Akopia Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

[mv] Pricing Structure Advice



******    message to minivend-users from Victor Nolton <ven@pragakhan.com>     ******

Client uses a spreadsheet which has 6 columns for their pricing structure
p1 q1 p2 q2 p3 q3
p=price
q=quantity

p1=100
q1=25
meaning 25 of the items costs $100 (aka $4.00 each).

here is a snip of their current pricing database which is different 
from their spreadsheet (but I'd like to make it exactly alike to the 
above and not use the below).

code	q1	q2	q3	q5	q10	q15	q20	q25 
	q50	q100	q300	q500	q600	q1000000000
01-0115								0.6 
	0.56	0.5	0.5	0.5	0.5	0.5
01-0205					1	1	1	1 
	0.9	0.9	0.9	0.9	0.9	0.9
01-0214				5	5	5	5	3 
	3	3	3	3	3	3
01-0223								0.64 
	0.56	0.5	0.5	0.5	0.5	0.5
01-0232								0.6 
	0.56	0.5	0.5	0.5	0.5	0.5
01-0241								0.68 
	0.58	0.53	0.53	0.53	0.53	0.53


Is there a simpler way to do this so it just reads the info p1 q1...p3 q3?

Suggestions would be appreciated.

http://www.vensnews.com

Victor "Ven" Nolton __________________________ http://www.VensNews.com
http://PragaKhan.com  http://LordsofAcid.com  http://DarlingNikkie.com

         All HTML Encoded email will be ignored. Learn Standards.
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list


Search for: Match: Format: Sort by: