作物电子表格

0 点赞
Rusty's Retirement
转载

A basic guide with a spreadsheet containing crop and berry data. Spreadsheet This guide contains a spreadsheet table with crop and berry parameters for anyone to use. I've done some basic maths to find out which crops are the most efficient for different parameters. For example, if you're bottlenecked by watering bots, you can grow a crop that is more water efficient. Spreadsheet link: https://docs.google.com/spreadsheets/d/14ba_tuCNRMV6-yQTmk8exRVV-_6VGmu5qOHHm2vKJN0/edit?usp=sharing I've explained each spreadsheet column in order, below: The Basic Stuff Cost, Time, Water, Cycles, Crop Sell Price and Biofuel values are taken straight from the game. In case anyone needs it explained: Cost 💰 - Cost per seed Time 🕒- Time it takes to grow in seconds Water 💧- How many times the crop needs to be watered to reach full growth Cycles ♻️- How many times the crop regrows Crop Sell Price 🥕💰- How many spare parts received when the crop is harvested Biofuel 🔋- Biofuel produced per crop when placed on the Biofuel Converter. Total Crop Sell Price 🥕💰 Crop Sell Price x Cycles = Total Crop Sell Price per seedThe total spare parts value for each crop, per seed. Total Biofuel 🔋 Biofuel x Cycles = Total Biofuel produced per seedThe total amount of biofuel each crop produces, per seed. Biofuel Sell 🔋💰 Total Biofuel x 10 spare parts = Total Biofuel value in spare partsThe total spare parts value for the biofuel produced by each crop, per seed Gross Profit 💰 Biofuel sell + Total Crop Sell Price = Gross profit Net Profit 💰 Gross profit - cost = Net profit Most Efficient Crops Refer to relevant columns on the spreadsheet Most Efficient Crop at producing Biofuel per Minute 🥕 = 🔋 per 🕒 see Time per Biofuel column (Time x Cycles)/Biofuel = Time per BiofuelThe time it takes for each crop to produce 1 biofuel. The more green the cell column is on the spreadsheet, the more time efficient the crop is at producing biofuel, assuming that it is watered and harvested optimally. For example, Tomatoes, Artichokes and Red Grapes produce the most biofuel per minute. In practice, it's unlikely that crops are watered and harvested immediately so this metric might not be the most practical, i.e. tomatoes are a water-hungry crop, and may spend time waiting to be watered. Artichokes and Red Grapes take a long time to grow so your Biofuel bots might be idle. Time to replant (min) 🌱 Time x cycles = Time to replantTime it takes to replant a seed, in minutes. Most Water Efficient Crop 🥕 = 💧 see Water Efficiency/Intervals column Time to grow / Water required to grow = Water efficiency/intervalHow long it takes before a plant needs to be watered. Red is least efficient (requires the most watering) while Green is most efficient (requires the least watering). You can plant more water efficient crops if you don't have enough water bots. Onions, Pinto Bean, Oats and Watermelon are very water efficient. Total Waterings 💧 Water x Cycles = Waterings per seedTotal number of waterings for each seed. Most Cost Efficient Late Game Crop 💧 per 🔋 see Lowest/Highest Upgrade Watering per Biofuel column Crop waterings required/watering per bot recharge = biofuel efficiency per wateringA calculation to determine how much Biofuel is used up by water bots to fully water/grow a seed. Once you enter the mid-late game, this metric is more useful to calculate which crops are the most cost-efficient. Upgraded water and harvest bots use up more biofuel, so growing water efficient crops becomes more important as they use up less biofuel to grow (Water bots only water a certain amount of tiles before recharging, see water bots below) Non upgraded bot 🤖 = 1 biofuel 🔋 to water 20 tiles 💧 Fully upgraded bot 🤖= 11 biofuel 🔋 to water 80 tiles 💧 For example, in the top 10 high tier crops, Watermelon is the most cost-efficient to grow as it uses up the least amount of water for the highest yield of biofuel. The Lowest Upgrade column calculates the biofuel efficiency of a non-upgraded water bot. The Highest Upgrade column calculates the biofuel efficiency of a fully upgraded water bot. You may have noticed that based on the numbers, the non-upgraded water bot and the lowest tier crop is technically the most optimal crop. This metric isn't perfect because it doesn't factor in time, and is more useful for comparing crops within the same column. On paper, a fully upgraded water bot is less "efficient" because it uses up more biofuel to water less tiles. However, this doesn't take into consideration how a fully upgraded bot will water more tiles in less time. It's finicky to calculate the effect of time/speed as it depends on other variables such as crop growth time, distance between water source and tiles, etc. It's safe to assume, the fully upgraded water bot is at least 4 times faster than the non upgraded bot because it can water 16 tiles before refilling, while the basic bot can water 4 tiles before refilling (see Water Bots below). Water Bots💧🤖 Water bots take 15 seconds to recharge. "Capacity" is a bit misleading - it takes 4 capacity to water 1 crop. Crops watered = Water Bot Capacity divided by 4. Water bots will always water 5 cycles before recharging. E.g. Non-upgraded bot will water 4 tiles and collect water 5 times before recharging (20 tiles watered per recharge). Bots with upgraded capacity can water more tiles before recharging. Base recharge Cost = 1 Biofuel 🔋 + 1🔋 recharge cost per upgrade Max 11 🔋 cost Water Bot Upgrades Capacity Speed 16 100 waters 20 soils then recharges 24 140 waters 30 tiles then recharges 32 180 waters 40 tiles then recharges 40 220 waters 50 tiles then recharges 48 260 waters 60 tiles then recharges 56 - waters 70 tiles then recharges 64 - waters 80 tiles then recharges Author Notes Let me know if there are any mistakes in the guide, or if you have any suggestions. I'm not a maths nerd so I didn't do any complicated equations or any equations that require some guesswork/estimates (e.g. calculating optimal layouts since that depends on other variables such as crop watering intervals, distance and time) If anyone else in the community wants to have a shot at crunching numbers feel free to use my spreadsheet as a base. You can copy the spreadsheet with a Google account by clicking File -> Make a Copy.