{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ReadMe","Filter"],"not_rendered":{"charts":3,"images":0,"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":"ReadMe","index":0,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Apply cosine roll-off filter to wave",null,null,null,null,null,null,null,null,null,null,null,null,null,"f","s"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
["Coded by","Kazuyuki Izuno",null,"Prof., Dept. of Civil and Environmental Eng., Ritsumeikan University",null,null,null,null,null,null,null,null,null,null,2,1]
[null,null,null,"izuno@se.ritsumei.ac.jp",null,null,null,null,null,null,null,null,null,null,2.1,{"$f":"0.5+0.5*COS(O4-2)","v":0.99750208263901285}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2000000000000002,{"$f":"0.5+0.5*COS(O5-2)","v":0.99003328892062081}]
["Usage",null,null,null,null,null,null,null,null,null,null,null,null,null,2.2999999999999998,0.9776682445628031]
[1,"Input cells in A-column. See the right figure for the parameters.",null,null,null,null,null,null,null,null,null,null,null,null,2.4,0.96053049700144255]
[null,"Band Pass Filter: Set lower and upper cutoff frequencies.",null,null,null,null,null,null,null,null,null,null,null,null,2.5,0.93879128094518638]
[null,"Low Pass Filter: Delete value in A6, and set the upper cutoff frequency in A8.",null,null,null,null,null,null,null,null,null,null,null,null,2.6,0.91266780745483911]
[null,"High Pass Filter: Delete value in A8, and set the lower cutoff frequency in A6.",null,null,null,null,null,null,null,null,null,null,null,null,2.7,0.88242109364224408]
[2,"Paste your data to B- and C-columns.",null,null,null,null,null,null,null,null,null,null,null,null,2.8,0.84835335467358275]
[3,"Click the Macros command button on the View tab, and select \"filter.\"",null,null,null,null,null,null,null,null,null,null,null,null,2.9,0.8108049841353322]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0.77015115293406988]
["Versions","2018-05-14"," ver.1.0",null,null,null,null,null,null,null,null,null,null,null,3.1,0.72679806071278863]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2,0.6811788772383367]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.3,0.63374941431229381]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.4,0.58498357145012048]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5,0.5353686008338514]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.6,0.48540023884935557]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.7,0.43557775285223754]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.8,0.38639895265345658]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.9,{"$f":"0.5+0.5*COS(O22-2)","v":0.3383552165682483}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0.29192658172642882]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.0999999999999996,0.24757694770007144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2,0.20574944137232709]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3,0.16686198936008795]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.4000000000000004,0.13130314222937711]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5,9.9428192226533152E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5999999999999996,{"$f":"0.5+0.5*COS(O29-2)","v":7.1555623315526451E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.7,4.7963928991469396E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.8,2.8888829665670968E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.9000000000000004,1.4520917425204671E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5.0037516997772924E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.0999999999999996,{"$f":"0.5+0.5*COS(O34-2)","v":4.3242486336025898E-4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.2,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0]

{"sheet":"Filter","index":1,"n_rows":130,"n_cols":7,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
["Time increment (s)","Time (s)","Wave","Filtered wave","Frequency (Hz)","Fourier Amp.","Filtered Fourier Amp."]
[0.05,0,{"$f":"SIN(2*PI()*B2)+2*SIN(4*PI()*B2)+1.5*SIN(8*PI()*B2)","v":0},1.0007680515371491,0,2.4618690739426283E-15,2.4602991519062338E-15]
["Number of data",{"$f":"B2+$A$2","v":0.05},{"$f":"SIN(2*PI()*B3)+2*SIN(4*PI()*B3)+1.5*SIN(8*PI()*B3)","v":2.9111722734026237},1.7939594898752196,7.8125E-2,0.107272817506619,0.10720513058799175]
[100,{"$f":"B3+$A$2","v":0.1},3.3715761633214898,2.3930022691867592,0.15625,7.3032908360714938E-2,7.2987255410119509E-2]
["Lower cutoff frequency (Hz)",0.15000000000000002,1.8294521485265447,2.5099231985387069,0.234375,6.0248110791806156E-2,6.0209964511152056E-2]
[null,0.2,0.70004224643736945,2.0126516710232814,0.3125,0.11797273786317342,0.11789738811775625]
["Upper cutoff frequency (Hz)",0.25,0.99999999999999989,1.0157662998177182,0.390625,1.8289733605002443E-2,1.8278233217893469E-2]
[3,0.3,1.2020707861529378,-0.14071177932778445,0.46875,0.11526311098155087,0.11519130269996104]
["Transition bandwidth (Hz)",0.35,-0.21141815977664957,-1.0258790356792744,0.546875,0.1030907666244333,0.10302526559268184]
[0.5,0.39999999999999997,-2.1960056587365431,-1.3076427607023449,0.625,5.7887159728566354E-2,5.7849990543292727E-2]
[null,0.44999999999999996,-2.2931382846527315,-0.90763842646319515,0.703125,0.16956797713341742,0.16946173699281467]
[null,0.49999999999999994,-5.0994364980683216E-15,-4.5393503417380077E-2,0.78125,5.8385581811479625E-2,5.8349499861848238E-2]
[null,0.54999999999999993,2.2931382846527266,0.85192195231108325,0.859375,0.21378859307704387,0.2136522693946708]
[null,0.6,2.1960056587365444,1.3342608751113447,0.9375,0.40708710715795393,0.40682281889901584]
[null,0.65,0.2114181597766509,1.1248599164232749,1.015625,0.36370751666523043,0.3634804715979385]
[null,0.70000000000000007,-1.2020707861529374,0.24146234515218806,1.09375,0.1660694012856698,0.16596843996292418]
[null,0.75000000000000011,-0.99999999999999867,-1.007784235321278,1.171875,1.7832102134973632E-2,1.7820692039793438E-2]
[null,0.80000000000000016,-0.70004224643737012,-2.1481428022489744,1.25,6.5419197672330542E-3,6.5375793675625047E-3]
[null,0.8500000000000002,-1.8294521485265482,-2.7266729030405754,1.328125,3.6343826123044702E-2,3.632121013620241E-2]
[null,0.90000000000000024,-3.3715761633214942,-2.4876806900418234,1.40625,6.2871329992354999E-3,6.2834400434635318E-3]
[null,0.95000000000000029,-2.9111722734026144,-1.4685557181306039,1.484375,8.3809276645709557E-2,8.3755530549156354E-2]
[null,1.0000000000000002,1.6844598632603791E-14,1.559997937294693E-2,1.5625,6.1395711675765657E-2,6.1353108756450898E-2]
[null,1.0500000000000003,2.9111722734026331,1.4876524732764485,1.640625,8.3657185906699585E-2,8.3605150041906245E-2]
[null,1.1000000000000003,3.3715761633214858,2.4793935066111921,1.71875,0.17510558141484478,0.17501089985239035]
[null,1.1500000000000004,1.8294521485265318,2.6963193275874229,1.796875,1.2480179634588371E-2,1.2472202855401281E-2]
[null,1.2000000000000004,0.70004224643736679,2.1187027132896654,1.875,0.37896638432155128,0.37867497255099963]
[null,1.2500000000000004,1.0000000000000047,1.0035244992706485,1.953125,0.72243769761356558,0.72198320406076288]
[null,1.3000000000000005,1.2020707861529321,-0.21401184857454081,2.03125,0.74229443602766143,0.74198854685607285]
[null,1.3500000000000005,-0.21141815977667155,-1.0845439112284425,2.109375,0.4311780960009674,0.43091009812398029]
[null,1.4000000000000006,-2.1960056587365577,-1.3139136336809103,2.1875,4.7720656562274581E-2,4.7672486958484007E-2]
[null,1.4500000000000006,-2.293138284652716,-0.87351929296206521,2.265625,0.14140451562005787,0.14130979703558505]
[null,1.5000000000000007,2.8666522280951234E-14,-8.116046592114564E-3,2.34375,9.323870864919459E-2,9.3247780248114837E-2]
[null,1.5500000000000007,2.2931382846527493,0.86360154606021045,2.421875,3.104277750443794E-2,3.1026368813339009E-2]
[null,1.6000000000000008,2.1960056587365218,1.3181077234232814,2.5,7.201956088179931E-2,7.1852390525067894E-2]
[null,1.6500000000000008,0.21141815977661715,1.099788107629071,2.578125,1.9139505116341476E-2,1.9123080326600501E-2]
[null,1.7000000000000008,-1.2020707861529463,0.22856420130695948,2.65625,3.456129011016091E-2,3.4731571622309401E-2]
[null,1.7500000000000009,-0.99999999999999012,-1.0012241792801468,2.734375,2.9721959603750191E-2,2.9684229658072585E-2]
[null,1.8000000000000009,-0.70004224643737478,-2.1310322567517135,2.8125,5.06542810349797E-3,4.7847840122981593E-3]
[null,1.850000000000001,-1.8294521485265718,-2.7141606432915362,2.890625,1.798871959455561E-2,1.4562261010278826E-2]
[null,1.900000000000001,-3.3715761633215084,-2.488606690576129,2.96875,5.171735126161872E-3,3.086053815036488E-3]
[null,1.9500000000000011,-2.9111722734025838,-1.4799539557885399,3.046875,2.7132754525128243E-3,9.6630083156691072E-4]
[null,2.0000000000000009,5.3229122498610337E-14,4.2154418454864277E-3,3.125,2.6447481397593163E-3,4.1274152601875411E-4]
[null,2.0500000000000007,2.9111722734026531,1.485108146532637,3.203125,4.9069172789076439E-4,1.878730350034636E-5]
[null,2.1000000000000005,3.3715761633214814,2.4864522570861451,3.28125,1.6916084761741786E-2,5.3121513986864607E-5]
[null,2.1500000000000004,1.829452148526538,2.7063139601858817,3.359375,1.5660139511552186E-2,7.0920481788509795E-5]
[null,2.2000000000000002,0.70004224643736812,2.123568889792685,3.4375,2.0223241159973808E-2,2.045830734351143E-5]
[null,2.25,0.99999999999999889,0.99998848965914022,3.515625,4.7438234540980034E-2,6.7977424831953094E-5]
[null,2.2999999999999998,1.2020707861529416,-0.2225499812605275,3.59375,6.4038742449059154E-3,2.5977788449813426E-6]
[null,2.3499999999999996,-0.21141815977663436,-1.0911770443191631,3.671875,8.0144401337290699E-2,5.1316017197482975E-5]
[null,2.3999999999999995,-2.1960056587365253,-1.3136199378231483,3.75,8.8744007412507625E-2,1.6758459197969001E-5]
[null,2.4499999999999993,-2.2931382846527537,-0.86677815708102857,3.828125,8.3169777060024347E-2,2.8626593536120152E-5]
[null,2.4999999999999991,-5.3474802710895553E-14,-3.0722658998329899E-4,3.90625,0.37466191362590345,3.5989649368473419E-5]
[null,2.5499999999999989,2.2931382846527044,0.86640268952528898,3.984375,0.57511224296217189,1.1936842418730559E-4]
[null,2.5999999999999988,2.1960056587365777,1.3137751955525538,4.0625,0.51245967442049067,2.6272187159942277E-5]
[null,2.6499999999999986,0.21141815977671374,1.0917414821181377,4.140625,0.2280438927147545,3.0847528377777273E-5]
[null,2.6999999999999984,-1.2020707861529185,0.22308415799147069,4.21875,5.469174928672748E-2,1.5182243195211372E-6]
[null,2.7499999999999982,-1.0000000000000262,-0.9998991480046846,4.296875,0.1426463317354319,1.3292441447312814E-5]
[null,2.799999999999998,-0.70004224643735724,-2.123991864265923,4.375,4.4383999710765454E-2,6.5177813348076249E-7]
[null,2.8499999999999979,-1.8294521485264723,-2.7069188120460446,4.453125,7.2775293103403124E-2,4.8676993185271843E-6]
[null,2.8999999999999977,-3.371576163321448,-2.4867693492052911,4.53125,7.5443839270074961E-2,5.3869852032020075E-7]
[null,2.9499999999999975,-2.911172273402725,-1.4848938410337924,4.609375,1.1153756401099335E-2,5.5254052143184559E-7]
[null,2.9999999999999973,-2.0348523213642444E-13,-3.6393135443765993E-3,4.6875,6.7250674708530439E-2,1.8820821213260535E-7]
[null,3.0499999999999972,2.9111722734025012,1.4804437507494546,4.765625,3.2169576587352235E-2,1.2094039178058148E-6]
[null,3.099999999999997,3.3715761633215422,2.4886326074530691,4.84375,3.6564029265094625E-2,4.708215337291234E-8]
[null,3.1499999999999968,1.8294521485266566,2.7137091558231128,4.921875,5.0364175895496778E-2,1.4647792387974932E-6]
[null,3.1999999999999966,0.70004224643739299,2.1304616892981207,5,6.6805379839347197E-15,1.5185002984904505E-20]
[null,3.2499999999999964,{"$f":"SIN(2*PI()*B67)+2*SIN(4*PI()*B67)+1.5*SIN(8*PI()*B67)","v":0.99999999999995215},1.0009431609963053,5.078125,4.4163706832742872E-2,1.00896361006392E-6]
[null,{"$f":"B67+$A$2","v":3.2999999999999963},1.2020707861529809,-0.22842773465412364,5.15625,2.806646922227005E-2,8.7793704930829119E-8]
[null,3.3499999999999961,-0.21141815977649037,-1.099412314025515,5.234375,2.1537683543943198E-2,3.9126238961877388E-7]
[null,3.3999999999999959,-2.1960056587364303,-1.3177652305255472,5.3125,3.9043299269099475E-2,1.4176246832449618E-7]
[null,3.4499999999999957,-2.293138284652843,-0.86347108463234823,5.390625,5.5673270895199509E-3,8.1209001286955519E-8]
[null,3.4999999999999956,-2.6351382013956037E-13,7.9964233447789752E-3,5.46875,3.1981365063125884E-2,1.2410989670079643E-7]
[null,3.5499999999999954,2.2931382846526005,0.87323569221256059,5.546875,2.574331447473472E-2,3.0385260092218321E-7]
[null,3.5999999999999952,2.1960056587366736,1.3136560908890358,5.625,1.276697219488741E-2,5.0570772860866183E-8]
[null,3.649999999999995,0.21141815977685741,1.0845183024733753,5.703125,3.2061031848540943E-2,3.0806198786047978E-7]
[null,3.6999999999999948,-1.2020707861528821,0.21426245535729324,5.78125,8.9822053909400443E-3,3.5300361649727909E-8]
[null,3.7499999999999947,-1.0000000000000693,-1.0032157936764925,5.859375,2.3998592087495808E-2,1.8858548089400012E-7]
[null,3.7999999999999945,-0.7000422464373306,-2.118655754316082,5.9375,2.4026413247036596E-2,9.194687786282229E-8]
[null,3.8499999999999943,-1.8294521485263344,-2.6966264515973233,6.015625,6.8004026146541528E-3,4.3851454202108301E-8]
[null,3.8999999999999941,-3.3715761633213877,-2.4797728725055732,6.09375,2.7013595009460271E-2,9.9364826380173183E-8]
[null,3.949999999999994,-2.9111722734028556,-1.487696161058921,6.171875,1.1270452682260569E-2,5.9774917834331616E-8]
[null,3.9999999999999938,-4.4065966153805647E-13,-1.5192192960423958E-2,6.25,1.8122861806379741E-2,6.3474220740672271E-8]
[null,4.0499999999999936,2.9111722734023715,1.4690964433384779,6.328125,2.2552220983515663E-2,9.8513586940927527E-8]
[null,4.0999999999999934,3.3715761633216124,2.487896310506104,6.40625,2.3827421217351061E-3,7.8908734833377638E-9]
[null,4.1499999999999932,1.829452148526775,2.7263871806339459,6.484375,2.3001181193583284E-2,8.2803801702485502E-8]
[null,4.1999999999999931,0.70004224643741608,2.1475867337962065,6.5625,1.2862081167277058E-2,4.0060021129668356E-8]
[null,4.2499999999999929,0.99999999999990918,1.007352143799777,6.640625,1.347739096412622E-2,3.9985404397923598E-8]
[null,4.2999999999999927,1.2020707861530178,-0.24153006231311525,6.71875,2.1176324785759489E-2,6.1771866784565679E-8]
[null,4.3499999999999925,-0.2114181597763225,-1.1245854938749114,6.796875,1.062948665979227E-3,2.5980378011912534E-9]
[null,4.3999999999999924,-2.1960056587363188,-1.3338365899884335,6.875,1.9607956278207824E-2,5.3392831183688057E-8]
[null,4.4499999999999922,-2.2931382846529322,-0.85158568464100837,6.953125,1.3974511269475416E-2,2.8128157191103E-8]
[null,4.499999999999992,-4.5756562601362294E-13,4.5447299537194161E-2,7.03125,9.6249233267865775E-3,2.4401926814516893E-8]
[null,4.5499999999999918,2.2931382846525112,0.90736095342639955,7.109375,1.9831421979392406E-2,3.2877133805430768E-8]
[null,4.5999999999999917,2.1960056587367847,1.3072158364513893,7.1875,3.8431346086062516E-3,9.0530217166112231E-9]
[null,4.6499999999999915,0.21141815977702527,1.0256364028576106,7.265625,1.6613463497969775E-2,2.2719658120594931E-8]
[null,4.6999999999999913,-1.2020707861528457,0.14086533424515302,7.34375,1.4731181112936186E-2,3.2191073684750362E-8]
[null,4.7499999999999911,-1.0000000000001124,-1.0153569776188682,7.421875,6.3205537442686715E-3,7.1601936121334324E-9]
[null,4.7999999999999909,-0.70004224643730706,-2.0123811525725666,7.5,1.8481936154888735E-2,3.7422099050830901E-8]
[null,4.8499999999999908,-1.8294521485262156,-2.510055765780236,7.578125,6.1372483088905872E-3,5.8092417099151719E-9]
[null,4.8999999999999906,-3.371576163321317,-2.3933928432132778,7.65625,1.3888672383309124E-2,2.603713702661907E-8]
[null,4.9499999999999904,-2.9111722734029857,-1.7941942127908401,7.734375,1.5207573276077798E-2,1.2209615723309395E-8]
[null,null,null,null,7.8125,3.4152274849630075E-3,5.9258566784917219E-9]
[null,null,null,null,7.890625,1.710666760496278E-2,1.1916940955508658E-8]
[null,null,null,null,7.96875,8.057766588016135E-3,1.2941398120547474E-8]
[null,null,null,null,8.046875,1.1352011540648348E-2,7.0682933508359843E-9]
[null,null,null,null,8.125,1.5451985612684118E-2,2.2984191442882893E-8]
[null,null,null,null,8.203125,8.123820416086878E-4,4.6728515797782123E-10]
[null,null,null,null,8.28125,1.5691245306306129E-2,2.1640026304361767E-8]
[null,null,null,null,8.359375,9.678668911056499E-3,5.3050625092578909E-9]
[null,null,null,null,8.4375,8.9484637054922239E-3,1.1461680359605819E-8]
[null,null,null,null,8.515625,1.5495947151522874E-2,8.2962966584404299E-9]
[null,null,null,null,8.59375,1.5536614152326139E-3,1.8527059722902879E-9]
[null,null,null,null,8.671875,1.4224467351366964E-2,7.5655448289768385E-9]
[null,null,null,null,8.75,1.1050198295649207E-2,1.2307595656485617E-8]
[null,null,null,null,8.828125,6.6386718227073932E-3,3.5428905670111762E-9]
[null,null,null,null,8.90625,1.5359832377290125E-2,1.6045182728202339E-8]
[null,null,null,null,8.984375,3.7293656841645359E-3,2.00683765588424E-9]
[null,null,null,null,9.0625,1.2696317527970142E-2,1.2503679826693353E-8]
[null,null,null,null,9.140625,1.2207050885206048E-2,6.6342854352070659E-9]
[null,null,null,null,9.21875,4.3928011050427722E-3,4.1042342328547438E-9]
[null,null,null,null,9.296875,1.5056012579094783E-2,8.2616886986093008E-9]
[null,null,null,null,9.375,5.7486969330015564E-3,5.1335845017122744E-9]
[null,null,null,null,9.453125,1.109672877275239E-2,6.1396920853920906E-9]
[null,null,null,null,9.53125,1.3173139159632648E-2,1.1340320959673559E-8]
[null,null,null,null,9.609375,2.1868120482512795E-3,1.217728253484205E-9]
[null,null,null,null,9.6875,1.4590618412165987E-2,1.2225546426060079E-8]
[null,null,null,null,9.765625,7.6372098141640797E-3,4.2712844054880451E-9]
[null,null,null,null,9.84375,9.4146551247055905E-3,7.7588061898370551E-9]
[null,null,null,null,9.921875,1.39644305617437E-2,7.8269791892803178E-9]
[null,null,null,null,10,2.4271746044230921E-15,1.9891271467519803E-21]