{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Расчёт без макросов","Расчёт с VBA(макросами)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Расчёт без макросов","index":0,"n_rows":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,3],[3,1,3,3]]}
["Переменная","Известно\n(вводить только 2 значения переменной)",null,null,"Результат"]
["a",100,null,null,{"$f":"IF(B2>0,B2,IF(AND(B2<=0,B3>0,B4>0),(B4^2-B3^2)^0.5,\nIF(AND(B2<=0,B3>0,B5>0,C5<=0,D5<=0),TAN(B5*PI()/180)*B3,\nIF(AND(B2<=0,B3>0,B5>0,C5>0,D5<=0),TAN((B5+(C5/60))*PI()/180)*B3,\nIF(AND(B2<=0,B3>0,B5>0,C5<=0,D5>0),TAN((B5+(C5/60)+(D5/3600))*PI()/180)*B3,\nIF(AND(B2<=0,B3>0,B5>0,C5>0,D5>0),TAN((B5+(C5/60)+(D5/3600))*PI()/180)*B3,\nIF(AND(B2<=0,B3>0,B5<=0,C5>0,D5>0),TAN(((C5/60)+(D5/3600))*PI()/180)*B3,\nIF(AND(B2<=0,B3>0,B5<=0,C5<=0,D5>0),TAN((D5/3600)*PI()/180)*B3,\nIF(AND(B2<=0,B3>0,B5<=0,C5>0,D5<=0),TAN((C5/60)*PI()/180)*B3,\nIF(AND(B2<=0,B4>0,B5>0,C5<=0,D5<=0),SIN(B5*PI()/180)*B4,\nIF(AND(B2<=0,B4>0,B5>0,C5>0,D5<=0),SIN((B5+(C5/60))*PI()/180)*B4,\nIF(AND(B2<=0,B4>0,B5>0,C5<=0,D5>0),SIN((B5+(C5/60)+(D5/3600))*PI()/180)*B4,\nIF(AND(B2<=0,B4>0,B5>0,C5>0,D5>0),SIN((B5+(C5/60)+(D5/3600))*PI()/180)*B4,\nIF(AND(B2<=0,B4>0,B5<=0,C5>0,D5>0),SIN(((C5/60)+(D5/3600))*PI()/180)*B4,\nIF(AND(B2<=0,B4>0,B5<=0,C5<=0,D5>0),SIN((D5/3600)*PI()/180)*B4,\nIF(AND(B2<=0,B4>0,B5<=0,C5>0,D5<=0),SIN((C5/60)*PI()/180)*B4,\nIF(AND(B2<=0,B3>0,B6>0,C6<=0,D6<=0),B3/TAN(B6*PI()/180),\nIF(AND(B2<=0,B3>0,B6>0,C6>0,D6<=0),B3/TAN((B6+(C6/60))*PI()/180),\nIF(AND(B2<=0,B3>0,B6>0,C6<=0,D6>0),B3/TAN((B6+(C6/60)+(D6/3600))*PI()/180),\nIF(AND(B2<=0,B3>0,B6>0,C6>0,D6>0),B3/TAN((B6+(C6/60)+(D6/3600))*PI()/180),\nIF(AND(B2<=0,B3>0,B6<=0,C6>0,D6>0),B3/TAN(((C6/60)+(D6/3600))*PI()/180),\nIF(AND(B2<=0,B3>0,B6<=0,C6<=0,D6>0),B3/TAN((D5/3600)*PI()/180),\nIF(AND(B2<=0,B3>0,B6<=0,C6>0,D6<=0),B3/TAN((C6/60)*PI()/180),\nIF(AND(B2<=0,B4>0,B6>0,C6<=0,D6<=0),COS(B6*PI()/180)*B4,\nIF(AND(B2<=0,B4>0,B6>0,C6>0,D6<=0),COS((B6+(C6/60))*PI()/180)*B4,\nIF(AND(B2<=0,B4>0,B6>0,C6<=0,D6>0),COS((B6+(C6/60)+(D6/3600))*PI()/180)*B4,\nIF(AND(B2<=0,B4>0,B6>0,C6>0,D6>0),COS((B6+(C6/60)+(D6/3600))*PI()/180)*B4,\nIF(AND(B2<=0,B4>0,B6<=0,C6>0,D6>0),COS(((C6/60)+(D6/3600))*PI()/180)*B4,\nIF(AND(B2<=0,B4>0,B6<=0,C6<=0,D6>0),COS((D6/3600)*PI()/180)*B4,\nIF(AND(B2<=0,B4>0,B6<=0,C6>0,D6<=0),COS((C6/60)*PI()/180)*B4,\n))))))))))))))))))))))))))))))","v":100},{"$f":"IF((B2>0)+(B3>0)+(B4>0)+OR(B5>0,C5>0,D5>0)+OR(B6>0,C6>0,D6>0)<>2,\"надо 2 параметра\",IF(B2>0,B2,IF(AND($B$3>0,$B$4>0),SQRT(B4^2-B3^2),IF(AND($B$3>0,OR($B$5>0,$C$5>0,$D$5>0)),B3*TAN(RADIANS(B5+C5/60+D5/3600)),IF(AND($B$3>0,OR($B$6>0,$C$6>0,$D$6>0)),B3/TAN(RADIANS(B6+C6/60+D6/3600)),IF(AND($B$4>0,OR($B$5>0,$C$5>0,$D$5>0)),B4*SIN(RADIANS(B5+C5/60+D5/3600)),IF(AND($B$4>0,OR($B$6>0,$C$6>0,$D$6>0)),B4*COS(RADIANS(B6+C6/60+D6/3600)),\"----\")))))))","v":100}]
["b",null,null,null,{"$f":"IF(B3>0,B3,IF(AND(B2>0,B4>0),(B4^2-B2^2)^0.5,\nIF(AND(B3<=0,B2>0,B6>0,C6<=0,D6<=0),TAN(B5*PI()/180)*B2,\nIF(AND(B3<=0,B2>0,B6>0,C6>0,D6<=0),TAN((B6+(C6/60))*PI()/180)*B2,\nIF(AND(B3<=0,B2>0,B6>0,C6<=0,D5>0),TAN((B6+(C6/60)+(D6/3600))*PI()/180)*B2,\nIF(AND(B3<=0,B2>0,B6>0,C6>0,D6>0),TAN((B6+(C6/60)+(D6/3600))*PI()/180)*B2,\nIF(AND(B3<=0,B2>0,B6<=0,C6>0,D6>0),TAN(((C6/60)+(D6/3600))*PI()/180)*B2,\nIF(AND(B3<=0,B2>0,B6<=0,C6<=0,D6>0),TAN((D6/3600)*PI()/180)*B2,\nIF(AND(B3<=0,B2>0,B6<=0,C6>0,D6<=0),TAN((C6/60)*PI()/180)*B2,\nIF(AND(B3<=0,B4>0,B5>0,C5<=0,D5<=0),COS(B5*PI()/180)*B4,\nIF(AND(B3<=0,B4>0,B5>0,C5>0,D5<=0),COS((B5+(C5/60))*PI()/180)*B4,\nIF(AND(B3<=0,B4>0,B5>0,C5<=0,D5>0),COS((B5+(C5/60)+(D5/3600))*PI()/180)*B4,\nIF(AND(B3<=0,B4>0,B5>0,C5>0,D5>0),COS((B5+(C5/60)+(D5/3600))*PI()/180)*B4,\nIF(AND(B3<=0,B4>0,B5<=0,C5>0,D5>0),COS(((C5/60)+(D5/3600))*PI()/180)*B4,\nIF(AND(B3<=0,B4>0,B5<=0,C5<=0,D5>0),COS((D5/3600)*PI()/180)*B4,\nIF(AND(B3<=0,B4>0,B5<=0,C5>0,D5<=0),COS((C5/60)*PI()/180)*B4,\nIF(AND(B3<=0,B4>0,B6>0,C6<=0,D6<=0),SIN(B6*PI()/180)*B4,\nIF(AND(B3<=0,B4>0,B6>0,C6>0,D6<=0),SIN((B6+(C6/60))*PI()/180)*B4,\nIF(AND(B3<=0,B4>0,B6>0,C6<=0,D6>0),SIN((B6+(C6/60)+(D6/3600))*PI()/180)*B4,\nIF(AND(B3<=0,B4>0,B6>0,C6>0,D6>0),SIN((B6+(C6/60)+(D6/3600))*PI()/180)*B4,\nIF(AND(B3<=0,B4>0,B6<=0,C6>0,D6>0),SIN(((C6/60)+(D6/3600))*PI()/180)*B4,\nIF(AND(B3<=0,B4>0,B6<=0,C6<=0,D6>0),SIN((D6/3600)*PI()/180)*B4,\nIF(AND(B3<=0,B4>0,B6<=0,C6>0,D6<=0),SIN((C6/60)*PI()/180)*B4,\nIF(AND(B3<=0,B2>0,B5>0,C5<=0,D5<=0),B2/TAN(B5*PI()/180),\nIF(AND(B3<=0,B2>0,B5>0,C5>0,D5<=0),B2/TAN((B5+(C5/60))*PI()/180),\nIF(AND(B3<=0,B2>0,B5>0,C5<=0,D5>0),B2/TAN((B5+(C5/60)+(D5/3600))*PI()/180),\nIF(AND(B3<=0,B2>0,B5>0,C5>0,D5>0),B2/TAN((B5+(C5/60)+(D5/3600))*PI()/180),\nIF(AND(B3<=0,B2>0,B5<=0,C5>0,D5>0),B2/TAN(((C5/60)+(D5/3600))*PI()/180),\nIF(AND(B3<=0,B2>0,B5<=0,C5<=0,D5>0),B2/TAN((D5/3600)*PI()/180),\nIF(AND(B3<=0,B2>0,B5<=0,C5>0,D5<=0),B2/TAN((C5/60)*PI()/180),\n))))))))))))))))))))))))))))))","v":98.241140538034401},{"$f":"IF((B2>0)+(B3>0)+(B4>0)+OR(B5>0,C5>0,D5>0)+OR(B6>0,C6>0,D6>0)<>2,\"надо 2 параметра\",IF(B3>0,B3,IF(AND($B$2>0,$B$4>0),SQRT(B4^2-B2^2),IF(AND($B$2>0,OR($B$5>0,$C$5>0,$D$5>0)),B2/TAN(RADIANS(B5+C5/60+D5/3600)),IF(AND($B$2>0,OR($B$6>0,$C$6>0,$D$6>0)),B2*TAN(RADIANS(B6+C6/60+D6/3600)),IF(AND($B$4>0,OR($B$5>0,$C$5>0,$D$5>0)),B4*COS(RADIANS(B5+C5/60+D5/3600)),IF(AND($B$4>0,OR($B$6>0,$C$6>0,$D$6>0)),B4*SIN(RADIANS(B6+C6/60+D6/3600)),\"----\")))))))","v":98.241140538034401}]
["c",null,null,null,{"$f":"IF(B4>0,B4,IF(AND(B2>0,B3>0),(B2^2+B3^2)^0.5,\nIF(AND(B4<=0,B3>0,B6>0,C6<=0,D6<=0),B3/SIN(B6*PI()/180),\nIF(AND(B4<=0,B3>0,B6>0,C6>0,D6<=0),B3/SIN((B6+(C6/60))*PI()/180),\nIF(AND(B4<=0,B3>0,B6>0,C6<=K120,D6>0),B3/SIN((B6+(C6/60)+(D6/3600))*PI()/180),\nIF(AND(B4<=0,B3>0,B6>0,C6>0,D6>0),B3/SIN((B6+(C6/60)+(D6/3600))*PI()/180),\nIF(AND(B4<=0,B3>0,B6<=0,C6>0,D6>0),B3/SIN(((C6/60)+(D6/3600))*PI()/180),\nIF(AND(B4<=0,B3>0,B6<=0,C6<=0,D6>0),B3/SIN((D6/3600)*PI()/180),\nIF(AND(B4<=0,B3>0,B6<=0,C6>0,D6<=0),B3/SIN((C6/60)*PI()/180),\nIF(AND(B4<=0,B3>0,B5>0,C5<=0,D5<=0),B3/COS(B5*PI()/180),\nIF(AND(B4<=0,B3>0,B5>0,C5>0,D5<=0),B3/COS((B5+(C5/60))*PI()/180),\nIF(AND(B4<=0,B3>0,B5>0,C5<=0,D5>0),B3/COS((B5+(C5/60)+(D5/3600))*PI()/180),\nIF(AND(B4<=0,B3>0,B5>0,C5>0,D5>0),B3/COS((B5+(C5/60)+(D5/3600))*PI()/180),\nIF(AND(B4<=0,B3>0,B5<=0,C5>0,D5>0),B3/COS(((C5/60)+(D5/3600))*PI()/180),\nIF(AND(B4<=0,B3>0,B5<=0,C5<=0,D5>0),B3/COS((D5/3600)*PI()/180),\nIF(AND(B4<=0,B3>0,B5<=0,C5>0,D5<=0),B3/COS((C5/60)*PI()/180),\nIF(AND(B4<=0,B2>0,B5>0,C5<=0,D5<=0),B2/SIN(B5*PI()/180),\nIF(AND(B4<=0,B2>0,B5>0,C5>0,D5<=0),B2/SIN((B5+(C5/60))*PI()/180),\nIF(AND(B4<=0,B2>0,B5>0,C5<=0,D5>0),B2/SIN((B5+(C5/60)+(D5/3600))*PI()/180),\nIF(AND(B4<=0,B2>0,B5>0,C5>0,D5>0),B2/SIN((B5+(C5/60)+(D5/3600))*PI()/180),\nIF(AND(B4<=0,B2>0,B5<=0,C5>0,D5>0),B2/SIN(((C5/60)+(D5/3600))*PI()/180),\nIF(AND(B4<=0,B2>0,B5<=0,C5<=0,D5>0),B2/SIN((D5/3600)*PI()/180),\nIF(AND(B4<=0,B2>0,B5<=0,C5>0,D5<=0),B2/SIN((C5/60)*PI()/180),\nIF(AND(B4<=0,B2>0,B6>0,C6<=0,D6<=0),B2/COS(B6*PI()/180),\nIF(AND(B4<=0,B2>0,B6>0,C6>0,D6<=0),B2/COS((B6+(C6/60))*PI()/180),\nIF(AND(B4<=0,B2>0,B6>0,C6<=0,D6>0),B2/COS((B6+(C6/60)+(D6/3600))*PI()/180),\nIF(AND(B4<=0,B2>0,B6>0,C6>0,D6>0),B2/COS((B6+(C6/60)+(D6/3600))*PI()/180),\nIF(AND(B4<=0,B2>0,B6<=0,C6>0,D6>0),B2/COS(((C6/60)+(D6/3600))*PI()/180),\nIF(AND(B4<=0,B2>0,B6<=0,C6<=0,D6>0),B2/COS((D6/3600)*PI()/180),\nIF(AND(B4<=0,B2>0,B6<=0,C6>0,D6<=0),B2/COS((C6/60)*PI()/180),\n))))))))))))))))))))))))))))))","v":140.18317193662665},{"$f":"IF((B2>0)+(B3>0)+(B4>0)+OR(B5>0,C5>0,D5>0)+OR(B6>0,C6>0,D6>0)<>2,\"надо 2 параметра\",IF(B4>0,B4,IF(AND($B$2>0,$B$3>0),SQRT(B2^2+B3^2),IF(AND($B$2>0,OR($B$5>0,$C$5>0,$D$5>0)),B2/SIN(RADIANS(B5+C5/60+D5/3600)),IF(AND($B$2>0,OR($B$6>0,$C$6>0,$D$6>0)),B2/COS(RADIANS(B6+C6/60+D6/3600)),IF(AND($B$3>0,OR($B$5>0,$C$5>0,$D$5>0)),B3/COS(RADIANS(B5+C5/60+D5/3600)),IF(AND($B$3>0,OR($B$6>0,$C$6>0,$D$6>0)),B3/SIN(RADIANS(B6+C6/60+D6/3600)),\"----\")))))))","v":140.18317193662665}]
["α",45,30,30,{"$f":"IF(AND(B5>0,C5>0,D5>0),B5&\"º\"&C5&\"'\"&D5&\"\"\"\",IF(AND(B5>0,C5>0,D5<=0),B5&\"º\"&C5&\"'\",IF(AND(B5>0,C5<=0,D5>0),B5&\"º\"&D5&\"\"\"\",IF(AND(B5>0,C5<=0,D5<=0),B5&\"º\",IF(AND(B5<=0,C5>0,D5>0),C5&\"'\"&D5&\"\"\"\",\nIF(AND(B5<=0,B4>0,B2>0,B3>0,(DEGREES(ATAN(B2/E3)))<1,(DEGREES(ATAN(B2/E3)))*60<1),TEXT((MOD((DEGREES(ATAN(B2/E3))),1)-INT(MOD((DEGREES(ATAN(B2/E3))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND((DEGREES(ATAN(B2/E3)))<1,(DEGREES(ATAN(B2/E3)))*60>=1,(DEGREES(ATAN(B2/E3)))*60=INT((DEGREES(ATAN(B2/E3)))*60)),TEXT(INT(MOD((DEGREES(ATAN(B2/E3))),1)*60),\"#\")&\"'\",\nIF(AND((DEGREES(ATAN(B2/E3)))<1,(DEGREES(ATAN(B2/E3)))*60>1),TEXT(INT(MOD((DEGREES(ATAN(B2/E3))),1)*60),\"#\")&\"'\"&TEXT((MOD((DEGREES(ATAN(B2/E3))),1)-INT(MOD((DEGREES(ATAN(B2/E3))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND((DEGREES(ATAN(B2/E3)))>=1,(DEGREES(ATAN(B2/E3)))=INT((DEGREES(ATAN(B2/E3))))),TEXT(INT((DEGREES(ATAN(B2/E3)))),\"#\")&\"°\",\nIF((DEGREES(ATAN(B2/E3)))>=1,TEXT(INT((DEGREES(ATAN(B2/E3)))),\"#\")&\"°\"&TEXT(INT(MOD((DEGREES(ATAN(B2/E3))),1)*60),\"#\")&\"'\"&TEXT((MOD((DEGREES(ATAN(B2/E3))),1)-INT(MOD((DEGREES(ATAN(B2/E3))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND(B5<=0,B4<=0,B2>0,B3>0,(DEGREES(ATAN(B2/E3)))<1,(DEGREES(ATAN(B2/E3)))*60<1),TEXT((MOD((DEGREES(ATAN(B2/E3))),1)-INT(MOD((DEGREES(ATAN(B2/E3))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND((DEGREES(ATAN(B2/E3)))<1,(DEGREES(ATAN(B2/E3)))*60>=1,(DEGREES(ATAN(B2/E3)))*60=INT((DEGREES(ATAN(B2/E3)))*60)),TEXT(INT(MOD((DEGREES(ATAN(B2/E3))),1)*60),\"#\")&\"'\",\nIF(AND((DEGREES(ATAN(B2/E3)))<1,(DEGREES(ATAN(B2/E3)))*60>1),TEXT(INT(MOD((DEGREES(ATAN(B2/E3))),1)*60),\"#\")&\"'\"&TEXT((MOD((DEGREES(ATAN(B2/E3))),1)-INT(MOD((DEGREES(ATAN(B2/E3))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND((DEGREES(ATAN(B2/E3)))>=1,(DEGREES(ATAN(B2/E3)))=INT((DEGREES(ATAN(B2/E3))))),TEXT(INT((DEGREES(ATAN(B2/E3)))),\"#\")&\"°\",\nIF((DEGREES(ATAN(B2/E3)))>=1,TEXT(INT((DEGREES(ATAN(B2/E3)))),\"#\")&\"°\"&TEXT(INT(MOD((DEGREES(ATAN(B2/E3))),1)*60),\"#\")&\"'\"&TEXT((MOD((DEGREES(ATAN(B2/E3))),1)-INT(MOD((DEGREES(ATAN(B2/E3))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND(B5<=0,B3<=0,B2>0,B4>0,(DEGREES(ASIN(B2/B4)))<1,(DEGREES(ASIN(B2/B4)))*60<1),TEXT((MOD((DEGREES(ASIN(B2/B4))),1)-INT(MOD((DEGREES(ASIN(B2/B4))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND((DEGREES(ASIN(B2/B4)))<1,(DEGREES(ASIN(B2/B4)))*60>=1,(DEGREES(ASIN(B2/B4)))*60=INT((DEGREES(ASIN(B2/B4)))*60)),TEXT(INT(MOD((DEGREES(ASIN(B2/B4))),1)*60),\"#\")&\"'\",\nIF(AND((DEGREES(ASIN(B2/B4)))<1,(DEGREES(ASIN(B2/B4)))*60>1),TEXT(INT(MOD((DEGREES(ASIN(B2/B4))),1)*60),\"#\")&\"'\"&TEXT((MOD((DEGREES(ASIN(B2/B4))),1)-INT(MOD((DEGREES(ASIN(B2/B4))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND((DEGREES(ASIN(B2/B4)))>=1,(DEGREES(ASIN(B2/B4)))=INT((DEGREES(ASIN(B2/B4))))),TEXT(INT((DEGREES(ASIN(B2/B4)))),\"#\")&\"°\",\nIF((DEGREES(ASIN(B2/B4)))>=1,TEXT(INT((DEGREES(ASIN(B2/B4)))),\"#\")&\"°\"&TEXT(INT(MOD((DEGREES(ASIN(B2/B4))),1)*60),\"#\")&\"'\"&TEXT((MOD((DEGREES(ASIN(B2/B4))),1)-INT(MOD((DEGREES(ASIN(B2/B4))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND(B5<=0,B4>0,B2<=0,B3>0,(DEGREES(ACOS(B3/B4)))<1,(DEGREES(ACOS(B3/B4)))*60<1),TEXT((MOD((DEGREES(ACOS(B3/B4))),1)-INT(MOD((DEGREES(ACOS(B3/B4))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND((DEGREES(ACOS(B3/B4)))<1,(DEGREES(ACOS(B3/B4)))*60>=1,(DEGREES(ACOS(B3/B4)))*60=INT((DEGREES(ACOS(B3/B4)))*60)),TEXT(INT(MOD((DEGREES(ACOS(B3/B4))),1)*60),\"#\")&\"'\",\nIF(AND((DEGREES(ACOS(B3/B4)))<1,(DEGREES(ACOS(B3/B4)))*60>1),TEXT(INT(MOD((DEGREES(ACOS(B3/B4))),1)*60),\"#\")&\"'\"&TEXT((MOD((DEGREES(ACOS(B3/B4))),1)-INT(MOD((DEGREES(ACOS(B3/B4))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND((DEGREES(ACOS(B3/B4)))>=1,(DEGREES(ACOS(B3/B4)))=INT((DEGREES(ACOS(B3/B4))))),TEXT(INT((DEGREES(ACOS(B3/B4)))),\"#\")&\"°\",\nIF((DEGREES(ACOS(B3/B4)))>=1,TEXT(INT((DEGREES(ACOS(B3/B4)))),\"#\")&\"°\"&TEXT(INT(MOD((DEGREES(ACOS(B3/B4))),1)*60),\"#\")&\"'\"&TEXT((MOD((DEGREES(ACOS(B3/B4))),1)-INT(MOD((DEGREES(ACOS(B3/B4))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND(B5<=0,C4>0,C2>0,C3>0,(DEGREES(ATAN(E2/E3)))<1,(DEGREES(ATAN(E2/E3)))*60<1),TEXT((MOD((DEGREES(ATAN(E2/E3))),1)-INT(MOD((DEGREES(ATAN(E2/E3))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND((DEGREES(ATAN(E2/E3)))<1,(DEGREES(ATAN(E2/E3)))*60>=1,(DEGREES(ATAN(E2/E3)))*60=INT((DEGREES(ATAN(E2/E3)))*60)),TEXT(INT(MOD((DEGREES(ATAN(E2/E3))),1)*60),\"#\")&\"'\",\nIF(AND((DEGREES(ATAN(E2/E3)))<1,(DEGREES(ATAN(E2/E3)))*60>1),TEXT(INT(MOD((DEGREES(ATAN(E2/E3))),1)*60),\"#\")&\"'\"&TEXT((MOD((DEGREES(ATAN(E2/E3))),1)-INT(MOD((DEGREES(ATAN(E2/E3))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND((DEGREES(ATAN(E2/E3)))>=1,(DEGREES(ATAN(E2/E3)))=INT((DEGREES(ATAN(E2/E3))))),TEXT(INT((DEGREES(ATAN(E2/E3)))),\"#\")&\"°\",\nIF((DEGREES(ATAN(E2/E3)))>=1,TEXT(INT((DEGREES(ATAN(E2/E3)))),\"#\")&\"°\"&TEXT(INT(MOD((DEGREES(ATAN(E2/E3))),1)*60),\"#\")&\"'\"&TEXT((MOD((DEGREES(ATAN(E2/E3))),1)-INT(MOD((DEGREES(ATAN(E2/E3))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND(B5<=0,C3<=0,C2>0,C4>0,(DEGREES(ASIN(E2/E4)))<1,(DEGREES(ASIN(E2/E4)))*60<1),TEXT((MOD((DEGREES(ASIN(E2/E4))),1)-INT(MOD((DEGREES(ASIN(E2/E4))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND((DEGREES(ASIN(E2/E4)))<1,(DEGREES(ASIN(E2/E4)))*60>=1,(DEGREES(ASIN(E2/E4)))*60=INT((DEGREES(ASIN(E2/E4)))*60)),TEXT(INT(MOD((DEGREES(ASIN(E2/E4))),1)*60),\"#\")&\"'\",\nIF(AND((DEGREES(ASIN(E2/E4)))<1,(DEGREES(ASIN(E2/E4)))*60>1),TEXT(INT(MOD((DEGREES(ASIN(E2/E4))),1)*60),\"#\")&\"'\"&TEXT((MOD((DEGREES(ASIN(E2/E4))),1)-INT(MOD((DEGREES(ASIN(E2/E4))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND((DEGREES(ASIN(E2/E4)))>=1,(DEGREES(ASIN(E2/E4)))=INT((DEGREES(ASIN(E2/E4))))),TEXT(INT((DEGREES(ASIN(E2/E4)))),\"#\")&\"°\",\nIF((DEGREES(ASIN(E2/E4)))>=1,TEXT(INT((DEGREES(ASIN(E2/E4)))),\"#\")&\"°\"&TEXT(INT(MOD((DEGREES(ASIN(E2/E4))),1)*60),\"#\")&\"'\"&TEXT((MOD((DEGREES(ASIN(E2/E4))),1)-INT(MOD((DEGREES(ASIN(E2/E4))),1)*60)/60)*3600,\"#\")&\"\"\"\",\n\nIF(AND(B5<=0,C4>0,C2<=0,C3>0,(DEGREES(ACOS(E3/E4)))<1,(DEGREES(ACOS(E3/E4)))*60<1),TEXT((MOD((DEGREES(ACOS(E3/E4))),1)-INT(MOD((DEGREES(ACOS(E3/E4))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND((DEGREES(ACOS(E3/E4)))<1,(DEGREES(ACOS(E3/E4)))*60>=1,(DEGREES(ACOS(E3/E4)))*60=INT((DEGREES(ACOS(E3/E4)))*60)),TEXT(INT(MOD((DEGREES(ACOS(E3/E4))),1)*60),\"#\")&\"'\",\nIF(AND((DEGREES(ACOS(E3/E4)))<1,(DEGREES(ACOS(E3/E4)))*60>1),TEXT(INT(MOD((DEGREES(ACOS(E3/E4))),1)*60),\"#\")&\"'\"&TEXT((MOD((DEGREES(ACOS(E3/E4))),1)-INT(MOD((DEGREES(ACOS(E3/E4))),1)*60)/60)*3600,\"#\")&\"\"\"\",\nIF(AND((DEGREES(ACOS(E3/E4)))>=1,(DEGREES(ACOS(E3/E4)))=INT((DEGREES(ACOS(E3/E4))))),TEXT(INT((DEGREES(ACOS(E3/E4)))),\"#\")&\"°\",\nIF((DEGREES(ACOS(E3/E4)))>=1,TEXT(INT((DEGREES(ACOS(E3/E4)))),\"#\")&\"°\"&TEXT(INT(MOD((DEGREES(ACOS(E3/E4))),1)*60),\"#\")&\"'\"&TEXT((MOD((DEGREES(ACOS(E3/E4))),1)-INT(MOD((DEGREES(ACOS(E3/E4))),1)*60)/60)*3600,\"#\")&\"\"\"\"\n))))))))))))))))))))))))))))))))))))))))","v":"45º30'30\""},{"$f":"IF((B2>0)+(B3>0)+(B4>0)+OR(B5>0,C5>0,D5>0)+OR(B6>0,C6>0,D6>0)<>2,\"надо 2 параметра\",IF(OR(B5>0,C5>0,D5>0),TEXT((B5+C5/60+D5/3600)/24,\"[ч]°мм'сс''\"),IF(OR(B6>0,C6>0,D6>0),TEXT((90-(B6+C6/60+D6/3600))/24,\"[ч]°мм'сс''\"),IF(AND($B$2>0,$B$3>0),TEXT(DEGREES(ATAN(B2/B3))/24,\"[ч]°мм'сс''\"),IF(AND($B$2>0,$B$4>0),TEXT(DEGREES(ASIN(B2/B4))/24,\"[ч]°мм'сс''\"),IF(AND($B$3>0,$B$4>0),TEXT(DEGREES(ACOS(B3/B4))/24,\"[ч]°мм'сс''\"),\"----\"))))))","v":"45°30'30''"}]
["β",null,null,null,"?",{"$f":"IF((B2>0)+(B3>0)+(B4>0)+OR(B5>0,C5>0,D5>0)+OR(B6>0,C6>0,D6>0)<>2,\"надо 2 параметра\",IF(OR(B6>0,C6>0,D6>0),TEXT((B6+C6/60+D6/3600)/24,\"[ч]°мм'сс''\"),IF(OR(B5>0,C5>0,D5>0),TEXT((90-(B5+C5/60+D5/3600))/24,\"[ч]°мм'сс''\"),IF(AND($B$2>0,$B$3>0),TEXT(DEGREES(ATAN(B3/B2))/24,\"[ч]°мм'сс''\"),IF(AND($B$2>0,$B$4>0),TEXT(DEGREES(ACOS(B2/B4))/24,\"[ч]°мм'сс''\"),IF(AND($B$3>0,$B$4>0),TEXT(DEGREES(ASIN(B3/B4))/24,\"[ч]°мм'сс''\"),\"----\"))))))","v":"44°29'30''"},null,null,null,null,null,null,null,null,"°"]
[null,"º","\""," '"]

{"sheet":"Расчёт с VBA(макросами)","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Переменная","Известно\n(вводить только 2 значения переменной)","Результат"]
["a",null,{"$f":"IF(B2>0,B2,IF(AND(B2<=0,B3>0,B4>0),(B4^2-B3^2)^0.5,\nIF(AND(B2<=0,B3>0,B5>0),TAN((SIGN(LEFTB(B5)&1)*SUMPRODUCT(MID(0&SUBSTITUTE(B5,\".\",MID(1/2,2,1)),LEN(B5)-{14,11,7},{2,3,7})/60^{0,1,2}))*PI()/180)*B3,\nIF(AND(B2<=0,B3>0,B6>0),B3/TAN((SIGN(LEFTB(B6)&1)*SUMPRODUCT(MID(0&SUBSTITUTE(B6,\".\",MID(1/2,2,1)),LEN(B6)-{14,11,7},{2,3,7})/60^{0,1,2}))*PI()/180),\nIF(AND(B2<=0,B4>0,B5>0),SIN((SIGN(LEFTB(B5)&1)*SUMPRODUCT(MID(0&SUBSTITUTE(B5,\".\",MID(1/2,2,1)),LEN(B5)-{14,11,7},{2,3,7})/60^{0,1,2}))*PI()/180)*B4,\nIF(AND(B2<=0,B4>0,B6>0),COS((SIGN(LEFTB(B6)&1)*SUMPRODUCT(MID(0&SUBSTITUTE(B6,\".\",MID(1/2,2,1)),LEN(B6)-{14,11,7},{2,3,7})/60^{0,1,2}))*PI()/180)*B4,\n))))))","v":149.9994666657185}]
["b",400,{"$f":"IF(B3>0,B3,IF(AND(B2>0,B4>0),(B4^2-B2^2)^0.5,\nIF(AND(B3<=0,B2>0,B6>0),TAN((SIGN(LEFTB(B6)&1)*SUMPRODUCT(MID(0&SUBSTITUTE(B6,\".\",MID(1/2,2,1)),LEN(B6)-{14,11,7},{2,3,7})/60^{0,1,2}))*PI()/180)*B2,\nIF(AND(B3<=0,B2>0,B5>0),B2/TAN((SIGN(LEFTB(B5)&1)*SUMPRODUCT(MID(0&SUBSTITUTE(B5,\".\",MID(1/2,2,1)),LEN(B5)-{14,11,7},{2,3,7})/60^{0,1,2}))*PI()/180),\nIF(AND(B3<=0,B4>0,B5>0),COS((SIGN(LEFTB(B5)&1)*SUMPRODUCT(MID(0&SUBSTITUTE(B5,\".\",MID(1/2,2,1)),LEN(B5)-{14,11,7},{2,3,7})/60^{0,1,2}))*PI()/180)*B4,\nIF(AND(B3<=0,B4>0,B6>0),SIN((SIGN(LEFTB(B6)&1)*SUMPRODUCT(MID(0&SUBSTITUTE(B6,\".\",MID(1/2,2,1)),LEN(B6)-{14,11,7},{2,3,7})/60^{0,1,2}))*PI()/180)*B4,\n))))))","v":400}]
["c",427.2,{"$f":"IF(B4>0,B4,IF(AND(B2>0,B3>0),(B2^2+B3^2)^0.5,\nIF(AND(B4<=0,B2>0,B5>0),B2/SIN((SIGN(LEFTB(B5)&1)*SUMPRODUCT(MID(0&SUBSTITUTE(B5,\".\",MID(1/2,2,1)),LEN(B5)-{14,11,7},{2,3,7})/60^{0,1,2}))*PI()/180),\nIF(AND(B4<=0,B2>0,B6>0),B2/COS((SIGN(LEFTB(B6)&1)*SUMPRODUCT(MID(0&SUBSTITUTE(B6,\".\",MID(1/2,2,1)),LEN(B6)-{14,11,7},{2,3,7})/60^{0,1,2}))*PI()/180),\nIF(AND(B4<=0,B3>0,B5>0),B3/COS((SIGN(LEFTB(B5)&1)*SUMPRODUCT(MID(0&SUBSTITUTE(B5,\".\",MID(1/2,2,1)),LEN(B5)-{14,11,7},{2,3,7})/60^{0,1,2}))*PI()/180),\nIF(AND(B4<=0,B3>0,B6>0),B3/SIN((SIGN(LEFTB(B6)&1)*SUMPRODUCT(MID(0&SUBSTITUTE(B6,\".\",MID(1/2,2,1)),LEN(B6)-{14,11,7},{2,3,7})/60^{0,1,2}))*PI()/180),\n))))))","v":427.2}]
["α",null,{"$f":"IF(B5>0,B5,\nIF(AND(B5<=0,B4>0,B2>0,B3>0),Convert_Degree(DEGREES(ATAN(B2/B3))),\n(IF(AND(B5<=0,B4<=0,B2>0,B3>0),Convert_Degree(DEGREES(ATAN(B2/B3))),\n(IF(AND(B5<=0,B3<=0,B2>0,B4>0),Convert_Degree(DEGREES(ASIN(B2/B4))),\n(IF(AND(B5<=0,B4>0,B2<=0,B3>0),Convert_Degree(DEGREES(ACOS(B3/B4))),\nIF(AND(B5<=0,C4>0,C2>0,C3>0),Convert_Degree(DEGREES(ATAN(C2/C3))),\n(IF(AND(B5<=0,C4<=0,C2>0,C3>0),Convert_Degree(DEGREES(ATAN(C2/C3))),\n(IF(AND(B5<=0,C3<=0,C2>0,C4>0),Convert_Degree(DEGREES(ASIN(C2/C4))),\n(IF(AND(B5<=0,C4>0,C2<=0,C3>0),Convert_Degree(DEGREES(ACOS(C3/C4))),\n)))))))))))))))","v":" 20° 33' 22\""}]
["β",null,{"$f":"IF(B6>0,B6,Convert_Degree(Convert_Decimal(Convert_Degree(90))-Convert_Decimal(IF(B5>0,B5,IF(AND(B5<=0,B4>0,B2>0,B3>0),Convert_Degree(DEGREES(ATAN(B2/B3))),(IF(AND(B5<=0,B4<=0,B2>0,B3>0),Convert_Degree(DEGREES(ATAN(B2/B3))),(IF(AND(B5<=0,B3<=0,B2>0,B4>0),Convert_Degree(DEGREES(ASIN(B2/B4))),(IF(AND(B5<=0,B4>0,B2<=0,B3>0),Convert_Degree(DEGREES(ACOS(B3/B4))))))))))))))","v":" 69° 26' 38\""}]
[]
[null,"34° 54' 55.000''"," - пример ввода угла"]