|
|
| Post Number: 1
|
beantownR6 
Group: Members
Posts: 70
Joined: Mar. 2012
|
 |
Posted on: Feb. 13 2013, 3:07 pm |
|
   |
Microsoft Excel cant seem to do what i want it to do for trip planning. Im planning a JMT hike and want to do something like this to plan my trip with a spreadsheet. Im not an exert in excel but it seems limited. i can get it to do an x-y axis of mileage over elevaion but can't add other information like this example.
http://mappery.com/map-of/John-Muir-Trail-Elevation-Map
can anyone reccomend a good line chart software?
thanks
|
 |
|
|
| Post Number: 2
|
EastieTrekker
Group: Members
Posts: 1467
Joined: Mar. 2012
|
|
Posted on: Feb. 13 2013, 3:42 pm |
|
 |
I just got a warning that this link contains spyware...
--------------
I request all the possible consumer protection organizations, and fight with their injustice. 
|
|
|
|
| Post Number: 3
|
|
|
| Post Number: 4
|
ol-zeke
me in the Tetons
Group: Members
Posts: 10923
Joined: Sep. 2002
|
|
Posted on: Feb. 13 2013, 3:58 pm |
|
|
Link looked good to me, but I know of nothing available to use to create such a thing. I will be watching this thread to see what others use.
--------------
Everything I know, I learned by doing it wrong at least twice.
The easiest way to ruin a Friday is to realize it is only Tuesday.
|
|
|
|
| Post Number: 5
|
Lamebeaver
trail? I don't need no stinkin trail!
Group: Members
Posts: 16346
Joined: Aug. 2004
|
|
Posted on: Feb. 13 2013, 4:20 pm |
|
|
The nice thing about backpacking is that it gets you away from the digitized world for awhile. Don't get me wrong, I think Google Earth is a great tool for trip planning, but it sounds like you're planning your trip to death.
|
|
|
|
| Post Number: 6
|
|
|
| Post Number: 7
|
JRinGeorgia
Group: Members
Posts: 318
Joined: Jul. 2012
|
|
Posted on: Feb. 13 2013, 4:48 pm |
|
|
(Lamebeaver @ Feb. 13 2013, 4:20 pm)
QUOTE it sounds like you're planning your trip to death.
...although, sometimes lots of planning is a good way to avoid death (and other things you don't want to happen). I'm a planner myself and have never regretted it, often been thankful for it. Not sure how a graph would help avoid trouble (as opposed to the same info in list form), but the OP is entitled to float his boat the way he wants.
Link works OK for me. It's a dense chart, but everything on there seems within the abilities of Excel. The key is the data -- once you have it, then it is a simple matter for Excel to convert it to a graph. It does get complicated in Excel to start mixing different data to be presented in different ways on the same graph, but maybe a combination of hi-tech and low-tech would work best -- what if you plotted the elevations and then simply hand-wrote daily mileages on a print-out? Or, do the whole thing by hand? While it may be doable in Excel you would have a learning curve and time commitment to get it there, you could just plot the whole thing on graph paper and be done in the time you are still reading Excel tutorials.
--------------
- JRinGeorgia
|
|
|
|
| Post Number: 8
|
Chuck D
Group: Members
Posts: 7414
Joined: Feb. 2002
|
|
Posted on: Feb. 13 2013, 5:02 pm |
|
|
I made this using a scatter plot and an excel add on called XY chart labeler, with a little time it could be made much nicer
Attached Image
--------------
Everyone should be quick to listen, slow to speak and slow to become angry,
|
|
|
|
| Post Number: 9
|
|
|
| Post Number: 10
|
beantownR6
Group: Members
Posts: 70
Joined: Mar. 2012
|
|
Posted on: Feb. 13 2013, 5:59 pm |
|
|
im not sure why the link is coming up with spam, but here is the image
chuck i will check out the xy chart labeler.
i just want to keep it simple and i think excel will work great, just a few things i need to work out like the y axis for elevation is to scale (so to speak) but when it plots the mileage on the x axis it is not relative. the distance between the nodes is always 1, regardless if its 6 miles between one pont and 10 between the next., or to scale. and i would like to add points like on chucks example.
|
|
|
|
| Post Number: 11
|
davecarb
Group: Members
Posts: 205
Joined: Jun. 2006
|
|
Posted on: Feb. 14 2013, 1:52 am |
|
|
This chart is the first JMT trip I went on with the creator of this chart - Brian O'Kelly (Losthillsguy). If you Google him I'm sure you will be able to find his email contact. I think he is still a member of this forum too. He might be able to direct you on how he created the chart.
--------------
"I only went out for a walk, and finally concluded to stay out 'till sundown, for going out, I found, was really going in." ~ John Muir
|
|
|
|
| Post Number: 12
|
beantownR6
Group: Members
Posts: 70
Joined: Mar. 2012
|
|
Posted on: Feb. 18 2013, 4:54 pm |
|
|
I'm finally getting it to do what I want, just had to mess around with excel some more. im using the JMT wilderness press guide. so far i have input all trail info, mileage, elevations into a spreadsheet and have it to a profile. takes a little time but worth it for me to help plan for such a big trip
|
|
|
|
|
|
|
Survival Skills 101 • Eat Better
