Get a Freelance Job

I have VSTO ultimate and Excel 10, I want to do an Add-in for Excel in VB.NET

I am a VBA developer and I want to learn VB.NET, so I need a step by step guide to build my first Excel Add-in

I need a document with the explanation of the steps required to create the Add-in (example: creates a new project, add references, etc.)and source code, it must work on Excel 2007 and win 32/64 bit and must be redistributable, will load the first time and will remain in the add-ons.

Step 1) when it will be loaded, will create a new tab (name Black) in the Ribbon (img 1) and a new group (img 2) whit button called Black second.

Step 2)when the button (Black second) is clicked will create a new worksheet Data (img 5) as the image 3, without comments (numbers ending in column B to 30000). Now the user fills in the columns (img 4).

Step 3)when the button in worksheet Data (Button 1)is clicked will create a new worksheet “-” (img 6). Here I need to translate all the formulas in VB.NET .In this way, I see only the numbers and not formulas in cells.The value of these cells (labels:num,peri,signal) should remain variable.

Step 4)build Add-in

In sheets, to explain myself better, I put the formulas with and without labels, I do not need any comments in Excel, but I want the commented code.

See the Add-in.zip file and ask me for any questions.

Should be a pretty straight forward job and should not take longer than an hour.
Needs to be done by Sunday,afternoon(pst)
{Thus, I am not going to have time to ask question about pricing. Give me one low price. I will pick programmer in the morning, about 12 hours.)

Detailed information is in the pdf,
but in short–
User enter product numbers–eg. 5225-5222
Take information from one excel sheet and put in to a New excel sheet. Rename xls as: Template to Date_Amazon_Upload.xls, eg. 01_01_2011_Amazon_Upload.xls.

I prefer this to be done with C# or Excel(VB)

Below are 3 attachment–The PDF, Front End Program–Describing Project, and 2 XLS files–1st is Data, Master_Product_List.xls
2nd is Template, Amazon_Template_File.xls

I had one programmer do the work for me one time before this and he gave me a bad review. I just want to let everyone know who read the one bad review that I got that I paid the programmer accordingly. He did not give me the correct final project like I asked. Now that I explained that, I will make sure that we both know what is expected and I will pay the total amount that is agreed upon. If you have any questions or need additional information, please let me know. Thank you.

This project is to convert a Golf Worksheet into a working PHP Script for an html page.

Our company requires detail oriented individuals familiar with Excel and internet use.Job description to include mining specific data from online resource and transfer of this data to Excel worksheet via numeric and alpha data entry.Excel worksheet will be supplied with detailed instructions on specific data needed and how it should be entered. Some variation will exist within source data, so careful attention must be paid to ensure accurate transfer of this data to worksheet.

http://snipurl.com/27y7kj

Hello,

I have created a series of forms (worksheet) using Acrobat X. The actual worksheet works well, the issue I am having is sharing it with other computers or macs. The worksheet is designed to be a central place for information, it is a 4 page worksheet that can be divided into 3 sections; Merchant Agreement, Order Form, and Commission.

The purpose of this form was for me to enter the information in one form, extract the sections and post them in a gmail calendar or dropbox for other to access. I only wanted certain people to see certain forms. While this works fine, the challenge is that depending on how I save the form affects what others can do with the worksheet/extracted form.

Some of the functionality needed is that people can enter information in the form, add and download attachments and save the form. Ideally I would like that the worksheet/ extracted forms all saved have a button on them that will allow a user to save the information and it would save to one master form. As well the way it would save is key, meaning the form would save using information from different fields ie deal #, Merchant Name, and Date – (YYC1000

1 Scheduling workbook needs

Hello,

I need several ebook/cd/worksheet covers done for various products that I have.

I’ve attached a sample of the style that I like. Please send me samples of your work and your best quote. Submittals without quotes and samples will not be considered.

Thanks

I need some a budgeting worksheet added to my wordpress blog. Budgeting sheet should be written in PHP/JavaScript/MySQL and can simply be link off my main page.

Budgeting Worksheet

***Please bid if you are available as soon as possible and can complete this within the next 2 hours. Thanks.***

I would like assistance in developing a Google Spreadsheet that on 1 worksheet lists names and credits for each individual and on another worksheet only lists the individuals from the first worksheet (in alphabetical order) that has 3 or more credits. There should be a way to update sheet 2 as changes are made to sheet 1.

Sheet 1 will be all manual. We will manually input the total # of credits for each person.

Sheet 2, will need to pull the names from sheet 1 but only the names and the account # (which will be in a column beside the name on sheet 1) of those that we have entered 3 or more credits for. As sheet 1 changes, sheet 2 should update automatically or there should be an easy way to run a script or something in the Google Doc to update Sheet 2.

This tutorial may help, http://www.google.com/google-d-s/scripts/writing_spreadsheet_data.html

***Please bid if you are available as soon as possible and can complete this within the next 2 hours. Thanks.***

I would like assistance in developing a Google Spreadsheet that on 1 worksheet lists names and credits for each individual and on another worksheet only lists the individuals from the first worksheet (in alphabetical order) that has 3 or more credits. There should be a way to update sheet 2 if changes are made to sheet 1.

Sheet 1 will be all manual. We will manually input the total # of credits for each person.

Sheet 2, will need to pull the names from sheet 1 but only the names and the account # (which will be in a column beside the name on sheet 1) of those that we have entered 3 or more credits for. As sheet 1 changes, sheet 2 should update automatically or there should be an easy way to run a script or something in the Google Doc to update Sheet 2.

This tutorial may help, http://www.google.com/google-d-s/scripts/writing_spreadsheet_data.html

Please bid if you are available as soon as possible and can complete this today. Thanks.

I would like assistance in developing a Google Spreadsheet that on 1 worksheet lists names and credits for each individual and on another worksheet only lists the individuals from the first worksheet (in alphabetical order) that has 3 or more credits.

Please bid if you are available as soon as possible and can complete this today. Thanks.

I’d like an Excel spreadsheet coded that uses the ebay API to extract details of auctions in progress using set criteria.

I’d like to be able to store multiple searches in a single worksheet (1 search per line) with each search to include the following variables

1) Search Title (User Defined Value)
2) Category (inc Child Categories)
3) Keywords
4) Expected Sale Price (This isn’t an ebay value)

I’d like to be able to store all my keyword exclusions in a single worksheet (1 exclusion per line)

I’d like the search results to be in a single worksheet consisting of the results of all the searches added to the search worksheet and are to include the following data:

1) Search Title (from Search Worksheet)
2) Auction Reference
3) Auction Title
4) Current Bid
5) Postage Costs
6) Total Costs (Consisting of Current Bid and Postage Cost value added together)
7) Expected Profit (calculation based on “Expected Sale Price” in the search worksheet, less the “Total Costs” value in the search results

I’d also like the following filters to be applied to the search results

1) If the auction title includes a value from the Keyword Exclusions worksheet, then it is to be excluded
2) If the Expected Profit figure is < 1 then it is to be excluded
3) If the time to the end of the auction is > 24 hours, then it is to be excluded.

Please only bid if you have experience of working with the Ebay API and VBA

Thanks

I’d like an Excel spreadsheet coded that uses the ebay API to extract details of auctions in progress using set criteria.

I’d like to be able to store multiple searches in a single worksheet (1 search per line) with each search to include the following variables

1) Search Title (User Defined Value)
2) Category (inc Child Categories)
3) Keywords
4) Expected Sale Price (This isn’t an ebay value)

I’d like to be able to store all my keyword exclusions in a single worksheet (1 exclusion per line)

I’d like the search results to be in a single worksheet consisting of the results of all the searches added to the search worksheet and are to include the following data:

1) Search Title (from Search Worksheet)
2) Auction Reference
3) Auction Title
4) Current Bid
5) Postage Costs
6) Total Costs (Consisting of Current Bid and Postage Cost value added together)
7) Expected Profit (calculation based on “Expected Sale Price” in the search worksheet, less the “Total Costs” value in the search results

I’d also like the following filters to be applied to the search results

1) If the auction title includes a value from the Keyword Exclusions worksheet, then it is to be excluded
2) If the Expected Profit figure is < 1 then it is to be excluded
3) If the time to the end of the auction is > 24 hours, then it is to be excluded.

Please only bid if you have experience of working with the Ebay API and VBA

Thanks

Hello friends,
I ve got an excel worksheet,
which has 8 cloums
1.Date (tarih)
2.Number (No)
3.Account (Hesap)
4.Transaction type (

I am developing an specific system for piles motion analysis.
I am not an software expert, so for now I’m working experimentally in a manual way:

1-Using a digital high-speed camera connected in to the USB port of a computer I record a .mov file, saved to a folder on computer;
2- The clip shows always a standard label, whit two black square (I can change its colour format, etc…) targets, moving downward an upward;
3- Using Adobe After Effects, I open the file, manually click the two targets and run the motion tracker routine;
4- Then I manually select the track points coordinates, copy and paste them on a excel worksheet;
5- The worksheet does the final job.

I need a program that, automatically:

a) Detects and opens a new .mov file in the folder;
b) In the first frame detects de centre of the two targets, saving its coordinates (x and y, in pixels);
c) Tracks the targets motion, saving its coordinates, frame by frame;
d) The program results output should be an excel worksheet or CSV file.

Introduction

The requirement is for a set of Microsoft Excel Macros to import data from proxy server log files into a Microsoft Excel Workbook and to produce reports and charts based on the imported data.

The Macros may be written in VBA and the result will be a single .XLS workbook containing the macros which would be triggered by either a hot key or a macro button.

The project will be in two stages. First developing the
Macro(s) to import the raw log file data into an Excel Workbook and secondly developing the Macro(s) to process this imported data to produce a number of charts based on the log file data.

Background

The company’s internal proxy servers produces log files which detail fetch request made by user PCs within the company network to servers on the internet via the proxy server. These proxy log files contain many lines, one for each fetch request. The log files are in plain text and each line contains the following fields prefaced by the identifier then the data and separated by a space. Records are separated by a newline character.

1 id= Proxy Server ID

I need an Excel expert to make a Spreadsheet that will calculate a daily study schedule containing 10-20 things to do per day. The study items on the Schedule are based on formulas that calculate percentages of how much time should be spent on each item.These percentages are user-defined and can be changed. A daily schedule for a 2-3 month period must be generated/created (basically, around 90 daily schedules must be generated with each daily schedule different based on the inputs). For each daily schedule, user inputs must be taken into account, such as shower breaks, breakfast breaks, lunch breaks, workout breaks, dinner breaks, other breaks including simple study breaks that should occur after every few hours of studying. It must also take into account vacation days that the user inputs and be able to calculate the accurate percentages of study time for each item factoring in all these breaks. To make things more complicated, some items should only be done once a week or once every two weeks, and the Schedule must be able to figure out how and when to allocate time for these items in the daily schedules. I have a basic schedule that does this which I will forward to you, but it must be significantly improved or a new better once created, especially to take into account the semi-weekly items.

Details description :
I enclose the spreadsheet I am currently using. In the Study Plans worksheet, I have the formulas for dividing the study time. The study items on the Schedule are based on formulas that calculate percentages of how much time should be spent on each item. These percentages are user-defined and can be changed.

In the “Schedule” worksheet, take a look at the comment in the first row. This is a good example of how someone will give me their schedule, and then I need to plug it into the sheet. In the “Schedule” worksheet, I took this information and created a daily row to calculate how many hours the person could study versus how many hours were for breaks or personal matters. The Print Area on this workbook is what I send to the people as their study schedule. Right now I copy and paste rows until the schedule looks OK. I want something that is automatic. The hardest part for me is trying to fit the criteria in around the breaks, etc. For example, lunch should always be around 12PM. Also, there should be a 15 minute or so break after every 2 hours of studying. I don’t know how to automate the calculation of this and for the spreadsheet to be smart enough to put everything where it belongs.

I only do about 6 days at a time, but I want a daily schedule for a 2-3 month period to be generated/created (basically, around 90 daily schedules must be generated with each daily schedule different based on the inputs). As I explain above, for each daily schedule, user inputs must be taken into account, such as shower breaks, breakfast breaks, lunch breaks, workout breaks, dinner breaks, other breaks including simple study breaks that should occur after every few hours of studying. It must also take into account vacation days that the user inputs and be able to calculate the accurate percentages of study time for each item factoring in all these breaks. To make things more complicated, some items should only be done once a week or once every two weeks, and the Schedule must be able to figure out how and when to allocate time for these items in the daily schedules. Obviously, my basic schedule must be significantly improved or a new better once created, especially to take into account the semi-weekly items.

I hope this is very easy for excel experts. I want to complete this in 1 day once accepted the bid. please excuse if its not possible in one day, Dont waste my time. While bidding say “Complete in 1 day” without Quotation at end of your bid so that i know you have read this project description. Please see the attached file and let me know your idea like how you going to do this.

Happy Bidding.

Thanks
Bala

I have an excel spreadsheet with 15 worksheets that contain a total of 130 fields. Some of the worksheets have field names defined as column headers with data in each of the subsequent rows, and other worksheets that I used ActiveX controls to define each of the fields.

I would like to create 2 additional worksheets to this spreadsheet that would do the following:

Specific Needs: From a folder of an undisclosed # of txt files; Import 3 txt files at a time to a Excel worksheet that have a matching strings “Run#1″, “Run#2″, “Run#3″, etc. while disguarding “Run#” that don’t have all 3 to match. TXT include 2 columns of data each with the number of inputs completely independant of the other txt files.

Then importing the next numerical RUN# to the next worksheet in the workbook while naming the new worksheet the same name as the Run#.

Sample of txt list:To illustrate string inside the file = ” &gt; Run#? ”
Folder Sample:
vt001.txt &gt; Run#1
vt002.txt &gt; Run#3
vt003.txt &gt; Run#4
vt004.txt &gt; Run#5
at001.txt &gt; Run#2
at002.txt &gt; Run#3
at003.txt &gt; Run#4
sa001.txt &gt; Run#1
sa002.txt &gt; Run#2
sa003.txt &gt; Run#3
sa004.txt &gt; Run#4
sa005.txt &gt; Run#5