Importing Data to an existing spread sheet. So you’ve got a master log, it doesn’t really matter where. Either on-line or off-line, for on-line – you can read “in the cloud”. And for off-line, well that is on your local device and given...
Importing data to an existing spread sheet. What happens where you have an existing temporary Master Log in an Excel spread sheet and you want to import more data. Well if it matches the existing structure it is easy, simply go to the first cell on the first blank row...
Now we have it, what next. The basic spread sheet that we want to use as a temporary solution for the Master Log is done, now we have to populate it with data. Getting Data In. There are several ways of getting your data into the spread sheet, as we are using Excel we...
A quick tidy up! So we have already created a simple spread sheet to use as a temporary master log. In this post we are going to look at making it a bit more presentable, really just so as you can see things at a glance. We are also going to look at and create some...
The Data Format. One of the most important things about your master log is data consistency. That is the way that the data is recorded by you, so being consistent is important. You can enter the data any way that you want, but when it comes to looking for something...
