tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 116734d1312086897-excel-2007-calculate-a-total-in-different-scenarios-calculation-of-different-scenarios
Sheet: Sheet1

Total Charge of Bill | Amt [NAME] paid | Amt Dik paid | Amt Dik owes [NAME] using original formula,                                                               (1-COUNTIF(B2:C2,A2/2)>=1)*(A2/2-C2) | What SHOULD be the answer? | Explanations | Does this formula tell me the correct answer?
100 | 0 | 0 |  | 0 | [NAME] pays 0%, Dik pays 0%.
100 | 0 | 50 |  | 0 | [NAME] pays 0%, Dik pays 50%.
100 | 0 | 100 |  | -50 | [NAME] pays 0%. Dik pays 100%.
100 | 50 | 0 |  | 0 | [NAME] pays 50%.  [NAME] pays 0%.
100 | 50 | 50 |  | 0 | [NAME] pays 50%.  [NAME] pays 50%.
100 | 50 | 100 |  | 0 | [NAME] pays 50%.  [NAME] pays 100%.
100 | 100 | 0 |  | 50 | [NAME] pays 100%.  [NAME] pays 0%.
100 | 100 | 50 |  | 0 | [NAME] pays 100%. Dik pays 50%.
100 | 100 | 100 |  | 0 | [NAME] pays 100%.  [NAME] pays 100%
100 | 0 | 40 |  | 0 | [NAME] pays 0%, [NAME] pays <50%.
100 | 0 | 60 |  | -10 | [NAME] pays 0%, [NAME] pays >50%.
100 | 40 | 0 |  | 0 | [NAME] pays < 50%, Dik pays 0%.
100 | 60 | 0 |  | 10 | [NAME] pays >50%, Dik pays 0%.
100 | 40 | 40 |  | 0 | [NAME] pays< 50%, [NAME] pays< 50%.
100 | 40 | 55 |  | -5 | [NAME] pays< 50%, [NAME] pays >50%.  [NAME] does NOT equal total bill
100 | 40 | 60 |  | -10 | [NAME] pays< 50%, [NAME] pays >50%.  [NAME] DOES equal total bill
100 | 55 | 40 |  | 5 | [NAME] pays >50%, [NAME] pays< 50%.  [NAME] does NOT equal total bill.
100 | 60 | 40 |  | 10 | [NAME] pays >50%, [NAME] pays< 50%.  [NAME] DOES equal total bill
100 | 60 | 60 |  | 0 | [NAME] pays >50%, [NAME] pays >50%.
Spreadsheet: 22767d1211930118-using-sumproduct-to-find-average-c
Sheet: 553

Identifier | Type | Start date | End date | Timeliness
value of vaccines | J | 2007-08-17 00:00:00 | 2007-08-28 00:00:00 | 11
natalizumab | J | 2007-08-23 00:00:00 | 2007-08-27 00:00:00 | 4
NICE decisions | mr | 2007-08-23 00:00:00 | 2007-08-23 00:00:00 | 0
HPV | mr | 2007-08-23 00:00:00 | 2007-08-24 00:00:00 | 1
NICE controversy | ab | 2007-08-27 00:00:00 | 2007-08-27 00:00:00 | 0
UTI guidelines | ab | 2007-08-27 00:00:00 | 2007-08-27 00:00:00 | 0
Spreadsheet: 477761d1472494989-using-vlook-up-formulas-is-there-a-way-to-pull-color-oeldere-477756d1472493829-using-vlook-up-formulas-is-there-a-way-to-pull-color-excel-test
Sheet: DEC 2016 - EXCEL TEST

1 | 2 | 3 | 4 | 5 | 6 | RECERT PACKET |  |  |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | RECERT DATE | PROJECT | UNIT | LAST NAME | FIRST NAME | 1ST NOTICE DATE SENT TO MGR | 2ND NOTICE DATE SENT TO MGR | 3RD NOTICE DATE SENT TO MGR | DATE RECEIVED FROM MGR RECEIVED | DATE SENT OUT 3RD PARTY VERS | DATE UPLOADED TO COMPLIANCE | CORRECTIONS  YES / NO | CORRECTIONS SENT TO COMPLIANCE | DALLAS / HARVEY UPLOADED TIC | MANAGER UPLOADED SIGNED TIC | DATE ORIGINAL [NAME] RECEIVED | DATE UPDATED IN PROCOREM | DATE FILE COMPLETE | COMMENTS
104 | 2016-12-01 00:00:00 | REHWIN2 | 104 | SMITH | CORDELL
302 | 2016-12-01 00:00:00 | REHWIN2 | 302 | JONES | LAURIE
402 | 2016-12-01 00:00:00 | REHWIN2 | 402 | GRANT | MARY
403 | 2016-12-01 00:00:00 | REHWIN2 | 403 | THOMAS | MARSHA
 | 2016-12-01 00:00:00
 | 2016-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-06-13 00:00:00
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 2Replace Costs-Results 11-15

Table 5.2.15.  Replacement Costs (Years 11 to 15)
 |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of Replacement Costs in Year:
Component | Unit Cost | Unit | Quantity | 11 | 12 | 13 | 14 | 15
 |  |  | Total Present Value of Replacement Costs (Years 11 to 15):
Spreadsheet: 525781d1498900319-help-needed-on-sorting-time-values-sample11
Sheet: Sheet1

 |  |  | Desired Result
2017-06-16 09:17:00
2017-06-16 13:24:00
2017-06-16 14:39:00
#[NAME]!
#[NAME]!
2017-06-16 15:30:00
#[NAME]!
2017-06-19 10:48:00
2017-06-19 14:06:00
#[NAME]!
#[NAME]!
#[NAME]!
2017-06-19 15:30:00
2017-06-20 12:49:00
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
2017-06-20 15:30:00
2017-06-21 12:25:00
2017-06-21 13:52:00
2017-06-21 15:06:00
#[NAME]!
#[NAME]!
2017-06-21 15:30:00
2017-06-22 10:47:00
2017-06-22 12:51:00
2017-06-22 14:18:00
#[NAME]!
#[NAME]!
2017-06-22 15:30:00
2017-06-23 12:31:00
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
2017-06-23 15:30:00
2017-06-27 09:54:00
2017-06-27 13:37:00
#[NAME]!
#[NAME]!
#[NAME]!
2017-06-27 15:30:00
2017-06-28 12:18:00
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
2017-06-28 15:30:00
2017-06-29 10:36:00
2017-06-29 14:31:00
#[NAME]!
#[NAME]!
#[NAME]!
2017-06-29 15:30:00
2017-06-30 10:56:00
2017-06-30 14:26:00
#[NAME]!
#[NAME]!
#[NAME]!
2017-06-30 15:30:00
Spreadsheet: 723084d1615502787-reconcile-bank-statement-forumla-reconcile-sample
Sheet: Sheet1

My Register |  |  |  |  |  |  |  | The Bank
Date | Transaction | Withdrawal | Deposit | Balance | [NAME] | Column2 |  | Date | Transaction | Withdrawal | Deposit | Balance
 | Starting Balance |  |  | 2000 |  |  |  |  | Starting Balance |  |  | 2000
2021-02-02 00:00:00 | Electric | 50.44 |  | 1949.56 | R |  |  | 2021-02-03 00:00:00 | Transaction - Electric Company | 50.44 |  | 1949.56
2021-02-15 00:00:00 | Cable | 49.99 |  | 1899.57 | R |  |  | 2021-02-18 00:00:00 | Joe's Cable, Inc | 49.99 |  | 1899.57
2021-02-25 00:00:00 | Car | 215.68 |  | 1683.89 |  |  |  | 2021-02-25 00:00:00 | Car Financer Co. | 215.68 |  | 1683.89
2021-02-26 00:00:00 | Rebate |  | 100.5 | 1784.39 | ? |  |  | 2021-02-26 00:00:00 | Deposit |  | 100.5 | 1784.39
2021-02-25 00:00:00 | Water Co. | 47.27 |  | 1737.12 | R |  |  | 2021-02-25 00:00:00 | City Water Company | 47.27 |  | 1737.12
2021-03-02 00:00:00 | Electric | 62.32 |  | 1674.8 | R |  |  | 2021-03-06 00:00:00 | Transaction - Electric Company | 62.32 |  | 1674.8
2021-03-10 00:00:00 | B-day gift |  | 50 | 1724.8 | ? |  |  | 2021-03-10 00:00:00 | Deposit |  | 50 | 1724.8
2021-03-15 00:00:00 | Cable | 49.99 |  | 1674.81 | R |  |  | 2021-03-20 00:00:00 | Joe's Cable, Inc | 49.99 |  | 1674.81
2021-03-25 00:00:00 | Water Co. | 63.89 |  | 1610.92 | R |  |  | 2021-03-25 00:00:00 | City Water Company | 63.89 |  | 1610.92
2021-03-25 00:00:00 | Car | 215.68 |  | 1395.24 | R |  |  | 2021-03-26 00:00:00 | Car Financer Co. | 215.68 |  | 1395.24
 |  |  |  |  |  |  |  | Dates may differ slightly from what was entered in My Register
What I would like is a formula that will: |  |  |  |  |  |  |  | Transaction may be different but will contain key words in both lists
- Match date, transaction, and amount, then return "R" in Column F if match or "?" if no match |  |  |  |  |  |  |  | The amount will match for the date, but could be different month to month
- Date (I guess month and year; unless can do within x days of the date in my register
Spreadsheet: holden_salisbury__12323__PrePay Accounting_1220
Sheet: Mead- Sat

Hour |  |  |  |  | Linked Data |  | Linked Data
Ending
Pacific | Mead physical | Saguaro | VEA | CAISO | WAPA Trans | psco | SRP | PAC | SRP | [NAME] | LDWP | To ISO | Balance
Standard | position | Purch | Purch | Whl | from Pin Pk/WW | Purch | PV/MD | Purch | Purch | SALE | Sale | ST [NAME] |  |  | Hour | Total | Total
(PST) |  |  |  | PV/MD | 78 MW |  |  | 110 |  |  |  |  |  |  | Ending | To PX | From PX
100 | -125 |  |  |  |  |  |  | 25 |  |  |  |  |  |  | 100 |  |  | -1
200 | -125 |  |  |  |  |  |  | 25 |  |  |  |  |  |  | 200 |  |  | -1
300 | -125 |  |  |  |  |  |  | 25 |  |  |  |  |  |  | 300 |  |  | -1
400 | -125 |  |  |  |  |  |  | 25 |  |  |  |  |  |  | 400 |  |  | -1
500 | -125 |  |  |  |  |  |  | 25 |  |  |  |  |  |  | 500 |  |  | -1
600 | -125 |  |  |  |  |  |  | 25 |  |  |  |  |  |  | 600 |  |  | -1
700 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 700 |  |  | -1
800 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 800 |  |  | -1
900 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 900 |  |  | -1
1000 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 |  |  | -1
1100 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1100 |  |  | -1
1200 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1200 |  |  | -1
1300 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1300 |  |  | -1
1400 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1400 |  |  | -1
1500 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1500 |  |  | -1
1600 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1600 |  |  | -1
1700 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1700 |  |  | -1
1800 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1800 |  |  | -1
1900 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900 |  |  | -1
2000 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000 |  |  | -1
2100 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2100 |  |  | -1
2200 | -75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2200 |  |  | -1
2300 | -125 |  |  |  |  |  |  | 25 |  |  |  |  |  |  | 2300 |  |  | -1
2400 | -125 |  |  |  |  |  |  | 25 |  |  |  |  |  |  | 2400 |  |  | -1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
Spreadsheet: 876484d1723177220-how-to-set-the-formula-in-column-j-to-show-the-company-name-excel-formula
Sheet: Courier Fee

Sterling Apparel Limited |  |  |  |  |  |  | Prepared by: | [NAME]
Balance as at 30 JUN 2024 | 2024-06-30 00:00:00 |  |  |  |  |  | Reviewed by: | ECHO
Posting Date | Invoice # | Sunpower | Northway | Mansway | Castco | Roadcoaster | Dimenia | TOTAL | Company
2024-01-31 00:00:00 | 900S02024010061 |  | 1382.07 |  |  |  |  |  | Northway
2024-01-31 00:00:00 | 900S02024010061 |  | 290.62 |  |  |  |  |  | Northway | How to set the formula in column J to show the company name?
2024-02-29 00:00:00 | MAY 20231229 |  |  |  |  | 70 |  |  | Roadcoaster
2024-02-29 00:00:00 | MAY 20231229 |  |  |  |  |  | 140 |  | Dimenia
2024-02-29 00:00:00 | MAY 20231229 |  |  |  |  | 70 |  |  | Roadcoaster
2024-02-29 00:00:00 | 8022-4AP 202401 |  |  |  |  |  | 1720
2024-01-31 00:00:00 | 8526469817IN |  |  |  |  |  | 9147
2024-02-29 00:00:00 | 9-451-79251 | 843.24
2024-02-29 00:00:00 | 9-451-79251 | 4484.71
2024-02-29 00:00:00 | 9-458-96536 |  |  |  | 184.86
2024-02-29 00:00:00 | 9-458-96536 |  |  | 658.94
2024-02-29 00:00:00 | 9-458-96536 |  |  | 274.76
2024-02-29 00:00:00 | 9-458-96536 |  |  |  | 661.5
2024-02-29 00:00:00 | 9-458-96536 |  |  | 437.27
Spreadsheet: 221142d1363378493-help-formula-to-sum-a-dynamic-range-dynamic-sum-formula-sample-sheet
Sheet: Sheet1

 | Sample Sheet
 | Date | Work Day | Budget | PY | Actual
 | 2013-02-25 00:00:00 | 1 | 395 | 322 | 305 |  | Period to Date Actuals:
 | 2013-02-26 00:00:00 | 2 | 395 | 274 | 291 |  | Period to Date Budget:
 | 2013-02-27 00:00:00 | 3 | 395 | 337 | 338 |  | Period to Date PY:
 | 2013-02-28 00:00:00 | 4 | 395 | 325 | 342
 | 2013-03-01 00:00:00 | 5 | 395 | 322 | 371
 | 2013-03-04 00:00:00 | 6 | 395 | 317 | 386
 | 2013-03-05 00:00:00 | 7 | 395 | 293 | 334
 | 2013-03-06 00:00:00 | 8 | 395 | 367 | 397
 | 2013-03-07 00:00:00 | 9 | 395 | 356 | 344
 | 2013-03-08 00:00:00 | 10 | 395 | 374 | 370
 | 2013-03-11 00:00:00 | 11 | 395 | 308 | 354
 | 2013-03-12 00:00:00 | 12 | 395 | 268 | 333
 | 2013-03-13 00:00:00 | 13 | 395 | 295 | 373
 | 2013-03-14 00:00:00 | 14 | 395 | 272 | 279
 | 2013-03-15 00:00:00 | 15 | 395 | 339
 | 2013-03-18 00:00:00 | 16 | 395 | 328
 | 2013-03-19 00:00:00 | 17 | 395 | 309
 | 2013-03-20 00:00:00 | 18 | 395 | 323
 | 2013-03-21 00:00:00 | 19 | 395 | 368
 | 2013-03-22 00:00:00 | 20 | 395 | 361
 | 2013-03-25 00:00:00 | 21 | 395 | 361
 | 2013-03-26 00:00:00 | 22 | 395 | 277
 | 2013-03-27 00:00:00 | 23 | 395 | 362
 | 2013-03-28 00:00:00 | 24 | 395 | 315
 | 2013-03-29 00:00:00 | 25 | 395 | 315
Spreadsheet: 152333d1335354870-excel-2007-matching-values-to-come-infront-book2
Sheet: Sheet1

 | S.n | Values |  | S.n | Result
 | 1 | 3 |  | 1
 | 2 | 5 |  | 2
 | 3 | 9 |  | 3 | 3
 | 4 | 12 |  | 4
 | 5 |  |  | 5 | 5
 | 6 |  |  | 6
 | 7 |  |  | 7
 | 8 |  |  | 8
 | 9 |  |  | 9 | 9
 | 10 |  |  | 10
Spreadsheet: 865055d1712147445-summing-data-between-dates-test-sample-data
Sheet: Sheet1

Asset# | Date/Time | Amount | Type |  | Date | 1 | 5 | 10 | 20 | 50 | 100 | [NAME] | Voucher
25339 | 2024-03-28 22:45:51 | 100 | [NAME] |  | 2024-03-29 00:00:00
25339 | 2024-03-28 22:57:41 | 50.17 | Voucher |  | 2024-03-30 00:00:00
25339 | 2024-03-29 06:48:01 | 10 | [NAME]
25339 | 2024-03-29 07:40:41 | 0 | [NAME]
25339 | 2024-03-29 12:37:04 | 100.01 | Voucher
25339 | 2024-03-29 12:40:06 | 100 | [NAME]
25339 | 2024-03-29 15:37:43 | 20 | [NAME]
25339 | 2024-03-29 16:43:01 | 50.01 | Voucher
25339 | 2024-03-29 21:29:00 | 50.49 | Voucher
25339 | 2024-03-29 21:32:26 | 1 | [NAME]
25339 | 2024-03-29 21:34:49 | 5 | [NAME]
25339 | 2024-03-30 07:36:52 | 0 | [NAME]
25339 | 2024-03-30 09:13:41 | 100 | [NAME]
25339 | 2024-03-30 09:49:58 | 30.52 | Voucher
Spreadsheet: 102570d1300484715-excel-2007-help-replacing-customer-names-from-template-or-using-macro-customers
Sheet: Sheet1

price_grou | stock_refe
[NAME] | 0237
BAD01 | 2002
BAD01 | 2305
BAD01 | 0219
BAD01 | 0266
BAD01 | 2664
BEA07 | 1620
BER01 | 0216
BER01 | 0237
BER01 | 0247
BER01 | 0219
BER01 | 2330
BER01 | 2308
BER01 | 2331
BER01 | 1626
BER01 | 2031
BER01 | 2037
BER01 | 2902
BER01 | 2664
BER01 | 0227
BER01 | 2305
BER01 | 1601
BER01 | 2615
BER01 | 2661
BER01 | 0245
BET02 | 2664
BLU011 | 0267
BLU011 | 0219
BLU03 | 0213
BRIT05 | 0213
BRIT05 | 0217
BRIT05 | 0233
BRIT05 | 1620
BRIT05 | 0257
BRIT05 | 1603
Spreadsheet: 484323d1476213696-how-to-track-this-by-hours-and-not-days-employee-attendance-orginal-_-as
Sheet: Employee Leave Tracker

 | Employee Name | Start Date | End Date | Type of Leave | Days | PTO hours | CME hours
 | [NAME] | 2016-10-07 00:00:00 | 2016-10-08 00:00:00 | PTO
 | Sean | 2016-01-17 00:00:00 | 2016-01-18 00:00:00 | CME
 | [NAME] | 2016-10-20 00:00:00 | 2016-10-25 00:00:00 | CME
 | [NAME] | 2016-07-01 00:00:00 | 2016-07-15 00:00:00 | PTO
 | Sean | 2016-12-25 00:00:00 | 2016-12-26 00:00:00 | CME
 | [NAME] | 2017-03-02 00:00:00
 | Sean |  | 2017-04-01 00:00:00 | PTO
Spreadsheet: 870059d1716563208-currency-mutiplied-by-the-exhange-rate-of-the-period-excel-forum-exchange-rates
Sheet: Windknife

Date | Total price in Eur | Converted price in USD
2024-01-06 00:00:00 | 36887.73234200743 |  | should not give a price, since no exchange rate available for 06-01
2024-02-08 00:00:00 | 40000 |  | it doesn't write "update exchange rate"
2024-03-05 00:00:00 | 46000
2024-04-10 00:00:00 | 12000
 | Exchange rate
 | 2024-01-05 00:00:00 | 1.0876
 | 2024-02-08 00:00:00
 | 2024-01-11 00:00:00 | 1.09123
 | 2024-02-03 00:00:00 | 1.0653
 | 2024-03-05 00:00:00 | 1000
Spreadsheet: louise_kitchen__23088__EastPower1
Sheet: 2's

2's = 24
[NAME], [NAME]
Lenartowich, [NAME]
Baughman, [NAME]
Tricoli, [NAME]
Luong, [NAME]
Tapscott, [NAME]
Dypiangco, [NAME]
Booth, [NAME]
Ward, [NAME]
Hill, [NAME]
Ahmed, Naveed
Kroll, Heather
Grace, [NAME]
Irani, [NAME]
[NAME], [NAME]
Trefz, Greg
Munoz, Victor
Forster, [NAME]
Pan, Liqun
Simoes, Catherine
Mitro, Fred
[NAME], Greg
Jafny, [NAME]
Hiemstra, Nick
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 1

 | February 14 | February 21 | February 28 | March 7 | March 14
Total Interest Rate* | 332814299.7 | 342084284.68 | 344278823.61 | 348892073.9
Cleared** | 205545726.24 | 209359961.55 | 212880645.89 | 214856842.7 | 215884777.28
Uncleared | 127268573.46 | 132724323.13 | 131398177.72 | 134035231.2 | 134154416.76
Total Cross-Currency | 15513373.799 | 16269924 | 16265064.916 | 16356173
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 15513373.799 | 16269924 | 16265064.916 | 16356173 | 16327140.529
Total Credit | 7438917.4818 | 7916085 | 8521129.9751 | 8675552
Cleared | 2172652.9058 | 2241658 | 2291901.8633 | 2305484 | 2471130.9821
Uncleared | 5266264.576 | 5674427 | 6229228.1118 | 6370068 | 6152597.0664
Total FX**** | 31450000 | 31450000 | 31450000 | 31450000 | 31450000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity**** | 4420000 | 4420000 | 4420000 | 4420000 | 4420000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity**** | 1700000 | 1700000 | 1700000 | 1700000 | 1700000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 393336590.9808 | 403840293.68 | 406635018.5011 | 411493798.9
Weekly snapshot, gross notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types. For cleared swaps, this table reflects only one of the two swaps that results from the clearing process; therefore, the numbers on this table are analogous to the notional value of futures open interest.
*See Data Dictionary for asset class descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
****These numbers are estimates.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: michelle_lokay__26692__Cal Throughput
Sheet: CERA

Flows Into California
Source:  CERA, EIA, CEC, TW actuals
Month | TW |  |  |  | El Paso |  |  |  | PGT |  |  |  | Kern River |  |  | Total
2001-10-01 00:00:00 | 945 | 1090 |  |  |  |  |  |  | 1703 | 1833 |  |  | 740 | 700
Sept | 941 | 1090 |  |  |  |  |  |  | 1712 | 1833 |  |  | 705 | 700
Aug | 1074 | 1090 |  |  |  |  |  |  | 1726 | 1833 |  |  | 635 | 700
July | 1057 | 1090 |  |  |  |  |  |  | 1756 | 1833 |  |  | 658 | 700
June | 1016 | 1090 |  |  |  |  |  |  | 1764 | 1833 |  |  | 540 | 700
May | 950 | 1090 |  |  |  |  |  |  | 1719 | 1833 |  |  | 567 | 700
April | 932 | 1090 |  |  |  |  |  |  | 1829 | 1833 |  |  | 592 | 700
March | 1110 | 1090 |  |  |  |  |  |  | 1819 | 1833 |  |  | 559 | 700
Feb | 1119 | 1090 |  |  |  |  |  |  | 1764 | 1833 |  |  | 520 | 700
2001-01-01 00:00:00 | 1109 | 1090 |  |  |  |  |  |  | 1758 | 1833 |  |  | 524 | 700
2000-12-01 00:00:00 | 1105 | 1090 |  |  |  |  |  |  | 1735 | 1833 |  |  | 520 | 700
Nov | 963 | 1090 |  |  |  |  |  |  | 1663 | 1833 |  |  | 570 | 700
Oct | 1053 | 1090 |  |  |  |  |  |  | 1800 | 1833 |  |  | 555 | 700
Sept | 1063 | 1090 |  |  |  |  |  |  | 1828 | 1833 |  |  | 542 | 700
Aug | 1036 | 1090 |  |  |  |  |  |  | 1852 | 1833 |  |  | 498 | 700
July | 985 | 1090 |  |  |  |  |  |  | 1858 | 1833 |  |  | 549 | 700
June | 944 | 1090 |  |  |  |  |  |  | 1864 | 1833 |  |  | 568 | 700
May | 829 | 1090 |  |  |  |  |  |  | 1857 | 1833 |  |  | 597 | 700
April | 729 | 950 |  |  |  |  |  |  | 1772 | 1833 |  |  | 615 | 700
March | 905 | 950 |  |  |  |  |  |  | 1793 | 1833 |  |  | 633 | 700
Feb | 857 | 950 |  |  |  |  |  |  | 1744 | 1833 |  |  | 649 | 700
2000-01-01 00:00:00 | 869 | 950 |  |  |  |  |  |  | 1687 | 1833 |  |  | 586 | 700
1999-12-01 00:00:00 | 945 | 950 |  |  |  |  |  |  | 1737 | 1833 |  |  | 573 | 700
Nov | 1040 | 950 |  |  |  |  |  |  | 1753 | 1833 |  |  | 571 | 700
Oct | 850 | 950 |  |  |  |  |  |  | 1846 | 1833 |  |  | 630 | 700
Sept | 795 | 950 |  |  |  |  |  |  | 1858 | 1833 |  |  | 579 | 700
Aug | 732 | 950 |  |  |  |  |  |  | 1794 | 1833 |  |  | 603 | 700
July | 831 | 950 |  |  |  |  |  |  | 1723 | 1833 |  |  | 593 | 700
June | 745 | 950 |  |  |  |  |  |  | 1693 | 1833 |  |  | 597 | 700
May | 754 | 950 |  |  |  |  |  |  | 1706 | 1833 |  |  | 671 | 700
April | 762 | 950 |  |  |  |  |  |  | 1724 | 1833 |  |  | 641 | 700
March | 809 | 950 |  |  |  |  |  |  | 1555 | 1833 |  |  | 638 | 700
Feb | 954 | 950 |  |  |  |  |  |  | 1569 | 1833 |  |  | 652 | 700
1999-01-01 00:00:00 | 901 | 950 |  |  |  |  |  |  | 1560 | 1833 |  |  | 634 | 700
Spreadsheet: theresa_staab__39598__Producer Pricing Detail Nov01
Sheet: North Finn Detail

[NAME] | Contact: | [NAME] |  |  | Enron North America
 | PH: | (307) 237-7854
 | FAX: |  |  |  | [NAME] | [PHONE]
First of Month Nomination: | 0
Additional Purchases: | 704 | MMBtu
Btu factor
Transportation | 0.485 | per Mcf
IF CIG Rockies
 |  | Index Discount/Premium | Crestone Transport/MMBtu | Total Receipts Fee Adjustment* | Total Net Back
Net Backs: | CIG GD Rockies | -0.08
 |  |  | CIG GD Rockies Volume MMBtu |  | Allocated Fuel MMBtu | Total Production MMBtu | $ CIG GD Rockies | Total Payment
 | CIG GD Rockies | CIG GD Rockies less Netback
 |  |  |  |  |  | avg. $/MMBtu
*Total Receipts Fee Adjustment is calculated by applying the Field Services Fee to the fuel volume and then dividing that dollar amount(fee times fuel volume) by the volume purchased.
Spreadsheet: 04ee76f2-efdb-4fc8-a540-8bde2dc353f7
Sheet: 4.2(MS) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(MS): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2010-11
 | Major Group | MS - Master's
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2010 (October 15, 2010)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | 9 | 21 | 0 | 2
 |  | Part Time | 4 | 7 | 1 | 0
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students graduating with degrees who earned a GPA of 3.0 or above, and the number who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured employment after graduation.
 |  |  |  |  | July 1, 2010- June 30, 2011
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
Diploma |  |  | na | na | na | na
Certificate |  |  | na | na | na | na
Associate Degree |  |  | na | na | na | na
 | Assoc. graduates admitted to four-year program |  | na | na | na | na
 | [NAME]. graduated with a GPA of 3.0 or above |  | na | na | na | na
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
 | [NAME]. graduated with a GPA of 3.0 or above |  | na | na | na | na
Master's Degree |  |  | 0 | 3 | 0 | 0
Employed after graduation |  |  | m | m | m | m
Notes:
m = not tracked;
Spreadsheet: 26d93474-ecdc-4712-88d0-285a604a742f
Sheet: Sheet1

Supplementary Table 1: HOb panel information | Unnamed: 1 | Unnamed: 2
Sample | Sex | Year or birth
506 | Male | 1981
507 | Male | 1949
508 | Male | 1946
509 | Female | 1938
511 | Male | 1955
513 | Male | 1946
514 | Male | 1942
515 | Female | 1964
517 | Female | 1968
518 | Female | 1943
519 | Male | 1982
521 | Female | 1948
523 | Male | 1924
524 | Female | 1931
525 | Male | 1948
526 | Male | 1925
528 | Male | 1950
529 | Female | 1917
531 | Male | 1954
536 | Male | 1936
543 | Female | 1953
546 | Male | 1931
548 | Male | 1931
550 | Male | 1938
551 | Female | 1931
553 | Female | 1915
554 | Female | 1948
555 | Female | 1922
557 | Female | 1936
565 | Male | 1913
566 | Male | 1942
567 | Male | 1930
570 | Female | 1936
572 | Male | 1932
573 | Female | 1933
575 | Female | 1959
576 | Female | 1934
577 | Male | 1940
578 | Male | 1937
580 | Female | 1953
581 | Female | 1920
582 | Female | 1951
583 | Female | 1918
585 | Female | 1950
586 | Male | 1927
589 | Male | 1955
590 | Female | 1945
591 | Female | 1943
592 | Male | 1941
593 | Male | 1926
594 | Female | 1945
595 | Male | 1936
596 | Male
597 | Male | 1924
598 | Female | 1926
599 | Female | 1948
600 | Female | 1951
601 | Male | 1914
Spreadsheet: 65478d1266197980-lookup-sample
Sheet: Sheet1

 | PERI-PREP WIPES [SALT] 840001 | 5012917021912
 | PERINAL SPRAY | 5012616174407
 | PERATIVE [READY TO HANG] | 5012616174803
 | PERDIX TAB 7.5MG | 5012616175008
 | PERDIX [NAME] 15MG | 5012616175206
 | PERFECTIL SKIN HAIR & NAILS CAP | 5012616111365
 | PERCUTOL OINTMENT 2% | 5012616175602
 | PERIACTIN TAB 4MG | 5015552000021
 | [NAME] CAP 200MG | 5015552000045
 | PERSONA TEST STICKS | 5014648428732
 | PERSONA STARTER PACK | 5014648427322
 | PERFECTION COL ENDURE MASCARA BROWN | 5014648424192
 | PERFECTION COL ENDURE MASCARA BLACK | 5013965051920
 | PERSIL PERFORMANCE LOW SUDS STD * | 5013965041327
 | PERSIL AUTO LIQUID CONC.BIO | 3360373001767
 | PERDIX [NAME] 15MG | 5012616175206
Spreadsheet: 861965d1709776638-simplify-formula-if-find-a-string-in-row-for-a-specific-value-search-tbd-for-id
Sheet: Sheet1

ID | "TBD" Found ? | Just one cell
77855000
78835700 |  | No
65239089 |  | Yes
ID | Color 1 | Color 2 | Color 3 | Color 4 | Color 5
77855000 |  | TBD | Green |  | Black
78835700 |  | Red
65239087 |  |  | Yellow | TBD
65239088 |  |  | Yellow
65239089 |  |  | Yellow | TBD