Expert answer:Reformat VBA Excel Sheet

Answer & Explanation:I need someone to take the amery Excel file and format it so it looks like the hydraulic excel file and change the code to make it work. I want to press the “Press Button to Compute” button and have all the yellow boxes (ouput boxes change accordingly). All you have to do is change the cells in VBA, shouldnt be too hard. I also need the function to read Project 3 and not Project 4 as it is now. Please let me know if you have any questions. 15_311_hydraulic_calculation_template_1___1_.xlsxamery_311project3.xlsm
15_311_hydraulic_calculation_template_1___1_.xlsx

amery_311project3.xlsm

Unformatted Attachment Preview

Pressure Losses
DP/CSG
DP/OH
HWDP/OH
DC/OH
MW
Q
Stroke Rate
Inside
Annulus
Total Friction Loss
psi
psi
psi
Jet Pressure Losses
TFA
Jet Loss
in2
psi
Total Pressure Loss in System
Pump Pressure
psi
Jets
Fann RPM
Fann Reading
600
300
200
100
6
3
Liner
Stroke
Rod
Volumetric Efficiency
Stroke Rate
Pump Factor
Flow Rate
Page 1 of 2
L
SL
R
EV
S
PF
Q
in
in
in
spm
gps
gpm
EMW (ppg)
Annulus Pressure Loss (psi)
Annulus DP (psi/ft)
Inside Pressure Loss (psi)
Inside DP (psi/ft)
ppg
gpm
spm
OD (in)
Length (ft)
0.00
0.00
ID (in)
Hole (in)
Frictional Pressure Losses
Name:
Used correct filename convention: email name_project3.xls
Successfully calculates a single pipe frictional pressure loss
Successfully calculates a single annulus frictional pressure loss
Successfully calculates all pipe frictional pressure losses
Successfully calculates all annulus frictional pressure losses
Mud pump: Triplex pump factor
Mud pump: Triplex pump rate
Mud pump: Duplex pump factor
Mud pump: Duplex pump rate
Single cell showing net frictional pressure loss
Single cell showing jet pressure loss (with up to four nozzle inputs)
Single cell showing total pump pressure
Calculates ECD in ppg at bottom of open hole section
Calculates ECD in ppg at top of open hole section
Successfully calculates optimum nozzle size for HHP
Successfully calculates optimum nozzle size for IF
Maximum Possible
Score
3
20
20
15
15
3
3
3
3
3
3
3
3
3
7.5
7.5
115
Your Score
0
Pressure Losses
4
4
4.5
6.25
#NAME?
#NAME?
#NAME?
#NAME?
MW
12
ppg
Rate
Q
85
249.1362
spm
gpm
Jets
14
15
15
ECD (ppg)
Inside DP (psi/ft)
3.24
3.24
2.75
2.5
EMW (ppg)
OD (in)
3200
4200
600
180
Annulus Pressure Loss (psi)
ID (in)
8.017
7.875
7.875
7.875
Annulus DP (psi/ft)
Length (feet)
DP/CSG
DP/OH
HWDP/OH
DC/OH
Inside Pressure Loss (psi)
Hole (in)
Frictional Pressure Losses
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
psi
psi
psi
Inside
Annulus
Total Friction Loss
Jet Pressure Losses
TFA
0.4954758
Jet Loss 279.40
Total Pressure Loss in System
Pump Pressure
#NAME?
Fann RPM
600
300
200
100
6
3
Liner
Stroke
Rod
Volumetric Efficiency
Pump Factor
Stroke Rate
Flow Rate
in2
psi
ECD at TD
14.28
Press Button to Compute
psi
Fann Reading
72
43
32
18
5
4
Triplex Pump
L
5.5
SL
10
R
0
EV
95%
PF
3.085279
S
85
Q
249.1362
Page 1 of 5
ECD at Shoe
#NAME?
in
in
in
gps
spm
gpm
Optimum HHP
Jet Force
#NAME?
#NAME?
Coefficients
A
B
Sxy
Sxx
Syy
1.213436
0.102882
C
2
Sx y
0.059362
Sxx
2
12.739
23.86101
6.913863 23.86101 173.2455
94.27689 173.2455
1287.92
6.39693 4.276666 40.92071 261.7669
5.703782 3.7612 32.53313 185.5619
5.298317 3.465736 28.07217 148.7352
12.739
94.27689
4.60517
173.2455
2 2
Sx x
1.791759 1.609438 3.210402 5.752268
1287.92
sum
avg
1.098612 1.386294 1.206949 1.325969
24.89457 17.38971 127.151 700.8069
4.149095 2.898284
5
4.5
Series1
4
Poly. (Series1)
3.5
3
2.5
2
y = 0.0594×2 + 0.1029x + 1.2134
R² = 0.999
1.5
1
0.5
0
0
80
70
60
50
40
30
20
1
2
2.890372 21.20759 97.66457
3
4
5
6
7
Coefficients
20
10
0
0
100
200
300
400
500
600
700
Coefficients
1674.504 18.28987 27.35753 175.0042
1058.405 14.14663 21.45307 122.3636
788.0466 12.01133 18.36257 97.29072
4.300685 73.75028
3.731472 41.74052
3.424947 30.72101
449.762
8.354249 13.31065 61.29783
2.946142 19.03239
10.30668
2.59029
2.883726 5.166943
1.58835 4.895666
1.456726 1.921812
1.523
1.673187
3982.481 57.31418 84.89055 462.7965
count
6
1.39811 4.047542
Name:
Used correct filename convention: email name_project4.xls
Successfully calculates a single pipe frictional pressure loss
Successfully calculates a single annulus frictional pressure loss
Successfully calculates all pipe frictional pressure losses
Successfully calculates all annulus frictional pressure losses
Mud pump: Triplex pump factor
Mud pump: Triplex pump rate
Mud pump: Duplex pump factor
Mud pump: Duplex pump rate
Blue box shows which type of pump
Single cell showing net frictional pressure loss
Single cell showing jet pressure loss (with up to three nozzle inputs)
Single cell showing total pump pressure
Calculates ECD in ppg at bottom of open hole section
Calculates ECD in ppg at top of open hole section
Successfully calculates optimum nozzle size for HHP
Successfully calculates optimum nozzle size for IF
Maximum Possible
Score
3
15
15
15
15
3
3
3
3
3
5
5
6
3
3
7.5
7.5
115
Your Score
0
…
Purchase answer to see full
attachment

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades