tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0184a0f3-0590-4571-bf12-bcfe4ffdd6bc
Sheet: 13a

 |  | Dealers** |  | Buyside |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Single - Name* | Corporate | 541842 | 8253751 | 541842 | 803638 | 1083685 | 9057389
 | Loans |  | 28639 |  | 1124 |  | 29763
 | Municipal |  | 3361 |  | <1,000 |  | 3361
 | Recovery
 | Sovereign | 33838 | 2643506 | 33838 | 243519 | 67676 | 2887025
Index Tranche | Asia |  | <1,000 |  | <100 |  | <1,000
 | Europe |  | 833701 |  | 88403 |  | 922104
 | North America |  | 1177439 |  | 37962 |  | 1215401
Index | Asia | 1369 | 319229 | 1669 | 48284 | 3038 | 367514
 | Europe | 278763 | 2561590 | 278532 | 386400 | 557296 | 2947991
 | North America | 515889 | 1659861 | 536018 | 331256 | 1051907 | 1991117
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL |  | 1371702 | 17481078 | 1391900 | 1940585 | 2763602 | 19421663
Estimated gross notional amount outstanding, December 14 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies.  Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 91289d1291057457-if-any-numbers-repeat-off-duty-details-equalization-form-sample
Sheet: Page 1

 |  |  | Company Name
 |  |  | Company Phone Number
 |  |  | Company FAX Number
 |  |  | Contact date/Person:
 |  |  | [NAME] Number:
 |  |  | Date of Detail
 | Units Assigned:
(C = Cancelled [NAME])
(NUA = No Units Available)
Units Contacted -No Answer
Date Billed / Total Hours
Payment Received
HP-125 Received
Sign Up Sheet Posted
Units Signed Up on Sheet
If Cancelled, enter date of cancellation:
Employee | Date appointed [NAME]. | Phone | [NAME]. No.
 |  |  |  | Response | Number | Response | Number | Response | Number | Response | Number | Response | Number
 |  |  | 13 | I | 13 | A | 18 | I | 17 | I | 15 | I | 14
 |  |  | 7 | I | 7 | I | 7 | I | 7 | I | 6 | I | 6
 |  |  | 15 | I | 15 | I | 14 | I | 13 | I | 12 | I | 12
 |  |  | 4 | I | 4 | I | 4 | I | 4 | I | 4 | I | 4
 |  |  | 5 | I | 5 | I | 5 | I | 5 | I | 5 | I | 5
 |  |  | 6 | I | 6 | I | 6 | I | 6 | D | 17 | I | 16
 |  |  | 10 | I | 10 | I | 10 | I | 10 | I | 9 | I | 9
 |  |  | 11 | I | 11 | I | 11 | I | 11 | I | 10 | I | 10
 |  |  | 12 | I | 12 | I | 12 | A | 18 | I | 16 | I | 15
 |  |  | 17 | I | 17 | I | 16 | I | 15 | I | 13 | I | 13
 |  |  | 1 | I | 1 | I | 1 | I | 1 | I | 1 | I | 1
 |  |  | 8 | I | 8 | I | 8 | I | 8 | I | 7 | I | 7
 |  |  | 14 | A | 14 | I | 13 | I | 12 | I | 11 | I | 11
 |  |  | 2 | I | 2 | I | 2 | I | 2 | I | 2 | I | 2
 |  |  | 18 | I | 18 | I | 17 | I | 16 | I | 14 | A | 18
 |  |  | 16 | I | 16 | I | 15 | I | 14 | A | 18 | I | 17
 |  |  | 9 | I | 9 | I | 9 | I | 9 | I | 8 | I | 8
 |  |  | 3 | I | 3 | I | 3 | I | 3 | I | 3 | I | 3
