{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Berekening","Settings"],"read":"whole","date_system":"1900"}

{"sheet":"Berekening","index":0,"n_rows":31,"n_cols":4,"rows_kept":31,"merged":[[0,0,0,3],[2,1,2,3],[4,1,4,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[19,1,19,3],[20,1,20,3],[22,0,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[27,1,27,3],[29,1,29,3],[30,1,30,3]]}
["Stap 1: vul de benodigde waarden in:"]
[]
["Servo systeem:","B3"]
[]
["Aantal decimalen invoer positie (x.XXXX):",4]
["Reductie 1:",1,":",10]
["Reductie 2:",1,":",1]
["Reductie 3:",1,":",1]
["Totale reductie [i=X]:",{"$f":"(D6/B6)*(D7/B7)*(D8/B8)","v":10}]
["Afstand per omwenteling / spoed [mm]:",{"v":241,"d":"241.000"}]
["Deviation Error [mm]:",10]
[]
["Berekende Numerator (P1-44):",{"$f":"SUM((_xlfn.XLOOKUP($B$3,Settings!A:A,Settings!B:B))*B9)","v":{"v":167772160,"d":"167772160.00"}}]
["Berekende Denumerator (P1-45):",{"$f":"SUM(B10*(10^B5))","v":{"v":2410000,"d":"2410000.00"}}]
["Berekende Condition of excessive position control deviation warning (P2-35):",{"$f":"SUM((B11*10^B5)*(B13/B14))","v":{"v":6961500.41493776,"d":"6961500.41"}}]
["Factor Nmax:",{"$f":"SUM(536870911/B13)","v":{"v":3.1999999940395356,"d":"3.20"}}]
["Factor Mmax:",{"$f":"SUM(4294967295/B14)","v":{"v":1782.1441058091286,"d":"1782.14"}}]
["Maximale factor t.b.v. verbeteren nauwkeurigheid:",{"$f":"IF(AND(B16<B17),IF(AND(ROUNDDOWN(B16,0)<=0),1,ROUNDDOWN(B16,0)),IF(AND(ROUNDDOWN(B17,0)<=0),1,ROUNDDOWN(B17,0)))","v":3}]
[]
["Stap 2: Indien bovenstaande Numerator en Denumerator een kommagetal bevatten, kun je de waarde verbeteren met een gewenste factor lager dan:",{"$f":"SUM(B18)","v":3}]
["Gewenste factor voor het verbeteren van de nauwkeurigheid (door bijvoorbeeld factoor met 10 of met 0,1 te vermenigvuldigen):",1]
[]
["In te stellen servo parameter:"]
["P1-44 (Numerator)",{"$f":"SUM(B13*B21)","v":167772160}]
["P1-45 (Denominator)",{"$f":"SUM(B14*B21)","v":2410000}]
["P2-35 (Condition of excessive position control deviation warning)",{"$f":"ROUNDDOWN(B15,0)","v":6961500}]
[]
["Verhouding Numerator/Denumerator:",{"$f":"SUM(B24/B25)","v":{"v":69.6150041493776,"d":"69.6150041"}}]
[]
[{"$f":"_xlfn.CONCAT(\"De verhouding van Numerator/Denumerator moet tussen \",_xlfn.XLOOKUP($B$3,Settings!A:A,Settings!C:C),\" < Numerator/Denumerator < \",_xlfn.XLOOKUP($B$3,Settings!A:A,Settings!D:D),\" vallen. De gekozen waarden zijn:\")","v":"De verhouding van Numerator/Denumerator moet tussen 1 < Numerator/Denumerator < 262144 vallen. De gekozen waarden zijn:"},{"$f":"IF(AND(AND((B24/B25)<25600),(B24/B25)>(1/50)),\"Goed\",\"Waarde valt buiten de range!\")","v":"Goed"}]
[{"$f":"_xlfn.CONCAT(\"De waarde van de condigtion of excessive position control deviation warning moet tussen 1 <= P2-35 <  \",_xlfn.XLOOKUP($B$3,Settings!A:A,Settings!E:E),\" liggen. De waarde is:\")","v":"De waarde van de condigtion of excessive position control deviation warning moet tussen 1 <= P2-35 <  1677721600 liggen. De waarde is:"},{"$f":"IF(AND(AND(B26<_xlfn.XLOOKUP($B$3,Settings!A:A,Settings!E:E)),B26>1),\"Goed\",\"Waarde valt buiten de range!\")","v":"Goed"}]

{"sheet":"Settings","index":1,"n_rows":3,"n_cols":5,"rows_kept":3}
["Servo systeem","Pulstal encoder","Min Gear","Max Gear","Max P2-35"]
["A2",1280000,0.02,25600,128000000]
["B3",16777216,1,262144,1677721600]