I need a spreadsheet that will calculate the grand total of contracts, then on a seperate line is will deduct a percent complete amount and give a current total. Also need to track timeline for all projects on page 2. These pages will have more than 100 jobs before end of year.
Our company has many spreadsheets with contact information. For each person, their "work city" which is usually a smaller city, needs to be mapped to a large city. I will provide the list of large cities I just need them remapped by how close they are. For example, Riverside, IL would be mapped to Chicago, IL. MUST BE UNITED STATES BASED WORKER.
I need to create a mail merge from Word to fill a form and some smaller spreadsheets from a regular csv created from a project management software report. The output currently needs editing in between with excel to change some formats such as dates into dd/mm/yyyy formats and a time field that comes out as eg 9:00am, 9:20am, 9:40, etc which need to
Have to match up a constantly updating inventory list with a static price list on a regular basis. Would like someone to teach me how via screen share.
We need every day to fill data from Google Spreadsheets to several forms. We provide the data and the forms and a way to check if everything is ok. Every day you will have to report the number of forms filled, errors, etc. Language of the forms will be Spanish, but as is a repetitive task, language is not really a problem.
I currently present and analyse financial data in 16 different spreadsheets, each with between 16 and 19 tabs in different formats and presentation styles. The current sheets have data going back 20 years, but i have purchased additional data going back as far as 1930 which needs to go into the new template formats which have been updated to make the
Manufacturing Biz, need formulas made and spreadsheets reconsiled
I have a few CSV spreadsheets that have information misaligned. I need the spreadsheets fixed so that similar information is found in the same columns (such as name and email address). There are five spreadsheets that need fixing. See the attachments for examples. I need two things done with each. I need full names split into FirstName and LastName
I have two spreadsheets with lists of events. I need someone to check if each event listed in Spreadsheet A is listed in Spreadsheet B or not. If it is, then you need to put the reference from B in a column in A. If not, then you need to make a note saying that it's not there. There are no exact name macthes, as I have already done those via an
I need a simple application building that I can remove duplicates from a excel spreadsheet. I have 3 spreadsheets one is a master spreadsheet contains a list of addresses, I have a further 2 spreadsheets that the master spreadsheet needs comparing with. The master spreadsheet will need the duplicated removing. The system will check the Address and Post
I have two spreadsheets that are output [url removed, login to view] each have a name that changes with each daily output. One sheet includes a column of "file number" and a blank column of "ID", as well as other columns of data. The second sheet includes the same "file number" data, and the "ID" column, with data entered, as well as other columns ...
Hi, I would like you to create two spreadsheets. Both will have two columns: one for name of the company and one with the email. The first spreadsheet will be companies listed on these websites: [url removed, login to view] [url removed, login to view] http://www
TASKS: -Managing email/Excel -Excel purchasing spreadsheet filling with the data I provide -fill out the New Order email template with the info from the spreadsheets -supplier will provide a timeline for when order should be complete, follow up a few days beforehand to get tracking numbers and packing slips, pass this info on to suppliers via
As an early phase, research firm, we seek assistance in converting our current Excel spreadsheets into a more functional relational database. We do not have the time, nor cash-flow, to work with inexperienced software personnel. We will develop a series of milestone with the successful candidate in order to allow us to continue our research, while
need 45 bank statement excel spreadsheets with compiled into 1 spreadsheet that i can sort by transaction type