Enhancing an Online Excel Application

Using VBA Macros

Free Download

CLASP is an international non-profit organization working to improve environmental and energy performance of appliances and related systems. They created an online street lighting evaluation tool to calculate street light design parameters.

The client wanted to update this tool with an additional method of calculation, VBA implementation of the formulas and greater choice of selection parameters.

We revamped the tool with VBA macros and implemented an additional method of calculating design parameters. The updated tool facilitates complex scientific calculations and provides more criteria to facilitate analysis. We also improved the user experience by adding functionality to illustrate the various street lighting configurations.

The upgraded tool equips users with more options and greater insight when designing street lighting. CLASP is now better positioned to reach its goals by influencing sustainable street light design initiatives.

Our Work

Industry

    Industry

Function

    Function
  • Industry

  • Function

  • Increasing Conversions with Adwords Spend Optimizer

    How To Optimize Adwords Budget in Real Time

    download
    An email with the download link will be sent to you.
    Download
  • Markdown Optimization for Retailers

    A Methodology to Track Performance and Maximize Value

    download
    An email with the download link will be sent to you.
    Download
  • Optimizing Marketing Spend with Marketing Mix Modeling

    Using Statistical Modeling and Empirical Methods

    download
    An email with the download link will be sent to you.
    Download
  • Leveraging Web Analytics for Customer Acquisition

    Leveraging Web Analytics for Customer Acquisition

    download
    An email with the download link will be sent to you.
    Download
  • Identifying Cross Selling Opportunities

    Using Advanced Data Analytics

    download
    An email with the download link will be sent to you.
    Download

*Subscribe to be the first one to know our latest updates

Contact us

Email us : cs@perceptive-analytics.com

Call us : 646.583.0001

or Fill out the form below:





Required*
Top 10 Emerging Analytics Startups in India to watch (Analytics India Magazine)

You have crafted a powerful analytical tool for us. Thank you.

Alan Benjamin
Principal, Benjamin Realty Advisors

I have been working with Chaitanya and Perceptive Analytics for about 20 months now. They did BI / reporting and excel tool development. Their work helped us in channeling our periodic reports to the senior and operational management. The team exceeded my expectations. Chaitanya would ask thought provoking questions that trigger a new line of thinking. They created good dashboards so our senior team can quickly interpret reports. We were able to make progress because the team knew finance and tools they created were easy to implement.

Samir Lavani
CFO at Pearl Hospitality

Chaitanya and the Perceptive Analytics team worked on multiple strategic projects that involved Tableau data visualizations. Perceptive's work (~ 1 year) led to successful launch of our portal - this was an important milestone for us. Visualizations created were insightful, easy to understand and visually attractive. The team often suggested ways to show data in more intuitive way so our audience can understand it. They also knew Tableau well that helped in customizing it for our purposes. The team worked hard to finish the project on time managing expectations. I look forward to working with Perceptive on other projects.

Haroon Yaqoob
Principal at Nomenclature Inc.