# Monthly summary party wise from a range and duplicate do want to make one qty

1. ## Monthly summary party wise from a range and duplicate do want to make one qty

Dear Sir,

Need help for monthly revenue party wise and weekly trips duplicated DO count in one qty.

auto formula need in report sheet.

Thanks and regards
Dackson.

2. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

Removed!!...........

3. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

In N4, copied down:

=COUNTIF(ENTRY!\$C\$3:\$ER\$20,REPORT!M4)

In O4, copied down:
=SUMIF(ENTRY!\$C\$3:\$ER\$20,M4,ENTRY!\$G\$3:\$EV\$20)

if this is NOT whjat you want, please explain more clearly...

4. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

sr no and party name also need to come automatically from entry sheet, please fill highlighted area

5. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

How is this derived .."WEEKLY DUPLICATED DO QTY" ?

6. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

We are preparing delivery order (DO) for each vehicle trip, normally each trip against each delivery order (DO) will be generated But some cases vehicle have weekly committed trips, for that weekly trips preparing one Delivery Order (DO) only and all dates in between the weekly DO. For example 1st, 2nd, 3rd days 3 trips are generated but DO no A1582 same only, that mean DO no A1582 weekly DO. All weekly DO date will be last trip date, for this case 3rd was last trip. So DO date has been 3rd only. In this case 1st and 2nd day DO quantity doesn’t want to count in “NET DO QTY”, only 3rd day will add in Net DO QTY. i hope you understand.
DAckson.

7. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

for sample of weekly Delivery Order (DO)

9. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

please explain the smiley's. I don't understand the meaning of it.

10. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

Just pop up for viewing alert

11. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

You get better result on your question if you add a small excel file, without confidential information.

12. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

Yes i will do for clear for you. Pls wait...

13. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

Pls find the attachment for more clarity. Of #5

14. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

you have the formula in N4 and O4

Why do you need the answers in D4 ad E4 as well?

Probably I don't understand the question.

15. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

I have looked at this several times, as have others.

No-one seems to know what you want. remove ALL the JUNK from your sheet. your report sheet has 26 columns!!! REMOVE ALL THAT ARE NOT REQUIRED. I have NO IDEA what you want. So, Explain what you want and show your expected results.

16. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

My understanding is as follows:

DO=Delivery Order

A delivery order can apply to more than one day and in this case we subtract 1 from "On Jobs Trips" on the start day until the penultimate day when such a delivery order expires.

e.g. A1582 applies to Days 1 to 3 so we subtract 1 from "On Jobs Trips" for Days 1 and 2 and 0 on Day 3.

And there may be more than one "multiple" DO starting and finishing on the same days e.g BK2121/CF3305 start on Day 14 and both finish on Day 17 so we subtract 2 from "On Jobs Trips" for days 14,15 and 16 and 0 on Day 17.

I assume it is possible to have the same start day but different finish day (or vice versa) when there are 2 (or more) "multiples"..

.... so we have look through 30/31 days of data, find the "multiple" DOs, determine their start/Finish days and then do the calculations above.

17. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

Yes you are right!!!!!!!!!!!!
We want to count how many duplication do nos is generated that treat one qty only. Do duplicated days not count in net do qty, only count treat last day of duplicated do no.

18. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

Dear Sir,
Important point I want to get count of Delivery Order No. one example for your awareness. I have 18 vehicles the 1st day 18 trips executed against that 18 trips 18 Delivery order no also generated. Then 1st day was 18 trips and 18 delivery order nos. This same 2nd day 18 trips executed against that 18 trips 18 Delivery order no also generated. Then 2nd day was 18 trips and 18 delivery order nos. This same 3rd day 18 trips executed against that 18 trips 18 Delivery order no also generated. Then 3rd day was 18 trips and 18 delivery order nos. Altogether in 3 days trips are executed 1st day 18 trips + 2nd day 18 trips + 3rd day 18 trips =54 trips and Altogether in 3 days Delivery Order No are generated 1st day 18 Delivery Order No + 2nd day 18 Delivery Order no + 3rd day 18 Delivery Order No =54 Delivery Order No. I hope up to here everybody can understand. Now starting the logic condition, in example 3 days 54 trips and 54 delivery order No are generated. but please find from above attached excel file, the veh 15 have same Delivery order no In 1st , 2nd & 3rd days which is colored (find 17th row). That means the vehicle trips was 54 but count of Delivery Order No actually 52 only. We are ignoring 1st day and 2nd day Delivery Order No quantity due to the same DO no (auto formula required in I3:I33 ) but 3rd day is last day of this same DO no, So we are counting in Delivery Order No quantity. Which days ignoring that day reducing from veh trips, then I will get that concern day Delivery order no count.
How many duplication DO no are generated from the range of C3:EV20 and how many time each DO no are duplicated that I want to reduce from the daily wise veh trips in each day.
DAY : VEH TRIPS : IGNORE DUPLICATED DO QTY : DELIVERY ORDER NO QTY
1 18 – 1 =17
2 18 – 1 =17
3 18 – 0 =17

19. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

SORRY IGNORE DUPLICATED DO QTY (auto formula required in I4:I33 )

SR # FORMULA NEED FROM B4 COLUMN AND PARTY NAME FORMULA NEED FROM C4 COLUMN

20. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

Do you not have answer to this in post #3?

21. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

In N4, copied down:

=COUNTIF(ENTRY!\$C\$3:\$ER\$20,REPORT!M4)

N4 FORMULA NEED IN D4, WANT TO FILTER ON JOB VEH ONLY. PARTIALLY ITS WORKING FINE

In O4, copied down:
=SUMIF(ENTRY!\$C\$3:\$ER\$20,M4,ENTRY!\$G\$3:\$EV\$20)

O4 FORMULA NEED IN E4, ITS WORKING FINE

BUT i NEED IN B4 INDEX FROM THE RANGE OF C3:EV20, THE INCREMENT COUNT OF PARTY NAME WITH OUT DUPLICATION.

AND I NEED IN C4 INDEX FROM THE RANGE OF C3:EV20, THE PARTY NAME WITH OUT DUPLICATION.

22. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

HI,
Glenn Kennedy/oeldere /JohnTopley
Regards,
Dackson.............

23. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

....N4 FORMULA NEED IN D4, WANT TO FILTER ON JOB VEH ONLY. PARTIALLY ITS WORKING FINE
How as you require "filtering" by party in C4.

...THE INCREMENT COUNT OF PARTY NAME
Does this mean you want count of (for example) number of PARTY 1 in the range?

24. ## Re: Monthly summary party wise from a range and duplicate do want to make one qty

yes ... filter On Job in "vehicle status" column, from all range C3:EV20 that DO count required.

how many party in on job the range C3:EV20 that count 1,2,3,4,6, etc .. avoid duplication of party list.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

## X vBulletin 4.1.8 Debug Information

• Page Generation 0.09501 seconds
• Memory Usage 9,527KB
• Queries Executed 16 (?)
Template Usage (35):
• (2)bbcode_quote
• (1)footer
• (1)forumrules
• (1)gobutton
• (24)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (4)postbit_attachment
• (24)postbit_legacy
• (24)postbit_onlinestatus
• (24)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
Included Files (39):
• ./vbseo.php
• ./env.php
• ./vbseo/includes/functions_vbseo.php
• ./vbseo/includes/functions_vbseo_pre.php
• ./vbseo/includes/functions_vbseo_url.php
• ./vbseo/includes/functions_vbseo_createurl.php
• ./vbseo/includes/functions_vbseo_db.php
• ./vbseo/includes/functions_vbseo_vb.php
• ./vbseo/includes/functions_vbseo_seo.php
• ./vbseo/includes/functions_vbseo_misc.php
• ./vbseo/includes/functions_vbseo_crr.php
• ./vbseo/includes/functions_vbseo_cache.php
• ./vbseo/includes/functions_vbseo_hook.php
• ./vbseo/includes/functions_vbseo_startup.php
• ./includes/config.php
• ./global.php
• ./includes/class_bootstrap.php
• ./includes/init.php
• ./includes/class_core.php
• ./includes/functions.php
• ./includes/class_friendly_url.php
• ./includes/class_hook.php
• ./includes/functions_cforum.php
• ./includes/functions_bigthree.php
• ./includes/class_postbit.php
• ./includes/class_bbcode.php
• ./includes/functions_reputation.php
• ./includes/class_bootstrap_framework.php
• ./vb/vb.php
• ./vb/phrase.php
• ./packages/vbattach/attach.php
• ./vb/types.php
• ./vb/cache.php
• ./vb/cache/db.php
• ./vb/cache/observer/db.php
• ./vb/cache/observer.php
• ./includes/functions_notice.php

Hooks Called (49):
• init_startup
• friendlyurl_resolve_class
• database_pre_fetch_array
• database_post_fetch_array
• global_bootstrap_init_start
• global_bootstrap_init_complete
• cache_permissions
• fetch_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• cache_templates
• template_register_var
• parse_templates
• notices_check_start
• notices_noticebit
• process_templates_complete
• reputation_image
• postbit_imicons
• bbcode_parse_start
• bbcode_parse_complete_precache
• bbcode_parse_complete
• postbit_attachment
• postbit_display_complete
• memberaction_dropdown
• tag_fetchbit_complete