tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 156210d1337224875-excel-2007-three-permutations-into-one-formula-template
Sheet: Trade Stats

 | Date |  |  |  | Instrument: |  |  | CL 06-12 |  |  |  | (Must  post T1 & T2) |  |  | Dancing with Markets - Trade Stats
 |  |  |  |  | Sequence of  [NAME] CCI Turbo |  |  |  |  |  | Entry | Exit T1 or | Exit | Stopped | T 1 | T 2 | Total | Run 1 | Run 2 | [NAME] pos |  | T&R | Trade | MFE if | Duration of
 | Trade | Bar # | ctrts | (L/S) | High | "UD" | Mid | "UD" | Low | "UD" | Price | Stopped | T 2 | Ticks | Ticks | Ticks | Ticks | MFE | MFE | [NAME] |  | Diff. | MAE | Stopped | Trade | Run
 | 1 |  | 2 | L |  |  |  |  |  |  | 100 | 99.9
 |  | Notes 1:
 | 2 |  | 2 | L |  |  |  |  |  |  | 100 | 100.1 | 100.2 |  |  |  |  | 20 | 56
 |  | Notes 2:
 | 3 |  | 2 | L |  |  |  |  |  |  | 100 | 100.1 |  |  |  |  |  | 16
 |  | Notes 3:
 | 4
 |  | Notes 4:
 | 5
 |  | Notes 5:
 | 6
 |  | Notes 6:
 | 7
 |  | Notes 7:
 | 8
 |  | Notes 8:
 | 9
 |  | Notes 9:
 | 10
 |  | Notes 10:
 | 11
 |  | Notes 11:
 | 12
 |  | Notes 12:
 | 13
 |  | Notes 13:
 | 14
 |  | Notes 14:
 | 15
 |  | Notes 15:
 | 16
 |  | Notes 16:
 | 17
 |  | Notes 17:
 |  |  |  |  | L |  | S
 | General notes:
Spreadsheet: richard_ring__31564__Enron_MayJune_1999
Sheet: Endorsed_Summ

 | 1999 Summary of Resources used toward sales of Environmentally Preferred Power (EPP)
 |  | "Endorsed" Hydro |  | Wind Generation
 |  | [NAME] | Idaho Falls | Foote Creek I | Foote Creek II
 |  | (MWh's) | (MWh's) | (MWh's) | (MWh's)
 | Total Generation
 | LESS: Amts Dedicated to EPP Customers
 | Amount Available for 1999 System Mix
Spreadsheet: 183661d1348936702-sequential-mann-kendal-test-mksq
Sheet: Sheet1

 | [NAME] Test
 |  |  |  |  |  |  |  |  |  | Year | Xj | [NAME]
 |  |  |  |  |  |  |  |  |  | 1961 | 19.99017345110087
 |  |  |  |  |  |  |  |  |  | 1962 | 19.05169930875576
 |  |  |  |  |  |  |  |  |  | 1963 | 19.24160138248848
 |  |  |  |  |  |  |  |  |  | 1964 | 20.24425812631319
 |  |  |  |  |  |  |  |  |  | 1965 | 19.63714285714286
 |  |  |  |  |  |  |  |  |  | 1966 | 22.06247311827956
 |  |  |  |  |  |  |  |  |  | 1967 | 19.40442204301075
 |  |  |  |  |  |  |  |  |  | 1968 | 19.27213389656938
 |  |  |  |  |  |  |  |  |  | 1969 | 19.77565220174091
 |  |  |  |  |  |  |  |  |  | 1970 | 19.99195660522273
 |  |  |  |  |  |  |  |  |  | 1971 | 19.72883266159128
 |  |  |  |  |  |  |  |  |  | 1972 | 19.4911679644049
 |  |  |  |  |  |  |  |  |  | 1973 | 19.82837732160313
 |  |  |  |  |  |  |  |  |  | 1975 | 19.80786930363543
 |  |  |  |  |  |  |  |  |  | 1976 | 19.80440643925349
 |  |  |  |  |  |  |  |  |  | 1977 | 20.33200140809012
 |  |  |  |  |  |  |  |  |  | 1978 | 19.40508448540707
 |  |  |  |  |  |  |  |  |  | 1979 | 19.96758038031675
 |  |  |  |  |  |  |  |  |  | 1980 | 20.19658416759362
 |  |  |  |  |  |  |  |  |  | 1981 | 19.93430683563748
 |  |  |  |  |  |  |  |  |  | 1982 | 19.83033090117768
 |  |  |  |  |  |  |  |  |  | 1983 | 20.22538453219626
 |  |  |  |  |  |  |  |  |  | 1984 | 19.88837319243604
 |  |  |  |  |  |  |  |  |  | 1985 | 20.43076932923707
 |  |  |  |  |  |  |  |  |  | 1986 | 20.26192524321556
 |  |  |  |  |  |  |  |  |  | 1987 | 20.99830371488603
 |  |  |  |  |  |  |  |  |  | 1988 | 21.26554288715857
 |  |  |  |  |  |  |  |  |  | 1989 | 20.14976830517153
 |  |  |  |  |  |  |  |  |  | 1990 | 21.02836853558628
 |  |  |  |  |  |  |  |  |  | 1991 | 20.71950076804915
 |  |  |  |  |  |  |  |  |  | 1992 | 20.24370967741935
 |  |  |  |  |  |  |  |  |  | 1993 | 20.15623463901689
 |  |  |  |  |  |  |  |  |  | 1994 | 20.01932859703021
 |  |  |  |  |  |  |  |  |  | 1995 | 20.21622247823861
 |  |  |  |  |  |  |  |  |  | 1996 | 20.4257866765542
 |  |  |  |  |  |  |  |  |  | 1997 | 20.08445340501792
 |  |  |  |  |  |  |  |  |  | 1998 | 20.94558115719406
 |  |  |  |  |  |  |  |  |  | 1999 | 20.7588716077829
 |  |  |  |  |  |  |  |  |  | 2000 | 20.27187059695958
 |  |  |  |  |  |  |  |  |  | 2001 | 20.37272913466462
 |  |  |  |  |  |  |  |  |  | 2002 | 20.27559779825909
 |  |  |  |  |  |  |  |  |  | 2003 | 20.4018990015361
 |  |  |  |  |  |  |  |  |  | 2004 | 20.1971792732666
 |  |  |  |  |  |  |  |  |  | 2005 | 20.68150665642601
 |  |  |  |  |  |  |  |  |  | 2006 | 20.43107142857143
 |  |  |  |  |  |  |  |  |  | 2007 | 20.13322580645161
 |  |  |  |  |  |  |  |  |  | 2008 | 20.44259485848474
 |  |  |  |  |  |  |  |  |  | 2009 | 20.15136328725038
 |  |  |  |  |  |  |  |  |  | 2010 | 20.396044546851
Spreadsheet: 381e2194-404e-48fd-b675-2994b62990b5
Sheet: Sheet1

Release: BEA Regions Housing Units Authorized By Building Permits | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=173
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-10-22 8:50 AM [NAME]
 | Real-Time | Period
Name: | Start | End
BEA Regions Housing Units Authorized By Building Permits | 2008-07-25 00:00:00 | Current
Link:
http://www.census.gov/const/www/permitsindex.html | 2008-07-25 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2008-07-25 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2008-07-25 00:00:00
2008-08-26 00:00:00
2008-09-25 00:00:00
2008-10-27 00:00:00
2008-11-26 00:00:00
2008-12-23 00:00:00
2009-01-29 00:00:00
2009-02-26 00:00:00
2009-03-25 00:00:00
2009-04-24 00:00:00
2009-05-27 00:00:00
2009-06-24 00:00:00
2009-07-27 00:00:00
2009-08-26 00:00:00
2009-09-25 00:00:00
2009-10-27 00:00:00
2009-11-25 00:00:00
2009-12-23 00:00:00
2010-01-28 00:00:00
2010-02-25 00:00:00
2010-03-24 00:00:00
2010-04-26 00:00:00
2010-05-26 00:00:00
2010-06-24 00:00:00
2010-07-27 00:00:00
2010-08-25 00:00:00
2010-09-27 00:00:00
2010-10-27 00:00:00
2010-11-24 00:00:00
2010-12-23 00:00:00
2011-01-27 00:00:00
2011-02-25 00:00:00
2011-03-24 00:00:00
2011-04-26 00:00:00
2011-05-25 00:00:00
2011-06-24 00:00:00
2011-07-27 00:00:00
2011-08-24 00:00:00
2011-09-27 00:00:00
2011-10-27 00:00:00
2011-11-28 00:00:00
2011-12-23 00:00:00
2012-01-27 00:00:00
2012-02-27 00:00:00
2012-03-26 00:00:00
2012-04-25 00:00:00
2012-05-24 00:00:00
2012-06-26 00:00:00
2012-07-26 00:00:00
2012-08-24 00:00:00
2012-09-27 00:00:00
2012-10-25 00:00:00
2012-11-29 00:00:00
2012-12-28 00:00:00
2013-01-28 00:00:00
2013-02-27 00:00:00
2013-03-26 00:00:00
2013-04-24 00:00:00
2013-05-24 00:00:00
2013-06-26 00:00:00
2013-07-25 00:00:00
2013-08-26 00:00:00
2013-09-26 00:00:00
2013-11-27 00:00:00
2013-12-24 00:00:00
2014-01-28 00:00:00
2014-02-27 00:00:00
2014-03-26 00:00:00
2014-04-24 00:00:00
2014-05-27 00:00:00
2014-06-25 00:00:00
2014-07-25 00:00:00
2014-08-26 00:00:00
2014-09-25 00:00:00
Spreadsheet: 63851d1264707750-looking-up-a-sum-of-data-in-several-columns-for-specific-values-of-another-column-player1profile
Sheet: Sheet1

 | Player Profile - Player1 |  |  | Date | # Of Players | Host | Place Finshed | Minus Score | 1st |  | 2nd |  | 3rd |  | Score to date
 | [NAME] |  |  |  |  |  |  |  | Name | Score | Name | Score | Name | Score
 | Total Score |  |  | 2010-01-22 00:00:00 | 6 | Player4 | 1 | 5 | Player1 | 15 | Player3 | 10 | Player5 | 5
 | Average Placing |  |  | 2010-01-24 00:00:00 | 4 | Player4 | 3 | 5 | Player2 | 12.5 | Player4 | 7.5 | Player1 | 0
 | Finished in Top 3 (%)
 | Score < 6 Players
 | Score > 6 Players
Spreadsheet: 750875d1633704963-index-match-to-create-a-grid-sample-index-match-copy
Sheet: Sheet1

Date | Dir |  |  | Date | Breanda | Cal | [NAME] | [NAME] | [NAME] | Latoya | Marianne | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Rosemarie | Walter | Ward
2022-01-05 00:00:00 | [NAME] |  |  | 2022-01-05 00:00:00
2022-01-12 00:00:00 | Cal |  |  | 2022-01-12 00:00:00
2022-01-19 00:00:00 | [NAME] |  |  | 2022-01-19 00:00:00
2022-01-26 00:00:00 | [NAME] |  |  | 2022-01-26 00:00:00
2022-02-02 00:00:00 | [NAME] |  |  | 2022-02-02 00:00:00
2022-02-09 00:00:00 | [NAME] |  |  | 2022-02-09 00:00:00
2022-02-16 00:00:00 | [NAME] |  |  | 2022-02-16 00:00:00
2022-02-23 00:00:00 | Breanda |  |  | 2022-02-23 00:00:00
2022-03-02 00:00:00 | Marianne |  |  | 2022-03-02 00:00:00
2022-03-09 00:00:00 | [NAME] |  |  | 2022-03-09 00:00:00
2022-03-16 00:00:00 | Walter |  |  | 2022-03-16 00:00:00
2022-03-23 00:00:00 | [NAME] |  |  | 2022-03-23 00:00:00
2022-03-30 00:00:00 | Latoya |  |  | 2022-03-30 00:00:00
2022-04-06 00:00:00 | Rosemarie |  |  | 2022-04-06 00:00:00
2022-04-13 00:00:00 | [NAME] |  |  | 2022-04-13 00:00:00
2022-04-20 00:00:00 | Ward |  |  | 2022-04-20 00:00:00
2022-04-27 00:00:00 | Cal |  |  | 2022-04-27 00:00:00
2022-05-04 00:00:00 | [NAME] |  |  | 2022-05-04 00:00:00
2022-05-11 00:00:00 | [NAME] |  |  | 2022-05-11 00:00:00
2022-05-18 00:00:00 | [NAME] |  |  | 2022-05-18 00:00:00
2022-05-25 00:00:00 | [NAME] |  |  | 2022-05-25 00:00:00
Trying to use this =INDEX($E$1, MATCH(1, ($J3=$F$3:$F$18)*($L$2=$G$3:$G$18),0)), however when the name repeated it threw Ref# error.  Not seeing the issue.
Desired output would be 'x' where the name and date in table 1 match the corresponding date and name in table 2.
 |  |  |  | Example of output:
 |  |  |  | Date | Breanda | Cal | [NAME] | [NAME] | [NAME] | Latoya | Marianne | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Rosemarie | Walter | Ward
 |  |  |  | 2022-01-05 00:00:00 |  |  |  |  | x
 |  |  |  | 2022-01-12 00:00:00 |  | x
 |  |  |  | 2022-01-19 00:00:00 |  |  | x
 |  |  |  | 2022-01-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  | 2022-02-02 00:00:00 |  |  |  |  |  |  |  |  |  | x
 |  |  |  | 2022-02-09 00:00:00 |  |  |  |  |  |  |  | x
 |  |  |  | 2022-02-16 00:00:00 |  |  |  |  |  |  |  |  | x
 |  |  |  | 2022-02-23 00:00:00 | x
 |  |  |  | 2022-03-02 00:00:00 |  |  |  |  |  |  | x
 |  |  |  | 2022-03-09 00:00:00 |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  | 2022-03-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  | 2022-03-23 00:00:00 |  |  |  | x
 |  |  |  | 2022-03-30 00:00:00 |  |  |  |  |  | x
 |  |  |  | 2022-04-06 00:00:00 |  |  |  |  | x |  |  |  |  |  |  |  | x
Spreadsheet: 808425d1670451503-conditional-format-based-on-data-in-one-cell-column-unless-another-column-cell-has-data-call-record-etaf-v2
Sheet: Sheet1

Date email sent | Time Sent | Due Date | Must Call | Date Called
2022-11-28 00:00:00 | 17:22:00 |  |  | 2022-12-02 00:00:00 |  |  |  | Many thanks for the reply. I have attached (I hope) as small example. I am trying to get Column D to show CALL based on the dates in Column A UNLESS Column E has an entry, in which case it should be blank
2022-11-28 00:00:00 | 17:23:00 |  |  | 2022-12-02 00:00:00
2022-12-02 00:00:00 | 09:23:00
2022-12-02 00:00:00 | 09:24:00
2022-12-02 00:00:00 | 09:25:00
2022-01-02 00:00:00 | 10:00:00
2022-12-02 00:00:00
2022-11-28 00:00:00 | 17:26:00 |  |  | 2022-12-02 00:00:00
2022-11-28 00:00:00 | 17:27:00 |  |  | 2022-12-02 00:00:00
2022-11-28 00:00:00 | 17:29:00 |  |  | 2022-12-02 00:00:00
2022-11-28 00:00:00 | 17:31:00 |  |  | 2022-12-02 00:00:00
2022-01-06 00:00:00 | 15:33:00
Spreadsheet: daren_farmer__6635__Texas Nat_Gas Ops 0200 O&M Report
Sheet: 2933

2933 |  |  |  |  |  |  |  |  |  |  |  |  |  | ASSOCHC | TOTAL_HEADCOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALYSTHC | 2000-01-01 00:00:00 |  | 2000-02-01 00:00:00 |  | 2000-03-01 00:00:00 |  | 2000-04-01 00:00:00 |  | 2000-05-01 00:00:00 |  | 2000-06-01 00:00:00 |  | 2000-07-01 00:00:00 |  | 2000-08-01 00:00:00 |  | 2000-09-01 00:00:00 |  | 2000-10-01 00:00:00 |  | 2000-11-01 00:00:00 |  | 2000-12-01 00:00:00
 |  | ACTUAL |  | PLAN2000 |  |  |  | ACTUAL |  | PLAN2000
 |  | M.PER |  | M.PER |  |  |  | M.YTD |  | M.YTD |  |  |  |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER
 |  |  |  |  |  | Monthly |  |  |  |  |  | YTD |  |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 |  | Actual |  | Plan |  | [NAME] |  | Actual YTD |  | Plan YTD |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Direct Expense:
TOT_COMP | Compensation |  |  |  |  |  |  |  |  |  |  |  |  | Headcount
[NAME] | Benefits and Payroll Taxes |  |  |  |  |  |  |  |  |  |  |  |  | Analysts and Associates
TOT_EMP_EXP | Employee Expenses
TOT_RECRUITING | Recruiting & Relocations
TOT_OSIDE_SERV | Outside Services |  |  |  |  |  |  |  |  |  |  |  |  | Direct Expense:
[NAME] | Supplies and Expense |  |  |  |  |  |  |  |  |  |  |  |  | Compensation
TOT_MKT | Marketing |  |  |  |  |  |  |  |  |  |  |  |  | Benefits and Payroll Taxes
TOT_CHAR_CONT | Charitable Contributions |  |  |  |  |  |  |  |  |  |  |  |  | Employee Expenses
TOT_RENT | Rent (3rd Party) |  |  |  |  |  |  |  |  |  |  |  |  | Recruiting & Relocations
TOT_TECH | Technology |  |  |  |  |  |  |  |  |  |  |  |  | Outside Services
TOT_TRANS | Transportation |  |  |  |  |  |  |  |  |  |  |  |  | Supplies and Expense
CORP_IT | Corporate IT |  |  |  |  |  |  |  |  |  |  |  |  | Marketing
CORP_RENT | Corporate Rent |  |  |  |  |  |  |  |  |  |  |  |  | Charitable Contributions
TOT_OTH_EXP | Other Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Rent (3rd Party)
[NAME] | Taxes Other Than Income |  |  |  |  |  |  |  |  |  |  |  |  | Technology
[PHONE] | Capital Allocation |  |  |  |  |  |  |  |  |  |  |  |  | Transportation
TOT_DEP_AMOR | Depreciation & Amortization |  |  |  |  |  |  |  |  |  |  |  |  | Corporate IT
 | Total Direct Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Corporate Rent
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Expenses
9230999860 | Allocated Intercompany Billings |  |  |  |  |  |  |  |  |  |  |  |  | Taxes Other Than Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Capital Allocation
 | Net Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Depreciation & Amortization
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Direct Expenses
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Allocated Intercompany Billings
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Expenses
Spreadsheet: 723734d1615864307-how-to-display-named-range-in-the-formula-based-result-display-named-range
Sheet: TASK#2

0 | apple |  | ROW | Name Range
1 | ball |  | 1 | MY_TABLE_ |  |  | 1
2 | cat |  | 9 | [NAME]_ |  |  | 2
3 | dog |  | 15 | MY_ELECTRONIC_ |  |  | AA
4 | egg |  |  |  |  |  | BB
5 | frog |  |  |  |  |  | GHI
6 | goat |  |  |  |  |  | MNO
AA | san jose
BB | san francisco
CC | dallas
DD | napa
EE | [NAME]
ABC | Computer
DEF | TV
GHI | Radio
JKL | Printer
MNO | Camera
Spreadsheet: 753937d1635848349-how-to-write-function-for-automatic-sequence-of-numbers-sub-change-orders
Sheet: Pond Cove

 | Subcontractor [NAME]
 | Project Name: | 47 West Broadway |  |  |  |  | Original Contract: |  |  | 40000
 | Project Number: | 19-1053 |  |  |  |  | Change Order Totals:
 | Subcontractor: | Pond Cove Millwork |  |  |  |  | Total Approved To Date:
 | Contract Number: | 429 |  |  |  |  | Total Paid To Sub To Date:
 | Cost Code: | 06 22 00 |  |  |  |  | Total Retainage To Date:
 | Retainage: | 0.05 |  |  |  |  | Remainder to [NAME]:
 | Subcontractor Invoice Number | Date on Invoice | Date Received by Woodhull | Date Invoice Approved | Amount Billed | Adjustments to Invoice | Amount Approved | Check Sent | Retainage Held | Notes
 |  |  |  |  | Amount Billed for Retainage | Adjustments to Invoice | Amount Approved | Check Sent
Spreadsheet: 805906d1669001469-excel-tab-auto-copy-data-log
Sheet: Main

Hire Date | Emp Name | Emp ID | Dept | Educator
2022-10-01 00:00:00 | [NAME], [NAME] | 233654 | 4D | Prince
2022-10-01 00:00:00 | [NAME], George | 822322 | 6E | Erika
2022-10-05 00:00:00 | [NAME], hessie | 464564 | 5A | Galvan
2022-10-05 00:00:00 | Hector, Diax | 234234 | 4A | [NAME]
2022-10-10 00:00:00 | [NAME], Cris | 65467 | 4D | Erika
2022-10-10 00:00:00 | Carol, Ipe | 234321 | 6D | Galvan
Spreadsheet: 847822d1698678291-using-hlookup-based-on-another-hlookup-sample
Sheet: Companionship planting

 |  | Vegetable / Cereal |  |  | Companionship planting
 |  | Common name |  | Scientific name
 |  | Portuguese | English
 | 1
Spreadsheet: 769209d1645401232-monthly-and-quarterly-reports-excel-question
Sheet: December 2019

 | REAC Treasurer's Report
 | 2019-12-01 00:00:00
 | Opening Interest Privilege Account #2 |  |  |  |  |  | 48218.57
 | RECEIPTS
 |  | Date |  | Name | Memo | Category | Amount
 |  | 2019-12-01 00:00:00 |  | 1st United | Newsletter Ad | Income | 500 |  | REAC Treasurer Report - Allocation to Budget
 |  | 2019-12-31 00:00:00 |  | ACERA Payroll | Member [NAME] | Income | 7908 |  | 2019-12-31 00:00:00
 |  | 2019-12-31 00:00:00 |  | Dividend | Checking Acct | Chk Interest | 6.22
 |  | 2019-12-31 00:00:00 |  | Interest |  | CD Interest | 86.88
 |  | 2019-12-12 00:00:00 |  | CFTB Refund |  | State Tax | 15 |  | INCOME | DEC
 |  |  |  |  |  |  |  |  | ACERA Payroll Membership
 |  |  |  | Total Receipts December 2019 |  |  |  |  | Direct Payment Membership Dues
 |  |  |  |  |  |  |  |  | 1st United SCU Newsletter Ad
 | DISBURSEMENTS |  |  |  |  |  |  |  | 1st United Credit Union Checking Int/Div
 | 0.05882352941176471 | 2019-12-09 00:00:00 | 5156 | [NAME] | [NAME] | D&O Stipend | 200 |  | 1st United Credit SCU Checking Acct Int/Div
 |  | 2019-12-09 00:00:00 | 5157 | [NAME] | [NAME] | D&O Stipend | 200 |  | Spring Luncheon/Annual Meeting Member [NAME]
 |  | 2019-12-09 00:00:00 | 5158 | [NAME] | Postage | [NAME] | 11 |  | Fall Luncheon Member [NAME]
 |  | 2019-12-10 00:00:00 | 4934 | Creative Circle | Newsletter layout | Newsletter | 362.5 |  | Other - CFTB Refund | 15
 |  | 2019-12-13 00:00:00 | 4935 | [NAME] | Supplies | [NAME] | 57.66 |  | Total Dec 2019 Income
 |  | 2019-12-13 00:00:00 | 4936 | [NAME] | January Stipend | D&O Stipend | 200
 |  | 2019-12-13 00:00:00 | 4937 | [NAME] | January Stipend | D&O Stipend | 200
 |  | 2019-12-13 00:00:00 | 4938 | [NAME] | January Stipend | D&O Stipend | 250 |  | EXPENSES
 |  | 2019-12-23 00:00:00 | 4939 | Red Arrow | Printing | Newsletter | 1679.52 |  | Red Arrow Printing for REAC Newsletter
 |  | 2019-12-19 00:00:00 | Debit | Harland Checks | Checks | [NAME] | 15.02 |  | Postmaster
 |  |  |  |  |  |  |  |  | D&O Liability Insurance Premium
 |  |  |  | Total Disbursements December 2019 |  |  |  |  | Conference Expenses
 |  |  |  |  |  |  |  |  | Dues and Subscriptions:
 |  |  |  |  |  |  |  |  | CRCEA
 |  | Balance - Check Book |  |  |  |  |  |  | SACRS
 |  | Outstanding Checks :  5074 |  | 5158 and 4939 |  |  | 1690.52 |  | Spring Members Luncheon
 |  | Statement Balance |  |  |  |  | 55249.49 | 3900.6 | Fall Memers' Luncheon
 |  | Discrepancy |  |  |  |  |  |  | D&O Stipend
 |  | All Assets |  |  |  |  |  |  | Holiday Directors and [NAME]
 |  | Interest Privilege Account 2 |  |  |  |  |  |  | Financial Review and Tax Preparation
 |  | Regular Shares Account |  |  |  |  | 25.01 | 20.01 | Franchise Tax Board
 |  | 36 Month Certificate of Deposit |  |  |  |  | 53000 | 20345 | Administrative Support
 |  | Total Assets |  |  |  |  |  | 53000 | Administrative Expenses
 |  |  |  |  |  |  |  |  | Newsletter layout (Creative Circle)
 |  |  |  |  |  |  |  |  | Web Maintenance (Lori Vandemeir)
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Total Dec 2019 Income
Spreadsheet: 330234d1404644801-skip-cells-and-move-onto-next-cell-that-dont-meet-criteria-using-if-fucntion-in-excel-example
Sheet: Sheet2

Name | Outcome | Date | Helper |  |  | Criterion | Array formula result
Mr [NAME] | Open | 2014-02-01 00:00:00 |  |  |  | Mr SmithQualified
Mr [NAME] | Disqualified | 2014-02-02 00:00:00
Mr [NAME] | Qualified | 2014-02-03 00:00:00
Mr Barnes | Qualified | 2014-02-04 00:00:00
Mr [NAME] | Qualified | 2014-02-05 00:00:00
Mr [NAME] | Open | 2014-02-06 00:00:00
Mr [NAME] | Qualified | 2014-02-07 00:00:00
Mr [NAME] | Qualified | 2014-02-08 00:00:00
Mr [NAME] | Disqualified | 2014-02-09 00:00:00
Mr [NAME] | Open | 2014-02-10 00:00:00
Mr [NAME] | Open | 2014-02-11 00:00:00
Mr Barnes | Qualified | 2014-02-12 00:00:00
Spreadsheet: 69939d1270592809-auto-filling-information-expense-report-02
Sheet: GL

GL | [NAME]
605500 | Uniforms
607503 | Employee Safety Equipment
607504 | Mentoring
607600 | Hiring & Testing
607700 | Training
609600 | Info Tech Services & Exp
610200 | Gas & Oil Vehicles
610300 | Maintenance
610400 | Repairs
610500 | Supplies
610600 | Tires Vehicles
610800 | Licenses Vehicles
610900 | Accident & Damage Claims
611000 | Safety Lane
611100 | Tolls
615000 | Meals
615500 | Entertainment
616000 | Travel (air, lodging, mileage)
620700 | Testing Plant
627500 | License & Fees
628000 | Safety
628500 | Dues& Subscriptions
629000 | Postage & Shipping
630000 | Office Supplies
635000 | EPA Exp (quarries only)
809000 | Hiring&Testing
809600 | [NAME] Exp
811000 | Gas&Oil
811500 | Maintenance
812000 | Repairs
812500 | Tires
814000 | Mentoring
814500 | Tolls
814600 | Safety Lane
815000 | Rental/Lease
815500 | Meals
815600 | Parking
816500 | Other Tickets
817000 | Entertainment
817500 | Travel & Lodging
818000 | Office Supplies
824600 | License & Fees (non-vehicle)
824800 | Penalties
826000 | Postage
829500 | Dues& Subscriptions
829550 | Training& Education
830000 | Meetings & Seminars
830501 | Advertising-Media
830502 | Advertising-Premiums
830503 | Advertising-Promotional
831500 | Miscellaneous
Spreadsheet: 490495d1479897185-if-function-is-not-reading-a-lookup-cell-correctly-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | GRADING
 |  |  | a | b | c | d | TOTAL | LEVEL |  |  |  | Level | from | to
 |  | [NAME] | 7 | 6 | 5 | 7 |  |  |  |  |  | 1 | 0 | 5
 |  | [NAME] | 5 | 4 | 3 | 1 |  |  |  |  |  | 2 | 6 | 9
 |  | [NAME] | 3 | 2 | 2 | 1 |  |  |  |  |  | 3 | 10 | 14
 |  | [NAME] | 7 | 7 | 7 | 7 |  |  |  |  |  | 4 | 15 | 18
 |  |  | 8 | 8 | 8 | 8 |  |  |  |  |  | 5 | 19 | 23
 |  |  | 3 | 4 | 4 | 8 |  |  |  |  |  | 6 | 24 | 27
 |  |  |  |  |  |  |  |  |  |  |  | 7 | 28 | 32
Spreadsheet: chris_germany__1977__lonestarnom2
Sheet: May 11,2002

[NAME]
[NAME]
Dallas, TX  75201-5696
Attention: | Wilma Easter - Scheduling Department |  |  | From: | Enron Capital & Trade
Fax: | 214/875-3810 |  |  |  | [NAME]
Phone: | 214/875-3296 |  |  |  | 713/853-4743 (Phone)
Backup:  [NAME] 214/875-2674 |  |  |  |  | 713/646-3037 (Fax)
Contract #LS-MC-1671 |  |  | Start Date: | 2002-05-11 00:00:00 |  | End Date: | 2002-05-31 00:00:00
RECEIPT POINT INFORMATION:
 | STATION # | [NAME] | UPSTREAM K# | NOM QUANTITY | FUEL % | NET QUANTITY | Changes
Cinergy | 17-1201-11 | [NAME] | 01T957 | 5000 | 0.01 |  | **
Cinergy | 17-3000-00 | [NAME] | 01T957 | 0 | 0.01
Cinergy | 17-1240-50 | NNG Sprayberry | 107903 | 10000 | 0.01
 | 17-1240-50 | NNG Sprayberry | 108466 | 0 | 0.01
 | 17-7462-50 | [NAME] | 5268 | 0 | 0.01
[NAME] | 17-3000-00 | [NAME] | 2880600203 | 0 | 0.01
[NAME] | 17-1201-11 | [NAME] | REM | 25000 | 0.01
DELIVERY POINT INFORMATION:
STATION # | [NAME] | UPSTREAM K# | NOM QUANTITY | FUEL % | NET QUANTITY
25-0002-00 | Kleburne Plant | 1671
FYI:  Buy/Sell Information
Cinergy | 17-1201-11 | [NAME] | #01T957 | 0 | 0 |  | sold to TXU K501
Cinergy | 17-1201-11 | [NAME] | #01T957 | 5000 | 0 |  | ** sold to TXU K1901