Data Tools

​​

Excel tool for converting other distributions into log normal

​

CSIRO has developed a simple excel sheet for getting a range or standard deviation into a log normal square of the standard deviation for use in SimaPro. The benefits of this is that your triangular distribution can then be used as the basic uncertainty and has the pedigree matrix scores applied in the same was as they were in your original inventory. Special thanks to Sandra Eady for sharing this and John Henshall for input to it.

 

Excel Macro for listing process parameters from SimaPro data export

​

With the increasing use of parameters it can be difficult to know where you have defined them and in the absence of a search function for parameters in SimaPro this little tool will take a CSV export of your project and produce a sortable list of parameters at the process, project and database level including the names of the process the parameters are defined in.