Excel programme with various input fields to generate a single output
- or -
Post a project like this£1.0k(approx. $1.2k)
- Posted:
- Proposals: 9
- Remote
- #87166
- Expired
Excel Expert, Excel Spreadsheets, Excel VBA & Access Database Developer, Data modelling & Analysis
London
1227587829032710665611807619539720141484610136580
Description
Experience Level: Expert
we currently deal with around 30 - 40 manufacturers who supply us various equipment , they supply there price lists usually in excel format and all suppliers supply in various formats for eg
some will display trade only pricing and tell us the discount across the whole list
some will display our own buy prices which we then need to add a sale margin to
some have complicated fields within there price lists which are sometimes not used
some have various discounts for diffent tpes of products
and some more scenarios as u can imagine.
---------------------------------------------------------------
these price lists are converted into a standard excel price list with various fields which allow us to upload into our invocing system and be able to use.
we need ths system to be able to create the output file which is required for our invoicing system so fields such as discounts manufacturers names part codes descriptions and some other specifically related to the invoicing system.
the price lists also need to be updated regularly as sometimes items are disconitnued and some items are added and price changes and so on
we need something to handle this and to make it easy
the programme should be able to
select manufacturer
check old price list to new price list and adjust for
new pricing
discontinued items
add new lines
add preferred margins of sales and a few other calculations
any other information let us know
system needs to be easy to use and have a nice front end
----------------------------------------------------------------
revision to above
1- we do not care what programme is uses towork with but we do insiat on excel as the output file
2 - we will need to be able to also create our owne price lists within the programme
3 - we will need to be able to search the variouse excel supplied lists for certain fields as the excel files can have a lot of useless information in them this could happen by searching various columns and so on but once the list has been converted in the new system it should be easy to maintain when manufacturer issues new price lists
4 - we will also need the programme to be able to use to search any part code we feed into it to check for
new costy price
old cost price
disconinued item
5 - As the final excel file which is produced will be posted into our invocing system/ web site sometimes the part code that the manufacturer has is to long so we sometimes need to create our own part code for a bunch of items and merge the manufacturers part code to be merged with the description so we dont loose the information.
6 - it would be nice that 2-3 users can access the system maybe a web based system?? OR SOMETHING THAT CAN RECIDE ON OUR SBS SERVER 2011 AND BE SHARED
7 - WHAT ABOTU SUPPLEIRS THAT SEND PRICE LISTS IN PDF CAN ANYTHING BE DONE ABOUT THIS OR IS IT A CASE OF TYPING THEM OUT IBNTO A SPREADSHEET FIRST?
8 - SOME MANUFACTURERS SUPPLY EXCEL PRICE LISTS WHICH HAVE IAMGES BUT THESE ARE NOT REALLY REQUIRES AS WE WOULD HAVE ALREADY GO THESE IN ANOTHER WAY.
9- WE WOULD LIKE THE ABILITY TO MERGE FIELDS AT WILL AND SEPERATE BY A COMMA
10 - SOME EXCEL PRICE LISTS HAVE USELESS IFNROMATION IN THERE SUCH AS CATEGORY NAMES CATEGORY TITLES And other information that is not required can this be handled
see attchements
fike common issue is a file which is the final output file which we use to post into our website and into our invoicing system via an upoad section
see genie price list which is supplied form manufacturer
see aritech price list which is supplied as is without the applicable discount they gice us
some will display trade only pricing and tell us the discount across the whole list
some will display our own buy prices which we then need to add a sale margin to
some have complicated fields within there price lists which are sometimes not used
some have various discounts for diffent tpes of products
and some more scenarios as u can imagine.
---------------------------------------------------------------
these price lists are converted into a standard excel price list with various fields which allow us to upload into our invocing system and be able to use.
we need ths system to be able to create the output file which is required for our invoicing system so fields such as discounts manufacturers names part codes descriptions and some other specifically related to the invoicing system.
the price lists also need to be updated regularly as sometimes items are disconitnued and some items are added and price changes and so on
we need something to handle this and to make it easy
the programme should be able to
select manufacturer
check old price list to new price list and adjust for
new pricing
discontinued items
add new lines
add preferred margins of sales and a few other calculations
any other information let us know
system needs to be easy to use and have a nice front end
----------------------------------------------------------------
revision to above
1- we do not care what programme is uses towork with but we do insiat on excel as the output file
2 - we will need to be able to also create our owne price lists within the programme
3 - we will need to be able to search the variouse excel supplied lists for certain fields as the excel files can have a lot of useless information in them this could happen by searching various columns and so on but once the list has been converted in the new system it should be easy to maintain when manufacturer issues new price lists
4 - we will also need the programme to be able to use to search any part code we feed into it to check for
new costy price
old cost price
disconinued item
5 - As the final excel file which is produced will be posted into our invocing system/ web site sometimes the part code that the manufacturer has is to long so we sometimes need to create our own part code for a bunch of items and merge the manufacturers part code to be merged with the description so we dont loose the information.
6 - it would be nice that 2-3 users can access the system maybe a web based system?? OR SOMETHING THAT CAN RECIDE ON OUR SBS SERVER 2011 AND BE SHARED
7 - WHAT ABOTU SUPPLEIRS THAT SEND PRICE LISTS IN PDF CAN ANYTHING BE DONE ABOUT THIS OR IS IT A CASE OF TYPING THEM OUT IBNTO A SPREADSHEET FIRST?
8 - SOME MANUFACTURERS SUPPLY EXCEL PRICE LISTS WHICH HAVE IAMGES BUT THESE ARE NOT REALLY REQUIRES AS WE WOULD HAVE ALREADY GO THESE IN ANOTHER WAY.
9- WE WOULD LIKE THE ABILITY TO MERGE FIELDS AT WILL AND SEPERATE BY A COMMA
10 - SOME EXCEL PRICE LISTS HAVE USELESS IFNROMATION IN THERE SUCH AS CATEGORY NAMES CATEGORY TITLES And other information that is not required can this be handled
see attchements
fike common issue is a file which is the final output file which we use to post into our website and into our invoicing system via an upoad section
see genie price list which is supplied form manufacturer
see aritech price list which is supplied as is without the applicable discount they gice us
Raj S.
100% (4)Projects Completed
13
Freelancers worked with
11
Projects awarded
17%
Last project
12 Mar 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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