tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 889682d1740584279-auto-serial-number-in-subtotal-with-excluding-each-subtotal-rows-creditors-list11
Sheet: Creditors

Currency | Name | Invoiced | Deduction | Paid | Balance | Invoice Rank
Above 1000K | A Industries | 2593183.24 | 0 | 0 |  | 1
 | B [NAME] | 2323983.51 | 0 | 0 |  | 2
 | C Industries | 2248999.79 | 0 | 0 |  | 3
 | B [NAME] | 1424269.43 | 0 | 0 |  | 4
 | C Industries | 1195558.24 | 0 | 0 |  | 5
 | D Industries | 1015870.56 | 0 | 0 |  | 6
 | Sub Total
Above 500K upto 1000K | A Industries | 955710 | 0 | 0 |  | 7
 | B [NAME] | 940929.15 | 0 | 0 |  | 8
 | C Industries | 906189.38 | 0 | 0 |  | 9
 | B [NAME] | 876585.9 | 0 | 0 |  | 10
 | C Industries | 825510.85 | 0 | 0 |  | 11
 | Sub Total
Above 250K upto 500K | A Industries | 485318.35 | 0 | 0 |  | 12
 | B [NAME] | 475400.1 | 0 | 0 |  | 13
 | C Industries | 451310.25 | 0 | 0 |  | 14
 | B [NAME] | 348557.73 | 0 | 0 |  | 15
 | C Industries | 292267.5 | 0 | 0 |  | 16
 | B [NAME] | 283664.22 | 0 | 0 |  | 17
 | C Industries | 265000 | 0 | 0 |  | 18
Above 250K upto 500K | Sub Total
Above 100K upto 250K | C Industries | 225428.22 | 0 | 0 |  | 19
 | C Industries | 204115.94 | 0 | 0 |  | 20
 | C Industries | 201998.7 | 0 | 0 |  | 21
 | C Industries | 194770.33 | 0 | 0 |  | 22
 | C Industries | 190978.02 | 0 | 0 |  | 23
 | C Industries | 163425.14 | 0 | 0 |  | 24
 | C Industries | 143526.51 | 0 | 0 |  | 25
 | C Industries | 128782.61 | 0 | 0 |  | 26
 | C Industries | 126360.52 | 0 | 0 |  | 27
 | C Industries | 125964 | 0 | 0 |  | 28
 | C Industries | 125250 | 0 | 0 |  | 29
 | C Industries | 124302.99 | 0 | 0 |  | 30
 | C Industries | 124192.33 | 0 | 0 |  | 31
 | C Industries | 118325 | 0 | 0 |  | 32
 | C Industries | 103346.79 | 0 | 0 |  | 33
 | C Industries | 103145.53 | 0 | 0 |  | 34
Above 100K upto 250K | Sub Total
 | A Industries | 94767.75 | 0 | 0 |  | 35
 | B [NAME] | 94069.46 | 0 | 0 |  | 36
 | C Industries | 91424.56 | 0 | 0 |  | 37
 | B [NAME] | 86959.92 | 0 | 0 |  | 38
 | C Industries | 82188.75 | 0 | 0 |  | 39
 | D Industries | 76240.5 | 0 | 0 |  | 40
 | B [NAME] | 74613 | 0 | 0 |  | 41
 | C Industries | 72516.88 | 0 | 0 |  | 42
 | B [NAME] | 70845.61 | 0 | 0 |  | 43
 | C Industries | 69980.1 | 0 | 0 |  | 44
 | D Industries | 68249.97 | 0 | 0 |  | 45
Below 100K | Sub Total
 | Group | Invoiced | Deduction | Paid | Balance | Count
 | Above 1000K upto 2000K
 | Above 500K upto 1000K
 | Above 250K upto 500K
 | Above 100K upto 250K
 | Below 100K
 | Total
Spreadsheet: 102547d1300467809-spreadsheets-numbers-change-to-date-example
Sheet: Sheet1

2010-11-01 00:00:00 | 2010-12-01 00:00:00
Advertiser ID | Advertiser | Rev Exp | [NAME] | Cost App | [NAME] | Acc Mngr | Status | Pmt Date Exp | Drgd Pmt | Rev AdvSys | Drgd Pmt AdvSys | Invoice Amt | Sale Scrub | [NAME] | Other Scrub | Pmt | Curr | Fees | Pmt Mtd | Prev Pmt | Net | Notes | Revenue (paid) | Expected Income | aaaaa | aaaaa | aaaaa | aaaaa | ChargeBacks (-BP) | Net Cost | Profit | Exp' Profit | % cost
1900-04-12 00:00:00 | a1 | 1960-04-07 14:58:50.880000 | 1988-12-15 13:48:17.280000 | 1942-06-15 10:44:49.920000 | 1911-02-02 22:25:06.240000 | Katerina | Out |  | 00:00:00 | 1966-08-23 05:45:36 |  |  |  |  |  |  | All |  | Wire | Out | 1900-02-28 00:00:00 |  |  |  | 1913-07-17 05:56:06.720000 |  | 1915-11-19 05:55:40.800000 | 1917-09-26 04:42:14.400000
1900-01-12 00:00:00 | a2 | 1921-03-06 20:05:08.160000 | 1953-09-02 20:56:41.280000 | 1915-06-15 08:22:07.680000 | 1901-08-17 01:54:02.880000 | Hagar | Out |  | 00:00:00 |  | 00:00:00 |  |  |  |  |  | USD |  | Wire | Out | 00:00:00 |  |  |  | 1904-02-13 04:05:22.560000 |  | 1908-06-14 07:50:35.520000 | 1908-09-04 13:25:03.043000
1900-07-23 00:00:00 | a3 | 1944-04-14 11:12:28.800000 | 1944-04-14 11:13:20.640000 | 1930-09-19 11:42:51.840000 | 1918-05-31 15:01:26.400000 | Sara | paid |  | 00:00:00 |  |  |  |  | 00:00:00 | 00:00:00 |  | EUR | 00:00:00 | Wire | October | 1900-01-01 00:00:00 |  |  |  | 1900-10-23 01:06:40.320000 |  | 1900-10-24 18:30:14.400000 | 1900-10-24 18:30:14.400000 | 1908-07-21 21:59:02.400000 |  |  |  |  |  |  | EUR | 1900-01-01 07:17:44.575000
1900-05-25 00:00:00 | a4 | 1922-04-03 00:45:56.160000 | 1932-04-12 23:50:47.040000 | 1916-10-20 15:34:42.240000 | 1902-02-04 07:36:28.800000 | Rebi | Out |  | 00:00:00 | 9047.08 |  |  |  | 1907-07-28 01:26:24 |  | 1918-04-20 15:07:12 | USD | 00:00:00 | Wire | October | 1900-02-14 00:00:00 |  | 1923-03-21 22:33:36 | 1924-10-07 10:48:00 | 1906-07-26 03:11:31.200000 |  | 1904-11-11 00:30:48.960000 | 1906-10-20 11:32:20.515000 |  |  |  |  |  |  |  | USD | 1900-01-01 00:00:00
1900-07-29 00:00:00 | a5 | 1921-11-03 13:22:04.800000 | 1931-04-29 04:18:11.520000 | 1916-03-20 19:03:04.320000 | 1901-06-21 09:50:24 | Sara | Paid |  | 00:00:00 | 1921-09-25 01:12:00 |  | 1921-09-25 01:12:00 | 1901-08-19 13:26:24 | 00:00:00 | 00:00:00 | 1921-09-10 02:52:48 | EUR |  | Wire | October | 1900-01-15 00:00:00 |  |  |  | 1904-11-01 13:44:58.560000 |  | 1906-03-22 09:01:00.480000 | 1906-03-22 09:01:00.480000 |  |  |  |  |  |  |  | NIS | 06:31:37.427000
Spreadsheet: lisa_gang__22248__ENA_PGE_APRIL_3_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-04-03 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  | Total In To PGE Trans
0100 |  | 0 | 4
0200 | 0 | 0 | 4
0300 | 0 | 0 | 4
0400 | 0 | 0 | 4
0500 | 0 | 0 | 4
0600 | 0 | 0 | 4
0700 | 0 | 4 | 0
0800 | 0 | 4 | 0
0900 | 0 | 4 | 0
1000 | 0 | 4 | 0
1100 | 0 | 4 | 0
1200 | 0 | 4 | 0
1300 | 0 | 4 | 0
1400 | 0 | 4 | 0
1500 | 0 | 4 | 0
1600 | 0 | 4 | 0
1700 | 0 | 4 | 0
1800 | 0 | 4 | 0
1900 | 0 | 4 | 0
2000 | 0 | 4 | 0
2100 | 0 | 4 | 0
2200 | 0 | 4 | 0
2300 | 0 | 0 | 4
2400 | 0 | 0 | 4
 | [NAME]) | PAC(G)MIDC | IPC(G)SYS
 | AVISTA(PSE) | PNM | IPC(T)SYS/LOLO
 | BPA(PSE) | ALLEGHENY | WWP(T)LOLO/MIDC
 | GAC(PSE) | EPMI(PSE) | IPC
 | BPA(T)MIDC/JD | SNPD(PSE) | MORGAN
 | GAC(PSE) | BPA(T)MIDC/JD | DYPM
 | BPA(PSE) | SNPD(PSE) | AVISTA
 | AVISTA(PSE) | EPMI(PSE) | ALLEGHENY
 | EPMI(PSE) | PGE(T)JD/MAL5 | EPMI(PSE)
 | PGE(T)JD/MAL5 | EPMI(PSE) | PGE(T)JD/MAL5
 | EPMI(PSE) | CISO(T)MAL5/NP15 | EPMI(PSE)
 | AVISTA(PSE) | EPMI(L, FS) CISO (CA) | CISO(T)MAL5/NP15
 | [NAME]) |  | EPMI(L, FS) CISO (CA)
 | CISO(T)MAL5/NP15
 | CERS(L,FS) CISO (CA)
Spreadsheet: 679272d1590305202-pull-top-three-values-in-list-only-if-in-specific-year-top-3-values-within-specific-dates
Sheet: Webinars

Content Analytics: [NAME]
 |  |  | 2019 | Webinars Overview
 |  |  |  |  | Top Three by Registrations
 |  |  | Rank | [NAME]. | Title
 |  |  |  | 722 | 2019 Webinar 11
 |  |  | 2 | 636 | 2019 Webinar 10
 |  |  | 3 | 505 | 2019 Webinar 12
 |  |  | 2020 | Webinars Overview |  |  | NEEDS TO ACCOUNT FOR YEAR
 |  |  |  |  | Top Three by Registrations
 |  |  | Rank | [NAME]. | Title
 |  |  |  | 300 | 2020 Webinar 1
 |  |  | 2 | 200 | 2020 Webinar 2
 |  |  | 3 | 122 | 2020 Webinar 5
 |  | DO NOT EDIT THESE
Webinar Title | Date | Year | Quarter | Registered | Attended | On-demand
2019 Webinar 1 | 2019-01-24 00:00:00 |  |  | 467 | 171 | 15
2019 Webinar 2 | 2019-04-10 00:00:00 |  |  | 140 | 73 | 13
2019 Webinar 3 | 2019-04-23 00:00:00 |  |  | 96 | 55 | 14
2019 Webinar 4 | 2019-04-25 00:00:00 |  |  | 167 | 36 | 5
2019 Webinar 5 | 2019-06-06 00:00:00 |  |  | 418 | 189 | 11
2019 Webinar 6 | 2019-06-20 00:00:00 |  |  | 201 | 74 | 5
2019 Webinar 7 | 2019-06-25 00:00:00 |  |  | 192 | 82 | 8
2019 Webinar 8 | 2019-08-07 00:00:00 |  |  | 206 | 71 | 9
2019 Webinar 9 | 2019-09-12 00:00:00 |  |  | 108 | 35 | 1
2019 Webinar 10 | 2019-09-24 00:00:00 |  |  | 636 | 177 | 4
2019 Webinar 11 | 2019-10-02 00:00:00 |  |  | 722 | 234 | 3
2019 Webinar 12 | 2019-11-13 00:00:00 |  |  | 505 | 300 | 9
2020 Webinar 1 | 2020-01-01 00:00:00 |  |  | 300 | 50 | 10
2020 Webinar 2 | 2020-01-02 00:00:00 |  |  | 200 | 75 | 30
2020 Webinar 3 | 2020-03-01 00:00:00 |  |  | 100 | 10 | 10
2020 Webinar 4 | 2020-04-01 00:00:00 |  |  | 60 | 35 | 9
2020 Webinar 5 | 2020-05-01 00:00:00 |  |  | 122 | 45 | 15
Spreadsheet: 693201d1598858141-how-to-apply-filter-formula-for-multiple-conditions-copy-of-processing-efficiency
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTR SENT | MTR RECEIVED | KGS SENT | KGS RECEIVED | [NAME] | REMARKS | WEEKS SENT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-26 00:00:00
Spreadsheet: 274293d1383065552-conditional-formatting-dates-based-on-date-range-and-day-gantt-cf-example
Sheet: Example

