{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Expected QB Values","QB Report"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3245,"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":"Instructions","index":0,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["How to Use this Report:"]
["1. In AdvancePro, perform an export to QuickBooks."]
["2. Run \"Inventory Valuation Summary\" report in QB."]
["3. Export report to new Excel worksheet."]
["4. On the exported sheet, adjust columns as necessary so that Column C = 'Inventory', Column D = 'On Hand', Column F = 'Calculated Avg', and Column H = 'Asset Value'"]
["5. Select columns A to H, copy those columns and then paste onto the 'QB Report' sheet of this workbook (click on cell A1 and paste)"]
["6. Go to the 'Expected QB Values' sheet and set the start and end dates at the top to calculate avg. cost. Only bills & work orders within the selected date range will be used to calculate the avg. cost (if there are no bills or work orders, the current cost set for the  product will be used)."]
["7. Click the 'Refresh Report' button to populate the report with the latest AdvancePro data."]
["8. Save the report with a different name for reference (this will allow you to revert back if you accidentally refresh and affect the values used for comparison)."]

{"sheet":"Expected QB Values","index":1,"n_rows":123,"n_cols":24,"rows_kept":123,"cut":false,"hidden":false,"merged":[[3,1,3,5],[3,8,3,16],[3,17,3,23],[0,6,0,7],[3,6,3,7],[0,2,2,5]]}
[null,null,"AP vs. QB Inventory Comparison Report",null,null,null,"Avg. Cost Calculation"]
[null,null,null,null,null,null,"Start Date:","2018-01-01"]
[null,null,null,null,null,null,"End Date:","2018-12-31"]
[null,"AP Product Details",null,null,null,null,"QB Export Status",null,"Quantities on transactions pending export to QB (DS = 'Drop Ship', WO = 'Work Order')\nAdjusted = Inventory adjustments pending QB export (blank if auto adjust QB inv. Setting is enabled)",null,null,null,null,null,null,null,null,"Expected QB values vs. actual"]
["ID","Product SKU","Product Name","AP QTY","Cost","Avg. Cost","Exportable","Exported","Bills","DS Bills","Cust RMA","WO Built","Invoices","DS Invoices","Vendor RMA","WO Used","Adjusted","Exp. QB QTY","Actual QB QTY","Exp. Avg. Cost","Actual Avg. Cost","Exp. Asset Value","Actual Asset Value","Value Difference"]
[1290,"123","ASEMBLY 1",0,57.5,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},57.5,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1227,"252025-L3-W1-T4","CF25 with 25-26.9 Density, 32-35 long, <14 wide, 2.00-2.25 thick",40,13.4,13.4,1,1,null,null,null,null,null,null,null,null,null,40,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":40},13.4,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":3.4},536,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":136},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-400}]
[1285,"2x20 ABC","2x20 ft ABC",0,2,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},2,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1225,"303030-L4-W2-T3","CF30 with 30+ Density, 36-39 logn, 14-15 wide, 1.75-1.99 thick",100,43.4,43.4,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},43.4,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":3.4},4340,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":340},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-4000}]
[1270,"3M Angle","3M Angle",0,26,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},26,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1271,"3M Angle 2","3M Angle",0,26,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},26,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1284,"4x20 ABC ","4 ft x 20 ft roll ABC",400,2,null,1,1,5,null,null,null,null,null,null,null,null,395,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},2,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},790,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1223,"801000","AutoClave Green H10 ",10,47.4,24.771428571428572,1,1,null,null,null,null,null,null,null,null,null,10,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},24.771428571428572,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":3.4},247.71428571428572,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-247.71428571428572}]
[1224,"803000","Calcined H10",25,13.4,34.006060606060608,1,1,null,null,null,null,null,null,null,null,null,25,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},34.006060606060608,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":3.4},850.15151515151524,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-850.15151515151524}]
[1243,"ABM-04","Alabaster Black - Marble - 3/4 in - 110 x 54 inches",0,0,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1221,"ASSEM0002","Assembly Item 2",2,2,2,1,1,1,null,null,null,null,null,null,null,null,1,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},2,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},2,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-2}]
[1219,"ASSEM001","Test Assembly",1,17,17,1,1,null,null,null,null,null,null,null,null,null,1,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},17,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},17,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-17}]
[1093,"AWA51","Alienware Area 51 Computer",2010,167,34.349901896664484,1,1,201,null,null,null,16,null,10,null,null,1835,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1540},34.349901896664484,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":34},63032.069980379325,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":52360},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-10672.069980379325}]
[1170,"B-11","B 11",255,1.2345678,9.9009900990099015E-2,1,1,1006,null,null,null,3,null,null,null,null,-748,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},9.9009900990099015E-2,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},-74.059405940594061,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":74.059405940594061}]
[1275,"B-218/B-514 5 1/4'' Mdf Base 4608' per unit","B-218/B-514 5 1/4'' Mdf Base 4608' per unit",1000,0,null,1,0,null,null,null,null,null,null,null,null,null,1000,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1214,"B-487","Glass Bauble ",8,300,300,1,1,null,null,null,null,null,null,null,null,null,8,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":8},300,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":300},2400,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":2400},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1215,"B-678","Baseball Card ",0,50,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},50,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1129,"B-9.50","9.50 Burner",100,167,null,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},167,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":34},16700,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":3400},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-13300}]
[1251,"BASIC-ASSEMBLY","Basic Assembly",202,0,6.5,1,1,null,null,null,null,null,null,null,null,null,202,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},6.5,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},1313,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1207,"BASSWOOD","BASSWOOD",250,0,null,1,1,null,null,null,null,1,null,null,null,null,251,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1242,"BBG-01","Baltic Brown - Granite - 3/4in - 73 x 118 inches",51,0,0,1,1,null,null,null,null,1,null,null,null,null,52,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":51},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1066,"BCPotatoes","Betty Crocker Au Gratin Potatoes",79.099999999999994,7,null,1,1,null,null,null,null,17,null,null,null,null,96.1,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":148},7,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":7},672.69999999999993,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1036},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":363.30000000000007}]
[1067,"BD001","BLACK & DECKER 20-Volt Max 3/8-in Cordless Battery Included Drill",17,1,1,1,1,1,7,null,null,null,null,null,null,null,9,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":31.0001},1,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1},9,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":31},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":22}]
[1277,"BOB","BOB SAMPLE",10,1,null,1,1,10,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},1,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.01},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":1}]
[1279,"BOB2","BOBSAMPLE-2",99,10,null,1,1,null,null,null,null,1,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},10,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},1000,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1195,"BOB-BRIDGE","BOB-BRIDGE",99,0.01,null,1,1,null,null,null,null,1,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},0.01,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.01},1,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1176,"BOB-TAB-CORE","BOB-TAB-CORE",99,0.35,null,1,1,null,null,null,null,null,null,null,null,null,99,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":99},0.35,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.17},34.65,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":16.48},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-18.169999999999998}]
[1179,"BOB-TAB-TOP","BOB-TAB-TOP",99,0.1336,null,1,1,null,null,null,null,1,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},0.1336,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.13},13.36,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":13.36},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1178,"BOB-TAB-UNWOUND","BOB-TAB-UNWOUND",100,0.30009999999999998,null,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},0.30009999999999998,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.3},30.009999999999998,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":30.01},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1180,"BOB-TAB-WOUND","BOB-TAB-WOUND",99,3.6,null,1,1,null,null,null,null,null,null,null,null,null,99,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":99},3.6,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.85},356.40000000000003,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":83.76},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-272.64000000000004}]
[1265,"BOTTLE ","BOTTLE ",1000,0,null,1,1,null,null,null,null,null,null,null,null,null,1000,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1217,"BREAKER","BREAKER",1,0,0,1,1,null,null,null,null,null,null,null,null,null,1,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1065,"BSODA","Arm & Hammer Baking Soda",573,2,2,1,1,1,null,null,null,6,null,null,null,null,578,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":590.00004999999999},2,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":2},1156,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1180},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":24}]
[1100,"BYOPC","Build your own PC kit",0,null,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1069,"CEOSRT3","CANNON EOS Rebel T3",92,100,null,1,1,null,null,null,null,11,null,null,null,null,103,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":105},100,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},10300,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":10500},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":200}]
[1250,"CFB360NG","CFB360NG",0,null,null,1,1,null,null,null,null,2,null,null,null,null,2,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1276,"Closet Rod 1 1/4'' wood round pole","Closet Rod 1 1/4'' wood round pole",1000,0,null,1,0,null,null,null,null,null,null,null,null,null,1000,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1070,"CN5012","Canon 50mm 1.2L Lens",95,1100,null,1,1,null,null,null,null,null,null,null,null,null,95,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},1100,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1100},104500,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":110000},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":5500}]
[1071,"CN600EX","Canon Speedlite 600EX-RT Flash",20,300,null,1,1,6,null,null,null,null,null,null,null,null,14,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":14},300,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":300},4200,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":4200},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1241,"CO296","Black Antique - Granite - 3/4 in - 112 x 71 inches",10,0,null,1,1,null,29,null,null,null,29,null,null,null,10,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1244,"CT044","Bianco Pentelico - Marble - 3/4 in - 116 x 76 inches",0,0,null,1,1,null,null,null,null,1,null,null,null,null,1,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1288,"custom kit abc","custom kit abc",0,null,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1232,"cuztom xyz","custom xyz",0,23,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},23,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1150,"CVR-DYNA-B-GOLD","CVR-DYNA-B-GOLD",100,10,6,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},6,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":10},600,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1000},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":400}]
[1139,"CVR-DYN-B","DYNA COVER TALL",140,1,null,1,1,45,null,null,null,null,null,null,null,null,95,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},1,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1},95,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":5}]
[1141,"CVR-DYN-B-GLD","PLATING FOR TALL DYNA - GOLD",140,5,null,1,1,45,null,null,null,null,null,null,null,null,95,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},5,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":5},475,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":500},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":25}]
[1142,"CVR-DYN-CHM","PLATING FOR DYNA SHORT - CHROME",100,3,null,1,1,1,null,null,null,null,null,null,null,null,99,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":99},3,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":3},297,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":297},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1140,"CVR-DYN-N","DYNA COVER SHORT",100,5,5,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},5,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":5},500,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":500},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1261,"DHOInst","Downhole Oil Instrument",0,317,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},317,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1074,"DREM001","Dremel Micro 18-Piece Variable-Speed Multipurpose Rotary Tool Kit",93,150,null,1,1,1,null,null,null,2,null,null,null,null,94,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":98},150,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":150},14100,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":14700},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":600}]
[1073,"DREM002","Dremel All-Purpose Rotary Tool Accessory Kit",94,200,null,1,1,null,null,null,null,null,null,null,null,null,94,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},200,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":200},18800,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":20000},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":1200}]
[1095,"DREMKIT","Demel Tool + Bit Kit",0,null,null,1,1,null,null,null,null,1,null,null,null,null,1,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1259,"DS_ABC","Directional Sensor ABC",999,23,null,1,1,null,null,null,null,1,null,null,null,null,1000,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},23,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},23000,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1072,"DW0002","DEWALT 18-Volt 1/2-in Cordless Battery Included Drill with Soft Case",105,1,1,1,1,6,null,null,null,1,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":200},1,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1},100,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":200},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":100}]
[1291,"EXAMPLE","EXAMPLE",0,2.5,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},2.5,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1203,"FP-TAB","FP-TAB",99,0.43290000000000001,null,1,1,null,null,null,null,null,null,null,null,null,99,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":99},0.43290000000000001,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.43},42.857100000000003,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":42.86},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":2.899999999996794E-3}]
[1198,"FTB-NECHM","FTB-NECHM",100,0,null,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1286,"Full Install","Full Install",0,null,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1222,"H10","Hi Volatility Coal",29650,1.7,null,1,1,null,null,null,null,null,null,null,null,null,29650,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":29720},1.7,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1.7},50405,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":50524},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":119}]
[1078,"HDGT01","Häagen-Dazs Green Tea Ice Cream",151,2,null,1,1,null,null,null,null,null,null,null,null,null,151,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":152},2,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":2},302,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":304},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":2}]
[1245,"IGL-03","Indus Gold - Limestone - 3/4 in - 100 x 54 inches",51,0,0,1,1,null,null,null,null,null,null,null,null,null,51,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":51},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1255,"ING-BT","Beet Juice (LB)",73.123999999999995,2.9159999999999999,null,1,1,10,null,null,null,10,null,null,null,null,73.123999999999995,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},2.9159999999999999,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},213.22958399999999,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1079,"INT001","Intel® Pentium® G3240 Dual-Core 3.1GHz CPU/Gigabyte GA-B85M-HD3 mATX MB/4GB DDR3 1600 Adata XPG V1 Memory Bundle",995,100,100,1,1,1,null,null,null,null,null,null,null,null,994,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":997},100,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},99400,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":99700},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":300}]
[1230,"Internal ABC","Part; ABC",0,0,10,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},10,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1231,"iphone 6s","Iphone 6s",10,50,null,1,1,5,null,null,null,null,null,null,null,null,5,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":5},50,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":50},250,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":250},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1282,"kit1","KIT1",0,0,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1080,"LACREMA","Lavazza Crema Aroma Coffee Beans",151,12.5,12.5,1,1,null,null,null,null,null,null,null,null,null,151,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":150},12.5,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":12.5},1887.5,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1875},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-12.5}]
[1138,"MAG CYL","CYLINDER MAGNETS",5306,1,1,1,1,336,null,null,null,null,null,null,null,null,4970,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":5000},1,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1},4970,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":5000},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":30}]
[1162,"MAG WIRE","MAG WIRE",1000,13,null,1,1,1000,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},13,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1097,"MRSFIELD","Mrs. Fields' Chocolate Chip Cookies",120,5,4.4444444444444446,1,1,null,null,null,null,null,null,null,null,null,120,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":120},4.4444444444444446,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":4.79},533.33333333333337,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":575},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":41.666666666666629}]
[1240,"MWE0-22","Magnific White - Granite - 3/4 in - 124 x 73 inches",1,0,null,1,1,null,null,null,null,null,null,null,null,null,1,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1083,"N17-55mm","Nikon 17-55mm f/2.8G ED-IF AF-S DX Lens",109,1.08406,10,1,1,null,null,null,null,1,null,null,null,null,110,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},10,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":10},1100,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1000},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-100}]
[1084,"ND3200","Nikon D3200",103,1100.2588000000001,1100,1,1,null,null,null,null,3,null,null,null,null,106,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":105},1100,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1100.95},116600,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":115600},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-1000}]
[1085,"ND750","Nikon D750 FX-format Digital SLR",109,10.84845,100,1,1,null,null,null,null,1,null,null,null,null,110,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},100,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},11000,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":10000},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-1000}]
[1077,"NVG4CE","Gigabyte GeForce GTX 970 G1",870,110,110,1,1,1,null,null,null,null,null,null,null,null,869,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":879},110,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":2},95590,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1758},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-93832}]
[1239,"PanelABC","Solar Panel ABC",453,100,null,1,1,1000,null,null,null,null,null,null,null,null,-547,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":-547},100,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},-54700,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":-54700},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1087,"PHSAECO","Saeco Poemia Espresso Machine",96,110,null,1,1,null,null,null,null,1,null,null,null,null,97,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},110,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":110},10670,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":11000},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":330}]
[1187,"PLATING FOR 632S SCREW-CHROME","PLATING FOR 632S SCREW-CHROME",100,1,null,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},1,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1},100,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1260,"PressureSensor","Pressure Sensor",1000,86,null,1,1,null,null,null,null,null,null,null,null,null,1000,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},86,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},86000,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1092,"PSUP","Ultra LSP Series V2 650-Watt Power Supply - ATX, 6x SATA, 2x PCI-E, 20/24-PIN, Thermal Controlled,135mm Fan, Single +12V Rail, Short Circuit, Over-Voltage and Thermal Protection",41,25,null,1,1,1,null,null,null,1,null,null,null,null,41,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":87},25,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":25},1025,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":2175},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":1150}]
[1099,"RENT","RENT",100,0,null,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1266,"ROSE-098","ROSE ",0,0,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1263,"RW-09","WINE (RED)",1000,0,null,1,1,null,null,null,null,null,null,null,null,null,1000,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1090,"SB-COFFEE-12OZ","Starbucks House Blend Coffee 12oz Bag",150,7.5,null,1,1,null,null,null,null,null,null,null,null,null,150,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":150},7.5,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":7.5},1125,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1125},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1193,"SCRW 632","SCRW 632",100,0.01,null,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},0.01,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.01},1,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1194,"SCRW-632-CHM","SCRW-632-CHM",100,1.01,null,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},1.01,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1.01},101,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":101},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1088,"SDUSB-8GB","Sandisk USB Drive 8GB",83,7,null,1,1,1,null,null,null,null,null,null,null,null,82,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":90},7,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":7},574,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":630},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":56}]
[1235,"SKU123@*@!@","Test Product 2",0,0,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1257,"SWIM-1PC","SWIM-1PC",720,5,5,1,1,null,null,null,null,10,null,null,null,null,730,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},5,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},3650,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1256,"SWIM-2P","Swimsuit - 2 Piece",10,2,2,1,1,10,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},2,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1190,"TA ANGLE BRASS","TA ANGLE BRASS",100,0,null,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1157,"TA BOBBIN FB","TA BOBBIN FB",100,0.45860000000000001,0.13300000000000001,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},0.13300000000000001,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.46},13.3,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":45.86},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":32.56}]
[1160,"TA Plastic-B","TA Plastic-B",100,0.16250000000000001,null,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},0.16250000000000001,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.16},16.25,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":16.25},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1161,"TA TEARDROPS","TA TEARDROPS",100,2.9999999999999997E-4,null,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},2.9999999999999997E-4,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.01},0.03,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.8},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0.77}]
[1182,"TA TEARDROPS-PRESSED","TA TEARDROPS-PRESSED",94,1.0003,null,1,1,null,null,null,null,null,null,null,null,null,94,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":94},1.0003,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":6.05},94.028199999999998,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":568.51},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":474.48180000000002}]
[1212,"TAB-DACHM","TAB-DACHM",100,15.2097,15.2,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},15.2,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":15.21},1520,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-1520}]
[1151,"TAB-DAGLD","TAB-DAGLD",100,48.496600000000001,16.259999999999998,1,0,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":-1},16.259999999999998,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},1625.9999999999998,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-1625.9999999999998}]
[1209,"TAB-THICK","TAB-THICK",100,0.1,null,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},0.1,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.1},10,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":10},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1208,"TAB-THIN","TAB-THIN",100,0.25,null,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},0.25,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.25},25,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":25},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1205,"TAB-WOOD","TAB-WOOD",100,0,null,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1158,"TAN-DACHM","TAN-DACHM",100,12.2902,null,1,0,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},12.2902,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},1229.02,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-1229.02}]
[1189,"TA-SCREW","Height Adjustment screws",600,0.1,null,1,1,506,null,null,null,null,null,null,null,null,94,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":94},0.1,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.1},9.4,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":9.4},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1185,"TA-SPRING","TA-SPRING",600,0.1,null,1,1,506,null,null,null,null,null,null,null,null,94,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":94},0.1,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.1},9.4,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":9.4},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1238,"test234","test234",0,0,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1273,"TESTKIT","Test Kit",0,null,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1267,"TEST-TAX","Test Tax Item",0,null,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1218,"TILE","Ceramic Tile",1,10,null,1,1,10,null,null,null,null,null,null,null,null,-9,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":-1},10,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":10},-90,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":-10},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":80}]
[1199,"Tile_ABC","Stone Tile",1329,2.5,2.5,1,1,50,null,null,null,41,null,null,null,null,1320,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":540},2.5,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":2.5},3300,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":1350},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-1950}]
[1200,"Tile_XYZ","Tile XYZ 6''x6''",139,13,13,1,1,null,null,null,null,null,null,null,null,null,139,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":189},13,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":13},1807,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":2457},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":650}]
[1091,"Tob01","Toblerone Swiss Milk Chocolate with Honey and Almond Nouga (100g) Bar",151,2,null,1,1,null,null,null,null,10,null,null,null,null,161,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":162.00004999999999},2,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":2},322,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":324},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":2}]
[1101,"tshirt","T-shirt",31,2,null,1,1,30,null,null,null,null,null,null,null,null,1,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},2,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},2,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-2}]
[1247,"UOM-ITEM","UOM Item",100,1,1,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},1,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},100,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
[1229,"variant","new variant",0,null,null,1,1,null,null,null,null,null,null,null,null,null,0,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},null,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},null,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1128,"VAT1","Variable Assembly Test",120,110,69.5,1,1,null,null,null,null,null,null,null,null,null,120,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},69.5,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":39.07},8340,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":3907.14},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-4432.8600000000006}]
[1201,"WIR-2C"," Lead Wire",354,0.5,null,1,1,40.25,10,null,null,4,null,null,null,null,307.75,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":98.75},0.5,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.5},153.875,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":49.37},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":-104.505}]
[1197,"WOUND-BOB-FTB","WOUND-BOB-FTB",100,0.45200000000000001,null,1,1,null,null,null,null,null,null,null,null,null,100,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":100},0.45200000000000001,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":0.45},45.2,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":45.2},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":0}]
[1264,"WW-87","WHITE WINE ",500,0,null,1,1,null,null,null,null,null,null,null,null,null,500,{"$f":"INDEX('QB Report'!D:D,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!F:F,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},0,{"$f":"INDEX('QB Report'!H:H,MATCH(Table_Query_from_AdvancePro_DB4[[#This Row],[Product SKU]]&\"*\",'QB Report'!C:C,0))","v":{"$error":"#N/A"}},{"$f":"Table_Query_from_AdvancePro_DB4[[#This Row],[Actual Asset Value]]-Table_Query_from_AdvancePro_DB4[[#This Row],[Exp. Asset Value]]","v":{"$error":"#N/A"}}]
["Total",null,null,null,null,null,null,null,{"$f":"SUMIF(Table_Query_from_AdvancePro_DB4[Bills],\"<>#N/A\")","v":4836.25},{"$f":"SUMIF(Table_Query_from_AdvancePro_DB4[DS Bills],\"<>#N/A\")","v":46},{"$f":"SUMIF(Table_Query_from_AdvancePro_DB4[Cust RMA],\"<>#N/A\")","v":0},{"$f":"SUMIF(Table_Query_from_AdvancePro_DB4[WO Built],\"<>#N/A\")","v":0},{"$f":"SUMIF(Table_Query_from_AdvancePro_DB4[Invoices],\"<>#N/A\")","v":148},{"$f":"SUMIF(Table_Query_from_AdvancePro_DB4[DS Invoices],\"<>#N/A\")","v":29},{"$f":"SUMIF(Table_Query_from_AdvancePro_DB4[Vendor RMA],\"<>#N/A\")","v":10},{"$f":"SUMIF(Table_Query_from_AdvancePro_DB4[WO Used],\"<>#N/A\")","v":0},{"$f":"SUMIF(Table_Query_from_AdvancePro_DB4[Adjusted],\"<>#N/A\")","v":0},{"$f":"SUMIF(Table_Query_from_AdvancePro_DB4[Exp. QB QTY],\"<>#N/A\")","v":53091.974000000002},{"$f":"SUMIF(Table_Query_from_AdvancePro_DB4[Actual QB QTY],\"<>#N/A\")","v":44553.750200000002},null,null,{"$f":"SUMIF(Table_Query_from_AdvancePro_DB4[Exp. Asset Value],\"<>#N/A\")","v":719766.41959263792},{"$f":"SUMIF(Table_Query_from_AdvancePro_DB4[Actual Asset Value],\"<>#N/A\")","v":478894.4},{"$f":"SUMIF(Table_Query_from_AdvancePro_DB4[Value Difference],\"<>#N/A\")","v":-124805.79000863788}]

{"sheet":"QB Report","index":2,"n_rows":96,"n_cols":8,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"On Hand",null,"Avg Cost",null,"Asset Value"]
[null,"Inventory"]
[null,null,"_-*@test (Test Product 1)",0,null,0,null,0]
[null,null,"ABM-04 (Alabaster Black - Marble - 3/4 in - 110 x 54 inches)",0,null,0,null,0]
[null,null,"B-11 (B 11)",100,null,0,null,0]
[null,null,"B-487 (Glass Bauble)",8,null,300,null,2400]
[null,null,"B-678 (Baseball Card)",0,null,0,null,0]
[null,null,"BASSWOOD (BASSWOOD)",100,null,0,null,0]
[null,null,"BBG-01 (Baltic Brown - Granite - 3/4in - 73 x 118 inches)",51,null,0,null,0]
[null,null,"BCPotatoes (Betty Crocker Au Gratin Potatoes)",148,null,7,null,1036]
[null,null,"BD001 (BLACK & DECKER 20-Volt Max 3/8-in Cordless Battery Included Drill)",31.0001,null,1,null,31]
[null,null,"BOB-BRIDGE (BOB-BRIDGE)",100,null,0.01,null,1]
[null,null,"BREAKER (BREAKER)",1,null,0,null,0]
[null,null,"BSODA (Arm & Hammer Baking Soda)",590.00004999999999,null,2,null,1180]
[null,null,"CEOSRT3 (CANNON EOS Rebel T3)",105,null,100,null,10500]
[null,null,"CN5012 (Canon 50mm 1.2L Lens)",100,null,1100,null,110000]
[null,null,"CN600EX (Canon Speedlite 600EX-RT Flash)",14,null,300,null,4200]
[null,null,"CO296 (Black Antique - Granite - 3/4 in - 112 x 71 inches)",1,null,0,null,0]
[null,null,"CT044 (Bianco Pentelico - Marble - 3/4 in - 116 x 76 inches)",1,null,0,null,0]
[null,null,"CVR-DYN-B (DYNA COVER TALL)",100,null,1,null,100]
[null,null,"CVR-DYN-B-GLD (PLATING FOR TALL DYNA - GOLD)",100,null,5,null,500]
[null,null,"CVR-DYN-CHM (PLATING FOR DYNA SHORT - CHROME)",99,null,3,null,297]
[null,null,"CVR-DYN-N (DYNA COVER SHORT)",100,null,5,null,500]
[null,null,"DREM001 (Dremel Micro 18-Piece Variable-Speed Multipurpose Rotary Tool Kit)",98,null,150,null,14700]
[null,null,"DREM002 (Dremel All-Purpose Rotary Tool Accessory Kit)",100,null,200,null,20000]
[null,null,"DW0002 (DEWALT 18-Volt 1/2-in Cordless Battery Included Drill with Soft Case)",200,null,1,null,200]
[null,null,"H10 (Hi Volatility Coal)",29720,null,1.7,null,50524]
[null,null,"HDGT01 (Hagen-Dazs Green Tea Ice Cream)",152,null,2,null,304]
[null,null,"IGL-03 (Indus Gold - Limestone - 3/4 in - 100 x 54 inches)",51,null,0,null,0]
[null,null,"INT001 (Intel Pentium G3240 Dual-Core 3.1GHz CPU/Gigabyte GA-B85M-HD3 mATX MB/4GB...",997,null,100,null,99700]
[null,null,"Internal ABC (Part; ABC)",0,null,0,null,0]
[null,null,"iphone 6s (Iphone 6s)",5,null,50,null,250]
[null,null,"LACREMA (Lavazza Crema Aroma Coffee Beans)",150,null,12.5,null,1875]
[null,null,"MAG CYL (CYLINDER MAGNETS)",5000,null,1,null,5000]
[null,null,"MAG WIRE (MAG WIRE)",0,null,0,null,0]
[null,null,"MFEILD (Mrs. Feilds Chocolate Chip Cookies)",48,null,4,null,192]
[null,null,"MFEILDS (Mrs. Fields Jumbo Individually Wrapped Chocolate Chip Cookies (12 count))",80,null,54,null,4320]
[null,null,"MWE0-22 (Magnific White - Granite - 3/4 in - 124 x 73 inches)",1,null,0,null,0]
[null,null,"N17-55mm (Nikon 17-55mm f/2.8G ED-IF AF-S DX Lens)",100,null,10,null,1000]
[null,null,"ND3200 (Nikon D3200)",105,null,1100.95,null,115600]
[null,null,"ND750 (Nikon D750 FX-format Digital SLR)",100,null,100,null,10000]
[null,null,"NVG4CE (Gigabyte GeForce GTX 970 G1)",879,null,2,null,1758]
[null,null,"PanelABC (Solar Panel ABC)",-547,null,100,null,-54700]
[null,null,"PHSAECO (Saeco Poemia Espresso Machine)",100,null,110,null,11000]
[null,null,"PLATING FOR 632S SCREW-CHROME (PLATING FOR 632S SCREW-CHROME)",100,null,1,null,100]
[null,null,"PSUP (Ultra LSP Series V2 650-Watt Power Supply - ATX, 6x SATA, 2x PCI-E, 20/24-P...",87,null,25,null,2175]
[null,null,"RENT (RENT)",100,null,0,null,0]
[null,null,"SB-COFFEE-12OZ (Starbucks House Blend Coffee 12oz Bag)",150,null,7.5,null,1125]
[null,null,"SCRW 632 (SCRW 632)",100,null,0.01,null,1]
[null,null,"SDUSB-8GB (Sandisk USB Drive 8GB)",90,null,7,null,630]
[null,null,"SKU123@*@!@ (Test Product 2)",0,null,0,null,0]
[null,null,"TA-SCREW (Height Adjustment screws)",94,null,0.1,null,9.4]
[null,null,"TA-SPRING (TA-SPRING)",94,null,0.1,null,9.4]
[null,null,"TAB-DAGLD (TAB-DAGLD)",-1,null,0,null,0]
[null,null,"TAN-DACHM (TAN-DACHM)",0,null,0,null,0]
[null,null,"TILE (Ceramic Tile)",-1,null,10,null,-10]
[null,null,"Tile_ABC (Stone Tile)",540,null,2.5,null,1350]
[null,null,"Tile_XYZ (Tile XYZ 6''x6'')",189,null,13,null,2457]
[null,null,"Tob01 (Toblerone Swiss Milk Chocolate with Honey and Almond Nouga (100g) Bar)",162.00004999999999,null,2,null,324]
[null,null,"tshirt (T-shirt)",0,null,0,null,0]
[null,null,"variant (new variant)",0,null,0,null,0]
[null,null,"WIR-2C (Lead Wire)",98.75,null,0.5,null,49.37]
[null,"Total Inventory",null,{"$f":"ROUND(SUM(D2:D62),5)","v":40890.750200000002},null,null,null,{"$f":"ROUND(SUM(H2:H62),5)","v":420688.17}]
[null,"Assembly"]
[null,null,"252025-L3-W1-T4 (CF25 with 25-26.9 Density, 32-35 long, 14 wide, 2.00-2.25 thick)",40,null,3.4,null,136]
[null,null,"303030-L4-W2-T3 (CF30 with 30+ Density, 36-39 logn, 14-15 wide, 1.75-1.99 thick)",100,null,3.4,null,340]
[null,null,"801000 (AutoClave Green H10)",0,null,3.4,null,0]
[null,null,"803000 (Calcined H10)",0,null,3.4,null,0]
[null,null,"ASSEM0002 (Assembly Item 2)",0,null,0,null,0]
[null,null,"ASSEM001 (Test Assembly)",0,null,0,null,0]
[null,null,"AWA51 (Alienware Area 51 Computer)",1540,null,34,null,52360]
[null,null,"B-9.50 (9.50 Burner)",100,null,34,null,3400]
[null,null,"BOB-TAB-CORE (BOB-TAB-CORE)",99,null,0.17,null,16.48]
[null,null,"BOB-TAB-TOP (BOB-TAB-TOP)",100,null,0.13,null,13.36]
[null,null,"BOB-TAB-UNWOUND (BOB-TAB-UNWOUND)",100,null,0.3,null,30.01]
[null,null,"BOB-TAB-WOUND (BOB-TAB-WOUND)",99,null,0.85,null,83.76]
[null,null,"cuztom xyz (custom xyz)",0,null,0,null,0]
[null,null,"CVR-DYNA-B-GOLD (CVR-DYNA-B-GOLD)",100,null,10,null,1000]
[null,null,"FP-TAB (FP-TAB)",99,null,0.43,null,42.86]
[null,null,"FTB-NECHM (FTB-NECHM)",100,null,0,null,0]
[null,null,"MRSFIELD (Mrs. Fields' Chocolate Chip Cookies)",120,null,4.79,null,575]
[null,null,"SCRW-632-CHM (SCRW-632-CHM)",100,null,1.01,null,101]
[null,null,"TA ANGLE BRASS (TA ANGLE BRASS)",100,null,0,null,0]
[null,null,"TA BOBBIN FB (TA BOBBIN FB)",100,null,0.46,null,45.86]
[null,null,"TA Plastic-B (TA Plastic-B)",100,null,0.16,null,16.25]
[null,null,"TA TEARDROPS (TA TEARDROPS)",100,null,0.01,null,0.8]
[null,null,"TA TEARDROPS-PRESSED (TA TEARDROPS-PRESSED)",94,null,6.05,null,568.51]
[null,null,"TAB-DACHM (TAB-DACHM)",0,null,15.21,null,0]
[null,null,"TAB-THICK (TAB-THICK)",100,null,0.1,null,10]
[null,null,"TAB-THIN (TAB-THIN)",100,null,0.25,null,25]
[null,null,"TAB-WOOD (TAB-WOOD)",100,null,0,null,0]
[null,null,"test234 (test234)",0,null,0,null,0]
[null,null,"VAT1 (Variable Assembly Test)",100,null,39.07,null,3907.14]
[null,null,"WOUND-BOB-FTB (WOUND-BOB-FTB)",100,null,0.45,null,45.2]
[null,"Total Assembly",null,{"$f":"ROUND(SUM(D64:D94),5)","v":3691},null,null,null,{"$f":"ROUND(SUM(H64:H94),5)","v":62717.23}]
["TOTAL",null,null,{"$f":"ROUND(D63+D95,5)","v":44581.750200000002},null,null,null,{"$f":"ROUND(H63+H95,5)","v":483405.4}]