“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I am trying to calculate the number of hours when wind is going a specific direction (0-45, 46-90, 90-360 in degrees) as well as the average speed +direction. Under YR-MODAHRMN, it is represented by ONE hour. How will I be able to create a formula for these?

Solved by O. Q. in 24 mins

x= a*cos(Kx *t)
y=b*sin (Ky *t) parametic equation

Solved by E. H. in 18 mins

I need to be able to quickly add the below scores together with a sum, so for example 1001 is one ID but I need to add all his timeonpitch and scores together to one total quickly as I have thousands of players. Then I also need to divide there score over how much time on the pitch.
pla id code timeonpitch score
1001 90 -1
1001 90 0
1001 90 2
1001 90 9
1001 90 9
1001 90 0
1001 90 9
1001 90 5
1001 90 0
1001 90 9
1001 90 -1
1001 90 3
1001 90 2
1001 90 4

Solved by C. B. in 22 mins

I am trying to figure out the average speed and direction between 0-45, 45-90,91+ in degrees. The direction (DIR) is given in degrees while the speed (SPD) is given in mph. I am trying to input the formula into column V.

Solved by V. U. in 17 mins

Looking to have Lat. Long in - Degrees Minutes Decimal Minutes
120* 23.2345'
Can you do that?

Solved by O. H. in 26 mins