Need help on spreadsheet project

salesbot · Posted: Thu Oct 25, 2007 6:00 am Post subject : Need help on spreadsheet project

Need help on spreadsheet project
I am willing to pay for any help!

I get expense and revenue reports from two different companies. What I need to do now is manually refer back and forth between spreadsheets and create a new one by hand with information from both to see where I am making or losing money. I feel that this could...

Author: jdblewitt
Category: Paid work offers and requests
Publish Date: Wed, 24 Oct 2007 19:17:29 GMT

I am willing to pay for any help!

I get expense and revenue reports from two different companies. What I need to do now is manually refer back and forth between spreadsheets and create a new one by hand with information from both to see where I am making or losing money. I feel that this could be easily streamlined for me by having some sort of script or program that reads both spreadsheets and create the third one for me. In theory, this is what I want:

Spreadsheet 1: (Created For Me)

Sales Report For Oct 20-22

Date |Transaction | Sale Amount | Source

Oct 20 | Sale | $10 | Keyword1

Oct 21 | Sale | $8 | Keyword2

Oct 22 | Sale | $12 | Keyword1

-------------------------------------------------

Spreadsheet 2: (Created For Me)

Report for spending for dates Oct 20-22

Source | Spend |

Keyword 1 | $13 |

Keyword 2 | $10 |

------------------------------------------------

Spreadsheet 3: (Needs To Be Created With Program)

Profit or loss for Oct 20-22

Source | Spend | Revenue | Profit/Loss |

Keyword 1 | $13 | $22 | $9

Keyword 2 | $10 | $8 | ($2) |

So basically I just need to compile the two reports (one spending and one revenue) to see what "sources" I am profiting from. I will have several hundred "sources" and several hundred "sales". I need to match up how much I spend and how much I sold per source for the span of the dates that I decide the report to be for. Once again this is the theory. There are a few more bells and whistles I would like, but nothing more complicated than I explained above. Thanks for reading and I hope this was clear enough.

Best,

Jim
Read more...

Source: CodingForums.com - Paid work offers and requests

Google Sites · Posted: Thu Oct 25, 2007 6:00 am Post subject :