Codes - A=Accepted [NAME]; D=Declined [NAME]; I=On-Duty, Training, Court, [NAME], OIL, CB, Dis, No Answer;  C=Detail Cancelled; N=No Units Available
Spreadsheet: 116761d1312127501-help-with-rotational-formulas-color-formatting-player-20rotation-1-
Sheet: Sheet1

 | Player | Default Band | Nickname |  | Squad | Player | Index | Starter
 |  |  |  |  | 1 | [NAME] | 1 | [NAME]
 |  |  |  |  | 1 | Betty | 2
 |  |  |  |  | 1 | Charlotte | 3 |  |  |  |  |  |  |  |  |  | EXAMPLE
 |  |  |  |  | 1 | [NAME] | 4 |  |  |  |  |  |  | Period | Squad | Point Guard (1) | Guard (2) | Guard (3) | Forward (4) | Forward (5)
 |  |  |  |  | 1 | [NAME] | 5 |  |  |  |  |  |  | 1 | 1 | [NAME] | Betty | Charlotte | [NAME] | [NAME]
 |  |  |  |  | 2 | Felicity | 6 |  |  |  |  |  |  | 2 | 2 | [NAME] | Heather | Izzi | [NAME] | Felicity
 |  |  |  |  | 2 | [NAME] | 7 |  |  |  |  |  |  | 3 | 1 | Charlotte | [NAME] | [NAME] | [NAME] | Betty
 |  |  |  |  | 2 | Heather | 8 |  |  |  |  |  |  | 4 | 2 | Izzi | [NAME] | Felicity | [NAME] | Heather
 |  |  |  |  | 2 | Izzi | 9 |  |  |  |  |  |  | 5 | 1 | [NAME] | [NAME] | Betty | Charlotte | [NAME]
 |  |  |  |  | 2 | [NAME] | 10 |  |  |  |  |  |  | 6 | 2 | Felicity | [NAME] | Heather | Izzi | [NAME]
 |  |  |  |  |  |  |  | AUTO
 |  |  |  |  | Period | Squad | Point Guard (1) | Guard (2) | Guard (3) | Forward (4) | Forward (5)
 |  |  |  |  | 1 | 1
 |  |  |  |  | 2 | 2
 |  |  |  |  | 3 | 1
 |  |  |  |  | 4 | 2
 |  |  |  |  | 5 | 1
 |  |  |  |  | 6 | 2
 |  |  |  |  |  |  |  | CUSTOM
 |  |  |  |  | Period | Squad | Point Guard (1) | Guard (2) | Guard (3) | Forward (4) | Forward (5)
 |  |  |  |  | 1 | 1
 |  |  |  |  | 2 | 2
 |  |  |  |  | 3 | 1
 |  |  |  |  | 4 | 2
 |  |  |  |  | 5 | 1
 |  |  |  |  | 6 | 2
Spreadsheet: 96124d1295555747-alternative-need-for-pivot-table-dna-export-example-v2
Sheet: PT

Count of [NAME] number | Positive | Negative
 | 1 | 1 Total | 2 | 2 Total | 3 | 3 Total | 4 | 4 Total | (blank) |  |  |  |  | (blank) Total | Grand Total
Course | (blank) |  | (blank) |  | (blank) |  | (blank) |  | -5 | -4 | -3 | -2 | (blank)
Buisness | 1 | 1 |  |  |  |  | 1 | 1 |  |  |  |  |  |  | 2
English |  |  | 1 | 1 |  |  |  |  |  | 1 |  |  |  | 1 | 2
French |  |  | 1 | 1 | 2 | 2 |  |  |  |  |  | 1 |  | 1 | 4
German | 1 | 1 |  |  |  |  | 1 | 1 |  |  |  |  |  |  | 2
Latin |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 | 1 |  |  | 2 | 4
Maths |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 2 | 2
Science |  |  | 1 | 1 | 1 | 1 |  |  |  |  | 2 |  |  | 2 | 4
Social |  |  | 1 | 1 |  |  |  |  | 1 |  |  | 1 | 1 | 3 | 4
Grand Total | 2 | 2 | 4 | 4 | 4 | 4 | 3 | 3 | 1 | 3 | 3 | 3 | 1 | 11 | 24
Spreadsheet: 7426bee7-5525-453c-a267-ef48f577b92c
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
35944385 | 2013-05-14 22:20:21 | ALLIES | 1 | 6 | 1 | 260978 | DoomHammer | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
35944564 | 2013-05-14 22:38:23 | AXIS | 0 | 5 | 6 | 260978 | DoomHammer | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
Spreadsheet: 538250d1505484623-need-a-formula-or-code-to-replace-dates-inventory-accuracy-template
Sheet: US Compliant SC's

