{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data Sheet","Instructions","Ref sheet"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data Sheet","index":0,"n_rows":110,"n_cols":28,"rows_kept":110,"cut":false,"hidden":false,"merged":[[2,1,2,2],[3,1,3,2],[4,0,5,0]]}
[null,null,"ACC Bulk Job Sheet",null,null,"Email job sheet & invoice to: accrepairs@enable.co.nz"]
[]
["Company name",null,null,null,"Invoice date"]
["Vendor ID",null,null,null,"Invoice number"]
["Job sheet period","START","END",null,"TOTAL EX GST",{"$f":"+SUM(U9:U108)","v":0},null,null,{"$f":"IF(COUNTBLANK(Y9:Y108)=100, \"\", \"Check Column Y - line item over $1k.\")","v":""}]
[]
[{"$f":"IF(COUNTIF(AB9:AB108,\"*equipment*\"),\"Please check error column at the end of the table\",\"\")","v":""}]
["Job Ref #","Charge type","Claim Number","First Name","Surname","Street #","Street Address","Town City","Date Job  Requested","Date Job Completed","Asset #","Asset Description","Asset Serial No.","Job Details","Labour Hours","Travel Distance (km)","Parts Description","Parts Costs","Labour Total ","Travel Total ","TOTAL JOB COST","Company Name","Cost  per unit","Cost  per unit","Total check","Equipment Type","Limit","Error"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O9>0,O9*W9,)","v":0},{"$f":"IF(P9>0,P9*X9,)","v":0},{"$f":"R9+T9+S9","v":0},{"$f":"IF(B9<>\"\",$B$3,\"\")","v":""},85,0.64,{"$f":"IF(U9>1999.99,\"OVER $2k - contact Enable\",\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(Z9,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},{"$f":"IF(AND(Z9 = \"\", U9 <> 0), \"Please set equipment type\", IF(AA9<U9,\"Over equipment type limit\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O10>0,O10*W10,)","v":0},{"$f":"IF(P10>0,P10*X10,)","v":0},{"$f":"R10+T10+S10","v":0},"",85,0.64,{"$f":"IF(U10>1999.99,\"OVER $2k - contact Enable\",\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(Z10,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},{"$f":"IF(AND(Z10 = \"\", U10 <> 0), \"Please set equipment type\", IF(AA10<U10,\"Over equipment type limit\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z11,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},{"$f":"IF(AND(Z11 = \"\", U11 <> 0), \"Please set equipment type\", IF(AA11<U11,\"Over equipment type limit\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z12,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z13,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z14,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z15,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z16,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z17,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z18,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z19,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z20,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z21,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O22>0,O22*W22,)","v":0},{"$f":"IF(P22>0,P22*X22,)","v":0},{"$f":"R22+T22+S22","v":0},"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z22,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z23,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z24,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z25,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z26,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z27,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z28,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z29,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z30,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z31,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z32,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z33,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z34,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z35,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z36,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z37,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z38,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z39,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z40,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"IF(B41<>\"\",$B$3,\"\")","v":""},85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z41,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z42,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z43,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z44,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z45,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z46,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O47>0,O47*W47,)","v":0},{"$f":"IF(P47>0,P47*X47,)","v":0},{"$f":"R47+T47+S47","v":0},"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z47,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z48,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z49,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z50,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z51,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z52,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z53,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z54,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z55,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z56,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z57,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z58,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z59,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z60,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z61,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z62,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z63,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z64,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z65,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z66,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z67,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z68,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z69,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z70,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z71,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z72,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"IF(B73<>\"\",$B$3,\"\")","v":""},85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z73,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,{"$f":"IF(U74>1999.99,\"OVER $2k - contact Enable\",\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(Z74,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},{"$f":"IF(AND(Z74 = \"\", U74 <> 0), \"Please set equipment type\", IF(AA74<U74,\"Over equipment type limit\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z75,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z76,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z77,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z78,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z79,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z80,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z81,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z82,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z83,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z84,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z85,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z86,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z87,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z88,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z89,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z90,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z91,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z92,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O93>0,O93*W93,)","v":0},{"$f":"IF(P93>0,P93*X93,)","v":0},{"$f":"R93+T93+S93","v":0},"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z93,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z94,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z95,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z96,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z97,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z98,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z99,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z100,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z101,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z102,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z103,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z104,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z105,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z106,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z107,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z108,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(S9:S108,T9:T108,R9:R108)=SUM(U9:U108),\"OK\",\"ERROR\")","v":"OK"},null,{"$f":"IF(AVERAGE(W9:W108)=85,\"OK\",\"ERROR\")","v":"OK"},{"$f":"IF(MAX(X9:X108)=0.64,\"OK\",\"ERROR\")","v":"OK"}]

{"sheet":"Instructions","index":1,"n_rows":62,"n_cols":28,"rows_kept":62,"cut":false,"hidden":false,"merged":[[43,1,43,2],[44,1,44,2],[45,0,46,0]]}
["INSTRUCTIONS:"]
[]
[]
[]
[]
[]
[]
["Field ","Description"]
["Company Name","Your company name"]
["Job card period ","Start date of job card to end date  (could be a week/two weeks or month)"]
["Invoice date","Date of your invoice"]
[]
["Job Ref #","Your own reference number (recommneded but optional)"]
["Charge type","Use drop down list to choose service type"]
["Claim Number","Must be provided in order to submit a claim"]
["First Name","Clients First Name"]
["Surname","Clients Surname"]
["Street #","Clients Street Address (number)"]
["Street Address","Clients Street Name"]
["Town/City","Clients Town/city"]
["Dat job requested","Date you received the service/repair/job"]
["Date job completed","Date job completed"]
["Asset #","Asset Number per label on equipment (don’t include \"A\" at beginning of number)"]
["Asset Description","Description of equipment"]
["Asset Serial No.","Serial number of asset (if applicable)"]
["Repair description","Description of job undertaken"]
["Labour Hours","Time spent on repair (billable hours). Enter as decimal (eg 30mins = 0.5,  1 hr 15 mins = 1.25)"]
["Travel Distance (km)","Travel distance to site for this repair (or apportion if multiple jobs)"]
["Parts Description","Description of parts used"]
["Parts Costs","Cost of parts used"]
["Labour Total ","Calculation- ENZ only field"]
["Travel Total ","Calculation- ENZ only field"]
["TOTAL JOB COST","Calculation- ENZ only field"]
["Company Name","ENZ only field"]
["Cost  per unit","ENZ only field"]
["Cost  per unit","ENZ only field"]
["Total check","Shows error if job over $2k"]
["Equipment Type","Select the equipment category you are working on"]
["Limit","Benchmark Limit"]
[]
["Example below;"]
[null,null,"ACC Bulk Job Sheet",null,null,null,"Email job sheet & invoice to: accrepairs@enable.co.nz"]
[]
["COMPANY NAME",null,null,null,"INVOICE DATE"]
["VENDOR ID",null,null,null,"INVOICE NUMBER"]
["Job sheet period","START","END",null,"TOTAL EX GST",{"$f":"+SUM(U50:U149)","v":1037},null,null,{"$f":"IF(COUNTBLANK(Y50:Y149)=100, \"\", \"Check Column Y - line item over $1k.\")","v":""}]
[]
[{"$f":"IF(COUNTIF(AB50:AB149,\"*equipment*\"),\"Please check error column at the end of the table\",\"\")","v":""}]
["Job Ref #","Charge type","Claim Number","First Name","Surname","Street #","Street Address","Town City","Date Job  Requested","Date Job Completed","Asset #","Asset Description","Asset Serial No.","Job Details","Labour Hours","Travel Distance (km)","Parts Description","Parts Costs","Labour Total ","Travel Total ","TOTAL JOB COST","Company Name","Cost  per unit","Cost  per unit","Total check","Equipment Type","Limit","Error"]
["ABC567","RP - Repair ","A123456789","Mickey","Mouse",345,"Sesame Street","Patea","2025-05-25","2025-05-26","ACC1234566","Power wheelchair","NA","PWC is not charging correctly, new battery",3,50,"Battery",750,{"$f":"IF(O50>0,O50*W50,)","v":255},32,{"$f":"R50+T50+S50","v":1037},{"$f":"IF(B50<>\"\",$B$3,\"\")","v":0},85,0.64,{"$f":"IF(U50>1999.99,\"OVER $2k - contact Enable\",\"\")","v":""},"Powered Wheelchairs",{"$f":"IFERROR(VLOOKUP(Z50,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":2000},{"$f":"IF(AND(Z50 = \"\", U50 <> 0), \"Please set equipment type\", IF(AA50<U50,\"Over equipment type limit\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,{"$f":"IF(U51>1999.99,\"OVER $2k - contact Enable\",\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(Z51,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},{"$f":"IF(AND(Z51 = \"\", U51 <> 0), \"Please set equipment type\", IF(AA51<U51,\"Over equipment type limit\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z52,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},{"$f":"IF(AND(Z52 = \"\", U52 <> 0), \"Please set equipment type\", IF(AA52<U52,\"Over equipment type limit\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z53,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",85,0.64,"",null,{"$f":"IFERROR(VLOOKUP(Z54,'Ref sheet'!Q$2:R$7,2,FALSE),\"\")","v":""},""]
[]
[]
[]
[]
["To clear and rest the spreadsheet please click the button"]
[]
["NOTE: THIS WILL DELETE ALL DATA SO EITHER SAVE"]
["A COPY FIRST OR SEND TO ENABLE BEFORE PRESSING"]

{"sheet":"Ref sheet","index":2,"n_rows":44,"n_cols":25,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["Charge Type","RP - Repair ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge limits"]
[null,"MD - Modification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Powered Wheelchairs",2000]
[null,"RF - Refurbishment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manual Wheelchairs",1600]
[null,"SA - Setup/Adjust",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hoists",800]
[null,"AS - Annual Service",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beds",900]
[null,"CL - Collect or Deliver",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bath/Toilets",2300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",1000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Enable New Zealand ACC Under $2,000 Job card record"]
[]
[null,"Company Name","ABC Repairs Ltd",null,null,null,"Invoice date","2021-11-26"]
[null,null,"Start Date","End date",null,null,"Invoice Number","ABC0001"]
[null,"Job card period","2021-11-15","2021-11-26",null,null,"Total Value (excl GST)",{"$f":"+SUM(U25:U44)","v":0},{"$f":"IF(COUNTBLANK(Y25:Y44)=20, \"\", \"Check Column Y - line item over $1k.\")","v":""}]
[]
[]
["Job Ref","Charge type","ACC Claim Number","Clients First Name","Clients Surname","Clients Address Street No","Clients Address Street ","Clients Address Town/City","Date repair/service requested","Date  repair/service completed","Asset Number","Asset Description","Asset Serial No.","Repair description","Labour Hours","Travel Distance (km)","Parts Description","Parts Costs","Labour Total ","Travel Total ","TOTAL JOB COST","Company Name","Cost  per unit","Cost  per unit","Total check"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O25>0,O25*W25,)","v":0},{"$f":"IF(P25>0,P25*X25,)","v":0},{"$f":"R25+T25+S25","v":0},{"$f":"IF(B25<>\"\",$C$3,\"\")","v":""},75,0.63,{"$f":"IF(U25>1999.99,\"OVER $2k - contact Enable\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,{"$f":"IF(U26>1999.99,\"OVER $2k - contact Enable\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",75,0.63,""]