{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Input","Output","Back_up","Basic_Data","Sample"],"not_rendered":{"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":5,"n_cols":4,"rows_kept":5}
["Material#","Material Description","BASIC DATA\n\n\n\n\n","BASIC DATA\n\n\n\n\n\n"]
[1000010,"(BLCK)KIT:CBL CLMP FTG,F/6MM HX HD","KIT:\nTYPE: CABLE CLAMP FITTING\nAPPLICATION: FOR 6MM HEX HEAD\n\n\n\n\n","KIT:\nTYPE: CABLE CLAMP FITTING\nAPPLICATION: FOR 6MM HEX HEAD\n\n\n\n\n\n"]
[1000012,"COND:20\",166.56 PPF,XLC-SE,MU/L:6.19\",B>","CONDUCTOR:\nOUTSIDE DIAMETER: 20\"\nWEIGHT: 166.56 PPF\nEND CONNECTIONS: XLC-SE, MU/L:6.19\"\nEND CONNECTION TYPE: BOX X PIN\nGRADE: X65\nLENGTH: R3\nSPECIFICATION: API 5L, PSL2\n\n\n\n\n","CONDUCTOR:\nOUTSIDE DIAMETER: 20\"\nWEIGHT: 166.56 PPF\nEND CONNECTIONS: XLC-SE, MU/L:6.19\"\nEND CONNECTION TYPE: BOX X PIN\nGRADE: X65\nLENGTH: R3\nSPECIFICATION: API 5L, PSL2\n\n\n\n\n\n"]
[1000013,"COND:20\",CTD,166.56 PPF,XLC-SE,MU/L:6.1>","CONDUCTOR:\nOUTSIDE DIAMETER: 20\", COATED\nWEIGHT: 166.56 PPF\nEND CONNECTIONS: XLC-SE, MU/L:6.19\"\nGRADE: X-65\nLENGTH: R3\nWALL THICKNESS: 0.812\"\n\n\n\n\n","CONDUCTOR:\nOUTSIDE DIAMETER: 20\", COATED\nWEIGHT: 166.56 PPF\nEND CONNECTIONS: XLC-SE, MU/L:6.19\"\nGRADE: X-65\nLENGTH: R3\nWALL THICKNESS: 0.812\"\n\n\n\n\n\n"]
[1000022,"LNR:PDC DRILLABLE,1.75\",AL","SSD: SLIDING SLEEVE\nTYPE: DURASLEEVE\nSIZE: 4.5\"\nGRADE: L80 13CR\nCONNECTION: SL APEX\n\n\n\n\n","SSD: SLIDING SLEEVE\nTYPE: DURASLEEVE\nSIZE: 4.5\"\nGRADE: L80 13CR\nCONNECTION: SL APEX\n\n\n\n\n\n"]

{"sheet":"Output","index":1,"n_rows":44,"n_cols":3,"rows_kept":44}
["Material#",10,"BASIC DATA\n"]
["Material#",20,"\n"]
["Material#",30,"\n"]
["Material#",40,"\n"]
["Material#",50,"\n"]
[1000010,10,"KIT:\n"]
[1000010,20,"TYPE: CABLE CLAMP FITTING\n"]
[1000010,30,"APPLICATION: FOR 6MM HEX HEAD\n"]
[1000010,40,"\n"]
[1000010,50,"\n"]
[1000010,60,"\n"]
[1000010,70,"\n"]
[1000012,10,"CONDUCTOR:\n"]
[1000012,20,"OUTSIDE DIAMETER: 20\"\n"]
[1000012,30,"WEIGHT: 166.56 PPF\n"]
[1000012,40,"END CONNECTIONS: XLC-SE, MU/L:6.19\"\n"]
[1000012,50,"END CONNECTION TYPE: BOX X PIN\n"]
[1000012,60,"GRADE: X65\n"]
[1000012,70,"LENGTH: R3\n"]
[1000012,80,"SPECIFICATION: API 5L, PSL2\n"]
[1000012,90,"\n"]
[1000012,100,"\n"]
[1000012,110,"\n"]
[1000012,120,"\n"]
[1000013,10,"CONDUCTOR:\n"]
[1000013,20,"OUTSIDE DIAMETER: 20\", COATED\n"]
[1000013,30,"WEIGHT: 166.56 PPF\n"]
[1000013,40,"END CONNECTIONS: XLC-SE, MU/L:6.19\"\n"]
[1000013,50,"GRADE: X-65\n"]
[1000013,60,"LENGTH: R3\n"]
[1000013,70,"WALL THICKNESS: 0.812\"\n"]
[1000013,80,"\n"]
[1000013,90,"\n"]
[1000013,100,"\n"]
[1000013,110,"\n"]
[1000022,10,"SSD: SLIDING SLEEVE\n"]
[1000022,20,"TYPE: DURASLEEVE\n"]
[1000022,30,"SIZE: 4.5\"\n"]
[1000022,40,"GRADE: L80 13CR\n"]
[1000022,50,"CONNECTION: SL APEX\n"]
[1000022,60,"\n"]
[1000022,70,"\n"]
[1000022,80,"\n"]
[1000022,90,"\n"]

{"sheet":"Back_up","index":2,"n_rows":42,"n_cols":7,"rows_kept":42}
["Material#",10,"Basic Data Text","Basic Data Text","Formula 1","Formula 2","Formula 3"]
[1000010,10,"KIT:\n","KIT:\n\n",{"$f":"RIGHT(C2,LEN(C2)-SEARCH(\":\",C2,1))","v":"\n"},{"$f":"TRIM(E2)","v":"\n"},{"$f":"A2&\"/\"&B2","v":"1000010/10"}]
[1000010,20,"TYPE: CABLE CLAMP FITTING\n","TYPE: CABLE CLAMP FITTING\n\n"," CABLE CLAMP FITTING\n",{"$f":"TRIM(E3)","v":"CABLE CLAMP FITTING\n"},{"$f":"A3&\"/\"&B3","v":"1000010/20"}]
[1000010,30,"APPLICATION: FOR 6MM HEX HEAD\n","APPLICATION: FOR 6MM HEX HEAD\n\n"," FOR 6MM HEX HEAD\n","FOR 6MM HEX HEAD\n","1000010/30"]
[1000012,10,"CONDUCTOR:\n","CONDUCTOR:\n\n","\n","\n","1000012/10"]
[1000012,20,"OUTSIDE DIAMETER: 20\"\n","OUTSIDE DIAMETER: 20\"\n\n"," 20\"\n","20\"\n","1000012/20"]
[1000012,30,"WEIGHT: 166.56 PPF\n","WEIGHT: 166.56 PPF\n\n"," 166.56 PPF\n","166.56 PPF\n","1000012/30"]
[1000012,40,"END CONNECTIONS: XLC-SE, MU/L:6.19\"\n","END CONNECTIONS: XLC-SE, MU/L:6.19\"\n\n"," XLC-SE, MU/L:6.19\"\n","XLC-SE, MU/L:6.19\"\n","1000012/40"]
[1000012,50,"END CONNECTION TYPE: BOX X PIN\n","END CONNECTION TYPE: BOX X PIN\n\n"," BOX X PIN\n","BOX X PIN\n","1000012/50"]
[1000012,60,"GRADE: X65\n","GRADE: X65\n\n"," X65\n","X65\n","1000012/60"]
[1000012,70,"LENGTH: R3\n","LENGTH: R3\n\n"," R3\n","R3\n","1000012/70"]
[1000012,80,"SPECIFICATION: API 5L, PSL2\n","SPECIFICATION: API 5L, PSL2\n\n"," API 5L, PSL2\n","API 5L, PSL2\n","1000012/80"]
[1000013,10,"CONDUCTOR:\n","CONDUCTOR:\n\n","\n","\n","1000013/10"]
[1000013,20,"OUTSIDE DIAMETER: 20\", COATED\n","OUTSIDE DIAMETER: 20\", COATED\n\n"," 20\", COATED\n","20\", COATED\n","1000013/20"]
[1000013,30,"WEIGHT: 166.56 PPF\n","WEIGHT: 166.56 PPF\n\n"," 166.56 PPF\n","166.56 PPF\n","1000013/30"]
[1000013,40,"END CONNECTIONS: XLC-SE, MU/L:6.19\"\n","END CONNECTIONS: XLC-SE, MU/L:6.19\"\n\n"," XLC-SE, MU/L:6.19\"\n","XLC-SE, MU/L:6.19\"\n","1000013/40"]
[1000013,50,"GRADE: X-65\n","GRADE: X-65\n\n"," X-65\n","X-65\n","1000013/50"]
[1000013,60,"LENGTH: R3\n","LENGTH: R3\n\n"," R3\n","R3\n","1000013/60"]
[1000013,70,"WALL THICKNESS: 0.812\"\n","WALL THICKNESS: 0.812\"\n\n"," 0.812\"\n","0.812\"\n","1000013/70"]
[1000015,10,"SSD: SLIDING SLEEVE\n","SSD: SLIDING SLEEVE\n\n"," SLIDING SLEEVE\n","SLIDING SLEEVE\n","1000015/10"]
[1000015,20,"TYPE: DURASLEEVE\n","TYPE: DURASLEEVE\n\n"," DURASLEEVE\n","DURASLEEVE\n","1000015/20"]
[1000015,30,"SIZE: 4.5\"\n","SIZE: 4.5\"\n\n"," 4.5\"\n","4.5\"\n","1000015/30"]
[1000015,40,"GRADE: L80 13CR\n","GRADE: L80 13CR\n\n"," L80 13CR\n","L80 13CR\n","1000015/40"]
[1000015,50,"CONNECTION: SL APEX\n","CONNECTION: SL APEX\n\n"," SL APEX\n","SL APEX\n","1000015/50"]
[1000016,10,"SSD: SLIDING SLEEVE\n","SSD: SLIDING SLEEVE\n\n"," SLIDING SLEEVE\n","SLIDING SLEEVE\n","1000016/10"]
[1000016,20,"TYPE: DURASLEEVE\n","TYPE: DURASLEEVE\n\n"," DURASLEEVE\n","DURASLEEVE\n","1000016/20"]
[1000016,30,"SIZE: 3.5'\n","SIZE: 3.5'\n\n"," 3.5'\n","3.5'\n","1000016/30"]
[1000016,40,"GRADE: L80 13CR\n","GRADE: L80 13CR\n\n"," L80 13CR\n","L80 13CR\n","1000016/40"]
[1000016,50,"CONNECTION: SL APEX\n","CONNECTION: SL APEX\n\n"," SL APEX\n","SL APEX\n","1000016/50"]
[1000016,60,"\n","\n\n",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"1000016/60"]
[1000017,10,"PACKER:\n","PACKER:\n\n","\n","\n","1000017/10"]
[1000017,20,"CASING/TUBING SIZE: 5.5\"\n","CASING/TUBING SIZE: 5.5\"\n\n"," 5.5\"\n","5.5\"\n","1000017/20"]
[1000017,30,"THREAD SIZE/WEIGHT/CONNECTION: 15.5#, SL APEX\n","THREAD SIZE/WEIGHT/CONNECTION: 15.5#, SL APEX\n\n"," 15.5#, SL APEX\n","15.5#, SL APEX\n","1000017/30"]
[1000017,40,"GRADE: L80 13CR\n","GRADE: L80 13CR\n\n"," L80 13CR\n","L80 13CR\n","1000017/40"]
[1000017,50,"TYPE: CHEMICAL INJECTION FEATURE\n","TYPE: CHEMICAL INJECTION FEATURE\n\n"," CHEMICAL INJECTION FEATURE\n","CHEMICAL INJECTION FEATURE\n","1000017/50"]
[1000021,10,"BALL:\n","BALL:\n\n","\n","\n","1000021/10"]
[1000021,20,"TYPE: DROPPING, PDC DRILLABLE\n","TYPE: DROPPING, PDC DRILLABLE\n\n"," DROPPING, PDC DRILLABLE\n","DROPPING, PDC DRILLABLE\n","1000021/20"]
[1000021,30,"DIAMETER: 1.5\"\n","DIAMETER: 1.5\"\n\n"," 1.5\"\n","1.5\"\n","1000021/30"]
[1000021,40,"MATERIAL: ALUMINIUM\n","MATERIAL: ALUMINIUM\n\n"," ALUMINIUM\n","ALUMINIUM\n","1000021/40"]
[1000022,10,"LINER:\n","LINER:\n\n","\n","\n","1000022/10"]
[1000022,20,"TYPE: PDC DRILLABLE\n","TYPE: PDC DRILLABLE\n\n"," PDC DRILLABLE\n","PDC DRILLABLE\n","1000022/20"]
[1000022,30,"SIZE: 1.75\"\n","SIZE: 1.75\"\n\n"," 1.75\"\n","1.75\"\n","1000022/30"]

{"sheet":"Basic_Data","index":3,"n_rows":12,"n_cols":1,"rows_kept":12,"hidden":true}
["BASIC_DATA"]
["KIT:\nTYPE: CABLE CLAMP FITTING\nAPPLICATION: FOR 6MM HEX HEAD"]
["CONDUCTOR:\nOUTSIDE DIAMETER: 20\"\nWEIGHT: 166.56 PPF\nEND CONNECTIONS: XLC-SE, MU/L:6.19\"\nEND CONNECTION TYPE: BOX X PIN\nGRADE: X65\nLENGTH: R3\nSPECIFICATION: API 5L, PSL2"]
["CONDUCTOR:\nOUTSIDE DIAMETER: 20\", COATED\nWEIGHT: 166.56 PPF\nEND CONNECTIONS: XLC-SE, MU/L:6.19\"\nGRADE: X-65\nLENGTH: R3\nWALL THICKNESS: 0.812\""]
["SSD: SLIDING SLEEVE\nTYPE: DURASLEEVE\nSIZE: 4.5\"\nGRADE: L80 13CR\nCONNECTION: SL APEX"]
["SSD: SLIDING SLEEVE\nTYPE: DURASLEEVE\nSIZE: 3.5'\nGRADE: L80 13CR\nCONNECTION: SL APEX\n"]
["PACKER:\nCASING/TUBING SIZE: 5.5\"\nTHREAD SIZE/WEIGHT/CONNECTION: 15.5#, SL APEX\nGRADE: L80 13CR\nTYPE: CHEMICAL INJECTION FEATURE"]
["BALL:\nTYPE: DROPPING, PDC DRILLABLE\nDIAMETER: 1.5\"\nMATERIAL: ALUMINIUM"]
["LINER:\nTYPE: PDC DRILLABLE\nSIZE: 1.75\"\nMATERIAL: ALUMINIUM"]
["GAUGE:MANDREL;\nSIZE: 4-1/2\"\nWEIGHT: 12.6#\nTHREAD UP: 4-1/2\" 12.6 LB/FT SL-APEX BOX\nTHREAD DOWN: 4-1/2\" 12.6 LB/FT SL-APEX PIN\nPRESSURE RATING: 10600PSI MIN WORKING\nTEMPERATURE RATING: 300 DEGF\nINSIDE DIAMETER: 3.864\" MIN\nDRIFT: 3.833\"\nMATERIAL: 13% CR 80 ICS118 - 22 HRC\nGAUGE INSTALLATION: EXTERNAL\nSURFACE TESTING FEATURE: YES\n"]
["GAUGE:MANDREL;\nSIZE: 5-1/2\"\nWEIGHT: 15.5#\nTHREAD UP: 5-1/2\" 15.5 LB/FT SL-APEX BOX\nTHREAD DOWN: 5-1/2\" 15.5 LB/FT SL-APEX PIN\nPRESSURE RATING: 6900PSI MIN\nTEMPERATURE RATING: 300 DEGF\nINSIDE DIAMETER: 4.856\"\nDRIFT: 4.825\"\nMATERIAL: 13% CR 80 KSI 18 - 22 HRC\nGAUGE INSTALLATION: EXTERNAL\nSURFACE TESTING FEATURE: YES\n\n"]
[""]

{"sheet":"Sample","index":4,"n_rows":11,"n_cols":2,"rows_kept":11,"hidden":true}
[1000010,"(BLCK)KIT:CBL CLMP FTG,F/6MM HX HD"]
[1000012,"COND:20\",166.56 PPF,XLC-SE,MU/L:6.19\",B>"]
[1000013,"COND:20\",CTD,166.56 PPF,XLC-SE,MU/L:6.1>"]
[1000015,"SSD,4.5\" DURASLEEVE,13CR L80,SLAPX"]
[1000016,"SSD,3.5\" DURASLEEVE,13CR L80,SLAPX"]
[1000017,"PKR:5.5\",15.5#,SLAPX,L80 13CR,CHEM INJ >"]
[1000021,"BALL:DROPPING,PDC DRILLABLE,1.5\",AL"]
[1000022,"LNR:PDC DRILLABLE,1.75\",AL"]
[1000031,"GAUGE:MNDRL;4-1/2\",12.6#,4-1/2\" 12.6 LB>"]
[1000033,"GAUGE:MNDRL;5-1/2\",15.5#,5-1/2\" 15.5 LB>"]
[1000050,"CTRL:TEC"]