Search the Community
Showing results for tags 'spreadsheet'.
Found 3 results
I'm currently at the stage of building a detailed budget as we are now in for planning and interfacing with self build mortgage lenders. I do have a high level spreadsheet and have a full development cost understood, however I need to break the build cost section out with real numbers just now as I just have my magic 'finger in the air' 1200/m^2 figure at the moment for the build. I have various prices back for all the windows, the house kit, MVHR, etc however I have basically been procrastinating as hard as I can before building the full budget spreadsheet and cashflow (albeit I have a very good idea of what I want it to do). I have a terrible habit of avoiding these things, rather than just eating the frog and getting done. I have downloaded a number of spreadsheets from on here, which I have attached for reference for anyone else who is looking. I can't remember who posted them (one is definitely by @Jeremy Harris) but thanks to those who shared. I am going to build a budget spreadsheet using the 'self build - cost estimate' attached. I seems to make sense and uses pivot tables to allow the data to easily broken out. I've a little learning to do on those but, I spend most of my day costing and estimating on spreadsheets for large engineering projects so should be fairly straightforward. Then I plan on adding a cashflow tab and actual costs vs budget. Hopefully so it's all easy to update and doesn't take up too much time throughout the process. However, I wanted to check if anyone else had other examples they would be happy to share and that worked well? And also any tips? extra functions or info to add that you would add in hindsight? I do plan on adding a column for reclaimable VAT so I can track this and also an easy way to add a column to monitor costs during build easily to see if we are on track. Sample_Costbook.xls Self Build - Cost Estimate.xlsx Simplified costing spreadsheet - 050421014.xls
Hi everyone Will be needing a company to reclaim VAT payments on our completed DIY new build (BC will sign off in about a month) I'm not great with paperwork, so... idea is to drop off a box of receipts... And wait for cheque! Prefer to use someone in Kent if poss (not keen on sending paperwork through post!) Any recommendations welcome
Budgets and spreadsheets go together like [...........insert your own idiom here..............] And so do errors: errors of fact and errors in formulae. Realising that, recently, every time it rains, I'm in the office trying hard to avoid checking our spreadsheet. Errors of fact Not a great lot to be done here. My only suggestion is to get a mate to check with you. @MrsRA is better at this process than I am, but we still manage to avoid the issue because it's so hard (for that read time-consuming) to do something which 'should' be easy. It isn't. Errors in Formulae Is there anything that can help the hard, detailed, mind-numbing, eye-watering, annoying slog Yes Here is a simple search for all versions of the term 'formula auditing' (because there are so many versions of spreadsheets out there) And here is one website's summary of several approaches to checking formulae in the most common (I think) spreadsheet of all. Just sayin'. Guess what I'm doing this morning.