The Energon Pub

Probably 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.

That's a lot of work you got yourself there!
I'de like to help, but am useless, it would take me forever to understand it perfectly and I live in Germany mening that I lose out on a lot and have to pay oferpriced for my stuff.

As for improvement, how about a formula that calculates the value increas of a figure, it would tell howmuch it gathers overall in worth?

Mening it would give you an idea how much it might be worth at the mo.
Ore sis you add tat oredy and I just didn't understand it?

Dead Metal wrote:As for improvement, how about a formula that calculates the value increas of a figure, it would tell howmuch it gathers overall in worth?

Not really possible. The market is too changing and varied by what is popular. A working knowlege of eBay is really necessary to discern the current values.

Mening it would give you an idea how much it might be worth at the mo.
Ore sis you add tat oredy and I just didn't understand it?

The capacity is easily there. It will just take individual effort to do it.

The sheet is easy to use and if you have questions, I can help. Did you want a copy?

If it's easy to use, it would be quite intresting but my coletion is very smal and not realy woth selling.
You want money for it?
As for the formula, I made one that shows how much Amasing Fantasy #15 has gathered on average each year, it dosn't show the real price but just shows with how much chash you cant count on. You want it?
Yea it's real simple basic math!

Dead Metal wrote:If it's easy to use, it would be quite intresting but my coletion is very smal and not realy woth selling.
You want money for it?

Absolutely not.

It's a public service, a mitzvah even.

Counterpunch wrote:

Dead Metal wrote:If it's easy to use, it would be quite intresting but my coletion is very smal and not realy woth selling.
You want money for it?

Absolutely not.

It's a public service, a mitzvah even.

Wow that much work and you want nothing for it?
Damn you are the inbodyment of genorsity!
OK I'll give it a try

OK let's get this back up!