tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 801097d1666083311-is-there-a-search-or-filter-function-that-works-on-partial-results-for-strings-partial-search-example
Sheet: Sheet1

Names | Match |  |  |  |  |  |  | Search |  | Matches |  | Wanted Matches
[NAME] |  |  |  |  |  |  |  | Katrin |  |  |  | [NAME]
Catherin | 0.8333333333333334 |  |  |  |  |  |  |  |  |  |  | Catherin
Katrin | 1 |  |  |  |  |  |  |  |  |  |  | Katrin
[NAME] | 1 |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | 1 |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | 0.3333333333333333
Mikael | 0.3333333333333333
Micael | 0.3333333333333333
[NAME] | 0.5
Spreadsheet: 886358d1736383002-formula-that-adds-up-weekly-month-and-ytd-data-from-my-table-formula-that-adds-up-weekly-month-and-ytd-data-from-my-table
Sheet: Daily_Figures

 | BH
Date : | 2025-01-01 00:00:00
RESULT Team 1 |  | 3 | 12 |  |  | 10 | 19 | 23 | 3 | 12 |  |  | 19 | 23 | 3
RESULT Team 2 |  | 19 | 14 |  |  | 21 | 27 | 33 | 19 | 14 |  |  | 27 | 33 | 19
RESULT Team 3 |  | 0 | 0 |  |  | 0 | 0 | 3 | 0 | 0 |  |  | 0 | 3 | 0
RESULT Team 4 |  | 21 | 33 |  |  | 35 | 54 | 51 | 21 | 33 |  |  | 54 | 51 | 21
RESULT Team 5 |  | 3 | 2 |  |  | 7 | 5 | 8 | 3 | 2 |  |  | 5 | 8 | 3
RESULT Team 6 |  | 4 | 7 |  |  | 5 | 10 | 6 | 4 | 7 |  |  | 10 | 6 | 4
Today's Date | 2025-01-15 00:00:00
TOTALS : | This Week | Average Per Day for Week |  | LAST Week | Average Per Day for Week |  | This Month | Average Per Day for Month |  | LAST Month | Average Per Day for Month |  | YTD | Average Per Day for Year | Average per WEEK | Average per MONTH
RESULT Team 1
RESULT Team 2
RESULT Team 3
RESULT Team 4
RESULT Team 5
RESULT Team 6
[NAME]
 | TOTALS for SAT - FRI Active Week | Average per day is over 5 DAYS (Mon - Fri) SAT & SUN are overtime and is added to Mon. |  | TOTALS for SAT - FRI Previous Week | Average per day is over 5 DAYS (Mon - Fri) SAT & SUN are overtime and is added to Mon. |  | TOTALS for ACTIVE Month 1st - 31st | Average per day is over the number of WORK DAYS in the Active month (MON-FRI) SAT & SUN are overtime and is added to Mon. |  | TOTALS for PREVIOUS Month 1st - 31st | Average per day is over the number of WORK DAYS in the PREVIOUS month (MON-FRI) SAT & SUN are overtime and is added to Mon. |  | TOTALS YTD | Average per day is over the number of WORK DAYS in the YEAR (MON-FRI) SAT & SUN are overtime and is added to Mon. | Average per day is over the number of WEEKS gone, in the YEAR (MON-FRI) SAT & SUN are overtime and is added to Mon. | Average per day is over the number of MONTHS gone, in the YEAR (MON-FRI) SAT & SUN are overtime and is added to Mon.
Spreadsheet: 101990d1300058635-refresh-cell-when-source-for-data-validation-has-changed-copy-of-test3
Sheet: Source

 | Code | Country |  |  |  | Testing Phase | Code
 | AU | Australia |  |  | [NAME] | Phase 4 | 12-101
 | BEL | Belgium |  |  | item2 | Phase 2 | 12-102
 | [NAME] | Benelux |  |  | item3 | Remediation | 12-103
 | CA | Canada |  |  | item4 | Year End | 12-104
 | CH | China |  |  | [NAME]
 | DE | Denmark |  |  | item6
 | FI | Finland |  |  | [NAME]
 | FR | France |  |  | item8
 | DE | Germany |  |  | item9
 | IT | Italy |  |  | item10
 | IN | India |  |  | item11
 | MX | Mexico |  |  | item12
 | NL | Netherlands |  |  | item13
 | NO | Nordics (All countries) |  |  | item14
 | PL | Poland |  |  | item15
 | PT | Portugal |  |  | item16
 | ES | Spain |  |  | item17
 | SE | Sweden |  |  | item18
 | UK | United Kingdom |  |  | item19
 | US | United States |  |  | item20
 | EU | Europe |  |  | item21
Spreadsheet: 134815d1325644644-extracting-ms-project-data-extract-forum-help-tollgates-to-milestones
Sheet: Sheet1

 | Extracted | 2012-01-03 00:00:00
 | Time Extracted | 17:30:00
 |  |  |  | AS IS Extraction |  |  |  |  |  |  |  | Ignore Times
 | Task Name | Notes / Comments | Planned Duration | Planned Start | Planned Finish | Phyical % Complete | Actual Finish | Resource Names | Predecessors |  |  | Planned Start | Planned Finish | Extracted Planned Duration (Days) | Extracted Planned Duration (Weeks) | Extracted Planned Duration (Months)
 | Company Z - Company A Program | 01/03/12 Draft | 111.4 wks? | 2011-12-15 08:00:00 | 2014-01-31 17:00:00 | 0 | NA
 | Company A Project Planning |  | 6 wks | 2011-12-19 08:00:00 | 2012-01-27 17:00:00 | 0 | NA | All Associated Company A Divisions
 | Company A Internal Program & Project Kickoff |  | 6 wks | 2011-12-19 08:00:00 | 2012-01-27 17:00:00 | 0 | NA | Company A Mgnt. & Company Z POCs
 | Define Objectives |  | 3 wks | 2011-12-19 08:00:00 | 2012-01-06 17:00:00 | 0 | NA
 | Define Project Scope |  | 5 wks | 2011-12-19 08:00:00 | 2012-01-20 17:00:00 | 0 | NA
 | Develop Project Plan |  | 5 wks | 2011-12-19 08:00:00 | 2012-01-20 17:00:00 | 0 | NA
 | Review Project Plan |  | 5 wks | 2011-12-19 08:00:00 | 2012-01-20 17:00:00 | 0 | NA
 | Revise Project Plan |  | 5 wks | 2011-12-19 08:00:00 | 2012-01-20 17:00:00 | 0 | NA
 | Re-Review Project Plan |  | 5 wks | 2011-12-19 08:00:00 | 2012-01-20 17:00:00 | 0 | NA
 | Company A Internal Approval |  | 1 wk | 2012-01-23 08:00:00 | 2012-01-27 17:00:00 | 0 | NA |  | 3,4,8,5,6,7
 | Company A Kickoff Meeting with Company Z |  | 3 wks? | 2012-01-16 08:00:00 | 2012-02-03 17:00:00 | 0 | NA
 | Company A Kickoff Meeting with Company Z | Company A Mgnt. & Company Z  Mgnt. & POCs | 3 wks? | 2012-01-16 08:00:00 | 2012-02-03 17:00:00 | 0 | NA | Company A Mgnt. & Company Z  Mgnt. & POCs
 | Company A Presents Project Plan |  | 3 wks? | 2012-01-16 08:00:00 | 2012-02-03 17:00:00 | 0 | NA
 | If necessary, Revise Project Plan |  | 3 wks? | 2012-01-16 08:00:00 | 2012-02-03 17:00:00 | 0 | NA
 | Re-Review Project Plan with Company Z |  | 3 wks? | 2012-01-16 08:00:00 | 2012-02-03 17:00:00 | 0 | NA
 | Company Z Approves Program & Project Plan |  | 0 wks | 2012-02-03 17:00:00 | 2012-02-03 17:00:00 | 0 | NA |  | 16,14,15
Spreadsheet: daren_farmer__5605__Equistar Activity 092000
Sheet: SEPT00

 | EQUISTAR  ACTIVITY for  September, 2000 |  |  |  |  |  |  |  |  | file name: Equistar Activity 092000.xls
 | Effective 9/19/00
 | Meter # |  | Deal # |  | Price ($) |  | Volume |  | Matrix
 | 1062
 | 1334 |  |  |  |  |  | 0
 | 1373 |  |  |  | Greater of $2.64 or Index - $.03 |  | 0 |  | ENA
 | 1373 | ENA | 380735 |  | 4.35 or Index-$.10 |  | 9000 |  | HPLC
 | 1373 |  | 165373 |  | Greater of $2.15 |  | 10000 |  | HPLC
 | 1373 |  | 128806 |  | Greater of $2.05 or Index - $.055 |  | 5000 |  | HPLC
 | 1384 | ENA | 240061 |  | $2.20 or Index -$.05 |  | 5000 |  | HPLC
 | 1399 |  | 165372 |  | $2.11or Index -$.07 |  | 5000 |  | HPLC
 | 1552 |  | 202387 |  | $2.21 or Index -$.07 |  | 5000 |  | HPLC
 | 1552 | ENA | 380735 |  | 4.35 or Index-$.10 |  | 0 |  | HPLC
 | 1552
 | 1553 |  | 380735 |  | 4.35 or Index-$.10 |  | 1000 |  | HPLC
 | 8024 | ENA | 240061 |  | $2.20 or Index -$.05 |  | 5000 |  | HPLC
 | 1266/1165 |  |  |  |  |  | 0 |  | HPLC
 |  |  |  |  |  |  |  |  | Less: Phillips {0.0/d}, [NAME] {15.0/d}
 |  |  |  |  |  |  |  |  | Third Party ( Sempra; 20.0/d )
NOTE:  Highlighted rows mean changes. |  |  |  |  |  |  |  |  | Note:   Channel / Syngas :    = 20.0/d
 |  |  |  |  |  |  | Mcnic ;  10.0 HPL & 5.0 ENA
Spreadsheet: 781731d1653503148-count-times-data-matches-in-two-columns-headcount-check
Sheet: Sheet1

2021 |  | 2022 |  | [NAME] is to compare the 2021 column against the 2022 column, and return the number of instances an employee ID number is a match.
0004074 |  | 0004074
0010210 |  | 0010210
0010269 |  | 0010269
1078263 |  | 1077605
1078268 |  | 1077607
1078276 |  | 1077609
1078286 |  | 1077611
1078296 |  | 1077612
1078312 |  | 1077613
1078314 |  | 1077614
1078327 |  | 1077620
1078329 |  | 1077621
1078343 |  | 1077623
1078346 |  | 1077624
1078349 |  | 1077628
1078352 |  | 1077629
1078353 |  | 1077630
1078354 |  | 1077631
1078377 |  | 1077633
1078385 |  | 1077635
1078397 |  | 1077637
1569376 |  | 1543698
1627577 |  | 1589684
1627580 |  | 1589911
1627645 |  | 1589959
1627669 |  | 1589992
Spreadsheet: 862310d1710061387-summarizing-no-of-orders-from-the-different-sheets-to-a-table-master-plan-202403-rev-2
Sheet: Summary

 | Quantity of Orders
 | Trade | Work Type | 2024
 |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | MVAC | PM
 |  | CM
 |  | A+A
 | [NAME] | PM
 |  | CM
 |  | A+A
 | UPS | PM
 |  | CM
 |  | A+A
 | Elect | PM
 |  | CM
 |  | A+A
 |  | PITC
 | BA | PM
 |  | CM
 |  | A+A
Spreadsheet: 219416d1362753986-top-3-sold-products-and-qyty-by-customer-from-list-top-3-in-list-formula
Sheet: Sheet1

Customer Name | Product | Totals
A | 1 | 3
A |  | 10
A |  | 3
A |  | 1 |  |  | Desired Results
A |  | 2
A |  | 6 |  |  | Customer | Product | Totals
A |  | 2 |  |  | A
A |  | 3 |  |  | A
A |  | 1 |  |  | A |  |  | Tie - Take the 1st product
A |  | 1 |  |  | B
A |  | 2 |  |  | B
A |  | 2 |  |  | B
B | 1 | 1 |  |  | C
B |  | 6 |  |  | C
B |  | 5 |  |  | C
B |  | 8
B |  | 9
B |  | 3
B |  | 14
B |  | 3
B |  | 1
B |  | 10
B |  | 2
B |  | 3
B |  | 1
B |  | 5
C | 1 | 20
C |  | 8
C |  | 1
C |  | 1
C |  | 2
C |  | 2
C |  | 6
C |  | 3
C |  | 2
C |  | 83
C |  | 10
C |  | 72
C |  | 4
C |  | 10
C |  | 8
C |  | 14
C |  | 2
C |  | 1
C |  | 60
C |  | 5
C |  | 61
C |  | 4
Spreadsheet: 120864d1315592590-column-into-several-rows-esimerkki
Sheet: Taul3

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VOITTO TN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.12387166
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.274884271
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.546196176
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.055047893
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.141781466
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.213876076
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.333475278
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.31086718
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.14732413
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.222103833
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.307552124
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.323019913
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 03f54fe3-ac4f-4ab3-867f-1f622601bfdb
Sheet: Case Type Codes

caseTypeCode | Description | Associated to Case Category
submissions.submission.filingInformation.caseInformation.caseTypeCode
CV_AE | Arrest Expungement | [NAME]
CV_AN | Administrative Agency | [NAME]
CV_AO | Other Civil Appeals | [NAME]
CV_CB | [NAME] | [NAME]
CV_CD | Employment Dispute - Discrimination | [NAME]
[NAME]_ CE | Emplyment Dispute - Other | [NAME]
CV_ CF | Fraud | [NAME]
CV_CG | Landlord/Tenant Dispute - Other | [NAME]
CV_CH | Landlord/Tenant - Unlawful Detainer | [NAME]
CV_CM | Mortgage Foreclosure | [NAME]
CV_CN | Contact | [NAME]
CV_CO | Other Contract | [NAME]
CV_CP | [NAME] (Debt Collection) | [NAME]
CV_HC | [NAME] | [NAME]
CV_IA | 60-1507 | [NAME]
CV_OR | Other Writs | [NAME]
CV_OT | Other | [NAME]
CV_PJ | Post Judgment Elevation Limited Ch 61 to [NAME] 60 | [NAME]
CV_PP | Personal Property | [NAME]
CV_RD | Eminent Domain | [NAME]
CV_RE | Real Estate | [NAME]
CV_RP | Other Real Property | [NAME]
CV_TA | Tax Appeal | [NAME]
CV_TB | Asbestos Product Liability | [NAME]
CV_TC | Automobile Tort | [NAME]
CV_TI | Intentional Tort | [NAME]
CV_TK | Legal Malpractice | [NAME]
CV_TM | Medical Malpractice | [NAME]
[NAME]_ TN | Other Professional Malpractice | [NAME]
CV_TO | Other Tort | [NAME]
CV_TP | Premises Liability | [NAME]
CV_TR | Transfer Limited Ch 61 to [NAME] 60 | [NAME]
CV_TT | Tort | [NAME]
CV_TU | Slander/Libel/Defamation | [NAME]
CV_TV | Tobacco Product Liability | [NAME]
CV_TX | Toxic/Other Product Liability | [NAME]
DM_DS | Marriage Dissolution/Divorce | DM
DM_DV | Divorce, Annulment, Separate Maintenance | DM
DM_OD | Domestic Other | DM
DM_PA | Paternity | DM
DM_PF | Protection from Abuse | DM
DM_PS | Protection from Stalking | DM
DM_RI | [NAME] In | DM
DM_RO | [NAME] Out | DM
DM_SU | [NAME], Custody, Support | DM
DM_US | UIFSA | DM
LM_CA | [NAME] | LM
LM_CJ | Employment Dispute - Discrimination | LM
[NAME] | Employment Dispute - Other | LM
LM_CL | Contract | LM
LM_CQ | Fraud | LM
LM_CS | [NAME] (Debt Collection) | LM
[NAME] | Other Contract | LM
LM_LA | Asbestos Product Liability | LM
LM_LB | Automobile Tort | LM
LM_LE | Intentional Tort | LM
[NAME] | Legal Malpractive | LM
LM_LN | Medical Malpractice | LM
LM_LO | Other Professional Malpractice | LM
LM_LT | Other Tort | LM
LM_LU | Premises Liability | LM
LM_LV | Slander/Libel/Defamation | LM
LM_LW | Tobacco Product Liability | LM
LM_LX | Toxic/Other Product Liability | LM
LM_OL | Other Limited | LM
LM_PL | Personal Property | LM
LM_PO | Other Real Property | LM
LM_RA | Eminent Domain | LM
LM_RL | Real Estate | LM
LM_RM | Mortgage Foreclosure | LM
LM_RR | Landlord/Tenant Dispute-Other | LM
LM_RU | Landlord/Tenant - Unlawful Detainer | LM
LM_TL | Tort | LM
ST_ST | State Tax | ST
 | Highlighted fields indicate that this is an inactive sub-type in FullCourt
 | What about Shawnee County existing case subyptes after the conversion that will be marked as inactive?
Spreadsheet: 274600d1383158014-mapping-data-to-different-spreadsheets-amanda
Sheet: Submitted

Submitted
Current Status | Date | Last Name | Lender Name | Type of Loan | [NAME] | Purpose | Prop Type | Title Company | Loan Officer | Loan Amount | Processor | Notes |  | Match (All data Row)
Spreadsheet: 147884d1333026691-conditional-formatting-in-excel-2010-example
Sheet: Home Page

Sheet 1 | Sheet 8 | Sheet 15
Sheet 2 | Sheet 9 | Sheet 16
Sheet 3 | Sheet 10 | Sheet 17
Sheet 4 | Sheet 11 | Sheet 18
Sheet 5 | Sheet 12 | Sheet 19
Sheet 6 | Sheet 13 | Sheet 20
Sheet 7 | Sheet 14 | Sheet 21
Spreadsheet: 440232d1452703404-vacation-tracking-from-an-anniversary-date-from-year-to-year-vacation-tracking-2016
Sheet: September

Employee Absence Schedule
September | Dates of Absence
Employee Name | 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 |  | Total Hours
A |  |  |  |  | H
B |  |  |  |  | H
C |  |  |  |  | H
D |  |  |  |  | H
E |  |  |  |  | H
F |  |  |  |  | H
G |  |  |  |  | H
H |  |  |  |  | H
J |  |  |  |  | H
K |  |  |  |  | H
L |  |  |  |  | H
N |  |  |  |  | H
O |  |  |  |  | H
Spreadsheet: 759557d1639591910-sum-column-based-on-values-in-2-other-columns-audits-master
Sheet: DC 21 Audits Master

[NAME] | Errors | Cases
[NAME] |  | 144 |  |  | [NAME]
[NAME] | 1 | 182 |  |  | [NAME]
Luc | 1 | 187 |  |  | [NAME]
[NAME] |  | 265 |  |  | will
[NAME] |  | 226
Brae |  | 241
[NAME] |  | 90
[NAME] | 400000 | 150
[NAME] | 0 | 100
[NAME] | 0 | 80
Ry | 0 | 60
[NAME] | 1 | 40
Will | 1 | 880
Will |  | 100
Jo | 1 | 220
[NAME] | 0 | 233
[NAME] | 1 | 80
[NAME] | 1 | 232
[NAME] | 1 | 234
Will |  | 259
JR |  | 191
Ry |  | 191
Spreadsheet: 729741d1619299954-excel-vlookup-with-if-to-match-date-between-two-dates-testfile
Sheet: Test

ID | Name | Time | Expected Result |  | ID | Name | Start | End
32429170 | CI_TBD | 2021-01-01 00:03:28 | 1889188 |  | 1889188 | CI_TBD | 2021-01-01 00:00:28 | 2021-01-02 07:00:25
32429171 | CI_TBD | 2021-01-01 00:00:00 | False |  | 2075878 | MDIBIS2 (I23736283) | 2021-03-23 06:59:47 | 2021-03-23 07:00:25
32429172 | ZA_GENERIC_CI (ZA_GENERIC_CI) | 2021-01-01 01:21:40 | #N/A |  | 2085523 | MDIBIS2 (I23736283) | 2021-01-01 01:06:32 | 2021-01-20 07:34:09
32429173 | CI_TBD | 2021-01-01 01:18:47 | 1889188 |  | 2092108 | AZGLGBNEVLA37 (S23219879) | 2021-01-01 01:00:22 | 2021-03-22 07:47:09
32429174 | AZGLGBNEVLA37 (S23219879) | 2021-01-01 01:34:22 | 2092108 |  | 2104453 | 44087 (S19390720) | 2021-03-22 07:47:04 | 2021-03-22 07:47:09
32429175 | MX_FAURECIA | 2021-01-01 01:38:17 | False |  | 2110861 | DHUB5728 | 2021-01-01 01:00:22 | 2021-01-01 01:48:22
32429176 | DHUB5728 | 2021-01-01 01:47:30 | 2110861 |  | 2121505 | 47834 (S22956950) | 2021-03-22 07:47:04 | 2021-03-22 07:47:09
32429177 | CI_TBD2 | 2021-01-01 01:54:08 | #N/A |  | 2121710 | 6511 (S19674359) | 2021-03-22 07:47:04 | 2021-03-22 07:47:09
32429179 | MU2GCLG0 | 2021-01-01 02:00:53 | False |  | 2122917 | 6382 (S22792138) | 2021-03-22 07:47:04 | 2021-03-22 07:47:09
32429180 | MDIBIS2 (I23736283) | 2021-01-01 02:06:32 | 2085523 |  | 2123462 | S-8453 (S22920907) | 2021-03-22 07:47:04 | 2021-03-22 07:47:09
 |  |  |  |  | 2127379 | MX_FAURECIA | 2021-03-22 07:47:04 | 2021-03-22 07:47:09
 |  |  |  |  | 2135355 | MU2GCLG0 | 2021-03-22 07:47:04 | 2021-03-22 07:47:09
