(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

    #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

    1 month later
    #2 2 years ago

    Hi JasonJoe,

    did you make any progress with your spreadsheet and API? I am not an expert; but I know a bit about Excel and APIs... so if you need help, I can try .
    thanks

    BenJN

    Promoted items from the Pinside Marketplace
    From: $ 79.95
    Playfield - Other
    Hookedonpinball.com
    $ 6,995.00
    Pinball Machine
    Gulf Coast Pinball, LLC
    $ 62.00
    Playfield - Toys/Add-ons
    The MOD Couple
    $ 9.95
    Apparel - Unisex
    Pinball Wheezer
    From: $ 110.00
    Playfield - Toys/Add-ons
    Lermods
    $ 16.00
    Cabinet - Sound/Speakers
    ModFather Pinball Mods
    From: $ 155.00
    $ 15.00
    Playfield - Decals
    Iron Monger Decal Out of stock
    Flashinstinct
    $ 12.00
    Electronics
    Yorktown Arcade Supply
    $ 8.95
    $ 25.00
    Cabinet - Other
    Filament Printing
    $ 9.99
    Eproms
    Matt's Basement Arcade
    From: $ 9.99
    Eproms
    Matt's Basement Arcade
    $ 9.99
    Eproms
    Matt's Basement Arcade
    $ 18.95
    $ 235.00
    Boards
    RS Technologies
    $ 38.00
    Playfield - Toys/Add-ons
    ModFather Pinball Mods
    $ 74.00
    Cabinet - Armor And Blades
    Id Rather Play Pinball
    $ 225.00
    Cabinet - (Alt) Translites
    FlyLand Designs
    $ 75.00
    Playfield - Toys/Add-ons
    DBC Pinball
    $ 7,299.00
    Pinball Machine
    Classic Game Rooms
    $ 88.00
    $ 229.00
    Lighting - Led
    PinballBulbs
    From: $ 5,599.00
    Pinball Machine
    Music City Pinball

    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