tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: ae524a90-e707-4fbb-8dcd-b4de78eb90a8
Sheet: Sheet1

LINE ITEM BUDGET | ATTACHMENT E | Unnamed: 2
Name of Applicant Agency: __________________________________________
Please provide a line item budget for the term of the contract  (7/1/010 – 6/30/11).  Please do not forget to include any proposed cost of living or performance appraisal merit increases in your proposed budget.
Term Beginning: __________________ | Term Ending:____________
A.     SALARIES AND EMPLOYEE BENEFITS
1)     Salaries - List each position to be funded by this award.
Position(s) | Full-Time Equivalent (FTE)1 | Budget for Contract Term
Direct Service Positions
Administrative Positions
Sub-Total Salaries: |  | 0
1 FTE = Amount of time employee works on this program.  State as decimal based upon a 40 hour work week.
2)     Employee Benefits - List type of employee benefit(s) and amount budgeted.
Type of Employee Benefit |  | Budget for Contract Term
Direct Service Staff |  | 0
Administrative Staff |  | 0
Sub-Total Employee Benefits |  | 0
Percentage Benefits
TOTAL SALARIES AND EMPLOYEE BENEFITS |  | 0
LINE ITEM BUDGET | ATTACHMENT E
B. SERVICES AND SUPPLIES
1)  Services - List any consultant(s) or contract services
Name of Consultant(s)/Contract Services |  | Budget for Contract Term
Independent Audit |  | 0
Sub-Total Services |  | 0
2) Supplies
Item |  | Budget for Contract Term
Office Expense* |  | 0
Program Expense* |  | 0
Telephone* |  | 0
Mileage* |  | 0
Other* |  | 0
Sub-Total Supplies |  | 0
TOTAL SERVICES AND SUPPLIES |  | 0
*Provide detail on Attachment F.
LINE ITEM BUDGET | ATTACHMENT E
C. OPERATING EXPENSES
Item* |  | Budget for Contract Term
Facility Lease/Rental |  | 0
Equipment Lease/Rental* |  | 0
Furnishings* |  | 0
Maintenance |  | 0
Utilities |  | 0
Insurance (Refer to General Contract Provisions for Insurance Requirements) |  | 0
Other* |  | 0
Total Operating Expenses |  | 0
GRAND TOTAL LINE ITEM BUDGET |  | 0
Minus Revenue
TOTAL BEING REQUESTED |  | 0
Spreadsheet: 85598d1285685592-average-problem-with-pivot-table-excel-help-book
Sheet: Sheet1

 |  |  | Data
Order # | Trans Type | Part # | Sum of Revenue Tot | Sum of Cost Price Tot | Sum of GP Tot | Average of GP %
19919 |  |  | 126289.3203125 | 39287.26953125 | 87002.05078125 | 68.89105948623798
18491 |  |  | 150480 | 95863 | 54617 | 37.21011248852158
18334 |  |  | 93767 | 39287.26953125 | 54479.73046875 | 58.10117681993665
13232 |  |  | 123000 | 80272.43359375 | 42727.56640625 | 34.79452194940476
14133 |  |  | 69719 | 32029.8896484375 | 37689.1103515625 | 54.03023128201042
14142 |  |  | 54210 | 20792.146484375 | 33417.853515625 | 61.64518265195535
18754 |  |  | 45209.98046875 | 16305.2783203125 | 28904.7021484375 | 63.93433894185595
14352 |  |  | 46569.671875 | 19988.685546875 | 26580.986328125 | 57.07789051954749
17788 |  |  | 46982 | 21521.169921875 | 25460.830078125 | 54.19273355354179
15545 | SA1 | XXX12 | 61147.12890625 | 36883.93359375 | 24263.1953125 | 39.68002381550902
 | SA1 Total |  | 61147.12890625 | 36883.93359375 | 24263.1953125 | 39.68002381550902
15545 |  |  | 61147.12890625 | 36883.93359375 | 24263.1953125 | 39.68002381550902
11112 | SA1 | XXX21 | 0.01 | 3151.933349609375 | -3151.923349609375 | -31519233.49609375
 |  | XXX23 | 46566 | 19660.7265625 | 26905.2734375 | 57.77879447987802
 | SA1 Total |  | 46566.01 | 22812.65991210938 | 23753.35008789063 | -15759587.85864964
11112 |  |  | 46566.01 | 22812.65991210938 | 23753.35008789063 | -15759587.85864964
Spreadsheet: 784482d1655754149-extracting-varying-text-in-the-middle-of-a-string-of-text-extracting-varying-text-in-middle
Sheet: Sheet1

Status | Is Termination Reason | Location | Department | Ledger Code | Pay Type | Pay Class | Pay Class Description | Manager | Extraction Result in this Column
Terminated |  | Operations Southwest - Phoenix - P&D - Pre Load Sort | [NAME] | 3701 | Hourly | P | Part Time |  | Phoenix - P&D
Active | False | Operations Bay - Concord - P&D - Pre Load Sort | [NAME] | 3225 | Hourly | P | Part Time | [NAME], [NAME]
Terminated | True | Operations Bay - Concord - P&D - Pre Load Sort | [NAME] | 3225 | Hourly | P | Part Time
Terminated |  | Operations Bay - San Francisco - P&D - Pre Load Sort | [NAME] | 3221 | Hourly | P | Part Time
Terminated |  | Operations Bay - San Francisco - P&D - Ops Admin | Ops Admin | 3221 | Hourly | P | Part Time
Terminated |  | HUB - Commerce - HUB - Twilight Sort | Twilight Sort | 3320 | Hourly | P | Part Time
Terminated |  | Operations Bay - San Jose - P&D - Pre Load Sort | [NAME] | 3219 | Hourly | P | Part Time
Terminated |  | Operations Bay - San Jose - P&D - Pre Load Sort | [NAME] | 3219 | Hourly | P | Part Time
Terminated |  | Operations Southwest - Buckeye - P&D - Pre Load Sort | [NAME] | 3703 | Hourly | P | Part Time
Terminated |  | Operations Bay - San Francisco - P&D - Pre Load Sort | [NAME] | 3221 | Hourly | P | Part Time
Spreadsheet: 5cca16d8-65f6-4775-966f-ddc42fd4f584
Sheet: Sheet1

State Auditor - DEM (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 10/25/2014 2:01:00 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 102886
2008 Primary Election - OFFICIAL RESULTS
District | [NAME] | TOTALS
District 01 | 354 | 354
District 02 | 593 | 593
District 03 | 600 | 600
District 04 | 519 | 519
District 05 | 911 | 911
District 06 | 718 | 718
District 07 | 685 | 685
District 08 | 567 | 567
District 09 | 469 | 469
District 10 | 933 | 933
District 11 | 1215 | 1215
District 12 | 1007 | 1007
District 13 | 1241 | 1241
District 14 | 629 | 629
District 15 | 766 | 766
District 16 | 717 | 717
District 17 | 1282 | 1282
District 18 | 988 | 988
District 19 | 646 | 646
District 20 | 923 | 923
District 21 | 1025 | 1025
District 22 | 1001 | 1001
District 23 | 1126 | 1126
District 24 | 1354 | 1354
District 25 | 317 | 317
District 26 | 929 | 929
District 27 | 1066 | 1066
District 28 | 992 | 992
District 29 | 705 | 705
District 30 | 451 | 451
District 31 | 834 | 834
District 32 | 511 | 511
District 33 | 707 | 707
District 34 | 771 | 771
District 35 | 651 | 651
District 36 | 668 | 668
District 37 | 930 | 930
District 38 | 536 | 536
District 39 | 739 | 739
District 40 | 477 | 477
District 41 | 944 | 944
District 42 | 647 | 647
District 43 | 846 | 846
District 44 | 1413 | 1413
District 45 | 810 | 810
District 46 | 1095 | 1095
District 47 | 664 | 664
TOTAL | 37972 | 37972
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 52142d1251838681-locking-cell-data-from-different-sheets-time-sheet-for-testing
Sheet: Sheet2

Name |  |  |  |  |  |  | Wk/Comm
 |  |  |  |  |  |  | 2009-08-31 00:00:00 |  |  | Week |  |  | 36
 |  |  |  |  | Start | Finish | Driving | Lunch | Minimun | Daily Hours |  |  | Total Daily Hours minus break
Date | Duty |  |  |  | Time | Time | Time | Breaks | Break 30 Minutes
2009-08-31 00:00:00 |  |  |  |  | 08:00:00 | 17:00:00 |  | Start Time |  | 09:00:00 | 9.000000000000002 | 11 |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  | Finish Time |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 02:00:00 |  | Break Duration | 1900-01-01 00:00:00 | 02:00:00 | 2 |  |  |  | 01:00:00
2009-09-01 00:00:00 |  |  |  |  | 23:00:00 | 04:00:00 |  | Start Time |  | 05:00:00 | 4.999999999999998 | 4.999999999999998 |  |  | 04:00:00
 |  |  |  |  |  |  |  | Finish Time |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  | Break Duration | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
2009-09-02 00:00:00 |  |  |  |  | 02:00:00 | 04:00:00 |  | Start Time |  | 02:00:00 | 2 | 7 |  |  | 02:00:00
 |  |  |  |  |  |  |  | Finish Time |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  | 1900-01-01 00:00:00 | 05:00:00 |  | Break Duration | 1900-01-01 00:00:00 | 05:00:00 | 5 |  |  |  | 1900-01-01 00:00:00
2009-09-03 00:00:00 |  |  |  |  | 1900-01-01 00:00:00 | 01:00:00 |  | Start Time |  | 01:00:00 | 1 | 1 |  |  | 01:00:00
 |  |  |  |  |  |  |  | Finish Time |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  | Break Duration | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
2009-09-04 00:00:00 |  |  |  |  | 01:00:00 | 03:00:00 |  | Start Time |  | 02:00:00 | 2 | 2 |  |  | 02:00:00
 |  |  |  |  |  |  |  | Finish Time |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  | Break Duration | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
2009-09-05 00:00:00 |  |  |  |  | 17:00:00 | 22:00:00 |  | Start Time |  | 05:00:00 | 4.999999999999998 | 7.999999999999998 |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 01:00:00 | 04:00:00 |  | Finish Time |  | 03:00:00 | 3 |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  | Break Duration | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
2009-09-06 00:00:00 |  |  |  |  |  |  |  | Start Time |  | 1900-01-01 00:00:00 | 0 | 6.999999999999999
 |  |  |  |  |  |  |  | Finish Time |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  | 23:00:00 | 06:00:00 |  | Break Duration | 1900-01-01 00:00:00 | 07:00:00 | 6.999999999999999 |  |  |  | 04:00:00
 |  |  |  |  |  |  | 1900-01-01 00:00:00 |  |  | Weekly Total(1) |  |  | 41 |  | 04:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 836413d1689332358-create-formula-in-pivot-pt-score-average-aligw
Sheet: Sheet1

 | Name | Score /100 |  |  | Row Labels | Average of Score
 | AAA | 79 |  |  | AAA | 79
 | BBB | 77 |  |  | BBB | 77
 | CCC | 73 |  |  | CCC | 73
 | DDD | 79 |  |  | DDD | 79
 |  |  |  |  | Grand Total | 77
Spreadsheet: 181900d1348187692-vlookup-or-help-w-pull-downs-and-older-people-assembly
Sheet: Sheet2

PART NUMBER | COST | TOTAL
6103-03-03 | 1.8
6117-03-03 | 3.65
6191-03-03 | 3.65
15333 | 0.22 | 5.28
6103-04-03 | 2.89
6191-04-03 | 4.9
6117-04-03 | 4.9
6104-03-03 | 2.87
6104-07-03 | 3.09
6194-03-03 | 4.95
6193-03-03 | 4.95
6102-03-03 | 3.1
6144-03-03
6114-03-03
6132-04-03
6105-03-03
6195-03-03
6194-03-03
6155-03-03
6141-07-03
61-4-07-03
6141-03-03
6142-03-03
6154-03-03
6104-31-03
6104-32-03
6194-31-03
6194-32-03
6154-31-03
6154-32-03
6105-31-03
6105-32-03
6195-30-03
6195-32-03
6155-33-03
6155-32-03
Spreadsheet: 131217d1322807181-pivot-table-auto-update-pivottable_dayofmonth
Sheet: Sheet1

WORKSHEET WORK IN PROGRESS
Sum of cl-cl
Day of Month | Close to Close sequence | [NAME] | Op-Hi | Actual | Total
2 | blue | 0.09999999999990905 | 16.2 | P Struc | 18.2
 |  | 0.2999999999999545 | 8.5 | NVD | 0.7000000000000455
 |  | 0.5 | 25 | P Struc | 13.09999999999991
 |  | 0.7999999999999545 | 10 | TREND | 13.90000000000009
 |  | 1.200000000000045 | 3.5 | ND | 5.200000000000045
 |  | 1.5 | 10.2 | P Struc | 8.399999999999864
 |  |  | 10.5 | INEUT | 4.700000000000045
 |  | 1.700000000000045 | 10.5 | ND | 2.600000000000136
 |  | 1.799999999999955 | 23.5 | P Struc | 36
 |  | 2 | 9.5 | INEUT | 4
 |  |  |  | ND | 3.5
 |  | 2.5 | 8.299999999999955 | INVD | 7.899999999999864
 |  | 3.299999999999955 | 1.799999999999955 | P Struc | 2.299999999999955
 |  |  | 3.5 | NEUT | 9.600000000000136
 |  |  | 4.299999999999955 | ND | 3.5
 |  | 3.5 | 15.3 | INEUT | 26.3
 |  | 3.700000000000045 | 4 | NEUT | 2.800000000000182
 |  |  | 13.5 | P Struc | 10.90000000000009
 |  | 4.5 | 23 | NVD | 27.2
 |  | 6.099999999999909 | 1.700000000000045 | INVD | 1.5
 |  | 6.799999999999955 | 9.799999999999955 | NEUT | 11.8
 |  | 7.5 | 6 | NEUT | 0.2999999999999545
 |  | 7.799999999999955 | 10 | INEUT | 2
 |  | 8 | 18.5 | NVD | 33.7
 |  | 8.100000000000023 | 13.4 | INEUT | 10.2
 |  | 8.899999999999864 | 4.900000000000091 | ND | 3.5
 |  | 10.40000000000009 | 6 | INEUT | 0.3000000000001819
 |  | 12 | 20.5 | INEUT | 33.7 | 10.6357142857143 | 28
 |  | 18 | 0 | INVD | 4
 |  | 23.2 | 0 | INEUT | 1.799999999999955 | 10.12000000000001
 | red | 0.5 | 10.7 | P Struc | -5.700000000000045
 |  | 2.199999999999932 | 6.300000000000068 | INEUT | -2.299999999999955
 |  | 2.900000000000091 | 7 | INEUT | -12.2
 |  | 3.299999999999955 | 0.2000000000000455 | NTD | -2.700000000000045
 |  |  | 7.200000000000045 | INEUT | -0.5
 |  | 6.200000000000045 | 2.599999999999909 | INEUT | -3.5
 |  | 7.700000000000045 | 0.3999999999998636 | NVD | -2
 |  | 9 | 2.299999999999955 | INVD | -5.600000000000136
 |  | 11.5 | 0.1000000000001364 | INVD | 0
 |  | 12.2 | 4.599999999999909 | INEUT | -7.5
 |  | 12.3 | 1 | INVD | -11.5
 |  |  | 12.5 | INEUT | -4.900000000000091
 |  | 14.2 | 0 | INVD | -25.90000000000009
 |  | 15.5 | 1 | INVD | -18.3
 |  |  | 2.200000000000045 | INEUT | -7.5
 |  | 15.90000000000009 | 1.399999999999864 | (blank) | 0
 |  | 16.8 | 5.700000000000045 | ND | -3.700000000000045
 |  | 20.3 | 3.299999999999955 | NVD | -6.800000000000182
 |  | 21 | 0.2999999999999545 | INVD | -26.19999999999982
 |  | 22 | 1 | INVD | -16
 |  | 24.5 | 2.299999999999955 | ND | -19.10000000000014
 |  | 25.40000000000009 | 6.5 | TREND | -6.5
 |  | 28.5 | 3.700000000000045 | NVD | -23.40000000000009 | -8.240000000000027 | 25
 |  | 38.5 | 1.5 | NVD | -44 | -10.65833333333336
Grand Total |  |  |  |  | 47.79999999999978
Spreadsheet: 267553d1380110845-time-including-an-or-phrase-test
Sheet: Sheet1

Summary | Resolution | Priority | Age of Incident (days) | Assignee | Submit Month | Submit Date | Submit Time | Assigned Group | Name
This is a summary of the problem | Agent is running. | High | 6 | [NAME] | 1 | 2013-01-01 00:00:00 | 02:51:07 | SysMgt Server Monitoring | TIVOLI AUTO CREATION
This is a summary of the problem | server has been removed from the database | Critical | 7 | [NAME] | 1 | 2013-01-02 00:00:00 | 08:11:53 | SysMgt Server Monitoring | [NAME]
Spreadsheet: 110996d1307530197-tidying-a-list-example
Sheet: Sheet1

Start | City | 1 | 2 | 3 | 4 | 5 | 6
 | London | [NAME] |  | [NAME] | [NAME] |  | [NAME]
 | Cardiff |  | [NAME] |  | [NAME] |  | [NAME]
 | Bristol |  |  | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME] |  |  | [NAME]
 | Edinburgh |  |  |  |  | [NAME] | [NAME]
End | City | 1 | 2 | 3 | 4 | 5 | 6
 | London | [NAME] | [NAME] | [NAME] | [NAME]
 | Cardiff | [NAME] | [NAME] | [NAME]
 | Bristol | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Edinburgh | [NAME] | [NAME]
Spreadsheet: 467474d1466717884-how-to-extract-multiple-datas-matching-to-a-cell-value-example-data2
Sheet: Sheet1

HoleID | From | To | Length | Cu | Au | CuEQ
CAR_0928_000000_EX | 0 | 1.0894 |  | 0.28 | 0.986805555555555 |  |  |  | these are the ID's I want to get | and I want to put it on the next sheet
CAR_0928_000001_EX | 0 | 1.0894 |  | 6.23 | 4.00204475308642 |  |  |  | HoleID
CAR_0928_000002_EX | 0 | 1.0894 |  | 0.71 | 0.734621913580247 |  |  |  | CAR_0928_000003_EX
CAR_0928_000003_EX | 0 | 1.0894 |  | 5 | 2.302546296296296 |  |  |  | CAR_0928_000008_EX
CAR_0928_000003_EX | 1.0894 | 2.1788 |  | 3.05 | 1.611782407407407 |  |  |  | CAR_0950_000016_EX
CAR_0928_000005_EX | 0 | 1.0894 |  | 0.92 | 1.315740740740741
CAR_0928_000005_EX | 1.0894 | 2.1788 |  | 0.18 | 0.6578703703703703
CAR_0928_000007_EX | 0 | 1.0894 |  | 1.27 | 12.46664351851852
CAR_0928_000008_EX | 0 | 1.0894 |  | 0.91 | 1.973611111111111
CAR_0928_000008_EX | 1.0894 | 2.1788 |  | 0.97 | 0.8442669753086419
CAR_0928_000010_EX | 0 | 1.0894 |  | 0.28 | 0.3289351851851852
CAR_0928_000010_EX | 1.0894 | 2.1788 |  | 0.26 | 0.4385802469135803
CAR_0928_000012_EX | 0 | 1.0894 |  | 2.2 | 2.817878086419753
CAR_0928_000012_EX | 1.0894 | 2.5275 |  | 2.95 | 2.774020061728395
CAR_0950_000014_EX | 0 | 2 |  | 0.2 | 0.9429475308641975
CAR_0950_000015_EX | 0 | 2 |  | 0.5 | 0.7565509259259259
CAR_0950_000016_EX | 0 | 2 |  | 1.8 | 0.7565509259259259
CAR_0950_000017_EX | 0 | 2 |  | 2.8 | 1.502137345679013
CAR_0950_000018_EX | 0 | 2 |  | 1.3 | 1.502137345679013
[NAME] | 0 | 2 |  | 0.1 | 0.7565509259259259
CAR_0950_000020_EX | 0 | 2 |  | 0.25 | 1.502137345679013
CAR_0950_000021_EX | 0 | 2 |  | 0.1 | 0.3727932098765432
[NAME] | 0 | 2 |  | 0.35 | 0.3727932098765432
CAR_0950_000023_EX | 0 | 2 |  | 0.16 | 1.502137345679013
CAR_0950_000024_EX | 0 | 2 |  | 2.3 | 1.11837962962963
CAR_0950_000025_EX | 0 | 2 |  | 0.25 | 0.3727932098765432
Spreadsheet: 599106d1542859967-saturday-work-schedule-28-advisors-8-shifts-saturday-work-schedule-28-advisors-8-shifts-v2
Sheet: Assignments

Team Member | Advisor 1 | Advisor 2 | Advisor 3 | Advisor 4 | Advisor 5 | Advisor 6 | Advisor 7 | Advisor 8 | Advisor 9 | Advisor 10 | Advisor 11 | Advisor 12 | Advisor 13 | Advisor 14 | Advisor 15 | Advisor 16 | Advisor 17 | Advisor 18 | Advisor 19 | Advisor 20 | Advisor 21 | Advisor 22 | Advisor 23 | Advisor 24 | Advisor 25 | Advisor 26 | Advisor 27 | Advisor 28
Saturday Shift
2018-01-05 00:00:00
Spreadsheet: 128922d1321354914-excel-2007-iferror-index-formula-returning-blank-cells-helpif-error-not-working
Sheet: Sheet1

 | Task | Days | Contingncy
 |  |  |  | Bx
 |  |  |  | Bwa
 | Bx | 4 | 3
 | Data Enter | B1
 | Results
 | [NAME]? | =IFERROR(INDEX(C13:C20, [NAME], C13:C20<>"", 0)), "")
 |  | Works only at entering data into cell C12 ?????, Try D12, E 12 etc etc
Spreadsheet: 165161d1341063613-same-value-but-shows-false-formulae-to-clean-and-modify-worksheet
Sheet: Report Language

Armenian | April 13
Exh. Number | Foreign Language | Helper | Date | Description | [NAME] | End Bates | Purpose | Reports
 | French, German, English |  |  | Certified US Patent No. x,xxx,xxx | NEA-LIMP0000002 | NEA-LIMP000230 |  | Sleepy Rebuttal  24 April 13, 2009  _x000D_ Bashful C-2 June 18, 2011
 | French |  |  | Certified US Patent No. x,yyy,yyy | NEA-LIMP000231 | NEA-LIMP001400 |  | Sleepy 24 April 13, 2009 Bopeep C-1 June 18, 2012
 |  |  |  | Certified US Patent No. x,xxx,zzz | NEA-LIMP002548 | NEA-LIMP002551 |  | Grumpy 17 April 13, 1999
 | Klingon, Unicorn |  |  | Certified US Patent No. a,[NAME],zzz | NEA-LIMP0003011 | NEA-LIMP003012
 | English |  |  | Certified File History of US Patent No. x,yzp,[NAME] | NEA-LIMP003013 |  |  | Sleepy Rebuttal 14 May 4, 2009
 | English |  |  | Certified File History of US Patent No. y,ued,wor | NEA-LIMP003333 | NEA-LIMP003355
 | German |  |  | Certified File History of US Patent No. d,swi,th | NEA-LIMP010001 | NEA-LIMP010141 |  | Bopeep 9, Jan. 20, 2005
Spreadsheet: 873521d1720014290-how-to-extract-the-number-of-working-hours-for-all-employees-and-extract-the-start-and-end-office-2003-time-33-aligw
Sheet: SSS2

Date | Name1 | [NAME] | Name3
01/06/2024
02/06/2024
03/06/2024
04/06/2024
05/06/2024
06/06/2024
07/06/2024
08/06/2024
09/06/2024
10/06/2024
11/06/2024
12/06/2024
13/06/2024
14/06/2024
15/06/2024
16/06/2024
17/06/2024
18/06/2024
19/06/2024
20/06/2024
21/06/2024
22/06/2024
23/06/2024
24/06/2024
25/06/2024
26/06/2024
27/06/2024
28/06/2024
29/06/2024
30/06/2024
Total
Spreadsheet: 52284d1251987954-excel-2007-combining-worksheets-sample-2-
Sheet: ExampleSheet2

PN | Description | Qty Used
1900123 | cap | 21
1900125 | inductor | 10
1900126 | cap | 5
1900128 | resistor | 21
1900129 | cap | 2
1900131 | crystal | 2
1900133 | fuse | 4
1900135 | cap | 17
1900199 | inductor | 9
1900225 | processor | 1
Spreadsheet: 233389d1367779508-counting-unique-values-from-data-on-two-separate-excel-tabs-sample-file-rs-
Sheet: TAB 1

Submitter | Company | Year | Report
IA | BB | 2012 | Report1
IA | BB | 2013 | Report1
IA | BB | 2013 | Report2
IA | BB | 2013 | Report3
DE | II | 2012 | Report2
DE | II | 2013 | Report1
DE | II | 2013 | Report2
DE | II | 2013 | Report3
Objective1: | For submitter "IA", for year 2013 ONLY, and for company "BB", count the number of UNIQUE reports listed in column D of BOTH tabs (Tab 1 and [NAME]).
Answer: | IA | BB | 2013 | 5 |  | Report 1, 2, 3, 4 and 5 (because, Report1 is repeated)
 |  |  |  | ^^^^ | ^^^^
 |  |  |  | Manually | [NAME]
Objective2: | For submitter "DE", for year 2013 ONLY, and for company "II", count the number of UNIQUE reports listed in column D of BOTH tabs (Tab 1 and [NAME]).
Answer: | DE | II | 2013 | 3 |  | Report 1, 2, and 3 (because, Report1 and Report2 are both repeated).
 |  |  |  | ^^^^ | ^^^^
 |  |  |  | Manually | [NAME]
Spreadsheet: 29677f2e-e5af-4aca-9e7a-c84f6b845a25
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
4024 | 9381 | [NAME] | Samuelson | USA | 381 | 01:22:07 | 00:01:30 | 02:24:22 | 00:01:46 | 00:42:18 | 1 | [NAME]
4024 | 12455 | [NAME] | Power | IRL | 383 | 01:31:41 | [NAME] | 02:22:48 | 00:01:33 | 00:49:43 | 2 | 04:47:12
4024 | 25604 | [NAME] | Fruen | GBR | 382 | 01:35:53 | 00:01:43 | 02:38:53 | 00:02:06 | 00:54:07 | 3 | 05:12:43
Spreadsheet: 65213d1265913913-pasting-data-from-one-sheet-to-another-with-formatting-and-cell-references-copying-example2
Sheet: columnLink

 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | Dear | [NAME] | 0
 | 0 | 0 | 0 | 0
 | 0 | Sorry you're feeling | 0 | blue
 | 0 | Maybe you should | 0 | 0
 | 0 | go see a | medium | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
Spreadsheet: 43591d1242234375-linking-drop-down-boxes-depending-comboboxes
Sheet: Sheet1

 |  |  |  | Main |  | Depndin'
 |  |  |  |  |  |  |  |  |  | Azerbaijan |  | Azerbaijan | Georgia | Russia | USA | Canada | Ukraine | France | Spain
 |  |  |  |  |  |  |  |  |  | Georgia |  | Baku | Tbilisi | Moscow | New-York | Ottawa | Kharkov | Paris | Madrid
 |  |  |  |  |  |  |  |  |  | Russia |  | Qusar | Batumi | Petesburg | Washington | Montreal | Kyiv | Marselle | Barcelona
 |  |  |  |  |  |  |  |  |  | USA |  | Yevlakh | [NAME] | Volqoqrad | Las-Angeles | Some on | Lvov | Nant | Athletico
 |  |  |  |  |  |  |  |  |  | Canada |  | Imishli | Marneuli | Stalingrad | San-Diego | On some | Dnepr | S-Etien | Bilbao
 |  |  |  |  |  |  |  |  |  | Ukraine
 |  |  |  |  |  |  |  |  |  | France
 |  |  |  |  |  |  |  |  |  | Spain
 |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 833607d1687144886-filter-with-dynamic-number-of-conditions-nested-list-formula-example-ans2
Sheet: Sheet1

Problem: Use a formula to find the count of unique Countries selected by dynamically parsing the required keys from a single text field.
Manual example:  1. Parse the keys from each yellow cell (this list of keys can be arbitrarily long) 2. Get only blue rows with one of the desired keys 3. Select all Countries for these rows 4. [NAME], then count the countries
Key | Country |  | Sample Combined Key Conditions |  |  | Expected
CAT | Aruba |  | CAT,BAM |  |  | 5
CAT | Scuba |  | BAM |  |  | 4
CAT | Pine |  | CATER |  |  | 1
CAT | Palm
CAT | Cove
CATER | Aruba
SAM | Palm
SAM | Cove
BAM | Scuba
BAM | Pine
BAM | Palm
BAM | Cove
Spreadsheet: 51652d1251287909-date-and-time-formula-help-oil-loss
Sheet: Sheet1

 |  |  | [NAME] ([NAME])
 | Date (dd/mm/yy) | Time (24hr) | Level Reading ([NAME]) | Top Up Amount ([NAME]) | Oil Loss ([NAME]/hr) | Warning Indicator
 | 2009-02-14 00:00:00 | 13:21:00 | 60 | 5 | 5.226815844172312e-06
 | 2009-02-15 00:00:00 | 02:21:00 | 21 | 39 | 3.000000000013432
 | 2009-02-18 00:00:00 | 03:30:00 | 66 | 45 | 0.6151742993841404
 | 2009-03-25 00:00:00 | 01:21:00 | 80 | 12 | 0.01432237273975095
 | 2009-03-26 00:00:00 | 02:30:00 | 90 | 120 | 4.771371769401367
 |  |  | Total Oil Loss ([NAME]) | 221 | 8.400873668354535
 |  |  |  |  | Total Oil Loss (ltrs/min)
Spreadsheet: 691142d1597506331-count-formula-on-multiple-matches-testing
Sheet: Sheet1

[NAME] | Gred2 | Gred3 |  | A | B | C | D | E | F
B | F | B
F | D | F
A | E | A
F | F | F
F | A | B
F | F | F
C | F | F
F | F | F
B | C | F
C | A | F