{"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-01-04"]
["Post # and Name","Location",2019,2018,"Goal","Diff","% of Goal"]
["Post 01 - Jack Henry","Anchorage",477,496,530,{"$f":"SUM(C5-E5)","v":-53},{"$f":"C5/E5","v":0.9}]
["Post 02 - Valdez","Valdez",18,19,19,-1,0.94736842105263153]
["Post 03 - Joseph T. Craig","Ketchikan",145,180,183,-38,0.79234972677595628]
["Post 04 - Pioneer","Anchorage",9,14,15,-6,0.6]
["Post 05 - Seward","Seward",181,219,228,-47,0.79385964912280704]
["Post 06 - Merlin Elmer Palmer","Wrangell",36,47,47,-11,0.76595744680851063]
["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",144,210,214,-70,0.67289719626168221]
["Post 12 - Lynn Canal","Haines",69,105,102,-33,0.67647058823529416]
["Post 13 - Sitka","Sitka",56,86,88,-32,0.63636363636363635]
["Post 14 - Edward Locken","Petersburg",6,7,7,{"$f":"SUM(E17-C17)","v":1},0.8571428571428571]
["Post 15 - Matanuska Valley","Palmer",220,212,241,{"$f":"SUM(C18-E18)","v":-21},0.91286307053941906]
["Post 16 - General Buckner","Homer",117,164,172,-55,0.68023255813953487]
["Post 17 - Robert G. Blair","Kodiak",116,192,184,-68,0.63043478260869568]
["Post 18 - Ninilchik","Ninilchik",89,108,112,-23,0.7946428571428571]
["Post 20 - George H. Plumley Memorial","Kenai",153,216,217,-64,0.70506912442396308]
["Post 21 - Aurora Borealis","Anchorage",39,57,53,-14,0.73584905660377353]
["Post 22 - Jack Warren","Delta Junction",33,35,39,{"$f":"SUM(E24-C24)","v":6},0.84615384615384615]
["Post 25 - Auke Bay","Auke Bay",82,85,104,{"$f":"SUM(C25-E25)","v":-22},0.78846153846153844]
["Post 26 - Prince of Wales","Craig",7,37,33,{"$f":"(C26-E26)","v":-26},0.21212121212121213]
["Post 27 - Gladys M. Heintz Memorial","Glenallen",33,45,44,{"$f":"SUM(C27-E27)","v":-11},0.75]
["Post 28 - Spenard","Anchorage",482,578,614,{"$f":"SUM(C28-E28)","v":-132},0.78501628664495116]
["Post 29 - Muldoon","Anchorage",203,289,320,{"$f":"SUM(C29-E29)","v":-117},0.63437500000000002]
["Post 30 - Con Miller","North Pole",99,145,142,{"$f":"SUM(C30-E30)","v":-43},0.69718309859154926]
["Post 33 - Peters Creek","Chugiak",268,318,338,{"$f":"(C31-E31)","v":-70},0.79289940828402372]
["Post 34 - Chappie James","Anchorage",36,55,56,{"$f":"SUM(C32-E32)","v":-20},0.6428571428571429]
["Post 35 - Susitna Valley","Wasilla",298,332,343,-45,0.86880466472303208]
["Post 57 - C.R. Huber","Fairbanks",192,261,267,-75,0.7191011235955056]
["Post 75 - Sterling","Sterling",3,12,12,-9,0.25]
["Post 442 - Peter Heyano","Dillingham",9,18,21,-12,0.42857142857142855]
["Post 77 - Department Headquarters","Anchorage",422,609,746,-324,0.56568364611260058]
["Post 49 - General Claire L. Chennault","Taipei - Taiwan",22,24,26,-4,0.84615384615384615]
["GM-01- Mid-Pacific","Tamuning",50,83,84,-34,0.59523809523809523]
["Grand Totals:   ",null,4179,5327,{"$f":"SUM(E5:E39)","v":5675},-1165,{"$f":"AVERAGE(C40/E40)","v":0.73638766519823784}]

