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

Search results

  1. O

    How to do iteration calculation using VBA in Excel

    @vletm 5% is the value from my original model, as i cant paste all the values here because of the size so i just took 0.5% as an example. with current, it was a mistake. i should have written 0.06. car load table is not the output. output tables are below. If current OR voltage value is above...
  2. O

    How to do iteration calculation using VBA in Excel

    I am making a model of Electric vehicle load on electric grid. I was using formulas to calculates things but now what i need to do will not be possible with formulas. I have not worked with VBA before so have no idea how to do it. if someone can help, it will be great. I have attached a part of...
  3. O

    Making a bar graph with dummy column in Excel

    I am not sure. couldnt be. maybe someone traced the line with a pen or something
  4. O

    Making a bar graph with dummy column in Excel

    Vletm Thank you very much for your help. i really appreciate it
  5. O

    Making a bar graph with dummy column in Excel

    yes great, we can put it as legend and show which color represents what. can you explain a little bit how you made this. Thanks
  6. O

    Making a bar graph with dummy column in Excel

    yes exactly, where the length of the bars (x axis) show hrs and height (y axis) shows MW
  7. O

    Making a bar graph with dummy column in Excel

    no i meant this graph. someone asked a question in comments and asked how to make it. find it in comments. one person explained how to make it. but i cant make it work.
  8. O

    Making a bar graph with dummy column in Excel

    Vletm, i found this one link. where similar data like mine is put in a graph. but i cant make it work. please have a look if you can understand it. it uses a dummy column, this is why i wrote dummy column in my post title. https://peltiertech.com/variable-width-column-charts/ please look in...
  9. O

    Making a bar graph with dummy column in Excel

    Hi vletm, I dont have that data. Thats uploaded just for example.
  10. O

    Making a bar graph with dummy column in Excel

    Hello Hui Thanks for the answer, but i need to y axis as MW and the height of each bar should show MW. E.g if the MW of 1 turbine is more the height would be more if MW is low the height would be low. And on x axis it should show the exact operating hours. Like for the most operating turbine...
  11. O

    Making a bar graph with dummy column in Excel

    I need to create a graph just like the one shown in the picture i attached. it does not need to have the curve, rectangular bars would be fine. but the axis should be the same. from what i searched, i found out i have to make dummy columns but I cant figure out how to make it in excel. If...
  12. O

    shifting a load of Electric Vehicle to the next row if a condition is not fulfulled in excel

    vehicle is plugged in for 45 mins, (it is mentioned in the description inside the excel file) for 45 mins this load will be constant and yes after 45 mins 11kw will reduce. but during this 45 min if any other vehicle is plugged in the load at that point of time would be 22 kw hope this answered...
  13. O

    shifting a load of Electric Vehicle to the next row if a condition is not fulfulled in excel

    I am making a scenario in excel where Electric vehicles are being charged in a given time range. i have a neighborhood loads and the load of EV at specific times. the cable capacity is 50 kW (means the combined load of EV and household should not exceed this value). is there a formula, which...
Back
Top