tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 376802d1423712381-sumif-for-multiple-criteria-criteria-ranges-and-sum-ranges-sample-book
Sheet: 1

1891300010 | 17343
1891300010 | 439
1891300012 | 292
1891300008 | 784
1891300012 | 1707
1891300014 | 19994
1891300019 | 261
1891300019 | 16666
1891300022 | 40
1891300023 | 3375
1891300023 | 937
1891300025 | 1875
1891300025 | 13125
1891300027 | 5000
1891300024 | 2200
1891300030 | 21250
1891300035 | 584
1891300028 | 70000
1891300028 | 25100
1891300028 | 4242
1891300036 | 625
1891300031 | 679
1891300041 | 1500
1891300042 | 2889
1891300044 | 1094
1891300053 | 509
1891300046 | 4807
1891300044 | 1016
1891300058 | 600
1891300054 | 40
1891300050 | 1050
1891300060 | 833
1891300060 | 791
1891300050 | 762
1891300050 | 4375
1891300050 | 354
1891300060 | 1770
1891300050 | 209
1891300050 | 42
1891300052 | 1434
1891300052 | 2645
1891300052 | 1216
1891300059 | 944
1891300064 | 1250
1891300064 | 28869
1891300064 | 28649
1891300064 | 11413
1891300064 | 15201
1891300064 | 1440
1891300064 | 1006
1891300064 | 7500
1891300067 | 495
1891300067 | 730
1891300087 | 1000
1891300072 | 833
1891300073 | 2115
1891300073 | 7708
1891300073 | 1000
1891300070 | 68
1891300073 | 26000
1891300089 | 1000
1891300090 | 937
1891300090 | 937
1891300090 | 937
1891300074 | 352
1891300074 | 1060
1891300074 | 794
1891300090 | 156
1891300080 | 405
1891300098 | 250
1891300092 | 1199
1891300098 | 13968
1891300103 | 1510
1891300099 | 83
1891300094 | 2039
1891300094 | 2462
1891300094 | 1313
1891300100 | 4375
1891300102 | 679
1891300102 | 412
1891300105 | 498
1891300105 | 1459
1891300116 | 42
1891300108 | 1407
1891300105 | 40
1891300105 | 1345
1891300110 | 619
1891300114 | 104
1891300111 | 375
1891300111 | 27
1891300111 | 312
1891300117 | 417
1891300115 | 2000
1891300115 | 375
1891300130 | 2500
1891300130 | 625
1891300118 | 3390
1891300118 | 712
1891300128 | 125
1891300120 | 1500
1891300120 | 2500
1891300131 | 1042
1891300131 | 1406
1891300129 | 4375
1891300129 | 2709
1891300129 | 2050
1891300129 | 1355
1891300129 | 1000
1891300132 | 10500
1891300132 | 3937
1891300132 | 1687
1891300122 | 4041
1891300122 | 801
1891300170 | 1224
1891300170 | 104
1891300171 | 834
1891300134 | 1406
1891300139 | 687
1891300138 | 1368
1891300140 | 2000
1891300141 | 50
1891300144 | 4062
1891300144 | 562
1891300145 | 625
1891300147 | 2500
1891300148 | 1750
1891300148 | 1250
1891300150 | 2000
1891300153 | 468
1891300156 | 1666
1891300157 | 28
1891300157 | 313
1891300158 | 1000
1891300158 | 887
1891300161 | 521
1891300166 | 1000
1891300167 | 166
1891300169 | 1145
1891300167 | 104
1891300169 | 1094
1891300168 | 1083
1891300167 | 7500
1891300169 | 312
1891300169 | 62
1891300172 | 2800
1891300173 | 1000
Spreadsheet: 132330d1323703424-how-to-access-information-from-a-table-copy-of-updated-pipe-pricing-1
Sheet: Sheet1

 |  | WATER PIPING
Material |  | [NAME]
Qty |  | Description |  | Mat. Price |  | Mat. Total
0
0 |  | 4"
0 |  | 3"
0 |  | 2 1/2"
0 |  | 2"
0 |  | 1 1/2"
0 |  | 1 1/4"
0 |  | 1"
0 |  | 3/4"
0 |  | 1/2"
Spreadsheet: 877584d1724390474-reverse-search-reverse-search
Sheet: Sheet1

