Tree Spreadsheet!

Dishconnected
Posts: 65
Joined: Tue Feb 04, 2014 4:51 pm
Location: Phoenix, AZ
Contact:

Tue Apr 29, 2014 1:27 pm

The data for this was taken from the OranThul guide but has since been updated for North America (NA) Alpha.

Feel feel to contribute to this document so that we can utilize it by responding in this thread.

https://docs.google.com/spreadsheets/d/ ... =409405395

Let me know if you have any questions/comments. :)

May 19, 2014 update #3:
  • Updated tree size data: Beech, Birch, Camphor, Chestnut, Ebony, Larch, Palm, Thuja
Future Updates!
  • Picture Linking
User avatar
Onix095
Posts: 15
Joined: Tue Feb 25, 2014 2:19 pm
Contact:

Tue Apr 29, 2014 1:41 pm

Might want to take a look at this sizing scale: http://imgur.com/a/91FCH

And to go along with the scale mentioned in the pictures:
[+] Show
All seeds from plants Dealer 1.5 × 1.5 botany / agriculture

Chicken 1.5 × 1.5 Cattle breeding
Goose 1.5 × 1.5 Livestock
Duck 1.5 × 1.5 Cattle breeding
Pig 3.0 × 3.0 Cattle breeding
Sheep 3.0 × 3.0 Livestock
Goat 3.0 × 3.0 Livestock
Turkey 3.0 × 3.0 Livestock


Feigenbaum 3.0 × 3.0 logging
Banana Tree 3.0 × 3.0 logging
Grapevine 3.0 × 3.0 logging
Laurel 3.0 × 3.0 logging
Cow 4.5 × 4.5 Livestock
Buffalo 4.5 × 4.5 Livestock
Yata 4.5 x 4.5 Livestock
Rubber Tree 4.5 × 4.5 logging
Bamboo 4.5 × 4.5 logging
Lemon Tree 4.5 × 4.5 logging
Eunsasi tree 4.5 × 4.5 logging
Date Palm 4.5 × 4.5 logging
Secretion tree 4.5 × 4.5 logging
Willow 4.5 × 4.5 logging
Back juniper 4.5 × 4.5 logging
Apple Tree 4.5 × 4.5 logging
Maple 4.5 × 4.5 logging
Cedar Tree 4.5 × 4.5 logging
Avocado 4.5 × 4.5 logging
Olive Tree 4.5 × 4.5 logging
Attention 4.5 × 4.5 logging
Polar 5.0 x 5.0 Livestock
Mega Seed 5.0 x 5.0 botany / agriculture
Oak 6.0 × 6.0 logging
Pine 6.0 × 6.0 logging
Ginkgo 6.0 × 6.0 logging
Moringa Tree 6.5 × 6.5 logging
Ash 7.5 × 7.5 logging
Hornbeam trees 7.5 × 7.5 logging
Pomegranate 7.5 × 7.5 logging
Orange Tree 7.5 × 7.5 logging
Cork 7.5 × 7.5 logging
Cherry 7.5 × 7.5 logging
Bad Korean translation everywhere, you have been warned. :)
Dishconnected
Posts: 65
Joined: Tue Feb 04, 2014 4:51 pm
Location: Phoenix, AZ
Contact:

Thu May 01, 2014 11:30 pm

Tree spreadsheet continues to be updated.

The previous revision did not contain data for when you plant in the wild, which increases 10 LP to every single harvest and significantly changes the LP ratios. I have updated to reflect this.
arcticwhitefox
Posts: 1
Joined: Thu May 01, 2014 12:57 pm

Fri May 02, 2014 4:34 am

Results for Gathering of bundled items made by the Farmer's Workbench (Results might be off due to un-ideal climate of zone)

***All Costs are of Singular Bundle***
[+] Show
Carrot Bundle (Ideal Climate -> Temperate)
****Grown in Arid Climate****
10 LP to make, 25 to Harvest
*Harvests -> 30 / 33 / 35 / 34
*Bait Worm -> 6 / 8 / 7 / 6
*Cost to make: 7s 50c
*Growth Time -> 5 hours 43 minutes
*Growth + Water -> 4 hours 35 minutes

Average Harvest: 33
Average LP/Item: .94


Azalea Bundle (Ideal Climate -> Temperate)
****Grown in Arid Climate****
10 LP to make, 25 to Harvest
*Harvests -> 38 / 36 / 35 / 38
*Bait Worm -> 8 / 8 / 7 / 5
*Cost to make: 5s
*Growth Time -> 5 hours 43 minutes
*Growth + Water -> 4 hours 35 minutes

Average Harvest: 36.75
Average LP/Item: 1.05


Rosemary Bundle (Ideal Climate -> Temperate)
***Grown in Arid Climate***
10 LP to make, 50 to Harvest
*Harvests -> 36 / 31/ 31/ 28 / 36 / 32 / 35 / 33
*Bait Worm -> 9 / 9 / 9 / 9 / 10 / 8 / 10 / 9
*Cost to make: 20s
*Growth Time -> 8 hours
*Growth + Water -> 6 hours 24 minutes

Average Harvest: 32.75
Average Item/LP: .54


Wheat Bundle (Ideal Climate -> Temperate)
***Grown in Arid Climate***
10 LP to make, 50 to Harvest
*Harvests -> 32 / 20 / 30 / 36 / 29 / 29 / 31 / 36
*Bait Worm -> 9 / 8 / 9 / 8 / 10 / 8 / 10 / 10
**Hay Bale -> 2 / 2 / 2 / 1 / 1 / 2 / 2 / 1
*Cost to make: 20s
*Growth Time -> 11 hours 26 minutes
*Growth + Water -> 9 hours 9 minutes

Average Harvest: 30.375
Average Item/LP: .51


Rice Bundle (Ideal Climate -> Temperate)
***Grown in Arid Climate***
10 LP to make, 25 to Harvest
*Harvests -> 30 / 33 / 31 / 35 / 35 /29 / 33 / 29
*Bait Worm -> 10 / 9 / 9 / 8 / 8 / 10 / 9 / 9
**Hay Bale -> 2 / 2 / 2 / 1 / 2 / 1 / 1 / 1
*Cost to make: 14s
*Growth Time -> 11 hours 26 minutes
*Growth + Water -> 9 hours 9 minutes

Average Harvest: 31.88
Average Item/LP: .91


Cotton Bundle (Ideal Climate -> Temperate)
***Grown in Arid Climate***
10 LP to make, 50 to Harvest
*Harvests -> 99 / 102 / 99 / 96 / 103 / 98 / 102 / 104
*Bait Worm -> 8 / 8 / 9 / 9 / 8 / 8 / 9 / 10
*Cost to make: 14s
*Growth time -> 11 hours 26 minutes
*Growth + water -> 9 hours 9 minutes

Average Harvest: 89.13
Average Item/LP: 1.46

Dishconnected
Posts: 65
Joined: Tue Feb 04, 2014 4:51 pm
Location: Phoenix, AZ
Contact:

Fri May 02, 2014 5:40 pm

Data came in from Warmwater (thanks!).

Once their proficiency went over 1000 they got 3-4 logs and the LP cost changed to 15 from 20. This means the gains are on a sliding scale. All values in the sheet assume less than 1000 proficiency.
Dishconnected
Posts: 65
Joined: Tue Feb 04, 2014 4:51 pm
Location: Phoenix, AZ
Contact:

Mon May 05, 2014 7:32 pm

Use this to create timers for your shtuff!

http://www.timeanddate.com/timer/#
Dishconnected
Posts: 65
Joined: Tue Feb 04, 2014 4:51 pm
Location: Phoenix, AZ
Contact:

Thu May 08, 2014 4:12 pm

Updated May 8, 2014:
  • Updated sheet name to reflect this is efficient farming - does not contain values for all zones.
  • Added color to tables for readability. Each sheet has the column it is sorted by highlighted in green.
  • Added Sequoia data. This was only one data point so this needs additional data.
  • Removed Sequoia "Labor - Chopping". Needs verification.
  • Updated Flaming Log comment (N49).
  • Added "No data" to clean up empty cells.
reivongoreheart
Posts: 33
Joined: Mon Apr 28, 2014 2:21 pm
Location: East Coast

Thu May 08, 2014 4:23 pm

