Using Excel to automate the preparation of coke pushing plans
Thread Content
This post was last edited by dzzwd on 2017-4-27 00:43. Excel can be used to semi-automatically create coke pushing plans and display the coking status, which greatly facilitates coke production management and operational processes! Update notes for the Excel automated scheduling tool for coke pushing plan (Version 2): 1. This Excel automated scheduling tool for coke pushing plan (Version 2) adds the functionality to select the sequence of coke pushing (2-1, 5-2, 9-2) based on the first version, enabling it to better meet the needs of each 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!
This post was last edited by dzzwd on 2017-4-17 09:14. We are now uploading the automated coke pushing plan tool that we use; those who need it can go ahead and use it! (Attachments are on the first floor)
This post was last edited by dzzwd on 2017-4-7 at 00:12. After two years of developing an automatic coke oven scheduling system using various functions in Excel 2003, I found this tool to be very useful for coal coking enterprises; it has been downloaded three times in the six days since it was posted, and I believe it works well
While downloading the material, thanks to the original poster for sharing it
Users who downloaded the attachment, how is it working for you? We are all warriors fighting in the field of coal coking; I hope this will be useful to everyone. Now I’m thinking again about how to modify it based on the attachment above so that all three serial sequences can be used.
This post was last edited by dzzwd on 2017-4-17 09:17. Update notes for the Excel automation tool for coke pushing plans (Version 2): 1. This tool (Version 2) adds the functionality to select the sequence of coke pushing operations (2-1, 5-2, 9-2), building on the features of Version 1 and thus enabling it to better meet the needs of each 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. (Attachments are on the first floor.) I hope this will bring convenience to everyone; wish you all a pleasant workday!
There are still quite a few users who download the attachments. How are you all finding them to use? The feedback from fellow sailors is the motivation that drives me to keep exploring and making improvements:lol:lol:lol
This post was last edited by wangshaobo on 2017-4-26 at 14:08. After downloading it for 3 wealth points, a compressed file is obtained; upon uncompressing it, the \"Usage Instructions\" file appears, with content as shown in the image. I can’t understand it – mainly because my computer skills are very poor. I tried to open that Excel file, but it was said to pose a security risk; I didn’t dare to proceed with running it