It turned out that I needed to export to docx and xlsx and see which out turned out better. Or i have to filter the data between excel and word. This is for the contract: consumable parts for all city-owned v.
var oneDay = 24*60*60*1000; // hours*minutes*seconds*milliseconds var firstDate = new Date("03/01/2013") var secondDate = new Date() var diffDays = Math.round(Math.abs((firstDate.getTime() - secondDate.getTime())/(oneDay)))
Other Lucky Numbers: <script language="JavaScript">
var oneDay = 24*60*60*1000; // hours*minutes*seconds*milliseconds var firstDate = new Date("03/01/2013") var secondDate = new Date() var diffDays = Math.round(Math.abs((firstDate.getTime() - secondDate.getTime())/(oneDay)))
for (i=15; i<=167; i=i+37) { num = Math.floor(Math.random()*100); var lott = (((i-3)*7 + diffDays*5 + num*7 + (i+3)*diffDays*44)%56)+1; document.write(" - " + lott); }
<script language="JavaScript"> var today = new Date()
var month = today.getMonth() + 1 var day = today.getDate() var year = today.getFullYear() var s = '/' document.write("Today\'s date: "+ month + s + day + s + year) document.write("<br/>") </script> </FONT></TD> </TR> </TABLE>
<!-- 4th table, for list of WEBSITE, CONTACT, FOLDERS AND DUE DATES. -->
<!-- row 3, d3, r4-5, to show Tech store Req header -->
<TR HEIGHT=25 >
<TD colspan="3" ALIGN=LEFT BGCOLOR=#FFFFFF ><B><FONT style=FONT-SIZE:24pt FACE="Cambria" COLOR=#1f00ff>Tech Store Orders Due Date:</FONT></B></TD> </TR>
<!-- row 3, d3, r4-5, this is to show actual date -->
<TR HEIGHT=72 >
<TD colspan="3" ALIGN=LEFT BGCOLOR=#FFFFFF ><FONT style=FONT-SIZE:32pt FACE="Calibri" COLOR=#000000>
<script language="JavaScript"> var m_names = new Array("December", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November"); var today = new Date() var dueDate = today.getDate() today.setDate(dueDate + 14) var month = today.getMonth()+1 var day = today.getDate() var year = today.getFullYear() var s = '/' document.write(m_names[month] + " " + day + ", " + year) </script> </FONT></TD> </TR>
<!-- row 3, d3, r6-7 this is to show Vehicle POs header -->
<TR HEIGHT=25 >
<TD colspan="3" ALIGN=LEFT BGCOLOR=#FFFFFF ><B><FONT style=FONT-SIZE:24pt FACE="Cambria" COLOR=#1f00ff>
LP Vehicle Orders on Term Contract:</FONT></B></TD> </TR>
<!-- row 3, d3, r6-7, this is to show actual date -->
<TR HEIGHT=22 >
<TD colspan="3" ALIGN=LEFT BGCOLOR=#FFFFFF ><FONT style=FONT-SIZE:32pt FACE="Calibri" COLOR=#000000>
<script language="JavaScript"> var today = new Date() var dueDate = today.getDate() today.setDate(dueDate + 90)
var month = today.getMonth() + 1 var day = today.getDate() var year = today.getFullYear() var s = '/'
document.write(month + s + day + s + year) document.write("<br/>");
</script>
<br /> </FONT></TD> </TR>
<!-- row 3, d3, r8, this is to show actual date --> <TR HEIGHT=20 >
<TD colspan="3" ALIGN=left BGCOLOR=#FFFFFF ><FONT style=FONT-SIZE:15pt FACE="Calibri" COLOR=#0000ff>
<script language="JavaScript">
document.write("Tire taxes are:"); document.write("<br/>"); document.write("5 -- $8.75"); document.write("<br/>"); document.write("6 -- $10.5"); document.write("<br/>"); document.write("7 -- $12.25"); document.write("<br/>"); document.write("<br/>"); var rate = 1.75 var s = '/' var t = '$'
for (i=4; i<=8; i=i+1) { var tax = i*rate; document.write(t+tax); }
</script>
<br /> </FONT></TD> </TR>
</TABLE>
<!-- This is random garbage -->
<script language="JavaScript">
<select name="_ctl0:cp_BODY_CONTENT:NameSearchBody:dl_NAME_SEARCH_AGENCY_NO" id="_ctl0_cp_BODY_CONTENT_NameSearchBody_dl_NAME_SEARCH_AGENCY_NO" style="width:590px;"> <option selected="selected" value="ALL">All Agencies</option> <option value="70">311 Customer Service Center</option> <option value="191">Access Appeals Commission</option> <option value="13">Adult Probation Department</option> <option value="26">Aging and Adult Services, Department of</option> <option value="27">Airport (San Francisco International - SFIA)</option> <option value="76">Animal Care and Control</option> <option value="28">Arts Commission</option> <option value="62">Asian Art Museum</option> <option value="1AAB">Assessment Appeals Board</option> <option value="2">Assessor-Recorder</option> <option value="707">Back Streets Business Advisory Board</option> <option value="37">Board of Appeals</option> <option value="1">Board of Supervisors</option> <option value="19">Building Inspection, Department of</option> <option value="60">California Academy of Sciences</option
</select>
<input type="submit" name="_ctl0:cp_BODY_CONTENT:NameSearchBody:btn_SUBMIT_NAME_SEARCH" value="Submit" id="_ctl0_cp_BODY_CONTENT_NameSearchBody_btn_SUBMIT_NAME_SEARCH" title="Enter your searech arguments above and press to search the directory." style="width:90px;" /> </script>
<script language="JavaScript"> //timer vars var startTime; var timer1:int; var texture1: GUITexture; function Update(){TimerStart();} function TimerStart(){ startTime = Time.time; //time starter timer1 = Time.time; //Set time if(timer1 > 5){ //<-------the number here are the seconds you want Debug.Log ("Time is over, render texture now"); //Here we just enable a GUI texture on the screen (create a GUItexture and disable it) texture1.enabled = true; } } </script>