Closed

We need a developer to implement existing function of Excel document with macros as new software

New software is to be developed that would replace Excel file with macros. Knowledge of Excel VBA macro language is necessary to be able to study current implementation. There will be more phases for this project, so we are searching for developer that can develop and support this software in long-term. This is description of Phase 1. In this phase only the same functionality that already exists in Excel file is to be developed. It is necessary to study existing Excel file and its macros to develop the same functionality. It is foreseen that this new software can be opened on the desktop computer as well as tablet or even mobile phone. Exact technology to use is not predefined, we are open to suggestions. It can run inside browser but we will consider also alternative suggestions, like mobile app development (some fields in a form will have to be filled with scanning QR code or barcode in the future).

Description of existing functionality in Excel file follows. This functionality must also be developed in Phase 1 (language used in Excel file is Slovenian, so some translations of it are used in this description), but of course it can/must be adapted to fit newly developed software best:

We have two Bill of Material (BOM) Excel files as an input to import to existing excel file ([url removed, login to view] and [url removed, login to view]). These two are exported from Solidworks software and represent bills of material of specific machine that is to be produced. Structure BOM contains entries that represent hierarchical structure of assemblies and parts. Quantity BOM contains entries that contain parts where their quantity in project is summed up. So they show up in quantity BOM only once, but in structure BOM multiple times in assemblies hierarchy.

These two BOM files are imported into Project.xlsm. Workflow is as follows:

1. First "Pot do kosovnic" ("BOM Path") must be set to point to path where Quantity_BOM and Structure_BOM are stored.

2. Click on "Uvoz podatkov" ("Import BOMs") button imports data found in [url removed, login to view] (into Quantity BOM tab in [url removed, login to view] file) and in [url removed, login to view] (into Structure BOM tab in [url removed, login to view] file). Implementation of "[url removed, login to view]!UvozPodatkovKosovnice" macro is to be studied for this to implement its functionality, because data are not just imported but also some simple data manipulation occurs.

3. Path "Pot do nacrtov" ("Plans path") has to be set.

4. Click on "Povezave do nacrtov" ("Create plan hyperlinks") button creates hyperlinks to PDF files.

Mainly it does following:

- takes path set under "Pot do nacrtov" ("Plans path") and adds plan name (found in "Part number" column in input Excel files) with extension PDF. This generated path is then set in Column D ("Stevilka risbe").

- deletes rows that cointain word "Sheet" in column D

- deletes cell contents in column D if it contains "-"

Macro "[url removed, login to view]!Povezava_do_nacrtov" is to be studied to implement this functionality.

5. Move to "Kolicinska kosovnica" ("Quantity BOM"). Under column "Dobavitelj" ("Supplier") right click on one entry. Popup menu oppens where you can choose "Status artikla". In submenu you can then set article status of this specific part. Entire row is then colored with specific color. Corresponding rows under "Structure BOM" tab are then colored also. Matching of these rows as well as other functionality of these status options can be studied under "Module 4" (functions like "PoslanoPovprasevanjeMacro", "NarocenoMacro" etc.)

If you have any additional questions about functionality to implement we stand ready to answer them.

Please provide us with examples of your past projects.

GUI has to be in Slovenian language at the end, but we can also translate it alone. Source code of the project is to be provided.

NOT PART OF CURRENT PROJECT BUT TO CONSIDER FOR FUTURE DEVELOPMENT: In next phases additional functionality will be added, like tracking production phases of specific parts. Currently these phases are only mentioned in columns "Operacija 1 - 5" (columns P-T). In next phase we will add possibility to set active operation of specific part and see which operations were already finished.

Kemahiran: Excel, Kejuruteraan Perisian, VB.NET, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: what we need for web developer, we need web developer in hanoi, we need web developer, get paid to make excel spreadsheets, freelance excel spreadsheet design, freelance excel jobs from home, excel jobs from home part time, online excel job home based, work from home excel projects, excel spreadsheet jobs from home, home based excel jobs, visual basic, we need freelancer mainframe developer cobol, need someone to create an excel macro document, we need to make a drastic update quickly to the dewitt staging site homepage please take read over the entire document before su, we need iphone developer, we need a ruby developer with immediate availability, we need a logo for a company and graphic design for the website see the word file attached for more details, we need a logo for a company and graphic design for the website see the word file attached for more details :-), we need a landing page for a product we already have an existing web site which can be used as

Tentang Majikan:
( 85 ulasan ) LAHORE, Pakistan

ID Projek: #16348890

13 pekerja bebas membida secara purata $102 untuk pekerjaan ini

$100 AUD dalam 7 hari
(28 Ulasan)
6.0
whitehorsetechn

Greeting, I have understood your We need a developer to implement existing function of Excel document with macros as new software task and can do it with your 100% satisfaction. Please ping me for more discussion. Lagi

$150 AUD dalam 10 hari
(11 Ulasan)
4.8
sysdesigner13

Hello. I have read your description carefully and understand it well. I am a full time developer and have high skills in Excel VBA. I have already completed a lot of similar projects in the past. I think yo Lagi

$50 AUD dalam 2 hari
(21 Ulasan)
4.6
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered ten excel vba projects in the past two months. Willing to take up your project. Thank you, Regards.

$150 AUD dalam 2 hari
(18 Ulasan)
4.1
herbzone127

Dear Hiring Manager. We carefully read your description about the project and knowledgeably aware about your requirements. As software developers we are interested in your project and also we worked with a develo Lagi

$108 AUD dalam 10 hari
(4 Ulasan)
3.0
$150 AUD dalam 10 hari
(3 Ulasan)
2.9
qualityteam19

A proposal has not yet been provided

$55 AUD dalam 2 hari
(1 Ulasan)
0.6
$111 AUD dalam 10 hari
(0 Ulasan)
0.0
$66 AUD dalam 10 hari
(0 Ulasan)
0.0
Ranjan2201

Understand from requirement that existing VBA project needs to be transformed into web application which will run on intranet. I have done similar projects in past and believe can do it this also. Looking forward fo Lagi

$111 AUD dalam 10 hari
(0 Ulasan)
0.0
sallysayed

i am talking and writing English fluently so it help me a lot and i have big experience in excel iam graduated from faculty of science and i work on Micro soft office especially on excel and analysis of data

$111 AUD dalam 10 hari
(0 Ulasan)
0.0
FelipeGAbreu

A proposal has not yet been provided

$111 AUD dalam 3 hari
(0 Ulasan)
0.0
$55 AUD dalam 10 hari
(0 Ulasan)
0.0