Activity Feed › Discussion Forums › Strictly Surveying › Excel Vertical Curve Calculator
-
I would like this excel program too if it’s still available.
thank you.
John McCullough
e-mail: [email protected]
-
All,
Unfortunately, I provided this to a single individual with a specific problem, under the condition he wouldn’t share it.As I created this program while collecting a wage, it is actually the property of my employer. To share it en-mass would be problematic.
As it seems to be in demand, I propose that all the beerleggers create it together, and therefore create a program easilly shared by all of us. The calculations are really not difficult, and the excel programming is well documented (just google if you struggle).
I would be happy to assist with any specific questions you may have.
(I am a surveyor, and while I program 48’s, 33’s, 35’s, and excel calculations, I am not a programmer by any stretch of the imagination, my programming lacks any elegance whatsoever, but gets the job done. Any advice I gave May be full of errors, but just happened to work correctly on whatever sample calculations I came up with to test it.)
-
> All,
> Unfortunately, I provided this to a single individual with a specific problem, under the condition he wouldn’t share it.
>
> As I created this program while collecting a wage, it is actually the property of my employer. To share it en-mass would be problematic.
>
> As it seems to be in demand, I propose that all the beerleggers create it together, and therefore create a program easilly shared by all of us. The calculations are really not difficult, and the excel programming is well documented (just google if you struggle).
>
> I would be happy to assist with any specific questions you may have.
>
> (I am a surveyor, and while I program 48’s, 33’s, 35’s, and excel calculations, I am not a programmer by any stretch of the imagination, my programming lacks any elegance whatsoever, but gets the job done. Any advice I gave May be full of errors, but just happened to work correctly on whatever sample calculations I came up with to test it.)Fair enough. Respect mon. Good follow up.
-
I haven’t played with it, but there is one from Michigan DOT
http://www.michigan.gov/documents/MDOT-Vertical_Curve_Calcs_120887_7.xlsAnd here’s one that I cooked up to look a lot like the screenshot posted above. I have not thoroughly checked it out for accuracy, so please verify it with some known examples before relying on it.
I also have not figured out how to terminate at the end of the curve, so you’ll have to cut or copy and paste cells to fit the number of stations you need displayed.
I’ll work on that when I can. Or maybe this will inspire somebody else to fix it.
https://dl.dropboxusercontent.com/u/25124076/VertCalc.xls
. -
A somewhat improved version of my spreadsheet is at the same link. It cleans up the junk after the useful list and adds a couple calculators at the side for problems with different given data.
. -
Bill,
I have some issue between dropbox and excel. Whenever I try to make the file editable, It just says “waiting for another application to complete OLE.” I have no idea what this.Any chance you can email the spreadsheet directly? jturnbull at grayse dot gs
Perhaps tonight, I will be able to look over it and see how it works.
Glad you could make this happen.
-
Updated again per suggestions from Justin (summerprophet). It now contains sheet 2 as a straight grade calculator.
The sheets are protected to keep you from accidentally clobbering a formula, but you can unprotect (Tools/Protection) if you need to change something other than the green cells.
. -
> Updated again per suggestions from Justin (summerprophet). It now contains sheet 2 as a straight grade calculator.
>
> The sheets are protected to keep you from accidentally clobbering a formula, but you can unprotect (Tools/Protection) if you need to change something other than the green cells.Way to go!
-
kindly send me copy of excel vertical curve calculator and send it to my email
-
I would like a copy of the Excel spreadsheet of the curve calculator. here is my email.. [email][email protected][/email]
thanks in advance
-
If you could copy me on that I’d greatly appreciate it – ldrennan63 AT gmail DOT com
-
There is a link to the file further up in this thread.
-
Bill93, post: 292393, member: 87 wrote: https://dl.dropboxusercontent.com/u/25124076/VertCalc.xls
Doesn’t the link work? What error do you get?
I emailed the file to the three latest requests. No warranties. Please check it carefully and let me know how it works out for you.
.
Log in to reply.