How to calculate weighted average for date and square feet

 



Store Details
Store Date Square
Number Type Opened Feet
       
32 Express 12/4/00  2,600
37 Standard 6/6/01  3,100
41 20/20 3/27/06  4,225
91 20/20 1/14/08  3,100
101 Standard 3/8/01  2,936
108 20/20 11/14/07  4,396
136 Express 8/14/09  2,250
160 Standard 1/14/06  2,919
171 Standard 1/22/18  3,325
188 20/20 3/5/16  4,226
230 Express 1/30/07  2,400
288 20/20 3/1/10  4,112
299 Standard 3/26/11  3,210
302 Express 1/14/08  2,673
315 20/20 6/29/02  4,000
367 20/20 2/1/05  4,100
376 20/20 1/14/08  4,181
472 Express 6/29/01  2,648
492 20/20 1/31/05  3,142
507 Standard 6/1/10  2,911
520 Standard 3/17/98  2,969
539 Standard 9/12/01  2,969
543 20/20 8/9/01  3,233
576 Standard 2/7/97  2,885
611 Standard 2/7/97  2,803
679 Standard 1/27/98  2,827
722 20/20 11/14/06  3,944
728 Express 5/6/12  1,860
742 Standard 8/1/09  2,340
753 Express 6/4/98  1,225
755 Express 1/30/93  1,558
757 Express 2/14/86  1,750
775 Express 8/21/06  1,368
796 Express 7/18/12  1,426
804 Express 1/16/90  748
810 Express 6/18/68  836
817 Express 4/15/71  1,270
845 Standard 6/17/72  2,204
866 Express 3/12/77  1,551
953 Express 11/2/69  1,551
988 Express 2/27/08  1,850
Total / WAVG 41 9/29/00  109,621
       
Express 17 10/2/95  1,750
Standard 13 6/18/01  2,860
20/20 11 12/24/06  3,903

<!–table {mso-displayed-decimal-separator:”.”; mso-displayed-thousand-separator:”,”;} @page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;} td {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:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl63 {font-size:8.0pt; font-weight:700; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none; background:#E7E6E6; mso-pattern:black none;} .xl64 {font-size:8.0pt; font-weight:700; text-align:center; vertical-align:middle; background:#E7E6E6; mso-pattern:black none;} .xl65 {font-size:8.0pt; vertical-align:middle;} .xl66 {color:white; font-size:8.0pt; font-weight:700; text-decoration:underline; text-underline-style:single-accounting; text-align:center-across; vertical-align:middle; background:#595959; mso-pattern:black none;} .xl67 {font-size:8.0pt; text-align:center; vertical-align:middle;} .xl68 {color:white; font-size:8.0pt; font-weight:700; text-align:center; vertical-align:middle; background:#595959; mso-pattern:black none;} .xl69 {color:white; font-size:8.0pt; font-weight:700; text-decoration:underline; text-underline-style:single-accounting; text-align:center-across; vertical-align:middle;} .xl70 {font-size:8.0pt; font-weight:700; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:#E7E6E6; mso-pattern:black none;} .xl71 {font-size:8.0pt; font-weight:700; text-align:center; vertical-align:middle; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:#E7E6E6; mso-pattern:black none;} .xl72 {font-size:8.0pt; mso-number-format:0; text-align:center; vertical-align:middle; border-top:none; border-right:none; border-bottom:.5pt hairline windowtext; border-left:none; background:#FFF2CC; mso-pattern:black none;} .xl73 {font-size:8.0pt; mso-number-format:0; text-align:center; vertical-align:middle; border-top:none; border-right:none; border-bottom:.5pt hairline windowtext; border-left:none;} .xl74 {font-size:8.0pt; mso-number-format:0; text-align:center; vertical-align:middle; border-top:.5pt hairline windowtext; border-right:none; border-bottom:.5pt hairline windowtext; border-left:none;} .xl75 {font-size:8.0pt; mso-number-format:0; text-align:center; vertical-align:middle; border-top:.5pt hairline windowtext; border-right:none; border-bottom:none; border-left:none;} .xl76 {font-size:8.0pt; mso-number-format:”Short Date”; text-align:center; vertical-align:middle; border-top:none; border-right:none; border-bottom:.5pt hairline windowtext; border-left:none; background:#FFF2CC; mso-pattern:black none;} .xl77 {font-size:8.0pt; font-weight:700; mso-number-format:0; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:#FFF2CC; mso-pattern:black none;} .xl78 {font-size:8.0pt; font-weight:700; mso-number-format:”_(* #,##0_);_(* \(#,##0\);_(* 022-022_);_(@_)”; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:#FFF2CC; mso-pattern:black none;} .xl79 {font-size:8.0pt; font-weight:700; mso-number-format:”Short Date”; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:#FFF2CC; mso-pattern:black none;} .xl80 {color:#005109; font-size:8.0pt; font-weight:700; mso-number-format:”Short Date”; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:#FFF2CC; mso-pattern:black none;} .xl81 {color:#005109; font-size:8.0pt; font-weight:700; mso-number-format:”_(* #,##0_);_(* \(#,##0\);_(* 022-022_);_(@_)”; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:#FFF2CC; mso-pattern:black none;} –>



Store Details
Store Date Square
Number Type Opened Feet
       
988 Express 2/27/08 1850
953 Express 11/2/69 1551
866 Express 3/12/77 1551
845 Standard 6/17/72 2204
817 Express 4/15/71 1270
810 Express 6/18/68 836
804 Express 1/16/90 748
796 Express 7/18/12 1426
775 Express 8/21/06 1368
757 Express 2/14/86 1750
755 Express 1/30/93 1558
753 Express 6/4/98 1225
742 Standard 8/1/09 2340
728 Express 5/6/12 1860
722 20/20 11/14/06 3944
679 Standard 1/27/98 2827
611 Standard 2/7/97 2803
576 Standard 2/7/97 2885
543 20/20 8/9/01 3233
539 Standard 9/12/01 2969
520 Standard 3/17/98 2969
507 Standard 6/1/10 2911
492 20/20 1/31/05 3142
472 Express 6/29/01 2648
376 20/20 1/14/08 4181
367 20/20 2/1/05 4100
315 20/20 6/29/02 4000
302 Express 1/14/08 2673
299 Standard 3/26/11 3210
288 20/20 3/1/10 4112
230 Express 1/30/07 2400
188 20/20 3/5/16 4226
171 Standard 1/22/18 3325
160 Standard 1/14/06 2919
136 Express 8/14/09 2250
108 20/20 11/14/07 4396
101 Standard 3/8/01 2936
91 20/20 1/14/08 3100
41 20/20 3/27/06 4225
37 Standard 6/6/01 3100
32 Express 12/4/00 2600
Total / WAVG 41    109,621
       
Express 17    1,739
Standard 13    2,877
20/20 11    3,878

 

By: Jordan

Leave a Reply

Your email address will not be published. Required fields are marked *