If this sheet has helped you, please upvote the main thread so that others can see it and we grow the stream of data coming in:

Version 1.5 - 10.07.2015

Direct all missing data to the thread shown in the first line of this sheet. Section 2.5, 7.0 and other parts of this file should be a complete, single source of truth for the community. Don't hoard and fragment data.

This is a personal worksheet I put together for myself and the foshelter subreddit. Go ahead and copy the data and formulas, but don't claim work as your own.

Any cell shaded in this colour is a variable to be changed for testing.

Any cell shaded in this colour marks an important question that remains unanswered

Actual Time = Triangle(skill level) * 30 minutes * Mod-Happy / (1+(Mod-Group + Mod-Level))

Mod-Happy = (1- (Vault Happiness / 10)

Mod-Group = 2% *(Number of trainees in room - 1)

Mod-Level = 6% *(Room Level -1)

New Stuff

Dwellers in the waste do not consume food and water

Legendary Dwellers from the Radio (speculation).

Powerleveling to max SPECIAL and level 50.

Level 1 Dweller has 100 health, there's a combat event ever 100 seconds in the waste. If I assume there's 200xp/hr just for being in the waste, I get some round XP numbers out: Lvl2 needs 4000, lvl5 needs 12000m lvl 8 needs 15000. I don't see a pattern though.

Dmg and xp is fixed for each enemy. You take 0-3 dmaage on success, 1-10 damage on failure and 1/10th the XP of sucess.

People in a training room will make others train faster even if they are max stat and don't need to train themselves.

My caps income has dissappeared. Bug or something we don't understand about caps on resource collection. Section 3.1 has details.

Pattern: Fixed Events that reward an amount of xp ending in 0 (60,70,80...) reward caps. All found events that reward loot end in 5 (65, 75, 85....). We may be missing some events.

The case isn't strong for Luck affecting combat and survivability in the waste. Removes a variable from combat analysis at least.

Confirmed bug at 100 items, loot after this is not picked up by dwellers.

Evidence for rare/legendary chance increasing with time for the hourly loot drop is looking pretty good. I've made an estimate with the limited data we have so far.

New Fixed Time Event's found thanks to /u/HabeQuiddim and /u/Riogray at the 75 and 15 hour marks.

Priority dataz we need

Sequenced waste exploration data. If you're sending a geared dweller out for multiple days, please consider recording their progress every 24 hours just like shown in section 7.4. This data is extremely vlauable right now.

It's hard to use however if you don't know if a rare was from an hourly event or fixed event. The best data would be 4 days sampled every 24 hours where you know how many rares came from the 5 fixed events that reward rares. This takes effort, but I'd love you for it.

A screenshot of a dweller being rewarded with legendary loot form the hourly event. Everything points to this being possible, but we haven't got the screenshot yet. (except for the negative time bug)

Screenshots of rewards from fixed events that disagree with what is recorded in section 7.1.4

We've found fixed time events rewarding xp in 5xp increments from 10 all the way to 125. We're missing events for 15xp, 110xp and 120xp. There may be events we haven't recorded.

Base training time from 1 - 2 is 30 minutes

Training time per level increases rapidly so that 1 -10 takes 82.5 hours.

Training time can be reduced by:

Having more people in the training room (they don't need to be training themselves)

Upgrading the traing room to a higher level

Increasing the average happiness of your vault.

Table below show in black the times observed to train skills. In grey, we used the largest observed time to calculate the (more accurate) base time by dividing by the triangle of that number.

No. Trainees in Room

Vault Happiness Boost

1.2 Possible Function for Calculating Training Time

Apparent Coefficients

Formula for now:

Boost per Trainee

Actual Time = Triangle(skill level) * 30 minutes / (1 + Mod-Group + Mod-Level + Mod-Happy)

Boost per Room Level

Mod-Happy = Vault Happiness / 10

Mod-Group = 2% *(Number of trainees in room - 1)

Trainees in Room

Mod-Level = 7% *(Room Level -1)

All the old data was recorded at the happiness boost when you click on vault happiness.

Since then it's become evident the game never used that number, rather it uses vault happiness /10

Room level is more effective at lower numbers of trainees

Trainee numbers are more effective at lower room level

1.3 What does this mean?

Training time goes down with the people training in the room, the level of the room, and your vault happiness.

We can use this to look at the best and worst case scenarios of training a SPECIAL from 1-10

Best Case: Full L3 Triple training room, vault with 100% happiness

Worst Cast: Training alone in L1 room with 10% cault happiness

Available trianing places

Total Time per Dweller (days)

Total Time across all dwellers

Real time required after simultaenous training

2.0 Resource Rooms

2.1 Relationship between skill and time

Testing showed the following relationship between cycle time and room skill

Cycle Time = Max Cycle Time / Total Skill in Room

(for a given level of vault happiness)

Time Reduction

2.2 Test: Effect of Happiness on on resource cycle time.

* Need to understand the scaling effect of vault happiness in order to arrive at the true base time

* Assuming that radiated workers don't work slower :S. Had to radiate a vault to get the happiness right down.

* Tested a level 1 power plant, single room, 1 worker, 1 skill.

Game is probably using the raw average of all dweller happiness in its calculation but only showing us rounded to two decimals in game.

* Means all the old data could be out by about 1%

* Full Resource Room Equation accounting for happiness

Cycle Time = Base Cycle Time / Total Skill in Room * (1 - (Vault Happiness / 10))

2.3 Test: Skill above 10 matters

*One worker at 12 skill had the room cycle time at 3:02, not 3:38.

In addition, testing has shown that pushing an entire room above the cap (60 for a triple) still drives cycle time further down. We haven't observed an stat being capped anywhere to date.

2.4 Best Rooms

Now that we know all the equations. We can input any variables we choose to see what the cycle time on a room is.

We can then compare all rooms for which is best for storage, output per cycle or output per minute. What ever we choose. By default, the table below shows that double plants are better than triple.

A simple comparison tool is shown below. You can copy this sheet yourself and change the variables in purple to compare whatever you wish

This comparison is only as accurate and complete as the raw data it's running off below, please check and add times to the reddit thread listed in the first row of this document

Avg skill per worker

Output/min/node

2.5 Raw Resource Room Data

Table hasn't got the data you need? Help us fill it out.

What we need to know:

3. Room Cycle Time

4. You vault happiness at the time you measured cycle time

5. The skill you had in the room at the time you measured cycle time (more accurate if you only put 1 skill in)

If 50 people people take the 3 mins to test 1 room each, we'll have all we need to know for the best rooms.

I see you logged into this spreadsheet reading this.......maybe....test something and give back...

Submit your data to http://www.reddit.com/r/foshelter/comments/3a0p7v/room_efficiency_data_thread/ so it can be included to help everyone.

Big thanks to /u/showrin76 for filling out a lot of this table.