Trendline Function Extraction
Yet another forecasting question.....
If given dates and amount of items received you can easily plot the data and
have Excel produce a fitting formula that's linear, polynomial, logorithmic,
I am working with different types of data, some linear (which is easy) some
cyclical. For the cyclical data I would like to use either a 3rd or 4th
degree polynomial to approximate the upcoming volume. Again, Excel will plot
the points and give you a formula, but you can't use it to forecast anything.
I thought of using a linear algebra approach and using this formula:
a1=INDEX(LIN...Add trendline to PivotChart
Hello, can anyone tell me how to add a trendline to a
pivot chart? No matter what I try I cannot add a
trendline. I've tried clicking on a data series, right
click then select add trend line but this option is
greyed out I have also tried using the chart menu. This
is realy getting on my nerves well only because I don't
know how to do it but I can do it when the chart is not
attached to a pivot table...Why?
Pivot charts do not have all the flexibility of a regular chart. While
it's inconvenient, it's also necessary to ensure the integrity of the
links to the...Trendlines to ignore empty cells
I have five years of data and the x axis is set for 6 years to allow the
chart to fill up as new data is input. When I add a trendline it seems to
include these empty cells. In fact, the cells contain a formula but have
managed to get the data plot to not be zero by using the NA() function which
I found in another thread. Any ideas how I can get the trendline to only use
the actual data for its calc rather than plotting along the whole of the x
Much appreciate your advice
This example will allow you to have a dynamic linear trend line that
recalculates and moves with the...Set up an automate update on my database
I have a database in Access to update every morning by hitting the update
button. Is there anyway I can set up a clock in the databse and set up an
automated update in a specific time. I mean, I would like to get the code to
set up a specific time and the form has to update by itself on that time.
Any help, really appreciated.
...sum doesn't update total without double-click of cell
In a spreadsheet, using formula like "A1 + B1" to get the
sum of values in cells A1 and B1 to show in a third cell.
The total in the third cell does not update automatically
after changing the value in one of the two cells (e.g., A1).
Only after double-clicking the third cell, is the proper total
Any ideas why this is happening?
Set your calculations to automatic under tools>options>calculations
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"David E. Gross" <David E. Gro...Can I update?
Operating System: Mac OS X 10.5 (Leopard)
Sorry if this question has already been answered:
Can I update Office v.X on my new MacBook? How do I go about it, and which is the latest version available to me?
Many thanks in advance,
Hi Chris -
You can still obtain the 10.1.9 update for Office X here:
However, this is the last update for that version and Office X is no longer
supported by MS. Also, I've no experience with the combination myself, but
I've seen a number of issues concerning it in...OL2000 getting rid of "MS Update mail"
I have started making a filter using information from the header
right click message | options, read 'return path address' and putting
the domain only in the filter in 'specific words in message header.
Works great, these go to permanent delete and gets around the fact
OL2000 wont look inside htlm messages.
Is there a way to make a list of these offending domains rather than
making individual rules? The junk rule list won't send to permanent and
using the suspected junk setting requires I reset it every time I add to
the junk list.
does it work...Updating notebook
When I wish to update my notebook from my desktop, can I just overwrite
Outlook.pst in my notebook with that from my desktop?
"Bruce" <Bruce@discussions.microsoft.com> wrote in message
> When I wish to update my notebook from my desktop, can I just overwrite
> Outlook.pst in my notebook with that from my desktop?
Only if you want to corrupt your mail profile. See this for other ideas:
Brian Tillman [MVP-Outlook]
I am having difficulty graphing a linear equation in two variables by using three ordered pair
1/2 y = 2x +
My ordered pair
x 0 1
y 2 6 10 see as follow
I am unable to graph this problem and need help!!!
Just select the range containing the ordered pairs and Insert|Chart.
Angela Mitchell wrote:
> I am having difficulty graphing a linear equation in two variables by using three ordered pairs
> 1/2 y = 2x + 1
> My ordered pairs
> x 0 1 2
> y 2 6 10 see as follows
> x y
> (0, 2)
>...CRM update 1.1
Is it supposed to come out in December?
Does anyone know if it will incorporate any customer self service such as
Is there a list of features/enhancements to be included in the release?
update 1.1? I havn't heard about that.........where did you hear about that?
Lord knows this CRM package is in dire needs of a massive service pack, and
if indeed its coming in december, will..........great, only took a year. I
too would like to see what features/enhancements it is attempting to
"John Olinger" <email@example.com> wrote in messa...Text box that updates a control IF it is EMPTY or Has Text
I have created a red and green radio button. For a quick visual look, I want
to be able to look at the form, which has multiple text boxes, to see if all
the information has been entered. If the text box is empty, the red radio
button is visible from the start. If the text box has the required info.,
the radio button (initial visibility set to false), becomes visible on the
form next to my text box. So, as the information is entered into the text
boxes, the red radio buttons change to green, indicating completed. In the
form current event I'm using
Private Sub Form_Current()
...cannot install Office 2001 Combo update 9,0,4
When I try to launch it on my G4, the Classic Environment is
Then I get the following message:
"The default location for this install cannot be found.This install
will be cancelled."
I have no trouble with other installs.
It sounds like you may have put your Office 2001 installation in a place
other than the default location and the updater can't find it. Is that
All responses should be made to this newsgroup within the same thread.
About Microsoft MVPs:
Search for help with the free Googl...Windows Update error 80070005
I have error 80070005 in windows update
Please always state what OS you're & service pack and what
version of Internet Explorer? as it often does make a difference -
Also, could you supply some information on what your firewall is, anti-virus,
other R-TP programs, e.g. Spybot Search & Destroy (reduced functionality
called "TeaTimer") Avira (From version 9) (Included in antivirus package),
Which update(s) ?
> I have error 80070005 in windows update
&...Update Primary Supplier
Is it possible to prevent HQ from changing Primary Supplier at the store
level? We have stores in multiple markets and they order the same SKU's but
from different vendors. Whenever I issue a WS250 to update item information,
there is always the risk that it will change the primary supplier at the
store and often times, I don't want it to.
I've worked around this problem temporarily using a custom table and DTS
jobs, but is there a way to prevent WS250 from even changing Item.SupplierID ?
No need to do anything, at the HQ level set the form level secruity and
disabl...how to update an XML table
Thanks in advance for any help... I have an .aspx file that I need to
update a list of email addresses to receive my newsletter (doesn't
have to be XML, an SQLserver table would work too I guess... are there
any advantages to either). OK I have a textbox that the user types in
their email address and a button to Submit it... then I want that
email address submitted to go into my file... of course the file would
reside on the hosting server in the same folder as the .aspx (?).
Thanks for any clues on how to code this!
> Thanks in advance for any help... I have an .as...Trendline error #2
Has anyone else found an error in the trendline tool in excel 07? I found
that when transforming the x axis to logarithmic, the trendline stays linear,
when it should curve with the axis. I think this started happening when I
moved between 07 and 03 using the compatibility package.
Ann Arbor, MI
Yes this appears to be a bug!
"R Lawson" wrote:
> Has anyone else found an error in the trendline tool in excel 07? I found
> that when transforming the x axis to logarithmic, the trendline stays linear,
> when it should c...Update links prompt not wanted
I am posting a few files sayb File A and File B (Excel 2003) on a network
drive. These files are password protected and are linked to each other where
File A is the source file for File B. To suppress the prompt to update when I
open File B, I went into Tools-Options-Edit and unchecked the 'Ask to update
automatic links'. This has stopped prompting me for updating all files
including these 2 files but I understand this is good only for my computer.I
would also like all users of these files on the network not to be prompted
for updating but that they open automatically File B wit...I would Like to Receive the Windows Update Services for my Account
Thanks for your service... I would like to receive the Windows Updates for
unt at any time; please, take note about it.
> Thanks for your service... I would like to receive the Windows
> Updates for this acco
> unt at any time; please, take note about it.
I have taken note. Many others that are your peers likely will as well.
However - I would bet the question would be, "Why should we care?"
This is a peer-to-peer newsgroup - a foru...Excell doesn't auto update cells anymore
My Excel 2007 has stopped auto updating formula cells when one of the input
cells are changed. It will only update the value if i mark the cell and
press enter, or save the file.
How do I make it auto update again?
Formulas tab, Calculation Options, check Automatic
Microsoft MVP - Excel
"Martin Schou" <firstname.lastname@example.org> wrote in message news:email@example.com...
| Hello NG
| My Excel 2007 has stopped auto updating formula cells when one of the input
| cells are changed. It will only...Update attribute using ldp
I have written an ldf script which creates few custom attributes and an
auxilliary class which contains these custom attributes.
Also this auxilliary class is part of Users and OrganizationalUnit
Now I want to update the values to the custom attributes.
How do I do it using ldp?
I can set values for the inbuilt attrbutes without any issues, however
when I try to set the values for the custom attributes I get below
Error 0x20B5 The name reference is invalid.
it takes me about 20 goes to update my share portfolio,
the internet is connected and can open other web sites,
be it does not connect to Money for share update??
...recipient update service #5
When itry and create abother recipient update service on my 2003 sp1 server
i cant, i get an error ("invalid argument") also when i go to the properties
of my existing recipient update services for enterprise and domain I do not
see the properties, all is see is the general, object and security tabs. I
have two exchange 2003 servers that srte in the same admin and routing group,
I get the same issue on the second server.
Would running domain prep or forest prep help resolve this issue?
Why do you need to create a new Recipient Update Service?
The...Trouble with updateing Outlook
I am trying to do an update to my Outlook 2002. It appears
that I have all the updates except for one titled
"Outlook 2000 calibration data objects (CDO). Update
I assume that I am getting this because my 2002 install
was an update from 2000.
When I attempt to download this CDO, I get the following
message: This machine does not have the microsoft outlook
email security update installed. Please install the
outlook email security update before running the CDO 1.21
email securiy update.
I can not seem to find the update that this message
referrs to. Wha...Update Link
I have got a problem of Excel update link after upgrade to Office 2003.
I have create 5 excel files which is linked togather. In the 1st one, it
contains raw data, and each of the other make use of the result of the
1 --> 2 --> 3 --> 4 --> 5
When I open the 5th file, it ask me to update link, form the background I
can still see the values, however no matter I choose "update" or "do not
update" the value turns into error. I have to open the 4th and 3rd file in
order to give my value back. This does not happen when I open the fil...Trendlines in graphs
Hi all! I have an interesting question. I am ploting a
graph where the X axis is by months and the Y axis is the
number of parts produced. Some months we do not produce
any parts; therefore, the Y axis is "0" at that time.
When I put a trend line on the chart, it sees the "0" as a
computable data point. A line is then generated but is
off from the true trend. The true trend can be generated
if I remove all the non producing months. Is there a way
to specify specific groups of cells in a column that you
want to use in a trendline analysis--sort of hop scotch ...