Very useful. Took me a bit to realize that this isn't a mod, but simply a spreadsheet; but once I figured that out, it took less than 10 minutes to unlock those 3 pesky challenges.
Wow thank you so much ! I can'ty believe how easy that was to just drag the sheet into google sheet and let it do the calculation for me.. You sir helped so many people !
This is the single greatest thing of all time. to say it was helpful would be an understatement. Fr some of the stupidest achievements in any game I've ever played, thank you so much bro.
I'm glad you found it useful. It was a bit annoying doing this the first time with trial and error, so I had hoped to prevent others from getting a stroke.
It gives you the exact amounts you need to sell of each ammo to get to your goal value by highlighted row, depending on your current in-game LEI.
Ex. If you have exactly 700 LEI in your inventory and you're trying to get 777 challenge done, the sheet should tell you how much of each ammo to sell which is 11 AR ammo to get to exactly 777.
***Just a quick ramble to clarify a few things*** This only calculates within 10,000 Lei less than the desired goal. Meaning if you were trying to go for 54321, the minimum LEI for this to work would need to be 44321. So the player should either subtract or add enough LEI in game between 54321-44321, then the solver will be able to calculate the rest. This means the player could sell or buy random things to get to that range, then the solver will take care of the smaller harder to organically manage values to get to the goal amount.
If in-game lei is too close, the solver won't work as well because like you mentioned, we only have a few variables we can use, specifically 15 and 7, and 200. So it needs to be adjusted in this case before using the solver as well, but if LEI is not lower than 10,000 and not overly close to desired LEI amount, it gives the solver enough numerical lee way to test out combinations.
The reason for this is ammo is easily acquired thus provides a static reference point, but being too far away from the goal value would require other variables I can't possibly know since I would need to take into account player stock of every which item, the duke's stock and what have you. So it'll take a little involvement from the player, but it sure as hell beats trial and error.
You can save it anywhere. Just open it with winrar or windows default zip opener, should just be a double click. Double click again on the file and enter your current LEI and goal LEI from the drop down menu.
14 comments
Since the smallest amount you can sell is 15, if you're going for lucky7 the only way to get there is if your lei ends in 2, 5 or 7.
Likewise with the 54,321 and 52,911 it'd need to end in 1 or 6
Ex. If you have exactly 700 LEI in your inventory and you're trying to get 777 challenge done, the sheet should tell you how much of each ammo to sell which is 11 AR ammo to get to exactly 777.
***Just a quick ramble to clarify a few things***
This only calculates within 10,000 Lei less than the desired goal. Meaning if you were trying to go for 54321, the minimum LEI for this to work would need to be 44321. So the player should either subtract or add enough LEI in game between 54321-44321, then the solver will be able to calculate the rest. This means the player could sell or buy random things to get to that range, then the solver will take care of the smaller harder to organically manage values to get to the goal amount.
If in-game lei is too close, the solver won't work as well because like you mentioned, we only have a few variables we can use, specifically 15 and 7, and 200. So it needs to be adjusted in this case before using the solver as well, but if LEI is not lower than 10,000 and not overly close to desired LEI amount, it gives the solver enough numerical lee way to test out combinations.
The reason for this is ammo is easily acquired thus provides a static reference point, but being too far away from the goal value would require other variables I can't possibly know since I would need to take into account player stock of every which item, the duke's stock and what have you. So it'll take a little involvement from the player, but it sure as hell beats trial and error.