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

Ukončen Zveřejněno před 6 lety K zaplacení v momentě doručení
Ukončen K zaplacení v momentě doručení

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 ([login to view URL] and [login to view URL]). 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 [login to view URL] (into Quantity BOM tab in [login to view URL] file) and in [login to view URL] (into Structure BOM tab in [login to view URL] file). Implementation of "[login to view URL]!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 "[login to view URL]!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.

Excel Softwarová architektura VB.NET Visual Basic Visual Basic pro aplikace

Identifikační číslo projektu: #16348890

O projektu

10 nabídek Projekt na dálku Aktivní před 5 lety

10 Freelnceři na tento projekt zveřejňují nabídky v průměru $111

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 za 2 dní
(111 Recenzí)
6.3
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. Další

$150 AUD za 10 dní
(13 Recenzí)
5.2
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 Další

$108 AUD za 10 dní
(6 Recenzí)
3.4
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 Další

$111 AUD za 10 dní
(2 Recenzí)
1.4
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 za 10 dní
(0 Recenzí)
0.0
FelipeGAbreu

A proposal has not yet been provided

$111 AUD za 3 dní
(0 Recenzí)
0.0