Unzip all three files to one folder

Open 'Whole wall Rvalue analysis Controls.xlsm' first which will also open 'Whole wall Rvalue analysis.xlsm'

Enable editing if popup window appears
Enable macros if popup window appears

If the analyis spreadsheet contains some wall components then it will also open 'Wall parts Library Version X.X.X.xlsm'
If the analysis spreadsheet doesn't have some existing wall components then open the library file manually and add some components

Wall components are added to the analysis spreadsheet by selecting them in the library and using the <Paste to Analysis> button at the top of the library spreadsheet
The pasted components are added left to right in the analysis spreadsheet
Once added to the analysis spreadsheet the individual components can be move or delected by selecting the <Move/Delete> button at the bottom of the analysis spreadsheet

Anytime the analysis spreadsheet has been modified such as adding / removing /altering the components then the analysis needs to be updated by pressing the <Calculate> button at the top left of the controls
The button will turn yellow if an update needs to be instigated

On the 'Controls' sheet the green boxes indicated variables that can be changed by the user - all other boxes are indicators only.

Modifications to the walls can be made in the 'analysis' spreadsheet by selecting an area and draging it. Restoring all parts in the 'analysis' to the default library state can be performed by the <Rebuild Wall From Source> button.

The light grey, light blue, and light green areas represent 1-D heatflow zones and the adjacent darker shaded areas represent 3-D heatflow.
The light and dark zones are seperated by a border line that gives a visual check of consistency when modifying an area or adding a new section to a wall profile

There is an <Auto Select ..> button on the control panel that toggles between selecting the whole component and being able to manually 'click and drag over' to select a smaller piece of a component
After manually selecting a smaller peice it is possible to then drag and drop the right bottom corner of the selection to copy the cells and replace adjacent cells.
This also copies the links to the analysis data so will only work if the light-dark shading and associated borders is also consistent.

There is also an <Auto Select ..> button on the library spreadsheet that toggles between selection a whole component and being able to manually 'click and drag over' to select a smaller piece of a component

<Conductance view ON/OFF> Colorizes the wall view providing a visual representation of the conductance of the wall. High thermal conductance is shown as a brighter colour, similar to the iron temperature scale.

<Selectall> selects the complete wall profile on the analysis sheet

<rebuild from source> re-copies all of the components of a wall profile from their library source. Any modifications to the components will therefore be lost.

<Clear> deletes the wall profile from analsys sheet

Notes:
  -'IGU' stands for 'insulated glazing unit' which is the glass part of a double glazed window.
  - Analysis displays timber as 50mm x 50mm squares but adjusts for the standard size of 45mm of dressed timber for the area ratios. Timber size is also adjusted for in the simulation data used for the analysis.
  - Analysis interpolates between pre-simulated datapoints (between R 1.6 and R 3.0 insulation), and extrapolates when beyond the simulated datapoints. A note is displayed at the top of the 'Controls' spreadsheet indicating if any extrapolating occurs.
  - Thermal view shows the heatflow to the cold side (external) of the wall.
  - The 'Analysis ' and 'Controls' spreadsheets cannot have their names changed, however the library file can be changed as long as no parts from that library are currently loaded into the 'Analysis' sheet.
  - Walls are simulated as 90mm deep framing.
  - 'area' refers to the pependicular face area, i.e. window and door reveals are not included although they are included in the effective R-values for the face areas adjacent to the reveals 
