tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 137279d1327031427-how-to-consolidate-large-quantity-of-arrows-into-one-cell-consolidation
Sheet: Sheet1

INPUT |  |  | OUTPUT
CODIGO | CANTIDAD |  | CODIGO | CANTIDAD
E1200 | 1 |  | E1200
E2500 | 1 |  | E2500
E1200 | 1 |  | WAP54G | 0
E2500 | 1 |  | WUSB54GC
WAP610N | 1
WUSB54GC | 15
E1200 | 2
WUSB54GC | 1
E1200 | 1
E2500 | 1
Spreadsheet: 6e310d43-6181-472b-9d61-eaf9b656fecb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | International Core Equity Fund
 | [NAME]
 | Inception Date | 2013-03-26 00:00:00
 |  | Class L | Class N | MSCI World Ex-US
 | Date | QICLX | QICNX | Index
* | 2013-03-31 00:00:00 | 0.006 | 0.006 | 0.0002089250916119667
 | 2013-04-30 00:00:00 | 0.0725646123260435 | 0.0725646123260435 | 0.04539428727161177
 | 2013-05-13 00:00:00 | -0.0426 | -0.0436 | -0.0224
 | 2013-06-13 00:00:00 | -0.009680542110358181 | -0.009689922480620172 | -0.03745691000284446
 | 2013-07-31 00:00:00 | 0.05180840664711628 | 0.05283757338551842 | 0.05320026829906244
 | 2013-08-31 00:00:00 | -0.03624535315985133 | -0.03717472118959109 | -0.01288183038461821
 | 2013-09-30 00:00:00 | 0.087753134 | 0.0878378378 | 0.070664662
 | 2013-10-31 00:00:00 | 0.0283687943 | 0.0283939663 | 0.0335525109
 | 2013-11-30 00:00:00 | 0.009482758620689813 | 0.008628127696289845 | 0.006128182470277022
 | 2013-12-31 00:00:00 | 0.011769782 | 0.011875686 | 0.01506515
 | 2014-01-31 00:00:00 | -0.04765957446808511 | -0.04765957446808522 | -0.04036735745759268
 | 2014-02-28 00:00:00 | 0.047363717605 | 0.047363717605 | 0.05457177515126
 | * partial month return, inception date 3/26/2013
 | Month-end Returns as of | Class L | Class N | MSCI World Ex-US
 | February 28, 2014 | QICLX | QICNX | Index
 | 1 Year
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.1817574379346305 | 0.179862550667945 | 0.1698975778193037
 | Since Inception Annualized Return
 | Since Inception Annualized Monthly Volatility | 0.1541865287328832 | 0.1552551713775161 | 0.1307269016330023
 | Quarter-end Returns as of | Class L | Class N | MSCI World Ex-US
 | December 31, 2013 | QICLX | QICNX | Index
 | 1 Year
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.1847824143116015 | 0.1828826766508886 | 0.1560235618063688
 | Since Inception Annualized Return
Spreadsheet: 130184d1322115561-how-to-use-if-formula-for-change-price-copy-of-december
Sheet: 31

 |  |  |  | 2011-12-31 00:00:00
Newspaper | Price | Quantity | Total
Value | 1.1 |  | 0
Value1 | 0.98 |  | 0 |  |  |  | 1
Value2 | 1.63 |  | 0
Value3 | 1.63 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.2 |  | 0
Value10 | 0.98 |  | 0
Value11 | 0.98 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: 99ae44b0-8fbe-449c-8768-2eb6a7fa8e7d
Sheet: Labor Rates

 |  | Replacement Labor Rates Price Sheet
 | Item Number | Labor Category | [NAME]
 |  |  | Base Year | Renewal Year 1 | Renewal Year 2 | Renewal Year 3 | Renewal Year 4 | Renewal Year 5 | Renewal Year 6
 | 1
Spreadsheet: 124191d1318233479-names-based-on-team-names-different-teams
Sheet: Overall Details

Name | Department
Name 1 | Team 1
Name 2 | Team 1
Name 3 | Team 1
Name 4 | Team 2
Name 5 | Team 3
Name 6 | Team 3
Name 7 | Team 1
Name 8 | Team 3
Name 9 | Team 2
Name 10 | Team 1
Spreadsheet: 735961d1623279180-help-on-calculating-deposit-amounts-based-on-percentages-and-adding-totals-for-each-month-example-summary-sheet-calculation
Sheet: Sales Progress Tracker

Instructions | Once data is entered, change row fill color to the following :- | GREEN fill - Deal progressing smoothly | ORANGE Fill - Minor delays or potential issue | RED fill - Major issue, deal may not proceed
[NAME] | Date added to CRM / Database | Next action required and Due Date | Date of 1st Conversation | Date Became Opportunity | Qualified(Q) | Date of [ Insert Next Step of Sales Process] | Date of [ Insert Next Step of Sales Process] | Date of [ Insert Next Step of Sales Process] | Date Prelim Signed | Value of Prelim | Date Contract Signed | Contract Value | Gross Margin on Contract | Net Margin on Contract | Contract Start Date | Target Completion date
[NAME] Q2 | Date added to CRM / Database | Next action required and Due Date | Date of 1st Conversation | Date Became Opportunity | Qualified(Q) or Trip Wire Purchase (TW) | Date of [ Insert Next Step of Sales Process] | Date of [ Insert Next Step of Sales Process] | Date of [ Insert Next Step of Sales Process] | Date Prelim Signed | Value of Prelim | Date Contract Signed | Contract Value | Gross Margin on Contract | Net Margin on Contract | Contract Start Date | Target Completion date
[NAME] | Date added to CRM / Database | Next action required and Due Date | Date of 1st Conversation | Date Became Opportunity | Qualified(Q) or Trip Wire Purchase (TW) | Date of [ Insert Next Step of Sales Process] | Date of [ Insert Next Step of Sales Process] | Date of [ Insert Next Step of Sales Process] | Date Prelim Signed | Value of Prelim | Date Contract Signed | Contract Value | Gross Margin on Contract | Net Margin on Contract | Contract Start Date | Target Completion date
Lead Name Q4 | Date added to CRM / Database | Next action required and Due Date | Date of 1st Conversation | Date Became Opportunity | Qualified(Q) or Trip Wire Purchase (TW) | Date of [ Insert Next Step of Sales Process] | Date of [ Insert Next Step of Sales Process] | Date of [ Insert Next Step of Sales Process] | Date Prelim Signed | Value of Prelim | Date Contract Signed | Contract Value | Gross Margin on Contract | Net Margin on Contract | Contract Start Date | Target Completion date
Spreadsheet: lisa_gang__22311__ENA_PGE_JUNE_4_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-06-04 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  | Total In To PGE Trans
0100 | 0 | 0 | 0 | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0
0700 | 25 | 25 | 50 | 25 | 25
0800 | 25 | 25 | 50 | 25 | 25
0900 | 25 | 25 | 50 | 25 | 25
1000 | 25 | 25 | 50 | 25 | 25
1100 | 25 | 25 | 50 | 25 | 25
1200 | 25 | 25 | 50 | 25 | 25
1300 | 25 | 25 | 50 | 25 | 25
1400 | 25 | 25 | 50 | 25 | 25
1500 | 25 | 25 | 50 | 25 | 25
1600 | 25 | 25 | 50 | 25 | 25
1700 | 25 | 25 | 50 | 25 | 25
1800 | 25 | 25 | 50 | 25 | 25
1900 | 25 | 25 | 50 | 25 | 25
2000 | 25 | 25 | 50 | 25 | 25
2100 | 25 | 25 | 50 | 25 | 25
2200 | 25 | 25 | 50 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24966 | BPA(G)24966 | BPA(G)24966 | BPA(G)24661 | BPA(G)24718
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP
 | MID | SNCL | TID | MORGAN | SDGE
 | MID(T)CPJK/TRACEY/WESLEY | ISO(T)CPJK/NP15 | TID(T)CPJK/TRACEY/WESLEY | APX(L)NP15 | ISO(T)MALIN/NP15
 | MID(L)WESLEY | SNCL(L)NP15 | TID | ISO(T)MALIN/NP15 | SDGE(L)NP15
 |  |  | TID(L)WESLEY | APX(L)NP15
Spreadsheet: 76560d1277117831-excel-2007-if-condition-test
Sheet: Sheet1 (2)

CSA | 11 | 15 | 16 | 17 | 18 | 19 | 20 | 25 | 30 | 35 | 39 | 40
TL | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 4 | 4 | 4 | 5
QTL | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3
Spreadsheet: 55781d1255968703-pivot-tables-help-on-pivot-tables
Sheet: Sheet2

 | 09/13/2009 12:01:00 AM | Week 37
 | 09/20/2009 12:01:00 AM | Week 38
 | 09/27/2009 12:01:00 AM | Week 39
 | 10/04/2009 12:01:00 AM | Week 40
 | 10/11/2009 12:01:00 AM | Week 41
 | 10/18/2009 12:01:00 AM | Week 42
 | 10/25/2009 12:01:00 AM | Week 43
 | 11/01/2009 12:01:00 AM | Week 44
 | 11/08/2009 12:01:00 AM | Week 45
 | 11/15/2009 12:01:00 AM | Week 46
 | 11/22/2009 12:01:00 AM | Week 47
 | 11/29/2009 12:01:00 AM | Week 48
 | 12/06/2009 12:01:00 AM | Week 49
 | 12/13/2009 12:01:00 AM | Week 50
 | 12/20/2009 12:01:00 AM | Week 51
 | 12/27/2009 12:01:00 AM | Week 52
 | 01/03/2010 12:01:00 AM | Week 1
 | 01/10/2010 12:01:00 AM | Week 2
 | 01/17/2010 12:01:00 AM | Week 3
 | 01/24/2010 12:01:00 AM | Week 4
 | 01/31/2010 12:01:00 AM | Week 5
 | 02/07/2010 12:01:00 AM | Week 6
Spreadsheet: 779090d1651583817-sum-datas-by-date-across-different-sheets-sample
Sheet: September

Date | Sales
2022-09-01 00:00:00 | 1
2022-09-02 00:00:00 | 1
2022-09-03 00:00:00 | 1
2022-09-04 00:00:00 | 1
2022-09-05 00:00:00 | 1
2022-09-06 00:00:00 | 1
2022-09-07 00:00:00 | 1
2022-09-08 00:00:00 | 1
2022-09-09 00:00:00 | 1
2022-09-10 00:00:00 | 1
2022-09-11 00:00:00 | 1
2022-09-12 00:00:00 | 1
2022-09-13 00:00:00 | 1
2022-09-14 00:00:00 | 1
2022-09-15 00:00:00 | 1
2022-09-16 00:00:00 | 1
2022-09-17 00:00:00 | 1
2022-09-18 00:00:00 | 1
2022-09-19 00:00:00 | 1
2022-09-20 00:00:00 | 1
2022-09-21 00:00:00 | 1
2022-09-22 00:00:00 | 1
2022-09-23 00:00:00 | 1
2022-09-24 00:00:00 | 1
2022-09-25 00:00:00 | 1
2022-09-26 00:00:00 | 1
2022-09-27 00:00:00 | 1
2022-09-28 00:00:00 | 1
2022-09-29 00:00:00 | 1
2022-09-30 00:00:00 | 1
Spreadsheet: 66425d1267086995-create-list-from-pivot-table-testlistfrompivot
Sheet: Report

[NAME] |  | Validation List | retrieved from Sheet : | Pivot
Jake
[NAME]
 |  | staff member: | [NAME]
 |  |  |  | yellow | red | blue
 |  | 0 | quote (not converted) | 2 | 0 | 5
 |  | 1 | sale (converted) | 1 | 2 | 1
 |  | 2 | total customers | 3 | 2 | 6
 |  | 3 | payment | 50 | 50 | 100
Spreadsheet: 94183d1294067777-formula-for-sport-rankings-wrestlingleage
Sheet: 135

Weight | Ranking | First Name | Last Name | School | Section | Grade
135 | 1 | Nick | Pena | Selma | CS | 12 | 2010 CIF 1
135 | 2 | Shane | [NAME] | Oakdale | SJ | 12 | 2010 CIF 3
135 | 3 | Shane | Yacuta | Porterville | CS | 12 | 2010 CIF 4
135 | 4 | Natrelle | Demison | Bakersville | CS | 11 | 2010 CIF 5
135 | 5 | Jorge | Barajas | [NAME] | CC | 11
135 | 6 | Willie | Fox | Gilroy | CC | 11 | reno 2
135 | 7 | [NAME] | Phaysamone | Clovis East | CS | 11 | zink 1
135 | 8 | Juan | Salas | Clovis | CS | 12 | zink 2
135 | 9 | [NAME] | [NAME] | Poway | SD | 11 | reno t12
135 | 10 | [NAME] | Micou | [NAME] | SS | 11 | reno t12
Spreadsheet: 853658d1703583765-search-from-two-sheet-two-different-column-in-two-seach-box-search_revised_hans
Sheet: Step1

Date | Category | [NAME] | TGNo | Party Name | Code | Item Name | Process | IP Length | FW Size | FMC | 1st Part |  |  | 2nd Part | HEader18
2023-09-12 00:00:00 | 8C | A-1256 | AC-125/X | Apple Inc | 12563 | Iphone 11 |  | ABC | 440 | 45 | 2563 |  |  | 564 | ABC-DSC/SE
2023-09-12 00:00:00 | 8C | PC-3458 | BC-125/X | Google Inc | 9781 | X-Watch |  | PLAT | 350 | 61 | 643 |  |  | 6314 | SALA-LA
2023-09-13 00:00:00 | 8C | A/658 |  | Apple | 2364 | Ultra |  | Disc | 90 | 71 | 479 |  |  | 3641 | MAS/RAKE-45
2023-09-13 00:00:00 | 4C | DC/536 | CS-536 | Microsoft | 61364 | [NAME] |  | ABC | 145 | 90 | 634 |  |  | 792 | SALMON-50/TC-15
 |  |  |  |  |  |  |  | 1st Sub | W1 | FM1 | 1st Sub IN | 2nd Sub | 2nd Sub IN | Oqty
2023-09-12 00:00:00 | MCX-2 | TC-44 | DAC-X/4 | Indian Jones | 6356 | Avatar | XAB | DLC | 636 | 25 | 456 | 256 |  | 636
2023-09-13 00:00:00 | MCX-3 | AB/663 | MC-34/36 | Microsoft Corp | 9423 | Lumia | DAC | MSC | 36 | 19 | 776 | 36 | LD-45 | 75
2023-09-13 00:00:00 | DCV-25 | A/658 | TC-46/6 | Apple Inc | 462 | Apple 13 | MAC | POS | 44 | 12 | 684 | 44 | MS6 | 336
2023-09-13 00:00:00 | DC-14 | J-44 | AB-463/8 | Edward Co. Pvt | 142 | [NAME] | STIGMA | CCS | 96 | 40 | 634 | 63 | PET | 124
2023-09-13 00:00:00 | MAX-12 | LS-63 | MC-test-36 | Google | 63 | [NAME] | MA-C | MSCX | 102 | 35 |  | 634 | POLY | 63
Spreadsheet: 237561d1369247401-advice-please-need-to-track-devices-issue-and-dates-deviceserviceregister-sample-ddev
Sheet: Issue Register

ISSUE REGISTER TABLE
ENTRY FIELDS |  |  | RETRIEVED FIELDS
Date | Status | Device_No | Device_Name | Date_Purchd | Age_in_Mths | Dept_No | Dept_Name | Contact_Name | Yr_Mth | Contact_TelNo
2013-05-01 00:00:00 | 1-Logged | 1
2013-05-01 00:00:00 | 1-Logged | 3
2013-05-01 00:00:00 | 1-Logged | 5
2013-05-01 00:00:00 | 2-In Progress | 1
2013-05-01 00:00:00 | 2-In Progress | 3
2013-05-01 00:00:00 | 3-Resolved | 1
2013-05-01 00:00:00 | 4-Scrapped | 5
2013-05-02 00:00:00 | 3-Resolved | 3
2013-06-01 00:00:00 | 1-Logged | 4
2013-06-01 00:00:00 | 2-In Progress | 4
2013-06-01 00:00:00 | 3-Resolved | 4
2013-06-09 00:00:00 | 1-Logged | 6
2013-06-11 00:00:00 | 2-In Progress | 6
2013-06-14 00:00:00 | 3-Resolved | 6
2013-06-20 00:00:00 | 1-Logged | 2
2013-06-21 00:00:00 | 1-Logged | 7
Spreadsheet: 757935d1638541963-conditional-formatting-for-difference-greater-or-less-than-5-samplecf-etaf
Sheet: Sheet1

 |  |  |  | Manual Example
Overall Performance |  |  |  | Overall Performance |  |  | Overall Performance |  |  | Overall Performance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If the difference between A6 and [NAME] is equal to or greater than 5% then A6 is red If the difference between A6 and [NAME] is equal to or less than 5% then A6 is amber If [NAME] is greater than B6 then [NAME] is green
Actual | Target |  |  | Actual | Target |  | Actual | Target |  | Actual | Target
0.89 | 0.95 |  |  | 0.9 | 0.95 |  | 0.95 | 0.95 |  | 1 | 0.95
Spreadsheet: 688488d1595821673-how-to-calculate-task-schedule-based-on-4-days-work-and-4-days-off-including-weekends-qadeerume
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | 4x4 Schedule - 8hrs = 1day  (4 days work and 4 days OFF based on hours)
 |  |  |  |  |  |  |  |  |  |  |  | Legend: | [NAME] cells
 |  |  |  |  |  |  | Helper Columns
 | ID | Task Name |  | Duration (Hr/Hrs.) | Start | Finish | Hrs |  | MOD |  |  | Tasks | hrs. | Start Date | Finish Date
 |  | Task Name |  | 8 | 2020-07-01 00:00:00 |  |  |  |  |  |  | Task 1 | 8 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 |  |  | 8 | 2020-07-01 00:00:00
 |  | Task Name 2 |  | 8 |  |  |  |  |  |  |  | Task 2 | 8 | 2020-07-02 00:00:00 | 2020-07-02 00:00:00 |  |  | 8
 |  | Task Name 3 |  | 4 |  |  |  |  |  |  |  | Task 3 | 4 | 2020-07-03 00:00:00 | 2020-07-03 00:00:00 |  |  | 4
 |  | Task Name 4 |  | 6 |  |  |  |  |  |  |  | Task 4 | 6 | 2020-07-03 00:00:00 | 2020-07-04 00:00:00 |  |  | 6
 |  |  |  | 4 |  |  |  |  |  |  |  | Task 5 | 4 | 2020-07-04 00:00:00 | 2020-07-04 00:00:00 |  |  | 4
 |  |  |  | 6 |  |  |  |  |  |  |  | Task 6 | 6 | 2020-07-04 00:00:00 | 2020-07-09 00:00:00 |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | Task 7 | 8 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | Here 4 days completed i.e. 32hrs. Straight <---- |  | 8 | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Task 8 | 8 | 2020-07-02 00:00:00 | 2020-07-02 00:00:00 |  |  | 8
 |  |  |  |  | added days | int(sum(hrs)/8) |  |  |  |  |  | Task 9 | 8 | 2020-07-03 00:00:00 | 2020-07-03 00:00:00 |  |  | 8
 |  |  |  |  | added 4 days off | int(sum(hrs)/32) |  |  |  |  |  | Task 10 | 8 | 2020-07-04 00:00:00 | 2020-07-04 00:00:00 |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | Task 11 | 8 | 2020-07-09 00:00:00 | 2020-07-09 00:00:00 | <--- after 4 days OFF, the next date is taken i.e. Thu 09/Jul/20 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | Task 12 | 8 | 2020-07-10 00:00:00 | 2020-07-10 00:00:00 |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | Task 13 | 8 | 2020-07-11 00:00:00 | 2020-07-11 00:00:00 |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | Task 14 | 8 | 2020-07-12 00:00:00 | 2020-07-12 00:00:00 |  |  | 8
Spreadsheet: 848355d1699074373-how-to-filter-select-specific-strings-from-a-big-database-if-and-or-search-left-example-for-forum-3-nov-2023
Sheet: Forum

Some examples for strings that occur in the big data sheet (80 columns; 900 rows) |  |  |  | Two attemps from myself (but not succesful yet)
Attempt 1
Apparatus for controlling a flow of molten source material | Apparatus for controlling something different | A method for controlling a flow
A method of improving a measurement of a parameter of interest | A method of improving a measurement of a parameter of interest | A method as claimed in claim 1
A lithographic apparatus | A lithographic apparatus comprising: [NAME] and the processing arrangement of claim XXX. | Exposure apparatus
An apparatus to perform the method of any of claims 1 to 14. | An apparatus | An apparatus, comprising a component
Method for control a flow | Method for controlling a flow according to claim 1 | The method for controlling a flow according to claim 1 or 2
Attempt 2
Apparatus for controlling a flow of molten source material | Apparatus for controlling something different | A method for controlling a flow
A method of improving a measurement of a parameter of interest | A method of improving a measurement of a parameter of interest | A method as claimed in claim 1
A lithographic apparatus | A lithographic apparatus comprising: [NAME] and the processing arrangement of claim XXX. | Exposure apparatus
An apparatus to perform the method of any of claims 1 to 14. | An apparatus | An apparatus, comprising a component
Method for control a flow | Method for controlling a flow according to claim 1 | The method for controlling a flow according to claim 1 or 2 |  |  |  |  |  | How can I adapt the formula to only exclude strings that start with "Method", "A method", "The Method"?
Spreadsheet: 862591d1710266986-how-to-pull-data-from-the-next-available-date-if-the-date-isnt-an-exact-match-problem-sample-workbook
Sheet: analysis

date | actual | expected | last | Match | Index | [NAME] | [NAME]
2020-05-12 00:00:00 | -0.008 | -0.008 | -0.004
2020-04-10 00:00:00 | -0.004 | -0.003 | 0.001
2020-03-11 00:00:00 | 0.001 | 0.002 | 0.001
Spreadsheet: 262170d1378012889-choosing-one-of-the-duplicate-customer-info-testworkbook_unsort_-ijulian-_
Sheet: Sales

Salesman | CUSTOMER | CHANGE DATE | SOLD DATE | CONTRACT | STATUS | NET VOLUME | helper [NAME] | helper column2
[NAME] | 2012 A J And Carol Manker Family Trust Dated 06/22/2012,  9-180038527 | 2013-03-09 00:00:00 | 2013-03-09 00:00:00 | 16684645 | GOOD | 10196
VIOLETTA | Abalos, Heather Oro 9-178537891 | 2013-03-20 00:00:00 | 2013-03-20 00:00:00 | 16687558 | GOOD | 13760
VIOLETTA | Abalos, Heather Oro 9-178537891 | 2013-05-08 00:00:00 | 2013-03-20 00:00:00 | 16687558 | CANCEL | -13760
SHARON | Abantao, [NAME] 9-178524376 | 2013-03-30 00:00:00 | 2013-03-30 00:00:00 | 16690348 | PENDING | 20499
MARILYN | Abshire, Kimberly D 9-175949879 | 2012-11-18 00:00:00 | 2012-11-18 00:00:00 | 16659635 | GOOD | 9770
STEVE | Academia, [NAME] | 2013-08-04 00:00:00 | 2013-08-04 00:00:00 | 16870401 | GOOD | 14420
STEVE | Academia, [NAME] | 2013-08-10 00:00:00 | 2013-08-04 00:00:00 | 16870401 | CANCEL | -14420
RUBEN | Acosta, Josafath 9-177958678 | 2013-01-19 00:00:00 | 2013-01-19 00:00:00 | 16673452 | PENDING | 7000
RUBEN | Acosta, Josafath 9-177958678 | 2013-01-28 00:00:00 | 2013-01-19 00:00:00 | 16673452 | CANCEL | -7000
WILLIAM | Adams, Jr, [NAME] 9-178588989 | 2013-03-17 00:00:00 | 2013-03-17 00:00:00 | 16686589 | GOOD | 14420
VERONICA | Adams, Lannia Alvanie 9-178968403 | 2013-05-04 00:00:00 | 2013-05-04 00:00:00 | 16701220 | PENDING | 2420
VERONICA | Adams, Lannia Alvanie 9-178968403 | 2013-05-14 00:00:00 | 2013-05-04 00:00:00 | 16701220 | CANCEL | -2420
[NAME] | 2012 A J And Carol Manker Family Trust Dated 06/22/2012,  9-180038527 | 2013-03-09 00:00:00 | 2013-03-09 00:00:00 | 16684645 | CANCEL | -10196
SHARON | Abantao, [NAME] 9-178524376 | 2013-03-30 00:00:00 | 2013-03-30 00:00:00 | 16690348 | CANCEL | 20499
Spreadsheet: 96f4ae33-8360-4c94-8a46-442298180eb1
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42997790 | 2014-09-03 03:17:39 | ALLIES | 0 | 1 | 5 | 798698 | dave65tdh | 12874 | western | 1944-06-06 |  | Battle of the Bridgehead
42997893 | 2014-09-03 03:38:28 | AXIS | 1 | 5 | 3 | 798698 | dave65tdh | 12874 | western | 1944-06-06 |  | Battle of the Bridgehead
Spreadsheet: c411f723-fd1f-4fb3-88a2-f4994609a507
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
TOBR | Test | TOBR | Tobramycin, Random, Serum | Tobramycin, Random, S | Enzyme-Multiplied Immunoassay Technique (EMIT) | Plain, Red-Top Tube: Red OR |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions:  1. Spin down within 2 hours of draw.  2. Serum for a peak level should be drawn 30 to 60 minutes after last dose (order TOBP/84810 [NAME], Peak, Serum). Serum for a trough level should be drawn no more than 30 minutes before next scheduled dose (order TOBT/81594 Tobramycin, Trough, Serum). | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | TOBRAMYCIN, PEAK Therapeutic: 5.0-12.0 mcg/mL  TOBRAMYCIN, TROUGH Therapeutic: <2.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 2 days | 1 | 80200 |  |  |  |  | Rochester
TOBR | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
TOBR | Result | 81751 | Tobramycin, Random, S | Tobramycin, Random, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 35670-9 | Tobramycin^random:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 699691d1602706997-convert-sumif-to-sumproduct-sumproduct-help
Sheet: Sheet1

10110190040110100
10110190040110150
10110190040110300
10110190040110350
10110190040110400
10110190040110450
10110190040110500
10110190040110550
10110190040110600
10110190040110650
10110190040110700
Spreadsheet: 46990d1245912164-excel-2007-formula-for-remainders-aaisha-timesheet
Sheet: Sheet1

 |  |  |  | Week No: 18 |  |  |  |  | Week Ending: 28 June 2009
NO. | SHIFT | NAME | N/T | O/T1 | O/T2 | MON 22/06 | HRS | TUES 23/06 | HRS | WED 24/06 | HRS | THUR 25/06 | HRS | FRI 26/06 | HRS | SAT 27/06 | HRS | SUN 28/06 | HRS
1 |  | L.C.MPANZA |  |  |  | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7.10-12.00 | 4.83 | 7-15.45 | 8.25
 |  | [NAME] |  |  |  | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7.20-16.00 | 7.17 | 7-16.00 | 8.5 | 7-12.00 | 5 | ----- | 0
 |  | [NAME] |  |  |  | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7-16.00 | 8.5 | SICK | 8.5 | 7-12.00 | 5 | ----- | 0
4 |  | M.C. NTULI |  |  |  | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7-12.00 | 5 | 7-16.00 | 8.5
5 |  | S. MSANI |  |  |  | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7-12.00 | 5 | ----- | 0
6 |  | [NAME] |  |  |  | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7-12.00 | 5 | ----- | 0
7 |  | [NAME] |  |  |  | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7-16.00 | 8.5 | 7-12.00 | 5 | 7-15.30 | 8
8 |  | [NAME]
 |  | Dear Daddylonglegs
 |  | Your formula worked like a dream. However…
 |  | While I love that the formula allows no more than 40 in column D,
 |  | I would like column E  to show 0 if the result is 0 or less than 0.
 |  | E.g. in the timesheet above, I'd like E4, E5, E7 and E8 to show 0.
 |  | This is a worker timesheet.
 |  | Thanks
 |  | Aaisha
Spreadsheet: 167180d1341922736-selection-from-dropdown-to-generate-new-table-information-donations
Sheet: General Fund

General Fund
First | Last | Street | City | State | Zip | Amount | Paypal Fee | Total Donation | Date | Type | Check # | Fund | [NAME]
[NAME] | Doe | X | X | X | 31525 | 50 |  | 50 | 2012-01-18 00:00:00 | Check | 9007 | General Fund | [EMAIL]
[NAME] | Joiner | H | H | H | 30306 | 1500 |  | 1500 | Feb. 12, 2012 | Check |  | General Fund
[NAME] | [NAME] | U | U | U | 30022 | 200 |  | 200 | 2012-04-08 00:00:00 | Check |  | General Fund
Isabelle | Bradley | D | D | D | 30306 | 30 | 1.17 | 28.83 | 2012-04-12 00:00:00 | Paypal |  | General Fund
[NAME] | [NAME] | T | T | T | 30189 | 240 | 7.26 | 232.74 | 2012-04-16 00:00:00 | Paypal |  | General Fund
 |  |  |  |  |  | 2020 | 8.43 | 2011.57