For the Full timers, copy and paste in this order.
First one goes in A1 cell, in excel,
Second one goes in B1.......
Third one C1
Fourth one D1
Fifth one E1
Please note the text that is red in this post, you must change it to match
your years of service, wage and add any longevity pay and crew chief pay also.
A was sent to your adders back then with this info on it.
Also each of the formulas are for Fleet ONLY.
Keep in mind that do to rounding errors ti might be olus or minus a share or two.
Place in A1
=ROUND((((0.157965*14.03/176481.02*0.5) + (3/168162*0.5) + (0.067613/176481.02) + (0.13339/9058))*7340875),0)
Place in B1
=ROUND((((0.157965*14.03/176538.66*0.5) + (3/168225*0.5) + (0.067613/176538.66) + (0.13339/9061))*306542),0)
Place in C1
=ROUND((((0.157965*14.03/176538.66*0.5) + (3/168225*0.5) + (0.067613/176538.66) + (0.13339/9061))*238715),0)
Place in D1
=ROUND((((0.157965*14.03/176672.34*0.5) + (3/168335*0.5) + (0.067613/176672.34) + (0.13339/9068))*238715),0)
Place in E1
=ROUND((((0.157965*14.03/176672.34*0.5) + (3/168335*0.5) + (0.067613/176672.34) + (0.13339/9068))*1227366),0)
Now the Part Timers.
Place In A1
=ROUND((((0.157965*((21.16*0.7/176481.02*0.5)+(3/168162*0.5)))+(0.067613*(21.16*0.7/176481.02))+(0.13339/9058))*7340875),0)
Place in B1
=ROUND((((0.157965*((21.16*0.7/176538.66*0.5)+(10/168225*0.5)))+(0.067613*(21.16*0.7/176538.66))+(0.13339/9061))*306542),0)
Place in C1
=ROUND((((0.157965*((21.16*0.7/176538.66*0.5)+(10/168225*0.5)))+(0.067613*(21.16*0.7/176538.66))+(0.13339/9061))*238715),0)
Place in D1
=ROUND((((0.157965*((21.16*0.7/176672.34*0.5)+(10/168335*0.5)))+(0.067613*(21.16*0.7/176538.66))+(0.13339/9068))*232219),0)
Place in E1
=ROUND((((0.157965*((21.16*0.7/176672.34*0.5)+(10/168335*0.5)))+(0.067613*(21.16*0.7/176538.66))+(0.13339/9068))*1227366),0)
On a side note, The TWU was granted 10,867,112 shares of stock less 14% for hold back, for a remainder of 9,345,717 for all the members
of the TWU that we received.
And this is that the formula is Simplifyed
TWU (0.13339/NEP + (7 PS W)/(10 TWB) + SS (3703/(500 TWB) + Y/(2 AYS)))