tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 157877d1337898513-formula-for-calculating-accrual-vacation-time-employee-pto-accrual-1-
Sheet: Sheet1

 | [NAME] | [NAME] | [NAME] | [NAME]
Start_Date | 2011-07-11 00:00:00 | 2008-06-14 00:00:00 | 2012-05-07 00:00:00 | 2011-05-08 00:00:00
Accural begins | 2012-01-09 12:00:00 | 2008-12-14 00:00:00 | 2012-11-06 00:00:00 | 2011-11-06 12:00:00 | 1900-07-01 00:00:00 | 1900-07-01 00:00:00 | 1900-07-01 00:00:00 | 1900-07-01 00:00:00 | 1900-07-01 00:00:00 | 1900-07-01 00:00:00 | 1900-07-01 00:00:00 | 1900-07-01 00:00:00
Vac_Rate | 3.33 | 3.33 | 0 | 3.33 | 3.33 | 3.33 | 3.33 | 3.33 | 3.33 | 3.33 | 3.33 | 3.33
Vac_Avail | 0 | 276.39 | 0 | 11.29 | 8947.710000000001 | 8947.710000000001 | 8947.710000000001 | 8947.710000000001 | 8947.710000000001 | 8947.710000000001 | 8947.710000000001 | 8947.710000000001
Vac_Used |  |  |  | 5
 | 5 |  |  | 7 |  |  |  |  |  |  |  |  |  |  | 2012-05-24 00:00:00
 | 7 |  |  | 5
 | 5 |  |  | 1
 | 10 |  |  | 6
 | 11 |  |  | 8
 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.33
Spreadsheet: 0671d617-be13-41fd-9b38-40314052c875
Sheet: Sheet1

 | [NAME] | Custer | McMindes | Wiest | Subtotal | Traditional Hall Occupancy | Wooster | [NAME] | Subtotal | FHSU Occupancy | Stadium | Stadium Occupancy | Total | Overall Occupancy
Capacity 05-06 | 122 | 81 | 589 | 375 |  |  | 84 |  |  |  | 116
Fall 2005 | 91 | 64 | 511 | 166 |  |  | d/k | d/k | d/k | d/k | 41 |  | d/k | d/k
Spring 2006 | 91 | 56 | 467 | 125 |  |  | d/k | d/k | d/k | d/k | d/k | d/k | d/k | d/k
Capactity 06-07 | 114 | 81 | 589 | 375 |  |  | 84 |  |  |  | 116
Fall 2006 | 64 | 63 | 503 | 104 |  |  | 70 |  |  |  | 53
Spring 2007 | 58 | 57 | 433 | 76 |  |  | 68 |  |  |  | 58
Capacity 07-08 | 114 | 81 | 589 | 375 |  |  | 84 |  |  |  | 116
Fall 2007 | 77 | 63 | 508 | 190 |  |  | 71 |  |  |  | 72
Spring 2008 | 68 | 58 | 447 | 132 |  |  | 66 |  |  |  | 97
Capacity 08-09 | 114 | 51 | 589 | 300 |  |  | 84 |  |  |  | 116
Fall 2008 | 62 | 60 | 510 | 178 |  |  | 72 |  |  |  | 115
Spring 2009 | 57 | 56 | 447 | 135 |  |  | 80 |  |  |  | 110
Capacity 09-10 | 122 | 59 | 599 | 281 |  |  | 112 |  |  |  | 116
Fall 2009 | 96 | 28 | 516 | 235 |  |  | 88 |  | 963 |  | 114
Spring 2010
*84 - There are 84 apartments with 112 bedrooms
Spreadsheet: andy_zipper__627__11_21_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 53 | 330 | 430 | 60.9 | 79.3 | 2.34 | 2001-11-21 10:33:00
 | HU F2 | 54 | 720 | 820 | 54.2 | 61.8 | 1.97 | 2001-11-21 10:33:00
 | HU G2 | 54 | 970 | 1070 | 52.6 | 58.1 | 1.88 | 2001-11-21 10:33:00
 | [NAME] | 55 | 1100 | 1225 | 49.5 | 55.2 | 1.81 | 2001-11-21 10:33:00
 | [NAME] | 62 | 1400 | 1525 | 49.4 | 53.8 | 2.01 | 2001-11-21 10:33:00
 | [NAME] | 62 | 1500 | 1625 | 47.5 | 51.5 | 1.93 | 2001-11-21 10:33:00
 | [NAME] | 62 | 1570 | 1700 | 45.4 | 49.2 | 1.84 | 2001-11-21 10:33:00
 | HU N2 | 62 | 1580 | 1750 | 42.8 | 47.4 | 1.76 | 2001-11-21 10:33:00
 | [NAME] | 62 | 1580 | 1750 | 40.1 | 44.5 | 1.65 | 2001-11-21 10:33:00
 | HU U2 |  |  |  | 36 | 39.4 | 1.59 | 2001-10-29 14:33:00
 | [NAME] |  |  |  | 32.2 | 36.6 | 1.43 | 2001-10-22 14:23:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU F3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | HU H3
Spreadsheet: 274676d1383179280-help-with-formula-for-sport-fixtures-badsa-fixtures
Sheet: 6 team

Date | Round | Match | Home | Away |  | Diamond | Time | Umpires |  |  | TEAM NAMES
 | 1 | 1 | 2 Wanderers | 1 Blue Jays |  |  |  |  |  | 1 | Blue Jays
 | 1 | 2 | 4.Tigers 2 | 3 Tigers 1 |  |  |  |  |  | 2 | Wanderers
 | 1 | 3 | Bye | 5 Steelers |  |  |  |  |  | 3 | Tigers 1
 | 2 | 1 | 3 Tigers 1 | Bye |  |  |  |  |  | 4 | Tigers 2
 | 2 | 2 | 1 Blue Jays | 4 Tigers 2 |  |  |  |  |  | 5 | Steelers
 | 2 | 3 | 5 Steelers | 2 Wanderers |  |  |  |  |  | 6 | Bye
 | 3 | 1 | 2.Wanderers | 6 Bye
 | 3 | 2 | 4 Tigers 2 | 5 Steelers
 | 3 | 3 | 3.Tigers1 | 1 Blue Jays
 | 4 | 1 | 1 Blue Jays | 5 Steelers
 | 4 | 2 | 2 Wanderers | 3 Tigers 1
 | 4 | 3 | 6 Bye | 4 Tigers 2
 | 5 | 1 | 5 Steelers | 3 Tigers 1
 | 5 | 2 | 6.Bye | 1 Blue jays
 | 5 | 3 | 4 Tigers 2 | 2 Wanderers
 | 6 | 1 | 1 Blue Jays | 2 Wanderers
 | 6 | 2 | 3 Tigers 1 | 4 Tigers 2
 | 6 | 3 | 5 Steelers | 6 Bye
 | 7 | 1 | 6 Bye | 3 Tigers 1
 | 7 | 2 | 4 Tigers 2 | 1 Blue Jays
 | 7 | 3 | 2 Wanderers | 5 Steelers
 | 8 | 1 | 6 Bye | 2 Wanderers
 | 8 | 2 | 5 Steelers | 4 Tigers 2
 | 8 | 3 | 1 Blue Jays | 3 Tigers 1
 | 9 | 1 | 5 Steelers | 1 Blue Jays
 | 9 | 2 | 3 Tigers 1 | 2 Wanderers
 | 9 | 3 | 4 Tigers 2 | 6 Bye
 | 10 | 1 | 3 Tigers 1 | 5 Steelers
 | 10 | 2 | 1 Blue Jays | 6 Bye
 | 10 | 3 | 2 Wanderers | 4 Tigers 2
 | 11 | 1 | 2 Wanderers | 1 Blue Jays
 | 11 | 2 | 4 Tigers 2 | 3 Tigers 1
 | 11 | 3 | 6 Bye | 5 Steelers
 | 12 | 1 | 3 Tigers 1 | 6 Bye
 | 12 | 2 | 1 Blue Jays | 4 Tigers 2
 | 12 | 3 | 5 Steelers | 2 Wanderers
 | 13 | 1 | 2 Wanderers | 6 Bye
 | 13 | 2 | 4 Tigers 2 | 5 Steelers
 | 13 | 3 | 3 Tigers 1 | 1 Blue Jays
 | 14 | 1 | 1 Blue Jays | 5 Steelers
 | 14 | 2 | 2 Wanderers | 3 Tigers 1
 | 14 | 3 | 6 Bye | 4 Tigers 2
 | 15 | 1 | 5 Steelers | 3 Tigers 1
 | 15 | 2 | 6 Bye | 1 Blue Jays
 | 15 | 3 | 4 Tigers 2 | 2 Wanderers
 | 16 | 1 | 1 | 2
 | 16 | 2 | 3 | 4
 | 16 | 3 | 5 | 6 Bye
 | 17 | 1 | 6 | 3
 | 17 | 2 | 4 | 1
 | 17 | 3 | 2 | 5
 | 18 | 1 | 6 Bye | 2
 | 18 | 2 | 5 | 4
 | 18 | 3 | 1 | 3
 | 19 | 1 | 5 | 1
 | 19 | 2 | 3 | 2
 | 19 | 3 | 4 | 6 Bye
 | 20 | 1 | 3 | 5
 | 20 | 2 | 1 | 6 Bye
 | 20 | 3 | 2 | 4
 | 21 | 1 | 2 | 1
 | 21 | 2 | 4 | 3
 | 21 | 3 | 6 | 5
 | 22 | 1 | 3 | 6
 | 22 | 2 | 1 | 4
 | 22 | 3 | 5 | 2
 | 23 | 1 | 2 | 6
 | 23 | 2 | 4 | 5
 | 23 | 3 | 3 | 1
 | 24 | 1 | 1 | 5
 | 24 | 2 | 2 | 3
 | 24 | 3 | 6 | 4
 | 25 | 1 | 5 | 3
 | 25 | 2 | 6 | 1
 | 25 | 3 | 4 | 2
 | 26 | 1 | 1 | 2
 | 26 | 2 | 3 | 4
 | 26 | 3 | 5 | 6
 | 27 | 1 | 6 | 3
 | 27 | 2 | 4 | 1
 | 27 | 3 | 2 | 5
 | 28 | 1 | 6 | 2
 | 28 | 2 | 5 | 4
 | 28 | 3 | 1 | 3
 | 29 | 1 | 5 | 1
 | 29 | 2 | 3 | 2
 | 29 | 3 | 4 | 6
 | 30 | 1 | 3 | 5
 | 30 | 2 | 1 | 6
 | 30 | 3 | 2 | 4
Spreadsheet: 85958d1285944499-error-with-if-statement-oct-march-1011-termtime-only
Sheet: December

 | YOUTH ASSOCIATION SOUTH YORKSHIRE - STAFF TIMESHEET
 | Name
 | Date | Start AM | Finish | Start PM | Finish | Holiday | Sick | Total | Project/Location/Outputs
Monday | 2010-11-29 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Tuesday | 2010-11-30 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Wednesday | 2010-12-01 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Thursday | 2010-12-02 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Friday | 2010-12-03 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 25
Monday | 2010-12-06 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Tuesday | 2010-12-07 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Wednesday | 2010-12-08 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Thursday | 2010-12-09 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Friday | 2010-12-10 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 25
Monday | 2010-12-13 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Tuesday | 2010-12-14 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Wednesday | 2010-12-15 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Thursday | 2010-12-16 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Friday | 2010-12-17 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 25
Monday | 2010-12-20 00:00:00 |  |  |  |  |  |  | 0 | CHRISTMAS HOLS
Tuesday | 2010-12-21 00:00:00 |  |  |  |  |  |  | 0 | CHRISTMAS HOLS
Wednesday | 2010-12-22 00:00:00 |  |  |  |  |  |  | 0 | CHRISTMAS HOLS
Thursday | 2010-12-23 00:00:00 |  |  |  |  |  |  | 0 | CHRISTMAS HOLS
Friday | 2010-12-24 00:00:00 |  |  |  |  |  |  | 0 | CHRISTMAS HOLS
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 0
 | 2010-12-27 00:00:00 |  |  |  |  |  |  | 0 | BANK HOLIDAY
 | 2010-12-28 00:00:00 |  |  |  |  |  |  | 0 | BANK HOLIDAY
 | 2010-12-29 00:00:00 |  |  |  |  |  |  | 0 | CHRISTMAS HOLS
 | 2010-12-30 00:00:00 |  |  |  |  |  |  | 0 | CHRISTMAS HOLS
 | 2010-12-31 00:00:00 |  |  |  |  |  |  | 0 | CHRISTMAS HOLS
 | Total |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | Total | 0 | 0 | 75.00000000000001
 | Signed | ……………………………………… |  |  | Please print off, sign and
 |  |  |  |  | Submit this timesheet by 8th January
 | Date | ………………………………………
 | Notes/Comments
Spreadsheet: 143718d1330536887-excel-2008-cells-with-external-references-not-updating-contract_fishsc_template
Sheet: Blank Form

[NAME]: |  |  | [NAME]:
Supplier Phone #: |  |  | [NAME] [NAME]:
Contract ID #:(REQUIRED) |  |  |  | Customer Name:
Previous Contract ID# |  |  |  | Customer Address:
Contract Start Date: |  |  |  |  | Line 2:
Contract End Date: |  |  |  |  | City:
 |  |  |  |  | State:
Please designate the type of Contract Event from the drop down |  |  |  |  | Zip:
 |  |  | Fisher Account #  (optional)
 |  |  |  |  | For large lists of account numbers, please use account tab.
Fisher Scientific Catalog # | Vendor Catalog # | Product Description | Unit of Measure | Quantity per UOM | Suggested End User Price | Guaranteed Margin % | Guaranteed Cost $ | Date item added (optional)
Spreadsheet: 621874d1556432850-carton-box-size-calculator-formula-xlforum-0236
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | L | W | H
 |  |  |  |  |  |  |  |  |  |  |  | 385 | 200 | 100
254 | 178 | 76 | Box | 1: | 254 | x | 178 | x | 76
330 | 229 | 102 | Box | 2: | 330 | x | 229 | x | 102
406 | 305 | 76 | Box | 3: | 406 | x | 305 | x | 76
356 | 254 | 127 | Box | 4: | 356 | x | 254 | x | 127
356 | 203 | 178 | Box | 5: | 356 | x | 203 | x | 178
483 | 305 | 102 | Box | 6: | 483 | x | 305 | x | 102
406 | 305 | 152 | Box | 7: | 406 | x | 305 | x | 152
457 | 229 | 216 | Box | 8: | 457 | x | 229 | x | 216
485 | 330 | 152 | Box | 9: | 485 | x | 330 | x | 152
356 | 305 | 254 | Box | 10: | 356 | x | 305 | x | 254
457 | 356 | 203 | Box | 11: | 457 | x | 356 | x | 205
559 | 457 | 305 | Box | 12: | 457 | x | 568 | x | 305
Spreadsheet: 40192d1238512007-change-sumproduct-to-if-with-exchange-rate-678002_ying
Sheet: CONSOLIDATE

TOTAL IN USD |  |  |  |  | Change Type: | FG |  |  |  | FG
2009 | JAN | SEA |  | JAN | AIR |  |  |  |  | RM
COUNTRY | FOB | FREIGHT | TOTAL | FOB | FREIGHT | TOTAL
CHN | 196.4973077 | 2.3223582 | 198.8196659 | 0 | 0 | 0
GBR | 146.3811405 | 20.9115915 | 167.292732 | 146.3811405 | 20.9115915 | 167.292732
USA | 510 | 25 | 535 | 510 | 25 | 535
Spreadsheet: 870253d1716801618-search-for-value-within-range-and-return-a-list-book1
Sheet: Sheet2

#5 |  | #1 | #2 | #3 | #4 | #5 | #6 | #7 | #8
 |  | WK02: 02/12-02/16 | WK03: 02/19-02/23 | WK04: 02/26-03/01 | WK05: 03/04-03/08 | WK06: 03/11-03/15 | WK07: 03/18-03/22 | WK08: 03/25-03/29 | WK09: 04/01-04/05
[NAME] |  | [NAME] | [NAME] |  |  | [NAME] |  | [NAME]
[NAME] |  | [NAME] | [NAME] |  |  | [NAME] |  | K1Yuna
[NAME] |  | KHenry |  |  |  | [NAME] |  | [NAME]
 |  | [NAME] |  |  |  |  |  | KAudry
 |  | KElina
Spreadsheet: louise_kitchen__22729__0201MarginRequirements
Sheet: 0111

FUTURES MARGIN REQUIREMENTS
2002-01-14 00:00:00
2002-01-11 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  |  |  | CANADIAN $$$ |  | US $$$
Broker | TE | Credit Facility Covering TE | TE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Daily Facility Movement Inc/(Dec) Line |  | Wire Day Cash In/(Out) |  | TE | Initial Margin | OTE
ABN-Amro Inc | 148571.6360000279 |  | 148571.6360000279 | 0 | 0 |  | 0 |  |  |  | 148571.6360000279 |  |  |  | 0
ADM INVESTOR | 0.1990000053192489 |  | 0.1990000053192489 | 0 | 0 |  | 0 |  |  |  | 0.1990000053192489 |  |  |  | 0
BANK ONE | 0.2200000286102295 |  | 0.2200000286102295 | 0 | 0 |  | 0 |  |  |  | 0.2200000286102295 |  |  |  | 0
CARR FUTURES (NG) | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
CARR FUTURES INC. | 4350649.816895109 |  | 4350649.816895109 | 0 | 0 |  | 0 |  |  |  | 4350649.816895109 |  |  |  | 0
CREDIT SUISSE FIRST BOSTON | 29866.61000000313 |  | 29866.61000000313 | 0 | 0 |  | 0 |  |  |  | 29866.61000000313 |  |  |  | 0
EDF MAN | 8383992.715999773 |  | 8383992.715999773 | 0 | 0 |  | 0 |  |  |  | 8383992.715999773 |  |  |  | 0
FIMAT | 2275935.16 |  | 2275935.16 | 0 | 0 |  | 0 |  |  |  | 2275935.16 |  |  |  | 0
HSBC - US$ | -2131.681408999983 |  | -2131.681408999983 | 0 | 0 |  | 0 |  |  |  | -2131.681408999983 |  |  |  | 0
HSBC - Canadian | 0 |  | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 64204.5 | 0 | 0
JP Morgan | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
[NAME] | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
PARIBAS | 80371717.16000006 |  | 80371717.16000006 | 0 | 0 |  | 0 |  |  |  | 80371717.16000006 |  |  |  | 0
PRUDENTIAL SI | -0.09857879066839814 |  | -0.09857879066839814 | 0 | 0 |  | 0 |  |  |  | -0.09857879066839814 |  |  |  | 0
REFCO, INC | 0.2590000069403686 |  | 0.2590000069403686 | 0 | 0 |  | 0 |  |  |  | 0.2590000069403686 |  |  |  | 0
R J O'BRIEN | 0.1799999999930151 |  | 0.1799999999930151 | 0 | 0 |  | 0 |  |  |  | 0.1799999999930151 |  |  |  | 0
SAUL STONE & COMPANY | 0.180000000000291 |  | 0.180000000000291 | 0 | 0 |  | 0 |  |  |  | 0.180000000000291 |  |  |  | 0
SMITH BARNEY, INC | 53592.45999999158 |  | 53592.45999999158 | 0 | 0 | 0 | 0 |  |  |  | 53592.45999999158 |  |  |  | 0
SMITH BARNEY, INC  (Financial) | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
TOTAL EXCLUDING MID-DAY CALLS | 95612194.81690721 | 0 | 95612194.81690721 | 0 | 0 | 0 | 0 |  | 0 |  | 95612194.81690721 |  | 64204.5 | 0 | 0
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS | 95612194.81690721
 |  |  |  |  |  |  |  |  |  |  |  |  | 95612194.81690721
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0 | 0 | 0 | 50000000
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: 824399d1680543214-comparing-two-lists-with-multiple-columns-lists
Sheet: Sheet10

Player | Year | Goals | Assists
[NAME] | 2016 | 29 | 39
Thorton | 2016 | 7 | 43
Burns | 2016 | 29 | 47
Couture | 2016 | 25 | 27
Meir | 2016 | 3 | 3
Herti | 2016 | 10 | 12
[NAME] | 2017 | 22 | 44
Thorton | 2017 | 13 | 23
Burns | 2017 | 12 | 55
Couture | 2017 | 34 | 27
Meir | 2017 | 21 | 15
Herti | 2017 | 22 | 24
[NAME] | 2018 | 23 | 10
Thorton | 2018 | 6 | 12
Burns | 2018 | 6 | 34
Couture | 2018 | 15 | 24
Meir | 2018 | 18 | 17
Herti | 2018 | 14 | 19
Player | 2016 | 2017 | 2018
[NAME]
Thorton
Burns
Couture
Meir
Herti
Spreadsheet: 825258d1681216687-alternative-to-sumproduct-sumproduct-alternative
Sheet: Sheet1

 |  | Jan | Feb | Mar | Apr | Apr | May | Jun | Jun | Jul | Total
 | cat | 1 | 2 | 1 | 3 | 3 | 3 | 1 | 1 | 1
 | dog | 1 | 1 | 3 | 1 | 1 | 1 | 3 | 1 | 3
 | fish | 1 | 2 | 3 | 1 | 3 | 1 | 3 | 1 | 1
 | Total
 | Animal | cat
 | Month | Apr
 | Sumproduct:
 | Alternative:
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 117749 | 151521 |  | -28656 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 151814 | 163364 |  | -14405 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 143004 | 151503 |  | -9438 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 154169 | 157385 |  | -4768 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 157375 | 160673 |  | -4235 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 157588 | 161529 |  | -4769 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 145516 | 151339 |  | -6919 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 140246 | 150353 |  | -12536 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 139389 | 150587 |  | -14369 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 147301 | 150703 |  | -4769 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 | 149404 | 151327 |  | -11510 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 | 166837 | 172663 |  | -6546 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 | 146938 | 159065 |  | -13761 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14 | 153581 | 160162 |  | -8714
15 | 145340 | 152613 |  | -8653 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 | 139911 | 152383 |  | -11445 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 | 152893 | 155464 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-11-30 00:00:00
 | 2001-12-17 00:00:00
 | CBS Dollars
 |  |  |  | -410963
Spreadsheet: 818889d1677102514-formula-for-pay-periods-numbering-leap-year-and-number-of-pay-periods-in-a-year-sample_paying-num_1
Sheet: Bi_2

Pay Periods | Begin Date | Day of the week | End Date | Day of the week |  | Start | 2021-12-27 00:00:00 |  | End | 2022-12-30 00:00:00
1 | 2021-12-27 00:00:00 | Monday | 2022-01-09 00:00:00 | Sunday
2 | 2022-01-10 00:00:00 | Monday | 2022-01-23 00:00:00 | Sunday |  |  |  |  | Leap Year? |  | No
3 | 2022-01-24 00:00:00 | Monday | 2022-02-06 00:00:00 | Sunday |  |  | # of pay periods per year |  |  | 26
4 | 2022-02-07 00:00:00 | Monday | 2022-02-20 00:00:00 | Sunday
5 | 2022-02-21 00:00:00 | Monday | 2022-03-06 00:00:00 | Sunday
6 | 2022-03-07 00:00:00 | Monday | 2022-03-20 00:00:00 | Sunday
7 | 2022-03-21 00:00:00 | Monday | 2022-04-03 00:00:00 | Sunday
8 | 2022-04-04 00:00:00 | Monday | 2022-04-17 00:00:00 | Sunday
9 | 2022-04-18 00:00:00 | Monday | 2022-05-01 00:00:00 | Sunday
10 | 2022-05-02 00:00:00 | Monday | 2022-05-15 00:00:00 | Sunday
11 | 2022-05-16 00:00:00 | Monday | 2022-05-29 00:00:00 | Sunday
12 | 2022-05-30 00:00:00 | Monday | 2022-06-12 00:00:00 | Sunday
13 | 2022-06-13 00:00:00 | Monday | 2022-06-26 00:00:00 | Sunday
14 | 2022-06-27 00:00:00 | Monday | 2022-07-10 00:00:00 | Sunday
15 | 2022-07-11 00:00:00 | Monday | 2022-07-24 00:00:00 | Sunday
16 | 2022-07-25 00:00:00 | Monday | 2022-08-07 00:00:00 | Sunday
17 | 2022-08-08 00:00:00 | Monday | 2022-08-21 00:00:00 | Sunday
18 | 2022-08-22 00:00:00 | Monday | 2022-09-04 00:00:00 | Sunday
19 | 2022-09-05 00:00:00 | Monday | 2022-09-18 00:00:00 | Sunday
20 | 2022-09-19 00:00:00 | Monday | 2022-10-02 00:00:00 | Sunday
21 | 2022-10-03 00:00:00 | Monday | 2022-10-16 00:00:00 | Sunday
22 | 2022-10-17 00:00:00 | Monday | 2022-10-30 00:00:00 | Sunday
23 | 2022-10-31 00:00:00 | Monday | 2022-11-13 00:00:00 | Sunday
24 | 2022-11-14 00:00:00 | Monday | 2022-11-27 00:00:00 | Sunday
25 | 2022-11-28 00:00:00 | Monday | 2022-12-11 00:00:00 | Sunday
26 | 2022-12-12 00:00:00 | Monday | 2022-12-25 00:00:00 | Sunday
1 | 2022-12-26 00:00:00 | Monday | 2023-01-08 00:00:00 | Sunday
Spreadsheet: 713795d1610941905-help-with-index-match-formula-for-multiple-occurances-of-same-value-sample
Sheet: Sheet1

S | S2 | MN | HT | AT | HTE Pre | HEC | HT Post | [NAME] | AEC | ATE Post
1 | 11 | 1 | SS | BH | 1500 | 29.29642803391735 |  | 1500 | -29.29642803391735
1 | 11 | 2 | MS | ST | 1500 | -23.52726870502823 |  | 1500 | 23.52726870502823
1 | 11 | 3 | AS | MR | 1500 | 42.67866191409707 |  | 1500 | -42.67866191409707
1 | 11 | 4 | PS | HH | 1500 | -34.96518324006727 |  | 1500 | 34.96518324006727
1 | 11 | 5 | BH | MS |  | -23.84781817881768 |  | 1476.472731294972 | 23.84781817881768 |  | <---- for the value in col F, look for previous value if "BH", which occurs in E2, so return the value in K2 (1471). |  |  |  |  |  |  |  |  |  |  | <---- for the value in col I, look for previous value if "MS", which occurs in D3, so return the value in H3 (1476).
1 | 11 | 6 | HH | SS |  | 39.9297942749922 |  | 1529.296428033917 | -39.9297942749922 |  | <---- for the value in col F, look for previous value of "HH", which occurs in E5, so return the value in K5 (1535). |  |  |  |  |  |  |  |  |  |  | <---- for the value in col F, look for previous value of "SS", which occurs in [NAME], so return the value in H2 (1529).
1 | 11 | 7 | MR | PS |  | -24.78992448663707 |  | 1465.034816759933 | 24.78992448663707
1 | 11 | 8 | ST | AS |  | 26.48117259005272 |  | 1542.678661914097 | -26.48117259005272
1 | 11 | 9 | SS | MS |  | 12.13118615720454 |  | 1500.320549473789 | -12.13118615720454
1 | 11 | 10 | AS | HH |  | -27.01002578225024 |  | 1574.89497751506 | 27.01002578225024
1 | 11 | 11 | PS | BH |  | 24.38433818337041 |  | 1446.855753787265 | -24.38433818337041
1 | 11 | 12 | ST | MR |  | -23.40144067551291 |  | 1432.531413599266 | 23.40144067551291
1 | 11 | 13 | HH | ST |  | 25.84525684070635 |  | 1523.527268705028 | -25.84525684070635 |  | <---- for the value in col F, look for previous value of "HH", which occurs in E11, so return the value in K11 (1602). |  |  |  |  |  |  |  |  |  |  | <---- for the value in col I, look for previous value of "ST", which occurs in D12, so return the value in H12 (1514).
1 | 11 | 14 | MR | SS |  | 31.08850314147424 |  | 1489.366633758925 | -31.08850314147424 |  | <---- for the value in col F, look for previous value of "MR", which occurs in E13, so return the value in K13 (1456). |  |  |  |  |  |  |  |  |  |  | <---- for the value in col F, look for previous value of "SS", which occurs in D10, so return the value in H10 (1501).
 |  |  |  |  |  |  |  |  |  |  | THESE LAST 2 HIGHLIGHTED IN YELLOW DO NOT RETURN THE CORRECT VALUE
Spreadsheet: phillip_m_love__30115__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 4/23/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
British Airways plc | V50852.1/2/3/4 | F | WTI | [NAME]
Catequil Overseas Partners, Ltd | V50936.2 | F | NG | [NAME]
Catequil Partners, LP | V50936.1 | F | NG | [NAME]
Chemoil Corporation | V49888.1 | F | 63GC | [NAME]
Global Companies LLC | V49764.1 | F | 61NY | [NAME]
Michigan Gas Storage Company | V48817.7 | F | NG | [NAME]
NAFTA Steel & Pipe, Inc. | V51000.1/2/3/4/5/6/7/8/9/A/B | P | SCSP | [NAME]
National Bank of Canada | V49374.1 | F | UBLB | [NAME]
New Counterparty | V45169.7/8/9/A/B/C | P | SCSP | [NAME]
New Counterparty | V50287.1 V49944.1 | P | NWSP | [NAME]
Thermo Cogeneration Partnership | V49937.1 | F | NG | [NAME]
Unit Petroleum Company | V50793.1/2 | F | NG | [NAME]
Westlake Petrochemical Corporation | V50890.1/2 | F | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
AEC Marketing | V49788.1 | F | NG | Alberta Energy Company (w/ECC)
Astra Resources, Inc. | V49793.1 | F | NG | Astra Power, LLC
Bank of America Corporation | V43355.2 | F | WTI | Bank of America, National Association
First Energy Corp. | V50533.1 | F | NG | FirstEnergy Services Corp.
Texaco Energy Marketing L.P. | V49930.1/2 | F | NG | Texaco Inc.