tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b38f365b-5365-4c84-9735-17025a22ff0c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | why size | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | why not just sec 8 now, proposed. [NAME]? Why size | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  | add project type |  |  | ocaf/ budget |  |  | then occpy
 |  |  | think thru difft types |  |  |  |  |  |  |  | Attachment 4b
 |  |  |  |  |  |  |  |  |  |  |  | Appendix 9-6b
 |  | Compare Section 8 Rents and [NAME] by Tenants Not Receiving Rental Assistance
 |  | Project Name: ____________ |  | ________________________________ |  |  |  |  |  |  | Date:
 |  | Project is(Circle one.):  236     BMIR      221d4/d3      202/811     Other  (Specify.____________)
 |  | A | B | C | D | E | F | G | H | I | J | K
 |  | Unit Type | Interior Sq. Ft | Current Sec  8 Contract Rent | Proposed Sec 8 Contract Rent | Avg. Rent for Units Without Assistance | Total Units at Project | # [NAME] 8 Units at Project     (all contracts) | #  Sec 8 Units Now Renewing | #  Units Offered Without Rental Assistance | # Units Occupied Without Rental Assistance | % of Total Occupied Without Rental Assistance                  (J / F)
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Important: | For each unit type, entry in last column must be at least 25%.
 |  |  |  |  | Attach rent roll showing units & rents used to compute the average in Column E.
 |  | The proposed Section 8 Rents were computed using:  Check One.
 |  |  | OCAF: | See OCAF Rent Adjustment Worksheet.
 |  |  |  | Attach completed OCAF Rent Adjustment Worksheet.
 |  |  |  |  | % increase allowed per OCAF is: |  |  |  |  | %
 |  |  | Budget: | See Form HUD-92547-A / Budget Worksheet of Handbook 4350.1.
 |  |  |  | Attach completed form HUD-92547-A / Budget Worksheet.
 |  |  |  | Current Budget Potential for Units being Renewed |  |  |  |  |  | $
 |  |  |  | New Budget Potential for Units Being Renewed |  |  |  |  |  | $
 |  |  |  |  | % increase in budget potential is: |  |  |  |  | %
 |  |  | Preparer's Name: |  |  |  |  |  |  | Date
 |  |  | Preparer's Title: |  |  |  |  |  |  | Date
 |  |  | Owner's Signature: |  |  |  |  |  |  | Date
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R24

Ime artikla
Spreadsheet: 875393d1721973983-need-sum-data-vertically-te
Sheet: Summary

EMP No | Name | V | PH | S | U | A
00001 | [NAME] | 4 | 4 | 3 | 1 | 2
00002 | Demian | 10 | 3 | 0 | 0 | 0
00005 | [NAME] | 3 | 1 | 2 | 0 | 0
00015 | MOHAMMAD | 18 | 2 | 0 | 0 | 0
00018 | MEGZARI | 21 | 2 | 1 | 1 | 0
 |  |  |  |  |  |  |  | v | Vacation
 |  |  |  |  |  |  |  | PH | Public Holdiday
 |  |  |  |  |  |  |  | S | [NAME]
 |  |  |  |  |  |  |  | U | Unpaid
 |  |  |  |  |  |  |  | A | Absent
Spreadsheet: 0f5d1feb-673f-48ff-af58-740d1807e773
Sheet: 1.18

Table 1.18: Registered divorces by country (2000-2012)
Country | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
Bahrain | 769 | 801 | 838 | 923 | 1030 | 1051 | 1141 | 1198 | 1323 | 1459 | 1569 | 1408 | 1649
Egypt | 68991 | 70279 | 70069 | 69867 | 64496 | 65047 | 65461 | 77878 | 84430 | 141467 | 149376 | 145505 | …
Iraq | ... | ... | ... | ... | ... | ... | ... | ... | ... | 52649 | 53840 | ... | ...
Jordan | 8241 | 9017 | 9032 | 9022 | 9791 | 10231 | 11413 | 11793 | 12826 | 15442 | 15707 | 16086 | ...
Kuwait | 3649 | 3851 | 3891 | 3998 | 4899 | 4538 | 4239 | 4945 | 4907 | 5932 | 5965 | 6254 | …
Lebanon | 4282 | 4480 | 4060 | 4328 | 4372 | 4746 | 4388 | 5859 | 5389 | 5957 | 5897 | 6879 | 6498
Libya | 1444 | 1662 | 1683 | 1641 | 1777 | 2077 | 1786 | 2813 | 2989 | … | … | … | …
Morocco | … | … | … | … | … | … | … | … | 27935 | 24170 | 22452 | … | …
Oman | ... | ... | ... | 26359 | ... | ... | ... | ... | 2816 | 2505 | 3661 | 3805 | …
Palestine | 3546 | 3687 | ... | ... | ... | ... | ... | … | 5009 | 5761 | 6150 | 6155
Qatar | 615 | 566 | 732 | 790 | 787 | 643 | 826 | 997 | 939 | 1108 | 1172 |  | …
Saudi Arabia | 18583 | 16725 | 18765 | 20794 | 24435 | 24318 | 24428 | 28561 | 28867 | 31218 | 31072 | 34622
Sudan | ... | ... | ... | ... | ... | ... | ... | ... | 2816 | ... | ...
Syrian Arab Republic | 7171 | 13077 | 14314 | 14314 | 17336 | 17821 | 19984 | 19506 | 22661 | 29525 | 28202 | … | …
Tunis | 11017 | 9706 | 10562 | 10212 | 10062 | 11576 | 11711 | 12557 | 12035 | 12822 | 12871 | 12651 | ...
United Arab Emirates | 2392 | 2832 | 3390 | 3243 | 3577 | 3617 | 3335 | 3657 | 3855 | 4076 | 4194 | 4145 | ...
Yemen | 507 | 617 | 998 | 104 | 33 | ... | ... | ... | ... | ... | ... | ... | ...
* Data for the years 2009 - 2010 include West Bank only and excludes Gaza Strip.
Spreadsheet: 57740d1257957496-formula-to-count-based-on-various-different-sections-new-availability-report
Sheet: Summary

Number of people with 14+ hours unassigned wc 02/11/09
 | 0304001 Risk | 0303001 IT Risk and Assurance | 01332 Supply Chain & Operations | 01384 Consultants | 01406 Customer | 01492 People and Organisational Chg | 01493 Finance&Performance Management | 01494 Process | 01495 Programme Advisory Services | 01499 Strategic Performance | 01501 IT Enablement
 | RISK | ITRA | SC&O | PI Consultants | Customer | P&OC | F&PM | Process | PAS | SP | ITA
Executive Director |  |  |  | N/A
Senior Manager |  |  |  | N/A
Manager |  |  |  | N/A
Senior |  |  |  | N/A
Staff/Assistant |  |  | N/A |  | N/A | N/A | N/A | N/A |  | N/A
Total
Number of people on unconfirmed work w/c 02/11/09
 | RISK | ITRA | SC&O | PI Consultants | Customer | P&OC | F&PM | Process | PAS | SP | ITA
Directors - Uncon |  |  |  | N/A
Senior Manager - Uncon |  |  |  | N/A
Manager - Uncon |  |  |  | N/A
Senior Consultant/Executive - Uncon |  |  |  | N/A
Consultant/Associate - Uncon |  |  | N/A |  | N/A | N/A | N/A | N/A |  | N/A
Total - Uncon
Number of people on NBD work w/c 02/11/09
 | RISK | ITRA | SC&O | PI Consultants | Customer | P&OC | F&PM | Process | PAS | SP | ITA
Directors - NBD |  |  |  | N/A
Senior Manager - NBD |  |  |  | N/A
Manager - NBD |  |  |  | N/A
Senior Consultant/Executive - NBD |  |  |  | N/A
Consultant/Associate - NBD |  |  | N/A |  | N/A | N/A | N/A | N/A |  | N/A
Total - NBD
 | RISK | ITRA | SC&O | PI Consultants | Customer | P&OC | F&PM | Process | PAS | SP | ITA
Totals
Key
60% or greater of population available
Greater then 20% but less then 60% of population available
20% or less of population available
Spreadsheet: 858203d1706947171-shorten-formula-book1
Sheet: Sheet1

[NAME] | APPLES | MONDAY | 43 |  |  | Fred | Bananas | Sunday
PETER | ORANGES | TUESDAY | 21 |  |  | [NAME] | Pears | Saturday
[NAME] | MANGOS | THURSDAY | 33 |  |  | [NAME] | Oranges | Tuesday
Spreadsheet: 16ec9453-9603-4705-be4a-65b8f778d546
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
Elementary | Fall 2011 | Sp 2012 | Fall 2012 | Sp 2013 | Fall 2013 | Sp 2014
Lang Arts | 25 | 27 | 23 | 24 | 23 | 24
Math | 28 | 19 | 22 | 23 | 21 | 20
Social Studies | 24 | 14 | 19 | 21 | 18 | 23
Science | 28 | 25 | 21 | 20 | 25 | 22
Early Childhood-PBC | Fall 2011 | Sp 2012 | Fall 2012 | Sp 2013 | Fall 2013 | Sp 2014
Spreadsheet: benjamin_rogers__1221__UAE latest O&M costs from Scott
Sheet: O&M_Estimate

Commercial Operations O&M Estimate
 |  |  |  | US$
 |  |  |  | Annual
Payroll & Burden
Administration and Operations Expenses
 |  |  |  | 50000
 |  |  |  | 0
 | Total Administration & Operations Expenses
Chemicals @ 14% Plant Load Factor (PLF)
[NAME] (excl. GT ScheduIed Maint. Program)
 |  |  |  | 25000
 |  |  |  | 25000
 |  |  |  | 10000
 | Total Maintenance
Sustaining Capital Expenses
Total O&M Expenses (excl GT Scheduled Maint. Program)
GT Scheduled Maintenance Program |  | 20 yr total |  |  | Annual Avg.
 |  |  |  | $/Mwh @ 14% PLF
Total Plant O&M Expenses |  |  |  |  | Annual Avg.
 |  |  |  | $/Mwh @ 14% PLF
Housing Colony Operating Expenses
Commercial Office Expenses
Total Project Operating Expenses |  |  |  |  | Annual Avg.
 |  |  |  | $/Mwh @14% PLF
OM&A Annual Fee
Operator Overhead Charge (G&A)
Spreadsheet: 477619d1472412477-how-to-highlight-multiple-cells-based-off-a-value-fantasy-football
Sheet: RB

 | Roto
RK | Player | Pos | Team | Bye
1 | [NAME] | RB | ARZ | 9
2 | [NAME] | RB | LAR | 8
3 | [NAME] | RB | MIN | 6
4 | [NAME] | RB | DAL | 7
5 | [NAME] | RB | HOU | 9
6 | [NAME] | RB | KC | 5
7 | [NAME] | RB | PIT | 8 | week 4
8 | [NAME] | RB | ATL | 11
9 | M. Ingram | RB | NO | 5
10 | E. Lacy | RB | GB | 4
11 | [NAME] | RB | BUF | 10
12 | [NAME] | RB | TB | 6
13 | [NAME] | RB | NYJ | 11
14 | [NAME] | RB | DEN | 11
15 | [NAME] | RB | SF | 8
16 | [NAME] | RB | SEA | 5
17 | [NAME] | RB | IND | 10
18 | [NAME] | RB | CAR | 7
19 | Latavius Murray | RB | OAK | 10
20 | [NAME] | RB | PHI | 4
21 | [NAME] | RB | TEN | 13
22 | [NAME] | RB | SD | 11
23 | [NAME] | RB | CHI | 9
24 | [NAME] | RB | WAS | 9
25 | [NAME] | RB | CIN | 9
26 | [NAME] | RB | NYG | 8
27 | [NAME] | RB | MIA | 8
28 | [NAME] | RB | CLE | 13
29 | [NAME] | RB | SD | 11
30 | [NAME] | RB | CIN | 9
31 | [NAME] | RB | TB | 6
32 | [NAME] | RB | JAC | 5
33 | [NAME] | RB | DET | 10
34 | [NAME] | RB | PIT | 8
35 | J. Ajayi | RB | MIA | 8
36 | [NAME] | RB | BAL | 8
37 | [NAME] | RB | NE | 9
38 | [NAME] | RB | JAC | 5
39 | [NAME] | RB | TEN | 13
40 | [NAME] | RB | CLE | 13
41 | [NAME] | RB | MIN | 6
42 | [NAME] | RB | KC | 5
43 | [NAME] | RB | NYJ | 11
44 | [NAME] | RB | KC | 5
45 | [NAME] | RB | GB | 4
46 | [NAME] | RB | ATL | 11
47 | [NAME] | RB | SEA | 5
48 | [NAME] | RB | ARZ | 9
49 | [NAME] | RB | DAL | 7
50 | [NAME] | RB | DEN | 11
51 | [NAME] | RB | DAL | 7
52 | T. Hightower | RB | NO | 5
53 | S. Vereen | RB | NYG | 8
54 | [NAME] | RB | BAL | 8
55 | [NAME] | RB | DET | 10
56 | [NAME] | RB | WAS | 9
57 | [NAME] | RB | NE | 9
58 | [NAME] | RB | NE | 9
59 | [NAME] | RB | PHI | 4
60 | [NAME] | RB | BAL | 8
61 | [NAME] | RB | WAS | 9
62 | D. Washington | RB | OAK | 10
63 | [NAME] | RB | SEA | 5
64 | [NAME] | RB | CHI | 9
65 | [NAME] | RB | NYG | 8
66 | [NAME] | RB | PHI | 4
67 | [NAME] | RB | DET | 10
68 | [NAME] | RB | IND | 10
69 | [NAME] | RB | ARZ | 9
70 | [NAME] | RB | NO | 5
71 | [NAME] | RB | FA | 0
72 | [NAME] | RB | CAR | 7
73 | [NAME] | RB | HOU | 9
74 | [NAME] | RB | NYJ | 11
75 | [NAME] | RB | TEN | 13
76 | [NAME] | RB | OAK | 10
77 | [NAME] | RB | IND | 10
78 | [NAME] | RB | LAR | 8
79 | [NAME] | RB | PHI | 4
80 | [NAME] | RB | BUF | 10
81 | [NAME] | RB | MIA | 8
82 | [NAME] | RB | SF | 8
83 | [NAME] | RB | BUF | 10
84 | [NAME] | RB | DEN | 11
Spreadsheet: 776254d1649645784-big-cleaning-data-excelforum_merge_subst
Sheet: Eliminate

 |  |  | Level1 |  | Level2 |  | Level3
 |  |  | From | To | From | To | From | To
 |  | 1 | ȁ | a | ī | i
 |  |  | ȃ | a | ṧ | s | /.
 |  |  | ẩ | a | /// |  | str | str.
 |  |  | ĉ | c | // |  | str. | str.
 |  |  | č | c | / | / | >
 |  |  | ḉ | c | avenue/ | avenue | *
 |  |  | ɗ | d | - |  | ?
 |  |  | ḍ | d | - | - | ^
 |  |  | ḏ | d | -- | - | ave nue | avenue
 |  |  | ė | e | -- | - | [
 |  |  | ê | e | -..- |  | ]
 |  |  | ë | e | /- |  | … | . |  | Note: H15 & F17 are not the same
 |  |  | ġ | g | .- |  | ⌂
 |  |  | ĝ | g |  |  | ă | a
 |  |  | ǧ | g | , |  | %
 |  |  | ḣ | h | ;
 |  |  | ĥ | h | bl. | block
 |  |  | ḧ | h | ¶
 |  |  | ǐ | i | .
 |  |  | ĭ | i | ~
Spreadsheet: 60563d1261075186-excel-2007-autofill-help-current-frieght-cc-test
Sheet: ConwayCC

Conway CC |  |  |  |  |  |  |  |  |  | Fuel Charge: |  | 0.2
State | First | Additional | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
AL | 85 | 45
AR | 100 | 45
AZ | 170 | 75
CA | 175 | 90
CO | 170 | 70
CT | 90 | 45
DC | 100 | 35
DE | 100 | 40
FL | 90 | 45
GA | 80 | 30
IA | 105 | 50
ID | 170 | 90
IL | 95 | 42
IN | 95 | 40
KS | 105 | 50
KY | 90 | 35
LA | 110 | 50
MA | 100 | 45
MD | 85 | 35
ME | 110 | 55
MI | 95 | 40
MN | 100 | 55
MO | 100 | 40
MS | 100 | 40
MT | 175 | 100
NC | 65 | 30
ND | 170 | 65
NE | 110 | 65
NH | 105 | 45
NJ | 85 | 40
NM | 170 | 70
NV | 175 | 85
NY | 100 | 45
OH | 95 | 30
OK | 100 | 50
OR | 175 | 80
PA | 85 | 35
RI | 105 | 45
SC | 72 | 30
SD | 170 | 60
TN | 80 | 35
TX | 105 | 50
UT | 175 | 70
VA | 75 | 30
VT | 105 | 50
WA | 150 | 80
WI | 100 | 40
WV | 105 | 35
WY | 150 | 80
Spreadsheet: 59811d1260364638-auto-link-to-another-worksheet-when-text-is-entered-in-cell-adhoc-metrics-sample
Sheet: UCAs

 |  |  |  |  |  |  |  |  |  | Today = Past Due Date
 |  |  |  |  |  | UCAs
Date Entered | Master Document # | Award # | Award Date | Contracting Officer |  | Due Date | Definitization Date | Definitized Amount ($) | Due Date to Definitization Date (days) | Today's Date to Due Date (days)
2008-10-04 00:00:00 | W813LT92323679 | W911QX-09-C-0078 | 2008-10-01 00:00:00 | Kathy |  | 2009-01-02 00:00:00 | 2009-02-01 00:00:00 | 1500000 | 30 | -341.3403380787058
2009-01-02 00:00:00 | W813LT60895213 | W911QX-09-C-0091 | 2008-12-26 00:00:00 | [NAME] |  | 2009-01-22 00:00:00 | 2009-02-24 00:00:00 | 2560000 | 33 | -321.3403380787058
2009-02-19 00:00:00 | W813LT60895343 | W911QX-09-C-0122 | 2009-02-11 00:00:00 | Christi |  | 2009-02-26 00:00:00 | 2009-03-15 00:00:00 | 2506400 | 17 | -286.3403380787058
2009-12-09 00:00:00 | W71B7J43234480 | W911QX-10-C-0019 | 2009-09-07 00:00:00 | [NAME]
Spreadsheet: 455934d1460567416-auto-populate-data-across-worksheets-test
Sheet: Party List

222
4785
8896
121214
14257
4511
2112
Spreadsheet: 31559d1227450524-lookup-multiple-instances-and-display-in-columns-extract-repts
Sheet: raw

ITEMNMBR | RCPTNMBR | DATERECD |  |  |  |  |  | ITEMNMBR
25 | GRN-0008567 | 2008-09-22 00:00:00 |  |  |  |  |  | 25
33 | GRN-0005857 | 2008-04-21 00:00:00 |  |  |  |  |  | 33
33 | GRN-0007252 | 2008-07-06 00:00:00 |  |  |  |  |  | 3600
3600 | GRN-0005514 | 2008-04-07 00:00:00 |  |  |  |  |  | 32511
3600 | GRN-0005514 | 2008-04-07 00:00:00
32511 | GRN-0005190 | 2008-03-24 00:00:00
32511 | GRN-0005367 | 2008-03-31 00:00:00
Spreadsheet: 839590d1692104589-how-to-concatenate-and-show-ranking-formulas-ranking-example
Sheet: Sheet1

Name 1 | [NAME] | Address | Phone No | Visits
Elvis | Presley | 2 West Street | 55987 | 23
[NAME] | [NAME] | 15 West Street | 16579 | 18
Clint | Eastwood | 2 North Row | 78945 | 4
[NAME] | Wayne | 54 East Avenue | 22265 | 66
 | How to rank and show Full name and amount of visits:
 | Rank 1 = [NAME] 66
 | Rank 2 = [NAME] 23
 | Rank 3 = [NAME] 18
 | Rank 4 = [NAME]
 | Name have been concatenated also
Spreadsheet: 858535d1707181037-expense-sheet-adding-additional-expense-to-first-month-new-prepaids-formula-help
Sheet: Invoices

2023 Invoices |  |  |  |  |  | # days in month
1125-0000 |  |  |  |  |  | start of month | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2024-12-01 00:00:00
 |  |  |  |  |  | end of month |  | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 |  | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00
VENDOR | Period Added to GL | Beginning Date of Expense | End Date of Expense | Total Expense | # Days | Expense Per Day | Balance 12/31/2022 | Jan - 2023 | Feb - 2023 | Mar - 2023 | Apr - 2023 | May - 2023 | Jun - 2023 | Jul - 2023 | Aug - 2023 | Sep - 2023 | Oct - 2023 | Nov - 2023 | Dec - 2023 | Balance 12/31/2023 | Jan - 2024 | Feb - 2024 | Mar - 2024 | Apr - 2024 | May - 2024 | Jun - 2024 | Jul - 2024 | Aug - 2024 | Sep - 2024 | Oct - 2024 | Nov - 2024 | Dec - 2024 | Balance 12/31/2024
Special Care Systems | 5/1/2023 | 2023-05-01 00:00:00 | 2024-04-30 00:00:00 | 37396.2
Vizient | 6/1/2023 | 2023-06-01 00:00:00 | 2024-05-31 00:00:00 | 21218
Healthstream (Staff Development) | 1/1/2023 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 1792
RQI | 2/1/2023 | 2023-03-01 00:00:00 | 2023-05-31 00:00:00 | 8134.37
Healthstream (Staff Development) | 3/1/2023 | 2023-03-01 00:00:00 | 2023-05-31 00:00:00 | 7728.02
[NAME], LLC | 2023-11-01 00:00:00 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 | -9569.7
[NAME] | 4/1/2023 | 2022-10-24 00:00:00 | 2023-10-23 00:00:00 | 5181
Issues to solve:
Total Expense is a negative amount -- balance not calculating
Beginning Date of Expense occurs BEFORE Period added to GL  -- How to add additional months of expense to first month
The expense amount on 4/1/23 should include any amount previously unexpensed (from 10/24/22 through 4/1/23)
Spreadsheet: 685733d1594160357-need-to-pull-a-max-value-based-on-highest-quarter-of-a-date-range-interest
Sheet: Sheet1

Example |  |  |  | Interest Tables
Amount Paid | 500 |  |  | Name | Effective Date Range | Begin Date | End Date | Rate as Decimal
Begin Date | 2017-01-15 00:00:00 |  |  | 4Q2019 | 10/1/2019-12/31/2019 | 2019-10-01 00:00:00 | 2019-12-31 00:00:00 | 1.2e-05
End Date | 2019-04-05 00:00:00 |  |  | 3Q2019 | 7/1/2019-9/30/2019 | 2019-07-01 00:00:00 | 2019-09-30 00:00:00 | 1.1e-05
Number of Days |  |  |  | 2Q2019 | 4/1/2019-6/30/2019 | 2019-04-01 00:00:00 | 2019-06-30 00:00:00 | 1.6e-05
Interest Rate |  |  |  | 1Q2019 | 1/1/2019-3/31/2019 | 2019-01-01 00:00:00 | 2019-03-31 00:00:00 | 1.9e-05
Amount of Interest |  |  |  | 4Q2018 | 10/1/2018-12/31/2018 | 2018-10-01 00:00:00 | 2018-12-31 00:00:00 | 2e-05
 |  |  |  | 3Q2018 | 7/1/2018-9/30/2018 | 2018-07-01 00:00:00 | 2018-09-30 00:00:00 | 2.7e-05
Answer should be 13.77 in B7 |  |  |  | 2Q2018 | 4/1/2018-6/30/2018 | 2018-04-01 00:00:00 | 2018-06-30 00:00:00 | 1.1e-05
 |  |  |  | 1Q2018 | 1/1/2018-3/31/2018 | 2018-01-01 00:00:00 | 2018-03-31 00:00:00 | 1.7e-05
 |  |  |  | 4Q2017 | 10/1/2017-12/31/2017 | 2017-10-01 00:00:00 | 2017-12-31 00:00:00 | 2.5e-05
 |  |  |  | 3Q2017 | 7/1/2017-9/30/2017 | 2017-07-01 00:00:00 | 2017-09-30 00:00:00 | 1.3e-05
 |  |  |  | 2Q2017 | 4/1/2017-6/30/2017 | 2017-04-01 00:00:00 | 2017-06-30 00:00:00 | 3.4e-05 | should pull this one
 |  |  |  | 1Q2017 | 1/1/2017-3/31/2017 | 2017-01-01 00:00:00 | 2017-03-31 00:00:00 | 2.2e-05
Spreadsheet: sara_shackleton__37808__Merced Amend 1 to ISDA 091801
Sheet: ISDA

AMENDMENT REQUEST TO ISDA SWAP AGREEMENT - INFORMATION SHEET
 |  | ATTORNEY:
DATE: |  | DEAL MAKER: | [NAME]
COUNTERPARTY: | Merced Irrigation District | CONTACT:
ADDRESS: | 744 West 20th Street | TITLE:
 | Merced, CA 95344 | PHONE:
 |  | FAX:
Incorporation State | CA irrigation district formed under the CA Water Code | S&P / Moody's Rating:
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) | n/a | Enron Corp. (BBB+)
LIMIT $ MILLIONS |  | 50000000
Incorporation State |  | OR
ELEGIBLE SWAP PARTICIPANT
Counterparty | X
Guarantor |  | X
COLLATERAL  THRESHOLD MATRIX | COUNTERPARTY | ENA (measuring Enron Corp.)
 | 8000000 | 40000000
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO: |  | Enron Corp.
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change | X | X
-Below = S&P | BBB- or Baa3 | BBB- or Baa3 | FOR COUNTERPARTY:
 | Certificates of Participation of Merced Irriation District, CA or Merced Irrigation District Public Facilities Financing Corporation | Senior Unsecured Debt | If any, the Underlying Rating by Moody's or SPUR Rating by S&P
Financial Covenants
-Funded Debt to Worth
-Minimum Net Worth | 35000000
-EBIT/Interest Expense | 2.0 to 1.0
-Funded Debt / EBITDA
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
-Reg Out/Ability to Set/Raise Rates | CP has the ability to set and raise user electric rates
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty | 2500000
-Guarantor |  | 100000000
Change in ownership
SPECIFIED ENTITY
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | (503) 464-8755
Spreadsheet: chris_germany__2339__2001new03
Sheet: 3rd Party Deals

 |  |  |  |  |  |  |  |  |  |  |  |  | 656574
 |  |  |  |  | EOG |  |  |  | EES |  |  |  | New Power Pool Supply
 | A06 |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | P10 |  |  |  |  | Total | Net
 | 597271 | Price | Amount |  | 597290 | Price | Amount |  | 597293 | Price | Amount |  |  | Price | Amount |  |  | Receipt | Citygate
1 | 3285 |  |  |  | 3942 |  |  |  | 3026 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 15418
 |  |  |  |  |  |  |  |  | 0 |  |  |  | 14333
 |  |  |  |  |  |  |  |  |  |  |  |  | 18970
 |  |  |  |  |  |  |  |  |  |  |  |  | 11000
 |  |  |  |  |  |  |  |  |  |  |  |  | 8912
 |  |  |  |  |  |  |  |  |  |  |  |  | 8912
 |  |  |  |  |  |  |  |  |  |  |  |  | 8912
 |  |  |  |  |  |  |  |  |  |  |  |  | 8912
 |  |  |  |  |  |  |  |  |  |  |  |  | 8912
 |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 12854
 |  |  |  |  |  |  |  |  |  |  |  |  | 15354
 |  |  |  |  | 1581 |  |  |  |  |  |  |  | 24473
 |  |  |  |  | 0 |  |  |  |  |  |  |  | 57973
 |  |  |  |  |  |  |  |  |  |  |  |  | 32031
29 |  |  |  |  |  |  |  |  |  |  |  |  | 24229
30
31 |  |  |  |  |  |  |  |  |  |  |  |  | 21414
Spreadsheet: drew_fossum__8882__MarchForecast
Sheet: TW-O&M

[NAME]
2000 O & M EXPENSE (000'S) - NET - 1ST QUARTER
 |  | 1999 Actuals |  | Prior Forecast |  | Forecast |  | Plan |  | Var. from Plan | Description
Direct Costs
Executive
Finance & Accounting |  |  |  |  |  |  |  |  |  |  | Savings distribution
Systems
Transportation Marketing |  |  |  |  |  |  |  |  |  |  | Savings distribution
Business Services |  |  |  |  |  |  |  |  |  |  | Savings distribution
Market Services
Regulatory Affairs & Administration |  |  |  |  |  |  |  |  |  |  | Savings distribution
TW Commercial Group
Operations |  |  |  |  |  |  |  |  |  |  | DOT fees reserve reversal, $153M, Timing
General & Administrative |  |  |  |  |  |  |  |  |  |  | $(200) Fuji lease reduction offset in corp. overview
Stretch
Total Direct Costs
GPG Allocations
Legal  (Co.  508) |  |  |  |  |  |  |  |  |  |  | OH reclass, $(200) [NAME] reversal
Finance & Accounting  (Co. 422) |  |  |  |  |  |  |  |  |  |  | OH reclass
Operations Technical Services  (Co. 423)
Human Resources  (Co. 507) |  |  |  |  |  |  |  |  |  |  | OH reclass
Executive |  |  |  |  |  |  |  |  |  |  | OH reclass, Ad Valorem Tax reclass $30; rev. OH $57
Other
Total GPG Allocations
Corporate Allocations
MMF
ECM
Insurance
Direct - EMI Co 001
Direct - Corp Co 011 |  |  |  |  |  |  |  |  |  |  | Ad Valorem  reclass $(30)
Aviation
EIS
EPSC - Co 901
EDS Delta |  |  |  |  |  |  |  |  |  |  | Capitalization deferred to 1st Qtr
Other
Total Corporate Allocations
Total O&M Expense