Proving the veracity of our spreadsheets when our data are compared to Astronomy’s data.

Hubble constant

For Science

Science does not know many things about Cosmology. It just knows:
- the light´s speed c = 300.00 Km/s;
- the deviation of galaxies; it means, their speeds through Doppler Effect ( changes on light´s frequency with the deviation speed Va of each one of them);
- Distances covered by galaxy’s light toward us, through Hubble constant (H0). Such constant was measured by the astromers Edwin Hubble (1929) who had observationally concluded that the deviation speeds of galaxies are proportional to the distances of Earth, it means, H0 = Va / D, being D the distance of a galaxy at speed Va toward Earth.
Through the evolution of telescopes, it became possible to obtain a more exact value for H0 , with a margin of error around H0 = 71Km/s/Mpc.

According to Logical Deductions.

It is possible to calculate the value of Hubble constant through the spreadsheet of visible universe.
We use the fixed data of universe:
[1] Light´s speed: c = 1
[2] Universe’s age: T = 13,7 billion years
[3] Frequency of light on emission: f = 5,8928E+14 Hz
[4] Wave’s length of yellow light (sun) : l = 5,09090E-07 m
According to data of 2 galaxies chosen for been simulated their dynamic and light between them.
To determine the pair of galaxies, we use in the spreadsheet the expansion speeds Vt and Vp of galaxies L and P respectively and the angle Ô that the direction of vectors of such speeds form among themselves since Big Bang. Let’s consider that galaxy L is our Milky Way – where Earth is located in. Let’s also remember that as it was already demonstrated above, data of visible universe do not depend on its expansion speed. Thus, we can consider any value for speed Vt of Earth.
Then, we put data of galaxies L and P in the spreadsheet of real universe:
[5] Expansion speed of Earth: Vt = 1,2 c
[6] Expansion speed of galaxy P: Vp = 1,8 c
[7] Angle that the direction of Earth forms with the direction of galaxy P: ang Ô = 25º
With data above we can obtain the spreadsheet (6) of real universe.

In this spreadsheet, we obtain data of galaxies L(Earth) and galaxy P
[8] Actual distance from Earth toward the center of universe:
A = 16,44 billion light years.
[9] Actual distance from galaxy P toward the center of universe:
B = 24,66 billion light years
[10] Actual distance between Earth and galaxy P:
D = 11,980650862 billion light years.
[31] Deviation speed between galaxy P and Earth:
Va = 0,874500063 c
[37] Hubble constant
H0 = 71,386861314 Km/s/Mpc
with data above and data provided for galaxies L and P:
[5] Expansion speed of Earth: Vt = 1,2 c
[6] Expansion speed of galaxy P: Vp = 1,8 c
[7] Angle that direction of Earth forms with direction of galaxy P: ang Ô = 25º
We obtain the figure below:

where galaxy P is in the visible universe of L(Earth).
The most important about data above is the Hubble constant H0= 71,386861314 Km/s/Mpc, obtained by the division of H0=Va/D= 0,874500063/11,980650862 = 71,386861314. Such value confers with that one obtained by Science. H0 = 71 Km/s/Mpc.
And THE MOST IMPORTANT: Such value H0 remains constant in the simulation of any pair of galaxy of Universe. You can download the spreadsheet and test it
I want you to pay attention that when we know the universe’s age T, we are able to calculate Hubble constant H0 , so that we already have: H0 = 1/T.
It is also right, because a galaxy that is at a deviation speed as Va = 1c is far from Earth D = Va x T.
Thus, H0 = Va / D = Va / (Va x T) = 1/T
But we do not use the formula H0= 1/T to find the value of H0.
We use the age T of universe for calculating:
- The value of A, distance covered by galaxy L (Earth) since the beginning of universe until nowadays, A = Vt x T.
- The value of B, distance covered by galaxy P since the beginning of universe until nowadays, B = Vp x T.
We calculate Va , which does not depend on T, but it depends on Vp and Vt.
Calculating the triangle OPL, the value of D and then, we will find out: H0 = Va / D
Giving a better example:
Let’s change the value of angle Ô from 25º to 70º in the previous example. We will obtain the spreadsheet number 7.

and we will have the figure:

We can observer through the figure that galaxy P is out of visible universe of galaxy L(Earth), being that we can observer that many data can not be calculated.
With the sum of angles:
[21] Add2: Add2 = 256,76281º
[32] Add3: Add3 = 256,76281º
[37] Add4: Add4 = 103,23719º
Negative impossible numbers:
[12] Time galaxy took to reach point P1:
T1 = -10,816772907 billion years