File:Icon Artificial Star.png and File:DSP Build Tracker and Item List.xlsx: Difference between pages
No edit summary |
imported>76561198121518784 |
||
Line 1: | Line 1: | ||
== Summary == | == Summary: == | ||
A workbook that will allow you to keep easy tracking of your production. It has auto formatting and does all the hard work for you - you just need to tell it your progress by entering a "Y" in the "master" sheet and all sub-sheets will auto update. | |||
== How to use this Workbook: == | |||
As you produce each item mark it in Column B with a "Y" on the "Master" sheet. | |||
Once the item is in the intra-planetary storage network mark it in Column C with a "Y" on the "Master" sheet. | |||
Once the item is in the inter-planetary storage network mark it in Column D with a "Y on the "Master" sheet. | |||
When an item is marked as being in the planetary storage it will be marked as available withing each production sheet, this will let you see if you have the base component available to create the target product. | |||
When an item is marked as being produced and both storage types it will be marked green. | |||
There is no need to update the production sheets as the master sheet will update these automatically, however you can add any specific notes for that production chain on the sub-sheet. | |||
Formulas and formatting are currently applied down to row 200 to allow for some expansion as the game grows. | |||
Products are all sorted aplhabetically and any furure ones can be inserted as needed. | |||
== Changelog: == | |||
14/02/21: V1.0: Initial layout | |||
== Upcoming: == | |||
I would like to add the required quantities. | |||
I would like to add a production calc that will work out how many you are producing and how much is required so you know | |||
if you are meeting the production requirements or over/under producing. | |||
I will look into a google sheets version - but as I'm not so familiar with this it may take a bit - especially with the formatting/formulas. | |||
== Requests: == | |||
Please feel free to let me know any changes you would like to see in future versions as well as any bugs if you find them(hopefully there are none! :p) | |||
====== THERE ARE NO MACRO's IN THIS WORKBOOK - ALL THE FORMATTING IS DONE WITH FORMULAS AND CONDITIONAL FORMATTING ====== |
Revision as of 20:38, 14 February 2021
Summary:
A workbook that will allow you to keep easy tracking of your production. It has auto formatting and does all the hard work for you - you just need to tell it your progress by entering a "Y" in the "master" sheet and all sub-sheets will auto update.
How to use this Workbook:
As you produce each item mark it in Column B with a "Y" on the "Master" sheet.
Once the item is in the intra-planetary storage network mark it in Column C with a "Y" on the "Master" sheet.
Once the item is in the inter-planetary storage network mark it in Column D with a "Y on the "Master" sheet.
When an item is marked as being in the planetary storage it will be marked as available withing each production sheet, this will let you see if you have the base component available to create the target product.
When an item is marked as being produced and both storage types it will be marked green.
There is no need to update the production sheets as the master sheet will update these automatically, however you can add any specific notes for that production chain on the sub-sheet.
Formulas and formatting are currently applied down to row 200 to allow for some expansion as the game grows.
Products are all sorted aplhabetically and any furure ones can be inserted as needed.
Changelog:
14/02/21: V1.0: Initial layout
Upcoming:
I would like to add the required quantities.
I would like to add a production calc that will work out how many you are producing and how much is required so you know if you are meeting the production requirements or over/under producing.
I will look into a google sheets version - but as I'm not so familiar with this it may take a bit - especially with the formatting/formulas.
Requests:
Please feel free to let me know any changes you would like to see in future versions as well as any bugs if you find them(hopefully there are none! :p)
THERE ARE NO MACRO's IN THIS WORKBOOK - ALL THE FORMATTING IS DONE WITH FORMULAS AND CONDITIONAL FORMATTING
File history
Click on a date/time to view the file as it appeared at that time.
Date/Time | Thumbnail | Dimensions | User | Comment | |
---|---|---|---|---|---|
current | 10:39, 13 September 2023 | 80 × 80 (15 KB) | Maintenance script (talk | contribs) | == Summary == Importing files from OLD Wiki |
You cannot overwrite this file.
File usage
More than 100 pages use this file. The following list shows the first 100 pages that use this file only. A full list is available.
- Accumulator
- Annihilation Constraint Sphere
- Antimatter
- Antimatter Fuel Rod
- Arc Smelter
- Artificial Star
- Artificial Star/ItemInfo
- Assembling Machine Mk.I
- Assembling Machine Mk.II
- Assembling Machine Mk.III
- Carbon Nanotube
- Casimir Crystal
- Chemical Plant
- Circuit Board
- Coal
- Conveyor Belt Mk.I
- Conveyor Belt Mk.II
- Conveyor Belt Mk.III
- Copper Ingot
- Copper Ore
- Crystal Silicon
- Deuterium
- Deuteron Fuel Rod
- Diamond
- Dyson Sphere Component
- EM-Rail Ejector
- Electric Motor
- Electromagnetic Matrix
- Electromagnetic Turbine
- Energetic Graphite
- Energy Exchanger
- Energy Matrix
- Fire Ice
- Foundation
- Fractal Silicon
- Fractionator
- Frame Material
- Full Accumulator
- Gear
- Glass
- Graphene
- Graviton Lens
- Gravity Matrix
- High-Purity Silicon
- Hydrogen
- Hydrogen Fuel Rod
- Information Matrix
- Interstellar Logistics Station
- Iron Ingot
- Iron Ore
- Items
- Kimberlite Ore
- Logistics Drone
- Logistics Vessel
- Magnet
- Magnetic Coil
- Matrix Lab
- Microcrystalline Component
- Mini Fusion Power Plant
- Miniature Particle Collider
- Mining Machine
- Oil Extractor
- Oil Refinery
- Orbital Collector
- Organic Crystal
- Particle Broadband
- Particle Container
- Photon Combiner
- Plane Filter
- Planetary Logistics Station
- Plasma Exciter
- Plastic
- Prism
- Processor
- Quantum Chip
- Ray Receiver
- Refined Oil
- Reinforced Thruster
- Satellite Substation
- Silicon Ore
- Small Carrier Rocket
- Solar Panel
- Solar Sail
- Sorter Mk.I
- Sorter Mk.II
- Sorter Mk.III
- Space Warper
- Spiniform Stalagmite Crystal
- Splitter
- Steel
- Stone
- Stone Brick
- Storage Mk.I
- Storage Mk.II
- Storage Tank
- Strange Matter
- Structure Matrix
- Sulfuric Acid
- Super-Magnetic Ring
- Technologies
View more links to this file.