tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 827330d1682611996-how-to-make-2-sums-equal-with-formulas-excelhelp
Sheet: IE

Expenditure | Amount | Income | Amount
To Meeting Expenses A/c | 795 | By Interest Received A/c | 18148.52
To Conveyance Expenses A/c | 1012 | By [NAME]
To Computer Expenses A/c | 6275
To Printing and Stationery A/c | 250
To Postage A/c | 138
To legal expenses | 7000
To Surplus | 2678.52
Spreadsheet: 554b845c-18a4-4f5b-a5df-14c7a97e6ba5
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0034350 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Hendersonville WWTP | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Henderson | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did conjunctive utilization occur at this facility? |  |  |  |  |  | Field Name: |  | Bulk Distribution |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage             (if applicable) | 5-Day Upset              (if applicable) | Bulk Volume Distributed |  |  |  | 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 (gallons): |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Spreadsheet: 0bf933d8-8657-45ef-b74a-bca84c1f8a83
Sheet: Sheet1

RefWorks | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
2007-2008
Metric | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | Total | 2007-2008 Price | Cost per unit
New Users | 8 | 19 | 60 | 75 | 23 | 11 | 10 | 78 | 16 | 21 | 8 | 6 | 335 | 12485 | 37.26865671641791
Repeat Users | 16 | 17 | 34 | 57 | 89 | 74 | 34 | 58 | 76 | 91 | 42 | 23 | 611 | 12485 | 20.43371522094926
Total Monthly Users | 24 | 36 | 94 | 132 | 112 | 85 | 44 | 136 | 92 | 112 | 50 | 29 | 946 | 12485 | 13.19767441860465 | per user
Total Sessions per month | 168 | 93 | 294 | 721 | 559 | 340 | 176 | 488 | 355 | 640 | 127 | 137 | 4098 | 12485 | 3.046608101512933 | per session
Average Sessions Per User | 7 | 2.58 | 3.13 | 5.46 | 4.99 | 4 | 4 | 3.59 | 3.86 | 5.71 | 2.54 | 4.72 | 51.58 | 12485 | 242.0511826289259
Total Subscriber References added | 990 | 296 | 1903 | 1701 | 1408 | 597 | 466 | 1532 | 1367 | 1505 | 581 | 788 | 13134 | 12485 | 0.9505862646566164 | per reference added
Average References added per user | 41.25 | 8.22 | 20.24 | 12.89 | 12.57 | 7.02 | 10.59 | 11.26 | 14.86 | 13.44 | 11.62 | 27.17 | 191.13 | 12485 | 65.32203212473186
Spreadsheet: 0a8bce26-c259-4370-9454-3553150f3fae
Sheet: Biol 2

 |  |  | 11-12 |  |  |  |  | 11-12 Total | 12-13 |  |  |  |  | 12-13 Total | 13-14 |  |  |  |  | 13-14 Total
Major | [NAME] | CrseNum | A | B | C | D | F |  | A | B | C | D | F |  | A | B | C | D | F
Biology Education-Grades 6-12 | BIOL | 102 |  | 2 |  |  |  | 2 | 1 |  |  |  |  | 1 | 1 |  | 1 |  |  | 2
 |  | 102L |  | 1 | 1 |  |  | 2 | 1 |  |  |  |  | 1 |  | 1 | 1 |  |  | 2
 |  | 211 | 1 | 1 | 1 |  |  | 3 | 1 |  |  |  |  | 1 | 1 |  | 1 |  |  | 2
 |  | 250 |  |  |  |  | 1 | 1 |  |  | 1 |  |  | 1
 |  | 315 | 1 | 1 | 1 |  |  | 3 |  | 1 |  |  |  | 1 |  |  | 2 |  |  | 2
 |  | 321 |  |  |  |  |  |  |  | 1 |  |  |  | 1
 |  | 339 | 1 | 1 | 1 |  |  | 3 | 1 |  |  |  |  | 1 |  |  | 2 | 1 |  | 3
 |  | 404 | 3 |  |  |  |  | 3 | 1 |  |  |  |  | 1 | 2 |  |  |  |  | 2
 |  | 410 | 1 |  | 2 |  |  | 3 | 1 |  |  |  |  | 1 |  |  | 2 |  |  | 2
 | CHEM | 101 |  | 1 | 1 |  | 1 | 3 | 1 |  |  |  |  | 1 |  |  | 1 | 1 |  | 2
 |  | 102 |  |  | 2 |  |  | 2 |  |  | 1 |  |  | 1 | 1 |  | 1 | 1 |  | 3
Biology Education-Grades 6-12 Total |  |  | 7 | 7 | 9 |  | 2 | 25 | 7 | 2 | 2 |  |  | 11 | 5 | 1 | 11 | 3 |  | 20
Spreadsheet: 284d70d5-ad87-4d7f-a312-2b207ce179f1
Sheet: Charter Lite

Project |  | Sponsor
Project Manager |  | Date Updated
Background
Business need and business benefits
Objectives
Scope | In Scope | Out of Scope
[NAME] | [NAME] | Due Date
Key Considerations | Assumptions & Constraints
Success criteria | 1 -
 | 2 -
 | 3 -
Signatures | Signature
Sponsor
 | Printed name
 | Date
Project Manager
 | Signature
 | Printed name
 | Date
Spreadsheet: 828117d1683229523-dynamically-unpivot-without-power-query-with-merge-columns-and-rows-dynamically-unpivot-without-power-query-including-custom-headers
Sheet: Sheet1

Week | Target | All Products |  | Apple |  |  |  |  | Week | Target | Product | Count Type | Actual
 |  | Cumulative | Week | Cumulative | Week |  |  |  | Week 1 | 75 | All Products | Cumulative | 72.4
Week 1 | 75 | 72.4 | 81.4 | 72.4 | 81.4 |  |  |  | Week 1 | 75 | All Products | Week | 81.4
Week 2 | 80 | 72.5 | 77 | 72.5 | 77 |  |  |  | Week 1 | 75 | Apple | Cumulative | 72.4
Week 3 | 85 | 72.9 | 79 | 72.9 | 79 |  |  |  | Week 1 | 75 | Apple | Week | 81.4
 |  |  |  |  |  |  |  |  | Week 2 | 80 | All Products | Cumulative | 72.5
 |  |  |  |  | A whole blank row to separate data |  |  |  | Week 2 | 80 | All Products | Week | 77
 | Merge row/column |  |  |  |  |  |  |  | Week 2 | 80 | Apple | Cumulative | 72.5
 |  |  |  |  |  |  |  |  | Week 2 | 80 | Apple | Week | 77
 |  |  |  |  |  |  |  |  | Week 2 | 85 | All Products | Cumulative | 72.9
 |  |  |  |  |  |  |  |  | Week 2 | 85 | All Products | Week | 79
 |  |  |  |  |  |  |  |  | Week 2 | 85 | Apple | Cumulative | 72.9
 |  |  |  |  |  |  |  |  | Week 2 | 85 | Apple | Week | 79
 |  |  |  |  | Desired Result in Dynamic Array Output
Spreadsheet: 115889d1311347855-excel-2007-matching-columns-worksheetone
Sheet: Worksheet2

productID | sectionID
2 | 12
5 | 12
6 | 14
8 | 7
14 | 7
16 | 4
18 | 4
24 | 4
26 | 12
29 | 13
35 | 12
36 | 12
42 | 12
49 | 12
53 | 7
56 | 7
58 | 9
59 | 7
60 | 7
67 | 7
68 | 10
81 | 4
82 | 4
85 | 4
86 | 9
89 | 4
90 | 12
93 | 12
94 | 9
95 | 9
96 | 12
101 | 4
106 | 4
107 | 7
108 | 12
125 | 7
129 | 12
130 | 4
153 | 9
156 | 7
158 | 9
160 | 12
172 | 9
177 | 13
184 | 12
196 | 2
202 | 7
207 | 7
210 | 9
224 | 7
225 | 2
229 | 7
234 | 8
235 | 7
239 | 12
251 | 7
260 | 7
261 | 7
288 | 9
301 | 9
302 | 9
306 | 9
313 | 9
324 | 8
329 | 7
341 | 7
342 | 7
347 | 7
348 | 7
351 | 7
354 | 9
360 | 7
369 | 9
374 | 7
387 | 7
392 | 12
398 | 7
403 | 9
411 | 7
413 | 7
418 | 7
419 | 9
425 | 8
426 | 9
427 | 13
429 | 12
430 | 12
439 | 3
440 | 7
441 | 13
444 | 4
445 | 12
446 | 4
447 | 7
448 | 7
449 | 12
450 | 12
457 | 14
457 | 124
465 | 12
469 | 9
470 | 9
481 | 9
486 | 7
489 | 12
490 | 9
492 | 9
493 | 4
499 | 12
500 | 7
505 | 12
506 | 12
511 | 7
520 | 7
523 | 7
528 | 7
531 | 13
539 | 8
563 | 9
575 | 9
577 | 4
578 | 9
579 | 4
581 | 4
582 | 4
583 | 4
584 | 9
589 | 1
593 | 4
594 | 16
607 | 8
619 | 8
624 | 12
627 | 7
629 | 12
638 | 12
644 | 9
652 | 10
653 | 8
658 | 7
660 | 9
663 | 12
664 | 12
666 | 12
669 | 9
Spreadsheet: robin_rodrigue__33258__HS_STORAGE
Sheet: QueryPage

 |  |  | BookList
 |  | BookName |  | Date | SheetName | RangeName | SQL
 |  |  |  |  | GRMS Detail | GRMSQueryReturnArea
Spreadsheet: 537383d1505035039-trying-to-bring-up-every-9th-entry-from-a-column-andy-excel-bsb-
Sheet: Sheet1

Value 1
Value 2
Value 3
Value 4
Value 5
Value 6
Value 7
Value 8
Value 9
Value 10
Value 11
Value 12
Value 13
Value 14
Value 15
Value 16
Value 17
Value 18
Value 19
Value 20
Value 21
Value 22
Value 23
Value 24
Value 25
Value 26
Value 27
Value 28
Value 29
Value 30
Value 31
Value 32
Value 33
Value 34
Value 35
Value 36
Value 37
Value 38
Value 39
Value 40
Value 41
Value 42
Value 43
Value 44
Value 45
Value 46
Value 47
Value 48
Value 49
Value 50
Value 51
Value 52
Value 53
Value 54
Value 55
Value 56
Value 57
Value 58
Value 59
Value 60
Value 61
Value 62
Value 63
Value 64
Value 65
Value 66
Value 67
Value 68
Value 69
Value 70
Value 71
Value 72
Value 73
Value 74
Value 75
Value 76
Value 77
Value 78
Value 79
Value 80
Value 81
Value 82
Value 83
Value 84
Value 85
Value 86
Value 87
Value 88
Value 89
Value 90
Spreadsheet: 680573d1591096447-match-and-condense-from-dataset-samplesheet
Sheet: Sheet1

What I HAVE. |  |  |  |  |  | What I NEED. |  |  |  |  |  | What I've TRIED.
Identifier | Option A | Option B | Option C |  |  | Identifier | Option A | Option B | Option C |  |  | Identifier | Option A | Option B | Option C
1 | Yes | Yes |  |  |  | 1 | Yes | Yes | Yes |  |  | 1
1 |  |  | Yes |  |  | 2 |  | Yes |  |  |  | 2
1 | Yes |  |  |  |  | 3 |  |  |  |  |  | 3
2 |  |  |  |  | > | 4 | Yes | Yes | Yes |  |  | 4
2 |  | Yes
3
4 | Yes
4 |  |  | Yes
4 | Yes | Yes
Spreadsheet: richard_shapiro__32170__shapiro-1
Sheet: cont

COST CENTER |  | OTHER BUSINESS EXPENSE | PRIORITY | REQUESTED | APPROVED | COMMENTS
[NAME] | P | Republican - RNC | A | 100000 | 100000 | [NAME] held 12/7/00
 | P | Republican - NRCC | A | 100000 | 100000 | [NAME] held 12/7/00
 | P | Republican - NRSC | A | 100000 | 100000 | [NAME] held 12/7/00
 | P | Republican - IRI | B | 10000 | 10000 | [NAME] held 12/7/00
 | P | Democratic - DNC | A | 100000 | 100000 | [NAME] held 12/7/00
 | P | Democratic - DSCC | A | 50000 | 50000 | [NAME] held 12/7/00
 | P | Democratic - DCCC | A | 50000 | 50000 | [NAME] held 12/7/00
 | P | Democratic - DLC | A | 50000 | 50000 | [NAME] held 12/7/00
 | P | Democratic - NDN | A | 10000 | 10000 | [NAME] held 12/7/00
 | P | Democratic - NDI | B | 10000 | 10000 | [NAME] held 12/7/00
 |  | Total Other Business Expense
Spreadsheet: 780410d1652440740-if-formula-using-index-match-with-help-from-helper-sample-1-
Sheet: Sheet1

Old Report
PARTICIPANT_NAME | NUMBER | BOOKING_ID | SERVICE_BOOKING_TYPE | SUPPORT_CATEGORY | SUPPORT_Number | START_DATE | END_DATE | STATUS
Participant 3 | 741035032 | 3497568 | Standard | IT Support | 06_05_001_1_5 | 2022-03-20 00:00:00 | 2023-03-20 00:00:00 | Active
Participant 6 | 246487752 | 5731648 | Standard | IT Support | 06_05_001_1_5 | 2021-04-11 00:00:00 | 2022-06-30 00:00:00 | Active
Participant 5 | 845963037 | 5973164 | Standard | IT Support | 06_05_001_1_5 | 2022-04-12 00:00:00 | 2022-04-30 00:00:00 | Active
Participant 1 | 294566094 | 6565625 | Standard | IT Support | 06_05_001_1_5 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | Active
Participant 2 | 676442211 | 6795483 | Standard | IT Support | 06_05_001_1_5 | 2021-05-30 00:00:00 | 2022-04-30 00:00:00 | Inactive
Participant 4 | 130289078 | 9346824 | Standard | IT Support | 06_05_001_1_5 | 2021-10-11 00:00:00 | 2022-04-17 00:00:00 | Active
New Report
PARTICIPANT_NAME | NUMBER | BOOKING_ID | SERVICE_BOOKING_TYPE | SUPPORT_CATEGORY | SUPPORT_Number | START_DATE | END_DATE | STATUS | TRUE / FALSE | Current Formula | Cell Meant To Say
Participant 1 | 294566094 | 6565625 | Standard | IT Support | 06_05_001_1_5 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | Active |  |  | No Change in Plan
Participant 2 | 676442211 | 6795483 | Standard | IT Support | 06_05_001_1_6 | 2021-05-30 00:00:00 | 2022-04-30 00:00:00 | Inactive |  |  | New but Not Active
Participant 3 | 741035032 | 3497568 | Standard | IT Support | 06_05_001_1_7 | 2022-03-20 00:00:00 | 2023-03-20 00:00:00 | Active |  |  | No Change in Plan
Participant 4 | 130289078 | 9346824 | Standard | IT Support | 06_05_001_1_8 | 2021-10-11 00:00:00 | 2023-04-17 00:00:00 | Active |  |  | Extended
Participant 5 | 845963037 | 5973164 | Standard | IT Support | 06_05_001_1_9 | 2022-05-01 00:00:00 | 2023-05-01 00:00:00 | Active |  |  | New
Participant 6 | 246487752 | 5731648 | Standard | IT Support | 06_05_001_1_10 | 2021-04-11 00:00:00 | 2022-06-30 00:00:00 | Active |  |  | No Change in Plan
Spreadsheet: 159152d1338517772-vlookup-help-sample
Sheet: Sheet2

Project Number 1 | Outsourced | Vendor 1 | -5411
 |  | Vendor 2 | -541
 | Inhouse | Costs | -571 |  |  |  | Expected Ressult
 |  |  | -4413
 |  |  | -541 |  |  |  | Project Number | Outsourced | Inhouse | Revenue
 | Revenue | Coustomer 1 | 6584 |  |  |  | Project Number 1
 |  | Customer 2 | 1532 |  |  |  | Project Number 2
Project Number 2 | Outsourced | Vendor 2 | -26
 | Inhouse | Costs | -52
 |  |  | -5412
 |  |  | -252
 |  |  | -14563
 |  |  | -123
 | Revenue | Coustomer 1 | 56516
 |  | Customer 2 | 123
 |  | Customer 3 | 521
Project Number 3
Spreadsheet: 47434d1246467834-copy-row-by-range-ef0702
Sheet: Sheet1

header1 | header2 | [NAME] | header4 | [NAME] | header6 | header7
1 | a | a | a | a | a | a
2 | 12 | 13 | 14 | a | a | a
2 | 12 | 13 | 14 | a | a | a
3 | 12 | 13 | 14 | a | a | a
3 | 12 | 13 | 14 | a | a | a
3 | 12 | 13 | 14 | a | a | a
3 | 12 | 13 | 14 | a | a | a
4 | 12 | 13 | 14 | a | a | a
4 | 13 | 13 | 14 | a | a | a
5 | 14 | 13 | 14 | a | a | a
6 | 15 | 16 | 17 | a | a | a
7 | 16 |  | 17 | a | a | a
7 | 17 |  | 17 | a | a | a
8 | 18 |  | 17 | a | a | a
9 | 19 | 20 | 17 | a | a | a
9 |  | 20 |  | a
10 | 20 | 20 | 17 | a | a | a
10 | 21 |  | 17 | a | a | a
11 | 22 |  | 17 | a | a | a
12 | 23 |  | 17 | a | a | a
13 | 24 |  | 17 | a | a | a
14 | 25 |  | 17 | a | a | a
14 | 26 |  | 17 | a | a | a
Spreadsheet: 106789d1303967276-2-lists-of-coordinates-i-wanna-find-the-closest-distbetweenpoints
Sheet: Sheet1

List 1 | x | y
A | 30 | 57 |  | Distance from Point A(30,57) to Point B(60,73)
B | 60 | 73 |  | Can be found by using the Pythagorean Theorum
C | 57 | 70 |  | The base of the triangle is 30 - 60 or 30
D | 45 | 62 |  | The height of the triangle is 57 - 73 or 16
E | 80 | 60
 |  |  |  | Distance between them is SQRT(30^2 + 16^2)
 |  |  |  | Do the above for each possible pair of points to see which is shortest
 |  |  |  | A to B
 |  |  |  | A to C
 |  |  |  | A to D
 |  |  |  | A to E
 |  |  |  | B to C
 |  |  |  | B to D
 |  |  |  | B to E
 |  |  |  | C to D
 |  |  |  | C to E
 |  |  |  | D to E
Spreadsheet: 810147d1671567909-sum-with-more-than-one-column-criteria-s666-pq-sum-with-more-than-one-column-criteria
Sheet: Sheet1

Project No. | Root Project | Compensation |  | List | Root Project | Compensation
000016.000 | 16 | 80705 |  | 000016.000,000016.001,000016.002,000016.003 | 16 | 107440
000016.001 | 16 | 8000 |  | 000017.000,000017.001 | 17 | 36500
000016.002 | 16 | 2295
000016.003 | 16 | 16440
000017.000 | 17 | 35000
000017.001 | 17 | 1500
Spreadsheet: 99688d1298297254-forumla-for-data-from-seperate-tabs-testcrystal
Sheet: Crystal Report

 |  | Date | Title | First Name | Last Name | Number | Hotkey | From | SOLD? | REF NUM
 |  | 2010-08-16 00:00:00 | Mr | Test | File | 12101210121 | ODS | Sheet1
 |  | 2010-08-16 00:00:00 | Mr | Test | File | 1210121222 | ODS | Sheet1
Spreadsheet: bbfec081-415f-4363-9398-58865904cdb0
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
[NAME] | Test | [NAME] | HER2 Amplification Associated with Breast Cancer, FISH, Tissue | [NAME], Breast Cancer, FISH | Fluorescence In Situ Hybridization (FISH) with DNA Probes | Formalin-fixed, paraffin-embedded tissue: FFPET |  |  |  | Varies | Provide a pathology report with each tissue specimen. The pathology report must include type of fixation used (ie, >6 hours and <48 hours). The laboratory will not reject a specimen that arrives without this information but will hold analysis of the specimen until a pathology report is received.   [NAME]: Tissue block Collection Instructions: Submit formalin-fixed, paraffin-embedded breast cancer tissue. Forms: If not ordering electronically, submit a Cytogenetics Hematologic Disorders Request Form (Supply T607) with the specimen. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Samples processed Monday through Sunday. Results reported Monday through Friday, 8 a.m.-5 p.m. CST. | 8 days | 11 days |  | Profile |  |  |  |  | Rochester
[NAME] | [NAME] | TISSUE | Tissue |  |  |  | Ambient
[NAME] | Order Question | G_652 | Reason For Referral |  | Plain Text
[NAME] | Result | 16878 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
[NAME] | Result | 16879 | [NAME] | [NAME] | Alphanumeric
[NAME] | Result | 16880 | Source | Source | Alphanumeric
[NAME] | Result | 16881 | Order Date | Order Date | Alphanumeric
[NAME] | Result | G_652 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
[NAME] | Result | 29636 | Fixative | Fixative | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Result | 16882 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Result | 16884 | Results | Results | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31150-6
[NAME] | Result | 16885 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69965-2
[NAME] | Result | 16886 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Result | 16887 | Consultant | Consultant | Alphanumeric
[NAME] | Result | 16888 | Report Date | Report Date | Alphanumeric
[NAME] | Billing Component | [NAME] |  | Cytogenetic Interp/Report |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88291
[NAME] | Billing Component | [NAME] |  | Inter In Situ Hybrid |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88274
[NAME] | Billing Component | [NAME] |  | Molec cyto, DNA Probe, Ea |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 88271
Spreadsheet: bbd3ecf6-0b83-472f-b662-703483b6553b
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (11 Entries):
 | 3 Test and measurement and quality control 3.10 Materials testing 3.10.1 Non-destructive testing
No. | Company | Country | City | [NAME] | Hall/Booth
1 | analyticon instruments gmbh | Germany | Rosbach | 61191 | A2.439
2 | Andor Technology plc. | United Kingdom | Belfast | BT12 7AL | A2.144
3 | Bruker Elemental GmbH | Germany | [NAME] | 47546 | A2.331/432
4 | FLUXANA GmbH & Co. [NAME] | Germany | Bedburg-Hau | 47551 | A2.509
5 | Innov-X Systems Europe B.V. | Netherlands | s&#39;-Hertogenbosch | 5222 AX | A2.534
6 | NIST National Institute of Standards & Technology | USA | Gaithersburg | MD 20899 | A2.409
7 | [NAME] | Germany | Waldbronn | 76337 | A2.217
8 | Renishaw GmbH | Germany | [NAME] | 72124 | A2.520
9 | RJL Micro & Analytic GmbH | Germany | Karlsdorf-Neuthard | 76689 | A1.531B
10 | Roentgenanalytik Systeme GmbH & Co.[NAME] | Germany | Taunusstein | 65232 | A2.419
11 | Shimadzu Deutschland GmbH | Germany | Duisburg | 47269 | [NAME]
Spreadsheet: 63006d1263983153-gathering-information-by-the-most-recent-dates-cashier-work-history-test-1-
Sheet: ACES

Employee:
ACES | Average:
Date | Observed By | Score | Average
2009-12-20 00:00:00 | [NAME] | 25
2010-01-12 00:00:00 | [NAME] | 21
2010-01-15 00:00:00 | [NAME] | 20
2010-01-18 00:00:00 | [NAME] | 23
2010-01-20 00:00:00 | [NAME] | 16
Spreadsheet: 770439d1646066742-textjoin-two-columns-without-an-additional-helper-column-sample_1
Sheet: Sheet1

have
1
1 |  | 1.2
1 |  | 1.3
1 |  | 1.4
1 |  | 1.5
1 |  | 1.6
1 |  | 1.7
1 |  | 1.8
1 |  | 1.9
1 |  | 1.10
2 |  | 2.11
2 |  | 2.12
2 |  | 2.13
2 |  | 2.14
2 |  | 2.15
2 |  | 2.16
2 |  | 2.17
2 |  | 2.18
2 |  | 2.19
2 |  | 2.20
2 |  | 2.21
2 |  | 2.22
2 |  | 2.23
2 |  | 2.24
2 |  | 2.25
2 |  | 2.26
2 |  | 2.27
3 |  | 3.28
3 |  | 3.29
3 |  | 3.30
3 |  | 3.31
3 |  | 3.32
3 |  | 3.33
Spreadsheet: 263959d1378740541-auto-inserting-data-in-cells-test
Sheet: SIGN IN SHEET

DATE | 9th | SEPT |  |  | TEAM | A |  |  |  |  | DC45
1900-01-01 00:00:00
 | Date Printed |  |  |  | 2013-09-09 16:28:26
 | ROSTERED SHIFT | ACTUAL START TIME | HAVE YOU SIGNED LATEST SI AND SLS |  | SIGN IN | ACTUAL FINISH TIME | OT | PASS EXPIRING | Mgr Sign |  | DAYS LEFT TO EXPIRY at time of printing
PASTE TIMES HERE → |  |  | BOX MUST BE TICKED OR HRS MAY NOT BE ENTERED
 | MON
 | 9th |  | YES | NO
[NAME] | 1300-2200 |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
EMMA TURK | H |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
[NAME] | 1400-2300 |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
[NAME] | SALES |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
HELEN MCCOMB | S |  |  |  |  |  |  | #N/A |  | #N/A | #N/A | [NAME] DATE
MERVYN TODD | 1700-0200 |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
[NAME] | 1430-1900 |  |  |  |  |  |  | #N/A |  | #N/A | #N/A | [NAME] DATE
PATRICIA PHILLIPS | X |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
GEMMA MCDONNELL | 0730-1630 |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
JULIE DAVIS | 1230-2130 |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
EMILIA DE LA TORRE |  |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
SIMON LYTTLE | 1230-2130 |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
[NAME] | 1400-2300 |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
[NAME] | 1230-2130 |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
LEANNE MARTIN | MAT |  |  |  |  |  |  | #N/A |  | #N/A | #N/A | [NAME] DATE
LAUREN HORNER | X |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
LORRAINE NESBITT | X |  |  |  |  |  |  | #N/A |  | #N/A | #N/A | [NAME] DATE
COLETTE WEIR | H |  |  | 0500-1 |  |  |  | #N/A |  | #N/A | #N/A
TIERNAGH BIGLEY | 1230-1700 |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
LAUREN MCKIMM | 1230-1700 |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
ROSIE OHARA | 1230-2130 |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
MARIE MCATEER | 1230-2130 |  |  |  |  |  |  | #N/A |  | #N/A | #N/A
[NAME] | H
ERIN SCOTT | 1100-1900
Roster and Annual Leave allocation available at bfsint.wix.com/teamabfs
Spreadsheet: 271289d1381894589-converting-time-to-hours-cplatt23-blank-billing-worksheet
Sheet: September 2013 BASC Billing

 |  |  |  | 2013-10-01 00:00:00
Name | Total $ | Rate | Total hrs | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | Pickup Time | Hours | [NAME], Amt
 |  | 12 |  | 17:44:00 |  | 15:46:00 |  | 17:03:00 |  | 16:11:00 |  | 17:13:00 |  | 16:10:00 |  | 16:05:00 |  | 15:39:00 |  | 17:34:00 |  | 15:29:00 |  | 16:35:00 |  | 16:52:00 |  | 16:11:00 |  | 15:37:00 |  | 16:15:00 |  | 16:41:00
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
Late pickups (Carpool)
Late pickups (After School)
Total