gistfile1.js

var data = [
    [Meteor.user().profile['company-name'], "15 ML Bottles", "", "", "", "", "", "", "Dripper Fuel", "", "", "", "30 ML Bottles", "", "", "", "", "", ""],
    [moment().format('MM-DD-YYYY'), '0 MG', '3 MG', '6 MG', '12 MG', '18 MG', '24 MG', 'Total', '0 DF', '3 DF', '6 DF', 'Total', '0 MG', '3 MG', '6 MG', '12 MG', '18 MG', '24 MG', 'Total'],
    ['Beehave', '','','','','','','=SUM(B3:G3)','NA','NA','NA','NA', '', '','','','','','=SUM(M3:R3)'],
    ['Blueberry Thrill', '','','','','','','=SUM(B4:G4)','NA','NA','NA','NA', '','','','','','','=SUM(M4:R4)'],
    ['Caramel Vapeuccino', '','','','','','','=SUM(B5:G5)','NA','NA','NA','NA', '','','','','','','=SUM(M5:R5)'],
    ['Carousel', '','','','','','','=SUM(B6:G6)','','','','=SUM(I6:K6)', '','','','','','','=SUM(M6:R6)'],
    ['Cherry Bomb', '','','','','','','=SUM(B7:G7)','NA','NA','NA','NA', '','','','','','','=SUM(M7:R7)'],
    ['Chill Out', '','','','','','','=SUM(B8:G8)','NA','NA','NA','NA', '','','','','','','=SUM(M8:R8)'],
    ['Coolcumber', '','','','','','','=SUM(B9:G9)','NA','NA','NA','NA', '','','','','','','=SUM(M9:R9)'],
    ['Grapevape', '','','','','','','=SUM(B10:G10)','NA','NA','NA','NA', '','','','','','','=SUM(M10:R10)'],
    ['Heisenberg (The Blue)', '','','','','','','=SUM(B11:G11)','','','','=SUM(I11:K11)', '','','','','','','=SUM(M11:R11)'],
    ['Heisenberg Menthol', '','','','','','','=SUM(B12:G12)','NA','NA','NA','NA', '','','','','','','=SUM(M12:R12)'],
    ['Miami Nice', '','','','','','','=SUM(B13:G13)','NA','NA','NA','NA', '','','','','','','=SUM(M13:R13)'],
    ['Mocha Javape', '','','','','','','=SUM(B14:G14)','NA','NA','NA','NA', '','','','','','','=SUM(M14:R14)'],
    ['Pearnapple', '','','','','','','=SUM(B15:G15)','','','','=SUM(I15:K15)', '','','','','','','=SUM(M15:R15)'],
    ['Scarlett Kiss', '','','','','','','=SUM(B16:G16)','','','','=SUM(I16:K16)', '','','','','','','=SUM(M16:R16)'],
    ['Se7en', '','','','','','','=SUM(B17:G17)','NA','NA','NA','NA', '','','','','','','=SUM(M17:R17)'],
    ['Soleéy', '','','','','','','=SUM(B18:G18)','NA','NA','NA','NA', '','','','','','','=SUM(M18:R18)'],
    ['Succer Punch', '','','','','','','=SUM(B19:G19)','','','','=SUM(I19:K19)', '','','','','','','=SUM(M19:R19)'],
    ['TNT Gold', '','','','','','','=SUM(B20:G20)','NA','NA','NA','NA', '','','','','','','=SUM(M20:R20)'],
    ['TNT Menthol', '','','','','','','=SUM(B21:G21)','NA','NA','NA','NA', '','','','','','','=SUM(M21:R21)'],
    ['TNT Red', '','','','','','','=SUM(B22:G22)','NA','NA','NA','NA', '','','','','','','=SUM(M22:R22)'],
    ['Vaperception', '','','','','','','=SUM(B23:G23)','NA','NA','NA','NA','', '','','','','','=SUM(M23:R23)'],
    ['Vapetrix', '','','','','','','=SUM(B24:G24)','','','','=SUM(I24:K24)', '','','','','','','=SUM(M24:R24)'],
    ['VMD (Vape My Day)', '','','','','','','=SUM(B25:G25)','','','','=SUM(I25:K25)', '','','','','','','=SUM(M25:R25)'],
    ['Watermelenthol', '','','','','','','=SUM(B26:G26)','NA','NA','NA','NA','', '','','','','','=SUM(M26:R26)'],
    ['Watermelony', '','','','','','','=SUM(B27:G27)','NA','NA','NA','NA','', '','','','','','=SUM(M27:R27)'],
    ['Oak Age Blend - 15 & 30 ml Bottles'],
    ['Elegante', '','','','','','=SUM(B29:F29)','NA','NA','NA','NA','NA', '','','','','','=SUM(M29:Q29)', 'NA'],
    ['General Custard', '','','','','','=SUM(B30:F30)','NA','NA','NA','NA','NA', '','','','','','=SUM(M30:Q30)', 'NA'],
    ['Shanghai', '','','','','','=SUM(B31:F31)','NA','NA','NA','NA','NA', '','','','','','=SUM(M31:Q31)', 'NA'],
    ['Triple Crown', '','','','','','=SUM(B32:F32)','NA','NA','NA','NA','NA', '','','','','','=SUM(M32:Q32)', 'NA'],
    ['VMD - Private Stock', '','','','','','=SUM(B33:F33)','NA','NA','NA','NA','NA', '','','','','','=SUM(M33:Q33)', 'NA'],
    ['Total Bottles', 'NA','NA','NA','NA','NA','=SUM(G29:G33)','=SUM(H3:H27)', 'NA','NA','NA', '=SUM(L3:L27)', 'NA','NA','NA','NA','NA','=SUM(R29:R33)','=SUM(S3:S27)'],
    ['=SUM(B34:S34)', '', '', '=IF(SUM(B34:S34) > 49, "Minimum Bottle Requirement Reached", "NOT ENOUGH BOTTLES TO PLACE ORDER - Minimum Bottles: 50")'],
    ['Totals (Not a final invoice, does not include shipping)', '', '','','', '', '', 'Price Tiers:', '15ML', '30ML'],
    ['15ML Premium Liquids', '=IF(SUM(G34,H34,L34,R34,S34)>4999, H34 * 4.5, IF(SUM(G34,H34,L34,R34,S34) > 2499, H34 * 4.75, IF(SUM(G34,H34,L34,R34,S34) > 999, H34 * 4.85, IF(SUM(G34,H34,L34,R34,S34) > 249, H34 * 5.00, IF(SUM(G34,H34,L34,R34,S34) > 49, H34 * 5.25, 0)))))','', 'Current Tier','','=IF(SUM(G34,H34,L34,R34,S34)>4999, "5000+", IF(SUM(G34,H34,L34,R34,S34) > 2499, "2500-4999", IF(SUM(G34,H34,L34,R34,S34) > 999, "1000-2499", IF(SUM(G34,H34,L34,R34,S34) > 249, "250-999", IF(SUM(G34,H34,L34,R34,S34) > 49, "50-249", "NA")))))',  '', '50-249', '$5.25', '$7.85'],
    ['30ML Premium Liquids', '=IF(SUM(G34,H34,L34,R34,S34)>4999, S34 * 4.5, IF(SUM(G34,H34,L34,R34,S34) > 2499, S34 * 4.75, IF(SUM(G34,H34,L34,R34,S34) > 999, S34 * 4.85, IF(SUM(G34,H34,L34,R34,S34) > 249, S34 * 5.00, IF(SUM(G34,H34,L34,R34,S34) > 49, S34 * 5.25, 0)))))', '', 'Bottles For Next Tier','','=IF(SUM(G34,H34,L34,R34,S34)>4999, "NA", IF(SUM(G34,H34,L34,R34,S34) > 2499, 5000 - SUM(G34,H34,L34,R34,S34), IF(SUM(G34,H34,L34,R34,S34) > 999, 2500 - SUM(G34,H34,L34,R34,S34), IF(SUM(G34,H34,L34,R34,S34) > 249, 1000 - SUM(G34,H34,L34,R34,S34), IF(SUM(G34,H34,L34,R34,S34) > 49, 250 - SUM(G34,H34,L34,R34,S34), 50 - SUM(G34,H34,L34,R34,S34))))))', '', '250-999', '$5.00', '$7.50'],
    ['Dripper Fuel', '=L34 * 8.50', '', '', '', '','', '1000-2499', '$4.85', '$7.35'],
    ['15ML Oak Aged', '=G34 * 7.00', '', '', '', '','', '2500-4999', '$4.75', '$7.20'],
    ['30ML Oak Aged', '=R34 * 10.00', '', '', '', '','', '5000+', '$4.50', '$7.05'],
    ['TOTAL PRICE', '=SUM(B37:B41)']

  ];