Fermé

Stand alone software conversion for excel workbook

Currently we use an excel template to do the following tasks for us, using a combination of VBA and spreadsheet formulae, using about 7 different worksheets.

What we do is:

1) import data from a csv file. This file contains information such as a unique client id (6digits), unique animal id, contact information, drug products and dates when these are due or sold to a specific animal. Every different drug will appear as a new line in the .csv for an animal, so if 'client a' has 'animal x' which needs 'drug 1' and '2', this will be on two lines of the .csv (one for each drug).

2) process the data to remove unnecessary information from it – such as removing unnecessary characters from a phone number string which may have been entered in the database (eg in the field mobile: '07123-432943 (mrs)' becomes '07123432943')

3) The most important bit: Analyse the data so that we concatenate (combine) information belonging to one client into a single output string which makes sense and reads appropriately. So for example 'client a' may have animals x, y and z. x may need to be told it needs drug 1 , y needs 1 and z needs 1 and 2. The final output might read ‘dear client a, animal x,y and z require drug 1, but z also requires drug 2...'. It is important that the program doesn’t just add one animal after the other in a continuous addition but creates a well composed output for each senario as far as possible and trying to avoid generics such as: require(s). The way the spreadsheet does this is to create a code for each senario and then use different templates depending on the code. There would probably be a cut off at which it would be too complicated to incorporate multiple animals requiring multiple different drugs – the current excel based system creates unique outputs for up to 3 animals requiring different medications (still quite a few permutations!). More than this and it produces a more generic output, but the alternative would be to split the output into two I suppose (eg if there are 5 animals, do the first three then the other two as two different output messages)

4) It will select which is the most appropriate method of communication available – so will preferentially send to email rather than SMS, and create different message depending on the modality – as characters are obviously limited in SMS. We don’t have emails and mobiles for every client so hence the different methods. In addition some data is more suited to certain communication – appointment reminders are probably best sent by text.

5) This then automatically sends the message to each client by email or email2SMS via outlook.

What we would like is a program that does this without needing to use excel. It also needs:

1) to be autoschedule-able or to be able to run manually at the press of a button (so perhaps continuously running the back ground) – we currently just do this by using scheduled tasks to run a auto opening macro in excel.

2) A preferences area where some options could be entered although this could be added functionality at a later date – such as time to send email, file locations, select an email client (or even integrated email client?); as long as I would be able to edit this per installation initially then these options don’t have to be there, but it would be a development step in the future.

3) As an additional output we are likely to want to be able to transfer the data to specific online print service which we use. Currently data is uploaded manually to the site by importing a csv and telling the website each time what column is used for what information, but I need to be able to automate this – so the program launches and loads the website in an internet explorer window, and automatically populates the data to the point where a preview is shown. We are due to meet with the website developer so I can find out more about how we can link the services.

4)Run on windows

Please let me know if you don't understand this brief

Compétences : Programmation C++, PHP, Architecture Logicielle

Voir plus : makes unique, two lines meet, transfer methods, software development process, software development needs, software developer site, software developer program, software developer phone number, point two lines meet, php mobile development system, php developer opening, online software development services, online best php developer, online architecture services, mobile system architecture, mobile client architecture, internet software development, internet explorer architecture, integrated information services, information software development, find two lines meet, find developer options, generics example, generic excel, find website developer online

Concernant l'employeur :
( 0 commentaires ) Kingston on thames, United Kingdom

N° du projet : #1027444

14 freelance ont fait une offre moyenne de 893 $ pour ce travail

LinkPlusOffshore

Please see PMB.

1200 $ USD en 32 jours
(5 Commentaires)
6.2
atchayagandhi

Hi, We can deliver the application for the described scenario, Kindly refer your private message board for further details.

750 $ USD en 10 jours
(28 Commentaires)
6.2
smartgest

I can help you with this. Please check PM.

750 $ USD en 7 jours
(26 Commentaires)
5.4
aboyko

I can do this application for Windows 32-bit platform.

750 $ USD en 21 jours
(5 Commentaires)
4.3
jgdovin

I am very interested in your project, please see PMB

750 $ USD en 10 jours
(8 Commentaires)
3.1
Appolon

Hello, please check your pm board.

750 $ USD en 10 jours
(4 Commentaires)
2.2
programer22

Hi I might to build this program with some open source C++ stuff (Qt or gtkmm depends what license you need Qt is GPL grkmm free in both case you might to have program for windows and linux as well) with a bit gui You Plus

750 $ USD en 14 jours
(3 Commentaires)
1.0
kostin000

i can do this easily, fast and good.

800 $ USD en 2 jours
(2 Commentaires)
1.0
RobStanfield

Thank you for the opportunity to bid for your project, "Stand alone software conversion for excel workbook".

1500 $ USD en 14 jours
(0 Commentaires)
0.0
LeoAugust

I am interest in your project. We can talk about it if you choose my bid raise. thanks.

750 $ USD en 0 jours
(0 Commentaires)
0.0
Bubblesort

Hi there. Looking foward to work with you, please see proposal details im PM. Thank you, regards.

750 $ USD en 30 jours
(0 Commentaires)
0.0
Wizzard84

I can do this for you.

750 $ USD en 10 jours
(0 Commentaires)
0.0
dumitreu

Easy. Some more time but with better quality....

750 $ USD en 15 jours
(0 Commentaires)
0.0
ankasoftware

Please have a look at PMB

1500 $ USD en 30 jours
(0 Commentaires)
0.0
sp1d3yz

I can do this given enough time

750 $ USD en 20 jours
(0 Commentaires)
0.0