Thread:QuickNick/@comment-26829117-20170414231731

Nick, I have to admit I'm impressed with your use of PowerQuery to extract information from the Wiki and I've learnt a lot about it by just looking at what you've done. The PowerQuery editor is a pain but once you get used to its limitations it's easy enough to manage.

I've been meaning to create a spreadsheet that makes maintaining the Upgrades Strategy For 100% Completion and this will make that a lot easier.

One thing I haven't managed to work out is a way to automatically create the R$ Only upgrade level from the upgrades table you extract from the wiki. I have a few ideas but none of them are very elegant. Any suggestions/solutions would be gratefully received. Basically you need to find the first 0 R$ upgrade in each upgrade type, get the level and subtract one (unless 0).

Cheers, Dave. 