saeed0012

New Member
Joined
Apr 12, 2024
Messages
1
Office Version
  1. 365
Platform
  1. Windows
hey guys

i would like to create a summary of the table into the table below in which when data is entered in the general table the summary table will only show the which have defects such as the poles that are rotten will show up in the table below , also the the pole number from the above table with regards the its defective pole should be shown in the summary along as the location

please and thank u

TAD-003 1 Primary Network Defects 2024..xlsx
ABCDEFGHIJKLMNOPQRSTUV
1NETWORK OPERATIONS DEPARTMENT
2Primary Network Defects Sheet GPL-TAD-003/1
3Pole No.LocationFeederPole LengthStructure TypeOld Pole (Remove)Old Pole w/Comms. RemoveOld Pole w/Meter (Remove)Replace Old Pole (Defective)Plumb PoleTransfer of Line HardwareLV Ckt on HV PoleDefective CrossarmReplace Pole Top PinReplace RCO, SPD, GABTree TrimmingBee/Pest Removal Replace Earth WireReplace Guy WireConductor to be tensionedOthersCode
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28Checked by:…………………………………Date;………………………..Certified By:…………………………Date:……………………..
29NT PatrolmanSupt/Designate
30
31NETWORK OPERATIONS DEPARTMENT
32Primary Network Defects Sheet GPL-TAD-003/1
33
34 CodesAbbreviationsDrawing
351Pole Alignment LAP - Light Angle Pole
362Unstable Soil/Foundation MAP - Medium Angle Pole
373Deterioration HAP - Heavy Angle Pole
384Corrosion/Rust DEP -Dead-end Pole
395Poor/Slack Connection TXP -Transformer Pole
406Scorch/burn marks IMP -Intermediate Pole
417Conductor Contact BP -Branch Pole
428Conductor Spacing SPR -Spur Pole
439Conductor Sag SP -Section Pole (GAB, SPDs, RCOs)
4410Defective Pole/Line Hardware PP -Plumb Pole
4511Overhanging vegetation
4612Vegetation Grow-in
4713Vegetation Undergrowth
4814Human Error/Workmanship
4915Sabotage/Vandals/Theft
5016Pests/wildlife
51Remarks:
52
53
54
55
56
57
58
59
60
61
62
63
64
65Summary Sheet
66Pole NumberLocationold pole to be removedold pole with meter to be removedreplace old polePlumb poleDefective crossarmReplace SPD,RCO,GABTree TrimmingBee/Pest Removal
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
Primary Distribution
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Forum statistics

Threads
1,223,867
Messages
6,175,069
Members
452,611
Latest member
bls2024

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top