Custom Calculations
About Custom CalculationsAccess Custom CalculationsPreparing your excel spreadsheetAvailable metrics in PodiumSet up Excel SpreadsheetManage CalculationsVisibilityFunctionsDownloadDuplicateEditShareDeleteUploading Spreadsheet to PodiumUpload Excel SpreadsheetMap Fields from Excel SpreadsheetView Custom Calculations
About Custom Calculations
Podium is able to link your excel spreadsheet with our output data.
When project scenarios are generated in Podium, a significant amount of data is created behind the scenes. Although the user interface of Podium allows you to view specific model data metrics, it may be beneficial to integrate the generated data with your company's spreadsheets. For instance, if you have a spreadsheet for conducting a commercial analysis of a project that requires area data inputs. The Custom Calculations feature enables you to upload and link your spreadsheets with Podium in order to perform Excel calculations in the background and present custom outputs on the platform. This approach is more efficient than manually inputting exported model data into a spreadsheet.
Access Custom Calculations
You can find the access Custom Calculations in the expandable left-hand panel in Podium. By clicking on ‘Custom Calculations’, you’ll get directed to the main page of this feature.
Preparing your excel spreadsheet
Before you start uploading your spreadsheets to Podium, it is important to understand which model metrics are currently exposed and can be mapped to your inputs. With that knowledge you can assess which of your existing spreadsheets are compatible and get ideas for new spreadsheets that can be used with Podium. A list of the currently available metrics can be found at the end of this article.
Available metrics in Podium
The following metrics represent:
IPMS1: Total Floor Area
IPMS3: Total Net Leasable Area
Metric
Site/Spatial/Storey/Name
Site/Spatial/Storey/IPMS3
Site/Spatial/Storey/IPMS2
Site/Spatial/Storey/IPMS1
Site/Spatial/Storey/ID
Site/Spatial/Storey/Height
Site/Spatial/Storey/Footprint Area
Site/Spatial/Storey/Efficiency
Site/Spatial/Storey/Apartments Total Count
Site/Spatial/Storey/4-Bed Apartment Unit Mix
Site/Spatial/Storey/4-Bed Apartment Count
Site/Spatial/Storey/3-Bed Apartment Unit Mix
Site/Spatial/Storey/3-Bed Apartment Count
Site/Spatial/Storey/2-Bed Apartment Unit Mix
Site/Spatial/Storey/2-Bed Apartment Count
Site/Spatial/Site/Site Coverage
Site/Spatial/Site/Motorcycle Parking Lots
Site/Spatial/Site/IPMS3
Site/Spatial/Site/IPMS2
Site/Spatial/Site/IPMS1
Site/Spatial/Site/ID
Site/Spatial/Site/GPR
Site/Spatial/Site/Footprint Area
Site/Spatial/Site/Efficiency
Site/Spatial/Site/Car Parking Lots
Site/Spatial/Site/Apartments Total Count
Site/Spatial/Site/4-Bed Apartment Unit Mix
Site/Spatial/Site/4-Bed Apartment Count
Site/Spatial/Site/3-Bed Apartment Unit Mix
Site/Spatial/Site/3-Bed Apartment Count
Site/Spatial/Site/2-Bed Apartment Unit Mix
Site/Spatial/Site/2-Bed Apartment Count
Site/Spatial/Residential Building/Number Of Storeys
Site/Spatial/Residential Building/Name
Site/Spatial/Residential Building/IPMS3
Site/Spatial/Residential Building/IPMS2
Site/Spatial/Residential Building/IPMS1
Site/Spatial/Residential Building/ID
Site/Spatial/Residential Building/Height
Site/Spatial/Residential Building/Footprint Area
Site/Spatial/Residential Building/Floor To Floor Height
Site/Spatial/Residential Building/Efficiency
Site/Spatial/Residential Building/Building Type
Site/Spatial/Residential Building/Apartments Total Count
Site/Spatial/Residential Building/4-Bed Apartment Unit Mix
Site/Spatial/Residential Building/4-Bed Apartment Count
Site/Spatial/Residential Building/3-Bed Apartment Unit Mix
Site/Spatial/Residential Building/3-Bed Apartment Count
Site/Spatial/Residential Building/2-Bed Apartment Unit Mix
Site/Spatial/Residential Building/2-Bed Apartment Count
Site/Spatial/Multi Storey Car Park/Number Of Storeys
Site/Spatial/Multi Storey Car Park/Motorcycle Parking Lots
Site/Spatial/Multi Storey Car Park/IPMS3
Site/Spatial/Multi Storey Car Park/IPMS1
Site/Spatial/Multi Storey Car Park/ID
Site/Spatial/Multi Storey Car Park/Footprint Area
Site/Spatial/Multi Storey Car Park/Floor To Floor Height
Site/Spatial/Multi Storey Car Park/Efficiency
Site/Spatial/Multi Storey Car Park/Car Parking Lots
Site/Spatial/Apartment/IPMS3
Site/Spatial/Apartment/IPMS2
Site/Spatial/Apartment/IMPS1
Site/Spatial/Apartment/ID
Site/Spatial/Apartment/Height
Site/Spatial/Apartment/Apartment Type
Building/Structural/Wall/Width
Building/Structural/Wall/Weight
Building/Structural/Wall/Volume
Building/Structural/Wall/Product Variant ID
Building/Structural/Wall/Product Type
Building/Structural/Wall/Name
Building/Structural/Wall/Material
Building/Structural/Wall/Length
Building/Structural/Wall/ID
Building/Structural/Wall/Height
Building/Structural/Wall/Grade
Building/Structural/Slab/Width
Building/Structural/Slab/Weight
Building/Structural/Slab/Volume
Building/Structural/Slab/Rebar Mass
Building/Structural/Slab/Product Variant ID
Building/Structural/Slab/Product Type
Building/Structural/Slab/Name
Building/Structural/Slab/Material
Building/Structural/Slab/Length
Building/Structural/Slab/ID
Building/Structural/Slab/Height
Building/Structural/Slab/Grade
Building/Structural/Column/Width
Building/Structural/Column/Weight
Building/Structural/Column/Volume
Building/Structural/Column/Rebar Mass
Building/Structural/Column/Product Variant ID
Building/Structural/Column/Product Type
Building/Structural/Column/Name
Building/Structural/Column/Material
Building/Structural/Column/Length
Building/Structural/Column/ID
Building/Structural/Column/Height
Building/Structural/Column/Grade
Building/Structural/Beam/Width
Building/Structural/Beam/Weight
Building/Structural/Beam/Volume
Building/Structural/Beam/Rebar Mass
Building/Structural/Beam/Product Variant ID
Building/Structural/Beam/Product Type
Building/Structural/Beam/Name
Building/Structural/Beam/Material
Building/Structural/Beam/Length
Building/Structural/Beam/ID
Building/Structural/Beam/Height
Building/Structural/Beam/Grade
Building/Structural/Any Structure/Weight
Building/Structural/Any Structure/Volume
Building/Structural/Any Structure/Product Variant ID
Building/Structural/Any Structure/Product Type
Building/Structural/Any Structure/Name
Building/Structural/Any Structure/Material
Building/Structural/Any Structure/ID
Building/Structural/Any Structure/Grade
Set up Excel Spreadsheet
1. Name input and output cells
To ensure compatibility with the Custom Calculation feature of Podium it's important to utilize the Name Manager to assign 'Input_' as a prefix for your input cells and 'Output_' as a prefix for your output cells in the spreadsheet. This naming convention enables Podium to distinguish between input and output cells before facilitating the mapping of these elements to model data.
2. Name input range
If required, you are able to give a range of inputs a single name with the prefix ‘Input_’. When mapped to Podium, the feature will add model data to the range until either all instances of the model have been added or until the range is fully filled out. When working with ranges, please ensure that the range length is proportionate to the length of model data instances you are intending to map.
Manage Calculations
When arriving on the ‘Custom Calculations’ page, you will see a list of all custom calculations you either created or someone shared with you. You can switch between your and shared calculations by clicking on the corresponding header tabs. A count next to each header tab also indicates to you how many custom calculations are available at this point in time in each section. .
Visibility
The visibility toggle controls if the corresponding custom calculation appears in the specified scenario space or not. Please note that this setting only applies to you and does not affect the visibility of the calculation for users you shared it with.
Functions
Clicking on the kebab menu on the right-hand side of each calculation line item enables you to access an array of functions.
Download
By clicking on ‘Download’ you can download the spreadsheet that is linked to the custom calculation to your local drive. This can be required if you want to change formulas or other soft inputs within the spreadsheet.
Duplicate
In case you want to create a version of a calculation with different behaviour, you can simply click ‘Duplicate’, which will create a copy of the selected custom calculation. This function also creates and stores a copy of the uploaded spreadsheet within the platform.
Edit
You can come back to the form to map and edit parameters by clicking on ‘Edit’ for a respective custom calculation line item in the list.
Share
Custom calculations are user managed, which means that no other users will see a custom calculation you add to Podium, unless you share it first.
To share a custom calculation, you need to first specify the users to invite. Start by typing an account name or clicking on the drop-down menu to select Podium users from your organization. Afterwards, click on 'Invite' to notify the selected users and make the calculation appear in their shared calculation section.
After you shared a custom calculation with your colleagues, you are able to manage the access by selecting ‘Share’ again in the kebab menu of the corresponding calculation. This enables you to ‘Remove’ access from specific users.
Delete
To delete a custom calculation, simply click select ‘Delete’ in the drop-down menu. Please keep in mind that people you shared the custom calculation with will also loose the calculation if you delete it.
Uploading Spreadsheet to Podium
Upload Excel Spreadsheet
To add a new custom calculation, simply click on the ‘Add Calculations’ button in the top right corner of the ‘Custom Calculations’ page, which will direct you to the input form.
When adding a new custom calculation, it is mandatory to enter a file name. You can add a description to provide more information about the calculation you are creating.
The next step is the mandatory upload of the Excel file you prepared with named Inputs and Output names. To do that, simply drag and drop your file into the ‘Excel File’ field or click on ‘Browse’ to select it on your local computer. Once you moved a spreadsheet into the form, you need to click on the ‘Upload File’ button, which becomes active once a spreadsheet is present.
Map Fields from Excel Spreadsheet
Once you uploaded a valid spreadsheet into the form, additional fields will appear enabling you to map defined inputs and to add suffixes to outputs.
Space & Typology
Every input cell or range you defined in your spreadsheet, needs to be mapped to a Podium metric. The list of metrics can be found at the end of this article. For ease of finding the metric you want to map, you can filter the metrics-list by space and/or typology. For example, if you select ‘Industrial', then metrics related to residential buildings won’t appear (i.e., Apartments Total Count).
The other aspect of the ‘Space’ selection is controlling in which scenario space your custom calculation can appear. For example, if it’s set to ‘Site’, then this custom calculation can only be visible in ‘Site’ space.
Map Input
Every cell or range that you named with the prefix ‘Input_’ in the spreadsheet you uploaded to the form will appear as a field to map. If that is not the case, please return to your spreadsheet and double check that you named the cells correctly using the name-manager as described above.
To map an input to a Podium model metric, simply look for the metric in the drop-down list next to the input field. The ‘Podium Property’ fields are also text-search enabled and you can find the desired metric by starting to type its name.
Set Output Suffix
Up to ten cells that you named with the prefix ‘Output_’ in the spreadsheet you uploaded to the form will appear as a field in the ‘Output’ section of the form. If that is not the case, please return to your spreadsheet and double check that you named the cells correctly using the name-manager as described above.
The ‘Suffix Unit’ enables you to add a suffix to each output cell, to make it more meaningful to users when reviewing a preview of the results within a scenario.
Visibility
The ‘Visibility’ toggle enables you to control if the custom calculation will appear in your scenarios or not.
View Custom Calculations
To access your own or a shared custom calculation, navigate to the space where the calculation is linked (Site / Building) and click on the ‘Calculations’ button in the right-hand panel. In the ‘Calculation’ panel, you will see the corresponding calculations. To run a calculation, simply click on the kebab menu located to the right of each one.
If you access one of your calculations, you are able to download the linked spreadsheet with the mapped input metrics of the current scenario to your local drive, by clicking on ‘Download’. In case of shared custom calculations, you are only able to run the spreadsheet in the background and review the outputs in the fly-out panel.
