Kapalı

Combination Generator from a Matrix Table

Let's say, I've got an 3 x 3 matrix. I want all the combinations of the table entries such that, a combination

C1 = [R1C1] x [R2C1] x [R3C1]

C2 = [R1C1] X [R2C1] X [R3C2]

C3 = [R1C1] X [R2C1] X [R3C3]

C4 = [R1C1] X [R2C2] X [R3C1]

C5 = [R1C1] X [R2C2] X [R3C2]

C6 = [R1C1] X [R2C2] X [R3C3]

C7 = [R1C1] X [R2C3] X [R3C1]

C8 = [R1C1] X [R2C3] X [R3C2]

C9 = [R1C1] X [R2C3] X [R3C3]

C10 = [R1C2] X [R2C1] X [R3C1]

C11 = [R1C2] X [R2C1] X [R3C2]

C12 = [R1C2] X [R2C1] X [R3C3]

C13 = [R1C2] X [R2C2] X [R3C1]

C14 = [R1C2] X [R2C2] X [R3C2]

C15 = [R1C2] X [R2C2] X [R3C3]

....and so on. For a 3X3, there would a total of 27 combinations.

The algorithm should work for nxm matrix.

The matrix would be an input table in excel. The excel macro should generate these combinations and should display these combinations in a list below the table.

The output list will have 2 columns. 1st column will have combination Id, 2nd column will have the combination value. Combination Id is a string showing which positions were multiplied to get that combination. For eg. in the example above, the first combination id would be 1-1-1 and combination would be C1 value. next would be [1-1-2, C2], then [1-1-3, C3], [1-2-1 C4] etc..

Beceriler: Excel, Visual Basic

Daha fazlasını gör: random word combination generator, word combination generator, matrix table mysql, excel generate all possible combinations vba, excel all combinations of 3 columns, vba combination generator, list all possible combinations, excel permutation generator, excel combinations generator, excel all combinations of 4 columns, excel formula to find all possible combinations, excel, microsoft, mathematics, algorithm, matrix table design mysql, generator css table, matrix table design, combination generator wordlist, letternumber combination generator

İşveren Hakkında:
( 0 değerlendirme ) Australia

Proje NO: #17442971

Bu iş için 19 freelancer ortalamada $34 teklif veriyor

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Daha Fazla

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(651 Değerlendirme)
8.3
schoudhary1553

Hi there, Warm Greetings We came along with your request for Combination Generator from a Matrix Table and we reviewed your project description. We'd like to help you with confidence and satisfying results. We Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(288 Değerlendirme)
7.6
ksriniravi

Greetings! I can develop an Excel based Combination Generator for a n*m matrix as specified in requirements. Being a full time freelancer working exclusively on Excel based projects, I work on developing such excel Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(165 Değerlendirme)
6.7
vano101

Hello I have over 17 years of experience in various areas of IT technologies and programming languages. Also, I have strong mathematical background and I have experience with writing Excel macros using VBA

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(329 Değerlendirme)
6.4
periyannas

Ok Sure ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(73 Değerlendirme)
5.9
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(60 Değerlendirme)
5.7
prabakarm23

Greetings for the Day!!!. I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv Daha Fazla

in %bids___i_period_sub_35% gün içinde83%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(54 Değerlendirme)
4.7
Ahmed818

hello, i am interested in this project can begin now , finish it in few hours waiting your answer Regards

in %bids___i_period_sub_35% gün içinde20%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(26 Değerlendirme)
4.0
robcastillo

hi! I would like to help you with your project, please share with me a file with some matrix samples and I will check it. Best regards Roberto C.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(15 Değerlendirme)
3.5
paulodayto08

I've been doing excel enhancement using vba macro for over 7 years now. and I am a subject expert matter and has a strong knowledge with MS excel. Please work with me, i can do than in less than a day. Also, current Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(16 Değerlendirme)
3.5
nishantha041

Dear sir, By profession i’m an engineer and has sound knowledge about matrixes and its behavior.i can develop solution for this [login to view URL] contact me. Thank you.

in %bids___i_period_sub_35% gün içinde27%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
2.9
in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
DataGuru2

Hi. Your explanation is absolutely clear. I think it can be done 100% . Let me know if you need me to do it.

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0
trebertm

I have made a proposal to you. An actual spreadsheet I made and ready for your review. If it's not what you have expected, please let me know so I can revise based on your need. If you want some features I can too. You Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0
fastlabindia

We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. We can redo, improve, and publish any engineering, scientific MATLAB, SI Daha Fazla

in %bids___i_period_sub_35% gün içinde10%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
2.0
in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
mhetre1s

I am an expert in Microsoft Excel Spreadsheet formulas and Visual Basic (VBA) programming for Excel files. I am willing to do the first project at low cost in order to demonstrate skills, earn good feedback and rec Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0