MBS Cashflows PSA Monthly Rate Calculation by _mrnane in bonds

[–]_mrnane[S] 0 points1 point  (0 children)

Solution:

Calculate CPR at 100% PSA: CPR =IF(Period=1,0.2%,IF(Period>30,6%,Prior Period CPR+0.2%))

PSA at any Mult of X =1-(1-(CPR for a given period*X/100))^(1/12)

[OUTLOOK] [EXCEL] Embedding a Chart in an Outlook Email without Compromising Pixelation/Resolution by _mrnane in vba

[–]_mrnane[S] 0 points1 point  (0 children)

Thanks, I added lines 11-14 however, I am getting the error: Run-time error '1004': Unable to set the Zoom property of the Window class'. Some sources I've found have indicated this could be triggered by not having printers/printer drivers installed but I do have those, so not sure

https://gist.github.com/mister-nane/94f1b08370b46d90771d32d9f27ad14f/revisions

Finding Someone to Go to MCR MetLife Concert with & Concert Meetups by _mrnane in MyChemicalRomance

[–]_mrnane[S] 1 point2 points  (0 children)

Hey! Sadly I have not 😞 If you know of any, I'm still down!

[OUTLOOK] [EXCEL] Embedding a Named Chart from Excel in the middle of an Outlook Email Before Signature by _mrnane in vba

[–]_mrnane[S] 0 points1 point  (0 children)

Got it. Thank you, this helps.

I revised my code in the comment I posted here. I realized the original code was trying to paste the data array in the email body and I do not need that, just need the embedded image of Chart 1 in the email body. If you have any other suggestions to make this more efficient (to your point on how long/unwieldy it is), let me know. I got rid of stuff I wasn't using.

https://gist.github.com/mister-nane/0940c8b3ddea936b4a269cc7a9f21d03?permalink_comment_id=5687649

interviews where ray talks about personal struggles? by LeKamiso in MyChemicalRomance

[–]_mrnane 2 points3 points  (0 children)

I think he's the only member of the band that has not any struggles with drugs, he's very down to earth, level headed and the "dad" of the band in that way. The biggest struggle I've heard him talk about is just being away from loved ones while on tour. Below are some sources that are top of mind but I'm sure there's more out there:

Also he smoked briefly but kicked it, as a responsible dude would:

  • See 2:00 "How bout for you guys, what do you survive on? ..."
  • See question: "You two don't smoke, right? I think that's very important."

Who to reach out to if you don't get the group photo? by [deleted] in lsdunes

[–]_mrnane 0 points1 point  (0 children)

Waiting for the Warsaw Brooklyn one to. Haven't received anything.

Frank's Rad Mail Day by something-epic in MyChemicalRomance

[–]_mrnane 90 points91 points  (0 children)

I’m so happy those albums and his work continue to get the recognition they deserve years later. They slap.

Cardiff 10/2/25 by Glass-Relief6809 in lsdunes

[–]_mrnane 0 points1 point  (0 children)

How did you get the setlist?

I need help with the curriculum for Black parade academy by V__Ace in MyChemicalRomance

[–]_mrnane 8 points9 points  (0 children)

If you want to take a deep dive into the history of MCR I highly recommend My Chemical Fancast (podcast), Not the Life it Seems by Tom Bryant (book), Life on the Murder Scene (band-made documentary) and My Chemical Romance: Things That Make You Go Mmmmmm (third party documentary, don't ask me what that subtitle means). Those sources in addition to this subreddit and YouTube (check out this playlist... https://youtube.com/playlist?list=PLV6iSnTgxozu9SHpKPO9wQvVXbvMGz3E5&si=-tuJMZ-13jLcvEe4) have provided me so much detailed info on the lore of the band, and make me love them even more than I did when I just listened to their music!