
SQL Server Integration & Automated Excel Fleet Management
Delivery in
5 days
- Views 6
- Sales 1
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
I will develop a structured Microsoft Excel reporting workbook connected to your SQL Server database, following the supplied layout and data tables.
The completed workbook will include:
SQL Server Integration: Connect Excel to the supplied SQL Server database and retrieve the relevant data.
Fleet Overview: Display total fleet numbers and asset availability.
Booking Status: Track quoted, booked and on-hire assets.
Client & Asset Tracking: Associate each asset with the relevant client and booking information.
Daily Booking Calendar: Create a date-based view showing fleet bookings and availability.
Automated Calculations: Implement the necessary formulas and query logic to calculate fleet utilisation and booking positions.
Manual Refresh: Add refresh functionality to update the report from the SQL Server database.
Testing & Formatting: Test the workbook and ensure the final presentation follows the supplied layout.
Deliverable: A fully functional Excel reporting workbook connected to SQL Server, ready for operational use.
The completed workbook will include:
SQL Server Integration: Connect Excel to the supplied SQL Server database and retrieve the relevant data.
Fleet Overview: Display total fleet numbers and asset availability.
Booking Status: Track quoted, booked and on-hire assets.
Client & Asset Tracking: Associate each asset with the relevant client and booking information.
Daily Booking Calendar: Create a date-based view showing fleet bookings and availability.
Automated Calculations: Implement the necessary formulas and query logic to calculate fleet utilisation and booking positions.
Manual Refresh: Add refresh functionality to update the report from the SQL Server database.
Testing & Formatting: Test the workbook and ensure the final presentation follows the supplied layout.
Deliverable: A fully functional Excel reporting workbook connected to SQL Server, ready for operational use.
What the Freelancer needs to start the work
SQL Server connection details and necessary access permissions.
Any required database credentials.
The relevant database tables and sample records.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies