# Calculate Ratio

Sep 25, 2007
I'm trying to create a quote... basically I need to find out about calculating ratios.

We have 47 students going on a trip to different venues, we offer 1:10 teachers (i.e. one teacher free, for every ten students going), however some venues offer a different ratio e.g. 1:5 teachers free of charge.

I need to somehow create a column where it will calculate the amount charged for the different ratios the venues offered.

View 9 Replies
ADVERTISEMENT
Sep 30, 2003

I have a spreadsheet that calculates Reward to Risk Ratio for the stock market investing. The formula is Target Price - Entry Price / Entry Price - Stop out Price.

The problem is the ratio often comes out to something like 3/4 or 7/8.

Is there a way to reduce the result down so that the first number is always a 1 to make it more clear but still maintain the ratio. For example, 1-1.3, or 1-7.8, etc.

View 9 Replies
View Related
Aug 7, 2008

I am trying to create a spreadsheet to calculate the macro nutrient ratio of foods based on carbohydrates, proteins, and fats and how many units/servings I eat of each. I've attached the file I've started. It's fairly straightforward and simple, thus far.

I would like to be able to associate a food with its various nutritional data in its row (fat, carbs, sugar, fiber, sat. fats, protein.. etc.). With all of my food items entered, I would like to be able to choose from a list, have it prompt me for how many units I've eaten then plug it into my formula to calculate totals and ratios.. The final flow should go soemthing like this...

1. Select a food from a list (each food on the list has its associated characteristics)..

2. Select how much ( each food will have an associated serving size i.e. 1/2 cup, 1oz..) ---- (4) oz VS. entering each unit in A1

3. Make these totals of each characteristic feed into my final chart with which to track and graph.

View 4 Replies
View Related
Jul 25, 2014

I have added 3 tables data .. also I had created a sample solution calc for emp1 and project1 ... I need to calculation the ratio between the months based on the working days and allocate the efforts accordingly.

View 2 Replies
View Related
Oct 14, 2009

I am trying to get an exact ratio in excel but am unable to do so. Example:

60,000/58000 = 1.03. The ratio should then be 1.03:1. But excel is showing this is 1:1. Here is my formula

PHP

=TEXT(E55/E56,"0")&":1" . I need it to show it to two decimals.

View 2 Replies
View Related
Mar 28, 2014

On the attached worksheet i have blocks of data in col C in chronological order,i wish to count the number of times related data in col AG is between 1 & 3 incl (highlighted in blue) ,the result to be expressed as a % in col V,eg block A =5,col AG has 2 event between 1 & 3,so col V = 40%.I have inserted empty rows between the data for clarity,there are no empty rows in the data.

View 1 Replies
View Related
May 23, 2013

What is the best Aspect Ratio for a dashboard 4 X 3 or 6 X 9.

View 3 Replies
View Related
Mar 2, 2013

I'm working on a plan with the objective to reach a 20:80 ratio from Team 1 to Team 2

The intent of the is get 80% of the work to be supported by Team 2, which currently has no team members.

Team 1 currently has 32 team members.

I am trying to to determine if I need to hire or re-deploy employees to from one team to another or to another program to achieve the objective.

The objective is to take Team 1, which is currently doing 100% of the work & reduce that work load to approximately 20%, which then Team 2 will be supporting approximately 80%.

I started a generic calculation but I believe it's wrong.

View 3 Replies
View Related
Feb 14, 2007

can Excel make a Ratio of the results of one column against another ?

eg, Col A 2.00

Col B 1.00

in Col C, the ratio result is 2 : 1

View 9 Replies
View Related
Feb 18, 2008

Assign values to ratio buttons

I have created a UserForm in Excel, to gather data for a questionnaire.

For each question, the user must select an answer from a radio button (Yes, No and N/A)

When I add the record (answers) to the sheet1, the results are shown as all being false.

I want to show either ‘Yes’ or ‘No’ or ‘N/A’

Private Sub CommandButton2_Click():

Dim LastRow As Object

Set LastRow = Sheet1.Range("a65536").End(xlUp)

LastRow.Offset(1, 1).Value = UserForm1.OptionButton1.Value

LastRow.Offset(1, 1).Value = UserForm1.OptionButton2.Value

LastRow.Offset(1, 1).Value = UserForm1.OptionButton3.Value

End Sub

View 9 Replies
View Related
Jul 13, 2006

Need formula to calculate employee turnover ratio and if there is a place to get a free template to download?

View 9 Replies
View Related
Nov 11, 2012

I have a userform that opens up to full screen, however, when i designed it everything is central and in its place, but when the userform opens full screen everything is pushed to the left and not using all the form.

I know that in VB2010 u can use docking and table layout panels for this sort of thing but VBA 2007 which I am using with excel doesnt seem to have these options?

View 1 Replies
View Related
Jul 29, 2014

with the following formula.

I need to find the median of Column C and Column H and then divide the median sum of Column C by the median sum of Column H. My data contains blanks so I obviously need to count cells with data only. I am trying to avoid hard coding any cells and am looking for a single formula.

View 1 Replies
View Related
Sep 27, 2011

below is my coding, it inserts a picture into a cell and fits to what ever the cell size is.

my cells are more landscape (fixed) than portrait, how can i still make the images fit into the cell height wise but keep a aspect ratio of a portrait picture.

Sub InsertPicture1()

Dim myPicture As Variant

myPicture = Application.GetOpenFilename _

("Pictures (*.gif; *.jpg; *.bmp; *.tif),*.gif; *.jpg; *.bmp; *.tif", , "Select Picture to Import")

If myPicture = False Then Exit Sub

Application.ScreenUpdating = False

[Code] ........

View 6 Replies
View Related
Aug 24, 2012

I'm haven't played with stats in a while and now I'm trying to determine the ideal traffic/labor hour in order to maximize revenue/labor hour. My data looks like this:

Excel 2010

A

B

C

D

E

F

1

Date

Traffic

Revenue

Hours

Traffic/hr

Revenue/hr

[Code] ........

Sheet1

I don't know if Excel or Analyst Toolpak has the firepower for this or if I'll need additional tools.

View 5 Replies
View Related
Jan 17, 2008

I can’t seem to work out the formula for calculating a ratio using the data in the pivot table.

I’ve added a column next to the pivot table to work out the ratio between to columns.

=SUM(B11/C11)

But what if there is no data in cell (B11), I want to return a “ “ (blank space)… but it returns a #DIV/0!

View 14 Replies
View Related
Aug 24, 2006

I have what may be a math question as much as an Excel question. See my attached spreadsheet example in which I grow the denominator of a ratio by a fixed percentage until it equals or exceeds the numerator. This results in the denominator being grown X number of times.

View 2 Replies
View Related
Aug 29, 2008

I have two columns in a payment schedule (which adjusts according to certain user inputs) that I need to use in my NPV calculation.

The first column is the Total Payment and the second is Inducements.

Therefore each value in the NPV calc. needs to be the sum of a given period's payment and inducement (but i don't want/have a separate column which calculates the sums). The number of periods adjusts with the users input of Term. There also may be periods where there is a payment but no inducement.

View 14 Replies
View Related
Dec 22, 2011

The formula below calculates between rows 2 and 109. How can I change it to calculate between row 2 and the last used row in the sheet.

Code:

Range("D2").Select

ActiveCell.FormulaR1C1 = _

"=(RC[-1]-MIN(R1C[-1]:R109C[-1]))/(MAX(R1C[-1]:R109C[-1])-MIN(R1C[-1]:R109C[-1]))"

View 2 Replies
View Related
Jan 10, 2007

i got a problem to calculate IRR and NPV for my company cash flow. i so confuse how to calculate cos the initial investment (expense) is pay in installment by yearly basis. i hope anyone can help me to solve this problem.

I m not sure whether what i'm doing is correct or not. thanx

http://spreadsheets.google.com/ccc?k...Hd2JSrIj7H-Pew

View 9 Replies
View Related
Feb 17, 2007

If I have this serie of values in the A column:

34

33

33

33

30

29

26

26

20

19

17

17

And want this results in the B column:

1

3

3

3

1

1

2

2

1

1

2

2

Those numbers will indicate how many of the same are in a row.

What's the easiest way to accomplish this?

View 7 Replies
View Related
May 13, 2009

to calculate the age from the format date of birth shown below.

SQL Data S1Date of Birth2Jun 9 1947 12:00AM3Jan 1 1957 12:00AM4Jan 1 1958 12:00AM5Jan 1 1956 12:00AM6Jun 4 1951 12:00AM7Dec 10 1963 12:00AM8Jun 17 1958 12:00AM Excel tables to the web >> Excel Jeanie HTML 4

View 9 Replies
View Related
Feb 24, 2010

I am trying to call a sub calculate but I keep getting errors, is calculate a reserved sub name?

View 9 Replies
View Related
Feb 18, 2008

building a spreadsheet. I have the total price in cell f6. In cell C6 I need price with no taxes. D6 should be the pst of 8% and E6 should be the gst of 5%.

View 3 Replies
View Related
May 6, 2013

Formula to calculate GST? I have a Non-capital and a Capital column, then a Claimable GST column.

I currently have '=SUM(E5/11)' in the Claimable GST column (G5).

If E5 is a zero value I need the sum of F5/11 in G5.

View 2 Replies
View Related
May 16, 2014

I have the following scenario on the attached worksheet: I need b45 to say 0% if b42 and b43 are left blank.

View 3 Replies
View Related
Jun 21, 2014

I have a simple issue i cannot figure out how to write a formula for.

In A2 i have the number of operations.

In A4 i have the percentage of CPU usage it requires to complete those operations.

I need an output somewhere that will tell me how may operations I can get per 0.1% of CPU usage.

View 5 Replies
View Related
Jul 24, 2014

I'm trying to automate the attached schedule so that the formulas in H stop increasing once the amount in column J equals zero. So far everything I've tried either gives me a circular reference error or ends up giving me the same result as if I depreciated the asset an additional month.

View 3 Replies
View Related
Feb 22, 2014

I need to calculate a TAT formula for the below case

P1 -- 1 Hour

P2 -- 2 Hour

P3 -- 4 Hour

P4 -- 8 Hour

Shift Start time : 6:30pm

Shift End Time : 3:30am

Suppose a request comes at 9:30pm and it is Priority 1 (P1) then it should be completed at 9:30pm + 1 hour = 10:30pm. I have given the below formula to execute this

=IF(A2="P1",1,IF(A2="P2",2,IF(A2="P3",4,IF(A2="P4",8,0))))

=B2+(TIME(D2,0,0))

The problem here is if the request is P4 then its 8 hr TAT and the formula will calculate the time as 5:30am. Since the shift time end at 3:30am itself the actual TAT should be the next day 8:30pm.

formula to calculate the TAT which includes the start time and end time and also excludes the weekends and holidays.

View 14 Replies
View Related
Sep 5, 2008

I am trying to formulate a formula that will calculate overtime hours worked.

Now standard hours are 17:30pm - 20:45pm. Anything outside these hours are overtime. If the start time is 18:00pm then the person is still paid from 17:30pm @ standard rate regardless.

Now I am trying to work out a formula that will cover hrs outside of the standard hrs AND hrs unworked but paid for.

see attached! September tab {blue highlighted cells}

View 9 Replies
View Related
Feb 23, 2009

Is there a formula for calculating date for every 2nd thursday of the month excluding holidays?

View 4 Replies
View Related
May 14, 2009

Just wanted to find out if the formulas in the attached apreadsheet are correct. Formulas from E6 to E10.

Also, if you multiply the "new daily target" with "working days" should'nt this give you the "remaining" figure? Currently it's not doing this

View 11 Replies
View Related
Jun 16, 2009

How to calculate the Hours

Check the attached file

View 5 Replies
View Related
Jul 14, 2009

I need to create a formula to work backwards from a closing balance to establish an inventory value on First In, First Out principles. The attached spreadsheet probably explains it better.

View 2 Replies
View Related
Aug 13, 2009

I need a formula that will calculate the total of the items in column "W" when the row directly below it contains a "1" in column "V". It will need to calculate the totals from that row all the way up to the next row that contains a "1" in column V.

Example:

In X14 (where I will put the formula) it would total W9 through W14. However the formula still needs to be able to calculate the total if there are more or less cells to sum. So that the same formula could calculate that in X8 it will total W5 through W8.

View 14 Replies
View Related
Oct 28, 2009

I need to set up something that "calculates" an orders next delivery date. We deliver on Tuesdays, Wednesdays, and Thursdays for different stores. IE.

Store 1 - Today's Date-Wednesday 10/28/09 = Next delivery date is Tuesday 11/3/09.

Store 2 - Today's Date-Wednesday 10/28/09 = Next delivery date is Wednesday 11/4/09.

Store 3 - Today's Date-Wednesday 10/28/09 = Next delivery date is Thursday 10/29/09.

View 3 Replies
View Related
Nov 2, 2009

I use this formula to calculate a %, but naturally when there is a 0 excel returns the #DIV/0! error. Can someone fix my formula so the error gets replaced with a 0

in the formula the 0 would be in cell W2 =IF(N2="yes",BN2/W2,0.5).

View 3 Replies
View Related
May 20, 2014

I have 2 columns (A and B) of text, A and B that needs to be turned into numbers in column C. The text in column A can also occur in column B and vice verse. There can also be 2 or 3 values in column B, there is no "," to separate the values only spaces. Every text name has a value (they are explained in the file but not included in original files). If there is text in both columns it has to add the value for each text. I need to get column C calculated by using VBA. Column C is empty from the start and the rows can be +500.

In the file the result is applied manually.

View 2 Replies
View Related
Jan 26, 2009

I have attached a file with both a sample section of data on the first sheet and the outcome I would like on the second sheet... I would do it all manually but there are over 200,000 rows in the actual file.

The macro needs to calculate the percentage of sale for each reference number within each part number and move down to the next part number and do the same until it reaches the bottom.

View 9 Replies
View Related
Feb 9, 2009

I am looking for a way to calculate a sheet every second. I haven't been able to find anything in the forums

View 2 Replies
View Related