xionhack Posted April 20, 2010 Share Posted April 20, 2010 Hi, Im trying to make a monthly activity sheet. I attached a file to show the exact way how im trying to make it. I have to generate the dates for every month, and for example, if a month starts with a friday, then the first day to put the activity would be a friday. If you see the excel file you can understand better. Can somebody help me? thanks <head> <meta http-equiv=Content-Type content="text/html; charset=windows-1252"> <meta name=ProgId content=Excel.Sheet> <meta name=Generator content="Microsoft Excel 12"> <link rel=File-List href="activity_files/filelist.xml"> <style id="activity_12690_Styles"> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} .xl1512690 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;} .xl6312690 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:.5pt solid windowtext; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;} .xl6412690 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:center; vertical-align:middle; border:.5pt solid windowtext; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;} .xl6512690 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:center; vertical-align:bottom; border:.5pt solid windowtext; background:#538ED5; mso-pattern:black none; white-space:nowrap;} --> </style> </head> <body> <!--[if !excel]> <![endif]--> <!--The following information was generated by Microsoft Office Excel's Publish as Web Page wizard.--> <!--If the same item is republished from Excel, all information between the DIV tags will be replaced.--> <!-----------------------------> <!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD --> <!-----------------------------> <div id="activity_12690" align=center x:publishsource="Excel"> <table border=0 cellpadding=0 cellspacing=0 width=2164 style='border-collapse: collapse;table-layout:fixed;width:1623pt'> <col width=116 style='mso-width-source:userset;mso-width-alt:4242;width:87pt'> <col width=64 span=8 style='width:48pt'> <col width=64 style='width:48pt'> <col width=64 span=23 style='width:48pt'> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1512690 width=116 style='height:15.0pt;width:87pt'></td> <td class=xl1512690 width=64 style='width:48pt'></td> <td colspan=3 class=xl6512690 width=192 style='width:144pt'>1 WEEK</td> <td colspan=7 class=xl6512690 width=448 style='border-left:none;width:336pt'>2 WEEK</td> <td colspan=7 class=xl6512690 width=448 style='border-left:none;width:336pt'>3 WEEK</td> <td colspan=7 class=xl6512690 width=448 style='border-left:none;width:336pt'>4 WEEK</td> <td colspan=6 class=xl6512690 width=384 style='border-left:none;width:288pt'>5 WEEK</td> <td class=xl1512690 width=64 style='width:48pt'></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl6312690 style='height:15.0pt'>Full Name</td> <td class=xl6312690 style='border-left:none'>Time</td> <td class=xl6312690 style='border-top:none;border-left:none'>T</td> <td class=xl6312690 style='border-top:none;border-left:none'>F</td> <td class=xl6312690 style='border-top:none;border-left:none'>S</td> <td class=xl6312690 style='border-top:none;border-left:none'>S</td> <td class=xl6312690 style='border-top:none;border-left:none'>M</td> <td class=xl6312690 style='border-top:none;border-left:none'>T</td> <td class=xl6312690 style='border-top:none;border-left:none'>W</td> <td class=xl6312690 style='border-top:none;border-left:none'>T</td> <td class=xl6312690 style='border-top:none;border-left:none'>F</td> <td class=xl6312690 style='border-top:none;border-left:none'>S</td> <td class=xl6312690 style='border-top:none;border-left:none'>S</td> <td class=xl6312690 style='border-top:none;border-left:none'>M</td> <td class=xl6312690 style='border-top:none;border-left:none'>T</td> <td class=xl6312690 style='border-top:none;border-left:none'>W</td> <td class=xl6312690 style='border-top:none;border-left:none'>T</td> <td class=xl6312690 style='border-top:none;border-left:none'>F</td> <td class=xl6312690 style='border-top:none;border-left:none'>S</td> <td class=xl6312690 style='border-top:none;border-left:none'>S</td> <td class=xl6312690 style='border-top:none;border-left:none'>M</td> <td class=xl6312690 style='border-top:none;border-left:none'>T</td> <td class=xl6312690 style='border-top:none;border-left:none'>W</td> <td class=xl6312690 style='border-top:none;border-left:none'>T</td> <td class=xl6312690 style='border-top:none;border-left:none'>F</td> <td class=xl6312690 style='border-top:none;border-left:none'>S</td> <td class=xl6312690 style='border-top:none;border-left:none'>S</td> <td class=xl6312690 style='border-top:none;border-left:none'>M</td> <td class=xl6312690 style='border-top:none;border-left:none'>T</td> <td class=xl6312690 style='border-top:none;border-left:none'>W</td> <td class=xl6312690 style='border-top:none;border-left:none'>T</td> <td class=xl6312690 style='border-top:none;border-left:none'>F</td> <td class=xl1512690></td> </tr> <tr height=20 style='height:15.0pt'> <td rowspan=3 height=60 class=xl6412690 style='height:45.0pt;border-top:none'>FIRST MEMBER</td> <td class=xl6312690 style='border-top:none;border-left:none'>Mor</td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl1512690></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl6312690 style='height:15.0pt;border-top:none; border-left:none'>Aft</td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl1512690></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl6312690 style='height:15.0pt;border-top:none; border-left:none'>Eve</td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl1512690></td> </tr> <tr height=20 style='height:15.0pt'> <td rowspan=3 height=60 class=xl6412690 style='height:45.0pt;border-top:none'>SECOND MEMBER</td> <td class=xl6312690 style='border-top:none;border-left:none'>Mor</td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl1512690></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl6312690 style='height:15.0pt;border-top:none; border-left:none'>Aft</td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl1512690></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl6312690 style='height:15.0pt;border-top:none; border-left:none'>Eve</td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl6312690 style='border-top:none;border-left:none'> </td> <td class=xl1512690></td> </tr> <![if supportMisalignedColumns]> <tr height=0 style='display:none'> <td width=116 style='width:87pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> </tr> <![endif]> </table> </div> <!-----------------------------> <!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD--> <!-----------------------------> </body> </html> Link to comment https://forums.phpfreaks.com/topic/199082-monthly-activity/ Share on other sites More sharing options...
Ken2k7 Posted April 20, 2010 Share Posted April 20, 2010 What do you need help with? You've only told us what you are doing, but you never stated the issue or anything. Is this a PHP issue? If it's a HTML issue, please direct your inquiry in that forum instead. Link to comment https://forums.phpfreaks.com/topic/199082-monthly-activity/#findComment-1044988 Share on other sites More sharing options...
xionhack Posted April 20, 2010 Author Share Posted April 20, 2010 My problem is, where u see "first member" and "second member", i want names be generated from a database, also, every single square, u will put a number, 1 or 2 that are codes specifying the attendance, at the end, i want in a table called "attendance" to be saved, the date, the member id (the id of the member that it says the name of) and the code that i put in the square. Also, all those squares i want them to be generated automatically depending on the month. Let me know if this is more clear Link to comment https://forums.phpfreaks.com/topic/199082-monthly-activity/#findComment-1045001 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.