tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 865152d1712204530-formula-that-will-pick-up-a-change-only-for-that-row-test3
Sheet: Expecting

 | Manual Entry |  | uses lookups |  | Assigns the Zone value in column D to each room that belongs to the same zone | Concats with columns H and J to form column I. Needed this to be able to create a unique instance in case I had rooms with identical names |  | Concatenated result. | uses lookups
 |  | Contains formulas | Contains formulas |  | Contains formulas | Contains formulas | Contains formulas | Contains formulas | Contains formulas
 | Number | Autofill | Layout |  | Helper Column | Helper Column | Helper Column | Helper Column | Rooms
 | ABC-DD- | Tag | Zone |  | 1 | 2 | 3 | 4
Group | 1 |  | A1 |  |  |  |  |  | Restroom 1
Group | 2 |  | A3 |  |  |  |  |  | Bed 1
Group but interupted.  if I insert a number here, cell H38 should update but without impacting the cell below, H39, which should still read ABC-DD-03 | 3 |  | A9 |  |  |  |  |  | Bed 1
 |  |  |  |  |  |  |  |  | Bed 2
 | 10 |  |  |  |  |  | ABC-DD-10 |  | Bed 3
 |  |  |  |  |  |  | ABC-DD-03 |  | Bed 3
Group | 8 |  | A6 |  |  |  |  |  | Kitchen
 |  |  |  |  |  |  |  |  | Dining
Group | 5 |  | A4 |  |  |  |  |  | Living 1
Group | 6 |  | A2 |  |  |  |  |  | Study
 |  |  |  |  |  |  |  |  | Lounge
 |  |  |  |  |  |  |  |  | Powder
 |  |  |  |  |  |  |  |  | Study 2
 |  |  |  |  |  |  | Final result
Spreadsheet: 674902d1588073778-index-match-returning-n-a-from-other-tab-pp_eh
Sheet: Background stuff_DO NOT AMEND!

[NAME] |  |  |  |  |  | On hold |  |  |  |  |  |  | Low |  | No |  |  | 0
Audrey & Ray |  |  |  |  |  | Not Started |  |  |  |  |  |  | Medium |  | Yes |  |  | 1
Client |  |  |  |  |  | In progress |  |  |  |  |  |  | High |  | N/A |  |  | 2
Ray |  |  |  |  |  | Completed |  |  |  |  |  |  |  |  | TBC |  |  | 3
Other (please specify in notes) |  |  |  |  |  | Total Tasks
Spreadsheet: 765671d1643477302-index-match-formula-only-works-for-a-portion-of-columns-cocktail-cost-calculator_support
Sheet: COGS Conversion

COGS CONVERSION
Company | Description | Size | UOM | CATEGORY | SUB-CATEGORY | GRS VALUE | DISCOUNT | REBTE ON GRS VAL | NET COST | 1 ML |  | 1 CL |  | 1 Ltr |  | 1 Oz |  | 1 Gr |  | 1 KG | 1 Piec/Pck | 6-Pack | 12-Pack | 24-Pack
Spreadsheet: joe_parks__14610__POSTIONTRAX_NOV
Sheet: HSC_SWAP

 | SELL |  |  |  | BUY
BEGINNING | 21 | 2.68 |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  | 21 | 2.63 |  |  |  |  | NEW DEALS
 | 21 | 2.64 |  |  | 10.5 | 2.63
 | 21 | 2.65 |  |  | 10.5 | 2.635 |  |  |  |  | TOTAL  P&L
 | 21 | 2.65
 | 10.5 | 2.59
 | 21 | 2.625 |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  | 10.5 | 2.55 |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  | 3 DAY ROLL
 |  |  |  |  |  |  |  |  |  |  | 230000
 |  |  |  |  |  |  |  |  |  |  | -366780
 |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  | -5.5
 |  |  |  |  |  |  |  |  |  |  | 12.5
 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  | ROLL VALUE
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 0364eab1-c30f-4b9b-9653-d0c627b7ccba
Sheet: Phone List

 | INCIDENT REPORTS 2013--Bluegrass Community & Technical College |  |  |  |  |  |  | [NAME]
 | Date | Time | Category | Description | Location | Disposition | Incident # | Notations
 | 2013-01-14 00:00:00 | 10:17:00 | Threat | Written (emails) | Room 111 | closed | D2013-01-01
 | 2013-01-18 00:00:00 | 15:26:00 | 911 | accidental | Room 103D | closed | D2013-01-02 | [NAME]
 | 2013-01-18 00:00:00 | 10:30:00 | Harassing Communications | telephone | Room 103C | closed | D2013-01-03 | King
 | 2013-01-30 00:00:00 | 07:44:00 | power outage | weather related | Campus | closed | D2013-01-04 | tornado warning
 | 3013-02-07 00:00:00 | 13:16:00 | alarm test | [NAME] test | Campus | closed | D2013-02-05 | drill
 | 2013-02-14 00:00:00 | 13:55:00 | Accident | student fell | mens restroom | closed | D2013-02-06 | broke nose
 | 2013-02-21 00:00:00 | 19:45:00 | accident | student fell | parking lot | closed | D2013-02-07 | hurt hip
 | 2013-02-25 00:00:00 | 09:00:00 | theft | handicap parking tag | parking lot | open | D2013-02-08 | report made
 | 2013-03-04 00:00:00 | 13:20:00 | poss theft | books not returned to owner | Campus | closed | D2013-03-09 | report made
 | 2013-03-13 00:00:00 | 14:38:00 | snap test | snap test/ 911 8second delay | Campus | closed | D2013-03-10 | report made
 | 2013-03-19 00:00:00 | 17:30:00 | Harassing | Student code of conduct | Smoking area | closed | D2013-03-11 | report made
 | 2013-03-26 00:00:00 | 10:30:00 | Injury | Welding shop  burn | Welding Shop | closed | D2013-03-12 | report made
 | 2013-04-08 00:00:00 | 17:00:00 | Injury | cut and bruise | Machine/tool | closed | D2013-04-13 | report made
 | 2013-05-08 00:00:00 | 07:45:00 | Injury | Abrasion | Outside, front | closed | D2013-05-14 | report made
 | Additional information- Todd Gray/Operations Manager of Security & Safety (859) 246-6422
Spreadsheet: joe_parks__14797__bridgeline 6-10
Sheet: Sheet1

b/s | contract | price | volume | time | cm | account | cti | order # | trader | reference | trade #
B | NGN2 | 3160 | 15 | 07:56:39 | 905 | 97563 | 4C | 2469 | amk | EO-2469 | 797 | 0 | N
B | NGN2 | 3178 | 25 | 05:49:47 | 905 | 97563 | 4C | 597 | amk | EO-597 | 588 | 0 | N
Spreadsheet: 269560d1381210589-index-and-match-help-production-status-1-
Sheet: Line3

 | 6/5# butter
