{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Mandato local consultorías","Mandato local Bienes o Servicio","ML consultorías (Addendum)","Budget TFM Nov 02","Budget TFM Nov 02 with PLE"],"not_rendered":{"images":2,"external_links":1,"defined_names":4,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Mandato local consultorías","index":0,"n_rows":47,"n_cols":7,"rows_kept":47,"merged":[[23,1,23,2],[32,1,32,2],[39,1,39,2],[43,1,43,6],[44,1,44,6],[45,1,45,6],[46,1,46,6]]}
[{"$nulls":6},"ANEXO 2"]
[]
[null,"Mandato local para Consultorías:  Presupuesto"]
[]
[]
[null,"Nombre Consultor/Compañia:","xx"]
[null,"Nombre del proyecto:","xx"]
[null,"No.7F","7F-"]
[null,"No de Contrato","xx"]
[null,"Duración prevista del mandato:","de:",null,"a:"]
[]
[null,"-  Expresado en","Bolivianos -"]
[{"$nulls":6},"Costo Total"]
["Cód.","Función/ Designación",null,"Precio/Unid.","Unidad","Cantidad",{"$f":"IF(C12=\"bolivianos\",\"BOB\",(IF(C12=\"Dólares Américanos -\",\"USD\",\"BOB\")))","v":"BOB"}]
[]
[1,"Honorarios Consultores"]
[]
[null,"Consultor  1",null,null,"dia",null,{"$f":"D18*F18","v":0}]
[{"$nulls":6},0]
[null,"Consultor  2",{"$nulls":4},0]
[{"$nulls":6},0]
[null,"Consultor  3",{"$nulls":4},0]
[{"$nulls":6},0]
[null,"Total honorarios consultores",{"$nulls":4},{"$f":"SUM(G18:G23)","v":0}]
[]
[2,"Gastos de viaje ( gastos reales)"]
[]
[null,"Vuelo",null,null,"viaje",null,{"$f":"D28*F28","v":0}]
[null,"Transporte aeropuerto",null,null,"Tramo",null,{"$f":"D29*F29","v":0}]
[null,"Gastos de Hospedaje",null,null,"día/noche",null,{"$f":"D30*F30","v":0}]
[null,"Viaticos (Desayuno, almuerzo y cena)",null,null,"día",null,{"$f":"D31*F31","v":0}]
[{"$nulls":6},{"$f":"D32*F32","v":0}]
[null,"Total gastos de viaje",{"$nulls":4},{"$f":"SUM(G28:G32)","v":0}]
[]
[3,"Otros gastos"]
[]
[{"$nulls":6},{"$f":"D37*F37","v":0}]
[{"$nulls":6},{"$f":"D38*F38","v":0}]
[{"$nulls":6},{"$f":"D39*F39","v":0}]
[null,"Total otros gastos",{"$nulls":4},{"$f":"SUM(G35:G39)","v":0}]
[]
[null,"TOTAL General ",{"$nulls":3},{"$f":"IF(C12=\"bolivianos\",\"BOB\",(IF(C12=\"Dólares Américanos -\",\"USD\",\"BOB\")))","v":"BOB"},{"$f":"G24+G33+G40","v":0}]
[]
[null,"    *El proceso interno de pago toma un promedio de 10 días luego de la aprobación del informe, producto o solicitud de pago."]
[null,"  **Los gastos no pueden exceder al presupuesto del Anexo 2 del contrato.  "]
[null,{"$f":"IF(C12=\"bolivianos\",\"***Los viaticos de alimentación tienen un monto fijo (Desayuno BOB 36, Almuerzo BOB 112 y Cena BOB 112)\",(IF(C12=\"Dólares Américanos -\",\" ***Los viaticos de alimentación tienen un monto fijo (Desayuno USD 5, Almuerzo USD 16 y Cena USD 16)\",\"***Los viaticos de alimentación tienen un monto fijo (Desayuno BOB 36, Almuerzo BOB 112 y Cena BOB 112)\")))","v":"***Los viaticos de alimentación tienen un monto fijo (Desayuno BOB 36, Almuerzo BOB 112 y Cena BOB 112)"}]
[null,"****Según normativa interna de la Cooperación Suiza, no se reconocerán los hospedajes mayores a 4 estrellas"]

{"sheet":"Mandato local Bienes o Servicio","index":1,"n_rows":51,"n_cols":7,"rows_kept":51,"merged":[[23,1,23,2],[32,1,32,2],[39,1,39,2]]}
[{"$nulls":6},"ANEXO 2"]
[]
[null,"Mandato local para Consultorías:  Presupuesto"]
[]
[]
[null,"Nombre Compañia:","xx"]
[null,"Objeto del Mandato:","xx"]
[null,"No.7F","7F-"]
[null,"No de Contrato","xx"]
[null,"Duración prevista del mandato:","de:",null,"a:"]
[]
[null,"-  Expresado en","Dólares américanos -"]
[{"$nulls":6},"Total"]
["Cód.","Función/ Designación",null,"Precio/Unid.","Unidad","Cantidad",{"$f":"IF(C12=\"bolivianos\",\"Costo BOB\",(IF(C12=\"Dólares Américanos -\",\"Costo USD\",\"Costo BOB\")))","v":"Costo USD"}]
[]
[1,"Remuneración Consultores"]
[]
[null,"Detallar los bienes o servicios si tienen precios unitarios, sino colocar global",{"$nulls":4},{"$f":"D18*F18","v":0}]
[null,"Ej. Comedor, sillas, etc.",{"$nulls":4},0]
[null,"Servicio de Limpieza",{"$nulls":4},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,"Total remuneración consultores",{"$nulls":4},{"$f":"SUM(G18:G23)","v":0}]
[]
[2,"Gastos de viaje ( gastos reales)"]
[]
[null,"no aplica",{"$nulls":4},{"$f":"D28*F28","v":0}]
[{"$nulls":6},{"$f":"D29*F29","v":0}]
[{"$nulls":6},{"$f":"D30*F30","v":0}]
[{"$nulls":6},{"$f":"D31*F31","v":0}]
[{"$nulls":6},{"$f":"D32*F32","v":0}]
[null,"Total gastos de viaje",{"$nulls":4},{"$f":"SUM(G28:G32)","v":0}]
[]
[3,"Otros gastos"]
[]
[null,"Transporte, etc… colocar no aplica si no se va usar esta linea",{"$nulls":4},{"$f":"D37*F37","v":0}]
[{"$nulls":6},{"$f":"D38*F38","v":0}]
[{"$nulls":6},{"$f":"D39*F39","v":0}]
[null,"Total otros gastos",{"$nulls":4},{"$f":"SUM(G35:G39)","v":0}]
[]
[null,"TOTAL General ",{"$nulls":3},{"$f":"IF(C12=\"bolivianos\",\"BOB\",(IF(C12=\"Dólares Américanos -\",\"USD\",\"BOB\")))","v":"USD"},{"$f":"G24+G33+G40","v":0}]
[]
[null,null,"Monto","Fecha aprox. pago*"]
[null,"1er pago"]
[null,"2do pago"]
[null,"3er pago"]
[null,"…. Pago"]
[null,null,{"$f":"SUM(C45:C48)","v":0},{"$f":"IF((C49=G42),\" \", \"error, verificar suma\")","v":" "}]
[]
[null,"* El proceso interno de pago toma un promedio de 10 días luego de la aprobación del informe, producto o solicitud de pago."]

{"sheet":"ML consultorías (Addendum)","index":2,"n_rows":48,"n_cols":9,"rows_kept":48,"merged":[[23,1,23,2],[32,1,32,2],[39,1,39,2],[45,1,45,6],[46,1,46,6],[47,1,47,6]]}
[{"$nulls":8},"ANEXO 2"]
[]
[null,"Mandato local para Consultorías:  Presupuesto"]
[]
[]
[null,"Nombre Consultor/Compañia:","xx"]
[null,"Nombre de la consultoría:","xx"]
[null,"No.7F","7F-"]
[null,"No de Contrato","xx",null,"Adenda No."]
[null,"Duración prevista del mandato:","de:",null,"a:"]
[]
[null,"-  Expresado en","Bolivianos -"]
[{"$nulls":6},"Total","Addendum","Nuevo Total"]
["Cód.","Función/ Designación",null,"Precio/Unid.","Unidad","Cantidad",{"$f":"IF(C12=\"bolivianos\",\"Costo BOB\",(IF(C12=\"Dólares Américanos -\",\"USD\",\"BOB\")))","v":"BOB"},{"$f":"IF(C12=\"bolivianos\",\"Costo BOB\",(IF(C12=\"Dólares Américanos -\",\"USD\",\"BOB\")))","v":"BOB"},{"$f":"IF(C12=\"bolivianos\",\"Costo BOB\",(IF(C12=\"Dólares Américanos -\",\"USD\",\"BOB\")))","v":"BOB"}]
[]
[1,"Remuneración Consultores"]
[]
[null,"Consultor  1",null,null,"hora(s)",null,{"$f":"D18*F18","v":0},0,{"$f":"SUM(G18:H18)","v":0}]
[{"$nulls":4},"día(s)",null,0,0,0]
[null,"Consultor  2",null,null,"hora(s)",null,0,0,0]
[{"$nulls":4},"day(s)",null,0,0,0]
[null,"Consultor  3",null,null,"hora(s)",null,0,0,0]
[{"$nulls":4},"día(s)",null,0,0,0]
[null,"Total remuneración consultores",{"$nulls":4},{"$f":"SUM(G18:G23)","v":0},{"$f":"SUM(H18:H23)","v":0},{"$f":"SUM(I18:I23)","v":0}]
[]
[2,"Gastos de viaje ( gastos reales)"]
[]
[null,"Vuelo",null,null,"viaje",null,{"$f":"D28*F28","v":0},0,{"$f":"SUM(G28:H28)","v":0}]
[null,"Transporte aeropuerto",null,null,"Tramo",null,{"$f":"D29*F29","v":0},0,{"$f":"SUM(G29:H29)","v":0}]
[null,"Gastos de Hospedaje",null,null,"día/noche",null,{"$f":"D30*F30","v":0},0,{"$f":"SUM(G30:H30)","v":0}]
[null,"Viaticos (Desayuno, almuerzo y cena)",null,null,"día",null,{"$f":"D31*F31","v":0},0,{"$f":"SUM(G31:H31)","v":0}]
[{"$nulls":6},{"$f":"D32*F32","v":0},0,{"$f":"SUM(G32:H32)","v":0}]
[null,"Total gastos de viaje",{"$nulls":4},{"$f":"SUM(G28:G32)","v":0},{"$f":"SUM(H28:H32)","v":0},{"$f":"SUM(I28:I32)","v":0}]
[]
[3,"Otros gastos"]
[]
[{"$nulls":6},{"$f":"D37*F37","v":0},0,{"$f":"SUM(G37:H37)","v":0}]
[{"$nulls":6},0,0,{"$f":"SUM(G38:H38)","v":0}]
[{"$nulls":6},0,0,{"$f":"SUM(G39:H39)","v":0}]
[null,"Total otros gastos",{"$nulls":4},{"$f":"SUM(G35:G39)","v":0},{"$f":"SUM(H35:H39)","v":0},{"$f":"SUM(I35:I39)","v":0}]
[]
[null,"TOTAL General ",{"$nulls":3},{"$f":"IF(C12=\"bolivianos\",\"BOB\",(IF(C12=\"Dólares Américanos -\",\"USD\",\"BOB\")))","v":"BOB"},{"$f":"G24+G33+G40","v":0},{"$f":"H24+H33+H40","v":0},{"$f":"I24+I33+I40","v":0}]
[]
[]
[null,"* El proceso interno de pago toma un promedio de 10 días luego de la aprobación del informe, producto o solicitud de pago."]
[null,"**Los gastos no pueden exceder al presupuesto del Anexo 2 del contrato.  "]
[null,{"$f":"IF(C12=\"bolivianos\",\"***Los viaticos de alimentación tienen un monto fijo (Desayuno BOB 36, Almuerzo BOB 112 y Cena BOB 112)\",(IF(C12=\"Dólares Américanos -\",\" ***Los viaticos de alimentación tienen un monto fijo (Desayuno USD 5, Almuerzo USD 16 y Cena USD 16)\",\"***Los viaticos de alimentación tienen un monto fijo (Desayuno BOB 36, Almuerzo BOB 112 y Cena BOB 112)\")))","v":"***Los viaticos de alimentación tienen un monto fijo (Desayuno BOB 36, Almuerzo BOB 112 y Cena BOB 112)"}]
[null,"****Según normativa interna de la Cooperación Suiza, no se reconocerán los hospedajes mayores a 5 estrellas"]

{"sheet":"Budget TFM Nov 02","index":3,"n_rows":225,"n_cols":15,"rows_kept":225,"hidden":true,"merged":[[8,2,8,3],[9,8,9,9],[9,10,9,11],[9,12,9,13],[16,0,17,0],[48,2,48,3],[56,0,57,0],[64,2,64,3],[73,2,73,3],[75,0,76,0],[88,2,88,3],[187,2,187,3],[188,2,188,3],[189,2,189,3],[190,2,190,3]]}
[]
[null,null,"Budget for Mandate with Trust Fund Management"]
[]
[null,null,{"$f":"'[1]Mandato local implem. proyecto'!C4","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!D4","v":{"v":0,"d":"0.00"}},{"$nulls":7},"Swiss Agency for Development and Cooperation (SDC)"]
[null,null,{"$f":"'[1]Mandato local implem. proyecto'!C5","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!D5","v":"Nombre Proyecto"},{"$nulls":7},{"$f":"'[1]Mandato local implem. proyecto'!L5","v":0}]
[{"$nulls":11},"Freiburgstrase 130"]
[null,null,"Name/Company:",{"$f":"'[1]Mandato local implem. proyecto'!D8","v":"Duración prevista del mandato"},"Intended duration of mandate:",{"$nulls":6},"CH-3003 Bern"]
[]
[null,null,{"$f":"'[1]Mandato local implem. proyecto'!C10","v":"Parte 1 y 2: Costos de los servicios del Contratista "},null,"from:",{"$f":"'[1]Mandato local implem. proyecto'!F10","v":"00:00:00"},"to:",{"$f":"'[1]Mandato local implem. proyecto'!H10","v":"00:00:00"}]
[{"$nulls":8},"Partial Action 1",null,"Partial Action 2",null,"Partial Action 3",null,"Total"]
["EXPLANATION","Code","Function/ Designation",null,"Price/ Unit","Unit","Quantity",null,"Quantity","Costs","Quantity","Costs","Quantity","Costs","Costs"]
[]
[null,"PART 1: Budget for services"]
[]
[null,1.1,"REMUNERATION "]
[]
["fees of staff at HQ assigned to the Project and/or taking on tasks of a general nature and/or managing the Project in HQ","1.11","Headquater (HQ) staff"]
[]
[null,null,"Managerial and technical staff:"]
["work at headquarter (HQ)",null,"Project director HQ",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+E20*I20","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+E20*K20","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E20*M20","v":{"$error":"#REF!"}},{"$f":"IF(E20*G20=0,0,IF(OR(E20*G20<>(J20+L20+N20),(J20+L20+N20)=0),\"Fill in 'Partial Action'\",E20*G20))","v":{"$error":"#REF!"}}]
["visit abroad",null,"Project director HQ",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+E21*I21","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+E21*K21","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E21*M21","v":{"$error":"#REF!"}},{"$f":"IF(E21*G21=0,0,IF(OR(E21*G21<>(J21+L21+N21),(J21+L21+N21)=0),\"Fill in 'Partial Action'\",E21*G21))","v":{"$error":"#REF!"}}]
["work at headquarter",null,"Project manager HQ",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+E22*I22","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+E22*K22","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E22*M22","v":{"$error":"#REF!"}},{"$f":"IF(E22*G22=0,0,IF(OR(E22*G22<>(J22+L22+N22),(J22+L22+N22)=0),\"Fill in 'Partial Action'\",E22*G22))","v":{"$error":"#REF!"}}]
["work abroad: visit or expertise",null,"Project manager HQ",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+E23*I23","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+E23*K23","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E23*M23","v":{"$error":"#REF!"}},{"$f":"IF(E23*G23=0,0,IF(OR(E23*G23<>(J23+L23+N23),(J23+L23+N23)=0),\"Fill in 'Partial Action'\",E23*G23))","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Administrative staff:",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
["fund management",null,"Accountant HQ",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+E26*I26","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+E26*K26","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E26*M26","v":{"$error":"#REF!"}},{"$f":"IF(E26*G26=0,0,IF(OR(E26*G26<>(J26+L26+N26),(J26+L26+N26)=0),\"Fill in 'Partial Action'\",E26*G26))","v":{"$error":"#REF!"}}]
["procurements",null,"Logistics HQ",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+E27*I27","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+E27*K27","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E27*M27","v":{"$error":"#REF!"}},{"$f":"IF(E27*G27=0,0,IF(OR(E27*G27<>(J27+L27+N27),(J27+L27+N27)=0),\"Fill in 'Partial Action'\",E27*G27))","v":{"$error":"#REF!"}}]
["mandate-specific",null,"Secretary HQ",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+E28*I28","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+E28*K28","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E28*M28","v":{"$error":"#REF!"}},{"$f":"IF(E28*G28=0,0,IF(OR(E28*G28<>(J28+L28+N28),(J28+L28+N28)=0),\"Fill in 'Partial Action'\",E28*G28))","v":{"$error":"#REF!"}}]
[]
[null,null,"Remuneration Headquater (HQ) staff ",null,null,"(SAP-Number: 33000000)",{"$nulls":3},{"$f":"SUM(J20:J29)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L20:L29)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N20:N29)","v":{"$error":"#REF!"}},{"$f":"O20+O21+O22+O23+O26+O27+O28","v":{"$error":"#REF!"}}]
[]
["fees of expatriate staff (located abroad)","1.12","Expatriate(s)"]
["10.5 working-months/year",null,"Teamleader",null,{"$f":"'[1]Mandato local implem. proyecto'!E49","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F49","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G49","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H49","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I49","v":0},{"$f":"+E33*I33","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K49","v":0},{"$f":"+E33*K33","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M49","v":0},{"$f":"+$E33*M33","v":{"v":0,"d":"0.00"}},{"$f":"IF(E33*G33=0,0,IF(OR(E33*G33<>(J33+L33+N33),(J33+L33+N33)=0),\"Fill in 'Partial Action'\",E33*G33))","v":{"v":0,"d":"0.00"}}]
["10.5 working-months/year",null,"Advisor (s)",null,{"$f":"'[1]Mandato local implem. proyecto'!E50","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F50","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G50","v":"mes trabj."},{"$f":"'[1]Mandato local implem. proyecto'!H50","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I50","v":0},{"$f":"+E34*I34","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K50","v":0},{"$f":"+E34*K34","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M50","v":0},{"$f":"+$E34*M34","v":{"v":0,"d":"0.00"}},{"$f":"IF(E34*G34=0,0,IF(OR(E34*G34<>(J34+L34+N34),(J34+L34+N34)=0),\"Fill in 'Partial Action'\",E34*G34))","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!E51","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F51","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G51","v":"mes trabj."},{"$f":"'[1]Mandato local implem. proyecto'!H51","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I51","v":{"v":0,"d":"0.00"}},null,{"$f":"'[1]Mandato local implem. proyecto'!K51","v":{"v":0,"d":"0.00"}},null,{"$f":"'[1]Mandato local implem. proyecto'!M51","v":{"v":0,"d":"0.00"}}]
[null,null,"Remuneration Expatriate(s)",null,null,"(SAP-Number: 36000000)",{"$nulls":3},{"$f":"SUM(J33:J35)","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K52","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L33:L35)","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M52","v":{"v":0,"d":"0.00"}},{"$f":"SUM(N33:N35)","v":{"v":0,"d":"0.00"}},{"$f":"O33+O34","v":{"$error":"#VALUE!"}}]
[]
["fees of consultant and/or international consultants","1.13","Consultant and/or international consultants "]
[]
["preparation finalisation at HQ (hour)",null,"Consultant  1",null,{"$f":"'[1]Mandato local implem. proyecto'!E56","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F56","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G56","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H56","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I56","v":0},{"$f":"+$E40*I40","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K56","v":0},{"$f":"+$E40*K40","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M56","v":0},{"$f":"+$E40*M40","v":{"v":0,"d":"0.00"}},{"$f":"IF(E40*G40=0,0,IF(OR(E40*G40<>(J40+L40+N40),(J40+L40+N40)=0),\"Fill in 'Partial Action'\",E40*G40))","v":{"v":0,"d":"0.00"}}]
["on mission abroad (day)",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!E57","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F57","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G57","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H57","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I57","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K57","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M57","v":0},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["preparation finalisation at HQ (hour)",null,"Consultant  2",null,{"$f":"'[1]Mandato local implem. proyecto'!E58","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F58","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G58","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H58","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I58","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K58","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M58","v":0},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["on mission abroad (day)",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!E59","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F59","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G59","v":"hora(s)"},{"$f":"'[1]Mandato local implem. proyecto'!H59","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I59","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K59","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M59","v":0},{"v":0,"d":"0.00"},{"$error":"#VALUE!"}]
["preparation finalisation at HQ (hour)",null,"Consultant  3",null,{"$f":"'[1]Mandato local implem. proyecto'!E60","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F60","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G60","v":"día (s)"},{"$f":"'[1]Mandato local implem. proyecto'!H60","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I60","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K60","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M60","v":0},{"v":0,"d":"0.00"},{"$error":"#VALUE!"}]
["on mission abroad (day)",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!E61","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F61","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G61","v":"hora(s)"},{"$f":"'[1]Mandato local implem. proyecto'!H61","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I61","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K61","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M61","v":0},{"v":0,"d":"0.00"},{"$error":"#VALUE!"}]
["preparation finalisation at HQ (hour)",null,"Consultant  4",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["on mission abroad (day)",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Renumeration Consultant and/or\ninternational consultants",null,null,"(SAP-Number: 36000010)",{"$nulls":3},{"$f":"SUM(J40:J48)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!K62","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L40:L48)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!M62","v":{"v":0,"d":"0.00"}},{"$f":"SUM(N40:N48)","v":{"$error":"#REF!"}},{"$f":"O40+O41+O42+O43+O44+O45+O46+O47","v":{"$error":"#VALUE!"}}]
[{"$nulls":10},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
["SUM 1.11 + 1.12 + 1.13",null,"TOTAL REMUNERATION 1.1",{"$nulls":6},{"$f":"+J49+J36+J30","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+L49+L36+L30","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+N49+N36+N30","v":{"$error":"#REF!"}},{"$f":"+O49+O36+O30","v":{"$error":"#VALUE!"}}]
[]
[null,1.2,"DIRECT COSTS international"]
[]
[null,1.21,"DIRECT COSTS (staff)"]
[]
["travelling expenses of headquarters staff responsible for the administration of the Project ","1.21.1","International travel and expenses (HQ-staff)"]
[]
["return ticket, business",null,"Project director",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E59*I59","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E59*K59","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E59*M59","v":{"$error":"#REF!"}},{"$f":"IF(E59*G59=0,0,IF(OR(E59*G59<>(J59+L59+N59),(J59+L59+N59)=0),\"Fill in 'Partial Action'\",E59*G59))","v":{"$error":"#REF!"}}]
["return ticket, business",null,"Project manager(s)",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E60*I60","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E60*K60","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E60*M60","v":{"$error":"#REF!"}},{"$f":"IF(E60*G60=0,0,IF(OR(E60*G60<>(J60+L60+N60),(J60+L60+N60)=0),\"Fill in 'Partial Action'\",E60*G60))","v":{"$error":"#REF!"}}]
["lump sum per trip for visa,vaccinations, taxes,miscellaneous",null,"Travel expenses",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E61*I61","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E61*K61","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E61*M61","v":{"$error":"#REF!"}},{"$f":"IF(E61*G61=0,0,IF(OR(E61*G61<>(J61+L61+N61),(J61+L61+N61)=0),\"Fill in 'Partial Action'\",E61*G61))","v":{"$error":"#REF!"}}]
["as of SDC regulations",null,"Per diems",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E62*I62","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E62*K62","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E62*M62","v":{"$error":"#REF!"}},{"$f":"IF(E62*G62=0,0,IF(OR(E62*G62<>(J62+L62+N62),(J62+L62+N62)=0),\"Fill in 'Partial Action'\",E62*G62))","v":{"$error":"#REF!"}}]
["actual costs (e.g hotel supplement) on submission of receipts",null,"Additional travel costs",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E63*I63","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E63*K63","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E63*M63","v":{"$error":"#REF!"}},{"$f":"IF(E63*G63=0,0,IF(OR(E63*G63<>(J63+L63+N63),(J63+L63+N63)=0),\"Fill in 'Partial Action'\",E63*G63))","v":{"$error":"#REF!"}}]
[]
[null,null,"DIRECT COSTS International travel and expenses (HQ-staff)",null,null,"(SAP-Number: 33000000)",{"$nulls":3},{"$f":"SUM(J59:J64)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L59:L64)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N59:N64)","v":{"$error":"#REF!"}},{"$f":"O59+O60+O61+O62+O63","v":{"$error":"#REF!"}}]
[]
["travelling expenses","1.21.2","International travel and expenses (consultants)"]
[]
["return ticket",null,"Consultant (s)",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E69*I69","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E69*K69","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E69*M69","v":{"$error":"#REF!"}},{"$f":"IF(E69*G69=0,0,IF(OR(E69*G69<>(J69+L69+N69),(J69+L69+N69)=0),\"Fill in 'Partial Action'\",E69*G69))","v":{"$error":"#REF!"}}]
["lump sum per trip for visa,vacc.,taxes,misc.",null,"Travel expenses",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E70*I70","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E70*K70","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E70*M70","v":{"$error":"#REF!"}},{"$f":"IF(E70*G70=0,0,IF(OR(E70*G70<>(J70+L70+N70),(J70+L70+N70)=0),\"Fill in 'Partial Action'\",E70*G70))","v":{"$error":"#REF!"}}]
["as of SDC regulations",null,"Per diems",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E71*I71","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E71*K71","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E71*M71","v":{"$error":"#REF!"}},{"$f":"IF(E71*G71=0,0,IF(OR(E71*G71<>(J71+L71+N71),(J71+L71+N71)=0),\"Fill in 'Partial Action'\",E71*G71))","v":{"$error":"#REF!"}}]
["actual costs (e.g hotel supplement) on submission of receipts",null,"Additional travel costs",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E72*I72","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E72*K72","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E72*M72","v":{"$error":"#REF!"}},{"$f":"IF(E72*G72=0,0,IF(OR(E72*G72<>(J72+L72+N72),(J72+L72+N72)=0),\"Fill in 'Partial Action'\",E72*G72))","v":{"$error":"#REF!"}}]
[]
[null,null,"DIRECT COSTS International travel and expenses (consultants)",null,null,"(SAP-Number: 36000010)",{"$nulls":3},{"$f":"SUM(J69:J73)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L69:L73)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N69:N73)","v":{"$error":"#REF!"}},{"$f":"O69+O70+O71+O72","v":{"$error":"#REF!"}}]
[]
["expenses of expatriate staff and their families accompanying\nthem to the post ","1.21.3","Travel expenses of resident expatriates and dependants"]
[]
["experts and dependants",null,"Transfer flights (start/ end of assignment)",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E78*I78","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E78*K78","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E78*M78","v":{"$error":"#REF!"}},{"$f":"IF(E78*G78=0,0,IF(OR(E78*G78<>(J78+L78+N78),(J78+L78+N78)=0),\"Fill in 'Partial Action'\",E78*G78))","v":{"$error":"#REF!"}}]
["oneway, business class",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["500 kg per adult",null,"Transfer of luggage (start/ end of ",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["250 kg per child",null,"  assignement)",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["experts and dependants",null,"Homeleave - flights",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["1 return per year, eco-class",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["Lump sum per trip and person for visa,vacc.,taxes,misc.",null,"Homeleave - travel expenses",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["80 kg per trip and person",null,"Homeleave - luggage",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Miscellaneous",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["actual costs (e.g hotel supplement) on submission of receipts",null,"Additional travel costs",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,null,"DIRECT COSTS Travel expenses of resident expatriates and dependants",null,null,"(SAP-Number: 36000000)",{"$nulls":3},{"$f":"SUM(J78:J88)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L78:L88)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N78:N88)","v":{"$error":"#REF!"}},{"$f":"O78+O79+O80+O81+O82+O83+O84+O85+O86+O87","v":{"$error":"#REF!"}}]
[]
[]
[null,"1.21.4","Expenses of foreign residence"]
["at cost",null,"Housing allowance",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E93*I93","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E93*K93","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E93*M93","v":{"$error":"#REF!"}},{"$f":"IF(E93*G93=0,0,IF(OR(E93*G93<>(J93+L93+N93),(J93+L93+N93)=0),\"Fill in 'Partial Action'\",E93*G93))","v":{"$error":"#REF!"}}]
["lump sum covering displacement, storage-costs, \nmedical checks",null,"Assignment\n  indemnity",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E94*I94","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E94*K94","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E94*M94","v":{"$error":"#REF!"}},{"$f":"IF(E94*G94=0,0,IF(OR(E94*G94<>(J94+L94+N94),(J94+L94+N94)=0),\"Fill in 'Partial Action'\",E94*G94))","v":{"$error":"#REF!"}}]
[null,null,"Schooling fees",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E95*I95","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E95*K95","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E95*M95","v":{"$error":"#REF!"}},{"$f":"IF(E95*G95=0,0,IF(OR(E95*G95<>(J95+L95+N95),(J95+L95+N95)=0),\"Fill in 'Partial Action'\",E95*G95))","v":{"$error":"#REF!"}}]
[]
[null,null,"DIRECT COSTS Expenses of foreign residence",null,null,"(SAP-Number: 36000000)",{"$nulls":3},{"$f":"SUM(J93:J96)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L93:L96)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N93:N96)","v":{"$error":"#REF!"}},{"$f":"O93+O94+O95","v":{"$error":"#REF!"}}]
[]
[null,null,"Total 1.21 DIRECT COSTS (staff)",{"$nulls":6},{"$f":"SUM(J89+J74+J65+J97)","v":{"$error":"#REF!"}},null,{"$f":"SUM(L89+L74+L65+L97)","v":{"$error":"#REF!"}},null,{"$f":"SUM(N89+N74+N65+N97)","v":{"$error":"#REF!"}},{"$f":"SUM(O89+O74+O65+O97)","v":{"$error":"#REF!"}}]
[]
[]
[null,1.22,"DIRECT COSTS for HQ-Administration"]
[]
[]
["lump sum, project related costs",null,"Communication",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E105*I105","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E105*K105","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E105*M105","v":{"$error":"#REF!"}},{"$f":"IF(E105*G105=0,0,IF(OR(E105*G105<>(J105+L105+N105),(J105+L105+N105)=0),\"Fill in 'Partial Action'\",E105*G105))","v":{"$error":"#REF!"}}]
["rail ticket, 2nd class, half-fare",null,"Travel to SDC-HQ",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["working day in Bern",null,"Meals",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["overnight stays incl. meals",null,"Per diem Bern",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["actual costs (e.g hotel supplement) on submission of receipts",null,"Additional travel costs",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Other costs",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,null,"DIRECT COSTS HQ-Administration",null,null,"(SAP-Number: 33000000)",{"$nulls":3},{"$f":"SUM(J104:J111)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L104:L111)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N104:N111)","v":{"$error":"#REF!"}},{"$f":"O105+O106+O107+O108+O109+O110","v":{"$error":"#REF!"}}]
[]
[null,1.23,"DIRECT COSTS Third Parties"]
[]
[]
["lump sum per year (budgetary)",null,"Audit at HQ",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E117*I117","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E117*K117","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E117*M117","v":{"$error":"#REF!"}},{"$f":"IF(E117*G117=0,0,IF(OR(E117*G117<>(J117+L117+N117),(J117+L117+N117)=0),\"Fill in 'Partial Action'\",E117*G117))","v":{"$error":"#REF!"}}]
["if not paid in lump sum",null,"Other costs",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E118*I118","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E118*K118","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E118*M118","v":{"$error":"#REF!"}},{"$f":"IF(E118*G118=0,0,IF(OR(E118*G118<>(J118+L118+N118),(J118+L118+N118)=0),\"Fill in 'Partial Action'\",E118*G118))","v":{"$error":"#REF!"}}]
[]
[null,null,"DIRECT COSTS  Third parties",null,null,"(SAP-Number: 33000000)",{"$nulls":3},{"$f":"SUM(J116:J119)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L116:L119)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N116:N119)","v":{"$error":"#REF!"}},{"$f":"O117+O118","v":{"$error":"#REF!"}}]
[]
["SUM  1.21 +1.22 +1.23",null,"TOTAL DIRECT COSTS 1.2",{"$nulls":6},{"$f":"+J120+J112+J97+J89+J74+J65","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+L120+L112+L97+L89+L74+L65","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+N120+N112+N97+N89+N74+N65","v":{"$error":"#REF!"}},{"$f":"+O120+O112+O99","v":{"$error":"#REF!"}}]
[]
[null,null," "]
[]
[]
["SUM 1.1 + 1.2",null,"TOTAL Part 1",{"$nulls":6},{"$f":"+J122+J51","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+L122+L51","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+N122+N51","v":{"$error":"#REF!"}},{"$f":"+O122+O51","v":{"$error":"#REF!"}}]
[]
[]
[null,"Part 2: Budget for fiduciary funds"]
[]
[]
[null,2.1,"PROJECT COSTS"]
[]
[null,"2.11","Remuneration of locals"]
[]
["salaries and costs ",null,"Local Project staff"]
["the price/unit includes salaries,",null,"Co-Teamleader",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E138*I138","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E138*K138","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E138*M138","v":{"$error":"#REF!"}},{"$f":"IF(E138*G138=0,0,IF(OR(E138*G138<>(J138+L138+N138),(J138+L138+N138)=0),\"Fill in 'Partial Action'\",E138*G138))","v":{"$error":"#REF!"}}]
["social costs and allowances of any",null,"Advisor (local)",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["kind.",null,"Accountant",null,{"$f":"'[1]Mandato local implem. proyecto'!E66","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F66","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G66","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H66","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I66","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K66","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M66","v":0},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,"Secretaries",null,{"$f":"'[1]Mandato local implem. proyecto'!E67","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F67","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G67","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H67","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I67","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K67","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M67","v":0},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,"Drivers",null,{"$f":"'[1]Mandato local implem. proyecto'!E68","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F68","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G68","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H68","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I68","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K68","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M68","v":0},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,"Peons",null,{"$f":"'[1]Mandato local implem. proyecto'!E69","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F69","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G69","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H69","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I69","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K69","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M69","v":0},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Local/ Regional consultants",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
["fees ",null,"Local expert (s)",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E146*I146","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E146*K146","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E146*M146","v":{"$error":"#REF!"}},{"$f":"IF(E146*G146=0,0,IF(OR(E146*G146<>(J146+L146+N146),(J146+L146+N146)=0),\"Fill in 'Partial Action'\",E146*G146))","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E147*I147","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E147*K147","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E147*M147","v":{"$error":"#REF!"}},{"$f":"IF(E147*G147=0,0,IF(OR(E147*G147<>(J147+L147+N147),(J147+L147+N147)=0),\"Fill in 'Partial Action'\",E147*G147))","v":{"$error":"#REF!"}}]
[]
[null,null,"Remuneration of locals",null,null,"(SAP-Number: 35000000)",{"$nulls":3},{"$f":"SUM(J138:J148)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!K78","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L138:L148)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!M78","v":{"v":0,"d":"0.00"}},{"$f":"SUM(N138:N148)","v":{"$error":"#REF!"}},{"$f":"O138+O139+O140+O141+O142+O143+O146+O147","v":{"$error":"#REF!"}}]
[]
[null,"2.12","DIRECT COSTS local / regional"]
[]
["travelling expenses international/ regional/ local staff ",null,"Travelling costs"]
[null,null,"Local/ regional flights",null,{"$f":"'[1]Mandato local implem. proyecto'!E74","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F74","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G74","v":"mes"},{"$f":"'[1]Mandato local implem. proyecto'!H74","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I74","v":0},{"$f":"+$E154*I154","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K74","v":0},{"$f":"+$E154*K154","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M74","v":0},{"$f":"+$E154*M154","v":{"v":0,"d":"0.00"}},{"$f":"IF(E154*G154=0,0,IF(OR(E154*G154<>(J154+L154+N154),(J154+L154+N154)=0),\"Fill in 'Partial Action'\",E154*G154))","v":{"$error":"#VALUE!"}}]
["except project-cars, to specify",null,"Other means of transport",null,{"$f":"'[1]Mandato local implem. proyecto'!E75","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F75","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G75","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H75","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I75","v":0},{"$f":"+$E155*I155","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K75","v":0},{"$f":"+$E155*K155","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M75","v":0},{"$f":"+$E155*M155","v":{"v":0,"d":"0.00"}},{"$f":"IF(E155*G155=0,0,IF(OR(E155*G155<>(J155+L155+N155),(J155+L155+N155)=0),\"Fill in 'Partial Action'\",E155*G155))","v":{"v":0,"d":"0.00"}}]
["local and regional consultants",null,"Per diems (consultants)",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E156*I156","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E156*K156","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E156*M156","v":{"$error":"#REF!"}},{"$f":"IF(E156*G156=0,0,IF(OR(E156*G156<>(J156+L156+N156),(J156+L156+N156)=0),\"Fill in 'Partial Action'\",E156*G156))","v":{"$error":"#REF!"}}]
["out of duty station (expats,locals)",null,"Per diems (project staff)",null,{"$f":"'[1]Mandato local implem. proyecto'!E76","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F76","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G76","v":"(No.SAP: 363 200 2200)"},{"$f":"'[1]Mandato local implem. proyecto'!H76","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I76","v":0},{"$f":"+$E157*I157","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K76","v":0},{"$f":"+$E157*K157","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M76","v":0},{"$f":"+$E157*M157","v":{"v":0,"d":"0.00"}},{"$f":"IF(E157*G157=0,0,IF(OR(E157*G157<>(J157+L157+N157),(J157+L157+N157)=0),\"Fill in 'Partial Action'\",E157*G157))","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Local infrastructure",null,{"$f":"'[1]Mandato local implem. proyecto'!E88","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F88","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G88","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H88","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I88","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!K88","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!M88","v":0}]
["communication, material, water,",null,"Office premises: rent",null,{"$f":"'[1]Mandato local implem. proyecto'!E90","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F90","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G90","v":"piezas"},{"$f":"'[1]Mandato local implem. proyecto'!H90","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I90","v":0},{"$f":"+$E160*I160","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K90","v":0},{"$f":"+$E160*K160","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M90","v":0},{"$f":"+$E160*M160","v":{"v":0,"d":"0.00"}},{"$f":"IF(E160*G160=0,0,IF(OR(E160*G160<>(J160+L160+N160),(J160+L160+N160)=0),\"Fill in 'Partial Action'\",E160*G160))","v":{"$error":"#VALUE!"}}]
["electricity, taxes, security",null,"Office: running costs",null,{"$f":"'[1]Mandato local implem. proyecto'!E91","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F91","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G91","v":"piezas"},{"$f":"'[1]Mandato local implem. proyecto'!H91","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I91","v":0},{"$f":"+$E161*I161","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K91","v":0},{"$f":"+$E161*K161","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M91","v":0},{"$f":"+$E161*M161","v":{"v":0,"d":"0.00"}},{"$f":"IF(E161*G161=0,0,IF(OR(E161*G161<>(J161+L161+N161),(J161+L161+N161)=0),\"Fill in 'Partial Action'\",E161*G161))","v":{"$error":"#VALUE!"}}]
["commodities",null,"Office material",null,{"$f":"'[1]Mandato local implem. proyecto'!E92","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F92","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G92","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H92","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I92","v":0},{"$f":"+$E162*I162","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K92","v":0},{"$f":"+$E162*K162","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M92","v":0},{"$f":"+$E162*M162","v":{"v":0,"d":"0.00"}},{"$f":"IF(E162*G162=0,0,IF(OR(E162*G162<>(J162+L162+N162),(J162+L162+N162)=0),\"Fill in 'Partial Action'\",E162*G162))","v":{"v":0,"d":"0.00"}}]
["repair, maintenance, replacement",null,"Office equipment",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E163*I163","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E163*K163","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E163*M163","v":{"$error":"#REF!"}},{"$f":"IF(E163*G163=0,0,IF(OR(E163*G163<>(J163+L163+N163),(J163+L163+N163)=0),\"Fill in 'Partial Action'\",E163*G163))","v":{"$error":"#REF!"}}]
["fuel, services, maintenance, repair",null,"Vehicles: running costs",null,{"$f":"'[1]Mandato local implem. proyecto'!E93","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F93","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G93","v":"(No. SAP: 363 200 2300)"},{"$f":"'[1]Mandato local implem. proyecto'!H93","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I93","v":0},{"$f":"+$E164*I164","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K93","v":0},{"$f":"+$E164*K164","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M93","v":0},{"$f":"+$E164*M164","v":{"v":0,"d":"0.00"}},{"$f":"IF(E164*G164=0,0,IF(OR(E164*G164<>(J164+L164+N164),(J164+L164+N164)=0),\"Fill in 'Partial Action'\",E164*G164))","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Purchase of equipment",null,{"$f":"'[1]Mandato local implem. proyecto'!E81","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F81","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G81","v":"día"},{"$f":"'[1]Mandato local implem. proyecto'!H81","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I81","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!K81","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!M81","v":0}]
["specify type and replacement/sale",null,"Project vehicles",null,{"$f":"'[1]Mandato local implem. proyecto'!E82","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F82","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G82","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H82","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I82","v":0},{"$f":"+$E167*I167","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K82","v":0},{"$f":"+$E167*K167","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M82","v":0},{"$f":"+$E167*M167","v":{"v":0,"d":"0.00"}},{"$f":"IF(E167*G167=0,0,IF(OR(E167*G167<>(J167+L167+N167),(J167+L167+N167)=0),\"Fill in 'Partial Action'\",E167*G167))","v":{"v":0,"d":"0.00"}}]
["\"shopping list\"",null,"Office equipment",null,{"$f":"'[1]Mandato local implem. proyecto'!E83","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F83","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G83","v":"(No. SAP: 363 200 2200)"},{"$f":"'[1]Mandato local implem. proyecto'!H83","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I83","v":0},{"$f":"+$E168*I168","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K83","v":0},{"$f":"+$E168*K168","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M83","v":0},{"$f":"+$E168*M168","v":{"v":0,"d":"0.00"}},{"$f":"IF(E168*G168=0,0,IF(OR(E168*G168<>(J168+L168+N168),(J168+L168+N168)=0),\"Fill in 'Partial Action'\",E168*G168))","v":{"$error":"#VALUE!"}}]
["project-specific",null,"Other material",null,{"$f":"'[1]Mandato local implem. proyecto'!E84","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F84","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G84","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H84","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I84","v":0},{"$f":"+$E169*I169","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K84","v":0},{"$f":"+$E169*K169","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M84","v":0},{"$f":"+$E169*M169","v":{"v":0,"d":"0.00"}},{"$f":"IF(E169*G169=0,0,IF(OR(E169*G169<>(J169+L169+N169),(J169+L169+N169)=0),\"Fill in 'Partial Action'\",E169*G169))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E170*I170","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E170*K170","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E170*M170","v":{"$error":"#REF!"}},{"$f":"IF(E170*G170=0,0,IF(OR(E170*G170<>(J170+L170+N170),(J170+L170+N170)=0),\"Fill in 'Partial Action'\",E170*G170))","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!E85","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F85","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G85","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H85","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I85","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!K85","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!M85","v":0}]
[null,null,"Third parties",null,{"$f":"'[1]Mandato local implem. proyecto'!E97","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F97","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G97","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H97","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I97","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!K97","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!M97","v":0}]
["lump sum per year (budgetary)",null,"Local auditing",null,{"$f":"'[1]Mandato local implem. proyecto'!E94","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F94","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G94","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H94","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I94","v":0},{"$f":"+$E173*I173","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K94","v":0},{"$f":"+$E173*K173","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M94","v":0},{"$f":"+$E173*M173","v":{"v":0,"d":"0.00"}},{"$f":"IF(E173*G173=0,0,IF(OR(E173*G173<>(J173+L173+N173),(J173+L173+N173)=0),\"Fill in 'Partial Action'\",E173*G173))","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,null,"DIRECT COSTS local / regional",null,null,"(SAP-Number: 35000000)",{"$nulls":3},{"$f":"SUM(J153:J175)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L153:L175)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N153:N175)","v":{"$error":"#REF!"}},{"$f":"O154+O155+O156+O157+O160+O161+O162+O163+O164+O167+O168+O169+O170+O173","v":{"$error":"#VALUE!"}}]
[{"$nulls":10},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
["Sum 2.11 +2.12",null,"TOTAL PROJECT COSTS  2.1",{"$nulls":6},{"$f":"SUM(J176+J149)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L176+L149)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N176+N149)","v":{"$error":"#REF!"}},{"$f":"SUM(O176+O149)","v":{"$error":"#VALUE!"}}]
[]
[null,2.2,"OTHER FIDUCIARY FUNDS"]
[]
[]
["incl. transport, insurance etc.",null,"Purchase of project material",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E183*I183","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E183*K183","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E183*M183","v":{"$error":"#REF!"}},{"$f":"IF(E183*G183=0,0,IF(OR(E183*G183<>(J183+L183+N183),(J183+L183+N183)=0),\"Fill in 'Partial Action'\",E183*G183))","v":{"$error":"#REF!"}}]
["incl. fitting out",null,"Expenditure on buildings",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["payment to holders",null,"Scholarships",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["organisation, participation",null,"Workshops and seminaries",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["as planned",null,"Other",{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["as planned",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["as planned",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["as planned",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["as planned",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
["made by sale",null,"Earnings",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E193*I193","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E193*K193","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E193*M193","v":{"$error":"#REF!"}},{"$f":"IF(E193*G193=0,0,IF(OR(E193*G193<>(J193+L193+N193),(J193+L193+N193)=0),\"Fill in 'Partial Action'\",E193*G193))","v":{"$error":"#REF!"}}]
["made by sale",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E194*I194","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E194*K194","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E194*M194","v":{"$error":"#REF!"}},{"$f":"IF(E194*G194=0,0,IF(OR(E194*G194<>(J194+L194+N194),(J194+L194+N194)=0),\"Fill in 'Partial Action'\",E194*G194))","v":{"$error":"#REF!"}}]
["made by sale",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E195*I195","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E195*K195","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E195*M195","v":{"$error":"#REF!"}},{"$f":"IF(E195*G195=0,0,IF(OR(E195*G195<>(J195+L195+N195),(J195+L195+N195)=0),\"Fill in 'Partial Action'\",E195*G195))","v":{"$error":"#REF!"}}]
["made by sale",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E196*I196","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E196*K196","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E196*M196","v":{"$error":"#REF!"}},{"$f":"IF(E196*G196=0,0,IF(OR(E196*G196<>(J196+L196+N196),(J196+L196+N196)=0),\"Fill in 'Partial Action'\",E196*G196))","v":{"$error":"#REF!"}}]
[]
[]
["Sum 2.2",null,"TOTAL OTHER FIDUCIARY FUNDS 2.2",null,null,"(SAP-Number: 35000000)",null,null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(J183:J191)-SUM(J193:J196)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L183:L191)-SUM(L193:L196)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N183:N191)-SUM(N193:N196)","v":{"$error":"#REF!"}},{"$f":"SUM(O183:O191)-SUM(O193:O196)","v":{"$error":"#REF!"}}]
[]
[null,2.3,"INTERESTS"]
[]
[]
[null,null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E204*I204","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E204*K204","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E204*M204","v":{"$error":"#REF!"}},{"$f":"IF(E204*G204=0,0,IF(OR(E204*G204<>(J204+L204+N204),(J204+L204+N204)=0),\"Fill in 'Partial Action'\",E204*G204))","v":{"$error":"#REF!"}}]
[]
[]
["Sum 2.3",null,"TOTAL INTERESTS  2.3",null,null,"(SAP-Number: 74000000)",null,null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(J203:J205)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L203:L205)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N203:N205)","v":{"$error":"#REF!"}},{"$f":"O204","v":{"$error":"#REF!"}}]
[]
[]
["SUM 2.1 + 2.2 + 2.3",null,"TOTAL Part 2",{"$nulls":5},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"J207+J199+J176+J149","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"L207+L199+L176+L149","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"N207+N199+N176+N149","v":{"$error":"#REF!"}},{"$f":"O199+O178+O207","v":{"$error":"#REF!"}}]
[{"$nulls":8},{"$f":"'[1]Mandato local implem. proyecto'!I109","v":{"v":0,"d":"0.00"}},null,{"$f":"'[1]Mandato local implem. proyecto'!K109","v":{"v":0,"d":"0.00"}},null,{"$f":"'[1]Mandato local implem. proyecto'!M109","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"$f":"'[1]Mandato local implem. proyecto'!I110","v":{"v":0,"d":"0.00"}},null,{"$f":"'[1]Mandato local implem. proyecto'!K110","v":{"v":0,"d":"0.00"}},null,{"$f":"'[1]Mandato local implem. proyecto'!M110","v":{"v":0,"d":"0.00"}}]
["SUM PART 1 + PART 2",null,"GRAND TOTAL",null,{"$f":"+F210+F127","v":0},{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+J210+J127","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+L210+L127","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+N210+N127","v":{"$error":"#REF!"}},{"$f":"+O210+O127","v":{"$error":"#REF!"}}]
[]
[]
[{"$nulls":7},"Budgetary planning of expenditures per year"]
[]
[]
[{"$nulls":11},"Partial","Partial","Partial","Total"]
[{"$nulls":11},"Action 1","Action 2","Action 3","Costs"]
[{"$nulls":10},"Share financed by SDC     1st   year:",{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L221:N221)","v":{"$error":"#REF!"}}]
[{"$nulls":10}," 2nd year:",{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L222:N222)","v":{"$error":"#REF!"}}]
[{"$nulls":10}," 3rd  year:",{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L223:N223)","v":{"$error":"#REF!"}}]
[{"$nulls":10}," 4th  year:",{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L224:N224)","v":{"$error":"#REF!"}}]
[{"$nulls":13},"Total",{"$f":"SUM(O221:O224)","v":{"$error":"#REF!"}}]

{"sheet":"Budget TFM Nov 02 with PLE","index":4,"n_rows":225,"n_cols":15,"rows_kept":225,"hidden":true,"merged":[[8,2,8,3],[9,8,9,9],[9,10,9,11],[9,12,9,13],[16,0,17,0],[48,2,48,3],[56,0,57,0],[64,2,64,3],[73,2,73,3],[75,0,76,0],[88,2,88,3],[187,2,187,3],[188,2,188,3],[189,2,189,3],[190,2,190,3]]}
[]
[null,null,"Budget for Mandate with Trust Fund Management (including PLE)"]
[]
[null,null,"Ref. DMS:",{"$nulls":8},"Swiss Agency for Development and Cooperation (SDC)"]
[null,null,"Ref. of Mandate",{"$nulls":8},{"$f":"'[1]Mandato local implem. proyecto'!L5","v":0}]
[{"$nulls":11},"Freiburgstrase 130"]
[null,null,"Name/Company:",null,"Intended duration of mandate:",{"$nulls":6},"CH-3003 Bern"]
[]
[null,null,{"$f":"'[1]Mandato local implem. proyecto'!C10","v":"Parte 1 y 2: Costos de los servicios del Contratista "},null,"from:",{"$f":"'[1]Mandato local implem. proyecto'!F10","v":"00:00:00"},"to:",{"$f":"'[1]Mandato local implem. proyecto'!H10","v":"00:00:00"}]
[{"$nulls":8},"Partial Action 1",null,"Partial Action 2",null,"Partial Action 3",null,"Total"]
["EXPLANATION","Code","Function/ Designation",null,"Price/ Unit","Unit","Quantity",null,"Quantity","Costs","Quantity","Costs","Quantity","Costs","Costs"]
[]
[null,"PART 1: Budget for services"]
[]
[null,1.1,"REMUNERATION "]
[]
["fees of staff at HQ assigned to the Project and/or taking on tasks of a general nature and/or managing the Project in HQ","1.11","Headquater (HQ) staff included in PLE"]
[]
[]
[{"$nulls":9},{"$f":"+E20*I20","v":{"v":0,"d":"0.00"}},null,{"$f":"+E20*K20","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E20*M20","v":{"v":0,"d":"0.00"}},{"$f":"IF(E20*G20=0,0,IF(OR(E20*G20<>(J20+L20+N20),(J20+L20+N20)=0),\"Fill in 'Partial Action'\",E20*G20))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"+E21*I21","v":{"v":0,"d":"0.00"}},null,{"$f":"+E21*K21","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E21*M21","v":{"v":0,"d":"0.00"}},{"$f":"IF(E21*G21=0,0,IF(OR(E21*G21<>(J21+L21+N21),(J21+L21+N21)=0),\"Fill in 'Partial Action'\",E21*G21))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"+E22*I22","v":{"v":0,"d":"0.00"}},null,{"$f":"+E22*K22","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E22*M22","v":{"v":0,"d":"0.00"}},{"$f":"IF(E22*G22=0,0,IF(OR(E22*G22<>(J22+L22+N22),(J22+L22+N22)=0),\"Fill in 'Partial Action'\",E22*G22))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"+E23*I23","v":{"v":0,"d":"0.00"}},null,{"$f":"+E23*K23","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E23*M23","v":{"v":0,"d":"0.00"}},{"$f":"IF(E23*G23=0,0,IF(OR(E23*G23<>(J23+L23+N23),(J23+L23+N23)=0),\"Fill in 'Partial Action'\",E23*G23))","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":9},{"$f":"+E26*I26","v":{"v":0,"d":"0.00"}},null,{"$f":"+E26*K26","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E26*M26","v":{"v":0,"d":"0.00"}},{"$f":"IF(E26*G26=0,0,IF(OR(E26*G26<>(J26+L26+N26),(J26+L26+N26)=0),\"Fill in 'Partial Action'\",E26*G26))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"+E27*I27","v":{"v":0,"d":"0.00"}},null,{"$f":"+E27*K27","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E27*M27","v":{"v":0,"d":"0.00"}},{"$f":"IF(E27*G27=0,0,IF(OR(E27*G27<>(J27+L27+N27),(J27+L27+N27)=0),\"Fill in 'Partial Action'\",E27*G27))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"+E28*I28","v":{"v":0,"d":"0.00"}},null,{"$f":"+E28*K28","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E28*M28","v":{"v":0,"d":"0.00"}},{"$f":"IF(E28*G28=0,0,IF(OR(E28*G28<>(J28+L28+N28),(J28+L28+N28)=0),\"Fill in 'Partial Action'\",E28*G28))","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Remuneration Headquater (HQ) staff ",{"$nulls":6},{"$f":"SUM(J20:J29)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(L20:L29)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(N20:N29)","v":{"v":0,"d":"0.00"}},{"$f":"O20+O21+O22+O23+O26+O27+O28","v":{"v":0,"d":"0.00"}}]
[]
["fees of expatriate staff (located abroad)","1.12","Expatriate(s)"]
["10.5 working-months/year",null,"Teamleader",null,{"$f":"'[1]Mandato local implem. proyecto'!E49","v":{"v":0,"d":"0.00"}},"w'mth",{"$f":"'[1]Mandato local implem. proyecto'!G49","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!I49","v":0},{"$f":"+E33*I33","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K49","v":0},{"$f":"+E33*K33","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M49","v":0},{"$f":"+$E33*M33","v":{"v":0,"d":"0.00"}},{"$f":"IF(E33*G33=0,0,IF(OR(E33*G33<>(J33+L33+N33),(J33+L33+N33)=0),\"Fill in 'Partial Action'\",E33*G33))","v":{"v":0,"d":"0.00"}}]
["10.5 working-months/year",null,"Advisor (s)",null,{"$f":"'[1]Mandato local implem. proyecto'!E50","v":{"v":0,"d":"0.00"}},"w'mth",{"$f":"'[1]Mandato local implem. proyecto'!G50","v":"mes trabj."},null,{"$f":"'[1]Mandato local implem. proyecto'!I50","v":0},{"$f":"+E34*I34","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K50","v":0},{"$f":"+E34*K34","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M50","v":0},{"$f":"+$E34*M34","v":{"v":0,"d":"0.00"}},{"$f":"IF(E34*G34=0,0,IF(OR(E34*G34<>(J34+L34+N34),(J34+L34+N34)=0),\"Fill in 'Partial Action'\",E34*G34))","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Remuneration Expatriate(s)",null,null,"(SAP-Number: 36000000)",{"$nulls":3},{"$f":"SUM(J33:J35)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(L33:L35)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(N33:N35)","v":{"v":0,"d":"0.00"}},{"$f":"O33+O34","v":{"$error":"#VALUE!"}}]
[]
["fees of consultant and/or international consultants","1.13","Consultant and/or international consultants "]
[]
["preparation finalisation at HQ (hour)",null,"Consultant  1",null,{"$f":"'[1]Mandato local implem. proyecto'!E56","v":{"v":0,"d":"0.00"}},"hour(s)",{"$f":"'[1]Mandato local implem. proyecto'!G56","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!I56","v":0},{"$f":"+$E40*I40","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K56","v":0},{"$f":"+$E40*K40","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M56","v":0},{"$f":"+$E40*M40","v":{"v":0,"d":"0.00"}},{"$f":"IF(E40*G40=0,0,IF(OR(E40*G40<>(J40+L40+N40),(J40+L40+N40)=0),\"Fill in 'Partial Action'\",E40*G40))","v":{"v":0,"d":"0.00"}}]
["on mission abroad (day)",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!E57","v":{"v":0,"d":"0.00"}},"day(s)",{"$f":"'[1]Mandato local implem. proyecto'!G57","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!I57","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K57","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M57","v":0},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["preparation finalisation at HQ (hour)",null,"Consultant  2",null,{"$f":"'[1]Mandato local implem. proyecto'!E58","v":{"v":0,"d":"0.00"}},"hour(s)",{"$f":"'[1]Mandato local implem. proyecto'!G58","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!I58","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K58","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M58","v":0},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["on mission abroad (day)",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!E59","v":{"v":0,"d":"0.00"}},"day(s)",{"$f":"'[1]Mandato local implem. proyecto'!G59","v":"hora(s)"},null,{"$f":"'[1]Mandato local implem. proyecto'!I59","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K59","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M59","v":0},{"v":0,"d":"0.00"},{"$error":"#VALUE!"}]
["preparation finalisation at HQ (hour)",null,"Consultant  3",null,{"$f":"'[1]Mandato local implem. proyecto'!E60","v":{"v":0,"d":"0.00"}},"hour(s)",{"$f":"'[1]Mandato local implem. proyecto'!G60","v":"día (s)"},null,{"$f":"'[1]Mandato local implem. proyecto'!I60","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K60","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M60","v":0},{"v":0,"d":"0.00"},{"$error":"#VALUE!"}]
["on mission abroad (day)",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!E61","v":{"v":0,"d":"0.00"}},"day(s)",{"$f":"'[1]Mandato local implem. proyecto'!G61","v":"hora(s)"},null,{"$f":"'[1]Mandato local implem. proyecto'!I61","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K61","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M61","v":0},{"v":0,"d":"0.00"},{"$error":"#VALUE!"}]
["preparation finalisation at HQ (hour)",null,"Consultant  4",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},"hour(s)",{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["on mission abroad (day)",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},"day(s)",{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,null,"Renumeration Consultant and/or\ninternational consultants",null,null,"(SAP-Number: 36000010)",{"$nulls":3},{"$f":"SUM(J40:J48)","v":{"$error":"#REF!"}},null,{"$f":"SUM(L40:L48)","v":{"$error":"#REF!"}},null,{"$f":"SUM(N40:N48)","v":{"$error":"#REF!"}},{"$f":"O40+O41+O42+O43+O44+O45+O46+O47","v":{"$error":"#VALUE!"}}]
[]
["SUM 1.12 + 1.13",null,"TOTAL REMUNERATION 1.1",{"$nulls":6},{"$f":"+J49+J36+J30","v":{"$error":"#REF!"}},null,{"$f":"+L49+L36+L30","v":{"$error":"#REF!"}},null,{"$f":"+N49+N36+N30","v":{"$error":"#REF!"}},{"$f":"+O49+O36+O30","v":{"$error":"#VALUE!"}}]
[]
[null,1.2,"DIRECT COSTS international"]
[]
[null,1.21,"DIRECT COSTS (staff)"]
[]
["travelling expenses of headquarters staff responsible for the administration of the Project ","1.21.1","International travel and expenses (HQ-staff) included in PLE"]
[]
[{"$nulls":9},{"$f":"+$E59*I59","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E59*K59","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E59*M59","v":{"v":0,"d":"0.00"}},{"$f":"IF(E59*G59=0,0,IF(OR(E59*G59<>(J59+L59+N59),(J59+L59+N59)=0),\"Fill in 'Partial Action'\",E59*G59))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"+$E60*I60","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E60*K60","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E60*M60","v":{"v":0,"d":"0.00"}},{"$f":"IF(E60*G60=0,0,IF(OR(E60*G60<>(J60+L60+N60),(J60+L60+N60)=0),\"Fill in 'Partial Action'\",E60*G60))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"+$E61*I61","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E61*K61","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E61*M61","v":{"v":0,"d":"0.00"}},{"$f":"IF(E61*G61=0,0,IF(OR(E61*G61<>(J61+L61+N61),(J61+L61+N61)=0),\"Fill in 'Partial Action'\",E61*G61))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"+$E62*I62","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E62*K62","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E62*M62","v":{"v":0,"d":"0.00"}},{"$f":"IF(E62*G62=0,0,IF(OR(E62*G62<>(J62+L62+N62),(J62+L62+N62)=0),\"Fill in 'Partial Action'\",E62*G62))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"+$E63*I63","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E63*K63","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E63*M63","v":{"v":0,"d":"0.00"}},{"$f":"IF(E63*G63=0,0,IF(OR(E63*G63<>(J63+L63+N63),(J63+L63+N63)=0),\"Fill in 'Partial Action'\",E63*G63))","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"DIRECT COSTS International travel and expenses (HQ-staff)",{"$nulls":6},{"$f":"SUM(J59:J64)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(L59:L64)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(N59:N64)","v":{"v":0,"d":"0.00"}},{"$f":"O59+O60+O61+O62+O63","v":{"v":0,"d":"0.00"}}]
[]
["travelling expenses","1.21.2","International travel and expenses (consultants)"]
[]
["return ticket",null,"Consultant (s)",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E69*I69","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E69*K69","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E69*M69","v":{"$error":"#REF!"}},{"$f":"IF(E69*G69=0,0,IF(OR(E69*G69<>(J69+L69+N69),(J69+L69+N69)=0),\"Fill in 'Partial Action'\",E69*G69))","v":{"$error":"#REF!"}}]
["lump sum per trip for visa,vacc.,taxes,misc.",null,"Travel expenses",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E70*I70","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E70*K70","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E70*M70","v":{"$error":"#REF!"}},{"$f":"IF(E70*G70=0,0,IF(OR(E70*G70<>(J70+L70+N70),(J70+L70+N70)=0),\"Fill in 'Partial Action'\",E70*G70))","v":{"$error":"#REF!"}}]
["as of SDC regulations",null,"Per diems",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E71*I71","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E71*K71","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E71*M71","v":{"$error":"#REF!"}},{"$f":"IF(E71*G71=0,0,IF(OR(E71*G71<>(J71+L71+N71),(J71+L71+N71)=0),\"Fill in 'Partial Action'\",E71*G71))","v":{"$error":"#REF!"}}]
["actual costs (e.g hotel supplement) on submission of receipts",null,"Additional travel costs",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E72*I72","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E72*K72","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E72*M72","v":{"$error":"#REF!"}},{"$f":"IF(E72*G72=0,0,IF(OR(E72*G72<>(J72+L72+N72),(J72+L72+N72)=0),\"Fill in 'Partial Action'\",E72*G72))","v":{"$error":"#REF!"}}]
[]
[null,null,"DIRECT COSTS International travel and expenses (consultants)",null,null,"(SAP-Number: 36000010)",{"$nulls":3},{"$f":"SUM(J69:J73)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L69:L73)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N69:N73)","v":{"$error":"#REF!"}},{"$f":"O69+O70+O71+O72","v":{"$error":"#REF!"}}]
[]
["expenses of expatriate staff and their families accompanying\nthem to the post ","1.21.3","Travel expenses of resident expatriates and dependants"]
[]
["experts and dependants",null,"Transfer flights (start/ end of assignment)",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E78*I78","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E78*K78","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E78*M78","v":{"$error":"#REF!"}},{"$f":"IF(E78*G78=0,0,IF(OR(E78*G78<>(J78+L78+N78),(J78+L78+N78)=0),\"Fill in 'Partial Action'\",E78*G78))","v":{"$error":"#REF!"}}]
["oneway, business class",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["500 kg per adult",null,"Transfer of luggage (start/ end of ",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["250 kg per child",null,"  assignement)",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["experts and dependants",null,"Homeleave - flights",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["1 return per year, eco-class",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["Lump sum per trip and person for visa,vacc.,taxes,misc.",null,"Homeleave - travel expenses",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["80 kg per trip and person",null,"Homeleave - luggage",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Miscellaneous",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["actual costs (e.g hotel supplement) on submission of receipts",null,"Additional travel costs",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,null,"DIRECT COSTS Travel expenses of resident expatriates and dependants",null,null,"(SAP-Number: 36000000)",{"$nulls":3},{"$f":"SUM(J78:J88)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L78:L88)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N78:N88)","v":{"$error":"#REF!"}},{"$f":"O78+O79+O80+O81+O82+O83+O84+O85+O86+O87","v":{"$error":"#REF!"}}]
[]
[]
[null,"1.21.4","Expenses of foreign residence"]
["at cost",null,"Housing allowance",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E93*I93","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E93*K93","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E93*M93","v":{"$error":"#REF!"}},{"$f":"IF(E93*G93=0,0,IF(OR(E93*G93<>(J93+L93+N93),(J93+L93+N93)=0),\"Fill in 'Partial Action'\",E93*G93))","v":{"$error":"#REF!"}}]
["lump sum covering displacement, storage-costs, \nmedical checks",null,"Assignment\n  indemnity",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E94*I94","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E94*K94","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E94*M94","v":{"$error":"#REF!"}},{"$f":"IF(E94*G94=0,0,IF(OR(E94*G94<>(J94+L94+N94),(J94+L94+N94)=0),\"Fill in 'Partial Action'\",E94*G94))","v":{"$error":"#REF!"}}]
[null,null,"Schooling fees",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E95*I95","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E95*K95","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E95*M95","v":{"$error":"#REF!"}},{"$f":"IF(E95*G95=0,0,IF(OR(E95*G95<>(J95+L95+N95),(J95+L95+N95)=0),\"Fill in 'Partial Action'\",E95*G95))","v":{"$error":"#REF!"}}]
[]
[null,null,"DIRECT COSTS Expenses of foreign residence",null,null,"(SAP-Number: 36000000)",{"$nulls":3},{"$f":"SUM(J93:J96)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L93:L96)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N93:N96)","v":{"$error":"#REF!"}},{"$f":"O93+O94+O95","v":{"$error":"#REF!"}}]
[]
[null,null,"Total 1.21 DIRECT COSTS (staff)",{"$nulls":6},{"$f":"SUM(J89+J74+J65+J97)","v":{"$error":"#REF!"}},null,{"$f":"SUM(L89+L74+L65+L97)","v":{"$error":"#REF!"}},null,{"$f":"SUM(N89+N74+N65+N97)","v":{"$error":"#REF!"}},{"$f":"SUM(O89+O74+O65+O97)","v":{"$error":"#REF!"}}]
[]
[]
[null,1.22,"DIRECT COSTS for HQ-Administration included in PLE"]
[]
[]
[{"$nulls":9},{"$f":"+$E105*I105","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E105*K105","v":{"v":0,"d":"0.00"}},null,{"$f":"+$E105*M105","v":{"v":0,"d":"0.00"}},{"$f":"IF(E105*G105=0,0,IF(OR(E105*G105<>(J105+L105+N105),(J105+L105+N105)=0),\"Fill in 'Partial Action'\",E105*G105))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,null,"DIRECT COSTS HQ-Administration",{"$nulls":6},{"$f":"SUM(J104:J111)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(L104:L111)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(N104:N111)","v":{"v":0,"d":"0.00"}},{"$f":"O105+O106+O107+O108+O109+O110","v":{"v":0,"d":"0.00"}}]
[]
[null,1.23,"DIRECT COSTS Third Parties"]
[]
[]
["lump sum per year (budgetary)",null,"Audit at HQ",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E117*I117","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E117*K117","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E117*M117","v":{"$error":"#REF!"}},{"$f":"IF(E117*G117=0,0,IF(OR(E117*G117<>(J117+L117+N117),(J117+L117+N117)=0),\"Fill in 'Partial Action'\",E117*G117))","v":{"$error":"#REF!"}}]
["if not paid in lump sum",null,"Other costs",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E118*I118","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E118*K118","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E118*M118","v":{"$error":"#REF!"}},{"$f":"IF(E118*G118=0,0,IF(OR(E118*G118<>(J118+L118+N118),(J118+L118+N118)=0),\"Fill in 'Partial Action'\",E118*G118))","v":{"$error":"#REF!"}}]
[]
[null,null,"DIRECT COSTS  Third parties",null,null,"(SAP-Number: 33000000)",{"$nulls":3},{"$f":"SUM(J116:J119)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L116:L119)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N116:N119)","v":{"$error":"#REF!"}},{"$f":"O117+O118","v":{"$error":"#REF!"}}]
[]
["SUM  1.21 +1.22 +1.23",null,"TOTAL DIRECT COSTS 1.2",{"$nulls":6},{"$f":"+J120+J112+J97+J89+J74+J65","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+L120+L112+L97+L89+L74+L65","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+N120+N112+N97+N89+N74+N65","v":{"$error":"#REF!"}},{"$f":"+O120+O112+O99","v":{"$error":"#REF!"}}]
[]
["SUM (1.12 + 1.13 + 1.21.2 + 1.12.3 + 1.21.4 + 1.23 + 2.1 \n+ 2.2 + 2.3 excluding \"Earnings\") multiplied by percentage",1.3,"PLE","Percentage:",{"v":0.13,"d":"13.00%"},{"$nulls":4},{"$f":"INT(((+J36+J49+J74+J89+J97+J120+J178+SUM(J183:J191))*$E$124)*20+0.5)/20","v":{"$error":"#REF!"}},null,{"$f":"INT(((+L36+L49+L74+L89+L97+L120+L178+SUM(L183:L191))*$E$124)*20+0.5)/20","v":{"$error":"#REF!"}},null,{"$f":"INT(((+N36+N49+N74+N89+N97+N120+N178+SUM(N183:N191))*$E$124)*20+0.5)/20","v":{"$error":"#REF!"}},{"$f":"INT(((+O36+O49+O74+O89+O97+O120+O178+SUM(O183:O191))*$E$124)*20+0.5)/20","v":{"$error":"#VALUE!"}}]
[]
[]
["SUM 1.1 + 1.2 + 1.3",null,"TOTAL Part 1",{"$nulls":6},{"$f":"+J122+J51+J124","v":{"$error":"#REF!"}},null,{"$f":"+L122+L51+L124","v":{"$error":"#REF!"}},null,{"$f":"+N122+N51+N124","v":{"$error":"#REF!"}},{"$f":"+O122+O51+O124","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,"Part 2: Budget for fiduciary funds"]
[]
[null,2.1,"PROJECT COSTS"]
[]
[null,"2.11","Remuneration of locals"]
[]
["salaries and costs ",null,"Local Project staff"]
["the price/unit includes salaries,",null,"Co-Teamleader",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E138*I138","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E138*K138","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E138*M138","v":{"$error":"#REF!"}},{"$f":"IF(E138*G138=0,0,IF(OR(E138*G138<>(J138+L138+N138),(J138+L138+N138)=0),\"Fill in 'Partial Action'\",E138*G138))","v":{"$error":"#REF!"}}]
["social costs and allowances of any",null,"Advisor (local)",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["kind.",null,"Accountant",null,{"$f":"'[1]Mandato local implem. proyecto'!E66","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F66","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G66","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H66","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I66","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K66","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M66","v":0},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,"Secretaries",null,{"$f":"'[1]Mandato local implem. proyecto'!E67","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F67","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G67","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H67","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I67","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K67","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M67","v":0},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,"Drivers",null,{"$f":"'[1]Mandato local implem. proyecto'!E68","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F68","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G68","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H68","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I68","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K68","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M68","v":0},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,"Peons",null,{"$f":"'[1]Mandato local implem. proyecto'!E69","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F69","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G69","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H69","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I69","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!K69","v":0},{"v":0,"d":"0.00"},{"$f":"'[1]Mandato local implem. proyecto'!M69","v":0},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Local/ Regional consultants",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
["fees ",null,"Local expert (s)",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E146*I146","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E146*K146","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E146*M146","v":{"$error":"#REF!"}},{"$f":"IF(E146*G146=0,0,IF(OR(E146*G146<>(J146+L146+N146),(J146+L146+N146)=0),\"Fill in 'Partial Action'\",E146*G146))","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E147*I147","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E147*K147","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E147*M147","v":{"$error":"#REF!"}},{"$f":"IF(E147*G147=0,0,IF(OR(E147*G147<>(J147+L147+N147),(J147+L147+N147)=0),\"Fill in 'Partial Action'\",E147*G147))","v":{"$error":"#REF!"}}]
[]
[null,null,"Remuneration of locals",null,null,"(SAP-Number: 35000000)",{"$nulls":3},{"$f":"SUM(J138:J148)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!K78","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L138:L148)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!M78","v":{"v":0,"d":"0.00"}},{"$f":"SUM(N138:N148)","v":{"$error":"#REF!"}},{"$f":"O138+O139+O140+O141+O142+O143+O146+O147","v":{"$error":"#REF!"}}]
[]
[null,"2.12","DIRECT COSTS local / regional"]
[]
["travelling expenses international/ regional/ local staff ",null,"Travelling costs"]
[null,null,"Local/ regional flights",null,{"$f":"'[1]Mandato local implem. proyecto'!E74","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F74","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G74","v":"mes"},{"$f":"'[1]Mandato local implem. proyecto'!H74","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I74","v":0},{"$f":"+$E154*I154","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K74","v":0},{"$f":"+$E154*K154","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M74","v":0},{"$f":"+$E154*M154","v":{"v":0,"d":"0.00"}},{"$f":"IF(E154*G154=0,0,IF(OR(E154*G154<>(J154+L154+N154),(J154+L154+N154)=0),\"Fill in 'Partial Action'\",E154*G154))","v":{"$error":"#VALUE!"}}]
["except project-cars, to specify",null,"Other means of transport",null,{"$f":"'[1]Mandato local implem. proyecto'!E75","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F75","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G75","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H75","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I75","v":0},{"$f":"+$E155*I155","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K75","v":0},{"$f":"+$E155*K155","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M75","v":0},{"$f":"+$E155*M155","v":{"v":0,"d":"0.00"}},{"$f":"IF(E155*G155=0,0,IF(OR(E155*G155<>(J155+L155+N155),(J155+L155+N155)=0),\"Fill in 'Partial Action'\",E155*G155))","v":{"v":0,"d":"0.00"}}]
["local and regional consultants",null,"Per diems (consultants)",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E156*I156","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E156*K156","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E156*M156","v":{"$error":"#REF!"}},{"$f":"IF(E156*G156=0,0,IF(OR(E156*G156<>(J156+L156+N156),(J156+L156+N156)=0),\"Fill in 'Partial Action'\",E156*G156))","v":{"$error":"#REF!"}}]
["out of duty station (expats,locals)",null,"Per diems (project staff)",null,{"$f":"'[1]Mandato local implem. proyecto'!E76","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F76","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G76","v":"(No.SAP: 363 200 2200)"},{"$f":"'[1]Mandato local implem. proyecto'!H76","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I76","v":0},{"$f":"+$E157*I157","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K76","v":0},{"$f":"+$E157*K157","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M76","v":0},{"$f":"+$E157*M157","v":{"v":0,"d":"0.00"}},{"$f":"IF(E157*G157=0,0,IF(OR(E157*G157<>(J157+L157+N157),(J157+L157+N157)=0),\"Fill in 'Partial Action'\",E157*G157))","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Local infrastructure",null,{"$f":"'[1]Mandato local implem. proyecto'!E88","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F88","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G88","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H88","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I88","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!K88","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!M88","v":0}]
["communication, material, water,",null,"Office premises: rent",null,{"$f":"'[1]Mandato local implem. proyecto'!E90","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F90","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G90","v":"piezas"},{"$f":"'[1]Mandato local implem. proyecto'!H90","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I90","v":0},{"$f":"+$E160*I160","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K90","v":0},{"$f":"+$E160*K160","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M90","v":0},{"$f":"+$E160*M160","v":{"v":0,"d":"0.00"}},{"$f":"IF(E160*G160=0,0,IF(OR(E160*G160<>(J160+L160+N160),(J160+L160+N160)=0),\"Fill in 'Partial Action'\",E160*G160))","v":{"$error":"#VALUE!"}}]
["electricity, taxes, security",null,"Office: running costs",null,{"$f":"'[1]Mandato local implem. proyecto'!E91","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F91","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G91","v":"piezas"},{"$f":"'[1]Mandato local implem. proyecto'!H91","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I91","v":0},{"$f":"+$E161*I161","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K91","v":0},{"$f":"+$E161*K161","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M91","v":0},{"$f":"+$E161*M161","v":{"v":0,"d":"0.00"}},{"$f":"IF(E161*G161=0,0,IF(OR(E161*G161<>(J161+L161+N161),(J161+L161+N161)=0),\"Fill in 'Partial Action'\",E161*G161))","v":{"$error":"#VALUE!"}}]
["commodities",null,"Office material",null,{"$f":"'[1]Mandato local implem. proyecto'!E92","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F92","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G92","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H92","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I92","v":0},{"$f":"+$E162*I162","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K92","v":0},{"$f":"+$E162*K162","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M92","v":0},{"$f":"+$E162*M162","v":{"v":0,"d":"0.00"}},{"$f":"IF(E162*G162=0,0,IF(OR(E162*G162<>(J162+L162+N162),(J162+L162+N162)=0),\"Fill in 'Partial Action'\",E162*G162))","v":{"v":0,"d":"0.00"}}]
["repair, maintenance, replacement",null,"Office equipment",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E163*I163","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E163*K163","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E163*M163","v":{"$error":"#REF!"}},{"$f":"IF(E163*G163=0,0,IF(OR(E163*G163<>(J163+L163+N163),(J163+L163+N163)=0),\"Fill in 'Partial Action'\",E163*G163))","v":{"$error":"#REF!"}}]
["fuel, services, maintenance, repair",null,"Vehicles: running costs",null,{"$f":"'[1]Mandato local implem. proyecto'!E93","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F93","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G93","v":"(No. SAP: 363 200 2300)"},{"$f":"'[1]Mandato local implem. proyecto'!H93","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I93","v":0},{"$f":"+$E164*I164","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K93","v":0},{"$f":"+$E164*K164","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M93","v":0},{"$f":"+$E164*M164","v":{"v":0,"d":"0.00"}},{"$f":"IF(E164*G164=0,0,IF(OR(E164*G164<>(J164+L164+N164),(J164+L164+N164)=0),\"Fill in 'Partial Action'\",E164*G164))","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Purchase of equipment",null,{"$f":"'[1]Mandato local implem. proyecto'!E81","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F81","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G81","v":"día"},{"$f":"'[1]Mandato local implem. proyecto'!H81","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I81","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!K81","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!M81","v":0}]
["specify type and replacement/sale",null,"Project vehicles",null,{"$f":"'[1]Mandato local implem. proyecto'!E82","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F82","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G82","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H82","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I82","v":0},{"$f":"+$E167*I167","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K82","v":0},{"$f":"+$E167*K167","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M82","v":0},{"$f":"+$E167*M167","v":{"v":0,"d":"0.00"}},{"$f":"IF(E167*G167=0,0,IF(OR(E167*G167<>(J167+L167+N167),(J167+L167+N167)=0),\"Fill in 'Partial Action'\",E167*G167))","v":{"v":0,"d":"0.00"}}]
["\"shopping list\"",null,"Office equipment",null,{"$f":"'[1]Mandato local implem. proyecto'!E83","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F83","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G83","v":"(No. SAP: 363 200 2200)"},{"$f":"'[1]Mandato local implem. proyecto'!H83","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I83","v":0},{"$f":"+$E168*I168","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K83","v":0},{"$f":"+$E168*K168","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M83","v":0},{"$f":"+$E168*M168","v":{"v":0,"d":"0.00"}},{"$f":"IF(E168*G168=0,0,IF(OR(E168*G168<>(J168+L168+N168),(J168+L168+N168)=0),\"Fill in 'Partial Action'\",E168*G168))","v":{"$error":"#VALUE!"}}]
["project-specific",null,"Other material",null,{"$f":"'[1]Mandato local implem. proyecto'!E84","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F84","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G84","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H84","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I84","v":0},{"$f":"+$E169*I169","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K84","v":0},{"$f":"+$E169*K169","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M84","v":0},{"$f":"+$E169*M169","v":{"v":0,"d":"0.00"}},{"$f":"IF(E169*G169=0,0,IF(OR(E169*G169<>(J169+L169+N169),(J169+L169+N169)=0),\"Fill in 'Partial Action'\",E169*G169))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E170*I170","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E170*K170","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E170*M170","v":{"$error":"#REF!"}},{"$f":"IF(E170*G170=0,0,IF(OR(E170*G170<>(J170+L170+N170),(J170+L170+N170)=0),\"Fill in 'Partial Action'\",E170*G170))","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!E85","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F85","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G85","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H85","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I85","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!K85","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!M85","v":0}]
[null,null,"Third parties",null,{"$f":"'[1]Mandato local implem. proyecto'!E97","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F97","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G97","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H97","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I97","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!K97","v":0},null,{"$f":"'[1]Mandato local implem. proyecto'!M97","v":0}]
["lump sum per year (budgetary)",null,"Local auditing",null,{"$f":"'[1]Mandato local implem. proyecto'!E94","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!F94","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!G94","v":0},{"$f":"'[1]Mandato local implem. proyecto'!H94","v":0},{"$f":"'[1]Mandato local implem. proyecto'!I94","v":0},{"$f":"+$E173*I173","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!K94","v":0},{"$f":"+$E173*K173","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Mandato local implem. proyecto'!M94","v":0},{"$f":"+$E173*M173","v":{"v":0,"d":"0.00"}},{"$f":"IF(E173*G173=0,0,IF(OR(E173*G173<>(J173+L173+N173),(J173+L173+N173)=0),\"Fill in 'Partial Action'\",E173*G173))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,"DIRECT COSTS local / regional",null,null,"(SAP-Number: 35000000)",{"$nulls":3},{"$f":"SUM(J153:J175)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L153:L175)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N153:N175)","v":{"$error":"#REF!"}},{"$f":"O154+O155+O156+O157+O160+O161+O162+O163+O164+O167+O168+O169+O170+O173","v":{"$error":"#VALUE!"}}]
[{"$nulls":10},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
["Sum 2.11 +2.12",null,"TOTAL PROJECT COSTS  2.1",{"$nulls":6},{"$f":"SUM(J176+J149)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L176+L149)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N176+N149)","v":{"$error":"#REF!"}},{"$f":"SUM(O176+O149)","v":{"$error":"#VALUE!"}}]
[]
[null,2.2,"OTHER FIDUCIARY FUNDS"]
[]
[]
["incl. transport, insurance etc.",null,"Purchase of project material",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E183*I183","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E183*K183","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E183*M183","v":{"$error":"#REF!"}},{"$f":"IF(E183*G183=0,0,IF(OR(E183*G183<>(J183+L183+N183),(J183+L183+N183)=0),\"Fill in 'Partial Action'\",E183*G183))","v":{"$error":"#REF!"}}]
["incl. fitting out",null,"Expenditure on buildings",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["payment to holders",null,"Scholarships",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["organisation, participation",null,"Workshops and seminaries",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["as planned",null,"Other",{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["as planned",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["as planned",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["as planned",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["as planned",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$nulls":4},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}}]
["made by sale",null,"Earnings",null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E193*I193","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E193*K193","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E193*M193","v":{"$error":"#REF!"}},{"$f":"IF(E193*G193=0,0,IF(OR(E193*G193<>(J193+L193+N193),(J193+L193+N193)=0),\"Fill in 'Partial Action'\",E193*G193))","v":{"$error":"#REF!"}}]
["made by sale",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E194*I194","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E194*K194","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E194*M194","v":{"$error":"#REF!"}},{"$f":"IF(E194*G194=0,0,IF(OR(E194*G194<>(J194+L194+N194),(J194+L194+N194)=0),\"Fill in 'Partial Action'\",E194*G194))","v":{"$error":"#REF!"}}]
["made by sale",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E195*I195","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E195*K195","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E195*M195","v":{"$error":"#REF!"}},{"$f":"IF(E195*G195=0,0,IF(OR(E195*G195<>(J195+L195+N195),(J195+L195+N195)=0),\"Fill in 'Partial Action'\",E195*G195))","v":{"$error":"#REF!"}}]
["made by sale",{"$nulls":3},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E196*I196","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E196*K196","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E196*M196","v":{"$error":"#REF!"}},{"$f":"IF(E196*G196=0,0,IF(OR(E196*G196<>(J196+L196+N196),(J196+L196+N196)=0),\"Fill in 'Partial Action'\",E196*G196))","v":{"$error":"#REF!"}}]
[]
[]
["Sum 2.2",null,"TOTAL OTHER FIDUCIARY FUNDS 2.2",null,null,"(SAP-Number: 35000000)",{"$nulls":3},{"$f":"SUM(J183:J191)-SUM(J193:J196)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L183:L191)-SUM(L193:L196)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N183:N191)-SUM(N193:N196)","v":{"$error":"#REF!"}},{"$f":"SUM(O183:O191)-SUM(O193:O196)","v":{"$error":"#REF!"}}]
[]
[null,2.3,"INTERESTS"]
[]
[]
[null,null,{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E204*I204","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E204*K204","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"+$E204*M204","v":{"$error":"#REF!"}},{"$f":"IF(E204*G204=0,0,IF(OR(E204*G204<>(J204+L204+N204),(J204+L204+N204)=0),\"Fill in 'Partial Action'\",E204*G204))","v":{"$error":"#REF!"}}]
[]
[]
["Sum 2.3",null,"TOTAL INTERESTS  2.3",null,null,"(SAP-Number: 74000000)",{"$nulls":3},{"$f":"SUM(J203:J205)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L203:L205)","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(N203:N205)","v":{"$error":"#REF!"}},{"$f":"O204","v":{"$error":"#REF!"}}]
[]
[]
["SUM 2.1 + 2.2 + 2.3",null,"TOTAL Part 2",{"$nulls":6},{"$f":"J207+J199+J176+J149","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"L207+L199+L176+L149","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"N207+N199+N176+N149","v":{"$error":"#REF!"}},{"$f":"O199+O178+O207","v":{"$error":"#REF!"}}]
[]
[]
["SUM PART 1 + PART 2",null,"GRAND TOTAL",null,{"$f":"+F210+F127","v":0},{"$nulls":4},{"$f":"+J210+J127","v":{"$error":"#REF!"}},null,{"$f":"+L210+L127","v":{"$error":"#REF!"}},null,{"$f":"+N210+N127","v":{"$error":"#REF!"}},{"$f":"+O210+O127","v":{"$error":"#REF!"}}]
[]
[]
[{"$nulls":7},"Budgetary planning of expenditures per year"]
[]
[]
[{"$nulls":11},"Partial","Partial","Partial","Total"]
[{"$nulls":11},"Action 1","Action 2","Action 3","Costs"]
[{"$nulls":10},"Share financed by SDC     1st   year:",{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L221:N221)","v":{"$error":"#REF!"}}]
[{"$nulls":10}," 2nd year:",{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L222:N222)","v":{"$error":"#REF!"}}]
[{"$nulls":10}," 3rd  year:",{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L223:N223)","v":{"$error":"#REF!"}}]
[{"$nulls":10}," 4th  year:",{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]Mandato local implem. proyecto'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L224:N224)","v":{"$error":"#REF!"}}]
[{"$nulls":13},"Total",{"$f":"SUM(O221:O224)","v":{"$error":"#REF!"}}]