{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Tax Analysis","Purchase Order ","PO July "],"not_rendered":{"defined_names":18,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Tax Analysis","index":0,"n_rows":24,"n_cols":6,"rows_kept":24}
["Tax Rate",{"v":0.04,"d":"4%"}]
["Order Total",{"$f":"SUM(Cost)","v":{"v":5071.04,"d":"$5,071.04"}}]
["Inventory ID","Item","Units Ordered","Unit Price","Tax per Unit","Cost"]
[1094,"TIAB sampler",10,{"v":22,"d":"$22.00"},{"$f":"D4*Tax","v":{"v":0.88,"d":"$0.88"}},{"$f":"(D4+E4)*C4","v":{"v":228.79999999999998,"d":"$228.80"}}]
[1095,"SPF 15 gel",12,{"v":12,"d":"$12.00"},{"v":0.48,"d":"$0.48"},{"$f":"(D5+E5)*C5","v":{"v":149.76,"d":"$149.76"}}]
[1096,"SPF 30 gel",12,{"v":19,"d":"$19.00"},{"v":0.76,"d":"$0.76"},{"v":237.12,"d":"$237.12"}]
[1097,"SPF 45 gel",12,{"v":18,"d":"$18.00"},{"v":0.72,"d":"$0.72"},{"v":224.64,"d":"$224.64"}]
[1098,"SPF 60 gel",12,{"v":20,"d":"$20.00"},{"v":0.8,"d":"$0.80"},{"v":249.60000000000002,"d":"$249.60"}]
[1099,"Yan Can Shampoo",15,{"v":19,"d":"$19.00"},{"v":0.76,"d":"$0.76"},{"v":296.40000000000003,"d":"$296.40"}]
[1100,"Yan Can Conditioner",15,{"v":7,"d":"$7.00"},{"v":0.28,"d":"$0.28"},{"v":109.2,"d":"$109.20"}]
[1101,"Yan Can Hair Mask",15,{"v":18,"d":"$18.00"},{"v":0.72,"d":"$0.72"},{"v":280.79999999999995,"d":"$280.80"}]
[1102,"Yan Can Mousse",6,{"v":18,"d":"$18.00"},{"v":0.72,"d":"$0.72"},{"v":112.32,"d":"$112.32"}]
[1103,"Yan Can Gel",6,{"v":15,"d":"$15.00"},{"v":0.6,"d":"$0.60"},{"v":93.6,"d":"$93.60"}]
[1104,"Yan Can Moulding Gel",6,{"v":25,"d":"$25.00"},{"v":1,"d":"$1.00"},{"v":156,"d":"$156.00"}]
[1105,"Yan Can Masque",6,{"v":20,"d":"$20.00"},{"v":0.8,"d":"$0.80"},{"v":124.80000000000001,"d":"$124.80"}]
[1011,"Hair Tint -- color 01",25,{"v":12,"d":"$12.00"},{"v":0.48,"d":"$0.48"},{"v":312,"d":"$312.00"}]
[1012,"Hair Tint -- color 02",25,{"v":12,"d":"$12.00"},{"v":0.48,"d":"$0.48"},{"v":312,"d":"$312.00"}]
[1013,"Hair Tint -- color 03",25,{"v":12,"d":"$12.00"},{"v":0.48,"d":"$0.48"},{"v":312,"d":"$312.00"}]
[1014,"Hair Tint -- color 04",25,{"v":12,"d":"$12.00"},{"v":0.48,"d":"$0.48"},{"v":312,"d":"$312.00"}]
[1015,"Hair Tint -- color 05",25,{"v":12,"d":"$12.00"},{"v":0.48,"d":"$0.48"},{"v":312,"d":"$312.00"}]
[1016,"Hair Tint -- color 06",25,{"v":12,"d":"$12.00"},{"v":0.48,"d":"$0.48"},{"v":312,"d":"$312.00"}]
[1017,"Hair Tint -- color 07",25,{"v":12,"d":"$12.00"},{"v":0.48,"d":"$0.48"},{"v":312,"d":"$312.00"}]
[1018,"Hair Tint -- color 08",25,{"v":12,"d":"$12.00"},{"v":0.48,"d":"$0.48"},{"v":312,"d":"$312.00"}]
[1019,"Hair Tint -- color 09",25,{"v":12,"d":"$12.00"},{"v":0.48,"d":"$0.48"},{"v":312,"d":"$312.00"}]

