Generating Unique Combinations From Fixed Data

2 posts in this topic

#1 ·  Posted (edited)

#include <Excel.au3>
#include <File.au3>
#include <String.au3>
#include <Array.au3>

Local $sku_array[0] ;13640
Local $name_array[0] ;13640
Local $sku_string
Local $name = "Name Here"; hardcoded, iterate through final list
Local $name_sku = "E001" ; hardcoded, iterate through final list

    For $size = 0 to 3 Step 1
        For $mg = 0 to 30 Step 1
            For $b = 0 to 1 Step 1
                For $menthol = 0 to 4 Step 1
                    For $vg = 0 to 10 Step 1
                        $sku_string = String($name_sku & $size & $mg & $b & $menthol & $vg)
                        _ArrayAdd($sku_array, $sku_string)
                        _ArrayAdd($name_array, $name)
    ;_ArrayDisplay($name_sku_array, "Array Data:")
    Local $oExcel = _Excel_Open()
    Local $sWorkbook = @ScriptDir & "\FURLS_TRLM_Product_Listing_Eliquid.xls"
    Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook, Default, Default, True)
    _Excel_RangeWrite($oWorkbook, $oWorkbook.Activesheet, $sku_array, "B2:B13641")
    _Excel_RangeWrite($oWorkbook, $oWorkbook.Activesheet, $name_array, "J2:J13641")
    _Excel_RangeWrite($oWorkbook, $oWorkbook.Activesheet, $name_array, "A2:A13641")
    ;A2 or Column 1 - $name_string
    ;B2 or Column 2 - $sku_string
    ;J2 or Column 10 - $name_string

So I am trying to generate every unique combination using 1 value from each set and then place each generated value into an array and then write to an excel sheet.

Edit: Functional Code, F#CK THE FDA!


I have the following data sets:

Size: 10, 30, 50, 100

MG: 0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30  (shortened in the above code for time constraints while testing)

VG: 0,1,2,3,4,5,6,7,8,9,10

Boost: 0,1

Menthol: 0,1,2,3,4

Edited by newcoding

Share this post

Link to post
Share on other sites

Another one moved to General Help and Support, Developer Forum clearly states "Do not post AutoIt topics here"

√-1 2^3 ∑ π, and it was delicious!

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • fosil
      By fosil
      Hi everyone.

      I'm currently working a program that constantly prints out log files through "consolewrite" and the "#AutoIt3Wrapper_Change2CUI=y" wrapper.

      Part of this program requires me to run a batch script.

      My issue is the batch script launches from the same window as consolewrite. I need the batch file to be launched through a different window as currently this causes an issue with the logs (which need to be very precise) but also causes the batch file to produce some funny behavior...

      Does anyone know how I can force the file to run on a second DOS window?

      Thanks in advance!!!
      Edit: Im using the "run" command if that helps. I tried "shellexecute" but that seemed to not launch the batch scripts at all.
    • nacerbaaziz
      By nacerbaaziz
      Hello guys
      I have an inquiry regarding bass.dll
      I wanted to record an audio file and did not know the way
      As well as I want to save the file after applying the effects
      can you help me?
      am sorry for my english
      With my greetings and best wishes
    • kenny4896
      By kenny4896
      Hi All,
      I tried my best to looking a solution from this forum or others, but I have no luck. The imagesearch dll working fine in my 64 bits machine, whenever I move the scripts to Win 7 (32 bits), it crashes. ImageSearchDLL.dll, ImageSearch.au3 and my simple scripts are in the same working directory. For win 7 (32 bits) machine, I'm using 32 bits ImageSearchdll.dll, the simple scripts as below:
      #include <ImageSearch.au3>
      Global $y = 0, $x = 0
      Local $search = _ImageSearch("C:\Program Files\AutoIt3\Examples\Images\mypc.PNG", 0, $x, $y, 0)
      if $search = 1 then
         MsgBox(0,"Found","Found my target here..." & $x & "," & $y)
         MouseMove($x, $y, 10)
         msgbox(0, "Not found","")
      However, I received error message below when running the script. Anyone here got clue? 
      Problem Event Name:    APPCRASH
        Application Name:    AutoIt3.exe
        Application Version:
        Application Timestamp:    55fc1979
        Fault Module Name:    AutoIt3.exe
        Fault Module Version:
        Fault Module Timestamp:    55fc1979
        Exception Code:    c0000005
        Exception Offset:    00020e42
        OS Version:    6.1.7601.
        Locale ID:    17417
        Additional Information 1:    0a9e
        Additional Information 2:    0a9e372d3b4ad19135b953a78882e789
        Additional Information 3:    0a9e
        Additional Information 4:    0a9e372d3b4ad19135b953a78882e789
    • Hanukka
      By Hanukka
      Hello there,
      I want to check the checkbox in the frame which pops up after choosing "run code snippet" option. ( Internet Explorer one would be prefered )
      Can you please please send the right code or some snippet here.. 
    • Fhelipe
      By Fhelipe
      Nothing More