tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1e1a238a-dc82-40f0-a314-09989f3d2cd8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 43. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (VIC), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413792J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413793K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413794L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413795R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413796T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413797V | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413798W | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413799X | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413800W | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413801X | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413802A | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 880126d1727753587-race-series-with-two-drop-races-sample-race-spreadsheet
Sheet: Sheet1

Overall Series Result | Name | Race 1 | Race 2 | Race 3 | Race 4 | Race 5 | Race 6 | Total Points (Best 4 of 6 Races)
1 | Racer | 1 | 11 | 2 | 1 | 2 | 9
2 | Racer | 6 | 3 | 8 | 5 | 3 | 4
3 | Racer | 2 | 5 | 3 | 9 | 5 | 7
Spreadsheet: 748820d1632371441-sum-across-multiple-sheets-with-sheets-names-as-references-demo
Sheet: Totals

 | Location | County by City | Count by City
 | Total | 1400 | 750
 | San Diego
 | Chicago
 | Denver
 | Calc Total
 | Lab | E$9
 | Shape | County by City | Count by City
0 | type 1
1 | Type 2
2 | type 3
3 | type 4
4 | type 5
5 | type 6
6 | type 7
7 | type 8
8 | type 9
9 | type 10
10 | Calc Total
11
12
13
14
Spreadsheet: 872034d1718382519-sorting-from-3-lists-sorting
Sheet: Bid Package 1

[NAME]
[NAME] 1 |  | [NAME] 2
[NAME] |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | [NAME]
 | [NAME] 2 | [NAME] 3 | [NAME] 4
Brokered / Self Perform Concrete | Masonry / Stone | Precast Concrete | Selective Demolition
Building & Foundation Concrete | Rough Carpentry | Structural Steel | Site and Structure Demolition
Final Cleaning | Millwork and Finish Carpentry | Dampproofing and Waterproofing | Expansion Joints
Surveying |  | EIFS | Metal Roofing & Wall Panels
[NAME] |  | Membrane Roofing
Building Siding |  | Fireproofing and Containment
[NAME] and Firestopping
Spray Insulation
Weather and [NAME]
Spreadsheet: 58711d1258987379-conditional-formatting-over-2-worksheets-sample
Sheet: PSE

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ref.
 | MONTH |  |  |  | Day: | M | T | W | T | F |  | M | T | W | T | F |  | M | T | W | T | F |  | M | T | W | T | F
 |  |  |  |  | Date:
 |  |  |  |  | Initials:
 |  | DAILY CHECKS (end of day)
 | 1 | Have the comms cells documents been updated?
 | 2 | Did the comms cells meeting take place?
 | 3 | Were Agent stats produced and published? (IMT email)
 | 4 | Were the Performance stats reviewed in the Comms Cell and any issues progressed via the 3Cs?  (spot check 1 Agent)
 | 5 | Did the relevant PSEs provide appropriate feedback for development issues? (Positive feedback in Comms Cell, Developments in 1:1 - Spot check 1 Agent)
 | 6 | Are actions in place to resolve 3C's?  (Check Comms Cell)
 | 7 | Are actions in place for identified solutions in Problem Solving?  ([NAME])
 | 8 | Have outstanding returns to work and lates been completed?
 | 9 | Was the correct process carried out if a major incident took place?
 |  | MONTHLY CHECKS: Last Friday of the month
 | 10 | Has agent call coaching been recorded and scored? (Check comms cell)
 | 11 | Have call handling processes been adhered to? (Call coaching 'standards' KPI)
 | 12 | Have agent 1:1s been completed?
 | 13 | New processes are documented, communicated to teams and available on [NAME] and knowledgebase
 | 14 | Have team meetings taken place this month?
 | 15 | Has a problem solving session taken place?
 |  |  |  |  |  | Yes to Question    = |  |  |  |  |  |  |  |  |  | No to Question   = |  |  |  |  |  |  | X |  | ( transfer to 3C sheet)
 | Remember to move the magnet on the board
 | Date | Raised by |  | Comments
Spreadsheet: 1e521a96-5da8-453d-8a8c-e9f6ebf17128
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 4. PERSONAL FINANCE COMMITMENTS By Purpose (Fixed Loans): Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
New motor cars and station wagons ; |  |  | Original | A2413473X | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
Used motor cars and station wagons ; |  |  | Original | A2413474A | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
Total motor vehicles ; |  |  | Original | A2413475C | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
Individual residential blocks of land ; |  |  | Original | A2413476F | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
Unsecured finance for owner occupation ; |  |  | Original | A2413477J | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
Debt consolidation ; |  |  | Original | A2413478K | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
Refinancing ; |  |  | Original | A2413479L | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
Other ; |  |  | Original | A2413480W | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | DERIVED | Month | 1
TOTAL ; |  |  | Original | A2413481X | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 100015d1298501725-double-vlookup-is-it-possible-book4
Sheet: Sheet1

Whse | Part Code | Color
B1 | 1 | Blue
B1 | 1 | Yellow
B1 | 1 | White
B1 | 1 | Red
A1 | 1 | Blue
A1 | 1 | Yellow
A1 | 3 | White
A1 | 3 | Red
Spreadsheet: 54730d1254793154-book-recommendation-to-learn-excel-want-a-macro-to-extract-tickers-pivot-table-temp
Sheet: Sheet2

2009-09-30 00:00:00 | [NAME] | TLM-T
2009-09-30 00:00:00 | [NAME] | PGF.UN-T
2009-09-30 00:00:00 | [NAME] | [NAME]-T
2009-09-29 00:00:00 | Prakash Hariharan | VET.UN-T
2009-09-28 00:00:00 | [NAME] | ECA-T
2009-09-28 00:00:00 | [NAME] | HES-N
2009-09-28 00:00:00 | [NAME] | CNQ-T
2009-09-25 00:00:00 | [NAME] | SCP-T
2009-09-25 00:00:00 | [NAME] | MRZ-X
2009-09-25 00:00:00 | [NAME] | EVG-X
2009-09-24 00:00:00 | [NAME] | TEVA-Q
2009-09-24 00:00:00 | [NAME] | ATD.B-T
2009-09-24 00:00:00 | [NAME] | XLY-N
2009-09-23 00:00:00 | [NAME] | MFC-T
2009-09-23 00:00:00 | [NAME] | IGM-T
2009-09-23 00:00:00 | [NAME] | RCI.B-T
2009-09-22 00:00:00 | [NAME] | CQE-T
2009-09-22 00:00:00 | [NAME] | GLM.A-X
2009-09-22 00:00:00 | [NAME] | ECA-T
2009-09-21 00:00:00 | [NAME] | SQM-N
2009-09-21 00:00:00 | [NAME] | FWLT-Q
2009-09-18 00:00:00 | [NAME] | AGI-T
2009-09-18 00:00:00 | [NAME] | GNA-T
2009-09-18 00:00:00 | [NAME] | CTQ-T
Spreadsheet: 752029d1634542354-excel-reporting-on-daily-and-monthly-basis-categorically-1
Sheet: Report

Summary
Start Week Containing
Week Ending
 | Category | Project |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Hrs
Total Hours:
 |  | Regular Hours:
 |  | OT Hours:
Note: Use increments of 0.25 (15 minutes) when recording hours.
Employee Signature |  |  | Date
Supervisor Signature |  |  | Date
[NAME]: [Name]
Spreadsheet: 715029d1611515115-dynamic-array-searchable-dropdown-samplerecipe
Sheet: Recipes Entry

 |  | RECIPE TEMPLATE
 |  | Recipe # | Main Recipe Type | Recipe Name |  | Add'l Recipe Type
 |  |  |  |  |  | Filling | False |  |  | False
 |  | Recipe Yield |  |  |  | RECIPE COST
 |  | Recipe Time (in minutes) |  | 0
 |  | Recipe [NAME] (CAKE RECIPES ONLY) |  | 0.6666666666666666 | Full
 |  |  |  |  |  | [NAME] | False
 |  | Qty | Measurement | Ingredient | Price | Icing Dam | False |  |  | True
 |  |  |  |  |  |  |  |  |  | True
Spreadsheet: 711787d1609906404-tricky-formula-to-match-data-in-3-column-or-disregard-a-column-if-not-applicable-sample-file-2-2-
Sheet: Sumproduct

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lookup
Location 2 |  |  |  |  |  |  |  |  |  | Housekeeper | Location 1 | Arizona | 15 |  |  |  | Location 1 | Arizona
 |  |  |  |  |  |  |  |  |  | Landscaper |  | Arizona | 32 |  |  |  | Location 2 | Arizona
Arizona |  |  |  |  |  |  |  |  |  | Manager |  | Arizona | 50 |  |  |  | Location 3 | Colorado
 |  |  |  |  |  |  |  |  |  | Housekeeper |  | Arizona | 15.5 |  |  |  | Location 4 | Colorado
 |  |  |  |  |  |  |  |  |  | Landscaper | Location 1 | Arizona | 28 |  |  |  | Location 5 | Colorado
Job | Start Date | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 |  |  |  |  |  | Manager | Location 3 | Colorado | 52 |  |  |  | Location 6 | Virginia
Housekeeper | 2021-01-01 00:00:00 | 0 | 0 | 0 |  |  |  |  |  | Manager | Location 2 | Arizona | 47 |  |  |  | Location 7 | Virginia
Landscaper | 2021-01-01 00:00:00 | 0 | 0 | 0 |  |  |  |  |  | Housekeeper |  | Colorado | 17 |  |  |  | Location 8 | Virginia
Manager | 2021-03-01 00:00:00 | 0 | 0 | 47 |  |  |  |  |  | Landscaper |  | Colorado | 29 |  |  |  | Location 9 | Virginia
 |  |  |  |  |  |  |  |  |  | Manager |  | Colorado | 60
 |  |  |  |  |  |  |  |  |  | Housekeeper |  | Virginia | 14
 |  |  |  |  |  |  |  |  |  | Landscaper |  | Virginia | 30
Location 1 | Does not work - Manager should be $50 |  |  |  |  |  |  |  |  | Manager | Location 7 | Virginia | 55
Location 2 | Does not work - Housekeeper should be $15.50 and Landscaper should be $32 |  |  |  |  |  |  |  |  | Manager |  | Virginia | 59
Location 3 | Does not work - Housekeeper should be $17 and Landscaper should be $29
Location 4 | Works
Location 5 | Works
Location 6 | Works
Location 7 | Does not work - Housekeeper should be $14 and Landscaper should be $30
Location 8 | Works
Location 9 | Works
Spreadsheet: d0997dac-31cb-48b5-8744-b947424b76c6
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (15 [NAME]):
 | 2 Analytik 2.4 Spektroskope 2.4.21 Spektroskopie Software
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | Advanced Chemistry Development Germany GmbH | Deutschland | Frankfurt | 60528 | A2.448
2 | Bio-Rad Laboratories Ltd. Informatics Division | Großbritannien | [NAME], [NAME] | HP2 7DX | A2.407
3 | Bruker Biospin GmbH | Deutschland | Rheinstetten | 76287 | A2.331/432
4 | Bruker Optik GmbH | Deutschland | Ettlingen | 76275 | A2.331/432
5 | Büchi Labortechnik GmbH | Deutschland | Essen | 45127 | A2.405
6 | [NAME] GmbH | Deutschland | [NAME] Hallertau | 84072 | A1.119/216
7 | J&M Analytik AG | Deutschland | [NAME] | 73457 | A2.550
8 | Molecular Devices (Germany) GmbH | Deutschland | Biberach an der Riss | 88400 | A3.230A
9 | NIR-Online GmbH | Deutschland | Walldorf | 69190 | A1.421
10 | [NAME] | Deutschland | Waldbronn | 76337 | A2.217
11 | ProSense GmbH | Deutschland | München | 81545 | A2.239
12 | SensoLogic GmbH Software + Sensor Systeme | Deutschland | Norderstedt | 22851 | A2.329
13 | Sentronic GmbH | Deutschland | Dresden | 01217 | A2.423
14 | Thermo Scientific | Deutschland | Dreieich | 63303 | B1.101/202
15 | Unity Scientific GmbH | Deutschland | [NAME] | 40549 | A1.406
Spreadsheet: 120058d1314961260-ranking-a-league-table-by-head-to-head-results-nhl-2011-2012-schedule
Sheet: Fixtures

Match | Date | Time | Visiting Team | Score |  |  | Home Team |  | W | L |  | Head to Head
1 | 2011-10-06 00:00:00 | 19:00:00 | Buffalo Sabres | 2 | OT | 3 | [NAME] |  | [NAME] | Buffalo Sabres |  | W                       L | [NAME] | Buffalo Sabres | Montreal Canadiens | Ottawa Senators | Toronto Maple Leafs
1 | 2011-10-06 00:00:00 | 19:00:00 | Montreal Canadiens | 2 |  | 0 | Toronto Maple Leafs |  | Montreal CanadiensW | Toronto Maple LeafsL |  | [NAME] |  | 1 | 1 | 0 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Buffalo Sabres | 0 | 0 | 0 | 0 | 1
2 | 2011-10-07 00:00:00 | 13:00:00 | Montreal Canadiens | 6 |  | 1 | Buffalo Sabres |  | Montreal Canadiens | Buffalo Sabres |  | Montreal Canadiens | 0 | 1 | 0 | 1 | 0
2 | 2011-10-07 00:00:00 | 13:00:00 | Ottawa Senators | 2 |  | 4 | Toronto Maple Leafs |  | Toronto Maple Leafs | Ottawa Senators |  | Ottawa Senators | 1 | 1 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Toronto Maple Leafs | 0 | 0 | 0 | 1 | 0
3 | 2011-10-08 00:00:00 | 13:00:00 | [NAME] | 3 | SO | 2 | Montreal Canadiens |  | [NAME] | Montreal Canadiens
3 | 2011-10-08 00:00:00 | 14:00:00 | Buffalo Sabres | 1 |  | 2 | Ottawa Senators |  | Ottawa Senators | Buffalo Sabres
4 | 2011-10-09 00:00:00 | 17:00:00 | Montreal Canadiens | 3 |  | 2 | Ottawa Senators |  | Montreal Canadiens | Ottawa Senators
4 | 2011-10-09 00:00:00 | 21:00:00 | [NAME] | 2 | SO | 1 | Toronto Maple Leafs |  | [NAME] | Toronto Maple Leafs
5 | 2011-10-10 00:00:00 | 13:00:00 | Toronto Maple Leafs | 1 |  | 2 | Buffalo Sabres |  | Buffalo Sabres | Toronto Maple Leafs
5 | 2011-10-10 00:00:00 | 13:00:00 | Ottawa Senators | 2 |  | 0 | [NAME] |  | Ottawa Senators | [NAME]
Spreadsheet: 170367d1343244687-formula-is-driving-me-mad-book1
Sheet: Sheet1

6
149.99 | 0.099 |  | 1001
150 | 0.079 |  | 501
300 | 0.069 |  | 301
500 | 0.059 |  | 151
1000 | 0.025 |  | 100
 |  |  | 5.9
Spreadsheet: 121443d1316059103-insert-data-on-new-row-if-insert-data-1-
Sheet: Data

 |  |  |  |  | TRUE FALSE HERE
 |  |  |  | IF TRUE I WANT DATA TO SHOW IN SALES TO COMPLETE ON NEW ROW
 |  |  |  | IF FALSE  I DO NOT WANT DATA TO SHOW IN SALES TO COMPLETE
 | 1 | Hole coring for new governors
 | 1 | Local Drawings for car interior approval
 | 1 | Lift Car Interiors
 | 0 | COPs & indication
 | 0 | Machine Room painting
 | 0 | Switchboard upgrade works
 | 0 | Smart meters & remote monitoring
 | 0 | Asbestos removal
 | 0 | Blankets
 | 0 | Hole coring to fit access devices(check wall finishes)
 | 0 | Elink cabling
 | 0 | Sheave bearing kits for cwt only (pg 11 of tender)
 | 1 | Sheave shaft inspection & machining
 | 0 | Cranage
 | 1 | Site Guards for landing doors (pg-13 of tender)
 | 0 | Relocation of static weight 'C' chanels below lift car
 | 0 | KIC
 | 0 | Inlink Display
 | 1 | Fire opinion on doors
 | 0 | Parking charges
Spreadsheet: louise_kitchen__23090__houstonpower
Sheet: Power Risk East and West

Power Risk East and West
East | [NAME]
East | [NAME]
East | [NAME]
East | Casey Evans
East | [NAME]
East | [NAME]
East | [NAME]
West | [NAME]
West | Heather Dunton
West | [NAME]
West | [NAME]
Spreadsheet: 189904d1351434005-using-multiple-match-tables-on-1-spreadsheet-excel-forum-example-1
Sheet: Sheet1

Select Equipment Number from List | Select Number of Colors from List | Select Code From List | Results
Machine #2 | 2 color | 101 | 557.25
 |  |  |  | Equipment #1 |  |  |  | Equipment #2
 |  |  | Color | Code | Total Price |  | Color | Code | Total Price
 |  | Results >> | 2 color | 101 | 551.75 |  | 2 color | 101 | 557.25 | << Results
Machine #1 | 1 color | 100 | 1 color | 100 | 375 |  | 1 color | 100 | 380.5
Machine #2 | 2 color | 101 | 1 color | 101 | 400.25 |  | 1 color | 101 | 405.75
 | 3 color | 102 | 1 color | 102 | 425.5 |  | 1 color | 102 | 431
 | 4 color | 103 | 1 color | 103 | 450.75 |  | 1 color | 103 | 456.25
 |  | 104 | 1 color | 104 | 476 |  | 1 color | 104 | 481.5
 |  | 105 | 1 color | 105 | 501.25 |  | 1 color | 105 | 506.75
 |  |  | 2 color | 100 | 526.5 |  | 2 color | 100 | 532
 |  |  | 2 color | 101 | 551.75 |  | 2 color | 101 | 557.25
 |  |  | 2 color | 102 | 577 |  | 2 color | 102 | 582.5
 |  |  | 2 color | 103 | 602.25 |  | 2 color | 103 | 607.75
 |  |  | 2 color | 104 | 627.5 |  | 2 color | 104 | 633
 |  |  | 2 color | 105 | 652.75 |  | 2 color | 105 | 658.25
These are the drop down list options |  |  | 3 color | 100 | 678 |  | 3 color | 100 | 683.5
for A2, B2 and C2 |  |  | 3 color | 101 | 703.25 |  | 3 color | 101 | 708.75
 |  |  | 3 color | 102 | 728.5 |  | 3 color | 102 | 734
 |  |  | 3 color | 103 | 753.75 |  | 3 color | 103 | 759.25
 |  |  | 3 color | 104 | 779 |  | 3 color | 104 | 784.5
 |  |  | 3 color | 105 | 804.25 |  | 3 color | 105 | 809.75
 |  |  | 4 color | 100 | 829.5 |  | 4 color | 100 | 835
 |  |  | 4 color | 101 | 854.75 |  | 4 color | 101 | 860.25
 |  |  | 4 color | 102 | 880 |  | 4 color | 102 | 885.5
 |  |  | 4 color | 103 | 905.25 |  | 4 color | 103 | 910.75
 |  |  | 4 color | 104 | 930.5 |  | 4 color | 104 | 936
 |  |  | 4 color | 105 | 955.75 |  | 4 color | 105 | 961.25
Spreadsheet: 80603d1280831223-highlighting-complex-duplication-book2
Sheet: Sheet1

Address | Application | Type | Value
1 Old Street | 1 | Bathroom | 100
1 New Street | 2 | Kitchen | 200
1 Old Street | 2 | Bathroom | 200
1 New Street | 2 | Bathroom | 100
1 Old Street | 1 | Kitchen | 200
Spreadsheet: 698481d1602000598-vlookup-returns-error-when-table-array-is-from-another-sheet-excel-settings-book1-example
Sheet: Sheet2

 |  |  |  |  | Employee | Date | Rate
 |  |  |  |  | Number 1 | 2020-04-03 00:00:00 | 4.5
 |  |  |  |  | Number 2 | 2020-04-17 00:00:00 | 0.5
 |  |  |  |  | Number 3 | 2020-04-10 00:00:00 | 1.5
 |  |  |  |  | Number 4 | 2020-04-03 00:00:00 | 1.25
 |  |  |  |  | Number 5 | 2020-04-03 00:00:00 | 2
 |  |  |  |  | Number 6 | 2020-04-03 00:00:00 | 25
 |  |  |  |  | Number 7 | 2020-04-03 00:00:00 | 2
 |  |  |  |  | Number 8 | 2020-04-10 00:00:00 | 4
 |  |  |  |  | Number 9 | 2020-04-03 00:00:00 | 8
 |  |  |  |  | Number 10 | 2020-04-10 00:00:00 | 5
Spreadsheet: 746569d1630849287-list-with-saturdays-sundays-and-holidays-sat-sun
Sheet: Dati

 | Mese corrente
Mesi |  | Anno |  |  | [NAME]
Gennaio | 1 | 2020 |  |  |  | capodanno
[NAME] | 2 | 2021 |  |  |  | epifania
Marzo | 3 | 2022 |  |  |  | pasqua
Aprile | 4 | 2023 |  |  |  | pasquetta
Maggio | 5 | 2024 |  |  |  | liberazione
[NAME] | 6 | 2025 |  |  |  | festa del lavoro
Luglio | 7 |  |  |  |  | festa della repubblica
[NAME] | 8 |  |  |  |  | ferragosto
Settembre | 9 |  |  |  |  | tutti i santi
Ottobre | 10 |  |  |  |  | Immacolata concezione
Novembre | 11 |  |  |  |  | Natale
Dicembre | 12 |  |  |  |  | Santo Stefano
 |  |  |  |  |  | [NAME]
Spreadsheet: 762510d1641584777-lookup-multiple-criteria-multiple-results-excel-q
Sheet: Phoenix_P8

Phoenix Centralized Training ASC office
Zone | Attendees | Global ID | Position | [NAME] | Needs Room | RoomNight
[NAME]
Phoenix | Potential 1 |  | waiting on background
 | Potential 2 |  | waiting on background
 | Potential 3 |  | waiting on background
 | Potential 4 |  | waiting on background
 | Potential 5 |  | waiting on background
 | Potential 6 |  | waiting on background
Tucson | [NAME] | 71080549 | [NAME] (transfer from pepsi merch) | TBD | yes | Tu/W
 |  |  | Samatha Shelper 7/22/2017
 |  |  | [NAME]
 |  |  | [NAME] 8/06/2017 | 405.24
El Paso |  |  | [NAME] 8/06/17 | 405.25
 |  |  | [NAME]
Spreadsheet: 771685d1646795115-assistance-with-2-spreadsheets-and-a-3rd-tally-spreadsheet-sample1
Sheet: Sheet1

Order Form | Date | Cust Ref | Ord Type | Name | Item | PCode | Online Cust Ref
AAAAAAB | 2022-03-01 00:00:00 | JOHNDOUGH | ONLINE | [NAME] | How to Basketball | 54053 | 54053
AAAAAAB | 2022-03-01 00:00:00 | JOHNDOUGH | ONLINE | [NAME] | How to Football | 54053 | 54053
AAAAAAB | 2022-03-01 00:00:00 | JOHNDOUGH | ONLINE | [NAME] | How to Soccer | 54053 | 54053
AAAAABB | 2022-03-01 00:00:00 | JANEDOUGH | ONLINE | [NAME] | How to print | 55043 | 55043
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: New 980H

New 980H |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 165539d1341259632-excel-2007-index-and-match-with-duplicates-book-bprime-oeldere-
Sheet: fail

 | martial Artist |  | Values | helper collumn | Top 6  Martial Artists |  |  | Top 6 Values |  | i have a list of 50 categories in column B
 | [NAME] |  | 9 | 9.000002 | [NAME] |  |  | 10.000007 |  | i have a list of 50 values in column D
 | [NAME] |  | 8 | 8.000003 | [NAME] |  |  | 9.000002 |  | i have the top 6 values in column I (populated by six of these type of functions =LARGE(D2:D106,2)
 | [NAME] |  | 7 | 7.000004 | [NAME] |  |  | 8.000003 |  | column f is where i am using this index statement to show the corresponding value from column B/I : =INDEX(B2:B300,MATCH(I4,D2:D300,0),1)
 | Chow-Yun Fat |  | 5 | 5.000005 | [NAME] |  |  | 7.000009
 | [NAME] |  | 5 | 5.000006 | [NAME] |  |  | 7.000008 |  | But i am getting duplicates in column F because excel stops at the first matched value.
 | [NAME] |  | 10 | 10.000007 | [NAME] |  |  | 7.000004
 | [NAME] |  | 7 | 7.000008 |  |  |  |  |  | should i edit the index statement (as i suspect) and in what way?
 | [NAME] |  | 7 | 7.000009
 |  |  |  |  |  |  |  |  |  | or should i edit the large statement (less likely i think)?
 |  |  |  |  |  |  |  |  |  | first post
 |  |  |  |  |  |  |  |  |  | thanks for the help
Spreadsheet: 157363d1337708848-index-matching-with-reference-column-after-data-rolling-trends
Sheet: Rolling Trend

 |  |  |  | Actual
 |  |  |  |  |  |  |  |  |  |  |  |  | Totals
Revenue:
Patient Service Revenue
Other Income
Total Revenue
Spreadsheet: 0339f364-78ef-4446-b4e5-8bf342d565e5
Sheet: Sheet1

NIGHT DIFFERENTIAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
(ATTACH TO TIME REPORT)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TIME PERIOD
NAME: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FROM
DEPT.: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TO
DATE |  |  |  |  |  | TIME WORKED |  |  |  |  |  |  |  |  |  | COMMENTS
 |  |  |  |  |  | FROM:   (AM/PM) |  |  |  |  | TO:  (AM/PM) |  |  |  |  | (OFFICE USE ONLY)
TOTAL HOURS WORKED:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INITIAL
TOTAL HOURS - NIGHT DIFFERENTIAL: