Create TimeSheet Report From CSV File

$30-100 USD

En curso

Publicado

hace alrededor de 10 años

$30-100 USD

Pagado a la entrega

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

ID del proyecto: 5428391

Información sobre el proyecto

31 propuestas

Proyecto remoto

Activo hace 10 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@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 en 3 días

4,9

(27 comentarios)

4,2

31 freelancers están ofertando un promedio de $77 USD por este trabajo

@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 en 2 días

5,0

(406 comentarios)

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 en 1 día

4,9

(260 comentarios)

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 en 0 día

4,9

(339 comentarios)

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 en 2 días

5,0

(220 comentarios)

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 en 2 días

5,0

(95 comentarios)

7,1

@caabdul

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

$69 USD en 3 días

4,9

(53 comentarios)

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 en 2 días

4,9

(122 comentarios)

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 en 2 días

4,8

(207 comentarios)

6,1

@LearningNew

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

$30 USD en 3 días

4,9

(22 comentarios)

5,3

@drevak

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

$80 USD en 3 días

5,0

(14 comentarios)

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 en 3 días

4,9

(18 comentarios)

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 en 1 día

4,9

(23 comentarios)

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 en 3 días

4,9

(10 comentarios)

4,3

@scsBiswas

I'm interested.. can we talk? .

$72 USD en 3 días

5,0

(17 comentarios)

4,4

@kchg

A proposal has not yet been provided

$93 USD en 3 días

5,0

(1 comentario)

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 en 3 días

5,0

(4 comentarios)

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 en 1 día

4,5

(7 comentarios)

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 en 3 días

0,0

(0 comentarios)

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 en 2 días