(Topic ID: 194834)

Excel Competition Tool using IFPA website API


By JasonJoe

2 years ago



Topic Stats

  • 2 posts
  • 2 Pinsiders participating
  • Latest reply 2 years ago by benjn
  • Topic is favorited by 1 Pinsider

You

Linked Games

No games have been linked to this topic.

    Topic Gallery

    There have been 6 images uploaded to this topic. (View topic image gallery).

    Flip Frenzy Alloc (resized).JPG
    Flip Frenzy Score 1 (resized).JPG
    Flip Frenzy Score Player WinPct (resized).JPG
    Flip Frenzy Score Player Games (resized).JPG
    Flip Frenzy Score Machin WinPct (resized).JPG
    Flip Frenzy Score Machin Games (resized).JPG

    You're currently viewing posts by Pinsider jasonjoe.
    Click here to go back to viewing the entire thread.

    #1 2 years ago

    I have created a spreadsheet to manage Flip Frenzy style pinball competitions but looking up & inputting player info (IFPA number, Player Name, Player Ranking & Player Rating) from the IFPA website is slow and prone to input errors.

    I have been experimenting with the API which looks like it will be very helpful but was wondering if anyone had done this already and could save me some trial and error time....

    Spreadsheet Basic Funtion :
    * Allocate the Machines at the start of the game
    Flip Frenzy Alloc (resized).JPG

    * Display a real time leader board
    Flip Frenzy Score 1 (resized).JPG

    * Post event Stats
    1) Number of games played per player per machine
    Flip Frenzy Score Machin Games (resized).JPG

    2) Win % player per machine
    Flip Frenzy Score Machin WinPct (resized).JPG

    3) Number of games played per player per opponent
    Flip Frenzy Score Player Games (resized).JPG

    4) Win % player per opponent
    Flip Frenzy Score Player WinPct (resized).JPG

    See the attached screenshots.

    Either way I hope to have the spread sheet finished soon and happy to share it with anyone interested in using it.

    JasonJoe

    Promoted items from the Pinside Marketplace
    $ 69.99
    Playfield - Toys/Add-ons
    Lighted Pinball Mods
    $ 27.99
    Lighting - Interactive
    Lee's Parts
    From: $ 11.95
    Playfield - Toys/Add-ons
    ULEKstore
    $ 79.95
    Cabinet - Shooter Rods
    Super Skill Shot Shop
    $ 75.00
    Playfield - Toys/Add-ons
    DBC Pinball
    $ 45.00
    Playfield - Plastics
    Vandelay Industries
    $ 69.00
    Cabinet - Armor And Blades
    Id Rather Play Pinball
    $ 18.00
    Playfield - Other
    Pin Monk
    $ 78.00
    Playfield - Toys/Add-ons
    ModFather Pinball Mods
    From: $ 9.99
    Eproms
    Matt's Basement Arcade
    $ 29.95
    Gameroom - Decorations
    Pinball Photos
    $ 229.99
    Lighting - Other
    Lighted Pinball Mods
    $ 40.00
    Gameroom - Decorations
    Arcade Arts
    $ 5,599.00
    Pinball Machine
    Operation Pinball
    $ 100.00
    $ 209.99
    $ 14.95
    Playfield - Toys/Add-ons
    ULEKstore
    $ 16.00
    Cabinet - Sound/Speakers
    ModFather Pinball Mods
    $ 25.00
    Displays
    Pappy's Pinball Palace
    $ 149.00
    From: $ 99.99
    Cabinet - Other
    Lighted Pinball Mods
    From: $ 42.00
    Cabinet - Shooter Rods
    ModFather Pinball Mods
    $ 90.00
    Lighting - Under Cabinet
    Rock Custom Pinball
    $ 38.00
    Cabinet - Sound/Speakers
    ModFather Pinball Mods

    You're currently viewing posts by Pinsider jasonjoe.
    Click here to go back to viewing the entire thread.

    Hey there! Got a moment?

    Great to see you're enjoying Pinside! Did you know Pinside is able to run thanks to donations from our visitors? Please donate to Pinside, support the site and get anext to your username to show for it! Donate to Pinside