Order # | Item # | CUSTOMER | TYPE | COUNT | POUNDS | Production Date | Lot # | Request | [NAME]
P | L |  |  |  |  | Not Happy |  | Date
P | L |  |  |  |  | Not Happy
P | L |  |  |  |  | Not Happy
P | L |  |  |  |  | Not Happy
P | L |  |  |  |  | Not Happy
q | T |  |  |  |  | Not Happy
q | T |  |  |  |  | Not Happy
q | T |  |  |  |  | Not Happy
Q | L |  |  |  |  | Happy
t | L |  |  |  |  | Not Happy
t | L |  |  |  |  | Not Happy
t | L |  |  |  |  | Not Happy
t | L |  |  |  |  | Not Happy
t | L |  |  |  |  | Not Happy
t | L |  |  |  |  | Not Happy
t | L |  |  |  |  | Not Happy
t | L |  |  |  |  | Not Happy
t | L |  |  |  |  | Not Happy
t | L |  |  |  |  | Not Happy
t | L |  |  |  |  | Not Happy
t | L |  |  |  |  | Not Happy
t | L |  |  |  |  | Not Happy
Spreadsheet: 210489d1359475281-golf-tournament-and-skins-pot-golf_skins-pcb-2
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Out | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | In | Total |  | Skins
GOLFERS | NAMES | 5 | 4 | 3 | 4 | 4 | 4 | 5 | 4 | 3 | 36 | 4 | 5 | 3 | 4 | 5 | 4 | 4 | 3 | 4 | 36 | 72
Wilfredo | Maldonado | 5 | 4 | 2 | 3 | 5 | 4 | 5 | 3 | 6 | 37 | 3 | 4 | 5 | 4 | 6 | 6 | 5 | 2 | 7 | 42 | 79 |  | $
[NAME] | Ridges | 5 | 4 | 4 | 3 | 4 | 7 | 5 | 5 | 4 | 41 | 5 | 6 | 4 | 5 | 5 | 3 | 4 | 3 | 3 | 38 | 79 |  | $
[NAME] | [NAME] | 4 | 4 | 4 | 5 | 4 | 5 | 7 | 4 | 3 | 40 | 5 | 4 | 5 | 4 | 6 | 3 | 3 | 5 | 5 | 40 | 80 |  | $
[NAME] | Majette | 4 | 5 | 3 | 4 | 4 | 4 | 5 | 5 | 4 | 38 | 5 | 5 | 4 | 3 | 4 | 6 | 6 | 4 | 5 | 42 | 80 |  | $
Ernie | Hooker | 5 | 5 | 4 | 5 | 4 | 4 | 7 | 3 | 2 | 39 | 5 | 6 | 2 | 4 | 5 | 6 | 4 | 4 | 5 | 41 | 80 |  | $
[NAME] | Bonilla | 4 | 3 | 2 | 5 | 4 | 5 | 5 | 5 | 4 | 37 | 5 | 5 | 5 | 4 | 6 | 4 | 5 | 4 | 6 | 44 | 81 |  | $
Al | Seda | 4 | 4 | 2 | 4 | 6 | 5 | 5 | 5 | 4 | 39 | 5 | 5 | 3 | 5 | 4 | 6 | 5 | 4 | 5 | 42 | 81 |  | $
[NAME] | [NAME] | 7 | 3 | 4 | 5 | 6 | 5 | 6 | 3 | 3 | 42 | 5 | 6 | 3 | 5 | 6 | 4 | 4 | 4 | 4 | 41 | 83 |  | $
Bernard | Hyson | 5 | 5 | 5 | 4 | 6 | 5 | 4 | 5 | 3 | 42 | 8 | 4 | 4 | 5 | 4 | 5 | 3 | 3 | 5 | 41 | 83
Rico | [NAME] | 7 | 5 | 4 | 3 | 4 | 4 | 6 | 5 | 3 | 41 | 4 | 6 | 2 | 5 | 5 | 5 | 4 | 6 | 5 | 42 | 83 |  | $
[NAME] | [NAME] | 4 | 5 | 5 | 4 | 5 | 5 | 4 | 5 | 4 | 41 | 5 | 4 | 5 | 5 | 5 | 5 | 4 | 4 | 6 | 43 | 84 |  | $
[NAME] | [NAME] | 6 | 4 | 3 | 3 | 4 | 3 | 8 | 5 | 4 | 40 | 5 | 6 | 6 | 6 | 5 | 4 | 4 | 5 | 4 | 45 | 85 |  | $
[NAME] | [NAME] | 6 | 5 | 4 | 4 | 5 | 6 | 6 | 6 | 5 | 47 | 7 | 4 | 3 | 5 | 4 | 5 | 3 | 4 | 5 | 40 | 87
[NAME] | West | 5 | 5 | 4 | 5 | 4 | 6 | 4 | 5 | 5 | 43 | 5 | 6 | 5 | 4 | 6 | 4 | 7 | 5 | 5 | 47 | 90
Walter | [NAME] | 4 | 4 | 4 | 5 | 5 | 8 | 5 | 6 | 4 | 45 | 4 | 6 | 5 | 4 | 5 | 6 | 5 | 7 | 4 | 46 | 91 |  | $
[NAME] | [NAME] | 6 | 6 | 4 | 4 | 5 | 4 | 6 | 6 | 5 | 46 | 5 | 5 | 5 | 4 | 8 | 5 | 6 | 5 | 6 | 49 | 95 |  | $
Winston | Agee | 7 | 6 | 4 | 5 | 3 | 5 | 6 | 5 | 6 | 47 | 5 | 6 | 4 | 5 | 7 | 8 | 6 | 4 | 7 | 52 | 99
[NAME] | Vazaquaz | 6 | 5 | 5 | 8 | 5 | 5 | 6 | 4 | 6 | 50 | 6 | 8 | 7 | 6 | 10 | 4 | 6 | 5 | 5 | 57 | 107 |  | $
10 | [NAME] | - | - | - | - | - | 3 | 4 | - | 2 |  | 3 | - | - | 3 | - | - | 3 | 2 | 3 |  |  | 8 | 14
 | Skins Payout |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.5
 |  | 4 | 3 | 2 | 3 | 4 | 3 | 4 | 3 | 2 |  | 3 | 4 | 2 | 3 | 4 | 3 | 3 | 2 | 3
 |  | 6 | 2 | 3 | 4 | 7 | 1 | 1 | 3 | 1 |  | 1 | 3 | 2 | 1 | 2 | 2 | 1 | 1 | 1
 |  | - | - | - | - | - | 3 | 4 | - | 2 |  | 3 | - | - | 3 | - | - | 3 | 2 | 3
Spreadsheet: bd2f2ad9-bfec-4b39-a7ed-4c97b2308613
Sheet: 2014-2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Political Science
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 013b761c-ed8c-4aef-b697-0f145f20f64f
Sheet: Timeline

Appendix A: Required Inventory Data Elements
 | Phase I - FY10 Inventory | Phase II - FY11 inventory
(A) A description of the services purchased by the executive agency | ü | ü
(B) A description of the role the services played in achieving agency objectives. |  | ü
(C) The organizational component of the executive agency administering the contract, and the organizational component of the agency whose requirements are being met through contractor performance of the service. | ü | ü
(D) The total dollar amount obligated for services under the contract and the funding source for the contract. | ü | ü
(E) The total dollar amount invoiced for services under the contract. |  | ü
(F) The contract type and date of award. | ü | ü
(G) The name of the contractor and place of performance. | ü | ü
(H) The number and work location of contractor employees, expressed as full-time equivalents for direct labor, compensated under the contract. |  | ü
(I) Whether the contract is a personal services contract. | ü | ü
(J) Whether the contract was awarded on a noncompetitive basis, regardless of date of award. | ü | ü
Spreadsheet: 838169d1690800725-create-a-new-table-from-rows-from-an-existing-data-set-based-on-a-cell-value-test-spreadsheet
Sheet: Sheet1

