tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 28571d1222887357-filtering-w-formulas-xxx-sales
Sheet: 2008

 | Customer | Code | 2008 | % | Cumulative
 |  |  | thru Aug | of Sales | %
 |  |  | 1518783 | 0.4279358934262022 | 0.4279358934262022
 |  |  | 326025 | 0.09186157578421511 | 0.5197974692104173
 |  |  | 288485 | 0.08128421651747349 | 0.6010816857278908
 |  |  | 205355 | 0.05786131092758989 | 0.6589429966554806
 |  |  | 168901 | 0.04758994559168688 | 0.7065329422471675
 |  |  | 103124 | 0.02905646236077417 | 0.7355894046079416
 |  |  | 76743 | 0.02162328935022781 | 0.7572126939581695
 |  |  | 68638 | 0.01933960536362842 | 0.7765522993217979
 |  |  | 86736 | 0.02443894068620407 | 0.800991240008002
 |  |  | 75388 | 0.02124150134259768 | 0.8222327413505998
 |  |  | 60817 | 0.01713594188932938 | 0.8393686832399292
 |  |  | 43911 | 0.01237246730852134 | 0.8517411505484506
 |  |  | 43640 | 0.01229610970699531 | 0.8640372602554459
 |  |  | 48189 | 0.01357784671563697 | 0.8776151069710829
 |  |  | 37664 | 0.0106122978002812 | 0.8882274047713641
 |  |  | 35627 | 0.01003834785818337 | 0.8982657526295474
 |  |  | 38247 | 0.01077656526039069 | 0.9090423178899382
 |  |  | 37492 | 0.01056383467311339 | 0.9196061525630516
 |  |  | 33944 | 0.009564141794093697 | 0.9291702943571453
 |  |  | 33043 | 0.009310273901197208 | 0.9384805682583425
 |  |  | 21319 | 0.00600689190750305 | 0.9444874601658455
 |  |  | 21167 | 0.005964064027680335 | 0.9504515241935259
 |  |  | 15487 | 0.004363653781673612 | 0.9548151779751994
 |  |  | 15123 | 0.0042610922799929 | 0.9590762702551924
 |  |  | 13984 | 0.003940164943689791 | 0.9630164351988821
 |  |  | 14942 | 0.004210093291519798 | 0.9672265284904019
 |  |  | 11786 | 0.00332085126046395 | 0.9705473797508659
 |  |  | 9450 | 0.00266265437055696 | 0.9732100341214228
 |  |  | 10960 | 0.003088115545111564 | 0.9762981496665344
 |  |  | 8779 | 0.002473591822129053 | 0.9787717414886634
 |  |  | 8184 | 0.002305943213612504 | 0.981077684702276
 |  |  | 6411 | 0.001806378536469912 | 0.9828840632387459
 |  |  | 6365 | 0.001793417467576195 | 0.9846774807063221
 |  |  | 6165 | 0.001737064994125255 | 0.9864145457004474
 |  |  | 7071 | 0.001992341698858017 | 0.9884068873993054
 |  |  | 5165 | 0.00145530262687055 | 0.9898621900261759
 |  |  | 5280 | 0.001487705299104841 | 0.9913498953252807
 |  |  | 4368 | 0.00123073802016855 | 0.9925806333454493
 |  |  | 2077 | 0.0005852204367880217 | 0.9931658537822373
 |  |  | 1712 | 0.0004823771727400545 | 0.9936482309549773
 |  |  | 1572 | 0.0004429304413243958 | 0.9940911613963017
 |  |  | 1038 | 0.0002924693372103835 | 0.9943836307335121
 |  |  | 698 | 0.0001966701323437839 | 0.9945803008658559
 |  |  | 655 | 0.0001845543505518316 | 0.9947648552164078
 |  |  | 781 | 0.0002200564088259244 | 0.9949849116252337
 |  |  | 590 | 0.0001662397966802758 | 0.995151151421914
 |  |  | 414 | 0.0001166496200434478 | 0.9952678010419574
 |  |  | 392 | 0.0001104508479638443 | 0.9953782518899212
 |  |  | 310 | 8.734633384895846e-05 | 0.9954655982237702
 |  |  | 15943 | 0.004492137421141757 | 0.999957735644912
 |  |  | 150 | 4.226435508820571e-05 | 1
 |  |  | 3549090
Spreadsheet: 541917d1507628548-vlookup-with-dynamic-column-index-sample-file
Sheet: Sheet1

 | Week 34
 | Monday | Monday | Tuesday | Tuesday | Wednesday | Wednesday | Thursday | Thursday | Friday | Friday
Unique identifier | Early | Late | Early | Late | Early | Late | Early | Late | Early | Late
3031 | 3 | 4 | 3 | 5 | 7 | 6 | 7 | 3 | 3 | 2
3022 | 4 | 64 | 4 | 6 | 7 | 8 | 9 | 4 | 5 | 0
2392 | 0 | 2 | 4 | 5 | 45 | 4 | 2 | 3 | 6 | 1
..
..
3031
3022
2392
..
..
Spreadsheet: 232492d1367433360-how-to-use-buttons-to-lookup-data-then-calculate-output-sheet-metal-analysis-solution
Sheet: stainless bar

Bar Stock |  |  |  |  |  |  |  |  |  |  |  | with tax and surcharge |  |  |  | 30% mark up
thickness | width | length | lb/ft | est weight | price/pound | qty recvd | date ordered | $/ft | price/pc | total paid |  | $/ft | price/pc | total paid |  | $/ft | price/pc | total paid
0.1875 | 1 | 144 | 0.638 | 38.25 | 2.76 |  | 2012-08-15 00:00:00
0.1875 | 1.25 | 144 | 0.797 | 47.815 | 2.76 |  | 2012-08-15 00:00:00
0.125 | 1.5 | 144 | 0.638 | 38.25 | 2.76 |  | 2012-08-15 00:00:00
0.25 | 1.25 | 144 | 1.063 | 51.024 | 2.76 |  | 2012-08-15 00:00:00
0.25 | 2 | 144 | 1.7 | 81.6 | 2.76 |  | 2012-08-15 00:00:00
Angle |  |  |  |  |  |  |  |  |  |  |  | with tax and surcharge |  |  |  | 30% mark up
web | thickness | length | lb/ft | est weight | price/pound | qty recvd | date ordered | $/ft | price/pc |  |  | $/ft | price/pc | total paid |  | $/ft | price/pc | total paid
1.5 | 0.1875 | 264 | 1.8 | 198 | 2.5 |  | 2012-08-15 00:00:00
1.5 | 0.25 | 264 | 2.34 | 154 | 2.5 |  | 2012-08-15 00:00:00
2 | 0.1875 | 264 | 2.44 | 161.04 | 2.5 |  | 2012-08-15 00:00:00
RND |  |  |  |  |  |  |  |  |  |  |  | with tax and surcharge |  |  |  | 30% mark up
 | diameter | length | lb/ft | est weight | price/pound | qty recvd | date ordered | $/ft | price/pc |  |  | $/ft | price/pc | total paid |  | $/ft | price/pc | total paid
 | 0.5 | 144 | 0.668 | 200.31 | 2.5 |  | 2012-08-15 00:00:00
 | 0.375 | 144 | 0.376 | 45.072 | 2.65 |  | 2012-08-15 00:00:00
 | 0.25 | 144 | 0.167 | 10 | 2.65 |  | 2012-08-15 00:00:00
Spreadsheet: 0e945ffa-a57b-482c-9381-424b6c10af53
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-12-18 09:28:16.850000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5 | 102.625 | 102.5 | 102.375 | 102 |  | and are added to price quote
4.875 | 102.497 | 102.372 | 102.247 | 101.872
4.75 | 101.986 | 101.861 | 101.736 | 101.361 |  | Note: | Refer To Price [NAME]
4.625 | 101.215 | 101.09 | 100.965 | 100.59 |  |  | For all Price Adjs
4.5 | 100.25 | 100.125 | 100 | 99.375
4.375 | 99.236 | 99.111 | 98.986 | 98.361
4.25 | 98.635 | 98.51 | 98.385 | 97.76
4.125 | 97.785 | 97.66 | 97.535 | 96.91
4 | 96.725 | 96.6 | 96.475 | 95.85 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.599 | 102.474 | 102.349 | 101.974
3.875 | 101.842 | 101.717 | 101.592 | 101.217
3.75 | 101.163 | 101.038 | 100.913 | 100.538
3.625 | 100.746 | 100.621 | 100.496 | 100.121
3.5 | 100.206 | 100.081 | 99.956 | 99.331
3.375 | 99.414 | 99.289 | 99.164 | 98.539
3.25 | 98.644 | 98.519 | 98.394 | 97.769 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-01-01 09:28:16.850000
30 DAY | 2014-01-16 09:28:16.850000
45 DAY | 2014-01-31 09:28:16.850000
60 DAY | 2014-02-15 09:28:16.850000
90 DAY | 2014-03-17 09:28:16.850000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: louise_kitchen__22723__PTypes and Sigmas
Sheet: Sheet1

Product Type | Product Type ID | Sigma Factor
Canada Financial Gas
CAN Gas Fin BasSwap | 1062 | 0.01 | 1
CAN Gas Fin BasSwap East | 1280 | 0.01 | 2
CAN Gas Fin Swap | 1063 | 0.2 | 3
CAN Gas Fin Swap East | 1278 | 0.2 | 4
CAN Gas Straddle Option | 2021 | 0.36 | 5
Canada Physical Gas
CAN Gas Phy Basis East Spd <or= 1Mo | 2131 | 0.1 | 6
CAN Gas Phy Basis East Spd > 1 Mo | 2132 | 0.1 | 7
CAN Gas Phy Fwd Firm East <or= 1Mo | 1179 | 0.2 | 8
CAN Gas Phy Fwd Firm West <or= 1Mo | 1182 | 0.2 | 9
CAN Gas Phy Fwd Firm West > 1 Mo | 1183 | 0.2 | 10
CAN Gas Phy Index Firm East <or= 1Mo | 1184 | 0.2 | 11
CAN Gas Phy Index Firm East > 1 Mo | 2115 | 0.2 | 12
CAN Gas Phy Index Firm West <or= 1Mo | 1186 | 0.2 | 13
CAN Gas Phy Index Firm West > 1 Mo | 1187 | 0.2 | 14
Canada Financial Power
CAN Power Fin Swap | 1916 | 3.23 | 15
US Financial Power
US East Power Fin Spd | 2127 | 12.85 | 16
US East Power Fin Swap | 1273 | 8.161 | 17
US West Pwr Fin Swap | 1315 | 18.647 | 18
US West Pwr Fin Swap CAISO | 1314 | 18.647 | 19
US Physical Power
US East Power Phy Fwd Firm (LD) | 1071 | 8.161 | 20
US East Power Phy ICAP | 2205 | 8.161 | 21
US East Power Phy Index | 1889 | 8.161 | 22
US East Power Phy LD Call Opt | 2111 | 9.15875 | 23
US East Power Phy LD Put Opt | 2112 | 9.15875 | 24
US East Power Phy Spd | 2083 | 8.161 | 25
US West Power Phy Fwd CAISO | 1115 | 18.647 | 26
US West Power Phy Fwd Firm | 1114 | 18.647 | 27
US West Power Phy Index [NAME] | 1272 | 18.647 | 28
US West Power Phy Index Firm | 1256 | 18.647 | 29
US West Power Phy Spd | 1242 | 18.647 | 30
US Financial Gas
US Gas Daily FIN OPT (Floating Strike) | 1970 | 0.25 | 31
US Gas Fin BasisSwap | 1091 | 0.01 | 32
US Gas Fin Opt Call | 1921 | 0.25 | 33
US Gas Fin Opt Put | 1920 | 0.25 | 34
US Gas Fin Spread | 1977 | 0.1 | 35
US Gas Fin Swap | 1089 | 0.25 | 36
US Physical Gas
US Gas Phy Fwd Firm <or= 1Mo | 1117 | 0.25 | 37
US Gas Phy Index Firm <or= 1Mo | 1123 | 0.25 | 38
US Gas Phy Index Firm > 1 Mo | 1125 | 0.25 | 39
Spreadsheet: 137673d1327314942-conditional-formatting-help-excel-help1
Sheet: REFFERED BY

NAME | ADDRESS | CONTACT NO. | REFERRED BY | COST | LETTER SENT OUT | LETTER RECEIVED | PAID | DATE | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21
Spreadsheet: 118219d1313537698-excel-2007-calculate-using-values-in-column-with-todays-date-sampleworksheet
Sheet: Sheet1

Re-order point | Plus 1Week | Minus 1Week | Product | Per week | Per month | Week Supply | PO In Place | 2011-07-29 00:00:00 | 2011-08-01 00:00:00 | 2011-08-02 00:00:00 | 2011-08-03 00:00:00 | 2011-08-04 00:00:00 | 2011-08-05 00:00:00 | 2011-08-08 00:00:00 | 2011-08-09 00:00:00 | 2011-08-10 00:00:00 | 2011-08-11 00:00:00 | 2011-08-12 00:00:00 | 2011-08-15 00:00:00 | 2011-08-16 00:00:00 | 2011-08-17 00:00:00 | 2011-08-18 00:00:00 | 2011-08-19 00:00:00 | 2011-08-22 00:00:00 | 2011-08-23 00:00:00 | 2011-08-24 00:00:00 | 2011-08-25 00:00:00
4350.5 |  |  | [NAME] |  | 1740.2 |  | 540 | 3542 |  |  |  |  |  | 8148
2911.4 |  |  | AC90 |  | 1164.56 |  | 540 | 2067 |  |  |  |  |  | 1633
288.96 |  |  | APP |  | 144.48 |  |  | 269 |  |  |  |  |  | 744
14752 |  |  | AR150 |  | 3688.32 |  | 562 | 11920 |  |  |  |  |  | 10662
9536 |  |  | AR90 |  | 2383.04 |  | 562 | 8869 |  |  |  |  |  | 8201
318.4 |  |  | BF45 |  | 79.6 |  |  | 602 |  |  |  |  |  | 555
429.8 |  |  | BG |  | 171.92 |  | 530 | 192
478.4 |  |  | GS90 |  | 191.36 |  |  | 949 |  |  |  |  |  | 866
3253.92 |  |  | HASF 1 oz |  | 813.48 |  |  | 4071 |  |  |  |  |  | 3734
2848 |  |  | HASF 2 oz |  | 712 |  |  | 4330
1288.16 |  |  | [NAME] |  | 322.04 |  |  | 2186
485.6 |  |  | HSN100 |  | 194.24 |  | 559 | 440 |  |  |  |  |  | 332
170.7 |  |  | IH90 |  | 68.28 |  |  | 688 |  |  |  |  |  | 666
71 |  |  | LSA45 |  | 28.4 |  |  | 223 |  |  |  |  |  | 204
1302.08 |  |  | NS45 |  | 325.52 |  | 550 |  |  |  |  |  | 2711 | 2591
7762.4 |  |  | SASF150 |  | 3104.96 |  | 554 | 7642 |  |  |  |  |  | 6484
4890.1 |  |  | SASF90 |  | 1956.04 |  | 554 | 7939 |  |  |  |  |  | 7207
331.2 |  |  | SISS |  | 82.8 |  |  | 1135 |  |  |  |  |  | 1074
319.9 |  |  | SQ180 |  | 127.96 |  | 543 | 77 |  |  |  |  |  | 35
509.2 |  |  | SQ90 |  | 203.68 |  | 543 | 101 |  |  |  |  |  | 22
168.08 |  |  | TB |  | 336.16 |  |  | 33 |  |  |  |  |  | 2
621.48 |  |  | Book |  | 621.48 |  |  | 1646
Spreadsheet: 726735d1617390874-convert-text-days-hours-minutes-to-total-hours-019-get-day-hour-minute-second-from-text
Sheet: HMS

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | i |  |  | ard
Data | [h]:mm:ss
2 Hours 3 Minutes 40 Seconds
1 Hour 45 Minutes 56 Seconds
20 Hours 5 Minutes
5 Minutes
10 hours 1 seconds
25 Minutes 50 seconds
5 seconds
200 Hours 3 Minutes 40 Seconds
1 Hour 45 Minutes 56 Seconds
20 Hours 5 Minutes
5 Minutes
10 hours 1 seconds
25 Minutes 50 seconds
5 seconds
Spreadsheet: 825232d1681200451-query-title-based-on-two-conditions-20230411
Sheet: Sheet1

 |  |  |  |  |  |  | query form
Classification | percentage | result |  |  |  |  | Classification | Business warning | Empty warning
A | 0.1317262942812781 | Business warning |  |  |  |  | A | 0.1 | 0.2
C | 0.08205451593296699 |  |  |  |  |  | B | 0.2 | 0.35
E | 0.07883317202853518 |  |  |  |  |  | C | 0.2 | 0.3
B | 0.35 | Empty warning |  |  |  |  | D | 0.12 | 0.25
B | 0.1655187897035272 |  |  |  |  |  | E | 0.3 | 0.4
C | 0.2417552443339675 | Business warning
D | 0.1811696881060994 | Business warning
Spreadsheet: 876489d1723191018-taking-average-value-from-cells-sample
Sheet: Sheet1

 | DIST | Value X | Value Y | [NAME] | [NAME]
 | A | 33.0124565 | 24.51256
 |  | 33.0124566 | 24.51257
 |  | 33.0124567 | 24.51258
 |  | 33.0124568 | 24.51259
 |  | 33.0124569 | 24.5126
 |  | 33.012457 | 24.51261
 | B | 44.51546 | 55.45756
 |  | 44.51545 | 55.45757
 |  | 44.51544 | 55.45758
 |  | 44.51543 | 55.45759
 |  | 44.51542 | 55.4576
 |  | 44.51541 | 55.45761
 |  | 44.5154 | 55.45762
 |  | 44.51539 | 55.45763
 |  | 78.45784 | 66.78457
 | C | 78.45785 | 66.78456
 |  | 78.45786 | 66.78455
 |  | 78.45787 | 66.78454
 |  | 78.45788 | 66.78453
 |  | 78.4578899999999 | 66.78452
 |  | 78.4578999999999 | 66.78451
 | End
Spreadsheet: 375968d1423426808-show-certain-detailed-data-from-other-sheet-ef683a_pulling-data-reporting-formula
Sheet: Data

Data will be updated monthly
Customers | Location Of Plant | State | Channel | Products | Sales | Price List | Rebate | Trspt Rebate |  | unique_rec |  | State |  | 0
LC Co | PJ Plant | Selangor & FT | RMX | OPC | 1000 | 400 | 50 | 15 |  |  |  | Selangor & FT
LC Co | [NAME] | [NAME] | RMX | Bag | 2000 | 300 | 40 | 10 |  |  |  | [NAME]
LC Co | Puchong | Melaka | RMX | LH | 300 | 250 | 30 | 10 |  |  |  | Melaka
BUILDCON | Kuchai Lama | Selangor & FT | IU | OPC | 400 | 400 | 50 | 15 |  |  |  | N Sembilan
BUILDCON | [NAME] 9 | Melaka | IU | OPC | 600 | 250 | 50 | 10 |  |  |  | All States
BUILDCON | [NAME] | Selangor & FT | IU | Bag | 700 | 400 | 40 | 15
BUILDCON | [NAME] ([NAME]) | N Sembilan | IU | Bag | 2000 | 200 | 40 | 20
UPC | [NAME] | Selangor & FT | Precast | LH | 400 | 400 | 30 | 15
UPC | [NAME] | [NAME] | Precast | OPC | 1000 | 300 | 50 | 10
UPC | [NAME] | Selangor & FT | Precast | OPC | 300 | 400 | 50 | 15
UPC | [NAME] | Selangor & FT | Precast | LH | 100 | 400 | 30 | 15
UPC | [NAME] | N Sembilan | Precast | LH | 100 | 200 | 30 | 20
UPC | Puncak Alam | Melaka | Precast | Bag | 200 | 250 | 40 | 10
Spreadsheet: 816624d1675747791-how-do-i-stack-multiple-columns-into-one-column-in-excel-365-mac-2d-to-1d-list
Sheet: Sheet2

[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | Mark | [NAME]
[NAME] | [NAME] | George
Spreadsheet: 863116d1710680934-average-top-5-values-between-two-dates-book1
Sheet: Sheet1

Date | Value |  |  |  | Top 5 Avg | Bottom 5 Avg
2023-04-01 00:00:00 | 12 |  | 2023-04-01 00:00:00 | 2023-04-30 00:00:00
2023-04-04 00:00:00 | -13 |  | 2023-05-01 00:00:00 | 2023-05-31 00:00:00
2023-04-07 00:00:00 | 45 |  | 2023-06-01 00:00:00 | 2023-06-30 00:00:00
2023-04-10 00:00:00 | -78 |  | 2023-07-01 00:00:00 | 2023-07-31 00:00:00
2023-04-13 00:00:00 | 18
2023-04-16 00:00:00 | -7
2023-04-19 00:00:00 | -15
2023-05-10 00:00:00 | 165
2023-05-13 00:00:00 | -40
2023-05-16 00:00:00 | -16
2023-05-19 00:00:00 | 684
2023-05-22 00:00:00 | 56
2023-05-25 00:00:00 | 498
2023-05-28 00:00:00 | 165
2023-05-31 00:00:00 | 61
2023-06-03 00:00:00 | 16
2023-06-06 00:00:00 | 53
2023-06-09 00:00:00 | 1
2023-06-12 00:00:00 | -25
2023-06-15 00:00:00 | 4
2023-06-18 00:00:00 | 6
2023-06-21 00:00:00 | 243
2023-06-24 00:00:00 | 5436
2023-07-21 00:00:00 | 1268
2023-07-24 00:00:00 | 891
2023-07-27 00:00:00 | -62
Spreadsheet: 708015d1607588214-populating-a-cell-in-excel-using-formulas-test
Sheet: PrePopulates

Site | Town | Post Code | Lat | Long | type
Manor Gardens |  |  |  |  | Shrub | want a formula where if I had in the site and feature it picks up the postcode, lat, long, town from the data tab
Spreadsheet: mary_hain__25863__Data_Response_DS_SP_001
Sheet: With Rev Aug After Adj

 | Regional Cost to Serve DSI Load
# of DSI Jobs | 7000
 | Market Price
Table 1: Regional Augmentation Costs With and Without DSI Load
Avg 5 Year Augmentation Price | $123.8/MWh |  | $91.8/MWh |  | $70.5/MWh
 | FY2002 | 5 yr Avg | FY2002 | 5 yr Avg | FY2002 | 5 yr Avg
With DSI Load
Without DSI Load
Difference
Subsidy per DSI Job per year
Table 3: Cost per SUB customer to subsidize DSI Sales - with IP TAC CRAC
Avg 5 Year Augmentation Price | $123.8/MWh |  | $91.8/MWh |  | $70.5/MWh
 | FY2002 | 5 yr Avg | FY2002 | 5 yr Avg | FY2002 | 5 yr Avg
Cost to 70 aMW Utility (70 aMW of BPA Subscription Purchases)
With DSI Load
Without DSI Load
Difference
Cost by Customer                  (Utility Cost / 28,233)
With DSIs
No DSI Load
DSI Subsidy paid by each utility customer per year
Cost Calculations:
PF rates after the application of the LB CRAC are multiplied by (70 aMW x 8760 hours per year) to calculate utility costs
Under the $123.8/MWh scenario, the FY2002 PF Rate after the LB CRAC is $89.58/MWh (see Attachment 1C "Augmentation Calculation with IP TAC CRAC" Tables)
$89.58 x 70 x 8760 = $54,930,456
Spreadsheet: 756029d1637247339-looking-up-data-in-a-range-and-adding-up-together-book4
Sheet: JFS

 |  |  |  |  |  |  | a | b | c | d | e | f | g | h | i | j | k | l | l
 |  | DROP DOWN MENUE
 |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00
 | 2021-01-01 00:00:00
 | 2021-02-01 00:00:00 |  | a | b | c | d | e | f | g | h | i | j | k | l | M
 | 2021-03-01 00:00:00 | Referrals
 | 2021-04-01 00:00:00 | Starts
 | 2021-05-01 00:00:00 | Referrals to Starts Ratio
 | 2021-06-01 00:00:00
 | 2021-07-01 00:00:00
 | 2021-08-01 00:00:00
 | 2021-09-01 00:00:00
 | 2021-10-01 00:00:00
 | 2021-11-01 00:00:00
 | 2021-12-01 00:00:00
Spreadsheet: darron_c_giron__7977__midland_cogen
Sheet: firm9906

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1999-06-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.14 |  |  | No. of Days: | 30
IFGMR (TRKL/LA) |  |  | 2.16
IFGMR (PEPL/TX/OK) |  |  | 2.12
IFGMR (ANR/LA) |  |  | 2.16
IFGMR (HENRY HUB) |  |  | 2.23
NX3 |  |  | 2.20067
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* (TX) |  | 2.5
TRIGGER* (LA) |  | 2.5
DIFFERENTIAL (TX)
DIFFERENTIAL (LA)
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: 144958d1331224595-how-do-i-sort-linked-data-by-name-in-a-spreadsheet-league-leaders
Sheet: Sheet3

 | League Leaders
 |  | Individual Stats Season Totals
 | Passing |  |  |  |  |  |  |  |  |  | Receiving |  |  |  |  |  | Rushing |  |  |  |  |  |  | Kicking |  |  |  |  | Defense
 | Player | Attempts | Completions | Pass % | Yards | Inc | INT | TDS | QB Rating |  | Player | Receptions | Yards | Yrds/catch | TDS |  | Player | Carries | Yards | Yrds/Carry | FMBL | TDS |  | Player | FLD Goal | 1xp | 2xp |  | Player | Tackles | Sacks | INT | Fumbles Caused | [NAME] | Defensive TD
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
Spreadsheet: 57545d1257768448-or-function-example
Sheet: Sheet2

 |  |  |  |  |  | ROW# | DealCount | Sold | Customer | Deal# |  |  | Type | Stock# | Yr | Model | Comm Gross | Sales1 Comm | Sales1 | Sales1 | Sales2 | Sales2
Salesperson Name
Salesperson Number
New
Used
Total
Comm. Gross
Total Gross
Commissions
Gross Bonus
Unit Bonus
Demo Bonus
Total Pay
Ranking
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
Spreadsheet: 843064d1695036837-need-formula-for-logistics-sheet-logistics-tracker-format-sample
Sheet: 2023-24

Date of Dispatch | TAT | ETA | Left NCR HUB Date | Reach HUB Date | Reach Dest City Date | Date of Delivery | Courier Performance | Status
2023-09-16 00:00:00 | 10 |  | 2023-09-18 00:00:00 | 2023-09-26 00:00:00 | 2023-09-26 00:00:00 | 2023-09-26 00:00:00
2023-09-11 00:00:00 | 10 |  | 2023-09-14 00:00:00 | 2023-09-20 00:00:00 | 2023-09-20 00:00:00 | 2023-09-22 00:00:00
 |  |  | 0-48 Hrs | 50-70 % of TAT | ETA -1 | Same as ETA
Spreadsheet: 752235d1634659752-vlookup-stops-working-after-several-rows-po-workbook
Sheet: 4th CO - 

13-005 NFCU AUDITORIUM EXPANSION
Owner Direct Purchase Summary Log
PO # | VENDOR | CONTRACTOR | PREVIOUSLY TAXED (NET AMT) | 2017-01-26 00:00:00 |  | CURRENT SUBTOTAL | nontx | nontx | nontx | NON TAXABLE | TAXABLE | TOTAL TAXES | TOTAL CO
 |  | subtotals
 |  | Total Previously Invoiced |  |  |  |  |  |  |  | TOTAL CHANGE ORDER AMOUNT