tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 777893d1650649113-how-to-change-cell-name-based-on-another-cell-and-place-data-on-correct-row-sample-workbook
Sheet: PIVOT

Sum of number | Column Labels
Row Labels | Completed | In Progress | Not Started | Not Yet Available | Grand Total
CLINIC1 [10402254] | 92 | 9 | 19 | 1 | 121
CLINIC2 [10402304] | 46 | 3 | 0 | 0 | 49
CLINIC3 [10402165] | 0 | 3 | 0 | 0 | 3
Grand Total | 138 | 15 | 19 | 1 | 173
Spreadsheet: 868409d1715159891-dynamic-formula-or-something-else-yoy-growth-v2-ans
Sheet: Period Dates

 | Last Year |  |  |  |  |  |  | This Year
 | Period | St Date | End Date | Working Days | EOP Working Days | Bank Holiday |  | Period | St Date | End Date | Working Days | EOP Working Days | Bank Holidays
 | GP P1 | 2023-04-01 00:00:00 | 2023-04-28 00:00:00 |  |  | 2023-04-07 00:00:00 |  | GP P1 | 2024-04-01 00:00:00 | 2024-04-28 00:00:00 |  |  | 2024-04-01 00:00:00
 | GP P2 | 2023-04-29 00:00:00 | 2023-05-26 00:00:00 |  |  | 2023-04-10 00:00:00 |  | GP P2 | 2024-04-29 00:00:00 | 2024-05-26 00:00:00 |  |  | 2024-05-06 00:00:00
 | GP P3 | 2023-05-27 00:00:00 | 2023-06-23 00:00:00 |  |  | 2023-05-01 00:00:00 |  | GP P3 | 2024-05-27 00:00:00 | 2024-06-23 00:00:00 |  |  | 2024-05-27 00:00:00
 | GP P4 | 2023-06-24 00:00:00 | 2023-07-21 00:00:00 |  |  | 2023-05-29 00:00:00 |  | GP P4 | 2024-06-24 00:00:00 | 2024-07-21 00:00:00 |  |  | 2024-08-26 00:00:00
 | GP P5 | 2023-07-22 00:00:00 | 2023-08-18 00:00:00 |  |  | 2023-08-28 00:00:00 |  | GP P5 | 2024-07-22 00:00:00 | 2024-08-18 00:00:00 |  |  | 2024-12-25 00:00:00
 | GP P6 | 2023-08-19 00:00:00 | 2023-09-15 00:00:00 |  |  | 2023-12-25 00:00:00 |  | GP P6 | 2024-08-19 00:00:00 | 2024-09-15 00:00:00 |  |  | 2024-12-26 00:00:00
 | GP P7 | 2023-09-16 00:00:00 | 2023-10-13 00:00:00 |  |  | 2023-12-26 00:00:00 |  | GP P7 | 2024-09-16 00:00:00 | 2024-10-13 00:00:00 |  |  | 2025-01-01 00:00:00
 | GP P8 | 2023-10-14 00:00:00 | 2023-11-10 00:00:00 |  |  | 2024-01-01 00:00:00 |  | GP P8 | 2024-10-14 00:00:00 | 2024-11-10 00:00:00
 | GP P9 | 2023-11-11 00:00:00 | 2023-12-08 00:00:00 |  |  | 2024-03-29 00:00:00 |  | GP P9 | 2024-11-11 00:00:00 | 2024-12-08 00:00:00
 | GP P10 | 2023-12-09 00:00:00 | 2024-01-05 00:00:00 |  |  |  |  | GP P10 | 2024-12-09 00:00:00 | 2025-01-05 00:00:00
 | GP P11 | 2024-01-06 00:00:00 | 2024-02-02 00:00:00 |  |  |  |  | GP P11 | 2025-01-06 00:00:00 | 2025-02-02 00:00:00
 | GP P12 | 2024-02-03 00:00:00 | 2024-03-01 00:00:00 |  |  |  |  | GP P12 | 2025-02-03 00:00:00 | 2025-03-02 00:00:00
 | GP P13 | 2024-03-02 00:00:00 | 2024-03-31 00:00:00 |  |  |  |  | GP P13 | 2025-03-03 00:00:00 | 2025-03-31 00:00:00
Spreadsheet: 625218d1558390469-extract-or-filter-data-filter
Sheet: Sheet1

Group no | Names | Quantity | filter data |  | Group no | Names | Quantity | Result
045/001 | bakery | 1500 | 1 |  | 045/001 | bakery | 1500
045/001001 | cakes | 120 | 8 |  | 045/001001 | cakes | 120
045/001001001 | Dry fruits cake | 10 |  |  | 045/001001001 | Dry fruits cake | 10
045/001001002 | Fresh cakes | 14 |  |  | 045/001001002 | Fresh cakes | 14
045/001002 | Sweets | 1750 |  |  | 045/001002 | Sweets | 1750
045/001002001 | Hand made | 20 |  |  | 045/001002001 | Hand made | 20
045/001002004 | Sugar free | 13 |  |  | 045/001002004 | Sugar free | 13
045/002 | vegetables and fruits | 4111 |  |  | 045/008 | Milk | 555
045/002001 | Veg | 12 |  |  | 045/008001 | Cow | 710
045/002001004 | Capsicum | 17 |  |  | 045/008001003 | Bottle | 200
045/002001007 | Tomatto | 14 |  |  | 045/008001004 | cover | 476
045/002005 | fruits | 30 |  |  | 045/008003 | Goat | 320
045/002005001 | Apple | 800 |  |  | 045/008003002 | Bottle | 220
045/002005004 | Orange | 145 |  |  | 045/008005004 | cover | 11
045/005 | Ice cream | 125
045/005007 | bar | 10
045/005007002 | choco bar | 20
045/008 | Milk | 555
045/008001 | Cow | 710
045/008001003 | Bottle | 200
045/008001004 | cover | 476
045/008003 | Goat | 320
045/008003002 | Bottle | 220
045/008005004 | cover | 11
Spreadsheet: 854586d1704402386-find-name-and-indicate-line-and-fraction-1
Sheet: Folha1

 |  |  |  |  |  | Fraction | Name
 |  |  |  |  |  | 1a | aaa
 |  |  |  |  |  | 1b | bbb
 |  |  |  |  |  | 1c | [NAME]
 |  |  |  |  |  | 1d | ddd
 |  |  |  |  |  | 2a | eee
 |  |  |  |  |  | 2b | [NAME]
 |  |  |  |  |  | 2c | ggg
 |  |  |  |  |  | 3a | hhh
 |  |  |  |  |  | 3b | iii
 |  |  |  |  |  | 3c | jjj
 |  |  |  |  |  | 4a | lll
 |  |  |  |  |  | 5b | mmm
 |  |  |  |  |  | 6a | nnn
 |  |  |  |  |  | 6b | ooo
 |  |  |  |  |  | 6c | ppp
 |  |  |  |  |  | 6d | qqq
 |  |  |  |  |  | 6e | rrr
Spreadsheet: 85516d1285618141-using-weekly-data-to-convert-to-monthly-quote-analyzer
Sheet: 12-07-10

Job # | Quote Value | Sector | Description | Job Won | Sectors | Job Won |  | Building |  |  |  |  |  | Landscaping
1 | 4465 | Building |  | No | Building | Yes
 |  |  |  |  | Landscaping | No
Spreadsheet: 771068d1646404024-help-with-auto-populating-tables-ordering-sheet-2-new-
Sheet: Index

 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Cancellations |  |  |  |  |  | Returns
Spare/Non-Spare | Spok Number | Company name | Merchant | Order Number | [NAME] | Date order Placed | Invoice Number | Collection or delivery date | Sent invoice to customer? | Customer paid invoice? | Payment Ref. | invoice created for customer? | Merchant invoice received? | Merchant invoice correct? | [NAME] credit requested? | [NAME] credit note received? | Overcharge funds received? | NOTES | Cancellation requested? | Requested credit from merchant? | Refund customer? | Credit sage invoice? | Cancellation Funds received from merchant? | NOTES | Return requested? | Evidence received? (image of item in good resalable order) | Received proof of return? | Refund customer? | Credit invoice? | Return Funds received from merchant? | NOTES
Spreadsheet: sara_shackleton__36439__Credit Line Summary
Sheet: Sheet1

 |  |  |  | Conversion of Variation
 | Original | Variation | Broker Fee | 5 Yr Avg. | 1 Yr Avg.
Paribas | 0 | FF+56 | 6.1 | FF+56 | FF+56
E D & F Man | 0 | L+50 | 6.1 | FF+76 | FF+97
SSB | T+25 | T+75 | 5 | FF+48 | FF+56 | ($50 million total, $35 million [NAME] variation)
ABN AMRO | --- | --- | 6.5 | --- | ---
Overnight Cost of Funds:  FF+23
5 year history: | L=T+53
 | FF=T+27
4 year history: | L=T+57
 | FF=T+28
3 year history: | L=T+63
 | L=T+32
2 year history: | L=T+67
 | FF=T+33
1 year history: | L=T+66
 | FF=T+19
Spreadsheet: 877428d1724260619-return-same-value-in-one-sheet-to-another-sheet-but-also-not-return-a-value-if-none-exists-return-value
Sheet: R Sheet

ID # | Description | Data 1 | Data 2 | Data 3
 |  | <-- does not work to return the value "ARGH" entered in M Sheet D10
 |  | <-- Works by not returning a result.
Spreadsheet: 724448d1616164676-get-date-from-table-to-other-sheet-planning-2021-week-11b-1-ans
Sheet: Info (2)

 | Dosier N° | Column5 | Werfomschrijving | N° | ∑ PW | ∑ BA | Latei ft ≠ St. | ∏ | ꙱ | Column1 | Column2 | Column3 | G.F.⌠ | G.M.₼ | Column4 | Dat. S12 | N° lot | Dat. S32 | Leverdat. | Verbo N° | TDL-N° | Koer N° | Naar werf | Terug
 | 202000021
Spreadsheet: 782764d1654255192-using-ifs-function-to-return-amounts-based-on-dates-and-values-book1
Sheet: Sheet2

No. of Days | Invoice Due Date Ageing | Original Amount | Remaining Due | Large Value
20 | 15-30 Days | 802.13 | 802.13
28 | 15-30 Days | 3704.4 | 3704.4 | 0
30 | 15-30 Days | 1229.52 | 1229.52
43 | 31-60 Days | 22911.6 | 22911.6
44 | 31-60 Days | 1719.07 | 1719.07
64 | 61-90 Days | 127.76 | 127.76
69 | 61-90 Days | -128.28 | -128.28
70 | 61-90 Days | 4523.22 | 4523.22
83 | 61-90 Days | 5040 | 5040
113 | 91-120 Days | -918 | -918
113 | 91-120 Days | -3225.6 | -3225.6
114 | 91-120 Days | 8208 | 8208
150 | 121-150 Days | 197.95 | 197.95
170 | 151-180 Days | -563.45 | -563.45
930 | 181 Days+ | 18.7 | 18.7
Spreadsheet: 719680d1613755117-providing-output-if-criteria-matched-criteria
Sheet: Sheet1

STATUS | ASSET NO | COUNTIF | WHAT I WANT | Column1 | Helper
MATCH | 41223 |  |  |  |  |  | STATUS |  | PRIORITY
DIFFERENT | 41223 |  | DIFFERENT |  |  |  | MATCH | MATCH | MATCH
DIFFERENT | 41223 |  |  |  |  |  | MATCH | DIFFERENT | DIFFERENT
MATCH | 42222 |  | MATCH |  |  |  | MATCH | NOT FOUND | MATCH
NOT FOUND | 42222 |  |  |  |  |  | DIFFERENT | DIFFERENT | DIFFERENT
DIFFERENT | 32211 |  | DIFFERENT |  |  |  | DIFFERENT | NOT FOUND | DIFFERENT
DIFFERENT | 32211 |  |  |  |  |  | NOT FOUND | NOT FOUND | NOT FOUND
DIFFERENT | 32211
MATCH | 42212 |  | MATCH
DIFFERENT | 42311 |  | DIFFERENT
NOT FOUND | 22413 |  | NOT FOUND |  |  |  | DIFFERENT | DIFFERENT | DIFFERENT
 |  |  |  |  |  |  | MATCH | DIFFERENT | DIFFERENT
 |  |  |  |  |  |  | DIFFERENT | NOT FOUND | DIFFERENT
 | sagarkarki69 |  |  |  |  |  | MATCH | NOT FOUND | MATCH
 |  |  |  |  |  |  | MATCH | MATCH | MATCH
 |  |  |  |  |  |  | NOT FOUND | NOT FOUND | NOT FOUND
Spreadsheet: 270361d1381446224-eliminate-choices-from-drop-box-as-they-are-used-drop-list-example
Sheet: Teams

Teams |  | 16 game week
Arizona |  | 1
Atlanta |  | 2
Baltimore |  | 3
Buffalo |  | 4
Carolina |  | 5
Chicago |  | 6
Cincinnati |  | 7
Cleveland |  | 8
Dallas |  | 9
Denver |  | 10
Detroit |  | 11
Green Bay |  | 12
Houston |  | 13
Indianapolis |  | 14
Jacksonville |  | 15
Kanas City |  | 16
Miami
Minnesota
N.Y. Giants
N.Y. Jets
New England
New Orleans
Oakland
Philadelphia
Pittsburgh
San Diego
San Franciso
Seattle
St. Louis
Tampa Bay
Tennessee
Washington
Spreadsheet: 36803d1234761368-vlookup-vba-based-on-date-price-list-v1
Sheet: Prices

Date | Price | Price 2
2009-01-01 00:00:00 | 13.01
2009-01-02 00:00:00 | 14.11
2009-01-03 00:00:00 | 15.01
2009-01-04 00:00:00 | 12.01
2009-01-05 00:00:00 | 12.97
2009-01-06 00:00:00 | 13.47
2009-01-07 00:00:00 | 16.71
2009-01-08 00:00:00 | 15.69
2009-01-09 00:00:00 | 17.01
2009-01-10 00:00:00 | 14.02
2009-01-11 00:00:00 | 14.07
2009-01-12 00:00:00 | 13.92
2009-01-13 00:00:00 | 12.99
2009-01-14 00:00:00 | 12.5
2009-01-15 00:00:00 | 12.21
2009-01-16 00:00:00 | 11.98
2009-01-17 00:00:00 | 11.57
2009-01-18 00:00:00 | 11.75
2009-01-19 00:00:00 | 11.6
2009-01-20 00:00:00 | 11.71
2009-01-21 00:00:00 | 11.57
2009-01-22 00:00:00 | 11.21
2009-01-23 00:00:00 | 11.34
Spreadsheet: 14a6a830-835b-4a81-9440-3389ef828f66
Sheet: 10b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, November 23 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors.
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 Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: andy_zipper__250__Global_Prod 6-6-01 EM
Sheet: New on 6-6-01 - 24 Hr

New Global Products made available on
that were not available on
Global Product Short Desc.
Credit Dflt Swap Enel SpA                5 Years         bpa/USDm
Credit Dflt Swap Iberdrola               5 Years         bpa/USDm
Credit Dflt Swap Marconi Plc             5 Years         bpa/USDm
Credit Dflt Swap RWE AG                  5 Years         bpa/USDm
Credit Dflt Swap Vattenfall              5 Years         bpa/USDm
For Curr Exch    Forward                 08Jun01         JPY/USD
For Curr Exch    Forward                 08Jun01         USD/EUR
For Curr Exch    Forward                 08Jun01         USD/GBP
For Curr LME     LME (Spot)              08Jun01         JPY/USD
For Curr LME     LME (Spot)              08Jun01         USD/EUR
For Curr LME     LME (Spot)              08Jun01         USD/GBP
Foreign Currency Reuters BOFC            06Jun01         CAD/USD
SG Dubai Swap    Platts                  Q4 2001         USD/bl/m
SG E-W FO Diff   Platts                  Oct-Dec01       USD/mt/m
US Crude Fin Opt NYMEX WTI    EC27.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC28.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP25.5     Jul01           USD/bl/m
US Ethylene Swap CMAI                    Jul01-Jun02     c/LB
US Prop FOB Phy  MB TET                  Jul01           c/Gl-b
Spreadsheet: 266009d1379463263-excel-align-data-from-many-rows-into-a-single-row-alignment-in-excel-by-row
Sheet: Sheet1

Current Situation
 |  |  | Sample 1 | Sample 2 | Sample 3 | Sample 4
Name | RT | [NAME] | Area | Area | Area | Area
Chemical A | 21.201 | 43 | 176962
Chemical A | 21.202 | 43 |  | 2162037
Chemical A | 21.2 | 43 |  |  | 1593040
Chemical A | 21.203 | 43 |  |  |  | 1595420
Chemical B | 21.311 | 81 | 156752
Chemical B | 21.311 | 81 |  | 54952
Chemical B | 21.311 | 81 |  |  | 248956
Chemical B | 21.311 | 81 |  |  |  | 152566
Chemical C | 21.415 | 77 | 9548
Chemical C | 21.415 | 77 |  | 533666
Chemical C | 21.415 | 77 |  |  | 15578
Chemical C | 21.415 | 77 |  |  |  | 1512889
Desired outcome
 |  |  | Sample 1 | Sample 2 | Sample 3 | Sample 4
Name | RT | [NAME] | Area | Area | Area | Area
Chemical A | 21.204 | 43 | 176962 | 2162037 | 1593040 | 1595420
Chemical B | 21.311 | 81 | 156752 | 54952 | 248956 | 152566
Chemical C | 21.415 | 77 | 9548 | 533666 | 15578 | 1512889
Spreadsheet: 103265d1301034206-extracting-data-from-a-cell-help-request-11-3-25
Sheet: Sheet1

 | Amount | Qty | Total Cost
01-556-6134    1EA    $3.94 EA | 3.94 | 1
01-361-8386    1EA    $18.48 BG | 18.48 | 1
01-556-6508    1EA    $0.62 BG | 0.62 | 1
01-581-0106    1EA    $53.17 EA | 53.17 | 1
01-556-6057    2EA    $3.26 EA | 3.62 | 2
01-581-0102    1EA    $57.83 EA | 57.83 | 1
01-512-1519    6EA    $0.53 EA
01-568-6030    1EA    $698.00 EA
00-137-9240    2EA    $2.68 EA
01-583-8521    2EA    $12.57 EA
01-556-6605    1EA    $18.51 BG
01-512-1654    1EA    $0.80 EA
01-512-6164    1EA    $0.27 EA
01-587-3381    1EA    $100.00 EA
01-556-4751    1EA    $3.58 EA
01-556-6155    1EA    $16.30 BG
01-372-1516    4FT    $2.61 FT
01-556-4707    4FT    $4.96 FT
01-577-1125    1EA    $117.83 EA
01-556-4631    4EA    $0.09 EA
01-166-8517    4EA    $0.05 EA
Spreadsheet: benjamin_rogers__1308__site_visit_schedule for Dave Kristich
Sheet: Confirm - Calpine

 |  | Company | Calpine
 |  | Company Contact & Number | [NAME](408) 792-1105
 |  | Site or Sites | [NAME]
 |  | Site Visit Date | Friday October 27th
 |  | Directions to Hotels/Site | See DealBench - Due Diligence List/Plant Pictures Section
 |  | Meeting Time/Place | Friday Morning (8:00am to 9:00am)
 |  |  | Gleason Plant
 |  |  | 1166 [NAME].
 |  |  | Gleason, TN 38229
 |  | Enron Site Visit Coordinator | [NAME]
 |  |  | Work: (713) 853-7626 / Cell: (713) 515-9477
 |  |  | [NAME] Manager
 |  |  | Work: (901) 648-2190
 |  | Calpine Site Visit Team
Spreadsheet: 186751d1350194708-get-the-data-from-two-different-sheets-book1
Sheet: Result

Shift |  |  |  |  |  |  |  |  |  |  |  |  | Shift A | Day
 |  |  |  |  |  |  |  |  |  |  |  |  | Shift B | Night
Emp No | Emp Name | 8-9 AM | 10-11 AM | 12-2 PM | 4-5 PM | 8-9 PM | 12-1 AM | 4-5 AM
 |  | Break Fast | Brunch | Lunch | [NAME] | Dinner | Snacks | Morning Tea
Spreadsheet: 720835d1614308919-trying-to-return-a-last-value-in-a-column-based-on-the-same-description-book1-5-
Sheet: Sheet1

 | Date | Stock | Type | Units |  | Previous Units | Cumulative Units
 | 2021-02-24 00:00:00 | Gasoline | Buy | 16
 | 2021-02-24 00:00:00 | Financial | Buy | 13
 | 2021-02-25 00:00:00 | Gasoline | Sell | 1
 | 2021-02-25 00:00:00 | Financial | sell | 1
 | 2021-02-26 00:00:00 | Financial | sell | 1
 | 2021-02-26 00:00:00 | Financial | sell | 1
 |  | Financial | sell | 1
 |  | Financial | sell | 1
Spreadsheet: 198676d1354859966-can-vlookup-do-this-solver_solution3
Sheet: Solver_setup

 | Target | 1938
 | 270.72 | 0
 | 346.86 | 0.9999999999996858
 | 287.64 | 0
 | 219.96 | 0
 | 135.36 | 0
 | 16.92 | 0
 | 169.2 | 0
 | 84.6 | 0.9999999999998586
 | 33.84 | 0
 | 37.14 | 0
 | 74.28 | 1
 | 111.42 | 0
 | 222.84 | 1
 | 55.71 | 0
 | 74.28 | 0
 | 241.41 | 0
 | 37.14 | 0.9999999999999979
 | 74.28 | 0
 | 18.57 | 0
 | 18.57 | 0
 | 18.57 | 0
 | 18.57 | 0
 | 37.14 | 0
 | 18.57 | 0
 | 55.71 | 0.9999999999999406
 | 246.8 | 1
 | 579.68 | 0.9999999999999991
 | 144.92 | 0
 | 289.84 | 0.9999999999995441
 | 81.5 | 0
 | 162.99 | 0
 | sum | 1937.749999999743
 | Object f | 0.2500000002571596
Spreadsheet: 785525d1656476366-update-wages-in-the-same-colum-help-to-increase-pay
Sheet: Sheet1

First name [*] | Last name [*] | Account email [*] | Employing entity | Synchronise with payroll [Yes | No] | Hours/days per week | Pay Normal Working Hours By Default [Yes | No] | Industrial instrument | Classification | Pay rate template | Anniversary date [dd/mm/yyyy] | Currency | Pay | Salary option [Annum | Month | Fortnight | Hour] | Override template rate [Yes | No]
 |  |  |  | Yes | 38 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 38 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 12 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 38 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 28 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 38 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 12 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 45 | Yes |  |  |  |  |  |  | Annum | No
 |  |  |  | Yes | 12 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 38 | No |  |  |  |  |  |  | Annum | No
 |  |  |  | Yes | 12 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 38 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 38 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 38 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 38 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 45 | Yes |  |  |  |  |  |  | Annum | No
 |  |  |  | Yes | 38 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 45 | Yes |  |  |  |  |  |  | Annum | No
 |  |  |  | Yes | 38 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 38 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 38 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 12 | Yes |  |  |  |  |  |  | Annum | No
 |  |  |  | Yes | 38 | Yes |  |  |  |  |  |  | Annum | No
 |  |  |  | Yes | 28 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 45 | Yes |  |  |  |  |  |  | Annum | No
 |  |  |  | Yes | 38 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 45 | Yes |  |  |  |  |  |  | Annum | No
 |  |  |  | Yes | 20 | No |  |  |  |  |  |  | Hour | No
 |  |  |  | Yes | 38 | No |  |  |  |  |  |  | Hour | No
Spreadsheet: 703549d1605041548-extract-rows-from-table-that-match-criteria-in-one-column-team-book-example
Sheet: Master

 | Name | [NAME] | Phone | Team
 | [NAME] |  | 1231231234 | Ushers
 | [NAME] |  | 1111111111 | Ushers
 | Mark |  | 2222222222 | Ushers, Safety
 | [NAME] |  | 3333333333 | Prayer Partners, Ushers
 | [NAME] |  | 4444444444 | Prayer Partners
 | Timothy |  | 5555555555 | Safety
 | [NAME] |  | 6666666666 | Safety, Ushers
 | [NAME] |  | 7777777777 | Prayer Partners
 | [NAME] |  | 8888888888 | Prayer Partners
 | [NAME] |  | 9999999999 | Safety
Spreadsheet: 684796d1593538470-indirect-function-looking-for-worksheet-named-after-current-year-newsample
Sheet: 2020

2020
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | sheet2 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | 2
Spreadsheet: 4d549660-74ff-421e-868c-8544c75044d7
Sheet: Sheet1

Locus | Fis | P-value
AG3H555 | 0.0471 | 1
AG3H812 | -0.0615 | 1
AG3H746 | -0.054 | 1
AG3H93 | 0.2096 | 0.439
AG3H242 | -0.0033 | 1
AG3H817 | 0.1145 | 1
AG3H119 | -0.1017 | 1
AG3H577 | -0.0684 | 1
AG3H249 | -0.0519 | 1
AG3H59 | 0.0477 | 0.997
Spreadsheet: 751050d1633805856-indicate-pairs-based-on-given-battery-log-ranking-in-pairs-aligw-rev-1
Sheet: Batteries

Battery |  | # | Type | Indicated mAh | Measured mAh | % | Pairs
Brand |  | 1 | AA | 2450 | 2400
Brand |  | 2 | AA | 2450 | 2410
Brand |  | 3 | AA | 2450 | 2500
Brand |  | 4 | AA | 2450
Brand |  | 5 | AA | 2450
Brand |  | 6 | AA | 2450
Brand |  | 7 | AA | 2450
Brand |  | 8 | AA | 2450
Battery |  | # | Type | Indicated mAh | Measured mAh | % | Pairs
Brand |  | 1 | AA | 1900
Brand |  | 2 | AA | 1900
Brand |  | 3 | AA | 1900
Brand |  | 4 | AA | 1900
Brand |  | 5 | AA | 1900
Brand |  | 6 | AA | 1900
Brand |  | 7 | AA | 1900
Brand |  | 8 | AA | 1900
Battery |  | # | Type | Indicated mAh | Measured mAh | % | Pairs
Brand |  | 1 | AAA | 750
Brand |  | 2 | AAA | 750
Brand |  | 3 | AAA | 750
Brand |  | 4 | AAA | 750
Brand |  | 5 | AAA | 750
Brand |  | 6 | AAA | 750
Brand |  | 7 | AAA | 750
Brand |  | 8 | AAA | 750
Spreadsheet: 377951d1424213744-searching-multiple-columns-excel
Sheet: Sheet1

ID | ID | ID | ID | ID | Av ratio |  | ID | Ratio
comp4621_c0_seq1 |  |  |  |  | 1.0805 |  | [NAME]
comp5270_c0_seq1 |  |  |  |  | 0.9671700000000001 |  | comp52747_c0_seq1
comp8506_c1_seq1 |  |  |  |  | 0.80481 |  | comp52784_c0_seq2
comp11830_c0_seq1 |  |  |  |  | 1.5515 |  | comp13686_c0_seq1
comp11830_c0_seq2 |  |  |  |  | 1.007085 |  | comp13690_c0_seq2
comp11968_c0_seq1 | comp51030_c0_seq1 |  |  |  | 1.0134 |  | comp13722_c0_seq2
[NAME] | comp51046_c0_seq1 | [NAME] |  |  | 0.9030400000000001 |  | comp13725_c0_seq1
comp12117_c0_seq1 | comp51059_c0_seq1 | comp52738_c0_seq1 | comp53550_c0_seq1 | comp53699_c0_seq1 | 0.99701 |  | comp52862_c0_seq2
comp12128_c0_seq1 | comp51169_c0_seq1 | comp52747_c0_seq1 | [NAME] | comp53703_c0_seq1 | 1.011085 |  | comp29435_c0_seq1
comp12192_c1_seq1 | comp51336_c0_seq1 | comp52784_c0_seq2 | comp53659_c0_seq2 | [NAME] | NaN |  | comp29464_c0_seq1
comp12315_c0_seq1 | [NAME] | comp52838_c0_seq1 | comp53682_c1_seq1 |  | 0.93859 |  | comp29467_c0_seq1
comp12709_c0_seq2 | comp51494_c0_seq1 | comp52862_c0_seq2 | comp53686_c0_seq1 |  | 0.7583 |  | comp29473_c0_seq1
comp12834_c0_seq2 |  |  |  |  | 0.736905 |  | comp29475_c0_seq1
comp12853_c0_seq2 |  |  |  |  | 0.787385 |  | comp29482_c0_seq1
comp13043_c0_seq2 |  |  |  |  | 0.951795 |  | comp29484_c0_seq1
comp13219_c0_seq1 |  |  |  |  | 0.984475 |  | comp29499_c0_seq1
comp13358_c0_seq1 |  |  |  |  | 1.007245 |  | comp29516_c0_seq1
comp13359_c0_seq1 |  |  |  |  | 0.9880500000000001 |  | comp29530_c0_seq1
comp13359_c0_seq2 | comp51700_c0_seq1 |  |  |  | 1.00456 |  | comp52747_c0_seq1
comp13627_c0_seq1 | comp51762_c1_seq2 |  |  |  | 1.17065 |  | comp52784_c0_seq2
comp13686_c0_seq1 | comp51837_c1_seq1 | comp52784_c0_seq2 | comp52862_c0_seq2 |  | 0.9209449999999999 |  | comp52838_c0_seq1
comp13690_c0_seq2 | comp51879_c0_seq2 | comp52838_c0_seq1 |  |  | 1.0451 |  | comp40507_c0_seq1
comp13722_c0_seq2 | comp51924_c0_seq1 |  |  |  | 0.97426 |  | comp40677_c0_seq1
comp13725_c0_seq1 |  |  |  |  | 0.999345 |  | comp40824_c0_seq1
Spreadsheet: 79364d1279641699-excel-2007-summing-up-words-and-convert-to-numbers-scorecard-challenge
Sheet: 1st QTR

 |  |  |  |  | McOpCo SCORECARD CHALLENGE
 |  |  |  |  | FIRST QUATER RESULTS 2010
Key performance Indicators |  |  | Below Target (0) | Slightly Below Target (1) |  | Meets or Exceeds Target (2) |  | Outstanding (3) |  |  |  |  | Below Target
 |  |  |  |  |  |  |  |  |  |  |  |  | Slightly Below
Restuarants |  | 400 North |  | Cookstown |  | Maple |  | [NAME] |  | Rutherford |  |  | Meets or Exceeds
 |  |  |  |  |  |  |  |  |  |  |  |  | Outstanding
Performance
Guest Counts
Sales vs. Last year
Build Your Peak
People
Crew Commitment
90 Day Terms(T6M)
Conv. and [NAME].
Late Night G.C
Drive Thru G.C
CSO
CSO (T6M)
[NAME] TET
Dine In TET
KVS Times
Mornings and Coffee
Morning G.C
Coffee Unit Growth
Profit
Food (vs. [NAME])
Food (FOB T3M)
Labour TPMH
Labour ACR
Labour (TPMH T3M)
P.A.C
Total Points