So here is the spreadsheet.
I used it up to now for myself and that was ok for me.
When sharing, there is some need to make it a bit more fancy and self explaining. I added also some extra functions, I didn't add before.
So what will you find in it :
Yellow fields are for for data entry
Critical print height : the height you want your piece to have. Measured from the bed in mm
Max tolerance : The maximum deviation you will accept from the Critical print height in mm
Nozzle : Nozzle width in mm from the nozzle you would like to use for the print. Determines the max layer height shown in the table.
Z-stepper angle : Choose between 1,8° and 0,9° stepper angles
Displacement in mm per revolution : One complete revolution lifts the bed this number of mm
How to :
First set up the sheet by entering the Z-axis parameters. Should be done only once, unless you mount another stepper or install another leadscrew.
Enter the print related parameters (Critical print height, Tolerance, nozzle)
The values in the rest of the sheet are calculated automatically.
Layer heights :
In this column you find the layerheights you can print with the nozzle chosen. The ones that result in the exact Critical print height are highlighted.
Minimum height :
Number of layers needed for the Critical print height or just a fraction below. Height is shown and the deviation from the Critical print height.
- Light green : exactly what you wanted. Sweet spot.
- Dark green with white characters : still within tolerance
- red : out of tolerance.
: the exact height you want your print to be measured from the bed. In the column layer heights the preferred ones or sweet spots will be highlighted. These are the layer heights were you will end up with the critical print height.
The min and max columns show the real total heights for a specific layer height.
Maximum height :
The same as the Minimum height except these are just a fraction above the critical print height
Hope you like it...