tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 742248d1627623893-automatically-summing-weeks-into-months-weeks-into-months
Sheet: Weeks

 |  | 2022-03-07 00:00:00 | 2022-03-14 00:00:00 | 2022-03-21 00:00:00 | 2022-03-28 00:00:00 | 2022-04-04 00:00:00 | 2022-04-11 00:00:00 | 2022-04-18 00:00:00 | 2022-04-25 00:00:00 | 2022-05-02 00:00:00 | 2022-05-09 00:00:00 | 2022-05-16 00:00:00 | 2022-05-23 00:00:00 | 2022-05-30 00:00:00
 | Task 1 | 1 | 1 |  | 0.5 | 0.5 | 0.5 |  |  | 4
 | Task 2 |  | 1 | 0.5 |  |  | 1 |  |  | 2
Spreadsheet: 696943d1601045980-cells-that-conditionally-displays-a-concatenated-list-of-other-cells-contents-doc_sample
Sheet: Sheet1

 |  | January | February | March | April | May | June
 | Red
 | Green
 | Doc Number
 | 123 | Red |  | Red | Green | Green | Red
 | 456 | Red | Green |  | Green |  | Green
 | 789 |  |  | Red |  | Green | Red
 | 321 |  |  | Red |  | Green
 | 654 |  |  | Red | Green | Green
 | 987 | Red | Green |  | Green |  | Green
Spreadsheet: 103602d1301345967-automated-shipping-estimator-daily_rates-1-
Sheet: UPS CWT Tier 3

 |  |  |  |  |  |  |  |  | 2011 Rates
 | Domestic
 | UPS Hundredweight Service Tier 3
 | Guaranteed Delivery Service Options
 | UPS Next Day Air |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 124 | 125 | 126
 | 100 Lbs. or more | 1.3 | 1.88 | 2.77 | 3.05 | 3.35 | 3.5 | 3.68 | 3.77 | 3.54 | 4.15
 | UPS Next Day Air Saver |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 132 | 133 | 134 | 135 | 136 | 137 | 138 | Service Not Available
 | 100 Lbs. or more | 1.03 | 1.57 | 2.67 | 3 | 3.15 | 3.33 | 3.5
 | UPS 2nd Day Air A.M. |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 242 | 243 | 244 | 245 | 246 | 247 | 248 | Service Not Available
 | 100 Lbs. or more | 0.83 | 0.94 | 1.22 | 1.77 | 2.86 | 3.14 | 3.36
 | UPS 2nd Day Air |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 202 | 203 | 204 | 205 | 206 | 207 | 208 | 224 | 225 | 226
 | 100 Lbs. or more | 0.73 | 0.88 | 1.13 | 1.59 | 2.57 | 2.86 | 2.97 | 3.03 | 2.76 | 3.36
 | UPS 3 Day Select |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Hundredweight Unit
 | Zones | 302 | 303 | 304 | 305 | 306 | 307 | 308 | Service Not Available
 | 200 to 499 Lbs. | 32.7 | 38.45 | 44.15 | 51.4 | 85.95 | 119.45 | 135.5
 | 500 to 999 Lbs. | 28.6 | 33.6 | 38.5 | 47.6 | 79.6 | 110.25 | 125.05
 | 1,000 Lbs. or more | 29.9 | 35.15 | 40.4 | 49.5 | 82.95 | 114.8 | 130.2
 | [NAME] |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Hundredweight Unit
 | Zones | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 44 | 45 | 46
 | 200 to 499 Lbs. | 24.65 | 30.95 | 34.6 | 40.4 | 50.85 | 58.7 | 68.25 | 184 | 184 | 218.3
 | 500 to 999 Lbs. | 21.75 | 27.35 | 30.55 | 35.65 | 44.8 | 51.8 | 60.15 | 161.05 | 161.05 | 190.45
 | 1,000 Lbs. or more | 22.5 | 27.8 | 31.25 | 36.55 | 45.9 | 53.05 | 61.7 | 164.3 | 164.3 | 194.7
 | Minimum Charges
 | UPS 3 Day Select Zones |  |  | 302 | 303 | 304 | 305 | 306 | 307 | 308 | Service Not Available
 | Minimum Charge |  |  | 47 | 47 | 47 | 47 | 47 | 47 | 47
 | [NAME] |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 44 | 45 | 46
 | Minimum Charge |  |  | 41 | 41 | 45 | 45 | 45 | 45 | 45 | 225 | 225 | 275
Spreadsheet: 878261d1725327234-amortization-for-those-payday-loans-with-apr-300-pay-loan
Sheet: Sheet1

 |  |  |  | Monthly Interest rate:
 | Period | Date | Balance b/f | Principal | Interest | Payment | Balance c/f
 | 0 | 2024-08-14 00:00:00 | 0 | 1080 |  | 0
 | 1 |  |  | 0 |  | 302.4
 | 2 |  |  | 0 |  | 302.4
 | 3 |  |  | 0 |  | 302.4
 | 4 |  |  | 0 |  | 302.4
 | 5 |  |  | 0 |  | 1427.67
 | Total
Spreadsheet: 869137d1715780271-team-comp-help-with-a-formula-to-show-each-teams-points-against-the-other-teams-points-pong-streaks
Sheet: Sheet1

Round | Home | Score | Score2 | Away
1 | [NAME] | 21 | 13 | Nathan
1 | [NAME] | 21 | 15 | Nathan
1 | [NAME] | 11 | 4 | Nathan
1 | Nathan | 21 | 17 | [NAME]
1 | Nathan | 21 | 14 | [NAME]
1 | Nathan | 11 | 5 | [NAME]
1 | [NAME] | 21 | 18 | Mark
1 | [NAME] | 21 | 13 | [NAME]
2 | [NAME] | 21 | 9 | Nathan
2 | [NAME] | 21 | 11 | [NAME]
2 | Nathan | 21 | 17 | [NAME]
2 | Nathan | 21 | 14 | [NAME]
2 | [NAME] | 21 | 12 | [NAME]
2 | [NAME] | 21 | 19 | Mark
2 | Mark | 11 | 8 | [NAME]
Spreadsheet: 1f1b1ce4-f60b-448a-a481-66d9dff26d29
Sheet: Mergent

Mergent
2004-2005
Metric | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | Total | Price for 2004-2005 | Price per unit
TOTAL
Searches | 59 | 47 | 176 | 370 | 150 | 192 | 166 | 45 | 126 | 61 | 81 | 8 |  | 9900
Companies Viewed | 35 | 27 | 86 | 202 | 67 | 88 | 71 | 27 | 35 | 10 | 55 | 0 |  | 9900
Spreadsheet: 812993d1673486551-formula-to-calculate-based-on-count-and-date-in-column-header-excelforum
Sheet: Summary

Sum of multiply | Date
Region | 2021-09-07 00:00:00 | 2022-10-07 00:00:00 | 2023-10-17 00:00:00 | 2023-11-15 00:00:00 | 2023-09-21 00:00:00 | 2023-08-22 00:00:00 | 2023-01-07 00:00:00 | 2023-06-28 00:00:00 | 2023-05-25 00:00:00 | 2027-09-22 00:00:00
East | 0 | 0 | 100 | 0 | 100 | 400 | 0 | 0 | 0 | 0
North | 200 | 0 | 0 | 100 | 0 | 0 | 0 | 500 | 0 | 0
South | 0 | 200 | 0 | 0 | 100 | 0 | 0 | 0 | 100 | 0
West | 0 | 0 | 0 | 100 | 0 | 0 | 100 | 0 | 0 | 200
 |  | 2 | 2 | 1 | 1 | 1 | 1
Spreadsheet: 289b27f3-ee27-41ed-9e56-88012f6c3301
Sheet: serials v mono

Serials vs. [NAME] by Branch FY11 and FY12
 | FY11 | FY12 | % change | % of total FY12 expend.
Kingston
monographs | 333441.26 | 314165.69
monographs endowments | 4377.87 | 14592.46
MONOGRAPHS TOTAL
serials | 2891248.79 | 3021619.98
serials endowments | 39437.93 | 31594.32
SERIALS TOTAL
KINGSTON SUBTOTAL
[NAME]
monographs | 462.78 | 541.01
serials | 9719.39 | 4437.11
[NAME]
CCE
monographs | 10237.42 | 10614.7
monographs endowments | 0 | 1661.35 | N/A
serials | 3411.96 | 2828.4
CCE SUBTOTAL
All branches
monographs
serials
TOTAL
Spreadsheet: 700369d1603166412-need-help-to-have-formula-to-ignore-cells-with-no-dates-multiple-cells-in-a-row-playing-with-timeline
Sheet: Condo Conv Refi

Subject | Start Date | All day event | Reminder on/off | Meeting Organizer | Categories | Description | Location
Sign Disclosures |  | True | False | Team Rosa | Sign Disclosures
[NAME] |  | True | False | Team Rosa | [NAME]
[NAME] |  | True | False | Team Rosa | [NAME]
Processing Review |  | True | False | Team Rosa | Processing Review
[NAME] |  | True | False | Team Rosa | [NAME] | _x000D_
Submit for Condo Approval |  | True | False | Team Rosa | Submit 4 Condo Approval
[NAME] |  | True | False | Team Rosa | [NAME]
Submit to Underwriting |  | True | False | Team Rosa | Submit to Underwriting
Final Approval |  | True | False | Team Rosa | Final Approval
CD |  | True | False | Team Rosa | CD
Docs Out |  | True | False | Team Rosa | Docs Out
Signing |  | True | False | Team Rosa | Signing
Close Date |  | True | False | Team Rosa | Close Date
Spreadsheet: chris_stokley__3845__Jan 2001 tranny
Sheet: Sheet1

DATE | SRP (MW) | ENA (MW) | (MW) Difference | SRP daily total | ENA daily total | Difference ($)
2001-01-02 00:00:00 | 160 | 160 |  | 52970.85
2001-01-03 00:00:00 | 155 | 155 |  | 38522.35
2001-01-04 00:00:00 | 160 | 160 |  | 42508.8
2001-01-05 00:00:00 | 560 | 560 |  | 163140.87
2001-01-06 00:00:00 | 580 | 560 | 20- | 146886.56 |  | 5065
2001-01-07 00:00:00 | 600 | 600 |  | 142251.56
2001-01-08 00:00:00 | 600 | 600 |  | 183780.72
2001-01-09 00:00:00 | 600 | 600 |  | 183398.06
2001-01-10 00:00:00 | 590 | 590 |  | 174074.13
2001-01-11 00:00:00 | 590 | 600 | 10+ | 180757.69 |  | 3063.7 | In SRP's favor
2001-01-12 00:00:00 | 600 | 600 |  | 261029.88
2001-01-13 00:00:00 | 600 | 600 |  | 175577.48
2001-01-14 00:00:00 | 440 | 440 |  | 105786.57
2001-01-15 00:00:00 | 600 | 600 |  | 170726.54
2001-01-16 00:00:00 | 600 | 600 |  | 273332.48
2001-01-17 00:00:00 | 580 | 560 | 20- | 365484.56 |  | 12603
2001-01-18 00:00:00 | 576 | 600 | 24+ | 349686.73 |  | 14570.4 | In SRP's favor
2001-01-19 00:00:00 | 591 | 600 | 9+ | 94744.21 |  | 1442.79 | In SRP's favor
2001-01-20 00:00:00 | 600 | 600 |  | 109581.7
2001-01-21 00:00:00 | 430 | 420 | 10- | 308646.28 |  | 7177.8
2001-01-22 00:00:00 | 580 | 580 |  | 201547.04
2001-01-23 00:00:00 | 590 | 600 | 10+ | 180712.95 |  | 3062.9 | In SRP's favor
2001-01-24 00:00:00 | 575 | 575 |  | 142433.29
2001-01-25 00:00:00 | 575 | 600 | 25+ | 59220.61 |  | 3384 | In SRP's favor
2001-01-26 00:00:00 | 425 | 425 |  | 94730.37
2001-01-27 00:00:00 | 400 | 400 |  | 74996.44
2001-01-28 00:00:00 | 575 | 575 |  | 192960.73
2001-01-29 00:00:00 | 625 | 625 |  | 186383.72
2001-01-30 00:00:00 | 600 | 600 |  | 141483.16
2001-01-31 00:00:00 | 600 | 600 |  | 133390.84
TOTALS | 15757 | 15785 |  | 4930739.16 | 5025213.54 | 94474.38
 |  |  |  | SRP | ENA
 |  |  |  | 4930739.16 | 5025213.54
 |  |  |  | X 2.3% | X 2.3%
 |  |  |  | 113407.00068 | 115579.91142
Spreadsheet: fe49f5b7-1002-4633-b1a6-81af94135bca
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CLAM | Test | CLAM | Clam, IgE | Clam, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CLAM | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CLAM | Result | CLAM | Clam, IgE | Clam, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6076-4
Spreadsheet: 832352d1686290370-order-sheet-for-supplies-for-my-special-education-class-pq-supplies-aligw-messed-up
Sheet: SSP1

# | PRODUCT DESCRIPTION | Vendor's Name | VENDOR PROD. CODE | UNIT PRICE | QTY | TOTAL | DDSB PROD. CODE
1 |  |  |  |  | 1
 |  |  |  |  | 1
Spreadsheet: 101942d1300011017-subtraction-from-2-cells-weekly_blanket_wash_consumption_master_2
Sheet: wk 3 

Blanket Wash / Materials. |  |  |  |  |  |  |  |  |  | BLANKET WASH / BLANKETS
 |  | Week | 8250102    514915-153-716
Date | 2011-02-18 00:00:00 | 3
Clean |  |  | Litres | Dirty |  |  |  | Litres
Stainless Tank |  |  |  | Renzmann wash / mach
1,000 Blue Tank ( 11 ) |  |  |  | Holding Stainless/Tank
Total Litres |  |  | 0 | 2nd holding tank(plastic)
Spare  Tanks  (18)
Total |  |  | 0 | Total |  |  |  | 0 |  | Filtered Blanket wash
 |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  | Tank Changed
Blankets- 595011. 153716 |  |  |  |  | Foils- 514915. 153716
Blue  Graffity |  |  |  | 0 |  | Foils
8251506 |  |  |  |  | 0 |  |  |  |  | DATE | 2011-02-18 00:00:00 |  |  | week | 3
Blue Vulcan Editor 20s |  |  |  | 16 |  | .18 RB Foils | 0 |  |  | WEEKLY BLANKET WASH USAGE
8251507 |  |  |  |  | 16 | 8252002 |  | 0 |  | DATE | CLEAN | DIRTY | TANK | DATE ON | TOTAL
28 up week 25 |  |  |  |  |  |  |  |  |  | 2011-02-11 00:00:00 | 0 | 0 | 0 |  | 0
Green Vulcan202Tower Blankets |  |  |  | 25 |  | .16 RB Foils | 0 |  |  | 2011-02-18 00:00:00 |  |  | 0 |  | 0
8251500 |  |  |  |  | 25 | 8252001 |  | 0 |  | TOTALS | 0 | 0 | 0
20 up week 25 |  |  |  |  |  |  |  | 30 in wk19
Green Vulcan 202 Newsman 40 |  |  |  | 44 |  | .18 RB Tower | 0 |  |  | TOTAL USED |  | DATE | 2011-02-18 00:00:00 |  | 0 | WEEK 1
8251508 |  |  |  |  | 44 | 8251511 |  | 0 |  |  |  |  |  |  |  | WEEK 2
30 up week 25 |  |  |  |  |  |  |  |  |  | SPARE TANK 1000 |  |  |  |  |  | WEEK 3
Brown Day International |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | WEEK 4
 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | WEEK 5
[NAME] |  |  |  |  |  | Aim Pre Packs |  |  |  |  |  |  |  |  | MONTH | TOTAL | 0
8251502   514940   153-716 |  |  |  |  |  | 8250101
 |  |  |  |  |  |  |  | 0 |  | CHEMPORT FOUNT SOL |  |  |  | AIM pre packs
Position A |  |  |  |  | Blanketwash Additives
 |  |  |  |  | 514915-153716 |  |  |  |  | DATE | TOTAL | USED |  |  | TOTAL | USED
Position B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 96 bought up
 |  |  |  |  | 8251501 | Parabar |  | 3 litres wk
Position C |  |  |  |  | 8250805 | Isowash |  | 50 litres wk
Spare |  |  |  |  | 8251825 | Surfactant |  | 8 litres wk
Total |  | 0 |  |  | xl  Pressroom/reports/originals/blanket wash totals
 |  |  |  |  |  |  |  |  |  | Total |  | 0 |  | Total |  | 0
xl  Pressroom/reports/originals/blanket wash totals
Spreadsheet: 120466d1315317176-finding-unique-between-2-columns-unique
Sheet: Sheet1

 | [NAME] | DATA2 | UNIQUE
 | ABC | JJJ
 | DEF | LLL
 | GHI | MMM
 | JJJ | NNN
 | LLL | PRT
 | MMM | GHT
 | NNN | QJW
 | PRT | CSQ
 | GHT | TRW
 | QJW | AQP
 | FRT | ZZZ
 | SWQ | DFR
 | RWT | RLA
 | FVS | SLA
 | FTJ | OOO
 | CSQ | QQQ
 | TRW | LFS
 | AQP | SQL
 | CSQ | RQQ
 | TRW | QQI
 | AQP | IQO
 | ZZZ | AST
 | DFR | POR
 | RLA | NIV
 | SLA | AND
 | LAS | DRE
 | TQP | WAN
 | PQG | LJK
 | BVD | KSQ
 |  | PSK
 |  | GHF
 |  | HGL
 |  | LOP
 |  | VOD
Spreadsheet: 712858d1610455437-consolidate-data-from-2-sheets-comparison-sample-data
Sheet: Result

Code | Price (From Sheet 1) | Price (From Sheet 2)
A
A1
A2
A3
B
B1
B3
C
C4
C5
C6
D
D1
Spreadsheet: 812050d1672929385-search-in-a-range-of-cells-to-see-if-date-is-in-the-same-week-number-annual-leave-log-april-2022-march-2023-1-
Sheet: employee3

Year total | 111.7 | hours | Based on 22.5 hours per week (15/08/2022 - 01/12/2022) and 30 hours (01/12/2022 - 31/03/2022)
Annual Leave |  |  | FT Annual Leave allowance = 33 days
Dates Booked | Hours Used | Running Hotel
2023-03-02 00:00:00 | 3
2023-03-03 00:00:00 | 4
2023-03-04 00:00:00 | 4
2023-03-05 00:00:00 | 6
2023-03-06 00:00:00 | 6
2023-03-07 00:00:00 | 6
2023-03-08 00:00:00 | 4
2023-03-09 00:00:00 | 6
2023-03-10 00:00:00 | 5
2023-03-11 00:00:00 | 5
2023-03-12 00:00:00 | 5
2023-03-13 00:00:00 | 5
2023-03-14 00:00:00 | 5
TOTAL LEFT
Spreadsheet: 676692d1588937168-conditional-formatting-does-not-work-product-and-keyword-research-shortlist-template
Sheet: Competition

