In the attached sheet you will find how I am getting the time it takes a room temperature to go from H to L when the Air conditional goes ON then it shows how long it takes room temperatures go from L to H. The test data shows fake data to simplify testing.
I need to create a macro to do the...
what do You really have? see above
what do You like to have? a chart with TWO sliding indicators. By manually moving the TWO indicators I can define a period in time and the chart will display energy consumed within this two indicators.
Energy consumed is the sum of ch1_amps_avg for the given...
Glad to hear that. The table is really very simple for the purpose of this post.
Here are the last 5 records out of 264240 rows
<<
year month day hour min ch1_amps_avg dt
264236 2023 8 21 16 27 0.228667 2023-08-21 16:27:00.000
264237 2023...
I have a table of two columns one is time stamp and the other is energy reading in kw. The time span of the readings is one year. I need to create a chart with TWO sliding indicators. By manually moving the TWO indicators I can define a period in time and the chart will display energy consumed...
You are GENIUS ( The most difficult design is a simple design)
You solved ALL my problems in a few lines.
Can you please prove me wrong in my last remark regarding dic.add and using range
Great response.
While waiting for a response, I did google research and got the solution for the IDE limitation. I need to add the Arabic Language to my keyboard.
Once w10 has it, I can input Arabic in the Editor AND use Debug.print to output Arabic. As for MsgBox there are a few solutions bit...
Background:
I have several financial forms in Arabic and I need to translate the Financial labels to English.
Google Translate was not specific enough; so I decided to use my own dictionary.
VBA has this powerful Dictionary Object.
The problem(s):
1. VBA Editor does not like Arabic characters...
The problem cannot be solved by formulas.....( in my view ), so VBA is the solution.
After all, it IS a programming language....So, I need an approach to the problem that can be implemented using VBA. Remember I asked for general help may be when I do some code I will come back with coding...
I need some general help in approaching this problem.
Let say the bank gives you 11.25 % on your saving account. The problem is your saving account balance VARIES during the physical month, so the rule is the bank apply the interest on the MINIMUM balance during the month.
For example ( taken...