Energy Ideas

Hi Steamy.

 

Having a bit of trouble opening your spreadsheet. 

 

Have tried it in Excel 2024 using the "all files option" Says the file is corrupt. Tried it in Excel 2013 version using the all files option, says it's protected with a password so won't open. 

@Gus Potter

 

Seem to remember that JohnMo had a similar problem, must be Scotch Software.

 

This, it is saved as an .xlsx file.

 

Compare U-Values and ACH.xlsx

Hiya. Can open it a bit in excel 2024, but it is stripping out a lot of info I think? Tried again with an earlier version of excel but most of the cells are not referencing. The charts are blank.

 

From what I can see you have put in a pile of effort into this. It's not a five minute job, it must have taken a huge effort to develop this. 

 

It looks like a good tool. 

 

It may be a "jock" problem at my end" but I doubt it. Ask around and see what others say.. you do know why the animal called the Haggis has it two left legs shorter.. it's so the can run round a hill and still stay level! 

 

 

 

 

15 minutes ago, Gus Potter said:

Can open it a bit in excel 2024

 

Both the ods and xlsx file work fine in LibreOffice calc.

 

Best thing to do is download and install a copy of libre office - https://www.libreoffice.org/

 

But beware, once you start using it instead of Excel, you may never go back 😁

 

Now need to do some interpretation.

38 minutes ago, SimonD said:

But beware, once you start using it instead of Excel, you may never go back 

And that is a big problem I have at my end as a practicing SE. I have written spreadsheets that have stiffness matrices ( the maths can be challenging) for example that I use for analysis of whacky stuff. These are benchmarked and tested against industry standard analysis software. Basically I write these and check, validate and so on. These are then sent to other SE's for checking. It also works the other way when I act as a checking SE. 

 

On a commercial level ( yes I know I'm captured) it make no sense to swap to libre whan I can get excel for a couple of hundred quid. 

 

The excel platform is also very powerfull in the text function / interface.. how it interacts with many cad packages for example. SE use a lot of Greek and other symbols.. we can't be mucking about with these as they are really important in their meaning. 

 

But to cut to the chase. I can see @SteamyTea has put a pile of work into this. Many BH folk will have excel say at work? 

 

So it would be great if @SteamyTea's spread sheet could be converted into something that your average punter can open at ease. 

 

 

 

 

@Gus Potter @SimonD

 

I use Libreoffice Portable https://portableapps.com/apps/office/libreoffice_portable

Can take it anywhere with me.

 

The problem may be that I used REGEX() to split up the array's columns and rows headings, not sure if Excel supports REGEX() (it should as it is a normal function in the IT world).  

 

I did think of one problem and that is when using MVHR, the result should be added to the ACH result as it is, in effect, and extra 'leak'.

 

This part was not a great deal of work.  I may try and make one that separates the 'ground' face of the cuboid and adds in some percentage of window area.