>
>

Excel File to Build Proposals

Excel File to Build Proposals

Closed
Entries
14
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
$ USD
NEW! - Set a price for your entry and if you don't win, you will have a second chance for the contest holder to buy your entry!
Upgrade your entry
  • Seal your entry to ensure your idea is unique. Only you and the contest holder will be able to view your sealed entry.

    $0.50 USD
  • Highlight your entry to make it visually stand out from the rest!

    $0.50 USD
Total: $ 0.00 USD
This entry is entirely my own original work and I agree to the Freelancer Terms and Conditions.
Submit Freelancer Loading...

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
    Runner up
    entry number 5
     Contest Entry #5 for Excel File to Build Proposals
     Contest Entry #5 for Excel File to Build Proposals
     Contest Entry #5 for Excel File to Build Proposals
     Contest Entry #5 for Excel File to Build Proposals
     Contest Entry #5 for Excel File to Build Proposals
    0 Likes
  2. Runner up
    Report
    entry number 6
     Contest Entry #6 for Excel File to Build Proposals
     Contest Entry #6 for Excel File to Build Proposals
     Contest Entry #6 for Excel File to Build Proposals
     Contest Entry #6 for Excel File to Build Proposals
     Contest Entry #6 for Excel File to Build Proposals
     Contest Entry #6 for Excel File to Build Proposals
     Contest Entry #6 for Excel File to Build Proposals
     Contest Entry #6 for Excel File to Build Proposals
     Contest Entry #6 for Excel File to Build Proposals
     Contest Entry #6 for Excel File to Build Proposals
     Contest Entry #6 for Excel File to Build Proposals
    0 Likes
  3. Runner up
    Report
    entry number 4
     Contest Entry #4 for Excel File to Build Proposals
     Contest Entry #4 for Excel File to Build Proposals
    0 Likes
  4. Runner up
    Report
    entry number 17
     Contest Entry #17 for Excel File to Build Proposals
    0 Likes
  5. Runner up
    Report
    entry number 12
     Contest Entry #12 for Excel File to Build Proposals
    0 Likes
  6. Runner up
    Report
    entry number 11
     Contest Entry #11 for Excel File to Build Proposals
    0 Likes
  7. Runner up
    Report
    entry number 7
     Contest Entry #7 for Excel File to Build Proposals
    0 Likes
  8. Runner up
    Report
    entry number 16
     Contest Entry #16 for Excel File to Build Proposals
    Rejected
    0 Likes
  9. Runner up
    Report
    entry number 15
     Contest Entry #15 for Excel File to Build Proposals
    Rejected
    0 Likes
  10. Runner up
    Report
    entry number 14
     Contest Entry #14 for Excel File to Build Proposals
    Rejected
    0 Likes
  11. Runner up
    Report
    entry number 3
     Contest Entry #3 for Excel File to Build Proposals
    Rejected
    0 Likes
  12. Runner up
    Report
    entry number 2
     Contest Entry #2 for Excel File to Build Proposals
    Rejected
    0 Likes
  13. Runner up
    Report
    entry number 1
     Contest Entry #1 for Excel File to Build Proposals
    Rejected
    0 Likes
  14. Runner up
    Report
    entry number 10
     Contest Entry #10 for Excel File to Build Proposals
    Withdrawn
  15. Runner up
    Report
    entry number 9
     Contest Entry #9 for Excel File to Build Proposals
    Withdrawn
  16. Runner up
    Report
    entry number 8
     Contest Entry #8 for Excel File to Build Proposals
    Withdrawn

Public Clarification Board