Coder & Updater: bbenejc [2313341]
Designer & Marketer: Thorgrun [2238577]
Hello everyone.
I would like to introduce a special project that me and a good friend, bbenejc have collaborated on. Faction Chains API! This handy new tool is an automatic tracker tool for all things chain related within your faction.
This project originated nearly a year ago, as Chain Leader of my little family and having memory issues I tend to use spreadsheets to track most info, These sheets were 100% manually updated until a special someone came to my rescue just a few months ago! (yes.. that's untold hours of work.. pay it no mind lol)
Acknowledgements
I want to give a huge thank you to my Project Partner, who literally handles all the data and code work. bbenejc is hugely responsible for making any of this happen, and also, he puts up with a lot of my random fickle ideas.
Id also like to thank TWOace and ersu, who helped me with the building of these sheets way back when i was manually doing things. Helping with my ideas and who helped teach me so much about using sheets.
Without you 3 i'd still be a young Padawan trying to find my way in this sheet life! xD
Now, Onto What These Sheets Offer:
New Chain! Screenshot
Generated Report Screenshot
This is a sample of one of our chains. As you can see its a fair bit of info (nothing too private IMO), feel free to hide columns to condense, or ask us for customizations. Xanax costs are what we pay, you can adjust this yourself.
In the below example dgumfs bonuses were manually added. Keep in mind, it calculates the highest bonus received. If they get higher bonuses in the future it will overwrite the data you manually added. Worry free!
Bonus Hit Tracker Screenshot
Xanax Tracker Screenshot
Both of these sheets are typically hidden, but because they look alike, and wanted to show them to you, i put them side by side. The info is then relayed to whichever chain the dates correlate to, and displayed as a number in the proper columns.
**1 API key can be a bit slow when fetching attacks, these sheets have been coded to loop multiple API keys, should you decide you want the reports to generate faster, you will need volunteers amongst your faction to give you their API key. All keys MUST be logged in the script editor along with their in game name beside it**
I notice throughout Torn, basic tools and spreadsheets are often shared free, given to the community. However this has taken a lot of time and work, and testing, that we both feel a one time fee would be worth while, not only to help us, but to show you that it is a great resource, we also offer more:
Price may change depending on demand.
There is now a short video, in real time showing you how the whole thing works once its setup. :)
There is no audio, but its pretty straight forward, and very simple, anyone could do it, even if you don't know sheets too well.
Video Here
Drop me or bbenejc [2313341] a message if you are interested! Post here or:
There is now a Discord Server for our Project. If anyone is interested, this is public and we welcome all feedback/questions/concerns.
Plus it helps that we get notifications when/if people ask questions lol :D
Discord Link
Designer & Marketer: Thorgrun [2238577]
Hello everyone.
I would like to introduce a special project that me and a good friend, bbenejc have collaborated on. Faction Chains API! This handy new tool is an automatic tracker tool for all things chain related within your faction.
This project originated nearly a year ago, as Chain Leader of my little family and having memory issues I tend to use spreadsheets to track most info, These sheets were 100% manually updated until a special someone came to my rescue just a few months ago! (yes.. that's untold hours of work.. pay it no mind lol)
Acknowledgements
I want to give a huge thank you to my Project Partner, who literally handles all the data and code work. bbenejc is hugely responsible for making any of this happen, and also, he puts up with a lot of my random fickle ideas.
Id also like to thank TWOace and ersu, who helped me with the building of these sheets way back when i was manually doing things. Helping with my ideas and who helped teach me so much about using sheets.
Without you 3 i'd still be a young Padawan trying to find my way in this sheet life! xD
Now, Onto What These Sheets Offer:
- Chain Reports – Easy to build, simply duplicate the “New Chain!” sheet, rename it (the date of the chain you want generated) and press the Update button. Done. Just like that. :) Even if you do it wrong, there are notifications coded in, to tell you what you did wrong and how to fix it.
Here is a screenshot of the New Chain! sheet. OD Tracker sheet displays any info in the OD column, its an ongoing thing on this sheet up to date. But when you duplicate it, name it whichever date of chain you want to generate, the code will only display info for that chain and during that chain timeframe. (For the Xanax and OD tracker, info 36 hours before the chain, and up to the end of the chain CD period, is included in the full report. To account for the stacking period, and any hits made by late arrivals on chain CD.)
New Chain! Screenshot
Generated Report Screenshot
This is a sample of one of our chains. As you can see its a fair bit of info (nothing too private IMO), feel free to hide columns to condense, or ask us for customizations. Xanax costs are what we pay, you can adjust this yourself.
- Bonus Hit Tracker –trying to give bonuses fairly to all for the merits? Well, this page tracks it all for you, you don't have to do anything at all. Pulling all info from a data sheet where all bonus hits are logged per chain, the data is presented neatly for you to view. The little red field you manually update yourself. :)
In the below example dgumfs bonuses were manually added. Keep in mind, it calculates the highest bonus received. If they get higher bonuses in the future it will overwrite the data you manually added. Worry free!
Bonus Hit Tracker Screenshot
- Participation Calc– again, fully automatic, pulling all info from Data_Chains (Hidden) as well as the generated chain reports and displaying it with ease, this sheet will calculate the participation levels of every member based on hits done per chain, comes with a custom filter, view by date, or by days in faction. Even Includes watch hours!
As you can see, these sheets are all tailored to my liking and for our faction, but of course, when you input your own API key it will key to your factions information.
- Xanax Tracker – Pulling all armory logs for “xanax taken” all info is logged in a hidden sheet, and displayed through each chain report based on the time frame of that chain. Tested 100% accurate.
- OD Tracker – Same with xanax, this sheet tracks all OD's from faction challenges, and if any happen during a chain or the timeframe of a chain, automatically logs that info on said chain report.
Xanax Tracker Screenshot
Both of these sheets are typically hidden, but because they look alike, and wanted to show them to you, i put them side by side. The info is then relayed to whichever chain the dates correlate to, and displayed as a number in the proper columns.
- Chain Summary - Similar to the way Yata stores chains, however this provides more information. Unlike Yata, this information is never delated later on. Screenshot below of the blank distributable copy, info automatically logs here after chains have been generated.
**1 API key can be a bit slow when fetching attacks, these sheets have been coded to loop multiple API keys, should you decide you want the reports to generate faster, you will need volunteers amongst your faction to give you their API key. All keys MUST be logged in the script editor along with their in game name beside it**
I notice throughout Torn, basic tools and spreadsheets are often shared free, given to the community. However this has taken a lot of time and work, and testing, that we both feel a one time fee would be worth while, not only to help us, but to show you that it is a great resource, we also offer more:
- Anyone who pays this one time fee, will get their own copy of these sheets, thats right, you are buying the product, not just the right to use it. (Obviously i don't want you having my faction sheets, and you don't want us having yours :P) We have created a blank sheet, just copy it (close the one you copied), open the new copy, click Tools – script Editor, and input your API key in the script editor, then save it!!! lol and now you can start generating old/new reports, the rest will update on its own according to the data you generate.
- If you want any design customizations done, or any additional info added to the reports? Just let us know.
- We also provide updates (because i'm fickle, and things are constantly added... sorry bbenejc) We will track all updates going forward here in this thread, if you decide you want those updates added, PM us. We will sort it out.
- If you break the code, send us a PM, we will fix it for you.
- Comes with a Chain Watch sheet, those hidden columns are Days 4 and 5. (Customizable depending on what you want) This sheet is not automatic. Just helpful.
- And of course, the sheet will come with a FAQs offering instructions and some basic explanations.
Price may change depending on demand.
There is now a short video, in real time showing you how the whole thing works once its setup. :)
There is no audio, but its pretty straight forward, and very simple, anyone could do it, even if you don't know sheets too well.
Video Here
Drop me or bbenejc [2313341] a message if you are interested! Post here or:
There is now a Discord Server for our Project. If anyone is interested, this is public and we welcome all feedback/questions/concerns.
Plus it helps that we get notifications when/if people ask questions lol :D
Discord Link
Mentions: Thorgrun [2238577]