Medic + BigBrother: 10-3

Day 318, 11:35 • Published in USA USA • by Pearlswine

I'm still doing the medic thing. I'm not going to post the medic info in this newspost, but I will be editing my previous post as needed. The medic spent ~9500USD last month and with gift prices at a low point, this means even more gifts were given out.

I've done a full update on the big brother, company list and CV list spreadsheets. They are linked below:
[a url=http://spreadsheets.google.com/pub?key=pi4EiQOnel6vRaE4QJ9v7Ew]Big Brother[/a]
[a url=http://spreadsheets.google.com/pub?key=pi4EiQOnel6v1rt0sCOUAYA]Company List[/a]
[a url=http://spreadsheets.google.com/pub?key=pi4EiQOnel6uKx_7_axZyHA]CV List[/a]

This may be the last update of these sheets. I don't expect the scripts to continue working come V1 and I'm not sure I'll have the time to fix them.

I'd like to explain how I calculate the estimated US productivity from the Big Brother spreadsheet.

Lets take the first line of my Q1 food column: =IF(AND($V3="food",$U3=1),($I3+1-$U3)*(1 +$G3/50)*(0.91+$W3/200)*($O3/100),0)

First I narrow down the data: For this column I want the company that this person works for to be Q1 and a producer of food. if they aren't, I multiply the equation by 0, if they are multiply by 1.

Next is the skill factor. I look at their skill in food, add 1 and subtract the quality. This is equivalent to the skill factor in the productivity equation.

Now the wellness factor. I take their current wellness, divide that by 50 and add 1.

Next is the number of employees factor. I use Excel's Vlookup function to get the number of employees in the company that they work for. Using that I can calculate the number of employees factor.

The final factor is a presence factor. I take each person's daily presence and if they don't show up to work consistently, the calculated productivity drops.

I then multiply all these factors together and come up with an individual daily productivity score. In order to get the US's entire daily productivity I just sum up everyone's individual productivity. To determine the number of products produced a day I just divide by the productivity required to produce one unit.


To determine the quality of food required I take the quality of their workplace, subtract the house quality and determine if they are in the army, if they are I add one. Any value of less than one is forced to equal one. This is the minimum quality of food needed by this person to stay at a constant wellness.

Products / day

Food
Q1 1442.3
Q2 1153.6
Q3 783.5
Q4 435.5

Gifts
Q1 222.3
Q2 546.4
Q3 205.6
Q4 0

Hospitals
Q1 0.22
Q2 0.00
Q3 0.13
Q4 0.14

Housing
Q1 6.71
Q2 5.51
Q3 3.27
Q4 1.33

Moving
Q1 26.2
Q2 7.58
Q3 1.68
Q4 0

Weapons
Q1 43.4
Q2 48.8
Q3 12.5
Q4 114

Productivity/day
Food
Q1 1442
Q2 1153
Q3 783
Q4 435

Gifts
Q1 444
Q2 1092
Q3 411
Q4 0

Hospitals
Q1 441
Q2 4.7
Q3 250
Q4 270

Housing
Q1 1341
Q2 1101
Q3 653
Q4 266

Moving
Q1 1046
Q2 303.
Q3 67.0
Q4 0

Weapons
Q1 434
Q2 488
Q3 125
Q4 1143