tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 12b68ba0-bc07-4cef-96ad-bc21bcffda75
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
FHAL | Test | FHAL | Triazolam (Halcion) | Triazolam (Halcion) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 2 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s). ([NAME] tube is not acceptable.) Spin down and send 2.0 mL sodium heparin plasma refrigerated. Note:	1. Indicate plasma on request form.    	2.  [NAME] specimen appropriately (plasma).  	3. Trough levels are most reproducible   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.) Spin down and send 2.0 mL of serum refrigerated. Note:	1. Indicate serum on request form. 	2. Label specimen appropriately (serum). 	3. Trough levels are most reproducible | 0.3 mL NOTE: Submission of the m | Hemolysis	NA Thawing 	NA Lipemia	NA Icterus	NA Other	NA | Reference Range: 5.0 - 20.0 ng/ml   Test Performed by: Medtox Laboratories, Inc.                                        402 W. County Road D                                        St. Paul, MN 55112 | Monday through Sunday | 3 days | 4 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc
FHAL | [NAME] | VARIES | Varies |  |  |  | Refrigerated
FHAL | Result | [NAME] | Triazolam (Halcion) | Triazolam (Halcion) | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 87661d1287542574-focus-completion-date-changed-book1
Sheet: Sheet1

 | CIVIL WORK |  |  |  |  |  | TI
 | START |  | FINISH |  | CW PAT & RFTI |  | START |  | FINISH |  | TI PAT
SITE NAME | FC | AC | FC | AC | FC | AC | FC | AC | FC | AC | FC | AC
A | 2010-09-07 00:00:00 | 2010-09-08 00:00:00 | 2010-10-23 00:00:00 |  | 2010-10-28 00:00:00 |  | 2010-10-29 00:00:00 |  | 2010-11-02 00:00:00 |  | 2010-11-05 00:00:00 |  | The focus civil work completion was asked to delay to 3/Nov/2010 (11 days)
 |  |  |  |  |  |  |  |  |  |  |  |  | This will effect to all the focus date of my other milestones
 |  |  |  |  |  |  |  |  |  |  |  |  | What should I do to all my focus date with this adjustment? Should I plus another 11 days to each milestones?
Spreadsheet: 159484d1338695651-align-text-vlookup-sumif-vlookup
Sheet: Sheet1

 |  |  | see comment |  | see comment
 | code | description | my sumif formula | example | result should be here |  | code | description
 | 18674 | EQUAL SACHETS | 0 | EQUAL SACHETS |  |  | 3896 | KELLOGGS CORN FLAKES
 | 40458 | CHIKO ECLAIRS HEART | 0 | CHIKO ECLAIRS HEART |  |  | 18674 | EQUAL SACHETS
 | 37421 | KELLOGGS SPECIAL -K | 0 | KELLOGGS SPECIAL -K |  |  | 19825 | SUREE FISH SAUCE
 | 42605 | DANISH PREMIUM | 0 | DANISH PREMIUM |  |  | 28881 | ROK BLEACHING
 | 42339 | PLASTIC BRUSH HOLDER | 0 | PLASTIC BRUSH HOLDER |  |  | 36622 | CLOSE UP TOOTHPASTE
 | 3896 | KELLOGGS CORN FLAKES | 0 | KELLOGGS CORN FLAKES |  |  | 37421 | KELLOGGS SPECIAL -K
 | 40437 | FEEDER CANDY 40G | 0 | FEEDER CANDY 40G |  |  | 40437 | FEEDER CANDY 40G
 | 36622 | CLOSE UP TOOTHPASTE | 0 | CLOSE UP TOOTHPASTE |  |  | 40458 | CHIKO ECLAIRS HEART
 | 19825 | SUREE FISH SAUCE | 0 | SUREE FISH SAUCE |  |  | 42339 | PLASTIC BRUSH HOLDER
 | 28881 | ROK BLEACHING | 0 | ROK BLEACHING |  |  | 42605 | DANISH PREMIUM
 |  | Column B+C has some data and [NAME] has the same data now I need column I text data to align with column C data (see example in E column
Spreadsheet: 772223d1647091264-fuel-cost-matching-vehicle-to-driver-to-miles-driven-per-day-fuel-cost
Sheet: Vehicles

 | Fuel PPG | 4.25
 | Total Cost
 |  |  |  |  |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 | Vehicle | MPG |  | Driver | Miles / Week | Fuel Cost | [NAME] | Vehicle | [NAME] | Vehicle | [NAME] | Vehicle | [NAME] | Vehicle | [NAME] | Vehicle | [NAME] | Vehicle | [NAME] | Vehicle
 | CRV | 32 |  | [NAME] |  |  | 42 | [NAME] | 42 | [NAME] | 42 | [NAME] | 42 | F150
 | HRV | 34 |  | Adchara |  | 55.78125 | 84 | CRV | 84 | CRV | 84 | CRV | 84 | CRV | 84 | CRV
 | F150 | 16 |  | Jessica |  | 35 | 70 | HRV | 70 | HRV | 70 | HRV | 70 | HRV
 | [NAME] | 25
Spreadsheet: daren_farmer__5961__SMI41reveff061200
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/09/00
Subject:  Revised Availabilities Effective 6/12/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-12 00:00:00 | SMI 41 | 1 | 0 |  |  | 0
1st of month DBQ = 0/d
The Sea Robin Plant will shut down Monday, June 12, 2000 at 9:00 a.m. for repairs and maintenance.
The plant should be back up on Thursday, June 15, 2000.
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: Canada

 | Canada
 | 2002 Plan
 |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2002 |  | 2002 |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  |  |  | 0
 | Analysts & Associates | 0 |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  | 927072 | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | Analyst | 66000
ENATAXES | Taxes Other than Income |  |  |  |  |  | Associate | 97200 | 2
ENATOTDR | Total Direct Expenses |  |  |  |  |  | Manager | 120000
 |  |  |  |  |  |  | Director | 156000 | 4
 | Headcount |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  | VP | 216000
 | Analyst & Associate Headcount |  |  |  |  |  | CEO | 240000 | 1
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | *  Analysts and Associates are billed through normal payroll for Canada. |  |  |  |  | Other Expense Calculation
ENAOUTTX
ENAINSUR |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
ENASYSDV
ENACORIT
ENACORRN
ENAOTHAL
ENADEPR
Spreadsheet: 771323d1646627873-count-if-multiple-strings-and-words-are-found-in-2-columns-sample-file-ridho
Sheet: Sheet1

Count Formula |  |  | Filter | Location
 | <----count should be 6 |  | 2.0-Walls | East
 |  |  | 1.5-Rails | South
[NAME] | Location |  | 3.1-Chairs | East
Sidewalk | East |  | 2.2-Sidewalk | West
Benches | South |  | 2.5-Grills | South
Walls | West |  | 2.5-Fixtures | North
Rails |  |  | 1.6-Benches | West
 |  |  | 1.8-Chairs | South
 |  |  | 2.2-Walls | North
 |  |  | 2.3-Rails | South
 |  |  | 1.7-Fixtures | East
 |  |  | 2.8-Benches | West
 |  |  | 2.6-Sidewalk | North
 |  |  | 7.2-Fixtures | East
 |  |  | 1.0-Walls | North
 |  |  | 2.7-Grills | South
Spreadsheet: 859506d1707887185-getting-last-entry-for-a-year-book1
Sheet: Sheet1

Date | Action | Qty | CS | DS | DP | CS1 | CP1 |  |  | DS Total | DS Median | first of year | Last of year
2023-06-21 00:00:00 | p | 295 | 3.85 |  |  |  |  |  | 2023 |  |  | 12.32 |  | Wrong answer
2023-09-20 00:00:00 | p | 13 | 3.87
2023-10-04 00:00:00 | d | 3.394 | 3.62994 |  |  |  |  |  |  |  | Correct answer is in cell F10 is |  | 12.68
2023-11-03 00:00:00 | d | 3.727 | 3.34317
2023-11-07 00:00:00 | p | 1 | 3.5
2023-11-20 00:00:00 | p | 1 | 3.68
2023-12-05 00:00:00 | d | 3.409 | 3.71957
2024-01-01 00:00:00 | p | 1 | 3.86 |  |  |  |  |  | 2024 |  |  |  |  | Wrong answer
2024-01-16 00:00:00 | d | 3.336 | 3.84293
2024-02-02 00:00:00 | d | 3.455 | 3.75977 |  |  |  |  |  |  |  | Correct answer is in cell F10 is |  | 11.74791
2024-02-10 00:00:00 | d | 3.115 | 3.7714
2025-07-08 00:00:00 | d | 3.478 | 3.978
 |  |  |  |  |  | Both forfmulas in cell N4 and cell N11 go to the last enter in the column and do not stop at the end of year.
Spreadsheet: 828818d1683740081-daily-kpi-tracker-call-center-kpi-tracker-needhelpcc-
Sheet: Sheet1

# of cases | case ID | Start Time | 08:00:00 | Current Time: |  |  |  | Minutes |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time List
1 | 909 | Productive Time: |  |  |  |  | break, meeting or training 1 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
2 | 910 |  |  |  |  |  | break, meeting or training 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
3 | 911 |  |  |  |  |  | break, meeting or training 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
4 | 912 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
5 | 913
6 | 914
7 | 915
8 | 916
9 | 917
10 | 918
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
Spreadsheet: 758583d1638960333-calculate-the-hourly-difference-between-the-first-time-two-status-have-been-triggered-test-data-example-etaf-2
Sheet: Sheet1

Application  ID | Status | Status Date/Time | time difference | SOLUTION | Helper |  | Count Affordability Incomplete | Count Affordability Accepted |  |  |  |  |  |  |  |  |  |  | MIN BY ID
40647563 | Affordability Incomplete | 2021-05-04 13:11:00 |  |  |  |  |  |  |  |  |  |  | MIN(IF(rng1=criteria1,IF(rng2=criteria2,values)))
40647563 | Affordability Product Incomplete | 2021-05-04 13:32:00 |  |  |  |  |  |  |  |  |  |  | MIN(IF(C2:C8=C11,D2:D8))
40647563 | Affordability Referred | 2021-05-04 13:32:00
40647563 | Affordability Manual Assessment | 2021-05-04 13:33:00
40647563 | Affordability Accepted | 2021-05-04 13:34:00
40647563 | App incomplete | 2021-05-04 13:34:00
40647563 | App referred | 2021-05-04 22:14:00
40647563 | App Manual Assessment | 2021-05-05 10:24:00
40647563 | App accepted | 2021-05-05 10:25:00
40647563 | App Manual Assessment | 2021-05-05 10:25:00
40647563 | Awaiting documents | 2021-05-05 10:33:00
40647563 | Application awaiting QA | 2021-05-12 15:19:00
40647563 | App Manual Assessment | 2021-05-13 15:34:00
67434572 | Affordability Incomplete | 2021-06-11 12:28:00
67434572 | Affordability Product Incomplete | 2021-06-11 14:04:00
67434572 | Affordability Offered | 2021-06-11 14:09:00
67434572 | Affordability Referred | 2021-06-11 14:17:00
67434572 | Affordability Incomplete | 2021-06-11 14:36:00
67434572 | Affordability Product Incomplete | 2021-06-11 15:16:00
67434572 | Affordability Offered | 2021-06-11 15:16:00
67434572 | Affordability Incomplete | 2021-06-11 15:17:00
67434572 | Affordability Product Incomplete | 2021-06-11 15:17:00
67434572 | Affordability Offered | 2021-06-11 15:17:00
67434572 | Affordability Referred | 2021-06-11 15:23:00
67434572 | Affordability Manual Assessment | 2021-06-11 15:34:00
67434572 | Affordability Accepted | 2021-06-11 15:34:00
67434572 | Affordability Incomplete | 2021-06-11 15:40:00
67434572 | Affordability Product Incomplete | 2021-06-11 16:06:00
67434572 | Affordability Offered | 2021-06-11 16:06:00
67434572 | Affordability Referred | 2021-06-11 16:06:00
67434572 | Affordability Manual Assessment | 2021-06-11 16:13:00
67434572 | Affordability Accepted | 2021-06-11 16:13:00
67434572 | App incomplete | 2021-06-11 16:23:00
67434572 | App referred | 2021-06-11 16:48:00
67434572 | App Manual Assessment | 2021-06-11 16:57:00
67434572 | App accepted | 2021-06-14 09:50:00
67434572 | App Manual Assessment | 2021-06-14 09:50:00
67434572 | Awaiting documents | 2021-06-14 10:02:00
67434572 | App not proceeding | 2021-09-16 12:28:00
Spreadsheet: 467148d1466596416-help-with-counting-on-dates-work-schedule
Sheet: Sheet1

work schedule
Start Date | End Date | # of Work Days |  |  | working days | work start | work ends
2015-12-30 00:00:00 | 2016-01-31 00:00:00 |  |  | [NAME] |  | 2015-12-30 00:00:00 | 2016-06-22 00:00:00
2015-12-30 00:00:00 | 2016-01-19 00:00:00 |  |  | Mr. [NAME] |  | 2015-12-30 00:00:00 | 2016-01-04 00:00:00
2016-03-24 00:00:00 | 2016-03-29 00:00:00 |  |  | [NAME] |  | 2016-03-24 00:00:00 | 2016-03-29 00:00:00
2016-03-24 00:00:00 | 2016-04-04 00:00:00 |  |  | [NAME] |  | 2016-03-24 00:00:00 | 2016-04-04 00:00:00
Spreadsheet: 40c363bd-47cf-4404-965f-60bb3c0d25ba
Sheet: Room Audit Data

Institution |  |  |  |  | Audit Data Input Fields |  |  |  | Peer Review Team
Date |  |  |  |  | Formula Calculated Fields |  |  |  | Room Audit Summary
PRT Team Lead |  |  |  |  | Data input by THECB
Rooms are identified by a unique alphabetic or numeric code. |  |  |  | Space use (room type) codes reflect actual use. |  |  | Functional category (room use) codes reflect actual use. |  |  | CIP identifies academic disciplines, instructional programs, and depts. |  |  | Prorated use. |  |  | Reported room area.
Bldg | Room # | Observed | Occurrence | Type | Observed | Occurrence | Use | Observed | Occurrence | CIP | Observed | Occurrence | Prorate | Observed | Occurrence | E&G SF | Observed | Occurrence | [NAME] | % Diff
Occurrence Count
Occurrence Percent
Spreadsheet: 172292d1344112296-creating-an-order-from-a-sheet-find-parts-and-cf-for-stock
Sheet: Cal-Sans

1834 E. 46th St. |  | Company name | Company B
Los Angeles, CA 90058
ph: [PHONE]
fax: [PHONE]
[EMAIL]
[NAME] -- Royal Palms                                                                                                   2500 Wilshire Blvd., Los Angeles, CA  90057   Tel:(213)-382-4241    Fax: (213) 382-0136
Qty. | Item No. | Description | Price
5 | RPC-601 | Platinum, 2ply White Bath Tissue (96/500) | 485
6 | LG-SF-K | Natural Singale Fold Paper Towel | 339.6
7 | AS-20-250 | Half Fold Toilet Seat Cover (20/250) | 559.3000000000001
Spreadsheet: 274697d1383194626-combining-subtotal-sum-with-offset-using-an-array-for-row-reference-sum-3-data-sets-by-12-rows-at-a-time
Sheet: Sheet1

3 Data sets each 1440 rows and 12 blank rows inbetween | Sums every 12 rows for data set 1 | Sums every 12 rows for data set 1, 2 and 3
1
1
1
Spreadsheet: 84524d1284573143-index-match-match-fbl-book-1
Sheet: Sheet2

 |  | Buffalo Bills |  |  |  |  |  |  |  |  |  | Buffalo Bills
 |  |  | Bills | Opponent |  |  |  |  |  |  |  |  | Bills | Opponent
 | WK 1 | [NAME] | 10 | 15 |  |  |  |  |  |  | WK 1 | [NAME] | 10 | 15
 | WK 2 | Packers | #N/A | #N/A |  |  |  |  |  |  | WK 2 | Packers | 7 | 9
 | WK 3 | Patriots | #N/A |  |  |  |  |  |  |  | WK 3 | Patriots | 21 | 9
 | WK 4 | Jets |  |  |  |  |  |  |  |  | WK 4 | Jets | 17 | 3
 | WK 5 | [NAME] |  |  |  |  |  |  |  |  | WK 5 | [NAME] | 14 | 13
 | WK 6 | Bye |  |  |  |  |  |  |  |  | WK 6 | Bye
 | WK 7 | Ravens |  |  |  |  |  |  |  |  | WK 7 | Ravens | 9 | 17
 | WK 8 | Chiefs |  |  |  |  |  |  |  |  | WK 8 | Chiefs
 | WK 9 | Bears |  |  |  |  |  |  |  |  | WK 9 | Bears
 | WK 10 | Lions |  |  |  |  |  |  |  |  | WK 10 | Lions
 | WK 11 | Bengals |  |  |  |  |  |  |  |  | WK 11 | Bengals
 | WK 12 | Steelers |  |  |  |  |  |  |  |  | WK 12 | Steelers
 | WK 13 | Vikings |  |  |  |  |  |  |  |  | WK 13 | Vikings
 | WK 14 | [NAME] |  |  |  |  |  |  |  |  | WK 14 | [NAME]
 | WK 15 | [NAME] |  |  |  |  |  |  |  |  | WK 15 | [NAME]
 | WK 16 | Patriots |  |  |  |  |  |  |  |  | WK 16 | Patriots
 | WK 17 | Jets |  |  |  |  |  |  |  |  | WK 17 | Jets
 | What I get |  |  |  |  |  |  |  |  |  | What I want
Spreadsheet: 38259d1236359900-vlookup-first-two-digits-book1
Sheet: Sheet1

137MX |  | 102 | 1081.01
139TH |  | 103 | 2775
103PH (604084) |  | 104 | 2775
402TH (603943) |  | 105 | 1121.2
124DK |  | 106 | 19A1.00
383MX |  | 107 | 1121.2
151PH (604058) |  | 116 | 2652
[NAME] (604083) |  | 117 | 2641
136PH (604082) |  | 121 | 265H.01
410CA |  | 123 | 2641
139CA |  | 125 | 2665.01
121PH (604080) |  | 126 | 2665.01
165PH (604070) |  | 129 | 4145.2
[NAME] (604057) |  | 130 | 18P5.2
165NZ |  | 131 | 2110
355PH(604081) |  | 132 | 2110
274CA |  | 133 | 2863
402TH (603943) |  | 133 | 2863.01
Spreadsheet: 177773d1346427111-produce-a-list-based-on-whether-or-not-a-vale-is-less-then-another-cell-value-tester-2
Sheet: Sheet1

1st name | 2nd name | Date | Age
Francisco | Chad |  | 12 |  |  | Dates Less then: | 2004-05-01 00:00:00
[NAME] | [NAME] |  | 84
[NAME] | [NAME] |  | 65
Iliana | Gerda |  | 45
Judi | [NAME] |  | 13
Johna | [NAME] |  | 95
Sherwood | Corene |  | 12
Tonie | [NAME] |  | 65
Deena | Reita |  | 84
[NAME] | Ginger |  | 65
Faustino | Jacinta |  | 75
[NAME] | Merrill |  | 84
Darell | Alecia |  | 65
[NAME] | Margurite |  | 45
Erma | Tandy |  | 32
Samual | Valeria |  | 45
Forest | Avery |  | 15
Glory | Porsha |  | 25
Susanna | Timothy |  | 65
[NAME] | Landon |  | 15
Spreadsheet: 780285d1652373171-return-multiple-values-across-many-rows-and-columns-20210302-projects
Sheet: Light Rail

 |  | 2020-02-28 00:00:00
 | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 | Stage 1 | Peer Review and Report | 15344 |  |  | 0 | 15344
 |  | Project Total
 |  |  | Subtotal of This Invoice
 |  |  | GST
 |  |  | Invoice Total (Including GST)
Spreadsheet: 88358d1288194309-matching-between-two-sheets-and-pulling-info-onto-the-3rd-sheet-replies
Sheet: Original File

id_number | Title | Initials | FirstName | Surname | DateOfBirth | Gender | Language | AddressHomeLine1 | AddressHomeLine2 | AddressHomeTown | AddressHomeCode | AddressPostalLine1 | AddressPostalLine2 | AddressPostalTown | AddressPostalCode | AddressState | TelephoneNumber1 | TelephoneNumber2 | [NAME] | [NAME] | Predicted_Income | APP_SURNAME | APP_FIRSTNAME | APP_GENDER | ID_DECEASED | DEBT_REVIEW | DNBSCORE | DNMSCORE | DCMSCORE | NOT_TOTAL_EVER | TELNUM2 | TELNUM3 | TELNUM4 | TOTALVALIDTEL | CUSTOMER_KEY | ret_flag | card_flag | DNBSCOREBAND | cell_number | cell_valid
89698745623213 | MS | X | XITORI FLORAH | SHIVURI | 19711112 | F | E | 50 CORNELIUS STREET |  | WELTEVREDENPARK | 1709 | 50 CORNELIUS STREET |  | WELTEVREDENPARK | 1709 | RSA | [PHONE] | [PHONE] | [PHONE] | [PHONE] | 7000 | SHIVURI | XITORI FLORAH | F | N |  | 634 | 639 | 614 | 0 | [PHONE] | [PHONE] | [PHONE] | 4 |  |  |  | 630-640 | [PHONE] | Y
89697456230866 | MR | G | GWINYITSHE | DLAMINI | 19711114 | M | E | 28 SHAP PLACE |  | MONTCLAIR | 4004 | 28 SHAP PLACE |  | MONTCLAIR | 4004 | RSA | [PHONE] | [PHONE] | [PHONE] | [PHONE] | 12000 | DLAMINI | GWINYITSHE | M | N |  | 640 | 659 | 619 | 0 | [PHONE] | [PHONE] | [PHONE] | 4 | DLAMIG 158 |  |  | 630-640 | [PHONE] | Y
86987456232777 | MS | L | LINDIWE THOBELENI | MAKHONZA | 19711116 | F | E | P O BOX 44826 |  | PIETERMARITZBURG | 3200 | P O BOX 44826 |  | PIETERMARITZBURG | 3200 | RSA | [PHONE] | [PHONE] | [PHONE] | [PHONE] | 8000 | MAKHONZA | LINDIWE THOBELENI | F | N |  | 632 | 638 | 632 | 0 | [PHONE] | [PHONE] | [PHONE] | 4 |  |  |  | 630-640 | [PHONE] | Y
89698745623327 | MS | A | AMANDA | STRYDOM | 19711117 | F | E | 20 WATSONIA PARK |  | ALGOAPARK | 6001 | 20 WATSONIA PARK |  | ALGOAPARK | 6001 | RSA | [PHONE] | [PHONE] | [PHONE] | [PHONE] | 10000 | STRYDOM | AMANDA | F | N |  | 632 | 622 | 643 | 0 | [PHONE] | [PHONE] | [PHONE] | 4 | STRYDA 653 |  |  | 630-640 | [PHONE] | Y
Spreadsheet: 177956d1346559223-off-setting-entries-offsetting-entreis
Sheet: offsetting entries 1

Journal # | Document # | Description | Balance
1-JE-01 | 1 | xxx | 1456
1-JE-01 | 1 | xxx | -1456
1-JE-01 | 7 | xxx | -1456
1-JE-01 | 7 | xxx | 2546
1-JE-03 | 3 | xxx | 7345
1-JE-03 | 12 | xxx | -7345
1-JE-04 | 4 | xxx | 6891
1-JE-05 | 5 | xxx | 3456
1-JE-06 | 6 | xxx | 2474
1-JE-09 | 9 | xxx | 8789
1-JE-09 | 9 | xxx | -8789
1-JE-11 | 11 | xxx | 345
1-JE-13 | 13 | xxx | 53742
1-JE-14 | 14 | xxx | 23637
1-JE-15 | 15 | xxx | 2357
1-JE-16 | 16 | xxx | 23178
1-JE-17 | 17 | xxx | 1257
Spreadsheet: 012ac4c2-40e1-4259-aad8-9901519025e6
Sheet: Sheet1

QUOTE - PRODUCTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Date: | [12/17/2012]
Quote #: [012345 ]
[Vendor Company Name] |  |  |  | To: [Name] [Dept]
[Street Address]                                                                                                                                                                                                                                               [Phone] |  |  |  | Mayo Clinic
[City, State, Zip] |  |  |  | [Street Address]
Phone: [[PHONE]] |  |  |  | [City, State, Zip]
Fax: [[PHONE]] |  |  |  | Dept .Phone: [[PHONE]]
[E-mail Address] |  |  |  | [E-mail Address]
 |  |  |  | Customer ID: [ABC0000]
SALESPERSON |  |  | QUOTE EXPIRATION DATE | SHIPPING TERMS |  | PAYMENT TERMS
 |  |  |  | FOB Destination, Bill 3rd Party |  | e-Payables, Net 15
QTY | ITEM # | LINE ITEM DESCRIPTION |  | ITEM LIST PRICE | DISCOUNT % |  | NOVATION PRICE | MAYO PURCHASE PRICE | MAYO [NAME] PRICE
 |  | INSTALLATION:
 |  | TRAINING:
 |  |  |  |  |  |  |  | SUBTOTAL
 |  |  |  |  |  |  |  | FREIGHT DISCOUNT
 |  |  |  |  |  |  |  | TOTAL
This Vendor Quotation prepared by:
This is a quotation on the goods named, subject to the conditions noted below: (Describe any conditions pertaining to these
prices and any additional terms of the agreement. You may want to include contingencies that will affect the quotation.)
Please attach a copy of quote in Vendor format as well.
Buyer to accept this quotation, sign here & return:
Mayo Contract #/Novation ID #: |  | ____________________
Thank you for your business!
Spreadsheet: 101826d1299863434-excel-2007-need-to-separate-a-description-field-in-various-character-lines-copy-of-sample_03_11_11
Sheet: Some example Data

Material | Description
10318863 | BEARING-TORRINGTON 23056-KYMB W507 C08C3, TORRINGTON 280SD30K, 05/06 CHANGED TO C3
10318878 | BEARING-SKF 23064-CCK/C4/W33, 6/3-PER AIT-NOT AVAILABLE ECB IN C3, R COUCH WILL DISCUSS WITH OTHERS TO, DETERMINE HOW BEARING WILL BE ADAPTABLE, 7/3-WHEN PURCHASED NEW, MODIFY TO C3, KEEP ROP AT 1, CHANGE SPECS PER R COUCH 1/1/0, REPLACE 23064-KYMB/W507/C08/C4, NEW SPEC CONSISTING OF C4 BEARING BEING, REWORKED TO C3 WITH HARDENED INNER RACE, 10/2-PER AIT-NOT AVAILABLE IN C3, 7/3-DO NOT REPAIR PER T COLE, DROPPPED THE ECB HARDENED INNER RACE, AND CHANGED TO C3 FIT DO TO NO LONGER, PUTTING STEAM TO THIS ROLL.
10318869 | BEARING-SKF 23156 CACK C083 W507, 6/3-PER MANNY G, DO NOT REPAIR
10315144 | BEARING-SKF 23220CCKYW33
10318871 | BEARING-SKF 23268 CAK C083 W507, 6/3-PER T COLE, OK TO REPAIR - BEARINGS, CHANGED OUT YEARLY
10315147 | BEARING-FAG 23944 SK MB C4, THESE BEARINGS TAKE A LONG TIME TO, COME IN. [NAME]. 6 MONTHS., TO GET BETTER DELIVERY WE CAN ORDER, THESE ALTERED FROM A STANDARD FIT.
10315223 | ADAPTER, BEARING-FAG H3944X7.993, HOLD FOR RETURN
10315428 | ADAPTER, BEAING H3064 X 11 1/2 UNSPLIT, [NAME]