{"sheet":"Purchase Order ","index":1,"n_rows":12,"n_cols":6,"rows_kept":12}
["Profit",null,null,"Shipping weight for this order"]
[{"$nulls":3},"Total weight must be <=",null,60]
[]
["Item","Retail Price","Cost of Goods","Shipping Weight","Stock Available","Units Sold"]
["SPF 15 gel",{"v":16,"d":"$16.00"},{"v":12,"d":"$12.00"},6,4]
["SPF 30 gel",{"v":17.5,"d":"$17.50"},{"v":14,"d":"$14.00"},6,5]
["SPF 45 gel",{"v":19,"d":"$19.00"},{"v":16,"d":"$16.00"},8,10]
["Yan Can Hair Mask",{"v":27.5,"d":"$27.50"},{"v":20,"d":"$20.00"},12,4]
["Yan Can Mousse",{"$f":"C9*1.25","v":{"v":25,"d":"$25.00"}},{"v":20,"d":"$20.00"},16,3]
["Yan Can Gel",{"v":22.5,"d":"$22.50"},{"v":15,"d":"$15.00"},6,5]
["Yan Can Moulding Gel",{"$f":"C11*1.25","v":{"v":25,"d":"$25.00"}},{"v":20,"d":"$20.00"},10,18]
["Yan Can Masque",{"v":35,"d":"$35.00"},{"v":30,"d":"$30.00"},20,4]

