Gas & Heating Spreadsheet

[Steven Jones]

Hi Everyone, not sure if I am posting in the right place so please accept my apologies if I am. I am in the process of leaving the Royal Navy and have just completed an Elementary Gas Course. I really enjoyed the course and during it I developed a spreadsheet for calculations on things such as purge volumes, pipe sizing, non-combi boiler selection and various others others. The idea is that the spreadsheet will hold everything that you need in one place (still developing it now) but will include things such as invoice, receipt, safety certificates, landlord certifcates etc. It can then be used to save information in one spreadsheet per household so that you can instantly recall it rather than dig through paperwork or rack your brains trying to remember what you told a customer when it was months ago that you were there. I have done a lot of searching around online and cant find any spreadsheets like it, so I wondered if the reason is because nobody will use it or if its because nobody has made one before or even if it is just not a good idea. I would love to know what the general thoughts on this are. I look forward to your repsonses

 

[on31ll]

Be careful as selling etc wont be allowed on forum but sure we could take a look ? Maybe some screenshots ? I know theres a few apps that do what ypur talking about !

 

[AWheating]

most self employed guys would make there own spreadsheet up, dont take to long tbh. good invoice software is helpful also.

 

[erpkid]

Hi Everyone, not sure if I am posting in the right place so please accept my apologies if I am. I am in the process of leaving the Royal Navy and have just completed an Elementary Gas Course. I really enjoyed the course and during it I developed a spreadsheet for calculations on things such as purge volumes, pipe sizing, non-combi boiler selection and various others others. The idea is that the spreadsheet will hold everything that you need in one place (still developing it now) but will include things such as invoice, receipt, safety certificates, landlord certifcates etc. It can then be used to save information in one spreadsheet per household so that you can instantly recall it rather than dig through paperwork or rack your brains trying to remember what you told a customer when it was months ago that you were there. I have done a lot of searching around online and cant find any spreadsheets like it, so I wondered if the reason is because nobody will use it or if its because nobody has made one before or even if it is just not a good idea. I would love to know what the general thoughts on this are. I look forward to your repsonses

This sounds like a good preparation for your challenges ahead and excellent revision for course work, however you need to be aware of existing products out there and that we often remake the wheel. If you find the tool helpful later all the better but as others have said there are some apps already out there. We use ACT! for contact management and excel with a few macros for our invoicing and quoting. Once you get stuck in with the tools you will find what suits you best and it could surprise you. Good luck in the future an welcome to the forum.

 

[Reg Man]

Intrigued by your idea, question is has it been done before, or is this new. Protect it, before releasing it if you think it has commercial way forward.

 

[Killy Bing]

I made up a snazzy little one for heat losses, formulas and all

 

[Steven Jones]

Thanks for the responses so far. Just to clarify, I am not advertising or looking to sell anything, but simply asking the opinion of the professionals as I am new to the industry.

I am working hard at getting my spreadsheet up and running and I will link some screen shots soon. I understand that people make their own spreadsheets for pipe sizing etc but in my experience these spreadsheets are not capable of all the calculations (like mine currently is). I currently have fully working spreadsheets to calculate for Ventilation (All categories), Purging, Installation Volumes, Boiler Sizing (non-combi), Gas Rates and am just completing the Pipe sizing one as we speak.

The idea behind the spreadsheet is that one household gets one spreadsheet (with all of the above), you then save that and can recall all as required from your tablet, laptop or pc. I understand that there are apps out there that do one or two of these functions but I am looking to make an all in one spreadsheet that covers them.

When the spreadsheet is completed (maybe some time) I would love it if I could send it to some of you guys on here for testing. Will keep you up to date.

Thanks all

 

[Steven Jones]

Some screen shots of my spreadsheet in development.