I gang

Setting up an Excel calculation tool

We are a standconstruction company. We are looking for a person who can develop a excel (or similar calculation) tool for us. This person must be perfect working with Excel and must speak very good english.

We will communicate each day via skype or similar to make sure the project can be completed within 7-10 days. max.

We will provide all inputs and data.

You must setup the information and prepare a calculation tool.

Main Idea:

page1 : General information from the client and the tradeshow. In addition we have an status of the project (milestone)

*** all following pages will pick up informations from page 1 and will add informations to page 1 as well.

page2: Here we have listed around 1000 rental or custommade elements that comes wirh a standconstruction. We will chosse only the amount of items we need for a construction. Add the end wechoose all elements we have marked and we get an detailed list of items. We must be able to choose the language (german or englisch for the items) and we must choose the currency we want to offer. We will provide the items and translation. This page containes the weight of each product, powerconsumption and it shows the warehoures where the product is stored.

page3: this is based on page 2, but we will only show the relevant informations that a client needs to see. This page includes our company logo and must look similar to our corporate letters, etc.

page4: delivery note, this page is based on page 2 and will show our subcontractors what items he must deliver and where the items are located(warehouse). add notes for handling or similar must be added.

We need to add a budget for our subcontractors too. This budget is a percentage of the total rental/standconstruction cost.

Requirements Excel Database

Sheet 1: Details: Client data, show dates, general information

Sheet 2: Articles: List of articles, description in English and German, purchase and sales prices, stock, various terms and discounts

Sheet 3: MaterialClient: Summary of articles off the article list, either in English or German, incl. sales prices, terms and discount

Sheet 4: MaterialConstructor: Summary of articles as in MaterialClient without prizes and terms, German

Linking to Word:

Sheet 5: Delivery note on the basis of MaterialClient

Sheet 6: Offer on the basis of MaterialClient

Sheet 7: Order Confirmation on the basis of MaterialClient

Sheet 8: Invoice on the basis of MaterialClient

Færdigheder: Databehandling, Excel, Format & Layout, Microsoft Access

Se mere: we excel, translation stock, total company logo, summary of an article, purchase summary, purchase company logo, prices for english translation, prepare logo for company, prepare company logo, prepare a company logo, perfect english to german translation, offer up, need a corporate sales person, look off translation, logo tool, logo for construction company with letters, following up, construction corporate logo, company logo stock, article tool, excel calculation tool, what is word processing, have a good day in german, letters translation, where is invoice?

Om arbejdsgiveren:
( 2 bedømmelser ) Hong Kong, Germany

Projekt-ID: #964505