Made a quick OC 2.0 sheet for my faction, probably more to come. Current features are:
List members not in an OC
List members missing an item and the item missing
List members below a required minimal success rate or above a maximal allowed success rate
Reward overview over the last crimes
Reward summary, sums over the last 31 days and averages overall
Additionally there is a quick overview of all the faction members, listed in the order from highest CE to lowest with the crimes their in, their roles, their success chance and when they joined.
Create a copy, check the attached Apps script, if satisfied plug in your API key in the "Meta" sheet cell A2 and set the minimal required success rates as you want. Then hit the "update" button in the "problems" sheet. The faction key must be of a member with "Faction API" permissions and at least minimal access.
This is donation ware if you like it I would appreciate some donations. Also if you want more features please tell me, regardless of if you donated or not.
If new crimes that are not on the list in the "meta" sheet get released:
Just put the crime name and min/max pass rate anywhere in the list, I had them sorted by the level to make finding them easier, but the order doesn't matter iirc. You can just add new crimes to the bottom as they get released
Update: Thanks to Mizadil [2640357] who has been doing almost entirely solitary rehabs for years now, I was able to find out all rehabs until 1,095!! Also many thanks to someone who asked to be pseudonymized (so I called them Subject A), for very valuable logs that got function even further mapped out to 4,635.
The bad news is that it seems the function is completely arbitrary. The good news is that this means you can just look up the amount of AP/rehab removed and not have to calculate some weird function. The bad news is it makes prediction impossible. The good news is that this means we will have an exact measurement once the function is fully mapped out until the dreaded rehab no after which it's 1AP/rehab
Here is what we know so far:
Rehab #
AP reduced
Notes
1-91
60.00
92-121
54.50
~60/1.1
122-151
50.00
=60/1.2
152-181
46.00
~60/1.3
182-211
42.(66)
~60/1.4
212-241
40.00
=60/1.5
242-271
37.50
=60/1.6
272-301
35.00
~60/1.7
302-331
33.(33)
=60/1.8
332-361
31.50
~60/1.9
362-501
30.00
=60/2
502-801
24.00
=60/2.5
802-1096?
20.00
=60/3
1097-1395?
15.00
=60/4
1396?-1695?
12.00
=60/5
1696?-1995?
10.00
=60/6
1996?-2296?
8.57
possibly 60/7
2297?-2592
7.50
=60/8
2593-2895
6.(66)
=60/9
2896-3195?
6.00
=60/10
3196?-3495?
5.46
Possibly 60/11
3496?-3795?
5.00
=60/12
3796?-4095?
4.61
Exact (within +-0.005, notably not 60/13 which is just a bit larger)
4096?-4395?
4.29
Possibly 4.33 or 60/14
4396?-
4.00
=60/15
It seems that after rehab 801 the amount is 60 divided by an increasing integer every 300 steps.
The issue with this theory is with 60/13~4.6154. Subject A rehabbed on 06 July 24 exactly 39 times, a multiple of 13. But instead of 39*60/13=180, they rehabbed only 179 AP. On 19 June 24 they rehabbed 41 times for 189 AP which gives a lower bound of ~4.6098 AP/rehab. Rounded to 0.01 one should be 4.62, but in reality it is 4.61.
Rounding down however also doesn't seem to be accurate. For 60/14~4.2857 on 30 October 24 Subject A recovers 120 AP from 28 rehabs. If this were rounded down to 4.28AP/rehab we should expect 119 AP recovered.
Also some drug AP values could be corrected, however others are still +-1 due to faction toleration perks:
Name
AP
Overdose
Cannabis
1
no data
AP value sure thanks to Nabrav
Ecstasy
20
20
AP value sure thanks to hcedim, od sure thanks to Nabrav
Ketamine
8
50
LSD
20
50
AP value sure, od estimate thanks to mizadil
Opium
10
no data
AP value sure (thanks hcedim)
PCP
26
50
Shrooms
5
no data
AP value sure (thanks hcedim)
Speed
13
50
AP value sure (thanks hcedim)
Vicodin
13
50
AP value sure, OD value sure
Xanax
35
100
AP and Overdose value sure (thanks hcedim)
Love Juice
50
n/a
AP value sure thanks to Subject A
Additional findings:
Fractional AP values from taking drugs are not forcibly rounded up
This editor window is entirely too small and there is so much wasted screen space it's annoying. I'll post this, then fix the formatting tomorrow or so.
I'm mainly putting this post out to gather what I have so far and see if other people have further insights. If you would like to do your own logs here is the spreadsheet I used. If you want to donate some logs you can go to torn.report -> Tools -> Manage Data -> Log categories -> Export as csv. This is will export all logs with timestamps of when you took drugs and rehabbed. You can send it to me via discord, you can find me in the torn discord (just start to @ me then you'll see my profile pop up) or some other way if you prefer
The exact data you'll give me is
time
rehab cost
rehab amounts
addiction removed (as %)
drugs taken
if it was an overdose
if it was from faction armory
hospital time in or decreased
nerve in or decreased
energy in or decreased
happy in or decreased
Again Thanks to Mizadil [2640357] for providing nigh-perfect data.
Loving the new target list, so I immediately had a couple things I wished were there as well:
Features:
Automatically refresh targets after a set time (5 minutes by default).
Automatically refresh attacked targets.
Manually refresh targets.
Make sure the attack button is enabled at all times.
Show current and max hp if the target is okay.
Show remaining hospital time if the target is in the hospital.
Show current competition status.
Show the predicted fair fight modifier from TornPal (via TornTools or directly).
Show predicted respect or level above the estimated fair fight modifier (respect estimation is based on level and the FF mod only. Chain, overseas, warlord etc. bonuses aren't taken into account).
Copy the estimated battle stats score and faction (if applicable) into the description field
If you have TornTools a public API key is sufficient as it gets the FF modifier from TornTools. Otherwise it needs to be a key that is registered with tornpal.com. So if you register your TornPDA key with TornPal you can see predicted fair fight modifier on your PDA! If not all other features will still be available of course.
If you click on "edit description" you will see an arrow. This arrow copies the Battlestat score and faction into the description field, this way you can filter by faction if you search for the faction and sort by FF if you sort by description. If you dont know what the battle stat score is, have a look in the wiki. Basically, target battle stat score divided by your battle stat score gives you the fair fight multiplier so this way you can effectively sort targets by their difficulty.
I would consider this script feature complete, if you would like to see anything else or something different please feel free to ask. Tips always welcome.
it was founded as a safe haven for the Jews who were persecuted during the second world war.
It wasnt. It was founded as a settler colonial project by Theodor Herzl. He wrote to people like Cecil Rhodes (of Rhodesia infamy) and surveyed different areas around the globe. A place in Argentina was once a strong contender for settlement but Palestine (then under Ottoman rule) won out in the end. He founded the Jewish Colonial Trust, a bank to help people who wish to become settlers, now operating under the name "Bank Leumi". He visited the Tsar in Russia and other fervent antisemites believing them to be strong allies since their systematic persecution of Jews would force them into his colonial project. He actually despised the Jews that wouldn't follow him calling them "Mauschl" a term used to evoke the image of the "miserly jew".
The zionist organisation always had strong to ties to antisemites, for example they offered to help Nazi Germany with the "jewish question" by having german jews settle in Palestine. Jews that wished to escape Nazi Germany to Palestine were able to transfer their wealth there, this was not possible if they wished to escape anywhere else. The zionists then helped the Nazi circumvent a boycott that they were very anxious about.
Never believe the lies of the Occupation Regime Of West Palestine. They never represented Jews but instead pretend that they do, they wear their faith like a cloak to hide their lies. Anyone who thinks the OROWPA represents Jews should ask why so many Jews choose to still live in Arab countries. Or in Iran, OROWPA's most powerful declared enemy.
First up some more resources for the future: https://tornapi.tornplayground.eu/ and also join the discord. Since I'm not a director I can't test directly but I believe you can loop through /company/news?&from=...&to... using the earliest timestamp in a query as the "to" parameter for the next.Poll once per second and you should be able to go back all the way to when the company was created.
Thanks! The drug AP's might indeed be off by 1 because of my faction toleration perk. If you have any further insights (especially for overdoses) please let me know.
I also had amended ecstasy to 20 AP, but forgot to add it to the public sheet.
Just put the crime name and min/max pass rate anywhere in the list, I had them sorted by the level to make finding them easier, but the order doesn't matter iirc. You can just add new crimes to the bottom as they get released
A sudden and unexpected comeback victory for Ukraine after the RAF have been blocked from torn dot com is sure to be at hand! We knew sanctions were going to work eventually, we just needed to try 17 times!!
It's now pointing to https://ffscouter.com/, if you log in there with the same key, you should be able to keep on using the script without changing anything.
If this were a real bazaar every vendor would only sell one category of items like clothes or veg or meat so customers shopping for either can see at a distance which vendors to go to. This is just a hodgepodge more akin to a flea market where people typically don't sell items you purchase every week because its a really ineffective way of shopping!
Do you mean like for each member what their role level for each crime would be? It's only possible to see what their role level (or check point pass rate) is in the role their currently in, thats visible in column F of "Overview"