arshad1976
New Member
- Joined
- Nov 12, 2017
- Messages
- 3
Dear Mr. Excel
Can you please help me to prepare the data on excel sheet as per attachment.
Regards
<colgroup><col span="4"><col><col span="2"><col><col><col span="5"><col><col><col><col><col><col span="2"><col><col><col><col><col span="2"><col><col><col><col><col><col span="8"><col></colgroup><tbody>
</tbody>
please help
Can you please help me to prepare the data on excel sheet as per attachment.
Regards
Shop | Space | Rent per sqm | Total | Grace Period in months | Apr-17 | May-17 | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | Total | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Jul-18 | Aug-18 | Sep-18 | Oct-18 | Nov-18 | Dec-18 | Total | Jan-19 | Feb-19 | Mar-19 | Apr-19 | May-19 | Jun-19 | Jul-19 | Aug-19 | Sep-19 | Oct-19 | Nov-19 | Dec-19 | Total |
1 | 1,000 | 200 | 200,000 | 3 | 200,000 | 200,000 | 200,000 | 200,000 | 400,000 | 200,000 | 200,000 | |||||||||||||||||||||||||||||
2 | 2,000 | 300 | 600,000 | 2 | 600,000 | 600,000 | 600,000 | 600,000 | 1,200,000 | 600,000 | 600,000 | |||||||||||||||||||||||||||||
3 | 1,500 | 400 | 600,000 | 3 | 600,000 | 600,000 | 600,000 | 600,000 | 1,200,000 | 600,000 | 600,000 | |||||||||||||||||||||||||||||
4 | 1,200 | 150 | 180,000 | 2 | - | - | - | |||||||||||||||||||||||||||||||||
5 | 1,300 | 500 | 650,000 | 6 | - | - | - | |||||||||||||||||||||||||||||||||
6 | 900 | 350 | 315,000 | 3 | - | - | - | |||||||||||||||||||||||||||||||||
7 | 100 | 250 | 25,000 | 4 | - | - | - | |||||||||||||||||||||||||||||||||
Total | 200,000 | 600,000 | - | 600,000 | - | - | - | - | - | 1,400,000 | 800,000 | - | - | 600,000 | - | - | 800,000 | - | - | 600,000 | - | - | 2,800,000 | 800,000 | - | - | 600,000 | - | - | - | - | - | - | - | - | 1,400,000 | ||||
Note: | ||||||||||||||||||||||||||||||||||||||||
1 | There are almost more then 1000 rows in this sheet and around five years plan but this is only sample | |||||||||||||||||||||||||||||||||||||||
2 | I am forecasting that the shop number 1 will be occupied on April 2017, and we will receive rent on the same month & then next rent will be after 6 months plus grace period as in example | |||||||||||||||||||||||||||||||||||||||
3 | Now I am making it manually, like when the shop is occupied in April 2017 then I have to shift all year accordingly. | |||||||||||||||||||||||||||||||||||||||
4 | Or I am forecasting for May 2017 to rent the shop but it is not occopied on the same months and I have to shift it manually to next month and all the months I have to do it manually with 6 month plus grace period.. | |||||||||||||||||||||||||||||||||||||||
5 | I want to make it by formula, means if I enter any number in any month then all the data should automatically be calculated in specific cell with specific interval up to end of all years | |||||||||||||||||||||||||||||||||||||||
6 | If for example shop # 3 didn’t occupied on the same month in which I forecasted the I have to shift it to next month means August 2017 and then manualy for all the years. |
<colgroup><col span="4"><col><col span="2"><col><col><col span="5"><col><col><col><col><col><col span="2"><col><col><col><col><col span="2"><col><col><col><col><col><col span="8"><col></colgroup><tbody>
</tbody>
please help