~~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 =====
^ceny Plzeň-Praha^^^^^^^^
^~~=label(t1c)~~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 |   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)~~|

----

^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)~~|

===== Balík s dobírkou do 5000 Kč =====
^ceny Plzeň-Praha  ^^^^^^^^
^~~=label(t4c)~~No^Firma  ^0,5 kg  ^1 kg  ^5 kg  ^ 10 kg  ^ 25 kg  ^ 50 kg  ^
|  1|PPL      |  145|  145|  171|  209|  263|  611|
|  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)~~|

----

^ceny Plzeň-Brno  ^^^^^^^^
^~~=label(t5c)~~No^Firma  ^0,5 kg  ^1 kg  ^5 kg  ^ 10 kg  ^ 25 kg  ^ 50 kg  ^
|  1|PPL      |  145|  145|  171|  209|  263|  611|
|  2|TopTrans |   92|  184|  184|  246|  398|  553|
|  3|DPD      |  ~~=round((89*1.21*1.08)+(0,45*1)+49,0)~~|  ~~=round((89*1.21*1.08)+(0,45*1)+49,0)~~|  ~~=round(((113*1.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)~~|

----

^ceny Plzeň-Ostrava  ^^^^^^^^
^~~=label(t6c)~~No^Firma  ^0,5 kg  ^1 kg  ^5 kg  ^ 10 kg  ^ 25 kg  ^ 50 kg  ^
|  1|PPL      |  145|  145|  171|  209|  263|  611|
|  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>