tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 542171d1507736556-ignore-blanks-cells-when-plotting-bar-graph-sgreenprice-bsb-
Sheet: Sample

[hour] | [sec] | rounddown | unique | frequency
00:15:48 | 948 | 940 | 940 | 1
00:17:20 | 1040 | 1040 | 1040 | 2
00:17:23 | 1043 | 1040 | 1050 | 3
00:17:30 | 1050 | 1050 | 1060 | 6
00:17:32 | 1052 | 1050 | 1070 | 4
00:17:34 | 1054 | 1050 | 1080 | 8
00:17:41 | 1061 | 1060 | 1090 | 6
00:17:42 | 1062 | 1060 | 1100 | 5
00:17:44 | 1064 | 1060 | 1110 | 4
00:17:45 | 1065 | 1060 | 1120 | 7
00:17:47 | 1067 | 1060 | 1130 | 5
00:17:49 | 1069 | 1060 | 1140 | 4
00:17:53 | 1073 | 1070 | 1150 | 3
00:17:55 | 1075 | 1070 | 1160 | 4
00:17:56 | 1076 | 1070 | 1170 | 3
00:17:58 | 1078 | 1070 | 1180 | 1
00:18:00 | 1080 | 1080
00:18:01 | 1081 | 1080
00:18:03 | 1083 | 1080
00:18:04 | 1084 | 1080
00:18:04 | 1084 | 1080
00:18:06 | 1086 | 1080
00:18:08 | 1088 | 1080
00:18:08 | 1088 | 1080
00:18:11 | 1091 | 1090
00:18:11 | 1091 | 1090
00:18:13 | 1093 | 1090
00:18:16 | 1096 | 1090
00:18:17 | 1097 | 1090
00:18:19 | 1099 | 1090
00:18:20 | 1100 | 1100
00:18:21 | 1101 | 1100
00:18:22 | 1102 | 1100
00:18:26 | 1106 | 1100
00:18:27 | 1107 | 1100
00:18:30 | 1110 | 1110
00:18:30 | 1110 | 1110
00:18:34 | 1114 | 1110
00:18:36 | 1116 | 1110
00:18:40 | 1120 | 1120
00:18:40 | 1120 | 1120
00:18:45 | 1125 | 1120
00:18:46 | 1126 | 1120
00:18:46 | 1126 | 1120
00:18:48 | 1128 | 1120
00:18:48 | 1128 | 1120
00:18:54 | 1134 | 1130
00:18:55 | 1135 | 1130
00:18:55 | 1135 | 1130
00:18:56 | 1136 | 1130
00:18:57 | 1137 | 1130
00:19:01 | 1141 | 1140
00:19:04 | 1144 | 1140
00:19:05 | 1145 | 1140
00:19:05 | 1145 | 1140
00:19:10 | 1150 | 1150
00:19:13 | 1153 | 1150
00:19:14 | 1154 | 1150
00:19:22 | 1162 | 1160
00:19:23 | 1163 | 1160
00:19:23 | 1163 | 1160
00:19:29 | 1169 | 1160
00:19:32 | 1172 | 1170
00:19:36 | 1176 | 1170
00:19:38 | 1178 | 1170
00:19:41 | 1181 | 1180
00:19:42 | 1182 | 1180
00:19:45 | 1185 | 1180
00:19:50 | 1190 | 1190
00:19:52 | 1192 | 1190
00:19:55 | 1195 | 1190
00:20:00 | 1200 | 1200
00:20:02 | 1202 | 1200
00:20:03 | 1203 | 1200
00:20:10 | 1210 | 1210
00:20:28 | 1228 | 1220
00:20:30 | 1230 | 1230
00:20:34 | 1234 | 1230
00:21:10 | 1270 | 1270
00:21:24 | 1284 | 1280
00:22:21 | 1341 | 1340
00:23:00 | 1380 | 1380
00:23:00 | 1380 | 1380
00:23:20 | 1400 | 1400
Spreadsheet: 795928d1663010283-combining-sheets-into-a-master-file-s666-pq-test
Sheet: Master

Concat | Customer Number | Account Manager | Company Chain | Mode | Product Code | Site | Incoterm |  | Concat | Customer Number | Account Manager | Company Chain | Mode | Product Code | Site | Incoterm
1213TruckSAD2000MEMEXW | 1213 | RC | BS | Truck | 124 | MEM | EXW |  | 1213TruckSAD2000MEMEXW | 1213 | RC | BS | Truck | 124 | MEM | EXW
1215TruckSAD50WYPCIP | 1215 | RC | BC | Truck | 125 | WYP | CIP |  | 1215TruckSAD50WYPCIP | 1215 | RC | BC | Truck | 125 | WYP | CIP
1002RailSADWYPCIP | 1002 | CR | A E | Rail | 123 | WYP | CIP |  | 1002RailSADWYPCIP | 1002 | CR | A E | Rail | 123 | WYP | CIP
1003RailSADWYPCIP | 1003 | CR | A E | Rail | 123 | WYP | CIP |  | 1003RailSADWYPCIP | 1003 | CR | A E | Rail | 123 | WYP | CIP
1871TruckSADTOLCIP | 1871 | CR | D C | Truck | 123 | TOL | CIP |  | 1871TruckSADTOLCIP | 1871 | CR | D C | Truck | 123 | TOL | CIP
1228TruckSAD2000TOLEXW | 1228 | CR | BR | Truck | 124 | TOL | EXW |  | 1228TruckSAD2000TOLEXW | 1228 | CR | BR | Truck | 124 | TOL | EXW
1693TruckSAD2000TOLEXW | 1693 | CR | BR | Truck | 124 | TOL | EXW |  | 1693TruckSAD2000TOLEXW | 1693 | CR | BR | Truck | 124 | TOL | EXW
1230TruckSAD2000TOLCIP | 1230 | CR | BR | Truck | 124 | TOL | CIP |  | 1230TruckSAD2000TOLCIP | 1230 | CR | BR | Truck | 124 | TOL | CIP
1006TruckSADNLVCIP | 1006 | MJ | AB US | Truck | 123 | NLV | CIP |  | 1006TruckSADNLVCIP | 1006 | MJ | AB US | Truck | 123 | NLV | CIP
1021RailSADWYPCIP | 1021 | MJ | A G | Rail | 123 | WYP | CIP |  | 1021RailSADWYPCIP | 1021 | MJ | A G | Rail | 123 | WYP | CIP
1023RailSADWYPCIP | 1023 | MJ | A G | Rail | 123 | WYP | CIP |  | 1023RailSADWYPCIP | 1023 | MJ | A G | Rail | 123 | WYP | CIP
1023TruckSADTOLCIP | 1023 | MJ | A G | Truck | 123 | TOL | CIP |  | 1023TruckSADTOLCIP | 1023 | MJ | A G | Truck | 123 | TOL | CIP
1024RailSADWYPCIP | 1024 | MJ | A G | Rail | 123 | WYP | CIP |  | 1024RailSADWYPCIP | 1024 | MJ | A G | Rail | 123 | WYP | CIP
1070RailSADWYPCIP | 1070 | MJ | Ar G | Rail | 123 | WYP | CIP |  | 1070RailSADWYPCIP | 1070 | MJ | Ar G | Rail | 123 | WYP | CIP
2047RailSADWYPDAP | 1000 | EE | ST G Mexico | Rail | 123 | XYZ | DAP |  | 2047RailSADWYPDAP | 1000 | EE | ST G Mexico | Rail | 123 | XYZ | DAP
2091RailSADWYPDAP | 1001 | EE | Content | Rail | 123 | XYZ | DAP |  | 2091RailSADWYPDAP | 1001 | EE | Content | Rail | 123 | XYZ | DAP
2046RailSADWYPDAP | 1002 | EE | St G | Rail | 123 | XYZ | DAP |  | 2046RailSADWYPDAP | 1002 | EE | St G | Rail | 123 | XYZ | DAP
Spreadsheet: 878168d1725197269-help-with-filter-formula-usd-payments
Sheet: USD Payments

I respectfully request an Excel formula to filter the US$ and Cash - US$ Bank transactions from the Transactions sheet, while excluding transactions associated with Group Code "D10".
The specified columns for extraction are Date, Bank, Account, Group Code, Reference, USD Debit, and USD Credit. Thank you for your assistance.
Date | Bank | Account | Group Code | Reference | USD Debit | USD Credit |  |  | US$ | Fees | C1 | 16802 | 0 | 200
 | US$ | Fees | C1 | 16802 | 0 | 200 |  | 2024-01-30 00:00:00 | US$ | Fees | C1 | 16803 | 0 | 200
2024-01-30 00:00:00 | US$ | Fees | C1 | 16803 | 0 | 200 |  | 2024-01-31 00:00:00 | US$ | Vehicle Maintenance | P1 | 2161 | 80 | 0
2024-01-31 00:00:00 | US$ | Vehicle Maintenance | P1 | 2161 | 80 | 0 |  | 2024-01-31 00:00:00 | US$ | Sundry Expenses | P1 | 2173 | 50 | 0
2024-01-31 00:00:00 | US$ | Sundry Expenses | P1 | 2173 | 50 | 0 |  | 2024-01-31 00:00:00 | Cash - US$ | Fees | C1 | 16642 | 0 | 20
2024-01-31 00:00:00 | Cash - US$ | Fees | C1 | 16642 | 0 | 20 |  | 2024-02-01 00:00:00 | Cash - US$ | Feeding Programme | P1 | 2160 | 4 | 0
2024-02-01 00:00:00 | Cash - US$ | Feeding Programme | P1 | 2160 | 4 | 0 |  | 2024-02-06 00:00:00 | Cash - US$ | Vehicle Maintenance | P1 | 2168 | 1 | 0
2024-02-06 00:00:00 | Cash - US$ | Vehicle Maintenance | P1 | 2168 | 1 | 0 |  | 2024-02-08 00:00:00 | US$ | Salaries & Wages | P2 | 2178 | 833 | 0
2024-02-08 00:00:00 | US$ | Salaries & Wages | P2 | 2178 | 833 | 0 |  | 2024-02-09 00:00:00 | US$ | Feeding Programme | P1 | 2181 | 100 | 0
2024-02-09 00:00:00 | US$ | Feeding Programme | P1 | 2181 | 100 | 0
Spreadsheet: 836654d1689565491-automatic-fill-in-daily-plant-data-collection-in-different-sheets-project-plant-data-collection
Sheet: Example

Date | 3.Jul.2023 | Humidity | 0.5 | Temperature | 50 | Weather | Rainy | Time | 8.30 am |  | Submit button |  | Clear button
Treatments | Plant samples | Height | Leaf Length | Leaf Width | Number of Leaf
B10F0 | 1 | 5.94 | 2.1 | 2.6 | 5
B10F0 | 2 | 5.54 | 3 | 2.4 | 4
B10F0 | 3 | 5.54 | 3.1 | 2.6 | 4
B10F0 | 4 | 5.49 | 2.7 | 2.6 | 5
B10F0 | 5 | 5.3 | 2.2 | 2.7 | 5
B10F0 | 6 | 5.52 | 2.6 | 2.4 | 5
B10F0 | 7 | 5.63 | 2.6 | 2.8 | 5
B10F0 | 8 | 5.23 | 3.2 | 2.1 | 5
B10F0 | 9 | 5.56 | 2.3 | 2.4 | 4
B9F1 | 1 | 5.37 | 2.8 | 2.2 | 5
B9F1 | 2 | 5.64 | 2.4 | 2.4 | 4
B9F1 | 3 | 5.72 | 2.6 | 2.6 | 5
B9F1 | 4 | 5.7 | 2.6 | 2.3 | 4
B9F1 | 5 | 5.36 | 3.2 | 2.1 | 5
B9F1 | 6 | 5.33 | 2.5 | 2.4 | 5
B9F1 | 7 | 5.49 | 2.6 | 2.7 | 4
B9F1 | 8 | 5.78 | 2.2 | 2.6 | 5
B9F1 | 9 | 5.87 | 2.6 | 2.3 | 5
B8F2 | 1 | 5.52 | 3.1 | 2.1 | 4
B8F2 | 2 | 5.87 | 3.2 | 2.1 | 4
B8F2 | 3 | 5.24 | 2.6 | 2.3 | 5
B8F2 | 4 | 5.55 | 3.1 | 2.3 | 4
B8F2 | 5 | 5.52 | 2.4 | 2.8 | 5
B8F2 | 6 | 5.67 | 2.1 | 2.7 | 4
B8F2 | 7 | 5.41 | 3 | 2.4 | 5
B8F2 | 8 | 5.68 | 2.9 | 2.7 | 4
B8F2 | 9 | 5.66 | 3.2 | 2.3 | 5
B7F3 | 1 | 5.94 | 2.2 | 2.4 | 5
B7F3 | 2 | 5.8 | 2.3 | 2.7 | 5
B7F3 | 3 | 5.65 | 2.7 | 2.8 | 5
B7F3 | 4 | 5.99 | 2.6 | 2.4 | 5
B7F3 | 5 | 5.76 | 2.7 | 2.8 | 4
B7F3 | 6 | 5.32 | 3 | 2.8 | 4
B7F3 | 7 | 5.56 | 2.9 | 2.8 | 4
B7F3 | 8 | 5.56 | 2.2 | 2.4 | 5
B7F3 | 9 | 5.66 | 2.1 | 2.2 | 5
B6F4 | 1 | 5.83 | 3.2 | 2.2 | 5
B6F4 | 2 | 5.6 | 3.1 | 2.3 | 4
B6F4 | 3 | 5.68 | 3.1 | 2.2 | 4
B6F4 | 4 | 5.65 | 2.7 | 2.3 | 5
B6F4 | 5 | 5.92 | 2.6 | 2.6 | 5
B6F4 | 6 | 5.47 | 2.2 | 2.1 | 4
B6F4 | 7 | 5.84 | 2.8 | 2.3 | 5
B6F4 | 8 | 5.52 | 2.7 | 2.3 | 4
B6F4 | 9 | 5.23 | 2.7 | 2.7 | 5
B0F10 | 1 | 5.34 | 3 | 2.3 | 5
B0F10 | 2 | 5.27 | 2.9 | 2.7 | 5
B0F10 | 3 | 5.31 | 2.5 | 2.5 | 5
B0F10 | 4 | 5.96 | 2.9 | 2.1 | 5
B0F10 | 5 | 5.77 | 2.3 | 2.5 | 5
B0F10 | 6 | 5.23 | 2.6 | 2.2 | 5
B0F10 | 7 | 5.83 | 2.1 | 2.2 | 5
B0F10 | 8 | 5.25 | 2.5 | 2.3 | 5
B0F10 | 9 | 5.41 | 3.1 | 2.2 | 4
Spreadsheet: 274619d1383162737-mapping-data-to-different-spreadsheets-amanda_reply
Sheet: Submitted

Submitted
Current Status | Date | Last Name | Lender Name | Type of Loan | [NAME] | Purpose | Prop Type | Title Company | Loan Officer | Loan Amount | Processor | Notes |  | Match (All data Row)
Spreadsheet: 38680d1236817833-pull-data-from-two-other-worksheet-per-condition-auction-09-00
Sheet: Form-01

 |  |  |  | 2009 Auction
 |  | [NAME]
 |  | Name
 |  | Address |  | automatically fill in based on pick from E5
 |  | Phone |  | automatically fill in based on pick from E5
 |  | Mobile |  | automatically fill in based on pick from E5
 |  | email |  | automatically fill in based on pick from E5
 |  | Item purchase |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | automatically fill in description from 'Auction Items' worksheet with ID associated with name picked in E5 | winning bid
 |  |  |  | Total: | 0
 |  |  |  | Thank You For Your Support!
Spreadsheet: mark_taylor__24791__Development Checklist
Sheet: Other

 |  | Done |  | Responsibility | Resources | Date | Status Notes
Connectivity
AT&T Line Install |  |  |  | [NAME] | [NAME] | 2000-10-05 00:00:00 | Preliminary work to be done week of 8/5/00. Updated timeframe requested from Anchi.
Additional Line Install |  |  |  | [NAME] | [NAME]/[NAME] | 2000-10-05 00:00:00 | Initial results not showing a conclusive winner. Additional information being gathered by HelpDesk. Awaiting Results.
Direct Lines
 | Espeed? |  |  | [NAME]
 | Reuters?
 | EBS |  |  |  | [NAME]
Spreadsheet: 857963d1706794205-three-way-lookup-with-merged-cell-reference-threeway-lookup-with-merged-cell
Sheet: Result

 |  |  |  |  |  | Tya, [NAME] |  |  | McDonald, Pllie |  |  | Mindop, Nathan
 |  |  |  |  |  | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time
 | Non-productive Time |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
99900032-001 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
99900004-001 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
99900011-001 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
99900024-001 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
99900014-001 |  |  |  |  |  | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0
99900015-001 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Work Order No. | Office | Name | PM | Mult | Project/Prospect | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
60051669-B1M |  |  |  |  |  | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0
60051669-B3M |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
60051669-BIM |  |  |  |  |  | 0 | 1.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0
60062368-C2B |  |  |  |  |  | 0 | 0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0
60063229-115 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
60063229-921 |  |  |  |  |  | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 4 | 0
60061616-290 |  |  |  |  |  | 0 | 0.25 | 0 | 0 | 2 | 0 | 0 | 5 | 0
Spreadsheet: 678893d1590102161-sorting-random-integers-in-descending-order-and-identifying-the-row-with-each-sorted-value-problem
Sheet: Problem Focus

Metric |  | Metric Rank | Row # | Hidden 'helper column'
24
12
12
8
20
20
8
20
20
20
10
20
4
10
32
32
20
8
20
4
8
20
8
8
20
4
10
6
10
6
6
6
6
30
50
10
20
8
20
4
30
50
20
8
20
4
32
10
20
8
20
4
12
3
20
8
8
20
4
75
50
50
50
50
15
15
15
20
20 |  |  |  | 22
Spreadsheet: 876930d1723641366-ignore-error-and-count-the-values-sample-data-for-error
Sheet: Sheet1

Year1 | Year2 | Year3 | Count Function | Output
#N/A | 2 | 3 |  | 2
1 | #N/A | 4 |  | 2
1 | 5 | 4 |  | 2
3 | #N/A | #N/A |  | 1
#N/A | 2 | 3 |  | 2
Spreadsheet: 748735d1632319356-work-out-daily-amount-to-target-31-day-figures
Sheet: 29th

 |  |  |  | TURNOVER |  |  |  |  | REVENUE
 | AREA 3 |  |  | Target | Needed Daily | Actual | [NAME] |  | Target | Needed Daily | Actual | [NAME] |  | [NAME]'s | ATV |  | [NAME] | SALT £ |  | TMC |  | BB+ |  | Errors
 | Asda - Aintree
 | Asda - Huyton
 | Asda - Hunts Cross
 | Asda - Horwich
 | Asda - Leigh
 | Asda - Burnley
 | Asda - Westbrook
 | Asda - Widnes
 | Asda - Bromborough
 | Asda - Accrington
 | Asda - Colne
 | Asda - Clayton Green
 | Asda - Runcorn
 | Asda - Blackburn
 | Asda - Walton
 | Asda - Blackpool
 | Asda - Wigan
 | Asda - Preston
