{"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-02-08"]
["Post # and Name","Location",2019,2018,"Goal","Diff","% of Goal"]
["Post 01 - Jack Henry","Anchorage",501,496,530,{"$f":"SUM(C5-E5)","v":-29},{"$f":"C5/E5","v":0.94528301886792454}]
["Post 02 - Valdez","Valdez",18,19,19,-1,0.94736842105263153]
["Post 03 - Joseph T. Craig","Ketchikan",159,180,183,-24,0.86885245901639341]
["Post 04 - Pioneer","Anchorage",9,14,15,-6,0.6]
["Post 05 - Seward","Seward",195,219,228,-33,0.85526315789473684]
["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",164,210,214,-50,0.76635514018691586]
["Post 12 - Lynn Canal","Haines",80,105,102,-22,0.78431372549019607]
["Post 13 - Sitka","Sitka",57,86,88,-31,0.64772727272727271]
["Post 14 - Edward Locken","Petersburg",6,7,7,{"$f":"SUM(E17-C17)","v":1},0.8571428571428571]
["Post 15 - Matanuska Valley","Palmer",232,212,241,{"$f":"SUM(C18-E18)","v":-9},0.96265560165975106]
["Post 16 - General Buckner","Homer",128,164,172,-44,0.7441860465116279]
["Post 17 - Robert G. Blair","Kodiak",139,192,184,-45,0.75543478260869568]
["Post 18 - Ninilchik","Ninilchik",97,108,112,-15,0.8660714285714286]
["Post 20 - George H. Plumley Memorial","Kenai",173,216,217,-44,0.79723502304147464]
["Post 21 - Aurora Borealis","Anchorage",41,57,53,-12,0.77358490566037741]
["Post 22 - Jack Warren","Delta Junction",40,35,39,{"$f":"SUM(E24-C24)","v":-1},1.0256410256410255]
["Post 25 - Auke Bay","Auke Bay",91,85,104,{"$f":"SUM(C25-E25)","v":-13},0.875]
["Post 26 - Prince of Wales","Craig",10,37,33,{"$f":"(C26-E26)","v":-23},0.30303030303030304]
["Post 27 - Gladys M. Heintz Memorial","Glenallen",38,45,44,{"$f":"SUM(C27-E27)","v":-6},0.86363636363636365]
["Post 28 - Spenard","Anchorage",538,578,614,{"$f":"SUM(C28-E28)","v":-76},0.87622149837133545]
["Post 29 - Muldoon","Anchorage",238,289,320,{"$f":"SUM(C29-E29)","v":-82},0.74375000000000002]
["Post 30 - Con Miller","North Pole",113,145,142,{"$f":"SUM(C30-E30)","v":-29},0.79577464788732399]
["Post 33 - Peters Creek","Chugiak",286,318,338,{"$f":"(C31-E31)","v":-52},0.84615384615384615]
["Post 34 - Chappie James","Anchorage",37,55,56,{"$f":"SUM(C32-E32)","v":-19},0.6607142857142857]
["Post 35 - Susitna Valley","Wasilla",323,332,343,-20,0.94169096209912539]
["Post 57 - C.R. Huber","Fairbanks",221,261,267,-46,0.82771535580524347]
["Post 75 - Sterling","Sterling",3,12,12,-9,0.25]
["Post 442 - Peter Heyano","Dillingham",12,18,21,-9,0.5714285714285714]
["Post 77 - Department Headquarters","Anchorage",458,609,746,-288,0.613941018766756]
["Post 49 - General Claire L. Chennault","Taipei - Taiwan",22,24,26,-4,0.84615384615384615]
["GM-01- Mid-Pacific","Tamuning",61,83,84,-23,0.72619047619047616]
["Grand Totals:   ",null,4570,5327,{"$f":"SUM(E5:E39)","v":5675},null,{"$f":"AVERAGE(C40/E40)","v":0.80528634361233475}]

