[v7.1.3] Books+Gym, SEs, Flying, $, Halloween

Brilliant. Will add in the next version, which I believe is coming around soon(tm) due to the User Bars API return being changed, knocking Max Happy and Nerve out of their scripted locations.

Thanks!

Small update pushed for the API change to nestle Bars in a return. Can either download a new copy, or if you want to update yourself,

UserAPI.gs file:
Lines 15 and 16 need replaced with
  const happyBar = userData.bars.happy?.maximum || 0;
  const nerveBar = userData.bars.nerve?.maximum || 0;

Thanks again to Tuxington for fixing this while I've been slammed at work; Update to percentages for flying as well as a Dark Energy + Revitalize fix on the Halloween tab from Tezcatlipoca are forthcoming and will be taking the main sheet to [7.1] version

Nah, was updated to uncapped gains when the change dropped. Good to go

On the agenda! Schedule hasn't allowed much time for a bit, but my curiosity has been piqued and perhaps I'll find a way to make the time

Will come, just no timelines I can stick to at the moment

Are you using the most recent sheet in the first post of the thread, as well as a full access API key?

There was a stretch there where API changes hit back to back to back, that sounds like when the "bars" return got changed for either max happy or max nerve. Might need a fresh copy

7.1 Change Log

Sheet

• Pandas have invaded the sheet and can be spotted lurking in many places on different tabs. If one is found, please contact LouisCross [2881495] to negotiate return

Scripts

• Fixed issue with API return being changed for Days Flown data in UserAPI.gs
• Added in new Contraband items to both TornAPI.gs (Torn Item values & Sell to City values) & FlightMarketAPI.gs (Item Market values)
• Added Item Market query for Goose Juice into FlightRefresh

Gym

• Lightly rearranged to enable adding Totals for stats in Long Term Train Calculator subarea

Energy

• Added in "SEs Used Calc" at bottom of Energy tab to calculate your total stats & cost associated after using X number of SEs

Budget

• Added ROI Years as a sort option for ROI Auto-Sorted Ranking table

Flying

• Added in Contraband items area
• Created toggle to utilize Sell to City pricing on applicable items, which will highlight when toggled
• Added in Price Cut field at the top, which will cut off the manually entered % in cell H3 from both Torn Item Values as well as Market Values when calculating profit - will not impact Sell to City values
• Updated "Best" readouts at the top of the page for better indexing
• Fixed issue where "Best X for No E Loss" subareas would index(match()) to an empty cell reference in a merged area, outputting no Location
• Added Xanax to all four overseas locations available
• Adjusted Xanax Pricing subarea to enable either API or Manual pricing for all locations
• Added new Arrowhead Set, Fossil, and Meteorite into Points conversion income subarea
• Expanded 365d calculator to include Arrowheads, Fossil, Meteorite
• Increased readability of formulas by inserting line breaks
• Changed item costs to be adaptive in profit calculations for all listed items, running off YATA's last value posted
• Fixed cell reference for Market Price toggle looking at incorrect cell for Goose Juice

Scalp

• Fixed energy drink supply pack utilizing alcohol supply pack pricing for trend cell
• Added in Price Cut / Market Tax toggle
• Added in conditional formatting for top row $ values now that market tax can mean many items are a net loss to buy and relist at the second lowest value

Math

• Removed REF error for CBD when utilizing 5 Nerve as Cost Basis; Previously referenced Green Stout versus Moonshine for lowest cost, however Green Stout was removed as a call in 7.0

Will update pictures in thread soon, link in main post is now active for 7.1

Requests that didn't make the cut (apologies!):

• Add in different gyms for each stat on the Long Term Train Calc days trained area. Reason: would need too many arrays in the back end, and design space thanks to my lovely spouse's design work is at a premium on the Gym sheet. A nice request, but after investigating, out of scope for this sheet
• Add API sensing for Speed Shoes and Caymans' Rig job bonus. Reason: looking for API text when utilizing a pair of speed shoes, and time. Still interested in exploring this, hunting for the return if anyone is able

Thanks for your patience, reach out if you run into any errors or have any questions!