tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 274617d1383162172-a-formula-that-copies-and-pastes-different-text-options-in-the-same-column-test-book-102
Sheet: Sheet1

Notes
Need to have Plan Name on every line
How to move the plan name that is located in column D as the beginning of every page break or plan name break, next to every line
associated with that plan?
 |  |  |  | Procedure Code Reimbursement
Holistic Addiction Treatment
Show all data where the Date From is between 1/1/2012, 12/31/2012
Date of
Service |  | Patient |  |  | Provider | Procedure |  | Charge | Payments
AET00 |  |  | Aetna
03/26/12 |  | Client Name |  | 76526 | SK
01/02/12 |  | Client Name |  | 65119 | SK
01/02/12 |  | Client Name |  | 65122 | SK
01/02/12 |  | Client Name |  | 65123 | SK
01/02/12 |  | Client Name |  | 65126 | SK
01/02/12 |  | Client Name |  | 65129 | SK
01/03/12 |  | Client Name |  | 65133 | SK
01/03/12 |  | Client Name |  | 65134 | SK
01/03/12 |  | Client Name |  | 65135 | SK
01/03/12 |  | Client Name |  | 65182 | SK
01/03/12 |  | Client Name |  | 65185 | SK
01/03/12 |  | Client Name |  | 65188 | SK
01/03/12 |  | Client Name |  | 65190 | SK
01/04/12 |  | Client Name |  | 65515 | SK
01/04/12 |  | Client Name |  | 65522 | SK
01/07/12 |  | Client Name |  | 65698 | SK
01/07/12 |  | Client Name |  | 65701 | SK
01/07/12 |  | Client Name |  | 65703 | SK
01/09/12 |  | Client Name |  | 65711 | SK
01/09/12 |  | Client Name |  | 65712 | SK
01/10/12 |  | Client Name |  | 65717 | SK
01/10/12 |  | Client Name |  | 65722 | SK
01/04/12 |  | Client Name |  | 65728 | SK
AME05 |  |  | AMERIHEALTH
01/03/12 |  | Client Name |  | 65525 | SK
01/10/12 |  | Client Name |  | 65729 | SK
01/06/12 |  | Client Name |  | 66164 | SK
01/14/12 |  | Client Name |  | 66465 | SK
01/18/12 |  | Client Name |  | 66575 | SK
01/21/12 |  | Client Name |  | 67943 | SK
02/13/12 |  | Client Name |  | 71078 | SK
02/16/12 |  | Client Name |  | 71095 | SK
02/21/12 |  | Client Name |  | 71228 | SK
02/23/12 |  | Client Name |  | 71276 | SK
BCB00 |  |  | BCBS of Florida
03/29/12 |  | Client Name |  | 76309 | SK
06/21/12 |  | Client Name |  | 83613 | SK
06/28/12 |  | Client Name |  | 84296 | SK
06/29/12 |  | Client Name |  | 93076 | SK
01/02/12 |  | Client Name |  | 65120 | SK
01/02/12 |  | Client Name |  | 65121 | SK
01/03/12 |  | Client Name |  | 65177 | SK
01/03/12 |  | Client Name |  | 65179 | SK
01/03/12 |  | Client Name |  | 65180 | SK
01/03/12 |  | Client Name |  | 65186 | SK
01/04/12 |  | Client Name |  | 65513 | SK
01/04/12 |  | Client Name |  | 65519 | SK
01/03/12 |  | Client Name |  | 65527 | SK
01/03/12 |  | Client Name |  | 65528 | SK
01/07/12 |  | Client Name |  | 65691 | SK
01/07/12 |  | Client Name |  | 65694 | SK
Spreadsheet: 870180d1716739187-roster-selecting-unhighlighted-cell-for-next-date-cover-slates-sample
Sheet: Sheet1

 | Day Cover |  |  |  | Early Night Cover |  |  |  | Late Night Cover
 | Date | Numbers |  |  | Date | Numbers |  |  | Date | Numbers
 | 2023-10-25 00:00:00 | 458 | OT
 | 2023-10-26 00:00:00 | 382 | 436
 | 2023-11-06 00:00:00 | 361 | 426 |  |  |  |  |  | 2023-11-13 00:00:00 | 382 | 426
 | 2023-12-04 00:00:00 | 415 | 754 |  | 2023-12-05 00:00:00 | 458 | 626 |  | 2023-12-05 00:00:00 | 411 | 754
 |  | OT | OT |  |  | 707 | 754 |  | 2024-12-11 00:00:00 | 74 | OT
 |  | OT | OT |  |  | 382 | 426 |  | 2023-12-16 00:00:00 | 411 | 458
 |  | OT | OT |  |  | 361 | 626 |  | 2023-12-17 00:00:00 | OT | OT
 |  | 707 | 436 |  |  | 415 | 436 |  | 2023-12-22 00:00:00 | OT | OT
 |  | OT | 754 |  |  | 707 | 476 |  | 2023-12-27 00:00:00
 |  | OT | 476 |  |  | 707 | 754 |  | 2023-12-28 00:00:00
 | 2024-01-01 00:00:00 | 411 | 626 |  | 2024-01-02 00:00:00 | 638 | 426 |  | 2024-01-02 00:00:00 | 382 | 476
 | 2024-01-06 00:00:00 | OT | 426 |  | 2024-01-08 00:00:00 | 74 | 436 |  | 2025-01-08 00:00:00 | 415 | OT
 | 2024-01-07 00:00:00 | 415 | 754 |  | 2024-01-13 00:00:00 | 411 | 626 |  | 2024-01-13 00:00:00 | OT | 436
 | 2024-01-12 00:00:00 | OT | OT |  | 2024-01-14 00:00:00 | 361 | 754 |  | 2024-01-14 00:00:00 | 638 | OT
 | 2024-01-17 00:00:00 | OT | OT |  | 2024-01-19 00:00:00 | 382 | 426 |  | 2024-01-19 00:00:00 | 361 | OT
 | 2024-01-18 00:00:00 | 74 | 436 |  | 2024-01-24 00:00:00 | 707 | 626 |  | 2024-01-24 00:00:00 | 411 | 754
 | 2024-01-23 00:00:00 | 415 | 638 |  | 2024-01-25 00:00:00 | 638 | 476 |  | 2024-01-25 00:00:00 | 707 | 626
 |  | OT | OT
Spreadsheet: 864205d1711468407-how-do-i-find-the-sum-total-amount-products-aligw
Sheet: Book1

Product | Apple |  | Orange |  | [NAME] |  | [NAME] |  | SUBTOTAL
Price | 20000 |  | 40000 |  | 80000 |  | 50000
[NAME] |  |  |  |  | 1 | 2024-03-26 00:00:00 |  |  | 80000
[NAME] | 2 | 2024-03-26 00:00:00 | 10 | 2024-03-26 00:00:00 |  |  |  |  | 60000
George | 5 | 2024-03-26 00:00:00 | 8 | 2024-03-26 00:00:00 |  |  | 25 | 2024-03-26 00:00:00 | 110000
Spreadsheet: 155457d1336849786-deleting-multiple-duplicates-with-criteria-filter-then-delete
Sheet: Sheet1

Article Number | version | Status
11122233 | 1 | NOK | delete
11122233 | 2 | NOK | delete
11122233 | 3 | NOK | delete
11122233 | 4 | OK | keep
44455566 | 1 | NOK | delete
44455566 | 2 | NOK | delete
44455566 | 3 | OK | keep
55588844 | 1 | OK | keep
11100055 | 1 | OK | keep
77799955 | 1 | OK | keep
11122255 | 1 | OK | keep
77799911 | 1 | NOK | delete
77799911 | 2 | OK | keep
88811177 | 1 | OK | keep
88899955 | 1 | OK | keep
Spreadsheet: 89a34f0a-b0cf-4f1d-9b5c-3cc91a933312
Sheet: Sheet1

