tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 463093d1464290709-trying-to-match-unique-values-in-single-column-against-multiple-columns-test-isnumber-index-match
Sheet: L2

[NAME] | FN | LN | Dept
[EMAIL] |  | Billy | HR
[EMAIL] | [NAME] | [NAME] | Finance
[EMAIL] | [NAME] | [NAME] | Finance
[EMAIL] | [NAME] | [NAME] | Finance
[EMAIL] | [NAME] | Charlies | IT
[EMAIL] | [NAME] | Charlies | IT
Spreadsheet: 169335d1342786969-countif-problem-with-formule-inside-excelq-countifs
Sheet: Sheet1

 |  |  |  |  |  | TRADE DATE | [NAME] want to do without!!
 |  |  |  |  |  | 2012-05-15 00:00:00 |  |  |  |  |  |  | 2012-07-16 00:00:00 | 2012-07-17 00:00:00 | 2012-07-18 00:00:00 | 2012-07-19 00:00:00 | 2012-07-20 00:00:00
 |  |  |  |  |  | 2012-05-16 00:00:00
 |  |  |  |  |  | 2012-05-17 00:00:00 |  |  |  |  |  | ANSWER HAS TO BE:
 |  |  |  |  |  | 2012-05-22 00:00:00
 |  |  |  |  |  | 2012-05-22 00:00:00
 |  |  |  |  |  | 2012-05-22 00:00:00
 |  |  |  |  |  | 2012-05-27 00:00:00
 |  |  |  |  |  | 2012-05-27 00:00:00
 |  |  |  |  |  | 2012-06-02 00:00:00
 |  |  |  |  |  | 2012-06-04 00:00:00
 |  |  |  |  |  | 2012-06-08 00:00:00
 |  |  |  |  |  | 2012-06-09 00:00:00
 |  |  |  |  |  | 2012-06-09 00:00:00
 |  |  |  |  |  | 2012-06-10 00:00:00
 |  |  |  |  |  | 2012-06-11 00:00:00
 |  |  |  |  |  | 2012-06-11 00:00:00
 |  |  |  |  |  | 2012-06-11 00:00:00
 |  |  |  |  |  | 2012-06-11 00:00:00
 |  |  |  |  |  | 2012-06-12 00:00:00
 |  |  |  |  |  | 2012-06-12 00:00:00
 |  |  |  |  |  | 2012-06-13 00:00:00
 |  |  |  |  |  | 2012-06-14 00:00:00
 |  |  |  |  |  | 2012-06-15 00:00:00
 |  |  |  |  |  | 2012-06-15 00:00:00
 |  |  |  |  |  | 2012-06-16 00:00:00
 |  |  |  |  |  | 2012-06-16 00:00:00
 |  |  |  |  |  | 2012-06-17 00:00:00
 |  |  |  |  |  | 2012-06-17 00:00:00
 |  |  |  |  |  | 2012-06-17 00:00:00
 |  |  |  |  |  | 2012-06-18 00:00:00
 |  |  |  |  |  | 2012-06-18 00:00:00
 |  |  |  |  |  | 2012-06-19 00:00:00
 |  |  |  |  |  | 2012-06-19 00:00:00
 |  |  |  |  |  | 2012-06-20 00:00:00
 |  |  |  |  |  | 2012-06-20 00:00:00
 |  |  |  |  |  | 2012-06-20 00:00:00
 |  |  |  |  |  | 2012-06-21 00:00:00
 |  |  |  |  |  | 2012-06-21 00:00:00
 |  |  |  |  |  | 2012-06-22 00:00:00
 |  |  |  |  |  | 2012-06-22 00:00:00
 |  |  |  |  |  | 2012-06-23 00:00:00
 |  |  |  |  |  | 2012-06-24 00:00:00
 |  |  |  |  |  | 2012-06-25 00:00:00
 |  |  |  |  |  | 2012-06-25 00:00:00
 |  |  |  |  |  | 2012-06-25 00:00:00
 |  |  |  |  |  | 2012-06-26 00:00:00
 |  |  |  |  |  | 2012-06-26 00:00:00
 |  |  |  |  |  | 2012-06-27 00:00:00
 |  |  |  |  |  | 2012-06-27 00:00:00
 |  |  |  |  |  | 2012-06-28 00:00:00
 |  |  |  |  |  | 2012-06-29 00:00:00
 |  |  |  |  |  | 2012-06-29 00:00:00
 |  |  |  |  |  | 2012-06-30 00:00:00
 |  |  |  |  |  | 2012-06-30 00:00:00
 |  |  |  |  |  | 2012-07-01 00:00:00
 |  |  |  |  |  | 2012-07-02 00:00:00
 |  |  |  |  |  | 2012-07-03 00:00:00
 |  |  |  |  |  | 2012-07-04 00:00:00
 |  |  |  |  |  | 2012-07-05 00:00:00
 |  |  |  |  |  | 2012-07-06 00:00:00
 |  |  |  |  |  | 2012-07-06 00:00:00
 |  |  |  |  |  | 2012-07-06 00:00:00
 |  |  |  |  |  | 2012-07-07 00:00:00
 |  |  |  |  |  | 2012-07-08 00:00:00
 |  |  |  |  |  | 2012-07-09 00:00:00
 |  |  |  |  |  | 2012-07-09 00:00:00
 |  |  |  |  |  | 2012-07-10 00:00:00
 |  |  |  |  |  | 2012-07-10 00:00:00
 |  |  |  |  |  | 2012-07-10 00:00:00
 |  |  |  |  |  | 2012-07-11 00:00:00
 |  |  |  |  |  | 2012-07-12 00:00:00
 |  |  |  |  |  | 2012-07-13 00:00:00
 |  |  |  |  |  | 2012-09-03 00:00:00
Spreadsheet: 694281d1599498653-merge-cells-merge-cell-07_09-richard
Sheet: Foglio1

 |  | RICHARD BUTTREY
 | 123456
 | lo.: A2345678     ASD ASD ASD
 | 123456 |  | <<< example in B2 if 123456 work, if AAA 123456 not work
 | 12345711
 | AAAA-12345678     ASDAS OEOE KKDK
 | 99978844
 | [NAME] 1237888     KAKA [NAME]
 | 123456
 | 9997888
 | AAAA-99888     KAKA DQQ ERR
Spreadsheet: 722662d1615365407-inventory-stock-formula-book1
Sheet: Stock IN

 | Item Name | Code | Shipped To | Date | Quantity
 | Womens T Shirt | 123 | Karratha | 2020-08-01 00:00:00 | 30
 | [NAME] | 456 | Port Hedland | 2020-12-12 00:00:00 | 50
 | Pants | 789 | Perth | 2020-12-30 00:00:00 | 90
 | Jeans | 987 | Brisbane | 2021-01-01 00:00:00 | 80
 | Boots | 321 | Christmas Creek | 2021-02-06 00:00:00 | 30
 | Womens T Shirt | 123 | Karratha | 2020-08-01 00:00:00 | 100
 | [NAME] | 456 | Port Hedland | 2020-12-12 00:00:00 | 25
 | Pants | 789 | Perth | 2020-12-30 00:00:00 | 32
 | Jeans | 987 | Brisbane | 2021-01-01 00:00:00 | 47
 | Boots | 321 | Christmas Creek | 2021-02-06 00:00:00 | 52
 | Womens T Shirt | 123 | Karratha | 2020-08-01 00:00:00 | 98
 | [NAME] | 456 | Port Hedland | 2020-12-12 00:00:00 | 65
 | Pants | 789 | Perth | 2020-12-30 00:00:00 | 78
 | Jeans | 987 | Brisbane | 2021-01-01 00:00:00 | 25
 | Boots | 321 | Christmas Creek | 2021-02-06 00:00:00 | 36
 | Womens T Shirt | 123 | Karratha | 2020-08-01 00:00:00 | 45
 | [NAME] | 456 | Port Hedland | 2020-12-12 00:00:00 | 56
 | Pants | 789 | Perth | 2020-12-30 00:00:00 | 65
 | Jeans | 987 | Brisbane | 2021-01-01 00:00:00 | 85
 | Boots | 321 | Christmas Creek | 2021-02-06 00:00:00 | 25
Spreadsheet: 712044d1610029807-sum-if-cell-reference-question-project-cash-flow-test-document
Sheet: Project Info

 | Project Name | Test
 | Project Commencement Year | 2020
 | Project Start Date | 2020-05-25 00:00:00
 | Credit Report Name
 | Credit Report Score
 | Credit Report Balance Sheet Review Date
 | Credit Report Directors Sign off Date
 | Next Review Date
 | Project Terms - Cash In only
 | Advanced Payment Terms | 0
 | Deposit Terms | 0
 | Gross Application | 21
 | CIS Deduction Terms | 0
 | Retention PC | 180
 | Retention Final | 365
 | Rebate | 0
Spreadsheet: 3b16176a-3a45-4283-bb62-5454ac60fca1
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
ESYC | Test | ESYC | Eastern Sycamore, IgE | Eastern Sycamore, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
ESYC | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ESYC | Result | ESYC | Eastern Sycamore, IgE | Eastern Sycamore, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6263-8
Spreadsheet: 468313d1467224506-finding-lookup-result-over-multiple-tabs-oeldere-468312d1467223790-finding-lookup-result-over-multiple-tabs-isna-help-file
Sheet: Oeldere

[NAME] | 500g box | Dry goods
Sugar | 1kg packet | Dry goods
Beans | 100g portions | Dry goods
Shampoo | 100ml bottle | housekeeping
soap bar | each | housekeeping
handy [NAME] | [NAME] bottle | housekeeping
diesel | 5l jerrycan | maintenance
PVA paint | 10l tin | maintenance
Spreadsheet: 689618d1596554893-filtering-properly-based-on-user-choices-test_resultsva
Sheet: Tests

StndPDL | StndNumb | StndName | StndTstQ | StndID
Select Standard From List | Standard No. | Standard Name | No. of Questions | Standard ID |  | SELECT | Firefighter Level II |  |  | Fire Officer  Level II | Fire Inspector Level II |  | Fire and Life Safety Educator II | Fire Service Instructor II | Telecommunicator II | Hazardous Materials Awareness - Skills
NA 1001 - Level 1 | NA 1001 | Level 1 | 75 | 1 |  | Pass |  |  |  |  |  |  | Public Information Officer |  |  | Hazardous Materials Operations
NA 1001 - Level II | NA 1001 | Level II | 25 | 2 |  | Fail |  |  |  |  |  |  |  |  |  | Hazardous Materials Technician
NA 1002 - Level 3 | NA 1003 | Level 3 | 50 | 3 |  |  |  |  |  |  |  |  |  |  |  | Hazardous Materials Mission Specific
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6 |  | SELECT FROM DROP DOWN
 |  |  |  | 7 |  | NFPA 1001
 |  |  |  | 8 |  | NFPA 1002
 |  |  |  | 9 |  | NFPA 1006
 |  |  |  | 10 |  | NFPA 1021
 |  |  |  | 11 |  | NFPA 1031
 |  |  |  | 12 |  | NFPA 1033
 |  |  |  | 13 |  | NFPA 1035
 |  |  |  | 14 |  | NFPA 1041
 |  |  |  | 15 |  | NFPA 1061
 |  |  |  | 16 |  | NFPA 1072
 |  |  |  | 39 |  | NFPA 1521
 |  |  |  | 17
 |  |  |  | 18
 |  |  |  | 21
 |  |  |  | 19
 |  |  |  | 20
 |  |  |  | 27
 |  |  |  | 22
 |  |  |  |  |  | SELECT FROM DROP DOWN
 |  |  |  |  |  | 20
 |  |  |  |  |  | 25
 |  |  |  |  |  | 50
 |  |  |  |  |  | 100
Spreadsheet: 847229d1698252384-correct-if-iserror-search-formula-re-sample
Sheet: RE Batch Table

Batch number | Description | Created By | Created On | [NAME] | Times Committed | Org | CC: T/F | AccCode | Column1 | Column2
26024 | AK CC - 7.2 to 7.8.23 Friends Place WPH | MYohannes | 2023-07-11 00:00:00 | [NAME] | 1
26131 | AK CC - Disbursed 8-15-23 Friends Place - $1,400.00 | MYohannes | 2023-08-23 00:00:00 | [NAME] | 1
26132 | EDF - August 23, 2023 - $5,700.00 | MYohannes | 2023-08-24 00:00:00 | [NAME] | 1
26133 | FCNL - August 23, 2023 - $7,000.00 | MYohannes | 2023-08-24 00:00:00 | [NAME] | 1
26134 | WPH - August 23, 2023 - $1,000.00 | MYohannes | 2023-08-24 00:00:00 | [NAME] | 1
26211 | AK CC - Disbursed 9-8-23 Friends Place WPH - $1,968.75 | MYohannes | 2023-09-14 00:00:00 | [NAME] | 1
26212 | WPH - September 14, 2023 - $3,375.00 | MYohannes | 2023-09-15 00:00:00 | [NAME] | 1
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Trilogy

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2018-03-17 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2018-03-17 00:00:00 |  |  |  | No Monies Received 2016 Letter sent 19/3/17
Spreadsheet: 812181d1673008817-use-vlookup-across-two-different-sheets-test-course-codes-and-urls
Sheet: Sheet2

Course Code | Link
[NAME]
AC102
AC103
AC200
AC311
AC312
AC331
AC332
AC341
AC342
AC411
AC412
AC415
AC416
[NAME]
AC424
AC425
AC444
AC470
[NAME]
AC490
[NAME]
AC493
AC499
AC500
AC501
[NAME]
[NAME]
AC506
AC507
AC599
Spreadsheet: sally_beck__35165__Global Hot List 0921
Sheet: Hotlist - Completed

E N R O N   G L O B A L   M A R K E T S  -  H O T  L I S T |  |  |  |  |  |  |  |  |  |  |  | 3Q00 DEALS COMPLETED
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  |  |  |  |  |  |  | South Star |  | 26
 |  | SUBTOTAL
 |  |  |  |  |  |  |  | SUBTOTAL
 |  | Coal Origination & Finance
 |  | Deal |  | Value |  |  |  | Global Risk Markets
 |  | Freight Liner |  | 250 |  |  |  | Deal |  | Value
 |  | SynFuel - Sempra |  | 0
 |  | NoxTech |  | 0
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  |  |  |  |  |  |  | TOTAL DEALS COMPLETED
Spreadsheet: 0c1d1b68-ec7a-4ce8-b7a8-3a619991ef7b
Sheet: Sheet1

TAYLOR POLICE DEPARTMENT RACIAL PROFILING DATA | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
Traffic Citations |  | pct. |  | pct. |  |  |  |  |  |  |  | pct | of cites no DL
 | 2007 |  | 2006
African American | 421 | 0.1274984857662023 | 550 | 0.1156190876602901
Hispanic | 1138 | 0.3446396123561478 | 1450 | 0.3048139583771284
White, non-Hispanic | 1705 | 0.5163537250151423 | 2704 | 0.5684254782425898
Other | 38 | 0.01150817686250757 | 53 | 0.01114147571999159
total | 3302 |  | 4757
Arrest Totals |  | pct.
(number is derived from total number of charges) | 2007 |  | 2006 | pct.
African American | 266 | 0.2926292629262927 | 264 | 0.2621648460774578
Hispanic | 367 | 0.4037403740374038 | 433 | 0.4299900695134062
White, non-Hispanic | 272 | 0.2992299229922992 | 301 | 0.2989076464746773
Other | 4 | 0.0044004400440044 | 9 | 0.00893743793445879
total | 909 |  | 1007
Vehicle Searches 2007 |  | pct. | consent | probable cause
African American | 29 | 0.2357723577235772 | 17 | 12
Hispanic | 44 | 0.3577235772357724 | 27 | 17
White, non-Hispanic | 50 | 0.4065040650406504 | 33 | 17
Other | 1 | 0.008130081300813009 |  | 1
total | 123 |  | 77 | 47
Arrests from Traffic 2007 |  | pct. | 2006
(number is derived from total number of charges)
African American | 80 | 0.273972602739726
Hispanic | 100 | 0.3424657534246575
White, non-Hispanic | 110 | 0.3767123287671233
Other | 2 | 0.00684931506849315
total | 292
Spreadsheet: 860109d1708336643-exponential-scientific-e-numbers-logost-test
Sheet: 20240219_02461038_WNF

Stellplatz1 | Stellplatz2 | Letztes Inventurdatum | SSCC
110 | 11E02 | 20230720 | 3.40541352062736e+17
1100000 | 11E06 | 20230828 | 3.40541352063726e+17
110000000 | 11E08 | 20230828 | 3.40541352063821e+17
1100000000000 | 11E12 | 20230504 | 3.40541352063793e+17
3e+16 | 3E16 | 20230505 | 3.40541352063645e+17
Spreadsheet: 123303d1317535698-print-one-address-yard-sale-roster-2011-03
Sheet: Sheet1

 | [NAME] Schedule
 | Friday | 2011-10-07 00:00:00 | 8 A - Noon | Name 1 | Front
 |  | 2011-10-07 00:00:00 | 8 A - Noon | Name 2 | Back
 |  | 2011-10-07 00:00:00 | 8 A - Noon | Name 3 | Stroller
 |  | 2011-10-07 00:00:00 | Noon - 4 P | Name 4 | Front
 |  | 2011-10-07 00:00:00 | Noon - 4 P | Name 5 | Back
 |  | 2011-10-07 00:00:00 | Noon - 4 P | Name 6 | Stroller
 | Saturday | 2011-10-08 00:00:00 | 8 A - Noon | Name 1 | Front
 |  | 2011-10-08 00:00:00 | 8 A - Noon | Name 2 | Back
 |  | 2011-10-08 00:00:00 | 8 A - Noon | Name 7 | Stroller
 |  | 2011-10-08 00:00:00 | Noon - 4 P | Name 8 | Front
 |  | 2011-10-08 00:00:00 | Noon - 4 P | Name 9 | Back
 |  | 2011-10-08 00:00:00 | Noon - 4 P | Name 4 | Stroller
 | Sunday | 2011-10-09 00:00:00 | 8 A - Noon | Name 5 | Front
 |  | 2011-10-09 00:00:00 | 8 A - Noon | Name 9 | Back
 |  | 2011-10-09 00:00:00 | 8 A - Noon | Name 6 | Stroller
 |  | 2011-10-09 00:00:00 | Noon - 4 P | Name 8 | Front
 |  | 2011-10-09 00:00:00 | Noon - 4 P | Name 10 | Back
 |  | 2011-10-09 00:00:00 | Noon - 4 P | Name 3 | Stroller
 | Standby |  |  | Name 11
 |  |  |  | Name 12
 |  |  |  | Name 13
 |  |  |  | Name 5 (would fill in)
Spreadsheet: 143053d1330164513-how-to-find-from-find-and-replace-command-formula-generated-number-sample
Sheet: Sheet1

SN | Name
110050 | A
 | B
 | C
 | D
 | E
 |  | I want to find from "Find and Replace" Command
Spreadsheet: 55971d1256128218-getting-values-of-scatter-704124
Sheet: Sheet1

1e-15 | 33.96
2e-15 | 33.27
3e-15 | 32.86 |  | Enter Value | 0.04
4e-15 | 32.58 |  | Closest lookup
5e-15 | 32.35 |  | Index position
6e-15 | 32.17 |  | [NAME]
7e-15 | 32.02 |  | Value Right
8e-15 | 31.88
9e-15 | 31.76
1e-14 | 31.66
2e-14 | 30.97
3e-14 | 30.56
4e-14 | 30.27
5e-14 | 30.05
6e-14 | 29.87
7e-14 | 29.71
8e-14 | 29.58
9e-14 | 29.46
1e-13 | 29.36
2e-13 | 28.66
3e-13 | 28.26
4e-13 | 27.97
5e-13 | 27.75
6e-13 | 27.56
7e-13 | 27.41
8e-13 | 27.28
9e-13 | 27.16
1e-12 | 27.05
2e-12 | 26.36
3e-12 | 25.96
4e-12 | 25.67
5e-12 | 25.44
6e-12 | 25.26
7e-12 | 25.11
8e-12 | 24.97
9e-12 | 24.86
1e-11 | 24.75
2e-11 | 24.06
3e-11 | 23.65
4e-11 | 23.36
5e-11 | 23.14
6e-11 | 22.96
7e-11 | 22.81
8e-11 | 22.67
9e-11 | 22.55
1e-10 | 22.45
2e-10 | 21.76
3e-10 | 21.35
4e-10 | 21.06
5e-10 | 20.84
6e-10 | 20.66
7e-10 | 20.5
8e-10 | 20.37
9e-10 | 20.25
1e-09 | 20.15
2e-09 | 19.45
3e-09 | 19.05
4e-09 | 18.76
5e-09 | 18.54
6e-09 | 18.35
7e-09 | 18.2
8e-09 | 18.07
9e-09 | 17.95
1e-08 | 17.84
2e-08 | 17.15
3e-08 | 16.74
4e-08 | 16.46
5e-08 | 16.23
6e-08 | 16.05
7e-08 | 15.9
8e-08 | 15.76
9e-08 | 15.65
1e-07 | 15.54
2e-07 | 14.85
3e-07 | 14.44
4e-07 | 14.15
5e-07 | 13.93
6e-07 | 13.75
7e-07 | 13.6
8e-07 | 13.46
9e-07 | 13.34
1e-06 | 13.24
2e-06 | 12.55
3e-06 | 12.14
4e-06 | 11.85
5e-06 | 11.63
6e-06 | 11.45
7e-06 | 11.29
8e-06 | 11.16
9e-06 | 11.04
1e-05 | 10.94
2e-05 | 10.24
3e-05 | 9.84
4e-05 | 9.55
5e-05 | 9.33
6e-05 | 9.14
7e-05 | 8.99
8e-05 | 8.86
9e-05 | 8.74
0.0001 | 8.63
0.0002 | 7.94
0.0003 | 7.53
0.0004 | 7.25
0.0005 | 7.02
0.0006 | 6.84
0.0007 | 6.69
0.0008 | 6.55
0.0009 | 6.44
0.001 | 6.33
0.002 | 5.64
0.003 | 5.23
0.004 | 4.95
0.005 | 4.73
0.006 | 4.54
0.007 | 4.39
0.008 | 4.26
0.009 | 4.14
0.01 | 4.04
0.02 | 3.35
0.03 | 2.96
0.04 | 2.68
0.05 | 2.47
0.06 | 2.3
0.07 | 2.15
0.08 | 2.03
0.09 | 1.92
0.1 | 1.82
0.2 | 1.22
0.3 | 0.91
0.4 | 0.7
0.5 | 0.56
0.6 | 0.45
0.7 | 0.37
0.8 | 0.31
0.9 | 0.26
Spreadsheet: 570cf09e-f974-4111-8cec-343fd9b9812b
Sheet: Customer

Forward Capacity Market Capacity Load Obligation Settlement Detail Report |  |  |  |  |  |  |  |  |  | Forward Capacity Market Capacity Load Obligation Settlement Detail Report
SD_FCMCLOSTLDTL_<customer id>_<settlement_date>_<version>.CSV |  |  |  |  |  |  |  |  |  | SD_FCMCLOSTLDTL_<customer id>_<settlement_date>_<version>.CSV
<[NAME] |  |  |  |  |  |  |  |  |  | <[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Capacity Zone ID | Capacity Zone Name | Customer Peak Contributions | Customer Capacity Requirement | Customer Capacity Load Obligation Bilateral MW | Customer HQICC | Customer Capacity Zone Designated FCA Self-Supplied MW | Customer Capacity Load Obligation | Net Regional Clearing Price | Customer Capacity Load Obligation Charge | Customer Specifically Allocated CTR  for Pool  Planned Units | Customer  Specifically  Allocated CTR  Credit for Pool  Planned Units | Customer Specifically Allocated CTR for Transmission Upgrade | Customer Specifically Allocated CTR Credit for Transmission Upgrade | Customer Specifically Allocated CTR Credit | Customer Residual CTR Fund Distribution Allocation MW | Customer Residual CTR Fund Credit | Customer CTR Credit
Number | String | MW | MW | MW | MW | MW | MW | $/kW-Month | $ | MW | $ | MW | $ | $ | MW | $ | $
Spreadsheet: 78836d1279132914-weighted-average-in-a-pivot-table-example-pivot-table
Sheet: Pivot Table

 | Values
Row Labels | Average of Statusing | Average of Appearance | Average of Clean Up | Average of Verify System | Average of Explain Basic
010430500 | 10 | 10 | 10 | 10 | 10
010431849 | 10 | 10 | 9 | 10 | 10
010432971 | 8.666666666666666 | 8 | 8 | 8 | 8
010434011 | 8.5 | 9.666666666666666 | 9.5 | 10 | 8.5
010434315 | 8.25 | 8.5 | 8.333333333333334 | 8.666666666666666 | 9.25
010436524 | 10 | 10 |  |  | 10
010436687 | 10 | 9 | 10 | 10 | 10
010436835 | 10 | 10 | 10 | 10 | 10
010436895 | 9.666666666666666 | 9.666666666666666 | 9.5 | 9.75 | 8.833333333333334
010438940 | 10 | 10 | 10 | 10 | 10
010439230 | 9 | 8.75 | 8.333333333333334 | 7.333333333333333 | 8.75
010439568 | 10 | 10 | 10 | 10 | 10
010439829 | 10 | 10 | 6.5 | 10 | 7
010439857 | 10 | 10 | 10 | 8.5 | 10
010439889 | 8.5 | 9 | 10 | 10 | 10
Grand Total | 9.30952380952381 | 9.404761904761905 | 9.161290322580646 | 9.35483870967742 | 9.142857142857142
 | This data has the true scores, but when the Technicians get their average, it is actually a weighted average.  Everything below 7 is counted as a 0. |  |  | We want to retain the actual score on the raw data sheet, that is not to be lost, but when it is put into the pivot table, the 0-6 need to count as 0, while the 7 counts as a 7 and the 8 as an 8 ect up to 10.
Spreadsheet: 830794d1685115538-vlookup-formula-to-grab-most-future-date-example
Sheet: Sheet1

 | what I have |  |  | What I would like
 | Item | Date |  | Item | latest date
 | apples | 2023-05-26 00:00:00 |  | apples | 2023-05-26 00:00:00
 | apples | 2023-05-04 00:00:00 |  | oranges | 2023-06-10 00:00:00
 | apples | 2023-05-15 00:00:00
 | oranges | 2023-05-01 00:00:00
 | oranges | 2023-06-10 00:00:00
 | oranges | 2023-05-15 00:00:00
Spreadsheet: sally_beck__34340__2002 Budget Edie Format
Sheet: EOPs

 | Energy Operations
 | 2002 Plan
 | Includes Gas Logistics |  |  |  |  |  |  | Energy Operations
 | Does not include Canada Operations
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % of | 2002 |  | Per HC | New HC | Adj Comp |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Total Exp | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  | 10256048
 | Special Pays | 0 |  |  |  |  | 0 | Compensation | 0
 | Analyst & Assoicate | 0 |  |  |  |  | 1791219
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | 2543410
ENAEMPEX | Employee Expense |  |  |  |  |  | 305015 | Other
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 355560
ENAOUTSV | Outside Services | 0 |  |  |  |  |  | Total |  |  |  |  | 36500125
ENASUPP | Supplies Expense |  |  |  |  |  | 353392
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 37500 |  |  |  | 1.25
ENARENT | Rent |  |  |  |  |  | 1453200 | Admins | 52500
ENATECH | Technology |  |  | 145000 |  |  | 310400 | Staff | 56250
ENATRANS | Transportation |  |  |  |  |  |  | Associate | 75000
ENAOTHEX | Other Expenses |  |  |  |  |  | 0 | Analysts | 60000
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Specialist | 65000
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialist | 82500
 |  |  |  |  |  |  |  | Managers | 100000
 | Headcount |  |  | 114 |  |  | 169 | Directors | 145000
 |  |  |  |  |  |  |  | Sr Director | 175000
 | A&A Headcount |  |  | 4 |  |  | 0 | Vice President | 237500
 |  |  |  |  |  |  |  | [NAME] | 312500 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  |  | Based on information from ENW accounting.