{"text_format":"3","workbook":"xlsx","n_sheets":18,"sheets":["Summary","S-1","S-2","S-3","S-4","S-5","S-6","S-7","S-8","S-9","S-10","S-11","S-12AB","S-12C","S-12D","S-12E","S-13","S-14"],"not_rendered":{"images":324,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":37,"n_cols":12,"rows_kept":37}
[]
[null,"SUMMARY OF STARK AWARD POINTS"]
[null,"(as of 31 December, 2016)",{"$nulls":8}," ","  "]
[null,"Section",{"$nulls":8},"Sub-Total","TOTAL"]
[null,1,"Chapter Member Appointed to a VA Hospital Council, etc.",{"$nulls":8},{"$f":"'S-1'!G34","v":0}]
[null,2,"Each Hour Served in VA Hospital Volunteer Service",{"$nulls":7}," ",{"$f":"'S-2'!G65","v":0}]
[null,3,"Each SAR Member Visiting a Veteran",{"$nulls":7}," ",{"$f":"'S-3'!G32","v":0}]
[null,4,"Each Gift Donated to Veterans (Personal Care Items)",{"$nulls":7}," ",{"$f":"'S-4'!H32","v":0}]
[null,5,"Each Dollar Donated to VAVS Projects, etc.",{"$nulls":7}," ",{"$f":"'S-5'!H35","v":0}]
[null,6,"Each Publication Donated to VA ",{"$nulls":7}," ",{"$f":"'S-6'!I49","v":0}]
[null,7,"Each Veteran Outing",{"$nulls":7}," ",{"$f":"'S-7'!I33","v":0}]
[null,8,"Special Observances",{"$nulls":8}," "]
[null," ","8 - A ","Special Observances - Sponsored/Joint by Chapter",{"$nulls":6},{"$f":"'S-8'!H34","v":0}]
[null," ","8 - B ","Attendance at Special Observances - Sponsored/Joint by Chapter",{"$nulls":6},{"$f":"'S-8'!I34","v":0}]
[{"$nulls":3},"Total (Section 8)",{"$nulls":7},{"$f":"SUM(K13:K14)","v":0}]
[null,9,"Participation in Wounded Warriors Program",{"$nulls":7}," "," "]
[null,null,"9 - A","Informal Presentation of Certificate/Coin",{"$nulls":6},{"$f":"'S-9'!G38","v":0}]
[null,null,"9 - B","Formal Presentation of Certificate/Coin",{"$nulls":6},{"$f":"'S-9'!H38","v":0}]
[{"$nulls":3},"Total (Section 9)",{"$nulls":7},{"$f":"SUM(K17:K18)","v":0}]
[null,10,"Participation in Operation Ancestor Search Program",{"$nulls":8}," "]
[null,null,"10 - A","Presentation of Program to a Group of Service Personnel",{"$nulls":6},{"$f":"'S-10'!G30","v":0}]
[null,null,"10 - B","Assisting Each Veteran With Computer Genealogy",{"$nulls":6},{"$f":"'S-10'!G54","v":0}]
[{"$nulls":3},"Total (Section 10)",{"$nulls":7},{"$f":"SUM(K21:K22)","v":0}]
[null,11,"Special Observances - Non-Chapt Sponsored",{"$nulls":7}," ",{"$f":"'S-11'!H34","v":0}]
[null,12,"Marking Revolutionary Patriot/Compatriot Graves",{"$nulls":8}," "]
[null,null,"12 - A ","Initial Revolutionary Grave Marking - Chapter",{"$nulls":6},{"$f":"'S-12AB'!H34","v":0}]
[null,null,"12 - B ","Attendance at Revolutionary Grave Marking",{"$nulls":6},{"$f":"'S-12AB'!H58","v":0}]
[null,null,"12 - C ","Flag Placement on a Veterans Grave",{"$nulls":6},{"$f":"'S-12C'!N37","v":0}]
[null,null,"12 - D ","Patriot Grave Registry donation to NSSAR",{"$nulls":6},{"$f":"'S-12D'!G34","v":0}]
[null,null,"12 - E ","Participation in a Veterans Funeral",{"$nulls":6},{"$f":"'S-12E'!K32","v":0}]
[{"$nulls":3},"Total (Section 12)",{"$nulls":7},{"$f":"SUM(K26:K30)","v":0}]
[null,13,"New or Used Clothing Donations",{"$nulls":7}," ",{"$f":"'S-13'!H35","v":0}]
[null,14,"Big Ticket Item Donations",{"$nulls":7}," ",{"$f":"'S-14'!H32","v":0}]
[]
[null,null,"TOTAL STARK AWARD POINTS EARNED",{"$nulls":7}," ",{"$f":"SUM(L5:L33)","v":0}]
[null," "]
[null," "]

{"sheet":"S-1","index":1,"n_rows":34,"n_cols":7,"rows_kept":34}
[]
[null,"1.  Chapter Member Appointed to a VA Hospital Council, or equivalent organization"]
[null,null,"(25 pts per member)"]
[]
[]
[null,null,"If there is any question regarding whether an appointment can be counted, contact the NSSAR Veterans Committee Chairman."]
[]
[null,null,"Date","Name","VA Hospital Council or Equivalent Organization","Role in Organization","Points"]
[null,1,{"$nulls":4},{"$f":"IF(AND(C9<>\"\",D9<>\"\",E9<>\"\",F9<>\"\",F9<>\" \"),25,0)","v":0}]
[null,2,{"$nulls":4},{"$f":"IF(AND(C10<>\"\",D10<>\"\",E10<>\"\",F10<>\"\",F10<>\" \"),25,0)","v":0}]
[null,3,{"$nulls":4},0]
[null,4,{"$nulls":4},0]
[null,5,{"$nulls":4},0]
[null,6,{"$nulls":4},0]
[null,7,{"$nulls":4},0]
[null,8,{"$nulls":4},0]
[null,9,{"$nulls":4},0]
[null,10,{"$nulls":4},0]
[null,11,{"$nulls":4},0]
[null,12,{"$nulls":4},0]
[null,13,{"$nulls":4},0]
[null,14,{"$nulls":4},0]
[null,15,{"$nulls":4},0]
[null,16,{"$nulls":4},0]
[null,17,{"$nulls":4},0]
[null,18,{"$nulls":4},0]
[null,19,{"$nulls":4},0]
[null,20,{"$nulls":4},0]
[null,21,{"$nulls":4},0]
[null,22,{"$nulls":4},0]
[null,23,{"$nulls":4},0]
[null,24,{"$nulls":4},0]
[null,25,{"$nulls":4},{"$f":"IF(AND(C33<>\"\",D33<>\"\",E33<>\"\",F33<>\"\"),25,0)","v":0}]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G9:G33)","v":0}]

{"sheet":"S-2","index":2,"n_rows":65,"n_cols":7,"rows_kept":65}
[]
[null,"2.  Each HOUR Served in VA Hospital Volunteer Service"]
[null,null,"(10 pts per hour)"]
[]
[null,null,"For hours that are volunteered and are in support of VA-related  activities, but are not included on the VA "]
[null,null,"Volunteer Service Report, list the hours in this area and identify the purpose."]
[]
[]
[null,"VA Volunteer Hours (per VA Voluntary Service Report)"]
[null,null,"Date","Name","Location of Volunteer Service","Hours","Points"]
[null,1,{"$nulls":4},{"$f":"IF(AND(C11<>\"\",D11<>\"\",E11<>\"\",F11<>\"\",F11<>\" \"),F11*10,0)","v":0}]
[null,2,{"$nulls":4},{"$f":"IF(AND(C12<>\"\",D12<>\"\",E12<>\"\",F12<>\"\",F12<>\" \"),F12*10,0)","v":0}]
[null,3,{"$nulls":3}," ",0]
[null,4,{"$nulls":4},0]
[null,5,{"$nulls":4},0]
[null,6,{"$nulls":4},0]
[null,7,{"$nulls":4},0]
[null,8,{"$nulls":4},0]
[null,9,{"$nulls":4},0]
[null,10,{"$nulls":4},0]
[null,11,{"$nulls":4},0]
[null,12,{"$nulls":4},0]
[null,13,{"$nulls":4},0]
[null,14,{"$nulls":4},0]
[null,15,{"$nulls":4},0]
[null,16,{"$nulls":4},0]
[null,17,{"$nulls":4},0]
[null,18,{"$nulls":4},0]
[null,19,{"$nulls":4},0]
[null,20,{"$nulls":4},0]
[{"$nulls":5},"SUB-TOTAL",{"$f":"SUM(G11:G30)","v":0}]
[]
[null,null,"Hours that are volunteered solely in support of an SAR activity (cannot be for any other organization) should be "]
[null,null,"included here.  Explain as clearly as possible.  The event must be in support of veterans or veteran causes."]
[]
[null,"Volunteer Hours (Non-VA Hospital)"]
[null,null,"Date","Name","Activity","Hours","Points"]
[null,1,{"$nulls":4},{"$f":"IF(AND(C38<>\"\",D38<>\"\",E38<>\"\",F38<>\"\",F38<>\" \"),F38*10,0)","v":0}]
[null,2,{"$nulls":4},{"$f":"IF(AND(C39<>\"\",D39<>\"\",E39<>\"\",F39<>\"\",F39<>\" \"),F39*10,0)","v":0}]
[null,3,{"$nulls":4},0]
[null,4,{"$nulls":4},0]
[null,5,{"$nulls":4},0]
[null,6,{"$nulls":4},0]
[null,7,{"$nulls":4},0]
[null,8,{"$nulls":4},0]
[null,9,{"$nulls":4},0]
[null,10,{"$nulls":4},0]
[null,11,{"$nulls":4},0]
[null,12,{"$nulls":4},0]
[null,13,{"$nulls":4},0]
[null,14,{"$nulls":4},0]
[null,15,{"$nulls":4},0]
[null,16,{"$nulls":4},0]
[null,17,{"$nulls":4},0]
[null,18,{"$nulls":4},0]
[null,19,{"$nulls":4},0]
[null,20,{"$nulls":4},0]
[null,21,{"$nulls":4},0]
[null,22,{"$nulls":4},0]
[null,23,{"$nulls":4},0]
[null,24,{"$nulls":4},0]
[null,25,{"$nulls":4},0]
[{"$nulls":5},"SUB-TOTAL",{"$f":"SUM(G38:G62)","v":0}]
[]
[{"$nulls":5},"TOTAL",{"$f":"G31+G63","v":0}]

{"sheet":"S-3","index":3,"n_rows":47,"n_cols":7,"rows_kept":47}
[]
[null,"3.  Each SAR Member Visiting a Veteran (not counted in section II)"]
[null,null,"(5 pts per visit)"]
[]
[null,null,"Each Veteran Visited, maximum of three (3) visits per hour. NOTE: Points are based on the number of visits, not the number of hours visited."]
[null,null,"Veterans who are visited must be in a hospital, nursing home, or home-bound because of a disability or illness.  Simply visiting your"]
[null,null,"brother-in-law, who is a veteran, at home on his birthday does not count, unless he is home-bound due to a disability or illness."]
[null,null,"Mileage to/from CANNOT be counted. See Section 7 (Veteran Outing) for the difference between a Visit and an Outing."]
[null,null,"DO NOT include anything here that is counted in Section 7."]
[]
[null,null,"Date","Compatriot","Name of Veteran","Location","Points"]
[null,1,{"$nulls":4},{"$f":"IF(AND(C12<>\"\",D12<>\"\",E12<>\"\",F12<>\"\",F12<>\" \"),5,0)","v":0}]
[null,2,{"$nulls":4},{"$f":"IF(AND(C13<>\"\",D13<>\"\",E13<>\"\",F13<>\"\",F13<>\" \"),5,0)","v":0}]
[null,3,{"$nulls":4},{"$f":"IF(AND(C14<>\"\",D14<>\"\",E14<>\"\",F14<>\"\",F14<>\" \"),5,0)","v":0}]
[null,4,{"$nulls":4},{"$f":"IF(AND(C15<>\"\",D15<>\"\",E15<>\"\",F15<>\"\",F15<>\" \"),5,0)","v":0}]
[null,5,{"$nulls":4},0]
[null,6,{"$nulls":4},0]
[null,7,{"$nulls":4},0]
[null,8,{"$nulls":4},0]
[null,9,{"$nulls":4},0]
[null,10,{"$nulls":4},0]
[null,11,{"$nulls":4},0]
[null,12,{"$nulls":4},0]
[null,13,{"$nulls":4},0]
[null,14,{"$nulls":4},0]
[null,15,{"$nulls":4},0]
[null,16,{"$nulls":4},0]
[null,17,{"$nulls":4},0]
[null,18,{"$nulls":4},0]
[null,19,{"$nulls":4},0]
[null,20,{"$nulls":4},0]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G12:G31)","v":0}]
{"$rows_empty":14}
[null,"."]

