The Local 176 monthly reporting form was created in Excel 2000/XP. You must have Excel on your computer to be able to use this computer form.
Please make sure to use the correct form(s) based
on:
1. NECA member or non-NECA member
2. Which agreement you worked under; Inside,
Residential, VDV or Sign
The
following steps should give you a completed report:
- Enter the SS #, name, and class for each employee.
- Enter 1 1/2, Double, & Straight time hours only—Total Hours will automatically be calculated from this. Do not manually type in the Total Hours column or you will lose the formula.
- Enter gross earnings.
- The rest of this form will be calculated for you.
NOTE: The formulas for each line are based on the journeyman or wireman rates; when entering apprentices or trainees, you’ll have to adjust the formula for that line to match any difference in rates (i.e. savings, dues, PAC).
If you need a continuation page press the tab at the bottom of the screen that says “Sheet 2”. Press the tab that says “Sheet 3” if you need a second continuation page. Simply fill out the same information that you do on the first page and the rest will be calculated for you, including bringing the totals of any continuation sheet(s) to the first page.
The report prints on letter
size paper. If you use a continuation page you will have to print each sheet individually by pressing the tab for each sheet and hitting print. Either copy or print off the number of copies needed. Sign and mail correct number of copies to appropriate parties.
PLEASE DON'T SHADE AREAS OF THE REPORT OR CHANGE
THE FONT COLOR. These reports are copied and
scanned by the various funds; dark shading and
certain colors don't show up well.
Please read the following Do’s and Don’ts List for some user suggestions and special instructions regarding inserting new employees or deleting prior employees.
Important Do's and Don'ts
DO save one copy of the form with just the SS #’s and names of your employees to work from each month. Then after filling in the monthly figures save that copy under a different name (Ex: 6/08 MPR) so that you will keep the copy with just your employees’ names and SS #’s to use again the next month.
DO NOT make manual entries in the “Total Hours” column, ”Total this page” and “Grand total all pages” lines, or in the areas for Lines 1-12 or you will wipe out the formulas for calculating.
To ADD or REMOVE EMPLOYEES—DO NOT use the following features or you will mess up the calculating formulas:
- Do not cut and paste any lines; you can use the copy and paste feature if needed.
- Do not insert or delete lines.
- Do not use sort to put in alphabetical order.
To INSERT A NEW EMPLOYEE in alphabetical order you should use the copy and paste feature to move as many lines as necessary down to make a line available for the new employee. You can either delete the SS # & name from the line you made available, which is now duplicated below it, or you may just begin typing the new SS # and name over the top.
To REMOVE AN EMPLOYEE from your form, DO NOT delete the whole line, just delete the name and SS # or type over the top of the person you want to remove.
Hope this makes things easier for you. If you have any questions, give us a call at (815) 729-2288 so that we can try to walk you through the procedure.
Choose Open.
You may then make edits as you see fit and save them to the downloaded document when finished.
When the file you choose has been selected from the menu and if the following prompt should appear, Please click save.
