Re: Cumulative sum with a ceiling
- From: "Chip Pearson" <chip@xxxxxxxxxxxx>
- Date: Mon, 1 Jan 2007 18:34:35 -0600
Microsoft also has a similar product, but I've not used it. (
MapPoint will do all that and more. One of the more intriguing features of
MapPoint is that it connects to the internet and downloads (from where I
don't know) road construction info, alerting you to the fact that a
particular highway may have construction delays. It allows you to assign
speeds to different road types (e.g., 70 mph for Interstates and 30 for side
streets), and will compute travel time based on which type of roads you'll
be driving on. MapPoint is one of favorite Office programs.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
"Dana DeLouis" <ddelouis@xxxxxxxxxxxxx> wrote in message
news:%23MEPzCgLHHA.2236@xxxxxxxxxxxxxxxxxxxxxxx
My objective is to plan a travel route over 5000kms and a scheduled stop
every 350kms for the night.
May I suggest an alternative if your travel is in the USA?
I would recommend mapping software, such as "Street Atlas 2007." from
DeLorme ( http://www.delorme.com )
Microsoft also has a similar product, but I've not used it. (
http://www.microsoft.com/streets/default.mspx )
You can tell such programs you would like to drive 350km per day, and it
will plan all your stops on the map.
You can also give your car's gas mileage, etc, and it will plan gas stops
as well.
Your map will display all the planned stops.
Right click the area of the map where you plan to spend the night, and it
will pull up all hotels in the area, complete with address/phone numbers.
Again, just an idea.
--
HTH :>)
Dana DeLouis
Windows XP & Office 2003
"Max" <Max@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:95C69C2F-77A9-4B16-AC5A-B18CF3E02A43@xxxxxxxxxxxxxxxx
Hello,
I need help please, with a formula which calculates the cumulative sum of
a
column of distances in kilometers.
When the cumulative total reaches a celing of 350kms, it must restart the
cumlulative total again.
If any distance is greater than 350kms then it must give the cumulative
total excluding the greater value, and highlight the cell, show the
greater
value in a seperate column and restart the cumulative count again.
My opbjective is to plan a travel route over 5000kms and a scheduled stop
every 350kms for the night. This is to plan where I will be stopping over
to
make the booking in advance.
Thank you for your help.
Max
.
- References:
- Re: Cumulative sum with a ceiling
- From: Dana DeLouis
- Re: Cumulative sum with a ceiling
- Prev by Date: Re: Getting around 'IF"
- Next by Date: Re: Getting around 'IF"
- Previous by thread: Re: Cumulative sum with a ceiling
- Next by thread: Help with a function might be an if
- Index(es):
Relevant Pages
|
