Looking for someone who can help build an excel spread sheet
- or -
Post a project like this£20(approx. $25)
- Posted:
- Proposals: 24
- Remote
- #2010550
- Expired
| Oracle Developer | Java Developer | Wordpress Developer | C-sharp | ASP.NET MVC
Hyderabad
Animation artist/ Graphic Designer/ Game Developer/ Web developer/ App Developer/ Sketch Artist
Islamabad
Excel Specialist, Data Analyst, Report Writer with Spencerian in complex SQL writing
Southend-on-Sea
211919422620532251658224159522371882229651222557622140662202732219665221885742153879
Description
Experience Level: Entry
I am looking for someone who can help create a spread sheet to help with rating customers files.
I am looking for a spread sheet to be created in Excel that has a master file tab with a click down function to select a customer. Once a customer is selected, their quoted rates appear so we can complete rating of a file. We have a system with our in house operation to arrange the invoicing so this is for costing purposes only.
So if a customer has a shipment of 1500kg - the spread sheet will find the correct rate and the spread sheet will work everything out. If the order was 5000kg it would work out the correct freight rate.
I have a lot of customer rates and some can be very different. Some charged in GBP, USD and Euro's - this needs to be considered as well.
If you need more information, I am happy to discuss this but please, I am looking for someone who can handle this. I understand to an excel novice like myself, this will be difficult to complete. Someone who is trained in excel will find this very easy to complete.
I am looking for a spread sheet to be created in Excel that has a master file tab with a click down function to select a customer. Once a customer is selected, their quoted rates appear so we can complete rating of a file. We have a system with our in house operation to arrange the invoicing so this is for costing purposes only.
So if a customer has a shipment of 1500kg - the spread sheet will find the correct rate and the spread sheet will work everything out. If the order was 5000kg it would work out the correct freight rate.
I have a lot of customer rates and some can be very different. Some charged in GBP, USD and Euro's - this needs to be considered as well.
If you need more information, I am happy to discuss this but please, I am looking for someone who can handle this. I understand to an excel novice like myself, this will be difficult to complete. Someone who is trained in excel will find this very easy to complete.
Trevor C.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
11%
Last project
21 Dec 2015
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Trevor,
Do you mean conditional formatting --- like if a customer has a shipment of 1500kg - the spreadsheet will find the correct rate with some color may be (green) and If the order was 5000kg it would work out the correct freight rate with some red color, to a better understanding?
642476
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies