{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["membership","%","SAL 2021","SAL 2020","AUX 2021","AUX 2020"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":6,"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":"membership","index":0,"n_rows":40,"n_cols":14,"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"]
["2020-10-23"]
["Post # and Name","Location",2021,2020,"Goal","Diff","% of Goal"]
["GM-01- Mid-Pacific","Tamuning",40,67,74,{"$f":"SUM(C5-E5)","v":-34},{"$f":"C5/E5","v":0.54054054054054057}]
["Post 01 - Jack Henry","Anchorage",430,617,637,-207,0.67503924646781788]
["Post 02 - Valdez","Valdez",14,16,23,-9,0.60869565217391308]
["Post 03 - Joseph T. Craig","Ketchikan",129,177,193,-64,0.66839378238341973]
["Post 04 - Pioneer","Anchorage",9,10,14,-5,0.6428571428571429]
["Post 05 - Seward","Seward",160,229,234,-74,0.68376068376068377]
["Post 06 - Merlin Elmer Palmer","Wrangell",23,38,49,-26,0.46938775510204084]
["Post 07 - Skagway","Skagway",33,33,39,-6,0.84615384615384615]
["Post 08 - John W. Jones","Cordova",4,6,11,-7,0.36363636363636365]
["Post 09 - Koyukuk","Coldfoot",21,32,32,-11,0.65625]
["Post 11 - Dorman H. Baker","Fairbanks",109,124,207,-98,0.52657004830917875]
["Post 12 - Lynn Canal","Haines",44,89,106,-62,0.41509433962264153,null,null,null,null,null,null,{"$f":"SUM(C5:C39)","v":3323}]
["Post 13 - Sitka","Sitka",40,64,84,-44,0.47619047619047616]
["Post 14 - Edward Locken","Petersburg",6,6,11,-5,0.54545454545454541]
["Post 15 - Matanuska Valley","Palmer",160,258,288,-128,0.55555555555555558]
["Post 16 - General Buckner","Homer",84,143,162,-78,0.51851851851851849]
["Post 17 - Robert G. Blair","Kodiak",109,179,189,-80,0.57671957671957674]
["Post 18 - Ninilchik","Ninilchik",79,104,110,-31,0.71818181818181814]
["Post 20 - George H. Plumley Memorial","Kenai",135,199,221,-86,0.61085972850678738]
["Post 21 - Aurora Borealis","Anchorage",28,52,61,-33,0.45901639344262296]
["Post 22 - Jack Warren","Delta Junction",27,40,48,-21,0.5625]
["Post 25 - Auke Bay","Auke Bay",69,97,106,-37,0.65094339622641506]
["Post 26 - Prince of Wales","Craig",3,18,23,{"$f":"(C27-E27)","v":-20},0.13043478260869565]
["Post 27 - Gladys M. Heintz Memorial","Glenallen",26,38,46,{"$f":"SUM(C28-E28)","v":-20},0.56521739130434778]
["Post 28 - Spenard","Anchorage",359,577,604,{"$f":"SUM(C29-E29)","v":-245},0.5943708609271523]
["Post 29 - Muldoon","Anchorage",159,288,320,{"$f":"SUM(C30-E30)","v":-161},0.49687500000000001]
["Post 30 - Con Miller","North Pole",70,133,160,{"$f":"SUM(C31-E31)","v":-90},0.4375]
["Post 33 - Peters Creek","Chugiak",216,341,350,{"$f":"(C32-E32)","v":-134},0.6171428571428571]
["Post 34 - Chappie James","Anchorage",24,38,56,{"$f":"SUM(C33-E33)","v":-32},0.42857142857142855]
["Post 35 - Susitna Valley","Wasilla",241,402,417,{"$f":"SUM(C34-E34)","v":-176},0.57793764988009588]
["Post 49 - General Claire L. Chennault","Taipei - Taiwan",19,21,27,{"$f":"SUM(C35-E35)","v":-8},0.70370370370370372]
["Post 57 - C.R. Huber","Fairbanks",107,255,280,{"$f":"SUM(C36-E36)","v":-173},0.38214285714285712]
["Post 100 - Eagle River","Eagle River",1,20,24,{"$f":"SUM((C37-E37))","v":-23},{"$f":"SUM(C37/E37)","v":4.1666666666666664E-2}]
["Post 442 - Peter Heyano","Dillingham",8,10,28,{"$f":"SUM(C38-E38)","v":-20},{"$f":"C38/E38","v":0.2857142857142857}]
["Post 77 - Department Headquarters","Anchorage",337,466,466,{"$f":"SUM(C39-E39)","v":-129},{"$f":"C39/E39","v":0.72317596566523601}]
["Grand Totals:   ",null,3323,5414,5502,null,{"$f":"AVERAGE(C40/E40)","v":0.60396219556524899}]

{"sheet":"%","index":1,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,6],[1,0,1,6]]}
["The American Legion Department of Alaska"]
["Percentage Membership Report"]
["2020-10-23"]
["Post # and Name","Location",2021,2020,"Goal","Diff","% of Goal"]
["Post 07 - Skagway","Skagway",33,33,39,{"$f":"SUM(C5-E5)","v":-6},{"$f":"C5/E5","v":0.84615384615384615}]
["Post 77 - Department Headquarters","Anchorage",337,466,466,-129,0.72317596566523601]
["Post 18 - Ninilchik","Ninilchik",79,104,110,-31,0.71818181818181814]
["Post 49 - General Claire L. Chennault","Taipei - Taiwan",19,21,27,-8,0.70370370370370372]
["Post 05 - Seward","Seward",160,229,234,-74,0.68376068376068377]
["Post 01 - Jack Henry","Anchorage",430,617,637,-207,0.67503924646781788]
["Post 03 - Joseph T. Craig","Ketchikan",129,177,193,-64,0.66839378238341973]
["Post 09 - Koyukuk","Coldfoot",21,32,32,-11,0.65625]
["Post 25 - Auke Bay","Auke Bay",69,97,106,-37,0.65094339622641506]
["Post 04 - Pioneer","Anchorage",9,10,14,-5,0.6428571428571429]
["Post 33 - Peters Creek","Chugiak",216,341,350,{"$f":"(C15-E15)","v":-134},0.6171428571428571]
["Post 20 - George H. Plumley Memorial","Kenai",135,199,221,{"$f":"SUM(C16-E16)","v":-86},0.61085972850678738]
["Post 02 - Valdez","Valdez",14,16,23,-9,0.60869565217391308]
["Post 28 - Spenard","Anchorage",359,577,604,-245,0.5943708609271523]
["Post 35 - Susitna Valley","Wasilla",241,402,417,-176,0.57793764988009588]
["Post 17 - Robert G. Blair","Kodiak",109,179,189,-80,0.57671957671957674]
["Post 27 - Gladys M. Heintz Memorial","Glenallen",26,38,46,-20,0.56521739130434778]
["Post 22 - Jack Warren","Delta Junction",27,40,48,-21,0.5625]
["Post 15 - Matanuska Valley","Palmer",160,258,288,-128,0.55555555555555558]
["Post 14 - Edward Locken","Petersburg",6,6,11,-5,0.54545454545454541]
["GM-01- Mid-Pacific","Tamuning",40,67,74,-34,0.54054054054054057]
["Post 11 - Dorman H. Baker","Fairbanks",109,124,207,-98,0.52657004830917875]
["Post 16 - General Buckner","Homer",84,143,162,-78,0.51851851851851849]
["Post 29 - Muldoon","Anchorage",159,288,320,-161,0.49687500000000001]
["Post 13 - Sitka","Sitka",40,64,84,-44,0.47619047619047616]
["Post 06 - Merlin Elmer Palmer","Wrangell",23,38,49,-26,0.46938775510204084]
["Post 21 - Aurora Borealis","Anchorage",28,52,61,-33,0.45901639344262296]
["Post 30 - Con Miller","North Pole",70,133,160,-90,0.4375]
["Post 34 - Chappie James","Anchorage",24,38,56,-32,0.42857142857142855]
["Post 12 - Lynn Canal","Haines",44,89,106,-62,0.41509433962264153]
["Post 57 - C.R. Huber","Fairbanks",107,255,280,-173,0.38214285714285712]
["Post 08 - John W. Jones","Cordova",4,6,11,-7,0.36363636363636365]
["Post 442 - Peter Heyano","Dillingham",8,10,28,-20,0.2857142857142857]
["Post 26 - Prince of Wales","Craig",3,18,23,{"$f":"(C38-E38)","v":-20},0.13043478260869565]
["Post 100 - Eagle River","Eagle River",1,20,24,{"$f":"SUM((C39-E39))","v":-23},{"$f":"SUM(C39/E39)","v":4.1666666666666664E-2}]
["Grand Totals:   ",null,3323,5414,5502,null,{"$f":"AVERAGE(C40/E40)","v":0.60396219556524899}]

{"sheet":"SAL 2021","index":2,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Barometer 2021 as of 10/16/20"]
[]
["SQD #","SQUADRON NAME","GOAL","ACTUAL","PERCENTAGE"]
[16,"GENERAL BUCKNER",70,52,74.3]
[29,"MULDOON",44,24,54.5]
[33,"PETERS CREEK",108,56,51.9]
[28,"SPENARD",135,69,51.1]
[35,"SUSITNA VALLEY",156,79,50.3]
[15,"MATANUSKA VALLEY",82,36,43.9]
[57,"C RUSSELL HUBER",159,69,43.4]
[1,"JACK HENRY ",129,54,41.9]
[3,"KETCHIKAN",40,14,35]
["************","AVERAGE*****************************",1436,486,33.799999999999997]
[5,"SEWARD",79,26,32.9]
[11,"DORMAN H BAKER",27,7,25.9]
[12,"LYNN CANAL",49,0,0]
[13,"SITKA",54,0,0]
[17,"ROBERT G BLAIR",146,0,0]
[18,"NINILCHIK",64,0,0]
[20,"GEORGE H PLUMLEY MEMORIAL",55,0,0]
[30,"CON MILLER",26,0,0]
[34,"CHAPPIE JAMES",12,0,0]
[]
[]
[]
[]
[]
[null,"DETACHMENT",1436,486,33.799999999999997]

{"sheet":"SAL 2020","index":3,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Barometer 2020 as of 10/16/2020"]
[]
["SQD #","SQUADRON NAME","GOAL","ACTUAL","PERCENTAGE"]
[13,"SITKA",44,54,122.7]
[34,"CHAPPIE JAMES",10,12,120]
[33,"PETERS CREEK",97,108,111.3]
[30,"CON MILLER",25,26,104]
[15,"MATANUSKA VALLEY",79,82,103.8]
[1,"JACK HENRY ",128,129,100.8]
[5,"SEWARD",79,79,100]
[57,"C RUSSELL HUBER",159,158,99.4]
[17,"ROBERT G BLAIR",147,146,99.3]
[3,"KETCHIKAN",41,40,97.6]
["************","AVERAGE*****************************",1487,1435,96.5]
[11,"DORMAN H BAKER",28,27,96.4]
[35,"SUSITNA VALLEY",163,157,96.3]
[12,"LYNN CANAL",51,49,96.1]
[18,"NINILCHIK",68,64,94.1]
[16,"GENERAL BUCKNER",80,70,87.5]
[29,"MULDOON",51,44,86.3]
[20,"GEORGE H PLUMLEY MEMORIAL",64,55,85.9]
[28,"SPENARD",173,135,78]
[]
[null,"DETACHMENT",1487,1435,96.5]

{"sheet":"AUX 2021","index":4,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,0,2,6]]}
[]
[]
["ALA 2021 BAROMETER as of 10/23/2020"]
["UNIT NO.","UNIT NAME","OBJECTIVE","JR.","SR.","TOTAL","PERCENT"]
["0077","HEADQUARTERS",20,0,19,19,0.95]
["0027","GLADYS M. HEINTZ",10,0,6,6,0.6]
["0003","KETCHIKAN",54,2,30,32,{"$f":"F7/C7","v":0.59259259259259256}]
["0033","PETERS CREEK",158,11,66,77,0.48734177215189872]
["0011","DORMAN H. BAKER",71,0,31,31,0.43661971830985913]
["0016","GENERAL BUCKNER",127,0,60,60,0.47244094488188976]
["0057","C. RUSSELL HUBER",210,10,82,92,0.43809523809523809]
["0005","SEWARD",154,4,60,64,0.41558441558441561]
["0035","SUSITNA VALLEY",200,6,91,97,0.48499999999999999]
["0006","MERLIN ELMER PALMER",105,2,33,35,0.33329999999999999]
["0001","JACK HENRY ",239,1,83,84,{"$f":"F15/C15","v":0.35146443514644349}]
["0029","MULDOON",100,0,21,21,{"$f":"F16/C16","v":0.21}]
["0034","CHAPPIE JAMES",10,0,2,2,{"$f":"F17/C17","v":0.2}]
["0020","GEO. H. PLUMLEY MEMORIAL",138,2,26,28,{"$f":"F18/C18","v":0.20289855072463769}]
["0018","NINILCHIK",85,0,16,47,{"$f":"F19/C19","v":0.55294117647058827}]
["0017","ROBERT G. BLAIR",122,0,22,22,0.18029999999999999]
["0015","MATANUSKA VALLEY",120,1,43,44,{"$f":"F21/C21","v":0.36666666666666664}]
["0028","SPENARD",252,0,68,68,0.26984126984126983]
["0013","SITKA",50,0,5,5,0.1]
["0012","LYNN CANAL",92,0,34,34,0.36956521739130432]
["0030","CON MILLER",30,0,1,1,3.3333333333333333E-2]
["0442","PETER HEYANO - DILLINGHAM",12,0,0,0,0]
[]
[null,"TOTAL",2365,39,830,869,0.3674]

{"sheet":"AUX 2020","index":5,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["ALA 2020 BAROMETER as of 10/23/2020"]
["UNIT NO.","UNIT NAME","OBJECTIVE","JR.","SR.","TOTAL","PERCENT"]
["0077","HEADQUARTERS",17,0,27,27,1.5882000000000001]
["0028","SPENARD",217,5,273,278,{"$f":"F4/C4","v":1.2811059907834101}]
["0017","ROBERT G. BLAIR",105,3,119,122,1.161904761904762]
["0035","SUSITNA VALLEY",205,16,212,226,1.102439024390244]
["0033","PETERS CREEK",158,20,154,174,1.1012658227848102]
["0005","SEWARD",163,3,163,166,1.01840490797546]
["0003","KETCHIKAN",55,4,52,56,1.0181818181818181]
["0027","GLADYS M. HEINTZ",10,0,10,10,1]
["0006","MERLIN ELMER PALMER",102,16,84,100,0.98040000000000005]
["0016","GENERAL BUCKNER",133,7,123,130,{"$f":"F12/C12","v":0.97744360902255634}]
["0015","MATANUSKA VALLEY",125,1,119,120,0.96]
["0057","C. RUSSELL HUBER",245,26,209,235,0.95918367346938771]
["0020","GEO. H. PLUMLEY MEMORIAL",148,15,125,140,0.94594594594594594]
["0018","NINILCHIK",90,2,83,85,0.94444444444444442]
["0011","DORMAN H. BAKER",79,4,67,71,0.89873417721518989]
["0012","LYNN CANAL",104,1,92,93,0.89423076923076927]
["0030","CON MILLER",30,2,24,26,0.8666666666666667]
["0029","MULDOON",103,0,87,87,0.84466019417475724]
["0001","JACK HENRY ",259,5,206,211,0.81467181467181471]
["0019","NOME",10,0,8,8,0.8]
["0442","PETER HEYANO - DILLINGHAM",13,0,10,10,{"$f":"F23/C23","v":0.76923076923076927}]
["0013","SITKA",58,0,21,21,{"$f":"F24/C24","v":0.36206896551724138}]
["0034","CHAPPIE JAMES",25,0,7,7,{"$f":"F25/C25","v":0.28000000000000003}]
[]
[null,"TOTAL",2437,130,2275,2405,0.9869]