VapeKit; The easy to use spreadsheet for all vaping needs.
Featuring the world's most advanced Juice Mixing Calculator and Coil Building Calculators and the world's most advanced and only customizable Volts/Watts/Ohms/Amps Calculators.
Also features a Juice/ml Calculator, Battery Amp Limit Calculator, VapeTrack, (a since quit smoking tracker), Expense/Order Tracker and more.
-Sheet 1, Page 1-
The main worksheet with most of the needed info on it.
*2 Coil Build Calculators that calculate:
Length of wire in inches and mm
Amount of coil wraps
Ohms per inch, ft, mm and m
Watts and Amps
Area of a cross-section of wire
Round or ribbon wire, any gauge, any material, any coil wrap size, any Ohms.
As long as the material, diameter (or height and width), and Ω mm²/m are known, this can calculate it.
Single coil builds, but Ohms can be divided accordingly for multi-coil builds.
*Round wire diameter chart in inch and mm, 36 to 22 gauge.
*Ribbon wire height/width chart in mm and approximate gauge compared to round wire, 0.01mm height x 0.3mm to 1.3mm width.
*Coil diameter chart in inch and mm, needle gauge 34 to 7 with 1/64" to 17/64" integrated.
*7 Conversion Calculators
inch to mm
mm to inch
in² to mm²
ft² to mm²
m² to mm²
fl oz to ml
dram to ml
*Amp Limit calculator
*Juice/ml Calculator which can include extras and shipping costs
*Juice/Bottle Mixer
Calculates PG, VG, Other, Nic mg, ml, Drops, Total Cost, Cost/ml
Mixes up to 12 different ingredients or bottles.
Color coded Totals which turn Green when they match Targets and turn Red when they do not match Targets.
*VapeTrack
Calculates days, months, years since last cigarette, number of cigarettes not smoked, money saved from not smoking, vaping costs, difference between vaping costs and cost of smoking during same time period, cost of cigarettes per week and cost of vaping per week.
*PG/VG image with explanations
------------------------------------------------------------------------
-Sheet 1, Page 2-
A sheet for visualizing and customizing many/any Volts and Watts ranges and Ohms combinations.
Basically, it's two Ohm's/Joule's Law calculators in chart form.
*Customizable Volts/Ohms calculator/chart which calculates Watts and Amps.
*Customizable Watts/Ohms calculator/chart which calculates Volts and Amps.
*Instructions/info for the various calculators
------------------------------------------------------------------------
-Sheet 1, Page 3-
A sheet with battery info.
*Battery comparison chart with links to manufacturers or stores and links to reviews/tests, if any.
*Ohms Wheel image showing the 12 Ohm's/Joule's Law calculations
*Volt/Amp/Ohm image showing the relationship between them
------------------------------------------------------------------------
-Sheet 2, Page 1 through Page 6-
A sheet to keep track of vaping expenses.
*Expense Totals: Juice, Hardware, Shipping and Total
*Hardware to Get / Juice to Try section
*Juice Favorites section
*Coupons section
*Juice breakdown: Vendor, Name, Price, ml, PG/VG, Nic, Manufacturer Date, Age Time, Age Start Time, Age Stop Time, First Time Vaped, Crack, Order number and Comments
*Hardware breakdown: Vendor, Item, Price, Order number and Comments.
*Order breakdown: Vendor, Subtotal, Shipping, Total, Order Date, Received Date, Tracking Number, Order Number and Comments
------------------------------------------------------------------------
-Sheet 3, Page 1 through 3-
A sheet to keep track of recipes
*Recipe section
------------------------------------------------------------------------
VapeKit 02.14 ~350kb .xls format (excel/kingston/openoffice spreadsheet) https://docs.google.com/file/d/0Bx6isH5im7XocjR5dW1MbGYzaG8/edit
As a complementary addition to VapeKit, I also created a Juice Pricing Comparison list/layout.
One sheet is for ready made juice pricing and info and one sheet is for DIY juice pricing and info.
The ready made sheet includes Vendor Name, all/most bottle sizes and pricing, cost/ml, shipping cost, free shipping point (if any) and vendor city, state, zip code.
The DIY sheet includes the above plus flavoring, PG, VG, Nicotine Base bottle sizes and pricing, cost/ml.
Each sheet has a price comparison list that shows Vendor Name, Low Cost/ml and High Cost/ml, which can be sorted by either.
------------------------------------------------------------------------
VapeKit Juice Pricing ~350kb .xls format (excel/kingston/openoffice spreadsheet) https://docs.google.com/file/d/0Bx6isH5im7XoR1dFX3ZuMURfM1E/edit
Featuring the world's most advanced Juice Mixing Calculator and Coil Building Calculators and the world's most advanced and only customizable Volts/Watts/Ohms/Amps Calculators.
Also features a Juice/ml Calculator, Battery Amp Limit Calculator, VapeTrack, (a since quit smoking tracker), Expense/Order Tracker and more.
-Sheet 1, Page 1-
The main worksheet with most of the needed info on it.
*2 Coil Build Calculators that calculate:
Length of wire in inches and mm
Amount of coil wraps
Ohms per inch, ft, mm and m
Watts and Amps
Area of a cross-section of wire
Round or ribbon wire, any gauge, any material, any coil wrap size, any Ohms.
As long as the material, diameter (or height and width), and Ω mm²/m are known, this can calculate it.
Single coil builds, but Ohms can be divided accordingly for multi-coil builds.
*Round wire diameter chart in inch and mm, 36 to 22 gauge.
*Ribbon wire height/width chart in mm and approximate gauge compared to round wire, 0.01mm height x 0.3mm to 1.3mm width.
*Coil diameter chart in inch and mm, needle gauge 34 to 7 with 1/64" to 17/64" integrated.
*7 Conversion Calculators
inch to mm
mm to inch
in² to mm²
ft² to mm²
m² to mm²
fl oz to ml
dram to ml
*Amp Limit calculator
*Juice/ml Calculator which can include extras and shipping costs
*Juice/Bottle Mixer
Calculates PG, VG, Other, Nic mg, ml, Drops, Total Cost, Cost/ml
Mixes up to 12 different ingredients or bottles.
Color coded Totals which turn Green when they match Targets and turn Red when they do not match Targets.
*VapeTrack
Calculates days, months, years since last cigarette, number of cigarettes not smoked, money saved from not smoking, vaping costs, difference between vaping costs and cost of smoking during same time period, cost of cigarettes per week and cost of vaping per week.
*PG/VG image with explanations
------------------------------------------------------------------------
-Sheet 1, Page 2-
A sheet for visualizing and customizing many/any Volts and Watts ranges and Ohms combinations.
Basically, it's two Ohm's/Joule's Law calculators in chart form.
*Customizable Volts/Ohms calculator/chart which calculates Watts and Amps.
*Customizable Watts/Ohms calculator/chart which calculates Volts and Amps.
*Instructions/info for the various calculators
------------------------------------------------------------------------
-Sheet 1, Page 3-
A sheet with battery info.
*Battery comparison chart with links to manufacturers or stores and links to reviews/tests, if any.
*Ohms Wheel image showing the 12 Ohm's/Joule's Law calculations
*Volt/Amp/Ohm image showing the relationship between them
------------------------------------------------------------------------
-Sheet 2, Page 1 through Page 6-
A sheet to keep track of vaping expenses.
*Expense Totals: Juice, Hardware, Shipping and Total
*Hardware to Get / Juice to Try section
*Juice Favorites section
*Coupons section
*Juice breakdown: Vendor, Name, Price, ml, PG/VG, Nic, Manufacturer Date, Age Time, Age Start Time, Age Stop Time, First Time Vaped, Crack, Order number and Comments
*Hardware breakdown: Vendor, Item, Price, Order number and Comments.
*Order breakdown: Vendor, Subtotal, Shipping, Total, Order Date, Received Date, Tracking Number, Order Number and Comments
------------------------------------------------------------------------
-Sheet 3, Page 1 through 3-
A sheet to keep track of recipes
*Recipe section
------------------------------------------------------------------------
VapeKit 02.14 ~350kb .xls format (excel/kingston/openoffice spreadsheet) https://docs.google.com/file/d/0Bx6isH5im7XocjR5dW1MbGYzaG8/edit
As a complementary addition to VapeKit, I also created a Juice Pricing Comparison list/layout.
One sheet is for ready made juice pricing and info and one sheet is for DIY juice pricing and info.
The ready made sheet includes Vendor Name, all/most bottle sizes and pricing, cost/ml, shipping cost, free shipping point (if any) and vendor city, state, zip code.
The DIY sheet includes the above plus flavoring, PG, VG, Nicotine Base bottle sizes and pricing, cost/ml.
Each sheet has a price comparison list that shows Vendor Name, Low Cost/ml and High Cost/ml, which can be sorted by either.
------------------------------------------------------------------------
VapeKit Juice Pricing ~350kb .xls format (excel/kingston/openoffice spreadsheet) https://docs.google.com/file/d/0Bx6isH5im7XoR1dFX3ZuMURfM1E/edit
Attachments
Last edited:
Nice work 
