• Replies 1 reply
  • Subscribers 80 subscribers
  • Views 188 views
  • Users 0 members are here

Please compare excel sheet with Sewer Gems Output column name

Bhavin Solanki
Offline

Hi

I am Bhavin Diwecha

Please compare excel sheet column text & Name and match with Sewer Gems Output of conduit table,

Example :- if Excel column show = d/D and which name d/D show in sewer Gems

please help me.

NODE PRESENT POP. PEAK FACTOR ULTIMATE POP. PRESENT Q(LPS) ULTIMATE Q(LPS) LENGTH
(M)		 DIA
(mm)		 SLOPE SEWAGE FLOW (FULL)
Qf (LPS)		 FLOW RATIO
(q/Qf)		 MANNING'S CO-EFFICIENT
(n)		 (d/D) VELOCITY (FULL), V VELOCITY RATIO ACTUAL VELOCITY FALL DUE TO BEND, PIPE SIZE DROP DUE TO BRANCH NO. OF VERTICAL DROP ADDL. DEPTH OF VERTICAL DROP GROUND LEVEL (M) INVERT LEVEL (M)
From To Pop. covered by pipe Cumulative Pop. Pop. covered by pipe Cumulative Pop. Present Peak Present Peak Cumulative (q1) Ultimate Peak Ultimate Peak Cumulative (q2) Present
(q1/Qf)		 Ultimate
(q2/Qf)		 Present
(d/D)		 Ultimate
(d/D)		 Present
(v1/V)		 Ultimate
(v2/V)		 Present
(v1)		 Ultimate
(v2)		 U.G.L. D.G.L. U.I.L D.I.L
                                                                 
1 2 5 15 5 10 28 0.027 0.08 0.05 0.15 26 150 200 12.73 0.01 0.01 0.011 0.07 0.07 0.72 0.32 0.32 0.23 0.23     0 0 101.723 101.186 100.373 100.243
2 3 5 30 5 10 55 0.027 0.16 0.05 0.29 26 150 200 12.73 0.01 0.02 0.011 0.07 0.10 0.72 0.32 0.40 0.23 0.29     0 0 101.186 100.863 100.243 100.113
3 4 5 60 5 10 110 0.027 0.32 0.05 0.59 31 150 200 12.73 0.03 0.05 0.011 0.10 0.14 0.72 0.40 0.50 0.29 0.36     0 0 100.863 100.771 100.113 99.477
4 5 5 75 5 10 137 0.027 0.40 0.05 0.73 17 150 200 12.73 0.03 0.06 0.011 0.12 0.16 0.72 0.45 0.54 0.32 0.39     0 0 100.771 101.129 99.477 99.392
Communities
Support and Services
Training and Learning
Social Media