{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Introduction","Instructions","Step 1 - Tasks 1 to 3","Step 1 - Tasks 4 to 5","Step 2 - Tasks 1 to 4","Step 2 - Tasks 5 to 8","Overview","Add Actuator","Database Cylinder","Add Valve","Database Valve","Planilha3"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Introduction","index":0,"n_rows":28,"n_cols":22,"rows_kept":28,"cut":false,"hidden":false,"merged":[[23,1,24,19],[1,12,2,19],[3,12,10,19],[11,12,11,19],[12,12,13,19],[1,1,2,10],[3,1,8,10],[10,1,11,10],[12,1,14,10],[15,1,19,10],[14,12,19,19],[27,21,52,30],[3,21,23,30],[21,1,22,19],[25,21,26,30],[1,21,2,30]]}
[]
[null,"About the HyPS Tool",null,null,null,null,null,null,null,null,null,null,"Disclaimer",null,null,null,null,null,null,null,null,"References (Theses)"]
[]
[null,"HyPS Tool - Design Method for Valve-Controlled Hydraulic Positioning Systems",null,null,null,null,null,null,null,null,null,null,"Users of this software acknowledge and agree that:\nThe software is not a substitute for professional judgment or advice. It is the responsibility of the user to verify the accuracy and suitability of all results and recommendations obtained from the software.\nThe developers of this software shall not be liable for any direct, indirect, incidental, special, consequential, or punitive damages arising out of the use of, or inability to use, the software, even if advised of the possibility of such damages.\nThe user assumes all risks associated with the use of the software, including but not limited to, errors, omissions, inaccuracies, or misuse thereof.",null,null,null,null,null,null,null,null,"This method originated from the thesis by Fernando L. Furst (2001) and was updated based on the later contributions of other graduate students: Alisson D. C. de Souza (2005), José R. B. Ramos Filho (2007), Rodrigo Szpak (2008), Irving Muraro (2009) and Mario Destro (2015).\n\nDESTRO, Mário Cesar. Análise de condições operacionais críticas em posicionadores eletro-hidráulicos. 2014. Master’s Thesis. Universidade Federal de Santa Catarina.\n\nFUST, Fernando Luiz Sistematização do projeto preliminar de circuitos hidráulicos de controle de posição. Florianópolis,. 2001. Master’s Thesis. Universidade Federal de Santa Catarina.\n\nMURARO, Irving. Estudo das Características Comportamentais de Válvulas Proporcionais e seus Efeitos nos Posicionadores Eletro-Hidráulicos. 2009. . Master’s Thesis. Universidade Federal de Santa Catarina.\n\nRAMOS FILHO, José Roberto Branco. Análise Teórico-Experimental de Falhas em Válvulas Direcionais Servoproporcionais. 2009 Master’s Thesis Universidade Federal de Santa Catarina.\n\nSOUZA, Alisson D Correa de. Desenvolvimento de Sistema de Projeto e Controle de Posicionadores Hidráulicos . 2005. Master’s Thesis Universidade Federal de Santa Catarina.\n\nSZPAK,  Rodrigo. Análise teorico-experimental do comportamento das pressões em posicionadores hidráulicos. 2008. Master’s Thesis Universidade Federal de Santa Catarina."]
[]
[]
[]
[]
[]
[]
[null,"Authorship"]
[]
[null,"The development of this tool was made possible through the collaborative efforts and support of several individuals at Laboratory of Hydraulic and Pneumatic Systems (LASHIP), in Florianopolis, Brazil.",null,null,null,null,null,null,null,null,null,null,"Reference text"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"De Negri, V. J. Design Method for Valve-Controlled Hydraulic Positioning Systems. UFSC, 2023 (PowerPoint presentation).\nMURARO, I., TEIXEIRA, P. L., DE NEGRI, V. J. Effect of proportional valves and cylinders on the behavior of hydraulic positioning systems. In: FPMC 2013, 2013, Sarasota, FL.. p.1 – 9. DOI:10.1115/FPMC2013-4496.\nAvailable at laship.ufsc.br"]
[null,"Pedro Alonso Condessa: Developer of the HyPS Tool.\nMarcos Paulo Nostrani: Advisor.\nVictor Juliano De Negri: Advisor/Coordinator.\n\nRelease: 02/2024"]
[]
[]
[]
[]
[]
[null,"Instructions"]
[]
[null,"The Design Method for Valve-Controlled Hydraulic Positioning Systems is parte of the embodiment design phase. It comprises 3 steps as shown below. These Steps are detailed in next tab. "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"References (Publications)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DESTRO, MÁRIO C.; DE NEGRI, VICTOR J. Method for combining valves with symmetric and asymmetric cylinders for hydraulic systems. INTERNATIONAL JOURNAL OF FLUID POWER. v.19, p.1 - 14, 2018. DOI: 10.1080/14399776.2018.1483164\n\nDESTRO, M. C., BRAVO, Rafael Rivelino da Silva, DE NEGRI, V. J. Comparative analysis of electro-hydraulic positioning systems under variable load conditions. In: 22nd International Congress of Mechanical Engineering (COBEM 2013), 2013, Ribeirão Preto. p.1663 – 1673.\n\nMURARO, I., TEIXEIRA, P. L., DE NEGRI, V. J. Effect of proportional valves and cylinders on the behavior of hydraulic positioning systems. In: ASME/BATH 2013 Symposium on Fluid Power & Motion Control, 2013, Sarasota, FL.. p.1 – 9. DOI:10.1115/FPMC2013-4496.\n\nMURARO, I., DE NEGRI, V. J., BELAN, H. C., RAMOS FILHO, J. R. B. Parameter influence on the design of hydraulic positioning systems In: 21st International Congress of Mechanical Engineering, 2011, Natal. RN.  ABCM, 2011.\n\nSZPAK, R., RAMOS FILHO, J. R. B., DE NEGRI, V. J. Theoretical and experimental study of the matching between proportional valves and symmetric and asymmetric cylinders In: 7th International Fluid Power Conference - 7 IFK, 2010, Aachen-Germany. v.2. p.155 – 166.\n\nSZPAK, R., RAMOS FILHO, J. R.B., BELAN, H. C., DE NEGRI, V. J. Theoretical and Experimental al Study of the Pressure Behavior on Hydraulic Positioning Systems In: Cobem 2009, 2009, Gramado.  ABCM, 2009.\n\nDE NEGRI. V., J., R. FILHO. J., R. B., SOUZA. A., D., C. A Design Method for Hydraulic Positioning  Systems.  51th National Conference on Fluid Power (NCFP), in conjunction with IFPE 2008, p. 669-679, 2008, Las Vegas, USA."]

{"sheet":"Instructions","index":1,"n_rows":3,"n_cols":39,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,35,35,38],[1,1,2,5],[1,7,2,16],[2,18,55,21],[1,23,2,25],[1,27,2,33]]}
[]
[null,"Tasks of Step 1",null,null,null,null,null,"Activities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasks of Step 2",null,null,null,"Activities",null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\nFor Step 1, we have two spreasheets tabs. In the first one, which is \"Step 1- Tasks 1 to 3\", you have two paths to follow.\n\nThe first one is if you don't know the actuator area. In this path, you'll fill all the orange tabs and get an actuator area as a result. Then, you'll have to search in catalogs to get an actuator with area greater than 90% of the result you got. For that, you can click in the Actuator Add Page and insert the informations needed. In the end of this tab, you can verify if your supply pressure is enough for the system you provided.\n\nThe second path is if you already know the area. For this case, you can go ahead and input your actuator by clicking the Actuator Add Page and inserting the needed information. Then, you can return to the Step 1 - Tasks 1 to 3 and Choose the actuator you added. In the end of this tab, you can verify if your supply pressure is enough for the system you provided.\n\nAfter completing Tasks 1 to 3, you can proceed to Step 1 - Tasks 4 to 5, which automatically calculates flow rate and natural frequency for your actuator.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\nFor Step 2, we have two spreadsheets as well. The first one, which is \"Step 2 - Tasks 1 to 4\", calculates automatically the Flow Coefficient of the valve with the results from the previous Tasks.\n\nThen, you can proceed to \"Step 2 - Tasks 5 to 8\", where you are asked to add a valve. For this Task, you can click the Valve Add Page, where you can insert informations of the valve. After adding, you can return to the \"Step 2 - Tasks 5 to 6\" and Choose the valve you added. We have two verifications here.\n\nOne is a Dynamic Response, which ensures that the natural frequency of your valve is greater than the one calculated. The second one is to verify if qv_max x D_P@ Vmax is within the valve operating limits.\n\nAfter completing Tasks 5 to 8, you can proceed to Overview to see the combination of your Actuator and Valve and see if the verifications are sucessfully met."]