Spreadsheet: 8577aac3-6e5b-4bd1-a681-faad0785a64f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5713 | 7671 | [NAME] | [NAME] | GBR | 0 | 00:38:31 | 00:05:01 | 01:12:10 | 00:02:40 | 01:01:25 | 1 | 02:59:45
5713 | 32834 | [NAME] | Nunnington | GBR | 0 | 00:30:36 | [NAME] | 01:25:40 | 00:03:54 | 01:07:07 | 2 | 03:12:52
5713 | 16871 | [NAME] | Dimmock | GBR | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
Spreadsheet: 89928d1289671617-i-get-an-error-in-index-and-match-formula-index-and-match-formula
Sheet: Data

 | COUNTRY | Stage | AGE | Message
 | UK | 10 | 3
 | UK | 10 | 45
 | UK | 10 | 7
 | UK | 10 | 8
 | UK | 10 | 2
 | UK | 10 | 1
 | UK | 10 | 7
 | UAE | 10 | 11
 | UAE | 10 | 12
 | UAE | 10 | 12
 | UAE | 10 | 4
 | KW | 10 | 2
 | KW | 10 | 4
 | KW | 10 | 6
 | KW | 10 | 8
 | KW | 10 | 10
 | KW | 10 | 12
 | KW | 10 | 13
 | KW | 10 | 14
 | KW | 10 | 15
 | KW | 10 | 16
 | UK | 20 | 5
 | UK | 20 | 6
 | UK | 20 | 7
 | UAE | 20 | 0
 | UAE | 20 | 0
 | UAE | 20 | 11
 | KW | 20 | 7
 | KW | 20 | 8
 | KW | 20 | 1
 | KW | 20 | 2
 | KW | 20 | 3
 | KW | 20 | 10
Spreadsheet: 747845d1631726236-counting-text-across-multiple-rows-and-columns-sample3-1-ans2
Sheet: SUMMARY

 |  |  | Your formula | Corrected formula
Location | Department | Floor | Held Sessions
Location A | URGENT CARE | 1
Location B | PEDIATRICS | 1
Location C | INTERNAL MEDICINE | 1
Location C | PEDIATRICS | 2
Location D | OB-GYN | 1
Location D | ORTHOPEDICS | 1
Location D | PAIN MANAGEMENT | 1
Location D | URGENT CARE | 1
Location D | ENT | 2
Location D | HEMATOLOGY/ONCOLOGY | 2
Location D | INTERNAL MEDICINE | 2
Location D | OPHTHALMOLOGY | 2
Location D | PODIATRY | 2
Location D | SHARED | 2
Location D | ENDOCRINOLOGY | 3
Location D | INTERNAL MEDICINE | 3
Location D | PEDIATRICS | 3
Location D | SHARED | 3
Spreadsheet: 77746d1278186048-excel-2007-mileages-mileage-log-with-reimbursement
Sheet: Mileage Log and Reimbursement

 | Mileage Log and Reimbursement Form
 | Employee Name |  |  |  |  | Rate Per Mile | 0.35
 | Employee ID |  |  |  |  | For Period
 | Vehicle Description |  |  |  |  | Total Mileage
 | Authorised By |  |  |  |  | Total Reimbursement
Date | Starting Location | Destination | Description/Notes | Toll Out bound | [NAME] | Mileage | Reimbursement
2010-06-21 00:00:00 | Telford | Banbury |  | 5 |  | 88.2
 |  |  |  |  |  | 0
 |  |  | Totals
Spreadsheet: 454074d1459622268-want-to-match-time-in-out-by-employee-id-to-cell-from-punch-card-data-test-in-out-01-2-
Sheet: Personal

4900651 | AAA
4900652
4900653
4900654
4900655
4900656
4900657
4900658
4900659
4900660
4900661
4900662
4900663
4900664
4900665
4900666
4900667
4900668
4900669
4900670
4900671
4900672
4900673
4900674
4900675
4900676
4900677
4900678
4900679
4900680
4900681
4900682
4900683
4900684
4900685
4900686
4900687
4900688
4900689
4900690
4900691
4900692
4900693
4900694
4900765
4900822
4900831
4900842
5000913
5101102
5101103
5101104
5101166
5101218
5101219
5101246
5101312
5101313
5101340
5101428
5201506
5201513
5201514
5201518
5201548
5201772
5302807
5302828
5302966
5303017
5303057
5303255
5303370
5303660
5303929
5404086
5404314
5405257
5505792
5506454
5506571
5608196
5608226
5608375
5608448
5709387
5709388
5709539
5709581
5709802
5709803
5709804
5709852
5709853
5709888
5810076
5810077
5810078
5810079
5810080
5810227
5810500
Spreadsheet: 186820d1350240810-stock-register-calculation-mechanic-test
Sheet: Sheet1

1 February 2012 to 28 February 2012
Stock Type | On hand 1 Feb 2012 | Incoming Quantity | Quantity in Stock | Until next order (min of 80) | Used (During month) | On hand 28 Feb 2012
Stock 1 | 80 |  |  |  | 25
Stock 2 | 80 |  |  |  | 16
Stock 3 | 80 |  |  |  | 0
Stock 4 | 80 |  |  |  | 7
Stock 5 | 80 |  |  |  | 79
1 March 2012 to 31 March 2012
Stock Type | On hand 1 Mar 2012 | Incoming Quantity | Quantity in Stock | Until next order (min of 80) | Used (During month) | On hand 31 Mar 2012
Stock 1
Stock 2
Stock 3
Stock 4
Stock 5
Spreadsheet: 165371d1341204676-multiple-row-and-column-based-record-to-linear-format-10-06-12-lost
Sheet: North West Distt.

Control Room No | 6847 | State | DELHI
FIR Number | 190/12 | District | NORTH WEST DISTRICT
FIR Date | 2012-06-10 00:00:00 | Police Station | MUKHERJI NAGAR
Vehicle Type | TWO WHEELER | Registration Number | DL5SAB3225
[NAME] | 2W - YAMAHA GLADIATOR | Engine Number | 24392
[NAME] | 2009 | Chasis Number | 25103
Vehicle Color | RED DARK | Phone Number | 9953615862
Complainant | DEEPAK KUMAR | Address | -
Stolen From | [NAME] SE KINGSWAY CAMP
Status | STOLEN/THEFT | Report Dt./Time on ZIPNET | 2012-06-10 00:07:00.110000
Spreadsheet: 869621d1716221631-index-and-match-multiple-rows-only-returning-top-row-gw_test3-aligw
Sheet: Sheet3

 | Dataset |  |  |  |  |  | Index and Match retrieve
 | Unique ID | Town | In the area? | Urban community | IMD 1 - 3 |  | Unique ID | In the area? | Urban community | IMD 1 - 3
 | A2G00043 | Bury | No | No | Yes |  |  | No
 | A2G00044 | Matlock | No | No | No |  | A2G00044 | Yes
 | A2G00044 | Matlock | Yes | No | Yes |  | A2G00045 | No
 | A2G00045 | [NAME] | No | No | No |  | A2G00052 | Yes
 | A2G00052 | Rochdale | Yes | No | No |  | A2G00053 | Yes
 | A2G00053 | Oldham | Yes | No | No |  | A2G00054 | Yes
 | A2G00054 | Stockport | Yes | No | No |  | A2G00065 | No
 | A2G00065 | [NAME] | No | No | No |  | A2G00067 | No
 | A2G00067 | [NAME] | No | No | No |  | A2G00078 | Yes
 | A2G00078 | Partington | No | Yes | No
 | A2G00078 | Partington | Yes | Yes | Yes