# How To Guides - All Employees This book contains all how to processes for use by all employees # How to Access Office Buildings and Arm/Disarm Alarm System ##### Purpose: To explain how to get into office building locations and how to arm/disarm the alarm system ##### Prerequisite: - Have access code entered into security system for all locations that will be accessed by employee ##### Who's Responsible: - All active employees trying to access office locations ##### Overview: - All office locations entrance doors are locked 24/7 - Alarm system automatically disarms at 6:00 AM, Monday - Friday - Alarm system automatically sets at 11:00 PM every day - Alarms do not disarm automatically on weekends or holidays ##### Process: - Enter last 4 digits of social security number and last two digits of birth year into the key pad located a the entrance of the location you are trying to enter - If you are the first person entering the building before 6:00 AM Monday - Friday or anytime on the weekends or holidays, go to the security keypad located inside the door, type in last four digits of social security number and then the number 1. This disarms the security alarm system - If you are the last person leaving the building, go to the security keypad located inside door, type in last four digits of social security number and then the number 2. This arms the security alarm system. **NOTE:** Make sure to check the building to verify that you are the last one in the building. You can use the intercom system in the Mt. Pleasant office to state you are leaving and alarming the system. Wait to see if anyone replies that they are still in the building ##### Troubleshooting: - Submit a ticket to IT # How to Connect to Hotspot or Wi-Fi ##### Purpose: To give directions on how to link to a hotspot or Wi-Fi with remote computer ##### Prerequisite: - Remote desktop - Access to hotspot or Wi-Fi ##### Who's Responsible: - All employees working remotely ##### Process: - **How to connect to a Hotspot** - Sign into computer - Click on Manage notifications icon in the lower right corner of computer desktop [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/mztcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/mztcapture.PNG) - - Make sure hotspot is on and active - Click Mobile hotspot button [![Screenshot (7).png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/screenshot-7.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/screenshot-7.png) - - Button will go blue and hotspot will be listed [![Screenshot (8).png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/screenshot-8.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/screenshot-8.png) - **How to connect to internet/Wi-Fi** - Sign into computer - Click on Manage notifications icon in the lower right corner of computer desktop [![image.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/image.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/image.png) - - Click Network button [![Screenshot (7).png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/jUoscreenshot-7.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/jUoscreenshot-7.png) - - Click the internet/Wi-Fi connection you want to link to [![Screenshot (9).png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/screenshot-9.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/screenshot-9.png) - - Click Connect button [![Screenshot (10).png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/screenshot-10.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/screenshot-10.png) - - System will display when you are connected ##### Troubleshooting: - Submit a ticket to IT # How to Submit Daily Job Logs ##### Purpose: To give instruction on how to create, track and maintain daily job log documents for proper reporting purposes ##### Prerequisite: - Have access to [Our Current](https://jranck.sharepoint.com/sites/Our-Current) web site ##### Who's Responsible: - All foremen, project managers and project management assistants with responsibility for creation, maintenance and review of site daily job logs ##### Process: - **How to create a daily job log (from scratch)** - Go to [Our Current](https://jranck.sharepoint.com/sites/Our-Current) web site - Click on Operations/Projects button [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/rNVcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/rNVcapture.PNG) - - Click on Daily Job Log button [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/0bPcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/0bPcapture.PNG) - - Click on Create Job Log button [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/Edbcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/Edbcapture.PNG) - - Select job number from the Job Number dropdown list **NOTE:** the list will show all active and inactive jobs. You can start typing a job number or job name and the list will auto populate with options to choose - Enter date for current daily job log - Click the Create button [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/pqFcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/pqFcapture.PNG) - - Type in job location - Attach any documents and pictures **NOTE:** At least 4 pictures are required to submit a daily job log per day - Click Choose Files, select files wanted to load - If there is a specific reason pictures cannot be sent, check the box to acknowledge that pictures were not attached [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/x7Bcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/x7Bcapture.PNG) - - Enter manpower breakdown - Only active employees are in the dropdown lists. Start typing in name and selection will filter down. This will also keep a count of manpower entered - Click on Employee and either scroll down to find employee or start to type in their name to filter the list down - Enter equipment that is on site - Only active equipment will be listed in the dropdown list - Click on Unit Number and either scroll down to find equipment or start to type in unit number or equipment name to filter the list down - Continue to click on all equipment from list that is on job site - If more equipment is needed to list that is not in the dropdown list (i.e. rental equipment), click the check box for Add more equipment? - Enter rental equipment information in the Equipment - other text box - If applicable, in the Visitor section, enter Subcontractors, Inspectors, and/or Other visitors text boxes - Enter weather information in Weather section **NOTE:** If the zip code for the job site is entered, the temperature, precipitation, and rain/snow boxes will automatically fill in. You may override what pulls in - If there is a weather delay, click on the weather delay check box and enter explanation [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/ScLcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/ScLcapture.PNG) - - If there was an accident and the accident form was filled out, click the check box for Accident form? and enter explanation - In Contractual Items section, check any boxes that are applicable and input explanations [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/gIfcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/gIfcapture.PNG) - - Enter summary of daily work in the Daily Work Summary **NOTE:** There is a talk to text option for this box. Click on the microphone in the upper left corner of the text box and talk to test is on. Make sure to reread what was recorded for accuracy - To print the form click the Print button - To Save changes and complete later, click Save Changes - To Submit the request to route to PM and PMA, click Submit [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/3micapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/3micapture.PNG) - **How to create a daily job log (using copy option)** - Go to [Our Current](https://jranck.sharepoint.com/sites/Our-Current) web site - Click on Operations/Projects button [![image.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/UiTimage.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/UiTimage.png) - - Click on Daily Job Log button [![image.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/O1dimage.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/O1dimage.png) - - Click on Create Job Log button [![image.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/bSiimage.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/bSiimage.png) - - Select job number from the Job Number dropdown list **NOTE:** the list will show all active and inactive jobs. Yu can start typing a job number or job name and the list will auto populate with options to choose - Enter date for current daily job log - Click the Create button [![image.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/pprimage.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/pprimage.png) - - Click Copy From Previous DJL button [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/Sqgcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/Sqgcapture.PNG) - - Click Copy button on DJL you want to copy from - Manpower and Equipment list are the only fields that will be pulled from the copy option. All other fields need to be filled in before Submitting [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/u9ccapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/u9ccapture.PNG) - - Once all fields are filled in and at least 4 pictures attached, click Submit to route to PM and PMA for review [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/9OIcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/9OIcapture.PNG) - **To view, edit, or print/download a daily job log that you created** - Go to [Our Current](https://jranck.sharepoint.com/sites/Our-Current) web site - Click on Operations/Projects button [![image.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/UiTimage.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/UiTimage.png) - - Click on Daily Job Log button [![image.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/O1dimage.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/O1dimage.png) - - Click on My Job Logs button [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/nTCcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/nTCcapture.PNG) - - A list of the last 100 job logs that you have submitted will display, ordered by most recent date [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/oaccapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/oaccapture.PNG) - - In the attachment column it displays who many attachments (documents, pictures) are included in that daily job log - You can either "View" any of your previous 100 daily job logs or "Edit" daily job logs that have been not submitted yet - To edit, click the Edit button - The edit page will be identical to the page description above used in the daily job log "Create" process after a job number has been selected - You will be able to update all the same fields available to you on the initial create page including the ability to add or remove employees, equipment, and/or attachments - You can then save or submit the updated daily job log - To view, click the View button - You will be able to view the daily job log from here and also download or print a PDF copy of the daily job log [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/8XEcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/8XEcapture.PNG) - **How to search for and select a completed daily job log form for a job** - Go to [Our Current](https://jranck.sharepoint.com/sites/Our-Current) web site - Click on Operations/Projects button [![image.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/UiTimage.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/UiTimage.png) - - Click on Daily Job Log button [![image.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/O1dimage.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/O1dimage.png) - - Click on Search Job Logs button [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/lHUcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/lHUcapture.PNG) - - You will be presented with a screen with a default selection list and filter options for a job number or year and an (optional) email or portion of an email name. Filters can be applied via the "Filter" button or clicking Enter - Each completed review presented can be viewed by selecting the "View" button [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/Zmjcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/Zmjcapture.PNG) - - The "View" page allows you to review the daily job log and you can either download a copy or print [![image.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/GYbimage.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/GYbimage.png) - - With appropriate security (PM or PMA), the "Edit" button allows you to make additions to comments or add/remove clarifications from the selected daily job log. - With appropriate security (PM or PMA), the "Delete" button allows you to remove a daily job log [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/XjScapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/XjScapture.PNG) ##### Troubleshooting: - For technical issues submit a ticket to IT - For process questions send email to Justin Thielen or Stacie Geiger # How to Submit Requests to IT Help Desk ##### Purpose: To show the ways requests can be sent to the IT help desk for assistance with technical questions or help fixing an issue. ##### Prerequisite: - Access to email or phone ##### Who's Responsible: - All employees ##### Process: - **Via Email** - Send email to **** with questions/issues. - A ticket will be created for the IT department. - All IT team members will be able to see all requests submitted - Include as much information as possible on the issue - Attach screen shots of issue if possible/applicable - Email follow ups will be sent via the ticket process to the requestor and anyone else CC'd on the ticket - **Via Phone** - External phone call **(989) 775-1010** - Internal phone call extension **2120** - Someone in the IT department will answer the phone. If no one answers, leave a message and a ticket will automatically be created and all IT members will be able to see it and listen to the voice mail - **Via Drop-in** - Stop by any of the IT teams offices. If someone's door is closed that means they are either working on something critical or are in a meeting. Pick another IT team member to go to - If IT can address a quick question, they will do so - If not, they may ask that a ticket be submitted so the information is gathered, and the request is not lost or forgotten about. This also allows tracking of the question/issue to identify if others are having the same question/issue # How to Submit Safety Trainings ##### Purpose: Provide employees the basic steps to use and complete submission of required safety trainings ##### Prerequisite: - JRE account and password ##### Who's Responsible: - All employees ##### Process: - How to View Safety Trainings - Navigate to [Safety Trainings](https://safety.jranck.com/SafetyTalks) app on Our Current, located on the Safety page - Click on View Safety Trainings button [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/IyHcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/IyHcapture.PNG) - - Safety trainings that need to be completed are listed under All Safety Trainings **NOTE:** The topic column will indicate Field, Warehouse, or Office. You only need to complete the trainings for your area (i.e. office employees only need to complete trainings identified with Office in the topic name) - The trainings that have been completed will indicate that the training has been "Submitted" in the Submitted column - You can complete, review or amend a training by selecting the "View" button [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/9ptcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/9ptcapture.PNG) - How to Complete a Safety Training - Navigate to the safety training you wish to complete, view or amend by clicking on the "View" button [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/Oa2capture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/Oa2capture.PNG) - - At the top of the page, click the topic title link or the Attachment link to view the associated training [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/VQucapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/VQucapture.PNG) - - Cover the information in the training document - Once done, close the training document [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/z7fcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/z7fcapture.PNG) - - Select job number, PREFAB, SAFETY, OFFICE, PREFAB WAREHOUSE, or WAREHOUSE from the Job Number selection list - LEAD BY and Date Completed will be filled out automatically - For office and warehouse employees, check the box indicating that "I am not an active foreman for this week" - Sign your name in the signature box - For any crew members that were a part of the safety training, select their names from the "Employee" selection box. You can enter a partial name or title to filter the selection **NOTE:** You can optionally upload a scan of a sign-in sheet - Check the box to certify that everyone listed was in attendance - Click "Submit" button [![Capture.PNG](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/K5wcapture.PNG)](https://docs.jranck.com/uploads/images/gallery/2025-08/K5wcapture.PNG) ##### Troubleshooting: - For technical issues submit a ticket to IT - For process questions send email to # How to Submit Cyber Security Trainings ##### Purpose: Provide employees the basic steps to use and complete submission of required cyber security trainings ##### Prerequisite: - JRE account and password ##### Who's Responsible: - All employees ##### Process: - How to View Cyber Security Trainings - Navigate to Cyber Security Trainings app on Our Current, located on the Safety page - Click on View Cyber Security Trainings button [![image.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/image.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/image.png) - - Cyber Security trainings that need to be completed are listed under View Cyber Security Trainings - The trainings that have been completed will indicate that the training has been "Submitted" in the Submitted column - You can complete, review or amend a training by selecting the "View" button [![image.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/tI0image.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/tI0image.png) - How to Complete a Cyber Security Training - Navigate to the training you wish to complete, view or amend by clicking on the "View" button [![image.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/BSfimage.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/BSfimage.png) - - At the top of the page, click the topic title link or the Attachment link to view the associated training [![image.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/NRRimage.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/NRRimage.png) - - Cover the information in the training document - Once done, close the training document [![image.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/3tZimage.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/3tZimage.png) - - Sign your name in the signature box - Click "Submit" button [![image.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/9W1image.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/9W1image.png) ##### Troubleshooting: - For technical issues submit a ticket to IT - For process questions send email to # How to View Paystubs - Field Users ##### Purpose: Show field users how to login the first time and view JRE paystubs ##### Prerequisite: - Valid jranck email and initial password ##### Who's Responsible: - Field employees ##### Process: - Go to [J Ranck web site home page](https://www.jranck.com/) - Click the upper Right Menu option [![1.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/1Ag1.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/1Ag1.png) - Scroll down and click Employee Portal [![2.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/2.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/2.png) - Input jranck email address [![3.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/3.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/3.png) - Change password [![4.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/4.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/4.png) - Receive success message - Go to [J Ranck web site home page](https://www.jranck.com/) - Click on Employee Portal - Click Next [![5.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/5.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/5.png) - Click Use different method [![6.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/6.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/6.png) - Click Phone option [![7.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/7.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/7.png) - Enter cell phone number [![8.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/8.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/8.png) - Click Get code text - Enter code received from phone text - Click Next [![9.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/9.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/9.png) - Click Close button [![10.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/10.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/10.png) - Go to [J Ranck web site home page](https://www.jranck.com/) - Click on Employee Portal - Click Employment/Human Resources button on Our Current home page [![11.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/11.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/11.png) - Click on Paystub View button [![12.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/12.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/12.png) - Enter employee jranck email address - Click Next [![13.png](https://docs.jranck.com/uploads/images/gallery/2025-08/scaled-1680-/13.png)](https://docs.jranck.com/uploads/images/gallery/2025-08/13.png) ##### Troubleshooting: - Submit a ticket to IT # How to Generate Accountability Site Access Report ##### Purpose: To explain how to generate an accountability site access report ##### Prerequisite: - Have OBDC configuration set up on electronic device (laptop/tablet) to allow query refresh to pull active employee list from Spectrum - Have admin access set up to receive emails with excel attachment from Virtual Keypad - Have edit access to Share Drive>All Users>MTP>Safety>ACCOUNTABILITY-SITE ACCESS folder
- If any of the above items are needed, contact IT ##### Who's Responsible: - Safety department ##### Overview: - All employees must use their badge to access office locations and job sites that are large enough to have keypad set ups for accountability in case of safety issues. - Employees should not piggy back to get into buildings - If badges are lost/misplaced/forgotten, employee can enter their assigned pin code to gain access. This will allow the system to log them as checking into the site - This report will show who has checked into a site, what site, and their phone numbers. It will also show anyone that is an active employee, that has not checked into a site ##### Process: - Email is received from Virtual Keypad at 8:03 am every morning - Open the Site Access.xlsx excel spreadsheet [![Screenshot 2026-03-30 122157.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-122157.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-122157.png) - Click on the Enable Editing button at the top - Delete columns D (Message), E (User No.), G (Area Name), H (Zone No.), I (Zone Name), J (Door Name), K (Output Name), and L (Count) - To do this left click on the column letter to choose the whole column, then right click to open options and scroll down to Delete option and click it. This removes that column from the spreadsheet. [![Screenshot 2026-03-30 121600.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-121600.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-121600.png) - Click on the headers in column 1 to select them all - Click on the Data tab at the top of the page - Click on the Filter icon to put filters across the headers [![Screenshot 2026-03-30 123004.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-123004.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-123004.png) - Left click on column D to select the entire column - Click on Remove Duplicates option in the tool bar [![Screenshot 2026-03-30 123714.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-123714.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-123714.png) - Leave Expand the selection option chosen - Click Remove Duplicates button [![Screenshot 2026-03-30 124124.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-124124.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-124124.png) - Click Unselect All button [![Screenshot 2026-03-30 124342.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-124342.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-124342.png) - Click User Name to check the box - Click Ok [![Screenshot 2026-03-30 124555.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-124555.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-124555.png) - A message box will pop up with how many duplicates are being removed. Click Ok [![Screenshot 2026-03-30 124727.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-124727.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-124727.png) - With column D still chosen, click sort AtoZ option in tool bar [![Screenshot 2026-03-30 125028.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-125028.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-125028.png) - Leave Expand the selection option chosen - Click Sort button [![Screenshot 2026-03-30 125358.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-125358.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-125358.png) - Right click on column D to select it - Click on Cut option - Right click on column C - Click on Insert Cut Cells option - This moves the User Name column to be before the System column [![Screenshot 2026-03-30 130151.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-130151.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-130151.png) - Open the Site Access Template.xlsx from the Share Drive All Users>MTP>Safety>ACCOUNTABILITY-SITE ACCESS [![Screenshot 2026-03-30 130852.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-130852.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-130852.png) - Click on the Editing button in the upper right corner [![Screenshot 2026-03-30 131151.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-131151.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-131151.png) - Click on Open in Desktop option [![Screenshot 2026-03-30 131255.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-131255.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-131255.png) - Click Open Excel button [![Screenshot 2026-03-30 131350.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-131350.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-131350.png) - Click on Enable Content button [![Screenshot 2026-03-30 131531.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-131531.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-131531.png) - If prompted with a Security Warning, click on Yes option for Trusted Document [![Screenshot 2026-03-30 131649.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-131649.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-131649.png) - Go back to the first spreadsheet that was cleansed and highlight columns A - D - Right click and select Copy option [![Screenshot 2026-03-30 131955.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-131955.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-131955.png) - Move back to the template and make sure the OnSite tab is displaying - Click on A1 cell to select it [![Screenshot 2026-03-30 132448.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-132448.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-132448.png) - Right click and select Paste Special option - Leave All the selection option - Click Ok button [![Screenshot 2026-03-30 132556.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-132556.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-132556.png) - Click on the Active Employee List tab in the template - Click on the Refresh All option in the tool bar. This brings in the most current active employee list from Spectrum [![Screenshot 2026-03-30 134415.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-134415.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-134415.png) - The report will show all employees names and location of who checked in using the keypads. Those that did not use the keypad will show N/A - This information can then be filter for employee names or by N/A to see who did not check in. It can also be filtered by location to see who checked in at each site **NOTE:** the employee name needs to be entered in the virtual keypad software the same way it is entered into Spectrum. If it is not the same the lookup will not work correctly in the spreadsheet. - Once the template has been updated it can be closed and a prompt will ask to close the file on Share Drive. Make sure to click Resume editing here option to allow the most current employee report to be save in Share Drive until the next update the next day. [![Screenshot 2026-03-30 135459.png](https://docs.jranck.com/uploads/images/gallery/2026-03/scaled-1680-/screenshot-2026-03-30-135459.png)](https://docs.jranck.com/uploads/images/gallery/2026-03/screenshot-2026-03-30-135459.png) ##### Troubleshooting: - Submit a ticket to IT # Using Shared Printers ## First Time Setup ### Computer Setup

YOU ONLY HAVE TO DO THIS ONCE

1. Open the `Kyocera Cloud Print and Scan` Application - You can find it on your desktop or by searching for `Kyocera Cloud Print and Scan` [![image-1.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/image-1.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/image-1.png) [![image-2.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/image-2.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/image-2.png) 2. A window will open asking you to login if you are not already signed in 3. Click `Sign in with Microsoft` [![image-3.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/image-3.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/image-3.png) 4. Your browser will open to the usual Microsoft/JRE sign-in page [![image-6.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/image-6.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/image-6.png) 5. Sign in to your account and then return to the app 6. You should now see a window similar to this [![image-7.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/image-7.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/image-7.png) ### Printer Setup

YOU ONLY HAVE TO DO THIS ONCE. YOU CAN PERFORM THESE STEPS AT ANY PRINTER WITH A BADGE READER. THIS WILL CONFIGURE YOUR BADGE FOR ALL PRINTERS.

1. Locate the email from `noreply.cps@kyocera.biz` containing your PIN and write it down for a later step [![Screenshot 2026-04-01 121402.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/screenshot-2026-04-01-121402.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/screenshot-2026-04-01-121402.png) 2. Scan your badge on the badge reader 3. The printer will display `The ID card is not registered. Register your ID card?` [![IMG_1451-1.jpeg](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/img-1451-1.jpeg)](https://docs.jranck.com/uploads/images/gallery/2026-04/img-1451-1.jpeg) 4. Tap `Yes` 5. Enter your PIN from the email and then tap Enter 6. You will get a notification that the card has been registered. This allows you to use your badge on any printers that have a badge reader [![IMG_1452-1.jpeg](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/img-1452-1.jpeg)](https://docs.jranck.com/uploads/images/gallery/2026-04/img-1452-1.jpeg) 7. You can now scan your badge to access the Kyocera Cloud Print and Scan application on any printer that has a badge reader ## Printing 1. Select the printer named `Kyocera Cloud Print and Scan` and then click Print [![image-4.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/image-4.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/image-4.png) 2. You can now go to any one of the shared printers 3. Scan your badge 4. Tap on `Kyocera Cloud Print and Scan` [![Screenshot 2026-04-01 125220.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/screenshot-2026-04-01-125220.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/screenshot-2026-04-01-125220.png) [![Screenshot 2026-04-01 125232-print.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/screenshot-2026-04-01-125232-print.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/screenshot-2026-04-01-125232-print.png) 5. Tap on your document(s) and then tap the printer icon [![Screenshot 2026-04-01 125258.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/screenshot-2026-04-01-125258.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/screenshot-2026-04-01-125258.png) 6. Change any print settings you desire 7. Tap Print [![Screenshot 2026-04-01 125310.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/screenshot-2026-04-01-125310.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/screenshot-2026-04-01-125310.png) ## Scanning to Email 1. Scan your badge 2. Tap on `Kyocera Cloud Print and Scan` [![Screenshot 2026-04-01 125220.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/screenshot-2026-04-01-125220.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/screenshot-2026-04-01-125220.png) 3. Tap `Scan to me` [![Screenshot 2026-04-01 125232-scan.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/screenshot-2026-04-01-125232-scan.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/screenshot-2026-04-01-125232-scan.png) 4. Select your desired scan settings 5. Tap `Scan` [![Screenshot 2026-04-01 125341.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/screenshot-2026-04-01-125341.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/screenshot-2026-04-01-125341.png) 6. You will receive an email from `noreply.cps@kyocera.biz` with the document attached - If the file is larger than 10MB, the email will not include the attachment and will instead contain a link to the document [![image-9.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/image-9.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/image-9.png) ## How to Find/Reset Your PIN 1. Go to the [Kyocera Web Portal](https://j-ranck.cps-us.kyocera.biz) or right click on the Kyocera app in your system tray and click `Go to home page` [![Screenshot 2026-04-02 072927.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/DMescreenshot-2026-04-02-072927.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/DMescreenshot-2026-04-02-072927.png) 2. Log in with your Microsoft/JRE account 3. In the top right corner of the page, click on your email address 4. Click `User profile` [![Screenshot 2026-04-02 073120.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/screenshot-2026-04-02-073120.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/screenshot-2026-04-02-073120.png) 5. Click the `Credential` menu item 6. Your PIN is displayed below and also gives you the option to generate a new PIN [![Screenshot 2026-04-02 073241.png](https://docs.jranck.com/uploads/images/gallery/2026-04/scaled-1680-/screenshot-2026-04-02-073241.png)](https://docs.jranck.com/uploads/images/gallery/2026-04/screenshot-2026-04-02-073241.png) # How to Enroll to Receive Your Payroll Statement by Email ##### Purpose**:** Provide J. Ranck Electric, Inc, employees the basic steps to sign up to have their pay statement sent to their personal email address. ##### Prerequisite: - Current JRE employee ##### Who's Responsible: - All employees ##### Process: - Go to the J. Ranck Employee Dashboard - Access the page by using this QR code: - [![image.png](https://docs.jranck.com/uploads/images/gallery/2026-06/scaled-1680-/image.png)](https://docs.jranck.com/uploads/images/gallery/2026-06/image.png) - Or type the URL link in your browser: [https://apps.jranck.com](https://apps.jranck.com). - On the main page after you log in, select your image on the top right of the screen. - Select My Account for the drop-down list: [![image.png](https://docs.jranck.com/uploads/images/gallery/2026-06/scaled-1680-/N9Wimage.png)](https://docs.jranck.com/uploads/images/gallery/2026-06/N9Wimage.png) - You will be directed to a page where you can enter your signup information. - This will take you to a form and information page. In the Settings section, check the box labeled “Email me my paystubs”. You can then enter a valid email address in the Email box. Then click on the Save Changes button. - **IMPORTANT!** By entering a personal email address, you are assured that any final pay statements are received as any jranck.com email addresses are invalid once an employee leaves J. Ranck Electric, Inc. [![image.png](https://docs.jranck.com/uploads/images/gallery/2026-06/scaled-1680-/a6Ximage.png)](https://docs.jranck.com/uploads/images/gallery/2026-06/a6Ximage.png) - You may also contact the IT Department. Their staff can also sign you up. Troubleshooting: - For technical issues submit a ticket to IT