Project Summary

Real-Time Data Analysis Made Accessible Through Online Calculator

Real-Time Data Analysis Made Accessible Through Online Calculator

A provincial agricultural services corporation approached Imaginet to update and enhance their online calculation tools that were utilized by various people in the agricultural industry. Their calculators were in Microsoft Excel and prone to user errors and instability. Imaginet built an online suite of user-friendly calculators, making them easily accessible on any device – including mobile. This stage of the project focused on the development of a fertilizer efficiency calculator for farmers to have optimum fertilizer usage at all times to maximize profits. 

The Imaginet Application Development team used Angular 12, TypeScript, and HTML5/CSS3 to build the application on the front end. On the back end, we used data stored on a server using C#, .NET Core, and SQL Server 2019. We added new features like speedometer indicators using GraphJS and new drawing code as a plugin. We also added graphs that can display partial datasets and custom fields to store auto-calculated values that can be replaced with user inputs. A new type of input field (created using Angular) ties together various events so real-time calculations can take place that can be used in other calculators, and users can replace the calculated value with their input if necessary. 

Additional formatting was added with HTML5/CSS3 to allow the client to print a formatted version of the summary/calculator outputs. There is also a section for analysis where the client can see a complete visualization to help them determine the best possible fertilizer application parameters. 

Our team tested the accuracy of the calculations using xUnit on the back end and Karma and Jasmine in a browser environment. 

The original tool evolved in parallel with our development, so there was no downtime for the client or the end users. The client can now access real-time data analysis on any device, saving many farmers time and money with faster calculations. 

Our team has been working hard to deliver exceptional results, and we are thrilled to share our success with you. Don’t forget to subscribe to our newsletter to stay updated on our most recent Microsoft 365 projects. Fill out the form at the bottom of the page if you would like to work with us and someone will be in touch.

Technologies Used

  • .NET 6
  • Angular 12
  • Angular Library/Libraries
  • ASP.NET Core
  • Azure DevOps
  • C#
  • DBMS
  • Git
  • HTML5/CSS3
  • Jasmine
  • JSON
  • Karma
  • MediatR
  • Microsoft Excel
  • Microsoft SQL Server Management Studio
  • RDBMS
  • RxJS
  • SQL Server 2019
  • TypeScript/JavaScript
  • Visual Studio 2022
  • xUnit

discover more

Protecting Sensitive Data: Ensuring Privacy from a Data Engineering Perspective 

Olena ShevchenkoAug 29, 202411 min read

Protecting Sensitive Data: Ensuring Privacy from a Data Engineering Perspective  In a bank call center, staff members handle clients’ data. They have to identify clients for various requests while maintaining privacy. The call center representative must be able to identify…

Custom Script Setting in SharePoint & OneDrive Removed

Janine JeansonAug 22, 20245 min read

Last week, we published a blog discussing Microsoft retiring SharePoint Add-Ins. In that blog, we briefly discussed how the Classic Mode for Custom Scripts has been affected by that change. The Custom Script setting in SharePoint and OneDrive has already…

SharePoint Add-Ins to be Retired in M365 

Janine JeansonAug 15, 20243 min read

In Microsoft’s effort to provide modern, evolved digital solutions, they will be retiring SharePoint Add-Ins and pushing SharePoint Extensibility Models instead – such as SharePoint Framework.   SharePoint Add-Ins will stop working for new tenants in November 2024 and will be…

Let’s Build Something Amazing Together

From concept to handoff, we’d love to learn more about what you are working on.
Send us a message below or drop us a line at 1-800-989-6022.