{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Sheet2","Data Entry","Master list","items in depth","Sheet6","Sheet4","Sheet3","Sheet1","AM 62","Data","Sheet5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":27,"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":"Sheet2","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Data Entry","index":1,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,1,24,2],[25,1,25,2],[1,1,1,4],[7,4,7,5],[6,4,6,5],[8,4,8,5],[7,1,7,2],[8,1,8,2],[5,1,5,2],[6,1,6,2],[4,4,4,5],[4,1,4,2],[5,4,5,5]]}
[]
[null,"Delviery note Data entry "]
[]
[null,"Please fill out the below cells "]
[null,"SHIPPER",null,null,"DATE"]
[null,"LOCATION/ADDRESS",null,null,"CONSIGNEE"]
[null,"VEHICLE TYPE",null,null,"LOCATION/ADDRESS"]
[null,"PLATE NO.",null,null,"DRIVER "]
[null,"JOB ID",null,null,"RIG NO."]
[null,null,null,null,null,null,null,null,null,"CountA for Colum A12:A23"]
[null,"ITEM","PART NO.","DESCRIPTION","SERIAL NO.","UOM ","QTY","REMARK (i.e. Used, Unused)",null,{"$f":"COUNT(B12:B22)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Macro has been assign to above button to transfer the data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sender Name",null,"Postion "]
[null,"Hemn",null,"Field engineer"]

{"sheet":"Master list","index":2,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,13,2,14]]}
[]
[null,"Delivery note Track Records Master list"]
["Items ","DN Number","Date","SHIPPER","LOCATION/ADDRESS","VEHICLE TYPE","PLATE NO.","JOB ID","CONSIGNEE","LOCATION/ADDRESS2","DRIVER ","RIG NO."]
[0,"DK-FSM-001",0,0]
[{"$f":"A4+1","v":1},{"$f":"LEFT(B4,7)&TEXT(RIGHT(B4,3)+1,\"000\")","v":"DK-FSM-002"},43990,"HTML"]
[{"$f":"A5+1","v":2},{"$f":"LEFT(B5,7)&TEXT(RIGHT(B5,3)+1,\"000\")","v":"DK-FSM-003"},43990,"Hemn"]
[{"$f":"A6+1","v":3},{"$f":"LEFT(B6,7)&TEXT(RIGHT(B6,3)+1,\"000\")","v":"DK-FSM-004"},43990,3344]

