tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 843001d1694978817-how-to-match-two-columns-in-two-different-work-sheets-and-fill-specific-rows-test-question-fluffinator-
Sheet: Page3

 |  |  |  |  |  |  |  |  | Date | Index | Area | Serial | Statistics | Code
 | 44060 | 1a | 188857 | One | 9 | AOL | [NAME] | 0.0125
 | 2020-08-05 00:00:00 | 3a | 188857 | One |  | AOL | [NAME] | 02:59:00
 | 2021-07-04 00:00:00 | 2a | 511197 | Three |  | COL | [NAME] | 04:00:00
 | 2021-03-05 00:00:00 | 3a | 511197 | Three | 9 | COL | Sierra | 00:01:00
 | 2019-04-07 00:00:00 | 4a | 355570 | Four | 5 | DOL | Victor | 02:02:00
Spreadsheet: 120241d1315120266-to-extract-the-same-four-number-but-in-different-order-from-the-same-set-of-data-numbers
Sheet: Sheet1

Date | Prize | Number |  |  | Count of Prize
2011-09-03 00:00:00 | 1st Prize | 3991 |  |  | Number | Total
2011-09-03 00:00:00 | 2nd Prize | 8851 |  |  | 182 | 1
2011-09-03 00:00:00 | 3rd Prize | 9683 |  |  | 186 | 1
2011-09-03 00:00:00 | Special | 2944 |  |  | 617 | 1
2011-09-03 00:00:00 | Special | 1764 |  |  | 792 | 1
2011-09-03 00:00:00 | Special | 8029 |  |  | 877 | 1
2011-09-03 00:00:00 | Special | 3254 |  |  | 1515 | 1
2011-09-03 00:00:00 | Special | 9133 |  |  | 1764 | 1
2011-09-03 00:00:00 | Special | 5568 |  |  | 1912 | 1
2011-09-03 00:00:00 | Special | 5609 |  |  | 1977 | 1
2011-09-03 00:00:00 | Special | 1515 |  |  | 2058 | 1
2011-09-03 00:00:00 | Special | 1977 |  |  | 2266 | 1
2011-09-03 00:00:00 | Special | 7368 |  |  | 2694 | 1
2011-09-03 00:00:00 | Consolation | 8994 |  |  | 2944 | 1
2011-09-03 00:00:00 | Consolation | 4189 |  |  | 3130 | 1
2011-09-03 00:00:00 | Consolation | 9853 |  |  | 3254 | 1
2011-09-03 00:00:00 | Consolation | 186 |  |  | 3274 | 1
2011-09-03 00:00:00 | Consolation | 3130 |  |  | 3287 | 1
2011-09-03 00:00:00 | Consolation | 5288 |  |  | 3417 | 1
2011-09-03 00:00:00 | Consolation | 3274 |  |  | 3474 | 1
2011-09-03 00:00:00 | Consolation | 4293 |  |  | 3554 | 1
2011-09-03 00:00:00 | Consolation | 792 |  |  | 3991 | 1
2011-09-03 00:00:00 | Consolation | 5838 |  |  | 4052 | 1
2011-08-31 00:00:00 | 1st prize | 7114 |  |  | 4056 | 1
2011-08-31 00:00:00 | 2nd prize | 182 |  |  | 4189 | 1
2011-08-31 00:00:00 | 3rd prize | 877 |  |  | 4293 | 1
2011-08-31 00:00:00 | special | 4052 |  |  | 5288 | 1
2011-08-31 00:00:00 | special | 8084 |  |  | 5568 | 1
2011-08-31 00:00:00 | special | 8989 |  |  | 5609 | 1
2011-08-31 00:00:00 | special | 9959 |  |  | 5838 | 1
2011-08-31 00:00:00 | special | 2694 |  |  | 6074 | 1
2011-08-31 00:00:00 | special | 7381 |  |  | 6617 | 1
2011-08-31 00:00:00 | special | 3474 |  |  | 7114 | 1
2011-08-31 00:00:00 | special | 7338 |  |  | 7338 | 1
2011-08-31 00:00:00 | special | 8604 |  |  | 7368 | 1
2011-08-31 00:00:00 | special | 617 |  |  | 7381 | 1
2011-08-31 00:00:00 | consolation | 2058 |  |  | 8029 | 1
2011-08-31 00:00:00 | consolation | 3287 |  |  | 8084 | 1
2011-08-31 00:00:00 | consolation | 6074 |  |  | 8604 | 1
2011-08-31 00:00:00 | consolation | 3417 |  |  | 8851 | 1
2011-08-31 00:00:00 | consolation | 2266 |  |  | 8989 | 1
2011-08-31 00:00:00 | consolation | 1912 |  |  | 8994 | 1
2011-08-31 00:00:00 | consolation | 3554 |  |  | 9133 | 1
2011-08-31 00:00:00 | consolation | 4056 |  |  | 9375 | 1
2011-08-31 00:00:00 | consolation | 6617 |  |  | 9683 | 1
2011-08-31 00:00:00 | consolation | 9375 |  |  | 9853 | 1
 |  |  |  |  | 9959 | 1
 |  |  |  |  | Grand Total | 46
Spreadsheet: 97497d1296660374-matching-and-conditional-referncing-calculation-excel-help
Sheet: A-Sheet2

Property Reference | Address | [NAME] | Type |  | Allocation bases
 |  |  | Building | Lease | Block Costs
 |  |  |  |  | Split Unit | Other %
MOS05290001012 | FLAT A , 12 PENTON STREET, |  | FLT | LHO | OTHER | 0.0769230769230769
MOS05290002012 | FLAT B , 12 PENTON STREET, |  | COMMERCIAL | FHO | YES
MOS05290006012 | FLAT F , 12 PENTON STREET |  | HOUSE | EMA | OTHER | 0.0769230769230769
MOS05290007012 | FLAT G , 12 PENTON STREET |  | FLT | EMA | YES
MOS05290008012 | FLAT H , 12 PENTON STREET |  | COMMERCIAL | FHO | YES
MOS05290010012 | FLAT J , 12 PENTON STREET, |  | HOUSE | LHO | OTHER | 0.0769230769230769
Spreadsheet: 273566d1382757209-how-to-show-only-the-cell-that-met-formula-criteria-when-filtering-filter-file
Sheet: Sheet1

 | TERMINAL | TB | TM | STG | PR
 | TYPE OF REVENUE | PARKING | PARKING | PARKING | PARKING
 |  | TERMINAL PASS | TERMINAL PASS | TERMINAL PASS | TERMINAL PASS
 |  |  | INSURANCE | INSURANCE
 |  |  | WHARFAGE | WHARFAGE | WHARFAGE
 |  |  |  | RENT
 | Cell to Filter based on terminal
 | TYPE OF REVENUE
 | TYPE OF REVENUE
 | TYPE OF REVENUE
 | TYPE OF REVENUE
Spreadsheet: 485861d1477117179-find-trends-in-employee-data-example
Sheet: page 25

Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
U 9 | 22:00     6:00 | 23:00     7:00 |  |  |  | 22:00     6:00 | 22:00     6:00
 |  | 14:00    23:00 | 14:00    23:00 | 15:00     1:00
 |  |  | 14:00    23:00 | 22:00     6:00 | 22:00     6:00 |  | 10:00    18:00
 | 7:00     15:00 | 4:00     11:00 |  | 6:00     15:00 | 6:00     15:00
 |  | 22:00     6:00 | 22:00     6:00 |  |  | 6:00     15:00 | 7:00     17:00
 | 6:00     16:00 | 13:00    22:00 | 14:00    23:00 | 14:00    22:24
Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
U 1 0 |  | 22:00     6:00 | 22:00     6:00 |  |  | 10:00    20:00 | 22:00     6:00
 | 22:00     6:00 |  | 22:00     6:00 | 22:00     6:00
 |  |  | 14:00    23:00 | 22:00     6:00 | 22:00     6:00 |  | 15:00     1:00
 |  | 14:00    23:00 | 14:00    24:00 | 14:00    22:24
 | 12:00    22:00 | 12:00    20:00 |  |  | 14:00    24:00 | 13:00    23:00 | 22:00     6:00
 | 22:00     6:00 |  | 22:00     6:00 | 22:00     6:00
Spreadsheet: 327903d1403713369-getting-around-n-a-scoring-tool-2
Sheet: Sheet1

Category | Answer | [NAME] | Percentage
Assurance of Supply | 5 | 5
Assurance of Supply | 2 | 5
Assurance of Supply | 4 | 5 |  |  |  | Row Labels | Product of Percentage
Assurance of Supply | 3 | 5 |  |  |  | Assurance of Supply | 0.6181818181818182
Assurance of Supply | 2 | 5 |  |  |  | Cost | 0.6222222222222222
Assurance of Supply | 2 | 5 |  |  |  | Innovation & Technology | 0.5523809523809524
Assurance of Supply | 5 | 5 |  |  |  | Quality | 0.6347826086956522
Assurance of Supply | 4 | 5 |  |  |  | Service | 0.5826086956521739
Assurance of Supply | 4 | 5 |  |  |  | Grand Total | 0.0785782625244251
Assurance of Supply | 1 | 5
Assurance of Supply | 1 | 5
Assurance of Supply | 3 | 5
Assurance of Supply | 3 | 5
Assurance of Supply | 1 | 5
Assurance of Supply | 5 | 5
Assurance of Supply | 5 | 5 |  |  |  |  |  | Data will then feed a chart
Assurance of Supply | 1 | 5 |  |  |  | Assurance of Supply
Assurance of Supply | 1 | 5 |  |  |  | Quality
Assurance of Supply | 5 | 5 |  |  |  | Service
Assurance of Supply | 5 | 5 |  |  |  | Cost
Assurance of Supply | 2 | 5 |  |  |  | Innovation & Technology
Assurance of Supply | 4 | 5
Quality | 5 | 5 |  |  |  |  | Note formula in column D is in this format so rows can be deleted without upsetting % the calculation.
Quality | 4 | 5
Quality | 4 | 5
Quality | 3 | 5
Quality | 1 | 5
Quality | 5 | 5
Quality | 5 | 5
Quality | 1 | 5
Quality | 4 | 5
Quality | 1 | 5
Quality | 1 | 5
Quality | 4 | 5
Quality | 1 | 5
Quality | 3 | 5
Quality | 3 | 5
Quality | 5 | 5
Quality | 3 | 5
Quality | 4 | 5
Quality | 2 | 5
Quality | 4 | 5
Quality | 4 | 5
Quality | 5 | 5
Quality | 1 | 5
Service | 4 | 5
Service | 3 | 5
Service | 2 | 5
Service | 5 | 5
Service | 2 | 5
Service | 4 | 5
Service | 2 | 5
Service | 2 | 5
Service | 1 | 5
Service | 5 | 5
Service | 4 | 5
Service | 2 | 5
Service | 1 | 5
Service | 2 | 5
Service | 2 | 5
Service | 5 | 5
Service | 5 | 5
Service | 1 | 5
Service | 3 | 5
Service | 3 | 5
Service | 4 | 5
Service | 4 | 5
Service | 1 | 5
Cost | 3 | 5
Cost | 3 | 5
Cost | 1 | 5
Cost | 5 | 5
Cost | 3 | 5
Cost | 2 | 5
Cost | 2 | 5
Cost | 4 | 5
Cost | 3 | 5
Cost | 5 | 5
Cost | 4 | 5
Cost | 3 | 5
Cost | 2 | 5
Cost | 3 | 5
Cost | 1 | 5
Cost | 4 | 5
Cost | 4 | 5
Cost | 4 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 1 | 5
Innovation & Technology | 4 | 5
Innovation & Technology | 4 | 5
Innovation & Technology | 4 | 5
Innovation & Technology | 1 | 5
Innovation & Technology | 4 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 2 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 4 | 5
Innovation & Technology | 1 | 5
Innovation & Technology | 5 | 5
Innovation & Technology | 5 | 5
Innovation & Technology | 2 | 5
Innovation & Technology | 1 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 1 | 5
Innovation & Technology | 1 | 5
Spreadsheet: 758059d1638613321-sumifs-with-date-problem-accounts-test
Sheet: Transactions

2020/21
Account | Date | Ref | Number | Payee | Splits | Sub-Category | Category | R | PAYMENT | DEPOSIT | Cleared Payment | Cleared Deposit | Month | Account Balance | Cleared Balance | BALANCE
Cheque | 2020-09-29 00:00:00 |  | 1 | Brought Forward from Current A/C |  | 1 | [Balance] | R |  | 13067.88 |  |  | 0
Sinking | 2020-09-29 00:00:00 |  | 2 | Brought Forward from Sinking Fund |  | 2 | [Balance] |  |  | 0 |  |  | 0
Cheque | 2020-10-01 00:00:00 |  | 3 | Service Charge |  |  | Flat 8 | R |  | 637.22
Cheque | 2020-10-02 00:00:00 |  | 4 | Service Charge |  |  | 2 Mews | R |  | 105.05
Cheque | 2020-10-02 00:00:00 |  | 5 | Service Charge |  |  | 5 Mews | R |  | 229.31
Cheque | 2020-10-12 00:00:00 |  | 6 | Electrics |  |  | Electrical Repairs | R | 59.4
Cheque | 2020-08-09 00:00:00 |  | 7 | Pyro |  |  | Fire Systems Maintenance | R | 53.97
Cheque | 2020-10-14 00:00:00 |  | 8 | Accountants |  |  | Accountancy/Annual Returns YTC | R | 150
Cheque | 2020-10-14 00:00:00 |  | 9 | Accountants |  |  | Accountancy/Annual Returns | R | 600
Cheque | 2019-09-30 00:00:00 |  | 10 | Service Charge |  |  | 6 Mews | R |  | 229.31
Cheque | 2020-11-05 00:00:00 |  | 11 | S E |  |  | Electricity | R | 529.59
Cheque | 2020-10-01 00:00:00 |  | 12 | Field |  | Oct | Gardening | R | 84
Cheque | 2020-11-04 00:00:00 |  | 13 | Field |  | Nov | Gardening | R | 84
Cheque | 2020-10-01 00:00:00 |  | 14 | Insurance |  |  | Building Insurance inc Public Liability | R | 3011.22
Cheque | 2020-10-01 00:00:00 |  | 15 | Insurance |  |  | Engineering Insurance - Lift | R | 675.9
Cheque | 2020-11-12 00:00:00 |  | 16 | Gates |  |  | Gates Maintenance | R | 204
Cheque | 2021-12-01 00:00:00 |  | 17 | Insurance |  |  | Building Insurance inc Public Liability | R | 3011.22
 |  |  |  | This means the formulae have not been copied
Spreadsheet: 187209d1350380084-mirroring-two-ranges-of-cells-so-that-either-range-could-be-edited-and-saved-in-the-other-test
Sheet: Period 4

 | School Name | Average | 0 | 0.6 | 0.63 | 0.67 | 0.7 | 0.73 | 0.77 | 0.8 | 0.83 | 0.87 | 0.9 | 0.93 | 0.97
 |  | [NAME] | F | D- | D | [NAME] | C- | C | C+ | B- | B | [NAME] | A- | A | A+
 | Teachers
 | Period 4 |  |  | Assignment or Test Name
 | 2012 |  |  | Total Points
 |  |  |  | AVERAGE
 | Student Name | Average | [NAME] | Assessment | Lab/ICA | Midterm | Final | Project
 | Student 19 |  |  |  |  |  |  |  | 1 | 3 | 4 | 50 | 8 | 4 | 50 | 93.5 | 51 | 79.5 | 4 | 3.5 | 100 | 81 | 3.5
 | Student 20 |  |  |  |  |  |  |  | 4 | 4 | 4 | 48.75 | 5 | 4 | 50 | 86 | 55 | 82.5 | 3.5 | 3 | 90 |  | 4
 | Student 21 |  |  |  |  |  |  |  | 1 | 4 | 4 | 42.5 | 8 | 4 | 40 | 91 | 40 | 72.5 |  |  | 90
 | Student 22 |  |  |  |  |  |  |  | 1 | 3 | 3 | 50 | 6 | 4 | 38 | 40 | 40 | 72 | 3.5 | 3 | 100 | 76 | 4
 | Student 23 |  |  |  |  |  |  |  | 3.5 | 3 | 3 | 48.75 | 7.5 | 4 | 42 | 61 | 47.5 | 75 | 4 | 3 | 80 | 78 | 3.5
 | Student 24 |  |  |  |  |  |  |  | 4 | 3.5 | 3.5 | 20 | 8 | 4 | 50 | 91 | 54 | 77 | 4 | 3 | 90 | 75 | 4
 | Student 25 |  |  |  |  |  |  |  | 3 | 3.5 | 3.5 | 32.5 | 7 | 4 | 40 | 92 | 41 | 85.5 | 3.5 | 3.5 | 90 | 93 | 4
 | Student 26 |  |  |  |  |  |  |  | 4 | 4 | 4 | 47.5 | 7 | 4 | 50 | 88 | 55 | 87 | 3.5 | 3.5 | 100 | 93 | 3
 | Student 27 |  |  |  |  |  |  |  | 2 | 4 | 4 | 50 | 7.5 | 4 | 50 | 91 | 55 | 76 | 4 | 3 | 90 | 88 | 2
 | Class Summary
 | Average
 | Highest Score
 | Lowest Score
 | Grade Categories | % of Final Grade
 | Assessment | 0.2
 | Lab/ICA | 0.3
 | Midterms | 0.2
 | Final | 0.15
 | Project | 0.15
 | TOTAL
Spreadsheet: 134393d1325263135-conditional-formatting-formula-to-check-expired-old-dates-cf301211
Sheet: Sheet1

Date | Status
2010-01-03 00:00:00 | Expired
2010-01-03 00:00:00 | Expired
2010-01-03 00:00:00 | Expired
2010-01-03 00:00:00 | Expired
2011-12-11 00:00:00
2011-12-12 00:00:00
2011-12-12 00:00:00
2011-12-12 00:00:00
2011-12-12 00:00:00
2011-12-10 00:00:00
2011-12-12 00:00:00
2011-12-10 00:00:00
2011-12-12 00:00:00
2010-08-22 00:00:00 | Expired
2011-12-12 00:00:00
2011-12-12 00:00:00
2011-12-13 00:00:00
2011-12-13 00:00:00
2011-12-06 00:00:00
2011-12-13 00:00:00
2011-12-13 00:00:00
2011-12-10 00:00:00
2011-12-14 00:00:00
2011-12-14 00:00:00
2011-12-14 00:00:00
2011-12-14 00:00:00
2011-12-14 00:00:00
2011-12-17 00:00:00
2011-12-17 00:00:00
2011-12-18 00:00:00
2011-12-19 00:00:00
2011-12-17 00:00:00
2011-12-17 00:00:00
2011-12-18 00:00:00
2011-12-19 00:00:00
2011-12-19 00:00:00
2011-12-19 00:00:00
2011-12-19 00:00:00
2011-12-19 00:00:00
2011-12-19 00:00:00
2011-12-19 00:00:00
2011-12-19 00:00:00
2011-12-20 00:00:00
2011-12-20 00:00:00
2008-09-15 00:00:00 | Expired
2011-12-20 00:00:00
2011-12-20 00:00:00
2011-12-20 00:00:00
2011-12-20 00:00:00
2011-12-21 00:00:00
2011-11-01 00:00:00
2011-11-14 00:00:00
2011-11-18 00:00:00
2011-12-15 00:00:00
2011-12-19 00:00:00
2011-12-22 00:00:00
2011-12-22 00:00:00
2011-12-28 00:00:00
2011-12-28 00:00:00
2011-12-28 00:00:00
2011-12-28 00:00:00
2011-12-28 00:00:00
2011-12-28 00:00:00
2011-12-28 00:00:00
2011-12-28 00:00:00
2011-12-28 00:00:00
2011-12-28 00:00:00
2011-12-29 00:00:00
2011-12-29 00:00:00
2011-12-29 00:00:00
2011-12-29 00:00:00
2011-12-30 00:00:00
Spreadsheet: joe_parks__14620__POSTIONTRAX_NOV
Sheet: scale

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  |  |  |  |  |  |  | MTM
 | 15.5 | 2.73 |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 | 23.25 | 2.745 |  |  |  |  |  |  |  |  | NEW DEALS
 | 31 | 2.765
 | 46.5 | 2.78 |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  |  |  |  |  | 17500
 |  |  |  |  |  |  |  |  |  |  | 20000
 |  | 2.81 | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 757936d1638543684-calculating-4-threads-issue-with-tracker-pla-learning-journey-example-
Sheet: Stage 1 (Michelle)

Michelle |  |  |  |  |  |  |  |  |  |  | (Please put an x to show all learning has been completed or an E if there is a valid exception)
[NAME] | [NAME] | Front-Line Manager Name | Grade | Location | Tax Regime | Project | Date PJ Commenced | TUD Date | Cohort | Expected Week in Stage 1 Learning | Week 1 | Week 2 | Race Equality Workshop | Week 3 | [NAME] | Case Study 1 | Case Study 2 | Week 4 | Case Study 3 | Week 5 | Case Study 4 | Case Study 5 | Week 6 | Case Study 6 | Case Study 7 | Week 7 | Case Study 8 | Case Study 9 | Week 8 | Exceptions
Spreadsheet: 113c4660-2bac-4598-9caa-b532bd18b400
Sheet: Sheet1

Unnamed: 0 | National Omicron-Psi Honor Society | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | UMW Chapter
 | 121 University Blvd
 | Fredericksburg, VA 22406
 | Application for Membership
 | NAME: |  |  |  |  |  | Faculty Advisor:
 | ADDRESS: |  |  |  |  |  | Program: | MBA |  | MSMIS
 | CITY/STATE/ZIP: |  |  |  |  |  |  | M.Ed. |  | Dual
 | SSN: |  |  |  |  |  |  | BPS
 | [NAME] PHONE: |  |  |  |  |  | Date of Birth:
 | TODAY'S DATE: |  |  |  |  |  | Current GPA:
 | List three community/professional organizations in which you serve as an active participant. To qualify for membership in UMW's chapter of Omicron-Psi, at least one must be a professional organization and at least one must be a community organization.
 | 1
 | 2
 | 3
 | Acheivements, Honors:
 | Goals/Future Plans:
 | Essay
 | Attach a brief, well-written essay on how you subscribe to the principles of duty, honor, and service; and how you maintain and demonstrate high ethical standards in all aspects of life.
 | Letters of Recommendation
 | Submit two letters of recommendation, one from a leader in the professional organization and one from a leader in the community organization in which you are involved.
 | Eligibility Criteria
 | 1 | Must be at least 24 years of age;
 | 2 | Undergraduate: earned a minimum of 60 graded credits of which 30 are from UMW
 |  | Graduate:  earned a minimum of 21 graded graduate credits from UMW;
 | 3 | Have a minimum cumulative GPA of 3.8 on a 4.0 scale;
 | 4 | Serves as an active participant in a minimum of three community/professional organizations of which one must be a professional organization and one must be a community organization. Organizations must reflect the community values of the University as stated in the Academic Catalog;
 | 5 | Maintain the principles of duty, honor and service;
 | 6 | Maintain and demonstrate high ethical standards in all aspects of life;
 | 7 | Submit a brief, well written essay on how the student subscribes to the principles of duty, honor and service and maintains and demonstrates high ethical standards in all aspects of life;
 | 8 | Submit two letters of recommendation, one from a leader in the professional organization and one from a leader in the community organization in which the student is involved.
 | Contact Information
 | [NAME], Assistant Dean of Advising Services:  [PHONE] or [EMAIL]
 | APPLICATION MUST BE TYPED
Spreadsheet: phillip_m_love__30147__9910_OA
Sheet: ARUBA-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 11157705 | 30241414
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 15023972 | 41429551
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 26181677 | 71670965
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -5555437 | -14169741 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -20887121 | -56681162
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 184885 | 501619
 | Total Purchases: |  | -26257673 | -70349284
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 75996 | 199508.4808611501
 |  |  | 0 | 0
23 | Fuel: |  | -184885 | -501619
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -77006
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -77006
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 16562230
31 |  | Prior Month Book Balance | 0 | -22061170
 |  | Total MTM Income | 0 | -5498940
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 4852414
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -390
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
Spreadsheet: 816627d1675755731-sum-by-year-book2
Sheet: Trail Balance

2023 | TRAIL BALANCE
Account | Account Type | Debit | Credit | Balance
Cash In Hand | ASSEST
Cash In Bank | ASSEST
Misc Income | INCOME
Rent Accrual | ASSEST
Interest Received | ASSEST
Acc.Payable | LIABILITY
Drawings | LIABILITY
Rental Income | INCOME
Tax | LIABILITY
Utility | LIABILITY
Management Fees | LIABILITY
Sundry Expenses | LIABILITY
Maintenanace | LIABILITY
[NAME] | LIABILITY
Bank Charges | LIABILITY
Donation | LIABILITY
Equity | LIABILITY
Account Receivable | ASSEST
Shareholder | LIABILITY
security deposit | LIABILITY
Spreadsheet: 793226d1661359016-sumifs-not-working-with-data-where-numbers-stored-as-text-sumifs-data-shown-as-text
Sheet: Sheet1

Type | GL | Amount |  | Conditions |  |  |  |  |  | Type | GL | Amount
1010101 | 99999 | 10 |  | Type | 1010101 |  | 1010101 |  |  | 1010101 | 99999 | 10 |  | 1010101
1010101 | 55555 | 20 |  | GL | 99999 |  | 99999 |  |  | 1010101 | 55555 | 20 |  | 99999
1010101 | 44444 | 30 |  |  |  |  |  |  |  | 1010101 | 44444 | 30
1010101 | 33333 | 40 |  | Amount |  |  |  |  |  | 1010101 | 33333 | 40
1010101 | 99999 | 50 |  |  |  |  |  |  |  | 1010101 | 99999 | 50
2010202 | 11111 | 60 |  | SUMIFS with conditions INSIDE formula |  |  |  |  |  | 2010202 | 11111 | 60 |  | SUMIFS with conditions INSIDE formula
2010202 | 55555 | 70 |  |  |  |  |  |  |  | 2010202 | 55555 | 70
2010202 | 99999 | 80 |  |  |  |  |  |  |  | 2010202 | 99999 | 80
2010202 | 77777 | 90 |  |  |  |  |  |  |  | 2010202 | 77777 | 90
2010202 | 99999 | 100 |  |  |  |  |  |  |  | 2010202 | 99999 | 100
Spreadsheet: 197619d1354491321-return-all-matching-rows-of-a-table-based-on-dropdown-cell-book1
Sheet: Sheet2

Select Product: |  | B | DROPDOWN LIST OF UNIQUE NAMES FROM Sheet1
Inventory ID | Cost Price | Sale Price | Quantity Available | Date Ordered
20129 | 150 | 300 | 10 | 2012-01-20 00:00:00
29321 | 140 | 300 | 10 | 2011-09-29 00:00:00
Another Example. Now using A
Select Product: |  | A | DROPDOWN LIST OF UNIQUE NAMES FROM Sheet1
Inventory ID | Cost Price | Sale Price | Quantity Available | Date Ordered
20122 | 200 | 400 | 10 | 2012-01-19 00:00:00
20001 | 130 | 370 | 25 | 2011-09-14 00:00:00
20111 | 100 | 350 | 5 | 2011-09-01 00:00:00
Spreadsheet: 90960d1290633647-formula-needed-to-place-a-stage-book2
Sheet: Sheet1

Stage | Range
1 | 0 | 500
2 |  | 2500
3 |  | 10000
4 |  | 25000
5 |  | 50000
6 |  | 100000
7
 | 2505
Spreadsheet: 830542d1684964449-picking-the-last-value-chronolgically-based-on-a-time-column-sample-table-1-aligw
Sheet: Sheet2

Date/Time | Result
2022-07-06 11:30:00 | 1.4 |  |  | 1.3
2022-07-06 13:26:00 | 1.3 |  | 2022-07-07 00:00:00 | 1.2
2022-07-06 16:24:00 | 1.2
2022-07-06 17:57:00 | 1.3
2022-07-07 05:55:00 | 1.5
2022-07-07 07:48:00 | 1
2022-07-07 11:54:00 | 1.9
2022-07-07 13:35:00 | 0.9
2022-07-07 16:45:00 | 1.3
2022-07-07 18:20:00 | 1.2
Spreadsheet: 96633d1295982902-finding-frequency-and-repetition-of-values-in-cells-in-a-row-r-d2
Sheet: Sheet1

 | R | R | D | R | R | D | M/C - I | M/C - I | R | D | 1
 | D | R | D | M/C - I | D | R | M/C - I | M/C - I | H | H | 0