{"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-29"]
["Post # and Name","Location",2019,2018,"Goal","Diff","% of Goal"]
["GM-01- Mid-Pacific","Tamuning",64,83,84,{"$f":"SUM(C5-E5)","v":-20},{"$f":"C5/E5","v":0.76190476190476186}]
["Post 01 - Jack Henry","Anchorage",538,496,530,8,1.0150943396226415]
["Post 02 - Valdez","Valdez",18,19,19,-1,0.94736842105263153]
["Post 03 - Joseph T. Craig","Ketchikan",167,180,183,-16,0.91256830601092898]
["Post 04 - Pioneer","Anchorage",9,14,15,-6,0.6]
["Post 05 - Seward","Seward",212,219,228,-16,0.92982456140350878]
["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",177,210,214,-37,0.82710280373831779]
["Post 12 - Lynn Canal","Haines",91,105,102,-11,0.89215686274509809]
["Post 13 - Sitka","Sitka",72,86,88,-16,0.81818181818181823]
["Post 14 - Edward Locken","Petersburg",6,7,7,-1,0.8571428571428571]
["Post 15 - Matanuska Valley","Palmer",258,212,241,{"$f":"SUM(C19-E19)","v":17},1.0705394190871369]
["Post 16 - General Buckner","Homer",141,164,172,-31,0.81976744186046513]
["Post 17 - Robert G. Blair","Kodiak",154,192,184,-30,0.83695652173913049]
["Post 18 - Ninilchik","Ninilchik",98,108,112,-14,0.875]
["Post 20 - George H. Plumley Memorial","Kenai",185,216,217,-32,0.85253456221198154]
["Post 21 - Aurora Borealis","Anchorage",45,57,53,-8,0.84905660377358494]
["Post 22 - Jack Warren","Delta Junction",40,35,39,1,1.0256410256410255]
["Post 25 - Auke Bay","Auke Bay",94,97,102,{"$f":"SUM(C26-E26)","v":-8},0.92156862745098034]
["Post 26 - Prince of Wales","Craig",10,37,33,{"$f":"(C27-E27)","v":-23},0.30303030303030304]
["Post 27 - Gladys M. Heintz Memorial","Glenallen",40,45,44,{"$f":"SUM(C28-E28)","v":-4},0.90909090909090906]
["Post 28 - Spenard","Anchorage",621,578,614,{"$f":"SUM(C29-E29)","v":7},1.0114006514657981]
["Post 29 - Muldoon","Anchorage",267,289,320,{"$f":"SUM(C30-E30)","v":-53},0.83437499999999998]
["Post 30 - Con Miller","North Pole",129,145,142,{"$f":"SUM(C31-E31)","v":-13},0.90845070422535212]
["Post 33 - Peters Creek","Chugiak",303,318,338,{"$f":"(C32-E32)","v":-35},0.89644970414201186]
["Post 34 - Chappie James","Anchorage",45,55,56,{"$f":"SUM(C33-E33)","v":-11},0.8035714285714286]
["Post 35 - Susitna Valley","Wasilla",352,332,343,9,1.0262390670553936]
["Post 442 - Peter Heyano","Dillingham",19,18,21,-2,0.90476190476190477]
["Post 49 - General Claire L. Chennault","Taipei - Taiwan",22,24,26,-4,0.84615384615384615]
["Post 57 - C.R. Huber","Fairbanks",238,261,267,-29,0.89138576779026213]
["Post 77 - Department Headquarters","Anchorage",478,609,746,-268,0.64075067024128685]
["Post 75 - Sterling","Sterling",4,12,12,-8,0.33333333333333331]
["Grand Totals:   ",null,5007,5327,{"$f":"SUM(E5:E39)","v":5673},null,{"$f":"AVERAGE(C40/E40)","v":0.88260179799048122}]

{"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-29"]
["Post # and Name","Location",2019,2018,"Goal","Diff","% of Goal"]
["Post 15 - Matanuska Valley","Palmer",258,212,241,{"$f":"SUM(C6-E6)","v":17},{"$f":"C6/E6","v":1.0705394190871369}]
["Post 35 - Susitna Valley","Wasilla",352,332,343,{"$f":"SUM(C7-E7)","v":9},{"$f":"C7/E7","v":1.0262390670553936}]
["Post 22 - Jack Warren","Delta Junction",40,35,39,1,{"$f":"C8/E8","v":1.0256410256410255}]
["Post 01 - Jack Henry","Anchorage",538,496,530,{"$f":"SUM(C9-E9)","v":8},{"$f":"C9/E9","v":1.0150943396226415}]
["Post 28 - Spenard","Anchorage",621,578,614,{"$f":"SUM(C10-E10)","v":7},{"$f":"C10/E10","v":1.0114006514657981}]
["Post 02 - Valdez","Valdez",18,19,19,{"$f":"SUM(C11-E11)","v":-1},{"$f":"C11/E11","v":0.94736842105263153}]
["Post 07 - Skagway","Skagway",34,35,36,{"$f":"SUM(C12-E12)","v":-2},{"$f":"C12/E12","v":0.94444444444444442}]
["Post 06 - Merlin Elmer Palmer","Wrangell",44,47,47,{"$f":"SUM(C13-E13)","v":-3},{"$f":"C13/E13","v":0.93617021276595747}]
["Post 05 - Seward","Seward",212,219,228,{"$f":"SUM(C14-E14)","v":-16},{"$f":"C14/E14","v":0.92982456140350878}]
["Post 25 - Auke Bay","Auke Bay",94,97,102,{"$f":"SUM(C15-E15)","v":-8},{"$f":"C15/E15","v":0.92156862745098034}]
["Post 03 - Joseph T. Craig","Ketchikan",167,180,183,{"$f":"SUM(C16-E16)","v":-16},{"$f":"C16/E16","v":0.91256830601092898}]
["Post 27 - Gladys M. Heintz Memorial","Glenallen",40,45,44,{"$f":"SUM(C17-E17)","v":-4},{"$f":"C17/E17","v":0.90909090909090906}]
["Post 30 - Con Miller","North Pole",129,145,142,{"$f":"SUM(C18-E18)","v":-13},{"$f":"C18/E18","v":0.90845070422535212}]
["Post 442 - Peter Heyano","Dillingham",19,18,21,{"$f":"SUM(C19-E19)","v":-2},{"$f":"C19/E19","v":0.90476190476190477}]
["Post 33 - Peters Creek","Chugiak",303,318,338,{"$f":"(C20-E20)","v":-35},{"$f":"C20/E20","v":0.89644970414201186}]
["Post 12 - Lynn Canal","Haines",91,105,102,{"$f":"SUM(C21-E21)","v":-11},{"$f":"C21/E21","v":0.89215686274509809}]
["Post 57 - C.R. Huber","Fairbanks",238,261,267,{"$f":"SUM(C22-E22)","v":-29},{"$f":"C22/E22","v":0.89138576779026213}]
["Post 18 - Ninilchik","Ninilchik",98,108,112,{"$f":"SUM(C23-E23)","v":-14},{"$f":"C23/E23","v":0.875}]
["Post 08 - John W. Jones","Cordova",6,6,7,{"$f":"SUM(C24-E24)","v":-1},{"$f":"C24/E24","v":0.8571428571428571}]
["Post 14 - Edward Locken","Petersburg",6,7,7,-1,{"$f":"C25/E25","v":0.8571428571428571}]
["Post 20 - George H. Plumley Memorial","Kenai",185,216,217,{"$f":"SUM(C26-E26)","v":-32},{"$f":"C26/E26","v":0.85253456221198154}]
["Post 21 - Aurora Borealis","Anchorage",45,57,53,{"$f":"SUM(C27-E27)","v":-8},{"$f":"C27/E27","v":0.84905660377358494}]
["Post 49 - General Claire L. Chennault","Taipei - Taiwan",22,24,26,{"$f":"SUM(C28-E28)","v":-4},{"$f":"C28/E28","v":0.84615384615384615}]
["Post 09 - Koyukuk","Coldfoot",26,28,31,{"$f":"SUM(C29-E29)","v":-5},{"$f":"C29/E29","v":0.83870967741935487}]
["Post 17 - Robert G. Blair","Kodiak",154,192,184,{"$f":"SUM(C30-E30)","v":-30},{"$f":"C30/E30","v":0.83695652173913049}]
["Post 29 - Muldoon","Anchorage",267,289,320,{"$f":"SUM(C31-E31)","v":-53},{"$f":"C31/E31","v":0.83437499999999998}]
["Post 11 - Dorman H. Baker","Fairbanks",177,210,214,{"$f":"SUM(C32-E32)","v":-37},{"$f":"C32/E32","v":0.82710280373831779}]
["Post 16 - General Buckner","Homer",141,164,172,{"$f":"SUM(C33-E33)","v":-31},{"$f":"C33/E33","v":0.81976744186046513}]
["Post 13 - Sitka","Sitka",72,86,88,{"$f":"SUM(C34-E34)","v":-16},{"$f":"C34/E34","v":0.81818181818181823}]
["Post 34 - Chappie James","Anchorage",45,55,56,{"$f":"SUM(C35-E35)","v":-11},{"$f":"C35/E35","v":0.8035714285714286}]
["GM-01- Mid-Pacific","Tamuning",64,83,84,{"$f":"SUM(C36-E36)","v":-20},{"$f":"C36/E36","v":0.76190476190476186}]
["Post 77 - Department Headquarters","Anchorage",478,609,746,{"$f":"SUM(C37-E37)","v":-268},{"$f":"C37/E37","v":0.64075067024128685}]
["Post 04 - Pioneer","Anchorage",9,14,15,{"$f":"SUM(C38-E38)","v":-6},{"$f":"C38/E38","v":0.6}]
["Post 75 - Sterling","Sterling",4,12,12,{"$f":"SUM(C39-E39)","v":-8},{"$f":"C39/E39","v":0.33333333333333331}]
["Post 26 - Prince of Wales","Craig",10,37,33,{"$f":"(C40-E40)","v":-23},{"$f":"C40/E40","v":0.30303030303030304}]
["Grand Totals:   ",null,5007,5327,{"$f":"SUM(E6:E40)","v":5673},null,{"$f":"AVERAGE(C41/E41)","v":0.88260179799048122}]

{"sheet":"SAL 2019","index":2,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Barometer 2019 as of March 29, 2019"]
[]
["SQD. #","SQUADRON NAME","GOAL","ACTUAL","PERCENTAGE"]
[29,"MULDOON",35,47,134.30000000000001]
[28,"SPENARD",135,165,122.2]
[18,"NINILCHIK",61,68,111.5]
[15,"MATANUSKA VALLEY",69,72,104.3]
[33,"PETERS CREEK",88,91,103.4]
[57,"C RUSSELL HUBER",142,134,94.4]
[35,"SUSITNA VALLEY",153,140,91.5]
["************","AVERAGE*****************************",1422,1213,85.3]
[1,"JACK HENRY ",121,101,83.5]
[11,"DORMAN H BAKER",29,24,82.8]
[17,"ROBERT G BLAIR",148,122,82.4]
[20,"GEORGE H PLUMLEY MEMORIAL",82,57,69.5]
[16,"GENERAL BUCKNER",90,62,68.900000000000006]
[5,"SEWARD",87,54,62.1]
[13,"SITKA",52,31,59.6]
[3,"KETCHIKAN",41,24,58.5]
[30,"CON MILLER",29,10,34.5]
[12,"LYNN CANAL",50,12,24]
[34,"CHAPPIE JAMES",10,0,0]
[]
[]
[]
[]
[]
[null,"DETACHMENT",1422,1213,85.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 3/29/2019"]
["UNIT NO.","UNIT NAME","OBJECTIVE","JUNIOR","SENIOR","TOTAL","PERCENT"]
["0077","HEADQUARTERS",11,0,16,16,{"$f":"F3/C3","v":1.4545454545454546}]
["0006","MERLIN ELMER PALMER",96,18,87,95,{"$f":"F4/C4","v":0.98958333333333337}]
["0035","SUSITNA VALLEY",229,10,167,177,{"$f":"F5/C5","v":0.77292576419213976}]
["0057","C. RUSSELL HUBER",278,15,197,212,{"$f":"F6/C6","v":0.76258992805755399}]
["0442","PETER HEYANO - DILLINGHAM",16,1,11,12,0.75]
["0027","GLADYS M. HEINTZ",15,0,10,10,{"$f":"F8/C8","v":0.66666666666666663}]
["0033","PETERS CREEK",216,8,128,136,{"$f":"F9/C9","v":0.62962962962962965}]
["0001","JACK HENRY ",376,6,223,229,{"$f":"F10/C10","v":0.60904255319148937}]
["0020","GEO. H. PLUMLEY MEMORIAL",216,12,117,129,{"$f":"F11/C11","v":0.59722222222222221}]
["0005","SEWARD",229,2,133,135,{"$f":"F12/C12","v":0.58951965065502188}]
["0012","LYNN CANAL",156,1,88,91,{"$f":"F13/C13","v":0.58333333333333337}]
["0011","DORMAN H. BAKER",121,3,67,70,{"$f":"F14/C14","v":0.57851239669421484}]
["0003","KETCHIKAN",82,1,44,45,{"$f":"F15/C15","v":0.54878048780487809}]
["0018","NINILCHIK",157,2,81,83,{"$f":"F16/C16","v":0.5286624203821656}]
["0016","GENERAL BUCKNER",221,2,114,116,{"$f":"F17/C17","v":0.52488687782805432}]
["0029","MULDOON",166,0,84,84,{"$f":"F18/C18","v":0.50602409638554213}]
["0034","CHAPPIE JAMES",41,0,18,18,{"$f":"F19/C19","v":0.43902439024390244}]
["0015","MATANUSKA VALLEY",237,3,100,103,{"$f":"F20/C20","v":0.43459915611814348}]
["0028","SPENARD",436,3,183,186,{"$f":"F21/C21","v":0.42660550458715596}]
["0013","SITKA",116,0,48,48,{"$f":"F22/C22","v":0.41379310344827586}]
["0017","ROBERT G. BLAIR",251,1,82,83,{"$f":"F23/C23","v":0.33067729083665337}]
["0030","CON MILLER",56,0,17,17,{"$f":"F24/C24","v":0.30357142857142855}]
["0019","NOME",62,0,5,5,{"$f":"F25/C25","v":8.0645161290322578E-2}]
[]
[null,"TOTAL",3784,90,2021,2100,{"$f":"F27/C27","v":0.55496828752642702}]