Developer to Create a UI and Report

Budget 500$ per month
Posted: 5 years ago
Opened
Description
Before You Dive In: Quick Glance, Technical Skills, Definitions

Summary

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).

Pricing

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 UI.xlsx: 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:
C++,Java,Python,Microsoft,Software Development,Microsoft Excel,Disclaimer.txt,Report Examples.xlsx,Excel Stock UI.xlsx,UI Specifications and Features Required.pdf,Current Stock (18).xlsx
Working conditions:
500
Category
Source: guru.com

Add a bid

days

Similar freelance jobs

safe 
...
6 months ago
safe$7
Hi Robert P. , I noticed your profile and would like to offer you my project. We can discuss any details over chat....
safe 
"Hello, I need to create a website based on a . psd design file. Please also specify the timeframe within which you can complete this. Technical requirements: Layout (not pixel-perfect, but close to it) Responsiveness (the website should properly adapt to different screen sizes and devices) Clean code......
safe 
Project Title: Delphi Code Feature Creation Using delphi: Check to see if this already exsits, if not: create a shedulled task to start my program on PC startup with highest permissions, with no password or prompt. program is called for example: C:\Program Files (x86)\Myfolder\myprogram. exe If it already......
safe 
I want to create a program for customers and sellers to be able to use, to create a template for there artwork and be able to size them to there specific needs. And be able to download them as pdf or png files. This program will benefit the clothing industry with the industry i am in....
safe 
Hi, I am not quite sure if what I am asking is possible but within my University degree there is a calculator program which only works on the HP Prime prime calculator, I own a Casio fx-CG50 AU. I was hoping to have this program converted into a format which is compatible with my Casio calculator, all......
1 year ago
safe 
I am looking for a skilled C++ developer to help with a real-time object detection system for my project....
1 year ago
safe 
Project Title: Correct Rcpp armadillo code Overview: I am seeking a skilled developer to fix a compilation error in my Rcpp armadillo code. The code is currently throwing a compilation error, and I need it to be resolved promptly. Requirements: - Proficient in Rcpp and armadillo library - Strong understanding......
1 year ago
safe 
Project Description: - I am looking for a freelancer who can combine all the columns of 2 rows with similar values in Telerik Reporting. - The combined data needs to be displayed in a table view. - Ideal skills and experience for this job include: - Proficiency in Telerik Reporting. - Strong understanding......
1 year ago
safe$250
Bonjour Dmytro M. , j'ai remarqué votre profil et je souhaite vous proposer mon projet. Nous pouvons discuter des détails via le chat....
safe 
Hello, I am looking to develop a unity soccer game with moves like score hero 1. Map with 1-3 stars achievments 2. engine to make the goals like i want 3. smooth game play 4. IAP , shop , buy lives 5. lives to play 6. finger smoothness touch 7. the level will be added automticlly to the map 8. rewind......
1 year ago
safe 
Project Title: Bootloader For Renesas RL78 mcu Description: I am looking for a skilled developer to create a bootloader for the Renesas RL78 mcu. The ideal candidate should have experience with Renesas RL78 mcu and be familiar with the development environment. bootloader code is ready need help for run......
safe 
I am using EMA´s (50/75/100/200),two Stoch (5/5/5 and 5/3/3), RDX Indicator and the Indicator "The Arty". For Short Positions the Prive has to be under the 200 EMA (the 100EMA under 200, 75 under 100, 50 under 75, NOT crossing) and for Long Positions over the 200 EMA ( 100 over 200, 75 over 100, 50 over......
1 year ago
safe 
My project involves using an Emotional Stroop Task to measure and assess attentional bias towards emotional stimuli. To do this, I will be using the Drift Diffusion Model which is an analytical model to study the human decision making process. My study will need to include 90 participants in order to......
safe 
I am looking for a WPF Developer for a long term project....
1 year ago
safe 
I'd like to extract tables from pdf invoices files. At this stage i really only want the products that are in the tables on the invoices. The only information i would like from the invoices is supplier date (received) location received. Within thetables i require stock code, product item, the unit measurement......
1 year ago
safe 
Im creating a config using 'openbullet 1. 4', everything added successfully, due i have 3 years of using openbullet, but this request i never faced it before!...
1 year ago
safe 
This position is responsible for verifying data quality reports and queries, correcting errors and also tracking them....
1 year ago
safe 
We are currently looking for developer to contact us on developing integration/plugin for below listed platform. Please drop me message on which plugin you're able to develop. Please send similar plugin portfolio of your previous work. The plugin need to ready for uploading to marketplace . ActiveCampaign.......
3 year ago
View all