Find Jobs
Hire Freelancers

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

$250-750 USD

Cancelado
Publicado hace más de 4 años

$250-750 USD

Pagado a la entrega
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 [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
ID del proyecto: 21836665

Información sobre el proyecto

15 propuestas
Proyecto remoto
Activo hace 4 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
15 freelancers están ofertando un promedio de $481 USD por este trabajo
Avatar del usuario
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 en 5 días
4,9 (777 comentarios)
8,7
8,7
Avatar del usuario
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 en 3 días
4,9 (426 comentarios)
7,7
7,7
Avatar del usuario
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 project. Thanks. .. .
$750 USD en 3 días
4,7 (72 comentarios)
7,4
7,4
Avatar del usuario
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 projects, i do everything, that's why i only take what interests me and i can do it effectively. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$250 USD en 7 días
4,9 (289 comentarios)
7,2
7,2
Avatar del usuario
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 the requirements, UI Specifications and Report examples. I can provide a completely Excel based solution. I have implemented many similar solutions involving file import and processing and report generation. I think 200 USD for all the mandatory features is a fair price. For the additional image requirement, my quote is 30 USD. Since you have set the budget has minimum $250, I cannot quote below that. If you can open a project with same description and set the budget as $30-$250, I can quote $200 and if extra feature of image inclusion is subsequently considered, a new milestone can be added. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 20 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$250 USD en 5 días
5,0 (227 comentarios)
7,0
7,0
Avatar del usuario
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 and portfolios. Thanks Note: This is not an automated bid and i'm ready to discuss your project right now. .. .
$750 USD en 4 días
5,0 (28 comentarios)
6,4
6,4
Avatar del usuario
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 software developer who has rich experience in this field. If you contact me, you and I will be happy. Thank you in advance. Skills: Excel, Python, Software Architecture, Visual Basic, Visual Basic for Apps
$555 USD en 2 días
4,9 (11 comentarios)
6,4
6,4
Avatar del usuario
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. Thanks.
$250 USD en 3 días
5,0 (230 comentarios)
6,5
6,5
Avatar del usuario
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 is not a problem for me. With my strong experience in Python I can do your any project perfectly. Please ping me and let’s continue discussing. If you hire me, I will do my best and I can work as full time on your timezone. Hope to contact soon. Best regards, Alexander T.
$500 USD en 7 días
5,0 (5 comentarios)
5,9
5,9
Avatar del usuario
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 system in Excel with VBA programming. I understood all requirements and able to convert it into action. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes to develop User Interface. I also have expertise in Manipulating and Exchanging Data in Multiple Sheets, Aggregate values, Critical Programming, Developing System for Management and Creating Reports. I can put images from specific folder into excel rows (it is future work in your case). So, I have sufficient knowledge and experiences to complete the work. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$250 USD en 7 días
4,8 (100 comentarios)
5,8
5,8
Avatar del usuario
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 this field. If you contact me, you and I will be happy. Thank you in advance. Skills: Excel, Python, Software Architecture, Visual Basic, Visual Basic for Apps
$555 USD en 2 días
4,8 (14 comentarios)
4,7
4,7
Avatar del usuario
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 en 1 día
5,0 (7 comentarios)
4,1
4,1
Avatar del usuario
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 positive response! Regards, Page O.
$750 USD en 7 días
5,0 (2 comentarios)
2,5
2,5
Avatar del usuario
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. give me a feedback to start working with you. thank you. my bests .
$333 USD en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED ARAB EMIRATES
Dubai, United Arab Emirates
0,0
0
Miembro desde oct 17, 2019

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.