Double Bass String tension Excel file

[DoubleMIDI]

I made a new version of my string tension excel file (now version 0.5) that has the Pirastro Perpetuals added.
(Evah Pirazzi Slaps have already been in version 0.4)

I also added a switch to show the retuned tension in the last column for all strings (not only solo strings).
So together with the changeable detuning parameter you can try any string detuning to find out the tension.
For example, setting -5 for the detuning and reading from high C to A string (orchestral tuning) you get the tension for a bumped set.

Also the string information and formula columns are protected now to avoid unwanted changes, these cells are not selectable.

Below the fixed string data is a large user space to add your own string data if you want. Just enter the relevant data in all columns.
There may be error messages if the data is not complete, but they go away if the data is completely entered.

Don’t forget that for any changes you need to download the file and load it into a spreadsheet application.

The link to my Talkbass Dropbox is:

Dropbox - Talkbass - Simplify your life

The name of the file is still “Recalculation of manufacturer tension data.xls”, only the content has changed, so please download this file again for the new version.

Have fun with it!

 

[marcox]

Such a useful tool. Thanks for the update!

 

[DoubleMIDI]

I only have checked the user part of the Excel file shortly with OpenOffice.

There might be some silly data at the begin of the user part that I used to verify my programming. That of course can be deleted or changed.

Could someone verify if entering data in the user part works for him/her and which application was used?
A short notice here would be nice.

You can simply type data from the upper part for testing.
Sorry, copy and paste should not possible because of the protected cells in the upper part.

 

[stefaniw80401]

On my copy of your file I've grouped the data by "pitch" (column F) so that I can compare relative tensions against the same string from all the manufacturers rather than see the string sets together. It's been so long I cannot remember how I did this grouping. Could've been a combination of some "sort-by/group-by" feature and manual process.

I've also color-coded the "string name" column B with an approximation of the tail-silk colors which helps my eyes find things easier.

In my "gauge" column D I've added my micrometer measurements of the string.