Calculating The Radius Of A Curve

Feb 19, 2009

I am trying to find a formula to calculate the total size from a to b with the curve being in cluded in the total.

ADVERTISEMENT

Derive Curve From Values Then Apply Curve To Another Dataset?

Jun 5, 2014

I have a data set (Set#1) that consists of a positional rank (1-240) and a dollar value ($46-$1) for each positional rank. It's not a straight line set.

DataSet.JPG

What I need to do is take that curve and apply it to another data set (Set#2) (1-240) and assign a dollar value ($46-$1) to each positional rank.

A "corner cutting" way of doing it would be an Index/Match to simply carry over the dollar value from (for example) #45 from my Set#1 to #45 in my Set#2. This could work reasonably well with data sets of the same size, but mine aren't always the same size, so I need to apply the curve itself. I

View 1 Replies View Related

Calculate Facets Lengths And Radius

Dec 2, 2008

I have used ROW function to determine the facets lengths and the number of internal angles and also the radius's
the offset figure is the distance the track or pole is set from the frame this can be adjustable by us or the end user

the radius measurement is a minimum and a maximum that the aluminium can be bent, will probably
be set parametrs to work with

Now bay widows come in all sorts of shapes and sizes
90 degree angle bays
2 bend bays
3 bend bays this is why I am using the row function, once the measurments are entered can excel generate

View 12 Replies View Related

Find Latitude And Longitude Within Radius And Within Given Slope And Return Number?

Feb 25, 2014

I have more than 1000000 coordinates with heights to sort through. The aim is to be able to give a specific radius and check all coordinates within this radius if the slope is more than a maximum slope. If this is the case it need to put the value (in this case) 100 in a new column. The reason for this is we have a reasonable flat terrain but the entire area is filled with Anthills. I need to sort the data. Normal ground points (No Anthills) should be labelled/coded as 200 and anthills as 100. This will allow my program to know the difference between the ground and anthills. In the tab "Input Sheet" I have a small portion of co-ordinates starting from row 8 to row 53 (this will have to extend all the way down to the last row in excel). I need to copy each row starting with row 8 (C8:E8) and paste it in row 2 (C2:E2). Column H indicates if the points are forming an anthill and the code needs to change. I have my final answer in the tab "Final Answer" that I require for my program. Is there any way I can write a VBA code that will check all the point instead of doing it manually.

View 4 Replies View Related

Formula For S Shape Curve?

Dec 13, 2013

I have a few dates and one Total value. I need to distribute this Total Value in such a way so I can get the same shape S curve (Date vs Value).

View 4 Replies View Related

Price Curve Formula

Apr 9, 2009

I'm trying Calculate Curved Price Rate by SF. phil.freestyle@gmail.com

View 5 Replies View Related

How Do I Calculate A Polynomial Curve Fit

Sep 7, 2009

For Excel 2007 -

I am looking for a function [or method] to calculate a polynomial curve fit. I can do it on a graph with the existing graph and chart tools, but I need to calculate it myself. Does such software exist somewhere in my Excel 2007 package, or can anyone recommend a freeware program? I am hesitant to download an unknown, un-recommended add-in.

View 14 Replies View Related

Calculate Area Under The Curve

Apr 13, 2008

i am getting some data via RS 232 port and plotting it straight to excel, which comes out to be in forms of waves you can say sine waves, now i need to calculate area under the curve, say like if i highlight some area it will automatically calculate the area, or if i select two points on the curve it will calculate the area. please help me out i am really stuck at this part.

View 9 Replies View Related

Apply A Curve To A Column

Jan 28, 2009

I'd like to apply a curve to a column of student exam grades and have the curved grades displayed in the adjacent column. Here is how I'd like to curve:

I like to make a linear function out of two coordinate pairs.

First Pair (x1,y1) = (Highest Exam Grade, 99) = (H,99)

Second Pair (x2,y2) = (Class Exam Average, Desired Exam Average) =(C,D)

Slope = (99-D)/(H-C) = m

Linear Function = Y-y = m(X-x) = Y-99=m(X-H)

Each student grade would = "Y" i.e. Y=m(X-H)+99

View 9 Replies View Related

Find Max In Xy Chart Curve Fit

Apr 13, 2006

How I can find a max in an xy chart curve fit?

View 9 Replies View Related

Create Growth Curve

Aug 28, 2007

Does anyone know of a statistical formula that would create a normal growth curve?

For example. Let's assume that I want to forcast growth from January through December. I know that in January I will have 100 units. In December, I will have 1,000 units. Is there a formula to predict the the units in Feb-Nov (using a normal growth curve)?

View 3 Replies View Related

Calculate Best Fit Equation Of Curve

May 16, 2008

I am trying to calculate the equation of a curve which best fits some data. On the x-axis is date and y-axis the readings. The curve is quadratic, so on the chart I am fitting a 2nd order polyomial and displaying the equation. To prove that the equation the trendline gives me is reasonable, I am applying the equation on the x parameter to get the y parameter estimate and looking to see the error between predicted and actual - see attached.

The equation and the output from it are clearly rubbish, even though on the graph the trendline is a reasonable fit - see attached. Has anyone any ideas why? I think it has something to do with using a date on the x-axis but no idea why. Is there a way to correct for this? I also tried using the following I to calculate the coefficients which came up with a reasonable forecast (although linest should only be used for linear data): =LINEST(C3:C15,B3:B15^{1,2,3})

View 2 Replies View Related

Create S Curve Based On Dates

Apr 4, 2014

I am working on Project Planning, I need to create the Progress curve for our Project based on Weight Factor every month.

I need to create the Plan and actual curve based on the dates defined in particular activities. Once the activity progress is calculated every month based on cut off date then it will sum product with corresponding WF to get the progress achieved every month. Presently I am calculating the values every month and pasting the values in Chart data every month. I had created the S Curve and attached here.

Now my objective is to automatically calculate the values for the entire cut off date at one time (From Project Start to End). i.e I don't want to do any manual work in the Chart. I will update only the actual Dates in the file, then the curves need to get automatically updated.

1) I don't want to calculate the progress for individual activities, I would like to calculate the overall progress directly.

2) When I change the Cut off date, then the previous values needs to become static.

View 1 Replies View Related

Formula To Distribute A Value Along A Bell Curve.

Nov 19, 2008

I'm trying to find a formula that would spread out a value amongst multiple cells along a bell curve. Say I have $x,xxx. I want to spread that amount out in a certain proportion, regardless of how many cells I'm spreading it throughout.

Say I have a $10,000 project. I want to be able to spread it out like a bell curve in the cells I choose. For instance, if it was a five month project it would be distributed as

January - $1,000
February - $2,500
March - $3,000
April - $2,500
May - $1,000

If I added another month it would change to
January - $833.33
February - $1,666.66
March - $2,500.00
April - $2,500.00
May - $1,666.66
June - $833.33

I already thought of manually adding percentages to each cell, but the formula needs to be dynamic.

View 5 Replies View Related

Drawing Tangent Line On Curve?

Mar 8, 2014

Can we draw tangent to a curve in excel graphs..? If yes if i could have some demo....** this.. I am working on finding rate ** change at an instantaneous point and average rate ** change ie: secant line

View 1 Replies View Related

Excel Split A Curve And Fit Trendline Using VBA

Feb 2, 2014

I need to solve about 450 excel sheets for my project.

The spreadsheet has X and Y data and curve is plotted. I need to split the curves into 3 parts based on slope change.

I can do it manually but I need an excel Macro which does this work.

A sample is attached : Excel forum-Lab data.xlsx‎

View 14 Replies View Related

Given Points On Curve, Solve For Equation

Feb 25, 2009

Is it possible in excel to find the equation for a curve?

I have 6 known x,y data points on a curve. I need to find the equation for the curve.

View 4 Replies View Related

Use Excel To Plot Growth Curve?

Mar 15, 2012

I would like to use excel to plot a growth curve. I would like it to plot the points that correlate to my data without connecting them by a line. I would then like to give excel a formula and have it plot that line on the graph.

View 9 Replies View Related

Graph Bell Curve Chart

Jul 14, 2014

I'm trying to graph a bell curve chart using the following data

Hotels per state
Total

AK
4

NH
5

[Code] ......

As you can see I have states and the number of hotels per state what I need not for statistical purposes but more for "pretyness" is to sort this data in a way that what you get is a somewhat of a bell shape curve graph.

View 2 Replies View Related

Excel 2010 :: Creating Bell Curve?

Jul 29, 2014

I want to create a bell curve for my team's annual appraisal. There are 12 people in my team. The scale is 1-5, where normally rating range from 2.9 to 4.0.

View 1 Replies View Related

Display Mean And Confidence Intervals On Bell Curve

Nov 26, 2013

I've managed to figure out how to normalize my data and create several bell curves. However, these charts do not display the mean, std deviation, or confidence intervals. Any way to add these into my charts?

View 7 Replies View Related

Put Together A Cancel Curve On An Annual Membership Model

Nov 15, 2009

What would be the best way to put together a cancel curve on an annual membership model?

View 5 Replies View Related

Histogram Plot With Normal Curve Overlay

Aug 28, 2002

I would like to create a histogram from experimental data with the normal distribution curve overlaying the histogram.

View 7 Replies View Related

Generating Normal Curve From Statistical Values?

May 14, 2013

Is there a way to generate a normal curve from just the statistical values (mean, std dev, etc)? I used the NORMDIST function but have to manually do the x values and it generates what I would descirbe as a "sample" curve. I would like to make one based on user input.

View 5 Replies View Related

Excel 2013 :: Plotting Gaussian Curve Over Bar Chart

Apr 14, 2014

I'm trying to overlay a Gaussian distribution on some data. The data is a frequency of particle size diameters, ranging from 200-1000 um (see attached). I'm using Excel 2013.

View 1 Replies View Related

Creating Curve With Multiple Values Already In Excel Spreadsheet?

Jul 11, 2013

Here's the spreadsheet I am talking about : [URL]

So as you can see each row = one day divided in 2 cycles of 12 hours : every 12 hours the cat gets a new injection of insulin (the columns "U" being the number of units of insulin the cat receives)

Now I want to turn this sheet into two different curves that would look like these : [URL]

As you can see the first graph shows data based on days (x) and insulin dose (y), while the second curves shows data based on days (x), and blood glucose values (y). This is basically the only way we could clearly see how the cat's disease is evolving over a long period of time.

If he had just started to take all these values from his cat I guess it would be simple to do, but since he already has a lot of data entered in his spreadsheet, I was wondering if I could use this data (and not write each number in a new document), to make things a little more simple and to avoid mistakes.

View 9 Replies View Related

Calculate Maximum Point On Curve From Xy Scatter Graph

Jan 18, 2008

I have put my values into a XY scatter graph but need to find the maximum point i.e when the gradient is zero. I am using visual basic to obtain my data and draw my graph.

View 7 Replies View Related

Calculating % GP Anyone

Nov 4, 2009

im running a new bar in Leeds and im trying to create a spreadsheet which will tell me how much to charge per drink to gain a 80% GP on products, ive got as far as listing the products and prices and calculating how much every measure (25ml) will cost. In the past ive used formulas where I can input the price i charge and it will calculate the GP (=SUM(D10/E10)*100-100) for example but id like to be able to type in the GP I want and for it to tell me the price i need, im not sure if tis possible but it will be a massive time saver.

View 9 Replies View Related

Calculating TAT

Mar 17, 2009

I have some activities that needs to be done ina specified time

Like for example

TAT HRShrsACT 14ACT 28ACT 324ACT 42ACT 54

And i have a sheet where in i need to calculate turn around time

ActivityStart timeEnd timeTATACT 1ACT 2ACT 3ACT 4ACT 5


Based on time entered in start time and end time the TAT column should calculate the TAT based on the above standards.

I also would liuke to exclude weekends(Saturday, sunday). Also the TAT should only be calculated during working hrs between 7:30 PM to 4:30 AM.

View 9 Replies View Related

Calculating Cost Per Second

Oct 25, 2007

I'm trying to make a worksheet where I can calculate the cost of a mobile postpaid subscription. It is charged per minute and the cost differs depending on which of the 2 available networks the customer is calling to. The first 20 minutes are free, not depending on network.

Edit:
Charges to network A is 1,79,- per minute after the first 20 minutes are spent.
Charges to network B is 2,29,- per minute after the first 20 minutes are spent.

To sum up:
1. The customer makes a call.
2. If there there are available free minutes, these should be spent first.
3. The customer is charged per minute, depending on network called.

View 14 Replies View Related

Calculating The Ballots That Come In

Mar 1, 2008

I am on an auto show board and want to come up with a way of calculating the ballots that come in, using excel. Ballot points are accrued as follows: 5 points for 1st place, 3 points for 2nd place, 1 point for 3rd place. With about 25 different categories (classes) and I am estimating participants at around 100.where I can in the automotive field knowing there is nothing besides personal gain.

View 12 Replies View Related

Cells Not Calculating?

Nov 9, 2008

I am having a problem with some of the cells in a spreadsheet not calculating.

For example, in column A, all the cells have formulas that pull data from another sheet. When I enter the formula, only the formula shows (not the result). I can't figure out what is wrong as the formulas in column B work fine (the results are showing, but not using the same data that column A is).

I am thinking it may have something to do with the data being used to calculate the formulas but not sure. How can I resolve this?

View 7 Replies View Related

Calculating Percentiles

Dec 5, 2008

For my Intro to Engineering class, I collected data of two filter media in the laboratory. The data included the % of the media which passed through a sieve and the sieve openings. For use in a certain equation, I need the opening size at the 10th, 30th, 50th, 70th and 90th percentiles. I've tried searching on the Microsoft website but I don't think the PERCENTILE function will work correctly with the given data. I also tried using the slope between points to find the opening sizes at the percentiles mentioned, but doing so yielded different results from my professor's. Attached is the data I collected organized in tables and graphs of the data. I have also attached a pdf file of an example which my professor has given us.

View 5 Replies View Related

Calculating Percentages

Mar 10, 2009

I think a really easy no brianer, I need to find the difference in percentage terms of two values. I am using =(B2-A2)/ABS(A2)

where B2 = 24.09
and A2 = 21.08

View 2 Replies View Related

Calculating Cost

Apr 17, 2009

Problem - billing spreadsheet for prisoner fee.

1 - 8 hrs = $55
9 - 24 hrs = $55 + $65 or $120
Anything over 24 hrs - $65 for each additional (24 hrs) ($185)

So if you were locked up for 6 hrs it is $55. If you were locked up for 18 hrs it is $120. If you were locked up for 28 hrs it is $185. And if you were locked up for 49 hrs it is $250. Cell F5 contains number of hours locked up - I would like cell I5 to calculate the cost of the stay. I am proud of myself for figuring out the date and time subtraction - but this part has me stumped.

View 5 Replies View Related

Calculating Rise In CPI

Jun 9, 2009

In order to compute and forecast an estimate of the triennial rent adjustment, i need to compute the rise in the cpi (table) from the lease date (cell c3) and the present date (cell a2) or the closest publishe date existing in the table. The % rise is easy to calculate present index / opening index -1 = % rise in cpi. I update the index monthly when onthe bls publish it.

View 3 Replies View Related

Calculating Months

Jun 20, 2009

I input a month as a start date, and then want the next x number of cells to increment by one month based on the start date. I thought this would be easy using the preset DATE function but I can't get the thing to do what I want.

View 9 Replies View Related

Calculating Using Time

Nov 12, 2009

Firstly, i'd like cell G5 to show the amount of time worked i.e diff between E6 & F6. Secondly I'd like help with the formula for cells AF6 & AG6 which would require AB6-AC6 divided by the frames, every time I try it I get a messed up answer.

View 14 Replies View Related

Calculating Between Two Times

Nov 24, 2009

I had an excellent response last time I posted here, this time Im stuck again with a new formula. Im trying to calculated amounts between different times, but keep tying my self in knots with complicated IF formulas.

Is there an easier way to work out hours worked between 2 times, but too complicated things further I need three separate amounts so Im guessing Ill need three separate formulas

Hours between 00:00 06:00
Hours between 06:00 19:00
& hours between 19:00 00:00

An example could be, 05:00 20:00 should be 1,13,1

View 11 Replies View Related

Calculating Field On A VBA From

Jun 20, 2007

I have run into a problem I have not found a solution for surprisingly. I need to calculate several fields on the form prior to saving it and thus exporting the data to the worksheet. All I can find is how to calculate the field in a worksheet and then reference it with VB code on the form. Is what I want to do possible?

If I run into many more problems I may want to shop this project out as my schedule barely allows for the work I have let alone attempting to learn VBA on the fly.

If anyone is interested I can post the project so far along with the detail of what I want it do in the end.

View 9 Replies View Related

Calculating Cells ..

Apr 1, 2009

I have the workbook set to Auto Calc the Cells, which seems to be a bad idea, because with the amount of formula in the workbook, it slows the whole thing down and makes it impossible to do anything within it.

Is there a way that I can speed this process up, using some code when I run certain sections?

There is a copy of what I am doing, so you can see the amount of formula.

View 13 Replies View Related

ADVERTISEMENT