Screen Printing Price Lookup template
Demonstration of how to look up a value in a pricing table. Use this template when you use a price table to determine your costs per color based on the quantity.
4.8 out of 5 stars
4.8 / 5
"Any website needs a calculator!"
QTY
is the reference for the question (slider) where you set the quantity.DA
is the reference for the cleaned pricing table.SCREENS_1
is the reference for the question (slider) where you set the number of colors in your design.- with the
1, 1
you determine whether you need an exact match and whether you want to look for the higher or lower bound. This is important because the pricing table provides prices for Quantity ranges (until 24, 48, and 72 instead of defining each quantity explicitly).
Note 1: When the number of screens is set to 2 (SCREENS_1
), the function will fetch the value from the third column (which is the correct column) of the table, since the table column count starts at 0.
Note 2: you need to clean up your data for the VLOOKUP to work correctly. In this case, you will need to omit the Header from the table.
Data
An important question to ask is "Where can I put my pricing table?". For this you have several options:
- Datasheet: an internal datasheet that is only available in the calculator.
- ConvertCalculator Table: a table is available over calculators. You can create and edit your table from your main dashboard.
- GoogleSheet: you can also use a GoogleSheet as your data source. To use a GoogleSheet, you can either load it directly into your calculator with the GOOGLESHEET function, or you can set the ConvertCalculator table source to a GoogleSheet.
- Airtable: You can also set the ConvertCalculator table source to Airtable, allowing you to use your Aitable base, including images, as a data source.
Is this screen printing price lookup template not what you are looking for?
Photography quote template
Wedding Photography
Registration form
Food Order Form
Qarry Vehicle Configurator
Photography Order Form
Cake Order Form Template
Catering Order Form
Simplify Online Sales for Coffee Companies!
Solar lead generation funnel
Screen Printing Price Lookup
Laser Pricing Calculator
Cleaning Calculator
Typeform Lead Form
Solar Power Calculator
PDF Quote
Quote calculator for leads
Screen Printing Lead Generation Form
Legendary Screen Printing Cost Quote Companion
Screen-printing quote generator
Printing cost calculator
Pricing page 2
FAIR salary calculator
Screen printing price quote calculator
Visual Handbag Configurator
Amazon Growth Calculator
Business Loan Calculator
Home Affordability Calculator
T-shirt pricing calculator
Pricing page example
T-shirt earnings
T-shirt Cost
Solar Lead Generation Calculator
Amazon ROI calculator
eBook download form
Courier Price Quote Calculator
Hourly Rate Calculator
Custom Cake Order Form
Building cost calculator
Remodeling Project Price Calculator
Car Rental Form
House Painting Price Quote Calculator
Music Artist Booking Form
Farmers Market Online Order System
Cocktail Delivery Form
Bakery Online Order System
Follow Up Call Appointment
Carpet Cleaning Estimate Template
Car Loan Calculator
Chair visual product configurator
Event Planner Price Quote Calculator
Wedding Photography Quote Calculator template
Sunglasses Product Configurator
Solar Calculator
Videography price quote