Dish you are dreamy.
Dishconnected
Posts: 65
Joined: Tue Feb 04, 2014 4:51 pm
Location: Phoenix, AZ
Contact:

Thu May 08, 2014 4:27 pm

reivongoreheart wrote:Dish you are dreamy.
Thanks. :D

There's a ton of work to do to get this accurate. I will be busy!
Dishconnected
Posts: 65
Joined: Tue Feb 04, 2014 4:51 pm
Location: Phoenix, AZ
Contact:

Thu May 08, 2014 4:54 pm

May 8, 2014 #2:
  • Added comments in column P - a mini FAQ, if you will.
reivongoreheart
Posts: 33
Joined: Mon Apr 28, 2014 2:21 pm
Location: East Coast

Thu May 08, 2014 4:56 pm

Its inspired me to make one for Husbandry. At least as far as lucrativeness. Maybe Ill start tonight.
Dishconnected
Posts: 65
Joined: Tue Feb 04, 2014 4:51 pm
Location: Phoenix, AZ
Contact:

Thu May 08, 2014 5:00 pm

reivongoreheart wrote:Its inspired me to make one for Husbandry. At least as far as lucrativeness. Maybe Ill start tonight.
If you need data let me know.

I already started on a Mining worksheet. :)
reivongoreheart
Posts: 33
Joined: Mon Apr 28, 2014 2:21 pm
Location: East Coast

Thu May 08, 2014 5:21 pm

I need to move my large farm to temperate for optimal numbers. Going to start with costs, feed, grow time, and what each animal brings in on average. Will probably move farm to Rookeborne tonight if I have the gold to rebuy livestock. Any data will be helpful as far as drops.
Dishconnected
Posts: 65
Joined: Tue Feb 04, 2014 4:51 pm
Location: Phoenix, AZ
Contact:

Thu May 08, 2014 5:56 pm

reivongoreheart wrote:I need to move my large farm to temperate for optimal numbers. Going to start with costs, feed, grow time, and what each animal brings in on average. Will probably move farm to Rookeborne tonight if I have the gold to rebuy livestock. Any data will be helpful as far as drops.
Gotcha. Use Oran Thul's husbandry guide to start yourself off since they made their sheets an image file.

http://www.oranthul.com/guides/m/222234 ... id=1767848
Dishconnected
Posts: 65
Joined: Tue Feb 04, 2014 4:51 pm
Location: Phoenix, AZ
Contact:

Fri May 09, 2014 12:22 am

May 8, 2014 #3:
  • Changed Aspen logs/hr to 6.5.
  • Updated Poplar to Any temperate.
Dishconnected
Posts: 65
Joined: Tue Feb 04, 2014 4:51 pm
Location: Phoenix, AZ
Contact:

Fri May 09, 2014 1:37 am

May 8, 2014 #4:
  • Changed Sequoia average yield to 16.5.
Dishconnected
Posts: 65
Joined: Tue Feb 04, 2014 4:51 pm
Location: Phoenix, AZ
Contact:

Fri May 09, 2014 2:49 pm

Request for Sequoia pictures!


Holy crap that is tall!
Image

Image

That is a Willow tree for comparison. Willow is size 2 and Sequoia is size 5.

~D
Dishconnected
Posts: 65
Joined: Tue Feb 04, 2014 4:51 pm
Location: Phoenix, AZ
Contact:

Fri May 09, 2014 10:20 pm

May 9, 2014 update #1:
  • Added Banana to 10K proficiency tab. Yields 4 logs in Tropical.
Dishconnected
Posts: 65
Joined: Tue Feb 04, 2014 4:51 pm
Location: Phoenix, AZ
Contact:

Mon May 12, 2014 3:25 pm

May 12, 2014 update #1:
  • Updated Aspen Average Logs/hr yield. This was incorrect.
  • Renamed Low LP/ High Log Yield sheet to be more informative.
  • Formatting changes.
Dishconnected
Posts: 65
Joined: Tue Feb 04, 2014 4:51 pm
Location: Phoenix, AZ
Contact:

Thu May 15, 2014 12:44 pm

May 15, 2014 update #1:
  • Updated Best - Tropical comment to point to Traveler's Trees.
Post Reply