Kapalı

Excel-based Dispatching Program

Job Description:

Hi, my name is Devin Sibley and I represent Sibley Transport. Our team is looking to design a program that simplifies & maximizes efficiency at our work place.

Our company's main income comes from hauling produced water from wellsites for oil & gas companies. The water ends up in a storage tank on location, and we are responsible for hauling the water before the tank gets full.

Our current program works well, but we need help to bring it to the next level. Currently, we have excel spreadsheets that automatically calculate an estimated volume within each tank in a week (Monday-Sunday.) When we're sent actual tank volumes from an employee of the oil company, we readjust our estimated values, and highlight those new values in the color Orange. When we decide it's time for a tank to be hauled, we highlight that tank Yellow, and dispatch a truck to go haul it. When the excel sheet reaches the end of the week, we have to manually create a new sheet.

My aspirations for improvement include (but are not limited to):

1. Having the spreadsheet automatically highlight a tank when our estimate reaches 75% capacity.

2. Designing a mobile app, so that the employees of the oil company can log in and adjust our estimated values when they have actual tank volumes.

Also having an interface for drivers as well, so they can change the value to zero when they've hauled the tank.

3. Having the spreadsheet automatically create a new sheet when the week has elapsed.

Beceriler: Excel, Visual Basic, Yazılım Mimarisi, Veri İşleme, C# Programlama

Müşteri Hakkında:
( 0 değerlendirme ) Spruce Grove, Canada

Proje NO: #36234909

Bu iş için 36 freelancer ortalamada $1176 teklif veriyor

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am a Daha Fazla

$1200 CAD in 10 gün içinde
(636 Değerlendirme)
8.6
asin1987

Hi Devin, I know I have bid beyond your budget, but I am giving a solution which is beyond Excel capability. Please do read once! So I propose to have the solution built on Microsoft Power Platform. I understand you c Daha Fazla

$2000 CAD in 25 gün içinde
(341 Değerlendirme)
8.5
AzzkaNoor

Greetings Devin! I am an expert Full-Stack web app developer having 8+ years of hands-on experience in fleet management applications development. I am happy to mention that I currently rank in the top 2% among 58+ mil Daha Fazla

$1500 CAD in 7 gün içinde
(44 Değerlendirme)
8.0
liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Daha Fazla

$1500 CAD in 4 gün içinde
(86 Değerlendirme)
7.8
Giovanni704

Hi there! I have more than 10 years of experience as a Data Base Administrator and Analytics Engineer. I would love to work together on your project and help you with the program to make it work smoothly and optimally. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(58 Değerlendirme)
6.9
apgrl123

I CAN COMPLETE YOUR PROJECT EASILY Hello, I am programmer with enough experiences on C#/.NET, VB.NET for 10+ years. C#/.NET, VB.NET is nice programming language and I am majoring on it for long years so I have confiden Daha Fazla

$1000 CAD in 15 gün içinde
(23 Değerlendirme)
6.6
SShtv

Hello, I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and m Daha Fazla

$750 CAD in 7 gün içinde
(129 Değerlendirme)
6.6
ravinderkumar248

Hi there, I can create and automate Excel-based Dispatching Program for you based on your requirements. I have 7+ years of expertise in Excel/VBA, SQL, Power BI, Tableau creating complex automation tools, formulas, Daha Fazla

$750 CAD in 5 gün içinde
(159 Değerlendirme)
6.1
kevins50

Hello, I'm a mobile and full-stack developer, I can develop this solution for you. A server would be needed so it work as a hub for information, the Android app would connect to it and get/set information about the sta Daha Fazla

$1125 CAD in 10 gün içinde
(42 Değerlendirme)
6.2
ayesha0124

Hi there. I am a full stack developer with experience in Software Architecture, Data Processing, Visual Basic, Excel and C# Programming. I have worked with many similar projects. I and my team of developers strive to Daha Fazla

$1500 CAD in 8 gün içinde
(7 Değerlendirme)
5.2
braincenter

Hello, I hope this message finds you well, Thanks for posting such an interesting project. I'm the exact type of contractor you are searching for. Having worked on similar projects for the past 10 years, I can handle Daha Fazla

$1125 CAD in 7 gün içinde
(17 Değerlendirme)
5.2
gahisharma

Hi, Hope you are doing well. We are a much expertise group of iOS, Android, Website developers, and Designers. We have developed Native Apps for various concepts like: #E-commerce, #Social Network, #Chat App - Voice Daha Fazla

$1125 CAD in 7 gün içinde
(6 Değerlendirme)
5.4
sharmin283

Hi, i m very interested for this kind of job and i am expert software developer in vusual basic and execl based software , i can upgrage the software version as you want, i read and undersntad all, i can start asap and Daha Fazla

$1000 CAD in 3 gün içinde
(16 Değerlendirme)
5.0
ONYEMATeam

hi dear with 20+ years experinces in software development i can tell you i can develop apps for your business and organaize your data. i have deep skill in database, application(web,desktop,mobile, blockchain) so i can Daha Fazla

$1125 CAD in 7 gün içinde
(16 Değerlendirme)
5.2
ankurbora7

Hi, Devin Sibley ? If u want excel macro, I can do this. If u want it in web version or desktop, I can help u. I've already created excel based on apps in both desktop and web. So, I can help u anyway. Hope to wor Daha Fazla

$1250 CAD in 20 gün içinde
(4 Değerlendirme)
4.9
amokhtar70

Hi, I have gone through the Job details and am interested in taking it up. I need you to share the files with me along with the required changes and I will deliver the required tasks fast and accurately. I’m Ahmed Hass Daha Fazla

$1000 CAD in 7 gün içinde
(19 Değerlendirme)
4.6
umairkaramat24

Hi, how are you? I go through the description and read it carefully, I know exactly what you are looking for. I have 5+ years’ experience in these skills Excel, Data Processing, Visual Basic, Software Architecture and Daha Fazla

$1500 CAD in 7 gün içinde
(11 Değerlendirme)
4.0
SandelaSolutions

Hi Devin - I am a software developer specialising in building custom Micosoft Access systems for small to medium sized businesses. I normally become involved when clients outgrow their Excel spreadsheets or other leg Daha Fazla

$1200 CAD in 7 gün içinde
(6 Değerlendirme)
4.0
Jaswinderkdevbi1

Hi, **** PHP expert**** I have more then 15 year’ experienced in development As i am expert, I can build it according to your requirements. Because I have a lot of the experiences about these fields, I can build y Daha Fazla

$750 CAD in 7 gün içinde
(5 Değerlendirme)
3.6
marlinrikey

I want 500CAD for this project because requirements are easy to implement for me. Hello, I've read your description carefully and fully understood. This project can be completed using C# or pyQT. Really interesting and Daha Fazla

$750 CAD in 7 gün içinde
(4 Değerlendirme)
2.6