I made a spreadsheet to calculate frets offline.


  • Up to 24 frets
  • unlimited scale length in inches
  • Decimal and fractional inches
  • Millimeter

The spreadsheet is in an open document format so should be able to be opened with all the usual spreadsheet programs, tested with LibreOffice and Excel.

The sheet is password protected so you can only change the scale length, if you want to play around with ift just unprotected the sheet, password is a blank password so just hit enter.

Views: 119


Reply to This

Replies to This Discussion

Mac iOS compatible?

Should be since it's using ods (Open Document Spreadsheet) don't have a Mac to test with.

comment didn't show even when I checked HTML. oh well.
I tested in excel and it works great. can do fractional scales to 0.00 (17.75 versus 17.76)
Be very handy for scales not found in standard template packs.

I know it’s completely different, but have you tried FretFind2D? It prints out a chart of fret positions in mathematical form as well as a 2 dimensional template with fret lines that fits on regular letter size paper? You just cut them in half & join them with tape to get a full size template? It even has some templates for popular maker guitars & other string instruments, you can also edit & save your custom templates within the program? But, not Mac/iOS compatible? Cheers :)

Excellent tool. It saves a tremendous amount of time and give one the flexibility to change length easily. I've attached a slightly different version that I use often. It has all the cells locked except desire scale length so I don't accidentally screw up. It shows both inch and MM lengths from the nut so you choose.

Thanks for sharing your tool.



The Essential Pages

New to Cigar Box Nation? How to Play Cigar Box GuitarsFree Plans & How to Build Cigar Box GuitarsCigar Box Guitar Building BasicsCigar Box Guitar Parts Store

Site Sponsor

Recommended Links & Resources


Cigar Box Amp Mods

Started by Cigar Box Nation in Feature Articles. Last reply by RTZGUITARS on Friday. 14 Replies

Blog Posts

Mr. Bells

Posted by Stephen Cohen on September 4, 2021 at 12:30pm 0 Comments

Bookie's Poor Man's Dobro

Posted by Steve Bookout on July 18, 2021 at 2:04pm 4 Comments

Get your groove on for free

Posted by François on July 13, 2021 at 3:05pm 1 Comment

Latest Activity

Old Man Williams commented on Old Man Williams's video

Learn To Play Beatles on 3 String Cigar Box Guitar - Norwegian Wood (This Bird Has Flown)

"Thanks for all the positive comments, I really appreciate it :-)"
15 minutes ago
Uncle John commented on Uncle John's video

Hobo’s Lullaby - repost of our recently departed friend.

"Back for another listen.  Love this.  Love that old man too.  "
30 minutes ago
Uncle John commented on Steebos Kalist's video

Life By The Drop - Cigar Box Guitar Cover

"Wow, Steebos.   Fine play, but it's the vocals I am digging here.  Anybody…"
33 minutes ago
Uncle John commented on Gary O'slide's video

Gary O'Slide Fugitif

"On the run.  Riding that poor horse hard.   Border bound."
35 minutes ago
Poorness Studios liked Steebos Kalist's video
38 minutes ago
Uncle John commented on Rich's photo

Padron 4 hole whole

"That's not a ten. But pretty darned close."
40 minutes ago
Uncle John commented on Rich's photo

Padron 4 hole front

"Me too on the sound holes, grate and painted edges. Black tail complements the black sound holes.…"
40 minutes ago
Uncle John commented on the anonymous pick's photo

swamp witch guitar bubble gum 4

"That is wonderful kitschy folk art my friend.  And no doubt, it plays well and sounds…"
43 minutes ago
Uncle John commented on the anonymous pick's photo

swamp witch guitar bubble gum 5

"Chewy. That is fun. I like it, Pick. Had a new player over last night to try my Roland Micro Cube.…"
44 minutes ago
Uncle John commented on Randy S. Bretz's photo

Ziricote fret board w/ brass powder inlay bone markers

"Looks great.  It amazes me how you get such tight, beautiful joints."
46 minutes ago
Uncle John posted a photo
48 minutes ago
Uncle John commented on Uncle John's photo

Good playing fretless. GDG.

"Good on you, Doug.  Have fun.  This one pictured is already being played pretty well by…"
49 minutes ago


© 2021   Created by Ben "C. B. Gitty" Baker.   Powered by

Badges  |  Report an Issue  |  Terms of Service

\uastyle>\ud/** Scrollup **/\ud.scrollup {\ud background: url("https://storage.ning.com/topology/rest/1.0/file/get/963882636?profile=original") no-repeat scroll 0 0 transparent;\ud bottom: 25px;\ud display: inline !important;\ud height: 40px;\ud opacity: 0.3 !important;\ud position: fixed;\ud right: 30px;\ud text-indent: -9999px;\ud width: 40px;\ud z-index: 999;\ud}\ud.scrollup:hover {\ud opacity:0.99!important;\ud}\ud \uascript type="text/javascript">\ud x$(document).ready(function(){\ud x$(window).scroll(function(){\ud if (x$(this).scrollTop() > 100) {\ud x$('.scrollup').fadeIn();\ud } else {\ud x$('.scrollup').fadeOut();\ud }\ud });\ud x$('.scrollup').click(function(){\ud x$("html, body").animate({ scrollTop: 0 }, 600);\ud return false;\ud });\ud });\ud \ua!-- End Scroll Up -->