name | number of assessments | good | average | poor
fred | 1 | 1 | 0 | 0
barbara | 7 | 5 | 2 | 0
[NAME] | 42 | 32 | 7 | 3
[NAME] | 3 | 1 | 1 | 1
[NAME] | 2 | 2 | 0 | 0
helena | 1 | 1 | 0 | 0
[NAME] | 2 | 1 | 0 | 1
[NAME] | 84 | 70 | 10 | 4
martin | 9 | 3 | 3 | 3
[NAME] | 2 | 1 | 1 | 0
What I want to return
People with fewer than x assessments |  |  | x= | 3
name | number of assessments | good | average | poor
fred | 1 | 1 | 0 | 0
[NAME] | 2 | 2 | 0 | 0
helena | 1 | 1 | 0 | 0
[NAME] | 2 | 1 | 0 | 1
[NAME] | 2 | 1 | 1 | 0
Spreadsheet: john_griffith__15633__Book1
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strike | Bid | Offer | Mid-Pt. Vol | Net Change
 | M | 4.25 | 0.39 | 0.41 | 0.5191999999999967 | 0.06374999999999303
 | N | 4.3 | 0.65 | 0.67 | 0.5188999999999986 | 0.04439999999999511
 | Q | 4.4 | 0.85 | 0.87 | 0.5280999999999987 | 0.03779999999999584
 | U | 4.45 | 1.03 | 1.045 | 0.5340999999999988 | 0.02489999999999726
 | V | 4.5 | 1.15 | 1.19 | 0.536999999999999 | 0.02099999999999769
 | X | 4.65 | 1.35 | 1.37 | 0.548999999999999 | 0.02489999999999726
 | Z | 4.8 | 1.52 | 1.57 | 0.5581999999999981 | 0.02429999999999732
 | F | 4.9 | 1.68 | 1.72 | 0.5647999999999985 | 0.02429999999999732
 | G | 4.8 | 1.73 | 1.78 | 0.563299999999999 | 0.02159999999999762
 | H | 4.6 | 1.56 | 1.62 | 0.505699999999999 | 0.01169999999999877
 | J | 4.25 | 1.2 | 1.225 | 0.3967999999999988 | 0.01319999999999855
 | K | 4.25 | 1.08 | 1.18 | 0.3606500000000007 | 0.007649999999999157
 |  |  | 2001-05-07 15:16:10.420000
Spreadsheet: 683118d1592494624-averaging-x-most-recent-entries-in-a-column-given-a-match-in-another-column-golf-example
Sheet: Sheet1

[NAME] | 2019-04-05 00:00:00 | 85
[NAME] | 2020-04-06 00:00:00 | 88
Adam | 2019-05-06 00:00:00 | 81
[NAME] | 2020-04-10 00:00:00 | 78
[NAME] | 2019-05-09 00:00:00 | 79
Adam | 2020-06-06 00:00:00 | 82
[NAME] | 2018-05-05 00:00:00 | 85
[NAME] | 2019-04-04 00:00:00 | 81
Adam | 2019-07-07 00:00:00 | 84
[NAME] | 2018-08-08 00:00:00 | 78
Adam | 2019-07-07 00:00:00 | 79
[NAME] | 2020-06-06 00:00:00 | 83
[NAME] | 2019-08-08 00:00:00 | 82
[NAME] | 2018-07-07 00:00:00 | 87
Adam | 2018-08-08 00:00:00 | 78
Adam | 2017-06-06 00:00:00 | 79
[NAME] | 2018-05-05 00:00:00 | 82
[NAME] | 2019-04-04 00:00:00 | 85
[NAME] | 2020-05-10 00:00:00 | 84
Adam | 2018-04-19 00:00:00 | 78
[NAME] | 2017-07-30 00:00:00 | 87
Spreadsheet: 267337d1380048264-vlookup-with-multiple-matches-sample
Sheet: Sheet2

Tracking Number | Invoice | GL Code |  |  | Tracking Number | Invoice | GL Code
1234 | 1 | ABC |  |  | 1234 | 2
1234 | 2 | EFG |  |  | 3456 | 2
2345 | 2 | HIJ
3456 | 1 | KLM
3456 | 2 | PQR
4567 | 1 | TEST
5678 | 1 | BIRD
5678 | 2 | DOG
Spreadsheet: 215752d1361468599-count-of-occupied-beds-sample-test-formula
Sheet: Sheet2

 | Jan | Feb | Mar | Apr | May | Jun
1 | 0 | 0
2 | 0
3 | 0
4 | 0
5 | 0
6 | 0
7 | 0
8 | 0
9 | 0
10 | 0
11 | 0
12 | 0
13 | 0
14 | 0
15 | 0
16 | 0
17 | 0
18 | 0
19 | 0
20 | 0
21 | 0
22 | 0
23 | 0
24 | 0
Spreadsheet: 136397d1326606767-excel-2007-3-way-lookup-sample
Sheet: FLOWS

VANITEC - FLOWS
DATE | UDM | LSA | LSB | PSA | PSB | EQ. TANK | S.G. | F.P.I |  | F.P.II |  | S.W. | [NAME] |  | POLY
 |  |  |  |  |  |  |  | VOL. | R.H. | VOL. | R.H. |  | CONS. | STOCK | CONS. | STOCK
2011-12-01 00:00:00
2011-12-02 00:00:00
2011-12-03 00:00:00
2011-12-04 00:00:00
2011-12-05 00:00:00
2011-12-06 00:00:00
2011-12-07 00:00:00
2011-12-08 00:00:00
2011-12-09 00:00:00
2011-12-10 00:00:00
2011-12-11 00:00:00
2011-12-12 00:00:00
2011-12-13 00:00:00
2011-12-14 00:00:00
2011-12-15 00:00:00
2011-12-16 00:00:00
2011-12-17 00:00:00
2011-12-18 00:00:00
2011-12-19 00:00:00
2011-12-20 00:00:00
2011-12-21 00:00:00
2011-12-22 00:00:00
2011-12-23 00:00:00
2011-12-24 00:00:00
2011-12-25 00:00:00
2011-12-26 00:00:00
2011-12-27 00:00:00
2011-12-28 00:00:00
2011-12-29 00:00:00
2011-12-30 00:00:00
2011-12-31 00:00:00
Spreadsheet: 113165d1309149648-how-do-you-update-one-inventory-sheet-to-one-row-in-another-sheet-brambles-example-1-
Sheet: Master Sheet

Bungalow | Item | Monitoring | Check Regime | Date Checked | Last Checked by | Comments
Brambles | Care Plans | up to date | Weekly | 2011-05-17 00:00:00 | [NAME] | General forms not being completed such as Residential targets and Guidance signing sheets ,will send  an email to senior team to be put on team meeting agendas. | Regs
Brambles | Visitors Book | up to date | Weekly | 2011-06-12 00:00:00 | Jo | up to date | Regs | This row to only show the latest info from the Visitors Sheet.
Brambles | Tidiness of Bungalows | clean & tidy | Weekly | 2011-05-17 00:00:00 | [NAME] | All bungalows very similar in tidiness and had piles of unnamed clothes. |  | Note: This formula checks the last date entry in column B of the relevent sheet and give the corrosponding values of all columns
Brambles | Staff [NAME] | up to date | Weekly | 2011-05-17 00:00:00 | [NAME] | Bungalows struggling with staff sickness and vacancies. | Regs | if there are multiple sheets and you want to updata data of all sheets in Master sheet than use the formula given in E3:G3
Brambles | General wear and tear | report any problems/defects | Weekly | 2011-05-17 00:00:00 | [NAME] | A couple of items on various bungalows are broken/damaged but have been reported and are being actioned.
Brambles | Medicines Analysis | up to date | Weekly | 2011-05-17 00:00:00 | [NAME] | Willows meds checks hadn't been completed during the 2hr slot allowed. Staff member aware and was spoken to.
Brambles | Task List from each Bungalow | up to date | Weekly | 2011-05-17 00:00:00 | [NAME] | Not started yet
 |  |  |  | 2011-06-12 00:00:00 | Jo | up to date |  | in case ther is only one sheet the formula in E10:G10 could also be used.
Spreadsheet: 758980d1639210692-find-matching-cell-contents-in-a-2d-array-and-returning-the-rows-in-a-horizontal-array-example
Sheet: Tabelle1

 | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10
Owner 1 | kiwi | raspberry | star fruit
Owner 2 | apple | banana
Owner 3 | banana | kiwi | star fruit | cucumber
Owner 4 | raspberry | pear | apple | durian | blueberry | apple | banana | star fruit | cucumber
Owner 5 | raspberry | date | pear
Owner 6 | banana | star fruit
Owner 7 | pear | cucumber
Owner 8 | durian | raspberry | star fruit | orange | date
Owner 9 | raspberry
Owner 10 | pear | apple | banana | kiwi | raspberry | orange | date
Owner 11 | star fruit
Owner 12 | date
Owner 13 | cucumber
Owner 14 | banana | orange
Owner 15 | orange
Owner 16 | kiwi | star fruit | orange
Owner 17 | apple | banana | star fruit | cucumber
Owner 18 | date
Owner 19 | orange | cucumber
Owner 20 | kiwi | orange
 |  | Instance 1 | Instance 2 | Instance 3 | Instance 4 | Instance 5 | Instance 6 | Instance 7 | Instance 8 | Instance 9 | Instance 10
 | pear | Owner 4 | Owner 5 | Owner 7 | Owner 10
 | apple | Owner 2 | Owner 4 | Owner 4 | Owner 10 | Owner 17
Spreadsheet: 698323d1601922144-printing-without-the-value-blank-form
Sheet: WWC Team Metrics

 |  | APRIL |  |  |  |  |  |  |  | [NAME]? | No
 | Team | Agent | Username | IC | WR | WC's | [NAME] | Refused
 |  | [NAME] | dnorman | [NAME], Darnell | 0.8639728899227478 | 51 | 80.14285714285714 | 8
 |  | [NAME] | btaylor2 | [NAME], Brandi | 0.7660534641498703 | 39 | 61.28571428571428 | 6
 |  | Cherelle Palmer2 | cpalmer2 | Palmer2, Cherelle | 0.7839052211814894 | 68 | 106.8571428571428 | 13
 |  | [NAME] | [NAME] | Bustillos, [NAME] | 0.881961847211114 | 54 | 84.85714285714286 | 1
 |  | [NAME] | jwilson | Wilson, Janelle | 0.8934866694294793 | 73 | 114.7142857142857 | 30
 |  | [NAME] | charlesburger | Burger, [NAME] | 0.8115113833775256 | 61 | 95.85714285714285 | 3
 |  | Sage Roles | sroles2 | Roles2, Sage | 0.848855690698631 | 81 | 127.2857142857143 | 7
Spreadsheet: 272491d1382402892-how-to-target-a-cell-by-the-data-it-contains-ef509_dashboard_summaries
Sheet: Employee_2

Timesheet | Part time Hrs - Week 1 | Actual [NAME] | [NAME] | Annual Leave Hrs - Week 1 | Total - Week 1 | Difference - Week 1 | Overtime Hours - Week 1 | Overtime Shifts - Week 1 | Part time Hrs - Week 2 | Actual [NAME] 2 | [NAME] | Annual Leave Hrs - Week 2 | Total - Week 2 | Difference - Week 2 | Overtime Hours - Week 2 | Overtime Shifts - Week 2 | Total Hrs Per Fortnight (excludes OT Columns)
475 | 24 |  |  | 24 |  |  |  |  | 24 | 24
476 | 24 | 12 | 12 |  |  |  |  |  | 24 | 12
477 | 24 | 24 |  |  |  |  | 12 | 1 | 24 | 24
478 | 24 | 24 |  |  |  |  |  |  | 24 |  |  | 24
479 | 24 |  |  | 24 |  |  |  |  | 24 | 36
480 | 24 | 36 |  |  |  |  |  |  | 24 | 24 |  |  |  |  | 8 | 1
481 | 24 | 24 |  |  |  |  | 20 | 2 | 24 |  | 24
482 | 24 | 24 |  |  |  |  | 12 | 1 | 24 | 24
483 | 24 | 24 |  |  |  |  |  |  | 24 |  |  | 24
484 | 24 |  |  | 24 |  |  |  |  | 24 | 36
485 | 24 | 36 |  |  |  |  |  |  | 24 | 24 |  |  |  |  | 8 | 1
486 | 24 | 24 |  |  |  |  | 20 | 2 | 24 |  | 24
487 | 24 | 24 |  |  |  |  |  |  | 24 |  |  | 24
 |  |  |  |  |  |  |  |  | Net difference Rostered vs Worked |  |  |  |  | Avg Total hours/fortnight
 |  |  |  |  |  |  |  |  | Avg Net Difference Rostered vs Worked |  |  |  |  | Absenteeism /fortnight
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Overtime Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]/fortnight
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Overtime Shifts
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]/fortnight
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Worked over # pay cycles
Spreadsheet: c039fad8-426f-4d71-bd13-0e50323964aa
Sheet: Totals

 |  |  | B&W MFP | Color MFP | B/W MFD | Color MFD |  |  | B&W  MFP | Color  MFP
 |  | MFP:
 |  |  | B&W  Printer | Color  Printer | B/W Printer | Color Printer |  |  | B&W  Printer | Color  Printer
 |  | Printer:
 |  |  | Total B&W | Total  Color | Total B&W | Total  Color |  |  | Total B&W | Total  Color
 |  | Total:
 |  |  |  |  | Total This Invoice: |  |  |  | Total This Invoice:
 |  |  |  |  | HP Toner: |  |  |  | Total Invoice w/ HP Toner:
 |  |  |  |  | Invoice Total
 |  | MFP
 |  | Printer
 |  |  |  |  | MFP Total:
 |  |  |  |  | Printer Total:
 |  |  |  |  | Device Total:
Spreadsheet: 879425d1726919395-dept-and-date-to-auto-calculate-based-on-todays-date-book1-6-
Sheet: Sheet2 (2)

 |  | Shift
 | Dept | 1 | 2 | 3
 | Grocery
 | Deli
 | Meat
 | Freezer
 | Produce
Spreadsheet: 803644d1667580755-automatically-inputting-data-from-a-seleceted-month-into-a-sheet-test-3
Sheet: REport

 | Brand A | Part Number | Month Qty Required |  | Month Required | January
 | Brand A | PN282EFI
 | Brand A | PN282EFI
 | Brand A | PN282EFI
 | Brand A | PN282EFI
 | Brand A | PN283WFI
 | Brand A | PN283EFI
 | Brand A | PN283EFI
 | Brand A | PN284EFI
 | Brand A | PN284EFI
Spreadsheet: 233668d1367883851-list-of-names-that-needs-to-be-identical-and-updated-in-different-tables-across-sheets-example-spreadsheet
Sheet: Table1

 |  | Product Name | stat 1 | description | other info
 |  | Product1 | 56 | words | fill |  |  | So I would like to only modify one table for the product list, does not matter which one, and have it reflect on all of them, even if rows are removed and such since all other columns are dependent on the product name in the list.  All lists of product name will always contain the exact same list, but each table might be filtered to see something different at times and I do not want that to be reflected on other tables.
 |  | Product2 | 4 | text | filler
 |  | Product3 | 6 | stuff | just
 |  | Product4 | 3 | more stuff | filling
 |  | Product5 | 367 | things | in
 |  | Product6 | 36 | stuff | the
 |  | Product7 | 78 | text | space
 |  | Product8 | 568 | words | to
 |  | Product9 | 64 | [NAME] | have |  |  | The challenge I also have is when I need to add a new product to the list as well. Since changes are made often to the product name list often it is even more time consuming for me to populate several sheets of tables to ensure everyone is using the same information.  All tabs contain completely different information for every column except for the product names as they will always require all of the exact same products listed.
 |  | Product10 | 35 | blahbla | info
 |  | Product11 | 356 | des | in
 |  | Product12 | 68 | you | each
 |  | Product13 | 57 | get | row
 |  | Product14 | 46 | the | and
 |  | Product15 | 25 | point | sort
 |  |  |  | Due to the detail of each "product" used, each of the seven tables contain a lot of information and filled out by their specific person.  The only requirement is that they are able to use the filter feature to sort responses for every table and such.
Spreadsheet: 714533d1611259686-custom-time-formatting-paybonusforefcorrectedformula_mrshorty-1-
Sheet: Sheet1

Working time | Needed Result
7:15:00 | 8:00:00
7:45:00 | 8:00:00
8:15:00 | 8:23:00
8:45:00 | 9:08:00
9:15:00 | 9:53:00
9:45:00 | 10:38:00
10:15:00 | 11:23:00
10:45:00 | 12:08:00
11:15:00 | 12:53:00
11:45:00 | 13:38:00
12:15:00 | 14:23:00