{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Voorblad","Reviews","Berekeningen","Ovz1","Ovz2"],"not_rendered":{"charts":4,"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 -  Reviews"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2023, G-Info/G. Verbruggen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"www.ginfo.nl"]

{"sheet":"Reviews","index":1,"n_rows":102,"n_cols":11,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Aanbieding","ReviewerID","Rating",null,"Filter/geavanceerd",null,"dubbel verwijderen",null,"draaitabel"]
[null,"Samsung Galaxy Xcover 6 Pro",367033,3]
[null,"Overprikkeld brein",642235,1,null,"Aanbieding",null,"Aanbieding",null,"Aanbieding","Gemiddelde van Rating"]
[null,"LEGO Marvel Eternals",863821,3,null,"Samsung Galaxy Xcover 6 Pro",null,"Samsung Galaxy Xcover 6 Pro",null,"Bruder - Linde Gaffeltruck",2.5454545454545454]
[null,"Sonos Soundbar Zwart",379860,1,null,"Overprikkeld brein",null,"Overprikkeld brein",null,"Fitbit Sense",2.6]
[null,"Sylvanian Families babybus",180813,1,null,"LEGO Marvel Eternals",null,"LEGO Marvel Eternals",null,"Kernkwadrantenspel",1.1666666666666667]
[null,"Fitbit Sense",103869,5,null,"Sonos Soundbar Zwart",null,"Sonos Soundbar Zwart",null,"LEGO Marvel Eternals",3.1428571428571428]
[null,"Kernkwadrantenspel",622721,1,null,"Sylvanian Families babybus",null,"Sylvanian Families babybus",null,"Lenovo tablet Tab M10",2.9090909090909092]
[null,"Lenovo tablet Tab M10",926739,2,null,"Fitbit Sense",null,"Fitbit Sense",null,"Overprikkeld brein",2.8333333333333335]
[null,"Bruder - Linde Gaffeltruck",884437,1,null,"Kernkwadrantenspel",null,"Kernkwadrantenspel",null,"Samsung Galaxy Xcover 6 Pro",3.8125]
[null,"Samsung Galaxy Xcover 6 Pro",326907,5,null,"Lenovo tablet Tab M10",null,"Lenovo tablet Tab M10",null,"Sonos Soundbar Zwart",3]
[null,"Samsung Galaxy Xcover 6 Pro",564982,4,null,"Bruder - Linde Gaffeltruck",null,"Bruder - Linde Gaffeltruck",null,"Sylvanian Families babybus",2.3333333333333335]
[null,"Overprikkeld brein",311814,4,null,"Samsung Galaxy Xcover 6 Pro",null,null,null,"Eindtotaal",2.88]
[null,"LEGO Marvel Eternals",103709,4]
[null,"LEGO Marvel Eternals",572937,1,null,"waarom laatste nog een keer??"]
[null,"Sonos Soundbar Zwart",752215,2]
[null,"Fitbit Sense",586548,3]
[null,"Bruder - Linde Gaffeltruck",413521,2]
[null,"Bruder - Linde Gaffeltruck",826735,4]
[null,"Overprikkeld brein",507621,2]
[null,"LEGO Marvel Eternals",161504,3]
[null,"Fitbit Sense",672701,3]
[null,"LEGO Marvel Eternals",786683,5]
[null,"Overprikkeld brein",729402,3]
[null,"Lenovo tablet Tab M10",169415,4]
[null,"Lenovo tablet Tab M10",317030,3]
[null,"Overprikkeld brein",291315,1]
[null,"Sonos Soundbar Zwart",706589,3]
[null,"Bruder - Linde Gaffeltruck",999985,2]
[null,"Sylvanian Families babybus",925256,4]
[null,"LEGO Marvel Eternals",182321,2]
[null,"Overprikkeld brein",839977,3]
[null,"Overprikkeld brein",827407,1]
[null,"Kernkwadrantenspel",944988,1]
[null,"Bruder - Linde Gaffeltruck",558078,4]
[null,"Samsung Galaxy Xcover 6 Pro",358991,4]
[null,"Fitbit Sense",845564,1]
[null,"Samsung Galaxy Xcover 6 Pro",498991,1]
[null,"Lenovo tablet Tab M10",252982,1]
[null,"Sonos Soundbar Zwart",788157,1]
[null,"Overprikkeld brein",534731,4]
[null,"Sonos Soundbar Zwart",368364,2]
[null,"Sonos Soundbar Zwart",766175,2]
[null,"Samsung Galaxy Xcover 6 Pro",757473,3]
[null,"LEGO Marvel Eternals",769924,5]
[null,"Kernkwadrantenspel",217580,1]
[null,"LEGO Marvel Eternals",363007,4]
[null,"LEGO Marvel Eternals",772180,2]
[null,"Sylvanian Families babybus",418052,4]
[null,"Sonos Soundbar Zwart",762068,5]
[null,"Samsung Galaxy Xcover 6 Pro",254900,4]
[null,"Bruder - Linde Gaffeltruck",932850,1]
[null,"Lenovo tablet Tab M10",647580,2]
[null,"Overprikkeld brein",608222,3]
[null,"Lenovo tablet Tab M10",317230,3]
[null,"Bruder - Linde Gaffeltruck",853468,5]
[null,"Kernkwadrantenspel",788246,1]
[null,"Lenovo tablet Tab M10",861386,1]
[null,"Sylvanian Families babybus",966446,1]
[null,"Samsung Galaxy Xcover 6 Pro",299622,3]
[null,"Fitbit Sense",958723,1]
[null,"LEGO Marvel Eternals",405722,5]
[null,"Sylvanian Families babybus",419673,1]
[null,"Sonos Soundbar Zwart",328189,3]
[null,"Samsung Galaxy Xcover 6 Pro",271711,4]
[null,"Sonos Soundbar Zwart",981665,4]
[null,"Lenovo tablet Tab M10",334791,5]
[null,"Samsung Galaxy Xcover 6 Pro",545797,3]
[null,"Sylvanian Families babybus",529482,2]
[null,"Samsung Galaxy Xcover 6 Pro",710085,4]
[null,"Kernkwadrantenspel",732167,1]
[null,"Sylvanian Families babybus",873568,1]
[null,"Sylvanian Families babybus",371327,3]
[null,"Samsung Galaxy Xcover 6 Pro",664058,5]
[null,"Lenovo tablet Tab M10",707392,4]
[null,"Kernkwadrantenspel",250166,2]
[null,"Sonos Soundbar Zwart",805970,3]
[null,"Lenovo tablet Tab M10",728333,3]
[null,"Overprikkeld brein",999554,2]
[null,"Samsung Galaxy Xcover 6 Pro",720066,4]
[null,"Sonos Soundbar Zwart",651981,5]
[null,"Overprikkeld brein",620209,5]
[null,"Samsung Galaxy Xcover 6 Pro",942286,5]
[null,"Bruder - Linde Gaffeltruck",451505,1]
[null,"Samsung Galaxy Xcover 6 Pro",309484,5]
[null,"Lenovo tablet Tab M10",860403,4]
[null,"Sonos Soundbar Zwart",601657,5]
[null,"LEGO Marvel Eternals",739108,1]
[null,"Overprikkeld brein",990237,5]
[null,"LEGO Marvel Eternals",917890,2]
[null,"Sonos Soundbar Zwart",533525,2]
[null,"Sylvanian Families babybus",123532,4]
[null,"LEGO Marvel Eternals",254947,2]
[null,"LEGO Marvel Eternals",410201,5]
[null,"Bruder - Linde Gaffeltruck",469976,2]
[null,"Sonos Soundbar Zwart",214933,1]
[null,"Samsung Galaxy Xcover 6 Pro",875839,4]
[null,"Bruder - Linde Gaffeltruck",230722,1]
[null,"Bruder - Linde Gaffeltruck",893916,5]
[null,"Sonos Soundbar Zwart",371124,4]
[null,"Sonos Soundbar Zwart",422360,5]

{"sheet":"Berekeningen","index":2,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,5,15,7]]}
[]
[null,"AanbNr",1,{"$f":"INDEX(lstAanbiedingen,aanbNr)","v":"Bruder - Linde Gaffeltruck"}]
[]
[null,null,"Aantal","Totaal"]
[null,1,{"$f":"COUNTIFS(tblReviews[Aanbieding],aanbNm,tblReviews[Rating],B5)","v":4},{"$f":"$C$10","v":11}]
[null,2,{"$f":"COUNTIFS(tblReviews[Aanbieding],aanbNm,tblReviews[Rating],B6)","v":3},{"$f":"$C$10","v":11}]
[null,3,{"$f":"COUNTIFS(tblReviews[Aanbieding],aanbNm,tblReviews[Rating],B7)","v":0},{"$f":"$C$10","v":11}]
[null,4,{"$f":"COUNTIFS(tblReviews[Aanbieding],aanbNm,tblReviews[Rating],B8)","v":2},{"$f":"$C$10","v":11}]
[null,5,{"$f":"COUNTIFS(tblReviews[Aanbieding],aanbNm,tblReviews[Rating],B9)","v":2},{"$f":"$C$10","v":11}]
[null,null,{"$f":"SUM(C5:C9)","v":11}]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Ratings"]
[null,null,null,null,null,"\u0098","\u009b","\u009a"]

{"sheet":"Ovz1","index":3,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,6,1,10]]}
[]
[null,null,"Aanbieding",null,"Rating",null,{"$f":"\"Reviews voor \"&aanbNm","v":"Reviews voor Bruder - Linde Gaffeltruck"}]
[null,null,"Bruder - Linde Gaffeltruck",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C3,tblReviews[Rating])","v":2.5454545454545454},{"$f":"REPT(crkVol,TRUNC(D3+0.25))&REPT(crkHalf,IF(AND(MOD(D3,1)>0.25,MOD(D3,1)<0.75),1,0))&REPT(crkLeeg,TRUNC(5-(D3-0.25)))","v":"\u0098\u0098\u009b\u009a\u009a"}]
[null,null,"Fitbit Sense",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C4,tblReviews[Rating])","v":2.6},"\u0098\u0098\u009b\u009a\u009a"]
[null,null,"Kernkwadrantenspel",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C5,tblReviews[Rating])","v":1.1666666666666667},"\u0098\u009a\u009a\u009a\u009a"]
[null,null,"LEGO Marvel Eternals",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C6,tblReviews[Rating])","v":3.1428571428571428},"\u0098\u0098\u0098\u009a\u009a"]
[null,null,"Lenovo tablet Tab M10",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C7,tblReviews[Rating])","v":2.9090909090909092},"\u0098\u0098\u0098\u009a\u009a"]
[null,null,"Overprikkeld brein",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C8,tblReviews[Rating])","v":2.8333333333333335},"\u0098\u0098\u0098\u009a\u009a"]
[null,null,"Samsung Galaxy Xcover 6 Pro",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C9,tblReviews[Rating])","v":3.8125},"\u0098\u0098\u0098\u0098\u009a"]
[null,null,"Sonos Soundbar Zwart",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C10,tblReviews[Rating])","v":3},"\u0098\u0098\u0098\u009a\u009a"]
[null,null,"Sylvanian Families babybus",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C11,tblReviews[Rating])","v":2.3333333333333335},"\u0098\u0098\u009b\u009a\u009a"]
[]
[]
[]
[]
[]
[null,null,null,null,"lettertype Wingdings2"]

{"sheet":"Ovz2","index":4,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,6,1,10]]}
[]
[null,null,"Aanbieding",null,"Rating",null,{"$f":"\"Reviews voor \"&aanbNm","v":"Reviews voor Bruder - Linde Gaffeltruck"}]
[null,null,"Bruder - Linde Gaffeltruck",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C3,tblReviews[Rating])","v":2.5454545454545454},{"$f":"REPT(crkVol,TRUNC(D3+0.25))&REPT(crkHalf,IF(AND(MOD(D3,1)>0.25,MOD(D3,1)<0.75),1,0))&REPT(crkLeeg,TRUNC(5-(D3-0.25)))","v":"\u0098\u0098\u009b\u009a\u009a"}]
[null,null,"Fitbit Sense",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C4,tblReviews[Rating])","v":2.6},"\u0098\u0098\u009b\u009a\u009a"]
[null,null,"Kernkwadrantenspel",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C5,tblReviews[Rating])","v":1.1666666666666667},"\u0098\u009a\u009a\u009a\u009a"]
[null,null,"LEGO Marvel Eternals",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C6,tblReviews[Rating])","v":3.1428571428571428},"\u0098\u0098\u0098\u009a\u009a"]
[null,null,"Lenovo tablet Tab M10",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C7,tblReviews[Rating])","v":2.9090909090909092},"\u0098\u0098\u0098\u009a\u009a"]
[null,null,"Overprikkeld brein",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C8,tblReviews[Rating])","v":2.8333333333333335},"\u0098\u0098\u0098\u009a\u009a"]
[null,null,"Samsung Galaxy Xcover 6 Pro",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C9,tblReviews[Rating])","v":3.8125},"\u0098\u0098\u0098\u0098\u009a"]
[null,null,"Sonos Soundbar Zwart",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C10,tblReviews[Rating])","v":3},"\u0098\u0098\u0098\u009a\u009a"]
[null,null,"Sylvanian Families babybus",{"$f":"AVERAGEIF(tblReviews[Aanbieding],C11,tblReviews[Rating])","v":2.3333333333333335},"\u0098\u0098\u009b\u009a\u009a"]