Starving Poet Posted May 25, 2013 Share Posted May 25, 2013 Hey guys! Some of you might remember me from WKC IE because of the large interactive spreadsheet that I made from Andromeda's original binding checklist. Well, with time running out, I decided that it was high time I got working on WKC 2 and, being the OCD freak that I am, I made a new interactive spreadsheet for WKC2. What makes this sheet different? Basically, how it works, you can track which binds you've made, which will keep track of the total materials you still need to gather and also track which materials you have and / or have not found. Note This sheet is at the maximum size and complexity limit that is allowed on Google Docs. 90% of all the calculations are done in cell C2 in the Collection List page. I HIGHLY recommend disabling that formula when you are updating any of the other sheets while you bind. You can disable the formula simply by deleting the '=' sign at the very beginning of the cell. When you want to see what items you still need, all you need to do is add the equal sign back to the beginning of that cell and it will populate that entire page. Enjoy! https://docs.google.com/spreadsheet/ccc?key=0AvZPij-OPAs_dHk5ekdOTUhJOEJOd0JjdHMwT2R0SXc&usp=sharing Link to comment Share on other sites More sharing options...
Metdevil Posted May 27, 2013 Share Posted May 27, 2013 Hey guys! Some of you might remember me from WKC IE because of the large interactive spreadsheet that I made from Andromeda's original binding checklist. Well, with time running out, I decided that it was high time I got working on WKC 2 and, being the OCD freak that I am, I made a new interactive spreadsheet for WKC2. What makes this sheet different? Basically, how it works, you can track which binds you've made, which will keep track of the total materials you still need to gather and also track which materials you have and / or have not found. Note This sheet is at the maximum size and complexity limit that is allowed on Google Docs. 90% of all the calculations are done in cell C2 in the Collection List page. I HIGHLY recommend disabling that formula when you are updating any of the other sheets while you bind. You can disable the formula simply by deleting the '=' sign at the very beginning of the cell. When you want to see what items you still need, all you need to do is add the equal sign back to the beginning of that cell and it will populate that entire page. Enjoy! https://docs.google.com/spreadsheet/ccc?key=0AvZPij-OPAs_dHk5ekdOTUhJOEJOd0JjdHMwT2R0SXc&usp=sharing Damn! That must have taken forever to make up! Nice, thanks heaps for this. Also, the page each item can be found on is a very nice touch Link to comment Share on other sites More sharing options...
Starving Poet Posted May 27, 2013 Author Share Posted May 27, 2013 Quite Welcome! I wish that I hadn't put this game off for so long. it was much less the soul-crushing endeavor that was WKC:IE. Link to comment Share on other sites More sharing options...
Metdevil Posted May 27, 2013 Share Posted May 27, 2013 Agreed and with only 3 weeks left on it before the servers close, I only hope that I can get to GR26 and beat Vellgander. The rest, I should be able to do solo. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now