Write some Software

Closed

High level - I need to be able to parse an excel spreadsheet and pull records that match a range of values.

Details- attached is an example report. Each "record" will span a variable number of rows, based on the number of entries in the "property code" column. Each entry in the "user" column, along with all following rows until the next "user" entry, and extending to the "property codes" column, constitutes a "record". In the example report, the first record is 1 row, while the second record is 24 rows.

I need a solution that will, when given a number range, copy any records that contain a matching property code in the range to a results file. If a record has multiple matching codes it should only be copied once, and the entire record should be copied.

As an example, if given the range 85000-85999, the results file would include the records for rjohnson (1 row) and ebarbezat (156 rows).

It would be beneficial to be able to specify the name of the results file when specifying the number range. If we can provide multiple names/number ranges at once, that would be ideal.

I understand that this is not a standard usage for excel, but the input file format cannot be changed. If you have any questions, please ask prior to bidding. This solution will be tested thoroughly prior to acceptance, so if we can work out any confusion ahead of time that would be greatly preferred.

Skills: Excel, Software Architecture, VB.NET, Visual Basic

See more: software write mq4, software write chip epson, useful software write book, software write web specs, provide list employees names children mysql, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, software write protect software, software write technical manual

Project ID: #12239101

Awarded to:

lkhelladi

hello, I'd be glad to implement the record file parsing tool for you. i suggest using python for this which is a very well known and powerful language for such tasks. Looking forward to chat with you soon for m More

$250 USD in 3 days
(7 Reviews)
3.8

16 freelancers are bidding on average $435 for this job

aarifakhtar

Hi: I have a few questions: In your brief you mentioned that the script should allow you to enter multiple range and a file name. So, I wanted to confirm whether you want a functionality where one set of ranges goes to More

$250 USD in 3 days
(134 Reviews)
6.7
wsh2

Greetings from Easton PA, USA.. {smile} Highly experienced (25+ years) MsEXCEL Business System, Programming, and Database expert with Guru / Mentor level technical credentials at www.experts-exchange.com and www.vbc More

$444 USD in 10 days
(45 Reviews)
6.3
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More

$500 USD in 5 days
(155 Reviews)
6.6
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$500 USD in 5 days
(117 Reviews)
6.3
$527 USD in 10 days
(15 Reviews)
5.5
poduzov

Hi I'm an Excel expert with years of experience and I can develop a VBA macro which would do the job in 12 hours. Best regards, Denis Poduzov

$277 USD in 0 days
(19 Reviews)
4.6
mike199

My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & More

$555 USD in 10 days
(2 Reviews)
4.2
$250 USD in 3 days
(13 Reviews)
3.6
yh2013

Let me have the required data in order to send you an example.  I have the required expertise for developing your project. Check my developed projects and reviews of my portafolio.

$250 USD in 11 days
(8 Reviews)
3.8
$477 USD in 10 days
(5 Reviews)
3.4
AleenaIlyas

Hello, I have read what you exactly need, however I would like to ask you a few questions. I do work smart and do not rest until I get the job done. Please feel free to ping me anytime so we can have a detailed discuss More

$880 USD in 15 days
(1 Review)
3.5
webanis

Hi , I am interested by your offer I will be happy to do this job even though I'm new in the field of freelance. Let me know more details of this work. I will start working immediately :) Br.

$333 USD in 10 days
(9 Reviews)
3.4
KirillKosenkov

Hi! I have long experience with Excel/VBA so i think i can do the task i think possible with multiple ranges too Feel free to message me to discuss any details Regards, Kirill

$250 USD in 2 days
(5 Reviews)
2.4
DavidLindon

What format do you need the report file to be? Is a console app ok or how did you want it to work? Look forward to hearing from you

$250 USD in 10 days
(1 Review)
2.4
alliedbandna

Dear Sir, Your have recently advertised for website developer . After reading the job description I am confident that I would be a perfect fit for this position as my experience and abilities precisely match your requ More

$250 USD in 25 days
(2 Reviews)
0.6
$666 USD in 10 days
(0 Reviews)
0.0
nbyerlee13

Offshore software application development company, Experts from India having range of Skills available in our In-house staff: Dedicated: Android Developer, Website Developer,Java Developers, E-commerce developer, PHP D More

$555 USD in 10 days
(0 Reviews)
0.0