tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 287567d1388864300-need-number-of-consecutive-hours-with-temperatures-below-zero-temp
Sheet: Pivot

 | Rank | Start Date in Hours | End Date in Hours | Sum of Hours Below Zero
 | 1 | 1996-01-29 23:00:00 | 1996-02-04 21:00:00 | 141.9999999999418
 | 2 | 1996-12-25 01:00:00 | 1996-12-26 14:00:00 | 37.00000000011642
 | 3 | 1996-01-19 09:00:00 | 1996-01-20 18:00:00 | 33
 | 4 | 1996-01-06 01:00:00 | 1996-01-06 17:00:00 | 16.00000000011642
 | 5 | 1996-01-07 02:00:00 | 1996-01-07 16:00:00 | 13.99999999988358
 | 6 | 1996-01-28 02:00:00 | 1996-01-28 15:00:00 | 12.99999999994179
 | 7 | 1996-12-26 23:00:00 | 1996-12-27 10:00:00 | 10.99999999988358
 | 8 | 1996-01-25 04:00:00 | 1996-01-25 14:00:00 | 10.00000000011642
 | 9 | 1996-02-06 02:00:00 | 1996-02-06 12:00:00 | 9.999999999941792
 | 9 | 1996-12-20 06:00:00 | 1996-12-20 16:00:00 | 9.999999999941792
 | Grand Total |  |  | 295.9999999998836
Spreadsheet: 33000d1229200027-value-and-codes-template-2-
Sheet: Schedule

DATE:    JAN | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
NAME | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA
JACKIE        (ft) | 1 | 1 | D | D | 1 | 1 | 1 | 1 | D | 1 | 1 | D | 1 | 1 | 1 | 1 | D | D | 1 | 1 | D | 1 | 1 | 1 | D | D | 1 | 1 | 1 | 1 | D
KAREN        (ft) | D | 1 | 1 | 1 | D | 1 | 1 | D | 1 | 1 | D | 1 | 1 | 1 | 1 | 1 | D | D | 1 | D | 1 | 1 | 1 | 1 | 1 | 1 | D | D | 1 | 1 | 1
WISLY           (ft) | PHD | PHD | D | D | 1 | 1 | 1 | 1 | 1 | D | 1 | 1 | D | 1 | 1 | 1 | D | 1 | 1 | 1 | 1 | 1 | D | D | 1 | 1 | 1 | 1 | 1 | D | D
TWIN             (ft) | 1 | D | 1 | 1 | 1 | D | 1 | 1 | 1 | D | D | 1 | 1 | D | 1 | 1 | 1 | 1 | D | 1 | 1 | PL | 1 | 1IN | D | 1 | 1 | 1 | D | 1 | 1
 | TH | F |  | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA
SHARON   (ft) | D | 1 | 2 | 2 | 2 | D | 2 | 2 | 2 | D | D | 2 | 2 | 2 | D | 2 | 2 | 2 | 2 | PL | 2 | 2 | 2 | D | D | 2 | 2 | 2 | 2 | 2 | D
[NAME]   (pt) | D | 2 | D | D | 2 | 2 | 2 | D | D | 2 | 2 | 2 | 2 | D | 2 | 2 | D | D | 2 | 2 | 2 | D | D | 2 | 2 | 2 | D | 2 | 2 | 2 | D
OSCAR  (pt) | 2 | D | 2 | 2 | 2 | D | 2 | 2 | 1 | D | D | 2 | D | 2 | 2 | 2 | 1 | D | 2 | 2 | 2 | 2 | 2 | D | 2IN | 2 | 2 | D | 2 | 2 | 2
IBRAHIMA  (pt) | D | 2 | D | D | 2 | 2 | 2 | 2 | 2 | D | 2IN | 2 | 2 | 2 | 2 | D | 2 | 2 | D | 2 | D | 2 | 2 | 2 | 2 | D | 2 | 2 | 2 | 2 | D
DARIUS  (pt) | 2 | 2 | D | 2IN | 2 | 2 | D | 2 | 2 | 2 | 2 | D | 2 | 2 | 2 | 2 | D | 2IN | 2 | 2 | 2 | 2 | D | D | D | 2 | 2 | 2 | D | 2 | 2
 | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA
WILNER   (ft) | 3 | 3 | 3 | D | D | 3 | 3 | 3 | 3 | 3 | D | D | 3 | 3 | 3 | 3 | 3 | D | 3 | PL | 3 | 3 | 3 | 3 | D | D | 3 | 3 | 3 | 3 | 3
CASSANDRA  (pt) | D | 3 | 3 | 3 | 3 | D | D | 3 | 3 | 3 | 3 | 3 | 3 | D | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | D | 3 | 3 | 3 | D | 3 | 3 | D | 3
CATHERINE  (ft) | 3 | D | D | 3 | 3 | 3 | 3 | 3 | D | D | 3 | 3 | 3 | 3 | 3 | D | D | 3 | 3 | 3 | 3 | 3 | D | D | 3 | 3 | 3 | 3 | 3 | 3 | D
Spreadsheet: 158182d1338034646-times-tables-book1
Sheet: Sheet1

 | zbor
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24
 | 3 | 6 | 9 | 12 | 15 | 18 | 21 | 24 | 27 | 30 | 33 | 36
 | 4 | 8 | 12 | 16 | 20 | 24 | 28 | 32 | 36 | 40 | 44 | 48
 | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60
 | 6 | 12 | 18 | 24 | 30 | 36 | 42 | 48 | 54 | 60 | 66 | 72
 | 7 | 14 | 21 | 28 | 35 | 42 | 49 | 56 | 63 | 70 | 77 | 84
 | 8 | 16 | 24 | 32 | 40 | 48 | 56 | 64 | 72 | 80 | 88 | 96
 | 9 | 18 | 27 | 36 | 45 | 54 | 63 | 72 | 81 | 90 | 99 | 108
 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120
 | 11 | 22 | 33 | 44 | 55 | 66 | 77 | 88 | 99 | 110 | 121 | 132
 | 12 | 24 | 36 | 48 | 60 | 72 | 84 | 96 | 108 | 120 | 132 | 144
 | Martin
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24
 | 3 | 6 | 9 | 12 | 15 | 18 | 21 | 24 | 27 | 30 | 33 | 36
 | 4 | 8 | 12 | 16 | 20 | 24 | 28 | 32 | 36 | 40 | 44 | 48
 | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60
 | 6 | 12 | 18 | 24 | 30 | 36 | 42 | 48 | 54 | 60 | 66 | 72
 | 7 | 14 | 21 | 28 | 35 | 42 | 49 | 56 | 63 | 70 | 77 | 84
 | 8 | 16 | 24 | 32 | 40 | 48 | 56 | 64 | 72 | 80 | 88 | 96
 | 9 | 18 | 27 | 36 | 45 | 54 | 63 | 72 | 81 | 90 | 99 | 108
 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120
 | 11 | 22 | 33 | 44 | 55 | 66 | 77 | 88 | 99 | 110 | 121 | 132
 | 12 | 24 | 36 | 48 | 60 | 72 | 84 | 96 | 108 | 120 | 132 | 144
Spreadsheet: 32aef552-eef5-459a-bb59-df5b1bb64887
Sheet: Sheet1

