tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 475089d1471081294-transpose-identified-duplicate-names-to-a-single-row-p99-sample-prc
Sheet: Sheet1

DATE | FIRMS | value |  |  |  |  |  |  |  | DATE | aa | bbbb | [NAME]
2000-07-19 00:00:00 | aa | 112.98 |  |  |  |  |  |  |  | 2000-07-19 00:00:00 | 112.98 | 1430.38 | 405.11
2000-08-19 00:00:00 | aa | 113.39 |  |  |  |  |  |  |  | 2000-08-19 00:00:00 | 113.39 | 1480.42 | 413.5
2000-09-19 00:00:00 | aa | 113.31 |  |  |  |  |  |  |  | 2000-09-19 00:00:00 | 113.31 | 1493.2 | 377.44
2000-10-19 00:00:00 | aa | 113.18 |  |  |  |  |  |  |  | 2000-10-19 00:00:00 | 113.18 | 1446.37 | 212.25
2000-11-19 00:00:00 | aa | 954.35 |  |  |  |  |  |  |  | 2000-11-19 00:00:00 | 954.35 | 1301.2 | 239.99
2000-12-19 00:00:00 | aa | 897.76 |  |  |  |  |  |  |  | 2000-12-19 00:00:00 | 897.76 | 1249.58 | 364.34
19/12/2000 1 | aa | 939.72 |  |  |  |  |  |  |  | . | 939.72 | 1078.72 | 418.59
19/12/2000 2 | aa | 1108.41 |  |  |  |  |  |  |  | . | 1108.41 | 1082.35 | 616.33
19/12/2000 3 | aa | 1218.26 |  |  |  |  |  |  |  | . | 1218.26 | 967.47 | 584.3
2016-07-19 00:00:00 | aa | 1228.84 |  |  |  |  |  |  |  | 2016-07-19 00:00:00 | 1228.84 | 586.19 | 572.17
2000-07-19 00:00:00 | bbbb | 1430.38
2000-08-19 00:00:00 | bbbb | 1480.42
2000-09-19 00:00:00 | bbbb | 1493.2
2000-10-19 00:00:00 | bbbb | 1446.37 |  |  |  |  |  |  |  | PIVOT TABLE
2000-11-19 00:00:00 | bbbb | 1301.2 |  |  |  |  |  |  |  | Sum of value | Column Labels
2000-12-19 00:00:00 | bbbb | 1249.58 |  |  |  |  |  |  |  | Row Labels | aa | bbbb | [NAME]
19/12/2000 1 | bbbb | 1078.72 |  |  |  |  |  |  |  | 2000-07-19 00:00:00 | 112.98 | 1430.38 | 405.11
19/12/2000 2 | bbbb | 1082.35 |  |  |  |  |  |  |  | 2000-08-19 00:00:00 | 113.39 | 1480.42 | 413.5
19/12/2000 3 | bbbb | 967.47 |  |  |  |  |  |  |  | 2000-09-19 00:00:00 | 113.31 | 1493.2 | 377.44
2016-07-19 00:00:00 | bbbb | 586.19 |  |  |  |  |  |  |  | 2000-10-19 00:00:00 | 113.18 | 1446.37 | 212.25
2000-07-19 00:00:00 | [NAME] | 405.11 |  |  |  |  |  |  |  | 2000-11-19 00:00:00 | 954.35 | 1301.2 | 239.99
2000-08-19 00:00:00 | [NAME] | 413.5 |  |  |  |  |  |  |  | 2000-12-19 00:00:00 | 897.76 | 1249.58 | 364.34
2000-09-19 00:00:00 | [NAME] | 377.44 |  |  |  |  |  |  |  | 19/12/2000 1 | 939.72 | 1078.72 | 418.59
2000-10-19 00:00:00 | [NAME] | 212.25 |  |  |  |  |  |  |  | 19/12/2000 2 | 1108.41 | 1082.35 | 616.33
2000-11-19 00:00:00 | [NAME] | 239.99 |  |  |  |  |  |  |  | 19/12/2000 3 | 1218.26 | 967.47 | 584.3
2000-12-19 00:00:00 | [NAME] | 364.34 |  |  |  |  |  |  |  | 2016-07-19 00:00:00 | 1228.84 | 586.19 | 572.17
19/12/2000 1 | [NAME] | 418.59
19/12/2000 2 | [NAME] | 616.33
19/12/2000 3 | [NAME] | 584.3
2016-07-19 00:00:00 | [NAME] | 572.17
Spreadsheet: 376308d1423561355-count-group-direfently-if-one-parameter-is-different-tests-ndm
Sheet: What i want

[NAME] that I enter |  |  |  |  | Calculated dana
Date | Location | Worker | O/C (O/C) | Positive (Y/N) | Merged for calculating no. of monthly inspectionsof contractor/own | Merged for calculating number of uniqe inspections | Merged calculator for uniqe inspections |  |  |  | month-> | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | SUM
2015-01-05 00:00:00 | Back Woods | abc | O | N |  |  |  |  |  | O | Own - No. of inspections
2015-01-05 00:00:00 | Back Woods | abc | O | N |  |  |  |  |  | O | Own - No. of inspections w/o "Y"
2015-01-05 00:00:00 | Back Woods | abc | C | N |  |  |  |  |  | C | Contractor - No. of inspections
2015-01-05 00:00:00 | Back Woods | abc | C | Y |  |  |  |  |  | C | Contractor - No. of inspections w/o "Y"
2015-01-05 00:00:00 | Back Woods | abc | C | N
2015-01-05 00:00:00 | Back Woods | abc | O | N
2015-01-05 00:00:00 | Back Woods | abc | O | N
2015-01-05 00:00:00 | Back Woods | abc | O | Y
2015-01-05 00:00:00 | Back Woods | abc | O | N
2015-01-05 00:00:00 | Back Woods | abc | O | Y
2015-01-06 00:00:00 | Yard | abc | O | N
2015-01-06 00:00:00 | Yard | abc | O | N
2015-01-06 00:00:00 | Yard | abc | C | Y
2015-01-07 00:00:00 | Front | abc | C | N
2015-01-07 00:00:00 | Front | abc | C | N
2015-01-07 00:00:00 | Front | abc | O | N
2015-01-07 00:00:00 | Front | abc | O | N
2015-01-07 00:00:00 | Front | abc | O | N
2015-01-07 00:00:00 | Front | abc | O | N
2015-01-07 00:00:00 | Front | abc | O | N
2015-02-10 00:00:00 | Yard | abc | O | N
2015-02-10 00:00:00 | Yard | abc | O | N
2015-02-10 00:00:00 | Yard | abc | O | N
2015-02-10 00:00:00 | Yard | abc | O | N
2015-05-08 00:00:00 | Front | abc | C | Y
2015-05-08 00:00:00 | Front | abc | C | N
2015-05-08 00:00:00 | Front | abc | C | N
2015-05-08 00:00:00 | Front | abc | C | N
2015-05-08 00:00:00 | Front | abc | C | N
Spreadsheet: 100690d1298978401-add-letters-to-numbers-in-column-b-book3_sem-
Sheet: Sheet8

01  02  03  04  05
01  06 15 29 44
01  07 12 20 35
01  08 27 33 36
01  09 19 21 45
01 10 11 24 39
01 13 18 26 37
01 14 25 34 41
01 16 32 38 43
01 17 23 28 31
01 22 30 40 42
02  06 12 25 40
02  07 11 30 45
02  08 13 16 31
02  09 28 34 37
02 10 20 22 41
02 14 19 27 38
02 15 21 35 42
02 17 33 39 44
02 18 24 29 32
02 23 26 36 43
03  06 16 23 42
03  07 13 21 36
03  08 12 26 41
03  09 14 17 32
03 10 29 35 38
03 11 22 31 43
03 15 20 28 39
03 18 34 40 45
03 19 25 30 33
03 24 27 37 44
04  06 30 31 39
04  07 17 24 43
04  08 14 22 37
04  09 13 27 42
04 10 15 18 33
04 11 16 29 40
04 12 23 32 44
04 19 35 36 41
04 20 21 26 34
04 25 28 38 45
05  06 11 19 34
05  07 26 32 40
05  08 18 25 44
05  09 15 23 38
05 10 14 28 43
05 12 17 30 36
05 13 24 33 45
05 16 22 27 35
05 20 31 37 42
05 21 29 39 41
06  07  08  09 10
06 13 17 38 41
06 14 24 26 35
06 18 22 28 36
06 20 27 32 45
06 21 33 37 43
07 14 18 39 42
07 15 25 27 31
07 16 28 33 41
07 19 23 29 37
07 22 34 38 44
08 11 21 28 32
08 15 19 40 43
08 17 29 34 42
08 20 24 30 38
08 23 35 39 45
09 11 20 36 44
09 12 22 29 33
09 16 25 26 39
09 18 30 35 43
09 24 31 40 41
10 12 16 37 45
10 13 23 30 34
10 17 21 27 40
10 19 26 31 44
10 25 32 36 42
11 12 13 14 15
11 17 25 35 37
11 18 23 27 41
11 26 33 38 42
12 18 21 31 38
12 19 24 28 42
12 27 34 39 43
13 19 22 32 39
13 20 25 29 43
13 28 35 40 44
14 16 21 30 44
14 20 23 33 40
14 29 31 36 45
15 16 24 34 36
15 17 22 26 45
15 30 32 37 41
16 17 18 19 20
21 22 23 24 25
26 27 28 29 30
31 32 33 34 35
36 37 38 39 40
41 42 43 44 45
Spreadsheet: d769c97d-f8bf-4347-9833-4715f648fe37
Sheet: 7.4 Page

