{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Overheads","Organisation","Staff Costs","Consumables + Other Costs","Travel & Subsistence","Other Costs","Summary","Schedule of Payments (2)","Schedule of Payments","Dropdown"],"not_rendered":{"charts":0,"images":1,"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":"Overheads","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"DO WE NEED THIS ?"]

{"sheet":"Organisation","index":1,"n_rows":89,"n_cols":8,"rows_kept":89,"cut":false,"hidden":false,"merged":[[51,1,51,2],[38,1,38,3],[34,1,34,3],[36,1,36,3],[58,1,58,3],[54,1,54,6],[53,1,53,6],[39,1,39,3],[26,1,26,2],[27,1,27,2],[28,1,28,2],[26,3,26,7],[27,3,27,7],[28,3,28,7],[30,1,30,2],[31,1,31,2],[32,1,32,2],[30,3,30,7],[31,3,31,7],[32,3,32,7],[1,1,1,8],[20,1,20,2],[22,1,22,2],[22,3,22,7],[24,1,24,2],[24,3,24,7],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[66,1,66,2],[67,1,67,2],[68,1,68,2],[69,1,69,2],[71,1,71,2],[74,1,74,10],[75,1,75,10],[76,1,76,10],[77,1,77,10],[78,1,78,10],[84,1,84,10],[85,3,85,10],[86,3,86,10],[88,4,88,10],[79,1,79,10],[80,1,80,10],[81,1,81,10],[82,1,82,10],[83,1,83,10]]}
[null,null,null,null,null,null,"Status:",{"$f":"IF(D89=\"\",\"ORIGINAL\",\"REVISED\")","v":"ORIGINAL"}]
[null,"Application form for a project with the Food Standards Agency Commercial Template"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Application Details"]
[]
[null,"Tender Reference"]
[]
[null,"Tender Title"]
[]
[null,"Full legal organisation name"]
[]
[null,"Main contact title"]
[null,"Main contact forname"]
[null,"Main contact surname"]
[]
[null,"Main contact position"]
[null,"Main contact email"]
[null,"Main contact phone"]
[]
[null,"Will you charge the Agency VAT on this proposal?",null,null,null,null,"Please select"]
[null,null,null,null,null,null,{"$f":"IF($G$35=\"Yes\",\"*Please provide your VAT Registration number below\", \"\")","v":""}]
[null,"Please state your VAT registration number:"]
[]
[null,"Project Costs Summary Breakdown by Participating Organisations"]
[null,"Please include only the cost to the FSA.  "]
[]
[null,"Organisation","VAT Code*","Total (£)"]
[null,"Insert name of Lead Organisation","Please select",0]
[null,"Insert name of Organisation 2","Please select",0]
[null,"Insert name of Organisation 3","Please select",0]
[null,"Insert name of Organisation 4","Please select",0]
[null,"Insert name of Organisation 5","Please select",0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[]
[null,"Total Project Costs (excluding VAT) **",null,{"$f":"SUM(D43:D50)","v":0}]
[]
[null,"*  Please indicate zero, exempt or standard rate.  VAT charges not identified above will not be paid by the FSA\n** The total cost figure should be the same as the total cost shown in table 4\n"]
[null,"** The total cost figure should be the same as the total cost shown below and in the Schedule of payments tab."]
[]
[]
[]
[null,"Project Costs Summary (Automatically calculated)"]
[]
[]
[null,"Staff Costs",null,{"$f":"'Staff Costs'!N38","v":0}]
[null,"Overhead Costs",null,{"$f":"'Staff Costs'!N40","v":0}]
[null,"Consumables and Other Costs",null,{"$f":"'Consumables + Other Costs'!L36","v":0}]
[null,"Travel and Subsistence Costs",null,{"$f":"'Travel & Subsistence'!L35","v":0}]
[null,"Other Costs - Part 1",null,{"$f":"'Consumables + Other Costs'!L42","v":0}]
[null,"Other Costs - Part 2",null,{"$f":"'Consumables + Other Costs'!L44","v":0}]
[null,"Other Costs - Part 3",null,{"$f":"'Consumables + Other Costs'!L46","v":0}]
[null,"Other Costs - Part 4",null,{"$f":"'Consumables + Other Costs'!L48","v":0}]
[null,"Other Costs - Part 5",null,{"$f":"'Consumables + Other Costs'!L50","v":0}]
[]
[null,"Total Project Costs",null,{"$f":"SUM(D62:D70)","v":0}]
[]
[]
[null,"COST OR VOLUME DISCOUNTS - INNOVATION"]
[null,"The Food Standards Agency collaborates with our suppliers to improve efficiency and performance to save the taxpayer money."]
[null,"A tenderer should include in his tender the extent of any discounts or rebates offered against their normal day rates or other"]
[null,"costs during each year of the contract.  Please provide full details below:"]
[]
[]
[]
[]
[]
[]
[]
[null,"SIGNATURE"]
[null,"NAME"]
[null,"DATE"]
[null,"REVISION DATE",null,null,"Enter the effective date if this version of the template replaces an earlier version"]

{"sheet":"Staff Costs","index":2,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[48,1,48,13],[41,1,41,13],[43,1,43,13],[44,1,44,13],[45,1,45,13],[46,1,46,13],[47,1,47,13],[6,1,6,7],[13,1,13,3],[8,1,8,13],[9,1,9,13],[10,1,10,13],[12,1,12,3],[39,9,39,11],[20,1,20,3],[21,1,21,3],[22,1,22,3],[34,1,34,3],[35,1,35,3],[37,9,37,11],[19,1,19,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3]]}
[]
[]
[]
[]
[]
[]
[null,"Staff Costs Table"]
[]
[null,"*This should reflect details entered in your technical application section 4C.   "]
[null,"Please insert as many lines as necessary for the individuals in the project team.  "]
[null,"Please note that FSA is willing to accept pay rates based upon average pay costs. You will need to indicate where these have been used."]
[]
[null,"* Role or Position within the project",null,null,null,"Participating Organisation",null,"Daily Rate (£/Day)",null,"* Daily Overhead Rate(£/Day)",null,"Days to be spent on the project by all staff at this grade",null,"Total Cost (incl. overheads)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(H14+J14)*L14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(H15+J15)*L15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,"Total Labour Costs",null,null,null,{"$f":"SUM(N14:N36)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"* Total Overhead Costs (if not shown above)"]
[]
[null,{"$f":"IF(N40>0,\"*Please provide full details below of how you have calculated your total overhead costs\", \"\")","v":""}]
[null," "]

{"sheet":"Consumables + Other Costs","index":3,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[43,1,43,9],[45,1,45,9],[47,1,47,9],[49,1,49,9],[51,7,51,9],[35,7,35,9],[23,1,23,5],[24,1,24,5],[25,1,25,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[29,1,29,5],[30,1,30,5],[31,1,31,5],[32,1,32,5],[41,1,41,9],[7,1,7,11],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5],[11,1,11,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[15,1,15,5],[16,1,16,5],[9,1,9,11],[21,1,21,5],[22,1,22,5],[40,2,40,9]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Consumable/Equipment Costs"]
[]
[null,"Please provide a breakdown of the consumables/equipment items you expect to consume during the project"]
[]
[null,"Item",null,null,null,null,null,"Quantity",null,"Cost/Item(£)",null,"Total"]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"J13*H13","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"J14*H14","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[]
[]
[null,null,null,null,null,null,null,"Total Material Costs",null,null,null,{"$f":"SUM(L13:L33)","v":0}]
[]
[]
[null,"Please provide, in the table below, estimates of other costs that do not fit within any other cost headings"]
[]
[null,null,"Description and justification of the cost",null,null,null,null,null,null,null,null,"Estimated Cost"]
[1,null,null,null,null,null,null,null,null,null,null,0]
[]
[2,null,null,null,null,null,null,null,null,null,null,0]
[]
[3,null,null,null,null,null,null,null,null,null,null,0]
[]
[4,null,null,null,null,null,null,null,null,null,null,0]
[]
[5,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,"Total Other Costs",null,null,null,{"$f":"SUM(L42:L50)","v":0}]

{"sheet":"Travel & Subsistence","index":4,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[20,1,20,5],[6,1,6,11],[11,1,11,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[10,1,10,5],[15,1,15,5],[16,1,16,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[34,5,34,9],[21,1,21,5],[22,1,22,5],[23,1,23,5],[24,1,24,5],[25,1,25,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[29,1,29,5],[30,1,30,5],[31,1,31,5]]}
[]
[]
[]
[]
[]
[]
[null,"Travel and Subsistence Costs"]
[]
[null,"Please provide a breakdown of the travel and subsistence costs you expect to incur during the project"]
[]
[null,"Purpose of journey or description of subsistence cost",null,null,null,null,null,"Frequency",null,"Cost each (£)",null,"Total Cost"]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"J12*H12","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"J13*H13","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[]
[]
[null,null,null,null,null,"Total Travel and Subsistence Costs",null,null,null,null,null,{"$f":"SUM(L12:L32)","v":0}]

{"sheet":"Other Costs","index":5,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":true,"merged":[[21,8,21,10],[6,1,6,11],[11,2,11,9],[13,2,13,9],[15,2,15,9],[17,2,17,9],[19,2,19,9],[10,2,10,9]]}
[]
[]
[]
[]
[]
[]
[null,"Other Costs"]
[]
[null,"Please provide, in the table below, estimates of other costs that do not fit within any other cost headings"]
[]
[null,null,"Description and justification of the cost",null,null,null,null,null,null,null,null,"Estimated Cost"]
[null,1,null,null,null,null,null,null,null,null,null,0]
[]
[null,2,null,null,null,null,null,null,null,null,null,0]
[]
[null,3,null,null,null,null,null,null,null,null,null,0]
[]
[null,4,null,null,null,null,null,null,null,null,null,0]
[]
[null,5,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,"Total Other Costs",null,null,{"$f":"SUM(L12:L20)","v":0}]

{"sheet":"Summary","index":6,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":true,"merged":[[15,1,15,2],[16,1,16,2],[17,1,17,2],[19,1,19,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2]]}
[]
[]
[]
[]
[]
[]
[null,"Project Costs Summary"]
[]
[]
[null,"Staff Costs",null,{"$f":"'Staff Costs'!N38","v":0}]
[null,"Overhead Costs",null,{"$f":"'Staff Costs'!#REF!","v":{"$error":"#REF!"}}]
[null,"Materials Costs",null,{"$f":"'Consumables + Other Costs'!L36","v":0}]
[null,"Travel and Subsistence Costs",null,{"$f":"'Travel & Subsistence'!L35","v":0}]
[null,"Other Costs - Part 1",null,{"$f":"'Other Costs'!L12","v":0}]
[null,"Other Costs - Part 2",null,{"$f":"'Other Costs'!L14","v":0}]
[null,"Other Costs - Part 3",null,{"$f":"'Other Costs'!L16","v":0}]
[null,"Other Costs - Part 4",null,{"$f":"'Other Costs'!L18","v":0}]
[null,"Other Costs - Part 5",null,{"$f":"'Other Costs'!L20","v":0}]
[]
[null,"Total Project Costs",null,{"$f":"SUM(D10:D18)","v":{"$error":"#REF!"}}]

{"sheet":"Schedule of Payments (2)","index":7,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[[51,1,51,7],[13,1,13,7],[18,3,18,4],[46,1,46,7],[47,1,47,7],[48,1,48,7],[49,1,49,7],[12,1,12,7],[6,1,6,7],[8,1,8,7],[9,1,9,7],[10,1,10,7],[11,1,11,7]]}
[]
[]
[]
[]
[]
[]
[null,"The Pricing Schedule"]
[]
[null,"Please complete a proposed schedule of payments below, excluding VAT to be charged by any subcontractors to the project lead "]
[null,"applicant.  This must add up to the same value as detailed in the Summary of project costs to FSA including  participating"]
[null,"organisations costs."]
[null,"Where differing rates of VAT apply against the deliverables please provide details on separate lines."]
[null,"Please link all deliverables (singly or grouped) to each payment. Please ensure that deliverable numbers are given as well as a "]
[null,"brief description e.g. Deliverable 01/02: interim report submitted to the FSA, monthly report, interim report, final report"]
[null,"Payment will be made to the Contractor, as per the schedule of payments upon satisfactory completion of the deliverables."]
[]
[null,{"$f":"IF(C19=\"\", \"Please enter proposed project start date (dd/mmm/yyyy)\",\"\")","v":"Please enter proposed project start date (dd/mmm/yyyy)"}]
[]
[null,"Proposed Project Start Date",null,"Amount"]
[null,"Invoice Due Date","Description as to which deliverables this invoice will refer to (Please include the deliverable ref no(s) as appropriate)","*Net","** VAT Code","§ Duration from start of project (Weeks)","§ Duration from start of project (Date)","Financial Year"]
[null,null,null,0,null,{"$f":"IF(B21=\"\",0,INT(B21-$C$19)/7)","v":0},{"$f":"IF(OR($C$19=0,F21=0,),\"\",($C$19+(F21*7)))","v":""},{"$f":"IF(G21=\"\",\"\",IF(MONTH(G21)<4,YEAR(G21)-1&\"-\"&RIGHT(YEAR(G21),2),YEAR(G21)&\"-\"&RIGHT(YEAR(G21)+1,2)))","v":""}]
[null,null,null,0,null,{"$f":"IF(B22=\"\",0,INT(B22-$C$19)/7)","v":0},{"$f":"IF(OR($C$19=0,F22=0,),\"\",($C$19+(F22*7)))","v":""},{"$f":"IF(G22=\"\",\"\",IF(MONTH(G22)<4,YEAR(G22)-1&\"-\"&RIGHT(YEAR(G22),2),YEAR(G22)&\"-\"&RIGHT(YEAR(G22)+1,2)))","v":""}]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,null,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,"Retention/Final Deliverable","***",{"$f":"ROUND(Organisation!D72/100*20,2)","v":0},null,null,"",""]
[]
[null,null,"Total",{"$f":"SUM(D21:D42)","v":0},null,{"$f":"IF(D44=Organisation!D72,\"Totals Agree\",\"Totals Disagree\")","v":"Totals Agree"}]
[]
[]
[null,"* Please insert the amount to be invoiced net of any VAT for each deliverable"]
[null,"** Please insert the applicable rate of VAT for each deliverable"]
[null,"*** 20% of the total project budget is withheld and will be paid upon acceptance of a satisfactory final report by the agency."]
[null,"§The number of weeks after project commencement for the deliverable to be completed "]
[]
[null,"Summary of Payments"]
[]
[null,null,null,"Year 1","Year 2","Year 3","Year 4"]
[null,null,"Financial Year (Update as applicable in YYYY-YY format)","2022-23","2023-24","2024-25","2025-26","Retention","Total"]
[null,null,"Total Amount",{"$f":"SUMIF($H$21:$H41,D$55,$D21:$D41)","v":0},{"$f":"SUMIF($H$21:$H41,E$55,$D21:$D41)","v":0},{"$f":"SUMIF($H$21:$H41,F$55,$D21:$D41)","v":0},{"$f":"SUMIF($H$21:$H41,G$55,$D21:$D41)","v":0},{"$f":"D42","v":0},{"$f":"SUM(D56:H56)","v":0}]

{"sheet":"Schedule of Payments","index":8,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[51,1,51,7],[46,1,46,7],[47,1,47,7],[48,1,48,7],[49,1,49,7],[6,1,6,7],[18,3,18,4],[8,1,8,7],[9,1,9,7],[10,1,10,7],[11,1,11,7],[12,1,12,7],[13,1,13,7]]}
[]
[]
[]
[]
[]
[]
[null,"The Pricing Schedule"]
[]
[null,"Please complete a proposed schedule of payments below, excluding VAT to be charged by any subcontractors to the project lead "]
[null,"applicant.  This must add up to the same value as detailed in the Summary of project costs to FSA including  participating"]
[null,"organisations costs."]
[null,"Where differing rates of VAT apply against the deliverables please provide details on separate lines."]
[null,"Please link all deliverables (singly or grouped) to each payment. Please ensure that deliverable numbers are given as well as a "]
[null,"brief description e.g. Deliverable 01/02: interim report submitted to the FSA, monthly report, interim report, final report"]
[null,"Payment will be made to the Contractor, as per the schedule of payments upon satisfactory completion of the deliverables."]
[]
[null,{"$f":"IF(C19=\"\", \"Please enter proposed project start date (dd/mmm/yyyy)\",\"\")","v":"Please enter proposed project start date (dd/mmm/yyyy)"}]
[]
[null,"Proposed Project Start Date",null,"Amount"]
[null,"Invoice Due Date","Description as to which deliverables this invoice will refer to (Please include the deliverable ref no(s) as appropriate)","*Net","** VAT Code","§ Duration from start of project (Weeks)","§ Duration from start of project (Date)","Financial Year"]
[null,null,null,0,null,{"$f":"IF(B21=\"\",0,INT(B21-$C$19)/7)","v":0},{"$f":"IF(OR($C$19=0,F21=0,),\"\",($C$19+(F21*7)))","v":""},{"$f":"IF(G21=\"\",\"\",IF(MONTH(G21)<4,YEAR(G21)-1&\"-\"&RIGHT(YEAR(G21),2),YEAR(G21)&\"-\"&RIGHT(YEAR(G21)+1,2)))","v":""}]
[null,null,null,0,null,{"$f":"IF(B22=\"\",0,INT(B22-$C$19)/7)","v":0},{"$f":"IF(OR($C$19=0,F22=0,),\"\",($C$19+(F22*7)))","v":""},{"$f":"IF(G22=\"\",\"\",IF(MONTH(G22)<4,YEAR(G22)-1&\"-\"&RIGHT(YEAR(G22),2),YEAR(G22)&\"-\"&RIGHT(YEAR(G22)+1,2)))","v":""}]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,null,null,0,null,0,"",""]
[null,"Retention/Final Deliverable","***",{"$f":"ROUND(Organisation!D72/100*20,2)","v":0},null,null,"",""]
[]
[null,null,"Total",{"$f":"SUM(D21:D42)","v":0},null,{"$f":"IF(D44=Organisation!D72,\"Totals Agree\",\"Totals Disagree\")","v":"Totals Agree"}]
[]
[]
[null,"* Please insert the amount to be invoiced net of any VAT for each deliverable"]
[null,"** Please insert the applicable rate of VAT for each deliverable"]
[null,"*** 20% of the total project budget is withheld and will be paid upon acceptance of a satisfactory final report by the agency."]
[null,"§The number of weeks after project commencement for the deliverable to be completed "]
[]
[null,"Summary of Payments"]
[]
[null,null,null,"Year 1","Year 3","Year 4"]
[null,null,"Financial Year (Update as applicable in YYYY-YY format)","2023-24","2024-25","2025-26","Retention","Total"]
[null,null,"Total Amount",{"$f":"SUMIF($H$21:$H41,D$55,$D21:$D41)","v":0},{"$f":"SUMIF($H$21:$H41,E$55,$D21:$D41)","v":0},{"$f":"SUMIF($H$21:$H41,F$55,$D21:$D41)","v":0},{"$f":"D42","v":0},{"$f":"SUM(D56:G56)","v":0}]

{"sheet":"Dropdown","index":9,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Please select","Please select","Please select"]
["20% of Labour Costs","STD","Yes"]
["Own calculations","ZERO","No"]
[null,"EXEMPT"]