Tips & Tricks Video: Spreadsheet Optimisation


Systemise, Optimise

The Expert Estimation Spreadsheets module has been redesigned so that you are able to quickly and efficiently manage spreadsheets and named cells in your project, and has a properties pane to see details of named cell references from inside the spreadsheets window.

In the HOME window, click on the SPREADSHEETS icon at the top in the ribbon menu. In this window you will see any spreadsheets linked to the project. To add a new spreadsheet, click on ADD OR REPLACE SPREADSHEET.

One of the key optimisations of the Spreadsheets window means that you don’t have to go to another window to view Named Cells. These named cells can be linked to Global Defines, Resource Base Rates, Sell Rates, as well as Managed Defines. You access the Named Cells of a spreadsheet directly from within this window very easily using the chevron icon on the left of the grid. This icon opens and closes an indented tree menu showing the Named Cells in each linked spreadsheet.

In the PROPERTIES PANE you can see where all the named cells are linked as well as double click on the references to quickly and easily take you directly to where the Named Reference is being utilised, giving you usage tree functionality within the Spreadsheets tool.

In the grid you can also right click on individual named cells to see the properties pane, or copy the details, or substitute one particular reference of a named cell for a different named cell.

If you want to make adjustments to the values generated from the spreadsheet, you can save a copy of the file by clicking on the SAVE SPREADSHEET option from the ribbon menu. At this point you can also rename the file to create a revision of the spreadsheet. Once a copy of the file has been saved, it can then be modified through Excel.

Once all the changes have been saved, the spreadsheet can then be re-imported into the application by clicking on the ADD or REPLACE SPREADSHEET button. The spreadsheet you select will be added to the Spreadsheets window depending on the file name that you choose.

If you RE-UPLOAD a spreadsheet that is already linked, you will be prompted to REPLACE or RENAME the spreadsheet. From within this window, you can choose to either replace the existing file or rename the file being imported, to create a second file. This allows you to easily keep an original spreadsheet master copy and to save a renamed spreadsheet that you are making changes to.

If you have multiple spreadsheets with Named References that match, you can choose to substitute the Named Reference values used in one spreadsheet, with the Named References from another spreadsheet.

This is done by clicking on the Spreadsheet you wish to substitute and click on the SUBTITUTE SPREADSHEET button from the ribbon menu. This will open the Substitute Spreadsheet window. From the dropdown in this window, you can select an alternative spreadsheet that will be used to substitute in for the selected spreadsheet.

You are also able to substitute specific Named Cells, or specific Named References using the context menu in the Grid or the Properties Pane.

And that’s an introduction to working with Spreadsheets Optimisation in Expert Estimation.

For further information see our Knowledge Base article.

If you have any questions, call us on our 24/7 Support Line. We’re always here to help.


lights action camera small

A lot of work goes into generating Tips & Tricks videos, but they are still part of our “More Done, More Fun” culture here at Pronamics.

It’s not just recording the odd video in a funny voice, or editing screen shots with old fashioned star wipes. Creating Tips & Tricks videos requires our training and marketing team to learn the features of Expert Estimation, which in terms strengthens our ability to support our clients.

Check out some of these handy tips & tricks videos.