tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 103909d1301570781-dates-and-status-collection-status
Sheet: Sheet1

Customer | Date of Booking | Amount | Installments |  |  | Jan'11 | Status | Feb'11 | status | Mar'11 | Status | Apr'11 | Status
[NAME] | 2011-01-01 00:00:00 | 10000 | 4 |  |  | 2011-01-12 00:00:00 | Collected | 1900-01-02 02:24:00 | Collected | 2011-03-01 00:00:00 | Collected | 2011-04-13 00:00:00 | Pending
[NAME] | 2011-02-01 00:00:00 | 10000 | 2 |  |  |  |  | 2011-02-20 00:00:00 | Collected | 2011-03-18 00:00:00 | Collected | 2011-04-01 00:00:00 | Pending
[NAME] | 2011-03-02 00:00:00 | 10000 | 2 |  |  |  |  |  |  | 2011-03-03 00:00:00 | Collected | 2011-04-12 00:00:00 | Pending
Report
Customer | [NAME] |  | Payment No | Date | Status
Date of Booking |  |  | 1 | 2011-02-20 00:00:00 | Collected | What is the  formula to be used to auto generate the values for D13:F13
Amount |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
Spreadsheet: 1479dc85-c4cd-4e2f-9dcc-bc0b821f0e4f
Sheet: Sheet1

[NAME] | Amount Awarded
[NAME] S Broadway | 1500
[NAME] Hwy 29 N | 7350
Alexandria, City of | 3634.78
Anoka County | 4000
[NAME] | 20240
Arna Township | 4000
Balkan Township | 6872.02
Baxter, City of | 5900
Belview, City of | 343.6
Betrtha, City of | 1003.5
Birchcreek, City of | 1500
[NAME], City of | 5600
[NAME], City of | 6000
Castle Rock Township | 303.95
Cedar Valley Township | 7730
Chisago City, City of | 3000
Chisholm, City of | 1500
Cokato, City of | 8000
Corinna Township | 6000
Elgin, City of | 1658
Elk River, City of | 6530
Elko New Market, City of | 5990
Elysian, City of | 4000
Eveleth, City of | 3250
Fergus Fall, City of | 14107
Folden Township | 279.85
Freeport, City of | 5500
Greenbush, City of | 2335
Hanover, City of | 200
Harris, City of | 5368
Hastings, City of | 5261.79
Hibbing, City of | 2570
Jeffers, City of | 37.5
Kimball, City of | 2975
Lake Eunice Township | 3950
Leaf Valley Township | 378
Lynden Township | 4000
Maple Grove, City of | 5134
Maynard, City of | 119.8
McIntosh, City of | 7000
Minneapolis, City of | 32000
Minneota, City of | 2630
Morton, City of | 37.5
Mountain Iron, City of | 200
Norwood Young America, City of | 200
Osakis, City of | 800
Osseo, City of | 300
Paynesville, City of | 8000
Pine River, City of | 2300
Prior Lake, City of | 7351.01
Proctor, City of | 4000
Randolph, City of | 400
[NAME], City of | 2350
Rose Creek, City of | 12285
Royalton, City of | 6400
Rushford, City of | 9500
Spicer, City of | 10000
St. Mary's Point, City of | 1800
Stephen, City of | 300
Sturgeon Lake Township | 730
Turtle Lake Township | 4874.5
Vergas, City of | 12948
Wabasha, City of | 6635
West St. Paul, City of | 900
Wilmont, City of | 7800
Windemere Township | 9037
Total Grants Awarded | 318899.8
Spreadsheet: 01af6e77-2c8d-4dba-b6db-8f3300c5d875
Sheet: Special Class

[NAME]: |  | High Cost Risk Pool Data Collection 2013-2014
Student SSID | Average Special Class Cost for Your LEA | Description of Unique Special Education Services as per Student IEP | Extraordinary Costs of Services Provided to Each Student | Total Average Classroom Costs + Extraordinary Costs | Subtract $19,683 (3X the 2012-13 Average Per Pupil Expenditure for Utah) ($6561) | Medicaid or Private Insurance  Reimbursement Received       (Subtracted from Total Costs) | Eligible Risk Pool Expenses
123456789 | 6000 | Physical Therapy, SLP, therapy swing, 2:1 aide | 22000 |  |  | 600
 |  |  |  |  |  | Subtotal
Spreadsheet: holden_salisbury__12291__Deals_Jan
Sheet: Jan 03-07

CounterParty | P.O.D. | MW | Delivery Pattern | Term | $ | Tariff | Currently Delivering? | Enpower Deal #
Nevada Power | Mead 230 | 50 | HLH | thru 4/6/02 | 150 |  | YES | 528030
Nevada Power | Palo Verde | 50 | HLH | thru 4/6/02 | 88.5 |  | YES | 559065
Nevada Power | Palo Verde | 25 | HLH | thru 4/6/02 | 147 |  | YES | 515363
Sierra Pacific | Palo Verde | 25 | HLH | thru 4/6/02 | 101 |  | YES | 498108
Sierra Pacific | Palo Verde | 25 | HLH | thru 4/6/02 | 136 |  | YES | 548872
Sierra Pacific | Palo Verde | 25 | HLH | thru 4/6/02 | 147 |  | YES | 514866
El Paso Electric | Palo Verde | 50 | HLH | thru 4/6/02 | 121 |  | YES | 502431
CRC | Palo Verde | 25 | HLH | thru 4/6/02 | 69 |  | Partially - 10mw | 399966
CRC | Palo Verde | 25 | HLH | thru 4/6/02 | 70 |  | YES | 501436
CRC | Palo Verde | 25 | HLH | thru 4/6/02 | 110 |  | YES | 618755
Nevada Power | Palo Verde | 25 | LLH | thru 4/6/02 | 70 |  | YES | 503214
Nevada Power | Palo Verde | 50 | LLH | thru 4/6/02 | 88.5 |  | YES | 559065
WALC | Pinnacle Peak | 25 | RTC | thru 4/6/02 | 45 |  | YES | 705583
Spreadsheet: 0ba568fc-fcd7-46d4-8a11-bf087d1506db
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 30. LEASE FINANCE COMMITMENTS, By Industry: Australia ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Agriculture, forestry and fishing ; |  |  | Original | A2420286X | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2420287A | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2420288C | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2420289F | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2420290R | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | A2420291T | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2420292V | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2420293W | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2420294X | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2420295A | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Public Administration ; |  |  | Original | A2420296C | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2420297F | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2420298J | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2420299K | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 237690d1369290058-how-to-filter-from-cell-and-move-to-a-new-cell-data-xtract-model
Sheet: Sheet1

FROZEN RAW P&D TAIL OFF VANNAMEI WHITE IQF SHRIMPS,POUCH PACK,WE [NAME] UNDER CH.3/FTP.,GR. 31/40 - 3600 CTNS
RAW [NAME] PDTO VANNAMEI SHRIMPS, "SUPREME CHOICE" BRAND (VKGUY S.NO.30 P.C.10.30) GR. 26/30 1800 CTNS
RAW [NAME] PDTO VANNAMEI SHRIMPS, "SUPREME CHOICE" BRAND (VKGUY S.NO.30 P.C.10.30) GR. 31/40 1780 CTNS
[NAME] BLOCK,"UNISTAR"BRAND,WE [NAME] UNDER CH.3/FTP,GR:16/20-1500 CTNS
[NAME] BLOCK,"UNISTAR"BRAND,WE [NAME] UNDER CH.3/FTP, GR:16/20-1200 CTNS
[NAME] BLOCK,"UNISTAR"BRAND,WE [NAME] UNDER CH.3/FTP, GR:21/25-300 CTNS
FROZEN RAW PD TAIL ON VANNAMEI IQF SHRIMPS,"CHICKEN OF THE SEA"BRAND;WE CLAIM UNDER CH.3/FTP.,GR. 16/20 - 1750 CTNS
FROZEN RAW PD BLACK TIGER SHRIMPS(WILD CAUGHT),"ORIGOLD"BRAND,WE [NAME] UNDER CH.3/FTP,GR:26/30-35 CTNS
FROZEN RAW PD BLACK TIGER SHRIMPS(WILD CAUGHT),"ORIGOLD"BRAND,WE [NAME] UNDER CH.3/FTP,GR:31/40-125 CTNS
FROZEN RAW PD BLACK TIGER SHRIMPS(WILD CAUGHT),"ORIGOLD"BRAND,WE [NAME] UNDER CH.3/FTP,GR:41/50-135 CTNS
FROZEN RAW PD BLACK TIGER SHRIMPS(WILD CAUGHT),"ORIGOLD"BRAND,WE [NAME] UNDER CH.3/FTP,GR:51/60-120 CTNS
FROZEN RAW PEELED & UNDEVEINED SHRIMPS(SEA CAUGHT),"ORIGOLD"BRAND,WE CLAIM UNDERCH.3/FTP,GR:60/80-25 CTNS
FROZEN RAW PEELED & UNDEVEINED SHRIMPS(SEA CAUGHT),"ORIGOLD"BRAND,WE CLAIM UNDERCH.3/FTP,GR:80/120-25 CTNS
I want to filter the above cell as
FROZEN RAW PD BLACK TIGER SHRIMPS(WILD CAUGHT),"ORIGOLD"BRAND,WE [NAME] UNDER CH.3/FTP,GR:31/40-125 CTNS | ORIGOLD | 31/40 | 125
RAW [NAME] PDTO VANNAMEI SHRIMPS, "SUPREME CHOICE" BRAND (VKGUY S.NO.30 P.C.10.30) GR. 26/30 1800 CTNS | SUPREME CHOICE | 26/30 | 1800
Spreadsheet: 02d04d30-0775-40e8-98fd-d74c76313cff
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | ПЛАТІЖНЕ ДОРУЧЕННЯ № | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | 1 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | 410001
 |  | від " |  | " |  | 2006 |  | р.
 | Платник
 | Код
 | Банк платника |  |  |  |  |  |  |  | код банку |  |  | [NAME] рах. № | СУМА
 | Одержувач
 | Код |  |  |  |  |  |  |  |  |  |  | КРЕДИТ рах. №
 | Банк одержувача |  |  |  |  |  |  |  | код банку
 | Сума словами
 | [NAME] платежу
 |  |  |  |  |  |  |  |  |  |  |  | Проведено банком
 | М.П. | Підпис |  |  |  |  |  |  |  |  | "___" _____________ 200__р.
 |  |  |  |  |  |  |  |  |  |  |  | Підпис банку
 |  | ПЛАТІЖНЕ ДОРУЧЕННЯ № |  |  |  |  |  |  | 1 |  |  |  |  | 410001
 |  | від " |  | " |  | 2006 |  | р.
 | Платник
 | Код
 | Банк платника |  |  |  |  |  |  |  | код банку |  |  | [NAME] рах. № | СУМА
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Одержувач
 | Код |  |  |  |  |  |  |  |  |  |  | КРЕДИТ рах. №
 | Банк одержувача |  |  |  |  |  |  |  | код банку
 | Сума словами
 | [NAME] платежу
 |  |  |  |  |  |  |  |  |  |  |  | Проведено банком
 | М.П. | Підпис |  |  |  |  |  |  |  |  | "___" _____________ 200__р.
 |  |  |  |  |  |  |  |  |  |  |  | Підпис банку
Spreadsheet: 728910d1618792571-how-to-get-vlookup-to-pick-the-second-row-when-the-first-row-is-blank-scheduling-doc-updated
Sheet: Schedule

Total Hours Scheduled |  |  |  |  |  | Monday |  |  | Tuesday |  |  | Wed |  |  | Thrusday |  |  | Friday |  |  | Saturday |  |  | Sunday | Total
NAME | Scheduled Hours | Worked Hours | Adherance | Monday Start Time | Monday Stop Time | MON | Tuesday Start Time | Tuesday Stop Time | TUE | Weds. Start Time | Weds. Stop Time | WED | Thursday Start Time | Thursday Stop Time | THU | Friday Start Time | Friday Stop Time | FRI | Saturday Start Time | Saturday Stop Time | SAT | Sunday Start Time | Sunday Stop | SUN | TOTAL |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun
Spreadsheet: 145317d1331524597-specific-formating-question-for-column-of-data-book1_utc2012
Sheet: Sheet1

Input |  |  |  |  |  | Result | Required
1H2406 | 1 | H2406 | 2406 | H | HO | 001HO02406 | 001HO02406
501H7052 | 501 | H7052 | 7052 | H | HO | 501HO07052 | 501HO07052
97WW5247 | 97 | WW5247 | 5247 | WW | WW | 097WW05247 | 097WW05247
11G3764 | 11 | G3764 | 3764 | G | GU | 011GU03764 | 011GU03764
203SR5846 | 203 | SR5846 | 5846 | SR | SR | 203SR05846 | 203SR05846
9J781 | 9 | J781 | 781 | J | JE | 009JE00781 | 009JE00781
205MO2783 | 205 | MO2783 | 2783 | MO | MO | 205MO02783 | 205MO02783
100LB937 | 100 | [NAME] | 937 | LB | LB | 100LB00937 | 100LB00937
Spreadsheet: 189820d1351369461-help-with-spreadsheets-connection-sample
Sheet: PRODUCT DATA BASE

RED WINE | THE WINE SHOP | 722887 | [PHONE] | [NAME] | 26 | 39 | 0 | 0 | 0 | 30
WHITE WINE | THE WINE SHOP | 742177 | 742177 | [NAME] Estate Riesling | 13 | 53 | 0 | 0 | 0 | 0
RED WINE | THE WINE SHOP | 833442 | 8437005267213 | Ars Vitro Tempranillo | 26 | 0 | 0 | 0 | 0 | 0
RED WINE | THE WINE SHOP | 716616 | [PHONE] | [NAME] [NAME] | 26 | 86 | 0 | 0 | 0 | 0
RED WINE | THE WINE SHOP | 712290 | 712290 | [NAME]Pazzo' | 26 | 78 | 0 | 0 | 0 | 0
WHITE WINE | THE WINE SHOP | 747841 | 898756001194 | Backhouse Pinot Grigio | 26 | 39 | 0 | 0 | 0 | 30
RED WINE | THE WINE SHOP | 747842 | [PHONE] | Backhouse Pinot Noir | 26 | 39 | 0 | 4.25 | 8 | 30
BUBBLES | THE WINE SHOP | 288449 | [PHONE] | [NAME] | 26 | 39 | 0 | 4.25 | 8 | 0 | 38
Spreadsheet: 709410d1608292414-converting-letters-to-number-value-excel-problem-updated
Sheet: Sheet1

Schedule | Number | Scheduling Issue | Weekday |  | Day of the Week | Weekday Number
M |  |  | 4 |  | M | 2
M,W |  |  | 6 |  | [NAME] | 3
M,Th,Sa |  |  | 7 |  | W | 4
 |  |  | 3 |  | Th | 5
 |  |  | 3 |  | F | 6
 |  |  | 2 |  | Sa | 7
 |  |  |  |  | Su | 1
Spreadsheet: 116080d1311592458-selective-columns-handicapscoresoncards
Sheet: master

HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total
par |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Handicaps |  |  |  | Stableford | Handicap
S/i |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | Playing | Correct | Exact | Par 3 | Points | Alteration
Adams. [NAME]
Adams. [NAME]
Addison. [NAME] | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 3 | 6 | 6 | 6 | 6 | 6 |  | 10 | 10 | 10
[NAME]. [NAME]
Ankers. Neville
Atkins. [NAME]
[NAME]. [NAME] | 5 | 6 | 5 | 6 | 3 | 5 | 6 | 5 | 6 | 5 | 6 | 5 | 6 | 5 | 6 | 5 | 6 | 5 |  | 16 | 16 | 16
Bartram. [NAME]
Basil. Greg
Batterbee. J
Baxter. N
Baxter. W | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  | 16 | 16 | 16
Beadsmore. Russ
Biggins. Clive
Biggins. Sue
[NAME]. [NAME]
Bromley. [NAME]
[NAME]. [NAME] | 5 | 6 | 7 | 6 | 5 | 6 | 7 | 6 | 5 | 6 | 5 | 6 | 7 | 6 | 7 | 6 | 7 | 6 |  | 28 | 28 | 28
[NAME]. Hamon
Clarke. [NAME]
Curt. Sean
Davey. [NAME]
[NAME]. Martyn | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 |  | 7 | 7 | 7.2
Dooley. [NAME]
[NAME]. [NAME]
Giboin. [NAME]
Goodall. [NAME]
[NAME]. [NAME] | 6 | 5 | 4 | 3 | 4 | 5 | 6 | 5 | 4 | 3 | 4 | 5 | 6 | 3 | 5 | 4 | 6 | 7 |  | 20 | 20 | 19.8
Grout. [NAME]
Haines. [NAME]
Hubband. [NAME]
Huckstepp. [NAME]
Hutchinson. [NAME]
Hutton. [NAME]
[NAME]. [NAME]
Kelly. [NAME]
[NAME]. [NAME]
[NAME]. [NAME]
[NAME]. [NAME]
Kolek. Darren
[NAME]. [NAME]
Leadbetter. [NAME]
Leadbetter. [NAME]
Leech. [NAME]
Leech. [NAME]
Lewis. [NAME]
Loom. [NAME]
[NAME]. [NAME]
Mackenzie. [NAME]
[NAME]. [NAME]
Marvesley. [NAME]
Manktelow. Trevor
McFaddon. [NAME]
[NAME]. [NAME]
Mitchell. [NAME]
Morgan. Rhys
Moriarty. [NAME]
Munting. [NAME]
[NAME]. [NAME]
[NAME]. [NAME]
Noons. Con
Noons. Martin
O'Grady. Eddie
[NAME]. Greg
Parrish. [NAME]
Parsonage. Eddie
Pearce. [NAME]
Pearce. [NAME]
Pennington. Carol
Power. [NAME]
Pym. [NAME]
[NAME]. Ian
Redondo. [NAME]
Reynolds. [NAME]
Rondeau. Gene
[NAME]. [NAME]
Scott. Bruce
Scott. [NAME]
Sharp. Ady
Shaw. [NAME]
Simmons. [NAME]
Smith. [NAME]
Smith. [NAME]
Smith. [NAME]
Sweeney. Eddie
Sweeney. [NAME]
Thompson. [NAME]
Thorpe. [NAME]
Umney. [NAME]
[NAME]. [NAME]
Watson. [NAME]
[NAME]. [NAME]
Weed. [NAME]
[NAME]. [NAME]
[NAME]. [NAME]
Woodford. [NAME]
Spreadsheet: 273595d1382773007-count-to-the-next-cell-scheda-00-2013
Sheet: Sheet1

totale:
 |  | marca | nome | gr | peso | prezzo | cad. | note | @image 1 | @image 2
Reparto A | 1
 | 2
 | 3
 | 4
Reparto B | 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
Reparto C | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100
 | 101
 | 102
 | 103
 | 104
 | 105
 | 106
 | 107
 | 108
 | 109
 | 110
 | 111
 | 112
 | 113
 | 114
 | 115
 | 116
 | 117
 | 118
 | 119
 | 120
 | 121
 | 122
 | 123
 | 124
 | 125
 | 126
 | 127
 | 128
 | 129
 | 130
 | 131
 | 132
 | 133
 | 134
 | 135
 | 136
 | 137
 | 138
 | 139
 | 140
 | 141
 | 142
 | 143
 | 144
 | 145
 | 146
 | 147
 | 148
 | 149
 | 150
 | 151
 | 152
 | 153
 | 154
 | 155
 | 156
 | 157
 | 158
 | 159
 | 160
 | 161
 | 162
 | 163
 | 164
 | 165
 | 166
 | 167
 | 168
 | 169
 | 170
 | 171
 | 172
 | 173
 | 174
 | 175
 | 176
 | 177
 | 178
 | 179
 | 180
 | 181
 | 182
 | 183
 | 184
 | 185
 | 186
 | 187
 | 188
 | 189
 | 190
 | 191
 | 192
 | 193
 | 194
 | 195
 | 196
 | 197
 | 198
 | 199
 | 200
 | 201
 | 202
 | 203
 | 204
 | 205
 | 206
 | 207
 | 208
 | 209
 | 210
 | 211
 | 212
 | 213
 | 214
 | 215
 | 216
 | 217
 | 218
 | 219
 | 220
 | 221
 | 222
 | 223
 | 224
 | 225
 | 226
 | 227
 | 228
 | 229
 | 230
 | 231
 | 232
 | 233
 | 234
 | 235
 | 236
 | 237
 | 238
 | 239
 | 240
 | 241
 | 242
 | 243
 | 244
 | 245
 | 246
 | 247
 | 248
 | 249
 | 250
Spreadsheet: 218647d1362521128-matching-the-data-sample
Sheet: Sheet1

This is the row data sample how it looks like just I have thousands of calls and thousands of tickets. Therefor manually we can see which ticket belongs to which call according to appropriate date and close time, but how is it possible to match them using any formula or something else?
Call |  |  | Ticket opened
Call date | Call time |  | Date | Time
2013-01-31 00:00:00 | 12:25:56 |  | 2013-01-14 00:00:00 | 00:12:07
2013-01-15 00:00:00 | 17:19:58 |  |  | 00:15:57
2013-01-23 00:00:00 | 08:06:26 |  | 2013-01-23 00:00:00 | 08:09:29
2013-01-07 00:00:00 | 06:07:09 |  | 2013-01-07 00:00:00 | 06:11:20
2013-01-11 00:00:00 | 19:48:36 |  | 2013-01-11 00:00:00 | 19:53:20
2013-01-14 00:00:00 | 00:09:37 |  | 2013-01-15 00:00:00 | 17:22:53
 |  |  | 2013-01-31 00:00:00 | 12:29:37
Spreadsheet: 125964d1319449434-excel-2007-how-to-shuffle-words-in-a-row-randomshuffle-3-
Sheet: Sheet1

Given Cells in Order |  |  |  |  |  |  |  |  |  |  |  |  | Random Shuffle |  |  |  |  |  |  |  |  |  |  |  |  | Concatenate the result
Google | Earth | lets | you | fly | anywhere | on | Earth | to | view | satellite | images |  | Earth | to | view | lets | satellite | anywhere | fly | you | images | Google | on | Earth |  | Earth to view lets satellite anywhere fly you images Google on Earth
Offers | the | choice | of | searching | the | whole | web |  |  |  |  |  | Offers | whole | choice | the | web | the | searching | of |  |  |  |  |  | Offers whole choice the web the searching of
PageRank | as | a | whole | number | between | 0 | and | 10 |  |  |  |  | as | PageRank | a | and | between | whole | 0 | number | 10 |  |  |  |  | as PageRank a and between whole 0 number 10
Spreadsheet: 99895d1298425102-tracking-income-and-invoices-for-projects-multiple-search-results-test-project-trackingvera
Sheet: Feb 2011

 | Income and Expense Report
 |  | 2011-02-01 00:00:00
 |  | 0 | LOSS
 | Date | Payment Type | Reference / Debtor No. | Supplier Invoice Number | Income  ($) | Purchasing Property | Total Invoice Costs ($) | MAC | GN | HF | BM | Comments
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  | PIF-ROW
 |  | Initial Instal'
 |  | Instalment
 |  | Final Instal'
 |  | Invoice Only
 |  | Other
Spreadsheet: phillip_platter__31373__ca0912EES
Sheet: BalanceWizard

Do NOT Touch! | HE01 | HE02 | HE03 | HE04 | HE05 | HE06 | HE07 | HE08 | HE09 | HE10 | HE11 | HE12 | HE13 | HE14 | HE15 | HE16 | HE17 | HE18 | HE19 | HE20 | HE21 | HE22 | HE23 | HE24
Use Path15 | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False
Use Path26 | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False
Min Flow | True | True | True | True | True | True | True | True | True | True | True | True | True | True | True | True | True | True | True | True | True | True | True | True
[NAME] | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False
Spreadsheet: 1068e4f9-782a-421e-99fc-23431b2fbed2
Sheet: POWER output

Month | Days/month | Monthly Averaged Energy Usage by Your school (kWh/month) | Monthly Averaged Insolation Incident On A Horizontal Surface (kWh/m2/day) | Monthly Averaged Insolation Incident On A Horizontal Surface (kWh/m2/month) | Area required to meet school's energy needs (m2) -- Assuming 100% efficiency | Area required to meet school's energy needs (m2) -- Assuming 20% efficiency
Jan | 31
Feb | 28
Mar | 31
Apr | 30
May | 31
Jun | 30
Jul | 31
Aug | 31
Sep | 30
Oct | 31
Nov | 30
Dec | 31
Annual Average
Spreadsheet: 1fb7f5f6-0625-406e-ac0c-db6891caceea
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME] 1
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 1202 | 1157 | 1027 | 899
20 - 60 | 3891 | 3337 | 2896 | 2493
60 und mehr | 2107 | 2338 | 2523 | 2664
Insgesamt | 7200 | 6832 | 6446 | 6056
%
unter 20 | 16.69444444444445 | 16.93501170960187 | 15.93236115420416 | 14.8447820343461
20 - 60 | 54.04166666666666 | 48.84367681498829 | 44.92708656531182 | 41.16578599735799
60 und mehr | 29.26388888888889 | 34.22131147540984 | 39.14055228048402 | 43.9894319682959
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 30.89180159342072 | 34.67186095295175 | 35.46270718232044 | 36.06097071801042
Altenquotient | 54.15060395785145 | 70.06293077614623 | 87.12016574585635 | 106.8592057761733
Gesamtquotient | 85.04240555127217 | 104.734791729098 | 122.5828729281768 | 142.9201764941837
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: sally_beck__36204__MgmtSum-Q201-Global-0525
Sheet: Expense Weekly Change

ENRON GLOBAL MARKETS
2nd QUARTER 2001 EXPENSES - WEEKLY CHANGE
 |  | Direct Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Crude & Products
Coal / Emissions
Vessel Trading
Emissions
Weather
Global Risk Markets
Financial Trading
Freight
LNG
Middle East
Puerto Rico
Finance and Structuring
Office of the Chairman
Subtotal Commercial
Group
Other Interest Related Charges
Total
 |  | Operating Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Spreadsheet: 454382d1459817595-using-dates-on-mutiple-sheets-to-pull-data-to-primary-sheet-test
Sheet: Sheet2

 | away | home
2016-04-05 00:00:00 | [NAME] | sfg
2016-04-05 00:00:00 | nyy | bal
2016-04-05 00:00:00 | tor | tab
2016-04-05 00:00:00 | sdg | [NAME]
2016-04-05 00:00:00 | kyt | bdb
2016-04-05 00:00:00 | yte | kui
2016-04-05 00:00:00 | tyu | olk
2016-04-05 00:00:00 | fnn | gnm
2016-04-05 00:00:00 | [NAME] | hbv
2016-04-05 00:00:00 | vsv | rfd
2016-04-05 00:00:00 | iyn | sed
2016-04-05 00:00:00 | rty | swf
2016-04-05 00:00:00 | tyi | vcf
2016-04-05 00:00:00 | hhr | [NAME]
2016-04-05 00:00:00 | no data | no data
2016-04-05 00:00:00 | no data | no data
2016-04-06 00:00:00 | iyn | sed
2016-04-06 00:00:00 | hhr | [NAME]
2016-04-06 00:00:00 | no data | no data
2016-04-06 00:00:00 | no data | no data
2016-04-06 00:00:00 | no data | no data
2016-04-06 00:00:00 | no data | no data
2016-04-06 00:00:00 | no data | no data
2016-04-06 00:00:00 | no data | no data