{"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-02-08"]
["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",232,212,241,{"$f":"SUM(C7-E7)","v":-9},{"$f":"C7/E7","v":0.96265560165975106}]
["Post 02 - Valdez","Valdez",18,19,19,{"$f":"SUM(C8-E8)","v":-1},{"$f":"C8/E8","v":0.94736842105263153}]
["Post 01 - Jack Henry","Anchorage",501,496,530,{"$f":"SUM(C9-E9)","v":-29},{"$f":"C9/E9","v":0.94528301886792454}]
["Post 07 - Skagway","Skagway",34,35,36,{"$f":"SUM(C10-E10)","v":-2},{"$f":"C10/E10","v":0.94444444444444442}]
["Post 35 - Susitna Valley","Wasilla",323,332,343,{"$f":"SUM(C11-E11)","v":-20},{"$f":"C11/E11","v":0.94169096209912539}]
["Post 06 - Merlin Elmer Palmer","Wrangell",44,47,47,{"$f":"SUM(C12-E12)","v":-3},{"$f":"C12/E12","v":0.93617021276595747}]
["Post 28 - Spenard","Anchorage",538,578,614,{"$f":"SUM(C13-E13)","v":-76},{"$f":"C13/E13","v":0.87622149837133545}]
["Post 25 - Auke Bay","Auke Bay",91,85,104,{"$f":"SUM(C14-E14)","v":-13},{"$f":"C14/E14","v":0.875}]
["Post 03 - Joseph T. Craig","Ketchikan",159,180,183,{"$f":"SUM(C15-E15)","v":-24},{"$f":"C15/E15","v":0.86885245901639341}]
["Post 18 - Ninilchik","Ninilchik",97,108,112,{"$f":"SUM(C16-E16)","v":-15},{"$f":"C16/E16","v":0.8660714285714286}]
["Post 27 - Gladys M. Heintz Memorial","Glenallen",38,45,44,{"$f":"SUM(C17-E17)","v":-6},{"$f":"C17/E17","v":0.86363636363636365}]
["Post 08 - John W. Jones","Cordova",6,6,7,{"$f":"SUM(C18-E18)","v":-1},{"$f":"C18/E18","v":0.8571428571428571}]
["Post 14 - Edward Locken","Petersburg",6,7,7,{"$f":"SUM(E19-C19)","v":1},{"$f":"C19/E19","v":0.8571428571428571}]
["Post 05 - Seward","Seward",195,219,228,{"$f":"SUM(C20-E20)","v":-33},{"$f":"C20/E20","v":0.85526315789473684}]
["Post 33 - Peters Creek","Chugiak",286,318,338,{"$f":"(C21-E21)","v":-52},{"$f":"C21/E21","v":0.84615384615384615}]
["Post 49 - General Claire L. Chennault","Taipei - Taiwan",22,24,26,{"$f":"SUM(C22-E22)","v":-4},{"$f":"C22/E22","v":0.84615384615384615}]
["Post 09 - Koyukuk","Coldfoot",26,28,31,{"$f":"SUM(C23-E23)","v":-5},{"$f":"C23/E23","v":0.83870967741935487}]
["Post 57 - C.R. Huber","Fairbanks",221,261,267,{"$f":"SUM(C24-E24)","v":-46},{"$f":"C24/E24","v":0.82771535580524347}]
["Post 20 - George H. Plumley Memorial","Kenai",173,216,217,{"$f":"SUM(C25-E25)","v":-44},{"$f":"C25/E25","v":0.79723502304147464}]
["Post 30 - Con Miller","North Pole",113,145,142,{"$f":"SUM(C26-E26)","v":-29},{"$f":"C26/E26","v":0.79577464788732399}]
["Post 12 - Lynn Canal","Haines",80,105,102,{"$f":"SUM(C27-E27)","v":-22},{"$f":"C27/E27","v":0.78431372549019607}]
["Post 21 - Aurora Borealis","Anchorage",41,57,53,{"$f":"SUM(C28-E28)","v":-12},{"$f":"C28/E28","v":0.77358490566037741}]
["Post 11 - Dorman H. Baker","Fairbanks",164,210,214,{"$f":"SUM(C29-E29)","v":-50},{"$f":"C29/E29","v":0.76635514018691586}]
["Post 17 - Robert G. Blair","Kodiak",139,192,184,{"$f":"SUM(C30-E30)","v":-45},{"$f":"C30/E30","v":0.75543478260869568}]
["Post 16 - General Buckner","Homer",128,164,172,{"$f":"SUM(C31-E31)","v":-44},{"$f":"C31/E31","v":0.7441860465116279}]
["Post 29 - Muldoon","Anchorage",238,289,320,{"$f":"SUM(C32-E32)","v":-82},{"$f":"C32/E32","v":0.74375000000000002}]
["GM-01- Mid-Pacific","Tamuning",61,83,84,{"$f":"SUM(C33-E33)","v":-23},{"$f":"C33/E33","v":0.72619047619047616}]
["Post 34 - Chappie James","Anchorage",37,55,56,{"$f":"SUM(C34-E34)","v":-19},{"$f":"C34/E34","v":0.6607142857142857}]
["Post 13 - Sitka","Sitka",57,86,88,{"$f":"SUM(C35-E35)","v":-31},{"$f":"C35/E35","v":0.64772727272727271}]
["Post 77 - Department Headquarters","Anchorage",458,609,746,{"$f":"SUM(C36-E36)","v":-288},{"$f":"C36/E36","v":0.613941018766756}]
["Post 04 - Pioneer","Anchorage",9,14,15,{"$f":"SUM(C37-E37)","v":-6},{"$f":"C37/E37","v":0.6}]
["Post 442 - Peter Heyano","Dillingham",12,18,21,{"$f":"SUM(C38-E38)","v":-9},{"$f":"C38/E38","v":0.5714285714285714}]
["Post 26 - Prince of Wales","Craig",10,37,33,{"$f":"(C39-E39)","v":-23},{"$f":"C39/E39","v":0.30303030303030304}]
["Post 75 - Sterling","Sterling",3,12,12,{"$f":"SUM(C40-E40)","v":-9},{"$f":"C40/E40","v":0.25}]
["Grand Totals:   ",null,4570,5327,{"$f":"SUM(E6:E40)","v":5675},null,{"$f":"AVERAGE(C41/E41)","v":0.80528634361233475}]

{"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 8, 2019"]
["SQD. #","SQUADRON NAME","GOAL","ACTUAL","PERCENTAGE"]
[29,"MULDOON",35,41,117.1]
[18,"NINILCHIK",61,68,111.5]
[28,"SPENARD",135,143,105.9]
[33,"PETERS CREEK",88,80,90.9]
[15,"MATANUSKA VALLEY",69,60,87]
[57,"C RUSSELL HUBER",142,119,83.8]
[35,"SUSITNA VALLEY",153,127,83]
[1,"JACK HENRY ",121,93,76.900000000000006]
["************","AVERAGE*****************************",1422,1043,73.3]
[17,"ROBERT G BLAIR",148,99,66.900000000000006]
[11,"DORMAN H BAKER",29,18,62.1]
[5,"SEWARD",87,50,57.5]
[16,"GENERAL BUCKNER",90,46,51.1]
[20,"GEORGE H PLUMLEY MEMORIAL",82,38,46.3]
[13,"SITKA",52,23,44.2]
[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,1043,73.3]

{"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 2/1/2019"]
["UNIT NO.","UNIT NAME","OBJECTIVE","JUNIOR","SENIOR","TOTAL","PERCENT"]
["0077","HEADQUARTERS",11,0,13,13,{"$f":"F3/C3","v":1.1818181818181819}]
["0006","MERLIN ELMER PALMER",96,18,68,86,{"$f":"F4/C4","v":0.89583333333333337}]
["0035","SUSITNA VALLEY",229,11,120,131,{"$f":"F5/C5","v":0.57205240174672489}]
["0442","PETER HEYANO - DILLINGHAM",16,1,8,9,0.5625]
["0027","GLADYS M. HEINTZ",15,0,8,8,{"$f":"F7/C7","v":0.53333333333333333}]
["0033","PETERS CREEK",216,7,108,115,0.53240740740740744]
["0020","GEO. H. PLUMLEY MEMORIAL",216,11,100,111,0.51388888888888884]
["0011","DORMAN H. BAKER",121,3,58,61,0.50413223140495866]
["0057","C. RUSSELL HUBER",278,9,131,140,0.50359712230215825]
["0001","JACK HENRY ",376,6,181,187,0.49734042553191488]
["0018","NINILCHIK",157,2,73,75,0.47770700636942676]
["0005","SEWARD",229,2,107,109,0.4759825327510917]
["0029","MULDOON",166,0,74,74,0.44578313253012047]
["0003","KETCHIKAN",82,0,33,34,0.41463414634146339]
["0016","GENERAL BUCKNER",221,2,87,89,0.40271493212669685]
["0013","SITKA",116,0,45,45,0.38793103448275862]
["0012","LYNN CANAL",156,1,56,57,0.36538461538461536]
["0017","ROBERT G. BLAIR",251,1,80,81,0.32270916334661354]
["0015","MATANUSKA VALLEY",237,1,71,72,0.30379746835443039]
["0030","CON MILLER",56,0,17,17,0.30357142857142855]
["0028","SPENARD",436,2,104,106,0.24311926605504589]
["0034","CHAPPIE JAMES",41,0,3,3,7.3170731707317069E-2]
["0019","NOME",62,0,4,4,6.4516129032258063E-2]
[]
[null,"TOTAL",3769,77,1541,1619,{"$f":"F27/C27","v":0.42955691164765192}]