{"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-01-04"]
["Post # and Name","Location",2019,2018,"Goal","Diff","% of Goal"]
["Post 02 - Valdez","Valdez",18,19,19,{"$f":"SUM(C6-E6)","v":-1},{"$f":"C6/E6","v":0.94736842105263153}]
["Post 07 - Skagway","Skagway",34,35,36,{"$f":"SUM(C7-E7)","v":-2},{"$f":"C7/E7","v":0.94444444444444442}]
["Post 15 - Matanuska Valley","Palmer",220,212,241,{"$f":"SUM(C8-E8)","v":-21},{"$f":"C8/E8","v":0.91286307053941906}]
["Post 01 - Jack Henry","Anchorage",477,496,530,{"$f":"SUM(C9-E9)","v":-53},{"$f":"C9/E9","v":0.9}]
["Post 35 - Susitna Valley","Wasilla",298,332,343,{"$f":"SUM(C10-E10)","v":-45},{"$f":"C10/E10","v":0.86880466472303208}]
["Post 08 - John W. Jones","Cordova",6,6,7,{"$f":"SUM(C11-E11)","v":-1},{"$f":"C11/E11","v":0.8571428571428571}]
["Post 14 - Edward Locken","Petersburg",6,7,7,{"$f":"SUM(E12-C12)","v":1},{"$f":"C12/E12","v":0.8571428571428571}]
["Post 22 - Jack Warren","Delta Junction",33,35,39,{"$f":"SUM(E13-C13)","v":6},{"$f":"C13/E13","v":0.84615384615384615}]
["Post 49 - General Claire L. Chennault","Taipei - Taiwan",22,24,26,{"$f":"SUM(C14-E14)","v":-4},{"$f":"C14/E14","v":0.84615384615384615}]
["Post 09 - Koyukuk","Coldfoot",26,28,31,{"$f":"SUM(C15-E15)","v":-5},{"$f":"C15/E15","v":0.83870967741935487}]
["Post 18 - Ninilchik","Ninilchik",89,108,112,{"$f":"SUM(C16-E16)","v":-23},{"$f":"C16/E16","v":0.7946428571428571}]
["Post 05 - Seward","Seward",181,219,228,{"$f":"SUM(C17-E17)","v":-47},{"$f":"C17/E17","v":0.79385964912280704}]
["Post 33 - Peters Creek","Chugiak",268,318,338,{"$f":"(C18-E18)","v":-70},{"$f":"C18/E18","v":0.79289940828402372}]
["Post 03 - Joseph T. Craig","Ketchikan",145,180,183,{"$f":"SUM(C19-E19)","v":-38},{"$f":"C19/E19","v":0.79234972677595628}]
["Post 25 - Auke Bay","Auke Bay",82,85,104,{"$f":"SUM(C20-E20)","v":-22},{"$f":"C20/E20","v":0.78846153846153844}]
["Post 28 - Spenard","Anchorage",482,578,614,{"$f":"SUM(C21-E21)","v":-132},{"$f":"C21/E21","v":0.78501628664495116}]
["Post 06 - Merlin Elmer Palmer","Wrangell",36,47,47,{"$f":"SUM(C22-E22)","v":-11},{"$f":"C22/E22","v":0.76595744680851063}]
["Post 27 - Gladys M. Heintz Memorial","Glenallen",33,45,44,{"$f":"SUM(C23-E23)","v":-11},{"$f":"C23/E23","v":0.75}]
["Post 21 - Aurora Borealis","Anchorage",39,57,53,{"$f":"SUM(C24-E24)","v":-14},{"$f":"C24/E24","v":0.73584905660377353}]
["Post 57 - C.R. Huber","Fairbanks",192,261,267,{"$f":"SUM(C25-E25)","v":-75},{"$f":"C25/E25","v":0.7191011235955056}]
["Post 20 - George H. Plumley Memorial","Kenai",153,216,217,{"$f":"SUM(C26-E26)","v":-64},{"$f":"C26/E26","v":0.70506912442396308}]
["Post 30 - Con Miller","North Pole",99,145,142,{"$f":"SUM(C27-E27)","v":-43},{"$f":"C27/E27","v":0.69718309859154926}]
["Post 16 - General Buckner","Homer",117,164,172,{"$f":"SUM(C28-E28)","v":-55},{"$f":"C28/E28","v":0.68023255813953487}]
["Post 12 - Lynn Canal","Haines",69,105,102,{"$f":"SUM(C29-E29)","v":-33},{"$f":"C29/E29","v":0.67647058823529416}]
["Post 11 - Dorman H. Baker","Fairbanks",144,210,214,{"$f":"SUM(C30-E30)","v":-70},{"$f":"C30/E30","v":0.67289719626168221}]
["Post 34 - Chappie James","Anchorage",36,55,56,{"$f":"SUM(C31-E31)","v":-20},{"$f":"C31/E31","v":0.6428571428571429}]
["Post 13 - Sitka","Sitka",56,86,88,{"$f":"SUM(C32-E32)","v":-32},{"$f":"C32/E32","v":0.63636363636363635}]
["Post 29 - Muldoon","Anchorage",203,289,320,{"$f":"SUM(C33-E33)","v":-117},{"$f":"C33/E33","v":0.63437500000000002}]
["Post 17 - Robert G. Blair","Kodiak",116,192,184,{"$f":"SUM(C34-E34)","v":-68},{"$f":"C34/E34","v":0.63043478260869568}]
["Post 04 - Pioneer","Anchorage",9,14,15,{"$f":"SUM(C35-E35)","v":-6},{"$f":"C35/E35","v":0.6}]
["GM-01- Mid-Pacific","Tamuning",50,83,84,{"$f":"SUM(C36-E36)","v":-34},{"$f":"C36/E36","v":0.59523809523809523}]
["Post 77 - Department Headquarters","Anchorage",422,609,746,{"$f":"SUM(C37-E37)","v":-324},{"$f":"C37/E37","v":0.56568364611260058}]
["Post 442 - Peter Heyano","Dillingham",9,18,21,{"$f":"SUM(C38-E38)","v":-12},{"$f":"C38/E38","v":0.42857142857142855}]
["Post 75 - Sterling","Sterling",3,12,12,{"$f":"SUM(C39-E39)","v":-9},{"$f":"C39/E39","v":0.25}]
["Post 26 - Prince of Wales","Craig",7,37,33,{"$f":"(C40-E40)","v":-26},{"$f":"C40/E40","v":0.21212121212121213}]
["Grand Totals:   ",null,4179,5327,{"$f":"SUM(E6:E40)","v":5675},-1165,{"$f":"AVERAGE(C41/E41)","v":0.73638766519823784}]

{"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 January 4, 2019"]
["SQD. #","SQUADRON NAME","GOAL","ACTUAL","PERCENTAGE"]
[18,"NINILCHIK",61,68,111.5]
[33,"PETERS CREEK",88,68,77.3]
[15,"MATANUSKA VALLEY",69,51,73.900000000000006]
[28,"SPENARD",135,98,72.599999999999994]
[35,"SUSITNA VALLEY",153,107,69.900000000000006]
[1,"JACK HENRY ",121,81,66.900000000000006]
[57,"C RUSSELL HUBER",142,90,63.4]
[29,"MULDOON",35,22,62.9]
[11,"DORMAN H BAKER",29,18,62.1]
["************","AVERAGE*****************************",1422,845,59.4]
[17,"ROBERT G BLAIR",148,77,52]
[5,"SEWARD",87,45,51.7]
[20,"GEORGE H PLUMLEY MEMORIAL",82,38,46.3]
[16,"GENERAL BUCKNER",90,36,40]
[3,"KETCHIKAN",41,16,39]
[13,"SITKA",52,18,34.6]
[12,"LYNN CANAL",50,12,24]
[34,"CHAPPIE JAMES",10,0,0]
[30,"CON MILLER",29,0,0]
[]
[]
[]
[]
[]
[null,"DETACHMENT",1422,845,59.4]

{"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 1/4/2019"]
["UNIT NO.","UNIT NAME","OBJECTIVE","JUNIOR","SENIOR","TOTAL","PERCENT"]
["0077","HEADQUARTERS",11,0,11,11,{"$f":"F3/C3","v":1}]
["0006","MERLIN ELMER PALMER",96,14,61,75,{"$f":"F4/C4","v":0.78125}]
["0442","PETER HEYANO - DILLINGHAM",16,1,8,9,0.5625]
["0027","GLADYS M. HEINTZ",15,0,8,8,{"$f":"F6/C6","v":0.53333333333333333}]
["0018","NINILCHIK",157,2,73,75,{"$f":"F7/C7","v":0.47770700636942676}]
["0035","SUSITNA VALLEY",229,4,103,107,{"$f":"F8/C8","v":0.46724890829694321}]
["0033","PETERS CREEK",216,7,92,99,{"$f":"F9/C9","v":0.45833333333333331}]
["0020","GEO. H. PLUMLEY MEMORIAL",216,5,94,99,{"$f":"F10/C10","v":0.45833333333333331}]
["0057","C. RUSSELL HUBER",278,6,121,127,{"$f":"F11/C11","v":0.45683453237410071}]
["0001","JACK HENRY ",376,6,163,169,{"$f":"F12/C12","v":0.44946808510638298}]
["0005","SEWARD",229,1,95,96,{"$f":"F13/C13","v":0.41921397379912662}]
["0011","DORMAN H. BAKER",121,3,45,48,{"$f":"F14/C14","v":0.39669421487603307}]
["0012","LYNN CANAL",156,1,56,57,{"$f":"F15/C15","v":0.36538461538461536}]
["0003","KETCHIKAN",82,0,29,29,{"$f":"F16/C16","v":0.35365853658536583}]
["0016","GENERAL BUCKNER",221,2,74,76,{"$f":"F17/C17","v":0.34389140271493213}]
["0029","MULDOON",166,0,52,52,{"$f":"F18/C18","v":0.31325301204819278}]
["0030","CON MILLER",56,0,17,17,{"$f":"F19/C19","v":0.30357142857142855}]
["0015","MATANUSKA VALLEY",237,1,67,68,{"$f":"F20/C20","v":0.28691983122362869}]
["0028","SPENARD",436,2,98,100,{"$f":"F21/C21","v":0.22935779816513763}]
["0034","CHAPPIE JAMES",41,0,3,3,{"$f":"F22/C22","v":7.3170731707317069E-2}]
["0019","NOME",62,0,4,4,{"$f":"F23/C23","v":6.4516129032258063E-2}]
["0013","SITKA",116,0,6,6,{"$f":"F24/C24","v":5.1724137931034482E-2}]
["0017","ROBERT G. BLAIR",251,0,3,3,{"$f":"F25/C25","v":1.1952191235059761E-2}]
[]
[null,"TOTAL",3769,55,1275,1330,{"$f":"F27/C27","v":0.35287874767842931}]