{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["WBS Format"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"WBS Format","index":0,"n_rows":192,"n_cols":10,"rows_kept":192,"cut":false,"hidden":false,"merged":[[0,0,6,5],[0,7,3,9],[4,7,4,9],[5,7,5,9],[6,8,6,9],[0,6,1,6],[2,6,3,6]]}
[null,null,null,null,null,null,"Tabriz Petrochemical Company","Vendor Logo"]
[]
[null,null,null,null,null,null,"310 KTPA HDPE Plant"]
[]
[null,null,null,null,null,null,"DOCUMENT TITLE:","Vendor Name :"]
[null,null,null,null,null,null,null,"XXXXX Co."]
[null,null,null,null,null,null,"Work Breakdown Structure","PO. No.:","XXXXXX"]
[]
["Project","Level No.","Phase","Sub-phase","Work Package","Activity ID","Activity Title","WBS Category","Weight in Overall","Relative Weight in Levels"]
[0,null,null,null,"Project Name",null,null,null,{"$f":"SUMIFS(I11:I192,$F11:$F192,\"<>\")","v":0.68750000000000044}]
[null,1,"Project Management and Control",null,null,null,null,"PHASE",{"$f":"SUMIFS(I12:I27,$F12:$F27,\"<>\")","v":6.0000000000000001E-3}]
[null,2,1.1000000000000001,"Milestones",null,null,null,"MLS",{"$f":"SUMIFS(I13:I19,$F13:$F19,\"<>\")","v":0}]
[null,3,"1.1.1",null,"Key Milestones",null,null,"MLS",{"$f":"SUMIFS(I14:I19,$F14:$F19,\"<>\")","v":0},{"$f":"SUMIFS(J14:J19,$F14:$F19,\"<>\")","v":0}]
[null,4,null,null,null,"GN.MLS.0001","PO Sign Date","MLS",0,{"$f":"IF($I$13>0,I14/$I$13,0)","v":0}]
[null,4,null,null,null,"GN.MLS.0002","Kick-off Meeting","MLS",0,{"$f":"IF($I$13>0,I15/$I$13,0)","v":0}]
[null,4,null,null,null,"GN.MLS.0003","Receiving Advanced Payment","MLS",0,0]
[null,4,null,null,null,"GN.MLS.0004","Project Start","MLS",0,0]
[null,4,null,null,null,"GN.MLS.0005","PIM","MLS",0,0]
[null,4,null,null,null,"GN.MLS.0006","Project Finish","MLS",0,0]
[null,2,1.2,"General and Control Documents",null,null,null,"Doc Type",{"$f":"SUMIFS(I21:I27,$F21:$F27,\"<>\")","v":6.0000000000000001E-3}]
[null,3,"1.2.1",null,"General Documents",null,null,"Doc Type",{"$f":"SUMIFS(I22:I27,$F22:$F27,\"<>\")","v":6.0000000000000001E-3},{"$f":"SUMIFS(J22:J27,$F22:$F27,\"<>\")","v":1}]
[null,4,null,null,null,"GN.WBS.0011","WBS ","Activity",1E-3,{"$f":"IF($I$21>0,I22/$I$21,0)","v":0.16666666666666666}]
[null,4,null,null,null,"GN.SCH.0011","Detail Time Schedule ","Activity",2E-3,0.33333333333333331]
[null,4,null,null,null,"GN.LST.0021","Final Book Index ","Activity",1E-3,0.16666666666666666]
[null,4,null,null,null,"GN.LST.0031","Sub-Vendor List ","Activity",1E-3,{"$f":"IF($I$21>0,I25/$I$21,0)","v":0.16666666666666666}]
[null,4,null,null,null,"GN.LST.0041","Spare Part List ","Activity",5.0000000000000001E-4,{"$f":"IF($I$21>0,I26/$I$21,0)","v":8.3333333333333329E-2}]
[null,4,null,null,null,"GN.PRC.0011","Packing, Marking And Shipping Procedure ","Activity",5.0000000000000001E-4,{"$f":"IF($I$21>0,I27/$I$21,0)","v":8.3333333333333329E-2}]
[null,1,"Engineering",null,null,null,null,"PHASE",{"$f":"SUMIFS(I29:I64,$F29:$F64,\"<>\")","v":6.000000000000001E-3}]
[null,2,2.1,"Engineering Common Docs (Related to All Tags)",null,null,null,"Priority",{"$f":"SUMIFS(I30:I37,$F30:$F37,\"<>\")","v":6.000000000000001E-3}]
[null,3,"2.1.2",null,"Common Documents ( Such as Procedures, Specifications, Reports, WQR, WPS, PQR …)",null,null,"Doc Type",{"$f":"SUMIFS(I31:I37,$F31:$F37,\"<>\")","v":6.000000000000001E-3},{"$f":"SUMIFS(J31:J37,$F31:$F37,\"<>\")","v":0.99999999999999967}]
[null,4,null,null,null,"EN.LST.0111","VPIS ","Activity",1E-3,{"$f":"IF($I$30>0,I31/$I$30,0)","v":0.16666666666666663}]
[null,4,null,null,null,"EN.PRC.0111","Fabrication Procedures ","Activity",1E-3,0.16666666666666663]
[null,4,null,null,null,"EN.PRC.0121","Quality Control Procedure ","Activity",1E-3,0.16666666666666663]
[null,4,null,null,null,"EN.PRC.0131","Inspection and Test Plan ","Activity",1E-3,0.16666666666666663]
[null,4,null,null,null,"EN.PRC.0141","N.D.E Procedure ","Activity",5.0000000000000001E-4,8.3333333333333315E-2]
[null,4,null,null,null,"EN.SPC.0011","Welding Procedure Specification Related to All Tags ","Activity",5.0000000000000001E-4,8.3333333333333315E-2]
[null,4,null,null,null,"EN.WQR.0021","Welder Qualification Records (WQR) ","Activity",1E-3,0.16666666666666663]
[null,2,2.2000000000000002,"Priority I  (Documents Related to Tag XXX, Tag Z)",null,null,null,"Priority",{"$f":"SUMIFS(I39:I47,$F39:$F47,\"<>\")","v":0}]
[null,3,"2.2.1",null,"Data Sheets",null,null,"Doc Type",{"$f":"SUMIFS(I40:I41,$F40:$F41,\"<>\")","v":0},{"$f":"SUMIFS(J40:J41,$F40:$F41,\"<>\")","v":0}]
[null,4,null,null,null,"EN.DSH.1011","Data Sheet for Tag XXX ","Activity",null,{"$f":"IF($I$39>0,I40/$I$39,0)","v":0}]
[null,4,null,null,null,"EN.DSH.1021","Data Sheet for Tag Z ","Activity",null,{"$f":"IF($I$39>0,I41/$I$39,0)","v":0}]
[null,3,"2.2.2",null,"Calculations",null,null,"Doc Type",{"$f":"SUMIFS(I43:I44,$F43:$F44,\"<>\")","v":0},{"$f":"SUMIFS(J43:J44,$F43:$F44,\"<>\")","v":0}]
[null,4,null,null,null,"EN.CAL.1011","Calculation sheet for Tag XXX ","Activity",null,{"$f":"IF($I$42>0,I43/$I$42,0)","v":0}]
[null,4,null,null,null,"EN.CAL.1021","Calculation sheet for Tag Z ","Activity",null,{"$f":"IF($I$42>0,I44/$I$42,0)","v":0}]
[null,3,"2.2.3",null,"Drawings",null,null,"Doc Type",{"$f":"SUMIFS(I46:I47,$F46:$F47,\"<>\")","v":0},{"$f":"SUMIFS(J46:J47,$F46:$F47,\"<>\")","v":0}]
[null,4,null,null,null,"EN.DWG.1011","General Arrangement for Tag XXX ","Activity",null,{"$f":"IF($I$45>0,I46/$I$45,0)","v":0}]
[null,4,null,null,null,"EN.DWG.1021","General Arrangement for Tag Z ","Activity",null,{"$f":"IF($I$45>0,I47/$I$45,0)","v":0}]
[null,2,2.2999999999999998,"Priority II (Documents Related to Tag WWW, Tag YYY)",null,null,null,"Priority",{"$f":"SUMIFS(I49:I57,$F49:$F57,\"<>\")","v":0}]
[null,3,"2.3.1",null,"Data Sheets",null,null,"Doc Type",{"$f":"SUMIFS(I50:I51,$F50:$F51,\"<>\")","v":0},{"$f":"SUMIFS(J50:J51,$F50:$F51,\"<>\")","v":0}]
[null,4,null,null,null,"EN.DSH.2011","Data Sheet for Tag WWW ","Activity",null,{"$f":"IF($I$49>0,I50/$I$49,0)","v":0}]
[null,4,null,null,null,"EN.DSH.2021","Data Sheet for Tag YYY ","Activity",null,{"$f":"IF($I$49>0,I51/$I$49,0)","v":0}]
[null,3,"2.3.2",null,"Calculations",null,null,"Doc Type",{"$f":"SUMIFS(I53:I54,$F53:$F54,\"<>\")","v":0},{"$f":"SUMIFS(J53:J54,$F53:$F54,\"<>\")","v":0}]
[null,4,null,null,null,"EN.CAL.2011","Calculation sheet for Tag WWW ","Activity",null,{"$f":"IF($I$52>0,I53/$I$52,0)","v":0}]
[null,4,null,null,null,"EN.CAL.2021","Calculation sheet for Tag YYY ","Activity",null,{"$f":"IF($I$52>0,I54/$I$52,0)","v":0}]
[null,3,"2.3.3",null,"Drawings",null,null,"Doc Type",{"$f":"SUMIFS(I56:I57,$F56:$F57,\"<>\")","v":0},{"$f":"SUMIFS(J56:J57,$F56:$F57,\"<>\")","v":0}]
[null,4,null,null,null,"EN.DWG.2011","General Arrangement for Tag WWW","Activity",null,{"$f":"IF($I$55>0,I56/$I$55,0)","v":0}]
[null,4,null,null,null,"EN.DWG.2021","General Arrangement for Tag YYY ","Activity",null,{"$f":"IF($I$55>0,I57/$I$55,0)","v":0}]
[null,2,2.4,"Priority III (Documents Related to Tag PPP, Tag GGG, Tag SSS)",null,null,null,"Priority",{"$f":"SUMIFS(I59:I64,$F59:$F64,\"<>\")","v":0}]
[null,3,"2.4.1",null,"Data Sheets",null,null,"Doc Type",{"$f":"SUMIFS(I60:I60,$F60:$F60,\"<>\")","v":0},{"$f":"SUMIFS(J60:J60,$F60:$F60,\"<>\")","v":0}]
[null,4,null,null,null,"EN.DSH.3011","Data Sheet for Tag GGG ","Activity",null,{"$f":"IF($I$59>0,I60/$I$59,0)","v":0}]
[null,3,"2.4.2",null,"Calculations",null,null,"Doc Type",{"$f":"SUMIFS(I62:I62,$F62:$F62,\"<>\")","v":0},{"$f":"SUMIFS(J62:J62,$F62:$F62,\"<>\")","v":0}]
[null,4,null,null,null,"EN.SCH.3011","Calculation sheet for Tag GGG ","Activity",null,{"$f":"IF($I$61>0,I62/$I$61,0)","v":0}]
[null,3,"2.4.3",null,"Drawings",null,null,"Doc Type",{"$f":"SUMIFS(I64:I64,$F64:$F64,\"<>\")","v":0},{"$f":"SUMIFS(J64:J64,$F64:$F64,\"<>\")","v":0}]
[null,4,null,null,null,"EN.DWG.3011","General Arrangement for Tag GGG ","Activity",null,{"$f":"IF($I$63>0,I64/$I$63,0)","v":0}]
[null,1,"Procurement and Supply of Materials (Based on Sub-vendor List)",null,null,null,null,"PHASE",{"$f":"SUMIFS(I66:I80,$F66:$F80,\"<>\")","v":0.1055}]
[null,2,3.1,"P.O #01",null,null,null,"P.O",{"$f":"SUMIFS(I67:I70,$F67:$F70,\"<>\")","v":5.2499999999999991E-2}]
[null,3,"3.1.1",null,"(e.g. Raw Material)",null,null,"Material Name",{"$f":"SUMIFS(I68:I70,$F68:$F70,\"<>\")","v":5.2499999999999991E-2},{"$f":"SUMIFS(J68:J70,$F68:$F70,\"<>\")","v":1}]
[null,4,null,null,null,"PC.PO1.1011","Purchase Order Placement","Activity",1.4999999999999998E-2,{"$f":"IF($I$67>0,I68/$I$67,0)","v":0.2857142857142857}]
[null,4,null,null,null,"PC.PO1.1012","Raw Material Supply/Fabrication","Activity",7.4999999999999989E-3,{"$f":"IF($I$67>0,I69/$I$67,0)","v":0.14285714285714285}]
[null,4,null,null,null,"PC.PO1.1013","Delivery At Vendor Shop","Activity",2.9999999999999995E-2,0.5714285714285714]
[null,2,3.2,"P.O #02",null,null,null,"P.O",{"$f":"SUMIFS(I72:I75,$F72:$F75,\"<>\")","v":2.5000000000000005E-2}]
[null,3,"3.2.1",null,"(e.g. Driver)",null,null,"Material Name",{"$f":"SUMIFS(I73:I75,$F73:$F75,\"<>\")","v":2.5000000000000005E-2},{"$f":"SUMIFS(J73:J75,$F73:$F75,\"<>\")","v":1}]
[null,4,null,null,null,"PC.PO2.2011","Purchase Order Placement","Activity",1.0000000000000002E-2,{"$f":"IF($I$72>0,I73/$I$72,0)","v":0.4}]
[null,4,null,null,null,"PC.PO2.2012","Raw Material Supply/Fabrication","Activity",5.000000000000001E-3,{"$f":"IF($I$72>0,I74/$I$72,0)","v":0.2}]
[null,4,null,null,null,"PC.PO2.2013","Delivery At Vendor Shop","Activity",1.0000000000000002E-2,{"$f":"IF($I$72>0,I75/$I$72,0)","v":0.4}]
[null,2,3.3,"P.O #03",null,null,null,"P.O",{"$f":"SUMIFS(I77:I80,$F77:$F80,\"<>\")","v":2.8000000000000001E-2}]
[null,3,"3.3.1",null,"(e.g. CS & SS Pipe)",null,null,"Material Name",{"$f":"SUMIFS(I78:I80,$F78:$F80,\"<>\")","v":2.8000000000000001E-2},{"$f":"SUMIFS(J78:J80,$F78:$F80,\"<>\")","v":1}]
[null,4,null,null,null,"PC.PO3.3011","Purchase Order Placement","Activity",8.0000000000000002E-3,{"$f":"IF($I$77>0,I78/$I$77,0)","v":0.2857142857142857}]
[null,4,null,null,null,"PC.PO3.3012","Raw Material Supply/Fabrication","Activity",4.0000000000000001E-3,{"$f":"IF($I$77>0,I79/$I$77,0)","v":0.14285714285714285}]
[null,4,null,null,null,"PC.PO3.3013","Delivery At Vendor Shop","Activity",1.6E-2,0.5714285714285714]
[null,1,"Manufacturing",null,null,null,null,"PHASE",{"$f":"SUMIFS(I82:I153,$F82:$F153,\"<>\")","v":0.32000000000000017}]
[null,2,4.0999999999999996,"Priority I  (Documents Related to Tag XXX, Tag Z)",null,null,null,"Priority",{"$f":"SUMIFS(I83:I112,$F83:$F112,\"<>\")","v":0.20000000000000007}]
[null,3,"4.1.1",null,"Tag XXX",null,null,"Tagged Items",{"$f":"SUMIFS(I84:I97,$F84:$F97,\"<>\")","v":0.15000000000000002},{"$f":"SUMIFS(J84:J97,$F84:$F97,\"<>\")","v":0.99999999999999956}]
[null,4,null,null,null,"MF.XXX.1001","Cutting Component I of Tag XXX","Activity",7.4999999999999997E-3,{"$f":"IF($I$83>0,I84/$I$83,0)","v":4.9999999999999989E-2}]
[null,4,null,null,null,"MF.XXX.1002","Welding Component I of Tag XXX","Activity",7.4999999999999997E-3,{"$f":"IF($I$83>0,I85/$I$83,0)","v":4.9999999999999989E-2}]
[null,4,null,null,null,"MF.XXX.1003","forming Component I of Tag XXX","Activity",7.4999999999999997E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.XXX.1004","Course No. Of Component I of Tag XXX","Activity",7.4999999999999997E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.XXX.1005","Cutting Of Component I of Tag XXX","Activity",7.4999999999999997E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.XXX.1006","1st Rolling Of Component I of Tag XXX","Activity",7.4999999999999997E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.XXX.1007","2nd Rolling Of Component I of Tag XXX","Activity",7.4999999999999997E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.XXX.1008","Fabricating Base Plate of Tag XXX","Activity",7.4999999999999997E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.XXX.1009","Hydrostatic test of Tag XXX","Activity",7.4999999999999997E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.XXX.1010","Component Assembly of Tag XXX","Activity",1.4999999999999999E-2,9.9999999999999978E-2]
[null,4,null,null,null,"MF.XXX.1011","Performance Test of Tag XXX","Activity",2.2499999999999999E-2,0.14999999999999997]
[null,4,null,null,null,"MF.XXX.1012","Final Assembly of Tag XXX","Activity",2.2499999999999999E-2,0.14999999999999997]
[null,4,null,null,null,"MF.XXX.1013","Running Test of Tag XXX","Activity",1.4999999999999999E-2,9.9999999999999978E-2]
[null,4,null,null,null,"MF.XXX.1014","Painting of Tag XXX","Activity",7.4999999999999997E-3,4.9999999999999989E-2]
[null,3,"4.1.2",null,"Tag ZZZ",null,null,"Tagged Items",{"$f":"SUMIFS(I99:I113,$F99:$F113,\"<>\")","v":0.05},{"$f":"SUMIFS(J99:J113,$F99:$F113,\"<>\")","v":1}]
[null,4,null,null,null,"MF.ZZZ.1001","Cutting Component I of Tag Z","Activity",2.5000000000000005E-3,{"$f":"IF($I$98>0,I99/$I$98,0)","v":5.000000000000001E-2}]
[null,4,null,null,null,"MF.ZZZ.1002","Welding Component I of Tag Z","Activity",2.5000000000000005E-3,{"$f":"IF($I$98>0,I100/$I$98,0)","v":5.000000000000001E-2}]
[null,4,null,null,null,"MF.ZZZ.1003","forming Component I of Tag Z","Activity",2.5000000000000005E-3,5.000000000000001E-2]
[null,4,null,null,null,"MF.ZZZ.1004","Course No. Of Component I of Tag Z","Activity",2.5000000000000005E-3,5.000000000000001E-2]
[null,4,null,null,null,"MF.ZZZ.1005","Cutting Of Component I of Tag Z","Activity",2.5000000000000005E-3,5.000000000000001E-2]
[null,4,null,null,null,"MF.ZZZ.1006","1st Rolling Of Component I of Tag Z","Activity",2.5000000000000005E-3,5.000000000000001E-2]
[null,4,null,null,null,"MF.ZZZ.1007","2nd Rolling Of Component I of Tag Z","Activity",2.5000000000000005E-3,5.000000000000001E-2]
[null,4,null,null,null,"MF.ZZZ.1008","Fabricating Base Plate of Tag Z","Activity",2.5000000000000005E-3,5.000000000000001E-2]
[null,4,null,null,null,"MF.ZZZ.1009","Hydrostatic test of Tag Z","Activity",2.5000000000000005E-3,5.000000000000001E-2]
[null,4,null,null,null,"MF.ZZZ.1010","Component Assembly of Tag Z","Activity",5.000000000000001E-3,0.10000000000000002]
[null,4,null,null,null,"MF.ZZZ.1011","Performance Test of Tag Z","Activity",7.4999999999999997E-3,0.15]
[null,4,null,null,null,"MF.ZZZ.1012","Final Assembly of Tag Z","Activity",7.4999999999999997E-3,0.15]
[null,4,null,null,null,"MF.ZZZ.1013","Running Test of Tag Z","Activity",5.000000000000001E-3,0.10000000000000002]
[null,4,null,null,null,"MF.ZZZ.1014","Painting of Tag Z","Activity",2.5000000000000005E-3,5.000000000000001E-2]
[null,2,4.2,"Priority II  (Documents Related to Tag WWW, Tag YYY)",null,null,null,"Priority",{"$f":"SUMIFS(I114:I143,$F114:$F143,\"<>\")","v":0.12000000000000005}]
[null,3,"4.2.1",null,"Tag WWW",null,null,"Tagged Items",{"$f":"SUMIFS(I115:I128,$F115:$F128,\"<>\")","v":4.0000000000000008E-2},{"$f":"SUMIFS(J115:J128,$F115:$F128,\"<>\")","v":0.99999999999999956}]
[null,4,null,null,null,"MF.WWW.1001","Cutting Component I of Tag WWW","Activity",2E-3,{"$f":"IF($I$114>0,I115/$I$114,0)","v":4.9999999999999989E-2}]
[null,4,null,null,null,"MF.WWW.1002","Welding Component I of Tag WWW","Activity",2E-3,{"$f":"IF($I$114>0,I116/$I$114,0)","v":4.9999999999999989E-2}]
[null,4,null,null,null,"MF.WWW.1003","forming Component I of Tag WWW","Activity",2E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.WWW.1004","Course No. Of Component I of Tag WWW","Activity",2E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.WWW.1005","Cutting Of Component I of Tag WWW","Activity",2E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.WWW.1006","1st Rolling Of Component I of Tag WWW","Activity",2E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.WWW.1007","2nd Rolling Of Component I of Tag WWW","Activity",2E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.WWW.1008","Fabricating Base Plate of Tag WWW","Activity",2E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.WWW.1009","Hydrostatic test of Tag WWW","Activity",2E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.WWW.1010","Component Assembly of Tag WWW","Activity",4.0000000000000001E-3,9.9999999999999978E-2]
[null,4,null,null,null,"MF.WWW.1011","Performance Test of Tag WWW","Activity",6.0000000000000001E-3,0.14999999999999997]
[null,4,null,null,null,"MF.WWW.1012","Final Assembly of Tag WWW","Activity",6.0000000000000001E-3,0.14999999999999997]
[null,4,null,null,null,"MF.WWW.1013","Running Test of Tag WWW","Activity",4.0000000000000001E-3,9.9999999999999978E-2]
[null,4,null,null,null,"MF.WWW.1014","Painting of Tag WWW","Activity",2E-3,4.9999999999999989E-2]
[null,3,"4.2.2",null,"Tag YYY",null,null,"Tagged Items",{"$f":"SUMIFS(I130:I144,$F130:$F144,\"<>\")","v":8.0000000000000016E-2},{"$f":"SUMIFS(J130:J144,$F130:$F144,\"<>\")","v":0.99999999999999956}]
[null,4,null,null,null,"MF.YYY.1001","Cutting Component I of Tag YYY","Activity",4.0000000000000001E-3,{"$f":"IF($I$129>0,I130/$I$129,0)","v":4.9999999999999989E-2}]
[null,4,null,null,null,"MF.YYY.1002","Welding Component I of Tag YYY","Activity",4.0000000000000001E-3,{"$f":"IF($I$129>0,I131/$I$129,0)","v":4.9999999999999989E-2}]
[null,4,null,null,null,"MF.YYY.1003","forming Component I of Tag YYY","Activity",4.0000000000000001E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.YYY.1004","Course No. Of Component I of Tag YYY","Activity",4.0000000000000001E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.YYY.1005","Cutting Of Component I of Tag YYY","Activity",4.0000000000000001E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.YYY.1006","1st Rolling Of Component I of Tag YYY","Activity",4.0000000000000001E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.YYY.1007","2nd Rolling Of Component I of Tag YYY","Activity",4.0000000000000001E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.YYY.1008","Fabricating Base Plate of Tag YYY","Activity",4.0000000000000001E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.YYY.1009","Hydrostatic test of Tag YYY","Activity",4.0000000000000001E-3,4.9999999999999989E-2]
[null,4,null,null,null,"MF.YYY.1010","Component Assembly of Tag YYY","Activity",8.0000000000000002E-3,9.9999999999999978E-2]
[null,4,null,null,null,"MF.YYY.1011","Performance Test of Tag YYY","Activity",1.2E-2,0.14999999999999997]
[null,4,null,null,null,"MF.YYY.1012","Final Assembly of Tag YYY","Activity",1.2E-2,0.14999999999999997]
[null,4,null,null,null,"MF.YYY.1013","Running Test of Tag YYY","Activity",8.0000000000000002E-3,9.9999999999999978E-2]
[null,4,null,null,null,"MF.YYY.1014","Painting of Tag YYY","Activity",4.0000000000000001E-3,4.9999999999999989E-2]
[null,2,4.3,"Priority III (Documents Related to Tag PPP, Tag GGG, Tag SSS)",null,null,null,"Priority",{"$f":"SUMIFS(I145:I153,$F145:$F153,\"<>\")","v":0}]
[null,3,"4.3.1",null,"Tag PPP",null,null,"Tagged Items",{"$f":"SUMIFS(I146:I147,$F146:$F147,\"<>\")","v":0},{"$f":"SUMIFS(J146:J147,$F146:$F147,\"<>\")","v":0}]
[null,4,null,null,null,null,null,"Activity",null,{"$f":"IF($I$145>0,I146/$I$145,0)","v":0}]
[null,4,null,null,null,null,null,"Activity",null,{"$f":"IF($I$145>0,I147/$I$145,0)","v":0}]
[null,3,"4.3.2",null,"Tag GGG",null,null,"Tagged Items",{"$f":"SUMIFS(I149:I150,$F149:$F150,\"<>\")","v":0},{"$f":"SUMIFS(J149:J150,$F149:$F150,\"<>\")","v":0}]
[null,4,null,null,null,null,null,"Activity",null,{"$f":"IF($I$148>0,I149/$I$148,0)","v":0}]
[null,4,null,null,null,null,null,"Activity",null,{"$f":"IF($I$148>0,I150/$I$148,0)","v":0}]
[null,3,"4.3.3",null,"Tag SSS",null,null,"Tagged Items",{"$f":"SUMIFS(I152:I153,$F152:$F153,\"<>\")","v":0},{"$f":"SUMIFS(J152:J153,$F152:$F153,\"<>\")","v":0}]
[null,4,null,null,null,null,null,"Activity",null,{"$f":"IF($I$151>0,I152/$I$151,0)","v":0}]
[null,4,null,null,null,null,null,"Activity",null,{"$f":"IF($I$151>0,I153/$I$151,0)","v":0}]
[null,1,"Final Inspection and Test",null,null,null,null,"PHASE",{"$f":"SUMIFS(I155:I172,$F155:$F172,\"<>\")","v":0.10000000000000002}]
[null,2,5.0999999999999996,"Priority I  (Documents Related to Tag XXX, Tag Z)",null,null,null,"Priority",{"$f":"SUMIFS(I156:I161,$F156:$F161,\"<>\")","v":6.0000000000000005E-2}]
[null,3,"5.1.1",null,"Tag XXX / Part 1",null,null,"Component",{"$f":"SUMIFS(I157:I158,$F157:$F158,\"<>\")","v":0.04},{"$f":"SUMIFS(J157:J158,$F157:$F158,\"<>\")","v":1}]
[null,4,null,null,null,"MF.PR1.INS.1011","Final Inspection & Test of Tag XXX / Part 1","Activity",0.02,{"$f":"IF($I$156>0,I157/$I$156,0)","v":0.5}]
[null,4,null,null,null,"MF.PR1.PKG.1011","Packing of Tag XXX / Part 1","Activity",0.02,{"$f":"IF($I$156>0,I158/$I$156,0)","v":0.5}]
[null,3,"5.1.2",null,"Tag ZZZ / Part 2",null,null,"Component",{"$f":"SUMIFS(I160:I161,$F160:$F161,\"<>\")","v":0.02},{"$f":"SUMIFS(J160:J161,$F160:$F161,\"<>\")","v":1}]
[null,4,null,null,null,"MF.PR2.INS.2011","Final Inspection & Test of Tag ZZZ / Part 2","Activity",0.01,{"$f":"IF($I$159>0,I160/$I$159,0)","v":0.5}]
[null,4,null,null,null,"MF.PR2.PKG.2012","Packing of Tag ZZZ / Part2","Activity",0.01,{"$f":"IF($I$159>0,I161/$I$159,0)","v":0.5}]
[null,2,5.2,"Priority II (Documents Related to Tag WWW, Tag YYY)",null,null,null,"Priority",{"$f":"SUMIFS(I163:I168,$F163:$F168,\"<>\")","v":3.0000000000000002E-2}]
[null,3,"5.2.1",null,"Tag WWW / Part 3",null,null,"Component",{"$f":"SUMIFS(I164:I165,$F164:$F165,\"<>\")","v":0.02},{"$f":"SUMIFS(J164:J165,$F164:$F165,\"<>\")","v":1}]
[null,4,null,null,null,"MF.PR3.INS.3011","Final Inspection & Test of Tag WWW / Part 3","Activity",0.01,{"$f":"IF($I$163>0,I164/$I$163,0)","v":0.5}]
[null,4,null,null,null,"MF.PR3.PKG.3012","Packing of Tag WWW / Part 3","Activity",0.01,{"$f":"IF($I$163>0,I165/$I$163,0)","v":0.5}]
[null,3,"5.2.2",null,"Tag YYY / Part 4",null,null,"Component",{"$f":"SUMIFS(I167:I168,$F167:$F168,\"<>\")","v":0.01},{"$f":"SUMIFS(J167:J168,$F167:$F168,\"<>\")","v":1}]
[null,4,null,null,null,"MF.PR4.INS.4011","Final Inspection & Test of Tag YYY / Part 4","Activity",5.0000000000000001E-3,{"$f":"IF($I$166>0,I167/$I$166,0)","v":0.5}]
[null,4,null,null,null,"MF.PR4.PKG.4012","Packing of Tag YYY / Part 4","Activity",5.0000000000000001E-3,{"$f":"IF($I$166>0,I168/$I$166,0)","v":0.5}]
[null,2,5.3,"Priority III (Documents Related to Tag PPP, Tag GGG, Tag SSS)",null,null,null,"Priority",{"$f":"SUMIFS(I170:I172,$F170:$F172,\"<>\")","v":0.01}]
[null,3,"5.3.1",null,"Tag PPP , G, S / Part 5",null,null,"Component",{"$f":"SUMIFS(I171:I172,$F171:$F172,\"<>\")","v":0.01},{"$f":"SUMIFS(J171:J172,$F171:$F172,\"<>\")","v":1}]
[null,4,null,null,null,"MF.PR5.INS.5011","Final Inspection & Test of Tag PPP, G, S / Part 5","Activity",5.0000000000000001E-3,{"$f":"IF($I$170>0,I171/$I$170,0)","v":0.5}]
[null,4,null,null,null,"MF.PR5.PKG.5012","Packing of Tag PPP, G, S / Part 5","Activity",5.0000000000000001E-3,{"$f":"IF($I$170>0,I172/$I$170,0)","v":0.5}]
[null,1,"Ex-Work/ FOB/ CFR/ Transportation and Delivery at Site",null,null,null,null,"PHASE",{"$f":"SUMIFS(I174:I186,$F174:$F186,\"<>\")","v":0.1}]
[null,2,6.1,"Priority I  (Documents Related to Tag XXX, Tag Z)",null,null,null,"Priority",{"$f":"SUMIFS(I175:I178,$F175:$F178,\"<>\")","v":0.05}]
[null,3,"6.1.1",null,"Tag XXX / Part 1",null,null,"Component",{"$f":"SUMIFS(I176:I176,$F176:$F176,\"<>\")","v":0.03},{"$f":"SUMIFS(J176:J176,$F176:$F176,\"<>\")","v":1}]
[null,4,null,null,null,"MF.PR1.DLV.1011","Delivery at Site of Tag XXX / Part 1","Activity",0.03,{"$f":"IF($I$175>0,I176/$I$175,0)","v":1}]
[null,3,"6.1.2",null,"Tag ZZZ / Part 2",null,null,"Component",{"$f":"SUMIFS(I178:I178,$F178:$F178,\"<>\")","v":0.02},{"$f":"SUMIFS(J178:J178,$F178:$F178,\"<>\")","v":1}]
[null,4,null,null,null,"MF.PR2.DLV.2011","Delivery at Site  of Tag ZZZ / Part 2","Activity",0.02,{"$f":"IF($I$177>0,I178/$I$177,0)","v":1}]
[null,2,6.2,"Priority II (Documents Related to Tag WWW, Tag YYY)",null,null,null,"Priority",{"$f":"SUMIFS(I180:I183,$F180:$F183,\"<>\")","v":0.04}]
[null,3,"6.2.1",null,"Tag WWW / Part 3",null,null,"Component",{"$f":"SUMIFS(I181:I181,$F181:$F181,\"<>\")","v":0.02},{"$f":"SUMIFS(J181:J181,$F181:$F181,\"<>\")","v":1}]
[null,4,null,null,null,"MF.PR3.DLV.3011","Delivery at Site of Tag WWW / Part 3","Activity",0.02,{"$f":"IF($I$180>0,I181/$I$180,0)","v":1}]
[null,3,"6.2.2",null,"Tag YYY / Part 4",null,null,"Component",{"$f":"SUMIFS(I183:I183,$F183:$F183,\"<>\")","v":0.02},{"$f":"SUMIFS(J183:J183,$F183:$F183,\"<>\")","v":1}]
[null,4,null,null,null,"MF.PR4.DLV.4011","Delivery at Site of Tag YYY / Part 4","Activity",0.02,{"$f":"IF($I$182>0,I183/$I$182,0)","v":1}]
[null,2,6.3,"Priority III (Documents Related to Tag PPP, Tag GGG, Tag SSS)",null,null,null,"Priority",{"$f":"SUMIFS(I185:I186,$F185:$F186,\"<>\")","v":0.01}]
[null,3,"6.3.1",null,"Tag PPP , G, S / Part 5",null,null,"Component",{"$f":"SUMIFS(I186:I186,$F186:$F186,\"<>\")","v":0.01},{"$f":"SUMIFS(J186:J186,$F186:$F186,\"<>\")","v":1}]
[null,4,null,null,null,"MF.PR5.DLV.5011","Delivery at Site of Tag  P, G, S / Part 5","Activity",0.01,{"$f":"IF($I$185>0,I186/$I$185,0)","v":1}]
[null,1,"Final Book",null,null,null,null,"PHASE",{"$f":"SUMIFS(I188:I192,$F188:$F192,\"<>\")","v":0.05}]
[null,2,7.1,"MR No.",null,null,null,"Item",{"$f":"SUMIFS(I189:I192,$F189:$F192,\"<>\")","v":0.05}]
[null,3,"7.1.1",null,"Soft Copy of Final Book Package",null,null,"Component",{"$f":"SUMIFS(I190:I190,$F190:$F190,\"<>\")","v":0.03},{"$f":"SUMIFS(J190:J190,$F190:$F190,\"<>\")","v":1}]
[null,4,null,null,null,"FB.5023.SFT.1011","Submission of Soft Copy of Final Documents","Activity",0.03,{"$f":"IF($I$189>0,I190/$I$189,0)","v":1}]
[null,3,"7.1.2",null,"Hard Copy of Final Book Package",null,null,"Component",{"$f":"SUMIFS(I192:I192,$F192:$F192,\"<>\")","v":0.02},{"$f":"SUMIFS(J192:J192,$F192:$F192,\"<>\")","v":1}]
[null,4,null,null,null,"FB.5023.HRD.1011","Submission of Hard Copy of Final Documents","Activity",0.02,{"$f":"IF($I$191>0,I192/$I$191,0)","v":1}]