Good morning, I am working on a project that I thought was something I could do myself. Turns out i was way off. I am working on a spreadsheet that I want to use as a digital template to determine the heating and cooling needs of a house based on materials used and sizes. I have all of the laborious work done, however, the programming aspect has proven tricky. I do think what I want can be done, but sadly it is out of my scope. Hoping that some experts would be able to assist in this project. I plan to make it open source as the commercial programs are at minimum, hundreds of dollars and there are no complete and free sizing applications. I am linking to my github as I don't know how I would post a small sheet that can show the whole picture. The .ods file is currently the "master" file. I would prefer to keep it out of the microsoft domain but if I need to buy a new license to make getting help easier, I will.


the project will involve VBA, I think. And I have started commenting cells and what the purpose of them needs to be. Hopefully this makes a bit of sense, and I will do whatever is needed to make this happen. Thank you

Edit: so I am unable to post a link to the github where the file is.