tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 745774d1630186963-please-help-beginner-with-a-20-number-problem-20-numbers-need-help
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Matches | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Check for these numbers | 1 | 2 |  |  | 5 |  | 7 | 8 |  | 10 |  |  |  | 14 |  |  | 17 | 18 |  | 20
1st place to check | 1 | 2 |  | 4 |  | 6 |  |  |  | 10 | 11 | 12 |  | 14 |  | 16 |  |  | 19 |  | 4 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
2nd place to check | 1 |  | 3 |  |  | 6 | 7 | 8 | 9 |  | 11 |  |  |  | 15 | 16 |  | 18 |  |  | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
3rd place to check |  |  |  |  | 5 |  | 7 | 8 | 9 | 10 | 11 |  |  | 14 |  |  | 17 | 18 | 19 |  | 7 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0
4th place to check |  | 2 |  | 4 |  | 6 |  | 8 | 9 |  |  |  |  | 14 |  |  | 17 | 18 | 19 | 20 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 1
5th place to check |  | 2 | 3 |  |  | 6 | 7 |  |  | 10 |  |  | 13 | 14 |  |  |  | 18 | 19 | 20 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1
Spreadsheet: 678907d1590112314-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example-sammyghr-
Sheet: 11 May 20 - 16 May 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-05-11 00:00:00 | 2020-05-12 00:00:00 | 2020-05-13 00:00:00 | 2020-05-14 00:00:00 | 2020-05-15 00:00:00 | 2020-05-16 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 11/05/2020 - 16/05/2020
Dameon | AWAY | AWAY | AWAY | AWAY | ✓ |  |  |  |  | Dameon | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | AWAY | ✓ | ✓ | ✓ |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | ✓ | [NAME] |  |  |  |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | [NAME] | ✓ | ✓ |  |  |  |  | [NAME] | ✓
Nathan | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  | Nathan | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  | [NAME] | N/A
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
Tyson | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  | Tyson | ✓
Will | ✓ | ✓ | ✓ | AWAY | AWAY |  |  |  |  | Will | ✓
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | ` | ✓ | AWAY | No | No |  |  |  |  |  | ❌
 | ✓ | ✓ | [NAME] | ✓ | ✓ |  |  |  |  |  | ❌
Edge Protection [NAME] |  |  | 11/05/2020 - 16/05/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 11/05/2020 - 16/05/2020
Laminex |  |  | ✓ |  |  |  |  |  |  | Dameon | ✓
Wilson |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
Canterbury Linen Services |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
Rangiora Borough |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Harley | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
Incidents/Accidents/Near Misses - Site |  |  | Type |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Nathan | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | N/A
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ❌
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ❌
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  |  | ✓
❌   Means did not get one at all
Spreadsheet: 93656d1293327161-last-data-range-cell-update-something-like-this2
Sheet: Sheet1

45 | 2 |  |  |  |  | group>>> | 2 | 5 | 6 | 7
67 | 2 |  |  |  |  |  | 45 | 87 | 123 | 234
87 | 5 |  |  |  |  |  | 67 | 43 | 565 | 127
43 | 5 |  |  |  |  |  | 124 | 98
98 | 5 |  |  |  |  |  | 879 | 453
124 | 2 |  |  |  |  |  | 908 | 236
453 | 5 |  |  |  |  |  | 345 | 1000
879 | 2
908 | 2
236 | 5
123 | 6
234 | 7
127 | 7
565 | 6
1000 | 5
345 | 2
Spreadsheet: 857758d1706684674-formula-not-recognizing-the-item-code-items-for-sale-aligw
Sheet: Inventory

Item Code | Description | Quantity | Unit Price | Notes
TW001 | Tumbler white
TW002 | Tumbler white
TB003 | Tumbler black
Spreadsheet: 747785d1631700474-how-to-find-and-count-uniques-in-a-table-giwi342-excel-count-ans
Sheet: Sheet1

ID | 03-A | 03-B | 03-C | 03-D | 03-E | 03-F | 03-G | 03-H | 03-I | 03-J | 03-K | 03-L | 03-M | 03-N | 03-O | 03-P | 04-A | 04-B | 04-C | 04-D
9 | 17.1 | 1 | 17.5 | 1 | 17.5 | 1 | 17.5 | 1 | 15.5 | 1 | 11.3 | 1 | 7.2 | 1 | 3.1 | 1 | 0 | 0 | 0 | 0
8 | 0.6 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0
7 | 13 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0
6 | 0.6 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 1.4 | 5.5 | 0
5 | 0 | 1.3 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 8.2 | 2 | 2 | 0
4 | 0 | 7.4 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 2
3 | 0 | 1.3 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 5.2 | 2 | 0 | 2
2 | 0 | 3.4 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0
1 | 0 | 1.3 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 1.1 | 1.1 | 0 | 1.1
 | Unique values | Counts
Spreadsheet: 95ce2f50-51c8-4b69-876d-a76617a277dc
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Brash Music | 881410004525 | The [NAME] | Ancient Skies | 2008-09-09 | Compact Disc | P & W | 13.99 | Y | Available
Brash Music | 881410005621 | The [NAME] | Beautiful Things | 2010-02-16 | Compact Disc | Praise | 13.99 | Y | Available
Brash Music | 881410007625 | Gungor | Ghosts Upon The Earth | 2011-09-20 | Compact Disc | Praise | 13.99 | Y | Available
Brash Music | 881410008721 | Gungor | Let There Be | 2013-10-22 | Music DVD | Ac | 14.99 | Y | Available
Brash Music | 881410008523 | Gungor | Creation Liturgy, A | 2012-10-16 | Compact Disc | Alt | 13.99 | Y | Available
Spreadsheet: 856617d1705814037-compare-planned-vs-actual-values-monthly-and-generate-a-table-20240121_o365_compare-planned-vs-actuals-excelforum-windknife
Sheet: Comparison

 | Activity | Month | Plan | Actual | Actual > Plan | [NAME] | Cumulative Variance | Actuals to cover Previous Months Backlog |  |  | Plan As of | 2023-03-01 00:00:00
 | Activity 1 | 2023-01-01 00:00:00 | 100 | 150 | 50 | 50 | 50 | 0 |  |  | Actual As of | 2023-05-30 00:00:00
 | Activity 1 | 2023-02-01 00:00:00 | 200 | 200 | 0 | 0 | 50 | 0
 | Activity 1 | 2023-03-01 00:00:00 | 300 | 600 | 300 | 300 | 350 | 0
 | Activity 2 | 2023-01-01 00:00:00 | 0 | 100 | 100 | 100 | 100 | 0
 | Activity 2 | 2023-02-01 00:00:00 | 200 | 0 | 0 | -200 | -100 | 0
 | Activity 2 | 2023-03-01 00:00:00 | 0 | 250 | 250 | 250 | 150 | 100
 | Activity 3 | 2023-03-01 00:00:00 | 200 | 0 | 0 | -200 | -200 | 0
 |  | 2023-01-01 00:00:00 | 100 | 150 | 50 | 50 | 50 | 0
 | Activity 1 | 2023-02-01 00:00:00 | 200 | 200 | 0 | 0 | 50 | 0
 | Activity 1 | 2023-03-01 00:00:00 | 300 | 600 | 300 | 300 | 350 | 0
 | Activity 2 | 2023-01-01 00:00:00 | 0 | 100 | 100 | 100 | 100 | 0
 | Activity 2 | 2023-02-01 00:00:00 | 200 | 0 | 0 | -200 | -100 | 0
 | Activity 2 | 2023-03-01 00:00:00 | 0 | 250 | 250 | 250 | 150 | 100 | This is correct.
 | Activity 3 | 2023-03-01 00:00:00 | 200 | 0 | 0 | -200 | -200 | 0 | Desired Result
 | Activity 3 | 2023-04-01 00:00:00 | 0 | 100 | 100 | 100 | -100 | 100 | 100 | As of Mar, there was a backlog of 200. From Apr actuals, 100 was used to cover this
 | Activity 3 | 2023-05-01 00:00:00 | 0 | 50 | 50 | 50 | -50 | 50 | 50 | As of Apr, there was a backlog of 100. From May actuals, 50 was used to cover this.
Spreadsheet: 139769d1328457578-excel-2007-help-with-if-or-lookup-function-book1
Sheet: Sheet1

Course | Number
Math | 14
English | 6
Science | 8
Science | 45
Art | 19 |  | Totals
Math | 9 |  | Math | Science | English | Art
Science | 5
English | 23
English | 7
Math | 65
Math | 8
Art | 22
Art | 43
Art | 91
Science | 15
English | 54
Science | 9
Science | 3
English | 44
Math | 18
Art | 2
Math | 36
Math
Science
English
Art
Spreadsheet: 226365d1365376373-how-do-i-take-a-two-digit-number-separate-the-two-digits-add-them-together-show-result-opc-code-algorythm
Sheet: Sheet1

 |  | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th
 | Number | 0 | 2 | 0 | 7 | 1 | 1 | 7 | 2 | 1
 | Algorythm | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2
 | Result
 | Check digit
 |  | The algorythm:
 |  | Starting with the leftmost digit, multiply each digit by a weighting factor. The weighting factor follows a repeating 212 pattern. The first digit is multiplied by 2, the second digit by 1, the third digit by 2, the fourth digit by 1, and so on.Using our sample barcode above, we start with the number 020711721
 |  | 0 * 2 = | 0
 |  | 2 * 1 = | 2
 |  | 0 * 2 = | 0
 |  | 7 * 1 = | 7
 |  | 1 * 2 = | 2
 |  | 1 * 1 = | 1
 |  | 7 * 2 = | 14
 |  | 2 * 1 = | 2
 |  | 1 * 2 = | 2
 |  | Now sum all of the products, treating 2-digit numbers as individual digits. In the above example, 14 would be treated as a 1 and a 4:
 |  | 0 + 2 + 0 + 7 + 2 + 1 + 1 + 4 + 2 + 2 = 21
 |  | Divide the result by 10; in this example, 21 divided by 10 = 2 with a remainder of 1. Subtract the remainder from 10 to obtain the check digit; in this case, 10 - 1 = 9. If the result is 10 (in the case of 10 - 0 = 10) change the result to 0.
Spreadsheet: andy_zipper__197__DYNEGY-ICE VOL May23
Sheet: Enron Activity - Dynegy Direct

DYNEGY DIRECT
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Note: Total Activity for Dynegy Direct is not available, therefore Enron's percentage can not be calculated
Enron North America - Dynegy Direct |  |  |  |  | Enron Power Marketing - Dynegy Direct |  |  |  |  | Enron Global Liquids - Dynegy Direct
 |  | Data |  |  |  |  | Data |  |  |  |  | Data
Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume
US Natural Gas | [NAME] | 2 | 10000 |  | (blank) | No Activity | 1 | #N/A |  | No Activity | No Activity | 1 | 0
 | [NAME] | 3 | 15000 |  | (blank) Total |  | 1 | #N/A |  | No Activity Total |  | 1 | 0
 | [NAME] | 1 | 5000 |  | Grand Total |  | 1 | #N/A |  | Grand Total |  | 1 | 0
US Natural Gas Total |  | 6 | 30000
Grand Total |  | 6 | 30000
Spreadsheet: 756135d1637301836-using-sumif-with-dynamic-arrays-to-sum-column-totals-horizontal-totalization-dj
Sheet: Inputs

 | General Assumptions
 | Timeline |  |  |  | Units | Assumption
 | Model Start Date |  |  |  | Date | 2020-07-01 00:00:00
 | Model Period (No. of months) |  |  |  | Months | 20
 | Latest Actuals period end date (i.e EOM) |  |  |  | Date | 2021-06-30 00:00:00
 | P&L Assumptions
 | P&L |  |  |  | Units | Assumption
 | Other revenue |  |  |  | $/Month | 0
 | Other direct costs |  |  |  | $/Month | 0
 | Bank Fees |  |  |  | $/Month | -10
 | Consulting & Accounting |  |  |  | $/Month | -20000
 | Legal expenses |  |  |  | $/Month | -450
 | Other income |  |  |  | $/Month | 0
 | Balance Sheet Assumptions
Spreadsheet: 863769d1711146890-formula-to-find-nth-value-based-on-multiple-criteria-with-duplicates-exp-report-solution-
Sheet: Sheet12

DATA |  |  |  |  | DESIRED RESULTS
SKU | QUANTITY | EXP DATE |  |  | SKU | Expiration 1 | Quantity 1 | Expiration 2 | Quantity 2 | Expiration 3 | Quantity 3 | Expiration 4 | Quantity 4
SKU1 | 34 | 2024-08-01 00:00:00 |  |  | SKU 1 | 2024-01-08 00:00:00 | 177 | 2024-01-09 00:00:00 | 1 | 23/9/2024 | 39 | 30/9/2024 | 104
SKU1 | 1 | 2024-08-01 00:00:00 |  |  | SKU 2 | 17/10/2024 | 827 | 19/10/2024 | 3950
SKU1 | 1 | 2024-08-01 00:00:00 |  |  | SKU 3 | 17/10/2024 | 5107 | 21/10/2024 | 5 | 25/10/2024 | 2073 | 26/10/2024 | 1
SKU1 | 1 | 2024-08-01 00:00:00
SKU1 | 1 | 2024-08-01 00:00:00 |  |  |  | Expiration1 | Quantity1 | Expiration2 | Quantity2 | Expiration3 | Quantity3 | Expiration4 | Quantity4
SKU1 | 1 | 2024-08-01 00:00:00 |  |  | SKU1 | 2024-08-01 00:00:00 | 177 | 2024-09-01 00:00:00 | 1 | 2024-09-23 00:00:00 | 39 | 2024-09-30 00:00:00 | 104
SKU1 | 1 | 2024-08-01 00:00:00 |  |  | SKU2 | 2024-10-17 00:00:00 | 827 | 2024-10-19 00:00:00 | 3950
SKU1 | 137 | 2024-08-01 00:00:00 |  |  | SKU3 | 2024-10-20 00:00:00 | 5107 | 2024-10-21 00:00:00 | 5 | 2024-10-25 00:00:00 | 2073 | 2024-10-26 00:00:00 | 1
SKU1 | 1 | 2024-09-01 00:00:00
SKU1 | 39 | 2024-09-23 00:00:00
SKU1 | 97 | 2024-09-30 00:00:00
SKU1 | 2 | 2024-09-30 00:00:00
SKU1 | 2 | 2024-09-30 00:00:00
SKU1 | 2 | 2024-09-30 00:00:00
SKU1 | 1 | 2024-09-30 00:00:00
SKU2 | 543 | 2024-10-17 00:00:00
SKU2 | 250 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 6 | 2024-10-17 00:00:00
SKU2 | 6 | 2024-10-17 00:00:00
SKU2 | 2 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 2 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 2 | 2024-10-17 00:00:00
SKU2 | 3 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 3950 | 2024-10-19 00:00:00
SKU3 | 1680 | 2024-10-20 00:00:00
SKU3 | 1759 | 2024-10-20 00:00:00
SKU3 | 1659 | 2024-10-20 00:00:00
SKU3 | 1 | 2024-10-20 00:00:00
SKU3 | 3 | 2024-10-20 00:00:00
SKU3 | 3 | 2024-10-20 00:00:00
SKU3 | 2 | 2024-10-20 00:00:00
SKU3 | 1 | 2024-10-21 00:00:00
SKU3 | 4 | 2024-10-21 00:00:00
SKU3 | 2071 | 2024-10-25 00:00:00
SKU3 | 2 | 2024-10-25 00:00:00
SKU3 | 1 | 2024-10-26 00:00:00
Spreadsheet: 160061d1338951995-count-of-style-in-a-range-of-sale-contribution-sales
Sheet: Sheet1

# of Sales | Sales $ |  | Total Sales |  | % | Count
1 | 10000 |  | 55000 |  | 0.2 | 1 | 0 - 20
1 | 9000 |  |  |  | 0.25 | 0 | 21 - 25
1 | 8000 |  |  |  | 0.5 | 2 | 26 - 50
1 | 7000 |  |  |  | 0.75 | 2 | 51 - 75
1 | 6000 |  |  |  | 0.9 | 2 | 76 - 90
1 | 5000 |  |  |  | 1 | 3 | 91 - 100
1 | 4000
1 | 3000
1 | 2000
1 | 1000
Spreadsheet: 783164d1654620372-conditional-formatting-based-on-a-list-eg-file
Sheet: Sheet1

 |  |  | data validation - indirect(C6) |  |  |  |  |  |  |  |  |  |  |  | For reference
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product | Min Price
 |  | Specified Product | Colour | Unit Price |  |  |  |  |  |  |  |  |  |  | Pen | 0.29
 |  | Pencil |  |  | << how do I get this to highlight red if lower than column Q? |  |  |  |  |  |  |  |  |  | Pencil | 0.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sharpener | 1
 |  | Sharpener | Red |  |  |  |  |  |  |  |  |  |  |  | Notepad | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Defined names in [NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pen | Pencil | Sharpener | Notepad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Red | HB | Yellow | Big
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blue | 2B | Red | Medium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pink |  | Green | Small
Spreadsheet: 103790d1301494174-adding-a-single-date-and-number-to-a-max-list-of-20-workbook33b
Sheet: Sheet1

 | 635 | Daily date and number entry - for holidays there won't be any updating.  Will that be a problem or will the coding just pickup the last entry and add to the col F & G list?
 | 629
 | 580
 | 078
 | 793
 | 750
 | 313
 | 420
 | 088
 | 529
 | 283
 | 529
 | 503
 | 442
 | 296
 | 997
 | 250
 | 727
 | 267
 | 173
Spreadsheet: 55524d1255628581-countif-or-vlookup-problem-dummy
Sheet: Sheet1

Employee | Status of Deal
[NAME] | Active-To-Date
[NAME] | Active-To-Date
Richelle | New
RJ | New
Ace | New
LA | Active-To-Date
Kris | New
Ecai | New
Saldy | Active-To-Date
[NAME] | Active-To-Date
[NAME] | New
Richelle | New
[NAME] | Active-To-Date
Ecai | New
Ecai | Active-To-Date
RJ | Active-To-Date
Saldy | New
Richelle | Active-To-Date
Richelle | New
[NAME] | New
RJ | New
Kris | New
Ace | New
Ecai | Active-To-Date
LA | Active-To-Date
LA | Active-To-Date
LA | Active-To-Date
Ace | Active-To-Date
Kris | New
 | Countif
New | 15
Active-to-date | 13
Spreadsheet: 882369d1730738632-strange-problem-microsoft-surface-7
Sheet: ZIII

Item | Cost |  | Flash | Amount | Where |  | Brand | Lens | [NAME] | Mount | [NAME] | Price | With Tax | Per Paycheck | Comment | Where
Z6III | 2496.95 |  | Godox V1 Pro | 329 | Comp |  | Nikon | 24-70 | 2.8 | Z | ED | 2400 |  |  | Use current F mount lens until can afford | Competitive
FTZII | 246.95 |  | Godox SU-1 [NAME] | 49 | Amazon |  | Nikon | 24-70 | 2.8 | F | ED | 2097 |  |  | Unk F or Z Betting it's an F Mount | Competitive
256G CF | 190 |  | PB-960 PROPAC | 120 | Amazon |  | Nikon | 70-200 | 2.8 | Z | ED | 2296 |  |  | Buy first. Need reach from current 24-120 | Competitive
256G SD | 129 |  | AK-R12 bounce | 11.9 | Amazon |  | Nikon | 70-200 | 2.8 | F | ED | 2347 |  |  | Buy first. Need reach from current 24-120 | Competitive
EN-EL15C Batteries | 207 |  | Total
Flash | 509.9
TotalSub
Tax
Total
Per Month
Per Paycheck
MB-N14 | 357
With Tax
Everything
Per Paycheck
Without Flash
Item | Cost
Z6III | 2496.95
FTZII | 246,95
256G CF | 190
256G SD | 129
EN-EL15C Batteries | 207
Sub
With Tax
Per Paycheck
Diff
Spreadsheet: 141084d1329079873-excel-2007-how-to-grab-information-from-other-sheets-and-place-it-in-the-main-sheet-fulllist
Sheet: Instructions

 |  | To submit entries electronically…
 |  |  | 1 | Copy the Entry Form file from floppy disk (or e-mail attachment)
 |  |  |  | onto your hard disk (or desktop) and use the copy as your working copy.
 |  |  |  | Keep the original "blank" Entry Form in its original state.
 |  |  |  | Do not use the original as your working copy.
 |  |  | 2 | Entries are accepted only in accordance with the information on the
 |  |  |  | printed Entry Forms
 |  |  | 3 | Information must be provided in every field.  Incomplete entries will not be processed.
 |  |  |  | Fields with a pull-down selection must be filled from the list provided.
 |  |  | 4 | Electronic entry may be made only once.  Any subsequent entries or
 |  |  |  | changes must be made in writing on the appropriate
 |  |  |  | Addition/Replacement forms.
 |  |  | 5 | If you add fields or change these forms, you must return it to its original form
 |  |  |  | so when the file is submitted it contains only the
 |  |  |  | original field names in their original order.
 |  |  | 6 | Return the disk to the Games office with the completed Cover Sheet and a printed
 |  |  |  | hard copy of your Entries.  Keep a copy for your records
 |  |  | 7 | Before proceeding enter your organisation's name here: | Lion
 |  |  | 8 | Do not enter data in all "capital" letters.
 |  |  |  | Capitalise the first letter, lower case the rest
Spreadsheet: 82f53e9e-fcfb-45e3-8624-a26869de5921
Sheet: Advanced

 | STAR Tutoring Form 2013-2014
 | Advanced Order Form
 | Mondo Publishing
 | [NAME] |  |  | [NAME]
 | [EMAIL] |  |  | [EMAIL]
 | Cell: (801) 913-0973 |  |  | Cell: (801) 573-4281
 | Fax: (801) 878-9949 |  |  | Fax: (801) 878-9949
 | www.benchmarkeducation.com |  |  | www.benchmarkeducation.com
Leveled Texts
ISBN Number | Description | Level | Book Quantity | Catalog Page | Price | Quantity | Total Price
54-288 | [NAME], Bookshop series | L-T | 50 | 74-76 | 370
54-295 | Grade 5 Classroom Library, Bookshop series | L-X | 50 | 77-79 | 385
Reading [NAME], Real-Life Reading
ISBN Number | Description | Level | Book Quantity | Catalog Page | Price | Quantity | Total Price
66-329 | Grade 4 Encyclofact Add-on Pack | O-T | 42 | 114-115 | 224
66-345 | Grade 4 Encyclofact Add-on Pack | O-T | 18 | 114-115 | 124
66-388 | Grade 4 Encyclofact Add-on Pack | O-T | 18 | 114-115 | 70
66-361 | Grade 4 Encyclofact Add-on Pack | O-T | 6 | 114-115 | 34
66-442 | Grade 5 Encyclofact Add-on Pack | R-W | 42 | 116-117 | 224
66-469 | Grade 5 Encyclofact Add-on Pack | R-W | 18 | 116-117 | 124
66-507 | Grade 5 Encyclofact Add-on Pack | R-W | 18 | 116-117 | 70
66-485 | Grade 5 Encyclofact Add-on Pack | R-W | 6 | 116-117 | 34
Persuasive and Argument Texts
ISBN Number | Description | Level | Book Quantity | Catalog Page | Price | Quantity | Total Price
677-08 | Should There be Presidential Term Limits? | S | 1 | 114-115 | 8
19-928 | Should the Electoral College be Abolished? | X | 1 | 114-115 | 8
19-843 | Should We Use Green Energy | R | 1 | 114-115 | 8
67-678 | Should We Drill for Oil in Protected Areas? | W | 1 | 114-115 | 8
67-651 | Are Organized Sports Better for Kids than Pickup Games? | T | 1 | 116-117 | 8
67-686 | Is it Better to be Judged by a Jury of Your Peers Than by a Judge? | V | 1 | 116-117 | 8
68-275 | Should There be Space Exploration? | R | 1 | 116-117 | 8
 |  |  |  |  | Total
 |  |  |  |  | FREE S & H |  | FREE
 |  |  |  |  | Grand Total
Choose from the following options to order: |  |  | BILL TO:
1. Fax order to [PHONE] |  |  | Name
2. Call Customer Service 1-886-6636 |  |  | District/School
3. Mail order to: |  |  | Address
Mondo Publishing |  |  | City/State/Zip
980 Avenue of the Americas |  |  | Phone  (       )
New York, NY  10018 |  |  | Fax (        )
 |  |  | P.O.#
Payment Method: |  |  | SHIP TO: (if different)
O   Check/Money Order Enclosed |  |  | Name
O   Visa | O   MasterCard |  | District/School
Card Number |  |  | Address
Expiration Date |  |  | City/State/Zip
Signature |  |  | Phone  (       )
 |  |  | Fax (        )
 |  |  | E-mail
Spreadsheet: 863076d1710625511-rearranging-data-based-on-dates-data-rearrange-excelforum2-4-
Sheet: Sheet1

 | ID | Month | Plan | Actual |  | ID | Plan | Actual |  |  | Plan | Actual
 | A01 | 2024-01-01 00:00:00 | 8 | 5 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 | A02 | 2024-02-01 00:00:00 | 4 | 7 |  | A01 | 2024-01-01 00:00:00 | No Actual |  | A01 | 2024-01-01 00:00:00 | No Actual
 | A03 | 2024-03-01 00:00:00 | 0 | 2 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | No Actual
 | A04 | 2024-04-01 00:00:00 | 1 | 3 |  | A02 | No Plan | 2024-02-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | No Actual
 |  |  |  |  |  | A03 | 2024-03-01 00:00:00 | No Actual |  | A01 | 2024-01-01 00:00:00 | No Actual
 |  |  |  |  |  | A04 | No Plan | 2024-04-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | No Actual
 |  |  |  |  |  |  |  |  |  | A01 | 2024-01-01 00:00:00 | No Actual
 |  |  |  |  |  |  |  |  |  | A01 | 2024-01-01 00:00:00 | No Actual
 |  |  |  |  |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 - 4 No.s "Feb-24" should be present in the Plan column
 |  |  |  |  |  |  |  |  |  | A02 | No Plan | 2024-02-01 00:00:00 |  | A01 - 5 No.s "Jan-24" should be present in the Actual column
 |  |  |  |  |  |  |  |  |  | A02 | No Plan | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A02 | No Plan | 2024-02-01 00:00:00 |  | A03 & A04 - results are correct
 |  |  |  |  |  |  |  |  |  | A02 | No Plan | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A02 | No Plan | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A02 | No Plan | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A03 | No Plan | 2024-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A03 | No Plan | 2024-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A04 | 2024-04-01 00:00:00 | 2024-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A04 | No Plan | 2024-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A04 | No Plan | 2024-04-01 00:00:00
Spreadsheet: 130822d1322597109-excel-2007-update-cells-from-cells-from-another-workbook-biz-2
Sheet: Sheet1

Numbers | More #'s
8 | 2
2 | 3
6 | 8
1 | 7
9 | 5
9 | 2
9 | 1
9 | 1
9 | 1
9 | 1