Create TimeSheet Report From CSV File

$30-100 USD

Em Andamento

Publicado

há aproximadamente 10 anos

$30-100 USD

Pago na 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 do Projeto: 5428391

Sobre o projeto

31 propostas

Projeto remoto

Ativo há 10 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

Concedido 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 em 3 dias

4,9

(27 avaliações)

4,2

31 freelancers estão ofertando em média $77 USD for esse trabalho

@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 em 2 dias

5,0

(406 avaliações)

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 em 1 dia

4,9

(260 avaliações)

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 em 0 dia

4,9

(339 avaliações)

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 em 2 dias

5,0

(220 avaliações)

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 em 2 dias

5,0

(95 avaliações)

7,1

@caabdul

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

$69 USD em 3 dias

4,9

(53 avaliações)

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 em 2 dias

4,9

(122 avaliações)

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 em 2 dias

4,8

(207 avaliações)

6,1

@LearningNew

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

$30 USD em 3 dias

4,9

(22 avaliações)

5,3

@drevak

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

$80 USD em 3 dias

5,0

(14 avaliações)

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 em 3 dias

4,9

(18 avaliações)

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 em 1 dia

4,9

(23 avaliações)

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 em 3 dias

4,9

(10 avaliações)

4,3

@scsBiswas

I'm interested.. can we talk? .

$72 USD em 3 dias

5,0

(17 avaliações)

4,4

@kchg

A proposal has not yet been provided

$93 USD em 3 dias

5,0

(1 avaliação)

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 em 3 dias

5,0

(4 avaliações)

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 em 1 dia

4,5

(7 avaliações)

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 em 3 dias

0,0

(0 avaliações)

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 em 2 dias