{"sheet":"S-4","index":4,"n_rows":32,"n_cols":8,"rows_kept":32}
[]
[null,"4.  Each Gift Donated to Veterans (Personal Care Items)"]
[null,null,"(1 point per gift)"]
[]
[null,null,"NOTES: Personal care items can be shampoo, shaving cream, deodorant, combs, puzzles, ball point pens, pencils, notepads, etc."]
[null,null,"DO NOT include mouthwash that is alcoholic (for obvious reasons) and soap (because some veterans may be allergic to the perfume)."]
[]
[null,null,"**$ Value is not required for Stark Report purposes, but when you make donations to the VA, the VA usually wants you to list"]
[null,null," a Total Value of all items donated.  Showing a value for such donated items here helps in computing the value for VA purposes.  "]
[null,null,"By showing an overall blanket average for the value here, you avoid trying to determine a value for each of several different"]
[null,null," items donated."]
[]
[null,null,"**** IMPORTANT ****"]
[null,null,"STARK AWARD points are NOT based on $ Value, but 1 point per item. "]
[]
[null,null,"Date","Compatriot","No. of Items","Location","$ Value","Points"]
[null,1,{"$nulls":5},{"$f":"IF(AND(C17<>\"\",D17<>\"\",E17<>\"\",E17<>\" \",F17<>\"\",G17<>\"\",G17<>\" \"),E17*1,0)","v":0}]
[null,2,{"$nulls":5},{"$f":"IF(AND(C18<>\"\",D18<>\"\",E18<>\"\",E18<>\" \",F18<>\"\",G18<>\"\",G18<>\" \"),E18*1,0)","v":0}]
[null,3,{"$nulls":5},0]
[null,4,{"$nulls":5},0]
[null,5,{"$nulls":5},0]
[null,6,{"$nulls":5},0]
[null,7,{"$nulls":5},0]
[null,8,{"$nulls":5},0]
[null,9,{"$nulls":5},0]
[null,10,{"$nulls":5},0]
[null,11,{"$nulls":5},0]
[null,12,{"$nulls":5},0]
[null,13,{"$nulls":5},0]
[null,14,{"$nulls":5},0]
[null,15,{"$nulls":5},0]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G17:G31)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H17:H31)","v":0}]

{"sheet":"S-5","index":5,"n_rows":35,"n_cols":8,"rows_kept":35}
[]
[null,"5.  Each Dollar Donated to VAVS Projects & Coupon books, etc."]
[null,null,"(1 point per $ - maximum of $1,500)"]
[]
[null,null,"Monetary donations can be made only to the VA.  Monetary donations to service  "]
[null,null,"organizations such as DAV PVA, VFW, AmVets, and the Wounded Warrior Project, etc. "]
[null,null,"DO NOT count."]
[]
[null,null,"Date","Compatriot","Cash Donated ($)","Description","VA Facility","Points"]
[null,1,{"$nulls":5},{"$f":"IF(AND(C10<>\"\",D10<>\"\",E10<>\"\",E10<>\" \",F10<>\"\",G10<>\"\"),E10*1,0)","v":0}]
[null,2,{"$nulls":5},{"$f":"IF(AND(C11<>\"\",D11<>\"\",E11<>\"\",E11<>\" \",F11<>\"\",G11<>\"\"),E11*1,0)","v":0}]
[null,3,{"$nulls":5},0]
[null,4,{"$nulls":5},0]
[null,5,{"$nulls":5},0]
[null,6,{"$nulls":5},0]
[null,7,{"$nulls":5},0]
[null,8,{"$nulls":5},0]
[null,9,{"$nulls":5},0]
[null,10,{"$nulls":5},0]
[null,11,{"$nulls":5},0]
[null,12,{"$nulls":5},0]
[null,13,{"$nulls":5},0]
[null,14,{"$nulls":5},0]
[null,15,{"$nulls":5},0]
[null,16,{"$nulls":5},0]
[null,17,{"$nulls":5},0]
[null,18,{"$nulls":5},0]
[null,19,{"$nulls":5},0]
[null,20,{"$nulls":5},0]
[null,21,{"$nulls":5},0]
[null,22,{"$nulls":5},0]
[null,23,{"$nulls":5},0]
[null,24,{"$nulls":5},0]
[null,25,{"$nulls":5},0]
[{"$nulls":6},"TOTAL",{"$f":"IF(SUM(H10:H34)<=1500, SUM(H10:H34),1500)","v":0}]

{"sheet":"S-6","index":6,"n_rows":49,"n_cols":9,"rows_kept":49}
[]
[null,"6.  Each Publication Donated to VA"]
[null,null,"(1 points per publication)"]
[]
[null,null,"Some VAs require magazines MUST be within a certain period of time of issue to be accepted by the VA, even though some"]
[null,null,"are not time-sensitive in nature (National Geographic, etc.). Check with local VA for their policy."]
[]
[null,null,"Donations made to organizations whose primary purpose is to serve veterans can count for points."]
[]
[null,null,"The value is not required for Stark Report purposes, but when you make donations to the VA, the VA usually wants you to list a total value "]
[null,null,"of all items donated. Showing a value here for such donated items helps in computing the value for VA purposes.  The values shown"]
[null,null,"here are subjective, even though some books/magazines may cost less, and some might cost more. By showing overall blanket "]
[null,null,"averages for the value you avoid the need to calculate a value for each book and magazine donated."]
[]
[null,null,"The average values used here are:"]
[{"$nulls":3},"(H)ard Cover Books = $5 ","(Mo)vies (VHS, DVD) = $5"]
[{"$nulls":3},"(P)aperback Books = $2","(A)udio Books = $5"]
[{"$nulls":3},"(M)agazines = $1","Music (CD)s = $5"]
[]
[null,null,"**** IMPORTANT ****"]
[null,null,"STARK AWARD points are NOT based on $ Value, but 1 point per publication"]
[]
[null,null,"Date","Compatriot","No. of Items","Publication Type","VA Facility","Points","$ Value"]
[null,1,{"$nulls":5},{"$f":"IF(AND(C24<>\"\",D24<>\"\",E24<>\"\",E24<>\" \",G24<>\"\"),E24*1,0)","v":0},{"$f":"IF(AND(C24<>\"\",D24<>\"\",E24<>\"\",E24<>\" \",G24<>\"\",F24=\"P\"),E24*2,IF(AND(C24<>\"\",D24<>\"\",E24<>\"\",E24<>\" \",G24<>\"\",F24=\"M\"),E24*1,IF(AND(C24<>\"\",D24<>\"\",E24<>\"\",E24<>\" \",F24<>\"\",G24<>\"\",F24=\"H\"),E24*5,IF(AND(C24<>\"\",D24<>\"\",E24<>\"\",E24<>\" \",F24<>\"\",G24<>\"\",F24=\"Mo\"),E24*5,IF(AND(C24<>\"\",D24<>\"\",E24<>\"\",E24<>\" \",F24<>\"\",G24<>\"\",F24=\"A\"),E24*5,IF(AND(C24<>\"\",D24<>\"\",E24<>\"\",E24<>\" \",F24<>\"\",G24<>\"\",F24=\"CD\"),E24*5,0))))))","v":0}]
[null,2,{"$nulls":5},{"$f":"IF(AND(C25<>\"\",D25<>\"\",E25<>\"\",E25<>\" \",G25<>\"\"),E25*1,0)","v":0},{"$f":"IF(AND(C25<>\"\",D25<>\"\",E25<>\"\",E25<>\" \",G25<>\"\",F25=\"P\"),E25*2,IF(AND(C25<>\"\",D25<>\"\",E25<>\"\",E25<>\" \",G25<>\"\",F25=\"M\"),E25*1,IF(AND(C25<>\"\",D25<>\"\",E25<>\"\",E25<>\" \",F25<>\"\",G25<>\"\",F25=\"H\"),E25*5,IF(AND(C25<>\"\",D25<>\"\",E25<>\"\",E25<>\" \",F25<>\"\",G25<>\"\",F25=\"Mo\"),E25*5,IF(AND(C25<>\"\",D25<>\"\",E25<>\"\",E25<>\" \",F25<>\"\",G25<>\"\",F25=\"A\"),E25*5,IF(AND(C25<>\"\",D25<>\"\",E25<>\"\",E25<>\" \",F25<>\"\",G25<>\"\",F25=\"CD\"),E25*5,0))))))","v":0}]
[null,3,{"$nulls":5},0,{"$f":"IF(AND(C26<>\"\",D26<>\"\",E26<>\"\",E26<>\" \",G26<>\"\",F26=\"P\"),E26*2,IF(AND(C26<>\"\",D26<>\"\",E26<>\"\",E26<>\" \",G26<>\"\",F26=\"M\"),E26*1,IF(AND(C26<>\"\",D26<>\"\",E26<>\"\",E26<>\" \",F26<>\"\",G26<>\"\",F26=\"H\"),E26*5,IF(AND(C26<>\"\",D26<>\"\",E26<>\"\",E26<>\" \",F26<>\"\",G26<>\"\",F26=\"Mo\"),E26*5,IF(AND(C26<>\"\",D26<>\"\",E26<>\"\",E26<>\" \",F26<>\"\",G26<>\"\",F26=\"A\"),E26*5,IF(AND(C26<>\"\",D26<>\"\",E26<>\"\",E26<>\" \",F26<>\"\",G26<>\"\",F26=\"CD\"),E26*5,0))))))","v":0}]
[null,4,{"$nulls":5},0,0]
[null,5,{"$nulls":5},0,0]
[null,6,{"$nulls":5},0,0]
[null,7,{"$nulls":5},0,0]
[null,8,{"$nulls":5},0,0]
[null,9,{"$nulls":5},0,0]
[null,10,{"$nulls":5},0,0]
[null,11,{"$nulls":5},{"$f":"IF(AND(C34<>\"\",D34<>\"\",E34<>\"\",E34<>\" \",G34<>\"\"),E34*1,0)","v":0},0]
[null,12,{"$nulls":5},0,0]
[null,13,{"$nulls":5},0,0]
[null,14,{"$nulls":5},0,0]
[null,15,{"$nulls":5},0,0]
[null,16,{"$nulls":5},0,0]
[null,17,{"$nulls":5},0,0]
[null,18,{"$nulls":5},0,0]
[null,19,{"$nulls":5},0,0]
[null,20,{"$nulls":5},0,0]
[null,21,{"$nulls":5},0,0]
[null,22,{"$nulls":5},0,0]
[null,23,{"$nulls":5},0,0]
[null,24,{"$nulls":5},0,0]
[null,25,{"$nulls":5},0,0]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H24:H48)","v":0},{"$f":"SUM(I24:I48)","v":0}]

{"sheet":"S-7","index":7,"n_rows":33,"n_cols":9,"rows_kept":33}
[]
[null,"7.  Each Veteran Outing"]
[null,null,"1 - 10 veterans = 10 pts",null,"11 - 25 veterans = 15 pts"]
[null,null,"26 - 50 veterans = 20 pts",null,"51+ veterans = 25 pts"]
[null,null,"Mileage points per mile = 1"]
[]
[null,null,"DO NOT include anything here that was counted in Section 3."]
[null,null,"A Veteran Outing differs from a Visit to a Veteran (Section 3).  An Outing extends  beyond a visit in that an outing involves"]
[null,null,"direct activity with a veteran, or a group of veterans.  Simply attending a function where veterans are present does not"]
[null,null,"count unless there is direct involvment of an activity with them."]
[]
[null,null,"Ex: Compatriot Tom Jones took Charlie and Frank (both veterans) out to lunch and a car ride (23 miles). "]
[{"$nulls":3}," Points = 10 (1-10 veterans) + mileage; or 10 + 23 = 33 points can be counted as an Outing"]
[null,null,"Ex: Compatriot Bob Smith assisted in umpiring the VAMC Wheelchair Games with 51 veterans participating."]
[{"$nulls":3},"Points =25 (51+ veterans) + mileage; 25 + 30 = 55 points can be counted as an Outing."]
[]
[null,null,"Date","Compatriot","No. of Veterans","Description of Outing","Location","Mileage","Points"]
[null,1,{"$nulls":6},{"$f":"IF(AND(C18<>\"\",D18<>\"\",E18<>\"\",E18<>\" \",F18<>\"\",G18<>\"\",H18<>\"\",AND(E18>0,E18<=10)),H18+10,IF(AND(C18<>\"\",D18<>\"\",E18<>\"\",E18<>\" \",F18<>\"\",G18<>\"\",H18<>\"\",AND(E18>10,E18<=25)),H18+15,IF(AND(C18<>\"\",D18<>\"\",E18<>\"\",E18<>\" \",F18<>\"\",G18<>\"\",H18<>\"\",AND(E18>25,E18<=50)),H18+20,IF(AND(C18<>\"\",D18<>\"\",E18<>\"\",E18<>\" \",F18<>\"\",G18<>\"\",H18<>\"\",E18>50),H18+25,0))))","v":0}]
[null,2,{"$nulls":6},{"$f":"IF(AND(C19<>\"\",D19<>\"\",E19<>\"\",E19<>\" \",F19<>\"\",G19<>\"\",H19<>\"\",AND(E19>0,E19<=10)),H19+10,IF(AND(C19<>\"\",D19<>\"\",E19<>\"\",E19<>\" \",F19<>\"\",G19<>\"\",H19<>\"\",AND(E19>10,E19<=25)),H19+15,IF(AND(C19<>\"\",D19<>\"\",E19<>\"\",E19<>\" \",F19<>\"\",G19<>\"\",H19<>\"\",AND(E19>25,E19<=50)),H19+20,IF(AND(C19<>\"\",D19<>\"\",E19<>\"\",E19<>\" \",F19<>\"\",G19<>\"\",H19<>\"\",E19>50),H19+25,0))))","v":0}]
[null,3,{"$nulls":6},0]
[null,4,{"$nulls":6},0]
[null,5,{"$nulls":6},0]
[null,6,{"$nulls":6},0]
[null,7,{"$nulls":6},0]
[null,8,{"$nulls":6},0]
[null,9,{"$nulls":6},0]
[null,10,{"$nulls":6},0]
[null,11,{"$nulls":6},0]
[null,12,{"$nulls":6},0]
[null,13,{"$nulls":6},0]
[null,14,{"$nulls":6},0]
[null,15,{"$nulls":6},0]
[{"$nulls":7},"TOTAL",{"$f":"SUM(I18:I32)","v":0}]

{"sheet":"S-8","index":8,"n_rows":34,"n_cols":9,"rows_kept":34}
[]
[null,"8 .  Special Observances"]
[]
[null,"8 - A.  Special Observances - Sponsored/Joint Sponsored by Chapter"]
[null,null,"(Chapter - 50 pts per event)"]
[null,null,"(Only Chapters can count points under 8-A)"]
[]
[null,null,"Only chapters can earn points in this Section.   These events must be sponsored by the Chapter, or jointly sponsored with other chapters or"]
[null,null,"patriotic/historic organizations, with veterans organizations attending.  The event must be open for attendance by other organizations or the public"]
[null,null,"Don't be confused by the NSSAR Stark Report Form that  lists several Patriotic events.  A chapter that attends one of the listed events must be one of the sponsors"]
[null,null,"of that event for it to count in this Section. Simply attending a listed event that's on the NSSAR Form does not earn points here, but in Section 11.  "]
[]
[null,"8 - B.  Attendance of Special Observances - Sponsored/Joint Sponsored by Chapter"]
[null,"               (Individual Member Points - 5 pts per)"]
[]
[null,null,"This is for attendance at those events shown in 8-A."]
[{"$nulls":7},"8-A.","8-B."]
[null,null,"Date","Compatriot Name(s)","No. of Compatriots","Event","Location","Points","Points"]
[null,1,{"$nulls":5},{"$f":"IF(AND(C19<>\"\",D19<>\"\",F19<>\"\",G19<>\"\"),50,0)","v":0},{"$f":"IF(AND(D19<>\"\",E19<>\"\",E19<>\" \",F19<>\"\",G19<>\"\",H19<>\"\"),E19*5,0)","v":0}]
[null,2,null,null," ",null,null,{"$f":"IF(AND(C20<>\"\",D20<>\"\",F20<>\"\",G20<>\"\"),50,0)","v":0},{"$f":"IF(AND(D20<>\"\",E20<>\"\",E20<>\" \",F20<>\"\",G20<>\"\",H20<>\"\"),E20*5,0)","v":0}]
[null,3,{"$nulls":5},0,0]
[null,4,{"$nulls":5},0,0]
[null,5,{"$nulls":5},0,0]
[null,6,{"$nulls":5},0,0]
[null,7,{"$nulls":5},{"$f":"IF(AND(C25<>\"\",D25<>\"\",F25<>\"\",G25<>\"\"),50,0)","v":0},0]
[null,8,{"$nulls":5},0,0]
[null,9,{"$nulls":5},0,0]
[null,10,{"$nulls":5},{"$f":"IF(AND(C28<>\"\",D28<>\"\",F28<>\"\",G28<>\"\"),50,0)","v":0},0]
[null,11,{"$nulls":5},0,0]
[null,12,{"$nulls":5},0,0]
[null,13,{"$nulls":5},0,0]
[null,14,{"$nulls":5},0,0]
[null,15,{"$nulls":5},0,0]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H19:H33)","v":0},{"$f":"SUM(I19:I33)","v":0}]

{"sheet":"S-9","index":9,"n_rows":38,"n_cols":8,"rows_kept":38}
[]
[null,"9 .  Participation In Wounded Warrior Programs"]
[]
[null,"9 - A.  Participation in the Wounded Warrior Program "]
[null,"              ","(INFORMAL presentation of SAR Wounded Warrior certificate & SAR Challenge coin - 25 pts each)"]
[]
[null,null,"This activity does not count towards \"Visits\" scored under Section #3, nor \"Outings\" scored under Section #7."]
[]
[null,"9 - B.  Participation in the Wounded Warrior Program "]
[null,"              ","(FORMAL presentation of SAR Wounded Warrior certificate & SAR Challenge coin - 50 pts each)"]
[]
[null,null,"Note that points can be earned ONLY by a Formal presentation of the SAR Wounded Warrior certificate and Challenge Coin."]
[]
[null,null,"Example: If there are presentations to six Wounded Warriors, points are earned: 6 X 50 = 300 points"]
[]
[{"$nulls":6},"9-A.","9-B."]
[null,null,"Date","Recipient's Name","Location","Formal Presentation (Y/N)","Points","Points"]
[null,1,{"$nulls":4},{"$f":"IF(AND(C18<>\"\",D18<>\"\",E18<>\"\",F18=\"N\"),25,0)","v":0},{"$f":"IF(AND(C18<>\"\",D18<>\"\",E18<>\"\",F18=\"Y\"),50,0)","v":0}]
[null,2,{"$nulls":4},{"$f":"IF(AND(C19<>\"\",D19<>\"\",E19<>\"\",F19=\"N\"),25,0)","v":0},{"$f":"IF(AND(C19<>\"\",D19<>\"\",E19<>\"\",F19=\"Y\"),50,0)","v":0}]
[null,3,{"$nulls":4},0,0]
[null,4,{"$nulls":4},0,0]
[null,5,{"$nulls":4},0,0]
[null,6,{"$nulls":4},0,0]
[null,7,{"$nulls":4},{"$f":"IF(AND(C24<>\"\",D24<>\"\",E24<>\"\",F24=\"N\"),25,0)","v":0},{"$f":"IF(AND(C24<>\"\",D24<>\"\",E24<>\"\",F24=\"Y\"),50,0)","v":0}]
[null,8,{"$nulls":4},0,0]
[null,9,{"$nulls":4},0,0]
[null,10,{"$nulls":4},0,0]
[null,11,{"$nulls":4},{"$f":"IF(AND(C28<>\"\",D28<>\"\",E28<>\"\",F28=\"N\"),25,0)","v":0},{"$f":"IF(AND(C28<>\"\",D28<>\"\",E28<>\"\",F28=\"Y\"),50,0)","v":0}]
[null,12,{"$nulls":4},0,0]
[null,13,{"$nulls":4},0,0]
[null,14,{"$nulls":4},0,0]
[null,15,{"$nulls":4},0,0]
[null,16,{"$nulls":4},0,0]
[null,17,{"$nulls":4},0,0]
[null,18,{"$nulls":4},0,0]
[null,19,{"$nulls":4},0,0]
[null,20,{"$nulls":4},0,0]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G18:G37)","v":0},{"$f":"SUM(H18:H37)","v":0}]

{"sheet":"S-10","index":10,"n_rows":54,"n_cols":7,"rows_kept":54}
[]
[null,"10 .  Participation In The Operation Ancestor Search Program"]
[]
[null,"10 - A. Presentation of Program to a group of Service personnel  - (20 pts each)"]
[]
[null,null,"This activity does not count towards \"Visits\" scored under Section #3, nor \"Outings\" scored under Section #7."]
[null,null,"Points counted in this Section MUST be in connection with the \"Operation Ancestor Search Program.\""]
[{"$nulls":6},"10-A."]
[null,null,"Date","Group Name","No. of Participants","Location","Points"]
[null,1,{"$nulls":4},{"$f":"IF(AND(C10<>\"\",D10<>\"\",E10<>\"\",F10<>\"\"),20,0)","v":0}]
[null,2,{"$nulls":4},{"$f":"IF(AND(C11<>\"\",D11<>\"\",E11<>\"\",F11<>\"\"),20,0)","v":0}]
[null,3,null,null," ",null,0]
[null,4,{"$nulls":4},0]
[null,5,{"$nulls":4},0]
[null,6,{"$nulls":4},0]
[null,7,{"$nulls":4},0]
[null,8,{"$nulls":4},0]
[null,9,{"$nulls":4},0]
[null,10,{"$nulls":4},0]
[null,11,{"$nulls":4},0]
[null,12,{"$nulls":4},0]
[null,13,{"$nulls":4},0]
[null,14,{"$nulls":4},0]
[null,15,{"$nulls":4},0]
[null,16,{"$nulls":4},0]
[null,17,{"$nulls":4},0]
[null,18,{"$nulls":4},0]
[null,19,{"$nulls":4},0]
[null,20,{"$nulls":4},0]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G10:G29)","v":0}]
[]
[null,"10 - B.  Assisting each Veteran with computer genealogy - (10 pts/hour)"]
[null,"              "]
[null,null,"Time spent with a veteran in genealogical research for SAR membership MUST be in conjunction with the \"Operation"]
[null,null,"Ancestor Search\" program. \"Operation Ancestor Search\" was created by NSSAR to provide genealogical training and"]
[null,null,"assistance to our nation's injured military service members by utilizing SAR knowledge and experience to assist"]
[null,null,"wounded service members to learn about their family history and teach them basic genealogy skills."]
[]
[null,null,"Assisting any veteran, with  genealogical research does not count for points in this section UNLESS it is in conjunction"]
[null,null,"with Operation Ancestor Search.  See \"Operation Ancestor Search\" program on the NSSAR website."]
[]
[{"$nulls":6},"10-B."]
[null,null,"Date","Veteran's Name","No. of Hours","Location","Points"]
[null,1,{"$nulls":4},{"$f":"IF(AND(C44<>\"\",D44<>\"\",E44<>\"\",E44<>\" \",F44<>\"\"),E44*10,0)","v":0}]
[null,2,{"$nulls":4},{"$f":"IF(AND(C45<>\"\",D45<>\"\",E45<>\"\",E45<>\" \",F45<>\"\"),E45*10,0)","v":0}]
[null,3,{"$nulls":3}," ",0]
[null,4,{"$nulls":4},0]
[null,5,{"$nulls":4},0]
[null,6,{"$nulls":4},0]
[null,7,{"$nulls":4},0]
[null,8,{"$nulls":4},0]
[null,9,{"$nulls":4},0]
[null,10,{"$nulls":4},0]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G44:G53)","v":0}]

{"sheet":"S-11","index":11,"n_rows":34,"n_cols":8,"rows_kept":34}
[]
[null,"11.  Special Historic/Patriotic Observances - Non-Chapter Sponsored "]
[null,"               (5 pts per member)"]
[]
[null,null,"Include attendance at Special Observances that are not listed under Item # 8A. Chapter meetings and business meetings do not count.  The events must be"]
[null,null,"historic or patriotic in nature."]
[]
[null,null,"Date","Compatriot Name(s)","No. of Compatriots","Event","Location","Points"]
[null,1,{"$nulls":5},{"$f":"IF(AND(C9<>\"\",D9<>\"\",E9<>\"\",E9<>\" \",F9<>\"\",G9<>\"\"),E9*5,0)","v":0}]
[null,2,{"$nulls":5},{"$f":"IF(AND(C10<>\"\",D10<>\"\",E10<>\"\",E10<>\" \",F10<>\"\",G10<>\"\"),E10*5,0)","v":0}]
[null,3,{"$nulls":5},0]
[null,4,{"$nulls":5},0]
[null,5,{"$nulls":5},0]
[null,6,{"$nulls":5},0]
[null,7,{"$nulls":5},0]
[null,8,{"$nulls":5},0]
[null,9,{"$nulls":5},0]
[null,10,{"$nulls":5},0]
[null,11,{"$nulls":5},0]
[null,12,{"$nulls":5},0]
[null,13,{"$nulls":5},0]
[null,14,{"$nulls":5},0]
[null,15,{"$nulls":5},0]
[null,16,{"$nulls":5},0]
[null,17,{"$nulls":5},0]
[null,18,{"$nulls":5},0]
[null,19,{"$nulls":5},0]
[null,20,{"$nulls":5},0]
[null,21,{"$nulls":5},0]
[null,22,{"$nulls":5},0]
[null,23,{"$nulls":5},0]
[null,24,{"$nulls":5},0]
[null,25,{"$nulls":5},0]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H9:H33)","v":0}]

{"sheet":"S-12AB","index":12,"n_rows":58,"n_cols":9,"rows_kept":58}
[]
[null,"12. Marking Revolutionary Patriot War Veterans's Graves"]
[]
[null,"12 - A.  Initial Revolutionary Grave Dedication - Chapter"]
[null,null,"(Only Chapters can count points under 12-A : 50 pts per marking) "]
[null,null,"(Maximum = 200 points)"]
[]
[null,null,"Only Chapters can count points in this Section.  Individual activities are not counted here.  An exception is listed in Ex. 2"]
[null,null,"(marking service consisting minimally of a SAR emblem/stone marker being placed, appropriate ceremony"]
[null,null,"(as listed in National Handbook) with Master of Ceremonies, Chaplain, a Compatriot in uniform, descendent(s)"]
[null,null,"invited and other Compatriots)."]
[null,null,"Ex. #1 Compatriot John's local chapter sponsored the marking of two (2) Revolutionary Patriot Veterans Graves."]
[null,null,"Each grave marking worth 50 points x 2 events = 100 points for that event."]
[null,null,"Ex. #2 Compatriot Robert obtains an NSSAR Grave Marker and places it on his own Patriot ancestor's grave and the Primary"]
[null,null,"primary chapter is not involved."]
[null,null,"Each Grave marking is worth 50 points x 1 marking = 50 points for that event."]
[]
[null,null,"Date","Compatriot Name(s)","Service Provided","Patriot's Name","Location","Points"]
[null,1,{"$nulls":5},{"$f":"IF(AND(C19<>\"\",D19<>\"\",E19<>\"\",F19<>\"\",G19<>\"\"),50,0)","v":0}]
[null,2,{"$nulls":5},{"$f":"IF(AND(C20<>\"\",D20<>\"\",E20<>\"\",F20<>\"\",G20<>\"\"),50,0)","v":0}]
[null,3,{"$nulls":5},0]
[null,4,{"$nulls":5},0]
[null,5,{"$nulls":5},0]
[null,6,{"$nulls":5},0]
[null,7,{"$nulls":5},0]
[null,8,{"$nulls":5},0]
[null,9,{"$nulls":5},0]
[null,10,{"$nulls":5},0]
[null,11,{"$nulls":5},0]
[null,12,{"$nulls":5},0]
[null,13,{"$nulls":5},0]
[null,14,{"$nulls":5},0]
[null,15,{"$nulls":5},0]
[{"$nulls":6},"TOTAL",{"$f":"IF(SUM(H19:H33)<=200, SUM(H19:H33),200)","v":0},{"$f":"IF(H34=200,\"Maximum Reached\",\"\")","v":""}]
[]
[null,"12 - B.  Attendance at Revolutionary Patriot Grave Marking "]
[null,"               (5 pts per member in attendance.  Mileage does not count.)"]
[]
[null,null,"e.g. Compatriot John was able to attend each of the two Grave Dedications sponsored by a SAR/DAR/CAR Chapter."]
[null,null,"Each worth 5 points x 2 markings = 10 points per year."]
[]
[null,null,"Date","Compatriot Name(s)","No. of Compatriots","Patriot's Name","Location","Points"]
[null,1,{"$nulls":5},{"$f":"IF(AND(C43<>\"\",D43<>\"\",E43<>\"\",E43<>\" \",F43<>\"\",G43<>\"\"),E43*5,0)","v":0}]
[null,2,{"$nulls":5},{"$f":"IF(AND(C44<>\"\",D44<>\"\",E44<>\"\",E44<>\" \",F44<>\"\",G44<>\"\"),E44*5,0)","v":0}]
[null,3,{"$nulls":5},0]
[null,4,{"$nulls":5},0]
[null,5,{"$nulls":5},0]
[null,6,{"$nulls":5},0]
[null,7,{"$nulls":5},0]
[null,8,{"$nulls":5},0]
[null,9,{"$nulls":5},0]
[null,10,{"$nulls":5},0]
[null,11,{"$nulls":5},0]
[null,12,{"$nulls":5},0]
[null,13,{"$nulls":5},0]
[null,14,{"$nulls":5},0]
[null,15,{"$nulls":5},0]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H43:H57)","v":0}]

