production planner 2.0.48.0
TRANSCRIPT
-
8/8/2019 Production Planner 2.0.48.0
1/232
General Information
This is a parallel version of Monthar's original Production Cost Analysis spreadsheet.
Important Note for users of OpenOffice
Description
How To Use This Spreadsheet
If you find N/A in some of the cells, go to Tools > Options > OpenOffice.org Calc > Calculate and check the boxSearch criteria = and must apply to whole cells
This spreadsheet should help everyone who is involved in the economy to calculate the production costs of anyintended to be used as a buyers guide.
Within the spreadsheet there are multiple options to set it up for your personal needs. For example, you can set wrates you pay (either structure by structure or globally) and what doubloon per lot-hour and/or percentage mark-upoverride manufactured costs with the actual purchase prices you pay for bought-in goods, or with the value of excTraders.All recipes in the game are included and there is a summary Prices sheet listing prices of every item, to which youper lot-hour and/or percentage mark-ups and compare them side by side. There are a couple of useful tables to qand multiple-item trades.There is a Shipyard Planner to calculate the materials required to make a list of ships and outfitting and a Product
lines and what structures you need.You can also look up the turn-ins and their value your reputation makes available at the European Traders and tuavailable from the Commendation Exchanges in the national capitals.Finally the sheet Bob the Builder calculates all the building materials and costs required to build multiple structures
Go to the Settings sheet first. Here you declare what structures you own, so that calculations will use advanced sspecific shipyard if you own them, or will know to use game animals instead of livestock to make leather.You can set tax rates for each structure (5% is set as defult) and Port Governor-applied Doubloon and Labour CoYou can also declare what relative value you place on goods produced by recipes with two outputs.
The Prices sheet allows you to look up the price of every manufacturable item in the game and compare prices whour and/or percentage mark-ups. You can also carry out quick calculations for single prices and multiple trades. - whether or not you use advanced recipes- whether you wish to include structure upkeep costs in the calculated prices- a value on Marks of Trade, Marks of Victory, Royal Commendations / Captured Batle Ensigns and Magistrate's /Excellence. These are used for the Dauntless Frigate, Couronne Mastercraft Galleon, refit and writ ships.- for items you have to buy, you can set a purchase price which is then used in all calculations instead of the man- an option to use Euro Trade values for items you acquire through the Euro Traders instead of the direct manufac
Shipyard Planneris for people engaged in shipbuilding or making outfittings. It calculates all the ingredients necmade shipwright materials and outfitting, along with the recipe costs and times (using structures, taxes, cost redselected in the Settings and Prices sheets), broken down by structure: Shipyard, Forge, Lumber Mill and Textilenot calculated is the cost of purchased materials. To use it:
1. Create a list of items you want to make (ships, outfitting, lineship structure bundles, hulls and rigs)2. Enter items you already have in either the Already Have In Shipyard Port table and/or one of the structure Alrea3. Buy/make all the items in the turquoise cells listed by structure. You can also quickly check you have enough m4. Make all the items in the list created in step 1.
Production Plannerallows you to plan production lines. Every structure is listed except for Careening Camp, Aevery recipe is listed except for ships and outfittings. You can select which structures you own, what recipes to rto use for the calculation and it will calculate the total costs involved, the net surplus or shortage of every materialmany unused hours there are in each structure.
-
8/8/2019 Production Planner 2.0.48.0
2/232
Most of the remaining sheets list the individual recipes, categorised as they are in the game.
History
Euro-Trades shows what exchanges are possible at the different European Traders based on your reputation. Ttimes are listed, and you can apply doubloons per lot-hour and/or percentage mark-ups to these as well, allowingof different exchanges.If you obtain goods through the European Traders rather than making or buying them, you can use the emanufactured cost in other price calculations. To do this:1. Enter the actual turn ins you are making at different European Traders. If you use more than one Trader, the av
2. Select Use Euro Trades Options in the Prices sheet.
Commendation Exchange shows the possible exchanges and their value at Exchequers, Commendation Enational capitals. Only manufacturable items are shown.
Bob the Buildercalculates the building materials and costs for making multiple structures.
Society Administration is used to record details of members' production
Writs and Refits lists the requirements for all refit and certifiable ships.
The first version of this spreadsheet was released by Monthar while the game was still in closed beta. At the powas an intention to have one society webpage to provide the sheet exclusively. After a few weeks it was brought Monthar maintained it up to Version 1.2.x. After Monthar was caught by his real life, the work was taken over bypretty long to keep the sheet up to date. With version 1.5.48.0.0 SirGrey decided to bring up this decent work up of revival. The intention was that the sourceforge system would make it easier to maintain the spreadsheet and espreadsheet is still available and is kept up to date by SirGrey.
Remus added a Shipyard Planner tab to version 1.6.34.1.50 for his own use in calculating shipbuilding mateincorporated into Production Cost Analysis 1.7.36.0.0 by SirGrey, but Remus continues to use this version for hisas game patches are released and improvements are suggested. To avoid confusion between the two versions, RShipyard Planner from 1.8 and Production Planner from 1.9 although it does incorporate all the functionality of Proplus several additional features subsequently introduced by SirGrey.
-
8/8/2019 Production Planner 2.0.48.0
3/232
Version Changes
Production Planner 2.0.48.0
Production Planner sheet corrected for Limestone and Marble recipe costs and
Production Planner 2.0.47.0
Common Wood recipe time corrected
Bob the Builder ingredient cost calculations corrected and provision to add you
Added the ability to set buy and sell costs in the Production Planner sheet
Production Planner PandP 2.0.37.0
Production Planner sheet settings enabled for tax rates and cost reductions
Corrected error in Shipyard Planner when a ship marked with an asterisk was a
Production Planner PandP 2.0.32.0
Error in tax rates corrected
Shipyard Planner ship recipe lookup corrected
Production Planner Power and Prestrige
Global Tax Rate option removed. Tax Rate drop down list removed
Labor and Doubloon Cost Reductions added
First and Second Rates removed
Courier ships removed
Mastercraft Deliverance and Mastercraft Conquistador added
Global labour modifier reset to 1
Recipe times adjusted for Oak, Fir, Teak, Iron Ore, Copper Ore, Zinc Ore, Gold
Couronne, Mastercraft Couronne and Mastercraft Hercules recipes changed (L
Quick Sales Calculator zero quantity now treated as 1
In Shipyard Planner, ships requiring a base deed are now marked by an asteris
Production Planner 1.26
Production Planner 1.23
Production Planner 1.21b
Production Planner 1.21a
Production Planner 1.21
Production Planner 1.18
Production Planner 1.17.50.1a
Production Planner 1.17.50.1
Production Planner 1.17
Production Planner 1.15.52.0
-
8/8/2019 Production Planner 2.0.48.0
4/232
Production Planner 1.15
Production Planner 1.14.63.0a
Production Planner 1.14.63.0
Production Planner 1.13.50.0b
Production Planner 1.13.50.0a
Production Planner 1.13.50.0
Production Planner 1.12.45.1h
Production Planner 1.12.45.1g
Production Planner 1.12.45.1f
Production Planner 1.12.45.1e
Production Planner 1.12.45.1d
Production Planner 1.12.45.1c
Production Planner 1.9.31.0.1
Production Planner 1.9.31.0
Shipyard Planner 1.8.28.0
1.6.34.1.50.Shipyard.1
1.6.34.1.50.Shipyard.0
1.6.34.0.0
1.5.48.4.50
1.5.48.4.30
1.5.48.4.1
1.5.48.0.13
1.5.48.0.0
1.1.71.0 Initial Release provided by Monthar
-
8/8/2019 Production Planner 2.0.48.0
5/232
Granite recipe time
own mark ups added.
dded to the Output list
Ore, Lignum Vitae and Lineship Structure Bundle
Bs and doubloons)
k
-
8/8/2019 Production Planner 2.0.48.0
6/232
-
8/8/2019 Production Planner 2.0.48.0
7/232
Quick Reference
Yellow cells can be filled out as you like. Entered values may be checked for validation.
Weeks Orange cells contain drop down lists. Select from the preset values. You can use delete if you
YesRed and green cells are mostly for Yes / No answers. You can select only Yes or No.
No
Double Output Recipe Calculation Met
#2 Output
#2 Output
#2 Output
#2 Output
#2 Output
Basic Quarry (Gravel Pit) No 5
Detailed Structure Setup
Structure Name Owned Tax Rate
Advanced Forge No 5
Advanced Logging Camp, Ironwood No 5
Advanced Logging Camp, Oak No 5
Advanced Logging Camp, Teak No 5
Advanced Lumber Mill No 5
Do not change any turquoise or grey cells.Note: Many grey cells contain hidden formulae.
IMPORTANT: Before looking Prices, Euro Trades or the Planner sheets, you should adjust your settings on
INFO: Double output recipes divide the cost and labor between the two outputs. There are three ways of doi1. The first output is fixed in value and all other costs go to the second output2. A percentage of the costs go to the first output and the remainder goes to the second output3. The second output is fixed in value and all other costs go to the first outputLabor hours are divided in the same proportion as costs.The default values are the amounts the Junk Merchant pays for the second output.
INFO: The Owned column is used to decide which structure to use for a recipe when calculating lot-hours aor Livestock are used in calculations involving Leather, Cured Meat or Crates of Hides.If you do not say you own any structure, the default structure for that recipe is used.If you say you own a structure a recipe can be run in, that structure is used.If you say you own more than one structure a recipe can be run in, the structure that takes the fewest lot-hostructure with the lowest upkeep is used. For example a small shipyard will be preferred over an advancedmaster large shipyard is preferred over a medium shipyard (but not an advanced medium shipyard) becauseAssembly Yard because of the structure upkeep.This information is used in all recipe calculations in the Prices and Shipyard Planner sheets.In general, declaring that you own a structure only really makes a difference in the case of advanced structuLodge, whose ownership means that hides, cured meat and leather will use the Game Animals recipes.
INFO: Tax Rates and Labor and Doubloon Cost Reductions apply to individual ports. In Production Planner iare in the same port.Tax Rates are determined by which nation owns a port and whether you have any skill such as Tax Evasionmodified by Port Governors.
Labor and Doubloon Cost Reductions are applied by Port Governors to recipes run in a port.
Butcher Beef(#1=Crate of Hides) (#2=Beef)
Refine Sugar(#1=Sugar, Refined) (#2=Molasses)
Quarry Granite (#1=Granite) (#2=Gravel)
Quarry Limestone (#1=Limestone) (#2=Gravel)
Quarry Marble(#1=Marble) (#2=Gravel)
-
8/8/2019 Production Planner 2.0.48.0
8/232
Advanced Mine, Copper No 5
Advanced Mine, Gold No 5
Advanced Mine, Iron No 5
Advanced Mine, Zinc No 5
Advanced Plantation, General No 5
Advanced Plantation, Sugar No 5
Advanced Quarry, Granite No 5Advanced Quarry, Limestone No 5
Advanced Quarry, Marble No 5
Advanced Shipyard, Medium No 5
Advanced Shipyard, Small No 5
Advanced Sugar Refinery No 5
Advanced Textile Mill No 5
Assembly Yard No 5
Basic Quarry (Gravel Pit) No 5
Careening Camp Yes 5
Draughtsman's Office No 5
Fishing Lodge No 5
Forge No 5Hunting Lodge No 5
Logging Camp, Fir Yes 5
Logging Camp, Ironwood No 5
Logging Camp, Oak No 5
Logging Camp, Teak No 5
Lumber Mill No 5
Master Draughtsman's Office Yes 5
Master Shipyard, Large No 5
Mine, Copper No 5
Mine, Gold No 5
Mine, Iron No 5
Mine, Silver No 5Mine, Sulfur No 5
Mine, Zinc No 5
Pasture Yes 5
Plantation, Cacao No 5
Plantation, Coffee No 5
Plantation, Cotton No 5
Plantation, General No 5
Plantation, Prickly Pear No 5
Plantation, Sugar No 5
Plantation, Tobacco No 5
Powder Mill No 5
Provisioner No 5Quarry, Granite Yes 5
Quarry, Limestone No 5
Quarry, Marble No 5
Recruitment Office No 5
Saltpeter Caves No 5
Shipyard, Large No 5
Shipyard, Medium No 5
-
8/8/2019 Production Planner 2.0.48.0
9/232
Shipyard, Small No 5
Slaughterhouse Yes 5
Sugar Refinery No 5
Tanner Yes 5
Tar Distillery No 5
Textile Mill No 5
Vineyard No 5Winery No 5
Woodcutter's Camp No 5
-
8/8/2019 Production Planner 2.0.48.0
10/232
on't want any value in the cell
hod Value
ixed Value 2
ixed Value 16
ixed Value 10
ixed Value 0
ixed Value 0
5 5 arry, Granite
Port Cost Reduction
Labor Doubloons
this page.
ng this:
d structure upkeep, and for whether Game Animals
rs is used. If there is no difference in lot-hours, theedium shipyard because it only uses one lot. Aof the labor multiplier. A Forge is preferred over an
res, shipyards, the Assembly Yard and the Hunting
it is assumed that all your structures of a given type
which reduces enemy taxes. They can also be
-
8/8/2019 Production Planner 2.0.48.0
11/232
-
8/8/2019 Production Planner 2.0.48.0
12/232
60
60
-
8/8/2019 Production Planner 2.0.48.0
13/232
Prices
Quick Sales Calculator
Select Category of Item to sale Man
Select Item to sale Leath
Quantity 420
% Mark-Up 500
Doubloons per lot-hour
Total in Whole Doubloons = 46,023
Total Rounded in Doubloons = 47,000
Multiple Sales & Quick Trade Calcu
Detailed Price List(with purchase price option
Settings UPKEEP AN
Use EuroTrades Options? No Do you use a
Do you want
Token Values
Mark of Victory
Mark of Trade
Royal Commendation percent (%) 200
Magistrate's Commendation db / lot hour
Structure Deeds
Raw Materials
Item Base Cost
Cacao 7 21
Cochineal 65 195
Coffee 15 44
Cotton Fiber 10 30
Fish, Fresh 2 7
Game Animals 9 27
Granite 4 12
Gravel 2 7
Hemp 4 12
211 Lignum Vitae 211 633
Limestone 7 21
Livestock 24 74
Logs, Common Wood 3 8
Logs, Fir 14 44
IMPORTANT: Before you start working with this sheet, check the structures you own, tax rates and multi
INFO: You can set up to four mark-up combinations using a percentage on total recipe/ingredients cost ais applied before the doubloons per lot-hour mark-up is added.Doubloons per lot-hour rates and are heavily influenced by the structures you own on the Settings sheet.will go down because fewer lot-hours are used. If you own a Shipyard, Large and are making a Fishing Slots but takes the same time to run the recipe. If you own a Master Shipyard, Large, the lot-hours go up leonly takes 40% of the time it does in a Fishing Lodge. Doubloons per lot-hour mark-ups are always calcuyou have not declared you own any suitable structures, the base structure is used.Doubloons per lot-hour mark-ups are applied to all the lot hours needed to make the item, including manPurchase Price.
INFO: If you purchase any items you can enter the purchase price in the list below. The main table will corecipe using that item will use the purchase price and zero labor against that ingredient.
INFO: Items with advanced recipes are in bold. Advanced recipes are used automatically if you select U
INFO: Items in red are not tradeable. This also applies in the Writs and Refits sheet.
INFO: If you use the European Traders, you can use enter your actual exchanges and your reputation onOptions below, the averaged value and labor of the exchanged items will be used instead of the direct comain table, along with the [Euro Trade] against the item name.
PurchasePrice
+200%0 db/hr
-
8/8/2019 Production Planner 2.0.48.0
14/232
Prices
Manufactured Goods
Item Base
Barrel
Beef
21 Black Powder
Blocks, Lignum Vitae
Blocks, Oak
Cannon, Huge
1,312 Cannon, Large
556 Cannon, Medium
279 Cannon, Small
77 Cannon, Swivel Gun
152 Cannon, Very Small
22 Cheese, Common
275 Cheese, Fine
Cotton, Spun
Crate of Furs
Crate of Hides from Game Animals
Crate of Hides from LivestockFish, Cured
11 Hardtack
Hemp Canvas
Hemp Rope
Ingot, Brass
Ingot, Gold
Ingot, Iron
Ingot, Silver
Leather from Game Animals
Leather from Livestock
Meat, Cured From Game Animals
Meat, Cured from Livestock
Molasses
Nails
Rum
280 Small Arms
Sugar, Refined
63 Wine, Common
744 Wine, Fine
Wood Tar
Shipwright Materials
Cannon Ammo
Consumable Items
Recruit Experts
Ship Deeds
Ship Deeds: Captured
Refit and Writ Ships
Refits
Writs
Ship Outfitting: Colossal
PurchasePrice
-
8/8/2019 Production Planner 2.0.48.0
15/232
Instructions on using this page:
Add further Output items as required.
Notes:
Output Runs Quantity Shipya
Hours
Recipe Cost
Colossal Hull
Huge Hull
Huge Square Rig
Large Fore-and-Aft Rig
Large Hull
Large Square Rig
Lineship Structure Bundle
Medium Fore-and-Aft Rig
Medium HullMedium Square Rig
Small Fore-and-Aft Rig
Small Hull
Small Square Rig
Tiny Fore-and-Aft Rig
Tiny Hull
Forge
Hours
Recipe Cost (total)
LimestoneLogs, Common Wood
Ore Copper
In the Output column, select items to be made from the drop down list. This contains all Ship Deeds,
In the Runs column, enter the number of runs of each Output recipe. Do not change any of the turquoi
The constituent ingredients, recipe costs and structure hours will be displayed in tables to the right of tThese include all sub-assemblies and their constituent parts except for Ship Deeds required as ingredi
If you already have some component parts made, you can take these into account by entering the quaIt does not matter whether you use each structure's Already Have column or the Already Have in ShiThe Already Have in Shipyard Port table has all items sorted in Inventory order.
Hours: These include the hours required for making all the constituent items, thus for a Ship Deed, the
Hours: Hours are adjusted for advanced structures, labour cost reductions and advanced recipes acc
Hours: It is strongly recommended that for Shipyard hours you declare that you own exactly one shipy
Recipe Cost: As with Hours, this includes making all constituent items. Tax and cost reduction are incl
Partial Recipes: For making constituent items, all times, costs and ingredients are for whole recipe ru
Ship Upgrades: For upgrades such as Mastercraft and Sleek ships, you will also need a deed for the
Hulls, Rigs and Lineship Structure Bundles: You can select these in the Output list. If you do, they
Lignum Vitae and Logs, Fir, Oak and Teak: Quantities in the Lumber Mill table are for the Lumber MLogs, Common Wood: The quantity required is shown only in the Forge table, even though Common
Wood Tar: The quantity required is shown only in the Miscellaneous Items table and not the Textile Mi
Assembly Yard: Recipes will be divided between Forge, Lumber Mill and Textile Mill even if you use a
Notes on using the Already Have in Shipyard Port table:
This table assumes that the Shipyard, Textile Mill and any other structure used to make outfitting are athat some outfittings are made in the Forge and Lumber Mill is generally ignored. Special arrangementAs a general rule if you use more than one port, enter quantites in the Shipyard port in this table (it is e
Ingots, Ores and Limestone: The values you enter in this table are ignored unless you select Yes for
Lignum Vitae and Logs, Fir, Oak and Teak: Quantities are accounted first against Miscellaneous Ite
Make
B
-
8/8/2019 Production Planner 2.0.48.0
16/232
Ore, Gold
Ore, Iron
Ore, Silver
Ore, Zinc
Anchor
Cannon, Huge
Cannon, Large
Cannon, MediumCannon, Small
Cannon, Swivel Gun
Cannon, Very Small
Ingot, Brass
Ingot, Gold
Ingot, Iron
Ingot, Silver
Nails
Ship Fittings, Brass
Ship Fittings, Iron
uy
Make
-
8/8/2019 Production Planner 2.0.48.0
17/232
A note to developers:
I have tried to make this page as robust as possible for future changes in recipes elsewhere in the spr
1. If an individual recipe changes on one of the recipe calculation worksheets: No change needed in S
2. If new ship or outfitting recipes are added or recipes are deleted: The Shipyard Recipes table in Dro
It does not matter how many rows of ship recipes there are so long as they all 29 rows of cells apart4: If rows are inserted or deleted from the Ship Deed worksheet, several of the formulae used in this s
3: If ship recipes are moved between rows in the Ship Deeds worksheet: The worksheet identifier (Shi
-
8/8/2019 Production Planner 2.0.48.0
18/232
Remus
-
8/8/2019 Production Planner 2.0.48.0
19/232
d Lumber Mill
0Already Have
Hours 0Already Have
0 Recipe Cost 0
0 Lignum Vitae 0
0 Logs, Fir 0
0 Logs, Oak 0
0 Logs, Teak 0
0 Blocks, Lignum Vitae 0
0 Blocks, Oak 0
0 Frame Timber, Lignum Vitae 0
0 Frame Timber, Oak 0
0 Keel Section 00 Mast Section 0
0 Planks, Oak 0
0 Planks, Teak 0
0 Ship Stem 0
0
0 Textile Mill
Hours 0Already Have
Recipe Cost 0
0Already Have
Cotton Fiber 0
0 Leather 0
0 Hemp 00 Cotton, Spun 0
0 Hemp Canvas 0
hipyard-made Shipwright Materials and Outfitting, in that order.
se cells - they will calculate automatically.
e Output list, one for each of the most important structures, plus a Miscellaneous Items table.ents - see Ship Upgrades below
ntities in the yellow cells in the Already Have columns.pyard Port table, or both (the entries are added together in the grey-coloured cells).
Shipyard Hours includes the time to make the hull and rig.
rding to the settings on the Settings and Prices sheets.
ard in the Settings sheet.
uded according to the values entered in the Settings sheet. No other mark up is applied.
s even if the recipe makes more items than are required.
ase ship. If you do already have a deed, you must add the base ship to the Output list. These shi
ill not also appear as Make quantities in the Shipyard table.
ill only. Quantities in the Miscellaneous Items table are those required by all other structures.Wood is required for a few outfittings.
ll table, even though it is needed to make rope and rigging.
n Assembly Yard. Recipe hours will be calculated for an Assembly Yard if you have one and don't
ll in one port, but the Forge and Lumber Mill may be in another - the discrepancys are made for those materials required by different structures in different ports.asier), then enter quantities in the Forge and Lumber Mill port directly in the Forge and Lumber Mil
Forge in Shipyard Port.
s. If you select Yes for Lumber Mill in Shipyard Port, any surplus will be credited to the Lumber M
Buy
M
ake
Bu
y
M
-
8/8/2019 Production Planner 2.0.48.0
20/232
-
8/8/2019 Production Planner 2.0.48.0
21/232
-
8/8/2019 Production Planner 2.0.48.0
22/232
-
8/8/2019 Production Planner 2.0.48.0
23/232
Already Have in Shipyard Port
Forge in Shipyard Port No
Lumber Mill in Shipyard Port No
Barrel 0
Black Powder 0
Blocks, Lignum Vitae 0
Blocks, Oak 0
Cannon, Huge 0
Cannon, Large 0
Cannon, Medium 0
Cannon, Small 0
Cannon, Swivel Gun 0Cannon, Very Small 0
Cheese, Fine 0
Cotton, Spun 0
Hemp Canvas 0
Hemp Rope 0
Ingot, Brass 0
Ingot, Gold 0
Ingot, Iron 0
Ingot, Silver 0
Leather 0
Nails 0Rum 0
Small Arms 0
s are marked with an asterisk.
have a specialist structure.
l tables.
ill.
-
8/8/2019 Production Planner 2.0.48.0
24/232
Wine, Fine 0
Wood Tar 0
Cotton Fiber 0
Granite 0
Hemp 0
Lignum Vitae 0
Limestone 0
Logs, Common Wood 0Logs, Fir 0
Logs, Oak 0
Logs, Teak 0
Ore, Copper 0
Ore, Gold 0
Ore, Iron 0
Ore, Silver 0
Ore, Zinc 0
Sulfur 0
Tobacco 0
Anchor 0
Colossal Hull 0
Frame Timber, Lignum Vitae 0
Frame Timber, Oak 0
Huge Hull 0
Huge Square Rig 0
Keel Section 0
Large Fore-and-Aft Rig 0
Large Hull 0
Large Square Rig 0
Lineship Structure Bundle 0
Mast Section 0
Medium Fore-and-Aft Rig 0Medium Hull 0
Medium Square Rig 0
Planks, Oak 0
Planks, Teak 0
Rigging 0
Sailcloth 0
Ship Fittings, Brass 0
Ship Fittings, Iron 0
Ship Provisioning 0
Ship Stem 0
Small Fore-and-Aft Rig 0
Small Hull 0Small Square Rig 0
Tiny Fore-and-Aft Rig 0
Tiny Hull 0
Mark of Victory 0
-
8/8/2019 Production Planner 2.0.48.0
25/232
hip Deeds the ship recipe now appears.
-
8/8/2019 Production Planner 2.0.48.0
26/232
-
8/8/2019 Production Planner 2.0.48.0
27/232
-
8/8/2019 Production Planner 2.0.48.0
28/232
-
8/8/2019 Production Planner 2.0.48.0
29/232
-
8/8/2019 Production Planner 2.0.48.0
30/232
-
8/8/2019 Production Planner 2.0.48.0
31/232
Start of Standard Recipes
Manufactured 11
Shipwright Mat 11
Item lookup Worksheet Start Row Row/Column
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothingnothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothingnothing nothing
nothing nothing
-
8/8/2019 Production Planner 2.0.48.0
32/232
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothingnothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothing
nothing nothingnothing nothing
Colossal Hull Shipwright Materials 13
Huge Hull Shipwright Materials 16
Huge Square Rig Shipwright Materials 17
Large Fore-and-Aft Rig Shipwright Materials 19
Large Hull Shipwright Materials 20
Large Square Rig Shipwright Materials 21
Lineship Structure Bundle Shipwright Materials 22
Medium Fore-and-Aft Rig Shipwright Materials 24
Medium Hull Shipwright Materials 25
Medium Square Rig Shipwright Materials 26
Small Fore-and-Aft Rig Shipwright Materials 36Small Hull Shipwright Materials 37
Small Square Rig Shipwright Materials 38
Tiny Fore-and-Aft Rig Shipwright Materials 39
Tiny Hull Shipwright Materials 40
Anchor Shipwright Materials 12
Cannon, Huge Manufactured Goods 17
Cannon, Large Manufactured Goods 18
Cannon, Medium Manufactured Goods 19
Cannon, Small Manufactured Goods 20
Cannon, Swivel Gun Manufactured Goods 21
-
8/8/2019 Production Planner 2.0.48.0
33/232
Ingot, Brass Manufactured Goods 33
Ingot, Gold Manufactured Goods 34
Ingot, Iron Manufactured Goods 35
Ingot, Silver Manufactured Goods 36
Nails Manufactured Goods 42
Ship Fittings, Brass Shipwright Materials 32
Ship Fittings, Iron Shipwright Materials 33
Blocks, Lignum Vitae Manufactured Goods 15
Blocks, Oak Manufactured Goods 16
Frame Timber, Lignum Vitae Shipwright Materials 15
Frame Timber, Oak Shipwright Materials 14
Keel Section Shipwright Materials 18
Mast Section Shipwright Materials 23
Planks, Oak Shipwright Materials 27
Planks, Teak Shipwright Materials 28
Ship Stem Shipwright Materials 35
Cotton, Spun Manufactured Goods 25
Hemp Canvas Manufactured Goods 31
Hemp Rope Manufactured Goods 32
Rigging Shipwright Materials 30
Sailcloth Shipwright Materials 31
-
8/8/2019 Production Planner 2.0.48.0
34/232
-
8/8/2019 Production Planner 2.0.48.0
35/232
Base Structure Adjusted Doubloons Taxes Adjusted Labor Shipyard h Lumber MilTextile Mill
0 0 0
-
8/8/2019 Production Planner 2.0.48.0
36/232
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 00 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
Runs Hours Recipe Co
120 6 1 0 0 0
480 24 1 0 0 0
240 12 1.2 0 0 0
240 12 3 0 0 0
150 8 2 0 0 0
120 6 2 0 0 0
-
8/8/2019 Production Planner 2.0.48.0
37/232
600 30 2 0 0 0
120 6 4 0 0 0
600 30 4 0 0 0
120 6 2 0 0 0
30 2 0.5 0 0 0
135 7 1 0 0 0
27 1 1 0 0 0
0 0
Runs Hours Recipe Co
250 13 1 0 0 0
36 2 1 0 0 0
500 25 4 0 0 0
150 8 1.5 0 0 0
150 8 2 0 0 0
50 3 3 0 0 0
45 2 0.5 0 0 0
150 8 1 0 0 0
50 3 2 0 0 0
0 0
Runs Hours Recipe Co
90 5 1 0 0 0
75 4 3 0 0 0
30 2 1 0 0 0
40 2 1 0 0 0
100 5 1 0 0 0
0 0
-
8/8/2019 Production Planner 2.0.48.0
38/232
-
8/8/2019 Production Planner 2.0.48.0
39/232
Forge hourShipyard reLumber MilTextile Mill Forge recipAnchor Barrel Black Pow Ship Fitting
0 0 0 0 0 0 0 0 0
-
8/8/2019 Production Planner 2.0.48.0
40/232
0
0
0
0
0
0
0
0
0
0
00
0
0
0
Ingot, BrasIngot, Iron Limestone Logs, ComLogs, TeakOre, Copp Ore, Gold Ore, Iron Ore, Silver
-
8/8/2019 Production Planner 2.0.48.0
41/232
0 0 0 0 0 0 0 0 0
Lignum Vit Logs, Fir Logs, Oak Logs, Teak
0 0 0 0
Cotton Fib Leather Hemp Blocks, OaWood Tar Hemp Can Hemp Rope
0 0 0 0 0 0 0
-
8/8/2019 Production Planner 2.0.48.0
42/232
-
8/8/2019 Production Planner 2.0.48.0
43/232
Cannon, H Cannon, L Cannon, MCannon, S Cannon, S Cannon, V Cheese, FiColossal H Cotton, Sp
0 0 0 0 0 0 0 0 0
-
8/8/2019 Production Planner 2.0.48.0
44/232
-
8/8/2019 Production Planner 2.0.48.0
45/232
-
8/8/2019 Production Planner 2.0.48.0
46/232
-
8/8/2019 Production Planner 2.0.48.0
47/232
Frame Tim Frame Tim Granite Hemp Can Hemp Rop Huge Hull Huge SquaIngot, BrasIngot, Cop
0 0 0 0 0 0 0 0 0
-
8/8/2019 Production Planner 2.0.48.0
48/232
-
8/8/2019 Production Planner 2.0.48.0
49/232
-
8/8/2019 Production Planner 2.0.48.0
50/232
-
8/8/2019 Production Planner 2.0.48.0
51/232
-
8/8/2019 Production Planner 2.0.48.0
52/232
-
8/8/2019 Production Planner 2.0.48.0
53/232
-
8/8/2019 Production Planner 2.0.48.0
54/232
-
8/8/2019 Production Planner 2.0.48.0
55/232
-
8/8/2019 Production Planner 2.0.48.0
56/232
-
8/8/2019 Production Planner 2.0.48.0
57/232
-
8/8/2019 Production Planner 2.0.48.0
58/232
-
8/8/2019 Production Planner 2.0.48.0
59/232
Medium HuMedium SqNails Blocks, Oa Planks, Oa Planks, Te Rigging Rum Sailcloth
0 0 0 0 0 0 0 0 0
-
8/8/2019 Production Planner 2.0.48.0
60/232
-
8/8/2019 Production Planner 2.0.48.0
61/232
-
8/8/2019 Production Planner 2.0.48.0
62/232
-
8/8/2019 Production Planner 2.0.48.0
63/232
Ship ProvisShip Stem Small Arm Small Fore Small Hull Small Squ Sulfur Tiny Fore- Tiny Hull
0 0 0 0 0 0 0 0 0
-
8/8/2019 Production Planner 2.0.48.0
64/232
-
8/8/2019 Production Planner 2.0.48.0
65/232
-
8/8/2019 Production Planner 2.0.48.0
66/232
-
8/8/2019 Production Planner 2.0.48.0
67/232
Tobacco Wine, Fine Wood Tar Anchor Barrel Black Pow Ship FittingCannon, H
0 0 0
-
8/8/2019 Production Planner 2.0.48.0
68/232
#N/A #N/A #N/A 0 #N/A
#N/A #N/A #N/A 0 #N/A
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A 0 #N/A
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A
Ingot, BrasIngot, Iron Limestone Logs, Com Logs, Teak
#N/A 0 #N/A #N/A #N/A
0 0 #N/A #N/A 0
0 0 #N/A 0 #N/A
#N/A 0 #N/A 0 #N/A
#N/A 0 #N/A 0 #N/A
#N/A 0 #N/A #N/A #N/A
-
8/8/2019 Production Planner 2.0.48.0
69/232
#N/A #N/A #N/A
#N/A #N/A #N/A
0 #N/A #N/A
#N/A #N/A #N/A
#N/A 0 #N/A #N/A #N/A
0 #N/A #N/A #N/A #N/A
#N/A 0 #N/A #N/A #N/A
Lignum Vit Logs, Fir Logs, Oak Logs, Teak
0 #N/A #N/A #N/A
#N/A #N/A 0 #N/A
0 #N/A #N/A #N/A
#N/A #N/A 0 #N/A
#N/A #N/A 0 #N/A
#N/A 0 #N/A #N/A
#N/A #N/A 0 #N/A
#N/A #N/A #N/A 0
#N/A #N/A 0 #N/A
Cotton Fib Leather Hemp Blocks, OaWood Tar
0 #N/A #N/A #N/A #N/A
#N/A #N/A 0 #N/A #N/A
#N/A #N/A 0 #N/A 0
#N/A 0 #N/A 0 #N/A
#N/A #N/A #N/A #N/A #N/A
-
8/8/2019 Production Planner 2.0.48.0
70/232
-
8/8/2019 Production Planner 2.0.48.0
71/232
Cannon, L Cannon, MCannon, S Cannon, S Cannon, V Cheese, FiColossal HCotton, Sp Frame Tim
-
8/8/2019 Production Planner 2.0.48.0
72/232
#N/A #N/A #N/A #N/A #N/A #N/A #N/A 0
#N/A #N/A #N/A #N/A #N/A #N/A #N/A 0
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
Ore, Copp Ore, Gold Ore, Iron Ore, Silver Ore, Zinc
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A
-
8/8/2019 Production Planner 2.0.48.0
73/232
0 #N/A #N/A #N/A 0
#N/A 0 #N/A #N/A #N/A
#N/A #N/A 0 #N/A #N/A
#N/A #N/A #N/A 0 #N/A
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A
Hemp Can Hemp Rope
#N/A #N/A
#N/A 0
0 #N/A
-
8/8/2019 Production Planner 2.0.48.0
74/232
-
8/8/2019 Production Planner 2.0.48.0
75/232
Frame Tim Granite Hemp Can Hemp Rop Huge Hull Huge SquaIngot, BrasIngot, Cop Ingot, Gold
-
8/8/2019 Production Planner 2.0.48.0
76/232
0 #N/A #N/A #N/A #N/A #N/A #N/A
0 #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
0 #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
0 #N/A 0 0 #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
0 #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A0 #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
0 #N/A #N/A #N/A #N/A #N/A #N/A
-
8/8/2019 Production Planner 2.0.48.0
77/232
-
8/8/2019 Production Planner 2.0.48.0
78/232
-
8/8/2019 Production Planner 2.0.48.0
79/232
Ingot, Iron Ingot, SilveShip FittingKeel SectioLarge ForeLarge Hull Large Squ Lignum Vit Blocks, Lig
-
8/8/2019 Production Planner 2.0.48.0
80/232
#N/A #N/A 0 0 #N/A #N/A
#N/A #N/A 0 0 #N/A #N/A
#N/A #N/A 0 #N/A #N/A 0
#N/A #N/A 0 #N/A #N/A 0
#N/A #N/A 0 0 #N/A #N/A
#N/A #N/A 0 #N/A #N/A #N/A
#N/A #N/A 0 #N/A #N/A 0
#N/A #N/A 0 #N/A #N/A #N/A
#N/A #N/A 0 0 #N/A #N/A
#N/A #N/A 0 #N/A #N/A #N/A
#N/A #N/A 0 #N/A #N/A #N/A#N/A #N/A 0 0 #N/A #N/A
#N/A #N/A 0 #N/A #N/A #N/A
#N/A #N/A 0 #N/A #N/A #N/A
#N/A #N/A 0 0 #N/A #N/A
-
8/8/2019 Production Planner 2.0.48.0
81/232
-
8/8/2019 Production Planner 2.0.48.0
82/232
-
8/8/2019 Production Planner 2.0.48.0
83/232
Lineship StLogs, Com Logs, Fir Logs, Oak Logs, TeakMark of VicMast Secti Medium FoMedium H
-
8/8/2019 Production Planner 2.0.48.0
84/232
#N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A 0
#N/A #N/A #N/A #N/A #N/A 0
#N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A 0
#N/A 0 0 0 #N/A #N/A
#N/A #N/A #N/A #N/A #N/A 0
#N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A 0
#N/A #N/A #N/A #N/A #N/A 0#N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A 0
#N/A #N/A #N/A #N/A #N/A 0
#N/A #N/A #N/A #N/A #N/A #N/A
-
8/8/2019 Production Planner 2.0.48.0
85/232
-
8/8/2019 Production Planner 2.0.48.0
86/232
-
8/8/2019 Production Planner 2.0.48.0
87/232
Medium SqNails Blocks, Oa Planks, Oa Planks, Te Rigging Rum Sailcloth Ship Provi
-
8/8/2019 Production Planner 2.0.48.0
88/232
0 #N/A 0 0 #N/A #N/A #N/A #N/A
0 #N/A 0 0 #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A 0 #N/A 0 #N/A
#N/A #N/A #N/A #N/A 0 #N/A 0 #N/A
0 #N/A 0 #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A 0 #N/A 0 #N/A
#N/A 0 0 0 #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A 0 #N/A 0 #N/A
0 #N/A 0 #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A 0 #N/A 0 #N/A
#N/A #N/A #N/A #N/A 0 #N/A 0 #N/A0 #N/A 0 #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A 0 #N/A 0 #N/A
#N/A #N/A #N/A #N/A 0 #N/A 0 #N/A
0 #N/A 0 #N/A #N/A #N/A #N/A #N/A
-
8/8/2019 Production Planner 2.0.48.0
89/232
-
8/8/2019 Production Planner 2.0.48.0
90/232
-
8/8/2019 Production Planner 2.0.48.0
91/232
Ship Stem Small Arm Small ForeSmall Hull Small Squ Sulfur Tiny Fore- Tiny Hull Tobacco
-
8/8/2019 Production Planner 2.0.48.0
92/232
0 #N/A #N/A #N/A
0 #N/A #N/A #N/A
#N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A
0 #N/A #N/A #N/A
#N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A
0 #N/A #N/A #N/A
#N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A0 #N/A #N/A #N/A
#N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A
0 #N/A #N/A #N/A
-
8/8/2019 Production Planner 2.0.48.0
93/232
-
8/8/2019 Production Planner 2.0.48.0
94/232
-
8/8/2019 Production Planner 2.0.48.0
95/232
Wine, Fine Wood Tar
-
8/8/2019 Production Planner 2.0.48.0
96/232
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
-
8/8/2019 Production Planner 2.0.48.0
97/232
-
8/8/2019 Production Planner 2.0.48.0
98/232
-
8/8/2019 Production Planner 2.0.48.0
99/232
Instructions on using this page:
This sheet enables you to plan your production using almost any combination of structu
This sheet lists every structure except for the Careening Camp and Shipyards.
For each structure, every recipe is listed except for ships, outfittings and gravel. You sh
Take care to only change Yellow, Orange (drop down list) and Red or Green (Yes/No d
If the time taken for all the recipe runs exceeds the Time Period for a structure, the num
Time Period
Use Same Time Period for all Structures? Yes 168Time Period 1 Weeks
SUMMARY
TRADING PROFIT
PLANTATIONS except SUGAR
HUNTING AND FISHING LODGES
PASTURE, SLAUGHTERHOUSE and TANNER
WOOD CAMPS and TAR DISTILLERY
SALTPETER CAVES, SULFUR MINE and POWDER MILL
METAL MINES, LIMESTONE QUARRY and FORGE
GRANITE and MARBLE QUARRY
LUMBER MILL
TEXTILE MILL
VINEYARD and WINERY
SUGAR PLANTATION and SUGAR REFINERY
PROVISIONER and RECRUITMENT OFFICE
The Time Period can be set either the same for all structures or each structure can beRaw Materials structures running only one recipe (ignoring gravel) are assumed to be 1
The Output Quantity always displays the quantity actually produced by that recipe, ev
Need displays the total quantity or an item needed by all the recipes being run in that s
Have is affected by what other structures also use that material. If an item is used by m
Recipe Cost includes Tax and Port Governor-applied Doubloon Cost Reductions.
Unused Recipe Hours are not the same as actual hours as they are affected by the L
Advanced Recipes are automatically used if selected in the Settings box. The setting i
Taxes and Port Governor-applied Labor and Cost Reductions can each be applied
-
8/8/2019 Production Planner 2.0.48.0
100/232
EURO TRADES
Calculation Data
-
8/8/2019 Production Planner 2.0.48.0
101/232
-
8/8/2019 Production Planner 2.0.48.0
102/232
res, with items made in one structure automatically being transferred to another structu
ould use the Shipyard Planner sheet for ships and outfittings.
rop down list) cells. The Turquoise cells display calculated values. Many of the Grey cel
ber of runs of each recipe will be adjusted downwards in proportion to fit within the Tim
Settings
Use Advanced Recipes? No Fixed ValueTax Rates Use Settings Sheet 5
Labor Cost Reductions Use Settings Sheet 0
Doubloon Cost Reductions Use Settings Sheet 0
Number of Structures Used: Cost:
Number of Structures Used: Cost:
Number of Structures Used: 5 Cost: 18598
Number of Structures Used: Cost:
Number of Structures Used: Cost:
Number of Structures Used: Cost:
Number of Structures Used: 1 Cost: 3440
Number of Structures Used: Cost:
Number of Structures Used: Cost:
Number of Structures Used: Cost:
Number of Structures Used: Cost:
Number of Structures Used: Cost:
set individually. Use Same Time Period for all Structures is recommended if you are00% utilised throughout the time period. For all other structures, enter the number ofru
n if some or all of the production is then used in another recipe.
ructure. In the Production Summary tables, Need is the total quantity needed in all reci
ore than one structure, any surplus gets used by each structure in turn. See the comme
bor Modifier for advanced structures and Labor Cost Reductions. There may be unexp
n the Prices sheet is ignored in this sheet.
in three ways: (i) None, (ii) a Fixed Value that applies throughout this sheet, (iii) the Sett
-
8/8/2019 Production Planner 2.0.48.0
103/232
-
8/8/2019 Production Planner 2.0.48.0
104/232
-
8/8/2019 Production Planner 2.0.48.0
105/232
e where they are used.
ls contain hidden formulae.
Period.
Unused Recipe Hours: Lot-Hours:
Unused Recipe Hours: Lot-Hours:
Unused Recipe Hours: 336 Lot-Hours: 336
Unused Recipe Hours: Lot-Hours:
Unused Recipe Hours: Lot-Hours:
Unused Recipe Hours: Lot-Hours:
Unused Recipe Hours: Lot-Hours:
Unused Recipe Hours: Lot-Hours:
Unused Recipe Hours: Lot-Hours:
Unused Recipe Hours: Lot-Hours:
Unused Recipe Hours: Lot-Hours:
Unused Recipe Hours: Lot-Hours:
orking out an entire production line. ns you wish to make of each recipe.
es run in all structures.
nts (red triangle) in the relevant cells.
cted Unused Recipe Hours due to rounding.
ings Sheet values.
-
8/8/2019 Production Planner 2.0.48.0
106/232
-
8/8/2019 Production Planner 2.0.48.0
107/232
-
8/8/2019 Production Planner 2.0.48.0
108/232
-
8/8/2019 Production Planner 2.0.48.0
109/232
-
8/8/2019 Production Planner 2.0.48.0
110/232
-
8/8/2019 Production Planner 2.0.48.0
111/232
Euro_Trades
European Traders
Mark-Ups
percent (%)db / lot hour
British Trader ReputationRosignol / Port Royal Indifferent
Dutch Trader ReputationOranjestad / Tortuga Indifferent
French Trader ReputationPointe-a-Pitre / Pensacola Indifferent
Spanish Trader ReputationSan Juan / Barilla Indifferent
Calculation Table
IMPORTANT:Values and Costs are calculated using the Tax Rates and the Double Output Recipe Calculations in the Settings sheet.IMPORTANT: Enter Percentage and Doubloon per lot-hour Mark-ups in the table below. These will be used to calculate Cost Per fromIMPORTANT: Trading and Cost Per from Manufacturing. They do not effect the Euro Trader calculations in the Prices sheet.
Turn-
ins
Turn
-ins
Turn
-ins
Turn
-in
s
-
8/8/2019 Production Planner 2.0.48.0
112/232
Commendation Exchange
Page 112 of 232
Commendation Exchanges
Mark-Ups
percent (%) 0
db / lot hour
Commendation Exchange (Nationals)
Quartermaster (Pirates)
IMPORTANT: Values are calculated using the Tax Rates selected in the 'Settings' tab.IMPORTANT: Enter Percentage and Doubloon per lot-hour Mark-ups in the table below. These will be used toIMPORTANT: calculate Values
-
8/8/2019 Production Planner 2.0.48.0
113/232
Ship Deed Base Deed Cost
'Abaddon's Will' Refit Galleon 'San Mateo' Galleon (Captured) 2,4
'Abaddon's Will' Refit Galleon (CT Mags) 'San Mateo' Galleon (Captured) 2,4
'Achilles' Privateer Frigate 'Myrmidon' Frigate 31,0
'Archelon' Frigate 'Deliverance' Frigate 27,6
'Arrow' Privateer Frigate 'Cerberus' Frigate 10,1'Bahamut' Refit Bark 'Leviathan' Bark (Captured) 3,1
'Bahamut' Refit Bark (Bucc Mags) 'Leviathan' Bark (Captured) 3,1
'Bloody Dagger' Refit Frigate 'Defiant' Frigate (Captured) 1,8
'Couronne' Galleon 'Couronne' Galleon, Uncertified Deed 1,623,0
'Couronne' Galleon (FT Mags) 'Couronne' Galleon, Uncertified Deed 1,623,0
'Cursed Blade' Refit Frigate 'Myrmidon' Frigate (Captured) 1,9
'Discovery' Privateer Frigate 'Raa' Frigate 13,2
'Discovery' Privateer Frigate (Priv Mags) 'Raa' Frigate 13,2
'Dromedary' Hellbrand Indiaman 'Dromedary' Indiaman 4,9
'Expedition' Privateer Packet-Boat 'Hermes' Packet-Boat 4,7
'Falcon' Naval Frigate 'Stralsund' Frigate 12,0
'Fallen' Refit Snow 'Curieuse' Snow (Captured) 7
'Gallant' Naval Frigate 'Defiant' Frigate 31,8
'Gallant' Naval Frigate (NO Mags) 'Defiant' Frigate 31,8
'Hercules' Heavy Frigate 'Hercules' Heavy Frigate, Uncertified Deed 366,5'Hercules' Heavy Frigate (Bucc Mags) 'Hercules' Heavy Frigate, Uncertified Deed 366,5
'Hercules' Mastercraft Frigate 'Hercules' Mastercraft Frigate, Uncertified Deed 1,135,5
'Hercules' Pirate Frigate 'Hercules' Pirate Frigate, Uncertified Deed 1,099,3
'Hercules' Sleek Frigate 'Hercules' Sleek Frigate, Uncertified Deed 363,5
'Hercules' Sleek Frigate (Priv / CT Mags) 'Hercules' Sleek Frigate, Uncertified Deed 363,5
'Hyperion' Refit Frigate 'Poseidon' Fourth Rate 469,1
'Intrepid' Privateer Frigate 'Capricieux' Mastercraft Frigate 58,6
'Intrepid' Privateer Frigate (Priv Mags) 'Capricieux' Mastercraft Frigate 58,6
'Khan' Flute 'Sultan' Flute 15,7
'Lancer' Naval Cutter 'Mediator' Cutter 4,0
'Macedon' Hunter's Fourth Rate 'Alexander' Fourth Rate 93,1
'Mercy' Naval Frigate 'Defiant' Mastercraft Frigate 59,8
'Mercy' Naval Frigate (NO Mags) 'Defiant' Mastercraft Frigate 59,8
'Monarch' Indiaman 'Mignone' Indiaman 15,0
'Mont Blanc' Indiaman 'Oliphant' Mastercraft Indiaman 59,4'Neptune's Disgrace' Refit Galleon 'Santiago' Galleon (Captured) 1,3
'Neptune's Disgrace' Refit Galleon (Pirate Mags) 'Santiago' Galleon (Captured) 1,3
'Reaper's Grasp' Refit Bark 'Agamemnon' Bark (Captured) 1,3
'Reason' Naval Fourth Rate 'Mordaunt' Fourth Rate 73,2
'Red Devil' Xebec 'Arcadia' Mastercraft Xebec (Captured) 2,4
'San Mateo' Heavy Galleon 'San Mateo' Heavy Galleon, Uncertified Deed 358,5
'San Mateo' Heavy Galleon (FT Mags) 'San Mateo' Heavy Galleon, Uncertified Deed 358,5
'San Mateo' Trader's Galleon 'San Mateo' Trader's Galleon, Uncertified Deed 516,2
'San Mateo' Trader's Galleon (FT Mags) 'San Mateo' Trader's Galleon, Uncertified Deed 516,2
'Treason' Pirate Flagship 'Wenden' Third Rate, Uncertified Deed 2,895,7
'Trinidad' Frigate 'Conquistador' Frigate 28,6
'Valiant' Third Rate 'Valiant' Third Rate, Uncertified Deed 1,189,3
'Valiant' Third Rate (NO Mags) 'Valiant' Third Rate, Uncertified Deed 1,189,3
'Wenden' Third Rate 'Wenden' Third Rate, Uncertified Deed 2,895,7
Refit
Refit: Buccaneer 'Leviathan' Bark (Captured)
Refit: Buccaneer 'Leviathan' Bark (Captured) (Bucc Mags)
Refit: Buccaneer 'Poseidon' Fourth Rate
Refit: Buccaneer 'Wenden' Third Rate
Refit: 'Conquistador' Frigate
Refit: Cutthroat 'Arcadia' Mastercraft Xebec (Captured)
Refit: Cutthroat 'Defiant' Frigate (Captured)
Refit: 'Deliverance' Frigate
Refit: Freetrader 'Dromedary' Indiaman
Refit: Freetrader 'Mignone' Indiaman
Refit: Freetrader 'Oliphant' Mastercraft Indiaman
Refit: Freetrader 'Sultan' Flute
Refit: Naval 'Alexander' Fourth RateRefit: Naval 'Defiant' Frigate
Refit: Naval 'Defiant' Frigate (NO Mags)
Refit: Naval 'Defiant' Mastercraft Frigate
-
8/8/2019 Production Planner 2.0.48.0
114/232
Writ
Writ 'Couronne' Galleon
Writ 'Couronne' Galleon (FT Mags)
Writ 'Hercules' Heavy Frigate
Writ 'Hercules' Heavy Frigate (Bucc Mags)Writ 'Hercules' Mastercraft Frigate
Writ 'Hercules' Pirate Frigate
Writ 'Hercules' Sleek Frigate
Writ 'Hercules' Sleek Frigate (Priv / CT Mags)
Writ 'Invincible' First Rate
Writ 'Prince' First Rate
Writ 'San Mateo' Heavy Galleon
Writ 'San Mateo' Heavy Galleon (FT Mags)
Writ 'San Mateo' Trader's Galleon
Writ 'San Mateo' Trader's Galleon (FT Mags)
Writ 'Trinity' Second Rate
Writ 'Triumphant' Second Rate
Writ 'Valiant' Third Rate
Writ 'Valiant' Third Rate (NO Mags)
Writ 'Wenden' Third Rate
-
8/8/2019 Production Planner 2.0.48.0
115/232
-
8/8/2019 Production Planner 2.0.48.0
116/232
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.000.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
-
8/8/2019 Production Planner 2.0.48.0
117/232
Bob the Buil
Structure Setup
Structure 1 Pasture
Structure 2 Pasture
Structure 3 Slaughterhouse
Structure 4 Tanner
Structure 5 Tanner
Structure 6
Structure 7
Structure 8
Structure 9
Structure 10
Mark-Ups
percent (%) 50
db / lot hour
INFO: This tool is to help you in building structures. Choose structures under "be calculated. Base costs of structure deeds and ingredients are calculated incan apply Mark-Ups by entering values in the Mark-Ups table. These are appli
-
8/8/2019 Production Planner 2.0.48.0
118/232
er
MaterialsItem Quantity
Granite 15
Gravel 24
Hemp Rope 0
Ingot, Brass 0
Ingot, Iron 3
Ingot, Silver 0
Leather 0
Blocks, Lignum Vitae 0
Limestone 0
Livestock 20
Logs, Common Wood 50
Logs, Oak 0Logs, Teak 0
Marble 0
Blocks, Oak 0
Ore, Copper 0
Costs
Building Fee 5000
Ingredient Costs 1642
Deed Costs 1144
Grand Total7786
Structure Setup" and all the building materials and costs willexactly the same way as they are in the Prices sheet. Youed to both the structure deed and the materials.
-
8/8/2019 Production Planner 2.0.48.0
119/232
1/17/2011
## Society Eco##
So
So
M
Eco
INFO: Within "Society Economy Administration" you can keep track of the structures that arand alter the details of each economy setup. Please have a closer look at the comments to get
INFO: In the "Society Orders" table you can keep track of any orders you get - either from socrecipes, purchase prices and use of Euro trades selected in the Settings and Prices tabs.
INFO: If you keep any items in stock for other people, for example for your society mates, you
INFO: The ingame society list is not that powerfull, as everybody should have realized allrea
INFO: Within the "Econ Lot Trading" section you can keep track of any information needed, ifoffering to produce on a specific server for another person while he is running his slots at yourcontact with all the players you are sharing with.
-
8/8/2019 Production Planner 2.0.48.0
120/232
-
8/8/2019 Production Planner 2.0.48.0
121/232
-
8/8/2019 Production Planner 2.0.48.0
122/232
omy Administration
iety Orders
ciety Stock
ember List
Lot Trading
available within your society. You can expand this table using the buttons on the left hand side, to seedetailed information regarding the all the functions.
iety members or other players. Note: All prices are calculated using the structures, tax rates, advanced
an use the "Society Stock" table to keep track of it.
y. The "Member List" table should help larger society to keep track of the members and all their toons.
you "share" economy slots with players from other servers. Sharing economy slots means you areserver for you. We recommend to use XFIRE (www.xfire.com) or another instant messanger to keep in
-
8/8/2019 Production Planner 2.0.48.0
123/232
-
8/8/2019 Production Planner 2.0.48.0
124/232
-
8/8/2019 Production Planner 2.0.48.0
125/232
-
8/8/2019 Production Planner 2.0.48.0
126/232
-
8/8/2019 Production Planner 2.0.48.0
127/232
-
8/8/2019 Production Planner 2.0.48.0
128/232
Structure Upkeep/Week Lots Used Labor Multiplier Port Reso
Advanced Forge 400 1 0.80 River
Advanced Logging Camp, Ironwood 400 1 0.80 River & Fo
Advanced Logging Camp, Oak 200 1 0.80 River & Fo
Advanced Logging Camp, Teak 400 1 0.80 River & Fo
Advanced Lumber Mill 200 1 0.80 River
Advanced Mine, Copper 200 1 0.80 River & Co
Advanced Mine, Gold 1,000 1 0.80 River & Go
Advanced Mine, Iron 400 1 0.80 River & Iro
Advanced Mine, Zinc 400 1 0.80 River & Zin
Advanced Plantation, General 200 1 0.80 River & Fe
Advanced Plantation, Sugar 400 1 0.80 River & Fe
Advanced Quarry, Granite 200 1 0.80 River & Gr
Advanced Quarry, Limestone 200 1 0.80 River & LimAdvanced Quarry, Marble 400 1 0.80 River & Ma
Advanced Shipyard, Medium 800 2 0.80 River & Na
Advanced Shipyard, Small 400 1 0.80 River
Advanced Sugar Refinery 400 1 0.80 River
Advanced Textile Mill 400 1 0.80 River
Assembly Yard 1,000 1 1.00 River
Careening Camp 400 2 1.00
Draughtsman's Office 100 1 1.00
Fishing Lodge 200 1 1.00
Forge 400 1 1.00
Hunting Lodge 200 1 1.00 Abundant G
Logging Camp, Fir 200 1 1.00 Forest, Fir
Logging Camp, Ironwood 400 1 1.00 Forest, Iron
Logging Camp, Oak 200 1 1.00 Forest, Oa
Logging Camp, Teak 400 1 1.00 Forest, TeaLumber Mill 200 1 1.00
Master Draughtsman's Office 200 1 1.00
Master Shipyard, Large 25,000 4 0.40 Deep Natu
Mine, Copper 200 1 1.00 Copper De
Mine, Gold 1,000 1 1.00 Gold Depo
Mine, Iron 400 1 1.00 Iron Depos
Mine, Silver 400 1 1.00 Silver Dep
Mine, Sulfur 400 1 1.00 Sulfur Dep
Mine, Zinc 400 1 1.00 Zinc Depos
Pasture 200 1 1.00 Fertile Soil
Plantation, Cacao 200 1 1.00 Fertile Soil
Plantation, Coffee 400 1 1.00 Fertile Soil
Plantation, Cotton 200 1 1.00 Fertile Soil
Plantation, General 200 1 1.00 Fertile Soil
Plantation, Prickly Pear 400 1 1.00 Fertile SoilPlantation, Sugar 400 1 1.00 Fertile Soil
Plantation, Tobacco 400 1 1.00 Fertile Soil
Powder Mill 400 1 1.00
Provisioner 200 1 1.00
Quarry, Granite 200 1 1.00 Granite
Quarry, Limestone 200 1 1.00 Limestone
Quarry, Marble 400 1 1.00 Marble De
Recruitment Office 100 1 1.00
Saltpeter Caves 200 1 1.00 Guano Cav
Shipyard, Large 1,200 3 1.00 Deep Natu
Shipyard, Medium 800 2 1.00 Natural Ha
Shipyard, Small 400 1 1.00
Slaughterhouse 200 1 1.00
Sugar Refinery 400 1 1.00
Tanner 200 1 1.00
Tar Distillery 200 1 1.00
Textile Mill 200 1 1.00
-
8/8/2019 Production Planner 2.0.48.0
129/232
Recipe Output Quantity Base Struc
Draft Advanced Forge Plans Deed: Advanced Forge 1 Master Draughtsman's
Draft Advanced Ironwood Logging Camp Plans Deed: Advanced Logging Camp, Ironwood 1 Master Draughtsman'
Draft Advanced Oak Logging Camp Plans Deed: Advanced Logging Camp, Oak 1 Master Draughtsman's
Draft Advanced Teak Logging Camp Plans Deed: Advanced Logging Camp, Teak 1 Master Draughtsman's
Draft Advanced Lumber Mill Plans Deed: Advanced Lumber Mill 1 Master Draughtsman's
Draft Advanced Copper Mine Plans Deed: Advanced Mine, Copper 1 Master Draughtsman's
Draft Advanced Gold Mine Plans Deed: Advanced Mine, Gold 1 Master Draughtsman's
Draft Advanced Iron Mine Plans Deed: Advanced Mine, Iron 1 Master Draughtsman's
Draft Advanced Zinc Mine Plans Deed: Advanced Mine, Zinc 1 Master Draughtsman's
Draft Advanced Plantation Plans Deed: Advanced Plantation, General 1 Master Draughtsman's
Draft Advanced Sugar Plantation Plans Deed: Advanced Plantation, Sugar 1 Master Draughtsman's
Draft Advanced Granite Quarry Plans Deed: Advanced Quarry, Granite 1 Master Draughtsman's
Draft Advanced Limestone Quarry Plans Deed: Advanced Quarry, Limestone 1 Master Draughtsman's
Draft Advanced Marble Quarry Plans Deed: Advanced Quarry, Marble 1 Master Draughtsman's
Draft Advanced Medium Shipyard Plans Deed: Advanced Shipyard, Medium 1 Master Draughtsman's
Draft Advanced Small Shipyard Plans Deed: Advanced Shipyard, Small 1 Master Draughtsman's
Draft Advanced Sugar Refinery Plans Deed: Advanced Sugar Refinery 1 Master Draughtsman's
Draft Advanced Textile Mill Plans Deed: Advanced Textile Mill 1 Master Draughtsman's
Draft Assembly Yard Plans Deed: Assembly Yard 1 Master Draughtsman's
Draft Draughtsman's Office Plans Deed: Draughtsman's Office 1 Draughtsman's OfficeDraft Fishing Lodge Plans Deed: Fishing Lodge 1 Draughtsman's Office
Draft Forge Plans Deed: Forge 1 Draughtsman's Office
Draft Hunting Lodge Plans Deed: Hunting Lodge 1 Draughtsman's Office
Draft Fir Logging Camp Plans Deed: Logging Camp, Fir 1 Draughtsman's Office
Draft Ironwood Logging Camp Plans Deed: Logging Camp, Ironwood 1 Draughtsman's Office
Draft Oak Logging Camp Plans Deed: Logging Camp, Oak 1 Draughtsman's Office
Draft Teak Logging Camp Plans Deed: Logging Camp, Teak 1 Draughtsman's Office
Draft Lumber Mill Plans Deed: Lumber Mill 1 Draughtsman's Office
Draft Master Draughtsman's Office Plans Deed: Master Draughtsman's Office 1 Draughtsman's Office
Draft Master Large Shipyard Plans Deed: Master Shipyard, Large 1 Master Draughtsman's
Draft Copper Mine Plans Deed: Mine, Copper 1 Draughtsman's Office
Draft Gold Mine Plans Deed: Mine, Gold 1 Draughtsman's Office
Draft Iron Mine Plans Deed: Mine, Iron 1 Draughtsman's Office
Draft Silver Mine Plans Deed: Mine, Silver 1 Draughtsman's Office
Draft Sulfur Excavation Plans Deed: Mine, Sulfur 1 Draughtsman's OfficeDraft Zinc Mine Plans Deed: Mine, Zinc 1 Draughtsman's Office
Draft Pasture Plans Deed: Pasture 1 Draughtsman's Office
Draft Cacao Plantation Plans Deed: Plantation, Cacao 1 Draughtsman's Office
Draft Coffee Plantation Plans Deed: Plantation, Coffee 1 Draughtsman's Office
Draft Cotton Plantation Plans Deed: Plantation, Cotton 1 Draughtsman's Office
Draft Plantation Plans Deed: Plantation, General 1 Draughtsman's Office
Draft Cochineal Harvest Plans Deed: Plantation, Prickly Pear 1 Draughtsman's Office
Draft Sugar Plantation Plans Deed: Plantation, Sugar 1 Draughtsman's Office
Draft Tobacco Plantation Plans Deed: Plantation, Tobacco 1 Draughtsman's Office
Draft Powder Mill Plans Deed: Powder Mill 1 Master Draughtsman's
Draft Provisioner Plans Deed: Provisioner 1 Draughtsman's Office
Draft Granite Quarry Plans Deed: Quarry, Granite 1 Draughtsman's Office
Draft Limestone Quarry Plans Deed: Quarry, Limestone 1 Draughtsman's Office
Draft Marble Quarry Plans Deed: Quarry, Marble 1 Draughtsman's Office
Draft Recruitment Office Plans Deed: Recruitment Office 1 Draughtsman's OfficeDraft Saltpeter Harvest Plans Deed: Saltpeter Caves 1 Draughtsman's Office
Draft Large Shipyard Plans Deed: Shipyard, Large 1 Master Draughtsman's
Draft Medium Shipyard Plans Deed: Shipyard, Medium 1 Master Draughtsman's
Draft Small Shipyard Plans Deed: Shipyard, Small 1 Draughtsman's Office
Draft Slaughterhouse Plans Deed: Slaughterhouse 1 Draughtsman's Office
Draft Sugar Refinery Plans Deed: Sugar Refinery 1 Master Draughtsman's
Draft Tannery Plans Deed: Tanner 1 Draughtsman's Office
Draft Tar Distillery Plans Deed: Tar Distillery 1 Draughtsman's Office
Draft Textile Mill Plans Deed: Textile Mill 1 Master Draughtsman's
Draft Vineyard Plans Deed: Vineyard 1 Draughtsman's Office
Draft Winery Plans Deed: Winery 1 Master Draughtsman's
Draft Cochineal Harvest Plans Deed: Plantation, Prickly Pear 1 Draughtsman's Office
-
8/8/2019 Production Planner 2.0.48.0
130/232
Advanced Recipe Output #1 Quantity Output #2 Qty Base Structure
Advanced Lignum Vitae Harvest Lignum Vitae 10 Logging Camp, Ironwood Loggi
Advanced Teak Harvest Logs, Teak 10 Logging Camp, Teak Loggi
Advanced Gold Mining Ore, Gold 10 Mine, Gold Mine,
Advanced Zinc Mining Ore, Zinc 10 Mine, Zinc Mine,
Advanced Sugarcane Harvest Sugarcane 10 Plantation, Sugar PlantaRecipe Output #1 Quantity Output #2 Qty Base Structure
Harvest Cacao Cacao 10 Plantation, Cacao Planta
Harvest Cochineal Cochineal 5 Plantation, Prickly Pear Planta
Harvest Coffee Coffee 5 Plantation, Coffee Planta
Harvest Cotton Cotton Fiber 10 Plantation, Cotton Planta
Net Fish Fish, Fresh 10 Fishing Lodge Fishin
Hunt Game Game Animals 8 Hunting Lodge Hunti
Quarry Granite Granite 5 Gravel 1 Quarry, Granite Quarr
Excavate Gravel Gravel 5 Quarry, Limestone Quarr
Harvest Hemp Hemp 10 Plantation, General Planta
Harvest Lignum Vitae Lignum Vitae 10 Logging Camp, Ironwood Loggi
Quarry Limestone Limestone 10 Gravel 2 Quarry, Limestone Quarr
Breed Cattle Livestock 2 Pasture Pastu
Harvest Common Wood Logs, Common Wood 20 Logging Camp, Oak Loggi
Harvest Fir Logs, Fir 10 Logging Camp, Fir LoggiHarvest Oak Logs, Oak 10 Logging Camp, Oak Loggi
Harvest Teak Logs, Teak 10 Logging Camp, Teak Loggi
Quarry Marble Marble 5 Gravel 1 Quarry, Marble Quarr
Mine Copper Ore, Copper 10 Mine, Copper Mine,
Mine Gold Ore, Gold 10 Mine, Gold Mine,
Mine Iron Ore, Iron 10 Mine, Iron Mine,
Mine Silver Ore, Silver 10 Mine, Silver Mine,
Mine Zinc Ore, Zinc 10 Mine, Zinc Mine,
Harvest Beans Sack of Beans 10 Plantation, General Planta
Extract Saltpeter Saltpeter 5 Saltpeter Caves Saltpe
Harvest Sugarcane Sugarcane 10 Plantation, Sugar Planta
Excavate Sulfur Sulfur 5 Mine, Sulfur Mine,
Harvest Tobacco Tobacco 10 Plantation, Tobacco Planta
Harvest Wheat Wheat 10 Plantation, General Planta
Harvest Grapes Wine Grapes 10 Vineyard Viney
-
8/8/2019 Production Planner 2.0.48.0
131/232
Advanced Recipe Output #1 Quantity Output #2
Advanced Lignum Blocks Blocks, Lignum Vitae 5
Advanced Huge Cannon Construction Cannon, Huge 1Advanced Large Cannon Construction Cannon, Large 2
Advanced Fine Cheesemaking Cheese, Fine 1
Advanced Skinning, Furs Crate of Furs 1
Advanced Brass Smelting Ingot, Brass 2
Advanced Iron Smelting Ingot, Iron 10
Advanced Rum Distilling Rum 8
Advanced Fine Wine Fermenting Wine, Fine 1
Recipe Output #1 Quantity Output #2
Craft Barrel Barrel 10
Butcher Beef 2nd output for vlookup Beef 4 Crate of Hides from Livesto
Mill Black Powder Black Powder 8
Manufacture Blocks, Lignum Vitae Blocks, Lignum Vitae 5
Manufacture Blocks, Oak Blocks, Oak 5
Forge Cannon, Huge Cannon, Huge 1
Forge Cannon, Large Cannon, Large 2
Forge Cannon, Medium Cannon, Medium 4
Forge Cannon, Small Cannon, Small 5
Forge Swivel Gun Cannon, Swivel Gun 8
Forge Cannon, Very Small Cannon, Very Small 6
Cheesemaking, Common Cheese, Common 4
Cheesemaking, Fine Cheese, Fine 1
Spin Cotton Cotton, Spun 10
Skin Game Furs Crate of Furs 1
Skin Game Hides Crate of Hides from Game Animals 2
Butcher Beef Crate of Hides from Livestock 4 Beef
Cure Fish Fish, Cured 20
Bake Bread Hardtack 10
Weave Canvas Hemp Canvas 5
Braid Rope Hemp Rope 5
Smelt Brass Ingot, Brass 2
Refine Gold Ingot, Gold 5
Smelt Iron Ingot, Iron 10
Smelt Silver Ingot, Silver 2
Cure Hides from Game Animals Leather from Game Animals 10
Cure Hides From Livestock Leather from Livestock 10
Cure Game Meat, Cured From Game Animals 2
Cure Beef Meat, Cured from Livestock 4
Refine Sugar 2nd output for vlookup Molasses 10 Sugar, Refined
Forge Nails Nails 5
Distill Rum Rum 8
Craft Small Arms Small Arms 1
Refine Sugar Sugar, Refined 10 Molasses
Ferment Wine, Common Wine, Common 10
Ferment Wine, Fine Wine, Fine 1Distill Tar Wood Tar 5
-
8/8/2019 Production Planner 2.0.48.0
132/232
Advanced Recipe Output Quantity
Advanced Anchor Forging Anchor 1
Advanced Oak Frame Timber Frame Timber, Oak 1
Advanced Lignum Frame Timber Frame Timber, Lignum Vitae 1
Advanced Huge Hull Construction Huge Hull 1
Advanced Keel Sawing Keel Section 1
Advanced Large Hull Construction Large Hull 1
Advanced Mast Cutting Mast Section 1
Advanced Sail Stitching Sailcloth 1
Advanced Provisioning Ship Provisioning 1
Recipe Output Quantity
Forge Anchor Anchor 1
Construct Colossal Hull Colossal Hull 1
Saw Frame Timber, Oak Frame Timber, Oak 1
Saw Frame Timber, Lignum Vitae Frame Timber, Lignum Vitae 1
Construct Huge Hull Huge Hull 1
Construct Huge Square Rig Huge Square Rig 1
Saw Keel Keel Section 1
Construct Large Fore-and-Aft Rig Large Fore-and-Aft Rig 1
Construct Large Hull Large Hull 1
Construct Large Square Rig Large Square Rig 1
Lineship Structural Materials Lineship Structure Bundle 1
Cut Mast Section Mast Section 1
Construct Medium Fore-and-Aft Rig Medium Fore-and-Aft Rig 1Construct Medium Hull Medium Hull 1
Construct Medium Square Rig Medium Square Rig 1
Mill Planks, Oak Planks, Oak 10
Mill Planks, Teak Planks, Teak 10
Construct Refit: 'Mystique' Poleacre Refit: 'Mystique' Poleacre 1
Knot Rigging Rigging 5
Stitch Sailcloth Sailcloth 1
Forge Brass Fittings Ship Fittings, Brass 5
Forge Iron Fittings Ship Fittings, Iron 5
Pack Ship Provisions Ship Provisioning 1
Saw Stem Ship Stem 2
Construct Small Fore-and-Aft Rig Small Fore-and-Aft Rig 1
Construct Small Hull Small Hull 1
Construct Small Square Rig Small Square Rig 1
Construct Tiny Fore-and-Aft Rig Tiny Fore-and-Aft Rig 1Construct Tiny Hull Tiny Hull 1
Bundle Unrest Supplies, Food Unrest Supplies, Food 1
Bundle Unrest Supplies, Luxuries Unrest Supplies, Luxuries 1
Bundle Unrest Supplies, Metal Unrest Supplies, Metal 1
Bundle Unrest Supplies, Textiles Unrest Supplies, Textiles 1
Bundle Unrest Supplies, Weapons Unrest Supplies, Weapons 1
Bundle Unrest Supplies, Wood Unrest Supplies, Wood 1
-
8/8/2019 Production Planner 2.0.48.0
133/232
Advanced Recipe Output Quantity Base Structure Structure Used U
Advanced Bronze Round Shot Crafting Crate of Bronze Round Shot 10 Forge Forge
Recipe Output Quantity Base Structure Structure Used U
Craft Bar Shot Crate of Bar Shot 10 Forge Forge
Craft Bronze Round Shot Crate of Bronze Round Shot 10 Forge Forge
Craft Canister Shot Crate of Canister Shot 10 Forge ForgeCraft Chain Shot Crate of Chain Shot 10 Forge Forge
Craft Grapeshot Crate of Grape Shot 10 Forge Forge
Craft Round Shot Crate of Heavy Round Shot 10 Forge Forge
Craft Langridge Crate of Langridge 15 Forge Forge
Craft Star Shot Crate of Star Shot 10 Forge Forge
Craft Stone Shot Crate of Stone Shot 15 Forge Forge
-
8/8/2019 Production Planner 2.0.48.0
134/232
Recipe Output Quantity Base Str
Admiral's Overhaul, First-Rate Admiral's Overhaul, First-Rate 5 Lumber M
Admiral's Overhaul, Well-made Admiral's Overhaul, Well-made 5 Lumber MCraft Bandages Bandages 10 Textile Mi
Craft Coarse Powder Charge Gunpowder (Coarse-Grained) 20 Powder M
Craft Fine Powder Charge Gunpowder (Fine-Grained) 20 Powder M
Craft Precise Powder Charge Gunpowder (Pre-Measured) 20 Powder M
Coarse-Grained Gunpowder, First-Rate Gunpowder, First-Rate (Coarse-Grained) 5 Powder M
Fine-Grained Gunpowder, First-Rate Gunpowder, First-Rate (Fine-Grained) 5 Powder M
Pre-Measured Gunpowder, First-Rate Gunpowder, First-Rate (Pre-Measured) 5 Powder M
Hull Patch, First-Rate Hull Patch, First-Rate 5 Lumber M
Emergency Hull Patch 4 Hull Patch, Improved 10 Lumber M
Emergency Hull Patch 2 Hull Patch, Inferior 10 Lumber M
Emergency Hull Patch 5 Hull Patch, Quality 10 Lumber M
Emergency Hull Patch 1 Hull Patch, Rough 10 Lumber M
Emergency Hull Patch 3 Hull Patch, Standard 10 Lumber M
Hull Patch, Well-made Hull Patch, Well-made 5 Lumber M
Fortified Wine Ration, First-Rate Keg of Fortified Wine, First-Rate 5 Sugar Ref
Fortified Wine Ration, Well-made Keg of Fortified Wine, Well-made 5 Sugar Ref
Emergency Rum Ration 4 Keg of Rum, Improved 10 Sugar Ref
Emergency Rum Ration 2 Keg of Rum, Inferior 10 Sugar Ref
Emergency Rum Ration 5 Keg of Rum, Quality 10 Sugar Ref
Emergency Rum Ration 1 Keg of Rum, Rough 10 Sugar Ref
Emergency Rum Ration 3 Keg of Rum, Standard 10 Sugar Ref
Mast Brace, First-Rate Mast Brace, First-Rate 5 Lumber M
Emergency Mast Brace 4 Mast Brace, Improved 10 Lumber M
Emergency Mast Brace 2 Mast Brace, Inferior 10 Lumber M
Emergency Mast Brace 5 Mast Brace, Quality 10 Lumber M
Emergency Mast Brace 1 Mast Brace, Rough 10 Lumber M
Emergency Mast Brace 3 Mast Brace, Standard 10 Lumber M
Mast Brace, Well-made Mast Brace, Well-made 5 Lumber M
Craft Smelling Salts Smelling Salts 5 Provisione
Spare Guns, First-Rate Spare Guns, First-Rate 5 Forge
Spare Guns 4 Spare Guns, Improved 5 Forge
Spare Guns 2 Spare Guns, Inferior 5 Forge
Spare Guns 5 Spare Guns, Quality 5 Forge
Spare Guns 1 Spare Guns, Rough 5 Forge
Spare Guns 3 Spare Guns, Standard 5 Forge
Spare Guns, Well-made Spare Guns, Well-made 5 Forge
Structural Brace, First-Rate Structural Brace, First-Rate 5 Lumber M
Structural Brace 4 Structural Brace, Improved 5 Lumber M
Structural Brace 2 Structural Brace, Inferior 5 Lumber M
Structural Brace 5 Structural Brace, Quality 5 Lumber M
Structural Brace 1 Structural Brace, Rough 5 Lumber M
Structural Brace 3 Structural Brace, Standard 5 Lumber M
Structural Brace, Well-made Structural Brace, Well-made 5 Lumber M
-
8/8/2019 Production Planner 2.0.48.0
135/232
Recipe Output Quantity Base Structure Structure Used Upkeep Recipe
Recruit Expert Captain Expert Captain 1 Recruitment Office Recruitment Office 1.79
Recruit Expert Carpenter Expert Carpenter 1 Recruitment Office Recruitment Office 1.79
Recruit Expert Gunner Expert Gunner 1 Recruitment Office Recruitment Office 2.38
Recruit Expert Mercenary Expert Mercenary 1 Recruitment Office Recruitment Office 1.19Recruit Expert Sailmaster Expert Sailmaster 1 Recruitment Office Recruitment Office 0.60
-
8/8/2019 Production Planner 2.0.48.0
136/232
Ship Deeds
Page 136 of 232
Recipe 'Agamemnon' Bark 'Alexander' Fourth Rate
Output 'Agamemnon' Bark 'Alexander' Fourth Rate
Quantity 3 2
Base Structure Shipyard, Medium Shipyard, Large
Structure Used Shipyard, Medium Shipyard, Large
Upkeep 85.71 257.14
Recipe Labor 18.00 36.00
Adjusted Labor 18.00 36.00
Doubloons 1,000 60,000
Adjusted Doubloons 1,000 60,000
Qty Cost Labor Qty Cost
Ingredient 1 Anchor 3 1,118 10.20 Anchor 8 2,980
Ingredient 2 Cannon, Large 2 2,623 17.70 Cannon, Large 24 31,480
Ingredient 3 Cannon, Small 16 4,468 45.60 Cannon, Medium 2 1,111
Ingredient 4 Cannon, Swivel Gun 4 310 3.40 Cannon, Small 32 8,937
Ingredient 5 Cannon, Very Small 12 1,821 19.00 Cannon, Swivel Gun 6 464
Ingredient 6 Granite 8 30 1.46 Colossal Hull 1 45,366
Ingredient 7 Large Hull 1 14,837 246.00 Granite 22 82
Ingredient 8 Medium Square Rig 1 3,700 68.59 Huge Square Rig 1 17,423
Ingredient 9 Ship Provisioning 1 741 31.60 Ship Provisioning 20 14,812
Ingredient 10 Sulfur 2 20 1.60 Sulfur 4 40
Ingredient 11 Wood Tar 4 145 4.32 Wood Tar 8 290
Ingredient 12
Ingredient 13
Ingredient 14
Ingredient Cost 29,812.86 122,986.07
Taxes 50 3000
Cost Per 10,316.19 93,121.61
Total Labor 161.82 970.24
Recipe 'Hercules' Frigate 'Hercules' Heavy Frigate
Output 'Hercules' Frigate 'Hercules' Heavy Frigate, Uncertified Deed
Quantity 2 1
Base Structure Shipyard, Large Shipyard, Large
Structure Used Shipyard, Large Shipyard, Large
Upkeep 171.43 14.29
Recipe Labor 24.00 2.00Adjusted Labor 24.00 2.00
Doubloons 6,400 500
Adjusted Doubloons 6,400 500
Qty Cost Labor Qty Cost
Ingredient 1 Anchor 4 1,490 13.60 'Hercules' Frigate 1 36,771
Ingredient 2 Cannon, Large 24 31,480 212.40 Blocks, Lignum Vitae 3 791
Ingredient 3 Cannon, Medium 4 2,223 22.40 Cannon, Large 4 5,247
Ingredient 4 Cannon, Small 12 3,351 34.20 Lineship Structure Bundle 1 318,960
Ingredient 5 Cannon, Swivel Gun 8 619 6.80 Planks, Teak 12 701
Ingredient 6 Granite 14 52 2.55 Ship Fittings, Brass 3 3,514
Ingredient 7 Large Hull 1 14,837 246.00
Ingredient 8 Large Square Rig 1 8,565 167.17
Ingredient 9 Ship Provisioning 5 3,703 158.00
Ingredient 10 Sulfur 4 40 3.20
Ingredient 11 Wood Tar 8 290 8.64Ingredient 12
Ingredient 13
Ingredient 14
Ingredient Cost 66,651.16 365,984.73
Taxes 320 25
Cost Per 36,771.29 366,524.01
Total Labor 473.48 2,245.42
Recipe 'Oliphant' Heavy Indiaman 'Oliphant' Indiaman
Output 'Oliphant' Heavy Indiaman 'Oliphant' Indiaman
Quantity 1 2
Base Structure Shipyard, Large Shipyard, Large
-
8/8/2019 Production Planner 2.0.48.0
137/232
Ship Deeds
Page 137 of 232
Structure Used Shipyard, Large Shipyard, Large
Upkeep 14.29 171.43
Recipe Labor 2.00 24.00
Adjusted Labor 2.00 24.00
Doubloons 1,000 6,400
Adjusted Doubloons 1,000 6,400
Qty Cost Labor Qty Cost
Ingredient 1 'Oliphant' Indiaman 1 33,515 479.11 Anchor 4 1,490
Ingredient 2 Blocks, Lignum Vitae 6 1,583 3.60 Cannon, Large 2 2,623
Ingredient 3 Planks, Teak 24 1,401 7.20 Cannon, Medium 20 11,113
Ingredient 4 Ship Fittings, Brass 6 7,029 27.60 Cannon, Small 2 559
Ingredient 5 Cannon, Swivel Gun 4 310
Ingredient 6 Cannon, Very Small 24 3,642
Ingredient 7 Granite 16 60
Ingredient 8 Huge Hull 1 27,744
Ingredient 9 Large Square Rig 1 8,565
Ingredient 10 Ship Provisioning 5 3,703
Ingredient 11 Sulfur 4 40
Ingredient 12 Wood Tar 8 290
Ingredient 13
Ingredient 14
Ingredient Cost 43,528.27 60,139.29
Taxes 50 320
Cost Per 44,592.56 33,515.36
Total Labor 523.51 479.11
-
8/8/2019 Production Planner 2.0.48.0
138/232
Ship Deeds
Page 138 of 232
Recipe
Output
Quantity
Base Structure
Structure Used
Upkeep
Recipe Labor
Adjusted Labor
Doubloons
Adjusted Doubloons
Ingredient 1
Ingredient 2
Ingredient 3
Ingredient 4
Ingredient 5
Ingredient 6
Ingredient 7
Ingredient 8
Ingredient 9
Ingredient 10
Ingredient 11
Ingredient 12
Ingredient 13
Ingredient 14
Ingredient Cost
Taxes
Cost Per
Total Labor
Recipe
Output
Quantity
Base Structure
Structure Used
Upkeep
Recipe LaborAdjusted Labor
Doubloons
Adjusted Doubloons
Ingredient 1
Ingredient 2
Ingredient 3
Ingredient 4
Ingredient 5
Ingredient 6
Ingredient 7
Ingredient 8
Ingredient 9
Ingredient 10
Ingredient 11Ingredient 12
Ingredient 13
Ingredient 14
Ingredient Cost
Taxes
Cost Per
Total Labor
Recipe
Output
Quantity
Base Structure
bec 'Arcadia' Xebec 'Athen
bec 'Arcadia' Xebec 'Athen
3
Shipyard, Medium Shipyar
Shipyard, Medium Shipyar
85.71 8
18.00 1
18.00 1
2,800 3
2,800 3
Cost Labor Qty Cost Labor
12,445 204.10 Anchor 4 1,490 13.60 Anchor
2,638 6.00 Cannon, Medium 2 1,111 11.20 Cannon, Medium
559 5.70 Cannon, Small 28 7,820 79.80 Cannon, Small
304 3.17 Cannon, Swivel Gun 6 464 5.10 Cannon, Swivel Gun
550 20.00 Granite 10 37 1.82 Granite
829 4.80 Large Fore-and-Aft Rig 1 5,386 85.39 Large Hull
516 5.20 Large Hull 1 14,837 246.00 Medium Square Rig
11,714 46.00 Ship Provisioning 4 2,962 126.40 Ship Provisioning
584 3.00 Sulfur 2 20 1.60 Sulfur
1,489 19.16 Wood Tar 5 181 5.40 Wood Tar
34,309.44 32,5
140
12,445.05 12,0
204.10 19
te 'Hercules' Sleek Frigate 'Hermes' Maste
tified Deed 'Hercules' Sleek Frigate, Uncertified Deed 'Hermes' Maste
1
Shipyard, Large Shipya
Shipyard, Large Shipya
21.43 9
3.00 43.00 4
500 9
500 9
Cost Labor Qty Cost Labor
2,725 100.00 'Hercules' Frigate 1 36,771 473.48 'Hermes' Packet-Boat
4,748 10.80 Blocks, Lignum Vitae 6 1,583 3.60 Blocks, Lignum Vitae
3,334 33.60 Cannon, Small 4 1,117 11.40 Cannon, Small
2,793 28.50 Lineship Structure Bundle 1 318,960 1711.34 Cheese, Fine
956,881 5134.02 Planks, Teak 18 1,051 5.40 Ingot, Gold
2,803 14.40 Ship Fittings, Brass 3 3,514 13.80 Ingot, Silver
21,086 82.80 Planks, Teak
Ship Fittings, Brass
Wine, Fine
362,996.85 12,9
25
363,543.28 13,8
2,228.02 13
'Poseidon' Fourth Rate 'Postillio
'Poseidon' Fourth Rate 'Postillio
1
Shipyard, Large Shipya
-
8/8/2019 Production Planner 2.0.48.0
139/232
Ship Deeds
Page 139 of 232
Structure Used
Upkeep
Recipe Labor
Adjusted Labor
Doubloons
Adjusted Doubloons
Ingredient 1
Ingredient 2
Ingredient 3
Ingredient 4
Ingredient 5
Ingredient 6
Ingredient 7
Ingredient 8
Ingredient 9
Ingredient 10
Ingredient 11
Ingredient 12
Ingredient 13
Ingredient 14
Ingredient Cost
Taxes
Cost Per
Total Labor
Shipyard, Large Shipya
257.14 2
36.00 1
36.00 1
60,000 2
60,000 2
Cost Labor Qty Cost Labor
373 3.40 Anchor 8 2,980 27.20 Anchor
310 3.40 Cannon, Large 4 5,247 35.40 Cannon, Small
911 9.50 Cannon, Medium 50 27,783 280.00 Cannon, Swivel Gun
4 0.18 Cannon, Small 12 3,351 34.20 Granite
2,527 43.30 Cannon, Swivel Gun 6 464 5.10 Medium Hull
2,635 47.79 Granite 22 82 4.01 Medium Square Rig
10 0.80 Huge Hull 1 27,744 355.90 Ship Provisioning
36 1.08 Large Square Rig 1 8,565 167.17 Sulfur
Lineship Structure Bundle 1 318,960 1711.34 Wood Tar
Ship Provisioning 14 10,368 442.39
Sulfur 4 40 3.20
Wood Tar 8 290 8.64
405,875.94 14,3
3000
469,133.08 5,6
3,182.55 7
-
8/8/2019 Production Planner 2.0.48.0
140/232
Ship Deeds
Page 140 of 232
Recipe
Output
Quantity
Base Structure
Structure Used
Upkeep
Recipe Labor
Adjusted Labor
Doubloons
Adjusted Doubloons
Ingredient 1
Ingredient 2
Ingredient 3
Ingredient 4
Ingredient 5
Ingredient 6
Ingredient 7
Ingredient 8
Ingredient 9
Ingredient 10
Ingredient 11
Ingredient 12
Ingredient 13
Ingredient 14
Ingredient Cost
Taxes
Cost Per
Total Labor
Recipe
Output
Quantity
Base Structure
Structure Used
Upkeep
Recipe LaborAdjusted Labor
Doubloons
Adjusted Doubloons
Ingredient 1
Ingredient 2
Ingredient 3
Ingredient 4
Ingredient 5
Ingredient 6
Ingredient 7
Ingredient 8
Ingredient 9
Ingredient 10
Ingredient 11Ingredient 12
Ingredient 13
Ingredient 14
Ingredient Cost
Taxes
Cost Per
Total Labor
Recipe
Output
Quantity
Base Structure
'Bermuda' Mastercraft Sloop 'Bermuda' Sloop
'Bermuda' Mastercraft Sloop 'Bermuda' Sloop
1 5
Shipyard, Small Shipyard, Small
Shipyard, Small Shipyard, Small
4.76 14.29
2.00 6.00
2.00 6.00
300 1,200
300 1,200
Qty Cost Labor Qty Cost
'Bermuda' Sloop 1 1,674 24.07 Anchor 1 373
Blocks, Lignum Vitae 3 791 1.80 Cannon, Swivel Gun 4 310
Cannon, Small 6 1,676 17.10 Cannon, Very Small 8 1,214
Cheese, Fine 1 275 10.00 Granite 4 15
Ingot, Gold 1 415 2.40 Small Fore-and-Aft Rig 1 2,537
Ingot, Silver 1 258 2.60 Small Hull 1 2,527
Planks, Teak 3 175 0.90 Sulfur 1 10
Ship Fittings, Brass 3 3,514 13.80 Wood Tar 3 109
Wine, Fine 1 744 9.58
9,522.28 7,093.73
15 60
9,842.04 1,673.60
84.25 24.07
'Hermes' Sleek Packet-Boat 'Hiorten' Galeas
'Hermes' Sleek Packet-Boat 'Hiorten' Galeas
1 6
Shipyard, Small Fishing Lodge
Shipyard, Small Fishing Lodge
2.38 1.19
1.00 1.001.00 1.00
400 600
400 600
Qty Cost Labor Qty Cost
'Hermes' Packet-Boat 1 4,702