FRENCHTOWN BRONCS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | NORTHWESTERN MONTANA 'A' BASKETBALL | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22
@ COLUMBIA FALLS | US | THEM |  | SUBMIT ASAP (PREFERABLY BY FOLLOWING MONDAY)
SCORE: | 51 | 34
2011-12-17 00:00:00 | W |  |  | mailto:[EMAIL]
PLAYER | PLAY | 3PT MAD | 3PT ATM | 3PT % | 2PT MAD | 2PT ATM | 2PT % | TOT FG | TOT FG % | FTM | FTA | FT % | TOT PTS | O REB | D REB | TOT RB | BLK | CHRG | STEAL | TOVR | ASST | FOUL
[NAME] | 1 | 1 | 4 | 0.25 | 2 | 8 | 0.25 | 3 | 0.25 | 1 | 8 | 0.125 | 8 |  | 2 | 2 |  |  | 2 | 4 | 1 | 1
[NAME] |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
[NAME] | 1 |  |  |  | 3 | 10 | 0.3 | 3 | 0.3 |  |  |  | 6 | 1 | 3 | 4 | 1 |  | 3 | 1 | 1 | 5
Kayla Blood10 | 1 | 1 | 3 | 0.3333333333333333 | 2 | 4 | 0.5 | 3 | 0.4285714285714285 | 2 | 3 | 0.6666666666666666 | 9 | 3 | 2 | 5 |  |  | 4 | 4 | 3 | 2
[NAME] | 1 |  |  |  | 3 | 8 | 0.375 | 3 | 0.375 | 6 | 6 | 1 | 12 | 1 | 2 | 3 |  |  | 4 | 4 | 0 | 2
[NAME] | 1 |  |  |  | 1 | 5 | 0.2 | 1 | 0.2 | 1 | 4 | 0.25 | 3 | 1 |  | 1 |  |  | 4 | 1 | 0 | 5
[NAME] | 1 |  | 1 | 0 | 2 | 8 | 0.25 | 2 | 0.2222222222222222 | 1 | 2 | 0.5 | 5 | 2 | 7 | 9 |  |  | 1 | 2 | 1 | 1
[NAME] |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
Morgan Ray09 | 1 |  |  |  | 2 | 2 | 1 | 2 | 1 | 3 | 5 | 0.6 | 7 | 1 |  | 1 |  |  | 1 | 0 | 0 | 2
[NAME] Berg11 | 1 |  |  |  |  | 3 | 0 | 0 | 0 | 1 | 4 | 0.25 | 1 | 2 |  | 2 |  |  | 1 | 2 | 0 | 2
[NAME] | 1 |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0 |  |  |  |  | 0 | 1
[NAME] |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
Team |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0 |  |  |  | 1
TOTALS | 1 | 2 | 8 | 0.25 | 15 | 48 | 0.3125 | 17 | 0.3035714285714285 | 15 | 32 | 0.46875 | 51 | 11 | 16 | 27 | 1 | 0 | 20 | 19 | 6 | 21
OPPONENT | 1 | 2 | 6 | 0.3333333333333333 | 8 | 32 | 0.25 |  | 0 | 12 | 25 | 0.48 | 34 | 9 | 6 |  |  |  |  | 26 |  | 11
Spreadsheet: 456466d1460885448-sumproduct-with-range-increment-monthly-sales-report
Sheet: For 2015-16

528
 | 0
Scheme Type
 | Gross Sales 15-16
 | Our | IND
AF | 0 | 0
B1 | 2.154 | 13.22
B2
CP
c
e1
e2
e3
e4
f1
f2
f3
g1
g2
g3
i
m
s
u
Grand Total | 2.154 | 13.22
Spreadsheet: 91347d1291111015-shared-spreadsheet-increasing-size-service-call-log-template
Sheet: Thursday

Service Call Log
 |  |  | [NAME] | Mick | [NAME] | [NAME]
Call total | 0 |  | 0 | 0 | 0 | 0
Date | Time | Name | Phone No. | Reg No. | Call taken by: | Call for: | Message | Status
 | [NAME] |  | [NAME] |  | To book in |  | Call put through
 | [NAME] |  | [NAME] |  | Checking Progress |  | Call back required
 | Other |  | [NAME] |  | Returning a call |  | Message only
 |  |  | [NAME] |  | Work Authority |  | URGENT!
 |  |  | [NAME] |  | Complaint |  | Completed
 |  |  |  |  | [NAME]
 |  |  |  |  | General enquiry
Spreadsheet: 813427d1673748508-perform-vlookup-on-cell-if-another-cell-contains-keyword-text-example1
Sheet: Table2

Day | Asset | Description | Serial # | Test Drive Required
1 | Classic Car | 1234 asdf | 1234
8 | 2WD Tractor | 123 qwerty | 2345
9 | T/A Day Cab Truck Tractor | 2010 Ford Truck Tractor (Inoperable) | 3456
7 | T/A Day Cab Truck Tractor | 2021 International Truck Tractor | 4576
Spreadsheet: 34279d1231436884-multiple-groups-in-excel-2002-uploadable-example-without-sorted-weeks-in-product-range-
Sheet: TotalSales

 | ProductRange1 | ProductRange2 | More product ranges this way -----> | Daily/Weekly Total | Monthly Total
12/01 | 35 | 0 |  | 35
12/02 | 55 | 0 |  | 55
12/03 | 75 | 0 |  | 75
12/04 | 95 | 0 |  | 95
12/05 | 115 | 0 |  | 115
12/06 | 135 | 0 |  | 135
12/07 | 155 | 0 |  | 155
2008/12/01 - 2008/12/07 | 665 | 0 |  | 665
12/08 | 195 | 0 |  | 195
12/09 | 215 | 0 |  | 215
12/10 | 235 | 0 |  | 235
12/11 | 255 | 0 |  | 255
12/12 | 275 | 0 |  | 275
12/13 | 295 | 0 |  | 295
12/14 | 315 | 0 |  | 315
2008/12/08 - 2008/12/14 | 1785 | 0 |  | 1785
12/15 | 355 | 0 |  | 355
12/16 | 375 | 0 |  | 375
12/17 | 395 | 0 |  | 395
12/18 | 415 | 0 |  | 415
12/19 | 435 | 0 |  | 435
12/20 | 455 | 0 |  | 455
12/21 | 475 | 0 |  | 475
2008/12/15 - 2008/12/21 | 2905 | 0 |  | 2905
12/22 | 515 | 0 |  | 515
12/23 | 535 | 0 |  | 535
12/24 | 555 | 0 |  | 555
12/25 | 575 | 0 |  | 575
12/26 | 595 | 0 |  | 595
12/27 | 615 | 0 |  | 615
12/28 | 635 | 0 |  | 635
2008/12/22 - 2008/12/28 | 4025 | 0 |  | 4025
12/29 | 675 | 0 |  | 675
12/30 | 695 | 0 |  | 695
12/31 | 715 | 0 |  | 715
2008-12 | 11465 | 0 |  |  | 11465
01/01 | 755 | 0 |  | 755
01/02 | 775 | 0 |  | 775
01/03 | 795 | 0 |  | 795
01/04 | 815 | 0 |  | 815
2008/12/29 - 2009/01/04 | 16690 | 0 |  | 5225
2009-01 | 3140 | 0 |  | 3140 | 3140
Spreadsheet: 139672d1328375482-event-spreadsheet-to-calendar-form-2012-best-schedule-ever
Sheet: Calendar

January 2012
SUNDAY |  | MONDAY |  | [NAME] |  | Wed |  | Thu |  | FRIDAY |  | SATURDAY
1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7
8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14
15 |  | 16 | [NAME], Jr. | 17 |  | 18 |  | 19 |  | 20 |  | 21
22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28
29 |  | 30 |  | 31
 |  |  |  |  | Notes : |  |  |  |  | 2012 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 2012 |  | 1
Spreadsheet: 687112d1594970676-dynamic-sum-until-sign-change-sum-till-sign-change
Sheet: Sheet1

 | Period | 0
 | Data | -1000 | 284 | 191 | -100 | 155 | 295 | 102 | 228 | 292 | -500 | -100 | 154 | 117 | 268 | -200 | 291 | 287 | 110 | 50
 | Sum at each period the remaining positiv and negative numbers until a sign change occurs
 | pos | 0 |  |  | 0 |  |  |  |  |  | 0 | 0 | etc…
 | [NAME] |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  | etc…
Spreadsheet: 870370d1716900532-xlookup-returning-n-a-error-check-error
Sheet: Sheet1

 |  | Lookup Value |  | Results |  |  |  |  |  |  |  |  | Lookup_Array | Return_Array
 | Original cell value | 61168.88 |  |  |  | <<=XLOOKUP(F5,Table1[Lookup_Array],Table1[Return_Array]) |  |  |  |  |  |  | 114600.78 | A
 | After pressing F2 and Enter | 61168.88 |  |  |  | <<=XLOOKUP(F6,Table1[Lookup_Array],Table1[Return_Array]) |  |  |  |  |  |  | 14234.929 | B
 |  |  |  |  |  |  |  |  |  |  |  |  | 61168.88 | C
 | Checker
 | Tried but not working |  |  |  |  | <<=XLOOKUP(VALUE(F5),Table1[Lookup_Array],Table1[Return_Array])
 | Solution 1 which works |  |  |  |  | <<=XLOOKUP(NUMBERVALUE(F5),Table1[Lookup_Array],Table1[Return_Array])
 | Solution 2 which works |  |  |  |  | <<=XLOOKUP(VALUE(CLEAN(F5)),Table1[Lookup_Array],Table1[Return_Array])
 | 61168.88
 | 61168.88
Spreadsheet: 788009d1658224559-help-with-index-match-against-a-partial-match-test1
Sheet: Sheet2

week number | Date | Del Date | [NAME] |  |  |  | Customer |  | Reason | Action |  | Whos     Order
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003959 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003958 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003957 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003956 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003955 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | [NAME] |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-18 00:00:00 | SRO-003953 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-18 00:00:00 | SRO-003952 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003951 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003950 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003949 |  |  |  |  |  |  | SHIPPED
Spreadsheet: phillip_m_love__30093__NCAA Tournament2001
Sheet: Standings

 |  |  | NCAA Tournament Pool 2001
Name | 1st Round | 2nd Round | 3rd Round | 4th Round | 5th Round | 6th Round | Total | Paid
[NAME] | 53 | 22 | 18 | 19 | 5 | 6 |  | x
[NAME] | 55 | 18 | 18 | 19 | 5 | 6 |  | x
[NAME] | 60 | 20 | 15 | 9 | 11 | 6 |  | x | Winner of Tie Breaker
Winfree | 42 | 22 | 18 | 19 | 5 | 6 |  | x
[NAME] | 47 | 20 | 18 | 15 | 5 | 6 |  | x
[NAME] | 44 | 20 | 15 | 14 | 11 | 6 |  | x
[NAME] | 49 | 18 | 12 | 13 | 11 | 6 |  | x
[NAME] | 54 | 20 | 18 | 9 | 6 | 0 |  | x
[NAME] | 39 | 22 | 18 | 15 | 5 | 6 |  | x
[NAME] | 44 | 18 | 18 | 13 | 5 | 6 |  | x
[NAME] | 48 | 22 | 15 | 9 | 6 | 0 |  | x
[NAME] | 40 | 20 | 15 | 13 | 11 | 0 |  | x
[NAME] | 56 | 18 | 18 | 6 | 0 | 0 |  | x
[NAME] | 32 | 20 | 18 | 9 | 11 | 6 |  | x
Brad Guilmino II | 52 | 14 | 9 | 8 | 5 | 6 |  | x
[NAME] | 44 | 20 | 15 | 9 | 6 | 0 |  | x
[NAME] | 35 | 23 | 12 | 13 | 5 | 6 |  | x
[NAME] | 34 | 18 | 15 | 9 | 11 | 6 |  | x
Tori Kuykendall | 31 | 18 | 12 | 15 | 11 | 6 |  | x
[NAME] | 36 | 20 | 15 | 10 | 5 | 6 |  | x
Kansas | 28 | 20 | 18 | 9 | 11 | 6 |  | x
[NAME] | 31 | 20 | 15 | 14 | 5 | 6 |  | x
Oneal | 31 | 18 | 18 | 13 | 5 | 6 |  | x
[NAME] | 30 | 20 | 18 | 15 | 6 | 0 |  | x
[NAME] | 38 | 16 | 15 | 13 | 5 | 0 |  | x
[NAME] | 32 | 18 | 18 | 9 | 6 | 0 |  | x
Errol McLaughlin II | 36 | 20 | 18 | 8 | 0 | 0 |  | x
[NAME] | 40 | 14 | 12 | 4 | 5 | 6 |  | x
[NAME] | 32 | 18 | 15 | 9 | 6 | 0 |  | x
Flannigan | 29 | 14 | 12 | 13 | 11 | 0 |  | x
[NAME] | 26 | 21 | 12 | 9 | 5 | 6 |  | x
[NAME] | 32 | 23 | 19 | 4 | 0 | 0 |  | x
[NAME] | 30 | 20 | 18 | 8 | 0 | 0 |  | x
Denver Plachy | 18 | 14 | 12 | 15 | 11 | 6 |  | x
[NAME] | 27 | 18 | 15 | 5 | 6 | 0 |  | x
[NAME] | 48 | 16 | 6 | 0 | 0 | 0 |  | x
[NAME] | 46 | 16 | 6 | 0 | 0 | 0 |  | x
[NAME] | 32 | 20 | 12 | 4 | 0 | 0 |  | x
[NAME] | 31 | 12 | 6 | 5 | 6 | 0 |  | x
[NAME] | 25 | 18 | 12 | 0 | 0 | 0 |  | x
[NAME] | 20 | 18 | 12 | 4 | 0 | 0 |  | x
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 9b

Product1 | USD | EUR3 | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Fixed-Float | 1276121 | 687907 | 126456 | 60708 | 22180 | 33346 | 74558 | 2281277
OTHER* | 733611 | 527630 | 132042 | 11359 | 84962 | 30566 | 47113 | 1567285
TOTAL
*OTHER variable includes the following products: Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, Basis, OIS, and FRA.
Spreadsheet: kate_symes__19076__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-11 00:00:00 |  | 386.02 | 10560 | 337.56 | 7552
 | 2001-04-10 00:00:00 |  | 379.15 | 19760 | 331.04 | 9192 | 398 | 621 | 337.4 | 615
 | 2001-04-09 00:00:00 |  | 311.43 | 19600 | 264.75 | 6584 | 334.15 | 437 | 337.5 | 100
 | 2001-04-08 00:00:00 |  | 273.75 | 1600 | 255 | 0 | 349.76 | 1330 | 342.22 | 135 |  | 264.68 | 20136
 | 2001-04-07 00:00:00 |  | 291.19 | 18496 | 225.83 | 11824 | 293.05 | 1559 | 279.89 | 435
 | 2001-04-06 00:00:00 |  | 291.19 | 18496 | 225.83 | 11824 | 290.88 | 400 | 227.31 | 325
 | 2001-04-05 00:00:00 |  | 348.81 | 22560 | 266.94 | 2480 | 259.38 | 200 | 158.94 | 610
 | 2001-04-04 00:00:00 |  | 314.36 | 18160 | 238.83 | 8040 | 307.45 | 455 | 246.52 | 460
 | 2001-04-03 00:00:00 |  | 305.4 | 18160 | 224.33 | 7200 | 300.45 | 350 | 288.25 | 1310
 | 2001-04-02 00:00:00 |  | 284.36 | 24400 | 227.63 | 9504 | 294.16 | 942 | 216.95 | 351
 | 2001-04-01 00:00:00 |  | 236.99 | 2336 | 225 | 0 | 243.67 | 158 | 219.78 | 273 |  | 229.73 | 26352
 | 2001-03-31 00:00:00 |  | 179.66 | 24400 | 125.17 | 9640 | 220.77 | 698 | 100 | 4
 | 2001-03-30 00:00:00 |  | 179.99 | 23600 | 125.18 | 9040 | 203.23 | 798 | 173.41 | 504
 | 2001-03-29 00:00:00 |  | 187.27 | 26400 | 130.98 | 10880 | 181.96 | 553 | 151.95 | 154
 | 2001-03-28 00:00:00 |  | 161.91 | 27600 | 100.36 | 9480 | 170.67 | 208 | 110.85 | 544
 | 2001-03-27 00:00:00 |  | 155.95 | 22800 | 89.58 | 6200 | 152.08 | 1038 | 121.24 | 169
 | 2001-03-26 00:00:00 |  | 334.36 | 15600 | 230.55 | 6600 | 102.59 | 243 | 60.96 | 287
 | 2001-03-25 00:00:00 |  | 260 | 0 | 230 | 0 | 70 | 200 | 41.32 | 456 |  | 229.94 | 19200
 | 2001-03-24 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 113.77 | 1687 | 139.44 | 832
 | 2001-03-23 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 331.82 | 1155 | 150 | 4
 | 2001-03-22 00:00:00 |  | 377.69 | 16800 | 274.53 | 6400 | 233.97 | 521 | 266.13 | 248
 | 2001-03-21 00:00:00 |  | 452.08 | 17280 | 319.69 | 4928 | 443.97 | 58 | 294.11 | 259
 | 2001-03-20 00:00:00 |  | 402.53 | 16000 | 277.64 | 5952 | 456.15 | 488 | 316.05 | 214
 | 2001-03-19 00:00:00 |  | 397.48 | 26800 | 342.53 | 7360 | 398.47 | 1222 | 145.95 | 454
 | 2001-03-18 00:00:00 |  | 370 | 0 | 330 | 0 | 140.35 | 285 | 146.22 | 1255 |  | 343.75 | 22080
 | 2001-03-17 00:00:00 |  | 245.91 | 18400 | 217.72 | 9200 | 400 | 50 | 215.18 | 140
 | 2001-03-16 00:00:00 |  | 245.91 | 18400 | 217.72 | 9200 | 325 | 415 | 188.89 | 405
 | 2001-03-15 00:00:00 |  | 216.73 | 20560 | 174.7 | 10144 | 237.58 | 642 | 186.25 | 260
 | 2001-03-14 00:00:00 |  | 211.45 | 25360 | 172.67 | 8512 | 225.87 | 1552 | 157.5 | 480
 | 2001-03-13 00:00:00 |  | 211.79 | 20960 | 168.03 | 9088 | 235.45 | 33 | 150.36 | 445
 | 2001-03-12 00:00:00 |  | 263.78 | 24240 | 255.08 | 7632 | 223.3 | 996 | 176.32 | 106
 |  |  |  |  |  | ..
Spreadsheet: 84953d1285054130-one-payment-multiple-dates-summation-one-payment-multiple-dates
Sheet: OP MD S

Payment | date | date | date
25 | 2009-05-14 00:00:00 | 2009-07-14 00:00:00 | 2009-09-14 00:00:00 |  | one payment, multiple dates, summation
30 | 2009-06-14 00:00:00 | 2009-08-14 00:00:00 | 2009-10-14 00:00:00 |  | http://www.excelforum.com/excel-worksheet-functions/746350-one-payment-multiple-dates-summation.html
40 | 2009-11-15 00:00:00 | 2009-12-15 00:00:00
50 | 2009-05-15 00:00:00 | 2009-09-15 00:00:00 | 2010-01-15 00:00:00 |  | TMShucks
 | Sum amt Month | Attempt 1 | Attempt 2
2009-05-01 00:00:00 | 75 |  |  |  | =SUMPRODUCT((($B$2:$D$5<>"")*(MONTH($B$2:$D$5)=MONTH($A9))*($A$2:$A$5)))
2009-06-01 00:00:00 | 0
 | 25
 | 0
 | 75
 | 0
 | 0
 | 0
 | 50
Spreadsheet: 067848f6-25b7-4f33-b783-f68b785d54d0
Sheet: Calculator

Name:
 | TENURE PROBATION PERIOD CALCULATOR
Enter data in these three fields:
 | Enter start date: | 2012-07-01 00:00:00
 | Years toward tenure granted upon hire: | 0
 | Was a Mid-Year Extension approved? | No
Timeline:
 | Third year review
 | Tenure package submittal
 | Tenure case consideration year
 | Tenure probation end date
Calculation:
 | TENURE STATUS DATE
 | CALCULATION:
 | Year 0 |  | -
 | Year 1 |  | -
 | Year 2 |  | -
 | Year 3 |  | -
 | Year 4 |  | -
 | Year 5 |  | -
 | Year 6 |  | -
 | Year 7 |  | -
 | *  HR - Print and retain copy of this calculation with offer letter
Spreadsheet: 00612e73-0a66-48ee-961b-afce64ad0a20
Sheet: Sheet1

Cost of Living Index | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Selected Cities
Third Quarter 2013 Data
City | All Items Index* | Grocery | Housing | Utilities | Transportation | Healthcare | Goods and Services
Albuquerque, NM | 94.3 | 90.9 | 82.5 | 90.1 | 102.6 | 96.7 | 103.5
Atlanta, GA | 93.5 | 90 | 87.3 | 91.5 | 102.2 | 99.7 | 96.6
[NAME], TX | 92.5 | 84.8 | 88.1 | 83.8 | 97.3 | 93.4 | 100.1
Boston, MA | 140.1 | 129.8 | 177.4 | 139.2 | 103.1 | 126.6 | 129.4
Chicago, IL | 117.4 | 100.6 | 141.8 | 100.3 | 122 | 103.5 | 109.8
Dallas, TX | 95.7 | 90.3 | 73.7 | 103 | 103.5 | 103.2 | 110.1
Denver, CO | 104 | 94.5 | 118 | 101.7 | 93.2 | 98.7 | 102
Houston, TX | 99 | 78.7 | 109.4 | 106.5 | 93.4 | 94.2 | 99.1
Las Vegas, NV | 102.7 | 93.8 | 103.1 | 92.2 | 105.5 | 100.7 | 108.5
Los Angeles, CA | 131 | 104.2 | 196.2 | 109.6 | 112.8 | 109.4 | 104.5
Miami-Dade County, FL | 107.2 | 101.8 | 120.6 | 94.7 | 107.5 | 104.5 | 102.5
Phoenix, AZ | 97.3 | 93.5 | 98.4 | 101.1 | 96.2 | 96.9 | 97.2
Portland, OR | 119.1 | 101.9 | 147.6 | 93.9 | 117.9 | 117.3 | 111.1
Raleigh-Cary, NC | 94.6 | 101 | 83.2 | 104.6 | 100.1 | 99.1 | 95.5
Salt Lake City, UT | 92.4 | 86.4 | 94 | 83.1 | 96.5 | 96.3 | 94.6
San Diego, CA | 129.2 | 103.4 | 194.9 | 97 | 113.7 | 107.6 | 104.3
San Francisco, CA | 159.9 | 117.9 | 285.5 | 97.7 | 113.6 | 119.2 | 115.5
San Jose, CA | 148.8 | 110.1 | 250.3 | 124.9 | 111.5 | 112.2 | 107
Seattle, WA | 117.5 | 98.5 | 136.1 | 97.2 | 117.9 | 118.4 | 115.9
St. Louis, MO-IL | 94.4 | 101.6 | 73.2 | 112.1 | 105.2 | 99.4 | 98.7
Washington, DC | 141.6 | 111.2 | 251.1 | 95.1 | 105.7 | 97.3 | 97.4
*Index measures the relative price levels for consumer goods and services in selected
cities as compared with the national average of 100 for all participating cities.
Source:  Council for Community and Economic Research, Third Quarter Data.
Revised November 2013
 |  | Metro Denver EDC
Spreadsheet: 687535d1595264987-budgeting-spreadsheet-2020-07-20-oeldere-mbradley84-687514d1595257494-budgeting-spreadsheet-example-1
Sheet: Oeldere

Name | Group | Date Paid | value | date
Paycheck #1 | income | 15th | -1000 | < = 15 |  |  | Som van value | Kolomlabels
Paycheck #2 | income | 26th | -500 | >15 |  |  | Rijlabels | < = 15 | >15 | Eindtotaal
Paycheck #3 | income | 31st | -1000 | >15 |  |  | income | -1000 | -1500 | -2500
Mortgage | expenses | 1st | 1000 | < = 15 |  |  | Paycheck #1 | -1000 |  | -1000
Car Payment | expenses | 10th | 500 | < = 15 |  |  | Paycheck #2 |  | -500 | -500
Electric | expenses | 12th | 60 | < = 15 |  |  | Paycheck #3 |  | -1000 | -1000
Gas | expenses | 13th | 50 | < = 15 |  |  | expenses | 1685 | 140 | 1825
Water | expenses | 27th | 40 | >15 |  |  | Car Payment | 500 |  | 500
Insurance | expenses | 4th | 75 | < = 15 |  |  | Credit Card |  | 100 | 100
Credit Card | expenses | 18th | 100 | >15 |  |  | Electric | 60 |  | 60
 |  |  |  |  |  |  | Gas | 50 |  | 50
Step 1 |  |  |  |  |  |  | Insurance | 75 |  | 75
In B2 through B4 person will enter amount of paycheck |  |  |  |  |  |  | Mortgage | 1000 |  | 1000
 |  |  |  |  |  |  | Water |  | 40 | 40
Step 2 |  |  |  |  |  |  | Eindtotaal | 685 | -1360 | -675
In C2 through C5 person will enter date paid
Step 3
In A10 through A16 person will enter bills and in the following columns they will enter due dates and the amount due.  I would like the formula to only place the amount due in that box if it falls before or after the date paid they selected. (Example, I do not want to have it list the "Water" bill in the Column for Paycheck #1 or Paycheck #3.  Make sense?
Step 4
In the boxes H7 through K13 I would like a formula that will put the amount due based on paycheck date and due date of the bills, and I would also like to split the payments up as to not consume the entire paychecks (Ex. Mortgage is $1000.00 and would like that split up between at least two paychecks.
Ultimate goal is to have this calculate how much money from each check should be set aside to cover the bills for the entire month.  Which means that the totals in columns H, I, and J, cannot exceed the amounts of each paycheck.  Is that even possible?