I would like to introduce another special faction tool that bb and I have been working on. The Faction Database! This tool provides any and all info you need or will need related to your faction and its members. Unlike our other Project you do not need multiple API keys, the script is fast and accurate using just one key.
After setup the sheets will tune to your faction, this does require that you have "Faction API Access" privilege's/permissions. On average it takes 31 days for the graphs to show properly. We offer 1 day, 7 day and 31 day totals.
Using our faction as a test, we have provided screenshots without any redactions. . What These Sheets Offer:
Faction Report
Idea behind the faction report sheet is to give leaders a daily overview of the faction's activity. Data included on this sheet:
Faction’s respect growth and analysis
Faction’s assets (vault money, points and armory breakdown)
This sheet shows all of your members’ jobs, so you can quickly see who is in city jobs or who is unemployed. Or if you have people working in low rated companies. Also provides a list of directors.
Want to plan your OC’s and need to quickly see your member’s NNBs? This sheet organizes your members into groups of NNB for easier viewing and it also includes estimated CE (crime xp), calculated using the formula from tornstats. It is only an estimation, so treat it that way.
This sheet’s purpose is to help you plan your faction’s organized crimes. It will keep track of your individual teams’ success rates and a full summary of your crimes. You can update the OC data anytime you’d like by pressing the red “Update” button on top right. This will also recalculate the recommendations.
Like our chain sheets we put the script in a separate place, so we can offer updates and bug fixes without ever having access to your sheets. This means we do NOT have access to any of your information, we only own the scripts. With Torn constantly changing we can fix anything free of charge.
Here is a FAQs, detailing how to setup your Faction Database, and answering any other questions we think you may have. However if you have questions not on the FAQs feel free to Join our [Project] Discord server and ask there, or send us a PM.
We can even offer a 2 day free trial should you wish to try it before purchasing.
All of this for a 1 time fee of $300 million. Contact me to purchase or with any questions you may have. If the price is a bit high, we do accept monthly subscription's tailored to your income.
If you already own our chain sheets, we can offer these sheets to you for $250 million. Do you want both Projects? We can work something out of course. Do you want only some parts of each project? Let us know. we are quite flexible. Do you want your own faction logo instead of ours? Feel free to edit that yourself, or, send me a photo or your faction logo and i can do it for you. :)
This pissed me right off. You encourage people to be creative, and then you take away one of the only ways a player CAN be creative. I only ever changed the background color, that's a "security concern?" I call bullshit. I fail to see how even using images for a background would be a security concern.
I'd think people using illegal scripts was more important to tackle than people using colored backgrounds. Anyway thanks for ruining my profile sig.. :/
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, generate reports with the click of a button!
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.
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 and Min Hits/Member 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. :)
Unfortunately, it is unable to automatically track bonus hits made outside the faction. They can be added in manually, full instructions in the included FAQs. (not too difficult)
Participation Calc– again, fully automatic, pulling all info from Data_Chains (Hidden) 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.
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. 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)
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 and on our Discord server, all sheets code is connected, so updates automatically happen for everyone. (we cannot see your information, only the script code itself, the only info we log of yours is your name and faction name.
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. The FAQs is now mostly completed, feel free to check it out here at anytime and view extra screenshots and explanations.
All of this for a one time fee of 80 mil. Keep in mind this is a faction tool. :) And it requires a lot of work for us to maintain. Price may change depending on demand.
Should you decide to become a tester for us, we could work out a deal on the price.
Do you need more info before purchasing?
There is now a short video, in real time showing you how to generate an old chain report, and then remove the attack logs from it, to save on memory usage. (you dont have to do this, it is mostly for the really big chains, 5000+ attack logs) 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.
Post here and drop me a message if you are interested! 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
Still need more? Well we can set you up with a 2 hour free trial!
Edit: Generated Chain Reports Accuracy Proven
In this I will compare the differences between our generated chain reports, and Yata's reports. (A long time ago i noticed a consistent error... don't get me wrong, i use Yata for a lot of things, and share it with those who don't know of it, but our sheets are better for chains) I will prove it now.
Please note: It is not my intent to smear Yata or its creator, he and the services he made are amazing, so please do not take it that way, I'm simply proving to you how accurate our chain tools are, in comparison to someone else's. :)
In this example I will use one of our old chains 01/13/2020 a 1000 hit chain.
Raw Hits Data 1 ScreenshotFroze the row with the chain date so you could see its the same generated report as above.
Raw Hits Data 2 Screenshotand it logs ALL hits during that chain, doesn't matter what kind of hit. After logging official chain hits, it stores all Cooldown hits.
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.)
The only parts that require manual editing are chain Watch, and any notes you may wish to add in the Note column yourself. Otherwise the code updates notes with “Participated” or “Did Not Participate” based on the “Min Hits/Member” range, which you can adjust to your factions expectations. Below those who didn't participate will be listed and you can decide who you'd like to kick.
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. :)
Unfortunately, it is unable to automatically track bonus hits made outside the faction. They can be added in manually on the Data_Bonuses hidden sheet. Unhide the sheet, insert column under row 6 and input the data yourself. You'll know it worked if it shows up on the Bonus Tracker. :) 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!
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.
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.
All of this for a one time fee of 80 mil. Keep in mind this is a faction tool. :) And it requires a lot of work for us to maintain. 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.
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
Yes, our faction was run by different leaders a year ago. It is a learning experience. But this post was not made for sympathy. It was made as a warning to others, don't trust him.
Of course we will recover, he only took 40% of our total assets, he didnt have ALL perms, but that's not the point. We wanted to make it public so he doesn't get the chance to do it again to someone else.
Yes, our faction was run by different leaders a year ago. It is a learning experience. But this post was not made for sympathy. It was made as a warning to others, don't trust him.
Of course we will recover, he only took 40% of our total assets, he didnt have ALL perms, but that's not the point. We wanted to make it public so he doesn't get the chance to do it again to someone else.
I disagree, all is fair in war , i do however agree this matchup shouldn't have even happened, this is why we resorted to tactics we've never used before:) if I want a 1 vs 1 fair fight ill arrange it with an opponent. besides I don't really think 5 mercs sitting on the 2 players we couldn't beat and 1 revive contract are "going overboard": lol xD I consider that planning, even if it didn't work as well as we had hoped, but heyy outside hits don't gain RW score, so please don't discredit our efforts.
Anyhow, we war for fun, nothing personal, so hopefully you guys had as much fun as we did. :D Thank you those of you in RIOT who gave us a tough fight, definitely more fun than some RWs we've had lol. We've learned a lot from you guys so thank you.
I am looking to sell off my AN, I've been running this company for well over a year now, and im ready to move on. Currently at 10 star, all employees pay 1 DVD tax per week when 10 star, sell trains for 450k at 9 star.
I paid 710mil for the company, but that was way back when DVDs were 3mil lol. i'd be happy with 650mil OBO.
I am looking to sell off my AN, I've been running this company for well over a year now, and I'm ready to move on.
- Currently at 10 star, all employees pay 1 DVD tax per week when 10 star, sell trains for 450k at 9 star. - All employees are active daily and rehab regularly, you don't have to go out and find new employees unless you want to. They also pay fees on time, rarely ever have to remind them.