F E D E R A Z I O N E  G I N N A S T I C A  d' I T A LI A | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
SEZIONE: G.P.T.
Denominazione gara: TROFEO GIOVANI 2° PROVA
[NAME]
Impianto ed indirizzo: PALAZZETTO "COUNTRY HOUSE" - AVELLINO
2012-05-20 00:00:00
CLASSIFICA  Generale  2° PROVA
Class. | SOCIETA' | SQUADRA | Cod.Fed | 1° PERCORSO | BONUS | PENALITA' | TOTALE | 2° PERCORSO | BONUS | PENALITA' | TOTALE | TOTALE
ORO | A.POL. PARTENOPE GINNASTICA ASS.DIL. | A | 11/000306 | 00:02:04 | 00:00:35 | 00:00:02 | 00:01:31 | 00:01:52 | 00:00:17 | 00:00:10 | 00:01:45 | 00:03:16
ORO | A.S.D. SPORTING | - | 11/002498 | 00:02:09 | 00:00:31 | 00:00:10 | [NAME] | 00:01:55 | 00:00:25 | 00:00:05 | 00:01:35 | 00:03:23
ORO | A.S.D. TRILLI | - | 11/002357 | 00:02:23 | 00:00:32 | 00:00:09 | [NAME] | [NAME] | [NAME] | 00:00:00 | 00:01:34 | 00:03:34
ARGENTO | A.S.D. GYMNIA | - | 11/001724 | 00:02:04 | 00:00:34 | 00:00:06 | 00:01:36 | 00:02:35 | 00:00:20 | 00:00:05 | 00:02:20 | 00:03:56
ARGENTO | A.POL. PARTENOPE GINNASTICA ASS.DIL. | B | 11/000306 | [NAME] | 00:00:35 | 00:00:02 | 00:01:59 | 00:02:15 | [NAME] | 00:00:05 | 00:02:02 | 00:04:01
ORO | MAGIC HARMONY A.S.D. | - | 11/001897 | 00:02:31 | 00:00:36 | 00:00:00 | 00:01:55 | 00:02:09 | 00:00:20 | 00:00:20 | 00:02:09 | 00:04:04
BRONZO | JEUNESSE | - | 11/001584 | 00:02:37 | 00:00:27 | [NAME] | 00:02:28 | [NAME] | 00:00:24 | 00:00:05 | 00:01:41 | 00:04:09
ARGENTO | SPORTING CLUB IL CUCCIOLO | A | 11/000534 | 00:02:41 | [NAME] | [NAME] | 00:02:54 | 00:02:13 | [NAME] | 00:00:05 | 00:01:52 | 00:04:46
ARGENTO | SPORTING CLUB IL CUCCIOLO | B | 11/000534 | 00:02:57 | 00:00:29 | 00:00:16 | 00:02:44 | 00:02:30 | 00:00:20 | 00:00:20 | 00:02:30 | [NAME]
BRONZO | C. GINNASTICA SAN LEUCIO DEL SANNIO A.S.D. | - | 11/002433 | 00:02:38 | 00:00:27 | 00:01:14 | 00:03:25 | 00:02:30 | 00:00:22 | 00:00:10 | 00:02:18 | 00:05:43
BRONZO | NEW GYM ASS.DIL. | - | 11/002214 | [NAME] | 00:00:36 | 00:00:00 | 00:02:36 | 00:03:00 | 00:00:20 | 00:00:30 | 00:03:10 | 00:05:46
BRONZO | A.POL. PARTENOPE GINNASTICA ASS.DIL. | C | 11/000306 | 00:03:26 | 00:00:30 | [NAME] | 00:03:38 | 00:02:53 | [NAME] | 00:00:10 | 00:02:45 | 00:06:23
 | [NAME] |  |  |  |  |  | [NAME]
 | MAIORANO ELISABETTA |  |  |  |  |  | DE GIORGIO PAOLO
COLLETTIVO
FASCIA | SOCIETA' | SQUADRA | Cod.Fed | TOTALE
ORO | A.S.D. TRILLI | - | 11/002357 | 31.7
ORO | A.S.D. SPORTING | - | 11/002498 | 28.7
ORO | SPORTING CLUB IL CUCCIOLO | B | 11/000534 | 28.1
ORO | JEUNESSE | - | 11/001584 | 27.8
ORO | SPORTING CLUB IL CUCCIOLO | A | 11/000534 | 26.6
ORO | C. GINNASTICA SAN LEUCIO DEL SANNIO A.S.D. | - | 11/002433 | 18
Spreadsheet: 824845d1680886639-count-how-many-times-a-string-of-text-is-present-in-cells-example
Sheet: Sheet1

 | Data |  | Numbers | Output
 | Sloby 25 |  | 34 | =count how many times the value in the left column is present in column B
 | Mugas 25 |  | 25 | 5
 | Strerough 34 |  | 11 | 2
 | [NAME], Seattle 11 |  | 56 | 1
 | Ciwood 56
 | Xares 25, Portland 14
 | Haco 67
 | Trock 90
 | Acoross 11
 | Esterbert 25
Spreadsheet: 135284d1325894777-match-values-in-2-columns-and-return-the-sum-im-data
Sheet: Co-Leading & Scoping

Date | Project Owner | IM | Details | Co-Leading or Scoping | Shadow Revenue | Status
FY11 | Greg | adam b |  | Co-Leading | Amount TBC | Open
FY11 | [NAME] | [NAME] |  | Co-Leading | Amount TBC | Open
FY11 | [NAME] | [NAME] |  | Co-Leading | Amount TBC | Open
FY12 | [NAME] | adam b |  | Co-Leading | 30000 | Closed
2011-10-27 00:00:00 | [NAME] | [NAME] |  | Co-Leading | Amount TBC | Open
2011-10-08 00:00:00 | [NAME] | adam b |  | Co-Leading | Amount TBC | Open
2011-10-14 00:00:00 | Violet | adam b |  | Co-Leading | Amount TBC | Open
Spreadsheet: 94015d1293789992-copying-data-from-a-table-to-another-one-copy-data-from-one-table-to-another
Sheet: DEC.

P1
JANUARY | 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
 | W | W | WP | P | V | V | V | V | V | V | V | P | P | P | P | W | W | P | P | P | P | P | W | P | P | P | P | P | P | W | P
FEBRUARY | 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
 | P | V | V | V | V1 | V1 | V1 | V1 | P
[NAME] | 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
APRIL | 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
MAY | 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
[NAME] | 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
JULY | 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
AUGUST | 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
SEPTEMBER | 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
OCTOBER | 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
NOVEMBER | 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
DECEMBER | 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
Spreadsheet: 224204d1364485633-sorting-project-task-list-with-merged-cells-sample-excelforums-2-solution
Sheet: Sheet1

 | Stage | Program Components | Sub Task | Assigned Resource | Dates | Status | Communication Manager(M)/ Participant (P) | Location (Delivery Method) | Comments
 | Stage 1 | Task #1 | Subtask #1 | [NAME], [NAME] | 2013-02-19 00:00:00 | Complete
 | Stage 1 | Task #1 | Subtask #2 | [NAME], [NAME] | 2013-02-20 00:00:00 | Complete
 | Stage 1 | Task #1 | Subtask #3 | [NAME], [NAME] | 2013-02-21 00:00:00 | Complete
 | Stage 1 | Task #1 | Subtask #4 | [NAME], [NAME] | 2013-02-22 00:00:00 | Complete
 | Stage 1 | Task #2 | Subtask #1 | [NAME], [NAME] | 2013-02-19 00:00:00 | Complete
 | Stage 1 | Task #2 | Subtask #2 | [NAME], [NAME] | 2013-02-20 00:00:00 | Complete
 | Stage 1 | Task #2 | Subtask #3 | [NAME], [NAME] | 2013-02-21 00:00:00 | Complete
 | Stage 1 | Task #3 | Subtask #1 | [NAME] | 2013-02-19 00:00:00 | Complete
 | Stage 1 |  | Subtask#2 | [NAME] | Feburary 19, 2013 | Complete
 | Stage 1 | Task #3 | Subtask #3 | [NAME] | Feburary 19, 2013 | Complete
 | Stage 1 | Task #4 | Subtask #1 | [NAME] | 2013-02-19 00:00:00 | Complete
 | Stage 2 | Task #1 | Subtask #1 | [NAME] | Feburary 19, 2013 | Complete
 | Stage 2 | Task #2 | Subtask #1 | [NAME] | 2013-02-19 00:00:00 | Complete
Spreadsheet: sally_beck__33697__Metrics 0609
Sheet: Mexico

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | Mexico
Results based on Activity through June 9, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 10
 |  | Weekly Summary - 2Q00 through 1Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-04-07 00:00:00 | 2000-04-14 00:00:00 | 2000-04-21 00:00:00 | 2000-04-28 00:00:00 | 2000-05-05 00:00:00 | 2000-05-12 00:00:00 | 2000-05-19 00:00:00 | 2000-05-26 00:00:00 | 2000-06-02 00:00:00 | 2000-06-09 00:00:00 | 2000-06-16 00:00:00 | 2000-06-23 00:00:00 | 2000-06-30 00:00:00
Postings Rollforward:
Beginning |  | 0
+ Entrances |  | 1 | 0 | 3 | 0 | 0 | 5 | 0 | 0 | 0 | 1
- Exits |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Executions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ending
 | Dollar Value of Transactions
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Average
Postings Rollforward:
Beginning |  | 100.5
+ Entrances |  | 0 | 14.3 | 1
- Exits |  | 0 | 0 | 0
+/- [NAME] |  | 0 | 0 | -13
- Executions |  | 0 | 0 | 0
Ending
Average Deal Size
 |  |  |  |  |  |  |  | Forward Quarters
 | Actual |  |  | Current Quarter |  | Per |  |  |  |  |  |  |  | Total Year
 | 1Q00 |  |  | 2Q00 |  | Hot List |  | 3Q00 |  |  | 4Q00 |  |  | 2000 |  |  | 1Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions | 0 | 0 |  | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0
DPR/MPR |  | 0 |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0
Postings | 0 | 0 |  | 2 | 0.871 |  |  | 2 | 0 |  | 4 | 34 |  |  |  |  | 2 | 4
Identified Margin
Budget |  | 4.7 |  |  | 4.7 |  |  |  | 4.7 |  |  | 4.7 |  |  |  |  |  | 6.3
$ Coverage
$ millions
Spreadsheet: 694362d1599567977-copy-names-from-one-sheet-to-other-workbook-sheets-sample-scoring-spreadsheet1
Sheet: ORG 10

ESCF PROPOSAL EVALUATION SCORING
ORGANISATION NAME: |  | FIRST ROUND RESULT
NAME OF PROPOSAL:
 | Potential Impact - minimum threshold 42% | SCORE | NOTES
 | a)    Relevance and extent of the specific social challenge - What is the scale of the social challenge in the geographic area where the planning will take place? (15%)
 | b)   Potential impact on the challenge - What is the extent of the potential impact of this innovation on this social challenge in this geographic area? (15%)
 | c)    Evidence - What robust national and international evidence exists to support the model or innovation in terms of its effectiveness? What is the evidence on the cost implications of the model compared to alternative approaches? (20%)
 | d)   Scope of potential impact geographically - What is the evidence that the innovation is relevant across EU Member [NAME]? What evidence is there that the approach is relevant in Central and Eastern European Countries? To what extent has the innovation been applied in other countries in Europe? (10%)
 | e)    Promotion of citizen-centred approaches - Does the innovation support service users and end beneficiaries to be self-directed and to be involved in plans to scale social service innovations? (10%)
 | Potential Impact Total
 | Capacities - minimum threshold 12% | SCORE | NOTES
 | a)    Capacities of the applicants - Do the organisation(s) applying have the capacities to produce the plan for scaling the innovation? (10%)
 | b)   Networks and linkages - What is the evidence that key partners (public, private, non-profit, philanthropic) are open to collaborating on developing the plan in the geographic area where the planning will take place and what are the current linkages between the proposers and these organisations? Do the applicants have strong international linkages that could assist with this planning? (10%)
 | Capacities Total
 | Quality of the application to develop the plan - minimum threshold 6% | SCORE | NOTES
 | a)    Activities - Description of activities, timeframe, methodology, risk management. (5%)
 | b)   Budget - Are expenditures associated with the proposed planning activities reasonable and well-substantiated? (5%)
 | Quality of the application to develop the plan Total
 | Total Score
Spreadsheet: 97629d1296753401-cross-sheet-calc-that-would-omit-0-possible-solution-but-am-getting-a-ref-error-2011trending
Sheet: 0124

01/24/11  Performance Data
 |  | 1st Work |  |  |  | QC |  |  | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT SURNOTACKL MNBENMMIG SURDTHCERT | SURBENCSMG SURFRM SURVALDOD SURCUSFLUP SURSPLIGO SRSPNIGO SURBENSPLT RAIDPS RAIDNP/TAIDIN-IA FAID/FAIDWF IAID/FAIDCO SURINQ | SURBENRSCH SURBENUPDT RAIDPB RAIDAR | SURBENLEGL SURPAYLNPO | MNTBENMMIG SURSPLIGO SURSPNIGO SURBENSPLT RAIDPS FAID | SURBENRSCH (PASS) SURBENUPDT (PASS/FAIL) RAIDPB RAIDAR | SURBENRSCH (FAIL)
 |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint | 5 |  | 6 |  |  |  |  | 58 | 2 | reporting/capmgmt | 4.5 | 12.88888888888889
 | Dustin | 5 | 7 | 6 |  |  |  |  | 79 | 2.5 | trending/capmgmt | 4 | 19.75
 | Sharron |  | 25 | 7 |  |  |  |  | 131 |  |  | 8 | 16.375
 | Roxy | 11 | 7 | 12 |  |  |  |  | 139 |  |  | 7.75 | 17.93548387096774
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | Ana | 10 | 13 | 11 |  |  |  |  | 147 |  |  | 9 | 16.33333333333333
 |  |  |  |  |  |  |  |  | 0
 | [NAME] | 15 | 12 | 19 |  |  |  |  | 218 | 1 | CISS | 8 | 27.25
 | Petra | 24 | 6 | 8 |  |  | 1 | 2 | 154 | 1 | training | 10.5 | 14.66666666666667
 | Regina |  |  |  |  | 3 | 18 |  | 150 | 0.5 | SWT | 9 | 16.66666666666667
 | Noy | 2 |  | 1 |  | 2 | 9 | 6 | 136 | 0.5 | SWT | 8.75 | 15.54285714285714
 | [NAME] |  |  |  |  | 5 | 25 |  | 210 |  |  | 9.75 | 21.53846153846154
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | SME | 0.01 | 1
 | Michelle | 32 |  |  |  |  |  |  | 64 |  | SME | 3.5 | 18.28571428571428
 | Keisha |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | [NAME] |  | 9 | 10 |  |  |  |  | 107 | 1 | training | 7.25 | 14.75862068965517
TEAM TOTALS | Pts Earned: | 2 | 3 | 8 | 12 | 2 | 8 | 8 |  |  |  |  | 200.2330723935563
 | TASK VOLUME: | 104 | 79 | 80 | 0 | 10 | 53 | 8 | 1593 | 8.5 |  | 90.03000000000002 | 17.69410196601133
 | Pts Earned: | 208 | 237 | 640 | 0 | 20 | 424 | 64
 |  |  |  |  |  |  |  | Average PTS | 99.564375 |  | Total Task Volume |  | 334
 | MID-DAY PPH  16.73
Spreadsheet: 45328d1244090909-nesting-vlookup-in-if-vice-versa-and-pivot-table-copy-of-sample-model-cat1-cat2-ytd
Sheet: Apr Cat2

Model | Amount-Cat2
750 | 0
900 | 0
AB | 0
AG | 0
AN | 0
BX | 0
BZ | 0
CA | 0
CB | 0
MF | 0
MR | 0
OA | 0
OB | 0
OR | 0
RA | 0
RF | 0
TM | 0
ZP | 0
Grand Total | 0
Spreadsheet: 86237d1286263832-excel-2007-combining-data-from-multiple-excel-files-sample2
Sheet: Count

Type | QTY | Period | Category
A | 3 | Week 1 | Y
B | 1 | Week 1 | Y
C | 2 | Week 1 | Y
D | 1 | Week 1 | Y
E | 1 | Week 1 | Y
F1 | 175 | Week 1 | Y
F2 | 62 | Week 1 | Y
F3 | 78 | Week 1 | Y
[NAME] | 110 | Week 1 | Y
G2 | 35 | Week 1 | Y
G3 | 5 | Week 1 | Y
G4 | 28 | Week 1 | Y
G5 | 70 | Week 1 | Y
G6 | 72 | Week 1 | Y
G7 | 75 | Week 1 | Y
G8 | 110 | Week 1 | Y
Spreadsheet: 867062d1713962936-find-stock-symbol-in-a-string-sample-find-symbol
Sheet: Sheet1

 |  |  |  | Current Formula Result |  | Desired result
 |  | BOT +615 KYN @8.1199 |  |  |  | KYN
 |  | SOLD -3 KYN @8.17 |  |  |  | KYN
 |  | BOT +18 KYN @7.95 |  |  |  | KYN
 |  | SOLD -22 KYN @8.22 |  |  |  | KYN
 |  | SOLD -15 KYN @8.42 |  |  |  | KYN
 |  | ORDINARY DIVIDEND~KYN |  |  |  | KYN
 |  | BOT 15.222 KYN UPON DIVIDEND REINVEST |  |  |  | KYN
 |  | Ordinary Dividend~KYN 142.50 US$ |  |  |  | KYN
 |  | BOT 14.953 KYN UPON DIVIDEND REINVEST |  |  |  | KYN
 |  | BOT 15.542 KYN UPON DIVIDEND REINVEST |  |  |  | KYN
 |  | ORDINARY DIVIDEND~KYN |  |  |  | KYN
 |  | Ordinary Dividend~KYN 140.52 US$ |  |  |  | KYN
 |  | BOT 14.689 KYN UPON Dividend Reinvest |  |  |  | KYN
 |  |  |  | When Sorting and searching for unique Symbols I get the same symbol, but the result in the highlighted cells are seen as a different symbol.  That is because the highlighted cell formula produces °spaces° after the symbol. Hence making it a unique symbol although visibly all are same result. I need the symbol only and no spaces in the result. Symbol can be as many as 6 characters and are formatted in the statement as shown in column C.
Spreadsheet: 2162b30d-6c81-4b09-a3bc-3d48ad675515
Sheet: Supp Table 1 - Mixed

Gene name | Functional Category | Domain/Function | ASEL | Neurons | Muscle | Gut | Hyp | ASER | ASE
col-49 | cell/organelle | Collagen | +/- |  |  |  |  | - | ne
npp-3 | cell/organelle | Collagen | +/- |  |  |  |  | [NAME] | +/-
D2096.8 | chromatin | Nucleosome assembly (NAP family) | +/- |  |  |  |  | - | [NAME]
rba-1 | chromatin | Chromatin associated, WD40 [NAME] (CAF1/NURF55) | +/- | - | + | + | - | - | ne
snfc-5 | chromatin | SWI-SNF chromatin remodeling complex, Snf5 subunit | +/- | + | - | + | - | +/- | [NAME]
pkc-3 | blastomere | Protein kinase C | +/- |  |  |  |  | - | +/-
par-1 | blastomere | Serine/threonine kinase | +/- |  |  |  |  | - | ne
gsk-3 | blastomere | [NAME] | +/- |  |  |  |  | +/- | +/-
nuo-3 | metabolism | NADH:ubiquinone oxidoreductase | +/- |  |  |  |  | - | [NAME]
kin-10 | signaling | Casein kinase II | +/- |  |  |  |  | + | +
rnp-7 | splcing | U1 small nuclear ribonucleoprotein (RRM domain) | +/- |  |  |  |  | +/- | +/-
pfs-2 | splcing | Polyadenylation factor I complex, subunit PFS2 | +/- |  |  |  |  | - | -
rnp-4 | splcing | member of the exon-exon junction complex (RRM) | +/- |  |  |  |  | - | ne
bed-1 | transcription | BED-type Zn finger domain | +/- |  |  |  |  | ne | ne
Spreadsheet: 855193d1704874094-unique-formula-and-add-12-months-for-every-unique-value-that-is-returned-sample-data
Sheet: Data Sample

Fiscal year/period.Fiscal year/period Level 01 | Project Name
Wednesday, 1 November 2023 | PLM - Dosing
Wednesday, 1 November 2023 | PLM - Dosing
Wednesday, 1 November 2023 | PLM - Dosing
Wednesday, 1 November 2023 | PLM - Dosing
Sunday, 1 October 2023 | PLM - Dosing
Sunday, 1 October 2023 | PLM - Dosing
Sunday, 1 October 2023 | PLM - Dosing
Sunday, 1 October 2023 | PLM - Dosing
Sunday, 1 January 2023 | High Connectivity
Monday, 1 May 2023 | High Connectivity
Wednesday, 1 March 2023 | High Connectivity
Wednesday, 1 November 2023 | High Connectivity