Results 1 to 10 of 19

Thread: Just testing. Testing some sort routines. No reply needed

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #8
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,458
    Rep Power
    10

    Some timimg results. Range.Sort v Sub SimpleArraySort6(

    The two codes are simply modified to give a time measurement thus:
    Range.Sort Method:
    Code:
    Dim StartTime As Double: Let StartTime = Timer
    rngToSort.Sort Key1:=wksToSort.Columns("H"), order1:=xlDescending, Key2:=wksToSort.Columns("J"), order2:=xlDescending, Key3:=wksToSort.Columns("X"), order3:=xlDescending 'X Nat
     MsgBox prompt:=Round(Timer - StartTime, 2)
    Array Sort coding ( In recursion code): ( Sub SimpleArraySort6( )
    Code:
    '3c)
    Dim StartTime As Double: Let StartTime = Timer
    arrTS() = rngToSort.Value: Call SimpleArraySort6(1, arrTS(), strIndcs, " 8 Desc 10 Desc 24 Desc "): rngToSort.Value = arrTS()
     MsgBox prompt:=Round(Timer - StartTime, 2)
    Part of original data test range
    _____ Workbook: ProAktuellex8600x2SortTime.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    H
    I
    J
    K
    W
    X
    Y
    824
    338
    0.1
    0
    825
    826
    351
    0.1
    827
    342
    0.1
    0
    828
    342
    0
    829
    341
    0.1
    0
    830
    338
    1
    0
    831
    338
    0.1
    0
    832
    338
    0.1
    0.1
    833
    337
    0.5
    0.1
    834
    337
    0.1
    0
    835
    337
    0
    0.1
    836
    336
    0.2
    0
    837
    335
    0.1
    0
    838
    334
    0
    0.1
    839
    333
    0.2
    0
    840
    332
    0.2
    0
    841
    332
    0.1
    0.1
    842
    332
    0.1
    0
    843
    331
    0.1
    0.1
    844
    331
    0.1
    0.1
    845
    329
    0.2
    0
    846
    329
    0.1
    0
    847
    326
    0.3
    0
    848
    326
    0.3
    0
    849
    326
    0.2
    0
    850
    326
    0.1
    0
    851
    324
    0.1
    0.1
    852
    324
    0.1
    0
    853
    319
    0.2
    0.1
    854
    318
    0.5
    0.1
    855
    316
    0.2
    0.1
    856
    279
    0.5
    0.1
    857
    232
    0.1
    0
    858
    230
    0.2
    0
    859
    215
    0
    0
    860
    861
    338
    0.1
    0.1
    862
    339
    0.1
    0
    863
    337
    0.1
    0.1
    864
    865
    338
    1
    0
    Worksheet: Sheet1


    "ProAktuellex8600x2SortTime.xlsm" https://app.box.com/s/af7891hzmd3sbfnnsmx5b28ktec6wwjo
    Last edited by DocAElstein; 03-14-2019 at 03:38 PM.

Similar Threads

  1. Replies: 19
    Last Post: 04-20-2019, 02:38 PM
  2. Replies: 1
    Last Post: 04-02-2019, 03:04 PM
  3. Testing functionalities
    By Admin in forum Test Area
    Replies: 1
    Last Post: 09-01-2016, 04:02 PM
  4. testing BBCode with conditional formatting
    By Admin in forum Test Area
    Replies: 0
    Last Post: 01-20-2016, 08:36 AM
  5. TESTING Column Letter test Sort Last Row
    By alansidman in forum Test Area
    Replies: 0
    Last Post: 10-24-2013, 07:14 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •