{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["analysis","data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"analysis","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Drill Down by Double Clicking",null,null,null,"www.clearlyandsimply.com"]
[]
[null,"Size","from","to","Counts","Revenues"]
[null,"Single Pallets",1,1,{"$f":"SUM((data!$C$6:$C$505>=$C5)*(data!$C$6:$C$505<=$D5))","v":18},{"$f":"SUM((data!$C$6:$C$505>=$C5)*(data!$C$6:$C$505<=$D5)*data!$D$6:$D$505)","v":3107}]
[null,"Pallets 2 - 5",2,5,{"$f":"SUM((data!$C$6:$C$505>=$C6)*(data!$C$6:$C$505<=$D6))","v":85},{"$f":"SUM((data!$C$6:$C$505>=$C6)*(data!$C$6:$C$505<=$D6)*data!$D$6:$D$505)","v":53958}]
[null,"Pallets 6 - 9",6,9,{"$f":"SUM((data!$C$6:$C$505>=$C7)*(data!$C$6:$C$505<=$D7))","v":74},{"$f":"SUM((data!$C$6:$C$505>=$C7)*(data!$C$6:$C$505<=$D7)*data!$D$6:$D$505)","v":91499}]
[null,"Pallets 10 - 13",10,13,{"$f":"SUM((data!$C$6:$C$505>=$C8)*(data!$C$6:$C$505<=$D8))","v":62},{"$f":"SUM((data!$C$6:$C$505>=$C8)*(data!$C$6:$C$505<=$D8)*data!$D$6:$D$505)","v":138324}]
[null,"Pallets 14 - 17",14,17,{"$f":"SUM((data!$C$6:$C$505>=$C9)*(data!$C$6:$C$505<=$D9))","v":67},{"$f":"SUM((data!$C$6:$C$505>=$C9)*(data!$C$6:$C$505<=$D9)*data!$D$6:$D$505)","v":186775}]
[null,"Full Loads (18 - 26 pallets)",18,26,{"$f":"SUM((data!$C$6:$C$505>=$C10)*(data!$C$6:$C$505<=$D10))","v":194},{"$f":"SUM((data!$C$6:$C$505>=$C10)*(data!$C$6:$C$505<=$D10)*data!$D$6:$D$505)","v":731669}]
[]
[null,null,null,null,null,"Double click a row (any column) in the overview table to drill down to the data"]

{"sheet":"data","index":1,"n_rows":505,"n_cols":4,"rows_kept":505,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Data",null,"www.clearlyandsimply.com"]
[]
[null,null,{"$f":"SUBTOTAL(2,C6:C505)","v":500},{"$f":"SUBTOTAL(9,D6:D505)","v":1205332}]
[null,"Quote","Size in pallets","Revenue"]
[null,"Quote 1",8,1208]
[null,"Quote 2",3,270]
[null,"Quote 3",14,2016]
[null,"Quote 4",22,3058]
[null,"Quote 5",4,700]
[null,"Quote 6",12,2940]
[null,"Quote 7",9,1359]
[null,"Quote 8",6,456]
[null,"Quote 9",3,615]
[null,"Quote 10",10,2470]
[null,"Quote 11",2,172]
[null,"Quote 12",9,486]
[null,"Quote 13",24,4368]
[null,"Quote 14",21,1554]
[null,"Quote 15",14,1568]
[null,"Quote 16",12,2820]
[null,"Quote 17",19,2964]
[null,"Quote 18",14,2086]
[null,"Quote 19",17,952]
[null,"Quote 20",16,2128]
[null,"Quote 21",8,1904]
[null,"Quote 22",24,2808]
[null,"Quote 23",25,6625]
[null,"Quote 24",4,260]
[null,"Quote 25",25,6650]
[null,"Quote 26",9,1305]
[null,"Quote 27",15,2685]
[null,"Quote 28",11,1738]
[null,"Quote 29",26,7566]
[null,"Quote 30",4,312]
[null,"Quote 31",3,783]
[null,"Quote 32",23,3519]
[null,"Quote 33",6,1548]
[null,"Quote 34",7,1281]
[null,"Quote 35",19,4047]
[null,"Quote 36",3,771]
[null,"Quote 37",24,6240]
[null,"Quote 38",21,1071]
[null,"Quote 39",23,2737]
[null,"Quote 40",14,1330]
[null,"Quote 41",7,763]
[null,"Quote 42",22,1584]
[null,"Quote 43",20,1340]
[null,"Quote 44",22,4092]
[null,"Quote 45",5,1385]
[null,"Quote 46",13,2938]
[null,"Quote 47",7,441]
[null,"Quote 48",24,3312]
[null,"Quote 49",13,3185]
[null,"Quote 50",7,1631]
[null,"Quote 51",8,2280]
[null,"Quote 52",6,1344]
[null,"Quote 53",25,6025]
[null,"Quote 54",10,1520]
[null,"Quote 55",17,1190]
[null,"Quote 56",2,236]
[null,"Quote 57",8,936]
[null,"Quote 58",10,650]
[null,"Quote 59",5,480]
[null,"Quote 60",11,2596]
[null,"Quote 61",9,1350]
[null,"Quote 62",19,3572]
[null,"Quote 63",5,530]
[null,"Quote 64",4,888]
[null,"Quote 65",14,2408]
[null,"Quote 66",5,845]
[null,"Quote 67",5,1475]
[null,"Quote 68",10,1350]
[null,"Quote 69",18,972]
[null,"Quote 70",9,1008]
[null,"Quote 71",21,3801]
[null,"Quote 72",11,1342]
[null,"Quote 73",2,106]
[null,"Quote 74",24,2136]
[null,"Quote 75",10,2750]
[null,"Quote 76",21,4389]
[null,"Quote 77",3,243]
[null,"Quote 78",24,1464]
[null,"Quote 79",13,1794]
[null,"Quote 80",16,2624]
[null,"Quote 81",26,2470]
[null,"Quote 82",3,744]
[null,"Quote 83",20,3120]
[null,"Quote 84",9,1107]
[null,"Quote 85",23,1265]
[null,"Quote 86",21,4683]
[null,"Quote 87",2,158]
[null,"Quote 88",22,4466]
[null,"Quote 89",3,846]
[null,"Quote 90",8,2368]
[null,"Quote 91",24,2448]
[null,"Quote 92",19,4199]
[null,"Quote 93",15,2100]
[null,"Quote 94",20,2600]
[null,"Quote 95",21,5586]
[null,"Quote 96",6,732]
[null,"Quote 97",2,152]
[null,"Quote 98",7,2079]
[null,"Quote 99",26,7410]
[null,"Quote 100",5,365]
[null,"Quote 101",1,290]
[null,"Quote 102",7,1435]
[null,"Quote 103",11,649]
[null,"Quote 104",9,531]
[null,"Quote 105",3,192]
[null,"Quote 106",25,7400]
[null,"Quote 107",9,2016]
[null,"Quote 108",15,2715]
[null,"Quote 109",3,573]
[null,"Quote 110",9,1053]
[null,"Quote 111",16,3040]
[null,"Quote 112",2,254]
[null,"Quote 113",6,1434]
[null,"Quote 114",25,4350]
[null,"Quote 115",22,1804]
[null,"Quote 116",6,690]
[null,"Quote 117",16,3776]
[null,"Quote 118",2,362]
[null,"Quote 119",18,3258]
[null,"Quote 120",21,2079]
[null,"Quote 121",17,4216]
[null,"Quote 122",26,5746]
[null,"Quote 123",23,5888]
[null,"Quote 124",22,1826]
[null,"Quote 125",16,2640]
[null,"Quote 126",1,210]
[null,"Quote 127",22,1584]
[null,"Quote 128",19,2717]
[null,"Quote 129",24,3312]
[null,"Quote 130",11,2794]
[null,"Quote 131",5,915]
[null,"Quote 132",15,2700]
[null,"Quote 133",2,224]
[null,"Quote 134",10,740]
[null,"Quote 135",22,5060]
[null,"Quote 136",11,2794]
[null,"Quote 137",24,4776]
[null,"Quote 138",6,336]
[null,"Quote 139",13,3393]
[null,"Quote 140",1,52]
[null,"Quote 141",26,6344]
[null,"Quote 142",21,1071]
[null,"Quote 143",9,1170]
[null,"Quote 144",20,2480]
[null,"Quote 145",25,3325]
[null,"Quote 146",10,910]
[null,"Quote 147",8,1448]
[null,"Quote 148",21,2058]
[null,"Quote 149",11,1023]
[null,"Quote 150",25,2700]
[null,"Quote 151",7,350]
[null,"Quote 152",22,2882]
[null,"Quote 153",12,3276]
[null,"Quote 154",19,3268]
[null,"Quote 155",22,4774]
[null,"Quote 156",19,5358]
[null,"Quote 157",23,2944]
[null,"Quote 158",8,1736]
[null,"Quote 159",10,790]
[null,"Quote 160",3,426]
[null,"Quote 161",12,2880]
[null,"Quote 162",15,4260]
[null,"Quote 163",18,3834]
[null,"Quote 164",17,4879]
[null,"Quote 165",1,150]
[null,"Quote 166",5,960]
[null,"Quote 167",9,1674]
[null,"Quote 168",23,2967]
[null,"Quote 169",19,3857]
[null,"Quote 170",11,2211]
[null,"Quote 171",24,2208]
[null,"Quote 172",1,296]
[null,"Quote 173",20,2040]
[null,"Quote 174",3,153]
[null,"Quote 175",1,146]
[null,"Quote 176",24,6888]
[null,"Quote 177",16,3632]
[null,"Quote 178",1,137]
[null,"Quote 179",7,1225]
[null,"Quote 180",15,3810]
[null,"Quote 181",6,468]
[null,"Quote 182",14,1876]
[null,"Quote 183",18,1944]
[null,"Quote 184",5,1245]
[null,"Quote 185",1,249]
[null,"Quote 186",8,944]
[null,"Quote 187",22,3322]
[null,"Quote 188",18,1548]
[null,"Quote 189",14,3934]
[null,"Quote 190",3,594]
[null,"Quote 191",11,2486]
[null,"Quote 192",5,1475]
[null,"Quote 193",18,4230]
[null,"Quote 194",18,2394]
[null,"Quote 195",4,1028]
[null,"Quote 196",26,4212]
[null,"Quote 197",6,1290]
[null,"Quote 198",16,3952]
[null,"Quote 199",18,1512]
[null,"Quote 200",5,940]
[null,"Quote 201",26,1300]
[null,"Quote 202",15,2415]
[null,"Quote 203",21,4872]
[null,"Quote 204",20,4640]
[null,"Quote 205",16,2288]
[null,"Quote 206",25,5050]
[null,"Quote 207",24,5160]
[null,"Quote 208",22,5082]
[null,"Quote 209",22,3630]
[null,"Quote 210",8,960]
[null,"Quote 211",6,1164]
[null,"Quote 212",20,5760]
[null,"Quote 213",4,816]
[null,"Quote 214",3,360]
[null,"Quote 215",18,2250]
[null,"Quote 216",6,1122]
[null,"Quote 217",23,1311]
[null,"Quote 218",19,2204]
[null,"Quote 219",3,783]
[null,"Quote 220",16,2528]
[null,"Quote 221",2,330]
[null,"Quote 222",24,5592]
[null,"Quote 223",2,450]
[null,"Quote 224",10,1140]
[null,"Quote 225",21,3570]
[null,"Quote 226",23,2622]
[null,"Quote 227",21,4137]
[null,"Quote 228",1,146]
[null,"Quote 229",24,3072]
[null,"Quote 230",15,2535]
[null,"Quote 231",7,567]
[null,"Quote 232",13,715]
[null,"Quote 233",26,3562]
[null,"Quote 234",25,6100]
[null,"Quote 235",18,3852]
[null,"Quote 236",14,3416]
[null,"Quote 237",22,1386]
[null,"Quote 238",11,2959]
[null,"Quote 239",16,4096]
[null,"Quote 240",4,1148]
[null,"Quote 241",5,945]
[null,"Quote 242",12,2928]
[null,"Quote 243",20,2120]
[null,"Quote 244",1,289]
[null,"Quote 245",5,1060]
[null,"Quote 246",20,1500]
[null,"Quote 247",26,3978]
[null,"Quote 248",16,3952]
[null,"Quote 249",5,1055]
[null,"Quote 250",6,930]
[null,"Quote 251",20,5260]
[null,"Quote 252",13,2028]
[null,"Quote 253",15,1455]
[null,"Quote 254",9,2070]
[null,"Quote 255",26,6162]
[null,"Quote 256",4,900]
[null,"Quote 257",6,768]
[null,"Quote 258",18,4626]
[null,"Quote 259",2,248]
[null,"Quote 260",9,1962]
[null,"Quote 261",17,4080]
[null,"Quote 262",9,1251]
[null,"Quote 263",20,4480]
[null,"Quote 264",9,1116]
[null,"Quote 265",25,1900]
[null,"Quote 266",8,488]
[null,"Quote 267",21,4389]
[null,"Quote 268",17,1513]
[null,"Quote 269",2,214]
[null,"Quote 270",23,2139]
[null,"Quote 271",17,2074]
[null,"Quote 272",16,4000]
[null,"Quote 273",22,4576]
[null,"Quote 274",13,3757]
[null,"Quote 275",1,80]
[null,"Quote 276",24,6744]
[null,"Quote 277",21,1344]
[null,"Quote 278",5,340]
[null,"Quote 279",6,300]
[null,"Quote 280",20,5180]
[null,"Quote 281",25,6300]
[null,"Quote 282",20,1620]
[null,"Quote 283",1,178]
[null,"Quote 284",11,1980]
[null,"Quote 285",24,1488]
[null,"Quote 286",16,3536]
[null,"Quote 287",21,2079]
[null,"Quote 288",13,1352]
[null,"Quote 289",5,835]
[null,"Quote 290",22,6182]
[null,"Quote 291",4,1120]
[null,"Quote 292",17,3757]
[null,"Quote 293",21,2793]
[null,"Quote 294",16,3360]
[null,"Quote 295",19,2014]
[null,"Quote 296",10,1640]
[null,"Quote 297",9,513]
[null,"Quote 298",25,3875]
[null,"Quote 299",1,146]
[null,"Quote 300",26,1560]
[null,"Quote 301",16,3488]
[null,"Quote 302",21,3843]
[null,"Quote 303",18,5202]
[null,"Quote 304",15,795]
[null,"Quote 305",2,260]
[null,"Quote 306",21,3948]
[null,"Quote 307",17,2329]
[null,"Quote 308",26,2288]
[null,"Quote 309",25,1350]
[null,"Quote 310",16,2688]
[null,"Quote 311",4,1196]
[null,"Quote 312",4,924]
[null,"Quote 313",5,715]
[null,"Quote 314",13,2093]
[null,"Quote 315",6,1602]
[null,"Quote 316",3,642]
[null,"Quote 317",3,432]
[null,"Quote 318",16,2928]
[null,"Quote 319",20,3780]
[null,"Quote 320",16,976]
[null,"Quote 321",22,3300]
[null,"Quote 322",18,1206]
[null,"Quote 323",14,1946]
[null,"Quote 324",18,4536]
[null,"Quote 325",14,1554]
[null,"Quote 326",10,1640]
[null,"Quote 327",23,2346]
[null,"Quote 328",22,4796]
[null,"Quote 329",18,2124]
[null,"Quote 330",2,370]
[null,"Quote 331",10,2820]
[null,"Quote 332",16,4496]
[null,"Quote 333",20,5840]
[null,"Quote 334",15,1920]
[null,"Quote 335",8,2224]
[null,"Quote 336",5,1235]
[null,"Quote 337",17,4539]
[null,"Quote 338",4,584]
[null,"Quote 339",9,1458]
[null,"Quote 340",4,452]
[null,"Quote 341",18,3366]
[null,"Quote 342",12,648]
[null,"Quote 343",10,1520]
[null,"Quote 344",4,232]
[null,"Quote 345",26,3848]
[null,"Quote 346",19,2014]
[null,"Quote 347",20,3500]
[null,"Quote 348",13,1924]
[null,"Quote 349",17,3315]
[null,"Quote 350",2,438]
[null,"Quote 351",17,4913]
[null,"Quote 352",23,6394]
[null,"Quote 353",2,314]
[null,"Quote 354",26,5200]
[null,"Quote 355",5,685]
[null,"Quote 356",4,424]
[null,"Quote 357",9,1890]
[null,"Quote 358",13,3679]
[null,"Quote 359",26,7150]
[null,"Quote 360",26,7046]
[null,"Quote 361",16,4320]
[null,"Quote 362",23,3174]
[null,"Quote 363",7,1295]
[null,"Quote 364",16,2048]
[null,"Quote 365",21,3738]
[null,"Quote 366",16,2240]
[null,"Quote 367",24,4176]
[null,"Quote 368",19,3116]
[null,"Quote 369",6,654]
[null,"Quote 370",12,3312]
[null,"Quote 371",22,1430]
[null,"Quote 372",20,4320]
[null,"Quote 373",5,1460]
[null,"Quote 374",19,3306]
[null,"Quote 375",10,1380]
[null,"Quote 376",23,5681]
[null,"Quote 377",24,7152]
[null,"Quote 378",1,96]
[null,"Quote 379",17,2448]
[null,"Quote 380",25,3925]
[null,"Quote 381",5,995]
[null,"Quote 382",13,3588]
[null,"Quote 383",14,4172]
[null,"Quote 384",26,2626]
[null,"Quote 385",13,2483]
[null,"Quote 386",22,6600]
[null,"Quote 387",26,5590]
[null,"Quote 388",13,1976]
[null,"Quote 389",3,822]
[null,"Quote 390",23,3910]
[null,"Quote 391",11,2574]
[null,"Quote 392",17,1972]
[null,"Quote 393",6,1524]
[null,"Quote 394",18,2016]
[null,"Quote 395",9,576]
[null,"Quote 396",13,3822]
[null,"Quote 397",8,2304]
[null,"Quote 398",20,5100]
[null,"Quote 399",6,498]
[null,"Quote 400",22,3762]
[null,"Quote 401",3,246]
[null,"Quote 402",24,3000]
[null,"Quote 403",23,4416]
[null,"Quote 404",10,2950]
[null,"Quote 405",9,1476]
[null,"Quote 406",16,3056]
[null,"Quote 407",10,1930]
[null,"Quote 408",11,2860]
[null,"Quote 409",23,2300]
[null,"Quote 410",11,3190]
[null,"Quote 411",7,1603]
[null,"Quote 412",16,2128]
[null,"Quote 413",3,423]
[null,"Quote 414",17,3485]
[null,"Quote 415",26,1560]
[null,"Quote 416",20,4900]
[null,"Quote 417",24,3720]
[null,"Quote 418",3,228]
[null,"Quote 419",19,3686]
[null,"Quote 420",25,2125]
[null,"Quote 421",21,1953]
[null,"Quote 422",21,3528]
[null,"Quote 423",20,5940]
[null,"Quote 424",6,570]
[null,"Quote 425",3,648]
[null,"Quote 426",25,1950]
[null,"Quote 427",19,4636]
[null,"Quote 428",25,6025]
[null,"Quote 429",26,5590]
[null,"Quote 430",14,1806]
[null,"Quote 431",21,5859]
[null,"Quote 432",1,93]
[null,"Quote 433",16,960]
[null,"Quote 434",18,1998]
[null,"Quote 435",12,1212]
[null,"Quote 436",19,4351]
[null,"Quote 437",1,154]
[null,"Quote 438",24,4440]
[null,"Quote 439",18,3312]
[null,"Quote 440",9,2547]
[null,"Quote 441",11,3190]
[null,"Quote 442",13,2717]
[null,"Quote 443",11,1958]
[null,"Quote 444",8,1560]
[null,"Quote 445",5,620]
[null,"Quote 446",19,3192]
[null,"Quote 447",7,1379]
[null,"Quote 448",8,1056]
[null,"Quote 449",25,4625]
[null,"Quote 450",10,1760]
[null,"Quote 451",2,328]
[null,"Quote 452",4,1020]
[null,"Quote 453",24,3768]
[null,"Quote 454",24,5352]
[null,"Quote 455",4,928]
[null,"Quote 456",4,244]
[null,"Quote 457",2,588]
[null,"Quote 458",26,5538]
[null,"Quote 459",16,2288]
[null,"Quote 460",10,1400]
[null,"Quote 461",7,623]
[null,"Quote 462",12,3336]
[null,"Quote 463",21,5418]
[null,"Quote 464",20,5040]
[null,"Quote 465",20,4840]
[null,"Quote 466",13,2834]
[null,"Quote 467",1,269]
[null,"Quote 468",11,2002]
[null,"Quote 469",19,1444]
[null,"Quote 470",7,959]
[null,"Quote 471",23,3266]
[null,"Quote 472",16,3744]
[null,"Quote 473",18,2430]
[null,"Quote 474",8,2200]
[null,"Quote 475",9,2556]
[null,"Quote 476",14,1078]
[null,"Quote 477",5,330]
[null,"Quote 478",7,1239]
[null,"Quote 479",19,4123]
[null,"Quote 480",26,2340]
[null,"Quote 481",19,3363]
[null,"Quote 482",21,6279]
[null,"Quote 483",26,7800]
[null,"Quote 484",7,756]
[null,"Quote 485",22,3652]
[null,"Quote 486",21,5082]
[null,"Quote 487",12,2988]
[null,"Quote 488",1,126]
[null,"Quote 489",5,860]
[null,"Quote 490",25,3725]
[null,"Quote 491",3,564]
[null,"Quote 492",5,410]
[null,"Quote 493",24,6768]
[null,"Quote 494",6,960]
[null,"Quote 495",19,2394]
[null,"Quote 496",4,800]
[null,"Quote 497",7,1393]
[null,"Quote 498",20,3680]
[null,"Quote 499",17,3621]
[null,"Quote 500",5,1260]