@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.