app.smartsheet.com Open in urlscan Pro
44.195.142.5  Public Scan

URL: https://app.smartsheet.com/b/publish?EQBCT=9ee290661ae34b58851e704ad5db841e
Submission: On August 24 via api from US — Scanned from DE

Form analysis 0 forms found in the DOM

Text Content

ROSS Stores Summary Dashboard (View Only)


Report Abuse
Help
An error has occurred in Smartsheet
Please log out and log back into the app before continuing. If the problem
continues,
please request assistance at www.smartsheet.com/gethelp.
 * Home
 * Search
 * Recently Opened
 * Favorites
 * Solution Center
 * Help

Grid View
Filter


Arial
10

toolbar/align left



toolbar/conditional formatting
highlight changes





Press Enter to inspect this widget.

Press Enter to inspect this widget.

ROSS Stores Summary Dashboard


Ross Status of Scope, Schedule & Budget
 * Project Domain
   Scope, Schedule & Budget.
 * Scope
   
 * Schedule
   
 * Budget
   

Press Enter to inspect this widget. Press Space to open the data source in the
same tab.
Site T-Minus Details - Click to Open
Ross Stores Site T-Minus
Press Enter to inspect this widget.
Click to Open
Ross Stores Contacts
Press Enter to inspect this widget.
Click to Open
Ross Stores Team Vacation Planner
Press Enter to inspect this widget.
Ross Site Count Report

Project NameProject StatusStatus Notes

Total

Count
27

Project Status
Complete

Count
4


Baltimore Crossdocks

Complete- Approved by Jim via email on 6/12


SEDC H2

Complete- Deliverable document submitted 7/26
- Close out meeting 8/17


SEDC H6

Complete- Deliverable document submitted 7/17
- Closeout meeting 8/17


CVDC Predictive Design

Complete- Closeout meeting held on 7/12
- Deliver updated predictive - 7/25
(Updates to Naming/Numbering updates)

Project Status
In Progress

Count
6


Sacramento Crossdocks

In Progress- Deliverable document submitted 7/30
- Closeout meeting - Target 8/24


SEDC Aruba Deployment

In Progress- Clearpass upgraded, ctrls installed and connected to network;
Outdoor APs staged (29); and 65 Indoor APs patched & names assigned.
- Next Steps: Add to domain, FW Rules, Add to Cluster and AP Provisioning


SEDC Carpeted Space

In Progress- Ross to validate Prod Internet Access - 8/22


Corp Campus Wi Fi Refresh

In Progress- Project is AMBER
- Insight Wireless & Clearpass configs complete.
- Limited testing performed with 1 AP
DEV Next steps:
1. Ross - Controller move - Date is 8/23
2. Ross - Vlan trunking and DHCP Helpers
3. Ross - License Keys for Wireless and Clearpass (DEV & PROD
4. Insight/Ross - Testing (Mobile, TACACS, etc.)
5. Insight Documentation DEV LLD and Prod HLD


Retail Wireless Pilot Move to Managed Services

In Progress- Contact: Brian Millington, PM
- Status meeting: Friday's 10:00 AM PT
https://teams.microsoft.com/l/meetup-join/19%3ameeting_YWQ0ZDY1ZmItNDBiYS00MDE2LWE0MTYtZGQ5ODk5NTQ4MjZk%40thread.v2/0?context=%7b%22Tid%22%3a%226c637512-c417-4e78-9d62-b61258e4b619%22%2c%22Oid%22%3a%22ae6f6eab-9d7b-4128-a11a-2d841063db12%22%7d


MVDC Wireless Survey

In Progress- Project K/O held on 8/16
- Site survey performed on 8/19 - 8/20
Next Steps
1. Ross - Supply AGV design specs and parameters
2. Wireless verification document - eta 8/31

Project Status
Not Started

Count
14


CVDC Deployment

Not Started- SOW submitted to Ross on 7/27
- Insight update in progress as of 7/31


SEH3 New WLAN for Android

Not Started- Pending Ross Review & Approval


Supply Chain ClearPass Captive Portal

Not Started- Pending Ross Review & Approval


ClearPass Migration (SC)

Not Started- Pending Ross Review & Approval


Predictive surveys San Antonio/El Paso

Not Started- Pending Ross Review & Approval


Airwave / Airglass Upgrade

Not Started- Pending Ross Review & Approval


BBO Network Refresh

Not Started- PSE Pending Ross Review & Approval


Columbus Predictive survey

Not Started- Pending Ross Review & Approval


DC8 (AZDC) Deployment 2023 Phase 1

Not Started- Pending Ross Review & Approval


DC8 (AZDC) Deployment 2023 Phase 2

Not Started- Pending Ross Review & Approval


SERVICES - Retail Refresh Pilot 6_23

Not Started- Pending Ross Review & Approval


SERVICES - Retail Refresh Pilot 7_23

Not Started- SOW submitted to Ross on 7/28


Tampa Crossdocks: Vulnerability Remediation

Not Started- SOW Rewrite In Progress


Dublin Managed Services

Not Started- Pending Ross Review & Approval

Project Status
On Hold

Count
3


HTDC

On Hold- Delayed due to electrical issues.
- Per Jim, the new target resolution is TBD


Atlanta Crossdocks

On Hold- AP Install by Ross - Target eta August


Portland Crossdocks

On Hold- AP Install by Ross - Target eta August
- Open Items: Switch reconfigs and IP Addresses

Open source report to view more
Press Enter to inspect this widget. Press Space to open the data source in the
same tab.
Ross Project Status Pie Chart Report

Press Enter to inspect this widget. Press Space to open the data source in the
same tab.
Ross Stores Detailed Active Task Status Report

Site NameResources /Site PriorityProject StatusStatus Notes


HTDC

- Delayed due to electrical issues.
- Per Jim, the new target resolution is TBD


AP Provisioning

Insight


HTDC Verification Survey

Steven Saylor


Deliverable Documentation

Insight


Sacramento Crossdocks

- Deliverable document submitted 7/30
- Closeout meeting - Target 8/24


Atlanta Crossdocks

- AP Install by Ross - Target eta August


Install new APs (8)

RossPer jim, target is eom July/early August


Atlanta Wireless Verification

Insight


Project Deliverables (As built, iGRC) documentation

Insight


Insight Delivered MS CR (if variance from predictive)

Insight


Client Approves LLD Design

Ross


Request to remove Extreme from Insight management

Ross


Project Close

Insight


Portland Crossdocks

- AP Install by Ross - Target eta August
- Open Items: Switch reconfigs and IP Addresses


Install new APs (5)

Ross


Portland Perform Wireless Verification

Insight


Final Docs and Review

Insight


Implement Licensing/Hardware/COs

Ross


Implementation

Insight


Insight Operational Validation

Insight/Ross


Ross Testing

Ross


Insight Managed Services Moved to Production (billing and support commence)

Insight/RossSwitches & Gateways added.
*APs pending host names


Ross iGRC Approval

Ross


Client Approves LLD Design

Ross


Request to remove Extreme from Insight management

Ross


Project Close

Insight


SEDC Aruba Deployment

- Clearpass upgraded, ctrls installed and connected to network; Outdoor APs
staged (29); and 65 Indoor APs patched & names assigned.
- Next Steps: Add to domain, FW Rules, Add to Cluster and AP Provisioning


Ross Dependencies
Hardware Delivery
Network Access thru FWs
Network Delivery
Licenses
COs for FW, IPs, DHCP, etc.
Ross Designs
Cabling and AP Install
Devices specified and Tested.

RossIn Progress, eta 8/1


Planning and Design

Ross/Insight


HLD Design to Ross

Ross/Insight


Ross iGRC Approval

Ross


Client Approves HLD

Ross


Insight Delivered MS CR (if variance from predictive)



Implementation

Ross


Insight Operational Validation

Insigh


Insight Managed Services Moved to Production (billing and support commence)

Insight/RossProjected timeframe to begin monitoring is mid/eom August


Post RF Survey Delivery

Insight


RF Survey Final Approval

Ross


Post Implementation Changes

Ross


Delivery LLD

Insight


Ross iGRC Approval

Ross


Client Approves LLD Design

Ross


Project Close

Insight/Ross


SEDC Carpeted Space

- Ross to validate Prod Internet Access - 8/22


Production Validation

RossPer Frank, DHCP and FW changes will be implemented the weekend of 8/21


Project Close

Insight


Corp Campus Wi Fi Refresh

- Project is AMBER
- Insight Wireless & Clearpass configs complete.
- Limited testing performed with 1 AP
DEV Next steps:
1. Ross - Controller move - Date is 8/23
2. Ross - Vlan trunking and DHCP Helpers
3. Ross - License Keys for Wireless and Clearpass (DEV & PROD
4. Insight/Ross - Testing (Mobile, TACACS, etc.)
5. Insight Documentation DEV LLD and Prod HLD


Submit/Implement FW Rules for Access

RossOngoing


Validate Access

InsightOngoing


Review Ross design and requirements document

Insight/RossEngineering kickoff scheduled for 6/14


Dev - Prepare Aruba HLD document

InsightSubmitted on 6/29


Dev - Prepare Clearpass HLD document

InsightDraft submitted on 7/17


Client Approved HLD Documents

Ross7/12 -Kyle approved Wi-Fi Design


Configure Aruba devices in DEV

InsightIn Progress


Configure Clearpass devices in DEV

InsightIssue - Unable to upgrade Dbln Clearpass device.
7/13 - Dave S. to begin publisher configs


Documentation changes

Insight/Ross


Submit CO for prod changes

Ross


Change Order Approval

Ross


Prod - Configure Aruba devices

Insight


Prod - Configure Clearpass devices

Insight


Prod - Wireless LLD

Insight


Prod - Clearpass LLD

Insight


Wireless Verification & Clearpass Testing

Ross


Managed Svcs Onboarding (Insight Delivered MS CR (if variance from predictive)



Ross Signed CR and PO

Ross


Implement Licensing/Hardware/COs

Ross


Implementation

Insight/Ross


Insight Operational Validation

Insight/Ross


Ross Testing

Ross


Insight Managed Services Moved to Production (billing and support commence)

Insight


Post RF Survey Delivery

Insight


RF Survey Final Approval

Ross


Post Implementation Changes

Insight/Ross


Delivery LLD

Insight


Ross iGRC Approval

Ross


Client Approves LLD Design

Ross


Project Close

Insight/Ross


CVDC



CVDC Deployment

- SOW submitted to Ross on 7/27
- Insight update in progress as of 7/31


Ross Signed SOW and PO

Ross


Ross Orders Equipment Based off of Project Deliverable

Ross


Submit Order Placed for BOM, Software, and Licensing

Ross


Scheduled Start Date

Insight


Project Engineers Assigned

Insight


Project Kickoff

Insight/Ross


Obtain VDI/VPN Access for Insight Engineer if needed

Ross


Ross Dependencies Tasks:
Hardware Delivery
Network Access thru FWs
Network Delivery
Licenses
COs for FW, IPs, DHCP, etc.
Ross Designs
Cabling and AP Install
Devices specified and Tested.

Ross


Planning and Design

Insight/Ross


HLD Design to Ross

Insight


Ross iGRC Approval

Ross


Client Approves HLD

Ross


Add To Managed Services CR Scoping (preliminary qty based on predictive)

Insight


CVDC Managed Svcs Onboarding



Ross Signed CR and PO



Implement Licensing/Hardware/COs



Implementation



Insight Operational Validation



Ross Testing



Insight Managed Services Moved to Production (billing and support commence)



Post RF Survey Delivery



RF Survey Final Approval



Post Implementation Changes



Delivery LLD



Ross iGRC Approval



Client Approves LLD Design



Project Close



Retail Wireless Pilot Move to Managed Services

- Contact: Brian Millington, PM
- Status meeting: Friday's 10:00 AM PT
https://teams.microsoft.com/l/meetup-join/19%3ameeting_YWQ0ZDY1ZmItNDBiYS00MDE2LWE0MTYtZGQ5ODk5NTQ4MjZk%40thread.v2/0?context=%7b%22Tid%22%3a%226c637512-c417-4e78-9d62-b61258e4b619%22%2c%22Oid%22%3a%22ae6f6eab-9d7b-4128-a11a-2d841063db12%22%7d


In Progress



SEH3 New WLAN for Android

- Pending Ross Review & Approval


Ross Signed SOW and PO

Ross


Supply Chain ClearPass Captive Portal

- Pending Ross Review & Approval


Ross Signed SOW and PO

Ross


ClearPass Migration (SC)

- Pending Ross Review & Approval


Ross Signed SOW and PO

Ross


MVDC Wireless Survey

- Project K/O held on 8/16
- Site survey performed on 8/19 - 8/20
Next Steps
1. Ross - Supply AGV design specs and parameters
2. Wireless verification document - eta 8/31


Submit Predictive design to Ross

Insight


Client Approves Design

Ross


Predictive SOW Close

Insight/Ross


Predictive surveys San Antonio/El Paso

- Pending Ross Review & Approval


Ross Signed SOW and PO

Ross


Airwave / Airglass Upgrade

- Pending Ross Review & Approval


Ross Signed SOW and PO

Ross


BBO Network Refresh

- PSE Pending Ross Review & Approval


Ross Signed SOW and PO

Ross


Columbus Predictive survey

- Pending Ross Review & Approval


Ross Signed SOW and PO

Ross


DC8 (AZDC) Deployment 2023 Phase 1

- Pending Ross Review & Approval


Ross Signed SOW and PO

Ross


DC8 (AZDC) Deployment 2023 Phase 2

- Pending Ross Review & Approval


Ross Signed SOW and PO

Ross


SERVICES - Retail Refresh Pilot 6_23

- Pending Ross Review & Approval


Ross Signed SOW and PO

Ross


SERVICES - Retail Refresh Pilot 7_23

- SOW submitted to Ross on 7/28


Ross Signed SOW and PO

Ross


Tampa Crossdocks: Vulnerability Remediation

- SOW Rewrite In Progress


Insight Delivered Provided SOW

Insight


Ross Signed SOW and PO

Ross


Dublin Managed Services

- Pending Ross Review & Approval


Ross Signed SOW and PO

Ross

Open source report to view more
Press Enter to inspect this widget. Press Space to open the linked Smartsheet
item in the same tab.
Ross High Level Milestones Report

End DateStatus% CompleteMilestoneCommentsResponsible


03/31/23

Atlanta - Wireless Configuration

Steve

04/14/23

Atlanta - Go Live

Steve

04/21/23

Portland - Wireless Configuration

Steve

04/21/23

Portland - Predictive Complete

Steve

05/04/23

Atlanta - Insight Predictive Design Complete

Steve

05/19/23

Portland Go Live

Jim

05/26/23

Atlanta - Install Replacement Switches

Rescheduled 5/13 install due to missing componentsSteve

05/26/23

Atlanta - Wireless Verification

Confirmed w/ Jim on 5/22Steve

06/04/23

SEDC Carpeted Space Role/Policy Configs

Awaiting Ross verification of FW changes for prod internet accessDivya, Dave

06/27/23

CVDC Predictive Survey

Design Submitted & ApprovedSteve

07/05/23

Atlanta - Predictive Approved

Approved 7/6Jim

07/05/23

Portland - Predictive Approved

Approved 7/6Jim

07/05/23

SEDC H6 - Wireless Configuration

Steve

07/26/23

SEDC H2 - Wireless Configs

Steve

07/31/23

Sacramento Cross docks

Steve

09/08/23

MVDC Wireless Survey


09/30/23

Corp Campus DEV Configuration Complete

Ben, Divya, Steve, Dave

TBD

Portland - Addt'l AP Installs and Switch Restack

Target Resume Date Mid-AugJim, Steve

TBD

Portland - Wireless Verification

Jim, Steve

TBD

Atlanta AP Install (7)

Target Resume Date Mid-AugJim, Steve

TBD

Atlanta Wireless Verification

Jim, Steve

TBD

Corp Campus Prod Configuration Complete

Ben, Divya, Steve, Dave

Open source report to view more
Press Enter to inspect this widget. Press Space to open the linked Smartsheet
item in the same tab.
Ross Accomplishments (Week/Week) Report

Week EndingAccomplishmentsParty Members


07/31/23

Sacramento Wireless Verification delivered to Ross


07/26/23

SEDC H2 Wireless Verification delivered to Ross


07/17/23

SEDC H6 Wireless Verification delivered to Ross


06/26/23

CVDC Predictive delivered to Ross


06/16/23

SEDC Carpeted Space LLD delivered to Ross


06/09/23

CVDC Site Visit completed


06/06/23

H6 Site Visit and Wireless Verification Completed


06/04/23

SEDC Carpeted Space Role & Policy Enforcement Implemented (H6)


05/26/23

Atlanta Replacement Switch Install


05/16/23

SEDC Carpeted Space - Role creation and policy enforcement in DEV


05/05/23

Atlanta predictive completed


04/30/23

HTDC APs provisioned


04/21/23

SEDC Carpeted Space kickoff


04/21/23

Portland Crossdocks gateways installed and configured


04/21/23

Portland Crossdocks Predictive Design



Corp Campus Non-Prod Clearpass & Wireless Configuration



Corp Campus Prod Clearpass & Wireless Configuration



MVDC Site Survey Complete



MVDC RF Survey delivered to Ross

Open source report to view more
Press Enter to inspect this widget. Press Space to open the linked Smartsheet
item in the same tab.

RAID (See below)

Press Enter to inspect this widget.
Ross Open Action Items/Tasks Report

Target Completion DateCategoryResponsibleTask DescriptionStatusCompletion
DateNotesTracking


08/16/23Jim Mattison

Kansas - Acess point KMO-AP006 appears to be off-line due to the fact of either
a bad cable or the cable is connected to the Eth1 port of the AP.

OpenAction Item

08/16/23Jim Mattison

Kansas - Access point KMO-AP11 appears to be DOA after working with Aruba TAC, a
replacement AP was ordered and on-site to be replaced.

OpenAction Item

08/16/23Jim Mattison

Baltimore -There is a need for a power strip to be added to the cabinet of IDF B
so that the redundant switch power supply can be connected to power.

OpenAction Item

08/16/23Jim Mattison

Baltimore - Two fiber patch cables need to be installed in the MDF to the core
switch ports 2/1/26-27 to IDF B & C

OpenAction Item

08/16/23Jim Mattison

Atlanta - The primary Internet circuit needs to be delivered/connected and
provisioned.

OpenTarget date 9/2/2023.Action Item

08/16/23Jim Mattison

Atlanta - Install access points in green need to be installed and provisioned
for both in and outside the facility. Once complete a final on-site verification
of the wireless coverage will need to be performed.

OpenAction Item

08/16/23Jim Mattison

Portland - The primary Internet circuit needs to be delivered/connected and
provisioned.

OpenTarget date 8/19/2023.Action Item

08/16/23Jim Mattison

Portland - Wireless in general for Portland needs to be revisited. Below is the
end-state deployment for both in and outside access points. Once they are
deployed and provisioned a final wireless verification needs to be performed.

OpenTarget Date 10/1/2023.Action Item

08/16/23Jim Mattison

Portland - Switches in IDF B & C need to be stacked, this will be performed
during the wireless verification.

OpenAction Item

08/16/23Jim Mattison

Sacramento - Swap 4 off brand SFPs in MDF 2/26 – 27 and IDF B 2/26, IDFC 2/26
with Aruba approved SFPs

OpenAction Item

08/16/23Jim Mattison

Sacramento -Callouts from the final deliverable need address for the wireless,
see attachments

OpenAction Item

08/24/23Jim Mattison

HTDC status of electrical issue resolution. Required to complete the project

OpenAction Item

Open source report to view more
Press Enter to inspect this widget. Press Space to open the linked Smartsheet
item in the same tab.
Ross Risks/Issues/Dependency Report

Date OfTypeProbabilityImpactStatusCategoryResponsibleDescriptionMitigation
Plan/Status/Comments


07/24/23HighHighActiveScheduleBen Savage Divya Kamath

VLAN conflict: Control plane security, VLAN 1327 not being allowed across the
trunk; SNMP Servers/Logging, spanning tree.

8/22 - Move will be performed on 8/23
8/15 - Ross internal move completion eta is 9/1

Open source report to view more
Press Enter to inspect this widget. Press Space to open the linked Smartsheet
item in the same tab.
Ross Decisions Report

Decision #DateDecision DetailsDecide BySupported ByApproved By (if
needed)Approved Date


3

06/13/23Corp Campus: CR 71918 - Add Guest W-Fi submitted on 6/1TBDSylvia Rhodes


4

06/06/23SEDC: 25 degree tilt. Team discussed and agreed that a tilt will be
implemented08/01/2023Frank B., Steve Saylor06/13/23


1

04/17/23HTDC As Built vs. Mesh design approachTBDJames Mattison, Kyle Ward


2

04/17/23Insight to perform predictives for both Atlanta and
Portland4/17/2021James Mattison04/17/23


5



6



7



8



9



10



11



12



13



14



15



16



17



18



19



20



21



22



23



24



25



26



27



28



29



30



31



32



33



34



35



36



37



38



39



40



41



42



43



44



45



46



47



48



49



50



51



52



53



54



55



56



57



58



59



60



61



62



63



64



65

Open source report to view more
Press Enter to inspect this widget. Press Space to open the linked Smartsheet
item in the same tab.