Đang Thực Hiện

Load Planning Database Ms Access

I am looking for an MS ACCESS expert who is very good with working on Reports. I have a spread Sheet that I would like to move into an Access Database. Please open the attached file (Load [url removed, login to view])

The database in the attachment is for example purposes to get you started.... OPEN THE DATABASE

This project involves 3 requirements.

1. Creating an import function & a Route Planning Form:

a) Create a function that Imports the Attached ".txt" Files into MS Access database and fill the table called "Tbl: Imported QAD Files". The text files come in every day, every hour so by the end of the day you've imported 8 files per supplier 1 for each hour. You need to include an indicator that shows when the file was imported(a new column showing date & time). The example table in the database is Tbl: Imported QAD Files

b) Route Planning:

Create a form that allows the user to plan # of Trucks and Routes. I've created a sample in a form called "Export". you need to Add the Planned Data sub form and allow the user to create results like in the table "Tbl: Planned Data" this has to be a very easy and quick proccess because there are over 50 Routes to be created.

2. Utilization Allocation:

a) Utilization by supplier in MS Access:

Look at the Queries in the database. It relates to the supplier tabs in the Excel. Most of the calculations have already been completed. Example: If you look at tab "CUSTOM MOLDED PRODUCTS" in the Load [url removed, login to view] and find "QRY: Sub Total Release.." in the database >>Filter>>DeliverDate "12/2/2010" You will see that the Utilization has already been calculated to match Utilization on the Excel sheet.

- You need this information for next step 2b.

b)Truck Assignment:

Assign Results of Utilization Calculation to Number of Trucks Assigned in 1(b) above. So when a file is imported the logic checks if that supplier has any planned trucks availlable then assigns all Orders to the availlable Trucks & Routes. If a truck is over capacity either because of (M3,Weight or skid spot) then allow the user to add an additional truck or reduce QAD Order quantities. Then generate Load Plan>>>

3. Reports:

Load Plan: Example in Excel

This report shows us how the Orders will be loaded on each truck and starting from skid spot 1 and which supplier orders are loaded. Each Route assigned in 1b that has orders in 1a should be shown in the report. If the Truck was over capacity when you calculated 2a then show BlowOut as shown in the attached example

Please review the attachment and ask any questions you may have before bidding. I am looking for a commited developer willing to work on other projects after this one.

Happy bidding.

Regards

Kỹ năng: Excel, Microsoft, Microsoft Access, SQL, Visual Basic

Xem thêm: load planner access, load planning excel, xls excel expert, utilization review, starting visual basic, planning an, need find access developer, looking access developer, need planner, function sheet sample, find excel expert, export project, create excel form expert, calculation logic, access database expert, load route planning excel, access load planning, access projects, export project 2010 excel, spread sheet expert, find planner, excel sheet expert, trucks, qry, project planning

Về Bên Thuê:
( 4 nhận xét ) Canal Winchester, United States

Mã Dự Án: #1077468

Đã trao cho:

mray32

Check private message

$180 USD trong 2 ngày
(1 Đánh Giá)
3.3

26 freelancer đang chào giá trung bình $173 cho công việc này

mrbrave

Ready to start now...

$200 USD trong 4 ngày
(77 Đánh Giá)
5.4
ExactSystems

You forgot to attach file.Please see detail on PMB. regards

$195 USD trong 6 ngày
(7 Đánh Giá)
4.9
ifaisal

Hello I can do this for you. I have expertise in MS access and has developed number of similar applications. Please see my private message for more details. Regards Faisal

$250 USD trong 15 ngày
(10 Đánh Giá)
4.2
superMena2001

please check your PM

$125 USD trong 7 ngày
(6 Đánh Giá)
4.1
PerfectSquare

please see the PM

$150 USD trong 5 ngày
(29 Đánh Giá)
4.1
muthumuni

Hello... #####... Can you Kindly see PMB for details ...##### Your satisfaction is my success muthumuni (Gold member) ................

$111 USD trong 7 ngày
(12 Đánh Giá)
3.9
mb01a

Please see my PM

$250 USD trong 5 ngày
(1 Đánh Giá)
3.4
guevanjr

I'm a experienced dba and systems developer. Ready to start.

$100 USD trong 3 ngày
(7 Đánh Giá)
3.3
ConsultOne

Please see my private message outlining the details of my bid. Please also send me the sample details which are missing from your bid outline

$350 USD trong 13 ngày
(1 Đánh Giá)
2.8
proitagent

I am a ms access profi and can easily do the job. Regards

$175 USD trong 1 ngày
(1 Đánh Giá)
1.7
iqbal9400

What is you want I am ready to fulfill your demand.

$180 USD trong 15 ngày
(0 Đánh Giá)
0.0
ymeknassi

Hello, I can make it done ASAP!

$70 USD trong 4 ngày
(0 Đánh Giá)
0.0
anthrosantos

I cannot find the attachment/s. I can do this project.

$250 USD trong 7 ngày
(0 Đánh Giá)
0.0
anquinton

I require any sample forms, database and information to be used to create this project. I also need to know it this database will be a single user database or a multi-user database and which version of access will be Thêm

$120 USD trong 10 ngày
(0 Đánh Giá)
0.0
DataAppGuru

Please see PMB for details. Thanks.

$50 USD trong 2 ngày
(0 Đánh Giá)
1.0
sekhar4dotnet

Hi I have lot of experience in developing MS Access database tools and reporting package for small medium companies. Example: Reliance ,Uninor projects are handle for Company. Thanks, sekhar

$100 USD trong 7 ngày
(0 Đánh Giá)
0.0
andleigh007

Please give me this project to serve you sir/mam

$250 USD trong 15 ngày
(0 Đánh Giá)
0.0
LuisGutierrez

I'm a MS Access expert since 2002, MS Excel since 1998, some C++ experience since 1999 and Java since 2006. Let's keep it easy and scalable.

$90 USD trong 4 ngày
(0 Đánh Giá)
0.0
sourabh20

Hi I have lot of experience in developing MS Access database tools and reporting package for small medium companies. I would like to implement this project as well. Thanks, Sourabh Bansal

$300 USD trong 5 ngày
(0 Đánh Giá)
0.0
Samtiger2

Access Expert Here !! Ready to start right way. Hope to achieve next positive feedback from you !!! Please check you inbox. "Always willing to walk extra miles to achieve Excellence"

$250 USD trong 5 ngày
(0 Đánh Giá)
0.0