• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by arishy

  1. A

    Curve Behavior

    The recording time of the temperature is every 5 minutes. Look at the timestamp. It tells you the value at this time is x
  2. A

    Curve Behavior

    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...
  3. A

    chart with two navigation bars

    This is close to what I want
  4. A

    chart with two navigation bars

    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...
  5. A

    chart with two navigation bars

    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...
  6. A

    chart with two navigation bars

    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...
  7. A

    ListObject...Basics Dr Watson

    Thank you, Dr Holmes
  8. A

    ListObject...Basics Dr Watson

    Public Sub List_Object0() Dim lo As ListObject Set lo = Sheet2.ListObjects("EmpTable") End Sub second line !!!!! Any Clue .... Office 16
  9. A

    Google translate hiccup

    Thank you again for sharing your findings. Your point is load and clear. I am heading now to "The Complete Guide" ....Wish me luck Best regards
  10. A

    Google translate hiccup

    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
  11. A

    Google translate hiccup

    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...
  12. A

    Google translate hiccup

    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...
  13. A

    Bank interest rate calculation

    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...
  14. A

    Bank interest rate calculation

    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...
  15. A

    Cash flow with a twist !!

    Thank you Anil for your followup ; I will look into this app.
See more
Back
Top