Rozdíly

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

--- fo:prepravky [16.07.2013 16:47]
Petr Vileta [Balík bez dobírky]
+++ 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í.:-(
-test
+===== Příplatky =====
-|PPL      |  109|  109|  134|  173|  227|  575|
+Všechny příplatky jsou k měsící červenci 2013 a jsou zahrnuty ve výpočtech.
-|TopTrans |   66|  130|  130|  193|  302|  408|
-|TopTrans |   66|  130|  130|  193|  302|  408|
-| | **~~=max(c1r1:c1r3)~~** | **~~=max(c2r1:c2r3)~~** | **~~=max(c3r1:c3r3)~~** | **~~=max(c4r1:c4r3)~~** | **~~=max(c5r1:c5r3)~~** | **~~=max(c6r1:c6r3)~~** |
+  - 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 =====
-**ceny Plzeň-Praha**
+^ceny Plzeň-Praha^^^^^^^^
-^~~=label(tab1c)~~Firma  ^0,5 kg  ^1 kg  ^5 kg  ^ 10 kg  ^ 25 kg  ^ 50 kg  ^
+^~~=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|
-|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)~~|
-|      |  ~~=max(c1r0:c1r2)~~|  |  |  |  |  |
+|  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^^^^^^^^
-^~~=label(tab1b)~~body Plzeň-Praha  ^^^^^^^
+|  |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)~~|
-^Firma    ^0,5 kg  ^1 kg  ^5 kg  ^ 10 kg  ^ 25 kg  ^ 50 kg  ^
+|  |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)~~|
-|PPL      |  ~~=max(tab1c.c1r1:c1:r2)~~|  |  |  |  |  |
+|  |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)~~|
-|TopTrans |   |  |  |  |  |  |
+|  |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)~~|
-|DPD      |   |  |  |  |  |  |
+^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)~~|
 ----
+^ceny Plzeň-Brno  ^^^^^^^^
+^~~=label(t2c)~~No^Firma  ^0,5 kg  ^1 kg  ^5 kg  ^ 10 kg  ^ 25 kg  ^ 50 kg  ^
+|  1|PPL      |  109|  109|  134|  173|  227|  575|
+|  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)~~|
+----
+^ceny Plzeň-Ostrava  ^^^^^^^^
+^~~=label(t3c)~~No^Firma  ^0,5 kg  ^1 kg  ^5 kg  ^ 10 kg  ^ 25 kg  ^ 50 kg  ^
+|  1|PPL      |  109|  109|  134|  173|  227|  575|
+|  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)~~|
-^Název  ^Plzeň-Praha  ^^^^^^^^^^^^Body  ^
+===== Balík s dobírkou do 5000 Kč =====
-^společnosti  ^0,5 kg  ^body  ^1 kg  ^body  ^5 kg  ^body  ^ 10 kg  ^body  ^ 25 kg  ^body  ^ 50 kg  ^body  ^celkem  ^
+^ceny Plzeň-Praha  ^^^^^^^^
-|PPL      |  109|  ~~=max(r2c1:r4c1)~~|  109|  ?|  134|  ?|  173|  ?|  227|  ?|  575|  ?| |
+^~~=label(t4c)~~No^Firma  ^0,5 kg  ^1 kg  ^5 kg  ^ 10 kg  ^ 25 kg  ^ 50 kg  ^
-|TopTrans |   66|  ~~=max(r2c1:r4c1)~~|  130|  ?|  130|  ?|  193|  ?|  302|  ?|  408|  ?| |
+|  1|PPL      |  145|  145|  171|  209|  263|  611|
-|DPD      |  ~~=round((89*1.21*1.08)+(0,45*1),0)~~|  ~~=max(r4c1:r4c1)~~|  ~~=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)~~|  ?| |
+|  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      |  109|  ?|  109|  ?|  134|  ?|  173|  ?|  227|  ?|  575|  ?| |
+|  1|PPL      |  145|  145|  171|  209|  263|  611|
-|TopTrans |   92|  ?|  184|  ?|  184|  ?|  246|  ?|  398|  ?|  553|  ?| |
+|  2|TopTrans |   92|  184|  184|  246|  398|  553|
-|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.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      |  109|  ?|  109|  ?|  134|  ?|  173|  ?|  227|  ?|  575|  ?| |
+|  1|PPL      |  145|  145|  171|  209|  263|  611|
-|TopTrans |  110|  ?|  209|  ?|  209|  ?|  308|  ?|  460|  ?|  643|  ?| |
+|  2|TopTrans |  110|  209|  209|  308|  460|  643|
-|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+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)~~|
-===== Balík s dobírkou do 5000 Kč =====
+|  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)~~|
-^Název  ^Plzeň-Praha  ^^^^^^^^^^^^Body  ^
+^mezivýpočet^^^^^^^^
-^společnosti  ^0,5 kg  ^body  ^1 kg  ^body  ^5 kg  ^body  ^ 10 kg  ^body  ^ 25 kg  ^body  ^ 50 kg  ^body  ^celkem  ^
+|  |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)~~|
-|PPL      |  145|  ?|  145|  ?|  171|  ?|  209|  ?|  263|  ?|  611|  ?| |
+|  |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)~~|
-|TopTrans |   66|  ?|  130|  ?|  130|  ?|  193|  ?|  302|  ?|  408|  ?| |
+|  |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)~~|
-|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)~~|  ?| |
+|  |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>
-^Název  ^Plzeň-Brno  ^^^^^^^^^^^^Body  ^
+^Firma  ^Body celkem  ^
-^společnosti  ^0,5 kg  ^body  ^1 kg  ^body  ^5 kg  ^body  ^ 10 kg  ^body  ^ 25 kg  ^body  ^ 50 kg  ^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)~~|
-|PPL      |  145|  ?|  145|  ?|  171|  ?|  209|  ?|  263|  ?|  611|  ?| |
+|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)~~|
-|TopTrans |   92|  ?|  184|  ?|  184|  ?|  246|  ?|  398|  ?|  553|  ?| |
+|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)~~|
-|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)~~|  ?| |
+|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>
-----
-^Název  ^Plzeň-Ostrava  ^^^^^^^^^^^^Body  ^
-^společnosti  ^0,5 kg  ^body  ^1 kg  ^body  ^5 kg  ^body  ^ 10 kg  ^body  ^ 25 kg  ^body  ^ 50 kg  ^body  ^celkem  ^
-|PPL      |  145|  ?|  145|  ?|  171|  ?|  209|  ?|  263|  ?|  611|  ?| |
-|TopTrans |  110|  ?|  209|  ?|  209|  ?|  308|  ?|  460|  ?|  643|  ?| |
-|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)~~|  ?| |