{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Restlevensduur"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Restlevensduur","index":0,"n_rows":109,"n_cols":27,"rows_kept":109,"cut":false,"hidden":false,"merged":[[102,1,102,8],[66,6,66,7],[6,1,6,8],[13,4,13,7],[15,4,15,7],[17,4,17,7],[19,4,19,7],[64,6,64,7],[65,6,65,7],[11,4,11,7],[91,1,91,8],[97,1,97,8],[67,6,67,7],[68,6,68,7],[69,6,69,7]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Als niet alle cellen zijn ingevult geen mail vesturen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E10<>\"\",E12<>\"\",E22<>\"\",E24<>\"\",E26<>\"\",E28<>\"\",E60<>\"\",E62<>\"\",E70<>\"\",G70<>\"\"),\"email\",\"\")","v":""}]
[]
[]
[null,"Restlevensduur calculatie volgens FEM 9.755"]
[]
[]
[null,"Actuele jaar ",null,null,2020,null,{"$f":"IF(E10=\"\",\"Vul het huidige jaar in!\",\"\")","v":""}]
[]
[null,"Email adres",null,null,null,null,null,null,null,null,null,null,1945,2016,"1Dm","ja",2000,null,null,"Bedrijfsgroep","theoretisch gebruik (vollast)"]
[null,null,null,null,null,null,null,null,null,null,null,null,1946,2017,"1Cm","nee",2001]
[null,"Klant         ",null,null,null,null,null,null,null,null,null,null,1947,2018,"1Bm",null,2002,null,null,"1Dm",100]
[null,null,null,null,null,null,null,null,null,null,null,null,1948,2019,"1Am",null,2004,null,null,"1Cm",200]
[null,"Referentie",null,null,null,null,null,null,null,null,null,null,1949,2020,"2m",null,2005,null,null,"1Bm",400]
[null,null,null,null,null,null,null,null,null,null,null,null,1950,2021,"3m",null,2006,null,null,"1Am",800]
[null,"Takel    ",null,null,null,null,null,null,null,null,null,null,1951,2022,"4m",null,2007,null,null,"2m",1600]
[null,null,null,null,null,null,null,null,null,null,null,null,1952,2023,"5m",null,2008,null,null,"3m",3200]
[null,"Nummer ",null,null,null,null,null,null,null,null,null,null,1953,2024,null,null,2009,null,null,"4m",6300]
[null,null,null,null,null,null,null,null,null,null,null,null,1954,2025,null,null,2010,null,null,"5m",12500]
[null,"Bouwjaar ",null,null,null,null,{"$f":"IF(E22=\"\",\"Vul bouwjaar in!\",\"\")","v":"Vul bouwjaar in!"},null,null,null,null,null,1955,2026,null,null,2011]
[null,null,null,null,null,null,null,null,null,null,null,null,1956,2027,null,null,2012]
[null,"FEM Groep",null,null,null,null,{"$f":"IF(E24=\"\",\"Vul de FEM groep in! Dit staat vermeldt op het type plaatje van de takel\",\"\")","v":"Vul de FEM groep in! Dit staat vermeldt op het type plaatje van de takel"},null,null,null,null,null,1957,2028,null,null,2013]
[null,null,null,null,null,null,null,null,null,null,null,null,1958,2029,null,null,2014]
[null,"Is dit de eerste inventarisatie?",null,null,null,null,{"$f":"IF(E26=\"\",\"Vul ja of nee in!\",\"\")","v":"Vul ja of nee in!"},null,null,null,null,null,1959,2030,null,null,2015]
[null,null,null,null,null,null,null,null,null,null,null,null,1960,2031,null,null,2016]
[null,"Heeft de takel een uren teller?",null,null,null,null,{"$f":"IF(E28=\"\",\"Vul ja of nee in!\",\"\")","v":"Vul ja of nee in!"},null,null,null,null,null,1961,2032,null,null,2017]
[null,null,null,null,null,null,null,null,null,null,null,null,1962,2033,null,null,2018]
[null,null,null,"Hoeveel bedrijfsuren heeft de takel nu gedraaid ",null,null,null,null,null,null,null,null,1963,2034,null,null,2019]
[null,null,null,null,null,null,null,null,null,null,null,null,1964,2035,null,null,2020]
[null,null,null,null,null,null,null,null,null,null,null,null,1965,2036,null,null,2021]
[null,null,null,null,null,null,null,null,null,null,null,null,1966,2037,null,null,2022]
[null,null,null,null,null,null,null,null,null,null,null,null,1967,2038,null,null,2023]
[null,null,null,"Wanneer was de laatste inventarisatie ",null,null,null,null,null,null,null,null,1968,2039,null,null,2024]
[null,null,null,"Wat was toen de restlevensduur ",null,null,null,null,null,null,null,null,1969,2040]
[null,null,null,"Hoeveel bedrijfsuren had de takel toen gedraaid",null,null,null,null,null,null,null,null,1970,2041]
[null,null,null,"Hoeveel bedrijfsuren heeft de takel nu gedraaid ",null,null,null,null,null,null,null,null,1971,2042]
[null,null,null,null,null,null,null,null,null,null,null,null,1972,2043]
[null,null,null,null,null,null,null,null,null,null,null,null,1973,2044]
[null,null,null,"Wanneer was de laatste inventarisatie ",null,null,null,null,null,null,null,null,1974,2045]
[null,null,null,"Wat was toen de restlevensduur ",null,null,null,null,null,null,null,null,1975,2046]
[null,null,null,null,null,null,null,null,null,null,null,null,1976,2047]
[null,null,null,null,null,null,null,null,null,null,null,null,1977,2048]
[null,"Aantal werdagen per jaar",null,null,220,null,"dagen",null,null,null,null,null,1978,2049]
[null,null,null,null,null,null,null,null,null,null,null,null,1979,2050]
[null,"Aantal bedrijfsuren per dag ",null,null,2,null,"uren",null,null,null,null,null,1980,2051]
[null,null,null,null,null,null,null,null,null,null,null,null,1981,2052]
[null,"Aantal transporten per bedrijfsuur",null,null,3,null,"(1 transport = 2x hijsen en 2x zakken)",null,null,null,null,null,1982,2053]
[null,null,null,null,null,null,null,null,null,null,null,null,1983,2054]
[null,"Gemiddelde inhaallengte per keer hijsen",null,null,3,null,"m",null,null,null,null,null,1984,2055]
[null,null,null,null,null,null,null,null,null,null,null,null,1985,2056]
[null,"Grofhijssnelheid per minuut ",null,null,4,null,"m/min",null,null,null,null,null,1986,2057]
[null,null,null,null,null,null,null,null,null,null,null,null,1987,2058]
[null,null,null,null,{"$f":"IF(AND(E45<>\"\",E47<>\"\",E49<>\"\"),E45*E47*E49,\"\")","v":1320},null,"aantal transporten per jaar",null,null,null,null,null,1988,2059]
[null,null,null,null,{"$f":"IF(AND(E51<>\"\",E53<>\"\"),(((E51*4)/E53)/60),\"\")","v":0.05},null,"uur per transport",null,null,null,null,null,1989,2060]
[null,null,null,null,null,null,null,null,null,null,null,null,1990,2061]
[null,"Gemiddelde looptijd takel",null,null,{"$f":"IF(AND(E55<>\"\",E56<>\"\"),E55*E56,IF(I30<>\"\",(I30/(E10-E22)),IF(AND(I35<>\"\",I37<>\"\",I38<>\"\"),((I38-I37)/(E10-I35)),\"\")))","v":66},null,"uur per jaar ",{"$f":"IF(AND(OR(E45<>\"\",E47<>\"\",E49<>\"\",E51<>\"\",E53<>\"\"),I30<>\"\"),\"Invul formulier is niet leeg. Druk op Clear\",\"\")","v":""},null,null,null,null,1991,2062]
[null,null,null,null,null,null,null,null,null,null,null,null,1992,2063]
[null,"Nominale last van de takel",null,null,null,null,"kg",null,null,null,null,null,1993,2064]
[null,null,null,null,5000,null,null,null,null,null,null,null,1994,2065]
[null,"Gewicht traverse / lastopnamemiddel",null,null,0,null,"kg",null,null,null,null,null,1995,2066]
[null,null,null,null,null,null,null,null,null,null,null,null,1996,2067]
[null,"Lastspectrum",null,null,"Last in kilo's ",null,"% van de bedrijfstijd van de takel",null,null,null,null,null,1997,2068]
[null,"1.",{"$f":"IF(E65<>\"\",\"\",CONCATENATE(\"bijvoorbeeld \",ROUND($E$60*(4/4),0)))","v":"bijvoorbeeld 0"},null,null,null,null,null,null,{"$f":"IF(AND(G65<>\"\",E65=\"\"),\"Vul last in\",IF(AND(E65<>\"\",G65=\"\"),\"Vul percentage in\",\"\"))","v":""},null,null,1998,2069]
[null,"2.",{"$f":"IF(E66<>\"\",\"\",CONCATENATE(\"bijvoorbeeld \",ROUND($E$60*(3/4),0)))","v":"bijvoorbeeld 0"},null,null,null,null,null,null,{"$f":"IF(AND(G66<>\"\",E66=\"\"),\"Vul last in\",IF(AND(E66<>\"\",G66=\"\"),\"Vul percentage in\",\"\"))","v":""},null,null,1999,2070]
[null,"3.",{"$f":"IF(E67<>\"\",\"\",CONCATENATE(\"bijvoorbeeld \",ROUND($E$60*(2/4),0)))","v":"bijvoorbeeld 0"},null,null,null,null,null,null,{"$f":"IF(AND(G67<>\"\",E67=\"\"),\"Vul last in\",IF(AND(E67<>\"\",G67=\"\"),\"Vul percentage in\",\"\"))","v":""},null,null,2000,2071]
[null,"4.",{"$f":"IF(E68<>\"\",\"\",CONCATENATE(\"bijvoorbeeld \",ROUND($E$60*(1/4),0)))","v":"bijvoorbeeld 0"},null,null,null,null,null,null,{"$f":"IF(AND(G68<>\"\",E68=\"\"),\"Vul last in\",IF(AND(E68<>\"\",G68=\"\"),\"Vul percentage in\",\"\"))","v":""},null,null,2001,2072]
[null,"5.",null,null,null,null,null,null,null,{"$f":"IF(AND(G69<>\"\",E69=\"\"),\"Vul last in\",IF(AND(E69<>\"\",G69=\"\"),\"Vul percentage in\",\"\"))","v":""},null,null,2002,2073]
[null,"Lege haak met alleen stroppen",null,null,0,null,null,null,null,{"$f":"IF(G70=\"\",\"In theorie 50% van de haakbewegingen\",\"\")","v":"In theorie 50% van de haakbewegingen"},null,null,2003,2074]
[null,null,null,null,null,null,null,null,null,null,null,null,2004,2075]
[null,"Totaal ",null,null,null,null,null,{"$f":"SUM(G65:H70)","v":0},"%",{"$f":"IF(H72<>100, \"Totaal dient 100% te zijn\", \"\")","v":"Totaal dient 100% te zijn"},null,null,2005]
[null,null,null,null,null,null,null,null,null,null,null,null,2006]
[null,"Belastingsfactor K",null,null,{"$f":"IF(AND(E65<>\"\",E60<>\"\",E62<>\"\",E65<>\"\"),G65/100*((E65+E62)/E60)^3+G66/100*((E66+E62)/E60)^3+G67/100*((E67+E62)/E60)^3+G68/100*((E68+E62)/E60)^3+G69/100*((E69+E62)/E60)^3+G70/100*((E70+E62)/E60)^3,\"\")","v":""},null,{"$f":"IF(E74<>\"\",\"0=laag, 1=maximaal\", \"\")","v":""},null,null,null,null,null,2007]
[null,null,null,null,null,null,null,null,null,null,null,null,2008]
[null,"Correctiefactor ",null,null,{"$f":"IF(E28=\"ja\",1.1,1.2)","v":1.2},null,null,null,null,null,null,null,2009]
[null,null,null,null,null,null,null,null,null,null,null,null,2010]
[null,"Aantal vollasturen",null,null,{"$f":"IF(AND(E58<>\"\",E74<>\"\",E76<>\"\",H72=100),E58*E74*E76,\"\")","v":""},null,"uur per jaar ",null,null,null,null,null,2011]
[null,null,null,null,null,null,null,null,null,null,null,null,2012]
[null,"Beschikbare vollasturen bij nieuwlevering",null,null,{"$f":"IF(E24=\"1Dm\",100,IF(E24=\"1Cm\",200,IF(E24=\"1Bm\",400,IF(E24=\"1Am\",800,IF(E24<>\"\",VLOOKUP(E24,T13:U21,2,TRUE),\"\")))))","v":""},null,"uur",null,null,null,null,null,2013]
[null,"Beschikbare vollasturen bij voorgaande inventarisatie ",null,null,{"$f":"IF(I36<>\"\",I36,IF(I42<>\"\",I42,\"\"))","v":""},null,"uur         ",null,null,null,null,null,2014]
[null,null,null,null,null,null,null,null,null,null,null,null,2015]
[null,null,"Aantal vollasturen verbruikt in vorige inventarisatie",null,{"$f":"IF(I36<>\"\",E80-I36,IF(I42<>\"\",E80-I42,IF(E84<>\"\",0,\"\")))","v":""},null,"uur",null,null,null,null,null,2016]
[null,null,{"$f":"CONCATENATE(\"Aantal vollasturen verbruikt van \",IF(I35<>\"\",I35,IF(I41<>\"\",I41,IF(AND(I35=\"\",I41=\"\"),E22,\"\"))),\" tot \",E10)","v":"Aantal vollasturen verbruikt van  tot 2020"},null,{"$f":"IF(AND(E26=\"ja\",E28=\"ja\",E78<>\"\"),E78*(E10-E22),IF(AND(E26=\"ja\",E28=\"nee\",E78<>\"\"),E78*(E10-E22),IF(AND(E26=\"nee\",E28=\"ja\",E78<>\"\"),E78*(E10-I35),IF(AND(E26=\"nee\",E28=\"nee\",E78<>\"\"),E78*(E10-I41),\"\"))))","v":""},null,"uur         ",null,null,null,null,null,2017]
[null,null,"Totaal verbruikt",null,{"$f":"IF(E84<>\"\",E83+E84,\"\")","v":""},null,"uur",null,null,null,null,null,2018]
[null,null,null,null,null,null,null,null,null,null,null,null,2019]
[null,"Rekenkundige restlevensduur, in resterende vollasturen",null,null,{"$f":"IF(E85<>\"\",E80-E85,\"\")","v":""},null,"uur",null,null,null,null,null,2020]
[null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,null,null,null,null,null,null,null,null,2022]
[null,"Einde levensduur bij gelijkblijvend gebruik",null,null,{"$f":"IF(E87<>\"\",E10+(E87/E78),\"\")","v":""},null,{"$f":"IF(E90=\"\",\"\",IF(E90-E10<0,\"De levensduur van de takel is verstreken\",IF(AND(E90-E10>0,E90-E10<1),\"De levensduur van de takel is bijna verstreken\",IF(E90-E10>1,\"De levensduur van de takel is nog toereikend\",\"\"))))","v":""},null,null,null,null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E90=\"\",0,E90-E10)","v":0}]
[]
[null,"De levensduur van de takel is bijna verstreken"]
[null,"LET OP: De rekenkundige levensduur van uw takel is bijna verstreken. Deze dient op korte termijn gereviseerd"]
[null,"of vervangen te worden. Er kan een nauwkeurigere inschatting van het gebruik gemaakt worden. "]
[null,"Stuur uw gegevens naar ons door via onderstaande E-mail knop en wij zullen zo spoedig mogelijk contact met "]
[null,"u op nemen voor een vrijblijvende aanbieding."]
[]
[null,"De levensduur van de takel is verstreken"]
[null,"LET OP: De rekenkundige levensduur van uw takel is verstreken. Deze dient gereviseerd of vervangen te worden. "]
[null,"Stuur uw gegevens naar ons door via onderstaande E-mail knop en wij zullen zo spoedig mogelijk contact met "]
[null,"u op nemen voor een vrijblijvende aanbieding."]
[]
[null,"De eigenaar blijft verantwoordelijk voor de juistheid van de verstrekte gegegevens.",null,null,null,null,null,null,null,null,null,null,2025]
[null,null,null,null,null,null,null,null,null,null,null,null,2026]
[null,null,null,null,null,null,null,null,null,null,null,null,2027]
[null,null,null,null,null,null,null,null,null,null,null,null,2028]
[null,null,null,null,null,null,null,null,null,null,null,null,2029]
[null,null,null,null,null,null,null,null,null,null,null,null,2030]
[null,null,null,null,null,null,null,null,null,null,null,null,2031]