{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["PRODUCCION","FichasTecnicas","SEMITERMINADO","Resumen"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"PRODUCCION","index":0,"n_rows":67,"n_cols":21,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"REDSYSTEMCE, S.L.",null,null,null,null,null,"PROGRAMA DE PRODUCCIÓN",null,null,null,null,null,null,"Lotes iniciados del 12 de enero de 2015 al 14 de enero de 2015"]
[]
[null,"Fecha","OF/LOTE","Cliente","ResClav01","ResClav02","ResClav03","Secc","UnitPed","UnitFab","ResLong","TimeIP","TimeINE","TimeEP","TimeAct","Rend","HorIni","HorFin","FinTurno"]
["AQUÍ->",20150117,201500133,"TXX OILS","RE225 ","TU-80 ","000662","Extru",200,200,2100,0,0,1.8821582733812949,0.42,0.01,11.697841726618705,14,14]
["|"]
["|"]
["TITULOS","Fecha","OF/LOTE","Cliente","ResClav01","ResClav02","ResClav03","Secc","UnitPed","UnitFab","ResLong","TimeIP","TimeINE","TimeEP","TimeAct","Rend","HorIni","HorFin","FinTurno"]
["x","Semiterm",201500116,"TXX OILS","RE220 ","TU-12 ","003359","Bucle",450,455,500,0.2,{"$f":"1*0.2*K10*J10/1000000","v":4.5499999999999999E-2},{"$f":"+O10*(16-SUM($O$29:$O$32)-SUM($L$29:$L$32)-SUM($M$29:$M$32))/SUM($O$29:$O$32)","v":0.57255555555555593},{"$f":"1*(P10*J10*K10/10000)","v":1.1375},0.05,6,{"$f":"+Q10+SUM(L10:O10)","v":7.9555555555555557},14]
["x","Semiterm",201500119,"ALMACÉN","RE220 ","TU-12 ","003359","Bucle",3500,3505,500,0,{"$f":"1*0.2*K11*J11/1000000","v":0.35049999999999998},{"$f":"+O11*(16-SUM($O$29:$O$32)-SUM($L$29:$L$32)-SUM($M$29:$M$32))/SUM($O$29:$O$32)","v":4.4105653235653266},8.7624999999999993,0.05,{"$f":"+R10","v":7.9555555555555557},21.479120879120881,14]
["x","Semiterm",201500120,"ALMACÉN","RE220 ","TU-12 ","003359","Bucle",3500,5,500,0,{"$f":"1*0.2*K12*J12/1000000","v":5.0000000000000001E-4},6.2918192918192959E-3,1.2500000000000001E-2,0.05,{"$f":"+R11","v":21.479120879120881},21.4984126984127,22]
["x","Semiterm",201500121,"BHS Hoover","RE220 ","TU-12 ","003359","Bucle",120,130,500,0,{"$f":"1*0.2*K13*J13/1000000","v":1.2999999999999999E-2},0.1635873015873017,0.32500000000000001,0.05,{"$f":"+R12","v":21.4984126984127},22.000000000000004,22]
[null,20150112,201500122,"BHS Hoover","RE220 ","TU-80 ","000045","Bucle",1200,1250,1970,{"$f":"1*0.24","v":0.24},{"$f":"1*0.1*K14*J14/1000000","v":0.24625},{"$f":"+O14*(16-SUM($O$14:$O$17)-SUM($L$14:$L$17)-SUM($M$14:$M$17))/SUM($O$14:$O$17)","v":0.76296190573568579},6.1045375000000002,2.479E-2,6,{"$f":"+Q14+SUM(L14:O14)","v":13.353749405735686},14]
[null,20150112,201500123,"BHS Hoover","RE225 ","TU-80 ","000428","Bucle",825,830,493,{"$f":"1*0.45","v":0.45},{"$f":"1*0.1*K15*J15/1000000","v":4.0918999999999997E-2},{"$f":"+O15*(16-SUM($O$14:$O$17)-SUM($L$14:$L$17)-SUM($M$14:$M$17))/SUM($O$14:$O$17)","v":0.20456677165664738},1.6367600000000002,0.04,{"$f":"+S14","v":14},16.332245771656648,{"$f":"+Q15+8","v":22}]
[null,20150112,201500124,"ASOLATE, S.A.","RE225 ","TU-80 ","000428","Bucle",900,925,493,0,{"$f":"1*0.2*K16*J16/1000000","v":9.1205000000000008E-2},0.22798104070168532,1.8241000000000001,0.04,{"$f":"+R15","v":16.332245771656648},18.475531812358334,{"$f":"+S15","v":22}]
[null,20150112,201500125,"TVP France","RE225 ","TU-80 ","000428","Bucle",1800,1800,493,0,{"$f":"1*0.2*K17*J17/1000000","v":0.17748000000000003},0.44363878190598222,3.5495999999999999,0.04,{"$f":"+R16","v":18.475531812358334},22.646250594264316,{"$f":"+S16","v":22}]
[null,20150113,201500126,"BHS Hoover","RE220 ","TU-12 ","003359","Bucle",50,55,800,{"$f":"1*0.45","v":0.45},{"$f":"1*0.2*K18*J18/1000000","v":8.8000000000000005E-3},{"$f":"+O18*(16-SUM($O$18:$O$21)-SUM($L$18:$L$21)-SUM($M$18:$M$21))/SUM($O$18:$O$21)","v":4.8356851559651241E-2},0.17600000000000002,0.04,6,6.6831568515596516,14]
[null,20150113,201500127,"NOVANTIA, S.A.","RE225 ","TU-80 ","000012","Bucle",2450,2460,800,{"$f":"1*0.24","v":0.24},{"$f":"1*0.2*K19*J19/1000000","v":0.39360000000000001},{"$f":"+O19*(16-SUM($O$18:$O$21)-SUM($L$18:$L$21)-SUM($M$18:$M$21))/SUM($O$18:$O$21)","v":2.1628700879407643},7.8719999999999999,0.04,{"$f":"+R18","v":6.6831568515596516},17.351626939500417,14]
[null,20150113,201500128,"CALORIE IT, S.L.U.","RE225 ","TU-80 ","000012","Bucle",40,40,800,0,{"$f":"1*0.2*K20*J20/1000000","v":6.4000000000000003E-3},3.5168619316109991E-2,0.128,0.04,{"$f":"+R19","v":17.351626939500417},17.521195558816526,22]
[null,20150113,201500129,"CALORIE IT, S.L.U.","RE220 ","TU-80 ","000045","Bucle",650,660,1970,{"$f":"1*0.24","v":0.24},{"$f":"1*0.1*K21*J21/1000000","v":0.13002},0.88558864118347336,3.2231958000000001,2.479E-2,{"$f":"+R20","v":17.521195558816526},22,{"$f":"+S20","v":22}]
[null,20150114,201500130,"FUGOR, S.A.","RE225 ","TU-80 ","000662","Bucle",40,40,2100,{"$f":"1*0.45","v":0.45},{"$f":"1*0.2*K22*J22/1000000","v":1.6799999999999999E-2},{"$f":"+O22*(16-SUM($O$22:$O$28)-SUM($L$22:$L$28)-SUM($M$22:$M$28))/SUM($O$22:$O$28)","v":0.15180932800151334},0.208236,2.479E-2,6,{"$f":"+Q22+SUM(L22:O22)","v":6.8268453280015136},14]
[null,20150114,201500131,"ASTUR INDUSTRIAL, S.A.","RE225 ","TU-80 ","000662","Bucle",600,610,2100,0,{"$f":"1*0.2*K23*J23/1000000","v":0.25619999999999998},{"$f":"+O23*(16-SUM($O$22:$O$28)-SUM($L$22:$L$28)-SUM($M$22:$M$28))/SUM($O$22:$O$28)","v":2.3150922520230783},3.1755990000000001,2.479E-2,{"$f":"+R22","v":6.8268453280015136},{"$f":"+Q23+SUM(L23:O23)","v":12.573736580024592},14]
[null,20150114,201500123,"BHS Hoover","RE225 ","TU-80 ","000428","Bucle",825,840,493,0,{"$f":"1*0.1*K24*J24/1000000","v":4.1411999999999997E-2},{"$f":"+O24*(16-SUM($O$14:$O$17)-SUM($L$14:$L$17)-SUM($M$14:$M$17))/SUM($O$14:$O$17)","v":0.20703143155612502},1.65648,0.04,12.573736580024592,{"$f":"+Q24+SUM(L24:O24)","v":14.478660011580716},14]
[null,20150114,201500132,"TCC SHIPS, CORP.","RE225 ","TU-80 ","000662","Bucle",100,110,2100,0,{"$f":"1*0.2*K25*J25/1000000","v":4.6199999999999998E-2},{"$f":"+O25*(16-SUM($O$22:$O$28)-SUM($L$22:$L$28)-SUM($M$22:$M$28))/SUM($O$22:$O$28)","v":0.41747565200416165},0.57264899999999996,2.479E-2,14.478660011580716,15.514984663584878,22]
[null,20150114,201500133,"TXX OILS","RE225 ","TU-80 ","000662","Bucle",200,210,2100,0,{"$f":"1*0.2*K26*J26/1000000","v":8.8200000000000001E-2},{"$f":"+O26*(16-SUM($O$22:$O$28)-SUM($L$22:$L$28)-SUM($M$22:$M$28))/SUM($O$22:$O$28)","v":0.79699897200794478},1.0932389999999998,2.479E-2,15.514984663584878,17.493422635592822,22]
[null,20150114,201500134,"BHS Hoover","RE220 ","TU-12 ","003359","Bucle",900,910,800,0.24,{"$f":"1*0.2*K27*J27/1000000","v":0.14560000000000001},{"$f":"+O27*(16-SUM($O$22:$O$28)-SUM($L$22:$L$28)-SUM($M$22:$M$28))/SUM($O$22:$O$28)","v":1.3156808426797824},1.8047120000000003,2.479E-2,17.493422635592822,{"$f":"+Q27+SUM(L27:O27)","v":20.999415478272603},22]
[null,20150114,"BLANK","BLANK","BLANK","BLANK","BLANK","Bucle",0,0,0,0,0,{"$f":"16-SUM(L22:O27)","v":1.0005845217273919},0,0,20.999415478272603,22,{"$f":"+S27","v":22}]
[null,20150112,201500116,"TXX OILS","RE220 ","TU-12 ","003359","Relle",450,455,500,0.2,{"$f":"1*0.2*K29*J29/1000000","v":4.5499999999999999E-2},{"$f":"+O29*(16-SUM($O$29:$O$32)-SUM($L$29:$L$32)-SUM($M$29:$M$32))/SUM($O$29:$O$32)","v":0.57255555555555593},{"$f":"1*(P29*J29*K29/10000)","v":1.1375},0.05,6,7.9555555555555557,14]
[null,20150112,201500119,"ALMACÉN","RE220 ","TU-12 ","003359","Relle",3500,3505,500,0,{"$f":"1*0.2*K30*J30/1000000","v":0.35049999999999998},{"$f":"+O30*(16-SUM($O$29:$O$32)-SUM($L$29:$L$32)-SUM($M$29:$M$32))/SUM($O$29:$O$32)","v":4.4105653235653266},8.7624999999999993,0.05,{"$f":"+R29","v":7.9555555555555557},21.479120879120881,14]
[null,20150112,201500120,"ALMACÉN","RE220 ","TU-12 ","003359","Relle",3500,{"$f":"3510-J30","v":5},500,0,{"$f":"1*0.2*K31*J31/1000000","v":5.0000000000000001E-4},6.2918192918192959E-3,1.2500000000000001E-2,0.05,{"$f":"+R30","v":21.479120879120881},{"$f":"+Q31+SUM(L31:O31)","v":21.4984126984127},22]
[null,20150112,201500121,"BHS Hoover","RE220 ","TU-12 ","003359","Relle",120,130,500,0,{"$f":"1*0.2*K32*J32/1000000","v":1.2999999999999999E-2},0.1635873015873017,0.32500000000000001,0.05,{"$f":"+R31","v":21.4984126984127},22.000000000000004,22]
[null,20150113,201500123,"BHS Hoover","RE225 ","TU-80 ","000428","Relle",825,826,493,{"$f":"1*0.45","v":0.45},{"$f":"1*0.1*K33*J33/1000000","v":4.0721800000000002E-2},{"$f":"+O33*(16-SUM($O$33:$O$36)-SUM($L$33:$L$36)-SUM($M$33:$M$36))/SUM($O$33:$O$36)","v":0.14708035173083694},2.4433079999999996,0.06,6,9.0811101517308366,{"$f":"+Q33+8","v":14}]
[null,20150113,201500124,"ASOLATE, S.A.","RE225 ","TU-80 ","000428","Relle",900,915,493,0,{"$f":"1*0.2*K34*J34/1000000","v":9.0219000000000021E-2},{"$f":"+O34*(16-SUM($O$33:$O$36)-SUM($L$33:$L$36)-SUM($M$33:$M$36))/SUM($O$33:$O$36)","v":0.16292799253476492},2.7065700000000001,0.06,{"$f":"+R33","v":9.0811101517308366},12.040827144265602,{"$f":"+S33","v":14}]
[null,20150113,201500125,"TVP France","RE225 ","TU-80 ","000428","Relle",1800,1800,493,0,{"$f":"1*0.2*K35*J35/1000000","v":0.17748000000000003},{"$f":"+O35*(16-SUM($O$33:$O$36)-SUM($L$33:$L$36)-SUM($M$33:$M$36))/SUM($O$33:$O$36)","v":0.32051408367494738},5.3243999999999998,0.06,{"$f":"+R34","v":12.040827144265602},17.863221227940549,22]
[null,20150113,201500122,"BHS Hoover","RE220 ","TU-80 ","000045","Relle",1200,370,1970,0.2,{"$f":"1*0.1*K36*J36/1000000","v":7.2889999999999996E-2},0.21938877205945187,3.6444999999999999,0.05,{"$f":"+R35","v":17.863221227940549},22,22]
[null,20150114,201500122,"BHS Hoover","RE220 ","TU-80 ","000045","Relle",1200,{"$f":"1210-J36","v":840},1970,0.2,{"$f":"1*0.1*K37*J37/1000000","v":0.16547999999999999},{"$f":"+O37*(16-SUM($O$37:$O$38)-SUM($L$37:$L$38)-SUM($M$37:$M$38))/SUM($O$37:$O$38)","v":0.40852000000000083},8.2739999999999991,0.05,6,15.048,14]
[null,20150114,201500129,"CALORIE IT, S.L.U.","RE220 ","TU-80 ","000045","Relle",650,660,1970,0,{"$f":"1*0.1*K38*J38/1000000","v":0.13002},{"$f":"+O38*(16-SUM($O$37:$O$38)-SUM($L$37:$L$38)-SUM($M$37:$M$38))/SUM($O$37:$O$38)","v":0.32098000000000071},6.5010000000000003,0.05,{"$f":"+R37","v":15.048},22,22]
[null,20150115,201500126,"BHS Hoover","RE220 ","TU-12 ","003359","Relle",50,52,800,0.2,{"$f":"1*0.2*K39*J39/1000000","v":8.3199999999999993E-3},{"$f":"+O39*(16-SUM($O$39:$O$42)-SUM($L$39:$L$42)-SUM($M$39:$M$42))/SUM($O$39:$O$42)","v":2.6612667974313758E-2},0.24959999999999999,0.06,6,6.4845326679743138,14]
[null,20150115,201500134,"BHS Hoover","RE220 ","TU-12 ","003359","Relle",900,910,800,0,0.1,{"$f":"+O40*(16-SUM($O$39:$O$42)-SUM($L$39:$L$42)-SUM($M$39:$M$42))/SUM($O$39:$O$42)","v":0.46572168955049081},4.3680000000000003,0.06,{"$f":"+R39","v":6.4845326679743138},11.418254357524805,{"$f":"+S39","v":14}]
[null,20150115,201500123,"BHS Hoover","RE225 ","TU-80 ","000428","Relle",825,835,493,{"$f":"1*0.45","v":0.45},{"$f":"1*0.1*K41*J41/1000000","v":4.1165500000000001E-2},{"$f":"+O41*(16-SUM($O$39:$O$42)-SUM($L$39:$L$42)-SUM($M$39:$M$42))/SUM($O$39:$O$42)","v":0.26334706334053193},2.4699299999999997,0.06,{"$f":"+R40","v":11.418254357524805},{"$f":"+Q41+SUM(L41:O41)","v":14.642696920865337},{"$f":"+Q41+8","v":19.418254357524805}]
[null,20150115,201500127,"NOVANTIA, S.A.","RE225 ","TU-80 ","000012","Relle",2450,1635,800,0,0.12,0.69730307913466338,6.54,0.05,{"$f":"+R41","v":14.642696920865337},22,22]
[null,20150116,201500127,"NOVANTIA, S.A.","RE225 ","TU-80 ","000012","Relle",2450,815,800,0.45,{"$f":"1*0.2*K43*J43/1000000","v":0.13039999999999999},{"$f":"+O43*(16-SUM($O$43:$O$48)-SUM($L$43:$L$48)-SUM($M$43:$M$48))/SUM($O$43:$O$48)","v":0.40896293798013872},3.26,0.05,6,10.249362937980138,14]
[null,20150116,201500128,"CALORIE IT, S.L.U.","RE225 ","TU-80 ","000012","Relle",40,40,800,0,6.4000000000000003E-3,{"$f":"+O44*(16-SUM($O$43:$O$48)-SUM($L$43:$L$48)-SUM($M$43:$M$48))/SUM($O$43:$O$48)","v":2.0071800637062025E-2},0.16,0.05,{"$f":"+R43","v":10.249362937980138},10.435834738617199,14]
[null,20150116,201500130,"FUGOR, S.A.","RE225 ","TU-80 ","000662","Relle",40,40,2100,0,1.6799999999999999E-2,5.2688476672287821E-2,0.42,0.05,{"$f":"+R44","v":10.435834738617199},10.925323215289486,14]
[null,20150116,201500131,"ASTUR INDUSTRIAL, S.A.","RE225 ","TU-80 ","000662","Relle",600,600,2100,0,0.252,0.7903271500843172,6.3,0.05,{"$f":"+R45","v":10.925323215289486},18.267650365373804,22]
[null,20150116,201500132,"TCC SHIPS, CORP.","RE225 ","TU-80 ","000662","Relle",100,105,2100,0,4.41E-2,0.13830725126475552,1.1025,0.05,{"$f":"+R46","v":18.267650365373804},19.552557616638559,22]
[null,20150116,201500133,"TXX OILS","RE225 ","TU-80 ","000662","Relle",200,200,2100,0,8.4000000000000005E-2,0.2634423833614391,2.1,0.05,{"$f":"+R47","v":19.552557616638559},22,22]
[null,20150112,201500116,"TXX OILS","RE220 ","TU-12 ","003359","Extru",450,455,500,0,{"$f":"1*0*K49*J49/1000000","v":0},{"$f":"+O49*(16-SUM($O$49:$O$50)-SUM($L$49:$L$50)-SUM($M$49:$M$50))/SUM($O$49:$O$50)","v":1.6132079646017701},0.22750000000000001,0.01,{"$f":"+R29","v":7.9555555555555557},{"$f":"+Q49+O49","v":8.1830555555555549},14,null,{"$f":"+R49-Q49","v":0.22749999999999915}]
[null,20150112,201500119,"ALMACÉN","RE220 ","TU-12 ","003359","Extru",3500,3500,500,0,0,{"$f":"+O50*(16-SUM($O$49:$O$50)-SUM($L$49:$L$50)-SUM($M$49:$M$50))/SUM($O$49:$O$50)","v":12.409292035398229},1.75,0.01,{"$f":"+R30","v":21.479120879120881},23.229120879120881,22]
[null,20150113,201500121,"BHS Hoover","RE220 ","TU-12 ","003359","Extru",120,130,500,0,0,{"$f":"+O51*(16-SUM($O$51:$O$54)-SUM($L$51:$L$54)-SUM($M$51:$M$54))/SUM($O$51:$O$54)","v":0.51155707831918096},6.5000000000000002E-2,0.01,{"$f":"+Q33","v":6},6.0650000000000004,14]
[null,20150113,201500123,"BHS Hoover","RE225 ","TU-80 ","000428","Extru",825,825,493,0,0,{"$f":"+O52*(16-SUM($O$51:$O$54)-SUM($L$51:$L$54)-SUM($M$51:$M$54))/SUM($O$51:$O$54)","v":3.2009700412210593},0.406725,0.01,{"$f":"+R33","v":9.0811101517308366},9.4878351517308364,14]
[null,20150113,201500124,"ASOLATE, S.A.","RE225 ","TU-80 ","000428","Extru",900,902,493,0,0,3.4997272450683576,0.44468599999999997,0.01,{"$f":"+R34","v":12.040827144265602},12.485513144265603,14]
[null,20150113,201500125,"TVP France","RE225 ","TU-80 ","000428","Extru",1800,1800,493,0,0,6.9839346353914022,0.88739999999999997,0.01,{"$f":"+R35","v":17.863221227940549},18.750621227940549,22]
[null,20150114,201500122,"BHS Hoover","RE220 ","TU-80 ","000045","Extru",1200,600,1970,0,0,{"$f":"+O55*(16-SUM($O$55:$O$56)-SUM($L$55:$L$56)-SUM($M$55:$M$56))/SUM($O$55:$O$56)","v":6.8180000000000005},1.1819999999999999,0.01,{"$f":"+Q37","v":6},7.1820000000000004,14]
[null,20150114,201500122,"BHS Hoover","RE220 ","TU-80 ","000045","Extru",1200,600,1970,0,0,{"$f":"+O56*(16-SUM($O$55:$O$56)-SUM($L$55:$L$56)-SUM($M$55:$M$56))/SUM($O$55:$O$56)","v":6.8180000000000005},1.1819999999999999,0.01,{"$f":"+R37","v":15.048},16.23,22]
[null,20150115,201500129,"CALORIE IT, S.L.U.","RE220 ","TU-80 ","000045","Extru",650,655,1970,0,0,{"$f":"+O57*(16-SUM($O$57:$O$59)-SUM($L$57:$L$59)-SUM($M$57:$M$59))/SUM($O$57:$O$59)","v":8.7476225294761143},1.2903500000000001,0.01,6,7.2903500000000001,14]
[null,20150115,201500126,"BHS Hoover","RE220 ","TU-12 ","003359","Extru",50,48,800,0,0,{"$f":"+O58*(16-SUM($O$57:$O$59)-SUM($L$57:$L$59)-SUM($M$57:$M$59))/SUM($O$57:$O$59)","v":0.26032371459827391},3.8399999999999997E-2,0.01,{"$f":"+R39","v":6.4845326679743138},6.522932667974314,14]
[null,20150115,201500134,"BHS Hoover","RE220 ","TU-12 ","003359","Extru",900,910,800,0,0,{"$f":"+O59*(16-SUM($O$57:$O$59)-SUM($L$57:$L$59)-SUM($M$57:$M$59))/SUM($O$57:$O$59)","v":4.9353037559256103},0.72799999999999998,0.01,{"$f":"+R40","v":11.418254357524805},{"$f":"+Q59+SUM(L59:O59)","v":17.081558113450416},22]
[null,20150116,201500127,"NOVANTIA, S.A.","RE225 ","TU-80 ","000012","Extru",2450,2450,800,0,0,{"$f":"+O60*(16-SUM($O$60:$O$64)-SUM($L$60:$L$64)-SUM($M$60:$M$64))/SUM($O$60:$O$64)","v":8.8344747159394039},1.96,0.01,6,16.794474715939405,14]
[null,20150116,201500128,"CALORIE IT, S.L.U.","RE225 ","TU-80 ","000012","Extru",40,40,800,0,0,{"$f":"+O61*(16-SUM($O$60:$O$64)-SUM($L$60:$L$64)-SUM($M$60:$M$64))/SUM($O$60:$O$64)","v":0.14423632189288821},3.2000000000000001E-2,0.01,{"$f":"+R60","v":16.794474715939405},16.970711037832292,22]
[null,20150116,201500123,"BHS Hoover","RE225 ","TU-80 ","000428","Extru",825,830,493,0,0,{"$f":"+O62*(16-SUM($O$60:$O$64)-SUM($L$60:$L$64)-SUM($M$60:$M$64))/SUM($O$60:$O$64)","v":1.844376892354717},0.40919000000000005,0.01,{"$f":"+R61","v":16.970711037832292},{"$f":"+Q62+O62","v":17.37990103783229},22]
[null,20150116,201500130,"FUGOR, S.A.","RE225 ","TU-80 ","000662","Extru",40,40,2100,0,0,{"$f":"+O63*(16-SUM($O$60:$O$64)-SUM($L$60:$L$64)-SUM($M$60:$M$64))/SUM($O$60:$O$64)","v":0.37862034496883157},8.4000000000000005E-2,0.01,{"$f":"+R61","v":16.970711037832292},17.433331382801125,22]
[null,20150116,201500131,"ASTUR INDUSTRIAL, S.A.","RE225 ","TU-80 ","000662","Extru",600,200,2100,0,0,{"$f":"+O64*(16-SUM($O$60:$O$64)-SUM($L$60:$L$64)-SUM($M$60:$M$64))/SUM($O$60:$O$64)","v":1.893101724844158},0.42,0.01,{"$f":"+R63","v":17.433331382801125},{"$f":"+Q64+SUM(L64:O64)","v":19.746433107645284},22]
[null,20150117,201500131,"ASTUR INDUSTRIAL, S.A.","RE225 ","TU-80 ","000662","Extru",600,395,2100,0,0,{"$f":"+O65*(8-SUM($O$65:$O$67)-SUM($L$65:$L$67)-SUM($M$65:$M$67))/SUM($O$65:$O$67)","v":3.7172625899280574},0.82950000000000002,0.01,6,{"$f":"+Q65+SUM(L65:O65)","v":10.546762589928058},14]
[null,20150117,201500132,"TCC SHIPS, CORP.","RE225 ","TU-80 ","000662","Extru",100,100,2100,0,0,{"$f":"+O66*(8-SUM($O$65:$O$67)-SUM($L$65:$L$67)-SUM($M$65:$M$67))/SUM($O$65:$O$67)","v":0.94107913669064747},0.21,0.01,{"$f":"+R65","v":10.546762589928058},11.697841726618705,14]
[null,20150117,201500133,"TXX OILS","RE225 ","TU-80 ","000662","Extru",200,200,2100,0,0,1.8821582733812949,0.42,0.01,{"$f":"+R66","v":11.697841726618705},14,14]

{"sheet":"FichasTecnicas","index":1,"n_rows":198,"n_cols":44,"rows_kept":198,"cut":false,"hidden":false,"merged":[]}
[]
[null,"REDSYSTEMCE, S.L."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Identificador de materiales"]
[{"$f":"TODAY()","v":"2015-01-29"},null,null,null,"Lote","Consumo de materiales"]
[null,null,null,null,{"$f":"+PRODUCCION!C6","v":201500133},{"$f":"+PRODUCCION!G6","v":"000662"},{"$f":"+PRODUCCION!J6","v":200},null,{"$f":"+PRODUCCION!H6","v":"Extru"},null,null,null,null,null,null,null,null,"Fase","Bucle","Bucle","Bucle","Bucle","Bucle","Bucle","Bucle","Bucle","Bucle","Bucle","Relle","Relle","Bucle/Relle","Bucle/Relle","Extru","Extru","Relle","Relle","Bucle","Bucle","Bucle","Bucle","Bucle","Bucle","Bucle","Bucle"]
["Datos",null,null,null,null,"unidades","euros/unid",null,"Buscador",null,null,null,null,null,null,null,null,null,"Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste"]
["x","ResClav02","ResClav03","Linea","Material","Cantidad","Importe",null,"ResClav01","ResClav02","ResClav03","Linea","Material","Cantidad","Importe",null,"Consumo","Coste","HILO   80/20  0,25  ","HILO   80/20  0,25  ","HILO   80/20  0,33  ","HILO   80/20  0,33  ","HILO   80/20  0,35  ","HILO   80/20  0,35  ","HILO   80/20  0,40  ","HILO   80/20  0,40  ","HILO   80/20  0,55  ","HILO   80/20  0,55  ","MAGNES ALFA 4B","MAGNES ALFA 4B","TAPON PLÁSTICO 9,5    6666","TAPON PLÁSTICO 9,5    6666","TFM    444 Z33","TFM    444 Z33","TUBO 333 9,5/45","TUBO 333 9,5/45","VARILLA A 3/65   11","VARILLA A 3/65   11","VARILLA A 3/65   22","VARILLA A 3/65   22","VARILLA B 3/65   11","VARILLA B 3/65   11","VARILLA B 3/65   22","VARILLA B 3/65   22"]
["RE225","TU80 ","000012",2,"HILO   80/20  0,33  ",7.9,1.7000000000000001E-2,null,{"$f":"IF($C8=$F$5,A8,)","v":0},{"$f":"IF($C8=$F$5,B8,)","v":0},{"$f":"IF($C8=$F$5,C8,)","v":0},{"$f":"IF($C8=$F$5,D8,)","v":0},{"$f":"IF($C8=$F$5,E8,)","v":0},{"$f":"IF($C8=$F$5,F8,)","v":0},{"$f":"IF($C8=$F$5,G8,)","v":0},null,{"$f":"+N8*$G$5","v":0},{"$f":"+Q8*O8","v":0},{"$f":"+IF(AND(S$5=$I$5,S$7=$E8),$Q8,0)","v":0},{"$f":"+IF(AND(T$5=$I$5,T$7=$E8),$R8,0)","v":0},{"$f":"+IF(AND(U$5=$I$5,U$7=$E8),$Q8,0)","v":0},{"$f":"+IF(AND(V$5=$I$5,V$7=$E8),$R8,0)","v":0},0,{"$f":"+IF(AND(X$5=$I$5,X$7=$E8),$R8,0)","v":0},0,{"$f":"+IF(AND(Z$5=$I$5,Z$7=$E8),$R8,0)","v":0},0,{"$f":"+IF(AND(AB$5=$I$5,AB$7=$E8),$R8,0)","v":0},0,{"$f":"+IF(AND(AD$5=$I$5,AD$7=$E8),$R8,0)","v":0},{"$f":"+IF(AND($I$5<>\"Extru\",AE$7=$E8),$Q8,0)","v":0},{"$f":"+IF(AND($I$5<>\"Extru\",AF$7=$E8),$R8,0)","v":0},0,{"$f":"+IF(AND(AH$5=$I$5,AH$7=$E8),$R8,0)","v":0},0,{"$f":"+IF(AND(AJ$5=$I$5,AJ$7=$E8),$R8,0)","v":0},{"$f":"+IF(AND(AK$5=$I$5,AK$7=$E8),$Q8,0)","v":0},{"$f":"+IF(AND(AL$5=$I$5,AL$7=$E8),$R8,0)","v":0},0,{"$f":"+IF(AND(AN$5=$I$5,AN$7=$E8),$R8,0)","v":0},0,{"$f":"+IF(AND(AP$5=$I$5,AP$7=$E8),$R8,0)","v":0},0,{"$f":"+IF(AND(AR$5=$I$5,AR$7=$E8),$R8,0)","v":0}]
["RE225","TU80 ","000012",17,"MAGNES ALFA 4B",0.6,0.55000000000000004,null,0,0,0,0,0,0,0,null,0,0,{"$f":"+IF(AND(S$5=$I$5,S$7=$E9),$Q9,0)","v":0},{"$f":"+IF(AND(T$5=$I$5,T$7=$E9),$R9,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(AND($I$5<>\"Extru\",AE$7=$E9),$Q9,0)","v":0},{"$f":"+IF(AND($I$5<>\"Extru\",AF$7=$E9),$R9,0)","v":0},0,{"$f":"+IF(AND(AH$5=$I$5,AH$7=$E9),$R9,0)","v":0},0,{"$f":"+IF(AND(AJ$5=$I$5,AJ$7=$E9),$R9,0)","v":0},0,{"$f":"+IF(AND(AL$5=$I$5,AL$7=$E9),$R9,0)","v":0},0,{"$f":"+IF(AND(AN$5=$I$5,AN$7=$E9),$R9,0)","v":0},0,{"$f":"+IF(AND(AP$5=$I$5,AP$7=$E9),$R9,0)","v":0},0,{"$f":"+IF(AND(AR$5=$I$5,AR$7=$E9),$R9,0)","v":0}]
["RE225","TU80 ","000012",7,"TAPON PLÁSTICO 9,5    6666",1,4.0000000000000001E-3,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000012",9,"TFM    444 Z33",3,0.04,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000012",1,"TUBO 333 9,5/45",1.4590000000000001,0.55999999999999994,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000012",14,"VARILLA A 3/65   22",1,0.03,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000012",15,"VARILLA B 3/65   22",1,3.1904761904761901E-2,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE220 ","TU80 ","000045",15,"HILO   80/20  0,55  ",7.5,0.06,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(AND(AB$5=$I$5,AB$7=$E15),$R15,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE220 ","TU80 ","000045",22,"MAGNES ALFA 4B",0.5,0.55000000000000004,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE220 ","TU80 ","000045",7,"TAPON PLÁSTICO 9,5    6666",1,4.0000000000000001E-3,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE220 ","TU80 ","000045",9,"TFM    444 Z33",3,0.04,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE220 ","TU80 ","000045",1,"TUBO 333 9,5/45",1.73,0.55999999999999994,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE220 ","TU80 ","000045",19,"VARILLA A 3/65   11",1,0.06,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE220 ","TU80 ","000045",20,"VARILLA B 3/65   11",1,0.06,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000428",2,"HILO   80/20  0,40  ",6.4,0.03,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000428",20,"MAGNES ALFA 4B",0.6,0.55000000000000004,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(AND(AI$5=$I$5,AI$7=$E23),$Q23,0)","v":0},0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000428",9,"TAPON PLÁSTICO 9,5    6666",1,4.0000000000000001E-3,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000428",11,"TFM    444 Z33",3,0.04,null,0,0,0,0,0,0,0,null,0,0,{"$f":"+IF(AND(S$5=$I$5,S$7=$E25),$Q25,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000428",1,"TUBO 333 9,5/45",1.1879999999999999,0.55999999999999994,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000428",17,"VARILLA A 3/65   11",1,0.06,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000428",18,"VARILLA B 3/65   11",1,0.06,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000662",2,"HILO   80/20  0,35  ",7.1,0.02,null,"RE225","TU80 ","000662",2,"HILO   80/20  0,35  ",7.1,0.02,null,{"$f":"+N29*$G$5","v":1420},{"$f":"+Q29*O29","v":28.400000000000002},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000662",14,"MAGNES ALFA 4B",0.5,0.55000000000000004,null,"RE225","TU80 ","000662",14,"MAGNES ALFA 4B",0.5,0.55000000000000004,null,100,55.000000000000007,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000662",7,"TAPON PLÁSTICO 9,5    6666",1,4.0000000000000001E-3,null,"RE225","TU80 ","000662",7,"TAPON PLÁSTICO 9,5    6666",1,4.0000000000000001E-3,null,200,0.8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000662",9,"TFM    444 Z33",3,0.04,null,"RE225","TU80 ","000662",9,"TFM    444 Z33",3,0.04,null,600,24,0,0,0,0,0,0,0,0,0,0,0,0,0,0,600,24,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000662",1,"TUBO 333 9,5/45",0.91600000000000004,0.55999999999999994,null,"RE225","TU80 ","000662",1,"TUBO 333 9,5/45",0.91600000000000004,0.55999999999999994,null,183.20000000000002,102.592,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000662",11,"VARILLA A 3/65   22",1,{"$f":"+IF(OR(E5=201500133,E5=201500132),0.0309803921568627,IF(E5=201500131,0.0303294760527162,0.03))","v":3.0980392156862699E-2},null,"RE225","TU80 ","000662",11,"VARILLA A 3/65   22",1,3.0980392156862699E-2,null,200,6.1960784313725394,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE225","TU80 ","000662",12,"VARILLA B 3/65   22",1,3.1904761904761901E-2,null,"RE225","TU80 ","000662",12,"VARILLA B 3/65   22",1,3.1904761904761901E-2,null,200,6.3809523809523805,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE220 ","TU18","003359",2,"HILO   80/20  0,25  ",4.5,0.01,null,0,0,0,0,0,0,0,null,{"$f":"+N36*$G$5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE220 ","TU18","003359",30,"MAGNES ALFA 4B",0.4,0.55000000000000004,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE220 ","TU18","003359",7,"TAPON PLÁSTICO 9,5    6666",1,4.0000000000000001E-3,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE220 ","TU18","003359",9,"TFM    444 Z33",3,0.04,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(AND(AI$5=$I$5,AI$7=$E39),$Q39,0)","v":0},0,0,0,0,0,0,0,0,0]
["RE220 ","TU18","003359",1,"TUBO 333 9,5/45",0.64500000000000002,0.55999999999999994,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE220 ","TU18","003359",27,"VARILLA A 3/65   22",1,{"$f":"+IF(E5=201500134,0.0309803921568627,0.03)","v":0.03},null,0,0,0,0,0,0,0,null,0,0,{"$f":"+IF(AND(S$5=$I$5,S$7=$E41),$Q41,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["RE220 ","TU18","003359",28,"VARILLA B 3/65   22",1,3.1904761904761901E-2,null,0,0,0,0,0,0,0,null,{"$f":"+N42*$G$5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+T43+V43+X43+Z43+AB43+AD43+AF43+AH43+AJ43+AL43+AN43+AP43+AR43","v":24},{"$f":"+SUM(S8:S42)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,600,24,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"|"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"|","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coste","HILO   80/20  0,25  ","HILO   80/20  0,25  ","HILO   80/20  0,33  ","HILO   80/20  0,33  ","HILO   80/20  0,35  ","HILO   80/20  0,35  ","HILO   80/20  0,40  ","HILO   80/20  0,40  ","HILO   80/20  0,55  ","HILO   80/20  0,55  ","MAGNES ALFA 4B","MAGNES ALFA 4B","TAPON PLÁSTICO 9,5    6666","TAPON PLÁSTICO 9,5    6666","TFM    444 Z33","TFM    444 Z33","TUBO 333 9,5/45","TUBO 333 9,5/45","VARILLA A 3/65   11","VARILLA A 3/65   11","VARILLA A 3/65   22","VARILLA A 3/65   22","VARILLA B 3/65   11","VARILLA B 3/65   11","VARILLA B 3/65   22","VARILLA B 3/65   22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semiterm",201500116,50.461666666666666,2047.5,20.475000000000001,0,0,0,0,0,0,0,0,0,0,455,1.82,0,0,0,0,0,0,455,13.65,0,0,455,14.516666666666666]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semiterm",201500119,388.72119047619043,15772.5,157.72499999999999,0,0,0,0,0,0,0,0,0,0,3505,14.02,0,0,0,0,0,0,3505,105.14999999999999,0,0,3505,111.82619047619046]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semiterm",201500120,0.55452380952380953,22.5,0.22500000000000001,0,0,0,0,0,0,0,0,0,0,5,0.02,0,0,0,0,0,0,5,0.15,0,0,5,0.15952380952380951]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semiterm",201500121,14.417619047619048,585,5.8500000000000005,0,0,0,0,0,0,0,0,0,0,130,0.52,0,0,0,0,0,0,130,3.9,0,0,130,4.1476190476190471]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bucle",201500122,717.5,0,0,0,0,0,0,0,0,9375,562.5,0,0,1250,5,0,0,0,0,1250,75,0,0,1250,75,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bucle",201500123,262.27999999999997,0,0,0,0,0,0,5312,159.35999999999999,0,0,0,0,830,3.3200000000000003,0,0,0,0,830,49.8,0,0,830,49.8,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bucle",201500124,292.29999999999995,0,0,0,0,0,0,5920,177.6,0,0,0,0,925,3.7,0,0,0,0,925,55.5,0,0,925,55.5,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bucle",201500125,568.79999999999995,0,0,0,0,0,0,11520,345.59999999999997,0,0,0,0,1800,7.2,0,0,0,0,1800,108,0,0,1800,108,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bucle",201500126,6.0997619047619054,247.5,2.4750000000000001,0,0,0,0,0,0,0,0,0,0,55,0.22,0,0,0,0,0,0,55,1.65,0,0,55,1.7547619047619045]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bucle",201500127,492.5037142857143,0,0,19434,330.37800000000004,0,0,0,0,0,0,0,0,2460,9.84,0,0,0,0,0,0,2460,73.8,0,0,2460,78.48571428571428]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bucle",201500128,8.0081904761904781,0,0,316,5.3720000000000008,0,0,0,0,0,0,0,0,40,0.16,0,0,0,0,0,0,40,1.2,0,0,40,1.2761904761904761]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bucle",201500129,378.84000000000003,0,0,0,0,0,0,0,0,4950,297,0,0,660,2.64,0,0,0,0,660,39.6,0,0,660,39.6,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bucle",201500130,8.3161904761904761,0,0,0,0,284,5.68,0,0,0,0,0,0,40,0.16,0,0,0,0,0,0,40,1.2,0,0,40,1.2761904761904761]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bucle",201500131,127.02288515406165,0,0,0,0,4331,86.62,0,0,0,0,0,0,610,2.44,0,0,0,0,0,0,610,18.500980392156883,0,0,610,19.461904761904758]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bucle",201500123,265.44,0,0,0,0,0,0,5376,161.28,0,0,0,0,840,3.36,0,0,0,0,840,50.4,0,0,840,50.4,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bucle",201500132,22.977366946778709,0,0,0,0,781,15.620000000000001,0,0,0,0,0,0,110,0.44,0,0,0,0,0,0,110,3.407843137254897,0,0,110,3.509523809523809]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bucle",201500133,43.865882352941171,0,0,0,0,1491,29.82,0,0,0,0,0,0,210,0.84,0,0,0,0,0,0,210,6.5058823529411667,0,0,210,6.6999999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bucle",201500134,101.81549019607839,4095,40.950000000000003,0,0,0,0,0,0,0,0,0,0,910,3.64,0,0,0,0,0,0,910,28.192156862745055,0,0,910,29.033333333333331]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLANK",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500116,266.26600000000002,0,0,0,0,0,0,0,0,0,0,182,100.10000000000001,455,1.82,0,0,293.47500000000002,164.346,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500119,2051.1259999999997,0,0,0,0,0,0,0,0,0,0,1402,771.1,3505,14.02,0,0,2260.7249999999999,1266.0059999999999,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500120,2.9260000000000002,0,0,0,0,0,0,0,0,0,0,2,1.1000000000000001,5,0.02,0,0,3.2250000000000001,1.8059999999999998,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500121,76.076000000000008,0,0,0,0,0,0,0,0,0,0,52,28.6,130,0.52,0,0,83.850000000000009,46.956000000000003,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500123,825.40527999999995,0,0,0,0,0,0,0,0,0,0,495.59999999999997,272.58,826,3.3040000000000003,0,0,981.28800000000001,549.52127999999993,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500124,914.34120000000007,0,0,0,0,0,0,0,0,0,0,549,301.95000000000005,915,3.66,0,0,1087.02,608.73119999999994,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500125,1798.704,0,0,0,0,0,0,0,0,0,0,1080,594,1800,7.2,0,0,2138.4,1197.5039999999999,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500122,461.68599999999998,0,0,0,0,0,0,0,0,0,0,185,101.75000000000001,370,1.48,0,0,640.1,358.45599999999996,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500122,1048.152,0,0,0,0,0,0,0,0,0,0,420,231.00000000000003,840,3.36,0,0,1453.2,813.79199999999992,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500129,823.54799999999989,0,0,0,0,0,0,0,0,0,0,330,181.50000000000003,660,2.64,0,0,1141.8,639.4079999999999,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500126,30.430399999999999,0,0,0,0,0,0,0,0,0,0,20.8,11.440000000000001,52,0.20800000000000002,0,0,33.54,18.782399999999999,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500134,532.53200000000004,0,0,0,0,0,0,0,0,0,0,364,200.20000000000002,910,3.64,0,0,586.95000000000005,328.69200000000001,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500123,834.39879999999982,0,0,0,0,0,0,0,0,0,0,501,275.55,835,3.34,0,0,991.9799999999999,555.50879999999984,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500127,1881.9504000000002,0,0,0,0,0,0,0,0,0,0,981,539.55000000000007,1635,6.54,0,0,2385.4650000000001,1335.8604,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500127,938.09759999999994,0,0,0,0,0,0,0,0,0,0,489,268.95000000000005,815,3.2600000000000002,0,0,1189.085,665.88759999999991,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500128,46.041599999999995,0,0,0,0,0,0,0,0,0,0,24,13.200000000000001,40,0.16,0,0,58.36,32.681599999999996,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500130,31.6784,0,0,0,0,0,0,0,0,0,0,20,11,40,0.16,0,0,36.64,20.5184,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500131,475.17599999999993,0,0,0,0,0,0,0,0,0,0,300,165,600,2.4,0,0,549.6,307.77599999999995,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500132,83.155799999999999,0,0,0,0,0,0,0,0,0,0,52.5,28.875000000000004,105,0.42,0,0,96.18,53.860799999999998,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"relle",201500133,158.392,0,0,0,0,0,0,0,0,0,0,100,55.000000000000007,200,0.8,0,0,183.20000000000002,102.592,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500116,54.6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1365,54.6,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500119,420,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10500,420,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500121,15.6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,390,15.6,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500123,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2475,99,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500124,108.24000000000001,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2706,108.24000000000001,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500125,216,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5400,216,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500122,72,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1800,72,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500122,72,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1800,72,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500129,78.600000000000009,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1965,78.600000000000009,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500126,5.76,0,0,0,0,0,0,0,0,0,0,0,0,0,0,144,5.76,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500134,109.2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2730,109.2,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500127,294,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7350,294,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500128,4.8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,120,4.8,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500123,99.600000000000009,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2490,99.600000000000009,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500130,4.8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,120,4.8,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500131,24,0,0,0,0,0,0,0,0,0,0,0,0,0,0,600,24,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500131,47.4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1185,47.4,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500132,12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,300,12,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extru",201500133,24,0,0,0,0,0,0,0,0,0,0,0,0,0,0,600,24,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+T105+V105+X105+Z105+AB105+AD105+AF105+AH105+AJ105+AL105+AN105+AP105+AR105","v":18337.452961792718},{"$f":"+SUM(S51:S104)","v":4342.5},{"$f":"+SUM(T51:T104)","v":43.425000000000004},{"$f":"+SUM(U51:U104)","v":19750},335.75000000000006,6887,137.74,28128,843.83999999999992,14325,859.5,7549.9000000000005,4152.4450000000006,25478,101.91200000000002,44040,1761.6,16194.083000000004,9068.6864800000003,6305,378.3,4435,{"$f":"+SUM(AN51:AN104)","v":134.45686274509802},6305,378.3,4435,141.49761904761905]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste","Consumo","Coste"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HILO   80/20  0,25  ","HILO   80/20  0,25  ","HILO   80/20  0,33  ","HILO   80/20  0,33  ","HILO   80/20  0,35  ","HILO   80/20  0,35  ","HILO   80/20  0,40  ","HILO   80/20  0,40  ","HILO   80/20  0,55  ","HILO   80/20  0,55  ","MAGNES ALFA 4B","MAGNES ALFA 4B","TAPON PLÁSTICO 9,5    6666","TAPON PLÁSTICO 9,5    6666","TFM    444 Z33","TFM    444 Z33","TUBO 333 9,5/45","TUBO 333 9,5/45","VARILLA A 3/65   11","VARILLA A 3/65   11","VARILLA A 3/65   22","VARILLA A 3/65   22","VARILLA B 3/65   11","VARILLA B 3/65   11","VARILLA B 3/65   22","VARILLA B 3/65   22"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fase","Material","Unidades","Tamaño envase","Consumo un.","Coste €","Si €","Compras €","Consumo un.","Consumos €","Sf €"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bobinado","HILO   80/20  0,25  ","mm",10000,4342.5,43.425000000000004,2300,0,{"$f":"+T113","v":10000},{"$f":"+V113*Y113/U113","v":100.00000000000001},{"$f":"+W113+X113-Z113","v":2200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bobinado","HILO   80/20  0,33  ","mm",10000,19750,335.75000000000006,6800,0,{"$f":"+T114*2","v":20000},{"$f":"+V114*Y114/U114","v":340.00000000000006},{"$f":"+W114+X114-Z114","v":6460}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bobinado","HILO   80/20  0,35  ","mm",10000,6887,137.74,9800,0,10000,200,9600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bobinado","HILO   80/20  0,40  ","mm",10000,28128,843.83999999999992,9000,0,{"$f":"+T116*3","v":30000},899.99999999999989,8100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bobinado","HILO   80/20  0,55  ","mm",10000,14325,859.5,18000,0,20000,1200,16800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bobinado/Rellenado","TAPON PLÁSTICO 9,5    6666","un.",3000,25478,101.91200000000002,1200,0,{"$f":"+T118*9","v":27000},108.00000000000001,1092]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bobinado","VARILLA A 3/65   11","un.",1000,6305,378.3,2220,0,{"$f":"+T119*7","v":7000},420,1800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bobinado","VARILLA A 3/65   22","un.",1000,4435,134.46,120,1550,{"$f":"+T120*5","v":5000},151.96,{"$f":"+W120+X120-Z120","v":1518.04}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bobinado","VARILLA B 3/65   11","un.",1000,6305,378.3,2340,0,{"$f":"+T121*7","v":7000},420,1920]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bobinado","VARILLA B 3/65   22","un.",1000,4435,141.495,90,1920,5000,159.52000000000001,1850.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Extrusionado","TFM    444 Z33","un.",2000,44040,1761.6,5200,0,{"$f":"+T123*23","v":46000},1840,3360]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rellenado","MAGNES ALFA 4B","grs",1000,7549.9000000000005,4152.4450000000006,23650,0,{"$f":"+T124*8","v":8000},4400,19250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rellenado","TUBO 333 9,5/45","mm",20000,16194.083000000004,9068.6864800000003,33600,0,{"$f":"+T125*1","v":20000},11199.999999999996,22400.000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V113:V125)","v":18337.45348},null,null,null,{"$f":"SUM(Z113:Z125)","v":21439.479999999996},{"$f":"SUM(AA113:AA125)","v":96350.52}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Artículo","# Fase","Fase","coste","Unidades Pedido","Unidades fabric.","Coste unitario"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500116,"01","Bucle",50.461666666666666,450,455,0.11090476190476191]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500116,"02","Relle",266.26600000000002,450,455,0.58520000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500116,"03","Extru",54.6,450,455,0.12000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500119,"01","Bucle",388.72119047619043,3500,3505,0.11090476190476189]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500119,"02","Relle",2051.1259999999997,3500,3505,0.58519999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500119,"03","Extru",420,3500,3500,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500120,"01","Bucle",0.55452380952380953,3500,5,0.11090476190476191]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500120,"02","Relle",2.9260000000000002,3500,5,0.58520000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500121,"01","Bucle",14.417619047619048,120,130,0.11090476190476191]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500121,"02","Relle",76.076000000000008,120,130,0.58520000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500121,"03","Extru",15.6,120,130,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500122,"01","Bucle",717.5,1200,1250,0.57399999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500122,"02","Relle",461.68599999999998,1200,370,1.2478]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500122,"02","Relle",1048.152,1200,840,1.2478]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500122,"03","Extru",72,1200,600,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500122,"03","Extru",72,1200,600,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anulada","01","Bucle",262.27999999999997,825,830,0.31599999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500123,"01","Bucle",265.44,825,840,0.316]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anulada","02","Relle",825.40527999999995,825,826,0.99927999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500123,"02","Relle",834.39879999999982,825,835,0.99927999999999984]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anulada","03","Extru",99,825,825,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500123,"03","Extru",99.600000000000009,825,830,0.12000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500124,"01","Bucle",292.29999999999995,900,925,0.31599999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500124,"02","Relle",914.34120000000007,900,915,0.99928000000000006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500124,"03","Extru",108.24000000000001,900,902,0.12000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500125,"01","Bucle",568.79999999999995,1800,1800,0.31599999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500125,"02","Relle",1798.704,1800,1800,0.99927999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500125,"03","Extru",216,1800,1800,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500126,"01","Bucle",6.0997619047619054,50,55,0.11090476190476192]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500126,"02","Relle",30.430399999999999,50,52,0.58519999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500126,"03","Extru",5.76,50,48,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500127,"01","Bucle",492.5037142857143,2450,2460,0.20020476190476191]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500127,"02","Relle",1881.9504000000002,2450,1635,1.1510400000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500127,"02","Relle",938.09759999999994,2450,815,1.1510399999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500127,"03","Extru",294,2450,2450,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500128,"01","Bucle",8.0081904761904781,40,40,0.20020476190476194]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500128,"02","Relle",46.041599999999995,40,40,1.1510399999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500128,"03","Extru",4.8,40,40,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500129,"01","Bucle",378.84000000000003,650,660,0.57400000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500129,"02","Relle",823.54799999999989,650,660,1.2477999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500129,"03","Extru",78.600000000000009,650,655,0.12000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500130,"01","Bucle",8.3161904761904761,40,40,0.2079047619047619]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500130,"02","Relle",31.6784,40,40,0.79196]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500130,"03","Extru",4.8,40,40,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500131,"01","Bucle",127.02288515406165,600,610,0.20823423795747811]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500131,"02","Relle",475.17599999999993,600,600,0.79195999999999989]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500131,"03","Extru",24,600,200,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500131,"03","Extru",47.4,600,395,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500132,"01","Bucle",22.977366946778709,100,110,0.20888515406162461]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500132,"02","Relle",83.155799999999999,100,105,0.79196]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500132,"03","Extru",12,100,100,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500133,"01","Bucle",43.865882352941171,200,210,0.20888515406162461]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500133,"02","Relle",158.392,200,200,0.79196]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500133,"03","Extru",24,200,200,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500134,"01","Bucle",101.81549019607839,900,910,0.11188515406162459]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500134,"02","Relle",532.53200000000004,900,910,0.58520000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201500134,"03","Extru",109.2,900,910,0.12000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(U141:U197)","v":18791.607961792713}]

{"sheet":"SEMITERMINADO","index":2,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,12,2,15],[42,16,42,17],[8,15,8,17]]}
["R E D S Y S T E M C E , S. L."]
[]
[null,null,"RELACIÓN DE SEMITERMINADO EN PERIODO Y FASE",null,null,null,null,null,null,null,null,null,"2015-01-17"]
[null,null,"valor de los consumos de materiales"]
[]
[]
[null,"DESDE","HASTA","FASE"]
[null,20150110,20150117," 0003"]
[null,null,null,null,null,null,null,null,"Entradas",null,null,null,"Salidas",null,null,"Existencias"]
["ResClav01","ResClav02","ResClav03","Fecha","Concepto","Fase","|","precio unitario","cantidad","valor","|","precio unitario","cantidad","valor","|","precio unitario","cantidad","valor"]
["--------","--------","--------","--------","--------","--------","|","--------","--------","--------","|","--------","--------","--------","|","--------","--------","--------"]
["RE220 ","TU-12 ","003359",20150110,201500116,"001","|",{"$f":"+J12/I12","v":0.11090476190476191},455,{"$f":"+FichasTecnicas!R47","v":50.461666666666666},"|",null,null,null,"|",{"$f":"+H12","v":0.11090476190476191},455,{"$f":"+J12","v":50.461666666666666}]
["RE220 ","TU-12 ","003359",20150110,201500119,"001","|",{"$f":"+J13/I13","v":0.11090476190476189},3505,{"$f":"+FichasTecnicas!R48","v":388.72119047619043},"|",null,null,null,"|",{"$f":"+H13","v":0.11090476190476189},3505,{"$f":"+J13","v":388.72119047619043}]
["RE220 ","TU-12 ","003359",20150111,201500120,"001","|",0.11090476190476191,5,{"$f":"+FichasTecnicas!R49","v":0.55452380952380953},"|",null,null,null,"|",0.11090476190476191,5,0.55452380952380953]
["RE220 ","TU-12 ","003359",20150111,201500121,"001","|",0.11090476190476191,130,{"$f":"+FichasTecnicas!R50","v":14.417619047619048},"|",null,null,null,"|",0.11090476190476191,130,14.417619047619048]
["RE220 ","TU-12 ","003359",20150112,201500116,"001","|",null,null,null,"|",{"$f":"+N16/M16","v":0.11090476190476191},455,{"$f":"+J12","v":50.461666666666666},"|",null,null,{"$f":"+R12-N16","v":0}]
["RE220 ","TU-12 ","003359",20150112,201500119,"001","|",null,null,null,"|",{"$f":"+N17/M17","v":0.11090476190476189},3505,{"$f":"+J13","v":388.72119047619043},"|",null,null,{"$f":"+R13-N17","v":0}]
["RE220 ","TU-12 ","003359",20150112,201500120,"001","|",null,null,null,"|",0.11090476190476191,5,0.55452380952380953,"|",null,null,0]
["RE220 ","TU-12 ","003359",20150112,201500121,"001","|",null,null,null,"|",0.11090476190476191,130,14.417619047619048,"|",null,null,0]
["RE220 ","TU-12 ","003359",20150112,201500120,"002","|",{"$f":"+Resumen!L17","v":0.69610476190476189},5,{"$f":"+H20*I20","v":3.4805238095238096},"|",null,null,null,"|",{"$f":"+H20","v":0.69610476190476189},5,{"$f":"+P20*Q20","v":3.4805238095238096}]
["RE220 ","TU-12 ","003359",20150112,201500116,"003","|",{"$f":"+Resumen!L15","v":0.816104761904762},455,{"$f":"+I21*H21","v":371.32766666666669},"|",null,null,null,"|",{"$f":"+H21","v":0.816104761904762},455,{"$f":"+Q21*P21","v":371.32766666666669}]
["RE220 ","TU-12 ","003359",20150112,201500119,"003","|",{"$f":"+Resumen!L16","v":0.81709919727891145},3500,{"$f":"+H22*I22","v":2859.84719047619},"|",null,null,null,"|",0.81709919727891145,3500,{"$f":"+P22*Q22","v":2859.84719047619}]
["RE220 ","TU-12 ","003359",20150113,201500121,"003","|",{"$f":"+Resumen!L18","v":0.816104761904762},130,{"$f":"+I23*H23","v":106.09361904761906},"|",null,null,null,"|",0.816104761904762,130,{"$f":"+Q23*P23","v":106.09361904761906}]
["RE220 ","TU-12 ","003359",20150115,201500126,"003","|",{"$f":"+Resumen!L23","v":0.88104503968253967},48,{"$f":"+H24*I24","v":42.290161904761902},"|",null,null,null,"|",0.88104503968253967,48,{"$f":"+P24*Q24","v":42.290161904761902}]
["RE220 ","TU-12 ","003359",20150115,201500134,"003","|",{"$f":"+Resumen!L31","v":0.81708515406162463},910,{"$f":"+I25*H25","v":743.54749019607846},"|",null,null,null,"|",0.81708515406162463,910,{"$f":"+Q25*P25","v":743.54749019607846}]
["--------","--------","--------","--------","--------","--------","|","--------","--------","--------","|","--------","--------","--------","|","--------","--------","--------"]
["RE225 ","TU-80 ","000012",20150116,201500127,"003","|",{"$f":"+Resumen!L24","v":1.4720619241982507},2450,{"$f":"+H27*I27","v":3606.5517142857143},"|",null,null,null,"|",1.4720619241982507,2450,{"$f":"+P27*Q27","v":3606.5517142857143}]
["RE225 ","TU-80 ","000012",20150116,201500128,"003","|",{"$f":"+Resumen!L25","v":1.4712447619047617},40,58.849790476190471,"|",null,null,null,"|",1.4712447619047617,40,58.849790476190471]
["--------","--------","--------","--------","--------","--------","|","--------","--------","--------","|","--------","--------","--------","|","--------","--------","--------"]
["RE220 ","TU-80 ","000045",20150114,201500122,"003","|",{"$f":"+Resumen!L19","v":1.9761149999999998},{"$f":"+PRODUCCION!J55+PRODUCCION!J56","v":1200},2371.3379999999997,"|",null,null,null,"|",1.9761149999999998,1200,2371.3379999999997]
["RE220 ","TU-80 ","000045",20150115,201500129,"003","|",{"$f":"+Resumen!L26","v":1.9557068702290075},{"$f":"+PRODUCCION!J57","v":655},1280.9879999999998,"|",null,null,null,"|",1.9557068702290075,655,1280.9879999999998]
["--------","--------","--------","--------","--------","--------","|","--------","--------","--------","|","--------","--------","--------","|","--------","--------","--------"]
["RE225 ","TU-80 ","000428",20150113,201500123,"003","|",{"$f":"+Resumen!L20","v":1.445106987951807},825,1192.2132650602407,"|",null,null,null,"|",1.445106987951807,830,1199.4387999999999]
["RE225 ","TU-80 ","000428",20150113,201500124,"003","|",{"$f":"+Resumen!L21","v":1.457739689578714},902,1314.8812,"|",null,null,null,"|",1.457739689578714,902,1314.8812]
["RE225 ","TU-80 ","000428",20150113,201500125,"003","|",{"$f":"+Resumen!L22","v":1.4352799999999999},1800,2583.5039999999999,"|",null,null,null,"|",1.4352799999999999,1800,2583.5039999999999]
["--------","--------","--------","--------","--------","--------","|","--------","--------","--------","|","--------","--------","--------","|","--------","--------","--------"]
["RE225 ","TU-80 ","000662",20150116,201500130,"003","|",{"$f":"+Resumen!L27","v":1.1198647619047619},40,44.794590476190479,"|",null,null,null,"|",1.1198647619047619,{"$f":"+I37","v":40},44.794590476190479]
["RE225 ","TU-80 ","000662",20150117,201500131,"003","|",{"$f":"+Resumen!L28","v":1.1320989666454817},595,673.59888515406158,"|",null,null,null,"|",1.1320989666454817,{"$f":"+I38","v":595},673.59888515406158]
["RE225 ","TU-80 ","000662",20150117,201500132,"003","|",{"$f":"+Resumen!L29","v":1.1813316694677871},100,118.13316694677872,"|",null,null,null,"|",1.1813316694677871,100,118.13316694677872]
["RE225 ","TU-80 ","000662",20150117,201500133,"003","|",{"$f":"+Resumen!L30","v":1.1312894117647059},200,226.25788235294118,"|",null,null,null,"|",1.1312894117647059,{"$f":"+I40","v":200},226.25788235294118]
["--------","--------","--------","--------","--------","--------","|","--------","--------","--------","|","--------","--------","--------","|","--------","--------","--------"]
[]
[" +   +   +   +   +   +  +   +   +   +   +   +   +   +   +   +   +   +  +   +   +   +   +   + V A L O R    S E M I T E R M I N A D O     ( E U R O S ) *   *   *   *   *   *   *   *   *   *    *   *   *   *   *   *   *",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(R20:R40)","v":17604.922681792716}]

{"sheet":"Resumen","index":3,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
["R E D S Y S T E M C E , S. L."]
[]
[]
["RESUMEN DEL COSTE DE MATERIALES POR OF Y FASE"]
[]
[]
[]
["Tabla dinámica"]
[]
[null,"01","Bobinado",null,"02","Rellenado",null,"03","Extrusionado",null,"Suma"]
["OF","UnitFab","Coste mp","Coste unitario","UnitFab","Coste mp","Coste unitario","UnitFab","Coste mp","Coste unitario","Coste mp","Coste unitario"]
[null,"unid.","euros","euros/unid.","unid.","euros","euros/unid.","unid.","euros","euros/unid.","euros","euros/unid."]
[201500116,455,50.461666666666666,{"$f":"+C15/B15","v":0.11090476190476191},455,266.26600000000002,{"$f":"+F15/E15","v":0.58520000000000005},455,54.6,{"$f":"+I15/H15","v":0.12000000000000001},{"$f":"+I15+F15+C15","v":371.32766666666669},{"$f":"+K15/H15","v":0.816104761904762}]
[201500119,3505,388.72119047619043,{"$f":"+C16/B16","v":0.11090476190476189},3505,2051.1259999999997,{"$f":"+F16/E16","v":0.58519999999999994},3500,420,{"$f":"+I16/H16","v":0.12},{"$f":"+I16+F16+C16","v":2859.84719047619},{"$f":"+K16/H16","v":0.81709919727891145}]
[201500120,5,0.55452380952380953,0.11090476190476191,5,2.9260000000000002,0.58520000000000005,null,null,null,3.4805238095238096,{"$f":"+K17/E17","v":0.69610476190476189}]
[201500121,130,14.417619047619048,0.11090476190476191,130,76.076000000000008,0.58520000000000005,130,15.6,0.12,106.09361904761906,{"$f":"+K18/H18","v":0.816104761904762}]
[201500122,1250,717.5,0.57399999999999995,1210,1509.838,1.2478,1200,144,0.12,2371.3379999999997,1.9761149999999998]
[201500123,840,265.44,0.316,835,834.39879999999982,0.99927999999999984,830,99.600000000000009,0.12000000000000001,1199.4387999999999,1.445106987951807]
[201500124,925,292.29999999999995,0.31599999999999995,915,914.34120000000007,0.99928000000000006,902,108.24000000000001,0.12000000000000001,1314.8812,1.457739689578714]
[201500125,1800,568.79999999999995,0.31599999999999995,1800,1798.704,0.99927999999999995,1800,216,0.12,2583.5039999999999,1.4352799999999999]
[201500126,55,6.0997619047619054,0.11090476190476192,52,30.430399999999999,0.58519999999999994,48,5.76,0.12,42.290161904761902,0.88104503968253967]
[201500127,2460,492.5037142857143,0.20020476190476191,2450,2820.0480000000002,1.1510400000000001,2450,294,0.12,3606.5517142857143,1.4720619241982507]
[201500128,40,8.0081904761904781,0.20020476190476194,40,46.041599999999995,1.1510399999999998,40,4.8,0.12,58.849790476190471,1.4712447619047617]
[201500129,660,378.84000000000003,0.57400000000000007,660,823.54799999999989,1.2477999999999998,655,78.600000000000009,0.12000000000000001,1280.9879999999998,1.9557068702290075]
[201500130,40,8.3161904761904761,0.2079047619047619,40,31.6784,0.79196,40,4.8,0.12,44.794590476190479,1.1198647619047619]
[201500131,610,127.02288515406165,0.20823423795747811,600,475.17599999999993,0.79195999999999989,595,71.400000000000006,0.12000000000000001,673.59888515406158,1.1320989666454817]
[201500132,110,22.977366946778709,0.20888515406162461,105,83.155799999999999,0.79196,100,12,0.12,118.13316694677872,1.1813316694677871]
[201500133,210,43.865882352941171,0.20888515406162461,200,158.392,0.79196,200,24,0.12,226.25788235294118,1.1312894117647059]
[201500134,910,101.81549019607839,0.11188515406162459,910,532.53200000000004,0.58520000000000005,910,109.2,0.12000000000000001,743.54749019607846,0.81708515406162463]
["Anulada",830,262.27999999999997,0.31599999999999995,826,825.40527999999995,0.99927999999999995,825,99,0.12,{"$f":"+I32+F32+C32","v":1186.6852799999999},1.4384063999999999]
[null,{"$f":"SUM(B15:B32)","v":14835},{"$f":"SUM(C15:C32)","v":3749.9244817927174},{"$f":"+C33/B33","v":0.25277549590783399},{"$f":"SUM(E15:E32)","v":14738},{"$f":"SUM(F15:F32)","v":13280.083480000001},{"$f":"+F33/E33","v":0.90107772289320132},{"$f":"SUM(H15:H32)","v":14680},{"$f":"SUM(I15:I32)","v":1761.6},{"$f":"+I33/H33","v":0.12},{"$f":"+I33+F33+C33","v":18791.607961792717},{"$f":"+D33+G33+J33","v":1.2738532188010354}]