BATTLELEDGER v1_1.xlsx
I've created a lightweight, tablet friendly ledger to help you track your monthly expenses and revenue. I wanted to see how much streamers were actually making from missions after repairs, turns out it wasn't pretty. The in-game finance report does not seem to tell you how much money you earned/spent in a month, and I wanted to know more. I eventually came up with a system I could use on my tablet and fill out with minimal info. I didn't want this to become ExcelTech (more than this already is) and have worked to keep out of game bookkeeping light.
I plan on using this to track which missions give the best return once repairs are factored in and significant salvage is noted. It could also be used to keep track of which chassis are constantly offline and costing you the most long term. This can be used in your spreadsheet program of choice or uploaded to googledocs. It also features automatic formatting and notes for entry guidelines along with protected cells to prevent misclicks.
Anyone familiar with spreadsheets can skip this and just note the unlock password. Cells have notes for formatting when needed.
UNLOCK PASSWORD: DEATHFROMABOVE
The excel sheet is protected and all unlock prompts use this password. The cells for the user to edit are unlockable separate from the sheet as a whole. All sheet protection can be removed at will, but I'd recommend keeping it for the blank template.
BLANK TEMPLATE:
Unlock the Blank Template sheet and enter your company name. You can now copy this sheet for every new month.
DATA ENTRY:
I designed the sheet to format the numbers for you, all values are meant to be entered as raw numbers and don't even need to be declared as negative values in the case of expenses and operating cost.
First thing you will want to enter is the projected monthly OPERATING COSTS (C6) and Morale Rate (A6) from the in-game Finance Report or in the upper left corner of the main tabs. The Morale Rate is the +/- morale lue you have set for the month.
In this case, the OPERATING COST is 241,850 C-Bills. This can change over a month, but entering it at the start gives you a rough Idea what you need to make to cover yourself. At the end of the month, update it with actual value in the Financial Report
After that you have the main area below, where you can enter any action that costs you money. The first field is "DTG" or Date Time Group. This is entered as a two to 4 digit number, with the last digit signifying the day. So for "Week 42, Day 2" you would just enter "422" and the cell will format it as "W42 d2". You can also just put one entry in the first cell of that day and only update the DTG when something happens on a later date.
The MISSION/EVENT field is for the type of mission (Battle/Recovery/etc), the number of Skull difficulty and your negotiated salvage rate. You can also track Repairs(RP), Refits(RF), Buy/Sell (B/S), Hires/Fires (H/F) and ship events (E) or upgrades (U) using any system you like. I'd recommend the abbreviated letters here and entering and indenting Repair/Refit directly under missions to signify that repair was caused by that mission. I wouldn't bother with noting every sold heatsink and jump jet individually, just roll it all in to one line.
Notes are for anything you wish, notable salvage, mission that didn't end in success or how many days a unit is offline.
Enter anything that costs you C-Bills in the EXPENSES row and any money gained in the "REVENUE" and that's it. The totals are tracked at the bottom and also update the net profit at the top of the ledger.
UNLOCK PASSWORD: DEATHFROMABOVE
The excel sheet is protected and all unlock prompts use this password. The cells for the user to edit are unlockable separate from the sheet as a whole. All sheet protection can be removed at will, but I'd recommend keeping it for the blank template.
BLANK TEMPLATE:
Unlock the Blank Template sheet and enter your company name. You can now copy this sheet for every new month.
DATA ENTRY:
I designed the sheet to format the numbers for you, all values are meant to be entered as raw numbers and don't even need to be declared as negative values in the case of expenses and operating cost.
First thing you will want to enter is the projected monthly OPERATING COSTS (C6) and Morale Rate (A6) from the in-game Finance Report or in the upper left corner of the main tabs. The Morale Rate is the +/- morale lue you have set for the month.
In this case, the OPERATING COST is 241,850 C-Bills. This can change over a month, but entering it at the start gives you a rough Idea what you need to make to cover yourself. At the end of the month, update it with actual value in the Financial Report
After that you have the main area below, where you can enter any action that costs you money. The first field is "DTG" or Date Time Group. This is entered as a two to 4 digit number, with the last digit signifying the day. So for "Week 42, Day 2" you would just enter "422" and the cell will format it as "W42 d2". You can also just put one entry in the first cell of that day and only update the DTG when something happens on a later date.
The MISSION/EVENT field is for the type of mission (Battle/Recovery/etc), the number of Skull difficulty and your negotiated salvage rate. You can also track Repairs(RP), Refits(RF), Buy/Sell (B/S), Hires/Fires (H/F) and ship events (E) or upgrades (U) using any system you like. I'd recommend the abbreviated letters here and entering and indenting Repair/Refit directly under missions to signify that repair was caused by that mission. I wouldn't bother with noting every sold heatsink and jump jet individually, just roll it all in to one line.
Notes are for anything you wish, notable salvage, mission that didn't end in success or how many days a unit is offline.
Enter anything that costs you C-Bills in the EXPENSES row and any money gained in the "REVENUE" and that's it. The totals are tracked at the bottom and also update the net profit at the top of the ledger.
Last edited:
