Em Andamento

Excel Work

Data Processing in Excel.

Notes: MUST be 2010 or above

Must have a fast computer with lots of RAM. These sheets have 300,000 rows

Must know what #N/A and #REF means in Excel.

=================================================================

I've included a Template Excel (processed) excel file. Two tabs, 1 data tab and 1 chart. The formulas should be relatively simple, however, many use #N/A and #REF in their functions.

I have 10 CSV files, where the data needs to be pasted into column 1&2 of the data tab. When I do it, some of the formulas get messed up and the chart series needs to be updated. With the copy/paste with the appropriate shift/ctrl or changing A1 to $A$1 for example,. this should be quick.

I need 10 total excel files produced to match the 10 CSV files based on the template.

=====================================================================

Please open the template before bidding.

Habilidades: Excel

Ver mais: formulas sheets, data excel work sheets, bidding formulas, excelchart, excel csv tab, need match files excel, copy csv excel, excel work processing, csv files processing, excel column copy, copy paste csv data excel, excel paste csv, simple excel template, template formulas, processing csv files, shift work excel, excel template simple, excel template data paste, excel match data paste, csv template excel, csv excel template, match paste data, copy paste work based, file series excel, copy excel template

Acerca do Empregador:
( 32 comentários ) Cincinnati, United States

ID do Projeto: #5106039

Premiar a:

sswijaya

Hi, I know that this problem can happen when we just copy and paste cells referenced by formula in other cells. Let me check with your template and I will let you know the solution. Regards, Susanto Additiona Mais

$25 USD em 1 dia
(19 Avaliações)
4.1

32 freelancers estão ofertando em média $25 para este trabalho

srikartiram

Hi, Excel expert here. I will get this done in a few hours. Thank you P.S : I've Excel 2007. But its quiet enough for this project :) Not sure why you need 2010 :(

$15 USD in 3 dias
(55 Comentários)
5.1
zExcel

Hi, firstyou need to provide the third parameter of the Aggregate function (that parameter appears to have been lost while you were performing some basic actions like cut, insert, etc)

$35 USD em 1 dia
(14 Comentários)
4.4
BrothersTeam

A proposal has not yet been provided

$35 USD in 3 dias
(9 Comentários)
4.2
Edison1983

***I can help you in few mins. I've 1TB Hard Disk, 4 GB DDR3 RAM, Ms Office 2010.********** Good Day!....I'm an Expert in Excel VBA Automation. Having 6+yrs of Exp. Have developed & designed various Excel based pr Mais

$30 USD in 0 dias
(11 Comentários)
3.7
dviruki

Hi, I understand what needs to be done and can do it. I have 12 years of extensive Excel experience and my computer has 8GB of RAM with Office 365 (Excel 2013) installed. Before bidding I actually ran the process for " Mais

$23 USD in 0 dias
(13 Comentários)
3.5
Vagtepes

Hello, I cant do it this because the dates are messed up and I dont know how to fix it but I can tell you the way to do it, on the csv's pick everything on the A cell except for the title and then on data tab choose te Mais

$25 USD em 1 dia
(6 Comentários)
3.3
inoussakabore

Working with VBA is my passion. there is 4 years i work with it. I have automate many process in my institution here.

$24 USD in 3 dias
(2 Comentários)
3.3
Virtualworker50

Respected Sir, It would be pleasure for me to render my services to you for creating data sheet as per attached template column 1 and 2 copy paste with accuracy without any but. I understand your requirement fully. Mais

$30 USD in 0 dias
(6 Comentários)
2.9
Aldo21

Hi, Ive seen the template and the toyota CVS files but I dont get why you use N/A in your formulas instead of "" blank?

$25 USD in 3 dias
(8 Comentários)
2.9
MasterExcel

I am Data Entry ,MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high Mais

$24 USD in 3 dias
(6 Comentários)
2.7
zubairch

Dear Sir, I am advance user of excel 2010, and working on excel projects since 2004. I think your requirement need a macro for automate generate report. I am advance user of excel 2010, and working on excel project Mais

$25 USD in 3 dias
(3 Comentários)
2.1
ROSB13

Hello, I'm interested to help you. My Excel is 2010. I understand you have problems when pasting from csv to excel and also this task requires lots of resources. I have experience in data processing and Excel. Please l Mais

$48 USD in 2 dias
(4 Comentários)
2.1
samin59

Excellent command over MLA, APA, Harvard, Chicago. Can provide services in finance, statistics, marketing, HRM, Economics, excel and all types of essays, assignments and research papers. Copyscape screenshot will Mais

$34 USD in 3 dias
(4 Comentários)
1.7
Ricklnd

I can do it, I have 2 Corei3's and 1 Corei7 both with a pound of RAM I put two days because tomorrow i'll out

$25 USD in 2 dias
(2 Comentários)
1.1
mailsmaity

Ready to work on this.. will deliver project with in time. please assign to me. looking forward to work with you my skype id - [url removed, login to view]

$14 USD in 3 dias
(1 Comentário)
0.6
elkintab

I am a PHP developer, and I've worked with it for many years. I also specialize in Graphic Designing. I have also experience in Website Development and HTML. I am looking to be hired and work on projects involving PHP, Mais

$30 USD in 3 dias
(0 Comentários)
0.0
RustyAUS

Hi, my first bid on a project. Senior analyst, 10+ years experience, often working with data in excess of 200K records. Australian, speak English, happy to Skype / talk if required. I understand REF and NA errors. Mais

$20 USD in 2 dias
(0 Comentários)
0.0
niroshlak4

I can do it fast and perfectly. My typing speed is 40 words per minute. This project I can do it perfectly.

$25 USD in 3 dias
(0 Comentários)
0.0
naveed682

respected, i have a great experience of MS Execel and word and lots of more.... kindly hire me for your project... regards, Naveed682

$10 USD in 3 dias
(0 Comentários)
0.0
smadil997

............... .. .. .......

$13 USD em 1 dia
(0 Comentários)
0.0