{"sheet":"Step 1 - Tasks 1 to 3","index":2,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,11,1,12],[5,6,5,9],[2,1,2,4],[17,6,18,8],[7,1,7,4],[13,1,13,4],[1,1,1,4],[1,6,1,9]]}
[]
[null,"System Dynamic Requirements",null,null,null,null,"Task 1 (System)",null,null,null,null,"Verification"]
[null,"Required Response",null,null,null,null,"Calculated Data","Value","Unity","Description",null,"Verification Status","Comment"]
[null,"Requirements","Value","Unity","Description",null,"ωn_S",{"$f":"IF(C6=1,6/(C5*C6),4/(C5*C6))","v":46.153846153846153},"rad/s","System Natural Frequency",null,{"$f":"IF(C12=\"No\",IF(AND(H10>0.9*H24,H24>H10),\"WARNING\",IF(H24>H10,\"FAILED\",\"PASS\")),IF(H16>H10,\"FAILED\",\"PASS\"))","v":"WARNING"},{"$f":"IF(L4=\"PASS\",\"Adequate Supply Pressure\",IF(L4=\"WARNING\",\"Slightly Lower Supply Pressure\",\"Insufficient Supply Pressure\"))","v":"Slightly Lower Supply Pressure"}]
[null,"ts_S",0.13,"s","System Settling Time",null,null,null,null,null,null,{"$f":"IF(C31>0.9*H30,\"PASS\",\"FAILED\")","v":"PASS"},"Actuator Area"]
[null,"ζ",1,1,"System Damping Ratio",null,"Tasks 2 to 3 (Actuator)"]
[null,"xd_A",0.05,"m","Desired Step Output",null,"Calculated Data","Value","Unity","Description"]
[null,"Hydraulic Requirements",null,null,null,null,"vmax_A",{"$f":"IF(C6=1,0.37*C7*H4,0.46*C7*H4)","v":0.85384615384615381},"m/s","Maximum Cylinder Velocity"]
[null,"βe",1000000000,"Pa","Bulk Modulus",null,"amax_A",{"$f":"IF(C6=1,-0.13*C7*H4^2,-0.21*C7*H4^2)","v":-13.846153846153847},"m/s²","Maximum Cylinder Acceleration"]
[null,"ps",7000000,"Pa","Supply Pressure",null,"pL_max (expand)",{"$f":"IF(OR(C11=\"SymCylinder + SymValve\",C11=\"AsymCylinder + AsymValve\"),2/3*C10,IF(C11=\"SingleEffectAsymCylinder + 3PortsAsym\",1/3*C10,0))","v":4666666.666666666},"Pa","Load Pressure @ Max. Power"]
[null,"configuration","SymCylinder + SymValve",1,"System Configuration",null,"pL_max (retract)",{"$f":"IF(C11=\"AsymCylinder + AsymValve\",1/3 * C10,H10)","v":4666666.666666666},"Pa","Load Pressure @ Max. Power"]
[null,"known area?","No",1,"Known Area",null,{"$f":"IF(C12=\"Yes\",\"pL @ xmax\",\"A_A @ xmax\")","v":"A_A @ xmax"},{"$f":"IF(C12=\"Yes\",(C19*(C7+C24)+C21)/C31,(C19*(C7+C24)+C21)/H10)","v":1.5472268571428574E-3},{"$f":"IF(C12=\"Yes\",\"Pa\",\"m²\")","v":"m²"},{"$f":"IF(C12=\"Yes\",\"Load Pressure @ Displacement\",\"Cylinder Area @ Max. Displacement\")","v":"Cylinder Area @ Max. Displacement"}]
[null,null,null,null,null,null,{"$f":"IF(C12=\"Yes\",\"pL @ v_max\",\"A_A @ v_max\")","v":"A_A @ v_max"},{"$f":"IF(C12=\"Yes\",(H8*C20+C21)/C31,(H8*C20+C21)/H10)","v":1.6572527472527476E-3},{"$f":"IF(C12=\"Yes\",\"Pa\",\"m²\")","v":"m²"},{"$f":"IF(C12=\"Yes\",\"Load Pressure @ Max. Vel.\",\"Cylinder Area @ Max. Velocity\")","v":"Cylinder Area @ Max. Velocity"}]
[null,"Load Requirements",null,null,null,null,{"$f":"IF(C12=\"Yes\",\"pL @ a_max\",\"A_A @ a_max\")","v":"A_A @ a_max"},{"$f":"IF(C12=\"Yes\",(C35*ABS(H9)+C21)/C31,(C18*ABS(H9)+C21)/H10)","v":1.5336263736263739E-3},{"$f":"IF(C12=\"Yes\",\"Pa\",\"m²\")","v":"m²"},{"$f":"IF(C12=\"Yes\",\"Load Pressure @ Max. Accel.\",\"Cylinder Area @ Max. Acceleration\")","v":"Cylinder Area @ Max. Acceleration"}]
[null,"Requirements","Value","Unity","Description"]
[null,"ML",10,"kg","Load Mass",null,{"$f":"IF(C12=\"Yes\",\"Max(pL)\",\"A_A\")","v":"A_A"},{"$f":"MAX(H12:H14)","v":1.6572527472527476E-3},{"$f":"IF(C12=\"Yes\",\"Pa\",\"m²\")","v":"m²"},{"$f":"IF(C12=\"Yes\",\"Max Load Pressure\",\"Cylinder Area A\")","v":"Cylinder Area A"}]
[null,"MA",10,"kg","Cylinder Piston Mass",null,"A_B",{"$f":"C22 * H16","v":1.6572527472527476E-3},"m²","Cylinder Area B"]
[null,"Mt",{"$f":"C17+C16","v":20},"kg","Total Mass",null,"To continue with the Steps, insert a real actuator in the Choose Below Area."]
[null,"Kt",2618.4,"N/m","Stiffness of the Load"]
[null,"Bt",1000,"Ns/m","Viscous Friction Coefficient"]
[null,"FL",6880,"N","External Load",null,"pL @ xmax",{"$f":"(C19*(C7+C24)+C21)/C31","v":4560163.0073856199}]
[null,"rA",{"$f":"IF(C11=\"SymCylinder + SymValve\",1,0.5)","v":1},1,"Area ratio (AB/AA)",null,"pL @ v_max",{"$f":"(H8*C20+C21)/C31","v":4884443.8273684848}]
[null,"lt_A",0.16,"m","Cylinder Stroke",null,"pL @ a_max",{"$f":"(C35*ABS(H9)+C21)/C31","v":4482405.615445287}]
[null,"xi_A",0.08,"m","Initial Cylinder Position",null,null,{"$f":"MAX(H21:H23)","v":4884443.8273684848}]
[]
[null,null,"Choose Below:"]
[null,"Actuator","REXROTH CGT3 MS2 50/22-500 SYM",1,null,null,{"$f":"IF(C27=\"Yes\",\"pL @ xmax\",\"Aa @ xmax\")","v":"Aa @ xmax"},{"$f":"(C19*(C7+C24)+C21)/H10","v":1.5472268571428574E-3}]
[null,null,null,null,null,null,{"$f":"IF(C27=\"Yes\",\"pL @ v_max\",\"Aa @ v_max\")","v":"Aa @ v_max"},{"$f":"(H8*C20+C21)/H10","v":1.6572527472527476E-3}]
[null,"de",{"$f":"IF(C27<>\"\", VLOOKUP(C27,'Database Cylinder'!$A:$G, 5, FALSE), \"\")","v":0.05},"m","Cylinder Ø",null,{"$f":"IF(C27=\"Yes\",\"pL @ a_max\",\"Aa @ a_max\")","v":"Aa @ a_max"},{"$f":"(C18*ABS(H9)+C21)/H10","v":1.5336263736263739E-3}]
[null,"dh",{"$f":"IF(C27<>\"\", VLOOKUP(C27,'Database Cylinder'!$A:$G, 6, FALSE), \"\")","v":2.1999999999999999E-2},"m","Cylinder Rod Ø",null,null,{"$f":"MAX(H27:H29)","v":1.6572527472527476E-3}]
[null,"AA",{"$f":"((C29^2-C30^2)*PI())/4","v":1.583362697409256E-3},"m²","Cylinder Area A"]
[null,"AB",{"$f":"C31*C39","v":1.583362697409256E-3},"m²","Cylinder Area B"]
[null,"MA",{"$f":"IF(C27<>\"\", VLOOKUP(C27,'Database Cylinder'!$A:$G, 2, FALSE), \"\")","v":5.5},"kg","Cylinder Mass at 0mm Stroke"]
[null,"Ms_A",{"$f":"IF(C27<>\"\", VLOOKUP(C27,'Database Cylinder'!$A:$G, 3, FALSE), \"\")","v":1.2},"kg/m","Cylinder mass per (0.1m) 100mm Stroke"]
[null,"Mt",{"$f":"C16+(C33+C34*C37)","v":15.692},"kg","Total Mass"]
[null,"Vt_A",{"$f":"C31*C37","v":2.5333803158548095E-4},"m³","Cylinder Volume"]
[null,"lt_A",{"$f":"IF(C27<>\"\", VLOOKUP(C27,'Database Cylinder'!$A:$G, 4, FALSE), \"\")","v":0.16},"m","Cylinder Stroke"]
[null,"xA",{"$f":"IF(C39=1,C37,((C31*C37)/(C31-C32)) * (1-(C32/C31)^(1/2)))","v":0.16},"m","Cylinder Stroke"]
[null,"rA",{"$f":"IF(C27<>\"\", VLOOKUP(C27,'Database Cylinder'!$A:$G, 7, FALSE), \"\")","v":1},1,"Area ratio (AB/AA)"]

{"sheet":"Step 1 - Tasks 4 to 5","index":3,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[6,2,6,4],[5,1,5,4],[1,1,1,4],[1,11,1,12],[1,6,1,9]]}
[]
[null,"System",null,null,null,null,"Tasks 4 to 5 (Actuator)",null,null,null,null,"Verification"]
[null,"Calculated Data","Value","Unity","Description",null,"Calculated Data","Value","Unity","Description",null,"Verification Status","Comment"]
[null,"ωn_S",{"$f":"'Step 1 - Tasks 1 to 3'!H4","v":46.153846153846153},"rad/s","System Natural Frequency",null,"qV_max",{"$f":"C11*'Step 1 - Tasks 1 to 3'!H8","v":1.3519481493263648E-3},"m³/s","Maximum Flow Rate",null,{"$f":"IF(H6>(5*C4),\"PASS\",\"WARNING\")","v":"PASS"},"Actuator Frequency"]
[null,null,null,null,null,null,"qV_max",{"$f":"H4*60000","v":81.116888959581885},"L/min","Maximum Flow Rate"]
[null,"Actuator",null,null,null,null,"ωn_min_A",{"$f":"IF('Step 1 - Tasks 1 to 3'!C11=\"SymCylinder + SymValve\",((4*'Step 1 - Tasks 1 to 3'!C9*C11^2)/(C16*C17))^(1/2),IF('Step 1 - Tasks 1 to 3'!C11=\"AsymCylinder + AsymValve\",(('Step 1 - Tasks 1 to 3'!C9/C16)*((C11/C19)+(C12/(C18-C19))))^(1/2),IF('Step 1 - Tasks 1 to 3'!C11=\"SingleEffectAsymCylinder + 3PortsAsym\",(('Step 1 - Tasks 1 to 3'!C9*C11^2)/(C16*C17))^(1/2),0)))","v":1588.2580279335593},"rad/s","Cylinder Natural Frequency"]
[null,"Actuator",{"$f":"'Step 1 - Tasks 1 to 3'!C27","v":"REXROTH CGT3 MS2 50/22-500 SYM"},null,null,null,"ωn_min_A",{"$f":"H6/(2*PI())","v":252.77911605101156},"Hz","Cylinder Natural Frequency"]
[null,"Catalog Data","Value","Unity","Description"]
[null,"de",{"$f":"IF(C7<>\"\", VLOOKUP(C7,'Database Cylinder'!$A:$G, 5, FALSE), \"\")","v":0.05},"m","Cylinder Ø"]
[null,"dh",{"$f":"IF(C7<>\"\", VLOOKUP(C7,'Database Cylinder'!$A:$G, 6, FALSE), \"\")","v":2.1999999999999999E-2},"m","Cylinder Rod Ø"]
[null,"AA",{"$f":"((C9^2-C10^2)*PI())/4","v":1.583362697409256E-3},"m²","Cylinder Area A"]
[null,"AB",{"$f":"C11*C20","v":1.583362697409256E-3},"m²","Cylinder Area B"]
[null,"MA",{"$f":"IF(C7<>\"\", VLOOKUP(C7,'Database Cylinder'!$A:$G, 2, FALSE), \"\")","v":5.5},"kg","Cylinder Mass at 0mm Stroke"]
[null,"Ms_A",{"$f":"IF(C7<>\"\", VLOOKUP(C7,'Database Cylinder'!$A:$G, 3, FALSE), \"\")","v":1.2},"kg/m","Cylinder mass per (0.1m) 100mm Stroke"]
[null,"Ml",{"$f":"'Step 1 - Tasks 1 to 3'!C16","v":10},"kg","Load Mass"]
[null,"Mt",{"$f":"C15+(C13+C14*C18)","v":15.692},"kg","Total Mass"]
[null,"Vt_A",{"$f":"C11*C18","v":2.5333803158548095E-4},"m³","Cylinder Volume"]
[null,"lt_A",{"$f":"IF(C7<>\"\", VLOOKUP(C7,'Database Cylinder'!$A:$G, 4, FALSE), \"\")","v":0.16},"m","Cylinder Stroke"]
[null,"xA",{"$f":"IF(C20=1,C18,((C11*C18)/(C11-C12)) * (1-(C12/C11)^(1/2)))","v":0.16},"m","Cylinder Stroke"]
[null,"ra",{"$f":"IF(C7<>\"\", VLOOKUP(C7,'Database Cylinder'!$A:$G, 7, FALSE), \"\")","v":1},1,"Area ratio"]

