Find Jobs
Hire Freelancers

47132 Data checking and updating.

N/A

Completato
Pubblicato più di 18 anni fa

N/A

Pagato al completamento
[login to view URL] I want to create a program that will update two excel lists in a particular way. You can see the program layout in the link I provided above. Data files: Two excel files (or one with two tabs). Each spreadsheet contains 3 columns: Last First Names(given), some Date(given), and a last column that will be updated by this program. Main Program Window and List Window: Will include three buttons: List1, List2, Update Lists. Clicking on List1 or List2 will open a window that will show all the info in that spreadsheet. The data can be edited and thus we have a "Save" and "Cancel" buttons that will either save and close or not save but still close this window. Update Window: Clicking on "Update Lists" button will open this Update Window. The main features of this program are in this window. This window has several stages: 1. It's has no data when it's opened. 2. You enter the data into the manual list either by typing or by copy-paste. 3. You click on "Find" button. The program will check if there is a row in any of the lists that has the first and last names that match to the manual list. In other words, we check to see if we have the names from the manual list in any of our given two lists. Example of successful and unsuccessful matches: John Smith = John Smith Smith John = John Smith Smith John = john smith Smith-John = John Smith Johny Smith != Smith John John Smith Y != Smith John John Smith != John Smith Y John Doe Smith != John Doe John Doe Smith != John Smith John Doe Smith = John Smith Doe When a match is found in some list (or both), it should be displayed in its column. The same name in manual column should change its color to be the same color as the color of the title above each list column. If the person from the manual list was found on both lists, then it will be colored in some third different color (blue). 4."Find" button disappears (or disabled). We now have the "Update" button. We now enter some string into the Date input box. This string (including comma) will be appended to the THIRD column of each list and only to the rows of the found names. 5."Update" button disappears (or disabled), Date input box becomes un-editable, but still holds the string. We now have the "Save All" and "Print" buttons. Save All button will save List1 and List2 to the same location where they were read from. The manual list will get saved to a new excel file. The program will ask the user where to save it and by what name. 6."Print" this function will print the manual list and the two partial lists of names that were found in list1 and list2. Because the size of the lists may vary, the proper way would be two print each list separately. Note: Only "Save" and "Save All" buttons can modify permanently the contents of list1 and list2 excel files. If you have any suggestions or recommendations on how to improve or make this program better, please let me know.
Rif. progetto: 1796413

Info sul progetto

1 proposta
Progetto a distanza
Attivo 12 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
Escrow required. I'll code it using Borland C++ Builder 6. Please check PMB also.
$95 USD in 4 giorni
4,8 (67 valutazioni)
5,6
5,6

Info sul cliente

Bandiera:
5,0
2
Membro dal mag 25, 2004

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.