According to the original plan, I had two days to produce the master spreadsheet for this project. That was seven working days ago and I think I am lucky to have made it as far as I have by today. The data I am working with is mostly incorrect and the database itself is very flaky. In addition, I found I needed to produce the spreadsheet from several sources - all on different platforms. I have managed, today to integrate the two disparate sections of the master Access database, the Red Dot list from another Excel spreadsheet and various items from Word documents into a coherent whole in such a way that we can now update by hand once a day if necessary and gradually improve the accuracy of the thing. My greatest joy is that I have taken a five thousand plus item database and reduced it to just two sheets of A4 in order to make the system simpler and more accurate. Whilst feeling fairly pleased with myself, I just know someone is bound to say, "That's OK, but can we do this"? aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaargh!
No comments:
Post a Comment