Posts Tagged spreadsheet

Convert 532 Spreadsheets Into One

I have 525 individual spreadsheets that I would like combine into one spreadsheet.

Most of the individual spreadsheets have identical structure however some have slightly different structures as the reporting methodology changed part way therough our project or users did not provide data for all sections.

I require someone with the Excell skills and/or data entry patience to combine all data into one spreadsheet (example outcome attached plus one of the individual spreadsheets).

Questions welcome

I would like this work completed within 3 days.

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

Research Project

I need somebody to do a fairly small research project. You will be experienced and able to complete the task within the next 7 days.

I need a list of UK Journalists to be produced that have written on a specific topic.

The spreadsheet will need –

Name,
publications their work has been published in
their status (staff writer or freelance)
position (editor, tech correspondent, etc)
twitter handle
email
phone (not essential, but handy)
link1 (link to at least one recently published, relevant article)
link2
link3

I can supply an initial spreadsheet with a bunch of contacts already included, and I can supply details of where to find more if needed – I need you to quote for finding 100 fresh contacts to include on the list I already have..

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: , , , , , , , , , , , , , , , ,

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: , , , , , , , , , , , , , , , ,

RAILS3 Developer

Hi,

Project: multilingual web search application
Task1
To write MVC code for a multi-model form with javascript (framework) for embedded models.
Based on e.g. formtastic, accepts_nested_attributes_for,
Task2
To extend above form to allow for batch entry of same multi-model objects via table/spreadsheet like form (a la MS Access) or spreadsheet upload

Please contact for more details!

Rails 3
MAC/LINUX
Github
Deployed to heroku

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

Updated Product Colors In Excel Spreadsheet

Bidder will update colors for about 100 products, by checking wholesale website and finding the product in an excel spreadsheet of our products. Each product has around 10-30 colors to be typed in.
For example 22MB – Champagne w/Gold Hi-Light

Each has to be added twice, with a different category number. Project should take about 10 hours.

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

Monthly Rollover

I want to enhance an existing spreadsheet to allow some automation. Imagine can achieve these by getting some macros written:
1. a monthly rollover of key closing balances to opening balances in next months spreadsheet
2. automatically at month end transfer summary of the months data onto a table of key data so that it is available for later months. e.g. In Feb spreadsheet show Jan data as history. In Mar sheet show Jan and Feb data as history. (Summarised)
3. after the finalisation of the months spreadsheet create 4 seperate spreadsheets that show 4 individual companies data. Anticipate may have to make data values only as otherwise spreadsheet formulas may not work.

Tags: , , , , , ,

Search Web For Contact Details & Format Existing Spreadsheet

I have a couple of databases that are not yet finished and are not formatted correctly.

I need somebody who can do the following:

A.) format the excel spreadsheet so that it is all done in a correct and uniform manner
B.) remove any duplicate entries
C.) web search and find the phone number and any contact details for the listings (roughly 500 odd)

I will need someone who can speak English fluently and will be able to use Google to search for contact details for the companies on the list. You will be searching for Australian companies, so you will be using australian sites.

Tags: , , , , , ,

Excel Macro To Compute Some Averages And Draw Charts

Hello,

I need a very good Excel Macro writer to:

loop through a csv file and separate data by account number
once its done separate first time orders from the rest (basically the first occurence of an order number on the spreadsheet(
once the first time orders are identified put a flag (1 or 0 or Y or N) in a column

From there i would like to create a one spreadsheet summary for each account.

The spreadsheet summary will have some averages as well as a couple of graphs.

I need this project completed very quickly so do not bid on it if you dont have time to work on it right away.

(Max bid $50)

Thanks

Tags: , , , , , ,

Products Adding, Excel Spreadsheet

I have a website done already, i just need someone to insert all the product for me, and create a excel spreadsheet for products uploading.

Tags: , , , ,

Simple Website To Spreadsheet Data Entry Job

This is a very simple website to spreadsheet data entry job.

Ill give you a website which you will visit every day and fill in 5 fields on a Google Spreadsheet.
It will probably take you less or about 1 hour a day.

Data MUST BE ACCURATE, and the TASK MUST BE FINISHED DAILY. You will be filling in
1. Business Name
2. City
3. Telephone number
4. Website
All this will be available on the website ill give you.

Ill try you out for a short period of time, if the work is good, you will be hired on an on-going long term basis.

Bid for 15 days work, about 1 hour a day (or less). Ill pay you on the 15th day, and will check your daily progress (the data changes daily).

Tags: , , , , , ,

Simple Website To Spreadsheet Data Entry Job

This is a very simple website to spreadsheet data entry job.

Ill give you a website which you will visit every day and fill in 5 fields on a Google Spreadsheet.
It will probably take you less or about 1 hour a day.

Data MUST BE ACCURATE, and the TASK MUST BE FINISHED DAILY. You will be filling in
1. Business Name
2. City
3. Telephone number
4. Website
All this will be available on the website ill give you.

Ill try you out for a short period of time, if the work is good, you will be hired on an on-going long term basis.

Bid for 15 days work, about 1 hour a day (or less). Ill pay you on the 15th day, and will check your daily progress (the data changes daily).

Tags: , , , , , ,

Internet Research And Data Entry Required

Search the web and compile an excel spreadsheet with all real estate agents names and email addresses in south east queensland. Excel spreadsheet columns to be "email address" , "First name" ,"Last name".
List to exclude Ray White Real estate agents and Harcourts real estate agents.

Tags: , , , , , ,

Iphone App For Accounting

I would like to take a simple excel spreadsheet and incoorporate it to use as an iphone app. It is industry specific to my needs to help me track dates and figures. I would also like space available for advertising.

I would also like a faciltiy within the app to take photographs(scan) of documents as evidence and also import files such as jpg, word, excel.

Spreadsheet is designed and ready to go.

I would like proof of previous work/jobs before accepting winning bid.

Thank you.

Tags: , , , ,

Excel Spreadsheet To Phone App

I have a speadsheet with three tabs write now. The first captures the data entry of 6 fields. The rest displays the analysis of the data. Id like an estimate as to the cost to convert to iPhone/iPad/Balackberry and Android app,

Tags: , , , , ,

Data Entry

Hi I am looking for someone input email addresses into an Microsoft excel spreadsheet.

I will supply the document in which the data will be taken from.

There seems to be about 300 or so email addresses that must be inputted.

The ideal person will have to correctly input all the email addresses accurately into this spreadsheet.

More ongoing work will be available for selected person.

Thank You

Tags: , , , , , ,

Data Scrape Live Football Scores To Excel Spreadsheet

I want a way to scrape live football scores from
http://soccernet.espn.go.com/scores?cc=5739 in to an excel spreadsheet, therefore the Excel spreadsheet in effect becomes a live football score centre. I need the this to be running on a local copy of Excel running locally on my computer, this is critical.

I want it to scrape:

The current live score
The current time in the game
The half time score
Any yellow cards
Any red cards

I need the score to automatically update every 30 – 60 seconds, this time interval I should be able to set via a field on the spreadsheet.

Once this is done there will be more work adding extra features.

PLEASE ONLY REPLY IF YOU CAN DO IT AS I HAVE BEEN LET DOWN TWICE ALREADY

Tags: , , , , , ,

Myspace Mobsters Spreadsheet Site Upgrade

Warlists.com is in need of of some minor upgrades.

The spreadsheet itself:
* Needs at least 2 design options, "Add Train" style and standard Spreadsheet
* Needs to calculate "Total Stats" including (but not limited to):
– Total Targets
– Total bounty amount (of all targets)
– Total cash spent via Mass Murder (Both for the user logged in & in totality)
– Total kills, fights won/lost, any other changes in stats
+ Individual reporting for each target as well as the spreadsheet as a whole
– Average Bounty, Cash & Deaths
* Stats display tool should be redesigned to match the rest of the site.

The Add Train after logging in via javascript and/or form submission needs the following:
* Auto-send friend requests to all members on the add train not currently on the friends list.
* Search friends list & send mob requests as necesary.
* Upgrade login system to include multi-user access, sessions stored in cookies & easy management via Admin Center.

Mass Murder (Auto-Hitlist):
* Needs to be completely redesigned, including an updated login system with form submission and javascript login options.
* Following limits required:
– By level (high & low)
– By bounty (high & low)
– By priority (High, Medium, Low)
– Maximum cash spent
* Check if target is "alive" prior to listing, display message if "dead" or already on the list.

New "Members Only" Features:
* Auto Punch/Attack/Hitlist that will run as long as the page is open in the clients browser (2hr timeout).

Critical:
* Auto-setup via WHMCS (installed, just need an actionhook)
* Must be suPHP complaint

Script should NOT be obfuscated or encrypted in any way.

There is a fully functional DEMO Warlist setup for this project that will function as the sandbox. URI will be given upon request via PMB. You will have FTP and SSH access, root access to the server upon proper justification.

BUDGET IS NEGOTIABLE WITHIN REASON. However, this is NOT a hard project to complete; I could personally code all this in under a week, but do not have the time. So please bid accordingly. If you have any questions, please contact us prior to bidding.

Tags: , , , , , ,

Excel Spreadsheet Build And Integration To MySQL Database

Im in need of some help creating an excel spreadsheet (or something similar) that will have the ability to manipulate data that will be contained in my database (MySQL). The database will contain XML feeds that contain sports statistics.

There will need to be 4 similar spreadsheets created, one for each sport. There might be multiple tabs in each spreadsheet.

I will provide exact details to the winning bidder on specifics (I have a sample spreadsheet that Ive created to show the flow of data and what data Im looking to be able to manipulate). What I need help with is the design of a template that is easy to use, and the writing of formulas to take data from the different sheets and database).

As of now, I do not have the database built, and will not have the xml feeds for a few weeks. I will need a quick turnaround on this project, and will award today to the bidder.

Tags: , , , , , ,

Search Google For Street Addresses And Paste To Spreadsheet

I have an existing spreadsheet of Business contact details. I have all data, except the "Street Address" column

I have SUBURB, CITY columns already.

All I need, is for you to Search Google and fill in just the business "Street Address" column

like:

24 Lincoln Road

No other details needed.

Around 990 "Street addresses" to search on Google, and paste to the spreadsheet.

Tags: , , , , , ,

A Simple Excel / OpenOffice Script

A short Spreadsheet script to draw graphs
==================================
I need a script (to be run on excel and/or OpenOffice) spreadsheet,
The script will create a graph from a given table and will mark high low points (and the distance between the points as a number) on the graph.

The script will get as params the minimum gap to consider and the number of points allowed per interval
A detailed spec with samples will be sent to appropriate Bids.

Project Budget is 30$.

Please Bid only if you know spreadsheet scripting.
Bids that will send samples to former scripts they wrote will be ranked higher.

GoodLuck
YaeLance.

Tags: , , , , , ,

Update Excel Spreadsheet

Meed a project excel sheet updating

Tags: , ,

Data Onto Excel Spreadsheet

We require a person or group of people to fill in data onto an excel spreadsheet approximately 8 columns of data per row. Varying data in each row, eg model number, description, specifications in point form etc. Information is easily obtainable on manufacturer websites.

Tags: , , , ,

Research: Prospective Buyer For Construction Business

I represent the owner of a construction company in the state of Hawaii who has asked me find a buyer for his business. To do so, I need a spreadsheet showing possible buyers from the construction industry. The companies listed should have an annual income of between $70,000,000 and $500,000,000. The information should be provided on a spreadsheet that will allow me to easily sort through the information. The spreadsheet should include the following information:

1. Company information:

Tags: , , , , , ,

Data Entry

Need help to input Name phone, fax and email address of roughly 1975 entires from website into an Excel spreadsheet. Each entry in the website contains four fields (Name, phone, fax and email). You need to enter these 4 fields into an excel spreadsheet in one row with 4 columns. Need to get this back in 3 days. Website will be provided and you need to have Microsoft excel. Lowest bid will be considered (Only bids below $50 will be considered)

Tags: , , , , , ,

Trigger Alerts/emails Off A Financial Spreadsheet

I have an Excel 2010 spreadsheet which is streaming in live market data. I need to be able to send out emails when certain cells hit certain values/rules.

Scope summary

a) Trigger an email (I have an SMTP/POP account) when figures in certain cells hit certain rules or values

b) The email subject header, must be able to have user-defined text, and values in selected cells

c) Timed alert – at a specific time, trigger an email with header of user-defined text and values in certain cells

Tags: , , , , , ,

Create 100 New Facebook And Twitter Accounts

Work on Facebook
1) Create 100 facebook accounts – location of all accounts should be specified as India.
2) Make all 100 accounts as friends to each other.

Work on Twitter
1) Create 100 Twitter accounts.
2) Make all 100 accounts as followers to each other.

Please note:
1) Facebook and Twitter have put lot of security restrictions. I understand this project can take long time to complete successfully. Quote project duration accordingly. If you can create quicker than anybody else, provide full explanation how you can do it.
You should have previous experience, therefore do not apply if you dont have previous experience.
2) Maintain shared spreadsheet on Google Docs to store all Facebook and Twitter User IDs and Passwords. so that i can review progress.
3) Document all other credentials used for ID creation (email ID, its password, Date of Birth, any other detail used during account creation. All these details should be visible on shared spreadsheet)

I am willing to pay $100 upon completion of this project.

Tags: , , , , , ,

Simple Data Entry Job

Simple Data Entry Job:

You need to copy titles and descriptions from a website into a .csv spreadsheet.

Sample spreadsheet is provided.

Should not take longer than an hour.

Tags: , , , ,

Data Scrape Live Football Scores Into Excel Spreadsheet

I want a way to scrape live football scores from
http://www.futbol24.com/Live/ in to an excel spreadsheet, therefore the Excel spreadsheet in effect becomes a live football score centre. I need the this to be running on a local copy of Excel running locally on my computer, this is critical.

I want it to scrape:

The current live score
The current time in the game
The half time score
Any yellow cards
Any red cards

I need the score to automatically update every 30 – 60 seconds, this time interval I should be able to set via a field on the spreadsheet.

Once this is done there will be more work adding extra features.

Tags: , , , , , ,

I Need Emails Matched To A Business List.

Hello Freelancers,

I have total of about 4000 business records in an Excel Spreadsheet
with business name and physical address.
They are from a city in Texas in the US.
I want to find matching emails for these businesses.
I will send you the excel spreadsheet for Email Searching.

You need to find the correct email address and
input it into the provided excel spreadsheet.

I need to finish Total 4000 records within 7 days.

Please only bid if you have good team.
I expect to pay $30 for the 4000 emails.

Tags: , , , , , ,

For Best4best

Using this website, I would like you to populate this spreadsheet with information.

There should be less than 1,500 companies to enter into the spreadsheet.

All the info can be retreived from the site.

I have already started the process to show you what needs to be done (see the attached spreadsheet).

As agreed, I will pay $75 for this work.

Cheers

Gbenga (Oke)

Tags: ,

Need To Extract Data From Email To Google Spreadsheet

I am looking for someone to build either a web based app I can run on my own server that can take data from an email (gmail account) and export it into Google Doc Spreadsheet I have online. The email looks similar to the following. I want certain text from this email to go into the spreadsheet or similar process for lets say email. If I get an email with certain data I want it to be inputed into the Google SpreadSheet online and updated as I get new emails with this data. I just need about 5-6 feilds taken from the email.

*** Must be able to automatically import the data from email into Google Spreadsheet through their API ** I will not accept any other means.

mc_gross: 15.00
protection_eligibility: Ineligible
payer_id:
tax: 0.00
payment_date: 02:29:02 Feb 17, 2011 PST
payment_status: Completed
charset: windows-1252
first_name:
mc_fee: 0.89
notify_version: 3.0
custom:
payer_status: verified
business:
quantity: 1
verify_sign:
txn_id:
payment_type: instant
payer_business_name:
btn_id:
last_name:
payment_fee: 0.89
shipping_discount: 0.00
insurance_amount: 0.00
receiver_id:
txn_type: web_accept
item_name:
discount: 0.00
mc_currency: USD
payment_gross: 15.00

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