[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