dm83737 Posted February 24, 2009 Author Share Posted February 24, 2009 dm83737,Great news - glad I was able to help. Now go and work on your presentation for tomorrow. ;-)M23One last question (sorry), the totaling function I have does not work when there are different values listed for the same policy run. Is there an easy way to find the sum of an array column? I tried searching briefly, but I can not spend a lot of time searching around in the forums (our IT department keeps track of your online time). If you want me to figure something out on my own, I am willing to look this up when I get home. I just thought I would ask in case you had it handy. Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted February 24, 2009 Moderators Share Posted February 24, 2009 (edited) dm83737,Assuming it is an AutoIt array, this should work:; $aArray is declared and filled somewhere.... ; And you know the start and end elements for the range to total $iCount = 0 For $i = $iStart_Element To $iEnd_Element $iCount += $aArray[$i] Next ; $iCount now holds the total of the elementsIs that what you are looking for?And in answer to the Java question - no experience at all. I suggest starting another thread and seeing if someone else can help - I think we have frightened the rest of the forum away from this one!M23P.S. Game was pretty gripping, but alas scoreless. Have to wait for the return in 2 weeks time...Edit: Looks like _ExcelReadArray will get your worksheet values into an AutoIt array if you need it. Edited February 24, 2009 by Melba23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now