Skip to main content

How to Generate Accountability Site Access Report

Purpose:

To explain how to getgenerate intoan officeaccountability buildingsite locationsaccess and how to arm/disarm the alarm systemreport

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 codeset enteredup intoto securityreceive systememails forwith allexcel locationsattachment thatfrom willVirtual beKeypad
    • accessed
  • Have byedit employeeaccess to Share Drive>All Users>MTP>Safety>ACCOUNTABILITY-SITE ACCESS folder 
  • If any of the above items are needed, contact IT
Who's Responsible:
  • AllSafety active employees trying to access office locationsdepartment
Overview:
  • All employees must use their badge to access office locations entranceand doorsjob sites that are lockedlarge 24/7enough to have keypad set ups for accountability in case of safety issues.
  • AlarmEmployees 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 automaticallyto disarmslog atthem 6:00as AM,checking Mondayinto -the Fridaysite
  • AlarmThis systemreport automaticallywill setsshow atwho 11:00has PMchecked everyinto day
    • a
  • Alarmssite, dowhat site, and their phone numbers. It will also show anyone that is an active employee, that has not disarmchecked automaticallyinto ona weekends or holidayssite
Process:
  • EnterEmail lastis 4received digitsfrom ofVirtual socialKeypad securityat number8:03 am every morning
  • Open the Site Access.xlsx excel spreadsheet

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 lastL two(Count) digits of
      birth
    • To yeardo intothis left click on the keycolumn padletter locatedto achoose the entrancewhole 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

  • Click on the headers in column 1 to select them all
  • Click on the Data tab at the top of the location you are trying to enterpage
  • If you are the first person entering the building before 6:00 AM Monday - Friday or anytimeClick on the weekendsFilter or holidays, goicon to theput securityfilters keypad located insideacross the door,headers
    • type

Screenshot 2026-03-30 123004.png

  • Left click on column D to select the entire column
  • Click on Remove Duplicates option in lastthe fourtool digitsbar
    • of
social

Screenshot 2026-03-30 123714.png

security
    number
  • Leave and thenExpand the numberselection 1.option This disarms the security alarm systemchosen
  • IfClick youRemove areDuplicates thebutton
    • last
person

Screenshot 2026-03-30 124124.png

leaving
    the
  • Click building,Unselect goAll tobutton
    • the
security

Screenshot 2026-03-30 124342.png

keypad
    located
  • Click insideUser door, type in last four digits of social security number and then the number 2. This arms the security alarm system. NOTE: Make sureName to check the buildingbox
  • Click Ok

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

  • With column D still chosen, click sort AtoZ option in tool bar

Screenshot 2026-03-30 125028.png

  • Leave Expand the selection option chosen
  • Click Sort button

Screenshot 2026-03-30 125358.png

  • Right click on column D to verifyselect thatit
    • you
  • Click areon Cut option
  • Right click on column C 
  • Click on Insert Cut Cells option
  • This moves the lastUser oneName column to be before the System column

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

  • Click on the Editing button in the building.upper Youright cancorner
    • use

Screenshot 2026-03-30 131151.png

  • Click on Open in Desktop option

Screenshot 2026-03-30 131255.png

  • Click Open Excel button

Screenshot 2026-03-30 131350.png

  • Click on Enable Content button

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

  • Go back to the intercomfirst systemspreadsheet that was cleansed and highlight columns A - D 
  • Right click and select Copy option

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

  • Right click and select Paste Special option
  • Leave All the selection option
  • Click Ok button

Screenshot 2026-03-30 132556.png

  • Click on the Active Employee List tab in the Mt.template
    • 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:

Back to top