tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: dutch_quigley__9392__prior energy 5-11-01
Sheet: LDC-E

 |  | Vol/d | Nymex |  |  | # of Days | Vol/month
 | 2002-05-01 00:00:00 | 317 | 4.15 |  |  | 31
 |  | 298 | 4.192 |  |  | 30
 |  | 312 | 4.242 |  |  | 31
 |  | 342 | 4.25 |  |  | 31
 |  | 285 | 4.255 |  |  | 30
 |  | 369 | 4.275 |  |  | 31
 |  | 569 | 4.415 |  |  | 30
 |  | 1165 | 4.545 |  |  | 31
 |  | 1102 | 4.595 |  |  | 31
 |  | 696 | 4.45 |  |  | 28
 |  | 575 | 4.262 |  |  | 31
 |  | 377 | 3.962 |  |  | 30
 |  | 317 | 3.927 |  |  | 31
 |  | 298 | 3.967 |  |  | 30
 |  | 312 | 4.017 |  |  | 31
 |  | 342 | 4.067 |  |  | 31
 |  | 285 | 4.087 |  |  | 30
 |  | 369 | 4.102 |  |  | 31
 |  | 569 | 4.214 |  |  | 30
 |  | 1165 | 4.349 |  |  | 31
 |  | 1102 | 4.407 |  |  | 31
 |  | 696 | 4.287 |  |  | 28
 |  | 575 | 4.148 |  |  | 31
 |  | 377 | 3.962 |  |  | 30
 | Weighted Avg
 | Avg
Spreadsheet: 752641d1634874715-returning-most-appropriate-value-from-a-list-book4-1-
Sheet: Sheet1

Num | Description | Main | Secondary | My attempt |  | Correct Answer C
1 | Connector,[NAME],Steel,7241-1 Series B,1700 PSI |  |  |  |  | Connector
2 | [NAME] Assy,2",2' length,HD,EPDM,200PSI,2" RF ANSI Flg,CS,150# |  |  |  |  | [NAME]
3 | [NAME],[NAME],Senior Flexonics,0.5"x12"Long,Series 161 SS Single Braided,NPTM connector |  |  |  |  | [NAME] Connector
4 | [NAME],Hydraulic,Parker,Med Press,1-1/4"ID,Series 387ST,210bar |  |  |  |  | [NAME]
5 | [NAME],Hydraulic,Parker,Med Press,1-1/4"ID,Series 387TC,210bar |  |  |  |  | [NAME]
6 | [NAME],Hydraulic,Parker,Med Press,1-1/4"ID,Series 487ST,280bar |  |  |  |  | [NAME]
7 | [NAME],Hydraulic,Parker,Med Press,1-1/4"ID,Series 787ST,350bar |  |  |  |  | [NAME]
8 | [NAME],Hydraulic,Parker,Med Press,1-1/4"ID,Series 787TC,350bar |  |  |  |  | [NAME]
9 | Nozzle,Washdown Flush Deck,0.5",SS ASTM A351 CF8M,SW,NAVSEA [PHONE],SS Tr |  |  |  |  | Nozzle
10 | Nozzle,Washdown Open,0.5",Brz ASTM B148,Thrd,NAVSEA [PHONE] |  |  |  |  | Reel
11 | Reel,[NAME],NPT |  |  |  |  | Reel
12 | Reel,[NAME],c/w Suction Nozzle |  |  |  |  | Reel
13 | Reel,Hose Reel Assembly,Automatic,1" Hose ID w/ Outlet Valve Mounting Base |  |  |  |  | Reel
14 | Reel,Hose Reel Assembly,SS,Hand-Crank,3000PSI,c/w 100ft [NAME],Refueling Nozzle |  |  |  |  | Reel
15 | [NAME],Closed Type,Orifice 1/4",95deg Spray Angle,1/2" NPT,Tyco EA-1,Natural Finish Bronze |  |  |  |  | Sprinkler
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Nozzle
 |  |  |  | Reel
 |  |  |  | Sprinkler°Head
Spreadsheet: 808584d1670523819-counting-rows-between-specific-events-book1
Sheet: Sheet1

WHEEL 1 | WHEEL 2 | WHEEL 3 |  |  |  |  | DELAY | TIMES
B | G | R |  |  |  |  | 0
G | B | R |  |  |  |  | 1
B | B | B |  |  |  |  | 2
B | R | R |  |  |  |  | 3
R | B | G |  |  |  |  | 4
B | G | B |  |  |  |  | 5
B | S | R |  |  |  |  | 6
S | B | B |  |  |  |  | 7
S | B | R |  |  |  |  | 8
R | G | R |  |  |  |  | 9
R | G | G |  |  |  |  | 10
R | G | R |  |  |  |  | 11
G | R | R |  |  |  |  | 12
B | S | S |  |  |  |  | 13
B | G | R |  |  |  |  | 14
G | B | B |  |  |  |  | 15
B | R | G |  |  |  |  | 16
S | R | B |  |  |  |  | 17
R | R | B |  |  |  |  | 18
B | B | B |  |  |  |  | 19
R | R | B |  |  |  |  | 20
G | G | G |  |  |  |  | 21
B | G | G |  |  |  |  | 22
R | R | R |  |  |  |  | 23
B | G | R |  |  |  |  | 24
G | R | R |  |  |  |  | 25
S | R | R |  |  |  |  | 26
B | B | R |  |  |  |  | 27
R | G | G |  |  |  |  | 28
R | G | R |  |  |  |  | 29
G | R | G |  |  |  |  | 30
B | R | R
G | B | R
Spreadsheet: 828645d1683654780-daily-kpi-tracker-call-center-kpi-tracker
Sheet: Sheet1

# of cases | case ID
1 | 909
2 | 910
3 | 911
4 | 912
5 | 913
6 | 914
7 | 915
8 | 916
9 | 917
10 | 918
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
Spreadsheet: 96637d1295984933-unable-to-display-correct-text-with-time-reference-cell-changing-according-to-day-time
Sheet: Sheet1

Product | Opening Time | Closing Time | ON/OFF |  |  | Time Now
A | 23:20:00 | 21:40:00
B | 07:10:00 | 16:20:00
C | 08:10:00 | 16:00:00
D | 09:00:00 | 17:00:00
Spreadsheet: 140023d1328595903-multiple-criteria-filter-example
Sheet: Sheet3

Row Labels | Sum of Due Category
10133663 | 0
10144679 | 2
10411705 | 11
10427451 | 3
10449522 | 4
10450313 | 1
10978925 | 0
11168893 | 1
32088940 | 7
Grand Total | 29
Spreadsheet: 765494d1643360177-i-want-to-count-the-occurrences-of-unique-values-within-a-group-test_sheet_for_froum
Sheet: Sheet1

 | Group | ID |  |  |  |  |  | Unique values | Count of Unique Values within Group
 | Applejuice | 10 |  |  |  |  |  | 10
 | Applejuice | 11 |  |  |  |  |  | 11
 | Applejuice | 12 |  |  |  |  |  | 12
 | Applejuice | 12 |  |  |  |  |  | 13
 | Applejuice | 12
 | Applejuice | 11
 | Applejuice | 10
 | Applejuice | 10
 | Oranges | 13 |  |  |  |  |  | 10
 | Oranges | 10 |  |  |  |  |  | 11
 | Oranges | 10 |  |  |  |  |  | 12
 | Oranges | 12 |  |  |  |  |  | 13
 | Oranges | 12
 | Oranges | 13
 | Bananamilk | 11 |  |  |  |  |  | 10
 | Bananamilk | 11 |  |  |  |  |  | 11
 | Bananamilk | 11 |  |  |  |  |  | 12
 | Bananamilk | 11 |  |  |  |  |  | 13
 | Bananamilk | 11
 | Bananamilk | 12
 | Bananamilk | 10
 | Bananamilk | 13
Spreadsheet: phillip_platter__31373__ca0912EES
Sheet: NP15

NP15
CounterParty | Total | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500 | 1600 | 1700 | 1800 | 1900 | 2000 | 2100 | 2200 | 2300 | 2400
PX - Purchase
PX - Sale
CA Imbalance - Purchase (Decrease Load)
CA Imbalance - Sale (Increase Load)
Generation
Generation
Generation
Generation
Generation
Generation
Generation
Generation
Generation
Generation
EES
EES Sell less
[NAME]
Sale to EES at DJ Index
Sale to ees at Fixed + 10
Load6
Load7
Load8
Load9
Load10
MEGA
PNM
SC Customer3
SC Customer4
SC Customer5
Daily Trades
Line Losses
Turlock Offset 3/11 - 3/31 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
cdwr offset |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ees |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
wesco |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other NP15 Trade |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other NP15 Trade |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total NP15
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
Spreadsheet: 72043d1272731989-calculating-percentiles-from-bin-frequency-data-727533-percentiles-from-binned-data
Sheet: Sheet2

Percentile | Value
0.3 | 0.3
0.7 | 0.8
[NAME]
Increment | G
0 | 1 | 0
0.1 | 1 | 1
0.2 | 1 | 2
0.3 | 1 | 3
0.4 | 1 | 4
0.5 | 1 | 5
0.6 | 1 | 6
0.7 | 1 | 7
0.8 | 1 | 8
0.9 | 1 | 9
1 | 1 | 10
Spreadsheet: 1639c5ce-4b1a-414e-b1a8-a8dddf236d6e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5437 | 7986 | [NAME] | Perkins | USA | 0 | 00:30:37 | 00:02:50 | 00:07:37 | 00:21:11 | 02:13:30 | 1 | 03:15:44
5437 | 7987 | Grant | [NAME] | CAN | 0 | 00:24:17 | 00:03:31 | 00:07:42 | 00:21:15 | 02:23:04 | 2 | 03:19:47
5437 | 7984 | [NAME] | [NAME] | USA | 0 | 00:30:48 | 00:03:08 | 00:08:35 | 00:23:11 | 02:30:03 | 3 | 03:35:42
5437 | 7971 | Ruben | Grande | MEX | 0 | [NAME] | 00:02:59 | 00:08:18 | 00:23:40 | 02:48:05 | 4 | 03:53:50
Spreadsheet: 729115d1618918428-pricing-based-on-cell-reference-and-drop-down-list-tiered-pricing
Sheet: Product Cost Breakdown

Gate Fees
Intl Adult | 424 | Intl Child | 212
[NAME] | 210 | SADC Child | 105
SA Adult | 105 | SA Child | 52
Type of Game Drive | Number of Adults | Type Of Adult | [NAME] | Number of Children | Type of Child | Child Gate Fees | Total Passengers | Vehicle Cost | Insurance Cost | Fuel Cost | Wholesale Cost | Guide Fee | Booking Fee | Gross Cost | [NAME] | Profit | Selling Price Point |  |  |  | Pax Number | Guide Fee | [NAME]
Shared Morning Game Drive |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.15 | 0.4
Shared Afternoon Game Drive |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 0.3
Shared Full Day Game Drive |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 36005d1233754176-how-to-calculate-monthly-and-quarterly-reports-monthly-reporting-example
Sheet: monthly-report

Project Type | Started | Finished | Employee
International | 2008-11-11 00:00:00 | 2008-11-25 00:00:00 | Mr White
Local | 2008-11-12 00:00:00 | 2008-11-26 00:00:00 | Mr Orange
International | 2008-11-18 00:00:00 | 2008-11-25 00:00:00 | Mr Blonde
Local | 2008-11-24 00:00:00 | 2008-12-01 00:00:00 | Mr Pink
Local | 2008-11-25 00:00:00 | 2008-12-02 00:00:00 | Mr Blue
Local | 2008-11-26 00:00:00 | 2009-01-15 00:00:00 | Mr [NAME]
International | 2008-11-28 00:00:00 | 2008-12-19 00:00:00 | Mr Orange
International | 2008-12-01 00:00:00 | 2009-01-16 00:00:00 | Mr Pink
International | 2008-12-05 00:00:00 | 2008-12-19 00:00:00 | Mr Blonde
Local | 2008-12-17 00:00:00 | 2009-01-19 00:00:00 | Mr White
International | 2008-12-18 00:00:00 | 2009-01-15 00:00:00 | Mr [NAME]
International | 2009-01-07 00:00:00 | 2009-01-21 00:00:00 | Mr Orange
Local | 2009-01-12 00:00:00 | 2009-02-09 00:00:00 | Mr Orange
Local | 2009-01-14 00:00:00 | 2009-01-28 00:00:00 | Mr [NAME]
International | 2009-01-19 00:00:00 | 2009-02-02 00:00:00 | Mr White
International | 2009-01-23 00:00:00 | 2009-02-06 00:00:00 | Mr Pink
Local | 2009-01-26 00:00:00 | 2009-01-29 00:00:00 | Mr Blonde
International | 2009-01-27 00:00:00 | 2009-02-10 00:00:00 | Mr [NAME]
International | 2009-01-29 00:00:00 | 2009-02-06 00:00:00 | Mr Blue
International | 2009-02-02 00:00:00 | 2009-03-13 00:00:00 | Mr Blonde
Local | 2009-02-03 00:00:00 | 2009-02-10 00:00:00 | Mr Blue
 |  |  |  |  | Report: January
 |  |  |  |  | Employee | Nbr of Projects | Nbr of Days worked | Nbr of International Projects | Nbr of Local Projects
 |  |  |  |  | Mr White
 |  |  |  |  | Mr Orange
 |  |  |  |  | Mr Blonde
 |  |  |  |  | Mr Pink
 |  |  |  |  | Mr Blue
 |  |  |  |  | Mr [NAME]
 |  |  |  |  | Report: Q1 (January-March)
 |  |  |  |  | Employee | Nbr of Projects | Nbr of Days worked | Nbr of International Projects | Nbr of Local Projects
 |  |  |  |  | Mr White
 |  |  |  |  | Mr Orange
 |  |  |  |  | Mr Blonde
 |  |  |  |  | Mr Pink
 |  |  |  |  | Mr Blue
 |  |  |  |  | Mr [NAME]
Spreadsheet: b8e030ea-75b0-4cd2-b4aa-6082df2953f6
Sheet: Interest Calculation

 | Calculating the Interest Rates
 | Budget | Nat. Debt | National
 | Year | Interest | Debt | Interest
 | 1993 | $ Billions | $ Billions | Rate
 | 1994 | 296.27776424626 | 4692.74991001332
 |  | 332.41355503062 | 4973.98290070939
 |  | 343.95507669515 | 5224.81093913573
 |  | 355.79583421466 | 5413.14601139734
 |  | 363.82372292026 | 5526.19300889762
 |  | 353.51147172287 | 5656.27090161543
 |  | 361.99773430236 | 5674.17820988686
 |  | 359.50763524241 | 5807.46341220006
 | 2010 | 413.95482536217 | 13561.6230308917
 | Calculating Interest on [NAME]-Bush Debt
 |  |  |  | [NAME]-[NAME]
 | Budget Year End |  | Interst | Debt $Billions | Interest
 | Sept. 30 1993 |  | $ Billions |  | Rate
 | Sept. 30 1994
 | Sept. 30 1995
 | Sept. 30 1996
 | Sept. 30 1997
 | Sept. 30 1998
 | Sept. 30 1999
 | Sept. 30 2000
 | Sept. 30 2001
 | Total Interest Owed |  |  | During [NAME] years
 | Reagan-Bushes Debt, 9/30/2009:
 | Interest since 9/2009:
 | Inputs are color coded and found at the Treasury
 | Gross national debts before 2000 on are found here:
 | www.treasurydirect.gov/govt/reports/pd/histdebt/histdebt_histo4.htm
 | Gross national debts from 2000 on are found here:
 | www.treasurydirect.gov/govt/reports/pd/histdebt/histdebt_histo5.htm
 | Annual Interest expenses are found here:
 | www.treasurydirect.gov/govt/reports/ir/ir_expense.htm
Spreadsheet: 852508d1702506472-separate-and-group-sequential-and-non-sequential-numbers-separate-between-sequential-and-non-sequential
Sheet: Sheet1

Sample Data 1 |  | Desired Result |  |  | Sample Data 2 |  | Desired Result |  |  |  | Sample 1 |  |  | Sample 2
 |  | From | To |  |  |  | From | To
1 |  | 1 | 3 |  | 17 |  | 17 |  |  |  |  | 3
2 |  | 5 |  |  | 19 |  | 19 | 20 |  |  | 5 |  |  | 19 | 20
3 |  | 7 | 9 |  | 20 |  | 24 |  |  |  | 7 | 9 |  | 24
5 |  | 11 |  |  | 24 |  | 26 | 27 |  |  | 11 |  |  | 26 | 27
7 |  | 13 |  |  | 26 |  | 29 | 32 |  |  | 13 |  |  | 29 | 32
8 |  | 15 | 20 |  | 27 |  | 34 |  |  |  | 15 | 20 |  | 34
9 |  |  |  |  | 29
11 |  |  |  |  | 30
13 |  |  |  |  | 31
15 |  |  |  |  | 32
16 |  |  |  |  | 34
17
18
19
20
Spreadsheet: 111935d1308163309-average-time-am-pm-when-various-criteria-are-met-sample
Sheet: WEEK 3

CALL LOG: WEEK OF
COLLECTOR |  | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | WEEKLY TOTAL
EXT | NAME | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION
7023 | b | 248 | 2:13:02 | 07:35:00 | 16:42:00 | 258 | 2:58:20 | 07:28:00 | 16:10:00 | 280 | 2:43:57 | 08:02:00 | 16:01:00 | 233 | 2:20:18 | 09:44:00 | 16:47:00 | 206 | 2:36:50 | 09:51:00 | 18:38:00
7008 | d | 348 | 6:54:21 | 07:59:00 | 18:44:00 | 229 | 4:13:09 | 07:59:00 | 16:37:00 |  |  |  |  | 310 | 5:50:06 | 08:01:00 | 18:49:00 | 287 | 5:21:58 | 07:58:00 | 17:00:00
7014 | c | 182 | 2:23:23 | 14:11:00 | 18:52:00 | 238 | 4:43:29 | 07:58:00 | 16:51:00 | 237 | 3:42:17 | 07:42:00 | 16:49:00 | 339 | 2:40:37 | 08:02:00 | 17:14:00 | 117 | 1:00:01 | 16:04:00 | 18:53:00
7011 | e | 290 | 4:10:17 | 08:59:00 | 16:49:00 | 187 | 3:11:07 | 08:46:00 | 16:54:00 | 129 | 1:48:31 | 12:40:00 | 17:12:00 | 157 | 1:55:52 | 09:00:00 | 16:50:00 | 241 | 2:56:56 | 09:12:00 | 17:04:00
7016 | g | 186 | 4:45:41 | 08:31:00 | 18:40:00 |  |  |  |  | 267 | 4:54:00 | 08:18:00 | 18:49:00 | 213 | 4:35:27 | 08:18:00 | 18:50:00 | 282 | 4:07:49 | 08:23:00 | 18:49:00
7032 | f | 229 | 3:21:47 | 08:32:00 | 16:55:00 | 234 | 4:16:13 | 10:09:00 | 18:53:00 | 71 | 1:03:47 | 08:08:00 | 10:57:00 | 185 | 2:54:00 | 08:13:00 | 16:58:00 | 204 | 3:06:27 | 08:21:00 | 16:56:00
7018 | h | 196 | 3:45:42 | 08:16:00 | 16:55:00 | 175 | 5:42:54 | 08:11:00 | 16:57:00 | 193 | 4:38:15 | 08:19:00 | 17:00:00 | 171 | 2:54:36 | 08:24:00 | 16:54:00 | 181 | 3:29:09 | 08:55:00 | 16:58:00
7013 | j | 131 | 2:28:15 | 08:09:00 | 16:41:00 | 152 | 4:32:26 | 08:21:00 | 16:22:00 | 105 | 3:45:16 | 08:05:00 | 16:49:00 | 151 | 2:40:58 | 08:18:00 | 16:53:00 | 281 | 4:22:22 | 08:07:00 | 16:58:00
7015 | i | 288 | 4:12:13 | 07:55:00 | 16:49:00 |  |  |  |  |  |  |  |  | 219 | 2:54:29 | 07:53:00 | 16:58:00 | 299 | 3:33:35 | 08:03:00 | 16:52:00
7012 | a | 348 | 6:54:21 | 07:59:00 | 18:44:00 |  |  |  |  | 187 | 3:11:07 | 08:46:00 | 16:54:00 | 213 | 4:35:27 | 08:18:00 | 18:50:00
COURT TOTALS
COURT AVERAGE
7010 | x | 282 | 4:00:05 | 08:17:00 | 18:43:00 | 361 | 5:29:16 | 08:07:00 | 18:52:00 | 393 | 5:19:10 | 08:09:00 | 18:42:00 | 338 | 4:37:59 | 08:03:00 | 18:45:00
7022 | y | 234 | 3:18:25 | 08:17:00 | 16:51:00 | 279 | 3:27:05 | 08:07:00 | 16:55:00 | 178 | 2:50:43 | 08:11:00 | 16:49:00 | 183 | 3:11:47 | 08:19:00 | 16:55:00 | 244 | 3:08:18 | 08:09:00 | 16:57:00
7019 | z | 220 | 2:57:21 | 08:11:00 | 17:54:00 | 147 | 1:58:55 | 08:14:00 | 17:37:00 | 148 | 2:43:42 | 08:27:00 | 17:05:00 | 186 | 3:07:13 | 10:00:00 | 17:51:00 | 162 | 2:31:24 | 08:24:00 | 16:40:00
CONSUMER TOTALS
CONSUMER AVERAGE
COMBINED TOTALS
COMBINED AVERAGE
Spreadsheet: 701262d1603664652-calendar-for-multi-day-recurring-events-recurring-events-multi-day
Sheet: Settings & Data

 | Drop Down Options: |  |  |  |  |  |  |  |  | All Dates
 | Basic | Weekdays | Months | Recurrency | Special Days | Special Dates | Cultural | People |  | Index | Dates | Display
 | Yes | Sunday | January | Monthly | Leap Day |  | Statutory | Birthday
 | No | Monday | February | Weekly | Easter |  | Observance | Anniversary
 |  | Tuesday | March | Daily | Passover |  | Popular | Memorial
 |  | Wednesday | April | One-Time | Good Friday
 |  | Thursday | May |  | [NAME]
 |  | Friday | June
 |  | Saturday | July
 |  |  | August
 |  |  | September
 |  |  | October
 |  |  | November
 |  |  | December
 |  |  | Special
Spreadsheet: 864411d1711592101-help-with-a-array-formula-to-output-results-sample-one-formula-dj
Sheet: Sheet1

Name | Start | End | Status |  |  | Name | Ttl # [NAME] |  | Total work done by shift |  |  | Day Shift Employees |  | Afternoon Shift Employees
[NAME] | 09:00:00 | 09:45:00 |  |  |  |  | 1 |  | Days | 7 |  | Name |  | Name
[NAME] | 09:00:00 | 09:40:00 | [NAME] |  |  | [NAME] | 2 |  | Afternoon | 3 |  | [NAME] |  | Grant
[NAME] | 09:10:00 | 10:05:00 | [NAME] |  |  | Michelle | 2 |  | Total | 10 |  | [NAME] |  | Michelle
Michelle | 09:10:00 | 10:00:00 | [NAME] |  |  | [NAME] | 3 |  |  |  |  | [NAME]
Grant | 10:00:00 | 11:45:00 | [NAME] |  |  | [NAME] | 2
[NAME] | 09:40:00 | 11:00:00 | [NAME]
[NAME] | 09:45:00 | 10:45:00 | [NAME]
Michelle | 10:00:00 | 10:56:00 | [NAME]
[NAME] | 10:05:00 | 11:28:00 | [NAME]
[NAME] | 11:00:00 | 12:10:00 | [NAME]
Grant | 11:45:00 |  | IN PROGRESS
 |  |  | `
Spreadsheet: 45150d1243938811-formula-to-calculate-growth-credit-card-sales-predictions
Sheet: Sheet1

 | January | February | March | April | May | June | July | August | September | October | November | December
Month Number | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Working Days | 20 | 20 | 21 | 19 | 20 | 21 | 23 | 20 | 22 | 22 | 21 | 11
Calls | 154345 | 210678 | 221370 | 157362 | 128112 | 168833.3930513918 | 189009.241109743 | 106056.901282933 | 128227.3400754286 | 120566.2119979925 | 88500.0946047462 | 16321.45334142072
Actual Sales | 3113 | 3601 | 3354 | 1824 | 1581
Predicted Sales | 3147.066475105142 | 3468.943297757247 | 3431.520392276728 | 1866.157780410461 | 1550.900524119251 | 1748.846700348462 | 1974.470848293523 | 902.7840223992321 | 1028.160193498935 | 857.31681179753 | 586.8813219706427 | 148.9242824846718
% Variance (Actual Vs Predicted) | -0.0109432942836949 | 0.03667223055894269 | -0.02311281821011561 | -0.02311281820748976 | 0.0190382516639777 | - | - | - | - | - | - | -
Sales Coefficient
1.000004361316213
1.095081206324589
0.862167071002159
302.7223096367769
Spreadsheet: 889672d1740575779-help-with-index-vlookup-and-calculations-test
Sheet: Holding

 |  | name | amount
 |  | Name 2
 |  | Name 3
 |  | Name 4
 |  | Name 1
 |  | Name 4
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Spreadsheet: 722258d1615145839-how-to-handle-dups-when-using-vlookup-book2
Sheet: Sheet1

Name | Name | Rec No | Census | 1790 | 1800 | 1810 | 1820 | 1830 | 1840 | 1850 | 1855 | 1860 | 1865 | 1870 | 1880 | 1890 | 1900 | 1910 | 1920 | 1930 | 1940 | 1950
[NAME], [NAME] | [NAME] | 29 | x
[NAME], [NAME] A | [NAME] | 3 | x
[NAME], [NAME] | [NAME] | 37 | x
[NAME], [NAME] | [NAME] | 413 | x
[NAME], Elmer | [NAME] | 31 | x
[NAME], [NAME] | [NAME] | 206 | x
[NAME], [NAME] | [NAME] | 204 | x
Spreadsheet: daren_farmer__5043__HPLN0418
Sheet: Sheet1

HPLN0418.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - April 18, 2001
 |  |  |  |  |  | **Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-04-18 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Sandhills |  | Enron | 8 | 8
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 693698d1599100124-sumifs-by-ccy-fiscal-period-and-category-though-special-treatment-for-specific-categories-sumifs
Sheet: Monthly

Fiscal Period | 2020P9 | GBP | EUR | USD | CHF | AUD | SGD | HKD | [NAME] | AED | CAD | MYR |  | https://www.excelforum.com/excel-formulas-and-functions/1326251-sumifs-by-ccy-fiscal-period-and-category-though-special-treatment-for-specific-categories.html
Currency | AR
 | [NAME]
 | APT
 | APNT Vendor
 | APNT Expenses
 | ECM
 | ECM Tax
 | ECM Pension/Other
 | IP Net Pay
 | IP Tax
 | IP Social
 | IP Other
 | Tax VAT
 | Tax CT
 | Tax Other
 | CoSec/Legal
 | [NAME]
 | Other
Spreadsheet: 713806d1610952705-formula-to-determine-what-the-next-arrival-date-is-for-stock-on-order-ordertracker
Sheet: Order Tracker

 |  | Order No. | MDI-0324 | MDI-0347 | MDI-0350A | MDI-0335 | MDI-0344 | MDI-0357
 |  | Supplier
 |  | Status | SHIPPED | SHIPPED | SHIPPED | SHIPPED | SHIPPED | SHIPPED
 |  | Vessel ETA | 2021-01-15 00:00:00 | 2021-01-21 00:00:00 | 2021-01-21 00:00:00 | 2021-01-22 00:00:00 | 2021-01-30 00:00:00 | 2021-01-29 00:00:00
 |  | Container No
 |  | [NAME] | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-21 00:00:00 | 2021-02-21 00:00:00
Code | Next arriving QTY | ETA Meubilair | 2021-01-19 00:00:00 | 2021-01-20 00:00:00 | 2021-01-25 00:00:00 | 2021-01-27 00:00:00 | 2021-02-04 00:00:00 | 2021-02-10 00:00:00
20265M | 100 | 2021-01-25 00:00:00 |  |  | 100 | 50
20665M | 50 | 2021-01-19 00:00:00 | 50 |  | 50
22471M | 100 | 2021-01-20 00:00:00 |  | 100
23662M | 200 | 2021-01-19 00:00:00 | 200 |  |  |  | 70 | 55
23663M | 40 | 2021-02-04 00:00:00 |  |  |  |  |  | 40
23664M | 200 | 2021-01-20 00:00:00 |  | 200 |  | 100
23666M | 50 | 2021-02-10 00:00:00 |  |  |  |  |  | 50
23865M | 40 | 2021-02-04 00:00:00 |  |  |  |  | 40 | 40
23866M | 30 | 2021-01-25 00:00:00 |  |  | 30 |  |  | 50
24273M |  |  |  | 200 |  | 200
57946M |  |  |  | 50
61491 |  |  | 100 |  |  |  |  | 50
61492 |  |  |  |  |  | 50
61493 |  |  |  |  |  |  | 150
61494 |  |  |  | 100
63232 |  |  |  |  | 50
63233 |  |  |  |  |  | 30
63234 |  |  |  |  | 20 |  | 20
63235 |  |  |  |  | 20 |  | 20
63727 |  |  |  |  | 100 |  | 100
Spreadsheet: 29146d1223984385-multiple-vlookups-incrementalisev2
Sheet: Sheet2

 | CustomerEvent# | Data
 | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10
customer# | Amount | Paid | Amount | Paid | Amount | Paid | Amount | Paid | Amount | Paid | Amount | Paid | Amount | Paid | Amount | Paid | Amount | Paid | Amount | Paid
1002 | 200003 | 1 | 20054 | 1 | 200566 | 1 | 201234 | 0 | 200003 | 1 | 205656 | 1 | 200003 | 0 | 202345 | 1 | 265666 | 0 | 209999 | 1
Grand Total | 200003 | 1 | 20054 | 1 | 200566 | 1 | 201234 | 0 | 200003 | 1 | 205656 | 1 | 200003 | 0 | 202345 | 1 | 265666 | 0 | 209999 | 1
Change the customer# to observe effects on sheet3