Report Transfer

TRANSFER (by day) <% xnumerodias=0 for i=lbound(TransDias) to ubound(TransDias) %> <% if TransDias(i,0)>0 then xnumerodias=xnumerodias+1 end if next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xtotalsamq1=xtotalsamq1+TransDias(i,21) next %> <% if xtotalsamq1>0 then %> <% else%> <%end if%> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xstotalsamq1=xstotalsamq1+TransDias(i,22) next %> <% if xstotalsamq1>0 then %> <% else%> <%end if%> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xOBbd1f=xOBbd1f+TransDias(i,28) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xOBbd1l=xOBbd1l+TransDias(i,30) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xtotalsamqtyOB1s=xtotalsamqtyOB1s+TransDias(i,36) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xtotalsamqtyOB2s=xtotalsamqtyOB2s+TransDias(i,37) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xtotalsamqtyOB3s=xtotalsamqtyOB3s+TransDias(i,38) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xtotalsamqtyOB=xtotalsamqtyOB+TransDias(i,24) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xOBbd3f=xOBbd3f+TransDias(i,29) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xOBbd3l=xOBbd3l+TransDias(i,31) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xtotalsamqtyOBbd31s=xtotalsamqtyOBbd31s+TransDias(i,39) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xtotalsamqtyOBbd32s=xtotalsamqtyOBbd32s+TransDias(i,40) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xtotalsamqtyOBbd33s=xtotalsamqtyOBbd33s+TransDias(i,41) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xtotalsamqtyOBbd3=xtotalsamqtyOBbd3+TransDias(i,27) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xtotf=xtotf+TransDias(i,28)+TransDias(i,29) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xtotl=xtotl+TransDias(i,30)+TransDias(i,31) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xtotalsamqtyOBbd31=xtotalsamqtyOBbd31+TransDias(i,36)+TransDias(i,39) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xtotalsamqtyOBbd32=xtotalsamqtyOBbd32+TransDias(i,37)+TransDias(i,40) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xtotalsamqtyOBbd33=xtotalsamqtyOBbd33+TransDias(i,38)+TransDias(i,41) next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,1)>0 then%> <%else%> <% end if xtott=xtott+TransDias(i,24)+TransDias(i,27) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xtotalsamm2OB=xtotalsamm2OB+TransDias(i,25) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xtotalsamamtOB=xtotalsamamtOB+TransDias(i,26) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xtotalsamqty=xtotalsamqty+TransDias(i,1) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xtotalsamm2=xtotalsamm2+TransDias(i,2) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xtotalsamamt=xtotalsamamt+TransDias(i,3) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xtotalothqty=xtotalothqty+TransDias(i,4) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xtotalothm2=xtotalothm2+TransDias(i,5) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xtotalothamt=xtotalothamt+TransDias(i,6) next %> <% m2=0 if m2=1 then %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xtotalsamqty1s=xtotalsamqty1s+TransDias(i,10) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xtotalsamqty2s=xtotalsamqty2s+TransDias(i,11) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xtotalsamqty3s=xtotalsamqty3s+TransDias(i,12) next %> <% end if ''''''''''''''''''''''''''''''''''''''''''''''''''''*************************** RESUMEN OFFSET %> <% xnumerodias=0 for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% if TransDiasoff(i,0)>0 then xnumerodias=xnumerodias+1 end if next %> <% ''''' qty bd1 %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xm21sbd2=xm21sbd2+TransDiasoff(i,1) next %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xamtbd21=xamtbd21+TransDiasoff(i,4) next %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xtotqty1sbd2=xtotqty1sbd2+TransDiasoff(i,7) next %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xamt2bd21=xamt2bd21+TransDiasoff(i,10) next %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xM22sbd2=xM22sbd2+TransDiasoff(i,2) next %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xamtbd22=xamtbd22+TransDiasoff(i,5) next %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xtotqty2sbd2=xtotqty2sbd2+TransDiasoff(i,8) next %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xamt2bd22=xamt2bd22+TransDiasoff(i,11) next %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xM23sbd2=xM23sbd2+TransDiasoff(i,3) next %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xamtbd23=xamtbd23+TransDiasoff(i,6) next %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xtotqty3sbd2=xtotqty3sbd2+TransDiasoff(i,9) next %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xamt2bd23=xamt2bd23+TransDiasoff(i,12) next %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xqtytotbd2=xqtytotbd2+TransDiasoff(i,1)+TransDiasoff(i,2)+TransDiasoff(i,3) next %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xamttotbd2=xamttotbd2+TransDiasoff(i,4)+TransDiasoff(i,5)+TransDiasoff(i,6) next %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xqty2totbd2=xqty2totbd2+TransDiasoff(i,7)+TransDiasoff(i,8)+TransDiasoff(i,9) next %> <% for i=lbound(TransDiasoff) to ubound(TransDiasoff) %> <% xtotamt2bd2=xtotamt2bd2+(TransDiasoff(i,10)+TransDiasoff(i,11)+TransDiasoff(i,12)) next %> <% '''''******************************** FIN resumen por WH %> <% xnumerodias=0 for i=lbound(TransDias) to ubound(TransDias) %> <% if TransDias(i,0)>0 then xnumerodias=xnumerodias+1 end if next %> <% ''''' qty bd1 %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xm21sbd1=xm21sbd1+TransDias(i,45) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xM22sbd1=xM22sbd1+TransDias(i,46) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xM23sbd1=xM23sbd1+TransDias(i,47) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xM2totbd1=xM2totbd1+TransDias(i,45)+TransDias(i,46)+TransDias(i,47) xtotm2shbd1=xtotm2shbd1+TransDias(i,83)+TransDias(i,86)+TransDias(i,89) next %> <% ''''' M2 bd1 end %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% 'xtotm2shbd1=xtotm2shbd1+TransDias(i,83)+TransDias(i,86)+TransDias(i,89) next %> <% ''''' M2 bd3 %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xM21sbd3=xM21sbd3+TransDias(i,54) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xM22sbd3=xM22sbd3+TransDias(i,55) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xM23sbd3=xM23sbd3+TransDias(i,56) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xM2totbd3=xM2totbd3+TransDias(i,54)+TransDias(i,55)+TransDias(i,56) xtotm2shbd3=(xtotm2shbd3+TransDias(i,92)+TransDias(i,95)+TransDias(i,98)) next %> <% ''''' M2 bd3 end %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% 'xtotm2shbd3=xtotm2shbd3+TransDias(i,92)+TransDias(i,95)+TransDias(i,98) next %> <% ''''' QTY bd1 %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xqty1sbd1=xqty1sbd1+TransDias(i,42) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xqty2sbd1=xqty2sbd1+TransDias(i,43) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xqty3sbd1=xqty3sbd1+TransDias(i,44) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xQtytotbd1=xQtytotbd1+TransDias(i,42)+TransDias(i,43)+TransDias(i,44) xtotqtyshbd1=(xtotqtyshbd1+TransDias(i,82)+TransDias(i,85)+TransDias(i,88)) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% 'xtotqtyshbd1=xtotqtyshbd1+TransDias(i,82)+TransDias(i,85)+TransDias(i,88) next %> <% ''''' QTY bd1 end %> <% ''''' QTY bd3 %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xqty1sbd3=xqty1sbd3+TransDias(i,51) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xqty2sbd3=xqty2sbd3+TransDias(i,52) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xqty3sbd3=xqty3sbd3+TransDias(i,53) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xQtytotbd3=xQtytotbd3+TransDias(i,51)+TransDias(i,52)+TransDias(i,53) xtotqtyshbd3=(xtotqtyshbd3+TransDias(i,91)+TransDias(i,94)+TransDias(i,97)) next %> <% ''''' QTY bd3 end %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% 'xtotqtyshbd3=xtotqtyshbd3+TransDias(i,91)+TransDias(i,94)+TransDias(i,97) next %> <% ''''' Amt bd1 %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xAMT1sbd1=xAMT1sbd1+TransDias(i,48) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xAMT2sbd1=xAMT2sbd1+TransDias(i,49) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xAMT3sbd1=xAMT3sbd1+TransDias(i,50) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xAMTtotbd1=xAMTtotbd1+TransDias(i,48)+TransDias(i,49)+TransDias(i,50) xtotamtshbd1=(xtotamtshbd1+TransDias(i,84)+TransDias(i,87)+TransDias(i,90)) next %> <% ''''' Amt bd1 end %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% 'xtotamtshbd1=xtotamtshbd1+TransDias(i,84)+TransDias(i,87)+TransDias(i,90) next %> <% ''''' Amt bd3 %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xAMT1sbd3=xAMT1sbd3+TransDias(i,57) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xAMT2sbd3=xAMT2sbd3+TransDias(i,58) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xAMT3sbd3=xAMT3sbd3+TransDias(i,59) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xAMTtotbd3=xAMTtotbd3+TransDias(i,57)+TransDias(i,58)+TransDias(i,59) xtotamtshbd3=(xtotamtshbd3+TransDias(i,93)+TransDias(i,96)+TransDias(i,99)) next %> <% ''''' Amt bd3 end %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% 'xtotamtshbd3=xtotamtshbd3+TransDias(i,93)+TransDias(i,96)+TransDias(i,99) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xtotalqty=xtotalqty+TransDias(i,7) xtotqtysh=xtotqtysh+TransDias(i,79) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% 'xtotqtysh=xtotqtysh+TransDias(i,79) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xtotalm2=xtotalm2+TransDias(i,8) xtotm2sh=xtotm2sh+TransDias(i,80) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% 'xtotm2sh=xtotm2sh+TransDias(i,80) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% xtotalamt=xtotalamt+TransDias(i,9) xtotamtsh=xtotamtsh+TransDias(i,81) next %> <% for i=lbound(TransDias) to ubound(TransDias) %> <% 'xtotamtsh=xtotamtsh+TransDias(i,81) next %> <% for i=lbound(TransDias) to ubound(TransDias) 'dias del mes Headcount hcmes=month(date()) hcyear=year(date()) hcdias=int(TransDias(i,0)) hcmes=int(mid(lfecinicio,5,2)) hcyear=int(mid(lfecinicio,1,4)) if hcdias>0 then 'response.write(hcdias&" ") 'response.write(hcmes&" ") 'response.write(hcyear) Set Rsheadc2 = Server.CreateObject("ADODB.RecordSet") set Rsheadc2=dbsql3.execute("select * from headcount where dia=" & hcdias & " and mes=" & hcmes & " and anno=" & hcyear) 'dia=" & hcdias & " and If Rsheadc2.EOF And Rsheadc2.BOF Then ' lturnotot=1 else 'lturno1t=0 'lturno2t=0 'lturno3t=0 lturnotot=0 Rsheadc2.movefirst Do While Not Rsheadc2.EOF if Rsheadc2("planta")=1 or Rsheadc2("planta")=3 or Rsheadc2("planta")=4 then 'if Rsheadc("turno")=1 then 'lturno1t=lturno1t+cdbl(Rsheadc("directo"))+cdbl(Rsheadc("indirecto")) 'end if 'if Rsheadc("turno")=2 then 'lturno2t=lturno2t+cdbl(Rsheadc("directo"))+cdbl(Rsheadc("indirecto")) 'end if 'if Rsheadc("turno")=3 then 'lturno3t=lturno3t+cdbl(Rsheadc("directo"))+cdbl(Rsheadc("indirecto")) 'end if 'if Rsheadc("dia")=hcdias then lturnotot=lturnotot+cdbl(Rsheadc2("directo"))+cdbl(Rsheadc2("indirecto")) 'end if end if Rsheadc2.MoveNext Loop end if Rsheadc2.close set Rsheadc2=nothing else lturnotot=1 end if TransDias(i,60)=lturnotot 'fin Headcount if lturnotot>1 then %> <% xtotalavgqty=xtotalavgqty+TransDias(i,7)/TransDias(i,60) else %> <% end if next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,60)>1 then %> <% xtotalavgm2=xtotalavgm2+TransDias(i,8)/TransDias(i,60) else %> <% end if next %> <% for i=lbound(TransDias) to ubound(TransDias) if TransDias(i,60)>1 then %> <% xtotalavgamt=xtotalavgamt+TransDias(i,9)/TransDias(i,60) else %> <% end if next %>

<%=MonthName(Month(Date), False) %> Generated: <%=time%>		<%=TransDias(i,0)%>	TOTAL	AVG
Samsung VB		<%=formatnumber(TransDias(i,21),0)%>	<%=formatnumber(xtotalsamq1,0)%>	<%=formatnumber(xtotalsamq1/xnumerodias,0)%>	<%=formatnumber(0,0)%>
Samsung Others		<%=formatnumber(TransDias(i,22),0)%>	<%=formatnumber(xstotalsamq1,0)%>	<%=formatnumber(xstotalsamq1/xnumerodias,0)%>	<%=formatnumber(0,0)%>
Samsung O/B QTY	BD 1 Prod F	<%=formatnumber(TransDias(i,28),0)%>	<%=formatnumber(TransDias(i,28),0)%>	<%=formatnumber(xOBbd1f,0)%>	<%=formatnumber(xOBbd1f/xnumerodias,0)%>
	BD 1 Prod L	<%=formatnumber(TransDias(i,30),0)%>	<%=formatnumber(TransDias(i,30),0)%>	<%=formatnumber(xOBbd1l,0)%>	<%=formatnumber(xOBbd1l/xnumerodias,0)%>
	T 1S	<%=formatnumber(TransDias(i,36),0)%>	<%=formatnumber(TransDias(i,36),0)%>	<%=formatnumber(xtotalsamqtyOB1s,0)%>	<%=formatnumber(xtotalsamqtyOB1s/xnumerodias,0)%>
	T 2S	<%=formatnumber(TransDias(i,37),0)%>	<%=formatnumber(TransDias(i,37),0)%>	<%=formatnumber(xtotalsamqtyOB2s,0)%>	<%=formatnumber(xtotalsamqtyOB2s/xnumerodias,0)%>
	T 3S	<%=formatnumber(TransDias(i,38),0)%>	<%=formatnumber(TransDias(i,38),0)%>	<%=formatnumber(xtotalsamqtyOB3s,0)%>	<%=formatnumber(xtotalsamqtyOB3s/xnumerodias,0)%>
	BD 1 Trans	<%=formatnumber(TransDias(i,24),0)%>	<%=formatnumber(TransDias(i,24),0)%>	<%=formatnumber(xtotalsamqtyOB,0)%>	<%=formatnumber(xtotalsamqtyOB/xnumerodias,0)%>
	BD 3 Prod F	<%=formatnumber(TransDias(i,29),0)%>	<%=formatnumber(TransDias(i,29),0)%>	<%=formatnumber(xOBbd3f,0)%>	<%=formatnumber(xOBbd3f/xnumerodias,0)%>
	BD 3 Prod L	<%=formatnumber(TransDias(i,31),0)%>	<%=formatnumber(TransDias(i,31),0)%>	<%=formatnumber(xOBbd3l,0)%>	<%=formatnumber(xOBbd3l/xnumerodias,0)%>
	1S	<%=formatnumber(TransDias(i,39),0)%>	<%=formatnumber(TransDias(i,39),0)%>	<%=formatnumber(xtotalsamqtyOBbd31s,0)%>	<%=formatnumber(xtotalsamqtyOBbd31s/xnumerodias,0)%>
	2S	<%=formatnumber(TransDias(i,40),0)%>	<%=formatnumber(TransDias(i,40),0)%>	<%=formatnumber(xtotalsamqtyOBbd32s,0)%>	<%=formatnumber(xtotalsamqtyOBbd32s/xnumerodias,0)%>
	3S	<%=formatnumber(TransDias(i,41),0)%>	<%=formatnumber(TransDias(i,41),0)%>	<%=formatnumber(xtotalsamqtyOBbd33s,0)%>	<%=formatnumber(xtotalsamqtyOBbd33s/xnumerodias,0)%>
	BD 3 Trans	<%=formatnumber(TransDias(i,27),0)%>	<%=formatnumber(TransDias(i,27),0)%>	<%=formatnumber(xtotalsamqtyOBbd3,0)%>	<%=formatnumber(xtotalsamqtyOBbd3/xnumerodias,0)%>
	Total Prod	<%=formatnumber(TransDias(i,28)+TransDias(i,29),0)%>	<%=formatnumber(TransDias(i,28)+TransDias(i,29),0)%>	<%=formatnumber(xtotf,0)%>	<%=formatnumber(xtotf/xnumerodias,0)%>
	Total Prod	<%=formatnumber(TransDias(i,30)+TransDias(i,31),0)%>	<%=formatnumber(TransDias(i,30)+TransDias(i,31),0)%>	<%=formatnumber(xtotl,0)%>	<%=formatnumber(xtotl/xnumerodias,0)%>
	1s:	<%=formatnumber(TransDias(i,36)+TransDias(i,39),0)%>	<%=formatnumber(TransDias(i,36)+TransDias(i,39),0)%>	<%=formatnumber(xtotalsamqtyOBbd31,0)%>	<%=formatnumber(xtotalsamqtyOBbd31/xnumerodias,0)%>
	2s:	<%=formatnumber(TransDias(i,37)+TransDias(i,40),0)%>	<%=formatnumber(TransDias(i,37)+TransDias(i,40),0)%>	<%=formatnumber(xtotalsamqtyOBbd32,0)%>	<%=formatnumber(xtotalsamqtyOBbd32/xnumerodias,0)%>
	3s:	<%=formatnumber(TransDias(i,38)+TransDias(i,41),0)%>	<%=formatnumber(TransDias(i,38)+TransDias(i,41),0)%>	<%=formatnumber(xtotalsamqtyOBbd33,0)%>	<%=formatnumber(xtotalsamqtyOBbd33/xnumerodias,0)%>
	Total Trans	<%=formatnumber(TransDias(i,24)+TransDias(i,27),0)%>	<%=formatnumber(TransDias(i,24)+TransDias(i,27),0)%>	<%=formatnumber(xtott,0)%>	<%=formatnumber(xtott/xnumerodias,0)%>
Samsung O/B M2		<%=formatnumber(TransDias(i,25),0)%>	<%=formatnumber(xtotalsamm2OB,0)%>	<%=formatnumber(xtotalsamm2OB/xnumerodias,0)%>
Samsung O/B AMT		<%=formatnumber(TransDias(i,26),0)%>	<%=formatnumber(xtotalsamamtOB,0)%>	<%=formatnumber(xtotalsamamtOB/xnumerodias,0)%>
Samsung QTY		<%=formatnumber(TransDias(i,1),0)%>	<%=formatnumber(xtotalsamqty,0)%>	<%=formatnumber(xtotalsamqty/xnumerodias,0)%>
Samsung M2		<%=formatnumber(TransDias(i,2),0)%>	<%=formatnumber(xtotalsamm2,0)%>	<%=formatnumber(xtotalsamm2/xnumerodias,0)%>
Samsung AMT		<%=formatnumber(TransDias(i,3),0)%>	<%=formatnumber(xtotalsamamt,0)%>	<%=formatnumber(xtotalsamamt/xnumerodias,0)%>
Others QTY		<%=formatnumber(TransDias(i,4),0)%>	<%=formatnumber(xtotalothqty,0)%>	<%=formatnumber(xtotalothqty/xnumerodias,0)%>
Others M2		<%=formatnumber(TransDias(i,5),0)%>	<%=formatnumber(xtotalothm2,0)%>	<%=formatnumber(xtotalothm2/xnumerodias,0)%>
Others AMT		<%=formatnumber(TransDias(i,6),0)%>	<%=formatnumber(xtotalothamt,0)%>	<%=formatnumber(xtotalothamt/xnumerodias,0)%>
Qty 1S		<%=formatnumber(TransDias(i,10),0)%>	<%=formatnumber(xtotalsamqty1s,0)%>	<%=formatnumber(xtotalsamqty1s/xnumerodias,0)%>
Qty 2S		<%=formatnumber(TransDias(i,11),0)%>	<%=formatnumber(xtotalsamqty2s,0)%>	<%=formatnumber(xtotalsamqty2s/xnumerodias,0)%>
Qty 3S		<%=formatnumber(TransDias(i,12),0)%>	<%=formatnumber(xtotalsamqty3s,0)%>	<%=formatnumber(xtotalsamqty3s/xnumerodias,0)%>

Summary Transfer OFFSET
<%=MonthName(Month(Date), False) %> Generated: <%=time%>		<%=TransDiasoff(i,0)%>	TOTAL	AVG
BD2 LABEL	1S Samsung	<%=formatnumber(TransDiasoff(i,1),0)%>	<%=formatnumber(xM21sbd2,0)%>	<%=formatnumber(xM21sbd2/xnumerodias,0)%>
	AMT	<%=formatnumber(TransDiasoff(i,4),0)%>	<%=formatnumber(xamtbd21,0)%>	<%=formatnumber(xamtbd21/xnumerodias,0)%>
	Others	<%=formatnumber(TransDiasoff(i,7),0)%>	<%=formatnumber(xtotqty1sbd2,0)%>	<%=formatnumber(xtotqty1sbd2/xnumerodias,0)%>
	AMT	<%=formatnumber(TransDiasoff(i,10),0)%>	<%=formatnumber(xamt2bd21,0)%>	<%=formatnumber(xamt2bd21/xnumerodias,0)%>
	2S Samsung	<%=formatnumber(TransDiasoff(i,2),0)%>	<%=formatnumber(xM22sbd2,0)%>	<%=formatnumber(xM22sbd2/xnumerodias,0)%>
	AMT	<%=formatnumber(TransDiasoff(i,5),0)%>	<%=formatnumber(xamtbd22,0)%>	<%=formatnumber(xamtbd22/xnumerodias,0)%>
	Others	<%=formatnumber(TransDiasoff(i,8),0)%>	<%=formatnumber(xtotqty2sbd2,0)%>	<%=formatnumber(xtotqty2sbd2/xnumerodias,0)%>
	AMT	<%=formatnumber(TransDiasoff(i,11),0)%>	<%=formatnumber(xamt2bd22,0)%>	<%=formatnumber(xamt2bd22/xnumerodias,0)%>
	3S Samsung	<%=formatnumber(TransDiasoff(i,3),0)%>	<%=formatnumber(xM23sbd2,0)%>	<%=formatnumber(xM23sbd2/xnumerodias,0)%>
	AMT	<%=formatnumber(TransDiasoff(i,6),0)%>	<%=formatnumber(xamtbd23,0)%>	<%=formatnumber(xamtbd23/xnumerodias,0)%>
	Others	<%=formatnumber(TransDiasoff(i,9),0)%>	<%=formatnumber(xtotqty3sbd2,0)%>	<%=formatnumber(xtotqty3sbd2/xnumerodias,0)%>
	AMT	<%=formatnumber(TransDiasoff(i,12),0)%>	<%=formatnumber(xamt2bd23,0)%>	<%=formatnumber(xamt2bd23/xnumerodias,0)%>
BD2	Tot Samsung	<%=formatnumber(TransDiasoff(i,1)+TransDiasoff(i,2)+TransDiasoff(i,3),0)%>	<%=formatnumber(xqtytotbd2,0)%>	<%=formatnumber(xqtytotbd2/xnumerodias,0)%>
	AMT	<%=formatnumber(TransDiasoff(i,4)+TransDiasoff(i,5)+TransDiasoff(i,6),0)%>	<%=formatnumber(xamttotbd2,0)%>	<%=formatnumber(xamttotbd2/xnumerodias,0)%>
	Tot Others	<%=formatnumber(TransDiasoff(i,7)+TransDiasoff(i,8)+TransDiasoff(i,9),0)%>	<%=formatnumber(xqty2totbd2,0)%>	<%=formatnumber(xqty2totbd2/xnumerodias,0)%>
	AMT	<%=formatnumber(TransDiasoff(i,10)+TransDiasoff(i,11)+TransDiasoff(i,12),0)%>	<%=formatnumber(xtotamt2bd2,0)%>	<%=formatnumber(xtotamt2bd2/xnumerodias,0)%>

Summary Transfer by Shift/Building
<%=MonthName(Month(Date), False) %> Generated: <%=time%>		<%=TransDias(i,0)%>	TOTAL	AVG
BD1 M2	1S	<%=formatnumber(TransDias(i,45),0)%>	<%=formatnumber(xM21sbd1,0)%>	<%=formatnumber(xM21sbd1/xnumerodias,0)%>
BD1 M2	2S	<%=formatnumber(TransDias(i,46),0)%>	<%=formatnumber(xM22sbd1,0)%>	<%=formatnumber(xM22sbd1/xnumerodias,0)%>
BD1 M2	3S	<%=formatnumber(TransDias(i,47),0)%>	<%=formatnumber(xM23sbd1,0)%>	<%=formatnumber(xM23sbd1/xnumerodias,0)%>
BOX BD1	Tot M2	<%=formatnumber(TransDias(i,45)+TransDias(i,46)+TransDias(i,47)-(TransDias(i,83)+TransDias(i,86)+TransDias(i,89)),0)%>	<%=formatnumber(xM2totbd1-xtotm2shbd1,0)%>	<%=formatnumber((xM2totbd1-xtotm2shbd1)/xnumerodias,0)%>
Total Sheets M2 BD1		<%=formatnumber(TransDias(i,83)+TransDias(i,86)+TransDias(i,89),0)%>	<%=formatnumber(xtotm2shbd1,0)%>	<%=formatnumber(xtotm2shbd1/xnumerodias,0)%>
BD3 M2	1S	<%=formatnumber(TransDias(i,54),0)%>	<%=formatnumber(xM21sbd3,0)%>	<%=formatnumber(xM21sbd3/xnumerodias,0)%>
BD3 M2	2S	<%=formatnumber(TransDias(i,55),0)%>	<%=formatnumber(xM22sbd3,0)%>	<%=formatnumber(xM22sbd3/xnumerodias,0)%>
BD3 M2	3S	<%=formatnumber(TransDias(i,56),0)%>	<%=formatnumber(xM23sbd3,0)%>	<%=formatnumber(xM23sbd3/xnumerodias,0)%>
BOX BD3	Tot M2	<%=formatnumber(TransDias(i,54)+TransDias(i,55)+TransDias(i,56)-(TransDias(i,92)+TransDias(i,95)+TransDias(i,98)),0)%>	<%=formatnumber(xM2totbd3-xtotm2shbd3,0)%>	<%=formatnumber((xM2totbd3-xtotm2shbd3)/xnumerodias,0)%>
Total Sheets M2 BD3		<%=formatnumber(TransDias(i,92)+TransDias(i,95)+TransDias(i,98),0)%>	<%=formatnumber(xtotm2shbd3,0)%>	<%=formatnumber(xtotm2shbd3/xnumerodias,0)%>
BD1 QTY	1S	<%=formatnumber(TransDias(i,42),0)%>	<%=formatnumber(xqty1sbd1,0)%>	<%=formatnumber(xqty1sbd1/xnumerodias,0)%>
BD1 QTY	2S	<%=formatnumber(TransDias(i,43),0)%>	<%=formatnumber(xqty2sbd1,0)%>	<%=formatnumber(xqty2sbd1/xnumerodias,0)%>
BD1 QTY	3S	<%=formatnumber(TransDias(i,44),0)%>	<%=formatnumber(xqty3sbd1,0)%>	<%=formatnumber(xqty3sbd1/xnumerodias,0)%>
BOX BD1	Tot QTY	<%=formatnumber(TransDias(i,42)+TransDias(i,43)+TransDias(i,44)-(TransDias(i,82)+TransDias(i,85)+TransDias(i,88)),0)%>	<%=formatnumber(xQtytotbd1-xtotqtyshbd1,0)%>	<%=formatnumber((xQtytotbd1-xtotqtyshbd1)/xnumerodias,0)%>
Total Sheets QTY BD1		<%=formatnumber(TransDias(i,82)+TransDias(i,85)+TransDias(i,88),0)%>	<%=formatnumber(xtotqtyshbd1,0)%>	<%=formatnumber(xtotqtyshbd1/xnumerodias,0)%>
BD3 QTY	1S	<%=formatnumber(TransDias(i,51),0)%>	<%=formatnumber(xqty1sbd3,0)%>	<%=formatnumber(xqty1sbd3/xnumerodias,0)%>
BD3 QTY	2S	<%=formatnumber(TransDias(i,52),0)%>	<%=formatnumber(xqty2sbd3,0)%>	<%=formatnumber(xqty2sbd3/xnumerodias,0)%>
BD3 QTY	3S	<%=formatnumber(TransDias(i,53),0)%>	<%=formatnumber(xqty3sbd3,0)%>	<%=formatnumber(xqty3sbd3/xnumerodias,0)%>
BOX BD3	Tot QTY	<%=formatnumber(TransDias(i,51)+TransDias(i,52)+TransDias(i,53)-(TransDias(i,91)+TransDias(i,94)+TransDias(i,97)),0)%>	<%=formatnumber(xQtytotbd3-xtotqtyshbd3,0)%>	<%=formatnumber((xQtytotbd3-xtotqtyshbd3)/xnumerodias,0)%>
Total Sheets QTY BD3		<%=formatnumber(TransDias(i,91)+TransDias(i,94)+TransDias(i,97),0)%>	<%=formatnumber(xtotqtyshbd3,0)%>	<%=formatnumber(xtotqtyshbd3/xnumerodias,0)%>
BD1 Amt($)	1S	<%=formatnumber(TransDias(i,48),0)%>	<%=formatnumber(xAMT1sbd1,0)%>	<%=formatnumber(xAMT1sbd1/xnumerodias,0)%>
BD1 Amt($)	2S	<%=formatnumber(TransDias(i,49),0)%>	<%=formatnumber(xAMT2sbd1,0)%>	<%=formatnumber(xAMT2sbd1/xnumerodias,0)%>
BD1 Amt($)	3S	<%=formatnumber(TransDias(i,50),0)%>	<%=formatnumber(xAMT3sbd1,0)%>	<%=formatnumber(xAMT3sbd1/xnumerodias,0)%>
BOX BD1	Tot Amt($)	<%=formatnumber(TransDias(i,48)+TransDias(i,49)+TransDias(i,50)-(TransDias(i,84)+TransDias(i,87)+TransDias(i,90)),0)%>	<%=formatnumber(xAMTtotbd1-xtotamtshbd1,0)%>	<%=formatnumber((xAMTtotbd1-xtotamtshbd1)/xnumerodias,0)%>
Total Sheets AMT BD1		<%=formatnumber(TransDias(i,84)+TransDias(i,87)+TransDias(i,90),0)%>	<%=formatnumber(xtotamtshbd1,0)%>	<%=formatnumber(xtotamtshbd1/xnumerodias,0)%>
BD3 Amt($)	1S	<%=formatnumber(TransDias(i,57),0)%>	<%=formatnumber(xAMT1sbd3,0)%>	<%=formatnumber(xAMT1sbd3/xnumerodias,0)%>
BD3 Amt($)	2S	<%=formatnumber(TransDias(i,58),0)%>	<%=formatnumber(xAMT2sbd3,0)%>	<%=formatnumber(xAMT2sbd3/xnumerodias,0)%>
BD3 Amt($)	3S	<%=formatnumber(TransDias(i,59),0)%>	<%=formatnumber(xAMT3sbd3,0)%>	<%=formatnumber(xAMT3sbd3/xnumerodias,0)%>
BOX BD3	Tot Amt($)	<%=formatnumber(TransDias(i,57)+TransDias(i,58)+TransDias(i,59)-(TransDias(i,93)+TransDias(i,96)+TransDias(i,99)),0)%>	<%=formatnumber(xAMTtotbd3- xtotamtshbd3,0)%>	<%=formatnumber((xAMTtotbd3- xtotamtshbd3)/xnumerodias,0)%>
Total Sheets AMT BD3		<%=formatnumber(TransDias(i,93)+TransDias(i,96)+TransDias(i,99),0)%>	<%=formatnumber(xtotamtshbd3,0)%>	<%=formatnumber(xtotamtshbd3/xnumerodias,0)%>
TOTAL
Total BOX QTY		<%=formatnumber(TransDias(i,42)+TransDias(i,43)+TransDias(i,44)+TransDias(i,51)+TransDias(i,52)+TransDias(i,53)-TransDias(i,79),0)%>	<%=formatnumber(xtotalqty-xtotqtysh,0)%>	<%=formatnumber((xtotalqty-xtotqtysh)/xnumerodias,0)%>
Total Sheets QTY		<%=formatnumber(TransDias(i,79),0)%>	<%=formatnumber(xtotqtysh,0)%>	<%=formatnumber(xtotqtysh/xnumerodias,0)%>
Total BOX M2		<%=formatnumber(TransDias(i,45)+TransDias(i,46)+TransDias(i,47)+TransDias(i,54)+TransDias(i,55)+TransDias(i,56)-TransDias(i,80),0)%>	<%=formatnumber(xtotalm2-xtotm2sh,0)%>	<%=formatnumber((xtotalm2-xtotm2sh)/xnumerodias,0)%>
Total Sheets M2		<%=formatnumber(TransDias(i,80),0)%>	<%=formatnumber(xtotm2sh,0)%>	<%=formatnumber(xtotm2sh/xnumerodias,0)%>
Total BOX AMT		<%=formatnumber(TransDias(i,48)+TransDias(i,49)+TransDias(i,50)+TransDias(i,57)+TransDias(i,58)+TransDias(i,59)-TransDias(i,81),0)%>	<%=formatnumber(xtotalamt-xtotamtsh,0)%>	<%=formatnumber((xtotalamt-xtotamtsh)/xnumerodias,0)%>
Total Sheets AMT		<%=formatnumber(TransDias(i,81),0)%>	<%=formatnumber(xtotamtsh,0)%>	<%=formatnumber(xtotamtsh/xnumerodias,0)%>
Avg QTY		<%=formatnumber((TransDias(i,42)+TransDias(i,43)+TransDias(i,44)+TransDias(i,51)+TransDias(i,52)+TransDias(i,53))/TransDias(i,60),0)%>	<%=formatnumber(1,0)%>	<%=formatnumber(xtotalavgqty,0)%>	<%=formatnumber(xtotalavgqty/xnumerodias,0)%>
Avg M2		<%=formatnumber((TransDias(i,45)+TransDias(i,46)+TransDias(i,47)+TransDias(i,54)+TransDias(i,55)+TransDias(i,56))/TransDias(i,60),0)%>	<%=formatnumber(1,0)%>	<%=formatnumber(xtotalavgm2,0)%>	<%=formatnumber(xtotalavgm2/xnumerodias,0)%>
Avg AMT		<%=formatnumber((TransDias(i,48)+TransDias(i,49)+TransDias(i,50)+TransDias(i,57)+TransDias(i,58)+TransDias(i,59))/TransDias(i,60),0)%>	<%=formatnumber(1,0)%>	<%=formatnumber(xtotalavgamt,0)%>	<%=formatnumber(xtotalavgamt/xnumerodias,0)%>