{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["DB","Input","Plan (keinginan)","Plan"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"DB","index":0,"n_rows":107,"n_cols":8,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Nomor Harness","Warna","Kabel","Panjang","Aむきしろ","Bむきしろ"]
[null,{"$f":"IF(C3=C2,B2,B2+1)","v":1},"MK3EC60171 (J) C01","Ht","UL1571AWG30",873,2.5,3.5]
[null,{"$f":"IF(C4=C3,B3,B3+1)","v":1},"MK3EC60171 (J) C01","Ht","UL1571AWG30",873,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","Ht","UL1571AWG30",873,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","C","UL1571AWG30",828,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","C","UL1571AWG30",828,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","C","UL1571AWG30",828,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","Ht","UL1571AWG30",703,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","U","UL1571AWG30",703,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","M","UL1571AWG30",758,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","O","UL1571AWG30",758,3,3.5]
[null,1,"MK3EC60171 (J) C01","B","UL1571AWG30",123,3,3.5]
[null,1,"MK3EC60171 (J) C01","U","UL1571AWG30",778,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","Ht","UL1571AWG30",728,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","K","UL1571AWG30",498,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","K","UL1571AWG30",498,3,3.5]
[null,1,"MK3EC60171 (J) C01","K","UL1571AWG30",498,2.5,2.5]
[null,1,"MK3EC60171 (J) C01","HJ","UL1571AWG30",543,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","HJ","UL1571AWG30",543,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","HJ","UL1571AWG30",543,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","Ht","UL1571AWG30",513,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","U","UL1571AWG30",513,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","Pt","UL1571AWG30",538,3,3.5]
[null,1,"MK3EC60171 (J) C01","A","UL1571AWG30",538,3,3.5]
[null,1,"MK3EC60171 (J) C01","Pt","UL1571AWG30",538,3,3.5]
[null,1,"MK3EC60171 (J) C01","K","UL1571AWG30",538,3,3.5]
[null,1,"MK3EC60171 (J) C01","Pt","UL1571AWG30",538,3,3.5]
[null,1,"MK3EC60171 (J) C01","HJ","UL1571AWG30",538,3,3.5]
[null,1,"MK3EC60171 (J) C01","Pt","UL1571AWG30",558,3,3.5]
[null,1,"MK3EC60171 (J) C01","A","UL1571AWG30",558,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","Pt","UL1571AWG30",558,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","K","UL1571AWG30",558,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","M","UL1571AWG30",608,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","B","UL1571AWG30",608,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","Pt","UL1571AWG30",608,2.5,3.5]
[null,1,"MK3EC60171 (J) C01","B","UL1571AWG30",608,2.5,3.5]
[null,2,"MK4E50959 (E) C01","O","AWG24",80,2.2000000000000002]
[null,2,"MK4E50959 (E) C01","HJ","AWG24",80,2.2000000000000002]
[null,2,"MK4E50959 (E) C01","U","AWG24",75,2.2000000000000002]
[null,2,"MK4E50959 (E) C01","A","AWG24",75,2.2000000000000002]
[null,2,"MK4E50959 (E) C01","Pt","AWG24",75,2.2000000000000002]
[null,2,"MK4E50959 (E) C01","O","AWG24",75,2.2000000000000002]
[null,2,"MK4E50959 (E) C01","HJ","AWG24",75,2.2000000000000002]
[null,2,"MK4E50959 (E) C01","U","AWG24",75,2.2000000000000002]
[null,3,"MK4E50960 (E) C01","M","AWG24",65,2.2000000000000002]
[null,3,"MK4E50960 (E) C01","O","AWG24",65,2.2000000000000002]
[null,3,"MK4E50960 (E) C01","HJ","AWG24",60,2.2000000000000002]
[null,3,"MK4E50960 (E) C01","U","AWG24",60,2.2000000000000002]
[null,3,"MK4E50960 (E) C01","A","AWG24",60,2.2000000000000002]
[null,3,"MK4E50960 (E) C01","Pt","AWG24",60,2.2000000000000002]
[null,3,"MK4E50960 (E) C01","O","AWG24",60,2.2000000000000002]
[null,4,"MK4EC63808 (A) C01","Pt","UL1061AWG22",53,2.5,2.5]
[null,4,"MK4EC63808 (A) C01","Pt","UL1061AWG22",53,2.5,2.5]
[null,4,"MK4EC63808 (A) C01","Pt","UL1061AWG22",53,2.5,2.5]
[null,4,"MK4EC63808 (A) C01","Pt","UL1061AWG22",53,2.5,2.5]
[null,4,"MK4EC63808 (A) C01","Pt","UL1061AWG22",53,2.5,2.5]
[null,4,"MK4EC63808 (A) C01","Pt","UL1061AWG22",53,2.5,2.5]
[null,5,"MK4EC59289 (D) C02","M","UL1061AWG26",765,2.2000000000000002,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",765,2.5,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",765,2.5,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",765,2.2000000000000002,2.5]
[null,5,"MK4EC59289 (D) C02","M","UL1061AWG26",225,2.2000000000000002,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",225,2.2000000000000002,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",225,2.5,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",225,2.5,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",225,2.5,2.5]
[null,{"$f":"IF(C68=C67,B67,B67+1)","v":5},"MK4EC59289 (D) C02","Ht","UL1061AWG26",225,2.5,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",225,2.5,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",225,2.5,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",225,2.5,2.5]
[null,5,"MK4EC59289 (D) C02","M","UL1061AWG26",60,2.5,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",60,2.5,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",60,2.5,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",60,2.5,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",60,2.5,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",60,2.5,2.5]
[null,5,"MK4EC59289 (D) C02","Ht","UL1061AWG26",60,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","K","UL1061AWG28",390,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","Pt","UL1061AWG28",390,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","M","UL1061AWG28",850,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","B","UL1061AWG28",850,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","M","UL1061AWG24",350,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","B","UL1061AWG24",350,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","Ht","UL1061AWG24",350,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","K","UL1061AWG24",350,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","Pt","UL1061AWG24",350,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","M","UL1061AWG24",350,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","B","UL1061AWG24",350,2.5,3]
[null,6,"MK4EC59290 (B) C01","Ht","UL1061AWG24",350,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","K","UL1061AWG24",350,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","Pt","UL1061AWG24",350,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","M","UL1061AWG24",350,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","B","UL1061AWG24",350,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","Ht","UL1061AWG26",810,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","K","UL1061AWG26",810,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","Pt","UL1061AWG26",810,2.5,3]
[null,6,"MK4EC59290 (B) C01","M","UL1061AWG26",810,2.5,2.5]
[null,6,"MK4EC59290 (B) C01","K","UL1061AWG26",810,2.5,3]
[null,6,"MK4EC59290 (B) C01","Ht","UL1061AWG24",380,2.5,3]
[null,6,"MK4EC59290 (B) C01","K","UL1061AWG24",380,2.5,3]
[null,6,"MK4EC59290 (B) C01","Pt","UL1061AWG24",380,2.5,3]
[null,6,"MK4EC59290 (B) C01","M","UL1061AWG24",380,2.5,3]
[null,6,"MK4EC59290 (B) C01","B","UL1061AWG24",250,3.5,3]
[null,6,"MK4EC59290 (B) C01","Ht","UL1061AWG24",250,3.5,2.5]
[null,6,"MK4EC59290 (B) C01","B","UL1061AWG24",380,3.5,3]
[null,6,"MK4EC59290 (B) C01","Ht","UL1061AWG24",380,3.5,2.5]

{"sheet":"Input","index":1,"n_rows":9,"n_cols":35,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Model","2020-04-01","2020-04-02","2020-04-03","2020-04-04","2020-04-05","2020-04-06","2020-04-07","2020-04-08","2020-04-09","2020-04-10","2020-04-11","2020-04-12","2020-04-13","2020-04-14","2020-04-15","2020-04-16","2020-04-17","2020-04-18","2020-04-19","2020-04-20","2020-04-21","2020-04-22","2020-04-23","2020-04-24","2020-04-25","2020-04-26","2020-04-27","2020-04-28","2020-04-29","2020-04-30","2020-05-01","JUMLAH"]
[null,1,"MK3EC60171 (J) C01",100,80,40,50,80,90,150,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D3:J3)","v":590}]
[null,2,"MK4E50959 (E) C01",50,50,50,50,50,50,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D4:J4)","v":350}]
[null,3,"MK4E50960 (E) C01",50,50,50,50,50,50,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350]
[null,4,"MK4EC63808 (A) C01",20,20,20,20,20,20,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140]
[null,5,"MK4EC59289 (D) C02",50,50,50,50,50,50,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350]
[null,6,"MK4EC59290 (B) C01",100,100,100,100,100,100,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700]
[null,null,"JUMLAH",{"$f":"SUM(D3:D8)","v":370},350,310,320,350,360,420]

{"sheet":"Plan (keinginan)","index":2,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Warna","Kabel","Panjang","Stip A","Stip B","Model","2020-04-01","2020-04-02","2020-04-03","2020-04-04","2020-04-05","2020-04-06"]
[null,null,"Ht","UL1571AWG30",873,2.5,3,"MK3EC60171 (J) C00",100,80,40,80,90,150]
[null,null,"Ht","UL1571AWG30",873,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"Ht","UL1571AWG30",873,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"C","UL1571AWG30",828,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"C","UL1571AWG30",828,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"C","UL1571AWG30",828,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"Ht","UL1571AWG30",703,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"U","UL1571AWG30",703,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"M","UL1571AWG30",758,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"O","UL1571AWG30",758,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"B","UL1571AWG30",123,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"U","UL1571AWG30",778,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"Ht","UL1571AWG30",728,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"K","UL1571AWG30",498,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"K","UL1571AWG30",498,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"K","UL1571AWG30",498,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"HJ","UL1571AWG30",543,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"HJ","UL1571AWG30",543,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"HJ","UL1571AWG30",543,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"Ht","UL1571AWG30",513,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"U","UL1571AWG30",513,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"Pt","UL1571AWG30",538,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"A","UL1571AWG30",538,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"Pt","UL1571AWG30",538,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"K","UL1571AWG30",538,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"Pt","UL1571AWG30",538,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"HJ","UL1571AWG30",538,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"Pt","UL1571AWG30",558,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"A","UL1571AWG30",558,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"Pt","UL1571AWG30",558,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"K","UL1571AWG30",558,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"M","UL1571AWG30",608,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"B","UL1571AWG30",608,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"Pt","UL1571AWG30",608,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"B","UL1571AWG30",608,2.5,3,"MK3EC60171 (J) C01",100,80,40,80,90,150]
[null,null,"O","AWG24",80,2,2.5,"MK4E50959 (E) C01",50,20,30,100,50,100]
[null,null,"HJ","AWG24",80,2,2.5,"MK4E50959 (E) C01",50,20,30,100,50,100]
[null,null,"U","AWG24",75,2,2.5,"MK4E50959 (E) C01",50,20,30,100,50,100]
[null,null,"A","AWG24",75,2,2.5,"MK4E50959 (E) C01",50,20,30,100,50,100]
[null,null,"Pt","AWG24",75,2,2.5,"MK4E50959 (E) C01",50,20,30,100,50,100]
[null,null,"O","AWG24",75,2,2.5,"MK4E50959 (E) C01",50,20,30,100,50,100]
[null,null,"HJ","AWG24",75,2,2.5,"MK4E50959 (E) C01",50,20,30,100,50,100]
[null,null,"U","AWG24",75,2,2.5,"MK4E50959 (E) C01",50,20,30,100,50,100]
[null,null,"Dan Seterusnya…......."]

{"sheet":"Plan","index":3,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Warna","Kabel","Panjang","Stip A","Stip B","No.Harness","2020-04-01","2020-04-02","2020-04-03","2020-04-04","2020-04-05","2020-04-06"]
[null,1,"Ht","UL1571AWG30",873,2.5,3.5,"MK4E50959 (E) C01",100]
[null,2,"Ht","UL1571AWG30",873,2.5,3.5,"MK4E50959 (E) C01",100]
[null,3,"Ht","UL1571AWG30",873,2.5,3.5,"MK4E50959 (E) C01",100]
[null,4,"C","UL1571AWG30",828,2.5,3.5,"MK4E50959 (E) C01",100]
[null,5,"C","UL1571AWG30",828,2.5,3.5,"MK4E50959 (E) C01",100]
[null,6,"C","UL1571AWG30",828,2.5,3.5,"MK4E50959 (E) C01",100]
[null,7,"Ht","UL1571AWG30",703,2.5,3.5,"MK4E50959 (E) C01",100]
[null,8,"U","UL1571AWG30",703,2.5,3.5,"MK4E50959 (E) C01",100]
[null,9,"M","UL1571AWG30",758,2.5,3.5,"MK4E50959 (E) C01",100]
[null,10,"O","UL1571AWG30",758,3,3.5,"MK4E50959 (E) C01",100]
[null,11,"B","UL1571AWG30",123,3,3.5,"MK4E50959 (E) C01",100]
[null,12,"U","UL1571AWG30",778,2.5,3.5,"MK4E50959 (E) C01",100]
[null,13,"Ht","UL1571AWG30",728,2.5,3.5,"MK4E50959 (E) C01",100]
[null,14,"K","UL1571AWG30",498,2.5,3.5,"MK4E50959 (E) C01",100]
[null,15,"K","UL1571AWG30",498,3,3.5,"MK4E50959 (E) C01",100]
[null,16,"K","UL1571AWG30",498,2.5,2.5,"MK4E50959 (E) C01",100]
[null,17,"HJ","UL1571AWG30",543,2.5,3.5,"MK4E50959 (E) C01",100]
[null,18,"HJ","UL1571AWG30",543,2.5,3.5,"MK4E50959 (E) C01",100]
[null,19,"HJ","UL1571AWG30",543,2.5,3.5,"MK4E50959 (E) C01",100]
[null,20,"Ht","UL1571AWG30",513,2.5,3.5,"MK4E50959 (E) C01",100]
[null,21,"U","UL1571AWG30",513,2.5,3.5,"MK4E50959 (E) C01",100]
[null,22,"Pt","UL1571AWG30",538,3,3.5,"MK4E50959 (E) C01",100]
[null,23,"A","UL1571AWG30",538,3,3.5,"MK4E50959 (E) C01",100]
[null,24,"Pt","UL1571AWG30",538,3,3.5,"MK4E50959 (E) C01",100]
[null,25,"K","UL1571AWG30",538,3,3.5,"MK4E50959 (E) C01",100]
[null,26,"Pt","UL1571AWG30",538,3,3.5,"MK4E50959 (E) C01",100]
[null,27,"HJ","UL1571AWG30",538,3,3.5,"MK4E50959 (E) C01",100]
[null,28,"Pt","UL1571AWG30",558,3,3.5,"MK4E50959 (E) C01",100]
[null,29,"A","UL1571AWG30",558,2.5,3.5,"MK4E50959 (E) C01",100]
[null,30,"Pt","UL1571AWG30",558,2.5,3.5,"MK4E50959 (E) C01",100]
[null,31,"K","UL1571AWG30",558,2.5,3.5,"MK4E50959 (E) C01",100]
[null,32,"M","UL1571AWG30",608,2.5,3.5,"MK4E50959 (E) C01",100]
[null,33,"B","UL1571AWG30",608,2.5,3.5,"MK4E50959 (E) C01",100]
[null,34,"Pt","UL1571AWG30",608,2.5,3.5,"MK4E50959 (E) C01",100]
[null,35,"B","UL1571AWG30",608,2.5,3.5,"MK4E50959 (E) C01",100]