geometry

  1. Worf

    Excel TypeScript and the Jarvis Algorithm

    Today I am presenting the gift-wrapping algorithm, which calculates the convex hull for a bidimensional set of points. You can read more about it on the link below. Here are the main features of the code: It will start from scratch and generate an aleatory array of coordinates. If you prefer...
  2. S

    Geometry: unique four-sided polygons

    Good Afternoon, I'm trying to assign values (whole number > 0 but <= 5) to each side of a four-sided polygon (sides a, b, c, d) in which the values add up to the same total, such as 12. However, the polygon must be unique regardless of orientation. One way I was visualizing this using Excel...
  3. Worf

    Manipulating shapes with VBA

    Here is a description of this application: Canvas sheet - shows your current work. Problem sheet - presents the original problem and also some examples that can be pasted on Dat page. Dat sheet - There are stored triangles vertices generated by the program. Alternatively, you can insert your...
  4. J

    VLOOKUP Multiple value return in Single Cell with Repitiion

    Hello - I have a reference value that I'm looking to return the associated values into one cell but am not sure how to do that. For example, assume the reference value is MATH in worksheet 1 and in Worksheet 2 Math is associated with Geometry, Algebra, Statistics. I'd like to return both...
  5. M

    Index-Match Formula

    I've got a spreadsheet that looks like this: <tbody> Teacher Class John Smith Algebra John Smith Calculus John Smith Geometry Steven Parker English </tbody> I'd like some help if possible, coming up with a formula to put into another sheet, that would put all the classes that...
  6. J

    VBA to Split 2D plane measurements into 16 workbooks

    I have a main workbook and a main worksheet.The values I want changed in the work sheet are the four variables shown above under X and Y in the H and I columns. I want to create 16 workbooks, each one determined by the geograpic location on the sheet shown in the diagram.They are numbered in the...
  7. T

    Line intersection - with a difference

    I have been working on a problem and through all of my research I have been unable to find an existing resolution. I do not have the required math knowledge to produce an elegant solution. There are several examples of working (and very elegant) line - line intersections with either complete...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top