{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculation","Target to be printed"],"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":"Calculation","index":0,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,27,1],[26,3,26,11],[8,1,9,1],[8,2,8,4],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[23,1,23,2]]}
["Target diameter:",null,19.685039400000001,"in","Rings:",10,"hidden constants",null,null,"(image on the next sheet has 50cm diameter + 5cm edge)"]
["Inner (black) target diameter:",null,7.8739999999999997,{"$f":"D1","v":"in"},null,"^",{"$f":"IF(D1=\"m\",100,IF(D1=\"mm\",0.1,IF(D1=\"in\",2.54,IF(D1=\"ft\",2.54*12,1))))","v":2.54}]
["Diameter of the 10 ring:",null,{"$f":"C1/F1","v":1.9685039400000002},{"$f":"D2","v":"in"},"<----------","-----^"]
["Actual (real) distance:",null,50,"m",null,null,{"$f":"IF(D4=\"m\",100,IF(D4=\"mm\",0.1,IF(D4=\"in\",2.54,IF(D4=\"ft\",2.54*12,1))))","v":100}]
["Radius viewing angle:",null,{"$f":"ATAN(((C1*$G$2)/2)/(C4*$G$4))","v":4.999958341558133E-3},"rad",{"$f":"C5*180/PI()","v":0.28647651071251157},"deg"]
["Inner radius viewing angle:",null,{"$f":"ATAN(((C2*$G$2)/2)/(C4*$G$4))","v":1.999993333355733E-3},"rad",{"$f":"C6*180/PI()","v":0.11459117705558464},"deg"]
["Radius of 10 view. angle.:",null,{"$f":"ATAN(((C3*$G$2)/2)/(C4*$G$4))","v":4.9999995909333946E-4},"rad",{"$f":"C7*180/PI()","v":2.8647887412762158E-2},"deg"]
[]
[null,{"$f":"CONCATENATE(\"DryFire  distance (\",D4,\")\")","v":"DryFire  distance (m)"},{"$f":"CONCATENATE(\"Diameter (\",D1,\") of\")","v":"Diameter (in) of"}]
[null,null,"target","inner r.","10th"]
[null,1,{"$f":"(TAN($C$5)*(B11*($G$4/$G$2)))*2","v":0.39370078800000008},{"$f":"(TAN($C$6)*(B11*($G$4/$G$2)))*2","v":0.15748000000000001},{"$f":"(TAN($C$7)*(B11*($G$4/$G$2)))*2","v":3.9370078800000007E-2}]
[null,2,{"$f":"(TAN($C$5)*(B12*($G$4/$G$2)))*2","v":0.78740157600000016},{"$f":"(TAN($C$6)*(B12*($G$4/$G$2)))*2","v":0.31496000000000002},{"$f":"(TAN($C$7)*(B12*($G$4/$G$2)))*2","v":7.8740157600000013E-2}]
[null,3,1.1811023640000002,0.47244000000000003,0.11811023640000001]
[null,4,1.5748031520000003,0.62992000000000004,0.15748031520000003]
[null,4.5,1.7716535460000005,0.70866000000000007,0.17716535460000002]
[null,5,1.9685039400000004,0.78739999999999999,0.19685039400000001]
[null,5.5,2.1653543340000003,0.86613999999999991,0.2165354334]
[null,6,2.3622047280000005,0.94488000000000005,0.23622047280000003]
[null,7,2.7559055160000003,1.10236,0.27559055160000001]
[null,8,3.1496063040000006,1.2598400000000001,0.31496063040000005]
[null,9,3.5433070920000009,1.4173200000000001,0.35433070920000004]
[null,10,3.9370078800000008,1.5748,0.39370078800000002]
[]
[null,"PRINTED TARGET"]
[null,{"$f":"CONCATENATE(\"dryfire dist. (\",D4,\")\")","v":"dryfire dist. (m)"},"size (cm)"]
[null,50,{"$f":"(TAN($C$5)*(B26*($G$4/$G$2)))*2*$G$2","v":50.000000076000013}]
[null,null,null,"WARNING!!! Once you have resized the target, do not save the file!"]
["© Lukas Plachy 28. 7. 2014",null,"http://lukas.plachy.eu"]

{"sheet":"Target to be printed","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}