{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Expenses Form","Data","Receipts","Validation","Import","Ls_XLB_WorkbookFile","Ls_AgXLB_WorkbookFile"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":85,"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":167,"n_cols":6,"rows_kept":167,"cut":false,"hidden":false,"merged":[[166,1,167,21],[17,1,17,3],[13,1,13,6],[104,3,106,21],[108,3,109,21],[82,3,83,21],[88,3,90,21],[92,3,93,21],[85,3,86,21],[98,3,99,21],[62,1,63,21],[67,3,68,21],[71,3,73,21],[75,3,76,21],[79,1,80,21],[153,1,154,21],[1,1,1,21],[42,1,43,21],[33,1,34,21],[50,3,50,21],[56,3,57,21],[5,1,5,4],[6,1,6,4],[7,1,7,3],[8,1,8,3],[9,1,9,2],[10,1,10,2],[11,1,11,3],[12,1,12,3],[14,1,14,3],[16,1,16,3],[15,1,15,3],[156,1,157,21],[160,1,161,21],[163,1,164,21],[120,3,121,21],[129,3,130,21],[138,1,139,21],[143,1,144,21],[149,1,151,21],[146,1,147,21],[141,1,141,21]]}
[]
[null,"NSPCC Volunteers - How to complete your expense claim form"]
[]
[null,"Contents"]
[]
[null,"Before you start - enable macros"]
[null,"Ensuring your expenses are valid"]
[null,"Preparing your receipts"]
[null,"Completing your form"]
[null,"About you"]
[null,"Coding"]
[null,"A. Non-Travel Expenses"]
[null,"B. Subsistence Expenses"]
[null,"C. Taxis, tubes and other non-mileage journey expenses"]
[null,"Additional Comments / Notes"]
[null,"D. Mileage expenses"]
[null,"Submitting your expense claim"]
[null,"Payment of your claim"]
[]
[null,"Before you start - enable macros"]
[null,"When opening this form ensure that Macros have been enabled so that you can make use of the buttons and automated checking in the system. "]
[null,"If you have not enabled macros, close the form and open it again, then select enable content on the yellow bar at the top of the screen as shown below: "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ensuring your expenses are valid"]
[null,"Familiarise yourself with the NSPCC expenses policy and ensure that the items you are claiming do not breach the type or value limit of the expenses which you are allowed to claim. If you are unsure whether certain expenses are permitted, contact the NPU or your Volunteer Contact. "]
[]
[null,"The NSPCC expenses policy can be found on First Stop at the following link. If you do not have access to the intranet please contact your Volunteer Contact for assistance. "]
[null,"http://firststop.net.nspcc.org.uk/WorkingHere/FinancePurchasing/Expenses/EmployeeExpenseClaimProcedures_fga9555.html"]
[]
[null,"Preparing your receipts"]
[null,"Ensure that you have receipts to support the expenses that you are claiming. "]
[null,"Number your receipts according to the expense claim section and line number to which they relate e.g. A1, B3 etc. "]
[null,"If you have access to a scanner, take a scanned copy of your receipts to send to NPU and retain the originals yourself. "]
[null,"If you do not have access to a scanner, send the original receipts to NPU, attached to the Receipts form which will be automatically printed when you submit your expense claim form. You may wish to keep copies of the receipts for your own records. "]
[]
[]
[null,"Completing your form"]
[null,"The expenses claim form contains key information about you and the claim in the header, and is then split into four sections according to the type of expenses you are claiming. "]
[]
[null,"About you"]
[null,"Full Name",null,"Please enter your full name (rather than any nick name or shortened name)"]
[null,"Authoriser",null,"This is the name of the Budget Holder authorising your expense claim form"]
[null,"Address",null,"Complete the relevant address fields including Town and Postcode. These fields are mandatory except for Address Line 2. "]
[null,"Email Address",null,"Please complete your email address here to ensure that your remittance advice can be emailed directly to you, saving NSPCC the postage and printing costs"]
[null,"Submission Date",null,"This should be the date your form is submitted to your NSPCC Contact for authorisation. The expenses on your claim form must be prior to the submission date"]
[]
[null,"Coding"]
[null,"Cost Centre",null,"This is the code which is used to capture your expenses in the Finance System and attribute them to your team or department. Please ensure you use a valid cost centre, five characters long, beginning with an Alpha character. If you are not sure which cost centre you should use, contact your NSPCC Contact. "]
[]
[null,"Project Code",null,"If you are working on a specific project which has project costing associated with it, you can capture the project code here. If you are not working on a project of this nature, leave this field blank. "]
[null,"Appeal Code",null,"This code is used by Fundraising only to capture expenses relating to a particular appeal, event or campaign. If you do not want to attribute costs in this way, leave this field blank. "]
[null,"Services Code",null,"This code is used by CSDD to attribute expense claims to particular Services or Themes. If you are not required to attribute costs in this way, leave this field blank. "]
[]
[null,"If you enter your codes in the Header area, these will be applied to all expenses on the form. If you wish to enter different codes on each line then click on the \"Line level coding entry on/off\" button to toggle line level coding on. You should then leave the header fields blank, and enter the codes on each individual line instead. "]
[]
[]
[null,"A. Non-Travel Expenses"]
[null,"This section is for entering expenses which are not journey-related. For example, claiming for care of dependants. The following information should be provided on each line: "]
[null,"Date",null,"This is the date of incurring the expenses. Enter the date in the format dd/mm/yyyy, and ensure that the date is prior to the submission date. Any expenses claimed over 3 months old require sign off by the functional director for your division. "]
[]
[null,"Account Code",null,"Assign the correct account code for your expenditure which best describes the type of cost incurred. This enables accurate financial reporting and monitoring. "]
[null,"Description",null,"Provide a detailed description of the expenses incurred and why they were required, in order to demonstrate that they were valid business expenditure of the NSPCC"]
[null,"Receipt available?",null,"Select Scanned, Posted or Unavailable from the drop down list to indicate whether you have a receipt for this expenditure and whether you are able to send a scanned image to NSPCC or whether you will post the receipt. If you have access to a scanner please send scanned copies, as this reduces the amount of paper that has to be retained by NPU and keeps the receipts with the claims, saving administrative effort. "]
[]
[]
[null,"Receipt Amount",null,"Indicate the total amount of the expenses as per the receipt (this may be higher than the actual amount claimed, as there may be an upper limit in place under the policy)"]
[null,"Amount Claimed",null,"This is the amount of expenses you wish to claim in respect of that receipt item. The amount claimed should not be higher than the value on the receipt, but it may be lower, where there is an upper limit in place under the policy. "]
[]
[]
[null,"B. Subsistence Expenses"]
[null,"This section is for entering subsistence costs in relation to a journey you may have made. It will typically relate to the cost of meals, however by exception may include accomodation where this has been booked outside of the central contract. "]
[]
[]
[null,"Date",null,"This is the date of incurring the expenses. Enter the date in the format dd/mm/yyyy, and ensure that the date is prior to the submission date. Any expenses claimed over 3 months old require sign off by the functional director for your division. "]
[]
[null,"Account Code",null,"Assign the correct account code for your expenditure which best describes the type of cost incurred. This enables accurate financial reporting and monitoring. "]
[null,"Meal Type",null,"Indicate the type of meal which you are claiming for. This determines the maximum value of expenses which you may claim. If you are not claiming for a meal, select other, but ensure you explain the nature of the expenses in the description field. "]
[]
[null,"Description",null,"Provide a detailed description of the expenses incurred and why they were required, in order to demonstrate that they were valid business expenditure of the NSPCC"]
[null,"Receipt available?",null,"Select Scanned, Posted or Unavailable from the drop down list to indicate whether you have a receipt for this expenditure and whether you are able to send a scanned image to NSPCC or whether you will post the receipt. If you have access to a scanner please send scanned copies, as this reduces the amount of paper that has to be retained by NPU and keeps the receipts with the claims, saving administrative effort. "]
[]
[]
[null,"Receipt Amount",null,"Indicate the total amount of the expenses as per the receipt (this may be higher than the actual amount claimed, as there may be an upper limit in place under the policy)"]
[null,"Amount Claimed",null,"This is the amount of expenses you wish to claim in respect of that receipt item. The amount claimed should not be higher than the value on the receipt, but it may be lower, where there is an upper limit in place under the policy. "]
[]
[]
[null,"C. Taxis, tubes, parking and other non-mileage journey expenses"]
[null,"This section is for entering all journey-related costs which are not mileage claims. Ensure that you descibe the reason for the journey to demonstrate that it is valid business expenditure. "]
[]
[null,"Date",null,"This is the date of incurring the expenses. Enter the date in the format dd/mm/yyyy, and ensure that the date is prior to the submission date. Any expenses claimed over 3 months old require sign off by the functional director for your division. "]
[]
[null,"Account Code",null,"Assign the correct account code for your expenditure which best describes the type of cost incurred. This enables accurate financial reporting and monitoring. "]
[null,"From Location",null,"Indicate the starting point of your journey. If it is your home, write home and the actual location"]
[null,"To Location",null,"Indicate the end point of your journey. If it is your home, write home and the actual location"]
[null,"Reason for journey",null,"Provide a clear explanation of why you took the journey and demonstrate that it was a business journey. "]
[null,"Receipt available?",null,"Select Scanned, Posted or Unavailable from the drop down list to indicate whether you have a receipt for this expenditure and whether you are able to send a scanned image to NSPCC or whether you will post the receipt. If you have access to a scanner please send scanned copies, as this reduces the amount of paper that has to be retained by NPU and keeps the receipts with the claims, saving administrative effort. "]
[]
[]
[null,"Receipt Amount",null,"Indicate the total amount of the expenses as per the receipt (this may be higher than the actual amount claimed, as there may be an upper limit in place under the policy)"]
[null,"Amount Claimed",null,"This is the amount of expenses you wish to claim in respect of that receipt item. The amount claimed should not be higher than the value on the receipt, but it may be lower, where there is an upper limit in place under the policy. "]
[]
[]
[null,"Additional Comments / Notes"]
[null,"This section is for entering further information about unusual items on your claim or to explain why you are unable to provide receipts etc. "]
[]
[null,"D. Mileage expenses"]
[null,"This section is for entering mileage claims. "]
[null,"Repeat return journeys may be entered on one line if preferred. Please include number of return journeys made in the \"Reason for journey field\". For example, \"Return to ChildLine for shift x 5\". "]
[]
[null,"Mileage since 6 April",null,"Enter the number of miles you have claimed in this tax year. This impacts on the rate of mileage that you are allowed to claim. "]
[]
[null,"Date",null,"This is the date of incurring the expenses. Enter the date in the format dd/mm/yyyy, and ensure that the date is prior to the submission date. Any expenses claimed over 3 months old require sign off by the functional director for your division. "]
[]
[null,"Account Code",null,"Assign the correct account code for your expenditure which best describes the type of mileage incurred. This enables accurate financial reporting and monitoring. "]
[null,"From Location",null,"Indicate the starting point of your journey. If it is your home, write home and the actual location. "]
[null,"From Postcode",null,"Enter the postcode where you started your journey. This enables your claim to be reviewed for reasonableness and allows detailed reporting on journeys made by NSPCC staff. "]
[null,"To Location",null,"Indicate the end point of your journey. If it is your home, write home and the actual location"]
[null,"To Postcode",null,"Enter the postcode where you finished your journey. This enables your claim to be reviewed for reasonableness and allows detailed reporting on journeys made by NSPCC staff. "]
[null,"Reason for journey",null,"Provide a clear explanation of why you took the journey and demonstrate that it was a business journey. "]
[null,"Passenger carried?",null,"Indicate whether you were carrying a passenger (NSPCC staff or volunteer) who was also undertaking a business journey. You may claim an additional 5p per mile for shared transport. "]
[null,"No. Miles",null,"Enter the number of miles travelled. You should calculate this using an online tool - entering the relevant postcodes to ascertain the number of miles. Links to AA Routeplanner and RAC Routeplanner are provided on the form. "]
[]
[]
[null,"Volunteer Declaration",null,"Your expense claim acts as a self-certification document in which you are stating that you had the necessary valid documents for travel at the time of taking the journey"]
[null,null,null,"Drivers Licence",null,"Confirm that you have a valid drivers licence and enter the expiry date"]
[null,null,null,"MOT",null,"Confirm that you have a current MOT certificate and enter the expiry date. If your vehicle is under 3 years old or registered in Jersey, select N/A and leave expiry date blank"]
[null,null,null,"Insurance policy",null,"Confirm that you have insurance for business use that covers you when driving on NSPCC business. Speak to your insurance provider if you are unsure. "]
[]
[null,"Submitting your expense claim"]
[null,"When your claim has been correctly completed all cells on the form will revert to white (there should be no red highlighting on the form). If any cells are highlighted in red, this indicates an error in completing the form, review your entries and read the instructions to identify the issue. If you require help with this, contact the NPU Helpdesk. NPU are unable to pay incorrectly completed claims. "]
[]
[]
[null,"Email your completed claim to your Volunteer Contact. You can do this by attaching it to an email, along with scanned copies of your receipts. "]
[]
[null,"When your Volunteer Contact receives your form they should open and check it. Then click on the Submit Form button in the top right hand corner of the claim. This will save the file and attach it to an email. Remember to attach the scanned copies of the receipts before forwarding to the next authoriser or NPU as required. "]
[]
[]
[null,"NPU will not process any claims which have not been submitted using the SUBMIT FORM button. This is because the process of submitting the claim calculates a unique reference number to allow them to track your claim. It also ensures the form has been correctly completed, reducing the time taken to process the claim by preventing the submission of invalid data. "]
[]
[]
[null,"Your expense claim should be authorised first by your NSPCC Volunteer Contact , and then by the budget holder for the cost centres on the form (if they are a different person). Your contact should forward the claim to the budget holder stating \"Approved\" in the body of the email. The budget holder should then foward the email, showing the contact's authorisation and including the attached claim and receipts, to the NPU (npuhelpdesk@nspcc.org.uk) stating \"Approved\" in the body of the email. "]
[]
[]
[]
[null,"If any expenses on your form are over 3 months old, the claim will need to be signed off by the Functional Director or a Senior Management Team member for your division before it can be paid. The budget holder should forward the claim to this Director/SMT and they should then forward the claim on to NPU stating \"Approved\" in the body of the email. "]
[]
[]
[null,"By stating \"Approved\", NSPCC Volunteer Contacts, budget holders and Directors/SMT members are confirming that they have checked the receipts to the form, and are satisfied that the expenses claimed have been incurred for valid business purposes. "]
[]
[]
[null,"Payment of your claim"]
[null,"NPU will process your claim once they receive it from the relevant authoriser, provided it has been correctly completed and receipts have been provided. Please bear in mind that any error in completion of the form or delay in authorisation of the claim will cause a delay in payment, and you are responsible for following up with your NSPCC Contact/budget holder in the first instance. "]
[]
[]
[null,"Payment will be made on the next available payment run after your claim has been processed. If you have provided an email address, you will receive an electronic remittance advice notifying you that the claim has been paid, otherwise a remittance advice will be posted to you. You can provide an email address at the top of this form. "]
[]
[]
[null,"To help minimise processing costs, we prefer to reimburse expense claims by direct bank transfer rather than by cheque. Please email the National Processing Unit directly with your bank details (npuhelpdesk@nspcc.org.uk) or ask your NSPCC Volunteer Contact for a BACS form. "]

{"sheet":"Expenses Form","index":1,"n_rows":74,"n_cols":24,"rows_kept":74,"cut":false,"hidden":false,"merged":[[55,17,56,19],[55,1,60,3],[72,1,72,15],[53,1,53,13],[45,12,45,13],[64,9,64,15],[38,1,38,3],[73,1,73,15],[55,8,55,9],[67,1,67,15],[66,1,66,15],[69,1,69,15],[70,1,70,15],[59,8,60,12],[62,1,62,14],[57,8,57,13],[58,8,58,12],[55,12,55,13],[43,1,44,9],[45,1,45,3],[43,12,43,13],[42,8,42,15],[16,8,16,12],[9,1,9,2],[9,3,9,9],[9,11,9,12],[45,17,45,19],[23,9,23,12],[22,9,22,12],[17,8,17,12],[11,1,11,15],[43,10,43,11],[42,1,42,3],[36,1,36,13],[39,1,40,15],[26,9,26,12],[33,10,33,12],[38,8,38,15],[4,1,5,15],[34,10,34,12],[35,10,35,12],[9,14,9,15],[20,1,20,15],[31,10,31,12],[32,10,32,12],[25,9,25,12],[27,1,27,13],[12,8,12,12],[13,8,13,12],[14,8,14,12],[29,1,29,15],[21,9,21,12],[30,10,30,12],[15,8,15,12],[6,3,6,9],[24,9,24,12],[18,1,18,13],[1,1,1,13],[6,1,6,2],[7,1,7,2],[8,1,8,2],[6,11,6,12],[7,11,7,12],[8,11,8,12],[2,1,2,15],[7,3,7,9],[6,14,6,15],[7,14,7,15],[8,14,8,15],[8,3,8,9]]}
[]
[null,{"$f":"IF(Validation!$C$19>0,Validation!$B$59,IF($S$9=\"Late Submission\",Validation!$B$63,Validation!$B$61))","v":"INCOMPLETE SUBMISSION Please ensure you have completed all necessary cells. Incorrectly completed cells will be shown in red. We are unable to process incomplete claims, if you are having difficulties completing your claim please call NPU on 02920 108132."}]
[null,{"$f":"IF(Receipt_Form_Required>0, Validation!E67,Validation!E68)","v":"RECEIPTS Please attach your receipts to the email generated when you use the Submit Form button to send your claim. Originals of scanned receipts should be retained by the claimant, not sent through to the NPU."}]
[]
[null,"NSPCC VOLUNTEER EXPENSE CLAIM FORM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time stamp","2015-06-03T11:15:55","Cost Centre",{"$f":"IF(ISBLANK(O7), \"Multi-Code\", O7)","v":"Multi-Code"}]
[]
[null,"Full Name",null,null,null,null,null,null,null,null,"Authoriser",null,null,"Cost Centre",null,null,null,"Earliest Month Covered",{"$f":"MIN(C14:C18, C23:C27,C32:C36,C49:C53)","v":"00:00:00"},"Unavailable receipts",{"$f":"COUNTIF(N:N, \"Unavailable\")","v":0},"Trading Count",{"$f":"IF(ISBLANK(O7), COUNTIF(E:E, \"F*\"), IF(LEFT(O7, 1)=\"F\", 1, 0))","v":0}]
[null,"Home Address 1","Address Line 1",null,null,null,null,null,null,null,"Submission Date",null,null,"Project",null,null,null,"Latest Month Covered",{"$f":"MAX(C14:C18,C23:C27,C32:C36,C49:C53)","v":"00:00:00"},"Claimant Initials",{"$f":"IF(LEN(Claimant)-LEN(SUBSTITUTE(Claimant,\" \",\"\"))=0,LEFT(Claimant,1),IF(LEN(Claimant)-LEN(SUBSTITUTE(Claimant,\" \",\"\"))=1,LEFT(Claimant,1)&MID(Claimant,FIND(\" \",Claimant)+1,1),LEFT(Claimant,1)&MID(Claimant,FIND(\" \",Claimant)+1,1)&MID(Claimant,FIND(\" \",Claimant,FIND(\" \",Claimant)+1)+1,1)))","v":""},"Total Count",{"$f":"IF(ISBLANK(O7), COUNTA(E:E), 1)-4","v":0}]
[null,"Home Address 2","Address Line 2",null,null,null,null,null,null,null,"Home Town",null,null,"Appeal/Campaign",null,null,null,"Submission Type",{"$f":"IF(COUNTA(C14:C18,C23:C27,C32:C36,C49:C53)<1,\"\",IF($L$8=\"\",IF(TODAY()-MIN($C$14:$C$53)>92,\"Late Submission\",\"Submission Permitted\"),IF($L$8-MIN($C$14:$C$53)>92,\"Late Submission\",\"Submission Permitted\")))","v":""},"Supplier Code",{"$f":"\"CE00\"&J7","v":"CE00"},"Mixed BU",{"$f":"IF(W7>0, IF(W8>W7, TRUE,FALSE), FALSE)","v":false}]
[null,"Email Address","Email Address",null,null,null,null,null,null,null,"Home Post Code",null,null,"Service/Theme",null,null,null,"Today's date",{"$f":"TEXT(TODAY(),\" dd/mm/yyyy\")","v":" 06/08/2018"}]
[]
[null,"A. NON-TRAVEL EXPENSES (for Parking use section C)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of errors",{"$f":"Validation!C19+COUNTIF(X:X, FALSE)","v":8}]
[null,"Item","Date","Account Code","Cost Centre","Project","Appeal","Service/Theme","Description",null,null,null,null,"Receipt available?","Receipt Amount £","Amount Claimed £",null,"Transaction Reference",{"$f":"$U$8&\"-\"&TEXT(Time_Stamp, \"ddmmyy-hhmmss\")","v":"-030615-111555"},null,null,null,"Receipts","Test Limit"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N14=\"Unavailable\", TRUE, IF(P14>O14, FALSE, TRUE))","v":true},{"$f":"W14","v":true}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N15=\"Unavailable\", TRUE, IF(P15>O15, FALSE, TRUE))","v":true},{"$f":"W15","v":true}]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,{"$f":"W16","v":true}]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,{"$f":"W17","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N18=\"Unavailable\", TRUE, IF(P18>O18, FALSE, TRUE))","v":true},{"$f":"W18","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O14:O18)","v":0},{"$f":"SUM(P14:P18)","v":0}]
[]
[null,"B. SUBSISTENCE EXPENSES (Meal costs when travelling on NSPCC business)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test limits on meal time claims"]
[null,"Item","Date","Account Code","Cost Centre","Project","Appeal","Service/Theme","Meal Type","Description",null,null,null,"Receipt available?","Receipt Amount £","Amount Claimed £",null,"Breakfast - before 7am","Breakfast - overnight stay","Lunch - overnight stay","Dinner - overnight stay","Dinner - after 9pm","Receipts","Test Limit"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($I23=Data!$A$18,'Expenses Form'!$P23>Data!$B$18), FALSE, TRUE)","v":true},{"$f":"IF(AND($I23=Data!$A$19,'Expenses Form'!$P23>Data!$B$19), FALSE, TRUE)","v":true},{"$f":"IF(AND($I23=Data!$A$20,'Expenses Form'!$P23>Data!$B$20), FALSE, TRUE)","v":true},{"$f":"IF(AND($I23=Data!$A$21,'Expenses Form'!$P23>Data!$B$21), FALSE, TRUE)","v":true},{"$f":"IF(AND($I23=Data!$A$22,'Expenses Form'!$P23>Data!$B$22), FALSE, TRUE)","v":true},{"$f":"IF(N23=\"Unavailable\", TRUE, IF(P23>O23, FALSE, TRUE))","v":true},{"$f":"IF(OR($R23=FALSE,$S23=FALSE, $T23=FALSE, $U23=FALSE, $V23=FALSE, $W23=FALSE), FALSE, TRUE)","v":true}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($I24=Data!$A$18,'Expenses Form'!$P24>Data!$B$18), FALSE, TRUE)","v":true},{"$f":"IF(AND($I24=Data!$A$19,'Expenses Form'!$P24>Data!$B$19), FALSE, TRUE)","v":true},{"$f":"IF(AND($I24=Data!$A$20,'Expenses Form'!$P24>Data!$B$20), FALSE, TRUE)","v":true},{"$f":"IF(AND($I24=Data!$A$21,'Expenses Form'!$P24>Data!$B$21), FALSE, TRUE)","v":true},{"$f":"IF(AND($I24=Data!$A$22,'Expenses Form'!$P24>Data!$B$22), FALSE, TRUE)","v":true},{"$f":"IF(N24=\"Unavailable\", TRUE, IF(P24>O24, FALSE, TRUE))","v":true},{"$f":"IF(OR($R24=FALSE,$S24=FALSE, $T24=FALSE, $U24=FALSE, $V24=FALSE, $W24=FALSE), FALSE, TRUE)","v":true}]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($I25=Data!$A$18,'Expenses Form'!$P25>Data!$B$18), FALSE, TRUE)","v":true},{"$f":"IF(AND($I25=Data!$A$19,'Expenses Form'!$P25>Data!$B$19), FALSE, TRUE)","v":true},{"$f":"IF(AND($I25=Data!$A$20,'Expenses Form'!$P25>Data!$B$20), FALSE, TRUE)","v":true},{"$f":"IF(AND($I25=Data!$A$21,'Expenses Form'!$P25>Data!$B$21), FALSE, TRUE)","v":true},{"$f":"IF(AND($I25=Data!$A$22,'Expenses Form'!$P25>Data!$B$22), FALSE, TRUE)","v":true},true,{"$f":"IF(OR($R25=FALSE,$S25=FALSE, $T25=FALSE, $U25=FALSE, $V25=FALSE, $W25=FALSE), FALSE, TRUE)","v":true}]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($I26=Data!$A$18,'Expenses Form'!$P26>Data!$B$18), FALSE, TRUE)","v":true},{"$f":"IF(AND($I26=Data!$A$19,'Expenses Form'!$P26>Data!$B$19), FALSE, TRUE)","v":true},{"$f":"IF(AND($I26=Data!$A$20,'Expenses Form'!$P26>Data!$B$20), FALSE, TRUE)","v":true},{"$f":"IF(AND($I26=Data!$A$21,'Expenses Form'!$P26>Data!$B$21), FALSE, TRUE)","v":true},{"$f":"IF(AND($I26=Data!$A$22,'Expenses Form'!$P26>Data!$B$22), FALSE, TRUE)","v":true},true,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($I27=Data!$A$18,'Expenses Form'!$P27>Data!$B$18), FALSE, TRUE)","v":true},{"$f":"IF(AND($I27=Data!$A$19,'Expenses Form'!$P27>Data!$B$19), FALSE, TRUE)","v":true},{"$f":"IF(AND($I27=Data!$A$20,'Expenses Form'!$P27>Data!$B$20), FALSE, TRUE)","v":true},{"$f":"IF(AND($I27=Data!$A$21,'Expenses Form'!$P27>Data!$B$21), FALSE, TRUE)","v":true},{"$f":"IF(AND($I27=Data!$A$22,'Expenses Form'!$P27>Data!$B$22), FALSE, TRUE)","v":true},{"$f":"IF(N27=\"Unavailable\", TRUE, IF(P27>O27, FALSE, TRUE))","v":true},true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O23:O27)","v":0},{"$f":"SUM(P23:P27)","v":0}]
[]
[null,"C. TAXIS, TUBES PARKING AND OTHER NON-MILEAGE JOURNEY EXPENSES"]
[null,"Item","Date","Account Code","Cost Centre","Project","Appeal","Service/Theme","From Location","To Location","Reason for Journey",null,null,"Receipt available?","Receipt Amount £","Amount Claimed £",null,null,null,null,null,null,"Receipts","Test Limit"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N32=\"Unavailable\", TRUE, IF(P32>O32, FALSE, TRUE))","v":true},{"$f":"W32","v":true}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N33=\"Unavailable\", TRUE, IF(P33>O33, FALSE, TRUE))","v":true},{"$f":"W33","v":true}]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,{"$f":"W34","v":true}]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,{"$f":"W35","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N36=\"Unavailable\", TRUE, IF(P36>O36, FALSE, TRUE))","v":true},{"$f":"W36","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O32:O36)","v":0},{"$f":"SUM(P32:P36)","v":0}]
[]
[null,"ADDITIONAL COMMENTS / NOTES  ",null,null,null,null,null,null,"Please use this box to add any further information e.g. explain expenses outside of policy or lost receipts. Failure to provide this information will delay payment of your claim. "]
[]
[]
[]
[null,"D. MILEAGE EXPENSES",null,null,null,null,null,null,"Enter journey details below. Repeat return journeys may be entered on one line. Please use an appropriate description indicating the number of return journeys made. "]
[null,"Please complete the number of miles you travelled and indicate whether you carried a passenger on NSPCC business. Please enter the number of miles you have claimed since 6th April excluding this claim. ",null,null,null,null,null,null,null,null,"Rate per mile in pence",null,"Rate per mile in pence"]
[null,null,null,null,null,null,null,null,null,null,"Up to threshold",45,"Passenger mileage",5]
[null,"The form will calculate mileage at the rate shown. ",null,null,null,null,null,null,"Rate Threshold",10000,"Above threshold",25,"Mileage since 6th April excluding this claim","Total mileage claimed since 1st April excluding this claim",null,null,null,"Used in calculation of mileage for split rate purposes"]
[]
[null,"Item","Date","Account Code","Cost Centre","Project","Appeal","Service/Theme","From Location","From PostCode","To Location","To PostCode","Reason for Journey","Passenger carried?","No. Miles","Amount Claimed £",null,"Cumulative Mileage Ex","Cumulative Mileage Inc","Mileage Over Limit"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(IF(R49>$J$46,($L$46*O49/100)+IF(N49=\"Yes\", $N$45*O49/100, 0),IF(S49>$J$46,(T49*$L$46/100)+((O49-T49)*$L$45/100)+IF(N49=\"Yes\", $N$45*O49/100, 0),(O49*$L$45/100)+IF(N49=\"Yes\", $N$45*O49/100, 0))),2), \"\")","v":0},null,{"$f":"O46","v":0},{"$f":"O46+O49","v":0},{"$f":"IFERROR(IF(S49-$J$46>0, S49-$J$46, 0), 0)","v":0}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(IF(R50>$J$46,($L$46*O50/100)+IF(N50=\"Yes\", $N$45*O50/100, 0),IF(S50>$J$46,(T50*$L$46/100)+((O50-T50)*$L$45/100)+IF(N50=\"Yes\", $N$45*O50/100, 0),(O50*$L$45/100)+IF(N50=\"Yes\", $N$45*O50/100, 0))),2), \"\")","v":0},null,{"$f":"R49+O49","v":0},{"$f":"S49+O50","v":0},{"$f":"IFERROR(IF(S50-$J$46>0, S50-$J$46, 0), 0)","v":0}]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(IF(R51>$J$46,($L$46*O51/100)+IF(N51=\"Yes\", $N$45*O51/100, 0),IF(S51>$J$46,(T51*$L$46/100)+((O51-T51)*$L$45/100)+IF(N51=\"Yes\", $N$45*O51/100, 0),(O51*$L$45/100)+IF(N51=\"Yes\", $N$45*O51/100, 0))),2), \"\")","v":0},null,{"$f":"R50+O50","v":0},{"$f":"S50+O51","v":0},0]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(IF(R52>$J$46,($L$46*O52/100)+IF(N52=\"Yes\", $N$45*O52/100, 0),IF(S52>$J$46,(T52*$L$46/100)+((O52-T52)*$L$45/100)+IF(N52=\"Yes\", $N$45*O52/100, 0),(O52*$L$45/100)+IF(N52=\"Yes\", $N$45*O52/100, 0))),2), \"\")","v":0},null,{"$f":"R51+O51","v":0},{"$f":"S51+O52","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(R53>$J$46,($L$46*O53/100)+IF(N53=\"Yes\", $N$45*O53/100, 0),IF(S53>$J$46,(T53*$L$46/100)+((O53-T53)*$L$45/100)+IF(N53=\"Yes\", $N$45*O53/100, 0),(O53*$L$45/100)+IF(N53=\"Yes\", $N$45*O53/100, 0))), \"\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O49:O53)","v":0},{"$f":"SUM(P49:P53)","v":0}]
[]
[null,null,null,null,null,null,null,null,"Calculate your mileage using an online tool:",null,"RAC Route Planner","AA Route Planner","Mileage since 6th April carried forward to next claim","Total mileage claimed since 1st April excluding this claim",{"$f":"O46+O54","v":0}]
[]
[null,null,null,null,null,null,null,null,"NSPCC drivers using their own / leased vehicle on NSPCC business - Volunteer Declaration",null,null,null,null,null,"Valid","Expiry Date"]
[null,null,null,null,null,null,null,null,"I confirm that the following documents were valid and correct at the time of incurring the mileage expense",null,null,null,null,"Drivers Licence"]
[null,null,null,null,null,null,null,null,"If your vehicle is under 3 years old or registered in Jersey enter N/A next to MOT and leave expiry date blank. Please speak with your motor insurance provider to ensure that you are covered for driving on NSPCC business (business use cover or similar). ",null,null,null,null,"MOT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Insurance Policy"]
[]
[null,"Total expenses claimed on this form",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P54+P37+P28+P19","v":0}]
[]
[null,"AUTHORISATION INSTRUCTIONS & DECLARATIONS",null,null,null,null,null,null,null,"Check your claim states VALID SUBMISSION at the top, then email it to your Volunteer Contact who will SUBMIT it on your behalf"]
[]
[null,"NSPCC VOLUNTEER CONTACT"]
[null,"If you agree that the above expenses have been incurred for business purposes and comply with the NSPCC expenses policy, forward this claim to the relevant Budget Holder stating \"Approved\". "]
[]
[null,"BUDGET HOLDER"]
[null,{"$f":" \"If you agree that the above expenses have been incurred for business purposes and comply with the NSPCC expenses policy and where receipts have not been provided accept the reasons stated above,\"&\" \"&IF(S9=\"Late Submission\",Validation!B73,Validation!B75)","v":"If you agree that the above expenses have been incurred for business purposes and comply with the NSPCC expenses policy and where receipts have not been provided accept the reasons stated above, please forward this claim to the National Processing Unit at npuhelpdesk@nspcc.org.uk stating \"Approved\"."}]
[]
[null,"FUNCTIONAL DIRECTOR"]
[null,{"$f":"IF(S9=\"Late Submission\",Validation!B79,Validation!B81)","v":"FUNCTIONAL DIRECTOR/SMT APPROVAL NOT REQUIRED: No expenses on this form were incurred more than 3 months before the date of submission. "}]

{"sheet":"Data","index":2,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Validation & Lists used in expenses form"]
["Please note, the validation works using named ranges - these can be controlled through Name Manager - Control F3"]
[]
[]
["Car Allowances","Engine Size - used in Engine_Size",null,null,"Up to & Inc","Above","Passenger mileage"]
["Drop Down List","Drop Down List","Lookup concatenation for rate & threshold","Threshold","£ per mile","£ per mile"]
["Select_Option"]
["ECOP",null,{"$f":"A8&ECOP","v":"ECOP"},5000,0.28100000000000003,0.14699999999999999,0.05]
["ECUA",null,{"$f":"A9&ECUA","v":"ECUA"},10000,0.45,0.25,0.05]
["None",null,{"$f":"A10&None","v":"None"},10000,0.45,0.25,0.05]
["Regular_Car_User",null,{"$f":"A11&Regular_Car_User","v":"Regular_Car_User"},10000,0.45,0.25,0.05]
["Car_Payment","Petrol engine up to 1400cc",{"$f":"A12&B12","v":"Car_PaymentPetrol engine up to 1400cc"},"N/A",0.12,0.12,0.05]
["Car_Payment","Petrol engine 1401cc and over",{"$f":"A12&B13","v":"Car_PaymentPetrol engine 1401cc and over"},"N/A",0.14699999999999999,0.14699999999999999,0.05]
["Car_Payment","Diesel engine",{"$f":"A12&B14","v":"Car_PaymentDiesel engine"},"N/A",0.12,0.12,0.05]
[]
[]
["Meal Types"]
["Breakfast - before 7am",5]
["Breakfast - overnight stay",5]
["Meal - 4+ hours",5]
["Dinner - London overnight",15]
["Dinner - Non-London overnight",12]
[]
[]
["Receipt Indicator","MOT Indicator","Travel Codes","Yes/No","Mileage codes",null,null,null,null,null,null,null,null,"codes not included"]
["Scanned","Yes","2316 - Volunteers Travel ","Yes","2319 - Volunteers Mileage",null,null,null,null,null,null,null,null,"2326 - Relocation/Redep Mileage"]
["Posted","No","2318 - Volunteers Taxis ","No",null,null,null,null,null,null,null,null,null,"2325 - Reloc/Redeploy other travel"]
["Unavailable","N/A",null,null,null,null,null,null,null,null,null,null,null,"2324 - Relocation Moving Costs"]
[]
[]
[]
[]
[]
[]
[]
["Account Code Detail",null,"Subsistence Travel Codes"]
["2315 - Volunteers Expenses ",null,"2317 - Volunteers Hotel/Subst "]

{"sheet":"Receipts","index":3,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":true,"merged":[[44,0,44,3],[46,0,46,3],[20,0,20,3],[30,0,30,3],[40,0,40,3],[10,0,10,2],[10,3,10,4],[2,0,6,4],[0,0,1,4],[9,0,9,2],[7,3,7,4],[8,3,8,4],[9,3,9,4],[7,0,7,2],[8,0,8,2]]}
["NSPCC VOLUNTEER EXPENSES RECEIPTS FORM"]
[]
["Please post your receipts with this form to the National Processing Unit at NSPCC, Diane Engelhardt House, Unit 2, Treglow Court, Dowlais Road, Cardiff, CF24 5LQ. \n\nPlease ensure that you clearly mark each receipt with the relevant section letter and item number corresponding to each line below e.g. A1 "]
[]
[]
[]
[]
["Full Name",null,null,{"$f":"'Expenses Form'!D7","v":0}]
["Authoriser",null,"Address Line 1",{"$f":"'Expenses Form'!L7","v":0}]
["Claim Submission Date",null,"Address Line 2",{"$f":"'Expenses Form'!L8","v":"00:00:00"}]
["Transaction Reference Number",null,null,{"$f":"'Expenses Form'!S13","v":"-030615-111555"}]
[]
["A. NON-TRAVEL EXPENSES"]
[]
["Item","Date","Acceptable Receipt","Receipt Total","Amount Claimed £"]
[1,{"$f":"IF(ISBLANK('Expenses Form'!C14), \"\", 'Expenses Form'!C14)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!N14), \"\", 'Expenses Form'!N14)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!O14),\"\", 'Expenses Form'!O14)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!P14), \"\", 'Expenses Form'!P14)","v":""}]
[2,{"$f":"IF(ISBLANK('Expenses Form'!C15), \"\", 'Expenses Form'!C15)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!N15), \"\", 'Expenses Form'!N15)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!O15),\"\", 'Expenses Form'!O15)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!P15), \"\", 'Expenses Form'!P15)","v":""}]
[3,{"$f":"IF(ISBLANK('Expenses Form'!C16), \"\", 'Expenses Form'!C16)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!N16), \"\", 'Expenses Form'!N16)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!O16),\"\", 'Expenses Form'!O16)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!P16), \"\", 'Expenses Form'!P16)","v":""}]
[4,{"$f":"IF(ISBLANK('Expenses Form'!C17), \"\", 'Expenses Form'!C17)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!N17), \"\", 'Expenses Form'!N17)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!O17),\"\", 'Expenses Form'!O17)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!P17), \"\", 'Expenses Form'!P17)","v":""}]
[]
["Total Non-Travel Expenses Claimed",null,null,null,{"$f":"SUM(E16:E19)","v":0}]
[]
["B. SUBSISTENCE EXPENSES"]
[]
["Item","Date","Acceptable Receipt","Receipt Total","Amount Claimed £"]
[1,{"$f":"IF(ISBLANK('Expenses Form'!C23), \"\",'Expenses Form'!C23)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!N23), \"\", 'Expenses Form'!N23)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!O23), \"\", 'Expenses Form'!O23)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!P23), \"\", 'Expenses Form'!P23)","v":""}]
[2,{"$f":"IF(ISBLANK('Expenses Form'!C24), \"\",'Expenses Form'!C24)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!N24), \"\", 'Expenses Form'!N24)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!O24), \"\", 'Expenses Form'!O24)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!P24), \"\", 'Expenses Form'!P24)","v":""}]
[3,{"$f":"IF(ISBLANK('Expenses Form'!C25), \"\",'Expenses Form'!C25)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!N25), \"\", 'Expenses Form'!N25)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!O25), \"\", 'Expenses Form'!O25)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!P25), \"\", 'Expenses Form'!P25)","v":""}]
[4,{"$f":"IF(ISBLANK('Expenses Form'!C26), \"\",'Expenses Form'!C26)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!N26), \"\", 'Expenses Form'!N26)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!O26), \"\", 'Expenses Form'!O26)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!P26), \"\", 'Expenses Form'!P26)","v":""}]
[]
["Total Subsistence Expenses Claimed",null,null,null,{"$f":"SUM(E26:E29)","v":0}]
[]
["C. TAXIS, TUBES AND OTHER NON-MILEAGE JOURNEY EXPENSES"]
[]
["Item","Date","Acceptable Receipt","Receipt Total","Amount Claimed £"]
[1,{"$f":"IF(ISBLANK('Expenses Form'!C32), \"\", 'Expenses Form'!C32)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!N32), \"\", 'Expenses Form'!N32)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!O32), \"\", 'Expenses Form'!O32)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!P32), \"\", 'Expenses Form'!P32)","v":""}]
[2,{"$f":"IF(ISBLANK('Expenses Form'!C33), \"\", 'Expenses Form'!C33)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!N33), \"\", 'Expenses Form'!N33)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!O33), \"\", 'Expenses Form'!O33)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!P33), \"\", 'Expenses Form'!P33)","v":""}]
[3,{"$f":"IF(ISBLANK('Expenses Form'!C34), \"\", 'Expenses Form'!C34)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!N34), \"\", 'Expenses Form'!N34)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!O34), \"\", 'Expenses Form'!O34)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!P34), \"\", 'Expenses Form'!P34)","v":""}]
[4,{"$f":"IF(ISBLANK('Expenses Form'!C35), \"\", 'Expenses Form'!C35)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!N35), \"\", 'Expenses Form'!N35)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!O35), \"\", 'Expenses Form'!O35)","v":""},{"$f":"IF(ISBLANK('Expenses Form'!P35), \"\", 'Expenses Form'!P35)","v":""}]
[]
["Total Non-Mileage Journey Expenses Claimed",null,null,null,{"$f":"SUM(E36:E39)","v":0}]
[]
["D. MILEAGE EXPENSES"]
[]
["Total Mileage Claimed",null,null,null,{"$f":"'Expenses Form'!P54","v":0}]
[]
["TOTAL CLAIM VALUE",null,null,null,{"$f":"E45+E41+E31+E21","v":0}]

{"sheet":"Validation","index":4,"n_rows":89,"n_cols":61,"rows_kept":89,"cut":false,"hidden":true,"merged":[[58,1,58,24],[60,1,60,24],[62,1,62,24]]}
[]
[null,"Header Validation"]
[]
[null,"Name",{"$f":"IF(ISBLANK('Expenses Form'!D7), 1, 0)","v":1}]
[null,"Authoriser",{"$f":"IF(ISBLANK('Expenses Form'!L7), 1, 0)","v":1}]
[null,"Submission Date",{"$f":"IF(ISBLANK('Expenses Form'!L8), 1, 0)","v":1}]
[null,"Address",{"$f":"IF(ISBLANK('Expenses Form'!D8), 1, 0)","v":1}]
[null,"Town",{"$f":"IF(ISBLANK('Expenses Form'!L9), 1, 0)","v":1}]
[null,"PostCode",{"$f":"IF(ISBLANK('Expenses Form'!L10), 1, 0)","v":1}]
[null,"Email Address",{"$f":"IF(ISBLANK('Expenses Form'!D10), 1, 0)","v":1}]
[null,"Cost Centre",{"$f":"IF(ISBLANK('Expenses Form'!$O$7), IF(SUM(L:L)>0, 1, 0), 0)","v":0}]
[null,"Project",{"$f":"IF(ISBLANK('Expenses Form'!O8), 1, 0)","v":1},null,"Excluded from error check as blank is a valid value"]
[null,"Appeal",{"$f":"IF(ISBLANK('Expenses Form'!O9), 1, 0)","v":1},null,"Excluded from error check as blank is a valid value"]
[null,"Commission",{"$f":"IF(ISBLANK('Expenses Form'!O10), 1, 0)","v":1},null,"Excluded from error check as blank is a valid value"]
[null,"Form <=0",{"$f":"IF(Total_Claim>0, 0, 1)","v":1}]
[null,"Comments",{"$f":"IF(AND(COUNTIF('Expenses Form'!N:N,\"Unavailable\")>0,ISBLANK('Expenses Form'!$B$40)),1,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Excluded from error check ",null,null,"Excluded from error check ",null,null,"Excluded from error check "]
[null,"Total Errors",{"$f":"SUM(C4:C11,C15:C17)+SUM(F:F)+SUM(I:I)+SUM(L:L)+SUM(X:X)+SUM(AA:AA)+SUM(AD:AD)+SUM(AG:AG)+SUM(AJ:AJ)+SUM(AM:AM)+SUM(AT:AT)+SUM(AW:AW)+SUM(AZ:AZ)+SUM(BC:BC)+SUM(BF:BF)+SUM(BI:BI)+SUM(AP:AP)","v":8},null,null,null,null,null,null,null,null,null,null,"as blank is a valid value",null,null,"as blank is a valid value",null,null,"as blank is a valid value"]
[]
[null,null,null,null,"Non-Travel Expenses"]
[]
[null,null,null,null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,null,null,null,null,null,null,"Area","Valid"]
[null,null,null,null,{"$f":"'Expenses Form'!$B14","v":1},{"$f":"IF(ISBLANK('Expenses Form'!C14), IF(COUNTA('Expenses Form'!$C14:$P14)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B14","v":1},{"$f":"IF(ISBLANK('Expenses Form'!D14), IF(COUNTA('Expenses Form'!$C14:$P14)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B14","v":1},{"$f":"IF(ISBLANK('Expenses Form'!$O$7), IF(ISBLANK('Expenses Form'!E14), IF(COUNTA('Expenses Form'!$C14:$P14)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B14","v":1},{"$f":"IF(ISBLANK('Expenses Form'!F14), IF(COUNTA('Expenses Form'!$C14:$P14)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B14","v":1},{"$f":"IF(ISBLANK('Expenses Form'!G6), IF(COUNTA('Expenses Form'!$C14:$P14)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B14","v":1},{"$f":"IF(ISBLANK('Expenses Form'!H6), IF(COUNTA('Expenses Form'!$C14:$P14)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B14","v":1},{"$f":"IF(ISBLANK('Expenses Form'!I14), IF(COUNTA('Expenses Form'!$C14:$P14)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B14","v":1},{"$f":"IF(ISBLANK('Expenses Form'!N14), IF(COUNTA('Expenses Form'!$C14:$P14)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B14","v":1},{"$f":"IF(AND(OR('Expenses Form'!N14=\"scanned\", 'Expenses Form'!N14=\"posted\"), ISBLANK('Expenses Form'!O14)), IF(COUNTA('Expenses Form'!$C14:$P14)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B14","v":1},{"$f":"IF(ISBLANK('Expenses Form'!P14), IF(COUNTA('Expenses Form'!$C14:$P14)>0, 1, 0), 0)","v":0},null,null,null,null,null,null,null,{"$f":"'Expenses Form'!$B14","v":1},{"$f":"IF(OR('Expenses Form'!$N14=\"Scanned\", 'Expenses Form'!$N14=\"Posted\"), IF('Expenses Form'!$P14>'Expenses Form'!$O14, 1, 0), 0)","v":0}]
[null,null,null,null,{"$f":"'Expenses Form'!$B15","v":2},{"$f":"IF(ISBLANK('Expenses Form'!C15), IF(COUNTA('Expenses Form'!$C15:$P15)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B15","v":2},{"$f":"IF(ISBLANK('Expenses Form'!D15), IF(COUNTA('Expenses Form'!$C15:$P15)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B15","v":2},{"$f":"IF(ISBLANK('Expenses Form'!$O$7), IF(ISBLANK('Expenses Form'!E15), IF(COUNTA('Expenses Form'!$C15:$P15)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B15","v":2},{"$f":"IF(ISBLANK('Expenses Form'!F15), IF(COUNTA('Expenses Form'!$C15:$P15)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B15","v":2},{"$f":"IF(ISBLANK('Expenses Form'!#REF!), IF(COUNTA('Expenses Form'!$C15:$P15)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B15","v":2},{"$f":"IF(ISBLANK('Expenses Form'!#REF!), IF(COUNTA('Expenses Form'!$C15:$P15)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B15","v":2},{"$f":"IF(ISBLANK('Expenses Form'!I15), IF(COUNTA('Expenses Form'!$C15:$P15)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B15","v":2},{"$f":"IF(ISBLANK('Expenses Form'!N15), IF(COUNTA('Expenses Form'!$C15:$P15)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B15","v":2},{"$f":"IF(AND(OR('Expenses Form'!N15=\"scanned\", 'Expenses Form'!N15=\"posted\"), ISBLANK('Expenses Form'!O15)), IF(COUNTA('Expenses Form'!$C15:$P15)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B15","v":2},{"$f":"IF(ISBLANK('Expenses Form'!P15), IF(COUNTA('Expenses Form'!$C15:$P15)>0, 1, 0), 0)","v":0},null,null,null,null,null,null,null,{"$f":"'Expenses Form'!$B15","v":2},{"$f":"IF(OR('Expenses Form'!$N15=\"Scanned\", 'Expenses Form'!$N15=\"Posted\"), IF('Expenses Form'!$P15>'Expenses Form'!$O15, 1, 0), 0)","v":0}]
[null,null,null,null,{"$f":"'Expenses Form'!$B16","v":3},{"$f":"IF(ISBLANK('Expenses Form'!C16), IF(COUNTA('Expenses Form'!$C16:$P16)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B16","v":3},{"$f":"IF(ISBLANK('Expenses Form'!D16), IF(COUNTA('Expenses Form'!$C16:$P16)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B16","v":3},{"$f":"IF(ISBLANK('Expenses Form'!$O$7), IF(ISBLANK('Expenses Form'!E16), IF(COUNTA('Expenses Form'!$C16:$P16)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B16","v":3},{"$f":"IF(ISBLANK('Expenses Form'!F16), IF(COUNTA('Expenses Form'!$C16:$P16)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B16","v":3},{"$f":"IF(ISBLANK('Expenses Form'!G7), IF(COUNTA('Expenses Form'!$C16:$P16)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B16","v":3},{"$f":"IF(ISBLANK('Expenses Form'!IK7), IF(COUNTA('Expenses Form'!$C16:$P16)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B16","v":3},{"$f":"IF(ISBLANK('Expenses Form'!I16), IF(COUNTA('Expenses Form'!$C16:$P16)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B16","v":3},{"$f":"IF(ISBLANK('Expenses Form'!N16), IF(COUNTA('Expenses Form'!$C16:$P16)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B16","v":3},{"$f":"IF(AND(OR('Expenses Form'!N16=\"scanned\", 'Expenses Form'!N16=\"posted\"), ISBLANK('Expenses Form'!O16)), IF(COUNTA('Expenses Form'!$C16:$P16)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B16","v":3},{"$f":"IF(ISBLANK('Expenses Form'!P16), IF(COUNTA('Expenses Form'!$C16:$P16)>0, 1, 0), 0)","v":0},null,null,null,null,null,null,null,{"$f":"'Expenses Form'!$B16","v":3},{"$f":"IF(OR('Expenses Form'!$N16=\"Scanned\", 'Expenses Form'!$N16=\"Posted\"), IF('Expenses Form'!$P16>'Expenses Form'!$O16, 1, 0), 0)","v":0}]
[null,null,null,null,{"$f":"'Expenses Form'!$B17","v":4},{"$f":"IF(ISBLANK('Expenses Form'!C17), IF(COUNTA('Expenses Form'!$C17:$P17)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B17","v":4},{"$f":"IF(ISBLANK('Expenses Form'!D17), IF(COUNTA('Expenses Form'!$C17:$P17)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B17","v":4},{"$f":"IF(ISBLANK('Expenses Form'!$O$7), IF(ISBLANK('Expenses Form'!E17), IF(COUNTA('Expenses Form'!$C17:$P17)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B17","v":4},{"$f":"IF(ISBLANK('Expenses Form'!F17), IF(COUNTA('Expenses Form'!$C17:$P17)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B17","v":4},{"$f":"IF(ISBLANK('Expenses Form'!G8), IF(COUNTA('Expenses Form'!$C17:$P17)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B17","v":4},{"$f":"IF(ISBLANK('Expenses Form'!IK8), IF(COUNTA('Expenses Form'!$C17:$P17)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B17","v":4},{"$f":"IF(ISBLANK('Expenses Form'!I17), IF(COUNTA('Expenses Form'!$C17:$P17)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B17","v":4},{"$f":"IF(ISBLANK('Expenses Form'!N17), IF(COUNTA('Expenses Form'!$C17:$P17)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B17","v":4},{"$f":"IF(AND(OR('Expenses Form'!N17=\"scanned\", 'Expenses Form'!N17=\"posted\"), ISBLANK('Expenses Form'!O17)), IF(COUNTA('Expenses Form'!$C17:$P17)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B17","v":4},{"$f":"IF(ISBLANK('Expenses Form'!P17), IF(COUNTA('Expenses Form'!$C17:$P17)>0, 1, 0), 0)","v":0},null,null,null,null,null,null,null,{"$f":"'Expenses Form'!$B17","v":4},{"$f":"IF(OR('Expenses Form'!$N17=\"Scanned\", 'Expenses Form'!$N17=\"Posted\"), IF('Expenses Form'!$P17>'Expenses Form'!$O17, 1, 0), 0)","v":0}]
[null,null,null,null,"Dates Not Completed",null,null,"Account Code Not Completed",null,null,"Cost Centre Not Completed",null,null,"Project Not Completed",null,null,"Appeal Not Completed",null,null,"Commission Not Completed",null,null,"Description Not Completed",null,null,"Acceptable Receipt Indicator Not Completed",null,null,"Receipt Total Not Completed",null,null,"Claim Amount Not Completed",null,null,null,null,null,null,null,null,"Claim greater than receipt value (where receipt provided)"]
[]
[null,null,null,null,"Subsistence Expenses"]
[]
[null,null,null,null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,null,null,null,"Area","Valid"]
[null,null,null,null,{"$f":"'Expenses Form'!$B23","v":1},{"$f":"IF(ISBLANK('Expenses Form'!C23), IF(COUNTA('Expenses Form'!$C23:$P23)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B23","v":1},{"$f":"IF(ISBLANK('Expenses Form'!D23), IF(COUNTA('Expenses Form'!$C23:$P23)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B23","v":1},{"$f":"IF(ISBLANK('Expenses Form'!$O$7),IF(ISBLANK('Expenses Form'!E23), IF(COUNTA('Expenses Form'!$C23:$P23)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B23","v":1},{"$f":"IF(ISBLANK('Expenses Form'!F23), IF(COUNTA('Expenses Form'!$C23:$P23)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B23","v":1},{"$f":"IF(ISBLANK('Expenses Form'!G23), IF(COUNTA('Expenses Form'!$C23:$P23)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B23","v":1},{"$f":"IF(ISBLANK('Expenses Form'!H23), IF(COUNTA('Expenses Form'!$C23:$P23)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B23","v":1},{"$f":"IF(ISBLANK('Expenses Form'!I23), IF(COUNTA('Expenses Form'!$C23:$P23)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B23","v":1},{"$f":"IF(ISBLANK('Expenses Form'!J23), IF(COUNTA('Expenses Form'!$C23:$P23)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B23","v":1},{"$f":"IF(ISBLANK('Expenses Form'!N23), IF(COUNTA('Expenses Form'!$C23:$P23)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B23","v":1},{"$f":"IF(AND(OR('Expenses Form'!N23=\"posted\", 'Expenses Form'!N23=\"scanned\"), ISBLANK('Expenses Form'!O23)), IF(COUNTA('Expenses Form'!$C23:$P23)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B23","v":1},{"$f":"IF(ISBLANK('Expenses Form'!P23), IF(COUNTA('Expenses Form'!$C23:$P23)>0, 1, 0), 0)","v":0},null,null,null,null,{"$f":"'Expenses Form'!$B23","v":1},{"$f":"IF(OR('Expenses Form'!$N23=\"Scanned\", 'Expenses Form'!$N23=\"Posted\"), IF('Expenses Form'!$P23>'Expenses Form'!$O23, 1, 0), 0)","v":0}]
[null,null,null,null,{"$f":"'Expenses Form'!$B24","v":2},{"$f":"IF(ISBLANK('Expenses Form'!C24), IF(COUNTA('Expenses Form'!$C24:$P24)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B24","v":2},{"$f":"IF(ISBLANK('Expenses Form'!D24), IF(COUNTA('Expenses Form'!$C24:$P24)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B24","v":2},{"$f":"IF(ISBLANK('Expenses Form'!$O$7),IF(ISBLANK('Expenses Form'!E24), IF(COUNTA('Expenses Form'!$C24:$P24)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B24","v":2},{"$f":"IF(ISBLANK('Expenses Form'!F24), IF(COUNTA('Expenses Form'!$C24:$P24)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B24","v":2},{"$f":"IF(ISBLANK('Expenses Form'!G24), IF(COUNTA('Expenses Form'!$C24:$P24)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B24","v":2},{"$f":"IF(ISBLANK('Expenses Form'!H24), IF(COUNTA('Expenses Form'!$C24:$P24)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B24","v":2},{"$f":"IF(ISBLANK('Expenses Form'!I24), IF(COUNTA('Expenses Form'!$C24:$P24)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B24","v":2},{"$f":"IF(ISBLANK('Expenses Form'!J24), IF(COUNTA('Expenses Form'!$C24:$P24)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B24","v":2},{"$f":"IF(ISBLANK('Expenses Form'!N24), IF(COUNTA('Expenses Form'!$C24:$P24)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B24","v":2},{"$f":"IF(AND(OR('Expenses Form'!N24=\"posted\", 'Expenses Form'!N24=\"scanned\"), ISBLANK('Expenses Form'!O24)), IF(COUNTA('Expenses Form'!$C24:$P24)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B24","v":2},{"$f":"IF(ISBLANK('Expenses Form'!P24), IF(COUNTA('Expenses Form'!$C24:$P24)>0, 1, 0), 0)","v":0},null,null,null,null,{"$f":"'Expenses Form'!$B24","v":2},{"$f":"IF(OR('Expenses Form'!$N24=\"Scanned\", 'Expenses Form'!$N24=\"Posted\"), IF('Expenses Form'!$P24>'Expenses Form'!$O24, 1, 0), 0)","v":0}]
[null,null,null,null,{"$f":"'Expenses Form'!$B25","v":3},{"$f":"IF(ISBLANK('Expenses Form'!C25), IF(COUNTA('Expenses Form'!$C25:$P25)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B25","v":3},{"$f":"IF(ISBLANK('Expenses Form'!D25), IF(COUNTA('Expenses Form'!$C25:$P25)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B25","v":3},{"$f":"IF(ISBLANK('Expenses Form'!$O$7),IF(ISBLANK('Expenses Form'!E25), IF(COUNTA('Expenses Form'!$C25:$P25)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B25","v":3},{"$f":"IF(ISBLANK('Expenses Form'!F25), IF(COUNTA('Expenses Form'!$C25:$P25)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B25","v":3},{"$f":"IF(ISBLANK('Expenses Form'!G25), IF(COUNTA('Expenses Form'!$C25:$P25)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B25","v":3},{"$f":"IF(ISBLANK('Expenses Form'!H25), IF(COUNTA('Expenses Form'!$C25:$P25)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B25","v":3},{"$f":"IF(ISBLANK('Expenses Form'!I25), IF(COUNTA('Expenses Form'!$C25:$P25)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B25","v":3},{"$f":"IF(ISBLANK('Expenses Form'!J25), IF(COUNTA('Expenses Form'!$C25:$P25)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B25","v":3},{"$f":"IF(ISBLANK('Expenses Form'!N25), IF(COUNTA('Expenses Form'!$C25:$P25)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B25","v":3},{"$f":"IF(AND(OR('Expenses Form'!N25=\"posted\", 'Expenses Form'!N25=\"scanned\"), ISBLANK('Expenses Form'!O25)), IF(COUNTA('Expenses Form'!$C25:$P25)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B25","v":3},{"$f":"IF(ISBLANK('Expenses Form'!P25), IF(COUNTA('Expenses Form'!$C25:$P25)>0, 1, 0), 0)","v":0},null,null,null,null,{"$f":"'Expenses Form'!$B25","v":3},{"$f":"IF(OR('Expenses Form'!$N25=\"Scanned\", 'Expenses Form'!$N25=\"Posted\"), IF('Expenses Form'!$P25>'Expenses Form'!$O25, 1, 0), 0)","v":0}]
[null,null,null,null,{"$f":"'Expenses Form'!$B26","v":4},{"$f":"IF(ISBLANK('Expenses Form'!C26), IF(COUNTA('Expenses Form'!$C26:$P26)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B26","v":4},{"$f":"IF(ISBLANK('Expenses Form'!D26), IF(COUNTA('Expenses Form'!$C26:$P26)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B26","v":4},{"$f":"IF(ISBLANK('Expenses Form'!$O$7),IF(ISBLANK('Expenses Form'!E26), IF(COUNTA('Expenses Form'!$C26:$P26)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B26","v":4},{"$f":"IF(ISBLANK('Expenses Form'!F26), IF(COUNTA('Expenses Form'!$C26:$P26)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B26","v":4},{"$f":"IF(ISBLANK('Expenses Form'!G26), IF(COUNTA('Expenses Form'!$C26:$P26)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B26","v":4},{"$f":"IF(ISBLANK('Expenses Form'!H26), IF(COUNTA('Expenses Form'!$C26:$P26)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B26","v":4},{"$f":"IF(ISBLANK('Expenses Form'!I26), IF(COUNTA('Expenses Form'!$C26:$P26)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B26","v":4},{"$f":"IF(ISBLANK('Expenses Form'!J26), IF(COUNTA('Expenses Form'!$C26:$P26)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B26","v":4},{"$f":"IF(ISBLANK('Expenses Form'!N26), IF(COUNTA('Expenses Form'!$C26:$P26)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B26","v":4},{"$f":"IF(AND(OR('Expenses Form'!N26=\"posted\", 'Expenses Form'!N26=\"scanned\"), ISBLANK('Expenses Form'!O26)), IF(COUNTA('Expenses Form'!$C26:$P26)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B26","v":4},{"$f":"IF(ISBLANK('Expenses Form'!P26), IF(COUNTA('Expenses Form'!$C26:$P26)>0, 1, 0), 0)","v":0},null,null,null,null,{"$f":"'Expenses Form'!$B26","v":4},{"$f":"IF(OR('Expenses Form'!$N26=\"Scanned\", 'Expenses Form'!$N26=\"Posted\"), IF('Expenses Form'!$P26>'Expenses Form'!$O26, 1, 0), 0)","v":0}]
[null,null,null,null,"Dates Not Completed",null,null,"Account Code Not Completed",null,null,"Cost Centre Not Completed",null,null,"Project Not Completed",null,null,"Appeal Not Completed",null,null,"Commission Not Completed",null,null,"Meal Type Not Completed",null,null,"Description Not Completed",null,null,"Acceptable Receipt Indicator Not Completed",null,null,"Receipt Total Not Completed",null,null,"Claim Amount Not Completed",null,null,null,null,null,"Claim greater than receipt value (where receipt provided)"]
[]
[null,null,null,null,"Taxi Expenses"]
[]
[null,null,null,null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid"]
[null,null,null,null,{"$f":"'Expenses Form'!$B32","v":1},{"$f":"IF(ISBLANK('Expenses Form'!C32), IF(COUNTA('Expenses Form'!$C32:$P32)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B32","v":1},{"$f":"IF(ISBLANK('Expenses Form'!D32), IF(COUNTA('Expenses Form'!$C32:$P32)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B32","v":1},{"$f":"IF(ISBLANK('Expenses Form'!$O$7),IF(ISBLANK('Expenses Form'!E32), IF(COUNTA('Expenses Form'!$C32:$P32)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B32","v":1},{"$f":"IF(ISBLANK('Expenses Form'!F32), IF(COUNTA('Expenses Form'!$C32:$P32)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B32","v":1},{"$f":"IF(ISBLANK('Expenses Form'!G32), IF(COUNTA('Expenses Form'!$C32:$P32)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B32","v":1},{"$f":"IF(ISBLANK('Expenses Form'!H32), IF(COUNTA('Expenses Form'!$C32:$P32)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B32","v":1},{"$f":"IF(ISBLANK('Expenses Form'!I32), IF(COUNTA('Expenses Form'!$C32:$P32)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B32","v":1},{"$f":"IF(ISBLANK('Expenses Form'!J32), IF(COUNTA('Expenses Form'!$C32:$P32)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B32","v":1},{"$f":"IF(ISBLANK('Expenses Form'!K32), IF(COUNTA('Expenses Form'!$C32:$P32)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B32","v":1},{"$f":"IF(ISBLANK('Expenses Form'!N32), IF(COUNTA('Expenses Form'!$C32:$P32)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B32","v":1},{"$f":"IF(AND(OR('Expenses Form'!N32=\"scanned\", 'Expenses Form'!N32=\"posted\"),ISBLANK('Expenses Form'!O32)), IF(COUNTA('Expenses Form'!$C32:$P32)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B32","v":1},{"$f":"IF(ISBLANK('Expenses Form'!P32), IF(COUNTA('Expenses Form'!$C32:$P32)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B32","v":1},{"$f":"IF(OR('Expenses Form'!$N32=\"Scanned\", 'Expenses Form'!$N32=\"Posted\"), IF('Expenses Form'!$P32>'Expenses Form'!$O32, 1, 0), 0)","v":0}]
[null,null,null,null,{"$f":"'Expenses Form'!$B33","v":2},{"$f":"IF(ISBLANK('Expenses Form'!C33), IF(COUNTA('Expenses Form'!$C33:$P33)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B33","v":2},{"$f":"IF(ISBLANK('Expenses Form'!D33), IF(COUNTA('Expenses Form'!$C33:$P33)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B33","v":2},{"$f":"IF(ISBLANK('Expenses Form'!$O$7),IF(ISBLANK('Expenses Form'!E33), IF(COUNTA('Expenses Form'!$C33:$P33)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B33","v":2},{"$f":"IF(ISBLANK('Expenses Form'!F33), IF(COUNTA('Expenses Form'!$C33:$P33)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B33","v":2},{"$f":"IF(ISBLANK('Expenses Form'!G33), IF(COUNTA('Expenses Form'!$C33:$P33)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B33","v":2},{"$f":"IF(ISBLANK('Expenses Form'!H33), IF(COUNTA('Expenses Form'!$C33:$P33)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B33","v":2},{"$f":"IF(ISBLANK('Expenses Form'!I33), IF(COUNTA('Expenses Form'!$C33:$P33)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B33","v":2},{"$f":"IF(ISBLANK('Expenses Form'!J33), IF(COUNTA('Expenses Form'!$C33:$P33)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B33","v":2},{"$f":"IF(ISBLANK('Expenses Form'!K33), IF(COUNTA('Expenses Form'!$C33:$P33)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B33","v":2},{"$f":"IF(ISBLANK('Expenses Form'!N33), IF(COUNTA('Expenses Form'!$C33:$P33)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B33","v":2},{"$f":"IF(AND(OR('Expenses Form'!N33=\"scanned\", 'Expenses Form'!N33=\"posted\"),ISBLANK('Expenses Form'!O33)), IF(COUNTA('Expenses Form'!$C33:$P33)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B33","v":2},{"$f":"IF(ISBLANK('Expenses Form'!P33), IF(COUNTA('Expenses Form'!$C33:$P33)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B33","v":2},{"$f":"IF(OR('Expenses Form'!$N33=\"Scanned\", 'Expenses Form'!$N33=\"Posted\"), IF('Expenses Form'!$P$14>'Expenses Form'!$O$14, 1, 0), 0)","v":0}]
[null,null,null,null,{"$f":"'Expenses Form'!$B34","v":3},{"$f":"IF(ISBLANK('Expenses Form'!C34), IF(COUNTA('Expenses Form'!$C34:$P34)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B34","v":3},{"$f":"IF(ISBLANK('Expenses Form'!D34), IF(COUNTA('Expenses Form'!$C34:$P34)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B34","v":3},{"$f":"IF(ISBLANK('Expenses Form'!$O$7),IF(ISBLANK('Expenses Form'!E34), IF(COUNTA('Expenses Form'!$C34:$P34)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B34","v":3},{"$f":"IF(ISBLANK('Expenses Form'!F34), IF(COUNTA('Expenses Form'!$C34:$P34)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B34","v":3},{"$f":"IF(ISBLANK('Expenses Form'!G34), IF(COUNTA('Expenses Form'!$C34:$P34)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B34","v":3},{"$f":"IF(ISBLANK('Expenses Form'!H34), IF(COUNTA('Expenses Form'!$C34:$P34)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B34","v":3},{"$f":"IF(ISBLANK('Expenses Form'!I34), IF(COUNTA('Expenses Form'!$C34:$P34)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B34","v":3},{"$f":"IF(ISBLANK('Expenses Form'!J34), IF(COUNTA('Expenses Form'!$C34:$P34)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B34","v":3},{"$f":"IF(ISBLANK('Expenses Form'!K34), IF(COUNTA('Expenses Form'!$C34:$P34)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B34","v":3},{"$f":"IF(ISBLANK('Expenses Form'!N34), IF(COUNTA('Expenses Form'!$C34:$P34)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B34","v":3},{"$f":"IF(AND(OR('Expenses Form'!N34=\"scanned\", 'Expenses Form'!N34=\"posted\"),ISBLANK('Expenses Form'!O34)), IF(COUNTA('Expenses Form'!$C34:$P34)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B34","v":3},{"$f":"IF(ISBLANK('Expenses Form'!P34), IF(COUNTA('Expenses Form'!$C34:$P34)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B34","v":3},{"$f":"IF(OR('Expenses Form'!$N34=\"Scanned\", 'Expenses Form'!$N34=\"Posted\"), IF('Expenses Form'!$P$14>'Expenses Form'!$O$14, 1, 0), 0)","v":0}]
[null,null,null,null,{"$f":"'Expenses Form'!$B35","v":4},{"$f":"IF(ISBLANK('Expenses Form'!C35), IF(COUNTA('Expenses Form'!$C35:$P35)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B35","v":4},{"$f":"IF(ISBLANK('Expenses Form'!D35), IF(COUNTA('Expenses Form'!$C35:$P35)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B35","v":4},{"$f":"IF(ISBLANK('Expenses Form'!$O$7),IF(ISBLANK('Expenses Form'!E35), IF(COUNTA('Expenses Form'!$C35:$P35)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B35","v":4},{"$f":"IF(ISBLANK('Expenses Form'!F35), IF(COUNTA('Expenses Form'!$C35:$P35)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B35","v":4},{"$f":"IF(ISBLANK('Expenses Form'!G35), IF(COUNTA('Expenses Form'!$C35:$P35)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B35","v":4},{"$f":"IF(ISBLANK('Expenses Form'!H35), IF(COUNTA('Expenses Form'!$C35:$P35)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B35","v":4},{"$f":"IF(ISBLANK('Expenses Form'!I35), IF(COUNTA('Expenses Form'!$C35:$P35)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B35","v":4},{"$f":"IF(ISBLANK('Expenses Form'!J35), IF(COUNTA('Expenses Form'!$C35:$P35)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B35","v":4},{"$f":"IF(ISBLANK('Expenses Form'!K35), IF(COUNTA('Expenses Form'!$C35:$P35)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B35","v":4},{"$f":"IF(ISBLANK('Expenses Form'!N35), IF(COUNTA('Expenses Form'!$C35:$P35)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B35","v":4},{"$f":"IF(AND(OR('Expenses Form'!N35=\"scanned\", 'Expenses Form'!N35=\"posted\"),ISBLANK('Expenses Form'!O35)), IF(COUNTA('Expenses Form'!$C35:$P35)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B35","v":4},{"$f":"IF(ISBLANK('Expenses Form'!P35), IF(COUNTA('Expenses Form'!$C35:$P35)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B35","v":4},{"$f":"IF(OR('Expenses Form'!$N35=\"Scanned\", 'Expenses Form'!$N35=\"Posted\"), IF('Expenses Form'!$P$14>'Expenses Form'!$O$14, 1, 0), 0)","v":0}]
[null,null,null,null,"Dates Not Completed",null,null,"Account Code Not Completed",null,null,"Cost Centre Not Completed",null,null,"Project Not Completed",null,null,"Appeal Not Completed",null,null,"Commission Not Completed",null,null,"From Location Not Completed",null,null,"To Location Not Completed",null,null,"Description Not Completed",null,null,"Acceptable Receipt Indicator Not Completed",null,null,"Receipt Total Not Completed",null,null,"Claim Amount Not Completed",null,null,"Claim greater than receipt value (where receipt provided)"]
[]
[null,null,null,null,"Mileage Expenses"]
[]
[null,null,null,null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,"Area","Valid",null,null,null,null,null,"Area","Valid",null,"Area","Valid",null,"Area ","Valid",null,"Area ","Valid",null,"Area ","Valid",null,"Area ","Valid"]
[null,null,null,null,{"$f":"'Expenses Form'!$B49","v":1},{"$f":"IF(ISBLANK('Expenses Form'!C49), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B49","v":1},{"$f":"IF(ISBLANK('Expenses Form'!D49), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B49","v":1},{"$f":"IF(ISBLANK('Expenses Form'!$O$7),IF(ISBLANK('Expenses Form'!E49), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B49","v":1},{"$f":"IF(ISBLANK('Expenses Form'!F49), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B49","v":1},{"$f":"IF(ISBLANK('Expenses Form'!G49), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B49","v":1},{"$f":"IF(ISBLANK('Expenses Form'!H49), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B49","v":1},{"$f":"IF(ISBLANK('Expenses Form'!I49), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B49","v":1},{"$f":"IF(ISBLANK('Expenses Form'!J49), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B49","v":1},{"$f":"IF(ISBLANK('Expenses Form'!K49), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B49","v":1},{"$f":"IF(ISBLANK('Expenses Form'!L49), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B49","v":1},{"$f":"IF(ISBLANK('Expenses Form'!M49), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B49","v":1},{"$f":"IF(ISBLANK('Expenses Form'!O49), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0)","v":0},null,null,null,null,null,1,0,null,1,0,null,1,{"$f":"IF(ISBLANK('Expenses Form'!$O$46), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0)","v":0},null,1,{"$f":"IF(OR(ISBLANK('Expenses Form'!$O$59), ISBLANK('Expenses Form'!$P$59)), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0)","v":0},null,1,{"$f":"IF(OR(ISBLANK('Expenses Form'!$O$60), AND(ISBLANK('Expenses Form'!$P$60),'Expenses Form'!$O$60=\"Yes\"), AND(ISBLANK('Expenses Form'!$P$60),'Expenses Form'!$O$60=\"No\")), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0)","v":0},null,1,{"$f":"IF(OR(ISBLANK('Expenses Form'!$O$61), ISBLANK('Expenses Form'!$P$61)), IF(COUNTA('Expenses Form'!$C49:$O49)>0, 1, 0), 0)","v":0}]
[null,null,null,null,{"$f":"'Expenses Form'!$B50","v":2},{"$f":"IF(ISBLANK('Expenses Form'!C50), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B50","v":2},{"$f":"IF(ISBLANK('Expenses Form'!D50), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B50","v":2},{"$f":"IF(ISBLANK('Expenses Form'!$O$7),IF(ISBLANK('Expenses Form'!E50), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B50","v":2},{"$f":"IF(ISBLANK('Expenses Form'!F50), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B50","v":2},{"$f":"IF(ISBLANK('Expenses Form'!G50), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B50","v":2},{"$f":"IF(ISBLANK('Expenses Form'!H50), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B50","v":2},{"$f":"IF(ISBLANK('Expenses Form'!I50), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B50","v":2},{"$f":"IF(ISBLANK('Expenses Form'!J50), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B50","v":2},{"$f":"IF(ISBLANK('Expenses Form'!K50), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B50","v":2},{"$f":"IF(ISBLANK('Expenses Form'!L50), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B50","v":2},{"$f":"IF(ISBLANK('Expenses Form'!M50), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B50","v":2},{"$f":"IF(ISBLANK('Expenses Form'!O50), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0)","v":0},null,null,null,null,null,2,0,null,2,0,null,2,{"$f":"IF(ISBLANK('Expenses Form'!$O$46), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0)","v":0},null,2,{"$f":"IF(OR(ISBLANK('Expenses Form'!$O$59), ISBLANK('Expenses Form'!$P$59)), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0)","v":0},null,2,{"$f":"IF(OR(ISBLANK('Expenses Form'!$O$60), AND(ISBLANK('Expenses Form'!$P$60),'Expenses Form'!$O$60=\"Yes\"), AND(ISBLANK('Expenses Form'!$P$60),'Expenses Form'!$O$60=\"No\")), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0)","v":0},null,2,{"$f":"IF(OR(ISBLANK('Expenses Form'!$O$61), ISBLANK('Expenses Form'!$P$61)), IF(COUNTA('Expenses Form'!$C50:$O50)>0, 1, 0), 0)","v":0}]
[null,null,null,null,{"$f":"'Expenses Form'!$B51","v":3},{"$f":"IF(ISBLANK('Expenses Form'!C51), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B51","v":3},{"$f":"IF(ISBLANK('Expenses Form'!D51), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B51","v":3},{"$f":"IF(ISBLANK('Expenses Form'!$O$7),IF(ISBLANK('Expenses Form'!E51), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B51","v":3},{"$f":"IF(ISBLANK('Expenses Form'!F51), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B51","v":3},{"$f":"IF(ISBLANK('Expenses Form'!G51), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B51","v":3},{"$f":"IF(ISBLANK('Expenses Form'!H51), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B51","v":3},{"$f":"IF(ISBLANK('Expenses Form'!I51), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B51","v":3},{"$f":"IF(ISBLANK('Expenses Form'!J51), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B51","v":3},{"$f":"IF(ISBLANK('Expenses Form'!K51), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B51","v":3},{"$f":"IF(ISBLANK('Expenses Form'!L51), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B51","v":3},{"$f":"IF(ISBLANK('Expenses Form'!M51), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B51","v":3},{"$f":"IF(ISBLANK('Expenses Form'!O51), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0)","v":0},null,null,null,null,null,3,0,null,3,0,null,3,{"$f":"IF(ISBLANK('Expenses Form'!$O$46), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0)","v":0},null,3,{"$f":"IF(OR(ISBLANK('Expenses Form'!$O$59), ISBLANK('Expenses Form'!$P$59)), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0)","v":0},null,3,{"$f":"IF(OR(ISBLANK('Expenses Form'!$O$60), AND(ISBLANK('Expenses Form'!$P$60),'Expenses Form'!$O$60=\"Yes\"), AND(ISBLANK('Expenses Form'!$P$60),'Expenses Form'!$O$60=\"No\")), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0)","v":0},null,3,{"$f":"IF(OR(ISBLANK('Expenses Form'!$O$61), ISBLANK('Expenses Form'!$P$61)), IF(COUNTA('Expenses Form'!$C51:$O51)>0, 1, 0), 0)","v":0}]
[null,null,null,null,{"$f":"'Expenses Form'!$B52","v":4},{"$f":"IF(ISBLANK('Expenses Form'!C52), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B52","v":4},{"$f":"IF(ISBLANK('Expenses Form'!D52), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B52","v":4},{"$f":"IF(ISBLANK('Expenses Form'!$O$7),IF(ISBLANK('Expenses Form'!E52), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B52","v":4},{"$f":"IF(ISBLANK('Expenses Form'!F52), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B52","v":4},{"$f":"IF(ISBLANK('Expenses Form'!G52), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B52","v":4},{"$f":"IF(ISBLANK('Expenses Form'!H52), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B52","v":4},{"$f":"IF(ISBLANK('Expenses Form'!I52), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B52","v":4},{"$f":"IF(ISBLANK('Expenses Form'!J52), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B52","v":4},{"$f":"IF(ISBLANK('Expenses Form'!K52), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B52","v":4},{"$f":"IF(ISBLANK('Expenses Form'!L52), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B52","v":4},{"$f":"IF(ISBLANK('Expenses Form'!M52), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0)","v":0},null,{"$f":"'Expenses Form'!$B52","v":4},{"$f":"IF(ISBLANK('Expenses Form'!O52), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0)","v":0},null,null,null,null,null,4,0,null,4,0,null,4,{"$f":"IF(ISBLANK('Expenses Form'!$O$46), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0)","v":0},null,4,{"$f":"IF(OR(ISBLANK('Expenses Form'!$O$59), ISBLANK('Expenses Form'!$P$59)), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0)","v":0},null,4,{"$f":"IF(OR(ISBLANK('Expenses Form'!$O$60), AND(ISBLANK('Expenses Form'!$P$60),'Expenses Form'!$O$60=\"Yes\"), AND(ISBLANK('Expenses Form'!$P$60),'Expenses Form'!$O$60=\"No\")), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0)","v":0},null,4,{"$f":"IF(OR(ISBLANK('Expenses Form'!$O$61), ISBLANK('Expenses Form'!$P$61)), IF(COUNTA('Expenses Form'!$C52:$O52)>0, 1, 0), 0)","v":0}]
[null,null,null,null,"Dates Not Completed",null,null,"Account Code Not Completed",null,null,"Cost Centre Not Completed",null,null,"Project Not Completed",null,null,"Appeal Not Completed",null,null,"Commission Not Completed",null,null,"From Location Not Completed",null,null,"From PostCode Not Completed",null,null,"To Location Not Completed",null,null,"To PostCode Not Completed",null,null,"Description Not Completed",null,null,"No. Miles Not Completed",null,null,null,null,null,null,"Car Allowance",null,null,"Engine Size",null,null,"Cumulative mileage",null,null,"Drivers Licence",null,null,"MOT",null,null,"Insurance"]
[]
[null,"Warning Messages"]
[]
[null,"INCOMPLETE SUBMISSION Please ensure you have completed all necessary cells. Incorrectly completed cells will be shown in red. We are unable to process incomplete claims, if you are having difficulties completing your claim please call NPU on 02920 108132."]
[]
[null,"VALID SUBMISSION Use the Submit Form button to attach the expense claim form to an email and send to your NSPCC contact. Expenses sent to NPU without using the Submit Form button will be rejected, as this process generates the transaction reference which allows your claim to be tracked. "]
[]
[null,"LATE SUBMISSION Some of the expenses on this form are over three months old. Use the Submit Form button to attach the expense claim form to an email and send to your NSPCC contact. These expenses require authorisation from your Functional Director or Senior Management Team member before they are submitted to the NPU to be processed."]
[]
[]
[null,"Receipt Instructions"]
[null,"Receipt form",{"$f":"COUNTIF('Expenses Form'!N14:N36, \"Posted\")","v":0},null,"RECEIPTS You have chosen to send your receipts to the NPU by post, a receipts form will be printed when you submit your claim.  If you have access to a scanner please scan your receipts, attach them to your claim email and retain the originals."]
[null,null,null,null,"RECEIPTS Please attach your receipts to the email generated when you use the Submit Form button to send your claim. Originals of scanned receipts should be retained by the claimant, not sent through to the NPU."]
[]
[]
[null,"Budget Holder Instructions"]
[]
[null,"please forward this claim to your Functional Director or Senior Management Team member stating \"Approved\" and give further explanation for the late submission if necessary."]
[]
[null,"please forward this claim to the National Processing Unit at npuhelpdesk@nspcc.org.uk stating \"Approved\"."]
[]
[]
[null,"Functional Director/SMT Approval Instructions"]
[null,"FUNCTIONAL DIRECTOR/SMT APPROVAL REQUIRED: Some or all of the expenses being claimed on this form were incurred more than 3 months before the date of submission. If you are willing to authorise payment of these expenses please forward this email with the claim attached to the National Processing Unit at NPUhelpdesk@nspcc.org.uk stating \"Approved\". If you  are unwilling to authorise these expenses please return the email to the employee's line manager giving the reason for non payment."]
[]
[null,"FUNCTIONAL DIRECTOR/SMT APPROVAL NOT REQUIRED: No expenses on this form were incurred more than 3 months before the date of submission. "]
[]
[]
[]
[null,"Training Code Test",{"$f":"COUNTIF('Expenses Form'!D:D, Data!$A$48)","v":0}]
[]
[null,"Receipt Form Required",{"$f":"COUNTIF('Expenses Form'!N:N, \"Posted\")","v":0}]
[]
[null,"Q&A Check",{"$f":"IFERROR(IF([1]!UserName() = \"\", \"NO QA\", [1]!UserName()), \"NO QA\")","v":"NO QA"}]

{"sheet":"Import","index":5,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[]
[null,"SunSystems Import Sheet",null,"FORM UPDATED ON THE GREEN - 01/08/2018"]
[null,"This sheet extracts the data required from the expenses form and formats it into a suitable format to be loaded into SunSystems. "]
[]
[null,"1. First log into Q&A and then click the Update Import File button. This sheet will default to manual recalculate because this is what Q&A requires. Therefore to pull the data through from the claim form you need to click here. "]
[]
[null,"2. Key the Supplier Account into the yellow box below and then check the account name is for the correct person. Click the Check Supplier Account button to display the name of the Account to which you are importing. "]
[null,"If the account does not exist, you need to arrange for the supplier to be created before you can import this claim. If the account is for the wrong person, contact the claimant to ensure that the employee number provided is correct. "]
[null,"Check the postcode indicator is TRUE - this shows that the postcode on the supplier record is the same as the one on the form. If not, this may indicate that the volunteer's address has changed and the supplier record needs to be updated. "]
[]
[null,"3. Enter the date the expense claim was received by NPU into the orange field"]
[]
[null,"4. If the account exists, click on the Send Data to SunSystems button to attempt to send the data. Any errors will be displayed as an Excel review note in cell I23. Any comments will be displayed as an Excel review note in cell I24"]
[]
[null,"5. Once you have successfully sent the data, use the Ledger Import function to import the created journal into SunSystems. "]
[]
[]
[null,"Step 1"]
[]
[null,"Header Information"]
[null,"User",{"$f":"IFERROR([1]!UserName(), \"\")","v":""},"Step 2",null,null,"Step 3"]
[null,"Business Unit",{"$f":"IF(BU_Error=TRUE, \"Undefined\", IF(TRD_Indicator>=1, \"TRD\", \"SOC\"))","v":"SOC"}]
[1,"Journal Type","PINVL",null,"Account Code (key here)",null,null,"Reported Errors"]
[null,"Transaction Reference",{"$f":"Transaction_Reference","v":"-030615-111555"},"Account Code Name",{"$f":"IF(Claimant=\"\", \"\", Claimant)","v":""},{"$f":"IFERROR(IF(ISBLANK(F23), \"\", IF(C21=\"\", \"\", [1]!AG_DTLK(\"0,2,SS5,CA,F={P}1,K=DbC,F=C,K=/CA/AccTyp,F={P}2,K=/CA/Cde,E=0,O=/CA/Nme,\",Import!F24,$C$22,F$23))), \"\")","v":""},{"$f":"E24=F24","v":true},"Comments"]
[null,"Transaction Date",{"$f":"Time_Stamp","v":"2015-06-03T11:15:55"},"PostCode Check",{"$f":"IF('Expenses Form'!L10=\"\", \"\",'Expenses Form'!L10)","v":""},{"$f":"IFERROR(IF(ISBLANK(F23), \"\", IF(C21=\"\", \"\", [1]!AG_DTLK(\"0,2,SS5,CA,F=SOC,K=DbC,F=C,K=/CA/AccTyp,F={P}1,K=/CA/Cde,E=0,O=/CA/NA/18,\",Import!F25,F$23))), \"\")","v":""},{"$f":"UPPER(E25)=UPPER(F25)","v":true}]
[null,"Authoriser",{"$f":"'Expenses Form'!L7","v":0},"Date Expense claim received by NPU"]
[null,"Line Detail Information"]
[null,"Account Code","Cost Centre (LA1) Analysis Code","Fund  (LA2)  Analysis Code","Project (LA4)  Analysis Code","Appeal Code  (LA5)  Analysis Code","LA6","Transaction Amount","VAT Analysis Code (LA7)  Analysis Code","Customer/Supplier Code (LA8)   Analysis Code","Description","Memo Amount","Post Code From","Post Code To","Transaction from date","Transaction to Date"]
[{"$f":"IF(B29=\"\", \"\", \"2;3\")","v":"2;3"},{"$f":"$F$23","v":0},null,null,null,null,null,{"$f":"-'Expenses Form'!P63","v":0},null,{"$f":"$F$23","v":0},{"$f":"$C$24","v":"-030615-111555"}]
[{"$f":"IF(B30=\"\", \"\", \"2;3\")","v":""},{"$f":"LEFT('Expenses Form'!D14, 4)","v":""},{"$f":"UPPER(IF(ISBLANK(B30), \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E14,'Expenses Form'!$O$7)))","v":""},{"$f":"IF(B30=\"\", \"\", \"G00000\")","v":""},{"$f":"UPPER(IF($B30=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F14), \"NA\", 'Expenses Form'!F14),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B30=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G14), \"NA\", 'Expenses Form'!G14),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B30=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H14), \"NA\", 'Expenses Form'!H14),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B30=\"\", \"\", 'Expenses Form'!P14)","v":""},{"$f":"IF(B30=\"\", \"\", \"1004N\")","v":""},{"$f":"IF(B30=\"\", \"\",$F$23)","v":""},{"$f":"IF(B30=\"\", \"\", 'Expenses Form'!I14)","v":""},null,null,null,{"$f":"IF(B30=\"\", \"\", 'Expenses Form'!C14)","v":""},{"$f":"IF(B30=\"\", \"\", 'Expenses Form'!C14)","v":""},1]
["",{"$f":"LEFT('Expenses Form'!D15, 4)","v":""},{"$f":"UPPER(IF(B31=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E15,'Expenses Form'!$O$7)))","v":""},{"$f":"IF(B31=\"\", \"\", \"G00000\")","v":""},{"$f":"UPPER(IF(B31=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F15), \"NA\", 'Expenses Form'!F15),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B31=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G15), \"NA\", 'Expenses Form'!G15),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B31=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H15), \"NA\", 'Expenses Form'!H15),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B31=\"\", \"\", 'Expenses Form'!P15)","v":""},{"$f":"IF(B31=\"\", \"\", \"1004N\")","v":""},"",{"$f":"IF(B31=\"\", \"\", 'Expenses Form'!I15)","v":""},null,null,null,{"$f":"IF(B31=\"\", \"\", 'Expenses Form'!C15)","v":""},{"$f":"IF(B31=\"\", \"\", 'Expenses Form'!C15)","v":""},2]
[{"$f":"IF(B32=\"\", \"\", \"2;3\")","v":""},{"$f":"LEFT('Expenses Form'!D16, 4)","v":""},{"$f":"UPPER(IF(B32=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E16,'Expenses Form'!$O$7)))","v":""},{"$f":"IF(B32=\"\", \"\", \"G00000\")","v":""},{"$f":"UPPER(IF(B32=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F16), \"NA\", 'Expenses Form'!F16),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B32=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G16), \"NA\", 'Expenses Form'!G16),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B32=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H16), \"NA\", 'Expenses Form'!H16),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B32=\"\", \"\", 'Expenses Form'!P16)","v":""},{"$f":"IF(B32=\"\", \"\", \"1004N\")","v":""},"",{"$f":"IF(B32=\"\", \"\", 'Expenses Form'!I16)","v":""},null,null,null,{"$f":"IF(B32=\"\", \"\", 'Expenses Form'!C16)","v":""},{"$f":"IF(B32=\"\", \"\", 'Expenses Form'!C16)","v":""},3]
[{"$f":"IF(B33=\"\", \"\", \"2;3\")","v":""},{"$f":"LEFT('Expenses Form'!D17, 4)","v":""},{"$f":"UPPER(IF(B33=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E17,'Expenses Form'!$O$7)))","v":""},"",{"$f":"UPPER(IF(B33=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F17), \"NA\", 'Expenses Form'!F17),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B33=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G17), \"NA\", 'Expenses Form'!G17),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B33=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H17), \"NA\", 'Expenses Form'!H17),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B33=\"\", \"\", 'Expenses Form'!P17)","v":""},"","",{"$f":"IF(B33=\"\", \"\", 'Expenses Form'!I17)","v":""},null,null,null,{"$f":"IF(B33=\"\", \"\", 'Expenses Form'!C17)","v":""},{"$f":"IF(B33=\"\", \"\", 'Expenses Form'!C17)","v":""},4]
["",{"$f":"LEFT('Expenses Form'!D23, 4)","v":""},{"$f":"UPPER(IF(B34=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E23,'Expenses Form'!$O$7)))","v":""},{"$f":"IF(B34=\"\", \"\", \"G00000\")","v":""},{"$f":"UPPER(IF($B34=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F23), \"NA\", 'Expenses Form'!F23),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B34=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G23), \"NA\", 'Expenses Form'!G23),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B34=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H23), \"NA\", 'Expenses Form'!H23),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B34=\"\", \"\", 'Expenses Form'!P23)","v":""},"","",{"$f":"IF(B34=\"\", \"\", LEFT('Expenses Form'!I23&\"/\"&'Expenses Form'!J23, 50))","v":""},null,null,null,{"$f":"IF(B34=\"\", \"\", 'Expenses Form'!C23)","v":""},{"$f":"IF(B34=\"\", \"\", 'Expenses Form'!C23)","v":""},1]
[{"$f":"IF(B35=\"\", \"\", \"2;3\")","v":""},{"$f":"LEFT('Expenses Form'!D24, 4)","v":""},{"$f":"UPPER(IF(B35=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E24,'Expenses Form'!$O$7)))","v":""},{"$f":"IF(B35=\"\", \"\", \"G00000\")","v":""},{"$f":"UPPER(IF($B35=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F24), \"NA\", 'Expenses Form'!F24),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B35=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G24), \"NA\", 'Expenses Form'!G24),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B35=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H24), \"NA\", 'Expenses Form'!H24),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B35=\"\", \"\", 'Expenses Form'!P24)","v":""},{"$f":"IF(B35=\"\", \"\", \"1004N\")","v":""},"",{"$f":"IF(B35=\"\", \"\", LEFT('Expenses Form'!I24&\"/\"&'Expenses Form'!J24, 50))","v":""},null,null,null,{"$f":"IF(B35=\"\", \"\", 'Expenses Form'!C24)","v":""},{"$f":"IF(B35=\"\", \"\", 'Expenses Form'!C24)","v":""},2]
["",{"$f":"LEFT('Expenses Form'!D25, 4)","v":""},{"$f":"UPPER(IF(B36=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E25,'Expenses Form'!$O$7)))","v":""},"",{"$f":"UPPER(IF($B36=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F25), \"NA\", 'Expenses Form'!F25),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B36=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G25), \"NA\", 'Expenses Form'!G25),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B36=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H25), \"NA\", 'Expenses Form'!H25),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B36=\"\", \"\", 'Expenses Form'!P25)","v":""},"","",{"$f":"IF(B36=\"\", \"\", LEFT('Expenses Form'!I25&\"/\"&'Expenses Form'!J25, 50))","v":""},null,null,null,{"$f":"IF(B36=\"\", \"\", 'Expenses Form'!C25)","v":""},{"$f":"IF(B36=\"\", \"\", 'Expenses Form'!C25)","v":""},3]
["",{"$f":"LEFT('Expenses Form'!D26, 4)","v":""},{"$f":"UPPER(IF(B37=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E26,'Expenses Form'!$O$7)))","v":""},"",{"$f":"UPPER(IF($B37=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F26), \"NA\", 'Expenses Form'!F26),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B37=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G26), \"NA\", 'Expenses Form'!G26),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B37=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H26), \"NA\", 'Expenses Form'!H26),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B37=\"\", \"\", 'Expenses Form'!P26)","v":""},"","",{"$f":"IF(B37=\"\", \"\", LEFT('Expenses Form'!I26&\"/\"&'Expenses Form'!J26, 50))","v":""},null,null,null,{"$f":"IF(B37=\"\", \"\", 'Expenses Form'!C26)","v":""},{"$f":"IF(B37=\"\", \"\", 'Expenses Form'!C26)","v":""},4]
["",{"$f":"LEFT('Expenses Form'!D32, 4)","v":""},{"$f":"UPPER(IF(B38=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E32,'Expenses Form'!$O$7)))","v":""},"",{"$f":"UPPER(IF($B38=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F32), \"NA\", 'Expenses Form'!F32),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B38=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G32), \"NA\", 'Expenses Form'!G32),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B38=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H32), \"NA\", 'Expenses Form'!H32),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B38=\"\", \"\", 'Expenses Form'!P32)","v":""},"","",{"$f":"IF(B38=\"\", \"\",'Expenses Form'!K32)","v":""},null,{"$f":"IF(B38=\"\", \"\",'Expenses Form'!I32)","v":""},{"$f":"IF(B38=\"\", \"\",'Expenses Form'!J32)","v":""},{"$f":"IF(B38=\"\", \"\", 'Expenses Form'!C32)","v":""},{"$f":"IF(B38=\"\", \"\", 'Expenses Form'!C32)","v":""},1]
[{"$f":"IF(B39=\"\", \"\", \"2;3\")","v":""},{"$f":"LEFT('Expenses Form'!D33, 4)","v":""},{"$f":"UPPER(IF(B39=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E33,'Expenses Form'!$O$7)))","v":""},{"$f":"IF(B39=\"\", \"\", \"G00000\")","v":""},{"$f":"UPPER(IF($B39=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F33), \"NA\", 'Expenses Form'!F33),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B39=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G33), \"NA\", 'Expenses Form'!G33),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B39=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H33), \"NA\", 'Expenses Form'!H33),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B39=\"\", \"\", 'Expenses Form'!P33)","v":""},{"$f":"IF(B39=\"\", \"\", \"1004N\")","v":""},"",{"$f":"IF(B39=\"\", \"\",'Expenses Form'!K33)","v":""},null,{"$f":"IF(B39=\"\", \"\",'Expenses Form'!I33)","v":""},{"$f":"IF(B39=\"\", \"\",'Expenses Form'!J33)","v":""},{"$f":"IF(B39=\"\", \"\", 'Expenses Form'!C33)","v":""},{"$f":"IF(B39=\"\", \"\", 'Expenses Form'!C33)","v":""},2]
["",{"$f":"LEFT('Expenses Form'!D34, 4)","v":""},{"$f":"UPPER(IF(B40=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E34,'Expenses Form'!$O$7)))","v":""},"",{"$f":"UPPER(IF($B40=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F34), \"NA\", 'Expenses Form'!F34),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B40=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G34), \"NA\", 'Expenses Form'!G34),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B40=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H34), \"NA\", 'Expenses Form'!H34),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B40=\"\", \"\", 'Expenses Form'!P34)","v":""},"","",{"$f":"IF(B40=\"\", \"\",'Expenses Form'!K34)","v":""},null,{"$f":"IF(B40=\"\", \"\",'Expenses Form'!I34)","v":""},{"$f":"IF(B40=\"\", \"\",'Expenses Form'!J34)","v":""},{"$f":"IF(B40=\"\", \"\", 'Expenses Form'!C34)","v":""},{"$f":"IF(B40=\"\", \"\", 'Expenses Form'!C34)","v":""},3]
["",{"$f":"LEFT('Expenses Form'!D35, 4)","v":""},{"$f":"UPPER(IF(B41=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E35,'Expenses Form'!$O$7)))","v":""},"",{"$f":"UPPER(IF($B41=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F35), \"NA\", 'Expenses Form'!F35),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B41=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G35), \"NA\", 'Expenses Form'!G35),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B41=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H35), \"NA\", 'Expenses Form'!H35),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B41=\"\", \"\", 'Expenses Form'!P35)","v":""},"","",{"$f":"IF(B41=\"\", \"\",'Expenses Form'!K35)","v":""},null,{"$f":"IF(B41=\"\", \"\",'Expenses Form'!I35)","v":""},{"$f":"IF(B41=\"\", \"\",'Expenses Form'!J35)","v":""},{"$f":"IF(B41=\"\", \"\", 'Expenses Form'!C35)","v":""},{"$f":"IF(B41=\"\", \"\", 'Expenses Form'!C35)","v":""},4]
["",{"$f":"LEFT('Expenses Form'!D49, 4)","v":""},{"$f":"UPPER(IF(B42=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E49,'Expenses Form'!$O$7)))","v":""},"",{"$f":"UPPER(IF($B42=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F49), \"NA\", 'Expenses Form'!F49),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B42=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G49), \"NA\", 'Expenses Form'!G49),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B42=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H49), \"NA\", 'Expenses Form'!H49),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B42=\"\", \"\", 'Expenses Form'!P49)","v":""},"","",{"$f":"IF(B42=\"\", \"\", 'Expenses Form'!M49)","v":""},{"$f":"IF(B42=\"\", \"\", 'Expenses Form'!O49)","v":""},{"$f":"IF(B42=\"\", \"\",UPPER('Expenses Form'!J49)&\"/\"&'Expenses Form'!I49)","v":""},{"$f":"IF(B42=\"\", \"\",UPPER('Expenses Form'!L49)&\"/\"&'Expenses Form'!K49)","v":""},{"$f":"IF(B42=\"\", \"\", 'Expenses Form'!C49)","v":""},{"$f":"IF(B42=\"\", \"\", 'Expenses Form'!C49)","v":""},1]
[{"$f":"IF(B43=\"\", \"\", \"2;3\")","v":""},{"$f":"LEFT('Expenses Form'!D50, 4)","v":""},{"$f":"UPPER(IF(B43=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E50,'Expenses Form'!$O$7)))","v":""},{"$f":"IF(B43=\"\", \"\", \"G00000\")","v":""},{"$f":"UPPER(IF($B43=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F50), \"NA\", 'Expenses Form'!F50),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B43=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G50), \"NA\", 'Expenses Form'!G50),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B43=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H50), \"NA\", 'Expenses Form'!H50),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B43=\"\", \"\", 'Expenses Form'!P50)","v":""},{"$f":"IF(B43=\"\", \"\", \"1004N\")","v":""},"",{"$f":"IF(B43=\"\", \"\", 'Expenses Form'!M50)","v":""},{"$f":"IF(B43=\"\", \"\", 'Expenses Form'!O50)","v":""},{"$f":"IF(B43=\"\", \"\",UPPER('Expenses Form'!J50)&\"/\"&'Expenses Form'!I50)","v":""},{"$f":"IF(B43=\"\", \"\",UPPER('Expenses Form'!L50)&\"/\"&'Expenses Form'!K50)","v":""},{"$f":"IF(B43=\"\", \"\", 'Expenses Form'!C50)","v":""},{"$f":"IF(B43=\"\", \"\", 'Expenses Form'!C50)","v":""},2]
["",{"$f":"LEFT('Expenses Form'!D51, 4)","v":""},{"$f":"UPPER(IF(B44=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E51,'Expenses Form'!$O$7)))","v":""},"",{"$f":"UPPER(IF($B44=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F51), \"NA\", 'Expenses Form'!F51),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B44=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G51), \"NA\", 'Expenses Form'!G51),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B44=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H51), \"NA\", 'Expenses Form'!H51),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B44=\"\", \"\", 'Expenses Form'!P51)","v":""},"","",{"$f":"IF(B44=\"\", \"\", 'Expenses Form'!M51)","v":""},{"$f":"IF(B44=\"\", \"\", 'Expenses Form'!O51)","v":""},{"$f":"IF(B44=\"\", \"\",UPPER('Expenses Form'!J51)&\"/\"&'Expenses Form'!I51)","v":""},{"$f":"IF(B44=\"\", \"\",UPPER('Expenses Form'!L51)&\"/\"&'Expenses Form'!K51)","v":""},{"$f":"IF(B44=\"\", \"\", 'Expenses Form'!C51)","v":""},{"$f":"IF(B44=\"\", \"\", 'Expenses Form'!C51)","v":""},3]
["",{"$f":"LEFT('Expenses Form'!D52, 4)","v":""},{"$f":"UPPER(IF(B45=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$7), 'Expenses Form'!E52,'Expenses Form'!$O$7)))","v":""},"",{"$f":"UPPER(IF($B45=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$8), IF(ISBLANK('Expenses Form'!F52), \"NA\", 'Expenses Form'!F52),'Expenses Form'!$O$8)))","v":""},{"$f":"UPPER(IF($B45=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$9), IF(ISBLANK('Expenses Form'!G52), \"NA\", 'Expenses Form'!G52),'Expenses Form'!$O$9)))","v":""},{"$f":"UPPER(IF($B45=\"\", \"\", IF(ISBLANK('Expenses Form'!$O$10), IF(ISBLANK('Expenses Form'!H52), \"NA\", 'Expenses Form'!H52),'Expenses Form'!$O$10)))","v":""},{"$f":"IF(B45=\"\", \"\", 'Expenses Form'!P52)","v":""},"","",{"$f":"IF(B45=\"\", \"\", 'Expenses Form'!M52)","v":""},{"$f":"IF(B45=\"\", \"\", 'Expenses Form'!O52)","v":""},{"$f":"IF(B45=\"\", \"\",UPPER('Expenses Form'!J52)&\"/\"&'Expenses Form'!I52)","v":""},{"$f":"IF(B45=\"\", \"\",UPPER('Expenses Form'!L52)&\"/\"&'Expenses Form'!K52)","v":""},{"$f":"IF(B45=\"\", \"\", 'Expenses Form'!C52)","v":""},{"$f":"IF(B45=\"\", \"\", 'Expenses Form'!C52)","v":""},4]

{"sheet":"Ls_XLB_WorkbookFile","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Ls_AgXLB_WorkbookFile","index":7,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[">>Staff Expense Claim Import",">'lsd",">'[LASATA SETUP FILE]\r\nDate=2015-06-01 09:13:30\r\nFileType=Agora XML SendData\r\nVersion=0\r\nBuffer=\r\n@Agora XML SendData:Str=@STARTBLOCK\r\nsetupFileVersion:2=1\r\nAbortIfErrorsExist:2=1\r\nAppendFile:2=0\r\nRunScript:2=1\r\nDatabaseOrig:8=\r\nDefinitionName:8=Ledger Import\r\nDefinitionVersion:4=2\r\nErrorReference:8=I23\r\nCommentReference:8=I24\r\nMatrixSend:11=0\r\nSkipBlanks:11=-1\r\nCSVDelimeter:8=\r\nCSVIncludeHeader:2=0\r\nMatrixReplicatorFieldOverrideNodePath:8=/LI Header/LI Detail/PERD\r\nDriverFieldOverrideNodePath:8=/LI Header/CREATED_DATETIME\r\nLanguage:8=\r\nOutputFileNameOrig:8=\r\nSetupFileNameOrig:8=\r\nSetupFileType:2=2\r\nShowMessages:2=1\r\nWorkBookSetupFileOrig:8=Staff Expense Claim Import\r\nLayoutIdetifierColumn:8=A2\r\nProduct:8=SS5\r\nSuperFieldKey:8=DbC\r\nSuperFieldValue:8=$C$22\r\nFieldValueCodePath:8=/LI Header/LI Detail/ACNT_CODE\r\nFieldValueValue:8=B8\r\nFieldValueCodePath:8=/LI Header/LI Detail/PERD\r\nFieldValueValue:8=PA  +0\r\nFieldValueCodePath:8=/LI Header/LI Detail/TXN_DATETIME\r\nFieldValueValue:8=$C$25\r\nFieldValueCodePath:8=/LI Header/LI Detail/JNL_SRCE\r\nFieldValueValue:8=$C$21\r\nFieldValueCodePath:8=/LI Header/LI Detail/TXN_REF\r\nFieldValueValue:8=$C$24\r\nFieldValueCodePath:8=/LI Header/LI Detail/AMT\r\nFieldValueValue:8=H8\r\nFieldValueCodePath:8=/LI Header/LI Detail/DESCR\r\nFieldValueValue:8=K8\r\nFieldValueCodePath:8=/LI Header/LI Detail/DR_CR_IND\r\nFieldValueValue:8=\r\nFieldValueCodePath:8=/LI Header/LI Detail/MEMO_AMT\r\nFieldValueValue:8=L8\r\nFieldValueCodePath:8=/LI Header/LI Detail/ANL_CODE_T0\r\nFieldValueValue:8=C8\r\nFieldValueCodePath:8=/LI Header/LI Detail/ANL_CODE_T1\r\nFieldValueValue:8=D8\r\nFieldValueCodePath:8=/LI Header/LI Detail/ANL_CODE_T2\r\nFieldValueValue:8=NA\r\nFieldValueCodePath:8=/LI Header/LI Detail/ANL_CODE_T3\r\nFieldValueValue:8=E8\r\nFieldValueCodePath:8=/LI Header/LI Detail/ANL_CODE_T4\r\nFieldValueValue:8=F8\r\nFieldValueCodePath:8=/LI Header/LI Detail/ANL_CODE_T5\r\nFieldValueValue:8=G8\r\nFieldValueCodePath:8=/LI Header/LI Detail/ANL_CODE_T6\r\nFieldValueValue:8=I8\r\nFieldValueCodePath:8=/LI Header/LI Detail/LI Detail LAD/PSTG_HDR_ID\r\nFieldValueValue:8=\r\nFieldValueCodePath:8=/LI Header/LI Detail/LI Detail LAD/GNRL_DESCR_02\r\nFieldValueValue:8=M8\r\nFieldValueCodePath:8=/LI Header/LI Detail/LI Detail LAD/GNRL_DESCR_03\r\nFieldValueValue:8=N8\r\nFieldValueCodePath:8=/LI Header/LI Detail/LI Detail LAD/GNRL_1_DATETIME\r\nFieldValueValue:8=O8\r\nFieldValueCodePath:8=/LI Header/LI Detail/LI Detail LAD/GNRL_2_DATETIME\r\nFieldValueValue:8=P8\r\nFieldValueCodePath:8=/LI Header/CREATED_DATETIME\r\nFieldValueValue:8=DATE \r\nFieldValueCodePath:8=/LI Header/DESCR\r\nFieldValueValue:8=$C$24\r\nFieldValueCodePath:8=/LI Header/POST_TYPE\r\nFieldValueValue:8=2\r\nFieldValueCodePath:8=/LI Header/POST_WRITE_TO_HOLD\r\nFieldValueValue:8=N\r\nFieldValueCodePath:8=/LI Header/POST_ROUGH_BOOK\r\nFieldValueValue:8=N\r\nFieldValueCodePath:8=/LI Header/POST_ALLOW_BAL_TRANS\r\nFieldValueValue:8=0\r\nFieldValueCodePath:8=/LI Header/POST_RPT_ERR_ONLY\r\nFieldValueValue:8=Y\r\nFieldValueCodePath:8=/LI Header/POST_RPT_FMT\r\nFieldValueValue:8=Z_LIALL\r\nFieldValueCodePath:8=/LI Header/POST_SUPPRESS_SUB_MSG\r\nFieldValueValue:8=N\r\nFieldValueCodePath:8=/LI Header/JRNL_TYPE\r\nFieldValueValue:8=$C$23\r\nFieldValueCodePath:8=/LI Header/LI Detail/ANL_CODE_T8\r\nFieldValueValue:8=\r\nFieldValueCodePath:8=/LI Header/LI Detail/ANL_CODE_T7\r\nFieldValueValue:8=J8\r\nFieldValueCodePath:8=/LI Header/LI Detail/LI Detail LAD/GNRL_DESCR_12\r\nFieldValueValue:8=$C$26\r\nFieldValueCodePath:8=/LI Header/LI Detail/LI Detail LAD/GNRL_5_DATETIME\r\nFieldValueValue:8=$F$26\r\nParam1:8=@START\r\nInternalName:8=IsCheckBalances\r\nValueFrom:8=N\r\nValueTo:8=\r\n\r\n@END\r\nZeroRecordCount:3=0\r\nNonZeroRecordCount:3=0\r\n\r\n@ENDBLOCK\r\n"]
[">>Import Expense Claim Form",">'axb",">'[LASATA SETUP FILE]\r\nDate=2014-05-27 18:10:31\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=Expense_Import\r\n@settngMacroButtonCaption:Str=Send Data to SunSystems\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_RunDataSend_52718094465000:Str=P0=Staff Expense Claim Import,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Import Expense Claim Form\r\n"]
[">>Refresh worksheet",">'axb",">'[LASATA SETUP FILE]\r\nDate=2014-05-27 18:17:44\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=Recalculate_Import\r\n@settngMacroButtonCaption:Str=Check Supplier Account\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_RecalculateWorksheet_52718165605000:Str=P0=[Expenses Form Rebuild 27-05-14.xlsm]Import,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Refresh worksheet\r\n"]
[">>Import_Expenses",">'axb",">'[LASATA SETUP FILE]\r\nDate=2014-05-27 18:46:31\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=Import_Expenses\r\n@settngMacroButtonCaption:Str=Send Data to SunSystems\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_RunDataSend_52718460610000:Str=P0=Staff Expense Claim Import,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Import_Expenses\r\n"]
[">>Update Import File",">'axb",">'[LASATA SETUP FILE]\r\nDate=2014-05-28 10:26:25\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=Recalculate_Worksheet\r\n@settngMacroButtonCaption:Str=Update Import File\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_RecalculateWorksheet_52810254359000:Str=P0=[Expenses Form Rebuild 27-05-14.xlsm]Import,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Update Import File\r\n"]