{"text_format":"2","workbook":"xlsx","n_sheets":22,"sheets":["Úvod","CBA - Agendové IS","Analyza citlivosti - AgendovéIS","Prínosy - Agendové IS","Výdavky - Agendové IS","Spotrebované cloudové služby","Parametre - Agendové IS","TCO","TCO - SW","TCO - HW","Faktory","Podklady>>>","TCO - Riešenie (bez HW a DB)","SW a aplikacie","eGovCloud - Parametre","Sumar MDs","Registre","Ciselniky","Klasifikacia pre Impl","Štandardné aktivity","Prinosy","MD rates"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Úvod","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[25,0,25,1],[25,2,25,8],[5,0,5,8],[7,0,9,8],[21,0,21,1],[21,2,21,8],[22,0,22,1],[22,2,22,8],[18,0,18,1],[18,2,18,8],[19,0,19,1],[19,2,19,8],[20,0,20,1],[20,2,20,8],[32,0,34,8],[30,6,31,7],[30,8,31,8],[6,0,6,8],[26,0,26,1],[26,2,26,8],[27,0,27,1],[27,2,27,8],[29,0,29,8],[30,0,31,1],[30,2,31,3],[30,4,31,5],[23,0,23,1],[23,2,23,8],[24,0,24,1],[24,2,24,8]]}
[]
[]
[]
[]
[]
["Príloha pre výpočet TCO a čistej súčasnej hodnoty z projektu"]
["Pre projekty zamerané na služby agendových informačných systémov"]
["Metodický pokyn k vypracovaniu finančnej analýzy projektu, analýzy nákladov a prínosov projektu a finančnej analýzy žiadateľa o NFP v programovom období 2014 – 2020."]
{"$rows_empty":10}
["Názov riešenia",null,"Konsolidovaná údajová základňa rezortu zdravotníctva"]
["Číslo projektu ITMS",null,"projekt_279"]
["Kód ISVS z MetaIS",null,"isvs_8125"]
["Organizácia",null,"Ministerstvo zdravotníctva Slovenskej republiky"]
["Ulica",null,"Limbová 2, Bratislava"]
["PSČ",null,"831 01"]
["Web",null,"http://www.health.gov.sk/"]
["IČO",null,"00165565"]
["Spracovateľ",null,"    Titul, Meno, Priezvisko"]
["Kontakt na spracovateľa    ",null,"    Email, telefón"]
[]
["Jednotlivé informácie sú farebne odlíšené nasledovne:"]
["Hlavička tabuľky",null,"Popisná informácia",null,"Automaticky vypočitavané hodnoty",null,"Miesto na vpisovanie vlastných hodnôt",null,"Preddefinované konštanty"]

{"sheet":"CBA - Agendové IS","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,10,2,11],[0,1,0,6],[0,7,0,11],[1,1,1,3],[1,4,1,6],[1,10,1,11]]}
[null,"Cashflow projektu",{"$nulls":5},"Čistá súčasná hodnota z projektu"]
[null,"Finančný cashflow",null,null,"Ekonomický cashflow",null,null,"koeficient obdobia","Finančná (FNPV)","Ekonomická (ENPV)","Kumulovaná diskont. návratnosť ENPV"]
["Obdobie","Alternat. A","Alternat. B","rozdiel","Alternat. A","Alternat. B","rozdiel"]
["t1",{"$f":"'Prínosy - Agendové IS'!Q4-'Výdavky - Agendové IS'!Q4","v":0},{"$f":"'Prínosy - Agendové IS'!R4-'Výdavky - Agendové IS'!R4","v":-5991305.00605},{"$f":"C4-B4","v":-5991305.00605},{"$f":"'Prínosy - Agendové IS'!T4-'Výdavky - Agendové IS'!Q4","v":0},{"$f":"'Prínosy - Agendové IS'!U4-'Výdavky - Agendové IS'!R4","v":-5991305.00605},{"$f":"F4-E4","v":-5991305.00605},0,{"$f":"D4*(1/(1+Faktory!$D$3)^H4)","v":-5991305.00605},{"$f":"G4*(1/(1+Faktory!$D$5)^H4)","v":-5991305.00605},{"$f":"J4","v":-5991305.00605},{"$f":"IF(K4>0,\"Rok návratu investície\",\"<\")","v":"<"}]
["t2",{"$f":"'Prínosy - Agendové IS'!Q5-'Výdavky - Agendové IS'!Q5","v":0},{"$f":"'Prínosy - Agendové IS'!R5-'Výdavky - Agendové IS'!R5","v":-4000580.9394750004},{"$f":"C5-B5","v":-4000580.9394750004},{"$f":"'Prínosy - Agendové IS'!T5-'Výdavky - Agendové IS'!Q5","v":0},{"$f":"'Prínosy - Agendové IS'!U5-'Výdavky - Agendové IS'!R5","v":-4000580.9394750004},-4000580.9394750004,1,{"$f":"D5*(1/(1+Faktory!$D$3)^H5)","v":-3846712.4418028845},{"$f":"G5*(1/(1+Faktory!$D$5)^H5)","v":-3810077.0852142856},{"$f":"J5+K4","v":-9801382.0912642851},{"$f":"IF(L4=\"<\",IF(K5>0,\"Rok návratu investície\",\"<\"),\">\")","v":"<"}]
["t3",{"$f":"'Prínosy - Agendové IS'!Q6-'Výdavky - Agendové IS'!Q6","v":0},{"$f":"'Prínosy - Agendové IS'!R6-'Výdavky - Agendové IS'!R6","v":-3815044.6834750003},-3815044.6834750003,{"$f":"'Prínosy - Agendové IS'!T6-'Výdavky - Agendové IS'!Q6","v":0},{"$f":"'Prínosy - Agendové IS'!U6-'Výdavky - Agendové IS'!R6","v":-3815044.6834750003},-3815044.6834750003,2,{"$f":"D6*(1/(1+Faktory!$D$3)^H6)","v":-3527223.2650471521},{"$f":"G6*(1/(1+Faktory!$D$5)^H6)","v":-3460357.9895464852},{"$f":"J6+K5","v":-13261740.08081077},{"$f":"IF(L5=\"<\",IF(K6>0,\"Rok návratu investície\",\"<\"),\">\")","v":"<"}]
["t4",{"$f":"'Prínosy - Agendové IS'!Q7-'Výdavky - Agendové IS'!Q7","v":-4239000},{"$f":"'Prínosy - Agendové IS'!R7-'Výdavky - Agendové IS'!R7","v":-2907513.9882499999},1331486.0117500001,{"$f":"'Prínosy - Agendové IS'!T7-'Výdavky - Agendové IS'!Q7","v":-4239000},{"$f":"'Prínosy - Agendové IS'!U7-'Výdavky - Agendové IS'!R7","v":-2462178.3235416664},1776821.6764583336,3,{"$f":"D7*(1/(1+Faktory!$D$3)^H7)","v":1183686.2160670089},{"$f":"G7*(1/(1+Faktory!$D$5)^H7)","v":1534885.3700104381},-11726854.710800333,"<"]
["t5",{"$f":"'Prínosy - Agendové IS'!Q8-'Výdavky - Agendové IS'!Q8","v":-4239000},{"$f":"'Prínosy - Agendové IS'!R8-'Výdavky - Agendové IS'!R8","v":-1942513.9882499999},2296486.0117500001,{"$f":"'Prínosy - Agendové IS'!T8-'Výdavky - Agendové IS'!Q8","v":-4239000},{"$f":"'Prínosy - Agendové IS'!U8-'Výdavky - Agendové IS'!R8","v":-1563177.5464166666},2675822.4535833336,4,{"$f":"D8*(1/(1+Faktory!$D$3)^H8)","v":1963045.8674850399},{"$f":"G8*(1/(1+Faktory!$D$5)^H8)","v":2201405.7546666944},-9525448.9561336376,"<"]
["t6",{"$f":"'Prínosy - Agendové IS'!Q9-'Výdavky - Agendové IS'!Q9","v":-4239000},{"$f":"'Prínosy - Agendové IS'!R9-'Výdavky - Agendové IS'!R9","v":-1872513.9882499999},2366486.0117500001,{"$f":"'Prínosy - Agendové IS'!T9-'Výdavky - Agendové IS'!Q9","v":-4239000},{"$f":"'Prínosy - Agendové IS'!U9-'Výdavky - Agendové IS'!R9","v":-1417787.8804027778},2821212.1195972222,5,{"$f":"D9*(1/(1+Faktory!$D$3)^H9)","v":1945079.0008241544},{"$f":"G9*(1/(1+Faktory!$D$5)^H9)","v":2210493.5168623673},-7314955.4392712703,"<"]
["t7",{"$f":"'Prínosy - Agendové IS'!Q10-'Výdavky - Agendové IS'!Q10","v":-4239000},{"$f":"'Prínosy - Agendové IS'!R10-'Výdavky - Agendové IS'!R10","v":-1817513.9882499999},2421486.0117500001,{"$f":"'Prínosy - Agendové IS'!T10-'Výdavky - Agendové IS'!Q10","v":-4239000},{"$f":"'Prínosy - Agendové IS'!U10-'Výdavky - Agendové IS'!R10","v":-1290175.9921666668},2948824.0078333332,6,{"$f":"D10*(1/(1+Faktory!$D$3)^H10)","v":1913735.5689383834},{"$f":"G10*(1/(1+Faktory!$D$5)^H10)","v":2200457.8766169609},-5114497.562654309,"<"]
["t8",{"$f":"'Prínosy - Agendové IS'!Q11-'Výdavky - Agendové IS'!Q11","v":-4239000},{"$f":"'Prínosy - Agendové IS'!R11-'Výdavky - Agendové IS'!R11","v":-1707513.9882499999},2531486.0117500001,{"$f":"'Prínosy - Agendové IS'!T11-'Výdavky - Agendové IS'!Q11","v":-4239000},{"$f":"'Prínosy - Agendové IS'!U11-'Výdavky - Agendové IS'!R11","v":-1135064.1039305555},3103935.8960694447,7,{"$f":"D11*(1/(1+Faktory!$D$3)^H11)","v":1923721.3142006728},{"$f":"G11*(1/(1+Faktory!$D$5)^H11)","v":2205909.2912572636},-2908588.2713970453,"<"]
["t9",{"$f":"'Prínosy - Agendové IS'!Q12-'Výdavky - Agendové IS'!Q12","v":-4239000},{"$f":"'Prínosy - Agendové IS'!R12-'Výdavky - Agendové IS'!R12","v":-1707513.9882499999},2531486.0117500001,{"$f":"'Prínosy - Agendové IS'!T12-'Výdavky - Agendové IS'!Q12","v":-4239000},{"$f":"'Prínosy - Agendové IS'!U12-'Výdavky - Agendové IS'!R12","v":-1053285.5490277777},3185714.4509722223,8,{"$f":"D12*(1/(1+Faktory!$D$3)^H12)","v":1849732.0328852618},{"$f":"G12*(1/(1+Faktory!$D$5)^H12)","v":2156216.9366016085},-752371.33479543682,"<"]
["t10",{"$f":"'Prínosy - Agendové IS'!Q13-'Výdavky - Agendové IS'!Q13","v":-4239000},{"$f":"'Prínosy - Agendové IS'!R13-'Výdavky - Agendové IS'!R13","v":-1707513.9882499999},2531486.0117500001,{"$f":"'Prínosy - Agendové IS'!T13-'Výdavky - Agendové IS'!Q13","v":-4239000},{"$f":"'Prínosy - Agendové IS'!U13-'Výdavky - Agendové IS'!R13","v":-889728.43922222219},3349271.5607777778,9,{"$f":"D13*(1/(1+Faktory!$D$3)^H13)","v":1778588.4931589053},{"$f":"G13*(1/(1+Faktory!$D$5)^H13)","v":2158970.3109120536},1406598.9761166167,"Rok návratu investície"]
["SPOLU",{"$f":"SUM(B4:B13)","v":-29673000},-27469528.546749994,2203471.4532499979,-29673000,-23618328.463708334,6054671.5362916663,"SPOLU",{"$f":"SUM(I4:I13)","v":-807652.21934060985},{"$f":"SUM(J4:J13)","v":1406598.9761166167}]

{"sheet":"Analyza citlivosti - AgendovéIS","index":2,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,"ENPV",-3,-0.6,-0.4,-0.01,0,0.01,0.4,0.6,2]
[{"$f":"'Parametre - Agendové IS'!A3:A3","v":"Počet podaní"},0,{"$f":"'CBA - Agendové IS'!$J$14","v":1406598.9761166167},5114601.5205713827,2148199.4850075697,1900999.3153772522,1418958.9845981314,1406598.9761166167,1394238.9676351002,912198.63685598015,664998.46722566104,-1065402.7201865637]
[null,null,null,-3,-0.6,-0.4,-0.01,0,0.01,0.4,0.6,2]
[{"$f":"'Parametre - Agendové IS'!A13:A13","v":"Výška administratívneho poplatku"},0,{"$f":"'CBA - Agendové IS'!$J$14","v":1406598.9761166167},1406598.9761166167,1406598.9761166167,1406598.9761166167,1406598.9761166167,1406598.9761166167,1406598.9761166167,1406598.9761166167,1406598.9761166167,1406598.9761166167]
[null,null,null,-3,-0.6,-0.4,-0.01,0,0.01,0.4,0.6,2]
[{"$f":"'Parametre - Agendové IS'!A23:A23","v":"Trvanie spracovania podania"},0,{"$f":"'CBA - Agendové IS'!$J$14","v":1406598.9761166167},5114601.5205713827,2148199.4850075697,1900999.3153772522,1418958.9845981314,1406598.9761166167,1394238.9676351002,912198.63685598015,664998.46722566104,-1065402.7201865637]
[null,null,null,-3,-0.6,-0.4,-0.01,0,0.01,0.4,0.6,2]
[{"$f":"'Parametre - Agendové IS'!A33:A33","v":"Priemerný čas potrebný na vypracovanie a doručenie podania"},0,{"$f":"'CBA - Agendové IS'!$J$14","v":1406598.9761166167},1406598.9761166167,1406598.9761166167,1406598.9761166167,1406598.9761166167,1406598.9761166167,1406598.9761166167,1406598.9761166167,1406598.9761166167,1406598.9761166167]
[null,null,null,-3,-0.6,-0.4,-0.01,0,0.01,0.4,0.6,2]
[{"$f":"'Parametre - Agendové IS'!A43:A43","v":"Počet zamestnancov vybavujúcich agendu"},0,{"$f":"'CBA - Agendové IS'!$J$14","v":1406598.9761166167},5114601.5205713827,2148199.4850075697,1900999.3153772522,1418958.9845981314,1406598.9761166167,1394238.9676351002,912198.63685598015,664998.46722566104,-1065402.7201865637]
[null,null,null,-3,-0.6,-0.4,-0.01,0,0.01,0.4,0.6,2]
[{"$f":"'Parametre - Agendové IS'!A53:A53","v":"Kvalitatívne prínosy - úspora prevádzkových nákladov z migrácie do cloudu"},0,{"$f":"'CBA - Agendové IS'!$J$14","v":1406598.9761166167},-7063496.3769929344,-287420.09450529655,277252.92903534113,1378365.3249395839,1406598.9761166167,1434832.6272936473,2535945.0231978865,3100618.0467385259,7053329.2115229806]

{"sheet":"Prínosy - Agendové IS","index":3,"n_rows":14,"n_cols":22,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,4,0,15],[0,16,0,21],[1,1,1,3],[1,4,1,6],[1,7,1,9],[1,13,1,15],[1,16,1,18],[1,19,1,21],[1,10,1,12]]}
[null,"Priame prínosy",null,null,"Nepriame prínosy",{"$nulls":11},"Prínosy spolu"]
[null,"Administratívne poplatky",null,null,"Ostatné daňové a nedaňové príjmy",null,null,"Cena ušetreného času používateľa",null,null,"Úspora z prevádzky pri využívaní cloudových služieb",null,null,"Kvalitatívne prínosy vo finančnom vyjadrení",null,null,"Finančné prínosy",null,null,"Ekonomické prínosy"]
["Obdobie","Alternat. A","Alternat. B","rozdiel","Alternat. A","Alternat. B","rozdiel","Alternat. A","Alternat. B","rozdiel","Alternat. A","Alternat. B","rozdiel","Alternat. A","Alternat. B","rozdiel","Alternat. A","Alternat. B","rozdiel","Alternat. A","Alternat. B","rozdiel"]
["t1",{"$f":"IF(ISERR('Parametre - Agendové IS'!D3*'Parametre - Agendové IS'!D13),\"-\",'Parametre - Agendové IS'!D3*'Parametre - Agendové IS'!D13)","v":"-"},{"$f":"IF(ISERR('Parametre - Agendové IS'!E3*'Parametre - Agendové IS'!E13),\"-\",'Parametre - Agendové IS'!E3*'Parametre - Agendové IS'!E13)","v":"-"},{"$f":"IF(ISERR(C4-B4),\"-\",C4-B4)","v":"-"},null,null,{"$f":"IF(ISERR(F4-E4),\"-\",F4-E4)","v":0},0,{"$f":"IF(ISERR(Faktory!$D$11*'Parametre - Agendové IS'!E3*('Parametre - Agendové IS'!D33-'Parametre - Agendové IS'!E33)),\"-\",Faktory!$D$11*'Parametre - Agendové IS'!E3*('Parametre - Agendové IS'!D33-'Parametre - Agendové IS'!E33))","v":"-"},{"$f":"IF(ISERR(I4-H4),\"-\",I4-H4)","v":"-"},{"$f":"'Spotrebované cloudové služby'!D3","v":0},{"$f":"'Spotrebované cloudové služby'!E3","v":0},{"$f":"IF(ISERR(K4-L4),\"-\",K4-L4)","v":0},{"$f":"'Parametre - Agendové IS'!D53","v":0},{"$f":"'Parametre - Agendové IS'!E53","v":0},{"$f":"IF(ISERR(O4-N4),\"-\",O4-N4)","v":0},{"$f":"SUM(B4,E4)","v":0},{"$f":"SUM(C4,F4)","v":0},{"$f":"R4-Q4","v":0},{"$f":"SUM(H4,K4,N4,Q4)","v":0},{"$f":"SUM(I4,L4,O4,R4)","v":0},{"$f":"U4-T4","v":0}]
["t2",{"$f":"IF(ISERR('Parametre - Agendové IS'!D4*'Parametre - Agendové IS'!D14),\"-\",'Parametre - Agendové IS'!D4*'Parametre - Agendové IS'!D14)","v":"-"},{"$f":"IF(ISERR('Parametre - Agendové IS'!E4*'Parametre - Agendové IS'!E14),\"-\",'Parametre - Agendové IS'!E4*'Parametre - Agendové IS'!E14)","v":"-"},{"$f":"IF(ISERR(C5-B5),\"-\",C5-B5)","v":"-"},null,null,0,0,{"$f":"IF(ISERR(Faktory!$D$11*'Parametre - Agendové IS'!E4*('Parametre - Agendové IS'!D34-'Parametre - Agendové IS'!E34)),\"-\",Faktory!$D$11*'Parametre - Agendové IS'!E4*('Parametre - Agendové IS'!D34-'Parametre - Agendové IS'!E34))","v":"-"},{"$f":"IF(ISERR(I5-H5),\"-\",I5-H5)","v":"-"},{"$f":"'Spotrebované cloudové služby'!D4","v":0},{"$f":"'Spotrebované cloudové služby'!E4","v":0},0,{"$f":"'Parametre - Agendové IS'!D54","v":0},{"$f":"'Parametre - Agendové IS'!E54","v":0},{"$f":"IF(ISERR(O5-N5),\"-\",O5-N5)","v":0},{"$f":"SUM(B5,E5)","v":0},0,{"$f":"R5-Q5","v":0},0,0,{"$f":"U5-T5","v":0}]
["t3",{"$f":"IF(ISERR('Parametre - Agendové IS'!D5*'Parametre - Agendové IS'!D15),\"-\",'Parametre - Agendové IS'!D5*'Parametre - Agendové IS'!D15)","v":"-"},{"$f":"IF(ISERR('Parametre - Agendové IS'!E5*'Parametre - Agendové IS'!E15),\"-\",'Parametre - Agendové IS'!E5*'Parametre - Agendové IS'!E15)","v":"-"},"-",null,null,0,0,{"$f":"IF(ISERR(Faktory!$D$11*'Parametre - Agendové IS'!E5*('Parametre - Agendové IS'!D35-'Parametre - Agendové IS'!E35)),\"-\",Faktory!$D$11*'Parametre - Agendové IS'!E5*('Parametre - Agendové IS'!D35-'Parametre - Agendové IS'!E35))","v":"-"},{"$f":"IF(ISERR(I6-H6),\"-\",I6-H6)","v":"-"},{"$f":"'Spotrebované cloudové služby'!D5","v":0},{"$f":"'Spotrebované cloudové služby'!E5","v":0},0,{"$f":"'Parametre - Agendové IS'!D55","v":0},{"$f":"'Parametre - Agendové IS'!E55","v":0},0,0,0,0,0,0,0]
["t4",{"$f":"IF(ISERR('Parametre - Agendové IS'!D6*'Parametre - Agendové IS'!D16),\"-\",'Parametre - Agendové IS'!D6*'Parametre - Agendové IS'!D16)","v":0},{"$f":"IF(ISERR('Parametre - Agendové IS'!E6*'Parametre - Agendové IS'!E16),\"-\",'Parametre - Agendové IS'!E6*'Parametre - Agendové IS'!E16)","v":0},0,null,null,0,0,{"$f":"IF(ISERR(Faktory!$D$11*'Parametre - Agendové IS'!E6*('Parametre - Agendové IS'!D36-'Parametre - Agendové IS'!E36)),\"-\",Faktory!$D$11*'Parametre - Agendové IS'!E6*('Parametre - Agendové IS'!D36-'Parametre - Agendové IS'!E36))","v":0},0,{"$f":"'Spotrebované cloudové služby'!D6","v":0},{"$f":"'Spotrebované cloudové služby'!E6","v":0},{"$f":"IF(ISERR(K7-L7),\"-\",K7-L7)","v":0},{"$f":"'Parametre - Agendové IS'!D56","v":0},{"$f":"'Parametre - Agendové IS'!E56","v":445335.66470833332},{"$f":"IF(ISERR(O7-N7),\"-\",O7-N7)","v":445335.66470833332},0,0,0,0,{"$f":"SUM(I7,L7,O7,R7)","v":445335.66470833332},{"$f":"U7-T7","v":445335.66470833332}]
["t5",{"$f":"IF(ISERR('Parametre - Agendové IS'!D7*'Parametre - Agendové IS'!D17),\"-\",'Parametre - Agendové IS'!D7*'Parametre - Agendové IS'!D17)","v":0},{"$f":"IF(ISERR('Parametre - Agendové IS'!E7*'Parametre - Agendové IS'!E17),\"-\",'Parametre - Agendové IS'!E7*'Parametre - Agendové IS'!E17)","v":0},0,null,null,0,0,{"$f":"IF(ISERR(Faktory!$D$11*'Parametre - Agendové IS'!E7*('Parametre - Agendové IS'!D37-'Parametre - Agendové IS'!E37)),\"-\",Faktory!$D$11*'Parametre - Agendové IS'!E7*('Parametre - Agendové IS'!D37-'Parametre - Agendové IS'!E37))","v":0},0,{"$f":"'Spotrebované cloudové služby'!D7","v":0},{"$f":"'Spotrebované cloudové služby'!E7","v":0},0,{"$f":"'Parametre - Agendové IS'!D57","v":0},{"$f":"'Parametre - Agendové IS'!E57","v":379336.44183333335},379336.44183333335,0,0,0,0,379336.44183333335,379336.44183333335]
["t6",{"$f":"IF(ISERR('Parametre - Agendové IS'!D8*'Parametre - Agendové IS'!D18),\"-\",'Parametre - Agendové IS'!D8*'Parametre - Agendové IS'!D18)","v":0},{"$f":"IF(ISERR('Parametre - Agendové IS'!E8*'Parametre - Agendové IS'!E18),\"-\",'Parametre - Agendové IS'!E8*'Parametre - Agendové IS'!E18)","v":0},0,null,null,0,0,{"$f":"IF(ISERR(Faktory!$D$11*'Parametre - Agendové IS'!E8*('Parametre - Agendové IS'!D38-'Parametre - Agendové IS'!E38)),\"-\",Faktory!$D$11*'Parametre - Agendové IS'!E8*('Parametre - Agendové IS'!D38-'Parametre - Agendové IS'!E38))","v":0},0,{"$f":"'Spotrebované cloudové služby'!D8","v":0},{"$f":"'Spotrebované cloudové služby'!E8","v":0},0,{"$f":"'Parametre - Agendové IS'!D58","v":0},{"$f":"'Parametre - Agendové IS'!E58","v":454726.10784722219},454726.10784722219,0,0,0,0,454726.10784722219,454726.10784722219]
["t7",{"$f":"IF(ISERR('Parametre - Agendové IS'!D9*'Parametre - Agendové IS'!D19),\"-\",'Parametre - Agendové IS'!D9*'Parametre - Agendové IS'!D19)","v":0},{"$f":"IF(ISERR('Parametre - Agendové IS'!E9*'Parametre - Agendové IS'!E19),\"-\",'Parametre - Agendové IS'!E9*'Parametre - Agendové IS'!E19)","v":0},0,null,null,0,0,{"$f":"IF(ISERR(Faktory!$D$11*'Parametre - Agendové IS'!E9*('Parametre - Agendové IS'!D39-'Parametre - Agendové IS'!E39)),\"-\",Faktory!$D$11*'Parametre - Agendové IS'!E9*('Parametre - Agendové IS'!D39-'Parametre - Agendové IS'!E39))","v":0},0,{"$f":"'Spotrebované cloudové služby'!D9","v":0},{"$f":"'Spotrebované cloudové služby'!E9","v":0},0,{"$f":"'Parametre - Agendové IS'!D59","v":0},{"$f":"'Parametre - Agendové IS'!E59","v":527337.99608333327},527337.99608333327,0,0,0,0,527337.99608333327,527337.99608333327]
["t8",{"$f":"IF(ISERR('Parametre - Agendové IS'!D10*'Parametre - Agendové IS'!D20),\"-\",'Parametre - Agendové IS'!D10*'Parametre - Agendové IS'!D20)","v":0},{"$f":"IF(ISERR('Parametre - Agendové IS'!E10*'Parametre - Agendové IS'!E20),\"-\",'Parametre - Agendové IS'!E10*'Parametre - Agendové IS'!E20)","v":0},0,null,null,0,0,{"$f":"IF(ISERR(Faktory!$D$11*'Parametre - Agendové IS'!E10*('Parametre - Agendové IS'!D40-'Parametre - Agendové IS'!E40)),\"-\",Faktory!$D$11*'Parametre - Agendové IS'!E10*('Parametre - Agendové IS'!D40-'Parametre - Agendové IS'!E40))","v":0},0,{"$f":"'Spotrebované cloudové služby'!D10","v":0},{"$f":"'Spotrebované cloudové služby'!E10","v":0},0,{"$f":"'Parametre - Agendové IS'!D60","v":0},{"$f":"'Parametre - Agendové IS'!E60","v":572449.88431944442},572449.88431944442,0,0,0,0,572449.88431944442,572449.88431944442]
["t9",{"$f":"IF(ISERR('Parametre - Agendové IS'!D11*'Parametre - Agendové IS'!D21),\"-\",'Parametre - Agendové IS'!D11*'Parametre - Agendové IS'!D21)","v":0},{"$f":"IF(ISERR('Parametre - Agendové IS'!E11*'Parametre - Agendové IS'!E21),\"-\",'Parametre - Agendové IS'!E11*'Parametre - Agendové IS'!E21)","v":0},0,null,null,0,0,{"$f":"IF(ISERR(Faktory!$D$11*'Parametre - Agendové IS'!E11*('Parametre - Agendové IS'!D41-'Parametre - Agendové IS'!E41)),\"-\",Faktory!$D$11*'Parametre - Agendové IS'!E11*('Parametre - Agendové IS'!D41-'Parametre - Agendové IS'!E41))","v":0},0,{"$f":"'Spotrebované cloudové služby'!D11","v":0},{"$f":"'Spotrebované cloudové služby'!E11","v":0},0,{"$f":"'Parametre - Agendové IS'!D61","v":0},{"$f":"'Parametre - Agendové IS'!E61","v":654228.43922222219},654228.43922222219,0,0,0,0,654228.43922222219,654228.43922222219]
["t10",{"$f":"IF(ISERR('Parametre - Agendové IS'!D12*'Parametre - Agendové IS'!D22),\"-\",'Parametre - Agendové IS'!D12*'Parametre - Agendové IS'!D22)","v":0},{"$f":"IF(ISERR('Parametre - Agendové IS'!E12*'Parametre - Agendové IS'!E22),\"-\",'Parametre - Agendové IS'!E12*'Parametre - Agendové IS'!E22)","v":0},0,null,null,0,0,{"$f":"IF(ISERR(Faktory!$D$11*'Parametre - Agendové IS'!E12*('Parametre - Agendové IS'!D42-'Parametre - Agendové IS'!E42)),\"-\",Faktory!$D$11*'Parametre - Agendové IS'!E12*('Parametre - Agendové IS'!D42-'Parametre - Agendové IS'!E42))","v":0},0,{"$f":"'Spotrebované cloudové služby'!D12","v":0},{"$f":"'Spotrebované cloudové služby'!E12","v":0},0,{"$f":"'Parametre - Agendové IS'!D62","v":0},{"$f":"'Parametre - Agendové IS'!E62","v":817785.54902777774},817785.54902777774,0,0,0,0,817785.54902777774,817785.54902777774]
[{"$nulls":15},"SPOLU",{"$f":"SUM(Q4:Q13)","v":0},0,0,0,3851200.0830416665,3851200.0830416665]

{"sheet":"Výdavky - Agendové IS","index":4,"n_rows":15,"n_cols":19,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,9],[0,10,0,15],[0,16,0,18],[1,1,1,3],[1,4,1,6],[1,7,1,9],[1,10,1,12],[1,13,1,15]]}
[null,"Fixné výdavky",{"$nulls":8},"Variabilné výdavky",{"$nulls":5},"Výdavky spolu"]
[null,"HW",null,null,"SW",null,null,"Služby",null,null,"Všeobecný materiál",null,null,"Osobné náklady"]
["Obdobie","Alternat. 1","Alternat. 2","rozdiel","Alternat. 1","Alternat. 2","rozdiel","Alternat. 1","Alternat. 2","rozdiel","Alternat. 1","Alternat. 2","rozdiel","Alternat. 1","Alternat. 2","rozdiel","Alternat. 1","Alternat. 2","rozdiel"]
["t1",{"$f":"TCO!D$21","v":0},{"$f":"TCO!D$11+TCO!D$12","v":53333.333333333336},{"$f":"C4-B4","v":53333.333333333336},{"$f":"TCO!D$20","v":0},{"$f":"TCO!D$7+TCO!D$8","v":1720000},{"$f":"F4-E4","v":1720000},{"$f":"TCO!D$24-(TCO!D$20+TCO!D$21)","v":0},{"$f":"TCO!D$9+TCO!D$10","v":4217971.6727166669},{"$f":"I4-H4","v":4217971.6727166669},{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!D3),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!D3)","v":0},{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!E3),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!E3)","v":0},{"$f":"IF(ISERR(L4-K4),\"-\",L4-K4)","v":0},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!D3*'Parametre - Agendové IS'!D23*'Parametre - Agendové IS'!D43),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!D3*'Parametre - Agendové IS'!D23*'Parametre - Agendové IS'!D43)","v":"-"},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!E3*'Parametre - Agendové IS'!E23*'Parametre - Agendové IS'!E43),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!E3*'Parametre - Agendové IS'!E23*'Parametre - Agendové IS'!E43)","v":"-"},{"$f":"IF(ISERR(O4-N4),\"-\",O4-N4)","v":"-"},{"$f":"SUM(B4,E4,H4,K4,N4)","v":0},{"$f":"SUM(C4,F4,I4,L4,O4)","v":5991305.00605},{"$f":"R4-Q4","v":5991305.00605}]
["t2",{"$f":"TCO!E$21","v":0},{"$f":"TCO!E$11+TCO!E$12","v":355733.33333333331},{"$f":"C5-B5","v":355733.33333333331},{"$f":"TCO!E$20","v":0},{"$f":"TCO!E$7+TCO!E$8","v":0},{"$f":"F5-E5","v":0},{"$f":"TCO!E$24-(TCO!E$20+TCO!E$21)","v":0},{"$f":"TCO!E$9+TCO!E$10","v":3644847.6061416669},{"$f":"I5-H5","v":3644847.6061416669},{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!D4),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!D4)","v":0},{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!E4),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!E4)","v":0},{"$f":"IF(ISERR(L5-K5),\"-\",L5-K5)","v":0},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!D4*'Parametre - Agendové IS'!D24*'Parametre - Agendové IS'!D44),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!D4*'Parametre - Agendové IS'!D24*'Parametre - Agendové IS'!D44)","v":"-"},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!E4*'Parametre - Agendové IS'!E24*'Parametre - Agendové IS'!E44),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!E4*'Parametre - Agendové IS'!E24*'Parametre - Agendové IS'!E44)","v":"-"},{"$f":"IF(ISERR(O5-N5),\"-\",O5-N5)","v":"-"},{"$f":"SUM(B5,E5,H5,K5,N5)","v":0},4000580.9394750004,{"$f":"R5-Q5","v":4000580.9394750004}]
["t3",{"$f":"TCO!F$21","v":0},{"$f":"TCO!F$11+TCO!F$12","v":471822.67733333335},471822.67733333335,{"$f":"TCO!F$20","v":0},{"$f":"TCO!F$7+TCO!F$8","v":0},0,{"$f":"TCO!F$24-(TCO!F$20+TCO!F$21)","v":0},{"$f":"TCO!F$9+TCO!F$10","v":3343222.0061416668},3343222.0061416668,{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!D5),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!D5)","v":0},{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!E5),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!E5)","v":0},{"$f":"IF(ISERR(L6-K6),\"-\",L6-K6)","v":0},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!D5*'Parametre - Agendové IS'!D25*'Parametre - Agendové IS'!D45),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!D5*'Parametre - Agendové IS'!D25*'Parametre - Agendové IS'!D45)","v":"-"},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!E5*'Parametre - Agendové IS'!E25*'Parametre - Agendové IS'!E45),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!E5*'Parametre - Agendové IS'!E25*'Parametre - Agendové IS'!E45)","v":"-"},{"$f":"IF(ISERR(O6-N6),\"-\",O6-N6)","v":"-"},0,3815044.6834750003,3815044.6834750003]
["t4",{"$f":"TCO!G$21","v":0},{"$f":"TCO!G$11+TCO!G$12","v":400489.34400000004},400489.34400000004,{"$f":"TCO!G$20","v":0},{"$f":"TCO!G$7+TCO!G$8","v":504000},504000,{"$f":"TCO!G$24-(TCO!G$20+TCO!G$21)","v":0},{"$f":"TCO!G$9+TCO!G$10","v":1767524.6442499999},1767524.6442499999,{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!D6),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!D6)","v":0},{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!E6),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!E6)","v":0},{"$f":"IF(ISERR(L7-K7),\"-\",L7-K7)","v":0},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!D6*'Parametre - Agendové IS'!D26*'Parametre - Agendové IS'!D46),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!D6*'Parametre - Agendové IS'!D26*'Parametre - Agendové IS'!D46)","v":4239000},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!E6*'Parametre - Agendové IS'!E26*'Parametre - Agendové IS'!E46),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!E6*'Parametre - Agendové IS'!E26*'Parametre - Agendové IS'!E46)","v":235500},{"$f":"IF(ISERR(O7-N7),\"-\",O7-N7)","v":-4003500},4239000,2907513.9882499999,-1331486.0117500001]
["t5",{"$f":"TCO!H$21","v":0},{"$f":"TCO!H$11+TCO!H$12","v":400489.34400000004},400489.34400000004,{"$f":"TCO!H$20","v":0},{"$f":"TCO!H$7+TCO!H$8","v":504000},504000,{"$f":"TCO!H$24-(TCO!H$20+TCO!H$21)","v":0},{"$f":"TCO!H$9+TCO!H$10","v":802524.64425000001},802524.64425000001,{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!D7),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!D7)","v":0},{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!E7),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!E7)","v":0},{"$f":"IF(ISERR(L8-K8),\"-\",L8-K8)","v":0},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!D7*'Parametre - Agendové IS'!D27*'Parametre - Agendové IS'!D47),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!D7*'Parametre - Agendové IS'!D27*'Parametre - Agendové IS'!D47)","v":4239000},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!E7*'Parametre - Agendové IS'!E27*'Parametre - Agendové IS'!E47),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!E7*'Parametre - Agendové IS'!E27*'Parametre - Agendové IS'!E47)","v":235500},{"$f":"IF(ISERR(O8-N8),\"-\",O8-N8)","v":-4003500},4239000,1942513.9882499999,-2296486.0117500001]
["t6",{"$f":"TCO!I$21","v":0},{"$f":"TCO!I$11+TCO!I$12","v":400489.34400000004},400489.34400000004,{"$f":"TCO!I$20","v":0},{"$f":"TCO!I$7+TCO!I$8","v":504000},504000,{"$f":"TCO!I$24-(TCO!I$20+TCO!I$21)","v":0},{"$f":"TCO!I$9+TCO!I$10","v":732524.64425000001},732524.64425000001,{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!D8),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!D8)","v":0},{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!E8),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!E8)","v":0},{"$f":"IF(ISERR(L9-K9),\"-\",L9-K9)","v":0},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!D8*'Parametre - Agendové IS'!D28*'Parametre - Agendové IS'!D48),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!D8*'Parametre - Agendové IS'!D28*'Parametre - Agendové IS'!D48)","v":4239000},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!E8*'Parametre - Agendové IS'!E28*'Parametre - Agendové IS'!E48),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!E8*'Parametre - Agendové IS'!E28*'Parametre - Agendové IS'!E48)","v":235500},{"$f":"IF(ISERR(O9-N9),\"-\",O9-N9)","v":-4003500},4239000,1872513.9882499999,-2366486.0117500001]
["t7",{"$f":"TCO!J$21","v":0},{"$f":"TCO!J$11+TCO!J$12","v":400489.34400000004},400489.34400000004,{"$f":"TCO!J$20","v":0},{"$f":"TCO!J$7+TCO!J$8","v":504000},504000,{"$f":"TCO!J$24-(TCO!J$20+TCO!J$21)","v":0},{"$f":"TCO!J$9+TCO!J$10","v":677524.64425000001},677524.64425000001,{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!D9),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!D9)","v":0},{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!E9),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!E9)","v":0},0,{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!D9*'Parametre - Agendové IS'!D29*'Parametre - Agendové IS'!D49),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!D9*'Parametre - Agendové IS'!D29*'Parametre - Agendové IS'!D49)","v":4239000},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!E9*'Parametre - Agendové IS'!E29*'Parametre - Agendové IS'!E49),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!E9*'Parametre - Agendové IS'!E29*'Parametre - Agendové IS'!E49)","v":235500},-4003500,4239000,1817513.9882499999,-2421486.0117500001]
["t8",{"$f":"TCO!K$21","v":0},{"$f":"TCO!K$11+TCO!K$12","v":400489.34400000004},400489.34400000004,{"$f":"TCO!K$20","v":0},{"$f":"TCO!K$7+TCO!K$8","v":504000},504000,{"$f":"TCO!K$24-(TCO!K$20+TCO!K$21)","v":0},{"$f":"TCO!K$9+TCO!K$10","v":567524.64425000001},567524.64425000001,{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!D10),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!D10)","v":0},{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!E10),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!E10)","v":0},0,{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!D10*'Parametre - Agendové IS'!D30*'Parametre - Agendové IS'!D50),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!D10*'Parametre - Agendové IS'!D30*'Parametre - Agendové IS'!D50)","v":4239000},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!E10*'Parametre - Agendové IS'!E30*'Parametre - Agendové IS'!E50),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!E10*'Parametre - Agendové IS'!E30*'Parametre - Agendové IS'!E50)","v":235500},-4003500,4239000,1707513.9882499999,-2531486.0117500001]
["t9",{"$f":"TCO!L$21","v":0},{"$f":"TCO!L$11+TCO!L$12","v":400489.34400000004},400489.34400000004,{"$f":"TCO!L$20","v":0},{"$f":"TCO!L$7+TCO!L$8","v":504000},504000,{"$f":"TCO!L$24-(TCO!L$20+TCO!L$21)","v":0},{"$f":"TCO!L$9+TCO!L$10","v":567524.64425000001},567524.64425000001,{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!D11),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!D11)","v":0},{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!E11),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!E11)","v":0},0,{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!D11*'Parametre - Agendové IS'!D31*'Parametre - Agendové IS'!D51),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!D11*'Parametre - Agendové IS'!D31*'Parametre - Agendové IS'!D51)","v":4239000},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!E11*'Parametre - Agendové IS'!E31*'Parametre - Agendové IS'!E51),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!E11*'Parametre - Agendové IS'!E31*'Parametre - Agendové IS'!E51)","v":235500},-4003500,4239000,1707513.9882499999,-2531486.0117500001]
["t10",{"$f":"TCO!M$21","v":0},{"$f":"TCO!M$11+TCO!M$12","v":400489.34400000004},400489.34400000004,{"$f":"TCO!M$20","v":0},{"$f":"TCO!M$7+TCO!M$8","v":504000},504000,{"$f":"TCO!M$24-(TCO!M$20+TCO!M$21)","v":0},{"$f":"TCO!M$9+TCO!M$10","v":567524.64425000001},567524.64425000001,{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!D12),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!D12)","v":0},{"$f":"IF(ISERR(Faktory!$D$9*'Parametre - Agendové IS'!E12),\"-\",Faktory!$D$9*'Parametre - Agendové IS'!E12)","v":0},0,{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!D12*'Parametre - Agendové IS'!D32*'Parametre - Agendové IS'!D52),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!D12*'Parametre - Agendové IS'!D32*'Parametre - Agendové IS'!D52)","v":4239000},{"$f":"IF(ISERR(Faktory!$D$7*'Parametre - Agendové IS'!E12*'Parametre - Agendové IS'!E32*'Parametre - Agendové IS'!E52),\"-\",Faktory!$D$7*'Parametre - Agendové IS'!E12*'Parametre - Agendové IS'!E32*'Parametre - Agendové IS'!E52)","v":235500},-4003500,4239000,1707513.9882499999,-2531486.0117500001]
[{"$nulls":15},"SPOLU",{"$f":"SUM(Q4:Q13)","v":29673000},{"$f":"SUM(R4:R13)","v":27469528.546749994},{"$f":"SUM(S4:S13)","v":-2203471.4532499979}]
["*","Všetky výdavkové položky sú automaticky vypočítané na základe údajov uvedených v záložkách TCO, spotrebované cloudové služby a Parametre - Agendové IS"]

{"sheet":"Spotrebované cloudové služby","index":5,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,10,0,11],[0,12,0,13],[2,0,11,0],[2,1,11,1],[0,3,0,5],[0,6,0,7],[0,8,0,9]]}
[null,null,null,"SPOLU",null,null,"cloudová služba 1",null,"cloudová služba 2",null,"cloudová služba 3",null,"cloudová služba N"]
["Parameter","Jednotka","Obdobie","Alternat. 1","Alternat. 2","rozdiel","Alternat. 1","Alternat. 2","Alternat. 1","Alternat. 2","Alternat. 1","Alternat. 2","Alternat. 1","Alternat. 2"]
["Spotrebovávané cloudové služby\nParameter je vyhodnocovaný ako úspora z prevádzky (v časti prínosy)","EUR","t1",{"$f":"SUM(G3,I3,K3,M3)","v":0},{"$f":"SUM(H3,J3,L3,N3)","v":0},{"$f":"E3-D3","v":0}]
[null,null,"t2",{"$f":"SUM(G4,I4,K4,M4)","v":0},{"$f":"SUM(H4,J4,L4,N4)","v":0},{"$f":"E4-D4","v":0}]
[null,null,"t3",0,0,0]
[null,null,"t4",0,0,0]
[null,null,"t5",0,0,0]
[null,null,"t6",0,0,0]
[null,null,"t7",0,0,0]
[null,null,"t8",0,0,0]
[null,null,"t9",0,0,0]
[null,null,"t10",0,0,0]

{"sheet":"Parametre - Agendové IS","index":6,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,6,0,7],[0,8,0,9],[0,10,0,11],[22,0,31,0],[22,1,31,1],[52,0,61,0],[52,1,61,1],[32,0,41,0],[32,1,41,1],[42,0,51,0],[42,1,51,1],[0,12,0,13],[2,0,11,0],[2,1,11,1],[12,0,21,0],[12,1,21,1],[0,3,0,5]]}
[null,null,null,"SPOLU",null,null,"Skupina služieb 1",null,"Skupina služieb 2",null,"Skupina služieb 3",null,"Skupina služieb N",null,"% zmena"]
["Parameter","Jednotka","Obdobie","Alternat. 1","Alternat. 2","rozdiel","Alternat. 1","Alternat. 2","Alternat. 1","Alternat. 2","Alternat. 1","Alternat. 2","Alternat. 1","Alternat. 2"]
["Počet podaní","počet / rok","t1",{"$f":"SUM(G3,I3,K3,M3)","v":0},{"$f":"SUM(H3,J3,L3,N3)+SUM(H3,J3,L3,N3)*$O$3","v":0},{"$f":"E3-D3","v":0},{"$nulls":8},{"$f":"'Analyza citlivosti - AgendovéIS'!B2","v":0}]
[null,null,"t2",{"$f":"SUM(G4,I4,K4,M4)","v":0},0,{"$f":"E4-D4","v":0}]
[null,null,"t3",0,0,0]
[null,null,"t4",300000,50000,-250000,300000,50000]
[null,null,"t5",300000,50000,-250000,300000,50000]
[null,null,"t6",300000,50000,-250000,300000,50000]
[null,null,"t7",300000,50000,-250000,300000,50000]
[null,null,"t8",300000,50000,-250000,300000,50000]
[null,null,"t9",300000,50000,-250000,300000,50000]
[null,null,"t10",300000,50000,-250000,300000,50000]
["Výška administratívneho poplatku","EUR","t1",{"$f":"IF(ISERR((G13*G3+I13*I3+K13*K3+M13*M3)/SUM(G3,I3,K3,M3)),\"-\",(G13*G3+I13*I3+K13*K3+M13*M3)/SUM(G3,I3,K3,M3))","v":"-"},{"$f":"IF(ISERR((H13*H3+J13*J3+L13*L3+N13*N3)/SUM(H3,J3,L3,N3)+((H13*H3+J13*J3+L13*L3+N13*N3)/SUM(H3,J3,L3,N3))*$O$13),\"-\",(H13*H3+J13*J3+L13*L3+N13*N3)/SUM(H3,J3,L3,N3)+((H13*H3+J13*J3+L13*L3+N13*N3)/SUM(H3,J3,L3,N3))*$O$13)","v":"-"},{"$f":"IF(ISERR(E13-D13),\"-\",E13-D13)","v":"-"},{"$nulls":8},{"$f":"'Analyza citlivosti - AgendovéIS'!B4","v":0}]
[null,null,"t2","-","-",{"$f":"IF(ISERR(E14-D14),\"-\",E14-D14)","v":"-"}]
[null,null,"t3","-","-","-"]
[null,null,"t4",0,0,0]
[null,null,"t5",0,0,0]
[null,null,"t6",0,0,0]
[null,null,"t7",0,0,0]
[null,null,"t8",0,0,0]
[null,null,"t9",0,0,0]
[null,null,"t10",0,0,0]
["Trvanie spracovania podania","hod.","t1",{"$f":"IF(ISERR((G23*G3+I23*I3+K23*K3+M23*M3)/SUM(G3,I3,K3,M3)),\"-\",(G23*G3+I23*I3+K23*K3+M23*M3)/SUM(G3,I3,K3,M3))","v":"-"},{"$f":"IF(ISERR((H23*H3+J23*J3+L23*L3+N23*N3)/SUM(H3,J3,L3,N3) + ((H23*H3+J23*J3+L23*L3+N23*N3)/SUM(H3,J3,L3,N3))*$O$23),\"-\",(H23*H3+J23*J3+L23*L3+N23*N3)/SUM(H3,J3,L3,N3)+ ((H23*H3+J23*J3+L23*L3+N23*N3)/SUM(H3,J3,L3,N3))*$O$23)","v":"-"},{"$f":"IF(ISERR(E23-D23),\"-\",E23-D23)","v":"-"},{"$nulls":8},{"$f":"'Analyza citlivosti - AgendovéIS'!B6","v":0}]
[null,null,"t2",{"$f":"IF(ISERR((G24*G4+I24*I4+K24*K4+M24*M4)/SUM(G4,I4,K4,M4)),\"-\",(G24*G4+I24*I4+K24*K4+M24*M4)/SUM(G4,I4,K4,M4))","v":"-"},{"$f":"IF(ISERR((H24*H4+J24*J4+L24*L4+N24*N4)/SUM(H4,J4,L4,N4) + ((H24*H4+J24*J4+L24*L4+N24*N4)/SUM(H4,J4,L4,N4))*$O$23),\"-\",(H24*H4+J24*J4+L24*L4+N24*N4)/SUM(H4,J4,L4,N4)+ ((H24*H4+J24*J4+L24*L4+N24*N4)/SUM(H4,J4,L4,N4))*$O$23)","v":"-"},{"$f":"IF(ISERR(E24-D24),\"-\",E24-D24)","v":"-"}]
[null,null,"t3","-","-","-"]
[null,null,"t4",1.5,0.5,-1,1.5,0.5]
[null,null,"t5",1.5,0.5,-1,1.5,0.5]
[null,null,"t6",1.5,0.5,-1,1.5,0.5]
[null,null,"t7",1.5,0.5,-1,1.5,0.5]
[null,null,"t8",1.5,0.5,-1,1.5,0.5]
[null,null,"t9",1.5,0.5,-1,1.5,0.5]
[null,null,"t10",1.5,0.5,-1,1.5,0.5]
["Priemerný čas potrebný na vypracovanie a doručenie podania","hod.","t1",{"$f":"IF(ISERR((G33*G3+I33*I3+K33*K3+M33*M3)/SUM(G3,I3,K3,M3)),\"-\",(G33*G3+I33*I3+K33*K3+M33*M3)/SUM(G3,I3,K3,M3))","v":"-"},{"$f":"IF(ISERR((H33*H3+J33*J3+L33*L3+N33*N3)/SUM(H3,J3,L3,N3)+((H33*H3+J33*J3+L33*L3+N33*N3)/SUM(H3,J3,L3,N3))*$O$33),\"-\",(H33*H3+J33*J3+L33*L3+N33*N3)/SUM(H3,J3,L3,N3)+((H33*H3+J33*J3+L33*L3+N33*N3)/SUM(H3,J3,L3,N3))*$O$33)","v":"-"},{"$f":"IF(ISERR(E33-D33),\"-\",E33-D33)","v":"-"},{"$nulls":8},{"$f":"'Analyza citlivosti - AgendovéIS'!B8","v":0}]
[null,null,"t2","-","-",{"$f":"IF(ISERR(E34-D34),\"-\",E34-D34)","v":"-"}]
[null,null,"t3","-","-","-"]
[null,null,"t4",0,0,0]
[null,null,"t5",0,0,0]
[null,null,"t6",0,0,0]
[null,null,"t7",0,0,0]
[null,null,"t8",0,0,0]
[null,null,"t9",0,0,0]
[null,null,"t10",0,0,0]
["Počet zamestnancov vybavujúcich agendu","počet","t1",{"$f":"IF(ISERR((G43*G3+I43*I3+K43*K3+M43*M3)/SUM(G3,I3,K3,M3)),\"-\",(G43*G3+I43*I3+K43*K3+M43*M3)/SUM(G3,I3,K3,M3))","v":"-"},{"$f":"IF(ISERR((H43*H3+J43*J3+L43*L3+N43*N3)/SUM(H3,J3,L3,N3)+((H43*H3+J43*J3+L43*L3+N43*N3)/SUM(H3,J3,L3,N3))*$O$43),\"-\",(H43*H3+J43*J3+L43*L3+N43*N3)/SUM(H3,J3,L3,N3)+((H43*H3+J43*J3+L43*L3+N43*N3)/SUM(H3,J3,L3,N3))*$O$43)","v":"-"},{"$f":"IF(ISERR(E43-D43),\"-\",E43-D43)","v":"-"},{"$nulls":8},{"$f":"'Analyza citlivosti - AgendovéIS'!B10","v":0}]
[null,null,"t2","-","-",{"$f":"IF(ISERR(E44-D44),\"-\",E44-D44)","v":"-"}]
[null,null,"t3","-","-","-"]
[null,null,"t4",1,1,0,1,1]
[null,null,"t5",1,1,0,1,1]
[null,null,"t6",1,1,0,1,1]
[null,null,"t7",1,1,0,1,1]
[null,null,"t8",1,1,0,1,1]
[null,null,"t9",1,1,0,1,1]
[null,null,"t10",1,1,0,1,1]
["Kvalitatívne prínosy - úspora prevádzkových nákladov z migrácie do cloudu","EUR","t1",{"$f":"SUM(G53,I53,K53,M53)","v":0},{"$f":"SUM(H53,J53,L53,N53)+SUM(H53,J53,L53,N53)*$O$53","v":0},{"$f":"E53-D53","v":0},{"$nulls":8},{"$f":"'Analyza citlivosti - AgendovéIS'!B12","v":0}]
[null,null,"t2",0,0,0]
[null,null,"t3",0,0,0]
[null,null,"t4",0,{"$f":"SUM(H56,J56,L56,N56)+SUM(H56,J56,L56,N56)*$O$53","v":445335.66470833332},445335.66470833332,null,{"$f":"TCO!G13/(1-Prinosy!$C$6)*Prinosy!C12","v":445335.66470833332}]
[null,null,"t5",0,379336.44183333335,379336.44183333335,null,{"$f":"TCO!H13/(1-Prinosy!$C$6)*Prinosy!C13","v":379336.44183333335}]
[null,null,"t6",0,454726.10784722219,454726.10784722219,null,{"$f":"TCO!I13/(1-Prinosy!$C$6)*Prinosy!C14","v":454726.10784722219}]
[null,null,"t7",0,527337.99608333327,527337.99608333327,null,{"$f":"TCO!J13/(1-Prinosy!$C$6)*Prinosy!C15","v":527337.99608333327}]
[null,null,"t8",0,572449.88431944442,572449.88431944442,null,{"$f":"TCO!K13/(1-Prinosy!$C$6)*Prinosy!C16","v":572449.88431944442}]
[null,null,"t9",0,654228.43922222219,654228.43922222219,null,{"$f":"TCO!L13/(1-Prinosy!$C$6)*Prinosy!C17","v":654228.43922222219}]
[null,null,"t10",0,817785.54902777774,817785.54902777774,null,{"$f":"TCO!M13/(1-Prinosy!$C$6)*Prinosy!C18","v":817785.54902777774}]

{"sheet":"TCO","index":7,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,3,4,12],[15,0,15,2],[17,3,17,12]]}
["Celkové náklady na vlastníctvo (TCO)"]
[]
["Počet používateľov :"]
[]
[null,null,null,"Rok"]
["P.č.",null,"Spolu","t1","t2","t3","t4","t5","t6","t7","t8","t9","t10"]
[1,"SW produkty - sumár obstaranie",{"$f":"SUM(D7:M7)","v":1720000},{"$f":"'TCO - SW'!$E5+'TCO - SW'!$E15","v":1720000},{"$f":"'TCO - SW'!$E6+'TCO - SW'!$E16","v":0},{"$f":"'TCO - SW'!$E7+'TCO - SW'!$E17","v":0},{"$f":"'TCO - SW'!$E8+'TCO - SW'!$E18","v":0},{"$f":"'TCO - SW'!$E9+'TCO - SW'!$E19","v":0},{"$f":"'TCO - SW'!$E10+'TCO - SW'!$E20","v":0},{"$f":"'TCO - SW'!$E11+'TCO - SW'!$E21","v":0},{"$f":"'TCO - SW'!$E12+'TCO - SW'!$E22","v":0},{"$f":"'TCO - SW'!$E13+'TCO - SW'!$E23","v":0},{"$f":"'TCO - SW'!$E14+'TCO - SW'!$E24","v":0}]
[null,"SW produkty - sumár prevádzka",3528000,{"$f":"'TCO - SW'!$E58+'TCO - SW'!$E68","v":0},{"$f":"'TCO - SW'!$E59+'TCO - SW'!$E69","v":0},{"$f":"'TCO - SW'!$E60+'TCO - SW'!$E70","v":0},{"$f":"'TCO - SW'!$E61+'TCO - SW'!$E71","v":504000},{"$f":"'TCO - SW'!$E62+'TCO - SW'!$E72","v":504000},{"$f":"'TCO - SW'!$E63+'TCO - SW'!$E73","v":504000},{"$f":"'TCO - SW'!$E64+'TCO - SW'!$E74","v":504000},{"$f":"'TCO - SW'!$E65+'TCO - SW'!$E75","v":504000},{"$f":"'TCO - SW'!$E66+'TCO - SW'!$E76","v":504000},{"$f":"'TCO - SW'!$E67+'TCO - SW'!$E77","v":504000}]
[null,"Aplikácie - sumár obstaranie",6313762.8849999998,{"$f":"'TCO - SW'!$E26+'TCO - SW'!$E36+'TCO - SW'!$E46","v":4159190.8727166667},{"$f":"'TCO - SW'!$E27+'TCO - SW'!$E37+'TCO - SW'!$E47","v":1077286.0061416668},{"$f":"'TCO - SW'!$E28+'TCO - SW'!$E38+'TCO - SW'!$E48","v":1077286.0061416668},{"$f":"'TCO - SW'!$E29+'TCO - SW'!$E39+'TCO - SW'!$E49","v":0},{"$f":"'TCO - SW'!$E30+'TCO - SW'!$E40+'TCO - SW'!$E50","v":0},{"$f":"'TCO - SW'!$E31+'TCO - SW'!$E41+'TCO - SW'!$E51","v":0},{"$f":"'TCO - SW'!$E32+'TCO - SW'!$E42+'TCO - SW'!$E52","v":0},{"$f":"'TCO - SW'!$E33+'TCO - SW'!$E43+'TCO - SW'!$E53","v":0},{"$f":"'TCO - SW'!$E34+'TCO - SW'!$E44+'TCO - SW'!$E54","v":0},{"$f":"'TCO - SW'!$E35+'TCO - SW'!$E45+'TCO - SW'!$E55","v":0}]
[null,"Aplikácie - sumár prevádzka",10574950.90975,{"$f":"'TCO - SW'!$E79+'TCO - SW'!$E89+'TCO - SW'!$E99+'TCO - SW'!$E109+'TCO - SW'!$E119","v":58780.800000000003},{"$f":"'TCO - SW'!$E80+'TCO - SW'!$E90+'TCO - SW'!$E100+'TCO - SW'!$E110+'TCO - SW'!$E120","v":2567561.6},{"$f":"'TCO - SW'!$E81+'TCO - SW'!$E91+'TCO - SW'!$E101+'TCO - SW'!$E111+'TCO - SW'!$E121","v":2265936},{"$f":"'TCO - SW'!$E82+'TCO - SW'!$E92+'TCO - SW'!$E102+'TCO - SW'!$E112+'TCO - SW'!$E122","v":1767524.6442499999},{"$f":"'TCO - SW'!$E83+'TCO - SW'!$E93+'TCO - SW'!$E103+'TCO - SW'!$E113+'TCO - SW'!$E123","v":802524.64425000001},{"$f":"'TCO - SW'!$E84+'TCO - SW'!$E94+'TCO - SW'!$E104+'TCO - SW'!$E114+'TCO - SW'!$E124","v":732524.64425000001},{"$f":"'TCO - SW'!$E85+'TCO - SW'!$E95+'TCO - SW'!$E105+'TCO - SW'!$E115+'TCO - SW'!$E125","v":677524.64425000001},{"$f":"'TCO - SW'!$E86+'TCO - SW'!$E96+'TCO - SW'!$E106+'TCO - SW'!$E116+'TCO - SW'!$E126","v":567524.64425000001},{"$f":"'TCO - SW'!$E87+'TCO - SW'!$E97+'TCO - SW'!$E107+'TCO - SW'!$E117+'TCO - SW'!$E127","v":567524.64425000001},{"$f":"'TCO - SW'!$E88+'TCO - SW'!$E98+'TCO - SW'!$E108+'TCO - SW'!$E118+'TCO - SW'!$E128","v":567524.64425000001}]
[2,"HW sumár obstaranie",0,{"$f":"'TCO - HW'!$E4+'TCO - HW'!$E14+'TCO - HW'!$E24","v":0},{"$f":"'TCO - HW'!$E5+'TCO - HW'!$E15+'TCO - HW'!$E25","v":0},{"$f":"'TCO - HW'!$E6+'TCO - HW'!$E16+'TCO - HW'!$E26","v":0},{"$f":"'TCO - HW'!$E7+'TCO - HW'!$E17+'TCO - HW'!$E27","v":0},{"$f":"'TCO - HW'!$E8+'TCO - HW'!$E18+'TCO - HW'!$E28","v":0},{"$f":"'TCO - HW'!$E9+'TCO - HW'!$E19+'TCO - HW'!$E29","v":0},{"$f":"'TCO - HW'!$E10+'TCO - HW'!$E20+'TCO - HW'!$E30","v":0},{"$f":"'TCO - HW'!$E11+'TCO - HW'!$E21+'TCO - HW'!$E31","v":0},{"$f":"'TCO - HW'!$E12+'TCO - HW'!$E22+'TCO - HW'!$E32","v":0},{"$f":"'TCO - HW'!$E13+'TCO - HW'!$E23+'TCO - HW'!$E33","v":0}]
[null,"HW sumár prevádzka",3684314.7520000003,{"$f":"'TCO - HW'!$E35+'TCO - HW'!$E45+'TCO - HW'!$E55+'TCO - HW'!$E65+'TCO - HW'!$E75","v":53333.333333333336},{"$f":"'TCO - HW'!$E36+'TCO - HW'!$E46+'TCO - HW'!$E56+'TCO - HW'!$E66+'TCO - HW'!$E76","v":355733.33333333331},{"$f":"'TCO - HW'!$E37+'TCO - HW'!$E47+'TCO - HW'!$E57+'TCO - HW'!$E67+'TCO - HW'!$E77","v":471822.67733333335},{"$f":"'TCO - HW'!$E38+'TCO - HW'!$E48+'TCO - HW'!$E58+'TCO - HW'!$E68+'TCO - HW'!$E78","v":400489.34400000004},{"$f":"'TCO - HW'!$E39+'TCO - HW'!$E49+'TCO - HW'!$E59+'TCO - HW'!$E69+'TCO - HW'!$E79","v":400489.34400000004},{"$f":"'TCO - HW'!$E40+'TCO - HW'!$E50+'TCO - HW'!$E60+'TCO - HW'!$E70+'TCO - HW'!$E80","v":400489.34400000004},{"$f":"'TCO - HW'!$E41+'TCO - HW'!$E51+'TCO - HW'!$E61+'TCO - HW'!$E71+'TCO - HW'!$E81","v":400489.34400000004},{"$f":"'TCO - HW'!$E42+'TCO - HW'!$E52+'TCO - HW'!$E62+'TCO - HW'!$E72+'TCO - HW'!$E82","v":400489.34400000004},{"$f":"'TCO - HW'!$E43+'TCO - HW'!$E53+'TCO - HW'!$E63+'TCO - HW'!$E73+'TCO - HW'!$E83","v":400489.34400000004},{"$f":"'TCO - HW'!$E44+'TCO - HW'!$E54+'TCO - HW'!$E64+'TCO - HW'!$E74+'TCO - HW'!$E84","v":400489.34400000004}]
[null,"Spolu ",{"$f":"SUM(C7:C12)","v":25821028.546749998},{"$f":"SUM(D7:D12)","v":5991305.00605},{"$f":"SUM(E7:E12)","v":4000580.9394750004},3815044.6834750003,2672013.9882499999,1707013.9882499999,1637013.9882499999,1582013.9882499999,1472013.9882499999,1472013.9882499999,1472013.9882499999]
[]
[]
["Náklady na existujúce riešenie\n(pôvodné riešenie pred realizáciou projektu OP II), ktoré bolo nahradené"]
[]
[null,null,null,"Rok"]
["P.č.",null,"Spolu","t1","t2","t3","t4","t5","t6","t7","t8","t9","t10"]
[1,"Náklady na dodávateľa spojené s prevádzkou SW",{"$f":"SUM(D20:M20)","v":0}]
[2,"Náklady na dodávateľa spojené s prevádzkou HW",{"$f":"SUM(D21:M21)","v":0}]
[3,"Personálne náklady*",{"$f":"SUM(D22:M22)","v":0}]
[4,"Náklady na priestory a energie",{"$f":"SUM(D23:M23)","v":0}]
[null,"Spolu** ",{"$f":"SUM(C20:C23)","v":0},{"$f":"SUM(D20:D23)","v":0},{"$f":"SUM(E20:E23)","v":0},0,0,0,0,0,0,0,0]
[]
["Poznámky:"]
["*","Personálne náklady existujúceho riešenia - náklady na zamestnancov priamo vykonávajúcich podporu daného IKT"]
["**","V pripade riešenia podpory daného IKT formou  outsourcingu, alebo(a) prenájmu , postačuje uviesť celkovú hodnotu, ak nie je možné výdavky štrukturovane rozdeliť"]

{"sheet":"TCO - SW","index":8,"n_rows":128,"n_cols":8,"rows_kept":128,"cut":false,"hidden":false,"merged":[[118,0,127,0],[118,1,127,1],[118,2,127,2],[0,0,0,3],[98,0,107,0],[98,1,107,1],[98,2,107,2],[108,0,117,0],[108,1,117,1],[108,2,117,2],[78,0,87,0],[78,1,87,1],[78,2,87,2],[88,0,97,0],[88,1,97,1],[88,2,97,2],[55,0,55,2],[57,0,66,0],[57,1,66,1],[57,2,66,2],[67,0,76,0],[67,1,76,1],[67,2,76,2],[35,0,44,0],[35,1,44,1],[35,2,44,2],[2,0,2,2],[45,0,54,0],[45,1,54,1],[45,2,54,2],[14,0,23,0],[14,1,23,1],[14,2,23,2],[25,0,34,0],[25,1,34,1],[25,2,34,2],[4,2,13,2],[4,0,13,0],[4,1,13,1]]}
["Náklady na obstaranie a prevádzku SW",null,null,null,"SPOLU","MDM Rezortná zbernica","MDM Portál","MDM Dátový server"]
["Názov","Účet/skupina výdavkov","Kód EKO klasifikácie","Obdobie"]
["Vytvorenie riešenia - obstaranie",null,null,null,{"$f":"E4+E25","v":8033762.8850000007},{"$f":"F4+F25","v":5623634.0194999995},{"$f":"G4+G25","v":803376.28850000002},{"$f":"H4+H25","v":1606752.577}]
["SW produkty",null,null,null,{"$f":"SUM(E5:E24)","v":1720000},{"$f":"SUM(F5:F24)","v":1204000},{"$f":"SUM(G5:G24)","v":172000},{"$f":"SUM(H5:H24)","v":344000}]
["Obstaranie, inštalácia SW produktu vrátane licencie k SW","013 Softvér",711003,"t1",{"$f":"SUM(F5:H5)","v":1720000},{"$f":"'SW a aplikacie'!C15","v":1204000},{"$f":"'SW a aplikacie'!D15","v":172000},{"$f":"'SW a aplikacie'!E15","v":344000}]
[null,null,null,"t2",{"$f":"SUM(F6:H6)","v":0}]
[null,null,null,"t3",{"$f":"SUM(F7:H7)","v":0}]
[null,null,null,"t4",0]
[null,null,null,"t5",0]
[null,null,null,"t6",0]
[null,null,null,"t7",0]
[null,null,null,"t8",0]
[null,null,null,"t9",0]
[null,null,null,"t10",0]
["Obstaranie, inštalácia SW produktu vrátane licencie k SW","518 Ostatné služby",633013,"t1",{"$f":"SUM(F15:H15)","v":0}]
[null,null,null,"t2",{"$f":"SUM(F16:H16)","v":0}]
[null,null,null,"t3",{"$f":"SUM(F17:H17)","v":0}]
[null,null,null,"t4",0]
[null,null,null,"t5",0]
[null,null,null,"t6",0]
[null,null,null,"t7",0]
[null,null,null,"t8",0]
[null,null,null,"t9",0]
[null,null,null,"t10",0]
["Aplikácie",null,null,null,{"$f":"SUM(E26:E55)","v":6313762.8850000007},{"$f":"SUM(F26:F55)","v":4419634.0194999995},{"$f":"SUM(G26:G55)","v":631376.28850000002},{"$f":"SUM(H26:H55)","v":1262752.577}]
["Vytvorenie aplikácie","013 Softvér",711003,"t1",{"$f":"SUM(F26:H26)","v":3965194.2060500002},{"$f":"'SW a aplikacie'!C5+'SW a aplikacie'!C8","v":2775635.9442349998},{"$f":"'SW a aplikacie'!D5+'SW a aplikacie'!D8","v":396519.42060499999},{"$f":"'SW a aplikacie'!E5+'SW a aplikacie'!E8","v":793038.84120999998}]
[null,null,null,"t2",{"$f":"SUM(F27:H27)","v":0}]
[null,null,null,"t3",{"$f":"SUM(F28:H28)","v":0}]
[null,null,null,"t4",0]
[null,null,null,"t5",0]
[null,null,null,"t6",0]
[null,null,null,"t7",0]
[null,null,null,"t8",0]
[null,null,null,"t9",0]
[null,null,null,"t10",0]
["Vytvorenie aplikácie","518 Ostatné služby",633013,"t1",193996.66666666666,{"$f":"'SW a aplikacie'!C$21*1/3","v":135797.66666666666},{"$f":"'SW a aplikacie'!D$21*1/3","v":19399.666666666668},{"$f":"'SW a aplikacie'!E$21*1/3","v":38799.333333333336}]
[null,null,null,"t2",193996.66666666666,{"$f":"'SW a aplikacie'!C$21*1/3","v":135797.66666666666},{"$f":"'SW a aplikacie'!D$21*1/3","v":19399.666666666668},{"$f":"'SW a aplikacie'!E$21*1/3","v":38799.333333333336}]
[null,null,null,"t3",193996.66666666666,{"$f":"'SW a aplikacie'!C$21*1/3","v":135797.66666666666},{"$f":"'SW a aplikacie'!D$21*1/3","v":19399.666666666668},{"$f":"'SW a aplikacie'!E$21*1/3","v":38799.333333333336}]
[null,null,null,"t4",0]
[null,null,null,"t5",0]
[null,null,null,"t6",0]
[null,null,null,"t7",0]
[null,null,null,"t8",0]
[null,null,null,"t9",0]
[null,null,null,"t10",0]
["Školenia spojené so SW a aplikáciou","518 Ostatné služby",637001,"t1",0]
[null,null,null,"t2",883289.33947500004,{"$f":"('SW a aplikacie'!C14+'SW a aplikacie'!C11)*0.5","v":618302.53763250005},{"$f":"('SW a aplikacie'!D14+'SW a aplikacie'!D11)*0.5","v":88328.933947500002},{"$f":"('SW a aplikacie'!E14+'SW a aplikacie'!E11)*0.5","v":176657.867895}]
[null,null,null,"t3",883289.33947500004,{"$f":"('SW a aplikacie'!C14+'SW a aplikacie'!C11)*0.5","v":618302.53763250005},{"$f":"('SW a aplikacie'!D14+'SW a aplikacie'!D11)*0.5","v":88328.933947500002},{"$f":"('SW a aplikacie'!E14+'SW a aplikacie'!E11)*0.5","v":176657.867895}]
[null,null,null,"t4",0]
[null,null,null,"t5",0]
[null,null,null,"t6",0]
[null,null,null,"t7",0]
[null,null,null,"t8",0]
[null,null,null,"t9",0]
[null,null,null,"t10",0]
["Prevádzka vytvoreného riešenia",null,null,null,{"$f":"E57+E78","v":14102950.90975},{"$f":"F57+F78","v":11741065.636824995},{"$f":"G57+G78","v":787295.09097499982},{"$f":"H57+H78","v":1574590.1819499996}]
["SW produkty",null,null,null,{"$f":"SUM(E58:E77)","v":3528000},{"$f":"SUM(F58:F77)","v":2469600},{"$f":"SUM(G58:G77)","v":352800},{"$f":"SUM(H58:H77)","v":705600}]
["Poplatky vlastníkovi SW produktu - údržba / support k licenciám","511 Opravy a udržiavanie",635009,"t1",{"$f":"SUM(F58:H58)","v":0}]
[null,null,null,"t2",{"$f":"SUM(F59:H59)","v":0}]
[null,null,null,"t3",{"$f":"SUM(F60:H60)","v":0}]
[null,null,null,"t4",504000,{"$f":"'SW a aplikacie'!C$32/7","v":352800},{"$f":"'SW a aplikacie'!D$32/7","v":50400},{"$f":"'SW a aplikacie'!E$32/7","v":100800}]
[null,null,null,"t5",504000,{"$f":"'SW a aplikacie'!C$32/7","v":352800},{"$f":"'SW a aplikacie'!D$32/7","v":50400},{"$f":"'SW a aplikacie'!E$32/7","v":100800}]
[null,null,null,"t6",504000,{"$f":"'SW a aplikacie'!C$32/7","v":352800},{"$f":"'SW a aplikacie'!D$32/7","v":50400},{"$f":"'SW a aplikacie'!E$32/7","v":100800}]
[null,null,null,"t7",504000,{"$f":"'SW a aplikacie'!C$32/7","v":352800},{"$f":"'SW a aplikacie'!D$32/7","v":50400},{"$f":"'SW a aplikacie'!E$32/7","v":100800}]
[null,null,null,"t8",504000,{"$f":"'SW a aplikacie'!C$32/7","v":352800},{"$f":"'SW a aplikacie'!D$32/7","v":50400},{"$f":"'SW a aplikacie'!E$32/7","v":100800}]
[null,null,null,"t9",504000,{"$f":"'SW a aplikacie'!C$32/7","v":352800},{"$f":"'SW a aplikacie'!D$32/7","v":50400},{"$f":"'SW a aplikacie'!E$32/7","v":100800}]
[null,null,null,"t10",504000,{"$f":"'SW a aplikacie'!C$32/7","v":352800},{"$f":"'SW a aplikacie'!D$32/7","v":50400},{"$f":"'SW a aplikacie'!E$32/7","v":100800}]
["Upgrade SW produktu","013 Softvér",718006,"t1",0]
[null,null,null,"t2",0]
[null,null,null,"t3",0]
[null,null,null,"t4",0]
[null,null,null,"t5",0]
[null,null,null,"t6",0]
[null,null,null,"t7",0]
[null,null,null,"t8",0]
[null,null,null,"t9",0]
[null,null,null,"t10",0]
["Aplikácie",null,null,null,{"$f":"SUM(E79:E128)","v":10574950.90975},{"$f":"SUM(F79:F128)","v":9271465.6368249953},{"$f":"SUM(G79:G128)","v":434495.09097499982},{"$f":"SUM(H79:H128)","v":868990.18194999965}]
["Poplatky za udržanie funkčnosti / dostupnosti aplikácie / update","511 Opravy a udržiavanie",635009,"t1",{"$f":"SUM(F79:H79)","v":0}]
[null,null,null,"t2",{"$f":"SUM(F80:H80)","v":0}]
[null,null,null,"t3",{"$f":"SUM(F81:H81)","v":0}]
[null,null,null,"t4",371588.64425000001,{"$f":"'SW a aplikacie'!C$35/7","v":260112.05097499999},{"$f":"'SW a aplikacie'!D$35/7","v":37158.864425},{"$f":"'SW a aplikacie'!E$35/7","v":74317.72885}]
[null,null,null,"t5",371588.64425000001,{"$f":"'SW a aplikacie'!C$35/7","v":260112.05097499999},{"$f":"'SW a aplikacie'!D$35/7","v":37158.864425},{"$f":"'SW a aplikacie'!E$35/7","v":74317.72885}]
[null,null,null,"t6",371588.64425000001,{"$f":"'SW a aplikacie'!C$35/7","v":260112.05097499999},{"$f":"'SW a aplikacie'!D$35/7","v":37158.864425},{"$f":"'SW a aplikacie'!E$35/7","v":74317.72885}]
[null,null,null,"t7",371588.64425000001,{"$f":"'SW a aplikacie'!C$35/7","v":260112.05097499999},{"$f":"'SW a aplikacie'!D$35/7","v":37158.864425},{"$f":"'SW a aplikacie'!E$35/7","v":74317.72885}]
[null,null,null,"t8",371588.64425000001,{"$f":"'SW a aplikacie'!C$35/7","v":260112.05097499999},{"$f":"'SW a aplikacie'!D$35/7","v":37158.864425},{"$f":"'SW a aplikacie'!E$35/7","v":74317.72885}]
[null,null,null,"t9",371588.64425000001,{"$f":"'SW a aplikacie'!C$35/7","v":260112.05097499999},{"$f":"'SW a aplikacie'!D$35/7","v":37158.864425},{"$f":"'SW a aplikacie'!E$35/7","v":74317.72885}]
[null,null,null,"t10",371588.64425000001,{"$f":"'SW a aplikacie'!C$35/7","v":260112.05097499999},{"$f":"'SW a aplikacie'!D$35/7","v":37158.864425},{"$f":"'SW a aplikacie'!E$35/7","v":74317.72885}]
["Aplikačná podpora / helpdesk","518 Ostatné služby",637005,"t1",0]
[null,null,null,"t2",0]
[null,null,null,"t3",0]
[null,null,null,"t4",0]
[null,null,null,"t5",0]
[null,null,null,"t6",0]
[null,null,null,"t7",0]
[null,null,null,"t8",0]
[null,null,null,"t9",0]
[null,null,null,"t10",0]
["Rozvoj - doplnenie funkcionality aplikácie / upgrade","013 Softvér",718006,"t1",0,{"$f":"SUMIF(Registre!$Q$4:$Q$63,'TCO - SW'!D99,Registre!$P$4:$P$40)","v":0}]
[null,null,null,"t2",2450000,{"$f":"SUMIF(Registre!$Q$4:$Q$63,'TCO - SW'!D100,Registre!$P$4:$P$40)","v":2450000}]
[null,null,null,"t3",2070000,{"$f":"SUMIF(Registre!$Q$4:$Q$63,'TCO - SW'!D101,Registre!$P$4:$P$40)","v":2070000}]
[null,null,null,"t4",1200000,{"$f":"SUMIF(Registre!$Q$4:$Q$63,'TCO - SW'!D102,Registre!$P$4:$P$40)","v":1200000}]
[null,null,null,"t5",235000,{"$f":"SUMIF(Registre!$Q$4:$Q$63,'TCO - SW'!D103,Registre!$P$4:$P$40)","v":235000}]
[null,null,null,"t6",165000,{"$f":"SUMIF(Registre!$Q$4:$Q$63,'TCO - SW'!D104,Registre!$P$4:$P$40)","v":165000}]
[null,null,null,"t7",110000,{"$f":"SUMIF(Registre!$Q$4:$Q$63,'TCO - SW'!D105,Registre!$P$4:$P$40)","v":110000}]
[null,null,null,"t8",0,{"$f":"SUMIF(Registre!$Q$4:$Q$63,'TCO - SW'!D106,Registre!$P$4:$P$40)","v":0}]
[null,null,null,"t9",0,{"$f":"SUMIF(Registre!$Q$4:$Q$63,'TCO - SW'!D107,Registre!$P$4:$P$40)","v":0}]
[null,null,null,"t10",0,{"$f":"SUMIF(Registre!$Q$4:$Q$63,'TCO - SW'!D108,Registre!$P$4:$P$40)","v":0}]
["Personálne náklady spojené s prevádzkou SW produktu a aplikácie","521 Mzdové výdavky",null,"t1",58780.800000000003,{"$f":"3*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$22","v":41146.559999999998},{"$f":"3*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$23","v":5878.0800000000008},{"$f":"3*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$24","v":11756.160000000002}]
[null,null,null,"t2",117561.60000000001,{"$f":"6*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$22","v":82293.119999999995},{"$f":"6*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$23","v":11756.160000000002},{"$f":"6*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$24","v":23512.320000000003}]
[null,null,null,"t3",195936,{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$22","v":137155.19999999998},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$23","v":19593.600000000002},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$24","v":39187.200000000004}]
[null,null,null,"t4",195936,{"$f":"'SW a aplikacie'!$C$33/7","v":137155.19999999998},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$23","v":19593.600000000002},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$24","v":39187.200000000004}]
[null,null,null,"t5",195936,{"$f":"'SW a aplikacie'!$C$33/7","v":137155.19999999998},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$23","v":19593.600000000002},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$24","v":39187.200000000004}]
[null,null,null,"t6",195936,{"$f":"'SW a aplikacie'!$C$33/7","v":137155.19999999998},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$23","v":19593.600000000002},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$24","v":39187.200000000004}]
[null,null,null,"t7",195936,{"$f":"'SW a aplikacie'!$C$33/7","v":137155.19999999998},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$23","v":19593.600000000002},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$24","v":39187.200000000004}]
[null,null,null,"t8",195936,{"$f":"'SW a aplikacie'!$C$33/7","v":137155.19999999998},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$23","v":19593.600000000002},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$24","v":39187.200000000004}]
[null,null,null,"t9",195936,{"$f":"'SW a aplikacie'!$C$33/7","v":137155.19999999998},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$23","v":19593.600000000002},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$24","v":39187.200000000004}]
[null,null,null,"t10",195936,{"$f":"'SW a aplikacie'!$C$33/7","v":137155.19999999998},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$23","v":19593.600000000002},{"$f":"10*260*8*Faktory!$D$7*'Štandardné aktivity'!$D$24","v":39187.200000000004}]
["Školenia spojené so SW a aplikáciou","518 Ostatné služby",637001,"t1",0]
[null,null,null,"t2",0]
[null,null,null,"t3",0]
[null,null,null,"t4",0]
[null,null,null,"t5",0]
[null,null,null,"t6",0]
[null,null,null,"t7",0]
[null,null,null,"t8",0]
[null,null,null,"t9",0]
[null,null,null,"t10",0]

{"sheet":"TCO - HW","index":9,"n_rows":84,"n_cols":15,"rows_kept":84,"cut":false,"hidden":false,"merged":[[0,0,0,3],[64,0,73,0],[64,1,73,1],[64,2,73,2],[74,0,83,0],[74,1,83,1],[74,2,83,2],[44,0,53,0],[44,1,53,1],[44,2,53,2],[54,0,63,0],[54,1,63,1],[54,2,63,2],[34,0,43,0],[34,1,43,1],[34,2,43,2],[2,0,2,2],[23,0,32,0],[23,1,32,1],[23,2,32,2],[33,0,33,2],[3,0,12,0],[3,1,12,1],[3,2,12,2],[13,0,22,0],[13,1,22,1],[13,2,22,2]]}
["Náklady na obstaranie a prevádzku HW",null,null,null,"SPOLU","eGov služba - VM pre portál - produkcia","eGov služba - VM pre integračná platforma - produkcia","eGov služba - VM pre DB server (všetky prostredia)","eGov služba - VM pre testovacie a školiace prostredia","eGov služba - storage SAN VM","eGov služba - storage so zálohovaním, DB priestory","eGov služba - storage so zálohovaním, DB priestory","Projektové vývojové prostredie","Výkon - návrh, inštalácia a prevádzka cloudu","HW položka N"]
["Názov","Účet/skupina výdavkov","Kód EKO klasifikácie","Obdobie"]
["Obstaranie",null,null,null,{"$f":"SUM(E4:E33)","v":0},{"$f":"SUM(F4:F33)","v":0},{"$f":"SUM(G4:G33)","v":0},{"$f":"SUM(H4:H33)","v":0},0,0,0,0,0,0,{"$f":"SUM(O4:O33)","v":0}]
["Nákup, inštalácia a sprevádzkovanie HW \nvrátane systémového SW","022 Samostatné hnuteľné veci\n a súbory hnuteľných vecí",713002,"t1",{"$f":"SUM(F4:O4)","v":0}]
[null,null,null,"t2",0]
[null,null,null,"t3",0]
[null,null,null,"t4",0]
[null,null,null,"t5",0]
[null,null,null,"t6",0]
[null,null,null,"t7",0]
[null,null,null,"t8",0]
[null,null,null,"t9",0]
[null,null,null,"t10",0]
["Nákup, inštalácia a sprevádzkovanie HW\n vrátane systémového SW","112 Zásoby",633002,"t1",0]
[null,null,null,"t2",0]
[null,null,null,"t3",0]
[null,null,null,"t4",0]
[null,null,null,"t5",0]
[null,null,null,"t6",0]
[null,null,null,"t7",0]
[null,null,null,"t8",0]
[null,null,null,"t9",0]
[null,null,null,"t10",0]
["Školenia spojené s HW","518 Ostatné služby",637001,"t1",0]
[null,null,null,"t2",0]
[null,null,null,"t3",0]
[null,null,null,"t4",0]
[null,null,null,"t5",0]
[null,null,null,"t6",0]
[null,null,null,"t7",0]
[null,null,null,"t8",0]
[null,null,null,"t9",0]
[null,null,null,"t10",0]
["Prevádzka riešenia",null,null,null,{"$f":"SUM(E35:E84)","v":3684314.7520000008},{"$f":"SUM(F35:F84)","v":188029.43999999997},{"$f":"SUM(G35:G84)","v":188029.43999999997},{"$f":"SUM(H35:H84)","v":222481.91999999995},90173.95199999999,1209600,1080000,432000,30000,244000,{"$f":"SUM(O35:O84)","v":0}]
["Poplatky dodávateľovi podpory HW - údržba/maintenance","511 Opravy a udržiavanie",635002,"t1",{"$f":"SUM(F35:O35)","v":0}]
[null,null,null,"t2",302400,{"$nulls":4},{"$f":"'TCO - Riešenie (bez HW a DB)'!B10/2","v":134400},{"$f":"'TCO - Riešenie (bez HW a DB)'!B11/2","v":120000},{"$f":"'TCO - Riešenie (bez HW a DB)'!B12/2","v":48000}]
[null,null,null,"t3",418489.34400000004,{"$f":"'TCO - Riešenie (bez HW a DB)'!B6","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!B7","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!B8","v":27810.239999999998},{"$f":"'TCO - Riešenie (bez HW a DB)'!B9","v":11271.743999999999},{"$f":"'TCO - Riešenie (bez HW a DB)'!B10/2","v":134400},{"$f":"'TCO - Riešenie (bez HW a DB)'!B11/2","v":120000},{"$f":"'TCO - Riešenie (bez HW a DB)'!B12/2","v":48000},{"$f":"'TCO - Riešenie (bez HW a DB)'!B13","v":30000}]
[null,null,null,"t4",388489.34400000004,{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$6","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$7","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$8","v":27810.239999999998},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$9","v":11271.743999999999},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$10","v":134400},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$11","v":120000},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$12","v":48000},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$13","v":0}]
[null,null,null,"t5",388489.34400000004,{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$6","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$7","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$8","v":27810.239999999998},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$9","v":11271.743999999999},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$10","v":134400},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$11","v":120000},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$12","v":48000},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$13","v":0}]
[null,null,null,"t6",388489.34400000004,{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$6","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$7","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$8","v":27810.239999999998},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$9","v":11271.743999999999},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$10","v":134400},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$11","v":120000},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$12","v":48000},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$13","v":0}]
[null,null,null,"t7",388489.34400000004,{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$6","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$7","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$8","v":27810.239999999998},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$9","v":11271.743999999999},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$10","v":134400},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$11","v":120000},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$12","v":48000},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$13","v":0}]
[null,null,null,"t8",388489.34400000004,{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$6","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$7","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$8","v":27810.239999999998},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$9","v":11271.743999999999},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$10","v":134400},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$11","v":120000},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$12","v":48000},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$13","v":0}]
[null,null,null,"t9",388489.34400000004,{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$6","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$7","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$8","v":27810.239999999998},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$9","v":11271.743999999999},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$10","v":134400},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$11","v":120000},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$12","v":48000},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$13","v":0}]
[null,null,null,"t10",388489.34400000004,{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$6","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$7","v":23503.68},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$8","v":27810.239999999998},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$9","v":11271.743999999999},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$10","v":134400},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$11","v":120000},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$12","v":48000},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$13","v":0}]
["Upgrade HW","022 Samostatné hnuteľné veci\n a súbory hnuteľných vecí",718002,"t1",0]
[null,null,null,"t2",0]
[null,null,null,"t3",0]
[null,null,null,"t4",0]
[null,null,null,"t5",0]
[null,null,null,"t6",0]
[null,null,null,"t7",0]
[null,null,null,"t8",0]
[null,null,null,"t9",0]
[null,null,null,"t10",0]
["Náklady na priestory, energie",null,632001,"t1",0]
[null,null,null,"t2",0]
[null,null,null,"t3",0]
[null,null,null,"t4",0]
[null,null,null,"t5",0]
[null,null,null,"t6",0]
[null,null,null,"t7",0]
[null,null,null,"t8",0]
[null,null,null,"t9",0]
[null,null,null,"t10",0]
["Personálne náklady spojené s prevádzkou HW",null,632001,"t1",53333.333333333336,{"$nulls":8},{"$f":"'TCO - Riešenie (bez HW a DB)'!$B$14/3","v":53333.333333333336}]
[null,null,null,"t2",53333.333333333336,{"$nulls":8},{"$f":"'TCO - Riešenie (bez HW a DB)'!$B$14/3","v":53333.333333333336}]
[null,null,null,"t3",53333.333333333336,{"$nulls":8},{"$f":"'TCO - Riešenie (bez HW a DB)'!$B$14/3","v":53333.333333333336}]
[null,null,null,"t4",12000,{"$nulls":8},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$14","v":12000}]
[null,null,null,"t5",12000,{"$nulls":8},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$14","v":12000}]
[null,null,null,"t6",12000,{"$nulls":8},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$14","v":12000}]
[null,null,null,"t7",12000,{"$nulls":8},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$14","v":12000}]
[null,null,null,"t8",12000,{"$nulls":8},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$14","v":12000}]
[null,null,null,"t9",12000,{"$nulls":8},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$14","v":12000}]
[null,null,null,"t10",12000,{"$nulls":8},{"$f":"'TCO - Riešenie (bez HW a DB)'!$D$14","v":12000}]
["Školenia spojené s HW","518 Ostatné služby",637001,"t1",0]
[null,null,null,"t2",0]
[null,null,null,"t3",0]
[null,null,null,"t4",0]
[null,null,null,"t5",0]
[null,null,null,"t6",0]
[null,null,null,"t7",0]
[null,null,null,"t8",0]
[null,null,null,"t9",0]
[null,null,null,"t10",0]

{"sheet":"Faktory","index":10,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,3,3,3],[4,0,5,0],[4,3,5,3],[6,0,7,0],[6,3,7,3],[6,1,7,1],[2,1,3,1],[2,2,3,2],[6,2,7,2],[4,2,5,2],[10,2,11,2],[10,0,11,0],[10,1,11,1],[10,3,11,3],[8,0,9,0],[8,3,9,3],[8,2,9,2],[8,1,9,1]]}
["Názov","Popis","Jednotka","Hodnota"]
["Životnosť projektu (t)","Referenčné obdobie je počet rokov, na ktorý sa vo finančnej analýze (analýze nákladov a výnosov) uvádzajú predpovede. Predpovede týkajúce sa budúceho trendu projektu by sa mali formulovať na obdobie, ktoré je primerané jeho ekonomicky užitočnému trvaniu a ktoré je dosť dlhé na to, aby zahŕňalo jeho pravdepodobné dlhodobejšie dosahy. Ide o časové obdobie, kedy je možné overiť úspešnosť investície. Trvanie sa mení podľa povahy investície. Referenčný časový horizont v rokoch podľa sektorov je uvedený podľa prílohy 1 Delegovaného nariadenia Komisie (EÚ) 480/2014 z 3. marca 2014, ktorým sa dopĺňa všeobecné nariadenie.","rok",10]
["Referenčná diskontná sadzba (i)","Diskontná sadzba, ktorá sa má používať vo finančnej analýze má informovať investora o alternatívnych kapitálových nákladoch. Môže sa za ňu považovať ušlý výnos najlepšieho alternatívneho projektu.\nV prípade verejných investičných projektov spolufinancovaných z fondov sa stanovuje 4 % finančná diskontná sadzbu pre výpočet čistej súčasnej hodnoty investície v stálych cenách roku predloženia žiadosti o NFP.\n","%",0.04]
[]
["Sociálna diskontná sadzba (r)","Cieľom CBA je preukázať pri štrukturálne významných investíciách, že ekonomická čistá súčasná hodnota za dané obdobie a pri stanovenej sociálnej diskontnej sadzbe je kladná.","%",0.05]
[null,"Diskontovanie odhadovaných nákladov a prínosov: keď sa odhadne tok ekonomických nákladov a prínosov, mala by sa uplatniť štandardná diskontovaná metodika peňažného toku pomocou sociálnej diskontnej sadzby"]
["Osobné náklady (Cper)","Cper=(1011*1,358)/160, pričom 1373 EUR  je priemerná hrubá mzda vo verejnej správe za 3. štvrťrok 2014. Odvody (SP, ZP, SF) sú 35,8%. Fond pracovnej doby na 1 mesiac je 160 hodín (čas na prestávku nie je započítaný).  \nOsobné náklady sú faktorom prevádzkových variabilných nákladov.  \n","EUR/hod",9.42]
[]
["Materiálové náklady podania (Cpap)","Cpap=Poštovné (0,83 EUR)+Tlač (0,02 EUR)+Papier (0,01 EUR)+Obálka (0,03 EUR).  \nMateriálové náklady podania sú faktorom prevádzkových variabilných nákladov.","EUR",0]
[]
["Priemerná mzda v NH","Cperc","EUR/hod",{"$f":"853.7/(22*8)","v":4.8505681818181818}]
[]
["t1","Prvý rok, ktorým výpočet CBA a TCO začína, rok začatia projektu ","rok",2017]

{"sheet":"Podklady>>>","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TCO - Riešenie (bez HW a DB)","index":12,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,2,0],[0,1,0,3],[0,4,2,4],[0,5,1,6],[1,1,2,1],[1,2,1,3]]}
["Popis","Náklady",null,null,"Predpoklady","Požiadavky"]
[null,"Obstaranie (roky 1 - 3)","Rok prevádzky"]
[null,null,"%","€",null,"Počet","Typ"]
["Infraštruktúra (požiadavky na umiestnenie v cloude)"]
["eGov služba - Pripojenie k sieťovým uzlom"]
["eGov služba - VM pre portál - produkcia",{"$f":"F6*'[1]eGovCloud - Parametre'!$B$9*'[1]eGovCloud - Parametre'!$B$7","v":23503.68},null,{"$f":"F6*'[1]eGovCloud - Parametre'!$B$9","v":23503.68},"Uvedené VM sú spolu porovnatelné s 1 server 4CPU - 8Cores - 128GB RAM",8,"Virtual Machine"]
["eGov služba - VM pre integračná platforma - produkcia",{"$f":"F7*'[1]eGovCloud - Parametre'!$B$9*'[1]eGovCloud - Parametre'!$B$7","v":23503.68},null,{"$f":"F7*'[1]eGovCloud - Parametre'!$B$9","v":23503.68},"Uvedené VM sú spolu porovnatelné s 1 server 4CPU - 8Cores - 128GB RAM",8,"Virtual Machine"]
["eGov služba - VM pre DB server (všetky prostredia)",{"$f":"F8*'[1]eGovCloud - Parametre'!$B$10*'[1]eGovCloud - Parametre'!$B$7","v":27810.239999999998},null,{"$f":"F8*'[1]eGovCloud - Parametre'!$B$10","v":27810.239999999998},"Uvedené VM sú spolu porovnatelné s 1 server 4CPU - 8Cores - 256GB RAM",4,"Virtual Machine"]
["eGov služba - VM pre testovacie a školiace prostredia",{"$f":"F9*'[1]eGovCloud - Parametre'!$B$11*'[1]eGovCloud - Parametre'!$B$7*'[1]eGovCloud - Parametre'!$B$12","v":11271.743999999999},null,{"$f":"F9*'[1]eGovCloud - Parametre'!$B$11*'[1]eGovCloud - Parametre'!$B$12","v":11271.743999999999},"spolu porovnatelné s 1 server 4CPU - 8Cores - 128GB RAM, počet VM",12,"Virtual Machine"]
["eGov služba - storage SAN VM",{"$f":"F10*'[1]eGovCloud - Parametre'!$B$13*'[1]eGovCloud - Parametre'!$B$8","v":268800},{"$f":"'TCO - Riešenie (bez HW a DB)'!B180","v":0},{"$f":"F10*'[1]eGovCloud - Parametre'!$B$13","v":134400},"nižšia úroven výkonu, minimálne zálohovanie",{"$f":"'[1]eGovCloud - Parametre'!B2*'[1]eGovCloud - Parametre'!$B$3*'[1]eGovCloud - Parametre'!$B$16","v":112},"GiB"]
["eGov služba - storage so zálohovaním, DB priestory",{"$f":"F11*'[1]eGovCloud - Parametre'!$B$15*'[1]eGovCloud - Parametre'!$B$8","v":240000},null,{"$f":"F11*'[1]eGovCloud - Parametre'!B15","v":120000},"vyššia kvalita - ostré živé dáta (relačné, OLAP, DB prevádzkové)",10,"TiB"]
["eGov služba - storage so zálohovaním, DB priestory",{"$f":"F12*'[1]eGovCloud - Parametre'!B14*'[1]eGovCloud - Parametre'!B8","v":96000},null,{"$f":"F12*'[1]eGovCloud - Parametre'!B14","v":48000},"stredná kvalita (neprodučné prostredia, archív, súborový systém pre výmenu súborov)",10,"TiB"]
["Projektové vývojové prostredie",30000,null,0,"Prostredie na vývoj riešenia"]
["Výkon - návrh, inštalácia a prevádzka cloudu",{"$f":"800*1*200","v":160000},null,{"$f":"600*0.1*200","v":12000},"1 FTE vyšší pri nasadení, 0.1 FTE prevádzka ročne"]
[]
["Databázová vrstva"]
["Licencie DB engine - MDM+BI Enterprise",{"$f":"F8*'[1]eGovCloud - Parametre'!B5*8","v":320000},0.2,{"$f":"B17*C17","v":64000},"32 Cores"]
[]
["Riešenie"]
["Licencie MDM + Konsolidácia",900000,0.2,{"$f":"B20*C20","v":180000},"10 dizajnérov, 100 užívateľov Prezentačného servera, Prod/Pre-Prod/Test"]
["Licencie digitalizácia",200000,0.2,{"$f":"B21*C21","v":40000},"licencie SW na digitalizáciu, vyťažovanie neštruktúrovaných dátových zdrojov (všetky prostredia)"]
["Licencie prevadzkový monitoring",100000,0.2,{"$f":"B22*C22","v":20000},"licencie za SW monitorovania infraštruktúry a aplikácií (všetky prostredia)"]
["Vyvolané licencie v eGov",200000,null,200000,"platby za vyvolané náklady v iných systémoch, ktoré bude IS KUZZ využívať (eDesk, LTA, ZEP a pod.)"]
["Vývoj riešenia MDM + Konsolidácia",{"$f":"'[1]Sumar MDs'!E16*'[1]MD rates'!C16","v":4937975.3499999996},0.05,{"$f":"B24*C24","v":246898.76749999999},"Kalkulovaných cca 50 registrov neznámej zložitosti a rozsahu."]
["Vývoj riešenia digitalizácia",{"$f":"B24*0.1","v":493797.53499999997},0.05,{"$f":"B25*C25","v":24689.876749999999},"práce na kustomizácií digitalizácie a vyťažovania"]
["Nasadenie, prevádzka",100000,null,100000,"práce spojené s roll-out systému (UAT, nasadenie, zavedenie spätnoväzobného systému, dozor)"]
["Organizačné zabezpečenie",{"$f":"3*260*8*[1]Faktory!D7+6*260*8*[1]Faktory!D7+10*260*8*[1]Faktory!D7","v":372278.4},null,{"$f":"10*260*8*[1]Faktory!D7","v":195936},"Predpoklad vytvorenia organizácie zodpovednej za správu a prevádzku KÚZZ s 10 FTE (počas prvých 3 rokov sa predpokladá postupný nábeh 3, 6, resp. 10 FTE v jednotlivých rokoch)"]
["Riadenie",{"$f":"107*7*170*3","v":381990},null,null,"Interné a externé - cca 7 FTE - Projektový manažér, projektový koordinátor, manažér monitorovania, manažér kvality, technický manažér, projektový asistent, finančný manažér"]
["Školenia",200000,null,null,"vývoj a naplnenie e-learningu, 1 beh školení pre 10 používateľov"]
["Publicita",200000]
[]
["CELKOM",{"$f":"SUM(B5:B31)","v":9286930.6290000007},null,{"$f":"SUM(D5:D31)","v":1472013.9882500002}]
[]
["TOTAL roky 1 - 3",{"$f":"B32","v":9286930.6290000007}]
["TOTAL roky 4 - 10",{"$f":"7*D32","v":10304097.917750001}]
["TOTAL 10 rokov",{"$f":"B34+B35","v":19591028.546750002}]
[]
[null,18584235.152000003]
[null,{"$f":"B36-B38","v":1006793.394749999}]
[]
["Ešte by bolo vhodné:"]
["počítať s obnovou HW po 4 rokoch prevádzky"]

{"sheet":"SW a aplikacie","index":13,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"SW a aplikácie - rozdelenie po moduloch a hlavných aktivitách"]
[]
[null,null,"MDM Rezortná zbernica","MDM Portál","MDM Dátový server","SPOLU"]
[null,"Analýza a dizajn",{"$f":"SUM(C6:C7)","v":950560.25487499987},{"$f":"SUM(D6:D7)","v":135794.32212500001},271588.64425000001,{"$f":"SUM(C5:E5)","v":1357943.2212499999}]
[null,"Vývoj riešenia MDM + Konsolidácia",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$24*'[1]Štandardné aktivity'!$D$24*'[1]Štandardné aktivity'!$D$7","v":864145.68624999991},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$24*'[1]Štandardné aktivity'!$D$25*'[1]Štandardné aktivity'!$D$7","v":123449.38374999999},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$24*'[1]Štandardné aktivity'!$D$26*'[1]Štandardné aktivity'!$D$7","v":246898.76749999999},{"$f":"SUM(C6:E6)","v":1234493.8374999999}]
[null,"Vývoj riešenia digitalizácia",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$25*'[1]Štandardné aktivity'!$D$24*'[1]Štandardné aktivity'!$D$7","v":86414.568624999985},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$25*'[1]Štandardné aktivity'!$D$25*'[1]Štandardné aktivity'!$D$7","v":12344.938375},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$25*'[1]Štandardné aktivity'!$D$26*'[1]Štandardné aktivity'!$D$7","v":24689.876749999999},123449.38374999998]
[null,"Implementácia",{"$f":"SUM(C9:C10)","v":1825075.6893599997},{"$f":"SUM(D9:D10)","v":260725.09847999999},521450.19695999997,2607250.9847999997]
[null,"Vývoj riešenia MDM + Konsolidácia",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$24*'[1]Štandardné aktivity'!$D$24*SUM('[1]Štandardné aktivity'!$D$11:$D$15)","v":1659159.7175999999},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$24*'[1]Štandardné aktivity'!$D$25*SUM('[1]Štandardné aktivity'!$D$11:$D$15)","v":237022.81679999997},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$24*'[1]Štandardné aktivity'!$D$26*SUM('[1]Štandardné aktivity'!$D$11:$D$15)","v":474045.63359999994},2370228.1679999996]
[null,"Vývoj riešenia digitalizácia",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$25*'[1]Štandardné aktivity'!$D$24*SUM('[1]Štandardné aktivity'!$D$11:$D$15)","v":165915.97175999996},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$25*'[1]Štandardné aktivity'!$D$25*SUM('[1]Štandardné aktivity'!$D$11:$D$15)","v":23702.28168},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$25*'[1]Štandardné aktivity'!$D$26*SUM('[1]Štandardné aktivity'!$D$11:$D$15)","v":47404.56336},237022.81679999994]
[null,"Testovanie",{"$f":"SUM(C12:C13)","v":1026605.075265},{"$f":"SUM(D12:D13)","v":146657.867895},293315.73579000001,1466578.6789500001]
[null,"Vývoj riešenia MDM + Konsolidácia",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$24*'[1]Štandardné aktivity'!$D$24*SUM('[1]Štandardné aktivity'!$D$16:$D$19)","v":933277.34114999999},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$24*'[1]Štandardné aktivity'!$D$25*SUM('[1]Štandardné aktivity'!$D$16:$D$19)","v":133325.33444999999},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$24*'[1]Štandardné aktivity'!$D$26*SUM('[1]Štandardné aktivity'!$D$16:$D$19)","v":266650.66889999999},1333253.3444999999]
[null,"Vývoj riešenia digitalizácia",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$25*'[1]Štandardné aktivity'!$D$24*SUM('[1]Štandardné aktivity'!$D$16:$D$19)","v":93327.734114999985},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$25*'[1]Štandardné aktivity'!$D$25*SUM('[1]Štandardné aktivity'!$D$16:$D$19)","v":13332.533445000001},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$25*'[1]Štandardné aktivity'!$D$26*SUM('[1]Štandardné aktivity'!$D$16:$D$19)","v":26665.066890000002},133325.33444999997]
[null,"Nasadenie a školenia",{"$f":"('[1]TCO - Riešenie (bez HW a DB)'!$B$29+'[1]TCO - Riešenie (bez HW a DB)'!$B$26)*'[1]Štandardné aktivity'!$D$24","v":210000},{"$f":"('[1]TCO - Riešenie (bez HW a DB)'!$B$29+'[1]TCO - Riešenie (bez HW a DB)'!$B$26)*'[1]Štandardné aktivity'!$D$25","v":30000},{"$f":"('[1]TCO - Riešenie (bez HW a DB)'!$B$29+'[1]TCO - Riešenie (bez HW a DB)'!$B$26)*'[1]Štandardné aktivity'!$D$26","v":60000},300000]
[null,"Obstaranie SW",{"$f":"SUM(C16:C20)","v":1204000},{"$f":"SUM(D16:D20)","v":172000},344000,1720000]
[null,"Licencie DB engine - MDM+BI Enterprise",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B17*'[1]Štandardné aktivity'!D24","v":224000},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B17*'[1]Štandardné aktivity'!D25","v":32000},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B17*'[1]Štandardné aktivity'!D26","v":64000},320000]
[null,"Licencie MDM + Konsolidácia",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B20*'[1]Štandardné aktivity'!$D$24","v":630000},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B20*'[1]Štandardné aktivity'!$D$25","v":90000},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B20*'[1]Štandardné aktivity'!$D$26","v":180000},900000]
[null,"Licencie digitalizácia",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B21*'[1]Štandardné aktivity'!$D$24","v":140000},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B21*'[1]Štandardné aktivity'!$D$25","v":20000},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B21*'[1]Štandardné aktivity'!$D$26","v":40000},200000]
[null,"Licencie prevadzkový monitoring",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B22*'[1]Štandardné aktivity'!$D$24","v":70000},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B22*'[1]Štandardné aktivity'!$D$25","v":10000},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B22*'[1]Štandardné aktivity'!$D$26","v":20000},100000]
[null,"Vyvolané licencie eGov",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B23*'[1]Štandardné aktivity'!$D$24","v":140000},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B23*'[1]Štandardné aktivity'!$D$25","v":20000},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B23*'[1]Štandardné aktivity'!$D$26","v":40000},200000]
[null,"Podporné aktivity",{"$f":"SUM(C22:C23)","v":407393},{"$f":"SUM(D22:D23)","v":58199},116398,581990]
[null,"Publicita",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B30*'[1]Štandardné aktivity'!$D$24","v":140000},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B30*'[1]Štandardné aktivity'!$D$25","v":20000},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B30*'[1]Štandardné aktivity'!D26","v":40000},200000]
[null,"Projektové riadenie",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B28*'[1]Štandardné aktivity'!$D$24","v":267393},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B28*'[1]Štandardné aktivity'!$D$25","v":38199},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!B28*'[1]Štandardné aktivity'!$D$26","v":76398},381990]
[null,"SPOLU",{"$f":"C5+C8+C11+C14+C15+C21","v":5623634.0195000004},{"$f":"D5+D8+D11+D14+D15+D21","v":803376.28850000002},1606752.577,8033762.8849999998]
[]
[null,"Prevádzka - cloud (1-3 rok)",{"$f":"SUM('[1]TCO - Riešenie (bez HW a DB)'!$B$6:$B$14)*'[1]Štandardné aktivity'!$D$24","v":616622.54079999996},{"$f":"SUM('[1]TCO - Riešenie (bez HW a DB)'!$B$6:$B$14)*'[1]Štandardné aktivity'!$D$25","v":88088.934400000013},{"$f":"SUM('[1]TCO - Riešenie (bez HW a DB)'!$B$6:$B$14)*'[1]Štandardné aktivity'!$D$26","v":176177.86880000003},880889.34400000004]
[null,"Prevádzka - organizačné zabezpečenie (1-3 rok)",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$27*'[1]Štandardné aktivity'!$D$24","v":260594.88},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$27*'[1]Štandardné aktivity'!$D$25","v":37227.840000000004},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$B$27*'[1]Štandardné aktivity'!$D$26","v":74455.680000000008},{"$f":"SUM(C27:E27)","v":372278.4}]
[]
[null,"SPOLU Náklady projektu",{"$f":"C24+C26+C27","v":6500851.4402999999},{"$f":"D24+D26+D27","v":928693.06290000002},1857386.1258,9286930.6290000007]
[]
[null,"Mimo nákladov projektu"]
[null,"Prevádzka - licencie (4-10 rok)",{"$f":"(('[1]TCO - Riešenie (bez HW a DB)'!$D$17+'[1]TCO - Riešenie (bez HW a DB)'!$D$20+'[1]TCO - Riešenie (bez HW a DB)'!$D$21+'[1]TCO - Riešenie (bez HW a DB)'!$D$22+'[1]TCO - Riešenie (bez HW a DB)'!$D$23)*'[1]Štandardné aktivity'!$D$24)*7","v":2469600},{"$f":"(('[1]TCO - Riešenie (bez HW a DB)'!$D$17+'[1]TCO - Riešenie (bez HW a DB)'!$D$20+'[1]TCO - Riešenie (bez HW a DB)'!$D$21+'[1]TCO - Riešenie (bez HW a DB)'!$D$22+'[1]TCO - Riešenie (bez HW a DB)'!$D$23)*'[1]Štandardné aktivity'!$D$25)*7","v":352800},{"$f":"(('[1]TCO - Riešenie (bez HW a DB)'!$D$17+'[1]TCO - Riešenie (bez HW a DB)'!$D$20+'[1]TCO - Riešenie (bez HW a DB)'!$D$21+'[1]TCO - Riešenie (bez HW a DB)'!$D$22+'[1]TCO - Riešenie (bez HW a DB)'!$D$23)*'[1]Štandardné aktivity'!$D$26)*7","v":705600},3528000]
[null,"Prevádzka - organizažné zabezpečenie (4-10 rok)",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$D$27*'[1]Štandardné aktivity'!$D$24*7","v":960086.39999999991},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$D$27*'[1]Štandardné aktivity'!$D$25*7","v":137155.20000000001},{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!$D$27*'[1]Štandardné aktivity'!$D$26*7","v":274310.40000000002},1371552]
[null,"Prevádzka - cloud (4-10 rok)",{"$f":"(SUM('[1]TCO - Riešenie (bez HW a DB)'!$D$6:$D$14)*'[1]Štandardné aktivity'!$D$24)*7","v":1962397.7856000001},{"$f":"(SUM('[1]TCO - Riešenie (bez HW a DB)'!$D$6:$D$14)*'[1]Štandardné aktivity'!$D$25)*7","v":280342.54080000002},{"$f":"(SUM('[1]TCO - Riešenie (bez HW a DB)'!$D$6:$D$14)*'[1]Štandardné aktivity'!$D$26)*7","v":560685.08160000003},2803425.4080000003]
[null,"Prevádzka - ostatné (4-10 rok)",{"$f":"(('[1]TCO - Riešenie (bez HW a DB)'!$D$24+'[1]TCO - Riešenie (bez HW a DB)'!$D$25+'[1]TCO - Riešenie (bez HW a DB)'!$D$26+'[1]TCO - Riešenie (bez HW a DB)'!$D$28)*'[1]Štandardné aktivity'!$D$24)*7","v":1820784.3568249999},{"$f":"(('[1]TCO - Riešenie (bez HW a DB)'!$D$24+'[1]TCO - Riešenie (bez HW a DB)'!$D$25+'[1]TCO - Riešenie (bez HW a DB)'!$D$26+'[1]TCO - Riešenie (bez HW a DB)'!$D$28)*'[1]Štandardné aktivity'!$D$25)*7","v":260112.05097499999},{"$f":"(('[1]TCO - Riešenie (bez HW a DB)'!$D$24+'[1]TCO - Riešenie (bez HW a DB)'!$D$25+'[1]TCO - Riešenie (bez HW a DB)'!$D$26+'[1]TCO - Riešenie (bez HW a DB)'!$D$28)*'[1]Štandardné aktivity'!$D$26)*7","v":520224.10194999998},2601120.5097499997]
[null,"SPOLU Prevádzka (4-10 rok)",{"$f":"SUM(C32:C35)","v":7212868.5424249992},{"$f":"SUM(D32:D35)","v":1030409.791775},2060819.5835500001,{"$f":"SUM(C36:E36)","v":10304097.917749999}]

{"sheet":"eGovCloud - Parametre","index":14,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"e-GovCloud Parametre"]
[]
[null,"Popis","Počet","Poznámka","Link"]
[null,"Spolu VM",{"$f":"'[1]TCO - Riešenie (bez HW a DB)'!F6+'[1]TCO - Riešenie (bez HW a DB)'!F7+'[1]TCO - Riešenie (bez HW a DB)'!F9","v":28}]
[null,"GiB per VM",40,"diskový priestor pre OS"]
[]
[null,"DB licencia per Core",10000,"napr. Pre MSSQL Enterprise DataCenter + BI je to 7000"]
[]
[null,"koeficient prvých troch rokov PROD",1,"z troch rokov dodavky toto prostredie bude zit tolkoto rokov"]
[null,"koeficient prvých troch rokov NonPROD",2,"z troch rokov dodavky toto prostredie bude zit tolkoto rokov"]
[null,"eGovCloud VM PROD",{"$f":"244.83*12","v":2937.96},"4 vCPU, 16 GiB RAM","https://metais.finance.gov.sk/detail/InfraSluzbaCennikovyZaznam/585e25fe-b582-4073-a9a0-02fd76cb8b34/cimaster?tab=summarizingCart"]
[null,"eGovCloud VM DBD",{"$f":"579.38*12","v":6952.5599999999995},"8 vCPU, 64 Gib RAM","https://metais.finance.gov.sk/detail/InfraSluzbaCennikovyZaznam/4b78480f-ecf9-4dcc-a9f1-d1883126173f/cimaster?tab=summarizingCart"]
[null,"eGovCloud VM PROD",{"$f":"130.46*12","v":1565.52},"2 vCPU, 8 GiB","https://metais.finance.gov.sk/detail/InfraSluzbaCennikovyZaznam/d0433b37-1bb4-4f32-9423-437f00acb89e/cimaster?tab=summarizingCart"]
[null,"koeficient eGov cloud nonPROD",0.6,"koeficient pre výpočet ceny za nonPROD prostredia (v MetaIS cena zrejme nie je)"]
[null,"eGov Storage SAN per 1GiB",{"$f":"100*12","v":1200},"Ceny sme nenasli v MetaIS, uvadzame nase odhady. Plati sa za neho a ide to do projektu?"]
[null,"eGov Storage per 1TiB (stredná)",{"$f":"400*12","v":4800},"Ceny sme nenasli v MetaIS, uvadzame nase odhady. Plati sa za neho a ide to do projektu?"]
[null,"eGov Storage per 1TiB (vysoká)",{"$f":"1000*12","v":12000},"Ceny sme nenasli v MetaIS, uvadzame nase odhady. Plati sa za neho a ide to do projektu?"]
[null,"koeficient deduplikacie VM",0.1,"koeficient pre výpočet kapacitu diskového priestoru na zálohovenie VM"]

{"sheet":"Sumar MDs","index":15,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,1,4],[21,1,21,3]]}
[]
[null,"Sumár MDs"]
[]
[null,"Kategória registra","Trieda","Počet","MDs na register","MDs Celkovo",null,"Faktory pre výpočet",null,"Poznámka"]
[null,{"$f":"'[1]Klasifikacia pre Impl'!A2","v":"číselník"},"Vzorové",{"$f":"IF('[1]Klasifikacia pre Impl'!B2>=I$5,I$5,'[1]Klasifikacia pre Impl'!B2)","v":10},{"$f":"VLOOKUP(B5,'[1]Klasifikacia pre Impl'!$A$2:$C$6,3)","v":20},{"$f":"D5*E5","v":200},null,"Počet vzorových implementácií pre kategóriu registra",10,"Výchádza z počtu organizácií (list \"Registre\", stĺpec \"Správca\")"]
[null,{"$f":"'[1]Klasifikacia pre Impl'!A2","v":"číselník"},"Ďalšie",{"$f":"'[1]Klasifikacia pre Impl'!B2-D5","v":112},{"$f":"VLOOKUP(B6,'[1]Klasifikacia pre Impl'!$A$2:$C$6,3)*(1-$I$6)","v":10},{"$f":"D6*E6","v":1120},null,"Úspora pri znovupoužití postupov pre číselníky",0.5]
[{"$nulls":7},"Úspora pri znovupoužití postupov pre registre - manuálny",0.1]
[null,{"$f":"'[1]Klasifikacia pre Impl'!A3","v":"manuálny"},"Vzorové",{"$f":"IF('[1]Klasifikacia pre Impl'!B3>=I$5,I$5,'[1]Klasifikacia pre Impl'!B3)","v":10},{"$f":"VLOOKUP(B8,'[1]Klasifikacia pre Impl'!$A$2:$C$6,3)","v":200},{"$f":"D8*E8","v":2000},null,"Úspora pri znovupoužití postupov pre registre - plne automatizovaný",0.3]
[null,{"$f":"'[1]Klasifikacia pre Impl'!A3","v":"manuálny"},"Ďalšie",{"$f":"'[1]Klasifikacia pre Impl'!B3-D8","v":22},{"$f":"VLOOKUP(B9,'[1]Klasifikacia pre Impl'!$A$2:$C$6,3)*(1-$I$7)","v":180},{"$f":"D9*E9","v":3960},null,"Úspora pri znovupoužití postupov pre registre - poloautomatický",0.3]
[{"$nulls":7},"Úspora pri znovupoužití postupov pre registre - webový",0.3]
[null,{"$f":"'[1]Klasifikacia pre Impl'!A4","v":"plne automatizovaný"},"Vzorové",{"$f":"IF('[1]Klasifikacia pre Impl'!B4>=I$5,I$5,'[1]Klasifikacia pre Impl'!B4)","v":0},{"$f":"VLOOKUP(B11,'[1]Klasifikacia pre Impl'!$A$2:$C$6,3)","v":130},{"$f":"D11*E11","v":0}]
[null,{"$f":"'[1]Klasifikacia pre Impl'!A4","v":"plne automatizovaný"},"Ďalšie",{"$f":"'[1]Klasifikacia pre Impl'!B4-D11","v":0},{"$f":"VLOOKUP(B12,'[1]Klasifikacia pre Impl'!$A$2:$C$6,3)*(1-$I$8)","v":91},{"$f":"D12*E12","v":0}]
[]
[null,{"$f":"'[1]Klasifikacia pre Impl'!A5","v":"poloautomatický"},"Vzorové",{"$f":"IF('[1]Klasifikacia pre Impl'!B5>=I$5,I$5,'[1]Klasifikacia pre Impl'!B5)","v":10},{"$f":"VLOOKUP(B14,'[1]Klasifikacia pre Impl'!$A$2:$C$6,3)","v":150},{"$f":"D14*E14","v":1500}]
[null,{"$f":"'[1]Klasifikacia pre Impl'!A5","v":"poloautomatický"},"Ďalšie",{"$f":"'[1]Klasifikacia pre Impl'!B5-D14","v":17},{"$f":"VLOOKUP(B15,'[1]Klasifikacia pre Impl'!$A$2:$C$6,3)*(1-$I$9)","v":105},{"$f":"D15*E15","v":1785}]
[]
[null,{"$f":"'[1]Klasifikacia pre Impl'!A6","v":"webový"},"Vzorové",{"$f":"IF('[1]Klasifikacia pre Impl'!B6>=I$5,I$5,'[1]Klasifikacia pre Impl'!B6)","v":0},{"$f":"VLOOKUP(B17,'[1]Klasifikacia pre Impl'!$A$2:$C$6,3)","v":200},{"$f":"D17*E17","v":0}]
[null,{"$f":"'[1]Klasifikacia pre Impl'!A6","v":"webový"},"Ďalšie",{"$f":"'[1]Klasifikacia pre Impl'!B6-D17","v":0},{"$f":"VLOOKUP(B18,'[1]Klasifikacia pre Impl'!$A$2:$C$6,3)*(1-$I$10)","v":140},{"$f":"D18*E18","v":0}]
[null,"Celkom",null,null,null,{"$f":"SUM(F5:F18)","v":10565}]
[]
[]
[null,"Náklady na integráciu na strane zdrojového systému"]
[]
[null,"Významnosť IS","Register/Zoznam","Náklad"]
[null,1,"Zoznam",5000]
[null,2,"Zoznam",10000]
[null,3,"Zoznam",20000]
[null,1,"Register",50000]
[null,2,"Register",100000]
[null,3,"Register",200000]

{"sheet":"Registre","index":16,"n_rows":63,"n_cols":17,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[null,"Zoznam registrov"]
[null,"36 RUVZ a 22 komor"]
[null,"Názov","Správca","Legislatíva/Predpis","Typ","Klasifikácia","IS","Zdroje dát","Vstupné rozhrania","Výstupné rozhrania","Automatizácia","Sizing v MB","Poznámka","Počet atribútov","Významnosť IS","Náklady na integráciu","Fáza projektu (rok)"]
[null,"Národný register poskytovateľov zdravotnej starostlivosti","NCZI","Zákon 153/2013, Vyhl. 9/2014","Register","Referenčný","JRÚZ/ISZI","iné registre","csv/txt, xml",null,"poloautomatický",null,null,63,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t2"]
[null,"Národný register zdravotníckych pracovníkov","NCZI","Zákon 153/2013, Vyhl. 9/2014","Register","Referenčný","JRÚZ/ISZI","iné registre","csv/txt, xml, xls",null,"poloautomatický",null,null,122,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t2"]
[null,"Národný register prijímateľov zdravotnej staroslivosti","NCZI","nie je","Register","Referenčný","JRÚZ/ISZI","iné registre","xml",null,"poloautomatický",null,null,469,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t2"]
[null,"Národný farmaceutický register","NCZI","nie je","Register","Referenčný","JRÚZ/ISZI","iné registre","xml, xls",null,"poloautomatický",null,null,null,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t2"]
[null,"Národný register elektronických zdravotných knižiek,","NCZI","Zákon 153/2013, Vyhl. 74/2014, Vyhl. 141/2016","Register","Štatistický","JRÚZ/ISZI","hlásenia","papier, xls, web GUI, xml",null,"poloautomatický",null,null,65,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t2"]
[null,"Národný onkologický register,","NCZI","Zákon 153/2013, Vyhl. 74/2014, Vyhl. 141/2016","Register","Štatistický","JRÚZ/ISZI","hlásenia","papier, xls, web GUI, xml",null,"poloautomatický",null,null,30,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t3"]
[null,"Národný register pacientov s diabetes mellitus,","NCZI","Zákon 153/2013, Vyhl. 74/2014, Vyhl. 141/2016","Register","Štatistický","JRÚZ/ISZI","hlásenia","papier, xls, web GUI, xml",null,"poloautomatický",null,null,25,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t3"]
[null,"Národný register pacientov s vrodenou vývojovou chybou,","NCZI","Zákon 153/2013, Vyhl. 74/2014, Vyhl. 141/2016","Register","Štatistický","JRÚZ/ISZI","hlásenia","papier, xls, web GUI, xml",null,"poloautomatický",null,null,30,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t3"]
[null,"Národný register pacientov so srdcovocievnym ochorením,","NCZI","Zákon 153/2013, Vyhl. 74/2014, Vyhl. 141/2016","Register","Štatistický","JRÚZ/ISZI","hlásenia","papier, xls, web GUI, xml",null,"poloautomatický",null,null,15,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t3"]
[null,"Národný register pacientov s neurologickým ochorením,","NCZI","Zákon 153/2013, Vyhl. 74/2014, Vyhl. 141/2016","Register","Štatistický","JRÚZ/ISZI","hlásenia","papier, xls, web GUI, xml",null,"poloautomatický",null,null,20,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t3"]
[null,"Národný register pacientov s chronickým ochorením pľúc,","NCZI","Zákon 153/2013, Vyhl. 74/2014, Vyhl. 141/2016","Register","Štatistický","JRÚZ/ISZI","hlásenia","papier, xls, web GUI, xml",null,"poloautomatický",null,null,20,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t3"]
[null,"Národný register pacientov s tuberkulózou,","NCZI","Zákon 153/2013, Vyhl. 74/2014, Vyhl. 141/2016","Register","Štatistický","JRÚZ/ISZI","hlásenia","papier, xls, web GUI, xml",null,"poloautomatický",null,null,25,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t4"]
[null,"Národný artroplastický register,","NCZI","Zákon 153/2013, Vyhl. 74/2014, Vyhl. 141/2016","Register","Štatistický","JRÚZ/ISZI","hlásenia","papier, xls, web GUI, xml",null,"poloautomatický",null,null,30,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t4"]
[null,"Národný register pacientov so zápalovým reumatickým ochorením,","NCZI","Zákon 153/2013, Vyhl. 74/2014, Vyhl. 141/2016","Register","Štatistický","JRÚZ/ISZI","hlásenia","papier, xls, web GUI, xml",null,"poloautomatický",null,null,20,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t4"]
[null,"Národný register osôb s úrazom vyžadujúcim poskytnutie ústavnej zdravotnej starostlivosti,","NCZI","Zákon 153/2013, Vyhl. 74/2014, Vyhl. 141/2016","Register","Štatistický","JRÚZ/ISZI","hlásenia","papier, xls, web GUI, xml",null,"poloautomatický",null,null,30,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t4"]
[null,"Národný register osôb s podozrením na ich zanedbávanie, týranie, zneužívanie a osôb, na ktorých bolo páchané násilie,","NCZI","Zákon 153/2013, Vyhl. 74/2014, Vyhl. 141/2016","Register","Štatistický","JRÚZ/ISZI","hlásenia","papier, xls, web GUI, xml",null,"poloautomatický",null,null,40,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t4"]
[null,"Národný register asistovanej reprodukcie.","NCZI","Zákon 153/2013, Vyhl. 74/2014, Vyhl. 141/2016","Register","Štatistický","JRÚZ/ISZI","hlásenia","papier, xls, web GUI, xml",null,"poloautomatický",null,null,20,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t4"]
[null,"Národný register organizácií nakladujúcich s liekmi","NCZI","Zákon 362/2011","Register","Referenčný","Excel","nie sú definované","xls",null,"manuálny",null,null,"N/A",1,{"$f":"'[1]Sumar MDs'!$C$25","v":50000},"t5"]
[null,"Centrálny register poistencov","ÚDZS","Zákon 581/2004, Vyhl. 107/2015","Register","Referenčný","IS ÚDZS",null,null,"xml,dbx","poloautomatický",null,null,17,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t2"]
[null,"Register poskytovateľov zdravotnej starostlivosti","ÚDZS","Zákon 581/2004, Vyhl. 107/2015","Register","Referenčný","IS ÚDZS","dátové vety","xml","xml,xls","poloautomatický",null,null,20,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t2"]
[null,"Register zdravotníckych pracovníkov","ÚDZS","Zákon 581/2004, Vyhl. 107/2015","Register","Referenčný","IS ÚDZS","dátové vety","xml","xml,xls","poloautomatický",null,null,11,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t2"]
[null,"Register úmrtí","ÚDZS","Zákon 581/2004, Vyhl. 107/2015","Register","Referenčný","IS ÚDZS","oznámenie","papier","xml","poloautomatický",null,null,14,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t2"]
[null,"Register zdravotných poisťovní","ÚDZS","Zákon 581/2004, Vyhl. 107/2015","Register","Referenčný","IS ÚDZS",null,null,"xml","poloautomatický",null,null,20,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t2"]
[null,"Register platiteľov poistného","ÚDZS","Zákon 581/2004, Vyhl. 107/2015","Register","Referenčný","IS ÚDZS","dátové vety","xml",null,"poloautomatický",null,null,10,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t2"]
[null,"Register osôb oprávnených na výkon dohľadu","ÚDZS","Zákon 581/2004, Vyhl. 107/2015","Register","Referenčný","IS ÚDZS",null,null,null,"poloautomatický",null,null,6,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t3"]
[null,"Register podaných prihlášok na verejné zdravotné poistenie","ÚDZS","Zákon 581/2004, Vyhl. 107/2015","Register","Referenčný","IS ÚDZS","oznámenie","webové rozhranie",null,"poloautomatický",null,null,20,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t2"]
[null,"Register osôb, ktoré odmietli za života pitvu","ÚDZS","Zákon 581/2004, Vyhl. 107/2015","Register","Referenčný","IS ÚDZS","oznámenie","papier",null,"poloautomatický",null,null,13,1,{"$f":"'[1]Sumar MDs'!$C$25","v":50000},"t5"]
[null,"Register zariadení sociálnych služieb a zariadení sociálnoprávnej ochrany detí a sociálnej kurately","ÚDZS","Zákon 581/2004, Vyhl. 107/2015","Register","Referenčný","IS ÚDZS","žiadosť","papier",null,"poloautomatický",null,null,9,1,{"$f":"'[1]Sumar MDs'!$C$25","v":50000},"t5"]
[null,"Register odborne spôsobilých osôb","ÚVZ SR","Zákon 355/2007","Register","Agendový","IS ÚVZ","formulár","papier, email, xls","email","manuálny",4830,"ročný objem dát",5,1,{"$f":"'[1]Sumar MDs'!$C$25","v":50000},"t2"]
[null,"IS o kúpaliskách a kvalite vody na kúpanie","ÚVZ SR, SAŽP","Zákon 355/2007","Zoznam","Štatistický","IS vody","formulár","papier","email","manuálny",47040,"ročný objem dát",35,1,{"$f":"'[1]Sumar MDs'!$C$22","v":5000},"t5"]
[null,"Zoznam právnických a fyzických osôb – podnikateľov, ktoré majú oprávnenie na vykonávanie činnosti pracovnej zdravotnej služby","ÚVZ SR","Zákon 355/2007","Zoznam","Agendový","Excel","formulár","papier","xls","manuálny",660,"ročný objem dát",6,1,{"$f":"'[1]Sumar MDs'!$C$22","v":5000},"t5"]
[null,"Zoznam fyzických osôb – podnikateľov a právnických osôb, ktoré vykonávajú samostatne dodávateľským spôsobom činnosť pracovnej zdravotnej služby","ÚVZ SR","Zákon 355/2007","Zoznam","Agendový","Excel","formulár","papier","xls","manuálny",0,"ročný objem dát",6,1,{"$f":"'[1]Sumar MDs'!$C$22","v":5000},"t5"]
[null,"Zoznam právnických osôb a fyzických osôb – podnikateľov oprávnených odstraňovať azbestové materiály zo stavieb","ÚVZ SR","Zákon 355/2007","Zoznam","Agendový","Excel","formulár","papier","xls","manuálny",77.5,"ročný objem dát",8,1,{"$f":"'[1]Sumar MDs'!$C$22","v":5000},"t5"]
[null,"Databáza spracovaných informácii z vyšetrení - rezistencie mikroorganizmov na antibiotiká","ÚVZ SR",null,"Zoznam","Agendový","SNARS","formulár","papier","email","manuálny",813580,"ročný objem dát",25,1,{"$f":"'[1]Sumar MDs'!$C$22","v":5000},"t5"]
[null,"Centrálny register rizikových prác","ÚVZ SR","Zákon 355/2007","Register","Agendový","ASTR","formulár","email, dbx","email","manuálny",110,"ročný objem dát",55,1,{"$f":"'[1]Sumar MDs'!$C$25","v":50000},"t5"]
[null,"Register výrobcov a dovozcov nových potravín a zložiek nových potravín","ÚVZ SR","Zákon 355/2007","Zoznam","Agendový","Excel","formulár","papier","xls","manuálny",4522.5,"ročný objem dát",5,1,{"$f":"'[1]Sumar MDs'!$C$22","v":5000},"t5"]
[null,"Register výrobcov a dovozcov výživových\ndoplnkov a potravín na osobitné výživové účely","ÚVZ SR","Zákon 355/2007","Zoznam","Agendový","Excel","formulár","email, web","xls","manuálny",1500,"ročný objem dát",6,1,{"$f":"'[1]Sumar MDs'!$C$22","v":5000},"t5"]
[null,"Register minerálnych vôd a pramenitých vôd","MZ SR","Zákon 355/2007",{"$nulls":10},1,null,"t6"]
[null,"Register činností vedúcich k ožiareniu","ÚVZ SR","Zákon 355/2007","Zoznam","Agendový","Excel","formulár","papier","xls","manuálny",110,"ročný objem dát",8,1,{"$f":"'[1]Sumar MDs'!$C$22","v":5000},"t6"]
[null,"Centrálny register dávok pracovníkov so zdrojmi ionizujúceho žiarenia","ÚVZ SR","Zákon 355/2007","Register","Agendový","IS ÚVZ","formulár","papier, email","email","manuálny",null,"ročný objem dát",15,1,{"$f":"'[1]Sumar MDs'!$C$25","v":50000},"t6"]
[null,"Centrálny register zdrojov ionizujúceho žiarenia","ÚVZ SR","Zákon 355/2007","Zoznam","Agendový","Excel","formulár","papier","xls","manuálny",39000,"ročný objem dát",50,1,{"$f":"'[1]Sumar MDs'!$C$22","v":5000},"t6"]
[null,"Register pacientov s prenosnými ochoreniami","ÚVZ SR","Zákon 355/2007","Register","Agendový","EPIS","formulár","papier, email, telefón","email, interakcia na server","manuálny",19708,"ročný objem dát",40,2,{"$f":"'[1]Sumar MDs'!$C$26","v":100000},"t6"]
[null,"Centrálna databáza vyplnených dotazníkov Testu Zdravé srdce","ÚVZ SR","nie je","Zoznam","Agendový","IS Zdravé srdce","formulár","papier, email",null,"manuálny",10,"ročný objem dát",30,1,{"$f":"'[1]Sumar MDs'!$C$22","v":5000},"t6"]
[null,"Register licencií (zdravotníckych pracovníkov)","Komory","Zákon 578/2004, Vyhl. 107/2015","Register","Agendový","IS komôr","formulár","papier","xml, xls","manuálny",100,"ročný objem dát",30,1,{"$f":"'[1]Sumar MDs'!$C$25","v":50000},"t3"]
[null,"Register komory","Komory","Zákon 578/2004, Vyhl. 107/2015","Register","Agendový","IS komôr","formulár","papier","xml, xls","manuálny",1150,"ročný objem dát",30,1,{"$f":"'[1]Sumar MDs'!$C$25","v":50000},"t3"]
[null,"Register povolení (poskytovateľov zdravotnej starostlivosti)","VÚC, MZ SR, ŠKK","Zákon 578/2004, Zákon 538/2005, Vyhl. 107/2015","Register","Agendový","IS VÚC, IS komory","formulár","papier","xml","manuálny",null,null,40,1,{"$f":"'[1]Sumar MDs'!$C$25","v":50000},"t3"]
[null,"Zoznam kategorizovaných liekov","MZ SR","Zákon 363/2011","Zoznam","Referenčný","IS DALI","formulár","papier, web GUI","web-xls","manuálny",null,null,20,3,{"$f":"'[1]Sumar MDs'!$C$24","v":20000},"t3"]
[null,"Zoznam kategorizovaných zdravotníckych pomôcok","MZ SR","Zákon 363/2011","Zoznam","Referenčný","IS DALI","formulár","papier, web GUI","web-xls","manuálny",null,null,17,3,{"$f":"'[1]Sumar MDs'!$C$24","v":20000},"t3"]
[null,"Zoznam kategorizovaných špeciálnych zdravotníckych materiálov","MZ SR","Zákon 363/2011","Zoznam","Referenčný","IS DALI","formulár","papier, web GUI","web-xls","manuálny",null,null,18,3,{"$f":"'[1]Sumar MDs'!$C$24","v":20000},"t3"]
[null,"Zoznam kategorizovaných dietetických potravín","MZ SR","Zákon 363/2011","Zoznam","Referenčný","IS DALI","formulár","papier, web GUI","web-xls","manuálny",null,null,22,3,{"$f":"'[1]Sumar MDs'!$C$24","v":20000},"t3"]
[null,"Zoznamy úradne určených cien ","MZ SR","Zákon 363/2011","Zoznam","Referenčný","IS DALI","formulár","papier, web GUI","web-xls","manuálny",null,null,10,3,{"$f":"'[1]Sumar MDs'!$C$24","v":20000},"t3"]
[null,"Zoznam zdravotníckych pomôcok na mieru ","MZ SR","Zákon 363/2011","Zoznam","Referenčný","IS DALI","formulár","papier, web GUI","web-xls","manuálny",null,null,21,3,{"$f":"'[1]Sumar MDs'!$C$24","v":20000},"t3"]
[null,"Registrácia humánnych liekov","ŠÚKL","Zákon 362/2011","Register","Agendový","IS o liekoch","formulár","papier",null,"manuálny",138015,null,14,3,{"$f":"'[1]Sumar MDs'!$C$27","v":200000},"t3"]
[null,"Databáza zdravotníckych pomôcok","ŠÚKL","Zákon 362/2011","Register","Agendový","IS o liekoch","formulár","papier",null,"manuálny",198157,null,39,2,{"$f":"'[1]Sumar MDs'!$C$26","v":100000},"t3"]
[null,"Register inšpekcie","ŠÚKL","Zákon 362/2011","Register","Agendový","IS o liekoch","formulár","papier",null,"manuálny",107.5,null,20,1,{"$f":"'[1]Sumar MDs'!$C$25","v":50000},"t3"]
[null,"Register hlásenia nežiaducich účinkoch","ŠÚKL","Zákon 362/2011","Register","Agendový","IS o liekoch","formulár","papier, email, telefón, web",null,"manuálny",4680,null,40,1,{"$f":"'[1]Sumar MDs'!$C$25","v":50000},"t3"]
[null,"Register spisov","RÚVZ","nie je","Register","Agendový","IS Win ASU","nie sú definované","papier, osobne, e-mail",null,"manuálny",201288,"ročný objem dát","N/A",1,{"$f":"'[1]Sumar MDs'!$C$25","v":50000},"t7"]
[null,"Databáza výsledkov laboratórnych vyšetrení","RÚVZ BA",null,"Databáza","Agendový","IS LIMS","formulár","papier",null,"manuálny",null,"ročný objem dát","N/A",1,{"$f":"'[1]Sumar MDs'!$C$22","v":5000},"t7"]
[null,"Register odborne spôsobilých osôb","RÚVZ",null,"Register","Agendový","IS ÚVZ","formulár",null,null,"manuálny",109868,"ročný objem dát",5,1,{"$f":"'[1]Sumar MDs'!$C$25","v":50000},"t7"]
[null,"Databáza spracovaných informácii z vyšetrení","RÚVZ","Zákon 355/2007","Databáza","Agendový","IS o kvalite vody na kúpanie, IS pitná voda","formulár","papier","web","manuálny",2415,"ročný objem dát","N/A",1,{"$f":"'[1]Sumar MDs'!$C$22","v":5000},"t7"]

{"sheet":"Ciselniky","index":17,"n_rows":126,"n_cols":3,"rows_kept":126,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Zoznam číselníkov"]
[]
[null,"Názov číselníka","Vlastný/preberaný"]
[null,"Stav kategorizácie"]
[null,"Stav registrácie"]
[null,"Povolenie viacnásobnej preskripcie"]
[null,"Skupina omamných a psychotropných látok"]
[null,"Lieková forma"]
[null,"Typ liekového upozornenia"]
[null,"Zoznam diagnóz"]
[null,"Zoznam zdravotných výkonov"]
[null,"Funkcia zdravotníckeho pracovníka"]
[null,"Typ kontaktnej osoby"]
[null,"Okolnosti merania krvného tlaku"]
[null,"Dôvod ukončenia a dočasného pozastavenia registrácie"]
[null,"Charakter očkovania"]
[null,"Zdravotnícka odbornosť"]
[null,"Druh očkovaní"]
[null,"Typ očkovania"]
[null,"Druh odbornej činnosti"]
[null,"Druh zariadenia v zdravotníctve"]
[null,"Odborné zameranie v zariadení"]
[null,"Zdravotnícke povolanie"]
[null,"Orgán príslušný na vydanie rozhodnutia v zdravotníctve"]
[null,"Právna forma organizácie","Preberaný"]
[null,"Samosprávny kraj","Preberaný"]
[null,"Lokálna štatistická územná jednotka 1 - okres","Preberaný"]
[null,"Lokálna štatistická územná jednotka 2 - obec","Preberaný"]
[null,"Krajina OSN","Preberaný"]
[null,"Laboratórne položky"]
[null,"Identifikátor","Preberaný"]
[null,"Príbuzenský stav","Preberaný"]
[null,"Pohlavie","Preberaný"]
[null,"Rodinný stav","Preberaný"]
[null,"Existenčný stav","Preberaný"]
[null,"Druhy nežiaducich reakcií"]
[null,"Titul za menom","Preberaný"]
[null,"Typ zainteresovanej osoby","Preberaný"]
[null,"Typy krvných skupín"]
[null,"Typ platiteľa zdravotného poistenia"]
[null,"Dôvod ukončenia zdravotného poistenia"]
[null,"Druh adresy","Preberaný"]
[null,"Typ telefónneho čísla","Preberaný"]
[null,"Typ zdravotného poistenia"]
[null,"Anatomicko-terapeuticko-chemický klasifikačný systém"]
[null,"Titul pred menom","Preberaný"]
[null,"Meracie jednotky pre zdravotnícku informatiku"]
[null,"Spôsob podania"]
[null,"Spôsob úhrady za dietetické potraviny"]
[null,"Spôsob úhrady za zdravotnícke pomôcky"]
[null,"Typ vzorky, alebo biologického materiálu"]
[null,"Viazanosť na lekársky predpis"]
[null,"Zásahové územie ambulancie záchrannej zdravotnej služby"]
[null,"Skupiny limitov dietetických potravín"]
[null,"Spôsob úhrady za liek"]
[null,"Indikačná skupina"]
[null,"Skratky výrobcov dietetických potravín"]
[null,"Typy doplňujúcich informácií"]
[null,"Anatomické miesta"]
[null,"Dôvod nevykonania očkovania"]
[null,"Fázy menštruačného cyklu"]
[null,"Kategória výsledku laboratórneho vyšetrenia"]
[null,"Typ platiteľa za laborátorne vyšetrenie"]
[null,"Reakcie po očkovaní"]
[null,"Spôsob odberu laboratórnej vzorky"]
[null,"Transportné obaly laboratórnej vzorky"]
[null,"Urgentnosť vyšetrenia"]
[null,"Skratky držiteľov rozhodnutia o registrácii lieku, skratky výrobcov"]
[null,"Skratky výrobcov zdravotníckych pomôcok"]
[null,"Druh zdravotníckych pomôcok a implantátov"]
[null,"Metódy merania krvného tlaku"]
[null,"Aplikačná forma dietetickej potraviny"]
[null,"Kód zriaďovateľa poskytovateľa zdravotnej starostlivosti a inej organizácie v zdravotníctve"]
[null,"PSČ","Preberaný"]
[null,"Právny vzťah zdravotníckeho pracovníka"]
[null,"Typ indikátora kvality"]
[null,"Oblasti indikátora kvality"]
[null,"Nesprávny spôsob životosprávy, životný štýl"]
[null,"Alergény"]
[null,"Prejavy nežiaducich reakcií"]
[null,"Zoznam komponentov"]
[null,"Originalita lieku"]
[null,"Spôsoby určenia dátumu pôrodu"]
[null,"Základná jednotka pre zdravotnícku informatiku"]
[null,"Typ jednotky pre zdravotnícku informatiku"]
[null,"Predpona pre zdravotnícku informatiku"]
[null,"Konverzia jednotky pre zdravotnícku informatiku"]
[null,"Skupiny liekovej formy"]
[null,"Farmaceutická surovina"]
[null,"Typ doplňujúceho údaja kontraindikácie"]
[null,"Hodnotenie interakcie"]
[null,"Hodnotenie kontraindikácie"]
[null,"Kvalita zdroja"]
[null,"Jednotka meny","Preberaný"]
[null,"Typ dávkovania"]
[null,"Typ doplňujúceho údaja interakcie"]
[null,"Typ liekovej alergie"]
[null,"Závažnosť varovania interakcie"]
[null,"Merná jednotka zdravotníckej pomôcky"]
[null,"Trieda zdravotníckej pomôcky"]
[null,"Typ identifikačného predmetu"]
[null,"Právny základ odbornej spôsobilosti zdravotníckeho pracovníka"]
[null,"Typ odboru odbornej spôsobilosti zdravotníckeho pracovníka"]
[null,"Typ starostlivosti pri výkone zdravotníckeho povolania"]
[null,"Zaradenie do evidenčného počtu"]
[null,"Titul pred menom zdravotníckeho pracovníka"]
[null,"Titul za menom zdravotníckeho pracovníka"]
[null,"Profesijný titul zdravotníckeho pracovníka"]
[null,"Druh licencie zdravotníckeho pracovníka"]
[null,"Dôvod ukončenia a pozastavenia platnosti licencie"]
[null,"Závažnosť kontraindikácie"]
[null,"Špecifikácia odborného zástupcu poskytovateľa zdravotnej starostlivosti"]
[null,"Typ zákonného zástupcu"]
[null,"Indikácia"]
[null,"Ekonomická činnosť","Preberaný"]
[null,"Inštitucionálne subsektory ESÚ 2010","Preberaný"]
[null,"Druh vlastníctva","Preberaný"]
[null,"Orgány ústrednej štátnej správy","Preberaný"]
[null,"Obmedzenie spôsobilosti na právne úkony","Preberaný"]
[null,"Mikroorganizmus"]
[null,"Dostupnosť lieku v SR"]
[null,"Dostupnosť lieku v lekárni"]
[null,"Spôsob platby"]
[null,"Spôsob doručenia"]
[null,"Plánovaná zdravotná starostlivosť podľa čakacieho zoznamu"]

{"sheet":"Klasifikacia pre Impl","index":18,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Zoznam číselníkov"]
[]
[null,"Kategória registra","Počet registrov","Počet MDs\nna vzorový register"]
[null,"číselník",122,20]
[null,"manuálny",32,200]
[null,"plne automatizovaný",0,130]
[null,"poloautomatický",27,150]
[null,"webový",0,200]

{"sheet":"Štandardné aktivity","index":19,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,3,7,3]]}
[]
[null,"Štandarné aktivity pri tvorbe integračných kosolidačných projektov a ich náročnosť"]
[]
[null,"#","Názov aktivity","Pomer prác"]
[null,1,"Analýza integračného business procesu",0.25]
[null,2,"Analýza interfejsových konektorov"]
[null,3,"Analýza a návrh dátového úložiska dát a metadát"]
[null,4,"Analýza prípadného webového rozhrania integrácie"]
[null,5,"Implementácia automatizovaných integračných šablón ",0.15]
[null,6,"Modelovanie/vývoj integračného projektu",0.17]
[null,7,"Modelovanie/vývoj validácie dát",0.06]
[null,8,"Modelovanie/vývoj unifikácie dát",0.06]
[null,9,"Modelovanie/vývoj monitoringu integrácie",0.04]
[null,10,"Unit testy",0.05]
[null,11,"Integračné testy",0.05]
[null,12,"A - Z testy",0.12]
[null,13,"Dokumentácia ",0.05]
[null,null,null,{"$f":"SUM(D5:D17)","v":1.0000000000000002}]
[]
[null,"Prácnosť riešenia podľa komponentov"]
[null,"#","Názov komponentu","Pomer prácnosti"]
[null,1,"MDM Rezortná zbernica",0.7]
[null,2,"MDM Portál",0.1]
[null,3,"MDM Dátový server",0.2]
[null,null,null,{"$f":"SUM(D22:D24)","v":1}]

{"sheet":"Prinosy","index":20,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Parametre prínosov"]
[]
[null,"Úspora nákladov vyplývajúca z cloudového riešenia"]
[]
[null,"Úspora prevádzkových nákladov oproti súčasným riešeniam",0.1]
[]
[null,"% nahrádzania súčasných systémov cloudom"]
[null,"t1",0]
[null,"t2",0]
[null,"t3",0]
[null,"t4",0.15]
[null,"t5",0.2]
[null,"t6",0.25]
[null,"t7",0.3]
[null,"t8",0.35]
[null,"t9",0.4]
[null,"t10",0.5]
[]
[]
[null,"Zníženie chybovosti údajov"]
[]
[null,"Počet chybových údajov vyžadujúcich manuálnu korekciu pred realizáciou za rok",300000]
[null,"Počet chybových údajov vyžadujúcich manuálnu korekciu po realizácii za rok",50000]
[null,"Priemerný čas na 1 korekciu pred realizáciou (hod)",1.5]
[null,"Priemerný čas na 1 korekciu po realizácii (hod)",0.5]
[null,"Čas strávený korekciou údajov za rok",{"$f":"C23*C25","v":450000}]
[null,"Čas strávený korekciou údajov za rok",{"$f":"C24*C26","v":25000}]
[null,"Časová úspora vyplývajúca z realizácie projektu (hod)",{"$f":"C27-C28","v":425000}]
[null,"Priemerný osobné náklady (EUR/hod)",{"$f":"Faktory!D7","v":9.42}]
[null,"Ekonomická úspora z realizácie projektu (EUR/rok)",{"$f":"C29*C30","v":4003500}]

{"sheet":"MD rates","index":21,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Priemerný náklad na vývoj v EUR/človekodeň"]
[]
[null,"Pozícia","EUR/ČD","Podiel"]
[null,"IT architekt",910,0.02,{"$f":"C5*D5","v":18.2}]
[null,"IT tester",570,0.12,{"$f":"C6*D6","v":68.399999999999991}]
[null,"IT programátor/vývojár",650,0.55000000000000004,357.50000000000006]
[null,"Projektový manažér IT projektu",890,0.02,17.8]
[null,"IT analytik",740,0.1,74]
[null,"IT dohľad/Quality Assurance",890,0.02,17.8]
[null,"Špecialista pre bezpečnosť IT",1200,0.02,24]
[null,"Špecialista pre databázy",600,0.15,90]
[null,"Vážený priemer EUR/ČD",null,{"$f":"SUM(D5:D12)","v":1},{"$f":"SUM(E5:E12)/SUM(D5:D12)","v":667.7}]
[]
[null,"Priemerná zľava",0.3]
[null,"Priemerný náklad na vývoj v EUR/ČD",{"$f":"E13*(1-C15)","v":467.39}]