APP DATA REPORT

Process Overview

Field	Details
Process Name	App Data Report
Segment	Consumer
Process Family	Lenovo India
Process User(s)	Wyzmindz solutions pvt ltd
Process Purpose	This report is instrumental in providing actionable insights, tracking performance, and supporting Lenovo’s sales strategies

Version History

Version Tag	Prepared By	Date of Update/Revision	Validated by	Reviewed by	Approved by	Revision Details
V 1.0	Kiran Biradar	02-12-2025	Daya	Vishwanath Mosale	SOP Document Creation	-
V 1.1	Kiran Biradar	17-12-2025	Daya	Vishwanath Mosale	SOP Document Creation	Flow chart updated

Distribution & Access List

Designation	Read	Write	Approval
Analyst	Yes	Yes	No
Team Lead	Yes	Yes	No
Manager	Yes	Yes	No

(Sellout to T3 Reporting)

1.1 Purpose

To process Raw App Data downloaded from the Bsharp platform and generate an accurate consumer RD sellout dataset. This processed data supports sales dashboards and trend reporting for top brands and retail partners.

1.2 Scope

This SOP applies to downloading, preparing, validating, and publishing monthly App Data for the Consumer segment in the RD vertical.

1.3 Business / Segment Overview

The RD channel covers top performing retail stores selling consumer PCs. Raw App Data provides transactional visibility from these stores.

1.4 Responsibility and Authority

• Execution: Kiran Kumar N Biradar
• Authority: Shilpi Gautam, Bhanuprakash HS

1.5 Escalation Matrix

Level	Contact	Organization	Purpose
L1	Kiran Kumar N Biradar	Wyzmindz	Data processing and corrections
L2	Bhanuprakash HS	Lenovo	Data approvals and support
L3	Shilpi Gautam	Lenovo	Final sign-off and escalations

1.6 RACI Matrix

Task	Responsible (R)	Accountable (A)	Consulted (C)	Informed (I)
Data download	Kiran	Bhanuprakash	Shilpi	Reporting team
Data processing & mapping	Kiran	Bhanuprakash	Shilpi	Reporting team
Validation	Kiran	Shilpi	Bhanuprakash	Reporting team
Publishing	Kiran	Shilpi	Bhanuprakash	Reporting team

1.7 Access Required

• Platform: Bsharp
• URL: https://apps.bsharpcorp.com/users_dashboard
• Access: Email ID and mobile number based password provided by Lenovo / Bsharp

1.8 Legends

Field	Meaning
NB	Notebook
DT	Desktop
MTM	Machine Type Model
G/NG	Gaming or Non-Gaming
SP Y	Special Price Yes
User Zone	Zone classification based on region

1.9 Tools Overview

Microsoft Excel is required for data cleaning, formulas, and pivot outputs.

1.10 Dependencies

• MTM Master file (latest as per Lenovo release)
• Previous finalized APP DATA file
• Raw App Data downloaded for the current month

1.12 Process Flow Chart

Step 1: for viewing flow chart first enable developer mode

Go to “file” menu click on “options” then click on check box mentioned as below

Step 2: Alt + F8 ---> Run (FnLock enable)

1.13 Step-by-Step Procedure

Step 1: Download Raw App Data

1. Log in to Bsharp portal.
2. Go to Report List and search “T3”.
3. Select Sellout To T3 report.
4. In Basic Filters:
   • Start Date: 1st day of current month
   • End Date: Yesterday
   • Apply Filter
5. Scroll down and click Download.
6. Create a working folder and keep all downloaded files together:
   • Raw App Data
   • APP DATA [Previous Month]
   • MTM Master [Updated version shared by Lenovo]

Step 2: Save App Data File

1. Open Form_Responses_Report file.
2. Save as: APP DATA [Previous Date]

Step 3: Data Cleaning & Header Alignment

1. Open the new APP DATA file.
2. In the Code Type Of Sale column:
   • Filter blanks → delete blank rows.
3. Insert one row on top.
4. Use MATCH formula referencing previous APP DATA to align headers.
5. Remove any #N/A headers.

Step 4: Formula Update

1. From previous month APP DATA → Copy formulas from BX1 to CF2
2. Paste into current month file in same cell.
3. Clear only values (not formulas) in:
   • CD2, CF2, BX2
4. Drag formulas down to full data length.

Step 5: Mapping and Classification

1. Filter Consumer DT
   • Populate Prod Type and Code Form Factor with formulas starting from BR2.
2. Filter Consumer NB
   • Set Prod Type = NB
   • Fill down formulas
3. With Consumer DT + Consumer NB filtered:
   • Standardize Code Type Of Sale = Consumer
4. NEW MTM mapping:
   • From New Segment Effective From 1st Jan’24
   • New Notebook + Desktops mapping
   • MTM Master reference
   • If blank or #N/A, use New Code Level
5. User Zone mapping:
   • Based on New Region
   • If West1, refer previous month mapping based key is city
6. Gaming classification (SP filter only):
   • If Code Form Factor contains gaming → G/NG = Gaming
   • Else if Code Series/Sub Series shows gaming → Gaming
   • Else → Non-Gaming

Step 6: Output Pivot

1. Select full dataset.
2. Insert Pivot Table → Enable Add this data to the model
3. Create Pivot based on the standard Lenovo reporting format.
4. Pivot columns rows and values as attached file below

1.14 Output Overview

Processed dataset containing:

• Store wise Consumer RD sellout
• Mapped MTM and product classifications
• Gaming / Non-Gaming segmentation
• Valid region and zone mapping

This supports analytics, dashboards, and sellout trend monitoring.

1.15 Validation Checklist

Checkpoint	Validation
Record Count	Matches source Raw App Data
Critical fields not blank	MTM, Type of Sale, Product Type, Region
Mapping correctness	Verified against MTM Master
Gaming flag	Logical correctness and zero blanks
Pivot totals	Match processed APP DATA totals

1.16 Communication

Final processed files are shared with Lenovo reporting stakeholders.

Use the link below to generate the email with the current dataset.

Attachments:

• Final APP DATA file
• Pivot output

1.17 Repository Details

Field	Details
Name	App data Report file including inputs Sources
Type	.xlsx
Path / URL	Local System
Access	Kiran/Admin
Owner / Team	Kiran
Last Updated	02-12-2025