{"sheet":"S-12C","index":13,"n_rows":37,"n_cols":14,"rows_kept":37}
[]
[null,"12. Marking Revolutionary Patriot War Veteran's and Compatriot Graves"]
[]
[null,"12 - C.  Flag/Wreath Placement on a Veterans Grave"]
[null,null,"(1 point per grave - maximum 200 points annually)"]
[]
[null,null,"In support of the Wreaths Across America program, chapters can count 1 point (up to 25) for each wreath purchased, and"]
[null,null,"1 point for each Wreaths Across America wreath placed by chapter members (up to 25 - total, not per individual)."]
[]
[null,null,"The above provisions for the support of the Wreaths Across America program (which can be a maximum of 50 additional "]
[null,null,"points) are included in the 200 total point maximum that can be earned by placing flags on veterans graves."]
[]
[null,null,"These maximums apply to the chapter count, and not individuals.  Thus, you can't have 10 individuals earning 200 each."]
[]
[{"$nulls":6},"Wreaths","Wreaths",null,null,"Wreaths","Wreaths"]
[null,null,"Date","Compatriot","Name(s) of Veteran","Flags Placed","Placed","Purchased","Location","Max. Flags","Placed","Purchased","Max. Wreaths","Points"]
[null,1,{"$nulls":7},{"$f":"IF(AND(F17<>\"\",F17<>\" \",F17<\"a\"),IF(F17>200, 200,F17),0)","v":0},{"$f":"IF(AND(G17<>\"\",G17<>\" \"),G17,0)","v":0},{"$f":"IF(AND(H17<>\"\",H17<>\" \"),H17,0)","v":0},{"$f":"IF(K17+L17>50,50,K17+L17)","v":0},{"$f":"IF(AND(C17<>\"\",D17<>\"\",E17<>\"\",F17<>\"\",G17<>\"\",H17<>\"\",I17<>\"\",J17+M17<=200),J17+M17,IF(AND(C17<>\"\",D17<>\"\",E17<>\"\",F17<>\"\",G17<>\"\",H17<>\"\",J17+M17>200),200,0))","v":0}]
[null,2,{"$nulls":7},{"$f":"IF(AND(F18<>\"\",F18<>\" \",F18<\"a\"),IF(F18>200, 200,F18),0)","v":0},{"$f":"IF(AND(G18<>\"\",G18<>\" \"),G18,0)","v":0},{"$f":"IF(AND(H18<>\"\",H18<>\" \"),H18,0)","v":0},{"$f":"IF(K18+L18>50,50,K18+L18)","v":0},0]
[null,3,{"$nulls":7},{"$f":"IF(AND(F19<>\"\",F19<>\" \",F19<\"a\"),IF(F19>200, 200,F19),0)","v":0},0,0,0,0]
[null,4,{"$nulls":7},0,0,0,0,0]
[null,5,{"$nulls":7},0,0,0,0,0]
[null,6,{"$nulls":7},0,0,0,0,0]
[null,7,{"$nulls":7},0,0,0,0,0]
[null,8,{"$nulls":7},0,0,0,0,0]
[null,9,{"$nulls":11},0]
[null,10,{"$nulls":11},0]
[null,11,{"$nulls":11},0]
[null,12,{"$nulls":11},0]
[null,13,{"$nulls":11},0]
[null,14,{"$nulls":7},0,0,0,0,0]
[null,15,{"$nulls":7},0,0,0,0,0]
[null,16,{"$nulls":7},0,0,0,0,0]
[null,17,{"$nulls":7},0,0,0,0,0]
[null,18,{"$nulls":7},0,0,0,0,{"$f":"IF(AND(C34<>\"\",D34<>\"\",E34<>\"\",F34<>\"\",G34<>\"\",H34<>\"\",I34<>\"\",J34+M34<=200),J34+M34,IF(AND(C34<>\"\",D34<>\"\",E34<>\"\",F34<>\"\",G34<>\"\",H34<>\"\",J34+M34>200),200,0))","v":0}]
[null,19,{"$nulls":7},0,0,0,0,0]
[null,20,{"$nulls":7},0,0,0,0,0]
[{"$nulls":8},"TOTAL",{"$nulls":4},{"$f":"IF(SUM(N17:N36)<=200, SUM(N17:N36),200)","v":0}]

{"sheet":"S-12D","index":14,"n_rows":34,"n_cols":8,"rows_kept":34}
[]
[null,"12. Marking Revolutionary Patriot War Veteran's and Compatriot Graves"]
[]
[null,"12 - D.  Patriot Grave Registry donation to NSSAR"]
[null,"               (Member Points - 5 points per grave)"]
[]
[null,null,"Location and documentation of new Patriot Grave Information donated to the National Graves Registry Committee"]
[null,null,"applies to this Section."]
[null,null,"Ex: Compatriot John was able to locate two Patriot graves in a local cemetery. He sent the location of the graves "]
[null,null,"and documentation of Revolutionary service to the Chairman of the Patriot Graves Registry Committee."]
[]
[]
[null,null,"Date","Compatriot","Name of Patriot","Location","Points"]
[null,1,{"$nulls":4},{"$f":"IF(AND(C14<>\"\",D14<>\"\",E14<>\"\",F14<>\"\"),5,0)","v":0}]
[null,2,{"$nulls":4},{"$f":"IF(AND(C15<>\"\",D15<>\"\",E15<>\"\",F15<>\"\"),5,0)","v":0}]
[null,3,{"$nulls":4},0]
[null,4,{"$nulls":4},0]
[null,5,{"$nulls":4},0]
[null,6,{"$nulls":4},0]
[null,7,{"$nulls":4},0]
[null,8,{"$nulls":4},0]
[null,9,{"$nulls":4},0,{"$f":"IF(G34=40,\"Maximum Reached\",\"\")","v":""}]
[null,10,{"$nulls":4},0]
[null,11,{"$nulls":4},0]
[null,12,{"$nulls":4},0]
[null,13,{"$nulls":4},0]
[null,14,{"$nulls":4},0]
[null,15,{"$nulls":4},0]
[null,16,{"$nulls":4},0]
[null,17,{"$nulls":4},0]
[null,18,{"$nulls":4},0]
[null,19,{"$nulls":4},0]
[null,20,{"$nulls":4},0]
[{"$nulls":5},"TOTAL",{"$f":"IF(SUM(G14:G33)<=40, SUM(G14:G33),40)","v":0}]

