Useful Excel Documens I Made for URPG
Results 1 to 5 of 5

Thread: Useful Excel Documens I Made for URPG

  1. #1
    Du Edoc'sil Ash K.'s Avatar
    Join Date
    Apr 2010
    Gender
    Male
    Location
    Pallet Town, Kanto
    Posts
    2,913

    Default Useful Excel Documens I Made for URPG

    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.

    MOST RECENT VERSION (Updated here April 29, 2014 with the minor TM price changes from Pokémart modifications in February 2014, if you already filled out one for yourself either look up and change those TMs or download this one and copy column C into your filled out one): URPG EM Chart Blank v2.xlsx

    FOR FFA CALCULATOR DESCRIPTION, SEE POST 5. File is there, but I'll also put it here for convenience. FFA Calculator.xlsx
    Attached Files Attached Files
    Last edited by Ash K.; 29th April 2014 at 12:15 AM.
    In a relationship with KnittyDragon, been together over a year <3
    URPG Senior Referee, Approver, Chief (BW) Judge, Elite Four Member, Fortree City Gym Leader, Celestic Town Division Head, Kumquat Island Gym Leader
    AIM MewAlcadiesMew; PWN/PXR Ash K.
    Stats
    Wishlist
    [18:13] alaskapigeon1: and you have OCD that rivals monk's
    "When you can have anything you want by uttering a few words, the goal matters not, only the journey to it." -Rhunön the Elf (Eldest: Inheritance Book 2)

  2. #2

    Pumpkin Re: Spreadsheet to calculate EM Values/Prices

    Wow did you make this just now? Nice work!

  3. #3
    ._. Synthesis's Avatar
    Join Date
    Aug 2009
    Gender
    Male
    Location
    Ireland
    Posts
    8,369
    Blog Entries
    227

    Default Re: Spreadsheet to calculate EM Values/Prices

    Alphabetical and everything! Very snazzy

  4. #4
    Du Edoc'sil Ash K.'s Avatar
    Join Date
    Apr 2010
    Gender
    Male
    Location
    Pallet Town, Kanto
    Posts
    2,913

    Default Re: Spreadsheet to calculate EM Values/Prices

    Quote Originally Posted by Pidge View Post
    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.

    Quote Originally Posted by Synthesis View Post
    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.
    Last edited by Ash K.; 10th December 2013 at 05:40 AM.
    In a relationship with KnittyDragon, been together over a year <3
    URPG Senior Referee, Approver, Chief (BW) Judge, Elite Four Member, Fortree City Gym Leader, Celestic Town Division Head, Kumquat Island Gym Leader
    AIM MewAlcadiesMew; PWN/PXR Ash K.
    Stats
    Wishlist
    [18:13] alaskapigeon1: and you have OCD that rivals monk's
    "When you can have anything you want by uttering a few words, the goal matters not, only the journey to it." -Rhunön the Elf (Eldest: Inheritance Book 2)

  5. #5
    Du Edoc'sil Ash K.'s Avatar
    Join Date
    Apr 2010
    Gender
    Male
    Location
    Pallet Town, Kanto
    Posts
    2,913

    Default Re: Useful Excel Documens I Made for URPG

    Okay, so I made something for FFAs in Excel too, which I've heard at least one ref ( @Buzzer) express interest in. Here it is: FFA Calculator.xlsx

    Explanation of how it works, though it's mostly self explanatory:

    Pokémon | % HP | Notes (visible) | Modified Speed | Current HP | Max HP | Unmodified Speed | Speed Multiplier | Speed Divider | Notes (invisible) | Stats (copy this column)

    Pokémon: For the first column, enter whatever name you want to be displayed for the Pokémon.

    % HP: Don't touch this column, it's automatic.

    Notes (visible): Anything that you want to be displayed in stats besides name and HP. This would probably include things like Sub, Ref2, SpAtt+2, etc.

    Modified Speed: Don't touch this column, it's automatic. However, it is useful because you can highlight this column (excluding row 1) and have it sort it by speed. Currently the speed is not set to display in stats, but making it do so would be very simple.

    Current HP: Put the actual amount of HP the Pokémon has here. This is NOT a percent. Say the Pokémon has 354 max HP, uses Sub (88 HP), then takes a Hyper Voice that does 103 damage, then Roosts (177 HP). You can input (without quotes) "=354-88-103+177", adding the relevant term as it happens if doing so is easier, BUT TO DO SO YOU MUST START WITH AN =.

    Max HP: Put the Max HP of whatever Pokémon it is before initial stats. Unless your special rule involves evolving or something, you shouldn't have to change it again. It is initialized as 1 because the dividing by 0 error on % HP was annoying.

    Unmodified Speed: The Pokémon's natural speed in URPG. Again, shouldn't need to be changed after initializing other than evolution, mega evolution, or Transform.

    Speed Multiplier: If the Pokémon has speed rises, Tailwind, or some other similar effect, put it here.

    Speed Divider: If the Pokémon has speed drops, paralysis, or some other similar effect, put it here. This column was added because it was annoying with how it was trying to deal with repeating decimals created by using 2/3 or something. I don't remember exactly, it was a while ago.

    Chart for both Speed rises and drops, obviously in opposite columns (paralysis should be x4 to whatever is in divider and Tailwind/Swift Swim/Chlorophyll/Sand Rush/Unburden should be x2 to multiplier, Quick Feet x1.5, all compounded multiplicatively. If you put "=2*2*3 for something with Tailwind, weather speeding, and Speed+4, it should do it for you but I will cry for your inability to do that yourself):
    Speed±1: 1.5
    Speed±2: 2
    Speed±3: 2.5
    Speed±4: 3
    Speed±5: 3.5
    Speed±6: 4

    Notes (invisible): Anything you want to leave as a reminder for yourself but to have no effect on stats. Useful for abilities or anything else hidden.

    Stats (copy this column): When you have entered everything else and are ready to post stats, highlight as far down as your FFA goes, then simply do a copy/paste into the FFA chat. If you have additional effects like Trick Room or weather, you can replace the row below the last Pokémon with them.


    Should the unthinkable happen and an FFA exceeds the 30 people it is currently set up for, simply highlight the entire last row and drag the bottom right corner down as far as needed (copying all cells down as far as you drag, formulas will automatically update based on their new position). When the FFA is done, either do that with a blank row or simply close without saving.

    Some tricks I've come up with, but that maybe don't work for you: When something is KO'd, make the speed negative. Do it in such a way that when it is sorted, they will end up in the order they were KO'd. Remember that if a cell's text gets too big, you can double click the right side of the header row's box for that column to automatically resize based on largest entry, or click and drag to custom resize it.


    If anyone needs the .xls version for old Excel instead of the .xlsx version I put here for new Excel, let me know. I can't guarantee all features will work properly. Additionally, I'm looking to add more features at some point. I think if I had the current damage formula as used in URPG, I MIGHT be able to get it to do calculations. No promises there. And obviously if I did do that, I'd need to run a bunch of random tests to ensure that it does indeed produce the same result. It is possibly I could use the Pokémon database from Ball's calculator get it to automatically have base health, speed, and if calculations were added the other stats, but I may need to learn a bit more about how to get Excel to behave well for that. Anyways, go nuts FFA refs who feel like using it, let me know all feedback so I can rejoice in what is done right and fix what can be fixed. If you have any further questions about it, anyone who would be using it should easily be able to find me to ask. If you're just curious about it and haven't seen me around AIM or Skype, reply here or leave me a VM or contact me on AIM at MewAlcadiesMew. You can also find me from URPG's Skype chat.
    Attached Files Attached Files
    In a relationship with KnittyDragon, been together over a year <3
    URPG Senior Referee, Approver, Chief (BW) Judge, Elite Four Member, Fortree City Gym Leader, Celestic Town Division Head, Kumquat Island Gym Leader
    AIM MewAlcadiesMew; PWN/PXR Ash K.
    Stats
    Wishlist
    [18:13] alaskapigeon1: and you have OCD that rivals monk's
    "When you can have anything you want by uttering a few words, the goal matters not, only the journey to it." -Rhunön the Elf (Eldest: Inheritance Book 2)

Bookmarks

Posting Permissions

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