tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 709040d1608138565-progress-bar-in-each-cell-based-on-values-progress-bar
Sheet: main

Serial Number | Date | Status | Progress bar
N119178025 |  | Wait for Dispatch to Service | 0
N119178081 |  | At Service for repair | 0.2
NL16362157 |  | In transit to Company | 0.5
NL16015026 |  | Wait for Dispatch to Client | 0.8
NL16089199 |  | Returned to client | 1
Spreadsheet: 482133d1474910630-how-to-pick-values-from-coumn-after-fulfilling-a-condition-book1
Sheet: Sheet1

Header | Value |  | Day
Sunday | -
Monday | B
Tuesday | -
Wednesday | -
Thursday | G
Friday | -
Saturday | A
Sunday | -
Monday | -
Tuesday | -
Wednesday | F
Thursday | -
Friday | -
Saturday | -
Spreadsheet: 755796d1637093103-formula-across-multiple-columns-example-customer-report
Sheet: Table1

Value
1234ABCD
1234ABC4
1234ABC5
1234ABC6
1234ABC7
1234ABC8
1234ABC9
1234ABC10
1234ABC11
1234ABC12
1234ABC13
1234ABC14
1234ABC15
1234ABC16
1234ABC17
1234ABC18
1234ABC19
1234ABC20
5432BCC1
5432BCC2
5432BCC3
5432BCC4
5432BCC5
5432BCC6
5432BCC7
5432BCC8
5432BCC9
5432BCC10
5432BCC11
5432BCC12
5432BCC13
5432BCC14
5432BCC15
5432BCC16
5432BCC17
5432BCC18
5432BCC19
5432BCC20
5432BCC21
5432BCC22
5432BCC23
5432BCC24
1234ABC21
1234ABC22
1234ABC23
1234ABC24
1234ABC25
1234ABC26
1234ABC27
Spreadsheet: 159758d1338835519-seperating-data-from-multiple-excel-sheets-schoolresources
Sheet: ContactList

School | HIV/AIDS Resource | HIV/AIDS Contact # | Sexual Minority Resource | Sexual Minority Contact #
School1
School2
School3
School4
Spreadsheet: 2d366a90-4a88-454a-ab15-62b113036c5b
Sheet: divisions

Voter | AFC East | AFC North | AFC South | AFC West | NFC East | NFC North | NFC South | NFC West | Average (should equal 16.5)
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Average
Rank
Spreadsheet: 146653d1332281679-help-with-chart-copy-of-profit-chart
Sheet: 2011

Profit Sharing % | 0.0363349323333517 | 0
Bonus % | 0.04458815267764159
Stockholders Investment | 50000
Adjusted Profits | 61866.17 | 17904.08 | 108327.52 | 57982.91 | 159435.81 | 67778.52 | 49746.98999999999 | 44000.90999999999 | 26593.57000000001 | 48486.85999999999 | 105229.41 | 47265.21000000001 | 29050.35000000001 | 87963.65000000001 | 14602.51999999999 | 134606.1 | 35460.25 | 111738.52 | 129963.46 | 236571.93 | -28223.14 | 100960.1 | -124647.86 | 8001.570000000116
 | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sept |  | Oct |  | Nov |  | Dec
 | 2011 | 2010 | 2011 | 2010 | 2011 | 2010 | 2011 | 2010 | 2011 | 2010 | 2011 | 2010 | 2011 | 2010 | 2011 | 2010 | 2011 | 2010 | 2011 | 2010 | 2011 | 2010 | 2011 | 2010
Profit Sharing | 2247.903100673633 | 650.5435352909155 | 3936.073109039804 | 2106.805111340822 | 5793.089367863118 | 2462.727937854725 | 1807.553515437923 | 1598.770087455898 | 966.2755664522521 | 1761.766777156697 | 3823.503491828522 | 1717.378207071658 | 1055.542501510184 | 3196.153270544633 | 530.5815760964146 | 4890.903535156372 | 1288.445784273735 | 4060.011563228865 | 4722.21352490826 | 8595.825068520415 | -1025.485882134712 | 3668.378401868421 | -4529.071558597097 | 290.7365045105812
Bonus | 2758.49823354093 | 798.3098525927093 | 4830.124000950274 | 2585.350843773952 | 7108.948238563456 | 3022.118998024584 | 2218.126385373109 | 1961.919293035166 | 1185.758159403549 | 2161.939516539432 | 4691.984999258144 | 2107.468399820792 | 1295.301441138926 | 3922.136656282628 | 651.0993912383144 | 6001.837338141891 | 1581.10704098734 | 4982.214189733708 | 5794.830596994565 | 10548.30533408434 | -1258.417675362453 | 4501.624353149963 | -5557.817812621294 | 356.7752248208418
TOTAL | 5006.401334214563 | 1448.853387883625 | 8766.197109990077 | 4692.155955114773 | 12902.03760642657 | 5484.846935879309 | 4025.679900811032 | 3560.689380491064 | 2152.033725855802 | 3923.706293696129 | 8515.488491086666 | 3824.846606892451 | 2350.84394264911 | 7118.28992682726 | 1181.680967334729 | 10892.74087329826 | 2869.552825261075 | 9042.225752962573 | 10517.04412190283 | 19144.13040260475 | -2283.903557497165 | 8170.002755018384 | -10086.88937121839 | 647.511729331423
Total adj profits
2011 | 567405.0499999999
2010 | 963260.36
 | 2011 | 2010
 | Total (trend) | Total
Profit Sharing | 20616.62409735204 | 35000
Bonus | 25299.54299946486 | 42950
*** Each month change formulas to remove one estimated
month & add once actual
Spreadsheet: 272859d1382534679-how-to-look-up-a-value-in-a-list-and-return-multiple-corresponding-values-multiple_corresponding_values-1-
Sheet: Orders

Client Name | Order date | order cost
[NAME] | 2013-12-12 00:00:00 | 1
[NAME] | 2013-12-13 00:00:00 | 2
[NAME] | 2013-12-14 00:00:00 | 3
[NAME] | 2013-12-15 00:00:00 | 4
[NAME] | 2013-12-16 00:00:00 | 5
[NAME] | 2013-12-17 00:00:00 | 6
[NAME] | 2013-12-18 00:00:00 | 7
[NAME] | 2013-12-19 00:00:00 | 8
[NAME] | 2013-12-20 00:00:00 | 9
[NAME] | 2013-12-21 00:00:00 | 10
[NAME] | 2013-12-22 00:00:00 | 11
[NAME] | 2013-12-23 00:00:00 | 12
[NAME] | 2013-12-24 00:00:00 | 13
Spreadsheet: 769126d1645323897-vlookup-with-variable-number-of-returned-data-help-post
Sheet: Sheet2

School Name | Location | Sem 1 | Sem 2 | # of Students | Date
[NAME] | East | 5 | 5 | 220 | 12/6/21 & 4/4/22
East Tipp Middle | West | 4 | 5 | 180 | 11/19/21 & 4/8/22
[NAME] | West | 3 | 3 | 140 | 12/7/21 & 4/5/22
Southwestern Middle | North | 6 | 0 | 160 | 11/16/21 & 11/17/21
St. [NAME] | North | 0 | 1 | 24 | 2022-05-06 00:00:00
Tecumseh Jr. High | West | 0 | 6 | 300 | 2022-05-06 00:00:00
Wainwright Middle | West | 2 | 2 | 80 | 12/9/21 & 3/31/22
[NAME] Middle | South | 4 | 5 | 270 | 12/2/21 & 4/14/2022
Spreadsheet: 273193d1382633541-excel-2007-simple-sumproduct-excruciatingly-slow-sample_sumproduct
Sheet: Sheet1

 |  |  |  | Can # | Qty | Size | M | T | W | H | F | Area | Remarks | M | T | W | Th | F | Total | Area
 |  |  |  | 7 | 1 | 8 | 1 |  |  |  |  | A | ALL
 |  |  |  | 7 | 1 | 8 |  | 1 |  |  |  | A | ALL
 |  |  |  | 7 | 1 | 8 |  |  | 1 |  |  | A | ALL |  |  |  |  |  |  | A
 |  |  |  | 7 | 1 | 8 |  |  |  | 1 |  | A | ALL |  |  |  |  |  |  | B
 |  |  |  | 7 | 1 | 8 |  |  |  |  | 1 | A | ALL |  |  |  |  |  |  | C
 |  |  |  | 58 | 1 | 8 |  |  |  |  | 1 | A | ALL |  |  |  |  |  |  | D
 |  |  |  | 100 | 1 | 8 |  |  |  | 1 |  | A | H |  |  |  |  |  |  | E
 |  |  |  | 38 | 2 | 8 | 1 |  |  |  |  | A | M-T-W-H |  |  |  |  |  |  | F
 |  |  |  | 38 | 2 | 8 |  | 1 |  |  |  | A | M-T-W-H |  |  |  |  |  |  | G
 |  |  |  | 38 | 2 | 8 |  |  | 1 |  |  | A | M-T-W-H |  |  |  |  |  |  | H
 |  |  |  | 101 | 1 | 8 |  |  |  | 1 |  | A | H
Spreadsheet: 156251d1337242406-one-lookup-value-multiple-matches-book1
Sheet: P2L Repairs (2)

Property ref | Job No/invoice no | Address 1 | City | Postcode | Job description | Job/Quote/other | Category | Boiler part replaced |  | Completed | Contractor | Date Completed | Materials | Time | Actual cost labour | Total cost | Sale labour | Sale Inc mat | Total Deduction | Profit | Paid/Deducted | [NAME]
52 | 1 |  |  |  | Gas certificate |  | Heating |  |  | Yes |  | 2012-01-10 00:00:00 |  |  |  |  |  |  | 55
53 | 2 |  |  |  | Fit laminate flooring |  | Flooring |  |  | Yes |  | 2012-01-15 00:00:00 |  |  |  |  |  |  | 200
54 | 3 |  |  |  | Faulty downstairs socket |  | Electrics |  |  | yes |  | 2012-02-20 00:00:00 |  |  |  |  |  |  | 30
55 | 4 |  |  |  | Inspect damp patch |  | Other |  |  | yes |  | 2012-02-23 00:00:00 |  |  |  |  |  |  | 25
55 | 5 |  |  |  | Fit new door |  | [NAME] |  |  | yes |  | 2012-03-01 00:00:00 |  |  |  |  |  |  | 75
52 | 6 |  |  |  | gas certifcate |  | Plumbing |  |  | Yes |  | 2012-03-10 00:00:00 |  |  |  |  |  |  | 55
53 | 7 |  |  |  | Decorate downstairs living room |  | Decoration |  |  | yes |  | 2012-04-01 00:00:00 |  |  |  |  |  |  | 150
54 | 8 |  |  |  | Replace leaking tap |  | Plumbing |  |  | yes |  | 2012-02-10 00:00:00 |  |  |  |  |  |  | 25
52 | 9 |  |  |  | Issue electrical certificate |  | Other |  |  | yes |  | 2012-05-01 00:00:00 |  |  |  |  |  |  | 150
55 | 10 |  |  |  | Replace front door |  | [NAME] |  |  | yes |  | 2012-04-10 00:00:00 |  |  |  |  |  | 50 | 75
Spreadsheet: e5160049-9599-4d17-adfe-6b63b49a5c16
Sheet: BP level 3

Biological Process GO term | Number of proteins
[NAME] process | 14779
cellular metabolic process | 14679
regulation of biological process | 13508
macromolecule metabolic process | 11876
nitrogen compound metabolic process | 9579
cellular response to stimulus | 7944
biosynthetic process | 7709
cell communication | 7564
multicellular organismal development | 7200
anatomical structure development | 7084
establishment of localization | 6040
cellular developmental process | 4968
small molecule metabolic process | 4536
response to chemical stimulus | 4387
response to stress | 4253
regulation of biological quality | 4108
organelle organization | 3906
catabolic process | 3724
regulation of molecular function | 3307
cellular localization | 3249
macromolecule localization | 2922
system process | 2826
cellular component assembly | 2641
cell death | 2625
cell cycle | 2577
response to external stimulus | 2202
cellular component movement | 2156
cell projection organization | 2011
macromolecular complex subunit organization | 1839
cell adhesion | 1709
cell-cell signaling | 1703
reproductive process | 1622
localization of cell | 1558
response to endogenous stimulus | 1434
protein complex biogenesis | 1331
oxidation-reduction process | 1264
cellular membrane organization | 1139
membrane organization | 1139
taxis | 1101
cell activation | 1083
cellular macromolecular complex subunit organization | 1039
immune response | 1029
cellular homeostasis | 1008
[NAME]-based process | 1006
response to abiotic stimulus | 1000
regulation of body fluid levels | 998
behavior | 898
coagulation | 884
multicellular organism reproduction | 873
microtubule-based process | 855
sexual reproduction | 753
[NAME] activation | 638
cell division | 602
response to biotic stimulus | 599
response to other organism | 560
developmental growth | 500
interspecies interaction between organisms | 466
organophosphate metabolic process | 448
cell junction organization | 438
cytokine production | 421
chromosome segregation | 365
ribonucleoprotein complex biogenesis | 358
epithelial cell proliferation | 347
cellular component disassembly | 336
viral reproductive process | 304
DNA conformation change | 280
aging | 272
developmental maturation | 267
extracellular structure organization | 265
hormone metabolic process | 253
Spreadsheet: 819649d1677611050-remove-characters-from-end-of-value-if-the-value-contains-a-particular-character-dlt
Sheet: Sheet1

3392-9 | 3392
393 | 393
299-410 | 299-410
2424 | 2424
2436-6 | 2436
50-440 | 50-440
504-41 | 504-41
60446 | 60446
7474-5 | 7474
9525 | 9525
3541-1 | 3541
Spreadsheet: 17d20ad7-f90d-4624-ac02-72dbe0905ea0
Sheet: Publish Potash

Potash
 |  |  |  |  | Q1 FY12 | Q2 FY12 | Q3 FY12 | Q4 FY12 | Q1 FY13 | Q2 FY13 | Q3 FY13 | Q4 FY13
 | Net Sales and Gross Margin (in millions, except per tonne)
 |  | Segment income statement
 |  |  | North America |  | 463.9 | 426.9 | 299.1 | 662.0000000000001 | 561 | 603 | 450.2 | 494
 |  |  | International |  | 409.1 | 411.7 | 254.1 | 374.5000000000001 | 398.5 | 177.2 | 307.8 | 537
 |  |  |  | Net Sales | 873 | 838.6 | 553 | 1037 | 960 | 780.1 | 758
 |  |  | Cost of Goods Sold |  | 428.6 | 444.9 | 283.4 | 523 | 501 | 425 | 449.6 | 542
 |  |  | Gross Margin |  |  |  |  |  |  |  | 308.4
 |  |  |  | As % of Sales |  |  |  |  |  |  | 0.4068601583113456
 |  |  | Resources Taxes |  | 80 | 50 | 48 | 80 | 70 | 67 | 41 | 72
 |  |  | Royalties |  | 16 | 17 | 17 | 20 | 12 | 15 | 14.8 | 16
 |  |  | Total Resources Taxes & Royalties |  |  |  |  |  |  |  | 55.8
 |  |  | Gross Margin (x Resources Taxes & Royalties)(g) |  |  |  |  |  |  |  | 364.2
 |  |  |  | As % of Sales |  |  |  |  |  |  | 0.4804749340369393
 |  |  | Operating Earnings |  | 402 | 357.8 | 233.9 | 464 | 416 | 315.6 | 216.1 | 444.9
 |  |  |  | As % of Sales |  |  |  |  |  |  | 0.2850923482849604
 | Cost of Goods Sold Detail (in millions)
 |  | COGS additional detail
 |  |  | Resource Taxes |  |  |  |  |  |  |  | 41
 |  |  | Royalties |  |  |  |  |  |  |  | 14.8
 |  |  | Brine Inflow Expenses |  | 39 | 45 | 59 | 63 | 67 | 60 | 55.3 | 54
 |  |  | MTM (gain)/loss |  | 8.5 | 15.1 | -4 | 18 | -34 | 2 | 24.1 | -6
 |  |  | DD&A |  | 53.2 | 54 | 58.3 | 68 | 65 | 72 | 77.1 | 87.79999999999998
 |  |  |  | Total costs |  |  |  |  |  |  | 212.3
 | Operating Data
 |  | Sales volumes ('000 tonnes)
 |  |  | Crop Nutrients North America(f) |  | 613 | 524.6 | 291 | 921 | 751 | 839 | 681 | 868
 |  |  | Crop Nutrients International(f) |  | 1043 | 1055 | 618 | 951 | 1020 | 487 | 927 | 1532
 |  |  | Non-Agricultural |  | 164 | 180.3 | 182 | 177 | 160 | 168 | 163 | 174
 |  |  | [NAME]) |  |  |  |  |  |  |  | 1771
 |  | Production [NAME] ('000 tonnes)
 |  |  | Production Volume |  | 1855 | 1805 | 1818 | 1944 | 1503 | 1764.769438724134 | 1985.353484954323 | 2514
 |  |  | Operating rate |  | 0.8062984285913043 | 0.78 | 0.79 | 0.85 | 0.65 |  | 0.7761350605763578
 |  | Realized prices (FOB plant, $/tonne)
 |  |  | MOP - North America crop nutrients(e)(h) |  | 520 | 533 | 531 | 498 | 479 | 472 | 434 | 414.85
 |  |  | MOP - International(e) |  | 400 | 393 | 411 | 403 | 404 | 352 | 325 | 327.54
 |  |  | MOP - Average(e) |  | 446 | 440 | 453 | 455 | 444 | 443 | 385 | 368
 |  | Potash CAPEX  ($ in millions) |  |  | 279 | 296 | 294 | 303 | 300 | 257 | 258 | 203
Spreadsheet: 182607d1348550198-highlite-next-schedule-column-in-week-table-based-on-service-date-service-schedule
Sheet: Sheet1

 |  |  |  | WEEK NUMBER
Vehicle Reg | SERVICE | Days | SCHEDULE START | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 2013-01-01 00:00:00
324561 | Monthly | 30 | 2012-01-02 00:00:00
324566 | Monthly | 30 | 2012-01-02 00:00:00
324571 | Bi-Monthly | 60 | 2012-01-03 00:00:00
324576 | Semi-Annual | 180 | 2012-01-03 00:00:00
324581 | Weekly | 7 | 2012-01-03 00:00:00
324586 | Weekly | 7 | 2012-01-03 00:00:00
324591 | Weekly | 7 | 2012-01-03 00:00:00
324596 | Weekly | 7 | 2012-01-03 00:00:00
324601 | Weekly | 7 | 2012-01-03 00:00:00
324606 | Yearly | 365 | 2012-01-01 00:00:00
324611 | Fortnightly | 14 | 2012-01-03 00:00:00
324616 | Quarterly | 90 | 2012-01-03 00:00:00
 |  |  |  | WEEK NUMBER
Vehicle Reg | SERVICE | Days | SCHEDULE START | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
324561 | Monthly | 30 | 2012-01-02 00:00:00
324566 | Monthly | 30 | 2012-01-02 00:00:00
324571 | Bi-Monthly | 60 | 2012-01-03 00:00:00
324576 | Semi-Annual | 180 | 2012-01-03 00:00:00
324581 | Weekly | 7 | 2012-01-03 00:00:00
324586 | Weekly | 7 | 2012-01-03 00:00:00
324591 | Weekly | 7 | 2012-01-03 00:00:00
324596 | Weekly | 7 | 2012-01-03 00:00:00
324601 | Weekly | 7 | 2012-01-03 00:00:00
324606 | Yearly | 365 | 2012-01-01 00:00:00
324611 | Fortnightly | 14 | 2012-01-03 00:00:00
324616 | Quarterly | 90 | 2012-01-03 00:00:00
Spreadsheet: 98644d1297507064-match-the-max-max-and-match
Sheet: Sheet1

Before |  | After
[NAME] | 99 | [NAME] | 99
[NAME] | 14 | [NAME] | 96
[NAME] | 52 | luke | 87
sahra | 48 | fred | 63
sean | 33 | [NAME] | 52
[NAME] | 25 | franky | 50
luke | 87 | sahra | 48
fred | 63 | neil | 45
ally | 11 | [NAME] | 41
claire | 5 | sean | 33
[NAME] | 41 | [NAME] | 25
[NAME] | 25 | [NAME] | 25
neil | 45 | [NAME] | 22
franky | 50 | [NAME] | 17
[NAME] | 96 | [NAME] | 14
[NAME] | 17 | ally | 11
[NAME] | 22 | claire | 5
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 12d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | - | 137393 | - | 52893
Cross-Currency Fixed-Fixed | - | 2174 | - | 2136
Cross-Currency Fixed-Float | - | 24818 | - | 19096
TOTAL | - | 164385 | - | 74125
Spreadsheet: kate_symes__18278__DJ Index 4-6_4-7
Sheet: Sheet1

Electricity Price Index Report
Rep. [NAME]: | 2001-04-06 00:00:00
Flow Date: | 4/6/01-4/7/01
From: | Enron Power Marketing Inc. - Kate Symes
Phone: | (800) 464-7486
Fax: | (503) 464-3740
To: | [NAME] or [NAME]
Phone: | (609) 520-4683 ([NAME])
Phone: | (609) 520-4663 (Earnest Onukogu)
Fax: | (609) 452-3531
COB
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 270 | 400
 | Firm Trades Purchases | 295 | 400
[NAME] | Firm Trades Sales | 210 | 400
 | Firm Trades Purchases | 210 | 200
MID COLUMBIA
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 289.0288713910761 | 6096
 | Firm Trades Purchases | 290 | 400
[NAME] | Firm Trades Sales | 229.0909090909091 | 2200
 | Firm Trades Purchases | #[NAME]! | 0
PALO VERDE
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 149.2857142857143 | 8400
 | Firm Trades Purchases | 184.03125 | 1280
[NAME] | Firm Trades Sales | 78.21428571428571 | 1400
 | Firm Trades Purchases | 85 | 400
MEAD
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 125 | 112
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 80 | 376
NP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 222.9326923076923 | 7380
 | Firm Trades Purchases | 255 | 800
[NAME] | Firm Trades Sales | 201 | 3800
 | Firm Trades Purchases | 198.5 | 400
SP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 175.3333333333333 | 1200
 | Firm Trades Purchases | 156.6214953271028 | 3424
[NAME] | Firm Trades Sales | 99.33333333333334 | 3600
 | Firm Trades Purchases | 99.44444444444444 | 864
Spreadsheet: c2d7d932-2dc7-4c4e-ae84-0a65c5ff363c
Sheet: Area 6

Location | Title | Name | Mobile | Address | CRCs | CRC Mobile
Area 6 | Area Manager | [NAME] | 07703 469 372 | 28 Beech Road
 |  |  |  | Harrogate
 |  |  |  | [NAME]
 |  |  |  | HG2 8EA
[NAME] | RDO | [NAME] | 07764 960 396 | Weetwood Pavilion | [NAME] | 07718 706548
 |  |  |  | Weetwood Sports Facility | [NAME] | 07718 706558
 |  |  |  | University of Leeds | [NAME] | 07715 856802
 |  |  |  | West Park Ring Road
 |  |  |  | Leeds LS16 5AU
East Yorkshire | RDO | [NAME] | 07764 960 401 | Sports & Fitness Centre | [NAME] | 07718 706554
 |  |  |  | University of Hull | [NAME] | 07718 706555
 |  |  |  | [NAME]
 |  |  |  | Hull HU6 7RX
[NAME] | RDO | [NAME] | 07764 960 376 | [NAME] | [NAME] | 07718 706556
 |  |  |  | Harrogate High School | Richie Young | 07718 706557
 |  |  |  | Ainsty Road | [NAME] | 07715 856700
 |  |  |  | Harrogate HG1 4AP
West Yorkshire | RDO | [NAME] | 07764 336 702 | Sports Services | [NAME] | 07718 706559
 |  |  |  | Shay Stadium | [NAME] | 07718 706560
 |  |  |  | Shaw Hill | [NAME] | 07718 706561
 |  |  |  | Halifax HX1 2YT
South Yorkshire | RDO | [NAME] | 07764 960 400 | [NAME] | [NAME] | 07718 706565
 |  |  |  | County Office | [NAME] | 07718 706566
 |  |  |  | Griffin House | Olly [NAME] | 07718 706567
 |  |  |  | 24 Station Road
 |  |  |  | Morley
 |  |  |  | Leeds LS27 8JW
[NAME] | RDO | [NAME] | 07711 185 219 | Rugby Union Development Office | [NAME] | 07718 706551
 |  |  |  | EIS Building | [NAME] | 07894 489095
 |  |  |  | Gateshead International Stadium | [NAME] | 07718 706552
 |  |  |  | Neilson Road
 |  |  |  | Gateshead
 |  |  |  | Tyne & Wear NE10 0EF
Northumberland | RDO | [NAME] | 07736 517 728 | Northumberland Rugby Office | [NAME] | 07718 706562
 |  |  |  | Druid Park | [NAME] | 07718 706563
 |  |  |  | Woolsington | [NAME] | 07718 706564
 |  |  |  | Newcastle NE13 8DF
Cumbria | RDO | [NAME] | 07711 901 374 | Lakes Colleges West Cumbria | [NAME] | 07718 706 568
 |  |  |  | [NAME] | [NAME] | 07545 921 474
 |  |  |  | Lillyhall | [NAME] | 07545 921 473
 |  |  |  | Workington
 |  |  |  | Cumbria CA14 4JN
Area 6 | URDO | [NAME] | 07894 489 755 | Rugby Football Union
 |  |  |  | Sports and Fitness Centre
 |  |  |  | University of Hull
 |  |  |  | [NAME]
 |  |  |  | Hull
 |  |  |  | HU6 7RX
Area 6 | WRDO | [NAME] | 07841 367 391 | 20 Grange Road
 |  |  |  | Bedale
 |  |  |  | [NAME]
 |  |  |  | DL8 2BE
Spreadsheet: 330480d1404759155-complex-comparison-of-columns-help-example-of-missing-data-on-table-4
Sheet: Tab3

Incident Number | tab1 row index | tab2 row index | Incident Number2 | Description | Priority | Created On | Status | Sold-To Party (00000001) | Team | VersionOne ID | Status3 | Owner
Spreadsheet: 676322d1588757584-bill-amount-automatically-changing-depending-on-which-month-year-selected-finances
Sheet: MonthsYears

Month | 4 or 5 Week Month | Year
January | 4 | 2020
February | 4 | 2021
March | 5 | 2022
April | 4
May | 4
June | 5
July | 4
August | 5
September | 4
October | 4
November | 5
December | 4
Spreadsheet: chris_dorland__1630__1999_equities
Sheet: 1999 Equity Trading

 | Bought | Sold | Price | Buy Cost | Sale Proceed | Gain/Loss | Commision
[NAME]
1999-08-24 00:00:00 | 250 |  | 21.5 |  |  |  | 50
1999-10-08 00:00:00 | 300 |  | 17.95 |  |  |  | 50
1999-11-18 00:00:00 |  | 550 | 19.3 |  |  |  | 62.5
1999-12-08 00:00:00 | 500 |  | 14.85 |  |  |  | 60
1999-12-14 00:00:00 | 500 |  | 15 |  |  |  | 60
1999-12-15 00:00:00 |  | 1000 | 15.9 |  |  |  | 85
[NAME] Exploration
1999-08-19 00:00:00 | 2500 |  | 1.85 |  |  |  | 85
1999-10-05 00:00:00 |  | 1000 | 2.4 |  |  |  | 65
1999-10-06 00:00:00 |  | 1500 | 2.2 |  |  |  | 80
Numac Energy
1999-08-17 00:00:00 | 1000 |  | 4.7 |  |  |  | 65
1999-08-24 00:00:00 |  | 1000 | 5.75 |  |  |  | 75
Velvet Exploration
1999-07-19 00:00:00 | 1000 |  | 4.4 |  |  |  | 168.4
1999-08-31 00:00:00 |  | 1000 | 5.5 |  |  |  | 75
Transalta 7.5% Perferred Shares
1999-05-05 00:00:00 | 691 |  | 25.2 |  |  |  | 85
1999-07-16 00:00:00 |  | 200 | 25.25 |  |  |  | 118.49
1999-08-17 00:00:00 |  | 491 | 25 |  |  |  | 64.46
Uniglobe Travel
1999-01-15 00:00:00 | 100 |  | 5.75 |  |  |  | 75
1999-01-15 00:00:00 | 50 |  | 5.85 |  |  |  | 0
1999-10-01 00:00:00 |  | 150 | 3.8 |  |  |  | 40
Ensign Resource Group
1999-11-03 00:00:00 | 200 |  | 30.4 |  |  |  | 47
1999-11-11 00:00:00 |  | 200 | 33 |  |  |  | 29
 |  |  |  | Total Gain Before Commision
 |  |  |  | Commision
 |  |  |  | Total Gain After Commision
Spreadsheet: 689401d1596378993-how-to-rank-three-columns-together-example-data
Sheet: Sheet1

Heat | Total cost | Total GWP | Rank
60.85525959367946 | 152.74930384 | 40.3447136874763
59.93372460496614 | 155.7130961650564 | 51.79482655429346
58.4565237020316 | 158.1414483095259 | 61.17541346174266
57.53372460496614 | 161.1052406345824 | 72.62552632855983
63.03620767494357 | 156.1748715972912 | 40.3447136874763
58.06121896162528 | 159.9811675879007 | 41.09482721451919
57.13932279909707 | 162.9449599129571 | 52.54494008133634
55.66212189616253 | 165.3733120574266 | 61.92552698878556
54.73914221218961 | 168.3371043824831 | 73.37563985560271
51.39142212189616 | 178.4584587842889 | 112.4770394041354
61.45932279909707 | 153.7096323992776 | 40.3447136874763
63.64045146726863 | 157.1352001565688 | 40.3447136874763
60.05905191873589 | 154.7766948554402 | 40.5550015853544
59.13643340857788 | 157.7404871804966 | 52.00511445217155
57.66013544018059 | 160.1688393249661 | 61.38570135962077
56.73625282167043 | 163.1326316500226 | 72.83581422643792
57.26483069977427 | 162.0085586033408 | 41.30511511239729
56.34257336343115 | 164.9723509283973 | 52.75522797921445
54.86573363431151 | 167.4007030728668 | 62.13581488666365
51.5203611738149 | 177.5220574746727 | 101.2372144351964
53.94148984198645 | 170.3644953979232 | 73.58592775348082
50.59250564334086 | 180.4858497997291 | 112.6873273020135
60.65390519187359 | 154.1362914741309 | 40.5550015853544
58.25498871331828 | 159.5284359436569 | 61.38570135962077
57.85968397291197 | 161.3681552220316 | 41.30511511239729
55.46040632054176 | 166.7602996915575 | 62.13581488666365
52.11539503386005 | 176.8816540933634 | 101.2372144351964
61.78943566591422 | 154.7075408568849 | 40.3447136874763
Spreadsheet: 143169d1330253873-margin-of-error-formula-t1
Sheet: Sheet1

Person | Within 24Hrs | Over 24Hrs | Over 48Hrs | Total | Within 1 Day | Within 3 Day
A |  | = | =
B |  | = | =
C |  |  | =
D |  | = | =
E |  | = | =
F |  | = | =
G |  | = | =
H
I |  | = | =
J |  | = | =