Find Jobs
Hire Freelancers

Excel programming

$750-1500 USD

Annulé
Publié il y a plus de 10 ans

$750-1500 USD

Payé lors de la livraison
I have data in a large spreadsheet (attached as Sample Data). Each row is one report. Data in column O (yellow highlight) is the date dictated, column P (orange) is time dictated, Column F (green) is work type and column S (blue) is characters. I need to generate a report from the Sample Data that sets out the sum of the characters by day within 4 different time periods 0000 - 0600, 0600 - 1200, 1200 - 1800 and 1800 - 0000 by work type. I need to be able to take the Sample Data sheet of any number of rows and be able to use this program to generate the above information. Typically I'll run the Sample Data for a month and there may be 20,000 rows in the data sheet.
N° de projet : 5193980

Concernant le projet

53 propositions
Projet à distance
Actif à il y a 10 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
53 freelances proposent en moyenne $882 USD pour ce travail
Avatar de l'utilisateur
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$750 USD en 0 jour
4,9 (335 commentaires)
7,7
7,7
Avatar de l'utilisateur
Sir I'm expert on Excel and i have done many project like this . Looking forward working with you. I'm ready to start now . Thanks
$833 USD en 10 jours
4,9 (322 commentaires)
7,1
7,1
Avatar de l'utilisateur
Hi....The budget you have set for this project is very high......As I understood the project, its hardly time taking work (can be finished in 1-4 hours depending on your need) and can be done at lower rate.....I am excel Expert and can complete this report very quickly.....I am available to discuss further about the project...
$766 USD en 1 jour
4,9 (259 commentaires)
6,8
6,8
Avatar de l'utilisateur
Dear Sir/Madam I'm happy to help you on this task.. I can do this for just $200 I can develop a perfect model for you. I have done lots of similar reports ;-)) You can visit my profile to see my reliability..;-) If you are comfortable, we can discuss the project further I assure you that, I will go beyond your expectations I look forward to hearing from you Best regards Priyal
$750 USD en 1 jour
5,0 (196 commentaires)
6,8
6,8
Avatar de l'utilisateur
Hi Chopkins. I have looked at the Sample Data and have gone through your requirements. I must say that its very easy for me to get it done in hopefully 2 days. I am very comfortable in dealing with large amount of data in Excel so the project requirements should not bother me at all. Kindly take a look at my profile and the Excel projects I have delivered so far. With a 100 % completion rate, I do not have any work in progress as I always deliver in time. I can provide you a sample of how it would be done, if you like. I also intend to include a very convenient user interface to it so that it would be easy to use. Lets get started on it and wind it up. If you have any concerns, kindly share. Hoping to read back from you. Regards. Usman
$770 USD en 3 jours
5,0 (70 commentaires)
6,7
6,7
Avatar de l'utilisateur
Hi, I want to help you to build an excel macro to accomplish your task. I'm actually willing to do this for $200. If you agree, please hire me directly using hourly project from my profile page: www.freelancer.com/u/sswijaya.html If you agree, I can create a working sample macro for you. Looking forward for your reply. Best Regards, Susanto
$750 USD en 3 jours
5,0 (69 commentaires)
6,4
6,4
Avatar de l'utilisateur
Dear Sir, Consider the job done with perfection. Thank you
$750 USD en 2 jours
4,8 (63 commentaires)
6,3
6,3
Avatar de l'utilisateur
Hi Take the service from the expert. I have successfully done many excel project and bid here confidently to execute it within shortest possible time. Please contact with me and give me a chance to assist you. Regards harubel
$998 USD en 7 jours
5,0 (41 commentaires)
5,8
5,8
Avatar de l'utilisateur
Good day, I THINK MADE INCORRECT BUDGET FOR THIS JOB. IT CAN BE DONE VERY CHEAPER. PLEASE CONTACT ME. I WILL GIVE YOU A FREE DEMO. I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the links for my past experiences: https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html https://www.freelancer.com/projects/4848189.html https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html Regards.
$750 USD en 2 jours
5,0 (71 commentaires)
6,0
6,0
Avatar de l'utilisateur
hey Chopkins, Firstly - I think you have posted the project in wrong category (750$ and above). This appears to be a very simple and interesting project for us and we can do this at a very low price but with awesome accuracy. Please reply and we can discuss further. thank you :-)
$750 USD en 3 jours
4,8 (159 commentaires)
5,9
5,9
Avatar de l'utilisateur
Hi, I have worked as pricing analyst for 4+ years. During this stint, I have worked on projects involving elasticity analysis, break-even analysis, regression and price models. In my projects, I work extensively on excel. I guess I have understood your requirement and can do it in properly. [I have done similar work for another employer and was able to finish it in time and to the customer's satisfaction. Please have a look at his [Sadebow] review in my profile.] Regards! Vikas
$750 USD en 3 jours
4,9 (39 commentaires)
5,6
5,6
Avatar de l'utilisateur
I re-looked at the sheet and have modified my bid accordingly. Thanks ==== Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. I have also worked on advanced VB features like making of ActiveX Exe, ActiveX dlls, OCX, Win32 API, multi-threading etc.. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$750 USD en 7 jours
4,9 (53 commentaires)
5,5
5,5
Avatar de l'utilisateur
!!Hello Sir/Madam, Ready to start. I read your description carefully and understand all your requirements. I have 4 years experience in this field. You can found my work USA Web Search Data Proof : - Company Name, Address, Email Id, Phone" Please open message board for further details. Regards Arman
$750 USD en 30 jours
4,7 (110 commentaires)
5,5
5,5
Avatar de l'utilisateur
Hello, your budget is unnecessary high for this. I already wrote formulas for this, with some listboxes for choice (type of work). You can check my past projects and reviews for your reference. If you're interested, my real bid for this would be ~50$. We can discuss it further, if (for some reason) we (all bidders) have misunderstand something, but from what I've seen, all can be done easily so budget is to high. On output sheet I would like to place list box for work type selection, you'll then manually insert date for search (or with * for whole month), and formulas would count numbers for specific time... Looking forward hearing from you, and discussing this further.
$750 USD en 0 jour
5,0 (30 commentaires)
4,7
4,7
Avatar de l'utilisateur
Experienced and accomplished academic writer at your service. Please contact for quality and result oriented services. Regards
$789 USD en 7 jours
5,0 (12 commentaires)
4,2
4,2
Avatar de l'utilisateur
Hi, 1) There are TOTAL "1137" reports. So, If we take this example sheet - program will be able to generate "1137" reports. 2)User can configure the Start Row and End Row to generate reports. For ex. START_ROW:100 TO END_ROW: 250, will generate the reports starts from ROW 101 to 251(ADDED ONE BECAUSE OF HEADER). DOUBTS: 1) You Mentioned: I need to generate a report from the Sample Data that sets out the sum of the characters by day within 4 different time periods 0000 - 0600, 0600 - 1200, 1200 - 1800 and 1800 - 0000 by work type. What do you mean by the above mentioned lines. Do you want to generate REPORT in 4 time intervals automatically ? 2)What naming convention will be used for the generated report ? 3) Do you have Report Template or do I need to design ? Do you need report generated in PDF format ? Thanks Sumit SaS Technologies
$750 USD en 7 jours
4,9 (13 commentaires)
4,2
4,2
Avatar de l'utilisateur
I have completed similar assignments already. I would like to send you an example but you made this a "restricted" project I can't send an attachment unless you send me a Private Message first. If you send me a message I will attach the sample using your figures attached to the project to let you judge my skill for yourself, I designed dashboards, reports and spreadsheets and managed databases for twenty years at a leading multinational. Now work from home in the UK across five freelance sites, with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting. Happy to work under a Confidentiality and Non-Disclosure Agreement if required, and will start as soon as you pay the Milestone into the site and send me your existing material. Hope you find this of interest and look forward to hearing from you Bob Allen-Turl
$750 USD en 3 jours
4,6 (12 commentaires)
4,6
4,6
Avatar de l'utilisateur
Hello, I can develop the VBA program to get the required output form excel as per your requirement. I am ready to discuss further and show you demo before you hire me I can start this project immediately. Regards Nikhil
$1 237 USD en 10 jours
4,9 (18 commentaires)
3,8
3,8
Avatar de l'utilisateur
Hello, I can do this for you with a macro VBA, but I assume that you'll have a different Sample Data file generated each time and that's why I think it's better to create a small application that will generate Sample Output from the sample data file that you'll select. Tell me what method suits your needs and also which version of Excel you use. Best Regards, Constantin Plaiasu
$750 USD en 10 jours
5,0 (14 commentaires)
3,6
3,6
Avatar de l'utilisateur
Hi I would like to speak to you.. I think you over priced a simple task... If I'm not wrong I could build you a VBA script for around 300 USD to meet your specifications... I'm a 12 year experienced VBA developer... please visit my profile and have a look of what other employers are saying about me... thanks for considering my proposal.
$750 USD en 3 jours
5,0 (4 commentaires)
3,6
3,6

À propos du client

Drapeau de UNITED STATES
Newtown Square, United States
4,8
13
Méthode de paiement vérifiée
Membre depuis nov. 11, 2010

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.