This log summarizes development of G7 since the last update of the G7 Help files. Copyright: Inforum 2009 Web Site: www.Inforum.umd.edu 10/10/08 Modified CreateVamFile() to work properly when called from the command box. 7.3757 10/17/08 Fixed a bad problem with ctrl, where the group was not processed properly. 10/18/08 Increased size of GString arrays in csum and chain. Fixed some memory freeing problems. 7.3758 10/22/08 Fixed up matin5 routine. 10/23/08 Fixed up additional serious problems with ctrl routine. 12/22/08 Fixed a file-delete problem in flowctrl.cpp. 1/6/09 Made listnames command print available macro series when listing names for a vam bank with vammode=='a'. Previously, only the vector names were printed. Also, add "ln" as a shortcut for listnames. Added case-sensitive sort option 's'; reverse order of sort 'r'; vam file only 'v' or Gbank only 'g' when vammode is 'a': listnames [-srgv] [mask] Note that vector elements are not quite in order, since the sort is alphabetical (e.g. ...out19 out2 out20...). Can add additonal options later, like case-insensitive sort. 7.3759 2/21/09 Fix false error message when creating a new workspace series with "xl read." Rework GUI control of InterDyme models, including IdBuild, Fixer, MacFixer, IdRun, Tables, and Express Tables. 7.376. 3/4/09 Enable creation of new spreadsheet documents with XL command. The commands {(xl open wb), (xl create [wb])} will start XL, create a new workbook, and insert one blank worksheet. Enabled "xl save []". "xl create wb " will create a new spreadsheet of a given name. Added "xl create ws []" that inserts a new worksheet to the right of the active sheet. Added "xl name ws " to set the name of the current worksheet. Implemented passing of array to Excel for WriteNumberArray() function. Added "up" and "left" directions for "xl write" command. Fixed bug in ColumnMinusOne() function. 3/5/09 Fixed bug in "xl read" optional dates. Fixed bugs in ColumnMinusOne() and ColumnPlusOne() functions. Implemented receiving of array from Excel for ReadNumberArray() function. 3/10/09 Significantly revised Excel code to split G7 interface from Excel class. Added "xl column width ". 4/15/09 Made r command return an error when missing data are encountered. When an editor is not saved and the G7 window is closed and the editor prompts for saving and the user cancels, made G7 stay open. G7.377. Began improvements to bank open window. Closed some memory leaks. 4/20/09 Added ,)> function to if-else routine. 4/24/09 Modified pause: pause [], where is one word (possibly in quotes). Made "return OK" actually return. Made fadd skip to next on "continue". 5/13/09 Fixed up the Run Dyme config. Improved the Tables config. Fixed bug when 'look' is run from script. Fixed launch of console from menu for Vista systems. Fixed inelegant treatement of cancellation from "Execute" menu item and button. 5/14/09 Changed File | Directory and Change Folder button to load the current working directory when they open; previously, they loaded the location of G7.exe. Implemented Font Dialog (previosly existed, but did not work) for graphs. Allow title and subtitles to be italic, bold, underline, strikeout, but not other graph text. Add Bold and Size settings for G7 main window to greg.ini, and store graph and editor font settings (size settings have no effect in graphs). Improve G7 main menu titles. 5/15/09 Implemented Redo in Editor. Improved editor menu arrangement. Load editor font from greg.ini, and implement editor font settings in all editor windows. Fixed bug in Editor Close. Eliminated false "modified" when font settings are implemented or when text is loaded from file. In G7 button bar, reorder the buttons. Eliminate the "Execute" button, and respecify the Run button to check for a file name in the Execute box; if present, run it, otherwise prompt for a file name. 5/20/09 Fix up some numerical problems in log graph. Add dialog for running IdBuild. Redo Dyme Run dialog. Change process for running Dyme models. Now, there is a check box in the dialog for running IdBuild (this is no different than running IdBuild from the menu), and for configuring Fixer and MacFixer. If the fixer boxes are checked, then those dialogs will open and the contents used to construct cfg files, but the programs will not be run. Instead, Fixer and MacFixer now will be called from Run.Bat, which will be executed by G7 in order to run the model. Run.Bat either must be supplied by the user, or G7 can construct a batch file with a button click, using information supplied in the Run Dyme window. It still is possible to use the old IdBuild->MacFixer->Fixer->Run Dyme sequence, but it is not preferred. The new way follows the standard Inforum sequence of setting the model configuration, copying historical banks to model banks, running the fixers, running the model, and then saving the model files. Plus, the new way reduces the number of menu selections needed to run the model. 5/21/09 Fix up the dir command. Fixed bug in look. Switched scaling to false for many windows (Bank Open, (Mac)Fixer, Run Dyme, Tables). 6/17/09 Correction to indexing in XL (problem with excelIntToColumn: AA). 7/1/09 Minor adjustment to column indexing function excelColumnPlusN(), with corresponding adjustment to function calls. Fixed problems with reading "up" and "left." Improved "xl missing" to recognize negative number arguments. Add detection of Excel error codes (e.g. returned when trying to read a cell with a divide-by-zero error) in the "read" command; insert a missing value, print a warning, and continue. G7.379 7/10/09 Fixed a bug in the show command that would cause trouble when executing "show" from the command box. Probably related to Ono's bug report, addressed 8/8/08. 7/28/09 Fixed group routine in do loop to handle cases like (1-97 (1-1) ), where (1-1) was not skipped properly. Instead, the exclusion routine was setting 1-97 to zero, because processing of the first "1" was setting the first element to zero, and so the processing of the second "1" was done improperly. There are problems with the routine, and they need to be redone! 7/31/09 Built new fills routine for do loop. Needs more work to fully integrate new system, both in RunCmdFile and any other function that calls the function. Need to convert other fills routines to use similar technology. New method builds groups using doubly linked lists. Should avoid the bugs that still plague the old routine. Added excelColumnToInt routine. Worked to debug groups commands, and made do loop handle such groups. Previous code was intended to handle such groups, but was not implemented properly. Previously, the group was read as a number, but now the group is specified like ":Manufacturing" as with other implementations. Modified getlist function because it was not printing properly, but the problem might originate elsewhere. Note that code for groups is buggy and full of leaks and needs to be checked. 8/6/09 Debugged the groups commands. Fixed groups.bin file open problem. Fixed memory leaks. 8/14/09 Redirected RunCmdFile() and excelGetGroup() to use new fills() routine. Adjusted xl vecread and xl matread accordingly. Need to implement new fills() in GVamFile.cpp. 8/17/09 Reworked vmake routine, fixed bugs and implemented new fills() function. Updated p123 function to use new fills() routine. That should complete the transition of the old fills() routine to the new, so I removed the old fills() routine. Still need to switch the old fill() routines (fill() in rhs.cpp and GroupHome->fill()) to fills(). 8/18/09 Made the GroupHome::fills() routine use the new fills() routine. Modified all calls to use dynamic arrays in the new format. Needed to adjust various GroupHome routines to use the dynamic, compact arrays. Updated ctrl, gidmake, fillrowdef(), gmatdat, scale. Modified pscale(). 8/19/09 Resurected vam test routine from 2003, and it turned up bugs. Changed vupdate abrev. from vu back to vup. Fixed up vmake. Ran into trouble in RAS; did not have time to fix. 8/20/09 Debugged RAS command. 8/21/09 In Editor, introduced the opening of a filename that is selected in the text of the editor window. NOTE: RAS seems to work with packed matrices, but it always scales the rows and columns to sum to 1.0. Is this desirable? It is not documented. Full matrices are not scaled in this way. NOTE: ras does not operate on groups with packed matrices. Made graph return on error. 8/28/09 Added @stdev() function to compute the sample standard deviation. Fix bug in dates in @mean() function. 9/2/09 When running Build, check whether Model.bat exists; if not, create it with standard entries. Print macro model window parameters to GReg.ini. 9/4/09 Fix buffer overflow in Vam title command. G7.38