020 ACAK Core User Guide - sdupjj/ACAK GitHub Wiki
Please make sure you have try to follow ACAK Core quick start at first.
https://github.com/sdupjj/ACAK/wiki/015-Quick-Start-For-ACAK-Core
0. Idea of ACAK
ACAK Core is very simple program. Size(Less than 300 Kb) is very mini. The logic of ACAK Core is very simple, too.
- Doing something when ACAK opened, doing something when ACAK closed.
- Doing something when One fired, doing something when One finished.
- One engine mechanism (a loop : Detecting environment => Deciding which bundle of actions should run => Run these actions =========== Interface Sensors => M01 => Actions in M02)
1. Let's switch to sheet "core_screen".
- Area 1 is to display current status of ACAK. 2 values : Green/"Done" and Red/"Working".
- Area 2 is to display the "V" above the selected column in M01.
- Area 3 is M00. It is to show how many loops One Engine has run in different columns. We can set the maximum for total run times and repeat run times for a column.
- Area 4 is M01. After area 7 get the reslut , ACAK will find the availabe column in M01.
- Area 5 is M02. Since Area 4, ACAK will find the availabe column in M02. Then ACAK will run the related actions in right column of M02.
- Area 6 is to show how many loops One Engine can run after fired/ how many loops One Engine have run after ACAK Core.xlsm opened / how many loops One Engine have run after fired.
- Area 7 is to linked with variant interface detective sensors.(three result, Green/1 ; Red/0 ; Gray/0)
- Area 8 is buttons. "One" is to fire the One Engine. "Check status" is to run Area 7 / IFs one time. "*PS1" & "*PS2" is to show the comments. "Close" is to close the comments. "1","2"..."1000" is to setup the One Engine loop times.
2. Make up ACAK
- Switch to sheet"core_display_setup" , setup "pro" or "simple " to decide show Excel functions or not.
- All the styles of the sheets are available to be changed based on your taste.
3. Setup ACAK
- Doing something when ACAK opened, doing something when ACAK closed.
There are 2 columns should be maintianed in sheet "core_ACAK_setup". Column "D" and "H".
There should be input in actions which will be taken just after ACAK (.xlsm file) opened.
There should be input in actions which will be taken just before ACAK (.xlsm file) closed.
Process: Open ACAK ---> Actions in Column "D" ---> ... ---> Actions in Column "H" ---> Close ACAK
- Doing something when One fired, doing something when One finished.
There are 2 columns should be maintianed in sheet "core_engine_setup". Column "D" and "H".
There should be input in actions which will be taken before the One Engine run.
There should be input in actions which will be taken after the One Engine run.
Process: click "Run One" ---> Actions in Column "D" ---> loop 1 ... last loop number ---> Actions in Column "H" - Setup ACAK
In sheet"core_setup", there are many variables can be set. Most of them are not needed to be changed.
But when you changed IF, M00, M01, M02 in screen "core_screen", some variables should be maintained.
They are "M01 Rows" , "M01 Cols" , "M02 Row Start Number" , "M02 Col Start Number" , "M02 Rows" , "M02 Cols".
4. Arsenal
As mentioned, Actions and Interface Sensors are the hands and eyes of ACAK.
- You can find all availalbe Actions and Interface Sensors in sheet "core_actions" and sheet "core_ifcamp".
- Configure Interface Sensors in sheet"core_if". If you want to add one more IF, just need add one more line in sheet"core_if".Then double click column B. Select what you want.
- Add/Change one more action in M02, "core_engine_setup" and "core_ACAK_setup". Just double click where you want to put the new action. And select it.
- Based on point 3.3, some settings should be changed. Pls also changed IF, M00, M01, M02 in screen "core_screen" if need.
5. Built-in function COUNT
- I want to have a friend place to put some variables. It should be very easy to modify. So I built a sheet"core_count". There could be hundreds of "countXXX" to be used.
- Some actions work with these countXXX, such as a_AddOne(Whichcount As String). The built-in interface sensor "if_IFonCo" is also linked with countXXX.