{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Numerical","%","SAL 2019","AUX 2019"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":"Numerical","index":0,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6]]}
["The American Legion Department of Alaska"]
["Membership Report"]
["2019-03-01"]
["Post # and Name","Location",2019,2018,"Goal","Diff","% of Goal"]
["Post 01 - Jack Henry","Anchorage",522,496,530,{"$f":"SUM(C5-E5)","v":-8},{"$f":"C5/E5","v":0.98490566037735849}]
["Post 02 - Valdez","Valdez",18,19,19,-1,0.94736842105263153]
["Post 03 - Joseph T. Craig","Ketchikan",165,180,183,-18,0.90163934426229508]
["Post 04 - Pioneer","Anchorage",9,14,15,-6,0.6]
["Post 05 - Seward","Seward",207,219,228,-21,0.90789473684210531]
["Post 06 - Merlin Elmer Palmer","Wrangell",44,47,47,-3,0.93617021276595747]
["Post 07 - Skagway","Skagway",34,35,36,-2,0.94444444444444442]
["Post 08 - John W. Jones","Cordova",6,6,7,-1,0.8571428571428571]
["Post 09 - Koyukuk","Coldfoot",26,28,31,-5,0.83870967741935487]
["Post 11 - Dorman H. Baker","Fairbanks",167,210,214,-47,0.78037383177570097]
["Post 12 - Lynn Canal","Haines",88,105,102,-14,0.86274509803921573]
["Post 13 - Sitka","Sitka",69,86,88,-19,0.78409090909090906]
["Post 14 - Edward Locken","Petersburg",6,7,7,{"$f":"SUM(E17-C17)","v":1},0.8571428571428571]
["Post 15 - Matanuska Valley","Palmer",246,212,241,{"$f":"SUM(C18-E18)","v":5},1.0207468879668049]
["Post 16 - General Buckner","Homer",132,164,172,-40,0.76744186046511631]
["Post 17 - Robert G. Blair","Kodiak",153,192,184,-31,0.83152173913043481]
["Post 18 - Ninilchik","Ninilchik",98,108,112,-14,0.875]
["Post 20 - George H. Plumley Memorial","Kenai",183,216,217,-34,0.84331797235023043]
["Post 21 - Aurora Borealis","Anchorage",43,57,53,-10,0.81132075471698117]
["Post 22 - Jack Warren","Delta Junction",40,35,39,{"$f":"SUM(E24-C24)","v":-1},1.0256410256410255]
["Post 25 - Auke Bay","Auke Bay",93,85,104,{"$f":"SUM(C25-E25)","v":-11},0.89423076923076927]
["Post 26 - Prince of Wales","Craig",10,37,33,{"$f":"(C26-E26)","v":-23},0.30303030303030304]
["Post 27 - Gladys M. Heintz Memorial","Glenallen",40,45,44,{"$f":"SUM(C27-E27)","v":-4},0.90909090909090906]
["Post 28 - Spenard","Anchorage",566,578,614,{"$f":"SUM(C28-E28)","v":-48},0.92182410423452765]
["Post 29 - Muldoon","Anchorage",264,289,320,{"$f":"SUM(C29-E29)","v":-56},0.82499999999999996]
["Post 30 - Con Miller","North Pole",124,145,142,{"$f":"SUM(C30-E30)","v":-18},0.87323943661971826]
["Post 33 - Peters Creek","Chugiak",292,318,338,{"$f":"(C31-E31)","v":-46},0.86390532544378695]
["Post 34 - Chappie James","Anchorage",43,55,56,{"$f":"SUM(C32-E32)","v":-13},0.7678571428571429]
["Post 35 - Susitna Valley","Wasilla",338,332,343,-5,0.98542274052478129]
["Post 57 - C.R. Huber","Fairbanks",222,261,267,-45,0.8314606741573034]
["Post 75 - Sterling","Sterling",3,12,12,-9,0.25]
["Post 442 - Peter Heyano","Dillingham",15,18,21,-6,0.7142857142857143]
["Post 77 - Department Headquarters","Anchorage",468,609,746,-278,0.62734584450402142]
["Post 49 - General Claire L. Chennault","Taipei - Taiwan",22,24,26,-4,0.84615384615384615]
["GM-01- Mid-Pacific","Tamuning",64,83,84,-20,0.76190476190476186]
["Grand Totals:   ",null,4820,5327,{"$f":"SUM(E5:E39)","v":5675},null,{"$f":"AVERAGE(C40/E40)","v":0.84933920704845811}]

{"sheet":"%","index":1,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6]]}
["The American Legion Department of Alaska"]
["The American Legion Department of Alaska"]
["Membership Report"]
["2019-03-01"]
["Post # and Name","Location",2019,2018,"Goal","Diff","% of Goal"]
["Post 22 - Jack Warren","Delta Junction",40,35,39,{"$f":"SUM(E6-C6)","v":-1},{"$f":"C6/E6","v":1.0256410256410255}]
["Post 15 - Matanuska Valley","Palmer",246,212,241,{"$f":"SUM(C7-E7)","v":5},1.0207468879668049]
["Post 35 - Susitna Valley","Wasilla",338,332,343,-5,0.98542274052478129]
["Post 01 - Jack Henry","Anchorage",522,496,530,-8,0.98490566037735849]
["Post 02 - Valdez","Valdez",18,19,19,-1,0.94736842105263153]
["Post 07 - Skagway","Skagway",34,35,36,-2,0.94444444444444442]
["Post 06 - Merlin Elmer Palmer","Wrangell",44,47,47,-3,0.93617021276595747]
["Post 28 - Spenard","Anchorage",566,578,614,-48,0.92182410423452765]
["Post 27 - Gladys M. Heintz Memorial","Glenallen",40,45,44,-4,0.90909090909090906]
["Post 05 - Seward","Seward",207,219,228,-21,0.90789473684210531]
["Post 03 - Joseph T. Craig","Ketchikan",165,180,183,-18,0.90163934426229508]
["Post 25 - Auke Bay","Auke Bay",93,85,104,-11,0.89423076923076927]
["Post 18 - Ninilchik","Ninilchik",98,108,112,-14,0.875]
["Post 30 - Con Miller","North Pole",124,145,142,-18,0.87323943661971826]
["Post 33 - Peters Creek","Chugiak",292,318,338,{"$f":"(C20-E20)","v":-46},0.86390532544378695]
["Post 12 - Lynn Canal","Haines",88,105,102,{"$f":"SUM(C21-E21)","v":-14},0.86274509803921573]
["Post 08 - John W. Jones","Cordova",6,6,7,{"$f":"SUM(C22-E22)","v":-1},0.8571428571428571]
["Post 14 - Edward Locken","Petersburg",6,7,7,{"$f":"SUM(E23-C23)","v":1},0.8571428571428571]
["Post 49 - General Claire L. Chennault","Taipei - Taiwan",22,24,26,{"$f":"SUM(C24-E24)","v":-4},0.84615384615384615]
["Post 20 - George H. Plumley Memorial","Kenai",183,216,217,-34,0.84331797235023043]
["Post 09 - Koyukuk","Coldfoot",26,28,31,-5,0.83870967741935487]
["Post 17 - Robert G. Blair","Kodiak",153,192,184,-31,0.83152173913043481]
["Post 57 - C.R. Huber","Fairbanks",222,261,267,-45,0.8314606741573034]
["Post 29 - Muldoon","Anchorage",264,289,320,-56,0.82499999999999996]
["Post 21 - Aurora Borealis","Anchorage",43,57,53,-10,0.81132075471698117]
["Post 13 - Sitka","Sitka",69,86,88,-19,0.78409090909090906]
["Post 11 - Dorman H. Baker","Fairbanks",167,210,214,-47,0.78037383177570097]
["Post 34 - Chappie James","Anchorage",43,55,56,-13,0.7678571428571429]
["Post 16 - General Buckner","Homer",132,164,172,-40,0.76744186046511631]
["GM-01- Mid-Pacific","Tamuning",64,83,84,-20,0.76190476190476186]
["Post 442 - Peter Heyano","Dillingham",15,18,21,-6,0.7142857142857143]
["Post 77 - Department Headquarters","Anchorage",468,609,746,-278,0.62734584450402142]
["Post 04 - Pioneer","Anchorage",9,14,15,-6,0.6]
["Post 26 - Prince of Wales","Craig",10,37,33,{"$f":"(C39-E39)","v":-23},0.30303030303030304]
["Post 75 - Sterling","Sterling",3,12,12,{"$f":"SUM(C40-E40)","v":-9},0.25]
["Grand Totals:   ",null,4820,5327,{"$f":"SUM(E6:E40)","v":5675},null,{"$f":"AVERAGE(C41/E41)","v":0.84933920704845811}]

{"sheet":"SAL 2019","index":2,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Barometer 2019 as of February 22, 2019"]
["SQD. #","SQUADRON NAME","GOAL","ACTUAL","PERCENTAGE"]
[29,"MULDOON",35,41,117.1]
[18,"NINILCHIK",61,68,111.5]
[28,"SPENARD",135,150,111.1]
[33,"PETERS CREEK",88,83,94.3]
[15,"MATANUSKA VALLEY",69,63,91.3]
[57,"C RUSSELL HUBER",142,119,83.8]
[35,"SUSITNA VALLEY",153,127,83]
[1,"JACK HENRY ",121,96,79.3]
["************","AVERAGE*****************************",1422,1095,77]
[20,"GEORGE H PLUMLEY MEMORIAL",82,57,69.5]
[17,"ROBERT G BLAIR",148,99,66.900000000000006]
[11,"DORMAN H BAKER",29,18,62.1]
[5,"SEWARD",87,54,62.1]
[16,"GENERAL BUCKNER",90,55,61.1]
[13,"SITKA",52,27,51.9]
[3,"KETCHIKAN",41,16,39]
[30,"CON MILLER",29,10,34.5]
[12,"LYNN CANAL",50,12,24]
[34,"CHAPPIE JAMES",10,0,0]
[]
[]
[]
[]
[]
[null,"DETACHMENT",1422,1095,77]

{"sheet":"AUX 2019","index":3,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["ALA 2019 BAROMETER as of 3/1/2019"]
["UNIT NO.","UNIT NAME","OBJECTIVE","JUNIOR","SENIOR","TOTAL","PERCENT"]
["0077","HEADQUARTERS",11,0,14,14,{"$f":"F3/C3","v":1.2727272727272727}]
["0006","MERLIN ELMER PALMER",96,18,69,87,0.90625]
["0035","SUSITNA VALLEY",229,11,139,150,0.65502183406113534]
["0057","C. RUSSELL HUBER",278,9,155,164,0.58992805755395683]
["0001","JACK HENRY ",376,6,209,215,0.57180851063829785]
["0033","PETERS CREEK",216,7,116,123,0.56944444444444442]
["0442","PETER HEYANO - DILLINGHAM",16,1,8,9,0.5625]
["0005","SEWARD",229,2,125,127,{"$f":"F10/C10","v":0.55458515283842791}]
["0020","GEO. H. PLUMLEY MEMORIAL",216,11,107,119,0.55092592592592593]
["0011","DORMAN H. BAKER",121,3,62,65,0.53719008264462809]
["0027","GLADYS M. HEINTZ",15,0,8,8,0.53333333333333333]
["0012","LYNN CANAL",156,1,79,80,0.51282051282051277]
["0018","NINILCHIK",157,2,77,79,0.50318471337579618]
["0029","MULDOON",166,0,76,76,0.45783132530120479]
["0003","KETCHIKAN",82,0,37,37,0.45121951219512196]
["0013","SITKA",116,0,48,48,0.41379310344827586]
["0016","GENERAL BUCKNER",221,2,88,90,0.40723981900452488]
["0015","MATANUSKA VALLEY",237,1,92,93,0.39240506329113922]
["0028","SPENARD",436,2,152,154,0.35321100917431192]
["0017","ROBERT G. BLAIR",251,1,81,82,0.32669322709163345]
["0030","CON MILLER",56,0,17,17,0.30357142857142855]
["0034","CHAPPIE JAMES",41,0,7,7,0.17073170731707318]
["0019","NOME",62,0,4,4,6.4516129032258063E-2]
[]
[null,"TOTAL",3784,77,1770,1848,{"$f":"F27/C27","v":0.48837209302325579}]