Excel wizard needed/good developer needed.

I need someone who is knows how to use excel very well. I have a sort of a template attached. Please pay attention to the Misc. sheet. Specifically the cells directly below House Misc. This is the format I need to use for all of the other sheets and headings within the sheets (Or something very similar). Below is what the excel workbooks needs to be able to do, I will use "House Misc" as an example:

Under Product info I need to be able to add as many products as I have and size of the product. This needs to be automated so i dont have to insert cells each time to do it.

Under Store price I need these stores to be editable. Not all stores are the same in all regions. I also need to be able to input the store price for each item. There are two more factors that go into the store adding which will be detailed in the "BP" section.

Under Paper Coupon type and internet coupon type, those are just simple input areas to be able to input the dollar amount and expiration. The titles stand for "On 1" means the coupon is good on 1 product, "On 2" means the coupon is good on 2 products.

Under Final Pricing: This section in probably the most complicated. "BP" stands for "Best Price" and "BPE" stands for "Best price ever". As discussed above there are two issues with this. Some companies will double coupons up to a buck. So if a coupon is $0.50 and under the coupon becomes double the face value. If it is over $0.50 but less than $1.00 it becomes $1.00. Some stores will not do this. So when inputting the store there will need to be a signifier to say if the store doubles or there will not be a correct way to calculate the best price. One other issue is that some companies wont accept internet coupons. We need to be able to identify these and remove the ones from the internet coupon calculation. You can decide the best way but it needs to be user friendly. So this is what I need. I need it to determine the best price on the product taking into acount the base price of the item, how many items you have to buy in order to get the coupon (So if it is in the "on 3" box then you will need to buy three items), if the store doubles coupons with the rules explained above, and if the store particpates in internet coupon deals. Then I want it to display the best price, store which they get it from, dan indicator for the coupon being used. The "BPE" would only change if the "BP" drops below the previous price.

The best approach to add a product would be to use some sort of a form with drop downs for categories, the types and amounts of coupons they have in the categories listed in the document, and expiration dates.

The best approach for adding a store would be to use some sort of a form with to signify if they accept internet coupons, and if they use the double coupon rule as explained above.

other rules. They need to be able to trend prices weekly. So Every week they will enter in new prices if there is a new price and new coupons be able to adjust the number of coupons they have for each item. Sometimes the user might want to remove and item as well.

The above steps need to be completed on all sheets and all categories which I have. Once that is completed I would like a results Sheet to populated with all products we have in all of the sheets with the associated "BP", "BPE", store, and type of coupon. I would like this to be sorted by store and sub sorted by category. This should also be easy to print so the format can be longer but not wider. Trends can be another results page just to inform the user of past "BP"'s.

Please let me know if you have any other questions. Thanks

If you feel this would be cheaper to program into a website please let me know. We can arrange to purchase a domain and hosting if needed.

Habilidades: Programação C, Excel, SQL, Visual Basic, Design de Sites

Veja mais: accessing web pages using excel vba, who needs a website developer, who is website developer, what will you do for a dollar, what do i need to do as a developer, we excel, website developer prices, website developer companies, Visual Basic Developer, the simple dollar, simple dollar, sheets add, purchase order template for excel, purchase order number example, purchase order form excel, order form format in excel, new trend website, need to buy a house, need it developer, me excel

Acerca do Empregador:
( 33 comentários ) Lebanon, United States

ID do Projeto: #464851

Concedido a:


Hello, how about i develop a php+mysql based web application for you? thanks!

$150 USD em 3 dias
(76 Comentários)

26 freelancers estão ofertando em média $144 para esse trabalho


Kindly view the PM for details. thanks.

$130 USD in 3 dias
(39 Comentários)

I am very experienced in Custom Excel Software creation, read my reviews. I can do this for you will a quality output. Thanks and Regards : TUHIN

$100 USD in 5 dias
(79 Comentários)

Excel developer since 1997. Can do. Regards, Svet.

$200 USD in 10 dias
(81 Comentários)

Hi, ready to work. Thanks, Al

$125 USD in 2 dias
(35 Comentários)

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram

$175 USD in 5 dias
(85 Comentários)

Nice job for me! Please, see PMB!

$100 USD in 3 dias
(62 Comentários)

I can help you.

$250 USD in 15 dias
(17 Comentários)

You may check PMB for a demo.

$120 USD in 5 dias
(34 Comentários)

I believe extending your Excel-based app will be the optimal approach. I will be pleased to apply my 12+ year experience in VBA/VBS/VB (Excel inclusive) to completing your assignment. Please see more details in PM.

$99 USD in 3 dias
(9 Comentários)

Exceptional quality & Fast work. Please refer to Profile & PMB for details. Thanks FAZ

$110 USD in 2 dias
(20 Comentários)

This can be done using Excel VBA. Please refer to PM

$150 USD in 6 dias
(16 Comentários)

Dear Shout Out! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

$185 USD in 3 dias
(16 Comentários)

Hi Please clarify how the paper coupon details be the same for the 7 stores as in the sample template? Would you consider moving the Paper Coupon and Internet Coupon out of the way, and create Paper Coupon (no do Mais

$150 USD in 7 dias
(7 Comentários)

Dear Mr./Ms., North America graduated and Microsoft certified professional. Please refer your PMB. Regards

$230 USD in 5 dias
(6 Comentários)

Hi See PMB for details Kris

$150 USD in 3 dias
(5 Comentários)

Hi, I can do this project. Please see detail in PM. Thank you, Panuwat

$150 USD in 4 dias
(2 Comentários)

Your project appears to be very interesting as well as appealing. I would suggest to have a separate tab for each Dept (House, Kitchen, Electronics, etc), so making new inputs would be very easy, and not require add Mais

$150 USD in 15 dias
(2 Comentários)

I'm an Odesk provider and I'm interested of this project...PM me... this project is fit to my experties...

$100 USD in 7 dias
(0 Comentários)

hi! Please view PMB. thanks

$30 USD in 2 dias
(0 Comentários)

Hi Sir , Please find my project proposal at your private message . thank you , Vijay

$50 USD in 2 dias
(0 Comentários)