tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 127309d1320281219-highlight-cells-of-a-training-schedule-if-training-start-end-dates-filled-training-schedule
Sheet: Translations

 | LANGUAGE | ENGLISH | FRENCH | GERMAN | ITALIAN | PORTUGUESE | SPANISH | (custom)
 | NATIVE | ENGLISH | FRANÇAIS | DEUTSCHE | ITALIANO | PORTUGUÊS | ESPAÑOL
 | MONTH | JANUARY | [NAME] | JANUAR | GENNAIO | JANEIRO | ENERO
 |  | FEBRUARY | FÉVRIER | FEBRUAR | FEBBRAIO | FEVEREIRO | FEBRERO
 |  | [NAME] | MARS | MÄRZ | MARZO | MARÇO | MARZO
 |  | APRIL | AVRIL | APRIL | APRILE | ABRIL | ABRIL
 |  | MAY | MAI | MAI | MAGGIO | MAIO | MAYO
 |  | [NAME] | JUIN | JUNI | GIUGNO | JUNHO | JUNIO
 |  | JULY | JUILLET | [NAME] | LUGLIO | JULHO | JULIO
 |  | AUGUST | AOÛT | AUGUST | AGOSTO | AGOSTO | AGOSTO
 |  | SEPTEMBER | SEPTEMBRE | SEPTEMBER | SETTEMBRE | SETEMBRO | SEPTIEMBRE
 |  | OCTOBER | OCTOBRE | OKTOBER | OTTOBRE | OUTUBRO | OCTUBRE
 |  | NOVEMBER | NOVEMBRE | NOVEMBER | NOVEMBRE | NOVEMBRO | NOVIEMBRE
 |  | DECEMBER | [NAME] | [NAME] | DICEMBRE | DEZEMBRO | DICIEMBRE
 | WEEKNAME | MONDAY | LUNDI | MONTAG | LUNEDI | SEGUNDA-FEIRA | LUNES
 |  | TUESDAY | MARDI | DIENSTAG | MARTEDI | TERÇA-FEIRA | MARTES
 |  | WEDNESDAY | MERCREDI | MITTWOCH | MERCOLEDI | QUARTA-FEIRA | [NAME]
 |  | THURSDAY | JEUDI | DONNERSTAG | GIOVEDI | QUINTA-FEIRA | [NAME]
 |  | FRIDAY | VENDREDI | FREITAG | VENERDI | SEXTA-FEIRA | VIERNES
 |  | SATURDAY | SAMEDI | SAMSTAG | SABATO | SÁBADO | SÁBADO
 |  | SUNDAY | DIMANCHE | SONNTAG | DOMENICA | DOMINGO | DOMINGO
 | YEAR | YEAR | ANNÉE | YEAR | ANNO | ANO | AÑO
 | HOLIDAYS | HOLIDAYS | VACANCES | FERIEN | VACANZE | FERIADOS | VACACIONES
 | LANGUAGE | LANGUAGE | LANGUE | SPRACHE | LINGUA | IDIOMA | IDIOMA
 | THEME | THEME | THEME | THEMA | TEMA | TEMA | TEMA
 | DAY | DAY | JOUR | DAY | GIORNO | DIA | DÍA
 | MONTH | MONTH | MOIS | MONAT | MESE | MÊS | MES
Spreadsheet: 0c3494d7-8a73-417d-9546-fffce970a8f8
Sheet: Sheet1

Date | Start (BST) | End (BST) | Match | Notes
2012-05-14 00:00:00 | 11:00 | 17:00 | Round 1 | Live
2012-05-14 00:00:00 | 18:00 | 22:00 | Round 1 | Live
2012-05-15 00:00:00 | 10:00 | 17:00 | Round 1  / Round 2 | Live
2012-05-15 00:00:00 | 18:00 | 20:00 | Round 1  / Round 2 | Live
2012-05-16 00:00:00 | 11:00 | 17:00 | Round 2 | Live
2012-05-16 00:00:00 | 18:00 | 20:00 | Round 2 | Live
2012-05-17 00:00:00 | 11:00 | 17:00 | Last 16 | Live
2012-05-17 00:00:00 | 18:00 | 22:00 | Last 16 | Live
2012-05-18 00:00:00 | 11:00 | 17:00 | Quarter Finals | Live
2012-05-18 00:00:00 | 20:00 | 22:00 | Quarter Finals | Live
2012-05-19 00:00:00 | 15:00 | 17:00 | Semi Final | Live
2012-05-19 00:00:00 | 19:00 | 21:00 | Semi Final | Live
2012-05-20 00:00:00 | 15:00 | 17:30 | Final | Live
Spreadsheet: 141432d1329260068-creating-a-list-using-data-validation-can-i-create-a-subcategory-list-sonepar-technology-team-pos-and-invoices-2012
Sheet: Friedman Branches

Friedman Electric - FCOR
Branch ID's & Locations
2011-01-01 00:00:00
# | Location | Branch Code | Dept | Street Address | City | St | Zip Code | Phone | Fax | Branch Manager | Manager [NAME] | City & Branch ID
1 | Athens, PA | FATH | FATH | 610 West Pine Street | Athens | PA | 18810 | 5708829640 | 5708881420 | [NAME] | [EMAIL]
 | Bloomsburg, PA | FBLM | FBLM | 1100 Old Berwick Road | Bloomsburg | PA | 17815 | 5707849488 | 5707845361 | [NAME] | [EMAIL]
 | Brodheadsville, PA | FBRD | FBRD | Rt 115 & Countrside Drive, HCR #1 361 | Brodheadsville | PA | 18322 | 5709925444 | 5709923341 | [NAME] | [EMAIL]
 | Dubois, PA | FDUB | FDUB | 990 Beaver Drive | Dubois | PA | 15801 | 8143716440 | 8143711423 | [NAME] | [EMAIL]
 | Exeter, PA (Corporate) | FCOR | FCOR | 1321 Wyoming Ave | Exeter | PA | 18643 | 5706543371 | 5706556194 | [NAME] | [EMAIL]
 | Exeter, PA (Branch) | FEXE | FEXE | 1321 Wyoming Ave | Exeter | PA | 18643 | 5706543371 | 5706556194 | [NAME] | [EMAIL]
 | Hazleton, PA | FHAZ | FHAZ | 455 East Broad Street | Hazleton | PA | 18201 | 5704599760 | 5704590682 | [NAME] | [EMAIL]
 | Honesdale, PA | FHON | FHON | 250 Sunrise Avenue | Honesdale | PA | 18431 | 5702534775 | 5702538772 | [NAME] | [EMAIL]
 | Ithaca, NY | FITH | FITH | 245 Cecil A. Malone Drive | Ithaca | NY | 14850 | 6072567700 | 6072567708 | [NAME] | [EMAIL]
 | Johnson City, NY (Warehouse) | FJNC | FJNC | 4210 [NAME] | Johnson City | NY | 13790 | 6077972304 | 6077974157 | [NAME] | [EMAIL]
 | Johnson City, NY (Showroom) | FJSR | FJSR | 800 Valley Plaza | Johnson City | NY | 13790 | 6077972305 | 6077976106 | Penny Burlingame Singer | [EMAIL]
 | Pittston, PA | FPCD | FPCD | 258 Armstrong Road | Pittston | PA | 18640 | 5709918106
 | Scranton, PA | FSCR | FSCR | 650 Wyoming Avenue | Scranton | PA | 18509 | 5703432461 | 5709690125 | [NAME] | [EMAIL]
 | Selinsgrove, PA | FSEL | FSEL | 1000 North High Street | Selinsgrove | PA | 17870 | 5703746116 | 5703746110 | [NAME] | [EMAIL]
 | State College, PA | FSTC | FSTC | 2620 Carolean Drive | State College | PA | 16801 | 8142348414 | 8142348376 | [NAME] | [EMAIL]
 | Stroudsburg, PA | FSTR | FSTR | 20-26 North Fifth Street | Stroudsburg | PA | 18360 | 5704245402 | 5704211978 | [NAME] | [EMAIL]
 | [NAME], PA | FWBA | FWBA | 33 Hill Street | Wilkes [NAME] | PA | 18702 | 5708259591 | 5708293328 | [NAME] | [EMAIL]
Spreadsheet: 165371d1341204676-multiple-row-and-column-based-record-to-linear-format-10-06-12-lost
Sheet: West Distt.

Control Room No | 6694 | State | DELHI
FIR Number | 152/12 | District | WEST DISTRICT
FIR Date | 2012-06-10 00:00:00 | Police Station | VIKAS PURI
Vehicle Type | TWO WHEELER | Registration Number | DL9SAE9652
[NAME] | 2W - BAJAJ DISCOVER | Engine Number | 16857
[NAME] | 2010 | Chasis Number | 49803
Vehicle Color | BLACK | Phone Number | 9953189652
Complainant | AMIT SHARMA | Address | E/13B SHIV RAM PARK NEAR BALAJI MNDIR NANGLOI
Stolen From | C-490, VIKASPURI, NR. OXFORD SCHOOL.
Status | STOLEN/THEFT | Reporting Date/Time on ZIPNET | 2012-06-07 00:01:37.310000
Control Room No | 6909/DCR | State | DELHI
FIR Number | 208/12 | District | WEST DISTRICT
FIR Date | 2012-06-10 00:00:00 | Police Station | HARI NAGAR
Vehicle Type | TWO WHEELER | Registration Number | AP10AH5177
[NAME] | 2W - HERO HONDA SPLENDER PLUS | Engine Number | 40330
[NAME] | 2006 | Chasis Number | 40356
Vehicle Color | BLACK | Phone Number
Complainant | JATIN | Address
Stolen From | A-63 FIRST FLOOR
Status | STOLEN/THEFT | Report Dt./Time on ZIPNET | 2012-06-11 00:06:53.060000
Spreadsheet: 127036d1320142086-count-uniquecountwithtwocriteria
Sheet: Sheet1

 |  |  |  | Item |  |  |  |  |  |  |  |  |  | Order No |  | Item | Unique Orders
 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 123 |  | 7 | 10
 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 124
 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 125
 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 126
 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 123
 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 123
 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 123
 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 130
 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 131
 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 132
 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 133
 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 134
 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 135
Spreadsheet: 054618c8-1174-447e-9751-407b9c7bb5eb
Sheet: Sheet1

Unnamed: 0 | Appraisal to comply with RICS [NAME] GN 94/2012 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | VALUATION DATE
 | GROSS DEVELOPMENT VALUE | 0
 | DEVELOPMENT COSTS
 | SITE ACQUISTION | 0
 | PLANNING/OTHER FEES | 0
 | S106 | 0
 | PRE CONSTRUCTION | 0
 | CONSTRUCTION | 0
 | CONTINGENCY | 0
 | PROFESSIONAL FEES | 0
 | FINANCE | 0
 | DEVELOPERS RETURN | 0
 | TOTAL DEVELOPMENT COSTS | 0
 | SURPLUS/DEFICIT | 0
 | Key Assumptions
 | VALUES |  | COSTS
 |  | £ |  | £ Sq M |  |  | % | £ |  | £ per acre
 |  |  | House construction costs per sq m Type 1 | 0 |  | Construction Contingency | 0 |  | Value of land
 | House Values Type 1 | 0 | House construction costs per sq m [NAME] | 0 |  | Professional fee |  | 0
 | House Values Type 2 | 0 | House construction costs per sq m Type 3 | 0 |  | Development Finance | 0 | 0
 | House Values Type 3 | 0 | House construction costs per sq m Type 4 | 0 |  | Developers Profit on Cost | 0 | 0
 | House Values Type 4 | 0 |  |  |  | [NAME] profit on GDV | 0 | 0
Spreadsheet: 723840d1615913705-formula-for-if-its-x-date-cell-y-example
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | © 2020 Vertex42.com
Employee |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
ID | Name
1 |  |  |  |  |  | V |  |  |  |  |  |  | V
2 |  |  |  |  |  |  |  |  |  |  |  | V
3 |  |  |  |  |  |  |  | V
Spreadsheet: 736230d1623424804-copy-and-combining-duplicate-data-carllogsdon
Sheet: Sample

 | 2021-01-01 00:00:00 |  | 2021-02-01 00:00:00 |  | 2021-03-01 00:00:00 |  | 2021-04-01 00:00:00 |  | 2021-05-01 00:00:00 |  | 2021-06-01 00:00:00 |  | 2021-07-01 00:00:00 |  | 2021-08-01 00:00:00 |  | 2021-09-01 00:00:00 |  | 2021-10-01 00:00:00 |  | 2021-11-01 00:00:00 |  | 2021-12-01 00:00:00
