{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Rating from tested data","Full Octave","Generalized Example one test pt","Loudness Index Table"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":3,"defined_names":32,"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":"Rating from tested data","index":0,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,1,49,8],[14,3,14,4],[20,9,20,12],[48,1,48,8],[21,1,21,8],[3,2,3,3],[4,2,4,3],[5,2,5,3],[12,3,12,4],[13,3,13,4]]}
[]
["Product Information"]
[]
["Company Name:",null,"ABC Company"]
["Trade Name:",null,"Model ABC"]
["Model Number:",null,"ABC 101"]
["Impeller Diameter:",null,18.25,"in"]
["Number of Blades:",null,7]
[]
[]
["Options"]
[]
["Sone Type:",null,null,"Hemispherical"]
["Data Format:",null,null,"Full Octave"]
["Sound Power Spectrum:",null,null,"Generalized"]
[]
["Test Data"]
[]
["Test Number:",null,null,12345,"S1"]
[]
[null,null,null,null,null,null,null,null,null,"Points of Operation"]
[null,"Full Octave Sound Power Results (dB)",null,null,null,null,null,null,null,"Speed","Static Pressure","Total Pressure","Fan Airflow"]
["Octave Band",1,2,3,4,5,6,7,8,"N","PS","PT","Q"]
["Center Frequency, f (Hz)",63,125,250,500,1000,2000,4000,8000,"rpm","in wg","in wg","cfm"]
[1,78.400000000000006,79.099999999999994,86,82.7,80.3,79.099999999999994,74.599999999999994,67.2,2000,0]
[2,75.099999999999994,79.2,83.6,78.7,76.2,74.7,69.599999999999994,62.4,2000,1.56]
[3,78.5,80.900000000000006,81.7,75.400000000000006,72.8,72.5,68.2,63.5,2000,2.4700000000000002]
[4,78.900000000000006,80.900000000000006,81.7,75,72,71.5,67.2,62.9,2000,2.63]
[null,80.2,81.400000000000006,82.4,75.8,72.400000000000006,71.099999999999994,66.900000000000006,63.4,2000,2.75]
[]
[]
[]
[]
["Published Sound Performance Ratings"]
[]
[]
["Company Name:",null,"ABC Company"]
["Trade Name:",null,"Model ABC"]
["Model Number:",null,"ABC 101"]
["Impeller Diameter:",null,18.25,"in"]
["Number of Blades:",null,7]
[]
[]
["Ratings "]
[]
["New Speed",null,2500,"rpm"]
["Static Pressure",null,2,"in wg"]
[]
[null,"Full Octave Sound Power Results (dB)"]
[null,"Octave Band"]
[null,1,2,3,4,5,6,7,8]
[null,63,125,250,500,1000,2000,4000,8000,"LWA (dB)","Loudness (sones)"]
[null,{"$f":"'Full Octave'!D97","v":80.537808342710505},{"$f":"'Full Octave'!E97","v":80.537808342710505},{"$f":"'Full Octave'!F97","v":88.87626988117205},{"$f":"'Full Octave'!G97","v":92.164049298013055},{"$f":"'Full Octave'!H97","v":81.135625375280682},{"$f":"'Full Octave'!I97","v":80.098388844892483},{"$f":"'Full Octave'!J97","v":79.354647946598902},{"$f":"'Full Octave'!K97","v":71.957792960007154},{"$f":"10*LOG10(10^((B53-26.2)/10)+10^((C53-16.1)/10)+10^((D53-8.6)/10)+10^((E53-3)/10)+10^((F53+0)/10)+10^((G53+1.2)/10)+10^((H53+1)/10)+10^((I53-1.1)/10))","v":91.205573227003939},{"$f":"'Full Octave'!C127","v":30.616603570990922}]

