tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 781144d1653024103-how-to-use-multiple-formula-at-one-cell-example-book
Sheet: Shipment Detail

Date Create | Shipment ID | Product Name | [NAME] | SHIP QTY | Total Quantity | Total Pallet | Total weight of product | Total Weight of shipment | Shipping cost | Shipping unit cost
2022-01-06 00:00:00 | 20000 | AAA | 5 | 147 |  | 6
2022-01-06 00:00:00 | 20000 | BBB | 1 | 464 | 0 | 0 |  | 0
2022-01-06 00:00:00 | 20000 | CCC | 0.5 | 210 | 0 | 0 |  | 0
2022-01-06 00:00:00 | 20000 | DDD | 0.5 | 140 | 0 | 0 |  | 0
2022-01-06 00:00:00 | 20000 | EEE | 1 | 120 | 0 | 0 |  | 0
2022-01-06 00:00:00 | 20000 | FFF | 1 | 240 | 0 | 0 |  | 0
2022-01-06 00:00:00 | 20000 | GGG | 1 | 120 | 0 | 0 |  | 0
2022-01-06 00:00:00 | 20000 | III | 1 | 276 | 0 | 0 |  | 0
2022-01-06 00:00:00 | 20000 | JJJ | 2 | 200 | 0 | 0 |  | 0
2022-01-06 00:00:00 | 20000 | KKK | 3 | 196 | 0 | 0 |  | 0
2022-01-06 00:00:00 | 20000 | LLL | 5 | 168 | 0 | 0 |  | 0
2022-01-06 00:00:00 | 20000 | MMM | 1 | 560 | 0 | 0 |  | 0
2022-01-07 00:00:00 | 30000 | AAA | 3 | 210 |  | 1
2022-01-07 00:00:00 | 30000 | CCC | 1 | 210 | 0 | 0 |  | 0
2022-01-07 00:00:00 | 30000 | DDD | 1 | 240 | 0 | 0 |  | 0
2022-01-10 00:00:00 | 40000 | EEE | 2 | 250 |  | 9
2022-01-10 00:00:00 | 40000 | JJJ | 2 | 392 | 0 | 0 |  | 0
2022-01-10 00:00:00 | 40000 | KKK | 3 | 196 | 0 | 0 |  | 0
2022-01-10 00:00:00 | 40000 | LLL | 2 | 490 | 0 | 0 |  | 0
2022-01-10 00:00:00 | 40000 | MMM | 1 | 480 | 0 | 0 |  | 0
2022-01-10 00:00:00 | 40000 | BBB | 2 | 1470 | 0 | 0 |  | 0
2022-01-13 00:00:00 | 50000 | FFF | 2 | 100 |  | 1
2022-01-14 00:00:00 | 60000 | GGG | 2 | 250 |  | 10
2022-01-14 00:00:00 | 60000 | HHH | 2 | 441 | 0 | 0 |  | 0
2022-01-14 00:00:00 | 60000 | JJJ | 1 | 588 | 0 | 0 |  | 0
2022-01-14 00:00:00 | 60000 | KKK | 1 | 150 | 0 | 0 |  | 0
2022-01-14 00:00:00 | 60000 | MMM | 0.5 | 108 | 0 | 0 |  | 0
2022-01-14 00:00:00 | 60000 | LLL | 2 | 240 | 0 | 0 |  | 0
2022-01-14 00:00:00 | 60000 | AAA | 2 | 784 | 0 | 0 |  | 0
2022-01-14 00:00:00 | 60000 | BBB | 3 | 256 | 0 | 0 |  | 0
2022-01-14 00:00:00 | 60000 | CCC | 0.5 | 150 | 0 | 0 |  | 0
2022-01-14 00:00:00 | 60000 | DDD | 1 | 512 | 0 | 0 |  | 0
2022-01-14 00:00:00 | 60000 | EEE | 2 | 530 | 0 | 0 |  | 0
2022-01-14 00:00:00 | 60000 | FFF | 1 | 500 | 0 | 0 |  | 0
Total
Spreadsheet: 271886d1382098217-problems-with-formula-calculating-dates-and-count-ifs-mngt-employee-stats-30-september-2013
Sheet: Sheet2

2013-09-30 00:00:00
2013-07-01 00:00:00
2013-07-01 00:00:00 |  |  |  | no. of employees | % of workforce
2013-06-03 00:00:00 |  |  | > 1 year
2013-05-28 00:00:00 |  |  | 1 year
2013-05-28 00:00:00 |  |  | 2 years
2013-05-16 00:00:00 |  |  | 3 years |  |  | > 4 years
2013-05-13 00:00:00 |  |  | 4 years
2013-05-08 00:00:00 |  |  | 5 years
2013-05-02 00:00:00 |  |  | 6 years |  |  | 5 -10 years
2013-04-29 00:00:00 |  |  | 7 - 10 years
2013-04-01 00:00:00 |  |  | 11 - 14 years
2013-02-18 00:00:00 |  |  | 15 - 19 years |  |  | 11 - 20+ years
2013-02-11 00:00:00 |  |  | 20 years plus
2013-01-02 00:00:00 |  |  | TOTAL
2012-11-26 00:00:00
2012-11-01 00:00:00
2012-09-24 00:00:00
2012-06-07 00:00:00
2012-06-01 00:00:00
2012-06-01 00:00:00
2012-04-18 00:00:00
2012-04-18 00:00:00
2012-04-16 00:00:00
2012-04-16 00:00:00
2012-01-03 00:00:00
2011-10-10 00:00:00
2010-07-01 00:00:00
2010-03-01 00:00:00
2009-04-06 00:00:00
2009-01-19 00:00:00
2008-12-01 00:00:00
2008-10-01 00:00:00
2008-09-15 00:00:00
2008-08-18 00:00:00
2008-05-06 00:00:00
2007-06-18 00:00:00
2007-06-18 00:00:00
2007-02-19 00:00:00
2007-01-02 00:00:00
2006-05-22 00:00:00
2006-04-24 00:00:00
2006-04-10 00:00:00
2006-04-03 00:00:00
2006-01-03 00:00:00
2005-06-06 00:00:00
2005-05-23 00:00:00
2005-01-03 00:00:00
2004-12-01 00:00:00
2004-10-01 00:00:00
2004-06-02 00:00:00
2003-09-01 00:00:00
2003-07-01 00:00:00
2003-06-02 00:00:00
2003-04-01 00:00:00
2003-03-24 00:00:00
2002-10-28 00:00:00
2002-06-05 00:00:00
2002-05-07 00:00:00
2002-02-01 00:00:00
2002-02-01 00:00:00
2002-01-02 00:00:00
2001-08-13 00:00:00
2001-05-29 00:00:00
2001-05-29 00:00:00
2001-01-15 00:00:00
2000-08-29 00:00:00
2000-04-17 00:00:00
1996-05-01 00:00:00
1996-04-09 00:00:00
1995-08-22 00:00:00
1995-02-13 00:00:00
1995-01-03 00:00:00
1993-04-05 00:00:00
Spreadsheet: 77976d1278440472-clustering-data-copy-of-clusters
Sheet: Sheet2

 | Yes |  | Cluster 1 | 0.46 |  | 1
 | Yes |  | Cluster 2 | 0.56 |  | 0.6666666666666666
 | Yes |  | Cluster 3 | 0.4615384615384616
 | Yes
 | No
 | Yes
 | No
 | Yes
 | Yes
 | Yes
 | No
 | No
 | Yes
 | No
 | Yes
 | No
 | No
 | No
 | No
 | No
 | Yes
 | No
 | Yes
 | Yes
 | No
 | Yes
 | No
 | No
 | Yes
 | Yes
 | No
 | Yes
 | Yes
 | Yes
 | Yes
 | No
 | No
 | No
 | No
 | No
 | Yes
 | Yes
 | Yes
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | Yes
 | No
 | No
 | Yes
 | No
 | No
 | No
 | No
 | No
 | Yes
 | Yes
 | Yes
 | Yes
 | No
 | No
 | Yes
 | Yes
 | Yes
 | No
 | Yes
 | Yes
 | Yes
 | Yes
 | Yes
 | Yes
 | No
 | No
 | No
 | Yes
 | Yes
 | No
 | No
 | Yes
 | Yes
 | Yes
 | No
 | Yes
 | Yes
 | Yes
 | Yes
 | No
 | No
 | Yes
 | No
 | No
 | Yes
 | Yes
 | Yes
 | No
 | No
 | Yes
 | Yes
 | Yes
 | Yes
 | Yes
 | Yes
 | Yes
 | No
 | No
 | Yes
 | No
 | No
 | No
 | Yes
 | No
 | Yes
 | No
 | Yes
 | No
 | No
 | No
 | No
 | No
 | Yes
 | Yes
 | Yes
 | No
 | No
 | No
 | No
 | No
 | Yes
 | Yes
 | Yes
 | No
 | No
 | No
 | Yes
 | No
 | No
 | No
 | No
 | Yes
 | Yes
 | No
 | Yes
 | No
 | No
 | Yes
 | No
 | Yes
 | Yes
Spreadsheet: 116780d1312159648-inventory-spreadsheet-sales-decrease-values-example
Sheet: sales

sold_date | [NAME] | Product | Quantity | sale_price | Cost Price | Profit
2011-01-03 00:00:00 | XbxsYw |  | 3 | 15
2011-01-03 00:00:00 | XbxsRd |  | 1 | 5
2011-01-07 00:00:00 | CR1616 |  | 1 | 1
2011-01-10 00:00:00 | NK503hp |  | 1 | 50
2011-01-12 00:00:00 | XbxsRd |  | 1 | 5
2011-01-13 00:00:00 | XbxsRd |  | 1 | 5
2011-01-14 00:00:00 | NK503hp |  | 1 | 50
Spreadsheet: 771547d1646725341-look-up-a-column-with-duplicates-and-return-from-multiple-specified-columns-book1
Sheet: Sheet1

Product ID | Colour | Weight | # ID | % Value | Origin |  |  | Desired Results
111 | Green |  |  |  |  |  |  | Product ID | Colour | # ID | Origin | % Value
222 | Blue |  |  |  |  |  |  | 111
333 | Red |  |  |  |  |  |  | 222 | Blue | #655 | UAE | 0.99
444 | Yellow
111 |  |  |  | 0.5 | China |  |  |  |  | #657 | China | 0.5
333 |  |  |  | 0.3 | Australia |  |  |  | Blue | #655 | UAE | 0.99
444 |  |  |  | 0.4 | USA
555 |  |  |  | 0.55 | UK
222 |  |  |  | 0.99 | UAE
555 |  | 1mg | #6543
222 |  | 2mg | #655
333 |  | 3mg | #656
111 |  | 4mg | #657
444 |  | 5mg | #658
Spreadsheet: 868237d1714985056-tier-incentive-will-be-automatically-calculated-based-on-tier-hani-calculation-
Sheet: Dr Al Rajhi

 |  |  | Revenue | Target
 |  | Revenue |  | 250000
 |  | Consumables
 |  | Net Amount
 |  | Dr [NAME]
 |  | Lab | 0
 |  | Lab Percentage 5%
 |  | Net to Pay
 |  | 250000-350000 | 0.1
 |  | 350001-500000 | 0.15
 |  | 500001-700000 | 0.2
 |  | 700001 and above | 0.3
 |  | Total Amount
 |  | Referral 10 % | 0
 |  | Net Total Amount to pay
 |  |  |  | Doctor [NAME] ……………
Spreadsheet: 454975d1460050843-if-word-appears-in-column-b-within-date-range-in-column-q-copy-of-test-6
Sheet: N8770 BM

N8770 Battery Maintenance
Status |  |  |  |  |  |  |  |  |  |  | Average sites received per day | Average sites [NAME] per day
aborted |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00
Active |  |  |  |  |  |  |  |  |  | 2016-02-01 00:00:00
Complete |  |  |  |  |  |  |  |  |  | 2016-03-01 00:00:00
Issue |  |  |  |  |  |  |  |  |  | 2016-04-01 00:00:00
inactive |  |  |  |  |  |  |  |  |  | 2016-05-01 00:00:00
planned |  |  |  |  |  |  |  |  |  | 2016-06-01 00:00:00
Survey |  |  |  |  |  |  |  |  |  | 2016-07-01 00:00:00
Specialist |  |  |  |  |  |  |  |  |  | 2016-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-10-01 00:00:00 |  |  |  |  |  | working days
 |  |  |  |  |  |  |  |  |  | 2016-11-01 00:00:00 |  |  |  | 2016-01-01 00:00:00 | 2016-01-31 00:00:00
Battery Handling |  |  |  |  |  |  |  |  |  | 2016-12-01 00:00:00 |  |  |  | 2016-02-01 00:00:00 | 2016-02-29 00:00:00
 | 12v30F | 12v33F | 12V62F | 12V92F | 12V170F | SBS 60 | Total |  |  |  |  |  |  | 2016-03-01 00:00:00 | 2016-03-31 00:00:00
2016-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-04-01 00:00:00 | 2016-04-30 00:00:00
2016-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-05-01 00:00:00 | 2016-05-31 00:00:00
2016-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-06-01 00:00:00 | 2016-06-30 00:00:00
2016-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-07-01 00:00:00 | 2016-07-31 00:00:00
2016-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-08-01 00:00:00 | 2016-08-31 00:00:00
2016-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-09-01 00:00:00 | 2016-09-30 00:00:00
2016-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-10-01 00:00:00 | 2016-10-31 00:00:00
2016-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-11-01 00:00:00 | 2016-11-30 00:00:00
2016-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-12-01 00:00:00 | 2016-12-31 00:00:00
2016-10-01 00:00:00
2016-11-01 00:00:00
2016-12-01 00:00:00
Date | Orders Received | Complete | Aborted | Surveys | Total events
2016-01-01 00:00:00
2016-02-01 00:00:00
2016-03-01 00:00:00
2016-04-01 00:00:00
2016-05-01 00:00:00
2016-06-01 00:00:00
2016-07-01 00:00:00
2016-08-01 00:00:00
2016-09-01 00:00:00
2016-10-01 00:00:00
2016-11-01 00:00:00
2016-12-01 00:00:00
Spreadsheet: 686823d1594825681-index-match-with-merged-cell-client-hub_engagement_eh
Sheet: Overview (2)

Client | July | August | September | October | November | December | January | February | March
 |  | 2 | 1 | 3 | 3 | 2 | 2 | 2 | 3
 | 1 | 2 | 3
Spreadsheet: 143599d1330473410-weighted-rank-if-duplicates-rank-the-average-weighted-rank
Sheet: Sheet1

Data Entries | number basis |  | weighted rank
 |  |  | expected outcome |  | NOTES:
10 | 1 |  | 1
14 | 2 |  | 2.5 |  | average of columnB  ( 2,3) - coz of duplicate data 14
14 | 3 |  | 2.5 |  | 2.5
16 | 4 |  | 4
17 | 5 |  | 5
19 | 6 |  | 6
20 | 7 |  | 7
21 | 8 |  | 8.5 |  | average of 8,9 duplicate data 21
21 | 9 |  | 8.5 |  | 8.5
25 | 10 |  | 10
78 | 11 |  | 12 |  | average of 11,12,13 triplicate 78
78 | 12 |  | 12 |  | 12
78 | 13 |  | 12
65 | 14 |  | 14
 |  |  | have problem with this column
***********   It is better if the "NUMBER BASIS" will be joined or included in the weighted rank formula..
 | so that there will be only two columns ( Data Entry and Weithed Rank only )
Spreadsheet: darrell_schoolcraft__7638__imball0201
Sheet: Stratland

 | Stratland Exploration
 | POI 60211 - Jones Trust
Day | Measured | Scheduled
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
2001-12-31 00:00:00 |  |  | 43180.07
2002-01-07 00:00:00
CBS Volume
 |  |  | 14850
Spreadsheet: 860428d1708528100-i-need-to-find-consecutive-big-or-small-or-combination-of-both-in-a-row-book1
Sheet: Sheet1

965 | SMALL
966 | BIG
967 | SMALL
968 | SMALL
969 | SMALL
970 | SMALL
971 | BIG
972 | BIG
973 | BIG
974 | SMALL
975 | BIG
976 | BIG
977 | BIG
978 | BIG
979 | BIG
980 | BIG
981 | SMALL
982 | BIG
983 | BIG
984 | SMALL
985 | SMALL
986 | BIG
987 | BIG
988 | SMALL
989 | SMALL
990 | SMALL
991 | SMALL
992 | SMALL
993 | SMALL
994 | BIG
995 | SMALL
996 | SMALL
997 | BIG
998 | BIG
999 | BIG
0 | SMALL
1 | BIG
2 | BIG
3 | BIG
4 | BIG
5 | SMALL
6 | BIG
7 | BIG
8 | BIG
9 | SMALL
10 | SMALL
11 | SMALL
12 | SMALL
13 | SMALL
14 | SMALL
15 | BIG
16 | BIG
17 | SMALL
18 | BIG
19 | BIG
20 | SMALL
21 | SMALL
22 | SMALL
841 | SMALL
842 | SMALL
843 | SMALL
844 | BIG
845 | BIG
846 | BIG
847 | SMALL
848 | SMALL
849 | SMALL
850 | SMALL
851 | SMALL
852 | BIG
853 | SMALL
854 | SMALL
855 | BIG
856 | BIG
857 | BIG
858 | SMALL
859 | BIG
860 | BIG
Spreadsheet: gerald_nemec__11517__020201 HPL
Sheet: INJECTION REPORT

ENRON
 | CORP |  |  |  |  |  |  | Interoffice
 |  |  |  |  |  |  |  | Memorandum
 | To: |  | CHARLIE THOMPSON
 | From: |  | BAMMEL OPERATOR |  |  |  |  | Deparatment: | BAMMEL
 | Subject: |  | WEEKLY [NAME] REPORT |  |  |  |  | Date: | 2001-02-01 00:00:00
 | 2001-01-26 00:00:00
 |  |  | MIN INJ | 0 |  | Net change | -317
 |  |  | MIN INJ | 0
 |  |  | MIN INJ | 237
 |  |  | MIN INJ | 578
 |  |  | MIN INJ | 0 |  | Net change | -193
 |  |  | MAX INJ | 0
 |  |  | MIN W/D | 188
 |  |  | MAX W/D | 469
 |  |  | MIN INJ | 0 |  | Net change | -195
 |  |  | MAX INJ | 0
 |  |  | MIN W/D | 111
 |  |  | MAX W/D | 282
 |  |  | MIN INJ | 0 |  | Net change | -203
 |  |  | MAX INJ | 0
 |  |  | MIN W/D | 166
 |  |  | MAX W/D | 207
 |  |  | MIN INJ | 0 |  | Net change | -280
 |  |  | MAX INJ | 0
 |  |  | MIN W/D | 177
 |  |  | MAX W/D | 359
 |  |  | MIN INJ | 0 |  | Net change | -122
 |  |  | MAX INJ | 0
 |  |  | MIN W/D | 60
 |  |  | MAX W/D | 438
 |  |  | MIN INJ | 0 |  | Net change | -313
 |  |  | MAX INJ | 0
 |  |  | MIN W/D | 106
 |  |  | MAX W/D | 399
 |  |  |  | Total Net Reservoir Change
 |  |  |  |  | GIP |  | 75.227 | BCF
Spreadsheet: 9e4d4cdf-37a3-4b51-ad6e-700599db545e
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
FSMAC | Test | FSMAC | Spinal [NAME] Test | SMA Evaluation (Carrier) | [NAME], ddCt Method | Lavender-top (EDTA) Tube: EDTA OR Yellow-top (ACD) tube OR |  |  | 4 | mL | Draw 4 mL whole blood in a lavender-top (EDTA) or yellow-top (ACD) tube. Ship refrigerate. | 2 mL | Hemolysis:	NA Thawing:	NA Lipemia:	NA Icterus:	NA Other:	NA | Testing is complete. Report has been attached in MayoAccess.   Test Performed by: Athena Diagnostics                              377 Plantation Street                              Four Biotech Park                              Worcester, MA 01605 | Upon Receipt | 7 days | 9 - 11 days | 1 | 81401 |  |  |  |  | Athena Diagnostics
FSMAC | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 14 days
FSMAC | Result | Z2415 | SMA Evaluation (Carrier) | SMA Evaluation (Carrier) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 874374d1720969702-trying-to-find-the-nth-smallest-and-nth-largest-between-2-user-defined-dates-in-excel-2010-sortabledates
Sheet: Sheet1

User Selectable
 | Begin Date | 1986-01-01 00:00:00 | End Date | 2024-12-24 00:00:00
 |  |  |  |  |  |  | Shortest Warnings |  |  |  | Longest Warnings
 | Date | Minutes | Helper Minutes | Area | Helper Area |  | Rank | Minutes | Date |  | Rank | Minutes | Date
 | 1986-01-01 00:00:00 | 00:07:00 |  | 17 |  |  | 1 |  |  |  | 1
 | 1987-04-08 00:00:00 | 00:12:00 |  | 2300 |  |  | 2 |  |  |  | 2
 | 1987-08-31 00:00:00 | 00:45:00 |  | 22 |  |  | 3 |  |  |  | 3
 | 1989-10-10 00:00:00 | 00:22:00 |  | 450 |  |  | 4 |  |  |  | 4
 | 1989-11-11 00:00:00 | 00:32:00 |  | 670 |  |  | 5 |  |  |  | 5
 | 1994-01-01 00:00:00 | 00:17:00 |  | 22 |  |  | 6 |  |  |  | 6
 | 1997-02-12 00:00:00 | 00:45:00 |  | 45 |  |  | 7 |  |  |  | 7
 | 1998-09-02 00:00:00 | 01:22:00 |  | 2300 |  |  | 8 |  |  |  | 8
 | 1999-04-06 00:00:00 | 00:07:00 |  | 22 |  |  | 9 |  |  |  | 9
 | 2000-03-03 00:00:00 | 01:00:00 |  | 789 |  |  | 10 |  |  |  | 10
 | 2000-04-08 00:00:00 | 00:08:00 |  | 90
 | 2000-09-17 00:00:00 | 00:59:00 |  | 22
 | 2000-12-12 00:00:00 | 00:01:00 |  | 230 |  |  | Smallest Warnings |  |  |  | Largest Warnings
 | 2003-06-09 00:00:00 | 01:20:00 |  | 17 |  |  | Rank | Area | Date |  | Rank | Area | Date
 | 2004-12-01 00:00:00 | 00:50:00 |  | 114 |  |  | 1 |  |  |  | 1
 | 2014-03-31 00:00:00 | 00:15:00 |  | 111 |  |  | 2 |  |  |  | 2
 | 2015-08-12 00:00:00 | 00:50:00 |  | 112 |  |  | 3 |  |  |  | 3
 | 2020-07-09 00:00:00 | 00:34:00 |  | 657 |  |  | 4 |  |  |  | 4
 | 2021-06-07 00:00:00 | 00:23:00 |  | 34 |  |  | 5 |  |  |  | 5
 | 2022-06-07 00:00:00 | 01:15:00 |  | 890 |  |  | 6 |  |  |  | 6
 | 2023-07-08 00:00:00 | 00:12:00 |  | 123 |  |  | 7 |  |  |  | 7
 | 2024-05-06 00:00:00 | 00:20:00 |  | 145 |  |  | 8 |  |  |  | 8
 | 2024-05-12 00:00:00 | 01:00:00 |  | 989 |  |  | 9 |  |  |  | 9
 |  |  |  |  |  |  | 10 |  |  |  | 10
Spreadsheet: 79849d1280086269-if-or-cells-contain-specific-text-display-results-in-multiple-areas-testsheet2_rev1
Sheet: Example Table

 | Raw Data |  |  | Input Field |  |  | Output
 | Code | Name |  | Job Code | B14 |  | Name | Current Jobs | Job Code | Job Code2 | Job Code3
 | B14 | [NAME] |  | Job Code | [NAME] |  |  |  |  |  |  | Array formula in columns J:L
 | B15 | [NAME] |  | Job Code | B16
 | B16 | [NAME]
 | B14 | [NAME]
 | B17 | [NAME]
 | B18 | [NAME]
 | B14 | [NAME]
 | B16 | [NAME]
 | [NAME] | [NAME]
 | B21 | [NAME]
 | B22 | [NAME]
 | B16 | [NAME]
 | B24 | [NAME]
 | B16 | [NAME]
 | [NAME] | [NAME]
Spreadsheet: 866379d1713302470-pulling-first-second-row-value-that-is-not-zero-examplesheet
Sheet: Sheet1

Route1 | Route2 | LBUS3_Bx1 | [NAME] | LBUS3_Bx3 | LBUS3_Bx4 | LBUS3_Bx5 | LBUS3_Bx6 | [NAME] | LBUS3_Bx7 | LBUS3_Bx8 | LBUS3_Bx9 | LBUS3_Bx10 | LBUS3_Bx11 | LBUS3_Bx12 | LBUS3_Bx12SBS
 | Bx12SBS | 0 | 0 | Bx3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bx12SBS
 | Bx9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bx8 | Bx9 | [NAME] | 0 | 0 | 0
 |  | 0 | 0 | 0 | Bx4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: b9a8185e-8f0b-41f9-925f-5649d6a399ff
Sheet: Sheet1

2010 official General Election Results | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
State of North Dakota Results
Precincts Reporting: 505/505 - Total Ballots Cast: 240876
Downloaded at 5/23/2013 5:12:28 AM
 | [NAME] A [NAME]  - NON | write-in  - NON
Judge of the District Court No. 1 - Northeast | 23184 | 131
TOTAL | 23184 | 131
 | Sonja  Clapp  - NON | write-in  - NON
Judge of the District Court No. 1 - Northeast Central | 18007 | 114
TOTAL | 18007 | 114
 | [NAME] | [NAME] | write-in  - NON
Judge of the District Court No. 1 - Northwest | 14649 | 11382 | 111
TOTAL | 14649 | 11382 | 111
 | [NAME] | write-in  - NON
Judge of the District Court No. 2 - East Central | 41314 | 256
TOTAL | 41314 | 256
 | [NAME] | write-in  - NON
Judge of the District Court No. 2 - South Central | 47128 | 321
TOTAL | 47128 | 321
 | [NAME] T ([NAME]) Paulson  - NON | [NAME] | write-in  - NON
Judge of the District Court No. 2 - Southeast | 14794 | 13096 | 56
TOTAL | 14794 | 13096 | 56
 | [NAME]  - NON | write-in  - NON
Judge of the District Court No. 3 - East Central | 41351 | 262
TOTAL | 41351 | 262
 | Joel D Medd  - NON | write-in  - NON
Judge of the District Court No. 3 - Northeast Central | 18055 | 129
TOTAL | 18055 | 129
 | [NAME] | write-in  - NON
Judge of the District Court No. 4 - East Central | 41512 | 223
TOTAL | 41512 | 223
 | [NAME] | write-in  - NON
Judge of the District Court No. 4 - Northwest | 25813 | 213
TOTAL | 25813 | 213
 | [NAME] | write-in  - NON
Judge of the District Court No. 4 - Southwest | 12403 | 50
TOTAL | 12403 | 50
 | [NAME] | write-in  - NON
Judge of the District Court No. 5 - Northeast | 22644 | 110
TOTAL | 22644 | 110
 | [NAME] | Parrell  [NAME] | write-in  - NON
Judge of the District Court No. 5 - South Central | 31121 | 22728 | 96
TOTAL | 31121 | 22728 | 96
 | [NAME] | write-in  - NON
Judge of the District Court No. 5 - Southeast | 24865 | 134
TOTAL | 24865 | 134
 | [NAME] | [NAME] | write-in  - NON
Judge of the District Court No. 6 - Southeast | 12526 | 13330 | 47
TOTAL | 12526 | 13330 | 47
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 861667d1709553818-search-book1-26-
Sheet: Sheet1

Client | TEST
Client Level | Low
 | Programs | Times |  | Hours | Weekday Apportion | Evening Apportion | Saturday Apportion | In activity Transport | [NAME]
 | Evening Social Club | Thursday 18:30 to 21:30 | Devonport - Digital Fun Monday 09:00 to 15:00 | 3 |  |  |  | 0 | 0.5593242403109576
 | Saturday Recreational Program | Saturday 09:00 to 15:00 | Devonport - Transport AM 1 Monday 07:30 to 09:00 | 6 |  |  |  | 3.5 | 0
 | Evening Transport Social 1 | Thursday 17:15 to 18:30 | Devonport - Transport PM 1 Monday 15:00 to 16:30 | 1.250000000000001 |  |  |  | 3.5 | 0
 | Evening Transport Social 1 | Thursday 21:30 to 22:45 | Devonport - Transport AM 3 Wednesday 07:30 to 09:00 | 1.249999999999998 |  |  |  | 5 | 0
 |  |  |  |  |  |  |  | 5 | 0
 |  |  |  |  |  |  |  | 3.5 | 0
 |  |  |  |  |  |  |  | 0 | 0
Total
 |  | Group Activities - Standard - Weekday Daytime - TTP
 |  | Group Activities - Standard - Saturday - TTP
 |  | Group Activities - Standard - Weekday Evening - TTP
 |  | Centre Capital Cost
 |  | [NAME]
 |  | Transport kms
 |  | Weekly Cost of Programs
Spreadsheet: 871005d1717479927-extract-unique-activities-based-on-sequential-activity-logs-user-activity-log
Sheet: Activities

User | Start time | End Time | Total Time
User 1 | 2024-05-01 09:45:00 | 2024-05-01 09:52:00
User 2 | 2024-05-01 10:45:00 | 2024-05-01 10:55:00
User 3 | 2024-05-01 11:45:00 | 2024-05-01 11:58:00
User 1 | 2024-05-01 12:45:00 | 2024-05-01 12:59:00
 |  | Average Time
Spreadsheet: 147576d1332864655-preserving-row-height-when-sorting-test
Sheet: Sheet1

Project Number | Project Name | Program | Project Type | Project Manager
ATM1 | El Centro [NAME] ATM | ATM | On Site Drive Up | A-
ATM2 | South Oxnard [NAME] ATM | ATM testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing END | On Site Drive Up | B
ATM3 | Grand Terrace [NAME] ATM | ATM | On Site Drive Up | C
ATM4 | Third & K Cap Add | ATM | On Site Drive Up | D
ATM5 | [NAME] | ATM | On Site Drive Up | E
[NAME] | South Kingshighway Relo | ATM | On Site Drive Up | F
ATM7 | [NAME]-up [NAME] ATM | ATM | On Site Drive Up | G
ATM8 | [NAME] | ATM | On Site Drive Up | H
ATM9 | Hillsborough | ATM | On Site Drive Up | I
Spreadsheet: 113756d1309562483-copy-certain-cell-value-in-column-from-one-sheet-to-other-based-on-filtering-or-match-copy-certain-cell-value-in-column-from-one-sheet-to-other-based-on-filtering-or-match
Sheet: Sheet2

Row # | Name | Number | Status
Spreadsheet: 673203d1587248989-look-up-rows-and-distribute-across-columns-pallet-pick-marc47555-
Sheet: Pallet Card

 |  |  |  | Max/Pallet: | 9 |  |  |  | MOT
 | Production Date: |  |  | Depot Date: |  |  |  | Depot:
 |  |  |  |  | Pallets Needed
 | Prod Code |  | Layers | Remaining | 1 | 2 | 3 | 4 | 5
 | 0007223 |  |  |  |  |  |  |  |  |  |  |  |  |  | I need to look up the layers column
 | 5200589
 | 0007225 |  |  |  |  |  |  |  |  |  |  |  |  |  | then have this automaticaly fill the pallets needed
 | 5216848 |  |  |  |  |  |  |  |  |  |  |  |  |  | Each pallet can only have maximum 9
 | 5201843 |  |  |  |  |  |  |  |  |  |  |  |  |  | once 9 has been reached id like it to move to the next column, and do the same, then so on and so on
 | 5205162
 | 0009694
 | 5216843
 | 5210413
 | 5216837
 | 5209761
 | 5214026
 | 5214996
 | 5210292
 | 5202529
 | 5213881
 | 5214025
 | 5209314
 | 5212974
 | 5210354
 | 5202524
 |  |  |  | Total
Spreadsheet: 146693d1332317900-formatting-negative-number-within-concatenation-not-working-book1_ddmusa
Sheet: Sheet1

 | ESTIMATED |  | ACTUAL
 | 100 |  | 1100 | 1000 | 0.9090909090909091 |  | $1,000.00  91%
 | 200 |  | 1000 | 800 | 0.8 |  | $800.00  80%
 | 300 |  | 900 | 600 | 0.6666666666666666 |  | $600.00  67%
 | 400 |  | 800 | 400 | 0.5 |  | $400.00  50%
 | 500 |  | 700 | 200 | 0.2857142857142857 |  | $200.00  29%
 | 600 |  | 600 | 0 | 0 |  | -
 | 700 |  | 500 | -200 | -0.4 |  | ($200.00) -40%
 | 800 |  | 400 | -400 | -1 |  | ($400.00) -100%
 | 900 |  | 300 | -600 | -2 |  | ($600.00) -200%
 | 1000 |  | 200 | -800 | -4 |  | ($800.00) -400%