tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 142048d1329602128-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: Canadian Open

 |  | WEEK 17 The Canadian Open
 |  | Total Earnings |  |  |  | Rankings Through Week 17 | Total
 | [NAME] | 0 |  | 1 |  | [NAME] | 0
 | [NAME] | 0 |  | 2 |  | [NAME] | 0
 | [NAME] | 0 |  | 3 |  | [NAME] | 0
 | Player 4 | 0 |  | 4 |  | Player 4 | 0
 | Player 5 | 0 |  | 5 |  | Player 5 | 0
 | Player 6 | 0 |  | 6 |  | Player 6 | 0
 | Player 7 | 0 |  | 7 |  | Player 7 | 0
 | Player 8 | 0 |  | 8 |  | Player 8 | 0
 | Player 9 | 0 |  | 9 |  | Player 9 | 0
 | Player 10 | 0 |  | 10 |  | Player 10 | 0
 | Player 11 | 0 |  | 11 |  | Player 11 | 0
 | Player 12 | 0 |  | 12 |  | Player 12 | 0
 | Player 13 | 0 |  | 13 |  | Player 13 | 0
[NAME] |  | Canadian Open |  | YTD
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 4
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 5
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 6
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 7
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 8
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 9
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 10
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 11
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 12
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 13
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Spreadsheet: 747961d1631805260-copy-information-from-multiple-tables-to-a-sheet-bwp-invoices
Sheet: Table 3

 |  |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  | Invoice #
 |  |  |  |  |  |  |  |  |  |  |  |  | 2021-09-10 00:00:00 |  |  |  | 78088
 | [NAME] |  |  |  |  |  |  |  |  | Ship To
P.O. Number |  |  | Terms |  | Rep |  | Ship |  | Via |  | F.O.B. |  |  | Project
PN32324 |  |  | 2%10NET45 |  | HOUSE |  | 2021-09-10 00:00:00 |  | UPS |  | Richmond, VA
Quantity |  | Item Code |  | Description |  |  |  |  |  |  |  | Price Each |  |  |  | Amount
1 |  | 300763 |  | DRILL FIX. [NAME]. CENTER |  |  |  |  |  |  |  | 395 |  |  |  | 395
 |  |  |  |  |  |  |  |  |  |  |  | Total                              $395.00
Payments/Credits                 $0.00 |  |  |  |  |  |  |  | Balance Due |  |  |  |  |  |  | 395
Spreadsheet: john_arnold__15330__TaxFree
Sheet: Sheet1

 |  |  |  | Grow tax-free,
 |  | Tax annually |  | tax at end
rate of growth |  | 0.1 |  | 0.1
tax in each year |  | 0.3 |  | 0
tax in last year |  | 0 |  |  | 0.3
year0 |  | 1000 |  | 1000
year1
year2
year3
year4
year5
Spreadsheet: 843020d1694997962-sort-text-strings-based-on-two-criteria-sort-strings-by-two-criteria
Sheet: Sheet2

 | Data |  | Desired result
 | 2r 37m2 |  | 2r 37m2
 | 2r 9m2 |  | 2r 49m2 |  | 2r 37m2
 | 2r 50m2 |  | 2r 50m2 |  | 2r 50m2
 | 12r 51m2 |  | 2r 51m2 |  | 2r 58m2
 | 2r 58m2 |  | 2r 58m2 |  | 3r 81m2
 | 3r 81m2 |  | 3r 81m2 |  | 4r 89m2 | https://www.excelforum.com/excel-formulas-and-functions/1412168-using-textsplit-with-map-and-lambda-is-not-working.html
 | 4r 101m2 |  | 4r 89m2 |  | 4r 94m2
 | 4r 89m2 |  | 4r 94m2 |  | 4r 96m2
 | 4r 94m2 |  | 4r 96m2 |  | 4r 97m2
 | 4r 96m2 |  | 4r 97m2 |  | 4r 101m2
 | 4r 97m2 |  | 4r 101m2 |  | 5r 98m2
 | 5r 104m2 |  | 5r 98m2 |  | 5r 104m2
 | 5r 98m2 |  | 5r 104m2 |  | 12r 51m2
