Add Content

Use Parameters

Integrate Spreadsheets

Integrate Python

Share Pages

Leverage Templates

Manage Workspace

Contact CalcTree

Guides & Support

Streamline your engineering tasks with our online calculator. Access guides and support for efficient calculations. Simplify your tak now.

Online Engineering Calculator - Guides and Support | CalcTree

Quick start

Upload Spreadsheet

Map Parameters

Tables

Charts

Edit Spreadsheet

Supported spreadsheets

Source Viewer

Seamlessly Integrate Spreadsheets - Enhance your workflow by integrating engineering calculation spreadsheets with CalcTree. Try now

Engineering Calculation Spreadsheets - CalcTree

Map cells, tables and charts onto the page

Open the CalcTree source viewer for the spreadsheet and click the edit icon. This will open the spreadsheet in a new MS Online Editor window for you to make your edits.

Changes made to the spreadsheet will automatically sync back to the CalcTree platform upon closing the MS Online Editor window.

Learn the basics of integrating a spreadsheet onto CalcTree

Spreadsheet quick start

Upload spreadsheets to pull key parameters such as cells, charts and tables onto a page.

After your spreadsheet is uploaded, calculation inputs and outputs will be automatically identified and mapped to CalcTree parameters. 

Learn more about the auto-mapping process in our 

Upload spreadsheets to pull key parameters such as cells, charts and tables onto a page. Know how-To Use the integrations tab. Try now

Upload Engineering Calculation Spreadsheet - CalcTree

When you upload a spreadsheet to one of your pages, CalcTree will automatically identify any cells that may be inputs or outputs for a calculation as well as any tables or charts that exist in the spreadsheet. This guide covers the automapping of individual cells to native CalcTree parameters, check out these guides for 

If an important input or output from your spreadsheet was not identified by the auto-mapping process, it can be manually mapped from the CalcTree spreadsheet viewer!

Spreadsheet Integration with CalcTree - Automatically map cells to native parameters, tables, and charts. Simplify data utilization. Explore now!

Map Parameters - CalcTree

More than just individual values, if your spreadsheet contains what we identify to be a table, the cells will be mapped as a table. These tables will initially be titled "Table (R x C)" and will show the dimensions of the table i.e. "9R x 3C". See below for an example of what you will see on the right-hand side menu when your table has been mapped.

If we have missed a table in your spreadsheet, it can be manually mapped just like individual cells. 

To manually map a table, highlight the range of cells that make up your table in the viewer and the same green button with a 

 will appear. Upon clicking, your range will be mapped to a table and added to your page.

Efficient Spreadsheet Tables with CalcTree - Seamlessly map cells into titled tables. Explore mapping examples now!

Table - CalcTree

Just like tables, charts will be automatically identified and mapped when you upload your spreadsheet to CalcTree! 

This comprehensive guide informs you on how to map charts for displaying visual data. Explore now

Charts - CalcTree

Make changes to your spreadsheets without re-uploading them by using our Microsoft (MS) Online Editor integration. Any changes you make to the spreadsheet will be reflected in your CalcTree workspace. 

To edit your spreadsheet, open the CalcTree source viewer for the spreadsheet in question and select the edit icon next to the spreadsheet title in the top bar of the viewer.

This will open the spreadsheet in a new MS Online Editor window for you to make your edits.

 while the MS Online Editor is open, the source viewer will be disabled.

Close the MS Online Editor window when you are done with making edits. Changes will then sync and be applied to your CalcTree page.

This guide outlines how to make changes to uploaded spreadsheets using MS Online. Explore now

Edit Spreadsheet - CalcTree

Learn how to share pages with team members or external stakeholders. Explore now

Supported spreadsheets - CalcTree

On CalcTree, you can hide calculation complexity when creating easy-to-use calculation templates or design reports by allowing the source to power the page. Whenever you want, you can still view the source to verify the calculation logic on the page.

There's a few ways you can see the source added to a page. 

This will immediately open the Source Viewer.

You can quickly vet the calculation logic by clicking on any page parameter. This will automatically take you to the relevant section in the source. 

To turn this feature on/off, click on the 'Follow parameters' toggle on the right side of the Source Viewer toolbar.

Learn more about mapping parameters from sources to pages:

Still have more questions?