tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 848329d1699041505-conditional-format-isformula-istext-excelforum_conditional
Sheet: Calendar 1

 | MATRIX |  |  |  |  |  |  |  |  |  |  | CONDITIONAL IN COLUM N
 | ↓ |  |  | ↓ |  |  | ↓ |  |  | 2023-10-04 00:00:00
 | Unit | Position | Shift | Staff | 2023-10-01 00:00:00 | 2023-10-02 00:00:00 | 2023-10-03 00:00:00 | 2023-10-04 00:00:00 | 2023-10-31 00:00:00 | Oct |  | Day: | 2023-10-03 00:00:00
 | 2C | POSIT.1 | M | Employee 01 | 2C |  |  | 2C |  |  |  |  | ↓
 | 3P | Position1 | E | Employee 02 |  | 3P | 3P |  |  |  |  | 2C |  |  | [NAME] It shouldn't be TRUE because there is a formula in but not text
 | 4C | Position1 | N | Employee 03 | 4C |  | 4C | 4C
 | 2C | Position1 | M | Employee 04 | 2C | 2C
 | 3P | Position1 | E | Employee 05 |  | 3P |  |  |  |  |  |  | ↑
 | 4C | Position1 | N | Employee 06 | 4C |  | 4C |  |  |  |  | If O5 < 1, [NAME] should be colored in yellow
 | FLO | Position1 | M | Employee 07 | FLO |  | FLO | FLO
 | 3P | Position1 | E | Employee 08 | HOL | HOL | 3P
 | 4C | Position1 | N | Employee 09 | VAC | VAC | VAC | VAC | VAC
 | 2C | Position1 | M | Employee 10 | 2C | SICK | SICK | SICK
 | FLO | Position1 | M | Employee 11 | FLO |  | FLO |  | FLO
 | 3P | Position1 | M | Employee 12 | 3P |  | 3P
 | 2C | Position1 | M | Employee 13 |  | 2C
 | 3P | Position1 | M | Employee 14 | 3P |  | 3P
 | 2C | Position1 | M | Employee 15 | 2C | 2C
 | FLO | Position1 | M | Employee 16 | FLO |  | FLO |  | FLO
 | 2C | Position1 | M | Employee 17 |  | 2C
 | 3P | Position1 | M | Employee 18 | VAC | VAC | VAC | VAC | VAC
 | 3P | Position1 | M | Employee 19 | VAC | VAC | VAC | VAC | VAC
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 8d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 29070 | 4741 | 31682 | 2671
OTHER* | 5716 | 3134 | 442 | 1250
TOTAL
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, FRA,  Inflation, OIS, and Swaption.
Spreadsheet: phillip_m_love__30139__200006_OA
Sheet: EAST-LRC-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  LRC
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | 3331023 |  | -3331023
 |  | TOTAL
Spreadsheet: 474281d1470704800-how-are-the-formulas-connected-in-excel-spreadsheet-calculator
Sheet: Simulator

 | CCT,Ra | 9 | 1 | 2 |  | 1050 |  |  | Tc (C) |  | 50
 | Product code |  |  |  |  |  |  |  |  |  |  | Tj (C)
 | Code
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 11a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis | 810 |  | 810
 | FRA | 10428 |  | 10428
 | Exotic
 | Inflation
 | IRS- [NAME] | 35302 |  | 35302
 | OIS | 1650 |  | 1650
 | VNS | <100 |  | <100
 | Zero Coupon | 192 |  | 192
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | 48382 | N/A*** | 48382
Estimated swap transaction volumes, week ending October 25, by product type and tenor (number of trades), all participant types and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 745143d1629776279-conditional-format-highlight-delivery-dates-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 2021-08-01 00:00:00 |  | 2021-09-01 00:00:00 |  | 2021-10-01 00:00:00
Stock Code | Name | SOH | Forecast | Demand | Usage MTD | 3mth Ave. | mth LY 3 months | Supply Months | Date Cover | Delivery |  | Delivery |  | Delivery
GP001B | A1000 | 16.384 | 11.485 |  | 12.102 | 13.138 | 14.843 | 1.2 | 2021-09-05 00:00:00 | 21.6 | 2021-08-30 00:00:00 | 21.6 | 2021-09-18 00:00:00 | 21.6 | 2021-10-30 00:00:00
GP001C | [NAME] | 3.855 | 2.61 |  | 3.475 | 3.666 | 2.838 | 1.1 | 2021-09-24 00:00:00 |  |  | 5 | 2021-09-06 00:00:00
GP001D | [NAME] | 0.02 | 0.088 |  | 0.12 | 0.153 | 0.093 | 0.1 | 2021-08-27 00:00:00 | 1.6 | 2021-08-23 00:00:00
Spreadsheet: 10fcb32d-aa01-471f-bce9-eaacccbae007
Sheet: Sheet1

