tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 789747d1659345421-equal-different-time-and-date-formats-different-date-time-formats
Sheet: Before

Header 1 | [NAME]
2017-04-19 22:50:14:380 | 2017-04-19 22:50:14.000
2017-04-19 22:50:19:419 | 2017-04-19 22:50:19.000
2017-04-19 22:50:19:421 | 2017-04-19 22:50:19.000
2017-04-19 22:50:19:430 | 2017-04-19 22:50:19.000
2017-04-19 22:50:53:074 | 2017-04-19 22:50:53.000
2017-04-19 22:50:53:199 | 2017-04-19 22:50:53.000
2017-04-19 22:50:53:210 | 2017-04-19 22:50:53.000
2017-04-29 16:17:59:505 | 2017-04-29 16:17:59.000
2017-04-29 16:18:01:476 | 2017-04-29 16:18:01.000
2017-04-29 16:18:01:488 | 2017-04-29 16:18:01.000
03/Aug/2018:09:02:21 | 2018-08-03 09:02:21.000
03/Aug/2018:09:07:03 | 2018-08-03 09:07:03.000
10-12-2019 02:22:09:065
10-12-2019 02:22:09:612
10-12-2019 02:22:09:620
10-12-2019 02:22:13:578
10-12-2019 02:22:14:287
10-12-2019 02:22:14:555
10-12-2019 02:22:14:562
10-12-2019 02:22:38:234
10-12-2019 02:22:38:242
10-12-2019 02:22:49:318
10-12-2019 02:22:49:327
10-12-2019 02:22:49:396
10-12-2019 02:22:49:396
10-12-2019 02:22:49:407
Spreadsheet: 292755d1390773505-trying-to-create-a-functional-spreadsheet-overhead-map-for-trailer-yard-excelforumtrailerinventory-2014-01-26-16-57
Sheet: Map

OFFICE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 987654 |  | A11111 |  |  | 987654 | YYY | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ROW C
 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  |  | 2 |  |  |  |  | 2
321098 |  |  |  |  | 3 |  |  |  |  | 3
 |  |  |  |  | 4 |  |  |  |  | 4
765432 |  |  |  |  | 5 |  |  |  |  | 5 | 6543210
 |  |  |  |  | 6 |  |  |  |  | 6
 |  |  |  |  | 7 |  |  |  |  | 7 | 123456
765432 |  |  |  |  | 8 |  |  |  |  | 8
 |  |  |  |  | 9 |  |  |  |  | 9
 |  |  |  |  | 10 |  |  |  |  | 10
987654 |  |  |  |  | 11 |  |  |  |  | 11 | [NAME]
 |  |  |  |  | 12 |  |  |  |  | 12
 | ROW A |  |  |  |  |  |  |  |  |  |  | ROW B
Spreadsheet: 173889d1344843189-need-a-macro-that-finds-and-replace-text-in-multiple-sheet-xxy
Sheet: Worksheet 11

MEASURES as values
The Americas | US | USA
 | CL | CHILE
 | CA | CANADA
 | MX | MEXICO
 | The Americas
Germany | DE | GERMANY
 | Germany
Europe + Africa | GB | UNITED KINGDOM
 | CH | SWITZERLAND
 | IT | ITALY
 | NL | NETHERLANDS
 | FR | FRANCE
 | FI | FINLAND
 | SE | SWEDEN
 | ES | SPAIN AND CANARY ISLANDS
 | BE | BELGIUM
 | TR | TURKEY
 | AT | AUSTRIA
 | DK | DENMARK
 | IE | IRELAND
 | PT | PORTUGAL
 | HU | HUNGARY
 | CZ | CZECH REPUBLIC
 | Europe + Africa
APAC | HK | HONG KONG (SAR) CHINA
 | TH | THAILAND
 | KR | KOREA REPUBLIC OF
 | CN | PEOPLE'S REPUBLIC OF CHIN
 | JP | JAPAN
 | SG | SINGAPORE
 | PH | PHILIPPINES
 | AU | AUSTRALIA
 | NZ | NEW ZEALAND
 | ID | INDONESIA
 | JO | JORDAN
 | APAC
[NAME] by Sales Org
Spreadsheet: f92c75ff-18b4-41a6-87ce-89810dbc0d6a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Not Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2013
 |  | Data Extracted on: December 9, 2013 (9:10 am)
Period | Value
Q1-2003 | X
Q2-2003 | X
Q3-2003 | X
Q4-2003 | 237399
Q1-2004 | 223675
Q2-2004 | 233241
Q3-2004 | 232983
Q4-2004 | 246201
Q1-2005 | 236033
Q2-2005 | 244136
Q3-2005 | 244711
Q4-2005 | 255856
Q1-2006 | 245182
Q2-2006 | 254735
Q3-2006 | 255745
Q4-2006 | 271401
Q1-2007 | 257973
Q2-2007 | 265739
Q3-2007 | 267325
Q4-2007 | 281304
Q1-2008 | 270217
Q2-2008 | 277643
Q3-2008 | 277604
Q4-2008 | 282885
Q1-2009 | 261948
Q2-2009 | 266881
Q3-2009 | 265508
Q4-2009 | 280622
Q1-2010 | 267483
Q2-2010 | 274697
Q3-2010 | 276055
Q4-2010 | 291990
Q1-2011 | 277885
Q2-2011 | 289552
Q3-2011 | 288862
Q4-2011 | 304550
Q1-2012 | 290131
Q2-2012 | 297462
Q3-2012 | 296119
Q4-2012 | 320584
Q1-2013 | 302663
Q2-2013 | 309664
Q3-2013 | X
Q4-2013 | X
Spreadsheet: 200021d1355392655-tree-structure-with-button-filter_example
Sheet: Sheet1

Main Category | Sub Category | Sub Sub Category
website redesign | gather requirements | meet with customer
website redesign | gather requirements | competitive research
website redesign | design | create wireframes
website redesign | design | detailed design
website redesign | design | review
website redesign | implementation | graphic design
website redesign | implementation | coding
website redesign | implementation | testing
Spreadsheet: 117374d1312744393-from-one-document-to-another-auto-filling-each-time-example
Sheet: Sheet1

WORK SHEET
Name:______________________________________
Date:_______________________________________
 | Occupied | Check Out | Change sheet | [NAME] | Night Shift | toilet | shower | sink | garbage | bed | dusting | COMMENTS
101
102
103
104
105
106
107
108
109
Spreadsheet: 785175d1656228867-consolidate-sheets-into-one-master-book1
Sheet: Area 2

First Name | Sir [NAME] | Age | Start Date | Finish Date
[NAME] | Smith | 66 | 1999-01-01 00:00:00 | 2020-06-07 00:00:00
[NAME] | Wayne | 68 | 2010-11-07 00:00:00 | 2021-08-01 00:00:00
Elvis | Presley | 71 | 1998-05-04 00:00:00 | 2005-11-15 00:00:00
[NAME] | [NAME] | 64 | 2001-03-15 00:00:00 | 2006-03-03 00:00:00
Spreadsheet: 0d0061e1-392d-4a0e-824f-9d7690545b3b
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0004988 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | [NAME] | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Chatham | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 2.37 |  | Area (acres): |  | 2.37 |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  | Trees |  | Cover Crop: |  | Trees |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.4 |  | [NAME] (in): |  | 0.4 |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 25 |  | Annual Rate (in): |  | 25 |  | Annual Rate (in): |  |  |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 38411d1236598118-excel-2007-issue-with-using-formulas-to-pull-data-from-one-sheet-to-another-lwnnsalariesprojections
Sheet: Dodgers

