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: 120


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


Headless Guitar Project - a $100 eBay kit & Gitty pickups

Started by Cigar Box Nation in Feature Articles. Last reply by Poorness Studios on Thursday. 5 Replies

Cigar Box Amp Mods

Started by Cigar Box Nation in Feature Articles. Last reply by RTZGUITARS Sep 17. 14 Replies

Blog Posts

Prototyping with a big ol' wine box

Posted by Ben on September 23, 2021 at 4:00pm 0 Comments

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

Latest Activity

steven hale liked GARAGE HERMIT's photo
20 minutes ago
Profile IconAlicia a carle, Ribs, maurizio nardini and 3 more joined Cigar Box Nation
43 minutes ago
Poorness Studios posted a video

Jewelry Box Guitar Amp

I went to the craft store with my wife over the weekend and found this box (intended to make a jewelry box). I went home and put this amp together in a matte...
1 hour ago
Lane Martin liked Uncle John's discussion Dave passed away on Friday AM, 9/17/21. Thanks for all the well-wishers before and after his passing.
1 hour ago
James Pobog replied to James Pobog's discussion Non-CBG build finished today...
"Thanks. As with all my builds, the camera hides a multitude of sins..."
2 hours ago
Poorness Studios liked James Pobog's discussion Non-CBG build finished today...
2 hours ago
Uncle John commented on Poorness Studios's photo

Jewelry Box to Guitar Amp

"You got a good balance on the amp between manufactured and just right home made.   Nice…"
4 hours ago
Uncle John commented on Sam Brown's photo

Recent CBG

"Hard to pick my fave. I like those lop sided head stocks. I like the yard sticks and all the sound…"
4 hours ago
Uncle John commented on smilingdog1's photo

Swamp Witch Guitar

"Fantastic prize and fest.  Good on Pick and you 61 Roadhouse folks."
4 hours ago
Uncle John commented on RON NORTHCUTT's photo

compass dulcijo

"The compass is pointing to excellent."
4 hours ago
Uncle John commented on Cigar Box Blues's photo

Diamond Dave

"Go Dave!"
4 hours ago
Uncle John commented on Poorness Studios's photo

Jewelry Box to Guitar Amp

"Kale, I am a homebody and a heavy traffic hater.   But I know you attend a lot of…"
4 hours 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 -->