tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 163757d1340443943-excel-2007-different-rate-drop-from-same-drop-down-menu-rate-drops
Sheet: Sheet1

 |  |  | Amount |  |  |  |  |  |  |  |  | january | february | march | april | may
 |  | january | 250000 |  |  |  |  |  |  |  | Company A | 0.001 | 0.00055 | 0.00055 | 0.001 | 0.0013
 |  |  | 50000 |  |  |  |  |  |  |  | Company B | 0.00075 | 0.00075 | 0.00075 | 0.00075 | 0.00075
 |  |  |  |  |  |  |  |  |  |  | Company C | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 0.0002
 |  |  |  |  |  |  |  |  |  |  | Company D | 5e-05 | 5e-05 | 5e-05 | 5e-05 | 5e-05
Company Name | Y/N |  |  |  |  |  |  |  |  |  | Company E | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 0.0002
 |  |  | RATE % |  |  |  |  |  |  |  | Company F | 5e-05 | 5e-05 | 5e-05 | 5e-05 | 5e-05
Company A | Y |  |  |  |  |  |  |  |  |  | Company G | 0.0015 | 0.0015 | 0.0015 | 0.0015 | 0.002
Company B | Y |  |  |  |  |  |  |  |  |  | Company H | 0.0015 | 0.0015 | 0.0015 | 0.0015 | 0.002
Company C | Y |  |  |  |  |  |  |  |  |  | Company I | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 0.0001
Company D | Y |  |  |  |  |  |  |  |  |  | Company J | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 0.0001
Company E | Y |  |  |  |  |  |  |  |  |  | Company K | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 0.0001
Company F | Y |  |  |  |  |  |  |  |  |  | Company L | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 0.0001
Company G | Y |  |  |  |  |  |  |  |  |  | Company M | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 0.0002
Company H | Y |  |  |  |  |  |  |  |  |  | Company N | 0.05 | 0.04 | 0.04 | 0.05 | 0.06
Company I | Y |  |  |  |  |  |  |  |  |  | Company O | 0.002 | 0.002 | 0.002 | 0.002 | 0.002
Company J | Y |  |  |  |  |  |  |  |  |  | Company P | 0.0005 | 0.0005 | 0.0005 | 0.0005 | 0.0005
Company K | Y |  |  |  |  |  |  |  |  |  | Company Q | 0.00625 | 0.00625 | 0.00625 | 0.00625 | 0.00625
Company L | Y |  |  |  |  |  |  |  |  |  | Company R | 0.00375 | 0.00375 | 0.00375 | 0.00375 | 0.00375
Company M | Y |  |  |  |  |  |  |  |  |  | Company S | 0.05 | 0.03 | 0.03 | 0.05 | 0.05
Company N | Y |  |  |  |  |  |  |  |  |  | Company T | 0.01 | 0.01 | 0.01 | 0.01 | 0.01
Company O | Y |  |  |  |  |  |  |  |  |  | Company U | 0.01 | 0.01 | 0.01 | 0.01 | 0.01
Company P | Y
Company Q | Y |  |  |  |  |  |  |  |  |  |  | 101 | 106 | 101 | 102 | 109
Company R | Y |  |  |  |  |  |  |  |  |  |  | 102 | 107 | 102 | 106 | 110
Company S | Y |  |  |  |  |  |  |  |  |  |  | 103 | 110 | 103 | 109 | 111
Company T | Y |  |  |  |  |  |  |  |  |  |  | 104 | 113 | 112 | 113 | 112
Company U | Y |  |  |  |  |  |  |  |  |  |  |  |  |  | 115 | 113
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 114
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115
 |  |  |  |  |  |  |  |  |  |  |  | Y
 |  |  |  |  |  |  |  |  |  |  |  | N
Spreadsheet: 187416d1350453517-help-with-look-up-functions-example17th
Sheet: SUMMARY

Number | Sheet# | Sheet Name | Box Number |  |  |  |  |  |  |  |  |  |  | 1
982
860
9
291
Spreadsheet: 691065d1597429922-out-of-stock-date-out-of-stock-date-etaf
Sheet: Sheet1

Out of Stock Date
SKU | Quantity | Date of Purchase | Rate of Sale (per month) | Out of Stock Date
123456 | 100 | 2020-07-01 00:00:00 | 5
1973251 | 50 | 2020-08-01 00:00:00 | 10
111111 | 75 | 2020-06-13 00:00:00 | 3
 | 10 | 2020-01-01 00:00:00 | 5
 |  |  | so will only last 2 months | sold In Jan & Feb - so what do you want to show - [NAME] ?
 |  |  | If you want to put the 1st of the month - change DAY(C5) to DAY(1)
 |  | You could use EOMONTH()
Spreadsheet: 175696d1345620770-data-validation-query-data-validation-query
Sheet: Data

Customer | DRAFT PLAN |  | FIRST PLAN |  | FINAL PLAN |  |  | DRAFT PLAN |  |  | To insert drop down menu
 | 2012-01-12 00:00:00 | 2012-02-12 00:00:00 | 2012-01-12 00:00:00 | 2012-02-12 00:00:00 | 2012-01-12 00:00:00 | 2012-02-12 00:00:00 |  | 2012-02-12 00:00:00 |  |  | DRAFT PLAN
A | 100 | 325 | 789 | 123 | 789 | 1234 |  | 325 |  |  | FIRST PLAN
B | 200 | 2134 | 456 | 456 | 4657 | 123 |  | 2134 |  |  | FINAL PLAN
C | 250 | 125 | 215 | 1325 | 564 | 132 |  | 125
D | 789 | 2564 | 1254 | 235 | 1325 | 456 |  | 2564
 |  |  |  |  |  |  |  |  |  |  | 2012-01-12 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2012-02-12 00:00:00
Spreadsheet: 125757d1319209774-is-there-an-easy-way-to-modify-an-excel-database-supplied-database
Sheet: Recovered_Sheet1

business name
555 smith street
SASKATOON
business name
555 smith street
REGINA
business name
555 smith street
[NAME]
business name
555 smith street
SASKATOON
business name
555 smith street
PLEASANTDALE
business name
555 smith street
SASKATOON
business name
555 smith street
REGINA
business name
555 smith street
[NAME]
business name
555 smith street
SASKATOON
business name
555 smith street
PLEASANTDALE
business name
555 smith street
SASKATOON
business name
555 smith street
REGINA
business name
555 smith street
[NAME]
business name
555 smith street
SASKATOON
business name
555 smith street
PLEASANTDALE
other fax [PHONE]
other fax [PHONE]
[NAME]
Accounts Payable contact [NAME]
Spreadsheet: 799260d1665006823-power-query-pivot-and-combine-unique-text-m_0301-general-eq-list_10-04-2022
Sheet: Sheet4

Row Labels | Count of InventoryGroup |  | Row Labels | Count of DWG Number
Air Cooled Exchanger | 4 |  | Air Cooled Exchanger | 4
3650.289.03 | 1 |  | 3650.289.03 | 1
5541.289.03 | 1 |  | 5541.289.03 | 1
5645.289.03 | 1 |  | 5645.289.03 | 1
6896.289.03 | 1 |  | 6896.289.03 | 1
Channel - of S/T Exch | 22 |  | Channel - of S/T Exch | 22
3640.289.03 | 1 |  | 3640.289.03 | 1
3641.289.03 | 1 |  | 3641.289.03 | 1
3642.289.03 | 1 |  | 3642.289.03 | 1
3651.289.03 | 1 |  | 3651.289.03 | 1
3652.289.03 | 1 |  | 3652.289.03 | 1
3653.289.03 | 1 |  | 3653.289.03 | 1
3654.289.03 | 1 |  | 3654.289.03 | 1
3655.289.03 | 1 |  | 3655.289.03 | 1
3663.289.03 | 1 |  | 3663.289.03 | 1
3664.289.03 | 1 |  | 3664.289.03 | 1
3666.289.03 | 1 |  | 3666.289.03 | 1
5535.289.03 | 1 |  | 5535.289.03 | 1
5536.289.03 | 1 |  | 5536.289.03 | 1
5538.289.03 | 1 |  | 5538.289.03 | 1
5539.289.03 | 1 |  | 5539.289.03 | 1
6857.289.03 | 1 |  | 6857.289.03 | 1
6858.289.03 | 1 |  | 6858.289.03 | 1
6859.289.03 | 1 |  | 6859.289.03 | 1
7002.289.03 | 1 |  | 7002.289.03 | 1
RPV-3644 | 1 |  | RPV-3644 | 1
(blank) | 2 |  | (blank) | 2
Column | 7 |  | Column | 7
3600.289.01 | 1 |  | 3600.289.01 | 1
3601.289.01 | 1 |  | 3601.289.01 | 1
3603.289.01 | 1 |  | 3603.289.01 | 1
3604.289.01 | 1 |  | 3604.289.01 | 1
3605.289.02 | 1 |  | 3605.289.02 | 1
3606.289.02 | 1 |  | 3606.289.02 | 1
6233.289.01 | 1 |  | 6233.289.01 | 1
Pressure Vessel | 7 |  | Pressure Vessel | 7
3610.289.02 | 1 |  | 3610.289.02 | 1
3611.289.03 | 1 |  | 3611.289.03 | 1
3614.289.02 | 1 |  | 3614.289.02 | 1
3615.289.02 | 1 |  | 3615.289.02 | 1
3617.289.02 | 1 |  | 3617.289.02 | 1
5649.289.03 | 1 |  | 5649.289.03 | 1
7119.289.03 | 1 |  | 7119.289.03 | 1
Shell - of S/T Exch | 22 |  | Shell - of S/T Exch | 22
3640.289.03 | 1 |  | 3640.289.03 | 1
3641.289.03 | 1 |  | 3641.289.03 | 1
3642.03.289 | 1 |  | 3642.03.289 | 1
3651.289.03 | 1 |  | 3651.289.03 | 1
3652.289.03 | 1 |  | 3652.289.03 | 1
3653.289.03 | 1 |  | 3653.289.03 | 1
3654.289.03 | 1 |  | 3654.289.03 | 1
3655.289.03 | 1 |  | 3655.289.03 | 1
3663.289.03 | 1 |  | 3663.289.03 | 1
3664.289.03 | 1 |  | 3664.289.03 | 1
3666.289.03 | 1 |  | 3666.289.03 | 1
5535.289.03 | 1 |  | 5535.289.03 | 1
5536.289.03 | 1 |  | 5536.289.03 | 1
5538.289.03 | 1 |  | 5538.289.03 | 1
5539.289.03 | 1 |  | 5539.289.03 | 1
6857.289.03 | 1 |  | 6857.289.03 | 1
6858.289.03 | 1 |  | 6858.289.03 | 1
6859.289.03 | 1 |  | 6859.289.03 | 1
7002.289.03 | 1 |  | 7002.289.03 | 1
RPV-3644 | 1 |  | RPV-3644 | 1
(blank) | 2 |  | (blank) | 2
(blank) |  |  | (blank)
(blank) |  |  | (blank)
Grand Total | 62 |  | Grand Total | 62
Spreadsheet: 214916d1361190913-search-for-a-phrase-in-a-column-error-value-city-sort
Sheet: Cities

Cities
Avon
Bedfordshire
Berkshire
Borders
Buckinghamshire
Cambridgeshire
Central
Cheshire
Clwyd
Cornwall
[NAME]
County Armagh
County Down
County Fermanagh
County Londonderry
County Tyrone
Cumbria
Derbyshire
[NAME]
Dorset
Dumfries and [NAME]
[NAME]
Dyfed
East Sussex
Essex
Fife
Gloucestershire
Grampian
Greater Manchester
Gwent
Gwynedd County
Hampshire
Herefordshire
Hertfordshire
Highlands and Islands
Humberside
Isle of Wight
Kent
Lancashire
Leicestershire
Lincolnshire
Lothian
Merseyside
Mid Glamorgan
Norfolk
[NAME]
Northamptonshire
Northumberland
Nottinghamshire
Oxfordshire
[NAME]
Rutland
Shropshire
Somerset
South Glamorgan
South Yorkshire
Staffordshire
Strathclyde
Suffolk
[NAME]
Tayside
[NAME] and [NAME]
Warwickshire
West Glamorgan
West Midlands
West Sussex
West Yorkshire
Wiltshire
[NAME]
Spreadsheet: 1a80b371-af0a-4f81-9872-f454fcc4b844
Sheet: Sheet1

If applicable, list whether registrant or any member, officer, employee or agent has been subject to any of the following actions by any court, jurisdiction, government entity in this state or any other state, or any federal agency:
E-mail a copy of any applicable agreements or court documents to [EMAIL]
Registration or authority to solicit denied, suspended, revoked, or enjoyed?
Person Name | State Where Action  Was Taken | Date Action  Taken | Regulatory Agency Involved | Brief Summary of Alleged [NAME] or Issues Invovled | Brief Description of Final Outcome
Entered into agreement concerning "do not call" violations?
Person Name | State Where Action  Was Taken | Date Action  Taken | Regulatory Agency Involved | Brief Summary of Alleged [NAME] or Issues Invovled | Brief Description of Final Outcome
Fundraising activities limited or prohibited?
Person Name | State Where Action  Was Taken | Date Action  Taken | Regulatory Agency Involved | Brief Summary of Alleged [NAME] or Issues Invovled | Brief Description of Final Outcome
Any violation(s) of ORC 1716 or any other state or local solicitation law in Ohio or any other state?
Person Name | State Where Action  Was Taken | Date Action  Taken | Regulatory Agency Involved | Brief Summary of Alleged [NAME] or Issues Invovled | Brief Description of Final Outcome
Voluntary settlement agreement with regulatory officials?
Person Name | State Where Action  Was Taken | Date Action  Taken | Regulatory Agency Involved | Brief Summary of Alleged [NAME] or Issues Invovled | Brief Description of Final Outcome
Any pending actions by any federal, state or local governmental agency?
Person Name | State Where Action  Was Taken | Date Action  Taken | Regulatory Agency Involved | Brief Summary of Alleged [NAME] or Issues Invovled | Brief Description of Final Outcome
Spreadsheet: 746005d1630430424-how-to-combine-if-then-statements-with-vlookup-book2
Sheet: Sheet4

Cust ID | Cust Name |  | Code
8813 | Bar Refaeli |  | V1122 |  |  |  | Aetna = V1122
6227 | [NAME] |  | S3344 |  |  |  | Anthem = S3344
9988 | [NAME] |  | L5566 |  |  |  | Humana = L5566, V1122
8900 | [NAME] |  | V1122
1511 | [NAME] |  | S3344
8062 | [NAME] |  | L5566
1850 | [NAME] |  | V1122
5020 | [NAME] |  | S3344
1746 | Beyonce Knowles |  | L5566
8124 | [NAME] |  | V1122
6934 | [NAME] |  | S3344
6496 | [NAME] |  | L5566
7566 | Bjork |  | V1122
9313 | [NAME] |  | S3344
9134 | [NAME] |  | L5566
2192 | [NAME] |  | V1122
4726 | Boman Irani |  | S3344
8978 | [NAME] |  | L5566
6124 | [NAME] |  | V1122
4162 | [NAME] |  | S3344
7739 | Bradley Cooper |  | L5566
9832 | [NAME] |  | V1122
6378 | Britney Spears |  | S3344
6423 | [NAME] |  | L5566
8320 | [NAME] |  | V1122
7368 | [NAME] |  | S3344
1584 | [NAME] |  | L5566
3782 | [NAME] |  | V1122
2453 | [NAME] |  | S3344
9783 | [NAME] |  | L5566
7118 | [NAME] |  | V1122
6344 | [NAME] |  | S3344
6538 | [NAME] |  | L5566
9750 | [NAME] |  | V1122
2251 | Harper Seven Beckham |  | S3344
8804 | [NAME] |  | L5566
2107 | [NAME] |  | V1122
1426 | [NAME] Yasin |  | S3344
5466 | [NAME] |  | L5566
9803 | Hayden Panettiere |  | V1122
8944 | [NAME] |  | S3344
2666 | Heath Ledger |  | L5566
7105 | [NAME] |  | V1122
6928 | Heather Locklear |  | S3344
3854 | [NAME] |  | L5566
5804 | [NAME] |  | V1122
8057 | [NAME] |  | S3344
1924 | [NAME] |  | L5566
1598 | [NAME] |  | V1122
3787 | Hema Malini |  | S3344
Spreadsheet: 107862d1305016405-how-to-transpose-data-query
Sheet: Sheet1

 |  | The Challenge
 | Days | Supplier No | [NAME]
 | 23 | AAA862912169 | [NAME]
 | 12 | AAA862912169 | [NAME]
 | 50 | AAA237456215 | LITE-ON TECHNOLOGY CORP
 | 33 | AAA237456215 | LITE-ON TECHNOLOGY CORP
 | 10 | AAA237456215 | LITE-ON TECHNOLOGY CORP
 | 40 | AAA385357371 | Amtek Precision Technology Pte Ltd (AI)
 | 12 | AAA679821330 | REXSSON TECHNOLOGY PTE LTD
 | 10 | AAA167781947 | OFFICE PRODUCTS ENGINEERING
 | 23 | AAA249430695 | NITTO [NAME] (SINGAPORE) PTE LTD
 | 46 | AAA098497514 | TECHNOCOM SYSTEMS SDN BHD
 | 46 | AAA250769247 | VENTURE CORPORATION LIMITED
 | 39 | AAA250769247 | VENTURE CORPORATION LIMITED
 |  | Outcome Expected
 |  | AAA862912169 | [NAME] | 23 | 12
 |  | AAA237456215 | LITE-ON TECHNOLOGY CORP | 50 | 33 | 10
 |  | AAA385357371 | Amtek Precision Technology Pte Ltd (AI) | 40
 |  | AAA679821330 | REXSSON TECHNOLOGY PTE LTD | 12
 |  | AAA167781947 | OFFICE PRODUCTS ENGINEERING | 23
 |  | AAA249430695 | NITTO [NAME] (SINGAPORE) PTE LTD | 23
 |  | AAA098497514 | TECHNOCOM SYSTEMS SDN BHD | 46
 |  | AAA250769247 | VENTURE CORPORATION LIMITED | 46 | 39
Spreadsheet: 859242d1707713466-creating-calculation-after-matchinf-data-look-up-and-add-value
Sheet: Monthly Cashflow

 |  | Month |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12
 |  | Year |  |  | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1
Revenue
 | Line Item 1
 | Line Item 2
 | Line Item 3
 | Line Item 4
 | Line Item 5
 | Line Item 6
 | Line Item 7
 | Line Item 8
 | Line Item 9
 | Line Item 10
 | Line Item 11
 | Total
Spreadsheet: 87781d1287630943-comparing-external-data-with-a-static-table-sample1
Sheet: Sample Sheet 1

ID | Lot #
56 | 6
105 | 3
165 | 2
204 | 6 |  | Lot Numbers: | 1, 2, 3, 4 | <-- Desired Results
351 | 8
387 | 2
504 | 1
507 | 1
513 | 5
543 | 7
546 | 5
628 | 4
3513 | 2
3515 | 8
5165 | 1
5321 | 1
5435 | 3
5648 | 2
6513 | 4
6801 | 7
Spreadsheet: 219908d1363011609-auto-reapply-autofilter-test
Sheet: SurfaceGrinding

Detail No. | Quantity | [NAME] | Define Holding Method | Dress Wheel | Inspection | Grinding | Types of Equipment | Clean Down | Other | Total Time (hours) | NOTES
 | 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
. |  |  |  |  |  |  |  | Grand Total |  | 0
Setting
Rotary Table
Angle Plate
Sine Table
Vice
[NAME]
Handling
Tooling
Spreadsheet: 467270d1466629572-conditional-format-calendar-if-date-matches-range-of-dates-in-other-cells-workbook2_etaf
Sheet: Sheet4

 | Summer Term 2016
 | Inset Day | 2016-04-11 00:00:00
 | Start of Pupil Term | 2016-04-12 00:00:00
 | May Day Bank Holiday | 2016-05-02 00:00:00
 | Spring Bank Holiday | 2016-05-30 00:00:00
 | Start Half Term | 2016-05-31 00:00:00
 | End Half Term | 2016-06-03 00:00:00
 | End of Term - School | 2016-07-20 00:00:00
 | Autumn Term 2016
 | [NAME] | 2016-09-01 00:00:00
 | Inset Day | 2016-09-02 00:00:00
 | Start of Pupil Term | 2016-09-05 00:00:00
 | Start Half Term | 2016-10-24 00:00:00
 | End Half Term | 2016-10-28 00:00:00
 | Inset Day | 2016-11-04 00:00:00
 | School End of Term | 2016-12-20 00:00:00
 | Spring Term 2017
 | Inset Day | 2017-01-04 00:00:00
 | Start of Pupil Term | 2017-01-05 00:00:00
 | [NAME] | 2017-02-13 00:00:00
 | End Half Term | 2017-02-17 00:00:00
 | School End of Term | 2017-03-31 00:00:00
 | Summer Term 2017
 | Good Friday | 2017-04-14 00:00:00
 | Easter Monday | 2017-04-17 00:00:00
 | Inset Day | 2017-04-18 00:00:00
 | Start of Pupil Term | 2017-04-19 00:00:00
 | May Day Bank Holiday | 2017-05-01 00:00:00
 | Spring Bank Holiday | 2017-05-29 00:00:00
 | [NAME] | 2017-05-30 00:00:00
 | End Half Term | 2017-06-02 00:00:00
 | End of Term - School | 2017-07-25 00:00:00
Spreadsheet: 476269d1471745179-holiday-and-other-leave-types-calendar-copy-of-calendar-example-1
Sheet: Example

 |  | 2016-01-01 00:00:00 | 2016-01-02 00:00:00 | 2016-01-03 00:00:00 | 2016-01-04 00:00:00 | 2016-01-05 00:00:00 | 2016-01-06 00:00:00 | 2016-01-07 00:00:00 | 2016-01-08 00:00:00 | 2016-01-09 00:00:00 | 2016-01-10 00:00:00 | 2016-01-11 00:00:00 | 2016-01-12 00:00:00 | 2016-01-13 00:00:00 | 2016-01-14 00:00:00 | 2016-01-15 00:00:00 | 2016-01-16 00:00:00 | 2016-01-17 00:00:00 | 2016-01-18 00:00:00 | 2016-01-19 00:00:00 | 2016-01-20 00:00:00 | 2016-01-21 00:00:00
 | Week end
 | [NAME]
 | [NAME]
 | [NAME]
index | Name | Leave Type | From | To | Daily Hours
1 | [NAME] | A/L | 2016-01-02 00:00:00 | 2016-02-10 00:00:00 | 7.5
 | [NAME] | Sick | 2016-01-12 00:00:00 | 2016-01-12 00:00:00 | 7.5 |  |  | Users fills in this table
 | [NAME] | A/L | 2016-01-04 00:00:00 | 2016-01-05 00:00:00 | 6 |  |  |  | Which then populates this table
 | [NAME] | Comp | 2016-01-06 00:00:00 | 2016-01-06 00:00:00 | 3.75
Spreadsheet: 691523d1597743339-correlation-formula-directly-from-correlation-matrix-sample-dataset
Sheet: Sample problem

 | Asset class standard deviations
 | U.S. Stocks | EU Stocks | EM Stocks | Frontier Stocks | U.S. Bonds | EU Bonds | EM Bonds | Frontier Bonds | Private Equity | Hedgefunds
 | 0.05 | 0.06 | 0.15 | 0.22 | 0.03 | 0.03 | 0.05 | 0.08 | 0.23 | 0.15
 | Correlation matrix
 | U.S. Stocks | EU Stocks | EM Stocks | Frontier Stocks | U.S. Bonds | EU Bonds | EM Bonds | Frontier Bonds | Private Equity | Hedgefunds
U.S. Stocks | 1 | 0.5 | 0.3 | 0.2 | 0.1 | 0 | 0 | 0 | 0 | 0
EU Stocks | 0.5 | 1 | 0.6 | 0.7 | 0.2 | 0.2 | 0.2 | 0.2 | 0.1 | 0.2 |  |  |  |  | Portfolio allocations
EM Stocks | 0.3 | 0.6 | 1 | 0.7 | 0.7 | 0.7 | 0.6 | 0.5 | 0.2 | 0.7 |  |  |  |  | Portfolio 1 | Portfolio 2 | Portfolio 3
Frontier Stocks | 0.2 | 0.7 | 0.7 | 1 | 0.5 | 0.6 | 0.4 | 0.4 | 0.2 | 0.4 |  |  |  | U.S. Stocks | 0.65 | 0.3 | 0
U.S. Bonds | 0.1 | 0.2 | 0.7 | 0.5 | 1 | 0.8 | 0.8 | 0.6 | 0.4 | 0.8 |  |  |  | EU Stocks | 0.009 | 0.026 | 0.003
EU Bonds | 0 | 0.2 | 0.7 | 0.6 | 0.8 | 1 | 0.7 | 0.5 | 0.3 | 0.8 |  |  |  | EM Stocks | 0.081 | 0.161 | 0.009
EM Bonds | 0 | 0.2 | 0.6 | 0.4 | 0.8 | 0.7 | 1 | 0.6 | 0.5 | 0.8 |  |  |  | Frontier Stocks | 0.06 | 0.08 | 0
Frontier Bonds | 0 | 0.2 | 0.5 | 0.4 | 0.6 | 0.5 | 0.6 | 1 | 0.5 | 0.5 |  |  |  | U.S. Bonds | 0 | 0.22 | 0.8
Private Equity | 0 | 0.1 | 0.2 | 0.2 | 0.4 | 0.3 | 0.5 | 0.5 | 1 | 0.4 |  |  |  | EU Bonds | 0 | 0.03 | 0.1
Hedgefunds | 0 | 0.2 | 0.7 | 0.4 | 0.8 | 0.8 | 0.8 | 0.5 | 0.4 | 1 |  |  |  | EM Bonds | 0 | 0.067 | 0.065
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Frontier Bonds | 0 | 0.016 | 0.024
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Private Equity | 0.2 | 0.1 | 0
 | Variance-Covariance matrix (calculated) |  |  |  |  |  |  |  |  |  |  |  |  | Hedgefunds | 0 | 0 | 0
 | Stats- og realkreditobligationer | Investment grade obligationer | High-yield obligationer | Emerging markets statsobligationer | Globale aktier (developed markets) | Emerging markets aktier | Private equity | Infrastruktur | Ejendomme | Hedgefonde
U.S. Stocks
EU Stocks
EM Stocks | 0.00225
Frontier Stocks | 0.002200000000000001 | 0.00924
U.S. Bonds | 0.00015 | 0.00036 | 0.00315
EU Bonds | 0 | 0.00036 | 0.00315 | 0.00396
EM Bonds | 0 | 0.0006000000000000001 | 0.0045 | 0.0044 | 0.0012
Frontier Bonds | 0 | 0.00096 | 0.006 | 0.007040000000000001 | 0.00144 | 0.0012
Private Equity | 0 | 0.00138 | 0.0069 | 0.01012 | 0.00276 | 0.00207 | 0.005750000000000001
Hedgefunds | 0 | 0.0018 | 0.01575 | 0.0132 | 0.0036 | 0.0036 | 0.006000000000000001 | 0.006
 | Porteføljestatistikker
 | Portfolio 1 | Portfolio 2 | Portfolio 3
Weight | 0.5 | 0.2 | 0.3
[NAME]
Standard deviation
Cov(A, B)  &  Cov(A, C)  &  Cov(B, C)
Cor(A, B)   &  Cor(A, C)  &  Cor(B, C) |  |  |  | <-- I would like to calculate these without using the variance-covariance matrix (I am thinking a similar formula to that for covariance in row 41 but using the correlation matrix)
Portfolio standard deviation (using covariance)
Portfolio standard deviation (using correlation)
Spreadsheet: tracy_geaccone__40401__GPM 101021  101073 Recalculation
Sheet: Apr 2001

KN Processing |  | GPM Agency Agreement |  |  | Prepared by [NAME]
Bushton Plant |  | TFDV Volume & Dollar Calculation
 |  | For
 |  | 2001-04-01 00:00:00
Contract #101021 |  |  | NNG Numbers |  |  | Oneok Numbers |  |  | Difference
 | Total Deliveries |  |  | 4474877 |  |  | 3479050
 |  | Deliveries to Inlet | 4282570 |  |  | 3337210
 |  | Deliveries to PVR
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 4468511 |  |  | 3479649
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
Contract #101073
 | Total Deliveries |  |  | 1084903 |  |  | 1330289
 |  | Deliveries to Inlet | 0
 |  | Deliveries to PVR | 1037549 |  |  | 1273566
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 1014872 |  |  | 1319413
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
 |  | Total Both Contracts
 |  | Index |  | 5.017
 |  | Total Revenue Due
Total Revenue Billed |  | 101021
 |  | 101073
 |  |  |  |  |  |  | 45596.23
 |  | Amount Due NNG (GPM)
Charge given by NNG on prior reconciliation
 |  | Amount Due NNG (GPM)
Spreadsheet: fd970b8f-38d7-44fc-887b-ff82041adcd2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | 1 | 2 | 3
 |  |  |  |  |  |  |  |  | Table 23    Household by occupation of the head, type of household
 |  |  |  |  |  |  | Jan.～Mar. 2012 |  |  |  | (Ten thousand household)
 |  |  |  |  |  |  |  | Type of household | Total | Two-or-more- person household | One-person household
 |  |  |  |  |  |  | Occupation the head of household engages in |  | 1 | 2 | 3
2300 | 87*10 |  | 1 |  |  |  | Total | 1 | 3254 | 2535 | 719
2300 | 87*10 |  | 1 |  |  |  | Administrative and managerial worker | 2 | 134 | 118 | 15
2300 | 87*10 |  | 1 |  |  |  | Professional and engineering workers | 3 | 557 | 404 | 152
2300 | 87*10 |  | 1 |  |  |  | Clerical worker | 4 | 523 | 401 | 122
2300 | 87*10 |  | 1 |  |  |  | Sales worker | 5 | 457 | 371 | 86
2300 | 87*10 |  | 1 |  |  |  | Service worker | 6 | 263 | 172 | 90
2300 | 87*10 |  | 1 |  |  |  | Security worker | 7 | 94 | 65 | 29
2300 | 87*10 |  | 1 |  |  |  | Agricultural, forestry and fishery worker | 8 | 107 | 97 | 9
2300 | 87*10 |  | 1 |  |  |  | Manufacturing process worker | 9 | 498 | 400 | 98
2300 | 87*10 |  | 1 |  |  |  | Transport and machine operation worker | 10 | 174 | 146 | 28
2300 | 87*10 |  | 1 |  |  |  | Construction and mining worker | 11 | 231 | 198 | 33
2300 | 87*10 |  | 1 |  |  |  | Other carrying, cleaning, packaging, and related worker | 12 | 195 | 146 | 48
2300 | 87*10 |  | 1 |  |  |  | Workers not classified by occupation | 13 | 22 | 17 | 6