Spreadsheet
I am building spreadsheets for engineering calculations. Here are my habits :
1 ) by default Excel is programmed with 1 sheet. People forget to seek other sheets
and sometimes the spreadsheet can be registered to the last sheet.
2 ) Put an explicit name on the each Tab
3 ) The 1ST sheet explains what is the spreadsheet purpose, what it is doing, and how it is organized. I put a link on this 1ST page to the other sheets. It gives the references for calculation i.e. engineering standards, methods, and procedures.
Sometimes a flowchart.
4 ) The 2ND Sheet tracks all revisions with detailed comments
5 ) The 3RD Sheet Gives the nomenclature and units used in the whole spreadsheet
6 ) The 4TH Sheet is the place where starts the calculations.
Any comments ?
