||
How to design other Trend Pages from DAILY
Next, I will explain how to use page Daily page to generate Weekly, Bi-Weekly, and Monthly Trends:
Copy and paste the page Daily, and name it as Weekly.
Go to Page DATA
From GZ, group5 (GV3:GZ32) columns as This week,
group second 5(GQ3:GU32) columns as last week,
group the third5 (GL3:GP32) columns as before week,
Go back to Page WKLY:
put =AVERAGE(DATA!GV3:DATA!GZ3) in (F3): and
put=AVERAGE(DATA!GQ3:DATA!GU3) in (E3):
put=AVERAGE(DATA!GL3:DATA!GP3) in (D3):
Copy (D3:F3)and Paste to (D4:F32)
Check the Values to make shure:
D3==AVERAGE(DATA!GL3:DATA!GP3)
E3=AVERAGE(DATA!GQ3:DATA!GU3)
F3=AVERAGE(DATA!GV3:DATA!GZ3)
And
D2=SQRT(SUMSQ(WKLY!D3:D32))
E2=SQRT(SUMSQ(WKLY!E3:E32))
F2=SQRT(SUMSQ(WKLY!F3:F32))
G2=E2/D2
H2=F2/E2
G3=E3/D3/G$2
H3=F3/E3/H$2
I3=H3/G3
J3=H3*G3
The weekly page is done.
Repeat these, but group the DATA 10 columns, instead of 5, per Bi-Week from GZ
To generate a 2WKLY
Repeat, but group the DATA 20 columns, instead of 5, per MONTH from GZ
To generate a MONTHLY
Pages of TRENDS are done.
Archiver|手机版|科学网 ( 京ICP备07017567号-12 )
GMT+8, 2024-10-19 23:17
Powered by ScienceNet.cn
Copyright © 2007- 中国科学报社