{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["X","Y","Z"],"not_rendered":{"charts":6,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"X","index":0,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":false,"merged":[[19,1,19,3],[19,4,19,5]]}
["3D Printer accuracy test to be used with: ",null,null,"https://www.thingiverse.com/thing:2484766  "]
["axis","X"]
["scale",1]
[null,null,null,"expected"]
[null,null,"now","after correction"]
["Axis setting[steps per mm]",null,200,{"$f":"C11*C6","v":200.13224519071909}]
["G-code",null,"M501",{"$f":"CONCATENATE(\"M92 X\",D6)","v":"M92 X200.132245190719"},"To save:","M500"]
[]
["Standard deviation [mm]",null,{"$f":"SQRT(SUMSQ(F22:F36)/COUNT(F22:F36))","v":0.11107498950877776},{"$f":"SQRT(SUMSQ(H23:H35)/COUNT(H23:H35))","v":0.1086049250215773}]
["mean wall thickness deviation [mm]",null,{"$f":"INTERCEPT(E22:E36,C22:C36)","v":7.7524324324323129E-2},{"$f":"C10","v":7.7524324324323129E-2},"constant offset (may be reduced by extrusion mutiplier)"]
["Multiplier",null,{"$f":"SLOPE(C22:C36,D22:D36)","v":1.0006612259535954}]
[]
["Derived desing gidelines"]
["Tolerance needed so 50% will fit",null,0,0]
["Tolerance needed to 84% of the prints fit ",null,{"$f":"C9+ABS(C10)","v":0.18859931383310088},{"$f":"D9","v":0.1086049250215773}]
["Tolerance needed to 97% of the prints fit ",null,{"$f":"C9*2+ABS(C10)","v":0.29967430334187861},{"$f":"D9*2","v":0.2172098500431546}]
["Tolerance needed to 99.8% of the prints fit ",null,{"$f":"C9*3+ABS(C10)","v":0.41074929285065642},{"$f":"D9*3","v":0.32581477506473189}]
["Mean relative deviation",null,{"$f":"(1-C11)","v":-6.6122595359541236E-4},0]
[]
[null,"length",null,null,"now",null,"expected after corretion"]
[null,"should be","scaled","is","deviation","no offset","deviation","no offset"]
[1,5,{"$f":"B22*$B$3","v":5},5.07,{"$f":"D22-C22","v":7.0000000000000284E-2},{"$f":"E22-$C$10","v":-7.5243243243228453E-3},{"$f":"D22*$C$11-C22","v":7.3352415584729158E-2},{"$f":"G22-$C$10","v":-4.1719087395939713E-3}]
[2,10,{"$f":"B23*$B$3","v":10},10.1,{"$f":"D23-C23","v":9.9999999999999645E-2},{"$f":"E23-$C$10","v":2.2475675675676515E-2},0.10667838213131375,{"$f":"G23-$C$10","v":2.9154057806990624E-2}]
[3,15,15,14.97,{"$f":"D24-C24","v":-2.9999999999999361E-2},-0.10752432432432249,-2.0101447474676348E-2,-9.7625771798999478E-2]
[4,20,20,19.97,-3.0000000000001137E-2,-0.10752432432432427,-1.6795317706701951E-2,-9.431964203102508E-2]
[5,25,25,25.04,3.9999999999999147E-2,-3.7524324324323982E-2,5.6557097878027207E-2,-2.0967226446295922E-2]
[6,50,50,50.26,0.25999999999999801,0.18247567567567488,0.29323321642770139,0.21570889210337826]
[7,100,100,100.23,0.23000000000000398,0.15247567567568085,0.29627467732886714,0.21875035300454401]
[8,150,150,149.80000000000001,-0.19999999999998863,-0.27752432432431173,-0.10094835215139142,-0.17847267647571455]
[9,125,125,124.99,-1.0000000000005116E-2,-8.7524324324328245E-2,7.2646631939889517E-2,-4.8776923844336129E-3]
[10,75,75,75.03,3.0000000000001137E-2,-4.7524324324321993E-2,7.9611783298261685E-2,2.0874589739385552E-3]
[11,25,25,25.05,5.0000000000000711E-2,-2.7524324324322419E-2,6.6563710137565124E-2,-1.0960614186758005E-2]
[12,20,20,19.989999999999998,-1.0000000000001563E-2,-8.7524324324324693E-2,3.2179068123703303E-3,-7.4306417511952799E-2]
[13,15,15,15.04,3.9999999999999147E-2,-3.7524324324323982E-2,4.994483834207486E-2,-2.757948598224827E-2]
[14,10,10,10.039999999999999,3.9999999999999147E-2,-3.7524324324323982E-2,4.663870857409691E-2,-3.088561575022622E-2]
[15,5,5,5.15,0.15000000000000036,7.2475675675677226E-2,0.15340531366101651,7.5880989336693377E-2]
[]
["Instructions:"]
["Only edit the yellow fields"]
["1) enter the current setting for the steps per mm (Control->motion->Xsteps/mmm)"]
["2) print the  part "]
["3) Measure the distance fromm the base to the top of each colum"]
[]
[]
["in green is the result you can use for your printer setting",{"$nulls":7},"Histogram",null,"current","after correction"]
["in blue are the recomended toleances (gaps between parts) to e used when designing",{"$nulls":7},-0.5,"<=-0.5",{"$f":"FREQUENCY(E22:E36,I46:I56)","v":0},{"$f":"FREQUENCY(G22:G36,I46:I56)","v":0}]
[{"$nulls":8},{"$f":"I46+0.1","v":-0.4},{"$f":"AVERAGE(I46:I47)","v":-0.45},0,0]
["all values are in mm",{"$nulls":7},{"$f":"I47+0.1","v":-0.30000000000000004},{"$f":"AVERAGE(I47:I48)","v":-0.35000000000000003},0,0]
[{"$nulls":8},-0.20000000000000004,-0.25000000000000006,0,0]
[{"$nulls":8},-0.10000000000000003,-0.15000000000000002,1,1]
[{"$nulls":8},0,-5.0000000000000017E-2,4,2]
[{"$nulls":8},0.1,0.05,7,8]
[{"$nulls":8},0.2,0.15000000000000002,1,2]
[{"$nulls":8},0.30000000000000004,0.25,2,2]
[{"$nulls":8},0.4,0.35000000000000003,0,0]
[{"$nulls":8},0.5,0.45,0,0]
[{"$nulls":9},">=0.5",0,0]

{"sheet":"Y","index":1,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[18,4,18,5],[18,1,18,3]]}
["axis","Y"]
["scale",1]
[null,null,null,"expected"]
[null,null,"now","after correction"]
["Axis setting[steps per mm]",null,200,{"$f":"C10*C5","v":200.23215674551778}]
["G-code",null,"M501",{"$f":"CONCATENATE(\"M92 \",B1,D5)","v":"M92 Y200.232156745518"},"To save:","M500"]
[]
["Standard deviation [mm]",null,{"$f":"SQRT(SUMSQ(F21:F35)/COUNT(F21:F35))","v":0.17598777964082604},{"$f":"SQRT(SUMSQ(H21:H35)/COUNT(H22:H34))","v":0.17196745335366487}]
["mean wall thickness deviation [mm]",null,{"$f":"INTERCEPT(E21:E35,C21:C35)","v":0.17144864864864956},{"$f":"C9","v":0.17144864864864956},"constant offset (may be reduced by extrusion mutiplier)"]
["Multiplier",null,{"$f":"SLOPE(C21:C35,D21:D35)","v":1.0011607837275889}]
[]
["Derived desing gidelines"]
["Tolerance needed so 50% will fit",null,0,0]
["Tolerance needed to 84% of the prints fit ",null,{"$f":"C8+ABS(C9)","v":0.34743642828947563},{"$f":"D8","v":0.17196745335366487}]
["Tolerance needed to 97% of the prints fit ",null,{"$f":"C8*2+ABS(C9)","v":0.52342420793030164},{"$f":"D8*2","v":0.34393490670732974}]
["Tolerance needed to 99.8% of the prints fit ",null,{"$f":"C8*3+ABS(C9)","v":0.69941198757112777},{"$f":"D8*3","v":0.51590236006099466}]
["Mean relative deviation",null,{"$f":"(1-C10)","v":-1.1607837275888766E-3},0]
[]
[null,"length",null,null,"now",null,"expected after corretion"]
[null,"should be","scaled","is","deviation","no offset","deviation","no offset"]
[1,5,{"$f":"B21*$B$2","v":5},5.24,{"$f":"D21-C21","v":0.24000000000000021},{"$f":"E21-$C$9","v":6.8551351351350653E-2},{"$f":"D21*$C$10-C21","v":0.2460825067325656},{"$f":"G21-$C$9","v":7.4633858083916038E-2}]
[2,10,{"$f":"B22*$B$2","v":10},10.210000000000001,{"$f":"D22-C22","v":0.21000000000000085},{"$f":"E22-$C$9","v":3.8551351351351293E-2},0.22185160185868291,{"$f":"G22-$C$9","v":5.0402953210033352E-2}]
[3,15,15,15.21,{"$f":"D23-C23","v":0.21000000000000085},3.8551351351351293E-2,0.22765552049662752,5.6206871847977957E-2]
[4,20,20,20.25,0.25,7.855135135135044E-2,0.27350587048367458,0.10205722183502502]
[5,25,25,25.11,0.10999999999999943,-6.1448648648650128E-2,0.13914727939975435,-3.2301369248895206E-2]
[6,50,50,50.37,0.36999999999999744,0.19855135135134788,0.42846867635864783,0.25702002770999827]
[7,100,100,100.07,6.9999999999993179E-2,-0.10144864864865638,0.18615962761981564,1.4710978971166078E-2]
[8,150,150,149.76,-0.24000000000000909,-0.41144864864865865,-6.6161028956287282E-2,-0.23760967760493684]
[9,125,125,125.03,3.0000000000001137E-2,-0.14144864864864842,0.17513278946043442,3.684140811784864E-3]
[10,75,75,75.45,0.45000000000000284,0.27855135135135328,0.53758113224658644,0.36613248359793688]
[11,25,25,25.07,7.0000000000000284E-2,-0.10144864864864928,9.9100848050653667E-2,-7.2347800597995893E-2]
[12,20,20,19.98,-1.9999999999999574E-2,-0.19144864864864913,3.1924588772263007E-3,-0.16825618977142326]
[13,15,15,14.94,-6.0000000000000497E-2,-0.23144864864865006,-4.2657891109822543E-2,-0.2141065397584721]
[14,10,10,10.01,9.9999999999997868E-3,-0.16144864864864977,2.161944511316527E-2,-0.14982920353548429]
[15,5,5,5.1100000000000003,0.11000000000000032,-6.144864864864924E-2,0.11593160484797949,-5.5517043800670074E-2]
[]
["Instructions:"]
["Only edit the yellow fields"]
["1) enter the current setting for the steps per mm (Control->motion->Xsteps/mmm)"]
["2) print the part"]
["3) Measure the distance fromm the base to the top of each colum"]
[]
[]
["in green is the result you can use for your printer setting",{"$nulls":7},"Histogram",null,"current","after correction"]
["in blue are the recomended toleances (gaps between parts) to e used when designing",{"$nulls":7},-0.5,"<=-0.5",{"$f":"FREQUENCY(E21:E35,I45:I55)","v":0},{"$f":"FREQUENCY(G21:G35,I45:I55)","v":0}]
[{"$nulls":8},{"$f":"I45+0.1","v":-0.4},{"$f":"AVERAGE(I45:I46)","v":-0.45},0,0]
["all values are in mm",{"$nulls":7},{"$f":"I46+0.1","v":-0.30000000000000004},{"$f":"AVERAGE(I46:I47)","v":-0.35000000000000003},0,0]
[{"$nulls":8},-0.20000000000000004,-0.25000000000000006,1,0]
[{"$nulls":8},-0.10000000000000003,-0.15000000000000002,0,0]
[{"$nulls":8},0,-5.0000000000000017E-2,2,2]
[{"$nulls":8},0.1,0.05,4,3]
[{"$nulls":8},0.2,0.15000000000000002,2,4]
[{"$nulls":8},0.30000000000000004,0.25,4,4]
[{"$nulls":8},0.4,0.35000000000000003,1,0]
[{"$nulls":8},0.5,0.45,1,1]
[{"$nulls":9},">=0.5",0,1]

{"sheet":"Z","index":2,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[18,1,18,2],[18,4,18,5]]}
["axis","Z"]
["scale",1]
[null,null,null,"expected"]
[null,null,"now","after correction"]
["Axis setting[steps per mm]",null,800,{"$f":"C10*C5","v":800.41054746984219}]
["G-code",null,"M501",{"$f":"CONCATENATE(\"M92 \",B1,D5)","v":"M92 Z800.410547469842"},"To save:","M500"]
[]
["Standard deviation [mm]",null,{"$f":"SQRT(SUMSQ(F21:F29)/COUNT(F21:F29))","v":7.8564937108095659E-2},{"$f":"SQRT(SUMSQ(H21:H35)/COUNT(H22:H34))","v":7.1309042820079591E-2},null,"for autolevel only"]
["base deviation [mm]",null,{"$f":"INTERCEPT(E21:E35,C21:C35)","v":-0.28694192185850148},{"$f":"C9","v":-0.28694192185850148},null,null,"old (M851)","new",null,null," "]
["Multiplier",null,{"$f":"SLOPE(C21:C35,D21:D35)","v":1.0005131843373027},null,null,"Z probe offset: ",2.35,{"$f":"G10+C9","v":2.0630580781414984},{"$f":"CONCATENATE(\"M851 \",B1,H10)","v":"M851 Z2.0630580781415"}," "]
[]
["Derived desing gidelines"]
["Tolerance needed so 50% will fit",null,0,0]
["Tolerance needed to 84% of the prints fit ",null,{"$f":"C8+ABS(C9)","v":0.36550685896659713},{"$f":"D8","v":7.1309042820079591E-2}]
["Tolerance needed to 97% of the prints fit ",null,{"$f":"C8*2+ABS(C9)","v":0.44407179607469283},{"$f":"D8*2","v":0.14261808564015918}]
["Tolerance needed to 99.8% of the prints fit ",null,{"$f":"C8*3+ABS(C9)","v":0.52263673318278847},{"$f":"D8*3","v":0.21392712846023876}]
["Mean relative deviation",null,{"$f":"(1-C10)","v":-5.1318433730274116E-4},0]
[]
[null,"length",null,null,"now",null,"expected after corretion"]
[null,"should be","scaled","is","deviation","no offset","deviation","no offset"]
[1,5,{"$f":"B21*$B$2","v":5},4.7,{"$f":"D21-C21","v":-0.29999999999999982},{"$f":"E21-$C$9","v":-1.3058078141498342E-2},{"$f":"D21*$C$10-C21","v":-0.29758803361467656},{"$f":"G21-$C$9","v":-1.0646111756175081E-2}]
[2,5,{"$f":"B22*$B$2","v":5},4.6399999999999997,{"$f":"D22-C22","v":-0.36000000000000032},{"$f":"E22-$C$9","v":-7.3058078141498839E-2},-0.35761882467491546,{"$f":"G22-$C$9","v":-7.0676902816413978E-2}]
[3,5,5,4.67,{"$f":"D23-C23","v":-0.33000000000000007},-4.305807814149859E-2,-0.32760342914479601,-4.0661507286294529E-2]
[4,5,5,4.7,-0.29999999999999982,-1.3058078141498342E-2,-0.29758803361467656,-1.0646111756175081E-2]
[5,50,50,49.77,-0.22999999999999687,5.6941921858504607E-2,-0.2044588155324405,8.2483106326060984E-2]
[6,75,75,74.8,-0.20000000000000284,8.6941921858498639E-2,-0.16161381156975096,0.12532811028875052]
[7,100,100,99.71,-0.29000000000000625,-3.058078141504772E-3,-0.23883038972755344,4.8111532130948043E-2]
[8,125,125,124.61,-0.39000000000000057,-0.10305807814149909,-0.32605209972871307,-3.9110177870211593E-2]
[9,150,150,149.55000000000001,-0.44999999999998863,-0.16305807814148715,-0.3732532823563588,-8.6311360497857315E-2]
{"$rows_empty":7}
["Instructions:"]
["Only edit the yellow fields"]
["1) enter the current setting for the steps per mm (Control->motion->Xsteps/mmm)"]
["2) print the part"]
["3) Measure the distance fromm the base to the top of each colum"]
[]
[]
["in green is the result you can use for your printer setting",{"$nulls":7},"Histogram",null,"current","after correction"]
["in blue are the recomended toleances (gaps between parts) to e used when designing",{"$nulls":7},-0.5,"<=-0.5",{"$f":"FREQUENCY(E21:E35,I45:I55)","v":0},{"$f":"FREQUENCY(G21:G35,I45:I55)","v":0}]
[{"$nulls":8},{"$f":"I45+0.1","v":-0.4},{"$f":"AVERAGE(I45:I46)","v":-0.45},1,0]
["all values are in mm",{"$nulls":7},{"$f":"I46+0.1","v":-0.30000000000000004},{"$f":"AVERAGE(I46:I47)","v":-0.35000000000000003},3,4]
[{"$nulls":8},-0.20000000000000004,-0.25000000000000006,5,4]
[{"$nulls":8},-0.10000000000000003,-0.15000000000000002,0,1]
[{"$nulls":8},0,-5.0000000000000017E-2,0,0]
[{"$nulls":8},0.1,0.05,0,0]
[{"$nulls":8},0.2,0.15000000000000002,0,0]
[{"$nulls":8},0.30000000000000004,0.25,0,0]
[{"$nulls":8},0.4,0.35000000000000003,0,0]
[{"$nulls":8},0.5,0.45,0,0]
[{"$nulls":9},">=0.5",0,0]