{"sheet":"S-12E","index":15,"n_rows":32,"n_cols":11,"rows_kept":32}
[]
[null,"12. Marking Revolutionary Patriot War Veteran's and Compatriot Graves"]
[]
[null,"12 - E.  Participation in a Veterans Funeral (per funeral)"]
[null,null,"Veteran:",null,"Funeral of an Active Duty Veteran KIA:"]
[null,null,"(R)eading, (D)edicaton, (B)ugler = 20 pts",null,"(R)eading, (D)edicaton, (B)ugler = 40 pts"]
[null,null,"(P)allbearer or (H)onorary Pallbearer = 20 pts",null,"(P)allbearer or (H)onorary Pallbearer = 40 pts"]
[null,null,"(A)ttendance = 5 pts",null,"(A)ttendance = 10 pts"]
[null,null,"Mileage = 1 point/mile (max = 50 pts)",null,"Mileage = 2 points/mile (max = 50 pts)"]
[]
[null,null,"Note that a Funeral for an Active Duty Service Member who was Killed in Action earns double points,"]
[null,null," with the maximum of 50 points for mileage remaining the same."]
[]
[null,null,"Attendance at a Visitation, Service, or Funeral counts only once - even if all are attended."]
[]
[null,null,"Date","Compatriot","Role in Funeral","Name of Veteran","KIA (Y/N)","Location","Mileage","Mileage Max","Points"]
[null,1,{"$nulls":7},{"$f":"IF(AND(G17=\"N\",I17<=50),I17,IF(AND(G17=\"Y\",2*I17<=50),I17*2,50))","v":50},{"$f":"IF(AND(C17<>\"\",D17<>\"\",F17<>\"\",H17<>\"\",G17=\"N\",I17<>\"\",I17<>\" \",OR(E17=\"R\",E17=\"D\",E17=\"B\",E17=\"P\",E17=\"H\")),J17+20,IF(AND(C17<>\"\",D17<>\"\",F17<>\"\",H17<>\"\",G17=\"Y\",I17<>\"\",I17<>\" \",OR(E17=\"R\",E17=\"D\",E17=\"B\",E17=\"P\",E17=\"H\")),J17+40,IF(AND(C17<>\"\",D17<>\"\",F17<>\"\",H17<>\"\",G17=\"N\",I17<>\"\",I17<>\" \",E17=\"A\"),J17+5,IF(AND(C17<>\"\",D17<>\"\",F17<>\"\",H17<>\"\",G17=\"Y\",I17<>\"\",E17=\"A\"),J17+10,0))))","v":0}]
[null,2,{"$nulls":7},{"$f":"IF(AND(G18=\"N\",I18<=50),I18,IF(AND(G18=\"Y\",2*I18<=50),I18*2,50))","v":50},{"$f":"IF(AND(C18<>\"\",D18<>\"\",F18<>\"\",H18<>\"\",G18=\"N\",I18<>\"\",I18<>\" \",OR(E18=\"R\",E18=\"D\",E18=\"B\",E18=\"P\",E18=\"H\")),J18+20,IF(AND(C18<>\"\",D18<>\"\",F18<>\"\",H18<>\"\",G18=\"Y\",I18<>\"\",I18<>\" \",OR(E18=\"R\",E18=\"D\",E18=\"B\",E18=\"P\",E18=\"H\")),J18+40,IF(AND(C18<>\"\",D18<>\"\",F18<>\"\",H18<>\"\",G18=\"N\",I18<>\"\",I18<>\" \",E18=\"A\"),J18+5,IF(AND(C18<>\"\",D18<>\"\",F18<>\"\",H18<>\"\",G18=\"Y\",I18<>\"\",E18=\"A\"),J18+10,0))))","v":0}]
[null,3,{"$nulls":7},50,0]
[null,4,{"$nulls":7},50,0]
[null,5,{"$nulls":7},50,0]
[null,6,{"$nulls":7},50,0]
[null,7,{"$nulls":7},50,0]
[null,8,{"$nulls":7},50,0]
[null,9,{"$nulls":7},50,0]
[null,10,{"$nulls":7},50,0]
[null,11,{"$nulls":7},50,0]
[null,12,{"$nulls":7},50,0]
[null,13,{"$nulls":7},50,0]
[null,14,{"$nulls":7},50,0]
[null,15,{"$nulls":7},50,0]
[{"$nulls":8},"TOTAL",null,{"$f":"SUM(K17:K31)","v":0}]

{"sheet":"S-13","index":16,"n_rows":35,"n_cols":8,"rows_kept":35}
[]
[null,"13.  New or Used Clothing Donations"]
[null,null,"(1 point per $1 value)"]
[]
[null,null,"Use the value of clothing as determined by the IRS, or a fair market value as determined by a consignment shop or thrift store."]
[null,null,"The clothing must be given  to the VA, or an organization whose primary function is to serve veterans.  Donations to Goodwill "]
[null,null,"and the Salvation Army do not count since their primary function is not veteran related. Count 1 point for each $1 of value."]
[]
[null,null,"Date","Compatriot Making Donation","Description of Goods"," Facility Receiving Donation","Dollar Value ($)","Points"]
[null,1,{"$nulls":5},{"$f":"IF(AND(C10<>\"\",D10<>\"\",E10<>\"\",F10<>\"\",G10<>\"\",G10<>\" \"),G10*1,0)","v":0}]
[null,2,{"$nulls":5},{"$f":"IF(AND(C11<>\"\",D11<>\"\",E11<>\"\",F11<>\"\",G11<>\"\",G11<>\" \"),G11*1,0)","v":0}]
[null,3,{"$nulls":5},0]
[null,4,{"$nulls":5},0]
[null,5,{"$nulls":5},0]
[null,6,{"$nulls":5},0]
[null,7,{"$nulls":5},0]
[null,8,{"$nulls":5},0]
[null,9,{"$nulls":5},0]
[null,10,{"$nulls":5},0]
[null,11,{"$nulls":5},0]
[null,12,{"$nulls":5},0]
[null,13,{"$nulls":5},0]
[null,14,{"$nulls":5},0]
[null,15,{"$nulls":5},0]
[null,16,{"$nulls":5},0]
[null,17,{"$nulls":5},0]
[null,18,{"$nulls":5},0]
[null,19,{"$nulls":5},0]
[null,20,{"$nulls":5},0]
[null,21,{"$nulls":5},0]
[null,22,{"$nulls":5},0]
[null,23,{"$nulls":5},0]
[null,24,{"$nulls":5},0]
[null,25,{"$nulls":5},0]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H10:H34)","v":0}]

{"sheet":"S-14","index":17,"n_rows":32,"n_cols":8,"rows_kept":32}
[]
[null,"14.  Big Ticket Item Donations"]
[null,null,"(1 point per $1 value up to 1/3 of original cost)"]
[]
[null,null,"TV's, computers, appliances, etc. must be in working order.  Be sure to check with the VA Voluntary Service office of your nearest VA Medical "]
[null,null,"Center to determine if they will take the donation.  Some VAMC's will not accept electronics. Donations can be made to Veterans Service"]
[null,null," organizations whose primary function is to serve veterans."]
[null,null,"Points are based in 1/3 of the Original Cost New.  The original cost new should be entered."]
[]
[{"$nulls":6},"Original"]
[null,null,"Date","Compatriot Making Donation","Description of Goods"," Facility Receiving Donation","Cost New ($)","Points"]
[null,1,{"$nulls":5},{"$f":"IF(AND(C12<>\"\",D12<>\"\",E12<>\"\",F12<>\"\",G12<>\"\",G12<>\" \"),G12/3,0)","v":0}]
[null,2,{"$nulls":5},{"$f":"IF(AND(C13<>\"\",D13<>\"\",E13<>\"\",F13<>\"\",G13<>\"\",G13<>\" \"),G13/3,0)","v":0}]
[null,3,{"$nulls":5},0]
[null,4,{"$nulls":5},0]
[null,5,{"$nulls":5},0]
[null,6,{"$nulls":5},0]
[null,7,{"$nulls":5},0]
[null,8,{"$nulls":5},0]
[null,9,{"$nulls":5},0]
[null,10,{"$nulls":5},0]
[null,11,{"$nulls":5},0]
[null,12,{"$nulls":5},0]
[null,13,{"$nulls":5},0]
[null,14,{"$nulls":5},0]
[null,15,{"$nulls":5},0]
[null,16,{"$nulls":5},0]
[null,17,{"$nulls":5},0]
[null,18,{"$nulls":5},0]
[null,19,{"$nulls":5},0]
[null,20,{"$nulls":5},0]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H12:H31)","v":0}]