tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 857594d1706568536-textjoin-multiple-criteria-with-data-in-rows-between-date-range-book1
Sheet: Sheet1

TASK NAME | START | FINISH |  | Calendar | Tasks
Example 1 | 2024-04-29 00:00:00 | 2024-05-11 00:00:00 |  | 2024-04-29 00:00:00
Example 2 | 2024-05-03 00:00:00 | 2024-05-04 00:00:00
Example 3 | 2024-05-06 00:00:00 | 2024-05-13 00:00:00
Example 4 | 2024-05-13 00:00:00 | 2024-05-13 00:00:00
Example 5 | 2024-05-13 00:00:00 | 2024-05-31 00:00:00
Example 6 | 2024-05-15 00:00:00 | 2024-05-15 00:00:00
Example 7 | 2024-06-01 00:00:00 | 2024-06-01 00:00:00
Example 8 | 2024-05-27 00:00:00 | 2024-05-27 00:00:00
Example 9 | 2024-06-01 00:00:00 | 2024-06-01 00:00:00
Example 10 | 2024-05-28 00:00:00 | 2024-05-30 00:00:00
Example 11 | 2024-05-31 00:00:00 | 2024-06-08 00:00:00
Example 12 | 2024-06-10 00:00:00 | 2024-06-15 00:00:00
Example 13 | 2024-05-21 00:00:00 | 2024-05-21 00:00:00
Example 14 | 2024-05-22 00:00:00 | 2024-05-22 00:00:00
Example 15 | 2024-05-23 00:00:00 | 2024-05-29 00:00:00
Example 16 | 2024-05-29 00:00:00 | 2024-05-29 00:00:00
Example 17 | 2024-05-29 00:00:00 | 2024-05-29 00:00:00
Example 18 | 2024-05-30 00:00:00 | 2024-06-01 00:00:00
Example 19 | 2024-05-31 00:00:00 | 2024-05-31 00:00:00
Example 20 | 2024-05-31 00:00:00 | 2024-05-31 00:00:00
Example 21 | 2024-05-29 00:00:00 | 2024-05-29 00:00:00
Example 22 | 2024-05-30 00:00:00 | 2024-05-30 00:00:00
Example 23 | 2024-05-29 00:00:00 | 2024-05-29 00:00:00
Example 24 | 2024-05-30 00:00:00 | 2024-05-31 00:00:00
Example 25 | 2024-05-31 00:00:00 | 2024-05-31 00:00:00
Example 26 | 2024-05-23 00:00:00 | 2024-05-23 00:00:00
Example 27 | 2024-05-30 00:00:00 | 2024-05-30 00:00:00
Example 28 | 2024-05-27 00:00:00 | 2024-05-27 00:00:00
Example 29 | 2024-05-28 00:00:00 | 2024-05-28 00:00:00
Example 30 | 2024-05-29 00:00:00 | 2024-05-29 00:00:00
Example 31 | 2024-05-30 00:00:00 | 2024-05-31 00:00:00
Example 32 | 2024-05-25 00:00:00 | 2024-05-25 00:00:00
Example 33 | 2024-05-30 00:00:00 | 2024-05-30 00:00:00
Spreadsheet: 184415d1349260355-automatic-look-up-and-substracting-if-found-match-actual-shorts
Sheet: Sheet1

 | MW
 | Shorts |  | Pick overs |  | Driver overs |  | Actual [NAME]
 | Item | Quantity | Item | Quantity | Item | Quantity | Item | Quantity
 | 222 | 2 | 222 | 1 | 321 | 4 | 222 | 1 | 1
 | 321 | 4 | 555 | 5 | 4569 | 2 | 321 | 0 | 0
 | 4278 | 3 | 4528 | 3 | 555 | 1 | 4278 | 3 | 3
 | 17512 | 1 |  |  |  |  | 17512 | 1 | 1
 | 555 | 5 |  |  |  |  | 555 | 0 | -1
 | 4569 | 6 |  |  |  |  | 4569 | 4 | 4
 | 12789 | 12 |  |  |  |  | 12789 | 12 | 12
 | 4528 | 3 |  |  |  |  | 4528 | 0 | 0
Spreadsheet: 802244d1666719796-calculate-numbers-backwards-from-total-sum-value-book4
Sheet: Solution

Position | Quantity | Price | Total Sum |  | Variable cell | Final price
Position 1 | 13 | 3.02 |  |  | 0
Position 2 | 22 | 3.039 |  |  | 0
Position 3 | 14 | 3.02 |  |  | 0
Position 4 | 23 | 3.039 |  |  | 0
Position 5 | 10 | 3.02 |  |  | 0
Position 6 | 18 | 3.039 |  |  | 0
Position 7 | 6 | 3.02 |  |  | 0
Position 8 | 5 | 3.039 |  |  | 0
Position 9 | 5 | 3.02 |  |  | 0
Position 10 | 19 | 3.039 |  |  | 0
Position 11 | 16 | 3.02 |  |  | 0
Position 12 | 8 | 3.039 |  |  | 0
Position 13 | 20 | 3.02 |  |  | 0
Position 14 | 20 | 3.039 |  |  | 0
Position 15 | 10 | 3.02 |  |  | 0
Position 16 | 25 | 3.039 |  |  | 0
Position 17 | 37 | 3.63 |  |  | 0
Position 18 | 37 | 3.63 |  |  | 0
Position 19 | 4090 | 0.133 |  |  | 0
Position 20 | 3960 | 0.133 |  |  | 0
Position 21 | 3800 | 0.133 |  |  | 0
Position 22 | 4630 | 0.133 |  |  | 0
Position 23 | 4410 | 0.083 |  |  | 0
Position 24 | 4360 | 0.083 |  |  | 0
Position 25 | 3820 | 0.083 |  |  | 0
Position 26 | 4160 | 0.083 |  |  | 0
Position 27 | 3520 | 0.163 |  |  | 0
Position 28 | 4430 | 0.163 |  |  | 0
Position 29 | 4160 | 0.351 |  |  | 0
Position 30 | 4840 | 0.351 |  |  | 0
Position 31 | 3940 | 0.351 |  |  | 0
Position 32 | 4920 | 0.351 |  |  | 0
Position 33 | 4810 | 0.429 |  |  | 0
Position 34 | 3940 | 0.429 |  |  | 0
Position 35 | 4480 | 0.534 |  |  | 0
Position 36 | 4710 | 0.534 |  |  | 0
Position 37 | 4250 | 0.534 |  |  | 0
Position 38 | 4520 | 0.656 |  |  | 0
Position 39 | 4390 | 0.656 |  |  | 0
Position 40 | 3730 | 0.229 |  |  | 0
Position 41 | 3500 | 0.229 |  |  | 0
 |  |  | Initial Grand total sum |  |  | Target | 30662.13