{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Database","Tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Database","index":0,"n_rows":15,"n_cols":40,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["PinPros Quotes Database"]
[]
[]
[]
[]
[]
[]
[]
["Quote #","Client Name","Company / Organization","Quote Date","Requested Completion Date","Order Quantity","Pin Size","% Area Used","Pin Thickness","Metal Type","Mold Size","Accessories","Finishes","Wage Rate","Minutes Per Mold","Pieces Per Mold","Mold Runs","Fluff Minutes","Mold Labor Hours","Mold Labor Cost","Metal Unit Price","Pounds Per Square","Percent Area Used","Pounds Per Pin","Raw Materials Cost","AF Cost","AF Labor Hours","Mold Cost","Total Cost","Profit Margin","Base Price","Discount Percentage","Discount","Discounted Price","Total Labor Hours","Rush Charges","Final Price","Unit Price","Total Profit","Comments"]
[10004,"Austin Collie","Indiannapolis Colts","2010-11-24","2010-12-08",15000,1,0.75,0.09,"Pewter","12-inch","Key Chain, Velvet Box","Satin, Spray (brz, cpr, brs)",9,5,21,715,240,63.583332061767578,572.25,11.5,2.4250851944088936E-2,0.75,1.8188139046203523E-2,3137.4541015625,13491.4287109375,192.85714721679687,57.25,17258.3828125,0.56999999284744263,40135.7734375,5.000000074505806E-2,2006.7886962890625,38128.984375,256.44049072265625,1000,39128.984375,2.6085989583333333,20870.6015625,"For the Super Bowl goal - It's gotta be perfect. - He wants them now."]
[10005,"Tom Brady","New England Patriots","2010-11-24","2010-12-15",20000,1,0.95,0.09,"Pewter","9-inch","Key Chain, Velvet Box","Antique, Paint & Wipe",9,5,11,1819,240,155.58332824707031,1400.25,11.5,2.4250851944088936E-2,0.94999998807907104,2.3038309169431778E-2,5298.81103515625,16814.28515625,157.14285278320312,48.400001525878906,23561.74609375,0.56999999284744263,54794.7578125,5.9999998658895493E-2,3287.685302734375,51507.07421875,312.7261962890625,10000,61507.07421875,3.0753537109375002,27945.328125,"to beat the colts - This will be the best pin ever. - Don't be late."]
[10006,"Erika Zeigner","EFY","2010-11-24","2010-12-15",100,0.75,1,0.125,"Pewter","12-inch","Neck Ribbon (.875\" x 30\")","Color Fill",9,5,29,4,60,1.3333333730697632,12,11.5,2.0062068477272987E-2,1,2.0062068523691155E-2,23.071378707885742,19.056451797485352,0.89516127109527588,57.25,111.37783050537109,0.64999997615814209,318.22235107421875,0,0,318.22235107421875,2.2284946441650391,0,318.22235107421875,3.1822235107421877,206.84451293945312,"For counselors -  - "]
[10007,"James Fry","Young Men's","2010-11-25","2010-12-23",5000,1,0.8,0.06,"Zinc","12-inch","Key Chain, Velvet Box","Color Fill",9,5,21,239,120,21.916666030883789,197.25,1.7300000190734863,0,0.80000001192092896,1.1287669491419022E-2,97.638343811035156,4158.89404296875,46.543777465820313,57.25,4511.0322265625,0.56999999284744263,10490.7724609375,0,0,10490.7724609375,68.460441589355469,0,10490.7724609375,2.0981544921875002,5979.740234375," -  - "]
[10008,"Craig Johnson","Layton Marathon","2010-11-25","2011-07-07",1000,3,0.6,0.125,"Zinc","12-inch","Neck Ribbon (.875\" x 30\")","Color Fill, Antique",9,6,5,200,90,21.5,193.5,1.7300000190734863,0,0.60000002384185791,0.15238354191864284,263.62353515625,212.56451416015625,3.8333334922790527,57.25,726.93804931640625,0.56999999284744263,1690.5535888671875,0,0,1690.5535888671875,25.333333969116211,0,1690.5535888671875,1.6905535888671874,963.61553955078125," -  - "]
[10009,"Brian Rich","BYU Football","2010-11-29","2010-12-21",1000,0.75,0.85,0.125,"Pewter","9-inch","Key Chain","Satin, Antique",9,5,18,56,90,6.1666665077209473,55.5,11.5,2.0062068477272987E-2,0.85000002384185791,1.7052758723454468E-2,196.10671997070312,145.71427917480469,3.3333334922790527,48.400001525878906,445.72100830078125,0.62000000476837158,1172.9500732421875,0,0,1172.9500732421875,9.5,0,1172.9500732421875,1.1729500293731689,727.22906494140625,"for the bowl game -  - "]

{"sheet":"Tables","index":1,"n_rows":60,"n_cols":43,"rows_kept":60,"cut":false,"hidden":true,"merged":[[26,19,26,21],[30,19,30,21],[31,19,31,21],[32,19,32,21],[27,25,27,27],[26,25,26,27],[34,25,34,27],[33,19,33,21],[32,25,32,27],[33,25,33,27],[27,19,27,21],[28,19,28,21],[29,19,29,21],[28,25,28,27],[29,25,29,27],[30,25,30,27],[31,25,31,27]]}
["PRODUCT COST = LABOR + RAW MATERIAL + MOLD + ACCESSORIES/FINISH"]
[]
["LABOR CALCULATION = ((((Qty / # of patterns that will fit in a mold) X Minutes required to run one mold) + Fluff minutes) / 60 minutes) X wage rate)"]
["RAW MATERIAL CALCULATION = (((Grams X Conversion Factor) + Factor) / 454) X Pewter Cost per pound)*quantity?"]
["MOLD CALCULATION = SEE TABLE E"]
["ACCESSORIES/FINISH COST = QTY X ACCESSORY/FINISH UNIT COST"]
[]
["Pattern thickness","input"]
["Mold size","input"]
["Quantity","input"]
["# of patterns that will fit in a mold","see table A (based on mold size & product size)"]
["Minutes required to run one mold","see table B (based on product size)"]
["Fluff Minutes","see table C (based on quantity)"]
["60 minutes",60]
["wage rate",12]
["Pounds","see table D (based on pattern thickness & product size)"]
["Pewter Conversion factor",4.5410000000000004]
["Pewter Factor",1.069]
["Pewter Cost per pound",11.5]
["Zinc Coversion Factor",4.5410000000000004]
["Zinc Factor",1.069]
["Zinc Cost Per Pound",1.7300000190734863]
["Mold Cost","see table E (based on mold size)"]
["Accessories/Finish Unit Cost","see table F (based on input of which accessories are included) - there can be multiple of these in one order"]
[]
["TABLE A","number of pieces per mold",null,null,"TABLE B",null,null,"TABLE C",null,null,"TABLE D1 - Pewter Weights",null,null,null,null,null,"TABLE E",null,null,"TABLE F",null,null,null,null,null,"TABLE G",null,null,null,null,null,null,"TABLE H"]
[null,"9-inch","12-inch",null,"Size","minutes to run 1 mold",null,"Size","fluff minutes",null,"Size / Thickness",0.06,0.09,0.125,null,null,"mold size","mold cost",null,"Finishes",null,null,null,"#/Hr",null,"Accessories",null,null,null,"#/Hr",null,"(size code)","Size/Qty",10000,5000,3000,2000,1000,750,500,300,200,100]
[0.5,25,40,null,0.5,3,null,10000,240,null,0.5,4.4092458293826719E-3,5.9524818696666069E-3,8.5980293672962092E-3,null,null,"9-inch",35.4,null,"Satin",null,null,0.03,350,null,"Nail/Clutch",null,null,2.8000000000000001E-2,500,null,1,"0\" to 1\"",0.47,0.47,0.47,0.47,0.52,0.52,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004]
[0.75,18,29,null,0.75,3,null,5000,120,null,0.75,1.069242113625298E-2,1.5101666965635651E-2,2.0062068523691155E-2,null,null,"12-inch",41,null,"Color Fill",null,null,0.06,155,null,"Split Ring",null,null,3.2857142857142856E-2,700,null,2,"1.25\" to 2\"",0.45000000000000007,0.45000000000000007,0.45000000000000007,0.45000000000000007,0.52,0.52,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004]
[1,11,21,null,1,3,null,3000,120,null,1,1.6975596443123287E-2,2.4250852061604697E-2,3.1526107680086103E-2,null,null,null,null,null,"Antique",null,null,0.01,750,null,"Key Chain",null,null,7.0000000000000007E-2,500,null,3,"2.25\" to 3\"",0.4,0.4,0.4,0.4,0.47,0.47,0.5,0.5,0.5,0.5]
[1.25,9,15,null,1.25,3,null,2000,120,null,1.25,2.7227092996438003E-2,3.8801363298567509E-2,5.1147251620838996E-2,null,null,null,null,null,"Paint & Wipe",null,null,0.04,200,null,"Buckle Loop/Knob",null,null,0.09,200,null,4,"3.25\" to 4\"",0.4,0.4,0.4,0.4,0.47,0.47,0.5,0.5,0.5,0.5]
[1.5,8,13,null,1.5,3,null,1000,90,null,1.5,3.7478589549752715E-2,5.3351874535530329E-2,7.0768395561591882E-2,null,null,null,null,null,"Spray Paint & Wipe",null,null,0.05,250,null,"Neck Ribbon (.875\" x 30\")",null,null,0.05,400]
[1.75,7,11,null,1.75,3,null,750,90,null,1.75,5.1367713912308127E-2,7.3744636496425195E-2,9.8987568869640996E-2,null,null,null,null,null,"Spray (brz, cpr, brs)",null,null,0.09,100,null,"Poly Bag",null,null,2.75E-2,400]
[2,5,8,null,2,3,null,500,90,null,2,6.5256838274863546E-2,9.4137398457320054E-2,0.1272067421776901,null,null,null,null,null,null,null,null,null,null,null,"Velvet Box",null,null,0.28000000000000003,350]
[2.25,5,7,null,2.25,3.5,null,300,60,null,2.25,8.2122203572252264E-2,0.12103379801655434,0.16115793506393666,null,null,null,null,null,null,null,null,null,null,null,"Plastic Box",null,null,0.12,350]
[2.5,4,7,null,2.5,3.5,null,200,60,null,2.5,9.8987568869640982E-2,0.14793019757578862,0.1951091279501832]
[2.75,3,6,null,2.75,3.5,null,100,60,null,2.75,0.12334865207698026,0.18133023473336241,0.24625637957102223]
[3,0,5,null,3,4,null,null,null,null,3,0.14770973528431952,0.21473027189093616,0.29740363119186125]
[3.25,0,4,null,3.25,4,null,null,null,null,3.25,0.16788203495374523,0.25364186633523822,0.34061424031981141]
[3.5,0,3,null,3.5,4,null,null,null,null,3.5,0.18805433462317095,0.29255346077954025,0.38382484944776157]
[3.75,0,3,null,3.75,4,null,null,null,null,3.75,0.21285634241344847,0.33278782897265713,0.44169620095840911]
[4,0,3,null,4,4,null,null,null,null,4,0.237658350203726,0.37302219716577401,0.49956755246905671]
[]
[null,null,null,null,null,null,null,null,null,null,"TABLE D2 - Zinc Weights"]
[null,null,null,null,null,null,null,null,null,null,"Size / Thickness",0.06,0.09,0.125]
[null,null,null,null,null,null,null,null,null,null,0.5,3.3069343720370042E-3,4.4092458293826719E-3,6.6138687440740083E-3]
[null,null,null,null,null,null,null,null,null,null,0.75,8.7082605130307782E-3,1.2125426030802348E-2,1.7196058734592418E-2]
[null,null,null,null,null,null,null,null,null,null,1,1.4109586654024552E-2,1.9841606232222024E-2,2.7778248725110831E-2]
[null,null,null,null,null,null,null,null,null,null,1.25,2.3148540604259027E-2,3.1746569971555241E-2,4.4643614022499556E-2]
[null,null,null,null,null,null,null,null,null,null,1.5,3.2187494554493504E-2,4.3651533710888452E-2,6.1508979319888274E-2]
[null,null,null,null,null,null,null,null,null,null,1.75,4.4423151731030411E-2,6.0847592445480873E-2,8.5098444507085563E-2]
[null,null,null,null,null,null,null,null,null,null,2,5.6658808907567325E-2,7.8043651180073295E-2,0.10868790969428285]
[null,null,null,null,null,null,null,null,null,null,2.25,7.0658164415857302E-2,9.6011327934807683E-2,0.1370173141480665]
[null,null,null,null,null,null,null,null,null,null,2.5,8.4657519924147287E-2,0.11397900468954207,0.16534671860185018]
[null,null,null,null,null,null,null,null,null,null,2.75,0.1075855982369372,0.13922193706275784,0.20965963918714606]
[null,null,null,null,null,null,null,null,null,null,3,0.13051367654972709,0.16446486943597363,0.25397255977244193]
[null,null,null,null,null,null,null,null,null,null,3.25,0.15344175486251699,0.19268404274402276,0.29112045588499091]
[null,null,null,null,null,null,null,null,null,null,3.5,0.17636983317530686,0.22090321605207189,0.3282683519975399]
[null,null,null,null,null,null,null,null,null,null,3.75,0.18898491658765343,0.282191733080491,0.40091067703661942]
[null,null,null,null,null,null,null,null,null,null,4,0.2016,0.34348025010891015,0.473553002075699]