{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["overzicht","blanco"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"overzicht","index":0,"n_rows":145,"n_cols":26,"rows_kept":145,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
[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,"720R-01-0223"]
[null,null,null,null,null,null,null,null," "]
["Beschrijving artikel (PPnr 55591)",null,null,null,null,null,null,"Open formaat","478,00 x 214,00 mm"]
["Code:","6517-05-0224",null,null,null,null,null,"Gesloten formaat","80,00 x 27 mm"]
["Type",null,null,null,null,null,null,"Kleur R/V","1/1"]
[null,null,null,null,null,null,null,"Grammage","40gr"]
[null,null,null,null,null,null,null,"Status","A"]
["Ordernr","PBnr PP","Voorraadbon","Leveringsdatum","Te produceren","Af te roepen","Uit welke","Reëel geproduceerd","Reëel geleverd","Resterende stock"]
["klant",null,"Afroepbon",null,"aantal","aantal","Voorraadbon","aantal","aantal","per VB"]
["test",296795,"Voorraadbon","2011-10-18",19326,null,null,19080,null,{"$f":"H10-I10","v":19080}]
["test",298120,"Afroepbon","2011-10-25",null,19326,296795,null,19080,-19080]
["test",298727,"Voorraadbon","2011-11-10",23040,null,null,25560,null,25560]
["test",298895,"Afroepbon","2011-11-17",null,2880,298727,null,2880,-2880]
["test",300659,"Afroepbon","2011-12-30",null,11520,298727,null,11520,-11520]
["test",301419,"Afroepbon","2012-01-16",null,2880,298727,null,2880,-2880]
["test",301832,"Voorraadbon","2012-02-07",66240,null,null,71280,null,71280]
["test",302535,"Afroepbon","2012-02-21",null,20160,"298727+301832",null,20160,-20160]
["test",305018,"Afroepbon","2012-04-03",null,40320,301832,null,40320,-40320]
["test",306113,"Voorraadbon","2012-07-03",54720,null,null,63360,null,63360]
["test",308789,"Afroepbon","2012-07-31",null,46080,"301832 + 306113",null,46040,-46040]
["test",312864,"Afroepbon","2012-11-06",null,14400,306113,null,14400,-14400]
["test",314253,"Afroepbon","2013-01-08",null,21960,306113,null,21960,{"$f":"H22-I22","v":-21960}]
["test",314662,"Voorraadbon","2013-02-12",16000,null,null,18480,null,18480]
["test",318102,"Afroepbon","2013-03-26",null,11520,314662,null,11520,-11520]
["test",318064,"Voorraadbon","2013-03-26",73640,null,null,73640,null,73640]
["test",318758,"Afroepbon","2013-04-02",null,28800,"314662+318064",null,28800,-28800]
["test",321852,"Afroepbon","2013-07-02",null,5760,318064,null,5760,-5760]
["test",323277,"Afroepbon","2013-07-23",null,20160,318064,null,20160,{"$f":"H28-I28","v":-20160}]
["test",324402,"Afroepbon","2013-09-03",null,25960,318064,null,25920,{"$f":"H29-I29","v":-25920}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J10:J29)","v":0}]
["6517-05-0224",null,null,null,null,null,"TOTAAL :",{"$f":"SUM(H10:H30)","v":271400},{"$f":"SUM(I10:I30)","v":271400},{"$f":"H31-I31","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Date : 26-08-2011"]
["Beschrijving artikel (PPnr 55438)",null,null,null,null,null,null,"Open formaat","478,00 x 214,00 mm"]
["Code:","720R-01-0223",null,null,null,null,null,"Gesloten formaat","80,00 x 27 mm"]
["Type",null,null,null,null,null,null,"Kleur R/V","2/2"]
[null,null,null,null,null,null,null,"Grammage","40gr"]
[null,null,null,null,null,null,null,"Status","A"]
["Ordernr","PBnr PP","Voorraadbon","Leveringsdatum","Te produceren","Af te roepen","Uit welke","Reëel geproduceerd","Reëel geleverd","Resterende stock"]
["klant",null,"Afroepbon",null,"aantal","aantal","Voorraadbon","aantal","aantal","per VB"]
["test",296793,"Voorraadbon","2011-10-19",103680,null,null,103680,null,{"$f":"H43-I43","v":103680}]
["test",298092,"Afroepbon","2011-10-26",null,80640,296793,null,80640,-80640]
["test",298733,"Voorraadbon","2011-12-23",69120,null,null,72000,null,72000]
["test",305021,"Afroepbon","2012-04-24",null,95040,"296793 + 298733",null,95040,-95040]
["test",306107,"Voorraadbon","2012-06-12",115200,null,null,119040,null,119040]
["test",307800,"Afroepbon","2012-07-10",null,66240,306107,null,66240,-66240]
["test",308755,"Afroepbon","2012-07-31",null,40320,306107,null,40320,-40320]
["test",306109,"Voorraadbon","2012-08-07",265000,null,null,266880,null,266880]
["test",308857,"Afroepbon","2012-07-31",null,17280,"306107 + 306109",null,17280,-17280]
["test",309671,"Afroepbon","2012-08-28",null,28800,306109,null,28800,-28800]
["test",310531,"Afroepbon","2012-09-11",null,80640,306109,null,80640,-80640]
["test",310565,"Afroepbon","2012-10-02",null,89280,306109,null,89280,-89280]
["test",313863,"Afroepbon","2012-12-11",null,5760,306109,null,5760,-5760]
["test",314252,"Afroepbon","2012-12-18",null,57600,306109,null,57600,-57600]
["test",313315,"Voorraadbon","2013-01-29",66240,null,null,70200,null,70200]
["test",316535,"Afroepbon","2013-02-19",null,20160,313315,null,20160,-20160]
["test",319845,"Afroepbon","2013-05-07",null,50040,313315,null,50040,{"$f":"H59-I59","v":-50040}]
["test",322689,"Voorraadbon","2013-08-06",54720,null,null,54720,null,54720]
["test",323158,"Afroepbon","2013-08-13",null,48960,322689,null,48960,-48960]
["test",322690,"Voorraadbon","2013-10-15",57600,null,null,57600,null,57600]
["test",325719,"Afroepbon","2013-10-15",null,23040,"322689+322690",null,23040,-23040]
["test",326448,"Afroepbon","2013-10-29",null,25920,322690,null,25920,{"$f":"H64-I64","v":-25920}]
["test",323558,"Voorraadbon","2013-10-15",23040,null,null,23040,null,{"$f":"H65-I65","v":23040}]
["test","xxx","Afroepbon","2014-02-11",null,43200,"322690+323558"]
["test",326479,"Voorraadbon","2013-12-23",57600,null,null,57600,null,57600]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J43:J67)","v":95040}]
["720R-01-0223",null,null,null,null,null,"TOTAAL :",{"$f":"SUM(H43:H68)","v":824760},{"$f":"SUM(I43:I68)","v":729720},{"$f":"H69-I69","v":95040}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Date : 26-08-2011"]
[]
["Beschrijving artikel (PPnr 55744)",null,null,null,null,null,null,"Open formaat","478,00 x 214,00 mm"]
["Code:","9F9G-01-1223",null,null,null,null,null,"Gesloten formaat","80,00 x 27 mm"]
["Type",null,null,null,null,null,null,"Kleur R/V","1/0"]
[null,null,null,null,null,null,null,"Grammage","40gr"]
[null,null,null,null,null,null,null,"Status","A"]
["Ordernr","PBnr PP","Voorraadbon","Leveringsdatum","Te produceren","Af te roepen","Uit welke","Reëel geproduceerd","Reëel geleverd","Resterende stock"]
["klant",null,"Afroepbon",null,"aantal","aantal","Voorraadbon","aantal","aantal","per VB"]
[]
["test",296789,"Voorraadbon","2011-11-21",8640,null,null,8640,null,{"$f":"H83-I83","v":8640}]
["test",302350,"Afroepbon","2012-02-15",null,8640,296789,null,8640,-8640]
["test",306118,"Voorraadbon","2012-07-03",20160,null,null,20160,null,20160]
["test",307063,"Afroepbon","2012-06-19",null,8640,306118,null,8640,-8640]
["test",311083,"Afroepbon","2012-10-02",null,11520,306118,null,11520,-11520]
["test",311394,"Voorraadbon","2012-10-16",11520,null,null,13320,null,13320]
["test",314652,"Afroepbon","2013-01-22",null,5760,311394,null,5760,{"$f":"H89-I89","v":-5760}]
["test",319844,"Afroepbon","2013-05-07",null,7560,311394,null,7560,{"$f":"H90-I90","v":-7560}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J83:J90)","v":0}]
[]
["9F9G-01-1223",null,null,null,null,null,"TOTAAL :",{"$f":"SUM(H83:H91)","v":42120},{"$f":"SUM(I83:I91)","v":42120},{"$f":"H93-I93","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Date : 26-08-2011"]
[]
["Beschrijving artikel (PPnr 55714)",null,null,null,null,null,null,"Open formaat","478,00 x 214,00 mm"]
["Code:","2W6W-01-0221",null,null,null,null,null,"Gesloten formaat","80,00 x 27 mm"]
["Type",null,null,null,null,null,null,"Kleur R/V","1/1"]
[null,null,null,null,null,null,null,"Grammage","40gr"]
[null,null,null,null,null,null,null,"Status","A"]
["Ordernr","PBnr PP","Voorraadbon","Leveringsdatum","Te produceren","Af te roepen","Uit welke","Reëel geproduceerd","Reëel geleverd","Resterende stock"]
["klant",null,"Afroepbon",null,"aantal","aantal","Voorraadbon","aantal","aantal","per VB"]
[]
["test",296786,"Voorraadbon","2011-11-18",8640,null,null,8640,null,{"$f":"H107-I107","v":8640}]
["test",299795,"Afroepbon","2011-12-06",null,5760,296786,null,5760,-5760]
["test",301842,"Voorraadbon","2012-02-07",8640,null,null,8640,null,8640]
["test",302261,"Afroepbon","2012-02-14",null,5760,"296786+301842",null,5760,-5760]
["test",304100,"Afroepbon","2012-04-03",null,2880,301842,null,2880,-2880]
["test",309223,"Voorraadbon","2012-10-15",11520,null,null,11520,null,11520]
["test",311148,"Afroepbon","2012-10-09",null,5760,"301842 + 309223",null,5760,-5760]
["test",319843,"Afroepbon","2013-05-14",null,8640,309223,null,8640,{"$f":"H114-I114","v":-8640}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J107:J114)","v":0}]
[]
["2W6W-01-0221",null,null,null,null,null,"TOTAAL :",{"$f":"SUM(H107:H115)","v":28800},{"$f":"SUM(I107:I115)","v":28800},{"$f":"H117-I117","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Date : 26-08-2011"]
[]
["Beschrijving artikel (PPnr 55254)",null,null,null,null,null,null,"Open formaat","478,00 x 214,00 mm"]
["Code:","9F9G-01-0223",null,null,null,null,null,"Gesloten formaat","80,00 x 27 mm"]
["Type",null,null,null,null,null,null,"Kleur R/V","1/1"]
[null,null,null,null,null,null,null,"Grammage","40gr"]
[null,null,null,null,null,null,null,"Status","A"]
["Ordernr","PBnr PP","Voorraadbon","Leveringsdatum","Te produceren","Af te roepen","Uit welke","Reëel geproduceerd","Reëel geleverd","Resterende stock"]
["klant",null,"Afroepbon",null,"aantal","aantal","Voorraadbon","aantal","aantal","per VB"]
[]
["test",296784,"Voorraadbon","2011-11-10",28800,null,null,28800,null,{"$f":"H131-I131","v":28800}]
["test",299311,"Afroepbon","2011-11-23",null,23040,296784,null,23040,-23040]
["test",300801,"Voorraadbon","2012-01-10",57600,null,null,59160,null,59160]
["test",300855,"Afroepbon","2012-01-17",null,31680,"296784+300801",null,31680,-31680]
["test",305077,"Afroepbon","2012-04-10",null,33240,300801,null,33240,-33240]
["test",306117,"Voorraadbon","2012-05-22",89280,null,null,89280,null,89280]
["test",306178,"Afroepbon","2012-05-29",null,34560,306117,null,34560,-34560]
["test",308725,"Afroepbon","2012-07-24",null,14400,306117,null,14400,-14400]
["test",309419,"Afroepbon","2012-08-14",null,40320,306117,null,40320,-40320]
["test",314654,"Voorraadbon","2013-02-05",34560,null,null,38400,null,38400]
["test",315744,"Afroepbon","2013-02-12",null,17280,314654,null,17280,-17280]
["test",317605,"Afroepbon","2013-03-12",null,21120,314654,null,21120,-21120]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J131:J142)","v":0}]
[]
["9F9G-01-0223",null,null,null,null,null,"TOTAAL :",{"$f":"SUM(H131:H143)","v":215640},{"$f":"SUM(I131:I143)","v":215640},{"$f":"H145-I145","v":0}]

{"sheet":"blanco","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}