Profit and Margins Spreadsheet.

[Skipple_MLBTS]

Hi everyone. With showzone.io still in development, I figured I would create a google spreadsheet that calculates the value of flipping certain cards in TheShow.

https://docs.google.com/spreadsheets/d/1961cHWKQoYXGU0FQNQXEvJSiyp43uoWsh7YSbmZJz_A/

It connects directly into the API and automatically updates values every 5 minutes.

If there is enough interest I'll go ahead and create a sheet for equipment too.

Enjoy!

[Skipple_MLBTS]

OF COURSE... I still have issues with google telling me I am calling services too much... I thought this was fixed but the sheet starts throwing errors right after I post this and I can't call out to any APIs until tomorrow morning. I will attempt to have this fixed by then.

Should be back up and running now.

[Skipple_MLBTS]

... dup post

[Big_Daddy_Kaine_PSN]

Would absolutely love to have a tool like this. Appreciate you working on a project like this!

[squishiesgirl_PSN]

@skipple_mlbts said in Profit and Margins Spreadsheet.:

Hi everyone. With showzone.io still in development, I figured I would create a google spreadsheet that calculates the value of flipping certain cards in TheShow.

https://docs.google.com/spreadsheets/d/1961cHWKQoYXGU0FQNQXEvJSiyp43uoWsh7YSbmZJz_A/

It connects directly into the API and automatically updates values every 5 minutes.

If there is enough interest I'll go ahead and create a sheet for equipment too.

Enjoy!

Good job...but 5 minute updates..a lot can change in 5 minutes

[Skipple_MLBTS]

@squishiesgirl said in Profit and Margins Spreadsheet.:

@skipple_mlbts said in Profit and Margins Spreadsheet.:

Hi everyone. With showzone.io still in development, I figured I would create a google spreadsheet that calculates the value of flipping certain cards in TheShow.

https://docs.google.com/spreadsheets/d/1961cHWKQoYXGU0FQNQXEvJSiyp43uoWsh7YSbmZJz_A/

It connects directly into the API and automatically updates values every 5 minutes.

If there is enough interest I'll go ahead and create a sheet for equipment too.

Enjoy!

Good job...but 5 minute updates..a lot can change in 5 minutes

Unfortunately I'm limited with google's limitations on outside URL calls. They have a limit on 20k at day.

I have to call each page individually. 64 pages for all the cards.

64 pages x 12 calls an hour x 24 hours a day = 18,500 calls so I am right up against the limit with 5 minute intervals.