tag:blogger.com,1999:blog-1869924468172210809.post4292699488212910241..comments2024-02-12T12:08:02.364+00:00Comments on Not Just Numbers: Time saved using spreadsheets always beats time saved writing them!Glen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-1869924468172210809.post-84028548512119479242016-10-25T16:38:27.279+01:002016-10-25T16:38:27.279+01:00Very good post!Very good post!Keithhttps://www.blogger.com/profile/02371187885328276169noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-54611542247187919392012-07-12T18:12:45.554+01:002012-07-12T18:12:45.554+01:00Huw Accountant
It is this manipulation every mont...Huw Accountant<br /><br />It is this manipulation every month/week/day that people seem to accept and it really doesn't have to be like that if the spreadsheet is built properly in the first place.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-8183709752633331422012-07-12T09:16:53.930+01:002012-07-12T09:16:53.930+01:00We have just commissioned two spreadsheet models f...We have just commissioned two spreadsheet models from a professional and i can confirm that getting them right is well worth it in terms of time saved. <br /><br />For example one sheet was based on something we already had but which required a mark against each job to say it is done and a lot of manipulation each month to show us what jobs were outstanding - so it was often ignored. Now we still mark off jobs done and hey presto have a list of outstanding work at the press of a button without any manipulation at all.Huw Accountanthttps://www.blogger.com/profile/18133179059898239174noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-711192477191464612012-06-14T16:20:23.838+01:002012-06-14T16:20:23.838+01:00Mike
You're right. This is one of the hardest...Mike<br /><br />You're right. This is one of the hardest things I find, doing what I do.<br /><br />It's easy once you can get hold of someone's spreadsheet to rewrite it. You can then demonstrate how much time they could be saving with the right approach.<br /><br />The problem is getting them to realise that it could be so much better!Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-88184463698279933052012-06-14T13:47:10.679+01:002012-06-14T13:47:10.679+01:00I agree with what you are saying but many, many us...I agree with what you are saying but many, many users tend to revert to only the things they are comfortable with. Things like this kind of spaghetti code: =F2+F7+F13+F23+F29+F35 instead of the simple use of subtotals and a sum() function. Not only hard to follow but more work and way easier to make mistakes with. My biggest problem is that people don't want to experiment to use an easier way to build something. The problem is they are satisfied with where they are and what they know so they don't try new functions or new methods in spreadsheet design. How do you get them to use new tools? I believe the average Excel user uses Sum() and maybe average() but not too much more.MikeHirschhttps://www.blogger.com/profile/07782797237691889461noreply@blogger.com