tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: joe_parks__14610__POSTIONTRAX_NOV
Sheet: DEC_SWAP

 | SELL |  |  |  | BUY
BEGINNING | 48 | 2.96 |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  | 46.5 | 2.97 |  |  |  |  | ROLLOFF VAULE
 | 31 | 2.875 |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  |  |  |  |  |  | 17500
 |  |  |  |  |  |  |  |  |  |  |  | 20000
 |  |  |  |  |  |  |  |  |  |  |  | 25000
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 687079d1594948266-formula-on-how-to-get-the-sum-of-specific-criteria-formula-on-how-to-get-the-sum-of-specific-criteria
Sheet: Sheet1

Raw data
 | Quantity | Value | Remarks
 | 1 | 2 | On hand
 | 4 | 21 | Scrapped
 | 2 | 4 | On hand
 | 5 | 4 | Scrapped
 | 1 | 46 | [NAME]
 | 11 | 146 | On hand
 | 2 | 3 | On hand
 | 3 | 5 | On hand
Output desire
 | Remarks | Qty. | Value
 | On hand | 19 | 160
 | Scrapped | 9 | 25
 | [NAME] | 1 | 46
Spreadsheet: james_steffes__12919__2000 Control Area Peaks
Sheet: Sheet1

Region | Company | 2000 MW Peak
ECAR
 | First Energy | 12079
 | Cinergy | 10699
 | Detroit Edison | 10919
 | Consumers Energy | 7306
 | AEP | 19167
 | Allegheny Power | 7791
 | LGE | 6317
VACAR
 | CPL | 11547
 | Duke | 18773
 | VEPCO | 15464
 | SCEG | 4211
 | SCPS | 3876
MAIN & MAPP
 | Alliant East | 2668
 | Alliant West | 3509
 | Ameren | 11073
 | ComEd | 20143
 | Illinois Power | 3472
 | Wisconsin Elec Power | 5849
 | Wisconsin Public Service | 2064
 | NSP (Xcel) | 7936
Spreadsheet: 8e8d4372-4ba0-45af-99bd-06108c58b87f
Sheet: Sheet1

The text as it appears below, will be reflected in the printed student award certificates. The accompanying guide will assist in accurately completing the required data | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Diamond | Gold | Silver | [NAME] | Encouragement | Total
0 | 0 | 0 | 0 | 0 | 0
Enter School Name Here
First Name | Surname | Roll Class/Team | [NAME] | School Name | School Type
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Moxey

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 34670d1231977452-lookup-or-index-dealer-selection
Sheet: Presentation

DEALER |  | STYLE | BOX COUNT | DOLLARS
84 LUMBER STORE#0811 |  | RUTLAND II | 4 | 356.44
 |  | SENECA RIDGE CHERRY | 2 | 376.66
 |  | SUTTON CLIFF MAPLE | 2 | 397.19
 |  | ENFIELD | 3 | 421.54
CONCEPT KITCHEN DESIGN |  | PORTRAIT MAPLE | 3 | 354.77
 |  | SUTTON CLIFF MAPLE | 1 | 356.11
ANDERSONVILLE KITCHEN & BATH |  | 0 | 0 | 0
 |  | 0 | 0 | 0
 |  | 0 | 0 | 0
 |  | 0 | 0 | 0
GALACTIC TECH INC |  | SPRING VALLEY CHERRY | 2 | 323.48
Spreadsheet: 679053d1590164872-creating-a-dynamic-list-example-list
Sheet: Example

Supplier | Count |  |  |  |  | Count | Supplier
[NAME] | 7 |  |  |  |  | 1 | [NAME]
Fred | 2 |  |  |  |  | 2 | [NAME]
[NAME] | 4 |  |  |  |  | 3 | [NAME]
[NAME] | 1 |  |  |  |  | 4 | [NAME]
[NAME] | 3 |  |  |  |  | 5 | [NAME]
 |  |  |  |  |  | 6 | [NAME]
 |  |  |  |  |  | 7 | [NAME]
 |  |  |  |  |  | 1 | Fred
 |  |  |  |  |  | 2 | Fred
 |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  | 2 | [NAME]
 |  |  |  |  |  | 3 | [NAME]
 |  |  |  |  |  | 4 | [NAME]
 |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  | 2 | [NAME]
 |  |  |  |  |  | 3 | [NAME]
Spreadsheet: 874697d1721232856-if-function-to-compare-multiple-tabs-rswlaw67-bills-by-pay-cycle
Sheet: Bills

[NAME] | Amount | Day of the Month Due | Pay Cycle
Amazon Prime | 15.62 | 1
HIDIVE | 5.99 | 29
Boomerang | 5.99 | 14
Pokemon | 2.99 | 14
Cricut | 9.99 | 15
[NAME] | 12.95 | 15
Crunchyroll | 11.99 | 12
Ribblr | 6.99 | 12
Storage Unit | 111 | 1
Discord | 10.41 | 8
Spotify | 11.99 | 5
InstantInk | 5.2 | 5
Patreon 1 | 25.23 | 1
[NAME] | 14.99 | 27
Epic | 11.99 | 27
Student Loan | 61.54 | 24
Patreon 2 | 10 | 24
Apple TV | 9.99 | 15
iCloud | 2.99 | 28
Snapchat+ | 3.99 | 29
Peacock Premium | 5.99 | 26
Spreadsheet: 218775d1362576970-reorganize-data-sample-excel-forum-option-2
Sheet: Number of shares

Name | VOLKSWAGEN PREF. - NUMBER OF SHARES | ENI - NUMBER OF SHARES | DAIMLER - NUMBER OF SHARES | SIEMENS - NUMBER OF SHARES
Code | DE0007664039(NOSH) | IT0003132476(NOSH) | DE0007100000(NOSH) | DE0007236101(NOSH)
2002 | 34 | 78 | 122 | 166
2003 | 35 | 79 | 123 | 167
2004 | 36 | 80 | 124 | 168
2005 | 37 | 81 | 125 | 169
2006 | 38 | 82 | 126 | 170
2007 | 39 | 83 | 127 | 171
2008 | 40 | 84 | 128 | 172
2009 | 41 | 85 | 129 | 173
2010 | 42 | 86 | 130 | 174
2011 | 43 | 87 | 131 | 175
2012 | 44 | 88 | 132 | 176
Spreadsheet: 718821d1613375251-help-me-time-sheet-in-out-timing-total-hours-ru
Sheet: FEB-2021

 |  |  |  |  |  | Attendence [NAME] الحضور
فبراير |  |  | شهر: |  | 2021
February |  |  | MORNING صباح |  | AFTER NOON بعد الظهر
SIGNATURE | REMARK | TOTAL HRS | OUT | IN | OUT | IN | REMARK | DATE
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-01 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-02 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-03 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-04 00:00:00
 | FRIDAY |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-05 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-06 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-07 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-08 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-09 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-10 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-11 00:00:00
 | FRIDAY |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-12 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-13 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-14 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-15 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-16 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-17 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-18 00:00:00
 | FRIDAY |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-19 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-20 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-21 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-22 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-23 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-24 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-25 00:00:00
 | FRIDAY |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-26 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-27 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00 |  | 2021-02-28 00:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00
 |  |  | 05:00:00 | 02:00:00 | 11:30:00 | 07:00:00
 | TOTAL HRS
Spreadsheet: mark_taylor__24701__epgofferanalysis (11-21-00)
Sheet: Summary

El Paso Offer Analysis
($000's except where noted)
Inputs |  |  |  |  |  |  |  | Sensitivity Analysis - 7 years
Deferred Payment Discount Rate |  |  |  |  |  | 0.085 |  | Discount Rate |  |  | 0.08 | 0.0825 | 0.085 | 0.0875 | 0.09 | 0.0925 | 0.095
Issue Date |  |  |  |  |  | 2000-12-15 00:00:00 |  | Enron Profit (Loss) (c) |  |  |  | 9407.96813145929 | 7934.009175430153 | 6479.534415086275 | 5044.219497816398 | 3627.746424940399 | 2229.803410098236
Contingent Payment Discount Rate |  |  |  |  |  | 0.116
Expenses as a % of Total Offering |  |  |  |  |  | 0.001875 |  | 10bps
Placement Fee as a % of Total Offering |  |  |  |  |  | 0.005
JEDI II Placement Advisory Fee |  |  |  |  |  | 0.005
JEDI II M&A Advisory fee |  |  |  |  |  | 3000 |  | Offering Price Analysis
JEDI II Carrying Value |  |  |  |  |  | 202212 |  | Discount Rate
Subordinated Note Carrying Value |  |  |  |  |  | 157900 |  | Offering Proceeds |  |  |  | 350553.4556413847 | 347599.9999999987 | 344685.5859529729 | 341809.5635764772 | 338971.2956784163 | 336170.1575146751
Initial Deferred Payment (7 years - 27 payments) |  |  |  |  |  | 14275.20886589462 |  | Implied Coupon
Contingent Payment $/kw (Linden Only - 678MW) |  |  |  |  |  | 38.5
2001 Contingent Payment
Transaction Analysis
 |  |  |  |  |  | [NAME] | SubNotes | Total
Deferred Payments
 | Gross Proceeds (a)
 | [NAME] thru 15-Dec
 | Allocation of Gross Proceeds
 | [NAME] thru 15-Dec (b) |  |  |  |  | 0
 | Placement Fees
 | Placement Advisory Fee |  |  |  |  |  | 0
 | M&A Advisory Fee |  |  |  |  |  | 0
 | Expenses
 | Net Proceeds
Contingent Payments
 | Probability Adjusted |  |  | no |  |  | 0
Transaction Value
Enron
 |  |  |  |  |  | [NAME] | SubNotes | Total
50% JEDI II
Carrying Value
Placement Advisory Fee Income |  |  |  |  |  |  | 0
M&A Advisory Fee Income |  |  |  |  |  |  | 0
Profit (Loss) (c)
(a)  Proceeds to be prorated to reflect [NAME] share of accrued interest on SubNotes through closing.
(b)  To be paid in cash by [NAME] at closing.
(c)  Includes interest income on the SubNotes for the period through closing (assumed to be 15-Dec-00 or $3,521).
Spreadsheet: 390286d1429585904-need-formula-to-calculate-if-date-is-within-range-calculate-if-date-is-within2
Sheet: Data

Category 1 | Category 2 | Total Cost | Start Date | End Date | # Months |  | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00 | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00
Labor | Internal | 5000 | 2015-02-01 00:00:00 | 2015-03-30 00:00:00 | 2
Labor | External | 5000 | 2015-02-01 00:00:00 | 2016-01-31 00:00:00 | 12
Labor | Internal | 5000 | 2015-03-01 00:00:00 | 2016-06-30 00:00:00 | 16
Hardware | Server | 20000 | 2015-12-01 00:00:00 | 2019-02-28 00:00:00
Hardware | Maintenance | 37336.95 | 2019-03-01 00:00:00 | 2019-12-31 00:00:00
Labor | External | 25000 | 2015-12-01 00:00:00 | 2016-06-30 00:00:00
Hardware | Server | 45000 | 2015-06-01 00:00:00 | 2019-02-28 00:00:00
Hardware | Maintenance | 50000 | 2019-03-01 00:00:00 | 2019-05-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(AND(F$1>=$B2,F$1<$C2),$A2/$D2,0)
Spreadsheet: 135887d1326293373-sumif-and-with-a-filter-excel-upload-paste-into-pivot-table
Sheet: Pivot £

 | Client | ALM
Sum of £ | Sum of £
Type | Type | Description | Total
Press Cuttings/Media Monitoring | Press Cuttings/Media Monitoring | Default 192 | 132.03
Press Cuttings/Media Monitoring |  | Default 193 | 94.07
Press Cuttings/Media Monitoring |  | Default 198 | 7
Travel | Travel | Default 194 | 50.88
Entertainment | Entertainment | Default 195 | 50.29
Entertainment |  | Default 196 | 42.75
Grand Total | Grand Total |  | 377.02
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Grand Total
Spreadsheet: 818635d1676980801-figure-weight-when-seeing-space-1919-stone-weights
Sheet: BOL

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS SHIPPED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEIGHT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ESTIMATED
 |  | PCS | MARK |  |  |  | PCS | MARK |  |  |  | PCS | MARK |  |  |  | PCS | MARK |  |  |  | PCS | MARK
 |  | SKID 1
 |  | 1 | add
 |  | 1 | ref
 |  | 1 | rep
 |  | SKID 2
 |  | 1 | S BASE
 |  | 1 | S CAP
 |  | 1 | BAND
 |  | 1 | RAIL
 |  | 1 | BASE
 |  | SKID 3
 |  | 1 | RF
 |  | 1 | add
 |  | NOTE: USE EXTREME CARE IN UNLOADING AND HANDLING STONE.  This company will make no allowances
 |  | for, nor replace any damaged stone if it is unloaded without first securing acknowledgement of damage by the Receiving Freight
 |  | Agent (or Motor Freight Carrier) noted on the packing list, giving extent of loss and stone numbers.  Replacement stones will be
 |  | furnished only upon your written order.
 |  | RECEIVED AND ACKNOWLEDGED BY:______________________________________________
Spreadsheet: 110167d1306925607-search-and-delete-from-two-lists-book1-headings
Sheet: Book1

Salutation | First Name | Last Name | Job Title | Street 1 | Street 2 | Street 3 | City | ZIP/Postal Code | Country/Region | Home Phone | [NAME] | Other Phone | E-mail | Company Name | Industry | Annual Revenue | No. of Employees | Description | Business Phone | Web Site | E-mail Address 3 | Currency | Topic
Spreadsheet: 139681d1328379030-if-function-with-cells-containing-formulas-050
Sheet: External Gutter Capacity

External Gutter Capacity Calculations |  |  | Date: | #N/A
AS PER E1/VM1 & AS1  Section 5
Job Number: | #N/A
Client: | #N/A
Site Address: | #N/A
Designer: | #N/A
(Based on a rainfallfall intensity of 100mm) | 100 |  |  | 100 | [NAME]
Maximum Area of Catchment: (m²) | 64 |  |  | 6400 | mm²
[NAME]: (degrees) |  | 1
Adjust Roof by [NAME] Factor: | 1.1 |  |  | 7040.000000000001 | mm²
Rainfall Intensity: (mm p/h) | 5100 | 8
Adjust Roof by Rainfall Intensity Factor: | 1.3 |  |  | 9152.000000000002 | mm²
 | TOTAL REQUIRED: |  |  | 9152.000000000002 | mm²
Gutter Selection: |  | 1 |  |  | 1
 | TOTAL ACHIEVED: |  |  | 5100 | mm²
 | SUMMARY: |  |  | pass
 | 9152.000000000002 |  |  | 5100
Downpipe design as per NZBC clause E1 Table 5
74mm dia. Pipe,  [NAME]°, [NAME]. Load to any pipe < 85m².
Spreadsheet: 158368d1338203454-depentent-fropdown-list-with-some-specifice-features-book2
Sheet: BLFLNG

Blind Flange
Tool No. | Bottom Connection | Top Connection | Pressure Rating | Cert. date
AWS - 44433 | 1/2" NPT Box | 2-1/16" 10K BX-152 |  | 2012-05-08 00:00:00
AWS - 44434 | 1/2" NPT Box | 3-1/16" 10K BX-154 |  | 2012-05-08 00:00:00
AWS - 44435 | 1/2" NPT Box | 4-1/16" 10K BX-155 |  | 2012-05-08 00:00:00
AWS - 44436 | 1/2" NPT Box | 5-18" 10K BX-169 |  | 2012-05-08 00:00:00
Spreadsheet: 831703d1685835796-formular-to-call-data-from-another-sheet-5-and-6-ask-new-vrs
Sheet: NAFASI YA SHULE

HALAMASHAURI [NAME]KITETO
B) MPANGILIO WA UFAULU WA SHULE ZOTE KWA KIGEZO CHA WASTANI WA ALAMA  DRS VI 2023
NA | SHULE | WALIOFANYA |  |  | WALIOFAULU |  |  | A |  |  | B |  |  | C |  |  | % WALIOFAULU | WASTANI WA ALAMA | D |  |  | E |  |  | % WALIOFELI | DARAJA
 |  | Wav | Was | Jml | Wav | Was | Jml | Wav | Was | Jml | Wav | Was | Jml | Wav | Was | Jml |  |  | Wav | Was | Jml | Wav | Was | Jml
1 | [NAME]
2 | Ndilali
3 | [NAME]
94
JUMLA KUU
 | NB. WASTANI WA ALAMA WA SHULE NI SAWASAWA NA JUMLA YA ALAMA ZA WANFUNZI WA SHULE HUSIKA WALIOFANYA MTIHANI GAWANYA KWA IDADI [NAME] MTIHANI
Spreadsheet: 846461d1697645680-create-an-array-that-enumerates-different-combinations-of-percentages-sample
Sheet: Sheet1

A | B | C | D | E | F | G | H | I | J | K | L | M
1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0.95 | 0.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0.9 | 0.05 | 0.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0.85 | 0.05 | 0.05 | 0.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0.8
0.75
0.7
0.65
0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
Spreadsheet: errol_mclaughlin_jr__10864__Orig-Other1001
Sheet: Orig Sched

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ^ENRON RISK MANAGEMENT SERVICES CORP.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ^DAILY DETAIL OF NEW TRANSACTIONS
Other
 |  |  |  |  |  |  |  |  | Total Notional |  |  | Value on Date
 |  |  |  |  |  |  |  |  | Quantities (Bcf) |  |  | Transaction Originated | Enter Value of
Deal # |  | Originated |  | Customer |  | EGS Origination |  | (Sales) |  | Purchases |  | (In Thousands) | Deal Here | Originator | Book ID |  | B/S | TERM | PRICE | PUB CODE | Book ID List
START ON NEXT LINE |  |  |  |  |  |  |  |  |  |  |  | Formula - DO NOT TOUCH
Y68594 |  | 2001-10-01 00:00:00 |  | Michigan Consolidate Gas Company |  | Capital Book |  | 2018163 |  | 2000000 |  |  | 97803 | Capital Book | FT-ONTARIO |  | b/s | 12/01-08/02 | 0 | MICH_CG-GD | Ft-Ontario
VC7636 |  | 2001-10-04 00:00:00 |  | [NAME] |  | mexico origination |  | unwind |  |  |  |  | 16153 | perez | NG-PRICE
Y80782 |  | 2001-10-04 00:00:00 |  | indelpro |  | mexico origination |  |  |  | 70000 |  |  | 7215 | perez | NG-PRICE |  | B | 04/02-10/02 | 2.865 |  |  |  |  |  |  | 126148 | 1
Y80782.2 |  | 2001-10-04 00:00:00 |  | indelpro |  | mexico origination |  |  |  | 70000 |  |  | 1360 | perez | NG-PRICE |  | B | 2001-12-02 00:00:00 | 3.31 |  |  |  |  |  |  | 126148 | 1
Y80782.3 |  | 2001-10-04 00:00:00 |  | indelpro |  | mexico origination |  |  |  | 70000 |  |  | 1020 | perez | NG-PRICE |  | b | 2001-11-02 00:00:00 | 3.145 |  |  |  |  |  |  | 126148 | 1
Y00460.7 |  | 2001-10-18 00:00:00 |  | [NAME] |  | mexico origination |  | 1 |  |  |  |  | 14849 | perez | NG-PRICE |  | B | 2001-08-01 00:00:00 | v |  |  |  |  |  |  | 126148 | 1
Y00460.8 |  | 2001-10-18 00:00:00 |  | [NAME] |  | mexico origination |  | 1 |  |  |  |  | 77308 | perez | NG-PRICE |  | B | 2001-08-01 00:00:00 | v |  |  |  |  |  |  | 126148 | 1
VC0578.A |  | 2001-10-18 00:00:00 |  | [NAME] |  | mexico origination |  | 1 |  |  |  |  | 19060 | perez | NG-PRICE |  | B | 2001-08-01 00:00:00 | v |  |  |  |  |  |  | 126148 | 1
VC0539.A |  | 2001-10-18 00:00:00 |  | [NAME] |  | mexico origination |  | 1 |  |  |  |  | 8168 | perez | NG-PRICE |  | B | 2001-08-01 00:00:00 | v |  |  |  |  |  |  | 126148 | 1
Y00460 |  | 2001-10-19 00:00:00 |  | [NAME] |  | mexico origination |  | 400000 |  |  |  |  | 178760 | perez | NG-PRICE |  | S | 04/02-10/02 | 3.238 |  |  |  |  |  |  | 126148 | 1
YF0231 |  | 2001-10-29 00:00:00 |  | Compania [NAME] |  | mexico origination |  |  |  | 160000 |  |  | 2800 | perez | NG-PRICE |  | B | 2001-11-01 00:00:00 | 3.1475 |  |  |  |  |  |  | 126148 | 1
TOTAL ORIGINATION
Spreadsheet: 161350d1339505992-count-numbers-in-other-column-before-certain-date-excelforum-12june
Sheet: Sheet1

Name | date | ID | Age
Pieter | 2012-05-01 00:00:00 | 2121212L | 232
Rutger | 2012-05-10 00:00:00 | 1211234L
Amelie | 2012-05-12 00:00:00 | 5662W4L | 23
Jan | 2012-05-15 00:00:00 | 4342233L
[NAME] | 2012-05-18 00:00:00 | 4465775L | 23
Nepre | 2012-05-20 00:00:00 | 3435463L | 4
[NAME] | 2012-05-23 00:00:00 | 3454656L
[NAME] | 2012-05-25 00:00:00 | 3454653L | 5
Gort | 2012-05-27 00:00:00 | 3564346L
[NAME] | 2012-05-31 00:00:00 | 2355335L | 3 |  |  |  | Date: | number: |  | How it should be:
Oster | 2012-06-04 00:00:00 | 4453234L |  |  |  |  | 2012-06-04 00:00:00 |  |  | 6
[NAME] | 2012-06-05 00:00:00 | 4534367L | 32 |  |  |  | 2012-06-05 00:00:00 |  |  | 7
[NAME] | 2012-06-07 00:00:00 | 3334563L | 5 |  |  |  | 2012-06-06 00:00:00 |  |  | 7
Thijs | 2012-06-08 00:00:00 | 5674322L |  |  |  |  | 2012-06-07 00:00:00 |  |  | 8
Robbert | 2012-06-11 00:00:00 | 6763677L | 43 |  |  |  | 2012-06-08 00:00:00 |  |  | 8
 |  |  |  |  | Hi,
 |  |  |  |  | I need to count the number of cells where an age is notated from a certain date to prior that date.
 |  |  |  |  | So in I12 I need to count the number of cells where an age is notated from 4 june to before, (count the numbers of cells where an age is notated between the arrows