tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__2914__02 2000 GELP OIL BY VENDOR
Sheet: GELP OIL DELIVERY SHEET #1

GELP   #2 FUEL OIL   RECEIPTS FOR THE MONTH
Delivery Date | Beginning Flow counter reading | Ending Flow counter reading | Plant Recorded Delivery |  | BP AMOCO       Quantity on B/L-Gross | Marathon Ashland Quantity on B/L-Gross | CITGO Quantity on B/L-Gross | B/L #
 | 28373776 | 28381337 |  |  |  | 7601
 |  | 28388888 |  |  |  | 7601
 |  | 28396349 |  |  | 7500
 |  | 28403830 |  |  | 7502
 |  | 28411381 |  |  |  | 7600
 |  | 28418825 |  |  | 7505
 |  | 28426390 |  |  |  | 7602
 |  | 28433842 |  |  |  |  | 7502
 |  | 28441281 |  |  | 7505
 |  | 28448732 |  |  |  |  | 7502
 |  | 28471115
 |  | 28478543 |  |  |  |  | 7501
 |  | 28485992 |  |  |  |  | 7501
 |  | 28493432 |  |  |  |  | 7502
 |  | 28500888 |  |  |  |  | 7502
 |  | 28508324 |  |  |  |  | 7501
 |  | 28515769 |  |  |  |  | 7502
 |  | 28530658
 |  | 28552961
 |  | 28560411 |  |  |  |  | 7501
 |  | 28567865 |  |  |  |  | 7501
 |  | 28575324 |  |  |  |  | 7501
 |  | 28582766 |  |  |  |  | 7501
 |  | 28590199 |  |  |  |  | 7501
 |  | 28597650 |  |  |  |  | 7510
 |  | 28605192 |  |  |  | 7601
 |  | 28612647 |  |  |  |  | 7501
 |  | 28620106 |  |  |  | 7502
 |  | 28627568 |  |  |  |  | 7501
 |  | 28635128 |  |  |  | 7602
 |  | 28642682 |  |  |  | 7601
 |  | 28650139 |  |  |  |  | 7502
 |  | 28657583 |  |  |  |  | 7502
 |  | 28665025 |  |  |  |  | 7501
 |  | 28672475 |  |  |  |  | 7500
 |  | 28679938 |  |  |  |  | 7501
 |  | 28687389 |  |  |  |  | 7501
 |  | 28694834 |  |  |  |  | 7501
 |  | 28702321 |  |  |  |  | 7502
 |  | 28717244
 |  | 28724686 |  |  |  |  | 7502
 |  | 28732133 |  |  |  |  | 7501
 |  | 28739587 |  |  |  |  | 7501
 |  | 28747028 |  |  |  |  | 7501
 |  | 28754486 |  |  |  |  | 7504
 |  | 28761951 |  |  |  |  | 7504
 |  | 28769395 |  |  |  |  | 7501
 |  | 28776838 |  |  |  |  | 7502
 |  | 28791738
 |  | 28799175 |  |  |  |  | 7502
 |  | 28806619 |  |  |  |  | 7502
 |  | 28814080 |  |  | 7500
 |  | 28821604 |  |  |  | 7601
 |  | 28829167 |  |  |  | 7601
 |  | 28836719 |  |  |  | 7601
 |  | 28844273 |  |  |  | 7600
 |  | 28851855 |  |  |  | 7601
 |  | 28859429 |  |  |  | 7602
 |  | 28867025 |  |  |  | 7603
 |  | 28874513 |  |  | 7508
 |  | 28882099 |  |  |  | 7602
 |  | 28889553 |  |  | 7499
 |  | 28897018 |  |  | 7500
 |  | 28904472 |  |  | 7500
 |  |  | Due from previous month | 583300
 |  |  | Any Fuel ordered ? | 75000
 |  |  | TOTAL DELIVERED
 |  |  | OWED TO GELP/ (OVER DELIVERED)
Spreadsheet: 43901d1242555572-average-column-depending-on-values-in-another-column-forex-journal-template
Sheet: CALENDAR

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009
 |  |  |  |  |  |  |  |  | 2009
 |  | JANUARY |  |  |  |  |  |  |  |  |  | FEBRUARY |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | APRIL
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 |  | MAY |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | JULY |  |  |  |  |  |  |  |  |  | AUGUST
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 |  | SEPTEMBER |  |  |  |  |  |  |  |  |  | OCTOBER |  |  |  |  |  |  |  |  |  | NOVEMBER |  |  |  |  |  |  |  |  |  | DECEMBER
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 |  |  |  |  |  |  |  | NEWS RELEASES |  |  |  |  |  |  |  |  |  |  |  |  | EVENTS & HOLIDAYS
 |  |  |  |  |  |  |  | DATE |  | [NAME] |  |  |  |  |  |  |  |  |  |  | DATE |  | [NAME]
Spreadsheet: 0378df0e-5ab3-4cb5-b403-35be60f5f755
Sheet: Sheet1

Please read these directions and complete cells B3 and [NAME]  before proceeding with the budget work. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
County
Budget Year |  | (This should be the budget for next year)
These worksheets will work best if completed in the following order:
1.   Complete the Financial Check Sheet for the |  |  |  | budget year.
To complete the check sheet and proof sheet, you will need the KSU audited 8-6,8-7a
and 8-7b for December of the year being checked and the previous year.
You will also need the budgets for |  |  | and
2.  Review the balances in Reserves and Pledges with the Board and make necessary transfers.
3.  Complete the Budget Worksheet.
4.  Print the Budget Form which will be automatically completed from the worksheet.
Other budget development and management worksheets that may be used: |  |  |  |  |  | End of Year Estimate Worksheet
 |  |  |  |  |  | Equipment Replacement Plan Worksheet
 |  |  |  |  |  | Monthly Overview
Developed by: [NAME], CED, Butler County and [NAME], Assistant Director, Extension Field Operations
Questions about use of the worksheets should be directed to your Area Director or the Extension Field Operations Office.
Spreadsheet: 776290d1649677526-make-a-calendar-for-2-month-with-upates-monthly-forumla-min-kalender
Sheet: Ark1

 |  |  |  |  |  |  |  |  | 2022
 |  | 2022-04-01 00:00:00 |  |  |  |  |  |  |  |  | 2022-05-01 00:00:00
 |  | Man | Tir | Ons | Tor | Fre | Lør | Søn |  |  | Man | Tir | Ons | Tor | Fre | Lør | Søn
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 1900-01-02 00:00:00 | 1900-01-03 00:00:00 | 1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 1900-01-07 00:00:00 | 1900-01-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 1900-01-09 00:00:00 | 1900-01-10 00:00:00 | 1900-01-11 00:00:00 | 1900-01-12 00:00:00 | 1900-01-13 00:00:00 | 1900-01-14 00:00:00 | 1900-01-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 1900-01-16 00:00:00 | 1900-01-17 00:00:00 | 1900-01-18 00:00:00 | 1900-01-19 00:00:00 | 1900-01-20 00:00:00 | 1900-01-21 00:00:00 | 1900-01-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 1900-01-23 00:00:00 | 1900-01-24 00:00:00 | 1900-01-25 00:00:00 | 1900-01-26 00:00:00 | 1900-01-27 00:00:00 | 1900-01-28 00:00:00 | 1900-01-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 1900-01-30 00:00:00 | 1900-01-31 00:00:00
Spreadsheet: 198101d1354652905-comparison-chart-help-male_female-comparison-chart-example
Sheet: Data

Existing Options
 | Sex | Age | Sports Steering Wheel | Allow Wheels | Black Automatic Transmission | Bluetooth Pack | Panoramic Sunroof | Run Flat Tyres | Parking Sensor with TV | Rear [NAME] | Bonnet Stripes | [NAME]
1 | F | 55 | x |  |  |  |  |  | x
2 | M | 20 |  | x | x |  | x |  |  |  | x | x
3 | F | 59 |  |  |  | x |  | x |  | x
4 | M | 35 | x |  |  |  |  |  | x | x
5 | F | 58 |  |  | x |  |  | x | x |  | x | x
6 | M | 54 |  | x |  | x |  |  |  | x
7 | F | 47 | x |  |  |  |  |  |  |  | x | x
8 | M | 43 |  |  | x |  |  | x | x
9 | F | 58 |  |  | x | x |  |  | x
10 | M | 59 | x | x |  |  |  |  |  | x | x | x
11 | F | 25 |  |  |  | x |  | x |  | x
12 | M | 46 | x |  | x |  |  | x
13 | F | 23 |  | x |  |  |  | x |  |  | x | x
14 | M | 45 |  |  |  |  |  |  | x | x
15 | F | 45 |  |  | x |  |  | x |  | x | x | x
16 | M | 34 |  | x
17 | F | 36 |  | x |  |  | x |  | x | x
18 | M | 27 | x | x |  | x |  |  |  |  | x | x
19 | F | 30 |  |  |  |  |  | x
20 | M | 39 | x |  |  |  |  |  | x |  | x | x
21 | F | 54 |  | x | x
22 | M | 50 |  |  |  | x
23 | F | 25 |  |  |  |  |  | x |  |  | x | x
24 | M | 50 |  |  | x |  |  |  | x
25 | F | 26 |  |  |  |  |  |  | x |  | x | x
26 | M | 58 | x |  |  |  | x |  |  | x | x | x
27 | F | 33 |  | x | x | x | x |  | x
28 | M | 35 |  |  |  |  |  |  |  |  | x | x
Spreadsheet: 132933d1324040477-looking-up-values-based-on-multiple-criteria-in-data-source-of-different-nuo-of-rows-data_analytics
Sheet: Raw

#
# | Entry Page Title contains funeral insurance plan?
#
# FILTERS
Entry Page Title | Document Group | Campaign Type (Intelligent) | Visits | Bounce rate | Conversion
Looking for best funeral insurance plan? 1 | TOTAL | TOTAL | 8 | 0.875 | 0
Looking for best funeral insurance plan? 1 | Short Form | TOTAL | 1 | 0 | 0
Looking for best funeral insurance plan? 1 | Short Form | [NAME] | 1 | 0 | 0
Looking for best funeral insurance plan? 1 | Other
Looking for best funeral insurance plan? 2 | TOTAL | TOTAL | 11 | 0.2727 | 0.0909
Looking for best funeral insurance plan? 2 | Short Form | TOTAL | 8 | 0 | 0
Looking for best funeral insurance plan? 2 | Short Form | [NAME] | 8 | 0 | 0
Looking for best funeral insurance plan? 2 | Application | TOTAL | 1 | 0 | 1
Looking for best funeral insurance plan? 2 | Application | [NAME] | 1 | 0 | 1
Looking for best funeral insurance plan? 2 | Other
Looking for best funeral insurance plan? 3 | TOTAL | TOTAL | 9 | 0.5556 | 0.1111
Looking for best funeral insurance plan? 3 | Short Form | TOTAL | 4 | 0 | 0
Looking for best funeral insurance plan? 3 | Short Form | [NAME] | 4 | 0 | 0
Looking for best funeral insurance plan? 3 | Application | TOTAL | 1 | 0 | 1
Looking for best funeral insurance plan? 3 | Application | [NAME] | 1 | 0 | 1
Looking for best funeral insurance plan? 3 | Other
Looking for best funeral insurance plan? 4 | TOTAL | TOTAL | 6 | 0 | 0.3333
Looking for best funeral insurance plan? 4 | Short Form | TOTAL | 5 | 0 | 0
Looking for best funeral insurance plan? 4 | Short Form | [NAME] | 5 | 0 | 0
Looking for best funeral insurance plan? 4 | Application | TOTAL | 2 | 0 | 1
Looking for best funeral insurance plan? 4 | Application | [NAME] | 2 | 0 | 1
Looking for best funeral insurance plan? 4 | Other
Looking for best funeral insurance plan? 5 | TOTAL | TOTAL | 8 | 0.25 | 0.25
Looking for best funeral insurance plan? 5 | Short Form | TOTAL | 6 | 0 | 0
Looking for best funeral insurance plan? 5 | Short Form | [NAME] | 6 | 0 | 0
Looking for best funeral insurance plan? 5 | Application | TOTAL | 2 | 0 | 1
Looking for best funeral insurance plan? 5 | Application | [NAME] | 2 | 0 | 1
Looking for best funeral insurance plan? 5 | Other
Looking for the Best Funeral Insurance Plan? | TOTAL | TOTAL | 8 | 0.5 | 0.25
Looking for the Best Funeral Insurance Plan? | Short Form | TOTAL | 3 | 0 | 0
Looking for the Best Funeral Insurance Plan? | Short Form | [NAME] | 3 | 0 | 0
Looking for the Best Funeral Insurance Plan? | Application | TOTAL | 2 | 0 | 1
Looking for the Best Funeral Insurance Plan? | Application | [NAME] | 2 | 0 | 1
Looking for the Best Funeral Insurance Plan? | Other
Total |  | 0 | 50 | 0.42 | 0.16
Spreadsheet: 192700d1352495665-duration-calculation-and-results-populated-on-another-sheet-gantt-example_ver2
Sheet: Schedule

Product: | Four
 |  |  |  |  | Hidden Columns
 | Active | Start | End | Duration | Start of Duration | End of Duration
Solution Engineer
Task A |  | 2012-11-05 00:00:00 | 2012-11-18 00:00:00 |  | [NAME] | D3
Task B |  | 2012-11-06 00:00:00 | 2012-11-20 00:00:00
Task C |  | 2012-11-05 00:00:00 | 2012-11-17 00:00:00
Task D |  | 2012-12-12 00:00:00 | 2013-01-01 00:00:00
Task E |  | 2013-01-22 00:00:00 | 2013-04-01 00:00:00
Task F |  | 2012-12-10 00:00:00 | 2013-01-14 00:00:00
Spreadsheet: 41244d1239734999-sorting-fun
Sheet: Sheet1

S.No | Student No | Student NaJe | Subjects |  |  |  |  |  | Total |  | Result | unique rank
 |  |  | [NAME] | English | Sicence | Social Sience | Jaths | Hindi | 625
16 | 116 | [NAME] | 123 | 90 | 92 | 66 | 91 | 92 | 554 |  | PASS | 1
27 | 127 | Sadabindu | 66 | 92 | 77 | 96 | 96 | 88 | 515 |  | PASS | 2
24 | 124 | Sachish | 98 | 92 | 92 | 60 | 92 | 72 | 506 |  | PASS | 3
6 | 106 | [NAME] | 67 | 72 | 96 | 92 | 96 | 77 | 500 |  | PASS | 4
1 | 101 | Aadit | 101 | 80 | 66 | 90 | 90 | 70 | 497 |  | PASS | 5
25 | 125 | Sachit | 102 | 72 | 72 | 77 | 96 | 60 | 479 |  | PASS | 6
3 | 103 | Aahva | 90 | 60 | 72 | 92 | 72 | 92 | 478 |  | PASS | 7
5 | 105 | Aakarsh | 88 | 60 | 92 | 77 | 92 | 66 | 475 |  | PASS | 8
13 | 113 | [NAME] | 96 | 63 | 55 | 77 | 92 | 92 | 475 |  | PASS | 9
10 | 110 | [NAME] | 88 | 72 | 96 | 55 | 96 | 66 | 473 |  | PASS | 10
8 | 108 | Raahi | 101 | 55 | 77 | 66 | 77 | 96 | 472 |  | PASS | 11
7 | 107 | Aakesh | 90 | 60 | 66 | 96 | 66 | 92 | 470 |  | PASS | 12
21 | 121 | Sachetan | 88 | 60 | 96 | 90 | 60 | 72 | 466 |  | PASS | 13
29 | 129 | Sadar | 99 | 60 | 96 | 60 | 60 | 90 | 465 |  | PASS | 14
28 | 128 | Sadanand | 98 | 72 | 92 | 66 | 66 | 67 | 461 |  | PASS | 15
9 | 109 | Raajaa | 90 | 60 | 92 | 60 | 92 | 66 | 460 |  | PASS | 16
15 | 115 | Raam | 99 | 60 | 72 | 96 | 66 | 66 | 459 |  | PASS | 17
23 | 123 | Sachin | 96 | 60 | 60 | 72 | 77 | 92 | 457 |  | PASS | 18
26 | 126 | Sachiv | 100 | 60 | 60 | 92 | 66 | 72 | 450 |  | PASS | 19
12 | 112 | Raajyashree | 92 | 60 | 66 | 72 | 77 | 77 | 444 |  | PASS | 20
20 | 120 | Radhakanta | 99 | 66 | 92 | 59 | 36 | 92 | 444 |  | PASS | 21
4 | 104 | Aakaar | 72 | 60 | 77 | 60 | 77 | 96 | 442 |  | PASS | 22
22 | 122 | [NAME] | 87 | 55 | 66 | 92 | 55 | 60 | 415 |  | PASS | 24
11 | 111 | [NAME] | 77 | 60 | 66 | 60 | 66 | 66 | 395 |  | PASS | 25
17 | 117 | Raam-datt | 56 | 66 | 72 | 60 | 60 | 60 | 374 |  | PASS | 26
18 | 118 | Rachit | 60 | 60 | 60 | 60 | 60 | 62 | 362 |  | PASS | 27
30 | 130 | [NAME] | 90 | 60 | 66 | 35 | 60 | 35 | 346 |  | PASS | 28
19 | 119 | Rachvik | 70 | 35 | 77 | 35 | 35 | 35 | 287 |  | PASS | 29
2 | 102 | Aaditya | 30 | 35 | 45 | 30 | 30 | 77 | 247 |  | FAIL | FAIL
14 | 114 | Raakesh | 30 | 65 | 60 | 92 | 96 | 96 | 439 |  | FAIL | FAIL
Spreadsheet: kate_symes__18100__Deal Correction 12-15
Sheet: Current Day

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2000-12-14 00:00:00 | 2000-12-15 00:00:00 | 2000-12-14 00:00:00 | STCA | JR | JR | N/A | Entered deal after daily calc |  | 480433 | NP-15 | BOM | On peak | 25 | 290 | EES
 |  |  |  | JR Count
 | 2000-12-14 00:00:00 | 2000-12-15 00:00:00 | 2000-12-14 00:00:00 | LTSW | MM | MM | N/A | Entered deal after daily calc |  | 480436 | NP-15 | BOM | On peak | 50 | 290 | EES
 |  |  |  | MM Count
 | 2000-12-15 00:00:00 | 2000-12-15 00:00:00 | 2000-12-12 00:00:00 | STCA | CM | Houston | APB | Broker fee: from none to .0075 |  | 478477 | NP-15 | 2000-12-13 00:00:00 | Off peak | 25 | 375 | El Paso
 |  |  |  | CM Count
 | 2000-12-15 00:00:00 | 2000-12-15 00:00:00 | 2000-12-08 00:00:00 | LTSW | KS | Houston | Natsource | Broker fee: from none to .0075 | Incorrect defaults in Deal Blotter | 477212 | Mead | Q3-01 | On peak | 25 | 330 | Nevada
 | 2000-12-15 00:00:00 | 2000-12-15 00:00:00 | 2000-12-05 00:00:00 | LTSW | KS | Houston | Natsource | Broker fee: from none to .005 | Incorrect defaults in Deal Blotter | 474434 | Mead | Q4-01 | RTC | 25 | 111 | Calpine
 |  |  |  | KS Count
 | 2000-12-15 00:00:00 | 2000-12-15 00:00:00 | 2000-12-15 00:00:00 | STSW | MF | Houston | APB | Broker: from Prebon to APB |  | 480865 | Palo Verde | 2000-12-18 00:00:00 | On peak | 50 | 226 | Sierra
 |  |  |  | [NAME]
 |  |  |  | Grand Count
Spreadsheet: 4102b452-1176-4797-bd34-b70720a4734e
Sheet: Sheet1

FY 2012 AEA STATE AID PAYMENTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | ORIGINAL | SEPT-FEB | PAID THROUGH | AMOUNT
 |  | BUDGET | PAYMENT | FEB | REMAINING
1 | [NAME] 1 | 12173702 | 1217373 | 7304238 | 4869464
5 | PRAIRIE LAKES AEA 8 | 11932421 | 1193242 | 7159452 | 4772969
7 | AEA 267 | 25953086 | 2595314 | 15571884 | 10381202
9 | MISSISSIPPI BEND AEA 9 | 17943809 | 1794383 | 10766298 | 7177511
10 | GRANT WOOD AEA 10 | 25140991 | 2514103 | 15084618 | 10056373
11 | HEARTLAND AEA 11 | 45695987 | 4569599 | 27417594 | 18278393
12 | NORTHWEST AEA | 14971662 | 1497170 | 8983020 | 5988642
13 | GREEN HILLS AEA 13 | 14813279 | 1481329 | 8887974 | 5925305
15 | GREAT PRAIRIE AEA 15 | 13537748 | 1353777 | 8122662 | 5415086
 |  | 182162685 | 18216290 | 109297740 | 72864945
Spreadsheet: 18ddff59-3a6a-4e3f-9c09-07ff8f8bf070
Sheet: Sheet1

Table KS10 Hours worked* | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Key Statistics for Birmingham 2006 Districts and 2004 Wards.*
Key Statistics provide headline results about the main Census topics and facilitate comparisons between different areas.
The dataset contains around 380 statistics for each area.  The districts are those in place at 23rd May 2006.
* Best Fit Approximations issued by the Office for National Statistics in December 2004
Results for new wards are based on allocation of whole Census Output Areas.
Data for any Census Output Area that is split by a new ward boundary are allocated to the ward that contains the greatest
share of its population.
For reasons of confidentiality, National Statistics have altered the published results where very small numbers of people in an area fall into any of the categories in a table  (e.g. persons in a Birmingham ward working in the fishing industry). This means that:
- Population and household totals may vary among tables
- Published figures for a larger area may not match the sum of results for its smaller constituent parts.
For more information please visit our website: www.birmingham.gov.uk or the National Statistics Website:
www.statistics.gov.uk/neighbourhood
Copyright and Conditions of Use
The material presented is derived from the 2001 Census Area Statistics.  All census material is Crown Copyright.  Birmingham Council has a 'click user licence' issued by Her [NAME]'s Stationary Office.  This allows the re-use and publication of Census data.
 | Persons and organisations outside the City Council should check whether they need to obtain a licence to use and publish the data.  More information can be obtained from the national census website or from her [NAME]'s Stationary Office (HMSO):
http:/www.hmso.gov.uk/click-use-home.htm                                                                                                                                     HMSO,The Licensing Division, St Clements House,                                                                                                                                        2 to 16 Colegate, [NAME], NRS 1BQ(tel 01603 621000)
2001 Census Statistics incorporate measures to protect against the inadvertent disclosure of information relating specifically to an identified person or household.  The material should not be used to attempt to derive information relating specifically to an identified person or household nor should a claim be made that such information has been obtained or derived.
 |  |  |  |  | Development Directorate Demographic Information Service
Source: 2001 Census, [Key Statistics for Local Authorities].  Crown
copyright 2005. Crown copyright material is reproduced with the permission
of the [NAME] of HMSO .
Spreadsheet: 174102d1344933506-sumifs-with-date-range-help-please-sumifs
Sheet: Sheet1

 |  |  |  |  |  |  |  | 2012-08-11 00:00:00 | 2012-08-18 00:00:00
 |  | 2012-08-04 00:00:00 | 2012-08-11 00:00:00 | 2012-08-18 00:00:00 | 2012-08-25 00:00:00
 | Guinness | 22 | 11 | 0 | 11
 | Heineken | 0 | 33 | 0 | 11 |  |  |  |  | Guinness | 2012-08-04 00:00:00 | 22
 | [NAME] | 44 | 0 | 11 | 33 |  |  |  |  | Guinness | 2012-08-11 00:00:00 | 11
 | Guest Ale | 11 | 11 | 33 | 0 |  |  |  |  | Guinness | 2012-08-18 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  | Guinness | 2012-08-25 00:00:00 | 11
 | Stock take from | 2012-08-04 00:00:00
 | Stock take to | 2012-08-18 00:00:00
 | I want a formula that will take the from and to dates and sum the numbers by product within the date range
 | eg for Guiness these dates would return 33
 | The answer sheet will look like
 |  | Total delivered
 | Guiness | formula in here
 | Product | Delivery | Total
 | a | 2012-08-04 00:00:00 | 1
 | b | 2012-08-04 00:00:00 | 2
 | c | 2012-08-04 00:00:00 | 3
 | d | 2012-08-04 00:00:00 | 4
 | a | 2012-08-11 00:00:00 | 5
 | b | 2012-08-11 00:00:00 | 6
 | c | 2012-08-11 00:00:00 | 7
 | d | 2012-08-11 00:00:00 | 8
 | a | 2012-08-18 00:00:00 | 9
 | b | 2012-08-18 00:00:00 | 10
 | c | 2012-08-18 00:00:00 | 11
 | d | 2012-08-18 00:00:00 | 12
Spreadsheet: 158387d1338213339-align-two-graphs-of-the-weight-development-of-my-two-puppy-dogs-rottweilers-ggptt
Sheet: MAX

Na |  |  |  | Delta |  | Together | Me | Difference | Delta
0 week | 2012-03-03 00:00:00 | 15.7 |  |  |  |  |  | 15.7 |  |  |  |  |  |  |  |  |  | months |  |  |  | DOB | 2011-11-09 00:00:00
1 week | 2012-03-10 00:00:00 |  |  |  |  | 89.9 | 73.5 |  |  | LG |  |  |  |  |  |  |  | months
2 week | 2012-03-13 00:00:00 |  |  |  |  |  | 92.5 |  |  |  |  |  |  |  |  |  |  | months
3 week | 2012-03-17 00:00:00 |  |  |  |  | 93.8 | 74.8 |  |  | LG |  |  |  |  |  |  |  | months
4 week | 2012-03-21 00:00:00 |  |  |  |  | 110.8 | 91.9 |  |  | LG |  |  |  |  |  |  |  | months
5 week | 2012-03-28 00:00:00 |  |  |  |  |  |  | 19.9 |  | LG |  |  |  |  |  |  |  | months
6 week | 2012-04-01 00:00:00 |  |  |  |  | 96 | 75.2 |  |  |  |  |  |  |  |  |  |  | months
 | 2012-04-04 00:00:00 |  |  |  |  | 116.7 | 94.7 |  |  |  |  |  |  |  |  |  |  | months
 | 2012-04-12 00:00:00 |  |  |  |  | 99 | 75 |  |  | LG |  |  |  |  |  |  |  | months
 | 2012-04-18 00:00:00 |  |  |  |  | 100.7 | 75.6 |  |  |  |  |  |  |  |  |  |  | months
 | 2012-04-23 00:00:00 |  |  |  |  | 99.4 | 74.7 |  |  |  |  |  |  |  |  |  |  | months
 | 2012-04-30 00:00:00 |  |  |  |  | 102.4 | 76 |  |  | LG |  |  |  |  |  |  |  | months
 | 2012-05-06 00:00:00 |  |  |  |  | 106 | 77.7 |  |  | LG |  |  |  |  |  |  |  | months
 | 2012-05-15 00:00:00 |  |  |  |  | 104.9 | 75.3 |  |  | LG |  |  |  |  |  |  |  | months
 | 2012-05-28 00:00:00 |  |  |  |  | 107.2 | 75.7 |  |  | LG |  |  |  |  |  |  |  | months
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | months
Spreadsheet: 135732d1326210462-calculated-field-in-sub-total-sample
Sheet: Data

Agent | Date | Month | ID | Company | Product | Activity Flag | Description | C - PV | PV 1 | PV 2 | PV 3
Doe, [NAME] | 2011-11-30 00:00:00 | Nov-11 | SHKZS33 | Company A | Product 1 | 3 | Code Compliance | 1 | 3 | 3 | 3
Doe, [NAME] | 2011-12-08 00:00:00 | Dec-11 | NWH3T33 | Company B | Product 2 | 1 | Rating Compliance | 5 | 8 | 10 | 12
Doe, [NAME] | 2011-12-13 00:00:00 | Dec-11 | THW3T33 | Company C | Product 1 | 1 | Rating Compliance | 5 | 8 | 10 | 12
Doe, [NAME] | 2011-12-21 00:00:00 | Dec-11 | NMHCT33 | Company B | Product 2 | 2 | Coverage Compliance | 3 | 4 | 4 | 3
Doe, [NAME] | 2011-12-29 00:00:00 | Dec-11 | BGPCT33 | Company D | Product 1 | 1 | Qualification Compliance | 5 | 6 | 7 | 8
Spreadsheet: 63577d1264466883-multiple-fields-to-multiple-rows-for-want-of-a-better-description-sat-upload-
Sheet: Suppliers

QuickRef | [NAME] | Company Name | Contact | Street | Town | City | Region | Postcode | [NAME] | Mob | Comments
 | S00001 | Deb's Dishes | [NAME] | 1 Dish Street | Dishtown | Dish City | Dishshire | D1 | 952000001 | 654000001
 | S00002 | [NAME]'s LMBs | [NAME] | 1 LMB Road | LMBtown | LMB City | LMBshire | L1 | 952000002 | 654000002
 | S00003 | [NAME]'s Remotes | [NAME] | 1 Remote Lane | Remotetown | Remote City | Remoteshire | R1 | 952000003 | 654000003
 | S00004 | [NAME]'s Cables | [NAME] | 1 Cable Close | Cabletown | Cable City | Cableshire | C1 | 952000004 | 654000004
 | S00005 | [NAME]'s Boxes | [NAME] | 1 Box Avenue | Boxtown | Box City | Boxshire | B1 | 952000005 | 654000005
 | S00006 | [NAME]'s TV's | [NAME] | 1 TV Drive | TVtown | TV City | TVshire | T1 | 952000006 | 654000006
 | S00007 | [NAME]'s DVD's | [NAME] | 1 DVD Mews | DVDtown | DVD City | DVDshire | D1 | 952000007 | 654000007
 | S00008 | [NAME]'s Radios | [NAME] | 1 Radio Hill | Radiotown | Radio City | Radioshire | R1 | 952000008 | 654000008