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

SQL Saturday Part 2: Learning About Microsoft Fabric 

Mike DiehlFeb 29, 20246 min read

SQL Saturday Part 2: Learning About Microsoft Fabric   February 29, 2024 I’ve been digging into Microsoft Fabric recently – well overdue, since it was first released about a year ago. At the recent SQL Saturday Atlanta event I attended in…

Custom Application Streamlines Production and Reduces Costs

Imaginet Resources CorpFeb 27, 20245 min read

A well-known consumer packaged goods (CPG) company specializing in pet food contacted Imaginet to complete and polish a custom application started by a few interns. The application was not as far along as they initially thought, and they needed support.  …

My Trip to SQL Saturday Atlanta (BI Edition): Part 1 

Mike DiehlFeb 23, 20245 min read

My Trip to SQL Saturday Atlanta (BI Edition): Part 1  February 23, 2024 Recently, I had the opportunity to attend SQL Saturday Atlanta (BI edition), a free annual event for data professionals and enthusiasts held in Alpharetta Georgia. I spoke…

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.