tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 600344d1543607023-get-total-from-other-cells-w-formulas-testing-inventory-template
Sheet: Inventory 2.0

Item | Description | Pallet | Cartons | Pieces | Physical Count | Item | Description | Pallet | Cartons | Pieces | Physical Count
1610-00 | [NAME] (4/Cart) |  |  |  |  | Fax Switch | Fax Switch
1610-30 | X16 Server w/CO Card |  |  |  |  | MOH PLAYER | X16 Music on Hold Player
1630-00 | COExpCard (2 Port) (20/Cart) |  |  |  |  | Wired Headset | Wired Headset
1645-00 | [NAME] (20/Cart) |  |  |  |  | Wireless Headset | Wireless Headset
1670-00 | CH X16 EKT (10/Cart) |  |  |  |  | IP7G | IP7G (10/Cart)
1670-75 | PINK X16 EKT (10/Cart) |  |  |  |  | QB1 | QB1 (20/Cart)
1670-76 | RM X16 EKT (10/Cart) |  |  |  |  | QB2 | QB2 (5/Cart)
1670-86 | TM X16 EKT (10/Cart) |  |  |  |  | QB3 | QB3 (?/Cart)
1670-92 | VB X16 EKT (10/Cart) |  |  |  |  | QBCO4 | QBCO4 (?/Cart)
47-2501 | [NAME] (8/Cart) |  |  |  |  | [NAME] | [NAME] (50/Cart)
4COLA | 4PortFXOModule (8/Cart) |  |  |  |  | QB02 | QB02 (50/Cart)
47-9001 | X-50  Server (8/Cart) |  |  |  |  | QBS2 | QBS2 (50/Cart)
47-9001XL | [NAME] |  |  |  |  | EX08 | EX08 (?/Cart)
47-7002 | X-3030 IP Phone (6/Cart) |  |  |  |  | W56H | Yeastar Cordless Phone
X4040 | Color LCD (6/Cart) |  |  |  |  | W56? | Yeastar Cordless Phone w/ Base
24BTNDSS | [NAME] (18/Cart)
47-9002 | X2020 IP Telephone
47-9003 | X2020 Sidecar
2499-01 | X-7 USB Recorder
47-9004 | 8 Port Network Switch
47-7005 | [NAME]
XB1698-XB | [NAME] (72/Cart)
47-9006 | Ethernet Cable
91-1045 | 7ft Telephone Line Cords
4poeswitch | 4 Port PoE Switch
8poeswitch | 8 Port PoE Switch
Cordless Basic Phone | Basic Cordless Telephone
COsurge | Phone Line Surge Protection
Spreadsheet: 683878d1593020109-advanced-filter-how-to-write-formula-onto-the-criteria-cell-table
Sheet: Sayfa1

SalesRep | Sales | Experience |  |  |  | SalesRep |  | SalesRep | Sales | Experience
[NAME] | 10 | 1 |  |  |  | <>?????* |  | [NAME] | 10 | 1
[NAME] | 15 | 3 |  |  |  |  |  | [NAME] | 30 | 5
[NAME] | 30 | 5 |  |  |  |  |  | Anna | 25 | 4
George | 12 | 2
Anna | 25 | 4
Jordan | 13 | 2
Spreadsheet: 768371d1644938767-trying-to-look-up-and-filter-data-example
Sheet: K ABV

ABV
Component name | Result text
Spreadsheet: 797950d1664226946-sum-up-until-new-cell-with-data-appears-then-repeat-2022-09-26-oeldere1-rafael1024-summation-test-file-1-
Sheet: Sheet1

Produce | Quantity | Total |  | Sum up the produce until a new produce name appears
Apple | 1
 | 2
 | 2
 | 4 |  |  | with apple appearing in cell A2 and banana appearing in cell A6, the formula would only add up from B1:B5
[NAME] | 3
 | 5
 | 7 |  |  | with banana appearing in cell A6 and corn appearing in cell A9, the formula would only add up from B6:B8
Corn | 5
 | 5
 | 5
Pear | 6
 | 8
 | 9
 | 9 |  |  | Note: Apple, [NAME], Corn, & Pear, along with the blanks in between, are already being referenced with a formula
Spreadsheet: 101154d1299277208-add-adjacent-cells-inventory-sample
Sheet: Sheet1

Room | Shelf # | Product | Quantity |  |  | Totals
ROOM A | CARTON 44 | Product B | 2000 |  | Product B
ROOM A | CARTON 43 | Product B | 1700 |  | Product B
ROOM A | CARTON 37 | Product C | 2000 |  | Product C
ROOM A | CARTON 36 | Product C | 2000 |  | Product A
ROOM A | CARTON 35 | Product C | 2000
ROOM A | CARTON 38 | Product C | 2000
ROOM A | CARTON 39 | Product C | 2000 |  | B keeps duplicating
ROOM A | CARTON 40 | Product C | 1200 |  | formula for G3 = 3700 ?
ROOM A | CARTON 4 | Product A | 2000
ROOM A | CARTON 1 | Product A | 2000
ROOM A | CARTON 20 | Product A | 2000
ROOM A | CARTON 16 | Product A | 2000
ROOM A | CARTON 5 | Product A | 2000
ROOM A | CARTON 6 | Product A | 2000
ROOM A | CARTON 3 | Product A | 2000
ROOM A | CARTON 7 | Product A | 2000
ROOM A | CARTON 8 | Product A | 2000
ROOM A | CARTON 9 | Product A | 2000
ROOM A | CARTON 12 | Product A | 2000
ROOM A | CARTON 11 | Product A | 2000
ROOM A | CARTON 10 | Product A | 2000
ROOM A | CARTON 13 | Product A | 2000
ROOM A | CARTON 14 | Product A | 2000
ROOM A | CARTON 15 | Product A | 2000
Spreadsheet: 476998d1472099313-how-to-sort-timesheet-from-a-single-column-to-3-different-columns-result
Sheet: Sheet1

UserAccount | UserName | Company | WorkDate | Day | Clock In | Clock Out | Work Hours
32 | [NAME] | Swift | 2016-07-01 00:00:00 |  | 08:53:13 | 18:12:18 | 9.31805555569008
32 | [NAME] | Swift | 2016-07-04 00:00:00 |  | 08:38:40 | 18:13:23 | 9.57861111103557
32 | [NAME] | Swift | 2016-07-05 00:00:00 |  | 08:38:21 | 18:30:08 | 9.863055555615574
32 | [NAME] | Swift | 2016-07-06 00:00:00 |  | 08:38:24 | 18:16:43 | 9.63861111109145
32 | [NAME] | Swift | 2016-07-07 00:00:00 |  | 08:36:29 | 18:12:35 | 9.601666666567326
32 | [NAME] | Swift | 2016-07-08 00:00:00 |  | 08:25:51 | 18:07:16 | 9.690277777786832
32 | [NAME] | Swift | 2016-07-11 00:00:00 |  | 08:34:17 | 18:01:10 | 9.448055555520114
32 | [NAME] | Swift | 2016-07-12 00:00:00 |  | 08:25:32 | 19:18:30 | 10.8827777778497
32 | [NAME] | Swift | 2016-07-13 00:00:00 |  | 08:33:18 | 18:13:13 | 9.665277777705342
32 | [NAME] | Swift | 2016-07-14 00:00:00 |  | 08:30:39 | 18:19:04 | 9.806944444484543
32 | [NAME] | Swift | 2016-07-15 00:00:00 |  | 08:25:36 | 18:00:31 | 9.581944444274995
32 | [NAME] | Swift | 2016-07-20 00:00:00 |  | 08:52:05 | 18:02:10 | 9.168055555550382
32 | [NAME] | Swift | 2016-07-21 00:00:00 |  | 08:36:21 | 18:01:41 | 9.42222222208511
32 | [NAME] | Swift | 2016-07-22 00:00:00 |  | 08:30:24
32 | [NAME] | Swift | 2016-07-24 00:00:00 |  | 08:13:47 | 18:08:20 | 9.909166666679084
32 | [NAME] | Swift | 2016-07-25 00:00:00 |  | 08:52:41 | 18:13:02 | 9.3391666666721
32 | [NAME] | Swift | 2016-07-26 00:00:00 |  | 08:27:17 | 18:14:07 | 9.78055555553874
32 | [NAME] | Swift | 2016-07-27 00:00:00 |  | 08:27:29 | 18:03:29 | 9.600000000034925
32 | [NAME] | Swift | 2016-07-28 00:00:00 |  | 08:18:57 | 18:11:43 | 9.879444444493856
32 | [NAME] | Swift | 2016-07-29 00:00:00 |  | 08:31:18 | 18:15:05 | 9.72972222219687
Spreadsheet: 5ef038fd-1328-465c-bdd1-d5e382e4637c
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Offshoreutstyr
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Aukra Maritime AS | Nautnes | 6480 | Aukra | 71 17 17 00
[NAME] | Øyav. 60 | 4270 | Åkrehamn | 52 84 45 20
[NAME] | Industriv. 40 | 1337 | Sandvika | 67 13 69 80 | 67 13 46 35
PSSI AS | [NAME] g 6 | 3012 | Drammen | 400 04 325 | 32 89 90 91
Trelleborg Offshore Norway AS | Kalosjeg. 15 | 3055 | [NAME] | 32 23 20 00
Cosalt Offshore Norway AS | Bekhuskaien 1 | 4013 | Stavanger | 51 55 45 00
[NAME] | Fyrstikkalléen 17 | 0661 | Oslo | 22 70 68 00 | 22 70 68 01
Northrop Grumman [NAME] BV | Damsgårdsv. 167 | 5160 | Laksevåg | 55 94 94 94 | 55 34 52 27
Maritim Service AS | [NAME] | 5450 | Sunde i Sunnhordland | 53 48 29 29 | 53 48 29 20
[NAME] | Høgslundv. 49 | 2020 | Skedsmokorset | 06706
Bull industri- og skipsteknisk as | Ringeriksv. 241 | 1340 | Skui | 67 17 54 00
GearConsult | Griniv. 159 | 1359 | Eiksmarka | 400 08 003
Origo Solutions AS | [NAME] | 4623 | Kristiansand | 920 80 500
Jumo AS | Storg. 2B | 1767 | Halden | 67 97 37 10 | 67 97 37 11
Origo Solutions AS | Kanalarmen 12 | 4033 | Stavanger | 920 80 500
Origo Solutions AS | Teknologiv. | 4846 | Arendal | 920 80 500
Scana Offshore Vestby AS | Tverrv. 4 | 1540 | Vestby | 64 95 65 00 | 64 95 65 01
Apply Leirvik AS | Storhaugv. 130 | 5416 | Stord | 53 49 62 00 | 53 49 62 01
Øglænd System AS | Engelsvollv. 264 | 4353 | Klepp stasjon | 51 78 81 00 | 51 78 81 60
Vinje Industri AS | Skibåsen 10A | 4636 | Kristiansand | 38 03 88 00
Kongsberg Seatex AS | Pirsenteret | 7462 | Trondheim | 73 54 55 00 | 73 51 50 20
[NAME] | Stålverksv. 1 | 0661 | Oslo | 22 70 77 00 | 22 70 77 01
AS Robinet | Davanger | 5310 | Hauglandshella | 56 15 28 80 | 56 15 28 88
TESS AS | Industrig. 8 | 3414 | [NAME] | 32 84 40 00 | 32 84 40 01
Aker Process Systems AS | [NAME]. 36 | 1364 | Fornebu | 67 83 77 00 | 67 83 77 99
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 735750d1623160669-finding-macthed-values-m-and-p-book-1-a
Sheet: Sheet1

 | 1M | 1M |  | 1P | 1P |  | 2M | 2M |  | 2P | 2P |  | 3M | 3M |  | 3P | 3P |  | 4M | 4M |  | 4P | 4P |  | 5M | 5M |  | 5P | 5P
 | M |  |  |  |  |  |  |  |  | P |  |  | M |  |  |  |  |  |  |  |  | P |  |  | M
 |  | M |  |  |  |  |  |  |  |  | P |  |  |  |  |  | P |  |  |  |  |  | P |  |  | M
 |  |  |  | P |  |  |  |  |  | P |  |  | M |  |  |  |  |  | M |  |  |  |  |  |  |  |  | P
 |  |  |  |  | P |  |  |  |  |  | P |  |  |  |  |  | P |  |  |  |  |  | P |  |  |  |  |  | P
 | M |  |  |  |  |  |  |  |  | P |  |  |  |  |  | P |  |  |  |  |  | P |  |  | M
 |  |  |  |  | P |  |  |  |  |  | P |  |  | M |  |  |  |  |  | M |  |  |  |  |  | M
 |  |  |  | P |  |  | M |  |  |  |  |  |  |  |  | P |  |  | M |  |  |  |  |  | M
 |  |  |  |  | P |  |  | M |  |  |  |  |  |  |  |  | P |  |  |  |  |  | P |  |  |  |  |  | P
 |  |  |  | p |  |  |  |  |  | P |  |  |  |  |  | P |  |  | M |  |  |  |  |  |  |  |  | P
 | M
 |  | M
 |  |  |  | P
 |  |  |  |  | P
 | M
 |  |  |  |  | p
 |  |  |  | p
 |  |  |  |  | P
 |  |  |  | P
Spreadsheet: 770696d1646228144-formula-not-working-when-cell-is-indexed-range-count-test
Sheet: range count test

 |  | 2022-02-02 00:00:00 |  |  |  |  |  |  | 2022-02-02 00:00:00
18:01:09 | 2022-02-02 00:00:00 |  | 1 | 18:01:09 | 19:00:44 |  | 18:01:09 | 2022-02-02 00:00:00 |  | 1 | 18:01:09 | 19:00:44
18:09:04 | 2022-02-02 00:00:00 |  |  |  |  |  | 18:09:04 | 2022-02-02 00:00:00
18:12:12 | 2022-02-02 00:00:00 |  |  |  |  |  | 18:12:12 | 2022-02-02 00:00:00
18:18:06 | 2022-02-02 00:00:00 |  |  |  |  |  | 18:18:06 | 2022-02-02 00:00:00
18:23:11 | 2022-02-02 00:00:00 |  |  |  |  |  | 18:23:11 | 2022-02-02 00:00:00
18:48:18 | 2022-02-02 00:00:00 |  |  |  |  |  | 18:48:18 | 2022-02-02 00:00:00
18:52:05 | 2022-02-02 00:00:00 |  |  |  |  |  | 18:52:05 | 2022-02-02 00:00:00
18:53:47 | 2022-02-02 00:00:00 |  |  |  |  |  | 18:53:47 | 2022-02-02 00:00:00
18:57:14 | 2022-02-02 00:00:00 |  |  |  |  |  | 18:57:14 | 2022-02-02 00:00:00
19:00:44 | 2022-02-02 00:00:00 |  |  |  |  |  | 19:00:44 | 2022-02-02 00:00:00
19:03:16 | 2022-02-02 00:00:00 |  |  |  |  |  | 19:03:16 | 2022-02-02 00:00:00
19:05:29 | 2022-02-02 00:00:00 |  |  |  |  |  | 19:05:29 | 2022-02-02 00:00:00
19:09:30 | 2022-02-02 00:00:00 |  |  |  |  |  | 19:09:30 | 2022-02-02 00:00:00
19:12:11 | 2022-02-02 00:00:00 |  |  |  |  |  | 19:12:11 | 2022-02-02 00:00:00
19:14:18 | 2022-02-02 00:00:00 |  |  |  |  |  | 19:14:18 | 2022-02-02 00:00:00
19:21:53 | 2022-02-02 00:00:00 |  |  |  |  |  | 19:21:53 | 2022-02-02 00:00:00
18:41:11 | 2022-02-05 00:00:00 |  |  |  |  |  | 18:41:11 | 2022-02-05 00:00:00
18:44:04 | 2022-02-05 00:00:00 |  |  |  |  |  | 18:44:04 | 2022-02-05 00:00:00
18:57:38 | 2022-02-05 00:00:00 |  |  |  |  |  | 18:57:38 | 2022-02-05 00:00:00
19:07:16 | 2022-02-05 00:00:00 |  |  |  |  |  | 19:07:16 | 2022-02-05 00:00:00
Spreadsheet: 797688d1664053676-populate-record-based-on-list-value-and-table-data-employee-list-sample
Sheet: Sheet1

Last Name | First Name | Employee # | Hire Date | Department | Job Title | Hazard Communication | Emergency Action Plan | Ergonomics | [NAME] | Personal Protective Equipment | Hearing Conservation | Security Awareness | [NAME] | Safety Rules | Electrical Safety | First Aid/CPR/AED | Knife Safety | LOTO - Authorized | LOTO - Affected | Electric Pallet Jack | Forklift | Scissor Lift | Fall Protection | Confined Entry | Baler | [NAME] | Power Tools
Doe1 | [NAME] | 12345 | 04/28/1997 | Material Handling | Forklift Operator I | 2022-01-26 00:00:00 | 2021-04-14 00:00:00 |  | 2004-03-23 00:00:00 | 2003-05-29 00:00:00 |  | 2020-07-17 00:00:00 | 2021-10-14 00:00:00 | 2002-11-12 00:00:00 |  |  |  | 2002-10-18 00:00:00 |  |  | 2022-01-07 00:00:00 |  |  | 2003-06-20 00:00:00
Doe2 | [NAME] | 12346 | 11/09/1998 | Rework | Production Specialist | 2022-01-25 00:00:00 | 2021-04-06 00:00:00 |  | 2004-03-23 00:00:00 | 2003-05-29 00:00:00 |  | 2020-07-06 00:00:00 | 2021-10-14 00:00:00 | 2002-11-18 00:00:00 |  |  | 2020-02-13 00:00:00 | 2002-10-18 00:00:00 |  |  | 2022-01-07 00:00:00 |  |  | 2003-06-20 00:00:00
Doe3 | [NAME] | 12347 | 2022-02-21 00:00:00 | General Mfg | Front Office
Doe4 | [NAME] | 12348 | 11/09/1998 | Assembly | Assembly Production Operator | 2022-01-24 00:00:00 | 2021-04-07 00:00:00 |  | 2004-03-23 00:00:00 | 2003-05-29 00:00:00 | 2022-01-11 00:00:00 | 2020-07-08 00:00:00 |  | 2003-06-11 00:00:00 |  |  | 2020-01-12 00:00:00 | 2002-10-18 00:00:00 |  |  |  |  |  | 2003-06-20 00:00:00
Doe5 | [NAME] | 12349 | 01/10/2000 | Shipping | Shipping Operator | 2022-01-26 00:00:00 | 2021-04-06 00:00:00 |  | 2004-03-23 00:00:00 | 2003-05-29 00:00:00 |  | 2020-07-07 00:00:00 |  | 2002-11-18 00:00:00 |  |  |  | 2002-10-18 00:00:00 |  |  |  |  |  | 2003-06-20 00:00:00
[NAME] | [NAME] | 12350 | 2022-04-11 00:00:00 | Molding | Molding Production Operator |  | 2021-04-05 00:00:00
Doe7 | Jan | 12351 | 04/14/1997 | Molding | Shift Lead | 2022-01-26 00:00:00 | 2021-04-05 00:00:00 |  | 2022-02-24 00:00:00 | 2003-05-29 00:00:00 | 2022-01-13 00:00:00 | 2020-07-13 00:00:00 | 2021-10-14 00:00:00 | 2002-11-18 00:00:00 |  | 2021-01-27 00:00:00 | 2020-02-11 00:00:00 | 2022-01-28 00:00:00 |  |  |  |  |  | 2003-06-20 00:00:00
Doe8 | John1 | 12352 | 2022-07-05 00:00:00 | Molding | Molding Production Operator
Doe9 | Jane1 | 12353 | 2005-02-23 00:00:00 | Sales | Front Office | 2005-02-24 00:00:00 | 2005-02-24 00:00:00 |  | 2005-02-24 00:00:00 | 2005-02-24 00:00:00 |  |  |  | 2005-02-24 00:00:00 |  |  |  | 2005-02-24 00:00:00 |  |  |  |  |  | 2005-02-24 00:00:00
Doe10 | [NAME] | 12354 | 2019-01-02 00:00:00 | QC | QC Inspector | 2022-01-17 00:00:00 | 2021-04-06 00:00:00 |  | 2022-02-23 00:00:00 | 2019-02-08 00:00:00 | 2022-01-11 00:00:00 | 2020-07-09 00:00:00 | 2021-10-14 00:00:00 | 2019-02-08 00:00:00 |  | 2021-01-25 00:00:00 | 2020-01-31 00:00:00 | 2019-02-08 00:00:00 |  |  |  |  |  | 2019-02-08 00:00:00
Spreadsheet: michelle_lokay__26563__imbalsumm0012
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 21055 | 19223 | 10745 | 10000
2 | 21202 | 19584 | 10722 | 10000
3 | 17314 | 17788 | 10773 | 10000
4 | 27334 | 19584 | 10003 | 10000
5 | 30871 | 33371 | 10556 | 10500
6 | 31042 | 29250 | 9009 | 10500
7 | 31704 | 34250 | 9973 | 10500
8 | 31619 | 34219 | 9894 | 10000
9 | 31577 | 30678 | 11348 | 8750
10 | 31492 | 30632 | 11398 | 8750 | 671
11 | 31398 | 30267 | 11008 | 8750
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  |  |  |  |  |  |  | -532429.6
2000-12-11 00:00:00
 |  |  | 516.78
 |  |  | 212.08
 |  |  | 58.33
 |  |  | 25
Spreadsheet: 755263d1636740068-textjoin-in-a-spill-array-formula-textjoin-in-a-spill-array-formula
Sheet: Planilha1

ID | ESTADO |  |  |  |  |  |  |  |  |  |  |  |  |  | =UNIQUE(Tabela1[ID])
1234 | RJ |  |  |  |  |  |  |  |  |  | ID | CIDADE |  |  | ID | CIDADE
1234 | SP |  |  | SP |  |  |  |  |  |  |  | ES / RJ |  |  |  |  | =CHOOSE(ROW(P3#)-2,TEXTJOIN(" / ",,INDEX(E2#,,1)),TEXTJOIN(" / ",,INDEX(E2#,,2)),TEXTJOIN(" / ",,INDEX(E2#,,3)),TEXTJOIN(" / ",,INDEX(E2#,,4)))
1234 | DF |  |  | DF |  |  |  |  |  |  | 1212 | SP / DF / RJ / ES / MA / AM / RO / MT / MS / PI / PE / RN |  |  | 1111 | ES / RJ
1111 | ES |  |  |  | ES |  |  |  |  |  | 1215 | US |  |  | 1212 | SP / DF / RJ / ES / MA / AM / RO / MT / MS / PI / PE / RN
1111 | RJ |  |  |  | RJ |  |  |  |  |  | 1234 | RJ / SP / DF |  |  | 1215 | US
1212 | SP |  |  |  |  | SP
1212 | DF |  |  |  |  | DF |  |  |  |  |  | ES / RJ
1212 | RJ |  |  |  |  | RJ |  |  |  |  | 1212 | SP / DF / RJ / ES / MA / AM / RO / MT / MS / PI / PE / RN
1212 | ES |  |  |  |  | ES |  |  |  |  | 1215 | US
1212 | MA |  |  |  |  | MA |  |  |  |  | 1234 | RJ / SP / DF
1212 | AM |  |  |  |  | AM
1212 | RO |  |  |  |  | RO
1212 | MT |  |  |  |  | MT
1212 | MS |  |  |  |  | MS
1212 | PI |  |  |  |  | PI
1212 | PE |  |  |  |  | PE
1212 | RN |  |  |  |  | RN
1215 | US |  |  |  |  |  | US
 |  |  |  |  |  |  |  |  |  |  |  | ES / RJ
 |  |  |  |  |  |  |  |  |  |  | 1212 | SP / DF / RJ / ES / MA / AM / RO / MT / MS / PI / PE / RN
 |  |  |  |  |  |  |  |  |  |  | 1215 | US
 |  |  |  |  |  |  |  |  |  |  | 1234 | RJ / SP / DF
Spreadsheet: 95566d1295157582-transfer-data-to-another-worksheet-and-create-hyperlink-opl-database6
Sheet: OPL

2
ONE POINT LESSON |  |  |  | PREPARED BY: |  | PERIOD |  | TEAM: | [NAME]
 |  |  |  | [NAME] | [NAME] | P4  2010
 |  |  |  | NUMBER: | 2
SUBJECT: |  | Do It Again
 |  |  |  |  |  |  |  |  |  |  |  |  | TITLE | LAST NAME | FIRST NAME | TEAM | LINE | AREA | SUBJECT | YEAR | PERIOD | OPL #
 |  |  |  |  |  |  |  |  |  |  |  |  | Do It Again | [NAME] | [NAME] | [NAME] | Bk MX | OFS | PRC | E&I | 2011 | 2 | [NAME]
APPROVED BY: |  |  | [NAME] |  |  |  | DATE:
Spreadsheet: 142149d1329688210-summarise-data-from-multiple-sheets-based-on-dates-test-data
Sheet: Area 3

Date | reference | problem |  |  | problem a
 |  |  |  |  | problem b
2012-02-01 00:00:00 | abc657 | [NAME] |  |  | problem c
2012-02-02 00:00:00 | [NAME] | problem a |  |  | [NAME]
2012-02-19 00:00:00 | abc659 | [NAME]
2012-02-19 00:00:00 | abc660 | problem c
2012-02-19 00:00:00 | abc661 | problem b
2012-02-19 00:00:00 | abc662 | problem b
2012-02-19 00:00:00 | abc663 | problem c
2012-02-19 00:00:00 | abc664 | problem a
2012-02-19 00:00:00 | abc665 | problem a
Spreadsheet: 58123b90-8d14-4a01-aa9e-5876a6a4b30d
Sheet: Turner's Pitches

Turner's Pitches
 |  |  | Date Bought | Date Sold | Days Owned | Paid | Price | Shares | Cost | Value | Gain | Annualized
 |  | F | 2012-02-03 00:00:00 | 2013-04-01 00:00:00 |  | 12.47 | 13.01 | 65 | 810.5500000000001
 |  | NGVC | 2012-11-30 00:00:00 |  |  | 19.49 |  | 75 | 1471.7
 |  | YHOO | 2013-03-01 00:00:00 |  |  | 21.75 |  | 100 | 2174.99
 |  | YRCW | 2013-03-22 00:00:00 | 2013-05-03 00:00:00 |  | 8.61 | 11.25 | 100
 |  | YRCW | 2013-03-22 00:00:00 |  |  | 8.61 |  | 200 | 1722
Spreadsheet: 213875d1360680943-can-i-get-results-using-a-pivot-table-pivot_table_or_somethingelse
Sheet: Output

Split_Variable | All | <====Would like something like this via a pivot table where what I select here would effect what is in the table below.
 | A
 | B
Month-Year | Header1 | Header2 | Header3 | Header4 | Header5 | Header6 | Header7 | TOTAL
2011-11-01 00:00:00 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | <===This table …...contents of this table are as follows:  Header1 has 1 row which contains a date in the month of november 2011, 51 rows in the month of december 2011
2011-12-01 00:00:00 | 51 | 0 | 0 | 0 | 0 | 0 | 0 | 51
2012-01-01 00:00:00 | 145 | 26 | 0 | 0 | 0 | 0 | 0 | 171
2012-02-01 00:00:00 | 167 | 100 | 7 | 0 | 0 | 0 | 0 | 274
2012-03-01 00:00:00 | 257 | 167 | 70 | 0 | 0 | 0 | 0 | 494
2012-04-01 00:00:00 | 332 | 189 | 141 | 0 | 0 | 0 | 0 | 662
2012-05-01 00:00:00 | 74 | 382 | 179 | 0 | 0 | 0 | 0 | 635
2012-06-01 00:00:00 | 59 | 133 | 307 | 0 | 0 | 0 | 0 | 499
2012-07-01 00:00:00 | 9 | 72 | 269 | 0 | 0 | 0 | 0 | 350
2012-08-01 00:00:00 | 1 | 18 | 64 | 28 | 0 | 0 | 0 | 111
2012-09-01 00:00:00 | 2 | 3 | 38 | 100 | 0 | 0 | 0 | 143
2012-10-01 00:00:00 | 0 | 1 | 7 | 174 | 0 | 0 | 0 | 182
2012-11-01 00:00:00 | 0 | 1 | 0 | 190 | 0 | 0 | 0 | 191
2012-12-01 00:00:00 | 0 | 0 | 2 | 387 | 0 | 0 | 0 | 389
2013-01-01 00:00:00 | 0 | 0 | 0 | 99 | 13 | 0 | 0 | 112
2013-02-01 00:00:00 | 0 | 0 | 0 | 62 | 82 | 0 | 0 | 144
2013-03-01 00:00:00 | 0 | 0 | 0 | 14 | 153 | 0 | 0 | 167
2013-04-01 00:00:00 | 0 | 0 | 0 | 2 | 176 | 0 | 0 | 178
2013-05-01 00:00:00 | 0 | 0 | 0 | 1 | 338 | 0 | 0 | 339
2013-06-01 00:00:00 | 0 | 0 | 0 | 1 | 192 | 0 | 0 | 193
2013-07-01 00:00:00 | 0 | 0 | 0 | 0 | 68 | 28 | 0 | 96
2013-08-01 00:00:00 | 0 | 0 | 0 | 0 | 29 | 96 | 0 | 125
2013-09-01 00:00:00 | 0 | 0 | 0 | 0 | 5 | 169 | 0 | 174
2013-10-01 00:00:00 | 0 | 0 | 0 | 0 | 1 | 199 | 28 | 228
2013-11-01 00:00:00 | 0 | 0 | 0 | 0 | 1 | 354 | 96 | 451
2013-12-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 128 | 177 | 305
2014-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 66 | 191 | 257
2014-02-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 13 | 342 | 355
2014-03-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 3 | 137 | 140
2014-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 1 | 69 | 70
2014-05-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 1 | 13 | 14
2014-06-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3
2014-07-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
2014-08-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
Spreadsheet: 36b4807f-b2cc-4aa6-81ed-15b4bd915fb7
Sheet: 1997-98

Table F
Student Numbers by [NAME] and Method of Study
1997-98
 | Full Time |  |  | Part Time |  |  | Total
 | Male | Female | Total | Male | Female | Total | Male | Female | Total
Undergraduate | 4699 | 4897 |  | 155 | 91 |  | 4854 | 4988
%
Graduate | 1961 | 1836 |  | 746 | 630 |  | 2707 | 2466
%
Total
Spreadsheet: 70db9285-519b-465f-8a00-89fc71b35e7d
Sheet: Sheet1

Nombre
[NAME], [NAME], por la que se convocan las audiciones [NAME] producción del [NAME]
[NAME], temporada 2014-2015
[NAME] y [NAME]. Noviembre 2014
Procedimiento de evaluación y [NAME] competencias profesionales: [NAME] en vivo
Hay un artista en mi cocina
Técnica, entrenamiento e interpretación vocal para profesionales del mundo de la Magia
Introducción a la [NAME]: Moodle
Promoción del tejido profesional [NAME], [NAME], la danza y los espectáculos dirigidos [NAME] infantil y juvenil en Andalucía, apoyo a la producción [NAME]
Enrédate 2015, [NAME] (teatros municipales)
Taller de programación de consolas de iluminación
Convocatoria del procedimiento de selección de ofertas de espacios [NAME]
Taller de sonorización y grabación de directos
Patronaje y confección a medida. [NAME], [NAME]
Taller de &quot;Microteatro&quot;
Curso &quot;Introducción al diseño [NAME];
Curso &quot;Técnica de Maquinaria Escénica y construcción de decorados&quot;
El Centro de Documentación de las Artes Escénicas de Andalucía galardonado en la II edición de los Premios del Teatro Andaluz
Teatros Romanos de Andalucía 2014
[NAME]: ciclos de formación en Danza Contemporánea, Española y Neoclásica 2014/2015
Espacios escénicos andaluces: estudio estadístico
Spreadsheet: 67046d1267691756-align-match-data-from-2-sheets-into-1-sheet-b-e-n-f001
Sheet: Compare

AA Docket | Issue | Version | Status | HH Docket | Issno
00-50-00-00A-016 | 3 | 1.4 | Pub | 00-50-00-00A-016 | 3 | STATUS | Issues match
 |  |  |  | 00-50-00-00A-016 | 2 | CHANGED | HH only
 |  |  |  | 00-50-01-01A-077 | 2 | CHANGED | HH only
00-50-01-01A-077 | 3 | 1.3 | Pub | 00-50-01-01A-077 | 3 | STATUS | Issues match
 |  |  |  | 00-50-01-02A-077 | 2 | CHANGED | HH only
00-50-01-02A-077 | 3 | 1.4 | Ready | 00-50-01-02A-077 | 3 | STATUS | Issues match
 |  |  |  | 00-50-01-03A-077 | 2 | CHANGED | HH only
00-50-01-03A-077 | 3 | 1.3 | Pub | 00-50-01-03A-077 | 3 | STATUS | Issues match
 |  |  |  | 00-50-01-04A-077 | 3 | CHANGED | HH only
00-50-01-04A-077 | 4 | 1.3 | Pub | 00-50-01-04A-077 | 4 | CHANGED | Issues match
00-50-01-05A-077 | 3 | 1.3 | Pub | 00-50-01-05A-077 | 3 | STATUS | Issues match
 | Step 1 | Data from sheet HH is copied across to sheet Compare, columns E to G
 | Step 2 | As data is copied across from sheet AA to sheet Compare it is placed in the corresponding
 |  | matching row.
 |  |  | in our example A2 and B2 match up with E2 and F2 therefore they are placed on the same row.
 | Step 3 | When these all match up then the entry in column H indicates 'Issues match' (as in our example cell H2)
 | Step 4 | If there is no data from sheet AA that matches with an entry in column E and F then column H indicates 'HH only"
 |  |  | in our example there is no matching data in A3 and B3 to line up with the data in E3 and F3
 |  |  | therefore A3 and B3 remain empty and our example indicates 'HH only' in cell H3