{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Grant Summary","GrantDetails","Committee","Legend"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Instructions","index":0,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,null,"Endowment Trust Fund Reimbursement Instructions and Guidelines"]
[]
["A.","How to fill out this request form:"]
[null,"1.","Complete the Grant Summary page completely. All white fields are required. The Financial Details section will be populated automatically."]
[null,"2.","Fill out the Grant Details with the specific items for which you are requesting reimbursement, one row for each item. Instructions and examples are provided at the top of the page."]
["B.","Reimbursement requests will be accepted by the Endowment Trust Fund (ETF) Disbursement Committee Chairman after January 1 and until"]
[null,"November 15 of the same year. Applications cannot pre-date the award/event and applications must be sent to the Committee Chairman as"]
[null,"an e-mail attachment."]
["C.","Instructions for chapters submitting requests for reimbursement:"]
[null,"1.","Each request submitted in an application must be itemized and include the recipient’s name, school or place of employment, date of"]
[null,null,"award, and other criteria used in making the award"]
[null,"2.","Reimbursement will be for the full amount for any approved medals and coins listed in the SAR Official Handbook and 75% of any"]
[null,null,"other approved chapter expenses. The Chapter should not be making a profit on awards reimbursed by the ETF."]
[null,"3.","Awards, to be eligible for reimbursement, must be awarded in accordance with the rules in the Official SAR Handbook. Requests to"]
[null,null,"present medals that may be presented with approval of the Florida Society must be submitted to and approved by the FLSSAR"]
[null,null,"Medals and Awards Committee prior to the event. A copy of that approval should accompany the application for reimbursement."]
[null,"4.","Eligible reimbursement will be limited to $750.00 per application. Chapters are limited to five (5) applications per year."]
["D.","Authorized reimbursement to chapters:"]
[null,"1.","Full reimbursement for all ROTC/JROTC medals; also one medal per year for the Rumbaugh Oration, Eagle Scout Scholarship, Knight Essay, and the JROTC Chapter Award Complete for the Outstanding Cadet of the Chapter. Full reimbursement for all US Navy Sea Cadet Corps (NSCC) Bronze Good Citizenship Medals. Full reimbursement for the Sea Cadet Medal Ribbon Bar which can be purchased along with the Bronze Good Citizenship Medal. For the state winners of the Enhanced JROTC, Eagle Scout Rumbaugh and Essay contests, chapters will be reimbursed 75% of the expense for travel (the current IRS allowable on January 1st of the calendar year) to Orlando and a hotel room."]
[null,"2.","Scholarship money for the Rumbaugh, Eagle Scout, JROTC, Knight Essay, Middle School Brochure Contest, and Americanism Poster Contest reimbursement limits are: $600 (1st), $400 (2nd), $200 (3rd). American History Teacher contest limit $500."]
[null,"3.","Meals for youth contests limits are $120.00 per award – limited to 3 meals, recipient and parents."]
[null,"4.","Medals for Law Enforcement, Fire-Safety, Heroism, Emergency Medical Services, Bronze Good Citizenship awards and other NSSAR medals presented to persons other than SAR members in recognition of their support of the SAR, persons whose achievements are noteworthy in their school, community or state, or those currently serving or who have served in the Armed Forces of the United States. Meals limited to $120.00 per award – limited to 3 meals, recipient, significant other and superior officer."]
[null,"5.","The SAR Wounded Warrior Certificate and Coin when presented to a non-SAR member of the U.S. Military injured in the line of duty. This is to be presented ONLY if the soldier/veteran has been awarded the Purple Heart Medal, and two meals per recipient. (Limit $120.00 per award – limited to 2 meals, recipient and significant other.) (Limit 2 awards per Chapter per year)."]
[null,"6.","Chapters purchasing flag kits for the Habitat for Humanity outreach program may request reimbursement. Limit of $500.00 per year. Chapters must report the name and address of each recipient, and the date of each dedication."]
[null,"7.","Support for the Florida Society C.A.R. Societies will be reimbursed at 100%."]
[null,"8.","Genealogical and Historical materials presented to public libraries and veterans museums."]
[null,"9.","Expenses incurred when honoring Revolutionary War Patriot’s graves."]
[null,"10.","Copies of historical documents presented to the Public Schools."]
[null,"11.","Restoration of historic and patriotic monuments."]
[null,"12.","History Fairs (Limit $200.00) and Genealogical workshops (Limit $400.00)."]
[null,"13.","Engraving expenses – not to exceed $20.00 per award."]
[null,"14.","Certificates of Appreciation, Eagle Scout patches and certificates, Flag Certificates and presentation folders."]
[null,"15.","Liberty Tree Dedication – not to exceed $500.00 per year."]
[null,"16.","The chapters are authorized reimbursement not to exceed $500 per calendar year for purchases of new, tangible, personal property that generates value points as outlined in the U.S. Stark Memorial Report for Resident veterans in nursing homes."]
[null,"17.","Support to Boy Scout Councils (Limit $500)"]
[null,"18.","Support to JROTC units. Limit $100 per unit."]
[null,"19.","The purchase of pamphlets /brochures to promote SAR membership or educate the public on our founding documents. A pamphlet example is \"The Declaration of Independence and the Constitution of the United States” printed by the SAR. The request should include the cost, the number distributed, and the individuals/groups to whom they were presented. Limit:$100."]
[null,"20.","Payments for historical sites & celebrations benefit be eligible for ETF reimbursement, not to exceed 100% or $500 per chapter."]
[]
[null,null,"BEFORE starting on your Endowment Trust Fund Grant Application Form, save the form to your PC. Add your chapter's name to the saved file name. \nFor Example, \"Lake-Sumter ETF request 101526\". Save this form and CLOSE this web page. Then OPEN the saved file on your PC."]
[]
[null,null,"Form updated and effective 11/1/2025"]

{"sheet":"Grant Summary","index":1,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[25,1,25,2],[28,1,28,2],[6,1,6,2],[8,1,8,2]]}
["Request Summary:"]
["Chapter tracking code (optional):"]
["Chapter:"]
["Amount Requested:"]
[]
["Chapter officer responsible for this project and contact for questions"]
["Name:"]
["Phone:"]
["Email:"]
[]
["Please indicate below where your ETF reimbursement check should be sent"]
["Name:"]
["Address:"]
["City:"]
["State:"]
["Zip:"]
[]
["Financial Details (This section is auto-calculated based on the entries in the Grant Details section)"]
["Total cost of project(s):",{"$f":"SUM(Legend!C2:C43)","v":0}]
["Less chapter/member contributions:",{"$f":"SUM(Legend!C2:C43)-SUM(Legend!E2:E43)","v":0}]
["Total amount requested:",{"$f":"B19-B20","v":0}]
[]
["Certification"]
["I do hereby affirm that the above statements are true and complete; that all Endowment Trust Fund money received will be used to help pay for"]
["the completed Chapter project detailed above; and that no funds will benefit any individual."]
["Chapter Officer:"]
[null,"The typed signature above is my authorized signature."]
["Date signed:"]
["Email:"]

{"sheet":"GrantDetails","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Grant Details"]
[]
["In the rows below, provide SPECIFIC information for this grant."]
["For Grant Type, use the drop-down list to select an authorized item."]
[]
["Examples include:"]
["ROTC Medal - Bronze","2026-01-01","Cadet Matthew Smith","My High School",30]
["Youth Contest Meal","2026-01-01","(x3) cadet and parents",null,120]
["Law Enforcement Commendation Medal","2026-01-01","Officer John Jones","Smithville Police Department",32.5]
["Habitat for Humanity Flag Kit","2026-01-01","Carson Family, 123 main street, mytown, FL",null,10]
[]
["Grant Type","Date","Recipient","School, Department, etc.","Amount","Additional Notes"]

{"sheet":"Committee","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[5,1,5,2],[6,1,6,2]]}
["Committee Use Only:"]
[]
["Approved:"]
["Amount:"]
["Date:"]
["Committee Chair:"]
["Committee Request #:"]
[]
["Committee Calculations:"]
["Grant Type","Qty Requested","Requested Amount","Reimbursement Percent","Authorized Amount"]

{"sheet":"Legend","index":4,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Grant Types","Qty Requested","Requested Amount","Reimbursement Percent","Authorized Amount",null,null,"Price","Approved"]
["Public Safety Medal",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A2)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A2)","v":0},1,{"$f":"C2*D2","v":0},null,null,null,"Yes",null,"ETF20251101"]
["Law Enforcement Commendation Medal",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A3)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A3)","v":0},1,0,null,null,32.5,"No"]
["Fire Safety Commendation Medal",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A4)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A4)","v":0},1,0,null,null,32.5]
["Emergency Medical Services Commendation Medal",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A5)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A5)","v":0},1,0,null,null,32.5]
["Heroism Medal",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A6)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A6)","v":0},1,0,null,null,32.5]
["Life Saving Medal",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A7)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A7)","v":0},1,0,null,null,32.5]
["Public Safety Meal",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A8)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A8)","v":0},0.75,0]
["Youth Contest Medal",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A9)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A9)","v":0},1,0]
["ROTC Medal - Silver",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A10)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A10)","v":0},1,0,null,null,30]
["ROTC Medal - Bronze",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A11)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A11)","v":0},1,0,null,null,30]
["JROTC Chapter Award Complete",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A12)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A12)","v":0},1,0,null,null,60]
["Sea Cadet Medal Set",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A13)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A13)","v":0},1,0,null,null,35]
["Sea Cadet Ribbon Bar",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A14)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A14)","v":0},1,0,null,null,6]
["Good Citizenship Medal - Bronze",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A15)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A15)","v":0},1,0,null,null,30]
["Chapter Orations Medal",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A16)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A16)","v":0},1,0,null,null,55]
["Chapter Essay Medal",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A17)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A17)","v":0},1,0,null,null,55]
["Eagle Scout Medal",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A18)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A18)","v":0},1,0,null,null,25]
["Eagle Scout Patch",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A19)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A19)","v":0},0.75,0,null,null,8]
["Eagle Scout Certificate",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A20)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A20)","v":0},0.75,0,null,null,0.5]
["Youth Video Contest Medal",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A21)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A21)","v":0},1,0,null,null,55]
["Youth Contest Meal",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A22)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A22)","v":0},0.75,0]
["Youth Contest Sholarship Money",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A23)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A23)","v":0},0.75,0]
["Youth Contest Travel",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A24)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A24)","v":0},0.75,0]
["Wounded Warrior Coin",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A25)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A25)","v":0},1,0,null,null,15]
["Wounded Warrior Certificate",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A26)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A26)","v":0},0.75,0,null,null,4]
["Wounded Warrior Meal",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A27)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A27)","v":0},0.75,0]
["Habitat for Humanity Flag Kit",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A28)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A28)","v":0},0.75,0]
["C.A.R. Society Support",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A29)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A29)","v":0},1,0]
["Genalogical and Historical materials presented",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A30)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A30)","v":0},0.75,0]
["Patriot Grave Expenses",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A31)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A31)","v":0},0.75,0]
["Restoration of monuments",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A32)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A32)","v":0},0.75,0]
["History Fairs",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A33)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A33)","v":0},0.75,0]
["Engraving Expenses",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A34)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A34)","v":0},0.75,0]
["Certificate of Appreciation",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A35)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A35)","v":0},0.75,0]
["Flag Certificate",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A36)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A36)","v":0},0.75,0]
["Presentation Folder",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A37)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A37)","v":0},0.75,0]
["Liberty Tree Dedication",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A38)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A38)","v":0},0.75,0]
["Tangible property for Veterans",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A39)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A39)","v":0},0.75,0]
["Support to Boy Scout Council",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A40)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A40)","v":0},0.75,0]
["Support to JROTC unit",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A41)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A41)","v":0},0.75,0]
["Pamphlets/Brochures",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A42)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A42)","v":0},0.75,0]
["Payments for historical sites and celebrations",{"$f":"COUNTIFS(GrantDetails!$A$13:$A$113,A43)","v":0},{"$f":"SUMIFS(GrantDetails!$E$13:$E$113,GrantDetails!$A$13:$A$113,A43)","v":0},1,0]