{"sheet":"Step 2 - Tasks 1 to 4","index":4,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,12],[5,1,5,4],[1,6,1,9]]}
[]
[null,"System",null,null,null,null,"Tasks 1 to 4 (Valve)",null,null,null,null,"Verification"]
[null,"Calculated Data","Value","Unity","Description",null,"Calculated Data","Value","Unity","Description",null,"Verification Status","Comment"]
[null,"ωn_S",{"$f":"'Step 1 - Tasks 1 to 3'!H4","v":46.153846153846153},"rad/s","System Natural Frequency",null,"wn_V",{"$f":"IF('Step 1 - Tasks 4 to 5'!L4=\"PASS\",5*C4,5*C7)","v":230.76923076923077},"rad/s","Valve Natural Frequency",null,"PASS","No verification"]
[null,null,null,null,null,null,"ts_V",{"$f":"4/(H4*0.7)","v":2.4761904761904766E-2},"s","Valve Settling Time (Considering 0.7 Damping Ratio)"]
[null,"Actuator",null,null,null,null,"ts_V",{"$f":"H5*1000","v":24.761904761904766},"ms","Valve Settling Time (Considering 0.7 Damping Ratio)"]
[null,"ωn_min_A",{"$f":"'Step 1 - Tasks 4 to 5'!H6","v":1588.2580279335593},{"$f":"'Step 1 - Tasks 4 to 5'!I6","v":"rad/s"},{"$f":"'Step 1 - Tasks 4 to 5'!J6","v":"Cylinder Natural Frequency"},null,"Δpt (extend)",{"$f":"IF('Step 1 - Tasks 1 to 3'!C11=\"SymCylinder + SymValve\",'Step 1 - Tasks 1 to 3'!C10-C8,IF('Step 1 - Tasks 1 to 3'!C11=\"SingleEffectAsymCylinder + 3PortsAsym\",2 * (('Step 1 - Tasks 1 to 3'!C10/2)-ABS(C8)),IF('Step 1 - Tasks 1 to 3'!C11=\"AsymCylinder + AsymValve\",(4*'Step 1 - Tasks 1 to 3'!C10 - 4*C8)/3,0)))","v":2115556.1726315152},"Pa","Valve Total Pressure Drop @ Max. Velocity"]
[null,"pL_vmax",{"$f":"('Step 1 - Tasks 1 to 3'!C20*'Step 1 - Tasks 1 to 3'!H8+'Step 1 - Tasks 1 to 3'!C21)/'Step 1 - Tasks 4 to 5'!C11","v":4884443.8273684848},"Pa","Load Pressure @ Max. Velocity",null,"Δpt (retract)",{"$f":"IF('Step 1 - Tasks 1 to 3'!C11=\"AsymCylinder + AsymValve\",(2*'Step 1 - Tasks 1 to 3'!C10-4*ABS('Step 1 - Tasks 1 to 3'!H11))/3,H7)","v":2115556.1726315152},"Pa","Valve Total Pressure Drop @ Max. Velocity"]
[null,null,null,null,null,null,"KV",{"$f":"'Step 1 - Tasks 4 to 5'!H4/(H7)^(1/2)","v":9.2949649185055039E-7},"m³/(s Pa^1/2)","Flow Coefficient"]
[null,null,null,null,null,null,"KV",{"$f":"H9*60000/SQRT(0.00001)","v":17.635955948303252},"L/(min bar^1/2)","Flow Coefficient"]
[]
[]
[]
[null,null,null,null,null,null,"pl @ v_max",null,"Pa","Cylinder Area with Max. Velocity"]

{"sheet":"Step 2 - Tasks 5 to 8","index":5,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,6,16,8],[1,1,1,4],[1,6,1,9],[1,11,1,12],[11,6,15,9]]}
[]
[null,"Valve",null,null,null,null,"Tasks 5 to 8 (Valve)",null,null,null,null,"Verification"]
[null,"Calculated Data","Value","Unity","Description",null,"Calculated Data","Value","Unity","Description",null,"Verification Status","Comment"]
[null,"ωn_S",{"$f":"'Step 2 - Tasks 1 to 4'!C4","v":46.153846153846153},"rad/s","System Natural Frequency",null,"ts_V",{"$f":"4/(C15*C16)","v":4.0440804772014964E-3},"s","Valve Settling Time",null,{"$f":"IF(AND(H6>=(C6/2),H6<=2*C6),\"PASS\",\"FAILED\")","v":"FAILED"},"Kv Comparison"]
[null,"wn_V",{"$f":"'Step 2 - Tasks 1 to 4'!H4","v":230.76923076923077},"rad/s","Valve Natural Frequency",null,"ts_V",{"$f":"H4*1000","v":4.0440804772014962},"ms","Valve Settling Time",null,{"$f":"IF(C15>C5,\"PASS\",\"FAILED\")","v":"PASS"},"Dynamic Respose"]
[null,"KV",{"$f":"'Step 2 - Tasks 1 to 4'!H9","v":9.2949649185055039E-7},"m³/(sPa^1/2)","Flow Coefficient",null,"KVcat",{"$f":"IF(C20=\"Yes\",C18/(C17)^(1/2),SQRT(2)*C18/(C17)^(1/2))","v":2.4026734210308922E-7},"m³/(sPa^1/2)","Catalog Flow Coefficient",null,{"$f":"IF(J17=\"Checked\",\"PASS\",\"FAILED\")","v":"FAILED"},"Operating Limits"]
[null,"KV",{"$f":"C6*60000/SQRT(0.00001)","v":17.635955948303252},"L/(min bar^1/2)","Flow Coefficient",null,"KVcat",{"$f":"H6*60000/SQRT(0.00001)","v":4.5587522904037954},"L/(min bar^1/2)","Catalog Flow Coefficient"]
[null,"KpU in catalog?","No",1,"Is Pressure Gain (KpU) in catalog?",null,"KqU0",{"$f":"(H6*ABS('Step 2 - Tasks 1 to 4'!H7)^(1/2))/C19","v":3.4946768637408029E-5},"m³/(sV)","Flow Gain"]
[null,"KpU",null,"Pa/V","Pressure Gain",null,"KC0 (extend)",{"$f":"IF(C8=\"No\",IF('Step 1 - Tasks 1 to 3'!C11=\"SymCylinder + SymValve\",(H6)/(2*('Step 1 - Tasks 1 to 3'!C10-ABS('Step 2 - Tasks 1 to 4'!C8))^(1/2)),IF('Step 1 - Tasks 1 to 3'!C11=\"SingleEffectAsymCylinder + 3PortsAsym\",(H6)/('Step 1 - Tasks 1 to 3'!C10-2*'Step 2 - Tasks 1 to 4'!C8)^(1/2),IF('Step 1 - Tasks 1 to 3'!C11=\"AsymCylinder + AsymValve\",(1/3)^(1/2) * (H6)/('Step 1 - Tasks 1 to 3'!C10-'Step 2 - Tasks 1 to 4'!C8)^(1/2),0))),H8/C9)","v":8.2594754725747047E-11},"m³/(sPa)","Flow-Pressure Coefficient"]
[null,null,null,null,null,null,"KC0 (retract)",{"$f":"IF('Step 1 - Tasks 1 to 3'!C11=\"AsymCylinder + AsymValve\",H6/(2*('Step 1 - Tasks 1 to 3'!C10-ABS('Step 2 - Tasks 1 to 4'!C8))^(1/2)),H9)","v":8.2594754725747047E-11},"m³/(sPa)","Flow-Pressure Coefficient"]
[]
[null,null,"Choose Below:",null,null,null,"Check that qV_max x ΔpP @ vmax is within the valve operating limits"]
[null,"Valve","MOOG 760 C263-A",1]
[]
[null,"wn_V_cat",{"$f":"IF(C13<>\"\", VLOOKUP(C13,'Database Valve'!$A:$G, 2, FALSE), \"\")","v":1099},"rad/s","Valve Natural Frequency"]
[null,"ζV",{"$f":"IF(C13<>\"\", VLOOKUP(C13,'Database Valve'!$A:$G, 3, FALSE), \"\")","v":0.9},1,"Valve Damping Ratio"]
[null,"Δpt_n",{"$f":"IF(C13<>\"\", VLOOKUP(C13,'Database Valve'!$A:$G, 4, FALSE), \"\")","v":6895000},"Pa","Catalog Valve Pressure Drop",null,"Please check the Operating Limits",null,null,"Not Checked"]
[null,"qVn",{"$f":"IF(C13<>\"\", VLOOKUP(C13,'Database Valve'!$A:$G, 5, FALSE), \"\")","v":6.3090196403438597E-4},"m³/s","Catalog Flow Rate at Pressure Drop"]
[null,"Un",{"$f":"IF(C13<>\"\", VLOOKUP(C13,'Database Valve'!$A:$G, 6, FALSE), \"\")","v":10},"V","Nominal control signal"]
[null,"total pressure drop?",{"$f":"IF(C13<>\"\", VLOOKUP(C13,'Database Valve'!$A:$G, 7, FALSE), \"\")","v":"Yes"},1,"Is the Pressure Drop in the Catalog the Total?"]

{"sheet":"Overview","index":6,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,11,1,12],[5,6,5,9],[7,2,7,4],[22,2,22,4],[12,6,12,9],[1,1,1,4],[1,6,1,9]]}
[]
[null,"Hydraulic Requirements",null,null,null,null,"System",null,null,null,null,"Verification"]
[null,"Requirements","Value","Unity","Description",null,"Calculated Data","Value","Unity","Description",null,"Verification Status","Comment"]
[null,"βe",{"$f":"'Step 1 - Tasks 1 to 3'!C9","v":1000000000},"Pa","Bulk Modulus",null,"ωn_S",{"$f":"'Step 1 - Tasks 1 to 3'!H4","v":46.153846153846153},"rad/s","System Natural Frequency",null,{"$f":"'Step 1 - Tasks 1 to 3'!L4","v":"WARNING"},{"$f":"'Step 1 - Tasks 1 to 3'!M4","v":"Slightly Lower Supply Pressure"}]
[null,"ps",{"$f":"'Step 1 - Tasks 1 to 3'!C10","v":7000000},"Pa","Supply Pressure",null,null,null,null,null,null,{"$f":"IF(C17>(0.9 *'Step 1 - Tasks 1 to 3'!H30),\"PASS\",\"FAILED\")","v":"PASS"},"Actuator Area"]
[null,"configuration","SymCylinder + SymValve",1,"System Configuration",null,"Actuator",null,null,null,null,{"$f":"IF(H8>(5*H4),\"PASS\",\"WARNING\")","v":"PASS"},"Actuator Frequency"]
[null,null,null,null,null,null,"Calculated Data","Value","Unity","Description",null,{"$f":"IF(AND(H19>=(H17/2),H19<=2*H17),\"PASS\",\"FAILED\")","v":"FAILED"},"Kv Comparison"]
[null,"Actuator",{"$f":"'Step 1 - Tasks 1 to 3'!C27","v":"REXROTH CGT3 MS2 50/22-500 SYM"},null,null,null,"ωn_min_A",{"$f":"IF(C6=\"SymCylinder + SymValve\",((4*C4*C17^2)/(C13*C20))^(1/2),IF(C6=\"AsymCylinder + AsymValve\",((C4/C13)*((C17/C21)+(C19/(C14-C21))))^(1/2),IF(C6=\"SingleEffectAsymCylinder + 3PortsAsym\",((C4*C17^2)/(C13*C20))^(1/2),0)))","v":1588.2580279335593},"rad/s","Cylinder Natural Frequency",null,{"$f":"IF('Step 2 - Tasks 5 to 8'!J17=\"Checked\",\"PASS\",\"FAILED\")","v":"FAILED"},"Operating Limits"]
[null,"Catalog Data","Value","Unity","Description",null,"ωn_min_A",{"$f":"H8/(2*PI())","v":252.77911605101156},"Hz","Cylinder Natural Frequency",null,{"$f":"'Step 2 - Tasks 5 to 8'!L5","v":"PASS"},{"$f":"'Step 2 - Tasks 5 to 8'!M5","v":"Dynamic Respose"}]
[null,"MA",{"$f":"IF(C8<>\"\", VLOOKUP(C8,'Database Cylinder'!$A:$G, 2, FALSE), \"\")","v":5.5},"kg","Cylinder Mass at 0mm Stroke",null,"qV_max",{"$f":"C17*'Step 1 - Tasks 1 to 3'!H8","v":1.3519481493263648E-3},"m³/s","Maximum Flow Rate"]
[null,"Ms_A",{"$f":"IF(C8<>\"\", VLOOKUP(C8,'Database Cylinder'!$A:$G, 3, FALSE), \"\")","v":1.2},"kg/m","Cylinder mass per (0.1m) 100mm Stroke",null,"qV_max",{"$f":"H10*60000","v":81.116888959581885},"L/min","Maximum Flow Rate"]
[null,"ML",{"$f":"'Step 1 - Tasks 1 to 3'!C16","v":10},"kg","Load Mass",null,"pl @ v_max",{"$f":"('Step 1 - Tasks 1 to 3'!C20*'Step 1 - Tasks 1 to 3'!H8+'Step 1 - Tasks 1 to 3'!C21)/C17","v":4884443.8273684848}]
[null,"Mt",{"$f":"C12+(C10+C11*C14)","v":15.692},"kg","Total Mass in Movement",null,"Valve"]
[null,"lt_A",{"$f":"IF(C8<>\"\", VLOOKUP(C8,'Database Cylinder'!$A:$G, 4, FALSE), \"\")","v":0.16},"m","Cylinder Stroke",null,"Calculated Data","Value","Unity","Description"]
[null,"de",{"$f":"IF(C8<>\"\", VLOOKUP(C8,'Database Cylinder'!$A:$G, 5, FALSE), \"\")","v":0.05},"m","Cylinder Ø",null,"Δpt (extend)",{"$f":"IF(C6=\"SymCylinder + SymValve\",C5-H12,IF(C6=\"SingleEffectAsymCylinder + 3PortsAsym\",2 * ((C5/2)-ABS(H12)),IF(C6=\"AsymCylinder + AsymValve\",(4*C5 - 4*H12)/3,0)))","v":2115556.1726315152},"Pa","Valve Total Pressure Drop"]
[null,"dh",{"$f":"IF(C8<>\"\", VLOOKUP(C8,'Database Cylinder'!$A:$G, 6, FALSE), \"\")","v":2.1999999999999999E-2},"m","Cylinder Rod Ø",null,"Δpt (retract)",{"$f":"IF(C6=\"AsymCylinder + AsymValve\",(2*C5-4*ABS(H12))/3,H15)","v":2115556.1726315152},"Pa","Valve Total Pressure Drop"]
[null,"AA",{"$f":"((C15^2-C16^2)*PI())/4","v":1.583362697409256E-3},"m²","Cylinder Area A",null,"KV",{"$f":"H10/(H15)^(1/2)","v":9.2949649185055039E-7},"m³/(sPa^1/2)","Flow Coefficient"]
[null,"rA",{"$f":"IF(C8<>\"\", VLOOKUP(C8,'Database Cylinder'!$A:$G, 7, FALSE), \"\")","v":1},1,"Area ratio",null,"KV",{"$f":"H17*60000/SQRT(0.00001)","v":17.635955948303252},"L/(min bar^1/2)","Flow Coefficient"]
[null,"AB",{"$f":"C18 * C17","v":1.583362697409256E-3},"m²","Cylinder Area B",null,"KVcat",{"$f":"C28/SQRT(C27)","v":2.4026734210308922E-7},"m³/(sPa^1/2)","Catalog Flow Coefficient"]
[null,"Vt_A",{"$f":"C14*C17","v":2.5333803158548095E-4},"m³","Cylinder Volume",null,"KVcat",{"$f":"H19*60000/SQRT(0.00001)","v":4.5587522904037954},"L/(min bar^1/2)","Catalog Flow Coefficient"]
[null,"xA",{"$f":"IF(C18=1,C14,((C17*C14)/(C17-C19)) * (1-(C19/C17)^(1/2)))","v":0.16},"m","Cylinder Stroke",null,"KqU0",{"$f":"H19*ABS(H15)^(1/2)/C29","v":3.4946768637408029E-5},"m³/(sV)","Flow Gain"]
[null,null,null,null,null,null,"KC0 (extend)",{"$f":"'Step 2 - Tasks 5 to 8'!H9","v":8.2594754725747047E-11},"m³/(sPa)","Flow-Pressure Coefficient"]
[null,"Valve",{"$f":"'Step 2 - Tasks 5 to 8'!C13","v":"MOOG 760 C263-A"},null,null,null,"KC0 (retract)",{"$f":"'Step 2 - Tasks 5 to 8'!H10","v":8.2594754725747047E-11},"m³/(sPa)","Flow-Pressure Coefficient"]
[null,"Catalog Data","Value","Unity","Description"]
[null,"wn_V_cat",{"$f":"IF(C23<>\"\", VLOOKUP(C23,'Database Valve'!$A:$G, 2, FALSE), \"\")","v":1099},"rad/s","Valve Natural Frequency"]
[null,"ζV",{"$f":"IF(C23<>\"\", VLOOKUP(C23,'Database Valve'!$A:$G, 3, FALSE), \"\")","v":0.9},1,"Valve Damping Ratio"]
[null,"Δpt_n",{"$f":"IF(C23<>\"\", VLOOKUP(C23,'Database Valve'!$A:$G, 4, FALSE), \"\")","v":6895000},"Pa","Catalog Valve Pressure Drop"]
[null,"qVn",{"$f":"IF(C23<>\"\", VLOOKUP(C23,'Database Valve'!$A:$G, 5, FALSE), \"\")","v":6.3090196403438597E-4},"m³/s","Catalog Flow Rate at Pressure Drop"]
[null,"Un",{"$f":"IF(C23<>\"\", VLOOKUP(C23,'Database Valve'!$A:$G, 6, FALSE), \"\")","v":10},"V","Nominal control signal"]
[null,"total pressure drop?",{"$f":"IF(C23<>\"\", VLOOKUP(C23,'Database Valve'!$A:$G, 7, FALSE), \"\")","v":"Yes"},1,"Is the Pressure Drop in the Catalog the Total?"]

{"sheet":"Add Actuator","index":7,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,2,1,4]]}
[]
[null,"Cylinder"]
[null,"Catalog Data","Value","Unity","Description"]
[null,"MA",null,"kg","Cylinder Mass at 0mm Stroke"]
[null,"Ms_A",null,"kg/m","Cylinder mass per (0.1m) 100mm Stroke"]
[null,"lt_A",null,"m","Cylinder Stroke"]
[null,"de",null,"m","Cylinder Ø"]
[null,"dh",null,"m","Cylinder Rod Ø"]
[null,"AA",{"$f":"(PI()*C7^2)/4","v":0},"m²","Cylinder Area A"]
[null,"rA",{"$f":"IF('Step 1 - Tasks 1 to 3'!C11=\"SymCylinder + SymValve\",1,IF(C9>0.001,((C7^2-C8^2)*PI())/4/C9,0.5))","v":1},1,"Area ratio"]

{"sheet":"Database Cylinder","index":8,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["No Selected Actuator","MA","Ms_A","lt_A","de","dh","rA"]
["REXROTH CGT3 MS2 50/22-500 SYM",5.5,1.2,0.16,0.05,2.1999999999999999E-2,1]
["REXROTH CGT3 MS2 50/22-500 ASYM",5.5,1.2,0.16,0.05,2.1999999999999999E-2,0.80640000000000012]

{"sheet":"Add Valve","index":9,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,2,1,4]]}
[]
[null,"Valve"]
[null,"Catalog Data","Value","Unity","Description"]
[null,"wn_V_cat",null,"rad/s","Valve Natural Frequency"]
[null,"ζV",null,1,"Valve Damping Ratio"]
[null,"Δpt_n",null,"Pa","Catalog Valve Pressure Drop"]
[null,"qVn",null,"m³/s","Catalog Flow Rate at Pressure Drop"]
[null,"Un",null,"V","Nominal control signal"]
[null,"total pressure drop?",null,1,"Is the Pressure Drop in the Catalog the Total?"]

{"sheet":"Database Valve","index":10,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["No Selected Valve","wn_v","ζ_v","Δpt_cat","qv_n_cat","Un","total pressure drop?"]
["MOOG 760 C263-A",1099,0.9,6895000,6.3090196403438597E-4,10,"Yes"]
["MOOG 760 S19KOFM4VPL",1979,0.8,6895000,3.1545098201719298E-4,10,"Yes"]

{"sheet":"Planilha3","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}