I have a sheet of sales with 7 blocks of daily data, Sunday to Sat. one block for each day. They are by store, down, and dept, across.
I have another spreadsheet report with 34 taps, one for each store. Each with one block for each day of the week. I need to look up values from the sheet of sales into each of the store tabs by day of the week, and dept.
I think it should be some type of V/H-LOOKUp formula but am lost on how to build it. Or it might be an Offset formula. I am toally not sure what to do.
Below I posted some test data sheets like what I will be using. The file names will need to be change to real ones later.
I not yet have rights to add file attachments here.
After the Sheets of sales is a test report from one of the Store report tabs. There are some notes in the first 2 days to see what I ma looking for.
I hope am I clear about what I need. If not please ask me anything.
Many thanks!!
File name is Sheets of sales Sunday Test data
STORE 1 2 3 4 5 6
3 $361.00 $719.00 $1,077.00 $1,435.00 $1,793.00 $2,151.00
5 $363.00 $721.00 $1,079.00 $1,437.00 $1,795.00 $2,153.00
6 $364.00 $722.00 $1,080.00 $1,438.00 $1,796.00 $2,154.00
7 $365.00 $723.00 $1,081.00 $1,439.00 $1,797.00 $2,155.00
8 $366.00 $724.00 $1,082.00 $1,440.00 $1,798.00 $2,156.00
9 $367.00 $725.00 $1,083.00 $1,441.00 $1,799.00 $2,157.00
10 $368.00 $726.00 $1,084.00 $1,442.00 $1,800.00 $2,158.00
11 $369.00 $727.00 $1,085.00 $1,443.00 $1,801.00 $2,159.00
12 $370.00 $728.00 $1,086.00 $1,444.00 $1,802.00 $2,160.00
14 $372.00 $730.00 $1,088.00 $1,446.00 $1,804.00 $2,162.00
15 $373.00 $731.00 $1,089.00 $1,447.00 $1,805.00 $2,163.00
16 $374.00 $732.00 $1,090.00 $1,448.00 $1,806.00 $2,164.00
17 $375.00 $733.00 $1,091.00 $1,449.00 $1,807.00 $2,165.00
18 $376.00 $734.00 $1,092.00 $1,450.00 $1,808.00 $2,166.00
19 $377.00 $735.00 $1,093.00 $1,451.00 $1,809.00 $2,167.00
20 $378.00 $736.00 $1,094.00 $1,452.00 $1,810.00 $2,168.00
21 $379.00 $737.00 $1,095.00 $1,453.00 $1,811.00 $2,169.00
22 $380.00 $738.00 $1,096.00 $1,454.00 $1,812.00 $2,170.00
23 $381.00 $739.00 $1,097.00 $1,455.00 $1,813.00 $2,171.00
24 $382.00 $740.00 $1,098.00 $1,456.00 $1,814.00 $2,172.00
25 $383.00 $741.00 $1,099.00 $1,457.00 $1,815.00 $2,173.00
26 $384.00 $742.00 $1,100.00 $1,458.00 $1,816.00 $2,174.00
27 $385.00 $743.00 $1,101.00 $1,459.00 $1,817.00 $2,175.00
28 $386.00 $744.00 $1,102.00 $1,460.00 $1,818.00 $2,176.00
29 $387.00 $745.00 $1,103.00 $1,461.00 $1,819.00 $2,177.00
30 $388.00 $746.00 $1,104.00 $1,462.00 $1,820.00 $2,178.00
31 $389.00 $747.00 $1,105.00 $1,463.00 $1,821.00 $2,179.00
32 $390.00 $748.00 $1,106.00 $1,464.00 $1,822.00 $2,180.00
33 $391.00 $749.00 $1,107.00 $1,465.00 $1,823.00 $2,181.00
34 $392.00 $750.00 $1,108.00 $1,466.00 $1,824.00 $2,182.00
37 $395.00 $753.00 $1,111.00 $1,469.00 $1,827.00 $2,185.00
38 $396.00 $754.00 $1,112.00 $1,470.00 $1,828.00 $2,186.00
43 $401.00 $759.00 $1,117.00 $1,475.00 $1,833.00 $2,191.00
44 $402.00 $760.00 $1,118.00 $1,476.00 $1,834.00 $2,192.00
48 $406.00 $764.00 $1,122.00 $1,480.00 $1,838.00 $2,196.00
82 $440.00 $798.00 $1,156.00 $1,514.00 $1,872.00 $2,230.00
83 $441.00 $799.00 $1,157.00 $1,515.00 $1,873.00 $2,231.00
86 $444.00 $802.00 $1,160.00 $1,518.00 $1,876.00 $2,234.00
96 $454.00 $812.00 $1,170.00 $1,528.00 $1,886.00 $2,244.00
99 $457.00 $815.00 $1,173.00 $1,531.00 $1,889.00 $2,247.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Monday
STORE 1 2 3 4 5 6
3 $163.00 $323.00 $483.00 $643.00 $803.00 $963.00
5 $165.00 $325.00 $485.00 $645.00 $805.00 $965.00
6 $166.00 $326.00 $486.00 $646.00 $806.00 $966.00
7 $167.00 $327.00 $487.00 $647.00 $807.00 $967.00
8 $168.00 $328.00 $488.00 $648.00 $808.00 $968.00
9 $169.00 $329.00 $489.00 $649.00 $809.00 $969.00
10 $170.00 $330.00 $490.00 $650.00 $810.00 $970.00
11 $171.00 $331.00 $491.00 $651.00 $811.00 $971.00
12 $172.00 $332.00 $492.00 $652.00 $812.00 $972.00
14 $174.00 $334.00 $494.00 $654.00 $814.00 $974.00
15 $175.00 $335.00 $495.00 $655.00 $815.00 $975.00
16 $176.00 $336.00 $496.00 $656.00 $816.00 $976.00
17 $177.00 $337.00 $497.00 $657.00 $817.00 $977.00
18 $178.00 $338.00 $498.00 $658.00 $818.00 $978.00
19 $179.00 $339.00 $499.00 $659.00 $819.00 $979.00
20 $180.00 $340.00 $500.00 $660.00 $820.00 $980.00
21 $181.00 $341.00 $501.00 $661.00 $821.00 $981.00
22 $182.00 $342.00 $502.00 $662.00 $822.00 $982.00
23 $183.00 $343.00 $503.00 $663.00 $823.00 $983.00
24 $184.00 $344.00 $504.00 $664.00 $824.00 $984.00
25 $185.00 $345.00 $505.00 $665.00 $825.00 $985.00
26 $186.00 $346.00 $506.00 $666.00 $826.00 $986.00
27 $187.00 $347.00 $507.00 $667.00 $827.00 $987.00
28 $188.00 $348.00 $508.00 $668.00 $828.00 $988.00
29 $189.00 $349.00 $509.00 $669.00 $829.00 $989.00
30 $190.00 $350.00 $510.00 $670.00 $830.00 $990.00
31 $191.00 $351.00 $511.00 $671.00 $831.00 $991.00
32 $192.00 $352.00 $512.00 $672.00 $832.00 $992.00
33 $193.00 $353.00 $513.00 $673.00 $833.00 $993.00
34 $194.00 $354.00 $514.00 $674.00 $834.00 $994.00
37 $197.00 $357.00 $517.00 $677.00 $837.00 $997.00
38 $198.00 $358.00 $518.00 $678.00 $838.00 $998.00
43 $203.00 $363.00 $523.00 $683.00 $843.00 $1,003.00
44 $204.00 $364.00 $524.00 $684.00 $844.00 $1,004.00
48 $208.00 $368.00 $528.00 $688.00 $848.00 $1,008.00
82 $242.00 $402.00 $562.00 $722.00 $882.00 $1,042.00
83 $243.00 $403.00 $563.00 $723.00 $883.00 $1,043.00
86 $246.00 $406.00 $566.00 $726.00 $886.00 $1,046.00
96 $256.00 $416.00 $576.00 $736.00 $896.00 $1,056.00
99 $259.00 $419.00 $579.00 $739.00 $899.00 $1,059.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Tuesday
STORE Dept 1 Dept 2 Dept 3 Dept 4 Dept 5 Dept 6
3 $127.00 $251.00 $375.00 $499.00 $623.00 $747.00
5 $129.00 $253.00 $377.00 $501.00 $625.00 $749.00
6 $130.00 $254.00 $378.00 $502.00 $626.00 $750.00
7 $131.00 $255.00 $379.00 $503.00 $627.00 $751.00
8 $132.00 $256.00 $380.00 $504.00 $628.00 $752.00
9 $133.00 $257.00 $381.00 $505.00 $629.00 $753.00
10 $134.00 $258.00 $382.00 $506.00 $630.00 $754.00
11 $135.00 $259.00 $383.00 $507.00 $631.00 $755.00
12 $136.00 $260.00 $384.00 $508.00 $632.00 $756.00
14 $138.00 $262.00 $386.00 $510.00 $634.00 $758.00
15 $139.00 $263.00 $387.00 $511.00 $635.00 $759.00
16 $140.00 $264.00 $388.00 $512.00 $636.00 $760.00
17 $141.00 $265.00 $389.00 $513.00 $637.00 $761.00
18 $142.00 $266.00 $390.00 $514.00 $638.00 $762.00
19 $143.00 $267.00 $391.00 $515.00 $639.00 $763.00
20 $144.00 $268.00 $392.00 $516.00 $640.00 $764.00
21 $145.00 $269.00 $393.00 $517.00 $641.00 $765.00
22 $146.00 $270.00 $394.00 $518.00 $642.00 $766.00
23 $147.00 $271.00 $395.00 $519.00 $643.00 $767.00
24 $148.00 $272.00 $396.00 $520.00 $644.00 $768.00
25 $149.00 $273.00 $397.00 $521.00 $645.00 $769.00
26 $150.00 $274.00 $398.00 $522.00 $646.00 $770.00
27 $151.00 $275.00 $399.00 $523.00 $647.00 $771.00
28 $152.00 $276.00 $400.00 $524.00 $648.00 $772.00
29 $153.00 $277.00 $401.00 $525.00 $649.00 $773.00
30 $154.00 $278.00 $402.00 $526.00 $650.00 $774.00
31 $155.00 $279.00 $403.00 $527.00 $651.00 $775.00
32 $156.00 $280.00 $404.00 $528.00 $652.00 $776.00
33 $157.00 $281.00 $405.00 $529.00 $653.00 $777.00
34 $158.00 $282.00 $406.00 $530.00 $654.00 $778.00
37 $161.00 $285.00 $409.00 $533.00 $657.00 $781.00
38 $162.00 $286.00 $410.00 $534.00 $658.00 $782.00
43 $167.00 $291.00 $415.00 $539.00 $663.00 $787.00
44 $168.00 $292.00 $416.00 $540.00 $664.00 $788.00
48 $172.00 $296.00 $420.00 $544.00 $668.00 $792.00
82 $206.00 $330.00 $454.00 $578.00 $702.00 $826.00
83 $207.00 $331.00 $455.00 $579.00 $703.00 $827.00
86 $210.00 $334.00 $458.00 $582.00 $706.00 $830.00
96 $220.00 $344.00 $468.00 $592.00 $716.00 $840.00
99 $223.00 $347.00 $471.00 $595.00 $719.00 $843.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Wednesday
STORE 1 2 3 4 5 6
3 $793.00 $1,583.00 $2,373.00 $3,163.00 $3,953.00 $4,743.00
5 $795.00 $1,585.00 $2,375.00 $3,165.00 $3,955.00 $4,745.00
6 $796.00 $1,586.00 $2,376.00 $3,166.00 $3,956.00 $4,746.00
7 $797.00 $1,587.00 $2,377.00 $3,167.00 $3,957.00 $4,747.00
8 $798.00 $1,588.00 $2,378.00 $3,168.00 $3,958.00 $4,748.00
9 $799.00 $1,589.00 $2,379.00 $3,169.00 $3,959.00 $4,749.00
10 $800.00 $1,590.00 $2,380.00 $3,170.00 $3,960.00 $4,750.00
11 $801.00 $1,591.00 $2,381.00 $3,171.00 $3,961.00 $4,751.00
12 $802.00 $1,592.00 $2,382.00 $3,172.00 $3,962.00 $4,752.00
14 $804.00 $1,594.00 $2,384.00 $3,174.00 $3,964.00 $4,754.00
15 $805.00 $1,595.00 $2,385.00 $3,175.00 $3,965.00 $4,755.00
16 $806.00 $1,596.00 $2,386.00 $3,176.00 $3,966.00 $4,756.00
17 $807.00 $1,597.00 $2,387.00 $3,177.00 $3,967.00 $4,757.00
18 $808.00 $1,598.00 $2,388.00 $3,178.00 $3,968.00 $4,758.00
19 $809.00 $1,599.00 $2,389.00 $3,179.00 $3,969.00 $4,759.00
20 $810.00 $1,600.00 $2,390.00 $3,180.00 $3,970.00 $4,760.00
21 $811.00 $1,601.00 $2,391.00 $3,181.00 $3,971.00 $4,761.00
22 $812.00 $1,602.00 $2,392.00 $3,182.00 $3,972.00 $4,762.00
23 $813.00 $1,603.00 $2,393.00 $3,183.00 $3,973.00 $4,763.00
24 $814.00 $1,604.00 $2,394.00 $3,184.00 $3,974.00 $4,764.00
25 $815.00 $1,605.00 $2,395.00 $3,185.00 $3,975.00 $4,765.00
26 $816.00 $1,606.00 $2,396.00 $3,186.00 $3,976.00 $4,766.00
27 $817.00 $1,607.00 $2,397.00 $3,187.00 $3,977.00 $4,767.00
28 $818.00 $1,608.00 $2,398.00 $3,188.00 $3,978.00 $4,768.00
29 $819.00 $1,609.00 $2,399.00 $3,189.00 $3,979.00 $4,769.00
30 $820.00 $1,610.00 $2,400.00 $3,190.00 $3,980.00 $4,770.00
31 $821.00 $1,611.00 $2,401.00 $3,191.00 $3,981.00 $4,771.00
32 $822.00 $1,612.00 $2,402.00 $3,192.00 $3,982.00 $4,772.00
33 $823.00 $1,613.00 $2,403.00 $3,193.00 $3,983.00 $4,773.00
34 $824.00 $1,614.00 $2,404.00 $3,194.00 $3,984.00 $4,774.00
37 $827.00 $1,617.00 $2,407.00 $3,197.00 $3,987.00 $4,777.00
38 $828.00 $1,618.00 $2,408.00 $3,198.00 $3,988.00 $4,778.00
43 $833.00 $1,623.00 $2,413.00 $3,203.00 $3,993.00 $4,783.00
44 $834.00 $1,624.00 $2,414.00 $3,204.00 $3,994.00 $4,784.00
48 $838.00 $1,628.00 $2,418.00 $3,208.00 $3,998.00 $4,788.00
82 $872.00 $1,662.00 $2,452.00 $3,242.00 $4,032.00 $4,822.00
83 $873.00 $1,663.00 $2,453.00 $3,243.00 $4,033.00 $4,823.00
86 $876.00 $1,666.00 $2,456.00 $3,246.00 $4,036.00 $4,826.00
96 $886.00 $1,676.00 $2,466.00 $3,256.00 $4,046.00 $4,836.00
99 $889.00 $1,679.00 $2,469.00 $3,259.00 $4,049.00 $4,839.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Thursday
STORE 1 2 3 4 5 6
3 $460.00 $917.00 $1,374.00 $1,831.00 $2,288.00 $2,745.00
5 $462.00 $919.00 $1,376.00 $1,833.00 $2,290.00 $2,747.00
6 $463.00 $920.00 $1,377.00 $1,834.00 $2,291.00 $2,748.00
7 $464.00 $921.00 $1,378.00 $1,835.00 $2,292.00 $2,749.00
8 $465.00 $922.00 $1,379.00 $1,836.00 $2,293.00 $2,750.00
9 $466.00 $923.00 $1,380.00 $1,837.00 $2,294.00 $2,751.00
10 $467.00 $924.00 $1,381.00 $1,838.00 $2,295.00 $2,752.00
11 $468.00 $925.00 $1,382.00 $1,839.00 $2,296.00 $2,753.00
12 $469.00 $926.00 $1,383.00 $1,840.00 $2,297.00 $2,754.00
14 $471.00 $928.00 $1,385.00 $1,842.00 $2,299.00 $2,756.00
15 $472.00 $929.00 $1,386.00 $1,843.00 $2,300.00 $2,757.00
16 $473.00 $930.00 $1,387.00 $1,844.00 $2,301.00 $2,758.00
17 $474.00 $931.00 $1,388.00 $1,845.00 $2,302.00 $2,759.00
18 $475.00 $932.00 $1,389.00 $1,846.00 $2,303.00 $2,760.00
19 $476.00 $933.00 $1,390.00 $1,847.00 $2,304.00 $2,761.00
20 $477.00 $934.00 $1,391.00 $1,848.00 $2,305.00 $2,762.00
21 $478.00 $935.00 $1,392.00 $1,849.00 $2,306.00 $2,763.00
22 $479.00 $936.00 $1,393.00 $1,850.00 $2,307.00 $2,764.00
23 $480.00 $937.00 $1,394.00 $1,851.00 $2,308.00 $2,765.00
24 $481.00 $938.00 $1,395.00 $1,852.00 $2,309.00 $2,766.00
25 $482.00 $939.00 $1,396.00 $1,853.00 $2,310.00 $2,767.00
26 $483.00 $940.00 $1,397.00 $1,854.00 $2,311.00 $2,768.00
27 $484.00 $941.00 $1,398.00 $1,855.00 $2,312.00 $2,769.00
28 $485.00 $942.00 $1,399.00 $1,856.00 $2,313.00 $2,770.00
29 $486.00 $943.00 $1,400.00 $1,857.00 $2,314.00 $2,771.00
30 $487.00 $944.00 $1,401.00 $1,858.00 $2,315.00 $2,772.00
31 $488.00 $945.00 $1,402.00 $1,859.00 $2,316.00 $2,773.00
32 $489.00 $946.00 $1,403.00 $1,860.00 $2,317.00 $2,774.00
33 $490.00 $947.00 $1,404.00 $1,861.00 $2,318.00 $2,775.00
34 $491.00 $948.00 $1,405.00 $1,862.00 $2,319.00 $2,776.00
37 $494.00 $951.00 $1,408.00 $1,865.00 $2,322.00 $2,779.00
38 $495.00 $952.00 $1,409.00 $1,866.00 $2,323.00 $2,780.00
43 $500.00 $957.00 $1,414.00 $1,871.00 $2,328.00 $2,785.00
44 $501.00 $958.00 $1,415.00 $1,872.00 $2,329.00 $2,786.00
48 $505.00 $962.00 $1,419.00 $1,876.00 $2,333.00 $2,790.00
82 $539.00 $996.00 $1,453.00 $1,910.00 $2,367.00 $2,824.00
83 $540.00 $997.00 $1,454.00 $1,911.00 $2,368.00 $2,825.00
86 $543.00 $1,000.00 $1,457.00 $1,914.00 $2,371.00 $2,828.00
96 $553.00 $1,010.00 $1,467.00 $1,924.00 $2,381.00 $2,838.00
99 $556.00 $1,013.00 $1,470.00 $1,927.00 $2,384.00 $2,841.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Friday
STORE 1 2 3 4 5 6
3 $745.00 $1,487.00 $2,229.00 $2,971.00 $3,713.00 $4,071.00
5 $747.00 $1,489.00 $2,231.00 $2,973.00 $3,715.00 $4,073.00
6 $748.00 $1,490.00 $2,232.00 $2,974.00 $3,716.00 $4,074.00
7 $749.00 $1,491.00 $2,233.00 $2,975.00 $3,717.00 $4,075.00
8 $750.00 $1,492.00 $2,234.00 $2,976.00 $3,718.00 $4,076.00
9 $751.00 $1,493.00 $2,235.00 $2,977.00 $3,719.00 $4,077.00
10 $752.00 $1,494.00 $2,236.00 $2,978.00 $3,720.00 $4,078.00
11 $753.00 $1,495.00 $2,237.00 $2,979.00 $3,721.00 $4,079.00
12 $754.00 $1,496.00 $2,238.00 $2,980.00 $3,722.00 $4,080.00
14 $756.00 $1,498.00 $2,240.00 $2,982.00 $3,724.00 $4,082.00
15 $757.00 $1,499.00 $2,241.00 $2,983.00 $3,725.00 $4,083.00
16 $758.00 $1,500.00 $2,242.00 $2,984.00 $3,726.00 $4,084.00
17 $759.00 $1,501.00 $2,243.00 $2,985.00 $3,727.00 $4,085.00
18 $760.00 $1,502.00 $2,244.00 $2,986.00 $3,728.00 $4,086.00
19 $761.00 $1,503.00 $2,245.00 $2,987.00 $3,729.00 $4,087.00
20 $762.00 $1,504.00 $2,246.00 $2,988.00 $3,730.00 $4,088.00
21 $763.00 $1,505.00 $2,247.00 $2,989.00 $3,731.00 $4,089.00
22 $764.00 $1,506.00 $2,248.00 $2,990.00 $3,732.00 $4,090.00
23 $765.00 $1,507.00 $2,249.00 $2,991.00 $3,733.00 $4,091.00
24 $766.00 $1,508.00 $2,250.00 $2,992.00 $3,734.00 $4,092.00
25 $767.00 $1,509.00 $2,251.00 $2,993.00 $3,735.00 $4,093.00
26 $768.00 $1,510.00 $2,252.00 $2,994.00 $3,736.00 $4,094.00
27 $769.00 $1,511.00 $2,253.00 $2,995.00 $3,737.00 $4,095.00
28 $770.00 $1,512.00 $2,254.00 $2,996.00 $3,738.00 $4,096.00
29 $771.00 $1,513.00 $2,255.00 $2,997.00 $3,739.00 $4,097.00
30 $772.00 $1,514.00 $2,256.00 $2,998.00 $3,740.00 $4,098.00
31 $773.00 $1,515.00 $2,257.00 $2,999.00 $3,741.00 $4,099.00
32 $774.00 $1,516.00 $2,258.00 $3,000.00 $3,742.00 $4,100.00
33 $775.00 $1,517.00 $2,259.00 $3,001.00 $3,743.00 $4,101.00
34 $776.00 $1,518.00 $2,260.00 $3,002.00 $3,744.00 $4,102.00
37 $779.00 $1,521.00 $2,263.00 $3,005.00 $3,747.00 $4,105.00
38 $780.00 $1,522.00 $2,264.00 $3,006.00 $3,748.00 $4,106.00
43 $785.00 $1,527.00 $2,269.00 $3,011.00 $3,753.00 $4,111.00
44 $786.00 $1,528.00 $2,270.00 $3,012.00 $3,754.00 $4,112.00
48 $790.00 $1,532.00 $2,274.00 $3,016.00 $3,758.00 $4,116.00
82 $824.00 $1,566.00 $2,308.00 $3,050.00 $3,792.00 $4,150.00
83 $825.00 $1,567.00 $2,309.00 $3,051.00 $3,793.00 $4,151.00
86 $828.00 $1,570.00 $2,312.00 $3,054.00 $3,796.00 $4,154.00
96 $838.00 $1,580.00 $2,322.00 $3,064.00 $3,806.00 $4,164.00
99 $841.00 $1,583.00 $2,325.00 $3,067.00 $3,809.00 $4,167.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Saturday
STORE 1 2 3 4 5 6
3 $856.00 $1,709.00 $2,562.00 $3,415.00 $4,268.00 $5,121.00
5 $858.00 $1,711.00 $2,564.00 $3,417.00 $4,270.00 $5,123.00
6 $859.00 $1,712.00 $2,565.00 $3,418.00 $4,271.00 $5,124.00
7 $860.00 $1,713.00 $2,566.00 $3,419.00 $4,272.00 $5,125.00
8 $861.00 $1,714.00 $2,567.00 $3,420.00 $4,273.00 $5,126.00
9 $862.00 $1,715.00 $2,568.00 $3,421.00 $4,274.00 $5,127.00
10 $863.00 $1,716.00 $2,569.00 $3,422.00 $4,275.00 $5,128.00
11 $864.00 $1,717.00 $2,570.00 $3,423.00 $4,276.00 $5,129.00
12 $865.00 $1,718.00 $2,571.00 $3,424.00 $4,277.00 $5,130.00
14 $867.00 $1,720.00 $2,573.00 $3,426.00 $4,279.00 $5,132.00
15 $868.00 $1,721.00 $2,574.00 $3,427.00 $4,280.00 $5,133.00
16 $869.00 $1,722.00 $2,575.00 $3,428.00 $4,281.00 $5,134.00
17 $870.00 $1,723.00 $2,576.00 $3,429.00 $4,282.00 $5,135.00
18 $871.00 $1,724.00 $2,577.00 $3,430.00 $4,283.00 $5,136.00
19 $872.00 $1,725.00 $2,578.00 $3,431.00 $4,284.00 $5,137.00
20 $873.00 $1,726.00 $2,579.00 $3,432.00 $4,285.00 $5,138.00
21 $874.00 $1,727.00 $2,580.00 $3,433.00 $4,286.00 $5,139.00
22 $875.00 $1,728.00 $2,581.00 $3,434.00 $4,287.00 $5,140.00
23 $876.00 $1,729.00 $2,582.00 $3,435.00 $4,288.00 $5,141.00
24 $877.00 $1,730.00 $2,583.00 $3,436.00 $4,289.00 $5,142.00
25 $878.00 $1,731.00 $2,584.00 $3,437.00 $4,290.00 $5,143.00
26 $879.00 $1,732.00 $2,585.00 $3,438.00 $4,291.00 $5,144.00
27 $880.00 $1,733.00 $2,586.00 $3,439.00 $4,292.00 $5,145.00
28 $881.00 $1,734.00 $2,587.00 $3,440.00 $4,293.00 $5,146.00
29 $882.00 $1,735.00 $2,588.00 $3,441.00 $4,294.00 $5,147.00
30 $883.00 $1,736.00 $2,589.00 $3,442.00 $4,295.00 $5,148.00
31 $884.00 $1,737.00 $2,590.00 $3,443.00 $4,296.00 $5,149.00
32 $885.00 $1,738.00 $2,591.00 $3,444.00 $4,297.00 $5,150.00
33 $886.00 $1,739.00 $2,592.00 $3,445.00 $4,298.00 $5,151.00
34 $887.00 $1,740.00 $2,593.00 $3,446.00 $4,299.00 $5,152.00
37 $890.00 $1,743.00 $2,596.00 $3,449.00 $4,302.00 $5,155.00
38 $891.00 $1,744.00 $2,597.00 $3,450.00 $4,303.00 $5,156.00
43 $896.00 $1,749.00 $2,602.00 $3,455.00 $4,308.00 $5,161.00
44 $897.00 $1,750.00 $2,603.00 $3,456.00 $4,309.00 $5,162.00
48 $901.00 $1,754.00 $2,607.00 $3,460.00 $4,313.00 $5,166.00
82 $935.00 $1,788.00 $2,641.00 $3,494.00 $4,347.00 $5,200.00
83 $936.00 $1,789.00 $2,642.00 $3,495.00 $4,348.00 $5,201.00
86 $939.00 $1,792.00 $2,645.00 $3,498.00 $4,351.00 $5,204.00
96 $949.00 $1,802.00 $2,655.00 $3,508.00 $4,361.00 $5,214.00
99 $952.00 $1,805.00 $2,658.00 $3,511.00 $4,364.00 $5,217.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Below is just one of the Store tabs (43) as a test report. All the cells next to the dept # need to be filled for each day
File name is Sales Reports, Tab name is Store 43
Sunday, 11/25/18 <- NOTE This date is one cell
Store 43 Actual Net Sales Projected Net Sales <- NOTE Store 43 is one cell
Store Total
Dept #s Actual Net Sales
Dept. 1 <- NOTE This date is one cell
Dept. 2 Formula needed here
Dept. 3 Formula needed here
Dept. 4 Formula needed here
Dept. 5 $1,833.00 <- This should be the result, next look below for Monday
Dept. 6 Formula needed here
Dept. 7 nothing needed here
$0.00 .00000
Monday, 11/26/18
Store 43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales
Dept. 1 Formula needed here
Dept. 2 Formula needed here
Dept. 3 Formula needed here
Dept. 4 $683.00 <- this should be the result
Dept. 5 Formula needed here
Dept. 6 Formula needed here
Dept. 7 nothing needed here
$0.00 .00000
Tuesday, 11/27/18
Store #43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales Projected Net Sales
Dept. 1 etc.
Dept. 2 etc
Dept. 3 "
Dept. 4 ".
Dept. 5 ."
Dept. 6 ."
Dept. 7 ."
$0.00 .00000
Wednesday, 11/28/18
Store 43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales Projected Net Sales
Dept. 1
Dept. 2
Dept. 3
Dept. 4
Dept. 5
Dept. 6
Dept. 7
$0.00 .00000
Thursday, 11/29/18
Store 43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales Projected Net Sales
Dept. 1
Dept. 2
Dept. 3
Dept. 4
Dept. 5
Dept. 6
Dept. 7
$0.00 .00000
Friday, 11/30/18
Store 43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales Projected Net Sales
Dept. 1
Dept. 2
Dept. 3
Dept. 4
Dept. 5
Dept. 6
Dept. 7
$0.00 .00000
Saturday, 12/01/18
Store 43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales Projected Net Sales
Dept. 1
Dept. 2
Dept. 3
Dept. 4
Dept. 5
Dept. 6
Dept. 7
I have another spreadsheet report with 34 taps, one for each store. Each with one block for each day of the week. I need to look up values from the sheet of sales into each of the store tabs by day of the week, and dept.
I think it should be some type of V/H-LOOKUp formula but am lost on how to build it. Or it might be an Offset formula. I am toally not sure what to do.
Below I posted some test data sheets like what I will be using. The file names will need to be change to real ones later.
I not yet have rights to add file attachments here.
After the Sheets of sales is a test report from one of the Store report tabs. There are some notes in the first 2 days to see what I ma looking for.
I hope am I clear about what I need. If not please ask me anything.
Many thanks!!
File name is Sheets of sales Sunday Test data
STORE 1 2 3 4 5 6
3 $361.00 $719.00 $1,077.00 $1,435.00 $1,793.00 $2,151.00
5 $363.00 $721.00 $1,079.00 $1,437.00 $1,795.00 $2,153.00
6 $364.00 $722.00 $1,080.00 $1,438.00 $1,796.00 $2,154.00
7 $365.00 $723.00 $1,081.00 $1,439.00 $1,797.00 $2,155.00
8 $366.00 $724.00 $1,082.00 $1,440.00 $1,798.00 $2,156.00
9 $367.00 $725.00 $1,083.00 $1,441.00 $1,799.00 $2,157.00
10 $368.00 $726.00 $1,084.00 $1,442.00 $1,800.00 $2,158.00
11 $369.00 $727.00 $1,085.00 $1,443.00 $1,801.00 $2,159.00
12 $370.00 $728.00 $1,086.00 $1,444.00 $1,802.00 $2,160.00
14 $372.00 $730.00 $1,088.00 $1,446.00 $1,804.00 $2,162.00
15 $373.00 $731.00 $1,089.00 $1,447.00 $1,805.00 $2,163.00
16 $374.00 $732.00 $1,090.00 $1,448.00 $1,806.00 $2,164.00
17 $375.00 $733.00 $1,091.00 $1,449.00 $1,807.00 $2,165.00
18 $376.00 $734.00 $1,092.00 $1,450.00 $1,808.00 $2,166.00
19 $377.00 $735.00 $1,093.00 $1,451.00 $1,809.00 $2,167.00
20 $378.00 $736.00 $1,094.00 $1,452.00 $1,810.00 $2,168.00
21 $379.00 $737.00 $1,095.00 $1,453.00 $1,811.00 $2,169.00
22 $380.00 $738.00 $1,096.00 $1,454.00 $1,812.00 $2,170.00
23 $381.00 $739.00 $1,097.00 $1,455.00 $1,813.00 $2,171.00
24 $382.00 $740.00 $1,098.00 $1,456.00 $1,814.00 $2,172.00
25 $383.00 $741.00 $1,099.00 $1,457.00 $1,815.00 $2,173.00
26 $384.00 $742.00 $1,100.00 $1,458.00 $1,816.00 $2,174.00
27 $385.00 $743.00 $1,101.00 $1,459.00 $1,817.00 $2,175.00
28 $386.00 $744.00 $1,102.00 $1,460.00 $1,818.00 $2,176.00
29 $387.00 $745.00 $1,103.00 $1,461.00 $1,819.00 $2,177.00
30 $388.00 $746.00 $1,104.00 $1,462.00 $1,820.00 $2,178.00
31 $389.00 $747.00 $1,105.00 $1,463.00 $1,821.00 $2,179.00
32 $390.00 $748.00 $1,106.00 $1,464.00 $1,822.00 $2,180.00
33 $391.00 $749.00 $1,107.00 $1,465.00 $1,823.00 $2,181.00
34 $392.00 $750.00 $1,108.00 $1,466.00 $1,824.00 $2,182.00
37 $395.00 $753.00 $1,111.00 $1,469.00 $1,827.00 $2,185.00
38 $396.00 $754.00 $1,112.00 $1,470.00 $1,828.00 $2,186.00
43 $401.00 $759.00 $1,117.00 $1,475.00 $1,833.00 $2,191.00
44 $402.00 $760.00 $1,118.00 $1,476.00 $1,834.00 $2,192.00
48 $406.00 $764.00 $1,122.00 $1,480.00 $1,838.00 $2,196.00
82 $440.00 $798.00 $1,156.00 $1,514.00 $1,872.00 $2,230.00
83 $441.00 $799.00 $1,157.00 $1,515.00 $1,873.00 $2,231.00
86 $444.00 $802.00 $1,160.00 $1,518.00 $1,876.00 $2,234.00
96 $454.00 $812.00 $1,170.00 $1,528.00 $1,886.00 $2,244.00
99 $457.00 $815.00 $1,173.00 $1,531.00 $1,889.00 $2,247.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Monday
STORE 1 2 3 4 5 6
3 $163.00 $323.00 $483.00 $643.00 $803.00 $963.00
5 $165.00 $325.00 $485.00 $645.00 $805.00 $965.00
6 $166.00 $326.00 $486.00 $646.00 $806.00 $966.00
7 $167.00 $327.00 $487.00 $647.00 $807.00 $967.00
8 $168.00 $328.00 $488.00 $648.00 $808.00 $968.00
9 $169.00 $329.00 $489.00 $649.00 $809.00 $969.00
10 $170.00 $330.00 $490.00 $650.00 $810.00 $970.00
11 $171.00 $331.00 $491.00 $651.00 $811.00 $971.00
12 $172.00 $332.00 $492.00 $652.00 $812.00 $972.00
14 $174.00 $334.00 $494.00 $654.00 $814.00 $974.00
15 $175.00 $335.00 $495.00 $655.00 $815.00 $975.00
16 $176.00 $336.00 $496.00 $656.00 $816.00 $976.00
17 $177.00 $337.00 $497.00 $657.00 $817.00 $977.00
18 $178.00 $338.00 $498.00 $658.00 $818.00 $978.00
19 $179.00 $339.00 $499.00 $659.00 $819.00 $979.00
20 $180.00 $340.00 $500.00 $660.00 $820.00 $980.00
21 $181.00 $341.00 $501.00 $661.00 $821.00 $981.00
22 $182.00 $342.00 $502.00 $662.00 $822.00 $982.00
23 $183.00 $343.00 $503.00 $663.00 $823.00 $983.00
24 $184.00 $344.00 $504.00 $664.00 $824.00 $984.00
25 $185.00 $345.00 $505.00 $665.00 $825.00 $985.00
26 $186.00 $346.00 $506.00 $666.00 $826.00 $986.00
27 $187.00 $347.00 $507.00 $667.00 $827.00 $987.00
28 $188.00 $348.00 $508.00 $668.00 $828.00 $988.00
29 $189.00 $349.00 $509.00 $669.00 $829.00 $989.00
30 $190.00 $350.00 $510.00 $670.00 $830.00 $990.00
31 $191.00 $351.00 $511.00 $671.00 $831.00 $991.00
32 $192.00 $352.00 $512.00 $672.00 $832.00 $992.00
33 $193.00 $353.00 $513.00 $673.00 $833.00 $993.00
34 $194.00 $354.00 $514.00 $674.00 $834.00 $994.00
37 $197.00 $357.00 $517.00 $677.00 $837.00 $997.00
38 $198.00 $358.00 $518.00 $678.00 $838.00 $998.00
43 $203.00 $363.00 $523.00 $683.00 $843.00 $1,003.00
44 $204.00 $364.00 $524.00 $684.00 $844.00 $1,004.00
48 $208.00 $368.00 $528.00 $688.00 $848.00 $1,008.00
82 $242.00 $402.00 $562.00 $722.00 $882.00 $1,042.00
83 $243.00 $403.00 $563.00 $723.00 $883.00 $1,043.00
86 $246.00 $406.00 $566.00 $726.00 $886.00 $1,046.00
96 $256.00 $416.00 $576.00 $736.00 $896.00 $1,056.00
99 $259.00 $419.00 $579.00 $739.00 $899.00 $1,059.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Tuesday
STORE Dept 1 Dept 2 Dept 3 Dept 4 Dept 5 Dept 6
3 $127.00 $251.00 $375.00 $499.00 $623.00 $747.00
5 $129.00 $253.00 $377.00 $501.00 $625.00 $749.00
6 $130.00 $254.00 $378.00 $502.00 $626.00 $750.00
7 $131.00 $255.00 $379.00 $503.00 $627.00 $751.00
8 $132.00 $256.00 $380.00 $504.00 $628.00 $752.00
9 $133.00 $257.00 $381.00 $505.00 $629.00 $753.00
10 $134.00 $258.00 $382.00 $506.00 $630.00 $754.00
11 $135.00 $259.00 $383.00 $507.00 $631.00 $755.00
12 $136.00 $260.00 $384.00 $508.00 $632.00 $756.00
14 $138.00 $262.00 $386.00 $510.00 $634.00 $758.00
15 $139.00 $263.00 $387.00 $511.00 $635.00 $759.00
16 $140.00 $264.00 $388.00 $512.00 $636.00 $760.00
17 $141.00 $265.00 $389.00 $513.00 $637.00 $761.00
18 $142.00 $266.00 $390.00 $514.00 $638.00 $762.00
19 $143.00 $267.00 $391.00 $515.00 $639.00 $763.00
20 $144.00 $268.00 $392.00 $516.00 $640.00 $764.00
21 $145.00 $269.00 $393.00 $517.00 $641.00 $765.00
22 $146.00 $270.00 $394.00 $518.00 $642.00 $766.00
23 $147.00 $271.00 $395.00 $519.00 $643.00 $767.00
24 $148.00 $272.00 $396.00 $520.00 $644.00 $768.00
25 $149.00 $273.00 $397.00 $521.00 $645.00 $769.00
26 $150.00 $274.00 $398.00 $522.00 $646.00 $770.00
27 $151.00 $275.00 $399.00 $523.00 $647.00 $771.00
28 $152.00 $276.00 $400.00 $524.00 $648.00 $772.00
29 $153.00 $277.00 $401.00 $525.00 $649.00 $773.00
30 $154.00 $278.00 $402.00 $526.00 $650.00 $774.00
31 $155.00 $279.00 $403.00 $527.00 $651.00 $775.00
32 $156.00 $280.00 $404.00 $528.00 $652.00 $776.00
33 $157.00 $281.00 $405.00 $529.00 $653.00 $777.00
34 $158.00 $282.00 $406.00 $530.00 $654.00 $778.00
37 $161.00 $285.00 $409.00 $533.00 $657.00 $781.00
38 $162.00 $286.00 $410.00 $534.00 $658.00 $782.00
43 $167.00 $291.00 $415.00 $539.00 $663.00 $787.00
44 $168.00 $292.00 $416.00 $540.00 $664.00 $788.00
48 $172.00 $296.00 $420.00 $544.00 $668.00 $792.00
82 $206.00 $330.00 $454.00 $578.00 $702.00 $826.00
83 $207.00 $331.00 $455.00 $579.00 $703.00 $827.00
86 $210.00 $334.00 $458.00 $582.00 $706.00 $830.00
96 $220.00 $344.00 $468.00 $592.00 $716.00 $840.00
99 $223.00 $347.00 $471.00 $595.00 $719.00 $843.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Wednesday
STORE 1 2 3 4 5 6
3 $793.00 $1,583.00 $2,373.00 $3,163.00 $3,953.00 $4,743.00
5 $795.00 $1,585.00 $2,375.00 $3,165.00 $3,955.00 $4,745.00
6 $796.00 $1,586.00 $2,376.00 $3,166.00 $3,956.00 $4,746.00
7 $797.00 $1,587.00 $2,377.00 $3,167.00 $3,957.00 $4,747.00
8 $798.00 $1,588.00 $2,378.00 $3,168.00 $3,958.00 $4,748.00
9 $799.00 $1,589.00 $2,379.00 $3,169.00 $3,959.00 $4,749.00
10 $800.00 $1,590.00 $2,380.00 $3,170.00 $3,960.00 $4,750.00
11 $801.00 $1,591.00 $2,381.00 $3,171.00 $3,961.00 $4,751.00
12 $802.00 $1,592.00 $2,382.00 $3,172.00 $3,962.00 $4,752.00
14 $804.00 $1,594.00 $2,384.00 $3,174.00 $3,964.00 $4,754.00
15 $805.00 $1,595.00 $2,385.00 $3,175.00 $3,965.00 $4,755.00
16 $806.00 $1,596.00 $2,386.00 $3,176.00 $3,966.00 $4,756.00
17 $807.00 $1,597.00 $2,387.00 $3,177.00 $3,967.00 $4,757.00
18 $808.00 $1,598.00 $2,388.00 $3,178.00 $3,968.00 $4,758.00
19 $809.00 $1,599.00 $2,389.00 $3,179.00 $3,969.00 $4,759.00
20 $810.00 $1,600.00 $2,390.00 $3,180.00 $3,970.00 $4,760.00
21 $811.00 $1,601.00 $2,391.00 $3,181.00 $3,971.00 $4,761.00
22 $812.00 $1,602.00 $2,392.00 $3,182.00 $3,972.00 $4,762.00
23 $813.00 $1,603.00 $2,393.00 $3,183.00 $3,973.00 $4,763.00
24 $814.00 $1,604.00 $2,394.00 $3,184.00 $3,974.00 $4,764.00
25 $815.00 $1,605.00 $2,395.00 $3,185.00 $3,975.00 $4,765.00
26 $816.00 $1,606.00 $2,396.00 $3,186.00 $3,976.00 $4,766.00
27 $817.00 $1,607.00 $2,397.00 $3,187.00 $3,977.00 $4,767.00
28 $818.00 $1,608.00 $2,398.00 $3,188.00 $3,978.00 $4,768.00
29 $819.00 $1,609.00 $2,399.00 $3,189.00 $3,979.00 $4,769.00
30 $820.00 $1,610.00 $2,400.00 $3,190.00 $3,980.00 $4,770.00
31 $821.00 $1,611.00 $2,401.00 $3,191.00 $3,981.00 $4,771.00
32 $822.00 $1,612.00 $2,402.00 $3,192.00 $3,982.00 $4,772.00
33 $823.00 $1,613.00 $2,403.00 $3,193.00 $3,983.00 $4,773.00
34 $824.00 $1,614.00 $2,404.00 $3,194.00 $3,984.00 $4,774.00
37 $827.00 $1,617.00 $2,407.00 $3,197.00 $3,987.00 $4,777.00
38 $828.00 $1,618.00 $2,408.00 $3,198.00 $3,988.00 $4,778.00
43 $833.00 $1,623.00 $2,413.00 $3,203.00 $3,993.00 $4,783.00
44 $834.00 $1,624.00 $2,414.00 $3,204.00 $3,994.00 $4,784.00
48 $838.00 $1,628.00 $2,418.00 $3,208.00 $3,998.00 $4,788.00
82 $872.00 $1,662.00 $2,452.00 $3,242.00 $4,032.00 $4,822.00
83 $873.00 $1,663.00 $2,453.00 $3,243.00 $4,033.00 $4,823.00
86 $876.00 $1,666.00 $2,456.00 $3,246.00 $4,036.00 $4,826.00
96 $886.00 $1,676.00 $2,466.00 $3,256.00 $4,046.00 $4,836.00
99 $889.00 $1,679.00 $2,469.00 $3,259.00 $4,049.00 $4,839.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Thursday
STORE 1 2 3 4 5 6
3 $460.00 $917.00 $1,374.00 $1,831.00 $2,288.00 $2,745.00
5 $462.00 $919.00 $1,376.00 $1,833.00 $2,290.00 $2,747.00
6 $463.00 $920.00 $1,377.00 $1,834.00 $2,291.00 $2,748.00
7 $464.00 $921.00 $1,378.00 $1,835.00 $2,292.00 $2,749.00
8 $465.00 $922.00 $1,379.00 $1,836.00 $2,293.00 $2,750.00
9 $466.00 $923.00 $1,380.00 $1,837.00 $2,294.00 $2,751.00
10 $467.00 $924.00 $1,381.00 $1,838.00 $2,295.00 $2,752.00
11 $468.00 $925.00 $1,382.00 $1,839.00 $2,296.00 $2,753.00
12 $469.00 $926.00 $1,383.00 $1,840.00 $2,297.00 $2,754.00
14 $471.00 $928.00 $1,385.00 $1,842.00 $2,299.00 $2,756.00
15 $472.00 $929.00 $1,386.00 $1,843.00 $2,300.00 $2,757.00
16 $473.00 $930.00 $1,387.00 $1,844.00 $2,301.00 $2,758.00
17 $474.00 $931.00 $1,388.00 $1,845.00 $2,302.00 $2,759.00
18 $475.00 $932.00 $1,389.00 $1,846.00 $2,303.00 $2,760.00
19 $476.00 $933.00 $1,390.00 $1,847.00 $2,304.00 $2,761.00
20 $477.00 $934.00 $1,391.00 $1,848.00 $2,305.00 $2,762.00
21 $478.00 $935.00 $1,392.00 $1,849.00 $2,306.00 $2,763.00
22 $479.00 $936.00 $1,393.00 $1,850.00 $2,307.00 $2,764.00
23 $480.00 $937.00 $1,394.00 $1,851.00 $2,308.00 $2,765.00
24 $481.00 $938.00 $1,395.00 $1,852.00 $2,309.00 $2,766.00
25 $482.00 $939.00 $1,396.00 $1,853.00 $2,310.00 $2,767.00
26 $483.00 $940.00 $1,397.00 $1,854.00 $2,311.00 $2,768.00
27 $484.00 $941.00 $1,398.00 $1,855.00 $2,312.00 $2,769.00
28 $485.00 $942.00 $1,399.00 $1,856.00 $2,313.00 $2,770.00
29 $486.00 $943.00 $1,400.00 $1,857.00 $2,314.00 $2,771.00
30 $487.00 $944.00 $1,401.00 $1,858.00 $2,315.00 $2,772.00
31 $488.00 $945.00 $1,402.00 $1,859.00 $2,316.00 $2,773.00
32 $489.00 $946.00 $1,403.00 $1,860.00 $2,317.00 $2,774.00
33 $490.00 $947.00 $1,404.00 $1,861.00 $2,318.00 $2,775.00
34 $491.00 $948.00 $1,405.00 $1,862.00 $2,319.00 $2,776.00
37 $494.00 $951.00 $1,408.00 $1,865.00 $2,322.00 $2,779.00
38 $495.00 $952.00 $1,409.00 $1,866.00 $2,323.00 $2,780.00
43 $500.00 $957.00 $1,414.00 $1,871.00 $2,328.00 $2,785.00
44 $501.00 $958.00 $1,415.00 $1,872.00 $2,329.00 $2,786.00
48 $505.00 $962.00 $1,419.00 $1,876.00 $2,333.00 $2,790.00
82 $539.00 $996.00 $1,453.00 $1,910.00 $2,367.00 $2,824.00
83 $540.00 $997.00 $1,454.00 $1,911.00 $2,368.00 $2,825.00
86 $543.00 $1,000.00 $1,457.00 $1,914.00 $2,371.00 $2,828.00
96 $553.00 $1,010.00 $1,467.00 $1,924.00 $2,381.00 $2,838.00
99 $556.00 $1,013.00 $1,470.00 $1,927.00 $2,384.00 $2,841.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Friday
STORE 1 2 3 4 5 6
3 $745.00 $1,487.00 $2,229.00 $2,971.00 $3,713.00 $4,071.00
5 $747.00 $1,489.00 $2,231.00 $2,973.00 $3,715.00 $4,073.00
6 $748.00 $1,490.00 $2,232.00 $2,974.00 $3,716.00 $4,074.00
7 $749.00 $1,491.00 $2,233.00 $2,975.00 $3,717.00 $4,075.00
8 $750.00 $1,492.00 $2,234.00 $2,976.00 $3,718.00 $4,076.00
9 $751.00 $1,493.00 $2,235.00 $2,977.00 $3,719.00 $4,077.00
10 $752.00 $1,494.00 $2,236.00 $2,978.00 $3,720.00 $4,078.00
11 $753.00 $1,495.00 $2,237.00 $2,979.00 $3,721.00 $4,079.00
12 $754.00 $1,496.00 $2,238.00 $2,980.00 $3,722.00 $4,080.00
14 $756.00 $1,498.00 $2,240.00 $2,982.00 $3,724.00 $4,082.00
15 $757.00 $1,499.00 $2,241.00 $2,983.00 $3,725.00 $4,083.00
16 $758.00 $1,500.00 $2,242.00 $2,984.00 $3,726.00 $4,084.00
17 $759.00 $1,501.00 $2,243.00 $2,985.00 $3,727.00 $4,085.00
18 $760.00 $1,502.00 $2,244.00 $2,986.00 $3,728.00 $4,086.00
19 $761.00 $1,503.00 $2,245.00 $2,987.00 $3,729.00 $4,087.00
20 $762.00 $1,504.00 $2,246.00 $2,988.00 $3,730.00 $4,088.00
21 $763.00 $1,505.00 $2,247.00 $2,989.00 $3,731.00 $4,089.00
22 $764.00 $1,506.00 $2,248.00 $2,990.00 $3,732.00 $4,090.00
23 $765.00 $1,507.00 $2,249.00 $2,991.00 $3,733.00 $4,091.00
24 $766.00 $1,508.00 $2,250.00 $2,992.00 $3,734.00 $4,092.00
25 $767.00 $1,509.00 $2,251.00 $2,993.00 $3,735.00 $4,093.00
26 $768.00 $1,510.00 $2,252.00 $2,994.00 $3,736.00 $4,094.00
27 $769.00 $1,511.00 $2,253.00 $2,995.00 $3,737.00 $4,095.00
28 $770.00 $1,512.00 $2,254.00 $2,996.00 $3,738.00 $4,096.00
29 $771.00 $1,513.00 $2,255.00 $2,997.00 $3,739.00 $4,097.00
30 $772.00 $1,514.00 $2,256.00 $2,998.00 $3,740.00 $4,098.00
31 $773.00 $1,515.00 $2,257.00 $2,999.00 $3,741.00 $4,099.00
32 $774.00 $1,516.00 $2,258.00 $3,000.00 $3,742.00 $4,100.00
33 $775.00 $1,517.00 $2,259.00 $3,001.00 $3,743.00 $4,101.00
34 $776.00 $1,518.00 $2,260.00 $3,002.00 $3,744.00 $4,102.00
37 $779.00 $1,521.00 $2,263.00 $3,005.00 $3,747.00 $4,105.00
38 $780.00 $1,522.00 $2,264.00 $3,006.00 $3,748.00 $4,106.00
43 $785.00 $1,527.00 $2,269.00 $3,011.00 $3,753.00 $4,111.00
44 $786.00 $1,528.00 $2,270.00 $3,012.00 $3,754.00 $4,112.00
48 $790.00 $1,532.00 $2,274.00 $3,016.00 $3,758.00 $4,116.00
82 $824.00 $1,566.00 $2,308.00 $3,050.00 $3,792.00 $4,150.00
83 $825.00 $1,567.00 $2,309.00 $3,051.00 $3,793.00 $4,151.00
86 $828.00 $1,570.00 $2,312.00 $3,054.00 $3,796.00 $4,154.00
96 $838.00 $1,580.00 $2,322.00 $3,064.00 $3,806.00 $4,164.00
99 $841.00 $1,583.00 $2,325.00 $3,067.00 $3,809.00 $4,167.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Saturday
STORE 1 2 3 4 5 6
3 $856.00 $1,709.00 $2,562.00 $3,415.00 $4,268.00 $5,121.00
5 $858.00 $1,711.00 $2,564.00 $3,417.00 $4,270.00 $5,123.00
6 $859.00 $1,712.00 $2,565.00 $3,418.00 $4,271.00 $5,124.00
7 $860.00 $1,713.00 $2,566.00 $3,419.00 $4,272.00 $5,125.00
8 $861.00 $1,714.00 $2,567.00 $3,420.00 $4,273.00 $5,126.00
9 $862.00 $1,715.00 $2,568.00 $3,421.00 $4,274.00 $5,127.00
10 $863.00 $1,716.00 $2,569.00 $3,422.00 $4,275.00 $5,128.00
11 $864.00 $1,717.00 $2,570.00 $3,423.00 $4,276.00 $5,129.00
12 $865.00 $1,718.00 $2,571.00 $3,424.00 $4,277.00 $5,130.00
14 $867.00 $1,720.00 $2,573.00 $3,426.00 $4,279.00 $5,132.00
15 $868.00 $1,721.00 $2,574.00 $3,427.00 $4,280.00 $5,133.00
16 $869.00 $1,722.00 $2,575.00 $3,428.00 $4,281.00 $5,134.00
17 $870.00 $1,723.00 $2,576.00 $3,429.00 $4,282.00 $5,135.00
18 $871.00 $1,724.00 $2,577.00 $3,430.00 $4,283.00 $5,136.00
19 $872.00 $1,725.00 $2,578.00 $3,431.00 $4,284.00 $5,137.00
20 $873.00 $1,726.00 $2,579.00 $3,432.00 $4,285.00 $5,138.00
21 $874.00 $1,727.00 $2,580.00 $3,433.00 $4,286.00 $5,139.00
22 $875.00 $1,728.00 $2,581.00 $3,434.00 $4,287.00 $5,140.00
23 $876.00 $1,729.00 $2,582.00 $3,435.00 $4,288.00 $5,141.00
24 $877.00 $1,730.00 $2,583.00 $3,436.00 $4,289.00 $5,142.00
25 $878.00 $1,731.00 $2,584.00 $3,437.00 $4,290.00 $5,143.00
26 $879.00 $1,732.00 $2,585.00 $3,438.00 $4,291.00 $5,144.00
27 $880.00 $1,733.00 $2,586.00 $3,439.00 $4,292.00 $5,145.00
28 $881.00 $1,734.00 $2,587.00 $3,440.00 $4,293.00 $5,146.00
29 $882.00 $1,735.00 $2,588.00 $3,441.00 $4,294.00 $5,147.00
30 $883.00 $1,736.00 $2,589.00 $3,442.00 $4,295.00 $5,148.00
31 $884.00 $1,737.00 $2,590.00 $3,443.00 $4,296.00 $5,149.00
32 $885.00 $1,738.00 $2,591.00 $3,444.00 $4,297.00 $5,150.00
33 $886.00 $1,739.00 $2,592.00 $3,445.00 $4,298.00 $5,151.00
34 $887.00 $1,740.00 $2,593.00 $3,446.00 $4,299.00 $5,152.00
37 $890.00 $1,743.00 $2,596.00 $3,449.00 $4,302.00 $5,155.00
38 $891.00 $1,744.00 $2,597.00 $3,450.00 $4,303.00 $5,156.00
43 $896.00 $1,749.00 $2,602.00 $3,455.00 $4,308.00 $5,161.00
44 $897.00 $1,750.00 $2,603.00 $3,456.00 $4,309.00 $5,162.00
48 $901.00 $1,754.00 $2,607.00 $3,460.00 $4,313.00 $5,166.00
82 $935.00 $1,788.00 $2,641.00 $3,494.00 $4,347.00 $5,200.00
83 $936.00 $1,789.00 $2,642.00 $3,495.00 $4,348.00 $5,201.00
86 $939.00 $1,792.00 $2,645.00 $3,498.00 $4,351.00 $5,204.00
96 $949.00 $1,802.00 $2,655.00 $3,508.00 $4,361.00 $5,214.00
99 $952.00 $1,805.00 $2,658.00 $3,511.00 $4,364.00 $5,217.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Below is just one of the Store tabs (43) as a test report. All the cells next to the dept # need to be filled for each day
File name is Sales Reports, Tab name is Store 43
Sunday, 11/25/18 <- NOTE This date is one cell
Store 43 Actual Net Sales Projected Net Sales <- NOTE Store 43 is one cell
Store Total
Dept #s Actual Net Sales
Dept. 1 <- NOTE This date is one cell
Dept. 2 Formula needed here
Dept. 3 Formula needed here
Dept. 4 Formula needed here
Dept. 5 $1,833.00 <- This should be the result, next look below for Monday
Dept. 6 Formula needed here
Dept. 7 nothing needed here
$0.00 .00000
Monday, 11/26/18
Store 43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales
Dept. 1 Formula needed here
Dept. 2 Formula needed here
Dept. 3 Formula needed here
Dept. 4 $683.00 <- this should be the result
Dept. 5 Formula needed here
Dept. 6 Formula needed here
Dept. 7 nothing needed here
$0.00 .00000
Tuesday, 11/27/18
Store #43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales Projected Net Sales
Dept. 1 etc.
Dept. 2 etc
Dept. 3 "
Dept. 4 ".
Dept. 5 ."
Dept. 6 ."
Dept. 7 ."
$0.00 .00000
Wednesday, 11/28/18
Store 43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales Projected Net Sales
Dept. 1
Dept. 2
Dept. 3
Dept. 4
Dept. 5
Dept. 6
Dept. 7
$0.00 .00000
Thursday, 11/29/18
Store 43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales Projected Net Sales
Dept. 1
Dept. 2
Dept. 3
Dept. 4
Dept. 5
Dept. 6
Dept. 7
$0.00 .00000
Friday, 11/30/18
Store 43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales Projected Net Sales
Dept. 1
Dept. 2
Dept. 3
Dept. 4
Dept. 5
Dept. 6
Dept. 7
$0.00 .00000
Saturday, 12/01/18
Store 43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales Projected Net Sales
Dept. 1
Dept. 2
Dept. 3
Dept. 4
Dept. 5
Dept. 6
Dept. 7