Spreadsheet: 691291d1597621009-could-dmax-be-changed-to-a-pull-down-formula-dmax-criteria-rows
Sheet: Sheet2

Client | Date | QTY |  |  |  | Client | DMAX | MAX |  | Client | Dmax
A |  | 10 |  |  |  | A |  |  |  | A
B |  | 20 |  |  |  | B |  |  |  | Client
C |  | 30 |  |  |  | C |  |  |  | B
D |  | 40 |  |  |  | D |  |  |  | Client
A |  | 50 |  |  |  |  |  |  |  | C
C |  | 60 |  |  |  |  |  |  |  | Client
A |  | 70 |  |  |  |  |  |  |  | D
B |  | 80
A |  | 90 |  |  |  | The criteria needs to be Two Rows
 |  |  |  |  |  | with Client on top and A-D below it.
Spreadsheet: 09de74b9-2680-47be-aa59-4ae5541f6459
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | City of Rio Rancho Department of Finance - Alarm Billing Customer Dispute Form
Please complete all the information on this form as completely and accurately as possible by typing or using blue or black ink.  Please contact us at (505) 891-5071 with any questions.
Section I - Customer Information |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Call # |  |  |  |  |  |  |  |  | Date of Call
Name:
 |  |  |  |  |  |  | Last Name |  |  |  |  |  |  |  |  |  | First Name
Address:
 |  |  |  |  | Street |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | City/State |  |  |  |  |  |  |  |  | Zip
Phone #: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-Mail:
Section II - Dispute Information
Please desribe the nature of your billing dispute in the space provided below.  If more space is required, please attach additional sheets with this form.
Customer Signature
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
Please return this completed and signed form to: Attn: [NAME], Alarm Billing, 3200 Civic Center Circle NE, Rio Rancho, NM  87144, or fax to (505) 891-5762.
For Internal Use Only
Date Received: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Responded:
Spreadsheet: 44663d1243438742-more-than-one-condition-for-a-sum-formula-sample_270509
Sheet: Sheet2

 | Needed for budget reporting
Budget Line | Code | 2009001 | 2009002 | 2009003 | 2009004 | 2009005 | 2009006 | 2009007 | 2009008 | 2009009 | 2009010 | 2009011 | 2009012
Proj S | X | #N/A
Proj S | Z
Proj Z | B
Proj Z | A
Proj Z | Y
Spreadsheet: 176635d1346046224-interest-rate-calculation-ef855678-interest-paid
Sheet: Sheet1

 | Int Rate | 0.1 | 0.095 | 0.09 | 0.085 |  | << interest rates |  |  | Interest calc for the amount on 30 Sep 2010
 | Date | 2010-09-01 00:00:00 | 2010-11-05 00:00:00 | 2011-11-05 00:00:00 | 2012-07-19 00:00:00 | 2012-08-31 00:00:00 | << commencing on this date |  |  | StartDate | EndDate | O/Balance | Days | Interest | C/Balance
 | 2010-09-30 00:00:00 | 367777.0213040286
 | 2010-10-31 00:00:00 | 614423.422917806
 | 2010-11-30 00:00:00 | 68424.75291535644
 | 2010-12-31 00:00:00 | 661341.8172758974
 | 2011-01-31 00:00:00 | 113757.9678973437
 | 2011-02-28 00:00:00 | 424036.1894445032
 | 2011-03-31 00:00:00 | 558110.2167983241
 | 2011-04-30 00:00:00 | 319783.2046335372 |  |  |  |  |  |  |  | Interest calc for the amount on 31 Oct 2010
 | 2011-05-31 00:00:00 | 348716.7115741003 |  |  |  |  |  |  |  | StartDate | EndDate | O/Balance | Days | Interest | C/Balance
 | 2011-06-30 00:00:00 | 61988.07355430714
 | 2011-07-31 00:00:00 | 218659.2986344802
 | 2011-08-31 00:00:00 | 568823.9829310627
 | 2011-09-30 00:00:00 | 251198.8926679187
 | 2011-10-31 00:00:00 | 688707.6205157943
 | 2011-11-30 00:00:00 | 937577.1881730763
 | 2011-12-31 00:00:00 | 809870.4612791354
 | 2012-01-31 00:00:00 | 378155.7661305992
 | 2012-02-29 00:00:00 | 851559.5329695004
 | 2012-03-31 00:00:00 | 726299.3058649536
 | 2012-04-30 00:00:00 | 379953.7010729326
 | 2012-05-31 00:00:00 | 841639.8833690326
 | 2012-06-30 00:00:00 | 959769.6731530263
 | 2012-07-31 00:00:00 | 837874.7863701277
 | 2012-08-31 00:00:00 | 147865.6175406895
 |  | Tot int paid:
Spreadsheet: 777044d1650100696-returning-the-most-recent-year-billed-for-each-client-test-dashboard-6
Sheet: PowerQuery Factures

[NAME] |  |  |  |  | [NAME] (oudated)
Source.Name | Date de facturation | Numéro de facture | Quarter |  | Source.Name | Date de facturation | Numéro de facture | Quarter
Facture 2022-001.xlsm | 2022-01-12 00:00:00 | 2022-001 |  |  | Facture 2021-007.xlsx | 2021-11-29 00:00:00 | 2021-007
Facture 2022-002.xlsm | 2022-01-12 00:00:00 | 2022-002 |  |  | Facture 2021-008.xlsx | 2021-11-29 00:00:00 | 2021-008
Facture 2022-003.xlsm | 2022-01-12 00:00:00 | 2022-003
Facture 2022-004.xlsm | 2022-02-21 00:00:00 | 2022-004
Facture 2022-005.xlsm | 2022-03-10 00:00:00 | 2022-005
Facture 2022-006.xlsm | 2022-04-11 00:00:00 | 2022-006
Facture 2022-007.xlsm | 2022-04-01 00:00:00 | 2022-007
Spreadsheet: 32789d1228945660-help-with-xls-column-calculation-checking-account-balance
Sheet: Sheet1

Debit Date | Item Description | Amount | Utilities | Insurance | Loans | Credit Card | Account Transfer | Interest | Misc 1 | [NAME] | [NAME]. 3 | Balance |  |  |  | Categories
2009-01-01 00:00:00 | Current Balance |  |  |  |  |  |  |  |  |  |  | 10000 |  |  | Airfare | -1
2009-01-01 00:00:00 | Groceries | 50 |  |  |  |  |  |  |  |  |  | 9950 |  |  | Auto | -1
2009-01-01 00:00:00 | Petrol | 75 |  |  |  |  |  |  |  |  |  | 9875 |  |  | Car | -1
2009-01-01 00:00:00 | Electric |  | 95 |  |  |  |  |  |  |  |  | 9780 |  |  | Credit Card | -1
2009-01-01 00:00:00 | [NAME] | 450 |  |  |  |  |  |  |  |  |  | 9330 |  |  | Deposit | 1
2009-01-01 00:00:00 |  |  |  |  |  |  |  |  |  | 14 |  | 9344 |  |  | Electric | -1
2009-01-01 00:00:00 |  |  |  |  |  |  |  | 3.25 |  |  |  | 9347.25 |  |  | Groceries | -1
2009-01-01 00:00:00 | Tax refund | 10.5 |  |  |  |  |  |  |  |  |  | 9357.75 |  |  | Home | -1
2009-01-01 00:00:00 | Taxi |  |  |  |  |  |  |  |  |  |  | 9357.75 |  |  | Hotel | -1
2009-01-01 00:00:00 | Hotel |  |  |  |  |  |  |  |  |  |  | 9357.75 |  |  | [NAME] | -1
2009-01-01 00:00:00 | Airfare |  |  |  |  |  |  |  |  |  |  | 9357.75 |  |  | Mortage | -1
2009-01-01 00:00:00 |  |  |  |  |  |  | 50 |  |  |  |  | 9407.75 |  |  | Petrol | -1
2009-01-01 00:00:00 | Water |  | 50 |  |  |  |  |  |  |  |  | 9357.75 |  |  | Tax refund | 1
2009-01-01 00:00:00 | Car |  |  |  | 25 |  |  |  |  |  |  | 9332.75 |  |  | Taxi | -1
2009-01-01 00:00:00 | Mortage |  |  |  | 300 |  |  |  |  |  |  | 9032.75 |  |  | Water | -1
2009-01-01 00:00:00 |  |  |  |  |  | 12 |  |  |  |  |  | 9044.75
2009-01-01 00:00:00 | Home |  |  | 35 |  |  |  |  |  |  |  | 9009.75
2009-01-01 00:00:00 | Auto |  |  | 112 |  |  |  |  |  |  |  | 8897.75
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 320046 | 326630 | 68213 | 62006 | 60282 | 67308 | 134575 | 120400
2 | 322443 | 342258 | 80613 | 62006 | 65523 | 61458 | 114858 | 123670
3 | 339003 | 356730 | 65345 | 62006 | 62518 | 57038 | 133408 | 135294
4 | 330189 | 334992 | 71515 | 62006 | 68003 | 60854 | 121528 | 122443
5 | 325424 | 357543 | 76506 | 45334 | 60101 | 61458 | 122124 | 116046
6 | 338716 | 363512 | 73883 | 62006 | 63277 | 61458 | 128438 | 126142
7 | 307408 | 329009 | 81561 | 62006 | 61384 | 66177 | 128949 | 116696
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-07-31 00:00:00 |  |  |  |  |  |  |  |  | 310272
2001-08-07 00:00:00
CBS Dollars
 |  |  | 1379279
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
Spreadsheet: 86276d1286294458-automatically-updating-a-workbook-with-information-from-several-workbooks-week-2
Sheet: Sheet1

Branch Name
Store 1 | 0.5333333333333333 | 0.01428571428571429 | 0.1666666666666667 | 0.25 | 1 | 4290 | 3092.4125 | 1.387266414166933
Store 2 | 0.4090909090909091 | 0.0427807486631016 | 0.02631578947368421 | 0.25 | 3 | 3070 | 2661.26 | 1.153588901497787
Store 3 | 0.5794392523364486 | 0.02419354838709677 | 0.6 | 0.5 | 1 | 5770 | 5245.554999999999 | 1.099978934545534
Store 4 | 0.4745762711864407 | 0.064 | 0.1428571428571428 | 0.25 | 1 | 5040 | 4941.61 | 1.019910514994101
Store 5 | 0.4029850746268657 | 0.03105590062111801 | 0.0% | 0.1 | 1 | 2510 | 3222.8325 | 0.7788180117955247
Spreadsheet: 70865d1271610165-voedselgenerator-voedselgenerator-help-
Sheet: broodmaaltijd

 | broodmaaltijd
 |  | Ochtend |  |  |  |  |  | middag |  |  |  |  |  |  | totaal
 |  | [NAME] | [NAME] | gem. | mensen | aantal x beleg |  | [NAME] | [NAME] | gem. | mensen | aantal x beleg |  | totaal aantal x beleg | dubbel beleg | totaal x beleg | [NAME] | aantal x beleg per broodje | aantal in verpaking | aantal [NAME] | aantal | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | plakjes brood | 3 | 2 |  |  |  |  | 5 | 3
 | bruinbrood | 0.6 | 0.4 |  |  |  |  | 0.6 | 0.4 |  |  |  |  |  |  |  | plakjes bruinbrood | 1 | 23 |  |  | broden
 | witbrood | 0.4 | 0.6 |  |  |  |  | 0.4 | 0.6 |  |  |  |  |  |  |  | [NAME] | 1 | 23 |  |  | broden
 | boter | 0.96 | 0.9 |  |  |  |  | 0.96 | 0.9 |  |  |  |  |  |  |  | broodjes met  boter | 5 | 500 |  |  | kuipjes
 | kaas | 0.2 | 0.09 |  |  |  |  | 0.2 | 0.09 |  |  |  |  |  |  |  | [NAME] | 25 | 1000 |  |  | kilo
 | ham | 0.08 | 0.08 |  |  |  |  | 0.08 | 0.08 |  |  |  |  |  |  |  | [NAME] | 1 | 10 |  |  | pakjes
 | cerverlaat | 0.06 | 0.08 |  |  |  |  | 0.06 | 0.08 |  |  |  |  |  |  |  | [NAME] | 1 | 10 |  |  | pakjes
 | boterhamworst | 0.06 | 0.08 |  |  |  |  | 0.06 | 0.08 |  |  |  |  |  |  |  | [NAME] | 1 | 10 |  |  | pakjes
 | leverpastei | 0.05 | 0.08 |  |  |  |  | 0.05 | 0.08 |  |  |  |  |  |  |  | [NAME] | 20 | 60 |  |  | kuipjes
 | hagelslag | 0.1 | 0.11 |  |  |  |  | 0.1 | 0.11 |  |  |  |  |  |  |  | [NAME] | 17.5 | 600 |  |  | pakken
 | [NAME] | 0.1 | 0.11 |  |  |  |  | 0.1 | 0.11 |  |  |  |  |  |  |  | [NAME] | 17.5 | 600 |  |  | pakken
 | jam | 0.1 | 0.12 |  |  |  |  | 0.1 | 0.12 |  |  |  |  |  |  |  | [NAME] | 17.5 | 500 |  |  | potten
 | pindakaas | 0.11 | 0.12 |  |  |  |  | 0.11 | 0.12 |  |  |  |  |  |  |  | broodjes pindakaas | 17.5 | 500 |  |  | potten
 | pasta | 0.14 | 0.13 |  |  |  |  | 0.14 | 0.13 |  |  |  |  |  |  |  | [NAME] | 17.5 | 500 |  |  | potten
 | dubbel beleg | mensen | percentage | mensen | procent
 |  |  | 0.3
Spreadsheet: 678519d1589931578-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example
Sheet: 13 Jan 20 - 18 Jan 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-01-13 00:00:00 | 2020-01-14 00:00:00 | 2020-01-15 00:00:00 | 2020-01-16 00:00:00 | 2020-01-17 00:00:00 | 2020-01-18 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 13/01/2020 - 18/01/2020
Dameon | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Dameon | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
Harley | AWAY | AWAY | AWAY | AWAY | AWAY |  |  | 1 |  | Harley | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Nathan | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Nathan | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | N/A
[NAME] | ✓ | ❌ | ✓ | ✓ | ✓ |  | 0.2 | 0.8 |  | [NAME] | ❌
Tyson | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Tyson | ✓
Will | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | ✓ | ✓ | AWAY | ✓ | AWAY |  |  |  |  |  | ❌
 |  | ✓ | AWAY | AWAY | AWAY |  |  |  |  |  | ❌
 | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  |  | ❌
Edge Protection [NAME] |  |  | 13/01/2020 - 18/01/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 13/01/2020 - 18/01/2020
Lilburn |  |  | ❌ |  |  |  |  |  |  | Dameon | ❌
Camden |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
63 [NAME] |  |  | ❌ |  |  |  |  |  |  | [NAME] | ❌
Canterbury Linen |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
Northlink |  |  | ❌ |  |  |  |  |  |  | [NAME] | ✓
Blum |  |  | ✓ |  |  |  |  |  |  | Harley | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | Nathan | ❌
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | N/A
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | Tyson | ❌
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌
Spreadsheet: 829038d1683880138-formulas-to-have-multiple-result-in-one-cell-exam2-2-
Sheet: Sheet1

SOURCE A |  |  |  |  |  |  |  |  | wokring Paper
 | STO NO | MODEL | STO Qty |  |  |  |  |  | STO NO | MODEL | Uniq Code | STO Qty | DN No | Ttl QTY DN | Open STO
 | 450012211 | ABCD | 200 |  |  |  |  |  | 450012211 | ABCD |  | 200
 | 450012211 | BCDE | 200 |  |  |  |  |  | 450012211 | BCDE |  | 200
 |  |  |  |  |  |  |  |  |  |  |  |  | Need formula in Yellow Highlighted
SOURCE B
 | STO NO | MODEL | DN No | MODEL | Uniq Code | DN Qty
 | 450012211 | ABCD | 810001 | ABCD |  | 100
 | 450012211 | ABCD | 810002 | ABCD |  | 50
 | 450012211 | ABCD | 810006 | ABCD |  | 50
 | 450012211 | BCDE | 810001 | BCDE |  | 50
 | 450012211 | BCDE | 810002 | BCDE |  | 100
Spreadsheet: 707406d1607251206-using-a-list-to-reduce-worksheets-midshires-master
Sheet: AK

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: e9929bdd-723d-479d-910e-b6482c605e25
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
43556892 | 2014-10-13 00:19:07 | AXIS | 1 | 5 | 2 | 714181 | ravel30 | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43557060 | 2014-10-13 00:29:52 | ALLIES | 1 | 5 | 3 | 714181 | ravel30 | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43575777 | 2014-10-14 07:47:31 | AXIS | 1 | 5 | 3 | 1239735 | Vaillants | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43575870 | 2014-10-14 08:06:12 | ALLIES | 0 | 4 | 5 | 1239735 | Vaillants | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43615684 | 2014-10-17 08:06:19 | AXIS | 0 | 3 | 5 | 3120 | gonzalan | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43615899 | 2014-10-17 08:24:19 | ALLIES | 1 | 5 | 1 | 3120 | gonzalan | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43696292 | 2014-10-22 23:17:25 | AXIS | 1 | 6 | 2 | 1509251 | mrmanley31 | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
43696537 | 2014-10-22 23:40:51 | ALLIES | 0 | 2 | 6 | 1509251 | mrmanley31 | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
Spreadsheet: 737184d1624270315-multiple-criteria-lookup-with-index-and-match-match
Sheet: Matrix-2

Data |  |  |  |  |  |  |  |  |  |  | Result 1 |  |  |  |  |  |  |  |  |  |  | Result 2
Match 1 Column | Match 2 Column |  | Match 3 Column |  | Invisible |  |  |  | Match 1 Row > |  | Pol | [NAME] | BOP | Poly | Ink | Red | Chem | Tol | Wov | Pfilm |  | Pol | [NAME] | BOP | Poly | Ink | Red | Chem | Tol | Wov | Pfilm
 |  | Pull 1 |  | PN | Pull 2 | x | y |  |  | PN | Pull 1 i.e C Column Data |  |  |  |  |  |  |  |  |  |  | Pull 1 i.e F Column Data
2077.4.1 | Pol |  |  |  |  | x | y | Match 3 Column | Match 2 Column
 | [NAME] |  |  |  |  | x | y
 | BOP | 1110 | PBS |  |  | x | y
 | Poly | 6500 | PLR | 5850 |  | x | y |  | PLR
 | Ink | 1010 | PBS | 999 | 1010 | x | y |  | PBS
 | Red | 140 | PBS |  | 140 | x | y
 | Red | 1040 | PLR |  | 1040 | x | y
 | Chem | 780 | PLR |  | 780 | x | y
Spreadsheet: 858693d1707291337-how-to-do-partial-match-between-two-columns-that-contains-names-checking-the-formulas
Sheet: Sheet2

 |  |  | Eligible Plans
From SAP | From HR | Company | Hours | Best guess
Lim, [NAME] | Backwood Jap | Sop | 3
Ram, Yukku | [NAME] | Sop | 4 | Pin, [NAME]
Pin, [NAME] | [NAME] | Sop | 6 | Ram, Yukku
[NAME], [NAME] (Jap) | [NAME] lim tan | Sop | 6 | Pin, [NAME]
Lim tan | [NAME] pin |  |  | [NAME], [NAME] (Jap)
Pin, [NAME] | Ram pin [NAME] |  |  | Pin, [NAME]
Pablo Escobar | [NAME] |  |  | Fan yong chu
[NAME] pim Pam | Carina kum |  |  | Fan yong chu
[NAME] ran tan Uy | Pablo pim tan |  |  | Fan yong chu
Lui | [NAME] |  |  | Fan yong chu
Fan yong chu | Lui escobaret |  |  | Fan yong chu