Jump to content

Generating Unique Combinations From Fixed Data

Recommended Posts

#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

    • Valnurat
      By Valnurat
      My color of pixel exists more than one place.
      How can I control the position so I find the exact position before I continue in my code?
    • nacerbaaziz
      By nacerbaaziz
      Hi dear
      With this script you can print Unicode text in the CMD screen
      the script is  easy to use
      just you  write the text that contains Unicode in the first input
      and the script automatically reflect the code in the second input
       you can copy the text to the clipboard
      or you can try printing the text in the CMD window
      I apologize to everyone for colors and shape if not appropriate
      I'm a blind man and I do not see
      Thank you for your understanding
      Greetings to all of youCmdUtM.au3
    • Abdulla060
      By Abdulla060
      Hello all, i have about 20 arrays in my script and i need to delete the first element of each, i have the name of the arrays in another array (its used in another part of the script)  and i tried to passing the names to from that array to the _ArrayDelete function but nothing happens and i get an error code :1 which state that i'm trying to delete an array which is not an array
      code example
      #include <Array.au3> global $allarrays[3] = ['array1','array2','array3'] global $array1[3] = ['1', '2', '3'] global $array2[3] = ['1', '2', '3'] global $array3[3] = ['1', '2', '3'] for $i = 0 to UBound($allarrays) - 1 _ArrayDelete($allarrays[$i], 0) Next _ArrayDisplay($array1) obviously i can just use  _arraydelete over and over however i'm looking for a more elegant way of doing this
    • Rammanan
      By Rammanan
      Hi all, Below is my script,
      Pls advise me if any wrong on that....File exit in location but the return -1.
      FileOpen($file, 0)
         $line = FileReadLine($file)
      Local $aArray = _FileListToArrayRec($serverpath, "*|*.txt", $FLTAR_FILES, $FLTAR_RECUR, $FLTAR_SORT, $FLTAR_NOPATH)
      If @error Then
              MsgBox($MB_SYSTEMMODAL, "Ooops!", "No files found")
          ;_ArrayDisplay($aArray, "Sorted tree")
                 Local $hSearch = FileFindFirstFile($line)
    • Theodoor
      By Theodoor
      I am trying to use the ControlClick in a "save as"-window to select the path of where to save the document.
      I found out that when in press the icon in front of the path, i select the path. So I am trying to press that button (i have attached a print screen of this window).
      While trying to figure out how i had to use the ControlClick, it said somewhere that i could us Au3Info to find out what title,... i should use with the ControlClick.
      The result of the Au3Info I have attached aswel.
      The ControlClick that i tried are these: (and none of these even move the mouse)
      ControlClick("[CLASS:ToolbarWindow32; INSTANCE:4]", "", "", "Left" ,1 ,10,10)
      ControlClick("[CLASS:ToolbarWindow32; INSTANCE:4]", "", "1001", "Left" ,1 ,10,10)
      ControlClick("[CLASS:ToolbarWindow32]", "", "", "Left" ,1 ,10,10)
      ControlClick("Save project as", "", "", "Left" ,1 ,10,10)
      I don't know what I am doing wrong.
      Should I use a controlID? is my windowtitle wrong?
      Can anyone help me?
      Thanks in advance,


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.