You've landed at the right place. oDesk is now Upwork. Learn about the new platform.

Vba Jobs

144 were found based on your criteria {{ paging.total | number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("hourly") | number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("fixed") | number:0}})
show all
only
only
only
show all
only
only
only
only
only
show all
only
only
only
Looking for the Team App?
Download the New Upwork Team App
Fixed-Price - Entry Level ($) - Est. Budget: $250 - Posted
I have a change log that and a change report. Currently, I update the change report manually. I would like the change report to be populated automatically from the change log. The format of both the change log and report are finished and I don't want to change them (if possible).
Skills: Excel VBA Microsoft Excel
Hourly - Entry Level ($) - Est. Time: More than 6 months, Less than 10 hrs/week - Posted
Statistical time series analysis of energy data with rapdiminer & r We are seeking an expert to build statistical models for time series data in the electric energy industry. We have timeseries data as ¼ h values representing the current energy load that a customer is consuming from the grid. We would like to do advanced statistical analysis of the energy data and represent the outcome oft he analysis in form of a report or web application. The first requirements would be: - Read a CSV timeseries file - Provide a report conatining the following information o Aggregated consumption per month o Aggregated maximum load per month with a timestamp representing the maximum energy load oft he individual month o Aggregations  Aggregated consumption per Month from Mo – Sa 09:00 – 20:00: Total Value and % value from overal consumption  Aggregated consumption from all other times: Total Value and % value from overal consumption o Monthly average of all daily minimum within one month
Skills: Excel VBA Business Analysis Data Analytics IBM SPSS
Fixed-Price - Entry Level ($) - Est. Budget: $35 - Posted
I have 2 spreadsheets that need VBA/macros created. The spreadsheet will have a submit button and when the user clicks submit it will take certain cells on the sheet to create the file name and save the file to a register.
Skills: Excel VBA Microsoft Excel
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
We are working for a steel mill and can produce "any" size in the source plate (within our dimensional program): and I can't seem to find a excel script or program that quite simply finds the size of the optimal plate in the dimensional program when we get a request for plates that we have to cut down and produce combined. Commercial nesting programs all have the stock option: where they have limited options of source plates to choose from, hence I cant find any good commercial alternatives. Normally this is not a large problem, but if the specification is large andunfortunate in dimensions it would be very good to have a way of finding the optimal dimensions of the source plates. Basically: what the software should do is the following (very simple example): Settings (in a excel table that is editable): Thickness: Max Width Max Length 1 100 1000 2 200 2000 3 300 2500 I have a complete table for this http://dansteel.dk/data/files/Pllaengder%20-%202015-01-28.pdf So, I select a series of cells of the same thickness (length - width - thickness) and the program identifies the dimension and number of plates that creates the least amount of scrap (or the one that creates zero scrap). For instance: 9 pcs of 10 x 100 and 2 pcs of 5 x 50 plates would give a result of 1 plate of 100 x 1000. *The settings should have a cell padding option per thickness for all cutts that are inside of the plate. In the finished product i would like to input on the "parts" page: thickness width length pcs padding and then generate (grouped/based on thickness) the optimal sizes to produce, with the consideration that we need a minimum number of each source plate (based on the fact that we prefferably need to produce at least 3800 KG).
Skills: Excel VBA Microsoft Excel
Fixed-Price - Intermediate ($$) - Est. Budget: $50 - Posted
Hi, i need to create a spreadsheet with a Gant chart that auto populates when i enter in some data/constraints. Basically the spreadsheet will consist of rows of retail stores. I must be able to rank the stores, specify the duration they will be running and how many stores can run in a given period. The Gant chart must then auto populate. Please let me know if this is unclear.
Skills: Excel VBA Microsoft Excel
Fixed-Price - Entry Level ($) - Est. Budget: $5 - Posted
I've attached two excel sheets. 'File 1' has some data which needs to be copied to 'File 2'. The format that the data needs to be copies is self explanatory if you have a look at the two files. Looking for an Excel Macro written to the button sitting in side 'File 2' total sheet. Looking for a newbie who are behind good comment. If you deliver, you surely will have it!
Skills: Excel VBA Microsoft Excel
Hourly - Expert ($$$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
We are a DRTV ( Direct Response TV) specialist Company that have offices in Australia and the UK. We have 2 contact centres and we need to some reporting in place taking it from paper based excel reports that are manually filled in to moving into Google apps so we can streamline and automate the whole process. The workflow is 1. contact centre data entries their numbers into google form( matches the attached Daily Call tracking sheet) via link on their chrome browser 2.data goes into master spreadsheet - format already created but needs improvement 3. management 1 page summary created - format already created but needs improvement Ideally once updated I want subscribed people to receive email alert the doc has been updated Additional to this : - Staff database - keep all updated in place - staff roster document- format already created but needs improvement- need to have it so when we update it subscribed team members get the email notification The company has google apps email address , however there are 2 different companies so need to ensure we can share across drives as the reports need to go to . I need it to be simple enough that I can outsource it to a Virtual assistant to do daily if it cannot be completely automated from data entry. Ideal Candidate: - I need someone who has done this before and execute this quickly. - Excellent english is required - You must be able to to coach us and perhaps record a screen cast of the process once complete - you can make suggestions and introduce us to how to get more out of the google apps products and create efficiencies if this is successful then there could be ongoing work as the company currently uses Dropbox for file storage and I am keen to move it across to google apps once we are comfortable we can achieve what we need to as outlined above, Some testimonials would be useful and examples even better. I require a cover letter on why you are the best candidate and your resume . Resumes without cover letters will not be responded to.
Skills: Excel VBA Google Apps Google Docs Microsoft Excel
Looking for the Team App?
Download the New Upwork Team App
Fixed Price Budget - ${{ job.amount.amount | number:0 }} to ${{ job.maxAmount.amount | number:0 }} Fixed-Price - Est. Budget: ${{ job.amount.amount | number:0 }} Open to Suggestion Hourly - Est. Time: {{ [job.duration, job.engagement].join(', ') }} - Posted
Skills: {{ skill.prettyName }}
Looking for the Team App?
Download the New Upwork Team App