Rozdíly

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

--- fo:prepravky [12.07.2013 23:43]
Petr Vileta
+++ fo:prepravky [19.07.2013 21:56] (aktuální)
Petr Vileta
@@ Řádek 1: / Řádek 1: @@
+~~NOTOC~~
 ====== 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í.:-(
+===== 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é 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.2|  0.1|  0.1|  0.1|
+|Plzeň-Brno     |  1.0|  0.8|  0.2|  0.1|  0.1|  0.1|
+|Plzeň-Ostrava  |  1.0|  0.8|  0.2|  0.1|  0.1|  0.1|
 ===== Balík bez dobírky =====
-^Název  ^Plzeň-Praha  ^^^^^^^^^^^^Body  ^
+^ceny Plzeň-Praha^^^^^^^^
-^společnosti  ^0,5 kg  ^body  ^1 kg  ^body  ^5 kg  ^body  ^ 10 kg  ^body  ^ 25 kg  ^body  ^ 50 kg  ^body  ^celkem  ^
+^~~=label(t1c)~~No^Firma  ^0,5 kg  ^1 kg  ^5 kg  ^ 10 kg  ^ 25 kg  ^ 50 kg  ^
-|PPL      |  109|  ?|  109|  ?|  134|  ?|  173|  ?|  227|  ?|  575|  ?| |
+|  1|PPL      |  109|  109|  134|  173|  227|  575|
-|TopTrans |   66|  ?|  130|  ?|  130|  ?|  193|  ?|  302|  ?|  408|  ?| |
+|  2|TopTrans |   66|  130|  130|  193|  302|  408|
+|  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)~~|
 ----
-^Název  ^Plzeň-Brno  ^^^^^^^^^^^^Body  ^
+^ceny Plzeň-Brno  ^^^^^^^^
-^společnosti  ^0,5 kg  ^body  ^1 kg  ^body  ^5 kg  ^body  ^ 10 kg  ^body  ^ 25 kg  ^body  ^ 50 kg  ^body  ^celkem  ^
+^~~=label(t2c)~~No^Firma  ^0,5 kg  ^1 kg  ^5 kg  ^ 10 kg  ^ 25 kg  ^ 50 kg  ^
-|PPL      |  109|  ?|  109|  ?|  134|  ?|  173|  ?|  227|  ?|  575|  ?| |
+|  1|PPL      |  109|  109|  134|  173|  227|  575|
-|TopTrans |   92|  ?|  184|  ?|  184|  ?|  246|  ?|  398|  ?|  553|  ?| |
+|  2|TopTrans |   92|  184|  184|  246|  398|  553|
+|  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)~~|
 ----
-^Název  ^Plzeň-Ostrava  ^^^^^^^^^^^^Body  ^
+^ceny Plzeň-Ostrava  ^^^^^^^^
-^společnosti  ^0,5 kg  ^body  ^1 kg  ^body  ^5 kg  ^body  ^ 10 kg  ^body  ^ 25 kg  ^body  ^ 50 kg  ^body  ^celkem  ^
+^~~=label(t3c)~~No^Firma  ^0,5 kg  ^1 kg  ^5 kg  ^ 10 kg  ^ 25 kg  ^ 50 kg  ^
-|PPL      |  109|  ?|  109|  ?|  134|  ?|  173|  ?|  227|  ?|  575|  ?| |
+|  1|PPL      |  109|  109|  134|  173|  227|  575|
-|TopTrans |  110|  ?|  209|  ?|  209|  ?|  308|  ?|  460|  ?|  643|  ?| |
+|  2|TopTrans |  110|  209|  209|  308|  460|  643|
+|  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č =====
-^Název  ^Plzeň-Praha  ^^^^^^^^^^^^Body  ^
+^ceny Plzeň-Praha  ^^^^^^^^
-^společnosti  ^0,5 kg  ^body  ^1 kg  ^body  ^5 kg  ^body  ^ 10 kg  ^body  ^ 25 kg  ^body  ^ 50 kg  ^body  ^celkem  ^
+^~~=label(t4c)~~No^Firma  ^0,5 kg  ^1 kg  ^5 kg  ^ 10 kg  ^ 25 kg  ^ 50 kg  ^
-|PPL      |  145|  ?|  145|  ?|  171|  ?|  209|  ?|  263|  ?|  611|  ?| |
+|  1|PPL      |  145|  145|  171|  209|  263|  611|
-|TopTrans |   66|  ?|  130|  ?|  130|  ?|  193|  ?|  302|  ?|  408|  ?| |
+|  2|TopTrans |   66|  130|  130|  193|  302|  408|
+|  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)~~|
 ----
-^Název  ^Plzeň-Brno  ^^^^^^^^^^^^Body  ^
+^ceny Plzeň-Brno  ^^^^^^^^
-^společnosti  ^0,5 kg  ^body  ^1 kg  ^body  ^5 kg  ^body  ^ 10 kg  ^body  ^ 25 kg  ^body  ^ 50 kg  ^body  ^celkem  ^
+^~~=label(t5c)~~No^Firma  ^0,5 kg  ^1 kg  ^5 kg  ^ 10 kg  ^ 25 kg  ^ 50 kg  ^
-|PPL      |  145|  ?|  145|  ?|  171|  ?|  209|  ?|  263|  ?|  611|  ?| |
+|  1|PPL      |  145|  145|  171|  209|  263|  611|
-|TopTrans |   92|  ?|  184|  ?|  184|  ?|  246|  ?|  398|  ?|  553|  ?| |
+|  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.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)~~|
 ----
-^Název  ^Plzeň-Ostrava  ^^^^^^^^^^^^Body  ^
+^ceny Plzeň-Ostrava  ^^^^^^^^
-^společnosti  ^0,5 kg  ^body  ^1 kg  ^body  ^5 kg  ^body  ^ 10 kg  ^body  ^ 25 kg  ^body  ^ 50 kg  ^body  ^celkem  ^
+^~~=label(t6c)~~No^Firma  ^0,5 kg  ^1 kg  ^5 kg  ^ 10 kg  ^ 25 kg  ^ 50 kg  ^
-|PPL      |  145|  ?|  145|  ?|  171|  ?|  209|  ?|  263|  ?|  611|  ?| |
+|  1|PPL      |  145|  145|  171|  209|  263|  611|
-|TopTrans |  110|  ?|  209|  ?|  209|  ?|  308|  ?|  460|  ?|  643|  ?| |
+|  2|TopTrans |  110|  209|  209|  308|  460|  643|
+|  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í =====
+<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>