Sales Reports

Parra · Apr 29th, 2002, 05:44 PM

Does anyone have any examples of sales report templates that I can view. I am working on updating/creating a new sales report for the company and I need suggestions.

We have 2 departments with approximatly 40 sales reps in each. I need a spreadsheet for each salesrep to measure their revenue generated, commission, account adjustments, revenue transfer. A sheet for each department and a summary sheet. This sounds more easy that it really is.

Any links to websites would also be useful.

Thanks
mr_parra@hotmail.com

Anne Troy · Apr 29th, 2002, 07:13 PM

You might want to ask Jay P for a file he made for me not too long ago.

It was vacations instead of sales, but the same process was involved.

Jay Petrulis · Apr 29th, 2002, 07:18 PM

Hi,

The file is at work. I will send it to you tomorrow. Dreamboat, I have your blessing to send it?

Also, I sent you a private e-mail last week regarding a project you were working on, where I spaced on the message until late Friday. If this is the same, I still have it. If not, please send it to my work address and I will work on it tomorrow. I promise I won't space out on it this time.

john.petrulis@notes.ntrs.com

Bye,
Jay

Anne Troy · Apr 29th, 2002, 07:39 PM

?

Spaced out?

You talking to me? Everything you did for me was BEAUTIFUL, Jay. Thanks!!

Send the file! Feel free to give out. I highly doubt anyone would recognize the names.

I don't!

MrStressed · Apr 30th, 2002, 02:16 AM

Can I be really cheeky and request a copy of that file too. It will probably help me enormously, I need to create something too and i'm struggling.

statto88@blueyonder.co.uk

many thanks

Strider · Jun 2nd, 2002, 07:47 PM

Speaking of Cheek ... I'm creating a grade book for my wife & would greatly appreciate any report help I can get would be greatly appreciated.

jmoore@sdcoe.k12.ca.us

Anne Troy · Jun 2nd, 2002, 11:17 PM

Jay: That file seems pretty popular. Think we could change the names and properties and make it a download? I've been so busy. I had another file from you too, right? Oh! I remember!

Anyway, any good files like that, I'm willing to load them up for download at http://www.thewordexpert.com/downloads.htm

Jack in the UK · Jun 3rd, 2002, 04:44 AM

Hi Dreamboat

downloads i have made noise, maybe you can have a word inside MVP, as this would really help guys, im behind this.

I thank you on behalf of all allowing your web space to be used.

Cheers

Anne Troy · Jun 3rd, 2002, 08:46 PM

Actually, Jack, I don't pay for my web space. I do a little Access work now and then for the hostess, and a terrific hostess she is. She doesn't need some Access developer or anything, but it sure would cost her a lot to find someone that can do what I can for her, because *average* Access experts don't advertise for work. It's worked out VERY well TheWordExpert, and I'm a *share-the-wealth* kind of gal.

If you have any suggestions for downloads, Jack, I hope you'll let me know!

Jack in the UK · Jun 4th, 2002, 04:36 AM

Yes i have as my above post said fought to have attachment in the posts, but thats not workable so easy from a tech point of view.

Also say you said OK, ill have my site with Download areas, who decides what up there???

OK we can say the goodie as i called them Audiojoes say was worth but they must be that good, and free to all,

Again we tread on the merky world o the internet and this might not be so workable, on V90 56k modem wire connections, the US have ADSL the UK its getting there, im in no rush but other guys will find a 1MB file impossable to leach down.

Security and attack is an issue, we all know the enamy is within.

The worlds full of fools and wee need to cater for tjis in any approach we make, else so IDIOT will infect the downlaods and all sort..

Yup i am fully protected, so i can check any files as i need, deep. but i was subject to a campaign of attack, and all failed, even the hacker.. FAILED ho hum!

Worth thinking about... ill look into this more and how to make ithe area JACK tight security else i want no part in it, not worth the risk, email between us is safer otherwise.

Macro virus are not that bad and rare now days, laroux II poped up the other day at work, i was not allowed a copy of that, sadly....

I have Laroux I so can test a secure area, ill look into this.

Apr 29th, 2002, 07:13 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	You might want to ask Jay P for a file he made for me not too long ago. It was vacations instead of sales, but the same process was involved. __________________ ~Anne Troy

Apr 29th, 2002, 07:39 PM	#4
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	? Spaced out? You talking to me? Everything you did for me was BEAUTIFUL, Jay. Thanks!! Send the file! Feel free to give out. I highly doubt anyone would recognize the names. I don't! __________________ ~Anne Troy

Jun 2nd, 2002, 11:17 PM	#7
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Jay: That file seems pretty popular. Think we could change the names and properties and make it a download? I've been so busy. I had another file from you too, right? Oh! I remember! Anyway, any good files like that, I'm willing to load them up for download at http://www.thewordexpert.com/downloads.htm __________________ ~Anne Troy

Jun 3rd, 2002, 04:44 AM	#8
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi Dreamboat downloads i have made noise, maybe you can have a word inside MVP, as this would really help guys, im behind this. I thank you on behalf of all allowing your web space to be used. Cheers __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Jun 4th, 2002, 04:36 AM	#10
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Yes i have as my above post said fought to have attachment in the posts, but thats not workable so easy from a tech point of view. Also say you said OK, ill have my site with Download areas, who decides what up there??? OK we can say the goodie as i called them Audiojoes say was worth but they must be that good, and free to all, Again we tread on the merky world o the internet and this might not be so workable, on V90 56k modem wire connections, the US have ADSL the UK its getting there, im in no rush but other guys will find a 1MB file impossable to leach down. Security and attack is an issue, we all know the enamy is within. The worlds full of fools and wee need to cater for tjis in any approach we make, else so IDIOT will infect the downlaods and all sort.. Yup i am fully protected, so i can check any files as i need, deep. but i was subject to a campaign of attack, and all failed, even the hacker.. FAILED ho hum! Worth thinking about... ill look into this more and how to make ithe area JACK tight security else i want no part in it, not worth the risk, email between us is safer otherwise. Macro virus are not that bad and rare now days, laroux II poped up the other day at work, i was not allowed a copy of that, sadly.... I have Laroux I so can test a secure area, ill look into this. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 29th, 2002, 05:44 PM	#1
Parra Board Regular Join Date: Feb 2002 Location: Los Angeles, CA Posts: 752	Does anyone have any examples of sales report templates that I can view. I am working on updating/creating a new sales report for the company and I need suggestions. We have 2 departments with approximatly 40 sales reps in each. I need a spreadsheet for each salesrep to measure their revenue generated, commission, account adjustments, revenue transfer. A sheet for each department and a summary sheet. This sounds more easy that it really is. Any links to websites would also be useful. Thanks mr_parra@hotmail.com

Apr 29th, 2002, 07:18 PM	#3
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, The file is at work. I will send it to you tomorrow. Dreamboat, I have your blessing to send it? Also, I sent you a private e-mail last week regarding a project you were working on, where I spaced on the message until late Friday. If this is the same, I still have it. If not, please send it to my work address and I will work on it tomorrow. I promise I won't space out on it this time. john.petrulis@notes.ntrs.com Bye, Jay

Apr 30th, 2002, 02:16 AM	#5
MrStressed Board Regular Join Date: Mar 2002 Location: Kent, the Garden of England, that no one has bothered to weed. Posts: 62	Can I be really cheeky and request a copy of that file too. It will probably help me enormously, I need to create something too and i'm struggling. statto88@blueyonder.co.uk many thanks

Jun 2nd, 2002, 07:47 PM	#6
Strider New Member Join Date: May 2002 Location: Strider Posts: 6	Speaking of Cheek ... I'm creating a grade book for my wife & would greatly appreciate any report help I can get would be greatly appreciated. jmoore@sdcoe.k12.ca.us

Jun 3rd, 2002, 08:46 PM	#9
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Actually, Jack, I don't pay for my web space. I do a little Access work now and then for the hostess, and a terrific hostess she is. She doesn't need some Access developer or anything, but it sure would cost her a lot to find someone that can do what I can for her, because average Access experts don't advertise for work. It's worked out VERY well TheWordExpert, and I'm a share-the-wealth kind of gal. If you have any suggestions for downloads, Jack, I hope you'll let me know!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode