1. ## Spreadsheet to calculate EM Values/Prices

URPG EM Chart.xlsx | URPG EM Chart.xlsx

I made this spreadsheet for tracking EM prices and values. It's laid out in this format:

TM# | TM Name | TM Price | Quantity (enter a value here) | Total price of that many

At the bottom there's a row that has total price of all TMs (doesn't include BM/MT/SM) (\$621,500), followed by the number of EMs you input, and then the total price of those EMs. The row above that allows for BM/MT/SMs to be added. The first one on the left is sorted by TM#, the second one on the right is sorted alphabetically. I made these entirely myself based on a suggestion by Pidge. Enjoy! The TM prices were manually entered, so if you spot an error please let me know. I had Excel and the Pokémart open side by side. These are .xlsx files.

2. ## Re: Spreadsheet to calculate EM Values/Prices

Wow did you make this just now? Nice work!

3. ## Re: Spreadsheet to calculate EM Values/Prices

Alphabetical and everything! Very snazzy

4. ## Re: Spreadsheet to calculate EM Values/Prices

Originally Posted by Pidge
Wow did you make this just now? Nice work!
Making that was easy. Excel can do a lot if you know how to use it. The hard part was that after that I decided to expand it and add every single Pokémon I own into it. I can post that if people want to see what that looks like and I can make a blank version of that one (aka make a copy and remove all my Pokémon from the copy) if people want that.

Originally Posted by Synthesis
Alphabetical and everything! Very snazzy
Also, thanks both of you :)

EDIT: Here's mine: URPG EM Chart.xlsx

And here's the blank one: URPG EM Chart Blank.xlsx

........................................ | Pokémon | Pokémon | Pokémon | Pokémon...................
TM# | TM Name | TM Price | 1 if have | 1 if have | 1 if have | 1 if have................... | Total price of that TM | Total number of that TM
...
...
...
| BM/MT/SM | 5000 | # BM/MT/SM | #BM/MT/SM | #BM/MT/SM | #BM/MT/SM..... | Total price of BM/MT/SMs | Total number of BM/MT/SMs
Total# | | | #EMs on Poké1 | #EMs on Poké2 | #EMs on Poké3.................. Total price of everything | Total number of everything
Total\$ | | | Price of Poké1 | Price of Poké2 | Price of Poké3............................................................................

Sorry if that explanation is confusing. IM me with questions.

It SHOULDN'T explode if you expand it by highlighting the whole right two columns (CX and CY) and copying them over further, then deleting the original two columns. There's about 100 spaces right now.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•