Skip to content

Instantly share code, notes, and snippets.

@lucyconklin

lucyconklin/test_item_group.csv

Created August 7, 2018 19:07
Show Gist options
  • Save lucyconklin/f8ea1d22f1ad7cbf8ce5d04100e0ae95 to your computer and use it in GitHub Desktop.
Save lucyconklin/f8ea1d22f1ad7cbf8ce5d04100e0ae95 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
test_item_group.csv
Item Description Type U/M Set U/M Materials Cost Materials Sales Price Labor Hours Labor Cost Labor Sales Price Total Sales Price
1" Quick Coupler 1" Quick Coupler Non-inventory Part Each Item each (ea) 70.13 206.38 - - - -
1" Swing Joint 1" Swing Joint Non-inventory Part Each Item each (ea) 55.52 163.39 - - - -
1.1/2" Poppet & Bonnet 1.1/2" Poppet & Bonnet Non-inventory Part Each Item each (ea) 185.06 544.61 - - - -
1.1/2" Shutoff Valve & Handle 1.1/2" Shutoff Valve & Handle Non-inventory Part Each Item each (ea) 60.92 179.28 - - - -
1.1/4" Poppet & Bonnet 1.1/4" Poppet & Bonnet Non-inventory Part Each Item each (ea) 62.07 182.66 - - - -
1.1/4" Shutoff Valve & Handle 1.1/4" Shutoff Valve & Handle Non-inventory Part Each Item each (ea) 60.92 179.28 - - - -
2" Ball Valve 2" Ball Valve Non-inventory Part Each Item each (ea) 45 132.43 - - - -
2" Poppet & Bonnet 2" Poppet & Bonnet Non-inventory Part Each Item each (ea) 185.06 544.61 - - - -
2" Pressure Regulator 2" Wilkins Pressure Regulator Non-inventory Part Each Item each (ea) 634 1865.77 - - - -
2" Shutoff Valve & Handle 2" Shutoff Valve & Handle Non-inventory Part Each Item each (ea) 60.92 179.28 - - - -
30" RCP 6' Section 30" RCP 6' Section Non-inventory Part Each Item each (ea) 222 653.31 8 560 1648 1076661.94
4" Round Nickle Bronze Flat Cap 4" Round Nickle Bronze Flat Cap Non-inventory Part Each Item each (ea) 65 191.29 0.25 17.5 51.5 9851.21
6" x 4" Rubber Coupling 6" x 4" Rubber Coupling Non-inventory Part Each Item each (ea) 22 64.74 - - - -
Abelia - 3 Gallon Abelia Non-inventory Part 3 Gallon gallon (gal) 15.94 46.91 0.04 2.63 7.73 362.37
African Bush Daisy African Bush Daisy Non-inventory Part 1 Gallon gallon (gal) 6.5 19.13 0.01 0.58 1.71 32.71
African Bush Daisy - 5gal African Bush Daisy Non-inventory Part 5 Gallon gallon (gal) 19.42 57.15 0.05 3.5 10.3 588.65
Agapanthus 'Peter Pan' - 1G Agapanthus 'Peter Pan' Non-inventory Part 1 Gallon gallon (gal) 5.5 16.19 0.01 0.58 1.71 27.67
Agapanthus 'Peter Pan' - 3G Agapanthus 'Peter Pan' Non-inventory Part 3 Gallon gallon (gal) 16.5 48.56 0.04 2.63 7.73 375.1
Agapanthus - 1 Gallon Agapanthus Non-inventory Part 1 Gallon gallon (gal) 5.95 17.51 0.01 0.58 1.71 29.94
Agapanthus - 3 Gallon Agapanthus Non-inventory Part 3 Gallon gallon (gal) 14.5 42.67 0.04 2.63 7.73 329.64
Agapanthus - 5 Gallon Agapanthus Non-inventory Part 5 Gallon gallon (gal) 21.25 62.54 0.05 3.5 10.3 644.12
Agapanthus "White Ice" - 2G Agapanthus "White Ice" Non-inventory Part 2 Gallon gallon (gal) 10 29.43 0.02 1.12 3.3 97
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment