History of the Savarez Selector

What it was

In the late 1990s Savarez — the string maker founded by the Savaresse family in 1770 (in Paris or in Lyon, depending on the source) and based today in Caluire-et-Cuire, next to Lyon — built a program for choosing strings: the Savarez Selector [10]. It was not a conventional application but a Microsoft Excel workbook, selectorconve.xls, with fifty worksheets, about twenty Visual Basic modules and Excel 5 dialog boxes. Its macros are dated between 10 October and 14 November 1998 and signed “DT”.

Savarez’s own early-music catalogue described it as “un programme informatique de calcul de calibres, de tensions de cordes… Ce logiciel appelé Savarez Selector, propre à Savarez, vous permet de résoudre un certain nombre de problèmes concernant les cordes tels que le calcul d’une tension, la recherche d’un calibre d’une corde existante ou d’une longueur vibrante”, and stated the medium: “disponible sur le CD ROM Savarez Selector que vous pouvez utiliser sous Windows 95-98 ou à partir du logiciel Excel 7.0 ou 97 ou même 2000” [1].

From three inputs — frequency, vibrating length and tension — the Selector computed the theoretical diameter of a plain string in fluorocarbon (KF Alliance), nylon or gut and looked up the catalogue references; for wound strings it worked with linear weight (PUL) and its five families; and it carried templates for thirty-one instruments, from the classical guitar to the concert harp, with their tunings. All of it in a language “somewhere between French and English”, as a luthier remembered years later on the Delcamp forum [2].

How it was distributed and how it vanished

Savarez shipped it on the “Savarez Selector” CD-ROM and, for a while, it could be downloaded from savarez.fr as Selectorconve.zip. In March 2014 the luthier Trevor Gore told the story on Delcamp: “Once upon a time, on that thing that Savarez calls a website, you could download a zipped Excel spreadsheet called ‘Selectorconve.zip’. This is a spreadsheet with a lot of macros that is supposed to help you design/choose string sets…”; and he added that it was no longer available: “they ask you to contact them and they will send you a copy” [2].

The community missed it because Savarez’s website did not publish complete tensions. In February 2010 a thread on the same forum found no tension data for the 540R set; three weeks later a member supplied figures “taken from an Excel spreadsheet that was distributed here some time ago” [3]. Another obtained them by writing to Savarez: “I sent an e-mail to Savarez and they sent me back a spreadsheet” (June 2010) [4], and the same figures resurfaced in 2011 in a user-compiled tension list [5]. It was in those threads that the Selector’s most opaque unit was deciphered: “P U L stands for Poids Unit Lineique; weight per unit length… Savarez use two units of length, centimeters for string length and % mm for string diameter” [2].

Today the file is no longer distributed. We searched the Internet Archive for its trace: there is no capture of the zip nor of the page that offered it between 1998 and 2006 (savarez.fr was only crawled from late 2002, and the 1998 savarez.com domain belonged to the US distributor) [10]. The program’s existence is therefore documented by the workbook itself and by Savarez’s catalogue, not by an archived copy of the download.

Why it no longer runs

The Selector was built on two techniques Excel later abandoned: the Excel 5/95 “dialog sheets”, replaced by Visual Basic UserForms, and previous-generation macros, which modern versions block by default for security reasons [6]. The workbook opens, but its 1998 interface does not appear and its routines do not run. That is why this site does not offer the file: it documents it and replicates it.

The Selector among its contemporaries

It was not the only string calculator of its time. Arto Wikla published his String Calculator in Helsinki in 1996 (version 2.0 in May 1997) [7]; Northern Renaissance Instruments handed out gut gauge tables on request [8]; and years later Lauri Niskanen wrote the calculator behind today’s Cuerdas Pulsadas String Calculator [9]. What set the Selector apart is that it was not a generic tool: it encoded Savarez’s 1998–2000 catalogue — references, gauges and linear weights — and Savarez’s own way of calculating, with coefficients explained in the concepts page.

How it was recovered

This site starts from a copy of the CD-ROM kept by Cuerdas Pulsadas. The catalogues, tunings and formulas were extracted from the file programmatically and verified against cells that Excel itself computed at the time (see the methodology). The original file and its code are not published; what is published are its data and its rules, reconstructed and checked.

Sources

  1. Savarez, Cordes pour Instruments Anciens (catalogue PDF, CD-era content, hosted on savarez.fr): https://www.savarez.fr/sites/default/files/public/produit/plaquette/catalogue_instruments_anciens.pdf
  2. Delcamp Classical Guitar Forum, “Calculating string tension using PUL (Savarez)”, March 2014 (Trevor Gore’s posts of 4 and 8 March): https://www.classicalguitardelcamp.com/viewtopic.php?t=84911
  3. Delcamp, “Tension of Savarez strings”, February–March 2010: https://www.classicalguitardelcamp.com/viewtopic.php?t=48157
  4. Delcamp, “Individual tensions of the Savarez high-tension basses?”, June 2010: https://www.classicalguitardelcamp.com/viewtopic.php?t=47004
  5. Delcamp, “String Tension List”, July 2011: https://www.classicalguitardelcamp.com/viewtopic.php?t=60555
  6. Microsoft Q&A, “What Excel 4.0 or 5.0 macro commands have been replaced?”: https://learn.microsoft.com/en-us/answers/questions/5682053/what-excel-4-0-or-5-0-macro-commands-have-been-rep and Microsoft Tech Community, “Excel 5.0 Dialog Sheets”: https://techcommunity.microsoft.com/discussions/excelgeneral/excel-5-0-dialog-sheets/2052994
  7. Arto Wikla, String Calculator (1996–1997): https://www.cs.helsinki.fi/u/wikla/mus/Calcs/wwwscalc.html
  8. Northern Renaissance Instruments, Guide to NRI Information and Prices: http://www.nrinstruments.uwclub.net/Guide.html
  9. Lauri Niskanen, Lute String Calculator: https://niskanenlutes.com/index.php?p=stringcalc
  10. Savarez, L’histoire Savarez: https://www.savarez.fr/content/lhistoire-savarez; Internet Archive captures of savarez.fr (2002–2006): https://web.archive.org/web/2002*/savarez.fr

Museum-mode gallery

A reconstruction of six sheets of the original workbook from its own data and formatting (text, bold, background colours and column widths). These are not screenshots: modern Excel can no longer open the original with its 1998 interface; what you see is exactly what the cells contained.

Plain string calculator (corde monofilament)
Reconstruction of sheet “corde monofilament” from the original file; not a screenshot · 28 rows × 8 columns
Plain string calculator
RowABCDEFGH
1PLAIN MONOFILAMENT STRINGS CALCULATION
2 SAVAREZ
3GAUGEDECIMALTENSION CALCULATION
4
5FREQUENCELENGTHTENSIONFREQUENCE htzLongueur Cm
6hertzCmKg
700.000.0000
8GAUGEGAUGEGAUGEGAUGEGAUGEGAUGEGAUGEGAUGE
9%mm KF%mm NYL%mm Boyau%mm steelCATAL_KFCATAL_NYLONCATAL_GUT%mm steel
100.00.00.000025.0000
11187TENSIONTENSIONTENSIONTENSION
12KgKgKgKg
130.000.000.002.22
14
15
16000
17000
18000
19000
20000
21
22SELECTED REFERENCES0000
23
24
25POSITIONNOTEFREQUENCYREFGAUGETENSION
26000000.00
27000000.00
28000000.00
Wound string calculator (cordes filees)
Reconstruction of sheet “cordes filees” from the original file; not a screenshot · 30 rows × 9 columns
Wound string calculator
RowABCDEFGHI
1WOUND STRINGS CACULATION
2 SAVAREZ
3DECIMAL
4GAUGECACULATIONCALCULTENSION
5FREQUENCELONGUEURTENSIONFREQUENCELongueur Cm
6hertzCmKg
700.000.0000
8POIDSP U LP U LP U LP U LP U L
9LINEIQUENYL/AGNYL/CUNYL/PLASGUT/AGGUT/CU
100.000.000.00selected0.000.000.000.000.00
11TENSIONTENSIONTENSIONTENSIONTENSION
12KgKgKgKgKg
130.000.000.000.000.00
14
15NYLON SILVER platedNYLON copper wdNYLON PLASTIC WdGUT wd silverplated GUT copper Wd
160.000.000.000.000.00
170.000.000.000.000.00
180.000.000.000.000.00
190.000.000.000.000.00
200.000.000.000.000.000
21Nylon /silver platedNylon copperNylon plastic WdBoyau/silverplatedGUT /copper
22SELECTED REFERENCE00000
23
24
25POSITIONNOTEFREQUENCEREFPULTENSION
26000000.00
27000000.00
28000000.00
29000000.00
30000000.00
Gauge and PUL catalogue (diam_mono)
Reconstruction of sheet “diam_mono” from the original file; not a screenshot · 40 rows × 26 columns
Gauge and PUL catalogue
RowABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2KF_NUnylon_nuBOYAU_NUNYLFILAGNYLFILAG_REFNYLFILCUNYLFILCU_REFNYLFILPLASNYLFILPLAS_REFBOYFILAGBOYFILAG_REFBOYFILCUBOYFILCU_REFKFNNNBRHBRVKFNNNBRHBRVLIGTHSOL GHYP 1
3000000000000000000000MEDIUMLA AHYP 2
430403870NFA7070NFC7255NFP55100BFA102110BFC110KF30NN40BRH38BRV38HPK30HPN40HPBH38HPBV38FORTEHYP 3
533424080NFA8080NFC8260NFP60120BFA122130BFC130KF33NN42BRH40BRV40HPK33HPN42HPBH40HPBV40
637444490NFA9090NFC9265NFP65130BFA132140BFC140KF37NN44BRH44BRV44HPK37HPN44HPBH44HPBV44
7414748100NFA100100NFC10270NFP70140BFA142160BFC160KF41NN47BRH48BRV48HPK41HPN47HPBH48HPBV48
8435051110NFA110110NFC11280NFP80160BFA162170BFC170KF43NN50BRH51BRV51HPK43HPN50HPBH51HPBV51
9455253120NFA120120NFC12290NFP90170BFA172180BFC180KF45NN52BRH53BRV53HPK45HPN52HPBH53HPBV53
10475455135NFA135135NFC132100NFP100190BFA192190BFC190KF47NN54BRH55BRV55HPK47HPN54HPBH55HPBV55
11505658150NFA150150NFC152110NFP110210BFA212200BFC200KF50NN56BRH58BRV58HPK50HPN56HPBH58HPBV58
12525861170NFA170170NFC172120NFP120220BFA222210BFC210KF52NN58BRH61BRV61HPK52HPN58HPBH61HPBV61
13556063190NFA190190NFC192130NFP130240BFA242220BFC220KF55NN60BRH63BRV63HPK55HPN60HPBH63HPBV63
14576466210NFA210210NFC212150NFP150260BFA262240BFC240KF57NN64BRH66BRV66HPK57HPN64HPBH66HPBV66
15606668230NFA230230NFC232170NFP170280BFA282250BFC250KF60NN66BRH68BRV68HPK60HPN66HPBH68HPBV68
16626871250NFA250250NFC252210NFP210300BFA302260BFC260KF62NN68BRH71BRV71HPK62HPN68HPBH71HPBV71
17647074275NFA275275NFC272230NFP230320BFA322280BFC280KF64NN70BRH74BRV74HPK64HPN70HPBH74HPBV74
18667279300NFA300300NFC302250NFP250350BFA352300BFC300KF66NN72BRH79BRV79HPK66HPN72HPBH79HPBV79
19697481325NFA325325NFC322270NFP270370BFA372320BFC320KF69NN74BRH81BRV81HPK69HPN74HPBH81HPBV81
20717784350NFA350350NFC352300NFP300400BFA402340BFC340KF71NN77BRH84BRV84HPK71HPN77HPBH84HPBV84
21748089375NFA375380NFC382320NFP320420BFA422360BFC360KF74NN80BRH89BRV89HPK74HPN80HPBH89HPBV89
22778394410NFA410410NFC412350NFP350440BFA442380BFC380KF77NN83BRH94BRV94HPK77HPN83HPBH94HPBV94
23818697430NFA430440NFC442380NFP380480BFA482410BFC410KF81NN86BRH97BRV97HPK81HPN86HPBH97HPBV97
24848999500NFA500480NFC482410NFP410480BFA484440BFC440KF84NN89BRH99BRV99HPK84HPN89HPBH99HPBV99
258691104530NFA530520NFC522NONO530BFA532470BFC470KF86NN91BRH104BRV104HPK86HPN91HPBH104HPBV104
269194109560NFA560550NFC552NONO590BFA592500BFC500KF91NN94BRH109BRV109HPK91HPN94HPBH109HPBV109
279597114NONO620NFC622NONO640BFA642530BFC530KF95NN97BRH114BRV114HPK95HPN97HPBH114HPBV114
28101100122NONONONONONO700BFA702570BFC570KF101NN100BRH122BRV122HPK101HPN100HPBH122HPBV122
29105103127NONONONONONO750BFA752610BFC610KF105NN103BRH127BRV127HPK105HPN103HPBH127HPBV127
30108107132NONONONONONO790BFA792640BFC640KF108NN107BRH132BRV132HPK108HPN107HPBH132HPBV132
31116110137NONONONONONO850BFA854710BFC710KF116NN110BRH137BRV137HPK116HPN110HPBH137HPBV137
32121112142NONONONONONO920BFA922760BFC760KF121NN112BRH142BRV142HPK121HPN112HPBH142HPBV142
33125122150NONONONONONO930BFA934810BFC810KF125NN122BRH150BRV150HPK125HPN122HPBH150HPBV150
34127127160NONONONONONO1000BFA1002880BFC880KF127NN127BRH160BRV160HPK127HPN127HPBH160HPBV160
35132132170NONONONONONO1100BFA1102950BFC950KF132NN132BRH170BRV170HPK132HPN132HPBH170HPBV170
36136137178NONONONONONO1230BFA12321010BFC1010KF136NN137BRH178BRV178HPK136HPN137HPBH178HPBV178
37140140185NONONONONONO1280BFA12821120BFC1120KF140NN140BRH185BRV185HPK140HPN140HPBH185HPBV185
38145145193NONONONONONO1350BFA13521250BFC1250KF145NN145BRH193BRV193HPK145HPN145HPBH193HPBV193
39150160203NONONONONONO1470BFA1474NONOKF150NN160BRH203BRV203HPK150HPN160HPBH203HPBV203
40160172213NONONONONONO1630BFA1632NONOKF160NN172BRH213BRV213HPK160HPN172HPBH213HPBV213
Template: classical guitar (GUITARECLASSIQ6C)
Reconstruction of sheet “GUITARECLASSIQ6C” from the original file; not a screenshot · 17 rows × 11 columns
Template: classical guitar
RowABCDEFGHIJK
1
2
3
4
5
6
7
8
9GUITARE
10PositionHertzlengthKF gaugenylon gaugegut gaugeP U LTENSION
11
12MI1330
13SI2247
14SOL3196
15RE4147
16LA5110
17MI682.4
Template: Renaissance lute (with the example Excel computed) (LUTREN)
Reconstruction of sheet “LUTREN” from the original file; not a screenshot · 30 rows × 12 columns
Template: Renaissance lute (with the example Excel computed)
RowABCDEFGHIJKL
1
2
3
4
5
6
7
8
9LUTH RENAISSANCE
10PositionHertzlengthKF gaugenylon gaugegut gaugeP U LTENSION
11SPECIFIC A 440
12SOL11392.360,534.6170621613
13RE22293.760,546.239397113
14RE32 uni293.760,546.239397113
15LA43220.160,561.6970761063
16LA53 uni220.160,561.6970761063
17FA64174.960,577.6261393913
18FA74 uni174.960,577.6261393913
19DO85130.960,5117.120661073
20DO95 uni130.960,5117.120661073
21SOL10698.160,5208.777630723
22SOL116 octa196.160,569.2341243223
23FA12787.460,5263.095249733
24FA137 octa174.960,577.6261393913
25MI14882.560,5295.126519593
26MI158 octa165.060,582.3156362443
27RE16973.560,5371.964044243
28RE179 octa146.960,592.4120707043
29DO181065.460,5469.24224313
30DO1910 octa130.960,5103.711036433
Template: concert harp (CONCHARP)
Reconstruction of sheet “CONCHARP” from the original file; not a screenshot · 40 rows × 12 columns
Template: concert harp
RowABCDEFGHIJKL
1
2
3
4
5
6
7
8
9CONCERT HARP
10Position frequency HertzVL cm or inchesgauge KF %mm or inchesgauge NYLON %mm or inchesgauge GUT %mm or inchesPULTENSION
11
12SOL - G-20O3136.00
13FA - F-102794.00
14MI - E112637.00
15RE - D222345.00
16DO - C332093.00
17SI - B441976.00
18LA - A551760.00
19SOL - G661568.00
20FA - F771397.00
21MI - E881318.00
22RE - D991175.00
23DO - C10101046.00
24SI - B1111988.00
25LA - A1212880.00
26SOL - G1313784.00
27FA - F1414698.00
28MI - E1515659.00
29RE - D1616588.00
30DO - C1717523.00
31SI - B1818494.00
32LA - A1919440.00
33SOL - G2020392.00
34FA - F2121349.00
35MI - E2222330.00
36RE - D2323294.00
37DO - C2424262.00
38SI - B2525247.00
39LA - A2626220.00
40SOL - G2727196.00