tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 769467d1645548995-populate-an-excel-calendar-with-information-from-sheet-in-same-workbook-opi-job-track-worksheet
Sheet: Practice

 |  | Month of: | 2022-02-01 00:00:00
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 |  | 2022-03-01 00:00:00
 |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  | 2022-04-01 00:00:00
 |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Spreadsheet: 538811d1505838094-finding-a-point-on-a-grid-armour-trips
Sheet: Kentville

[NAME] To: | [NAME]
Amherst, NS | 173
Annapolis, NS | 57
Atholville, NB | 403
Bathurst, NB | 334
Berwick, NS | 11
Bridgewater, NS | 62
Chatham, NB | 287
Dartmouth, NS | 64
Debert, NS | 117
[NAME], NS | 80
Fredericton, NB | 322
[NAME], NB | 447
Halifax, NS | 67
Hantsport, NS | 22
Lakeside, NS | 70
Lunenburg, NS | 59
Meteghan, NS | 111
Middleton, NS | 29
Mill Village, NS | 81
[NAME], NB | 217
[NAME], NS | 88
New Glasgow, NS | 146
New Minas, NS | 6
North Sydney, NS | 302
Port Hawkesbury, NS | 218
Pubnico, NS | 159
[NAME], NB | 305
Saulnierville, NS | 106
Scoudouc, NB | 213
Sydport-Term, NS | 314
Tantallon, NS | 82
Truro, NS | 109
Wedgeport, NS | 145
Weymouth, NS | 94
[NAME], PE | 253
Yarmouth, NS | 137
Spreadsheet: 36088d1233851856-vlookup-multiple-rows-to-one-worksheet1
Sheet: Detail

Product # | Comp. # | Percentage
57 | 106219 | 20
57 | 106222 | 80
129 | 106222 | 100
701 | 106160 | 11
701 | 106162 | 13
701 | 106222 | 76
703 | 100001 | 3.98
703 | 106160 | 0.5
703 | 108710 | 3.98
703 | 108720 | 91.54
Spreadsheet: 818942d1677136521-automating-results-across-sheets-pt-scoring-system_v1
Sheet: Full Data PT

Height | Weight | BMI | [NAME] (n) | T2 Sit Ups (n) | [NAME] (hh:min:sec.0) Week 11 | [NAME] Up Score | [NAME] Up Score | [NAME] | [NAME]
177 | 85 |  | 100 | 100 | 0
175 | 110 |  | 5 | 10 | 19.4
Spreadsheet: 157620d1337805461-master-tab-sample
Sheet: Person A

PAY PERIOD: |  | MAY 13 - MAY 26, 2012 |  |  | LOCATION:
EMPLOYEES NAME: |  | Person A |  |  | DIVISION: | 6502
 |  |  | TWO WEEK PERIOD
Date | Project | Description | Field ST | Field OT | Shop ST | Shop OT | Travel | R&M ST | R&M OT | Training ST | Training OT | Stat | CNRL TRAVEL | Daily Totals
Date | Project | Description | RT | OT | TT | XT | RT-Trvl |  |  |  |  | Q | Alb Trvl | Totals
2012-05-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2012-05-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2012-05-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2012-05-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2012-05-17 00:00:00 | [PHONE] | #N/A |  |  | 8 |  |  |  |  |  |  |  |  | 8
2012-05-18 00:00:00 | [PHONE] | #N/A |  |  | 8 |  |  |  |  |  |  |  |  | 8
2012-05-19 00:00:00 | [PHONE] | #N/A |  | 12 |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2012-05-20 00:00:00 | [PHONE] | #N/A |  | 12 |  |  |  |  |  |  |  |  |  | 12
2012-05-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2012-05-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2012-05-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2012-05-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2012-05-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2012-05-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2 Week Totals |  |  | 0 | 24 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40
 |  |  | Weekly Summary for ST Hours |  |  |  | 16
PayPeriod Summary
 |  |  |  |  |  |  |  | Comments:
 |  |  | # of Days
 |  |  | NLA
 |  |  | 0 | x $369.23= | 0
 |  |  | 0 | x $25.00= | 0
 |  |  | TOTAL |  | 0
 |  |  | #N/A
 |  |  |  | Values
 |  |  | Row Labels | Sum of Field ST | Sum of Field OT | Sum of Shop ST | Sum of Shop OT | Sum of Travel | Sum of Stat | Sum of R&M ST | Sum of R&M OT | Sum of Training ST | Sum of Training OT | Sum of CNRL TRAVEL
 |  |  | Project | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0
 |  |  | (blank)
 |  |  | [PHONE] |  | 24 | 16
 |  |  | Grand Total | 0 | 24 | 16 | 0 | 0 | 0 |  |  |  |  | 0
 |  | Field ST | Field OT | Shop ST | Shop OT | Travel | Stat | Total
Week 1 Totals: |  | 0 | 12 | 16 | 0 | 0 | 0 | 28
 |  | Field ST | Field OT | Shop ST | Shop OT | Travel | Stat | Total
Week 2 Totals: |  | 0 | 12 | 0 | 0 | 0 | 0 | 12
Spreadsheet: 134111d1325017050-simplified-report-for-equipment-maintenance-equipment-cost-report
Sheet: 7246

AMC No. | 09-04 | EQUIPMENT COST REPORT
Unit Number | OTV 7246 |  | Start Date | 24/07/2011 |  |  |  | [NAME] |  | 789
Employee Name: |  |  | End Date | 06/08/2011 |  |  |  | Hour [NAME] |  | 12
Date | Receipt Number | Vendor | Fuel |  | [NAME] |  | Motor Oil |  | [NAME]. Cost | Total Cost | Odometer | PRINT NAME
 |  |  | Quantity | Cost | Quantity | Cost | Quantity | Cost
 |  |  |  |  |  | Hour [NAME] |  |  |  | Odometer End
Service Record
[NAME] | [NAME] | Vendor | Receipt Number
Filter Changed |  |  |  |  |  | NOTES
Oil Changed
Greased
Other
Supervisor Signature: __________________________________________
Spreadsheet: 852251d1702334452-conc-or-textjoin-multiple-services-for-clients-conc-or-textjoin-automotive-services
Sheet: Sheet1

Client | Statement | Service 1 | Service 2 | Service 3 | Concatenate | Comments
[NAME] | We will also perform your: | oil change | tire rotation | annual inspection |  | needs commas and 'and'
Adam | We will also perform your:
Cathleen | We will also perform your: |  |  | annual inspection |  | extra space before 'annual'
Nick | We will also perform your: |  | tire rotation | annual inspection |  | needs 'and'
Ava | We will also perform your:
Erin | We will also perform your: | oil change | tire rotation | annual inspection |  | needs commas and 'and'
Emily | We will also perform your:
[NAME] | We will also perform your:
Caren | We will also perform your: |  | tire rotation |  |  | extra space before 'tire'
[NAME] | We will also perform your: | oil change
[NAME] | We will also perform your: | oil change | tire rotation |  |  | needs 'and'
[NAME] | We will also perform your:
[NAME] | We will also perform your: | oil change |  | annual inspection |  | needs 'and'
Abdul | We will also perform your: | oil change
Spreadsheet: 6361836c-f63c-4171-b2ed-f075b2d0770a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
업무추진비 집행내역
[건축시설부장] |  |  |  |  |  | (단위 : 원)
연번 | 일시 | 장소 | 내    역 | 지출액 | 참석인원 | 결재방식
1 | 5월4일 | 만수산 | 오찬간담회 | 37500 | 5명 | 카드
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Spreadsheet: 135890d1326295636-changing-col_index_num-using-vlookup-ef7_dummy-file
Sheet: Sheet2

Skill Expertise |  | a | b | c | d | e | f
Windows |  | 3 | 5 |  | 5 | 3 | 4
MS PROJECT |  |  |  |  | 4 |  | 3
ORCAD CIS |  | 4 | 5 | 3 | 5 | 3 | 5
DFM |  |  | 4 |  | 5 |  | 3
ALLEGRO PCB EDITOR
LP CALCULATOR (IPC-7351A)
TRACE WIDTH CALCULATOR
DFE |  |  |  |  | 5 |  | 4
VIA CALCULATOR
PAD DESIGNER
EMI / EMC SIMULATION
POWER INTEGRITY
PSPICE |  | 1 | 4 | 3 | 3 |  | 3
THERMAL SIMULATION |  |  | 2 |  | 2
SIGNAL INTEGRITY |  |  | 3 | 1 | 3 | 1 | 4
ALLEGRO |  | 1 | 5 |  | 5 | 4 | 4
MATLAB |  |  |  | 1
[NAME] |  |  | 3 | 3
KVASER CAN CARD |  |  | 3 | 2
VECTOR CAN CARD
OSCILLOSCOPE |  | 3 | 5 | 5 | 3 |  | 4
Electronics Work Bench |  | 2 |  |  |  |  | 4
Function Generator |  | 3 | 5 | 5 | 4
Hardware Testing + Troubleshooting |  |  |  | 4
Spreadsheet: 867263d1714115966-complex-transpose-problem-transpose-ef
Sheet: Table4

Item | Qty | Price
aaa | 1 | 10
aaa | 2 | 9
aaa | 3 | 8
bbb | 1 | 15
[NAME] | 1 | 20
[NAME] | 2 | 18
[NAME] | 3 | 16
[NAME] | 4 | 15
[NAME] | 5 | 14
ddd | 1 | 10
ddd | 2 | 8
ddd | 3 | 6
ddd | 4 | 5
ddd | 5 | 4
eee | 1 | 30
eee | 2 | 25
eee | 3 | 22
Spreadsheet: 54e81ac8-fa6a-4f53-8f09-678b79369008
Sheet: Sheet1

Unnamed: 0 | GOBPID | Pvalue | OddsRatio | ExpCount | Count | Size | Term
1 | GO:0042684 | 0.003399646 | 27.735849 | 0.089008766 | 2 | 12 | cardioblast cell fate commitment
2 | [NAME] | 0.004125068 | 10.298780 | 0.326365475 | 3 | 44 | amine biosynthetic process
3 | GO:0006952 | 0.005611833 | 4.806667 | 1.149696561 | 5 | 155 | defense response
4 | GO:0035050 | 0.006064838 | 19.800539 | 0.118678355 | 2 | 16 | [NAME] tube development
5 | GO:0009069 | 0.006840952 | 18.477987 | 0.126095752 | 2 | 17 | [NAME] acid metabolic process
6 | GO:0001764 | 0.007417397 | Inf | 0.007417397 | 1 | 1 | neuron migration
7 | GO:0019432 | 0.007417397 | Inf | 0.007417397 | 1 | 1 | triglyceride biosynthetic process
8 | GO:0019544 | 0.007417397 | Inf | 0.007417397 | 1 | 1 | arginine catabolic process to glutamate
9 | GO:0044262 | 0.009895481 | 5.169340 | 0.845583277 | 4 | 114 | cellular carbohydrate metabolic process
Spreadsheet: 730087d1619540557-nested-if-with-or-i-think-example-file
Sheet: Sheet1

Start Date | End Date | Days | Report From Date | Report To Date | Act Scpt Val Start Date:Posn Pysc | Act Scpt Val End Date:Posn Pysc | Effective Date:Posn Pay Details | Effective End Date:Posn Pay Details | Start Date:Occupancy | End Date:Occupancy
 |  |  | 2020-04-01 00:00:00 | 2021-03-31 00:00:00 | 2020-09-01 00:00:00 |  | 2020-07-01 00:00:00 | 2021-01-03 00:00:00 | 2020-07-01 00:00:00 | 2021-01-03 00:00:00
Spreadsheet: 731974d1620729458-create-a-cell-reference-to-another-worksheet-example-2-
Sheet: Sheet3

