Spreadsheet: 879399d1726869821-mixed-up-data-mix-test
Sheet: Sheet1

4203
 |  | Sales | Cost
96047 | Batteries | 4419.33 | 3145.89
Store | account code/description | Selling Price | Cost
4203 | 25 - Tire Accessories
4203 | 3003 - TPMS SENSOR | 613.89 | 105.3
4203 | 3005 - TPMS REBUILD KIT | 149.7 | 0
4203 | 96250 - RUBBER STEM | 535.02 | 0
4203 | 25 - Tire Accessories | 1298.61 | 105.3
4203 | 26 - Tire Labor
4203 | 97012 - TIRE SERVICES PACKAGES | 0 | 0
4203 | 99982 - TIRE LABOR | 1619.98 | 0
4203 | 99983 - NATIONAL TIRE LABOR | 495.86 | 0
4203 | 26 - Tire Labor | 2115.84 | 0
4203 | 30 - Wheels Accessories
4203 | 96830 - WHEEL TOOL | 0 | 24.35
4203 | 30 - Wheels Accessories | 0 | 24.35
4203 | 31 - Alignments
4203 | 977 - ALIGNMENT SERVICES | 11085.66 | 0
4203 | 31 - Alignments | 11085.66 | 0
4203 | 32 - LOF Services
4203 | 96054 - OIL FILTER | 996.11 | 403.76
4203 | 96394 - OIL DRAIN PLUG | 33.09 | 16.85
4203 | 96806 - FLUIDS AND OILS | 5273.91 | 2464.07
4203 | 97001 - LOF SERVICE PACKAGES | 850.09 | 0
4203 | 97021 - LOF SERVICE [NAME] | 3038.63 | 0
4203 | 32 - LOF Services | 10191.83 | 2884.68
4203 | 33 - Tune-Up
4203 | 96046 - AIR FILTER | 844.6 | 256.33
4203 | 96095 - COIL (IGNITION) | 1366.6 | 521.45
4203 | 96170 - PCV VALVE | 90.97 | 20.67
4203 | 96182 - SPARK PLUG | 1246.97 | 583.92
4203 | 96814 - ELECTRONIC IGNITION | 539.94 | 0
4203 | 99971 - TUNE UP DESCRIPTIONS | 2723.94 | 0
4203 | 33 - Tune-Up | 6813.02 | 1382.37
4203 | 34 - Cooling
4203 | 96052 - HEATER HOSE | 0 | 41.44
4203 | 96056 - RADIATOR | 1100.54 | 378.91
4203 | 96102 - COOL FAN SWITCH | 145.23 | 59.41
4203 | 96196 - THERMOSTAT & GASKET | 688.31 | 229.59
4203 | 96244 - THERMOSTAT GASKET | 26.98 | 76.38
4203 | 96316 - HOSE CLAMP | 82.88 | 8.58
4203 | 96358 - DRIVE BELT TENSIONER | 0 | 172.46
4203 | 96469 - FAN & MOTOR | 1225.55 | 591.77
4203 | 96645 - COOLING RESERVOIR | 429.41 | 176.31
4203 | 97022 - BELTS/COOLING DESCRIPTION | 5458.86 | 0
4203 | 34 - Cooling | 9157.76 | 1734.85
4203 | 35 - Electrical
4203 | 96069 - ALTERNATOR | 3846.72 | 1688.53
4203 | 96080 - BRAKE LIGHT SWITCH | 291.55 | 116.59
4203 | 96143 - HEADLAMP | 59.98 | 23.47
4203 | 96154 - LAMP BULB | 383.63 | 230.3
4203 | 96503 - INSTRUMENT CLUSTER | 498.56 | 180
4203 | 96700 - PIGTAIL CONNECTOR | 88.99 | 26.82
4203 | 96769 - ELECTRICAL SOCKET | 32.99 | 17.58
4203 | 97023 - ELECTRICAL DESCRIPTION | 5930.49 | 0
4203 | 99976 - BATTERY SERVICE | 2874.65 | 0
4203 | 35 - Electrical | 14007.56 | 2283.29
4203 | 36 - Batteries
4203 | 96047 - BATTERY | 4419.33 | 3145.89
4203 | 36 - Batteries | 4419.33 | 3145.89
4203 | 37 - Brakes
4203 | 37000 -  NON STOCK BRAKES | 189.56 | 126
4203 | 96020 - BRAKE CABLE | 509.52 | 279.59
4203 | 96023 - BRAKE ROTOR | 1912.38 | 534
4203 | 96027 - PADS (DISC BRAKE) | 2301.96 | 619.82
4203 | 96029 - BRAKE BOOSTER | 198.56 | 97.37
4203 | 96044 - WHEEL HUB (BRAKE) | 324.99 | 139.07
4203 | 96277 - BR MISC | 36.52 | 12.5
4203 | 97024 - BRAKES DESCRIPTION | 7253.28 | 0
4203 | 37 - Brakes | 12726.77 | 1808.35
4203 | 38 - Fuel/Emissions
4203 | 3803 - DRIVABILITY DIAGNOSTICS | 6010.97 | 0
4203 | 96066 - AIR FLOW MOTOR/SENSOR | 302.56 | 132.31
4203 | 96083 - CAMSHAFT SENSOR | 89.56 | 30.82
4203 | 96136 - FUEL PUMP | 0 | 196.79
4203 | 96153 - KNOCK SENSOR | 285.69 | 121.25
4203 | 96169 - OXYGEN SENSOR | 449.56 | 273.41
4203 | 96370 - FUEL SYSTEM | 239.56 | 94.04
4203 | 97005 - FUEL/EMISSION PACKAGES | 0 | 0
4203 | 97025 - FUEL/EMISSION DESCRIPTION | 1462.5 | 0
4203 | 38 - Fuel/Emissions | 8840.4 | 848.62
4203 | 39 - Heat/AC
4203 | 96064 - AC COMPRESSOR | 1095.56 | 752.86
4203 | 96124 - AC EVAPORATOR CORE | 697.99 | 236.46
4203 | 96220 - AC HOSE | 321.51 | 109.46
4203 | 96297 - AC KIT | -2.16 | 0
4203 | 96377 - HEAT AND AC SYSTEM | 0 | 39.93
4203 | 96768 - CABIN FILTERS | 844.71 | 201.88
4203 | 96815 - MISC AC | 711.96 | 0
4203 | 97006 - HEAT/AC PACKAGES | 0 | 0
4203 | 97026 - HEAT/AC DESCRIPTION | 2543.22 | 0
4203 | 39 - Heat/AC | 6212.79 | 1340.59
4203 | 40 - Engine
4203 | 40000 -  NON STOCK ENGINE | 7678.99 | 4986
4203 | 96086 - CAMSHAFT SEAL | 113.98 | 27.2
4203 | 96121 - ENGINE MOUNT | 2033.16 | 846.43
4203 | 96123 - CAM/CRANK BOLT KIT | 42.56 | 18.71
4203 | 96132 - FRONT CRANK SEAL | 89.56 | 26.36
4203 | 96207 - VALVE COVER GASKET | 875.5 | 263.3
4203 | 96234 - INTAKE MANIFOLD | 1211.11 | 1211.11
4203 | 96361 - ENGINE GASKET SET | 69.87 | 30.55
4203 | 96404 - ENGINE REAR MAIN SEAL | 142.99 | 37.04
4203 | 96517 - VALVE ADJUSTER | 259.85 | 156.18
4203 | 96519 - VALVE COVER | 36.99 | 18.03
4203 | 97027 - ENGINE DESCRIPTION | 10757.06 | 0
4203 | 40 - Engine | 23311.62 | 7620.91
4203 | 41 - Drivetrain
4203 | 4103 - DRIVETRAIN PACKAGES | 0 | 0
4203 | 96259 - HALFSHAFT | 769.61 | 284.02
4203 | 97028 - DRIVETRAIN DESCRIPTION | 5496.42 | 0
4203 | 41 - Drivetrain | 6266.03 | 284.02
4203 | 42 - Suspension/Steering
4203 | 4602 - SHOCK/STRUT LABOR | 2973.54 | 0
4203 | 96003 - CONTROL ARM | 9225.11 | 3507.04
4203 | 96013 - SWAY BAR BUSHING | 0 | 12
4203 | 96014 - SWAY BAR KIT | 0 | 48.46
4203 | 96015 - TIE ROD END | 179.65 | 54.47
4203 | 96254 - CONTROL ARM BUSHING | 0 | 10.36
4203 | 96485 - REAR TRAILING ARM | 149.69 | 45.38
4203 | 97029 - SUSPENSION/STEERING DESC | 7220.76 | 0
4203 | 42 - Suspension/Steering | 19748.75 | 3677.71
4203 | 43 - Exhaust
4203 | 96090 - CATALYTIC CONVERTER | 1417.1 | 1091.2
4203 | 96308 - CONVERTER | 0 | 478.23
4203 | 97030 - EXHAUST DESCRIPTION | 330 | 0
4203 | 43 - Exhaust | 1747.1 | 1569.43
4203 | 44 - Transmission
4203 | 96330 - AUTOMATIC TRANS | 383.55 | 137.45
4203 | 96618 - TRANSMISSION SHIFT CABLE | 1145.26 | 882.72
4203 | 96697 - OUTPUT SHAFT SEAL | 95.12 | 55.6
4203 | 97008 - TRANSMISSION PACKAGES | 156 | 0
4203 | 44 - Transmission | 1779.93 | 1075.77
4203 | 45 - Safety Inspections
4203 | 99990 - SAFETY INSPECTIONS | 4287.32 | 0
4203 | 45 - Safety Inspections | 4287.32 | 0
4203 | 46 - Shocks & Struts
4203 | 96057 - SHOCK | 1663.06 | 529.44
4203 | 96058 - STRUT ASSEMBLY | 3241.6 | 1355.12
4203 | 46 - Shocks & Struts | 4904.66 | 1884.56
4203 | 48 - Shop Supplies
4203 | 99984 - SHOP SUPPLIES | 7942.12 | 0
4203 | 48 - Shop Supplies | 7942.12 | 0
4203 | 50 - Miscellaneous
4203 | 5002 - HEADLIGHT RESTORATION | 579.86 | 277.7
4203 | 96053 - MAINTENANCE | 32.02 | 0
4203 | 96214 - WIPER BLADES | 799.09 | 251.97
4203 | 96793 - MISC SEAL | 0 | 17.8
4203 | 97031 - MISCELLANEOUS DESCRIPTION | 918.96 | 0
4203 | 50 - Miscellaneous | 2329.93 | 547.47
4203 | 51 - Coupons/Discounts
4203 | 5106 - TAXABLE COUPONS | -3816.62 | 0
4203 | 51 - Coupons/Discounts | -3816.62 | 0
4203 | 52 - Disposal and Environmental Fees
4203 | 99970 - NATL OIL FILTER DISPOSAL FEES | 33.56 | 0
4203 | 99992 - OTHER DISPOSAL FEES | 35 | 0
4203 | 52 - Disposal and Environmental Fees | 68.56 | 0
4203 | 55 - National Account Labor
4203 | 5501 - NATIONAL ACCOUNT LABOR | 32.85 | 0
4203 | 55 - National Account Labor | 32.85 | 0
4203 | 60 - Outside Services
4203 | 6002 - MISC SUBLET LABOR | 772.99 | 583
4203 | 60 - Outside Services | 772.99 | 583
4203 | 66 - Belts and Hoses
4203 | 96055 - RADIATOR HOSE | 507.65 | 180.7
4203 | 96117 - DRIVE BELT | 799.9 | 219.18
4203 | 66 - Belts and Hoses | 1307.55 | 399.88
4203 | 67 - Fuel injection Services
4203 | 3802 - FUEL INJECTOR CLEANER | 454.93 | 95.04
4203 | 6701 - FUEL INJECTION SERVICE PACKAGE | 0 | 0
4203 | 6702 - FUEL INJECTION SERVICE LABOR | 865 | 0
4203 | 67 - Fuel injection Services | 1319.93 | 95.04
4203 | 68 - Power Steering Flush
4203 | 6801 - POWER STEERING FLUSH PACKAGE | 0 | 0
4203 | 6802 - POWER STEERING FLUSH LABOR | 120 | 0
4203 | 96441 - POWER STEERING FLUID | 149.98 | 55.38
4203 | 68 - Power Steering Flush | 269.98 | 55.38
4203 | 69 - Coolant Flush
4203 | 6901 - COOLANT FLUSH PACKAGE | 0 | 0
4203 | 6902 - COOLANT FLUSH LABOR | 2184.56 | 0
4203 | 96347 - ENGINE COOLANT | 2575.16 | 606.18
4203 | 69 - Coolant Flush | 4759.72 | 606.18
4203 | 70 - Transmission Flush
4203 | 7001 - TRANSMISSION FLUSH PACKAGE | 0 | 0
4203 | 7002 - TRANSMISSION FLUSH LABOR | 752.96 | 0
4203 | 96354 - DIFFERENTIAL OIL | 869.71 | 288.03
4203 | 96419 - TRANS FLUID/CHEMICALS | 1615.53 | 560.03
4203 | 70 - Transmission Flush | 3238.2 | 848.06
4203 | 71 - Brake Fluid Flush
4203 | 7101 - BRAKE FLUSH PACKAGE | 0 | 0
4203 | 7102 - BRAKE FLUSH LABOR | 1746 | 0
4203 | 96440 - BRAKE FLUID | 1096.78 | 167.42
4203 | 71 - Brake Fluid Flush | 2842.78 | 167.42
4203 | 72 - Freon and AC Chemicals
4203 | 3903 - FREON | 573.23 | 112.65
4203 | 72 - Freon and AC Chemicals | 573.23 | 112.65
4203 | group total: | 170556.2 | 35085.77