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

Vba Jobs

147 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
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