Los Angeles Dodgers | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 |  | Los Angeles Dodgers | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
Actual |  |  |  |  |  |  |  | Operations
Budget | 90 | 90 | 90 | 90 | 90 | 90
Difference |  |  |  |  |  |  |  | Fan Base Factors
 |  |  |  |  |  |  |  | Record Reward
Cost of Goods |  |  |  |  |  |  |  | Division Winner | 1
Personnel |  |  |  |  |  |  |  | LCS Winner | 1
Christian, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | Income
Tekotte, [NAME] | ML | ML | ML | ML | ML | ML
Westmoreland, [NAME] | ML | ML | ML | ML | ML | ML
[NAME] | ML | ML | ML | ML | ML | ML |  | Expenses
Boscan, Wilfredo | ML | ML | ML | ML | ML | ML |  | Helton, Todd | 0.1 | 0.1
Buckner, [NAME] | ML | ML | ML | ML | ML | ML |  | Jones, Jacque | 2
Castillo, [NAME] | ML | ML | ML | ML | ML | ML |  | [NAME], Derek | 2
Coke, [NAME] | ML | ML | ML | ML | ML | ML |  | Schneider, [NAME] | 0.8
Cox, [NAME] | ML | ML | ML | ML | ML | ML |  | To Brewers | 0.5
DiFelice, [NAME] | ML | ML | ML | ML | ML | ML |  | To Padres | 10.5
Donaldson, [NAME] | ML | ML | ML | ML | ML | ML
Freese, [NAME] | ML | ML | ML | ML | ML | ML
Frey, [NAME] | ML | ML | ML | ML | ML | ML
Hanigan, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], Darin | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
[NAME], George | ML | ML | ML | ML | ML | ML
Lugo, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
[NAME], Hector | ML | ML | ML | ML | ML | ML
Smoker, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Todd, Jess | ML | ML | ML | ML | ML | ML
Trinidad, Polin | ML | ML | ML | ML | ML | ML
Young Jr., [NAME] | ML | ML | ML | ML | ML | ML
Zimmerman, Jordan | ML | ML | ML | ML | ML | ML
Sabathia, C.C. | 19.3 | 19.3
Drew, J.D. | 13.5
[NAME], [NAME] | 8.7
Kuroda, [NAME] | 5.6 | 5.6 | 5.6
Winn, [NAME] | 4.7
Lilly, [NAME] | 3.9
Molina, Yadier | 3.5 | A3
Uggla, [NAME] | 3 | A2 | A3
Tallet, [NAME] | 2.6
Frasor, [NAME] | 2.3
Wilson, [NAME] | 2.2 | 2.2
Rauch, [NAME] | 2.2
Izturis, Maicer | 2 | A3
Rivera, [NAME] | 1.8
Lincecum, [NAME] | 0.7 | A1 | A2 | A3
Banks, [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Bierd, Randor | 0.3 | 0.7 | A1 | A2 | A3
Pearce, [NAME] | 0.3 | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Wade, [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Spreadsheet: 50805d1250280142-formula-with-muliple-outputs-detention-tracking
Sheet: Sheet2

[NAME]
ID | Last Name | First Name | Grade | Team | Date | Code | Demerits | 2009-11-10 00:00:00 | 2009-11-17 00:00:00 | 2009-11-24 00:00:00 | 2009-12-01 00:00:00 | 2009-12-08 00:00:00 | 2009-12-15 00:00:00 | 2009-12-22 00:00:00 | 2009-01-05 00:00:00 | 2009-01-12 00:00:00 | 2009-01-19 00:00:00 | 2009-01-26 00:00:00
125486 | Egbert | G | 8 | R | 2009-09-07 00:00:00 | T
125486 | Egbert | G | 8 | R | 2009-09-08 00:00:00 | T
125478 | Flowers | C | 7 | L | 2009-09-08 00:00:00 | ST | 2
541236 | Hill | D | 8 | Q | 2009-09-07 00:00:00 | T
541236 | Hill | D | 8 | Q | 2009-09-08 00:00:00 | T | 2
123456 | [NAME] | A | 6 | G | 2009-09-08 00:00:00 | Ref | 2
456789 | [NAME] | S | 6 | K | 2009-09-07 00:00:00 | T
456789 | [NAME] | S | 6 | K | 2009-09-08 00:00:00 | T | 2
235689 | Truss | E | 7 | L | 2009-09-07 00:00:00 | T
235689 | Truss | E | 7 | L | 2009-09-08 00:00:00 | T | 2
Spreadsheet: ef966b36-b28f-43d5-85ee-ca5642e7840f
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. NUR, RNSG) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom = Face  OR  Online Course = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and         seeking answers | M
[NAME] (e.g. NUR, RNSG) | PSY
Discipline codes: Nursing = 5138                            (4 digits) | 4200 | 5138 | 5138 | 5138 | 5138 | 5138 | 5138
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
NO Local Code for NURSING                                     Leave Blank
Long (L)  Forms | L | L | L | L | L | L | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 712652d1610360073-countifs-2-conditions-sample-countifs-file
Sheet: LSS Action Items

LSS Action Items | Status
LSS0001 | Closed
LSS0001 | In Progress
LSS0001 | In Progress
LSS0001 | In Progress
LSS0001 | In Progress
LSS0002 | Closed
LSS0003 | In Progress
LSS0003 | Closed
LSS0003 | In Progress
LSS0003 | In Progress
LSS0003 | Closed
LSS0003 | Closed
LSS0003 | In Progress
Spreadsheet: 715686d1611835287-replace-a-formula-to-find-multiple-partial-text-string-and-list-all-book1
Sheet: Sheet1

 |  |  |  |  |  | =IFERROR(LOOKUP(2,1/SEARCH(SUBSTITUTE(I5,"""",""),D$5:D$87),B$5:B$87),"")
 |  |  | Data comes in like this-: |  |  |  | [NAME] I have works fine for single instances
 | 2020-12-02 00:00:00 | D/D | 'NPOWER | -5 |  |  |  | HALFORDS
 | 2020-12-02 00:00:00 | D/D | BA GROUP LTD | -52.93 |  |  |  | 'NPOWER
 | 2020-12-02 00:00:00 | POS | 573 01DEC20 C , HALFORDS 079 , SH GB | -11.9 |  |  |  | ANIMAL HEALTHCARE
 | 2020-12-02 00:00:00 | POS | 573 01DEC20 C , STARBUCKS , SH GB | -6.12
 | 2020-12-03 00:00:00 | POS | 573 02DEC20 C , NEW GREAT WALL , SH GB | -32.6
 | 2020-12-04 00:00:00 | POS | 573 02DEC20 , AMZN DIGITA , L*MY6Y4 , 35661 LU | -3.29 |  |  | Final result would look like this
 | 2020-12-05 00:00:00 | D/D | 573 04DEC20 , ANIMAL HEALTHCARE | -13 |  |  | 2020-12-05 00:00:00 | ANIMAL HEALTHCARE | 13
 | 2020-12-17 00:00:00 | D/D | 573 16DEC20 , ANIMAL HEALTHCARE | -17
 | 2020-12-21 00:00:00 | POS | 573 06DEC20 , SAINSBURY S , SH GB | -48
 |  |  |  |  |  |  | fprmula puuled down over 3 rows
Spreadsheet: 841241d1693444313-if-formula-excel-test-ken
Sheet: 1D Validation

NPI | Pay Class | NPI | PRPR | AGAG
1234567 | MDCR100 | 9876543 | 887 | NC100
6543210 | MDCR100 | 9876542 | 888 | NC100
1234568 | MDCR100 | 9876541 | 889 | NC100
6543209 | MDCR100 | 9876540 | 890 | NC100
1234569 | MDCR100 | 9876539 | 891 | NC100
6543208 | MDCR100 | 9876538 | 892 | NC100
1234570 | MDCR100 | 9876537 | 893 | NC100
6543207 | MDCR100 | 9876536 | 894 | NC100
1234571 | MDCR100 | 9876535 | 895 | NC85
6543206 | MDCR100 | 9876534 | 896 | NC85
1234572 | MDCR100 | 9876533 | 897 | NC85
6543205 | MDCR100 | 9876532 | 898 | NC85
1234573 | MDCR100 | 1234581 | 899 | NC85
6543204 | MDCR100 | 1234580 | 900 | NC85
1234574 | MDCR100 | 1234579 | 901 | NC85
6543203 | MDCR100 | 1234578 | 902 | NC85
1234575 | MDCR100 | 1234577 | 903 | NC85
6543202 | MDCR100 | 1234576 | 904 | NC100
1234576 | MDCR85 | 1234575 | 905 | NC100
6543201 | MDCR85 | 1234574 | 906 | NC100
1234577 | MDCR85 | 1234573 | 907 | NC100
6543200 | MDCR85 | 1234572 | 908 | NC100
1234578 | MDCR85 | 1234571 | 909 | NC100
6543199 | MDCR85 | 1234570 | 910 | NC100
1234579 | MDCR85 | 1234569 | 911 | NC100
1234580 | MDCR85 | 1234568 | 912 | NC100
1234581 | MDCR85 | 1234567 | 913 | NC100
Spreadsheet: 117277d1312614016-using-and-to-check-2-conditions-786879_portsample
Sheet: Sheet1

location | species | dates | Sum of livecount | Sum of carcass count
Blue Volvo | corn oil | 2011-06-28 00:00:00 | 496 | 98
 | diesel | 2011-06-21 00:00:00 | 502 | 45
 |  | 2011-08-09 00:00:00 | 863 | 76
 | electric | 2011-10-10 00:00:00 | 483 | 46
 | gasoline | 2011-07-03 00:00:00 | 934 | 53
Blue Volvo Total |  |  | 3278 | 318
[NAME] | corn oil | 2011-08-02 00:00:00 | 925 | 1
 |  | 2011-08-23 00:00:00 | 975 | 86
 | diesel | 2011-06-23 00:00:00 | 799 | 92
 |  | 2011-06-28 00:00:00 | 525 | 18
 |  | 2011-07-02 00:00:00 | 148 | 16
 |  | 2011-08-16 00:00:00 | 870 | 35
Green Ford Total |  |  | 4242 | 248
Red Citroen | diesel | 2011-07-30 00:00:00 | 206 | 55
 |  | 2011-10-21 00:00:00 | 582 | 40
 | electric | 2011-06-21 00:00:00 | 581 | 67
 |  | 2011-06-28 00:00:00 | 381 | 86
Red Citroen Total |  |  | 1750 | 248
Silver Toyota | electric | 2011-06-23 00:00:00 | 673 | 14
 |  | 2011-07-02 00:00:00 | 522 | 82
 | gasoline | 2011-08-03 00:00:00 | 685 | 1
 |  | 2011-08-22 00:00:00 | 426 | 57
Silver Toyota Total |  |  | 2306 | 154
[NAME] | corn oil | 2011-10-19 00:00:00 | 218 | 57
 | diesel | 2011-06-23 00:00:00 | 928 | 68
 |  | 2011-07-03 00:00:00 | 783 | 50
 |  | 2011-08-05 00:00:00 | 705 | 47
 | electric | 2011-06-28 00:00:00 | 116 | 23
 |  | 2011-07-02 00:00:00 | 961 | 19
 |  | 2011-07-12 00:00:00 | 156 | 21
 |  | 2011-08-10 00:00:00 | 147 | 63
 |  | 2011-08-21 00:00:00 | 950 | 1
 |  | 2011-10-04 00:00:00 | 903 | 31
 | gasoline | 2011-06-23 00:00:00 | 887 | 6
White Landcruiser Total |  |  | 6754 | 386
[NAME] | corn oil | 2011-07-02 00:00:00 | 562 | 27
 | electric | 2011-08-11 00:00:00 | 241 | 69
 |  | 2011-08-29 00:00:00 | 287 | 44
Yellow Mazda Total |  |  | 1090 | 140
Grand Total |  |  | 19420 | 1494
Spreadsheet: 9f7323c3-0e43-4fa7-a72e-bca410598052
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
SSB | Test | SSB | SS-B/La Antibodies, IgG, Serum | SS-B/La Ab, IgG, S | [NAME] | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.35 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <1.0 U (negative) > or =1.0 U (positive) Reference values apply to all ages. | Monday through Saturday; 4 p.m. | 1 day | 3 days | 1 | 86235 |  |  |  |  | Rochester
SSB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
SSB | Result | SSB | SS-B/La Ab, IgG, S | SS-B/La Ab, IgG, S | Numeric |  |  |  |  | U |  |  |  |  |  |  |  |  |  | 33613-1 | Sjogrens syndrome-B extractable nuclear [NAME].IgG:ACnc:Pt:Ser:Qn:
Spreadsheet: 837764d1690400791-need-a-simple-formula-if-todays-date-is-august-1st-minus-6-days-then-return-balance-sample42
Sheet: Sheet1

 |  | Balance | 455.02
 |  | Jan | 455.02
 |  | Feb | 455.02
 |  | Mar | 455.02
 |  | Apr | 455.02
 |  | May | 455.02
 |  | Jun | 455.02
 |  | Jul |  | =IF TODAY [NAME]AUGUST J14 MINUS 6 DAYS, THEN RETURN BALANCE (D1)
 |  | Aug
 |  | Sep
 |  | Oct
 |  | Nov
 |  | Dec
Spreadsheet: 158245d1338110338-adding-charts-to-excel-excel-2010-example-7-
Sheet: Sheet1

week | Week 22
Row Labels | Sum of data1 | Sum of data2 | Sum of data3 | Sum of data4
Agent 1 | 1 | 1 | 0 | 1
Agent 2 | 1 | 1 | 0 | 1
Agent 3 | 1 | 1 | 0 | 1
Agent 4 | 1 | 1 | 0 | 0
Agent 5 | 1 | 1 | 0 | 1
Agent 6 | 1 | 0 | 0 | 1
Agent 7 | 1 | 1 | 0 | 1
Agent 8 | 1 | 1 | 1 | 0
Grand Total | 8 | 7 | 1 | 6
Spreadsheet: 64686d1265478384-problem-with-choices-disappearing-in-forms-combobox-when-selected-problem-100-
Sheet: Sheet2

 |  | ACTIVITY 1
A |  | COMMUNICATION |  | 28
B |  | CONSULTATION
C |  | DATA ANALYSIS
D |  | DATA REPORTING
E |  | EVALUATION
F |  | IMPLEMENTATION
G |  | MANAGEMENT
H |  | MEETINGS
I |  | PROFESSIONAL DEVELOPMENT
J |  | TRAINING
K
L |  | ACTIVITY 2
M |  | COMMUNICATION
N |  | CONSULTATION
O |  | DATA ANALYSIS
P |  | DATA REPORTING
Q |  | EVALUATION
R |  | IMPLEMENTATION
S |  | MANAGEMENT
T |  | MEETINGS
U |  | PROFESSIONAL DEVELOPMENT
V |  | TRAINING
W
X |  | ACTIVITY 3
Y |  | COMMUNICATION
Z |  | CONSULTATION
dd |  | DATA ANALYSIS
[NAME] |  | DATA REPORTING
 |  | EVALUATION
 |  | IMPLEMENTATION
 |  | MANAGEMENT
 |  | MEETINGS
 |  | PROFESSIONAL DEVELOPMENT
 |  | TRAINING
 |  | ACTIVITY 4
 |  | COMMUNICATION
 |  | CONSULTATION
 |  | DATA ANALYSIS
 |  | DATA REPORTING
 |  | EVALUATION
 |  | IMPLEMENTATION
 |  | MANAGEMENT
 |  | MEETINGS
 |  | PROFESSIONAL DEVELOPMENT
 |  | TRAINING |  | 24
 |  |  |  | 11
 |  | ACTIVITY 5 |  | 19
 |  | COMMUNICATION |  | 15
 |  | CONSULTATION |  | 1
 |  | DATA ANALYSIS |  | 1
 |  | DATA REPORTING |  | 1
 |  | EVALUATION |  | 1
 |  | IMPLEMENTATION |  | 1
 |  | MANAGEMENT |  | 1
 |  | MEETINGS |  | 1
 |  | PROFESSIONAL DEVELOPMENT |  | 1
 |  | TRAINING |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 15
Spreadsheet: 846942d1698072988-subtract-formula-required-formula-required
Sheet: Sheet1

Current Value | Previous Value | ANSWER
-114 | 0 | -114
-1968 | -3 | -1965
2 | 0 | 2
-3 | -5 | -2
1000 | 0 | 1000
1000 | 500 | 500
2000 | 3000 | -1000
-20 | 500 | -480
3000 | 1000 | 2000
-40 | -50 | -10
-5000 | 3000 | -2000
2000 | 2000 | 0
-200 | -600 | -400
2269 | -1181 | 1088
Spreadsheet: john_griffith__16155__1_25_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 19.5 | 175 | 185 | 48.1 | 50.9 | 0.61 | 2002-01-25 12:04:00
 | CL J2 | 20 | 276 | 283 | 47.5 | 48.7 | 0.6 | 2002-01-25 12:04:00
 | CL K2 | 20 | 345 | 360 | 46.1 | 48.1 | 0.59 | 2002-01-25 12:04:00
 | CL M2 | 20 | 392 | 400 | 45.2 | 46.1 | 0.57 | 2002-01-25 12:04:00
 | CL N2 | 20 | 425 | 440 | 43.3 | 44.9 | 0.55 | 2002-01-25 12:04:00
 | CL Q2 | 20 | 440 | 465 | 40.9 | 43.3 | 0.53 | 2002-01-25 12:04:00
 | CL U2 | 20 | 455 | 475 | 39.4 | 41.1 | 0.51 | 2002-01-25 12:04:00
 | [NAME] | 20 | 465 | 485 | 37.4 | 39.1 | 0.48 | 2002-01-25 12:04:00
 | CL X2 | 20 | 470 | 490 | 35.7 | 37.3 | 0.46 | 2002-01-25 12:04:00
 | [NAME] | 20 | 475 | 495 | 34.5 | 35.9 | 0.44 | 2002-01-25 12:04:00
 | CL F3 | 20 | 480 | 505 | 33.3 | 35 | 0.43 | 2002-01-25 12:04:00
 | CL G3 | 20 | 485 | 505 | 32.3 | 33.6 | 0.41 | 2002-01-25 12:04:00
 | CL M3 | 20.5 | 515 | 540 | 29.4 | 30.9 | 0.39 | 2002-01-25 12:04:00
 | CL Z3 | 20.5 | 530 | 560 | 26.4 | 28 | 0.35 | 2002-01-25 12:04:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 163605d1340378189-search-for-missing-matches-highlight-unused-numbers-problem
Sheet: Leadsheet

 |  | InputColumn
 |  | ok |  | ok |  | ok |  | ok |  | ok |  | ok |  | 2009 |  | ok |  | ok |  | ok |  | ok |  | ok
Account | Description | July |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | TOTALS
503101 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
509323 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
509401 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
509402 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 130770 |  | 1569240
509404 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
509405 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 4941803 |  | 59301636
509406 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
509408 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 5360 |  | 64320
509409 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
509410 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 72095 |  | 865140