Performing basic Excel functions on millions of rows of data

£20-250 GBP

Selesai

Dibuat

hampir 11 tahun yang lalu

£20-250 GBP

Dibayar ketika dikirim

I have a database with four fields: Store ID / Customer Postcode / Order Value / Order Items (in CSV format) I would like to add three fields to this database: I would like to convert Store ID to Store Latitude/Longitude, using a lookup table of store IDs and store lat/long (in CSV). I would like to convert Customer Postcode to Customer Latitude/Longitude, using a lookup table of all UK postcodes and lat/long (in CSV). I would like to calculate the distance between Store Lat/Long and Customer Lat/Long using trigonometry. I would like to be able to see as output the store ID and the max/min I know this can be achieved easily in Excel and I have the capability to do this. However, the number of records in the database preclude using Excel. I am open to any solution.

Data Processing

Database Administration

Microsoft Access

SQL

ID Proyek: 4715207

Tentang proyek

45 proposal

Proyek remot

Aktif 11 tahun yang lalu

Ingin menghasilkan uang?

Alamat email

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda

Dapatkan bayaran atas pekerjaan Anda

Uraikan proposal Anda

Gratis mendaftar dan menawar pekerjaan

Diberikan kepada:

@nathanlebel

Good morning. I have 15 years of Access and Excel experience and can get this done for you today. Please check your PMB. Thanks for the consideration. Best Regards.

£30 GBP dalam 1 hari

5,0

(4 ulasan)

3,3

45 freelancer menawar dengan rata-rata £142 GBP untuk pekerjaan ini

@e3d

Hello, I'm an expert in data processing. Kindly check your PM

£60 GBP dalam 3 hari

5,0

(229 ulasan)

8,7

@fabest

Dear, I am Access/VBA automation Expert since 11years. I can build Access tool with your data, and generate LAT/LONG, calculate distance etc... It's very easy for me since I am developper in Big Telecom company, I am used to. I am available right now. I will be available after development, as support. Regards, Fabrice

£98 GBP dalam 1 hari

4,8

(86 ulasan)

7,3

@sswijaya

Hi please let me help you with this.

£70 GBP dalam 2 hari

5,0

(50 ulasan)

6,5

@feninsoftech

HI, This will be achieved by importing all data in SQL Server database and then applying look-up in database. I have 8.5 years experience in SQL Server, C# and ASP.NET.

£222 GBP dalam 5 hari

4,9

(49 ulasan)

6,8

@maverick44000

Hi nj. It can be easily done in MS Access. You shall have the results in 1 day. Looking to read from you. Regards

£55 GBP dalam 1 hari

5,0

(29 ulasan)

5,8

@binaryromel

##### Excel expert here! Please check PM. #####

£88 GBP dalam 2 hari

4,8

(68 ulasan)

5,7

@NourElDeen

Dear Sir, I'd like to help. Thanks, NourElDeen

£100 GBP dalam 1 hari

5,0

(72 ulasan)

5,7

@mneo

Hi, Please have a look at your PMB.

£84 GBP dalam 1 hari

5,0

(6 ulasan)

5,0

@AliSafder

Hi, I can export csv to sql server and then do the look up for you... its really easy. let me do it.

£110 GBP dalam 3 hari

5,0

(39 ulasan)

5,1

@tuhindo82

Dear I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. I have vast experience in IT / Data Entry / Web Research /Admin / SEO / Content upload for eCommerce and Marketing. Understanding how valuable an education is, I am serving Pacific Pharmaceuticals Limited as a Sr. Executive (MIS), toward earning my Masters of Business Administration (MBA) degree and B. Sc Computer Science. I have completed many web research/data entry/ General Admin and marketing project. I am 100% able to do your project. Sincerely, Tarikul Islam

£250 GBP dalam 24 hari

5,0

(6 ulasan)

4,7

@gshiels

Hi njbell - please see PM

£257 GBP dalam 3 hari

5,0

(6 ulasan)

4,8

@elboukharimu

Hi, I can help you, please check your Inbox.

£166 GBP dalam 3 hari

4,3

(37 ulasan)

5,5

@pkcyber

Hi, I will give u an application which will allow u select two input files and on clicking on output button it will give u output file in the format u advise in project description. You can use this application even in future yourself. In PMB i have sent u some demo links of my projects

£100 GBP dalam 3 hari

5,0

(16 ulasan)

5,0

@idleswell

Hello, My proposal details are in the PMB. A IDLER

£230 GBP dalam 7 hari

5,0

(10 ulasan)

4,3

@russel02cuet

Thank you Nicholas, for your clear project description. My proposal is to develop an application that read all data from excel files and apply the rules. Ofcourse the look up table will be stored in a table and perform as ruls for outcomes and distance calculation. Thanks -Rus

£210 GBP dalam 5 hari

4,8

(27 ulasan)

4,4

@mkhall

I believe I have a way of accomplishing this. Please see my PM for details.

£150 GBP dalam 5 hari

5,0

(1 ulasan)

4,4

@decato0110

hi, i'm excel expert.. i can do this well, thanks, tristan

£150 GBP dalam 3 hari

5,0

(8 ulasan)

3,7

@Pharoa

Very strong excel and software development skills. I propose a System that uses Ms Access.

£150 GBP dalam 3 hari

5,0

(1 ulasan)

3,7

@cheungkc

Use sequential read and write to handle large number of rows

£150 GBP dalam 3 hari

5,0

(6 ulasan)

3,1

@mirabueno319

I can do this for you.. I am proficient in Microsoft Excel. I have experience in sorting through huge volumes of data. One project I did was to sort through 80K entries and delete duplicates. Another one was for 3 files with 180K entries. I used different formulae and styles within excel to do this. Please award me this project.

£120 GBP dalam 3 hari