Cycle Count By Location - Period Ending August 31, 2017 - FY 18 - US Locations
Area | Region | Location Number | Location Name | Country | Ending Inventory | Total $ Counted | Value Difference | Inventory $ [NAME] | Number Of Parts Counted | Number Of Parts Counted With Errors | Count Error Rate | Book Quantity | Counted Quantity | Piece Count Error Rate | Operational Error Rate | Operation Count Delta | Status | Location Type | Last Wall To Wall
 |  |  | US Totals
Spreadsheet: 690657d1597225985-index-match-sum-based-on-criteria-index-match-sum
Sheet: Sheet1

OFFSET VALUE |  | 2020-08-10 00:00:00 | 2020-08-11 00:00:00 | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-17 00:00:00 | 2020-08-18 00:00:00 | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | 2020-08-21 00:00:00 | 2020-08-24 00:00:00 | 2020-08-25 00:00:00 | 2020-08-26 00:00:00 | 2020-08-27 00:00:00 | 2020-08-28 00:00:00
3 | Current Formula, Wrong answer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product Criteria
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  | 2020-08-10 00:00:00 | 2020-08-11 00:00:00 | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-17 00:00:00 | 2020-08-18 00:00:00 | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | 2020-08-21 00:00:00 | 2020-08-24 00:00:00 | 2020-08-25 00:00:00 | 2020-08-26 00:00:00 | 2020-08-27 00:00:00 | 2020-08-28 00:00:00 |  |  | 3
 | Answer should be | 21 | 121 | 37 | 37 | 57 | 37 | 37 | 32 | 42 | 32 | 32 | 41 | 0 | 0 | 0 |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  | 2020-08-10 00:00:00 | 2020-08-11 00:00:00 | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-17 00:00:00 | 2020-08-18 00:00:00 | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | 2020-08-21 00:00:00 | 2020-08-24 00:00:00 | 2020-08-25 00:00:00 | 2020-08-26 00:00:00 | 2020-08-27 00:00:00 | 2020-08-28 00:00:00 | Bank Holiday |  | 7
Product Number |  | 41.4 | 41.4 | 41.4 | 41.4 | 41.4 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 0 |  | 8
1 |  | 20.4 | 20.4 | 20.4 | 20.4 | 20.4 | 19 | 19 | 19 | 19 | 19 | 24 | 24 | 24 | 24 | 24 | Bank Holiday |  | 9
2 |  | 1 | 1 | 1 | 1 | 1 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 | 7.6 | 7.6 | 7.6 | 7.6 | 7.6 | Bank Holiday |  | 12
3 |  | 11.6 | 11.6 | 11.6 | 11.6 | 11.6 | 23.2 | 23.2 | 23.2 | 23.2 | 23.2 | 24.4 | 24.4 | 24.4 | 24.4 | 24.4 | Bank Holiday |  | 13
4 |  | 0 | 0 | 0 | 0 | 0 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 0 | 0 | 0 | 0 | 0 | Bank Holiday |  | 14
5 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday |  | 15
6 |  | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
7 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
8 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
9 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
11 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
12 |  | 0 | 0 | 0 | 0 | 0 | 5 | 5 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
13 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 |  | 0 | 0 | 0 | 0 | 100 | 0 | 0 | 20 | 0 | 0 | 0 | 10 | 0 | 0 | 9 | Bank Holiday
15 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
16 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bank Holiday
Spreadsheet: 217965d1362270423-depreciation-straight-line-calculation-based-on-start-and-end-date-depreciation-straight-line-calc
Sheet: Orig

Depreciation Straight line Calculation based on start and end date
Asset Cost | 100000
Start Date | 2013-01-01 00:00:00 | date place in service
End Date | 2014-05-31 00:00:00 | final month of depreciation
Useful life
 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10
 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | Total
 |  | Difference between asset cost and total depreciation over asset useful life.  This should be -0-
Spreadsheet: 120327d1315215061-excel-2007-how-to-autopopulate-cells-with-the-used-of-h-and-vlookup-quotation
Sheet: InputData

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
ITEM  NO | DATE | QUOTED BY | QUOTATION  NO | SUBJECT | ATTENTION | QUOTED TO | ADDRESS (L1) | TELEPHONE | FAX | [NAME] | TERM OF PAYMENT (L1) | TERM OF PAYMENT (L2) | VALIDITY FIRM | DELIVERY TIME | INSTALLATION | WARANTY | NOTE (L1) | NOTE (L2) | NOTE (L3) | NOTE (L4) | [NAME] | QUANTITY – 1 | [NAME] | QUANTITY – 2 | [NAME] | QUANTITY – 3 | [NAME] | QUANTITY – 4 | [NAME] | QUANTITY – 5
20110905-1 | 2011-09-05 00:00:00 | [NAME] | JD / 110905-1 | TEST 1 | [NAME] | ABCDEFG ENGINEERING CO., LTD | 1010 MAIN STREET, ETC, ETC | [PHONE] | [PHONE] | [NAME] | 50% IN ADVANCE | 50% - 30 DAYS | 30 | 30 DAYS | - | 12 | - | - | - | - | AV 001 | 30 | RB 001 | 10 | DB 001 | 20
20110905-2 | 2011-09-05 00:00:00 | [NAME] | JS / 110905-2 | TEST 2 | [NAME] | ABCDEFG ENGINEERING CO., LTD | 1010 MAIN STREET, ETC, ETC | [PHONE] | [PHONE] | [NAME] | 50% IN ADVANCE | 50% - 30 DAYS | 30 | 30 DAYS | - | 12 | - | - | - | - | DB 001 | 20 | AV 001 | 30 | RB 001 | 10
Spreadsheet: 833070d1686760468-power-query-how-to-get-prev-months-value-how-to-get-prev-months-value-example-spreadsheet
Sheet: Sheet1

Data Set |  |  |  | Fake Pivot Table with intended result |  |  |  | slicers non functional for demonstration
Date | Item | Stock |  | Row Labels | Sum of Stock | Stock Change
2023-01-01 00:00:00 | Box | 100 |  | Mar | 373 | 168
2023-01-01 00:00:00 | Bottle | 84 |  | Bag | 137 | 11
2023-01-01 00:00:00 | Crate | 65 |  | Barrel | 8 | 8
2023-01-01 00:00:00 | Barrel | 45 |  | Bottle | 22 | 22
2023-01-01 00:00:00 | Bag | 67 |  | Box | 152 | 86
2023-02-01 00:00:00 | Box | 66 |  | Crate | 54 | 41
2023-02-01 00:00:00 | Bottle | 0 |  | Grand Total | 373
2023-02-01 00:00:00 | Crate | 13
2023-02-01 00:00:00 | Barrel | 0
2023-02-01 00:00:00 | Bag | 126
2023-03-01 00:00:00 | Box | 152
2023-03-01 00:00:00 | Bottle | 22
2023-03-01 00:00:00 | Crate | 54
2023-03-01 00:00:00 | Barrel | 8
2023-03-01 00:00:00 | Bag | 137
2023-04-01 00:00:00 | Box | 100
2023-04-01 00:00:00 | Bottle | 96
2023-04-01 00:00:00 | Crate | 31
2023-04-01 00:00:00 | Barrel | 8
2023-04-01 00:00:00 | Bag | 218
2023-05-01 00:00:00 | Box | 147
2023-05-01 00:00:00 | Bottle | 4
2023-05-01 00:00:00 | Crate | 27
2023-05-01 00:00:00 | Barrel | 56
2023-05-01 00:00:00 | Bag | 222
Spreadsheet: 81949d1282054997-football-league-predictor-workbook-new-league
Sheet: League Table

 |  |  | [NAME]
 |  |  | POS |  | PLAYER | P | W | D | L | F | A | PTS | 6 WK  Prediction  Pts
 |  |  | 1st |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 12
 |  |  | 2nd |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 3rd |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 4th |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 5th |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 6th |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 7th |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 8th |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 9th |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 10th |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 11th |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 12th |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 13th |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 14th |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 87698d1287576636-advice-on-using-the-lookup-function-requested-book2
Sheet: Sheet1

Item | Size | Color | Attrib 1 | Scale | Attrib 2 | Attrib 3 | Attrib 4 | Attrib 5
59:87:00:11 | Small | Grey | 65 |  | 4 | 3 | 1 | 2
59:87:01:21 | Small | Grey | 65 |  | 5 | 3 | 1 | 2
59:86:96:31 | Small | Grey | 65 |  | 5 | 3 | 1 | 2
59:86:14:11 | Medium | Red | 83 |  | 5 | 2 | 2 | 0
59:87:01:10 | Large | Red | 95 |  | 5 | 2 | 2 | 0
59:86:18:21 | Medium | Red | 83 |  | 6 | 2 | 2 | 0
59:86:78:20 | Large | Red | 95 |  | 6 | 2 | 2 | 0
59:87:07:31 | Medium | Red | 83 |  | 6 | 2 | 2 | 0
59:86:12:43 | Medium | Red | 83 |  | 5 | 2 | 3 | 0
59:87:90:51 | Medium | Red | 83 |  | 5 | 2 | 3 | 0
59:86:96:50 | Large | Red | 95 |  | 5 | 2 | 3 | 0
Spreadsheet: 550065d1512076672-tally-up-x-marks-for-roll-sheets-with-names-on-multiple-sheets-master-attendance-sheet-example
Sheet: Tue & Wed Combined

 | NAME | TOTAL TUE & WED COUNT
1 | AJAY SMITH
 | ALEX YU
 | ALEXANDRA MCDONALD
 | [NAME]
 | ANGEL YOU
 | ANNIE CLARK
 | BECCA GOODSON
 | [NAME]
 | [NAME]
 | SAMUEL SMITH
Spreadsheet: 821480d1678737678-import-values-to-one-cell-based-on-another-book1
Sheet: Sheet1

 |  |  |  |  | 7
 |  |  |  |  | 1 |  | [NAME] |  |  |  | 15 |  | Name 01
 |  |  |  |  | 2 |  | [NAME] |  |  |  | 16 |  | Name 02
 |  |  |  |  | 3 |  | [NAME] |  |  |  | 17 |  | Name 03
 |  |  |  |  | 4 |  | [NAME] |  |  |  | 18 |  | Name 04
 |  |  |  |  | 5 |  | [NAME] |  |  |  | 19 |  | Name 05
 |  |  |  |  | 6 |  | [NAME] |  |  |  | 20 |  | Name 06
 |  |  |  |  | 7 |  | [NAME] |  |  |  | 21 |  | Name 07
 |  |  |  |  | 8 |  | George |  |  |  | 22 |  | Name 08
 |  |  |  |  | 9 |  | Paige |  |  |  | 23 |  | Name 09
 |  |  |  |  | 10 |  | [NAME] |  |  |  | 24 |  | Name 10
 |  |  |  |  | 11 |  | [NAME] |  |  |  | 25 |  | Name 11
 |  |  |  |  | 12 |  | [NAME] |  |  |  | 26 |  | Name 12
 |  |  |  |  | 13 |  | Fred |  |  |  | 27 |  | Name 13
 |  |  |  |  | 14 |  | Gloria |  |  |  | 28 |  | Name 14
Spreadsheet: 27926d1221657893-using-a-range-of-values-in-a-lookup-function-655816
Sheet: Sheet1

 |  |  | E
 |  |  | LOOKUP VALUES | 0 | 1 | 1 | 0 | 1
 |  |  |  |  |  |  |  |  | Comparison | Row Number | Index
 |  |  | A | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0
 |  |  | B | 1 | 1 | 1 | 0 | 0 | 0 | 2 | 0
 |  |  | C | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 0
 |  |  | D | 1 | 0 | 1 | 0 | 0 | 0 | 4 | 0
 |  |  | E | 1 | 1 | 1 | 1 | 1 | 1 | 5 | 5 | E
 |  |  | F | 1 | 0 | 1 | 1 | 1 | 0 | 6 | 0
 |  |  | G | 0 | 1 | 1 | 1 | 0 | 0 | 7 | 0
 |  |  | H | 1 | 1 | 1 | 1 | 0 | 0 | 8 | 0
 |  |  | I | 0 | 0 | 1 | 1 | 0 | 0 | 9 | 0
 |  |  | J | 1 | 0 | 1 | 1 | 0 | 0 | 10 | 0
 |  |  | TABLE ARRAY
 |  |  |  | 1 | 2 | 3 | 4 | 5
 |  |  | A | 1 | 1 | 1 | 1 | 0
 |  |  | B | 0 | 1 | 1 | 1 | 0
 |  |  | C | 1 | 0 | 1 | 1 | 0
 |  |  | D | 0 | 0 | 1 | 1 | 0
 |  |  | E | 0 | 1 | 1 | 0 | 1
 |  |  | F | 0 | 0 | 1 | 0 | 1
 |  |  | G | 1 | 1 | 1 | 0 | 0
 |  |  | H | 0 | 1 | 1 | 0 | 0
 |  |  | I | 1 | 0 | 1 | 0 | 0
 |  |  | J | 0 | 0 | 1 | 0 | 0
Spreadsheet: 39376d1237534699-sumproduct-of-columns-based-on-matrix-position-sumproduct_problem
Sheet: Sheet1

 | A | B | C | D | E | F | G | H | I | J
A | 218.9 | 55 | 611.9 | 15 | 643.8 | 846.7 | 616.1 | 384.4 | 443.7 | 307.2
B | 825.2 | 127.6 | 634.3 | 143.8 | 692.1 | 954.2 | 444.5 | 815.4 | 953.8 | 242.6
C | 900.8 | 897.1 | 971.7 | 765 | 804.6 | 207.6 | 762.1 | 22 | 480.4 | 8.5
D | 480.8 | 426.7 | 299.2 | 487.9 | 985.6 | 504.4 | 268.8 | 630.5 | 543.7 | 416.9
E | 809 | 822.9 | 899 | 325.1 | 865.1 | 400.3 | 314.4 | 148.9 | 324.1 | 986.4
F | 969.1 | 122 | 315 | 225.6 | 53.1 | 475.5 | 801.3 | 188.5 | 567.5 | 267.5
G | 317.7 | 979.6 | 737.7 | 948.2 | 669 | 209 | 799.8 | 750.9 | 391.4 | 412.1
H | 311.6 | 698.6 | 320.6 | 469.8 | 385.6 | 285 | 441.1 | 144.3 | 993 | 43
I | 451.4 | 128 | 426.9 | 473.2 | 290.4 | 806.3 | 507.6 | 150 | 423.2 | 88.5
J | 541.2 | 443.5 | 936 | 760.6 | 836.4 | 937.6 | 569.3 | 18 | 585.7 | 325.3
 | A | B | C | D | E | F | G | H | I | J
A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
B | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
C | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
D | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
E | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
F | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
G | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
H | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
I | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
J | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 160308d1339038172-range-lookup-for-x-and-y-sumproduct-index-work-question-2
Sheet: Sheet2

 |  |  |  |  |  |  |  | Block | x min | x [NAME] | y min | y [NAME] | interval x | interval y
 |  |  |  | sample points. There's a total of 160… |  |  |  | 1 | 424850 | 425060 | 5409960 | 5410200 | 210 | 240
 |  |  |  |  |  |  |  | 2 | 425060 | 425270 | 5410200 | 5410440 | 210 | 240
 |  |  |  | x | y | Block |  | 3 | 425270 | 425480 | 5410440 | 5410680 | 210 | 240
 |  |  |  | 425460.556 | 5409383.684 | ? |  | 4 | 425480 | 425690 | 5410680 | 5410920 | 210 | 240
 |  |  |  | 425558.3652 | 5409357.424 | ? |  | 5 | 425690 | 425900 | 5410920 | 5411160 | 210 | 240
 |  |  |  | 425556.8218 | 5409429.947 | ? |  | 6 | 425900 | 426110 | 5411160 | 5411400 | 210 | 240
 |  |  |  | 425457.8327 | 5409339.057 | ? |  | 7 | 426110 | 426320 | 5411400 | 5411640 | 210 | 240
 |  |  |  | 425422.057 | 5409241.722 | ? |  | 8 | 426320 | 426530 | 5411640 | 5411880 | 210 | 240
 |  |  |  | 425623.7547 | 5409275.334 | ? |  | 9 | 426530 | 426740 | 5411880 | 5412120 | 210 | 240
 |  |  |  | 425202.5512 | 5409277.896 | ? |  | 10 | 426740 | 426950 | 5412120 | 5412360 | 210 | 240
 |  |  |  | 425457.0422 | 5409186.971 | ? |  | 11 | 426950 | 427160 | 5412360 | 5412600 | 210 | 240
 |  |  |  |  |  |  |  | 12 | 427160 | 427370 | 5412600 | 5412840 | 210 | 240
 |  |  |  |  |  |  |  | 13 | 427370 | 427580 | 5412840 | 5413080 | 210 | 240
 |  |  |  |  |  |  |  | 14 | 427580 | 427790 | 5413080 | 5413320 | 210 | 240
 |  |  |  |  |  |  |  | 15 | 427790 | 428000 | 5413320 | 5413560 | 210 | 240
 |  |  |  |  |  |  |  | 16 | 428000 | 428210 | 5413560 | 5413800 | 210 | 240
 |  |  |  |  |  |  |  | 17 | 428210 | 428420 | 5413800 | 5414040 | 210 | 240
 |  |  |  |  |  |  |  | 18 | 428420 | 428630 | 5414040 | 5414280 | 210 | 240
 |  |  |  |  |  |  |  | 19 | 428630 | 428840 | 5414280 | 5414520 | 210 | 240
 |  |  |  |  |  |  |  | 20 | 428840 | 429050 | 5414520 | 5414760 | 210 | 240
 |  |  |  |  |  |  |  | 21 | 429050 | 429260 | 5414760 | 5415000 | 210 | 240
 |  |  |  |  |  |  |  | 22 | 429260 | 429470 | 5415000 | 5415240 | 210 | 240
 |  |  |  |  |  |  |  | 23 | 429470 | 429680 | 5415240 | 5415480 | 210 | 240
 |  |  |  |  |  |  |  | 24 | 429680 | 429890 | 5415480 | 5415720 | 210 | 240
Spreadsheet: 42761d1241375155-conditional-formatting-sales-config
Sheet: Total Price Summary

Description | Total Price
Access Control Hardware
Access Control Software Products
Professional Services
GRAND TOTAL
Spreadsheet: 716900d1612412848-return-latest-balance-for-each-accounts-return-n-a-if-no-rows-of-data-forum-excel-3-f-v-2021
Sheet: Prêt

 |  |  | Prêt à |  | Solde
 |  |  | a
 |  |  | b
 |  |  | c
 |  |  | d
 | Date | Description | Prêt à | Montant | Solde | [NAME] | Mode d'envoi | Mode paiement
 | 2020-01-01 00:00:00 |  | a | 320 |  | Personnel | Comptant
 | 2020-01-05 00:00:00 |  | c | 40 |  | Épicerie
 | 2020-03-19 00:00:00 |  | c | -30 |  | Épicerie |  | Comptant
 | 2020-03-19 00:00:00 |  | b | 240 |  | Épicerie
 | 2020-04-05 00:00:00 |  | b | 300 |  | Personnel | Comptant
 | 2020-06-06 00:00:00 |  | c | 30 |  | Épicerie
 | 2020-06-06 00:00:00 |  | c | -20 |  | Épicerie
 | 2020-10-01 00:00:00 |  | d | 0 |  | Personnel | Comptant
Spreadsheet: 136674d1326784074-display-name-along-with-score-tournament-stats-template-copy
Sheet: Batting

 |  | Match 1 |  |  |  |  | Match 2 |  |  |  |  | Match 3 |  |  |  |  | Match 4 |  |  |  |  | Match 5 |  |  |  |  | Match 6 |  |  |  |  | Match 7 |  |  |  |  | Match 8
Name | Team | Runs | Balls Faced | 4's | 6's | SR | Runs | Balls Faced | 4's | 6's | SR | Runs | Balls Faced | 4's | 6's | SR | Runs | Balls Faced | 4's | 6's | SR | Runs | Balls Faced | 4's | 6's | SR | Runs | Balls Faced | 4's | 6's | SR | Runs | Balls Faced | 4's | 6's | SR | Runs | Balls Faced | 4's | 6's | SR |  | Total Runs | Total 4's | Total 6's | Total Balls Faced | SR |  |  | Maximun Runs Scored | Maximum 4's | Maximum 6's | Best SR | Highest Score in one Macth
q |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Score
w |  | 3 |  |  |  |  | 3 |  |  |  |  | 43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name
e |  | 43 |  |  |  |  | 3
re |  | 5 |  |  |  |  | 43 |  |  |  |  | 432
re |  | 54 |  |  |  |  | 2 |  |  |  |  | 4
t |  | 6 |  |  |  |  | 5 |  |  |  |  | 324
t |  |  |  |  |  |  | 4 |  |  |  |  | 32
y |  | 77 |  |  |  |  | 5 |  |  |  |  | 544
y |  | 6 |  |  |  |  | 435 |  |  |  |  | 655
yu |  |  |  |  |  |  | 3 |  |  |  |  | 6
u |  | 87 |  |  |  |  | 45 |  |  |  |  | 5
u |  | 9 |  |  |  |  | 345 |  |  |  |  | 6
i |  | 80 |  |  |  |  | 3 |  |  |  |  | 5
i |  | 8 |  |  |  |  | 3
 |  |  |  |  |  |  | 4 |  |  |  |  | 7
Spreadsheet: 64783d1265630755-lookup-tracker
Sheet: Sheet2

 | Recall 6 / Recall January
 |  |  |  | Qty Outstanding | A |  | 2nd |  | FLT |  | A | 2nd | FLT
 | Product | EAN | Total PIE'd in W/H |  | Pallet ID | Qty | Pallet ID | Qty | Pallet ID | Qty | Exit Route | Exit Route | Exit Route | Qty Sent
 | NOKE71GREYSTEELNEW |  | 499 |  | R6 5 | 263 |  |  |  |  | CPW |  |  | 263
 |  |  |  |  | R6 7 | 225 |  |  |  |  | CPW |  |  | 225
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Sent
 |  |  |  | Product Summary
 |  |  |  | Total In
 |  |  |  | Total Sold
 |  |  |  | Outstanding
 |  |  |  | Missing | 0
 |  |  |  | Total Left At