I have a list of wind directions and I want to get the average. Obviously, there is an issue since the average of a northwest (330) and northeast (030) wind is 360, not 180. I've got several formulas in the attached spreadsheet, but none seem to give the correct results.
View 3 RepliesI'm trying to create a wind rose using data from a logger. Have wasted a lot of time so far.
Formula that could put this data into some kind of wind rose?
The main information I'm interested in is the length of time the wind blows in different directions.
I am trying to create a wind rose in excel. IS there a process to make wind rose in excel ?
View 4 Replies View RelatedWorking on the same piece of work as in:
http://www.excelforum.com/excel-gene...n-formula.html
Howver this time i need to add in columns for whether the ship is moving or not and the speed of the wind.
Currently have this formula to calculate the kinetic energy fo the plane:
I need to calculate the subscription amount based on the capacity of the wind mill.
The slab rates are as follows:
1. Up to 0.6 MW - Rs.3,000
2. more than 0.6 up to 3MW-Rs. 7,000
3. 3 MW up to 98MW -Rs. 7,000 for the first three MW and Rs.1,500 per MW in excess of 3 MW
4. Above 98 MW -Rs. 1,50,000
I had tried IF statement but was not successful.
My understanding of Excel is that the calculations are performed in Column A first and then down through the rows in Column A. After all the calculations are finished in A, the calculation moves over to Column B and down the rows in B. Is this true?
I know that Excel is a little more complicated than that especially when it creates a queue for calculations, etc. However, assuming there's no calculation list/queue, would the above be correct?
I have a sheet with part protection and have 4 columns that I want to enter data. Need advice on macro -columns cdef. When data in column c entered, go right two columns, enter data in column e, go right, enter data in column f, and go down, and back, to column c. That is on the next row down ready to enter next set of data.
View 2 Replies View RelatedI'm trying to do is take the difference of two wind directions but need the actual difference not the true mathematical difference. For example:
Wind direction 350 was forecasted
Wind direction 020 was observed
The difference is 030 degrees off not 330 degrees.
How do I do a formula to state the true difference not numeric?
I was figuring these conditions:
- if the number is above 180 & below 360 just subtract 180
- if the number is below 180 & above 0 just add 180
Using w/ example:
350-180=170
020+180=200
170-200=-030 (then take ABS to get 030)
I'm a weather professional and doing tons of metrics regarding weather parameters.
is there a way of changing the text direction for an ActiveX textbox? I need it to show the text in some of the boxes vertically but in other boxes horizontal.
View 7 Replies View RelatedMove after return direction Xltoright In Specified Range.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = ThisWorkbook.Worksheets("mastersheet").Range("trgadd") Then
Application.MoveAfterReturnDirection = xlToRight
Else
Application.MoveAfterReturnDirection = xlDown
End If
When placing a control on a worksheet, the text in the label,option box etc controls is vertical and I can't find a way of changing the direction to left to right. It doesn't happen on all workbooks. I can put the control on a "normal" workbook and then copy it to the "abnormal" workbook but I would like to know why/how I can change the direction of the text.
Under Tools/Options/International the text direction states left to right
I believe this is a little basic for this forum; but, I haven't been able to find a good answer just searching the web.
I have a spreadsheet that I am entering single digit numbers in each cell. I would like the cursor to automatically jump to the next cell to the right after the number is entered (without having to hit the right arrow key).
I have this macro that automatically inserts the date in column B when data is entered in column D. What I would like to is when I press enter in a cell in column D then the selection cell will move to column E and then when I enter again in column E then move to column D again on the next row. IE. if I'm in D12 and press enter then move to E12 and then move to D13 and so on.
View 4 Replies View RelatedE11 through E24 contains numbers and a few errors (#N/A) that need to persist (the errors need to show).
E10 needs to show the average of the numbers that are in E11 through E24, and just ignore the errors.
I have many columns like that - where the errors need to show and I need to show an average of the number/values that do appear, ignoring the errors.
i have two columns...a and b (a w/ names, and b w/grades). then i have the table lookup with names and grades all mixed up for many rows. i want to be able to average the grades with appropriate names.
=average(vlookup(name, table, column, false))?? i don't get it to work and how can i specify the grade to average?
TotHCInv.Value = WorksheetFunction. Sum(KRInv, PBLInv, CRInv, PVInv)
If i >= 34 Then CPSCtphRMA.Value = WorksheetFunction.Average("G" & (i - 30) & ":G" & i)
The first line runs properly, but the second line bugs out with the error message "Unable to get the Average property of the WorksheetFunction class". I can simply do the math, but I thought that using the worksheet function would be easier than summing and dividing. I'm curious, though, as to why I can't seem to use the Average function.
Can I get a minimum average and a maximum average, I have a worksheet with days of supply for 100 stores with about 100-200 products each, the dos resides in column D.
I was going to create a summary page and reference column d.
The following just gives me the min, I want the min average if possible:
I am attempting to calculate Grade point averages for my students for all classes. There are 5 columns of grades to be considered. I frist assign values of 0-5 to the grades then average the points. My problem is that I want the AVERAGE to ignore the zero but it calculates it as well. (I enter a 0 if I have no grade for that class.) I have tried the{ } to make it an array formula but this also did not work. Here is what I have, can anyone help?
=SUM(AVERAGE(IF(AND(L2>89,L2<100),5,IF(AND(L2<90,L2>79),4,IF(AND(L2>69,L2<80),3,IF(AND(L2<70,L2>59), 2,IF(AND(L2>0,L2<60),1,0))))),IF(AND(T2>89,T2<100),5,IF(AND(T2<90,T2>79),4,IF(AND(T2>69,T2<80),3,IF( AND(T2<70,T2>59),2,IF(AND(T2>0,T2<60),1,0))))),IF(AND(AB2>89,AB2<100),5,IF(AND(AB2<90,AB2>79),4,IF(A ND(AB2>69,AB2<80),3,IF(AND(AB2<70,AB2>59),2,IF(AND(AB2>0,AB2<60),1,0))))),IF(AND(AJ2>89,AJ2<100),5,I F(AND(AJ2<90,AJ2>79),4,IF(AND(AJ2>69,AJ2<80),3,IF(AND(AJ2<70,AJ2>59),2,IF(AND(AJ2>0,AJ2<60),1,0))))) ,IF(AND(AR2>89,AR2<100),5,IF(AND(AR2<90,AR2>79),4,IF(AND(AR2>69,AR2<80),3,IF(AND(AR2<70,AR2>59),2,IF (AND(AR2>0,AR2<60),1,0)))))),-1)
I know it is huge. The syntax is correct. It calculates the average, but always for all 5 columns. It will not ignore a 0 in a column.
I'm using the formula =AVERAGE(B16:L16) to give me the average.
However I have a couple of problems with this. Firstly I would like to exclude the value zero from the average. Secondly to also ignore the lowest and highest values.
Example, if the values in the cells are 0,1,2,3,4,5,6,7,8,9,10 then the current result shows 5, by ignoring the 0 and lowest value 1 and highest value 10 the average should be 4.5.
Ok, I for some reason just cant wrap my head around this. I need to to get the average time per call of two rows, but they are based on how many calls taken.
so in one column i have 50168 calls taken at 4:21 seconds per call. and in the next row i have 597 calls taken at 5:20 per call. I need to see what the new average will be with them combined, and I need it to display in m:ss form.
to formulate Excel formulas to obtain the average buy price and average sell price for me to do this futures trading. Thanks a lot. I downloaded the Htmlmaker to post the spreadsheet here to show the manual way to calcualte the average buy price and average sell price but when it is on html form, i clicked on the 'Please click this button to send the source into clipboard' button & then i paste into this thread. Is the way to make my spreadsheet appear here correct cause it cannot work.
View 9 Replies View RelatedI wish to average the best three values (highest) of the last 5 values ( excluding zeros ) in a row.
View 2 Replies View RelatedWhat I am trying to do is track a 10 week rolling average, where scores are entered weekly in row A6 thru W6. The formula needs to count back starting with W6 until it counts 10 scores then average them. Some cells may be blank.
View 14 Replies View RelatedI have a column with time data in HH:MM:SS format. I need to find the average and sum of the entire column. But the problem is it does not give me the sum or average...
If I press F2 and then Enter in each of the cellsthen I get the sum or average. However, as there are thousands of entries, it's not possible to manually do F2 and Enter in all the data.
Is there a way to do it (F2 & Enter).
I have a list of 16,000 numbers in a column. I need to average every 62 consecutive entries, i.e average of 1-62, 63-125, 126-188.......
View 2 Replies View RelatedI have a spreadsheet which has data in the format of:
Date
Sales
Monday, 8 July 2013
191
Tuesday, 9 July 2013
180
[Code] ....
I calculate the average of the last four weekdays individually with =Average(A1,A8,A14..) in a cell above them to get a four week average.
Each time I add a new weeks worth of data, I manually adjust the formula to remove the first cell, and include the latest cell with new data.
I'm looking to find out if there is a way I can automate adjusting the formula so it always grabs the last four Mondays (for example)? Either in VBA or a formula.
Here is my code as it is right now (With the correct range, and yes its a messy range :
[Code] ......
That is my range and thats the range I have to use (The stats are spread out in those rows. How I can get this to disregard 0's? Right now it seems to fail on the third rangevalue (For example in the range above it fails and highlights Y88), but if i remove that value it does the same on the next one instead, always the third.
I have tried =AVERAGEIFS(Range,">0") versions and also ones with /COUNTIF after and others but cant get this to work.
screenshot.jpg
Ok, so from the attached picture (screenshot.jpg), you will see a data export of staff losses.
On the table to the right, i need cell G2 to take the ID from cell F2 and then search column A and add up every time there is negative number in column B.
So if staff ID has -15 , -15, -10 and -10 in the first table, their summary on the right table will show -50
(PS, i know it says AVERAGE LOSS) but i just need it to be the total. So basically, from the loss log on the left, it just counts the total losses occurred by each individual staff member on the summary table to the right.
i m using this to get average
r4/s4 = result(t4)
r4 = 5
s4 = 517
Result(t4) = 517/5 = 103.4
now i use the roundup function to get the decimal less value
=Roundup(t4,0) = Result = 103
i want both function in one function to get result
Cell: F6 is to represent "average weekly offering".
D2:D53: represents the Total Given Year To Date.
I need a Weekly Average for Offering, so is it possible to have a formula that can show the average weekly offering in cell F6?