{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Ceturkšņa pārdoš. datu atskaite","aprēķini"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Ceturkšņa pārdoš. datu atskaite","index":0,"n_rows":63,"n_cols":12,"rows_kept":63,"cut":false,"hidden":false,"merged":[[1,0,3,5]]}
[]
["CETURKŠŅA PĀRDOŠANAS DATU ATSKAITE",null,null,null,null,null,null,null,null,"RĀDĪT POPULĀRĀKOS",5,"PRODUKTI"]
[]
[null,null,null,null,null,null,null,null,null,"RĀDĪT VISUS PĀRĒJOS","NĒ","PRODUKTI"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PRODUKTS","1. CETURKSNIS","2. CETURKSNIS","3. CETURKSNIS","4. CETURKSNIS","KOPSUMMA"]
[null,"Rāmji",4000,4500,5000,5000,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":18500}]
[null,"Disku bremzes, priekšējās",294,249.9,323.39999999999998,367.5,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":1234.8}]
[null,"Kalipera bremzes, priekšējās",200,170,220,250,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":840}]
[null,"Disku bremzes, aizmugurējās",400,340,440,500,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":1680}]
[null,"Kalipera bremzes, aizmugurējās",294,249.9,323.39999999999998,367.5,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":1234.8}]
[null,"Sēdekļi",235,199.75,32,293.75,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":760.5}]
[null,"Dakšas",100,85,110,125,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":420}]
[null,"Bremžu troses",300,255,330,375,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":1260}]
[null,"Ātruma pārslēga troses",250,212.5,275,312.5,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":1050}]
[null,"Aizmugurējie zobrati",400,340,440,500,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":1680}]
[null,"Priekšējie zobrati",200,170,220,250,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":840}]
[null,"Stūres",1895,1610.75,3445,3333,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":10283.75}]
[null,"Bremžu sviras",544,462.4,598.4,680,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":2284.8000000000002}]
[null,"Sēdekļu balsti",200,170,220,250,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":840}]
[null,"Stūres skavas",60,51,66,75,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":252}]
[null,"Sēdekļa somiņas",2413,2051.0500000000002,4000,3016.25,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":11480.3}]
[null,"Spieķi",233,198.05,256.3,291.25,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":978.6}]
[null,"Stīpas",354,300.89999999999998,389.4,442.5,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":1486.8}]
[null,"Riepas",423,359.55,465.3,528.75,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":1776.6}]
[null,"Rokturi",2222,1888.7,2444.1999999999998,2777.5,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":9332.4}]
[null,"Rokturu lenta",1550.4,1317.8400000000001,1705.44,1938,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":6511.68}]
[null,"Polsteri",30,25.5,33,37.5,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":126}]
[null,"Ķēdes",208,176.8,228.8,260,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":873.6}]
[null,"Ātrumu pārslēdzēji",356,302.60000000000002,391.6,445,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":1495.2}]
[null,"Ātri atbrīvojamas rumbas",258,219.3,283.8,322.5,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":1083.5999999999999}]
[null,"Standarta rumbas",414,351.9,455.4,517.5,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":1738.8}]
[null,"Pedāļi",369,313.64999999999998,405.9,461.25,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":1549.8}]
[null,"Ķēdes aizsargi",324,275.39999999999998,356.4,405,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":1360.8}]
[null,"Spoguļi",87,73.95,95.7,108.75,{"$f":"SUM(Pārdošana[[#This Row],[1. CETURKSNIS]:[4. CETURKSNIS]])","v":365.4}]

{"sheet":"aprēķini","index":1,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["*** Šai lapai jāpaliek slēptai***"]
[]
[]
[null,null,null,null,"Produkts","1. CETURKSNIS","2. CETURKSNIS","3. CETURKSNIS","4. CETURKSNIS","Kopā"]
[null,1,{"$f":"IF($B5>n,\"\",LARGE(Pārdošana[KOPSUMMA],1))","v":18500},{"$f":"IF($B5>n,\"\",IF(C4=C5,MATCH(C5,OFFSET(Pārdošana[KOPSUMMA],D4,),0)+D4,MATCH(C5,Pārdošana[KOPSUMMA],0)))","v":1},{"$f":"IF($B5>n,\"\",INDEX(Pārdošana[PRODUKTS],D5))","v":"Rāmji"},{"$f":"IF($B5>n,\"\",INDEX(Pārdošana[1. CETURKSNIS],$D5))","v":4000},{"$f":"IF($B5>n,\"\",INDEX(Pārdošana[2. CETURKSNIS],$D5))","v":4500},{"$f":"IF($B5>n,\"\",INDEX(Pārdošana[3. CETURKSNIS],$D5))","v":5000},{"$f":"IF($B5>n,\"\",INDEX(Pārdošana[4. CETURKSNIS],$D5))","v":5000},{"$f":"IF($B5>n,\"\",INDEX(Pārdošana[KOPSUMMA],$D5))","v":18500}]
[null,2,{"$f":"IF($B6>n,\"\",LARGE(Pārdošana[KOPSUMMA],2))","v":11480.3},{"$f":"IF($B6>n,\"\",IF(C5=C6,MATCH(C6,OFFSET(Pārdošana[KOPSUMMA],D5,),0)+D5,MATCH(C6,Pārdošana[KOPSUMMA],0)))","v":16},{"$f":"IF($B6>n,\"\",INDEX(Pārdošana[PRODUKTS],D6))","v":"Sēdekļa somiņas"},{"$f":"IF($B6>n,\"\",INDEX(Pārdošana[1. CETURKSNIS],$D6))","v":2413},{"$f":"IF($B6>n,\"\",INDEX(Pārdošana[2. CETURKSNIS],$D6))","v":2051.0500000000002},{"$f":"IF($B6>n,\"\",INDEX(Pārdošana[3. CETURKSNIS],$D6))","v":4000},{"$f":"IF($B6>n,\"\",INDEX(Pārdošana[4. CETURKSNIS],$D6))","v":3016.25},{"$f":"IF($B6>n,\"\",INDEX(Pārdošana[KOPSUMMA],$D6))","v":11480.3}]
[null,3,{"$f":"IF($B7>n,\"\",LARGE(Pārdošana[KOPSUMMA],3))","v":10283.75},{"$f":"IF($B7>n,\"\",IF(C6=C7,MATCH(C7,OFFSET(Pārdošana[KOPSUMMA],D6,),0)+D6,MATCH(C7,Pārdošana[KOPSUMMA],0)))","v":12},{"$f":"IF($B7>n,\"\",INDEX(Pārdošana[PRODUKTS],D7))","v":"Stūres"},{"$f":"IF($B7>n,\"\",INDEX(Pārdošana[1. CETURKSNIS],$D7))","v":1895},{"$f":"IF($B7>n,\"\",INDEX(Pārdošana[2. CETURKSNIS],$D7))","v":1610.75},{"$f":"IF($B7>n,\"\",INDEX(Pārdošana[3. CETURKSNIS],$D7))","v":3445},{"$f":"IF($B7>n,\"\",INDEX(Pārdošana[4. CETURKSNIS],$D7))","v":3333},{"$f":"IF($B7>n,\"\",INDEX(Pārdošana[KOPSUMMA],$D7))","v":10283.75}]
[null,4,{"$f":"IF($B8>n,\"\",LARGE(Pārdošana[KOPSUMMA],4))","v":9332.4},{"$f":"IF($B8>n,\"\",IF(C7=C8,MATCH(C8,OFFSET(Pārdošana[KOPSUMMA],D7,),0)+D7,MATCH(C8,Pārdošana[KOPSUMMA],0)))","v":20},{"$f":"IF($B8>n,\"\",INDEX(Pārdošana[PRODUKTS],D8))","v":"Rokturi"},{"$f":"IF($B8>n,\"\",INDEX(Pārdošana[1. CETURKSNIS],$D8))","v":2222},{"$f":"IF($B8>n,\"\",INDEX(Pārdošana[2. CETURKSNIS],$D8))","v":1888.7},{"$f":"IF($B8>n,\"\",INDEX(Pārdošana[3. CETURKSNIS],$D8))","v":2444.1999999999998},{"$f":"IF($B8>n,\"\",INDEX(Pārdošana[4. CETURKSNIS],$D8))","v":2777.5},{"$f":"IF($B8>n,\"\",INDEX(Pārdošana[KOPSUMMA],$D8))","v":9332.4}]
[null,5,{"$f":"IF($B9>n,\"\",LARGE(Pārdošana[KOPSUMMA],5))","v":6511.68},{"$f":"IF($B9>n,\"\",IF(C8=C9,MATCH(C9,OFFSET(Pārdošana[KOPSUMMA],D8,),0)+D8,MATCH(C9,Pārdošana[KOPSUMMA],0)))","v":21},{"$f":"IF($B9>n,\"\",INDEX(Pārdošana[PRODUKTS],D9))","v":"Rokturu lenta"},{"$f":"IF($B9>n,\"\",INDEX(Pārdošana[1. CETURKSNIS],$D9))","v":1550.4},{"$f":"IF($B9>n,\"\",INDEX(Pārdošana[2. CETURKSNIS],$D9))","v":1317.8400000000001},{"$f":"IF($B9>n,\"\",INDEX(Pārdošana[3. CETURKSNIS],$D9))","v":1705.44},{"$f":"IF($B9>n,\"\",INDEX(Pārdošana[4. CETURKSNIS],$D9))","v":1938},{"$f":"IF($B9>n,\"\",INDEX(Pārdošana[KOPSUMMA],$D9))","v":6511.68}]
[null,6,{"$f":"IF($B10>n,\"\",LARGE(Pārdošana[KOPSUMMA],6))","v":""},{"$f":"IF($B10>n,\"\",IF(C9=C10,MATCH(C10,OFFSET(Pārdošana[KOPSUMMA],D9,),0)+D9,MATCH(C10,Pārdošana[KOPSUMMA],0)))","v":""},{"$f":"IF($B10>n,\"\",INDEX(Pārdošana[PRODUKTS],D10))","v":""},{"$f":"IF($B10>n,\"\",INDEX(Pārdošana[1. CETURKSNIS],$D10))","v":""},{"$f":"IF($B10>n,\"\",INDEX(Pārdošana[2. CETURKSNIS],$D10))","v":""},{"$f":"IF($B10>n,\"\",INDEX(Pārdošana[3. CETURKSNIS],$D10))","v":""},{"$f":"IF($B10>n,\"\",INDEX(Pārdošana[4. CETURKSNIS],$D10))","v":""},{"$f":"IF($B10>n,\"\",INDEX(Pārdošana[KOPSUMMA],$D10))","v":""}]
[null,7,{"$f":"IF($B11>n,\"\",LARGE(Pārdošana[KOPSUMMA],7))","v":""},{"$f":"IF($B11>n,\"\",IF(C10=C11,MATCH(C11,OFFSET(Pārdošana[KOPSUMMA],D10,),0)+D10,MATCH(C11,Pārdošana[KOPSUMMA],0)))","v":""},{"$f":"IF($B11>n,\"\",INDEX(Pārdošana[PRODUKTS],D11))","v":""},{"$f":"IF($B11>n,\"\",INDEX(Pārdošana[1. CETURKSNIS],$D11))","v":""},{"$f":"IF($B11>n,\"\",INDEX(Pārdošana[2. CETURKSNIS],$D11))","v":""},{"$f":"IF($B11>n,\"\",INDEX(Pārdošana[3. CETURKSNIS],$D11))","v":""},{"$f":"IF($B11>n,\"\",INDEX(Pārdošana[4. CETURKSNIS],$D11))","v":""},{"$f":"IF($B11>n,\"\",INDEX(Pārdošana[KOPSUMMA],$D11))","v":""}]
[null,8,{"$f":"IF($B12>n,\"\",LARGE(Pārdošana[KOPSUMMA],8))","v":""},{"$f":"IF($B12>n,\"\",IF(C11=C12,MATCH(C12,OFFSET(Pārdošana[KOPSUMMA],D11,),0)+D11,MATCH(C12,Pārdošana[KOPSUMMA],0)))","v":""},{"$f":"IF($B12>n,\"\",INDEX(Pārdošana[PRODUKTS],D12))","v":""},{"$f":"IF($B12>n,\"\",INDEX(Pārdošana[1. CETURKSNIS],$D12))","v":""},{"$f":"IF($B12>n,\"\",INDEX(Pārdošana[2. CETURKSNIS],$D12))","v":""},{"$f":"IF($B12>n,\"\",INDEX(Pārdošana[3. CETURKSNIS],$D12))","v":""},{"$f":"IF($B12>n,\"\",INDEX(Pārdošana[4. CETURKSNIS],$D12))","v":""},{"$f":"IF($B12>n,\"\",INDEX(Pārdošana[KOPSUMMA],$D12))","v":""}]
[null,9,{"$f":"IF($B13>n,\"\",LARGE(Pārdošana[KOPSUMMA],9))","v":""},{"$f":"IF($B13>n,\"\",IF(C12=C13,MATCH(C13,OFFSET(Pārdošana[KOPSUMMA],D12,),0)+D12,MATCH(C13,Pārdošana[KOPSUMMA],0)))","v":""},{"$f":"IF($B13>n,\"\",INDEX(Pārdošana[PRODUKTS],D13))","v":""},{"$f":"IF($B13>n,\"\",INDEX(Pārdošana[1. CETURKSNIS],$D13))","v":""},{"$f":"IF($B13>n,\"\",INDEX(Pārdošana[2. CETURKSNIS],$D13))","v":""},{"$f":"IF($B13>n,\"\",INDEX(Pārdošana[3. CETURKSNIS],$D13))","v":""},{"$f":"IF($B13>n,\"\",INDEX(Pārdošana[4. CETURKSNIS],$D13))","v":""},{"$f":"IF($B13>n,\"\",INDEX(Pārdošana[KOPSUMMA],$D13))","v":""}]
[null,10,{"$f":"IF($B14>n,\"\",LARGE(Pārdošana[KOPSUMMA],10))","v":""},{"$f":"IF($B14>n,\"\",IF(C13=C14,MATCH(C14,OFFSET(Pārdošana[KOPSUMMA],D13,),0)+D13,MATCH(C14,Pārdošana[KOPSUMMA],0)))","v":""},{"$f":"IF($B14>n,\"\",INDEX(Pārdošana[PRODUKTS],D14))","v":""},{"$f":"IF($B14>n,\"\",INDEX(#REF!,$D14))","v":""},{"$f":"IF($B14>n,\"\",INDEX(Pārdošana[2. CETURKSNIS],$D14))","v":""},{"$f":"IF($B14>n,\"\",INDEX(Pārdošana[3. CETURKSNIS],$D14))","v":""},{"$f":"IF($B14>n,\"\",INDEX(Pārdošana[4. CETURKSNIS],$D14))","v":""},{"$f":"IF($B14>n,\"\",INDEX(Pārdošana[KOPSUMMA],$D14))","v":""}]
[null,null,null,null,{"$f":"\"\"","v":""}]
[null,{"$f":"IekļautCitu=\"JĀ\"","v":false},null,null,"Cits",{"$f":"SUM(Pārdošana[1. CETURKSNIS]) - SUM(F5:F14)","v":6533.0000000000018},{"$f":"SUM(Pārdošana[2. CETURKSNIS]) - SUM(G5:G14)","v":5553.0499999999993},{"$f":"SUM(Pārdošana[3. CETURKSNIS]) - SUM(H5:H14)","v":6959.7999999999993},{"$f":"SUM(Pārdošana[4. CETURKSNIS]) - SUM(I5:I14)","v":8166.25},{"$f":"SUM(Pārdošana[KOPSUMMA]) - SUM(J5:J14)","v":27212.100000000006}]
[]
[null,null,null,null,"KOPSUMMA",{"$f":"SUM(Pārdošana[1. CETURKSNIS])","v":18613.400000000001},{"$f":"SUM(Pārdošana[2. CETURKSNIS])","v":16921.39},{"$f":"SUM(Pārdošana[3. CETURKSNIS])","v":23554.44},{"$f":"SUM(Pārdošana[4. CETURKSNIS])","v":24231},{"$f":"SUM(Pārdošana[KOPSUMMA])","v":83320.23000000001}]
[]
[]
[]
[null,{"$f":"\"KOPĀ UN \"&n&\" POPULĀRĀKIE PRODUKTI\"","v":"KOPĀ UN 5 POPULĀRĀKIE PRODUKTI"}]