Nr. | Unique
123S453 |  | Something I found in internet, but dont understand how it works .:(
123S455
123S456
123S457
123S458
5
123S460
123S461
Spreadsheet: 878139d1725134367-need-to-show-the-number-of-occurances-within-a-date-range-cad-data-test
Sheet: CAD DATA TEST

Incident Start Date | CAD Unit
2024-01-02 00:00:00 | 409C
2024-01-02 00:00:00 | 410C
2024-01-02 00:00:00 | 405C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =COUNTIFS('CAD DATA TEST'!E14
2024-01-02 00:00:00 | 405C
2024-01-02 00:00:00 | 357C
2024-01-02 00:00:00 | 854C
2024-01-02 00:00:00 | 405C
2024-01-02 00:00:00 | 405C
2024-01-02 00:00:00 | 340C
2024-01-02 00:00:00 | 340C
2024-01-02 00:00:00 | 243C
2024-01-02 00:00:00 | 357C
2024-01-03 00:00:00 | 348C
2024-01-03 00:00:00 | 373C
2024-01-03 00:00:00 | 340C
2024-01-03 00:00:00 | 383C
2024-01-03 00:00:00 | 379C
2024-01-03 00:00:00 | 383C
2024-01-03 00:00:00 | 304C
2024-01-03 00:00:00 | 372C
2024-01-03 00:00:00 | 406C
2024-01-03 00:00:00 | 383C
2024-01-03 00:00:00 | 614C
2024-01-03 00:00:00 | 854C
2024-01-03 00:00:00 | 368C
2024-01-03 00:00:00 | 379C
2024-01-03 00:00:00 | 392C
2024-01-03 00:00:00 | 407C
2024-01-03 00:00:00 | 406C
2024-01-03 00:00:00 | 192C
2024-01-03 00:00:00 | 406C
2024-01-03 00:00:00 | 380C
2024-01-03 00:00:00 | 380C
2024-01-03 00:00:00 | 380C
2024-01-04 00:00:00 | 340C
2024-01-04 00:00:00 | 404C
2024-01-04 00:00:00 | 404C
2024-01-04 00:00:00 | 348C
2024-01-04 00:00:00 | 348C
2024-01-04 00:00:00 | 340C
2024-01-04 00:00:00 | 340C
2024-01-04 00:00:00 | 406C
2024-01-04 00:00:00 | 392C
2024-01-04 00:00:00 | 372C
2024-01-04 00:00:00 | 192C
2024-01-04 00:00:00 | 372C
2024-01-04 00:00:00 | 340C
2024-01-04 00:00:00 | 304C
Spreadsheet: 330909d1404902192-formula-for-matching-two-sheets-with-only-part-of-the-description-dslr
Sheet: Sheet1

Description
D-SLR  CANON EOS 1200D EFS18-55 IS
D-SLR  [NAME]
D-SLR  CANON EOS 1100D+EF-S18-55IS II
D-SLR  CANON EOS 1100D+EF-S18-55DC III
D-SLR  SONY SLT-A58K
D-SLR  NIKON D7100+AF-S 18-105 VR
D-SLR  NIKON D5300 18-55VR KIT
D-SLR  NIKON D7100 BODY
D-SLR  NIKON D5300 18-55VR II KIT
D-SLR  NIKON D3300 18-55 VR II KIT BLK
D-SLR  NIKON D3300 18-55 VR II KIT GR
D-SLR  CANON EOS-1100D/EFS18-55III+EF75300
D-SLR  CANON EOS 1100D+EF-S18-55IS II
D-SLR  CANON EOS 650D EFS18-55ISII KIT
D-SLR  CANON EOS 1100D+18-55+75-300+50MM
D-SLR  CANON EOS600D18-55III+75-300IIIEMBU
D-SLR  CANON EOS650D+18-55III+75-300IIIEMBU
D-SLR  CANON EOS 600D+18-55III DC
D-SLR  CANON EOS100D+EFS18-55IS STM
D-SLR  PENTAX PENTAX K500 18-55
Spreadsheet: 107303d1304510925-conditionally-copying-values-down-a-column-test
Sheet: Sheet2

Number | Reference | Helper
12321 | 10001
12322
12323
12324
12325
12326
12327
12328
12329
12330
12331 | 10002
12332
12333
12334
12335
12336
12337
12338
12339 | 10003
12340
12341
12342
12343
12344
12345 | 10004
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 71

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
W71 | 2018-05-30 00:00:00 | 8.04 | 0.545 | 3.03 | 1.28 | 1.95 |  | 3.652785548717129 | 0 | 0.467 | 1.223 | 348 |  |  | 0.049 | 5.022 | 0.017 | 0.03 | 0.016 | 0.002
Spreadsheet: 861155d1709118280-adding-countif-formula-is-there-a-better-way-excel-help-27-aligw
Sheet: Order of Merit

 |  | Cotswold | Caddington | Little Hay | Stanmore | Forest of Dean | Five Lakes | Silverstone | [NAME] | Cainhoe Woods | Batchwood Park
No | MEMBER | ReUnion | Pairs | [NAME] | Memorial | Weekender | Essex | Northants | European | Beds | Last Chance | Masters | Singles | TOTAL | WINS | Helper | Rank | AliGW
1 | ADAMS. [NAME] | 5 | 3 | 4 | 2
2 | ADAMS. [NAME] | 4 | 4 | 4 | 2
3 | BATTERBEE. [NAME] | 1 | 1 | 5 | 1
4 | BAXTER. [NAME]
5 | BENNETT. [NAME]
6 | BROMLEY. [NAME]
7 | CURT. [NAME]
8 | CURT. Sean
9 | DAVEY. [NAME]
10 | DERBYSHIRE. [NAME]
11 | DONNELLY. [NAME]
12 | DOWNER. [NAME]
13 | FORDE. [NAME]
14 | GARVEY. [NAME]
15 | GELLMAN. [NAME]
16 | GIBOIN. [NAME]
17 | GROUT. [NAME]
18 | HARVEY. [NAME]
19 | HIMSWORTH. [NAME]
20 | HODGES. [NAME]
21 | JUN. [NAME]
22 | KIDD. [NAME]
23 | KNOTT. [NAME]
24 | KOLEK. Darren
25 | KOLEK. [NAME]
26 | LEADBETTER. [NAME]
27 | LEECH. [NAME]
28 | LEECH. [NAME]
29 | LEONARD. [NAME]
30 | LEWIS. [NAME]
31 | LOOM. Scott
32 | MANKTELOW. Trevor
33 | MARVESLEY. [NAME]
34 | MCGILLIVRAY. [NAME]
35 | MCKENZIE. [NAME]
36 | MITCHELL. [NAME]
37 | MOSS. [NAME]
38 | MUNTING. [NAME]
39 | PEARCE. [NAME]
40 | PEARCE. [NAME]
41 | PYM. [NAME]
42 | SMITH. [NAME]
43 | SMITH. [NAME]
44 | TAYLOR. [NAME]
45 | THORPE. [NAME]
46 | VALENTINE. [NAME]
47 | VANN. Martin
48 | [NAME]. [NAME]
49 | WILLS. Stuart
 | Highest Score
Spreadsheet: 215a8e19-3954-41ce-b0d8-bb8cbb5769d3
Sheet: Sheet1

Table 12--Annual U.S. cotton textile exports, by destination | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Region/country | 2008 | 2009 | 2010 | 2011 | 2012
 | 1,000 pounds 1/
North America | 1680984.744 | 1356760.22 | 1605765.112 | 1646249.908 | 1446117.566
Canada | 135091.202 | 112927.664 | 111075.831 | 114771.456 | 119262.438
Costa Rica | 10261.535 | 4659.379 | 4631.498 | 3479.647 | 3928.616
Dominican Republic | 216934.536 | 209897.849 | 248181.361 | 332771.895 | 248098.758
El Salvador | 168581.227 | 114885.348 | 95127.771 | 137745.781 | 130710.699
Guatemala | 50017.872 | 42117.305 | 42866.667 | 34958.852 | 30091.144
Haiti | 8181.539 | 6739.748 | 8041.991 | 7242.092 | 8036.373
Honduras | 688713.629 | 510184.446 | 732140.939 | 670135.044 | 574627.278
Mexico | 374170.879 | 330032.585 | 331749.972 | 315928.094 | 300629.233
Nicaragua | 19784.725 | 16774.553 | 22671.468 | 18865.715 | 20802.501
Panama | 1804 | 1777 | 2240.42 | 4015.862 | 3393.047
South America | 37779.081 | 32446.212 | 33038.095 | 31489.891 | 36437.95
Brazil | 6074.064 | 5329.158 | 5932.926 | 8309.586 | 5676.359
Chile | 2396.491 | 2589.35 | 5514.507 | 2666.824 | 3211.121
Colombia | 14086.02 | 9865.699 | 7198.378 | 8303.47 | 14515.387
Peru | 2395.259 | 2950.509 | 4949.399 | 2944.434 | 3215.708
Venezuela | 9721.025 | 7895.179 | 5712.718 | 6168.505 | 6023.779
Europe | 46183.073 | 40068.13 | 41538.81 | 41045.755 | 36345.287
Belgium | 6235.693 | 4068.797 | 4776.39 | 4658.542 | 3644.55
Germany | 7464.803 | 7193.362 | 6360.763 | 7190.771 | 5667.158
Italy | 2532 | 2181 | 2016.708 | 2272.033 | 2020.721
Netherlands | 5481.974 | 4956.585 | 5421.656 | 4661.768 | 4655.301
United Kingdom | 12625.581 | 10602.711 | 11899.586 | 11748.676 | 11602.726
Asia | 64939.848 | 57521.603 | 87558.621 | 100804.773 | 108757.267
China | 12819.368 | 14821.219 | 39351.147 | 53300.864 | 63211.295
Hong Kong | 6114.314 | 4840.76 | 5569.061 | 5656.396 | 6761.776
India | 2306.6 | 2902.427 | 4141.143 | 3823.53 | 3177.708
Israel | 1730 | 2475.806 | 2022.039 | 2460.609 | 2038.25
Japan | 11739.166 | 9310.379 | 9893.36 | 10442.194 | 11044.03
Singapore | 3095.879 | 2286.379 | 2886.313 | 2373.468 | 2434.023
South Korea | 6992.407 | 6748.126 | 10451.588 | 7016.23 | 5630.582
United Arab Emirates | 3420.036 | 3352.943 | 2812.137 | 3025.448 | 3779.601
Oceania | 7148.943 | 7194.512 | 7100.352 | 9581.138 | 8828.059
Australia | 5545.952 | 5629.003 | 5288.074 | 7713.051 | 6933.477
Africa | 6651 | 4179 | 4084 | 8305 | 3480
World 2/ | 1843718.99 | 1498247.41 | 1779107.942 | 1837476.287 | 1639966.961
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Sources: USDA, Economic Research Service; and U.S. Dept. of Commerce, U.S. Census Bureau.
Last update: 03/12/13.
Spreadsheet: 122187d1316645963-copying-data-from-columns-to-a-new-sheet-when-the-result-of-a-cell-is-correct-demo
Sheet: Six

Date | Number | Surname | Forename | Staff | Type | Code | Team | Decision | Decision Date | Start | End | No. of Days
2011-09-01 00:00:00 | NW2221W | Smith | [NAME] | 12 | P | A22 | a | No | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 5
2011-09-01 00:00:00 | 003WW | [NAME] | [NAME] | 2 | P | A12 | a | No | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 5
2011-09-01 00:00:00 | [NAME] | Dunston | [NAME] | 2 | L | B6 | d | No | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 5
2011-09-01 00:00:00 | 87899 | Jones | [NAME] | 2 | L | F5 | d | Reserved | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 5
2011-09-01 00:00:00 | ASD3 | Smith | [NAME] | 5 | L | F5 | d | Reserved | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 5
2011-09-01 00:00:00 | ER4466 | [NAME] | [NAME] | 5 | T | C2 | d | No | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 5
2011-09-01 00:00:00 | 43459 | Pidge | [NAME] | 11 | T | C2 | d | Recon | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 5
2011-09-01 00:00:00 | FFGHJ | Watson | Stephen | 11 | A | A12 | d | No | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 5
2011-09-02 00:00:00 | [NAME] | Jennings | [NAME] | 6 | A | F5 | a | No | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 10
2011-09-02 00:00:00 | SDSAA | Boater | Adele | 2 | T | C12 | a | Yes | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 10
2011-09-02 00:00:00 | 34RT5 | [NAME] | [NAME] | 8 | G | C 12 | a | Reserved | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 10
2011-09-02 00:00:00 | WER456 | Talbot | [NAME] | 8 | T | [NAME] | c | Reserved | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 10
2011-09-02 00:00:00 | 11 | Trimby | [NAME] | 12 | T | [NAME] | c | Reserved | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 10
2011-09-02 00:00:00 | WE23QW | Collis | [NAME] | 1 | G | B6 | c | Reserved | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 10
2011-09-03 00:00:00 | MNBHU | Bolyn | [NAME] | 1 | G | B6 | c | Reserved | 2011-09-05 00:00:00 | 2011-09-05 00:00:00 | 2011-09-05 00:00:00 | 5
2011-09-03 00:00:00 | 123WE | [NAME] | Rose | 1 | P | H3 | a | No | 2011-09-05 00:00:00 | 2011-09-05 00:00:00 | 2011-09-05 00:00:00 | 5
2011-09-03 00:00:00 | GH789II | [NAME] | [NAME] | 3 | P | F5 | a | No | 2011-09-05 00:00:00 | 2011-09-05 00:00:00 | 2011-09-05 00:00:00 | 5
2011-09-03 00:00:00 | QWE | [NAME] | [NAME] | 3 | L | A12 | b | Recon | 2011-09-05 00:00:00 | 2011-09-05 00:00:00 | 2011-09-05 00:00:00 | 5 |  | Yes
2011-09-03 00:00:00 | 345TN | Bryant | [NAME] | 2 | T | [NAME] | b | Yes | 2011-09-05 00:00:00 | 2011-09-05 00:00:00 | 2011-09-05 00:00:00 | 5 |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Reserved
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Recon
Spreadsheet: 140986d1328999061-highlighting-dated-cells-0269
Sheet: Sheet1

 |  |  | 2
 | Table | Date moved
 | 1 | 2011-10-05 00:00:00
 | 2 | 2011-12-03 00:00:00 | 2012-01-02 00:00:00
 | 3
 | 4 | 2012-01-04 00:00:00
 | 5
 | 6 | 2011-10-05 00:00:00 | 2011-12-12 00:00:00
 | 7 | 2012-01-04 00:00:00
 | 8 | 2012-01-15 00:00:00
 | 9 | 2012-01-15 00:00:00
Spreadsheet: 157018d1337597880-summarize-data-with-count-ifs-sumifs-or-similar-excelforum-example
Sheet: Sheet1

Data | Data |  |  |  |  |  | Working time |  | Temporary |  | Permanent |  | Certain time
Name | Country | Field | Worked hours | Hiring form |  | Field | Europé | S. America | Europé | S. America | Europé | S. America | Europé | S. America
[NAME] | Sweden | Sales | 100 | Temporary |  | Sales | ? | ? | ? | ? | ? | ? | ? | ?
[NAME] | Germany | Tech support | 100 | Permanent |  | Tech support | ? | ? | ? | ? | ? | ? | ? | ?
Anders | England | Marketing | 25 | Certain time |  | Marketing | ? | ? | ? | ? | ? | ? | ? | ?
Marcus | Brazil | HR | 100 | Certain time |  | HR | ? | ? | ? | ? | ? | ? | ? | ?
[NAME] | Argentina | Focus areas | 80 | [NAME] |  | Focus areas | ? | ? | ? | ? | ? | ? | ? | ?
Isac | Peru | Production | 100 | Certain time |  | Production | ? | ? | ? | ? | ? | ? | ? | ?
[NAME] | Kanada | Supply chain | 100 | Temporary |  | Supply chain | ? | ? | ? | ? | ? | ? | ? | ?
[NAME] | Sweden | Sales | 100 | Temporary
[NAME] | Germany | Sales | 100 | Permanent
Lewis | England | Marketing | 25 | Vikariat |  | Sum of Worked hours | Column Labels
[NAME] | Brazil | HR | 100 | Certain time |  |  | Certain time |  |  | [NAME] | Permanent |  | Temporary |  | Vikariat
Fredric | Argentina | Focus areas | 80 | [NAME] |  | Row Labels | Brazil | England | Peru | Argentina | Germany | Kanada | Kanada | Sweden | England
Billy | Peru | Focus areas | 100 | Certain time |  | Focus areas |  |  | 100 | 160
[NAME] | Kanada | Supply chain | 100 | Permanent |  | HR | 200
 |  |  |  |  |  | Marketing |  | 25 |  |  |  |  |  |  | 25
 |  |  |  |  |  | Production |  |  | 100
 |  |  |  |  |  | Sales |  |  |  |  | 100 |  |  | 200
 |  |  |  |  |  | Supply chain |  |  |  |  |  | 100 | 100
 |  |  |  |  |  | Tech support |  |  |  |  | 100
 |  |  |  |  |  | Grand Total | 200 | 25 | 200 | 160 | 200 | 100 | 100 | 200 | 25