{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Automated Community Service Rpt","Read Me","Sheet3"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"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":"Automated Community Service Rpt","index":0,"n_rows":116,"n_cols":10,"rows_kept":116,"cut":false,"hidden":false,"merged":[[108,5,108,7],[108,1,108,3],[110,5,110,7],[110,1,110,3],[107,1,107,3],[109,1,109,3],[107,5,107,7],[109,5,109,7],[104,1,104,3],[106,5,106,7],[103,1,103,3],[105,1,105,3],[103,5,103,7],[105,5,105,7],[106,1,106,3],[98,5,98,7],[111,1,111,7],[88,0,88,7],[90,0,90,7],[92,0,92,7],[94,0,94,7],[98,1,98,3],[100,5,100,7],[100,1,100,3],[102,5,102,7],[99,1,99,3],[101,1,101,3],[99,5,99,7],[101,5,101,7],[102,1,102,3],[104,5,104,7],[81,0,81,6],[82,0,82,6],[84,0,84,9],[86,0,86,7],[96,0,96,7],[75,0,75,9],[77,0,77,6],[78,0,78,6],[79,0,79,6],[80,0,80,6],[69,0,69,6],[70,0,70,6],[71,0,71,6],[72,0,72,6],[73,0,73,6],[62,0,62,6],[63,0,63,6],[65,0,65,9],[66,0,66,9],[68,0,68,6],[56,0,56,9],[58,0,58,6],[59,0,59,6],[60,0,60,6],[61,0,61,6],[48,0,48,6],[49,0,49,6],[50,0,50,6],[51,0,51,6],[55,0,55,9],[41,0,41,6],[43,0,43,9],[44,0,44,9],[46,0,46,6],[47,0,47,6],[36,0,36,6],[37,0,37,6],[38,0,38,6],[39,0,39,6],[40,0,40,6],[29,0,29,6],[30,0,30,6],[31,0,31,6],[33,0,33,9],[34,0,34,9],[21,0,21,6],[23,0,23,9],[26,0,26,6],[27,0,27,6],[28,0,28,6],[16,0,16,6],[17,0,17,6],[18,0,18,6],[19,0,19,6],[20,0,20,6],[10,0,10,9],[4,1,4,3],[11,0,11,9],[13,0,13,9],[14,0,14,9],[0,0,0,9],[1,0,1,9],[2,0,2,9],[6,0,6,9],[7,0,7,9]]}
["Veterans of Foreign Wars"]
["Dept. of Tennessee"]
["Community Service Report Form"]
[]
[null,"Post/Auxiliary Number",null,null,null,null,"District"]
[]
["Report every month as soon as project is completed"]
[]
[null,null,"Reporting period for this report:",null,"From",null,"To"]
[]
["Circle each item, give a short description and record hours, money, mileage,"]
["number of projects, number of people for each group, e.g. Post or Auxiliary."]
[]
["Community Involvement:         Blood Drive, CPR Class, Recycling, Neighborhood Cleanup,"]
["                                                Highway Cleanup, and other projects."]
[]
[null,null,null,null,null,null,null,"Post",null,"Aux"]
[null,null,null,null,null,null,null,null,"~Hours~"]
[null,null,null,null,null,null,null,null,"~Money~"]
[null,null,null,null,null,null,null,null,"~Miles~"]
[null,null,null,null,null,null,null,null,"~Projects~"]
[null,null,null,null,null,null,null,null,"~People~"]
[]
["Cooperation With Others:        March of Dimes, Muscular Dystrophy, other Veterans Organizations"]
[null,null,null,"  or other Cooperative Projects"]
[]
[null,null,null,null,null,null,null,"Post",null,"Aux"]
[null,null,null,null,null,null,null,null,"~Hours~"]
[null,null,null,null,null,null,null,null,"~Money~"]
[null,null,null,null,null,null,null,null,"~Miles~"]
[null,null,null,null,null,null,null,null,"~Projects~"]
[null,null,null,null,null,null,null,null,"~People~"]
[]
["Aid to Others:           Hospital or Nursing Home Volunteers, Senior Citizens, Individuals with "]
["                                Special Needs, Personal or Family Tragedy or Illness, Aid to others in need,"]
[]
[null,null,null,null,null,null,null,"Post",null,"Aux"]
[null,null,null,null,null,null,null,null,"~Hours~"]
[null,null,null,null,null,null,null,null,"~Money~"]
[null,null,null,null,null,null,null,null,"~Miles~"]
[null,null,null,null,null,null,null,null,"~Projects~"]
[null,null,null,null,null,null,null,null,"~People~"]
[]
["School or Church Assistance:     Volunteer in School, Speaker of Program in School or Church,"]
["                                                   Other School or Church Assistance Project, Projects not listed above."]
[]
[null,null,null,null,null,null,null,"Post",null,"Aux"]
[null,null,null,null,null,null,null,null,"~Hours~"]
[null,null,null,null,null,null,null,null,"~Money~"]
[null,null,null,null,null,null,null,null,"~Miles~"]
[null,null,null,null,null,null,null,null,"~Projects~"]
[null,null,null,null,null,null,null,null,"~People~"]
[]
[]
[]
["Safety:      Pedestrian, Drug, Recreational, Highway, Home, Fire Safety, Public Recognition, "]
["                Other Safety Programs."]
[]
[null,null,null,null,null,null,null,"Post",null,"Aux"]
[null,null,null,null,null,null,null,null,"~Hours~"]
[null,null,null,null,null,null,null,null,"~Money~"]
[null,null,null,null,null,null,null,null,"~Miles~"]
[null,null,null,null,null,null,null,null,"~Projects~"]
[null,null,null,null,null,null,null,null,"~People~"]
[]
["Citizenship Education:    Flag Presentation, Color Guard, Voter Registration, Patriotic Program in School,"]
["                                       Veterans Day, Memorial Day, Loyalty Day, or any other program."]
[]
[null,null,null,null,null,null,null,"Post",null,"Aux"]
[null,null,null,null,null,null,null,null,"~Hours~"]
[null,null,null,null,null,null,null,null,"~Money~"]
[null,null,null,null,null,null,null,null,"~Miles~"]
[null,null,null,null,null,null,null,null,"~Projects~"]
[null,null,null,null,null,null,null,null,"~People~"]
[]
["Youth Activities:  Sports and Athletics, Boy Scouts, Girl Scouts, Junior Girls, Special Events."]
[]
[null,null,null,null,null,null,null,"Post",null,"Aux"]
[null,null,null,null,null,null,null,null,"~Hours~"]
[null,null,null,null,null,null,null,null,"~Money~"]
[null,null,null,null,null,null,null,null,"~Miles~"]
[null,null,null,null,null,null,null,null,"~Projects~"]
[null,null,null,null,null,null,null,null,"~People~"]
[]
["Circle YES or NO              This Year (May 1st to April 30th)"]
[]
["(L) Did your Post have a Loyalty Day Program?",null,null,null,null,null,null,null,"YES","NO"]
[]
["(V) Did your Post Submit a Voice of Democracy entry to the District?",null,null,null,null,null,null,null,"YES","NO"]
[]
["(P) Did your Post Submit a Patriots Pen entry to the District?",null,null,null,null,null,null,null,"YES","NO"]
[]
["(T) Did your Post Submit a Teacher of the Year entry to the District?",null,null,null,null,null,null,null,"YES","NO"]
[]
["(BP) Did your Post purchase Buddy Poppies?",null,null,null,null,null,null,null,"YES","NO"]
[]
["(VMS) Did your Post make a donation to Veterans & Military Support? Formally NMS",null,null,null,null,null,null,null,"YES","NO"]
[]
[null,"Total Post Hours",null,null,{"$f":"SUM(H18,H28,H38,H48,H60,H70,H79)","v":0},"Total Post Money Donated",null,null,{"$f":"SUM(H80,H71,H61,H49,H39,H29,H19)","v":0}]
[]
[null,"Total Aux Hours",null,null,{"$f":"SUM(J79,J70,J60,J48,J38,J28,J18)","v":0},"Total Aux Money Donated",null,null,{"$f":"SUM(J80,J71,J61,J75,J49,J39,J29,J19)","v":0}]
[]
[null,"Total Hours",null,null,{"$f":"SUM(H18,H28,H38,H48,H60,H70,H79,J79,J70,J60,J48,J38,J28,J18)","v":0},"Total Money Donated",null,null,{"$f":"SUM(H80,J80,H71,J71,J61,H61,H49,J49,H39,J39,J29,H29,J19,H19)","v":0}]
[]
[null,"Total Post Projects",null,null,{"$f":"SUM(H82,H73,H63,H51,H41,H31,H21,)","v":0},"Total Post Miles",null,null,{"$f":"SUM(H81,H72,H50,H40,H30,H20,H62)","v":0}]
[]
[null,"Total Auxiliary Projects",null,null,{"$f":"SUM(J82,J73,J63,J51,J41,J31,J21)","v":0},"Total Aux Miles",null,null,{"$f":"SUM(J81,J72,J62,J50,J40,J30,J20,)","v":0}]
[]
[null,"Total Projects",null,null,{"$f":"SUM(H82,H73,H63,H51,H41,H31,H21,J82,J73,J63,J51,J41,J31,J21)","v":0},"Total Miles",null,null,{"$f":"SUM(I105,I107)","v":0}]
[]
[null,"Total People",null,null,{"$f":"SUM(H83,J83,H74,J74,H64,J64,H52,J52,H42,J42,H32,J32,H22,J22)","v":0},"Total Miles X $.14=",null,null,{"$f":"PRODUCT(0.14,I109)","v":0}]
[null,"    Dollar value of this report activities (donated + mileage) = ",null,null,null,null,null,null,{"$f":"SUM(I111,I103)","v":0}]
[]
[null,null,"Community Service Officer:      "," "]
[]
[null,null,null,null,null,null,null,null,"  Revised 7/11"]

{"sheet":"Read Me","index":1,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Bill Sparks"]
["Junior Vice Commander, Post 4848"]
[]
["mailto:bwsparks@epbfi.com"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}