Advanced Lookup Table for Lowest Value in Matrix

Objective: to develop a python script which can lookup proper spend of categories

1. Find the lowest dollar value in the matrix at each level of spend

2. Do not go over the constraints for a given column

3. Disable the cell values which have been already used

4. In the case where there is a tie for lowest dollar value please select from the first column to left.

Logic Programming in python (pyke, kanren, pyDatalog) or pure python are all acceptable.

We will test the output under many scenarios to be sure the logic is developed correctly. Please see attached Excel data.

Kemahiran: Python, SQL

Lihat lagi: create linked lookup table, objective cell selected, aes lookup table, offset match, index match array, index match vs vlookup, index match multiple criteria rows and columns, index match 3 criteria, index match match excel, excel index match multiple criteria, index match multiple columns, mysql, sql, python, postgresql, ulaw lookup table, pic18 dtmf lookup table, importance lookup table excel, vehicle makes models lookup table javascript, mcc18 lookup table

Tentang Majikan:
( 9 ulasan ) Franklin, United States

ID Projek: #15421401

Dianugerahkan kepada:


Hi I can do it immediately. Relevant Skills and Experience PYthon, SQL Proposed Milestones $25 USD - ONe Time Which Database do you use? Mysql, Postgresql?

$25 USD dalam sehari
(0 Ulasan)

5 pekerja bebas membida secara purata $25 untuk pekerjaan ini

$25 USD dalam sehari
(35 Ulasan)

Hi i have 8 years of experience in using phython. I can finish this job 1 days . Hope we can have more conversation Regards, Nagaraja Relevant Skills and Experience Hi i have 8 years of experience in using phython. I Lagi

$25 USD dalam sehari
(3 Ulasan)

python Relevant Skills and Experience python Proposed Milestones $25 USD - completing

$25 USD dalam 0 hari
(1 Ulasan)

Hi I am new to freelancer.com but I have experienced for 10 years and have ever built several apps. I hope working at this project and i will do my best for project. Regards Marc Gardiner Relevant Skills and Experienc Lagi

$25 USD dalam sehari
(0 Ulasan)