Things to consider when planning a spreadsheet - best practice approach
Key things to consider when designing a spreadsheet Somethings we need to consider when we plan to create a spreadsheet for our work: We need to think about (plan) our spreadsheet before we start so that we can eliminate the time consuming effort to modify and edit the sheet later when we have encoded a lot of data into it. When you decide on a consistent column naming convention for your sheet. There are three common conventions: Snake Case Camel Case Pascal Case (Upper Camel Case) We need to decide on what information you want in the sheet. Each type of data would be entered into a column. It is important to keep the data in the columns simple. Do not try to put too much information into a single column. We need to consider how useful is the data in each column and if we can use it for metrics (M&E). Case Study: BSIF Computer Hardware Inventory Column Naming Convention As you can see the column names have "no" naming convention. Some are all capitals with space and so...