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