{"sheet":"items in depth","index":3,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Items Descrition in depth related to DN numbers"]
[]
["DN Number","Date","ITEM","PART NO.","DESCRIPTION","SERIAL NO.","UOM ","QTY","REMARK (i.e. Used, Unused)"]
[0,0,0]
[{"$f":"'Master list'!B5","v":"DK-FSM-002"},{"$f":"'Master list'!C5","v":"2020-06-08"},1]
[null,null,2]
[null,null,3]
[{"$f":"'Master list'!B8","v":0},{"$f":"'Master list'!C8","v":"00:00:00"},1]
[null,null,2]
[null,null,3]
[{"$f":"'Master list'!B11","v":0},{"$f":"'Master list'!C11","v":"00:00:00"},1,"fg"]
[null,null,2,"dfg","g"]
[null,null,3,"fg","fgfg"]
[null,null,4,"g"]
[null,null,5,"fg"]
[]
[]
[]
[]
[null,null,null,null,"Hint"]
[null,null,null,null,"Three record has been added to the master and items in depth sheets using macro button"]
[null,null,null,null,"in this example A6:A8 needs to get merged because column C has on only 3 items  and it is quite the same for column B6:B8"]
[null,null,null,null,"B9:B11 and A9:A11 same too while item is 3 lines (rows)"]
[null,null,null,null,"A12:A16 needs to get merged as column C is 5 items for that record, same rules for B12:B16"]
[]
[]
[null,null,null,null,"while it get merged the value should be based on master list sheet respectively "]
[null,null,null,null,"for exampe A6:A8 should be DK-FSM-002 and B6:B8 should be second record date in master list which is 6/8/2020 for that example "]
[null,null,null,null,"and so one for others "]

{"sheet":"Sheet6","index":4,"n_rows":8,"n_cols":31,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT","SWT"]
[]
[]
[]
[]
[]
[null,26,6]
[null,25,25]

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

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

{"sheet":"Sheet1","index":7,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
["Ser.","Plate Number","Type","Unit Attached","Contractor"]
[1,"4040 Basra","Crane 20 Ton","SLS","Arabian Gulf"]
[2,"3333 Basra","Crane 20 Ton","SLS","Arabian Gulf"]
[3,"2593 Basra","Crane 50 Ton","SWT","Arabian Gulf"]
[4,"2900 Erbil","Crane 30 Ton","SLS","Arabian Gulf"]
[5,"4628 Basra","Crane 25 Ton","SLS","Arabian Gulf"]
[6,"1328 Dhiqar","Crane 50 Ton","SWT","Arabian Gulf"]
[7,"41796 Sulymaniya","Water Tank","SWT","Arabian Gulf"]
[8,"16227 Baghdad","Vacuum Pump","SWT","Arabian Gulf"]
[9,"28237 Dahuk","Water Tank","SWT","Arabian Gulf"]
[10,"153734 Erbil","Self-loader","SWT","Arabian Gulf"]
[11,"139494 Erbil","Self-loader","SWT/MPFM","Arabian Gulf"]
[12,"131416 Erbil","12 Ton Truck","SLS","Arabian Gulf"]
[13,"7565 Basra","12 Ton Truck","SLS","Arabian Gulf"]
[14,"33669 Basra","HEAD + Lowboy","SLS","Arabian Gulf"]
[15,"74418 Erbil","HEAD + Trailer 36 Ton","SWT","Arabian Gulf"]
[16,"7615 Basra","HEAD + Lowboy","SLS","Arabian Gulf"]
[17,"15305 Erbil","HEAD","SWT","Arabian Gulf"]
[18,"91667 Basra","Forklift","SWT","Arabian Gulf"]
[19,"73618 Basra","Forklift","SLS","Arabian Gulf"]
[20,"11720 Erbil","Trailer (flatbed)","SWT","Arabian Gulf"]
[21,"116761 Erbil","Trailer (flatbed)","SWT","Arabian Gulf"]
[22,"68502 Erbil","Trailer (flatbed)","SWT","Arabian Gulf"]
[23,"10935 Erbil","Trailer (flatbed)","SWT","Arabian Gulf"]
[24,"89010 Erbil","Trailer (flatbed)","SLS","Arabian Gulf"]
[25,"76902 Erbil","Trailer (flatbed)","SWT/PTU","Arabian Gulf"]
[26,"135602 Erbil","Trailer (flatbed)","SWT","Noor Co."]
[27,"84073 Erbil","Trailer (flatbed)","SWT","Noor Co."]
[28,"135478 Erbil","Trailer (flatbed)","SWT","Noor Co."]
[29,"119558 Erbil","HEAD","SLS","Noor Co."]
[30,"74483 Sulymaniya","Trailer (flatbed)","SWT","Noor Co."]
[31,"42833 Sulymaniya","Trailer (flatbed)","SWT","Noor Co."]
[32,"73208 Sulymaniya","HEAD","SLS","Noor Co."]
[33,"89914 Basra","Trailer (flatbed)","SWT","Noor Co."]
[34,"48670 Erbil","Trailer (flatbed)","SWT","Noor Co."]
[35,"116405 Erbil","Trailer (flatbed)","SLS","Noor Co."]
[36,"141737 Erbil","Trailer (flatbed)","SWT","Noor Co.",null,"Ser.","Plate Number","Type","Unit Attached","Contractor"]
[37,"115139 Erbil","HEAD + Trailer","SWT/PTU","Ibrahim",null,1,"3494 Basra","Crane","WLS","Arabian Gulf"]
[38,"69019 Erbil","HEAD + Trailer 36 Ton","SWT","Muslim",null,2,"3817 Basra","Crane","WLS","Arabian Gulf"]
[39,"5960 Erbil","HEAD + Trailer 36 Ton","SWT","Hammed ",null,3,"475298 Baghdad","Crane","WLS","Arabian Gulf"]

{"sheet":"AM 62","index":8,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Plate No.","Days On","Cost P/Day","Cost P/Month","FSM","Absent"]
["8228 Basra",31,209.67741935483872,6500,6500,0]
[58437,31,209.67741935483872,6500,6500,0]
[120580,20,64.516129032258064,2000,1333.3333333333335,666.66666666666652]
[null,null,null,null,{"$f":"SUM(E2:E4)","v":14333.333333333334},null,{"$f":"SUM(E5:F5)","v":14333.333333333334}]

{"sheet":"Data","index":9,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["HR","Human Resource"]
["SQSHE","Safety",null,null,"UN","Unutilized"]
["OC","OiLSERV City",null,null,"Base","Working in Base"]
["SC","Supply chain"]
["FI","Finance"]
["IT","IT Services"]
["MT-V","Maintenance-Vechiles"]
["MT-F","Maintenance"]
["PE","Permit"]
["MT.F.","facility maintenance"]
["A","3rd Party Absent- NO PAY"]
["ENI.R","IOS Cost for ENI Rigless Project"]
["EXXON","IOS Cost for Exxon Project"]
["ENI80","IOS Cost for ENI80 Project"]
["ENI6","IOS Cost for ENI6 Project"]
["TRS","To be Recharged to PrimaDrill "]
["CTS","Coiltubing"]
["STM","Stimulation"]
["CMT","Cementing"]
["SWT","Surface Wire Testing"]
["SLS","Slickline services"]
["WHM","Wellhead Maintenance"]
["DST","NS"]
["FMS","Fluid & Solid Management"]
["WMS","Waste Management Services (FMS)"]
["SPS","Surface Production Services"]
["OFF","OFF Hire - NO Cost for OiLSERV"]
["Pool","Pool(To be Recharged on usage)"]
["TCP","WLS TCP"]
["CHS","WLSCHS"]
["DDS","Drilling "]
["DDT","Drilling Tools"]
["MDL","MDL"]
["ENI.R-24","24 hours Operations"]
["EXXON-24","24 hours Operations"]
["ENI80-24","24 hours Operations"]
["ENI6-24","24 hours Operations"]
["TRS-24","24 hours Operations"]
["CTS-24","24 hours Operations"]
["STM-24","24 hours Operations"]
["CMT-24","24 hours Operations"]
["SWT-24","24 hours Operations"]
["SLS-24","24 hours Operations"]
["WHM-24","24 hours Operations"]
["DST-24","24 hours Operations"]
["FMS-24","24 hours Operations"]
["WMS-24","24 hours Operations"]
["SPS-24","24 hours Operations"]
["TCP-24","24 hours Operations"]
["CHS-24","24 hours Operations"]
["DDS-24","24 hours Operations"]
["DDT-24","24 hours Operations"]
["MDL-24","24 hours Operations"]

{"sheet":"Sheet5","index":10,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Transport No.","Owned By","BL","Make/Model","Asset","Colour","Plate No.","UTILIZATION ",null,"OS","CMT","CTS","WHM","WLS","SPS","SPM","FSM","SLS","SWT","N/A","Days On"]
[null,"Al Maher","CTS","Mercedes","Head + Trailer","White","126953 Erbil",1,null,0,0,31,0,0,0,0,0,0,0,0,31]
[null,"Al Maher","CTS",null,"Forklift 3 ton","Red",38421,1,null,0,0,31,0,0,0,0,0,0,0,0,31]
[null,"Al Maher","WLS","Mercedes","Forklift 7 ton",null,4619,0.74193548387096775,null,0,0,0,0,23,0,0,0,0,0,8,31]
[null,"Al Maher","SWT","Mercedes","Head + Trailer","White","42833 Basra",1,null,0,0,0,0,0,0,0,0,0,31,0,31]
[null,"Al Maher","SWT","Mercedes","Head + Trailer","Blue","135478 Erbil",1,null,0,0,2,0,0,0,0,0,0,29,0,31]
[null,"Al Maher","SWT","Mercedes","Head + Trailer",null,"141737 Erbil",1,null,0,0,2,0,0,0,0,0,0,29,0,31]
[null,"Al Maher","SWT","Mercedes","Head + Trailer","Blue","48670 Erbil",1,null,0,0,4,0,0,0,0,0,1,26,0,31]
[null,"Al Maher","SWT","Mercedes","Head + Trailer","White","135602 Erbil",0.12903225806451613,null,0,0,0,0,0,0,0,0,0,4,0,4]
[null,"Al Maher","SWT","Mercedes","Head + Trailer","White","74483 Silyman",1,null,0,0,9,0,0,0,0,0,0,22,0,31]
[null,"Al Maher","SWT","Mercedes","Head + Trailer","White","116405 Erbil",1,null,0,1,2,0,0,0,0,0,0,28,0,31]
[null,"Al Maher","SWT","Mercedes","Head + Trailer","White","84073 Erbil",1,null,0,0,9,0,2,0,0,0,0,20,0,31]
[null,"Al Maher","WLS","Mercedes","Head + Trailer","Yellow","154931 Erbil",1,null,0,0,0,0,30,0,0,0,0,1,0,31]
[null,"Al Maher","FSM","Scani","Vacuum Truck","Black","8228 Basra",1,null,0,0,0,0,0,0,0,31,0,0,0,31]
[null,"Al Maher","SPS","Mercedes","Self-Loader","White",151201,1,null,0,0,0,0,0,31,0,0,0,0,0,31]
[null,"Al Maher","CTS","Mercedes","Head + Trailer","White",151473,1,null,0,0,31,0,0,0,0,0,0,0,0,31]
[null,"Al Maher","CTS","Mercedes","Head + Trailer","Orange",63176,1,null,0,0,30,0,1,0,0,0,0,0,0,31]
[null,"Al Maher","TST","Mercedes","Head + Trailer","White","55925 Basra",1,null,0,0,0,0,0,0,0,0,0,31,0,31]
[null,"Al Maher","FSM","Mercedes","HEAD (6x4)",null,52480,0.4838709677419355,null,0,0,0,0,0,0,0,15,0,0,0,15]
[null,"Al Maher","SWT","Mercedes","Head + Trailer","White",152201,1,null,0,0,1,0,0,0,0,0,0,30,0,31]
[null,"Al Maher","FSM","Scania","Vacuum Truck",null,58437,1,null,0,0,0,0,0,0,0,31,0,0,0,31]
[null,"Al Maher","LOG","Mercedes","Head + Trailer",null,119558,0.64516129032258063,null,1,1,6,0,3,0,0,0,0,9,0,20]