'Generate Master Detail Sales Data Based on Excel 365
I have multiple stores, say 20.
Every Store has an opening - closing time from 10AM - 10PM. I have a time bucket of 2 hours, so 5 bucket of 10-12, 12-14, 14-16,16-18,18-20 I am now trying to generate dummy sales data in Excel So as an example am looking at
| Id | serial | date | timebucket | qty | amt | Store |
|---|---|---|---|---|---|---|
| 1 | 1 | 2020-01-01 | 10-12 | 2 | 210 | Store1 |
| 1 | 2 | 2020-01-01 | 10-12 | 5 | 10 | Store1 |
| 1 | 3 | 2020-01-01 | 10-12 | 1 | 854.23 | Store1 |
| 2 | 1 | 2020-01-01 | 10-12 | 2 | 1257.7 | Store1 |
| 3 | 1 | 2020-01-01 | 12-14 | 10 | 210 | Store1 |
| 3 | 2 | 2010-01-01 | 12-14 | 8 | 5 | Store1 |
Replicate this data for stores 1 to 20 For the 5 time buckets Is this doable using sequence and randbetween?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|