Calculate Angle From X, Y Coordinates
I have a userform, on it is a very large command button with a picture of a map loaded on the button. The button is 500 width(X) by 500 height (Y), so the center of the button would be at the location 250 (X) by 250 (Y). The button is coded for mousemove to get the X,Y cooridates and when you _Click the button a textbox gives the distance to the point(mousemove) from the center of the button. All that is good, but now I'd like to find the degree of the point referenced to a compass, ie, if the point is at 250 (X) and (Y) is less than 250 then the point would be due north at 0/360 degrees and if the point (Y) is greater than 250, it would be south of the center of the button. I hope this make sense. It's been a long time since trig. I've been searching but can't seem to find the correct formula to figure this out.
Here's the other problem, I'm doing this in powerpoint so I'm not sure if cos or tan functions are loaded in this program. I am posting this in the xl forum because I figure that's where most of the people who could figure this out are. If this is in the incorrect forum I can try to move it,
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Calculate Shortest Distance From Coordinates
I want to use a User Defined name look up its corresponding X/Y Coordinates , reference a list organized by categories, then go through each name in the list finding each's X/Y Coord Calculate distance. SQRT((XX)*(XX)+(YY)*(YY)) where X and Y are Coordinates & Return the name of the smallest Value.
View Replies!
View Related
Calculate Relative Vector Coordinates
I am running a fairly complex simulation at work and have quite a few different functions in it. For the simulation to work properly, i need to have the Solver addin and the Analysis ToolPak installed. Everytime that i try and use the simulation on a different computer (or if anyone else tries to run it) the addins must be enabled again. Is there a way to set up a macro to enable them when either i open the simulation (first preference) or when a button is pressed (2nd preference).
View Replies!
View Related
Sine Of An Angle X By Summing An Infinite Series In VBA
i was set some work related to maths to be carried out in VBA. the problem for me is im finding it very hard to understand either and so i cannot seem to work out how to complete the assignment given. i can attach the assignment to save space and time reading on here however if you would like me to post up the assignement i can do that too....
View Replies!
View Related
Numbering For Coordinates
how to get a single cell (C2) and (D2) to make the numbering format go from (## ## ##) to (######). The Excel spread sheet is a coordinate converter, designed to take Degree's minuets seconds and convert it to Decimal Degrees, the formula is set up and work Great, but every time I copy and paste the coordinate to the excel spread sheet, i have to manuelly erase the spaces between the numbers so the formula can work properly. How can i get the cell to automatically delete the space between the numbers to save me time.(I.e 29 35 42.34325 to> 293542.34325)
View Replies!
View Related
Calculating Distance Between Coordinates
i use a Trimble Total Station Survey equipment, This is used for suveying and measuring distances between points on jobs. These points can be exported onto the pc as a text file and imported onto excel, the file has a northing and easting to locate the point these are comma separated. I would like to know if excell is capable of working out a distance betwen two of these such points by using the two pairs of northing and easting coordinates. The maximum distance between two points is no more than 50 meters. If for example when imported onto excel point 1's coordinates are locted in cells A1 and B1 and points 2's coordinates are locted in cells A2 and B2.
View Replies!
View Related
XYZ Coordinates Graph 3D
I have the following data: X Axis  Years (2004, 2005 ,...) Y Axis  Quantity (imported, exported, produaced) Z Axiz  Name of the products I want to make a graph with teh X, y,z axis in excel. When i use the 3D graphs in excel, it is not taking the z vales connected to teh cell.
View Replies!
View Related
Convert Lat/longs Coordinates
I'm trying to create a spreadsheet that will convert coordinates from DDMMSS.00 to DDMM.000. I found another thread that discusses this same issue, but I was unable to make it work for me. I'm attaching a sample spreadsheet that basically shows what I'm trying to do.
View Replies!
View Related
Finding The Hypotenuse Of From Two Pairs Of X,Y Coordinates
I have a map with several waypoints and would like to find the distance between any of these two waypoints. Sounds simple, but I have having an issue with the later parts of the excel file. Let me explain further. There are over 100 waypoints on this map we have. Each waypoint has an, seemingly arbitrary, Xcoordinate and YCoordinate. However, if you divide the coordinates by [X], they turn into miles. It should go without saying that finding the distance between two waypoints is rather simple mathematically, but I having an issue figuring out how to pull two random waypoints and having the distance automatically calculated. So far, I just have column A with the waypoint name and with column B and C having the X and Y coordinates respectively. Is there anyway I can create some sort of call function that when two waypoint values are entered it would automatically calculate the distances?
View Replies!
View Related
Extract AutoCAD XYZ Coordinates
I am trying to extract (and separate into 3 columns) the numbers only, positive or negative portion of (XYZ) Coordinates copied from AutoCAD and pasted into column A X = 96179.9699 Y = 61973.9793 Z = 1368.0025 In column B,C and D, I have tried to use Find Mid and other means
View Replies!
View Related
Count Geographic Coordinates Within A Range
I have 2 columns of longitude and latitude coordinates. I want to count coordinates within certain ranges. A bit like using the Frequency function but for 2 sets of values and 2 bins arrays. This would mean I could create a table with latitute bins as the row headers and longitude bins as the column headings. Would anyone know how to do this?
View Replies!
View Related
Data Type Of Coordinates Of 2dimensional Array
I have a big array "DataArray" and want to access it: For i = 1 To 4 variable = DataArray(SourceArray(i)) Next i "DataArray" has two dimensions, so SourceArray has to consist of data like this: SourceArray(1) = 1,2 sourceArray(2) = 2,4 etc What data type does Sourcearray have to be? Integer doesnt seem to work, and DataArray doesnt like a string as coordinates. I have a workaround with two different arrays of integer for x and y coordinates, but this cannot be it.
View Replies!
View Related
Modify Freeform Shape Coordinates
Right now I'm modifying a figure based on size data in an excel table. I'm modifying the X/Y coordinates of the points of the freeform shape with VBA, however, I have to use absolute x,y coordinates. I'd like to be able to move the shapes throughout the sheet. With fixed coordinates, this makes it difficult. I'm hoping there's an easy way to it
View Replies!
View Related
ActiveCell.Address  Discarding Fixed Coordinates
I'm attempting to write a piece of code that builds a formula dependent on the location of the cell it is being created in. The relevant line of code currently reads as follows: ActiveCell.Offset(0, 5).Value = "=" & ActiveCell.Offset(0, 5).Address & " & " & ActiveCell.Offset(0, 6).Address Which when activated in cell A3, will enter the formula =$A$3 & $A$2 However, I would like to know if there is a way of automatically building a formula like this, only without the absolute references. Reason being, this formula is used in a large table, which is sorted in date order automatically when the sheet is activated. Since the code generated will point at the row it was generated on, when the table is sorted, this formula will calculate the incorrect result.
View Replies!
View Related
Minimum Distance Calculation Of Geographic Coordinates Using Array
I am working on two spreadsheets, one we shall call Target Sheet and the other Reference Sheet. On the target sheet, I have a set of 200 geographic coordinates longitude and latitude (in decimal degrees). Each pair of coordinates coresponds to a geographic site. On the reference sheet, I have a set of 900 geographic coordinates longitude and latitude (in decimal degrees). Each pair of coordinates coresponds to a geographic site. Note that of the 900, 200 are the same from target sheet, other 700 are different sites. Using the spherical law of cosines, I can calculate the distance between a set of coordinates on target sheet agianst a set of coordinates on reference sheet. This allows me to see the distance from one geographic site, to the other. This was easy. The formula I use is as follows: ....
View Replies!
View Related
Getting Max Value Of A Point Inside A Square Defined With X,y Coordinates
I have a square which is defined with x,y coordinates (roughly 2000 points), and for each point I have a value. And I have to divide this square in to 9 equal sub grids, and find the max value in each sub grid. I have all the coordinates for the sub grids. But I can’t get the max value of the specified cells. I am thinking something like this: if 0<x>10 and 0<y<10 then it is sub grid 1 and I want to find the max value there and if 0<x>10 and 10<y<20 then it is sub grid 2 and so one…..
View Replies!
View Related
Button Position/Coordinates On Worksheet. Discrepancy Between Versions
Add Multiple Buttons That Select Row Of Housing Cell. One of my Macro's places a button on a sheet using Top/Left; Set sbut = Sheets("Listings").Shapes.AddFormControl(xlButtonControl, _ Range("J" & count).Left, Range("J" & count).Top, 50, 12) When I try to find the row of the clicked button using the following code; Range(ActiveSheet.Buttons(Application.Caller).TopLeftCell.Address).Activate The code behaves differently in Excel 2002 and 2007. In 2002 it returns the row the button sits on, but 2007 returns the cell above the button. This could be because the workbook is an XLS running in Excel 2007 in compatibility mode? Is there a way to "nudge" the button down a little after it has been placed using .top/.left ? Or is the only way around this something like; Range(ActiveSheet.Buttons(Application.Caller).TopLeftCell.Address).Activate count = ActiveCell.Row If Application.Version >= 12 Then count = count + 1 End If Is this a bug, or something that I am doing wrong ? The workbook needs to be a .xls to ensure that it works in older versions of Excel.
View Replies!
View Related
How To Calculate Combinations ?
I want to see how much combinations are possible when i got 6 numbers..  got this numbers 123456  want to calculate how much combinations of ( 2 ) numbers possible  want to calculate how much of ( 3 ) numbers possible  want to calculate how much of ( 4 ) numbers possible  want to calculate how much of ( 5) numbers possible  never 2 same numbers together (22) or (223) or (2234) may not be in list  How can i make the result visible in kind of list ? I would be nice if somebody knows a good solution..
View Replies!
View Related
Calculate Variances
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 Replies!
View Related
Calculate Totals
I have a spread sheet that is used to review calls placed by a call center. Column A has the extensions of the phones, and Column E has the type of call (Outgoing or Incoming). Each line is a new phone call. We have about 8 extensions, but the worksheet could have a couple thousand calls. So, Column A could have extension 1401 from rows 1100 as extension 1401 made 100 calls. I'm looking for a formula or macro that will summarize how many outgoing and incoming calls extension 1401 had. Thoughts? My initial thought was something like this: =SUMPRODUCT((A2:A5000=H2),(E2:E5000)) In this formula, I would type in the extension of H2 and it would scan Column A and add up the values in Column E. The only problem is, that Column H doesn't contain a numerical value. It only has "Incoming" and "Outgoing" (minus the quotes), so this doesn't work.
View Replies!
View Related
Calculate Ratio
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 Replies!
View Related
Calculate The Variance
i have a dynamic list of numbers....currently 10 numbers in the list. how can i calculate the variance? i have the upper limit (=MIN(1,(mean+half width)) i have the lower limit (=MAX(0,meanhalf width) i have the mean (avg of all numbers) i have the t value (TINV(alpha, (n1))) i have the half width (t value * SQRT of Var/N) i just don't know how to get the VAR/N
View Replies!
View Related
Calculate If There Is Anything In The Cell
Im wanting to do a sum calculate if there is anything in the cell. Ive tried using the 'count' and 'count if' but both return values of zero. There are words in the cell, rather than numbers. I want it to return the value of cells with data in them, and exclude those with nothing ("") in them.
View Replies!
View Related
How To Calculate Age
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 Replies!
View Related
Calculate Hours
I am designing a simple time card. Column D=time in, Column E=time out. My formula in column F to calculate total hours is =TEXT(E2D2,"[h]hrs"). The result is not correct. Example: In at 9:30 out at 5:00 and the calculated total is 4 hours.
View Replies!
View Related
Calculate The Probabilities
How to calculate probabilities... say that I am buying pop bottles that say "1 in 6 wins" or drawing buttons from hats where 5 of them are numbered 15 and the other one is the winner. (Note that you would have to keep putting the buttons back after drawing so there is always 15 and a winner whenever you draw) The possible combininations are easy to figure out... just do 6 to the power of how ever many bottles you buy or how many times you draw a button. So obviously if you draw once, there is 6^1 possible... if you draw twice there are 6^2 (or 36) possible combinations. To figure out how many winning possibilities (win atleast once) there are it's not too hard at this level... you can just list the possibilities: First  Second 11 12 13 14 15 1W (1 winning combination) 21 22 23 24.................................
View Replies!
View Related
Calculate Overtime
I have a time sheet for my employee's that I need to calculate their overtime in 1.5x and 2x rates. Their overtime totals are done in individule columns from D33 to S33. The first 4 hours per day are charged at 1.5x and anything over that is 2x. I want to show the 1.5x in one box and the 2x in another. I do believe that I need two formulas one in each of the boxes where the final totals would go. Here's an example, in columns D37 to D41 the employee has worked 12, 14, 9, 16 and 14.5 hours. so that's 17 hours @ 1.5x and 8.5 @ 2x.
View Replies!
View Related
Calculate The Value In The NPV
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 Replies!
View Related
Calculate The Percentage
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 Replies!
View Related
How To Calculate Time
WHen I was a beginner at Excel, I came up with the following formula to calculate the time difference between two "time" values. Since I was too lazy to add a ":" between my hour and minute, I had decided to simply enter the start (column B) and end time (column C) as a military time (e.g., 0100, 1230, 1500, 1930, 2300, 2359). The following formula would be in Column D. =IF(C7
View Replies!
View Related
How To Calculate Date
how to calculate the date for one year. If i have 24Jun08 (A1) i need to calculate 24Jun09. If i do =A1+365 it gives me an error (the little green thing in the corner of the box) is there a way to do this without the error showing up.
View Replies!
View Related
Calculate Total
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 Replies!
View Related
Formula To Calculate A %
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 Replies!
View Related
Calculate Text As Value
trying to calculate a text as value in a formula. In cell A5 (please see the excel attached) I have a weighted formula that is supoosed to return a final result based on the drop down from cells B5 to V5. Drop downs give the option of choosing a value. Everything is going fine as long as you select a value (5, 3 or 0). In cells H5, J5, K5, R5, S5, U5 there is also the option of choosing NA. I am trying to get the formula to calculate NA as being equal to 5. Basically, if for the respective parameter someone choses NA, the final result in cell A5 should not be influenced. If all the parameters are 5 and only one has NA (any of the cells H5, J5, K5, R5, S5, U5), the final result (in cell A5) should be 100. The same applies if all parameters are 5 & more than one cell or all the cells that have the NA options (H5, J5, K5, R5, S5, U5) are NA.
View Replies!
View Related
Calculate Overlap
Here is my data Range A1:L8 1234567891011Overlap111122275%22275%22250%22225%2220%2220% I am trying to figure out a formula in L3 which is the calculation of overlap of region1 and region2. The top row is the number of days. What formula can I use to calculate the percent overlap? The numbers in column L show the expected result. (Using XL 07)
View Replies!
View Related
How To Calculate Overtime
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 Replies!
View Related
Calculate Workbook
I'm opening 2 workbooks and I'm on Manual Calculation option. I wanted to calculate only workbook A. The standard button only give me the option of calculating a worksheet or all open workbooks (F9).
View Replies!
View Related
Calculate A Certain Weekday
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 DateWednesday 10/28/09 = Next delivery date is Tuesday 11/3/09. Store 2  Today's DateWednesday 10/28/09 = Next delivery date is Wednesday 11/4/09. Store 3  Today's DateWednesday 10/28/09 = Next delivery date is Thursday 10/29/09.
View Replies!
View Related
If Cell Has Value Calculate
I am setting up a spread sheet to compare an invoice between 2 suppliers. It has formulas throughout and a total column. If no data is entered in cells then total column has "value" in it. How can I eliminate the"value" while still keeping formulas in place. Not all cells will have data in them on every instance. But I still need all formulas to be saved
View Replies!
View Related
