tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7805__imbalsumm0108
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 199740 | 206461 |  | -6136 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 124221 | 140424 |  | -16997 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 208560 | 226875 |  | -13759 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 174497 | 201790 |  | -27623 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 170484 | 195304 |  | -25217 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 171739 | 196507 |  | -26132 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 181261 | 192920 |  | -9874 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 197070 | 204844 |  | -4417 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 193826 | 201331 |  | -8466 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 183951 | 200529 |  | -19807 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 | 205187 | 209202 |  | -3450 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 | 196282 | 206942 |  | -11937 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 | 208969 | 209066 |  | -807 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14 | 200915 | 207816 |  | -8506
15 | 185028 | 192042 |  | -7418 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 | 205829 | 210433 |  | -5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 | 203994 | 209294 |  | -5929 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18 | 230790 | 250585 |  | -6265
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-07-31 00:00:00 |  |  |  | 5110
 | 2001-08-18 00:00:00
 | CBS Dollars
 |  |  |  | -487771.44
Spreadsheet: jeff_dasovich__14103__California PJM and NE Tables revised2
Sheet: A17

TABLE A17 FREQUENCY OF PRICE SPIKES IN CALIFORNIA ISO GENERATOR NON-SPINNING MARKET NP15
PRICE EQUALS OR EXCEEDS | FY 00/99 | FY 99/98
 | # of hours
 | % of available hours
100 | 112 | 140
 | 0.01275 | 0.01598
250 | 64 | 87
 | 0.00729 | 0.00993
500 | 38 | 0
 | 0.00433 | 0
750 | 0 | 0
 | 0 | 0
1000 | 0 | 0
 | 0 | 0
Source: CAISO website (www.caiso.com)
FY 00/99: 8/1/1999-7/31/2000
FY 99/98: 8/1/1998-7/31/1999
Spreadsheet: rick_buy__32943__Log as of FEB 12_01
Sheet: Sum Feb 7 to 13

 | Week summary (Feb 7 to 13)
Category | Description | Total |  | Breakdown of Cat 1
1 | Human Errors |  |  | Process in place but not followed
2 | IT Hardware problems |  |  | Officialized on time but needed recalc
3 | IT Software Problems |  |  | Book not officialized | 1
4 | Miscellaneous |  |  | No process in place
5 | Uncontrollable | 0 |  | Other
 | Total |  |  | Total
 |  |  |  | Breakdown of Cat 2
 |  |  |  | Computer breakdown | 0
 |  |  |  | Other
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 3
 |  |  |  | Correct inputs, incorrect outputs
 |  |  |  | Slow feeds
 |  |  |  | Feed problem
 |  |  |  | Books shown as officialized, but not RiskTrac
 |  |  |  | Application down alternate system used
 |  |  |  | Other
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 4
 |  |  |  | Credit interface | 0
 |  |  |  | Other | 0
 |  |  |  | Total
Spreadsheet: a15823af-1caf-4305-af1b-b117d7fbbd32
Sheet: Calendar

[NAME] for calendar(updated: Mar 24 2013)
Command to modify the schedule:
Attribute Name |  |  | Value |  |  |  |  |  |  |  | Notice
Policy name
Schedule name
Recurring Days of the Month
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | Command Option
9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
25 | 26 | 27 | 28 | 29 | 30 | 31 | Last
Recurring Week Days
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Command Option
1
2
3
4
Last
Spreadsheet: 860413d1708517592-splitting-names-in-a-cell-and-take-corresponding-values-testbook-1-
Sheet: Bylines

Site | Year | Month | Quarter | Byline | Count | Byline Type | External | Internal | Total |  |  | Site | Year | Month | Quarter | Byline | Count
Red | 2020 | Dec | Q4 | [NAME] | 100 | Internal |  |  |  |  |  |  | 2020 | Dec | Q4 | [NAME] | 100
Red | 2020 | Dec | Q4 | [NAME] | 90 | External |  |  |  |  |  | Red | 2020 | Dec | Q4 | [NAME] | 90
Red | 2020 | Dec | Q1 | [NAME] | 80 | External |  |  |  |  |  | Red | 2020 | Dec | Q1 | [NAME] | 80
Yellow | 2020 | Dec | Q1 | [NAME] | 70 | Internal |  |  |  |  |  | Yellow | 2020 | Dec | Q1 | [NAME] | 70
Yellow | 2020 | Dec | Q1 | [NAME] | 60 | External |  |  |  |  |  | Yellow | 2020 | Dec | Q1 | [NAME] | 60
Blue | 2020 | Dec | Q1 | [NAME] | 50 | Internal |  |  |  |  |  | Blue | 2020 | Dec | Q1 | [NAME] | 50
Yellow | 2020 | Dec | Q2 | Mark | 60 | External |  |  |  |  |  | Yellow | 2020 | Dec | Q2 | Mark | 60
Green | 2020 | Dec | Q2 | [NAME] | 70 | Internal |  |  |  |  |  | Green | 2020 | Dec | Q2 | [NAME] | 70
Blue | 2020 | Dec | Q4 | Mark | 81 | External |  |  |  |  |  | Blue | 2020 | Dec | Q4 | Mark | 81
Green | 2020 | Dec | Q4 | [NAME] | 91 | Internal |  |  |  |  |  | Green | 2020 | Dec | Q4 | [NAME] | 91
Green | 2020 | Dec | Q4 | [NAME] | 100 | Internal |  |  |  |  |  | Green | 2020 | Dec | Q4 | [NAME] | 100
Green | 2023 | Jan | Q1 | [NAME], [NAME] | 2 | Internal |  |  |  |  |  | Green | 2023 | Jan | Q1 | [NAME] | 2
 |  |  |  |  |  |  |  |  |  |  |  | Green | 2023 | Jan | Q1 | [NAME] | 2
Spreadsheet: d7778562-9bb3-40cd-8bcc-6059ce83c072
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38776564 | 2013-11-30 21:49:17 | ALLIES | 1 | 6 | 3 | 29893 | Marsupilami 44 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38776998 | 2013-11-30 22:11:42 | AXIS | 1 | 6 | 0 | 29893 | Marsupilami 44 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38807101 | 2013-12-02 22:13:02 | ALLIES | 0 | 3 | 6 | 579964 | Laverdure60 | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
38807414 | 2013-12-02 22:36:25 | AXIS | 0 | 3 | 6 | 579964 | Laverdure60 | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
38835508 | 2013-12-04 23:01:43 | AXIS | 1 | 6 | 3 | 1305195 | g1ul10 | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
38835814 | 2013-12-04 23:22:18 | ALLIES | 0 | 3 | 6 | 1305195 | g1ul10 | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
38847938 | 2013-12-05 21:48:22 | AXIS | 0 | 3 | 6 | 54879 | jml0702 | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
38848265 | 2013-12-05 22:09:54 | ALLIES | 1 | 6 | 4 | 54879 | jml0702 | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
38863016 | 2013-12-06 23:55:33 | AXIS | 0 | 4 | 5 | 1456045 | dzastusmazeika | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
38863361 | 2013-12-07 00:21:30 | ALLIES | 0 | 3 | 5 | 1456045 | dzastusmazeika | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
38877412 | 2013-12-07 23:16:48 | AXIS | 0 | 3 | 6 | 362264 | [NAME] | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
38877674 | 2013-12-07 23:40:13 | ALLIES | 1 | 6 | 4 | 362264 | [NAME] | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
38878362 | 2013-12-08 00:32:15 | AXIS | 0 | 5 | 6 | 362264 | [NAME] | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
38878660 | 2013-12-08 00:55:10 | ALLIES | 0 | 4 | 6 | 362264 | [NAME] | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
Spreadsheet: 800955d1666011059-extract-information-from-different-sheets-in-a-workbook-s666-pq-new-sample-file
Sheet: Group 2

Group Members : Group 2
Description
Generated at |  | 2022-10-17 09:53:49
S.No | Display Name | Column1 | [NAME] | Column2 | Primary Group | Department
1 | TEST Name5 |  | JKLDJO |  | Domain Users | Credit
2 | TEST Name6 |  | JFHUIKD |  | Domain Users | IT
3 | TEST Name7 |  | NBHDFL |  | Domain Users | Finance
5 | TEST Name8 |  | [NAME] |  | Domain Users | IT
Spreadsheet: louise_kitchen__24046__East Power Consolidation
Sheet: Ercot Origination

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00
 |  | YTD Actual |  | Annualized |  | %
ENACOMP | Compensation |  |  |  |  | of Total
 | Special Pays | 115000
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 3
 | Analyst & Associate Headcount |  |  | 1
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
 | Masters Golf Tournament | 61013 |  | 61013
Spreadsheet: 142054d1329605419-sumproduct-condition-to-avoid-duplicates-duplicate-test
Sheet: Sheet1

 | BUID | ORDER_NUM | CASE_ID | Order Date Week | Status
 | 4747 | 390131977 | 16793172 | 201245 | Pending
 | 7878 | 389174384 | 16768143 | 201244 | Confirmed
 | 7878 | 386472799 | 17275173 | 201244 | Confirmed
 | 7878 | 394607923 | 17275173 | 201244 | Confirmed
 | 3232 | 389711672 | 16793172 | 201245 | Pending
 | 7878 | 395261795 | 17221810 | 201245 | Confirmed
 | 7878 | 387159908 | 16582637 | 201245 | Pending
 | 3232 | 390029304 | 16787467 | 201245 | Pending
 | 3232 | 396236176 | 16793172 | 201245 | Pending
 | 3232 | 387361553 | 16589484 | 201245 | Confirmed
 | 3232 | 396493272 | 17393829 | 201244 | Pending
 | 3232 | 396061129 | 17275173 | 201244 | Confirmed
 |  |  |  |  |  |  |  |  |  |  | I | J
 |  |  |  |  |  |  |  |  |  |  | 201244 | 201245
 |  |  |  |  |  |  |  |  | 17 | Confirmed
 |  |  |  |  |  |  |  |  | 18 | Pending
Spreadsheet: 005d782d-7b4c-4c89-ad49-c7da5e701aa6
Sheet: Sheet1

Electronic Course Record | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Computer Information Technologies - Information Security Track
Name: |  |  |  |  |  | Phone #: |  |  |  | Rev. 11/26 SD
ID #: |  |  |  |  |  | Student Signature: |  |  | Date:
[NAME]: |  |  |  |  |  | Advisor Signature: |  |  | Date:
Required Transitional Courses |  |  |  | Courses | Grade | Authorizing Signature: |  |  | Date:
RDG 030 - Improved College Reading |  |  |  | RDG 30 |  | NOTES:
RDG 185 College Reading |  |  |  | RDG 185
ENC 090 - Foundations of College Writing I |  |  |  | ENC 90
ENC 091 - Foundations of College Writing II |  |  |  | ENC 91
MAT 055 - Pre-Algebra |  |  |  | MAT 055
MAT 065 - Basic Algebra with Measurements |  |  |  | MAT 065
MAT 085 (MAT 120) - Intermediate Algebra |  |  |  | MAT 085
Computer (digital) literacy completed
General Education Courses (Core Curriculum/Prerequisites) |  |  |  |  | Credit  Hours | Courses | Grade | Notes
ENG 101 or higher |  |  |  |  | 3
MAT 126 or higher |  |  |  |  | 3 |  |  | BS transfer students should take MAT150 or higher
Social/Behavioral Sciences |  |  |  |  | 3
Natural Sciences |  |  |  |  | 3 (4) |  |  | BS transfer students should take PHY171 or PHY231/PHY241
Heritage/Humanities |  |  |  |  | 3
Technical Core Requirements |  |  |  |  | Credit  Hours | Courses | Grade | Notes
CIT 105 Introduction to Computers |  |  |  |  | 3
CIT 111 Computer hardware and Software |  |  |  |  | 4 | CIT 111
CIT 120 Computational Thinking |  |  |  |  | 3 | CIT 120
CIT 150 OR CIT 155 OR CIT 157 |  |  |  |  | 3 |  |  | CIT155 is recommended
CIT 170 Database Design Fundamentals |  |  |  |  | 3 | CIT 170
CIT 180 Security Fundamentals |  |  |  |  | 3 | CIT 180
Level I Networking Course |  |  |  |  | 4
Approved Level I Programming Language Course |  |  |  |  | 3
CIT 291 CIT Capstone |  |  |  |  | 3 | CIT 291
Information Security Track |  |  |  |  | Credit  Hours | Courses | Grade | Notes
CIT 182 Perimeter Defense |  |  |  |  | 3 | CIT 182
CIT 184 Attacks and Exploits |  |  |  |  | 3 | CIT 184
CIT 217 UNIX/Linux Administration |  |  |  |  | 3 | CIT 217
Approved Network Elective Course |  |  |  |  | 3
Approved Network Elective Course |  |  |  |  | 3
Approved Security Elective Course |  |  |  |  | 3
Approved CIT Technical Course |  |  |  |  | 3
Approved CIT Technical Course |  |  |  |  | 3
Total Credit Hours |  |  |  |  | 68
SW Program Coordinator: [NAME] 7355 or [EMAIL]
VERY IMPORTANT - Please refer to the Curriculum Guide for important track information and course sequences
Please note that students may not use one course to fulfill multiple requirements
All incoming students must have First-Year Experience Course: FYE 105 (GEN 100 or GEN 102 prior to Spring 2013) within in the first two (2) semesters of college
Spreadsheet: 148396d1333386915-creating-a-report-to-show-vehicle-tax-due-tax-disc-log
Sheet: DN02 FGD

 |  |  |  |  | DN02 FGD
Registration number : | DN02 FGD |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | DAF |  | 2002-08-05 00:00:00 | 12 Months | 2003-08-01 00:00:00 | 1200
Specification : | 6 x 2 A (3 Axle) |  | 2003-07-31 00:00:00 | 12 Months | 2004-08-01 00:00:00 | 1200
Type : | FTGCF85.430 |  | 2004-07-30 00:00:00 | 12 Months | 2005-08-01 00:00:00 | 1200
1st Registered : | 01.08.02 |  | 2005-07-29 00:00:00 | 12 Months | 2006-08-01 00:00:00 | 1200
Engine : | XE CI 12.60 litre |  | 2006-07-31 00:00:00 | 12 Months | 2007-08-01 00:00:00 | 1200
[NAME] : | 44,000kg |  | 2007-07-31 00:00:00 | 12 Months | 2008-08-01 00:00:00 | 1200
 |  |  | 2008-07-31 00:00:00 | 12 Months | 2009-08-01 00:00:00 | 1200
 |  |  | 2009-07-23 00:00:00 | 12 Months | 2010-08-01 00:00:00 | £1,200 + £2.5 (Online Fee)
 |  |  | 2010-07-21 00:00:00 | 12 Months | 2011-08-01 00:00:00 | £1,200 + £2.5 (Online Fee)
Back To Index |  |  | 2011-07-28 00:00:00 | 12 Months | 2012-08-01 00:00:00 | £1,200 + £2.5 (Online Fee)
Spreadsheet: c08a861b-6323-41b9-bc2d-cb9ea777e794
Sheet: Transportation

 | 5. Transportation |  |  |  |  | Comments |  | Click here to return to Summary page
 | Green Transportation Actions
 | ACTION | Credit | Points Earned | Total Possible Points |  |  |  | FILL IN THE GREEN CELLS ONLY
 |  |  |  |  |  |  |  | CALCULATIONS ARE DONE AUTOMATICALLY
 | A) Modes of Transport Used Majority of Time to Get to Work | Enter # of People |  | 10
 | Total # Employees in office | 0 |  |  |  |  |  | If people use more than one of these methods to get to work please enter them in only one category. (i.e. If [NAME] bikes some days and carpools others enter him for either the bike/walk or carpool cell).  If you are unsure of how many people bike/walk- feel free to estimate.
 | Total # Bikers/walkers (3 points for every 25%) | 0
 | Total # People that take public transportation (3 points for every 25%) | 0
 | Total # People that carpool/vanpool (3 points for every 25%) | 0
 | B) Do you ever check out vehicles from Transportation Services? If so are they hybrids? | 2 Pts, Enter "YES", "NO", or "N/A" in cell below this one.
 |  | NO
 | C) Do you ever rent bikes from the CU Bike Station to run errands? (there are bike trucks available too!) | 2 Pts, Enter "YES" or "NO" in cell below this one. |  | 2
 |  | NO
 | D) Do you have a designated department bike? | 2 Pts, Enter "YES" or "NO" in cell below this one. |  | 2
 |  | NO
 | Total Transportation Points
Spreadsheet: 694892d1599857920-sumif-not-working-properly-productn-materials-planning-template
Sheet: BC 3mm

 |  |  |  | Total for 75 batches
100000025444 | 3.47
100000024051 | 160
100000024053 | 190.11
100000024052 | 0
100000025425 | 4
100000025424 | 4
100000025436 | 9.09
200000008863 | 133
100000024101 | 60
100000025380 | 1
100000025401 | 2
100000025391 | 0.5
100000025432 | 1.88
100000025873 | 218.41
100000029113 | 100
100000032512 | 596.53
100000044825 | 40
100000040473 | 365
100000040932 | 144.01
100000045271 | 100
Spreadsheet: vkaminski__40900__CASH_GasMat_0400MyCopy
Sheet: CF

INCOME STATEMENT - CASH FLOW ($000)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Offset For
Contract Year |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "CF_Table"
Calendar Year |  |  |  | 1999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals |  | 1
Months Of Operation
Escalation Factor - Fixed Transportation
Escalation Factor - Operating Expenses
Brazilian Exchange Rate
Revenues
Transportation Payments
 | Transportation Revenues
 | Total Revenues (Billed To TBS)
Expenses
Operation & Maintenance
 |  | (1)
 |  | (1)
 | Total O&M
 | WH Tax On Offshore Service (1)'s - Grossed Up
 | PIS/COFINS (Calc'd On Total O&M + W/H Tax)
 | Total Operating Expenses Including Taxes
Other Income/(Expenses)
 | Plus: Interest Income - Partner / Shareholder Loans
 | Plus: Transport Option Payment From TBS
 | Less: OPIC Agency Fee + Loan Guarantee Fee
 | Less: L/C Fee - Debt Service
 | Total Other Income / (Expenses)
Earnings Before Depr, Int & Taxes (EBDIT)
 | Less: Book Depreciation Expense
Earnings Before Int & Taxes (EBIT)
 | Less: Interest Expense - Senior Debt
 | Less: Interest Expense - Subordinated Debt
 | Less: IDC To Be Expensed
Earnings Before Interest On Net Equity (INE) & Taxes
 | Less: Interest On Net Equity (INE)
Earnings Before Taxes (EBT)
 | Less: Book Provision For Income Taxes
Earnings Before Sudam Credits
 | Add: Sudam Credits Applied Against Losses
PROJECT BOOK INCOME
 | Plus: Book Depreciation
 | Plus: IDC To Be Expensed
 | Plus: Book Provision For Income Taxes
 | Less: Sudam Credits Applied Against Losses
 | Less: Cash Taxes
 | Less: Principal Payments - Senior Debt
NET A-T CASH FLOW BEFORE SUBORDINATED DEBT REPAYMENT
 | Less: Principal Payments - Subordinated Debt
NET A-T CASH FLOW BEFORE TRAPPED CASH
 | Trapped Cash Loaned To Partners
 | Repayment Of Prior Year Trapped Cash Loans
NET A-T CASH FLOW DISTRIBUTED
Spreadsheet: 685094d1593712213-cant-combine-two-criteria-in-one-formula-mixed-drawdown-formula-v2-aligw
Sheet: Sheet2

Drawing taken: |  |  |  | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period
Period | Monthly |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  |  | Monthly
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
% Drawdown | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  | Total available |  | 197262 | 143568 | 157457 | 135678 | 134759 | 129140 | 103734 | 113546 | 148341 | 190054 | 164522 | 145717 | 149580 | 187115 | 105399 |  |  | 3
 |  |  | Reinvest |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  | Drawdown |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  | Select a value in B2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  | For every multtiple of that frenquency, Row 6 deducts the % set in B4. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  | Row7 shows what is drawn down. That works perfectly. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | If you select "Month" in B2, formula SHOULD do the same where the column date is the last in any month, but it doesn't. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
Spreadsheet: 769487d1645554786-unique-count-average-percentage-and-weekly-breakdown-member-check-ins-average-check-ins-testing
Sheet: Average Checkins per Age Group

Starting Age | Ending Age | Average Checkins
13 | 19 |  |  | IS THERE AN EASIER WAY TO DO THIS, RATHER THAN JUST DIVIDING THE TWO VALUES?
20 | 29 |  |  | IT WOULD BE THE UNIQUE NUMBER OF MEMBERS DIVIDED BY THE TOTAL NUMBER OF VISITS
30 | 39 |  |  | FOR 13-19 IT WOULD BE "2 / 9", SO 22.22%.
40 | 49 |  |  | FOR 20-29 IT WOULD BE "1 / 2", SO 50%.
50 | 59
60 | 69
70 | 79 |  |  | IS THERE A WAY TO SHOW 0, INSTEAD OF THE ERROR, IF NO CHECK INS EXIST FOR THAT AGE GROUP?
80 | 89
90 | 99999
Spreadsheet: hunter_shively__12722__Fundamentals_Netco
Sheet: Natural Gas Orig

 | Natural Gas Origination
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 1
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 11
 |  |  |  |  |  |  |  | Director | 143000 | 14
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 6
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 1
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 40032d1238351481-excel-2007-can-you-split-an-axis-on-a-graph-interaction-plots
Sheet: Sheet1

Intrasegmental
 | PE | CS |  | PE | CS |  | PE | CS |  | PE | CS |  | PE | CS
Level | 486 | 486 | Level | 826 | 826 | Level | 879 | 879 | Level | 672 | 672 | Level | 876 | 876
2.5 | 521 | 535 | 2.5 | 893 | 899 | 2.5 | 981 | 972 | 2.5 | 669 | 668 | 2.5 | 956 | 916
5 | 522 | 572 | 5 | 918 | 1014 | 5 | 1036 | 1061 | 5 | 786 | 779 | 5 | 909 | 970
7.5 | 473 | 539 | 7.5 | 902 | 1118 | 7.5 | 1119 | 1130 | 7.5 | 823 | 879 | 7.5 | 878 | 1045
10 | 524 | 541 | 10 | 1123 | 1265 | 10 | 1424 | 1170 | 10 | 1083 | 860 | 10 | 945 | 1096
15 | 545 | 576 | 15 | 1331 | 1487 | 15 | 1732 | 1171 | 15 | 1507 | 1030 | 15 | 1053 | 1394
Intersegmental
 | PE | CS |  | PE | CS |  | PE | CS
Level | 1463 | 1463 | Level | 1378 | 1378 | Level | 1212 | 1212
2.5 | 1622 | 1623 | 2.5 | 1457 | 1403 | 2.5 | 1283 | 1254
5 | 1703 | 1867 | 5 | 1604 | 1614 | 5 | 1322 | 1317
7.5 | 1773 | 2051 | 7.5 | 1751 | 1750 | 7.5 | 1271 | 1473
10 | 2250 | 2211 | 10 | 2381 | 1809 | 10 | 1556 | 1418
15 | 2732 | 2463 | 15 | 3049 | 1997 | 15 | 1979 | 1696
Interjoint
 | PE | CS |  | PE | CS |  | PE | CS
Level | 101 | 101 | Level | 188 | 188 | Level | 174 | 174
2.5 | 97 | 104 | 2.5 | 207 | 207 | 2.5 | 181 | 175
5 | 123 | 131 | 5 | 230 | 230 | 5 | 198 | 186
7.5 | 145 | 170 | 7.5 | 234 | 267 | 7.5 | 208 | 202
10 | 160 | 225 | 10 | 266 | 302 | 10 | 241 | 201
15 | 263 | 336 | 15 | 313 | 385 | 15 | 302 | 219