{"sheet":"PO July ","index":2,"n_rows":136,"n_cols":8,"rows_kept":136}
["PO #","Item ID","Item","Order Date","Date Expected","Ordered","Received","Value Received"]
["PO1104005",1036,"ColorFab Color 008","2013-07-01","2013-07-08",35,33,{"v":165,"d":"$165.00"}]
["PO1104005",1026,"Glazer 6 oz","2013-07-01","2013-07-09",20,20,{"v":200,"d":"$200.00"}]
["PO1104005",1029,"ColorFab Color 001","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1030,"ColorFab Color 002","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1031,"ColorFab Color 003","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1033,"ColorFab Color 005","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1034,"ColorFab Color 006","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1035,"ColorFab Color 007","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1037,"ColorFab Color 009","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1038,"ColorFab Color 010","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1027,"Glazer 8oz","2013-07-01","2013-07-09",20,20,{"v":220,"d":"$220.00"}]
["PO1104005",1028,"Glazer 20 oz","2013-07-01","2013-07-09",20,20,{"v":500,"d":"$500.00"}]
["PO1104005",1029,"ColorFab Color 001","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1030,"ColorFab Color 002","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1031,"ColorFab Color 003","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1033,"ColorFab Color 005","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1034,"ColorFab Color 006","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1035,"ColorFab Color 007","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1037,"ColorFab Color 009","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1038,"ColorFab Color 010","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1039,"ColorFab Color 011","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1040,"ColorFab Color 012","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1041,"ColorFab Color 013","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1042,"ColorFab Color 014","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1043,"ColorFab Color 015","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1044,"ColorFab Color 016","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1045,"ColorFab Color 017","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1046,"ColorFab Color 018","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1047,"ColorFab Color 019","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1048,"ColorFab Color 020","2013-07-01","2013-07-08",35,35,{"v":175,"d":"$175.00"}]
["PO1104005",1049,"ColorFab Drabber","2013-07-01","2013-07-08",35,35,{"v":280,"d":"$280.00"}]
["PO1104005",1050,"ColorFab Booster","2013-07-01","2013-07-08",35,35,{"v":420,"d":"$420.00"}]
["PO1104005",1051,"ColorFab 10","2013-07-01","2013-07-08",35,35,{"v":385,"d":"$385.00"}]
["PO1104005",1052,"ColorFab 20","2013-07-01","2013-07-08",35,35,{"v":385,"d":"$385.00"}]
["PO1104005",1053,"ColorFab 30","2013-07-01","2013-07-08",35,35,{"v":385,"d":"$385.00"}]
["PO1104005",1054,"ColorFab 40","2013-07-01","2013-07-08",35,35,{"v":385,"d":"$385.00"}]
["PO1104005",1032,"ColorFab Color 004","2013-07-01","2013-07-08",35,37,{"v":185,"d":"$185.00"}]
["PO1104008",1089,"Tea in a Bottle Shampoo","2013-07-01","2013-07-15",20,20,{"v":400,"d":"$400.00"}]
["PO1104008",1090,"Tea in a Bottle Conditioner","2013-07-01","2013-07-15",20,20,{"v":220,"d":"$220.00"}]
["PO1104008",1091,"TIAB 16 oz","2013-07-01","2013-07-15",20,20,{"v":300,"d":"$300.00"}]
["PO1104008",1092,"TIAB 32 oz","2013-07-01","2013-07-15",20,20,{"v":460,"d":"$460.00"}]
["PO1104008",1093,"TIAB 48 oz","2013-07-01","2013-07-15",20,20,{"v":500,"d":"$500.00"}]
["PO1104008",1094,"TIAB sampler","2013-07-01","2013-07-15",20,20,{"v":440,"d":"$440.00"}]
["PO1104009",1007,"DermoMagic 8 oz","2013-07-01","2013-07-22",30,28,{"v":280,"d":"$280.00"}]
["PO1104009",1099,"Yan Can Shampoo","2013-07-01","2013-07-22",30,20,{"v":380,"d":"$380.00"}]
["PO1104009",1100,"Yan Can Conditioner","2013-07-01","2013-07-22",30,0,0]
["PO1104009",1008,"DermoMagic 16 oz","2013-07-01","2013-07-22",15,15,{"v":225,"d":"$225.00"}]
["PO1104009",1009,"DermoMagic 24 oz","2013-07-01","2013-07-22",15,15,{"v":375,"d":"$375.00"}]
["PO1104009",1010,"DermoMagic samples","2013-07-01","2013-07-22",10,10,{"v":300,"d":"$300.00"}]
["PO1104009",1101,"Yan Can Hair Mask","2013-07-01","2013-07-22",20,20,{"v":360,"d":"$360.00"}]
["PO1104009",1102,"Yan Can Mousse","2013-07-01","2013-07-22",25,25,{"v":450,"d":"$450.00"}]
["PO1104009",1103,"Yan Can Gel","2013-07-01","2013-07-22",25,25,{"v":375,"d":"$375.00"}]
["PO1104009",1104,"Yan Can Moulding Gel","2013-07-01","2013-07-22",10,10,{"v":250,"d":"$250.00"}]
["PO1104009",1105,"Yan Can Masque","2013-07-01","2013-07-22",15,15,{"v":300,"d":"$300.00"}]
["PO1104001",1005,"Cuticle conditioner","2013-07-04","2013-07-18",20,18,{"v":234,"d":"$234.00"}]
["PO1104001",1001,"Bronzing gel","2013-07-04","2013-07-18",5,5,{"v":75,"d":"$75.00"}]
["PO1104001",1002,"Bronzing powder","2013-07-04","2013-07-18",20,20,{"v":500,"d":"$500.00"}]
["PO1104001",1004,"Cuticle remover","2013-07-04","2013-07-18",20,20,{"v":200,"d":"$200.00"}]
["PO1104001",1006,"Conditioning spray","2013-07-04","2013-07-18",15,15,{"v":255,"d":"$255.00"}]
["PO1104001",1003,"Bronzing blush","2013-07-04","2013-07-18",15,20,{"v":280,"d":"$280.00"}]
["PO1104002",1007,"DermoMagic 8 oz","2013-07-11","2013-08-01",30,28,{"v":280,"d":"$280.00"}]
["PO1104002",1008,"DermoMagic 16 oz","2013-07-11","2013-08-01",15,15,{"v":225,"d":"$225.00"}]
["PO1104002",1009,"DermoMagic 24 oz","2013-07-11","2013-08-01",15,15,{"v":375,"d":"$375.00"}]
["PO1104002",1010,"DermoMagic samples","2013-07-11","2013-08-01",10,10,{"v":300,"d":"$300.00"}]
["PO1104003",1015,"Hair Tint -- color 05","2013-07-16","2013-07-23",25,20,{"v":240,"d":"$240.00"}]
["PO1104003",1011,"Hair Tint -- color 01","2013-07-16","2013-07-23",25,25,{"v":300,"d":"$300.00"}]
["PO1104003",1012,"Hair Tint -- color 02","2013-07-16","2013-07-23",25,25,{"v":300,"d":"$300.00"}]
["PO1104003",1013,"Hair Tint -- color 03","2013-07-16","2013-07-23",25,25,{"v":300,"d":"$300.00"}]
["PO1104003",1014,"Hair Tint -- color 04","2013-07-16","2013-07-23",25,25,{"v":300,"d":"$300.00"}]
["PO1104003",1016,"Hair Tint -- color 06","2013-07-16","2013-07-23",25,25,{"v":300,"d":"$300.00"}]
["PO1104003",1017,"Hair Tint -- color 07","2013-07-16","2013-07-23",25,25,{"v":300,"d":"$300.00"}]
["PO1104003",1018,"Hair Tint -- color 08","2013-07-16","2013-07-23",25,25,{"v":300,"d":"$300.00"}]
["PO1104003",1019,"Hair Tint -- color 09","2013-07-16","2013-07-23",25,25,{"v":300,"d":"$300.00"}]
["PO1104004",1020,"Gloves -- 100 pk","2013-07-23","2013-07-28",100,100,{"v":2000,"d":"$2,000.00"}]
["PO1104004",1021,"Caps -- 100 pk","2013-07-23","2013-07-28",100,100,{"v":1900,"d":"$1,900.00"}]
["PO1104004",1022,"Brush style 120","2013-07-23","2013-07-28",50,50,{"v":1050,"d":"$1,050.00"}]
["PO1104004",1023,"Brush style 121","2013-07-23","2013-07-28",50,75,{"v":1200,"d":"$1,200.00"}]
["PO1104004",1024,"Brush style 122","2013-07-23","2013-07-28",50,50,{"v":700,"d":"$700.00"}]
["PO1104004",1025,"Brush style 123","2013-07-23","2013-07-28",50,50,{"v":1200,"d":"$1,200.00"}]
["PO1104006",1055,"NailMagic Color 01","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1056,"NailMagic Color 02","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1057,"NailMagic Color 03","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1058,"NailMagic Color 04","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1059,"NailMagic Color 05","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1060,"NailMagic Color 06","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1061,"NailMagic Color 07","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1062,"NailMagic Color 08","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1063,"NailMagic Color 09","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1064,"NailMagic Color 10","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1065,"NailMagic Color 11","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1066,"NailMagic Color 12","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1067,"NailMagic Color 13","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1068,"NailMagic Color 14","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1069,"NailMagic Color 15","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1070,"NailMagic Color 16","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1071,"NailMagic Color 17","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1072,"NailMagic Color 18","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1073,"NailMagic Color 19","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1074,"NailMagic Color 20","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1075,"NailMagic Color 21","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1076,"NailMagic Color 22","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1077,"NailMagic Color 23","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1078,"NailMagic Color 24","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1079,"NailMagic Color 25","2013-07-29","2013-08-12",25,25,{"v":106.25,"d":"$106.25"}]
["PO1104006",1080,"NailMagic Base","2013-07-29","2013-08-12",25,25,{"v":153.75,"d":"$153.75"}]
["PO1104006",1081,"NailMagic Top","2013-07-29","2013-08-12",25,20,{"v":123,"d":"$123.00"}]
["PO1104006",1082,"NailMagic Ridge Filler","2013-07-29","2013-08-12",25,20,{"v":240,"d":"$240.00"}]
["PO1104006",1083,"NailMagic Glossy","2013-07-29","2013-08-12",25,20,{"v":240,"d":"$240.00"}]
["PO1104006",1084,"NailMagic NoChip","2013-07-29","2013-08-12",25,20,{"v":200,"d":"$200.00"}]
["PO1104007",1001,"Bronzing gel","2013-07-29","2013-08-12",5,5,{"v":75,"d":"$75.00"}]
["PO1104007",1002,"Bronzing powder","2013-07-29","2013-08-12",20,20,{"v":500,"d":"$500.00"}]
["PO1104007",1085,"NoTan Tanning Spray","2013-07-29","2013-08-05",15,0,0]
["PO1104007",1086,"NoTan Moisturizer","2013-07-29","2013-08-05",15,0,0]
["PO1104007",1087,"NoTan Bronzer","2013-07-29","2013-08-05",15,0,0]
["PO1104007",1088,"NoTan Tanning Gel","2013-07-29","2013-08-05",5,0,0]
["PO1104007",1095,"SPF 15 gel","2013-07-29","2013-08-03",20,0,0]
["PO1104007",1096,"SPF 30 gel","2013-07-29","2013-08-03",20,0,0]
["PO1104007",1097,"SPF 45 gel","2013-07-29","2013-08-03",20,0,0]
["PO1104007",1098,"SPF 60 gel","2013-07-29","2013-08-03",20,0,0]
["PO1104010",1029,"ColorFab Color 001","2013-07-31","2013-08-07",35,20,{"v":100,"d":"$100.00"}]
["PO1104010",1030,"ColorFab Color 002","2013-07-31","2013-08-07",35,35,{"v":175,"d":"$175.00"}]
["PO1104010",1031,"ColorFab Color 003","2013-07-31","2013-08-07",35,35,{"v":175,"d":"$175.00"}]
["PO1104010",1033,"ColorFab Color 005","2013-07-31","2013-08-07",35,20,{"v":100,"d":"$100.00"}]
["PO1104010",1034,"ColorFab Color 006","2013-07-31","2013-08-07",35,35,{"v":175,"d":"$175.00"}]
["PO1104010",1035,"ColorFab Color 007","2013-07-31","2013-08-07",35,35,{"v":175,"d":"$175.00"}]
["PO1104010",1037,"ColorFab Color 009","2013-07-31","2013-08-07",35,35,{"v":175,"d":"$175.00"}]
["PO1104011",1015,"Hair Tint -- color 05","2013-07-31","2013-08-07",25,20,{"v":240,"d":"$240.00"}]
["PO1104011",1011,"Hair Tint -- color 01","2013-07-31","2013-08-07",25,25,{"v":300,"d":"$300.00"}]
["PO1104011",1012,"Hair Tint -- color 02","2013-07-31","2013-08-07",25,25,{"v":300,"d":"$300.00"}]
["PO1104011",1013,"Hair Tint -- color 03","2013-07-31","2013-08-07",25,25,{"v":300,"d":"$300.00"}]
["PO1104011",1014,"Hair Tint -- color 04","2013-07-31","2013-08-07",25,25,{"v":300,"d":"$300.00"}]
["PO1104011",1016,"Hair Tint -- color 06","2013-07-31","2013-08-07",25,25,{"v":300,"d":"$300.00"}]
["PO1104011",1017,"Hair Tint -- color 07","2013-07-31","2013-08-07",25,25,{"v":300,"d":"$300.00"}]
["PO1104011",1018,"Hair Tint -- color 08","2013-07-31","2013-08-07",25,25,{"v":300,"d":"$300.00"}]
["PO1104011",1019,"Hair Tint -- color 09","2013-07-31","2013-08-07",25,25,{"v":300,"d":"$300.00"}]