Posts Tagged Excel

Write 2 Sentence On Different Posts

Hello,

I have the list of websites. Youll visit each website, open different posts, read them carefully and write 2-3 sentences related to the posts in Excel.

I will pay $0.04 for each post (2 sentences).

Thanks,
Abbas.

04/05/2011 at 12:26 EDT:

Payment will be only after I check the work. (No Milestones)

Tags: , , , , , , , , , , , , , , ,

Excel Macro Conversion To HTML

I am requesting a Macro file that will process an Excel file with a list of events and provide me HTML code for this list with appropriate formatting that I will then place in my online website.

The list of events is approximately 200-300, spread over 3 columns.
Each event row will have to be parsed for Title, Date, Time, Location, and price.

The Macro should parse each event row, reorganize columns based on a predetermined structure, then generate HTML code for the table that can be manually pasted into my website.

Please pm me for sample of the excel file or with any additional questions.

Tags: , , , , , , , , , , , , , , , ,

Database Work. Fill In An Excel Spreadsheet.

We are looking for a person who can check an Scandinavian section of a branch website.
You will have to copy details into an Excel file and put all the different details at the right place.

There are 1049 Life Science companies that need to be listed. You should be able to do at least 10 per hour.
It is not a very difficult job but it is important that all the details will be copied without mistakes.

Although it is a fairly simple job we are looking for someone with a scientific background in Life Sciences because we might also have other Life Science jobs in the future.

If we select you for the job you will receive details about the website and youll receive an Excel template that you can use.

Tags: , , , , , , , , , , , , , , , ,

Need Some Research Done

Hi There
I need few excel sheets populated for some information.
1. I need some info in excel sheet about oscar/Golden globe/BAFTA winner movies and actors
2. I need info about filmfare/IIFA/Screen awards winner actors and movies
3. Need info about various football tournaments arranged day wise for 2011 and annually for next 4 years
4. Need info about various cricket series/tournaments arranged day wise for 2011 and annually for next 4 years
5. Need info about various tennis tournaments weekwise for 2011
6. Need to verify some information about festivals.
7. Need to prepare lists of contacts of advertising agencies, schools colleges and universities, advertising agencies, radios, TVs NGOs and software houses in Pakistan/India.

No escrow. Give us your best price as we will need a lot of work done. Will prefer having a deal on per unit basis.
Regards
Maira Sarfraz

Tags: , , , , , , , , , , , , , , , ,

Financial Control /ekonomistyrning

Financial control ground level

I need some help (if you are swedsih it is a plus, since the cases is in Swedish).

It is three cases

One assignment is about calculation in excel the other one is about budget in excel. The last one is a smaller case for financial control of smaller company, were you should Plan an activity and make a budget for activities for the company (max 5 pages)

It is a easy and fast task for someone that is into financial control.

Tags: , , , , , , , , , , , , , , , ,

Excel Spreadsheet Tool / Script

I need a tool, script, setup of Excell to handle changing all numbers in Column I (PRICE). The resulting number would be a % of Column I (PRICE) plus the original number in Column I (PRICE) . For example, if the original number was 100, and I need the % (to be added to original #) was 30% the resulting calculated figure would be 130.

I need to see a proof that the tool, script etc works.

I will pay best offer on proven work.

The Spreadsheet attached is to be used and the column to be edited is attached.

Thanks, Casey Connors

Tags: , , , , , , , , , , , , , , , ,

VBA Program To Extract Excel Data Ready For Mysql (Repost)

Hi,

Sorry this had been cancelled and reposted due to the incorrect budget being set on the first project.

I have the fun task of getting data which has been entered into Ms Excel spreadsheets over the past 5 years into a mySQL database.

The client uses excel spreadsheets to record customer body measurements as part of a personal training service. There are over 20 spreadsheet files, each with at least 50 sheets of data. The problem is the data is not set in a database friendly format. (see example attachment)

I got the client to enter to the userid into cell A1 on each spreadsheet. I need to get this data either onto another excel spreadsheet or into a CSV file ready to import. Im thinking the best way to do this would be to create a VBA program that grabs data from certain cells and places them sequentially onto database ready lines.

The DB structure for the mysql DB will be (tbl_measurements):
user_id INT(10)
mm_date DATETIME
mm_weight DOUBLE
mm_abdominal DOUBLE
mm_subscapula DOUBLE
mm_bicep DOUBLE
mm_tricep DOUBLE
mm_sum_of_4 DOUBLE
mm_diff_mm DOUBLE
mm_diff_per DOUBLE
mm_history DOUBLE
mm_shoulders DOUBLE
mm_chest_in DOUBLE
mm_chest_ex DOUBLE
mm_bicep_right_un DOUBLE
mm_bicep_right_flex DOUBLE
mm_bicep_left_un DOUBLE
mm_bicep_left_flex DOUBLE
mm_waist DOUBLE
mm_navel DOUBLE
mm_hips DOUBLE
mm_quad_right DOUBLE
mm_quad_left DOUBLE
mm_calve_right DOUBLE
mm_calve_left DOUBLE

So, what I need is a simple VBA program (or similar), that reads in a single excel file, loops though all cells on each sheet, and spits out either a excel file, or CSV file in the correct format. (i.e. ready to import into a mySQL database)

Tags: , , , , , , , , , , , , , , , ,

Directory Project

I need someone to enter my company into online directories. I will provide the company information, but I need you to have a list of directories and create an excel spreadsheet with the link, email, username if necessary and password.

REQUIREMENTS:
– All directories must be US only.
– All directories must show up in a Google SERP.
– I already have my company listed on a few directories and duplication will not be allowed.

Please include your fee per entry in a PM.

Happy Bidding

Tags: , , , , , , , , , , , , , , , ,

Custom MS Excel Formula

I need a custom formula created for MS Excel, compatible with 2007 and newer. This formula will determine total material usage based on the following:

1. Material units are 10 sticks. The returned value will be in number of units.
2. The material is used to build a frame: minimum dimensions is 4 x 4, with no maximum size, using 2 increments.
3. The formula will optimize material usage and use waste as applicable.
4. The formula will factor is waste due to 45 degree cuts at the corners.
5. A joint cannot fall within 4 of the frame corner.

Please let me know of any questions or clarifications.

Thank you

Tags: , , , , , , , , , , , , , , , ,

Update Contents Of Mysql Php Db Using Excel File Provided

Need data in existing and functioning mysql database updated with new data that I will provide as an excel file. Old data is to be completely removed and replaced entirely with the new data in the excel file I will provide. You can see the databased involved at.
http://www.manvillerubber.com/jm_clipper_oil_seals_sizes_prices.php

Tags: , , , , , , , , , , , , , , , ,

Excel To Webform

Have 400 cells in row A with commas after each one

Need to transfer them to web form so that each one is in a row

Ex.) M145541,M451212,M451212 etc…

Can be done via teamviewer if you would like….

Should be easy $30 for less than 10 minutes…

Tags: , , , , , , , , , , , ,

VBA Program To Extract Data From Excel Ready For Mysql

Hi,

I have the fun task of getting data which has been entered into Ms Excel spreadsheets over the past 5 years into a mySQL database.

The client uses excel spreadsheets to record customer body measurements as part of a personal training service. There are over 20 spreadsheet files, each with at least 50 sheets of data. The problem is the data is not set in a database friendly format. (see example attachment)

I got the client to enter to the userid into cell A1 on each spreadsheet. I need to get this data either onto another excel spreadsheet or into a CSV file ready to import. Im thinking the best way to do this would be to create a VBA program that grabs data from certain cells and places them sequentially onto database ready lines.

The DB structure for the mysql DB will be (tbl_measurements):
user_id INT(10)
mm_date DATETIME
mm_weight DOUBLE
mm_abdominal DOUBLE
mm_subscapula DOUBLE
mm_bicep DOUBLE
mm_tricep DOUBLE
mm_sum_of_4 DOUBLE
mm_diff_mm DOUBLE
mm_diff_per DOUBLE
mm_history DOUBLE
mm_shoulders DOUBLE
mm_chest_in DOUBLE
mm_chest_ex DOUBLE
mm_bicep_right_un DOUBLE
mm_bicep_right_flex DOUBLE
mm_bicep_left_un DOUBLE
mm_bicep_left_flex DOUBLE
mm_waist DOUBLE
mm_navel DOUBLE
mm_hips DOUBLE
mm_quad_right DOUBLE
mm_quad_left DOUBLE
mm_calve_right DOUBLE
mm_calve_left DOUBLE

So, what I need is a simple VBA program (or similar), that reads in a single excel file, loops though all cells on each sheet, and spits out either a excel file, or CSV file in the correct format. (i.e. ready to import into a mySQL database)

Tags: , , , , , , , , , , , , , , , ,

Excel Vlookup, Match Or Index Formula

I have two spreadsheets (TestSheet1 and TestSheet2)

I would like TestSheet1 to look over TestSheet2 and add address data next to any matching name.

The solution may be vlookup, match or index formula

I am looking for an Excel expert who can provide the formula to solve this problem and provide it in the test spreadsheets provided.

I would like a solution within a few hours if possible and will select the first suitable bidder

Tags: , , , , , , , , , , , , , , , ,

Excel Programing,purchasing Price Comparison Spreadsheet

I have a restaurant I need a spreadsheet that will allow me me to do my purchases according to the
lowest price bid comparison ,this is how it would work.
1- create purchase order from database
2- import multiple vendor bid prices in excel format for the coming week
3- automatic find cheapest price for items according to purchase order
4-automatic create purchase order per vendor according to cheapest price
5- e-mail automated to winning bid vendors
6-receiving goods, to be able to check mark items when they arrive and make sure the prices
charges on invoice are same as bid.
7-receiving invoice to download on Quickbooks
7- all compatible with pc and ipad

Tags: , , , , , , , , , , , , , , , ,

Private Project For Chartered8

Hello,
We are looking forward for a freelancer who can do research on IT companies globally and input their contact information in pre organised excel sheet. Data base should contain following fields, Name of Company, Generic Email, Phone No, Fax No, Contact form.

Candidate should have good research skills as well as sound knowledge of working on excel sheet.

Thanks
mannubhai2010

Tags: , , , , , , , , , , , , , , , ,

Classified Advertisement Site Html Mock Up – Isellglobal.com

I have a very simple project. I need to get some html mock ups done for a classified site. No back end functionality is required. Just html. This should include necessary graphics and logo.

Im giving the link to the excel where it shows the indication of the UI. note that this is just an indication – this should not be exactly copied to html. The htmls designer should think how better the UI can be then convert it in to the html.

Excel is available @ http://isellglobal.com.

Please provide your sample work. New comers are also welcome as long as they can show the proof that they can do it.

Once you create the first page, you need to share with me the image of it so that I can review before you proceed further. For an html expert this is a very simple task. You may refer to other sites. but do not copy paste. My requirement includes demonstrating the UI with two different css. Details are in the excel.

Here is the complete link.
http://isellglobal.com/docs-review/r8intel-screens.xls

Please understand the screen flow before you design it.

Tags: , , , , , , , , , , , , , , , ,

Excel Expert Needed Asap

I need to compare "order management" list against "netbilling" list Every time you find a file that exist in order management but NO exist in netbilling you highlight in Red as i have already started doing. The you make seperate excel list of only files in red and send to me. Please let me know if you have any questions and thank u for bidding.

Tags: , , , , , , , , , , , , , , , ,

SPSS Model Help

Need to build a suitable model with a given excel data using SPSS software and interpret the model.

Tags: , , , , , , , , , , , , ,

Need Help With Some Excel Document Creation

I am creating some excel workbooks to be used regularly in my business. I have no experience with Excel so we need someone with some hefty experience to help us create the documents we will use in our day to day business and show us how to implement it into our business. This should be simple stuff at first but if I find the right person we will work with them consistently as we expand our operation. Toronto freelancers only please.

Tags: , , , , , , , , , , , , , , ,

Simple Copy Paste Data Entry Job

This is simple copy paste job, I have excel file I just want You to collect some information maybe its 400 contacts maximum I think, deadline is 1 day, and i think its really pretty small and easy job so dont bid higher, Thanks

Regards
Daniel

Tags: , , , , , , , , , , , , , , , ,

Scrap Data From Website To Excel Spreadsheet

I want all data scrap from particular website link, ill give you a link in PMB.

*Website just have COMPANY NAME, ADDRESS, CITY, STATE, ZIP CODE, PHONE NUMBER.

But i want COMPANY NAME, ADDRESS, CITY, STATE, ZIP CODE, PHONE NUMBER, EMAIL ADDRESS, WEBSITE, CONTACT NAME(IF AVAILABLE)

So, for the email address or website, you have to do google search.

At google search..you just enter the company name and you will found the company website, then go to the website and find email address on that.

Note:
I want excel spreadsheet with required field:
COMPANY NAME, ADDRESS, CITY, STATE, ZIP CODE, PHONE NUMBER, EMAIL ADDRESS, WEBSITE, CONTACT NAME(IF AVAILABLE)

I want total of 1000 records within 2 days maximum or asap.

Thanks in advance

Tags: , , , , , , , , , , , , , , , ,

Data Collection And Entry

This project is to have data collected from 2 websites. The work is very simple and there is not a large amount of data.

You will go to the websites that I give you. And fill in the columns in the excel spread sheet with details from each page. The details I am looking for are about 10 fields from each. Name, Url, Details etc.

My budget is $30USD. To prove you have read this put 154TIGO in your message to me. There is about 5hours work total involved.

Tags: , , , , , , , , , , , , , , , ,

Data Entry Clark Need

I have sevarel excel file with various data such as name, address, phone number, email address, company name etc.
Will provide you a database and you have to entry the data from excel file to database. Have to start asap and need to finish within next one week.
http://www.joblist.com

Tags: , , , , , , , , , , , , , , , ,

Excel Expert

you should be an Excel Macro Expert you need to create a sheet for me only experts and ready for test before hiring..

Tags: , , , , , , , , , , , ,

Copy And Paste Excel Data Between Sheets

I need to take the 220 schools from Sheet 1 of the enclosed Excel document and transfer certain information to Sheet 2.

You will see that I have completed the first three lines on Sheet 2 as an example – I would like you to do the rest.

Tags: , , , , , , , , , , , , , ,

Excel Duplicate/vlookup Function

Hi all excel pros,

For in the next couple of hours.
I want to merge data from cells in the 4th column ("fits on").
There are multiple rows.
Merging should occur only if there is a match for product name AND product id AND image no.
If TRUE, values in "fits on" column should be merged into 1 cell, SEPARATED by a comma.
Ideally, the copied rows should then be removed.

product name product ID image no. fits on
headlight A 16 1256 car D
headlight A 16 1256 car C
headlight P 11 1142 car M
headlight P 11 1142 car S

Should become:

product name product ID image no. fits on
headlight A 16 1256 car D, car C
headlight P 11 1142 car M, car S

Maybe some kind of combination of & function, countif and Vlookup???

thansk in advance guys!

Tags: , , , , , , , , , , , , , , , ,

Need To Update Website By Using Php

Hello,
We have a current website that uses php. We have a prooducts that get updated on our website by using an excel spreadsheet, but its not working.

Here is what we need.

1. We list domain names on our site for sale. We would like to update the sold one easily. We used to be able to do it by just updating a excel document but its not working.

This should be a simple task.

Thanks!

Tags: , , , , , , , , , , , , , , ,

Excel Data Entry — Mine "Inc. 5000" Website List

We need to mine this website — http://www.inc.com/inc5000/list — for ALL the companies

How you can do a great job:

1. Click on each company name (ex. Lexicon Consulting #4, WDFA Marketing #5, TheFind #12, etc.)
2. Copy/paste info from each company page into the attached Excel, with all 10 columns we want labeled on attached template (Columns A-J)
3. Email us your completed Excel file, and youre done!

There are a total of 5000 companies on the list (100 pages of 50).

Feel free to ask me any questions, and happy bidding!

Tags: , , , , , , , , , , , , , , , ,

Gathering Email Addresses

Looking for users to acquire email addresses for individuals.

Individuals First Name, Last Name, Address, City, State, Zip, and Birth Date Provided.

Need emails.

Each email found is .05.

Must know how to enter data into excel.

Tags: , , , , , , , , , , , , , , , ,

SEO For Website

Hi,

* Ill provide all articles, press releases, necessary texts.
* You may need to create new account/s. You will have to create all account using one email id and transfer email details to me.
* All submissions should be made on daily basis.
* Youll have to provide a detailed excel file containing daily submission reports. Use one excel file and update that daily and submit a copy to me daily.

I need you to Copy the provided article/press releases/text and paste it to those websites where you have submitted articles/press releases/text in your past work.

Submissions must be done by a human, no automated software. The article must stay on the directory and not be deleted.

You will need to do 30 submissions daily:
Directory submission- 10
Press release submission- 10
Social bookmarking- 10
Total- 30
Total (30×30) =900 submission in a month.
I can pay you every 2nd day for your every 2 days submission.

NO SPAM
MANUAL WORK ONLY!!
WHITE HAT METHOD ONLY!!

In your bid:
Please mention the quote for total 1500 submission.

I will hire in the future if quality job done on this project !!

Tags: , , , , , , , , , , , , , , ,