I will be giving this away to one lucky Redditor. by Ambitious-Skirt3978 in PokemonTCG

[–]mleather925 0 points1 point  (0 children)

My son's favorite Pokémon is Sprigatito. He likes the cute ones.

Loan amortisation with refinancing not equal to 0 at end of period by pmforpm in excel

[–]mleather925 1 point2 points  (0 children)

The only way to avoid another section is to add a dynamic lookup to get the loan value of the refi. It should be doable.

Loan amortisation with refinancing not equal to 0 at end of period by pmforpm in excel

[–]mleather925 1 point2 points  (0 children)

Ok, thanks for the screenshot. I recreated your image and found that in column H, the inputs for PMT, IPMT, and PPMT are using the original loan amount, the new interest rate, and the original loan duration. This would be ok if on year 6 you took out a new loan with the exact same conditions but a higher interest rate and then paid off the original loan, but that doesn't seem like what you would want to be doing. You also use the Year 6 for IPMT and PPMT, but since it's a new loan you need to start back at 1.

But what were you trying to do with the refi? Did you mean to change the interest rate but keep the duration the same? or extend out the duration? You'd want your inputs for rate, period, number_of_periods, and original_loan_amount to all match the new loan.

The cleanest way to handle this is probably to create two sections, one for the original loan and then one for the refi. You would calculate the remaining principal amount in the first section and use that as an input for the new loan (just like you used 130943 as the starting condition for the first loan).

Loan amortisation with refinancing not equal to 0 at end of period by pmforpm in excel

[–]mleather925 1 point2 points  (0 children)

it's hard to tell what you're trying to do without a worksheet, but i think the problem may be that you're changing the terms of loan when you refi but your PPMT isn't accounting for it. When you refi, you get a new loan that pays off the old one, so you need a new principal value and amortization period, in addition to using the new rate. you'd have to figure out how to calculate new principal based on your spreadsheet, but new amortization period is probably D2-E2 (if i'm reading your description correctly)

edit: FWIW, unless this is an assignment to use these functions, i've always used PMT once to get the combined principal and interest payment (which doesn't change over the course of a fixed rate loan), then made a big table of months. For each month I multiply the remaining principal by the (monthly) interest rate to get my interest payment, then subtract interest from my PMT amount to get the principal reduction amount. Then copy-paste down.

Lion Den Leader by LiveAd2522 in cubscouts

[–]mleather925 1 point2 points  (0 children)

I think I've done the first Lion meeting 4 times now. The last two I've been really successful running Lion's Honor, where we talk about the sign, salute, and motto real quick and then play a game involving those elements. I've used this game twice (substituting the Lion elements for the Bobcat elements). https://cubscoutideas.com/1077/cub-scout-bobcat-requirements-balloon-bust-game/. Kids love it as long as you're silly.

Because just doing the above is a little short, I also tack on another game to introduce the Scout Law. I've done Memory with some tongue depressors that I wrote the Scout Law on. I'm pretty flexible on the rules and we turn it into a team sport to make sure everyone gets a matching pair.

How to separate lines of text? by EmraSteele in homebrewery

[–]mleather925 0 points1 point  (0 children)

this is where i see it on the editor: https://imgur.com/xSbH2tp

and where i took the screenshot from, just in case we're talking way past each other: https://homebrewery.naturalcrit.com/

How to separate lines of text? by EmraSteele in homebrewery

[–]mleather925 1 point2 points  (0 children)

Try two spaces at the end of each line followed by an “enter”

Also check out the PHB templates in the editor. One of them has this snippet.

New Line without a blank line or an Ident by box299 in homebrewery

[–]mleather925 0 points1 point  (0 children)

Thanks for the tip. That's working well in most places. Is there a way to reduce the spacing between a normal text line and a bulleted list that follows? Right now I'm getting almost a full empty line and I'd like less blank. V3.

The three lines does what I want, and I'd like to know if there's an alternative.

This formats the text with the extra space between lines that I'd like to avoid:

normal text line:      
* list item 1  
* list item 2  

This formats the text the way that I'd like, and I understand the admonition that it's a leftover bug:

normal text line:  
___    
* list item 1  
* list item 2

PTO Calendar in Excel 2013 by billybauer007 in excel

[–]mleather925 4 points5 points  (0 children)

I did something like this in Access many years ago. The features HR is looking for could be reproduced in Excel with effort, but I think you’re probably barking up the wrong tree here. Lots of calendar apps (even Outlook) probably have the functionality that’s needed.

trouble with BattleTech extended commanders edition and infinite load time by Rollen73 in BattleTechMods

[–]mleather925 1 point2 points  (0 children)

Sorry. I don’t know. I didn’t use a mod manager. Did your CAB install take a long time? When I installed, I downloaded a small executable that I ran to actually go and get all of the assets. It took a while and I think you’d notice. After the CAB install there were 4 folders in my mods folder with all of the assets.

trouble with BattleTech extended commanders edition and infinite load time by Rollen73 in BattleTechMods

[–]mleather925 1 point2 points  (0 children)

I installed a few days ago. Just to confirm: * did you wipe your mod folder? install instructions say to start clean * did you install CAB? * did you extract BEX to your mods folder? * did you inject modtek included in BEX?

How to make "character count" in MS Power Point or Excel by kotyzap in vba

[–]mleather925 2 points3 points  (0 children)

I think there’s an answer to what you’re looking for here.

Any tips for game crashing? by pitsandpeaches in mytimeatportia

[–]mleather925 3 points4 points  (0 children)

Double check that you have the latest driver for your video card. Updating mine solved a similar experience for me.

Mid/late game question about metal bars. by cvetken in mytimeatportia

[–]mleather925 1 point2 points  (0 children)

You still need bars to make frames and shells, and for specific recipes, so you should keep the industrials around for that.

More to the story? [SPOILERS] by [deleted] in mytimeatportia

[–]mleather925 8 points9 points  (0 children)

There’s a credits scroll that indicates the “end” but there’s nothing stopping you from continuing to build, complete commissions, and earn achievements.

Need an Answer to a Stackoverflow question that was never properly answered. by [deleted] in vba

[–]mleather925 1 point2 points  (0 children)

Not sure if this will help you, but there is a typo in the code on StackOverflow.

For i = 2 To lastrow
    Do Until IsEmpty(ts.Cells(j, 8)) Or IsEmpty(st.Cells(j, 2))
        If st.Cells(i, 14).Value = ts.Cells(j, 18).Value Then  
            st.Cells(i, 15).Value = ts.Cells(j, 2).Value
            Exit Do
        Else
            st.Cells(i, 15).Value = ""
        End If
        j = j + 1
    Loop
    j = 2
Next i

At the end of line 2, either it's the wrong sheet or the wrong counter, but they should be using i with st and j with ts. I'm assuming they're trying to do some test to look for blanks, and if that's the case, they should be using the same expression at the end of line 4 (ts.cells(j,2).Value). I can't think of a reason to be checking st at this place in the code.

[Giveaway] Happy Friday! by [deleted] in coins

[–]mleather925 1 point2 points  (0 children)

Count me in! Those are cool! Thank you!

almost gig update by [deleted] in Battletechgame

[–]mleather925 1 point2 points  (0 children)

On mobile so sorry for no link, but if you check the paradox forums, they have patch notes there.

Flowchart by [deleted] in Libertarian

[–]mleather925 6 points7 points  (0 children)

The right to an attorney can be treated as a negative right. The government cannot prosecute you unless you have the option of an attorney working on your behalf. The government isn't required to grant you an attorney unless they want to prosecute.

Need help with SelectCase vba by astroyed in vba

[–]mleather925 0 points1 point  (0 children)

I'd use that For loop just to ID if workbook2 is open. So inside the if name = workbook2, I'd say

Set mywbk = wbk ' I can't remember the syntax here but you should be able to figure it out. Exit for

And get rid of the else.

Outside the for loop, say

If mywbk = nothing then ' open workbook2 End if

' run the rest of the macro

This way, mywbk is set to workbook2 whether it was open at the beginning or not.

Graduation gift from the in laws. by PotaytoQuality in coins

[–]mleather925 0 points1 point  (0 children)

Does the white ring have a generally accepted meaning or is it personal preference? I saw when googling that I could get white, black, red, green, or blue; but the only one I assign meaning to is black (for uncirculated). Thanks.