tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 755371d1636815529-retrieve-data-from-string-of-text-retrievedata-with-second-date-xl-2016
Sheet: Sheet1

Raw Data | Result (retrieve values with underscore) | Result (retrieve first date in string, if any) | Result (retrieve second date in string, if any) | Result (value that starts with "ABCD")
Raja 20211113_83378 complete his project of 23/10/2021 by 25/10/2021
[NAME] has 81918191 by 21/10/2021 of 26/11/2021
[NAME] has ABCD-1212-14444-4444 of 88110011 by 24/11/2021
[NAME] has 2029221_2291 by 28/10/2021
[NAME] wants ABCD-111-222-991 of 25/10/2021
 |  |  | =IFERROR(INDEX(FILTERXML("<F><d>"&SUBSTITUTE($A2," ","</d><d>")&"</d></F>","//d"),AGGREGATE(15,6,(1/(--ISNUMBER(SEARCH("/",TEXT(FILTERXML("<F><d>"&SUBSTITUTE($A2," ","</d><d>")&"</d></F>","//d"),"dd/mm/e")))))*ROW(OFFSET($A$1,,,ROWS(FILTERXML("<F><d>"&SUBSTITUTE($A2," ","</d><d>")&"</d></F>","//d")))),2)),"NA")
 | =IFERROR(INDEX(FILTERXML("<F><d>"&SUBSTITUTE($A2," ","</d><d>")&"</d></F>","//d"),MATCH(1,--ISNUMBER(SEARCH("_",FILTERXML("<F><d>"&SUBSTITUTE($A2," ","</d><d>")&"</d></F>","//d"))),0)),"NA")
 | 20211113_83378 | 2021-10-23 00:00:00 | 2021-10-25 00:00:00 | NA
 | NA | 2021-10-21 00:00:00 | 2021-11-26 00:00:00 | NA
 | NA | 2021-11-24 00:00:00 | NA | ABCD-1212-14444-4444
 | 2029221_2291 | 2021-10-28 00:00:00 | NA | NA
 | NA | 2021-10-25 00:00:00 | NA | ABCD-111-222-991
 |  |  | 2021-10-25 00:00:00
 |  |  | 2021-11-26 00:00:00
 |  |  |  |  | <-- | Excel 365 (FILTER)
Spreadsheet: 735406d1622962491-overtime-calculation-if-function-or-sumif-excel-forum
Sheet: Sheet2

Name | Total hours per day
 | 2021-05-01 00:00:00 | 2021-05-02 00:00:00 | 2021-05-03 00:00:00 | 2021-05-04 00:00:00 | 2021-05-05 00:00:00 | 2021-05-06 00:00:00 | 2021-05-07 00:00:00 | 2021-05-08 00:00:00 | 2021-05-09 00:00:00 | 2021-05-10 00:00:00 |  |  | Normal OT | Holiday Overtime
Jone | 8 | 9 | 10 | 11 | 12 | 8 | 8 | 11 | 12 | 13
[NAME] | 9 | 10 | 12 | 8 | 9 | 13 | 14 | 8 | 9 | 12
Jimy | 10 | 11 | 8 | 9 | 10 | 12 | 13 | 8 | 8 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | After 8 hours calcuation OT(Without Holiday Hours) | Yellow coloured Cells total  ( full working hours as overtime)
 |  |  |  | Note  : Yellow coloured working hours will consider as holiday working hours hence company bond to pay for employ for whole day as overtime working hours
Spreadsheet: 199a7f20-ec5f-4f0a-afae-2f2567125bf4
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
MNRU | Test | MNRU | Manganese, Random, [NAME] | Manganese, Random, U | Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS) | Plastic urine container with no metal cap or glued insert |  |  | 2 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 6-mL tube (Supply T465) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 2 mL Collection Instructions:  1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.4 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-15 years: not established > or =16 years: 0.1-0.9 mcg/L | Tuesday, Thursday; 3 p.m. | 1 day | 5 days | 1 | 83785 |  |  |  |  | Rochester
MNRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
MNRU | Result | 86154 | Manganese, Random, U | Manganese, Random, U | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 5684-6 | Manganese:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 759312d1639490813-unique-deduplication-testworksheet
Sheet: Sheet1

Multiple * | FIRST | LAST | Concatenated
 | [NAME] | Doe | [NAME]
 | [NAME] | [NAME]
 | [NAME] | Smith
 | [NAME] | Doe
 | Willy | Wonka
 | George | Smith
 | Alfred | Neuman
 | [NAME] | [NAME]
 | [NAME] | Adams
 | George | Washington
 | [NAME] | Willis
 | [NAME] | Smith
 | [NAME] | Smith
 | Alfred | Neuman
 | MJ | Jones
 | [NAME] | Adams
 | [NAME] | Adams
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | Clint | Eastwood
 | J | Doe
 | MJ | Jones
Spreadsheet: 647939d1572781768-column-search-with-various-formats-of-names-office-problem
Sheet: Example Sheet

Target to search ( each of the cell below) - Date format DD/MM/YY | Search against this Coloumn | Record 1D | Date
Tanya, Surname_25/12/18 | Names 1
[NAME] | Names 2 Surname
Surname kenny_10/08/12 | Surname Name 3
Surname, Thomas_12/06/19 | Name_Surname4
[NAME] ven desol_12/04/18 | Tanya, Surname_25/12/18
[NAME] | [NAME] Jones|_10/11/13 | Surname Name 4
Vince_Surname_15/06/16 | Surname Name 5
[NAME] | Surname Name 6
 | Surname Name 6
 | [NAME]
 | [NAME] ven desol_12/04/18
 | Surname kenny_10/08/12
 | [NAME]
 | [NAME] ven desol_12/04/18
 | [NAME] | [NAME] Jones|_10/11/13
 | Vince_Surname
Spreadsheet: 874826d1721333075-counting-the-days-test-etaf
Sheet: TEST

Item | Buy date
Chocolate | 2020-01-02 17:43:00
Sweets | 2020-01-03 04:45:00
Potato | 2020-01-03 04:47:00
Drinks | 2020-01-03 12:32:00
Potato | 2020-01-03 14:04:00
Drinks | 2020-01-05 03:12:00
Potato | 2020-01-05 09:03:00
Drinks | 2020-01-06 04:12:00
Drinks | 2020-01-06 23:21:00
Sweets | 2020-01-10 18:10:00
Drinks | 2020-01-14 04:27:00
Drinks | 2020-01-17 09:01:00
Chocolate | 2020-01-19 12:42:00
Drinks | 2020-01-27 13:51:00
Drinks | 2020-01-30 17:50:00
Ice Cream | 2020-02-03 17:01:00
Drinks | 2020-02-05 12:32:00
Ice Cream | 2020-02-10 07:28:00
Drinks | 2020-02-11 16:30:00
Chocolate | 2020-02-16 20:13:00
Chocolate | 2020-02-17 14:37:00
Ice Cream | 2020-02-19 22:49:00
Chocolate | 2020-02-24 18:27:00
Chocolate | 2020-02-26 02:58:00
Ice Cream | 2020-03-01 17:34:00
Drinks | 2020-03-05 12:47:00
Chocolate | 2020-03-07 17:41:00
Chocolate | 2020-03-11 18:28:00
Chocolate | 2020-03-12 04:37:00
Out | 2020-03-13 02:02:00
Spreadsheet: 140343d1328712720-pivot-table-calculation-test
Sheet: Foglio1

WEEKDAY | (Tutto)
Conteggio di Customer
Mesi | Date | Totale
gen | 02-gen | 12
 | 03-gen | 10
 | 04-gen | 10
 | 05-gen | 16
 | 06-gen | 12
 | 09-gen | 8
 | 11-gen | 10
 | 12-gen | 3
 | 13-gen | 2
 | 16-gen | 2
 | 17-gen | 2
 | 18-gen | 2
 | 19-gen | 2
 | 23-gen | 8
 | 24-gen | 2
 | 25-gen | 16
 | 27-gen | 2
gen Totale |  | 119
feb | 06-feb | 3
 | 07-feb | 6
 | 08-feb | 2
 | 09-feb | 5
 | 10-feb | 4
 | 13-feb | 6
 | 14-feb | 3
 | 15-feb | 4
 | 16-feb | 4
 | 17-feb | 2
 | 22-feb | 6
 | 23-feb | 9
 | 24-feb | 8
 | 29-feb | 8
feb Totale |  | 70
Totale complessivo |  | 189
Spreadsheet: kam_keiser__17861__NEW BOOK REQUEST TAGG-West011002
Sheet: Sheet1

 | From: | Risk Management -Controls |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
 | Subject: | New Book Request |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 | Requestor: | [NAME]
 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  |  | Type Of Transactions |  |  | Book Mapping
CP ID | Short Name | Long Name | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed |  | MTM | Prud | Realized
166966 | PWR-GAS-WMGMT | POWERGASWESTMANAGEMENT | x |  |  | MJ | NYMEX | x |  |  |  |  |  |  | [NAME] | MTM | Netco | ASAP
166967 | PWR-GAS-NW | POWERGASNORTHWEST | x |  |  | MJ | NYMEX | x |  |  |  |  |  |  | [NAME] | MTM | Netco | ASAP
166968 | PWR-GAS-SW | POWERGASSOUTHWEST | x |  |  | MJ | NYMEX | x |  |  |  |  |  |  | [NAME] | MTM | Netco | ASAP
166969 | PWR-GAS-CALI | POWERGASCALIFORNIA | x |  |  | MJ | NYMEX | x |  |  |  |  |  |  | [NAME] | MTM | Netco | ASAP
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag.
 | *A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
 | BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
 | ***Please provide login names for book administrators.***
 |  |  |  |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
 | Book | Login |  |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC
 | Administrator* | Names |  |  |  |  |  |  |  |  |  |  |  | Hierarchy
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Created in TAGG/ERMS
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Cross-Commodity DBA
 | Heather Dunton
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | PORTFOLIO NAME |  | Added (Y/N) | Processors ID
 | Casey Evans |  |  |  |  |  |  |  |  |  |  |  | ALL: | AGG-CREDIT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-BU
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-CM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DISCOUNTING USD
 |  |  |  |  |  |  |  |  |  |  |  |  | IF: | GDI
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GD-INDEX
 |  |  |  |  |  |  |  |  |  |  |  |  | IF: | Index
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-INDEX
 |  |  |  |  |  |  |  |  |  |  |  |  | IF: | Gas
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GAS III & IV
Spreadsheet: 584331d1533124725-sum-of-special-characters-within-a-list-excel-upload
Sheet: Template 

Document Header Data |  | Field Definition | Please ensure there are no RED highlighted cells before submitting this form |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 2
Document date: |  | [NAME]
Reference: |  | 16 Characters
Requestor: |  | 25 Characters |  | Balance Control |  |  | Balance Control
Posting Date: |  | [NAME] |  | Debits |  |  | Profit and Loss
Posting Period: |  |  |  | Credits |  |  | Balance sheet
Lead Company Code: |  | 4 Characters |  | Control Total |  |  | Control Total
Currency: |  | 3 Characters
Document Type: |  | 2 Characters |  | Special Charaters |  |  | Error Message
[NAME]: |  | [NAME] |  | Special Charaters
Originating PC
IAP RITM
Line Item Data
Company Code | G/L Account | Cost Centre | Profit Centre | WBS Element | Order No | Assignment | Line Item Text | Debit Amount | Credit Amount | FOM Compliance Code | Reason code | Partner Profit Centre | Transaction Type | Employee ID
 | 600000 |  |  |  |  |  | Test1! | 100
 | 600001 |  |  |  |  |  | Test2@ |  | 100
 | 100001 |  |  |  |  |  | Test3" | 200
 | 100002 |  |  |  |  |  | Test4/ |  | 200
Spreadsheet: 72315d1273004571-converting-and-calculating-average-elapsed-time-elapsed_time
Sheet: Sheet1

 | Q1 | Q2 | Q3 | Q4 | Q5
Student1 | 55 secs | 1 min 26 secs | 38 secs | 30 secs | 1 min 9 secs
Student2 | 1 min 36 secs | 34 secs | 1 min 1 sec | 2 mins 27 secs | 2 mins 17 secs
Student3 | 1 min 56 secs | . | 1 min 44 secs | 12 secs | 1 min 35 secs
Student4 | 1 min 27 secs | . | 38 secs | 1 min 28 secs | 1 min 31 secs
Student5 | 1 min 24 secs | 36 secs | 33 secs | 27 secs | 1 min 35 secs
Student6 | . | 26 secs | . | 32 secs | .
Student7 | 31 secs | 23 secs | 42 secs | 57 secs | 1 min 26 secs
Student8 | 33 secs | . | 49 secs | 55 secs | 1 min 14 secs
Student9 | 57 secs | 56 secs | 25 secs | 44 secs | 40 secs
Student10 | 1 min 12 secs | 1 min 4 secs | 1 min 4 secs | . | 2 mins 12 secs
Student11 | . | 46 secs | . | 55 secs | .
Student12 | . | 27 secs | . | 1 min 19 secs | .
Student13 | 59 secs | 36 secs | 1 min 32 secs | 56 secs | 1 min 47 secs
Student14 | 1 min 20 secs | 19 secs | 1 min 2 secs | 57 secs | 1 min 27 secs
Student15 | . | . | . | 27 secs | .
Student16 | 1 min 6 secs | . | 1 min 24 secs | 2 mins 56 secs | 2 mins 10 secs
Student17 | 23 secs | . | 22 secs | . | 2 mins 1 sec
Student18 | 52 secs | 1 min 19 secs | 1 min 15 secs | 2 mins 38 secs | 1 min 34 secs
Student19 | 24 secs | . | 1 min 25 secs | 25 secs | 39 secs
Student20 | 46 secs | 20 secs | 1 min 36 secs | 23 secs | 2 mins 30 secs
Spreadsheet: 877121d1723798189-sumproduct-with-multiple-criteria-including-date-sample-file
Sheet: Raw data

Roll | Date | Currency | Quantity
2024-08-08 00:00:00 | 2024-08-12 00:00:00 | Paris | 1
2024-08-08 00:00:00 | 2024-08-12 00:00:00 | Paris | 2
2024-08-08 00:00:00 | 2024-08-13 00:00:00 | Tokyo | 1
2024-08-08 00:00:00 | 2024-08-13 00:00:00 | Tokyo | 2
2024-08-08 00:00:00 | 2024-08-13 00:00:00 | Tokyo | -1
2024-08-08 00:00:00 | 2024-08-13 00:00:00 | Tokyo | 2
2024-08-08 00:00:00 | 2024-08-14 00:00:00 | Tokyo | 1
Spreadsheet: 838097d1690711714-user-choice-consolidation-with-hierarchy-applied-result-and-then-given-a-number-dif
Sheet: DATA

Difficult | Important | Frequency | Category |  | Diff | Imp | [NAME]
Very | Very | Very | 2 |  | Very | Very | Very
Very | Very | Mod | 2 |  | Mod | Mod | Mod
Very | Very | Inf | 1 |  | Not | Not | Inf
Very | Mod | Very | 2
Very | Mod | Mod | 2
Very | Mod | Inf | 1
Very | Not | Very | 3
Very | Not | Mod | 3
Very | Not | Inf | 2
Mod | Very | Very | 2
Mod | Very | Mod | 4
Mod | Very | Inf | 3
Mod | Mod | Very | 2
Mod | Mod | Mod | 4
Mod | Mod | Inf | 3
Mod | Not | Very | 3
Mod | Not | Mod | 2
Mod | Not | Inf | 2
Not | Very | Very | 5
Not | Very | Mod | 3
Not | Very | Inf | 2
Not | Mod | Very | 3
Not | Mod | Mod | 3
Not | Mod | Inf | 3
Not | Not | Very | 2
Not | Not | Mod | 3
Not | Not | Inf | 5
Spreadsheet: 140084d1328620603-removing-a-linked-cell-tlc-client-progress
Sheet: THC

COURSE NAME
Clients | Client's Name | Client's Name | Client's Name | Client's Name
Students | Student's Name | Student's Name | Student's Name | Student's Name
Course Set Up | Date Completed | Comments
Initial contact |  | Who?
Details added to database |  | Anything missing?
Evaluation coordinated
Date
Location
Teacher
Evaluation report sent to teacher
Evaluation report received from teacher
Needs analysis conducted
Follow up contact
[NAME]
Feedback requirements
Billing option
Course plan created
Course plan translated
Client sent evaluation report, course plan & T's & C's
Client accepts T's & C's
Teacher allocated to course
Teacher availability updated
Start of course confirmed
Course and lessons added to database
Course details sent to Financial Director
Course added to end of month lessons report
Client sent teacher profile and login details
Client contacted after 1st class
Client Follow Up & Feedback | Date Completed | Comments
Follow up call 1
Follow up call 2
Follow up call 3
Follow up call 4
Client feedback 1
Client feedback 2
Client feedback 3
Course Notes | Date Completed | Comments
Note 1
Note 2
Note 3
Note 4
Note 5
Evaluations
Student | Date | Fluency | Vocab | [NAME] | Pronunciation | Level
Student 1
Student 2
Student 3
End of Course | Date Completed | Comments
Client contacted to confirm end of course |  | When will course end?
Teacher informed of end of course
End of course report sent to teacher
End of course report received from teacher
End of course report translated
End of course report sent to client
Spreadsheet: john_zufferli__16706__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Hedgeable Volume | Current Gas Hedges |  | AECO Basis Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (contracts/day) | (contracts/day) | % Hedged | (contracts/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 390354d1429610856-conditional-formatting-based-on-difference-example-etaf-
Sheet: Sheet1

VENUE | APRIL - INVITES | APRIL ATTENDANCE | MAY - INVITES | MAY [NAME] | April | May
Amherst | 100 | 6 | 50 | 35
Ash | 0 | 15 | 30 | 56
Aylesford | 450 | 480 | 500 | 508
Aylesham | 700 | 789 | 650 | 650
Balmoral | 60 | 55 | 80 | 95
Bearsted | 210 | 0 | 160 | 165
Darenth | 95 | 96 | 0 | 0
Birchington | 0 | 0 | 70 | 73
Blackthorn | 535 | 538 | 480 | 475
Borough Green | 300 |  | 225 | 219
[NAME] | 10 | 5 | 0 | 10
Bower | 560 | 582 | 475 | 489
 |  |  |  |  |  |  |  |  |  |  |  | Rules | Applies to
 |  | I want to highlight any figures in column C that have a 10% difference from those figures in column B |  |  |  |  |  |  |  |  |  |  | $C$3:$C$14,$E$3:$E$14
 | 1 | If the amount <= 10% lower than column B - green |  |  |  |  |  |  |  |  |  | OR( C3="",C3/B3<=0.1)
 | 2 | If the amount is >= 10% higher than column B - red |  |  |  |  |  |  |  |  |  | [NAME]/B3>=1.1
 | 3 | If no difference black font on white |  |  |  |  |  |  |  |  |  | c3=b3
 | 4 | If blank, count as lower (rule 1)
Spreadsheet: 43483d1242137908-excel-2007-problems-calculating-innings-pitched-from-other-worksheets-test
Sheet: Sheet1

pitcher's name | innings pitched num after decimal pt <10 | innings pitched # after decimal pt. =10
w | 12.2 | 12.2
x | 1.1 | 1.2
y | 30 | 33.2
z | 12.1 | 11.2
e | 25 | 26.2
totals
what totals should look like | 81.1 | 87
Spreadsheet: 78082d1278518217-identify-top-10-sample-top-10_2
Sheet: Sheet4

Campaign | Aquamarine
Sum of Impressions | Column Labels
Row Labels | Aquamarine Bracelets | Grand Total
aqua marine bracelet | 6899064.28571428 | 6899064.28571428
aqua marine bracelets | 7051493.10714285 | 7051493.10714285
aquamarine bracelet | 7203921.92857143 | 7203921.92857143
aquamarine bracelets | 7356350.75 | 7356350.75
Grand Total | 28510830.07142856 | 28510830.07142856
Spreadsheet: 63918d1264776154-excel-2007-automatically-sum-for-specific-lines-in-a-pivot-table-test_file_forum_29-01
Sheet: Country

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average | % diff vs
Sum of EUR |  | Week
Location | Year | 3 | 2 | 1 | Grand Total
Amsterdam | 2010 | 78714.37999999999 | 145520.4299999999 | 117697.03 | 341931.8399999999
 | 2009 | 167127.0900000001 | 318620.3200000002 | 156896.76 | 642644.1700000004
Amsterdamx | 2010 | 2823.16 | 2034.72 | 1245.85 | 6103.73
 | 2009 | 278.9 | 76.17 | 305.39 | 660.46
Brussels | 2010 | 71144.87999999999 | 59139.63 | 95932.95000000006 | 226217.46
 | 2009 | 185383.29 | 116237.92 | 242885.77 | 544506.9800000001
Brusselsx | 2010 | 1500.04 | 2001.48 | 2125.72 | 5627.240000000001
 | 2009 | 3734.699999999999 | 2007.34 | 1058.77 | 6800.809999999999
London | 2010 | 267290.7700000001 | 177827.35 | 11539.3800000001 | 456657.5000000002
 | 2009 | 238092.64 | 257353.3999999999 | 250982.3799999998 | 746428.4199999997
London y | 2009 | 32338.44 | 13757.04 | 54625.20000000002 | 100720.68
Londonx | 2010 | 15980.53999999998 | 19115.11999999996 | 16440.56999999997 | 51536.22999999991
 | 2009 | 18605.7 | 18892.52 | 27112.05999999998 | 64610.27999999998
New York | 2010 | 48051.31999999999 | 87519.90999999992 | 98850.07000000002 | 234421.2999999999
 | 2009 | 121429.65 | 84453.14000000001 | 117720.29 | 323603.08
Grand Total |  | 1252495.5 | 1304556.49 | 1195418.19 | 3752470.18
Spreadsheet: 714573d1611296763-custom-time-formatting-paybonusforefproperresults
Sheet: Sheet1

Working time | Needed Result | [NAME]
7:00:00 | 8:00:00
7:15:00 | 8:00:00
7:30:00 | 8:00:00
7:45:00 | 8:00:00
8:00:00 | 8:00:00
8:15:00 | 8:23:00
8:30:00 | 8:45:00
8:45:00 | 9:08:00
9:00:00 | 9:30:00
9:15:00 | 9:53:00
9:30:00 | 10:15:00
9:45:00 | 10:38:00
10:00:00 | 11:00:00
10:15:00 | 11:23:00
10:30:00 | 11:45:00
10:45:00 | 12:08:00
11:00:00 | 12:30:00
11:15:00 | 12:53:00
11:30:00 | 13:15:00
11:45:00 | 13:38:00
12:00:00 | 14:00:00
12:15:00 | 14:23:00
12:30:00 | 14:45:00
Spreadsheet: 147730d1332949576-drop-down-list-reference-formula-machine-schedule-2
Sheet: Lathe

Due Date | Part Number | Rev Level | Qty Due | Job Number | Release | Quoted time Min/pc |  | Machine Number | Total Hours | Running Total Hours | Total Qty completed | Remaining Hours
2012-01-10 00:00:00 | #N/A | 0 | 100 | 0 | -1 | 3.55 |  |  | 5 | 5 | 100 | 0
2012-02-10 00:00:00 |  | 0 | 90 | 0 | -2 | 3.55 |  |  | 5 | 5 | 75 | 0.8875
2012-03-10 00:00:00 |  | 0 | 80 | 0 | -3 | 3.55 |  |  | 4.73 | 4.73 |  | 4.733333333333333
2012-04-10 00:00:00 |  | 0 | 70 | 0 | -4 | 3.55 |  | L1 | 4.14 | 4.14 |  | 4.141666666666667
2012-05-10 00:00:00 |  | 0 | 60 | 0 | -5 | 3.55 |  |  | 3.55 | 3.55 |  | 3.55
2012-06-12 00:00:00 |  | 0 | 50 | 0 | -6 | 3.55 |  |  | 2.96 | 2.96 |  | 2.958333333333333
2012-07-15 00:00:00 |  | 0 | 50 | 0 | -7 | 3.55 |  | L1 | 2.96 | 2.96 |  | 2.958333333333333
2012-08-15 00:00:00 |  | 0 | 50 | 0 | -8 | 3.55 |  | l2 | 2.96 | 2.96 |  | 2.958333333333333
2012-09-12 00:00:00 |  | 0 | 50 | 0 | -9 | 3.55 |  |  | 2.96 | 2.96 |  | 2.958333333333333
2012-10-12 00:00:00 |  | 0 | 100 | 0 | -10 | 3.55 |  | L1 | 5.92 | 5.92 |  | 5.916666666666667
2012-11-15 00:00:00 |  | 0 | 100 | 0 | -11 | 3.55 |  |  | 5.92 | 5.92 |  | 5.916666666666667
2012-12-12 00:00:00 |  | 0 | 150 | 0 | -12 | 3.55 |  |  | 8.88 | 8.88 |  | 8.875
Machine Name | Total Machine Hours
L1 | 13.02
L2 | 2.96
L3 | 0
[NAME] | 0
L5 | 0
L6 | 0
L8 | 0
L10 | 0
L11 | 0
L12 | 0
[NAME] | 0
[NAME] | 0
L15 | 0
L16 | 0
L17 | 0
L18 | 0
L19 | 0
L20 | 0
[NAME] | 0
L22 | 0
[NAME] | 0
L24 | 0
[NAME] | 0
L26 | 0
Spreadsheet: 797925d1664215028-delete-rows-without-affecting-formulas-sample
Sheet: MAIN

no. | name | date | notes |  |  | This is main data sheet
1 | Mr.[NAME] | 2022-01-01 00:00:00 | [NAME]
2 | Mr.[NAME] | 2022-02-02 00:00:00 | note2
4 | Mr.[NAME] | 2022-04-04 00:00:00 | note4
5 | Mr.[NAME] | 2022-05-05 00:00:00 | note5
6 | Mr.[NAME] | 2022-06-06 00:00:00 | note6
Spreadsheet: michelle_lokay__26740__imball0203
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 | -34078 | -40000
2 | -35189 | -33000
3 | -29296 | -34000
4 | -36478 | -35000
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
2002-02-28 00:00:00 |  |  | 61952
2002-03-04 00:00:00
CBS Volume
 |  |  | 33105
Spreadsheet: 462434d1464040465-need-auto-filter-to-return-only-characters-searched-want-to-pull-5ml-and-not-get-25ml-book1
Sheet: Sheet1

 |  |  |  |  | 2
 |  |  |  |  | 3 | 6 | hghgh5ml | 15 | 15
 |  |  |  |  | 4 | 8 | 5ml | 20 | 20
 |  |  |  |  | 5 | 10 | 5ml6 | 25 | 25
 |  |  |  |  | 6 | 12 | 65ml | 30 | 30
 |  |  |  |  | 7 | 14 | 5ml | 35 | 35
Spreadsheet: 731284d1620277210-calculate-quantity-based-on-multiple-conditions-sample-workbook
Sheet: Purchased

Date Purchased | Set Number | Set Name | Quantity | Retail Cost | Purchase Price | Total Cost | Received
2021-03-30 00:00:00 | 12345 | ABCDE | 8
2021-04-27 00:00:00 | 98765 | FGHIJ | 4
2021-04-27 00:00:00 | 45678 | KLMNO | 9
2021-04-30 00:00:00 | 65432 | PQRST | 5
Spreadsheet: 53580d1253542417-exclusive-selection-testspqr-1-
Sheet: Sheet2

Unit | 1 | 2 | 3 | 4 | 5 | 6
Time | Up to 30 minutes | to 60 minutes | to 90 minutes | to 120 minutes | to 240 minutes | to 360 minutes
Increment | 2.5 | 0.5 | 0.75 | 1 | 1.25 | 2.5
Fee | 2.5 | 3 | 3.75 | 4.75 | 6 | 8.5
Laptop Connectivity
 | 1.5