tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 764248d1642662591-how-to-get-count-from-formula-using-cell-test
Sheet: Sheet2

ID | Name | Date | Time |  |  | ID | Date | Time |  |  | 13:00:00 | 12:00:00
100 | Rakiq | 2022-01-20 00:00:00 | 12:00:00 |  |  | 200 |  |  |  | 2022-01-20 00:00:00 |  | ?
200 | Tarek | 2022-01-20 00:00:00 | 13:00:00 |  |  | 300 |  |  |  | 2022-01-21 00:00:00 | ? | ?
300 | Jabbar | 2022-01-21 00:00:00 | 13:00:00 |  |  | 500
400 | Sabbir | 2022-01-21 00:00:00 | 12:00:00
500 | Sobur | 2022-01-21 00:00:00 | 12:00:00
Spreadsheet: 88611d1288388772-insert-rows-based-on-cell-count-create_chart
Sheet: Sheet1

Blank Beginning Chart
Resulting Chart Here
Label 1 |  |  |  | Label 2
2 |  | Text |  | 10 |  | Text
5 |  | Text |  | 7 |  | Text
7 |  | Text |  | 9 |  | Text
3 |  | Text |  | 1 |  | Text
9 |  | Text |  | 3 |  | Text
 |  |  |  | 8 |  | Text
 |  |  |  | 5 |  | Text
 |  |  |  | 7 |  | Text
BLANK ROW
BLANK ROW
Data Located Here
Label 1 |  |  |  | Label 2
2 |  | Text |  | 10 |  | Text
5 |  | Text |  | 7 |  | Text
7 |  | Text |  | 9 |  | Text
3 |  | Text |  | 1 |  | Text
9 |  | Text |  | 3 |  | Text
 |  |  |  | 8 |  | Text
 |  |  |  | 5 |  | Text
 |  |  |  | 7 |  | Text
Spreadsheet: 88731d1288600049-charting-date-copy-of-book1-2
Sheet: Sheet4

Row Labels | Sum of 2
sij | 21
vlj | 18
ožu | 17
tra | 23
svi | 23
lip | 33
srp | 15
kol | 13
ruj | 14
lis | 15
Grand Total | 192
Spreadsheet: 688247d1595662004-using-sumifs-to-categorize-expenditures-monthly-example1
Sheet: table

Date | Store | Purchased Product | Category | Amount
2020-06-16 00:00:00 |  |  | Lawn Equipment Purchases | 10
2020-06-16 00:00:00 |  |  | Lawn Equipment Purchases | 20
2020-06-16 00:00:00 |  |  | Truck Expense | 30
2020-06-25 00:00:00 |  |  | Truck Expense | 40
2020-06-25 00:00:00 |  |  | Truck Expense | 50
2020-06-26 00:00:00 |  |  | License | 60
2020-06-28 00:00:00 |  |  | Gas | 70
2020-06-29 00:00:00 |  |  | Lawn Equipment Purchases | 80
2020-07-01 00:00:00 |  |  | Lawn Equipment Purchases | 90
2020-07-02 00:00:00 |  |  | Lawn Equipment Supplies | 100
2020-07-05 00:00:00 |  |  | Lawn Oil/Gas | 110
2020-07-07 00:00:00 |  |  | Lawn Oil/Gas | 120
2020-07-07 00:00:00 |  |  | Gas | 130
2020-07-07 00:00:00 |  |  | Lawn Equipment Supplies | 140
2020-07-07 00:00:00 |  |  | Lawn Oil/Gas | 150
2020-07-10 00:00:00 |  |  | Customer Repair | 160
2020-07-11 00:00:00 |  |  | Food | 170
2020-07-13 00:00:00 |  |  | Gas | 180
2020-07-14 00:00:00 |  |  | Lawn Equipment Supplies | 190
2020-07-14 00:00:00 |  |  | Lawn Oil/Gas | 200
2020-07-16 00:00:00 |  |  | Food | 210
2020-07-16 00:00:00 |  |  | Truck Expense | 220
2020-07-16 00:00:00 |  |  | Truck Expense | 230
2020-07-16 00:00:00 |  |  | Lawn Equipment Supplies | 240
2020-07-20 00:00:00 |  |  | Gas | 250
2020-07-20 00:00:00 |  |  | Lawn Equipment Supplies | 260
2020-07-22 00:00:00 |  |  | License | 270
2020-07-22 00:00:00 |  |  | Truck Expense | 280
2020-07-22 00:00:00 |  |  | Lawn Equipment Supplies | 290
2020-07-23 00:00:00 |  |  | Lawn Equipment Purchases | 300
2020-07-23 00:00:00 |  |  | Lawn Oil/Gas | 310
2020-07-09 00:00:00 |  |  | Advertising | 305
2020-07-23 00:00:00 |  |  | Food | 320
2020-07-23 00:00:00 |  |  | Oil/Gas | 330
Spreadsheet: 866853d1713779959-aggregate-function-to-count-instances-based-on-criteria-book24-etaf
Sheet: Sheet1

 |  | MATCH 1 |  | POINTS | MATCH 2 |  | POINTS | MATCH 3 |  | POINTS | MATCH 4 |  | POINTS | MATCH 5 |  | POINTS | MATCH 6 |  | POINTS | MATCH 7 |  | POINTS | MATCH 8 |  | POINTS | MATCH 9 |  | POINTS | MATCH 10 |  | POINTS | MATCH 11 |  | POINTS | [NAME] |  | POINTS | MATCH 13 |  | POINTS | MATCH 14 |  | POINTS | MATCH 15 |  | POINTS | 1 POINT TOTAL
 |  |  | A | 1 | 12 | 2 | 1 | 23 | 1 | 2 | 16 | 4 | 4 | 22 | 7 | 2 | 13 | 1 | 5 | 35 | 2 | 3 | 12 | 1 | 6 | 34 | 5 | 1 | 33 | 4 | 3 | 23 | 2 | 2 | 12 | 1 | 2 | 22 | 2 | 4 | 12 | 9 | 1 | 13 | 1 | 1 |  | 5
 |  |  | B | 4 | 3 | 4 | 2 | 1 | 1 | 1 | 18 | 4 | 5 | 13 | 7 | 4 | 16 | 4 | 5 | 15 | 8 | 1 | 17 | 2 | 4 | 18 | 3 | 2 | 19 | 1 | 2 | 55 | 6 | 5 | 67 | 4 | 1 | 45 | 1 | 3 | 34 | 2 | 6 | 27 | 2 | 3 |  | 3
 |  |  | C | 1 | 12 | 2 | 1 | 23 | 1 | 2 | 16 | 4 | 4 | 22 | 7 | 2 | 13 | 1 | 5 | 35 | 2 | 3 | 12 | 1 | 6 | 34 | 5 | 1 | 33 | 4 | 3 | 23 | 2 | 2 | 12 | 1 | 2 | 22 | 2 | 4 | 12 | 9 | 1 | 13 | 1 | 5 |  | 4
 |  |  | D
 |  |  | E
 |  |  | F
 |  |  | G
Spreadsheet: 293122d1390902980-separating-text-and-numbers-in-different-columns-ef571_separating-numbers-and-text
Sheet: Sheet1

22,162 Boeing (The) Co. $ 2,892,141
12,543 Honeywell International, Inc. 1,087,854
27,556 L-3 Communications Holdings, Inc. 2,768,000
16,332 Lockheed Martin Corp. 2,177,709
27,336 Northrop Grumman Corp. 2,938,893
4,584 Precision Castparts Corp. 1,161,815
20,273 Raytheon Co. 1,669,887
7,675 Rockwell Collins, Inc. 535,945
56,588 Textron, Inc. 1,629,169
17,488 [NAME], Inc. 1,044,733
35,461 Expeditors International of
Washington, Inc. 1,606,029
18,256 FedEx Corp. 2,391,536
11,400 United Parcel Service, Inc., Class B 1,119,936
Spreadsheet: 45103d1243879222-coordinating-ranges-data-coordination
Sheet: New Spreadsheet

Store | Jan Sales | Feb Sales | [NAME]
136 | 0 | 0 | 67224
145 | 13214 | 13214 | 13214
178 | 75673 | 75673 | 75673
190 | 34622 | 34622 | 34622
201 | 34523 | 0 | 0
342 | 45754 | 45754 | 45754
This sheet represents a new tab on a different spreadsheet, laid out the way I would like to see it, with store #[NAME] matched to their sales.
I have manually dropped in the values I would like to see, but I am sure there is some way to automate this process through excel, any help would be appreciated.
Spreadsheet: 100815d1299056882-count-unique-items-within-a-choice-copy-of-example1
Sheet: Sheet1

Number | Company |  | company | count
46 | A |  | A | 29 |  | Count of Number
47 | A |  | B | 4 |  | Company | Total
48 | B |  | C | 2 |  | A | 29
61 | A |  |  |  |  | B | 4
62 | A |  |  |  |  | C | 2
63 | A |  |  |  |  | Grand Total | 35
64 | A
65 | A
66 | A
67 | A
68 | A
69 | A
83 | B
84 | A
85 | A
86 | A
103 | B
104 | A
105 | A
107 | A
108 | A
109 | A
110 | A
118 | C
122 | A
129 | A
156 | B
157 | A
158 | A
159 | A
168 | A
169 | A
170 | A
172 | A
175 | C
Spreadsheet: mark_whitt__25254__Huber - Existing & Proposed Deals 111201
Sheet: Summary

Existing Deals with Huber
Start | End | Volume (MMBtu/d) | Delivery Point | Contract Price | 55 days payables* | Mark-to-Market Value to ENE
2001-12-01 00:00:00 | 2006-09-30 00:00:00 | 5000 | [NAME] | IF NGPL MidContinent index |  | -90118
2001-12-01 00:00:00 | 2006-09-30 00:00:00 | 5000 | [NAME] | IF NGPL MidContinent index |  | 189775
2002-06-01 00:00:00 | 2013-05-31 00:00:00 | 42000 | Gage | IF NGPL MidContinent Index minus $0.01
 |  |  |  | Existing Deals Total Payables as of Jan 25, 2002
 |  |  |  | Existing Deals Total Payables as of July 25, 2002
Proposed Deals with Huber
Start | End | Volume (MMBtu/d) | Delivery Point | Contract Price | 55 days payables* | Mark-to-Market Value to ENE
2001-12-01 00:00:00 | 2002-05-31 00:00:00 | 45000 | Glenrock | IF CIG Rocky Mtns. index minus $0.03
2001-12-01 00:00:00 | 2006-05-31 00:00:00 | 20000 | PG&E Topock | Gas Daily PG&E Topock index minus $0.02
2001-12-01 00:00:00 | 2002-05-31 00:00:00 | 10000 | [NAME] | Gas Daily El Paso-San Juan index minus $0.10
2001-12-01 00:00:00 | 2002-05-31 00:00:00 | 10000 | [NAME] | Gas Daily NWPL Wyoming Pool index minus $0.10
 |  |  |  | Prosed Deals Total Payables as of Jan 25, 2002
 |  |  |  | Proposed Deals Total Payables as of July 25, 2002
 |  |  |  | Total Proposed & Existing Payables as of Jan 25, 2002
 |  |  |  | Total Proposed & Existing Payables as of July 25, 2002
* The "55 days payable" value above is calculated as 55 days times the Daily Volume times the average 2002 wellhead netback price (curve date = Nov 9, 2001)
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -23719 | -22302
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -2149512 | -2131133
58710 | -167 | -1009
60921 | 1366289 | 1319320
78026 |  | 81197
500084 | -6753 | -19000
500085
500097 | -9773
INDEX
2001-08-31 00:00:00 |  |  | 129217.63
2001-09-22 00:00:00
CBS Volume
 |  |  | 7128
Spreadsheet: darrell_schoolcraft__7414__imball0201
Sheet: WTGmktg

 | /------------------------------------------  contract 22100  --------------------------------------------------------\
 | 10811 |  | 13234 |  | 16540 |  | 500648
 | Follet |  | Oasis Dairy Farms |  | WTG/TW Winker |  | Sum WTG New Mex
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -173 | -170 |  |  | -1576 | -1050
2 | -214 | -170 |  |  | -1603 | -1050
3 | -199 | -170 |  |  | -1406 | -1050
4 | -152 | -170 |  |  | -1400 | -1050
5 | -147 | -170 |  |  | -1303 | -1050
6 | -164 | -170 |  |  | -1240 | -1050
7 | -174 | -170 |  |  | -1112 | -1050
8 | -164 | -170 |  |  | -876 | -1050
9 | -143 | -170 |  |  | -729 | -1050
10 | -143 | -170 |  |  | -1037 | -1050
11 | -144 | -170 |  |  | -1043 | -1050
12 |  | -170 |  |  | -1049 | -1050
13 | -144 | -170 |  |  | -916 | -1050
14 | -144 | -170 |  |  | -1099 | -1050
15 | -157 | -170 |  |  | -824 | -1050
16 | -159 | -170 |  |  | -772 | -1050
17 | -158 | -170 |  |  | -851 | -1050
18 | -191 | -170 |  |  | -950 | -1050
19 | -166 | -170 |  |  | -1033 | -1050
20 | -155 | -170 |  |  | -1036 | -1050
21 | -159 | -170 |  |  | -864 | -1050
22 | -148 | -170 |  |  | -668 | -1050
23 | -165 | -170 |  |  | -796 | -1050
24 | -156 | -170 |  |  | -1331 | -1050
25 | -148 | -170 |  |  | -1108 | -1050
26 | -156 | -170 |  |  | -942 | -1050
27 | -136 | -170 |  |  | -855 | -1050
28 | -135 | -170 |  |  | -595 | -1050
29 | -197 | -170 |  |  | -566 | -1050
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | -35540.33
2002-01-29 00:00:00
CBS Volume
 |  |  | -3434
Spreadsheet: 0173ab41-90b2-4418-ad46-332f029241ea
Sheet: Sheet1

TRAVEL REQUEST | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | OFFICE USE ONLY | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  |  |  |  |  |  | TRIP NO.
NAME: |  | THIS FORM CANNOT BE FILLED IN ON-LINE. |  |  |  |  |  |  |  |  |  | AMOUNT:
ADDRESS: |  | CONTACT PURCHASING FOR THE CORRECT FORM.
NAME OF ORGANIZATION: |  |  |  |  |  |  | FUND                     (2) | PROGRAM     (4) | SUB    (1) | TOPS                                            (6) |  | OBJECT                   (4) | APPROVED AMOUNTS
PURPOSE OF MEETING:
PLACE: |  |  |  |  |  |  |  | DATES:
SIGNATURES |  |  |  |  |  |  |  |  | ESTIMATED EXPENSES: |  |  |  | REQUESTED ADVANCE
 | REQUESTING EMPLOYEE |  |  |  |  |  |  |  | Meals
 | DIVISION CHAIR/ADMINISTRATIVE HEAD |  |  |  |  |  |  |  | Other
 | ADMINISTRATOR/DEAN |  |  |  |  |  |  |  | Lodging
 | VICE PRESIDENT |  |  |  |  |  |  |  | Regis.
 | COLLEGE PRESIDENT |  |  |  |  |  |  |  | Transport.
 | OTHER (STAFF DEVEL. OFC., GRANT, BOARD REPORT DATE, ETC.) |  |  |  |  |  |  |  | Total Estimated Expense: |  |  |  | Total Advance:
[NAME] | DATE | Leaving from:  (City) |  |  |  |  | Time | Arriving at:  (City) |  |  |  |  |  | Time
EXPENSE CLAIM
EXPENSE CLAIM | ITEM |  |  |  | DATES →
 | BREAKFAST
 | LUNCH
 | DINNER
 | GROUND TRANSPORTATION
 | TELEPHONE, FAX, INTERNET
 | LODGING - HOTEL, MOTEL, ETC.
 | CONFERENCE REG. FEE - ATTACH RECEIPT & APPLICATION
 | PRIVATE CAR MILEAGE |  |  | @
 | TRANSPORT. - ATTACH  I.D. COUPON OR TICKET STUB FOR AIR TRAVEL
 | OTHER - ATTACH  ITEMIZED LIST
 |  |  |  | DAILY TOTALS
SIGNATURES |  |  |  |  |  |  |  |  | TOTAL CLAIMS
 | REQUESTING EMPLOYEE:
 | DIVISION CHAIR/ADMIN HEAD: |  |  |  |  |  |  |  | <ADVANCE>
 | ADMINISTRATOR/DEAN
 | VICE PRESIDENT |  |  |  |  |  |  |  | AMOUNT DUE EMPLOYEE
 | COLLEGE PRESIDENT
 |  |  |  |  |  |  |  |  | REFUND DUE DISTRICT
 | OTHER (STAFF DEVEL. OFC., GRANT, BOARD REPORT DATE,  ETC.)
Spreadsheet: 699719d1602736797-return-a-0-or-1-value-based-on-a-match-sample111
Sheet: Sheet1

ID | [NAME] | A | B | C | D | E | F | G
1 | A | 1 | 0 | 0 | 0 | 0 | 0 | 0
1 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | A | 1 | 0 | 0 | 0 | 0 | 0 | 0
2 | A | 1 | 0 | 0 | 0 | 0 | 0 | 0
2 | B | 0 | 1 | 0 | 0 | 0 | 0 | 0
2 | B | 0 | 1 | 0 | 0 | 0 | 0 | 0
3 | F | 0 | 0 | 0 | 0 | 0 | 1 | 0
3 | C | 0 | 0 | 1 | 0 | 0 | 0 | 0
3 | D | 0 | 0 | 0 | 1 | 0 | 0 | 0
4 | B | 0 | 1 | 0 | 0 | 0 | 0 | 0
4 | C | 0 | 0 | 1 | 0 | 0 | 0 | 0
4 | D | 0 | 0 | 0 | 1 | 0 | 0 | 0
Spreadsheet: 875568d1722181859-number-of-days-difference-according-to-keyword-excel-number-of-day-according-to-name-of-project
Sheet: Data

Date | Project
2024-07-09 00:00:00 | Project 1
2024-07-09 00:00:00 | Project 1
2024-07-10 00:00:00 | Project 1
2024-07-15 00:00:00 | Project 1
2024-07-17 00:00:00 | Project 1
2024-07-22 00:00:00 | Project 1
2024-07-23 00:00:00 | Project 1
2024-07-24 00:00:00 | Project 1
2024-07-27 00:00:00 | Project 2
Spreadsheet: 805081d1668523694-how-do-i-format-all-dates-before-this-past-sunday-and-every-new-sunday-excel-help
Sheet: Sheet1

Lookup table |  |  |  | This week |  |  |  |  | Next week
1 | Sunday |  |  | Week of 11-13-2022 |  |  |  |  | Week of 11-20-2022
2 | Monday |  |  | Date of last contact | Weekday # | Weekday |  |  | Date of last contact | Weekday # | Weekday
3 | Tuesday |  | Should be red | 2022-10-30 00:00:00 |  |  |  | Should be green | 2022-11-21 00:00:00
4 | Wednesday |  | Should be red | 2022-11-01 00:00:00 |  |  |  | Should be green | 2022-11-22 00:00:00
5 | Thursday |  | Should be red | 2022-11-01 00:00:00 |  |  |  | Should be red | 2022-11-16 00:00:00
6 | Friday |  | Should be red | 2022-11-07 00:00:00 |  |  |  | Should be red | 2022-11-15 00:00:00
7 | Saturday |  | Should be red | 2022-11-11 00:00:00 |  |  |  | Should be green | 2022-11-21 00:00:00
 |  |  | Should be green | 2022-11-13 00:00:00 |  |  |  | Should be green | 2022-11-23 00:00:00
 |  |  | Should be green | 2022-11-14 00:00:00 |  |  |  | Should be red | 2022-11-14 00:00:00
 |  |  | Should be green | 2022-11-15 00:00:00 |  |  |  | Should be red | 2022-11-15 00:00:00
Spreadsheet: 218804d1362585279-football-league-table-database
Sheet: Sumário - Tabela 2-3-1-1-1-1-13

Jornada | 14
Sunderland | 0 | 0 | Queen Parks Rangers
[NAME] | 1 | 0 | Reading
Southampton | 1 | 1 | Norwich City
Stoke City | 2 | 1 | Newcastle United
Swansea City | 3 | 1 | West Bromwich Albion
[NAME] | 2 | 1 | Liverpool
Chelsea | 0 | 0 | Fulham
Everton | 1 | 1 | Arsenal
[NAME] | 1 | 0 | West Ham United
Wigan Athletic | 0 | 2 | Manchester City
Spreadsheet: 783733d1655112053-googlesheets-vlookup-if-divide-vlookupif-divide
Sheet: Sheet1

 | asd | sdf | df | B/D
fds | 2 | 29 | 67 | ?
dfv | low | 40 | 76 | ?
dfv | medium | 2 | 8 | ?
ssd | high | 5 | 9 | ?
Spreadsheet: 818991d1677161173-extracting-raw-data-in-a-single-column-into-multiple-columns-extracting-data
Sheet: Sheet1

 |  | Desired Outcome
Raw Data: |  | Entry | Exit | Entry Price | PL
T                      12/7/2022    12/8/2022         $0.68        $1.20   STOPPED   OUT                -48% |  | 2022-12-07 00:00:00 | 2022-12-08 00:00:00 | 0.68 | -0.48
RCL                  12/6/2022  12/15/2022         $3.20        $3.80    TARGET   REACHED             19% |  | 2022-12-06 00:00:00 | 2022-12-15 00:00:00 | 3.2 | 0.19
[NAME]    12/6/2022         $2.15        $2.85    TARGET   REACHED             33% |  | 2022-12-01 00:00:00 | 2022-12-06 00:00:00 | 2.15 | 0.33
Spreadsheet: 842931d1694918687-result-makes-no-sense-to-me-someone-help-lonnie
Sheet: Sheet1

6x1.35kg |  | Steak strips cooked | 500 |  | [PHONE] |  |  | 9 |  |  | 0.3 | 0.56 | 0.25 | 0.12 | 0.14
6x1.35kg |  | Steak strips cooked | 100 |  | [PHONE] |  |  | 9 |  |  | 0.3 | 0.56 | 0.25 | 0.12 | 0.14
Spreadsheet: 703468d1605012088-sum-time-spent-exampletimes-gk
Sheet: Sheet1

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Team One
Team Two
Team Three
Team Four
Team Five
Team Six
Team Seven
Team Eight
Team Nine
Team Ten
Spreadsheet: 707325d1607180860-index-match-formula-not-working-properly-from-data-in-pivot-tables-help-november-mileage-and-fuel
Sheet: Mileage

Truck | 01 | 73 | 1022 | 247006 | 2907 | 667896 | 88 | Total
AL | 0 |  | 0 | 134 | 0 | 445 | 0
AR | 225 |  | 0 | 0 | 0 | 146 | 304
AZ | 0 |  | 0 | 360 | 0 | 744 | 0
CA | 0 |  | 0 | 900 | 0 | 837 | 0
CO | 420 |  | 0 | 586 | 0 | 71 | 1027
CT | 0 |  | 0 | 319 | 0 | 0 | 0
FL | 0 | 731 | 0 | 1117 | 0 | 2887 | 0
GA | 0 | 712 | 0 | 0 | 0 | 1132 | 0
IA | 147 | 320 | 0 | 991 | 0 | 195 | 0
ID | 536 | 550 | 0 | 1331 | 0 | 997 | 1121
IL | 0 | 929 | 0 | 824 | 0 | 656 | 133
IN | 0 | 151 | 1603 | 643 | 0 | 161 | 125
KS | 0 |  | 0 | 0 | 0 | 0 | 824
KY | 0 | 186 | 0 | 0 | 0 | 280 | 194
LA | 0 |  | 0 | 731 | 0 | 624 | 0
MA | 0 | 170 | 0 | 144 | 0 | 0 | 0
MD | 0 |  | 0 | 115 | 0 | 0 | 83
ME | 0 | 51 | 0 | 0 | 0 | 0 | 0
MI | 0 |  | 2039 | 0 | 0 | 0 | 0
MO | 530 | 431 | 0 | 241 | 0 | 1935 | 251
MS | 0 |  | 0 | 155 | 0 | 284 | 0
MT | 655 |  | 0 | 556 | 0 | 630 | 0
NE | 0 | 909 | 0 | 918 | 0 | 1377 | 0
NH | 0 | 21 | 0 | 0 | 0 | 0 | 0
NJ | 0 |  | 0 | 124 | 0 | 0 | 0
NM | 446 |  | 0 | 1374 | 0 | 994 | 884
NY | 0 | 384 | 0 | 245 | 0 | 0 | 0
OH | 0 | 245 | 4017 | 1087 | 0 | 331 | 0
OK | 1014 |  | 0 | 41 | 0 | 397 | 815
OR | 202 | 747 | 0 | 1900 | 0 | 919 | 836
PA | 0 | 47 | 0 | 1438 | 0 | 0 | 151
SD | 479 |  | 0 | 484 | 0 | 500 | 0
TN | 0 | 363 | 0 | 0 | 0 | 564 | 507
TX | 1411 |  | 0 | 2625 | 0 | 1671 | 1415
UT | 547 | 296 | 0 | 1341 | 0 | 718 | 1150
VA | 0 |  | 0 | 0 | 0 | 0 | 675
WA | 509 | 7 | 0 | 1799 | 0 | 542 | 838
WV | 0 |  | 0 | 58 | 0 | 216 | 208
WY | 378 | 799 | 0 | 1390 | 0 | 1104 | 716
Total (mi)
Spreadsheet: darrell_schoolcraft__7431__ONEOKRECAP2002
Sheet: Feb 02

INTERNAL REPORT ONLY |  |  | FEBRUARY ONEOK IMBALANCE SUMMARY |  |  |  |  |  |  |  | POI 420 |  | 78109 |  | POI 78108 |  | POI 78107 |  | 65, 62867,61491 | POI 71410 |  | POI 61491
 | SUBLETTE | HOLCOMB | HUGOTON |  | BUSHTON PVR |  | MULLINVILLE |  | BUSHTON PROD. |  | DELHI BEAVER |  | ELLIS CO #1/#2 |  | WWD CO #1 |  | CLARK CO #1 |  | HEMPHILL/CANADIAN |  |  |  |  | ONEOK
 | 103132 | 103134 | TOTAL DEVIATION |  | 103135 |  | 103133 |  | 103138 |  | 106901 |  | 107444 |  | 107445 |  | 107446 |  | 108308 | 108307 |  | 108309 |  | TOTAL DEVIATION |  |  | SUBLETTE | HOLCOMB | HUGO | PVR | MULL | BUSHTON | D.BVR | ELL 1 | WWD 1 | CLK 1 | HEMP/CAN |  |  |  |  |  |  |  |  |  | ONEOK
2002-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 103132 | 103134 | TOTAL | 103135 | 103133 | 103138 | 106901 | 107444 | 107445 | 107446 | 104307 |  |  |  |  |  |  |  |  |  | TOTAL DEVIATION
(EST) BEGINNING BALANCE | 173672 | -391832 |  |  | 75970 |  | 8232 |  | -13589 |  | -1578 |  | 33819 |  | -10206 |  | 4848 |  | -8521 | 18139 |  | -22219
2002-02-01 00:00:00 | -4415 | -3487 |  |  | 5386 |  | -154 |  | -86 |  | 172 |  | 368 |  | -281 |  | 9 |  | 558 | -1084 |  | 0
2002-02-02 00:00:00 | 1583 | -3284 |  |  | 6785 |  | -146 |  | -67 |  | 322 |  | 538 |  | -100 |  | 18 |  | 85 | -1069 |  | 0
2002-02-03 00:00:00 | 3100 | -3950 |  |  | 6202 |  | -185 |  | -68 |  | 383 |  | 271 |  | 9 |  | 3 |  | 1317 | -1033 |  | 0
2002-02-04 00:00:00 | 4946 | -3135 |  |  | 4841 |  | -144 |  | -112 |  | 0 |  | 659 |  | -62 |  | 11 |  | 0 | -1188 |  | 0
2002-02-05 00:00:00
2002-02-06 00:00:00
2002-02-07 00:00:00
2002-02-08 00:00:00
2002-02-09 00:00:00
2002-02-10 00:00:00
2002-02-11 00:00:00
2002-02-12 00:00:00
2002-02-13 00:00:00
2002-02-14 00:00:00
2002-02-15 00:00:00
2002-02-16 00:00:00
2002-02-17 00:00:00
2002-02-18 00:00:00
2002-02-19 00:00:00
2002-02-20 00:00:00
2002-02-21 00:00:00
2002-02-22 00:00:00
2002-02-23 00:00:00
2002-02-24 00:00:00
2002-02-25 00:00:00
2002-02-26 00:00:00
2002-02-27 00:00:00
2002-02-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
VOLUME ADJ. | 0 | -69 |  |  | 0 |  | -60 |  | 273 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0
December CUMULATIVE
EST ENDING BALANCE
 |  |  |  |  |  |  |  |  |  |  | BAD DAS
 |  |  | 3161324
 |  |  | 3162595
Spreadsheet: 71111d1271842752-convert-data-records-sample-workbook
Sheet: Desired Output

ID | NAME | DESIGN | [NAME] |  |  |  | JDATE
30159 | Bala | TO | Emails | Fax | Computer | HRD | 2010-04-20 00:00:00
30160 | [NAME] | SO | Shorthand | Data Entry |  |  | 2010-04-19 00:00:00
30161 | Ashok | DO | Data Entry | Shorthand | Front Office |  | 2010-04-18 00:00:00
Spreadsheet: john_zufferli__16781__marks
Sheet: Sheet1

 |  |  |  |  |  |  | Jan 8 2002
 |  | *2001 actual published PP
 |  |  | flat | on | off |  | 2002 | BID | OFFER | MID
 |  | JAN* | 131.23 | 145.5 | 113.1 |  | JAN | 32.25 | 32.75
 |  | FEB* | 116.75 | 134.4 | 93.16 |  | FEB | 32.75 | 33
 |  | MAR* | 97.23 | 114.6 | 73.12 |  | MAR | 33.25 | 33.75
 |  | APR* | 114.82 | 138.4 | 85.25 |  | APR | 31.5 | 32.5
 |  | MAY* | 88.34 | 107.4 | 61.85 |  | MAY | 31.5 | 32.5
 |  | JUN* | 63.59 | 79.85 | 41.34 |  | JUN | 31.5 | 32.5
 |  | JUL* | 53.47 | 64.64 | 40.48 |  | JUL | 35.5 | 37.5
 |  | AUG* | 52.37 | 63.54 | 36.91 |  | AUG | 35.5 | 37.5
 |  | SEP* | 29.84 | 35.9 | 23.11 |  | SEP | 35.5 | 37.5
 |  | OCT* | 43.92 | 54.2 | 29.73 |  | OCT | 38.5 | 39.5
 |  | NOV* | 33.31 | 42.28 | 22.09 |  | NOV | 38.5 | 39.5
 |  | DEC | 33.3 |  |  |  | DEC | 38.5 | 39.5
 |  |  |  |  |  |  | Cal 2002
Spreadsheet: 541937d1507637735-lookup-many-not-standard-data-test-1-
Sheet: Sheet2

Lookup table | Rating | Master Table | Rating | Similarity
binus elektro | -2146826259 | Binus teknik elektro | A | 0.95
STIE BINA BANGSA BANTEN | -2146826259 | stie bina bangsa | B | 0.888888888888889
Bina bangsa elektro | -2146826259 | [NAME] | C | 0.9852216748768474
Spreadsheet: 78846d1279139748-excel-2007-excel-automatically-delimiting-data-pasted-from-sql-server-2005-book1
Sheet: Incorrect

[NAME] | Pass-Through / Traditional / Hybrid | [NAME] | Mnth
AIDS Healthcare Foundation MCO of Florida | Inc. (Med D) | PT | 2009-11-01 00:00:00
AIDS Healthcare Foundation MCO of Florida | Inc. (Med D) | PT | 2009-11-01 00:00:00
AIDS Healthcare Foundation MCO of Florida | Inc. (Med D) | PT | 2009-11-01 00:00:00
AIDS Healthcare Foundation MCO of Florida | Inc. (Med D) | PT | 2009-11-01 00:00:00
AIDS Healthcare Foundation MCO of Florida | Inc. (Med D) | PT | 2009-11-01 00:00:00
AIDS Healthcare Foundation MCO of Florida | Inc. (Med D) | PT | 2009-11-01 00:00:00
AIDS Healthcare Foundation MCO of Florida | Inc. (Med D) | PT | 2009-11-01 00:00:00
AIDS Healthcare Foundation MCO of Florida | Inc. (Med D) | PT | 2009-11-01 00:00:00