Income- Reimbursement and Additional Income generated in the Food Service Department | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Reimbuset/Poten Income |  |  |  |  |  |  |  |  | District Total
Lowest % Incr Reimb
Breakfast
Paid |  |  |  |  |  |  |  |  | 0
Free |  |  |  |  |  |  |  |  | 0
Reduce |  |  |  |  |  |  |  |  | 0
Lunch |  |  |  |  |  |  |  |  | 0
Paid |  |  |  |  |  |  |  |  | 0
Free |  |  |  |  |  |  |  |  | 0
Reduce |  |  |  |  |  |  |  |  | 0
Other Income |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  | 0
FS Vending |  |  |  |  |  |  |  |  | 0
Catering |  |  |  |  |  |  |  |  | 0
Special Events |  |  |  |  |  |  |  |  | 0
After School Snacks |  |  |  |  |  |  |  |  | 0
Fund Raising Events |  |  |  |  |  |  |  |  | 0
General Fund |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
School Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: eaa37b3b-34e8-4028-a3a0-5870eb3636c6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Home Sales
 |  | New Single-family [NAME]: United States
 |  | Not Seasonally Adjusted All Houses [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: August 22, 2014 (9:59 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008 | 44 | 48 | 49 | 49 | 49 | 45 | 43 | 38 | 35 | 32 | 27 | 26
2009 | 24 | 29 | 31 | 32 | 34 | 37 | 38 | 36 | 30 | 33 | 26 | 24
2010 | 24 | 27 | 36 | 41 | 26 | 28 | 26 | 23 | 25 | 23 | 20 | 23
2011 | 21 | 22 | 28 | 30 | 28 | 28 | 27 | 25 | 24 | 25 | 23 | 24
2012 | 23 | 30 | 34 | 34 | 35 | 34 | 33 | 31 | 30 | 29 | 28 | 28
Spreadsheet: 661714d1581208126-combine-two-lists-into-new-list-temp_worksheet
Sheet: Sheet1

List1 | List2 | Desired Result Using Formula | Also Desired Result (No Duplicates) | Combined
Apple | Mango | Apple | Apple
Orange | Apple | Orange | Orange
Pear | Nectarine | Pear | Pear
Apple | [NAME] | Apple | [NAME]
[NAME] |  | [NAME] | Mango
 |  | Mango | Nectarine
 |  | Nectarine
Spreadsheet: 689594d1596543350-how-to-apply-date-range-to-if-formula-test
Sheet: 04.2 - Go-Live Baseline

 | Project | Baseline
 | Project A-01 | 2020-07-01 00:00:00
 | Project A-02 | 2020-11-01 00:00:00
 | Project A-03 | 2021-01-01 00:00:00
 | Project A-04 | 2020-03-01 00:00:00
 | Project A-05 | 2020-03-01 00:00:00
 | Project A-06 | 2020-05-01 00:00:00
 | Project A-07 | 2020-08-01 00:00:00
 | Project A-08 | 2020-05-01 00:00:00
 | [NAME] | 2020-07-01 00:00:00
 | Project B-02 | 2020-09-01 00:00:00
 | Project B-03 | 2020-06-01 00:00:00
 | Project B-04 | 2020-06-01 00:00:00
 | Project B-05 | 2020-05-01 00:00:00
 | Project B-06 | 2020-01-01 00:00:00
 | Project B-07 | 2020-04-01 00:00:00
 | Project B-08 | 2020-09-01 00:00:00
 | Project C-01 | 2020-03-01 00:00:00
 | Project C-02 | 2020-05-01 00:00:00
 | Project C-03 | 2020-04-01 00:00:00
 | Project C-04 | 2020-06-01 00:00:00
 | Project C-05 | 2020-06-01 00:00:00
 | Project C-06 | 2021-03-01 00:00:00
Spreadsheet: 701164d1603574355-how-to-count-the-quantity-per-piece-and-box-quantity
Sheet: Sale

 | Orders | Product Name | Qty | Price Select | Sale Price | Total Price
 | 1 | Product 1 | 1 | WHOLE
 | 2 | Product 2 | 3 | PIECE
 | 3 | Product 3 | 5 | PIECE
 | 4 | Product 3 | 4 | WHOLE
 | 5 | Product 2 | 3 | WHOLE
 | 6 | Product 1 | 8 | PIECE
 | 7 | Product 4 | 5 | WHOLE
 | 8 | Product 2 | 2 | PIECE
Spreadsheet: 128399d1320941783-countif-drainage-material-call-off-b
Sheet: Order Form

 | Pipes | Rockers | Socket | Spigot |  | Manhole Rings | 1000mm | 750mm | 500mm
 | 0.15 | 0 | 0 | 0 |  | 900 |  |  |  | How can I get the formula in here to look at
 | 0.225 | 0 | 0 | 0 |  | 1050 |  |  |  | the Manhole tab
 | 0.3 | 0 | 0 | 0 |  | 1200 | 2 | 3 | 1 | and counts the number of 1000mm, 750mm & 500mm rings for each type?
 | 0.375 | 0 | 0 | 0 |  | 1350 |  |  |  | on this sheet the answer should be what I have wrote next to the ring sizes
 | 0.45 | 42 | 21 | 21 |  | 1500 | 2 | 4
 | 0.525 | 0 | 0 | 0 |  | 1800 | 1 | 1
 | 0.6 | 0 | 0 | 0 |  | 2100
 | 0.675 | 0 | 0 | 0 |  | 2400
 | 0.75 | 0 | 0 | 0 |  | 2700
 | 0.825 | 0 | 0 | 0 |  | 3000
 | 0.9 | 0 | 0 | 0
 | 1.05 | 0 | 0 | 0
 | 1.2 | 0 | 0 | 0
 | 1.5 | 0 | 0 | 0
 | 1.6 | 0 | 0 | 0
 | 1.8 | 0 | 0 | 0
Spreadsheet: 688949d1596032530-solver-function-too-slow-when-trying-to-find-a-sum-that-satisfies-multiple-constraints-solver-3-factor-test-3_mod
Sheet: Sheet1

 |  | Control Factor 1 |  | 6296 |  | Control Factor 2 |  | 267 |  | Control Factor 3 |  | 111
 |  | Sum factor 1 |  |  |  | Sum factor 2 |  |  |  | Sum Factor 3
 |  | Difference
 | Position | Factor list 1 |  |  |  | Factor list 2 |  |  |  | Factor list 3
 | 1 | 711 | 0 |  |  | 2 |  |  |  | 7
 |  | 197 | 1 |  |  | 32 |  |  |  | 12
 |  | 79 | 1 |  |  | 37 |  |  |  | 9
 |  | 578 | 0 |  |  | 44 |  |  |  | 10
 |  | 603 | 1 |  |  | 41 |  |  |  | 20
 |  | 976 | 0 |  |  | 45 |  |  |  | 4
 |  | 399 | 0 |  |  | 42 |  |  |  | 4
 |  | 280 | 0 |  |  | 28 |  |  |  | 4
 |  | 235 | 0 |  |  | 10 |  |  |  | 19
 |  | 904 | 0 |  |  | 29 |  |  |  | 19
 |  | 769 | 0 |  |  | 17 |  |  |  | 14
 |  | 860 | 1 |  |  | 2 |  |  |  | 20
 |  | 548 | 0 |  |  | 44 |  |  |  | 1
 |  | 218 | 0 |  |  | 3 |  |  |  | 14
 |  | 992 | 0 |  |  | 36 |  |  |  | 13
 |  | 927 | 1 |  |  | 4 |  |  |  | 9
 |  | 613 | 0 |  |  | 42 |  |  |  | 15
 |  | 568 | 0 |  |  | 47 |  |  |  | 15
 |  | 504 | 1 |  |  | 32 |  |  |  | 1
 |  | 332 | 0 |  |  | 50 |  |  |  | 3
 |  | 276 | 0 |  |  | 40 |  |  |  | 5
 |  | 153 | 1 |  |  | 36 |  |  |  | 6
 |  | 752 | 1 |  |  | 16 |  |  |  | 4
 |  | 907 | 0 |  |  | 29 |  |  |  | 2
 |  | 678 | 1 |  |  | 4 |  |  |  | 17
 |  | 710 | 1 |  |  | 21 |  |  |  | 1
 |  | 153 | 0 |  |  | 23 |  |  |  | 8
 |  | 842 | 0 |  |  | 29 |  |  |  | 8
 |  | 833 | 1 |  |  | 42 |  |  |  | 12
 |  | 58 | 0 |  |  | 14 |  |  |  | 14
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 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: 829131d1683948635-help-with-daily-schedule-with-auto-days-off-example-tennfox-
Sheet: Thursday

 | Primary | Trainee |  |  |  |  | Off
211
212
213
214
314
315
316
Spreadsheet: 740082d1626178826-need-a-formula-to-match-and-pull-data-from-a-separate-sheet-referencematching
Sheet: End Goal

Owner | Car | Owner ID
[NAME] | Mazda 6 | 123
[NAME] | Buick | 123
[NAME] | Mazda CX5 | 123
[NAME] | Honda | 12344
[NAME] | Honda | 12344
[NAME] | BMW | 12344
[NAME] | Subaru | 9566
Jake | Mercedes | 8611
Jake | Mercedes | 8611
Jake | Fiat | 8611
[NAME] | Acura | 5445
[NAME] | Acura | 5445
[NAME] | Acura | 5445
Joel | BMW | 7854
Joel | BMW | 7854
Joel | BMW | 7854
Joel | Mercedes | 7854
Spreadsheet: 93249d1292863815-pivot-table-layout-match-calander
Sheet: Schedule

 | Column Labels
Row Labels | Park A | Park B | Park C | Park D | Park E | [NAME]
2010-12-04 00:00:00
2010-12-04 00:00:00
1st Half |  |  |  |  |  |  |  |  | A1 Vs. A2
A
2nd Half
B
2010-12-05 00:00:00
2010-12-05 00:00:00
2010-12-11 00:00:00
2010-12-11 00:00:00
2010-12-12 00:00:00
2010-12-12 00:00:00
1st Half
B
2nd Half
B
2010-12-18 00:00:00
2010-12-18 00:00:00
1st Half
A
2nd Half
B
2010-12-19 00:00:00
2010-12-19 00:00:00
1st Half
A
2nd Half
B
2010-12-25 00:00:00
2010-12-25 00:00:00
1st Half
A
2nd Half
A
2010-12-26 00:00:00
2010-12-26 00:00:00
1st Half
B
2nd Half
B
2011-01-01 00:00:00
2011-01-01 00:00:00
1st Half
B
2nd Half
A
2011-01-02 00:00:00
2011-01-02 00:00:00
1st Half
A
2nd Half
B
2011-01-08 00:00:00
2011-01-08 00:00:00
2nd Half
A
2011-01-09 00:00:00
2011-01-09 00:00:00
1st Half
B
2nd Half
B
2011-01-15 00:00:00
2011-01-15 00:00:00
1st Half
A
2nd Half
B
2011-01-16 00:00:00
2011-01-16 00:00:00
2nd Half
A
B
2011-01-22 00:00:00
2011-01-22 00:00:00
1st Half
A
B
2nd Half
A
B
2011-01-23 00:00:00
2011-01-23 00:00:00
1st Half
A
B
2nd Half
B
2011-01-29 00:00:00
2011-01-29 00:00:00
1st Half
A
2nd Half
A
2011-01-30 00:00:00
2011-01-30 00:00:00
1st Half
B
2011-02-05 00:00:00
2011-02-05 00:00:00
1st Half
B
2nd Half
A
B
2011-02-06 00:00:00
2011-02-06 00:00:00
1st Half
A
2nd Half
A
B
2011-02-12 00:00:00
2011-02-12 00:00:00
1st Half
A
B
2nd Half
A
2011-02-13 00:00:00
2011-02-13 00:00:00
1st Half
B
2nd Half
A
B
2111-01-08 00:00:00
2111-01-08 00:00:00
1st Half
A
Spreadsheet: 727560d1617964136-help-with-a-dynamic-filtering-table-book1
Sheet: Sheet2

List 1 | List 2 | List 3 | List 4 | List 5
Spreadsheet: 775218d1648911262-business-mileage-tiered-rate-mileage
Sheet: Sheet1

WEEK | AMOUNT OF MILES THAT WEEK
1 | 65
2 | 123
3 | 188
4 | 138
5 | 197
6 | 86
7 | 51
8 | 130
9 | 179
10 | 50
11 | 141
12 | 139
13 | 197
14 | 165
15 | 176
16 | 152
17 | 52
18 | 112
19 | 184
20 | 155
21 | 173
22 | 174
23 | 161
24 | 102
25 | 168
26 | 190
27 | 90
28 | 94
29 | 171
30 | 138
31 | 153
32 | 88
33 | 111
34 | 102
35 | 84
36 | 78
37 | 88
38 | 86
39 | 62
40 | 165
41 | 77
42 | 195
43 | 125
44 | 64
45 | 169
46 | 156
47 | 121
48 | 74
49 | 159
50 | 105
51 | 162
52 | 161
53 | 144
54 | 191
55 | 124
56 | 63
57 | 60
58 | 100
59 | 95
60 | 102
61 | 111
62 | 73
63 | 141
64 | 189
65 | 85
66 | 54
67 | 91
68 | 140
69 | 77
70 | 119
71 | 126
72 | 81
73 | 66
74 | 158
75 | 126
76 | 175
77 | 70
78 | 188
79 | 50
80 | 117
81 | 186
82 | 70
83 | 165
84 | 164
85 | 102
86 | 93
87 | 158
88 | 155
89 | 85
90 | 106
91 | 63
92 | 65
93 | 69
94 | 181
95 | 95
96 | 159
97 | 168
98 | 140
99 | 120
100 | 167
101 | 160
102 | 160
103 | 171
104 | 132
105 | 186
106 | 95
Spreadsheet: 455914d1460562664-create-a-four-column-sorting-table-that-updates-based-on-calculations-response-16-xxx-u54-tracker-schema_safe
Sheet: Tracker

[NAME] |  |  |  |  |  | Participant Referral |  |  | Screening Questions |  |  | Most Recent Appointment |  |  | Next Scheduled Appointment |  |  |  | Interview Process |  |  |  | Follow-Up Checklist
Code | 4-Digit Code | Treatment Code | Gender ID | Referring Site | [NAME] | Date of Contact | Date Confirmed with Site | Verbal [NAME]? | Fluent English speaker? | Treated for HSIL? | Health? | Last  Date | Eligibility Status (Post-Appt) | Date READY if PENDING | Next  Date? | Eligibility Status (Pre-Appt) | Date READY if PENDING | Notified of eligibility? | 1st Assessment Date | Confirmed 1st Assessment? | 2nd Assessment Date | Confirmed 2nd Assessment? | Demographics Obtained? | Payment Sent  (Date Mailed) | Comments
5001AL |  |  | CisMale |  |  | 2016-02-26 00:00:00 | 2016-02-26 00:00:00 | 2016-02-26 00:00:00 |  |  |  | 2015-12-26 00:00:00 |  |  | 2016-05-05 00:00:00 |  |  | 2016-02-25 00:00:00 | 2016-02-26 00:00:00 | 2016-02-25 00:00:00 |  | 2016-03-03 00:00:00 |  | 2016-03-06 00:00:00 | none |  | [NAME] for sites >>>
5002TL |  |  | CisMale |  |  | 2016-04-01 00:00:00 | 2016-04-02 00:00:00 | 2016-04-02 00:00:00 |  |  |  | 2016-03-06 00:00:00 |  |  | 2016-06-06 00:00:00 |  |  | 2016-04-04 00:00:00 | 2016-04-10 00:00:00 | 2016-04-09 00:00:00
5003TH |  |  | CisFemale |  |  | 2016-04-06 00:00:00 | 2016-04-06 00:00:00 | 2016-04-06 00:00:00 |  |  |  | 2016-03-09 00:00:00 |  |  | 2016-04-20 00:00:00 |  |  | 2016-05-21 00:00:00 | 2016-05-22 00:00:00
5004SH |  |  | CisFemale |  |  | 2016-04-08 00:00:00 | 2016-04-08 00:00:00 | 2016-04-08 00:00:00 |  |  |  | 2016-03-06 00:00:00 |  |  | 2016-05-01 00:00:00 |  |  | 2016-04-09 00:00:00
5005SL |  |  | TransMale |  |  | 2016-04-08 00:00:00 | 2016-04-08 00:00:00 | 2016-04-08 00:00:00 |  |  |  | 2016-03-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rules:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a | If (Col F) was within past 30 days, display PENDING in (Col G); else display READY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | b | If (Col I) will occur within next 14 days, display PENDING in (Col J); else display READY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c | If (Col G) = PENDING, calculate READY DATE in (Col H): (Date from Col F + 30 days)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d | If (Col J) = PENDING, calculate READY DATE in (Col K): (Date from Col J + 30 days)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e | 2nd Assessment must be completed 7-10 days after 1st Assessment.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ** | NOTE: Use business days T1-T2 interval (per JB)
Spreadsheet: lisa_gang__22233__EPE_MARCH_2002
Sheet: MARCH(26)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-03-26 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS
Pacific | Mountain | SALE
Standard | Standard | EPMI
Time | Time | 22.25
 |  | CARRY OVER FROM 3/25
 |  | 3/1/02-3/31/02
 |  | EPE TAG#1199 |  |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL
2400 | 0100 | 25
0100 | 0200 | 0
0200 | 0300 | 0
0300 | 0400 | 0
0400 | 0500 | 0
0500 | 0600 | 0
0600 | 0700 | 0
0700 | 0800 | 0
0800 | 0900 | 0
0900 | 1000 | 0
1000 | 1100 | 0
1100 | 1200 | 0
1200 | 1300 | 0
1300 | 1400 | 0
1400 | 1500 | 0
1500 | 1600 | 0
1600 | 1700 | 0
1700 | 1800 | 0
1800 | 1900 | 0
1900 | 2000 | 0
2000 | 2100 | 0
2100 | 2200 | 0
2200 | 2300 | 0
2300 | 2400 | 0
2400 | 0100 | 0
 | MST Total |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  | TOTAL SALES | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C
 |  | EPMI
 |  | AZPS(T)FC3/PPD2
 |  | WALC(T)PPD2/COOLIDGE
 |  | CRSP(L)COOLIDGE
Spreadsheet: 680106d1590780998-have-data-automatically-build-new-list-based-on-criteria-from-a-specific-column-budget-example
Sheet: February

2021
2021-02-01 00:00:00
 |  |  |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
Input | Description | Amount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 775
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
Spreadsheet: 881461d1729534551-add-values-from-column-c-if-columns-a-and-b-contain-specific-text-alternate-sheet-transaction-log
Sheet: Agent Production

 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | Total Production
Sales Revenue |  | This formula is currently returning the "total" of all years, not just 2018
Commission Earned |  | [NAME] not working
Avg Commission %
Company Earnings |  | [NAME] not working
Total # [NAME]
Total # Buyers
Total # [NAME]
Total # Terminated
Total # Expired
Total List Price
Total Sold Price
Average % Closed
Transactions tab columns:
 | A = Name
 | B = Property Status (Closed)
 | D = Year
 | N = List Price
 | O = Sell Price
 | Q = Agent Commission
 | R = Company $
Spreadsheet: 45647d1244463931-extra-f-columns-onlineexample
Sheet: Sheet1

Computer Name | Type | Network username | Network Domain Name | Status | Last Contact | Asset Status | Org. Unit | Computer manufacturer | Computer model | Computer serial number | Computer asset tag | Memory | Slot Type 1 | Processor | Processor Speed | Monitor | Hard Disk Size ([NAME]) | Drive C: [NAME] (MB) | OS | OS Product | User First Name | User Last Name | Cost Centre | Business Area | HO Data Acquired Date | Contact from last report | User name from last report | Note
032A0069301 | Network PC | bloggsj | NETWORK | Schedule Update Pending + Audit Complete + Audit Scheduled + Registered + Secure | 2009-06-01 14:44:00 | Operational | BUILDING NAME | Amended | D1534 (D1534) | 032A1108xxx | 032A11081xx | 512 | DIMM | Intel Pentium 4 processor supporting Hyper-Threading Technology | 2600 |  | 6.0GB | 6.0GB | Windows XP | Professional |  |  |  |  |  | 2009-04-23 15:16:00 | bloggsj
Spreadsheet: 887900d1738229621-conditional-formatting-copying-to-others-cells-not-working-as-tracker_test
Sheet: Sheet1

Project Name = Live in precon Project Name = on the radar | Programme | Tender issue date
Project Title - Example | Planned | 2025-01-28 00:00:00
CRM: | Forecast | 2025-01-28 00:00:00 |  | Green if date from C2 hit; Amber if date from C2 goes over
Planner: | Actual | 2025-01-28 00:00:00 |  | Green if date from C3 hit; Red if date from C3 goes over
Project Title | Planned
CRM: | Forecast
Planner: | Actual
Project Title | Planned
CRM: | Forecast
Planner: | Actual