{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["INICIO","DO_01","REGISTRO","DETALLE","DATA","SERIE001","SERIE002","SERIE003"],"not_rendered":{"images":1,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"INICIO","index":0,"n_rows":6,"n_cols":2,"rows_kept":6}
[null,"Programación en Excel VBA • Nivel I"]
[null,"MOS Expert CPC Martín Cruz • +51 998401784 | Excel No Convencional"]
[]
[null,"For Each"]
[]
[null,"For Next"]

{"sheet":"DO_01","index":1,"n_rows":51,"n_cols":12,"rows_kept":51,"hidden":true}
[]
[]
[]
[]
[{"$nulls":8},"►","CIEN registros"]
[]
[{"$nulls":9},"•","Borrar datos"]
[{"$nulls":10},"Inicie borrando los datos generados en las hoja"]
[{"$nulls":10},"DETALLE, DATA y SERIE…"]
[]
[{"$nulls":9},"•","Capture los datos en variables"]
[{"$nulls":10},"Mes"]
[{"$nulls":10},"Serie"]
[{"$nulls":10},"Producto"]
[{"$nulls":10},"Base"]
[]
[{"$nulls":9},"•","Hoja DETALLE"]
[{"$nulls":10},"Ubique los 100 registros que se generen."]
[]
[{"$nulls":9},"•","Hoja DATA (Variable Mes y Serie)"]
[{"$nulls":10},"La variable Mes debe servir para ubicar Base en "]
[{"$nulls":10},"la fila de mes que corresponda."]
[{"$nulls":10},"La variable Serie debe servir para ubicar Base en"]
[{"$nulls":10},"la columna de Serie que corresponda."]
[]
[{"$nulls":10},"▲","Importante"]
[{"$nulls":11},"El objetivo principal es acumular los 100 datos que se"]
[{"$nulls":11},"generen de forma aleatoria."]
[{"$nulls":11},"Toma en cuenta antes de ubicar Base en la posición"]
[{"$nulls":11},"de fila y columna correspondiente, debe capturar el"]
[{"$nulls":11},"valor que se encuentre en dicha posición para acumularlo."]
[{"$nulls":11},"No usar instrucción IF"]
[]
[{"$nulls":9},"•","Hojas SERIE (Variable Serie, Mes y Producto)"]
[{"$nulls":10},"La variable Serie debe servir para seleccionar la hoja serie que"]
[{"$nulls":10},"corresponda."]
[{"$nulls":10},"No usar instrucción IF"]
[{"$nulls":10},"Ubicada la hoja, la variable Mes debe servir para para determinar"]
[{"$nulls":10},"la fila y la variable Producto, para determinar la columna."]
[]
[{"$nulls":10},"▲","Importante"]
[{"$nulls":11},"El objetivo principal es acumular los 100 datos que se"]
[{"$nulls":11},"generen de forma aleatoria."]
[{"$nulls":11},"Toma en cuenta antes de ubicar Base en la posición"]
[{"$nulls":11},"de fila y columna correspondiente, debe capturar el"]
[{"$nulls":11},"valor que se encuentre en dicha posición para acumularlo."]
[{"$nulls":11},"No usar instrucción IF"]
[]
[{"$nulls":9},"•","Terminar en la hoja REGISTRO, celda B5."]
[]
[{"$nulls":9},"•","Generar un mensaje de finalización."]

{"sheet":"REGISTRO","index":2,"n_rows":17,"n_cols":7,"rows_kept":17,"hidden":true}
[null,"For Each • Registro"]
[null,"MOS Expert CPC Martín Cruz • +51 998401784 | Excel No Convencional"]
[]
[]
[null,"Mes",{"$f":"INDEX(t.meses[MES],RANDBETWEEN(1,12))","v":"Setiembre"},null,"MES",null,"PRODUCTO"]
[null,"Serie",{"$f":"TEXT(RANDBETWEEN(1,3),\"000\")","v":"001"},null,"Enero",null,"Gaseosas"]
[null,"Numero",{"$f":"RANDBETWEEN(100,300)","v":259},null,"Febrero",null,"Licores"]
[null,"Producto",{"$f":"INDEX(t.productos[PRODUCTO],RANDBETWEEN(1,4))","v":"Licores"},null,"Marzo",null,"Cervezas"]
[null,"Base",{"$f":"RANDBETWEEN(1000,6000)","v":3312},null,"Abril",null,"Abarrotes"]
[{"$nulls":4},"Mayo"]
[{"$nulls":4},"Junio"]
[{"$nulls":4},"Julio"]
[{"$nulls":4},"Agosto"]
[{"$nulls":4},"Setiembre"]
[{"$nulls":4},"Octubre"]
[{"$nulls":4},"Noviembre"]
[{"$nulls":4},"Diciembre"]

{"sheet":"DETALLE","index":3,"n_rows":105,"n_cols":7,"rows_kept":105,"hidden":true}
[null,"For Each • Detalle"]
[null,"MOS Expert CPC Martín Cruz • +51 998401784 | Excel No Convencional"]
[]
[]
[null,null,"Mes","Serie","Numero","Producto","Base"]
[null,null,"Febrero","003",274,"Gaseosas",1714]
[null,null,"Enero","001",260,"Licores",4330]
[null,null,"Junio","001",199,"Abarrotes",3398]
[null,null,"Agosto","003",297,"Gaseosas",2848]
[null,null,"Agosto","002",103,"Cervezas",1307]
[null,null,"Octubre","001",142,"Cervezas",1111]
[null,null,"Enero","002",172,"Abarrotes",5121]
[null,null,"Junio","002",266,"Abarrotes",3890]
[null,null,"Marzo","002",129,"Gaseosas",1940]
[null,null,"Marzo","002",298,"Licores",1711]
[null,null,"Noviembre","001",117,"Abarrotes",3878]
[null,null,"Diciembre","003",141,"Cervezas",2638]
[null,null,"Octubre","002",147,"Licores",2483]
[null,null,"Setiembre","002",272,"Cervezas",2263]
[null,null,"Marzo","001",144,"Gaseosas",1545]
[null,null,"Febrero","002",266,"Cervezas",4906]
[null,null,"Enero","002",240,"Licores",5342]
[null,null,"Setiembre","001",110,"Cervezas",1257]
[null,null,"Febrero","001",253,"Gaseosas",2347]
[null,null,"Julio","002",244,"Gaseosas",2461]
[null,null,"Junio","002",235,"Cervezas",1293]
[null,null,"Marzo","003",129,"Licores",5876]
[null,null,"Julio","001",143,"Gaseosas",2999]
[null,null,"Agosto","003",110,"Abarrotes",3042]
[null,null,"Agosto","001",287,"Cervezas",4957]
[null,null,"Octubre","001",208,"Gaseosas",2534]
[null,null,"Marzo","001",276,"Cervezas",4632]
[null,null,"Noviembre","003",162,"Abarrotes",1713]
[null,null,"Febrero","003",128,"Licores",1943]
[null,null,"Noviembre","003",183,"Cervezas",1735]
[null,null,"Setiembre","002",272,"Gaseosas",4719]
[null,null,"Febrero","002",219,"Cervezas",5131]
[null,null,"Setiembre","003",282,"Gaseosas",1732]
[null,null,"Febrero","001",103,"Abarrotes",5087]
[null,null,"Julio","001",290,"Abarrotes",2721]
[null,null,"Junio","002",209,"Licores",1682]
[null,null,"Diciembre","001",135,"Licores",1410]
[null,null,"Febrero","001",223,"Abarrotes",1287]
[null,null,"Setiembre","001",185,"Abarrotes",4725]
[null,null,"Mayo","001",267,"Gaseosas",5885]
[null,null,"Abril","003",292,"Abarrotes",4944]
[null,null,"Setiembre","001",215,"Abarrotes",5890]
[null,null,"Enero","002",134,"Abarrotes",1241]
[null,null,"Diciembre","003",288,"Licores",2989]
[null,null,"Setiembre","002",187,"Abarrotes",4828]
[null,null,"Agosto","001",171,"Cervezas",5046]
[null,null,"Enero","001",277,"Cervezas",3945]
[null,null,"Enero","001",219,"Licores",5738]
[null,null,"Junio","001",124,"Licores",4167]
[null,null,"Enero","003",117,"Gaseosas",1900]
[null,null,"Marzo","002",182,"Abarrotes",4823]
[null,null,"Marzo","002",256,"Cervezas",4141]
[null,null,"Octubre","002",207,"Abarrotes",2243]
[null,null,"Abril","003",283,"Licores",2057]
[null,null,"Enero","002",212,"Licores",5345]
[null,null,"Marzo","001",166,"Gaseosas",3143]
[null,null,"Julio","001",159,"Gaseosas",4863]
[null,null,"Febrero","003",252,"Cervezas",5270]
[null,null,"Marzo","003",146,"Cervezas",1156]
[null,null,"Noviembre","002",137,"Abarrotes",3290]
[null,null,"Febrero","003",177,"Abarrotes",3542]
[null,null,"Enero","003",105,"Gaseosas",4196]
[null,null,"Octubre","002",189,"Licores",5705]
[null,null,"Octubre","001",265,"Cervezas",4739]
[null,null,"Enero","003",248,"Cervezas",1318]
[null,null,"Abril","001",139,"Cervezas",4504]
[null,null,"Julio","002",101,"Gaseosas",2448]
[null,null,"Abril","001",258,"Cervezas",1359]
[null,null,"Abril","001",298,"Abarrotes",3118]
[null,null,"Mayo","002",243,"Cervezas",2009]
[null,null,"Diciembre","003",135,"Cervezas",1523]
[null,null,"Abril","001",268,"Cervezas",2592]
[null,null,"Enero","002",267,"Cervezas",1856]
[null,null,"Febrero","001",265,"Gaseosas",5677]
[null,null,"Abril","003",231,"Cervezas",5571]
[null,null,"Noviembre","002",154,"Licores",1313]
[null,null,"Marzo","002",106,"Licores",1361]
[null,null,"Setiembre","003",226,"Cervezas",4894]
[null,null,"Noviembre","002",107,"Gaseosas",2741]
[null,null,"Marzo","002",107,"Abarrotes",1477]
[null,null,"Abril","002",137,"Gaseosas",3426]
[null,null,"Diciembre","001",177,"Licores",4616]
[null,null,"Octubre","003",126,"Cervezas",4718]
[null,null,"Junio","003",281,"Abarrotes",2655]
[null,null,"Junio","001",262,"Gaseosas",3545]
[null,null,"Febrero","003",254,"Cervezas",4040]
[null,null,"Mayo","003",136,"Gaseosas",2805]
[null,null,"Octubre","002",108,"Gaseosas",4827]
[null,null,"Julio","002",266,"Licores",4374]
[null,null,"Marzo","001",232,"Cervezas",5177]
[null,null,"Julio","002",187,"Licores",4155]
[null,null,"Junio","003",226,"Abarrotes",4336]
[null,null,"Noviembre","001",117,"Abarrotes",5971]
[null,null,"Junio","003",105,"Licores",1396]
[null,null,"Diciembre","002",292,"Abarrotes",5453]
[null,null,"Octubre","001",300,"Licores",5127]
[null,null,"Setiembre","002",210,"Gaseosas",4468]
[null,null,"Agosto","003",243,"Gaseosas",1376]
[null,null,"Agosto","001",233,"Cervezas",1420]
[null,null,"Octubre","001",211,"Cervezas",5846]

{"sheet":"DATA","index":4,"n_rows":17,"n_cols":5,"rows_kept":17,"hidden":true}
[null,"For Each • Data resumen"]
[null,"MOS Expert CPC Martín Cruz • +51 998401784 | Excel No Convencional"]
[]
[]
[null,"Mes","001","002","003"]
[null,"Enero",14013,18905,7414]
[null,"Febrero",14398,10037,16509]
[null,"Marzo",14497,15453,7032]
[null,"Abril",11573,3426,12572]
[null,"Mayo",5885,2009,2805]
[null,"Junio",11110,6865,8387]
[null,"Julio",10583,13438]
[null,"Agosto",11423,1307,7266]
[null,"Setiembre",11872,16278,6626]
[null,"Octubre",19357,15258,4718]
[null,"Noviembre",9849,7344,3448]
[null,"Diciembre",6026,5453,7150]

{"sheet":"SERIE001","index":5,"n_rows":17,"n_cols":6,"rows_kept":17,"hidden":true}
[null,"For Each • Serie 001"]
[null,"MOS Expert CPC Martín Cruz • +51 998401784 | Excel No Convencional"]
[]
[]
[null,"Mes","Gaseosas","Licores","Cervezas","Abarrotes"]
[null,"Enero",null,10068,3945]
[null,"Febrero",8024,null,null,6374]
[null,"Marzo",4688,null,9809]
[null,"Abril",null,null,8455,3118]
[null,"Mayo",5885]
[null,"Junio",3545,4167,null,3398]
[null,"Julio",7862,null,null,2721]
[null,"Agosto",null,null,11423]
[null,"Setiembre",null,null,1257,10615]
[null,"Octubre",2534,5127,11696]
[null,"Noviembre",{"$nulls":3},9849]
[null,"Diciembre",null,6026]

{"sheet":"SERIE002","index":6,"n_rows":17,"n_cols":6,"rows_kept":17,"hidden":true}
[null,"For Each • Serie 002"]
[null,"MOS Expert CPC Martín Cruz • +51 998401784 | Excel No Convencional"]
[]
[]
[null,"Mes","Gaseosas","Licores","Cervezas","Abarrotes"]
[null,"Enero",null,10687,1856,6362]
[null,"Febrero",null,null,10037]
[null,"Marzo",1940,3072,4141,6300]
[null,"Abril",3426]
[null,"Mayo",null,null,2009]
[null,"Junio",null,1682,1293,3890]
[null,"Julio",4909,8529]
[null,"Agosto",null,null,1307]
[null,"Setiembre",9187,null,2263,4828]
[null,"Octubre",4827,8188,null,2243]
[null,"Noviembre",2741,1313,null,3290]
[null,"Diciembre",{"$nulls":3},5453]

{"sheet":"SERIE003","index":7,"n_rows":17,"n_cols":6,"rows_kept":17,"hidden":true}
[null,"For Each • Serie 003"]
[null,"MOS Expert CPC Martín Cruz • +51 998401784 | Excel No Convencional"]
[]
[]
[null,"Mes","Gaseosas","Licores","Cervezas","Abarrotes"]
[null,"Enero",6096,null,1318]
[null,"Febrero",1714,1943,9310,3542]
[null,"Marzo",null,5876,1156]
[null,"Abril",null,2057,5571,4944]
[null,"Mayo",2805]
[null,"Junio",null,1396,null,6991]
[null,"Julio"]
[null,"Agosto",4224,null,null,3042]
[null,"Setiembre",1732,null,4894]
[null,"Octubre",null,null,4718]
[null,"Noviembre",null,null,1735,1713]
[null,"Diciembre",null,2989,4161]