Spreadsheet: 469954d1468260425-error-when-trying-to-create-a-related-formula-book1
Sheet: Sheet1

 | Customer | Category |  |  | Customer
 | 1 | 2011-01-01 00:00:00 |  |  | 1
 | 1 | 2011-01-01 00:00:00 |  |  | 2
 | 2 | 2012-01-01 00:00:00 |  |  | 3
 | 2 | 2012-01-01 00:00:00 |  |  | 4
 | 3 | 2013-01-03 00:00:00 |  |  | 5
 | 3 | 2013-01-03 00:00:00 |  |  | 6
 | 4 | 2013-01-04 00:00:00
 | 4 | 2013-01-04 00:00:00
 | 4 | 2013-01-04 00:00:00
 | 5 | 2016-01-06 00:00:00
 | 5 | 2016-01-06 00:00:00
 | 5 | 2016-01-06 00:00:00
 | 6 | 2016-01-08 00:00:00
 | 6 | 2016-01-08 00:00:00
Spreadsheet: 54612d1254655055-excel-accounting-help-pm-tracking
Sheet: Inventory List

Stock ID | Name | Purchase Price | Reorder Level | Qty Purchased | [NAME] | Stock On Hand (SOH) | Reorder ? | Discontinued ?
[NAME] | 50mm x 35mm Keyring |  | 15 | 202 | 100 | 102 | No
KR-57x22 | 57mm x 22mm Keyring |  |  | 0 | 0 | 0 | No
KR-34S | 34mm Square Keyring |  |  | 0 | 0 | 0 | No
KR-34R | 34mm Round Keyring |  |  | 0 | 0 | 0 | No
KR-45S | 45mm Square Keyring |  |  | 0 | 0 | 0 | No
KR-45R | 45mm Round Keyring |  |  | 0 | 0 | 0 | No
PG-Heart | Heart Photo Globe |  | 1 | 6 | 3 | 3 | No
PG-Snow | Snow Photo Globe |  | 1 | 52 | 48 | 4 | No
PG-Glitter | Glitter Photo Globe |  | 1 | 6 | 3 | 3 | No
MUG-Glass-Stein | [NAME] Beer Stein |  | 1 | 2 | 2 | 0 | No | Yes
KR-BOB | Black Bottle Opener Keyring |  | 2 | 8 | 1 | 7 | No
DC-90S | 90mm Square Acrylic Drink Coaster |  | 2 | 42 | 37 | 5 | No
MP-DIY | Do It Yourself Mousepad |  | 5 | 49 | 29 | 20 | No
MP-Printed | Printed Mousepad |  | 5 | 10 | 6 | 4 | Yes
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
 |  |  |  | 0 | 0 | 0 | No
Spreadsheet: 685828d1594215826-needing-help-with-find-and-add-between-dates-type-formulas-2020-07-08-oeldere-prof-sick-685823d1594214511-needing-help-with-find-and-add-between-dates-
Sheet: Sheet2

 |  |  |  |  |  |  |  |  | Today
Date | Equipment # | Hours | Gallons | use Hours | use Gallons | Month | DAY |  | Past Days in Period |  | 40
2020-05-25 00:00:00 | 17 | 5640 | 24
2020-06-03 00:00:00 | 17 | 5700 | 27 |  |  |  |  |  | Equipment # |  | 45
2020-06-12 00:00:00 | 17 | 5757 | 35
2020-06-18 00:00:00 | 17 | 5805 | 14 |  |  |  |  |  | Beginning Date |  | 2020-06-01 00:00:00
2020-06-22 00:00:00 | 17 | 5834 | 30 |  |  |  |  |  | Hours on Beginning Date day |  | 12800
2020-06-29 00:00:00 | 17 | 5867 | 32 |  |  |  |  |  | Gallons on Beginning day |  | 60
2020-07-01 00:00:00 | 17 | 5890 | 27
2020-07-03 00:00:00 | 17 | 5903 | 24
2020-07-06 00:00:00 | 17 | 5922 | 27.5
2020-05-03 00:00:00 | 32 | 7500 | 34 |  |  |  |  |  | Ending Date |  | 2020-07-03 00:00:00
2020-05-17 00:00:00 | 32 | 7645 | 45 |  |  |  |  |  | Hours on ending day |  | 13375
2020-05-31 00:00:00 | 32 | 7700 | 61
2020-06-05 00:00:00 | 32 | 7731 | 34
2020-06-12 00:00:00 | 32 | 7789 | 29 |  |  |  |  |  | Total Gallons |  | 518
2020-06-18 00:00:00 | 32 | 7812 | 15
2020-06-24 00:00:00 | 32 | 7869 | 60
2020-07-02 00:00:00 | 32 | 7900 | 59
2020-07-05 00:00:00 | 32 | 7960 | 45
2020-05-10 00:00:00 | 45 | 12540 | 50 |  |  |  |  |  |  | Inputs=>
2020-05-17 00:00:00 | 45 | 12600 | 75
2020-05-24 00:00:00 | 45 | 12702 | 60
2020-06-01 00:00:00 | 45 | 12800 | 55
2020-06-07 00:00:00 | 45 | 12900 | 47
2020-06-12 00:00:00 | 45 | 13134 | 60
2020-06-18 00:00:00 | 45 | 13200 | 78
2020-06-24 00:00:00 | 45 | 13264 | 59
2020-07-01 00:00:00 | 45 | 13307 | 34
2020-07-03 00:00:00 | 45 | 13375 | 65
Rijlabels | Som van use Hours | Som van Gallons
17 | 282 | 240.5
5 | 0 | 24
6 | 227 | 138
7 | 55 | 78.5
32 | 460 | 382
5 | 200 | 140
6 | 169 | 138
7 | 91 | 104
45 | 835 | 583
5 | 162 | 185
6 | 562 | 299
7 | 111 | 99
Eindtotaal | 1577 | 1205.5
Spreadsheet: 758436d1638878144-count-duplicate-sets-of-2-numbers-test-01
Sheet: Sheet1

a | b | c | d | e | f | g | Duplicate same sets | Comment
8 | 8 | 3 | 7 | 3 | 7 | 7 | 2 | 37 & # 37 is a same duplicate
2 | 0 | 2 | 6 | 1 | 0 | 2 | 2 | 02 & 02 is the same duplicate
4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 44 & 44 & 44 is the same duplicate
8 | 2 | 8 | 2 | 8 | 2 | 3 | 2 | 82 & 82 & 82 is the same duplicate
1 | 1 | 2 | 2 | 0 | 0 | 1 | 0 | because the sets are not same
3 | 0 | 2 | 4 | 8 | 1 | 9 | 0 | no duplicate sets
Spreadsheet: 817458d1676249894-negative-amount-and-summation-issue-2023-commission-for-designers-sample
Sheet: Data and Calcs

Sales Total | January | February | March | April | May | June | July | August | September | October | November | December |  | Sales | Bonus | Class |  | Sales | Bonus | Class |  | Sales | Bonus | Class
[NAME] | 39000 | 50000 | 20000 | 70000 |  |  |  |  |  |  |  |  |  | 20000 | 200 | Quick |  | 40000 | 500 | Custom |  | 70000 | 1500 | National
Emily | 43117.15 |  |  |  |  |  |  |  |  |  |  |  |  | 25000 | 350 | Quick |  | 50000 | 750 | Custom |  | 80000 | 2000 | National
[NAME] | 41086.74 |  |  |  |  |  |  |  |  |  |  |  |  | 30000 | 500 | Quick |  | 60000 | 1000 | Custom |  | 90000 | 2500 | National
JJ | 42705.97 |  |  |  |  |  |  |  |  |  |  |  |  | 35000 | 650 | Quick |  | 70000 | 1500 | Custom |  | 100000 | 3000 | National
[NAME] | 25668.03 |  |  |  |  |  |  |  |  |  |  |  |  | 40000 | 800 | Quick |  | 80000 | 2000 | Custom |  | 110000 | 3500 | National
Shawnee | 23658.52 |  |  |  |  |  |  |  |  |  |  |  |  | 45000 | 1000 | Quick |  | 90000 | 2500 | Custom |  | 120000 | 4000 | National
Travis | 25735.94 |  |  |  |  |  |  |  |  |  |  |  |  | 50000 | 1250 | Quick |  | 100000 | 3000 | Custom |  | 130000 | 4500 | National
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 55000 | 1500 | Quick |  | 110000 | 3500 | Custom |  | 140000 | 5000 | National
D&L Total | January | February | March | April | May | June | July | August | September | October | November | December |  | 60000 | 1750 | Quick |  | 120000 | 4000 | Custom |  | 150000 | 5500 | National
[NAME] | 400 |  | 1000 |  |  |  |  |  |  |  |  |  |  | 65000 | 2000 | Quick |  | 130000 | 4500 | Custom |  | 160000 | 6000 | National
Emily | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 70000 | 2250 | Quick |  | 140000 | 5000 | Custom |  | 170000 | 6500 | National
[NAME] | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 75000 | 2500 | Quick |  | 150000 | 5500 | Custom |  | 180000 | 7000 | National
JJ | 52.5 |  |  |  |  |  |  |  |  |  |  |  |  | 80000 | 2750 | Quick |  | 160000 | 6000 | Custom |  | 190000 | 8000 | National
[NAME] | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 85000 | 3000 | Quick |  | 170000 | 6500 | Custom |  | 200000 | 8500 | National
Shawnee | 382.76
Travis | 142
Open Invoice | January | February | March | April | May | June | July | August | September | October | November | December
[NAME]
Emily
[NAME]
JJ
[NAME]
Shawnee
Travis
Spreadsheet: 883845d1732584958-conditional-formatting-for-due-dates-eabaker64-sample2-tms
Sheet: Using Second Formula

List created | List sent | First | Second | Holidays |  |  |  | Second Formula
2024-09-20 00:00:00 | 2024-09-24 00:00:00 |  |  | 2024-07-04 00:00:00 |  | Green |  | =AND(A2<=TODAY(),NETWORKDAYS.INTL(A2,IF(B2="",TODAY(),B2),,$E$2:$E$7)<=3)
2024-10-11 00:00:00 |  |  |  | 2024-09-02 00:00:00 |  | Red |  | =AND(A2<=TODAY(),NETWORKDAYS.INTL(A2,IF(B2="",TODAY(),B2),,$E$2:$E$7)>3)
2024-11-14 00:00:00 | 2024-11-20 00:00:00 |  |  | 2024-10-14 00:00:00
2024-11-20 00:00:00 |  |  |  | 2024-11-11 00:00:00
2024-11-21 00:00:00 |  |  |  | 2024-11-28 00:00:00
2024-12-22 00:00:00 |  |  |  | 2024-12-25 00:00:00
Spreadsheet: 273489d1382725151-change-date-into-text-if-today-and-adding-text-if-cell-isblank-into-an-array-help-x-
Sheet: Certificate Database

DISCIPLINE | EMPLOYEE ID | EMPLOYEE | COURSE | Other Information | EXPIRES ON | LINK
AA | 2099 | [NAME] | ARGO - Manufacture |  | 2013-03-27 00:00:00
BB | 5049 | [NAME] | ATV |  | 2000-09-08 00:00:00
AA | 2099 | [NAME] | ATV |  | 2014-04-26 00:00:00 | 2014-04-26 00:00:00
AA | 2099 | [NAME] | Defensive Driving |  | 2013-05-05 00:00:00 | 2013-05-05 00:00:00
AA | 2099 | [NAME] | Defensive Driving |  | 2015-08-28 00:00:00 | 2015-08-28 00:00:00
BB | 5049 | [NAME] | Trailering |  | 1999-02-15 00:00:00 | 1999-02-15 00:00:00
BB | 5049 | [NAME] | Trailering |  | 2007-03-10 00:00:00 | 2007-03-10 00:00:00
AA | 2099 | [NAME] | UTV |  | 2016-04-28 00:00:00 | 2016-04-28 00:00:00
BB | 5049 | [NAME] | WHMIS |  | No Exp | No Exp
AA | 2099 | [NAME] | WHMIS |  | No Exp