Omar Khan
New Member
Members
Forum Posts: 1
Member Since:
July 22, 2018
July 22, 2018
Offline
Hello,
Maybe you can help me. i have attached a sample. below is the description of the task
i have line load in column B, but the line in capped to 100 kW so the load more than 100 kW should be shifted to the cells where the load is less than hundred (can be seen in column D). from the table, we see the accumulated load to be shifted is 25 kW. this should be shifted to the cells starting from F24 onwards. but the value in row E should be completely filled before overflowing to the next cell. when it reaches the end of the table, it should move to the top and start distributing.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Riny van Eekelen, Joerg Burger, RACHEL LAWRENCE, MacNaughton Finance
Guest(s) 12
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Excel Learner
david gavi
Rick KISA
Jan Elenbaas
Ranjeet Wankhade
Sugata Maity
Karen McCarron
Amanda Zibell
Kevin Sanderson
wer klaus
Forum Stats:
Groups: 3
Forums: 24
Topics: 6880
Posts: 30158
Member Stats:
Guest Posters: 49
Members: 33700
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —