tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 62658d1263565326-is-this-type-of-copy-even-possible-test
Sheet: DATA1

Document Name | Sub-Division | Due Date | Responsible | Identifier | Authored | Approved | Submit
Test Name 1 | TRN | 2010-01-01 00:00:00 | [NAME] | CCPR-TRN-001.1.00 | ü | ü | ü
Test Name 2 | TRN | 2010-01-20 00:00:00 | [NAME] | CCPR-TRN-002.1.00 | ü
Test Name 3 | TRN | 2010-01-21 00:00:00 | [NAME] | CCPR-TRN-002.1.01 | ü
Test Name 4 | TRN | 2010-01-22 00:00:00 | [NAME] | CCPR-TRN-002.1.02 | ü
Test Name 5 | TRN | 2010-01-23 00:00:00 | [NAME] | CCPR-TRN-002.1.03 | ü
Test Name 6 | TRN | 2010-01-24 00:00:00 | [NAME] | CCPR-TRN-002.1.04 | ü
Test Name 7 | TRN | 2010-01-25 00:00:00 | [NAME] | CCPR-TRN-002.1.05 | ü
Test Name 8 | TRN | 2010-01-26 00:00:00 | [NAME] | CCPR-TRN-002.1.06 | ü
Test Name 9 | TRN | 2010-01-27 00:00:00 | [NAME] | CCPR-TRN-002.1.07 | ü
Test Name 10 | TRN | 2010-01-28 00:00:00 | [NAME] | CCPR-TRN-002.1.08 | ü
Test Name 11 | TRN | 2010-01-29 00:00:00 | [NAME] | CCPR-TRN-002.1.09 | ü
Test Name 12 | TRN | 2010-01-30 00:00:00 | [NAME] | CCPR-TRN-002.1.10 | ü
Test Name 13 | TRN | 2010-01-31 00:00:00 | [NAME] | CCPR-TRN-002.1.11 | ü
Test Name 14 | TRN | 2010-02-01 00:00:00 | [NAME] | CCPR-TRN-002.1.12 | ü
Test Name 15 | TRN | 2010-02-02 00:00:00 | [NAME] | CCPR-TRN-002.1.13 | ü
Test Name 16 | TRN | 2010-02-03 00:00:00 | [NAME] | CCPR-TRN-002.1.14 | ü
Test Name 17 | TRN | 2010-02-04 00:00:00 | [NAME] | CCPR-TRN-002.1.15 | ü
Test Name 18 | TRN | 2010-02-05 00:00:00 | [NAME] | CCPR-TRN-002.1.16 | ü
Test Name 19 | TRN | 2010-02-06 00:00:00 | [NAME] | CCPR-TRN-002.1.17 | ü
Test Name 20 | TRN | 2010-02-07 00:00:00 | [NAME] | CCPR-TRN-002.1.18 | ü
Test Name 21 | TRN | 2010-02-08 00:00:00 | [NAME] | CCPR-TRN-002.1.19 | ü
Test Name 22 | TRN | 2010-02-09 00:00:00 | [NAME] | CCPR-TRN-002.1.20 | ü
Test Name 23 | TRN | 2010-02-10 00:00:00 | [NAME] | CCPR-TRN-002.1.21 | ü
Test Name 24 | TRN | 2010-02-11 00:00:00 | [NAME] | CCPR-TRN-002.1.22 | ü
Test Name 25 | TRN | 2010-02-12 00:00:00 | [NAME] | CCPR-TRN-002.1.23 | ü
Spreadsheet: 689109d1596127148-rank-duplicate-values-with-countifs-rank_countifs
Sheet: Order Data

Date
Rank |  | Fruit | Order Date | Order Cost
 |  | Apples | 2015-03-01 00:00:00 | 40.3
 |  | Apples | 2015-07-01 00:00:00 | 43.6
 |  | Apples | 2015-04-01 00:00:00 | 66.1
 |  | Apples | 2017-01-01 00:00:00 | 41
 |  | Apples | 2017-01-01 00:00:00 | 103.4
 |  | Apples | 2017-02-01 00:00:00 | 36.3
 |  | Apples | 2017-04-01 00:00:00 | 35.2
 |  | Apples | 2017-05-01 00:00:00 | 30
 |  | Apples | 2018-01-01 00:00:00 | 50
 |  | Apples | 2018-01-01 00:00:00 | 110.1
 |  | Apples | 2018-09-01 00:00:00 | 53
 |  | Apples | 2018-11-01 00:00:00 | 75.5
 |  | Apples | 2019-01-01 00:00:00 | 50
 |  | Oranges | 2013-08-01 00:00:00 | 135.7
 |  | Oranges | 2015-06-01 00:00:00 | 169.5
 |  | Oranges | 2016-04-01 00:00:00 | 120
 |  | Oranges | 2016-11-01 00:00:00 | 96
 |  | Oranges | 2017-03-01 00:00:00 | 17.8
 |  | Oranges | 2012-06-01 00:00:00 | 70
 |  | Oranges | 2013-06-01 00:00:00 | 70
 |  | Oranges | 2014-06-01 00:00:00 | 92.5
 |  | Oranges | 2014-11-01 00:00:00 | 136.6
 |  | Oranges | 2015-08-01 00:00:00 | 150
 |  | Oranges | 2012-08-01 00:00:00 | 116.1
 |  | Oranges | 2016-07-01 00:00:00 | 37.5
 |  | Oranges | 2015-03-01 00:00:00 | 168.4
 |  | Oranges | 2016-05-01 00:00:00 | 181.3
 |  | Bananas | 2017-09-22 00:00:00 | 68.9
 |  | Bananas | 2015-11-03 00:00:00 | 176.3
 |  | Bananas | 2017-03-22 00:00:00 | 37.8
 |  | Bananas | 2014-12-11 00:00:00 | 180.1
 |  | Bananas | 2015-07-31 00:00:00 | 84.4
 |  | Bananas | 2018-01-31 00:00:00 | 97.3
 |  | Bananas | 2018-05-23 00:00:00 | 83.1
 |  | Bananas | 2019-08-27 00:00:00 | 60
 |  | Bananas | 2019-09-12 00:00:00 | 125
 |  | Bananas | 2016-08-16 00:00:00 | 180
 |  | Bananas | 2016-12-29 00:00:00 | 96.3
 |  | Bananas | 2015-06-08 00:00:00 | 74.3
 |  | Bananas | 2015-07-07 00:00:00 | 200
 |  | Bananas | 2017-05-01 00:00:00 | 133.7
 |  | Bananas | 2016-12-19 00:00:00 | 180
Spreadsheet: 59624d1260217146-excel-2007-checking-a-range-of-dates-with-if-or-select-case-example1
Sheet: Instructions

NOTE: FOR TELEWORK DAYS YOU ENTER YOUR TIME IN BOTH THE "Time in Duty" AND "Telework
Hours" "Worked" COLUMNS.  THE FORMULAS WILL COUNT ONLY THE HOURS RECORDED IN
"Time in Duty Status" COLUMNS AND WON'T DOUBLE COUNT THE TELEWORK HOURS.
YOU CAN TELEWORK ONLY PART OF A DAY.  FOR EXAMPLE, IF YOU WORK 8 HOURS IN A
DAY AND ONLY 3 HOURS WERE TELEWORK YOU WOULD RECORD 8 HOURS UNDER "Regular"
AND 3 HOURS UNDER "Telework Hours" "Worked".  IF YOU TELEWORKED "Overtime" AND/OR
"Comp" AND/OR "Earned" "Credit Hours" (MORE THAN 8 HOURS OR YOUR REGULAR AWS HOURS)
YOU WOULD RECORD THOSE IN THE APPROPRIATE COLUMNS UNDER "Time in Duty Status" and
RECORD THE TOTAL OF "Regular" + "Overtime" + "Comp" + "Credit Hours" (AS APPROPRIATE) IN
THE "Telework Hours" "Worked" COLUMN.
ALSO NOTE: PAY PERIOD 08-24 IS NOT A DATE, BUT THE 24th PAY PERIOD, ENDING 11/22/08.
ALL INSTRUCTIONS BELOW, EXCEPT NUMBER 8, APPLY TO THE TAB TA2008-24
1.  ENTER YOUR NAME ON TA2008-24 IN CELL 4C. THIS WILL POPULATE ALL LATER PAY PERIODS.
2.  ENTER YOUR ESTABLISHED HOURS IN THE UPPER RIGHT-HAND BOX. THIS WILL
POPULATE THE ESTABLISHED HOURS AND WORKING HOURS FOR ALL LATER PAY PERIODS.
DO NOT ERASE THE NUMBERS IN THE CELL.  TYPE OVER THE NUMBERS IN THE CELL.
NOTE THAT HOLIDAYS ARE IDENTIFIED IN RED IN THE HOURS WORKED COLUMN AS A
REMINDER TO YOU.  YOU MUST POPULATE THE HOLIDAY COLUMN, H, WITH THE NUMBER
OF HOURS APPROPRIATE TO YOUR WORK SCHEDULE, WHETHER REGULAR OR AWS.
NOTE: IF YOU DO NOT WANT THE SPREADSHEET TO AUTOMATICALLY TRACK YOUR ANNUAL,
SICK, AND COMP BALANCES DO NOT COMPLETE STEPS 3 THROUGH 8 BELOW.
3.  ENTER YOUR CREDIT HOUR BALANCE AT THE END OF PAY PERIOD 08-23 IN CELL M13.
THE BALANCE WILL BE CALCULATED AUTOMATICALLY FOR ALL LATER PAY PERIODS.
4.  ENTER YOUR ANNUAL LEAVE BALANCE AT THE END OF PAY PERIOD 08-23 IN CELL N13.
THE BALANCE WILL BE CALCULATED AUTOMATICALLY FOR ALL LATER PAY PERIODS.
5.  ENTER YOUR SICK LEAVE BALANCE AT THE END OF PAY PERIOD 08-23 IN CELL O13.
THE BALANCE WILL BE CALCULATED AUTOMATICALLY FOR ALL LATER PAY PERIODS.
6.  ENTER YOUR COMP TIME BALANCE AT THE END OF PAY PERIOD 08-23 IN CELL P13.
THE BALANCE WILL BE CALCULATED AUTOMATICALLY FOR ALL LATER PAY PERIODS.
7.  ENTER YOUR LWOP BALANCE AT THE END OF PAY PERIOD 08-23 IN CELL Q13.
THE BALANCE WILL BE CALCULATED AUTOMATICALLY FOR ALL LATER PAY PERIODS.
MOST EMPLOYEES SHOULD HAVE NO BALANCE IN LWOP.
8.  ENTER THE HOURS OF ANNUAL LEAVE YOU EARN PER PAY PERIOD
IN THIS BOX - |  | 4 | THIS WILL BE USED TO CALCULATE YOUR BALANCE IN
SUBSEQUENT PAY PERIODS.
Spreadsheet: 297459d1392395457-time-calculation-between-two-cells-time-formula
Sheet: Sheet1

[NAME] | Document | Time Stamp | Total Time Taken (Output)
LAN 1 | A | 2014-05-01 19:12:00 | 11 hrs 55 Mins | first document was tagged at 8 AM and last document was tagged at 7.55 PM
LAN 1 | B | 2014-05-01 19:13:00 | 11 hrs 55 Mins
LAN 1 | C | 2014-05-01 08:00:00 | 11 hrs 55 Mins
LAN 1 | D | 2014-05-01 19:45:00 | 11 hrs 55 Mins
LAN 1 | E | 2014-05-01 19:46:00 | 11 hrs 55 Mins
LAN 1 | F | 2014-05-01 19:55:00 | 11 hrs 55 Mins
LAN 1 | G | 2014-05-01 19:50:00 | 11 hrs 55 Mins
LAN 1 | H | 2014-05-01 19:49:00 | 11 hrs 55 Mins
LAN 1 | I | 2014-05-01 19:48:00 | 11 hrs 55 Mins
LAN 2 | A | 2014-05-01 18:05:04 | 0 hrs 15 Mins | first document was tagged at 6.5PM and last document was tagged at 6.20 PM
LAN 2 | B | 2014-05-01 18:06:05 | 0 hrs 15 Mins
LAN 2 | C | 2014-05-01 18:07:05 | 0 hrs 15 Mins
LAN 2 | D | 2014-05-01 18:08:05 | 0 hrs 15 Mins
LAN 2 | E | 2014-05-01 18:09:05 | 0 hrs 15 Mins
LAN 2 | F | 2014-05-01 18:10:05 | 0 hrs 15 Mins
LAN 2 | G | 2014-05-01 18:11:05 | 0 hrs 15 Mins
LAN 2 | H | 2014-05-01 18:12:05 | 0 hrs 15 Mins
LAN 2 | I | 2014-05-01 18:13:05 | 0 hrs 15 Mins
LAN 2 | A | 2014-05-01 18:14:05 | 0 hrs 15 Mins
LAN 2 | B | 2014-05-01 18:15:05 | 0 hrs 15 Mins
LAN 2 | C | 2014-05-01 18:16:05 | 0 hrs 15 Mins
LAN 2 | D | 2014-05-01 18:20:04 | 0 hrs 15 Mins
LAN 3 | A | 2014-05-01 17:15:00 | 2 hrs 15 mins | first document was tagged at 5.15PM and last document was tagged at 7.30 PM
LAN 3 | B | 2014-05-01 17:16:00 | 2 hrs 15 mins
LAN 3 | C | 2014-05-01 19:30:00 | 2 hrs 15 mins
LAN 3 | D | 2014-05-01 17:25:00 | 2 hrs 15 mins
LAN 3 | E | 2014-05-01 17:30:00 | 2 hrs 15 mins
LAN 3 | F | 2014-05-01 18:15:00 | 2 hrs 15 mins
LAN 3 | G | 2014-05-01 17:18:00 | 2 hrs 15 mins
Spreadsheet: 783579d1654930999-search-exact-match-not-sure-where-the-problem-is-sample-data
Sheet: data (2)

 |  |  |  |  |  |  |  | Sales Team
 |  |  |  |  |  |  |  | Jo
 |  |  |  |  |  |  |  | [NAME]
Email_subject | Email_date | Email_sender | Email_text | Sender |  |  |  | Meg
[NAME] | [NAME] date | Sender | Content including same Meg
[NAME] | [NAME] date | Sender | Content including job [NAME]
[NAME] | [NAME] date | Sender | Content including mega [NAME]
Spreadsheet: 753770d1635744552-find-total-quantity-comparing-multiple-cells-in-another-sheet-stock3
Sheet: home

 | Stationary Details
 | Item code | Item name | opening balance
 | p1 | A1 | 50
 | p2 | A2 | 80
 | p3 | A3 | 100
 | p4 | A4 | 70
 | p5 | A5 | 60
 |  |  | 40
Spreadsheet: dbefd1cf-77d1-44da-84e1-ea5709a4c675
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
43049039 | 2014-09-06 22:34:19 | ALLIES | 0 | 4 | 6 | 256598 | sam1812 | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
43049521 | 2014-09-06 22:52:52 | AXIS | 1 | 6 | 4 | 256598 | sam1812 | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
43174986 | 2014-09-15 21:44:16 | ALLIES | 1 | 5 | 1 | 398065 | Keisus | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
43175197 | 2014-09-15 22:00:46 | ALLIES | 1 | 6 | 3 | 1630836 | OneEyedMonkey | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43201697 | 2014-09-17 22:07:19 | AXIS | 1 | 10 | 4 | 832450 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 6Inter O&M 11-20

Table 5.2.61.  Present Value of Intermittent Operations and [NAME] (Years 11-20)
 |  |  |  |  |  |  |  |  |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of O&M Costs for Year:
Component | Unit Cost | Unit | Quantity | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  |  | Total Present Value of Intermittent Operations & Maintenace Costs (Years 11-20):
 |  |  |  |  |  |  |  |  |  |  |  | Total Present Value of Intermittent Operations & Maintenance Costs (Life of Project):
Spreadsheet: sally_beck__33696__Hot List 0609
Sheet: Hotlist - Completed

E N R O N   N O R T H   A M E R I C A - H O T  L I S T |  |  |  |  |  |  |  |  |  |  |  | 2Q00 DEALS COMPLETED
 |  | East Midstream |  |  |  |  |  | Mexico
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | City of Austin |  | 0
 |  | Budget |  |  |  | Overview |  | Budget |  |  |  | Overview
 |  | 20493 |  |  |  |  |  | 4656
 |  | West Midstream |  |  |  |  |  | ENA Upstream Assets
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  |  |  |  |  |  |  | Gallup |  | 861
 |  |  |  |  |  |  |  | Saxet Energy |  | 552
 |  | Budget |  |  |  | Overview |  | North Central Oil |  | 527
 |  | 13235 |  |  |  |  |  | CP&L |  | 490
 |  |  |  |  |  |  |  | Costilla |  | 454
 |  | Industrial Downstream |  |  |  |  |  | Costilla |  | 256
 |  | Deal |  | Value |  |  |  | EEX |  | 230
 |  | Grupo Editorale Espresso |  | 220 |  |  |  | Chusei |  | 208
 |  | Pacific Forrest Resources |  | 116 |  |  |  | 89 Deals Under 200K
 |  | Budget |  |  |  | Overview |  | Budget |  |  |  | Overview
 |  | 22861 |  |  |  |  |  | 30471
 |  | Generation Investments |  |  |  |  |  | Principal Investing
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | Motown |  | 12600
 |  | Budget |  |  |  | Overview |  | Budget |  |  |  | Overview
 |  | 18711 |  |  |  |  |  | 15385
 |  | Coal Origination & Finance |  |  |  |  |  | Energy Capital Resources
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | Budget |  |  |  | Overview |  | Budget |  |  |  | Overview
 |  | 12747 |  |  |  |  |  | 9328
 |  | Canada Origination & Finance |  |  |  |  |  | CTG Assets
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | CNR Pipe Assignment |  | 1300 |  |  |  | Gasco |  | -170
 |  | CNR Warrants |  | 1700
 |  | CNR Warrants 2 |  | 950
 |  | Blue Range Recovery |  | 500
 |  | [NAME] |  | 400
 |  | Beau Canada |  | 350
 |  | Gas Alberta |  | 340
 |  | Enmax |  | 230
 |  | Aggregate Deals < $200K |  | 700
 |  | British Energy PPA |  | 0 |  |  |  | Budget |  |  |  | Overview
 |  | Budget |  |  |  | Overview |  | 2430
 |  | 11556
 |  |  |  |  |  |  |  | Office of the Chairman
 |  | GRM New Products |  |  |  |  |  | Deal |  | Value
 |  | Deal |  | Value
 |  |  |  |  |  |  |  | Budget |  |  |  | Overview
 |  | Budget |  |  |  | Overview |  | 38074
 |  | 7712
Spreadsheet: 272260d1382316467-need-to-remove-duplicate-address-rows-in-two-data-lists-one-is-in-all-caps-forum-example
Sheet: Sheet1

This is the current situation, the bulk list is over 9,000 long, and contains many of the names from the customer list in "E-F"  Need to remove any addresses found in "E-F"  from the  "A-B-C" columns
Bulk Address List | City | St |  | Customer Address List | City
11621 Nw 72Nd Ter | Alachua | FL |  | 10209  Nw 209Th Lane | Alachua
11630 Nw 72Nd Ter | Alachua | FL |  | 22806  Nw Cr 241 | Alachua
11704 Nw 69Th Ter | Alachua | FL |  | 9944  Nw 136Th Drive | Alachua
11734 Nw 74Th Ter | Alachua | FL |  | 12811  Nw 112Th Ave | Alachua
117515 Nw 122Nd Ter | Alachua | FL |  | 12606  Nw 142Nd Terrace | Alachua
11805 Nw 140Th St | Alachua | FL |  | 1821  Nw 198Th Lane | Alachua
11817 Nw 72Nd Ter | Alachua | FL |  | 12103  Nw 136Th St | Alachua
11907 Nw 129Th Ter | Alachua | FL |  | 23608  Nw 78Th Ave | Alachua
12103 Nw 136Th St | Alachua | FL
12811  Nw 112Th Ave | Alachua | FL
This is the desired result list………on another sheet or column, with the duplicate addresses deleted
Bulk Address List | City | St
11621 Nw 72Nd Ter | Alachua | FL
11630 Nw 72Nd Ter | Alachua | FL
11704 Nw 69Th Ter | Alachua | FL
11734 Nw 74Th Ter | Alachua | FL
117515 Nw 122Nd Ter | Alachua | FL
11805 Nw 140Th St | Alachua | FL
11817 Nw 72Nd Ter | Alachua | FL
11907 Nw 129Th Ter | Alachua | FL
Spreadsheet: 9c164bc9-77ed-4298-828b-d0941df7b784
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
YOLK | Test | YOLK | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
YOLK | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
YOLK | Result | YOLK | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6107-7
Spreadsheet: 215912d1361538880-find-data-betwwen-two-dates-find-data-between-2-dates
Sheet: Sheet1

1234 | DONE | 2012-01-01 00:00:00 |  |  | 2012-01-01 00:00:00
12344 | NOT | 2012-02-21 00:00:00 |  |  | 2012-04-22 00:00:00
34323 | DONE | 2012-03-15 00:00:00
45678 | NOT | 2012-01-13 00:00:00
67890 | DONE | 2012-04-22 00:00:00
43434 | NOT | 2012-09-01 00:00:00
99999 | DONE | 2013-02-01 00:00:00
Spreadsheet: 25456b08-2ddd-481c-8db5-0e9c97e4ced8
Sheet: Sheet1

Rappahannock Basin (3-) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  | 42
Spreadsheet: 540950d1507050056-autofill-company-name-with-partial-input-label-copy
Sheet: Sheet2

Company Name | Address
Bunbury Farmers Market | Deliver to: K & G Distributors, Canning Vale Market, next to [NAME]
[NAME] | 23 St Quentin Ave, Claremont
[NAME] | 15/1 N Beach Rd, North Beach
[NAME] | 82 Marina Blvd, Ocean Reef
[NAME] | 180 Rokeby Rd, Subiaco
[NAME] | Birchwood Ave & Rosewood Avenue, Woodlands
IGA / Alkimos | 1/1 Graceful Blvd, Alkimos
IGA / Atwell | 129 [NAME], Atwell
IGA / Beaumaris | [NAME], [NAME]
IGA / Broadway | Broadway Fair Shopping Centre, Crawley
IGA / Captain Stirling | Stirling Hwy & Florence Rd, Nedlands
IGA / Carine | 10/473 Beach Rd, Duncraig
IGA / City Beach | Ocean Village Shopping Centre, 3 Kilpa Ct
IGA / Como | 25 [NAME], Como
IGA / Cottesloe | 1/36 [NAME], Cottesloe
IGA / Duncraig | Duncraig Shopping Centre, 15/50 Marri Rd
IGA / East Perth | 81 Royal St, East Perth
IGA / Leeming | Findlay Rd & Farrington Road, Leeming
IGA / Marmion | [NAME], Marmion
IGA / Morris Fresh | 1/27 Morris Pl, Innaloo
IGA / Mosman Park | 130 Wellington St, Mosman Park
IGA / Mt Lawley | 629 Beaufort St
IGA / Mt Pleasant | 80 Cranford Ave, Mount Pleasant
IGA / Park Hive | 1/1 Macquarie Blvd, Hammond Park
IGA / Pearsall | 155 [NAME], Pearsall
IGA / Riverton | [NAME], Riverton
IGA / Sanderson Rd | Sanderson Rd & Willoughby Rd, [NAME]
IGA / South Fremantle | 195 Hampton Rd, South Fremantle
IGA / The Downs | 6/3 Bournemouth Cres, [NAME]
Supa IGA / Hilton | 285 South St, Hilton
Supa IGA / Kinross | 3 Selkirk Dr, Kinross
Supa IGA / Lynwood | 1/6-12 Lynwood Ave, Lynwood
Supa IGA / Northbridge | 150 Newcastle St, Northbridge
[NAME] | 176-178 Swansea St E, East Victoria Park
Xpress IGA / Denmark | Deliver to: 3 Divison Rd. Maddington
Spreadsheet: 851599d1701798666-return-a-value-between-a-number-on-different-sheets-test-dates
Sheet: OnCallSheet

2024 On-Call Duty Schedule |  | Holiday | Day | Date
December 2023 | 2023-12-06 00:00:00
 |  | Christmas Day | Monday | 2023-12-25 00:00:00
 |  | New Year's | Monday | 2024-01-01 00:00:00
January 2024
February
 |  | President’s Day
March
April
May
 |  | Memorial Day
June
July |  | Independence Day
August
September |  | Labor Day
October
November
 |  | Thanks Giving & Day After
December
 |  | Christmas
January 2025
Spreadsheet: 40257d1238568829-convert-multiple-currency-to-usd-with-filter-678002_ying_2
Sheet: JAN09SEA

Exchange Rate:
EUR | 1.3941061
HKD | 0.1290199
USD | 1
 |  |  |  | Ex-Country |  |  |  | Currency | FOB Price |  |  |  |  | Freight charge | Surcharge |  |  |  |  |  |  |  | TYPE
 |  |  |  | SRI |  |  |  | HKD | 332934 |  |  |  |  | 2583.91 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | THA |  |  |  | USD | 17351.4 |  |  |  |  | 256.92 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | THA |  |  |  | HKD | 90432 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | VIE |  |  |  | HKD | 29484 |  |  |  |  | 39.6 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | MAL |  |  |  | HKD | 52622.8 |  |  |  |  | 98.81 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | CHN |  |  |  | HKD | 337900.8 |  |  |  |  | 487.49 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | CHN |  |  |  | HKD | 1551391.5 |  |  |  |  | 1319.88 | 377.57 |  |  |  |  |  |  |  | FG
 |  |  |  | THA |  |  |  | HKD | 34416 |  |  |  |  | 38.82 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | SRI |  |  |  | HKD | 1151844.9 |  |  |  |  | 2057.46 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | PHP |  |  |  | HKD | 34069 |  |  |  |  | 88.14 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | PHP |  |  |  | HKD | 89388 |  |  |  |  | 124.72 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | CHN |  |  |  | HKD | 136122 |  |  |  |  | 225.08 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | VIE |  |  |  | USD | 1036902.89 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | CHN |  |  |  | HKD | 324082 |  |  |  |  | 666.15 | 245.42 |  |  |  |  |  |  |  | FG
 |  |  |  | THA |  |  |  | USD | 172 |  |  |  |  | 38.82 | 0 |  |  |  |  |  |  |  | RM
 |  |  |  | THA |  |  |  | USD | 23473.9 |  |  |  |  | 284.43 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | THA |  |  |  | HKD | 98370 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | VIE |  |  |  | HKD | 39880 |  |  |  |  | 67.54 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | VIE |  |  |  | HKD | 172945 |  |  |  |  | 74.14 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | SRI |  |  |  | HKD | 804353.8 |  |  |  |  | 5434.8 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | ITA |  |  |  | EUR | 130166 |  |  |  |  | 155.28 | 124.22 |  |  |  |  |  |  |  | FG
 |  |  |  | CHN |  |  |  | HKD | 325331.1 |  |  |  |  | 1048.09 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | THA |  |  |  | USD | 34526.7 |  |  |  |  | 233.27 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | THA |  |  |  | HKD | 15600 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | VIE |  |  |  | USD | 84943.83 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | RM
 |  |  |  | CHN |  |  |  | HKD | 28564 |  |  |  |  | 306.39 | 0 |  |  |  |  |  |  |  | FG
 |  |  |  | CHN |  |  |  | HKD | 845768.5 |  |  |  |  | 854.04 | 188.79 |  |  |  |  |  |  |  | FG
 |  |  |  | SRI |  |  |  | HKD | 433261.2 |  |  |  |  | 3097.84 | 0 |  |  |  |  |  |  |  | FG
Spreadsheet: 463127d1464304518-formula-linking-issue-every-5th-row
Sheet: Sheet1

 | One |  |  |  | Two
Spreadsheet: 269234d1381070669-conditional-formatting-copy-paste-in-increments-workbook
Sheet: Sheet1

1 |  | 0.5 |  | 0.75 | 0.25 | 1
0.5 | 1 | 0.5 | 0.5 | 0.25 | 0.75 | 0.5
1 | 0.75 | 0.5 | 1 | 0.5
0.25 | 0.25 | 0.75 |  | 0.5
Spreadsheet: 783367d1654766581-problem-with-return-to-single-specific-value-according-to-the-specific-items-return-to-single-specific-value-according-to-the-specific-items
Sheet: Sheet1

 | Return to single specific value according to the specific items
 |  |  |  |  |  |  |  |  | tomatoes | <<---- key in any fruit names in the list
 | Date | Inv-numbers | fruit | fruit | fruit | fruit
 | 2015-05-01 00:00:00 | 1 | oranges | grapefruits | tomatoes | limes
 | 2015-05-02 00:00:00 | 2 | nectarines | rockmelons | peaches | plums |  |  |  | INCORRECT OUTCOME |  |  | DESIRED OUTCOME
 | 2015-05-03 00:00:00 | 3 | bananas | tomatoes | apples | tomatoes |  |  |  | (got repeat value) |  |  | (skip repeat value)
 | 2015-05-04 00:00:00 | 4 | strawberries | raspberries | blueberries | kiwifruit
 | 2015-05-05 00:00:00 | 5 | apples | pears | oranges | apples |  |  |  | Inv-numbers |  |  | Inv-numbers
 | 2015-05-06 00:00:00 | 6 | watermelons | rockmelons | honeydew | bananas |  |  |  |  |  |  | 1
 | 2015-05-07 00:00:00 | 7 | apples | avocados | apples | nectarines |  |  |  |  |  |  | 3
 | 2015-05-08 00:00:00 | 8 | raspberries | blueberries | peaches | plums |  |  |  |  |  |  | 9
 | 2015-05-09 00:00:00 | 9 | bananas | apricots | peaches | tomatoes |  |  |  |  |  |  | 10
 | 2015-05-10 00:00:00 | 10 | tomatoes | tomatoes | watermelons | tomatoes
 |  |  |  |  |  |  |  |  |  |  |  |  | Additional : Can do it without using { ARRAY FORMULA } ??
Spreadsheet: 181476d1348054950-sumifs-not-working-quite-right-sumifs-of-dates
Sheet: Sheet1

Date | £ |  | Month | Jan
2012-08-12 00:00:00 | 18 |  | Year | 2012
2012-01-01 00:00:00 | 56
2012-01-02 00:00:00 | 22 |  | [NAME] |  | (Should be 56+22)
2012-03-05 00:00:00 | 35
2012-03-01 00:00:00 | 4
2012-06-06 00:00:00 | 33