Spreadsheet: 668914d1585129836-creating-a-forecast-book1
Sheet: Sales

2020 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018
Week | Bananas | Apples | Cucumbers | Kiwi | Cheese | Oranges | Onions | Potatoes | Tomatoes | Spinach | Total |  |  | Week | Bananas | Apples | Cucumbers | Kiwi | Cheese | Oranges | Onions | Potatoes | Tomatoes | Spinach | Total |  |  |  | Vecka | Försäkringsbolag | Kommun | Tingsrätt/Övriga | Krim/Skatt | AG-tjänsten | Total |  |  | Vecka | Försäkringsbolag | Kommun | Polisen | Tingsrätt/Övriga | A-kassa | Brottsoffer | Krim&Skatt | KFM | AG-tjänsten | Total
1 | 52 | 45 | 0 | 2 | 0 | 0 | 0 | 122 | 12 | 14 |  |  |  | 1 | 104 | 99 | 3 | 1 | 0 | 1 | 0 | 241 | 27 | 27 | 503 | 2018-12-31 00:00:00 |  |  | 1 | 153 | 237 | 17 | 289 | 234 | 930 |  |  | 1 | 153 | 237 | 11 | 3 | 0 | 3 | 289 | 35 | 234 | 965
2 | 148 | 228 | 10 | 1 | 0 | 2 | 2 | 469 | 56 | 29 |  |  |  | 2 | 139 | 230 | 14 | 4 | 0 | 1 | 0 | 502 | 79 | 66 | 1035 | 2019-01-07 00:00:00 |  |  | 2 | 169 | 183 | 38 | 527 | 403 | 1320 |  |  | 2 | 169 | 183 | 16 | 17 | 0 | 5 | 527 | 100 | 403 | 1420
3 | 175 | 265 | 7 | 1 | 0 | 1 | 3 | 627 | 35 | 26 |  |  |  | 3 | 222 | 215 | 10 | 5 | 1 | 6 | 0 | 638 | 114 | 69 | 1280 | 2019-01-14 00:00:00 |  |  | 3 | 246 | 305 | 37 | 550 | 332 | 1470 |  |  | 3 | 246 | 305 | 12 | 17 | 1 | 7 | 550 | 118 | 332 | 1588
4 | 257 | 303 | 7 | 9 | 0 | 3 | 10 | 653 | 71 | 87 |  |  |  | 4 | 240 | 312 | 13 | 5 | 1 | 4 | 0 | 721 | 157 | 84 | 1537 | 2019-01-21 00:00:00 |  |  | 4 | 248 | 349 | 29 | 723 | 400 | 1749 |  |  | 4 | 248 | 349 | 10 | 11 | 5 | 3 | 723 | 85 | 400 | 1834
5 | 226 | 337 | 15 | 5 | 0 | 1 | 6 | 838 | 210 | 42 |  |  |  | 5 | 209 | 257 | 7 | 2 | 0 | 11 | 0 | 542 | 144 | 66 | 1238 | 2019-01-28 00:00:00 |  |  | 5 | 226 | 257 | 34 | 574 | 501 | 1592 |  |  | 5 | 226 | 257 | 13 | 15 | 1 | 5 | 574 | 56 | 501 | 1648
6 | 244 | 290 | 10 | 2 | 0 | 1 | 1 | 721 | 42 | 65 |  |  |  | 6 | 197 | 309 | 14 | 10 | 2 | 8 | 0 | 659 | 60 | 54 | 1313 | 2019-02-04 00:00:00 |  |  | 6 | 200 | 317 | 25 | 644 | 380 | 1566 |  |  | 6 | 200 | 317 | 11 | 9 | 0 | 5 | 644 | 94 | 380 | 1660
7 | 228 | 375 | 9 | 2 | 0 | 7 | 1 | 626 | 32 | 70 |  |  |  | 7 | 245 | 362 | 12 | 6 | 0 | 3 | 0 | 505 | 48 | 69 | 1250 | 2019-02-11 00:00:00 |  |  | 7 | 220 | 303 | 36 | 631 | 395 | 1585 |  |  | 7 | 220 | 303 | 16 | 18 | 0 | 2 | 631 | 77 | 395 | 1662
8 | 254 | 395 | 4 | 0 | 1 | 4 | 2 | 634 | 19 | 79 |  |  |  | 8 | 240 | 381 | 15 | 8 | 0 | 4 | 0 | 655 | 64 | 57 | 1424 | 2019-02-18 00:00:00 |  |  | 8 | 274 | 270 | 40 | 592 | 388 | 1564 |  |  | 8 | 274 | 270 | 11 | 27 | 0 | 2 | 592 | 48 | 388 | 1612
9 | 234 | 305 | 11 | 3 | 0 | 5 | 7 | 572 | 25 | 70 |  |  |  | 9 | 228 | 293 | 14 | 10 | 2 | 2 | 0 | 596 | 55 | 49 | 1249 | 2019-02-25 00:00:00 |  |  | 9 | 252 | 393 | 24 | 559 | 410 | 1638 |  |  | 9 | 252 | 393 | 13 | 4 | 0 | 7 | 559 | 47 | 410 | 1685
10 | 209 | 370 | 9 | 6 | 0 | 3 | 0 | 599 | 58 | 12 |  |  |  | 10 | 246 | 314 | 22 | 5 | 2 | 2 | 0 | 602 | 37 | 61 | 1291 | 2019-03-04 00:00:00 |  |  | 10 | 256 | 236 | 28 | 551 | 441 | 1512 |  |  | 10 | 256 | 236 | 7 | 15 | 0 | 6 | 551 | 41 | 441 | 1553
11 | 193 | 288 | 7 | 0 | 1 | 4 | 3 | 572 | 74 | 24 |  |  |  | 11 | 214 | 296 | 20 | 5 | 1 | 4 | 0 | 614 | 37 | 55 | 1246 | 2019-03-11 00:00:00 |  |  | 11 | 250 | 362 | 22 | 572 | 427 | 1633 |  |  | 11 | 250 | 362 | 10 | 6 | 1 | 5 | 572 | 33 | 427 | 1666
12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 223 | 302 | 14 | 9 | 0 | 5 | 0 | 625 | 39 | 68 | 1285 | 2019-03-18 00:00:00 |  |  | 12 | 234 | 281 | 24 | 553 | 418 | 1510 |  |  | 12 | 234 | 281 | 12 | 7 | 1 | 4 | 553 | 43 | 418 | 1553
13 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 292 | 293 | 10 | 3 | 0 | 4 | 0 | 650 | 46 | 54 | 1352 | 2019-03-25 00:00:00 |  |  | 13 | 244 | 246 | 15 | 428 | 323 | 1256 |  |  | 13 | 244 | 246 | 6 | 5 | 0 | 4 | 428 | 35 | 323 | 1291
14 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 220 | 259 | 8 | 7 | 0 | 6 | 0 | 567 | 45 | 52 | 1164 | 2019-04-01 00:00:00 |  |  | 14 | 169 | 290 | 18 | 374 | 283 | 1134 |  |  | 14 | 169 | 290 | 9 | 6 | 1 | 2 | 374 | 44 | 283 | 1178
15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 235 | 283 | 16 | 3 | 0 | 5 | 0 | 593 | 46 | 57 | 1238 | 2019-04-08 00:00:00 |  |  | 15 | 237 | 315 | 38 | 563 | 408 | 1561 |  |  | 15 | 237 | 315 | 18 | 13 | 0 | 7 | 563 | 35 | 408 | 1596
16 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 188 | 286 | 8 | 4 | 1 | 1 | 0 | 480 | 23 | 42 | 1033 | 2019-04-15 00:00:00 |  |  | 16 | 287 | 304 | 17 | 618 | 389 | 1615 |  |  | 16 | 287 | 304 | 9 | 5 | 0 | 3 | 618 | 35 | 389 | 1650
17 |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 148 | 223 | 5 | 1 | 0 | 5 | 0 | 496 | 33 | 34 | 945 | 2019-04-22 00:00:00 |  |  | 17 | 253 | 290 | 29 | 559 | 408 | 1539 |  |  | 17 | 253 | 290 | 13 | 11 | 0 | 5 | 559 | 55 | 408 | 1594
18 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 138 | 212 | 8 | 2 | 0 | 3 | 0 | 365 | 38 | 36 | 802 | 2019-04-29 00:00:00 |  |  | 18 | 161 | 205 | 18 | 280 | 280 | 944 |  |  | 18 | 161 | 205 | 8 | 7 | 1 | 2 | 280 | 37 | 280 | 981
19 |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | 230 | 289 | 8 | 1 | 0 | 5 | 0 | 616 | 40 | 53 | 1242 | 2019-05-06 00:00:00 |  |  | 19 | 239 | 221 | 28 | 428 | 402 | 1318 |  |  | 19 | 239 | 221 | 14 | 8 | 0 | 6 | 428 | 48 | 402 | 1366
20 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 174 | 342 | 16 | 2 | 0 | 14 | 0 | 623 | 32 | 65 | 1268 | 2019-05-13 00:00:00 |  |  | 20 | 142 | 280 | 15 | 471 | 388 | 1296 |  |  | 20 | 142 | 280 | 4 | 8 | 1 | 2 | 471 | 29 | 388 | 1325
21 |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 219 | 285 | 10 | 10 | 0 | 4 | 0 | 546 | 33 | 45 | 1152 | 2019-05-20 00:00:00 |  |  | 21 | 266 | 284 | 21 | 427 | 399 | 1397 |  |  | 21 | 266 | 284 | 6 | 12 | 0 | 3 | 427 | 39 | 399 | 1436
22 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 161 | 289 | 8 | 3 | 1 | 5 | 0 | 531 | 21 | 64 | 1083 | 2019-05-27 00:00:00 |  |  | 22 | 245 | 273 | 35 | 561 | 336 | 1450 |  |  | 22 | 245 | 273 | 14 | 17 | 0 | 4 | 561 | 54 | 336 | 1504
23 |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 176 | 195 | 6 | 1 | 0 | 1 | 0 | 409 | 41 | 45 | 874 | 2019-06-03 00:00:00 |  |  | 23 | 152 | 224 | 23 | 381 | 325 | 1105 |  |  | 23 | 152 | 224 | 7 | 11 | 0 | 5 | 381 | 36 | 325 | 1141
24 |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 182 | 203 | 14 | 3 | 0 | 7 | 0 | 573 | 41 | 42 | 1065 | 2019-06-10 00:00:00 |  |  | 24 | 253 | 230 | 17 | 603 | 398 | 1501 |  |  | 24 | 253 | 230 | 7 | 6 | 1 | 3 | 603 | 29 | 398 | 1530
25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 178 | 213 | 5 | 7 | 1 | 1 | 0 | 385 | 17 | 41 | 848 | 2019-06-17 00:00:00 |  |  | 25 | 154 | 230 | 21 | 443 | 297 | 1145 |  |  | 25 | 154 | 230 | 6 | 14 | 0 | 1 | 443 | 27 | 297 | 1172
26 |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 223 | 324 | 4 | 18 | 1 | 5 | 0 | 559 | 32 | 57 | 1223 | 2019-06-24 00:00:00 |  |  | 26 | 195 | 291 | 32 | 491 | 391 | 1400 |  |  | 26 | 195 | 291 | 14 | 12 | 1 | 5 | 491 | 27 | 391 | 1427
27 |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | 197 | 253 | 11 | 8 | 0 | 1 | 0 | 502 | 1987 | 42 | 3001 | 2019-07-01 00:00:00 |  |  | 27 | 189 | 228 | 13 | 494 | 311 | 1235 |  |  | 27 | 189 | 228 | 2 | 8 | 1 | 2 | 494 | 36 | 311 | 1271
28 |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 156 | 241 | 10 | 6 | 0 | 0 | 0 | 473 | 246 | 70 | 1202 | 2019-07-08 00:00:00 |  |  | 28 | 183 | 222 | 13 | 505 | 267 | 1190 |  |  | 28 | 183 | 222 | 7 | 4 | 0 | 2 | 505 | 31 | 267 | 1221
29 |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 116 | 169 | 15 | 2 | 0 | 0 | 0 | 466 | 27 | 25 | 820 | 2019-07-15 00:00:00 |  |  | 29 | 106 | 180 | 16 | 377 | 204 | 883 |  |  | 29 | 106 | 180 | 10 | 4 | 0 | 2 | 377 | 33 | 204 | 916
30 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 109 | 135 | 11 | 0 | 0 | 0 | 0 | 373 | 20 | 19 | 667 | 2019-07-22 00:00:00 |  |  | 30 | 95 | 101 | 10 | 328 | 225 | 759 |  |  | 30 | 95 | 101 | 2 | 6 | 0 | 2 | 328 | 21 | 225 | 780
31 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 69 | 174 | 5 | 3 | 0 | 0 | 0 | 338 | 14 | 14 | 617 | 2019-07-29 00:00:00 |  |  | 31 | 87 | 153 | 9 | 303 | 205 | 757 |  |  | 31 | 87 | 153 | 3 | 5 | 0 | 1 | 303 | 31 | 205 | 788
32 |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 95 | 177 | 17 | 7 | 0 | 1 | 0 | 393 | 24 | 28 | 742 | 2019-08-05 00:00:00 |  |  | 32 | 109 | 190 | 7 | 325 | 314 | 945 |  |  | 32 | 109 | 190 | 2 | 3 | 1 | 1 | 325 | 30 | 314 | 975
33 |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 119 | 178 | 8 | 8 | 0 | 4 | 0 | 323 | 15 | 61 | 716 | 2019-08-12 00:00:00 |  |  | 33 | 157 | 163 | 17 | 378 | 409 | 1124 |  |  | 33 | 157 | 163 | 5 | 11 | 1 | 0 | 378 | 26 | 409 | 1150
34 |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 231 | 234 | 3 | 8 | 0 | 4 | 3 | 468 | 17 | 77 | 1045 | 2019-08-19 00:00:00 |  |  | 34 | 214 | 176 | 17 | 453 | 343 | 1203 |  |  | 34 | 214 | 176 | 8 | 4 | 1 | 4 | 453 | 31 | 343 | 1234
35 |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 219 | 166 | 10 | 10 | 4 | 6 | 10 | 416 | 15 | 44 | 900 | 2019-08-26 00:00:00 |  |  | 35 | 250 | 214 | 22 | 459 | 392 | 1337 |  |  | 35 | 250 | 214 | 13 | 5 | 1 | 3 | 459 | 41 | 392 | 1378
36 |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 | 213 | 273 | 12 | 10 | 0 | 4 | 1 | 511 | 19 | 58 | 1101 | 2019-09-02 00:00:00 |  |  | 36 | 229 | 245 | 16 | 504 | 388 | 1382 |  |  | 36 | 229 | 245 | 7 | 3 | 3 | 3 | 504 | 36 | 388 | 1418
37 |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 173 | 265 | 5 | 0 | 0 | 4 | 4 | 575 | 21 | 61 | 1108 | 2019-09-09 00:00:00 |  |  | 37 | 221 | 168 | 24 | 545 | 390 | 1348 |  |  | 37 | 221 | 216 | 10 | 12 | 0 | 2 | 545 | 32 | 390 | 1428
38 |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | 182 | 297 | 4 | 7 | 1 | 3 | 0 | 496 | 28 | 61 | 1079 | 2019-09-16 00:00:00 |  |  | 38 | 257 | 191 | 32 | 533 | 397 | 1410 |  |  | 38 | 257 | 191 | 20 | 7 | 1 | 4 | 533 | 39 | 397 | 1449
39 |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 263 | 219 | 11 | 3 | 1 | 7 | 1 | 566 | 24 | 45 | 1140 | 2019-09-23 00:00:00 |  |  | 39 | 268 | 245 | 38 | 461 | 352 | 1364 |  |  | 39 | 268 | 245 | 16 | 22 | 0 | 0 | 461 | 37 | 352 | 1401
40 |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 215 | 309 | 6 | 2 | 0 | 1 | 3 | 511 | 41 | 72 | 1160 | 2019-09-30 00:00:00 |  |  | 40 | 226 | 199 | 36 | 500 | 389 | 1350 |  |  | 40 | 226 | 199 | 18 | 10 | 2 | 6 | 500 | 46 | 389 | 1396
41 |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 | 213 | 248 | 10 | 4 | 1 | 12 | 3 | 399 | 29 | 61 | 980 | 2019-10-07 00:00:00 |  |  | 41 | 241 | 237 | 37 | 546 | 428 | 1489 |  |  | 41 | 241 | 237 | 14 | 14 | 3 | 6 | 549 | 37 | 428 | 1529
42 |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 | 212 | 321 | 5 | 6 | 4 | 2 | 2 | 497 | 22 | 60 | 1131 | 2019-10-14 00:00:00 |  |  | 42 | 233 | 258 | 24 | 513 | 216 | 1244 |  |  | 42 | 233 | 258 | 13 | 5 | 1 | 5 | 517 | 58 | 216 | 1306
43 |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 | 231 | 261 | 16 | 3 | 0 | 3 | 1 | 445 | 26 | 158 | 1144 | 2019-10-21 00:00:00 |  |  | 43 | 237 | 305 | 35 | 495 | 91 | 1163 |  |  | 43 | 237 | 305 | 22 | 8 | 1 | 4 | 495 | 39 | 91 | 1202
44 |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 | 216 | 275 | 4 | 2 | 0 | 5 | 1 | 474 | 35 | 58 | 1070 | 2019-10-28 00:00:00 |  |  | 44 | 221 | 217 | 43 | 540 | 83 | 1104 |  |  | 44 | 221 | 217 | 24 | 11 | 5 | 3 | 541 | 41 | 83 | 1146
45 |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 | 206 | 266 | 7 | 3 | 0 | 1 | 3 | 501 | 31 | 44 | 1062 | 2019-11-04 00:00:00 |  |  | 45 | 236 | 252 | 32 | 536 | 58 | 1114 |  |  | 45 | 236 | 252 | 18 | 10 | 0 | 4 | 536 | 45 | 58 | 1159
46 |  |  |  |  |  |  |  |  |  |  |  |  |  | 46 | 198 | 395 | 9 | 6 | 0 | 6 | 5 | 610 | 29 | 37 | 1295 | 2019-11-11 00:00:00 |  |  | 46 | 209 | 288 | 30 | 523 | 57 | 1107 |  |  | 46 | 209 | 288 | 20 | 5 | 0 | 5 | 523 | 50 | 57 | 1157
47 |  |  |  |  |  |  |  |  |  |  |  |  |  | 47 | 230 | 372 | 13 | 3 | 0 | 2 | 5 | 570 | 27 | 55 | 1277 | 2019-11-18 00:00:00 |  |  | 47 | 262 | 269 | 38 | 587 | 88 | 1244 |  |  | 47 | 262 | 269 | 17 | 14 | 1 | 6 | 587 | 36 | 88 | 1280
48 |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | 236 | 265 | 13 | 0 | 0 | 5 | 4 | 616 | 33 | 70 | 1242 | 2019-11-25 00:00:00 |  |  | 48 | 231 | 356 | 13 | 591 | 68 | 1259 |  |  | 48 | 231 | 356 | 7 | 2 | 1 | 3 | 591 | 47 | 68 | 1306
49 |  |  |  |  |  |  |  |  |  |  |  |  |  | 49 | 169 | 310 | 3 | 3 | 0 | 3 | 4 | 607 | 23 | 46 | 1168 | 2019-12-02 00:00:00 |  |  | 49 | 202 | 244 | 26 | 495 | 67 | 1034 |  |  | 49 | 202 | 244 | 13 | 9 | 0 | 4 | 495 | 44 | 67 | 1078
50 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 213 | 325 | 11 | 4 | 0 | 3 | 2 | 544 | 25 | 33 | 1160 | 2019-12-09 00:00:00 |  |  | 50 | 212 | 253 | 26 | 610 | 54 | 1155 |  |  | 50 | 212 | 253 | 11 | 9 | 0 | 6 | 612 | 55 | 54 | 1212
51 |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 | 216 | 222 | 17 | 4 | 0 | 1 | 5 | 639 | 27 | 40 | 1171 | 2019-12-16 00:00:00 |  |  | 51 | 274 | 269 | 26 | 554 | 86 | 1209 |  |  | 51 | 274 | 269 | 14 | 10 | 0 | 2 | 556 | 628 | 86 | 1839
52 |  |  |  |  |  |  |  |  |  |  |  |  |  | 52 | 117 | 136 | 10 | 1 | 0 | 2 | 1 | 200 | 9 | 13 | 489 | 2019-12-23 00:00:00 |  |  | 52 | 81 | 89 | 7 | 196 | 29 | 402 |  |  | 52 | 89 | 81 | 1 | 4 | 0 | 2 | 196 | 16 | 29 | 418
Average |  |  |  |  |  |  |  |  |  |  |  |  |  | Average |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medel |  |  |  |  |  |  |  |  | Medel
Median |  |  |  |  |  |  |  |  |  |  |  |  |  | Median |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Median |  |  |  |  |  |  |  |  | Median
Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  | Total