tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 707406d1607251206-using-a-list-to-reduce-worksheets-midshires-master
Sheet: RDa

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 36873d1234847038-excel-2007-how-do-i-reference-a-min-value-in-another-spreadsheet-discrete-measures
Sheet: SLw-rtoLL

Level | 25PE | 25CS | 5PE | 5CS | 75PE | 75CS | 10PE | 10CS | 15PE | 15CS
Spreadsheet: 824519d1680638144-combining-aggregate-with-if-and-functions-cumulative_installs
Sheet: Sheet1

 | FY19 | FY20 | FY21 | FY22 | FY23 | FY24
# installs |  | 2 | 2 | 1 | 4 | 0
Cumulative installs
Cost
Spreadsheet: 035fde3b-1aa8-4db6-bf59-15fb3cc2d21f
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FHPL | Test | FHPL | Human Placental Lactogen (HPL) | Human Placental Lactogen | Enzyme-Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a red top tube(s). Separate and send 1 mL of serum frozen in plastic vial. | 0.5 mL | Specimens other than	Serum Anticoagulants other than	Plain red-top Hemolysis	NA Thawing	warm reject; cold reject Lipemia	NA Icteric	NA | Males and nonpregnant Woman: 0.00-0.10 mcg/mL 1st Trimester of Pregnancy: 0.20-2.10 mcg/mL 2nd Trimester of Pregnancy: 0.50-6.70 mcg/mL 3rd Trimester of Pregnancy: 4.50-12.80 mcg/mL                                              Test Performed by: Cambridge Biomedical Inc.                              1320 Soldiers Field Road 	                 Boston, MA 02135 | Thursday | 1 - 9 days | 3 - 11 days | 1 | 83632 |  |  |  |  | Cambridge Biomedical Inc.
FHPL | [NAME] | SRED | Serum Red |  |  |  | Frozen | 90 days
FHPL | Result | [NAME] | Human Placental Lactogen | Human Placental Lactogen | Alphanumeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 2104-8
Spreadsheet: mary_fischer__25606__31Z
Sheet: E20.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Z
COMPANY NAME    LINC
ANALYSIS OF OTHER INCOME AND DEDUCTIONS
 |  |  |  |  |  |  |  |  |  | E-20
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER INCOME - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Income - Other
(MUST TIE TO HYPERION ACCOUNT 1690)
Income Accts:  DR/(CR)
Reverse signs from Hyperion
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER DEDUCTIONS - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Deductions - Other
(MUST TIE TO HYPERION ACCOUNT 1775)
Asset/Expense Accts:  DR/(CR)
Same signs as Hyperion
 |  |  |  |  |  |  |  |  |  | E-20
Spreadsheet: 00d9c308-757c-4b3b-96b2-422a09123dad
Sheet: Grade 3 Reading

2013 Minnesota Test of Academic Skills (MTAS)
2013 MTAS Grade 3
[NAME]
Raw Score | Scale Score*** | Level
0 | 58 | D
1 | 83 | D
2 | 100 | D
3 | 111 | D
4 | 120 | D
5 | 128 | D
6 | 136 | D
7 | 145 | D
8 | 154 | D
9 | 163 | D
10 | 171 | D
11 | 177 | D
12 | 182 | D
13 | 186 | D
14 | 190 | P
15 | 194 | P
16 | 197 | P
17 | 200 | M
18 | 203 | M
19 | 206 | M
20 | 210 | M
21 | 213 | M
22 | 217 | M
23 | 221 | M
24 | 227 | E
25 | 234 | E
26 | 246 | E
27 | 268 | E
Notes:
*2007 and 2008/2009/2010/2011  MTAS scale metrics are not comparable
**2011/2012 and 2008/2009/2010  Grades 3-8 Mathematics MTAS scale metrics are not comparable
***2013 and 2008/2009/2010/2011/2012  Reading MTAS scale metrics are not comparable
End of Worksheet
Spreadsheet: 330495d1404766433-complex-comparison-of-columns-help-example-of-missing-data-on-table-5
Sheet: Tab3

Incident Number | tab1 row index | tab2 row index | Incident Number2 | Description | Priority | Created On | Status | Sold-To Party (00000001) | Team | VersionOne ID | Status3 | Owner
Spreadsheet: 586040d1534175063-not-showing-duplicates-in-data-validation-list-from-dynamic-table-data-validation-list-aligw
Sheet: Sheet1

Tab1
1
2
1
3
4
Spreadsheet: mary_fischer__25606__31Z
Sheet: ELIST.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Z |  | (Please print)  PREPARED BY: | Sonya City
COMPANY NAME    LINC
E-SCHEDULES CHECK LIST
For the period ending: 06/30/2001 |  | REVIEWED BY: | [NAME]
*  PRIORITY SCHEDULE
SCH | CONSOL ACCT | QUARTERLY SCHEDULES | COMPLETED or N/A
E-1 | 053, 060 | A/R - Other | Completed
E-2 * | 195 | Other Current Assets | Completed
E-3 * | TOT_INVEST_SUBS | Investment in Unconsolidated
 | TOT_EQEARN_OTH | Affiliates, Partnerships & Joint Ventures | N/A
E-4 * | 269, 270, 280 | Merchant and Other Investments | Completed
E-5 | 344 | Goodwill | Completed
E-6 * | TOT_PPE | Property, Plant & Equipment | Completed
 | [NAME] | Depreciation, Depletion & Amortization
[NAME] * | 343, 360 | Other Deferred Charges | N/A
E-11* | 655 | Other Current Liabilities | Completed
E-12 * | 450,  TOT_NP_OTHER | Short-Term and Long-Term Debt | N/A
 | 770,  705,  775,  765
E-14* | 860 | Other Deferred Credits | Completed
E-15 | 855 | Minority Interests | N/A
E-16* | 1676 | (Gain) Loss on Sales of Assets | N/A
E-20* | 1690, 1775 | Other Income and Other Deductions | N/A
E-21 |  | Lease Expense & Future Lease Commitments | Completed
E-31 | VARIOUS ACCOUNTS | Equity/Invmt Sub | Completed
E-36 | 0 | Investee's Summarized Information | N/A
 | TOT_EQEARN_OTH
 |  | ADDITIONAL SCHEDULES FOR YEAR END ONLY
E-18 | 65, 641, 815, 840 | Analysis of Reserve Items | N/A
Spreadsheet: 33105d1229384312-nested-if-functions-roman-3b
Sheet: Sheet4

 |  | width of blind |  | 4000
 |  | drop of blind |  | 1700 |  |  |  |  |  | [NAME] of headrail |  |  | 3990
 |  |  |  |  |  |  |  |  |  | drop of blind |  |  | 1700
 |  | Hardware allowance | 2320 | 45 |  |  |  |  | Profile 2211 |  |  |  | 3990 | [NAME]
 |  |  |  |  |  |  |  |  | Hex Bar 2111 |  |  |  | 3970 | [NAME]
 |  | no. Of pockets |  | 7.5 |  |  |  |  | Gear 2049 |  |  |  | 1
 |  |  |  |  |  |  |  |  | Tape Spool 2081 |  |  |  | 13
 |  |  |  |  |  |  |  |  | Tape Centralizer 3056 |  |  |  | 13
 |  |  | 1 | 265.6666666666666 |  | [NAME] |  |  | Tape Ring 3073 |  |  |  | 13
 |  |  | 2 | 486.3333333333333 |  |  |  |  | Bracket 3630 |  |  |  | 8
 |  |  | 3 | 706.9999999999999 |  |  |  |  | Screw 18R |  |  |  | 8
 |  |  | 4 | 927.6666666666665 |  |  |  |  | End Cover 2179 |  |  |  | 2
 |  |  | 5 | 1148.333333333333 |  |  |  |  | Clip 2059 |  |  |  | 2
 |  |  | 6 | 1369 |  |  |  |  | Bead Chain 4845 |  |  |  | 3 | mtr
 |  |  | 7 | 1589.666666666667
 |  |  |  |  |  |  |  |  |  | spool positions |  | 0 | 70
 |  |  | 1/2    pocket | 110.3333333333333 |  | [NAME] |  |  |  | in mm from end |  | 1 | 390.8333333333333
 |  |  |  |  |  |  |  |  |  |  |  | 2 | 711.6666666666666
 |  |  |  |  |  |  |  |  |  |  |  | 3 | 1032.5
 |  |  |  |  |  |  |  |  |  |  |  | 4 | 1353.333333333333
 |  | Customer | HW |  |  |  |  |  | Customer | HW |  | 5 | 1674.166666666667
 |  | Client | [NAME] |  |  |  |  |  | Client | [NAME] |  | 6 | 1995
 |  | Order No. | 12345 |  |  |  |  |  | Order No. | 12345 |  | 7 | 2315.833333333333
 |  |  |  |  |  |  |  |  |  |  |  | 8 | 2636.666666666667
 |  |  |  |  |  |  |  |  |  |  |  | 9 | 2957.5
 |  |  |  |  |  |  |  |  |  |  |  | 10 | 3278.333333333333
 |  |  |  |  |  |  |  |  |  |  |  | 11 | 3599.166666666667
 |  |  |  |  |  |  |  |  |  |  |  | 12 | 3920
