Dragoons: A Rotation Reborn

[Ihm]

May I ask if you could add a Drop-Down menu to switch between a Pre-Turn 5 & Turn 5 gear set, instead of manually editing the 0-1s?

Not sure really how I could pull that off in excel. Would need to have a sheet for each then pull them together on a display sheet. Wouldn't really work particularly well, you'd be better off making two copies of the sheet honestly, unless someone knows a way I'm missing?

[Migosha]

Thanks for sharing Ihm.
I must do something wrong: I open your document under GoogleDoc. Some values are in error (writing #NAME in the cell) as I guess GoogleDoc doesn't use the same formulaes. I click on "File" and "Download as..." and ask for an xlsx format. Once opened under Excel I still have that error on some cells, all those related to food.
Do I do it wrong on the recovering method? Or is it that I downloaded it at the exact time you were modifying something on food?

Edit: I downloaded it again by rightclicking on it and asked "Download" and it works correctly now. I guess opening the doc and asking to get it in xslx wasn't the good way to get it.

[EasymodeX]

Not sure really how I could pull that off in excel. Would need to have a sheet for each then pull them together on a display sheet. Wouldn't really work particularly well, you'd be better off making two copies of the sheet honestly, unless someone knows a way I'm missing?

I haven't looked at the spreadsheet in question, but one possible option would be to use the restrictions as an override. E.g. you have a general selection pool, but that selection pool is overridden by preset filters. If the filter = pre-T5, then zero-out Boots of Maiming from the selection pool.


On a separate topic: general reminder to avoid too much discussion about the detailed functionality of individual parsers. Don't want the thread to get deleted and stuff.

[ziddyt]

Not sure really how I could pull that off in excel. Would need to have a sheet for each then pull them together on a display sheet. Wouldn't really work particularly well, you'd be better off making two copies of the sheet honestly, unless someone knows a way I'm missing?

there's a way to do drop-down menus in excel, but I'm not that good.
I did add an option to my spreadsheets to choose to exclude turn 5 drops though, if you wanna check em out

[Ihm]

Oh, to make a general drop-down in Excel, go to Data -> Data Validation. Allow: List. Check the "in-cell dropdown" option. In the source field type your options separated by commas: A,B,C,D or use the reference to select the options from elsewhere in the spreadsheet.

there's a way to do drop-down menus in excel, but I'm not that good.
I did add an option to my spreadsheets to choose to exclude turn 5 drops though, if you wanna check em out

I haven't looked at the spreadsheet in question, but one possible option would be to use the restrictions as an override. E.g. you have a general selection pool, but that selection pool is overridden by preset filters. If the filter = pre-T5, then zero-out Boots of Maiming from the selection pool.

I have multiple drop down lists on the sheets as well as the ability to exclude any drops you want.