IC Checklist

[Helvirahel]

I didn't see a good one in the threads, so I made one up to make it easier on myself. Thought I'd share it. It's in alphabetical order though, not the game order.

http://www.megaupload.com/?d=V31J9QI9

Just add an X to the crafted column once you've created it, and it will tally up how many you have left.

Edit: Forgot to mention, someone else typed up the list as a text document, I just turned it into a spreadsheet.

[whytebler000]

nice job, i was thinking of making one of these. However, there is a small error in the formulas on the first page.

for example: under completion percentage column you have the formula as =c2/b2, where it should be =(b2-c2)/b2.

that or you need to change the c column from "remaining" to "completed" and redo the formulas in that column.

personally its easier to just change the formula in the d column.

other than that looks good.

[jacaut]

heyyy its a wonderful list, but the problem is i dont have word/excel any chance there is a wordpad list floating around, where i can just delete the item as i go? would be awesome kthnxbai

[whytebler000]

Originally Posted by jacaut

heyyy its a wonderful list, but the problem is i dont have word/excel any chance there is a wordpad list floating around, where i can just delete the item as i go? would be awesome kthnxbai

copy paste the list into whatever program.

or find an alternative method of acquiring office

[boshans]

use open office...best program besides microsoft office. openoffice.org i believe it is.

[Helvirahel]

Originally Posted by whytebler000

nice job, i was thinking of making one of these. However, there is a small error in the formulas on the first page.

for example: under completion percentage column you have the formula as =c2/b2, where it should be =(b2-c2)/b2.

that or you need to change the c column from "remaining" to "completed" and redo the formulas in that column.

personally its easier to just change the formula in the d column.

other than that looks good.

Whoops, lol. I uploaded it before I fixed it I guess. On the copy on my computer all that information is right. Sorry guys, my bad.

Edit: Uploaded the fixed version, also as an .xls instead of an .xlsx. Should make it compatible with older versions of excel than the one I have.