{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":71,"n_cols":19,"rows_kept":71,"merged":[[3,1,3,4],[3,8,3,10],[8,1,8,4],[8,8,8,10],[18,1,18,4]]}
[]
[]
[]
[null,"worker",{"$nulls":6},"work_place"]
[null,"id","int (10)","Unikālais numurs",{"$nulls":4},"id","int(10)","Unikāls numurs"]
[null,"worker_name","varchar(50)","Darbinieka vārds",{"$nulls":4},"work_name","varchar(20)","Darba vietas nosaukums"]
[]
[]
[null,"work",{"$nulls":6},"funds_info"]
[null,"id","int(10)","Unikāls numurs",{"$nulls":4},"id","int(10)","Unikāls numurs"]
[null,"work_type","varchar(20)","Darba nosaukums",{"$nulls":4},"price","decimal(20,0)","Cena par darbu"]
[null,"work_problem","varchar(150)","Darba kļūdas apraksts",{"$nulls":4},"amount","decimal(20,0)","Daudzums cik nepieciešams"]
[null,"work_nr","decimal(5,2)","Darba numurs",{"$nulls":4},"sum","decimal(20,0)","Kopējā summa"]
[null,"follow_nr","varchar(10)","Apsekojuma numurs"]
[null,"unit","int(50)","Mērvienības norādes skaitlis"]
[null,"measurement","varchar(10)","Mērvienības nosaukums"]
[]
[]
[null,"date"]
[null,"id","int(10)","Unikāls numurs"]
[null,"week_day","tinyint(7)","Nedēļas diena"]
[null,"date","DATE","Datums katrai dienai"]
[null,"time","TIME","Stundas laiki"]
[null,"start_time","DATETIME","Sākuma laiks"]
[null,"end_time","DATETIME","Beigu laiks"]
[]
[]
[null,null,"Datums","No","Darba tips","Vieta","Kļūdas apraksts","Apsekojuma NR/daudzums","Datums","Līdz","Darba veicējs","Km","stundas","Darba nr",null,"merv","cena","Daudzums","Kopā"]
[null,{"$f":"WEEKDAY(C29)","v":"1900-01-01"},"2012-01-01","06:00:00","Apgaita","Jelgava","Maršruta apsekošana","2012.01.01-01",{"$f":"C29","v":"2012-01-01"},"07:30:00","U. Grunde-Zeiferts",20,{"$f":"J29-D29","v":"01:30:00"},{"$f":"LOOKUP(G29,'[1]3'!$B$2:$B$143,'[1]3'!$A$2:$A$143)","v":5.2},{"$f":"LOOKUP(G29,'[1]3'!$B$2:$B$143,'[1]3'!$B$2:$B$143)","v":"Maršruta apsekošana"},{"$f":"LOOKUP(G29,'[1]3'!$B$2:$B$143,'[1]3'!$C$2:$C$143)","v":"km"},{"$f":"LOOKUP(G29,'[1]3'!$B$2:$B$143,'[1]3'!$D$2:$D$143)","v":{"v":1,"d":"1.00"}},{"v":20,"d":"20.0"},{"$f":"Q29*R29","v":{"v":20,"d":"20.00"}}]
[null,"1900-01-02","2012-01-02","06:00:00","Apgaita","Jelgava","Maršruta apsekošana","2012.01.02-01","2012-01-02","07:30:00","U. Grunde-Zeiferts",20,"01:30:00",{"$f":"LOOKUP(G30,'[1]3'!$B$2:$B$143,'[1]3'!$A$2:$A$143)","v":5.2},{"$f":"LOOKUP(G30,'[1]3'!$B$2:$B$143,'[1]3'!$B$2:$B$143)","v":"Maršruta apsekošana"},{"$f":"LOOKUP(G30,'[1]3'!$B$2:$B$143,'[1]3'!$C$2:$C$143)","v":"km"},{"$f":"LOOKUP(G30,'[1]3'!$B$2:$B$143,'[1]3'!$D$2:$D$143)","v":{"v":1,"d":"1.00"}},{"v":20,"d":"20.0"},{"$f":"Q30*R30","v":{"v":20,"d":"20.00"}}]
[null,"1900-01-02","2012-01-02","07:45:00","Sapulce","ME","Ražošanas sapulce",null,"2012-01-02","08:30:00","U. Grunde-Zeiferts",null,"00:45:00"]
[null,"1900-01-02","2012-01-02","09:00:00","Būvniecība","Raiņa-Pasta","Signālgalvu uzstādīšana",null,"2012-01-02","13:00:00","Ē. Aukmanis",null,"04:00:00"]
[null,"1900-01-02","2012-01-02","09:00:00","Būvniecība","Raiņa-Pasta","Signālgalvu uzstādīšana",null,"2012-01-02","13:00:00","U. Grunde-Zeiferts",5,"04:00:00"]
[null,"1900-01-02","2012-01-02","13:30:00","Būvniecība","Raiņa-Pasta","Signālgalvu pievienošana",null,"2012-01-02","15:00:00","Ē. Aukmanis",5,"01:30:00"]
[null,"1900-01-02","2012-01-02","13:30:00","Būvniecība","Raiņa-Pasta","Signālgalvu pievienošana",null,"2012-01-02","16:00:00","U. Grunde-Zeiferts",5,"02:30:00"]
[null,"1900-01-02","2012-01-02","16:00:00","Info","ME","Nenodoto signālgalvu sanešana Mazā noliktavā",null,"2012-01-02","17:00:00","U. Grunde-Zeiferts",null,"01:00:00"]
[null,"1900-01-03","2012-01-03","06:00:00","Apgaita","Jelgava","Maršruta apsekošana","2012.01.03-01","2012-01-03","07:30:00","U.Grunde-Zeiferts",20,"01:30:00",{"$f":"LOOKUP(G37,'[1]3'!$B$2:$B$143,'[1]3'!$A$2:$A$143)","v":5.2},{"$f":"LOOKUP(G37,'[1]3'!$B$2:$B$143,'[1]3'!$B$2:$B$143)","v":"Maršruta apsekošana"},{"$f":"LOOKUP(G37,'[1]3'!$B$2:$B$143,'[1]3'!$C$2:$C$143)","v":"km"},{"$f":"LOOKUP(G37,'[1]3'!$B$2:$B$143,'[1]3'!$D$2:$D$143)","v":{"v":1,"d":"1.00"}},{"v":20,"d":"20.0"},{"$f":"Q37*R37","v":{"v":20,"d":"20.00"}}]
[null,"1900-01-03","2012-01-03","07:45:00","Sapulce","ME","Ražošanas sapulce",null,"2012-01-03","08:30:00","U. Grunde-Zeiferts",null,"00:45:00"]
[null,"1900-01-03","2012-01-03","08:40:00","Info","ME","Donatas interesējas par Stacijas MINI luksoforu",null,"2012-01-03","08:50:00","U. Grunde-Zeiferts",null,"00:10:00"]
[null,"1900-01-03","2012-01-03","09:00:00","Dokmentacija","ME","Skaitītāju rādījumi, P/S žurnāls",null,"2012-01-03","10:30:00","U. Grunde-Zeiferts",null,"01:30:00"]
[null,"1900-01-03","2012-01-03","09:00:00","Dokmentacija","ME","Skaitītāju rādījumi, P/S žurnāls",null,"2012-01-03","10:30:00","U. Grunde-Zeiferts",null,"01:30:00"]
[null,"1900-01-03","2012-01-03","10:30:00","Dokmentacija","P/S","Rēķinu ievešana P/S",null,"2012-01-03","10:45:00","U. Grunde-Zeiferts",5,"00:15:00"]
[null,"1900-01-03","2012-01-03","11:50:00","Izsaukums","Rīgas-Izstādes","Kļūda GEP","2012.01.03-02","2012-01-03","12:50:00","U.Grunde-Zeiferts",10,"01:00:00",5.1,"Izsaukums luksofora objektā","gab.",{"v":10,"d":"10.00"},{"v":1,"d":"1.0"},{"$f":"Q43*R43","v":{"v":10,"d":"10.00"}}]
[null,"1900-01-03","2012-01-03","13:00:00","Info","P/S","Māris Mielavs par meteostaciju uzturēšanu",null,"2012-01-03","13:45:00","U. Grunde-Zeiferts",5,"00:45:00"]
[null,"1900-01-03","2012-01-03","14:00:00","Izsaukums","Dobeles-Brieža","Andrejs Bobikins liek pārbaudīt skaitītāja rādījumus","2012.01.03-03","2012-01-03","14:15:00","U.Grunde-Zeiferts",5,"00:15:00",5.1,"Izsaukums luksofora objektā","gab.",{"v":10,"d":"10.00"},{"v":1,"d":"1.0"},{"$f":"Q45*R45","v":{"v":10,"d":"10.00"}}]
[null,"1900-01-03","2012-01-03","14:15:00","Izsaukums","Raiņa-Sarmas","Andrejs Bobikins liek pārbaudīt skaitītāja rādījumus","2012.01.03-04","2012-01-03","14:30:00","U.Grunde-Zeiferts",5,"00:15:00",5.1,"Izsaukums luksofora objektā","gab.",{"v":10,"d":"10.00"},{"v":1,"d":"1.0"},{"v":10,"d":"10.00"}]
[null,"1900-01-03","2012-01-03","14:50:00","Izsaukums","Raiņa-Mātera","GP1G1","2012.01.03-05","2012-01-03","15:30:00","U.Grunde-Zeiferts",5,"00:40:00",5.1,"Izsaukums luksofora objektā","gab.",{"v":10,"d":"10.00"},{"v":1,"d":"1.0"},{"v":10,"d":"10.00"}]
[null,"1900-01-03","2012-01-03","14:50:00","Apkope","Raiņa-Mātera","Vadības plates ZKS tipa drošinātāja nomaiņa",null,"2012-01-03","15:30:00","U. Grunde-Zeiferts",null,{"$f":"J48-D48","v":"00:40:00"},{"$f":"LOOKUP(G48,'[1]3'!$B$2:$B$143,'[1]3'!$A$2:$A$143)","v":3.17},{"$f":"LOOKUP(G48,'[1]3'!$B$2:$B$143,'[1]3'!$B$2:$B$143)","v":"Vadības plates ZKS tipa drošinātāja nomaiņa"},{"$f":"LOOKUP(G48,'[1]3'!$B$2:$B$143,'[1]3'!$C$2:$C$143)","v":"gab."},{"$f":"LOOKUP(G48,'[1]3'!$B$2:$B$143,'[1]3'!$D$2:$D$143)","v":{"v":10,"d":"10.00"}},{"v":1,"d":"1.0"},{"v":10,"d":"10.00"}]
[null,"1900-01-03","2012-01-03","14:50:00","Apkope","Raiņa-Mātera","Bojājuma noteikšana",null,"2012-01-03","15:30:00","U. Grunde-Zeiferts",null,{"$f":"J49-D49","v":"00:40:00"},{"$f":"LOOKUP(G49,'[1]3'!$B$2:$B$143,'[1]3'!$A$2:$A$143)","v":2.4},{"$f":"LOOKUP(G49,'[1]3'!$B$2:$B$143,'[1]3'!$B$2:$B$143)","v":"Balsta vāka maiņa"},{"$f":"LOOKUP(G49,'[1]3'!$B$2:$B$143,'[1]3'!$C$2:$C$143)","v":"gab."},{"$f":"LOOKUP(G49,'[1]3'!$B$2:$B$143,'[1]3'!$D$2:$D$143)","v":{"v":5,"d":"5.00"}},{"v":1,"d":"1.0"},{"v":5,"d":"5.00"}]
[null,"1900-01-03","2012-01-03","15:45:00","Izsaukums","Raiņa-Pasta","Trūkst balsta vāks","2012.01.03-06","2012-01-03","16:00:00","U.Grunde-Zeiferts",5,{"$f":"J50-D50","v":"00:15:00"},5.1,"Izsaukums luksofora objektā","gab.",{"v":10,"d":"10.00"},{"v":1,"d":"1.0"},{"v":10,"d":"10.00"}]
[null,"1900-01-03","2012-01-03","15:45:00","Apkope","Raiņa-Pasta","Balsta vāks",null,"2012-01-03","16:00:00","U. Grunde-Zeiferts",null,"00:15:00",{"$f":"LOOKUP(G51,'[1]3'!$B$2:$B$143,'[1]3'!$A$2:$A$143)","v":2.4},{"$f":"LOOKUP(G51,'[1]3'!$B$2:$B$143,'[1]3'!$B$2:$B$143)","v":"Balsta vāka maiņa"},{"$f":"LOOKUP(G51,'[1]3'!$B$2:$B$143,'[1]3'!$C$2:$C$143)","v":"gab."},{"$f":"LOOKUP(G51,'[1]3'!$B$2:$B$143,'[1]3'!$D$2:$D$143)","v":{"v":5,"d":"5.00"}},{"v":1,"d":"1.0"},{"v":5,"d":"5.00"}]
[null,"1900-01-03","2012-01-03","16:00:00","Datortehnikas apkope","ME","Kopētāja sagatavošana darbam, Veikala printera neveiksmīga instalēšana, Anrda datora papildus konfigurēšana",null,"2012-01-03","17:30:00","U. Grunde-Zeiferts",null,"01:30:00"]
[null,"1900-01-04","2012-01-04","06:00:00","Apgaita","Jelgava","Maršruta apsekošana","2012.01.04-01","2012-01-04","07:30:00","U.Grunde-Zeiferts",20,"01:30:00",{"$f":"LOOKUP(G53,'[1]3'!$B$2:$B$143,'[1]3'!$A$2:$A$143)","v":5.2},{"$f":"LOOKUP(G53,'[1]3'!$B$2:$B$143,'[1]3'!$B$2:$B$143)","v":"Maršruta apsekošana"},{"$f":"LOOKUP(G53,'[1]3'!$B$2:$B$143,'[1]3'!$C$2:$C$143)","v":"km"},{"$f":"LOOKUP(G53,'[1]3'!$B$2:$B$143,'[1]3'!$D$2:$D$143)","v":{"v":1,"d":"1.00"}},{"v":20,"d":"20.0"},{"$f":"Q53*R53","v":{"v":20,"d":"20.00"}}]
[null,"1900-01-04","2012-01-04","07:45:00","Sapulce","ME","Ražošanas sapulce",null,"2012-01-04","08:30:00","U. Grunde-Zeiferts",null,"00:45:00"]
[null,"1900-01-04","2012-01-04","08:30:00","Dokmentacija","ME","Meteostacijas uzturēšanas līguma izmaksas",null,"2012-01-04","09:00:00","U. Grunde-Zeiferts",null,"00:30:00"]
[null,"1900-01-04","2012-01-04","09:00:00","Izsaukums","Raiņa-Mātera","Trūkst balsta vāks","2012.01.04-02","2012-01-04","16:00:00","U.Grunde-Zeiferts",5,"07:00:00",5.1,"Izsaukums luksofora objektā","gab.",{"v":10,"d":"10.00"},{"v":1,"d":"1.0"},{"$f":"Q56*R56","v":{"v":10,"d":"10.00"}}]
[null,"1900-01-04","2012-01-04","09:00:00","Apkope","Raiņa-Mātera","Spuldzes maiņa balstā",null,"2012-01-04","09:30:00","U. Grunde-Zeiferts",null,"00:30:00",{"$f":"LOOKUP(G57,'[1]3'!$B$2:$B$143,'[1]3'!$A$2:$A$143)","v":1.28},{"$f":"LOOKUP(G57,'[1]3'!$B$2:$B$143,'[1]3'!$B$2:$B$143)","v":"SP-7 tipa sadalnes montāža"},{"$f":"LOOKUP(G57,'[1]3'!$B$2:$B$143,'[1]3'!$C$2:$C$143)","v":"gab."},{"$f":"LOOKUP(G57,'[1]3'!$B$2:$B$143,'[1]3'!$D$2:$D$143)","v":{"v":20,"d":"20.00"}},{"v":1,"d":"1.0"},{"$f":"Q57*R57","v":{"v":20,"d":"20.00"}}]
[null,"1900-01-04","2012-01-04","09:30:00","Dokmentacija","ME","Skaitītāju rādījumi LVC",null,"2012-01-04","10:00:00","U. Grunde-Zeiferts",null,"00:30:00"]
[null,"1900-01-04","2012-01-04","10:00:00","Datortehnikas apkope","ME","Kopētāja pieinstalēšana serverim, printera resursu izdalīšana, Kopētaja piesaiste Aināra, Andra,Veikala datoram",null,"2012-01-04","11:30:00","U. Grunde-Zeiferts",null,"01:30:00"]
[null,"1900-01-04","2012-01-04","11:30:00","Datortehnikas apkope","ME","Datortīkla vada ievilšana virs veikala griestiem",null,"2012-01-04","13:00:00","U. Grunde-Zeiferts",null,"01:30:00"]
[null,"1900-01-04","2012-01-04","13:00:00","Dokmentacija","P/S","Māris Mielavs par meteostaciju uzturēšanu",null,"2012-01-04","13:30:00","U. Grunde-Zeiferts",5,"00:30:00"]
[null,"1900-01-04","2012-01-04","13:30:00","Projektēšana","P/S","Dzidra Staša par Lietuvas ielas signālplāniem",null,"2012-01-04","14:30:00","U. Grunde-Zeiferts",null,"01:00:00"]
[null,"1900-01-04","2012-01-04","14:45:00","Datortehnikas apkope","ME","Pie Brigitas. Meteostacijas uzturēšanas līguma izmaksas",null,"2012-01-04","15:00:00","U. Grunde-Zeiferts",null,"00:15:00"]
[null,"1900-01-04","2012-01-04","14:22:00","Izsaukums","Raiņa-Akadēmijas","Nolauzti stiprinājuma kronšteini atkārtotāja transporta signālgalvai V3","2012.01.04-03","2012-01-04","17:00:00","U.Grunde-Zeiferts",5,"02:38:00",5.1,"Izsaukums luksofora objektā","gab.",{"v":10,"d":"10.00"},{"v":1,"d":"1.0"},{"$f":"Q64*R64","v":{"v":10,"d":"10.00"}}]
[null,"1900-01-04","2012-01-04","15:00:00","Apkope","Raiņa-Akadēmijas","Signālgalvas demontāža uz balsta",null,"2012-01-04","16:00:00","U. Grunde-Zeiferts",null,"01:00:00",{"$f":"LOOKUP(G65,'[1]3'!$B$2:$B$143,'[1]3'!$A$2:$A$143)","v":4.4},{"$f":"LOOKUP(G65,'[1]3'!$B$2:$B$143,'[1]3'!$B$2:$B$143)","v":"Signālgalvas demontāža uz balsta"},{"$f":"LOOKUP(G65,'[1]3'!$B$2:$B$143,'[1]3'!$C$2:$C$143)","v":"gab."},{"$f":"LOOKUP(G65,'[1]3'!$B$2:$B$143,'[1]3'!$D$2:$D$143)","v":{"v":10,"d":"10.00"}},{"v":1,"d":"1.0"},{"$f":"Q65*R65","v":{"v":10,"d":"10.00"}}]
[null,"1900-01-04","2012-01-04","16:00:00","Apkope","Raiņa-Akadēmijas","Pasūtītāja transporta signālgalvas montāža uz balsta",null,"2012-01-04","17:30:00","U. Grunde-Zeiferts",null,"01:30:00",{"$f":"LOOKUP(G66,'[1]3'!$B$2:$B$143,'[1]3'!$A$2:$A$143)","v":2.43},{"$f":"LOOKUP(G66,'[1]3'!$B$2:$B$143,'[1]3'!$B$2:$B$143)","v":"Pasūtītāja transporta signālgalvas montāža uz balsta"},{"$f":"LOOKUP(G66,'[1]3'!$B$2:$B$143,'[1]3'!$C$2:$C$143)","v":"gab."},{"$f":"LOOKUP(G66,'[1]3'!$B$2:$B$143,'[1]3'!$D$2:$D$143)","v":{"v":20,"d":"20.00"}},{"v":1,"d":"1.0"},{"$f":"Q66*R66","v":{"v":20,"d":"20.00"}}]
[null,"1900-01-04","2012-01-04","16:00:00","Apkope","Raiņa-Akadēmijas","Signālkabeļa Cu 7x1,5 montāža stabā, konsolē",null,"2012-01-04","17:30:00","U. Grunde-Zeiferts",null,"01:30:00",{"$f":"LOOKUP(G67,'[1]3'!$B$2:$B$143,'[1]3'!$A$2:$A$143)","v":1.11},{"$f":"LOOKUP(G67,'[1]3'!$B$2:$B$143,'[1]3'!$B$2:$B$143)","v":"Signālkabeļa Cu 7x1,5 montāža stabā, konsolē"},{"$f":"LOOKUP(G67,'[1]3'!$B$2:$B$143,'[1]3'!$C$2:$C$143)","v":"m."},{"$f":"LOOKUP(G67,'[1]3'!$B$2:$B$143,'[1]3'!$D$2:$D$143)","v":{"v":1.5,"d":"1.50"}},{"v":3,"d":"3.0"},{"$f":"Q67*R67","v":{"v":4.5,"d":"4.50"}}]
[null,"1900-01-04","2012-01-04","16:00:00","Apkope","Raiņa-Akadēmijas","Signālkabeļa spaiļu komplekta nomaiņa balstā, konsolē",null,"2012-01-04","17:30:00","U. Grunde-Zeiferts",null,"01:30:00",{"$f":"LOOKUP(G68,'[1]3'!$B$2:$B$143,'[1]3'!$A$2:$A$143)","v":1.25},{"$f":"LOOKUP(G68,'[1]3'!$B$2:$B$143,'[1]3'!$B$2:$B$143)","v":"Signālkabeļa spaiļu komplekta nomaiņa balstā, konsolē"},{"$f":"LOOKUP(G68,'[1]3'!$B$2:$B$143,'[1]3'!$C$2:$C$143)","v":"kompl."},{"$f":"LOOKUP(G68,'[1]3'!$B$2:$B$143,'[1]3'!$D$2:$D$143)","v":{"v":5,"d":"5.00"}},{"v":1,"d":"1.0"},{"$f":"Q68*R68","v":{"v":5,"d":"5.00"}}]
[null,"1900-01-04","2012-01-04","21:00:00","Dokmentacija","mājās","Slodzes savākšana par decembri",null,"2012-01-04","21:30:00","U. Grunde-Zeiferts",5,"00:30:00"]
[null,"1900-01-04","2012-01-04","20:00:00","Maiņa","Jelgava","Maiņas nodošana",null,{"$f":"C70","v":"2012-01-04"},"21:00:00","U. Grunde-Zeiferts, E.Aukmanis",50,{"$f":"J70-D70","v":"01:00:00"}]
[null,"1900-01-05","2012-01-05","06:00:00","Apgaita","Jelgava","Maršruta apsekošana","2012.01.05-01","2012-01-05","07:30:00","Ē.Aukmanis",25,"01:30:00",{"$f":"LOOKUP(G71,'[1]3'!$B$2:$B$143,'[1]3'!$A$2:$A$143)","v":5.2},{"$f":"LOOKUP(G71,'[1]3'!$B$2:$B$143,'[1]3'!$B$2:$B$143)","v":"Maršruta apsekošana"},{"$f":"LOOKUP(G71,'[1]3'!$B$2:$B$143,'[1]3'!$C$2:$C$143)","v":"km"},{"$f":"LOOKUP(G71,'[1]3'!$B$2:$B$143,'[1]3'!$D$2:$D$143)","v":{"v":1,"d":"1.00"}},{"v":20,"d":"20.0"},{"$f":"Q71*R71","v":{"v":20,"d":"20.00"}}]