Table of Offsets into Rhino as 3D Points

First the short version, then more details and some “how to” tips.

Attached is an Excel spreadsheet I use for importing a table of offsets into Rhino as a set of 3D points. It is a zipped file/folder because this forum does not allow direct uploading of .xls files.
Offset Input Template (49.5 KB)
The spreadsheet uses the conventional system for units of feet and inches of writing the offsets as feet - inches (integers) - eighths of inches. For example 4-6-3 is 4 feet 6 3/8 inches.
After entering the offsets on the first sheet the second sheet is saved as a .csv file, which can then be imported into Rhino.

Example of a Mukilteo boat which was documented for the National Park Service by Jack Becker. The lines and table of offsets can be downloaded at 1. Lines and offsets table - 19' 6" Mukilteo Boat, The Center for Wooden Boats, Seattle, King County, WA

Excel spreadsheet with the offsets entered:
Mukilteo (59.7 KB)

.csv file with offsets:
Mukilteo Points4.csv (27.7 KB)

Rhino 7 .3dm file with offsets as 3D points:
Mukilteo Points Imported 4.3dm (1.5 MB)

Rhino 7 .3dm file with points sorted and initial curves:
Mukilteo 004.3dm (1.6 MB)

Initial post updated with corrected files.

Additional posts planned instructions and tips on entering data into the spreadsheet.

Hi David,

This is going to be educational - well done! Incidentally, I note that the offsets were derived in Rhino from a point cloud so you are going full circle with our favourite tool…

One question about the dimension format: I presume that a plus symbol at the end simply means slightly more than the 8th?


Notes on entering offsets in the Excel spreadsheet:

Do not make corrections in the Excel spreadsheet by dragging the contents of cells. The result will be errors in the output. Dragging cells in the spreadsheet will change the references in the formulas used to create the sheet for the .csv file. If you make a mistake and type input in the wrong cells then back up and type it in the correct cells.

Each offset location has three cell for feet, inches and eighths of inches respectively. This follows the standard format used in tables of offsets. In the spread sheet it is permitted to enter values for greater than 11 and values for eighths greater than 7. Also the values entered do not have to be integers. For example the following are equivalent:
5 feet 3 inches 1 eighths
0 feet 63 inches 1 eighths
5 feet 3.125 inches 0 eighths
0 feet 63.125 inches 0 eighths
All of the above result in 63.125 as the value in the .csv file.

Negative values can be entered for offsets. This can be useful if points are desired below the baseline for example. The entry in each cell needs to be entered as a negative number. For example -2 feet -7 inches -2 eighths results in -31.25 in the .csv file. If -2 feet 7 inches 2 eighths is entered instead the result in the .csv file will be -16.75 in the .csv file.

Entries in tables of offsets frequently contain “+” after the number of eighths. This usually means to add 1/16 inch to the offsets. I add .5 to the number of eighths when entering the corresponding value in the spreadsheet. For example 1 5 2+ is entered as 1 5 2.5