{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Terms of Use","Introduction","Cost Summary","Other charges","Non chargeable","Materials","New","Renewal","Knowledge test","Basic English Test","Replacement Licence","Change of Address","Replacement Badge"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"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":"Terms of Use","index":0,"n_rows":100,"n_cols":1,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["IMPORTANT NOTICE: PLEASE READ CAREFULLY  BEFORE USING THE SOFTWARE: "]
[]
["This licence agreement (Licence) is a legal agreement between you (Licensee or you) and the WELSH HEADS OF ENVIRONMENTAL HEALTH – ALL WALES LICENSING EXPERT PANEL (Licensor, us, our or we) for:"]
[]
["§         ALL WALES LICENSING EXPERT PANEL – TAXI FEES TOOLKIT V. 2.1 computer software (Software); and the"]
["§         printed materials and electronic documentation (Documentation). "]
[]
["We licence use of the Software and Document to you on the basis of this Licence. We do not sell the Software or Documentation to you. We remain the owners of the Software and Documentation at all times. "]
[]
["IMPORTANT NOTICE TO ALL USERS: "]
[]
["§         BY USING THIS SOFTWARE, YOU AGREE TO THE TERMS OF THIS LICENCE WHICH WILL BIND YOU AND YOUR EMPLOYEES. THE TERMS OF THIS LICENCE INCLUDE, IN PARTICULAR, LIMITATIONS ON OUR LIABILITY."]
[]
["§         IF YOU DO NOT AGREE TO THE TERMS OF THIS LICENCE, WE WILL NOT LICENSE THE SOFTWARE AND DOCUMENTATION TO YOU AND YOU MUST DISCONTINUE YOUR USE OF THE SOFTWARE NOW.  "]
[]
["You should print a copy of this Licence for future reference."]
[]
["1.                   Grant and scope of licence"]
[]
["1.1               In consideration of you agreeing to abide by the terms of this Licence, the Licensor hereby grants to you a non-exclusive, non-transferable licence to use the Software and the Documentation in the UK on the terms of this Licence."]
[]
["1.2               You may:"]
[]
["(a)          install and use the Software for your internal business purposes."]
[]
["(b)          use any Documentation in support of the use permitted under condition 1 and make copies of the Documentation as are reasonably necessary for its lawful use."]
[]
["2.                   Restrictions"]
[]
["2.1               Except as expressly set out in this Licence or as permitted by any local law, you undertake: "]
[]
["(a)          not to copy the Software or Documentation except where such copying is incidental to normal use of the Software or where it is necessary for the purpose of back-up or operational security;"]
[]
["(b)          not to rent, lease, sub-license, loan, translate, merge, adapt, vary or modify the Software or Documentation;"]
[]
["(c)          not to make alterations to, or modifications of, the whole or any part of the Software nor permit the Software or any part of it to be combined with, or become incorporated in, any other programs;"]
["(d)          not to disassemble, de-compile, reverse engineer or create derivative works based on the whole or any part of the Software nor attempt to do any such things except to the extent that (by virtue of section 296A of the Copyright, Designs and Patents Act 1988) such actions cannot be prohibited because they are essential for the purpose of achieving inter-operability of the Software with another software program, and provided that the information obtained by you during such activities:"]
[]
["(i)             is used only for the purpose of achieving inter-operability of the Software with another software program;"]
[]
["(ii)           is not disclosed or communicated without the Licensor's prior written consent to any third party to whom it is not necessary to disclose or communicate it; and"]
[]
["(iii)          is not used to create any software which is substantially similar to the Software."]
[]
["(e)          to keep all copies of the Software secure; "]
[" "]
["(f)            to supervise and control use of the Software and ensure that the Software is used by your employees and representatives in accordance with the terms of this Licence;"]
[]
["(g)          not to provide, or otherwise make available, the Software in any form, in whole or in part (including, but not limited to, program listings, object and source program listings, object code and source code) to any person without prior written consent from us."]
[]
["3.                   Intellectual property rights"]
[]
["3.1               You acknowledge that all intellectual property rights in the Software and the Documentation throughout the world belong to us, that rights in the Software are licensed (not sold) to you, and that you have no rights in, or to, the Software or the Documentation other than the right to use them in accordance with the terms of this Licence."]
[]
["4.                   Limited warranty"]
[]
["4.1               We warrant that:"]
[]
["(a)          the Software will, when properly used and on an operating system for which it was designed, perform substantially in accordance with the functions described in the Documentation; and"]
[]
["(b)          that the Documentation correctly describes the operation of the Software in all material respects. "]
[]
["5.                   Limitation of liability "]
[]
["5.1               You acknowledge that the Software has not been developed to meet your individual requirements, and that it is therefore your responsibility to ensure that the facilities and functions of the Software as described in the Documentation meet your requirements."]
[]
["5.2               We only supply the Software and Documentation for internal use by your business, and you agree not to use the Software or Documentation for any re-sale purposes. "]
[]
["5.3               To the fullest extent permissible by English law we shall not under any circumstances whatsoever be liable to you for any losses, claims or demands that result from the use of the Software or Documentation, whether such claims or demands are founded in contract, tort (including negligence), breach of statutory duty, or otherwise. For the avoidance of doubt this includes all claims including claims relating to:"]
[]
["(a)          loss of profits, sales, business, or revenue;"]
["(b)          business interruption;"]
["(c)          loss of anticipated savings;"]
["(d)          loss or corruption of data or information;"]
["(e)          loss of business opportunity, goodwill or reputation; or"]
["(f)            any indirect or consequential loss or damage."]
[]
["5.4               This Licence sets out the full extent of our obligations and liabilities in respect of the supply of the Software and Documentation. Except as expressly stated in this Licence, there are no conditions, warranties, representations or other terms, express or implied, that are binding on us.  Any condition, warranty, representation or other term concerning the supply of the Software and Documentation which might otherwise be implied into, or incorporated in, this Licence whether by statute, common law or otherwise, is excluded to the fullest extent permitted by law."]
[]
["6.                   Termination"]
[]
["6.1               We may terminate this Licence immediately by written notice to you if you commit a material or persistent breach of this Licence which you fail to remedy (if remediable) within 14 days after the service of written notice requiring you to do so. "]
[]
["6.2               Upon termination for any reason:"]
[]
["(a)          all rights granted to you under this Licence shall cease;"]
[]
["(b)          you must cease all activities authorised by this Licence;"]
[]
["(c)          you must immediately delete or remove the Software from all computer equipment in your possession and immediately destroy or return to us (at our option) all copies of the Software then in your possession, custody or control and, in the case of destruction, certify to us that you have done so."]
[]
["7.                   Other important terms"]
[]
["7.1               We may transfer our rights and obligations under this Licence to another organisation, but this will not affect your rights or our obligations under this Licence. "]
[]
["7.2               You may only transfer your rights or your obligations under this Licence to another person if we agree in writing."]
[]
["7.3               This Licence constitutes the entire agreement between you and us. You acknowledge that you have not relied on any statement, promise or representation made or given by or on behalf of the us which is not set out in this Licence."]
[]
["7.4               This Licence, its subject matter and its formation (and any non-contractual disputes or claims) are governed by English law. We both agree to the exclusive jurisdiction of the courts of England and Wales. "]

{"sheet":"Introduction","index":1,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[28,0,30,8],[19,0,27,8],[31,0,32,8],[0,0,3,8],[4,0,18,8]]}
[" All Wales Licensing Technical Panel "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"  "]
[]
[]
[]
[]
[]
[]
["The All Wales Licensing Technical Panel is a sub group of the Welsh Heads of Environmental Health Group (WHoEHG).  The membership includes Managers and Senior Officers from each of the local authorities in Wales that has responsibility for Licensing functions.  The toolkit has been developed with the aim of providing a consistent and robust mechanism for setting Licensing Fees.  The toolkit comprises of 4 documents: An Overview of legislation, Guidance notes on completing the spreadsheets, guidance notes on time monitoring and the spreadsheets for calculating fees.  It is essential that users read these documents before attempting to complete the spreadsheets.   "]
[]
[]
[]
[]
[]
[]
[]
[]
["The All Wales Licensing Technical Panel is happy to provide this toolkit to assist Local Authorities in setting their fees, however each individual Local Authority is liable for its use.  It is therefore advisable to seek your own legal and financial advice."]
[]
[]
["All Wales Licensing Technical Panel - Version 2.1 - 12th December 2014"]

{"sheet":"Cost Summary","index":2,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":false,"merged":[[37,0,37,5],[0,0,0,15],[17,16,17,17],[11,1,12,1],[23,1,24,1],[1,1,1,3],[23,15,24,15],[11,0,12,0],[1,0,2,0],[23,0,24,0],[35,0,35,1],[36,0,36,1],[11,15,12,15],[1,4,2,4],[23,3,23,14],[11,3,11,14]]}
["Cost Summary"]
["Post Title","Salary Costs",null,null,"TOTAL SALARY"]
[null,"BASIC","NI","SUPER"]
[null,null,null,null,{"$f":"SUM(B4:D4)","v":0},null,null,null,null,"   "]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0,null,null,null," "]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["Post Title","Number of Posts",null,"Central Recharges (refer to \"Overview\" Document)",null,null,null,null,null,null,null,null,null,null,null,"Total Recharges"]
[null,null,null,"Header 1","Header 2","Header 3","Header 4","Header 5","Header 6","Header 7","Header 8","Header 9","Header 10","Header 11","Header 12"]
[null,null,"Total (£)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:O14)","v":0}]
[{"$f":"A4","v":0},null,null,{"$f":"SUM(D14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O14/B22)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[0,null,null,{"$f":"SUM(D14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O14/B22)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[0,null,null,{"$f":"SUM(D14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O14/B22)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[0,null,null,{"$f":"SUM(D14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O14/B22)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[0,null,null,{"$f":"SUM(D14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O14/B22)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[0,null,null,{"$f":"SUM(D14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O14/B22)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[0,null,null,{"$f":"SUM(D14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N14/B22)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O14/B22)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Total No. Posts",{"$f":"SUM(B15:B21)","v":0}]
[]
["Post Title","Number of Posts",null,"Direct Costs (refer to \"Overview\" Document)",null,null,null,null,null,null,null,null,null,null,null,"Total Recharges"]
[null,null,null,"Header 1","Header 2","Header 3","Header 4","Header 5","Header 6","Header 7","Header 8","Header 9","Header 10","Header 11","Header 12"]
[null,null,"Total (£)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D26:O26)","v":0}]
[{"$f":"A4","v":0},{"$f":"B15","v":0},null,{"$f":"SUM(D26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D27:O27)","v":{"$error":"#DIV/0!"}}]
[0,0,null,{"$f":"SUM(D26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D28:O28)","v":{"$error":"#DIV/0!"}}]
[0,0,null,{"$f":"SUM(D26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D29:K29)","v":{"$error":"#DIV/0!"}}]
[0,0,null,{"$f":"SUM(D26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D30:O30)","v":{"$error":"#DIV/0!"}}]
[0,0,null,{"$f":"SUM(D26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D31:O31)","v":{"$error":"#DIV/0!"}}]
[0,0,null,{"$f":"SUM(D26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D32:O32)","v":{"$error":"#DIV/0!"}}]
[0,0,null,{"$f":"SUM(D26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O26/B34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D33:O33)","v":{"$error":"#DIV/0!"}}]
["Total No. Posts",{"$f":"SUM(B27:B33)","v":0}]
[]
["Agreed Annual Productive hours"]
["Agreed Annual Chargeable hours"]
["Hourly Rate"]
["Post Title","Total Salary","Total Recharges","Total Direct Charges","Total","Hourly Rate (Total divided by Agreed Annual Chargeable hours)"]
[{"$f":"A4","v":0},{"$f":"SUM(E4)","v":0},{"$f":"P15","v":{"$error":"#DIV/0!"}},{"$f":"P27","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B40:D40)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E40/C37)","v":{"$error":"#DIV/0!"}}]
[0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(E41/C37)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"  "]
[0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(E42/C37)","v":{"$error":"#DIV/0!"}}]
[0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(E43/C37)","v":{"$error":"#DIV/0!"}}]
[0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(E44/C37)","v":{"$error":"#DIV/0!"}}]
[0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(E45/C37)","v":{"$error":"#DIV/0!"}}]
[0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(E46/C37)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Other charges","index":3,"n_rows":54,"n_cols":16,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,1,54,1],[53,0,54,0],[3,0,3,15],[0,0,0,15],[30,0,32,0],[36,0,36,1],[49,0,49,1],[27,0,29,0],[15,0,17,0],[18,0,20,0],[21,0,23,0],[24,0,26,0],[6,0,8,0],[9,0,11,0],[12,0,14,0]]}
["Drivers - Other Charges (within normal working hours)"]
[]
["Licence Duration"]
["Table 1 - Charges for time"]
["Officer (name)"]
["Hourly Rate"]
["Enquiries"]
[null,{"$f":"SUM(B7*B3)","v":0},{"$f":"SUM(C7*B3)","v":0},{"$f":"SUM(D7*B3)","v":0},{"$f":"SUM(E7*B3)","v":0},{"$f":"SUM(F7*B3)","v":0},{"$f":"SUM(G7*B3)","v":0},{"$f":"SUM(H7*B3)","v":0},{"$f":"SUM(I7*B3)","v":0},{"$f":"SUM(J7*B3)","v":0},{"$f":"SUM(K7*B3)","v":0},{"$f":"SUM(L7*B3)","v":0},{"$f":"SUM(M7*B3)","v":0},{"$f":"SUM(N7*B3)","v":0},{"$f":"SUM(O7*B3)","v":0},{"$f":"SUM(P7*B3)","v":0}]
[null,{"$f":"SUM(B6/60)*B8","v":0},{"$f":"SUM(C6/60)*C8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["Complaints"]
[null,{"$f":"SUM(B10*B3)","v":0},{"$f":"SUM(C10*B3)","v":0},{"$f":"SUM(D10*B3)","v":0},{"$f":"SUM(E10*B3)","v":0},{"$f":"SUM(F10*B3)","v":0},{"$f":"SUM(G10*B3)","v":0},{"$f":"SUM(H10*B3)","v":0},{"$f":"SUM(I10*B3)","v":0},{"$f":"SUM(J10*B3)","v":0},{"$f":"SUM(K10*B3)","v":0},{"$f":"SUM(L10*B3)","v":0},{"$f":"SUM(M10*B3)","v":0},{"$f":"SUM(N10*B3)","v":0},{"$f":"SUM(O10*B3)","v":0},{"$f":"SUM(P10*B3)","v":0}]
[null,{"$f":"SUM(B6/60)*B11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Project Work"]
[null,{"$f":"SUM(B13*B3)","v":0},{"$f":"SUM(C13*B3)","v":0},{"$f":"SUM(D13*B3)","v":0},{"$f":"SUM(E13*B3)","v":0},{"$f":"SUM(F13*B3)","v":0},{"$f":"SUM(G13*B3)","v":0},{"$f":"SUM(H13*B3)","v":0},{"$f":"SUM(I13*B3)","v":0},{"$f":"SUM(J13*B3)","v":0},{"$f":"SUM(K13*B3)","v":0},{"$f":"SUM(L13*B3)","v":0},{"$f":"SUM(M13*B3)","v":0},{"$f":"SUM(N13*B3)","v":0},{"$f":"SUM(O13*B3)","v":0},{"$f":"SUM(P13*B3)","v":0}]
[null,{"$f":"SUM(B6/60)*B14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["General Admin"]
[null,{"$f":"SUM(B16*B3)","v":0},{"$f":"SUM(C16*B3)","v":0},{"$f":"SUM(D16*B3)","v":0},{"$f":"SUM(E16*B3)","v":0},{"$f":"SUM(F16*B3)","v":0},{"$f":"SUM(G16*B3)","v":0},{"$f":"SUM(H16*B3)","v":0},{"$f":"SUM(I16*B3)","v":0},{"$f":"SUM(J16*B3)","v":0},{"$f":"SUM(K16*B3)","v":0},{"$f":"SUM(L16*B3)","v":0},{"$f":"SUM(M16*B3)","v":0},{"$f":"SUM(N16*B3)","v":0},{"$f":"SUM(O16*B3)","v":0},{"$f":"SUM(P16*B3)","v":0}]
[null,{"$f":"SUM(B6/60)*B17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Meetings"]
[null,{"$f":"SUM(B19*B3)","v":0},{"$f":"SUM(C19*B3)","v":0},{"$f":"SUM(D19*B3)","v":0},{"$f":"SUM(E19*B3)","v":0},{"$f":"SUM(F19*B3)","v":0},{"$f":"SUM(G19*B3)","v":0},{"$f":"SUM(H19*B3)","v":0},{"$f":"SUM(I19*B3)","v":0},{"$f":"SUM(J19*B3)","v":0},{"$f":"SUM(K19*B3)","v":0},{"$f":"SUM(L19*B3)","v":0},{"$f":"SUM(M19*B3)","v":0},{"$f":"SUM(N19*B3)","v":0},{"$f":"SUM(O19*B3)","v":0},{"$f":"SUM(P19*B3)","v":0}]
[null,{"$f":"SUM(B6/60)*B20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Training time(i.e. excluding cost of training)"]
[null,{"$f":"SUM(B22*B3)","v":0},{"$f":"SUM(C22*B3)","v":0},{"$f":"SUM(D22*B3)","v":0},{"$f":"SUM(E22*B3)","v":0},{"$f":"SUM(F22*B3)","v":0},{"$f":"SUM(G22*B3)","v":0},{"$f":"SUM(H22*B3)","v":0},{"$f":"SUM(I22*B3)","v":0},{"$f":"SUM(J22*B3)","v":0},{"$f":"SUM(K22*B3)","v":0},{"$f":"SUM(L22*B3)","v":0},{"$f":"SUM(M22*B3)","v":0},{"$f":"SUM(N22*B3)","v":0},{"$f":"SUM(O22*B3)","v":0},{"$f":"SUM(P22*B3)","v":0}]
[null,{"$f":"SUM(B6/60)*B23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Compliance and Enforcement (licensed only)"]
[null,{"$f":"SUM(B25*B3)","v":0},{"$f":"SUM(C25*B3)","v":0},{"$f":"SUM(D25*B3)","v":0},{"$f":"SUM(E25*B3)","v":0},{"$f":"SUM(F25*B3)","v":0},{"$f":"SUM(G25*B3)","v":0},{"$f":"SUM(H25*B3)","v":0},{"$f":"SUM(I25*B3)","v":0},{"$f":"SUM(J25*B3)","v":0},{"$f":"SUM(K25*B3)","v":0},{"$f":"SUM(L25*B3)","v":0},{"$f":"SUM(M25*B3)","v":0},{"$f":"SUM(N25*B3)","v":0},{"$f":"SUM(O25*B3)","v":0},{"$f":"SUM(P25*B3)","v":0}]
[null,{"$f":"SUM(B6/60)*B26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Committee Disciplinary"]
[null,{"$f":"SUM(B28*B3)","v":0},{"$f":"SUM(C28*B3)","v":0},{"$f":"SUM(D28*B3)","v":0},{"$f":"SUM(E28*B3)","v":0},{"$f":"SUM(F28*B3)","v":0},{"$f":"SUM(G28*B3)","v":0},{"$f":"SUM(H28*B3)","v":0},{"$f":"SUM(I28*B3)","v":0},{"$f":"SUM(J28*B3)","v":0},{"$f":"SUM(K28*B3)","v":0},{"$f":"SUM(L28*B3)","v":0},{"$f":"SUM(M28*B3)","v":0},{"$f":"SUM(N28*B3)","v":0},{"$f":"SUM(O28*B3)","v":0},{"$f":"SUM(P28*B3)","v":0}]
[null,{"$f":"SUM(B6/60)*B29","v":0},{"$f":"SUM(C6/60)*C29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"SUM(B31*B3)","v":0},{"$f":"SUM(C31*B3)","v":0},{"$f":"SUM(D31*B3)","v":0},{"$f":"SUM(E31*B3)","v":0},{"$f":"SUM(F31*B3)","v":0},{"$f":"SUM(G31*B3)","v":0},{"$f":"SUM(H31*B3)","v":0},{"$f":"SUM(I31*B3)","v":0},{"$f":"SUM(J31*B3)","v":0},{"$f":"SUM(K31*B3)","v":0},{"$f":"SUM(L31*B3)","v":0},{"$f":"SUM(M31*B3)","v":0},{"$f":"SUM(N31*B3)","v":0},{"$f":"SUM(O31*B3)","v":0},{"$f":"SUM(P31*B3)","v":0}]
[null,{"$f":"SUM(B6/60)*B32","v":0},{"$f":"SUM(C6/60)*C32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total   ",{"$f":"SUM(B9+B12+B15+B18+B21+B24+B27+B30+B33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Charges for time",{"$f":"SUM(B34:P34)","v":0}]
[]
["Table 2 - Specific Costs"]
["Type of Charge","£"]
["Previous Surplus"]
["Previous Deficit"]
["Out of Hours Work (compliance)"]
["Replacement Badge"]
["Replacement Licence"]
["Change of Address"]
[]
[]
[]
["Total Specific Costs",{"$f":"SUM(B39:B47)","v":0}]
[]
["Table 3 - Licence Holders"]
["Total Licence Holders"]
[]
[]
["Total Other Charges",{"$f":"SUM(B35+B48)/B51","v":{"$error":"#DIV/0!"}}]

{"sheet":"Non chargeable","index":4,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[29,0,29,1],[0,0,0,15],[15,0,17,0],[18,0,20,0],[21,0,23,0],[6,0,8,0],[9,0,11,0],[12,0,14,0],[3,0,3,15]]}
["Drivers - Non Chargeable (within normal working hours)"]
[]
["Licence Duration"]
["Table 1 - Charges for time"]
["Officer (name)"]
["Hourly Rate"]
["Enforcement (unlicensed)"]
[null,{"$f":"SUM(B7*B3)","v":0},{"$f":"SUM(C7*B3)","v":0},{"$f":"SUM(D7*B3)","v":0},{"$f":"SUM(E7*B3)","v":0},{"$f":"SUM(F7*B3)","v":0},{"$f":"SUM(G7*B3)","v":0},{"$f":"SUM(H7*B3)","v":0},{"$f":"SUM(I7*B3)","v":0},{"$f":"SUM(J7*B3)","v":0},{"$f":"SUM(K7*B3)","v":0},{"$f":"SUM(L7*B3)","v":0},{"$f":"SUM(M7*B3)","v":0},{"$f":"SUM(N7*B3)","v":0},{"$f":"SUM(O7*B3)","v":0},{"$f":"SUM(P7*B3)","v":0}]
[null,{"$f":"SUM(B6/60)*B8","v":0},{"$f":"SUM(C6/60)*C8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["FOI"]
[null,{"$f":"SUM(B10*B3)","v":0},{"$f":"SUM(C10*B3)","v":0},{"$f":"SUM(D10*B3)","v":0},{"$f":"SUM(E10*B3)","v":0},{"$f":"SUM(F10*B3)","v":0},{"$f":"SUM(G10*B3)","v":0},{"$f":"SUM(H10*B3)","v":0},{"$f":"SUM(I10*B3)","v":0},{"$f":"SUM(J10*B3)","v":0},{"$f":"SUM(K10*B3)","v":0},{"$f":"SUM(L10*B3)","v":0},{"$f":"SUM(M10*B3)","v":0},{"$f":"SUM(N10*B3)","v":0},{"$f":"SUM(O10*B3)","v":0},{"$f":"SUM(P10*B3)","v":0}]
[null,{"$f":"SUM(B6/60)*B11","v":0},{"$f":"SUM(C6/60)*C11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["DPA"]
[null,{"$f":"SUM(B13*B6)","v":0},{"$f":"SUM(C13*B6)","v":0},{"$f":"SUM(D13*B6)","v":0},{"$f":"SUM(E13*B6)","v":0},{"$f":"SUM(F13*B6)","v":0},{"$f":"SUM(G13*B6)","v":0},{"$f":"SUM(H13*B6)","v":0},{"$f":"SUM(I13*B6)","v":0},{"$f":"SUM(J13*B6)","v":0},{"$f":"SUM(K13*B6)","v":0},{"$f":"SUM(L13*B6)","v":0},{"$f":"SUM(M13*B6)","v":0},{"$f":"SUM(N13*B6)","v":0},{"$f":"SUM(O13*B6)","v":0},{"$f":"SUM(P13*B6)","v":0}]
[null,{"$f":"SUM(B6/60)*B14","v":0},{"$f":"SUM(C6/60)*C14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"SUM(B16*B3)","v":0},{"$f":"SUM(C16*B3)","v":0},{"$f":"SUM(D16*B3)","v":0},{"$f":"SUM(E16*B3)","v":0},{"$f":"SUM(F16*B3)","v":0},{"$f":"SUM(G16*B3)","v":0},{"$f":"SUM(H16*B3)","v":0},{"$f":"SUM(I16*B3)","v":0},{"$f":"SUM(J16*B3)","v":0},{"$f":"SUM(K16*B3)","v":0},{"$f":"SUM(L16*B3)","v":0},{"$f":"SUM(M16*B3)","v":0},{"$f":"SUM(N16*B3)","v":0},{"$f":"SUM(O16*B3)","v":0},{"$f":"SUM(P16*B3)","v":0}]
[null,{"$f":"SUM(B6/60)*B17","v":0},{"$f":"SUM(C6/60)*C17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"SUM(B19*B3)","v":0},{"$f":"SUM(C19*B3)","v":0},{"$f":"SUM(D19*B3)","v":0},{"$f":"SUM(E19*B3)","v":0},{"$f":"SUM(F19*B3)","v":0},{"$f":"SUM(G19*B3)","v":0},{"$f":"SUM(H19*B3)","v":0},{"$f":"SUM(I19*B3)","v":0},{"$f":"SUM(J19*B3)","v":0},{"$f":"SUM(K19*B3)","v":0},{"$f":"SUM(L19*B3)","v":0},{"$f":"SUM(M19*B3)","v":0},{"$f":"SUM(N19*B3)","v":0},{"$f":"SUM(O19*B3)","v":0},{"$f":"SUM(P19*B3)","v":0}]
[null,{"$f":"SUM(B6/60)*B20","v":0},{"$f":"SUM(C6/60)*C20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"SUM(B22*B3)","v":0},{"$f":"SUM(C22*B3)","v":0},{"$f":"SUM(D22*B3)","v":0},{"$f":"SUM(E22*B3)","v":0},{"$f":"SUM(F22*B3)","v":0},{"$f":"SUM(G22*B3)","v":0},{"$f":"SUM(H22*B3)","v":0},{"$f":"SUM(I22*B3)","v":0},{"$f":"SUM(J22*B3)","v":0},{"$f":"SUM(K22*B3)","v":0},{"$f":"SUM(L22*B3)","v":0},{"$f":"SUM(M22*B3)","v":0},{"$f":"SUM(N22*B3)","v":0},{"$f":"SUM(O22*B3)","v":0},{"$f":"SUM(P22*B3)","v":0}]
[null,{"$f":"SUM(B6/60)*B23","v":0},{"$f":"SUM(C6/60)*C23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Officer non chargeable Cost",{"$f":"SUM(B9+B12+B15+B18+B21+B24)","v":0},0,0,0,0,0,0,{"$f":"SUM(I9+I12+I15+I18+I21+I24)","v":0},0,0,0,0,0,0,0]
[]
["Total Charges for time",{"$f":"SUM(B25:P25)","v":0}]
[]
[]
["Table 2 - Specific Costs"]
["Type of Charge","£"]
["Out of hours work (unlicensed only)"]
[]
[]
["Total Specific Costs",{"$f":"SUM(B32:B34)","v":0}]
[]
["Total Non-Chargeable Costs",{"$f":"SUM(B27+B35)","v":0}]

{"sheet":"Materials","index":5,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,3],[0,4,0,5]]}
["Badge"]
["Material ","Unit Cost","Material ","Unit Cost","Material","Unit Cost"]
["Card"]
["Holder"]
["Lanyard"]
["Delivery"]
[]
[]
["Total",{"$f":"SUM(B3:B5)","v":0},"Total",{"$f":"SUM(D3:D5)","v":0},"Total",{"$f":"SUM(F3:F8)","v":0}]

{"sheet":"New","index":6,"n_rows":71,"n_cols":10,"rows_kept":71,"cut":false,"hidden":false,"merged":[[28,0,29,0],[16,0,17,0],[12,0,13,0],[14,0,15,0],[26,0,27,0],[24,0,25,0],[0,0,0,9],[3,1,3,7],[22,0,23,0],[4,0,5,0],[10,0,11,0],[6,0,7,0],[8,0,9,0],[18,0,19,0],[20,0,21,0],[30,0,31,0],[46,0,47,0],[34,0,35,0],[36,0,37,0],[38,0,39,0],[40,0,41,0],[42,0,43,0],[32,0,33,0],[62,0,63,0],[58,0,59,0],[50,0,51,0],[44,0,45,0],[60,0,61,0],[54,0,55,0],[56,0,57,0],[52,0,53,0],[48,0,49,0]]}
["Drivers"]
["Post Title",{"$f":"'Cost Summary'!A4","v":0},{"$f":"'Cost Summary'!A5","v":0},{"$f":"'Cost Summary'!A6","v":0},{"$f":"'Cost Summary'!A7","v":0},{"$f":"'Cost Summary'!A8","v":0},{"$f":"'Cost Summary'!A9","v":0},{"$f":"'Cost Summary'!A10","v":0},"Materials Cost / Other charges","Totals"]
["Hourly Rate",{"$f":"'Cost Summary'!F40","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F41","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F42","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F43","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F44","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F45","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F46","v":{"$error":"#DIV/0!"}}]
[null,"New"]
["Application Process"]
[]
["Receipt of application form"]
[null,{"$f":"SUM(B3/60)*B7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B8:H8)","v":{"$error":"#DIV/0!"}}]
["Check application form and associated documents and deal with any issues"]
[null,{"$f":"SUM(B3/60)*B9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B10:H10)","v":{"$error":"#DIV/0!"}}]
["Receipt of application fee"]
[null,{"$f":"SUM(B3/60)*B11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B12:H12)","v":{"$error":"#DIV/0!"}}]
["Issue Receipt"]
[null,{"$f":"SUM(B3/60)*B13","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B14:H14)","v":{"$error":"#DIV/0!"}}]
["Record created on computer system"]
[null,{"$f":"SUM(B3/60)*B15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B16:H16)","v":{"$error":"#DIV/0!"}}]
["DBS completed and sent"]
[null,{"$f":"SUM(B3/60)*B17","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B18:H18)","v":{"$error":"#DIV/0!"}}]
["DVLA Mandate Sent"]
[null,{"$f":"SUM(B3/60)*B19","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C3/60)*C19","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B20:I20)","v":{"$error":"#DIV/0!"}}]
["File created and filed/stored"]
[null,{"$f":"SUM(B3/60)*B21","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B22:H22)","v":{"$error":"#DIV/0!"}}]
["Receipt of DBS"]
[null,{"$f":"SUM(B3/60*B23)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B24:H24)","v":{"$error":"#DIV/0!"}}]
["Receipt of DVLA Mandate"]
[null,{"$f":"SUM(B3/60*B25)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C3/60*C25)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B26:H26)","v":{"$error":"#DIV/0!"}}]
["Verify application criteria met"]
[null,{"$f":"SUM(B3/60)*B27","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C3/60)*C27","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B28:H28)","v":{"$error":"#DIV/0!"}}]
["Record updated on computer system / file"]
[null,{"$f":"SUM(B3/60)*B29","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B30:H30)","v":{"$error":"#DIV/0!"}}]
["Discuss DBS content with applicant (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B31","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C3/60)*C31","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B32:H32)","v":{"$error":"#DIV/0!"}}]
["Liaise with Police (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B33","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B34:H34)","v":{"$error":"#DIV/0!"}}]
["Refer for management decision (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B35","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C3/60)*C35","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B36:H36)","v":{"$error":"#DIV/0!"}}]
["Committee date arranged (time per task multiplied by no. referred to committee divided by total number of applications)   "]
[null,{"$f":"SUM(B3/60)*B37","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B38:H38)","v":{"$error":"#DIV/0!"}}]
["Letter sent to applicant informing of committee date (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B39","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B40:I40)","v":{"$error":"#DIV/0!"}}]
["Committee report produced (time per task multiplied by no. referred to committee divided by total number of applications) "]
[null,{"$f":"SUM(B3/60)*B41","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B42:H42)","v":{"$error":"#DIV/0!"}}]
["Committee report verfied (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B43","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B44:H44)","v":{"$error":"#DIV/0!"}}]
["Committee preparation (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B45","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C3/60)*C45","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B46:H46)","v":{"$error":"#DIV/0!"}}]
["Attend Committee (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B47","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B48:H48)","v":{"$error":"#DIV/0!"}}]
["Notify applicant in writing of decision of Committee (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B49","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B50:H50)","v":{"$error":"#DIV/0!"}}]
["Computer system updated"]
[null,{"$f":"SUM(B3/60)*B51","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B52:H52)","v":{"$error":"#DIV/0!"}}]
["Licence produced"]
[null,{"$f":"SUM(B3/60)*B53","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B54:H54)","v":{"$error":"#DIV/0!"}}]
["Licence authorised and signed"]
[null,{"$f":"SUM(B3/60)*B55","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B56:H56)","v":{"$error":"#DIV/0!"}}]
["Badge created"]
[null,{"$f":"SUM(B3/60)*B57","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B58:I58)","v":{"$error":"#DIV/0!"}}]
["badge and Licence signed for by applicant / posted - conditions explained"]
[null,{"$f":"SUM(B3/60)*B59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B60:H60)","v":{"$error":"#DIV/0!"}}]
["File updated and filed/stored"]
[null,{"$f":"SUM(B3/60)*B61","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B62:H62)","v":{"$error":"#DIV/0!"}}]
["Total Other Charges (from other charges worksheet)"]
[null,null,null,null,null,null,null,null,null,{"$f":"I64","v":0}]
[null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(J7:J64)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Renewal","index":7,"n_rows":69,"n_cols":10,"rows_kept":69,"cut":false,"hidden":false,"merged":[[24,0,25,0],[42,0,43,0],[12,0,13,0],[26,0,27,0],[16,0,17,0],[28,0,29,0],[50,0,51,0],[0,0,0,9],[6,0,7,0],[8,0,9,0],[10,0,11,0],[4,1,4,7],[3,0,3,9],[4,0,5,0],[44,0,45,0],[32,0,33,0],[30,0,31,0],[40,0,41,0],[14,0,15,0],[18,0,19,0],[20,0,21,0],[22,0,23,0],[46,0,47,0],[34,0,35,0],[36,0,37,0],[38,0,39,0],[48,0,49,0],[66,0,67,0],[52,0,53,0],[64,0,65,0],[56,0,57,0],[58,0,59,0],[60,0,61,0],[62,0,63,0],[54,0,55,0]]}
["Drivers"]
["Post Title",{"$f":"'Cost Summary'!A4","v":0},{"$f":"'Cost Summary'!A5","v":0},{"$f":"'Cost Summary'!A6","v":0},{"$f":"'Cost Summary'!A7","v":0},{"$f":"'Cost Summary'!A8","v":0},{"$f":"'Cost Summary'!A9","v":0},{"$f":"'Cost Summary'!A10","v":0},"Materials Cost / Other charges","Totals"]
["Hourly Rate",{"$f":"'Cost Summary'!F40","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F41","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F42","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F43","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F44","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F45","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F46","v":{"$error":"#DIV/0!"}}]
["Renewal"]
["Application Process"]
[]
["DBS list generated",null,null,null,null,null,null,"  "]
[null,{"$f":"SUM(B3/60)*B7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B8:H8)","v":{"$error":"#DIV/0!"}}]
["DBS renewal letter sent"]
[null,{"$f":"SUM(B3/60)*B9","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C3/60)*C9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B10:H10)","v":{"$error":"#DIV/0!"}}]
["Medical list generated"]
[null,{"$f":"SUM(B3/60)*B11","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C3/60)*C11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B12:H12)","v":{"$error":"#DIV/0!"}}]
["Medical letter sent"]
[null,{"$f":"SUM(B3/60)*B13","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C3/60)*C13","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B14:H14)","v":{"$error":"#DIV/0!"}}]
["Generate Renewal list"]
[null,{"$f":"SUM(B3/60)*B15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B16:H16)","v":{"$error":"#DIV/0!"}}]
["Generate Reminder letter"]
[null,{"$f":"SUM(B3/60)*B17","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B18:H18)","v":{"$error":"#DIV/0!"}}]
["Collate application forms & packs to be included"]
[null,{"$f":"SUM(B3/60)*B19","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B20:H20)","v":{"$error":"#DIV/0!"}}]
["Send letter and packs"]
[null,{"$f":"SUM(B3/60)*B21","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B22:H22)","v":{"$error":"#DIV/0!"}}]
["Receipt of form"]
[null,{"$f":"SUM(B3/60)*B23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B24:H24)","v":{"$error":"#DIV/0!"}}]
["Check application form and associated documents and deal with any issues"]
[null,{"$f":"SUM(B3/60)*B25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B26:H26)","v":{"$error":"#DIV/0!"}}]
["Receipt of application fee"]
[null,{"$f":"SUM(B3/60)*B27","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B28:H28)","v":{"$error":"#DIV/0!"}}]
["Issue Receipt"]
[null,{"$f":"SUM(B3/60)*B29","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B30:H30)","v":{"$error":"#DIV/0!"}}]
["Record updated on computer system"]
[null,{"$f":"SUM(B3/60)*B31","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B32:H32)","v":{"$error":"#DIV/0!"}}]
["DBS completed and sent (time per task divide by number of years task completed)"]
[null,{"$f":"SUM(B3/60)*B33","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B34:H34)","v":{"$error":"#DIV/0!"}}]
["Receipt of DBS  (time per task divide by number of years task completed)"]
[null,{"$f":"SUM(B3/60)*B35","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B36:H36)","v":{"$error":"#DIV/0!"}}]
["Record updated on computer system / file"]
[null,{"$f":"SUM(B3/60)*B37","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B38:H38)","v":{"$error":"#DIV/0!"}}]
["Discuss DBS content with applicant (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B39","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B40:H40)","v":{"$error":"#DIV/0!"}}]
["Liaise with Police (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B41","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B42:H42)","v":{"$error":"#DIV/0!"}}]
["Refer for management decision (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B43","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B44:H44)","v":{"$error":"#DIV/0!"}}]
["Committee date arranged (time per task multiplied by no. referred to committee divided by total number of applications)   "]
[null,{"$f":"SUM(B3/60)*B45","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B46:H46)","v":{"$error":"#DIV/0!"}}]
["Letter sent to applicant informing of committee date (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B47","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B48:H48)","v":{"$error":"#DIV/0!"}}]
["Committee report produced (time per task multiplied by no. referred to committee divided by total number of applications) "]
[null,{"$f":"SUM(B3/60)*B49","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C3/60)*C49","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B50:H50)","v":{"$error":"#DIV/0!"}}]
["Committee report verfied (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B51","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C3/60)*C51","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B52:H52)","v":{"$error":"#DIV/0!"}}]
["Committee preparation (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B53","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C3/60)*C53","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B54:H54)","v":{"$error":"#DIV/0!"}}]
["Attend Committee (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B55","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B56:H56)","v":{"$error":"#DIV/0!"}}]
["Notify applicant in writing of decision of Committee (time per task multiplied by no. referred to committee divided by total number of applications)"]
[null,{"$f":"SUM(B3/60)*B57","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C3/60)*C57","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B58:H58)","v":{"$error":"#DIV/0!"}}]
["Record updated on computer system"]
[null,{"$f":"SUM(B3/60)*B59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B60:H60)","v":{"$error":"#DIV/0!"}}]
["Licence and badge created"]
[null,{"$f":"SUM(B3/60)*B61","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B62:I62)","v":{"$error":"#DIV/0!"}}]
["Licence authorised and signed "]
[null,{"$f":"SUM(B3/60)*B63","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B64:H64)","v":{"$error":"#DIV/0!"}}]
["file stored"]
[null,{"$f":"SUM(B3/60)*B65","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B66:H66)","v":{"$error":"#DIV/0!"}}]
["Total Other Charges (from other charges worksheet)"]
[null,null,null,null,null,null,null,null,null,{"$f":"I68","v":0}]
[null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(J7:J68)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Knowledge test","index":8,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,0,21,0],[0,0,0,9],[6,0,7,0],[8,0,9,0],[4,0,5,0],[3,0,3,9]]}
["Drivers"]
["Post Title",{"$f":"'Cost Summary'!A4","v":0},{"$f":"'Cost Summary'!A5","v":0},{"$f":"'Cost Summary'!A6","v":0},{"$f":"'Cost Summary'!A7","v":0},{"$f":"'Cost Summary'!A8","v":0},{"$f":"'Cost Summary'!A9","v":0},{"$f":"'Cost Summary'!A10","v":0},"Materials Cost / Other charges","Totals"]
["Hourly Rate",{"$f":"'Cost Summary'!F40","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F41","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F42","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F43","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F44","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F45","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F46","v":{"$error":"#DIV/0!"}}]
["Knowledge Test"]
["Application Process"]
[]
["Send information pack"]
[null,{"$f":"SUM(B3/60)*B7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B8:H8)","v":{"$error":"#DIV/0!"}}]
["Prepare Test"]
[null,{"$f":"SUM(B3/60)*B9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B10:H10)","v":{"$error":"#DIV/0!"}}]
["Receipt of application fee"]
[null,{"$f":"SUM(B3/60)*B11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B12:H12)","v":{"$error":"#DIV/0!"}}]
["Issue Receipt"]
[null,{"$f":"SUM(B3/60)*B13","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B14:H14)","v":{"$error":"#DIV/0!"}}]
["Conduct Test"]
[null,{"$f":"SUM(B3/60)*B15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B16:H16)","v":{"$error":"#DIV/0!"}}]
["Mark Test"]
[null,{"$f":"SUM(B3/60)*B17","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B18:H18)","v":{"$error":"#DIV/0!"}}]
["Decision letter / certificate sent"]
[null,{"$f":"SUM(B3/60)*B19","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B20:H20)","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"SUM(B3/60*B21)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B22:H22)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(J8,J10,J12,J14,J16,J18,J20,J22)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Basic English Test","index":9,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,0,21,0],[12,0,13,0],[14,0,15,0],[16,0,17,0],[0,0,0,9],[6,0,7,0],[8,0,9,0],[10,0,11,0],[18,0,19,0],[4,0,5,0],[3,0,3,9]]}
[" "]
["Post Title",{"$f":"'Cost Summary'!A4","v":0},{"$f":"'Cost Summary'!A5","v":0},{"$f":"'Cost Summary'!A6","v":0},{"$f":"'Cost Summary'!A7","v":0},{"$f":"'Cost Summary'!A8","v":0},{"$f":"'Cost Summary'!A9","v":0},{"$f":"'Cost Summary'!A10","v":0},"Materials Cost / Other charges","Totals"]
["Hourly Rate",{"$f":"'Cost Summary'!F40","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F41","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F42","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F43","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F44","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F45","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F46","v":{"$error":"#DIV/0!"}}]
["Basic English Test"]
["Application Process"]
[]
["Prepare Test"]
[null,{"$f":"SUM(B3/60)*B7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B8:H8)","v":{"$error":"#DIV/0!"}}]
["Receipt of application fee"]
[null,{"$f":"SUM(B3/60)*B9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B10:H10)","v":{"$error":"#DIV/0!"}}]
["Issue Receipt"]
[null,{"$f":"SUM(B3/60)*B11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B12:H12)","v":{"$error":"#DIV/0!"}}]
["Conduct Test"]
[null,{"$f":"SUM(B3/60)*B13","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B14:H14)","v":{"$error":"#DIV/0!"}}]
["Mark Test"]
[null,{"$f":"SUM(B3/60)*B15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B16:H16)","v":{"$error":"#DIV/0!"}}]
["Decision letter / certificate sent"]
[null,{"$f":"SUM(B3/60)*B17","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B18:H18)","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"SUM(B3/60)*B19","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B20:H20)","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"SUM(B3/60*B21)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B22:H22)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(J8,J10,J12,J14,J16,J18,J20,J22)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Replacement Licence","index":10,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,0,21,0],[12,0,13,0],[14,0,15,0],[16,0,17,0],[0,0,0,9],[6,0,7,0],[8,0,9,0],[10,0,11,0],[18,0,19,0],[4,0,5,0],[3,0,3,9]]}
["Drivers"]
["Post Title",{"$f":"'Cost Summary'!A4","v":0},{"$f":"'Cost Summary'!A5","v":0},{"$f":"'Cost Summary'!A6","v":0},{"$f":"'Cost Summary'!A7","v":0},{"$f":"'Cost Summary'!A8","v":0},{"$f":"'Cost Summary'!A9","v":0},{"$f":"'Cost Summary'!A10","v":0},"Materials Cost / Other charges","Totals"]
["Hourly Rate",{"$f":"'Cost Summary'!F40","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F41","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F42","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F43","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F44","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F45","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F46","v":{"$error":"#DIV/0!"}}]
["Replacement Licence"]
["Application Process"]
[]
["Notification received"]
[null,{"$f":"SUM(B3/60)*B7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B8:H8)","v":{"$error":"#DIV/0!"}}]
["Receipt of fee"]
[null,{"$f":"SUM(B3/60)*B9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B10:H10)","v":{"$error":"#DIV/0!"}}]
["Issue receipt"]
[null,{"$f":"SUM(B3/60)*B11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B12:H12)","v":{"$error":"#DIV/0!"}}]
["Computer System updated"]
[null,{"$f":"SUM(B3/60)*B13","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B14:H14)","v":{"$error":"#DIV/0!"}}]
["New Licence Produced"]
[null,{"$f":"SUM(B3/60)*B15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B16:H16)","v":{"$error":"#DIV/0!"}}]
["File Updated"]
[null,{"$f":"SUM(B3/60)*B17","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B18:H18)","v":{"$error":"#DIV/0!"}}]
["New Licence Sent/Collected"]
[null,{"$f":"SUM(B3/60)*B19","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B20:H20)","v":{"$error":"#DIV/0!"}}]
["File returned in system"]
[null,{"$f":"SUM(B3/60*B21)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B22:H22)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(J8,J10,J12,J14,J16,J18,J20,J22)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Change of Address","index":11,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,0,21,0],[12,0,13,0],[14,0,15,0],[16,0,17,0],[0,0,0,9],[6,0,7,0],[8,0,9,0],[10,0,11,0],[18,0,19,0],[4,0,5,0],[3,0,3,9]]}
["Drivers"]
["Post Title",{"$f":"'Cost Summary'!A4","v":0},{"$f":"'Cost Summary'!A5","v":0},{"$f":"'Cost Summary'!A6","v":0},{"$f":"'Cost Summary'!A7","v":0},{"$f":"'Cost Summary'!A8","v":0},{"$f":"'Cost Summary'!A9","v":0},{"$f":"'Cost Summary'!A10","v":0},"Materials Cost / Other charges","Totals"]
["Hourly Rate",{"$f":"'Cost Summary'!F40","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F41","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F42","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F43","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F44","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F45","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F46","v":{"$error":"#DIV/0!"}}]
["Change Of Address"]
["Application Process"]
[]
["Notification received"]
[null,{"$f":"SUM(B3/60)*B7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B8:H8)","v":{"$error":"#DIV/0!"}}]
["Receipt of fee"]
[null,{"$f":"SUM(B3/60)*B9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B10:H10)","v":{"$error":"#DIV/0!"}}]
["Issue receipt"]
[null,{"$f":"SUM(B3/60)*B11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B12:H12)","v":{"$error":"#DIV/0!"}}]
["Computer System updated"]
[null,{"$f":"SUM(B3/60)*B13","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B14:H14)","v":{"$error":"#DIV/0!"}}]
["New Licence Produced"]
[null,{"$f":"SUM(B3/60)*B15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B16:H16)","v":{"$error":"#DIV/0!"}}]
["File Updated"]
[null,{"$f":"SUM(B3/60)*B17","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B18:H18)","v":{"$error":"#DIV/0!"}}]
["Licence Sent/Collected"]
[null,{"$f":"SUM(B3/60)*B19","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B20:H20)","v":{"$error":"#DIV/0!"}}]
["File returned in system"]
[null,{"$f":"SUM(B3/60*B21)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B22:H22)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(J8,J10,J12,J14,J16,J18,J20,J22)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Replacement Badge","index":12,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,0,21,0],[12,0,13,0],[14,0,15,0],[16,0,17,0],[0,0,0,9],[6,0,7,0],[8,0,9,0],[10,0,11,0],[18,0,19,0],[4,0,5,0],[3,0,3,9]]}
["Drivers"]
["Post Title",{"$f":"'Cost Summary'!A4","v":0},{"$f":"'Cost Summary'!A5","v":0},{"$f":"'Cost Summary'!A6","v":0},{"$f":"'Cost Summary'!A7","v":0},{"$f":"'Cost Summary'!A8","v":0},{"$f":"'Cost Summary'!A9","v":0},{"$f":"'Cost Summary'!A10","v":0},"Materials Cost / Other charges","Totals"]
["Hourly Rate",{"$f":"'Cost Summary'!F40","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F41","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F42","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F43","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F44","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F45","v":{"$error":"#DIV/0!"}},{"$f":"'Cost Summary'!F46","v":{"$error":"#DIV/0!"}}]
["Replacement Badge"]
["Application Process"]
[]
["Notification received"]
[null,{"$f":"SUM(B3/60)*B7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B8:H8)","v":{"$error":"#DIV/0!"}}]
["Receipt of fee and photos"]
[null,{"$f":"SUM(B3/60)*B9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B10:H10)","v":{"$error":"#DIV/0!"}}]
["Issue receipt"]
[null,{"$f":"SUM(B3/60)*B11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B12:H12)","v":{"$error":"#DIV/0!"}}]
["Computer System updated"]
[null,{"$f":"SUM(B3/60)*B13","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B14:H14)","v":{"$error":"#DIV/0!"}}]
["New badge Produced"]
[null,{"$f":"SUM(B3/60)*B15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B16:H16)","v":{"$error":"#DIV/0!"}}]
["File Updated"]
[null,{"$f":"SUM(B3/60)*B17","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B18:H18)","v":{"$error":"#DIV/0!"}}]
["Badge Collected / Sent"]
[null,{"$f":"SUM(B3/60)*B19","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B20:H20)","v":{"$error":"#DIV/0!"}}]
["File returned in system"]
[null,{"$f":"SUM(B3/60*B21)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(B22:H22)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(J8,J10,J12,J14,J16,J18,J20,J22)","v":{"$error":"#DIV/0!"}}]