WPS Table Study: The position relation of circles and circles

To study the position relationship between the geometry, the geometry sketchpad is undoubtedly one of the best platform, but the use of WPS table powerful data processing and graph generation function, can also be in-depth study of some geometric problems? The following is a study of the position relationship between circles and circles (Fig. 1) as an example, Let you have a more in-depth understanding of the WPS table:

Figure 1 WPS Table Example (click to see larger image)

The goal to be achieved in this example:

1. After establishing the parametric equation of two circles, the graph of the WPS table is used to generate two circles.

2. Use the scroll bar control in the form toolbar to control the size and position of the two circles;

3, according to the size of the two circle and position to determine the position between them.

The production process is as follows:

First, the completion of the basic content of the worksheet input

1. In A1 cell, enter the title "Study the position relationship of circles and circles".

2. Because the center of the Circle is (a,b), the parametric equation of the circular radius r is:

We assume that the center coordinates of the two circles are (A1,B1), (A2,B2), and the radius of the two circles are R1 and R2 respectively.

3. Enter data labels in A3:F3: parameters (θ) [angles], parameters (θ) [radians], x1=a1+r1*cosθ, y1=b1+r1*sinθ, X2=a 2 +r2*cosθ, Y2=b2+r 2 *sinθ, and enter a theta value in column A using the quick input method.

4, complete the other basic information input (Figure 2).

Fig. 2 WPS table (click to see larger image)

Inserting a scroll bar control and setting related parameters

1, click the right mouse button in the blank position of the toolbar, find and click the form command in the pop-up shortcut menu, and bring up the form toolbar.

2, in the form toolbar click the scroll bar button, the mouse pointer changes to 10 font, press and hold the left mouse button from the K7 cell in the upper-right corner drag to complete the first scroll bar drawing.

3. Select the scroll bar just drawn, click the right mouse button, click "Format Object Formatting" in the pop-up shortcut menu, pop up the Format Object dialog box, click the "Control" tab, complete the setting of relevant parameters (Figure 3), close the dialog box.

Figure 3 WPS Set Object Format

4, the completion of several other scroll bar drawing, and the completion of the parameters of the set (parameter set below the table, please refer to the annex for detailed understanding).

5. In the following cells, enter the formula in sequence:

6, drag the mouse to select B4:f4, the mouse to move to the lower right corner of the control point, hold down the left button to drag down to F364, the use of fast input method to complete the formula. The preparation before the drawing is now complete.

Iii. drawing geometry with the chart Wizard

1, click the Chart Wizard button in the Common toolbar, pop-up Chart Type dialog box, in the chart type option, we select the "countless points smooth line scatter plot" in the xy (scatter) chart.

2, click the "Next" button below the dialog box, enter the "Source Data" dialog box, how can you draw two circles in the same chart? Click the Series tab above, click the Add button under Series options, click the Pick button to the right of the name option on the right, and zoom out of the Source Data dialog box. Click the C2 cell, and then click the Return button in the Source Data dialog box to complete the add name; The same method completes the addition of the x value, y value. Of course, you can also enter the formula directly to complete the above content Add (Figure 4).

Figure 4 WPS Source Data settings

3, click the "Add" button again under the "series" option, the same way to complete the circle two related content added. At this point you should be able to preview to two circles.

4, click "Next" button, go to the Chart Options dialog box, click on the top of the dialog box "grid Line" tab, select the main gridlines and minor gridlines for the value (x) axis and the value (y) axis, and then click the Legend tab above the dialog box to cancel the show legend Option to hide the legend.

5, click the "Finish" button, and end the chart drawing (Figure 5).

Fig. 5 WPS table (click to see larger image)

6, now use the mouse to drag the scroll bar, the size of the two circles, the position will change with 6 parameters change.

Set the format of the axis and beautify the image

Drag three scroll bars to return the value of the 6 parameter to the drawing's initial state. Hides the J column and adjusts the chart area size.

1, click the drop-down arrow to the right of the chart area option on the Chart toolbar, select Value (X) axis, then click the Format Chart button on the Chart toolbar to set the axis to a thicker blue, set font size to 12, and in the Scale tab, the minimum value (X) axis scale , maximum, major units, minor units are set to "15", "15", "5", "1", Cancel the check box in front of the above options (Figure 6), save the relevant settings.

Figure 6 WPS Value axis format setting

2, in a similar way to complete the chart area, plot area, value (x) axis major gridlines, value (x) axis minor gridlines, and other content settings, and adjust the chart position.

3, select the a2:f364 area, the text color set to white, hidden text, save the file.

Now, by dragging the scroll bar to change the value of the relevant parameter, you can change the size and position of the two circles, and the WPS table will determine the position relationship between the two circles and display the results in the I20 cell.