Contents

Four - USING THE SPREADSHEET

 

Before going any farther with the spreadsheet, it is best to check it and be certain that it is working correctly. To do this, first set the number one at D1 and the number three at F1. Now check the cells one by one to see if the following numbers appear there. If any one of them does not appear as shown, there is an error in the spreadsheet which you need to find by verifying the information in each cell.

Cell/Number
B1 / -.5
D1 / 1
F1 / 3
B2 / -1.5
D2 / .5
F2 / .5
B3 / 20,857,003
E3 / 32.25777559
B7 / 1,137.16567
D7 / 1,137.16567
F7 / 1,137.16567
H7 / 1,137.16567
B8 / 200,526.530
D8 / 200,526.530
F8 / 200,526.530
H8 / 200,526.530
C9 / .9999999999
B10 / 20,857,003

D10 / 20,857,103
F10 / 62,571,009
H10 / 62,571,109
B11 / 5,466.55446
D11 / 5,466.60688
F11 / 49,198.9902
H11 / 49,199.1474
C12 / 100
G12 / 100
B13 / 32.25777559
D13 / 32.25746626
F13 / 3.584197287
H13 / 3.584185831
C14 / 32.25762092
G14 / 3.584191559
C15 / 32.25762092
G15 / 3.584191559
C16 / .9999999998

G16 / .9999999999
B17 / 36,682.4352
D17 / 36,682.3473
F17 / 21,178.6138
H17 / 21,178.5969
B18 / 36,682.4352
D18 / 36,682.3473
F18 / 21,178.6138
H18 / 21,178.5969
C19 / 36,682.3913
G19 / 21,178.6054
B20 / 6.947430922
B21 / 1
D21 / .9999928082
F21 / .1924500897
H21 / .1924496283

---

If all of the numbers are correct on the previous page, change D1 to 2, make certain that the spreadsheet has re-calculated every cell, and then check it against the numbers that follow. If any one of them does not appear as shown, there is in error in the spreadsheet which you need to find by verifying information in each cell.

Cell/Number
B1 / -.5
D1 / 2
F1 / 3
B2 / -1.5
D2 / .5
F2 / .5
B3 / 20,857,003
E3 / 32.25777559
B7 / 1,137.16567
D7 / 1,137.16567
F7 / 1,137.16567
H7 / 1,137.16567
B8 / 401,053.060
D8 / 401,053.060
F8 / 401,053.060
H8 / 401,053.060
C9 / .9999999998
B10 / 20,857,003

D10 / 20,857,103
F10 / 62,571,009
H10 62,571,109
B11 / 5,466.55446
D11 / 5,466.60688
F11 / 49,198.9902
H11 / 49,199.1474
C12 / 100
G12 / 100
B13 / 64.51555118
D13 / 64.51493253
F13 / 7.168394575
H13 / 7.168371662
C14 / 64.51524185
G14 / 7.168383119
C15 / 64.51524185
G15 / 7.168383119
C16 / .9999999998

G16 / 1.000000000
B17 / 51,876.7974
D17 / 51,876.6730
F17 / 29,951.0829
H17 / 29,951.0590
B18 / 51,876.7974
D18 / 51,876.6730
F18 / 29,951.0829
H18 / 29,951.0590
C19 / 51,876.7352
G19 / 29,951.0710
B20 / 9.825151034
B21 / 1.414213562
D21 / 1.414203391
F21 / .2721655269
H21 / .2721648745

If you find that the numbers for the cells are correct, it is time to move on to using the spreadsheet in the manner in which it was intended.

---

Certain portions of the spreadsheet were isolated to allow the user to experiment with them. V exp, M exp, mr, mr exp V, mr exp M, and F may each be changed easily to see what the effects will be. In experimenting, the user will soon discover that the equations and values given herein are correct and that others do not work.

Now set D1 to one again and leave the other inputs as they are. Cycle the spreadsheet until all the calculations are complete. Now notice that certain equalities are present. They are as follows:

1.     All K values are the same. This is true only as long as we use the value of M=1 for sea level on earth. Setting a standard at a location below or above sea level on earth will change K, as will setting a standard at a different mass such as that of another celestial body. However, once a value for K has been established as a standard, this value can be used successfully anywhere. Its purpose then is to easily find the value of MV at any point in the universe as long as the gravity and the distance from the center of the body being used is known. MV is the mass flow at the point where it is calculated. However, M must be known to find V.

2.     All MVA values are the same. Since we are seeing Mass flowing in toward a body, the effect is like liquid flowing into a funnel. The flow rate at any of the funnel's cross-sections is the same. The cross-sections may have different velocities and different densities of the nether moving through them, and every cross-section is different, but the product of Mass times velocity times area will be the same. If it is different, then the something on the spreadsheet is not correct.

