{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle3"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Tabelle1","index":0,"n_rows":209,"n_cols":6,"rows_kept":209,"cut":false,"hidden":false,"merged":[[4,5,4,8],[5,0,5,1]]}
["lambda=",6.3E-7,"Wellenlänge",null,null,"Intensitätsberechnung für 0 <= alpha <= 4 Lamda/d"]
["dy=",{"$f":"1/D2*2","v":5.0000000000000001E-3},"(als Anteil von r)",400,"Streifen, Erregerzentren auf Durchmesser; berechnet zu einer Seite, also 200 Stück"]
["Belendendurchmesser: 2",null,"(facher Radius)"]
["d=",2.0000000000000001E-4,"(m)"]
["www.schulphysik.de/strutz/Kreisblende.pdf",null,null,null,null,"Erläuterung zum Faktor 1,22 bei der Kreisblende"]
["vgl. Metzler S. 310"]
[]
["Nummer","Intensität","alpha","dphi","alpha/(k/d)"]
[0,{"$f":"intensi(D9,$B$2)","v":314.07612946864327},{"$f":"A9*0.01*$B$1/($B$4/2)","v":0},{"$f":"2*PI()/$B$1*$B$2*$B$4/2*SIN(C9)","v":0},{"$f":"C9/($B$1/2)*$B$4/2","v":0}]
[1,{"$f":"intensi(D10,$B$2)","v":313.76639896019913},{"$f":"A10*0.01*$B$1/($B$4/2)","v":6.3E-5},{"$f":"2*PI()/$B$1*$B$2*$B$4/2*SIN(C10)","v":3.1415926515116301E-4},{"$f":"C10/($B$1/2)*$B$4/2","v":0.02}]
[2,312.83873408268363,1.26E-4,6.2831852905542783E-4,0.04]
[3,311.29770424734579,1.8899999999999999E-4,9.4247779046589635E-4,6.0000000000000005E-2]
[4,309.15089011941666,2.52E-4,1.2566370481356707E-3,0.08]
[5,306.40883139216021,3.1500000000000001E-4,1.5707963008178526E-3,0.1]
[6,303.0849542762665,3.7799999999999997E-4,1.8849555472655437E-3,0.12000000000000001]
[7,299.19547930356703,4.4100000000000004E-4,2.1991147862318468E-3,0.14000000000000004]
[8,294.75931020560409,5.04E-4,2.513274016469863E-3,0.16]
[9,289.79790478210805,5.669999999999999E-4,2.8274332367326941E-3,0.18]
[10,284.33512882049422,6.3000000000000003E-4,3.1415924457734437E-3,0.2]
[11,278.39709426369603,6.9300000000000004E-4,3.4557516423452121E-3,0.22]
[12,272.01198294893123,7.5599999999999994E-4,3.7699108252011023E-3,0.24000000000000002]
[13,265.20985735294732,8.1899999999999996E-4,4.0840699930942163E-3,0.26]
[14,258.02245987924368,8.8200000000000008E-4,4.3982291447776578E-3,0.28000000000000008]
[15,250.48300230853775,9.4499999999999988E-4,4.7123882790045257E-3,0.3]
[16,242.6259471048001,1.008E-3,5.0265473945279261E-3,0.32]
[17,234.4867823248502,1.0710000000000001E-3,5.3407064901009604E-3,0.34000000000000008]
[18,226.10179191941597,1.1339999999999998E-3,5.6548655644767278E-3,0.36]
[19,217.50782323725906,1.1969999999999999E-3,5.9690246164083374E-3,0.37999999999999995]
[20,208.74205355164187,1.2600000000000001E-3,6.2831836446488858E-3,0.4]
[21,199.84175741975793,1.3229999999999997E-3,6.597342647951478E-3,0.41999999999999993]
[22,190.84407666121362,1.3860000000000001E-3,6.9115016250692199E-3,0.44]
[23,181.7857947013764,1.449E-3,7.2256605747552096E-3,0.46]
[24,172.703116970205,1.5119999999999999E-3,7.539819495762554E-3,0.48000000000000004]
[25,163.63145897718343,1.575E-3,7.8539783868443545E-3,0.5]
[26,154.60524359951756,1.6379999999999999E-3,8.1681372467537136E-3,0.52]
[27,145.65770902446184,1.701E-3,8.4822960742437382E-3,0.54]
[28,136.82072867828393,1.7640000000000002E-3,8.796454868067528E-3,0.56000000000000016]
[29,128.12464435584337,1.8269999999999998E-3,9.1106136269781864E-3,0.57999999999999996]
[30,119.59811363628899,1.8899999999999998E-3,9.424772349728822E-3,0.6]
[31,111.26797253407085,1.9530000000000001E-3,9.7389310350725379E-3,0.62]
[32,103.15911419149968,2.016E-3,1.0053089681762432E-2,0.64]
[33,95.294384270262185,2.0790000000000001E-3,1.0367248288551617E-2,0.66]
[34,87.694493547345772,2.1420000000000002E-3,1.0681406854193195E-2,0.68000000000000016]
[35,80.377948065883601,2.2049999999999999E-3,1.0995565377440262E-2,0.70000000000000007]
[36,73.360997035767298,2.2679999999999996E-3,1.1309723857045933E-2,0.72]
[37,66.657598524095562,2.3309999999999997E-3,1.1623882291763312E-2,0.74]
[38,60.279402822245522,2.3939999999999999E-3,1.1938040680345504E-2,0.7599999999999999]
[39,54.23575322708772,2.4569999999999995E-3,1.2252199021545607E-2,0.7799999999999998]
[40,48.533703829072927,2.5200000000000001E-3,1.256635731411674E-2,0.8]
[41,43.178053761472043,2.5830000000000002E-3,1.2880515556811994E-2,0.82000000000000006]
[42,38.171397233925696,2.6459999999999995E-3,1.3194673748384482E-2,0.83999999999999986]
[43,33.514188550838789,2.709E-3,1.3508831887587315E-2,0.86]
[44,29.204821202102451,2.7720000000000002E-3,1.3822989973173589E-2,0.88]
[45,25.239720011172992,2.8349999999999998E-3,1.4137148003896418E-2,0.9]
[46,21.613445234101675,2.898E-3,1.4451305978508905E-2,0.92]
[47,18.318807424017763,2.9610000000000001E-3,1.4765463895764162E-2,0.94000000000000006]
[48,15.346991808754638,3.0239999999999998E-3,1.507962175441529E-2,0.96000000000000008]
[49,12.687690875551608,3.0869999999999999E-3,1.53937795532154E-2,0.98000000000000009]
[50,10.329243816304842,3.15E-3,1.5707937290917597E-2,1]
[51,8.2587814596847036,3.2129999999999997E-3,1.6022094966274995E-2,1.0199999999999998]
[52,6.4623753027679287,3.2759999999999998E-3,1.6336252578040698E-2,1.04]
[53,4.92518925445943,3.339E-3,1.6650410124967811E-2,1.06]
[54,3.6316327155372536,3.4020000000000001E-3,1.6964567605809448E-2,1.08]
[55,2.5655136455123988,3.4650000000000002E-3,1.7278725019318715E-2,1.1000000000000001]
[56,1.710190303853548,3.5280000000000003E-3,1.7592882364248726E-2,1.1200000000000003]
[57,1.0487204021304306,3.591E-3,1.7907039639352584E-2,1.1400000000000001]
[58,0.56400646334327964,3.6539999999999997E-3,1.82211968433834E-2,1.1599999999999999]
[59,0.23893625447758968,3.7169999999999994E-3,1.8535353975094288E-2,1.18]
[60,5.651723710046927E-2,3.7799999999999995E-3,1.8849511033238356E-2,1.2]
[61,4.0677458720086512E-6,3.8430000000000001E-3,1.9163668016568717E-2,1.22]
[62,5.3018273773051669E-2,3.9060000000000002E-3,1.9477824923838476E-2,1.24]
[63,0.19965933028114718,3.9690000000000003E-3,1.9791981753800751E-2,1.26]
[64,0.42460646837845906,4.032E-3,2.0106138505208648E-2,1.28]
[65,{"$f":"intensi(D74,$B$2)","v":0.71321065345890999},{"$f":"A74*0.01*$B$1/($B$4/2)","v":4.0949999999999997E-3},{"$f":"2*PI()/$B$1*$B$2*$B$4/2*SIN(C74)","v":2.0420295176815283E-2},{"$f":"C74/($B$1/2)*$B$4/2","v":1.2999999999999998}]
[66,1.0515762829782347,4.1580000000000002E-3,2.0734451767373763E-2,1.32]
[67,1.4266322653401211,4.2209999999999999E-3,2.1048608275637204E-2,1.34]
[68,1.8261922537722666,4.2840000000000005E-3,2.1362764700358725E-2,1.3600000000000003]
[69,2.2390039203090697,4.3470000000000002E-3,2.1676921040291432E-2,1.3800000000000001]
[70,2.65478726413351,4.4099999999999999E-3,2.1991077294188432E-2,1.4000000000000001]
[71,3.0642620544754213,4.4729999999999995E-3,2.2305233460802848E-2,1.42]
[72,3.4591646100542022,4.5359999999999992E-3,2.2619389538887796E-2,1.44]
[73,3.8322542136951543,4.5989999999999998E-3,2.293354552719639E-2,1.46]
[74,4.1773095514624208,4.6619999999999995E-3,2.3247701424481734E-2,1.48]
[75,4.4891156495627706,4.725E-3,2.3561857229496962E-2,1.5]
[76,4.7634418588191814,4.7879999999999997E-3,2.3876012940995169E-2,1.5199999999999998]
[77,4.9970115049637407,4.8510000000000003E-3,2.4190168557729482E-2,1.54]
[78,5.1874638829754458,4.9139999999999991E-3,2.4504324078453012E-2,1.5599999999999996]
[79,5.333309324754854,4.9769999999999997E-3,2.4818479501918889E-2,1.5799999999999998]
[80,5.4338781112929251,5.0400000000000002E-3,2.5132634826880221E-2,1.6]
[81,5.4892640330012119,5.1029999999999999E-3,2.5446790052090121E-2,1.62]
[82,5.5002634249434053,5.1660000000000005E-3,2.5760945176301713E-2,1.6400000000000001]
[83,5.4683105173724496,5.2290000000000001E-3,2.6075100198268111E-2,1.6600000000000001]
[84,5.3954099463678027,5.291999999999999E-3,2.6389255116742429E-2,1.6799999999999997]
[85,5.2840672647143512,5.3549999999999995E-3,2.6703409930477807E-2,1.7000000000000002]
[86,5.1372182798100905,5.4180000000000001E-3,2.7017564638227347E-2,1.72]
[87,4.9581580236558249,5.4809999999999998E-3,2.7331719238744171E-2,1.74]
[88,4.7504701305502026,5.5440000000000003E-3,2.7645873730781409E-2,1.76]
[89,4.517957361256701,5.607E-3,2.7960028113092162E-2,1.78]
[90,4.2645739690623561,5.6699999999999997E-3,2.8274182384429573E-2,1.8]
[91,3.9943605537609801,5.7329999999999994E-3,2.8588336543546748E-2,1.8199999999999996]
[92,3.7113819950175242,5.7959999999999999E-3,2.8902490589196819E-2,1.84]
[93,3.4196689975134822,5.8590000000000005E-3,2.9216644520132905E-2,1.86]
[94,3.1231637175862605,5.9220000000000002E-3,2.9530798335108129E-2,1.8800000000000001]
[95,2.8256698754969327,5.9850000000000007E-3,2.9844952032875616E-2,1.9000000000000004]
[96,2.5308076899105196,6.0479999999999996E-3,3.0159105612188479E-2,1.9200000000000002]
[97,2.2419739023373619,6.1109999999999992E-3,3.0473259071799853E-2,1.9399999999999997]
[98,1.9623070901520492,6.1739999999999998E-3,3.0787412410462872E-2,1.9600000000000002]
[99,1.6946583979865835,6.2369999999999995E-3,3.1101565626930647E-2,1.9800000000000002]
[100,1.4415677496668471,6.3E-3,3.1415718719956305E-2,2]
[101,1.2052455371584523,6.3630000000000006E-3,3.1729871688292985E-2,2.02]
[102,0.98755971978674617,6.4259999999999994E-3,3.2044024530693792E-2,2.0399999999999996]
[103,0.79002820706262855,6.489E-3,3.2358177245911869E-2,2.06]
[104,0.61381634229739146,6.5519999999999997E-3,3.2672329832700346E-2,2.08]
[105,0.45973925228861046,6.6150000000000002E-3,3.2986482289812338E-2,2.1]
[106,0.32826878131645976,6.6779999999999999E-3,3.3300634616000989E-2,2.12]
[107,0.21954468567976762,6.7409999999999996E-3,3.3614786810019413E-2,2.14]
[108,0.13338972853654044,6.8040000000000002E-3,3.3928938870620762E-2,2.16]
[109,6.9328283976336086E-2,6.8669999999999998E-3,3.4243090796558143E-2,2.1800000000000002]
[110,2.6608034307819505E-2,6.9300000000000004E-3,3.4557242586584699E-2,2.2000000000000002]
[111,4.2243255206581027E-3,6.9930000000000001E-3,3.4871394239453561E-2,2.2200000000000002]
[112,9.4673283893574242E-4,7.0560000000000006E-3,3.5185545753917857E-2,2.2400000000000007]
[113,1.5347381133330798E-2,7.1190000000000012E-3,3.5499697128730717E-2,2.2600000000000007]
[114,4.583056360217571E-2,7.182E-3,3.5813848362645284E-2,2.2800000000000002]
[115,9.0663206369101232E-2,7.2450000000000006E-3,3.6127999454414687E-2,2.3000000000000003]
[116,0.14800573622899213,7.3079999999999994E-3,3.6442150402792056E-2,2.3199999999999998]
[117,0.21594292340534899,7.3709999999999999E-3,3.6756301206530534E-2,2.3400000000000003]
[118,0.2925142904915824,7.4339999999999988E-3,3.707045186438325E-2,2.36]
[119,0.37574370235300419,7.4969999999999993E-3,3.7384602375103347E-2,2.38]
[120,0.46366777920813246,7.559999999999999E-3,3.7698752737443948E-2,2.4]
[121,0.5543628059191964,7.6229999999999996E-3,3.801290295015821E-2,2.42]
[122,0.64596984421572901,7.6860000000000001E-3,3.8327053011999263E-2,2.44]
[123,0.73671779060488085,7.7489999999999998E-3,3.8641202921720234E-2,2.46]
[124,0.82494416059576048,7.8120000000000004E-3,3.8955352678074276E-2,2.48]
[125,0.90911341900719833,7.8750000000000001E-3,3.9269502279814524E-2,2.5]
[126,0.9878327160339746,7.9380000000000006E-3,3.9583651725694113E-2,2.52]
[127,1.0598649288767474,8.0009999999999994E-3,3.9897801014466182E-2,2.5399999999999996]
[128,1.1241389485816065,8.064E-3,4.0211950144883886E-2,2.56]
[129,{"$f":"intensi(D138,$B$2)","v":1.1797571908023388},{"$f":"A138*0.01*$B$1/($B$4/2)","v":8.1270000000000005E-3},{"$f":"2*PI()/$B$1*$B$2*$B$4/2*SIN(C138)","v":4.0526099115700362E-2},{"$f":"C138/($B$1/2)*$B$4/2","v":2.58}]
[130,1.2260003470157805,8.1899999999999994E-3,4.0840247925668753E-2,2.5999999999999996]
[131,1.2623294288616311,8.2529999999999999E-3,4.1154396573542196E-2,2.62]
[132,1.2883851923359937,8.3160000000000005E-3,4.1468545058073833E-2,2.64]
[133,1.3039850601848999,8.379000000000001E-3,4.1782693378016829E-2,2.6600000000000006]
[134,1.3091176896937393,8.4419999999999999E-3,4.2096841532124306E-2,2.68]
[135,1.3039353588966875,8.5050000000000004E-3,4.2410989519149421E-2,2.7]
[136,1.2887443667804275,8.568000000000001E-3,4.2725137337845318E-2,2.7200000000000006]
[137,1.263993662186472,8.6309999999999998E-3,4.3039284986965139E-2,2.74]
[138,1.2302619316660646,8.6940000000000003E-3,4.3353432465262041E-2,2.7600000000000002]
[139,1.1882433884604511,8.7569999999999992E-3,4.3667579771489162E-2,2.78]
[140,1.1387325130223709,8.8199999999999997E-3,4.3981726904399679E-2,2.8000000000000003]
[141,1.0826080000831757,8.8829999999999985E-3,4.4295873862746707E-2,2.82]
[142,1.0208161682844297,8.9459999999999991E-3,4.4610020645283417E-2,2.84]
[143,0.95435408592305471,9.0089999999999979E-3,4.4924167250762939E-2,2.8599999999999994]
[144,0.88425266057820873,9.0719999999999985E-3,4.5238313677938465E-2,2.88]
[145,0.81155993146791672,9.134999999999999E-3,4.5552459925563116E-2,2.9]
[146,0.7373247915674882,9.1979999999999996E-3,4.5866605992390057E-2,2.92]
[147,0.66258135205284596,9.2610000000000001E-3,4.6180751877172445E-2,2.94]
[148,0.5883341447968482,9.323999999999999E-3,4.6494897578663409E-2,2.96]
[149,0.51554433976097691,9.3869999999999995E-3,4.6809043095616135E-2,2.98]
[150,0.44511713348393239,9.4500000000000001E-3,4.7123188426783778E-2,3]
[151,0.37789044284899187,9.5129999999999989E-3,4.7437333570919463E-2,3.0199999999999996]
[152,0.31462501520842689,9.5759999999999994E-3,4.7751478526776386E-2,3.0399999999999996]
[153,0.25599604215549926,9.639E-3,4.80656232931077E-2,3.06]
[154,0.20258634004430265,9.7020000000000006E-3,4.8379767868666546E-2,3.08]
[155,0.15488113618102495,9.7650000000000011E-3,4.8693912252206102E-2,3.1000000000000005]
[156,0.11326447569282756,9.8279999999999982E-3,4.9008056442479485E-2,3.1199999999999992]
[157,7.8017240812514446E-2,9.8909999999999988E-3,4.932220043823992E-2,3.1399999999999997]
[158,4.9316751937730906E-2,9.9539999999999993E-3,4.9636344238240551E-2,3.1599999999999997]
[159,2.7237898643655029E-2,1.0017E-2,4.9950487841234521E-2,3.18]
[160,1.1755729082260006E-2,1.008E-2,5.0264631245975008E-2,3.2]
[161,2.7494081157060529E-3,1.0142999999999999E-2,5.0578774451215162E-2,3.2199999999999998]
[162,7.4383014136694893E-6,1.0206E-2,5.0892917455708168E-2,3.24]
[163,3.2340236374159628E-3,1.0269E-2,5.1207060258207183E-2,3.2600000000000002]
[164,1.2056443912609774E-2,1.0332000000000001E-2,5.1521202857465385E-2,3.2800000000000002]
[165,2.6033297692672142E-2,1.0395000000000001E-2,5.1835345252235931E-2,3.3000000000000007]
[166,4.4663464467180954E-2,1.0458E-2,5.2149487441271979E-2,3.3200000000000003]
[167,6.7395631320711108E-2,1.0521000000000001E-2,5.2463629423326726E-2,3.3400000000000003]
[168,9.3638226665577709E-2,1.0583999999999998E-2,5.2777771197153302E-2,3.3599999999999994]
[169,0.12276960305432126,1.0646999999999998E-2,5.3091912761504927E-2,3.3799999999999994]
[170,0.15414831280958066,1.0709999999999999E-2,5.340605411513475E-2,3.4000000000000004]
[171,0.18712332407583593,1.0773E-2,5.3720195256795937E-2,3.4200000000000004]
[172,0.2210440307865861,1.0836E-2,5.4034336185241678E-2,3.44]
[173,0.25526991781626479,1.0898999999999999E-2,5.4348476899225125E-2,3.46]
[174,0.28917975207068453,1.0962E-2,5.4662617397499481E-2,3.48]
[175,0.32218018128759351,1.1025E-2,5.4976757678817899E-2,3.5]
[176,0.35371363466502137,1.1088000000000001E-2,5.5290897741933576E-2,3.52]
[177,0.38326543289413756,1.1150999999999999E-2,5.5605037585599669E-2,3.54]
[178,0.41037002952691459,1.1214E-2,5.5919177208569371E-2,3.56]
[179,0.43461632062868105,1.1276999999999999E-2,5.6233316609595851E-2,3.5799999999999996]
[180,0.45565197511087974,1.1339999999999999E-2,5.6547455787432317E-2,3.6]
[181,0.47318675379859676,1.1403E-2,5.6861594740831918E-2,3.62]
[182,0.48699480090838404,1.1465999999999999E-2,5.7175733468547853E-2,3.6399999999999992]
[183,0.49691590700235022,1.1528999999999999E-2,5.7489871969333306E-2,3.66]
[184,0.50285575740922794,1.1592E-2,5.7804010241941456E-2,3.68]
[185,0.50478519438274583,1.1655E-2,5.811814828512548E-2,3.7]
[186,0.50273853470680019,1.1718000000000001E-2,5.8432286097638585E-2,3.72]
[187,0.49681099689901598,1.1781E-2,5.874642367823394E-2,3.74]
[188,0.48715530345197805,1.1844E-2,5.9060561025664739E-2,3.7600000000000002]
[189,0.47397753356699079,1.1907000000000001E-2,5.9374698138684179E-2,3.7800000000000002]
[190,0.45753231046491083,1.1970000000000001E-2,5.9688835016045431E-2,3.8000000000000007]
[191,0.43811741452648262,1.2033000000000002E-2,6.0002971656501709E-2,3.8200000000000007]
[192,0.41606791915323149,1.2095999999999999E-2,6.0317108058806169E-2,3.8400000000000003]
[193,{"$f":"intensi(D202,$B$2)","v":0.39174995031817494},{"$f":"A202*0.01*$B$1/($B$4/2)","v":1.2158999999999998E-2},{"$f":"2*PI()/$B$1*$B$2*$B$4/2*SIN(C202)","v":6.0631244221712045E-2},{"$f":"C202/($B$1/2)*$B$4/2","v":3.8599999999999994}]
[194,0.36555417327561912,1.2221999999999998E-2,6.0945380143972508E-2,3.8799999999999994]
[195,0.33788911083363188,1.2284999999999999E-2,6.1259515824340763E-2,3.9000000000000004]
[196,0.30917439698570603,1.2348E-2,6.1573651261570009E-2,3.9200000000000004]
[197,0.27983406761056318,1.2411E-2,6.1887786454413424E-2,3.9400000000000004]
[198,0.25028998644417072,1.2473999999999999E-2,6.2201921401624199E-2,3.9600000000000004]
[199,0.22095549969840844,1.2537E-2,6.2516056101955569E-2,3.98]
[200,0.19222940665700977,1.26E-2,6.2830190554160698E-2,4]

{"sheet":"Tabelle2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}