Attendance |  | Pilot Start | Pilot End | [NAME] | P1 End | [NAME] | [NAME] |  | 2013-10-01 00:00:00 | 2013-10-02 00:00:00 | 2013-10-03 00:00:00 | 2013-10-04 00:00:00 | 2013-10-05 00:00:00 | 2013-10-06 00:00:00 | 2013-10-07 00:00:00 | 2013-10-08 00:00:00 | 2013-10-09 00:00:00 | 2013-10-10 00:00:00 | 2013-10-11 00:00:00 | 2013-10-12 00:00:00 | 2013-10-13 00:00:00 | 2013-10-14 00:00:00 | 2013-10-15 00:00:00 | 2013-10-16 00:00:00 | 2013-10-17 00:00:00 | 2013-10-18 00:00:00 | 2013-10-19 00:00:00 | 2013-10-20 00:00:00 | 2013-10-21 00:00:00 | 2013-10-22 00:00:00 | 2013-10-23 00:00:00 | 2013-10-24 00:00:00 | 2013-10-25 00:00:00 | 2013-10-26 00:00:00 | 2013-10-27 00:00:00 | 2013-10-28 00:00:00 | 2013-10-29 00:00:00 | 2013-10-30 00:00:00 | 2013-10-31 00:00:00 | 2013-11-01 00:00:00 | 2013-11-02 00:00:00 | 2013-11-03 00:00:00 | 2013-11-04 00:00:00 | 2013-11-05 00:00:00 | 2013-11-06 00:00:00 | 2013-11-07 00:00:00 | 2013-11-08 00:00:00 | 2013-11-09 00:00:00 | 2013-11-10 00:00:00 | 2013-11-11 00:00:00 | 2013-11-12 00:00:00 | 2013-11-13 00:00:00 | 2013-11-14 00:00:00 | 2013-11-15 00:00:00 | 2013-11-16 00:00:00 | 2013-11-17 00:00:00 | 2013-11-18 00:00:00 | 2013-11-19 00:00:00 | 2013-11-20 00:00:00 | 2013-11-21 00:00:00 | 2013-11-22 00:00:00 | 2013-11-23 00:00:00 | 2013-11-24 00:00:00 | 2013-11-25 00:00:00 | 2013-11-26 00:00:00 | 2013-11-27 00:00:00 | 2013-11-28 00:00:00 | 2013-11-29 00:00:00 | 2013-11-30 00:00:00
Mon | Thu | 2013-10-14 00:00:00 | 2013-10-31 00:00:00 | 2013-11-04 00:00:00 | 2013-11-14 00:00:00
Sun | Wed | N/A | N/A | 2013-10-13 00:00:00 | 2013-10-21 00:00:00 | 2013-10-27 00:00:00 | 2013-12-01 00:00:00
Mon | Fri | N/A | N/A |  |  | 2013-11-11 00:00:00 | 2013-11-22 00:00:00
Spreadsheet: 1cd8721b-22df-4c37-a54f-c02dd7754793
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5765 | 40957 | Iain | Dawson | GBR | 36 | 00:12:42 | 00:03:01 | [NAME] | 00:02:18 | 00:23:33 | 1 | 01:10:26
5765 | 30685 | [NAME] | [NAME]   B1 | GBR | 37 | 00:13:44 | 00:03:25 | 00:29:44 | 00:02:35 | 00:21:32 | 2 | 01:11:00
5765 | 30797 | [NAME] | [NAME] | GBR | 35 | 00:15:43 | [NAME] | 00:32:06 | 00:02:34 | 00:22:57 | 3 | 01:16:54
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled | Totals
1 |  |  | 24500 | 24000
2 |  |  | 24489 | 24000
3 |  |  | 24487 | 24000
4 |  |  | 24484 | 24000
5 |  |  | 24523 | 24000
6 |  |  | 24492 | 24000
7 |  |  | 24497 | 24000
8 |  |  | 24506 | 20164
9 |  |  | 24485 | 24000
10 |  |  | 24482 | 24000
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  | -178485 | -108573
2001-11-30 00:00:00 | Balance | -1023166.39 |  | -526596.1
2001-12-10 00:00:00 | Balance
 |  |  |  | Contract #
 |  |  |  | 22864 | 0 | Zia |  |  | 22864
 |  |  |  | 20379 | -51695.87 | Grayco/Artesia |  |  | 20379 | 2979
 |  |  |  | 26357 |  | [NAME] |  |  | 26357
 |  |  |  | 21544 | 61340.16 | [NAME], [NAME] |  |  | 21544 | 36108
 |  |  |  | 24532 | -1132591.35 | 500211,500212,500219,500230 - Coburn points |  |  | 24532 | -139694
 |  |  |  | Duke
20379
24532
21544
26357
22864
23995
22051
21665
22664
24361
26393
24268
Spreadsheet: 99508d1298122511-if-function-test
Sheet: Sheet1

The |  |  |  |  |  |  |  | Family
Week 1 |  | Today's Date | Red Foods | Habit Book Score | Average Steps Per Day | Total Days Worn | Step Goal | Days Step Goal was Met? | Today's Weight | Weight Change | Total Weight Loss | Week 2 Red Food Goal | Week 2 Step Goal
 |  | 2011-04-05 00:00:00 |  |  | 5000 | 5 |  |  |  |  |  | 8 |  | 7000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11000
 |  |  |  |  |  | Total Family Weight Loss
Week 2 |  | Today's Date | Red Foods | Habit Book Score | Average Steps Per Day | Total Days Worn | Step Goal | Days Step Goal was Met? | Today's Weight | Weight Change | Total Weight Loss | Week 2 Red Food Goal | Week 2 Step Goal
 |  | 2011-04-05 00:00:00 | 9 | 5 | 11000 | 5 |  | 5 | 228 |  |  | 7 |  | 7000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11000
 |  |  |  |  |  | Total Family Weight Loss
Week 3 |  | Today's Date | Red Foods | Habit Book Score | Average Steps Per Day | Total Days Worn | Step Goal | Days Step Goal was Met? | Today's Weight | Weight Change | Total Weight Loss | Week 3 Red Food Goal | Week 3 Step Goal
 |  |  |  |  | 12000 |  |  | 5 |  |  |  | 6 |  | 7000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11000
 |  |  |  |  |  | Total Family Weight Loss
Spreadsheet: 65548d1266273456-find-a-value-across-multiple-sheets-in-another-workbook-sales-orders_2010
Sheet: SalesDec

Expected Sales Proceeds For JANUARY 2010
 |  |  |  |  |  |  | FX | 0.9135
 | INVOICE | INVOICE DATE | CUSTOMER | PRODUCT | Quantity | PRICE        USD / MT | AMOUNT (USD) | AMOUNT (AUD)
EXPORT
 | 101206 | 2010-12-12 00:00:00 | Customer1 | Product100 | 5000 | 5 | 25000 | 27367.26874657909
 | 101207 | 2010-12-13 00:00:00 | Customer2 | Product200 | 6000 | 5 | 30000 | 32840.72249589491
 | 101208 | 2010-12-14 00:00:00 | Customer3 | Product300 | 7000 | 5 | 35000 | 38314.17624521073
 | 101209 | 2010-12-15 00:00:00 | Customer4 | Product400 | 8000 | 5 | 40000 | 43787.62999452655
 | 101210 | 2010-12-16 00:00:00 | Customer5 | Product500 | 9000 | 5 | 45000 | 49261.08374384236
 | 101211 | 2010-12-17 00:00:00 | Customer6 | Product600 | 10000 | 5 | 50000 | 54734.53749315818
 | 101212 | 2010-12-18 00:00:00 | Customer7 | Product700 | 11000 | 5 | 55000 | 60207.991242474
 | 101213 | 2010-12-19 00:00:00 | Customer8 | Product800 | 12000 | 5 | 60000 | 65681.44499178982
 | 101214 | 2010-12-20 00:00:00 | Customer9 | Product900 | 13000 | 5 | 65000 | 71154.89874110564
DOMESTIC
Spreadsheet: 755900d1637168593-formula-for-calculating-the-scrabble-value-of-welsh-words-sample
Sheet: Template

Word | Value | [NAME]
gobeithio
Llantrisant
rhule
kangarŵ
[NAME]
helpu
diolch
yn
fawr
Dw i'n hoffi
Spreadsheet: 759906d1639798322-remove-text-from-cell-extract-text
Sheet: Sheet1

This is what I have | this is what I need | [NAME]
Capacity - Level 2: Coordination Of Supports - 07_002_0106_8_3 | 07_002_0106_8_3
Capacity - Level 2: Coordination Of Supports - 07_002_0106_8_3 | 07_002_0106_8_3
Self-Management Capacity Building - 01_134_0117_8_1 | 01_134_0117_8_1
Capacity - Level 2: Coordination Of Supports - Non Face 2 Face - 07_002_0106_8_3 | 07_002_0106_8_3
Cap-Assessmt,Recommendation,Therapy /Or Train(Incl. AT)-O/ [NAME] Face2face-15_056_0128_1_3 | 15_056_0128_1_3
Cap-Continence aids: assess, recomm/train by [NAME] - 15_051_0114_1_3 | 15_051_0114_1_3
Cap-Continence aids: assess, rrecomm/train by [NAME] | 15_051_0114_1_3
Cap - Health Supports By A Clinical Nurse - Weekday Daytime Travel - 15_412_0114_1_3 | 15_412_0114_1_3
Cap-Assessmt,Recommendation,Therapy /Or Train(Incl. AT)-O/ [NAME] Face2face-15_056_0128_1_3 | 15_056_0128_1_3
Spreadsheet: robin_rodrigue__33254__michaelrobin
Sheet: Comparison

 | In [NAME]'s P/L list not matching [NAME] |  | In [NAME]'s P/L list not matching [NAME]
 | East |  | East
 | INTRA-EA-PROMPT-PRC |  | ALL MATCH
 | INTRA-ME-PROMPT-PRC
 | Central |  | Central
 | ARUBA-PHY |  | ALL MATCH
 | Canada |  | Canada
 | IMCAN-ERMS-XL-BAS
 | In [NAME]'s Bench list not matching [NAME] |  | In [NAME]'s Bench list not matching [NAME]
 | East |  | East
 | INTRA-EA-PROMPT-PRC
 | INTRA-ME-PROMPT-PRC
 | CENTRAL |  | CENTRAL
 | ARUBA-PHY |  | FT-IM-ENOV-BAS
 |  |  | FT-IM-ENOV-PRC
 |  |  | TP-EMWNSS-IDX
 | WEST |  | WEST
 |  |  | GD-NEW-BAS
 |  |  | GD-NEW-GDL
 |  |  | GD-NEW-PRC
 |  |  | INTRA-WEST-PHY
 |  |  | FT-WEST-IDX
 |  |  | INTRA-WEST-IDX
 | TEXAS |  | TEXAS
 |  |  | GD-TEXAS-BAS
 |  |  | GD-TEXAS-GDL
 |  |  | GD-TEXAS-PRC
 |  |  | ST-BAMMEL-BAS
 |  |  | ST-BAMMEL-HPL-BAS
 |  |  | ST-BAMMEL-HPL-PRC
 |  |  | ST-BAMMEL-IDX
 |  |  | ST-BAMMEL-PRC
 |  |  | ST-ERMS-XL-PRC
 |  |  | ST-SPINDLETOP-BAS
 |  |  | ST-SPINDLETOP-PRC
 | CANADA |  | CANADA
 | IMCAN-ERMS-XL-BAS
 | NON-GAS TRADING |  | NON-GAS TRADING
 |  |  | OIL-NG-HDG-CAB-BAS
 |  |  | OIL-NG-HDG-CAB-GDL
 |  |  | OIL-NG-HDG-SPEC
Spreadsheet: 847783d1698657883-conditional-formatting-training-certificate-expiration-dates-course-matrix-august-2023
Sheet: Fuel Tank Safety

 |  | Fuel Tank Safety
 |  |  | (2 Years)
 | Name | Course | Date of course | Date of renewal
 | [NAME] | Fuel Tank Safety | N/A | Not required |  |  | Key
 | [NAME] | Fuel Tank Safety | N/A | Not required |  |  |  | Not due
 | [NAME] | Fuel Tank Safety | 2021-11-17 00:00:00 | 2023-11-17 00:00:00 |  |  |  | Overdue
 | [NAME] | Fuel Tank Safety | 2023-07-01 00:00:00 | 2025-07-01 00:00:00 |  |  |  | Due within the next week
 | [NAME] | Fuel Tank Safety | 2023-07-12 00:00:00 | 2025-07-12 00:00:00 |  |  |  | Required
 | [NAME] | Fuel Tank Safety | N/A | Not required |  |  |  | Not Required
 | [NAME] | Fuel Tank Safety | N/A | Not required
 | [NAME] | Fuel Tank Safety | N/A | Not required
 | [NAME] | Fuel Tank Safety | N/A | Not required
 | [NAME] | Fuel Tank Safety | N/A | Not required
 | [NAME] | Fuel Tank Safety | 2021-11-17 00:00:00 | Not required
 | Greg Love | Fuel Tank Safety | N/A | Not required
 | [NAME] | Fuel Tank Safety | N/A | Not required
 | [NAME] | Fuel Tank Safety | 2023-01-04 00:00:00 | 2025-01-04 00:00:00
 | [NAME] Parkinson | Fuel Tank Safety | 2023-06-01 00:00:00 | 2025-06-01 00:00:00
 | [NAME] | Fuel Tank Safety | N/A | Not required
 | [NAME] | Fuel Tank Safety | N/A | Not required
 | [NAME] | Fuel Tank Safety | 2021-11-16 00:00:00 | Not required
 | [NAME] | Fuel Tank Safety | N/A | Not required
 | [NAME] | Fuel Tank Safety |  | Not required
 | [NAME] | Fuel Tank Safety | 2023-04-18 00:00:00 | 2025-04-18 00:00:00
 | [NAME] | Fuel Tank Safety | 2021-11-16 00:00:00 | Not required
 | [NAME] | Fuel Tank Safety | 2023-05-26 00:00:00 | 2025-05-26 00:00:00
 | [NAME] | Fuel Tank Safety | N/A | Not required
 | [NAME] | Fuel Tank Safety | 2023-06-06 00:00:00 | 2025-06-06 00:00:00
 | [NAME] | Fuel Tank Safety | N/A | Not required
 | [NAME] | Fuel Tank Safety |  | 2025-08-03 00:00:00
 | [NAME] | Fuel Tank Safety | N/A | Not required
 | [NAME] | Fuel Tank Safety | 2022-02-17 00:00:00 | 2024-02-17 00:00:00
 | [NAME] | Fuel Tank Safety | N/A | Not required
Spreadsheet: phillip_m_love__30683__onsys forms 0003
Sheet: Calpine

Calpine
Contract: various | 2000-01-01 00:00:00
 | CPR estimate | Actual Payment | [NAME] | UA 4 RATE
[NAME] | 4540501
VALUE | 11827491.21
NET RATE |  |  |  | 2.54
Volume Variance:
 |  | =D8 (Volume Variance) * (B12-E12) CPR Price less UA 4 Rate
Rate Variance:
 |  | =(B8+D8) Actual [NAME] * (C12-B12) Actual Price less CPR Price
 | TOTAL IMPACT TO INCOME:
 |  | =Volume [NAME]
 |  | Check Figure = ((D10/D8) less E12 UA 4 Rate) * D8
CHECK FIGURE |  | ($1,526,969)/(446,480) LESS $1.947 (UA4 RATE) BY (446,480MMBTU)
Note:
How much  should be deferred?
There is a HL&P WACOG true up of $119,812 included in these numbers, this should be taken,
therefor the remaining variance is $64,477
Spreadsheet: 120525d1315350042-excel-2007-conditional-formatting-case-color-book1
Sheet: Sheet1

Case # | Color
A1 | red
A2 | blue
A2 | red
A3 | red
A3 | orange
A3 | green
A4 | red
A5 | blue
A6 | red
A6 | orange
A6 | green
A7 | green
Spreadsheet: 698570d1602057647-generic-formula-to-sort-multivalues-in-specific-order-sort-multiple-in-correct-order_new
Sheet: Sheet1

 |  |  |  |  |  |  |  | Expected
Specific | All |  | 4 | 1 | 3 | 2 |  | 4 | 1 | 3 | 2
red | blue§green§red§yellow |  |  |  |  |  |  | yellow | red | green | blue
yellow | yellow |  |  |  |  |  |  |  | yellow
green | red§blue§green |  |  |  |  |  |  |  | green | blue | red
blue | red§yellow |  |  |  |  |  |  |  | red |  | yellow
green
 | green |  |  |  |  |  |  |  | green
Spreadsheet: 66870d1267553102-sum-values-based-on-multiple-criteria-comma-delimited-in-a-single-cell-sample
Sheet: data

dept | code | balance
dep1 | [NAME] | 110
dep1 | C09 | 157
dep1 | [NAME] | 268
dep1 | [NAME] | 268
dep1 | [NAME] | 268
dep1 | C09 | 268
dep1 | C04 | 268
dep1 | C07 | 268
dep1 | [NAME] | 268
dep2 | C09 | 268
dep2 | AN30 | 18
dep2 | C04 | 47
dep2 | AN30 | 70
dep2 | AN30 | 70
dep2 | C04 | 115
dep2 | C04 | 47
dep2 | C07 | 190
dep2 | Z4 | 19
dep2 | Z47 | 66
Spreadsheet: 709618d1608453462-automatically-fill-in-common-info-based-on-keyword-match-book1
Sheet: Sheet1

Animal | Type | Weight | Fur? | Tail
Berkshire Pig
Persian Cat
[NAME] Pig
Maine Coon Cat
大猪
非洲河马
[NAME]
非洲河马
Spreadsheet: john_griffith__15750__10_16_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 59 | 325 | 400 | 41.7 | 51.4 | 1.73 | 2001-10-16 14:53:00
 | [NAME] | 60 | 675 | 775 | 41.8 | 48 | 1.69 | 2001-10-16 14:53:00
 | HU F2 | 61 | 880 | 925 | 41.3 | 43.5 | 1.63 | 2001-10-16 14:53:00
 | HU G2 | 62 | 1000 | 1100 | 38.3 | 42.2 | 1.57 | 2001-10-16 14:53:00
 | [NAME] | 63 | 1110 | 1210 | 37.3 | 40.7 | 1.54 | 2001-10-16 14:53:00
 | [NAME] | 68 | 1325 | 1450 | 37.6 | 41.2 | 1.68 | 2001-10-16 14:53:00
 | [NAME] | 70 | 1400 | 1550 | 35.5 | 39.4 | 1.65 | 2001-10-16 14:53:00
 | [NAME] | 69 | 1400 | 1600 | 33.4 | 38.2 | 1.55 | 2001-10-16 14:53:00
 | HU N2 |  |  |  | 34.7 | 38.1 | 1.58 | 2001-10-12 14:55:00
 | [NAME] |  |  |  | 28.9 | 34.2 | 1.39 | 2001-10-04 14:29:00
 | HU U2 |  |  |  |  |  | 0.05 | 2001-09-06 10:39:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | [NAME]
 | HU F3 |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]