{ From user Lonnie, Model Manipulating_dates at Thu, Sep 13, 2007 11:05 AM~~
}
Softwareversion 4.0.0
{ System Variables with non-default values: }
Typechecking := 1
Checking := 1
Saveoptions := 2
Savevalues := 0
{!40000|Graph_hlabelrotation := 90}
{!40000|Att_contlinestyle Graph_primary_valdim: 1}
Model Manipulating_dates
Title: Manipulating Dates in Analytica
Description: In this talk, I'll cover numerous aspects relating to the~~
manipulation of dates in Analytica. I'll introduce the encoding of d~~
ates as integers and the date origin preference. I'll review how to c~~
onfigure input variables, edit tables, or even individual columns of ~~
edit tables to accept (and parse) dates as input. I'll cover date num~~
ber format capabilities in depth, including how to create your own cu~~
stom date formats, understanding how date formats interact with your ~~
computer's regional settings, and how to restrict a date format to a ~~
single column only. We'll also see how axis scaling in graphs is date~~
-aware. ~
~
Next, we'll examine various ways to manipulate dates in Analytica exp~~
ressions. This includes use of the new and powerful functions MakeDat~~
e, DatePart, and DateAdd, and some interesting ways in which these ca~~
n be used, for example, to define date sequences. Finally, we'll prac~~
tice our array mastery by aggregating results to and from different d~~
ate granularities, such aggregating from a month sequence to a years,~~
or interpolating from years to months.
Author: Lonnie Chrisman
Date: Thu, Sep 13, 2007 10:02 AM
Saveauthor: Lonnie
Savedate: Thu, Sep 13, 2007 11:05 AM
Defaultsize: 48,24
Diagstate: 1,1,0,550,455,17
Windstate: 2,102,90,482,481
Fontstyle: Arial, 15
Fileinfo: 0,Model Manipulating_dates,2,2,0,0,W:\TestModels\Manipulatin~~
g Dates in Analytica.ANA
Variable Start_date
Title: Start Date
Definition: MakeDate(2007,8,10) + 100
Nodelocation: 104,56,1
Nodesize: 48,24
Valuestate: 2,341,167,416,303,0,MIDM
Numberformat: 2,DD,2,2,0,0,4,0,$,0,"ABBREV",0
Variable End_date
Title: End date
Definition: 9/13/ 2007
Nodelocation: 232,56,1
Nodesize: 48,24
Valuestate: 2,165,157,416,303,0,MIDM
Numberformat: 2,DD,2,2,0,0,4,0,$,0,"ABBREV",0
Variable Elapsed_days
Title: Elapsed days
Definition: End_date - Start_date
Nodelocation: 160,120,1
Nodesize: 48,24
Variable End_date_part
Title: End date part
Definition: DatePart(End_date, part)
Nodelocation: 336,120,1
Nodesize: 48,24
Valuestate: 2,564,166,403,365,0,MIDM
Index Part
Title: Part
Definition: ['y','m','MMM','MMMM','d','ddd','dddd','Dddd','w','www','w~~
www','q']
Nodelocation: 352,56,1
Nodesize: 48,24
Index The_date
Title: the date
Definition: DateAdd( Today() , 0..365, 'wd' )
Nodelocation: 88,192,1
Nodesize: 48,24
Numberformat: 2,DD,1,2,0,0,4,0,$,0,"LONG",0
{!40000|Att_previndexvalue: [39.336K,39.337K,39.338K,39.339K,39.34K,39.341K~~
,39.342K,39.343K,39.344K,39.345K,39.346K,39.347K,39.348K,39.349K,39.35K~~
,39.351K,39.352K,39.353K,39.354K,39.355K,39.356K,39.357K,39.358K,39.359K~~
,39.36K,39.361K,39.362K,39.363K,39.364K,39.365K,39.366K,39.367K,39.368K~~
,39.369K,39.37K,39.371K,39.372K,39.373K,39.374K,39.375K,39.376K,39.377K~~
,39.378K,39.379K,39.38K,39.381K,39.382K,39.383K,39.384K,39.385K,39.386K~~
,39.387K,39.388K,39.389K,39.39K,39.391K,39.392K,39.393K,39.394K,39.395K~~
,39.396K,39.397K,39.398K,39.399K,39.4K,39.401K,39.402K,39.403K,39.404K~~
,39.405K,39.406K,39.407K,39.408K,39.409K,39.41K,39.411K,39.412K,39.413K~~
,39.414K,39.415K,39.416K,39.417K,39.418K,39.419K,39.42K,39.421K,39.422K~~
,39.423K,39.424K,39.425K,39.426K,39.427K,39.428K,39.429K,39.43K,39.431K~~
,39.432K,39.433K,39.434K,39.435K,39.436K,39.437K,39.438K,39.439K,39.44K~~
,39.441K,39.442K,39.443K,39.444K,39.445K,39.446K,39.447K,39.448K,39.449K~~
,39.45K,39.451K,39.452K,39.453K,39.454K,39.455K,39.456K,39.457K,39.458K~~
,39.459K,39.46K,39.461K,39.462K,39.463K,39.464K,39.465K,39.466K,39.467K~~
,39.468K,39.469K,39.47K,39.471K,39.472K,39.473K,39.474K,39.475K,39.476K~~
,39.477K,39.478K,39.479K,39.48K,39.481K,39.482K,39.483K,39.484K,39.485K~~
,39.486K,39.487K,39.488K,39.489K,39.49K,39.491K,39.492K,39.493K,39.494K~~
,39.495K,39.496K,39.497K,39.498K,39.499K,39.5K,39.501K,39.502K,39.503K~~
,39.504K,39.505K,39.506K,39.507K,39.508K,39.509K,39.51K,39.511K,39.512K~~
,39.513K,39.514K,39.515K,39.516K,39.517K,39.518K,39.519K,39.52K,39.521K~~
,39.522K,39.523K,39.524K,39.525K,39.526K,39.527K,39.528K,39.529K,39.53K~~
,39.531K,39.532K,39.533K,39.534K,39.535K,39.536K,39.537K,39.538K,39.539K~~
,39.54K,39.541K,39.542K,39.543K,39.544K,39.545K,39.546K,39.547K,39.548K~~
,39.549K,39.55K,39.551K,39.552K,39.553K,39.554K,39.555K,39.556K,39.557K~~
,39.558K,39.559K,39.56K,39.561K,39.562K,39.563K,39.564K,39.565K,39.566K~~
,39.567K,39.568K,39.569K,39.57K,39.571K,39.572K,39.573K,39.574K,39.575K~~
,39.576K,39.577K,39.578K,39.579K,39.58K,39.581K,39.582K,39.583K,39.584K~~
,39.585K,39.586K,39.587K,39.588K,39.589K,39.59K,39.591K,39.592K,39.593K~~
,39.594K,39.595K,39.596K,39.597K,39.598K,39.599K,39.6K,39.601K,39.602K~~
,39.603K,39.604K,39.605K,39.606K,39.607K,39.608K,39.609K,39.61K,39.611K~~
,39.612K,39.613K,39.614K,39.615K,39.616K,39.617K,39.618K,39.619K,39.62K~~
,39.621K,39.622K,39.623K,39.624K,39.625K,39.626K,39.627K,39.628K,39.629K~~
,39.63K,39.631K,39.632K,39.633K,39.634K,39.635K,39.636K,39.637K,39.638K~~
,39.639K,39.64K,39.641K,39.642K,39.643K,39.644K,39.645K,39.646K,39.647K~~
,39.648K,39.649K,39.65K,39.651K,39.652K,39.653K,39.654K,39.655K,39.656K~~
,39.657K,39.658K,39.659K,39.66K,39.661K,39.662K,39.663K,39.664K,39.665K~~
,39.666K,39.667K,39.668K,39.669K,39.67K,39.671K,39.672K,39.673K,39.674K~~
,39.675K,39.676K,39.677K,39.678K,39.679K,39.68K,39.681K,39.682K,39.683K~~
,39.684K,39.685K,39.686K,39.687K,39.688K,39.689K,39.69K,39.691K,39.692K~~
,39.693K,39.694K,39.695K,39.696K,39.697K,39.698K,39.699K,39.7K,39.701K~~
]}
{!40000|Att_graphindexrange: 1,,,,,,10}
Chance Data
Title: data
Definition: cumulate( Random( Uniform(-1,1), over:the_date), the_date~~
)
Nodelocation: 208,192,1
Nodesize: 48,24
Valuestate: 2,66,69,877,485,1,MIDM
Function Date_to_text(date : Number)
Title: Date to Text
Description: Returns a textual representation of the date as mm/dd/yyy~~
y
Definition: "" & date
Nodelocation: 360,192,1
Nodesize: 48,24
Paramnames: date
Numberformat: 2,DD,0,2,0,0,4,0,$,0,"MM/dd/yyyy",0
Variable Text_date
Title: text date
Definition: Date_to_text( Today() )
Nodelocation: 248,256,1
Nodesize: 48,24
Valuestate: 2,332,105,416,303,0,MIDM
Function Wrong_way(date : coerce text)
Title: Wrong way
Definition: date
Nodelocation: 360,248,1
Nodesize: 48,24
Windstate: 2,439,72,476,224
Paramnames: date
Numberformat: 2,DD,2,2,0,0,4,0,$,0,"ABBREV",0
Variable Wrong_way_call
Title: wrong way call
Definition: Wrong_way( Today() )
Nodelocation: 256,312,1
Nodesize: 48,24
Numberformat: 2,%,4,2,0,0,4,0,$,0,"ABBREV",0
Function Parse_date(t : text)
Title: Parse Date
Description: Convert a textual date to numeric date.~
Note that the number format for this function is set to Date, so that~~
Coerce_to_num parses something that looks like a date as a date.
Definition: coerce_to_num(t)
Nodelocation: 472,192,1
Nodesize: 48,24
Windstate: 2,460,396,476,224
Paramnames: t
Numberformat: 2,DD,2,2,0,0,4,0,$,0,"ABBREV",0
Function Coerce_to_num(x : coerce number)
Title: Coerce to num
Description: Converts its parameter to a number, using the number form~~
at of the caller
Definition: x
Nodelocation: 472,248,1
Nodesize: 48,24
Paramnames: x
Variable Test_parse_date
Title: Test parse date
Definition: Parse_date( " Sep 13, 2007" )
Nodelocation: 368,312,1
Nodesize: 48,24
Numberformat: 2,DD,2,2,0,0,4,0,$,0,"ABBREV",0
Module Aggregation
Title: Aggregation
Defaultsize: 48,24
Nodelocation: 88,264,1
Nodesize: 56,24
Diagstate: 1,434,21,563,433,17
Index Day
Title: Day
Definition: today() ..DateAdd(Today(),5,'y')
Nodelocation: 88,56,1
Nodesize: 48,24
Numberformat: 2,DD,2,2,0,0,4,0,$,0,"ABBREV",0
{!40000|Att_previndexvalue: [39.336K,39.337K,39.338K,39.339K,39.34K,39.341K~~
,39.342K,39.343K,39.344K,39.345K,39.346K,39.347K,39.348K,39.349K,39.35K~~
,39.351K,39.352K,39.353K,39.354K,39.355K,39.356K,39.357K,39.358K,39.359K~~
,39.36K,39.361K,39.362K,39.363K,39.364K,39.365K,39.366K,39.367K,39.368K~~
,39.369K,39.37K,39.371K,39.372K,39.373K,39.374K,39.375K,39.376K,39.377K~~
,39.378K,39.379K,39.38K,39.381K,39.382K,39.383K,39.384K,39.385K,39.386K~~
,39.387K,39.388K,39.389K,39.39K,39.391K,39.392K,39.393K,39.394K,39.395K~~
,39.396K,39.397K,39.398K,39.399K,39.4K,39.401K,39.402K,39.403K,39.404K~~
,39.405K,39.406K,39.407K,39.408K,39.409K,39.41K,39.411K,39.412K,39.413K~~
,39.414K,39.415K,39.416K,39.417K,39.418K,39.419K,39.42K,39.421K,39.422K~~
,39.423K,39.424K,39.425K,39.426K,39.427K,39.428K,39.429K,39.43K,39.431K~~
,39.432K,39.433K,39.434K,39.435K,39.436K,39.437K,39.438K,39.439K,39.44K~~
,39.441K,39.442K,39.443K,39.444K,39.445K,39.446K,39.447K,39.448K,39.449K~~
,39.45K,39.451K,39.452K,39.453K,39.454K,39.455K,39.456K,39.457K,39.458K~~
,39.459K,39.46K,39.461K,39.462K,39.463K,39.464K,39.465K,39.466K,39.467K~~
,39.468K,39.469K,39.47K,39.471K,39.472K,39.473K,39.474K,39.475K,39.476K~~
,39.477K,39.478K,39.479K,39.48K,39.481K,39.482K,39.483K,39.484K,39.485K~~
,39.486K,39.487K,39.488K,39.489K,39.49K,39.491K,39.492K,39.493K,39.494K~~
,39.495K,39.496K,39.497K,39.498K,39.499K,39.5K,39.501K,39.502K,39.503K~~
,39.504K,39.505K,39.506K,39.507K,39.508K,39.509K,39.51K,39.511K,39.512K~~
,39.513K,39.514K,39.515K,39.516K,39.517K,39.518K,39.519K,39.52K,39.521K~~
,39.522K,39.523K,39.524K,39.525K,39.526K,39.527K,39.528K,39.529K,39.53K~~
,39.531K,39.532K,39.533K,39.534K,39.535K,39.536K,39.537K,39.538K,39.539K~~
,39.54K,39.541K,39.542K,39.543K,39.544K,39.545K,39.546K,39.547K,39.548K~~
,39.549K,39.55K,39.551K,39.552K,39.553K,39.554K,39.555K,39.556K,39.557K~~
,39.558K,39.559K,39.56K,39.561K,39.562K,39.563K,39.564K,39.565K,39.566K~~
,39.567K,39.568K,39.569K,39.57K,39.571K,39.572K,39.573K,39.574K,39.575K~~
,39.576K,39.577K,39.578K,39.579K,39.58K,39.581K,39.582K,39.583K,39.584K~~
,39.585K,39.586K,39.587K,39.588K,39.589K,39.59K,39.591K,39.592K,39.593K~~
,39.594K,39.595K,39.596K,39.597K,39.598K,39.599K,39.6K,39.601K,39.602K~~
,39.603K,39.604K,39.605K,39.606K,39.607K,39.608K,39.609K,39.61K,39.611K~~
,39.612K,39.613K,39.614K,39.615K,39.616K,39.617K,39.618K,39.619K,39.62K~~
,39.621K,39.622K,39.623K,39.624K,39.625K,39.626K,39.627K,39.628K,39.629K~~
,39.63K,39.631K,39.632K,39.633K,39.634K,39.635K,39.636K,39.637K,39.638K~~
,39.639K,39.64K,39.641K,39.642K,39.643K,39.644K,39.645K,39.646K,39.647K~~
,39.648K,39.649K,39.65K,39.651K,39.652K,39.653K,39.654K,39.655K,39.656K~~
,39.657K,39.658K,39.659K,39.66K,39.661K,39.662K,39.663K,39.664K,39.665K~~
,39.666K,39.667K,39.668K,39.669K,39.67K,39.671K,39.672K,39.673K,39.674K~~
,39.675K,39.676K,39.677K,39.678K,39.679K,39.68K,39.681K,39.682K,39.683K~~
,39.684K,39.685K,39.686K,39.687K,39.688K,39.689K,39.69K,39.691K,39.692K~~
,39.693K,39.694K,39.695K,39.696K,39.697K,39.698K,39.699K,39.7K,39.701K~~
,39.702K,39.703K,39.704K,39.705K,39.706K,39.707K,39.708K,39.709K,39.71K~~
,39.711K,39.712K,39.713K,39.714K,39.715K,39.716K,39.717K,39.718K,39.719K~~
,39.72K,39.721K,39.722K,39.723K,39.724K,39.725K,39.726K,39.727K,39.728K~~
,39.729K,39.73K,39.731K,39.732K,39.733K,39.734K,39.735K,39.736K,39.737K~~
,39.738K,39.739K,39.74K,39.741K,39.742K,39.743K,39.744K,39.745K,39.746K~~
,39.747K,39.748K,39.749K,39.75K,39.751K,39.752K,39.753K,39.754K,39.755K~~
,39.756K,39.757K,39.758K,39.759K,39.76K,39.761K,39.762K,39.763K,39.764K~~
,39.765K,39.766K,39.767K,39.768K,39.769K,39.77K,39.771K,39.772K,39.773K~~
,39.774K,39.775K,39.776K,39.777K,39.778K,39.779K,39.78K,39.781K,39.782K~~
,39.783K,39.784K,39.785K,39.786K,39.787K,39.788K,39.789K,39.79K,39.791K~~
,39.792K,39.793K,39.794K,39.795K,39.796K,39.797K,39.798K,39.799K,39.8K~~
,39.801K,39.802K,39.803K,39.804K,39.805K,39.806K,39.807K,39.808K,39.809K~~
,39.81K,39.811K,39.812K,39.813K,39.814K,39.815K,39.816K,39.817K,39.818K~~
,39.819K,39.82K,39.821K,39.822K,39.823K,39.824K,39.825K,39.826K,39.827K~~
,39.828K,39.829K,39.83K,39.831K,39.832K,39.833K,39.834K,39.835K,39.836K~~
,39.837K,39.838K,39.839K,39.84K,39.841K,39.842K,39.843K,39.844K,39.845K~~
,39.846K,39.847K,39.848K,39.849K,39.85K,39.851K,39.852K,39.853K,39.854K~~
,39.855K,39.856K,39.857K,39.858K,39.859K,39.86K,39.861K,39.862K,39.863K~~
,39.864K,39.865K,39.866K,39.867K,39.868K,39.869K,39.87K,39.871K,39.872K~~
,39.873K,39.874K,39.875K,39.876K,39.877K,39.878K,39.879K,39.88K,39.881K~~
,39.882K,39.883K,39.884K,39.885K,39.886K,39.887K,39.888K,39.889K,39.89K~~
,39.891K,39.892K,39.893K,39.894K,39.895K,39.896K,39.897K,39.898K,39.899K~~
,39.9K,39.901K,39.902K,39.903K,39.904K,39.905K,39.906K,39.907K,39.908K~~
,39.909K,39.91K,39.911K,39.912K,39.913K,39.914K,39.915K,39.916K,39.917K~~
,39.918K,39.919K,39.92K,39.921K,39.922K,39.923K,39.924K,39.925K,39.926K~~
,39.927K,39.928K,39.929K,39.93K,39.931K,39.932K,39.933K,39.934K,39.935K~~
,39.936K,39.937K,39.938K,39.939K,39.94K,39.941K,39.942K,39.943K,39.944K~~
,39.945K,39.946K,39.947K,39.948K,39.949K,39.95K,39.951K,39.952K,39.953K~~
,39.954K,39.955K,39.956K,39.957K,39.958K,39.959K,39.96K,39.961K,39.962K~~
,39.963K,39.964K,39.965K,39.966K,39.967K,39.968K,39.969K,39.97K,39.971K~~
,39.972K,39.973K,39.974K,39.975K,39.976K,39.977K,39.978K,39.979K,39.98K~~
,39.981K,39.982K,39.983K,39.984K,39.985K,39.986K,39.987K,39.988K,39.989K~~
,39.99K,39.991K,39.992K,39.993K,39.994K,39.995K,39.996K,39.997K,39.998K~~
,39.999K,40K,40.001K,40.002K,40.003K,40.004K,40.005K,40.006K,40.007K,~~
40.008K,40.009K,40.01K,40.011K,40.012K,40.013K,40.014K,40.015K,40.016K~~
,40.017K,40.018K,40.019K,40.02K,40.021K,40.022K,40.023K,40.024K,40.025K~~
,40.026K,40.027K,40.028K,40.029K,40.03K,40.031K,40.032K,40.033K,40.034K~~
,40.035K,40.036K,40.037K,40.038K,40.039K,40.04K,40.041K,40.042K,40.043K~~
,40.044K,40.045K,40.046K,40.047K,40.048K,40.049K,40.05K,40.051K,40.052K~~
,40.053K,40.054K,40.055K,40.056K,40.057K,40.058K,40.059K,40.06K,40.061K~~
,40.062K,40.063K,40.064K,40.065K,40.066K,40.067K,40.068K,40.069K,40.07K~~
,40.071K,40.072K,40.073K,40.074K,40.075K,40.076K,40.077K,40.078K,40.079K~~
,40.08K,40.081K,40.082K,40.083K,40.084K,40.085K,40.086K,40.087K,40.088K~~
,40.089K,40.09K,40.091K,40.092K,40.093K,40.094K,40.095K,40.096K,40.097K~~
,40.098K,40.099K,40.1K,40.101K,40.102K,40.103K,40.104K,40.105K,40.106K~~
,40.107K,40.108K,40.109K,40.11K,40.111K,40.112K,40.113K,40.114K,40.115K~~
,40.116K,40.117K,40.118K,40.119K,40.12K,40.121K,40.122K,40.123K,40.124K~~
,40.125K,40.126K,40.127K,40.128K,40.129K,40.13K,40.131K,40.132K,40.133K~~
,40.134K,40.135K,40.136K,40.137K,40.138K,40.139K,40.14K,40.141K,40.142K~~
,40.143K,40.144K,40.145K,40.146K,40.147K,40.148K,40.149K,40.15K,40.151K~~
,40.152K,40.153K,40.154K,40.155K,40.156K,40.157K,40.158K,40.159K,40.16K~~
,40.161K,40.162K,40.163K,40.164K,40.165K,40.166K,40.167K,40.168K,40.169K~~
,40.17K,40.171K,40.172K,40.173K,40.174K,40.175K,40.176K,40.177K,40.178K~~
,40.179K,40.18K,40.181K,40.182K,40.183K,40.184K,40.185K,40.186K,40.187K~~
,40.188K,40.189K,40.19K,40.191K,40.192K,40.193K,40.194K,40.195K,40.196K~~
,40.197K,40.198K,40.199K,40.2K,40.201K,40.202K,40.203K,40.204K,40.205K~~
,40.206K,40.207K,40.208K,40.209K,40.21K,40.211K,40.212K,40.213K,40.214K~~
,40.215K,40.216K,40.217K,40.218K,40.219K,40.22K,40.221K,40.222K,40.223K~~
,40.224K,40.225K,40.226K,40.227K,40.228K,40.229K,40.23K,40.231K,40.232K~~
,40.233K,40.234K,40.235K,40.236K,40.237K,40.238K,40.239K,40.24K,40.241K~~
,40.242K,40.243K,40.244K,40.245K,40.246K,40.247K,40.248K,40.249K,40.25K~~
,40.251K,40.252K,40.253K,40.254K,40.255K,40.256K,40.257K,40.258K,40.259K~~
,40.26K,40.261K,40.262K,40.263K,40.264K,40.265K,40.266K,40.267K,40.268K~~
,40.269K,40.27K,40.271K,40.272K,40.273K,40.274K,40.275K,40.276K,40.277K~~
,40.278K,40.279K,40.28K,40.281K,40.282K,40.283K,40.284K,40.285K,40.286K~~
,40.287K,40.288K,40.289K,40.29K,40.291K,40.292K,40.293K,40.294K,40.295K~~
,40.296K,40.297K,40.298K,40.299K,40.3K,40.301K,40.302K,40.303K,40.304K~~
,40.305K,40.306K,40.307K,40.308K,40.309K,40.31K,40.311K,40.312K,40.313K~~
,40.314K,40.315K,40.316K,40.317K,40.318K,40.319K,40.32K,40.321K,40.322K~~
,40.323K,40.324K,40.325K,40.326K,40.327K,40.328K,40.329K,40.33K,40.331K~~
,40.332K,40.333K,40.334K,40.335K,40.336K,40.337K,40.338K,40.339K,40.34K~~
,40.341K,40.342K,40.343K,40.344K,40.345K,40.346K,40.347K,40.348K,40.349K~~
,40.35K,40.351K,40.352K,40.353K,40.354K,40.355K,40.356K,40.357K,40.358K~~
,40.359K,40.36K,40.361K,40.362K,40.363K,40.364K,40.365K,40.366K,40.367K~~
,40.368K,40.369K,40.37K,40.371K,40.372K,40.373K,40.374K,40.375K,40.376K~~
,40.377K,40.378K,40.379K,40.38K,40.381K,40.382K,40.383K,40.384K,40.385K~~
,40.386K,40.387K,40.388K,40.389K,40.39K,40.391K,40.392K,40.393K,40.394K~~
,40.395K,40.396K,40.397K,40.398K,40.399K,40.4K,40.401K,40.402K,40.403K~~
,40.404K,40.405K,40.406K,40.407K,40.408K,40.409K,40.41K,40.411K,40.412K~~
,40.413K,40.414K,40.415K,40.416K,40.417K,40.418K,40.419K,40.42K,40.421K~~
,40.422K,40.423K,40.424K,40.425K,40.426K,40.427K,40.428K,40.429K,40.43K~~
,40.431K,40.432K,40.433K,40.434K,40.435K,40.436K,40.437K,40.438K,40.439K~~
,40.44K,40.441K,40.442K,40.443K,40.444K,40.445K,40.446K,40.447K,40.448K~~
,40.449K,40.45K,40.451K,40.452K,40.453K,40.454K,40.455K,40.456K,40.457K~~
,40.458K,40.459K,40.46K,40.461K,40.462K,40.463K,40.464K,40.465K,40.466K~~
,40.467K,40.468K,40.469K,40.47K,40.471K,40.472K,40.473K,40.474K,40.475K~~
,40.476K,40.477K,40.478K,40.479K,40.48K,40.481K,40.482K,40.483K,40.484K~~
,40.485K,40.486K,40.487K,40.488K,40.489K,40.49K,40.491K,40.492K,40.493K~~
,40.494K,40.495K,40.496K,40.497K,40.498K,40.499K,40.5K,40.501K,40.502K~~
,40.503K,40.504K,40.505K,40.506K,40.507K,40.508K,40.509K,40.51K,40.511K~~
,40.512K,40.513K,40.514K,40.515K,40.516K,40.517K,40.518K,40.519K,40.52K~~
,40.521K,40.522K,40.523K,40.524K,40.525K,40.526K,40.527K,40.528K,40.529K~~
,40.53K,40.531K,40.532K,40.533K,40.534K,40.535K,40.536K,40.537K,40.538K~~
,40.539K,40.54K,40.541K,40.542K,40.543K,40.544K,40.545K,40.546K,40.547K~~
,40.548K,40.549K,40.55K,40.551K,40.552K,40.553K,40.554K,40.555K,40.556K~~
,40.557K,40.558K,40.559K,40.56K,40.561K,40.562K,40.563K,40.564K,40.565K~~
,40.566K,40.567K,40.568K,40.569K,40.57K,40.571K,40.572K,40.573K,40.574K~~
,40.575K,40.576K,40.577K,40.578K,40.579K,40.58K,40.581K,40.582K,40.583K~~
,40.584K,40.585K,40.586K,40.587K,40.588K,40.589K,40.59K,40.591K,40.592K~~
,40.593K,40.594K,40.595K,40.596K,40.597K,40.598K,40.599K,40.6K,40.601K~~
,40.602K,40.603K,40.604K,40.605K,40.606K,40.607K,40.608K,40.609K,40.61K~~
,40.611K,40.612K,40.613K,40.614K,40.615K,40.616K,40.617K,40.618K,40.619K~~
,40.62K,40.621K,40.622K,40.623K,40.624K,40.625K,40.626K,40.627K,40.628K~~
,40.629K,40.63K,40.631K,40.632K,40.633K,40.634K,40.635K,40.636K,40.637K~~
,40.638K,40.639K,40.64K,40.641K,40.642K,40.643K,40.644K,40.645K,40.646K~~
,40.647K,40.648K,40.649K,40.65K,40.651K,40.652K,40.653K,40.654K,40.655K~~
,40.656K,40.657K,40.658K,40.659K,40.66K,40.661K,40.662K,40.663K,40.664K~~
,40.665K,40.666K,40.667K,40.668K,40.669K,40.67K,40.671K,40.672K,40.673K~~
,40.674K,40.675K,40.676K,40.677K,40.678K,40.679K,40.68K,40.681K,40.682K~~
,40.683K,40.684K,40.685K,40.686K,40.687K,40.688K,40.689K,40.69K,40.691K~~
,40.692K,40.693K,40.694K,40.695K,40.696K,40.697K,40.698K,40.699K,40.7K~~
,40.701K,40.702K,40.703K,40.704K,40.705K,40.706K,40.707K,40.708K,40.709K~~
,40.71K,40.711K,40.712K,40.713K,40.714K,40.715K,40.716K,40.717K,40.718K~~
,40.719K,40.72K,40.721K,40.722K,40.723K,40.724K,40.725K,40.726K,40.727K~~
,40.728K,40.729K,40.73K,40.731K,40.732K,40.733K,40.734K,40.735K,40.736K~~
,40.737K,40.738K,40.739K,40.74K,40.741K,40.742K,40.743K,40.744K,40.745K~~
,40.746K,40.747K,40.748K,40.749K,40.75K,40.751K,40.752K,40.753K,40.754K~~
,40.755K,40.756K,40.757K,40.758K,40.759K,40.76K,40.761K,40.762K,40.763K~~
,40.764K,40.765K,40.766K,40.767K,40.768K,40.769K,40.77K,40.771K,40.772K~~
,40.773K,40.774K,40.775K,40.776K,40.777K,40.778K,40.779K,40.78K,40.781K~~
,40.782K,40.783K,40.784K,40.785K,40.786K,40.787K,40.788K,40.789K,40.79K~~
,40.791K,40.792K,40.793K,40.794K,40.795K,40.796K,40.797K,40.798K,40.799K~~
,40.8K,40.801K,40.802K,40.803K,40.804K,40.805K,40.806K,40.807K,40.808K~~
,40.809K,40.81K,40.811K,40.812K,40.813K,40.814K,40.815K,40.816K,40.817K~~
,40.818K,40.819K,40.82K,40.821K,40.822K,40.823K,40.824K,40.825K,40.826K~~
,40.827K,40.828K,40.829K,40.83K,40.831K,40.832K,40.833K,40.834K,40.835K~~
,40.836K,40.837K,40.838K,40.839K,40.84K,40.841K,40.842K,40.843K,40.844K~~
,40.845K,40.846K,40.847K,40.848K,40.849K,40.85K,40.851K,40.852K,40.853K~~
,40.854K,40.855K,40.856K,40.857K,40.858K,40.859K,40.86K,40.861K,40.862K~~
,40.863K,40.864K,40.865K,40.866K,40.867K,40.868K,40.869K,40.87K,40.871K~~
,40.872K,40.873K,40.874K,40.875K,40.876K,40.877K,40.878K,40.879K,40.88K~~
,40.881K,40.882K,40.883K,40.884K,40.885K,40.886K,40.887K,40.888K,40.889K~~
,40.89K,40.891K,40.892K,40.893K,40.894K,40.895K,40.896K,40.897K,40.898K~~
,40.899K,40.9K,40.901K,40.902K,40.903K,40.904K,40.905K,40.906K,40.907K~~
,40.908K,40.909K,40.91K,40.911K,40.912K,40.913K,40.914K,40.915K,40.916K~~
,40.917K,40.918K,40.919K,40.92K,40.921K,40.922K,40.923K,40.924K,40.925K~~
,40.926K,40.927K,40.928K,40.929K,40.93K,40.931K,40.932K,40.933K,40.934K~~
,40.935K,40.936K,40.937K,40.938K,40.939K,40.94K,40.941K,40.942K,40.943K~~
,40.944K,40.945K,40.946K,40.947K,40.948K,40.949K,40.95K,40.951K,40.952K~~
,40.953K,40.954K,40.955K,40.956K,40.957K,40.958K,40.959K,40.96K,40.961K~~
,40.962K,40.963K,40.964K,40.965K,40.966K,40.967K,40.968K,40.969K,40.97K~~
,40.971K,40.972K,40.973K,40.974K,40.975K,40.976K,40.977K,40.978K,40.979K~~
,40.98K,40.981K,40.982K,40.983K,40.984K,40.985K,40.986K,40.987K,40.988K~~
,40.989K,40.99K,40.991K,40.992K,40.993K,40.994K,40.995K,40.996K,40.997K~~
,40.998K,40.999K,41K,41.001K,41.002K,41.003K,41.004K,41.005K,41.006K,~~
41.007K,41.008K,41.009K,41.01K,41.011K,41.012K,41.013K,41.014K,41.015K~~
,41.016K,41.017K,41.018K,41.019K,41.02K,41.021K,41.022K,41.023K,41.024K~~
,41.025K,41.026K,41.027K,41.028K,41.029K,41.03K,41.031K,41.032K,41.033K~~
,41.034K,41.035K,41.036K,41.037K,41.038K,41.039K,41.04K,41.041K,41.042K~~
,41.043K,41.044K,41.045K,41.046K,41.047K,41.048K,41.049K,41.05K,41.051K~~
,41.052K,41.053K,41.054K,41.055K,41.056K,41.057K,41.058K,41.059K,41.06K~~
,41.061K,41.062K,41.063K,41.064K,41.065K,41.066K,41.067K,41.068K,41.069K~~
,41.07K,41.071K,41.072K,41.073K,41.074K,41.075K,41.076K,41.077K,41.078K~~
,41.079K,41.08K,41.081K,41.082K,41.083K,41.084K,41.085K,41.086K,41.087K~~
,41.088K,41.089K,41.09K,41.091K,41.092K,41.093K,41.094K,41.095K,41.096K~~
,41.097K,41.098K,41.099K,41.1K,41.101K,41.102K,41.103K,41.104K,41.105K~~
,41.106K,41.107K,41.108K,41.109K,41.11K,41.111K,41.112K,41.113K,41.114K~~
,41.115K,41.116K,41.117K,41.118K,41.119K,41.12K,41.121K,41.122K,41.123K~~
,41.124K,41.125K,41.126K,41.127K,41.128K,41.129K,41.13K,41.131K,41.132K~~
,41.133K,41.134K,41.135K,41.136K,41.137K,41.138K,41.139K,41.14K,41.141K~~
,41.142K,41.143K,41.144K,41.145K,41.146K,41.147K,41.148K,41.149K,41.15K~~
,41.151K,41.152K,41.153K,41.154K,41.155K,41.156K,41.157K,41.158K,41.159K~~
,41.16K,41.161K,41.162K,41.163K]}
Variable X_by_day
Title: X by day
Definition: cumulate( 2*random(over:Day)-1, Day )
Nodelocation: 216,56,1
Nodesize: 48,24
Valuestate: 2,541,302,416,303,0,MIDM
Index Month
Title: Month
Definition: Day_to_month[Day = Unique(Day_to_month,Day) ]
Nodelocation: 88,120,1
Nodesize: 48,24
Valuestate: 2,56,66,428,546,0,MIDM
Numberformat: 2,DD,2,2,0,0,4,0,$,0,"ABBREV",0
{!40000|Att_previndexvalue: [39.336K,39.354K,39.385K,39.415K,39.446K,39.477K~~
,39.506K,39.537K,39.567K,39.598K,39.628K,39.659K,39.69K,39.72K,39.751K~~
,39.781K,39.812K,39.843K,39.871K,39.902K,39.932K,39.963K,39.993K,40.024K~~
,40.055K,40.085K,40.116K,40.146K,40.177K,40.208K,40.236K,40.267K,40.297K~~
,40.328K,40.358K,40.389K,40.42K,40.45K,40.481K,40.511K,40.542K,40.573K~~
,40.601K,40.632K,40.662K,40.693K,40.723K,40.754K,40.785K,40.815K,40.846K~~
,40.876K,40.907K,40.938K,40.967K,40.998K,41.028K,41.059K,41.089K,41.12K~~
,41.151K]}
Variable Day_to_month
Title: Day to month
Definition: MakeDate( DatePart(Day,'y'), DatePart(Day,'m'), 1 )
Nodelocation: 336,56,1
Nodesize: 48,24
Numberformat: 2,DD,2,2,0,0,4,0,$,0,"ABBREV",0
Variable X_by_month
Title: X by Month
Definition: Aggregate( X_by_day, Day_to_month, Day, Month )
Nodelocation: 216,120,1
Nodesize: 48,24
Valuestate: 2,528,9,416,303,1,MIDM
Function Aggregate(X, map : Array[I] ; I,J : Index)
Title: Aggregate
Description: Each element of map should be an element of J. ~
X is indexed by I. Aggregates the value of X to index J
Definition: Sum( X * (map=J), I )
Nodelocation: 376,120,1
Nodesize: 48,24
Windstate: 2,417,339,476,224
Paramnames: X,map,I,J
Variable Xm_by_day
Title: Xm by day
Definition: X_by_month [ Month = Day_to_month ]
Nodelocation: 216,184,1
Nodesize: 48,24
Valuestate: 2,28,4,497,303,1,MIDM
Variable Input_data
Title: Input data
Definition: Table(Self)(~
38.612K)
Indexvals: ['item 1']
Nodelocation: 72,256,1
Nodesize: 48,24
Defnstate: 2,524,279,416,303,0,MIDM
Numberformat: 2,DD,2,2,0,0,4,0,$,0,"ABBREV",0
Variable Compare1
Definition: [DAY,X_BY_DAY]
Indexvals: ['Day','X by day']
Nodelocation: 112,192,1
Nodesize: 48,24
Nodeinfo: 1,1,1,1,1,1,0,0,0,0
Valuestate: 2,19,310,416,303,0,MIDM
Reformval: [Self,Day]
Variable Two_columns__separat
Title: two columns, separate
Definition: Table(Self)(~
37.89K,9-27-2007)
Indexvals: [Date1,'dollar amt']
Nodelocation: 72,321,1
Nodesize: 48,31
Defnstate: 2,124,313,416,303,0,MIDM
Numberformat: 2,F,4,2,0,1,4,0,$,0,"ABBREV",0
Constant Date1
Title: date
Definition: 0
Nodelocation: 208,256,1
Nodesize: 48,24
Numberformat: 2,DD,2,2,0,0,4,0,$,0,"ABBREV",0
Close Aggregation
Close Manipulating_dates