This follows on from Part 1 of my Fleet Carrier Management Spreadsheet instructions, linked here.
The Storage section allows you to record what, and how much you have stored on your carrier. You can edit all the highlighted fields with the projected profit (should you then sell it) calculated automatically.
The Commodities section allows you to calculate what commodities you want to BUY from other Commanders (note I have not configured this to sell as I personally don't want to do that, and I doubt many people will). In the first four columns add the commodity name, the amount you currently have purchased, the galactic average price, and the maximum amount you will buy.
The buying price % is what amount of the maximum available price you can get when you later sell it that you are prepared to pay other commanders for as their selling price. Enter this as a percentage, so 0.85 for 85%. This allows you to calculate how much you'll pay other Commanders for commodities, and any projected profit when you later sell them is calculated for you. You should also manually enter the maximum market price you can sell the commodities for.
I only added the Rares section in the hope Frontier might allow the buying and selling of rare commodities on Carriers. This isn't looking likely but I'm an optimist so I left it in. It works in the same way as the Commodities section.
Now we come to Module and Ship stock. With these just add the number of what you have in the appropriate cell. The total sale value of those modules or ships will be calculated for you. You'll see that not all cells are white. This shows you what is available in the game for each module, and for each class.
Note that absolutely every Module (and Ship) available in the game is shown here, but not all of them are available to buy and sell on carriers. I added them in the hope they might all be unlocked at some future time.
The Ships section works that same as the Modules one, but also includes cells where you can record how many of each type of Armour you have for each ship, should they become available to purchase and sell at some point in the future.
So that's how you use my Fleet Carriers Management Spreadsheet. You can download it from THIS LINK. Have fun Commanders
The Storage section allows you to record what, and how much you have stored on your carrier. You can edit all the highlighted fields with the projected profit (should you then sell it) calculated automatically.
The Commodities section allows you to calculate what commodities you want to BUY from other Commanders (note I have not configured this to sell as I personally don't want to do that, and I doubt many people will). In the first four columns add the commodity name, the amount you currently have purchased, the galactic average price, and the maximum amount you will buy.
The buying price % is what amount of the maximum available price you can get when you later sell it that you are prepared to pay other commanders for as their selling price. Enter this as a percentage, so 0.85 for 85%. This allows you to calculate how much you'll pay other Commanders for commodities, and any projected profit when you later sell them is calculated for you. You should also manually enter the maximum market price you can sell the commodities for.
I only added the Rares section in the hope Frontier might allow the buying and selling of rare commodities on Carriers. This isn't looking likely but I'm an optimist so I left it in. It works in the same way as the Commodities section.
Now we come to Module and Ship stock. With these just add the number of what you have in the appropriate cell. The total sale value of those modules or ships will be calculated for you. You'll see that not all cells are white. This shows you what is available in the game for each module, and for each class.
Note that absolutely every Module (and Ship) available in the game is shown here, but not all of them are available to buy and sell on carriers. I added them in the hope they might all be unlocked at some future time.
The Ships section works that same as the Modules one, but also includes cells where you can record how many of each type of Armour you have for each ship, should they become available to purchase and sell at some point in the future.
So that's how you use my Fleet Carriers Management Spreadsheet. You can download it from THIS LINK. Have fun Commanders
Last edited:
