tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kim_ward__20701__kingman_indications
Sheet: 4-3-01

 |  |  |  |  |  |  |  |  |  | TABLE 1
Quote for | City of Kingman
4/3/01  10:00 am |  |  |  |  |  |  |  |  |  | This quote is illustrative.  Actual pricing may differ due to market changes
Del Pt.: | Citizens City Gate
 |  | [NAME] | Citygate | San Juan | San Juan | Rounded | San Juan | Citygate | [NAME] | NYMEX |  | EPSJ | Fuel | Transport | Final Price | San Juan | City Gate
 | Days/ | [NAME] | [NAME] | [NAME] | Volume | Volume | [NAME] | [NAME] | [NAME] |  | Basis | Price | Adj Price | to Gate | City Gate | payments | payments
Month | Month | MMBtu/Mo | MMBtu/Mo | MMBtu/Mo | MMBtu/d | MMBtu/day | MMBtu/Mo | MMBtu/Mo | MMBtu/Mo | $/MMBtu | $/MMBtu | $/MMBtu | *
2001-05-01 00:00:00 | 31 | 12000 | 2244 |  |  |  |  |  |  | 5.135 | -0.51 |  |  | 0.35
2001-06-01 00:00:00 | 30 |  | 2768 |  |  |  |  |  |  | 5.16 | -0.47 |  |  | 0.35
2001-07-01 00:00:00 | 31 |  | 3103 |  |  |  |  |  |  | 5.21 | -0.43 |  |  | 0.35
2001-08-01 00:00:00 | 31 |  | 3274 |  |  |  |  |  |  | 5.26 | -0.42 |  |  | 0.35
2001-09-01 00:00:00 | 30 |  | 2710 |  |  |  |  |  |  | 5.25 | -0.405 |  |  | 0.35
2001-10-01 00:00:00 | 31 |  | 2498 |  |  |  |  |  |  | 5.255 | -0.375 |  |  | 0.35
2001-11-01 00:00:00 | 30 |  | 2176 |  |  |  |  |  |  | 5.2 | -0.16 |  |  | 0.35
2001-12-01 00:00:00 | 31 |  | 1000 |  |  |  |  |  |  | 5.3 | -0.16 |  |  | 0.35
2002-01-01 00:00:00 | 31 |  | 1000 |  |  |  |  |  |  | 5.3 | -0.16 |  |  | 0.35
2002-02-01 00:00:00 | 28 |  | 1000 |  |  |  |  |  |  | 5.3 | -0.16 |  |  | 0.35
2002-03-01 00:00:00 | 31 |  | 1018 |  |  |  |  |  |  | 5.3 | -0.16 |  |  | 0.35
2002-04-01 00:00:00 | 30 |  | 1466 |  |  |  |  |  |  | 4.57 | -0.14 |  |  | 0.35
2002-05-01 00:00:00 | 31 |  | 2244 |  |  |  |  |  |  | 4.425 | -0.14 |  |  | 0.35
2002-06-01 00:00:00 | 30 |  | 2768 |  |  |  |  |  |  | 4.41 | -0.14 |  |  | 0.35
2002-07-01 00:00:00 | 31 |  | 3103 |  |  |  |  |  |  | 4.44 | -0.14 |  |  | 0.35
2002-08-01 00:00:00 | 31 |  | 3274 |  |  |  |  |  |  | 4.45 | -0.14 |  |  | 0.35
2002-09-01 00:00:00 | 30 |  | 2710 |  |  |  |  |  |  | 4.43 | -0.14 |  |  | 0.35
2002-10-01 00:00:00 | 31 |  | 2498 |  |  |  |  |  |  | 4.43 | -0.14 |  |  | 0.35
2002-11-01 00:00:00 | 30 |  | 2176 |  |  |  |  |  |  | 4.45 | -0.14 |  |  | 0.35
2002-12-01 00:00:00 | 31 |  | 1000 |  |  |  |  |  |  | 4.45 | -0.14 |  |  | 0.35
2003-01-01 00:00:00 | 31 |  | 1000 |  |  |  |  |  |  | 4.7 | -0.12 |  |  | 0.35
2003-02-01 00:00:00 | 28 |  | 1000 |  |  |  |  |  |  | 4.53 | -0.12 |  |  | 0.35
2003-03-01 00:00:00 | 31 |  | 1018 |  |  |  |  |  |  | 4.27 | -0.12 |  |  | 0.35
2003-04-01 00:00:00 | 30 |  | 1466 |  |  |  |  |  |  | 4.05 | -0.12 |  |  | 0.35
 |  |  |  |  |  |  |  |  |  |  |  | Average San Juan Price
 |  |  |  |  |  |  |  |  |  |  |  | Average City gate Price
 |  |  |  |  |  |  |  |  |  |  |  |  | * If pipeline tariff for fuel changes during term,
 |  |  |  |  |  |  |  |  |  |  |  |  | this value will also change.
Approved: | Buyer:
 | [NAME]:
Spreadsheet: 56154d1256242371-data-lookup-exampledatalookup
Sheet: Overview

 |  | WIP Count Date: |  | 2009-07-01 00:00:00 |  |  |  | Current Date: | 2009-10-22 22:01:50 |  |  |  |  | Machining Month | 2009-07-01 00:00:00
Project: |  | 0579A
 |  | SL |  | WIP (Not on Hold) | Hold Qty | WIP Target |  | alternative for F8:F26
 |  |  |  |  |  | 0
[NAME] |  | 1 |  | 1100 | 210 | 0 |  | 210
 |  | 1 |  |  | 0 | 0
 |  | 1 |  |  | 0 | 8000
Coin |  | 2 |  | 2200 | 220 | 8000 |  | 220
 |  | 1 |  |  | 0 | 8000
 |  | 1 |  |  | 0 | 8000
[NAME]. |  | 3 |  | 3300 | 230 | 8000 |  | 230
 |  | 1 |  |  | 0 | 8000
 |  | 1 |  |  | 0 | 4000
[NAME] |  | 4 |  | 4400 | 0 | 4000
 |  | 1 |  |  | 0 | 4000
 |  | 1 |  |  | 0 | 5000
Zion |  | 5 |  | 5500 | 240 | 5000 |  | 240
 |  | 1 |  |  | 0 | 5000
 |  | 1 |  |  | 0 | 5000
Mag |  | 6 |  | 6600 | 250 | 5000 |  | 250
 |  | 1 |  |  | 0 | 5000
 |  | 1 |  |  | 0 | 5000
Vision |  | 7 |  | 7700 | 260 | 5000 |  | 260
 |  | 1 |  |  | #N/A | 5000
 |  | 1 |  |  | #N/A | 20412
FG (Bx) |  | 8 |  | 432 | 550 | 20412 | (in Bx or [NAME])
 |  | 1 |  |  |  | 20412
FG (Skid) |  | 0
 |  | WIP After [NAME]. (Count) |  | 24632 | 1960
 |  | WIP After [NAME]. (Turnover) |  | #N/A
 |  |  |  |  |  | 55412
 |  | Total WIP |  | 31232 | 1960 | 55412
 |  |  |  |  |  | 55412
 | Blend Qty | 7630
 | [NAME] | 1100
 | FG tray Qty | 54
 | FG Skid Qty | 3240
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
Spreadsheet: 840305d1692634115-threshold-tracking-risk-management-threshold-tracking-2023-v3
Sheet: Data Validation

Individual Name | Home | Incident Type | IDT Threshold | Facility Threshold
Aldridge, [NAME] | 1W | Chemical or Mechanical [NAME] | Any Incident | 2 within 2 mos.
[NAME], [NAME] | 2E | Choking | Any Incident | 2 within 6 mos.
[NAME], Sagan | 2W | Decubitus | Any Incident | 2 within 12 mos.
Armstrong, [NAME] | 3E | Falls | 3 within 30 days | >3 within 30 days
Barned, Brian D | 3W | Individual to Staff Aggression - Minor Injury to Staff | 3 within 14 days | 4 within 30 days
Bell, Charlesetta D | DM | Individual to Staff Aggression - Serious Injury to Staff | Any Incident | 2 within 30 days
Berreman, [NAME] | ME | LOS - Behavioral/Psychiatric >72 Hrs. | Any Incident | 2 within 1 week
[NAME], [NAME] | WS | Major Injury | Any Incident | 3 in 6 mos.
Bond, Melvina |  | Minor Injury | 5 within 1 mo. | 15 within 3 mos.
[NAME], [NAME] R |  | Mortality - Expected or Unexpected Death | Any Incident | N/A
Brockman, [NAME] |  | Peer to Peer Aggressor - No/Minor Injury | 3 within 14 days | 4 within 30 days
Brown, [NAME] |  | Peer to Peer Aggressor - Serious Injury | Any Incident | 2 within 30 days
[NAME], [NAME] |  | Peer to [NAME] | 3 within 14 days | 4 within 30 days
Caldwell, [NAME] |  | Peer to Peer Victim - Serious Injury | Any Incident | 2 within 30 days
Cammack, English B |  | Physical Restraint | Any Incident | 6 within 2 mos.
[NAME], [NAME] |  | Pica | 1st event | 2 within 180 days
Clark, Regina K |  | Pneumonia - Aspiration | Any Incident | 2 within 12 mos.
Coffield, Mitchell B |  | Pneumonia - Non-Aspiration | Any Incident | 2 within 12 mos.
Daugherty, [NAME] |  | Polypharmacy - Interclass | Any Incident | Ongoing until resolved
Deen, [NAME] |  | Polypharmacy - Intraclass | Any Incident | Ongoing until resolved
Desgrosiellier, Teresa |  | SIB - Minor Injury | 3 within 14 days | 6 within 3 mos.
Elam, [NAME] |  | SIB - Serious Injury | Any Incident | 2 within 3 mos.
[NAME], [NAME]
[NAME], [NAME]
French, [NAME]
Gayheart, Breanna
Geary, [NAME]
[NAME], Zaid H
[NAME], Marion
Gulley, Fred
Hall, [NAME]
Hammonds, Martino
Humphress, [NAME]
Hyden, [NAME]
Jenkins, [NAME]
Jones, [NAME]
Kingsley, Jill M
Kippes, [NAME]
[NAME], [NAME]
[NAME], [NAME]
Martin, [NAME]
Moore, Keiron
[NAME], Josephine I
[NAME], [NAME]
[NAME], [NAME]
[NAME], [NAME]
Poole, [NAME]
Radford, Cameron
[NAME], [NAME]
[NAME], [NAME]
Roney, George
Saffram, [NAME]
[NAME], [NAME]
Shields, [NAME]
Smith, [NAME]
Smith, Sterling
Spicer, [NAME]
Stallings, [NAME]
Stelly, [NAME]
[NAME], [NAME]
Stivers, [NAME]
Swift, Katrina W
Thompson, Amanda J
West, [NAME]
Woods, A'Joy S
Yates, [NAME]
Spreadsheet: 675944d1588577047-h_lookup-split-over-3-columns-copy-of-map1
Sheet: Sheet1

 |  |  |  |  |  |  | JAN |  |  |  |  |  |  |  |  | Trainingsevolutie | PIET |  |  | JAN
 |  |  |  |  |  |  | one | two | date |  |  |  |  |  |  | 1 | 1 | 5 | 2020-02-25 00:00:00 | 1 | 13 | 2020-02-25 00:00:00
 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 2 | 2 | 6 | 2020-02-26 00:00:00 | 2 | 12 | 2020-02-25 00:00:00
 |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | 3 | 3 | 7 | 2020-02-27 00:00:00 | 3 | 11 | 2020-02-25 00:00:00
 |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  | 4 | 4 | 8 | 2020-02-28 00:00:00 | 4 | 10 | 2019-01-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 9 | 2020-02-29 00:00:00 | 5 | 9 | 2017-06-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 6 | 10 | 2020-03-01 00:00:00 | 6 | 8 | 2019-01-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 7 | 11 | 2020-03-02 00:00:00 | 7 | 7 | 2019-01-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 | 12 | 2020-03-03 00:00:00 | 8 | 6 | 2017-06-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 9 | 13 | 2020-03-04 00:00:00 | 9 | 5 | 2017-06-07 00:00:00
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: Weather

Weather
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90131093 | BENNETT, STEPHEN D | Mgr Research | MGR-ST
90011699 | MARQUEZ, [NAME] | Mgr Research | MGR-ST
90012909 | [NAME], [NAME] | VP Research | VP-ST
90011275 | RYAN, [NAME] | Mgr Trading Supt | MGR-CS
90152405 | STEVENS, [NAME] | Specialist Sr Research | SPECSR-ST
 |  | Employees
Spreadsheet: 848461d1699198269-text-date-range-to-date-value-range-text-date-range-to-date-value-range
Sheet: Sheet1

Billing Durations | Start  Date | End  Date | Duration
Apr 27, 2023 - May 24, 2023
[NAME], 2023 - Jul 5, 2023
No duration given
Jul 6, 2023 - Aug 2, 2023
Jul 6, 2023 - Aug 2, 2023
Jul 6, 2023 - Aug 2, 2023
Jul 23, 2023 - Aug 19, 2023
Jun 27, 2023 - Jul 24, 2023
Jul 25, 2023 - Aug 21, 2023
Aug 31, 2023 - Sep 27, 2023
Aug 31, 2023 - Sep 27, 2023
Aug 31, 2023 - Sep 27, 2023
Sep 27, 2023 - Oct 24, 2023
Sep 27, 2023 - Oct 24, 2023
Feb 2, 2023 - Mar 1, 2023
Feb 16, 2023 - Mar 15, 2023
[NAME], 2023 - Mar 11, 2023
[NAME], 2023 - Mar 11, 2023
N/A
Mar 19, 2023 - Mar 25, 2023
[NAME], 2023 - Apr 1, 2023
Apr 11, 2023 - May 8, 2023
Apr 13, 2023 - May 10, 2023
Spreadsheet: 155039d1336658224-excel-2007-how-to-create-a-list-that-returns-unique-values-test-hot-list
Sheet: MICHIGAN

 | MICHIGAN
 | NAME | CONTACT | [NAME] | PHONE | ENROLLMENT | SENT | RESPONSE | COLD | INTERESTED | HOT | POS. SALES $ | CLOSE DATE | NOTES | Trial End
 | Oakland Community College |  |  |  | 74000 | 1
 | Michigan State University, East Lansing |  |  |  | 47800 | 1
 | Baker College, multiple locations |  |  |  | 42000
 | University of Michigan, Ann Arbor, MI |  |  |  | 41500 | 1 | 1 |  |  | 1
 | Wayne State University, Detroit |  |  |  | 32500 | 1
 | Central Michigan University, Mount Pleasant |  |  |  | 28000 | 1 | 1 | 1 |  |  |  |  |  | 2012-03-16 00:00:00
 | Western Michigan University, Kalamazoo |  |  |  | 25000
 | Grand Valley State University, Allendale, Grand Rapids |  |  |  | 24500 | 1
 | Eastern Michigan University, Ypsilanti |  |  |  | 23000 | 1 | 1
 | Oakland University, Rochester Hills |  |  |  | 19000
 | Kellogg Community College |  |  |  | 15000 | 1
 | Ferris State University, Big Rapids |  |  |  | 14000 | 1 | 1 | 1
 | Henry Ford Community College |  |  |  | 13000
 | Davenport University, multiple locations |  |  |  | 12000
 | Jackson Community College |  |  |  | 12000
 | Delta College |  |  |  | 11000
 | Saginaw Valley State University, University Center |  |  |  | 10500
TOTALS
Spreadsheet: 678377d1589859854-index-match-for-auto-costings-calculations-jitterbug888_bizcostings-sample_v2
Sheet: LOANS & BIZ COSTS

CATEGORY | ITEM | AVERAGE BILL | PERIOD | DAY | WEEK | MONTH | QTR | BI-ANNUAL | YEAR | COMMENTS
BUSINESS COST | GAS | 36 | quarterly
BUSINESS COST | ELECTRICITY | 100 | quarterly
BUSINESS COST | INTERNET | 90 | monthly
BUSINESS COST | RENT | 6035.7 | monthly
BUSINESS COST | [NAME] | 138 | 6 months
BUSINESS COST | PHONE | 85.85 | monthly
BUSINESS LOAN | MASTERCARD | 265 | monthly
BUSINESS LOAN | VISA | 225 | monthly
BUSINESS LOAN | VISA2 | 315 | monthly
BUSINESS LOAN | LOAN1 | 283.65 | monthly
BUSINESS LOAN | BANK OVERDRAFT | 185 | monthly
BUSINESS COST | CONDO | 3500 | yearly
BUSINESS COST | WAVERLEY COUNCIL | 277 | yearly
CHARITY | CHARITY1 | 10 | monthly
SUBSCRIPTIONS | MAGAZINE | 18.5 | monthly
BUSINESS COST | LAUNDRY | 36 | weekly
BUSINESS COST | CANDLES | 0.75 | daily
BUSINESS COST | LEGAL | 200 | yearly
BUSINESS COST | REPAIRS | 50 | weekly
BUSINESS COST | MANCHESTER | 100 | quarterly
BUSINESS COST | LICENSES | 200 | 6 months
BUSINESS COST | INSURANCE | 100 | yearly
BUSINESS COST | PUBLIC LIABILITY | 200 | 6 months
BUSINESS COST | PROFESSIONAL INDEMNITY | 500 | yearly
PERSONAL LOAN | TOM | 2000 | 2 years
PERSONAL LOAN | CARLIE | 5000 | 4 years
Spreadsheet: 102635d1300608513-automate-new-sheets-in-workbook-stock
Sheet: 5

Name Product: |  |  | Report
Code: |  | Supplier:
Colour: |  | [NAME]:
Price/Unit: |  | Price Sale/Unit:
Date | Description | Inv.No. | Receive | Sale | Balance | Remark
Spreadsheet: 82527d1282592549-format-add-rows-of-data-adding-rows-of-data
Sheet: 2

 | Operating Model (Revenue)
 |  | Product 1
 |  |  | Volume
 |  |  | Price per unit
 |  |  |  | Volume growth
 |  |  |  | Price per unit growth
 |  |  | Revenue
 |  |  |  | growth
 |  | Product 2
 |  |  | Volume
 |  |  | Price per unit
 |  |  |  | Volume growth
 |  |  |  | Price per unit growth
 |  |  | Revenue
 |  |  |  | growth
 |  | Product 3
 |  |  | Volume
 |  |  | Price per unit
 |  |  |  | Volume growth
 |  |  |  | Price per unit growth
 |  |  | Revenue
 |  |  |  | growth
Spreadsheet: 848385d1699106167-separation-digits-test
Sheet: Sheet1

4.1.10 Leerrohre DN 100
4.1.13Leerrohrgraben (Maschinenaushub)
3.1.7Test
3.1.7 April
Spreadsheet: 792877d1661193003-need-to-list-unique-values-from-3-separate-table-columns-test-sheet
Sheet: Sheet1

data I would enter in tables |  |  |  |  |  |  |  |  |  |  |  |  | desired output
XPARTS | Item | Cost |  | YPARTS | Item | Cost |  | [NAME] | Item | Cost |  |  | Part | Cost
PT1 | Widget | 10 |  | PT3 | Other | 20 |  | PT5 | Wire | 1
PT2 | Thing | 15 |  | PT4 | Item | 25 |  | PT6 | Connector | 2
PT1 | Widget | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | would want this to read "PT3" in column N and "$20" in column O
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | would want this to read "PT4" in column N and "$25" in column O
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | would want this to read "PT5" in column N and "$1" in column O
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | would want this to read "PT6" in column N and $2 in column O
Spreadsheet: 731240d1620242876-losing-formula-integrity-after-using-the-sort-and-filter-function-chris-gantt-project-chart
Sheet: Test

2021 - PROJECT FORECASTING- DATE UPDATED:  21.047.56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TABLE ONE
2021 |  |  |  |  |  | Apr |  |  |  | May |  |  |  | Jun
Team Lead | Project | Milestone | [NAME] | Phase | Team Member | 2021-04-04 00:00:00 | 2021-04-11 00:00:00 | 2021-04-18 00:00:00 | 2021-04-25 00:00:00 | 2021-05-02 00:00:00 | 2021-05-09 00:00:00
[NAME] | 19003 - Project Y | 2021-06-05 00:00:00 | FFE PKG | Phase 3 | [NAME] |  |  |  |  |  |  |  |  | 7.5 | 30 | 25 | 15 | 5
[NAME] | 19003 - Project Y | 2021-04-01 00:00:00 | FFE PKG | Phase 1 | Kaley |  | 1 | 3 | 3 | 3
[NAME] | 19003 - Project Y | 2021-06-06 00:00:00 | FFE PKG | Phase 3 | Yvonne |  |  |  |  |  |  |  |  |  | 5 | 5 | 5
[NAME] | 19003 - Project Y | 2021-06-01 00:00:00 | Occupancy | Phase 5 | [NAME] | 1 | 1 | 1 | 1 | 3 | 3 | 1 | 1 | 2 | 2 | 2 | 2 | 2
[NAME] | 19003 - Project Y | 2021-05-08 00:00:00 | Occupancy | Phase 2 | Kaley |  |  |  |  |  | 1 | 5 | 5
[NAME] | 19003 - Project Y | 2021-06-03 00:00:00 | Occupancy | Phase 5 | Yvonne | 4 | 2 |  | 2 |  | 2 | 2 |  | 2 |  | 2 | 2
 |  |  |  |  |  |  |  |  |  | May |  |  |  | Jun |  |  |  |  | TABLE TWO
 | ORGINAL UNSORTED VERSION
 |  |  |  |  | [NAME]
 |  |  |  |  | Kaley
 |  |  |  |  | Yvonne
 |  |  |  |  | Totals
2021 - PROJECT FORECASTING- DATE UPDATED:  21.047.56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TABLE ONE
2021 |  |  |  |  |  | Apr |  |  |  | May |  |  |  | Jun
Team Lead | Project | Milestone | [NAME] | Phase | Team Member | 2021-04-04 00:00:00 | 2021-04-11 00:00:00 | 2021-04-18 00:00:00 | 2021-04-25 00:00:00 | 2021-05-02 00:00:00 | 2021-05-09 00:00:00
[NAME] | 19003 - Project Y | 2021-04-01 00:00:00 | FFE PKG | Phase 1 | Kaley |  | 1 | 3 | 3 | 3
[NAME] | 19003 - Project Y | 2021-05-08 00:00:00 | Occupancy | Phase 2 | Kaley |  |  |  |  |  | 1 | 5 | 5
[NAME] | 19003 - Project Y | 2021-06-01 00:00:00 | Occupancy | Phase 5 | [NAME] | 1 | 1 | 1 | 1 | 3 | 3 | 1 | 1 | 2 | 2 | 2 | 2 | 2
[NAME] | 19003 - Project Y | 2021-06-03 00:00:00 | Occupancy | Phase 5 | Yvonne | 4 | 2 |  | 2 |  | 2 | 2 |  | 2 |  | 2 | 2
[NAME] | 19003 - Project Y | 2021-06-05 00:00:00 | FFE PKG | Phase 3 | [NAME] |  |  |  |  |  |  |  |  | 7.5 | 30 | 25 | 15 | 5
[NAME] | 19003 - Project Y | 2021-06-06 00:00:00 | FFE PKG | Phase 3 | Yvonne |  |  |  |  |  |  |  |  |  | 5 | 5 | 5
 |  |  |  |  |  | Apr |  |  |  | May |  |  |  | Jun |  |  |  |  | TABLE TWO
 | SORT & FILTER FUNCTION BY COLUMN C - MILESTONE
 |  |  |  |  | [NAME]
 |  |  |  |  | Kaley
 |  |  |  |  | Yvonne
 |  |  |  |  | Totals
Spreadsheet: 481013d1474237587-excel-time-duration-format-not-working-time-clock-final
Sheet: Sheet1

Date | Time | ID | Name | Check In/Check Out | Hours Worked | Weekly Hours | Test |  | ID | NAME | Weekly Hours
2016-08-28 00:00:00 | 07:27:00 | 15000 |  |  |  |  |  |  | 13997 | [NAME] | 30
2016-08-28 00:00:00 | 16:00:00 | 15000 |  |  |  |  |  |  | 15000 | [NAME] | 36
2016-08-28 00:00:00 | 05:27:00 | 16000 |  |  |  |  |  |  | 16000 | [NAME] | 45
2016-08-28 00:00:00 | 14:00:00 | 16000
2016-08-29 00:00:00 | 07:00:00 | 13997
2016-08-29 00:00:00 | 15:32:00 | 13997
2016-08-29 00:00:00 | 07:15:00 | 15000
2016-08-29 00:00:00 | 15:59:00 | 15000
2016-08-29 00:00:00 | 06:02:00 | 16000
2016-08-29 00:00:00 | 14:25:00 | 16000
2016-08-30 00:00:00 | 06:45:00 | 13997
2016-08-30 00:00:00 | 15:27:00 | 13997
2016-08-30 00:00:00 | 07:15:00 | 15000
2016-08-30 00:00:00 | 15:15:00 | 15000
2016-08-30 00:00:00 | 05:00:00 | 16000
2016-08-30 00:00:00 | 13:55:00 | 16000
2016-08-31 00:00:00 | 06:58:00 | 13997
2016-08-31 00:00:00 | 15:17:00 | 13997
2016-08-31 00:00:00 | 07:14:00 | 15000
2016-08-31 00:00:00 | 16:36:00 | 15000
2016-08-31 00:00:00 | 05:35:00 | 16000
2016-08-31 00:00:00 | 14:00:00 | 16000
Spreadsheet: 836665d1689577161-using-index-formula-to-summarise-training-database-index
Sheet: IR

CÔNG TY TNHH GE-SHEN VIỆT NAM |  |  |  |  |  |  |  |  |  | Form  :  HR-F02
GE-SHEN (VIETNAM) CO., LTD. |  |  |  |  |  |  |  |  |  | Rev    :  C
GHI CHÉP ĐÀO TẠO CÁ NHÂN/ NHÓM
GROUP / INDIVIDUAL TRAINING RECORD
Emp. No.: | 105320 |  |  |  |  |  | Name:
Dept: |  |  |  |  |  |  | Position:
Date Joined: |  |  |  |  |  |  | Year:
TT No. | Int/ Ext | Date |  |  | Time |  |  | Khóa đào tạo Training Course | Trained by | Ghi chú Remarks
1 |  |  |  |  |  |  |  |  |  |  |  | B7 | manually key in
2 |  |  |  |  |  |  |  |  |  |  |  | B8 | [NAME] in Employee name sheet, Column C
3 |  |  |  |  |  |  |  |  |  |  |  | B9 | [NAME] in Employee name sheet, Column E
4 |  |  |  |  |  |  |  |  |  |  |  | H7 | [NAME] in Employee name sheet, Column B
5 |  |  |  |  |  |  |  |  |  |  |  | H8 | [NAME] in Employee name sheet, Column D
6 |  |  |  |  |  |  |  |  |  |  |  | H9 | is it possible to tabulate data below base on year, i.e. if I keyed in 2022, the data will be show for year 2022 only, then if I change the year for 2023, it will tabulate the data for 2023
7 |  |  |  |  |  |  |  |  |  |  |  | B13 | list of training attended by by [NAME], lookup value in Database, Column D
8 |  |  |  |  |  |  |  |  |  |  |  | C13 | start date for 1st list training attended by by [NAME], lookup value in Database, Column E
9 |  |  |  |  |  |  |  |  |  |  |  | B14 to G42 | Other list of training attended by B7
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 847785d1698658673-conditional-formatting-with-percentages-conditionalformattingtest
Sheet: Sheet1

Supplier | Item Number | Item Name | Description | Units Ordered | Items per Unit | Number Units on B/O | Item Quantity In Stock | Unit Price | Per | Date Last  Ordered | Total
ABC Supplier | ABC 123 | DiaryJoe | [NAME] | 1 | 30 | 0 | 1 | 600 | Each | 2023-09-08 00:00:00
ABC Supplier | ZXY456 | [NAME] | Blue ink Pens | 1 | 17 | 0 | 15 | 80 | Each | 2023-09-08 00:00:00
This is what I would like to see.
ABC Supplier | ABC 123 | DiaryJoe | [NAME] | 1 | 30 | 0 | 1 | 600 | Each | 2023-09-08 00:00:00
ABC Supplier | ZXY456 | [NAME] | Blue ink Pens | 1 | 17 | 0 | 7 | 80 | Each | 2023-09-08 00:00:00
ABC Supplier | ZXY789 | Blpens | Black ink Pens | 1 | 17 | 0 | 17 | 80 | Each | 2023-09-08 00:00:00
Spreadsheet: 684410d1593350900-extract-data-with-power-query-and-groupby-tool-excelforumquestion
Sheet: Foglio1

Company | Product |  | Gruppo | Prodotti
Apple | F |  |  |  | B | A
Dell | D |  | Apple |  | F
Amazon | A |  | Dell
Microsoft | C |  | Google |  | F
Apple | F |  | Microsoft |  | A | C
Google | F
Amazon | B
Google | F
Microsoft | A
Amazon | A
Microsoft | C
Spreadsheet: 156258d1337246039-one-lookup-value-multiple-matches-book1
Sheet: Rent

[NAME] | Property Letting | Rent Due | Month | Date Due | Date Paid | Amount Paid | Other Income | Amount paid | Management Fee | Total
[NAME] | 5 Altcar Road |  | May | 2012-05-01 00:00:00
[NAME] | 33 [NAME] |  | May | 2012-05-01 00:00:00
[NAME] | 1 Holly Grove |  | May | 2012-05-01 00:00:00
[NAME] | 20 [NAME] |  | May | 2012-05-01 00:00:00
[NAME] | 92 Princes Road |  | May | 2012-05-01 00:00:00
David & Julie Collings | 10 Woodbank Road |  | May | 2012-05-01 00:00:00
David & Julie Collings | 1 Worcester Road (flat 3) |  | May | 2012-05-01 00:00:00
David & Julie Collings | 31 Whipcord Lane |  | May | 2012-05-01 00:00:00
[NAME] | 37 Bulwer Street |  | May | 2012-05-01 00:00:00
[NAME] | 2 Rossett Street |  | May | 2012-05-01 00:00:00
[NAME] | 26 Priestfield |  | May | 2012-05-01 00:00:00
[NAME] | 1a Westfield Road |  | May | 2012-05-01 00:00:00 |  | 500
[NAME] | [NAME] (flat) |  | May | 2012-05-01 00:00:00 |  | 600
[NAME] | 121a [NAME] |  | May | 2012-05-01 00:00:00 |  | 400 | 2012-05-10 00:00:00 | 100
[NAME] | 102A Nortfield Road |  | May | 2012-05-01 00:00:00
[NAME] | 1B Westfield |  | May | 2012-05-01 00:00:00
[NAME] | 24 Ullswater Street |  | May | 2012-05-01 00:00:00
[NAME] | 102 Northop Road |  | May | 2012-05-01 00:00:00
[NAME] | 36 Quayside |  | May | 2012-05-01 00:00:00
[NAME] | 2 Anglesea Road (flat 1) |  | May | 2012-05-01 00:00:00
[NAME] | 2 Anglesea Road (flat 2) |  | May | 2012-05-01 00:00:00
[NAME] | 2 Anglesea Road (flat 3) |  | May | 2012-05-01 00:00:00
[NAME] | 91 Princes Road |  | May | 2012-05-01 00:00:00
[NAME] | 9 Dingle Vale |  | May | 2012-05-01 00:00:00
[NAME] | 44 Worcester Walk |  | May | 2012-05-01 00:00:00
[NAME] | 72 Rodney Street |  | May | 2012-05-01 00:00:00
[NAME] | 14 Ripon Street |  | May | 2012-05-01 00:00:00
[NAME] | 62 Violet Road |  | May | 2012-05-01 00:00:00
[NAME] | 14 Meadow Lane |  | May | 2012-05-01 00:00:00 |  | 500
[NAME] | 12 Darrell Drive |  | May | 2012-05-01 00:00:00
[NAME] | 35 Ottley Street |  | May | 2012-05-01 00:00:00