The spreadsheet of dynamic of our visible universe

We can not detect the expansion speed V of the universe of our galaxy when we are on the Earth.
Our visible universe is static and all galaxies have been deviating from us at speed Va since the beginning of Universe – when the Big Bang took place – even when galaxies were not formed yet and they were represented by quanta of energy, which originated them.

Dynamic of a galaxy P and its light in relation to Earth

The redshift Z of a galaxy P of our visible universe that was provided by Astronomy indicates its deviation speed Va. Knowing the actual age of universe T = 13,7 billion years calculated by Nasa, with an error around 1%, frequency F and also the wave’s length l that light is emitted, where:

f = 5,8928 x 1014 Hz.
l = 5,0909 x 10-7 m.
Logical Deductions created a spreadsheet that provides us the dynamic of galaxy P and of its photon that reaches us nowadays. It calculates the position P1 of galaxy P and the age T1 of universe when the photon was emitted
The time T2 when:
- galaxy goes from position P1 toward position P at speed Va, covering distance D3;
- the photon seen by an observer on Earth covers the distance P1-Earth(D1) at a speed c1 = c - Va.
- the photon, seen by an observer on P, covers the trajectory P-Earth(D) at speed c;
- the frequency of arrival of photon on the Earth that was changed by deviation speed Va from P. Dynamic between two galaxies- one of them is Milky Way (Earth) – for an observer on the reference frame of each one of them.

On the galaxy E reference frame | On the Earth reference frame

Creating the spreadsheet

For simulating the motion of a galaxy P in the visible universe, we need to define which one would be such galaxy P. Thus, we would need to know its deviation speed Va or its redshift Z. We know:
[1] The speed of light in vacuum::
c = 300.000 Km/s (or a unit of speed);
[2] The actual age of universe provided by NASA in 2003:
T = 13,7 billion years;
[3] The frequency of light’s emission:
f = 5,8928 x 1014 Hz;
[4] The wave’s length of light´s emission:
l= 5,0909 x 10-7 m.
We use variables:
Data of galaxy P (MUNICS S2F1 - 0323) that we want to study;
[5] We can use redshift Z
[5] or the deviation speed Va.

We calculate:

[6] If we use Va, we calculate the redshift Z defined by Science through the formula:

[6] If we use the redshift Z, we calculate the deviation speed Va, using the formula of Science:

[7] The distance D that galaxy P is from Earth. Galaxies deviate from Earth at their speeds Va. Although there was no galaxies in the initial instant of the creation there was the primordial grave for creating them, which correspondent points since the beginning deviate at their speeds Va;

D = Va x T

[8] The time T2 that the photon emitted by galaxy P takes to arrive at Earth, seen by observer on P, from where it was emitted at speed c; for such observer photon is always at speed c, according to his truth – he thinks he is standing still;
T2 = D/c

[9] The arrival speed c1 of photon at Earth, observed from it. According to Newtonian theories about speed composition, and the truth of the observer on Earth – who thinks he is standing still and he sees P deviates from him at speed Va. c1 = c - Va
c1 = c - Va

[10] The distance D1 between galaxy P and Earth when the photons were emitted from point P1;
D1 = c1 x T2;

[11] The distance D3 covered by galaxy from its position P1 toward P at speed Va;
D3 = Va x T2;

We must remember that on time T2:
- the galaxy P goes from P1 toward P at speed Va;
- the photon covers distance D at speed c for an observer on galaxy P.
- the photon covers distance D1, at speed c1 for an observer on Earth.
[12] The age of universe T1 on photon’s emission;
T1 = T - T2;
[13] The frequency f ’ of light’s arrival on Earth by formula of deviation Doppler.

[14] The ray of visible universe:
R = c x T

[15] Another way for calculating D1:
D1 = Va x T1
As we have already made the calculus we can see that for any galaxy P [15] = [16], which is an evidence of internal consistence of the spreadsheet.
[16] Another way for calculating f ‘, using the formula of undulatory physics v = l f ‘, where v = c.

For you testing the functioning of such spreadsheet, please download the spreadsheet of
visible universe using Va

It is amazing that the result above [16] has the same value of the result [13] of the formula of relativistic Doppler Effect; However, “Logical Deductions” interprets the frequency’s decrease (f ‘< f) as a direct consequence of speed c1 is smaller than c due to deviation Va (c1 < v).
[17] The value of Hubble constant H0 by astronomy’s formula:

While science empirically calculates the value of H0 , we calculate it through Va of galaxy and also the distance D, which is calculated through the Newtonian concept of light, it means, “photons are influenced by speed of their sources”. For any value of galaxy simulated on spreadsheet we can observer that its value is constant H0 = 71,386861314 Km/s/Mpc, which confers with the actual value provided by Science. Such value is valid for the actual age of universe T = 13,7 billion years, because H0 varies in accordance with the age T of universe.

For you testing the functioning of such spreadsheet, please download the spreadsheet of visible universe using Z by pressing here.