tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 842619d1694634704-how-to-i-lookup-a-calculated-value-in-one-sheet-that-matches-a-value-on-another-sheet-temp-1-
Sheet: Rates_Schedule

(rounded up by15min) | Duration | Overtime | 2022
60 MINUTES OR LESS | 01:00:00
1 HOUR 15 MINUTES | 01:15:00
1 HOUR 30 MINUTES | 01:30:00
1 HOUR 45 MINUTES | 01:45:00
2 HOURS | 02:00:00
2 HOURS 15 MINUTES | 02:15:00
2 HOURS 30 MINUTES | 02:30:00
2 HOURS 45 MINUTES | 02:45:00
3 HOURS | 03:00:00
3 HOURS 15 MINUTES | 03:15:00
3 HOURS 30 MINUTES | 03:30:00
3 HOURS 45 MINUTES | 03:45:00
4 HOURS | 04:00:00
4 HOURS 15 MINUTES | 04:15:00
4 HOURS 30 MINUTES | 04:30:00
4 HOURS 45 MINUTES | 04:45:00
5 HOURS | 05:00:00
5 HOURS 15 MINUTES | 05:15:00
5 HOURS 30 MINUTES | 05:30:00
5 HOURS 45 MINUTES | 05:45:00
6 HOURS | 06:00:00
6 HOURS 15 MINUTES | 06:15:00
6 HOURS 30 MINUTES | 06:30:00
6 HOURS 45 MINUTES | 06:45:00
7 HOURS | 07:00:00
7 HOURS 15 MINUTES | 07:15:00
7 HOURS 30 MINUTES | 07:30:00
7 HOURS 45 MINUTES | 07:45:00
8 HOURS | 08:00:00
8 HOURS 15 MINUTES | 08:15:00
8 HOURS 30 MINUTES | 08:30:00
8 HOURS 45 MINUTES | 08:45:00
9 HOURS | 09:00:00
9 HOURS 15 MINUTES | 09:15:00
9 HOURS 30 MINUTES | 09:30:00
9 HOURS 45 MINUTES | 09:45:00
10 HOURS | 10:00:00
10 HOURS 15 MINUTES | 10:15:00
10 HOURS 30 MINUTES | 10:30:00
10 HOURS 45 MINUTES | 10:45:00
11 HOURS | 11:00:00
Spreadsheet: dutch_quigley__9451__Enron sheet
Sheet: Sheet1

 |  |  |  | MMBtu/
 |  |  |  | Month
 |  |  | 2001-11-01 00:00:00 | 5117
 |  |  | 2001-12-01 00:00:00 | 7247
 |  |  | 2002-01-01 00:00:00 | 7220
 |  |  | 2002-02-01 00:00:00 | 4995
 |  |  | 2002-03-01 00:00:00 | 3639
 |  |  | 2002-04-01 00:00:00
 |  |  | 2002-05-01 00:00:00
 |  |  | 2002-06-01 00:00:00
 |  |  | 2002-07-01 00:00:00
 |  |  | 2002-08-01 00:00:00
 |  |  | 2002-09-01 00:00:00
 |  |  | 2002-10-01 00:00:00
 |  |  | Total
[NAME] reflect monthly hedge amounts pertaining to [NAME] confirmed Aug 27, 2001
Spreadsheet: benjamin_rogers__911__PJM Eastern Hub Pricing
Sheet: ATC

Year | 1998
Month | Average of RT East Hub | Average of RT West Hub | Delta Real Time
4 | 18.63326842837274 | 18.69898470097356
5 | 23.78603494623655 | 23.94952956989246
6 | 24.88656944444443 | 24.9328472222222
7 | 34.0649193548387 | 34.1245564516129
8 | 29.56625 | 29.57684139784942
9 | 23.41383333333333 | 23.58831944444443
10 | 18.23855033557047 | 18.22958389261744
11 | 17.15902777777774 | 17.30255555555553
12 | 16.73052419354839 | 16.74299731182796
Grand Total | 22.96996060606063 | 23.04360151515153
Year | 1999
Month | Average of RT East Hub | Average of RT West Hub | Delta Real Time
1 | 19.92458333333332 | 19.92129032258063
2 | 16.66712797619048 | 16.51337797619048
3 | 19.66040322580644 | 19.58608870967741
4 | 21.42887343532684 | 21.44232267037552
5 | 22.39383064516129 | 22.48350806451613
6 | 36.98587500000001 | 36.85548611111112
7 | 93.0892473118281 | 89.93735215053769
8 | 33.82440860215053 | 31.7401747311828
9 | 22.30112499999998 | 21.54258333333332
10 | 20.71888590604027 | 19.71477852348993
11 | 17.39684722222222 | 16.34563888888889
12 | 19.31177419354838 | 18.04310483870967
Grand Total | 28.78533904109576 | 27.97835273972596
Year | 2000
Month | Average of RT East Hub | Average of RT West Hub | Delta Real Time | Average of DA East Hub | Average of DA West Hub | Delta Day Ahead
1 | 29.34606182795703 | 23.08975806451612
2 | 25.37778735632185 | 23.7396695402299
3 | 22.3577016129032 | 21.95692204301076
4 | 26.57931944444446 | 23.56261111111112
5 | 38.71946236559138 | 28.678938172043
6 | 32.93762500000001 | 23.14247222222223 |  | 35.86476388888892 | 27.50077777777783
7 | 27.91006720430106 | 23.67481182795698 |  | 27.93600806451612 | 25.91876344086021
8 | 31.3285752688172 | 29.06295698924727 |  | 33.02400537634408 | 32.24869623655913
9 | 25.51794444444444 | 24.73916666666667 |  | 23.72031944444446 | 23.12948611111113
10 | 29.59786290322579 | 29.72883064516127 |  | 30.13060483870969 | 30.08614247311825
11 | 30.34563888888888 | 30.26068055555555 |  | 31.56638888888891 | 31.36688888888888
12 | 45.63284946236557 | 43.90588709677418 |  | 48.1206048387096 | 48.51447580645154
Grand Total | 30.51650728597435 | 27.1656819216757 |  | 32.94435552959518 | 31.30712616822442
Year | 2001
Month | Average of RT East Hub | Average of RT West Hub | Delta Real Time | Average of DA East Hub | Average of DA West Hub | Delta Day Ahead
1 | 37.80741935483872 | 36.60121966129034 |  | 40.85900537634406 | 39.86526881720427
2 | 37.00543154761907 | 28.82747023809524 |  | 37.47241071428569 | 29.89620535714285
3 | 42.66322580645156 | 34.8497177419355 |  | 45.61245967741937 | 37.94323924731176
4 | 36.01773611111115 | 34.5563888888889 |  | 38.33430555555557 | 35.97162499999996
5 | 37.65738636363635 | 32.37066287878788 |  | 36.89770833333331 | 34.15441287878789
Grand Total | 38.3080046948357 | 33.59855264906097 |  | 40.08184272300452 | 35.77255868544575
Spreadsheet: 843117d1695065090-how-to-covert-a-matrix-to-a-list-in-columns-matrix-to-list-conversion-bvj-
Sheet: ben's

ODI | OCI | OTI | UDI | UCI | TIMP | IPI | SSR | PLP | PIP | GOCI | Aerial
Spreadsheet: 546111d1509878969-formula-for-sorting-in-alphabetical-order-sample-workbook-for-sorting-alphabetically
Sheet: Sheet1

 |  |  |  |  | EXPECTED RESULT
 |  | ALL |  |  |  |  | ALL
 |  |  |  |  |  |  | AA
 |  |  |  |  |  |  | ADFDF
 |  |  |  |  |  |  | BB
 |  |  |  |  |  |  | CC
 |  |  |  |  |  |  | CC
 |  |  |  |  |  |  | DD
 |  |  |  |  |  |  | DD
 |  |  |  |  |  |  | DEFG
 |  |  |  |  |  |  | EE
 |  |  |  |  |  |  | EE
 |  |  |  |  |  |  | FGH
 |  |  |  |  |  |  | GG
 |  |  |  |  |  |  | HH
 |  |  |  |  |  |  | KK
 |  |  |  |  |  |  | MOIM
Spreadsheet: darrell_schoolcraft__7302__imball0201
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
1 | 219 | 150
2 | 22 | 150
3 | 305 | 150
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
2001-12-31 00:00:00 |  |  | 180032
2002-01-03 00:00:00
CBS Volume
 |  |  | 78993
Spreadsheet: chris_germany__2011__Lonestarnom0602
Sheet: June 14th, 2002

[NAME]
[NAME]
Dallas, TX  75201-5696
Attention: | Wilma Easter - Scheduling Department |  |  |  | From: | Enron Capital & Trade
Fax: | 214/875-3810 |  |  |  |  | [NAME]
Phone: | 214/875-3296 |  |  |  |  | 713/853-7750 (Phone)
Backup:  [NAME] 214/875-2674 |  |  |  |  |  | 713/345-7374 (Fax)
Contract #LS-MC-1671 |  |  | Start Date: |  | 2002-06-14 00:00:00 |  | End Date: | 2002-06-30 00:00:00
RECEIPT POINT INFORMATION:
 | STATION # | [NAME] | UPSTREAM K# | Previous Day Nom | NOM QUANTITY | FUEL % | NET QUANTITY | Changes
Cinergy | 17-1201-11 | [NAME] | 01T957 | 2000 | 2000 | 0.01 |  | **
Cinergy | 17-1954-50 | Conoco Sterling | Conoco | 8000 | 8000 | 0.01
 | 17-8060-01 | [NAME] | 3400 | 0 | 0 | 0.01
Cinergy | 17-8060-00 | [NAME] | 3400 | 0 | 0 | 0.01
Cinergy | 17-1240-50 | NNG Sprayberry | 108301 | 10000 | 10000 | 0.01
Cinergy |  |  |  | 0 | 0
 | 17-1240-50 | NNG Sprayberry | 108301 | 0 | 0 | 0.01
[NAME] | 17-2270-00 | HPL Interconnect | 9606506 | 0 | 0 | 0.01
[NAME] | 17-1925-00 | Duke/Carthage Hub | 481 | 0 | 0 | 0.01
[NAME] | 17-3000-00 | [NAME] | 2880600203 | 20000 | 20000 | 0.01
[NAME] | 17-1201-11 | [NAME] | REM | 0 | 0 | 0.01
[NAME] | 18-0006-00 | TW Pecos | 24198 | 15000 | 10000 | 0.01
DELIVERY POINT INFORMATION:
STATION # | [NAME] | UPSTREAM K# |  | Previous Day Nom | NOM QUANTITY | FUEL % | NET QUANTITY
25-0002-00 | Kleburne Plant | 1671 |  | 44550
FYI:  Buy/Sell Information
Cinergy | 17-1201-11 | [NAME] | #01T957 | 0 | 0 | 0 |  | sold to TXU K501 | K2704
Cinergy | 17-3000-00 | [NAME] | 2880600203 | 0 | 0 | 0 |  | ** sold to TXU K501
 |  |  |  |  |  | total sold TXU
Cuts:
Spreadsheet: 789484d1659113952-count-the-number-of-results-in-a-table-2022-07-29-oeldere-slock92-last-man-standing-1-
Sheet: week 1

 | Week 1
 | NAME | TEAM
 |  |  |  |  | Teams | amount Picked
 |  |  |  |  | [NAME] | 1
 |  |  |  |  | [NAME] | 2
 |  |  |  |  | Northampton Town | 4
 |  |  |  |  | Rijlabels | Aantal van TEAM
 |  |  |  |  | [NAME] | 1
 |  |  |  |  | Derby County | 1
 |  |  |  |  | Ipswich Town | 2
 |  |  |  |  | [NAME] | 1
 |  |  |  |  | Millwall | 1
 |  |  |  |  | [NAME] | 2
 |  |  |  |  | Northampton Town | 4
 |  |  |  |  | Norwich City | 1
 |  |  |  |  | Salford City | 1
 |  |  |  |  | Sheffield Wednesday | 2
 |  |  |  |  | Stockport County | 5
 |  |  |  |  | Sunderland | 1
 |  |  |  |  | Tranmere Rovers | 1
 |  |  |  |  | Watford | 1
 |  |  |  |  | Eindtotaal | 24
Spreadsheet: 777447d1650383152-attendance-rolling-12-month-calculator-attendance-example-1-fixed-aligw
Sheet: Sheet1

 | Employee Name | Total Points  this year | Total Points | 2022-04-11 00:00:00
 | Employee A |  |  |  |  |  | 1 | 1
 | Employee B |  |  |  | 0.5 | 0.5 |  |  | 3
Spreadsheet: 137483d1327149409-excel-2007-counting-for-specific-text-in-a-cell-book1
Sheet: Sheet1

14 |  |  |  | 6 | 3 | 13
28 |  |  |  | 12 | 4
97 |  |  |  | 15 | 4
21 |  |  |  | 18 | 2
61
30
70
17
44
58
13
41
80
5
66
14
16
74
48
8
78
94
7
27
43
69
99
5
99
54
6
80
89
26
40
14
66
84
28
10
70
58
76
81
53
38
11
39
78
18
5
39
74
30
64
93
82
14
20
29
67
57
33
2
10
80
25
76
78
63
74
33
99
26
79
44
57
3
57
75
75
1
12
83
88
79
85
80
73
51
40
100
62
36
12
34
70
64
86
81
49
43
44
80
48
8
94
6
20
42
30
67
58
87
11
23
50
4
65
19
87
77
10
7
99
3
97
65
49
47
7
6
91
98
82
43
73
47
68
73
30
20
51
12
91
24
76
83
56
61
43
2
90
15
76
71
75
75
57
52
47
48
14
42
28
59
61
49
34
69
78
36
66
13
31
96
16
75
38
87
97
51
19
11
25
51
84
57
27
99
90
16
44
86
97
97
84
26
61
89
81
97
11
33
52
30
83
39
82
1
77
85
48
94
20
37
33
12
35
78
5
58
60
11
76
15
13
37
100
95
62
95
69
24
8
99
63
95
73
45
37
7
36
49
92
91
79
25
27
84
58
90
18
55
88
41
16
21
97
86
4
45
48
81
47
19
52
15
31
87
57
88
13
51
89
42
75
75
41
15
49
82
40
13
95
87
63
64
30
19
19
24
78
92
75
97
95
49
100
100
5
36
8
2
36
54
21
60
25
92
94
91
13
90
74
52
64
32
4
Spreadsheet: 713782d1610931269-evaluate-date-range-for-last-date-in-year-semi-annual-quarter-and-year-daterange
Sheet: Sheet5

Dates | YrEnd | Last6/30/YY | LastQtr | Last Month
2006-01-03 00:00:00
2006-01-13 00:00:00
2006-01-30 00:00:00
2006-01-31 00:00:00 |  |  |  | MthEnd
2006-02-01 00:00:00
2006-02-02 00:00:00
2006-02-24 00:00:00
2006-02-27 00:00:00
2006-02-28 00:00:00 |  |  |  | MthEnd
2006-03-01 00:00:00
2006-03-10 00:00:00
2006-03-20 00:00:00
2006-03-31 00:00:00 |  |  | [NAME] | MthEnd
2006-04-03 00:00:00
2006-04-18 00:00:00
2006-04-19 00:00:00
2006-04-20 00:00:00 |  |  |  | MthEnd
2006-05-01 00:00:00
2006-05-16 00:00:00
2006-05-30 00:00:00
2006-05-31 00:00:00 |  |  |  | MthEnd
2006-06-01 00:00:00
2006-06-20 00:00:00
2006-06-29 00:00:00 |  | SemiAnnual | [NAME] | MthEnd
2006-07-03 00:00:00
2006-07-05 00:00:00
2006-07-17 00:00:00 |  |  |  | MthEnd
2006-08-01 00:00:00
2006-08-24 00:00:00 |  |  |  | MthEnd
2006-09-01 00:00:00
2006-09-05 00:00:00
2006-09-20 00:00:00
2006-09-29 00:00:00 |  |  | [NAME] | MthEnd
2006-10-02 00:00:00
2006-10-19 00:00:00
2006-10-27 00:00:00 |  |  |  | MthEnd
2006-11-01 00:00:00
2006-11-30 00:00:00 |  |  |  | MthEnd
2006-12-01 00:00:00
2006-12-26 00:00:00
2006-12-27 00:00:00
2006-12-28 00:00:00 | YrEnd |  | [NAME] | MthEnd
Spreadsheet: 1932d25e-0ed1-41db-a3ec-dcaf335bdac8
Sheet: Sheet1

Date | Channel | Start (MYT) | End (MYT) | Match | Notes
2012-02-24 00:00:00 | ASSP2 | 05:00:00 | 13:00:00 | Last 16 | Live
2012-02-25 00:00:00 | ASSP2 | 04:00:00 | 08:00:00 | Quarter Final | Live
2012-02-25 00:00:00 | ASSP2 | 09:00:00 | 13:00:00 | Quarter Final | Live
2012-02-26 00:00:00 | ASSP2 | 01:00:00 | 03:30:00 | Semi Final | Live
2012-02-26 00:00:00 | ASSP2 | 16:00:00 | 18:30:00 | Semi Final | Delayed
2012-02-27 00:00:00 | ASSP2 | 23:00:00 | 02:00:00 | Final | Delayed
Spreadsheet: 822194d1679160523-formula-for-adding-dividing-value-of-cells-based-on-criteria-mock-up
Sheet: DATA

SN | SELLING PRICE | TEAM 1 | SELLER 1 | TEAM 2 | SELLER 2 |  |  | SALES PER TEAM | TOTAL |  | SALES PER SELLER | TOTAL
1 | 500000 | [NAME] | LATIFA | [NAME] | SALEM |  |  | [NAME] |  |  | LATIFA
2 | 250000 | JABAR TEAM | ALAA | [NAME] | MOSTAFA |  |  | JABAR TEAM |  |  | ALAA
3 | 150000 | JABAR TEAM | ALAA |  |  |  |  | [NAME] |  |  | SALEM
4 | 100000 | [NAME] | SALEM |  |  |  |  |  |  |  | AHMED
 |  |  |  |  |  |  |  |  |  |  | MOSTAFA
 |  |  |  |  |  |  |  | MANUAL RESULTS
 |  |  |  |  |  |  |  | SALES PER TEAM | TOTAL |  | SALES PER SELLER | TOTAL
 |  |  |  |  |  |  |  | [NAME] | 375000 |  | LATIFA | 250000
 |  |  |  |  |  |  |  | JABAR TEAM | 275000 |  | ALAA | 275000
 |  |  |  |  |  |  |  | [NAME] | 350000 |  | SALEM | 350000
 |  |  |  |  |  |  |  |  |  |  | AHMED | 0
 |  |  |  |  |  |  |  |  |  |  | MOSTAFA | 125000
Spreadsheet: 694850d1599839147-not-the-same-but-the-next-one-livro1
Sheet: Folha1

 |  |  | WATER
 |  |  | DATE | REF | DESC | AMMOUNT |  | DATE | REF | TYPE | DESC | DEBIT | CREDIT
 |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | --- | BALANCE | --- | --- | 1000
 |  |  |  |  |  |  |  | 2020-02-01 00:00:00 | 001 | WATER | PAYMENT WATER February | 100.54
 |  |  |  |  |  |  |  | 2020-03-02 00:00:00 | 002 | WATER | PAYMENT WATER March | 54.74
 |  |  |  |  |  |  |  | 2020-04-02 00:00:00 | 003 | ELECTRICITY | PAYMENT ELECTRICITY APBRIL | 34.51
 |  |  |  |  |  |  |  | 2020-04-04 00:00:00 | 004 | GARDEN | PAYMENT GARDEN APBRIL | 450
 |  |  |  |  |  |  |  | 2020-06-04 00:00:00 | 005 | ELECTRICITY | PAYMENT ELECTRICITY JUNE | 211.45
 |  |  | ELECTRICITY
 |  |  | DATE | REF | DESC | AMMOUNT
 |  |  | GARDEN
 |  |  | DATE | REF | DESC | AMMOUNT
Spreadsheet: mary_fischer__25606__31Z
Sheet: E2.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Z
COMPANY NAME    LINC
ANALYSIS OF OTHER CURRENT ASSETS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-2
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
[NAME] |  | 87969 |  | -97290 |  |  |  | 1038
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total Current Assets | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 195
Asset/Expense Accts:  DR/(CR)
Spreadsheet: 04c5457c-c058-4ef8-8065-707d229ef389
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | DEPARTMENT OF GENERAL SERVICES |  |  |  |  |  |  | Last Update = 7/3/2014
 | WAREHOUSE AND DISTRIBUTION DIVISION
 |  |  |  |  |  |  | Note: Effective 8/23/2013 Bobali Warehouse Statistics (DGS5) Were combined with Elmerton Warehouse Statistics ([NAME]) Due to consolidation of Warehouses
 | WAREHOUSE ACTIVITY
 | Make a Selection To View Individual Warehouse Statistics
 | Whse: | (All)
 | Month | Receipts | Orders Released | Orders Shipped | Lines Released | Lines Shipped | [NAME]
 | 05/2013 | 98 | 4459 | 3614 | 11008 | 8828 | 2180
 | 06/2013 | 74 | 3971 | 3188 | 9754 | 7676 | 2078
 | 07/2013 | 90 | 4101 | 3328 | 10341 | 8251 | 2090
 | 08/2013 | 95 | 3971 | 3204 | 10145 | 8016 | 2129
 | 09/2013 | 77 | 3683 | 2884 | 9581 | 7214 | 2367
 | 10/2013 | 89 | 3893 | 3049 | 10323 | 7821 | 2502
 | 11/2013 | 76 | 3618 | 2805 | 9589 | 7408 | 2181
 | 12/2013 | 72 | 3267 | 2622 | 8565 | 6797 | 1768
 | 01/2014 | 122 | 3945 | 3024 | 9755 | 7294 | 2461
 | 02/2014 | 32 | 3486 | 2756 | 8515 | 6453 | 2062
 | 03/2014 | 16 | 4224 | 3407 | 10864 | 8531 | 2333
 | 04/2014 | 4 | 4450 | 3613 | 10866 | 8742 | 2124
 | 05/2014 | 18 | 4405 | 3405 | 9953 | 7758 | 2195
 | 06/2014 | 19 | 3976 | 3255 | 10333 | 8189 | 2144
 | Grand Total | 882 | 55449 | 44154 | 139592 | 108978 | 30614
Spreadsheet: 830810d1685124939-comparing-2-lists-columns-of-names-s666-pq-comparing-2-lists-columns-of-names
Sheet: Sheet1

List1 | List2 |  | Difference
[NAME] | [NAME] |  | [NAME]
[NAME] | [NAME] |  | [NAME]
[NAME] | [NAME] |  | [NAME]
[NAME] | Ellie Asa
Ellie Asa | [NAME]
[NAME] | [NAME]
[NAME] | Paulinho Panoz
Paulinho Panoz | [NAME]
[NAME]
Spreadsheet: 525693d1498840967-formuals-to-sum-distinct-values-with-condition-any-and-all-sample-c
Sheet: Table

Location | Name | Category
West | [NAME] | A
West | [NAME] | B
West | [NAME] | B
West | Kathy | B
West | Kathy | B
West | [NAME] | A
East | Dale | A
East | Dale | A
East | [NAME] | B
East | [NAME] | B
East | [NAME] | A
East | Billy | B
South | [NAME] | A
South | [NAME] | A
South | [NAME] | A
South | [NAME] | B
South | [NAME] | B
South | [NAME] | A
North | [NAME] | B
North | [NAME] | B
North | [NAME] | B
North | [NAME] | B
North | [NAME] | B
North | [NAME] | A
Spreadsheet: michelle_lokay__26563__imbalsumm0012
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 33295 | 17825 |  | 14579
2 | 35755 | -187 |  | 35000
3 | 4589 | -187
4 | 42970 | -187 |  | 43232
5 | 419 | -187 |  | 61
6 |  | 14623 |  | -5000
7 | 36032 | 18481 |  | 16742
8 | 29195 | 20939 |  | 8000
9 | 435 | -187
10 |  | -187
11 |  | -187 | 5
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2000-11-30 00:00:00 |  |  | 24376.68
 |  |  |  | 2000-12-11 00:00:00
Spreadsheet: 862349d1710105664-i-am-trying-to-calculate-the-projected-bed-occupancy-rates-in-a-residential-program-cenus-learn-abaorca-
Sheet: Sheet1

ID | Admission Date | Discharge Date | Projected Census |  | Current Census: |  | Days per admission (av) |  | Average Stay
A | 2023-10-27 00:00:00 | 2024-03-07 00:00:00
B | 2023-11-02 00:00:00 | 2024-03-14 00:00:00
D | 2023-11-29 00:00:00
D | 2023-12-06 00:00:00 | 2024-03-01 00:00:00
F | 2023-12-07 00:00:00
H | 2024-01-15 00:00:00 | 2024-02-01 00:00:00
I | 2024-02-01 00:00:00
J | 2024-03-05 00:00:00 |  |  |  |  |  |  |  | We need to be able to look at the spreadsheet and have it calculate the projected census based on discharges and admissions.
K | 2024-03-15 00:00:00 |  |  |  |  |  |  |  | We have to keep tally on this due to bed availablity as well as staffing ratio requirements.
 | We maintain all | Discharges vary. So the
 | admissions including | dates can vary a lot.
 | upcoming ones.
Spreadsheet: 36339d1234223123-multiple-vlookup-small-if-array-example-2
Sheet: Sheet1

product ID | material ID | Prod time (sec) | portion size (pcs) | portion volume (m^3) | product name | material name | quantity
178 | 35 | 300 | 100 | 0.004 | Prod A | 1 | 19
178 | 34 | 300 | 100 | 0.004 | Prod b | 2 | 24
179 | 35 | 300 | 100 | 0.0035 | Prod B | 3 | 29
179 | 34 | 300 | 100 | 0.0035 | Prod B | 4 | 34
180 | 37 | 300 | 100 | 0.003 | Prod C | 3 | 1
180 | 35 | 300 | 100 | 0.003 | Prod a | 1 | 21
180 | 34 | 300 | 100 | 0.003 | Prod d | 2 | 52
181 | 36 | 300 | 100 | 0.0025 | Prod D | 5 | 1
181 | 37 | 300 | 100 | 0.0025 | Prod a | 3 | 2
181 | 34 | 300 | 100 | 0.0025 | Prod b | 2 | 106
182 | 36 | 300 | 100 | 0.00325 | Prod E | 5 | 1
182 | 34 | 300 | 100 | 0.00325 | Prod a | 2 | 52
182 | 35 | 300 | 100 | 0.00325 | Prod b | 1 | 58
 | ID | QTY
 | 182 | 3
Materials | 5 | Prod E
 | 2 | Prod a
 | 1 | Prod b
Spreadsheet: 140398d1328731102-dynamic-validation-with-list-that-have-been-auto-filtered-flexible-data-validation
Sheet: Sheet2

class | occurrence
lecturer | lecturer1
lecturer | lecturer2 |  | TABLE A
lecturer | [NAME]
student | [NAME]
student | student2
lecturer | [NAME]
lecturer | lecturer10
lecturer | [NAME]
 |  |  | lecturer | student
 |  |  | lecturer1 | student2 |  | TABLE B
 |  |  | lecturer2 | student2
 |  |  | [NAME] | [NAME]
Spreadsheet: 776437d1649740117-check-from-the-source-table-to-list-subjects-below-the-required-marks-by-name-choletseng-hlookup-with-vlookup
Sheet: Sheet1

suject | math | language | Chemical | English | physics
Pass requirement >= | 90 | 90 | 60 | 80 | 70
Name1 | 60 | 100 | 70 | 70 | 55
[NAME] | 100 | 60 | 50 | 99 | 80
Name3 | 30 | 100 | 60 | 100 | 40
Name4 | 80 | 50 | 90 | 120 | 80
Name5 | 100 | 80 | 100 | 80 | 90
Name6 | 88 | 90 | 99 | 70 | 99
 |  |  |  |  |  | Samples are for reference only and have no meaning (E11:O22 does not exist and will be deleted later)
Summary of Failed Items
Name6 | math |  |  |  |  | [NAME] | math |  |  | Name3 | math | 30 |  | Name4 | math | 80
 | language |  |  |  |  |  | language | 60 |  |  | language |  |  |  | language | 50
 | Chemical |  |  |  |  |  | Chemical | 50 |  |  | Chemical |  |  |  | Chemical
 | English |  |  |  |  |  | English |  |  |  | English |  |  |  | English
 | physics |  |  |  |  |  | physics |  |  |  | physics | 40 |  |  | physics
 |  |  |  |  |  | Name5 | math |  |  | Name6 | math | 88
 |  |  |  |  |  |  | language | 80 |  |  | language
 |  |  |  |  |  |  | Chemical |  |  |  | Chemical
 |  |  |  |  |  |  | English |  |  |  | English | 70
 |  |  |  |  |  |  | physics |  |  |  | physics
Spreadsheet: dfecdd08-4937-4d6a-a316-53f432a6314e
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38692347 | 2013-11-24 21:21:57 | AXIS | 0 | 1 | 6 | 443634 | caty | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
38692669 | 2013-11-24 21:38:36 | ALLIES | 1 | 6 | 2 | 443634 | caty | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
38749079 | 2013-11-28 21:55:47 | AXIS | 0 | 3 | 6 | 54879 | jml0702 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38749546 | 2013-11-28 22:33:38 | ALLIES | 1 | 6 | 1 | 54879 | jml0702 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38774009 | 2013-11-30 18:25:42 | ALLIES | 0 | 4 | 7 | 901544 | manu76 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
38774369 | 2013-11-30 19:00:23 | AXIS | 0 | 6 | 7 | 901544 | manu76 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
38784122 | 2013-12-01 11:13:15 | AXIS | 1 | 10 | 7 | 1360620 | Factotem | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
38788946 | 2013-12-01 18:30:01 | ALLIES | 1 | 10 | 5 | 333660 | Per-power | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
38789462 | 2013-12-01 19:14:18 | AXIS | 0 | 8 | 10 | 333660 | Per-power | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
38873566 | 2013-12-07 18:31:45 | AXIS | 0 | 4 | 6 | 939846 | Tristan710 | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
38873871 | 2013-12-07 18:50:34 | ALLIES | 1 | 6 | 4 | 939846 | Tristan710 | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune