Best fit data from a best fit curve?
MS Excel 2003. I have followed the instructions to apply best fit curve to
my raw data points. I have a best fit curve that I am happy with, and I now
need to extract the corresponding actual best fit data from the curve for use
in other software applications. Does someone know how?
See Bernard's page, which also includes a link to Tushar's page.
> MS Excel 2003. I have followed the instructions to apply best fit curve to
> my raw data points. I have a best fit curve that I am happy w...Question Ragarding migration
Having some issues with migration from 5.5 to 2000. Have 2000 exchange
server setup in a different org than that of the 5.5.
Both in DNS with mx records and priority 10
Have ADC installed and 2 way connection agreement between the 2 - constant
replication. Can migrate the mailbox over to the 2000 server no problem with
the migration wizard. However, first issue is that after the migration has
completed, the mailbox is left in place on the 5.5 server. I thought it
would delete it
Second issue is that if I leave the mailbox intact, it receives mail on the
5.5 server. If I delete i...MDA to AA data migration
Has anyone successfully migrated MDA data to AA? We want to implement AA but
are waiting for AA support from a 3rd party (AIT from mc2). We are
considering implementing MDA for the short-term, then migrating to AA once
it's supported by AIT.
Currently working on a tool to do so, if you are interested in talking about
it please contact me.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
"Mike Muscarella" wrote:
> Has anyone successfully migrated MDA data to AA? We want to implement AA but
> are waiting fo...Deleting rows containing common data
I have an Excel 2000 spreadsheet with 30,000 rows. The rows look like this:
How do I delete the rows containing "total"
1. Select the range and apply an AutoFilter (Data > Filter
2. On the drop-down list, select "Total".
3. Select the range again if needed.
5. Press F5 > Special and click "Visible Cells Only."
6. Remove...Import and Export problem
Unfortunately, it became necessary to re-install windows XP due to a problem
with a video driver. Before the re-install, I backed up all outlook files
by doing an export to a CD and saving all contacts, e-mail folders and
calendar to a .pst file. The CD tells me the file is there and they have
data in them, but I can not get outlook to import the files back from the
CD. I have tried to open the .pst files directly from the CD, specifying
outlook at the program, but this will not work. Hopefully, someone will
know how to recover my .pst data files as this is the only back-up I have.
...Import raw MIME messages
Hi, Is there a way, or utililty, to import raw MIME messages into Outlook
2003 or Outlook Express? I would like to preserve the base64 encoded
attachments, too. I have searched Usenet newsgroups with Google Groups, and
I have searched SlipStick.com. I just cannot finding anything, but I cannot
believe there is not an existing solution.
You might want to try Redemption http://www.dimastr.com/redemption/ (will
require the ability to write code on your part).
"Lee C." <noSpam@hotmail.com> wrote in message
> Hi, Is...Lowest value in a selection of data
What formula would I use to find the lowest value in a selection of
data i.e. B49:E52.
Gary''s Student - gsnu2007a
Jumping in here...
Is it possible to know the address of the cell containing the minimum
You can use the MATCH function to locate the (relative) position, but
if you have more than one value which are minima then it will only
find the first.
On Nov 16, 7:23 pm, John Google <JohnGoo...@hotmail.co.uk> wrote:
> Jumping in here...
> Is it possible to know the address of the cell containin...Migrating AD to new domain. How does Exch 5.5 fit in?
Over a weekend (hopefully) I will be migrating from one domain to
another temporary domain. Then I will be taking the original domain
out of it's current forest and into its own. I will then migrate back
to the original domain.
I'm using Exchange 5.5. What do I do with Exchange? Should I leave
it with the original domain and assume that the appended SIDHistory of
the users will still work correctly with it when they move back? I'm
thinking this will work since it's happening over a weekend...
I don't know anything about migrating Exchange 5.5 to a new domain...
Any ...connecting to data access page with filter criteria
I have an access database that I connect to from a GIS application (ArcView)
using VBscript. I need to port my GIS project to the free viewer (ArcReader)
which does not support VBscript but does support hyperlinking to a URL based
on a value supplied by an underlying record.
In my current project I can send filter critera to open a particular
database, form and record. Would it be possible to do the same using data
access pages or would I need to create a separate page for each record I want
...Regarding data needed for regular meetings
Hello. I have a project that must be finished in Q4 in order to garner
revenue for the year. To that end, I'm enforcing daily (1/2 hour) and weekly
meetings. I'm trying to figure out what views are appropriate for which
meeting. Perhaps in the daily meeting a view filtered to show the week's
activities. Then in the weekly meeting, what, maybe a report showing
activities for the month along with risks and issues? Anybody have real-world
expertise they can apply to this? Thanks in advance.
...Do Pivot Tables have an automatic data range expansion?
As I add new rows of data to my data base, my pivot table will not expand to
include them after refreshing. Is there any way of setting the pivot table
to include the entire database regardless of its continuously growing size?
Right now, as I add a new row of data I must delete my old Pivot table and
create a new one from scratch. Is this normal?
You can use a dynamic range that grows/contracts with your data.
Debra Dalgleish explains it all at:
> As I add new rows of data to my data base, my pivot table wil...How do I reduce the number of data points I have??
I have some 10000 data points from which I need to reduce to something like
100 points before making an xy chart. Typically I would like to make a chart
of every 10th point. So basically I need to reduce the length of my two
rows. Is there any way I can do this easily??
Any help is highly appreciated. Thanks in advance
From the Microsoft Charting FAQ:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
ssan...Activated Outlook and lost all data on Outlook Express
When I downloaded Windows XP Patch 2 it included Outlook. I installed the
patch and activated Outlook. My old Outlook Express disappeared, along with
a lot of files that I hadn't read/responded to/saved. Is Outlook Express
still somewhere in my computer system? How do I access it to review and save
some of the files that were there?
If you use outlook 2003,
try to import data from outlook express to outlook 2003.
from menu of oulook 2003,
file > import & export > import internet mail and addresses > Outlook Express 4.x, 5.x, 6.x
"TeacherGuy"...Extract Data from curupted Access 2000 Database
any sugestion on how to Extract Data from curupted Access
2000 Database ???
the Error i get when attempting to Open
The microsoft jet database engine stoped the process
becouse you and another user are attempting to change the
On Tue, 1 Jun 2004 10:34:58 -0700, "Levon"
>any sugestion on how to Extract Data from curupted Access
>2000 Database ???
>the Error i get when attempting to Open
>The microsoft jet database engine s...Is there a way to Sort Data by font color or cell shading?
I have a long list of items that I sort by either item number or date
depending on what I'm looking for. From time to time these items status will
change and I will gray them out by just shading the background of the cell
Is there a way I can sort these items by the background/shading of the cell
first and then the secondary sort be date?
So all the cells which contain gray shading will be first in the list
(sorted by date if possible) then the rest of the list without the gray
shading will follow by date as well.
Take a look at this link:
http://www.cpearson.c...Importing Vendor/Supplier Items
Is anybody successfully importing their supplier/vendor purchase order items
into RMS SO 2.0?
We would like to import all the item information from a PO that we have
ordered on a vendors web site or spreadsheet (including item descriptions,
UPC codes (and set these as our ILCs) pricing etc), so we don't have to
manually enter this.
I can see a lot of potential problems (existing items versus new items,
existing cost versus new cost, different layouts for different suppliers) so
any feed back would be appreciated.
Is anybody using any add-on modules to accomplish this? If so how do...Ms access data type detail
I am using Ms access 2007, can anyone explain to me all the DATA TYPES,
like what are their limitations etc.
Also how can i create a drop down list and allows selecting more than 1
e.g ... in my db i have an option for
known languages and the answers could be more than one. English,
French, Spanish etc
> I am using Ms access 2007, can anyone explain to me all the DATA TYPES,
> like what are their limitations etc.
> Also how can i create a drop down list and al...When Must Lotus be imported To Lotus Before/After
This question is complicated, but one that I will need to
do very shortly. I currently have an operating system of
Windows 98, and I am wishing to upgrade to Windows XP,
Home Edition. Now the complicating part, on Windows 98, I
have Lotus SmartSuite 9.0 and the end result is that I
wish to have Excel on Windows XP. Must I install a Excel
version onto Windows 98 and import my Lotus Files into it,
before upgrading, or must this all be done after
upgrading? I have a second question as well, and that is
must I get Lotus SmartSuite 9.8 which is compatible with
Windows XP in order to s...missing data--again!
A GP 8.0 client on SQL 2000 (8.00.2039) has reported--for the second time
since late last August--that their unposted journal entry data keeps
Fortunately, I have had a backup that I can successfully restore. Also, I
ran DBCC CHECKDB and Check Links in general, plus SQL is automatically
performing this maintenance weekly every Sunday AM. No errors are reported.
They have had, over the last year, one or two network issues pop up. But, I
am having difficulty telling them for the second time to chalk it up to a
Again, it is only their un...sort data
i am trying, unsuccessfullty, to sort some data (a small example is below) so
I can graph it. I want to put it into a pivot table format but don't want
calculations, just the actual data. any ideas??/
Location DATE Result
WAT002WA ALBANY BOTTOM 19-Jul-05 0.83
WAT002WA ALBANY BOTTOM 23-Jun-05 0.8
WAT002WA ALBANY BOTTOM 28-May-05 1.16
WAT002WA ALBANY BOTTOM 02-May-05 0.93
WAT002WA ALBANY BOTTOM 06-Apr-05 0.66
WAT002WA ALBANY BOTTOM 11-Mar-05 0.59
WAT002WA ALBANY BOTTOM 13-Feb-05 0.54
WAT002WA ALBANY BOTTOM 18-Jan-05 0.62
WAT002WA ALBANY TOP 09-Mar-07 0.73
...Sending graphic data to another computer2
Thank you for your reply...
But I don't want to create a file,
Just to send data and then show them in the server app.
> this code captures the screen and writes it to a jpg, writing to a file
> take long, you should look into something that changes the bitmap into a
> in memory, perhapse even lets you play with the DPI (quality) to reduce
> size of the jpg.
Like i said, my example creates a file, but you SHOULD NOT CREATE A FILE,
you should simply convert the Bitmap to a JPG in memory so that it does not
take too much memory. The bigger the image the longer it...Archiving Dynamics GP MFG Data
Has anyone ever archived any of their Dynamics GP MFG Data? We need to
do this but can't find any information on the best way to do so. Our
data volume has grown over the years and queries are taking a
performance hit as a result.
In our test environment I found a 300% increase in efficiency when
posting MO Receipts after deleting the data in the MOP1027 table, in
which we had over 4 million records. I posted previously about MO
Receipt posting being slower after upgrading and found that SQL 2k sp4
returns the following error found in the DEXSQL.log often when trying
to perform inserts...Exporting e-mail to a data file
I've tried a couple of varieties (Access, CSV) with similar results. Neither
option includes the "Received" field.
Why is that? How do I include the "Received" field in the exported file?
If you use Access to set up a linked table connected to your mail =
folder, you will see the Received date among the available properties. =
Third-party export tools are also available; see =
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olco...Input text message (dialog box) for data validation
This may sound idiotic to some, but I've already been wasting too much
time with this option, and am looking for some guru insight. I am
trying to input text into the Data Validation Text Box that looks
something like this:
Q3) Was this a prospective or retrospective analysis or study
documenting the effects of XYZ that compared and reported the data in
the Marketing Strategy Program?
c) This appears to be a concise comparison, but ot...Macro: Find matching DATA, copy correspondently values into another list
Okey guys - please advise me on this.
(There was unfortunately no quick response to my latest problem - and
I begun to swim...
However - that brought me out on deep VBA-water...again - and now need
a life buoy (metaphorical spoken)).
The core of my macro problem is to look for all the values in column A
(Range A5:A??) in Sheet "BOARD" (not bored!!!) that match values in
another list placed in column A in sheet "LIST".
When finding the match I will copy correspondent celle.value in column
D / sheet "BOARD" into column B in sheet "LIST" - this w...