{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Voorblad","Basis","Basis2","Result"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":1},"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":"Voorblad","index":0,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Voorbeeld materiaal -  Grafiek opmaken"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2018, G-Info/G. Verbruggen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"www.ginfo.nl"]

{"sheet":"Basis","index":1,"n_rows":103,"n_cols":5,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[null,"Random-bestand maken: ","mockaroo.com"]
[]
[null,"Soort","Datum","Omschr","Bedrag"]
[null,"NYSE","2018-07-01","Lyssa",1165.48]
[null,"NYSE","2018-07-17","Rosette",1831.52]
[null,"NYSE","2018-05-06","Herman",1228.74]
[null,"NASDAQ","2018-08-09","Bryn",1670.21]
[null,"NYSE","2018-02-27","Candice",1149.78]
[null,"NYSE","2018-06-06","Harriett",1040.53]
[null,"NASDAQ","2018-07-13","Barret",1928.46]
[null,"NYSE","2018-11-19","Marilyn",1997.64]
[null,"NYSE","2018-07-18","Travis",1778.82]
[null,"NASDAQ","2018-08-17","Henry",1617.38]
[null,"NYSE","2018-05-06","Violetta",1945.62]
[null,"NASDAQ","2018-12-27","Tresa",1457.39]
[null,"NASDAQ","2018-09-29","Tiebold",1634.41]
[null,"NYSE","2018-06-20","Kimberly",1072.49]
[null,"NASDAQ","2018-11-06","Yasmeen",1098.99]
[null,"NASDAQ","2018-07-13","Lottie",1623.29]
[null,"NASDAQ","2018-03-21","Darcy",1105.05]
[null,"NASDAQ","2018-01-19","Howie",1342.69]
[null,"NYSE","2018-01-16","Sheelah",1443.96]
[null,"NYSE","2018-12-08","Octavia",1185.18]
[null,"NASDAQ","2018-05-22","Keenan",1968.02]
[null,"NYSE","2018-09-09","Noella",1297.83]
[null,"NASDAQ","2018-10-19","Carolynn",1204.0899999999999]
[null,"NASDAQ","2018-10-16","Tull",1288.19]
[null,"NASDAQ","2018-05-11","Wilmette",1829.95]
[null,"NYSE","2018-06-08","Bili",1955.45]
[null,"NASDAQ","2018-11-15","Farlee",1077.01]
[null,"NYSE","2018-01-12","Etty",1455.49]
[null,"NASDAQ","2018-04-03","Jonell",1894.02]
[null,"NASDAQ","2018-02-18","Tomasina",1514.99]
[null,"NYSE","2018-07-03","Max",1739.71]
[null,"NYSE","2018-02-25","Cassie",1836]
[null,"NYSE","2018-04-05","Winna",1955.94]
[null,"NASDAQ","2018-10-14","Bale",1773.48]
[null,"NASDAQ","2018-04-13","Giuseppe",1597.77]
[null,"NYSE","2018-06-26","Iggie",1742.27]
[null,"NASDAQ","2018-12-22","Stefa",1448.31]
[null,"NYSE","2018-02-16","Liv",1213.98]
[null,"NASDAQ","2018-02-13","Tobin",1731.5]
[null,"NYSE","2018-11-03","Cele",1886.9]
[null,"NYSE","2018-04-03","Bil",1492.55]
[null,"NYSE","2018-10-13","Bernie",1999.4]
[null,"NYSE","2018-07-09","Amabelle",1173.75]
[null,"NASDAQ","2018-09-21","Alphard",1250.42]
[null,"NASDAQ","2018-08-28","Georgianne",1876.37]
[null,"NYSE","2018-04-18","Wye",1273.8399999999999]
[null,"NYSE","2018-03-11","Ruprecht",1843.03]
[null,"NYSE","2018-05-20","Stewart",1465.89]
[null,"NASDAQ","2018-08-01","Arlena",1828.47]
[null,"NASDAQ","2018-02-13","Bruce",1051.43]
[null,"NASDAQ","2018-05-17","Robin",1877.89]
[null,"NYSE","2018-02-25","Devonna",1252.76]
[null,"NYSE","2018-04-05","Percival",1885.73]
[null,"NYSE","2018-11-03","Esme",1463.95]
[null,"NYSE","2018-07-05","Malissa",1727.21]
[null,"NASDAQ","2018-11-10","Jeana",1215.58]
[null,"NYSE","2018-10-28","Dotti",1326.98]
[null,"NASDAQ","2018-06-10","Florie",1398.34]
[null,"NASDAQ","2018-04-01","Corine",1030]
[null,"NASDAQ","2018-12-25","Lonnie",1534.08]
[null,"NASDAQ","2018-04-01","Hillyer",1868.34]
[null,"NYSE","2018-08-28","Arther",1468.31]
[null,"NASDAQ","2018-07-28","Nikaniki",1449.4]
[null,"NASDAQ","2018-02-04","Ringo",1366.89]
[null,"NASDAQ","2018-06-28","Felipe",1875.51]
[null,"NYSE","2018-12-13","Wanda",1133.22]
[null,"NASDAQ","2018-11-11","Bobbi",1506.42]
[null,"NYSE","2018-01-25","Cristobal",1333.01]
[null,"NYSE","2018-04-09","Tania",1662.66]
[null,"NASDAQ","2018-03-01","Hatty",1484.42]
[null,"NASDAQ","2018-02-18","Manon",1860.63]
[null,"NYSE","2018-09-11","Matthew",1463.22]
[null,"NYSE","2018-08-04","Cody",1166.07]
[null,"NASDAQ","2018-06-14","Ariel",1396.39]
[null,"NYSE","2018-12-23","Channa",1696.74]
[null,"NYSE","2018-03-25","Delmore",1885.13]
[null,"NYSE","2018-08-05","Gasper",1412.65]
[null,"NYSE","2018-07-22","Rianon",1830.67]
[null,"NYSE","2018-06-06","Sheila",1851.12]
[null,"NYSE","2018-01-27","Giavani",1906.92]
[null,"NASDAQ","2018-08-11","Larissa",1604.47]
[null,"NASDAQ","2018-12-09","Elihu",1228.93]
[null,"NASDAQ","2018-01-11","Georgetta",1536.97]
[null,"NYSE","2018-08-15","Bernelle",1610.74]
[null,"NYSE","2018-05-13","Stanwood",1496.67]
[null,"NYSE","2018-12-25","Reginald",1494.31]
[null,"NASDAQ","2018-03-10","Edie",1502.19]
[null,"NYSE","2018-07-01","Lyman",1602.41]
[null,"NASDAQ","2018-09-27","Montgomery",1292.96]
[null,"NYSE","2018-10-15","Brent",1210.92]
[null,"NYSE","2018-11-24","Mark",1775.75]
[null,"NYSE","2018-10-15","Phineas",1705.63]
[null,"NASDAQ","2018-12-24","Linzy",1663.44]
[null,"NYSE","2018-04-19","Carlee",1070.3499999999999]
[null,"NYSE","2018-07-23","Norby",1098.6400000000001]
[null,"NYSE","2018-03-14","Dar",1969.36]
[null,"NYSE","2018-09-25","Cornelle",1493.98]
[null,"NASDAQ","2018-11-06","Imojean",1098.48]
[null,"NYSE","2018-05-25","Garvy",1076.6199999999999]
[null,"NASDAQ","2018-06-10","Standford",1662.81]

{"sheet":"Basis2","index":2,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Soort","Datum","Omschr","Bedrag"]
[null,"NASDAQ","2018-01-19","Howie",1342.69]
[null,"NYSE","2018-03-16","Sheelah",1443.96]
[null,"NASDAQ","2018-03-21","Darcy",1105.05]
[null,"NYSE","2018-04-27","Candice",1149.78]
[null,"NYSE","2018-05-06","Herman",1228.74]
[null,"NYSE","2018-05-08","Violetta",1945.62]
[null,"NASDAQ","2018-05-22","Keenan",1768.02]
[null,"NYSE","2018-06-06","Harriett",1540.53]
[null,"NYSE","2018-07-01","Lyssa",1165.48]
[null,"NASDAQ","2018-07-13","Barret",1728.46]
[null,"NASDAQ","2018-07-14","Lottie",1623.29]
[null,"NYSE","2018-07-17","Rosette",1831.52]
[null,"NYSE","2018-07-18","Travis",1778.82]
[null,"NASDAQ","2018-08-09","Bryn",1670.21]
[null,"NASDAQ","2018-08-17","Henry",1617.38]
[null,"NASDAQ","2018-09-29","Tiebold",1634.41]
[null,"NASDAQ","2018-10-06","Yasmeen",1098.99]
[null,"NASDAQ","2018-10-27","Tresa",1457.39]
[null,"NYSE","2018-11-19","Marilyn",1997.64]
[null,"NYSE","2018-12-08","Octavia",1185.18]

{"sheet":"Result","index":3,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Soort","NASDAQ",null,null,"x-min",{"$f":"MIN(B:B)","v":"2018-01-19"},{"$f":"DATE(YEAR(G2),MONTH(G2),1)","v":"2018-01-01"},"y-min",{"$f":"MIN(D:D)","v":1098.99},{"$f":"TRUNC(J2/100)*100","v":1000},null,"Titel:",{"$f":"\"Bedragen van \"&C2","v":"Bedragen van NASDAQ"}]
[null,null,null,null,null,"x-max",{"$f":"MAX(B:B)","v":"2018-10-27"},{"$f":"DATE(YEAR(G3),MONTH(G3)+1,1)","v":"2018-11-01"},"y-max",{"$f":"MAX(D:D)","v":1768.02},{"$f":"(TRUNC(J3/100)+1)*100","v":1800}]
[null,"Som van Bedrag"]
[null,"Datum","Omschr","Totaal"]
[null,"2018-01-19","Howie",1342.69]
[null,"2018-03-21","Darcy",1105.05]
[null,"2018-05-22","Keenan",1768.02]
[null,"2018-07-13","Barret",1728.46]
[null,"2018-07-14","Lottie",1623.29]
[null,"2018-08-09","Bryn",1670.21]
[null,"2018-08-17","Henry",1617.38]
[null,"2018-09-29","Tiebold",1634.41]
[null,"2018-10-06","Yasmeen",1098.99]
[null,"2018-10-27","Tresa",1457.39]