The Wraplication has been constructed following the ExcelWraps Design Guide. It is intended to provide enough information to independently debug the Wraplication it should grow as more detail is added to each individual wrap. Links to the relevant material should be added as they become available. At the end of the project this page should be a useful hyperlinked map of where all elements of the Wraplication can be found. The convention for wrap specification is:
WrapNames are in bold.
WrapSheet names are in bold italics.
Links to external docs and pages are highlighted blue.
Director: John Doyle
Client Implementer: Leighton Vaughan
Implementer: Thomas Chardon
Tester: Shama Shakya
Description - This Wraplication is a development of the historic ERG inspection process SEE TC FOR PROCESS DETAIL
Prefix and Version control - Each Wrap definition name will have a prefix CL and the class of vehicle, for example CL158 or CL322. Further detail may be added to the prefix for vehicle classes where there are multiple variants, for example CL700-12car and CL700-8car.
Launch Page, Navigation and Menu - The launch page for Redelivery Admin is here.
Aesthetics - All wraps need to satisfy the Aesthetic Checklist:
Set default row height to 30 - finger friendly.
Use Client Excel theme. Primary Branding Colours are Blue (RGB 0,76, 143), Grey (RGB 174, 170, 167) and White.
Colour cells in tables - light shade for input cells and dark shade for fixed text.
Use thick white borders.
A5 layouts for Mobile/desktop friendly.
Many tabs for Mobile/desktop friendly.
Minimise merged cells for Mobile/desktop friendly.
KPI
Cost per vehicle. Cost per fleet/Number of Vehicles [Does the unit in the header need changing to £, instead of £k? (DH, 13/05/2021)]
Cost per fleet. Derived from CLXXX_Redelivery_Cost?ReID=1&Version=Last&filter=TotalCost
Start Date
Inspected
Type. Derived from CLXXX_Redelivery_SetUp?ReID=1&filter.type
Quantity. Derived from CLXXX_Redelivery_SetUp?ReID=1&filter.vehtot
Workgroup Tags - TOC in place for all relevant work groups.
Wrapgroups, Roles and Unique Keys
All wrap definitions have been placed in the Redelivery wrap group.
Each vehicle class has a view role, view-321 for example. Currently each page has been configured to be visible to T-Asset, TOC-Rectify or both. However, the view roles could be used to alter this. This may be easier to manage if we use workgroups rather than roles.
The unique key setups use the following format
CLXXX_RedeliveryWrapMap?Reid=1 and CLXXX_Redilvery_Cost?Reid=1 for use at Admin/Planner level.
CLXXX_Redelivery_Underframe?Reid=1&Unit=322482 for use at Artisan.
Schedule
DashboardLayoutPlan_WeeklyReport?day=9&year=2021&month=5 will run at 11:00 each Sunday.
RedeliveryCost_WeeklyReport?year=2021&month=5&day=9&fleet=mkiv_gc&reid=1 will run at 18:00 each Sunday.
Pdf Strategy
Dev Team Dependencies
Awaiting release of improved touch screen functionality before secondary menus can be hung from main menu.
Custom Widgets - No custom widgets currently used on this wraplication.
Deliverable - Nothing awaiting delivery.
Integration - No new items to be integrated.
Testing - The system should be tested with a dummy Reid and Unit. CLXXX_RedeliveryWrapMap?Reid=1 and supporting artisan wraps, CLXXX_Redelivery_Underframe?Reid=1&Unit=322482 for example, should be tested from the perspective of both T-Asset and TOS-Rectify. Outputs should be verified on CLXXX_Redelivery_Cost?Reid=1&Version=1.
Checker's Responsibilities [Do we want to create a checker wrap with a checklist of the below? (DH 13/5/2021)]
Wrap functionality verified
Wrap Aesthetic verified
Wrap Navigation verified
Wraplication specification is correct and up to date
Anyone from the ExcelWraps Team can read the specification to diagnose bugs and add new features to the wraplication.
Client Demos - Client demos must never fail and should never take place until the demo have been rehearsed internally first.
WrapTasks - Any changes to this specification must be covered by a
. Time charged must be inclusive of both implementer and checker hours.
