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

Progress Chart for Road works

Status
Not open for further replies.

vletm

Excel Ninja
PRO
Where need any new that type of format?
You would copy that file and
start to modify needed Your information there.
 

PRO

New Member
PRO
1st sentence - okay.
2nd - If I remember about 2yrs old code
... extra layers would be a challenge. Do You need to use all 'old' layers?
3rd - You can add, but it won't work without hours and hours coding.
Sir, i understand that it will take time but it would really be a great help to me as i have got stuck in my works.
All i need is to add the required no of layers.
I hope you will understand the situation.
 

vletm

Excel Ninja
PRO
Yes, I'll understand Your situation.
You are stuck in Your works and
same time, I should do use hours and hours my own time.
It won't be something copy & paste case!
Do You understand the situation?
 

PRO

New Member
Sir I know it will take some of your precious time but it is my humble request to you to please consider this work. And as you are proficient in MS Excel,I believe you will do it in less time. All it needs is minor changes so that it will give the desired output.
It really will be great help sir.
Please consider it for once.

Thanks
 

vletm

Excel Ninja
As You would understand..
... even 'minor changes' would easy means 24hrs 'minor coding' or more!
... and after that 'some more times with testing'
... and so on!
I normally ever won't use term 'minor' with these.
... but it would be sure that I would do it quicker than You.
I can put it in my list ...
 

PRO

New Member
Yes sir i believe you.
Please put it in your list and that too on the slightly above level. :D
I am waiting for your kind help sir.

PS: There is no doubt about your speed sir. :)

hoping for an early action.
 

PRO

New Member
Hello sir,
I have received your attachment, I will go through it soon and revert back to you.
PS: Thanks for your quick response.
 

RaviKumar.K

New Member
Hello Mr. Vletm nice to see you after long time :)
Here i have a small doubt which is "in output sheet boxes alignment is slightly misaligned". As per previous conversation it will happened due to version change.
Here with i would like to request you to clarify for which version width of the column & height of row is suggestible.
And another one is for me & Mr. PRO have a same common problem is our chainage was starting from some around 200+000 (it will be changed due to our packages & locations) but this strip chart is starting with 0+000 will you do any favor in this issue pls....
I hope it was a positive reply to me from your end :)
 
Last edited:

vletm

Excel Ninja
RaviKumar.K
for which version width of the column & height of row is suggestible.
What would You mean?
I only figure that if You change any of those
then output would be 'Your like' maybe not wanted!
Mean, do not change!
There is ONLY one cell,
where someone would do setting for 'rowheight'! =
'tmp's Cell A1.
That has depend Excel-version!
I use value 14!

What would mean term 'problem'?
> from some around 200+000 < ... hmm?
1) Start need to be fixed value!
2) The end need to know too!
>> Do someone ever need smaller than ~200+000 values?
or
it would also work
after add those values to column BY as much needed and
take care that BY10 value is at least max value.
>> Do someone use one file? or many files?

Term 'positive' has many meanings ... I try to give 'soft' reply.
 

RaviKumar.K

New Member
RaviKumar.K
for which version width of the column & height of row is suggestible.
What would You mean?
I only figure that if You change any of those
then output would be 'Your like' maybe not wanted!
Mean, do not change!
There is ONLY one cell,
where someone would do setting for 'rowheight'! =
'tmp's Cell A1.
That has depend Excel-version!
I use value 14!

What would mean term 'problem'?
> from some around 200+000 < ... hmm?
1) Start need to be fixed value!
2) The end need to know too!
>> Do someone ever need smaller than ~200+000 values?
or
it would also work
after add those values to column BY as much needed and
take care that BY10 value is at least max value.
>> Do someone use one file? or many files?

Term 'positive' has many meanings ... I try to give 'soft' reply.

Hello Sir, Good to see you :)

Attached strip chart was downloaded from reply # 84. I made some corrections like adding chainage up to 300+000.

In this strip chart my chainage starts from 220+150 but the boxes is showing some around 226+440, and you can see that the boxes are slightly moved towards right side (image also enclosed).

when am adding the chainage in output sheet, the file was going hang for few seconds.

"What would mean term 'problem'?
> from some around 200+000 < ... hmm?
1) Start need to be fixed value!
2) The end need to know too!
>> Do someone ever need smaller than ~200+000 values?
or
it would also work
after add those values to column BY as much needed and
take care that BY10 value is at least max value.
>> Do someone use one file? or many files?"

Few of them our Road Projects will starts with Chainage like 086+060 or 220+115 or 551+865 or 2102+254, it will vary by our road projects and it depend upon its length.

I was tried to change the cell value in "BY11" instead of "000+000" with "220+115" it is not allowing when I click on "DO IT".

Thank You in advance...
 

Attachments

vletm

Excel Ninja
RaviKumar.K
> I made some corrections like ...
> In this strip chart my chainage starts from 220+150 but the boxes is showing some around 226+440, and you can see that the boxes are slightly moved towards right side (image also enclosed).
I checked that file,
question: has someone told to correct eg zoom%?
... No! Let it be 100%!
All matters! 100% as below.
Screen Shot 2018-06-01 at 15.52.37.png

> when am adding the chainage in output sheet, the file was going hang for few seconds.

If You do same manually by pencil,
how long time it would take to make whole 'output'-sheet?
One sec or few seconds or even more longer?

Many cases, if need to do something more ... it would take longer time.

> I was tried to change the cell value in "BY11" instead of "000+000" with "220+115" it is not allowing when I click on "DO IT".
Hmm.. why did I try to give some hints? and You do something different?
There are rules how this would work!
It's much easier to get wrong result that 100% correct,
especially if not follow rules or hints!
Eg if You write to 'wrong' cell word 'cat' ... maybe it won't work!
Did You read my replies?
Maybe, some of those, You have skipped!

That PRO, who wrote: All i need is to add the required no of layers.
and something in #85 ... hmm? Term 'Soon' seems to be over 48hrs.
 

RaviKumar.K

New Member
RaviKumar.K
> I made some corrections like ...
> In this strip chart my chainage starts from 220+150 but the boxes is showing some around 226+440, and you can see that the boxes are slightly moved towards right side (image also enclosed).

I checked that file,
question: has someone told to correct eg zoom%?
... No! Let it be 100%!
All matters! 100% as below.
View attachment 52655

> when am adding the chainage in output sheet, the file was going hang for few seconds.

If You do same manually by pencil,
how long time it would take to make whole 'output'-sheet?
One sec or few seconds or even more longer?

Many cases, if need to do something more ... it would take longer time.

> I was tried to change the cell value in "BY11" instead of "000+000" with "220+115" it is not allowing when I click on "DO IT".
Hmm.. why did I try to give some hints? and You do something different?
There are rules how this would work!
It's much easier to get wrong result that 100% correct,
especially if not follow rules or hints!
Eg if You write to 'wrong' cell word 'cat' ... maybe it won't work!
Did You read my replies?
Maybe, some of those, You have skipped!

That PRO, who wrote: All i need is to add the required no of layers.
and something in #85 ... hmm? Term 'Soon' seems to be over 48hrs.


Hello Good Evening :)

"If You do same manually by pencil,
how long time it would take to make whole 'output'-sheet?
One sec or few seconds or even more longer?
Many cases, if need to do something more ... it would take longer time."
Sir you are mistaken me, what i mean is if the chainge Value stars with 0+000 to 100+000 then the calculation part is low so that the excel will not hang, while am making the chainage value 0+000 to 500+000 the calculation part taking more time, thats what i mean it, thats why was requested you if there is any chance to change 0+000 replace with some 200+000, I think it is not possible.

Sir i was use the attachment from reply # 84, i was observed that in "output Sheet" on RHS side i was able to change the code but the same time on LHS side was not updating.

And Top Level is missing, i mean there is tabular format for both LHS & RHS "Si no., from, To, Code"
 

vletm

Excel Ninja
RaviKumar.K
More rows means more time.
You cannot select 'start value'!
It could do but as that PRO has asked 'ONLY' something ... but PRO's soon ?
'Start value' modification could take ... time for me + testing...
it's not one minute modification!

Sir i was use the attachment from reply # 84, i was observed that in "output Sheet" on RHS side i was able to change the code but the same time on LHS side was not updating.
Hmm.. what would You try to express?
Screen Shot 2018-06-14 at 15.59.18.png
hmm ... maybe ... if You modify those below RHS texts then
need to click LHS and after that RHS to refresh texts.

And Top Level is missing, i mean there is tabular format for both LHS & RHS "Si no., from, To, Code"
Do You mean this which ... is not missing ... or how?
Screen Shot 2018-06-14 at 15.57.19.png
 

RaviKumar.K

New Member
RaviKumar.K
More rows means more time.
You cannot select 'start value'!
It could do but as that PRO has asked 'ONLY' something ... but PRO's soon ?
'Start value' modification could take ... time for me + testing...
it's not one minute modification!

Sir i was use the attachment from reply # 84, i was observed that in "output Sheet" on RHS side i was able to change the code but the same time on LHS side was not updating.
Hmm.. what would You try to express?
View attachment 52892
hmm ... maybe ... if You modify those below RHS texts then
need to click LHS and after that RHS to refresh texts.

And Top Level is missing, i mean there is tabular format for both LHS & RHS "Si no., from, To, Code"
Do You mean this which ... is not missing ... or how?
View attachment 52891


Hi,

The strip chart downloaded at Reply # 60 enclosed for your reference.
from Column no. "CO to DB" there is a tabular form it giving that top layer with its locations.


Screenshot (6).png
 

RaviKumar.K

New Member
Hi,

That was for your reference (enclosed copy).
In our input we got that only what was the work done at site, but we cant find how much work is to be done, so we have to depend on Strip Charts.
That tabular form will help us to know at what location works was pending.
In new format that tabular form was missing. I need that tabular form back again in the latest file.
 

Attachments

Last edited:

RaviKumar.K

New Member
Sorry i mean am trying to show what i need.
"Top Level" with same heading they 2 two types.
First one is Vertical boxes that shows top layer on Top.
Second one with same heading "Top Level" it generating in text that says the on which location to which location is Top layer. I need that one.

Both Top Levels are required in the latest file. (off-course first one is working good & need as well as second one also)
 

vletm

Excel Ninja
Babu Maharana
As a new member, please, reread Forum Rules
You seems already missed few basic sentences from there.
.. as well as ..
Have You image, what others would do based Your 'I need'-sentence?
... except that You need something
 
Status
Not open for further replies.
Top