Frequently asked questions

I cannot signup for an account

If your web-browser blocks pop ups then this can often cause issues with our sign up system. Please try a different web-browser (eg. Google Chrome) or try to signup using your phone (not connected to wifi). Once you have signed up on your phone you can use the details to log in on your desktop.

If the above steps do not work then please check if you can visit this link to a public Pensolve file.

If you can not see and download the PDF of the public file, then please contact the team at team@pensolve.com and we will help you with the sign up.

Convert Excel file to Google Sheets

  1. Put the Excel file into a Google Drive folder
  2. Go to Google drive on the web browser https://drive.google.com/drive
  3. Navigate to the Excel file and right click then select 'Open with' > 'Google Sheets'.
  4. The file should open as a Google Sheets file
  5. If you have the Pensolve Add-on installed you can click on 'Add-on' > 'Pensolve' > 'Show sidebar'
  6. Click 'Process to PDF' to convert to a Pensolve PDF

Convert Google Sheets to Excel

  1. In Google Sheets click 'File' > 'Download as' > 'Microsoft Excel (.xlsx)'

What is the maximum length of a parameter name?

16 characters, long names make the calculations hard to read.

How can I add a comment/note in the spreadsheet that is not attached to calculations.

  1. You can write the note directly underneath a section heading (before any calculations), in which case it will appear as summary text for that section.
  2. You can add 'Note: ' infront of the comment/note and it will appear as a note in itallics in the output.

How can I reduce the number of pages in the output

You can put tables onto seperate sheets and then write | PENOUT | SUMMARY | in adjacent cells, this reduces the verbosity of that sheet. You could also write | PENOUT | NONE |, which completely hides that sheet.

Summarise or hide an individual section

summarise a section

Pensolve has not shown my tables correctly

This can occur when you have individual inputs adjacent to a table, then Pensolve tries to include them into the table. It is good practice to leave blank cells around your tables so that other people can understand them.

To help you decode these issues and others, it is best to use the Google Sheets Add-on. This shows you how the cells are interpretted and the cell dependents to trace what uses thoses cells.

How do I add a PENBREAK

Just write 'PENBREAK' into a cell, preferably in row 1.

Pensolve does not recognise my units

If you are using a non-SI unit then you will need to put square brackets around it (e.g. [lb])

What is Pensolve?

Pensolve is a new calculation visualisation product that helps engineers to be more efficient when reviewing the integrity of their calculations.

Pensolve enables better calculation sharing and review between colleagues, and offers a new solution for companies when sharing their calculations with external parties.

Why use Pensolve?

Pensolve helps you manage your risk around spreadsheet use in design. The conversion to hand-written calculations provides tranparency to allow for quick review. By making spreadsheets more transparent engineers no longer use the as a black-box.

Pensolve also provide a version detection tool, so you can quickly see if the master file has be altered.

How can I make my .xls spreadsheet function in Pensolve?

A suitable work around is to open your .xls file in Microsoft Excel, click "Save as..." , then save it as a .xlsx file.

How can I reduce the number of pages produced by Pensolve

Pensolve reproduces every unique equation to allow the whole spreadsheet to be reviewed. However, this can be unnecessary. To compress the output of a sheet then include 'PENOUT' in one cell, and 'SUMMARY' in the cell to the right. If you don't want to include the sheet at all, write 'NONE' instead of 'SUMMARY'.

How do I include a figure in the Pensolve output

You paste the figure into the spreadsheet where you want it to appear in the output and then add a border to it.

For Microsoft Excel

For Google Sheets

Note: PDF images are not supported.

If you are using Google sheets you can find more information here.

How can I include a long table on the same sheet as individual calculations?

You can use a PENBREAK, a penbreak is like a vertical page break that allows you to include a table and then push it to the end of the PDF output. Learn more here

Why didn't my spreadsheet convert into a legible format?

Pensolve has a complex algorithm that allows it to convert engineering calculations provided the spreadsheet is set out in a certain spreadsheet layout. The 'Guide' tab within the Pensolve app explains the necessary format.

Does Pensolve save the spreadsheets and conversions?

The spreadsheets that users convert are kept in their original format on our secured servers provided by Microsoft Azure so that we can continually improve upon the benefits that Pensolve delivers to customers e.g. exploring which spreadsheet functions are used most often.

For more detailed information on how your information is used and secured by Pensolve please read through Pensolve’s Privacy Policy.

Why can Pensolve be trusted with a customer’s intellectual property?

At Pensolve we take intellectual property seriously. Our algorithms, the primary source of our company's value, are unique to us, so we understand that your spreadsheets are extremely valuable to you.

In order to protect your IP, Pensolve provides an encrypted connection between your spreadsheet and our servers. Further, Pensolve claims no rights to any IP that customers convert using Pensolve. Our customers retain intellectual property rights to the content they convert using Pensolve, in both its spreadsheet and converted form.

In short, what belongs to you stays yours

For further information about our security arrangements please read our Terms of Service and Privacy Policy. Pensolve is happy for our customers to audit our security arrangements: contact us at support@pensolve.com.

When will Pensolve be available?

Pensolve is available now! We are constantly updating Pensolve with new features to deliver even more value to our customers. If you have an idea for a feature that Pensolve does not currently offer then we would love to hear from you at team@pensolve.com.

How can I get Pensolve?

You can conveniently access your secure Pensolve account from any computer with an internet connection.

We at Pensolve want to give our customers the best product possible which means we are determined to seamlessly deliver new product benefits and capabilities to our customers. As a result, Pensolve cannot ship physical CDs of the product.

Not a customer? Please contact Pensolve for a local sales representative for more information on purchasing Pensolve.

Find out more

Check out Pensolve's Youtube videos.