(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
    $ 9,500.00
    $ 25.00
    Playfield - Decals
    Flashinstinct
    $ 9,099.00
    Pinball Machine
    Operation Pinball
    $ 159.99
    Lighting - Other
    Lighted Pinball Mods
    $ 7,299.00
    Pinball Machine
    Classic Game Rooms
    $ 35.00
    Playfield - Toys/Add-ons
    3D MODS
    $ 99.99
    Playfield - Toys/Add-ons
    Lighted Pinball Mods
    $ 69.00
    Playfield - Toys/Add-ons
    The MOD Couple
    $ 5,799.00
    Pinball Machine
    Nitro Pinball Shop
    $ 64.99
    Playfield - Toys/Add-ons
    Lermods
    $ 25.00
    Boards
    German-Pinball-Modular
    $ 14.95
    $ 60.00
    Playfield - Plastics
    Vandelay Industries
    $ 10.95
    From: $ 6.00
    Playfield - Protection
    Pin Monk
    $ 79.99
    Cabinet - Armor And Blades
    PinGraffix Pinside Shop
    $ 200.00
    Lighting - Interactive
    Professor Pinball
    $ 44.00
    Playfield - Toys/Add-ons
    Lermods
    $ 86.95
    Cabinet - Shooter Rods
    Super Skill Shot Shop
    $ 89.99
    $ 199.00
    Cabinet - Toppers
    Id Rather Play Pinball
    From: $ 5,799.00
    Pinball Machine
    Music City Pinball
    $ 139.00
    Playfield - Toys/Add-ons
    Sparky Pinball

    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