Reverse Search
 |  |  |  |  |  |  |  |  | Expected Result
Outlet | Sau.24 | Vas.24 | Kov.24 | Bal.24 | Geg.24 |  | Top | Value | Outlet | Month
1 | 8632 | 1719 | 7166 | 8908 | 4673 |  | 1 | 9553 | 2 | Sau.24
2 | 9553 | 7818 | 7983 | 3247 | 3519 |  | 2 | 9111 | 4 | Vas.24
3 | 8039 | 8710 | 6913 | 5827 | 5868 |  | 3 | 8908 | 1 | Bal.24
4 | 4043 | 9111 | 6654 | 4104 | 4122
5 | 1096 | 5074 | 8876 | 1657 | 6644
Spreadsheet: 698172d1601826521-vlookup-with-rank-and-if-tournament
Sheet: 2

[NAME]: |  |  |  |  |  |  | Voor:
Raja paar |  | Mängijate nimed |  |  |  |  |  | [NAME]
13-14 | 1
 | 2
 | 3
11-12 | 1
 | 2
 | 3
9-10 | 1
 | 2
 | 3
11-12 | 1
 | 2
 | 3
14-13 | 1
 | 2
 | 3
 |  | [NAME] tulemus:
 |  | HCP
 |  | [NAME]:
 |  | [NAME]
 |  | V/punkt
[NAME]: |  | _____________________ |  | [NAME]: | ___________________________
Spreadsheet: 1864bfd3-b049-497a-8e01-506ac958f24c
Sheet: Sheet1

State of New Hampshire - General Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | State Senate District 2
2012-11-06 00:00:00 | [NAME], r | [NAME], Jr., d | [NAME]
[NAME] | 476 | 383
Ashland | 562 | 494 | 2
Bridgewater | 353 | 287
Bristol | 882 | 652 | 1
Campton | 871 | 858 | 3
Center Harbor | 442 | 236
Danbury | 317 | 286
Dorchester | 123 | 72
Ellsworth | 30 | 22
[NAME] | 346 | 282 | 4
[NAME] | 169 | 115
Haverhill | 1233 | 641 | 1
Hebron | 232 | 137
Hill | 292 | 222 | 2
Holderness | 596 | 636 | 1
Meredith | 2342 | 1453 | 2
New Hampton | 671 | 555
Orange | 83 | 87
Orford | 293 | 383 | 1
Piermont | 205 | 201 | 1
Plymouth | 1192 | 1949 | 8
Rumney | 467 | 356
Sanbornton | 921 | 764 | 3
[NAME] | 898 | 834 | 3
[NAME] | 264 | 167
Wentworth | 309 | 178 | 1
Wilmot | 374 | 430
Totals | 14943 | 12680 | 33
Spreadsheet: 3acd49a4-fc30-4698-85de-ff7dd0c856c1
Sheet: Mergent

Mergent
2010-2011
COUNTER-Compliant?: | No
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | Total | 2010-2011 Price | Price per unit
MergentOnline
Logins | 11 | 17 | 25 | 27 | 69 | 58 | 14 | 31 | 73 | 84 | 46 | 17
Searched | 42 | 38 | 48 | 47 | 163 | 90 | 38 | 128 | 393 | 249 | 139 | 87 |  | 0
Companies Viewed | 21 | 7 | 21 | 28 | 95 | 69 | 6 | 34 | 186 | 1624 | 124 | 39 |  | 0
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | Total | 2010-2011 Price | Price per unit
Mergent WebReports
Logins | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Searched | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |  | 1000 | N/A
Companies Viewed | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |  |  | N/A
Time in database | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | —
Mergent WebReports purchased 4/2010.
Spreadsheet: 373109d1422327198-remove-blanks-from-a-list-and-sort-automatically-tlist
Sheet: Raw

Associate | Title | Supervisor | Helper
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
Britney Chitwood | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
Terrence Reese | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] May | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Market Supervisor | [NAME]
[NAME] | Market Supervisor | [NAME]
[NAME] | Assistant Manager | [NAME]
[NAME] | Market Supervisor | [NAME]
[NAME] | Manager | [NAME]
[NAME] | Assistant Manager | [NAME]
[NAME] | Market Supervisor | [NAME]
[NAME] | Market Supervisor | [NAME]
[NAME] | Market Supervisor | [NAME]
Kermit Frog | Manager | [NAME]
Spreadsheet: 472726d1469717006-employee-attendance-tracker-viewing-all-together-on-a-year-calendar-copy-of-employee-attendance-tracker1
Sheet: Calendar View

 | EMPLOYEE ATTENDANCE RECORD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select an Employee: |  |  |  |  |  |  |  |  | Employee 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select a Year: |  |  |  |  |  |  |  |  | 2017
 |  |  |  |  |  |  | Su | M | T | W | T | F | S | Su | M | T | W | T | F | S | Su | M | T | W | T | F | S | Su | M | T | W | T | F | S | Su | M | T | W | T | F | S | Su | M | T | W | T | F | S
 |  | KEY STATISTICS
 |  |  | Days on Leave |  |  |  |  |  |  |  | Working Days |  |  |  |  |  |  |  | # of Days Sick |  |  |  |  |  |  | on Annual |  |  |  |  |  |  |  | on Bereavement |  |  |  |  |  |  |  | on Compassionate |  |  |  |  |  |  |  | on Study/Workshop
Spreadsheet: 676877d1589033060-vlookup-with-wildcard-not-working-help2
Sheet: Sheet1

 |  | I want Key word (reference table) to lookup Description in Table 1 checking if value either column B or C.
 |  | e.g. Tesco is in two places but is defined by revenue or cost Coolum
TABLE 1:     EXACT NAME |  |  |  |  |  |  |  | REFERENCE
[NAME] | revenue | cost | [NAME] revenue | [NAME] in |  |  |  | KEY | [NAME]
Toolstation |  | 50 |  |  |  |  |  | Toolstation | repairs
Gym Group |  | 60 |  |  |  |  |  | Screwfix | repairs
Tesco |  | 10 |  |  |  |  |  | Gym Group | workout
Screwfix |  | 10 |  |  |  |  |  | Tesco | food
wages Tesco | 5 |  |  |  |  |  |  | wage Tesco | wages1
wages screwfix | 10 |  |  |  |  |  |  | wages screwfix | wages2
www.screwfix.com |  | 15
Spreadsheet: louise_kitchen__22842__Hot List Update 06-18-01
Sheet: Compression +50

Deal Description Sheet - 06/18/01
Compression Services
YTD P&L | 4304000
Project Name | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
Oakhill | [NAME] | 7,000 HP retrofit. | $1.00 MM | 2001-06-15 00:00:00 | 0.75 | 2001-06-01 00:00:00 | Working with customer and Rusk County Co-Op to finalize deal.
Project Seebreeze Phase II A | Duke Field Services (El Paso-Matagorda Plant) | Duke upfront payment for connection of El Paso Matagorda plant to system. | $1.00 MM | 2001-06-01 00:00:00 | 0.75 | 2001-07-01 00:00:00 | Transaction closure upon delivery of El Paso contract.  [NAME] proposal currently under consideration by El Paso.
Bay Gas | Bay Gas Storage Co. | 13,000 HP storage facility expansion. | $1.20 MM | 2001-06-05 00:00:00 | 0.5 | 2001-08-01 00:00:00 | Notional pricing for gas w/parking provision received.  Conf. With customer regarding parking was positive but not confirmed.  Proposal adjustment for tiered heat rates, on/int/off peak & a reduced annual charge.
[NAME] | Duke Energy Field Services | 20,000 HP NGL processing plant retrofit. | $0.81 MM | 2001-06-06 00:00:00 | 0.5 | 2001-08-01 00:00:00 | Met with Duke on 6/6 and presented additional options.  Gathering additional information for detailed proposal.
Carthage | Anadarko | 12,000 HP Compression Station | $500 M (early) | 2001-06-04 00:00:00 | 0.5 | 2001-08-01 00:00:00 | Met with customer on 6/4 and presented initial proposal.  Waiting for customer feedback.
Nicor | Nicor | 22,000 - 72,000 HP replacement project. | $2.50 MM | 2001-06-12 00:00:00 | 0.5 | 2001-10-01 00:00:00 | Met with Nicor on 6/12 and laid out forward plan to finalize scope definition and deal structure requirements.  Planning on submitting detailed proposal by 7/31.
JM Huber | JM Huber | Producer asset/HP outsourcing deal. | $0.50 MM | 2001-06-05 00:00:00 | 0.5 | 2001-10-01 00:00:00 | Held initial data gathering meeting on 5/31.  Developing proposal.
Eastchester Phase II | Iroquois Gas Pipeline | 4,000 HP grass roots expansion. | $1.00 MM | 2001-05-11 00:00:00 | 0.5 | 2001-11-01 00:00:00 | Met with Iroquois on 5/11.  Customer is waiting on FERC approval by the end of summer.
Stagecoach | Tennessee Gas Pipeline (EPG) | 14,000 HP expansion of Tennessee 300 line. | $0.98 MM | 2001-06-14 00:00:00 | 0.75 | 2001-12-01 00:00:00 | FERC certificate not accepted.  EPG to refile in August/September pending new open season for transport.
Project Seebreeze Phase III | TBD | Final monetization of Enron position. | $3.00 MM | N/A | 0.5 | 2001-12-01 00:00:00 | Working market and awaiting initial [NAME] production.  Will develop Information Memorandum for sale to appropriate counterparties by 10/1/01.
Southern Trails | Questar Pipeline Co. | 6,000 HP Beaumont Station | $0.50 MM | 2001-06-13 00:00:00 | 0.5 | 2001-12-01 00:00:00 | Met with customer on 6/13 to present proposal and scenarios.
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Jim Condon

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Disagree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
No response
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 500A [NAME] | State Rep | Yes
Spreadsheet: 700261d1603104968-total-of-quantities-for-unique-parts-that-repeat-at-random-totals-where-unique
Sheet: Sheet1

Part | Qty |  | Totals |  |  | What I would like to be output | Part | qty
e | 6 |  |  |  |  | Unique parts (ignore case) | a | 142
f | 25 |  |  |  |  | and the corresponding | b | 27
a | 21 |  |  |  |  | total quantities of each | c | 13
e | 22 |  |  |  |  |  | d | 7
a | 21 |  |  |  |  |  | e | 36
f | 11 |  |  |  |  |  | f | 59
f | 15
c | 13
b | 3
c | 23
f | 8 |  |  |  |  |  | Ignore that
a | 15
c | 21
b | 17
e | 8
b | 7
c | 9
a | 9
c | 22
a | 20
A | 17
a | 8
A | 4
d | 7
a | 4
A | 23
c | 6
Spreadsheet: 164554d1340809501-formula-for-countif-40-of-balance-has-been-paid-2007-book1
Sheet: Sheet1

Balance At Assign | Current Balance
8144.58 | 8144.58
3960.85 | 1370.85
1254.85 | 1254.85
30304.82 | 18216.82
7779.35 | 6777.95
39244.99 | 39344.99
1352.72 | 1352.72
3877.71 | 2804.57
337.85 | 337.85
8885.43 | 5853.43
11621.33 | 8543.86
5202.06 | 4822.68
1684.26 | 555.66
3055.08 | 1521.54
8429.14 | 8429.14
2883 | 2883
9729.29 | 323.52
2459.16 | 2459.16
2360.32 | 2360.32
8570.89 | 7070.89
8727.16 | 8441.16
8349.87 | 2496.87
28683.99 | 13335.88
3121.43 | 3121.43
3321.43 | 1421.43
3203.57 | 203.57
606.04 | 0
2677.75 | 2677.75
11604.38 | 3509.48
1302.64 | 775.64
3135.59 | 3135.59
9571.6 | -173.84
5698.83 | 4611.83
Spreadsheet: 267285d1380034864-is-there-a-way-to-make-a-data-entry-form-by-using-the-worksheet-as-the-form-data-entry-form
Sheet: Data Entry Form

 | Client Action Update Form
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Once Only Entries (But Editable when Client No. Is Entered as a Start Point)
 | Name |  | [NAME] |  |  |  | Client No. |  | 123456 |  | Date Of Birth |  | 1984-12-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Requirement | Attended
 | Appointment Type |  | Induction |  |  |  | Contact No 1 |  | 07984 821 458 |  | Contact No 2 |  | 01958 879 568 |  |  | Client No. | Job Start
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date of Birth | Job Start Letter
 | Date |  | 2013-09-24 00:00:00 |  |  |  | Client Form |  | Yes |  | Client Form Signed |  | Yes |  |  | Contact No 1 | Client Form Signed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contact No 2 | [NAME]
 | Time |  | 15.39 |  |  |  | [NAME] |  | Yes |  | Spec Letter |  | No |  |  | Client Form | Spec Letter
 | Attended |  | Yes |  |  |  | Job Start |  | Yes |  | Job Start Letter |  | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Available to Every Time an Event is Recorded By the User
 | Requirement |  | funding for web design course |  |  |  |  |  |  |  |  |  |  |  |  | Name | Meeting Notes 1, 2 & 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | Advisor Action 1, 2 & 3
 | Next Appointment Date |  | 2013-10-05 00:00:00
 | Next Appointment Time |  | 13.3
 | Next Appointment Type |  | One To One
 | Meeting Notes 1 |  | [NAME] has come to centre to request funding for a web design course to go self - employed |  |  |  |  |  |  |  |  |  |  |  |  | Time | Client Action 1, 2 & 3
 | Meeting Notes 2 |  | [NAME] has previously worked as a computer technician and wants to change careers.
 | Meeting Notes 3 |  | [NAME] has HNC in computer design. |  |  |  |  |  |  |  |  |  |  |  |  | Appointment Types that can Be entered
 | Advisor Action 1 |  | Send funding request |  |  |  | Client Action 1 |  | Update CV at next appointment |  |  |  |  |  |  | Induction | Failed To Attend
 | Advisor Action 2 |  | Find Web Design Courses |  |  |  | Client Action 2 |  | Look for work within the chosen sector |  |  |  |  |  |  | One To One | Informal
 | Advisor Action 3 |  |  |  |  |  | Client Action 3 |  |  |  |  |  |  |  |  | Exited | In work
Spreadsheet: 845587d1697036014-group-and-increment-avoiding-duplications-seq1
Sheet: Sheet1

VARIATION 1
 | Cust1 | Cust2 | Cust3 | Cust4 | Cust5 | SEQUENCE
Grp1 | X |  | X
[NAME] |  | X
Grp3 | X |  |  | X
Grp4 |  |  |  | X
Grp5 |  |  |  |  | X
Grp6 |  |  | X |  | X
Grp7 | X |  |  | X | X
Grp8 | X
Grp9 |  | X | X
[NAME] | X |  | X | X
Spreadsheet: 01ba546c-3082-4910-b5d1-aa4aa9761cb4
Sheet: Sheet1

Count Week Waiver Request Form
District Name
County
District IRN
Contact Person Name
Contact Person Phone
Contact Person E-mail
Date(s) not in Session
Count Week Conflict Type (A-E; see notes below)
Description
If NOT all buildings: Enter building IRNs
Alternate Week Requested
Summary:
Additional Explanatory Information
***By requesting this waiver, the school district agrees that students reported by more than one district will count only where they are reported during the normal October count week. ***
Notes:
Count Week Conflict Types/descriptions:
A: Religious holiday observance -- description should include name of holiday.
B: Community event -- [NAME] -- description should include name of event and number of years observed.
C: Year Round School -- description should include IRN numbers of schools not in session. Also, attach an electronic copy of the school's calendar.
D: Calamity Day during Count Week -- description should include type of calamity (power outage, flood, etc.)
E: Other -- Description should include brief summary of conflict. Additional Explanatory Information cell should include more detailed information. See instructions for supplemental information required.
Alternative Week Selection
The district must choose the first week prior to the true count week for which the district is in session for five days. Please provide an explanation if it is not the proceeding week.
Spreadsheet: 66058d1266716550-calculate-number-of-business-days-between-two-dates-and-allocate-them-across-week-end-daterange
Sheet: Sheet1

Task Start Date | Task Due Date |  | 2010-02-05 00:00:00 | 2010-02-12 00:00:00 | 2010-02-19 00:00:00 | 2010-02-26 00:00:00 | 2010-03-05 00:00:00 | 2010-03-12 00:00:00 | 2010-03-19 00:00:00 | 2010-03-26 00:00:00 | 2010-04-02 00:00:00 | 2010-04-09 00:00:00 | 2010-04-16 00:00:00 | 2010-04-23 00:00:00 | 2010-04-30 00:00:00 | 2010-05-07 00:00:00 | 2010-05-14 00:00:00 | 2010-05-21 00:00:00 | 2010-05-28 00:00:00 | 2010-06-04 00:00:00 | 2010-06-11 00:00:00 | 2010-06-18 00:00:00 | 2010-06-25 00:00:00 | 2010-07-02 00:00:00 | 2010-07-09 00:00:00 | 2010-07-16 00:00:00 | 2010-07-23 00:00:00 | 2010-07-30 00:00:00 | 2010-08-06 00:00:00 | 2010-08-13 00:00:00 | 2010-08-20 00:00:00 | 2010-08-27 00:00:00 | 2010-09-03 00:00:00 | 2010-09-10 00:00:00 | 2010-09-17 00:00:00 | 2010-09-24 00:00:00 | 2010-10-01 00:00:00 | 2010-10-08 00:00:00 | 2010-10-15 00:00:00 | 2010-10-22 00:00:00 | 2010-10-29 00:00:00 | 2010-11-05 00:00:00 | 2010-11-12 00:00:00 | 2010-11-19 00:00:00 | 2010-11-26 00:00:00 | 2010-12-03 00:00:00 | 2010-12-10 00:00:00 | 2010-12-17 00:00:00 | 2010-12-24 00:00:00 | 2010-12-31 00:00:00 | 2011-01-07 00:00:00
2010-02-01 00:00:00 | 2010-02-10 00:00:00 |  | 5 | 3 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-02-11 00:00:00 | 2010-03-10 00:00:00 |  |  | 2 | 5 | 5 | 5 | 3 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-02-11 00:00:00 | 2010-03-10 00:00:00 |  |  | 2 | 5 | 5 | 5 | 3 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-11 00:00:00 | 2010-03-17 00:00:00 |  |  |  |  |  |  | 2 | 3 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-11 00:00:00 | 2010-03-17 00:00:00 |  |  |  |  |  |  | 2 | 3 | 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 | 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 | 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 | 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 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 8a456900-77b5-4930-82c2-868634691e36
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 |  |  | Table 10: Number & rates of syphilis diagnoses
 |  |  | in England, 2002 - 2011
 |  |  | Data are presented by gender & age group
 |  |  | Data type: service data
 |  | Data type:
 |  | Service data: | Data represent STI diagnoses among people accessing services located in England
 |  |  | i.e. data may include people who are resident in England, Wales, Scotland,
 |  |  | Northern Ireland or abroad
 |  | Contents:
 |  | Information
 |  | Notes: | Information detailing the contents of the data presented
 |  | STI Code Groups: | Definitions of STI conditions presented
 |  | GUMCAD Submissions: | GUMCAD data availability for 2011
 |  | Data
 |  | Syphilis: | Diagnosis numbers & rates by gender & age group
 |  | Data supplied by:
 |  | Health Protection Agency
 |  | Genito-urinary medicine clinic activity dataset (GUMCAD)
 |  | Data prepared by:
 |  | HIV and Sexually Transmitted Infections Department
 |  | Health Protection Agency
 |  | Health Protection Services Colindale
 |  | 61 Colindale Avenue
 |  | London
 |  | NW9 5EQ
 |  | Tel: 020-8200-6868
 |  | [NAME]: hiv/[EMAIL]
 |  | Website: www.hpa.org.uk