TPQ · Total Part Quantities

Open / download original Excel fileFW_and_TW_Final_Takeoff.xlsx

These are the saved quantities in your original file. It includes the earlier WP2 entries. The V5 model uses your later TCXVPP replacement revision.

FW FAB 1-5

FW FAB 1–5 — parts and quantities
Only these five FAB drawings. Quantities are pieces. No component breakdowns.

Pods / data hall	11		Pods / Horizon	33
Data hall is the data-center scope used here. Pipe stock part numbers are not specified.

FAB 1
Assemblies					Per scope	5	55	165
Part number	Part	Material	Size	Cut length	Per FAB	Pod	Data hall	Horizon
WP1	Weld Part 1	SS	1 1/2"		3	15	165	495
25220	90° elbow		1 1/2"		2	10	110	330
24090	Bronze valve	Bronze	Not stated		1	5	55	165
76575	Transition coupling		Not stated		1	5	55	165
25360	Reducing tee		1 1/2" x 1 1/2" x 1/2"		1	5	55	165
26025	IPS reducer		1 1/2" to 1"		1	5	55	165
76585	IPS-to-CTS transition	Bronze	Not stated		1	5	55	165
79045	Check valve		1"		1	5	55	165
79450	Female NPT adapter	Bronze	1" x 1"		1	5	55	165
Not specified	Pipe cut	CS	1/2"	2 3/8"	1	5	55	165
Not specified	Pipe cut	CS	1"	4 1/4"	1	5	55	165
Not specified	Pipe cut	CS	1 1/2"	2' 6 13/16"	1	5	55	165
Total part pieces (WP1 counted once)					12	60	660	1,980
Total CS pipe cut pieces					3	15	165	495


FAB 2
Assemblies					Per scope	8	88	264
Part number	Part	Material	Size	Cut length	Per FAB	Pod	Data hall	Horizon
WP1	Weld Part 1	SS	1 1/2"		3	24	264	792
25220	90° elbow		1 1/2"		2	16	176	528
24090	Bronze valve	Bronze	Not stated		1	8	88	264
76575	Transition coupling		Not stated		1	8	88	264
25360	Reducing tee		1 1/2" x 1 1/2" x 1/2"		1	8	88	264
26025	IPS reducer		1 1/2" to 1"		1	8	88	264
76585	IPS-to-CTS transition	Bronze	Not stated		1	8	88	264
79045	Check valve		1"		1	8	88	264
79450	Female NPT adapter	Bronze	1" x 1"		1	8	88	264
Not specified	Pipe cut	CS	1/2"	2 3/8"	1	8	88	264
Not specified	Pipe cut	CS	1"	4 1/4"	1	8	88	264
Not specified	Pipe cut	CS	1 1/2"	1' 8 9/16"	1	8	88	264
Total part pieces (WP1 counted once)					12	96	1,056	3,168
Total CS pipe cut pieces					3	24	264	792


FAB 3
Assemblies					Per scope	1	11	33
Part number	Part	Material	Size	Cut length	Per FAB	Pod	Data hall	Horizon
WP1	Weld Part 1	SS	1 1/2"		3	3	33	99
25220	90° elbow		1 1/2"		3	3	33	99
24090	Bronze valve	Bronze	Not stated		1	1	11	33
76575	Transition coupling		Not stated		1	1	11	33
25360	Reducing tee		1 1/2" x 1 1/2" x 1/2"		1	1	11	33
26025	IPS reducer		1 1/2" to 1"		1	1	11	33
76585	IPS-to-CTS transition	Bronze	Not stated		1	1	11	33
79045	Check valve		1"		1	1	11	33
79450	Female NPT adapter	Bronze	1" x 1"		1	1	11	33
Not specified	Pipe cut	CS	1/2"	2 3/8"	1	1	11	33
Not specified	Pipe cut	CS	1"	4 1/4"	1	1	11	33
Not specified	Pipe cut	CS	1 1/2"	8"	1	1	11	33
Not specified	Pipe cut	CS	1 1/2"	2' 6 13/16"	1	1	11	33
Total part pieces (WP1 counted once)					13	13	143	429
Total CS pipe cut pieces					4	4	44	132


FAB 4
Assemblies					Per scope	13	143	429
Part number	Part	Material	Size	Cut length	Per FAB	Pod	Data hall	Horizon
WP1	Weld Part 1	SS	1 1/2"		2	26	286	858
25220	90° elbow		1 1/2"		1	13	143	429
24090	Bronze valve	Bronze	Not stated		1	13	143	429
76575	Transition coupling		Not stated		1	13	143	429
25360	Reducing tee		1 1/2" x 1 1/2" x 1/2"		1	13	143	429
26100	45° street elbow		1/2"		1	13	143	429
Not specified	Pipe cut	CS	1/2"	2 3/8"	1	13	143	429
Not specified	Pipe cut	CS	1 1/2"	4 1/4"	1	13	143	429
Total part pieces (WP1 counted once)					7	91	1,001	3,003
Total CS pipe cut pieces					2	26	286	858


FAB 5
Assemblies					Per scope	1	11	33
Part number	Part	Material	Size	Cut length	Per FAB	Pod	Data hall	Horizon
WP1	Weld Part 1	SS	1 1/2"		2	2	22	66
25220	90° elbow		1 1/2"		2	2	22	66
24090	Bronze valve	Bronze	Not stated		1	1	11	33
76575	Transition coupling		Not stated		1	1	11	33
25360	Reducing tee		1 1/2" x 1 1/2" x 1/2"		1	1	11	33
26100	45° street elbow		1/2"		1	1	11	33
Not specified	Pipe cut	CS	1/2"	2 3/8"	1	1	11	33
Not specified	Pipe cut	CS	1 1/2"	4 1/4"	1	1	11	33
Not specified	Pipe cut	CS	1 1/2"	1' 1"	1	1	11	33
Total part pieces (WP1 counted once)					8	8	88	264
Total CS pipe cut pieces					3	3	33	99


Combined totals — all five FAB drawings
Part number	Part	Material	Size	Cut length		Pod	Data hall	Horizon
WP1	Weld Part 1	SS	1 1/2"			70	770	2,310
25220	90° elbow		1 1/2"			44	484	1,452
24090	Bronze valve	Bronze	Not stated			28	308	924
76575	Transition coupling		Not stated			28	308	924
25360	Reducing tee		1 1/2" x 1 1/2" x 1/2"			28	308	924
26025	IPS reducer		1 1/2" to 1"			14	154	462
76585	IPS-to-CTS transition	Bronze	Not stated			14	154	462
79045	Check valve		1"			14	154	462
79450	Female NPT adapter	Bronze	1" x 1"			14	154	462
26100	45° street elbow		1/2"			14	154	462
TOTAL PART PIECES						268	2,948	8,844
WP1 is counted as one fabricated part. Its adapter and SS cut are not added again.

Part number	Part	Material	Size	Cut length		Pod	Data hall	Horizon
Not specified	Pipe cut	CS	1/2"	2 3/8"		28	308	924
Not specified	Pipe cut	CS	1"	4 1/4"		14	154	462
Not specified	Pipe cut	CS	1 1/2"	4 1/4"		14	154	462
Not specified	Pipe cut	CS	1 1/2"	8"		1	11	33
Not specified	Pipe cut	CS	1 1/2"	1' 1"		1	11	33
Not specified	Pipe cut	CS	1 1/2"	1' 8 9/16"		8	88	264
Not specified	Pipe cut	CS	1 1/2"	2' 6 13/16"		6	66	198
TOTAL CS PIPE CUT PIECES						72	792	2,376
TOTAL PARTS + CS PIPE CUT PIECES						340	3,740	11,220


Materials already inside WP1
Each WP1 contains one B19MPX-R150 adapter and one 1 1/2" SS pipe cut at 2 5/8".
The quantities below apply to EACH item separately. They are included in WP1, not additional assemblies.
Drawing	Included items	Material	Size	Cut length	Per FAB	Pod	Data hall	Horizon
FAB 1	Adapter and SS cut (each)	SS	1 1/2"	2 5/8" pipe	3	15	165	495
FAB 2	Adapter and SS cut (each)	SS	1 1/2"	2 5/8" pipe	3	24	264	792
FAB 3	Adapter and SS cut (each)	SS	1 1/2"	2 5/8" pipe	3	3	33	99
FAB 4	Adapter and SS cut (each)	SS	1 1/2"	2 5/8" pipe	2	26	286	858
FAB 5	Adapter and SS cut (each)	SS	1 1/2"	2 5/8" pipe	2	2	22	66
TOTAL OF EACH WP1 INTERNAL ITEM						70	770	2,310


Quantity basis: FAB 1.pdf through FAB 5.pdf, page 1; previously checked part-number takeoff.
Scope ratios: referenced drawing quantity blocks 14 / 154 / 462 and WP1 70 / 770 / 2,310.

TW Supply and Return

TW Supply and Return — final takeoff
Edit yellow cells on Edit Inputs. Quantities and weld-part materials update automatically.
WP2 uses assembly-layout quantities. The detail-sheet quantity conflict remains noted on Edit Inputs.

Supply drawing
Assemblies						8	88	264
Part number	Part	Material	Size	Cut length	Per drawing	Pod	Data hall	Horizon
WP2	Weld Part 2	SS	2"		1	8	88	264
WP3	Weld Part 3	SS	2"		1	8	88	264
WP4	Weld Part 4	SS	2"		0	0	0	0
80425	90° elbow	SS	2"		1	8	88	264
80930	Threaded-branch tee	SS	2" x 2" x 3/4" FPT		1	8	88	264
Custom — no PN	Reducing bushing	Not stated	3/4" MPT x 1/2" FPT		1	8	88	264
80720	Reducing tee	SS	2" x 2" x 1/2"		1	8	88	264
81081	Ball valve	SS	1/2"		1	8	88	264
80580	Press tee	SS	1/2"		1	8	88	264
79430	Bronze instrument adapter — uncut	Bronze	1/2"		2	16	176	528
TOTAL PART PIECES					10	80	880	2,640
Weld parts count as one part each. Tube cuts are listed below.


Return drawing
Assemblies						8	88	264
Part number	Part	Material	Size	Cut length	Per drawing	Pod	Data hall	Horizon
WP2	Weld Part 2	SS	2"		2	16	176	528
WP3	Weld Part 3	SS	2"		1	8	88	264
WP4	Weld Part 4	SS	2"		1	8	88	264
80425	90° elbow	SS	2"		1	8	88	264
80930	Threaded-branch tee	SS	2" x 2" x 3/4" FPT		0	0	0	0
Custom — no PN	Reducing bushing	Not stated	3/4" MPT x 1/2" FPT		0	0	0	0
80720	Reducing tee	SS	2" x 2" x 1/2"		2	16	176	528
81081	Ball valve	SS	1/2"		1	8	88	264
80580	Press tee	SS	1/2"		1	8	88	264
79430	Bronze instrument adapter — uncut	Bronze	1/2"		3	24	264	792
TOTAL PART PIECES					12	96	1,056	3,168
Weld parts count as one part each. Tube cuts are listed below.


Combined parts — Supply + Return
Part number	Part	Material	Size			Pod	Data hall	Horizon
WP2	Weld Part 2	SS	2"			24	264	792
WP3	Weld Part 3	SS	2"			16	176	528
WP4	Weld Part 4	SS	2"			8	88	264
80425	90° elbow	SS	2"			16	176	528
80930	Threaded-branch tee	SS	2" x 2" x 3/4" FPT			8	88	264
Custom — no PN	Reducing bushing	Not stated	3/4" MPT x 1/2" FPT			8	88	264
80720	Reducing tee	SS	2" x 2" x 1/2"			24	264	792
81081	Ball valve	SS	1/2"			16	176	528
80580	Press tee	SS	1/2"			16	176	528
79430	Bronze instrument adapter — uncut	Bronze	1/2"			40	440	1,320
TOTAL PART PIECES						176	1,936	5,808


All tube cuts — including tube inside weld parts
Stock part number	Material	Size	Cut length	Per Supply	Per Return	Pod pieces	Hall pieces	Horizon pieces
82000	SS	1/2"	1 3/4"	2	2	32	352	1,056
82025	SS	2"	1 5/8"	1	2	24	264	792
82025	SS	2"	3 7/8"	1	1	16	176	528
82025*	SS	2"	6 7/8"	1	0	8	88	264
82025	SS	2"	9 1/8"	0	1	8	88	264
82025	SS	2"	14"	1	1	16	176	528
TOTAL TUBE CUT PIECES				6	7	104	1,144	3,432
*82025 on the 6 7/8" cut is inferred. Counts include internal weld-part tubes once; do not add them to the part-piece total.


Ferrules already inside WP2, WP3 and WP4
Part number	Part	Material	Size			Pod	Data hall	Horizon
TL14AM7-200PL	Weld ferrule	SS	2"			48	528	1,584
Included materials only. Ferrules are already contained in the weld parts above.

Edit Inputs

Edit quantities and scope
Yellow cells are editable counts. The workbook is unprotected. Keep gray/formula cells for automatic totals.

Drawing	Pod assemblies	Data hall assemblies	Horizon assemblies
Supply	8	88	264				pp. 1–2: each 8 / 88 / 264. Independent scope counts.
Return	8	88	264


Parts per one complete drawing
Part number	Part	Material	Size	Supply qty	Return qty
WP2	Weld Part 2	SS	2"	1	2		pp. 3, 6, 7 and 9. Layout usage 1 Supply / 2 Return; p. 9 quantity block conflicts.
WP3	Weld Part 3	SS	2"	1	1		pp. 1–2 and 10: one per Supply and one per Return.
WP4	Weld Part 4	SS	2"	0	1		pp. 2, 8 and 11: one per Return.
80425	90° elbow	SS	2"	1	1		p. 3 item 2; p. 8 item 2. Original per drawing: 1 / 1.
80930	Threaded-branch tee	SS	2" x 2" x 3/4" FPT	1	0		p. 4 item 1. Original per drawing: 1 / 0. Optional 80920 not selected.
Custom — no PN	Reducing bushing	Not stated	3/4" MPT x 1/2" FPT	1	0		p. 4 item 2. Original per drawing: 1 / 0. Custom; no manufacturer PN given.
80720	Reducing tee	SS	2" x 2" x 1/2"	1	2		p. 5 item 1; p. 6 item 1; p. 7 item 1. Original per drawing: 1 / 2.
81081	Ball valve	SS	1/2"	1	1		pp. 5–6 item 3. Original per drawing: 1 / 1.
80580	Press tee	SS	1/2"	1	1		pp. 5–6 item 4. Original per drawing: 1 / 1.
79430	Bronze instrument adapter — uncut	Bronze	1/2"	2	3		pp. 5–7 allow 79430. User-selected uncut bronze replaces 80126. Effective: 2 / 3.


Tube cuts per one complete drawing
Stock part number	Use	Material	Size	Cut length	Supply qty	Return qty
82000	Small tubes	SS	1/2"	1 3/4"	2	2	pp. 5–6 item 2. Two separate tube cuts per drawing; no cut adapters.
82025	Inside WP2	SS	2"	1 5/8"	1	2	p. 9 item 1. One tube per WP2. Quantity follows WP2 automatically.
82025	Separate tube	SS	2"	3 7/8"	1	1	p. 3 item 3; p. 8 item 3. One per drawing.
82025*	Separate tube	SS	2"	6 7/8"	1	0	p. 1 cut callout. Stock PN inferred from matching 2" tube, not printed on this callout.
82025	Inside WP4	SS	2"	9 1/8"	0	1	p. 11 item 1. One tube per WP4. Quantity follows WP4 automatically.
82025	Inside WP3	SS	2"	14"	1	1	p. 10 item 1. One tube per WP3. Quantity follows WP3 automatically.


Included weld-part material
Part number	Part	Material	Size	Qty / weld part
TL14AM7-200PL	Weld ferrule	SS	2"	1			pp. 9–11 item 2: one ferrule per weld part, already included.


Drawing notes
Source: TW GPU DROPS COMPLETE - REV 0 9.29.26.pdf, pages 1–11.
WP2: p. 9 prints 8 / 88 / 264. Assembly usage requires 24 / 264 / 792. This draft uses assembly usage; confirm the mismatch.
Bronze 79430 is used uncut at all five adapter positions per Supply + Return pair, following your earlier instruction.
Supply uses 80930 plus the custom reducing bushing. The optional 80920 replacement is not included.
82025* on the 6 7/8" cut is inferred, not directly stated. All pipe quantities are cut pieces, not stock lengths.
The Return 9 1/8" cut is inside WP4 and is counted once. Weld operations are not purchased parts.
WP2 / WP3 / WP4 are local fabricated-part labels. Ferrules and their internal tube cuts must not be added to weld-part counts.
Edit existing quantities and scope counts in yellow. Adding new part rows requires extending the totals and formula references.