Orange County NC Website
Browse       Search
*The forms look the same, but the user experience is completely different <br />Quick Summary of Improvements <br />① <br />② <br />③ <br />④ <br />⑤ <br />⑥ <br />⑦ <br />⑧ <br />⑨ <br />⑩ <br />Instructions for use <br />① <br />② <br />③ <br />④ <br />⑤ <br />⑥ <br />⑦ <br />⑧ <br />⑨ <br />⑩ <br />⑪ <br />⑫ <br />Welcome to the New Improved HCCBG Provider Packet* <br />Increased number of service selections available on forms (increased from 8 to 14). <br />Electonic copy of workbook limits need to input all new data each year, just what changed. <br />Worbook is set up to be a 10 year workbook, just select the fiscal year from list on the "Input" worksheet and it populates all required dates for the new <br />year. <br />Dramatic reduction in keystrokes required! When you enter information now, it automatically forwards the value to the next sheet in the packet requiring <br />that information. <br />Calculation formulas are already included throughout, including match calculations. <br />Useful header information; click on a header row and it describes the field name and how to complete cell or column it labels. <br />732A instructions: Click on row desriptors to left and header cells, instruction on how to complete section or column will show. This is a complicated <br />sheet, it is recommended to review video link above prior to completion. Please check for red error messages that pop up below each section and at <br />bottom of page. <br />Detail service information by level eliminates requirement of In-home supplement form. <br />Salary calculation for fractional FTE reduces math errros on 732A1 Labor Distribution Schedule. <br />Color coding of input cells. If it is tan it is calculated and locked, if it is green it will accept your input. <br />Entry proof and error checking… if the system detects an error it will pop up a warning message. Need a second look? make sure no errors are on the new <br />"Proof" worksheet. <br />Read the "instructions" worksheet first. For a video walkthough of the HCCBG Provider Packet Please click on the link below. GoToMeeting will request <br />name/email information to register. When video launches please forward through the first 1:30 of the video as the screen is black prior to the video <br />starting, additionally, the webinar launches in "letterbox" format, to make larger click in the presentation and select the arrows in the lower right hand <br />corner. <br />Green cells on Input tab must be completed, they are necessary to populate entire workbook. Provider will not need to complete all cells for services, only <br />for the number of unique HCCBG services they provide. Tan cells are formulas, so let the program fill in the values there. <br />Navigation throgh worksheet is left to right, progress throught the workbook completing the green shaded cells <br />Click on the header cells, the specific instruction on what is necessary to complete the cell will pop up when clicked. <br />7321A new feature: Assignable salary is calcualated based on the FTE value multiplied by the staff salary. This assigned salary must also be categorized into <br />Admin or one of the services selected. The "assigned salary" must match the total keyed into green cells, or an error will pop up at the end of the row. <br />https://attendee.gotowebinar.com/recording/1667454861360868867 <br />Save a copy of your file, and submit an electronic copy to the county and/or COG. A signed copy of the forms is also required, but please be aware that <br />some forms are not printer friendly as the forms are wider to incoporate a wider service selection. <br />In-Home Supplement is hidden as it is no longer required by most AAAs, if your AAA requires it, you will need to right click in the tab area of the workbook <br />and select unhide from the box that pops up. When clicking on unhide a few worksheet names are selected you will need to select the "In-Home Svc <br />Supplement Worksheet." <br />732 instructions: Much less to complete here as most cells are populated from the 732A form, must select drop down indicator for direct or purchased <br />service, and HCCBG clients anticipated to be served. If you are an adult day care or adult day health provider, please populate the administrative portion at <br />bottom of the page, those cells are not automatcially filled. <br />733 Instructions: Complete green shaded text box with narrative on outreach activites you have implemented or plan to pursue. <br />734 form Instructions (Standard Assurances and Client Rights Assurances): Read it, sign it and submit. <br />Proof Sheet: will display known calculation errors or questions. Please use this form to check for internal consistency and discuss issues with county or <br />COG staff. Errors are displayed with a specific message, and value of calculated variance is to the right of the message. <br />DocuSign Envelope ID: 16A1D963-40F9-46F1-A38B-8B0D62C87C54