Question: I want to solve this with VBA code in Excel.Please help me. A total number of N points P; are defined in a plane by

I want to solve this with VBA code in Excel.Please help me.I want to solve this with VBA code in Excel.Please help me.

A total number of N points P; are defined in a plane by means of their coordinates X; and Y. The number of the points and the values of their coordinates must be input from a text file with the following content: N X Y XN YN The input coordinate values must be output preliminarily on Sheet1 with precision of two digits after the decimal separator in the following way: Coordinates of points X X Y Y XN Y From the keyboard, the coordinates of one additional point T must be input. A matrix A[N,3] must be created, whose first column contains the distances from the points P to the origin of the coordinate system 0, whose second column contains the distances from the points P; to point T, and whose third column contains the surface areas of the triangles OTP;. The computation of the distances and of the areas must take place in sub- procedures. The matrix A must be output on Sheetl under the table of coordinate data in the following way: OP PiT OTPI The starting of the different sub-procedures must be done with command buttons

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!