Käynnissä

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.

Taidot: C-ohjelmointi, Excel, SQL, Visual Basic, verkkosivujen suunnittelu

Näytä lisää: 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, internet developer, how to get the factors of a number, how to calculate prices on excel, how can i get the best developer website, get developer

About the Employer:
( 33 reviews ) Lebanon, United States

Projektin tunnus: #464851

Myönnetty käyttäjälle:

Arenabpo

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

150 $ USD 3 päivässä
(73 arvostelua)
6.9

27 freelanceria on tarjonnut keskimäärin 146 $ tähän työhön

JohnNuman

Kindly view the PM for details. thanks.

130 $ USD 3 päivässä
(30 arvostelua)
7.0
rajtuhin1

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 5 päivässä
(78 arvostelua)
6.8
schandraram

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

175 $ USD 5 päivässä
(112 arvostelua)
6.6
svet63

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

200 $ USD 10 päivässä
(70 arvostelua)
6.5
Wonderer

Hi, ready to work. Thanks, Al

125 $ USD 2 päivässä
(43 arvostelua)
5.7
nagybatonyi

Nice job for me! Please, see PMB!

100 $ USD 3 päivässä
(39 arvostelua)
5.6
Yurilad

I can help you.

250 $ USD 15 päivässä
(17 arvostelua)
5.0
oFAZo

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

110 $ USD 2 päivässä
(18 arvostelua)
4.8
pyazlm

You may check PMB for a demo.

120 $ USD 5 päivässä
(34 arvostelua)
4.5
gvyshnya

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 3 päivässä
(9 arvostelua)
4.3
johnsinit

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 3 päivässä
(16 arvostelua)
4.2
refractocd

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

150 $ USD 6 päivässä
(16 arvostelua)
4.1
code09

Hello . Please ses PMB for deails.

200 $ USD 7 päivässä
(11 arvostelua)
3.7
skujuira

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

230 $ USD 5 päivässä
(6 arvostelua)
3.7
cheungkc

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 Lisää

150 $ USD 7 päivässä
(7 arvostelua)
3.0
Abikris

Hi See PMB for details Kris

150 $ USD 3 päivässä
(5 arvostelua)
2.5
mjl78

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 Lisää

150 $ USD 15 päivässä
(2 arvostelua)
1.6
avudai

Dear Sir, I can provide a quality deliverable to you with what you have requested. I can also provide you additional, user friendly features which you have not mentioned. Plz check your PM for details. Note: The Lisää

199 $ USD 10 päivässä
(0 arvostelua)
0.0
SuccessSolutions

Pl ref PM.

100 $ USD 2 päivässä
(0 arvostelua)
0.0
vijayvolv

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

50 $ USD 2 päivässä
(0 arvostelua)
0.0