File:DSP Build Tracker and Item List.xlsx: Difference between revisions

File on DSP Wiki
VisualWikitext
imported>76561198121518784
(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" :P How to use this Workbook: As you produce each item mark it in Column B with a "Y" Once the item is in the intra-planetary storage network mark it in Column C with a "Y" Once the item is in the inter-planetary storage network mark it in Column D with a "Y" When an item is marked as being in the plane...)
 
(Maintenance script uploaded File:DSP Build Tracker and Item List.xlsx)
Tag: Server-side upload
 
(6 intermediate revisions by one other user not shown)
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" :P
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:
== How to use this Workbook: ==
As you produce each item mark it in Column B with a "Y" on the "Master" sheet.


As you produce each item mark it in Column B with a "Y"
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 intra-planetary storage network mark it in Column C with a "Y"
Once the item is in the inter-planetary storage network mark it in Column D with a "Y"


When an item is marked as being in the planetary storage it will be marked as available withing each production sheet
Once the item is in the inter-planetary storage network mark it in Column D with a "Y on the "Master" 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


Formulas and formatting are currently applied down to row 200 to allow for some expansion as the game grows
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.
Products are all sorted aplhabetically and any furure ones can be inserted as needed


Changelog:
When an item is marked as being produced and both storage types it will be marked green.
14/02/21: V1.0:  Initial layout


Upcoming:
Would like to add the required quantities
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




Requests: Please feel free to let me know any changesyou would like to see in future versions as well as any bugs if you find them(hopefully there are none!)
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
 
18/02/21: v1.1:  Added a missing item
 
Added times to produce each item (this will be updated shortly to calculate times depending on assembler version speed)
 
Added links for each item to its corresponding wiki page(only on master sheet so far - sub-sheets may be done later)
 
== 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 & Feedback: ==
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)
 
I can be reached at: classified_one at hotmail dot com - Please put "DSP Tracker" in your subject so that your email doesn't get flung into junk!
 
====== THERE ARE NO MACRO's IN THIS WORKBOOK - ALL THE FORMATTING IS DONE WITH FORMULAS AND CONDITIONAL FORMATTING ======

Latest revision as of 10:39, 13 September 2023

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

18/02/21: v1.1: Added a missing item

Added times to produce each item (this will be updated shortly to calculate times depending on assembler version speed)

Added links for each item to its corresponding wiki page(only on master sheet so far - sub-sheets may be done later)

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 & Feedback:

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)

I can be reached at: classified_one at hotmail dot com - Please put "DSP Tracker" in your subject so that your email doesn't get flung into junk!

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/TimeDimensionsUserComment
current10:39, 13 September 2023 (51 KB)Maintenance script (talk | contribs)== Summary == Importing files from OLD Wiki

You cannot overwrite this file.

There are no pages that use this file.

Retrieved from "https://dev.dsp-wiki.com/index.php?title=File:DSP_Build_Tracker_and_Item_List.xlsx&oldid=7835"
🍪 We use cookies to keep session information to provide you a better experience.
Learn more