Link to Similar Products on Amazon (Top 3-5 competitors) | Brand Name | Selling Price | Estimated Velocity (Units/Month) | Monthly Revenue | Monthly Gross Profit (after Amazon fees) | Margin Per Unit | No. of Reviews | Review Rating | Listing Optimizated? | Add Value or Improve Listing?
https://www.amazon.com/dp/B07YGMFRYJ | LNDMA | 52.99 | 60 | 15155 |  | 39.46 | 97 | 4.3 | Yes | Better images and lower pricing | 2019-04-28 00:00:00
https://www.amazon.com/dp/B086VDLN94 | XISH | 61.99 | 0 | 0 | 0 | 0 | 0 | 0 | No | Better images, copywriting and lower pricing | 2020-04-09 00:00:00
https://www.amazon.com/dp/B0839PK4ZW | TAYVADA | 16.95 | 503 | 8526 | 5471.38 | 10.88 | 66 | 4.9 | Yes | Competitive pricing of 16 pack and bundle with a hair band | 2020-02-01 00:00:00
https://www.amazon.com/dp/B07NXZYFKW | wyewye | 19.9 | 1475 | 29352 | 16335.62 | 11.08 | 546 | 4.4 | Yes | Provide both bamboo charcoal (8pcs) and activated charcoal (8pcs) | 2019-05-18 00:00:00
https://www.amazon.com/dp/B07RPS65J4 | Vitscan | 21.98 | 1317 | 28948 | 16743.02 | 12.71 | 450 | 4.3 | Yes |  | 2019-06-15 00:00:00
Spreadsheet: 715564d1611767334-if-and-function-should-show-multiple-result-test2
Sheet: Sheet1

 |  | values | expected result
 |  | 5.2
 |  | 3.3 | 3
 |  | 3.7 | 4
 |  | 4 | 4
 |  | 5.3 | 5
 |  | 6 | 5
 |  | 5.7 | 5
 |  | 1.2 | 1
 |  | 1.5 | 1
 |  | 1.8 | 1
 |  | 2 | 1
 |  | 1.6 | 1
Spreadsheet: mark_taylor__24675__Long Descriptions
Sheet: volumetric_measures

Price Units Field
 | Characters
Price Units Field | Field Abbreviation | Product Group | ID | Long Description Sentences
therm | TH |  | 1 | The unit of measure for which the price is quoted against is therms.
Btu | Btu |  | 2 | The unit of measure for which the price is quoted against is British thermal units, which are equal to the amount of heat required to raise the temperature of 1lb of water by 1 degree Fahrenheit.
MMBtu per Day | MMBtu/d |  | 3 | The unit of measure in which the price is quoted is in millions of British thermal units per day. With respect to a financial Transaction, the Notional Quantity per Determination Period is the Volume submitted to Enron multiplied by the number of days in the relevant Determination Period.  With respect to a Transaction which calls for physical delivery, the DCQ is the volume submitted.
MMBtu per Month | MMBtu/mth |  |  | The unit of measure for which the price is quoted against is in millions of British thermal units per month.
kWh | kWh |  | 4 | The unit of measure for which the price is quoted against is stated in kilowatts per hour.
GJ | GJ |  | 5 | The unit of measure for which the price is quoted against is in gigajoules.
MWh | MWh |  | 6 | The unit of measure for which the price is quoted against is stated in Megawatts.
MW | MW |  | 7 | The unit of measure for which the price is quoted against is stated in Megawatts per hour.
mt | mt |  | 8 | The unit of measure for which the price is quoted against is in metric tonnes.
cm | cm |  | 9 | The unit of measure for which the price is one centimetre.
Heating Degree Day | HDD |  | 10 | Heating Degree Day | HDD will be defined in the GTC
[NAME] | CDD |  | 11 | [NAME] | CDD will be defined in the GTC
[NAME] | [NAME] |  | 12 | The unit of measure for which the price is one millimetre.
Barrel | bbl |  | 13 | The unit of measure for which the price is quoted against is stated in Barrels.
Emission allowance | EA |  | 14 | The unit of measure for which the price is quoted against is the standard Emission Allowance.
[NAME] | GAL |  | 15 | The unit of measure for which the price is quoted against is stated in Gallons.
Pound | LB |  | 16 | The unit of measure for which the price is quoted against is stated in pounds.
1/10 inch | 1/10" |  | 17 | The unit of measure for which the price is one tenth of an inch.
Short ton | ST |  | 18 | The unit of measure for which the price is quoted against is in short tons (2000 lbs).
Spreadsheet: 683564d1592830381-consolidating-sheets-text-not-consolidating-consolidation
Sheet: Sheet 2

Ref | Description | Quantity | Units | Rate | Value
3/5/4a | Text 1 | 25 | m3 | 1
3/5/4b | Text 2 | 35 | m3 | 5.87
3/5/4c | Text 3 | 25 | m3 | 5.87
3/5/4d | Text 4 | 20 | m3 | 25.54
3/5/4e | Text 5 | 21 | m2 | 1.36
3/5/4f | Text 6 | 30 | m2 | 3.3
3/5/ | Text 7 | 31 |  | 1.5
3/5/4g | Text 8 | 32 | m2 | 2.5
3/5/ | Text 9 | 36 |  | 3
3/5/5 | Text 10 | 90 | m | 6
3/5/ | Text 11 | 90 |  | 72
3/5/6 | Text 12 | 90 | No | 32
3/5/ | Text 13 | 811 |  | 32
3/5/6 | Text 14 | 210 | no | 12
3/5/6a | Text 15 | 320 | Nr | 32
3/5/6b | Text 16 | 30 | m2 | 35
3/5/ | Text 17 | 0 |  | 32
Spreadsheet: 862854d1710432176-returning-a-column-header-name-if-a-cell-has-a-value-in-it-example
Sheet: Sheet1

Heworth | Manors | [NAME] | Pelaw | S Gosforth | Sunderland | [NAME] | Cullercoats | Output
 | Image 2 |  |  |  |  |  |  | Manors
 |  |  |  |  | Image 2 |  |  | Sunderland
 |  |  |  |  |  |  | Image 1 | Cullercoats
 |  |  |  | Image 2 |  |  |  | S Gosforth
 | Image 2 |  |  |  |  |  |  | Manors
 |  |  |  |  | Image 2 |  |  | Sunderland
Both equally |  |  |  |  |  |  |  | Heworth
Both equally |  |  |  |  |  |  |  | Heworth
Spreadsheet: 889785d1740698398-unpivot-via-formula-with-multiple-header-rows-using-formula-and-return-as-dynamic-array-unpivot-via-dynamic-array-formula-with-multiple-rows
Sheet: Sheet1

 |  |  | Fiscal 2025 | Fiscal 2026
 |  |  | Jun | Jul |  |  |  |  | Desired Result as dynamic array
A | A-1 | A-2 | 9 | 9 |  |  |  |  | A | A-1 | A-2 | Fiscal 2025 | Jun | 9
B |  |  | 2 | 7 |  |  |  |  | B |  |  | Fiscal 2025 | Jun | 2
C |  |  | 10 | 9 |  |  |  |  | C |  |  | Fiscal 2025 | Jun | 10
D |  |  | 3 | 1 |  |  |  |  | D |  |  | Fiscal 2025 | Jun | 3
E |  |  | 8 | 1 |  |  |  |  | E |  |  | Fiscal 2025 | Jun | 8
F |  |  | 2 | 10 |  |  |  |  | F |  |  | Fiscal 2025 | Jun | 2
G |  |  | 2 | 10 |  |  |  |  | G |  |  | Fiscal 2025 | Jun | 2
H |  |  | 9 | 7 |  |  |  |  | H |  |  | Fiscal 2025 | Jun | 9
I |  |  | 5 | 7 |  |  |  |  | I |  |  | Fiscal 2025 | Jun | 5
 |  |  |  |  |  |  |  |  | A | A-1 | A-2 | Fiscal 2026 | Jul | 9
 |  |  |  |  |  |  |  |  | B |  |  | Fiscal 2026 | Jul | 7
 |  |  |  |  |  |  |  |  | C |  |  | Fiscal 2026 | Jul | 9
 |  |  |  |  |  |  |  |  | D |  |  | Fiscal 2026 | Jul | 1
 |  |  |  |  |  |  |  |  | E |  |  | Fiscal 2026 | Jul | 1
 |  |  |  |  |  |  |  |  | F |  |  | Fiscal 2026 | Jul | 10
 |  |  |  |  |  |  |  |  | G |  |  | Fiscal 2026 | Jul | 10
 |  |  |  |  |  |  |  |  | H |  |  | Fiscal 2026 | Jul | 7
 |  |  |  |  |  |  |  |  | I |  |  | Fiscal 2026 | Jul | 7
 |  |  |  |  |  |  |  |  |  | A-1 | A-2 | Fiscal 2025 | Jun | 9
 |  |  |  |  |  |  |  |  | B | B-1 | B-2 | Fiscal 2025 | Jun | 2
 |  |  |  |  |  |  |  |  | C | C-1 | C-2 | Fiscal 2025 | Jun | 10
 |  |  |  |  |  |  |  |  | D | D-1 | D-2 | Fiscal 2025 | Jun | 3
 |  |  |  |  |  |  |  |  | E | E-1 | E-2 | Fiscal 2025 | Jun | 8
 |  |  |  |  |  |  |  |  | F | F-1 | F-2 | Fiscal 2025 | Jun | 2
 |  |  |  |  |  |  |  |  | G | G-1 | G-2 | Fiscal 2025 | Jun | 2
 |  |  |  |  |  |  |  |  | H | H-1 | H-2 | Fiscal 2025 | Jun | 9
 |  |  |  |  |  |  |  |  | I | I-1 | I-2 | Fiscal 2025 | Jun | 5
 |  |  |  |  |  |  |  |  | A | A-1 | A-2 | Fiscal 2026 | Jul | 9
 |  |  |  |  |  |  |  |  | B | B-1 | B-2 | Fiscal 2026 | Jul | 7
 |  |  |  |  |  |  |  |  | C | C-1 | C-2 | Fiscal 2026 | Jul | 9
 |  |  |  |  |  |  |  |  | D | D-1 | D-2 | Fiscal 2026 | Jul | 1
 |  |  |  |  |  |  |  |  | E | E-1 | E-2 | Fiscal 2026 | Jul | 1
 |  |  |  |  |  |  |  |  | F | F-1 | F-2 | Fiscal 2026 | Jul | 10
 |  |  |  |  |  |  |  |  | G | G-1 | G-2 | Fiscal 2026 | Jul | 10
 |  |  |  |  |  |  |  |  | H | H-1 | H-2 | Fiscal 2026 | Jul | 7
 |  |  |  |  |  |  |  |  | I | I-1 | I-2 | Fiscal 2026 | Jul | 7
Spreadsheet: 703501d1605023401-get-values-from-different-sheets-where-different-bits-of-data-values-match-chasing-values
Sheet: Sheet2

470316A.210 | 0
471605A.102 | 0
471649A.303 | 0
471851A.101 | 1
471881A.101 | 1
472063A.101 | 0
472181A.104 | 1
472182A.103 | 0
472221A.101 | 0
472291A.103 | 0
472301A.204 | 1
472311A.102 | 1
472454A.101 | 1
472509A.102 | 0
472510A.101 | 0
472573A.104 | 0
472579A.101 | 0
472580A.101 | 0
472649A.103 | 1
472748A.101 | 1
472797A.101 | 0
472810A.102 | 0
472821A.101 | 1
472823A.202 | 0
472839A.101 | 0
472870A.101 | 0
472924A.203 | 1
472930A.102 | 0
472956A.102 | 1
473095A.203 | 0
473096A.103 | 0
473098A.203 | 0
473288A.102 | 0
473303A.102 | 0
473842A.101 | 1
473879A.101 | 1
473881A.101 | 1
473937A.102 | 0
473952A.102 | 1
474052A.101 | 1
474090A.101 | 1
474278A.101 | 1
[NAME] | 0
474283A.101 | 1
474416A.101 | 0
474417A.101 | 1
474418A.101 | 1
474421A.101 | 1
474467A.101 | 1
474581A.101 | 1
[NAME] | 0