#### How Do I Integrate?

```I have a spreadsheet of about 100 data points of independent variables and
matching values for dependent variables.  I want to integrate the resulting
curve to find the area underneath.  How do I do this?
```
 0
Myles1 (3)
1/18/2006 2:25:02 PM
excel.misc 78881 articles. 5 followers.

2 Replies
527 Views

Similar Articles

[PageSpeed] 47

```Myles,

To calculate the area under a curve, you can use

=SUMPRODUCT(A3:A100-A2:A99,(B3:B100+B2:B99)/2)

Where your x values are in A2:A100, and your Y values are in B2:B100.  This is
an approximate method for finding the area under the curve, summing the area
of the trapezoids defined by pairs of points (and the points along the x
axis).

HTH,
Bernie
MS Excel MVP

"Myles" <Myles@discussions.microsoft.com> wrote in message
news:AB144A4C-CCA8-4251-9A22-F65A4648239C@microsoft.com...
>I have a spreadsheet of about 100 data points of independent variables and
> matching values for dependent variables.  I want to integrate the resulting
> curve to find the area underneath.  How do I do this?

```
 0
Bernie
1/18/2006 2:56:08 PM
```see my Tip&Tricks site for more details

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Myles" <Myles@discussions.microsoft.com> wrote in message
news:AB144A4C-CCA8-4251-9A22-F65A4648239C@microsoft.com...
>I have a spreadsheet of about 100 data points of independent variables and
> matching values for dependent variables.  I want to integrate the
> resulting
> curve to find the area underneath.  How do I do this?

```
 0
bliengme5824 (3040)
1/18/2006 3:09:06 PM

Similar Artilces:

Integration Questions
Where do I go or how do I get the CRM to integrate with Great Plains, I think there is supposed to be an integration tool somewhere, but I cannot find it. There is an integration CD which you will have received if you are a CRM partner or customer "Nathan Tidd" <NTiddSPAM@douglas-associates.com> wrote in message news:0d1a01c3b421\$ec4437c0\$a501280a@phx.gbl... > Where do I go or how do I get the CRM to integrate with > Great Plains, I think there is supposed to be an > integration tool somewhere, but I cannot find it. It is much more than a "Utility", i...

CRM Integration with an other SQL db
I'm looking to bridge Navision on SQL with CRM. Any body got some suggestions on the best way to built that real time link? -- Benoit How "Real Time" do you want it. If you want, you can use PostCallouts to implement this kind of integration (and there is a paper on MSDN on this subject) where you post changes to Accounts, new Orders, etc. from CRM to your Accounts package. For the other direction, bringing Accounts and sales information from the Accounts package into MSCRM then I would look at using a package like Scribe (BizTalk is also an option) to do this on a sch...

Scheduling Integration for Integration Manager
Hi, Does anyone have any step by step procedure or documentation for scheduling integrations for Integration Manager? I hope there is a workable way for not so technical users to use so that I won't need to customize a functionality for this in Dynamics GP. They want to update their price list if possible using integration manager. However, they want it to be scheduled, like for example the manager will create the integrations today, then it will the update (integration), the end of next week without human intervention. Reason being is that updates/integration can run during ...

Integration Transaction Order Issue
We just switched from using Integration Assistant for Excel to Integration Manager 9.0. The integrations are defined the same way for both programs. When the General Journal integrations run they complete without errors/warnings. But when you view the transactions in the batch in Great Plains the transactions are not in the same order as they were in the Excel spreadsheet. They seem to be very random. The total dollar amounts balance and the integration runs successfully but we can't get the transactions to maintain their order from the Excel spreadsheet. We can't use a so...

When integrating or using an address book in Outlook, the display name is automatically appended with the name of the address book the 'look up' found the name in... example: Jonathan Dorfman (ACT!) Is there any way to edit this feature or suppress it? Thanks in advance. Jonathan ------------------------------------------------ ~~ Message posted from http://www.OutlookForum.com/ ~~ View and post usenet messages directly from http://www.OutlookForum.com/ ...

CRM to GP Integration CD Builds
Hi, We are missing our GP to CRM Integration CD and waiting on delivery of a new one. However, we do have the Release Candidate 2 CD dated 3/25/2003. Can anyone tell me if this CD is the same as the RTM CD that went out? I can't remember if there was another build afterwards. Alan ...

Integration Mgr with Excel ODBC
I'm trying to use an Excel workbook (xlsx) as a simple ODBC source. After specifying the path for the source file when I click the Table button IM pauses for a few seconds and then closes. Same thing happens if I try using xls format. This is on GP 10 SP2 with IM 10.00.1134. Any ideas what would be causing this to happen? Changing the spreadsheet to XLS would be a good first step. -- Charles Allen, MVP "irishjamr" wrote: > I'm trying to use an Excel workbook (xlsx) as a simple ODBC source. After > specifying the path for the source file when I click th...

Using a SQL Job to run an unattended Integration with Integration
Is there a way to run an Integration using a sql job instead of using a Windows Scheduled task. I am using SQL Optimizer so I do not need to log into Great Plains first. Lewis: Yes. You would first create a .bat file (DOS program). In this batch file, you move to the Integration Manager folder (optional), then you would use the command line called IMRun.exe located in this folder (IMRun.Exe "IntegrationName" -Refer documentation) . Once you create the batch file, you would call this batch file using a DTS package within SQL EM. Then you would schedule a SQL job to call this D...

Scheduled Integration via Integration Manager
Hi! I in dire need of help and would need to know if there is any way that I can schedule integrations using integration manager. For example, my client would want to update the price list via integration manager. Is there a way for them to just enter a date to run the integration, and if possible a time as well, then it will automatically run the integration at that specified date and time? Any workarounds, ways and step by step procedure on how to achieve that, would be very very great. Thanks! -- Bryan Hipolito The IM user guide covers that in detail. If you don't already ...

CRM Integration 1.2 for Great Plains
The CRM Integration 1.2 for Great Plains seems to only support integration between one Great Plains company databse and an installation of CRM. Does anyone know if it is possible to integrate more than one Great Plains database to a CRM installation using the the standard CRM Integration 1.2 for Great Plains and Biztalk server. CRM <=> GP Integration only supports integraiton to one GP company DB. >-----Original Message----- >The CRM Integration 1.2 for Great Plains seems to only support >integration between one Great Plains company databse and an >installation of CRM....

Re: Integration Manager Error
"6538" <lbeach@remingtonconsulting.com> wrote in message news:... > Running a JE integration and receive the following error. I have checked > the source documents and previewed and all appears fine. > > This integration cannot be run because of the following problem(s): > Source Recordset '1' not round - used for Record Source option on > collection 'Entries' > > ...

Integration DB Size
Our integration database is growing at a very rapid pace (about 200 MB per day) ... compared to the pace that our GP & CRM databases are growing. Is there some way to "shrink" the Integration DB? -- Brandon ================== Presentations Direct - http://www.presentationsdirect.com > Binding Machines http://www.presentationsdirect.com/binding-machines/gbc-binding-machines.asp > Laminators http://www.presentationsdirect.com/laminators/gbc-laminators.asp > Paper Shredders http://www.presentationsdirect.com/paper-shredders/gbc-paper-shredders.asp...

Mas90 integration
I am trying to find out if RMS is compatible with Mas90 (MAS 90 is a 32-bit accounting, distribution and light manufacturing software) If the integration is possible where can i find the steps on how to set it up, or if there is a module for this where can I purchase it from? Thanks, HaikHR@gmail.com Try the Peachtree 3.0 export. It is very close. MAS had and import tool to import the file, as I remember it is and module they offer. Good luck. mt "Haik" <Haik@discussions.microsoft.com> wrote in message news:E5028623-B547-4399-B1B3-1146BD3015B4@microsoft.com... >I ...

Bank Reconciliation Integration Problem #2
We are receiving "No Matching Transaction found for Transaction Number" warning message during a bank reconcilliation integration for the XFR type. Have checked that the transaction number is correct in CM20200, and we can clear the XFR types manually. Is this transaction type not allowed for some reason? Or is there some other reason why we get this warning? Scott Here is the response I got from MBS Developer Support: This has been logged as bug 26212: SUMMARY: When running a bank reconcilation integration if one of the transactions is a bank transfer with a type of XF...

Site integration--Reverse Proxy
Hi, I am working on a project to integrate another site into our site. What happened is like this: 1. I have a iframe with the src referenced to a special folder (SiteIntegration) in our site (original site). 2. I have a HTTPHandler which acting as reverse proxy to make request to the target site and I have the following config in web.config <add verb="*" path="SiteIntegration/*" type="ReverseProxy.ReverseProxy"/> 3. I created a request to the target url in the ReverseProxy-- ProcessRequest sub. (Adding right authentication), and I got r...

Sharepoint Integrate with CRM
Hi all, Does Any one know virtual pc image that had integration sharepoint with crm for demo purpose available for download ? thanks to all in advance ...

web integration
We are looking for a web integration for RMS that support multi level of price for example we have retail customers the has standard price and wholesale customer that has price level A, we want the wholesale customer can log in and check the price on a web catalog Thanks We resell a webstore add-on that alows for customer specific pricing as well as level specific pricing, also with the ability for wholesale customers to produce their own trade price lists. Email me if you need more information rod@rsgplc.com "Norman" wrote: > We are looking for a web integration for ...

Integration Manager only running for some integrations
Setup is GP 10/IM 10 running on Citrix for the clients. I'm the IT person, running GP on my laptop. For some reason, only one of the integrations is not working - the one that updates our chart of accounts. All the other integrations work fine - SOP entry and cash receipts entry. They use IM on a daily basis, mostly for the SOP and cash receipts; the COA is used only rarely. When the client chooses the COA integration, then Run, nothing happens. I tried running the integration myself, and got a "you don't have permissions to these tables" error. So, wha...

Integration Manager Errors During Integration
Hi all, We have just upgraded to version 9 of great plains dynamics and since doing this one of the integrations in integration manager v9 no longer works. I'm getting 2 errors stating: DOC1 Field BatchID does not have a default value DOC2 Field Reference does not have a default value The integration completes its run but ultimately fails. Could nayone please help me to identify where these errors have come from and ideas of any solutions. Many thanks in advance. Grant Sorry. I have found the problem. It seems that the CSV file that was the source had a row with missing fields. T...

Is Entity Framework like an In-memory Integrated DevEnvironment?
I have been experimenting a little bit with Entity Framework, and it seems like it is mimicking an In-memory Integrated development environment similar to Microsoft Access which is a "Not" In-memory Integrated development environment. So it appears to me that Entity Framework offers the ease of an Integrated Dev Evironment with all the functionality of .Net -- except in memory. Is this a reasonable view? Or am I missing anything abut the point of the Entity Framework? Rich *** Sent via Developersdex http://www.developersdex.com *** Rich P wrote: > I have been...

Payroll Integration TTGDS Error
We set up a new payroll transaction integration. I can preview the file and all the data looks good. When we run the integration, we get this error: The destination could not be initialized due to the following problem: TTGDS Errors: TTGDS_ITEMALREADYEXISTS Does anyone know what this means? ...

Integration Manager delete integration
Is there any way to delete integrations? -- Patti Patti, In IM, click on the Object button on the toolbar. Under Types, select the Integrations folder. Highlight the integration you are interested in deleting under the Objects pane. Click on the Delete button. Best regards, -- MG.- Mariano Gomez, MIS, MCP, PMP Maximum Global Business, LLC http://www.maximumglobalbusiness.com The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com "Patti Foo" wrote: > Is there any way to delete integrations? > -- > Patti ...

SDK integration in VS2005
In my MFC application I have resources in german as default and in english, all included in the .exe. Whenever the program runs under a german version of the OS it appears in german if it runs on any other language it should come up in english. I'm using this code: #ifdef FORCE_ENGLISH_US lcidUser = MAKELCID(MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US), SORT_DEFAULT); #else lcidUser = GetUserDefaultLCID(); #endif LANGID langid = LANGIDFROMLCID(lcidUser); if (PRIMARYLANGID(langid) != LANG_GERMAN) { LCID lcidUsEnglish = MAKELCID(MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US), SOR...

VERY Slow Integration
I have been reading about how slow IM seems to be. It seems to me however that my integration is beyond the scope of slow. I have an Integration that pulls info from various fields from 2 tables. I have these mapped and created a query relationship. However, when I run the integration its taking 15 plus minutes per document. Surley there is something I am doing wrong or have misconfigured. The source database is SQL 2000 while the destination is on SQL 2005 connection is on a T1. I am using version 8.0 of IM Any ideas on where to start to find the problem. I have exhausted every thing...

payables integration
We are using GP 10.0 and have set up the payables inegration for our payroll taxes and benfits. I am having a issue trying to split out the fed wh and fica taxes. Right now we have them all going to one vendor and I would like to be able to have the fed wh go to one vendor and the fica to another so that we can relieve the correct payables without having to manually go into the ap batch and change each ap voucher. I have tried using the payables intergration but it will not let me set up the fica code with a different vendor and if I use a different vendor it wants me to assign an e...