{"sheet":"Full Octave","index":1,"n_rows":127,"n_cols":16,"rows_kept":127,"cut":false,"hidden":true,"merged":[[10,2,10,9],[18,2,18,9],[17,12,17,15],[38,1,43,1],[34,11,37,11],[34,14,37,14],[34,13,37,13],[34,12,37,12]]}
["AMCA Standard 301 Worksheet"]
[{"$f":"'Rating from tested data'!D15 &\" Sound Power Level Method\"","v":"Generalized Sound Power Level Method"}]
[]
["Comparison Data"]
[]
[null,"Company:",{"$f":"IF(ISTEXT('Rating from tested data'!C37),'Rating from tested data'!C37,\"\")","v":"ABC Company"}]
[null,"Model:",{"$f":"IF(ISTEXT('Rating from tested data'!C39),'Rating from tested data'!C39,\"\")","v":"ABC 101"}]
[null,"Comparison ID:",{"$f":"IF(ISTEXT('Rating from tested data'!#REF!),'Rating from tested data'!#REF!,\"\")","v":""}]
[null,"Impeller Diameter (Dc):",null,{"$f":"IF('Rating from tested data'!D40=\"mm\", 'Rating from tested data'!C40/25.4, 'Rating from tested data'!C40)","v":18.25},"inch"]
[]
[null,null,"Sound Power Levels (dB)",null,null,null,null,null,null,null,null,null,"Speed","Static Pressure"]
[null,"Octave Band",1,2,3,4,5,6,7,8,null,null,"N","Ps"]
[null,"Center Freq., f (Hz)",63,125,250,500,1000,2000,4000,8000,"LWA (dB)","Loudness (sones)","rpm",{"$f":"'Rating from tested data'!D47","v":"in wg"}]
[null,"Catalog Point",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER('Rating from tested data'!C46),'Rating from tested data'!C46,\"-\")","v":2500},{"$f":"IF(ISNUMBER('Rating from tested data'!C47),'Rating from tested data'!C47,\"-\")","v":2}]
[]
["Change the comparison data to IP unit"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Points of Operation"]
[null,null,"Sound Power Levels (dB)",null,null,null,null,null,null,null,null,null,"Speed","Static Pressure","Total Pressure","Fan Airflow"]
[null,"Octave Band",1,2,3,4,5,6,7,8,null,null,"N","Ps","PT","Q"]
[null,"Center Freq., f (Hz)",63,125,250,500,1000,2000,4000,8000,"LWA (dB)","Loudness (sones)","rpm","in wg.","in wg.","cfm"]
[null,"Comparison Data",null,null,null,null,null,null,null,null,null,null,{"$f":"M14","v":2500},{"$f":"IF((ISNUMBER(N14)), (IF(N13=\"mm Aq\", N14/25.4,IF(N13=\"mm Hg\", N14*0.535, (IF(N13=\"Pa\", N14*0.00401, N14))))),\"-\")","v":2}]
[]
[]
["Base Test Conditions and Results"]
[]
[null,"Test Number:",null,{"$f":"IF(ISTEXT('Rating from tested data'!D19),'Rating from tested data'!D19,\"\")","v":""}]
[null,"Model:",null,{"$f":"IF(ISTEXT('Rating from tested data'!C6),'Rating from tested data'!C6,\"\")","v":"ABC 101"}]
[null,"Speed:",null,{"$f":"AVERAGE('Rating from tested data'!J25:J30)","v":2000},"rpm"]
[null,"Impeller Diameter (D):",null,{"$f":"IF('Rating from tested data'!D7=\"mm\",'Rating from tested data'!C7/25.4, 'Rating from tested data'!C7)","v":18.25},"in"]
[null,"Number of Blades (NB):",null,{"$f":"'Rating from tested data'!C8","v":7}]
[null,"Blade pass frequency (fbp)",null,{"$f":"D29*D31/60","v":233.33333333333334},"Hz"]
[]
[null,null,"Sound Power Results, Lwm (dB)",null,null,null,null,null,null,null,null,"Speed","Static Pressure","Total Pressure","Fan Airflow"]
[null,null,"Octave Band",1,2,3,4,5,6,7,8,"N (rpm)","Ps (in. wg)","PT (in. wg)","Q (cfm)"]
[null,null,"Center Freq., fc (Hz)",63,125,250,500,1000,2000,4000,8000]
[null,null,"Lower frequency (Hz)",45,90,180,355,710,1400,2800,5600]
[null,null,"Upper frequency (Hz)",90,180,355,710,1400,2800,5600,11200]
[null,"Determination #",1,{"$f":"IF(NOT(ISBLANK('Rating from tested data'!B25)),'Rating from tested data'!B25,\"-\")","v":78.400000000000006},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!C25)),'Rating from tested data'!C25,\"-\")","v":79.099999999999994},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!D25)),'Rating from tested data'!D25,\"-\")","v":86},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!E25)),'Rating from tested data'!E25,\"-\")","v":82.7},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!F25)),'Rating from tested data'!F25,\"-\")","v":80.3},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!G25)),'Rating from tested data'!G25,\"-\")","v":79.099999999999994},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!H25)),'Rating from tested data'!H25,\"-\")","v":74.599999999999994},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!I25)),'Rating from tested data'!I25,\"-\")","v":67.2},{"$f":"IF(ISNUMBER('Rating from tested data'!J25),'Rating from tested data'!J25,\"-\")","v":2000},{"$f":"IF(ISNUMBER('Rating from tested data'!K25), (IF('Rating from tested data'!$K$24=\"mm Aq\", ('Rating from tested data'!K25)/25.4, IF('Rating from tested data'!$K$24=\"mm Hg\", ('Rating from tested data'!K25)*0.535,(IF('Rating from tested data'!$K$24=\"Pa\", ('Rating from tested data'!K25)*0.00401, 'Rating from tested data'!K25))))),\"-\")","v":0},{"$f":"IF(ISNUMBER('Rating from tested data'!L25), (IF('Rating from tested data'!$L$24=\"mm Hg\", 'Rating from tested data'!L25/25.4,  IF('Rating from tested data'!$L$24=\"mm Hg\", 'Rating from tested data'!L25*0.535,IF('Rating from tested data'!$L$24=\"Pa\", 'Rating from tested data'!L25*0.00401, 'Rating from tested data'!L25)))),\"-\")","v":"-"},{"$f":"IF(ISNUMBER('Rating from tested data'!M25), (IF('Rating from tested data'!$M$24=\"m3/min\", 'Rating from tested data'!M25*35.31, (IF('Rating from tested data'!$M$24=\"m3/sec\", 'Rating from tested data'!M25*35.31*60, 'Rating from tested data'!M25)))),\"-\")","v":"-"}]
[null,null,2,{"$f":"IF(NOT(ISBLANK('Rating from tested data'!B26)),'Rating from tested data'!B26,\"-\")","v":75.099999999999994},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!C26)),'Rating from tested data'!C26,\"-\")","v":79.2},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!D26)),'Rating from tested data'!D26,\"-\")","v":83.6},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!E26)),'Rating from tested data'!E26,\"-\")","v":78.7},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!F26)),'Rating from tested data'!F26,\"-\")","v":76.2},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!G26)),'Rating from tested data'!G26,\"-\")","v":74.7},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!H26)),'Rating from tested data'!H26,\"-\")","v":69.599999999999994},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!I26)),'Rating from tested data'!I26,\"-\")","v":62.4},{"$f":"IF(ISNUMBER('Rating from tested data'!J26),'Rating from tested data'!J26,\"-\")","v":2000},{"$f":"IF(ISNUMBER('Rating from tested data'!K26), (IF('Rating from tested data'!$K$24=\"mm Aq\", ('Rating from tested data'!K26)/25.4, IF('Rating from tested data'!$K$24=\"mm Hg\", ('Rating from tested data'!K26)*0.535,(IF('Rating from tested data'!$K$24=\"Pa\", ('Rating from tested data'!K26)*0.00401, 'Rating from tested data'!K26))))),\"-\")","v":1.56},{"$f":"IF(ISNUMBER('Rating from tested data'!L26), (IF('Rating from tested data'!$L$24=\"mm Hg\", 'Rating from tested data'!L26/25.4,  IF('Rating from tested data'!$L$24=\"mm Hg\", 'Rating from tested data'!L26*0.535,IF('Rating from tested data'!$L$24=\"Pa\", 'Rating from tested data'!L26*0.00401, 'Rating from tested data'!L26)))),\"-\")","v":"-"},{"$f":"IF(ISNUMBER('Rating from tested data'!M26), (IF('Rating from tested data'!$M$24=\"m3/min\", 'Rating from tested data'!M26*35.31, (IF('Rating from tested data'!$M$24=\"m3/sec\", 'Rating from tested data'!M26*35.31*60, 'Rating from tested data'!M26)))),\"-\")","v":"-"}]
[null,null,3,{"$f":"IF(NOT(ISBLANK('Rating from tested data'!B27)),'Rating from tested data'!B27,\"-\")","v":78.5},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!C27)),'Rating from tested data'!C27,\"-\")","v":80.900000000000006},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!D27)),'Rating from tested data'!D27,\"-\")","v":81.7},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!E27)),'Rating from tested data'!E27,\"-\")","v":75.400000000000006},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!F27)),'Rating from tested data'!F27,\"-\")","v":72.8},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!G27)),'Rating from tested data'!G27,\"-\")","v":72.5},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!H27)),'Rating from tested data'!H27,\"-\")","v":68.2},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!I27)),'Rating from tested data'!I27,\"-\")","v":63.5},{"$f":"IF(ISNUMBER('Rating from tested data'!J27),'Rating from tested data'!J27,\"-\")","v":2000},{"$f":"IF(ISNUMBER('Rating from tested data'!K27), (IF('Rating from tested data'!$K$24=\"mm Aq\", ('Rating from tested data'!K27)/25.4, IF('Rating from tested data'!$K$24=\"mm Hg\", ('Rating from tested data'!K27)*0.535,(IF('Rating from tested data'!$K$24=\"Pa\", ('Rating from tested data'!K27)*0.00401, 'Rating from tested data'!K27))))),\"-\")","v":2.4700000000000002},{"$f":"IF(ISNUMBER('Rating from tested data'!L27), (IF('Rating from tested data'!$L$24=\"mm Hg\", 'Rating from tested data'!L27/25.4,  IF('Rating from tested data'!$L$24=\"mm Hg\", 'Rating from tested data'!L27*0.535,IF('Rating from tested data'!$L$24=\"Pa\", 'Rating from tested data'!L27*0.00401, 'Rating from tested data'!L27)))),\"-\")","v":"-"},{"$f":"IF(ISNUMBER('Rating from tested data'!M27), (IF('Rating from tested data'!$M$24=\"m3/min\", 'Rating from tested data'!M27*35.31, (IF('Rating from tested data'!$M$24=\"m3/sec\", 'Rating from tested data'!M27*35.31*60, 'Rating from tested data'!M27)))),\"-\")","v":"-"}]
[null,null,4,{"$f":"IF(NOT(ISBLANK('Rating from tested data'!B28)),'Rating from tested data'!B28,\"-\")","v":78.900000000000006},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!C28)),'Rating from tested data'!C28,\"-\")","v":80.900000000000006},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!D28)),'Rating from tested data'!D28,\"-\")","v":81.7},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!E28)),'Rating from tested data'!E28,\"-\")","v":75},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!F28)),'Rating from tested data'!F28,\"-\")","v":72},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!G28)),'Rating from tested data'!G28,\"-\")","v":71.5},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!H28)),'Rating from tested data'!H28,\"-\")","v":67.2},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!I28)),'Rating from tested data'!I28,\"-\")","v":62.9},{"$f":"IF(ISNUMBER('Rating from tested data'!J28),'Rating from tested data'!J28,\"-\")","v":2000},{"$f":"IF(ISNUMBER('Rating from tested data'!K28), (IF('Rating from tested data'!$K$24=\"mm Aq\", ('Rating from tested data'!K28)/25.4, IF('Rating from tested data'!$K$24=\"mm Hg\", ('Rating from tested data'!K28)*0.535,(IF('Rating from tested data'!$K$24=\"Pa\", ('Rating from tested data'!K28)*0.00401, 'Rating from tested data'!K28))))),\"-\")","v":2.63},{"$f":"IF(ISNUMBER('Rating from tested data'!L28), (IF('Rating from tested data'!$L$24=\"mm Hg\", 'Rating from tested data'!L28/25.4,  IF('Rating from tested data'!$L$24=\"mm Hg\", 'Rating from tested data'!L28*0.535,IF('Rating from tested data'!$L$24=\"Pa\", 'Rating from tested data'!L28*0.00401, 'Rating from tested data'!L28)))),\"-\")","v":"-"},{"$f":"IF(ISNUMBER('Rating from tested data'!M28), (IF('Rating from tested data'!$M$24=\"m3/min\", 'Rating from tested data'!M28*35.31, (IF('Rating from tested data'!$M$24=\"m3/sec\", 'Rating from tested data'!M28*35.31*60, 'Rating from tested data'!M28)))),\"-\")","v":"-"}]
[null,null,5,{"$f":"IF(NOT(ISBLANK('Rating from tested data'!B29)),'Rating from tested data'!B29,\"-\")","v":80.2},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!C29)),'Rating from tested data'!C29,\"-\")","v":81.400000000000006},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!D29)),'Rating from tested data'!D29,\"-\")","v":82.4},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!E29)),'Rating from tested data'!E29,\"-\")","v":75.8},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!F29)),'Rating from tested data'!F29,\"-\")","v":72.400000000000006},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!G29)),'Rating from tested data'!G29,\"-\")","v":71.099999999999994},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!H29)),'Rating from tested data'!H29,\"-\")","v":66.900000000000006},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!I29)),'Rating from tested data'!I29,\"-\")","v":63.4},{"$f":"IF(ISNUMBER('Rating from tested data'!J29),'Rating from tested data'!J29,\"-\")","v":2000},{"$f":"IF(ISNUMBER('Rating from tested data'!K29), (IF('Rating from tested data'!$K$24=\"mm Aq\", ('Rating from tested data'!K29)/25.4, IF('Rating from tested data'!$K$24=\"mm Hg\", ('Rating from tested data'!K29)*0.535,(IF('Rating from tested data'!$K$24=\"Pa\", ('Rating from tested data'!K29)*0.00401, 'Rating from tested data'!K29))))),\"-\")","v":2.75},{"$f":"IF(ISNUMBER('Rating from tested data'!L29), (IF('Rating from tested data'!$L$24=\"mm Hg\", 'Rating from tested data'!L29/25.4,  IF('Rating from tested data'!$L$24=\"mm Hg\", 'Rating from tested data'!L29*0.535,IF('Rating from tested data'!$L$24=\"Pa\", 'Rating from tested data'!L29*0.00401, 'Rating from tested data'!L29)))),\"-\")","v":"-"},{"$f":"IF(ISNUMBER('Rating from tested data'!M29), (IF('Rating from tested data'!$M$24=\"m3/min\", 'Rating from tested data'!M29*35.31, (IF('Rating from tested data'!$M$24=\"m3/sec\", 'Rating from tested data'!M29*35.31*60, 'Rating from tested data'!M29)))),\"-\")","v":"-"}]
[null,null,6,{"$f":"IF(NOT(ISBLANK('Rating from tested data'!B30)),'Rating from tested data'!B30,\"-\")","v":"-"},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!C30)),'Rating from tested data'!C30,\"-\")","v":"-"},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!D30)),'Rating from tested data'!D30,\"-\")","v":"-"},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!E30)),'Rating from tested data'!E30,\"-\")","v":"-"},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!F30)),'Rating from tested data'!F30,\"-\")","v":"-"},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!G30)),'Rating from tested data'!G30,\"-\")","v":"-"},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!H30)),'Rating from tested data'!H30,\"-\")","v":"-"},{"$f":"IF(NOT(ISBLANK('Rating from tested data'!I30)),'Rating from tested data'!I30,\"-\")","v":"-"},{"$f":"IF(ISNUMBER('Rating from tested data'!J30),'Rating from tested data'!J30,\"-\")","v":"-"},{"$f":"IF(ISNUMBER('Rating from tested data'!K30), (IF('Rating from tested data'!$K$24=\"mm Aq\", ('Rating from tested data'!K30)/25.4, IF('Rating from tested data'!$K$24=\"mm Hg\", ('Rating from tested data'!K30)*0.535,(IF('Rating from tested data'!$K$24=\"Pa\", ('Rating from tested data'!K30)*0.00401, 'Rating from tested data'!K30))))),\"-\")","v":"-"},{"$f":"IF(ISNUMBER('Rating from tested data'!L30), (IF('Rating from tested data'!$L$24=\"mm Hg\", 'Rating from tested data'!L30/25.4,  IF('Rating from tested data'!$L$24=\"mm Hg\", 'Rating from tested data'!L30*0.535,IF('Rating from tested data'!$L$24=\"Pa\", 'Rating from tested data'!L30*0.00401, 'Rating from tested data'!L30)))),\"-\")","v":"-"},{"$f":"IF(ISNUMBER('Rating from tested data'!M30), (IF('Rating from tested data'!$M$24=\"m3/min\", 'Rating from tested data'!M30*35.31, (IF('Rating from tested data'!$M$24=\"m3/sec\", 'Rating from tested data'!M30*35.31*60, 'Rating from tested data'!M30)))),\"-\")","v":"-"}]
[]
[]
["Calculations"]
[]
[]
[null,"Convert comparison performance point to test speed and impeller diameter using the fan laws to determine which data point(s) to use."]
[]
[null,null,"Psc' = Psc · (N / Nc)² · (d / dc)²"]
[null,null,"Psc'=",{"$f":"N22*(AVERAGE(L39:L44)/M22)^2*(D30/D9)^2","v":1.2800000000000002},"in wg"]
[null,"Determine the Blade Passage Frequency (BPF) for the test speed."]
[]
[null,null,"BPF = (N · NB) / 60"]
[]
[null,null,"Det.","N","Ps","BPF","Pt","Q"]
[null,"PC'","-",{"$f":"AVERAGE(L39:L44)","v":2000},{"$f":"D53","v":1.2800000000000002},{"$f":"M22/60*D31","v":291.66666666666663}]
[null,"P0",{"$f":"IF(E59<SMALL($M$39:$M$44,1),1,IF(E59>LARGE($M$39:$M$44,1),MATCH(LARGE($M$39:$M$44,1),$M$39:$M$44,0)-1,IF(E59=SMALL($M$39:$M$44,1),MATCH(E59,$M$39:$M$44,0),MATCH(E59,$M$39:$M$44,1))))","v":1},{"$f":"INDEX($L$39:$L$44,$C60,1)","v":2000},{"$f":"INDEX($M$39:$M$44,$C60,1)","v":0},{"$f":"D60/60*$D$31","v":233.33333333333334},{"$f":"INDEX($N$39:$N$44,$C60,1)","v":"-"},{"$f":"INDEX($O$39:$O$44,$C60,1)","v":"-"}]
[null,"P1",{"$f":"IF(E59>INDEX(M39:M44,C60,1),C60+1,IF(E59<INDEX(M39:M44,C60,1),C60+1,C60))","v":2},{"$f":"INDEX($L$39:$L$44,$C61,1)","v":2000},{"$f":"INDEX($M$39:$M$44,$C61,1)","v":1.56},{"$f":"D61/60*$D$31","v":233.33333333333334},{"$f":"INDEX($N$39:$N$44,$C61,1)","v":"-"},{"$f":"INDEX($O$39:$O$44,$C61,1)","v":"-"}]
[]
[]
[null,"For P0 and P1, the measured sound power level for each octave band."]
[]
[null,null,"Extrapolated Left",null,null,null,null,null,null,null,null,"Extrapolated Right"]
[null,"Octave Band",null,1,2,3,4,5,6,7,8]
[null,"Center Freq., f (Hz)",null,63,125,250,500,1000,2000,4000,8000]
[null,"Lower f (Hz)",null,45,90,180,355,710,1400,2800,5600]
[null,"Upper f (Hz)",null,90,180,355,710,1400,2800,5600,11200]
[null,"Postion of Blade Pass Frequency",null,{"$f":"IF(AND($F$60>D69,$F$60<=D70),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND($F$60>E69,$F$60<=E70),\"Yes\",\"No\")","v":"No"},"Yes","No","No","No","No","No"]
[null,"Test Lw0 (dB)",null,{"$f":"INDEX($D$39:$K$44,$C$60,D67)","v":78.400000000000006},79.099999999999994,86,82.7,80.3,79.099999999999994,74.599999999999994,67.2]
[null,"X0",0,{"$f":"10*LOG(D68/$D$60)+20","v":4.9831055378960052},{"$f":"10*LOG(E68/$D$60)+20","v":7.9588001734407516},10.969100130080564,13.979400086720375,16.989700043360187,20,23.010299956639813,26.020599913279625,{"$f":"IF(K74<J74,((K73-J73)/(K74-J74))*(L74-K74)+K73,K73+ABS(K73-J73))","v":48.366869718989406}]
[null,{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",\"Lwg0 (dB)\",\"Lwk0 (dB)\")","v":"Lwg0 (dB)"},{"$f":"D74","v":66.132199097805085},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",D72-50*LOG10($D$60/1000)-70*LOG10($D$30/20),D72-10*LOG10($H$60)-20*LOG10($G$60))","v":66.132199097805085},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",E72-50*LOG10($D$60/1000)-70*LOG10($D$30/20),E72-10*LOG10($H$60)-20*LOG10($G$60))","v":66.832199097805074},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",F72-50*LOG10($D$60/1000)-70*LOG10($D$30/20),F72-10*LOG10($H$60)-20*LOG10($G$60))","v":73.732199097805079},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",G72-50*LOG10($D$60/1000)-70*LOG10($D$30/20),G72-10*LOG10($H$60)-20*LOG10($G$60))","v":70.432199097805082},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",H72-50*LOG10($D$60/1000)-70*LOG10($D$30/20),H72-10*LOG10($H$60)-20*LOG10($G$60))","v":68.032199097805076},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",I72-50*LOG10($D$60/1000)-70*LOG10($D$30/20),I72-10*LOG10($H$60)-20*LOG10($G$60))","v":66.832199097805074},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",J72-50*LOG10($D$60/1000)-70*LOG10($D$30/20),J72-10*LOG10($H$60)-20*LOG10($G$60))","v":62.332199097805074},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",K72-50*LOG10($D$60/1000)-70*LOG10($D$30/20),K72-10*LOG10($H$60)-20*LOG10($G$60))","v":54.932199097805082},{"$f":"IF(K74<J74,0,((K74-J74)/(K73-J73)*(L73-J73)+J74))","v":0}]
[null,"Test Lw1 (dB)",null,{"$f":"INDEX($D$39:$K$44,$C$61,D67)","v":75.099999999999994},79.2,83.6,78.7,76.2,74.7,69.599999999999994,62.4]
[null,"X1",0,{"$f":"10*LOG(D68/$D$61)+20","v":4.9831055378960052},{"$f":"10*LOG(E68/$D$61)+20","v":7.9588001734407516},10.969100130080564,13.979400086720375,16.989700043360187,20,23.010299956639813,26.020599913279625,{"$f":"IF(K77<J77,((K76-J76)/(K77-J77))*(L77-K77)+K76,K76+ABS(K76-J76))","v":46.980732798054817}]
[null,{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",\"Lwg1 (dB)\",\"Lwk1 (dB)\")","v":"Lwg1 (dB)"},{"$f":"D77","v":62.832199097805074},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",D75-50*LOG10($D$61/1000)-70*LOG10($D$30/20),D75-10*LOG10($H$61)-20*LOG10($G$61))","v":62.832199097805074},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",E75-50*LOG10($D$61/1000)-70*LOG10($D$30/20),E75-10*LOG10($H$61)-20*LOG10($G$61))","v":66.932199097805082},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",F75-50*LOG10($D$61/1000)-70*LOG10($D$30/20),F75-10*LOG10($H$61)-20*LOG10($G$61))","v":71.332199097805074},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",G75-50*LOG10($D$61/1000)-70*LOG10($D$30/20),G75-10*LOG10($H$61)-20*LOG10($G$61))","v":66.432199097805082},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",H75-50*LOG10($D$61/1000)-70*LOG10($D$30/20),H75-10*LOG10($H$61)-20*LOG10($G$61))","v":63.932199097805082},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",I75-50*LOG10($D$61/1000)-70*LOG10($D$30/20),I75-10*LOG10($H$61)-20*LOG10($G$61))","v":62.432199097805082},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",J75-50*LOG10($D$61/1000)-70*LOG10($D$30/20),J75-10*LOG10($H$61)-20*LOG10($G$61))","v":57.332199097805074},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",K75-50*LOG10($D$61/1000)-70*LOG10($D$30/20),K75-10*LOG10($H$61)-20*LOG10($G$61))","v":50.132199097805085},{"$f":"IF(K77<J77,0,((K77-J77)/(K76-J76)*(L76-J76)+J77))","v":0}]
[]
[null,"Blade Pass Frequency",null,"X =",{"$f":"INDEX(D73:K73,MATCH(\"Yes\",D71:K71,0))","v":10.969100130080564},"&","LWG0 =",{"$f":"INDEX(D74:K74,MATCH(\"Yes\",D71:K71,0))","v":73.732199097805079}]
[]
[null,"Using Comparison Data"]
[]
[null,"Octave Band",null,1,2,3,4,5,6,7,8]
[null,"Center Freq., f (Hz)",null,63,125,250,500,1000,2000,4000,8000]
[null,"Lower f (Hz)",null,45,90,180,355,710,1400,2800,5600]
[null,"Upper f (Hz)",null,90,180,355,710,1400,2800,5600,11200]
[null,"Postion of Blade Pass Frequency",null,{"$f":"IF(AND($D$32>=D85,$D$32<=D86),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND($D$32>=E85,$D$32<=E86),\"Yes\",\"No\")","v":"No"},"Yes","No","No","No","No","No"]
[null,"Xc",null,{"$f":"10*LOG10(D84/$M$22)+20","v":4.0140054078154428},{"$f":"10*LOG10(E84/$M$22)+20","v":6.9897000433601875},10,13.010299956639813,16.020599913279625,19.030899869919438,22.041199826559247,25.051499783199063]
[null,"Interpolation Index",null,{"$f":"IF(D$88<0, 1, IF(D$88>$L73,9,MATCH(D88,$C73:$L73,1)-1))","v":0},1,2,3,4,5,6,7]
[null,{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\", \"Inter Lwgc0\", \"Inter Lwkc0\")","v":"Inter Lwgc0"},null,{"$f":"(D$88-INDEX($C$73:$L$73,D$89))/(INDEX($C$73:$L$73,D$89+1)-INDEX($C$73:$L$73,D$89))*(INDEX($C$74:$L$74,D$89+1)-INDEX($C$74:$L$74,D$89))+INDEX($C$74:$L$74,D$89)","v":66.132199097805085},66.132199097805085,67.312369294546343,78.41089524308228,68.194561810933379,66.404826525534745,66.018512811669908,59.280875524798205]
[null,{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\", \"BPF Lwgc0 (dB)\", \"BPF Lwkc0 (dB)\")","v":"BPF Lwgc0 (dB)"},null,{"$f":"IF(D87=\"Yes\",D74,\"\")","v":""},"",73.732199097805079,"","","","",""]
[null,{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",\"Lwgc0 (dB)\",\"Lwkc0 (dB)\")","v":"Lwgc0 (dB)"},null,{"$f":"MAX(D90,D91)","v":66.132199097805085},{"$f":"MAX(E90,E91)","v":66.132199097805085},{"$f":"MAX(F90,F91)","v":73.732199097805079},78.41089524308228,68.194561810933379,66.404826525534745,66.018512811669908,59.280875524798205]
[null,{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\", \"Inter Lwgc1\", \"Inter Lwkc1\")","v":"Inter Lwgc1"},null,{"$f":"(D$88-INDEX($C$76:$L$76,D$89))/(INDEX($C$76:$L$76,D$89+1)-INDEX($C$76:$L$76,D$89))*(INDEX($C$77:$L$77,D$89+1)-INDEX($C$77:$L$77,D$89))+INDEX($C$77:$L$77,D$89)","v":62.832199097805074},62.832199097805074,69.744624535861121,74.315715480300668,63.109646762753158,62.23701933502349,61.415091240136128,53.874032381730615]
[null,{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",\"BPF Lwgc1 (dB)\",\"BPF Lwkc1 (dB)\")","v":"BPF Lwgc1 (dB)"},null,{"$f":"IF(D87=\"Yes\",D77,\"\")","v":""},"",71.332199097805074,"","","","",""]
[null,{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",\"Lwgc1 (dB)\",\"Lwkc1 (dB)\")","v":"Lwgc1 (dB)"},null,{"$f":"MAX(D93,D94)","v":62.832199097805074},{"$f":"MAX(E93,E94)","v":62.832199097805074},71.332199097805074,74.315715480300668,63.109646762753158,62.23701933502349,61.415091240136128,53.874032381730615]
[null,{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",\"Lwgc (dB)\",\"Lwkc (dB)\")","v":"Lwgc (dB)"},null,{"$f":"IF(NOT($C$60=$C$61),((D95-D92)/($E$61-$E$60))*($E$59-$E$60)+D92,D92)","v":63.424506790112765},{"$f":"IF(NOT($C$60=$C$61),((E95-E92)/($E$61-$E$60))*($E$59-$E$60)+E92,E92)","v":63.424506790112765},71.762968328574303,75.050747745415322,64.022323822682935,62.985087292294743,62.241346394001162,54.844491407409414]
[null,"LWC (dB)",null,{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",D$96+50*LOG10($M$22/1000)+70*LOG10($D$9/20),D$96+10*LOG10($M$22)+20*LOG10($O$22))","v":80.537808342710505},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",E$96+50*LOG10($M$22/1000)+70*LOG10($D$9/20),E$96+10*LOG10($M$22)+20*LOG10($O$22))","v":80.537808342710505},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",F$96+50*LOG10($M$22/1000)+70*LOG10($D$9/20),F$96+10*LOG10($M$22)+20*LOG10($O$22))","v":88.87626988117205},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",G$96+50*LOG10($M$22/1000)+70*LOG10($D$9/20),G$96+10*LOG10($M$22)+20*LOG10($O$22))","v":92.164049298013055},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",H$96+50*LOG10($M$22/1000)+70*LOG10($D$9/20),H$96+10*LOG10($M$22)+20*LOG10($O$22))","v":81.135625375280682},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",I$96+50*LOG10($M$22/1000)+70*LOG10($D$9/20),I$96+10*LOG10($M$22)+20*LOG10($O$22))","v":80.098388844892483},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",J$96+50*LOG10($M$22/1000)+70*LOG10($D$9/20),J$96+10*LOG10($M$22)+20*LOG10($O$22))","v":79.354647946598902},{"$f":"IF('Rating from tested data'!$D$15=\"Generalized\",K$96+50*LOG10($M$22/1000)+70*LOG10($D$9/20),K$96+10*LOG10($M$22)+20*LOG10($O$22))","v":71.957792960007154}]
[]
[null,"Find the corresponding sound pressure levels at a distance of 5 ft. for spherical and hemispherical sone calculation"]
[]
[null,null,"Lp(hemispherical) = Lwcm - 11.5"]
[null,null,"Lp(spherical) = Lwcm - 14.65"]
[]
[null,null,{"$f":"IF('Rating from tested data'!D13=\"Hemispherical\",\"Presenting data in Hemispherical Sones\",\"Presenting data in Spherical Sones\")","v":"Presenting data in Hemispherical Sones"}]
[]
[null,"Octave Band",1,2,3,4,5,6,7,8]
[null,"Center Freq., fc (Hz)",63,125,250,500,1000,2000,4000,8000]
[null,"Lp (dB)",{"$f":"IF('Rating from tested data'!$D$13=\"Hemispherical\",IF(D97>11.5,D97-11.5,0),IF('Rating from tested data'!$D$13=\"Spherical\",IF(D97>14.65,D97-14.65,0)))","v":69.037808342710505},{"$f":"IF('Rating from tested data'!$D$13=\"Hemispherical\",IF(E97>11.5,E97-11.5,0),IF('Rating from tested data'!$D$13=\"Spherical\",IF(E97>14.65,E97-14.65,0)))","v":69.037808342710505},{"$f":"IF('Rating from tested data'!$D$13=\"Hemispherical\",IF(F97>11.5,F97-11.5,0),IF(F97>14.65,F97-14.65,0))","v":77.37626988117205},{"$f":"IF('Rating from tested data'!$D$13=\"Hemispherical\",IF(G97>11.5,G97-11.5,0),IF(G97>14.65,G97-14.65,0))","v":80.664049298013055},{"$f":"IF('Rating from tested data'!$D$13=\"Hemispherical\",IF(H97>11.5,H97-11.5,0),IF(H97>14.65,H97-14.65,0))","v":69.635625375280682},{"$f":"IF('Rating from tested data'!$D$13=\"Hemispherical\",IF(I97>11.5,I97-11.5,0),IF(I97>14.65,I97-14.65,0))","v":68.598388844892483},{"$f":"IF('Rating from tested data'!$D$13=\"Hemispherical\",IF(J97>11.5,J97-11.5,0),IF(J97>14.65,J97-14.65,0))","v":67.854647946598902},{"$f":"IF('Rating from tested data'!$D$13=\"Hemispherical\",IF(K97>11.5,K97-11.5,0),IF(K97>14.65,K97-14.65,0))","v":60.457792960007154}]
[]
[]
[null,{"$f":"IF('Rating from tested data'!D13=\"Hemispherical\", \"Calculate loudness in fan (hemispherical) sones.\", \"Calculate loudness in spherical sones.\")","v":"Calculate loudness in fan (hemispherical) sones."}]
[]
[null,null,"Using the loudness index table and interpolation, find the loudness index for each octave band."]
[]
[null,"Octave Band",1,2,3,4,5,6,7,8]
[null,"Center Freq., f (Hz)",63,125,250,500,1000,2000,4000,8000]
[null,"Lp (dB)",{"$f":"C108","v":69.037808342710505},69.037808342710505,77.37626988117205,80.664049298013055,69.635625375280682,68.598388844892483,67.854647946598902,60.457792960007154]
[null,"Lp¹ (dB)",{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(C117,'Loudness Index Table'!$B$7:$B$127,1)-1)+1,1)","v":69},{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(D117,'Loudness Index Table'!$B$7:$B$127,1)-1)+1,1)","v":69},{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(E117,'Loudness Index Table'!$B$7:$B$127,1)-1)+1,1)","v":77},{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(F117,'Loudness Index Table'!$B$7:$B$127,1)-1)+1,1)","v":80},{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(G117,'Loudness Index Table'!$B$7:$B$127,1)-1)+1,1)","v":69},{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(H117,'Loudness Index Table'!$B$7:$B$127,1)-1)+1,1)","v":68},{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(I117,'Loudness Index Table'!$B$7:$B$127,1)-1)+1,1)","v":67},{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(J117,'Loudness Index Table'!$B$7:$B$127,1)-1)+1,1)","v":60}]
[null,"s¹ (sones)",{"$f":"VLOOKUP(C118,'Loudness Index Table'!$B$7:$J$127,C$115+1)","v":3},{"$f":"VLOOKUP(D118,'Loudness Index Table'!$B$7:$J$127,D$115+1)","v":4.7},{"$f":"VLOOKUP(E118,'Loudness Index Table'!$B$7:$J$127,E$115+1)","v":9.3000000000000007},{"$f":"VLOOKUP(F118,'Loudness Index Table'!$B$7:$J$127,F$115+1)","v":13.5},{"$f":"VLOOKUP(G118,'Loudness Index Table'!$B$7:$J$127,G$115+1)","v":8.3000000000000007},{"$f":"VLOOKUP(H118,'Loudness Index Table'!$B$7:$J$127,H$115+1)","v":9.3000000000000007},{"$f":"VLOOKUP(I118,'Loudness Index Table'!$B$7:$J$127,I$115+1)","v":10.5},{"$f":"VLOOKUP(J118,'Loudness Index Table'!$B$7:$J$127,J$115+1)","v":8.3000000000000007}]
[null,"Lp² (dB)",{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(C117,'Loudness Index Table'!$B$7:$B$127,1)-1+1)+1,1)","v":70},{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(D117,'Loudness Index Table'!$B$7:$B$127,1)-1+1)+1,1)","v":70},{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(E117,'Loudness Index Table'!$B$7:$B$127,1)-1+1)+1,1)","v":78},{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(F117,'Loudness Index Table'!$B$7:$B$127,1)-1+1)+1,1)","v":81},{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(G117,'Loudness Index Table'!$B$7:$B$127,1)-1+1)+1,1)","v":70},{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(H117,'Loudness Index Table'!$B$7:$B$127,1)-1+1)+1,1)","v":69},{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(I117,'Loudness Index Table'!$B$7:$B$127,1)-1+1)+1,1)","v":68},{"$f":"INDEX('Loudness Index Table'!$B$7:$J$127,(MATCH(J117,'Loudness Index Table'!$B$7:$B$127,1)-1+1)+1,1)","v":61}]
[null,"s² (sones)",{"$f":"VLOOKUP(C120,'Loudness Index Table'!$B$7:$J$127,C$115+1)","v":3.2},{"$f":"VLOOKUP(D120,'Loudness Index Table'!$B$7:$J$127,D$115+1)","v":5},{"$f":"VLOOKUP(E120,'Loudness Index Table'!$B$7:$J$127,E$115+1)","v":9.9},{"$f":"VLOOKUP(F120,'Loudness Index Table'!$B$7:$J$127,F$115+1)","v":14.4},{"$f":"VLOOKUP(G120,'Loudness Index Table'!$B$7:$J$127,G$115+1)","v":8.8000000000000007},{"$f":"VLOOKUP(H120,'Loudness Index Table'!$B$7:$J$127,H$115+1)","v":9.9},{"$f":"VLOOKUP(I120,'Loudness Index Table'!$B$7:$J$127,I$115+1)","v":11.1},{"$f":"VLOOKUP(J120,'Loudness Index Table'!$B$7:$J$127,J$115+1)","v":8.8000000000000007}]
[null,"s (sones)",{"$f":"((C121-C119)/(C120-C118))*(C117-C118)+C119","v":3.0075616685421012},{"$f":"((D121-D119)/(D120-D118))*(D117-D118)+D119","v":4.7113425028131521},9.5257619287032309,14.09764436821175,8.6178126876403418,9.6590333069354894,11.012788767959341,8.5288964800035778]
[]
[null,null,"Calculate Total Loudness Index:"]
[null,null,"S = 0.3·(s1 + s2 +s3 + s4 + s5 + s6 + s7 + s8) + 0.7·smax"]
[]
[null,"S (sones)",{"$f":"0.3*SUM(C122:J122)+0.7*MAX(C122:J122)","v":30.616603570990922}]

