{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Raport de cheltuieli"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Raport de cheltuieli","index":0,"n_rows":14,"n_cols":14,"rows_kept":14,"merged":[[0,1,0,6],[2,3,2,5],[2,6,2,7],[2,8,2,10],[4,3,4,5],[4,6,4,7],[4,8,4,10]]}
[null,"Raport de cheltuieli de deplasare"]
[]
[null,"Nume","Crina Codreanu","Autorizat de",null,null,"Vlad Preda",null,"Rambursare per kilometru",null,null,{"v":0.32,"d":"0.32 lei"}]
[]
[null,"Departament","Vânzări","Data remiterii",null,null,{"$f":"TODAY()","v":"2018-01-19"},null,"Rambursare totală datorată",null,null,{"$f":"RambursareTotalăDatorată","v":{"v":2106.9580368098163,"d":"2,106.96 lei"}}]
[]
[null,"Perioada",{"$f":"IF(MIN(B10:B13)=MAX(B10:B13),TEXT(MIN(B10:B13),\"dd.mm.yyyy\"),\"De la \"&TEXT(MIN(B10:B13),\"dd.mm.yyyy\")&\" la \"&TEXT(MAX(B10:B13),\"dd.mm.yyyy\"))","v":"De la 20.12.2017 la 25.12.2017"}]
[]
[null,"Dată","Descrierea cheltuielilor","Bilet de avion","Cazare","Transport \nintern \n(benzină, mașină închiriată, taxi)","Mese și bacșișuri","Conferințe și seminarii","Kilometri","Rambursare kilometraj","Diverse","Rata de schimb valutar","Monedă cheltuieli","Total"]
[null,{"$f":"TODAY()-30","v":"2017-12-20"},"Transport la biroul clientului",{"v":350,"d":"350.00"},{"v":150,"d":"150.00"},{"v":45,"d":"45.00"},{"v":12,"d":"12.00"},{"v":50,"d":"50.00"},{"v":35,"d":"35.00"},{"$f":"IF('Raport de cheltuieli'!I10<>\"\",'Raport de cheltuieli'!I10*PrețTransport,\"\")","v":{"v":11.200000000000001,"d":"11.20"}},null,{"v":0.326,"d":"0.33"},"CAD",{"$f":"IFERROR(IF(OR('Raport de cheltuieli'!$L10=\"\",'Raport de cheltuieli'!$L10=1),SUM('Raport de cheltuieli'!$J10:$K10,'Raport de cheltuieli'!$D10:$H10)*1,SUM('Raport de cheltuieli'!$J10:$K10,'Raport de cheltuieli'!$D10:$H10)/'Raport de cheltuieli'!$L10),\"\")","v":{"v":1896.319018404908,"d":"1,896.32 lei"}}]
[null,{"$f":"TODAY()-30","v":"2017-12-20"},"Prânz cu clientul",{"$nulls":3},{"v":24.3,"d":"24.30"},null,{"v":12,"d":"12.00"},{"$f":"IF('Raport de cheltuieli'!I11<>\"\",'Raport de cheltuieli'!I11*PrețTransport,\"\")","v":3.84},null,{"v":0.326,"d":"0.33"},"CAD",{"$f":"IFERROR(IF(OR('Raport de cheltuieli'!$L11=\"\",'Raport de cheltuieli'!$L11=1),SUM('Raport de cheltuieli'!$J11:$K11,'Raport de cheltuieli'!$D11:$H11)*1,SUM('Raport de cheltuieli'!$J11:$K11,'Raport de cheltuieli'!$D11:$H11)/'Raport de cheltuieli'!$L11),\"\")","v":{"v":86.31901840490798,"d":"86.32 lei"}}]
[null,"2017-12-20","Seminar amiază",{"$nulls":4},{"v":100,"d":"100.00"},{"v":6,"d":"6.00"},{"$f":"IF('Raport de cheltuieli'!I12<>\"\",'Raport de cheltuieli'!I12*PrețTransport,\"\")","v":1.92},null,{"v":1,"d":"1.00"},"RON",{"$f":"IFERROR(IF(OR('Raport de cheltuieli'!$L12=\"\",'Raport de cheltuieli'!$L12=1),SUM('Raport de cheltuieli'!$J12:$K12,'Raport de cheltuieli'!$D12:$H12)*1,SUM('Raport de cheltuieli'!$J12:$K12,'Raport de cheltuieli'!$D12:$H12)/'Raport de cheltuieli'!$L12),\"\")","v":{"v":101.92,"d":"101.92 lei"}}]
[null,{"$f":"TODAY()-25","v":"2017-12-25"},"Deplasare la aeroport",{"$nulls":5},{"v":70,"d":"70.00"},{"$f":"IF('Raport de cheltuieli'!I13<>\"\",'Raport de cheltuieli'!I13*PrețTransport,\"\")","v":{"v":22.400000000000002,"d":"22.40"}},null,{"v":1,"d":"1.00"},"RON",{"$f":"IFERROR(IF(OR('Raport de cheltuieli'!$L13=\"\",'Raport de cheltuieli'!$L13=1),SUM('Raport de cheltuieli'!$J13:$K13,'Raport de cheltuieli'!$D13:$H13)*1,SUM('Raport de cheltuieli'!$J13:$K13,'Raport de cheltuieli'!$D13:$H13)/'Raport de cheltuieli'!$L13),\"\")","v":{"v":22.400000000000002,"d":"22.40 lei"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,Cheltuieli[Bilet de avion])","v":{"v":350,"d":"350.00"}},{"$f":"SUBTOTAL(109,Cheltuieli[Cazare])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Cheltuieli[Transport \nintern \n(benzină, mașină închiriată, taxi)])","v":{"v":45,"d":"45.00"}},{"$f":"SUBTOTAL(109,Cheltuieli[Mese și bacșișuri])","v":{"v":36.3,"d":"36.30"}},{"$f":"SUBTOTAL(109,Cheltuieli[Conferințe și seminarii])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Cheltuieli[Kilometri])","v":{"v":123,"d":"123.00"}},{"$f":"SUBTOTAL(109,Cheltuieli[Rambursare kilometraj])","v":39.36},{"$f":"SUBTOTAL(109,Cheltuieli[Diverse])","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUBTOTAL(109,Cheltuieli[Total])","v":{"v":2106.9580368098163,"d":"2,106.96 lei"}}]