Find Jobs
Hire Freelancers

Search algorithm

€250-750 EUR

Completed
Posted over 4 years ago

€250-750 EUR

Paid on delivery
From a large number of samples (a to x), the smallest possible sample set should be selected, in which all characteristic values (0-5) are available for each individual parameter (I-X). An implementation as a dynamically adaptable Excel macro would be preferred. Since performance is a big issue, could you please tell me on which sorting algorithm you’re planning to base the solution. If MS Excel don’t find you’re needs for a solution we could switch to another Plattform. XLS Example [login to view URL] It is the goal to find the highlighted colums, or at least the best combination Since not all values will be equally distributed, a sorting algorithm must be used. Furthermore there has to be an option in the script to select I-VI. Due to performance limitations we have decided to consider another option, that each characteristic value (1-5) is present twice in total: So: - every parameter (I-VI) musst be ickluded in the final sample set with every values (1-5) expressed twice with the smallest possible number of samples
Project ID: 23837735

About the project

33 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I have seen the sample PDF where sample data is contain, I will make Visual Basic code to got parameter as per your requirement with good and professional quality without any error. Need more details about requirement to start the project. I have completed more then 100 project within 8 months with 5 star review. You are gentle requested to see excel project sample in my portfolio here: https://www.freelancer.com/u/rashedkhanrubel. I will deliver the project within timeline with better quality. If you want to award me the project I'd be very happy to discuss deeply about your requirement and get started for you as soon as possible. Thanks! Rashed
€250 EUR in 2 days
5.0 (468 reviews)
8.1
8.1
33 freelancers are bidding on average €444 EUR for this job
User Avatar
Hello, I can help you with your project - Search algorithm I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
€500 EUR in 10 days
4.9 (619 reviews)
8.6
8.6
User Avatar
Hi, Reading your project description about working on an Excel sheet using Excel Macro makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Rather than fill this proposal with a list of qualifications, I want to complete a part of this project as a proof of concept before you award this project. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time
€500 EUR in 5 days
4.9 (75 reviews)
7.0
7.0
User Avatar
Hi, I can perfectly provide you a solution for this in Excel as well as in Python and SQL. I am a professional VBA programmer and Excel expert holding years of experience in utilizing advance level tools and functions including VBA and Macro. I will be happy to discuss in detail how I am highly suitable for this project.q
€250 EUR in 1 day
4.8 (249 reviews)
7.3
7.3
User Avatar
Hello there. I have checked your project description (I think is possible but I can do it in google sheet if you are interested) .I can do your project in less than 24 hours according to your description with full delivery and without error. I would also complete your project with the highest precision and quality. I have extensive experience in your project.
€400 EUR in 2 days
4.9 (173 reviews)
6.5
6.5
User Avatar
Hello there. I'm an expert data scientist here. I've downloaded the example pdf and I was wondering what do you exactly mean by the smallest possible sample set ? A sample output will be helpful. Please let's discuss more details in the chat. I'm also happy to provide a quick demo as a proof of concept before you award me the project
€350 EUR in 3 days
5.0 (15 reviews)
5.8
5.8
User Avatar
Hello, I can help you with your project - Search algorithm I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/whitehorsetechn?w=f I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Vibrantwebtech Ramesh
€400 EUR in 10 days
4.8 (13 reviews)
5.3
5.3
User Avatar
Hi, I am a computer science graduate and expert in algorithms. Your problem is a version of set cover problem and therefore no polynomial time algorithm exist for exact solution. Also there is a logn-approximation and this is the best you can get.
€500 EUR in 15 days
5.0 (17 reviews)
4.9
4.9
User Avatar
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.
€250 EUR in 1 day
4.6 (25 reviews)
4.9
4.9
User Avatar
I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in programming and development I have been excellent with JAVA,C#,C/C++ and PHP programming language along with MySQL with XAMPP Server. I also build application for Cloud computing and High performance computing as I also have knowledge regarding Hadoop, MPI, OpenMP (distributed frameworks) and also have build applications in CUDA C++ and OpenCL. I also have experience with the most famous framework ASP.NET. My most expertise are in JAVA where I have built countless projects for semester projects and Final year project. You may find many developers in this field however we assure that you will not be able to find a team like us. We not only ensure the code is quality wise but we also assure that the code we write are optimised and we ensure that the program performs right operation under right environment i.e. we create programs that are defect free. You may also find freelancers that cost low but they do not put their 100% which then shows in the software and leads to an unhappy customer. We ensure reasonable price are put as tag on the job and we ensure in order to give the write product. We highly appreciate your time, if you are interested kindly let me know
€250 EUR in 7 days
5.0 (4 reviews)
4.3
4.3
User Avatar
Hello again, I see you updated your optimization project. First of all, to select the smallest possible set of samples, in which all characteristic values (0-5) are available for each individual parameter (I-X), you can program an initial heuristic that orders the samples to be considered as candidates according to the lowest frequency of their mode(of their characteristic values), which will allow a higher probability of choosing the samples with the highest diversity of different characteristic values for each individual parameter, and which contributes to maximize the presence of all characteristic values. With this initial ordering, the next step will be to choose the following samples that have different modes, in order to maximize, again, the presence of the different characteristic values. Finally, the next steps will consist of determining the next samples, recursively applying the previous steps. That would be roughly the algorithm to use, that I can do in the spreadsheet directly. For the other options I could consider a simpler algorithm, taking into account some elements already mentioned. Anyway, I would have to clarify some details with you. I hope you can communicate with me. I'll surely make a great algorithm for you!
€500 EUR in 10 days
4.6 (6 reviews)
4.0
4.0
User Avatar
I do Excel macros. I think it has to be done doing for each column a search cell by cell and boolean variables for each digit (0-9), that stop when it fill all digits, then select the rows.
€250 EUR in 57 days
5.0 (14 reviews)
3.8
3.8
User Avatar
Hi Sir, I am very interested in your project and also I am ready to start immediately.I will give you high quality and fast work. I assure u will like my work very much and i will give u unlimited changes . I will deliver you project timely and there will be no delay in my work.I will start work asap.I will regularly update you,i can do work as per your requirement.I am here for long term work relationship so will give 101% best output from my end so that you consider me for future job :) waiting for you reply thankyou
€500 EUR in 7 days
5.0 (1 review)
2.9
2.9
User Avatar
Greetings, I have 35+ years of Information Technology experience in Engineering Delivery, Services Delivery, Support Management, Product Management & Quality Systems across multiple domains. Brought in solidity & a process-driven culture to delivery organizations worked. During these years, I have used Excel extensively to manage the programs/projects/actions, performance management, and other reporting requirements. I have gained expertise in Office productivity tools and specially Excel and I have been training people on these tools. Normalized/cleaned up lot of data, collected from various sources and made it easily usable using Excel. Provided numerous solutions using Excel in the area of Budgets, Actuals, Revenue Projection, Billing, Gross margins, Project Estimates / Plan / Monitoring / Reporting, Performance Assessments, Resource Management, Timesheets etc. These required me to use lot of functions & formulas and very innovative Pivot table features. Keen to take up this assignment. The details provided are not completely clear and to me it appears it can be accomplished quickly in Excel. If this turns out to be a simple problem, I will compensate you by providing additional assistance which we agree. I will deliver quality work and my turn around time will be 1 day. if proposed terms are the problem, we can discuss the same. Thank you for taking the time to read my proposal. Warm Regards
€250 EUR in 1 day
5.0 (3 reviews)
2.6
2.6
User Avatar
Hello, How are You? This is Hammad, I went through your job description in detail also review your attached file and I assure you that I can defiantly design the algorithm. The code will free from any type of bug or error Questions: Any specific Programming language you want? Any demanding compiler you wanted to work on? My expertise are C#, PHP, NodeJs and many other languages like python, C++, C, Java, etc Let's have a chat where we can discuss it in detail. Thank you for taking the time to read my application. Best Wishes, Hammad O Software Engineer
€250 EUR in 4 days
4.6 (1 review)
2.6
2.6
User Avatar
Hi this can very well be done by excel using formula and some logic, please connect and share the read data file and some more instructions, i am confident that i can do it in one day time.
€250 EUR in 3 days
5.0 (2 reviews)
1.3
1.3
User Avatar
I’m interested in your proposal. Please send me the details of your project. Looking forward for these kind of projects in future.
€250 EUR in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I saw that you need help with Algorithm, Data Processing, Excel, Mathematics, Visual Basic. I have 6 years of experience working on these frameworks. I believe I can help you with it. I would request you to have a look at my porfolio, customer feedbacks from my profile. If you find me worthy of doing your job. Please start the chat and lets discuss it. Regards Shamshad
€1,250 EUR in 29 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello SIR, I don't think that what are you looking for is as simple as your description, as soon as you talk about the best possible combination (probability algorithms come into play) it means that your problem is a little more complex, I am an engineer in the industrial computing with mathematical bases with an experience of more than 4 years in vba in my daily routine, I would like to collaborate with you on this subject, there are a lot of sorting algorithm that we can analyse together before making the choice of the one that we will implement according to your requirements (temporal and spatial). I am ready to talk more about the subject before starting and also the deadline and the final price. Best Regards,
€500 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I think your problem is the generalized set cover problem which is NP-Hard. If you really want the true minimum sample set, then the solution would be A* with a heuristic. Another solution would be ILP with Gurobi. There also exist approximation solutions. I could implement all three for you and compare in terms of time and accuracy on real data. I suggest you forget about Excel and consider a real programming language such as Java or C++.
€750 EUR in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hallo, ich arbeite mit Datensortierungsalgorithmen (QuickSort, Heapshort, BubbleSort, ...) seit längerer Zeit und insgesamt 15x Jahren als SW-Entwickler. Persönlich würde ich schnell mit meinem Matlab-Lizenz den besten Algorithmus finden und danach es in Python implementieren. Ich denke, dass man es mit Excel gut kombinieren kann. Wichtig ist die Definition des Sortirungsalgorithmus (wie definiert man the "smalles possible Subset"). Sollte die Performance extrem wichtig sein müssten man runter auf die C-Sprache kommen und das Sortierprogramm von Excel ausführen. Ich denke und hoffe, dass es mit einem gescheiten Verfahren, dies nicht notwendig sein wird. Selbst im Notfall, habe ich sowas gemacht und daher könnte ich es umsetzen. Örtlich bin ich in Stuttgart aber natürlich mit einem kurzem Gespräch kann ich das Projekt starten und durchführen. Lizenzen, Rechner habe ich selber. Sollten Sie noch Infos benötigen, melden Sie sich gerne bei mir. Beste Grüße, Pablo Costi
€550 EUR in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Mannheim, Germany
5.0
5
Payment method verified
Member since Feb 10, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.