Captain Orso's Newfangled Build Plan Spread Sheet
Posted: Sat Jul 05, 2014 5:10 pm
Because it's been requested by PM, and because I loath to do things more than once, here it is.
So I've finally gotten around to putting a package together for my Build Spread Sheet. It is attached along with the necessary font. Please read the included readme file for legal restrictions pertaining to the included font.
A couple of rules that need to be followed to use this spread sheet as intended:
The spread sheet is divided into sections between rows with a black background and a merged set of cells displaying the section's name, such as "=== Eastern Divisioins ===". In column "A" of the first and last row of each section are texts used to recognize the limits of each section; EG "EDS" and "EDE" (Eastern Divisions Start and Eastern Divisions End). The formula in the the merged set of cells in column "B" uses these to present the section label. The section label and the delimiters are freely editable, but the first and last cells must match up with the formula and be exclusive.
Entering a date into column "E" requires you to use the spread sheet's language format, which you may change. Since the sheet is formatted in U.S. English you must enter the date in the format M.D.Y, where the day must be either 1 or 16 (the start of a half-month turn) EG 10.16.62 for '62 Oct Late. All dates are in the 20th century; EG 62 Oct E is actually the 1st of October 1962. This is because of the way calc programs represent dates. If you enter an actual 19th century date, the formula in column "G" will not work.
Column "G" is calculated if column "F" contains a numeric value > 1. The Date generated in "G" is not correct for two reasons. 1. I have not found a way to calculate with only 30-day months and 15-day half months. 2. "14" is added to the date in "G" so that the "E" and "L" labels are correct; the date itself will not be, but that is inconsequential. The the full date is written out in columns "E" and "G" is for review purposes.
You will often have to insert new rows to a section. Do this by selecting the last row of the section (the row-number on the far left) and dragging down as many rows as you wish to insert, then right-click on the marked row-numbers (not in the cells) to open the context menu, and click on "Insert Rows".
These freshly inserted rows will be formatted exactly as the row which as directly above them before their creation. Therefore it may be necessary to reformat these new cells. Use the "Format Paintbrush for this. Also the formula in column "F" may need to be copied into the new cells of column "F".
In the example I've left in the spread sheet I've used dark-gray to mark units which I plan to build, but which have not yet been purchased; red to mark units which have been purchased, but are still building; yellow to mark units which have been built, but are still traveling to their division or what ever.
You may of course color the cells how ever you wish, just not columns "E" and "G". These use "Conditional Formatting" and changing their back ground color or other formatting will break that.
You may add new sections or delete current ones as you wish. Just follow the above rules.
If you have any questions, please post them here. They and their answers may benefit others.
Enjoy!!
So I've finally gotten around to putting a package together for my Build Spread Sheet. It is attached along with the necessary font. Please read the included readme file for legal restrictions pertaining to the included font.
A couple of rules that need to be followed to use this spread sheet as intended:
The spread sheet is divided into sections between rows with a black background and a merged set of cells displaying the section's name, such as "=== Eastern Divisioins ===". In column "A" of the first and last row of each section are texts used to recognize the limits of each section; EG "EDS" and "EDE" (Eastern Divisions Start and Eastern Divisions End). The formula in the the merged set of cells in column "B" uses these to present the section label. The section label and the delimiters are freely editable, but the first and last cells must match up with the formula and be exclusive.
Entering a date into column "E" requires you to use the spread sheet's language format, which you may change. Since the sheet is formatted in U.S. English you must enter the date in the format M.D.Y, where the day must be either 1 or 16 (the start of a half-month turn) EG 10.16.62 for '62 Oct Late. All dates are in the 20th century; EG 62 Oct E is actually the 1st of October 1962. This is because of the way calc programs represent dates. If you enter an actual 19th century date, the formula in column "G" will not work.
Column "G" is calculated if column "F" contains a numeric value > 1. The Date generated in "G" is not correct for two reasons. 1. I have not found a way to calculate with only 30-day months and 15-day half months. 2. "14" is added to the date in "G" so that the "E" and "L" labels are correct; the date itself will not be, but that is inconsequential. The the full date is written out in columns "E" and "G" is for review purposes.
You will often have to insert new rows to a section. Do this by selecting the last row of the section (the row-number on the far left) and dragging down as many rows as you wish to insert, then right-click on the marked row-numbers (not in the cells) to open the context menu, and click on "Insert Rows".
These freshly inserted rows will be formatted exactly as the row which as directly above them before their creation. Therefore it may be necessary to reformat these new cells. Use the "Format Paintbrush for this. Also the formula in column "F" may need to be copied into the new cells of column "F".
In the example I've left in the spread sheet I've used dark-gray to mark units which I plan to build, but which have not yet been purchased; red to mark units which have been purchased, but are still building; yellow to mark units which have been built, but are still traveling to their division or what ever.
You may of course color the cells how ever you wish, just not columns "E" and "G". These use "Conditional Formatting" and changing their back ground color or other formatting will break that.
You may add new sections or delete current ones as you wish. Just follow the above rules.
If you have any questions, please post them here. They and their answers may benefit others.
Enjoy!!
What the heck are you guys doing?