tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2fee095b-6a1a-4aa1-bf4a-b9a06290a295
Sheet: Sheet1

Product: | Microsoft SharePoint Server 2010
Worksheet title: | Variations planning data worksheet
Related content: | Plan variations
Prepared by:
Date:
Instructions: | 1. Record the URL for the variations root site in the space provided below.
 | 2. Record the source variation site for your solution in the top row of the Sites data sheet tab. Enter the following:
 | The label as you want it to display in the site URL.
 | The label display name as you want it to appear in the site navigation.
 | The language and locale to associate with the site (if applicable).
 | The name of the site owner who will be responsible for the site.
 | The name of the person responsible for translating site content (if applicable).
 | 3. For each target variation site, enter the following:
 | The label as you want it to appear in the site URL.
 | The label display name as you want it to appear in the site navigation.
 | The language and locale to associate with the site (if applicable).
 | The name of the site owner who will be responsible for the site.
 | The name of the person responsible for translating site content (if applicable).
Root site URL:
Spreadsheet: 117683d1312962827-excel-2007-merge-deduped-problem-excel-test-2-options
Sheet: version1

Customer number | Title | FirstName | LastName | County | PostCode | [NAME] | Units | Events | Seminar
11111 | Mr | Testfirstname1 | Testlastname1 | Testcounty1 | Testpostcode1 | Testemail1 | Testunits1 | Testevents1 | Event1
2222200 | Ms | Testfirstname2 | Testlastname2 | Testcounty2 | Testpostcode2 | Testemail2 | Testunits2 | Testevents2 | Event2
2222200 | Ms | Testfirstname2 | Testlastname2 | Testcounty2 | Testpostcode2 | Testemail2 | Testunits2 | Testevents2 | Event3
3333 | Mrs | Testfirstname3 | Testlastname3 | Testcounty3 | Testpostcode3 | Testemail3 | Testunits3 | Testevents3 | Event4
3333 | Mrs | Testfirstname3 | Testlastname3 | Testcounty3 | Testpostcode3 | Testemail3 | Testunits3 | Testevents3 | Event4
3333 | Mrs | Testfirstname3 | Testlastname3 | Testcounty3 | Testpostcode3 | Testemail3 | Testunits3 | Testevents3 | Event4
3333 | Mrs | Testfirstname3 | Testlastname3 | Testcounty3 | Testpostcode3 | Testemail3 | Testunits3 | Testevents3 | Event4
4444444444 | Miss | Testfirstname4 | Testlastname4 | Testcounty4 | Testpostcode4 | Testemail4 | Testunits4 | Testevents4 | Event5
4444444444 | Miss | Testfirstname4 | Testlastname4 | Testcounty4 | Testpostcode4 | Testemail4 | Testunits4 | Testevents4 | Event6
4444444444 | Miss | Testfirstname4 | Testlastname4 | Testcounty4 | Testpostcode4 | Testemail4 | Testunits4 | Testevents4 | Event5
4444444444 | Miss | Testfirstname4 | Testlastname4 | Testcounty4 | Testpostcode4 | Testemail4 | Testunits4 | Testevents4 | Event7
4444444444 | Miss | Testfirstname4 | Testlastname4 | Testcounty4 | Testpostcode4 | Testemail4 | Testunits4 | Testevents4 | Event5
Fixed data
Customer number | Title | FirstName | LastName | County | PostCode | [NAME] | Units | Events | Seminar
11111 | Mr | Testfirstname1 | Testlastname1 | Testcounty1 | Testpostcode1 | Testemail1 | Testunits1 | Testevents1 | Event1
2222200 | Ms | Testfirstname2 | Testlastname2 | Testcounty2 | Testpostcode2 | Testemail2 | Testunits2 | Testevents2 | Event2, Event3
3333 | Mrs | Testfirstname3 | Testlastname3 | Testcounty3 | Testpostcode3 | Testemail3 | Testunits3 | Testevents3 | Event4
4444444444 | Miss | Testfirstname4 | Testlastname4 | Testcounty4 | Testpostcode4 | Testemail4 | Testunits4 | Testevents4 | Event5, Event6, Event7
Spreadsheet: 19127a0f-ced6-4c40-9dcd-27e27b11b585
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
09/02/2006 | Football | [NAME] | 12:00 AM | W, 42-10
09/09/2006 | Football | EASTERN WASHINGTON | 12:00 AM | W, 52-3
09/14/2006 | Football | MARYLAND | 12:00 AM | W, 45-24
09/23/2006 | Football | at East Carolina | 12:00 AM | W, 27-10
10/07/2006 | Football | at Mississippi State | 12:00 AM | W, 42-14
10/14/2006 | Football | SYRACUSE | 12:00 AM | W, 41-17
10/20/2006 | Football | at Connecticut | 12:00 AM | W, 37-11
11/02/2006 | Football | at Louisville | 12:00 AM | L, 34-44
11/11/2006 | Football | CINCINNATI | 12:00 AM | W, 42-24
11/16/2006 | Football | at Pitt | 12:00 AM | W, 45-27
11/25/2006 | Football | USF | 12:00 AM | L, 19-24
12/02/2006 | Football | RUTGERS | 12:00 AM | W, 41-39 (3OT)
[NAME] | Football | Georgia Tech (Gator Bowl) | 12:00 AM | W, 38-35
Spreadsheet: 163830d1340475819-working-with-id-and-parentid-as-criteria-workbook1
Sheet: Sheet2 (2)

 | ID | parentID | type | critA | critB
 | 27 |  | root | A | 1
 | 39 | 29 | branch | A | 0
 | 635 | 32 | terminal | A | 0
 | 33 | 32 | branch
 | 40 | 39 | branch
 | 775 | 33 | terminal | A | 1
 | 34 | 33 | branch
 | 812 | 40 | branch
 | 37 | 34 | terminal
 | 813 | 812 | terminal
 | 781 | 12 | branch | A | 0
 | 14 | 13 | internal
 | 784 | 781 | branch
 | 15 | 14 | internal
 | 782 | 784 | branch
 | 19 | 18 | final
Spreadsheet: 106200d1303387161-formula-to-compare-if-multiple-cells-no-longer-blank-book1_pdauction
Sheet: Sheet1

 | 2009 |  |  | 2010 |  |  | Clients with Changes > | 8
Client | Dog | Cat | Fish | Dog | Cat | Fish | Changed
Name 1 | Collie | Persian |  | [NAME] | Persian |  | 1
Name 2 |  | Persian |  | [NAME] | Persian |  | 1
Name 3 |  | Persian |  |  | Persian
Name 4 |  | Persian |  | [NAME] | Persian |  | 1
Name 5 |  |  |  |  | Persian |  | 1
Name 6 |  |  |  |  | Persian |  | 1
Name 7 |  |  | Goldfish |  |  |  | 1
Name 8 |  | Persian |  |  | Siamese |  | 1
Name 9 | Westie |  |  | Westie
Name 10 |  | Persian |  |  |  |  | 1
Spreadsheet: 855870d1705339204-looking-for-a-way-to-automate-scheduling-duos-into-different-squads-sample-scheduling-bsweet0us-
Sheet: Squad schedule

SQUAD 1 | 1/12/2024, 2:00 pm |  |  | SQUAD 2 | 1/13/2024, 2:00 pm |  |  |  | SQUAD 3 | 1/14/2024, 2:00 pm |  |  | SQUAD 4 | 1/15/2024, 2:00 pm
[NAME] | [NAME] |  |  | [NAME] | [NAME] |  |  |  | [NAME] | [NAME] |  |  | [NAME] | [NAME]
[NAME] | Briley Scantland |  |  | [NAME] | [NAME] |  |  |  | [NAME] | [NAME]
[NAME] | Nate Apgar |  |  | [NAME] | [NAME] |  |  |  | [NAME] | [NAME]
[NAME] | [NAME]
Bobbi [NAME] | [NAME]
SQUAD 5 | 1/16/2024, 2:00 pm
[NAME] | [NAME]
Spreadsheet: a26b7375-5661-4f60-b8f7-b509fc2ece26
Sheet: Sheet1

Start Date | End Date | Meeting Name | HQ Hotel | Venues | Attendees
2013-11-19 00:00:00 | 2013-11-19 00:00:00 | Project Homeless Connect | Cashman Center | Cashman Center | 2000
2013-10-24 00:00:00 | 2013-10-24 00:00:00 | Nevada Medicaid Providers Conference | Cashman Center | Cashman Center | 225
2013-09-28 00:00:00 | 2013-09-28 00:00:00 | Milan Institute Graduation Ceremony | Cashman Center | Cashman Center | 1500
2013-06-22 00:00:00 | 2013-06-23 00:00:00 | Magic the Gathering Grand Prix presented by [NAME] | Golden Nugget | Cashman Center | 1500
Spreadsheet: 8083553c-d683-4e32-b23f-d77bb6aea827
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7400 | 16569 | [NAME] | Galea | MLT | 10 | 00:21:10 | 00:02:44 | 01:03:43 | 00:01:21 | 00:36:20 | 1 | 02:05:20
7400 | 56367 | [NAME] | [NAME] | GBR | 6 | 00:23:06 | 00:02:47 | 01:03:19 | 00:01:23 | 00:39:24 | 2 | 02:10:03
7400 | 56366 | Lewis | Murchie | GBR | 7 | 00:20:47 | 00:02:28 | 01:09:46 | 00:01:16 | 00:44:17 | 3 | 02:18:36
7400 | 57544 | Yarden | [NAME] | ISR | 9 | 00:22:40 | 00:03:22 | 01:15:19 | 00:01:33 | [NAME] | 4 | 02:23:40
7400 | 57545 | [NAME] | Abramovich | ISR | 8 | 00:31:04 | 00:03:44 | 01:25:25 | 00:00:00 | 00:00:00 | 5 | 02:54:14
Spreadsheet: jeff_dasovich__14117__2000WK13(a)final
Sheet: Payout

 |  | Total | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 | Wk 7 | Wk 8 | Wk 9 | Wk 10 | Wk 11 | Wk 12 | Wk 13 | Wk 14 | Wk 15 | Wk 16 | Wk 17 | Season | [NAME]
 | Narvco |  | 65 |  |  | 50 |  |  |  |  |  |  | 50 |  | 35
1 | [NAME] |  |  | 65 |  |  | 50 |  |  |  |  | 65
11 | [NAME] |  |  | 42.5 |  |  |  |  |  | 65 |  |  |  | 20 | 50
16 | Eldon |  | 18.33 |  |  |  |  |  |  |  |  | 50 | 35 |  | 65
2 | Barrie |  |  |  | 20 |  | 65 |  | 50
-12 | Cameron |  |  |  | 65 |  |  |  |  | 20 | 20
-26 | [NAME] |  |  |  |  | 65 |  | 50
-40 | Sheas |  |  |  |  |  |  | 65 |  |  |  |  |  |  | 20
-54 | Hank |  |  | 42.5 |  |  | 20 |  |  |  |  | 20
-68 | JAM |  | 50 |  |  |  |  |  |  | 50
-82 | Mike&Lisa |  |  |  |  |  |  |  |  |  |  |  | 65 | 35
-96 | [NAME] |  |  |  |  |  |  |  |  |  |  | 35 |  | 65
-110 | [NAME] |  |  |  | 50 |  |  |  |  |  | 35
-124 | Helmet |  |  |  |  |  |  |  |  | 35 | 50
-138 | [NAME] |  |  |  |  |  |  | 35 |  |  |  |  |  | 50
-152 | Growney |  | 18.33 |  |  |  |  |  |  |  | 65
-166 | [NAME] |  |  |  |  |  |  |  | 65
-180 | WAM |  |  |  |  |  | 35 | 20
 | [NAME] |  |  |  | 35
 | [NAME]
 | Carlton |  |  | 20
 | Daryl |  |  |  |  |  |  |  |  |  |  |  | 20
 | [NAME] |  | 18.34
-194 | [NAME]
-208 | Prentice
-222
-236 | TOTAL DOLLARS PAID OUT
-250
Spreadsheet: 328798d1404092126-choose-function-not-returning-expected-results-choose-test-file
Sheet: Room1A

 |  |  |  | Weekday | Roll Taker
 |  |  |  | Monday | Taker 1
 |  |  |  | Tuesday | Taker 2
Student | Grade | Room | Session | Wednesday | Taker 3
LastName, FirstName 1 | 10 | 1 | A | Thursday | Taker 4
LastName, FirstName 2 | 10 | 1 | A | Friday | Taker 5
LastName, FirstName 3 | 10 | 1 | A
LastName, FirstName 4 | 10 | 1 | A
LastName, FirstName 5 | 9 | 1 | A
LastName, FirstName 6 | 9 | 1 | A
LastName, FirstName 7 | 9 | 1 | A
LastName, FirstName 8 | 9 | 1 | A
LastName, FirstName 9 | 10 | 1 | A
LastName, FirstName 10 | 10 | 1 | A
LastName, FirstName 11 | 9 | 1 | A
LastName, FirstName 12 | 9 | 1 | A
LastName, FirstName 13 | 9 | 1 | A
LastName, FirstName 14 | 9 | 1 | A
LastName, FirstName 15 | 9 | 1 | A
LastName, FirstName 16 | 9 | 1 | A
LastName, FirstName 17 | 10 | 1 | A
LastName, FirstName 18 | 10 | 1 | A
LastName, FirstName 19 | 9 | 1 | A
LastName, FirstName 20 | 9 | 1 | A
LastName, FirstName 21 | 9 | 1 | A
LastName, FirstName 22 | 9 | 1 | A
LastName, FirstName 23 | 10 | 1 | A
LastName, FirstName 24 | 10 | 1 | A
LastName, FirstName 25 | 9 | 1 | A
LastName, FirstName 26 | 9 | 1 | A
LastName, FirstName 27 | 9 | 1 | A
LastName, FirstName 28 | 9 | 1 | A
LastName, FirstName 29 | 9 | 1 | A
LastName, FirstName 30 | 9 | 1 | A
LastName, FirstName 31 | 9 | 1 | A
LastName, FirstName 32 | 9 | 1 | A
LastName, FirstName 33 | 9 | 1 | A
LastName, FirstName 34 | 9 | 1 | A
LastName, FirstName 35 | 9 | 1 | A
LastName, FirstName 36 | 9 | 1 | A
LastName, FirstName 37 | 9 | 1 | A
LastName, FirstName 38 | 9 | 1 | A
LastName, FirstName 39 | 10 | 1 | A
LastName, FirstName 40 | 10 | 1 | A
LastName, FirstName 41 | 10 | 1 | A
LastName, FirstName 42 | 10 | 1 | A
LastName, FirstName 43 | 11 | 1 | A
LastName, FirstName 44 | 11 | 1 | A
Spreadsheet: 42baa451-fc73-4ca0-aec3-dfb773e62dff
Sheet: Field A

Permit No.: |  |  | WQ0024756 |  |  | Facility Name: |  | The Grove WWTF |  |  |  |  |  | County: | [NAME] |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | Field A |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 0.55 |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.34 |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 124.1 |  | Annual Rate (in): |  |  |  | Annual Rate (in): |  |  |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 850520d1700857136-replace-a-word-from-number-850518d1700856407-replace-a-word-from-number-2611-0212
Sheet: Φύλλο1

ΒΕΝΕΤΙΔΗΣ | ΔΗΜΗΤΡΙΟΣ
Spreadsheet: 105287d1302696406-conditional-formatting-between-sheets-book1
Sheet: Sheet1

Reg No
10001
10002
10003
10004
10005
10006
10007
10008
10009
10010
10011
10012
10013
10014
10015
10016
10017
10018
10019
10020
10021
10022
10023
10024
10025
10026
10027
10028
10029
10030
10031
10032
10033
10034
10035
10036
10037
10038
Spreadsheet: 144027d1330687852-adding-people-to-multiple-groups-for-a-stakeholder-list-0179
Sheet: Sheet1

uniques | First Name | Surname | Name | Group
1 | [NAME] | Cox | [NAME] | EPOD Project Team
1 | [NAME] | Smith | [NAME] | EPOD Project Team
1 | Nick | [NAME] | [NAME] | EPOD Project Team
1 | [NAME] | [NAME] | [NAME] | EPOD Project Team
2 | [NAME] | Smith | [NAME] | Project Support
2 | [NAME] | Cox | [NAME] | Safety Committee
Spreadsheet: 349112d1412205210-counting-unique-instances-above-a-certain-quantity-customer
Sheet: Sheet1

Customer | Year
A | 1
A | 2
A | 3
A | 4
B | 1
B | 2
B | 3
C | 1
C | 2
D | 1
D | 2
D | 3
E | 1
E | 2
F | 1
F | 2
F | 3
6
Spreadsheet: 177753d1346423240-produce-a-list-based-on-whether-or-not-a-vale-is-less-then-another-cell-value-tester
Sheet: Sheet1

1st name | 2nd name | Date | Age
Francisco | Chad |  | 12 |  |  |  | Dates Less then: | 2005-05-12 00:00:00
[NAME] | [NAME] |  | 84
[NAME] | [NAME] |  | 65 |  |  |  | 1st name | 2nd name | Date | Age
Iliana | Gerda |  | 45 |  |  |  | [NAME] | [NAME] | 1985-04-15 00:00:00 | 84
Judi | [NAME] |  | 13 |  |  |  | Iliana | Gerda | 1985-04-15 00:00:00 | 45
Johna | [NAME] |  | 95 |  |  |  | Johna | [NAME] | 1998-12-23 00:00:00 | 95
Sherwood | Corene |  | 12 |  |  |  | Deena | Reita | 2003-07-16 16:00:00 | 84
Tonie | [NAME] |  | 65 |  |  |  | [NAME] | Ginger | 1985-04-15 00:00:00 | 65
Deena | Reita |  | 84 |  |  |  | Faustino | Jacinta | 1985-04-15 00:00:00 | 75
[NAME] | Ginger |  | 65 |  |  |  | Forest | Avery | 1985-04-15 00:00:00 | 15
Faustino | Jacinta |  | 75 |  |  |  | Glory | Porsha | 2003-07-16 16:00:00 | 25
[NAME] | Merrill |  | 84 |  |  |  | Susanna | Timothy | 1998-12-23 00:00:00 | 65
Darell | Alecia |  | 65 |  |  |  | [NAME] | Landon | 1998-12-23 00:00:00 | 15
[NAME] | Margurite |  | 45
Erma | Tandy |  | 32
Samual | Valeria |  | 45
Forest | Avery |  | 15
Glory | Porsha |  | 25
Susanna | Timothy |  | 65
[NAME] | Landon |  | 15
Spreadsheet: 125250d1318946561-calculating-costs-where-quantities-cover-more-than-one-threshold-calculating-costs-where-quantity-includes-more-than-one-threshold
Sheet: Sheet1

 | Pricing Table
Soil Volume (m3) |  | Cost per m3 of Soil dug
From | To
0 | 77820.29999999999 | 2.883562898669931
77820.29999999999 | 854827 | 3.36856416367316
854827 | 942377 | 2.03192505819058
942377 | 1019777 | 3.191864889340609
1019777 | 1160077 | 2.706934891138587
1160077 | 1356827 | 2.816011922107943
Time | Actual  Soil Dug m3 | Cumulative Achieved | Cost of actual m3
Month 1 | 75000 |  | ?
Month 2 | 78000 |  | ?
Month 3 | 700000 |  | ?
Month 4 | 102000 |  | ?
Month 5 | 202000 |  | ?
Month 6 | 105000 |  | ?
Spreadsheet: 738168d1624883462-combining-data-into-a-single-list-examplesheet
Sheet: data

data number | names
1 | cat | dog | horse
2 | dog | cat | horse | lion | donkey
3 | horse | donkey
4 | bird | donkey | cat
5 | dog | cat | lion
6 | squirrel | [NAME] | cat | dog
7 | squirrel | horse | lion
Spreadsheet: 159456d1338664479-excel-2007-counting-the-number-of-instances-in-a-specific-month-month-instance-count-sample
Sheet: Sheet1

Next Scheduled Exercise Date | Status
2012-03-30 00:00:00 | N/A
2012-05-11 00:00:00 | Complete
2012-05-16 00:00:00 | Complete
2012-08-26 00:00:00 | N/A
2012-09-17 00:00:00 | N/A
2012-06-28 00:00:00 | N/A
2012-03-09 00:00:00 | Complete
2012-02-03 00:00:00 | N/A
2012-02-22 00:00:00 | N/A
Spreadsheet: eric_saibi__9869__101901R
Sheet: Seabrook 01

Owner Name |  | Northeast Utilities
Station Name |  | Seabrook Nuclear Power Station
Unit Name |  | Seabrook 01
NERC Region |  | NPCC
State |  | NH
Fuel Type |  | Nuclear
Capacity |  | 1,242 MW
Start Date |  | 2001-10-15 00:00:00
End Date |  | 2001-10-20 00:00:00
Prv. Start Date |  | 2001-10-15 00:00:00
Prv. End Date |  | 2001-10-16 00:00:00
Comments |  | Unit's currently in hot standby.  Preparing to come on line tomorrow.
SIC |  | 4911
Plant ID |  | 1015015
Unit ID |  | 1008197
Outage ID |  | 18660
Spreadsheet: 100181d1298593551-conditional-formatting-test_master-sheet2
Sheet: Historical_Data

 | MEASURES DASHBOARD - Historical Data
 | Area - CUSTOMER
 |  | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00
 | All Projects | 0.78 | 0.76 | 0.75 | 0.69 | 0.67 | 0.48 | 0.72 | 0.77
Spreadsheet: 885878d1735805769-fill-a-table-cell-with-data-from-another-table-based-on-the-adjacent-table-cell-value-department-meeting-schedule-sansitised
Sheet: 2025

All meetings are hed at 1:30pm in the Conference Room unless otherwise noted
Date | Type | Description | Presenter (Main) | Presenter (Additional) | Notetaker |  | Outline | Status
2024-01-01 00:00:00 | Safety Talk
2024-01-01 00:00:00 | Department |  | DeptManagement01
2024-01-16 00:00:00 | Informative
2024-02-05 00:00:00 | Safety Talk
2024-02-05 00:00:00 | Department |  | DeptManagement01
2024-02-20 00:00:00 | Informative
Spreadsheet: james_steffes__12981__Savings_Analysis
Sheet: DWR(MWs)-Rep

 |  |  |  |  |  |  | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00
 |  | Peak Net Short (Mw) |  |  |  |  | 10289.95629467034 | 9870.66024855059 | 10284.81876866849 | 11078.69705021289 | 12878.00454879448 | 10268.73406936875 | 9708.496369727422 | 8427.708899288704
 |  | Executed Contracts (Mw)
 |  | AIP Contracts (Mw)
 |  | % of NS Met by Executed Contracts
 |  | % of NS Met by AIP Contracts
 |  | % of NS Met by Contracts
 |  |  | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00
 |  | Peak Net Short (Mw) | 9481.290943572161 | 9781.036985473433 | 9420.299032101737 | 9379.64374490527 | 10196.59818194865 | 10672.87031153731 | 11676.98449180098 | 12376.57511059735 | 14041.41469568781 | 11704.06463900102 | 11168.55713051082 | 9469.606155066187
 |  | Executed Contracts (Mw)
 |  | AIP Contracts (Mw)
 |  | % of NS Met by Executed Contracts
 |  | % of NS Met by AIP Contracts
 |  | % of NS Met by Contracts
 |  |  | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
 |  | Peak Net Short (Mw) | 13304 | 14839 | 15722 | 16585 | 17400 | 17778 | 18164 | 19768
 |  | Executed Contracts (Mw) | 8241 | 9524 | 8887 | 8825 | 8825 | 8531 | 8531 | 8237
 |  | AIP Contracts (Mw) | 4495 | 4691 | 3010 | 2554 | 2554 | 2554 | 2554 | 2554
 |  | % of NS Met by Executed Contracts
 |  | % of NS Met by AIP Contracts
 |  | % of NS Met by Contracts
 |  | * Net short is energy requirements before effects of funded programmatic load management and load curtailment.
 |  | Peak Net Short is [NAME] for the Average Week of each Month (for 2003-10 Month shown is July)
 |  | AIP - Agreement in Principle
Spreadsheet: 860982d1708998346-formula-to-match-partial-match-formula-to-match-items-with-partial-match
Sheet: Debtors

Code | Name | Period Month | Period Year | Reference | Sub-Reference | Date Processed | Outstanding | Due Date | Accounting Group | Ageing | Unmatched Items | Should Be
XM9854 | Vehicle Parts Sales (internal) | 5 | 2024 | 690639 |  |  | 11.21 | 2024-03-30 00:00:00 | Sale | 21.54978900462447
XM9854 | Vehicle Parts Sales (internal) | 5 | 2024 | 690643 |  |  | 10.55 | 2024-03-30 00:00:00 | Sale | 21.44492789351352
XM9854 | Vehicle Parts Sales (internal) | 5 | 2024 | 690649 |  |  | 26.98 | 2024-03-30 00:00:00 | Sale | 20.44353900462738
XM9854 | Vehicle Parts Sales (internal) | 5 | 2024 | 690668 |  |  | 11.21 | 2024-03-30 00:00:00 | Sale | 17.68242789351643
XM9854 | Vehicle Parts Sales (internal) | 5 | 2024 | 690670 |  |  | 173.32 | 2024-03-30 00:00:00 | Sale | 17.51576122685219
XM9854 | Vehicle Parts Sales (internal) | 5 | 2024 | 690698 |  |  | 83.33 | 2024-03-30 00:00:00 | Sale | 11.71298344906972
XM9854 | Vehicle Parts Sales (internal) | 5 | 2024 | 690699 |  |  | 74.8 | 2024-03-30 00:00:00 | Sale | 11.71228900463029
XM9854 | Vehicle Parts Sales (internal) | 5 | 2024 | 690703 |  |  | 11.21 | 2024-03-30 00:00:00 | Sale | 11.45812233795732
XM9854 | Vehicle Parts Sales (internal) | 5 | 2024 | 690746 |  |  | 15.43 | 2024-03-30 00:00:00 | Sale | 3.628955671294534
Spreadsheet: c7ed6b2f-7f92-46e0-a1f8-ca603f49421f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7199 | 30808 | [NAME] | Prinsloo | RSA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:21:56
Spreadsheet: 94263d1294132586-filter-list-with-formula-filter-list-with-formula
Sheet: Sheet1

Code | Number |  |  |  |  | Criteria Is not to show those value with same Code and same Number
G | 7
F | 6 |  |  |  |  | Below list is what I want (NOTE : must not sort the database) |  |  |  |  | Here is what I tried but only work for single column (NOTE : The second column value is not right)
E | 5
D | 4 |  |  |  |  | Code | Number |  |  |  | Code | Number
C | 3 |  |  |  |  | A | 1
B | 2 |  |  |  |  | A | 8
A | 1 |  |  |  |  | B | 2
G | 14 |  |  |  |  | B | 9
F | 13 |  |  |  |  | C | 3
E | 12 |  |  |  |  | C | 10
D | 11 |  |  |  |  | D | 4
C | 10 |  |  |  |  | D | 11
B | 9 |  |  |  |  | E | 5
A | 8 |  |  |  |  | E | 12
G | 7 |  |  |  |  | F | 6
F | 6 |  |  |  |  | F | 13
E | 5 |  |  |  |  | G | 7
D | 4 |  |  |  |  | G | 14
C | 3
B | 2 |  |  |  |  | Question is how to make a formula to generate those list I wanted?
A | 1
G | 14
F | 13
E | 12
D | 11
C | 10
B | 9
A | 8
Spreadsheet: 90902d1290602233-how-to-insert-a-drop-down-country-list-ziva770_21-11-2010-forum-1-
Sheet: 21-11-2010

[NAME] | Name | url | Business Area | location
 |  |  | Diamonds & Jewelry | New Jersey | NJ
 |  |  | Diamonds & Jewelry
 | [NAME] |  | Diamonds & Jewelry | IOWA | IA
 | [NAME] |  | Diamonds & Jewelry
 | Rich
 | [NAME]
 | Yehuda
 | Harold
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 50459d1249918219-i-want-to-calculate-a-result-only-if-a-cell-in-a-previous-worksheet-is-populated-holidays-2009-staff-test
Sheet: Summary Sheet

Monthly Totals | January |  |  | February |  |  | March |  |  | April |  |  | May |  |  | June |  |  | July |  |  | August |  |  | September |  |  | October |  |  | November |  |  | December
Name | H | L | S | H | L | S | H | L | S | H | L | S | H | L | S | H | L | S | H | L | S | H | L | S | H | L | S | H | L | S | H | L | S | H | L | S
A.N.Other | 6 | 1 | 0 | 0 | 0 | 18 | 0 | 0 | 3 | 4 | 0 | 0 | 5 | 0 | 0 | 1 | 0 | 10 | 1.5 | 0 | 16 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0
Totals | 6 | 1 | 0 | 0 | 0 | 18 | 0 | 0 | 3 | 4 | 0 | 0 | 5 | 0 | 0 | 1 | 0 | 10 | 1.5 | 0 | 16 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0