{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["LubriCalc","Constants","Pictures","release note"],"not_rendered":{"charts":0,"images":6,"macros":0,"external_links":0,"defined_names":15,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"LubriCalc","index":0,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[[22,6,22,9],[1,2,3,9],[9,7,21,11]]}
[]
[null,"Lubrication cycle calculator"]
[null,"V2.10 / 15.12.2023 / michsc",null,null,null,null,null,null,null,null,1]
[]
[null,"Situation:",null,null,null,null,"Type:"]
[null,"speed",3,"[m/s]",null,null,"Pump",1,null,"quantity per stroke:",{"$f":"LOOKUP(H6,Constants!B36:B37,Constants!E36:E37)","v":0.32},"[cm3]"]
[null,"shift operation",3,null,{"$f":"LOOKUP(C7,Constants!B22:B24,Constants!C22:C24)","v":24},"[h]","Gantry, Trackmotion",1,{"$f":"IF(H6=2,3+H7,H7)","v":1},"example:",{"$f":"LOOKUP(H7,Constants!B17:B19,Constants!A17:A19)","v":"EP, TMF, TMO"}]
[null,"duty cycle",50,"[%]"]
[null,null,null,null,null,null,{"$f":"VLOOKUP(I7,Constants!#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"Constants!#REF!","v":{"$error":"#REF!"}}]
[null,"direct Input for daily travel",120,"[km/day]"]
[null,"adjustment value (50% - 200%)",3,null,{"$f":"LOOKUP(C11,Constants!B27:B33,Constants!D27:D33)","v":1}]
[null,"gantry or track size",1]
[]
[]
[null,"Tabular value:  (empirical value Güdel)"]
[null,"reqiured lubrication amount U per lubrication point",{"$f":"((LOOKUP(C12,Constants!B13:B14,Constants!C13:C14))*$E$11)","v":0.3},"[cm3/100km]"]
[null,"required lubrication amount Pt (total)",{"$f":"IF(C12=1,((LOOKUP($H$7,Constants!B52:B54,Constants!C52:C54))*$E$11),((LOOKUP($H$7,Constants!B52:B54,Constants!D52:D54)))*$E$11)","v":0.89999999999999991},"[cm3/100km]"]
[]
[null,"Results:"]
[null,"daily travel V",{"$f":"IF(K3=1,(C8/100*E7*C6*3.6),(C10))","v":129.6},"[km/day]",{"$f":"IF(K3<>2,(Constants!C66),(Constants!C67))","v":"calculated"}]
[null,"lubrication quantity per day P",{"$f":"C17*C20/100","v":1.1663999999999999},"[cm3/day]"]
[null,"lubrication quantity per cycle at each rack",{"$f":"C17*E22","v":0.44999999999999996},"[cm3/cycle]",{"$f":"INDEX(Constants!$F$40:$G$42,LubriCalc!$H$7,LubriCalc!$H$6)","v":0.5}]
[null,"lubrication quantity per cycle at each guide",{"$f":"C17*E23","v":0.22499999999999998},"[cm3/cycle]",{"$f":"INDEX(Constants!$F$43:$G$45,LubriCalc!$H$7,LubriCalc!$H$6)","v":0.25}]
[null,"emptying time of cartridge P1 ",{"$f":"IF(E24>ConstMaxReplTime,(ConstMaxReplTime),ROUNDDOWN(LubriCalc!E24,0))","v":11},"[month]",{"$f":"ConstCartVol/(LubriCalc!C21*ConstMonthDay)","v":11.431184270690444},"(effective)"]
[null,{"$f":"LOOKUP(LubriCalc!H6,Constants!B47:B48,Constants!C47:C48)","v":"P2"},{"$f":"IF(H6=1,LOOKUP(H7,Constants!B40:B42,Constants!D40:D42),LOOKUP(H7,Constants!B40:B42,Constants!E40:E42))","v":3}]
[null,"every",{"$f":"1/((C17/(C25*K6)))*100","v":106.66666666666669},"[km]"]
[]
[null,"Nice to know:"]
[null,"lubrication quantity per day at each rack",{"$f":"$C$21*$E$29","v":0.58319999999999994},"[cm3/day]",{"$f":"INDEX(Constants!$F$40:$G$42,LubriCalc!$H$7,LubriCalc!$H$6)","v":0.5}]
[null,"lubrication quantity per day at each guide",{"$f":"$C$21*$E$30","v":0.29159999999999997},"[cm3/day]",{"$f":"INDEX(Constants!$F$43:$G$45,LubriCalc!$H$7,LubriCalc!$H$6)","v":0.25}]
[null,"total km per cartridge life time",{"$f":"C20*ConstMonthDay*E24","v":44444.444444444445},"[km]"]
[null,"strokes per cartridge life time",{"$f":"ROUNDDOWN(C31/C26,0)","v":416},"[stroke]"]

{"sheet":"Constants","index":1,"n_rows":67,"n_cols":8,"rows_kept":67,"cut":false,"hidden":true,"merged":[[39,7,41,7],[42,7,44,7],[37,5,37,6]]}
[]
[]
["Lubrication"]
[null,null,null,null,"Name"]
["Max interval",null,100,"[km]","ConstMaxIntDist"]
["Max interval",null,3,"[day]","ConstMaxIntTime"]
["Max replacementime",null,36,"[month]","ConstMaxReplTime"]
["Cardridge volume",null,400,"[cm^3]","ConstCartVol"]
["Volume per exit/stroke",null,0.16,"[cm^3]","ConstVolPerExitStroke"]
["Average day/month",null,30,"[day/month]","ConstMonthDay"]
[]
["Req. Quant. 100km"]
["Size 2 ¦ 3 ¦ 4",1,0.3,"[cm^3/100km]"]
["Size 5 ¦ 6 ¦ 7",2,0.4,"[cm^3/100km]"]
[]
["Quant. Lubpart"]
["EP, TMF, TMO",1,3]
["ZP, FP Y-Axis",2,6]
["FP X-Axis",3,4]
[]
[null,"idx","hours/day"]
["ShiftWork 1",1,8,"[h]"]
["ShiftWork 2",2,16,"[h]"]
["ShiftWork 3",3,24,"[h]"]
[]
[null,"idx","Name","Percentage"]
["Degree of poll. 1",1,"-50%",0.5]
["Degree of poll. 3",2,"-25%",0.75]
["Degree of poll. 5",3,"0",1]
["Degree of poll. 6",4,"+25%",1.25]
["Degree of poll. 7",5,"+50%",1.5]
["Degree of poll. 8",6,"+75%",1.75]
["Degree of poll. 9",7,"+100%",2]
[]
[null,"idx","Name","exits []","strokeportion [cm^3 ]"]
["Pump type",1,"FlexxPump4 N412A + B412A",2,{"$f":"D36*C9","v":0.32}]
[null,2,"FlexxPump4 D424A",4,{"$f":"D37*C9","v":0.64}]
[null,null,null,"min. Strokes (Splitter)"]
[null,"idx","Name","N412A + B412A","D424A","N412A + B412A","D424A"]
["Systems",1,"1-Axis Module ¦ 3 lubrication points",3,1,{"$f":"1/2","v":0.5},{"$f":"2/4","v":0.5},"% rack"]
[null,2,"2-Axis Module ¦ 6 lubrication points",4,3,{"$f":"1/6","v":0.16666666666666666},{"$f":"1/4","v":0.25}]
[null,3,"X-Axis FP ¦ 4 lubrication points",3,1,{"$f":"1/4","v":0.25},{"$f":"1/4","v":0.25}]
[null,1,"1-Axis Module ¦ 3 lubrication points",3,1,{"$f":"1/4","v":0.25},{"$f":"1/4","v":0.25},"% guide"]
[null,2,"2-Axis Module ¦ 6 lubrication points",4,3,{"$f":"1/6","v":0.16666666666666666},{"$f":"1/8","v":0.125}]
[null,3,"X-Axis FP ¦ 4 lubrication points",3,1,{"$f":"1/4","v":0.25},{"$f":"1/4","v":0.25}]
[]
["name P2",1,"P2"]
[null,2,"strokes per cycle"]
[]
[]
["Req. Quant. Per Lub","idx","Sice 1-4","Sice 5-7"]
["3- lube points",1,{"$f":"$C$13*C17","v":0.89999999999999991},{"$f":"$C$14*C17","v":1.2000000000000002}]
["6- lube points",2,{"$f":"$C$13*C18","v":1.7999999999999998},{"$f":"$C$14*C18","v":2.4000000000000004}]
["4- lube points",3,{"$f":"$C$13*C19","v":1.2},{"$f":"$C$14*C19","v":1.6}]
[]
["Units",1,"[cm3]"]
[null,2,"[cm3/100km]"]
[null,3,"[cm3/day]"]
[null,4,"[cm3/cycle]"]
[null,5,"[km/day]"]
[null,6,"[month]"]
[null,7,"[km]"]
[null,8,"[stroke]"]
[]
["direct Input",null,"-"]
[null,null,"calculated"]
[null,null,"direct input"]

{"sheet":"Pictures","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Spalte1","Spalte2"]
[]
[1]
[2]
[3]
[4]
[5]
[6]

{"sheet":"release note","index":3,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["version","change","date","responsible"]
["V1.00","release for DesignRules / Gudel Downlads on Website / Picture Park","2016-08-29","michsc"]
["V2.00","new added butom for direct Input daily travel / lubrication values (Req. Quant. 100km) for size 1-4 and size 5-7 doubled / corecture values adjustetd (+/-25% and +/-50%)","2018-02-02","michsc"]
["V2.01"," corecture values adjustetd: -50% up to +100%","2018-05-28","michsc"]
["V2.10","Pump types/designations updated (new Flexxpump 4) / accordingly lubricant quantity per output adjusted (new 0.16 cm^3, old: 0.15 cm^3)\nProgramming adapted for Windows 10, various small design adjustments made.","2013-12-15","michsc"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"INDEX($B$2:$B$28,MATCH(\"\",$B$2:$B$28,-1))","v":"Pump types/designations updated (new Flexxpump 4) / accordingly lubricant quantity per output adjusted (new 0.16 cm^3, old: 0.15 cm^3)\nProgramming adapted for Windows 10, various small design adjustments made."},"latest release"]