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