{"sheet":"Generalized Example one test pt","index":2,"n_rows":52,"n_cols":25,"rows_kept":52,"cut":false,"hidden":false,"merged":[[18,10,18,11],[18,13,18,14],[16,16,18,17],[4,2,4,3],[5,2,5,3],[6,2,6,3],[11,3,11,5],[12,3,12,5],[13,3,13,5]]}
[]
[]
["Product Information"]
[]
["Company Name:",null,"ABC Company"]
["Trade Name:",null,"Model ABC"]
["Model Number:",null,"ABC 101"]
[]
[]
["Options"]
[]
["Sone Type:",null,null,"Hemispherical"]
["Data Format:",null,null,"Full Octave"]
["Sound Power Spectrum:",null,null,"Generalized"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Increase/decrease speed by 10 rpm"]
[null,"Generalized Sound Spectrum",null,null,null,null,null,null,null,"Example Converted Sound Spectrum"]
[null,null,"SI Units",null,null,null,"IP Units",null,null,null,"SI Units",null,null,"IP Units"]
[null,"Test Speed (N)",2000,"rpm",null,null,null,null,null,"Nc =",1980,"rpm"]
[null,"Impeller Diameter (D)",463.55,"mm",null,null,{"$f":"C21/25.4","v":18.25},"in.",null,"Dc = ",463.55,"mm",null,{"$f":"K21/25.4","v":18.25},"in."]
[null,"Airflow (Q)",4.47,"m3/s",null,null,{"$f":"C22*2119.7","v":9475.0589999999993},"cfm",null,"Qc = ",{"$f":"C22*(K20/C20)*(K21/C21)^3","v":4.4253},"m3/s",null,{"$f":"K22*2119.7","v":9380.3084099999996},"cfm"]
[null,"Total Pressure (Pt)",0,"Pa",null,null,{"$f":"C23/248.34","v":0},"in. wg",null,"Ptc = ",{"$f":"C23*(K20/C20)^2*(K21/C21)^2","v":0},"Pa",null,{"$f":"K23/248.34","v":0},"in. wg"]
[null,"Number of Blades (NB)",7,null,null,null,null,null,null,"NB = ",7]
[null,"Blade pass frequency (fbp)",{"$f":"C20*C24/60","v":233.33333333333334},"Hz",null,null,null,null,null,"fbpc = ",{"$f":"K20*K24/60","v":231},"Hz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AMCA  Band","Center Frequency","Upper Frequency","Lower Frequency"]
[null,"Band","Location of fbp","Hz","Test LW",null,"X","LWG",null,"Band","Hz","Location of fbp","Xc","Interpolated LWGc","BPF LWGc","Interpolation Index","LWGc","LWc",null,null,null,null,"f (Hz)","f (Hz)","f (Hz)"]
[null,null,null,null,null,"Extrapolated point:",0,{"$f":"H29","v":66.132199097805085}]
[null,1,{"$f":"IF(AND($C$25>X29,$C$25<=Y29),\"Yes\",\"No\")","v":"No"},63,78.400000000000006,null,{"$f":"10*LOG(D29/$C$20)+20","v":4.9831055378960052},{"$f":"E29-50*LOG($C$20/1000)-70*LOG($C$21/508)","v":66.132199097805085},null,1,63,{"$f":"IF(AND($K$25>=X29,$K$25<=Y29),\"Yes\",\"No\")","v":"No"},{"$f":"10*LOG(K29/$K$20)+20","v":5.0267535919205049},{"$f":"(M29-INDEX(G$28:G$37,$P29))/(INDEX(G$28:G$37,$P29+1)-INDEX(G$28:G$37,$P29))*(INDEX(H$28:H$37,$P29+1)-INDEX(H$28:H$37,$P29))+INDEX(H$28:H$37,$P29)","v":66.142466830741185},{"$f":"IF(L29=\"Yes\",$H$38,\"\")","v":""},{"$f":"MATCH(M29,G$28:G$37,1)","v":2},{"$f":"MAX(N29,O29)","v":66.142466830741185},{"$f":"Q29+50*LOG($K$20/1000)+70*LOG($K$21/508)","v":78.192027462813599},null,null,null,1,63,45,90]
[null,2,{"$f":"IF(AND($C$25>X30,$C$25<=Y30),\"Yes\",\"No\")","v":"No"},125,79.099999999999994,null,{"$f":"10*LOG(D30/$C$20)+20","v":7.9588001734407516},{"$f":"E30-50*LOG($C$20/1000)-70*LOG($C$21/508)","v":66.832199097805074},null,2,125,{"$f":"IF(AND($K$25>=X30,$K$25<=Y30),\"Yes\",\"No\")","v":"No"},8.0024482274652531,{"$f":"(M30-INDEX(G$28:G$37,$P30))/(INDEX(G$28:G$37,$P30+1)-INDEX(G$28:G$37,$P30))*(INDEX(H$28:H$37,$P30+1)-INDEX(H$28:H$37,$P30))+INDEX(H$28:H$37,$P30)","v":66.932246128701365},{"$f":"IF(L30=\"Yes\",$H$38,\"\")","v":""},{"$f":"MATCH(M30,G$28:G$37,1)","v":3},{"$f":"MAX(N30,O30)","v":66.932246128701365},{"$f":"Q30+50*LOG($K$20/1000)+70*LOG($K$21/508)","v":78.981806760773779},null,null,null,2,125,90,180]
[null,3,{"$f":"IF(AND($C$25>X31,$C$25<=Y31),\"Yes\",\"No\")","v":"Yes"},250,86,null,{"$f":"10*LOG(D31/$C$20)+20","v":10.969100130080564},{"$f":"E31-50*LOG($C$20/1000)-70*LOG($C$21/508)","v":73.732199097805079},null,3,250,"Yes",11.012748184105066,{"$f":"(M31-INDEX(G$28:G$37,$P31))/(INDEX(G$28:G$37,$P31+1)-INDEX(G$28:G$37,$P31))*(INDEX(H$28:H$37,$P31+1)-INDEX(H$28:H$37,$P31))+INDEX(H$28:H$37,$P31)","v":73.684350517811197},73.732199097805079,{"$f":"MATCH(M31,G$28:G$37,1)","v":4},{"$f":"MAX(N31,O31)","v":73.732199097805079},85.781759729877493,null,null,null,3,250,180,355]
[null,4,{"$f":"IF(AND($C$25>X32,$C$25<=Y32),\"Yes\",\"No\")","v":"No"},500,82.7,null,{"$f":"10*LOG(D32/$C$20)+20","v":13.979400086720375},{"$f":"E32-50*LOG($C$20/1000)-70*LOG($C$21/508)","v":70.432199097805082},null,4,500,"No",14.023048140744876,{"$f":"(M32-INDEX(G$28:G$37,$P32))/(INDEX(G$28:G$37,$P32+1)-INDEX(G$28:G$37,$P32))*(INDEX(H$28:H$37,$P32+1)-INDEX(H$28:H$37,$P32))+INDEX(H$28:H$37,$P32)","v":70.397400130536809},"",{"$f":"MATCH(M32,G$28:G$37,1)","v":5},{"$f":"MAX(N32,O32)","v":70.397400130536809},82.446960762609223,null,null,null,4,500,355,710]
[null,5,{"$f":"IF(AND($C$25>X33,$C$25<=Y33),\"Yes\",\"No\")","v":"No"},1000,80.3,null,{"$f":"10*LOG(D33/$C$20)+20","v":16.989700043360187},{"$f":"E33-50*LOG($C$20/1000)-70*LOG($C$21/508)","v":68.032199097805076},null,5,1000,"No",17.033348097384689,{"$f":"(M33-INDEX(G$28:G$37,$P33))/(INDEX(G$28:G$37,$P33+1)-INDEX(G$28:G$37,$P33))*(INDEX(H$28:H$37,$P33+1)-INDEX(H$28:H$37,$P33))+INDEX(H$28:H$37,$P33)","v":68.01479961417094},"",{"$f":"MATCH(M33,G$28:G$37,1)","v":6},{"$f":"MAX(N33,O33)","v":68.01479961417094},80.064360246243353,null,null,null,5,1000,710,1400]
[null,6,{"$f":"IF(AND($C$25>X34,$C$25<=Y34),\"Yes\",\"No\")","v":"No"},2000,79.099999999999994,null,{"$f":"10*LOG(D34/$C$20)+20","v":20},{"$f":"E34-50*LOG($C$20/1000)-70*LOG($C$21/508)","v":66.832199097805074},null,6,2000,"No",20.043648054024501,{"$f":"(M34-INDEX(G$28:G$37,$P34))/(INDEX(G$28:G$37,$P34+1)-INDEX(G$28:G$37,$P34))*(INDEX(H$28:H$37,$P34+1)-INDEX(H$28:H$37,$P34))+INDEX(H$28:H$37,$P34)","v":66.766951034177055},"",{"$f":"MATCH(M34,G$28:G$37,1)","v":7},{"$f":"MAX(N34,O34)","v":66.766951034177055},78.816511666249468,null,null,null,6,2000,1400,2800]
[null,7,{"$f":"IF(AND($C$25>X35,$C$25<=Y35),\"Yes\",\"No\")","v":"No"},4000,74.599999999999994,null,{"$f":"10*LOG(D35/$C$20)+20","v":23.010299956639813},{"$f":"E35-50*LOG($C$20/1000)-70*LOG($C$21/508)","v":62.332199097805074},null,7,4000,"No",23.053948010664314,{"$f":"(M35-INDEX(G$28:G$37,$P35))/(INDEX(G$28:G$37,$P35+1)-INDEX(G$28:G$37,$P35))*(INDEX(H$28:H$37,$P35+1)-INDEX(H$28:H$37,$P35))+INDEX(H$28:H$37,$P35)","v":62.224902282061223},"",{"$f":"MATCH(M35,G$28:G$37,1)","v":8},{"$f":"MAX(N35,O35)","v":62.224902282061223},74.274462914133636,null,null,null,7,4000,2800,5600]
[null,8,{"$f":"IF(AND($C$25>X36,$C$25<=Y36),\"Yes\",\"No\")","v":"No"},8000,67.2,null,{"$f":"10*LOG(D36/$C$20)+20","v":26.020599913279625},{"$f":"E36-50*LOG($C$20/1000)-70*LOG($C$21/508)","v":54.932199097805082},null,8,8000,"No",26.064247967304127,{"$f":"(M36-INDEX(G$28:G$37,$P36))/(INDEX(G$28:G$37,$P36+1)-INDEX(G$28:G$37,$P36))*(INDEX(H$28:H$37,$P36+1)-INDEX(H$28:H$37,$P36))+INDEX(H$28:H$37,$P36)","v":54.824902282061231},"",{"$f":"MATCH(M36,G$28:G$37,1)","v":9},{"$f":"MAX(N36,O36)","v":54.824902282061231},66.874462914133645,null,null,null,8,8000,5600,11200]
[null,null,null,null,null,"Extrapolated point:",40,{"$f":"(G37-G35)/(G36-G35)*(H36-H35)+H35","v":20.567663293472165}]
[null,null,null,null,null,{"$f":"\"+ Blade pass frequency:\"","v":"+ Blade pass frequency:"},{"$f":"INDEX(G28:G37,MATCH(\"Yes\",C28:C37,0))","v":10.969100130080564},{"$f":"INDEX(H28:H37,MATCH(\"Yes\",C28:C37,0))","v":73.732199097805079}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Markers for Plot"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X","LWK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lwg at Blade Pass",{"$f":"G38-3","v":7.9691001300805642},{"$f":"H38","v":73.732199097805079}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G38","v":10.969100130080564},{"$f":"H38","v":73.732199097805079}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G38+3","v":13.969100130080564},{"$f":"H38","v":73.732199097805079}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blade Pass",{"$f":"G38","v":10.969100130080564},{"$f":"H38-2","v":71.732199097805079}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G38","v":10.969100130080564},{"$f":"H38-15","v":58.732199097805079}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blade Pass",{"$f":"INDEX(M28:M37,MATCH(\"Yes\",L28:L37,0))","v":11.012748184105066},{"$f":"INDEX(Q28:Q37,MATCH(\"Yes\",L28:L37,0))-2","v":71.732199097805079}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q51","v":11.012748184105066},{"$f":"R51-17","v":54.732199097805079}]

{"sheet":"Loudness Index Table","index":3,"n_rows":127,"n_cols":10,"rows_kept":127,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Loudness Index Table"]
[]
[null,null,"Octave Band / Center Frequency (Hz)"]
[null,null,1,2,3,4,5,6,7,8]
[null,"Lp (dB)",63,125,250,500,1000,2000,4000,8000]
[null,0]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9,null,null,null,null,null,null,null,0.1]
[null,10,null,null,null,null,null,null,null,0.14000000000000001]
[null,11,null,null,null,null,null,null,null,0.18]
[null,12,null,null,null,null,null,null,0.1,0.22]
[null,13,null,null,null,null,null,null,0.14000000000000001,0.26]
[null,14,null,null,null,null,null,null,0.18,0.3]
[null,15,null,null,null,null,null,0.1,0.22,0.35]
[null,16,null,null,null,null,null,0.14000000000000001,0.26,0.4]
[null,17,null,null,null,null,null,0.18,0.3,0.45]
[null,18,null,null,null,null,0.1,0.22,0.35,0.5]
[null,19,null,null,null,null,0.14000000000000001,0.26,0.4,0.55000000000000004]
[null,20,null,null,null,null,0.18,0.3,0.45,0.61]
[null,21,null,null,null,null,0.22,0.35,0.5,0.67]
[null,22,null,null,null,null,0.26,0.4,0.55000000000000004,0.73]
[null,23,null,null,null,0.12,0.3,0.45,0.61,0.8]
[null,24,null,null,null,0.16,0.35,0.5,0.67,0.87]
[null,25,null,null,null,0.21,0.4,0.55000000000000004,0.73,0.94]
[null,26,null,null,null,0.26,0.45,0.61,0.8,1.02]
[null,27,null,null,null,0.31,0.5,0.67,0.87,1.1000000000000001]
[null,28,null,null,null,0.37,0.55000000000000004,0.73,0.94,1.18]
[null,29,null,null,0.12,0.43,0.61,0.8,1.02,1.27]
[null,30,null,null,0.16,0.49,0.67,0.87,1.1000000000000001,1.35]
[null,31,null,null,0.21,0.55000000000000004,0.73,0.94,1.18,1.44]
[null,32,null,null,0.26,0.61,0.8,1.02,1.27,1.54]
[null,33,null,null,0.31,0.67,0.87,1.1000000000000001,1.35,1.64]
[null,34,null,null,0.37,0.73,0.94,1.18,1.44,1.75]
[null,35,null,0.12,0.43,0.8,1.02,1.27,1.54,1.87]
[null,36,null,0.16,0.49,0.87,1.1000000000000001,1.35,1.64,1.99]
[null,37,null,0.21,0.55000000000000004,0.94,1.18,1.44,1.75,2.11]
[null,38,null,0.26,0.62,1.02,1.27,1.54,1.87,2.2400000000000002]
[null,39,null,0.31,0.69,1.1000000000000001,1.35,1.64,1.99,2.38]
[null,40,null,0.37,0.77,1.18,1.44,1.75,2.11,2.5299999999999998]
[null,41,0.12,0.43,0.85,1.27,1.54,1.87,2.2400000000000002,2.68]
[null,42,0.16,0.49,0.94,1.35,1.64,1.99,2.38,2.84]
[null,43,0.21,0.55000000000000004,1.04,1.44,1.75,2.11,2.5299999999999998,3]
[null,44,0.26,0.62,1.1299999999999999,1.54,1.87,2.2400000000000002,2.68,3.2]
[null,45,0.31,0.69,1.23,1.64,1.99,2.38,2.84,3.4]
[null,46,0.37,0.77,1.33,1.75,2.11,2.5299999999999998,3,3.6]
[null,47,0.43,0.85,1.44,1.87,2.2400000000000002,2.68,3.2,3.8]
[null,48,0.49,0.94,1.56,1.99,2.38,2.84,3.4,4.0999999999999996]
[null,49,0.55000000000000004,1.04,1.68,2.11,2.5299999999999998,3,3.6,4.3]
[null,50,0.62,1.1299999999999999,1.82,2.2400000000000002,2.68,3.2,3.8,4.3]
[null,51,0.69,1.23,1.96,2.38,2.84,3.4,4.0999999999999996,4.9000000000000004]
[null,52,0.77,1.33,2.11,2.5299999999999998,3,3.6,4.3,5.2]
[null,53,0.85,1.44,2.2400000000000002,2.68,3.2,3.8,4.5999999999999996,5.5]
[null,54,0.94,1.56,2.38,2.84,3.4,4.0999999999999996,4.9000000000000004,5.8]
[null,55,1.04,1.68,2.5299999999999998,3,3.6,4.3,5.2,6.2]
[null,56,1.1299999999999999,1.82,2.68,3.2,3.8,4.5999999999999996,5.5,6.6]
[null,57,1.23,1.96,2.84,3.4,4.0999999999999996,4.9000000000000004,5.8,7]
[null,58,1.33,2.11,3,3.6,4.3,5.2,6.2,7.4]
[null,59,1.44,2.27,3.2,3.8,4.5999999999999996,5.5,6.6,7.8]
[null,60,1.56,2.44,3.4,4.0999999999999996,4.9000000000000004,5.8,7,8.3000000000000007]
[null,61,1.68,2.61,3.6,4.3,5.2,6.2,7.4,8.8000000000000007]
[null,62,1.82,2.81,3.8,4.5999999999999996,5.5,6.6,7.8,9.3000000000000007]
[null,63,1.96,3,4.0999999999999996,4.9000000000000004,5.8,7,8.3000000000000007,9.9]
[null,64,2.11,3.2,4.3,5.2,6.2,7.4,8.8000000000000007,10.5]
[null,65,2.27,3.5,4.5999999999999996,5.5,6.6,7.8,9.3000000000000007,11.1]
[null,66,2.44,3.7,4.9000000000000004,5.8,7,8.3000000000000007,9.9,11.8]
[null,67,2.61,4,5.2,6.2,7.4,8.8000000000000007,10.5,12.6]
[null,68,2.81,4.3,5.5,6.6,7.8,9.3000000000000007,11.1,13.5]
[null,69,3,4.7,5.8,7,8.3000000000000007,9.9,11.8,14.4]
[null,70,3.2,5,6.2,7.4,8.8000000000000007,10.5,12.6,15.3]
[null,71,3.5,5.4,6.6,7.8,9.3000000000000007,11.1,13.5,16.399999999999999]
[null,72,3.7,5.8,7,8.3000000000000007,9.9,11.8,14.4,17.5]
[null,73,4,6.2,7.4,8.8000000000000007,10.5,12.6,15.3,18.7]
[null,74,4.3,6.6,7.8,9.3000000000000007,11.1,13.5,16.399999999999999,20]
[null,75,4.7,7,8.3000000000000007,9.9,11.8,14.4,17.5,21.4]
[null,76,5,7.4,8.8000000000000007,10.5,12.6,15.3,18.7,23]
[null,77,5.4,7.8,9.3000000000000007,11.1,13.5,16.399999999999999,20,24.7]
[null,78,5.8,8.3000000000000007,9.9,11.8,14.4,17.5,21.4,26.5]
[null,79,6.2,8.8000000000000007,10.5,12.6,15.3,18.7,23,28.5]
[null,80,6.7,9.3000000000000007,11.1,13.5,16.399999999999999,20,24.7,30.5]
[null,81,7.2,9.9,11.8,14.4,17.5,21.4,26.5,33]
[null,82,7.7,10.5,12.6,15.3,18.7,23,28.5,35.299999999999997]
[null,83,8.1999999999999993,11.1,13.5,16.399999999999999,20,24.7,30.5,38]
[null,84,8.8000000000000007,11.8,14.4,17.5,21.4,26.5,33,41]
[null,85,9.4,12.6,15.3,18.7,23,28.5,35.299999999999997,44]
[null,86,10,13.5,16.399999999999999,20,24.7,30.5,38,48]
[null,87,10.8,14.4,17.5,21.4,26.5,33,41,52]
[null,88,11.7,15.3,18.7,23,28.5,35.299999999999997,44,56]
[null,89,12.6,16.399999999999999,20,24.7,30.5,38,48,61]
[null,90,13.6,17.5,21.4,26.5,33,41,52,66]
[null,91,14.7,18.7,23,28.5,35.299999999999997,44,56,71]
[null,92,16,20,24.7,30.5,38,48,64,77]
[null,93,17.3,21.4,26.5,33,41,52,66,83]
[null,94,18.7,23,28.5,35.299999999999997,44,56,71,90]
[null,95,20,24.7,30.5,38,48,61,77,97]
[null,96,21.4,26.5,33,41,52,66,83,105]
[null,97,23,28.5,35.299999999999997,44,56,71,90,113]
[null,98,24.7,30.5,38,48,61,77,97,121]
[null,99,26.5,33,41,52,66,83,105,130]
[null,100,28.5,35.299999999999997,44,56,71,90,113,139]
[null,101,30.5,38,48,61,77,97,121,149]
[null,102,33,41,52,66,83,105,130,160]
[null,103,35.299999999999997,44,56,71,90,113,139,171]
[null,104,38,48,61,77,97,121,149,184]
[null,105,41,52,66,83,105,130,160,197]
[null,106,44,56,71,90,113,139,171,211]
[null,107,48,61,77,97,121,149,184,226]
[null,108,52,66,83,105,130,160,197,242]
[null,109,56,71,90,113,139,171,211,260]
[null,110,61,77,97,121,149,184,226,278]
[null,111,66,83,105,130,160,197,242,298]
[null,112,71,90,113,139,171,211,260,320]
[null,113,77,97,121,149,184,226,278]
[null,114,83,105,130,160,197,242,298]
[null,115,90,113,139,171,211,260,320]
[null,116,97,121,149,184,226,278]
[null,117,105,130,160,197,242,298]
[null,118,113,139,171,211,260,320]
[null,119,121,149,184,226,278]
[null,120,130,160,197,242,298]