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

Taidot: Visual Basic, Excel, Python, tietojärjestelmäarkkitehtuuri, Visual Basic for Apps

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Dubai, United Arab Emirates

Projektin tunnus: #21836665

17 freelanceria on tarjonnut keskimäärin 469$ tähän työhön


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 5 päivässä
(775 arvostelua)

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 Lisää

$500 USD 10 päivässä
(351 arvostelua)

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 3 päivässä
(314 arvostelua)

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 Lisää

$750 USD 3 päivässä
(60 arvostelua)

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 Lisää

$250 USD 7 päivässä
(235 arvostelua)

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 Lisää

$250 USD 5 päivässä
(190 arvostelua)

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 Lisää

$750 USD 4 päivässä
(24 arvostelua)

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 2 päivässä
(141 arvostelua)

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 Lisää

$500 USD 7 päivässä
(4 arvostelua)

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 Lisää

$555 USD 2 päivässä
(5 arvostelua)

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 Lisää

$250 USD 7 päivässä
(82 arvostelua)

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 Lisää

$250 USD 3 päivässä
(33 arvostelua)

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 Lisää

$555 USD 2 päivässä
(12 arvostelua)

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 Lisää

$500 USD 7 päivässä
(11 arvostelua)

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 1 päivässä
(4 arvostelua)

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 Lisää

$750 USD 7 päivässä
(2 arvostelua)

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. Lisää

$333 USD 7 päivässä
(0 arvostelua)