tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 151373d1334874669-copying-data-to-another-worksheet-ist-answer-sheet
Sheet: TEST #5

TEST 05 ANSWERS
POSITION |  | 0 |  |  | INIT | 0
LAST NAME |  | 0
1 | B |  | 0
2 | A |  | 0
3 | C |  | 0
4 | C |  | 0
5 | B |  | 0
6 | C |  | 0
7 | D |  | 0
8 | B |  | 0
9 | B |  | 0
10 | D |  | 0
11 | B |  | 0
12 | A |  | 0
13 | C |  | 0
14 | C |  | 0
15 | B |  | 0
16 | C |  | 0
17 | B |  | 0
18 | A |  | 0
19 | A |  | 0
20 | D |  | 0
21 | A |  | 0
22 | D |  | 0
23 | C |  | 0
24 | B |  | 0
25 | D |  | 0
 |  |  | 0 | Points
 |  |  | 0 | %
Spreadsheet: 113933d1309822146-conditional-formatting-copy-down-contact-calander_not_solved
Sheet: Sheet1

2011-07-04 00:00:00 | QUOTE | ORDER | Contact Tracker |  |  |  |  |  |  |  |  | DAYS |  | DAYS |  | DAYS | BDAY | DAYS
Date |  |  | Last Name | First Name | Address | City | Postal | [NAME] | Phone | Cell | Quote Card |  | [NAME] |  | 6 Mth |  | 12 Mth
2011-06-25 00:00:00 | Y |  |  |  |  |  |  |  |  |  | 2011-07-02 00:00:00 | -2 |  |  | 2011-12-22 00:00:00 | 171
Spreadsheet: kim_ward__20936__jobsearch
Sheet: jobs

COMPANY | CITY | $ | RESUME? | HEADHUNTER | PHONE | EMAIL ADDRESS | JOB | MANAGER | COMMENTS
FPL | Houston? | 100-150, 35-40% | 2001-12-04 00:00:00 | [NAME] | [PHONE] |  | West Power Originator, Marketer | [NAME] | [NAME] on Monday - have her send resume
Eprime | Denver |  | 2001-12-04 00:00:00 | [NAME] | [PHONE] |  | Director, Gas Origination |  | [NAME] on Monday - have her send resume
SMUD | Sacramento |  |  | none |  |  | real-time scheduling | [NAME]
Palo Alto | Palo Alto |  |  | call [NAME] |  |  | Senior Resource Planner
Coral | San Diego |  | 2001-12-06 00:00:00 | call [NAME] |  |  | west origination
DUKE
El Paso |  |  |  |  |  |  |  |  | Hiring freeze
AEP
PSCO - power | Denver |  | called - lm | none | [PHONE] |  | power origination | [NAME] | LM on 11/30
PSCO - gas | Denver |  | called - lm | none | [PHONE] |  | gas origination | [NAME] | LM on 11/30
APS | Phoenix | 80K, 20K |  | none |  |  | power or gas trading | [NAME]
Occidental | Houston | 100K | 2001-11-30 00:00:00 | Army Guerra |  | [EMAIL] | gas marketer in [NAME] | [NAME] | talked 11/30
[NAME]
City of Mesa | Mesa, AZ
NRG | Minniapolis |  | 2001-12-06 00:00:00 | Todd |  |  | power originator
Western Resources | Topeka |  | 2001-12-06 00:00:00 | Todd
Spreadsheet: 3611e05a-64c1-4673-a514-1f2f3cbe085e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5059 | 5547 | [NAME] | [NAME] | RSA | 21 | 00:20:27 | 00:00:49 | 01:17:41 | 00:00:57 | 00:40:41 | 1 | [NAME]
5059 | 30438 | [NAME] | Steyn | RSA | 24 | 00:22:26 | 00:00:50 | 01:19:56 | 00:00:54 | 00:44:09 | 2 | 02:28:16
5059 | 9697 | [NAME] | Germishuys | RSA | 25 | 00:22:26 | 00:00:49 | 01:22:40 | 00:00:55 | 00:44:16 | 3 | 02:31:06
5059 | 12804 | [NAME] | Fischer | RSA | 27 | [NAME] | 00:00:48 | 01:23:45 | 00:00:54 | 00:45:06 | 4 | 02:31:49
5059 | 7803 | Vicky | [NAME] | RSA | 22 | 00:21:12 | 00:00:50 | 01:23:51 | 00:01:02 | 00:46:47 | 5 | 02:33:42
5059 | 30415 | Lauren | Dance | RSA | 0 | 00:22:23 | 00:00:50 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
5059 | 10743 | [NAME] | [NAME] | RSA | 23 | 00:22:24 | 00:00:48 | 01:29:40 | 00:00:57 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 274572d1383151867-rearrange-list-in-an-alhabatical-order-copy-of-book1sample-1-
Sheet: Sheet1

 |  |  |  |  | OFFICE LIST
 |  |  |  |  | NAME | CODE | NAME2 |  |  |  |  | A CODE | FAX NO | JP NO | VPN NO | LINE NO
 |  |  |  | Bidhuna | RAJOPUR | 242 | [NAME] |  |  |  |  | QF |  | E1141
 |  |  |  | Kankaha | MANADNAGRI | 436 | [NAME] |  |  |  |  | WF |  | 411`E4 |  | 131
 |  |  |  | Malihabad | Bidhuna | 456 | Kanishka Nath |  |  |  |  | AF |  | 341113 |  | 134
 |  |  |  | MANADNAGRI | Malihabad | 464 | Manjusha |  |  |  |  | FS |  | 414141 | 2619
 |  |  |  | RAJOPUR | Kankaha | 632 | Kapoor |  |  |  |  | SG |  | 1241 | 3519 | 132
Spreadsheet: 741543d1627115009-counting-items-taking-more-than-stipulated-time-between-batch-productions-counting-sample-copy
Sheet: Sheet1

Item | Batch | Production Date | [NAME] | Time from expiry to next batch production
[NAME] | 1 | 2021-01-12 00:00:00 | 2021-01-28 00:00:00 | NA
YYY | 1 | 2021-01-03 00:00:00 | 2021-01-06 00:00:00 | NA
ZZZ | 1 | 2021-01-02 00:00:00 | 2021-01-10 00:00:00 | NA
[NAME] | 2 | 2021-02-28 00:00:00 | 2021-02-28 00:00:00
ZZZ | 2 | 2021-01-12 00:00:00 | 2021-01-28 00:00:00
ZZZ | 3 | 2021-03-02 00:00:00 | 2021-03-10 00:00:00
YYY | 2 | 2021-01-12 00:00:00 | 2021-01-18 00:00:00
 |  |  |  | Count of items taking more than 25 days for production of next batch
 |  |  |  | 2
Spreadsheet: 299889d1393320959-displaying-date-format-file-name-in-a-cell-24-02-14
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | (Full Filename)
 |  |  |  |  |  |  |  |  | Filename with extension
 |  |  |  |  |  |  |  |  | Filename without extension
 |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 |  |  |  |  |  | format cells - date - *14/03/2001
Spreadsheet: john_griffith__16137__1_24_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 19.5 | 175 | 187 | 47 | 50.2 | 0.6 | 2002-01-24 11:06:00
 | CL J2 | 20 | 275 | 290 | 46.8 | 49.4 | 0.6 | 2002-01-24 11:06:00
 | CL K2 | 20 | 350 | 360 | 46.5 | 47.8 | 0.59 | 2002-01-24 11:06:00
 | CL M2 | 20 | 395 | 400 | 45.3 | 45.9 | 0.57 | 2002-01-24 11:06:00
 | CL N2 | 20 | 430 | 450 | 43.7 | 45.8 | 0.56 | 2002-01-24 11:06:00
 | CL Q2 | 20 | 450 | 470 | 41.8 | 43.6 | 0.54 | 2002-01-24 11:06:00
 | CL U2 | 20 | 460 | 485 | 39.7 | 41.9 | 0.51 | 2002-01-24 11:06:00
 | [NAME] | 20 | 465 | 485 | 37.4 | 39 | 0.48 | 2002-01-24 11:06:00
 | CL X2 | 20 | 470 | 490 | 35.7 | 37.2 | 0.46 | 2002-01-24 11:06:00
 | [NAME] | 20 | 480 | 500 | 34.8 | 36.3 | 0.45 | 2002-01-24 11:06:00
 | CL F3 | 20 | 490 | 510 | 33.9 | 35.3 | 0.44 | 2002-01-24 11:06:00
 | CL G3 | 20.5 | 495 | 520 | 32.1 | 33.7 | 0.42 | 2002-01-24 11:06:00
 | CL M3 | 20.5 | 515 | 530 | 29.4 | 30.3 | 0.38 | 2002-01-24 11:06:00
 | CL Z3 | 20.5 | 535 | 555 | 26.7 | 27.7 | 0.35 | 2002-01-24 11:06:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 68532d1269043520-formula-disappears-generic-version
Sheet: Sorry

 | Your Goal |  |  |  | Your Plan
 |  |  | Revenue
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 | 291885.5808523059 |  |  |  | 0
 |  |  |  |  | 0
 | 291885.5808523059 |  |  |  | 0
 |  |  |  | M | 58377.11617046119
 |  |  |  | 1 | 23350.84646818448
 |  |  |  | 2 | 35026.26970227671
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 | 116754.2323409224 |  |  |  | 116754.2323409224
 | 175131.3485113835 |  |  |  | -116754.2323409224
 |  |  |  |  | -33741.97314652656
 |  |  |  |  | -16345.59252772913
 |  |  |  |  | -66666.66666666669
 | 15000 |  |  |  | 15000
 | 85000 |  |  |  | -81666.66666666669
 |  |  |  | Difference | 166666.6666666667 |  | Where would you like to adjust your estimates?
Spreadsheet: 2221c500-1a35-40aa-b8bc-d710e0f6acb9
Sheet: 2

 | Nov 30 |  | Dec 7 |  | Dec 14 |  | Dec 21
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rates* | 386135995 | 386135995 | 386815002 | 386815002 | 373815958 | 373815958 | N/A | N/A
SD/MSPs | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 16707328 | 16707328 | 16715730 | 16715730 | 14833311 | 14833311 | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | 22031189 | 22031189 | 22051544 | 22051544 | 22186373 | 22186373 | 20253627 | 20253627
Dealers** | 18749996 | 18718637 | 18742936 | 18712521 | 18853736 | 18819257 | 17188255 | 17188614
Buyside | 3281193 | 3312552 | 3308609 | 3339024 | 3332637 | 3367115 | 3065372 | 3065012
Total Equity | 6121616 | 6121616 | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Commodities | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, estimated gross notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, and participant types, cleared and uncleared. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL]
Spreadsheet: 772078d1646998251-need-help-on-formula-to-get-score-for-help-calculation
Sheet: For Help

 |  |  |  |  |  |  |  |  |  |  | 1st Scenario |  |  | 2nd Scenario
 |  |  |  | 2 | 2.5 | 3.5 | 4.5
 |  | Transaction Per Hr | Weight | Range |  |  |  | Out of 5 |  |  | Transaction Per Hr | Expected Score Out of 5 |  | Transaction Per Hr | Expected Score Out of 5
 |  | 17.25 |  | 16 | 21 | 24 | 27 |  |  | A --- > | 16 | 2 |  | 2 | 2
 |  |  |  |  |  |  |  |  |  | mid of A & B
 |  |  |  |  |  |  |  |  |  | B --- > | 21 | 2.5 |  | 4 | 2.5
 |  |  |  |  |  |  |  |  |  | mid of B & C
 |  |  |  |  |  |  |  |  |  | C --- > | 24 | 3.5 |  | 6 | 3.5
 |  |  |  |  |  |  |  |  |  | mid of C & D
 |  |  |  |  |  |  |  |  |  | D --- > | 27 | 4.5 |  | 8 | 4.5
 |  |  |  |  |  |  |  |  |  |  | 30 | 5
 |  |  |  | 2 | 2.5 | 3.5 | 4.5
 |  | Transaction Per Hr | Weight | Range |  |  |  | Out of 5
 |  | 7.99 |  | 2 | 4 | 6 | 8
Spreadsheet: 742f38fa-1f32-455f-bd56-0777bba7e648
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7940 | 41634 | [NAME] | Stockwell | USA | 84 | 00:04:52 | 00:03:10 | 00:43:22 | 00:02:05 | 00:28:43 | 1 | 01:22:14
7940 | 60937 | Hailey | Danisewicz | USA | 85 | 00:07:00 | 00:03:30 | 00:44:39 | 00:01:49 | [NAME] | 2 | 01:26:54
7940 | 60940 | [NAME] | [NAME] | USA | 86 | [NAME] | 00:03:44 | 00:49:49 | 00:02:16 | 00:31:47 | 3 | 01:34:23
Spreadsheet: 731130d1620206607-looking-up-a-sum-of-values-with-a-moving-column-each-week-example-file
Sheet: Data Week2

DmdUnit | *TYPE | 2021-05-09 00:00:00 | 2021-05-16 00:00:00 | 2021-05-23 00:00:00 | 2021-05-30 00:00:00 | 2021-06-06 00:00:00 | 2021-06-13 00:00:00 | 2021-06-20 00:00:00 | 2021-06-27 00:00:00 | 2021-07-04 00:00:00 | 2021-07-11 00:00:00 | 2021-07-18 00:00:00 | 2021-07-25 00:00:00 | 2021-08-01 00:00:00 | 2021-08-08 00:00:00
397726_0118 | 4 | 51115 | 51115 | 51115 | 51115 | 51115 | 51115 | 51115 | 51115 | 51115 | 51115 | 51115 | 51115 | 51115 | 1
397726_0118 | 4 | 11.17 | 11.17 | 11.17 | 11.17 | 11.17 | 11.17 | 11.17 | 11.17 | 11.17 | 11.17 | 11.17 | 11.17 | 11.17 | 2
397726_0118 | 4 | 2000 | 1007 | 1007 | 1007 | 1007 | 1007 | 1007 | 1007 | 1007 | 1007 | 1007 | 1007 | 1007 | 3
397683_0118 | 4 | 124 | 500 | 124 | 124 | 124 | 124 | 124 | 124 | 124 | 124 | 124 | 124 | 124 | 4
397683_0118 | 4 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 5
397683_0118 | 4 | 8 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 6
397685_0118 | 4 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 7
397685_0118 | 4 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 8
397685_0118 | 4 | 100 | 1000 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 9
397687_0118 | 4 | 246 | 246 | 246 | 246 | 246 | 246 | 246 | 246 | 246 | 246 | 246 | 246 | 246 | 10
397687_0118 | 4 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 11
397687_0118 | 4 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 12
397689_0118 | 4 | 557 | 557 | 557 | 557 | 557 | 557 | 557 | 557 | 557 | 557 | 557 | 557 | 557 | 13
397689_0118 | 4 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 14
397689_0118 | 4 | 33 | 80 | 40 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
Spreadsheet: 149656d1334072952-excel-2007-pivot-table-i-want-the-actual-value-date-to-show-up-in-the-value-test-pivot-problem
Sheet: Pivot

Count of Event Date | Event Code
Row Labels | 02 | 03 | 04 | 05 | 06 | 07 | 08 | (blank) | Grand Total
Person 1 | 1 | 1 | 1 | 1 |  | 1 | 1 |  | 6
Person 2 |  |  | 1 | 1 |  |  |  |  | 2
Person 3 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 6
Person 4 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 7
Person 5 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 6
(blank)
Grand Total | 4 | 4 | 5 | 5 | 3 | 4 | 2 |  | 27
I need the actual date in each value - not the number 1
Spreadsheet: 832230d1686196104-order-sheet-for-supplies-for-my-special-education-class-pq-supplies-aligw
Sheet: Totals

 | Order Information
 | Class | Total Supplies Ordered | Total Cost
 | AR
 | PLP1
 | [NAME]
 | PLP3
 | SSP1
 | SSP1
 | [NAME]
Spreadsheet: 3db26791-0764-41b5-a62e-2447310f99f1
Sheet: Sheet1

MONDAY PROGRAM SCHEDULE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Rotation | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
9:00 - 9:50 | Swim   Check | Den Time | Shower | Scout     Craft | Nature | BBs | [NAME] | Den Time | Trading Post | [NAME] | Handicraft | Archery
10:00 - 10:50 | Den Time | Shower | Scout     Craft | Nature | BBs | [NAME] | Den Time | Trading Post | [NAME] | Handicraft | Archery | [NAME]
11:00 -11:50 | Shower | Scout     Craft | Nature | BBs | [NAME] | Den Time | Trading Post | [NAME] | Handicraft | Archery | [NAME] | Den Time
12:30 - 1:15 | LUNCH
1:15 - 2:30 | SEISTA
2:30 - 3:20 | Scout     Craft | Nature | BBs | [NAME] | Den Time | Trading Post | [NAME] | Handicraft | Archery | [NAME] | Den Time | Shower
3:30 - 4:20 | Nature | BBs | Swim   Check | Den Time | Trading Post | [NAME] | Handicraft | Archery | [NAME] | Den Time | Shower | [NAME]
4:30 - 5:20 | BBs | Swim   Check | Den Time | Trading Post | [NAME] | Handicraft | Archery | [NAME] | Den Time | Shower | [NAME] | Nature
5:50 - 5:55 | RETREAT
6:00 - 6:45 | DINNER
7:00 - 8:00 | STAFF HUNT
TUESDAY PROGRAM SCHEDULE
Rotation | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
9:00 - 9:50 | Boating | Den Time | Trading Post | [NAME] | Handicraft | Archery | Boating | Den Time | Shower | [NAME] | Nature | BBs
10:00 - 10:50 | Den Time | Trading Post | [NAME] | Handicraft | Archery | Boating | Den Time | Shower | [NAME] | Nature | BBs | Boating
11:00 -11:50 | Trading Post | [NAME] | Handicraft | Archery | Boating | Den Time | Shower | [NAME] | Nature | BBs | Boating | Den Time
12:30 - 1:15 | LUNCH
1:15 - 2:30 | SEISTA
2:30 - 3:20 | [NAME] | Handicraft | Archery | Boating | Den Time | Shower | [NAME] | Nature | BBs | Boating | Den Time | Trading Post
3:30 - 4:20 | Handicraft | Archery | Boating | Den Time | Shower | [NAME] | Nature | BBs | Boating | Den Time | Trading Post | [NAME]
4:30 - 5:20 | Archery | Boating | Den Time | Shower | [NAME] | Nature | BBs | Boating | Den Time | Trading Post | [NAME] | Handicraft
5:50 - 5:55 | RETREAT
6:00 - 6:45 | DINNER
7:00 - 8:30 | CAMPWIDE PROGRAM
7:15-7:45 | LEADER'S ROUNDTABLE (IN THE PIT)
8:45-10:00 | SECOND YEAR CAMPER PROGRAM
9:00-10:00 | SAFE SWIM DEFENSE (ADMIN)
Spreadsheet: 51fcb3d9-04d8-441a-af69-6172a9a97adb
Sheet: Wage growth

 | This sheet contains the CAA's estimates of the impact of wage growth assumptions on the airports staff costs.
 | Heathrow - wage growth
 |  |  |  |  | Q5 |  |  |  |  | Q5+1 | Q6 |  |  |  |  |  | Q6 Total | CAGR | per year
 |  |  |  |  | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19
 | Staff costs from ABP (cross check)
 | January 2013 RBP Forecast |  |  |  | Q5 |  |  |  |  | Q5+1 | Q6 |  |  |  |  |  | Q6 Total | CAGR | per year
 |  |  |  |  | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19
 | Total Man Years
 | Staff Total Index (2012/13 =1)
 | £m 2011/12
 | Regulatory Staff Costs
 | Regulatory Staff Costs (Forecasts at current rates)
 | Year: |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | Forecast with " reduction |  |  |  |  |  |  |  |  | 305.4860567942724 | 290.1563560768578 | 278.0436511119685 | 263.4254085301515 | 254.5499717462305 | 251.2025961792058
 | "
 | End
Spreadsheet: 706358d1606659080-marking-distinct-values-in-table-based-on-multiple-conditions-exceldistinct
Sheet: Sheet1

 |  |  |  |  |  | WHAT I WANT
Type | Year | District | 2019 DIST | 2020 DIST |  | 2019 DIST | 2020 DIST |  |  | Distinct Count of District |  | Year
ONE | 2019 | [NAME] |  |  |  | 1 |  |  |  | Type | District | 2019 | 2020
ONE | 2020 | [NAME] | 1 |  |  |  | 1 |  |  | ONE | [NAME] | 1 | 1
ONE | 2020 | [NAME] | 1 |  |  |  |  |  |  |  | WAZIR-S | 1 | 1
ONE | 2020 | [NAME] | 1
ONE | 2020 | [NAME] | 1
ONE | 2020 | [NAME] | 1
ONE | 2019 | WAZIR-S | 1 |  |  | 1
ONE | 2020 | WAZIR-S | 1 |  |  |  | 1
ONE | 2020 | WAZIR-S | 1
Spreadsheet: 843368d1695229509-date-ranges-and-conditional-formating-on-call-schedule-example_1
Sheet: Schedule Example

2023 CALL OUT LIST |  |  |  |  |  |  |  |  |  |  |  |  | Start Date | End Date
TechNove Solutions
On call hours turn over on Tuesdays at 4:30 PM
 |  |  |  |  |  |  |  |  |  |  |  | CF | Date | Day | TMS | (AI) | Day
2023-01-03 00:00:00 | - |  | [NAME] |  |  | - |  | [NAME] |  | EMPLOYEE | Contact # |  | 2023-09-19 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  | [NAME] | (555) 123-4567 |  | 2023-09-20 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  | [NAME] | (555) 987-6543 |  | 2023-09-21 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  | [NAME] | (555) 555-7890 |  | 2023-09-22 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  | [NAME] | (555) 789-1234 |  | 2023-09-23 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  | [NAME] | (555) 234-5678 |  | 2023-09-24 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  | [NAME] | (555) 876-5432 |  | 2023-09-25 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-09-26 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-09-27 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-09-28 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-09-29 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-09-30 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-10-01 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-10-02 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-10-03 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-10-04 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-10-05 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-10-06 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-10-07 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-10-08 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-10-09 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-10-10 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-10-11 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-10-12 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-10-13 00:00:00
 | - |  | [NAME] |  |  | - |  | [NAME] |  |  |  |  | 2023-10-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-22 00:00:00
Spreadsheet: drew_fossum__8882__MarchForecast
Sheet: TW-VARIANCE

 | [NAME]
 | First Quarter Forecast
 | Margins
 | Millions of Dollars
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st Qtr
 |  |  |  | Jan | Feb | March |  |  |  |  |  |  |  |  |  |  | Total
 | Error in plan |  |  | -0.027 | -0.026 | -0.027 |  |  |  |  |  |  |  |  |  |  |  |  | Duplication (Bayless ctrc)
 | Unsubscribed |  |  | -0.05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (9,000/d EOT-WOT & 25,000/d SLaPl-Bl)
 | Interim resubscription |  |  |  | -0.1 | -0.11 |  |  |  |  |  |  |  |  |  |  |  |  | Ctrc exp end of Jan - short-term rate $.05 vs. $12 (49,475/d EOT-WOT)
 | El Paso Field Services |  |  | -0.039 | -0.03625 | -0.03875 |  |  |  |  |  |  |  |  |  |  |  |  | Interconnect delayed on EPFS side
 | Southwest Gas |  |  | -0.01 | -0.01 | -0.01 |  |  |  |  |  |  |  |  |  |  |  |  | Pending FERC approval on SWGas side
 | Enhanced Firm Backhaul |  |  |  |  | -0.01 |  |  |  |  |  |  |  |  |  |  |  |  | Pending FERC approval
 | Market Center Service |  |  | -0.01
 | Interim resubscription |  |  |  |  | -0.02 |  |  |  |  |  |  |  |  |  |  |  |  | Ctrc exp end of Feb - short-term rate $.06 vs. $.10 (15,000/d BL-TH)
 | Subscribed at higher rates and volumes |  |  | 0.04 | 0.04 |  |  |  |  |  |  |  |  |  |  |  |  |  | Limited Term Firm,Texaco, Southern
 | 30-day deals and Daily FT |  |  | 0.1
 | Lower Volumes EOT to WOT |  |  |  | -0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Lower throughput from East of Thoreau to West of Thoreau
 | [NAME]. |  |  | 0.15 | 0.2
 | TOTAL MARGIN
 | Fuel  Price [NAME] |  |  | 0.4 | -0.03 | 0.08479 |  |  |  |  |  |  |  |  |  |  |  |  | January variance due to UAF reserve reversal of .244 and UAF lower than plan by .150
 | Fuel Volume Variance
 | Hedging Adjustment |  |  |  | 0.017 | 0.093
 | TOTAL FUEL
 | Total Transwestern
Spreadsheet: 74960d1275493208-vlookup-for-a-range-vlookup
Sheet: Sheet1

VALUE | RESULT |  | TABLE
29 | "Between 20 and 30" |  | -40 | "Between -30 and -40"
-4 | "Between 0 and -10" |  | -30 | "Between -20 and -30"
30 | "Between 30 and 40" |  | -20 | "Between -10 and -20"
10 | "Between 10 and 20" |  | -10 | "Between 0 and -10"
13 | "Between 10 and 20" |  | 0 | "No change"
-24 | "Between -20 and -30" |  | 1 | "Between 1 and 10"
9 | "Between 1 and 10" |  | 10 | "Between 10 and 20"
-39 | "Between -30 and -40" |  | 20 | "Between 20 and 30"
-26 | "Between -20 and -30" |  | 30 | "Between 30 and 40"
18 | "Between 10 and 20"
-24 | "Between -20 and -30"
35 | "Between 30 and 40"
28 | "Between 20 and 30"
13 | "Between 10 and 20"
-39 | "Between -30 and -40"
16 | "Between 10 and 20"
14 | "Between 10 and 20"
1 | "Between 1 and 10"
32 | "Between 30 and 40"
23 | "Between 20 and 30"
40 | "Between 30 and 40"
-7 | "Between 0 and -10"
-22 | "Between -20 and -30"
22 | "Between 20 and 30"
-25 | "Between -20 and -30"
36 | "Between 30 and 40"
23 | "Between 20 and 30"
2 | "Between 1 and 10"
-39 | "Between -30 and -40"
24 | "Between 20 and 30"
-28 | "Between -20 and -30"
12 | "Between 10 and 20"
-3 | "Between 0 and -10"
-35 | "Between -30 and -40"
-15 | "Between -10 and -20"
-34 | "Between -30 and -40"
5 | "Between 1 and 10"
30 | "Between 30 and 40"