{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["OUSim","IEKF","KFSim","KF2Sim","ArtillerySim"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":1,"defined_names":31,"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":"OUSim","index":0,"n_rows":242,"n_cols":9,"rows_kept":242,"cut":false,"hidden":false,"merged":[]}
["Time","X",null,null,null,null,null,"std deviation, s",5]
[0,{"$f":"stddev*NORMSINV(RAND())","v":2.0900467925853885},null,null,null,null,null,"time const, tau",1]
[{"$f":"A2+delta","v":0.1},{"$f":"shrinkfact*B2 + SQRT(noisevar)* NORMSINV(RAND())","v":1.7429452874857474},null,null,null,null,null,"time btwn meas,Δ",0.1]
[0.2,3.3062929355593185]
[0.30000000000000004,2.2807906955526751,null,null,null,null,null,"c = exp(-Δ/tau) =",{"$f":"EXP(-delta/tau)","v":0.90483741803595952}]
[0.4,5.1013033327628587,null,null,null,null,null,"q =s^2(1-c^2) =",{"$f":"stddev^2*(1-shrinkfact^2)","v":4.5317311730504573}]
[0.5,3.2666029684031099]
[0.6,4.485089465050506]
[0.7,0.7549605827458179]
[0.79999999999999993,1.22957530557035]
[0.89999999999999991,3.144727368974678]
[0.99999999999999989,-1.6437200476627756]
[1.0999999999999999,5.1575297669891551E-2]
[1.2,-0.76546485176121748]
[1.3,-1.5118681291807698]
[1.4000000000000001,-2.1606215162807536]
[1.5000000000000002,-1.6518233967134608]
[1.6000000000000003,0.47660110627626162]
[1.7000000000000004,-3.7201650837278493]
[1.8000000000000005,-4.1673445335909429]
[1.9000000000000006,-2.7473030904732614]
[2.0000000000000004,-6.5614052651434527]
[2.1000000000000005,-3.5644179905179612]
[2.2000000000000006,-8.6518618915850567]
[2.3000000000000007,-8.6907076331672499]
[2.4000000000000008,-9.3549736791599436]
[2.5000000000000009,-7.1811229179433509]
[2.600000000000001,-9.3237138213877806]
[2.7000000000000011,-7.018349720031023]
[2.8000000000000012,-7.3229539406985866]
[2.9000000000000012,-8.2108192216617226]
[3.0000000000000013,-4.4601038393821906]
[3.1000000000000014,-3.8401971881568211]
[3.2000000000000015,-5.2435526798421144]
[3.3000000000000016,-3.1506918840844107]
[3.4000000000000017,-3.7455970512874535]
[3.5000000000000018,-0.48668052122705774]
[3.6000000000000019,-0.24149221897137871]
[3.700000000000002,-0.19381678385180026]
[3.800000000000002,2.8150492250676304]
[3.9000000000000021,1.2161164418514767]
[4.0000000000000018,0.57458344368706271]
[4.1000000000000014,1.624414996488045]
[4.2000000000000011,2.9638355562909426]
[4.3000000000000007,2.6872259572178283]
[4.4000000000000004,2.7267769033247689]
[4.5,4.2367473933385513]
[4.5999999999999996,4.8433007358667837]
[4.6999999999999993,3.9489979333966283]
[4.7999999999999989,9.598733850461473]
[4.8999999999999986,9.5175695287285986]
[4.9999999999999982,9.9516254177034771]
[5.0999999999999979,8.6064927902603809]
[5.1999999999999975,8.426859471238858]
[5.2999999999999972,5.423651574047442]
[5.3999999999999968,7.6009086103030246]
[5.4999999999999964,7.9733276331495926]
[5.5999999999999961,8.7131395198228265]
[5.6999999999999957,11.656274490784972]
[5.7999999999999954,9.4446427632225909]
[5.899999999999995,9.1738529838213942]
[5.9999999999999947,6.6056994233734914]
[6.0999999999999943,4.3832311345092192]
[6.199999999999994,6.2460010066018992]
[6.2999999999999936,7.0719674354952309]
[6.3999999999999932,7.9867975103383646]
[{"$f":"A66+delta","v":6.4999999999999929},{"$f":"shrinkfact*B66 + SQRT(noisevar)* NORMSINV(RAND())","v":7.617031098164329}]
[6.5999999999999925,6.9495485809331399]
[6.6999999999999922,6.0643295643584434]
[6.7999999999999918,4.0660949750749733]
[6.8999999999999915,3.211849454145332]
[6.9999999999999911,1.0262123411935415]
[7.0999999999999908,2.0163151231755454]
[7.1999999999999904,1.9919286122183446]
[7.2999999999999901,1.1567461046562657]
[7.3999999999999897,1.8094925825042778]
[7.4999999999999893,-0.61935848241193403]
[7.599999999999989,0.36874521543748739]
[7.6999999999999886,-0.74201625519538816]
[7.7999999999999883,-2.5930766840757045]
[7.8999999999999879,1.8325090731518028]
[7.9999999999999876,-0.43634774066478199]
[8.0999999999999872,1.8907742692303351]
[8.1999999999999869,1.1933096189810055]
[8.2999999999999865,4.6269165658812739]
[8.3999999999999861,2.7965914978342967]
[8.4999999999999858,1.5869331163657519]
[8.5999999999999854,4.1230525257857717]
[8.6999999999999851,4.8519980614284615]
[8.7999999999999847,4.5865447202457519]
[8.8999999999999844,6.6830701312065486]
[8.999999999999984,3.1410358618163023]
[9.0999999999999837,-0.67705655128625253]
[9.1999999999999833,-3.0495524799776574]
[9.2999999999999829,-4.527623463497668]
[9.3999999999999826,-5.0923033717129833]
[9.4999999999999822,-2.6990091214202416]
[9.5999999999999819,0.59709213350874846]
[9.6999999999999815,0.45970357681576068]
[9.7999999999999812,0.99431719746947522]
[9.8999999999999808,-0.95235896412765952]
[9.9999999999999805,-0.50984082195223279]
[10.09999999999998,-0.50732371265811549]
[10.19999999999998,2.8635093811997829]
[10.299999999999979,3.1893417765017666]
[10.399999999999979,4.01176342249647]
[10.499999999999979,5.9066844163645129]
[10.599999999999978,5.1993200748916086]
[10.699999999999978,5.7750507795707149]
[10.799999999999978,0.42998747602923171]
[10.899999999999977,-2.1856565166692965]
[10.999999999999977,-0.30481754324138932]
[11.099999999999977,0.10532655377993655]
[11.199999999999976,2.0547515059937593]
[11.299999999999976,2.326683591684537]
[11.399999999999975,9.460730601442302E-2]
[11.499999999999975,1.8135026569128561]
[11.599999999999975,6.0923823813391582]
[11.699999999999974,5.940810559340691]
[11.799999999999974,4.3437012056361466]
[11.899999999999974,6.2554747751274622]
[11.999999999999973,3.8894175500203874]
[12.099999999999973,2.8464008950821942]
[12.199999999999973,2.4486429552871596]
[12.299999999999972,1.6122976842157239]
[12.399999999999972,3.9163830723116462]
[12.499999999999972,5.0888904288973427]
[12.599999999999971,6.0870774721065626]
[12.699999999999971,3.6488222695954509]
[12.799999999999971,-0.50840326413594639]
[{"$f":"A130+delta","v":12.89999999999997},{"$f":"shrinkfact*B130 + SQRT(noisevar)* NORMSINV(RAND())","v":-1.9732157176412817}]
[12.99999999999997,-2.9858193125133585]
[13.099999999999969,-2.8451908446651917]
[13.199999999999969,-4.8609762618256251]
[13.299999999999969,-0.948254870095941]
[13.399999999999968,-0.1953082661546931]
[13.499999999999968,-1.7793573483625713]
[13.599999999999968,-7.3810056129556454]
[13.699999999999967,-5.3365209545006467]
[13.799999999999967,-7.2971095565232993]
[13.899999999999967,-5.336604308267578]
[13.999999999999966,-3.4385218341574832]
[14.099999999999966,-3.4516332909347591]
[14.199999999999966,-3.2014173799742247]
[14.299999999999965,-1.3315294916317844]
[14.399999999999965,-1.8714500280915809]
[14.499999999999964,-1.9483474792305346]
[14.599999999999964,-0.45358248836700787]
[14.699999999999964,1.1303512443921804E-2]
[14.799999999999963,-2.4610112646756206]
[14.899999999999963,-1.2020129135036053]
[14.999999999999963,0.64956087622577408]
[15.099999999999962,-1.167954962228904]
[15.199999999999962,-3.0580990414649416]
[15.299999999999962,-5.5518581838209844]
[15.399999999999961,-7.0297522450497141]
[15.499999999999961,-4.6956026863326752]
[15.599999999999961,-7.8949870890665945]
[15.69999999999996,-8.8886039155069732]
[15.79999999999996,-8.7042936348133839]
[15.899999999999959,-6.2906514085225327]
[15.999999999999959,-4.4771337820133423]
[16.099999999999959,-5.0955592077449952]
[16.19999999999996,-5.3439708492529725]
[16.299999999999962,-5.5624841434599848]
[16.399999999999963,-2.1627507369094596]
[16.499999999999964,-3.3814458322320249]
[16.599999999999966,-3.6940262532630546]
[16.699999999999967,-5.583022382630709]
[16.799999999999969,-6.0222611091885394]
[16.89999999999997,-5.1198357941311921]
[16.999999999999972,-3.6268607295428335]
[17.099999999999973,-5.7847803939127491]
[17.199999999999974,-9.279279626692432]
[17.299999999999976,-6.8831718700926583]
[17.399999999999977,-8.3417047344143711]
[17.499999999999979,-7.1926555350145991]
[17.59999999999998,-7.6763035597602753]
[17.699999999999982,-8.5005997794578239]
[17.799999999999983,-11.024125150364018]
[17.899999999999984,-9.760818293296472]
[17.999999999999986,-10.290450241782601]
[18.099999999999987,-9.925425043373048]
[18.199999999999989,-11.252248738500377]
[18.29999999999999,-12.723662445661468]
[18.399999999999991,-9.8111788477713144]
[18.499999999999993,-11.09822078635535]
[18.599999999999994,-11.410673957065868]
[18.699999999999996,-12.972623433361456]
[18.799999999999997,-11.987121651610945]
[18.899999999999999,-9.9741407409648097]
[19,-7.7122205455924231]
[19.100000000000001,-7.0893103657005483]
[19.200000000000003,-7.1315426264764197]
[{"$f":"A194+delta","v":19.300000000000004},{"$f":"shrinkfact*B194 + SQRT(noisevar)* NORMSINV(RAND())","v":-5.7298848786624799}]
[19.400000000000006,-3.5517922620123903]
[19.500000000000007,-3.8068899972585655]
[19.600000000000009,-1.0806057267081215]
[19.70000000000001,-2.7731406310151234]
[19.800000000000011,-1.7727205950239537]
[19.900000000000013,-3.8236723170752596]
[20.000000000000014,-2.4515367978173486]
[20.100000000000016,-1.5422002378344661]
[20.200000000000017,-1.0190978138362616]
[20.300000000000018,-3.8212209448454431]
[20.40000000000002,-1.7149946489788659]
[20.500000000000021,-1.9814576980312251]
[20.600000000000023,-6.1358905120135026]
[20.700000000000024,-5.5412950486578465]
[20.800000000000026,-3.414214363854347]
[20.900000000000027,-4.8064632434962187]
[21.000000000000028,-6.4083173761504693]
[21.10000000000003,-4.1173954140753333]
[21.200000000000031,-2.9175943129974398]
[21.300000000000033,-2.0902057779872254]
[21.400000000000034,-4.4375992729550564]
[21.500000000000036,-5.9101753083281094]
[21.600000000000037,-3.5909648051676406]
[21.700000000000038,-7.3018097130187094]
[21.80000000000004,-6.5662032036574338]
[21.900000000000041,-5.5141067328788278]
[22.000000000000043,-9.70733658397344]
[22.100000000000044,-10.194670919446912]
[22.200000000000045,-12.646366063711362]
[22.300000000000047,-11.0954931834788]
[22.400000000000048,-13.801628428422974]
[22.50000000000005,-15.183476172149719]
[22.600000000000051,-17.399477481123139]
[22.700000000000053,-18.452645656322574]
[22.800000000000054,-17.92449420994749]
[22.900000000000055,-16.109464399078934]
[23.000000000000057,-18.169379369942863]
[23.100000000000058,-18.20844675029231]
[23.20000000000006,-19.913887854070747]
[23.300000000000061,-18.377291946828006]
[23.400000000000063,-18.618441809787473]
[23.500000000000064,-14.908358029917299]
[23.600000000000065,-12.82459413282408]
[23.700000000000067,-14.436733453937105]
[23.800000000000068,-12.750867630033056]
[23.90000000000007,-8.4395208102295243]
[24.000000000000071,-9.3915335241532922]

{"sheet":"IEKF","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["H","K","mu(+)","sig(+)",null,null,null,"mu(-)",1]
[null,null,{"$f":"mu","v":1},{"$f":"sigma","v":0.5},null,null,null,"sig(-)",0.5]
[{"$f":"COS(C2)","v":0.54030230586813977},{"$f":"A3*sigma/(A3*A3*sigma+$I$4)","v":1.5352699509585364},{"$f":"mu+B3*($I$5-SIN(mu)-$I$3)","v":0.47574985790021762},{"$f":"(1-A3*B3)*sigma","v":8.5245052683518452E-2},null,null,null,"muV",0.1]
[{"$f":"COS(C3)","v":0.88894953278881716},1.0455385049050496,0.64297893707549703,3.5284517275968874E-2,null,null,null,"R",0.03]
[{"$f":"COS(C4)","v":0.800313193951116},1.1424865287029473,0.60987399991404945,4.2826478583810446E-2,null,null,null,"Z",0.6]
[0.81972019268812468,1.1199262988215033,0.61757766382915869,4.0986899266769516E-2]
[0.81528352997076436,1.1250143392190235,0.61584024566387519,4.1397169126893785E-2]
[0.81628837173505375,1.1238584030892858,0.6162349643124716,4.1303727040744642E-2]
[0.8160603010515769,1.124120584217531,0.61614543706441172,4.132490881258355E-2]
[0.81611204155531336,1.1240610959052364,0.61616575059699552,4.1320102093937328E-2]
[0.81610030232430386,1.1240745925240767,0.61616114189326854,4.1321192603016144E-2]
[0.8161029657329173,1.12407153037248,0.61616218752918994,4.1320945183540014E-2]
[0.81610236145265147,1.1240722251191804,0.61616195029334997,4.1321001318450234E-2]

{"sheet":"KFSim","index":2,"n_rows":101,"n_cols":16,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["time","mu(-)","sig(-)","Err(-)","X (truth)","z","d_shock","k-gain","mu(+)","sig(+)","Err(+)",null,"R (or rr)",1,{"$f":"SQRT(N1)","v":1},"sqrt(R)"]
[1,1,100,{"$f":"(E2-B2)*(E2-B2)/C2","v":0.29326163848807912},{"$f":"B2+SQRT(C2)*NORMSINV(RAND())","v":6.4153636857378205},{"$f":"m_func(E2)+sqt_r*NORMSINV(RAND())","v":18.005596612634967},{"$f":"(F2-m_func(B2))*(F2-m_func(B2))/(C2*d_func(B2)*d_func(B2)+rr)","v":0.30205276009985604},{"$f":"C2*d_func(B2)/(C2*d_func(B2)*d_func(B2)+rr)","v":0.49875311720698257},{"$f":"B2+H2*(F2-m_func(B2))","v":6.489075617274298},{"$f":"(1-H2*d_func(B2))*C2","v":0.24937655860348684},{"$f":"(E2-I2)*(E2-I2)/J2","v":2.1788129891862212E-2},null,"Q (or qq)",1,{"$f":"SQRT(N2)","v":1},"sqrt(Q)"]
[{"$f":"A2+1","v":2},{"$f":"I2+mu_w","v":6.5890756172742977},{"$f":"J2+qq","v":1.2493765586034868},{"$f":"(E3-B3)*(E3-B3)/C3","v":0.39191040293329399},{"$f":"E2+mu_w+sqt_q*NORMSINV(RAND())","v":5.8893301846363242},{"$f":"m_func(E3)+sqt_r*NORMSINV(RAND())","v":16.986185499704572},{"$f":"(F3-m_func(B3))*(F3-m_func(B3))/(C3*d_func(B3)*d_func(B3)+rr)","v":0.23689551248646298},{"$f":"C3*d_func(B3)/(C3*d_func(B3)*d_func(B3)+rr)","v":0.41663201663201638},{"$f":"B3+H3*(F3-m_func(B3))","v":6.0924645294099697},{"$f":"(1-H3*d_func(B3))*C3","v":0.20831600831600822},{"$f":"(E3-I3)*(E3-I3)/J3","v":0.19808157020761888},null,"mu_W",0.1]
[{"$f":"A3+1","v":3},{"$f":"I3+mu_w","v":6.1924645294099694},{"$f":"J3+qq","v":1.2083160083160083},0.24321139923600651,{"$f":"E3+mu_w+sqt_q*NORMSINV(RAND())","v":6.7345680500605942},17.188870888155162,{"$f":"(F4-m_func(B4))*(F4-m_func(B4))/(C4*d_func(B4)*d_func(B4)+rr)","v":6.5895879331404617E-3},{"$f":"C4*d_func(B4)/(C4*d_func(B4)*d_func(B4)+rr)","v":0.41428469598688433},{"$f":"B4+H4*(F4-m_func(B4))","v":6.1112406297803679},0.20714234799344208,{"$f":"(E4-I4)*(E4-I4)/J4","v":1.87570082427328}]
[4,6.2112406297803675,1.207142347993442,0.74695999097587662,7.1608126583088936,18.868598439567172,0.35879385792155771,0.41421565630006479,6.8102450065835338,0.20710782815003242,0.59339948438454948]
[5,6.9102450065835335,1.2071078281500325,0.35292328400705641,6.257545643276555,16.961287071583559,0.59306447869087509,0.41421362401250567,6.1401378183755178,0.20710681200625278,6.6557913834222215E-2]
[6,6.2401378183755174,1.2071068120062527,4.0138576656954854E-4,6.2621495310092143,18.518246655027003,0.18484983837551142,0.41421356418758981,6.6700794933790277,0.20710678209379499,0.80348336503859463]
[7,6.7700794933790274,1.2071067820937951,0.6132832945955069,5.9096735285862074,16.385899221815123,0.79624142716968727,0.41421356242650881,5.8777558817499225,0.20710678121325438,4.9188934017415642E-3]
[8,5.9777558817499221,1.2071067812132543,1.056382334482727,4.8485232752830401,15.232695880169963,0.50924451902254197,0.41421356237466739,5.2641421774001937,0.20710678118733372,0.83405801976527749]
[9,5.3641421774001934,1.2071067811873337,1.004765578792937,4.2628432426578726,13.625507109683547,0.75863900293191577,0.41421356237314133,4.4931433238231664,0.20710678118657069,0.25609073291019802]
[10,4.593143323823166,1.2071067811865708,0.46330047078067416,3.8453110297850692,12.805786197186025,0.32698041048322629,0.41421356237309642,4.0213213143803381,0.20710678118654821,0.14958283889025895]
[11,4.1213213143803378,1.2071067811865481,0.13562020429666072,3.7167127773072748,14.015592971239325,0.10250659726038504,0.41421356237309509,4.441487829275923,0.20710678118654752,2.5363673412653918]
[12,4.5414878292759226,1.2071067811865475,0.1664363101764435,4.0932619948468343,13.664796554623658,3.0003594317874711E-2,0.41421356237309503,4.3682723729278399,0.20710678118654754,0.36517736222328084]
[13,4.4682723729278395,1.2071067811865475,3.9548058620806494,6.6531918163842478,18.298814455980409,3.2649283617319598,0.41421356237309503,6.2751836495908524,0.20710678118654754,0.68993479278593883]
[14,6.375183649590852,1.2071067811865475,0.68365510725460665,7.2836134575341251,20.579588419480807,1.3733537327010983,0.41421356237309503,7.5470854085711423,0.20710678118654754,0.335177190169963]
[15,7.6470854085711419,1.2071067811865475,3.3579425078737832E-2,7.8484158626035363,21.890245077360866,0.43707384335584859,0.41421356237309503,8.3082010137082829,0.20710678118654754,1.0207410108218424]
[16,8.4082010137082825,1.2071067811865475,0.51579401747874454,7.619139256813396,21.344980327660913,3.8130084539778106E-2,0.41421356237309503,8.2129317520725138,0.20710678118654754,1.7024528381253776]
[17,8.3129317520725134,1.2071067811865475,2.9156239997065652,6.4369068318126468,16.384238823953577,4.7139011434733433,0.41421356237309503,6.1417797206676781,0.20710678118654754,0.42055605921624079]
[18,6.2417797206676777,1.2071067811865475,3.7590717392122439,8.3719442653378326,21.127912105898634,2.2787119165168988,0.41421356237309503,7.7513200204003141,0.20710678118654754,1.8597867785764406]
[19,7.8513200204003137,1.2071067811865475,0.78336888025087026,8.8237447668569935,22.643646097883902,0.64640158193588537,0.41421356237309503,8.6553110538925324,0.20710678118654754,0.13698207031396425]
[20,8.7553110538925321,1.2071067811865475,0.6653688050042601,7.8591128634733414,20.942646510898978,0.42182005879284973,0.41421356237309503,8.1058342961922669,0.20710678118654754,0.29391343448117463]
[21,8.2058342961922666,1.2071067811865475,0.18551346916724043,7.7326170452036562,19.441919006593668,0.66568790304506764,0.41421356237309503,7.389937303278904,0.20710678118654754,0.56699932688269861]
[22,7.4899373032789036,1.2071067811865475,3.6100566228066722,9.5774534900083239,24.887092199006542,4.131609434970331,0.41421356237309503,9.5225733835870159,0.20710678118654754,1.4542382743620784E-2]
[23,9.6225733835870155,1.2071067811865475,2.0202517494360837E-2,9.7787354656187393,25.298703706314981,0.19044284165436562,0.41421356237309503,10.058970956511482,0.20710678118654754,0.37918570268908919]
[24,10.158970956511482,1.2071067811865475,0.35797436365286411,10.816324196296843,29.193330086457486,2.5767901310853536,0.41421356237309503,11.764209297408357,0.20710678118654754,4.3382749698566805]
[25,11.864209297408356,1.2071067811865475,0.4247116482355841,11.148197907391348,28.327366767890403,2.7596221834537339E-2,0.41421356237309503,11.698088191480972,0.20710678118654754,1.4600165325528631]
[26,11.798088191480971,1.2071067811865475,1.8910582563421854,10.287224450156341,25.577217993014976,1.563734016941676,0.41421356237309503,10.547594682124895,0.20710678118654754,0.32733190727490452]
[27,10.647594682124895,1.2071067811865475,0.83471014032575497,9.6438097097765372,25.610205274197625,8.0502542724170151E-2,0.41421356237309503,10.363864982015494,0.20710678118654754,2.5034409405074372]
[28,10.463864982015494,1.2071067811865475,0.886397236746019,11.498261480124965,25.060853758509314,0.12893261588689414,0.41421356237309503,10.104793100789889,0.20710678118654754,9.3756182829075208]
[29,10.204793100789889,1.2071067811865475,8.8120295446510717,13.466243793252449,31.480339417785597,6.323154398825598,0.41421356237309503,12.719381416762426,0.20710678118654754,2.6933131123016896]
[30,12.819381416762425,1.2071067811865475,1.8916237679177623,14.330471049347858,34.119454454802366,2.0786421281640499,0.41421356237309503,14.261131092733969,0.20710678118654754,2.3215220456182763E-2]
[31,14.361131092733968,1.2071067811865475,0.1426095057663983,13.946227608207408,31.095167580270342,1.1841318278400659,0.41421356237309503,13.272952877623931,0.20710678118654754,2.1887205249641424]
[32,13.372952877623931,1.2071067811865475,6.6856759787164138E-3,13.283117891061208,31.585893662297849,4.3929295746934997E-3,0.41421356237309503,13.306673698580331,0.20710678118654754,2.6791786570146336E-3]
[33,13.406673698580331,1.2071067811865475,1.6482744170711015E-2,13.265618984866013,31.750473003156234,6.7826007545667138E-4,0.41421356237309503,13.380630271857708,0.20710678118654754,6.3868483975768928E-2]
[34,13.480630271857708,1.2071067811865475,0.86920494279827853,12.4563143144048,29.560576340001816,0.9888233176134924,0.41421356237309503,12.486234315704682,0.20710678118654754,4.3224392395852188E-3]
[35,12.586234315704681,1.2071067811865475,0.67134388427745995,11.686021143606295,27.537830833204527,1.1909416003947884,0.41421356237309503,11.494931607747448,0.20710678118654754,0.1763110338809194]
[36,11.594931607747448,1.2071067811865475,5.7800016548593725,14.236347741727517,34.132809939963622,6.0597164576217599,0.41421356237309503,14.056580741483156,0.20710678118654754,0.15603629292923971]
[37,14.156580741483156,1.2071067811865475,1.3696994409966499,15.442416455489607,36.404697858291549,1.6398244252518352,0.41421356237309503,15.437137036712629,0.20710678118654754,1.3457918887549905E-4]
[38,15.537137036712629,1.2071067811865475,4.1138324936774611,17.765552415358098,41.112169473394999,4.3545864978352151,0.41421356237309503,17.623901637197125,0.20710678118654754,9.6882114813690676E-2]
[39,17.723901637197127,1.2071067811865475,0.4217297521016386,18.437395045428772,42.534797386736621,0.74729328028466613,0.41421356237309503,18.588362903122135,0.20710678118654754,0.1100461024305848]
[40,18.688362903122137,1.2071067811865475,0.38897821924819931,18.003134294416714,40.486000401584654,0.61334601588262194,0.41421356237309503,17.905198797788763,0.20710678118654754,4.6311190028703778E-2]
[41,18.005198797788765,1.2071067811865475,2.1280236192481286,19.607931383505907,43.432536431867483,1.0065762883703429,0.41421356237309503,19.00848155373065,0.20710678118654754,1.7350474782084273]
[42,19.108481553730652,1.2071067811865475,1.2731913910470223,20.348190375140419,47.946859766492949,3.8384150520013494,0.41421356237309503,21.067668898524751,0.20710678118654754,2.4994321414567096]
[43,21.167668898524752,1.2071067811865475,2.046330832438038E-2,21.324835683323165,47.730728182332243,2.6822597834375409E-2,0.41421356237309503,21.331444958540786,0.20710678118654754,2.109178591448637E-4]
[44,21.431444958540787,1.2071067811865475,2.3105527663386103,23.101500021266766,51.296645910728827,2.022960907214205,0.41421356237309503,22.853753260989382,0.20710678118654754,0.29636140775445607]
[45,22.953753260989384,1.2071067811865475,0.37968098977400638,23.630743288570162,51.000051086889023,1.4694352886502767E-3,0.41421356237309503,22.992086474899128,0.20710678118654754,1.9694310505508994]
[46,23.09208647489913,1.2071067811865475,0.29306922056525353,23.686868656459215,55.436246691997091,3.1020600793535889,0.41421356237309503,24.853353087128404,0.20710678118654754,6.5699728381564269]
[47,24.953353087128406,1.2071067811865475,6.5783951598166981,22.135406067268114,50.251627295505109,3.7179429207230337,0.41421356237309503,23.02515628163291,0.20710678118654754,3.8224506190800716]
[48,23.125156281632911,1.2071067811865475,0.59089155842567709,22.28060361476037,50.073250133397821,0.23771009470537011,0.41421356237309503,22.637601059421755,0.20710678118654754,0.61536939913117994]
[49,22.737601059421756,1.2071067811865475,0.25160525270713674,23.28870395972708,49.88601031007817,5.9561006783848715E-2,0.41421356237309503,22.493549821392016,0.20710678118654754,3.052870118926108]
[50,22.593549821392017,1.2071067811865475,3.0843593510119085,24.523096682243708,53.998981193198524,2.4930295332504713,0.41421356237309503,24.172482857733481,0.20710678118654754,0.59355880687924401]
[51,24.272482857733483,1.2071067811865475,1.7304277897520634E-2,24.417010056535762,54.394832437523412,0.12392253172255681,0.41421356237309503,24.62450918021883,0.20710678118654754,0.20789220943209594]
[52,24.724509180218831,1.2071067811865475,3.5291791375339075E-2,24.930909181888872,56.595725845451561,0.79066837889225161,0.41421356237309503,25.613704534959425,0.20710678118654754,2.2510585674875196]
[53,25.713704534959426,1.2071067811865475,4.0134620732810763E-3,25.78330825098589,57.574829705463316,0.22588840637354518,0.41421356237309503,26.1889817239487,0.20710678118654754,0.79461891939440588]
[54,26.288981723948702,1.2071067811865475,0.43672803109123309,25.562911914726147,55.477836767200451,0.75672766950264725,0.41421356237309503,25.419080770102433,0.20710678118654754,9.9887594434361168E-2]
[55,25.519080770102434,1.2071067811865475,0.87761694369268783,24.489820179185024,53.828663581882452,0.83759839890655163,0.41421356237309503,24.603876749729626,0.20710678118654754,6.2812531824721546E-2]
[56,24.703876749729627,1.2071067811865475,4.4461223507950898,22.387210084102087,49.059339825796478,4.9079328285962971,0.41421356237309503,22.488491268916796,0.20710678118654754,4.9529418296698595E-2]
[57,22.588491268916798,1.2071067811865475,0.73616674843757368,21.645818539851696,47.863716514383803,0.91812071777087567,0.41421356237309503,21.630305108627017,0.20710678118654754,1.1620408901342645E-3]
[58,21.730305108627018,1.2071067811865475,4.648757842343379E-2,21.493418065596234,47.150908475252244,0.2943021532721361,0.41421356237309503,21.187808884426207,0.20710678118654754,0.45096047111701676]
[59,21.287808884426209,1.2071067811865475,0.14815639007955636,20.864913408993861,45.107066066189489,1.0455217811418389,0.41421356237309503,20.265301289764029,0.20710678118654754,1.7359870665144757]
[60,20.36530128976403,1.2071067811865475,0.49381524206766214,21.137368467769384,46.715487209990151,0.1664253004386135,0.41421356237309503,20.773253861074242,0.20710678118654754,0.64015019715525445]
[61,20.873253861074243,1.2071067811865475,2.1770007164718705E-2,21.035360996250372,46.419568038836609,1.8339348547439467E-2,0.41421356237309503,20.737831010168499,0.20710678118654754,0.42743212998971342]
[62,20.8378310101685,1.2071067811865475,0.82441147227691014,21.835404405299627,50.939155701813434,3.1187450718586516,0.41421356237309503,22.603827916128036,0.20710678118654754,2.8510640192992969]
[63,22.703827916128038,1.2071067811865475,1.6604933148897603,21.288062137293714,47.915068626488356,1.0659807260826797,0.41421356237309503,21.671364490101393,0.20710678118654754,0.70939586249262454]
[64,21.771364490101394,1.2071067811865475,0.20023190674134145,21.279733233530592,48.062279707930031,3.9604424707887914E-2,0.41421356237309503,21.572355885493735,0.20710678118654754,0.41344863722648822]
[65,21.672355885493737,1.2071067811865475,2.0574593181520036,20.096420260235924,46.664834991661053,0.48417625086853866,0.41421356237309503,20.976528140381099,0.20710678118654754,3.7400507904950571]
[66,21.0765281403811,1.2071067811865475,{"$f":"(E67-B67)*(E67-B67)/C67","v":8.0111346881241441E-3},20.978190482248351,{"$f":"m_func(E67)+sqt_r*NORMSINV(RAND())","v":46.5452831722057},6.3376987234873866E-2,0.41421356237309503,20.824780275971342,{"$f":"(1-H67*d_func(B67))*C67","v":0.20710678118654754},0.11363554227978645]
[{"$f":"A67+1","v":67},{"$f":"I67+mu_w","v":20.924780275971344},{"$f":"J67+qq","v":1.2071067811865475},3.4096968182346101,{"$f":"E67+mu_w+sqt_q*NORMSINV(RAND())","v":22.953540525749812},50.967358704162606,{"$f":"(F68-m_func(B68))*(F68-m_func(B68))/(C68*d_func(B68)*d_func(B68)+rr)","v":2.9092345601154226},{"$f":"C68*d_func(B68)/(C68*d_func(B68)*d_func(B68)+rr)","v":0.41421356237309503},{"$f":"B68+H68*(F68-m_func(B68))","v":22.630428117735704},0.20710678118654754,{"$f":"(E68-I68)*(E68-I68)/J68","v":0.50409565352974861}]
[68,22.730428117735705,1.2071067811865475,0.22889404146294023,23.256070153367475,52.762027518908937,0.90854516362304316,0.41421356237309503,23.683604472679029,0.20710678118654754,0.88256692099595546]
[69,23.783604472679031,1.2071067811865475,1.1467880241515314,22.607043551801222,50.81037964890978,0.52955095959844689,0.41421356237309503,23.055901951315771,0.20710678118654754,0.97280186414219172]
[70,23.155901951315773,1.2071067811865475,0.52372948940157671,23.951010383018023,51.676117231016768,2.2771872822360886E-2,0.41421356237309503,23.306805472886214,0.20710678118654754,2.0037970937519805]
[71,23.406805472886216,1.2071067811865475,2.0984777754368276,24.998372861625711,56.21120103693864,3.3180132814589087,0.41421356237309503,25.228346930404793,0.20710678118654754,0.25536620292103401]
[72,25.328346930404795,1.2071067811865475,2.8757428352793939,23.465196727813929,51.906010653411897,2.4136227872743015,0.41421356237309503,23.774763077735649,0.20710678118654754,0.46271456904899072]
[73,23.874763077735651,1.2071067811865475,2.9762116277875419E-2,24.064304768087631,51.804108568622638,0.15335430887139589,0.41421356237309503,23.48315829115689,0.20710678118654754,1.6307106204543189]
[74,23.583158291156892,1.2071067811865475,0.60421835012508573,22.729134832607105,51.069959807964104,0.20623028321981082,0.41421356237309503,23.129032446021636,0.20710678118654754,0.77215289764266271]
[75,23.229032446021638,1.2071067811865475,0.19299021427419216,22.746373356857223,51.311694924693789,3.6758059907667632E-3,0.41421356237309503,23.168404020421374,0.20710678118654754,0.85999058054969324]
[76,23.268404020421375,1.2071067811865475,0.1993724492395853,23.758979025348118,52.087167799659525,5.1968714310389345E-2,0.41421356237309503,23.496370496707669,0.20710678118654754,0.33298397531746748]
[77,23.596370496707671,1.2071067811865475,2.8479006418437845E-2,23.781781396519822,54.086267918368726,0.61516497311949425,0.41421356237309503,24.380695029741986,0.20710678118654754,1.731944932002409]
[78,24.480695029741987,1.2071067811865475,1.7704727509586979,23.018795695455168,52.093129256993073,0.59885769375145848,0.41421356237309503,23.706836067300213,0.20710678118654754,2.2857752439417296]
[79,23.806836067300214,1.2071067811865475,1.7584285218185055E-3,23.760764264720773,51.572996714457965,0.18581433839851844,0.41421356237309503,23.375774194248887,0.20710678118654754,0.71565669415934752]
[80,23.475774194248888,1.2071067811865475,9.1310299450510585E-2,23.14377828816135,51.165484131661778,0.10601436762444538,0.41421356237309503,23.15017571817069,0.20710678118654754,1.9761357155919669E-4]
[81,23.250175718170691,1.2071067811865475,0.17405984924628828,23.708552009396037,51.766779608724711,1.2178924008183715E-2,0.41421356237309503,23.360533880570141,0.20710678118654754,0.58480276356757266]
[82,23.460533880570143,1.2071067811865475,0.30766377722511673,22.851121842771491,51.767207740104993,4.0616285605546689E-3,0.41421356237309503,23.396802973150315,0.20710678118654754,1.4377505861737214]
[83,23.496802973150317,1.2071067811865475,0.21234958358041378,24.003092043071895,52.748522957307756,9.7779329021420364E-2,0.41421356237309503,23.809499837575625,0.20710678118654754,0.18095951187205359]
[84,23.909499837575627,1.2071067811865475,0.45167666064190953,24.647891305541329,53.66013809385332,0.12139018371057043,0.41421356237309503,24.257910778435082,0.20710678118654754,0.73433042921505354]
[85,24.357910778435084,1.2071067811865475,0.28832961149197422,23.767957704666632,51.405022017075815,0.91616389787945118,0.41421356237309503,23.400746269126756,0.20710678118654754,0.65108557826408253]
[86,23.500746269126758,1.2071067811865475,2.1844222276287133,21.876914109097513,49.584659300174899,1.0021713878658014,0.41421356237309503,22.499661163920511,0.20710678118654754,1.872531126546755]
[87,22.599661163920512,1.2071067811865475,2.7478073985979692E-2,22.417537663398416,49.723694548308622,3.8813522039666044E-2,0.41421356237309503,22.402649686996792,0.20710678118654754,1.0702297629534097E-3]
[88,22.502649686996794,1.2071067811865475,0.11688365838290513,22.127028792152142,48.810913507829838,0.24475858868250869,0.41421356237309503,22.007918862525031,0.20710678118654754,6.8501742214787983E-2]
[89,22.107918862525032,1.2071067811865475,4.438588611277567E-2,22.339389171886094,49.3887238103312,5.1282443520536481E-3,0.41421356237309503,22.179530623794069,0.20710678118654754,0.12338927413039306]
[90,22.27953062379407,1.2071067811865475,1.9811454445724508,20.733097922167438,44.966377245738101,3.6189431366987899,0.41421356237309503,20.377178622533844,0.20710678118654754,0.61165813657045387]
[91,20.477178622533845,1.2071067811865475,4.221237984276293E-2,20.251446812728002,44.655101338291743,0.28962632201834371,0.41421356237309503,19.939009204953894,0.20710678118654754,0.47133781999962698]
[92,20.039009204953896,1.2071067811865475,1.5571885532891485,21.4100281188502,46.68757992140857,0.44449183353519045,0.41421356237309503,20.705711412491258,0.20710678118654754,2.3951993267158591]
[93,20.805711412491259,1.2071067811865475,0.7703431876883845,21.770017632371392,47.134403387030709,4.6926668623681368E-2,0.41421356237309503,21.022337054149123,0.20710678118654754,2.6992174947050827]
[94,21.122337054149124,1.2071067811865475,8.3394256881693968E-2,20.805058354905217,46.26002315084078,0.16634633791773271,0.41421356237309503,20.714481273366587,0.20710678118654754,3.9613418995999926E-2]
[95,20.814481273366589,1.2071067811865475,4.7635502889165265E-2,21.054275223587904,47.02426876311052,2.6811179304806906E-2,0.41421356237309503,20.978222469480478,0.20710678118654754,2.7927725853238789E-2]
[96,21.07822246948048,1.2071067811865475,3.9652587234787737,18.890417474909359,42.258862076066769,4.1154015286687446,0.41421356237309503,19.049577224823658,0.20710678118654754,0.12231287574289935]
[97,19.149577224823659,1.2071067811865475,9.0186127445887523E-3,19.04523917519224,42.111007859157795,0.24220811040051474,0.41421356237309503,18.657430792955548,0.20710678118654754,0.72617294552791223]
[98,18.757430792955549,1.2071067811865475,2.8095023102868155,20.59899786762497,45.811728106096339,1.8648820032028215,0.41421356237309503,20.123037618950068,0.20710678118654754,1.0938229884159336]
[99,20.22303761895007,1.2071067811865475,2.7765986971075201,22.053789135653584,49.284638461352763,2.5280521322610938,0.41421356237309503,21.813022566130734,0.20710678118654754,0.27989687574540462]
[100,21.913022566130735,1.2071067811865475,0.86880546298166583,22.937103112717324,52.693368933454614,2.5660771016204977,0.41421356237309503,23.514920534673205,0.20710678118654754,1.6120813196116994]

{"sheet":"KF2Sim","index":3,"n_rows":18,"n_cols":24,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,15,0,16]]}
["time",null,"mu(-)",null,"sig(-)",null,"Normal","X",null,"K","Normal","Z",null,"mu(+)",null,"sig(+)",null,null,1,0,"Identity"]
[1,null,0,null,10,0,{"$f":"NORMSINV(RAND())","v":8.6120237028360178E-2},{"$f":"C2+SQRT(E2)*G2","v":0.27233610164318905},null,{"$f":"MMULT(E2:F3,TRANSPOSE($S$4:$T$4))/(MMULT($S$4:$T$4,MMULT(E2:F3,TRANSPOSE($S$4:$T$4)))+$S$12)","v":0},{"$f":"NORMSINV(RAND())","v":-1.1609561105612163},{"$f":"MMULT($S$4:$T$4,H2:H3)+SQRT($S$12)*K2","v":-1.1609561105612163},null,{"$f":"C2:C3+MMULT(J2:J3,L2-MMULT($S$4:$T$4,C2:C3))","v":0},null,{"$f":"MMULT($S$1:$T$2-MMULT(J2:J3,$S$4:$T$4),E2:F3)","v":10},0,null,0,1]
[null,null,0,null,0,100,{"$f":"NORMSINV(RAND())","v":-0.48061180701683964},{"$f":"C3+SQRT(F3)*G3","v":-4.8061180701683961},null,0,null,null,null,0,null,0,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"H"]
[2,null,{"$f":"MMULT($S$6:$T$7,N2:N3)+$S$14:$S$15","v":1},null,{"$f":"MMULT($S$6:$T$7,MMULT(P2:Q3,TRANSPOSE($S$6:$T$7)))+$S$9:$T$10","v":110},100,0.30709389646666202,{"$f":"MMULT($S$6:$T$7,H2:H3)+MMULT($V$9:$W$10,G5:G6)+$S$14:$S$15","v":-3.533781968525207},null,{"$f":"MMULT(E5:F6,TRANSPOSE($S$4:$T$4))/(MMULT($S$4:$T$4,MMULT(E5:F6,TRANSPOSE($S$4:$T$4)))+$S$12)","v":0},{"$f":"NORMSINV(RAND())","v":-0.23325531276511699},{"$f":"MMULT($S$4:$T$4,H5:H6)+SQRT($S$12)*K5","v":-0.23325531276511699},null,{"$f":"C5:C6+MMULT(J5:J6,L5-MMULT($S$4:$T$4,C5:C6))","v":1},null,{"$f":"MMULT($S$1:$T$2-MMULT(J5:J6,$S$4:$T$4),E5:F6)","v":110},100]
[null,null,0,null,100,101,-2.2670482450028E-2,-4.8287885526184242,null,0,null,null,null,0,null,100,101,null,1,1,"phi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
[3,null,{"$f":"MMULT($S$6:$T$7,N5:N6)+$S$14:$S$15","v":2},null,{"$f":"MMULT($S$6:$T$7,MMULT(P5:Q6,TRANSPOSE($S$6:$T$7)))+$S$9:$T$10","v":411},201,-1.2048610953367631,{"$f":"MMULT($S$6:$T$7,H5:H6)+MMULT($V$9:$W$10,G8:G9)+$S$14:$S$15","v":-7.3625705211436312},null,{"$f":"MMULT(E8:F9,TRANSPOSE($S$4:$T$4))/(MMULT($S$4:$T$4,MMULT(E8:F9,TRANSPOSE($S$4:$T$4)))+$S$12)","v":0},{"$f":"NORMSINV(RAND())","v":0.48499059255392618},{"$f":"MMULT($S$4:$T$4,H8:H9)+SQRT($S$12)*K8","v":0.48499059255392618},null,{"$f":"C8:C9+MMULT(J8:J9,L8-MMULT($S$4:$T$4,C8:C9))","v":2},null,{"$f":"MMULT($S$1:$T$2-MMULT(J8:J9,$S$4:$T$4),E8:F9)","v":411},201,null,null,null,null,"normal1","normal2"]
[null,null,0,null,201,102,-9.3669479882696808E-4,-4.829725247417251,null,0,null,null,null,0,null,201,102,null,{"$f":"V9^2+W9^2","v":0},{"$f":"V9*W9+V10*W10","v":0},"Q",0,0,"up state 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T9","v":0},{"$f":"V10^2+W10^2","v":1},null,0,1,"up state 2"]
[4,null,{"$f":"MMULT($S$6:$T$7,N8:N9)+$S$14:$S$15","v":3},null,{"$f":"MMULT($S$6:$T$7,MMULT(P8:Q9,TRANSPOSE($S$6:$T$7)))+$S$9:$T$10","v":915},303,-3.2534821596413077E-2,{"$f":"MMULT($S$6:$T$7,H8:H9)+MMULT($V$9:W$10,G11:G12)+$S$14:$S$15","v":-11.192295768560882},null,{"$f":"MMULT(E11:F12,TRANSPOSE($S$4:$T$4))/(MMULT($S$4:$T$4,MMULT(E11:F12,TRANSPOSE($S$4:$T$4)))+$S$12)","v":0},-0.83352233167481848,{"$f":"MMULT($S$4:$T$4,H11:H12)+SQRT($S$12)*K11","v":-0.83352233167481848},null,{"$f":"C11:C12+MMULT(J11:J12,L11-MMULT($S$4:$T$4,C11:C12))","v":3},null,{"$f":"MMULT($S$1:$T$2-MMULT(J11:J12,$S$4:$T$4),E11:F12)","v":915},303]
[null,null,0,null,303,103,-0.42095122945586894,-5.25067647687312,null,0,null,null,null,0,null,303,103,null,1,null,"R"]
[]
[5,null,{"$f":"MMULT($S$6:$T$7,N11:N12)+$S$14:$S$15","v":4},null,{"$f":"MMULT($S$6:$T$7,MMULT(P11:Q12,TRANSPOSE($S$6:$T$7)))+$S$9:$T$10","v":1624},406,-0.86338981090253275,{"$f":"MMULT($S$6:$T$7,H11:H12)+MMULT($V$9:$W$10,G14:G15)+$S$14:$S$15","v":-15.442972245434003},null,{"$f":"MMULT(E14:F15,TRANSPOSE($S$4:$T$4))/(MMULT($S$4:$T$4,MMULT(E14:F15,TRANSPOSE($S$4:$T$4)))+$S$12)","v":0},-0.97205906511950724,{"$f":"MMULT($S$4:$T$4,H14:H15)+SQRT($S$12)*K14","v":-0.97205906511950724},null,{"$f":"C14:C15+MMULT(J14:J15,L14-MMULT($S$4:$T$4,C14:C15))","v":4},null,{"$f":"MMULT($S$1:$T$2-MMULT(J14:J15,$S$4:$T$4),E14:F15)","v":1624},406,null,1,null,"muW"]
[null,null,0,null,406,104,1.505569226988966,-3.7451072498841542,null,0,null,null,null,0,null,406,104,null,0]
[]
[6,null,{"$f":"MMULT($S$6:$T$7,N14:N15)+$S$14:$S$15","v":5},null,{"$f":"MMULT($S$6:$T$7,MMULT(P14:Q15,TRANSPOSE($S$6:$T$7)))+$S$9:$T$10","v":2540},510,-0.255379305087304,{"$f":"MMULT($S$6:$T$7,H14:H15)+MMULT($V$9:$W$10,G17:G18)+$S$14:$S$15","v":-18.188079495318156},null,{"$f":"MMULT(E17:F18,TRANSPOSE($S$4:$T$4))/(MMULT($S$4:$T$4,MMULT(E17:F18,TRANSPOSE($S$4:$T$4)))+$S$12)","v":0},{"$f":"NORMSINV(RAND())","v":-1.0076147519337999},{"$f":"MMULT($S$4:$T$4,H17:H18)+SQRT($S$12)*K17","v":-1.0076147519337999},null,{"$f":"C17:C18+MMULT(J17:J18,L17-MMULT($S$4:$T$4,C17:C18))","v":5},null,{"$f":"MMULT($S$1:$T$2-MMULT(J17:J18,$S$4:$T$4),E17:F18)","v":2540},510]
[null,null,0,null,510,105,0.36230048796640024,-3.3828067619177542,null,0,null,null,null,0,null,510,105]

{"sheet":"ArtillerySim","index":4,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Shot","Gain (K)","KalmanAim","Dispersion(V)","Miss (Z)","KalmanHit?",null,"sig_disp",1,null,"3CALAim","MissDist","3CALHit?",null,"Improve",null,"Truth(X)"]
[1,{"$f":"1/(A2+($I$1/$I$2)^2)","v":0.99009900990099009},0,{"$f":"NORMINV(RAND(),0,$I$1)","v":-1.1728357322344891},{"$f":"$I$4-C2-D2","v":17.060052800547954},{"$f":"IF(ABS(E2)<$I$3,1,0)","v":0},null,"sig_B",10,null,0,{"$f":"$I$4-D2-K2","v":17.060052800547954},{"$f":"IF(ABS(L2)<$I$3,1,0)","v":0},null,{"$f":"F2-M2","v":0},null,{"$f":"$I$4","v":15.887217068313465}]
[2,{"$f":"1/(A3+($I$1/$I$2)^2)","v":0.49751243781094534},{"$f":"C2+B2*E2","v":16.891141386681142},1.163505940775748,-2.1674302591434245,0,null,"R",1,null,0,14.723711127537717,0,null,0,null,{"$f":"$I$4","v":15.887217068313465}]
[3,0.33222591362126247,{"$f":"C3+B3*E3","v":15.812817874669488},0.27607609830480839,-0.20167690466083144,1,null,"TgtLoc(X)",{"$f":"NORMINV(RAND(),0,$I$2)","v":15.887217068313465},null,0,15.611140970008657,0,null,1,null,15.887217068313465]
[4,0.24937655860349128,15.745815580762235,-0.414020349558052,0.55542183710928172,1,null,null,null,null,{"$f":"AVERAGE($L$2:$L$4)","v":15.798301632698108},0.50293578517340798,1,null,0,null,15.887217068313465]
[5,0.19960079840319361,15.884324767073776,0.7142955671702419,-0.71140326593055347,1,null,null,null,null,15.798301632698108,-0.62538013155488414,1,null,0,null,15.887217068313465]
[6,0.1663893510815308,15.742328107207399,1.982102580980301,-1.8372136198742353,0,null,null,null,null,15.798301632698108,-1.8931871453649443,0,null,0,null,15.887217068313465]
[7,0.14265335235378032,15.436635325198376,8.6396756445448378E-2,0.36418498666964078,1,null,null,null,null,15.798301632698108,2.5186791699081112E-3,1,null,0,null,15.887217068313465]
[8,0.12484394506866417,15.488587534423717,0.13034031210212593,0.26828922178762216,1,null,null,null,null,15.798301632698108,-4.1424876486768625E-2,1,null,0,null,15.887217068313465]
[9,0.11098779134295228,15.522081819291085,0.5508563403392982,-0.18572109131691816,1,null,null,null,null,15.798301632698108,-0.46194090472394045,1,null,0,null,15.887217068313465]
[10,9.9900099900099903E-2,15.501469045560018,-4.4959536807680507E-2,0.43070755956112716,1,null,null,null,null,15.798301632698108,0.13387497242303859,1,null,0,null,15.887217068313465]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"bu"]