7.4 Health—bulk billing and private health insurance
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
General practice bulk billing rate – per cent (a)
September | 78.8 | 79.8 | 80.7 | 81.7 | 82.8
December | 79.6 | 79.8 | 80.9 | 82 | 83.1
March | 79.6 | 80.2 | 81.2 | 82.4 | 83.6
June | 80.2 | 80.9 | 82 | 82.8 | 84.1
Annual | 79.55 | 80.17500000000001 | 81.2 | 82.225 | 83.39999999999999
Private health insurance hospital coverage rate – per cent
September | 45.08096679552347 | 45.53591571185988 | 46.15959354253204 | 46.74981429894813 | 47.03406840886705
December | 45.12814214754992 | 45.63737010236642 | 46.20332977086591 | 46.72900796747304 | 46.99921033431011
March | 45.1384024857778 | 45.66804539635353 | 46.19363179006441 | 46.7257311945353 | 46.99534691839843
June | 45.27669024424733 | 45.91358597678721 | 46.59980093973978 | 46.90868302628604 | 47.17063910854445
(a) Out of hospital services only | http://www.health.gov.au/internet/main/publishing.nsf/Content/Medicare+Statistics-1 | http://www.health.gov.au/internet/main/publishing.nsf/Content/Medicare+Statistics-1 | http://www.health.gov.au/internet/main/publishing.nsf/Content/Medicare+Statistics-1 | http://www.health.gov.au/internet/main/publishing.nsf/Content/Medicare+Statistics-1
http://www.phiac.gov.au/statistics/trends/index.htm | http://www.phiac.gov.au/statistics/trends/index.htm | http://www.phiac.gov.au/statistics/trends/index.htm | http://www.phiac.gov.au/statistics/trends/index.htm | http://www.phiac.gov.au/statistics/trends/index.htm | http://www.phiac.gov.au/statistics/trends/index.htm
Sources:
Department of Health and Ageing, Medicare statistics online
Private Health Insurance Administration Council, Membership statistics online
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | December 2014 for bulk billing data
 |  |  |  |  |  |  |  | December 2014 for health insurance data
Spreadsheet: 172432d1344210570-conditional-formatting-and-basic-array-question-array-and-conditional-formatting
Sheet: Sheet1

 | Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | Column 14 | Column 15 | Largest | 2nd Largest?
Row 1 | 5.5 | 5.5 | 5.5 | 5.5 | 4 | 5.5 | 5.5 | 3 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5
Row 2 | 7 | 7 | 6.5 | 7 | 6.5 | 7 | 7 | 7 | 7 | 6.5 | 7 | 6.5 | 7 | 6.5 | 6.5
Row 3 | 7.5 | 7 | 7 | 7 | 7 | 7.5 | 7 | 7 | 7 | 7.5 | 7 | 7 | 7.5 | 7 | 7.5
Row 4 | 7 | 7.5 | 8 | 7.5 | 8 | 8 | 7.5 | 8 | 7.5 | 8 | 8 | 7 | 8 | 7.5 | 8
Row 5 | 8 | 7 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 8 | 7.5 | 9 | 8 | 7.5 | 7.5 | 8.5 | 8
Row 6 | 9 | 8.5 | 8 | 8 | 8 | 8.5 | 8 | 8 | 8 | 8 | 8 | 8 | 9 | 8 | 8
Row 7 | 11 | 13 | 11 | 13 | 11 | 12 | 11 | 11 | 11 | 11 | 11 | 12 | 13 | 11 | 10
Row 8 | 11 | 13 | 11 | 13 | 11 | 13 | 12 | 11 | 13 | 11 | 11 | 12 | 11 | 12 | 12
Row 9 | 15 | 13 | 13 | 15 | 13 | 13 | 13 | 15 | 15 | 15 | 15 | 13 | 15 | 13 | 13
Row 10 | 15 | 21 | 17 | 17 | 17 | 21 | 17 | 17 | 17 | 17 | 17 | 17 | 21 | 15 | 19
Row 11 | 21 | 26 | 26 | 26 | 26 | 29 | 23 | 21 | 26 | 26 | 21 | 26 | 21 | 26 | 26
Row 12 | 26 | 34 | 26 | 26 | 26 | 41 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 23
Spreadsheet: 678228d1589789360-dynamic-reporting-possible-pivot-table-with-multiple-columns-on-one-sheet-to-source-from-pivottest
Sheet: Report

Report
Agency Engaged |  |  | Organisation Type Engaged |  |  | Progress of Projects
Name | Number of Times |  | Type | Number of times |  | Progress | #
ONETAKE | 3 |  | BUSINESS | 0 |  | STARTUP | 9
TWOTAKE | 3 |  | PRIVATE | 10 |  | ONGOING | 5
GIVEONE | 5 |  | CORPORATION | 6 |  | STALLED | 5
GIVETWO | 5 |  | GOVERNMENT | 6 |  | FINISHED | 1
OUTTERONE | 3 |  |  |  |  | UNKNOWN | 0
OUTTERTWO | 3
BEYONDONE | 0
BEYONDTWO | 0
Spreadsheet: 1490a0bb-eb02-4b5e-8405-337e97a9598f
Sheet: Sheet1

Table S5. Homoeolog-specific regulation of 3-ketoacyl-CoA synthase (KCS) genes in developing cotton fiber. Expression levels were normalized with RPKM.
GoraiID | seq_description | dom10_At | dom10_Dt | homeolog regulation | Regulation at 10 dpa
Gorai.001G150900.1 | 3-ketoacyl-CoA synthase 1 | 0 | 0.1034961328164912
Gorai.004G149300.1 | 3-ketoacyl-CoA synthase 1 | 0.05016914273621034 | 0.4933317047838652
Gorai.008G129800.1 | 3-ketoacyl-CoA synthase 1 | 53.93085736484583 | 132.080469085659 | Dt_up
Gorai.006G069800.1 | 3-ketoacyl-CoA synthase 2 | 11.18534995045281 | 28.80196480126193 | Dt_up
[NAME] | 3-ketoacyl-CoA synthase 2 | 469.3544632455905 | 210.1346542985988 | At_up | dom > wild
Gorai.011G165200.1 | 3-ketoacyl-CoA synthase 2 | 194.9401246347755 | 161.4133332420926 |  | dom > wild
Gorai.002G005600.1 | 3-ketoacyl-CoA synthase 4 | 0 | 0
Gorai.002G005700.1 | 3-ketoacyl-CoA synthase 4 | 0 | 0
Gorai.005G108000.1 | 3-ketoacyl-CoA synthase 4 | 2.690838831377519 | 1.588872900576114
Gorai.005G244100.1 | 3-ketoacyl-CoA synthase 4 | 4.467591778959767 | 7.549184646161665 |  | dom > wild
Gorai.009G201600.1 | 3-ketoacyl-CoA synthase 4 | 16.69245830982532 | 11.68325709199201 |  | dom > wild
Gorai.002G218500.1 | 3-ketoacyl-CoA synthase 6 | 920.2377460002525 | 1554.017313904958 |  | dom > wild
Gorai.006G065600.1 | 3-ketoacyl-CoA synthase 6 | 0 | 0
Gorai.007G009500.1 | 3-ketoacyl-CoA synthase 6 | 0 | 0
Gorai.002G005500.2 | 3-ketoacyl-CoA synthase 9 | 1.969503950065383 | 5.491160680781718 | Dt_up
Gorai.010G093900.1 | 3-ketoacyl-CoA synthase 10 | 0.235472602583095 | 4.984069653373014
Gorai.013G221500.1 | 3-ketoacyl-CoA synthase 10 | 439.341532016718 | 401.3909272638014
Gorai.004G278700.1 | 3-ketoacyl-CoA synthase 11 | 0.2362221105450744 | 0
Gorai.009G021000.1 | 3-ketoacyl-CoA synthase 11 | 17.01536728866043 | 23.95535397217619
Gorai.010G066800.4 | 3-ketoacyl-CoA synthase 11 | 39.97594105073445 | 59.96640880603836
Gorai.001G107300.1 | 3-ketoacyl-CoA synthase 12 | 11.20416850089072 | 44.12955634027884 | Dt_up
Gorai.009G102300.1 | 3-ketoacyl-CoA synthase 12 | 528.9669892630137 | 218.7396507297173 | At_up | dom > wild
Gorai.010G202800.1 | 3-ketoacyl-CoA synthase 19 | 74.12506977797932 | 116.7822088755274
Gorai.011G245100.1 | 3-ketoacyl-CoA synthase 19 | 1.083532575639924 | 3.227863953977903
Gorai.011G249000.1 | 3-ketoacyl-CoA synthase 19 | 100.0437137479454 | 4.060553898838065 | At_up | dom > wild
Gorai.011G249100.1 | 3-ketoacyl-CoA synthase 19 | 3.695335086738329 | 0 | At_only | dom > wild
Gorai.011G249200.1 | 3-ketoacyl-CoA synthase 19 | 297.8544890985553 | 125.5202972821035 | At_up | dom > wild
Spreadsheet: 841083d1693331736-unique-count-filter-count-lookup-test
Sheet: 1

 |  |  |  |  | First Name | Last Name | Dept Code |  |  |  | First Name | count 16
 |  |  |  |  | [NAME] | Last Name | TN-PR-ASS |  |  |  | [NAME]
 |  |  |  |  | Kuarmeshia | Last Name | TN-PR-ASS |  |  |  | Kuarmeshia
 |  |  |  |  | Dagim | Last Name | TN-PR-WAR |  |  |  | Dagim
 |  |  |  |  | Reginald | Last Name | TN-PR-WAR |  |  |  | Reginald
 |  |  |  |  | Salvador | Last Name | TN-PR-WAR |  |  |  | Salvador
 |  |  |  |  | Terrance | Last Name | TN-PR-ASS |  |  |  | Terrance
 |  |  |  |  | Hring | Last Name | TN-PR-ASS |  |  |  | Hring
 |  |  |  |  | [NAME] | Last Name | TN-PR-WAR |  |  |  | [NAME]
 |  |  |  |  | Bu | Last Name | TN-PR-ASS |  |  |  | Bu
 |  |  |  |  | Luz | Last Name | TN-PR-ASS |  |  |  | Luz
 |  |  |  |  | [NAME] | Last Name | TN-PR-WAR |  |  |  | [NAME]
 |  |  |  |  | [NAME] | Last Name | TN-PR-WAR |  |  |  | [NAME]
 |  |  |  |  | Vahn | Last Name | TN-PR-ASS |  |  |  | Vahn
 |  |  |  |  | [NAME] | Last Name | TN-PR-WAR |  |  |  | [NAME]
 |  |  |  |  | Ovidio | Last Name | TN-PR-WAR |  |  |  | Ovidio
 |  |  |  |  | Brett | Last Name | TN-PR-WAR |  |  |  | Brett
 |  |  |  |  | [NAME] | Last Name | TN-PR-ASS
 |  |  |  |  | Kuarmeshia | Last Name | TN-PR-ASS
 |  |  |  |  | Dagim | Last Name | TN-PR-WAR
 |  |  |  |  | Reginald | Last Name | TN-PR-WAR
 |  |  |  |  | Salvador | Last Name | TN-PR-WAR
 |  |  |  |  | Terrance | Last Name | TN-PR-ASS
 |  |  |  |  | Hring | Last Name | TN-PR-ASS
 |  |  |  |  | [NAME] | Last Name | TN-PR-WAR
 |  |  |  |  | Bu | Last Name | TN-PR-ASS
 |  |  |  |  | Luz | Last Name | TN-PR-ASS
 |  |  |  |  | [NAME] | Last Name | TN-PR-WAR
 |  |  |  |  | [NAME] | Last Name | TN-PR-WAR
 |  |  |  |  | Vahn | Last Name | TN-PR-ASS
 |  |  |  |  | [NAME] | Last Name | TN-PR-WAR
 |  |  |  |  | Ovidio | Last Name | TN-PR-WAR
 |  |  |  |  | Brett | Last Name | TN-PR-WAR
Spreadsheet: 718351d1613111864-required-formula-to-generate-leave-register-additional-requirement-sample_leavebook2
Sheet: Result

 |  | Leaves
 | [NAME]
 | Micheal
 | [NAME]
 | Ahmed
 | [NAME]
 | Greg
 | Micky
 | Trace
 | Lisy
 | Saraham
 | Leave - Monthwise
 | Name | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00
 | [NAME]
 | Micheal
 | [NAME]
 | Ahmed
 | [NAME]
 | Greg
 | Micky
 | Trace
 | Lisy
 | Saraham
 | Total
Spreadsheet: 7cbf8c62-f69a-477b-93d7-5fabd2ff4a28
Sheet: Sheet1

Finanční vyúčtování dotace | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
PŘÍJEMCE                                                               (jméno a příjmení/název/obchodní firma)
ADRESA                                                                  (trvalé bydliště/místo podnikání/sídlo)
IČ                                                                              (u fyzické osoby i datum narození a rodné číslo)
Název dotačního programu |  |  | [NAME] kraji na rok 2008
Název projektu
Celkové výdaje na projekt                                  ( v Kč ):
Výše dotace z rozpočtu JMK                               ( v Kč ):
Z dotace vráceno                                                    ( v Kč ):
Prostředky vráceny na účet JMK dne
Osoba odpovědná za vyúčtování dotace ([NAME] a příjmení, funkce, adresa, telefon)
Soupis dokladů vztahujících se k realizaci projektu/akce/činnosti
číslo účetního dokladu v účetní evidenci | číslo prvotního účetního dokladu | název dokladu | datum vystavení dokladu | účel platby | datum platby | [NAME] (bez DPH)* | z toho částka hrazená z dotace JMK
V ………………………………………dne ……………………………
Název/obchodní firma a podpis osoby [NAME] (příp. též otisk razítka):
…………………………………………………………………………………………………..
*Není-li příjemce plátcem DPH, uvede celkové výdaje včetně DPH.
[NAME] příjemce plátcem DPH, ale nemůže v konkrétním případě uplatnit nárok na odpočet DPH na vstupu podle
zákona č. 235/2004 Sb., o dani z přidané hodnoty, ve znění pozdějších předpisů, uvede rovněž celkové výdaje
včetně DPH.
Pokud je příjemce plátcem DPH a má nárok v konkrétním případě uplatnit nárok na odpočet DPH na vstupu
[NAME] č. 235/2004 Sb, o dani z přidané hodnoty, ve znění pozdějších předpisů, bude částka uvedena bez DPH.
Spreadsheet: a3550a28-1345-47fb-9596-3e202fc6537c
Sheet: Sheet1

Unnamed: 0 | BUCS Squash 2010/11 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 | Home Team | Men's Results Card |  |  |  |  |  |  |  |  |  |  |  | Away Team
 | Brunel Univeristy 3rd Team | Match Date: |  |  | 2010-10-20 00:00:00 |  |  |  |  |  |  |  |  | Brunel University 2nd Team
 |  | Games | Individual Game Scores |  |  |  |  |  |  |  |  |  | Games
 |  |  | H | A | H | A | H | A | H | A | H | A
 | [NAME] | 0 | 7 | 11 | 5 | 11 | 4 | 11 |  |  |  |  | 3 | Nirav Bhajaj
 | Bhavesh Thapariya | 1 | 8 | 11 | 11 | 7 | 10 | 12 | 7 | 11 |  |  | 3 | [NAME]
 | [NAME] | 2 | 6 | 11 | 11 | 5 | 11 | 9 | 7 | 11 | 4 | 11 | 3 | [NAME]
 | 4) ENTER PLAYER 4 HERE | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 4) ENTER PLAYER 4 HERE
 | 5) ENTER PLAYER 5 HERE | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 5) ENTER PLAYER 5 HERE
 | MATCH RESULT
 | Brunel Univeristy 3rd Team |  |  |  |  | 0 | - | 3 | Brunel University 2nd Team
 |  |  |  |  | GAMES
 |  |  |  |  |  | 3 | - | 9
 |  |  |  |  |  | POINTS
 |  |  |  |  | 91 |  | - | 121
THIS RESULTS CARD MUST BE EMAILED TO [EMAIL] WITHIN 5 WORKING DAYS OF THE MATCH
 | MATCH RESULT |  | H | A
 | Match 1 |  | 0 | 1
 | Match 2 |  | 0 | 1
 | Match 3 |  | 0 | 1
 | Match 4 |  | 0 | 0
 | Match 5 |  | 0 | 0
 | GAMES
 |  | Game | 1 | 2 | 3 | 4 | 5 | Total Games
 | Match 1
 | H |  | 0 | 0 | 0 | 0 | 0 | 0
 | A |  | 1 | 1 | 1 | 0 | 0 | 3
 | Match 2
 | H |  | 0 | 1 | 0 | 0 | 0 | 1
 | A |  | 1 | 0 | 1 | 1 | 0 | 3
 | Match 3
 | H |  | 0 | 1 | 1 | 0 | 0 | 2
 | A |  | 1 | 0 | 0 | 1 | 1 | 3
 | Match 4
 | H |  | 0 | 0 | 0 | 0 | 0 | 0
 | A |  | 0 | 0 | 0 | 0 | 0 | 0
 | Match 5
 | H |  | 0 | 0 | 0 | 0 | 0 | 0
 | A |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 824399d1680543214-comparing-two-lists-with-multiple-columns-lists
Sheet: Sheet11

Table 1
Covo | [NAME] | V
Eastwood | [NAME] | v | 695-3297
Arcand | [NAME] | A | 695-2532
Beaulieu | Michel
Legault | [NAME]
Rozon | Gilles |  | 695-7565
Cross | [NAME] | X | 694-4865
Kelso | [NAME]
Du Preez | [NAME]
Arsenault | Stéphane | V | 697-7813
Legault | [NAME]
Table 2
Eastwood | [NAME]
Arsenault | Stéphane
Kelso | [NAME]
Legault | [NAME]
Mitchell | [NAME]
Arcand | [NAME]
Beaulieu | Michel
Rozon | Gilles
Cross | [NAME]
Du Preez | [NAME]
Covo | [NAME]
Chartrain | [NAME]
Legault | [NAME]
Spreadsheet: 221101d1363366484-how-to-sort-data-into-various-tables-and-lookup-matching-data-to-populate-rest-of-table-start-up-qualification-audit
Sheet: Sheet1

Date | Name | Sales | Code
Q1 2013/2014 | JBL | 500 | 856
Q4 2012/2014 | Andover | 250 | 350 |  |  |  |  |  | Bonus | 0.12
 |  |  |  |  |  |  |  |  | Minimum amount | 100000
 |  |  |  |  |  |  |  |  | Maximum amount | 200000
Sheet1 |  |  |  |  |  |  |  |  |  | Sales | Bonus
 |  |  |  |  |  |  |  |  | Salesman A | 87925
 | A | B | C | D | E | F |  |  | Salesman B | 100000
1 | Item | Value |  | Lookup | Count | Value |  |  | Salesman C | 145000
2 | A | 23 |  | X | 3 |  |  |  | Salesman D | 200750
3 | X | 34 |  |  |  | 89 |  |  | Salesman E | 178650
4 | C | 24 |  |  |  | 82 |  |  | Salesman F | 99555
5 | B | 64 |  |  |  |  |  |  | Salesman G | 147000
6 | X | 89 |  |  |  |  |  |  | Salesman H | 213450
7 | X | 82 |  |  |  |  |  |  | Salesman I | 122680
8 | A | 73 |  |  |  |  |  |  | Salesman J | 92500
9 | D | 97
10 | C | 97
You want to lookup all instances of X and return the corresponding values.
In the formulas I use the following defined named ranges:
Item
Refers to: =Sheet1!$A$2:$A$10
Value
Refers to: =Sheet1!$B:$B
Enter this formula in E2. This will return the count of records for the lookup value.
Enter this array formula** in F2. This will extract the corresponding data for the lookup value.
Copy down until you get blanks.
** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.
Spreadsheet: f92e6407-0c8f-4f62-a724-bc53d2e97cfb
Sheet: Sheet1

DAFTAR PESERTA PLPG RAYON 112 UNIVERSITAS NEGERI SEMARANG | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
TAHAP XIII GUGUS PATEMON
[NAME] Tanggal 27 Oktober - 5 Nopember 2011
Kelas | : [NAME]
No | No peserta | Nama | Sekolah | [NAME]
1 |  | BAMBANG HARIANTO | MTS HIDAYATUS SYUBBAN | KOTA SEMARANG
2 |  | WALINTO | MA FUTUHIYYAH KUDU | KOTA SEMARANG
3 |  | SUKAT | MA N 2 SEMARANG | KOTA SEMARANG
4 |  | YULIANA SURYANTI | MTS N BRANGSONG | KENDAL
5 |  | NASRON | MA N 2 SEMARANG | KOTA SEMARANG
6 |  | [NAME] | MA N 2 SEMARANG | KOTA SEMARANG
7 | 11032606220002 | KHOMSAH ROWIYANI | MTS N BUARAN PEKALONGAN | PEKALONGAN
8 |  | NURHADI | MA N 1 SEMARANG | KOTA SEMARANG
9 |  | [NAME] | MTS N KETANGGUNGAN | BREBES
10 |  | KARTINI | MTS NU SALATIGA | SALATIGA
11 |  | KHALIMAH | MTS NURUL ULUM JEMBAYAT | TEGAL
12 |  | MACHDUM | [NAME] | KOTA SEMARANG
13 |  | AHMAD TOIFURI | MI TARBIYATUS SHIBYAN | KOTA SEMARANG
14 | 11032606220018 | WINURSIH | MTS MA'ARIF KARANGANYAR | PEKALONGAN
15 | 11036502620014 | MU'MINAH | MTS RAUDHATUL ULUM | KOTA TEGAL
16 |  | MASDAR MASYUDI | MA HUSNUL KHATIMAH | KOTA SEMARANG
17 |  | [NAME] | MTS NU 24 DARUL ULUM PATEBON | KENDAL
18 |  | NUR ARINI | MTS FILIAL AL-IMAN | TEGAL
19 |  | AHMAD RODLOH | [NAME] | KOTA SEMARANG
20 |  | INNA MUFLIKHAH HIDAYATULLAH | MTS MUHAMMADIYAH  WANASARI | BREBES
21 |  | NURLAELATUL MISKIYAH | MI DARUSSALAM | TEGAL
22 |  | [NAME] | [NAME] GHOY | KOTA SEMARANG
23 |  | SYAMSUL ARIFIN | MA NURUSSALAM | KOTA SEMARANG
24 |  | [NAME] | MTS BABUSSALAM KEMAKMURAN | BREBES
25 |  | KAPSAH | MTS NU MIFTAHUL ULUM MARGASARI | TEGAL
26 |  | NGADINO | MTS ASWAJA | KAB SEMARANG
27 |  | HUDALLOH | MI INFARUL GHOY 01 | KOTA SEMARANG
28 |  | Giyanti, S.Pd | MI Sruwen IV | Kab. Semarang
29 |  | [NAME] | MTs SUNAN KALIJAGA | Kab. [NAME]
30 |  | DARYOTO | MTs AL HUDA REBAN | Kab. [NAME]
31 |  | Isyami | MI Ma'arif Rowosari | Kab. Semarang
32 |  | MUSTAIN | MTs HUSNUL KHATIMAH | KOTA SEMARANG
33 |  | Syarifah, S.Ag | MTs PSA Bustanul Muta'allimin | Kab. Semarang
34 |  | PATONI | MTs. SUDIRMAN KAWENGEN | Kab. Semarang
Spreadsheet: darrell_schoolcraft__7783__imbalsumm0107
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 |  |  |  |  | 1110 | 1243 | 1812 | 1669
2 |  |  |  |  | 1157 | 1277 | 1766 | 1699
3 |  |  |  |  | 1153 | 1277 | 1747 | 1699
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  |  |  |  |  |  |  | 351398
2001-07-03 00:00:00
Spreadsheet: 113500d1309377436-cannot-solve-vlookup-mid-function-problem-autodecode
Sheet: Flash Decode

Part # | [NAME]
Reference | Code | Description
1. Memory (K)
2. [NAME]
3. Small Classification
4~5. Density
6. Technology
7. Organization
8. Vcc
9. Mode
10. Generation
11. "─" |  | -
12. Package
13. Temp
14. [NAME]
15. Pre-Program Version
16. Packing Type
17~18. Customer "Customer List Reference"