{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Cost Centres (2)","Front Page","Capital Details Instruction VA","Capital Details Instructions","Capital Form","Adjustment Form Instructions","End of Yr Adjustment Form","Example Yr End Adjustment","Bank Movement Instructions","Bank Movement Form","Drop down options","Example Bank Movement Form","Integra Upload","Drs & Crs Analysis","cost centres","Cost Centres ","LOOK UPS","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":5,"defined_names":8,"comments":3,"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":"Cost Centres (2)","index":0,"n_rows":117,"n_cols":3,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
[]
["SAP Cost Centre","School","DfES NO."]
[]
[10040,"All Saints' CE School (NW2)",3300]
[10042,"All Saints' CE School (N20)",3317]
[10043,"Annunciation RC Infant School",3500]
[10044,"Barnfield School",2002]
[10045,"Bell Lane School",2003]
[10046,"Brookland Junior School",2007]
[10047,"Brookland Infant School",2008]
[10048,"Brunswick Park School",2009]
[10049,"Childs Hill School",2010]
[10050,"Christ Church CE School",3302]
[10051,"Church Hill School",2011]
[10054,"Colindale School",2014]
[10055,"Coppetts Wood School",2015]
[10056,"Courtland School",2016]
[10057,"Cromer Road School",2017]
[10058,"Deansbrook Junior School",2018]
[10059,"Deansbrook Infant School",2019]
[10060,"Dollis Junior School",5200]
[10061,"Dollis Infant School",2021]
[10062,"Edgware Junior School",2022]
[10063,"Edgware Infant School",2023]
[10064,"Fairway School",2024]
[10065,"Foulds School",2025]
[10066,"Frith Manor School",2026]
[10067,"Garden Suburb Junior School",2027]
[10068,"Garden Suburb Infant School",2028]
[10069,"Goldbeaters School",2029]
[10070,"Grasvenor Avenue Infant School",2030]
[10071,"Hollickwood School",2031]
[10072,"Holly Park School",2032]
[10073,"Holy Trinity CE School",3304]
[10074,"Livingstone School",2036]
[10075,"Manorside School ",2037]
[10076,"Martin Junior School",2039]
[10077,"Martin Infant School",2040]
[10078,"Monken Hadley CE School",3305]
[10079,"Monkfrith School",2042]
[10080,"Moss Hall Junior School",2043]
[10081,"Moss Hall Infant School",2044]
[10082,"Northside School",2045]
[10083,"Danegrove School",2073]
[10084,"Osidge School",5201]
[10085,"Our Lady of Lourdes RC School",3501]
[10086,"Queenswell Junior School",2072]
[10087,"St. Agnes' RC School",3502]
[10088,"St. Catherine's RC School",3504]
[10089,"St. John's CE School (N11)",3307]
[10092,"St. Mary's CE School (N3)",3311]
[10093,"St. Mary's CE School (EN4)",3312]
[10094,"St. Paul's CE School (N11)",3313]
[10095,"St. Paul's CE School (NW7)",3314]
[10096,"St. Vincent's RC School",3506]
[10097,"Sunnyfields School",2070]
[10098,"Summerside School ",2052]
[10099,"St. Andrew's CE School",3315]
[10100,"Trent CE School",3316]
[10101,"Tudor School",2055]
[10102,"Underhill Junior School",2056]
[10103,"Underhill Infant School",2057]
[10105,"Whitings Hill School",2060]
[10106,"Independent Jewish Day School",3515]
[10107,"St. Joseph's RC Junior School",3509]
[10108,"St. Theresa's RC School",3507]
[10109,"Woodridge School",2054]
[10110,"Sacred Heart RC School",3510]
[10111,"St. Joseph's RC Infant School",3508]
[10112,"Rosh Pinah School",3512]
[10113,"Barnet Hill School",2064]
[10114,"Menorah Primary School",3513]
[10115,"Blessed Dominic RC School",3511]
[10116,"St. John's CE School (N20)",3309]
[10117,"Annunciation RC Junior School",3514]
[10118,"Chalgrove School",2067]
[10119,"Queenswell Infant School",2071]
[10120,"Parkfield School",2000]
[10121,"Hasmonean Primary School",3516]
[10122,"Hyde School",2074]
[10123,"Woodcroft Primary",3518]
[10124,"Wessex Gardens School",2076]
[10125,"Mathilda Marks Kennedy School",5948]
[10126,"Menorah Foundation School",5949]
[10127,"Orion School",2077]
[10128,"Beis Yaakov",2079]
[10129,"Pardes House School",2078]
[10130,"Brookhill Nursery",1000]
[10131,"Hampden Way Nursery",1001]
[10132,"Moss Hall Nursery",1002]
[10133,"St Margaret's Nursery",1003]
[10134,"Broadfields Primary",3519]
[10136,"Ashmole School",5406]
[10137,"Bishop Douglass RC High",5408]
[10138,"Compton School",4215]
[10139,"Friern Barnet School",4003]
[10140,"Mill Hill High School",5402]
[10141,"Ravenscroft School",4009]
[10142,"St James' Catholic High School",5407]
[10143,"St Mary's CE High School ",5403]
[10144,"Whitefield School",4012]
[10145,"Finchley Catholic High School",5405]
[10146,"Hasmonean High School",5409]
[10147,"Henrietta Barnett School ",4752]
[10148,"St. Michael's Catholic Grammar School",5404]
[10149,"Queen Elizabeth's School, Barnet",5401]
[10150,"Hendon School",5400]
[10151,"Christ's College ",4211]
[10152,"Copthall School",4210]
[10153,"East Barnet School",4212]
[10154,"Queen Elizabeth's Girls' School",4208]
[10156,"Oak Lodge School",7000]
[10157,"Northway School",7005]
[10158,"Oakleigh School",7009]
[10159,"Mapledown School",7010]
[10698,"St. Mary's & St. Johns Primary",3521]
[10953,"Claremont Primary School",3522]

{"sheet":"Front Page","index":1,"n_rows":98,"n_cols":27,"rows_kept":98,"cut":false,"hidden":false,"merged":[[28,11,28,14],[0,7,0,11],[1,7,1,11],[1,13,1,15],[2,13,2,15],[19,12,24,14],[8,12,16,14],[5,2,5,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please choose your School"]
[null,null,null,null,null,null,null,"Please choose your School",null,null,null,null,null,"2017/18 END OF YEAR FORMS",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(H2,Z:AA,2,0)","v":0},null,"Brookhill Nursery",10130]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2018-03-07T15:15:12.720"},null,null,null,null,null,null,null,null,null,null,null,"Hampden Way Nursery",10131]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moss Hall Nursery",10132]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St Margaret's Nursery",10133]
[null,null,"To be submitted by Monday 23rd April 2018",null,null,null,null,null,null,null,null,null,"Notes:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Akiva",11094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Saints' CE School (N20)",10042]
[null,null,null,null,null,null,null,null,null,null,null,null,"Once completed, save this file to your computer in an EXCEL FORMAT renaming it \"school name\"  Analysis of Bank Movement 2017-18. Once saved, this file should be attached to an email and returned  to schools.accountancy@barnet.gov.uk by Monday 23rd April 2018.",null,null,null,null,null,null,null,null,null,null,null,null,"All Saints' CE School (NW2)",10040]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annunciation RC Infant School",10043]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annunciation RC Junior School",10117]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Barnfield School",10044]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beis Yaakov",10128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beit Shvidler Primary School",11278]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bell Lane School",10045]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blessed Dominic RC School",10115]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brookland Infant School",10047]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brookland Junior School",10046]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brunswick Park School",10048]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chalgrove School",10118]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Childs Hill School",10049]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Christ Church CE School",10050]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Church Hill School",10051]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colindale School",10054]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coppetts Wood School",10055]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Courtland School",10056]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cromer Road School",10057]
[null,null,"Schools Accountancy Section",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Danegrove School",10083]
[null,null,"Claudette James 020 8359 7132",null,null,null,"Priscilla Williams 020 8359 2773",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deansbrook Infant School",10059]
[null,null,"Nicole Gibson 020 8359 7223",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dollis Infant School",10061]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dollis Junior School",10060]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Edgware Primary School",10063]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fairway School",10064]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Foulds School",10065]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frith Manor School",10066]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Garden Suburb Infant School",10068]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Garden Suburb Junior School",10067]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Goldbeaters School",10069]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hasmonean Primary School",10121]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hollickwood School",10071]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Holly Park School",10072]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Holy Trinity CE School",10073]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Livingstone School",10074]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manorside School ",10075]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Martin Primary",11093]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mathilda Marks Kennedy School",10125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Menorah Foundation School",10126]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Menorah Primary School",10114]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monken Hadley CE School",10078]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monkfrith School",10079]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moss Hall Infant School",10081]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moss Hall Junior School",10080]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northside School",10082]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orion School",10127]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Osidge School",10084]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Our Lady of Lourdes RC School",10085]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pardes House School",10129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Queenswell Infant School",10119]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Queenswell Junior School",10086]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rosh Pinah School",10112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sacks Morasha",11381]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sacred Heart RC School",10110]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Agnes' RC School",10087]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Andrew's CE School",10099]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Catherine's RC School",10088]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. John's CE School (N11)",10089]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. John's CE School (N20)",10116]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Joseph's RC Primary School",10107]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Mary's & St. Johns Primary",10698]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Mary's CE School (EN4)",10093]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Mary's CE School (N3)",10092]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Paul's CE School (N11)",10094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Paul's CE School (NW7)",10095]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Theresa's RC School",10108]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Vincent's RC School",10096]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summerside School ",10098]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sunnyfields School",10097]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trent CE School",10100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tudor School",10101]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Underhill School",10103]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wessex Gardens School",10124]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whitings Hill School",10105]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woodcroft Primary",10123]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woodridge School",10109]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Finchley Catholic High School",10145]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Friern Barnet School",10139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JCOSS",11174]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Menorah High",11513]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St James' Catholic High School",10142]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Michael's Catholic Grammar School",10148]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mapledown",10159]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northway",10157]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oakleigh",10158]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oak Lodge ",10156]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northgate",10185]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pavilion",10188]

{"sheet":"Capital Details Instruction VA","index":2,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Instructions for completion of the Capital Detail Form - VA and Foundation schools only"]
["Background"]
["The Governing Body of a VA school are responsible for meeting all capital expenditure"]
["Therefore all capital transactions should should be processed in the governing body's accounts."]
["If capital expenditure is accounted for in the Council's accounts for a VA school, this could lead to these assets being erroneously included in the Council's assets. "]
[]
["The only exception are loose ICT items"]
["Therefore there should not be any transactions on the following codes:"]
["CI01, CI03, CE01, CE02, CE03"]
["Loose ICT items may be coded in:"]
["CI04 from DRF E30 and CE04"]
[]
[]
[]
["Expenditure on the Capital Detail form"]
["CE04  Capital ICT purchases"]
[]
["Once the total expenditure is established this total must be broken down into projects."]
["Please indicate whether the projects are complete, both in terms of the work and financially."]
["This is the information needed to complete the expenditure part of the Capital Return."]
[]
["Income/Funding in the Capital Detail form"]
["Schools should use CI04 Direct Revenue Financing Income"]
[]
["Balances C/f"]
["VA schools should not have any balaces to carry forward on this form.  "]
["The funding and expenditure for loose ICT should match."]
[]
[]
["If you have any problems completing these forms please contact Schools' Accountancy on "]
["020 8359 7132/7223/2773"]

{"sheet":"Capital Details Instructions","index":3,"n_rows":41,"n_cols":1,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Instructions for completion of the Capital Detail Form Community Schools only"]
["Background"]
[]
["The LA require details of all schools capital projects and how they were funded for the following reasons."]
["1. To ensure there is a complete record of the LA assets for inclusion in the LA accounts."]
["2. To enable the LA to certify to the DfE that the Devolved Formula Capital Grant, which has been devolved to schools "]
["has been spent within the permitted three years and five months."]
[]
["Instructions"]
[]
["Expenditure"]
["Schools must interrogate their local accounting systems to ascertain the levels of capital expenditure for the "]
["completed financial year 2017/18. The CFR codes relating to capital expenditure are;"]
["CE01 Acquisition of land and buildings"]
["CE02 New Construction, conversion & renovation"]
["CE03 Purchase of Vehicles, equipment & machinery"]
["CE04 Capital ICT purchases"]
[]
["Once the total expenditure for each code is established these totals must be broken down into projects."]
["Please indicate whether the projects are complete, both in terms of the work and financially."]
["This is the information needed to complete the expenditure part of the Capital Return."]
[]
["Income/Funding"]
["Schools must look at their 'Total Capital Resources' available in 2017/18, break it down into b/f balances and  "]
["in year sources of income, then decide from which of these sources/balances the 2017/18 capital projects were funded. "]
["The CFR codes relating to capital funding are"]
["B03 B/F Devolved Formula Capital balances"]
["B05 Other Capital Balances B/F ie Private Income & Direct Revenue Financing income"]
["CI01 Capital Income from Public Sources"]
["CI03 Private Capital Income"]
["CI04 Direct Revenue Financing Income"]
[]
["This is the information needed to complete the 'Funded by' part of the Capital Return."]
[]
["Balances C/f"]
["Schools must work out how the balances carried forward are made up. They may be made up of Devolved Formula Capital"]
["allocations from 2015/16 & 2016/17, 2017/18. Any other Capital Funding received from Public Sources, Private Capital"]
["Income and any Direct Revenue Financing transfers which have yet to be expensed."]
[]
["If you have any problems completing these forms please contact Schools' Accountancy on "]
["020 8359 7132/7223/2773"]

{"sheet":"Capital Form","index":4,"n_rows":128,"n_cols":17,"rows_kept":128,"cut":false,"hidden":false,"merged":[[2,2,2,4],[7,6,8,6],[15,6,16,6],[18,6,19,6],[21,6,22,6],[92,2,92,3],[30,6,31,6],[52,6,53,6],[55,6,56,6],[49,6,50,6],[24,6,25,6],[27,6,28,6],[24,8,25,8],[27,8,28,8],[55,8,56,8],[38,8,39,8],[30,8,31,8],[41,8,42,8],[44,8,45,8],[41,6,42,6],[38,6,39,6],[44,6,45,6],[7,8,8,8],[15,8,16,8],[18,8,19,8],[49,8,50,8],[52,8,53,8]]}
["Capital Expenditure & Funding 2017/18 - Details ",null,null,null,null,null,{"$f":"+'Front Page'!X2","v":0}]
[null,null,null,null,null,null,null,null,null,"Please choose your school",null,null,null,"Complete"]
[null,null,"School name",null,null,null,null,null,null,"Brookhill Nursery","Nursery","Community",null,"Incomplete"]
[null,null,null,null,null,"Is this a \"Nil Return\"? - please select Yes or No in box",null,null,null,"Hampden Way Nursery ","Nursery","Community"]
["Expenditure",null,null,null,null,null,null,null,null,"Moss Hall Nursery","Nursery","Community",null,null,null,null,"Yes"]
["Where expenditure is recorded please provide details of the acquisition",null,null,null,null,null,null,null,null,"St Margaret's Nursery ","Nursery","Community",null,null,null,null,"No"]
[null,null,null,null,"Amount £'s","Description","Work Complete/Incomplete?",null,"Financially Complete/Incomplete?"]
["CE01","Acquisition of land & existing buildings",null,null,0,"Project 1 - ",null,null,null,"Akiva","Primary","VA"]
["CE01","Total",0,null,null,null,null,null,null,"All Saints N20","Primary","VA"]
[null,null,null,null,null,null,null,null,null,"All Saints NW2","Primary","VA"]
["Does the total spent on CE01 and the",null,null,null,null,null,null,null,null,"Annunciation Inf","Primary","VA"]
["projects for CE01 balance? ",null,null,null,{"$f":"IF(C9-E8,\"False\",\"True\")","v":"True"},null,null,null,null,"Annunciation Jun","Primary","VA"]
[null,null,null,null,null,null,null,null,null,"Barnet Hill","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Barnfield","Primary","Community"]
["Where expenditure is recorded please provide details of the work carried out and to which building",null,null,null,null,null,null,null,null,"Beis Yaakov","Primary","VA"," Once you have completed the forms please save as  your \"school name\"  & \"EOY Forms 2017-18\" in an EXCEL FORMAT and return via email to schools.accountancy@barnet.gov.uk  "]
["CE02","New Construction, conversion ",null,null,0,"Project 1 -",null,null,null,"Bell Lane ","Primary","Community"]
[null,"& renovation",null,null,null,null,null,null,null,"Blessed Dominic","Primary","VA"]
["CE02","Total",0,null,null,null,null,null,null,"Broadfields Primary","Primary","Community"]
[null,null,null,null,0,"Project 2 - ",null,null,null,"Brookland Infants","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Brookland Juniors","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Chalgrove","Primary","Community"]
[null,null,null,null,0,"Project 3 - ",null,null,null,"Childs Hill","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Christchurch JMI","Primary","VA"]
[null,null,null,null,null,null,null,null,null,"Church Hill","Primary","Community"]
[null,null,null,null,0,"Project 4 - ",null,null,null,"Claremont Primary ","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Colindale","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Coppetts Wood","Primary","Community"]
[null,null,null,null,0,"Project 5 - ",null,null,null,"Coppetts Wood","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Courtland","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Courtland","Primary","Community"]
[null,null,null,null,0,"Project 6 - ",null,null,null,"Cromer Road","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Cromer Road","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Danegrove","Primary","Community"]
["Does the total spent on CE02 and the",null,null,null,null,null,null,null,null,"Danegrove","Primary","Community"]
["projects for CE02 balance? ",null,null,null,{"$f":"IF(C18-E25-E22-E19-E16-E28-E31,\"False\",\"True\")","v":"True"},null,null,null,null,"Deansbrook Inf","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Deansbrook Inf","Primary","Community"]
["Where expenditure is recorded please provide details of the asset purchased",null,null,null,null,null,null,null,null,"Deansbrook Jun","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Deansbrook Jun","Primary","Community"]
["CE03 ","Vehicles, equipment & machinery",null,null,0,"Project 1 - ",null,null,null,"Dollis Inf ","Primary","Community"]
["CE03 ","Total",0,null,null,null,null,null,null,"Dollis Inf ","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Dollis Junior ","Primary","Foundation"]
[null,null,null,null,0,"Project 2 - ",null,null,null,"Dollis Junior ","Primary","Foundation"]
[null,null,null,null,null,null,null,null,null,"Edgware Inf","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Edgware Jun","Primary","Community"]
[null,null,null,null,0,"Project 3 - ",null,null,null,"Fairway","Primary","Community"]
["Does the total spent on CE03 and the",null,null,null,null,null,null,null,null,"Foulds","Primary","Community"]
["projects for CE03 balance? ",null,null,null,{"$f":"IF(C40-E45-E42-E39,\"False\",\"True\")","v":"True"},null,null,null,null,"Frith Manor","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Garden Suburb Inf","Primary","Community"]
["Where expenditure is recorded please provide details of the ICT equipment purchased",null,null,null,null,null,null,null,null,"Garden Suburb Jnr","Primary","Community"]
["CE04","Capital ICT ",null,null,0,"Project 1 - ",null,null,null,"Goldbeaters","Primary","Community"]
["CE04","Total",0,null,null,null,null,null,null,"Grasvenor Avenue Inf","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Hasmonean Primary","Primary","VA"]
[null,null,null,null,0,"Project 2 - ",null,null,null,"Holly Park","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Holy Trinity","Primary","VA"]
[null,null,null,null,null,null,null,null,null,"Hyde","Primary","Community"]
[null,null,null,null,0,"Project 3 - ",null,null,null,"Independent Jewish ","Primary","VA"]
["Does the total spent on CE04 and the",null,null,null,null,null,null,null,null,"Livingstone","Primary","Community"]
["projects for CE04 balance? ",null,null,null,{"$f":"IF(C51-E56-E53-E50,\"False\",\"True\")","v":"True"},null,null,null,null,"Manorside","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Martin Primary School ","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Mathilda Marks Kennedy","Primary","VA"]
["Funded by",null,null,null,null,null,null,null,null,"Menorah Foundation ","Primary","VA"]
[null,null,null,null,null,null,null,null,null,"Menorah Primary ","Primary","VA"]
["Please give details below of the funding sources used to fund the capital projects listed above",null,null,null,null,null,null,null,null,"Monken Hadley CE","Primary","VA"]
[null,null,null,null,null,null,null,null,null,"Monkfrith","Primary","Community"]
["Total capital expenditure as listed above",null,null,null,{"$f":"C51+C40+C18+C9","v":0},null,null,null,null,"Moss Hall Inf","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Moss Hall Jun","Primary","Community"]
["CFR Code","Description",null,null,null,null,null,null,null,"Northside","Primary","Community"]
["B03","B/f DFC balance 2015/16",null,null,0,null,null,null,null,"Orion","Primary","Community"]
["B03","B/f DFC balance 2016/17",null,null,0,null,null,null,null,"Osidge JMI","Primary","Foundation"]
["B04","DFC balance 2017/18",null,null,0]
["B04","B/f Standards Fund Capital Bal (Not DFC)",null,null,0,null,null,null,null,"Our Lady of Lourdes","Primary","VA"]
["B05","B/f Private Capital Income",null,null,0,null,null,null,null,"Pardes House ","Primary","VA"]
["B05","B/f Direct Revenue Financing",null,null,0,null,null,null,null,"Parkfield","Primary","Community"]
["CI01","2017/18 DFC ",null,null,0,null,null,null,null,"Queenswell Inf","Primary","Community"]
["CI03","2017/18 Private Capital Income",null,null,0,null,null,null,null,"Queenswell Jun","Primary","Community"]
["CI04","2017/18 Direct Revenue Financing",null,null,0,null,null,null,null,"Rosh Pinah","Primary","VA"]
[null,"Total",null,null,{"$f":"SUM(E68:E76)","v":0},null,null,null,null,"Sacred Heart","Primary","VA"]
[null,null,null,null,null,null,null,null,null,"St Agnes RC","Primary","VA"]
["Does the total capital expenditure equal the ",null,null,null,null,null,null,null,null,"St Andrews CE","Primary","VA"]
["total 'funded by' amount? ",null,null,null,{"$f":"IF(E77-E65,\"False\",\"True\")","v":"True"},null,null,null,null,"St Catherines RC","Primary","VA"]
[null,null,null,null,null,null,null,null,null,"St Johns CE N11","Primary","VA"]
["Please give details below of carried forward capital balances",null,null,null,null,null,null,null,null,"St Johns CE N20","Primary","VA"]
[null,null,null,null,null,null,null,null,null,"St Josephs RC Inf","Primary","VA"]
["CFR Code","Description",null,null,null,null,null,null,null,"St Josephs RC Jun","Primary","VA"]
["B03","C/f 2015/16 DFC",null,null,0,"Note: Any DFC balance from 2015/16 must be spent by August 2018",null,null,null,"St Mary's & St Johns Primary","Primary","VA"]
["B03","C/f 2016/17 DFC",null,null,0,null,null,null,null,"St Marys CE EB","Primary","VA"]
["B03","C/f 2017/18 DFC",null,null,0,null,null,null,null,"St Marys CE N3","Primary","VA"]
["B05","C/f Private Capital Income",null,null,0,null,null,null,null,"St Pauls CE NW7","Primary","VA"]
["B05","C/f Direct Revenue Financing",null,null,0,null,null,null,null,"St Theresas RC","Primary","VA"]
[null,"Total Balance C/f to 2018/19",null,null,{"$f":"SUM(E85:E89)","v":0},null,null,null,null,"St Vincents RC","Primary","VA"]
[null,null,null,null,null,null,null,null,null,"Summerside","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Sunnyfields","Primary","Community"]
[null,"Date",null,null,"Authorised by",null,null,null,null,"Trent","Primary","VA"]
[null,null,null,null,null,null,null,null,null,"Tudor","Primary","Community"]
[null,null,null,null,null,"note:",null,null,null,"Underhill Inf       ","Primary","Community"]
[null,null,null,null,null,"This form needs Head teacher authorisation but the signed ",null,null,null,"Underhill Jun","Primary","Community"]
[null,null,null,null,null,"copy should stay in school for audit puposes.",null,null,null,"Wessex Gardens ","Primary","Community"]
[null,null,null,null,null,null,null,null,null,"Whitings Hill","Primary","Community"]
["Please complete all yellow boxes and return to Schools Accountancy Section by email to schools.accountancy@barnet.gov.uk ",null,null,null,null,null,null,null,null,"Woodcroft Primary","Primary","Community"]
["by 28th March 2018",null,null,null,null,null,null,null,null,"Woodridge","Primary","Community"]
[]
[null,null,null,null,null,null,null,null,null,"Ashmole","Secondary","Foundation"]
[null,null,null,null,null,null,null,null,null,"Bishop Douglass","Secondary","VA"]
[null,null,null,null,null,null,null,null,null,"Christs College Finchley","Secondary","Community"]
[null,null,null,null,null,null,null,null,null,"Copthall","Secondary","Community"]
[null,null,null,null,null,null,null,null,null,"Copthall","Secondary","Community"]
[null,null,null,null,null,null,null,null,null,"East Barnet","Secondary","Community"]
[null,null,null,null,null,null,null,null,null,"East Barnet","Secondary","Community"]
[null,null,null,null,null,null,null,null,null,"Finchley Catholic High","Secondary","VA"]
[null,null,null,null,null,null,null,null,null,"Friern Barnet ","Secondary","Community"]
[null,null,null,null,null,null,null,null,null,"Hasmonean High ","Secondary","VA"]
[null,null,null,null,null,null,null,null,null,"Hendon","Secondary","Foundation"]
[null,null,null,null,null,null,null,null,null,"Henrietta Barnett","Secondary","VA"]
[null,null,null,null,null,null,null,null,null,"JCoSS","Secondary","VA"]
[null,null,null,null,null,null,null,null,null,"Mill Hill High","Secondary","Foundation"]
[null,null,null,null,null,null,null,null,null,"Queen Elizabeth's Girls' ","Secondary","Community"]
[null,null,null,null,null,null,null,null,null,"Queens Elizabeth's School Barnet","Secondary","Foundation"]
[null,null,null,null,null,null,null,null,null,"Ravenscroft","Secondary","Community"]
[null,null,null,null,null,null,null,null,null,"St James' Catholic High","Secondary","VA"]
[null,null,null,null,null,null,null,null,null,"St Mary's C E High","Secondary","VA"]
[null,null,null,null,null,null,null,null,null,"St Michaels Cath Gram","Secondary","VA"]
[null,null,null,null,null,null,null,null,null,"The Compton","Secondary","Community"]
[null,null,null,null,null,null,null,null,null,"Whitefield","Secondary","Community"]
[]
[null,null,null,null,null,null,null,null,null,"Mapledown","Special","Community"]
[null,null,null,null,null,null,null,null,null,"Northway","Special","Community"]
[null,null,null,null,null,null,null,null,null,"Oak Lodge","Special","Community"]
[null,null,null,null,null,null,null,null,null,"Oakleigh","Special","Community"]

{"sheet":"Adjustment Form Instructions","index":5,"n_rows":30,"n_cols":1,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Instructions for completion of the End of Year Adjustment Form"]
[]
[]
["COMPLETING ACCRUAL FORM"]
["STEP 1 - Schools details"]
["·         Choose your School from the drop down menu"]
["·         The School’s Cost Centre number will automatically populate"]
["·         Complete the Preparer’s details (name, email, telephone no.)"]
["·         The Authoriser should sign the form once it has been completed"]
["STEP 2 – Transaction details to be entered"]
["·         Choose the type of adjustment using the drop down list (column A)"]
["·         Who authorised the transaction (column B)"]
["·         Enter the Supplier or Customer name (column C)"]
["·         Enter the invoice number or reference details (column D)"]
["·         Enter a description of the transaction (column E)"]
["·         Enter the date the services were received / to be received or, services provided / to be provided (column F)"]
["·         Enter the value of the adjustment.  You will not be able to enter a value less than £1,000. (column G)"]
["·         You will need to state whether the value is an actual or estimated in (column H)"]
["·         Next, you will need to classify the EOY adjustment using the drop down list (column I)"]
["An explanation of classifications can be found at the end of the form."]
["If you are unsure which classification to choose, please contact Schools Accountancy for assistance."]
["·         Enter the CFR Code using the drop down menu (column J)"]
["·         RM Budget Code (column K) – optional  "]
["This column has been provided to assist with RM input.  You may prefer to manipulate / sort the form after submission to assist with RM Finance. The manipulated / sorted version should not be submitted to Schools Accountancy."]
["STEP 3 – Checking / Authorising"]
["Check all details on the form are correct.  The Head Teacher should then sign the form authorising the submission to Schools Accountancy"]
["Submit the form to Schools Accountancy no later than Wednesday 28th March 2018."]
[]
["If you have any problems completing these forms please contact Schools' Accountancy on "]
["020 8359 7132/7223/2773"]

{"sheet":"End of Yr Adjustment Form","index":6,"n_rows":67,"n_cols":16,"rows_kept":67,"cut":false,"hidden":false,"merged":[[62,1,62,7],[63,1,63,7],[64,1,64,7],[65,1,65,7],[66,1,66,7],[57,1,57,7],[58,1,58,7],[59,1,59,7],[60,1,60,7],[61,1,61,7],[45,1,45,6],[45,7,45,8],[46,1,46,6],[46,7,46,8],[0,0,0,2],[0,4,0,9],[1,4,1,9],[50,7,50,8],[47,1,47,6],[47,7,47,8],[48,1,48,6],[48,7,48,8],[49,1,49,2],[49,7,49,8]]}
["End of Year Adjustments (Accruals) - Debtors/Creditors/Receipts in Advance/Payments in Advance",null,null,null,"SCHOOLS ARE ONLY ALLOWED TO ACCRUE FOR AMOUNTS OVER £1K PER INVOICE. If your invoice is under £1k you should not accrue."]
[null,null,null,null,"ACCURALS MUST EXCLUDE VAT"]
["Schools Name:                              ","School name",null,null,"PREPARER NAME"]
["Financial Year:","2017/18",null,null,"PREPARER'S EMAIL ADDRESS:"]
["Cost Centre:",{"$f":"VLOOKUP(B3,'[2]LOOK UPS '!$A$3:$C$110,3,FALSE)","v":"cost centre"},null,null,"PREPARER'S TELEPHONE NUMBER:"]
[null,null,null,null,"Authoriser:"]
[]
["Type (Please select from the drop down list)","Authorised by:","Supplier or Customer Name","Invoice Number / Order No.","Description","Date Goods/ Services Received","Value (Only include amounts greater than £1,000)","Is the amount actual or estimated?","Classification of the debtor/creditor. Who is the debtor or creditor with?","CFR Code","RM Budget Code",null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(J9,2)","v":""},{"$f":"L9&A9","v":""},{"$f":"IF(M9='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M9='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M9='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M9='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M9='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M9='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M9='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M9='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M9='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M9='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M9='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M9='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M9='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M9='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M9='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M9='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M9='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M9='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M9='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M9='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M9='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M9='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M9='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M9='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M9='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M9='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M9='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M9='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M9='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M9='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M9='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M9='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},{"$f":"A9&I9","v":""},{"$f":"A9&J9","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(J10,2)","v":""},{"$f":"L10&A10","v":""},{"$f":"IF(M10='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M10='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M10='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M10='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M10='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M10='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M10='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M10='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M10='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M10='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M10='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M10='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M10='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M10='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M10='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M10='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M10='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M10='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M10='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M10='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M10='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M10='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M10='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M10='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M10='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M10='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M10='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M10='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M10='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M10='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M10='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M10='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M11='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M11='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M11='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M11='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M11='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M11='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M11='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M11='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M11='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M11='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M11='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M11='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M11='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M11='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M11='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M11='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M11='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M11='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M11='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M11='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M11='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M11='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M11='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M11='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M11='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M11='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M11='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M11='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M11='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M11='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M11='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M11='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M12='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M12='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M12='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M12='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M12='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M12='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M12='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M12='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M12='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M12='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M12='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M12='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M12='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M12='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M12='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M12='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M12='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M12='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M12='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M12='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M12='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M12='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M12='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M12='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M12='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M12='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M12='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M12='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M12='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M12='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M12='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M12='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M13='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M13='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M13='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M13='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M13='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M13='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M13='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M13='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M13='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M13='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M13='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M13='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M13='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M13='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M13='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M13='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M13='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M13='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M13='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M13='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M13='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M13='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M13='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M13='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M13='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M13='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M13='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M13='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M13='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M13='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M13='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M13='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M14='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M14='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M14='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M14='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M14='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M14='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M14='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M14='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M14='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M14='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M14='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M14='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M14='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M14='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M14='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M14='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M14='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M14='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M14='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M14='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M14='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M14='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M14='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M14='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M14='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M14='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M14='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M14='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M14='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M14='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M14='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M14='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,""," Once you have completed the forms please save as  your \"school name\"  & \"EOY Forms 2017-18\" in an EXCEL FORMAT and return via email to schools.accountancy@barnet.gov.uk  ",{"$f":"IF(M15='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M15='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M15='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M15='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M15='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M15='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M15='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M15='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M15='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M15='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M15='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M15='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M15='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M15='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M15='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M15='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M15='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M15='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M15='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M15='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M15='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M15='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M15='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M15='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M15='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M15='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M15='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M15='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M15='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M15='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M15='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M15='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M16='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M16='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M16='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M16='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M16='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M16='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M16='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M16='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M16='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M16='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M16='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M16='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M16='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M16='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M16='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M16='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M16='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M16='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M16='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M16='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M16='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M16='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M16='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M16='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M16='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M16='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M16='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M16='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M16='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M16='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M16='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M16='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M17='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M17='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M17='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M17='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M17='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M17='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M17='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M17='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M17='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M17='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M17='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M17='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M17='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M17='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M17='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M17='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M17='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M17='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M17='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M17='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M17='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M17='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M17='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M17='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M17='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M17='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M17='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M17='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M17='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M17='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M17='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M17='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M18='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M18='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M18='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M18='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M18='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M18='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M18='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M18='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M18='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M18='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M18='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M18='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M18='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M18='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M18='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M18='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M18='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M18='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M18='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M18='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M18='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M18='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M18='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M18='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M18='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M18='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M18='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M18='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M18='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M18='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M18='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M18='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M19='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M19='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M19='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M19='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M19='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M19='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M19='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M19='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M19='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M19='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M19='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M19='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M19='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M19='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M19='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M19='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M19='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M19='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M19='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M19='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M19='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M19='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M19='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M19='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M19='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M19='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M19='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M19='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M19='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M19='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M19='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M19='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M20='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M20='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M20='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M20='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M20='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M20='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M20='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M20='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M20='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M20='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M20='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M20='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M20='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M20='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M20='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M20='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M20='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M20='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M20='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M20='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M20='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M20='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M20='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M20='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M20='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M20='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M20='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M20='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M20='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M20='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M20='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M20='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M21='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M21='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M21='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M21='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M21='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M21='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M21='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M21='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M21='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M21='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M21='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M21='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M21='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M21='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M21='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M21='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M21='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M21='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M21='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M21='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M21='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M21='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M21='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M21='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M21='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M21='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M21='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M21='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M21='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M21='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M21='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M21='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M22='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M22='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M22='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M22='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M22='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M22='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M22='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M22='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M22='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M22='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M22='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M22='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M22='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M22='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M22='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M22='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M22='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M22='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M22='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M22='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M22='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M22='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M22='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M22='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M22='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M22='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M22='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M22='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M22='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M22='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M22='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M22='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M23='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M23='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M23='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M23='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M23='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M23='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M23='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M23='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M23='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M23='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M23='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M23='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M23='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M23='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M23='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M23='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M23='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M23='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M23='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M23='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M23='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M23='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M23='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M23='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M23='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M23='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M23='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M23='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M23='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M23='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M23='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M23='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M24='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M24='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M24='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M24='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M24='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M24='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M24='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M24='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M24='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M24='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M24='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M24='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M24='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M24='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M24='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M24='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M24='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M24='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M24='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M24='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M24='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M24='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M24='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M24='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M24='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M24='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M24='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M24='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M24='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M24='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M24='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M24='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M25='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M25='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M25='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M25='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M25='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M25='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M25='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M25='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M25='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M25='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M25='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M25='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M25='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M25='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M25='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M25='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M25='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M25='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M25='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M25='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M25='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M25='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M25='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M25='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M25='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M25='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M25='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M25='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M25='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M25='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M25='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M25='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M26='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M26='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M26='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M26='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M26='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M26='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M26='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M26='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M26='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M26='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M26='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M26='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M26='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M26='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M26='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M26='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M26='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M26='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M26='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M26='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M26='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M26='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M26='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M26='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M26='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M26='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M26='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M26='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M26='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M26='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M26='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M26='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M27='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M27='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M27='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M27='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M27='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M27='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M27='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M27='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M27='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M27='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M27='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M27='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M27='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M27='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M27='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M27='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M27='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M27='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M27='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M27='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M27='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M27='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M27='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M27='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M27='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M27='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M27='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M27='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M27='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M27='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M27='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M27='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M28='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M28='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M28='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M28='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M28='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M28='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M28='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M28='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M28='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M28='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M28='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M28='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M28='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M28='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M28='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M28='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M28='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M28='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M28='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M28='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M28='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M28='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M28='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M28='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M28='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M28='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M28='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M28='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M28='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M28='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M28='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M28='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M29='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M29='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M29='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M29='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M29='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M29='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M29='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M29='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M29='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M29='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M29='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M29='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M29='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M29='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M29='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M29='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M29='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M29='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M29='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M29='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M29='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M29='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M29='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M29='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M29='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M29='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M29='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M29='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M29='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M29='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M29='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M29='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M30='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M30='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M30='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M30='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M30='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M30='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M30='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M30='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M30='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M30='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M30='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M30='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M30='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M30='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M30='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M30='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M30='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M30='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M30='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M30='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M30='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M30='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M30='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M30='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M30='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M30='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M30='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M30='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M30='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M30='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M30='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M30='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M31='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M31='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M31='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M31='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M31='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M31='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M31='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M31='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M31='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M31='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M31='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M31='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M31='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M31='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M31='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M31='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M31='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M31='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M31='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M31='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M31='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M31='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M31='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M31='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M31='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M31='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M31='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M31='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M31='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M31='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M31='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M31='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M32='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M32='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M32='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M32='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M32='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M32='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M32='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M32='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M32='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M32='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M32='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M32='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M32='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M32='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M32='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M32='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M32='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M32='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M32='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M32='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M32='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M32='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M32='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M32='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M32='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M32='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M32='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M32='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M32='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M32='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M32='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M32='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M33='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M33='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M33='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M33='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M33='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M33='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M33='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M33='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M33='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M33='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M33='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M33='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M33='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M33='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M33='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M33='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M33='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M33='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M33='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M33='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M33='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M33='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M33='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M33='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M33='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M33='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M33='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M33='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M33='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M33='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M33='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M33='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M34='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M34='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M34='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M34='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M34='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M34='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M34='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M34='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M34='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M34='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M34='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M34='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M34='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M34='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M34='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M34='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M34='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M34='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M34='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M34='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M34='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M34='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M34='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M34='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M34='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M34='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M34='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M34='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M34='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M34='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M34='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M34='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M35='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M35='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M35='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M35='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M35='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M35='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M35='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M35='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M35='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M35='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M35='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M35='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M35='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M35='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M35='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M35='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M35='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M35='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M35='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M35='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M35='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M35='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M35='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M35='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M35='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M35='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M35='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M35='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M35='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M35='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M35='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M35='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M36='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M36='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M36='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M36='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M36='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M36='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M36='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M36='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M36='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M36='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M36='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M36='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M36='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M36='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M36='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M36='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M36='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M36='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M36='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M36='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M36='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M36='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M36='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M36='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M36='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M36='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M36='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M36='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M36='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M36='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M36='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M36='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M37='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M37='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M37='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M37='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M37='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M37='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M37='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M37='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M37='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M37='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M37='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M37='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M37='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M37='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M37='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M37='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M37='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M37='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M37='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M37='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M37='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M37='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M37='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M37='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M37='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M37='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M37='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M37='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M37='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M37='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M37='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M37='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M38='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M38='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M38='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M38='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M38='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M38='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M38='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M38='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M38='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M38='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M38='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M38='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M38='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M38='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M38='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M38='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M38='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M38='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M38='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M38='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M38='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M38='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M38='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M38='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M38='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M38='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M38='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M38='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M38='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M38='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M38='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M38='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M39='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M39='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M39='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M39='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M39='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M39='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M39='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M39='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M39='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M39='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M39='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M39='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M39='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M39='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M39='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M39='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M39='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M39='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M39='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M39='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M39='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M39='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M39='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M39='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M39='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M39='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M39='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M39='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M39='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M39='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M39='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M39='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M40='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M40='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M40='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M40='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M40='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M40='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M40='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M40='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M40='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M40='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M40='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M40='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M40='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M40='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M40='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M40='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M40='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M40='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M40='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M40='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M40='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M40='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M40='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M40='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M40='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M40='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M40='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M40='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M40='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M40='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M40='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M40='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(M41='LOOK UPS'!$A$176,'LOOK UPS'!$B$176,IF(M41='LOOK UPS'!$A$177,'LOOK UPS'!$B$177,IF(M41='LOOK UPS'!$A$178,'LOOK UPS'!$B$178,IF(M41='LOOK UPS'!$A$179,'LOOK UPS'!$B$179,IF(M41='LOOK UPS'!$A$180,'LOOK UPS'!$B$180,IF(M41='LOOK UPS'!$A$181,'LOOK UPS'!$B$181,IF(M41='LOOK UPS'!$A$182,'LOOK UPS'!$B$182,IF(M41='LOOK UPS'!$A$183,'LOOK UPS'!$B$183,IF(M41='LOOK UPS'!$A$184,'LOOK UPS'!$B$184,IF(M41='LOOK UPS'!$A$185,'LOOK UPS'!$B$185,IF(M41='LOOK UPS'!$A$186,'LOOK UPS'!$B$186,IF(M41='LOOK UPS'!$A$187,'LOOK UPS'!$B$187,IF(M41='LOOK UPS'!$A$188,'LOOK UPS'!$B$188,IF(M41='LOOK UPS'!$A$189,'LOOK UPS'!$B$189,IF(M41='LOOK UPS'!$A$190,'LOOK UPS'!$B$190,IF(M41='LOOK UPS'!$A$191,'LOOK UPS'!$B$191,IF(M41='LOOK UPS'!$A$192,'LOOK UPS'!$B$192,IF(M41='LOOK UPS'!$A$193,'LOOK UPS'!$B$193,IF(M41='LOOK UPS'!$A$194,'LOOK UPS'!$B$194,IF(M41='LOOK UPS'!$A$195,'LOOK UPS'!$B$195,IF(M41='LOOK UPS'!$A$196,'LOOK UPS'!$B$196,IF(M41='LOOK UPS'!$A$197,'LOOK UPS'!$B$197,IF(M41='LOOK UPS'!$A$198,'LOOK UPS'!$B$198,IF(M41='LOOK UPS'!$A$199,'LOOK UPS'!$B$199,IF(M41='LOOK UPS'!$A$200,'LOOK UPS'!$B$200,IF(M41='LOOK UPS'!$A$201,'LOOK UPS'!$B$201,IF(M41='LOOK UPS'!$A$202,'LOOK UPS'!$B$202,IF(M41='LOOK UPS'!$A$203,'LOOK UPS'!$B$203,IF(M41='LOOK UPS'!$A$204,'LOOK UPS'!$B$204,IF(M41='LOOK UPS'!$A$205,'LOOK UPS'!$B$205,IF(M41='LOOK UPS'!$A$206,'LOOK UPS'!$B$206,IF(M41='LOOK UPS'!$A$207,'LOOK UPS'!$B$207))))))))))))))))))))))))))))))))","v":false},"",""]
[null,null,null,null,null,null,{"$f":"SUM(G9:G41)","v":0}]
[]
["Definitions"]
[]
["Creditor","Payment not yet made in respect of goods or services received by 31st March 2018"]
["Debtor","Income which has not been received and which relates to supplying a good or services received by 31st March 2018"]
["Payments in Advance","Payment received by 31st March 2018 but relates to the provision of goods and services in 2018/19 and beyond"]
["Receipts in Advance","Income received by 31st March 2018 but relates to the provision of goods and services in 2018/19 and beyond"]
[]
[]
[]
["The London Borough of Barnet has to disclose who its debtor/creditors and payments in advance/receipts in advance are with."]
["In particular we are interested in transactions with central government bodies, other local authorities, the mayor, the london borough of Barnet"]
[]
[]
["Drop down","Further information"]
["Central Government including DfE or EFA","Central Government Departments for example Department of Health, Department of Transport, HMRC, Education Funding Agency/Department for Education"]
["Mayor/MOPAC/TFL","MOPAC (The Mayor's Office for Policing And Crime), TFL (Transport for London), The Mayor of London."]
["London Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise).","Schools may be owed Funding from the Council and rate/NNDR bills."]
["Cambridge Education/ISS","Services provided might include: School Meals, School improvement, School admissions, Travel Plans, services for Children with Special Educational Needs. Refer to the traded services document for information of services provided by Cambridge Education."]
["Capita (CSG/Customer Support Group)","Services provided might include: Financial Support Services, Human Resources, Payroll, IT. Refer to the traded services document for information of services provided by Capita/CSG."]
["Regional Enterprise (RE)","Planning and Development Management, Building Control, Environmental Health, Trading Standards and Licensing, Highways. Refer to the traded services document for information of services provided by RE."]
["Local Authorities excluding London Borough of Barnet","For example London Borough of Harrow, London Borough of Haringey, London Borough of Enfield, London Borough of Brent, London Borough of Islington, Hertfordshire County Council.  Also include Kent CC (Laser)"]
["NHS","Such as Department of Health, Chase Farm Hospital"]
["Academies","Transactions with other schools that are an academy."]
["Other","All other suppliers/Customers who do not fit in the categories above eg parents, utility companies etc."]

{"sheet":"Example Yr End Adjustment","index":7,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":false,"merged":[[33,1,33,6],[33,7,33,8],[0,0,0,2],[0,4,0,9],[1,4,1,9],[32,1,32,6],[32,7,32,8],[34,1,34,6],[34,7,34,8],[35,1,35,6],[35,7,35,8],[36,1,36,2],[36,7,36,8],[37,7,37,8],[44,1,44,7],[45,1,45,7],[46,1,46,7],[53,1,53,7],[47,1,47,7],[48,1,48,7],[49,1,49,7],[50,1,50,7],[51,1,51,7],[52,1,52,7]]}
["End of Year Accruals- Debtors/Creditors/Receipts in Advance/Payments in Advance",null,null,null,"SCHOOLS ARE ONLY ALLOWED TO ACCRUE FOR AMOUNTS OVER £1K PER INVOICE. If your invoice is under £1k you should not accrue."]
[null,null,null,null,"ACCURALS MUST EXCLUDE VAT"]
["Schools Name:                              ","School name",null,null,"PREPARER NAME"]
["Financial Year:","2017/18",null,null,"PREPARER'S EMAIL ADDRESS:"]
["Cost Centre:",{"$f":"VLOOKUP(B3,'[2]LOOK UPS '!$A$3:$C$110,3,FALSE)","v":"cost centre"},null,null,"PREPARER'S TELEPHONE NUMBER:"]
[null,null,null,null,"Authoriser:"]
[]
["Type (Please select from the drop down list)","Authorised by:","Supplier or Customer Name","Invoice Number / Order No.","Description","Date Goods/ Services Received","Value (Only include amounts greater than £1,000)","Is the amount actual or estimated?","Classification of the debtor/creditor. Who is the debtor or creditor with?","CFR Code","RM Budget Code",null,null,"CHECK"]
["Creditor",null,null,null,"School Meals Feb & March",null,1000,null,"Cambridge Education/ISS","E25",null,{"$f":"LEFT(J9,2)","v":"E2"},{"$f":"L9&A9","v":"E2Creditor"},"good"]
["Debtor",null,null,null,"SEN",null,5650,null,"Local Authorities excluding London Borough of Barnet","I03",null,{"$f":"LEFT(J10,2)","v":"I0"},{"$f":"L10&A10","v":"I0Debtor"},"good"]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,null,null,null,null,null,"","",false]
[null,null,null,null,null,null,{"$f":"SUM(G9:G28)","v":6650}]
[]
["Definitions",null,null,null,{"$f":"'[3]LOOK UPS '!$A$3:$A$110","v":{"$error":"#REF!"}}]
[]
["Creditor","Payment not yet made in respect of goods or services received by 31st March 2018"]
["Debtor","Income which has not been received and which relates to supplying a good or services received by 31st March 2018"]
["Payments in Advance","Payment received by 31st March 2018 but relates to the provision of goods and services in 2018/19 and beyond"]
["Receipts in Advance","Income received by 31st March 2018 but relates to the provision of goods and services in 2018/19 and beyond"]
[]
[]
[]
["The London Borough of Barnet has to disclose who its debtor/creditors and payments in advance/receipts in advance are with."]
["In particular we are interested in transactions with central government bodies, other local authorities, the mayor, the london borough of Barnet"]
[]
[]
["Drop down","Further information"]
["Central Government including DfE or EFA","Central Government Departments for example Department of Health, Department of Transport, HMRC, Education Funding Agency/Department for Education"]
["Mayor/MOPAC/TFL","MOPAC (The Mayor's Office for Policing And Crime), TFL (Transport for London), The Mayor of London."]
["London Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise).","Include all invoices from the London Borough of Barnet.  Schools may be owed Funding from the Council and rate/NNDR bills."]
["Cambridge Education/ISS","Services provided might include: School Meals, School improvement, School admissions, Travel Plans, services for Children with Special Educational Needs. Refer to the traded services document for information of services provided by Cambridge Education."]
["Capita (CSG/Customer Support Group)","Services provided might include: Financial Support Services, Human Resources, Payroll, IT. Refer to the traded services document for information of services provided by Capita/CSG."]
["Regional Enterprise (RE)","Planning and Development Management, Building Control, Environmental Health, Trading Standards and Licensing, Highways. Refer to the traded services document for information of services provided by RE."]
["Local Authorities excluding London Borough of Barnet","For example London Borough of Harrow, London Borough of Haringey, London Borough of Enfield, London Borough of Brent, London Borough of Islington, Hertfordshire County Council."]
["NHS","Such as Department of Health, Chase Farm Hospital"]
["Academies","Transactions with other schools that are an academy."]
["Other","All other suppliers/Customers who do not fit in the categories above eg parents, utility companies etc."]

{"sheet":"Bank Movement Instructions","index":8,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Instructions for completing the Analysis of Bank Movement 21st - 31st March 2018"]
[]
[]
["COMPLETING THE ANALYSIS OF BANK STATEMENT MOVEMENT FORM"]
["STEP 1 - Schools Details","Drop Down Menu"]
["·         Choose your School from the drop down menu","Included in the year end return as a debtor"]
["·         The School’s Cost Centre number will automatically populate","Included in the year end return as a creditor"]
["STEP 2 - Account Balances","Included in the year end return as a receipt in advance"]
["·         Enter the Bank balance at 20th March 2018 (close of business)","Included in the year end return as a payment in advance"]
["·         Enter the Bank balance at 31st March 2018 (close of business)","Included in the year end return but as an estimate, the actual is immaterially different (>£1k)"]
["If the Bank balance is different on the 31st March to the balance at 20th March, the difference will show in cell, B12.","Included in the 20th March bank rec as an unpresented income"]
["The next steps are dependent on whether you have a difference or not.","Included in the 20th March bank rec as an unpresented cheque"]
["If you do not have a difference in the Bank balances then, go to STEP 3","Immaterial amount (less than £1k per amount) not a debtor/creditor/PIA/RIA"]
["If you do have a difference in the Bank balances then, go to STEP 4","Was not included in the year end return and was not in the 20th March bank reconciliation as an unpresented income/cheque"]
[null,"This income relates to 2018/19"]
["STEP 3 – No difference in Bank Balance ","This expenditure relates to 2018/19"]
["·         Go to the bottom of the form and complete;","Other"]
["o   Prepared By"]
["o   Authorised By"]
["o   Contact Details"]
["Submit the form along with a signed copy of the Bank Statement to Schools Accountancy no later than Monday 23rd April 2018."]
["STEP 4 – Difference in Bank Balance "]
["Each transaction contributing to the difference in the Bank Balance at 31st March 2018 will need to be explained. A table is provided within the form to assist in listing each transaction creating the difference. Ensure only one transaction per line is entered."]
["a)      Enter a description of the transaction."]
["b)      Enter the amount ensuring debits & credits appear in the correct columns."]
["c)       Enter the date the transaction appears on the Bank statement."]
["d)      Enter the relevant CFR code (budget code is not required)."]
["e)      The next column to complete will be column ‘F’ of the table which has a drop down list of possible reasons for the transaction not being included in the Accounts for 2017/18 (bank reconciliation 20/3/2018).  Choose a reason relevant to the transaction."]
["f)       After choosing a reason, Column ‘G’ will state whether you need to provide an explanation in column ‘H’."]
["g)      If an explanation is required, please explain why it was not possible to include the transaction as an unpresented item or as an EOY (End of Year) adjustment."]
["h)      When each transaction has been listed the total of the transactions should agree to the Bank Balance difference show in CELL, B12.  If the figures agree, a message will appear stating the form can be submitted. If the figures do not agree, a message will appear stating ‘Error, Do not Submit’."]
[]
["After completing the table and ensuring the transactions listed agree to the Bank Balance difference move on to (i)"]
[]
["i)        Go to the bottom of the form and complete;"]
["a.       Prepared By"]
["b.      Authorised By"]
["c.       Contact Details"]
["Submit the form along with a signed copy of the Bank Statement to Schools Accountancy no later than Monday 23rd April 2018."]
[]
["If you have any problems completing these forms please contact Schools' Accountancy on 020 8359 7132/7223/2773"]

{"sheet":"Bank Movement Form","index":9,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[8,3,8,5],[9,3,9,5],[0,5,5,7]]}
["ANALYSIS OF BANK MOVEMENT FOR THE PERIOD 21/03/2018 TO 31/03/2018",null,null,null,null,"IF THE BANK TRANSACTIONS FROM THE 21/3/2018 TO 31/3/2018 ARE NOT ALREADY IN YOUR ACCOUNTING SYSTEM FOR 2017/18 DATA, YOU MUST NOT GO BACK INTO 2017/18 DATA TO PROCESS THE TRANSACTIONS.  THE TRANSACTIONS MUST BE POSTED IN THE NEW YEAR'S DATA 2018/19"]
[]
[{"$f":"'[4]Closure Return Checklist'!A3","v":"Schools Name:                              "},{"$f":"'Front Page'!H2","v":"Please choose your School"}]
[{"$f":"'[4]Closure Return Checklist'!A4","v":"Financial Year:"},"2017/18"]
[{"$f":"'[4]Closure Return Checklist'!A5","v":"Cost Centre:"},{"$f":"VLOOKUP(B3,'LOOK UPS'!$A$3:$C$110,3,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,"£",null,null,null,null,null,"Guidance"]
["Bank Balance as at 20/03/2018",4589.25,null,"IF YOUR ACCOUNT BALANCE WAS OVERDRAWN ON THE 20/03/2018, PLEASE INSERT \"-\" IN FRONT OF THE FIGURE",null,null,null,"this must equal the bank statement balance. Please include a copy of the 20/03/2018 bank statement. This is your end of day balance."]
["Bank Balance as at 31/03/2018",3214.2,null,"IF YOUR ACCOUNT BALANCE WAS OVERDRAWN ON THE 31/03/2018, PLEASE INSERT \"-\" IN FRONT OF THE FIGURE",null,null,null,"this must equal the bank statement balance. Please include a copy of the 31/03/2018 bank statement. This is your end of day balance."]
[]
["Difference:",{"$f":"B9-B10","v":1375.0500000000002}]
[]
[]
["This difference is explained by:",null,null,null,null,null,null,"Please list out all the transactions between the 20th March 2018-31st March 2018. ",null,null,null,null," Once you have completed the forms please save as  your \"school name\"  & \"EOY Forms 2017-18\" in an EXCEL FORMAT and return via email to schools.accountancy@barnet.gov.uk  "]
[]
["Description of transaction","Debit (Decrease bank balance)","Credit (Increase bank balance)","date on bank statement","CFR Code","reason",null,"if  reason in Column F is 'other' or 'was not included in the year end return and was not in the 20th March bank reconciliation as an unpresented income/cheque' please explain"]
[null,null,null,null,null,null,{"$f":"IF(F18='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F18='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F19='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F19='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F20='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F20='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F21='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F21='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F22='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F22='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F23='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F23='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F24='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F24='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F25='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F25='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F26='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F26='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F27='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F27='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F28='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F28='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F29='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F29='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F30='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F30='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F31='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F31='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F32='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F32='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,{"$f":"SUM(B16:B32)","v":0},{"$f":"SUM(C16:C32)","v":0}]
[]
["NET TOTAL:",{"$f":"B33-C33","v":0},"This must equal cell B12",null,null,{"$f":"IF(B12=B35,'[5]Drop down options'!A21,'[5]Drop down options'!A19)","v":"ERROR DO NOT SUBMIT RETURN"}]
[]
["Prepared by:"]
[]
["Authorised by:"]
[]
["Contact telephone number and email for queries:"]

{"sheet":"Drop down options","index":10,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Included in the year end return as a debtor"]
["Included in the year end return as a creditor"]
["Included in the year end return as a receipt in advance"]
["Included in the year end return as a payment in advance"]
["Included in the year end return but as an estimate, the actual is immaterially different (>£1k)"]
["Included in the 20th March bank rec as an unpresented income"]
["Included in the 20th March bank rec as an unpresented cheque"]
["Immaterial amount (less than £1k per amount) not a debtor/creditor/PIA/RIA"]
["Was not included in the year end return and was not in the 20th March bank reconciliation as an unpresented income/cheque"]
["This income relates to 2018/19"]
["This expenditure relates to 2018/19"]
["Other"]

{"sheet":"Example Bank Movement Form","index":11,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,5,5,7],[8,3,8,5],[9,3,9,5]]}
["ANALYSIS OF BANK MOVEMENT FOR THE PERIOD 21/03/2018 TO 31/03/2018",null,null,null,null,"IF THE BANK TRANSACTIONS FROM THE 21/3/2018 TO 31/3/2018 ARE NOT ALREADY IN YOUR ACCOUNTING SYSTEM FOR 2017/18 DATA, YOU MUST NOT GO BACK INTO 2017/18 DATA TO PROCESS THE TRANSACTIONS.  THE TRANSACTIONS MUST BE POSTED IN THE NEW YEAR'S DATA 2018/19"]
[]
[{"$f":"'[4]Closure Return Checklist'!A3","v":"Schools Name:                              "},"School"]
[{"$f":"'[4]Closure Return Checklist'!A4","v":"Financial Year:"},"2017/18"]
[{"$f":"'[4]Closure Return Checklist'!A5","v":"Cost Centre:"},{"$f":"VLOOKUP(B3,'[5]LOOK UPS'!$A$3:$C$110,3,FALSE)","v":"Cost Centre"}]
[]
[]
[null,"£",null,null,null,null,null,"Guidance"]
["Bank Balance as at 20/03/2018",4589.25,null,"IF YOUR ACCOUNT BALANCE WAS OVERDRAWN ON THE 20/03/2018, PLEASE INSERT \"-\" IN FRONT OF THE FIGURE",null,null,null,"this must equal the bank statement balance. Please include a copy of the 20/03/2018 bank statement. This is your end of day balance."]
["Bank Balance as at 31/03/2018",3214.2,null,"IF YOUR ACCOUNT BALANCE WAS OVERDRAWN ON THE 31/03/2018, PLEASE INSERT \"-\" IN FRONT OF THE FIGURE",null,null,null,"this must equal the bank statement balance. Please include a copy of the 31/03/2018 bank statement. This is your end of day balance."]
[]
["Difference:",{"$f":"B9-B10","v":1375.0500000000002}]
[]
[]
["This difference is explained by:",null,null,null,null,null,null,"Please list out all the transactions between the 20th March 2018-31st March 2018. "]
[]
["Description of transaction","Debit (Decrease bank balance)","Credit (Increase bank balance)","date on bank statement","CFR Code","reason",null,"if  reason in Column E is 'other' or 'was not included in the year end return and was not in the 20th March bank reconciliation as an unpresented income/cheque' please explain"]
[null,null,null,null,null,"Included in the 20th March bank rec as an unpresented cheque",{"$f":"IF(F18='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F18='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F19='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F19='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F20='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F20='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F21='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F21='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F22='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F22='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F23='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F23='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F24='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F24='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F25='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F25='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F26='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F26='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F27='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F27='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F28='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F28='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F29='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F29='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F30='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F30='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F31='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F31='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,null,null,null,null,null,{"$f":"IF(F32='[5]Drop down options'!$A$12,'[5]Drop down options'!$A$16,IF(F32='[5]Drop down options'!$A$9,'[5]Drop down options'!$A$16,'[5]Drop down options'!$A$17))","v":"No explanation required in Column H"}]
[null,{"$f":"SUM(B16:B32)","v":0},{"$f":"SUM(C16:C32)","v":0}]
[]
["NET TOTAL:",{"$f":"B33-C33","v":0},"This must equal cell B12",null,null,{"$f":"IF(B12=B35,'[5]Drop down options'!A21,'[5]Drop down options'!A19)","v":"ERROR DO NOT SUBMIT RETURN"}]
[]
["Prepared by:"]
[]
["Authorised by:"]
[]
["Contact telephone number and email for queries:"]

{"sheet":"Integra Upload","index":12,"n_rows":116,"n_cols":8,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
[]
["GLs to be used:"]
[null,null,null,"Total Amount","GL code"]
["Creditor","Central Government including DfE or EFA",{"$f":"A4&B4","v":"CreditorCentral Government including DfE or EFA"},{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C4,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946951,null,{"$f":"E4&B4","v":"946951Central Government including DfE or EFA"}]
["Creditor","Mayor/MOPAC/TFL","CreditorMayor/MOPAC/TFL",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C5,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946952,null,{"$f":"E5&B5","v":"946952Mayor/MOPAC/TFL"}]
["Creditor","Local Authorities excluding London Borough of Barnet",{"$f":"A6&B6","v":"CreditorLocal Authorities excluding London Borough of Barnet"},{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C6,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946952,null,"946952Local Authorities excluding London Borough of Barnet"]
["Creditor","Cambridge Education/ISS","CreditorCambridge Education/ISS",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C7,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946962,null,"946962Cambridge Education/ISS"]
["Creditor","Capita (CSG/Customer Support Group)","CreditorCapita (CSG/Customer Support Group)",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C8,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946962,null,"946962Capita (CSG/Customer Support Group)"]
["Creditor","Regional Enterprise (RE)","CreditorRegional Enterprise (RE)",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C9,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946962,null,"946962Regional Enterprise (RE)"]
["Creditor","London Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise).","CreditorLondon Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise).",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C10,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924962,null,"924962London Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise)."]
["Creditor","NHS","CreditorNHS",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C11,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946960,null,"946960NHS"]
["Creditor","Academies","CreditorAcademies",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C12,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946951,null,"946951Academies"]
["Creditor","Other","CreditorOther",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C13,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946962,null,"946962Other"]
["Debtor","Central Government including DfE or EFA","DebtorCentral Government including DfE or EFA",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C14,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924951,null,"924951Central Government including DfE or EFA"]
["Debtor","Mayor/MOPAC/TFL","DebtorMayor/MOPAC/TFL",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C15,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924952,null,"924952Mayor/MOPAC/TFL"]
["Debtor","London Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise).","DebtorLondon Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise).",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C16,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946962,null,"946962London Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise)."]
["Debtor","Cambridge Education/ISS","DebtorCambridge Education/ISS",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C17,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924962,null,"924962Cambridge Education/ISS"]
["Debtor","Capita (CSG/Customer Support Group)","DebtorCapita (CSG/Customer Support Group)",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C18,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924962,null,"924962Capita (CSG/Customer Support Group)"]
["Debtor","Regional Enterprise (RE)","DebtorRegional Enterprise (RE)",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C19,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924962,null,"924962Regional Enterprise (RE)"]
["Debtor","Local Authorities excluding London Borough of Barnet","DebtorLocal Authorities excluding London Borough of Barnet",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C20,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924952,null,"924952Local Authorities excluding London Borough of Barnet"]
["Debtor","NHS","DebtorNHS",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C21,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924958,null,"924958NHS"]
["Debtor","Academies","DebtorAcademies",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C22,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924951,null,"924951Academies"]
["Debtor","Other","DebtorOther",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C23,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924962,null,"924962Other"]
["Payments in Advance","Central Government including DfE or EFA","Payments in AdvanceCentral Government including DfE or EFA",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C24,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924951,null,"924951Central Government including DfE or EFA"]
["Payments in Advance","Mayor/MOPAC/TFL","Payments in AdvanceMayor/MOPAC/TFL",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C25,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924952,null,"924952Mayor/MOPAC/TFL"]
["Payments in Advance","Local Authorities excluding London Borough of Barnet","Payments in AdvanceLocal Authorities excluding London Borough of Barnet",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C26,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946952,null,"946952Local Authorities excluding London Borough of Barnet"]
["Payments in Advance","Cambridge Education/ISS","Payments in AdvanceCambridge Education/ISS",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C27,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924962,null,"924962Cambridge Education/ISS"]
["Payments in Advance","Capita (CSG/Customer Support Group)","Payments in AdvanceCapita (CSG/Customer Support Group)",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C28,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924962,null,"924962Capita (CSG/Customer Support Group)"]
["Payments in Advance","Regional Enterprise (RE)","Payments in AdvanceRegional Enterprise (RE)",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C29,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924962,null,"924962Regional Enterprise (RE)"]
["Payments in Advance","London Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise).","Payments in AdvanceLondon Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise).",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C30,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946962,null,"946962London Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise)."]
["Payments in Advance","NHS","Payments in AdvanceNHS",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C31,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924958,null,"924958NHS"]
["Payments in Advance","Academies","Payments in AdvanceAcademies",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C32,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924951,null,"924951Academies"]
["Payments in Advance","Other","Payments in AdvanceOther",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C33,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924962,null,"924962Other"]
["Receipts in Advance","Central Government including DfE or EFA","Receipts in AdvanceCentral Government including DfE or EFA",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C34,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946951,null,"946951Central Government including DfE or EFA"]
["Receipts in Advance","Mayor/MOPAC/TFL","Receipts in AdvanceMayor/MOPAC/TFL",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C35,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946952,null,"946952Mayor/MOPAC/TFL"]
["Receipts in Advance","London Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise).","Receipts in AdvanceLondon Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise).",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C36,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},924962,null,"924962London Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise)."]
["Receipts in Advance","Cambridge Education/ISS","Receipts in AdvanceCambridge Education/ISS",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C37,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946962,null,"946962Cambridge Education/ISS"]
["Receipts in Advance","Capita (CSG/Customer Support Group)","Receipts in AdvanceCapita (CSG/Customer Support Group)",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C38,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946962,null,"946962Capita (CSG/Customer Support Group)"]
["Receipts in Advance","Regional Enterprise (RE)","Receipts in AdvanceRegional Enterprise (RE)",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C39,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946962,null,"946962Regional Enterprise (RE)"]
["Receipts in Advance","Local Authorities excluding London Borough of Barnet","Receipts in AdvanceLocal Authorities excluding London Borough of Barnet",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C40,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946952,null,"946952Local Authorities excluding London Borough of Barnet"]
["Receipts in Advance","NHS","Receipts in AdvanceNHS",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C41,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946960,null,"946960NHS"]
["Receipts in Advance","Academies","Receipts in AdvanceAcademies",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C42,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946951,null,"946951Academies"]
["Receipts in Advance","Other","Receipts in AdvanceOther",{"$f":"SUMIF('End of Yr Adjustment Form'!$O$9:$O$28,C43,'End of Yr Adjustment Form'!$G$9:$G$28)","v":0},946962,null,"946962Other"]
[]
["Receipts in Advance","Creditor"]
["Debtor","Payments in Advance"]
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'End of Yr Adjustment Form'!B3","v":"School name"}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'End of Yr Adjustment Form'!B5","v":"cost centre"},null,"SCH "," Year End Adj 2017/18"]
[{"$f":"'End of Yr Adjustment Form'!A6","v":0}]
[]
[]
["JOURNAL TO BE POSTED:",null,null,null,"Narrative"]
[null,"DR","CR",null,{"$f":"$D$49&$B$49&$E$49","v":"SCH cost centre Year End Adj 2017/18"}]
["I01",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A55,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A55,'End of Yr Adjustment Form'!$G:$G)","v":0},null,{"$f":"$D$49&$B$49&$E$49","v":"SCH cost centre Year End Adj 2017/18"}]
["I02",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A56,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A56,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["I03",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A57,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A57,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["I05",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A58,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A58,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["I06",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A59,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A59,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["I07",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A60,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A60,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["I08",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A61,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A61,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["I09",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A62,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A62,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["I10",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A63,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A63,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["I11",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A64,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A64,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["I12",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A65,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A65,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["I13",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A66,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A66,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["I15",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A67,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A67,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["I16",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A68,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A68,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["I17",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A69,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A69,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["I18",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A70,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A70,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E01",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A71,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A71,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E02",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A72,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A72,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E03",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A73,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A73,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E04",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A74,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A74,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E05",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A75,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A75,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E06",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A76,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A76,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E07",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A77,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A77,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E08",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A78,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A78,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E09",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A79,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A79,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E10",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A80,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A80,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E11",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A81,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A81,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E12",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A82,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A82,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E13",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A83,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A83,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E14",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A84,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A84,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E15",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A85,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A85,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E16",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A86,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A86,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E17",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A87,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A87,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E18",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A88,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A88,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E19",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A89,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A89,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E20",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A90,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A90,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E21",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A91,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A91,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E22",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A92,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A92,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E23",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A93,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A93,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E24",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A94,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A94,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E25",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A95,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A95,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E26",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A96,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A96,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E27",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A97,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A97,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E28",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A98,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A98,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E29",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A99,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A99,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E31",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A100,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A100,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["E32",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A101,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A101,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["CI01",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A102,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A102,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["CI03",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$45&A103,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$A$46&A103,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["CE01",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A104,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A104,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["CE02",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A105,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A105,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["CE03",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A106,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A106,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
["CE04",{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$45&A107,'End of Yr Adjustment Form'!$G:$G)","v":0},{"$f":"SUMIF('End of Yr Adjustment Form'!$P:$P,$B$46&A107,'End of Yr Adjustment Form'!$G:$G)","v":0},null,"SCH cost centre Year End Adj 2017/18"]
[946951,null,{"$f":"SUMIF($E$4:$E$43,A108,$D$4:$D$43)","v":0},"Creditors Government Depts","SCH cost centre Year End Adj 2017/18"]
[946952,null,{"$f":"SUMIF($E$4:$E$43,A109,$D$4:$D$43)","v":0},"Creditors OLA's","SCH cost centre Year End Adj 2017/18"]
[946962,{"$f":"SUMIF($G$4:$G$43,A110&H110,$D$4:$D$43)","v":0},{"$f":"SUMIF($E$4:$E$43,A110,$D$4:$D$43)-B110","v":0},"Creditors other","SCH cost centre Year End Adj 2017/18",null,null,"London Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise)."]
[946960,null,{"$f":"SUMIF($E$4:$E$43,A111,$D$4:$D$43)","v":0},"Creditor NHS","SCH cost centre Year End Adj 2017/18"]
[924951,{"$f":"SUMIF($E$4:$E$43,A112,$D$4:$D$43)","v":0},null,"Central Govt Debtors","SCH cost centre Year End Adj 2017/18"]
[924952,{"$f":"SUMIF($E$4:$E$43,A113,$D$4:$D$43)","v":0},null,"Local Authority Debtors","SCH cost centre Year End Adj 2017/18"]
[924962,{"$f":"SUMIF($E$4:$E$43,A114,$D$4:$D$43)-C114","v":0},{"$f":"SUMIF($G$4:$G$43,A114&H114,$D$4:$D$43)","v":0},"Other Creditors/RIA/Debtors with Barnet","SCH cost centre Year End Adj 2017/18",null,null,"London Borough of Barnet excluding Cambridge Education and RE (Regional Enterprise)."]
[924958,{"$f":"SUMIF($E$4:$E$43,A115,$D$4:$D$43)","v":0},null,"Debtors - NHS Bodies","SCH cost centre Year End Adj 2017/18"]
[null,{"$f":"SUM(B55:B115)","v":0},{"$f":"SUM(C55:C115)","v":0}]

{"sheet":"Drs & Crs Analysis","index":13,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":true,"merged":[[1,1,1,4],[1,5,1,8]]}
["Data to be transferred on to the Drs & Crs Schedule"]
[null,"Debtors / PIA",null,null,null,"Creditors / RIA"]
[null,924951,924952,924962,924958,946951,946952,946962,946960]
[null,"Debtors - Govt Dept.","Debtors - OLA's","Debtors - Other","Debtors - NHS Bodies","Creditors - Govt Dept.","Creditors - OLA's","Creditors - Other ","Creditors - NHS Bodies","Net Internal Creditors /Debtors"]
[{"$f":"'Front Page'!H2","v":"Please choose your School"},{"$f":"'Integra Upload'!B112-'Integra Upload'!C112","v":0},{"$f":"'Integra Upload'!B113-'Integra Upload'!C113","v":0},{"$f":"'Integra Upload'!B114-'Integra Upload'!C114","v":0},{"$f":"'Integra Upload'!B115-'Integra Upload'!C115","v":0},{"$f":"'Integra Upload'!B108-'Integra Upload'!C108","v":0},{"$f":"'Integra Upload'!B109-'Integra Upload'!C109","v":0},{"$f":"'Integra Upload'!B110-'Integra Upload'!C110","v":0},{"$f":"'Integra Upload'!B111-'Integra Upload'!C111","v":0},{"$f":"SUM(B5:I5)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," Once you have completed the forms please save as  your \"school name\"  & \"EOY Forms 2017-18\" in an EXCEL FORMAT and return via email to schools.accountancy@barnet.gov.uk  "]

{"sheet":"cost centres","index":14,"n_rows":117,"n_cols":3,"rows_kept":117,"cut":false,"hidden":true,"merged":[]}
[]
["School","DCSF","SAP Cost Centre"]
[]
["Brookhill Nursery",1000,10130]
["Hampden Way Nursery",1001,10131]
["Moss Hall Nursery",1002,10132]
["St Margaret's Nursery",1003,10133]
[]
["Akiva",3520,11094]
["All Saints' CE School (N20)",3317,10042]
["All Saints' CE School (NW2)",3300,10040]
["Annunciation RC Infant School",3500,10043]
["Annunciation RC Junior School",3514,10117]
["Barnfield School",2002,10044]
["Beis Yaakov",2079,10128]
["Beit Shvidler",3524,11278]
["Bell Lane School",2003,10045]
["Blessed Dominic RC School",3511,10115]
["Brookland Infant School",2008,10047]
["Brookland Junior School",2007,10046]
["Brunswick Park School",2009,10048]
["Chalgrove School",2067,10118]
["Childs Hill School",2010,10049]
["Christ Church CE School",3302,10050]
["Church Hill School",2011,10051]
["Colindale School",2014,10054]
["Coppetts Wood School",2015,10055]
["Courtland School",2016,10056]
["Cromer Road School",2017,10057]
["Danegrove School",2073,10083]
["Deansbrook Infant School",2019,10059]
["Dollis Infant School",2021,10061]
["Dollis Junior School",5200,10060]
["Edgware Primary School",2023,10063]
["Fairway School",2024,10064]
["Foulds School",2025,10065]
["Frith Manor School",2026,10066]
["Garden Suburb Infant School",2028,10068]
["Garden Suburb Junior School",2027,10067]
["Goldbeaters School",2029,10069]
["Hasmonean Primary School",3516,10121]
["Hollickwood School",2031,10071]
["Holly Park School",2032,10072]
["Holy Trinity CE School",3304,10073]
["Livingstone School",2036,10074]
["Manorside School ",2037,10075]
["Martin Primary",3523,11093]
["Mathilda Marks Kennedy School",5948,10125]
["Menorah Foundation School",5949,10126]
["Menorah Primary School",3513,10114]
["Monken Hadley CE School",3305,10078]
["Monkfrith School",2042,10079]
["Moss Hall Infant School",2044,10081]
["Moss Hall Junior School",2043,10080]
["Northside School",2045,10082]
["Orion School",2077,10127]
["Osidge School",5201,10084]
["Our Lady of Lourdes RC School",3501,10085]
["Pardes House School",2078,10129]
["Queenswell Infant School",2071,10119]
["Queenswell Junior School",2072,10086]
["Rosh Pinah School",3512,10112]
["Sacred Heart RC School",3510,10110]
["St. Agnes' RC School",3502,10087]
["St. Andrew's CE School",3315,10099]
["St. Catherine's RC School",3504,10088]
["St. John's CE School (N11)",3307,10089]
["St. John's CE School (N20)",3309,10116]
["St. Joseph's RC Junior School",3509,10107]
["St. Mary's & St. Johns Primary",3521,10698]
["St. Mary's CE School (EN4)",3312,10093]
["St. Mary's CE School (N3)",3311,10092]
["St. Paul's CE School (N11)",3313,10094]
["St. Paul's CE School (NW7)",3314,10095]
["St. Theresa's RC School",3507,10108]
["St. Vincent's RC School",3506,10096]
["Summerside School ",2052,10098]
["Sunnyfields School",2070,10097]
["Trent CE School",3316,10100]
["Tudor School",2055,10101]
["Underhill School",2057,10103]
["Wessex Gardens School",2076,10124]
["Whitings Hill School",2060,10105]
["Woodcroft Primary",3518,10123]
["Woodridge School",2054,10109]
[]
["Finchley Catholic High School",5405,10145]
["Friern Barnet School",4003,10139]
["JCOSS",5427,11174]
["Menorah High",4004,11513]
["St James' Catholic High School",5407,10142]
["St. Michael's Catholic Grammar School",5404,10148]
[]
["Mapledown School",7010,10159]
["Northway School",7005,10157]
["Oakleigh School",7009,10158]
[]
["Northgate",1102,10185]
["Pavillion",1100,10188]
[]
[]
[]
["Bishop Douglass RC High",5408,10137]
["Broadfields Primary",3519,10134]
["Claremont Primary School",3522,10953]
["Deansbrook Junior School",2018,10058]
["Edgware Junior School",2022,10062]
["Grasvenor Avenue Infant School",2030,10070]
["Hyde School",2074,10122]
["Oak Lodge School",7000,10156]
["Parkfield School",2000,10120]
["St. Joseph's RC Infant School",3508,10111]
["St Mary's CE High School ",5403,10143]
["Underhill Junior School",2056,10102]
["Copthall School",4210,10152]
["Henrietta Barnett School ",4752,10147]
["Discovery Bay",1103,10186]

{"sheet":"Cost Centres ","index":15,"n_rows":117,"n_cols":3,"rows_kept":117,"cut":false,"hidden":true,"merged":[]}
[]
["SAP Cost Centre","School","DfES NO."]
[]
[10040,"All Saints' CE School (NW2)",3300]
[10042,"All Saints' CE School (N20)",3317]
[10043,"Annunciation RC Infant School",3500]
[10044,"Barnfield School",2002]
[10045,"Bell Lane School",2003]
[10046,"Brookland Junior School",2007]
[10047,"Brookland Infant School",2008]
[10048,"Brunswick Park School",2009]
[10049,"Childs Hill School",2010]
[10050,"Christ Church CE School",3302]
[10051,"Church Hill School",2011]
[10054,"Colindale School",2014]
[10055,"Coppetts Wood School",2015]
[10056,"Courtland School",2016]
[10057,"Cromer Road School",2017]
[10058,"Deansbrook Junior School",2018]
[10059,"Deansbrook Infant School",2019]
[10060,"Dollis Junior School",5200]
[10061,"Dollis Infant School",2021]
[10062,"Edgware Junior School",2022]
[10063,"Edgware Infant School",2023]
[10064,"Fairway School",2024]
[10065,"Foulds School",2025]
[10066,"Frith Manor School",2026]
[10067,"Garden Suburb Junior School",2027]
[10068,"Garden Suburb Infant School",2028]
[10069,"Goldbeaters School",2029]
[10070,"Grasvenor Avenue Infant School",2030]
[10071,"Hollickwood School",2031]
[10072,"Holly Park School",2032]
[10073,"Holy Trinity CE School",3304]
[10074,"Livingstone School",2036]
[10075,"Manorside School ",2037]
[10076,"Martin Junior School",2039]
[10077,"Martin Infant School",2040]
[10078,"Monken Hadley CE School",3305]
[10079,"Monkfrith School",2042]
[10080,"Moss Hall Junior School",2043]
[10081,"Moss Hall Infant School",2044]
[10082,"Northside School",2045]
[10083,"Danegrove School",2073]
[10084,"Osidge School",5201]
[10085,"Our Lady of Lourdes RC School",3501]
[10086,"Queenswell Junior School",2072]
[10087,"St. Agnes' RC School",3502]
[10088,"St. Catherine's RC School",3504]
[10089,"St. John's CE School (N11)",3307]
[10092,"St. Mary's CE School (N3)",3311]
[10093,"St. Mary's CE School (EN4)",3312]
[10094,"St. Paul's CE School (N11)",3313]
[10095,"St. Paul's CE School (NW7)",3314]
[10096,"St. Vincent's RC School",3506]
[10097,"Sunnyfields School",2070]
[10098,"Summerside School ",2052]
[10099,"St. Andrew's CE School",3315]
[10100,"Trent CE School",3316]
[10101,"Tudor School",2055]
[10102,"Underhill Junior School",2056]
[10103,"Underhill Infant School",2057]
[10105,"Whitings Hill School",2060]
[10106,"Independent Jewish Day School",3515]
[10107,"St. Joseph's RC Junior School",3509]
[10108,"St. Theresa's RC School",3507]
[10109,"Woodridge School",2054]
[10110,"Sacred Heart RC School",3510]
[10111,"St. Joseph's RC Infant School",3508]
[10112,"Rosh Pinah School",3512]
[10113,"Barnet Hill School",2064]
[10114,"Menorah Primary School",3513]
[10115,"Blessed Dominic RC School",3511]
[10116,"St. John's CE School (N20)",3309]
[10117,"Annunciation RC Junior School",3514]
[10118,"Chalgrove School",2067]
[10119,"Queenswell Infant School",2071]
[10120,"Parkfield School",2000]
[10121,"Hasmonean Primary School",3516]
[10122,"Hyde School",2074]
[10123,"Woodcroft Primary",3518]
[10124,"Wessex Gardens School",2076]
[10125,"Mathilda Marks Kennedy School",5948]
[10126,"Menorah Foundation School",5949]
[10127,"Orion School",2077]
[10128,"Beis Yaakov",2079]
[10129,"Pardes House School",2078]
[10130,"Brookhill Nursery",1000]
[10131,"Hampden Way Nursery",1001]
[10132,"Moss Hall Nursery",1002]
[10133,"St Margaret's Nursery",1003]
[10134,"Broadfields Primary",3519]
[10136,"Ashmole School",5406]
[10137,"Bishop Douglass RC High",5408]
[10138,"Compton School",4215]
[10139,"Friern Barnet School",4003]
[10140,"Mill Hill High School",5402]
[10141,"Ravenscroft School",4009]
[10142,"St James' Catholic High School",5407]
[10143,"St Mary's CE High School ",5403]
[10144,"Whitefield School",4012]
[10145,"Finchley Catholic High School",5405]
[10146,"Hasmonean High School",5409]
[10147,"Henrietta Barnett School ",4752]
[10148,"St. Michael's Catholic Grammar School",5404]
[10149,"Queen Elizabeth's School, Barnet",5401]
[10150,"Hendon School",5400]
[10151,"Christ's College ",4211]
[10152,"Copthall School",4210]
[10153,"East Barnet School",4212]
[10154,"Queen Elizabeth's Girls' School",4208]
[10156,"Oak Lodge School",7000]
[10157,"Northway School",7005]
[10158,"Oakleigh School",7009]
[10159,"Mapledown School",7010]
[10698,"St. Mary's & St. Johns Primary",3521]
[10953,"Claremont Primary School",3522]

{"sheet":"LOOK UPS","index":16,"n_rows":207,"n_cols":3,"rows_kept":207,"cut":false,"hidden":false,"merged":[]}
[]
["School","DCSF","SAP Cost Centre"]
["School name",null,"cost centre"]
["Brookhill Nursery",1000,10130]
["Hampden Way Nursery",1001,10131]
["Moss Hall Nursery",1002,10132]
["St Margaret's Nursery",1003,10133]
["Akiva",3520,11094]
["All Saints' CE School (N20)",3317,10042]
["All Saints' CE School (NW2)",3300,10040]
["Annunciation RC Infant School",3500,10043]
["Annunciation RC Junior School",3514,10117]
["Barnfield School",2002,10044]
["Beis Yaakov",2079,10128]
["Beit Shvidler",3524,11278]
["Bell Lane School",2003,10045]
["Blessed Dominic RC School",3511,10115]
["Brookland Infant School",2008,10047]
["Brookland Junior School",2007,10046]
["Brunswick Park School",2009,10048]
["Chalgrove School",2067,10118]
["Childs Hill School",2010,10049]
["Christ Church CE School",3302,10050]
["Church Hill School",2011,10051]
["Colindale School",2014,10054]
["Coppetts Wood School",2015,10055]
["Courtland School",2016,10056]
["Cromer Road School",2017,10057]
["Danegrove School",2073,10083]
["Deansbrook Infant School",2019,10059]
["Dollis Infant School",2021,10061]
["Dollis Junior School",5200,10060]
["Edgware Primary School",2023,10063]
["Fairway School",2024,10064]
["Foulds School",2025,10065]
["Frith Manor School",2026,10066]
["Garden Suburb Infant School",2028,10068]
["Garden Suburb Junior School",2027,10067]
["Goldbeaters School",2029,10069]
["Hasmonean Primary School",3516,10121]
["Hollickwood School",2031,10071]
["Holly Park School",2032,10072]
["Holy Trinity CE School",3304,10073]
["Livingstone School",2036,10074]
["Manorside School ",2037,10075]
["Martin Primary",3523,11093]
["Mathilda Marks Kennedy School",5948,10125]
["Menorah Foundation School",5949,10126]
["Menorah Primary School",3513,10114]
["Monken Hadley CE School",3305,10078]
["Monkfrith School",2042,10079]
["Moss Hall Infant School",2044,10081]
["Moss Hall Junior School",2043,10080]
["Northside School",2045,10082]
["Orion School",2077,10127]
["Osidge School",5201,10084]
["Our Lady of Lourdes RC School",3501,10085]
["Pardes House School",2078,10129]
["Queenswell Infant School",2071,10119]
["Queenswell Junior School",2072,10086]
["Rosh Pinah School",3512,10112]
["Sacred Heart RC School",3510,10110]
["St. Agnes' RC School",3502,10087]
["St. Andrew's CE School",3315,10099]
["St. Catherine's RC School",3504,10088]
["St. John's CE School (N11)",3307,10089]
["St. John's CE School (N20)",3309,10116]
["St. Joseph's RC Junior School",3509,10107]
["St. Mary's & St. Johns Primary",3521,10698]
["St. Mary's CE School (EN4)",3312,10093]
["St. Mary's CE School (N3)",3311,10092]
["St. Paul's CE School (N11)",3313,10094]
["St. Paul's CE School (NW7)",3314,10095]
["St. Theresa's RC School",3507,10108]
["St. Vincent's RC School",3506,10096]
["Summerside School ",2052,10098]
["Sunnyfields School",2070,10097]
["Trent CE School",3316,10100]
["Tudor School",2055,10101]
["Underhill School",2057,10103]
["Wessex Gardens School",2076,10124]
["Whitings Hill School",2060,10105]
["Woodcroft Primary",3518,10123]
["Woodridge School",2054,10109]
["Finchley Catholic High School",5405,10145]
["Friern Barnet School",4003,10139]
["JCOSS",5427,11174]
["Menorah High",4004,11513]
["St James' Catholic High School",5407,10142]
["St. Michael's Catholic Grammar School",5404,10148]
["Mapledown School",7010,10159]
["Northway School",7005,10157]
["Oakleigh School",7009,10158]
["Northgate",1102,10185]
["Pavillion",1100,10188]
["Bishop Douglass RC High",5408,10137]
["Broadfields Primary",3519,10134]
["Claremont Primary School",3522,10953]
["Deansbrook Junior School",2018,10058]
["Edgware Junior School",2022,10062]
["Grasvenor Avenue Infant School",2030,10070]
["Hyde School",2074,10122]
["Oak Lodge School",7000,10156]
["Parkfield School",2000,10120]
["St. Joseph's RC Infant School",3508,10111]
["St Mary's CE High School ",5403,10143]
["Underhill Junior School",2056,10102]
["Copthall School",4210,10152]
["Henrietta Barnett School ",4752,10147]
["Discovery Bay",1103,10186]
[]
[]
[]
[]
[]
[]
[]
[]
["CE01","Acquisition of Land & Buildings"]
["CE02","New Construction, Conversion & Renovation"]
["CE03","Vehicles, Plant, Equipment & Machinery"]
["CE04","Information Communications Technology"]
["CI01","Capital Income"]
["CI03","Voluntary or Private Capital Income"]
["E01","Teaching Staff"]
["E02","Supply Teaching Staff"]
["E03","Education Support Staff"]
["E04","Premises Staff"]
["E05","Administrative & Clerical Staff"]
["E06","Catering Staff"]
["E07","Cost of Other Staff"]
["E08","Indirect Employee Expenses"]
["E09","Staff Development & Training"]
["E10","Supply Teacher Insurance"]
["E11","Staff Related Insurance"]
["E12","Building Maintenance & Improvement"]
["E13","Grounds Maintenance & Improvement"]
["E14","Cleaning & Caretaking"]
["E15","Water & Sewerage"]
["E16","Energy"]
["E17","Rates"]
["E18","Other Occupation Costs"]
["E19","Learning Resources"]
["E20","ICT Learning Resources"]
["E21","Exam Fees"]
["E22","Administrative Supplies"]
["E23","Other Insurance Premiums"]
["E24","Special Facilities"]
["E25","Catering Supplies"]
["E26","Agency Supply Teachers"]
["E27","Bought in Professional Services - Curriculum"]
["E28","Bought in Professional Services - Other"]
["E29","Loan Interest"]
["E31","Community Extended School - Staff Costs"]
["E32","Community Extended School - Other Costs"]
["I01","Funds Delegated By LEA"]
["I02","Funding for 6th Form Students"]
["I03","SEN Funding"]
["I04","Funding for Minority Ethnic Pupils"]
["I05","Pupil Premium"]
["I06","Other Government Grants"]
["I07","Other Grants & Payments"]
["I08","Income from Facilities & Services"]
["I09","Income from Catering"]
["I10","Receipts from Supply Teacher Insurance Claims"]
["I11","Receipts from Other Insurance Claims"]
["I12","Income from Contributions"]
["I13","Donations and/or Voluntary Funds"]
["I15","Extended School Funding - Pupil Focussed "]
["I16","Extended School Funding - Community Focussed"]
["I17","Community Extended School - Other Income"]
[]
[]
[]
[]
["i0Debtor","good"]
["I1Debtor","good"]
["CIDebtor","good"]
["e0Creditor","good"]
["e1Creditor","good"]
["e2Creditor","good"]
["e3Creditor","good"]
["ceCreditor","good"]
["e0Payments in Advance","good"]
["e1Payments in Advance","good"]
["e2Payments in Advance","good"]
["e3Payments in Advance","good"]
["cePayments in Advance","good"]
["i0Receipts in Advance","good"]
["i1Receipts in Advance","good"]
["CIReceipts in Advance","good"]
["e0Debtor","error, correct before submitting the form."]
["e1Debtor","error, correct before submitting the form."]
["e2Debtor","error, correct before submitting the form."]
["e3Debtor","error, correct before submitting the form."]
["ceDebtor","error, correct before submitting the form."]
["i0Creditor","error, correct before submitting the form."]
["i1Creditor","error, correct before submitting the form."]
["CICreditor","error, correct before submitting the form."]
["i0Payments in Advance","error, correct before submitting the form."]
["i1Payments in Advance","error, correct before submitting the form."]
["ciPayments in Advance","error, correct before submitting the form."]
["e0Receipts in Advance","error, correct before submitting the form."]
["e1Receipts in Advance","error, correct before submitting the form."]
["e2Receipts in Advance","error, correct before submitting the form."]
["e3Receipts in Advance","error, correct before submitting the form."]
["ceReceipts in Advance","error, correct before submitting the form."]

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