Data Cleaning Exercise (Semi - Automated/Rule based)

We have a series of excel worksheets whereby vehicle observations are made at a series of locations along a route. A registration number is noted at each observation point along with the time. This registration number is then matched at the analysis stage so we can calculate times taken between two locations. Some observers at the observation points record vehicle registration numbers correctly while others may miss a digit or transpose a digit. We would like a programme that create a new field containing the suggested correct registration based on data already gathered in the database and using a few basic rules we'll briefly discuss.

Kemahiran: Excel, Visual Basic

Lihat lagi: cleaning data exercise, data cleaning outsource reviews, on semi, data analysis with excel, data cleaning using vba, transpose, route, exercise, excel data analysis, excel based, data visual, data point, analysis data excel, excel database visual basic, automated analysis, excel digit, visual basic database excel database, basic programme, data vehicle, exercise database, rule visual basic, data analysis worksheets, vehicle data, visual rules, excel vehicle

Tentang Majikan:
( 40 ulasan ) Co Dublin, Ireland

ID Projek: #389125

Dianugerahkan kepada:


Hi, I am an excel vba expert. I have over 11 years experience. I undersrand your project and can do it easilt Kind regards Nash

$100 USD dalam 0 hari
(17 Ulasan)

6 pekerja bebas membida secara purata $116 untuk pekerjaan ini


Hello,Please refer your [url removed, login to view] you.

$200 USD dalam 3 hari
(76 Ulasan)

that seems funny. I can do that either with an external program that will read the excel file to process it offline and rewrite the new column (with Delphi or Access), or inside excel, with a VBA function that will Lagi

$80 USD dalam 12 hari
(3 Ulasan)

Hi Please refer my PMB Regards

$180 USD dalam 2 hari
(1 Ulasan)

Hello, Please allow me to do this job. Am confident to have a good product.

$55 USD dalam 2 hari
(0 Ulasan)

I am a expert - professional with an experience of 7 years in making website designs, graphic designs, logo designs, flash,OSCommerce, Joomla, DotnetNuke, PHP/Mysql, ASP, ASP.Net, Access, MS SQL Server, .Net, Ajax, CSS Lagi

$80 USD dalam 3 hari
(0 Ulasan)