Customer | # ECIs | Total cost | # ECIs | Total cost | # ECIs | Total cost | # ECIs | Total cost | # ECIs | Total cost | # ECIs | Total cost | # ECIs | Total cost | # ECIs | Total cost | # ECIs | Total cost | # ECIs | Total cost | # ECIs | Total cost | # ECIs | Total cost
ELSEVIER INC | 2 | 1.08
MINING MEDIA, INC. | 2 | 184.6
ENDEAVOR BUSINESS MEDIA LLC | 2 | 0
MINING MEDIA, INC. | 2 | 0
FAITH CATHOLIC | 2 | 0
Spreadsheet: 10716a36-0f5b-4270-b6b1-ffa57456d264
Sheet: Sheet1

Table 4--U.S. fiber demand | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Dec. | Jan. | Feb. |  | Feb.
Item | 2012 | 2013 | 2013 |  | 2012
 | 1,000 480-lb. [NAME]
Cotton:
All consumed by mills 1/ | 233 | 299 | 281 |  | 278
Total since August 1 | 1397 | 1695 | 1976 |  | 1924
Daily rate | 11.1 | 13 | 14.1 |  | 13.9
Upland consumed by mills 1/ | 232 | 297 | 280 |  | 276
Total since August 1 | 1390 | 1687 | 1967 |  | 1913
Daily Rate | 11 | 12.9 | 14 |  | 13.8
Upland exports | 855 | 1502 | 1733 |  | 1365
Total since August 1 | 3369 | 4871 | 6604 |  | 5322
Sales for next season | 40 | 67 | 368 |  | 94
Total since August 1 | 543 | 609 | 977 |  | 584
Extra-long staple exports | 42.4 | 75.4 | 66 |  | 59.2
Total since August 1 | 292.7 | 368.1 | 434.1 |  | 303.9
Sales for next season | 0 | 0 | 35.3 |  | 3.9
Total since August 1 | 4.4 | 4.4 | 39.8 |  | 40.9
 | Nov. | Dec. | Jan. |  | Jan.
 | 2012 | 2012 | 2013 |  | 2012
 | Million pounds
Manmade:
Raw fiber exports | 52.4 | 49.5 | 51.2 |  | 50.9
Noncellulosic | 51.9 | 49.1 | 50.7 |  | 50.5
Cellulosic | 0.5 | 0.4 | 0.5 |  | 0.4
Total since January 1 | 630.1 | 679.6 | 51.2 |  | 50.9
Total since January 1
 | 1,000 pounds
Wool and mohair:
Raw wool exports, clean | 917.8 | 596.5 | 665.2 |  | 191.2
Total since January 1 | 7144.2 | 7740.6 | 665.2 |  | 191.2
Wool top exports | 192.4 | 138.9 | 232.8 |  | 0
Total since January 1 | 921.9 | 1060.8 | 232.8 |  | 0
Mohair exports, clean | 35 | 130.8 | 1.7 |  | 0
Total since January 1 | 452 | 582.8 | 1.7 |  | 0
1/  Estimated by USDA.
Sources: USDA, Farm Service Agency; USDA, Export Sales;
U.S. Dept. of Commerce, U.S. Census Bureau; and [NAME].
Last update: 04/12/13.
Spreadsheet: 77431d1277907875-copying-data-from-one-sheet-to-another-help
Sheet: Sheet1

 |  |  |  | dob
 | 1st name | 2nd name | sex | dd | [NAME] | yy | cgno. | collno.
 | [NAME] | [NAME] | m | 12 | 23 | 34 | 1234567 | 9876548
 | [NAME] | moo | m | 78 | 89 | 45 | 9638524 | 1472581
 | ishy | fishy | f | 74 | 85 | 96 | 7418527 | 9516235
 | janey | waney | f | 96 | 78 | 28 | 7849518 | 7381643
Spreadsheet: 166247d1341507091-splitting-up-expanding-range-of-numbers-to-list-2-
Sheet: Sheet1

apple | 496 | 1 | 7 | Cat | 7 | 1 |  | apple | 496 | 1 | Cat
apple | 576 | 5 | 9 | Dog | 5 | 8 |  | apple | 496 | 2 | Cat
bannana | 834 | 2 | 8 | Bird | 7 | 13 |  | apple | 496 | 3 | Cat
fred | 123 | 7 | 11 | cow | 5 | 20 |  | apple | 496 | 4 | Cat
bannana | 496 | 2 | 6 | slug | 5 | 25 |  | apple | 496 | 5 | Cat
 |  |  |  |  |  |  |  | apple | 496 | 6 | Cat
 |  |  |  |  |  |  |  | apple | 496 | 7 | Cat
 |  |  |  |  |  |  |  | apple | 576 | 5 | Dog
 |  |  |  |  |  |  |  | apple | 576 | 6 | Dog
 |  |  |  |  |  |  |  | apple | 576 | 7 | Dog
 |  |  |  |  |  |  |  | apple | 576 | 8 | Dog
 |  |  |  |  |  |  |  | apple | 576 | 9 | Dog
 |  |  |  |  |  |  |  | bannana | 834 | 2 | Bird
 |  |  |  |  |  |  |  | bannana | 834 | 3 | Bird
 |  |  |  |  |  |  |  | bannana | 834 | 4 | Bird
 |  |  |  |  |  |  |  | bannana | 834 | 5 | Bird
 |  |  |  |  |  |  |  | bannana | 834 | 6 | Bird
 |  |  |  |  |  |  |  | bannana | 834 | 7 | Bird
 |  |  |  |  |  |  |  | bannana | 834 | 8 | Bird
 |  |  |  |  |  |  |  | fred | 123 | 7 | cow
 |  |  |  |  |  |  |  | fred | 123 | 8 | cow
 |  |  |  |  |  |  |  | fred | 123 | 9 | cow
 |  |  |  |  |  |  |  | fred | 123 | 10 | cow
 |  |  |  |  |  |  |  | fred | 123 | 11 | cow
 |  |  |  |  |  |  |  | bannana | 496 | 2 | slug
 |  |  |  |  |  |  |  | bannana | 496 | 3 | slug
 |  |  |  |  |  |  |  | bannana | 496 | 4 | slug
 |  |  |  |  |  |  |  | bannana | 496 | 5 | slug
 |  |  |  |  |  |  |  | bannana | 496 | 6 | slug
Spreadsheet: 116091d1311597349-excel-claim-sorting-claims-sorting-tracker-cst-
Sheet: Data

Type Renewal Date : |  | 2011-08-01 00:00:00 | Type Year | 2011
Serial | Date | Paid | Oustanding | Total | Title
1 | 2006-08-15 00:00:00 | 100 | 50 | 150 | MD
2 | 2007-05-01 00:00:00 | 50 | 100 | 150 | EL
3 | 2007-09-09 00:00:00 | 150 | 65 | 215 | PL
4 | 2008-08-15 00:00:00 | 65 | 45 | 110 | TH
5 | 2009-09-16 00:00:00 | 15 | 156 | 171 | EL
6 | 2010-11-01 00:00:00 | 5100 | 353 | 5453 | PL
7 | 2011-12-30 00:00:00 | 15 | 353 | 368 | MD
 | TOTAL | 5495 | 1122 | 6617
Spreadsheet: 54139d1254158535-row-lookup-followed-by-calculation-fantasy_stats_test
Sheet: QB - Week2

Name | Team |  | Comp | Att | Yds | Int | TD |  | Att | Yds | TD |  | Sack | SackYds |  | Fum | [NAME]
[NAME] | IND |  | 14 | 23 | 303 | 0 | 2 |  | 1 | 3 | 0 |  | 1 | 8 |  | 0 | 0
[NAME] | ARI |  | 24 | 26 | 243 | 0 | 2 |  | 1 | -1 | 0 |  | 0 | 0 |  | 0 | 0
[NAME] | HOU |  | 25 | 39 | 357 | 0 | 4 |  | 4 | 4 | 0 |  | 0 | 0 |  | 0 | 0
[NAME] | ATL |  | 21 | 27 | 220 | 1 | 3 |  | 2 | 3 | 0 |  | 0 | 0 |  | 0 | 0
[NAME] | MIN |  | 1 | 1 | 14 | 0 | 0 |  | 3 | -3 | 0 |  | 0 | 0 |  | 0 | 0
[NAME] | NOR |  | 25 | 34 | 311 | 1 | 3 |  | 1 | -1 | 0 |  | 2 | 23 |  | 2 | 0
[NAME] | MIN |  | 23 | 27 | 155 | 0 | 2 |  | 0 | 0 | 0 |  | 3 | 16 |  | 0 | 0
Eli Manning | NYG |  | 25 | 38 | 330 | 0 | 2 |  | 1 | 2 | 0 |  | 0 | 0 |  | 0 | 0
[NAME] | CHI |  | 27 | 38 | 236 | 0 | 2 |  | 1 | -1 | 0 |  | 2 | 5 |  | 0 | 0
[NAME] | NYJ |  | 14 | 22 | 163 | 0 | 1 |  | 2 | -2 | 0 |  | 2 | 26 |  | 1 | 0
Trent Edwards | BUF |  | 21 | 31 | 230 | 1 | 2 |  | 3 | 24 | 0 |  | 2 | 10 |  | 0 | 0
[NAME] | BAL |  | 17 | 26 | 190 | 1 | 2 |  | 5 | 3 | 0 |  | 1 | 9 |  | 1 | 0
[NAME] | CIN |  | 15 | 23 | 185 | 2 | 3 |  | 2 | 1 | 1 |  | 2 | 17 |  | 1 | 0
[NAME] | TEN |  | 21 | 33 | 216 | 1 | 2 |  | 2 | 4 | 0 |  | 2 | 7 |  | 1 | 1
[NAME] | SFO |  | 19 | 26 | 144 | 0 | 0 |  | 1 | 17 | 0 |  | 4 | 21 |  | 1 | 0
[NAME] | WAS |  | 23 | 35 | 242 | 0 | 0 |  | 7 | 28 | 0 |  | 1 | 5 |  | 1 | 0
Philip Rivers | SDG |  | 25 | 45 | 436 | 2 | 2 |  | 4 | 10 | 0 |  | 2 | 15 |  | 0 | 0
[NAME] | DEN |  | 19 | 37 | 263 | 0 | 1 |  | 2 | 0 | 0 |  | 0 | 0 |  | 0 | 0
[NAME] | GNB |  | 21 | 39 | 261 | 0 | 1 |  | 4 | 43 | 0 |  | 6 | 39 |  | 1 | 0
[NAME] | CAR |  | 25 | 41 | 308 | 1 | 1 |  | 0 | 0 | 0 |  | 1 | 12 |  | 0 | 0
[NAME] | PIT |  | 23 | 35 | 221 | 1 | 1 |  | 3 | 6 | 1 |  | 2 | 18 |  | 0 | 0
[NAME] | JAC |  | 23 | 43 | 282 | 1 | 2 |  | 4 | 27 | 0 |  | 4 | 2 |  | 3 | 1
[NAME] | STL |  | 15 | 28 | 125 | 0 | 1 |  | 2 | 9 | 0 |  | 1 | 6 |  | 1 | 0
[NAME] | SEA |  | 15 | 23 | 127 | 1 | 1 |  | 4 | 1 | 0 |  | 0 | 0 |  | 1 | 0
[NAME] | TAM |  | 26 | 50 | 296 | 2 | 3 |  | 1 | 0 | 0 |  | 2 | 0 |  | 1 | 0
[NAME] | PHI |  | 31 | 51 | 391 | 3 | 2 |  | 1 | -6 | 0 |  | 1 | 7 |  | 0 | 0
[NAME] | SEA |  | 10 | 18 | 97 | 0 | 0 |  | 3 | 12 | 0 |  | 1 | 7 |  | 0 | 0
[NAME] | MIA |  | 22 | 33 | 183 | 1 | 0 |  | 1 | 4 | 0 |  | 2 | 19 |  | 1 | 0
[NAME] | KAN |  | 24 | 39 | 241 | 2 | 1 |  | 5 | 34 | 0 |  | 2 | 5 |  | 0 | 0
[NAME] | ARI |  | 3 | 6 | 22 | 0 | 0 |  | 3 | -3 | 0 |  | 0 | 0 |  | 0 | 0
[NAME] | CLE |  | 18 | 31 | 161 | 1 | 0 |  | 3 | 4 | 0 |  | 4 | 15 |  | 1 | 1
[NAME] | DET |  | 18 | 30 | 152 | 2 | 1 |  | 1 | 7 | 0 |  | 2 | 16 |  | 1 | 0
[NAME] | NWE |  | 23 | 47 | 216 | 1 | 0 |  | 1 | 2 | 0 |  | 0 | 0 |  | 0 | 0
[NAME] | OAK |  | 7 | 24 | 109 | 0 | 0 |  | 3 | -3 | 0 |  | 2 | 10 |  | 0 | 0
[NAME] | DAL |  | 13 | 29 | 127 | 3 | 1 |  | 1 | 3 | 1 |  | 0 | 0 |  | 0 | 0
Spreadsheet: 138995d1328032477-validating-hourly-rates-ef20_timekeepingv2
Sheet: Sheet1

Name | Basic | [NAME] per Hour | Shift Start | Shift End | Hours w/ Night diff | Hours With Night diff | Night Differential | Total Salary
[NAME] | 10000 | 1250 | 1900-01-01 00:00:00 | 1900-01-01 06:00:00 |  |  | 0.1
Seph | 10000 | 1250 | 1900-01-01 01:00:00 | 1900-01-01 05:00:00 |  |  | 0.1
Nick | 10000 | 1250 | 18:00:00 | 1900-01-01 03:00:00 |  |  | 0.1
Com | 10000 | 1250 | 1900-01-01 00:00:00 | 1900-01-01 09:00:00 |  |  | 0.1
Com | 10000 | 1250 | 1/0/1900  11:00:00 PM | 1900-01-01 09:00:00 |  |  | 1.1
Night Differential
11PM to 6AM
night differential falls from 11PM to 6AM.  Its rate per hour is paid at 10%
Spreadsheet: 24423d1214758245-get-data-from-several-closed-xls-files-closed
Sheet: User

0 | Message : | -- HELLO --
Resulting_Excel.xls | shoppinglist.xls | for macro.xls | M_World_DB2new.xls | 001.xls | another macro.xls | Object1.xls | beverage.xls | date.xls | ALBAIFOpen.xls | extracting.xls | months graphed.xls | testing.xls | Test1.xls | Xl0000011.xls | Xl0000012.xls | reminder.xls | Desired List.xls | Xl0000013.xls | Xl0000014.xls | Attendance_Register(2).xls | Attendance_Register.xls | M_World_DB2.xls | Hyperlink.xls | Rank by subject.xls | school.xls | sheetname.xls | Chennai.xls | sirish.xls | R2C.xls | consolidate_-_indicates_the_source.xls | ferretlover.xls | final_settlement.xls | TEVT_AnilKumar_Week19.xls | TEVT_ChandraSekhar_Week19.xls | TEVT_Guruprasad_Week19.xls | TEVT_Rajani[1].B_Week19.xls | TEVT_SudiptoSengupta_Week19.xls | consolidate.xls | Book1.xls | 10.0 Macro Rebuild.xls | 20080420_Wk17.xls | 20080420_Wk17_ravi.xls | assessment sample.xls | school_macro.xls | spectraflame.xls | help_ravi.xls | harrymacro.xls | Rebuild.xls | coloured pics.xls | daveuknow.xls | Herman_macro.xls | doorwani.xls | CCE_Log.xls | Codyroadenergycapacity(1).xls | saveascsv.xls | Phone numbers of desktop.xls | vayaQueryProcessLogSheet_ZW_.xls | celeaning.xls | clean.xls | Stock Turns Example.xls | Stock with macro.xls | bajesh.xls | jp.xls | Reporting in progress 1.xls | Reporting in progress 1 with macro.xls | contact.xls | example 3.xls | extract.xls | closed.xls
stat.xls | Directory : | G:\a
snappy.xls
tzares.xls | This File : | closed.xls
consolidate.xls
 | Working Sheet : | Circuit Details
 | RANGE TO EXTRACT
 | FROM | A22 |  | 1
 | TO | a24 |  | A22:a24
 |  |  |  | True
 |  | this will extract a range from multiple workbooks in the same folder
 |  | providing a)you want the same range from each and a) the tab is named the same  and c)only those workbooks  and this one are  in the same folder
 | 1 | put all files in one folder
 | 2 | change path to match folder (C3)
 | 3 | put exact name of sheet tab you wish to copy  in C7
 | 4 | input start and end of range to copy
 | 5 | click init
 | 6 | click treat file wait till finished
 | note | if it’s a single column it will transpose data from each sheet to a row
 |  | if it’s a single row or a range of rows it will put them one under the other
 |  | output is on sheet "data"
 |  | THIS IS NOT MY ORIGINAL IDEA
 | STATION 1 | I MODIFIED IT FROM A COPY I THINK CAME FROM OZ GRID
 | OMC NAME
 | NAME
 | DATE
 | FEEDBACK GIVEN
 | S.No
 | Voice and Accent (40)
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | Voice and Accent Total
 | Voice & Accent % score
 | [NAME] (60)
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | Customer Handling Skills Total
 | Customer Handling Skills % score
 | Total Possible Points
 | end date
 | Date-Initial
Spreadsheet: 437804d1451515716-organizing-information-in-excel-need-this-for-work-organizing-info
Sheet: Goal

Team1 | 1. Attribute A | 4
 | 2. Atribute B | 6
 | 3. Attribute C | 3
 | 4. Attribute D | 2
Team 2 | 1. Attribute A | 6
 | 2. Atribute B | 2
 | 3. Attribute C | 6
 | 4. Attribute D | 2
Team 3 | 1. Attribute A | 6
 | 2. Atribute B | 3
 | 3. Attribute C | 6
 | 4. Attribute D | 3
Team1 | 1. Attribute A | 9
 | 2. Atribute B | 4
 | 3. Attribute C | 7
 | 4. Attribute D | 3
Team 2 | 1. Attribute A | 3
 | 2. Atribute B | 3
 | 3. Attribute C | 7
 | 4. Attribute D | 3
Team1 | 1. Attribute A | 9
 | 2. Atribute B | 4
 | 3. Attribute C | 7
 | 4. Attribute D | 3
Team 2 | 1. Attribute A | 3
 | 2. Atribute B | 3
Team 4 | 3. Attribute C | 6
 | 4. Attribute D | 2
 | 1. Attribute A | 6
 | 2. Atribute B | 3
 | 3. Attribute C | 6
 | 4. Attribute D | 3
Spreadsheet: 832332d1686268907-a-column-that-repeats-a-plate-5-times-and-adds-a-different-letter-after-each-plate-example-file
Sheet: Data

State | Plate | [NAME] | Equip | Account Number | Make | Year
MN | V123456 | alsk;fjdal;kjdfl;adjsf | 11111 | ABC123 | Bear | 2011
MN | [NAME] | alsdfjsldfjk | 55555 | ABC234 | Duck | 2013
MN | O123456 | [NAME] | 33333 | ABC567 | Horse | 2015
MN | A123456 | alksdfjasl;dkfjasldf | 222222 | ABC725 | Cat | 2010
MN | B123456 | lasj;df;lsdkjfl;sdjf | 44444 | ABC655 | Dog | 2012
PA | H12351 | asdl;jkaflkjfsljk | 1234 | ABC777 | Pig | 2009
NM | M32121 | al;dskjflskjfl;jdf | 57772 | ABC222 | [NAME] | 2005
AZ | G12543 | [NAME] | 56666 | ABC888 | [NAME] | 2003
Spreadsheet: 88cc6879-f3ff-42df-b3cc-6ffd5869db8e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7782 | 13399 | Claudia | Hille | GER | 0 | 01:00:22 | 00:01:07 | 01:48:27 | 00:01:23 | [NAME] | 1 | 03:25:08
7782 | 27040 | [NAME] | Venema | NED | 0 | 01:12:18 | 00:01:31 | 01:44:01 | 00:01:37 | 00:38:41 | 2 | 03:38:07
7782 | 57194 | Monique | Haans | NED | 0 | 01:08:44 | 00:01:46 | 01:53:06 | 00:02:05 | 00:39:52 | 3 | 03:45:30
7782 | 57007 | Claudia | Schlindwein | GER | 0 | 01:13:47 | [NAME] | 01:52:43 | 00:01:44 | 00:42:36 | 4 | 03:52:30