Create TimeSheet Report From CSV File

$30-100 USD

Σε Εξέλιξη

Αναρτήθηκε

περίπου 10 χρόνια πριν

$30-100 USD

Πληρωμή κατά την παράδοση

Create timesheet report that uses data from csv file and create reports for each name in the report. Source will include 15-20 columns of data, not all columns will be used. Source file will be a csv file imported into Excel and then a customized version of the timesheet is created with all the clock ins and outs on the report. Multpage with multiple names. See attached sample file with fields needed on the report. [login to view URL] is the what the report format should look like. [login to view URL] - sample source file [login to view URL] - sample of report, but only used as reference. The hours will have to be calculated to show overtime, i.e. hours over 8 and DT hours of 12, but these should be variables that can be changed. Attached find a sample report. The template should be easy to change in Excel so that when the next batch if data is imported it automatically is imported and formatted. The process should be straight forward, i.e. open file, select source and run, report is saved to new file.

Excel

Visual Basic

Visual Basic for Apps

Ταυτότητα εργασίας: 5428391

Σχετικά με την εργασία

31 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 10 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@Baxter2008

Hello Victorcab I am an Excel VBA developer. Your detailed specifications are great and clearly spell out what you need. I can build a macro solution to import and reformat the data for you for delivery within a day or two. I do object - oriented VBA for maintainability and can also parameterize items like normal work day, overtime and double - time work hours. I'm proposing a three-click solution from opening file browser, selecting input file to process, through generating the report and then prompting for "Save as" filename to write the output file to. Please contact me to discuss further. Best regarfs, Brent

$55 USD σε 3 ημέρες

4,9

(27 αξιολογήσεις)

4,2

31 freelancers δίνουν μια μέση προσφορά $77 USD για αυτή τη δουλειά

@Khurramz

Hi! I have created a similar sheet that works in the following way: 1. Enter time in & time out 2. Enter the project reference OUTPUT: 1. Salary Sheet 2. Project wise cost of labor 3. Payslips 4. Salary transfer letter for bank I am sure I can do this sheet in an excellent manner. Please let me know if you have any questions. Thanks, Khurram Zubair

$35 USD σε 2 ημέρες

5,0

(406 αξιολογήσεις)

7,9

@zExcel

Hi, I will be happy to help you with this project. Please feel free to message me prior to accepting my bid

$66 USD σε 1 ημέρα

4,9

(260 αξιολογήσεις)

7,7

@Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that I can start with the implementation.

$80 USD σε 0 ημέρα

4,9

(339 αξιολογήσεις)

7,8

@deepbluetech

Hi victorcab, I specialize in Excel macro based projects. Would be happy to work on your Timesheet report project. The last successfully completed project of mine was a complex Timesheet based project with numerous reports, which in addition to overtime included graphs, average work time by person, average work time by category, weekly analysis, etc. The calculation were more specific in minutes (1440 minutes for each day). Let me know and provide the csv/pdf files you have mentioned in the description. Regards, Arul

$100 USD σε 2 ημέρες

5,0

(220 αξιολογήσεις)

7,4

@maverick44000

Hi Victor. I can make this Excel sheet for you using VBA macro. Kindly share the file which you forgot to attach. I can get to work right away. Regards. Usman.

$90 USD σε 2 ημέρες

5,0

(95 αξιολογήσεις)

7,1

@caabdul

Greatings! Sir, Kindly provide me files through message from inbox page. Thank you

$69 USD σε 3 ημέρες

4,9

(53 αξιολογήσεις)

6,2

@dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.

$66 USD σε 2 ημέρες

4,9

(122 αξιολογήσεις)

6,3

@expertatwork

hey Victor ! are you using WINDOWS or MAC ? we cannot see the attached files. Can you please reply with them ? thanks !

$30 USD σε 2 ημέρες

4,8

(207 αξιολογήσεις)

6,1

@LearningNew

can u show the sample file please.................................................................................................................

$30 USD σε 3 ημέρες

4,9

(22 αξιολογήσεις)

5,3

@drevak

*************************************** Consider it done....done professionally ***********************

$80 USD σε 3 ημέρες

5,0

(14 αξιολογήσεις)

4,9

@adim

Hello there, I'm a software engineer with more than 15 years experience in Excel, Access, VBA, VB6, .NET, SQL. During our contract I will be available via Skype/Gtalk, email and via site message center. All of these messages are forwarded to my cell phone so you can rest assured communication will not be a problem. Bugs fixing and minor changes are included in the bid without any additional fees. Best regards, Adrian P.S. You forgot to attach the files!

$100 USD σε 3 ημέρες

4,9

(18 αξιολογήσεις)

4,8

@excel4engineers

Although I can't find the attachments but it makes a sense. I will provide you VBA macro script under windows excel which ill be able to process any size of csv files with any number of workers and variable overtime with one click.

$45 USD σε 1 ημέρα

4,9

(23 αξιολογήσεις)

4,2

@dank111

Hi, I have worked with a MNC where I have done this type of report through csv import for timesheets from CRM. I can be of help. Pls message me so that we can discuss further. I am available to start your project immediately.

$70 USD σε 3 ημέρες

4,9

(10 αξιολογήσεις)

4,3

@scsBiswas

I'm interested.. can we talk? .

$72 USD σε 3 ημέρες

5,0

(17 αξιολογήσεις)

4,4

@kchg

A proposal has not yet been provided

$93 USD σε 3 ημέρες

5,0

(1 αξιολόγηση)

3,4

@Jamesdmartin

Hello Victor! I've created a timesheet in Excel before (take a look at my profile to find a link to my LinkedIn Profile) so I know what you need. I wasn't able to see any of the attachments, maybe I will after I bid, but I do have a question. You said you wanted a multipage report, would that be one for each person. Would it be Ok to have one report where you can select a person and see all of their hours? Or do the reports need to be sent out to individuals (ie: you DO NOT want anyone else to see another's timesheet). Thanks!

$88 USD σε 3 ημέρες

5,0

(4 αξιολογήσεις)

3,4

@seanmdale

Hi victorcab, I am a professional consultant with CIMA training and a breadth of experience in Microsoft Office products specialising in data manipulation and the presentation of business intelligence or management information. I have the technical capabilities and commercial understanding to bring your requirements to life. I would be very interested in discussing your project further and establish a plan of action to meet your needs. I look forward to hearing from you. Kind regards, SMD.

$50 USD σε 1 ημέρα

4,5

(7 αξιολογήσεις)

3,3

@mrg678

Hi! I found no files attached to clearly define the parameters of this job. How many rows/page, how many pages/file and how many files have to be processed. I am prepared to prepare a sample for you to prove that I can do the job efficiently. I will finalize the bid amount when I shall submit the sample conversion. Thanks for reading my proposal. Vicente

$72 USD σε 3 ημέρες

0,0

(0 αξιολογήσεις)

0,0

@cpering

I have a considerable amount of experience dealing with Microsoft Excel spreadsheets, especially pertaining to calculating hours for employees. I am able to create this report in a way that will allow the thresholds for Overtime and Double-Time calculations to be changed easily. I am also able to separate these employee, or by day, depending on what you require. I am flexible on the method by which this accomplished. Ideally, I would use VBA to allow the user to select the target CSV file and then parse the data, sending it to a new workbook. This could also be done in a Macro-Enabled Workbook which would create standard Excel workbooks. Or, this could also be accomplished using a Macro-Enabled Template. If you would like any additional information you can contact me via email. Thank you,

$61 USD σε 2 ημέρες