Скачать или смотреть Tips & Tricks - Handling Non-Numeric Named Cell Values - Pronamics cost estimating software

Find out the best way to handle the importation of non-numeric named cell values from excel.

HELPFUL RESOURCES, LINKS & TRANSCRIPT INFORMATION BELOW: (click on ‘Show More’) ____________________________________________

Click the links below to access useful Knowledge Base articles, start a free trial, download the Product Selector, explore our website, or access helpful links at our support hub.

► Global Defines: https://knowledgebase.pronamics.com.a...
► Defines: https://knowledgebase.pronamics.com.a...
► Spreadsheets: https://knowledgebase.pronamics.com.a...

► Tips & Tricks Video - Global Defines: https://pronamics.com.au/support-hub/...

Start your free 30-day trial: https://pronamics.com.au/free-trial/

► Explore our Homepage and website: https://pronamics.com.au/
► Support Hub and Product Selector download: https://pronamics.com.au/support-hub/
► Knowledge Base: https://knowledgebase.pronamics.com.au/
► Find us on Facebook:   / pronamics  
► On LinkedIn:   / pronamics-pty-ltd  

We’d love to hear from you!

Call us:
24/7/365 Support: +61 7 3481 9626
Consulting and sales: +61 7 3481 9676
Training: +61 7 3481 9686

Email us:
support(at symbol)pronamics.com.au (replace text with @ symbol)
____________________________________________
TRANSCRIPT

Handling Non Numeric Named Cell Values In Excel

When linking Global Defines with named cells in spreadsheets, Expert Estimation gives you the ability to choose between importing all named cells from an Excel spreadsheet or only named cells with a numeric value.

Let’s have a look at an example spreadsheet for Global Defines values we want to link to. We want to import the values for Labour Productivity, Project Duration, Time Lost In Hours and Overtime Allowance.

First we need to check that the cells with values are named so they can be seen in the Spreadsheets window in Expert Estimation. We have named the cells LabProd, ProjectDuration, Wastage, TimeLostHRS, and OvertimeAllowance.

In Expert Estimation, to get to the Spreadsheets window, in the HOME menu tab, select Spreadsheets from the ribbon tool bar, or go to Resource Explorer, then select Spreadsheets from the ribbon menu.
To import a spreadsheet, click on the ‘add spreadsheets’ icon in the ribbon menu, then upload your Excel file from the location where the spreadsheet has been saved. You can upload XLSX and XLSM files. CSV files do not allow named cells so they cannot be imported.

To see a summary of all the named cells, including those with non-numeric values, in the Expert Estimation Spreadsheets window, make sure the ‘Import Numeric Named Cells Only’ box is not ticked, then highlight the imported spreadsheet document, and click on ‘View Spreadsheet Defines’. You will see a summary of all the named cell values. Named cells that are not able to be converted to a numeric value, for example if the cell is empty or has text in the cell, it will be imported and synchronised with a value of zero.

These cells and values can be synchronised with Global Defines and Resource Rates. This is useful when you need to calculate a value in Excel and be able to then use that value in calculations throughout your project, or use it as the Base Rate of a Resource.

When you import a spreadsheet, a copy of the spreadsheet is added to the Expert Estimation database. The original remains unchanged in the location where it was saved.

To instead see only named cells with a numeric value, check the tick box in the “Import Named Cells only” column on the imported spreadsheet row, and click ‘View Spreadsheet Defines’ again.
You can see this time, only the named cells with a value have been listed. Time Lost Hours, which had a no value in the named cell, and Overtime Allowance, which had text in the named cell, are no longer shown.

And that is how to handle importing numeric and non-numeric named cell values from Excel spreadsheets into Expert Estimation.

For more information see the Knowledgebase article linked below this video. Contact our 24/7 support team by phone or email. We love to listen to your feedback and any tweaks that you would like to help make it even better. We can also help you with achieving the results you’re looking for in the application.

Please let us know what you think. We look forward to speaking with you.