Developer to Create a User Interface To Read From Excel Stock File and Generate Customised Report

Before You Dive In: Quick Glance, Technical Skills, Definitions


You will create an app (preferably by Excel) that reads an Excel file containing item stock and create a report. The report is customized as per list of option provided the User Interface (UI) of the app.

Though not included in this project now. The developer should be able to develop a module in the future that adds an image from a folder for each row as per the product ID.

Project Output:

I need to create an excel file (or any other software/platform/program language) that provides an interface to load an excel file and rearrange it in a certain way according to requirements, essentially creating another table that shows certain columns in certain arrangements.

Development Environment

The project assumes Excel with VBA. However, any other platform is ok (Access, Python ...etc.) as long as it reads Excel file and generates Excel files (with Images in future development).


The project is priced at USD 200 and will be done over four milestones; 50 for each.

A 5th milestone might be (which means it might not) added related to adding images. See Future Development: Adding Images. This means you should have the ability to write a program that adds images to an Excel file from a Folder. The 4th milestone is priced at an additional USD 50.

If you feel the price is low (or high); please feel free to let me know you lump sum price in the following format:

X + Y

Where X is your price for the project and Y for the image milestone.

Related Files

This specification and feature file must be viewed and better understood by viewing and studying the following support files:

- Excel Stock [login to view URL]: Excel Stock User Interface, is an example file of the design of the user interface. The purpose is to illustrate the features required. It lists all the options required for this project. This will be referred to as "UI Example" file.

- Report Examples: Shows examples of output of the report needed.

- Current Stock 18: An actual stock file. This will be referred to as "Source Example" file. Tests of features should be run on the file.

Some definitions and Background

The original file is a stock file for food items, namely confectionery items.

The stock is recorded using three Unit of Measures (UoM): Carton (CTN); BOX; Pieces (PCS)

In the Report Examples file provided, the Stock_Raw sheet, for Item INC-10-000:

56.42 CTN = 1354 PCS

The issue here is the file is hard to read because it lists each store stock in a separate row.

The last column Qty (All Warehouses) sum CTN for all same item across all lines of similar items.

The original file that will be fed to the app to generate the report will be called the "source" file.

The objective of this app is to aggregate these same items into one row where warehouses will become headers rather than separate rows; see the Report Examples file

Items are same if they have the same Product Code + Expiry Date; this IMPORTANT to understand.

The specifications will suggest using setting variables to control some features and pass values, for example filling color of cells. These variables are presented in the format {variable_name} to distinguish them. The variable name in the app will be just variable_name without {}. See "Configurations" Sheet in the UI Example file.

To Dive In! please load the Specifications and Features Required file

Skills: Visual Basic, Excel, Python, Software Architecture, Visual Basic for Apps

See more: user interface web developer, create front end user interface excel, create user excel, create user excel list, mortgage calculator user interface read files graphic, create read write excel xml file vbnet, create user interface restaurant ordering system, create user interface several applications, create user interface application oracle, write program recognise common symbols neural networktext interface gui user interface pls read file attached , end developer working user interface, create user interface desktop application, create user interface udk, create user interface, also you are not allowed to use drag and drop tools such as those found in netbeans etc to create the graphical user interface f, create user interface online, how to create mobile shop balance sheet from excel

About the Employer:
( 0 reviews ) Dubai, United Arab Emirates

Project ID: #21836665

17 freelancers are bidding on average $469 for this job


I wish to confirm if you are okay with a web application in PHP and MySql. This will need to be hosted on a web server. Once you confirm, I will study in detail and get back to you.

$500 USD in 5 days
(775 Reviews)

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha More

$500 USD in 10 days
(351 Reviews)

Hello, I’m an Excel VBA expert and I would like to develop your reporting tool. Please check my profile and contact me to discuss further details. Regards.

$250 USD in 3 days
(314 Reviews)

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 More

$750 USD in 3 days
(60 Reviews)

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje More

$250 USD in 7 days
(235 Reviews)

Greetings! This the best requirements definition that I have come across on this platform. It is as thorough as it can get at this stage of the project - congratulations on a commendable job! I have read through all More

$250 USD in 5 days
(190 Reviews)

Hi there, Being an expert in Python programming I can do this project for you. please leave a message on my chat so we can discuss the budget and deadline of the project. Also, have a look at my profile for my reviews More

$750 USD in 4 days
(24 Reviews)

Hi, I have understand the project requirement & interested to make for this project. I will do it within time. Please send a message so we can discuss more & start the project. Thanks.

$250 USD in 2 days
(141 Reviews)

Hi. I just read your project description carefully and it sounds like you are looking for me. Python is my one of main programming language in my life. I can build good UI with pyqt and managing Excel or PDF in python More

$500 USD in 7 days
(4 Reviews)

Hi,dear! I am quite interested in your project - 'Developer to Create a User Interface To Read From Excel Stock File and Generate Customised Report'. :) I've already done this kind of project before. I am a skillful so More

$555 USD in 2 days
(5 Reviews)

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions, disclaimer and all attached documents carefully. My price: USD 200 + 50 I can develop complete working sy More

$250 USD in 7 days
(82 Reviews)

Hi, I have understand the project requirement & interested to make program to organize and make dynamic report in excel as required for this project. Please send a message so we can discuss more & start the project. Th More

$250 USD in 3 days
(33 Reviews)

Hi,dear! I am quite interested in your project - 'Developer to Create a User Interface To Read From Excel Stock File and Generate Customised Report'. :) I am a skillful software developer who has rich experience in thi More

$555 USD in 2 days
(12 Reviews)

Hi.I have checked your requirement and understand it well. I have many experience in **** python **** I am a full stack developer with enough experience and skills in Django & ReactJs & VueJs & ASP.NET & PHP & JAVA More

$500 USD in 7 days
(11 Reviews)

I am a professional data scientist from Scotland I have a vast amount of experience working with Excel spreadsheets. I am happy to discuss your project further when you are available.

$777 USD in 1 day
(4 Reviews)

Greetings, My name is Page and I have been working from last 8 years in IT field. I am very much interested in your project and would like to invite you for further discussion over chat board. Waiting for your positi More

$750 USD in 7 days
(2 Reviews)

Hi, Hope you are fine I am Abdenor from Algeria. I am an Expert Excel with VBA Macro. I work every day on Excel since 17 years, I have developed more than 300 app Excel for professionnel use. I am sure I can help you. More

$333 USD in 7 days
(0 Reviews)