{"text_format":"5","workbook":"ods","n_sheets":1,"sheets":["Sheet1"],"defined_names":["Excel_BuiltIn_Criteria","Excel_BuiltIn_Database","Excel_BuiltIn_Data_Form","Excel_BuiltIn_Print_Area","Excel_BuiltIn_Print_Titles","Excel_BuiltIn_Recorder","solver_opt"],"not_rendered":{"defined_names":7},"read":"whole","wrapped":"gz","date_system":"iso_in_file"}

{"sheet":"Sheet1","index":0,"n_rows":44,"n_cols":6,"rows_kept":44,"merged":[[0,0,0,5],[2,0,2,5],[14,0,14,1]]}
["Abwicklungen und wahre Längen"]
[]
["Normkalkulation nach DIN 6935 zur Abkantung von Blechdicken bis 12mm"]
[{"$f":"of:=TODAY()","v":"2026-03-25"},null,null,"marc.gloor@u.nus.edu",null,"V 1.94 / gloor"]
[]
["Firma:",null,null,"Ref.:"]
[]
["Benennung:",null,null,"Zch.-Nummer:"]
[]
[]
[]
[]
[]
[]
["Eingabemodus :",null,null,"Berechnungen:",null,"Biegekanten:"]
[]
["Blechdicke:",null,{"$f":"of:=IF([.B17]>12;\"max. 12mm !\";0)","v":0},null,null,{"$f":"of:=IF([.F18]>0;\"Abstände zur Basis:\";0)","v":0}]
["1. Länge:",null,{"$f":"of:=IF([.B18]<(4*[.B20]);\"min. 4 x R !\";0)","v":0},"Prop. r/s:",{"$f":"of:=IF([.B17]>0;[.B20]/[.B17];0)","v":0},{"$f":"of:=IF([.E20]=0;0;[.B18]+([.E20]/2))","v":0}]
["1. Winkel:",null,null,"Korrekturfaktor:",{"$f":"of:=IF(AND([.E18]>0.65;[.E18]<=1);0.6;0)+IF(AND([.E18]>1;[.E18]<=1.5);0.7;0)+IF(AND([.E18]>1.5;[.E18]<=2.4);0.8;0)+IF(AND([.E18]>2.4;[.E18]<=3.8);0.9;0)+IF([.E18]>3.8;1;0)","v":0}]
["1. Radius:",null,{"$f":"of:=IF([.B20]=0;0;IF([.B20]<[.B17];\"min. 1 x s !\";0))","v":0},"Ausgleichswert:",{"$f":"of:=IF(AND([.B19]>0;[.B20]>0);IF([.B19]<=90;(3.141592653*((180-[.B19])/180)*([.B20]+(([.B17]/2)*[.E19])))-(2*([.B20]+[.B17]));0)+IF(AND([.B19]>90;[.B19]<=165);(3.141592653*((180-[.B19])/180)*([.B20]+(([.B17]/2)*[.E19])))-(2*([.B20]+[.B17]))*(TAN(((180/57.29577951)-([.B19]/57.29577951))/2));0);0)","v":0}]
["2. Länge:",0,{"$f":"of:=IF([.B21]<(4*[.B23]);\"min. 4 x R !\";0)","v":0},"Prop. r/s:",{"$f":"of:=IF([.B17]>0;[.B23]/[.B17];0)","v":0},{"$f":"of:=IF([.E23]=0;0;[.B18]+[.B21]+([.E23]/2))","v":0}]
["2. Winkel:",0,null,"Korrekturfaktor:",{"$f":"of:=IF(AND([.E21]>0.65;[.E21]<=1);0.6;0)+IF(AND([.E21]>1;[.E21]<=1.5);0.7;0)+IF(AND([.E21]>1.5;[.E21]<=2.4);0.8;0)+IF(AND([.E21]>2.4;[.E21]<=3.8);0.9;0)+IF([.E21]>3.8;1;0)","v":0}]
["2. Radius:",0,{"$f":"of:=IF([.B23]=0;0;IF([.B23]<[.B17];\"min. 1 x s !\";0))","v":0},"Ausgleichswert:",{"$f":"of:=IF(AND([.B22]>0;[.B23]>0);IF([.B22]<=90;(3.141592653*((180-[.B22])/180)*([.B23]+(([.B17]/2)*[.E22])))-(2*([.B23]+[.B17]));0)+IF(AND([.B22]>90;[.B22]<=165);(3.141592653*((180-[.B22])/180)*([.B23]+(([.B17]/2)*[.E22])))-(2*([.B23]+[.B17]))*(TAN(((180/57.29577951)-([.B22]/57.29577951))/2));0);0)","v":0}]
["3. Länge:",0,{"$f":"of:=IF([.B24]<(4*[.B26]);\"min. 4 x R !\";0)","v":0},"Prop. r/s:",{"$f":"of:=IF([.B17]>0;[.B26]/[.B17];0)","v":0},{"$f":"of:=IF([.E26]=0;0;[.B18]+[.B21]+[.B24]+([.E26]/2))","v":0}]
["3. Winkel:",0,null,"Korrekturfaktor:",{"$f":"of:=IF(AND([.E24]>0.65;[.E24]<=1);0.6;0)+IF(AND([.E24]>1;[.E24]<=1.5);0.7;0)+IF(AND([.E24]>1.5;[.E24]<=2.4);0.8;0)+IF(AND([.E24]>2.4;[.E24]<=3.8);0.9;0)+IF([.E24]>3.8;1;0)","v":0}]
["3. Radius:",0,{"$f":"of:=IF([.B26]=0;0;IF([.B26]<[.B17];\"min. 1 x s !\";0))","v":0},"Ausgleichswert:",{"$f":"of:=IF(AND([.B25]>0;[.B26]>0);IF([.B25]<=90;(3.141592653*((180-[.B25])/180)*([.B26]+(([.B17]/2)*[.E25])))-(2*([.B26]+[.B17]));0)+IF(AND([.B25]>90;[.B25]<=165);(3.141592653*((180-[.B25])/180)*([.B26]+(([.B17]/2)*[.E25])))-(2*([.B26]+[.B17]))*(TAN(((180/57.29577951)-([.B25]/57.29577951))/2));0);0)","v":0}]
["4. Länge:",0,{"$f":"of:=IF([.B27]<(4*[.B29]);\"min. 4 x R !\";0)","v":0},"Prop. r/s:",{"$f":"of:=IF([.B17]>0;[.B29]/[.B17];0)","v":0},{"$f":"of:=IF([.E29]=0;0;[.B18]+[.B21]+[.B24]+[.B27]+([.E29]/2))","v":0}]
["4. Winkel:",0,null,"Korrekturfaktor:",{"$f":"of:=IF(AND([.E27]>0.65;[.E27]<=1);0.6;0)+IF(AND([.E27]>1;[.E27]<=1.5);0.7;0)+IF(AND([.E27]>1.5;[.E27]<=2.4);0.8;0)+IF(AND([.E27]>2.4;[.E27]<=3.8);0.9;0)+IF([.E27]>3.8;1;0)","v":0}]
["4. Radius:",0,{"$f":"of:=IF([.B29]=0;0;IF([.B29]<[.B17];\"min. 1 x s !\";0))","v":0},"Ausgleichswert:",{"$f":"of:=IF(AND([.B28]>0;[.B29]>0);IF([.B28]<=90;(3.141592653*((180-[.B28])/180)*([.B29]+(([.B17]/2)*[.E28])))-(2*([.B29]+[.B17]));0)+IF(AND([.B28]>90;[.B28]<=165);(3.141592653*((180-[.B28])/180)*([.B29]+(([.B17]/2)*[.E28])))-(2*([.B29]+[.B17]))*(TAN(((180/57.29577951)-([.B28]/57.29577951))/2));0);0)","v":0}]
["5. Länge:",0,{"$f":"of:=IF([.B30]<(4*[.B32]);\"min. 4 x R !\";0)","v":0},"Prop. r/s:",{"$f":"of:=IF([.B17]>0;[.B32]/[.B17];0)","v":0},{"$f":"of:=IF([.E32]=0;0;[.B18]+[.B21]+[.B24]+[.B27]+[.B30]+([.E32]/2))","v":0}]
["5. Winkel:",0,null,"Korrekturfaktor:",{"$f":"of:=IF(AND([.E30]>0.65;[.E30]<=1);0.6;0)+IF(AND([.E30]>1;[.E30]<=1.5);0.7;0)+IF(AND([.E30]>1.5;[.E30]<=2.4);0.8;0)+IF(AND([.E30]>2.4;[.E30]<=3.8);0.9;0)+IF([.E30]>3.8;1;0)","v":0}]
["5. Radius:",0,{"$f":"of:=IF([.B32]=0;0;IF([.B32]<[.B17];\"min. 1 x s !\";0))","v":0},"Ausgleichswert:",{"$f":"of:=IF(AND([.B31]>0;[.B32]>0);IF([.B31]<=90;(3.141592653*((180-[.B31])/180)*([.B32]+(([.B17]/2)*[.E31])))-(2*([.B32]+[.B17]));0)+IF(AND([.B31]>90;[.B31]<=165);(3.141592653*((180-[.B31])/180)*([.B32]+(([.B17]/2)*[.E31])))-(2*([.B32]+[.B17]))*(TAN(((180/57.29577951)-([.B31]/57.29577951))/2));0);0)","v":0}]
["6. Länge:",0,{"$f":"of:=IF([.B33]<(4*[.B35]);\"min. 4 x R !\";0)","v":0},"Prop. r/s:",{"$f":"of:=IF([.B17]>0;[.B35]/[.B17];0)","v":0},{"$f":"of:=IF([.E35]=0;0;[.B18]+[.B21]+[.B24]+[.B27]+[.B30]+[.B33]+([.E35]/2))","v":0}]
["6. Winkel:",0,null,"Korrekturfaktor:",{"$f":"of:=IF(AND([.E33]>0.65;[.E33]<=1);0.6;0)+IF(AND([.E33]>1;[.E33]<=1.5);0.7;0)+IF(AND([.E33]>1.5;[.E33]<=2.4);0.8;0)+IF(AND([.E33]>2.4;[.E33]<=3.8);0.9;0)+IF([.E33]>3.8;1;0)","v":0}]
["6. Radius:",0,{"$f":"of:=IF([.B35]=0;0;IF([.B35]<[.B17];\"min. 1 x s !\";0))","v":0},"Ausgleichswert:",{"$f":"of:=IF(AND([.B34]>0;[.B35]>0);IF([.B34]<=90;(3.141592653*((180-[.B34])/180)*([.B35]+(([.B17]/2)*[.E34])))-(2*([.B35]+[.B17]));0)+IF(AND([.B34]>90;[.B34]<=165);(3.141592653*((180-[.B34])/180)*([.B35]+(([.B17]/2)*[.E34])))-(2*([.B35]+[.B17]))*(TAN(((180/57.29577951)-([.B34]/57.29577951))/2));0);0)","v":0}]
["7. Länge:",0,{"$f":"of:=IF([.B36]<(4*[.B38]);\"min. 4 x R !\";0)","v":0},"Prop. r/s:",{"$f":"of:=IF([.B17]>0;[.B38]/[.B17];0)","v":0},{"$f":"of:=IF([.E38]=0;0;[.B18]+[.B21]+[.B24]+[.B27]+[.B30]+[.B33]+[.B36]+([.E38]/2))","v":0}]
["7. Winkel:",0,null,"Korrekturfaktor:",{"$f":"of:=IF(AND([.E36]>0.65;[.E36]<=1);0.6;0)+IF(AND([.E36]>1;[.E36]<=1.5);0.7;0)+IF(AND([.E36]>1.5;[.E36]<=2.4);0.8;0)+IF(AND([.E36]>2.4;[.E36]<=3.8);0.9;0)+IF([.E36]>3.8;1;0)","v":0}]
["7. Radius:",0,{"$f":"of:=IF([.B38]=0;0;IF([.B38]<[.B17];\"min. 1 x s !\";0))","v":0},"Ausgleichswert:",{"$f":"of:=IF(AND([.B37]>0;[.B38]>0);IF([.B37]<=90;(3.141592653*((180-[.B37])/180)*([.B38]+(([.B17]/2)*[.E37])))-(2*([.B38]+[.B17]));0)+IF(AND([.B37]>90;[.B37]<=165);(3.141592653*((180-[.B37])/180)*([.B38]+(([.B17]/2)*[.E37])))-(2*([.B38]+[.B17]))*(TAN(((180/57.29577951)-([.B37]/57.29577951))/2));0);0)","v":0}]
["8. Länge:",0,{"$f":"of:=IF([.B39]<(4*[.B41]);\"min. 4 x R !\";0)","v":0},"Prop. r/s:",{"$f":"of:=IF([.B17]>0;[.B41]/[.B17];0)","v":0},{"$f":"of:=IF([.E41]=0;0;[.B18]+[.B21]+[.B24]+[.B27]+[.B30]+[.B33]+[.B36]+[.B39]+([.E41]/2))","v":0}]
["8. Winkel:",0,null,"Korrekturfaktor:",{"$f":"of:=IF(AND([.E39]>0.65;[.E39]<=1);0.6;0)+IF(AND([.E39]>1;[.E39]<=1.5);0.7;0)+IF(AND([.E39]>1.5;[.E39]<=2.4);0.8;0)+IF(AND([.E39]>2.4;[.E39]<=3.8);0.9;0)+IF([.E39]>3.8;1;0)","v":0}]
["8. Radius:",0,{"$f":"of:=IF([.B41]=0;0;IF([.B41]<[.B17];\"min. 1 x s !\";0))","v":0},"Ausgleichswert:",{"$f":"of:=IF(AND([.B40]>0;[.B41]>0);IF([.B40]<=90;(3.141592653*((180-[.B40])/180)*([.B41]+(([.B17]/2)*[.E40])))-(2*([.B41]+[.B17]));0)+IF(AND([.B40]>90;[.B40]<=165);(3.141592653*((180-[.B40])/180)*([.B41]+(([.B17]/2)*[.E40])))-(2*([.B41]+[.B17]))*(TAN(((180/57.29577951)-([.B40]/57.29577951))/2));0);0)","v":0}]
[]
[]
["Gesamtlänge der Abwicklung:",{"$nulls":4},{"$f":"of:=IF(INT(SUM([.B18];[.B21];[.B24];[.B27];[.B30];[.B33];[.B36];[.B39];[.E20];[.E23];[.E26];[.E29];[.E32];[.E35];[.E38];[.E41])+1)=1;0;INT(SUM([.B18];[.B21];[.B24];[.B27];[.B30];[.B33];[.B36];[.B39];[.E20];[.E23];[.E26];[.E29];[.E32];[.E35];[.E38];[.E41])+1))","v":0}]