Work in Progress: TF Toy Spreadsheet (all inclusive)
Posted: Fri Jul 13, 2007 10:52 amProbably more to come...
Rule #1: To get the excel sheet, PM me with your email address.
I am currently developing (that makes it sound more important than it is…) an Excel Spreadsheet in order to keep track of my collection, purchases, pay-outs, worth, and degree of completeness.
Already, the thing is getting pretty sizable. Completed listings are available for Armada through Titanium.
G1, G2, and Beast Wars are yet to be chronicled due to their size.
I know many of you have asked for a copy of this listing and I will provide it to anyone who wants it at this point, however, it is not complete yet.
What you can do to help:
1. I need lists of G1, G2, and Beast Wars. This ideally should be done in a spreadsheet, alphabetized, and spellchecked, proofed, etc.
2. Provide me with specifics about a given line’s size classes and price points. Currently, I am using a generic model, Basic, Deluxee, Voyager, Ultra, Mega Supreme. This does not hold true for all lines, but is a good approximation.
How does this work?
Part 1:
First off, the basic element of this spreadsheet is the class description. Enter that, and the sheet gives you the MSRP in another column.
The formula is a simple ‘IF’ statement:
=IF(B2="Basic",7,IF(B2="Deluxe",10,IF(B2="Voyager",20,IF(B2="Ultra",26,IF(B2="Mega",40,IF(B2="Supreme",50,0))))))
To revise this, simply replace a category word, like “Basic”, with something else, like “Micro”. You change the price point by altering the number directly after the category word. For instance, change:
=IF(B2="Basic",7,… to =IF(B2="Basic",10,
and you alter the price point of the Basic class to 10 dollars.
Do your alterations to Cell D2 and then copy it to the rest of the D column.
Part 2:
Columns E & F will be set to automatically fill in once the price point is established. They will copy the value you give them in the MSRP column.
THEN, if you happened to pay more or less for a toy than the MSRP, revise it in the ‘Paid’ column.
The ‘Current Worth’ column is there so you can track you collection’s value. Know that your Alt. Swerve is selling for $60 on eBay? Up the price in this column by simply overwriting the base formula (type your number in over it).
Part 3: Value Calculations
The formulas in the columns ‘I’ and ‘J’ will calculate your expenditures.
NOTE: Calculations will be incorrect if you do not erase the values in the Paid and Current Worth Columns for toys you do not own.
MSRP Total figures the cost of an entire series.
Total Spent calculates what you have paid out.
Secondary Worth figures the value your collection has to other people based on your input.
Saved off MSRP is a figure for you bargain shoppers to judge how well you are doing.
Net Increase in Value relates what kind of profit margin you might be looking at in selling.
Now again, this isn't done, it's not complete, it's just to help everyone out. So, no complaining.
If you have suggestions or ways to improve or things to add, feel free to share.
Rule #1: To get the excel sheet, PM me with your email address.
I am currently developing (that makes it sound more important than it is…) an Excel Spreadsheet in order to keep track of my collection, purchases, pay-outs, worth, and degree of completeness.
Already, the thing is getting pretty sizable. Completed listings are available for Armada through Titanium.
G1, G2, and Beast Wars are yet to be chronicled due to their size.
I know many of you have asked for a copy of this listing and I will provide it to anyone who wants it at this point, however, it is not complete yet.
What you can do to help:
1. I need lists of G1, G2, and Beast Wars. This ideally should be done in a spreadsheet, alphabetized, and spellchecked, proofed, etc.
2. Provide me with specifics about a given line’s size classes and price points. Currently, I am using a generic model, Basic, Deluxee, Voyager, Ultra, Mega Supreme. This does not hold true for all lines, but is a good approximation.
How does this work?
Part 1:
First off, the basic element of this spreadsheet is the class description. Enter that, and the sheet gives you the MSRP in another column.
The formula is a simple ‘IF’ statement:
=IF(B2="Basic",7,IF(B2="Deluxe",10,IF(B2="Voyager",20,IF(B2="Ultra",26,IF(B2="Mega",40,IF(B2="Supreme",50,0))))))
To revise this, simply replace a category word, like “Basic”, with something else, like “Micro”. You change the price point by altering the number directly after the category word. For instance, change:
=IF(B2="Basic",7,… to =IF(B2="Basic",10,
and you alter the price point of the Basic class to 10 dollars.
Do your alterations to Cell D2 and then copy it to the rest of the D column.
Part 2:
Columns E & F will be set to automatically fill in once the price point is established. They will copy the value you give them in the MSRP column.
THEN, if you happened to pay more or less for a toy than the MSRP, revise it in the ‘Paid’ column.
The ‘Current Worth’ column is there so you can track you collection’s value. Know that your Alt. Swerve is selling for $60 on eBay? Up the price in this column by simply overwriting the base formula (type your number in over it).
Part 3: Value Calculations
The formulas in the columns ‘I’ and ‘J’ will calculate your expenditures.
NOTE: Calculations will be incorrect if you do not erase the values in the Paid and Current Worth Columns for toys you do not own.
MSRP Total figures the cost of an entire series.
Total Spent calculates what you have paid out.
Secondary Worth figures the value your collection has to other people based on your input.
Saved off MSRP is a figure for you bargain shoppers to judge how well you are doing.
Net Increase in Value relates what kind of profit margin you might be looking at in selling.
Now again, this isn't done, it's not complete, it's just to help everyone out. So, no complaining.
If you have suggestions or ways to improve or things to add, feel free to share.
That's a lot of work you got yourself there!
