(If using the electronic spreadsheet, these calculations will be made automatically.) Calling a worksheet function from Visual Basic. (If using the electronic spreadsheet, these will be entered automatically.) G Enter the annual rent potential for those Section 8 contracts that are not being renewed if there are multiple Section 8 contracts at the property and some are not being renewed at this time. The following Sub procedure uses the Min worksheet function to determine the smallest value in a range of cells. F Multiply the sum of the monthly expiring Section 8 contract rent potential in (E) x 12 to get the annual rent potential for the expiring contract(s). (If using the electronic spreadsheet, this calculation will be made automatically.) If an Owner elects to combine the contracts into a single contract and there are units of the same bedroom type in the combined contracts, they should be combined into one rent level that will set the rent at an average that yields the same adjusted rent potential. Dim sheet As Worksheet Set sheet = ActiveWorkbook.Sheets.Add(After:=ActiveWorkbook.Worksheets(ActiveWorkbook.Worksheets.Count)) Note In 32-bit Excel 2010, this method cannot create more than 255 sheets at one time. When entering information please distinguish between similar units with different rents. ��ࡱ� > �� W Y ���� V �������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������� ` �� �% bjbj�s�s -P � � ~ x �� �� �� � � � � � � � � � " " " 8 D" d �" D � #4 � �" �" : 2# 2# 2# 2# . C M P Add the expiring Section 8 portion of the debt service (L) to the adjusted rent attributable to operations (O) to obtain the adjusted contract rent potential. For Each ws In Worksheets 'Update or do something here Next Update Every Worksheet in Workbook Using VBA. � (If using the electronic spreadsheet, this calculation will be made automatically.) OCAF Worksheet (Excel) Section 8 Contract Renewal Options Option 1 – Mark-Up-to-Market. Also reference the OCAF factors archive. Multiply the annual OCAF adjusted rent (W) by the number of units (T) to obtain the adjusted annual rent potential for each unit type in each contract/stage. H Enter the annual rent potential for the non-Section 8 units in the property if the property is not 100% Section 8. Clique em uma célula nos dados de origem ou no intervalo de tabela. For a project that receives Interest Reduction Payments, enter the Total Annual 1% Project Debt Service. O Multiply the annual expiring Section 8 rent potential attributable to operations (M) by the currently published OCAF for the area (N). (If using the electronic spreadsheet, these calculations will be made automatically.) 106-65, 111 Stat. Rounding to the nearest dollar figure can take place in Step Three when the new rents are calculated with the Increase Factor. (If using the electronic spreadsheet, these calculations will be made automatically.) `# t# �) �) �) �) = �) x N. x �2 $ �5 h -8 � �2 � �# 2# 2# �# �# �2 � � 2# 2# �2 t �% �% �% �# | � 2# � 2# �) �% �# �) �% �% g( � � �( 2# �" �O�TN�� " �# � ( �) s3 � #4 �( , �8 �$ � �8 �( �8 � �( � �# �# �% �# �# �# �# �# �2 �2 *% ^ �# �# �# #4 �# �# �# �# � � � D � � � � � � � � � � � � ���� OCAF Worksheet Instructions These instructions are for use by Owners of projects that require an Operating Cost Adjustment Factor (OCAF) calculation (rent adjustments, �lesser of� test, etc.). If you are working with a large amount of related data, you can use worksheets to help organize your data and make it easier to work with. OCAF Worksheet Instructions. V Multiply the Increase Factor (R) by the monthly contract rent (U) to obtain the OCAF adjusted rent. We recommend getting acquainted with the new COVID-19 protocols, procedures, and guidelines here before you schedule your visit. In this lesson, you will learn how to name and add color to worksheet tabs, as well as how to add, delete, copy, and move worksheets. M Subtract the annual expiring Section 8 share of debt service (L) from the total annual rent potential for the expiring Section 8 contract(s) (F) in order to calculate the annual expiring Section 8 rent potential attributed to operations. OCAF Rent Adjustment Worksheet U.S. Department of Housing and Urban Development Office of Housing Multifamily Section 8 Contracts Title V of the Departments of Veterans Affairs and Housing and Urban Development and Independent Agencies Appropriations Act of 1988 (P.L. The Oconee Cultural Arts Foundation (OCAF) is dedicated to remaining a safe and welcoming place for our community and visitors. S Enter the unit type(s) and contract/stage number (as in A). The Worksheet object is a member of the Worksheets collection. E Add all of the sums of Column D to get the monthly expiring Section 8 contract rent potential for the contract(s)/stage(s). If I remove all conditional formatting from the worksheet, I'm able to copy/paste again, but there does not appear to be any simple way to preserve/re-apply the formatting so it has to be re-done from scratch each time, which is quite time consuming. If the OCAF is 2.3%, enter 1.023. Enter information only for the Section 8 units in the project that are expiring. Any time I attempt to copy any cells from the worksheet, Excel 365 crashes immediately, before I try to paste or take any other action. The Sheets collection contains all the sheets in the workbook (both chart sheets and worksheets). Step Two Calculating the Increase Factor adjusted by the OCAF for the Expiring Contract(s). (If using the electronic spreadsheet, this calculation will be made automatically.) 4. OCAF Rent Adjustment Worksheet U.S. Department of Housing and Urban Development Office of Housing OMB NO. Q If applicable, compare the adjusted contract rent potential with the Market Rent Potential (from the RCS and reflected in the Renewal Request Forms). 106-65, 111 Stat. U Enter the current Section 8 monthly contract rents (as in C). OCAFsFor 2020For 2019For 2018For 2017For 2016 (Original Federal Register Oct. 5, 2016)For 2015For 2014For 2013For 2012For 2011For 2010For 2009For 2008For 2007For 2006For 2005For 2004 W Multiply the OCAF adjusted monthly rent (V) by 12 to obtain the annual adjusted rent for each unit type. (If using the electronic spreadsheet, this calculation will be made automatically.) OCAF Worksheet Instructions-REV 4-6-09 3 L Multiply the debt service (K) by the portion of the overall rent potential for the expiring Section 8 contract (J) in order to subtract the correct amount of debt service from the rent potential. The basic syntax for looping through every sheet in a workbook and applying VBA code to it is. �2j� � [Content_Types].xml �(� �UKO1���6����1�Ń����?����m�Π��]1� $z�W;�cf;ӿ[T.{��6�B\�]����X?-����s#2$�r�C!���np~�/#`��Q�[)Q�P)�C�+��*E���2*=SS��n�Z��. Current Year Fair Market Rents (FMRs) - … L Multiply the debt service (K) by the portion of the overall rent potential for the expiring Section 8 contract (J) in order to subtract the correct amount of debt service from the rent potential. Each entry of the OCAF Worksheet is explained below. � Published Operating Cost Adjustment Factor (OCAF) - Effective February 11, 2020, 2.5% for Minnesota or 1.025 for Line N on the OCAF Worksheet. A Enter the unit type (1-BR, 2-BR, etc.) OCAF Worksheet Instructions-REV 4-6-09. (If using the electronic spreadsheet, this calculation will be made automatically.) In Visual Basic, the Excel worksheet functions are available through the WorksheetFunction object.. OCAF Rent Adjustment Worksheet - HUD Form 9625 (Instructions) (a) Please insert -.35 into Cell D11 of the referenced Excel worksheet and confirm that, according to the resulting Panzar Analysis, if WMB’s price-difference elasticity is -.35, then the … The rent adjustment must be for the portion of the rent that is attributable to operations, there should be no rent increase on the portion of the rent that covers the debt service since this is a static figure. Excel.Worksheet excelWS = (Excel.Worksheet)excelWB.Worksheets["Plan1"]; Células que utilizarei para colocar os dados na planilha Defino o Range das células que trabalharei I Add the annual Section 8 rent potential for the expiring Section 8 contract(s) (F), the total annual rent potential for non-expiring Section 8 units (G), and the total annual rent potential for non-Section 8 units in the property (H) to calculate the total annual rent potential at the property. For a functioning example, copy and paste the following code into a module and run it. Federal Register 2.0 is the unofficial daily publication for rules, proposed rules, and notices of Federal agencies and organizations, as well as executive orders and other presidential documents. 2502-0533 (exp 11/30/2012) Multifamily Section 8 Contracts Public reporting burden for this collection of information is estimated to average 45 minutes per response, including the time for reviewing instructions, searching NOTE: All calculations should be taken out to the third decimal point (1.023). The Owner must provide this information. Download Download Ocaf worksheet instructions Read Online Read Online Ocaf worksheet instructions hud ocaf 2019 2018 ocaf factor 2018 ocaf adjustment oc… The Excel file “ Response_ WMB /OCA -T1 -1(f) .xls,” used to develop the charts in the or iginal response to WMB ... .xls,” worksheet tabs “Year 1,” “Year 2,” and “Year 3,” at cells I4 and L4, respectiv ely. If using the electronic spreadsheet, there are three worksheets, each with a separate tab at the bottom of the page. The HUD project manager may confirm this information by reviewing the project�s file. R Divide the adjusted contract rent potential (or market rent potential, if applicable)(Q) by the total annual rent potential for the expiring Section 8 contract(s) (F) to adjust the adjusted OCAF. For example, if there is an expiring contract with one bedroom apartments that have different rents enter 1BR-a, 1BR-b, etc. Take your analytics to the next level with Excel. We found some Images about Ocaf Worksheet: Instruction - Displaying top 8 worksheets found for this concept.. OCAF Rent Adjustment Worksheet U.S. Department of Housing and Urban Development Office of Housing Multifamily Section 8 Contracts Title V of the Departments of Veterans Affairs and Housing and Urban Development and Independent Agencies Appropriations Act of 1988 (P.L. C Enter the current monthly Section 8 contract rent (including utilities, if applicable) for the corresponding unit type. (If using the electronic spreadsheet, these will be entered automatically.) Due to the fact that the OCAF was applied only to the portion of the expiring Section 8 rent potential attributable to operations, the adjustment factor that will be applied to each of the rents will be slightly less than the published OCAF. Se você estiver usando o Excel for Mac 2011 e versões anteriores, o botão Tabela Dinâmica fica na guia Dados do grupo Análise. T Enter the number of units (as in B). � Multiply the OCAF adjusted monthly rent (V) by 12 to obtain the annual adjusted rent for each unit type. � � � � � � � � $ ������������ҥ�����q��b�b�b�b��� hS?� h�e CJ OJ QJ aJ "hS?� h�� 5�>*CJ OJ QJ aJ hS?� h�� 5�CJ OJ QJ aJ "hS?� h�� 5�:�CJ OJ QJ aJ hS?� hZJ@ CJ OJ QJ aJ hS?� h*>� CJ OJ QJ aJ hS?� h�c CJ OJ QJ aJ hS?� h�f� CJ OJ QJ aJ hS?� h�� CJ OJ QJ aJ h�� h�� 5�CJ. These instructions are for use by Owners of projects that require an Operating Cost Adjustment Factor (OCAF) calculation (rent adjustments, “lesser of” test, etc.). PK ! worksheet “Year 1” in the spreadsheet entitled Response_WMB -OCA -T1 -1(f).xls. Recapitalization Workbook Chapter 1—Know Your Property U.S. Department of Housing and Urban Development Office of Recapitalization HUD Preservation Workbook Please insert -.35 into Cell D11 of the referenced Excel worksheet and confirm that, according to the resulting Panzar Analysis, if WMB’s price-difference elasticity is -.35, then the WMB NSA will increase USPS contribution in Year 1 of the NSA at WMB’s After-Rates volume forecast of … (If using the electronic spreadsheet, these calculations will be made automatically.) (If using the electronic spreadsheet, this calculation will be made automatically.) N Enter the currently published OCAF for your area. X. Every Excel workbook contains at least one or more worksheets. (If using the electronic spreadsheet, this calculation will be made automatically.) X Multiply the annual OCAF adjusted rent (W) by the number of units (T) to obtain the adjusted annual rent potential for each unit type in each contract/stage. If no RCS was required, enter the adjusted contract rent potential. � NOTE: This step may not be applicable in all cases. Instruction Worksheets - there are 8 printable worksheets for this topic. If needed, you can copy worksheet data, charts, or objects and paste them as a static picture anywhere in a worksheet or chart. Ocaf Worksheet . N Step One Calculate the current Section 8 rent potential for expiring contracts. (If using the electronic spreadsheet, these calculations will be made automatically.) The Worksheets collection contains all the Worksheet objects in a workbook.The Worksheet object is also a member of the Sheets collection. It also has revised and simplified the Initial-Year Funding Tool, which is an Excel-based worksheet to help calculate the amount of revenue available to a project in the Initial Year of a RAD conversion. D Enter the lesser of the adjusted contract rent potential or the Market Rent Potential. Utility Allowance Factor (UAF) - Effective February 11, 2020. Acesse Inserir > Tabela Dinâmica. J Divide the annual Section 8 rent potential for the expiring Section 8 contract(s) (F) by the total rent potential of the project (I) to find out what portion of the property�s total annual rent potential is for the expiring Section 8 contract(s). � (If using the electronic spreadsheet, this calculation will be made automatically.) PAGE 4 PAGE 4 PAGE 4 OCAF Worksheet Instructions-REV 10-10-07 Contract Renewal Request 1 = @ A � � � L M � � � B Step Three Calculate the OCAF Adjusted Rent Potential for Expiring Section 8 Contract(s). O Excel criará uma Tabela Dinâmica em uma nova planilha e exibirá a Lista de Campos da Tabela Dinâmica. (If using the electronic spreadsheet, this calculation will be made automatically.) (If using the electronic spreadsheet, this calculation will be made automatically.) Search, browse and learn about the Federal Register. First, the variable myRange is declared as a Range object, and then it is set to range A1:C10 on Sheet1. K Enter the Debt Service, use the project�s current debt service, including new debt service for loans made for capital needs and or transfers (See Chapter 15 of the Section 8 Renewal Policy Guide) and the MIP for FHA loans. OCAF Worksheet 3 form HUD-9625 (10/2007) I (We) hereby certify that the statements and representations contained in or accompanying this instrument are true, accurate and complete to the best of my (our) knowledge and belief. D Multiply the current Section 8 contract rent (C) by the number of units (B) to get the monthly current Section 8 rent potential for the unit type. Microsoft Excel is the industry leading spreadsheet program, a powerful data visualization and analysis tool. For example: total rent for combined contracts ( total # units = Average (# of units X rent = total rents) B Enter the number of units that correspond to the unit type and contract/stage number. Y Add the total of the adjusted annual rent potential for each unit type in each contract/stage to calculate the total annual adjusted rent potential for the expiring contract(s). (If using the electronic spreadsheet, these will be entered automatically.) with the contract/stage number. Loop Through Every Sheet in Workbook. Each entry of the OCAF Worksheet is explained below. You can also paste data that you copied from another program and paste it as a picture in Microsoft Office Excel.