Charts and Spreadsheets

[24-24-2015 edited to add link to other charts]

Charts, Spreadsheets, Etc.

This page includes various charts useful to machining. Additional charts will be added to this page as time permits. All charts will be provided in both editable and PDF formats. Editable formats will be ODF (Open Document Format) as provided by LibreOffice.

NOTE: For links to other useful online charts and tables, look here: https://sites.google.com/site/lagadoacademy/useful-links#charts

List of charts and spreadsheets:

• Angle Plate Hole Coordinates (spreadsheet)
• Bolt Circle Calculator (spreadsheet)
• Fraction - Decimal Conversion Chart (chart)
• Spring Making (spreadsheet)
• Thermal Expansion (spreadsheet)

Angle Plate Hole Coordinates

This chart (and spreadsheet) provides coordinates for drilling holes for the purpose of milling angle plates for a precise number of degrees. In addition, the spreadsheet enables the calculation of additional angles not listed in the chart. For an example of how this chart is used to make angle plates, see the Angle Plate link on this website.

• Chart in spreadsheet format : https://docs.google.com/open?id=0Bykt5WZ092aWZVdCcW5ya2xUc0k
• Chart in PDF format : https://docs.google.com/open?id=0Bykt5WZ092aWUjlYVXNuNjFSb0k

Bolt Circle Calculator

This spreadsheet calculates the X, Y coordinates for a specified number of bolt holes in a circle of specified radius; the resulting table can be printed out for use at the workbench. As noted above, this spreadsheet is for LibreOffice Calc; it will probably work in Excel, but this has not been tested.

Updated 7-26-2018 to support metric entries and results.

Updated 7-27-2018 to include Google Sheets version; this can be used online.

• LibreOffice spreadsheet (version 2) : https://drive.google.com/open?id=1Eujhoz3CLyz-_6dk8HpNIo8htTEHxsum
• LibreOffice spreadsheet (version 3) : https://drive.google.com/file/d/1n90Sj8gXJTHKdGzi8LlLbFqWboalTDIg/view?usp=sharing
  • This version also creates a diagram showing bolt hole locations.
• Google Sheets spreadsheet : https://docs.google.com/spreadsheets/d/1JE6Tt7UnyC4nbgOoON_pJlHz_j5rWDyW6gJtx5UIelY/edit?usp=sharing

Fraction - Decimal Conversion Chart

This chart is intended to provide all of the commonly used fractions from 1/64 to 1 by 64ths, while at the same time providing improved readability. Decimal equivalents are provided to four decimal places. Since typically only three decimal places are used, the fourth decimal place is included in a reduced font size so that the first three decimal places may be more easily read.

• Chart in spreadsheet format : https://docs.google.com/open?id=0Bykt5WZ092aWOE1QSTRMUjQ2bE0
• Chart in PDF format : https://docs.google.com/open?id=0Bykt5WZ092aWVGZVSTAyMHZtQlk

Spring Making

[Aug. 17, 2015]

The site page on Spring Making includes links to a spreadsheet for calculating mandrel sizes for spring winding, as well as calculations for duplicating a spring using different spring wire types, etc.

Thermal Expansion

This spreadsheet enables the calculation of the amount of thermal expansion in a material with change in temperature. The spreadsheet enables the selection of material type (iron, aluminum, etc.), the initial length (in mm or inches) and the starting and ending temperature (°F or °C). This spreadsheet was created in LibreOffice and saved to the two formats below; the spreadsheet has not been tested in Excel.

• Spreadsheet in LibreOffice Calc (.ods) format : https://drive.google.com/file/d/0Bykt5WZ092aWQ190cjFPdFJhUEk/edit?usp=sharing
• Spreadsheet in Excel (.xls) format : https://drive.google.com/file/d/0Bykt5WZ092aWOEhLQWtiaHF4c2M/edit?usp=sharing