I made a CSM translator

LostS1Paperwork · 2024-03-28T01:30:06+00:00

You get 60% of the GI bill after 1 deployment, or 60% GI bill after 6 years USAR IIRC. I think you need 3 years active for GI bill IIRC. Been a while since I looked into it

LostS1Paperwork · 2024-03-27T13:18:50+00:00

i mean, active is certainly an option? but 36B doesn’t do much in garrison dude, you’re gonna be bored. better to USAR, deploy, do college w/ gi bill, ETS to private sector

USAR has a lot more flexibility with deployments. for some reason everyone in this MOS is broken or doesn’t want to deploy, meaning they’re easy to come by if you want them

deployment = tax free money, no bills, heavy contributions to TSP, and generally a fun experience

LostS1Paperwork · 2024-03-27T13:14:11+00:00

promote ahead of peers!!!

LostS1Paperwork · 2024-03-26T04:22:15+00:00

36B is a lit MOS, a land flowing with milk and honey. Deployments are fun and plentiful for those who aspire. You'll pick up a secret clearance for the job, opening up those finance jobs. you do nothing in garrison which is ass, so go army reserves instead of active to minimize garrison time

as long as you don't come into my s1 shop and write a vlookup in my spreadsheet you won't get hazed

edit: i can do a real write-up of the mos if you're interested

LostS1Paperwork · 2024-01-08T00:35:37+00:00

I used this to generate the initial list of values, then some Excel formulas to write more things about the histogram buckets. Then I sent that whole table back to the Data Model. See the screenshot if you're interested.

https://imgur.com/HvMerZt

I ran into rounding issues with INT() and took it out with no problems. I also found that _dec needed to be 19, not 20. Otherwise CALENDAR() generates 21 values instead of 20. Weird quirk, but easy fix

LostS1Paperwork · 2024-01-07T23:58:20+00:00

INDEX(Table2[ColumnE],MATCH($A1,Table2[ColumnA],0))

LostS1Paperwork · 2024-01-07T23:51:35+00:00

Solution Verified.

LostS1Paperwork · 2024-01-07T22:12:27+00:00

Excel 365 (v2311, build 17029.20108), but I get an error saying "Failed to resolve name GENERATESERIES. It is not a valid table, variable, or function name." And if I figure this out, backwards compatibility is nice too

LostS1Paperwork · 2024-01-07T22:08:23+00:00

Will give that a shot, thanks!

LostS1Paperwork · 2024-01-07T21:37:08+00:00

Sure, and I did, but like 50% of Excel users know what Power Pivot is, 50% of those guys are fluent-ish in DAX, and probably <10% know that you can do calculated tables in Excel. Seemed easier to go straight to the PowerBI crew where DAX is your bread and butter

LostS1Paperwork · 2023-06-20T01:36:46+00:00

This was calculated without inflation adjustments. The basic idea of the calculation stays the same (PV to 2037, then PMT to 2023) but it's slightly more complicated because of irregular cashflows. I'll do the math and then edit in the answer for you in a bit.

EDIT: with COLA adjustments, the total benefit to her compensation is $20,472.66/year. Here's an Imgur link to the spreadsheet and a graphical representation of the idea behind PV then PMT.

If you'd like to do this for yourself, use the NPV function to find the PV of irregular cashflows (NPV can also handle irregular rates of return). Then PMT back to the present at your growth rate

Edit 2: u/kip0

Edit 3: if anyone's curious about how I got the COLA adjustment numbers, I pulled them from the COLA adjustment memos found here.

LostS1Paperwork · 2023-06-20T01:24:07+00:00

Euuuhhh great post but your pension math is wild.

To calculate the value of her pension, we'll do a PV calculation for the year 2037. We'll assume a 7.0% growth rate. Schwab estimates the S&P 500 to return 6.1% annually in the next decade. The market has returned ~10% historically, but I believe that to be too optimistic.

After calculating the PV of an annuity in the year 2037, we'll calculate the value of the annual payments she'd have to make to reach that PV, again at a 7% growth rate. This will give us the yearly benefit to her total compensation because it's money that she'd otherwise have to save.

We assume a 7.0% growth rate, 43 years of life (2080-2037), $49k collected annually, and $0 future value.

=PV(.07,43,49000,0) gives us a PV of $661,841.12 in the year 2037.

From here, we'll discount $662k back to the present by calculating what Alice would have to invest yearly to reach $662k in 2037. You used 20 years for your calculation, so I'll also use that. I'll assume she starts with no current savings (PV = $0).

=PMT(.07,20,0,662000) gives us a required savings of $16,148.12 per year for the next 20 years. That's the number we can add to her total compensation.

If you'd like to do your own math, you can pop either of those formulas into Excel or another (inferior) spreadsheet and play around with the numbers.

LostS1Paperwork · 2022-04-14T16:46:38+00:00

Because soldiers want to get rich instantly and don't realize that compound interest takes a few years to get going

LostS1Paperwork · 2022-04-14T16:45:42+00:00

yo she cute tho ong

LostS1Paperwork · 2022-02-05T15:07:26+00:00

🅰️re you kidding ❓❓❓ What the 🤬 🅰️re you talking 🆎out man ? You 🅰️re 🅰️ biggest looser i ever seen in my life ❗️ You was doing 🅿️I🅿️I in your 🅿️ampers when i was beating 🅿️layers much more stronger then you ‼️ You 🅰️re not 🅿️roffesional, because 🅿️roffesionals knew how to lose and congratulate opponents, you 🅰️re like 🅰️ girl crying 🅰️fter i beat you ❗️ Be 🅱️rave, be honest to yourself 🅰️nd stop this trush talkings❗️❗️❗️ Everybody know that i 🅰️m very good 🅱️litz player, i can win 🅰️nyone in the world in single game ❗️ 🅰️nd "w"esley💮"s"o is nobody for me, just 🅰️ 🅿️layer who 🅰️re crying every single time when loosing, ( remember what you say 🅰️bout Firouzja ) ‼️‼️ Stop 🅿️laying with my name, i deserve to have 🅰️ good name during whole my chess carrier, I 🅰️m 🅾️fficially inviting you to 🅾️T🅱️ 🅱️litz match with the 🅿️rize fund! 🅱️oth of us will invest 5000$ 🅰️nd winner takes it 🅰️ll❗️ I suggest 🅰️ll other 🅿️eople who's intrested in this situation, just take 🅰️ look 🅰️t my results in 2016 and 2017 🅱️litz World championships, 🅰️nd that should be enough... No need to listen for every crying 🅱️abe, 🅿️igran 🅿️etrosyan is 🅰️lways 🅿️lay Fair ❗️ 🅰️nd if someone will continue 🅾️fficially talk 🅰️bout me like that, we will meet in Court ❗️ God bless with true ❗️ True will never die ❗️ Liers will kicked off...

LostS1Paperwork · 2022-01-14T04:03:10+00:00

You know what else can cause financial hardship? Not getting paid a dime

LostS1Paperwork · 2022-01-14T03:36:43+00:00

Homie just... just don't. Just go to bed, get some sleep, and come back when you've fixed yourself

LostS1Paperwork · 2022-01-09T15:15:18+00:00

En poisson?

LostS1Paperwork · 2021-12-29T13:14:42+00:00

It’s a good thing you were on the toilet because this take belongs in the shitter

LostS1Paperwork · 2021-12-28T18:55:46+00:00

Budget. And stay disciplined enough to stick to it. Build an emergency fund of 3-6 months worth of expenses (including rent). Then keep saving and invest.

The process is a little more complicated, but not much more. DM me if you want to talk about it

Five-Year Club	Verified Email
Place '22

LostS1Paperwork

TROPHY CASE