Hallow everyone !
Guys how I can integrate Schedule Standard (STD) in my excel to automatically check 3 cells in my DB ?
This is original pdf file of Schedule Standard
This is my DB and I marked by color only that places which match with my DB, I want control those cells automatically because of human factor and mechanical mistakes.
I need only one Example how I can integrate this Schedule in my DB. By formula only because I don't know VBA properly.
I just transform Schedule Standard (STD) which was in pdf to Excel.
Thanks guys.
Guys how I can integrate Schedule Standard (STD) in my excel to automatically check 3 cells in my DB ?
This is original pdf file of Schedule Standard
This is my DB and I marked by color only that places which match with my DB, I want control those cells automatically because of human factor and mechanical mistakes.
I need only one Example how I can integrate this Schedule in my DB. By formula only because I don't know VBA properly.
TIE-IN Welding Log SD 2021 W (version 2).xlsx | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AS | AV | BA | BB | |||||||||||||||||||||
1 | Drawing № | Revision Number | Line | IsoType | Unit | Service | Train | Material Class | Joint Type | Joint | Joint Size | Spool | Location | SCH | Pipelen | Item Code1 | Item Code2 | Subcontractor | Mat Grade1 | Mat Grade2 | Area | Fit-Up Date | Heat Number1 | Heat Number2 | WPS | Welder1 | Welder2 | Welder3 | Welder4 | Date Of Weld | Welding Report Number | VISUAL REPORT DATE | THK | VIS RESULT | VIS DATE | ||||||||||||||||||||
2 | HS523217-66-PIP-ISO-0005-0001 | F002 | 4-TP-660005-DA23-NI | AG | 66 | TP | 0001 | DA23 | BW | WS02 | 4 | SP01 | SHOP | 80 | 1820963 | 1906050 | A234 | A105 | SHOP | 06.02.2021 | 1016493111 | 2019733110 | 001 | PW-002 | N/A | N/A | N/A | 06.02.2021 | CON-PIP-12-T-S0001 | 06.02.2021 | 8.56 | ACC | 06.02.021 | ||||||||||||||||||||||
3 | HS523217-66-PIP-ISO-0003-0001 | F002 | 4-TP-660005-DA23-NI | AG | 66 | TP | 0001 | DA23 | BW | WS02 | 4 | SP01 | SHOP | 80 | 1820963 | 1906050 | A234 | A105 | SHOP | 06.02.2021 | 1016493111 | 2019733110 | 001 | PW-002 | N/A | N/A | N/A | 06.02.2021 | CON-PIP-12-T-S0002 | 06.02.2021 | 8.56 | ACC | 06.02.021 | ||||||||||||||||||||||
Weld log |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
CD293:CJ294,CD301:CJ302,Z206:AA206,C204,BL205:BL206,BC217:BE217,O216:O217,U212:AE212,W231:AA231,AE231:AE234,Y234:AB235,AH235:BP235,AG220:BP220,AG211:BN211,W232:AB233,L359:CJ368,L2:CH2,L105:L106,L62:N64,L231:O234,L216:M217,L235:L236,L227:M230,C207:J210 | Cell | contains a blank value | text | NO |
I just transform Schedule Standard (STD) which was in pdf to Excel.
std.xlsx | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
1 | Nominal pipe size mm/ inch | OD mm | 20 | 30 | STD | 40 | 60 | XS | 80 | 100 | 120 | 140 | 160 | XXS | Shipping vol/CBM | ||
2 | 15 1/2 | 21,3 | 2.77 1.27 | 2.77 1.27 | 3.73 1.62 | 3.73 1.62 | 4.78 1.95 | 7.47 2.55 | 0,0004 | ||||||||
3 | 20 3/4 | 26,7 | 2.87 1.69 | 2.87 1.69 | 3.91 2.20 | 3.91 2.20 | 5.56 2.90 | 7.82 3.64 | 0,0007 | ||||||||
4 | 25 1 | 33,4 | 3.38 2.50 | 3.38 2.50 | 4.55 3.24 | 4.55 3.24 | 6.35 4.24 | 9.09 5.45 | 0,0011 | ||||||||
5 | 32 11/4 | 42,2 | 3.56 3.39 | 3.56 3.39 | 4.85 4.47 | 4.85 4.47 | 6.35 5.61 | 9.70 7.77 | 0,0017 | ||||||||
6 | 40 11/2 | 48,3 | 3.68 4.05 | 3.68 4.05 | 5.08 5.41 | 5.08 5.41 | 7.14 7.25 | 10.15 9.56 | 0,023 | ||||||||
7 | 50 2 | 60,3 | 3.91 5.44 | 3.91 5.44 | 5.54 7.48 | 5.54 7.48 | 8.74 11.11 | 11.07 13.44 | 0,036 | ||||||||
8 | 65 21/2 | 73 | 5.16 8.63 | 5.16 8.63 | 7.01 11.41 | 7.01 11.41 | 9.53 14.92 | 14.02 20.39 | 0,0053 | ||||||||
9 | 80 3 | 88,9 | 5.49 11.29 | 5.49 11.29 | 7.62 15.27 | 7.62 15.27 | 11.13 21.35 | 15.24 27.68 | 0,0079 | ||||||||
10 | 90 31/2 | 101,6 | 5.74 13.57 | 5.74 13.57 | 8.08 18.63 | 8.08 18.63 | - - | - - | 0,0103 | ||||||||
11 | 100 4 | 114,3 | 6.02 16.07 | 6.02 16.07 | 8.56 22.32 | 8.56 22.32 | 11.13 28.32 | 13.49 33.54 | 17.12 41.03 | 0,013 | |||||||
12 | 125 5 | 141,3 | 6.55 21.77 | 6.55 21.77 | 9.53 30.97 | 9.53 30.97 | 12.70 40.28 | 15.88 49.11 | 19.05 57.43 | 0,0199 | |||||||
13 | 150 6 | 168,3 | 7.11 28.26 | 7.11 28.26 | 10.97 42.56 | 10.97 42.56 | 14.27 54.20 | 18.26 67.56 | 21.95 79.22 | 0,028 | |||||||
14 | 200 8 | 219,1 | 6.35 33.31 | 7.04 36.81 | 8.18 42.55 | 8.18 42.55 | 10.31 53.08 | 12.70 64.64 | 12.70 64.64 | 15.09 75.92 | 18.26 90.44 | 20.62 100.92 | 23.01 111.27 | 22.23 107.92 | 0,048 | ||
15 | 250 10 | 273,1 | 6.35 41.77 | 7.80 51.03 | 9.27 60.31 | 9.27 60.31 | 12.70 81.55 | 12.70 81.55 | 15.09 96.01 | 18.26 114.75 | 21.44 133.06 | 25.40 155.15 | 28.58 172.33 | 25.40 155.15 | 0,074 | ||
16 | 300 12 | 323,9 | 6.35 49.73 | 8.38 65.20 | 9.53 73.88 | 10.31 79.73 | 14.27 108.96 | 12.70 97.46 | 17.48 132.08 | 21.44 159.91 | 25.40 186.97 | 28.58 208.14 | 33.32 238.76 | 25.40 186.97 | 0,104 | ||
17 | 350 14 | 355,6 | 7.92 67.90 | 9.53 81.33 | 9.53 81.33 | 11.13 94.55 | 15.09 126.71 | 12.70 107.39 | 19.05 158.10 | 23.83 194.96 | 27.79 224.65 | 31.75 253.56 | 35.71 281.70 | 0,126 | |||
18 | 400 16 | 406,4 | 7.92 77.83 | 9.53 93.27 | 9.53 93.27 | 12.70 123.30 | 16.66 160.12 | 12.70 123.30 | 21.44 203.53 | 26.19 245.56 | 30.96 286.64 | 36.53 333.19 | 40.49 365.35 | 0,165 | |||
19 | 450 18 | 457,2 | 7.92 87.71 | 11.13 122.38 | 9.53 105.16 | 14.27 155.80 | 19.05 205.74 | 12.70 139.15 | 23.88 254.55 | 29.36 309.62 | 34.93 363.56 | 39.67 408.26 | 45.24 459.37 | 0,209 | |||
20 | 500 20 | 508 | 9.53 117.15 | 12.70 155.12 | 9.53 117.15 | 15.09 183.42 | 20.62 247.83 | 12.70 155.12 | 26.19 311.17 | 32.54 381.53 | 38.10 441.49 | 44.45 508.11 | 50.01 564.81 | 0,258 | |||
21 | 550 22 | 558,8 | 9.53 129.13 | 12.70 171.09 | 9.53 129.13 | - - | 22.23 294.25 | 12.70 171.09 | 28.58 373.83 | 34.93 451.42 | 41.28 527.02 | 47.63 600.63 | 53.98 672.26 | 0,312 | |||
22 | 600 24 | 609,6 | 9.53 141.12 | 14.27 209.64 | 9.53 141.12 | 17.48 255.41 | 24.61 355.26 | 12.70 187.06 | 30.96 442.08 | 38.89 547.71 | 46.02 640.03 | 52.37 720.15 | 59.54 808.22 | 0,372 | |||
23 | 650 26 | 660,4 | 12.70 202.72 | - - | 9.53 152.87 | - - | 12.70 202.72 | 0,436 | |||||||||
24 | 700 28 | 711,2 | 12.70 218.69 | 15.88 271.21 | 9.53 164.85 | - - | 12.70 218.69 | 0,505 | |||||||||
25 | 750 30 | 762 | 12.70 234.67 | 15.88 292.18 | 9.53 176.84 | - - | 12.70 234.67 | 0,58 | |||||||||
26 | 800 32 | 812,8 | 12.70 250.64 | 15.88 312.15 | 9.53 188.82 | 17.48 342.91 | 12.70 250.64 | 0,66 | |||||||||
27 | 850 34 | 863,6 | 12.70 266.61 | 15.88 332.12 | 9.53 200.31 | 17.48 364.90 | 12.70 266.61 | 0,745 | |||||||||
28 | 900 36 | 914,4 | 12.70 282.27 | 15.88 351.70 | 9.53 212.56 | 19.05 420.42 | 12.70 282.27 | 0,836 | |||||||||
29 | 950 38 | 965,2 | 9.53 224.54 | 12.70 298.24 | 0,931 | ||||||||||||
30 | 1000 40 | 1016 | 9.53 236.53 | 12.70 314.22 | 1,032 | ||||||||||||
31 | 1050 42 | 1066,8 | 9.53 248.52 | 12.70 330.19 | 1,138 | ||||||||||||
32 | 1100 44 | 1117,8 | 9.53 260.50 | 12.70 346.16 | SI Units (Metric) OD = mm Wall thickness = mm Weight = kg/m (plain end mass) | 1,249 | |||||||||||
33 | 1150 46 | 1168,4 | 9.53 272.25 | 12.70 351.82 | 1,365 | ||||||||||||
34 | 1200 48 | 1219,2 | 9.53 284.24 | 12.70 377.79 | 1,486 | ||||||||||||
page 1 |
Thanks guys.