3.     The values for each average G should be essentially the same as the corresponding values for the difference in velocities. This is because G actually IS the difference in the velocities.

4.     The values at C9, C16, and G16 must be very very close to one.

As long as the above conditions are met, the values found at cells B1, B2, D2, and F2 will be all right. However, with experimentation, you will see that the values now in these cells are the only ones that will satisfy the conditions. You may begin by experimenting with each separately and then graduate to two or three at a time and you will find that this is true. You may also vary the formulae for finding velocities and Masses and the same will hold true.

Before you begin, you may wish to set D1 at one as this may make your task easier.

One thing that you may have noticed by this time is that the density of the nether increases as the nether flow moves toward the center of a body, while it is being pushed by pressure from outside and lack of pressure at the center. This appears to be a paradox. However, it seems that the nether is reluctant to alter its flow pattern as easily as it can alter its pressure directionally.

The inward flow through the funnel of a gravity well, such as a planet, is frictionless. It is as if the nether is sliding through a funnel whose sides have no friction whatsoever. This is logical since a gravity funnel has no sides.

The nether is also elastic and compressible, a quality easily verified with the dynamics of magnetism as explained in this series.

As the nether flows into the gravity funnel, it must decide what portion of it must go first, what part next, and what part last. In a fluid with inertia, this is not an easy thing. It requires a complete and constant re-routing of its flow pattern.

The end result is that it requires less energy for the nether to compress in two dimensions (the dimensions of the cross-section of its flow) than to re-route its flow pattern.

There is a tendency for it to expand a bit radially, but not a very great tendency. Consequently, the inward velocity is hindered but still increases as the nether moves inward, and the nether density is decreased in the radial dimension as it compresses in the plane of each sphere.

This may seem difficult to comprehend at first, but remember that the nether is not quite like air or water which prefers to adjust its flow rather than to compress. Both air and water are composed of vorticles in constant motion, so re-routing them is no big deal. The nether is not particulate (or vorticulate) and it behaves differently. Explaining this another way, the inertia of the nether is stronger than its resistance to compression, and it can compress relatively easily in two dimensions without easily expanding in the third.

I think of it as if the nether were like a group of horses all entering a chute at the same time from different directions. They are neck and neck, no nose is ahead of any other nose, and they are moving at the same speed which is fast. The chute has a slick fence on either side that funnels the horses into the chute. The horses can't slow down and they can't speed up. They are committed to going into that chute. What can they do? If they were the nether, they would simply compress and all would go through at once.

So what do we know of the nether so far?
 

Nether Qualities       Back

1.    Everything in the universe is composed of it.

2.     It is a perfect fluid in the sense that it is non-particulate.

4.     It is frictionless. There is no friction within it to prevent it from continuing to do whatever it is doing.

5.     It is compressible. In fact, it can compress in one dimension while expanding in another.

6.     It is energy conscious. It reacts to any change in a way that uses the least energy.

---

The major consequences of the above are:

(1)     It is in all of the space in our universe. Space is not empty.

(2)     Its density varies from place to place.

(3)    It becomes more dense as it approaches a mass.

(4)     It is constantly in motion.

(5)     Once its velocity is set, nether cannot be detected by normal means.

(6)     It can be detected by its acceleration or the acceleration of any vortices (matter) within it.

(7)     All energy is the consequence of motion within it.

(8)     All energy is transmitted by means of motion within it.

(9)     It may be considered "primal mass".

---

In this chapter, the notation has been that for spreadsheets with limited symbols available. Consequently, upper case letters have been used where normally lower case letters would have been used. This was done to allow the lower case letters to be free for use where normally subscript letters would have been used. For example, "G" was used to take the place of "g". What follows in this chapter departs from the foregoing and returns to the usually accepted letters with subscripts.

Average gravity for various heights can be very accurately determined by the following method. I do not know who else may have determined this method, but it is one I have found to be correct.

r_u = radius of sphere under
r_a = radius of sphere over
g_u = gravity at sphere under
g_a = gravity at sphere over
g_ave = average gravity between two spheres
T = Time interval
B = 1 / [(r_a / r_u) + 1]
g_ave = [Bg_u] + [(1 - B)_a]

The following is another method used in the spreadsheet to determine average gravity for various values of H and F.

r_a - r_u = H

H / v_ave = T

(v_u - v_a) / T = g_ave

Other useful formulae found in the spreadsheet follow.

v_e - v_a = (2r_eg_e) ^1/2 - (2r_ag_a) ^1/2 = g_avev_ave / H

or

v_s - v_h = (2r_sg_s) ^1/2 - (2r_hg_h) ^1/2 = g_avev_ave / H

In these formulae,

v_ave = (v_u + v_a) / 2 ,
v_ave = (v_e + v_a) / 2,
and v_ave = (v_s + v_h) / 2.
 

Contents - Next