{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Taul1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Taul1","index":0,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[[6,1,6,9],[7,1,7,9]]}
[]
[null,"Metsäteiden kunnossapito / Pisteytys"]
[]
[null,"Hinnan painoarvo",70,"% / pistettä"]
[null,"Laadun painoarvo",30,"% / pistettä"]
[]
[null,"Hintapisteiden laskenta: Tarjousten halvin hinta/tarjouksen hinta * hinnan painoarvo = tarjouksen hintapisteet. Halvin hintatarjous saa aina hinnan painoarvon verran (esimerkissä 70 pistettä) hintapistettä, muut vähemmän hintapisteitä."]
[null,"Laatupisteiden laskenta: Laatupisteet kertyvät annettujen laatulupausten mukaisesti. Laatulupausten summa kertoon laadun yhteispistemäärän (esimerkissä 30 pistettä)"]
[]
[null,"Syötetään tarjoajien nimet",null,"Tarjous A","Tarjous B","Tarjous C","Tarjous D","Tarjous E","Tarjous F","Tarjous G","Tarjous H","Tarjous I","Tarjous J"]
[null,"Syötetään tarjoushinnat / Eur",null,60000,50000,62000,63450,68000,69520,75000]
[]
[null,"Pisteiden laskenta"]
[]
[null,"Hintapisteet","Max.pist.",{"$f":"D10","v":"Tarjous A"},{"$f":"E10","v":"Tarjous B"},"Tarjous C","Tarjous D","Tarjous E","Tarjous F","Tarjous G","Tarjous H","Tarjous I","Tarjous J"]
[null,"Yhteensä",{"$f":"C4","v":70},{"$f":"IF(D11<>\"\",(MIN($D$11:$M$11)/D11)*$C$4,0)","v":58.333333333333336},{"$f":"IF(E11<>\"\",(MIN($D$11:$M$11)/E11)*$C$4,0)","v":70},56.451612903225801,55.161544523246654,51.470588235294123,50.345224395857301,46.666666666666664,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K11<>\"\",(MIN($D$11:$M$11)/K11)*$C$4,\"\")","v":""},{"$f":"IF(L11<>\"\",(MIN($D$11:$M$11)/L11)*$C$4,\"\")","v":""},{"$f":"IF(M11<>\"\",(MIN($D$11:$M$11)/M11)*$C$4,\"\")","v":""}]
[null,"Laatupisteet   ","Max.pist.",{"$f":"D10","v":"Tarjous A"},{"$f":"E10","v":"Tarjous B"},"Tarjous C","Tarjous D","Tarjous E","Tarjous F","Tarjous G","Tarjous H","Tarjous I","Tarjous J"]
[null,"1. Urakoitsijan aikaisempi kokemus ",{"$f":"$C$5/5","v":6},5,6,6,2,6,2,2,0,0,0]
[null,"2. Urakoitsijan vastuuhenkilön osaaminen ",{"$f":"$C$5/5","v":6},3,6,6,3,6,5,5,0,0,0]
[null,"3. Urakoitsijan kuljettajien osaaminen ",{"$f":"$C$5/5","v":6},6,6,6,6,6,6,6,0,0,0]
[null,"4. Urakoitsijan kalusto ",{"$f":"$C$5/5","v":6},2,6,6,6,6,3,3,0,0,0]
[null,"5. Työn seuranta ",6,3,3,1,6,3,0,0,null,0,0]
[null,"Yhteensä",{"$f":"SUM(C19:C23)","v":30},{"$f":"SUM(D19:D23)","v":19},{"$f":"SUM(E19:E23)","v":27},{"$f":"SUM(F19:F23)","v":25},{"$f":"SUM(G19:G23)","v":23},{"$f":"SUM(H19:H23)","v":27},{"$f":"SUM(I19:I23)","v":16},{"$f":"SUM(J19:J23)","v":16},{"$f":"SUM(K19:K23)","v":0},{"$f":"SUM(L19:L23)","v":0},{"$f":"SUM(M19:M23)","v":0}]
[]
[null,null,null,{"$f":"D10","v":"Tarjous A"},{"$f":"E10","v":"Tarjous B"},{"$f":"F10","v":"Tarjous C"},{"$f":"G10","v":"Tarjous D"},{"$f":"H10","v":"Tarjous E"},{"$f":"I10","v":"Tarjous F"},{"$f":"J10","v":"Tarjous G"},{"$f":"K10","v":"Tarjous H"},{"$f":"L10","v":"Tarjous I"},{"$f":"M10","v":"Tarjous J"}]
[null,"Yhteispisteet",null,{"$f":"IF(D16<>\"\",D16+D24)","v":77.333333333333343},{"$f":"IF(E16<>\"\",E16+E24)","v":97},{"$f":"IF(F16<>\"\",F16+F24)","v":81.451612903225794},{"$f":"IF(G16<>\"\",G16+G24)","v":78.161544523246647},{"$f":"IF(H16<>\"\",H16+H24)","v":78.470588235294116},{"$f":"IF(I16<>\"\",I16+I24)","v":66.345224395857301},{"$f":"IF(J16<>\"\",J16+J24)","v":62.666666666666664},{"$f":"IF(K16<>\"\",K16+K24)","v":0},{"$f":"IF(L16<>\"\",L16+L24)","v":0},{"$f":"IF(M16<>\"\",M16+M24)","v":0}]
[null,"Sijoitus",null,{"$f":"IF(D11>0,RANK(D27,$D$27:$M$27),0)","v":5},{"$f":"IF(E11>0,RANK(E27,$D$27:$M$27),0)","v":1},{"$f":"IF(F11>0,RANK(F27,$D$27:$M$27),0)","v":2},{"$f":"IF(G11>0,RANK(G27,$D$27:$M$27),0)","v":4},{"$f":"IF(H11>0,RANK(H27,$D$27:$M$27),0)","v":3},{"$f":"IF(I11>0,RANK(I27,$D$27:$M$27),0)","v":6},{"$f":"IF(J11>0,RANK(J27,$D$27:$M$27),0)","v":7},{"$f":"IF(K11>0,RANK(K27,$D$27:$M$27),0)","v":0},{"$f":"IF(L11>0,RANK(L27,$D$27:$M$27),0)","v":0},{"$f":"IF(M11>0,RANK(M27,$D$27:$M$27),0)","v":0}]