Spreadsheet: 275038d1383315626-matching-indexing-a-list-of-lab-reported-contaminants-with-an-epa-list-index-match
Sheet: Sheet1

Site Sampled | Contaminant   (Reported by Lab) |  | Match the contaminant with the parameter and place the corresponding  CTL in this column | Parameter | EPA CTL's (Cleanup Target Levels)
Well 1 | 1,1,1,2-Tetrachloroethane | ug/l |  | 1,1,1,2-Tetrachloroethane | 1.3
Well 1 | 1,1,1-Trichloroethane | ug/l |  | 1,1,1-Trichloroethane | 200
Well 1 | 1,1,2- Trichloropropane | ug/l |  | 1,1,2- Trichloropropane | 35
Well 1 | 1,1,2,2-Tetrachloroethane | ug/l |  | 1,1,2,2-Tetrachloroethane | 0.2
Well 1 | 1,1,2,3-Tetrachloropropane | ug/l |  | 1,1,2,3-Tetrachloropropane
Well 1 | 1,1,2-Trichloro-1,2,2-trifluorethane | ug/l |  | 1,1,2-Trichloro-1,2,2-trifluorethane | 210000
Well 1 | 1,1,2-Trichloroethane | ug/l |  | 1,1,2-Trichloroethane | 5
Well 1 | 1,1,2-Trichloroethane | ug/l |  | 1,1,2-Trichloroethane | 3
Well 1 | 1,1-Dichloroethane | ug/l |  | 1,1-Dichloroethane | 70
Well 1 | 1,1-Dichloroethane | ug/l |  | 1,1-Dichloroethene | 7
Well 2 | 1,1-Dichloroethene |  |  | Aresenic | 0.005
Well 2 | 1,1,2,3-Tetrachloropropane
Well 2 | 1,1,2-Trichloro-1,2,2-trifluorethane
Well 2 | 1,1,1,2-Tetrachloroethane
Well 2 | 1,1,1-Trichloroethane
Well 2 | 1,1,1,2-Tetrachloroethane
Well 2 | 1,1,2,3-Tetrachloropropane
Well 2 | Phenol
Well 3 | 1,1,2,2-Tetrachloroethane
Well 3 | 1,1,1-Trichloroethane
Well 3 | 1,1,2-Trichloro-1,2,2-trifluorethane
Well 3 | 1,1,2-Trichloroethane
Well 3 | 1,1,2- Trichloropropane
Spreadsheet: 767900d1644705893-what-if-analysis-to-calculate-the-effect-of-new-pricing-example-calculation
Sheet: Current Sales

 |  |  |  |  |  |  |  |  | Product 1 |  | Product 2 |  | Product 3 |  | Product 4 |  | Sum of Quantity | Sum of Amount
Org. | Product 1 | Product 2 | Product 3 | Product 4 | Last Order # | Last Order Date | # Orders 2021 | Account | Quantity | Amount | Quantity | Amount | Quantity | Amount | Quantity | Amount |  |  | Average Price | Named Ranges | Product 1 | Product 2 | Product 3 | Product 4 | TOTAL
Reseller 1 | 18.95 |  | 26.95 |  | 10 | 2021-12-01 00:00:00 |  | AAA | 10 |  |  |  | 210
Reseller 2 |  |  |  | 28.95 | 20 | 2021-04-30 00:00:00 |  | BBB | 20 |  |  |  |  |  | 15
Reseller 3 | 24.95 |  |  |  | 100 | 04/05/2021 |  | CCC | 949
Distributor 1 | 24.95 | 26.95 | 29 |  | 1500 | 07/09/2021 |  | DDD | 29000 |  | 9600 |  | 45000
Distributor 2 | 21 | 26.95 | 31 | 30 | 10 | 2021-08-03 00:00:00 |  | EEE | 53000 |  | 1200 |  | 14500 |  | 5000
Distributor 3 | 24.95 | 26 | 30 | 21 | 12 | 10/19/2021 |  | FFF | 28000 |  | 162000 |  | 48000 |  | 125000
Spreadsheet: 92150d1291814314-spreadsheet-to-determine-login-logout-times-ats2
Sheet: Sheet1

Name | Date | Seg_Start | Seg_Finish | Segment Type(what it should read) | My [NAME] (lookup based on instance) |  | Instance # | Total  # Instances
Louise | 2010-12-01 00:00:00 | 11:53:11 | 20:14:08 | SINGLE | SINGLE |  | 1 | 1 |  |  |  |  | SINGLE
[NAME] | 2010-12-01 00:00:00 | 11:59:04 | 13:22:26 | START | START |  | 1 | 2 |  |  |  |  | START
Michelle | 2010-12-01 00:00:00 | 09:37:18 | 17:32:40 | SINGLE | SINGLE |  | 1 | 1 |  |  |  |  | SINGLE
Dean | 2010-12-01 00:00:00 | 10:30:49 | 19:01:23 | SINGLE | SINGLE |  | 1 | 1 |  |  |  |  | SINGLE
Adam | 2010-12-01 00:00:00 | 13:27:57 | 19:08:57 | SINGLE | SINGLE |  | 1 | 1 |  |  |  |  | SINGLE
Shelly | 2010-12-01 00:00:00 | 07:54:09 | 14:12:03 | SINGLE | SINGLE |  | 1 | 1 |  |  |  |  | SINGLE
Byron | 2010-12-01 00:00:00 | 09:51:29 | 19:03:02 | SINGLE | SINGLE |  | 1 | 1 |  |  |  |  | SINGLE
[NAME] | 2010-12-01 00:00:00 | 11:35:58 | 19:27:38 | FINISH | FINISH |  | 2 | 2 |  |  |  |  | START
[NAME] | 2010-12-01 00:00:00 | 13:57:22 | 16:29:48 | START | START |  | 1 | 2 |  |  |  |  | START
[NAME] | 2010-12-01 00:00:00 | 16:33:17 | 18:59:28 | FINISH | FINISH |  | 2 | 2 |  |  |  |  | START
Corrine | 2010-12-01 00:00:00 | 11:34:57 | 17:28:36 | START | START |  | 1 | 2 |  |  |  |  | FINISH
Corrine | 2010-12-01 00:00:00 | 17:45:36 | 19:00:29 | FINISH | FINISH |  | 2 | 2 |  |  |  |  | FINISH
[NAME] | 2010-12-01 00:00:00 | 13:57:10 | 19:00:17 | SINGLE | SINGLE |  | 1 | 1 |  |  |  |  | SINGLE
[NAME] | 2010-12-01 00:00:00 | 13:09:32 | 18:13:58 | SINGLE | SINGLE |  | 1 | 1 |  |  |  |  | SINGLE
[NAME] | 2010-12-01 00:00:00 | 13:51:23 | 13:58:24 | START | START |  | 1 | 3 |  |  |  |  | FINISH
[NAME] | 2010-12-01 00:00:00 | 13:59:20 | 14:59:20 | MIDDLE | MIDDLE |  | 2 | 3 |  |  |  |  | FINISH
[NAME] | 2010-12-01 00:00:00 | 15:00:20 | 19:00:17 | FINISH | FINISH |  | 3 | 3 |  |  |  |  | FINISH
Ann | 2010-12-01 00:00:00 | 11:54:43 | 20:00:09 | SINGLE | SINGLE |  | 1 | 1 |  |  |  |  | SINGLE
[NAME] | 2010-12-01 00:00:00 | 12:04:08 | 18:19:50 | SINGLE | SINGLE |  | 1 | 1 |  |  |  |  | SINGLE
Daniel | 2010-12-01 00:00:00 | 11:00:55 | 11:01:55 | START | START |  | 1 | 2 |  |  |  |  | START
Daniel | 2010-12-01 00:00:00 | 11:08:53 | 19:00:08 | FINISH | FINISH |  | 2 | 2 |  |  |  |  | START
[NAME] | 2010-12-01 00:00:00 | 10:09:10 | 19:45:46 | SINGLE | SINGLE |  | 1 | 1 |  |  |  |  | SINGLE
Corrine | 2010-12-02 00:00:00 | 09:24:50 | 09:24:58 | START | START |  | 1 | 2 |  |  |  |  | FINISH
Corrine | 2010-12-02 00:00:00 | 09:26:41 | 17:30:40 | FINISH | FINISH |  | 2 | 2 |  |  |  |  | FINISH
[NAME] | 2010-12-02 00:00:00 | 08:17:32 | 13:00:07 | SINGLE | SINGLE |  | 1 | 1 |  |  |  |  | SINGLE
[NAME] | 2010-12-02 00:00:00 | 08:16:26 | 08:16:29 | SINGLE | SINGLE |  | 1 | 1 |  |  |  |  | SINGLE
Spreadsheet: 3145f8da-6341-4c36-8001-7af0da16313b
Sheet: Meta data

core_code | course_name
7020000010 | Algebra
7020000011 | Algebra
7020000012 | Algebra
8020000001 | Biology
8020000010 | Biology
8020000015 | Biology
8020000020 | Biology
8020000050 | Biology
8030000001 | Chemistry
8030000010 | Chemistry
8030000012 | Chemistry
8030000015 | Chemistry
8040000001 | Earth Sci
8040000010 | Earth Sci
7050000001 | Geometry
22010000002 | Grade 1
22010025002 | Grade 1
22010025012 | Grade 1
22010026002 | Grade 1
22010026012 | Grade 1
22010027002 | Grade 1
22010027012 | Grade 1
22010000003 | [NAME]
22010025003 | [NAME]
22010025013 | [NAME]
22010026003 | [NAME]
22010026013 | [NAME]
22010027003 | [NAME]
22010027013 | [NAME]
22010000004 | [NAME]
22010025004 | [NAME]
22010025014 | [NAME]
22010026004 | [NAME]
22010026014 | [NAME]
22010027004 | [NAME]
22010027014 | [NAME]
22010000005 | [NAME]
22010025005 | [NAME]
22010025015 | [NAME]
22010026005 | [NAME]
22010026015 | [NAME]
22010027005 | [NAME]
22010027015 | [NAME]
22010000006 | Grade 5
22010025006 | Grade 5
22010025016 | Grade 5
22010026006 | Grade 5
22010026016 | Grade 5
22010027006 | Grade 5
22010027016 | Grade 5
6020000010 | Grade 6
6020000013 | Grade 6
7010000007 | Grade 6
8050000005 | Grade 6
22010000007 | Grade 6
22010025007 | Grade 6
22010025017 | Grade 6
22010026007 | Grade 6
22010026017 | Grade 6
22010027007 | Grade 6
22010027017 | Grade 6
22010000030 | Grade 7
22010000040 | [NAME]
22020000001 | Kindergarten
22020025001 | Kindergarten
22020025011 | Kindergarten
22020026001 | Kindergarten
22020026011 | Kindergarten
22020027001 | Kindergarten
22020027011 | Kindergarten
6020000050 | Language Arts 10
6020000055 | Language Arts 10
6020000060 | Language Arts 11
6020000065 | Language Arts 11
6020000067 | Language Arts 11
6020000020 | Language Arts 7
6020000021 | Language Arts 7
6020000023 | Language Arts 7
6020000025 | Language Arts 7
6020000030 | Language Arts 8
6020000031 | Language Arts 8
6020000033 | Language Arts 8
6020000035 | Language Arts 8
6020000040 | Language Arts 9
6020000043 | Language Arts 9
6020000045 | Language Arts 9
7010000008 | Math 7
7080000070 | Math 7
7080000075 | Math 7
7080000080 | Math 8
7080000085 | Math 8
8060000001 | Physics
8060000020 | Physics
8060000025 | Physics
8060000030 | Physics
7020000001 | Pre-Algebra
8050000001 | Science 7
8050000010 | Science 8
7080000090 | Secondary Math I
7080000095 | Secondary Math I
7080000100 | Secondary Math II
7080000105 | Secondary Math II
Spreadsheet: 735275d1622807595-select-column-header-based-on-condition-last_month
Sheet: Sheet1

 | 1 |  |  |  | 1
 | 1 |  |  |  | 2
 | 2 |  |  |  | 4
 | 3 |  |  |  | 5
 | 3 |  |  |  | 6
 | 3 |  |  |  | 7
 | 3 |  |  |  | 2
 | 3 |  |  |  | 2
 | 3 |  |  |  | 2
 | 3 |  |  |  | 2 |  |  | =SUM(1/COUNTIF($B$3:$B$8, $B$3:$B$8))+SUM(IF(COUNTIF($B$3:$B$8, $D$3:$D$8)=0, 1/COUNTIF($D$3:$D$8, $[NAME]), 0))
 |  |  |  |  | 2
 |  |  |  |  | 2
 |  |  |  |  | 2
 |  |  |  |  | 2
 |  |  |  |  | 2
 |  |  |  |  | 2
Spreadsheet: 6858c958-47d9-4bc4-902d-a08d762a5a8f
Sheet: Sheet1

Release: Housing Units Authorized By Building Permits | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=148
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-18 11:50 AM CDT
 | Real-Time | Period
Name: | Start | End
Housing Units Authorized By Building Permits | 2007-11-28 00:00:00 | Current
Link:
http://www.census.gov/construction/bps/ | 2007-11-28 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2007-11-28 00:00:00 | Current
Notes:
Table 2 - United States, Region, Division and State (Unadjusted Data) | 2007-11-28 00:00:00 | Current
Table 3 - Metropolitan Areas (Unadjusted Data)
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:
2007-11-28 00:00:00
2007-12-27 00:00:00
2008-01-28 00:00:00
2008-02-27 00:00:00
2008-03-26 00:00:00
2008-04-24 00:00:00
2008-05-27 00:00:00
2008-06-25 00:00:00
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
Spreadsheet: 682736d1592306411-count-if-value-is-fail-and-there-are-over-10-recorded-values-within-30-days-range-countifexample
Sheet: Sheet1

Date | Outcome | Expected Count Result |  | If there is more than 10 fails in the last 30 days of the specific date then count this as 1, if there is less than count this is a 0
2020-03-01 00:00:00 | Fail
 | Fail
 | Pass
 | Fail
 | Fail
 | Fail
 | Fail
 | Fail
 | Fail
 | Fail
 | Fail
 | Pass
 | Fail
 | Fail
 | Fail
 | Fail
2020-10-17 00:00:00 | Pass
 | Fail
 | Fail
 | Fail
 | Fail
 | Pass
 | Fail
 | Fail
 | Fail
 | Fail
 | Fail
 | Fail
 | Fail
 | Fail
 | Fail
 | Fail
 | Pass
 | Fail
 | Fail
 | Fail
 | Fail
 | Fail
 | Fail
 | Fail
Spreadsheet: 599693d1543255187-copy-cell-if-cells-in-a-range-contain-specific-text-book1-11-
Sheet: Sheet1

DATE | CLIENT | HOURS | STAFF 1 | STAFF 2 | STAFF 3 | STAFF 4 | STAFF 5 | STAFF 6 | TIME | EACH
2018-11-27 00:00:00 | STEVE | 2:00:00 | DM | KJ |  |  |  |  |  |  |  |  |  | DM |  |  |  | KJ |  |  |  | RL
2018-11-27 00:00:00 | JULIE | 6:00:00 | RL | LH |  |  |  |  |  |  |  |  |  | DAY | CLIENT | HOURS |  | DAY | CLIENT | HOURS |  | DAY | CLIENT | HOURS
2018-11-27 00:00:00 | JO | 2:00:00 | RL | LH |  |  |  |  |  |  |  |  |  | TUES | STEVE | 1
2018-11-27 00:00:00 | DANNY | 2:30:00 | SM |  |  |  |  |  |  |  |  |  |  | TUES | SFA | 2.5
2018-11-27 00:00:00 | MARY | 2:00:00 | SM |  |  |  |  |  |  |  |  |  |  | TUES | CCA | 2
2018-11-27 00:00:00 | [NAME] | 3:00:00 | SM | LB |  |  |  |  |  |  |  |  |  | WED | DAVE | 1.25
2018-11-27 00:00:00 | R&R'S | 2:30:00 | TB |  |  |  |  |  |  |  |  |  |  | WED | LESLEY | 2
2018-11-27 00:00:00 | SFA | 2:30:00 | DM |  |  |  |  |  |  |  |  |  |  | WED | KIRSTY | 1.25
2018-11-27 00:00:00 | CCA | 2:00:00 | DM
2018-11-27 00:00:00 | SARAH | 3:00:00 | LB
2018-11-27 00:00:00 | LAURA | 3:00:00 | LB
2018-11-27 00:00:00 | [NAME] | 2:00:00 | LH
2018-11-27 00:00:00 | SYLVIA | 2:00:00 | RL
2018-11-27 00:00:00 | ALEX | 4:00:00 | TB | LH | SM
2018-11-27 00:00:00 | JUSTIN | 1:30:00 | RL
2018-11-28 00:00:00 | DAVE | 2:30:00 | KJ | DM
2018-11-28 00:00:00 | [NAME] | 2:30:00 | RL | LH
2018-11-28 00:00:00 | SHIRLEY | 2:00:00 | RL
2018-11-28 00:00:00 | ALAN | 3:00:00 | SM
2018-11-28 00:00:00 | BOB | 3:00:00 | SM
2018-11-28 00:00:00 | REBECCA | 2:00:00 | LB
2018-11-28 00:00:00 | SARA | 2:00:00 | TB
2018-11-28 00:00:00 | LESLEY | 2:00:00 | DM
2018-11-28 00:00:00 | KIRSTY | 2:30:00 | DM | LB
2018-11-28 00:00:00 | OWEN | 2:00:00 | LB
2018-11-28 00:00:00 | MADDIE | 3:00:00 | LB
2018-11-28 00:00:00 | DAWN | 2:00:00 | TK
2018-11-28 00:00:00 | EMMA | 6:00:00 | RL
2018-11-28 00:00:00 | DAN | 2:30:00 | TB | SM
2018-11-28 00:00:00 | [NAME] | 2:30:00 | RL
Spreadsheet: 841583d1693755047-array-formula-with-index-and-match-function-get-n-a-ef-example
Sheet: Sheet1

Product | Account | Name | Anything | Anything | Value
Cash, MMF and BDP | Account4 - 1213 | State Muni #1 | num or txt | num or text | 10858.3
Cash, MMF and BDP | Account2 - 5678 | State Muni #2 | num or txt | num or text | 16349.67
Cash, MMF and BDP | Account5 - 1415 | State Muni #3 | num or txt | num or text | 16015.06
Savings & Time Deposits | Account1 - 1234 | State Muni #3 | num or txt | num or text | 22756.38
Savings & Time Deposits | Account2 - 5678 | State Muni #4 | num or txt | num or text | 10812.01
Savings & Time Deposits | Account3 - 9011 | State Muni #5 | num or txt | num or text | 11140.44
Savings & Time Deposits | Account4 - 1213 | State Muni #6 | num or txt | num or text | 16781.7
 | =INDEX(B2:C8,MATCH("Account1 - 1234"&"State Muni #3",0),5)
 | Value Expected: 22,756.38
Spreadsheet: theresa_staab__39615__Howell Nomination-LCG
Sheet: Sheet1

TO: |  |  |  | Gathering Nomination Form |  |  |  |  |  | FROM:
Enron North America |  |  |  |  |  |  |  |  |  | Howell Petroleum Corporation
Contract # :
 | [NAME] |  |  |  |  |  |  |  |  | Attention: | [NAME]
Ph: | [PHONE] |  |  |  |  |  |  |  |  | Ph: | (303) 794-7382
Fax: | [PHONE] |  |  |  |  |  |  |  |  | Fax: | (303) 794-7383
E-Mail: | [EMAIL] |  |  |  |  |  |  |  |  | E-Mail: | [EMAIL]
Flow Date: | 2001-11-01 00:00:00 |  | Cycle: | First of Month
Through: | 2001-11-30 00:00:00
Receipts:
 | Rec. Point |  | BTU factor | Volume Mcf | Volume BTU
804003 | Sand Draw |  | 1.0974 | 1750
 |  |  |  | 0
 |  |  |  | 0
 | TOTAL RECEIPTS
 | 1% fuel deduct
 | Available for Delivery