Skip to main content

Pensolve - Engineering Spreadsheet Standard

Pensolve

Assess spreadsheets to highlight potential errors and convert to hand-written calculations

The Pensolve add-on allows you to directly connect with the Pensolve services and seamlessly process files to hand-written calculations.

Using the add-on you can:

  • See all of the cells that are used in calculations through distinctive cell coloring.
  • Preview the hand-written equations before the are processed.
  • View unused cells
  • See processing errors directly within the spreadsheet

The improved connectivity compared to using Pensolve's standalone web application means that users learn faster and can find calculation issues easier.

Benefits to the engineering firm:

  • Speed up the review of spreadsheet-based calculations by providing a uniform and transparent presentation format for spreadsheet calculations
  • Reduce errors in spreadsheets
  • Minimise the loss of knowledge when a senior engineer leaves and his/her spreadsheets cannot be followed by others
  • Allow self-review of spreadsheets - by viewing the calculations in a hand-written format the spreadsheet developer can check whether the formulas are what he/she intended
  • Reinforce a culture of developing clear well-documented spreadsheets that can be easily interpreted by the whole firm
  • Provide professional documentation of calculations for peer-review and consent applications
  • Minimise the effort required to train new staff to follow the company spreadsheet formatting standards
  • Minimise the time required for engineers to switch between different projects by improving the transparency of designs and assessments

You need a Pensolve account to make use of this add-in.

Add-in capabilities
When this add-in is used, it
  • Can read and make changes to your document
  • Can send data over the Internet
  • https://az158878.vo.msecnd.net/marketing/Partner_21474847099/Product_42949680922/Asset_76067594-c2ce-4af6-9328-3a0d2825d298/exceladdinscreenshots.png
    /images/videoOverlay.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474847099/Product_42949680922/Asset_76067594-c2ce-4af6-9328-3a0d2825d298/exceladdinscreenshots.png
    /images/videoOverlay.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474847099/Product_42949680922/Asset_76067594-c2ce-4af6-9328-3a0d2825d298/exceladdinscreenshots.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474847099/Product_42949680922/Asset_47948cc6-790c-43a0-8b30-7b4a14a82311/exceladdinscreenshots2.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474847099/Product_42949680922/Asset_47e5aace-9415-4ded-94dd-80289b80ea78/exceladdinscreenshots3.png