Investigating iron washer at entry to coil Coil is 40mm long 4mm inside radius 10mm outside radius 4 layers of 31 turns each Projectile is 10mm long 2.25mm radius made of M-19 steel starting 47mm away from center To import in Excel: Data - Get External Data - Import text file then choose the file written by this program and click Finish. This data file is tab delimited (Excel's default import format) Iron washer thickness = 0.1 -47 0.2204408058175259 -46 0.303084163260377 -45 0.3681419263325911 -44 0.5084980520654796 -43 0.6801994686995759 -42 0.9402086623790935 -41 1.322005498966217 -40 1.874592908359334 -39 2.74139565943643 -38 4.059753752660644 -37 5.855854046225152 -36 8.329630861967001 -35 11.30920536668821 -34 14.13371053666708 -33 16.40837463177324 -32 18.14495015979915 -31 19.42580104569709 -30 20.38472824753758 -29 21.05276165663809 -28 21.65283668906032 -27 21.92132542361406 -26 22.3450594991875 -25 22.57589943523366 -24 22.63982145288348 -23 22.85366937308723 -22 22.7981257545379 -21 22.80395219020148 -20 22.81017433571576 -19 22.73705119007061 -18 22.62990589642218 -17 22.5357966185077 -16 22.33517805019118 -15 22.08605793083048 -14 21.81564589339041 -13 21.40042737214502 -12 20.90900965822782 -11 20.3731386496183 -10 19.46618427319613 -9 18.51552404672649 -8 17.21382423475044 -7 15.47207176755857 -6 13.20986167613264 -5 10.51111074616783 -4 7.747009716019298 -3 5.384459257320807 -2 3.18965596099002 -1 1.397747650119356 0 -0.3517548991012491 1 -1.991955219506647 2 -3.815787078905448 3 -5.876406204939192 4 -8.175900918272028 5 -10.49275549533532 6 -13.07828348881453 Iron washer thickness = 0.6 -47 0.1707366056586039 -46 0.2175727373521708 -45 0.2785091105818912 -44 0.357372568041561 -43 0.4700386869463528 -42 0.636651087469374 -41 0.8518410342718413 -40 1.191264514437744 -39 1.699428824362323 -38 2.548317625618667 -37 3.899654505711399 -36 6.435569351635766 -35 10.61527159462679 -34 15.01111922037548 -33 17.80418622788436 -32 19.4942428472503 -31 20.55271427618502 -30 21.39078200123579 -29 21.78062264259976 -28 22.17126221217075 -27 22.43560361681417 -26 22.7362420683986 -25 22.8042574559009 -24 22.94873829367423 -23 23.0001768897031 -22 23.04112625490284 -21 23.0342502199048 -20 23.02883722653864 -19 22.94818778917128 -18 22.88741406635893 -17 22.78773765201987 -16 22.62613677501703 -15 22.39894144319912 -14 22.24141900016475 -13 21.92822065496127 -12 21.54037118577148 -11 21.12865190132532 -10 20.54854965581005 -9 19.69144509178913 -8 18.62549483128337 -7 16.87814830016743 -6 13.9999867830954 -5 10.00394393133583 -4 6.330950595116899 -3 3.728726552209733 -2 1.775060428046493 -1 0.1828311586056675 0 -1.260455813436797 1 -2.780620722922233 2 -4.454749735243998 3 -6.453978300017162 4 -8.582784708893579 5 -10.8012346017681 6 -13.33772157608995 Iron washer thickness = 1.1 -47 0.151061216383379 -46 0.1943195720503985 -45 0.2431945157653717 -44 0.3096361310789753 -43 0.4034118952437457 -42 0.5264820445541161 -41 0.6978864142475728 -40 0.9473875321875196 -39 1.348554993019833 -38 2.031030642617101 -37 3.32912885041437 -36 5.891260228263913 -35 10.37015552779082 -34 15.18261733655412 -33 18.03547743985011 -32 19.87551545438269 -31 21.05869199819996 -30 21.59332005730675 -29 22.07554977831448 -28 22.40223495179508 -27 22.6593832819236 -26 22.88639203537987 -25 22.94815709120539 -24 23.0936335034489 -23 23.12140758542844 -22 23.15785325023373 -21 23.16239198388317 -20 23.16159455785495 -19 23.06897186337426 -18 23.04208127466837 -17 22.94035008722366 -16 22.80735189951843 -15 22.63226035081934 -14 22.53281756307691 -13 22.29170934908717 -12 21.98697595901212 -11 21.67500483465113 -10 21.23500817294243 -9 20.56542205971009 -8 19.55106045503129 -7 17.699971232114 -6 14.2034594158809 -5 9.3312829851546 -4 5.401570809166412 -3 2.897439849948319 -2 0.9382731994665596 -1 -0.4764913176280388 0 -1.731809945270797 1 -3.159947696341949 2 -4.742779138058322 3 -6.668469155755576 4 -8.773813660167981 5 -10.94263800090083 6 -13.44555997097845 Iron washer thickness = 1.6 -47 0.1565490960871097 -46 0.1962824605852616 -45 0.245883084048851 -44 0.3115708727476962 -43 0.3986899502507544 -42 0.5159636751314629 -41 0.6778785274671481 -40 0.929404900863863 -39 1.294968448841942 -38 1.947392167759172 -37 3.18935284225525 -36 5.743742037277215 -35 10.19379126157093 -34 15.18763853273058 -33 18.14341265202789 -32 19.88991752124811 -31 21.04771193177076 -30 21.64976845921112 -29 22.15564094609282 -28 22.54490506636432 -27 22.68712400262705 -26 22.97590739222373 -25 22.99490803281844 -24 23.11910603309466 -23 23.14967055109073 -22 23.22026363020258 -21 23.19020017287119 -20 23.19284334885116 -19 23.09151116661008 -18 23.07893503689614 -17 22.98061047146344 -16 22.85566581338584 -15 22.70222852742996 -14 22.57082999845804 -13 22.42240230400619 -12 22.12515379779524 -11 21.85575567940067 -10 21.44837232597642 -9 20.81423741582847 -8 19.83152218012839 -7 17.72642819811426 -6 14.02237496156356 -5 9.090969435017843 -4 5.132765815142447 -3 2.760033597892258 -2 0.8362827984758772 -1 -0.5526511751005367 0 -1.796331898485819 1 -3.198153775667518 2 -4.808393147528043 3 -6.71792902469167 4 -8.804665606836666 5 -10.98007584417787 6 -13.4593326900856 Iron washer thickness = 2.1 -47 0.1597682493401944 -46 0.195909162782756 -45 0.2452755860858949 -44 0.3078883061238729 -43 0.3911775404954794 -42 0.5097976014947671 -41 0.6639256313097869 -40 0.8923017434285155 -39 1.26014026168569 -38 1.888495042657285 -37 3.095285628060477 -36 5.546987367618081 -35 10.05376363441583 -34 15.20780723806922 -33 18.16675853733474 -32 19.9332466191241 -31 21.15432936458763 -30 21.80013059823381 -29 22.21688626629974 -28 22.6056163643156 -27 22.83040795218771 -26 22.95921523272185 -25 23.02724786954939 -24 23.11055170044537 -23 23.1780501038229 -22 23.19652337448759 -21 23.21854453038453 -20 23.19107278695762 -19 23.14643387719558 -18 23.10744074160947 -17 23.062248100107 -16 22.89596474129486 -15 22.77184382716035 -14 22.65989189476461 -13 22.50159005924338 -12 22.26076447356109 -11 21.95546705780798 -10 21.63454546160242 -9 20.95939449778753 -8 19.83575532928121 -7 17.79591685091591 -6 14.01339154863391 -5 9.077624524051553 -4 5.079737103874988 -3 2.55530436017969 -2 0.7701324028811338 -1 -0.6310724619279258 0 -1.859259285773462 1 -3.257216037884732 2 -4.85471604762822 3 -6.758478719924133 4 -8.841164567800789 5 -11.00724698099436 6 -13.41162454345063 Iron washer thickness = 2.6 -47 0.1611649660899891 -46 0.1988651426789514 -45 0.2494118048893215 -44 0.3125110891539035 -43 0.3992660305723453 -42 0.5077852282168084 -41 0.6600405392650914 -40 0.8752344698117455 -39 1.252554309257417 -38 1.802481029756694 -37 2.909686096289873 -36 5.312858222264159 -35 9.931587827261287 -34 15.21484300420916 -33 18.20577719712166 -32 20.00360831998847 -31 21.13109412670585 -30 21.82069516921214 -29 22.2118347805594 -28 22.61635006566917 -27 22.73849175626523 -26 22.92219315298365 -25 23.04607644157424 -24 23.16206175790751 -23 23.21682311881274 -22 23.20208994050569 -21 23.21936293200417 -20 23.1708055077798 -19 23.14905181984451 -18 23.12581976901914 -17 23.05532731146852 -16 22.94522396449113 -15 22.80796820545586 -14 22.71450243140938 -13 22.58213955942474 -12 22.31869500081418 -11 22.09839199832356 -10 21.73019081576199 -9 21.08435658899245 -8 19.95553002871872 -7 17.73985892678072 -6 13.91322385476173 -5 9.02874253111897 -4 5.048394017219301 -3 2.515912243526568 -2 0.7028004157504574 -1 -0.6767981824945917 0 -1.929586716564295 1 -3.300250833246945 2 -4.894989472485707 3 -6.788284679368303 4 -8.873731654034829 5 -11.03265643195156 6 -13.43103161198606 Iron washer thickness = 3.1 -47 0.1632129749893406 -46 0.2027616652821275 -45 0.2573663488793313 -44 0.3150721231112284 -43 0.403213031799793 -42 0.5052318164696307 -41 0.6598138043868195 -40 0.8824520692187341 -39 1.197356482619181 -38 1.720710366302427 -37 2.763871351074845 -36 5.169403709077654 -35 9.836158221698131 -34 15.22004240797229 -33 18.25486142852602 -32 20.02841854486356 -31 21.17554643819711 -30 21.84447250693757 -29 22.24959720563002 -28 22.66673276818702 -27 22.78813172882314 -26 22.99794513127033 -25 23.04101976273224 -24 23.15010699168811 -23 23.22952321097957 -22 23.21546366745603 -21 23.26115850264658 -20 23.26199933593761 -19 23.21264136066675 -18 23.18759175136735 -17 23.11734502692776 -16 23.01554561870724 -15 22.87890408699456 -14 22.8101194880298 -13 22.66307756854813 -12 22.44284736233064 -11 22.22283894513888 -10 21.83702040553034 -9 21.11581854909263 -8 19.88850701515224 -7 17.67216923557201 -6 14.00588781756572 -5 9.001949914285664 -4 5.00340902889003 -3 2.460749419093845 -2 0.6582797917007418 -1 -0.7171504723750415 0 -1.957219291822868 1 -3.330382621259321 2 -4.750464881276586 3 -6.825471225384405 4 -8.909598637460094 5 -11.05352860891152 6 -13.47178268968366 Iron washer thickness = 3.6 -47 0.1670541951893172 -46 0.208881801123238 -45 0.257542144345351 -44 0.3272355769055111 -43 0.4063406712821996 -42 0.5135348120209985 -41 0.6622759655058585 -40 0.8513624496218498 -39 1.158468156070248 -38 1.607737531858835 -37 2.584630176941015 -36 5.022957290847661 -35 9.748529110432175 -34 15.2245879436918 -33 18.28910490662079 -32 20.0440460651613 -31 21.2267550052157 -30 21.86958292505999 -29 22.27893370648077 -28 22.63690988055605 -27 22.79449077411537 -26 23.02685758998314 -25 23.05444908450281 -24 23.18242405276729 -23 23.25647332183324 -22 23.36002434465298 -21 23.2616521196921 -20 23.2795390132296 -19 23.21211700785647 -18 23.21605200340905 -17 23.11498261907012 -16 23.02627743728932 -15 22.93476203962704 -14 22.88177684225164 -13 22.73142995018921 -12 22.55822543827591 -11 22.3122909814415 -10 21.93781747578206 -9 21.17327790830784 -8 19.90413783882212 -7 17.70886158696414 -6 14.03890019310903 -5 9.002770401490334 -4 4.968710928933167 -3 2.41545555511174 -2 0.6251729899096798 -1 -0.7317250096018607 0 -2.079690839699836 1 -3.368380625146144 2 -4.916930455523468 3 -6.849274479238023 4 -8.92304776761563 5 -11.14462984112593 6 -13.48968831257453 Iron washer thickness = 4.1 -47 0.1739741741973045 -46 0.2138976556423079 -45 0.2645615518903857 -44 0.3319620609342932 -43 0.4161275907331016 -42 0.5246365435145692 -41 0.6632100659492271 -40 0.8472106439640859 -39 1.08441719394581 -38 1.491311815675586 -37 2.443151345775894 -36 4.868771869002595 -35 9.656550202095311 -34 15.19466013989028 -33 18.30619607846087 -32 20.13736587665808 -31 21.25393606225125 -30 21.89612815224229 -29 22.27163218968499 -28 22.70259729771775 -27 22.83080635600286 -26 22.97940083270077 -25 23.09343451092518 -24 23.14649416393925 -23 23.2707405424053 -22 23.27070913530195 -21 23.28418114795493 -20 23.28185140742438 -19 23.26352013504503 -18 23.18360893074786 -17 23.14429207746799 -16 23.1171850557832 -15 23.00770782047131 -14 22.93934098519952 -13 22.80703139960694 -12 22.60180657087925 -11 22.39574557824204 -10 21.93400010821732 -9 21.13494564137048 -8 19.93774428280582 -7 17.7172654565928 -6 14.00818418789797 -5 8.937311168119541 -4 4.935012723783813 -3 2.416431273081125 -2 0.5944433165028349 -1 -0.8074270847171741 0 -2.12998520046721 1 -3.401472988634019 2 -4.903349120037071 3 -6.877214345923347 4 -8.945132477418762 5 -11.16633090934989 6 -13.50852473838411 Iron washer thickness = 4.6 -47 0.1819968167471942 -46 0.223229063486651 -45 0.278929907672959 -44 0.3416776749311491 -43 0.4257360760399282 -42 0.5234820314340851 -41 0.6584356048416938 -40 0.8130487668401327 -39 1.004600089040117 -38 1.367163489064892 -37 2.311153781594998 -36 4.749086657163455 -35 9.637512232718491 -34 15.23361814534205 -33 18.29815068468561 -32 20.12191975136076 -31 21.19968677933183 -30 21.91445749429298 -29 22.29380709571248 -28 22.71877309057955 -27 22.83306925952592 -26 23.0116886163468 -25 23.09724667423474 -24 23.19766691675337 -23 23.26836799511207 -22 23.29285948148671 -21 23.31601327029819 -20 23.30821257915626 -19 23.26081335670601 -18 23.2209904978848 -17 23.18937524163509 -16 23.12820088269188 -15 23.04432569406642 -14 23.01809134423189 -13 22.88321485302813 -12 22.70278908255614 -11 22.46214046622102 -10 22.02134967434201 -9 21.19841656707991 -8 19.95877181679938 -7 17.74599722568926 -6 14.00630475652997 -5 8.96460492284241 -4 4.923957885094134 -3 2.369240591464783 -2 0.5593863529844038 -1 -0.8470681391063284 0 -2.072134858549979 1 -3.427698570610218 2 -4.862210645432384 3 -6.901345535670076 4 -8.969208206879451 5 -11.11851257622804 6 -13.52590127289278 Iron washer thickness = 5.1 -47 0.1893257652503808 -46 0.2297643856438747 -45 0.2863953563237558 -44 0.3517648595645499 -43 0.4375056983124628 -42 0.532427351532503 -41 0.6505595440764447 -40 0.7701043900487079 -39 0.9235814732983012 -38 1.263717971096716 -37 2.21172831931488 -36 4.639975348770922 -35 9.5912396400413 -34 15.24769922653516 -33 18.30532343662564 -32 20.08544859908425 -31 21.28542305798882 -30 21.93980179709454 -29 22.35673090237168 -28 22.72404605219118 -27 22.87839548594917 -26 23.02039294203327 -25 23.15288457377869 -24 23.22072107997224 -23 23.30404210841838 -22 23.30870906146455 -21 23.33796595488664 -20 23.33091955693885 -19 23.33666307721927 -18 23.25072808884602 -17 23.24961815751282 -16 23.17732418458041 -15 23.11814588243458 -14 23.07875650492324 -13 22.99658783470134 -12 22.77513762307208 -11 22.51494611992378 -10 22.02319853383022 -9 21.24805199189114 -8 19.97969058945123 -7 17.77387870326738 -6 14.01657316192146 -5 8.936618451943104 -4 4.874479071060626 -3 2.336861462776013 -2 0.5216073507068798 -1 -0.8378282135644721 0 -2.059474494165542 1 -3.465400498718551 2 -4.865699499494396 3 -6.923712553929578 4 -8.994480186846538 5 -11.131328812941 6 -13.54041521756733