Excel File to Build Proposals

Closed
Entries
16
Prize (USD)
$30

Contest Brief

I need an excel file to be used to build sale proposals as follows:
- first sheet: is the result proposal contains
First Line : in the top middle the logo of the our company, on the right the name of the company and in the left the date of today.
Second line: "Customer Name:" and The Name of customer
Third line: "Project Name: and project title
Fourth line: "Responsible Person" and the responsible name
Fifth line: "Comments: " and comments

Then followed by number of sections each section gets its information from remaining sheets (i.e. Section 1 gets information from sheet 2, Section 2 gets information from sheet 3, and so on
The section format will be:
First line of section is the name of the section taken from the name of the sheet
Second line of the section is Column titles: Seq. num. , Item code, Description, quantity, U Price, Total Price.
Third, fourth, fifth ... lines of the section are rows of the table contains the values which taken from the correspondence sheet except the total price which is calculated as unit price by quantity.
The last line contains the word: "Total" and the sum of total prices of items.

After Sections, a single line contains the "Whole Total:" and the sum of the totals for each section (in numbers and pronounced in letters).
In each remaining sheets:
first line of the section is Column titles : Seq. num. , Item code, Description, quantity, buy U Price, profit percentage, U price (which is buy u Price multiply by profit percentage)
Third, fourth, fifth ... are lines of the table which contains cells entered by the user to define the items, quantity and price.

Notes:
- number of sections depends on number non empty sheets after the first
- Number of lines of the section (items) are varying according to number of lines (item rows) in each remaining sheet.
-

Recommended Skills:

Post a Contest like this

Previous Poll Results

Submit Your Entry

Drag and Drop multiple files here.


Describe your entry here (optional).


1000 characters
This entry is entirely my own original work and I agree to the Freelancer.com Terms and Conditions.
Submit Entry

Please ensure the following:

  • You've read the contest brief
  • You've read feedback provided by the contest holder
  • You've looked at other entries and read the message board

Supported file types:
JPG, PNG, GIF

  1. Winner
    entry number 5
    #5 for Excel File to Build Proposals by wtreymacyucy
    0 Likes
  2. Report
    entry number 6
    #6 for Excel File to Build Proposals by FahimAhamed
    0 Likes
  3. Report
    entry number 4
    #4 for Excel File to Build Proposals by jcgillet
    0 Likes
  4. Report
    entry number 17
    #17 for Excel File to Build Proposals by grapaa
    0 Likes
  5. Report
    entry number 12
    #12 for Excel File to Build Proposals by persian1988
    0 Likes
  6. Report
    entry number 11
    #11 for Excel File to Build Proposals by renovamenars
    0 Likes
  7. Report
    entry number 7
    #7 for Excel File to Build Proposals by tinuragul99
    0 Likes
  8. Report
    entry number 16
    #16 for Excel File to Build Proposals by grapaa
    Rejected
    0 Likes
  9. Report
    entry number 15
    #15 for Excel File to Build Proposals by grapaa
    Rejected
    0 Likes
  10. Report
    entry number 14
    #14 for Excel File to Build Proposals by grapaa
    Rejected
    0 Likes
  11. Report
    entry number 3
    #3 for Excel File to Build Proposals by diptisamant84
    Rejected
    0 Likes
  12. Report
    entry number 2
    #2 for Excel File to Build Proposals by princewhin
    Rejected
    0 Likes
  13. Report
    entry number 1
    #1 for Excel File to Build Proposals by moustafaa
    Rejected
    0 Likes
  14. Report
    entry number 10
    Withdrawn
  15. Report
    entry number 9
    Withdrawn
  16. Report
    entry number 8
    Withdrawn

Public Clarification Board