@JDubbz

20% + original price is already good enough, why is min maxing this so important, if you lose sight of what the game is really about? ripping off nerds and making sure they come back to do it again?

oh and to 4)
I basically have it round up and down to the nearest value and then check which of the rounded values returns a better profit depending on the input values.

Sorry for not keeping this updated the recent weeks, I"m on vacation rn.
Thanks for your thoughts on this. @The Watching Shadow
And yes, some functions just function differently or some dont even work at all comparing Excel, OpenOffice and Google Sheets, I just used google sheets for this one since its easier to share.

Oh phooey...somehow didn't realize I typed where instead of were in 5). I suppose I could just delete them all and repost with the correction since I can't edit any of these but... meh?

Odd posting this in reverse order of what I typed...but hopefully it reads OK this way?

1) Line 30 (markup of 40%) has Chance entered in as 15%. This matches what's in LoddZee's guide (been referencing that one a lot too), but I noticed your screenshot instead has Chance i that line as 30%. How come it's different in your screenshot?

2) Regarding the coding/equation issues mentioned below, it's because the XLOOKUP function is only in the very latest Microsoft Office (not available in Excel 2019 or earlier). I presume the errors are due to the function not existing in OpenOffice either (they seem to be based on older Office from what I recall?).

3) Due to 2), I've been tweaking a copy of the table to behave like what I think you intended, but using nested if functions instead. It gets...messy...doing it that way so I can see why you were using XLOOKUP (I wasn't aware that, VLOOKUP, or HLOOKUP even existed until now) instead. The nested if function is basically just checking if the max at the bottom (K39) matches a markup % in column C then state that corresponding Markup % (IF(K10=$K$39,C10, etc...). Used a similar nested if function to state the corresponding best price to sell.

4) I wasn't quite sure what you were doing with the ceiling/floor/xlookup nested lines but changed it to =(H5-(H5-ROUNDDOWN(H5,0)))+H2 instead where it's just subtracting off the change (the rounddown subtraction portion) and adding on whatever is input into the "round to the step of" line.

5) The columns hidden for the check if market price is less than 2 where....confusing. I gathered the first column was from the section in LoddZee's guide, but I'm honestly still trying to make sense of the forecast/linear interpolation (LERP function?) column. It seems like the profit column is using this area if the market value is exactly 2? Based on LoddZee's guide, I would have thought the main check would be used if the market price was 2 or more than 2?

Now I wish there was a master list somewhere of the general market values and avg cost for all the items so I don't have to pull up the game to check the values... xD I know one of LoddZee's guides has range of market prices, but I don't think I saw anything for the avg cost line. I wonder if these avg costs are fixed, or do they fluctuate daily too?

*ponders crunching numbers to compare against what is in dotalversager's guide for optimal pricing*

Been tinkering with your Excel file as the number crunching intrigued me. I had been setting prices to be rounded up to the nearest dollar. I hadn't thought about marking it up further since most of it seemed like a decent profit at that. Apparently my list was too long for one comment so I'm breaking it up into a few comments. It'll be in reverse order of sorts so my numbered list still reads top to bottom?

Thats sad but possible. thanks for reply