Rozdíly

Zde můžete vidět rozdíly mezi vybranou verzí a aktuální verzí dané stránky.

--- fo:prepravky [17.07.2013 16:13]
Petr Vileta [Vyhodnocení]
+++ fo:prepravky [19.07.2013 21:56] (aktuální)
Petr Vileta
@@ Řádek 2: / Řádek 2: @@
 ====== Přepravní služby ======
 Zde jsou uvedeny některé přepravní služby a jejich ceny za přepravu. Aby srovnání bylo alespoň přibližné, musí se jednat o zásilku pojištěnou, v hodnotě do 5000 Kč. Ceny jsou uvedeny s DPH.
-Vzdálenosti jsou vybrány pouze 3, protože větší výpočty by byly při použité technice (plugin) téměř nemožné. Části mezivýpočty si moc nevšímejte. Plugin není Calc ani Excel a jinak to neumí.:-(
+Vzdálenosti jsou vybrány pouze 3, protože větší výpočty by byly při použité technice (plugin) téměř nemožné. Části "mezivýpočty" si moc nevšímejte. Plugin není Calc ani Excel a jinak to neumí.:-(
+===== Příplatky =====
+Všechny příplatky jsou k měsící červenci 2013 a jsou zahrnuty ve výpočtech.
+  - PPL
+    * ceny jsou uvedeny včetně všech příplatků
+    * v cenách je zahrnuta sleva 10% oproti běžným cenám
+  - TopTrans
+    * ceny jsou převzaty z kalkulačky na jejich webu
+  - DPD
+    * palivový příplatek 8% k ceně zásilky
+    * mýtné 0,45 Kč bez DPH za každý kilogram hhmotnosti
+  - Geis
+    * palivový příplatek 6% k ceně zásilky
+    * mýtné 0,44 Kč bez DPH za každý kilogram hhmotnosti
 ===== Koeficienty pravděpodobnosti =====
-Těmito koeficienty se vynásobí hodnota v části mezivýpočty. Měly by určovat pravděpodobnost, s jakou budeme posílat balíky určité váhy na konkrétní vzdálenost.
+Těmito koeficienty se vynásobí hodnota v části mezivýpočty. Měly by určovat pravděpodobnost, s jakou budeme posílat balíky určité hmotnosti na konkrétní vzdálenost.
 ^~~=label(ko)~~Trasa  ^0,5 kg  ^1 kg  ^5 kg  ^ 10 kg  ^ 25 kg  ^ 50 kg  ^
-|Plzeň-Praha    |  1.0|  0.8|  0.4|  0.3|  0.2|  0.1|
+|Plzeň-Praha    |  1.0|  0.8|  0.2|  0.1|  0.1|  0.1|
-|Plzeň-Brno     |  1.0|  0.8|  0.4|  0.3|  0.2|  0.1|
+|Plzeň-Brno     |  1.0|  0.8|  0.2|  0.1|  0.1|  0.1|
-|Plzeň-Ostrava  |  1.0|  0.8|  0.4|  0.3|  0.2|  0.1|
+|Plzeň-Ostrava  |  1.0|  0.8|  0.2|  0.1|  0.1|  0.1|
 ===== Balík bez dobírky =====
@@ Řádek 17: / Řádek 32: @@
 |  1|PPL      |  109|  109|  134|  173|  227|  575|
 |  2|TopTrans |   66|  130|  130|  193|  302|  408|
-|  3|DPD      |  ~~=round((89*1.21*1.08)+(0,45*1),0)~~|  ~~=round((89*1.21*1.08)+(0,45*1),0)~~|  ~~=round((113*1.21*1.08)+(0,45*5),0)~~|  ~~=round((143*1.21*1.08)+(0,45*10),0)~~|  ~~=round((174*1.21*1.08)+(0,45*25),0)~~|  ~~=round((410*1.21*1.08)+(0,45*50),0)~~|
+|  3|DPD      |  ~~=round(((89*1.08)+(0.45*1))*1.21,0)~~|  ~~=round(((89*1.08)+(0.45*1))*1.21,0)~~|  ~~=round(((113*1.08)+(0.45*5))*1.21,0)~~|  ~~=round(((143*1.08)+(0.45*10))*1.21,0)~~|  ~~=round(((174*1.08)+(0.45*25))*1.21,0)~~|  ~~=round(((410*1.08)+(0.45*50))*1.21,0)~~|
+|  4|Geis     |  ~~=round(((80*1.06)+(0.44*1))*1.21,0)~~|  ~~=round(((80*1.06)+(0.44*1))*1.21,0)~~|  ~~=round(((103*1.06)+(0.44*5))*1.21,0)~~|  ~~=round(((129*1.06)+(0.44*10))*1.21,0)~~|  ~~=round(((159*1.06)+(0.44*25))*1.21,0)~~|  ~~=round(((370*1.06)+(0.44*50))*1.21,0)~~|
 ^mezivýpočet^^^^^^^^
 |  |PPL      |  ~~=round(-ko.r1c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 |  |TopTrans |   ~~=round(-ko.r1c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 |  |DPD      |   ~~=round(-ko.r1c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
+|  |Geis     |  ~~=round(-ko.r1c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 ^body^^^^^^^^
 |  |PPL  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 |  |TopTrans  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 |  |DPD  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
+|  |Geis  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 ----
@@ Řádek 33: / Řádek 51: @@
 |  1|PPL      |  109|  109|  134|  173|  227|  575|
 |  2|TopTrans |   92|  184|  184|  246|  398|  553|
-|  3|DPD      |  ~~=round((89*1.21*1.08)+(0,45*1),0)~~|  ~~=round((89*1.21*1.08)+(0,45*1),0)~~|  ~~=round((113*1.21*1.08)+(0,45*5),0)~~|  ~~=round((143*1.21*1.08)+(0,45*10),0)~~|  ~~=round((174*1.21*1.08)+(0,45*25),0)~~|  ~~=round((410*1.21*1.08)+(0,45*50),0)~~|
+|  3|DPD      |  ~~=round(((89*1.08)+(0,45*1))*1.21,0)~~|  ~~=round(((89*1.08)+(0,45*1))*1.21,0)~~|  ~~=round(((113*1.08)+(0,45*5))*1.21,0)~~|  ~~=round(((143*1.08)+(0,45*10))*1.21,0)~~|  ~~=round(((174*1.08)+(0,45*25))*1.21,0)~~|  ~~=round(((410*1.08)+(0,45*50))*1.21,0)~~|
+|  4|Geis     |  ~~=round(((80*1.06)+(0.44*1))*1.21,0)~~|  ~~=round(((80*1.06)+(0.44*1))*1.21,0)~~|  ~~=round(((103*1.06)+(0.44*5))*1.21,0)~~|  ~~=round(((129*1.06)+(0.44*10))*1.21,0)~~|  ~~=round(((159*1.06)+(0.44*25))*1.21,0)~~|  ~~=round(((370*1.06)+(0.44*50))*1.21,0)~~|
 ^mezivýpočet^^^^^^^^
 |  |PPL      |  ~~=round(-ko.r2c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 |  |TopTrans |   ~~=round(-ko.r2c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 |  |DPD      |   ~~=round(-ko.r2c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
+|  |Geis     |  ~~=round(-ko.r1c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 ^body^^^^^^^^
 |  |PPL  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 |  |TopTrans  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 |  |DPD  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
+|  |Geis  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 ----
@@ Řádek 49: / Řádek 70: @@
 |  1|PPL      |  109|  109|  134|  173|  227|  575|
 |  2|TopTrans |  110|  209|  209|  308|  460|  643|
-|  3|DPD      |  ~~=round((89*1.21*1.08)+(0,45*1),0)~~|  ~~=round((89*1.21*1.08)+(0,45*1),0)~~|  ~~=round((113*1.21*1.08)+(0,45*5),0)~~|  ~~=round((143*1.21*1.08)+(0,45*10),0)~~|  ~~=round((174*1.21*1.08)+(0,45*25),0)~~|  ~~=round((410*1.21*1.08)+(0,45*50),0)~~|
+|  3|DPD      |  ~~=round(((89*1.08)+(0,45*1))*1.21,0)~~|  ~~=round(((89*1.08)+(0,45*1))*1.21,0)~~|  ~~=round(((113*1.08)+(0,45*5))*1.21,0)~~|  ~~=round(((143*1.08)+(0,45*10))*1.21,0)~~|  ~~=round(((174*1.08)+(0,45*25))*1.21,0)~~|  ~~=round(((410*1.08)+(0,45*50))*1.21,0)~~|
+|  4|Geis     |  ~~=round(((80*1.06)+(0.44*1))*1.21,0)~~|  ~~=round(((80*1.06)+(0.44*1))*1.21,0)~~|  ~~=round(((103*1.06)+(0.44*5))*1.21,0)~~|  ~~=round(((129*1.06)+(0.44*10))*1.21,0)~~|  ~~=round(((159*1.06)+(0.44*25))*1.21,0)~~|  ~~=round(((370*1.06)+(0.44*50))*1.21,0)~~|
 ^mezivýpočet^^^^^^^^
 |  |PPL      |  ~~=round(-ko.r3c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 |  |TopTrans |   ~~=round(-ko.r3c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 |  |DPD      |   ~~=round(-ko.r3c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
+|  |Geis     |  ~~=round(-ko.r1c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 ^body^^^^^^^^
 |  |PPL  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 |  |TopTrans  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 |  |DPD  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
+|  |Geis  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 ===== Balík s dobírkou do 5000 Kč =====
@@ Řádek 64: / Řádek 88: @@
 |  1|PPL      |  145|  145|  171|  209|  263|  611|
 |  2|TopTrans |   66|  130|  130|  193|  302|  408|
-|  3|DPD      |  ~~=round((89*1.21*1.08)+(0,45*1)+49,0)~~|  ~~=round((89*1.21*1.08)+(0,45*1)+49,0)~~|  ~~=round((113*1.21*1.08)+(0,45*5)+49,0)~~|  ~~=round((143*1.21*1.08)+(0,45*10)+49,0)~~|  ~~=round((174*1.21*1.08)+(0,45*25)+49,0)~~|  ~~=round((410*1.21*1.08)+(0,45*50)+49,0)~~|
+|  3|DPD      |  ~~=round(((89*1.08)+(0,45*1))*1.21+49,0)~~|  ~~=round(((89*1.08)+(0,45*1))*1.21+49,0)~~|  ~~=round(((113*1.08)+(0,45*5))*1.21+49,0)~~|  ~~=round(((143*1.08)+(0,45*10))*1.21+49,0)~~|  ~~=round(((174*1.08)+(0,45*25))*1.21+49,0)~~|  ~~=round(((410*1.08)+(0,45*50))*1.21+49,0)~~|
+|  4|Geis     |  ~~=round(((80*1.06)+(0.44*1))*1.21+45,0)~~|  ~~=round(((80*1.06)+(0.44*1))*1.21+45,0)~~|  ~~=round(((103*1.06)+(0.44*5))*1.21+45,0)~~|  ~~=round(((129*1.06)+(0.44*10))*1.21+45,0)~~|  ~~=round(((159*1.06)+(0.44*25))*1.21+45,0)~~|  ~~=round(((370*1.06)+(0.44*50))*1.21+45,0)~~|
 ^mezivýpočet^^^^^^^^
 |  |PPL      |  ~~=round(-ko.r1c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 |  |TopTrans |   ~~=round(-ko.r1c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 |  |DPD      |   ~~=round(-ko.r1c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
+|  |Geis      |   ~~=round(-ko.r1c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 ^body^^^^^^^^
 |  |PPL  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 |  |TopTrans  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 |  |DPD  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
+|  |Geis  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 ----
@@ Řádek 80: / Řádek 107: @@
 |  1|PPL      |  145|  145|  171|  209|  263|  611|
 |  2|TopTrans |   92|  184|  184|  246|  398|  553|
-|  3|DPD      |  ~~=round((89*1.21*1.08)+(0,45*1)+49,0)~~|  ~~=round((89*1.21*1.08)+(0,45*1)+49,0)~~|  ~~=round((113*1.21*1.08)+(0,45*5)+49,0)~~|  ~~=round((143*1.21*1.08)+(0,45*10)+49,0)~~|  ~~=round((174*1.21*1.08)+(0,45*25)+49,0)~~|  ~~=round((410*1.21*1.08)+(0,45*50)+49,0)~~|
+|  3|DPD      |  ~~=round((89*1.21*1.08)+(0,45*1)+49,0)~~|  ~~=round((89*1.21*1.08)+(0,45*1)+49,0)~~|  ~~=round(((113*1.08)+(0,45*5))*1.21+49,0)~~|  ~~=round(((143*1.08)+(0,45*10))*1.21+49,0)~~|  ~~=round(((174*1.08)+(0,45*25))*1.21+49,0)~~|  ~~=round(((410*1.08)+(0,45*50))*1.21+49,0)~~|
+|  4|Geis     |  ~~=round(((80*1.06)+(0.44*1))*1.21+45,0)~~|  ~~=round(((80*1.06)+(0.44*1))*1.21+45,0)~~|  ~~=round(((103*1.06)+(0.44*5))*1.21+45,0)~~|  ~~=round(((129*1.06)+(0.44*10))*1.21+45,0)~~|  ~~=round(((159*1.06)+(0.44*25))*1.21+45,0)~~|  ~~=round(((370*1.06)+(0.44*50))*1.21+45,0)~~|
 ^mezivýpočet^^^^^^^^
 |  |PPL      |  ~~=round(-ko.r2c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 |  |TopTrans |   ~~=round(-ko.r2c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 |  |DPD      |   ~~=round(-ko.r2c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r2c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
+|  |Geis      |   ~~=round(-ko.r1c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 ^body^^^^^^^^
 |  |PPL  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 |  |TopTrans  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 |  |DPD  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
+|  |Geis  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 ----
@@ Řádek 96: / Řádek 126: @@
 |  1|PPL      |  145|  145|  171|  209|  263|  611|
 |  2|TopTrans |  110|  209|  209|  308|  460|  643|
-|  3|DPD      |  ~~=round((89*1.21*1.08)+(0,45*1)+49,0)~~|  ~~=round((89*1.21*1.08)+(0,45*1)+49,0)~~|  ~~=round((113*1.21*1.08)+(0,45*5)+49,0)~~|  ~~=round((143*1.21*1.08)+(0,45*10)+49,0)~~|  ~~=round((174*1.21*1.08)+(0,45*25)+49,0)~~|  ~~=round((410*1.21*1.08)+(0,45*50)+49,0)~~|
+|  3|DPD      |  ~~=round(((89*1.08)+(0,45*1))*1.21+49,0)~~|  ~~=round(((89*1.08)+(0,45*1))*1.21+49,0)~~|  ~~=round(((113*1.08)+(0,45*5))*1.21+49,0)~~|  ~~=round(((143*1.08)+(0,45*10))*1.21+49,0)~~|  ~~=round(((174*1.08)+(0,45*25))*1.21+49,0)~~|  ~~=round(((410*1.08)+(0,45*50))*1.21+49,0)~~|
+|  4|Geis     |  ~~=round(((80*1.06)+(0.44*1))*1.21+45,0)~~|  ~~=round(((80*1.06)+(0.44*1))*1.21+45,0)~~|  ~~=round(((103*1.06)+(0.44*5))*1.21+45,0)~~|  ~~=round(((129*1.06)+(0.44*10))*1.21+45,0)~~|  ~~=round(((159*1.06)+(0.44*25))*1.21+45,0)~~|  ~~=round(((370*1.06)+(0.44*50))*1.21+45,0)~~|
 ^mezivýpočet^^^^^^^^
 |  |PPL      |  ~~=round(-ko.r3c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 |  |TopTrans |   ~~=round(-ko.r3c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 |  |DPD      |   ~~=round(-ko.r3c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r3c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
+|  |Geis      |   ~~=round(-ko.r1c1*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c2*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c3*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c4*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c5*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|  ~~=round(-ko.r1c6*(cell(col(),row()-max(c0r2:c0r99)-1)-max(range(col(),2,col(),max(c0r2:c0r99)+1)))/max(range(col(),2,col(),max(c0r2:c0r99)))*10000,0)~~|
 ^body^^^^^^^^
 |  |PPL  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 |  |TopTrans  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 |  |DPD  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
+|  |Geis  |  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|  ~~=round(cell(col(),row()-max(c0r2:c0r99)-1)/sum(range(col(),2*max(c0r2:c0r99),col(),3*max(c0r2:c0r99)-1))*100,0)~~|
 ===== Vyhodnocení =====
-ToDo
+<sortable r2>
+^Firma  ^Body celkem  ^
+|PPL       |  ~~=sum(t1c.r12c2:r12c7) + sum(t2c.r12c2:r12c7) + sum(t3c.r12c2:r12c7) + sum(t4c.r12c2:r12c7) + sum(t5c.r12c2:r12c7) + sum(t6c.r12c2:r12c7)~~|
+|TopTrans  |  ~~=sum(t1c.r13c2:r13c7) + sum(t2c.r13c2:r13c7) + sum(t3c.r13c2:r13c7) + sum(t4c.r13c2:r13c7) + sum(t5c.r13c2:r13c7) + sum(t6c.r13c2:r13c7)~~|
+|DPD       |  ~~=sum(t1c.r14c2:r14c7) + sum(t2c.r14c2:r14c7) + sum(t3c.r14c2:r14c7) + sum(t4c.r14c2:r14c7) + sum(t5c.r14c2:r14c7) + sum(t6c.r14c2:r14c7)~~|
+|Geis       |  ~~=sum(t1c.r15c2:r15c7) + sum(t2c.r15c2:r15c7) + sum(t3c.r15c2:r15c7) + sum(t4c.r15c2:r15c7) + sum(t5c.r15c2:r15c7) + sum(t6c.r15c2:r15c7)~~|
+</sortable>