Crius Industry Tools for Google Drive - Update
I pushed some updates to the script this weekend. This should address some bugs with the getPOS() routine, as well as some features that @CCP_Nullarbor added to the Teams CREST feeds.
- Fixed issue with getPOS(): Was trying to fetch location names with the wrong function call. This issue has been resolved and all valid TQ corp keys should return good data now
- Fixed issue with getIndustryJobs(): Was not fetching personal jobs correctly. Changed key validation to be correct now. Can fetch corporate or personal jobs automatically off a single key/vcode
- Added teamName/activity to Teams and TeamsAuction feeds: Were "TODO" placeholders. Now reports in-game names and valid activity information
Go fetch a fresh copy from either source, and continue reporting bugs
I still need to clean up some errors and hanging bits. I'd like to push this tool to proper add-in status, but I am a little unclear on what to do between what I have now and what it takes to be considered "release ready". Also, probably time to bite the bullet and buy some icon/banner designs.
This one won't be as useful for the veteran 3rd party devs, but should be invaluable to the amateurs. I put together some SQL queries and the resultant CSVs into the github. If you're trying to update your spreadsheets with new data, these feeds should help you save a boatload of time. If you're not sure what to do with the CSV files, I suggest you read up on pivot tables.
I did a pretty long set of streams on Sunday. The goal was to help show off the spreadsheet fu and help people learn to build better spreadsheets with the tools at hand. I will have the raw streams up on YouTube and Twitch tonight, but I want to boil down the lesson plans into 5-15min function lessons. I still need to write up lesson plans and get my hands around video editing, but it's a goal for this August to put together a series that will help people build their own calculators.