Excel automated scheduling tool for coking plant coke pushing plans
Thread Content
This post was last edited by dzzwd on 2017-4-27 at 23:06. 1. The Excel-based tool for automatically scheduling coke pushing operations (Version 2) now includes the option to select the sequence of coke pushing operations (2-1, 5-2, 9-2), which enables it to better meet the needs of each coal coking plant. 2. Since calculating large loops requires a function to find the \"least common multiple\", and this function is not available in Excel 2003, a solution is provided in the attachment this time. I hope this will bring convenience to everyone. Wishing you all a pleasant workday!
So many users have downloaded the attachment; how are you all finding it? I hope marine friends will provide feedback; your input is what motivates me to keep exploring and making improvements:lol:lol:lol
“\"Excel for Automated Pushing Plan Preparation (2nd Edition)\” contains no macro commands and will not cause any harm to your computer. “The method for solving the issue of Excel 2003 not having a function for finding the least common multiple is intended to help those who are still using Excel 2003 in overcoming the problem of being unable to automatically calculate the LCM. For Excel 2007 and later versions, one can simply open the file “Excel Implementation for Automated Pushing Plan Preparation (Version 2).xls”; following the instructions provided in the worksheet, adjustments can be made and the changes in the worksheet can be observed until it meets one’s needs. The contents of the worksheet will not change as long as it is not saved. Additionally, our factory’s 1# and 2# coke ovens have a total of 78 carbonization chambers; the total number of such chambers in other companies may vary. Those who need this information adjusted can let me know. I may also develop a universal coke pushing plan formulation tool based on the second version, one that can meet the needs of different total numbers of carbonization chambers. Thank you for your generosity; I hope it’s useful to you! I have re-uploaded the instructions!