Low Code Application Development Platform

1
Excel Spreadsheet Automation
2
Low Code Platform - AmpleLogic

• Low Code Application Development Platform is a
  powerful responsive application development
  platform enables configuration of complex
  business applications very efficiently with
  little help from Technical Teams.
• Low-Code Application Development Platform assures
  80 percent of your needs will be addressed
  minimal coding. We have developed multiple
  solutions across the vertical departments of an
  organization based on client requirements

3
Excel Key Challenges

• Excel is widely used and has become an integral
  part of Professional life. There are many
  unanswered questions when the Excel is shared
  among big group with multiple owners

4
Our Unique Solution for Excel Automation
Imagine an MS Excel that has the features of a
Controlled Access and Tracking  

• Centralized Database that can be accessed from
  Excel.
• Secure Data Access with Active Directory.
• In built workflow, No Email Attachments.
• Role Based Access, Definition to Rows, Columns
  and Cells
• Trace the Excel with Workflow Status Report.
• Triggers an Automated Emails on Button click
• Continue to Use the Excel Features Like Sorting,
  Search etc.
• Audit Trails On Data Changes
• No additional software required

5
We provide our automations in

• Sales
• Finance
• Supply Chain
• Production
• Engineering
• HR
• Purchase
• Quality
• IT

We develop any custom application based on client
requirements and irrespective of departments
6
Solutions so far developed

• Sales Targeting Forecasting
• Finance Budgeting
• Management Information (MIS) System
• OPEX (Operational Expenses
• CAPEX (Capital Expenses)
• Back Order Management
• Engineering Process Automation
• Energy Process Automation (Specific Energy
  Calculation)
• HR Appraisal Process
• Supply Chain Planning

7
Excel Automation

• A process which currently happening through MS
  Excel in the organization under various
  department can be automated through our Excel
  Platform by achieving workflow and roles based
  access with secured way.
• User can open excel application in any browser,
  save the excel and trigger a workflow for Review
  or Approval with single mouse click.

8
Tracking Status of Excel Work Flow
9
Challenges Our Solution Approach

• Current Challenges
• Sales Targeting is the challenging Task in
  companies as they deal with 5000 - 12000 SKU's or
  products with 1000 Field Staff.
• Currently the Sales Targeting process is done
  thru MS Excel Sheets, the strategy team will
  consolidate excels based on the regions and send
  them for necessary approvals.
• The Target Consolidation is delayed due to Excel
  sheets from each ASM/ RSM/SM/Divisional head with
  multiple versions floating thru emails.
• Business Users comfort of using excel sheets,
  makes them not to move out of Excel.
• Our Unique Solution
• Considering the Business User's excel convenience
  and understanding the excel consolidation issues,
  AmpleLogic team has come up with an Excel
  automation Tool with an Inbuilt workflow.
• This solution uses Excel kind of web Interface,
  auto generates the targets based on the
  Predefined Business Logic on 2 or 3 years data.
  Sales Team is allowed to rearrange Monthly
  Targets, to match with Yearly Target Value.
• The Inbuilt Dashboards gives the clear picture on
  Targets VS. Actuals, Current year/Month Targets
  against Last Year System.

10
Sales Targeting Solution

• Sales Targeting Solution is an web based excel
  interface application that helps to automate the
  existing manual process of sales targeting
  carried out through excel spreadsheets.
• AmpleLogic Sales Targeting solution will
  automatically assign the sales targeting based on
  the individual performance
• Generation of Sales Target based on previous 3
  year records. Target is given by divisional head
  which flows in defined workflow/hierarchy in
  sales team and they have the flexibility to
  rearrange the target at SM, RSM and ASM level.
• In single screen it provides the comparison of
  Target VS. Actuals and also shows the previous
  year performance information.
• Our tool completely removes the dependency over
  Excel and multiple sheets with security. Reduce
  the process completion time 4 times then manual
  process.

11
How It Works?
12
End User Interface

• Proven Case Study-
• This solution has been implemented in one of the
  Largest Pharmaceutical Company where 1000 Users
  are using our tool for the Sales Targeting
  Process.

13
Sample Graphical Reports
14
Finance Budgeting

• Allocation and distribution of budget for plants
  and different departments based on the products.
  Maintaining the financial flow and total
  expenditure of an organization and finally
  calculation of net profit and KPIs Report.
• Role Based Flow

15
End User Experience

• Excel like interface with Auto calculated Fields
  based on the formula with alerts in case of
  condition violation

16
Engineering Automation (Trackers

• Plant level tracking of resource consumption (
  like boiler, fuel , furnace, energy, air
  compressor, water uses, energy ) within a defined
  workflow input and secured access which finally
  generates an output sheet of KPI(key performance
  indicator) and power index, energy index with all
  validation and calculation.
• By our tool we are avoiding the need of multiple
  excel sheets floating on same department and
  reduces the task completion time.
• It also helps to maintain regulatory compliance
  system at plant.

17
Engineering Automation

• Current Challenges
• Giving manual input is difficult for each day.
• Too many excel sheets are floating in department
  which is tough to monitor and track.
• Importing data from SAP or other legacy system is
  difficult.
• No validation on data, irrelevant information
  inserted without any restriction and validation.
• Our unique Solution
• Workflow based data insertion which can be linked
  with active directory removing dependency over
  Excel.
• Automatically data will be imported from SAP only
  other data needs to be inserted from end user.
• Output sheet index after validation and
  calculation with required charts .
• Reducing the time completion process without any
  confliction.
• Help to maintain regulatory compliances system.

18
Engineering Weekly Input

• Our successful implementation
• Live in Sun Pharma for their 27 plants across the
  globe
• Going to associated with largest steel
  manufacturing company of India

19
www.amplelogic.com
To know more, email us info_at_amplelogic.com