{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["MNA Datagrid collect","MNA Datagrid view"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":"MNA Datagrid collect","index":0,"n_rows":168,"n_cols":29,"rows_kept":168,"cut":false,"hidden":false,"merged":[[2,27,2,28]]}
[null,null,null,{"$f":"\"MS000MNA\"","v":"MS000MNA"},{"$f":"VLOOKUP(DataColl[[#This Row],[DBA]],#REF!,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":{"$error":"#VALUE!"}},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":{"$error":"#VALUE!"}},null,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operated\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":{"$error":"#VALUE!"}},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I","X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"($ en miles)"]
[]
[null,null,"ConsD","Partner","Vendor","DBA","Portfolio","MID","Period","Period_","MID+Per","Net\nVolume","Net\nVolume 0","NetNo","Tot\nDiscIncome","Tot\nAuthRev","Tot\nProcRev","Tot\nMiscRev","GrossRev","DiscExp","MNA20%","Tot\nAuthExp","Tot\nProcExp","Tot\nMiscExp","GrossExp","TotResidual\nEarnings","TotResEarn_Err","Inactive","Error"]
[null,null,{"$f":"IF(C5=\"ConsD\",1,C5+1)","v":1},{"$f":"\"MS000MNA\"","v":"MS000MNA"},"MNA01","CACTUS COMIDA MEXICANA 1","MS000MNAA1","8031689469","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803168946942979},26048.97,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},1900,908.77,201.06,0,89.98,1199.81,615.17999999999995,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":176.91649999999998},90.21,35.840000000000003,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":933.14649999999995},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":266.6635},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,2,"MS000MNA","MNA01","SOLUCIONES ADMINISTRATIVAS","MS000MNAA1","8031694931","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803169493142979},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,3,"MS000MNA","MNA01","CACTUS TAQUERIA 4","MS000MNAA1","8031700076","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803170007642979},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,15,0,0,34.979999999999997,49.98,7.5,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":10.995000000000001},0,0,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":33.495000000000005},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":16.484999999999992},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,4,"MS000MNA","MNA01","CACTUS TAQUERIA 3","MS000MNAA1","8031700159","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803170015942979},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,15,0,0,34.979999999999997,49.98,7.5,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":10.995000000000001},0,0,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":33.495000000000005},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":16.484999999999992},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,5,"MS000MNA","MNA02","LAS PLAYAS DE DON ARTURO","MS000MNAA1","8031751814","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803175181442979},1241.2,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},48,39.67,8.4,44.94,29.99,123,31.1,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":24.53},1.31,27.99,593,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":677.93000000000006},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-554.93000000000006},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,6,"MS000MNA","MNA01","LA PEQUENA CAKE DECORACION","MS000MNAA1","8031789327","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803178932742979},399.7,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},20,12.36,2.2999999999999998,4.0199999999999996,19.98,38.659999999999997,8.18,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":8.0289999999999999},1.04,2.21,2,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":21.459},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":17.200999999999997},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,7,"MS000MNA","MNA01","LA PEQUENA PANADERIA","MS000MNAA1","8031796280","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803179628042979},649.46,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},59,35.340000000000003,10.45,41.78,20.97,108.54,24.14,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":22.307000000000002},2.41,24,7,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":79.856999999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":28.683000000000007},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,8,"MS000MNA","MNA01","PANCAKES CELESTIALES","MS000MNAA1","8031806311","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180631142979},2534.9299999999998,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},80,63.34,0.5,1.22,19.98,85.04,34.35,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":14.390000000000002},0.14000000000000001,2.0499999999999998,2,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":52.93},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":32.110000000000007},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,9,"MS000MNA","MNA02","HELADOS MEXTY 2","MS000MNAA1","8031806618","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180661842979},389.97,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},41,14.34,2.15,5.09,0,21.58,11.15,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":3.165},0.81,4.97,202,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":222.095},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-200.51499999999999},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,10,"MS000MNA","MNA02","HELADOS MEXTY","MS000MNAA1","8031806667","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180666742979},52.95,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},11,3.1,0.6,1.82,5,10.52,2.37,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":2.1559999999999997},0.31,1.71,361,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":367.54599999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-357.02600000000001},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,11,"MS000MNA","MNA01","TORTAS MEXICO RESTAURANT","MS000MNAA1","8031806931","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180693142979},2590.38,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},135,85.14,14.5,0,19.98,119.62,52.8,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":19.345000000000002},2.39,2.56,2,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":79.094999999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":40.525000000000006},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,12,"MS000MNA","MNA02","CARNITAS EL REY","MS000MNAA1","8031816237","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181623742979},7930.67,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},344,181.03,25.3,0,20,226.33,131.96,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":30.190500000000004},2.78,6.8,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":171.73050000000003},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":54.599499999999978},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,13,"MS000MNA","MNA02","CARNITAS EL REY 2","MS000MNAA1","8031816310","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181631042979},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,14,"MS000MNA","MNA02","ELIAS BABY FASHION","MS000MNAA1","8031816385","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181638542979},329.18,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},6,4.88,0.3,0.69,30,35.869999999999997,3.15,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":8.3375000000000004},0.12,0.71,2,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":14.317499999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":21.552499999999998},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,15,"MS000MNA","MNA02","GELI DELISH","MS000MNAA1","8031818316","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181831642979},190.41,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},13,6.16,2.8,11.42,25,45.38,4.6399999999999997,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":10.417000000000002},0.31,2.87,132,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":150.23699999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-104.857},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,16,"MS000MNA","MNA01","MANUELITOS RESTAURANT Y TAQUERIA","MS000MNAA1","8031819561","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181956142979},305.36,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},20,10.3,2.1,0,246.89,259.29000000000002,6.26,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":63.57050000000001},0.37,0.4,204,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":274.60050000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-15.31049999999999},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,17,"MS000MNA","MNA01","ANGEL RADIADOES 1","MS000MNAA1","8031820353","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182035342979},2188.5,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},22,43.59,1.6,12.55,246.98,304.72000000000003,20.88,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":72.004000000000005},0.31,5.65,184,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":282.84399999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":21.876000000000033},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,18,"MS000MNA","MNA02","PANADERIA DE ANA","MS000MNAA1","8031821096","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182109642979},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0.02,0.01,0,0,0.03,0.02,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":3.4999999999999996E-3},0.02,0,580,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":580.04349999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-580.01350000000002},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,19,"MS000MNA","MNA02","DIETERS MOTORES IMPORTADOS","MS000MNAA1","8031821211","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182121142979},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0.04,0.05,7.0000000000000007E-2,20,20.16,0.04,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":5.032},0.02,7.0000000000000007E-2,202,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":207.16200000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-187.00200000000001},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,20,"MS000MNA","MNA01","TIOS CAFE","MS000MNAA1","8031825485","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182548542979},6903.74,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},239,215.42,20.6,0,19.98,256,134.04,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":37.192000000000007},3.22,4.62,2,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":181.072},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":74.927999999999997},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,21,"MS000MNA","MNA01","ANGEL RADIADOES 2","MS000MNAA1","8031843744","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803184374442979},4876.01,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},18,75.959999999999994,1.8,12.18,0,89.94,27.13,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":17.059000000000001},0.34,6.46,182,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":232.989},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-143.04900000000001},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,22,"MS000MNA","MNA02","JESSES TACO DE MEXICO","MS000MNAA1","8031845202","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803184520242979},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,23,"MS000MNA","MNA02","LA ESTRELLA MARKET","MS000MNAA1","8031845368","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803184536842979},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0.05,0,0.15,0,0.2,0.05,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":4.0000000000000008E-2},0,0.15,5,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":5.24},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-5.04},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,24,"MS000MNA","MNA01","LABORATORIOS DENTALES HICERAM","MS000MNAA1","8031858239","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803185823942979},9,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},2,0.69,0.2,0,0,0.89,0.54,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0.11449999999999999},0.05,0.04,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0.74450000000000016},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0.14549999999999985},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,25,"MS000MNA","MNA02","VC ARENA","MS000MNAA1","8031858973","201709 SEP",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-09-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803185897342979},1917.77,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},30,29.25,1.05,6.82,0,37.119999999999997,26.13,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":4.0540000000000003},0.78,5.69,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":36.653999999999996},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0.46600000000000108},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,26,"MS000MNA","MNA01","CACTUS COMIDA MEXICANA 1","MS000MNAA1",8031689469,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803168946943009},42095.42,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},3032,1459.97,308.20999999999998,0,89.98,1858.16,985.52,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":267.43600000000004},138.38,57.84,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":1464.1760000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":393.98399999999992},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,27,"MS000MNA","MNA01","SOLUCIONES ADMINISTRATIVAS","MS000MNAA1",8031693347,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803169334743009},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,28,"MS000MNA","MNA01","SOLUCIONES ADMINISTRATIVAS","MS000MNAA1",8031694931,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803169493143009},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,29,"MS000MNA","MNA01","CACTUS TAQUERIA 4","MS000MNAA1",8031700076,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803170007643009},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,15,0,0,34.979999999999997,49.98,7.5,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":10.995000000000001},0,0,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":33.495000000000005},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":16.484999999999992},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,30,"MS000MNA","MNA01","CACTUS TAQUERIA 3","MS000MNAA1",8031700159,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803170015943009},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,15,0,0,34.979999999999997,49.98,7.5,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":10.995000000000001},0,0,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":33.495000000000005},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":16.484999999999992},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,31,"MS000MNA","MNA02","LAS PLAYAS DE DON ARTURO","MS000MNAA1",8031751814,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803175181443009},3265.55,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},100,81.05,20.2,47.78,29.99,179.02,59.89,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":32.777000000000001},3.56,31.39,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":140.61700000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":38.402999999999992},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,32,"MS000MNA","MNA01","LA PEQUENA CAKE DECORACION","MS000MNAA1",8031789327,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803178932743009},958.34,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},37,25.68,4,5.87,19.98,55.53,15.39,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":10.804500000000001},2.0299999999999998,3.67,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":46.894500000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":8.6355000000000004},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,{"$f":"IF(C37=\"ConsD\",1,C37+1)","v":33},{"$f":"\"MS000MNA\"","v":"MS000MNA"},"MNA01","LA PEQUENA PANADERIA","MS000MNAA1",8031796280,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803179628043009},2185.6999999999998,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},191,102.2,27.65,47.09,20.97,197.91,70.55,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":35.3675},6.08,29.52,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":156.51749999999998},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":41.392500000000013},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,34,"MS000MNA","MNA01","PANCAKES CELESTIALES","MS000MNAA1",8031806311,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180631143009},59314.57,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},1715,1549.93,176.4,5.81,19.98,1752.12,881.2,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":261.78999999999996},26.94,35.659999999999997,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":1220.5900000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":531.52999999999975},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,35,"MS000MNA","MNA02","HELADOS MEXTY 2","MS000MNAA1",8031806618,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180661843009},878.74,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},80,30.16,4,20.23,0,54.39,23.42,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":8.9134999999999991},1.69,17.579999999999998,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":64.603499999999997},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-10.213499999999996},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,36,"MS000MNA","MNA02","HELADOS MEXTY","MS000MNAA1",8031806667,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180666743009},377.45,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},41,41.41,2.1,6.54,58.87,108.92,24.54,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":22.322000000000003},1.18,5.94,-324,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":-270.01800000000003},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":378.93800000000005},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,37,"MS000MNA","MNA01","TORTAS MEXICO RESTAURANT","MS000MNAA1",8031806931,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180693143009},19612.48,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},1133,668.9,166.2,1.03,19.98,856.11,416.25,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":130.7775},28.43,22.37,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":612.82749999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":243.28250000000003},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,38,"MS000MNA","MNA02","CARNITAS EL REY","MS000MNAA1",8031816237,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181623743009},67392.39,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},3272,1598.48,479.5,0,15.33,2093.31,1145.8800000000001,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":294.1515},51.82,64.58,8.32,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":1564.7514999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":528.55850000000009},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,39,"MS000MNA","MNA02","CARNITAS EL REY 2","MS000MNAA1",8031816310,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181631043009},0.01,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},1,34.33,1.2,0,81.83,117.36,17.36,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":25.868000000000002},0.27,0.02,33,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":76.518000000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":40.841999999999999},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,40,"MS000MNA","MNA02","ELIAS BABY FASHION","MS000MNAA1",8031816385,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181638543009},8511.7199999999993,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},105,142.68,5.3,6.07,91.83,245.88,100.17,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":41.435999999999993},1.99,6.86,217,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":367.45600000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-121.57600000000002},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,41,"MS000MNA","MNA02","GELI DELISH","MS000MNAA1",8031818316,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181831643009},1317.92,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},56,31.42,12,41.51,76.83,161.76,22.76,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":35.887999999999998},1.26,11.01,-324,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":-253.08199999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":414.84199999999998},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,42,"MS000MNA","MNA01","MANUELITOS RESTAURANT Y TAQUERIA","MS000MNAA1",8031819561,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181956143009},11615.02,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},554,352.49,58.9,4.62,19.89,435.9,209.4,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":67.094999999999999},9.2200000000000006,13.41,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":314.12500000000006},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":121.77499999999992},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,43,"MS000MNA","MNA01","ANGEL RADIADOES 1","MS000MNAA1",8031820353,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182035343009},23350.5,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},190,495.82,20.2,93.67,19.98,629.66999999999996,257.17,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":105.98349999999999},3.43,49.88,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":431.46350000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":198.20649999999995},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,44,"MS000MNA","MNA02","PANADERIA DE ANA","MS000MNAA1",8031821096,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182109643009},406.66,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},7,39.69,0.32,2.38,10,52.39,21.86,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":8.7255000000000003},0.27,1.67,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":45.525500000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":6.8644999999999996},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,45,"MS000MNA","MNA02","DIETERS MOTORES IMPORTADOS","MS000MNAA1",8031821211,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182121143009},11030.36,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},20,263.99,0.8,26.8,81.83,373.42,217.07,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":49.94100000000001},0.37,14.17,215,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":496.55100000000004},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-123.13100000000003},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,46,"MS000MNA","MNA01","TIOS CAFE","MS000MNAA1",8031825485,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182548543009},26793.08,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},916,779.55,96.2,0,19.98,895.73,469.56,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":130.02050000000003},14.91,17.72,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":647.21050000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":248.51949999999999},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,47,"MS000MNA","MNA01","ANGEL RADIADOES 2","MS000MNAA1",8031843744,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803184374443009},19990,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},109,416.08,12.8,62.72,246.98,738.58,214.85,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":141.67500000000001},2.41,25.21,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":399.14499999999998},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":339.43500000000006},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,48,"MS000MNA","MNA02","JESSES TACO DE MEXICO","MS000MNAA1",8031845202,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803184520243009},11218.82,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},748,337.72,0,509.49,20,867.21,294.17,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":157.96850000000001},52.69,402.85,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":920.67849999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-53.468499999999949},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,49,"MS000MNA","MNA02","LA ESTRELLA MARKET","MS000MNAA1",8031845368,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803184536843009},7918.56,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},391,206.3,41.05,199.79,101.83,548.97,147.75,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":107.69250000000002},7.07,173.72,399,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":835.23250000000007},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-286.26250000000005},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,50,"MS000MNA","MNA01","LABORATORIOS DENTALES HICERAM","MS000MNAA1",8031858239,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803185823943009},8793.1200000000008,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},5,315.32,0.5,0,82.96,398.78,272.41000000000003,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":45.212999999999994},0.14000000000000001,0.1,25,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":342.86300000000006},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":55.916999999999916},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,51,"MS000MNA","MNA02","VC ARENA","MS000MNAA1",8031858973,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803185897343009},10850.7,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},152,199.69,8.4499999999999993,42.9,91.83,342.87,183.66,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":48.985500000000002},5.18,38.119999999999997,33,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":308.94549999999998},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":33.924500000000023},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,52,"MS000MNA","MNA02","LLANTAS AV","MS000MNAA1",8031864849,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803186484943009},82313.509999999995,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},322,1788.91,32.299999999999997,212.44,96.83,2130.48,1379.07,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":256.80600000000004},6.1,162.74,1039,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":2843.7159999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-713.23599999999988},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,53,"MS000MNA","MNA01","GLASS BOTTOM DISTRIBUTORES","MS000MNAA1",8031873345,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803187334543009},115,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},1,1.1200000000000001,0.3,0,148.97999999999999,150.4,0.5,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":37.500000000000007},7.0000000000000007E-2,0.02,117,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":155.09},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-4.6899999999999977},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,54,"MS000MNA","MNA02","FUNERARIA LLC","MS000MNAA1",8031874814,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803187481443009},13581.46,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},10,214.68,0.11,0,30,244.79,134.72,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":34.253500000000003},0.46,0.2,20,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":189.6335},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":55.156499999999994},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,55,"MS000MNA","MNA01","RASPADOS GDL","MS000MNAA1",8031890828,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803189082843009},1238.94,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},151,976.97,15.8,28.08,424.98,1445.83,40.19,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":353.41949999999997},2.59,20.91,369,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":786.10950000000003},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":659.7204999999999},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,56,"MS000MNA","MNA02","JAN DJ COMMUNICACION","MS000MNAA1",8031902730,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803190273043009},550.02,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},10,11.69,1.5,1.33,10,24.52,8.4700000000000006,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":4.4359999999999999},0.26,1.08,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":14.246},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":10.273999999999999},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,57,"MS000MNA","MNA02","LA VEROS COMIDA DE MAR Y GRILL","MS000MNAA1",8031904702,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803190470243009},28002.67,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},736,12972.62,111,0,20,13103.62,339.34,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},11.4,14.38,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":365.11999999999995},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":12738.5},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":12738.5},null,"X"]
[null,null,58,"MS000MNA","MNA02","SALUD MAS VIDA","MS000MNAA1",8031919908,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803191990843009},2599.0700000000002,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},29,67.08,1.6,45.68,35,149.36000000000001,52.97,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":26.746000000000006},0.7,25.72,361,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":467.13600000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-317.77600000000001},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,59,"MS000MNA","MNA02","RUEDAS Y LLANTAS","MS000MNAA1",8031921417,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803192141743009},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,60,"MS000MNA","MNA01","NATS WEST","MS000MNAA1",8031932653,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803193265343009},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,61,"MS000MNA","MNA02","SALUD MAS VIDA","MS000MNAA1",8031946018,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803194601843009},935.98,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},20,24.87,0.85,25.66,0,51.38,19.350000000000001,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":8.9750000000000014},1.35,14.06,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":43.735000000000007},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":7.644999999999996},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,62,"MS000MNA","MNA02","SALUD MAS VIDA","MS000MNAA1",8031946091,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803194609143009},126.65,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},4,2.2000000000000002,0.2,6.87,0,9.27,1.38,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":2.0415000000000001},0.41,3.94,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":7.7714999999999996},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":1.4984999999999999},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,63,"MS000MNA","MNA02","EL FINO, ESTETICA","MS000MNAA1",8031965497,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803196549743009},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,64,"MS000MNA","MNA02","DULCERIA LA COLMENA","MS000MNAA1",8031968616,"201710 OCT",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-10-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803196861643009},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,177,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":177},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-177},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,{"$f":"IF(C69=\"ConsD\",1,C69+1)","v":65},{"$f":"\"MS000MNA\"","v":"MS000MNA"},"MNA01","CACTUS COMIDA MEXICANA 1","MS000MNAA1","8031689469","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803168946943040},43607.63,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},3137,1512.04,322.3,0,149.97,1984.31,1022.11,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":291.65550000000002},144.69,59.52,74.989999999999995,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":1592.9655},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":391.34449999999993},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,66,"MS000MNA","MNA01","SOLUCIONES ADMINISTRATIVAS","MS000MNAA1","8031693347","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803169334743040},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,67,"MS000MNA","MNA01","SOLUCIONES ADMINISTRATIVAS","MS000MNAA1","8031694931","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803169493143040},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,68,"MS000MNA","MNA01","CACTUS TAQUERIA 4","MS000MNAA1","8031700076","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803170007643040},26136.97,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},1521,839.27,161.30000000000001,0.26,94.97,1095.8,552.98,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":163.35399999999998},72.45,28.59,74.989999999999995,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":892.36400000000015},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":203.43599999999981},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,69,"MS000MNA","MNA01","CACTUS TAQUERIA 3","MS000MNAA1","8031700159","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803170015943040},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,15,0,0,94.97,109.97,7.5,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":25.9925},0,0,74.989999999999995,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":108.48249999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":1.4875000000000114},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,70,"MS000MNA","MNA02","LAS PLAYAS DE DON ARTURO","MS000MNAA1","8031751814","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803175181443040},1589.31,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},67,44.14,14.35,63.73,89.98,212.2,32.93,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":46.463999999999999},2.86,39.542499999999997,77.989999999999995,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":199.78649999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":12.413499999999999},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,71,"MS000MNA","MNA01","LA PEQUENA CAKE DECORACION","MS000MNAA1","8031789327","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803178932743040},506.72,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},23,20.71,2.2999999999999998,1.08,19.98,44.07,11.955,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":8.6265000000000001},1.02,1.06,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":37.661499999999997},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":6.4085000000000036},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,72,"MS000MNA","MNA01","LA PEQUENA PANADERIA","MS000MNAA1","8031796280","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803179628043040},1635.15,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},133,73.209999999999994,21.1,56.4,20.97,171.68,50.16,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":32.888000000000005},5.0999999999999996,33.42,20,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":141.56799999999998},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":30.112000000000023},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,73,"MS000MNA","MNA01","PANCAKES CELESTIALES","MS000MNAA1","8031806311","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180631143040},58590.98,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},1696,1533.09,173.1,10.3,19.98,1736.47,871.21,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":259.87550000000005},26.43,37.29,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":1209.8055000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":526.66449999999986},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,74,"MS000MNA","MNA02","HELADOS MEXTY 2","MS000MNAA1","8031806618","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180661843040},540.03,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},50,20.62,2.6,18.25,0,41.47,15.79,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":7.2095000000000002},1.23,15.46,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":52.689499999999995},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-11.219499999999996},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,75,"MS000MNA","MNA02","HELADOS MEXTY","MS000MNAA1","8031806667","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180666743040},332.91,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},30,38.81,1.7,10.17,105,155.68,22.695,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":34.381000000000007},1.3,8.73,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":82.106000000000009},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":73.573999999999998},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,76,"MS000MNA","MNA01","TORTAS MEXICO RESTAURANT","MS000MNAA1","8031806931","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180693143040},18003.060000000001,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},974,606.74,100,1.1100000000000001,19.98,727.83,380.61,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":105.8355},15.78,18.91,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":536.13549999999998},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":191.69450000000006},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,77,"MS000MNA","MNA02","CARNITAS EL REY","MS000MNAA1","8031816237","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181623743040},64606.75,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},3040,1495.49,429.7,0,120,2045.19,1069.07,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":297.48350000000005},46.53,60.02,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":1486.1034999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":559.08650000000011},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,78,"MS000MNA","MNA02","CARNITAS EL REY 2","MS000MNAA1","8031816310","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181631043040},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,35.340000000000003,0,0,120,155.34,17.84,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":35.267000000000003},0,0,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":66.106999999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":89.233000000000004},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,79,"MS000MNA","MNA02","ELIAS BABY FASHION","MS000MNAA1","8031816385","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181638543040},6209.1,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},84,111.72,4.2,3.27,130,249.19,80.69,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":46.159500000000001},1.65,4.2,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":147.6995},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":101.4905},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,80,"MS000MNA","MNA02","GELI DELISH","MS000MNAA1","8031818316","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181831643040},674.29,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},29,17.32,5.8,46.21,125,194.33,12.82,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":46.01850000000001},0.73,12.97,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":87.538500000000013},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":106.7915},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,81,"MS000MNA","MNA01","MANUELITOS RESTAURANT Y TAQUERIA","MS000MNAA1","8031819561","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181956143040},10925.46,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},466,297.39,47.7,1.97,19.89,366.95,165.66,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":58.605500000000006},7.57,10.15,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":256.9855},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":109.96449999999999},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,82,"MS000MNA","MNA01","ANGEL RADIADOES 1","MS000MNAA1","8031820353","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182035343040},21477.19,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},173,460.84,18.399999999999999,88.99,19.98,588.21,235.69,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":99.914500000000004},3.16,46.18,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":399.94450000000006},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":188.26549999999997},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,83,"MS000MNA","MNA02","PANADERIA DE ANA","MS000MNAA1","8031821096","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182109643040},2088.9499999999998,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},78,71.459999999999994,5.32,14.63,110,201.41,53.63,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":39.6265},2.75,11,18,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":125.0065},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":76.403499999999994},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,84,"MS000MNA","MNA02","DIETERS MOTORES IMPORTADOS","MS000MNAA1","8031821211","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182121143040},30935.64,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},60,718.14,3.05,12.14,120,853.33,587.65,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":95.802500000000023},1.26,6.83,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":704.54250000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":148.78750000000002},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,85,"MS000MNA","MNA01","TIOS CAFE","MS000MNAA1","8031825485","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182548543040},29873.98,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},982,884.83,99.6,0.52,19.98,1004.93,541.07000000000005,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":143.01849999999999},15.37,19.46,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":733.91850000000011},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":271.01149999999984},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,86,"MS000MNA","MNA01","ANGEL RADIADOES 2","MS000MNAA1","8031843744","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803184374443040},20268,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},104,398.02,11.3,45.01,19.98,474.31,195.93,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":79.391500000000008},2.08,21.7,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":314.10149999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":160.20850000000002},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,87,"MS000MNA","MNA02","JESSES TACO DE MEXICO","MS000MNAA1","8031845202","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803184520243040},26116.85,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},1727,662.91,0,435.58,120,1218.49,562.97,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":192.02850000000001},83.78,368.34249999999997,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":1220.1210000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-1.6310000000000855},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,88,"MS000MNA","MNA02","LA ESTRELLA MARKET","MS000MNAA1","8031845368","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803184536843040},9881.19,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},493,252.6,50.5,279.43,140,722.53,179.32,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":144.76850000000002},8.5,239.98,20,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":592.56849999999997},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":129.9615},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,89,"MS000MNA","MNA01","LABORATORIOS DENTALES HICERAM","MS000MNAA1","8031858239","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803185823943040},10112.35,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},3,271.69,0.3,0,32.97,304.95999999999998,222.49,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":31.741999999999997},0.08,0.06,25,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":279.37200000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":25.587999999999965},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,90,"MS000MNA","MNA02","VC ARENA","MS000MNAA1","8031858973","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803185897343040},13974.19,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},186,268.69,9.5,39.020000000000003,130,447.21,250.51,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":61.700500000000005},3.37,34.54,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":363.12050000000005},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":84.08949999999993},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,91,"MS000MNA","MNA02","LLANTAS AV","MS000MNAA1","8031864849","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803186484943040},87861.84,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},411,1950.13,44,238.74,115,2347.87,1510.3,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":284.90750000000003},7.94,181.25,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":1999.3975},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":348.47249999999985},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,92,"MS000MNA","MNA01","GLASS BOTTOM DISTRIBUTORES","MS000MNAA1","8031873345","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803187334543040},742.74,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},2,21.7,0.3,0,19.98,41.98,12.545,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":7.9859999999999989},0.08,0.04,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":35.650999999999996},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":6.3290000000000006},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,93,"MS000MNA","MNA02","FUNERARIA LLC","MS000MNAA1","8031874814","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803187481443040},38610.870000000003,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},36,763.55,0.47,0,130,894.02,535.79,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":116.34700000000001},1.95,0.72,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":667.80700000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":226.21299999999997},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,94,"MS000MNA","MNA01","RASPADOS GDL","MS000MNAA1","8031890828","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803189082843040},3459.24,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},343,141.74,34.9,67,29.98,273.62,98.69,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":48.667000000000002},5.69,49.67,19,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":221.71699999999998},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":51.90300000000002},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,95,"MS000MNA","MNA02","JAN DJ COMMUNICACION","MS000MNAA1","8031902730","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803190273043040},1413.42,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},17,40.380000000000003,2.4,5.88,110,158.66,32.840000000000003,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":33.097000000000001},0.61,3.22,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":82.76700000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":75.892999999999986},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,96,"MS000MNA","MNA02","LA VEROS COMIDA DE MAR Y GRILL","MS000MNAA1","8031904702","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803190470243040},37567.96,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},977,676.39,148.65,0,120,945.04,464.33,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":143.39400000000001},15.25,19.28,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":655.25399999999991},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":289.78600000000006},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,97,{"$f":"\"MS000MNA\"","v":"MS000MNA"},"MNA02","SALUD MAS VIDA","MS000MNAA1","8031919908","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803191990843040},8566.2800000000007,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},106,221.79,5.4,216.89,135,579.08000000000004,174.81,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":109.80800000000002},2.1800000000000002,117.22,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":419.01800000000003},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":160.06200000000001},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,98,"MS000MNA","MNA02","RUEDAS Y LLANTAS","MS000MNAA1","8031921417","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803192141743040},40.03,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},4,35.979999999999997,0.2,0,130,166.18,18.43,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":37.859000000000002},0.17,0.08,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":69.539000000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":96.641000000000005},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,99,"MS000MNA","MNA01","NATS WEST","MS000MNAA1","8031932653","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803193265343040},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,14.9,0.1,0,19.98,34.979999999999997,7.45,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":7.2549999999999999},0.08,0,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":29.785},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":5.1949999999999967},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,100,"MS000MNA","MNA02","SALUD MAS VIDA","MS000MNAA1","8031946018","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803194601843040},7288.39,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},73,156.28,4.55,129.44999999999999,135,425.28,117.74,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":82.771999999999991},7.67,69.62,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":292.80200000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":132.47799999999995},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,101,"MS000MNA","MNA02","SALUD MAS VIDA","MS000MNAA1","8031946091","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803194609143040},804.31,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},19,21.84,0.95,27.32,135,185.11,16.96,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":42.885500000000008},1.82,15.76,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":92.425500000000014},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":92.6845},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,102,"MS000MNA","MNA02","EL FINO, ESTETICA","MS000MNAA1","8031965497","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803196549743040},5551.56,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},353,161.82,17.95,0,0,179.77,116.52,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":21.638500000000004},5.81,7.06,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":164.02850000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":15.741500000000002},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,103,"MS000MNA","MNA02","DULCERIA LA COLMENA","MS000MNAA1","8031968616","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803196861643040},3574.99,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},72,98.36,3.7,151.29,135,388.35,90.13,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":79.061500000000009},9.85,119.46,-142,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":156.50150000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":231.8485},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,104,"MS000MNA","MNA02","OXNARD HERRAMIENTAS DE ACERO","MS000MNAA1","8031981536","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803198153643040},10690.86,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},104,196.83,10.5,0,130,337.33,118.52,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":60.628500000000003},1.92,2.02,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":183.08850000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":154.24149999999997},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,105,"MS000MNA","MNA02","MR CAMARON 2","MS000MNAA1","8031988127","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803198812743040},0.01,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},1,0.19,0.1,0.39,125,125.68,0.14000000000000001,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":31.392000000000003},0.02,0.31,199,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":230.86199999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-105.18199999999999},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,106,"MS000MNA","MNA02","VEROS, COMIDA MEXICANA DE MAR Y BAR","MS000MNAA1","8031988580","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803198858043040},40964,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},1023,862.73,113.52,0,130,1106.25,541.16,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":168.33050000000003},16.12,20.079999999999998,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":745.69050000000004},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":360.55949999999996},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,107,"MS000MNA","MNA01","CACTUS TAQUERIA 2 EN PROV","MS000MNAA1","8032001698","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803200169843040},24441.58,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},1649,818.07,167.32,0,29.99,1015.38,544.85,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":144.875},72.41,32.22,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":794.35500000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":221.02499999999998},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,108,"MS000MNA","MNA02","BARRERAS RESTAURANT Y PANADERIA","MS000MNAA1","8032008487","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803200848743040},7024.59,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},251,152.22999999999999,12.3,0,120,284.52999999999997,108.53,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":49.426499999999997},9.11,5,7.5,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":179.56650000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":104.96349999999995},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,109,"MS000MNA","MNA02","TACOS JALISCO","MS000MNAA1","8032019443","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803201944343040},1660.39,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},110,60.94,5.5,0,0,66.44,44.43,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":7.7240000000000002},1.85,2.1800000000000002,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":56.183999999999997},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":10.256},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,110,"MS000MNA","MNA02","CAFFE VERONA","MS000MNAA1","8032029665","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803202966543040},1.25,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},4,1.19,0.3,0,120,121.49,0.99,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":30.174500000000002},0.12,0.08,177,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":208.36449999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-86.874499999999998},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,111,"MS000MNA","MNA02","EL AGAVE AZUL, RESTAURANT","MS000MNAA1","8032030135","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803203013543040},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0.34,0,0,200,200.34,0.22,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":50.041000000000004},0.02,0.02,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":50.301000000000009},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":150.03899999999999},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,112,"MS000MNA","MNA01","VANCOUVER WINGS","MS000MNAA1","8032045620","201711 NOV",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-11-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803204562043040},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,{"$f":"IF(C117=\"ConsD\",1,C117+1)","v":113},"MS000MNA","MNA01","CACTUS COMIDA MEXICANA 1","MS000MNAA1","8031689469","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803168946943070},41753.230000000003,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},2840,1414.12,288.88,0,199.96,1902.96,947.76,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":286.18800000000005},129.63999999999999,54.22,74.989999999999995,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":1492.7980000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":410.16199999999981},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,114,"MS000MNA","MNA01","SOLUCIONES ADMINISTRATIVAS","MS000MNAA1","8031693347","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803169334743070},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,115,"MS000MNA","MNA01","SOLUCIONES ADMINISTRATIVAS","MS000MNAA1","8031694931","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803169493143070},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,116,"MS000MNA","MNA01","CACTUS TAQUERIA 4","MS000MNAA1","8031700076","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803170007643070},93012.44,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},5801,3081.15,628.5,0,144.96,3854.61,2055.9499999999998,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":552.46250000000009},282.77,109.44,74.989999999999995,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":3075.6124999999997},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":778.9975000000004},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,117,"MS000MNA","MNA01","CACTUS TAQUERIA 3","MS000MNAA1","8031700159","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803170015943070},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,15,0,0,144.96,159.96,7.5,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":38.490000000000009},0,0,74.989999999999995,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":120.98},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":38.980000000000004},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,118,"MS000MNA","MNA02","LAS PLAYAS DE DON ARTURO","MS000MNAA1","8031751814","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803175181443070},1297.8499999999999,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},55,43.97,16.5,86.22,129.99,276.68,34.799999999999997,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":62.210000000000008},4.08,54.112499999999997,18,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":173.20249999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":103.47750000000002},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,119,"MS000MNA","MNA01","LA PEQUENA CAKE DECORACION","MS000MNAA1","8031789327","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803178932743070},1129.1500000000001,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},45,29.52,4.9000000000000004,0.76,129.96,165.14,17.649999999999999,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":37.754999999999995},2.06,1.24,74.989999999999995,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":133.69499999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":31.444999999999993},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,120,"MS000MNA","MNA01","LA PEQUENA PANADERIA","MS000MNAA1","8031796280","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803179628043070},2319.3000000000002,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},190,98.35,28.15,23.42,130.94999999999999,280.87,65.61,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":57.095500000000001},6.36,16.52,79.989999999999995,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":225.57550000000003},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":55.294499999999971},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,121,"MS000MNA","MNA01","PANCAKES CELESTIALES","MS000MNAA1","8031806311","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180631143070},70443.38,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},1832,1808.28,183,10.19,129.96,2131.4299999999998,1025.48,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":327.76149999999996},27.97,39.82,74.989999999999995,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":1496.0215000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":635.40849999999978},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,122,"MS000MNA","MNA02","HELADOS MEXTY 2","MS000MNAA1","8031806618","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180661843070},689.57,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},58,24.19,3,24.51,100,151.69999999999999,19.170000000000002,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":34.090999999999994},1.35,20.399999999999999,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":88.010999999999996},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":63.688999999999993},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,123,"MS000MNA","MNA02","HELADOS MEXTY","MS000MNAA1","8031806667","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180666743070},443.39,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},42,42.48,2.2000000000000002,5.35,5,55.03,25.285,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":8.7005000000000017},1.5,5.07,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":55.555500000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-0.52550000000000097},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,124,"MS000MNA","MNA01","TORTAS MEXICO RESTAURANT","MS000MNAA1","8031806931","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803180693143070},18056.509999999998,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},939,604.72,95.9,2.0299999999999998,129.96,832.61,378.08,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":132.53650000000002},15.27,18.989999999999998,74.989999999999995,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":619.86649999999997},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":212.74350000000004},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,125,"MS000MNA","MNA02","CARNITAS EL REY","MS000MNAA1","8031816237","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181623743070},71746.539999999994,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},3123,1607.42,446.9,0,20,2074.3200000000002,1162.24,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":286.13200000000006},48.41,61.64,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":1571.4220000000003},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":502.89799999999991},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,126,"MS000MNA","MNA02","CARNITAS EL REY 2","MS000MNAA1","8031816310","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181631043070},0.01,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},1,35.090000000000003,0.15,0,20,55.24,17.614999999999998,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":10.287000000000001},0.04,0.02,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":40.962000000000003},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":14.277999999999999},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,127,"MS000MNA","MNA02","ELIAS BABY FASHION","MS000MNAA1","8031816385","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181638543070},3855.23,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},50,70.45,2.5,3.22,30,106.17,51.09,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":16.3245},1.08,3.57,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":87.064499999999995},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":19.105500000000006},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,128,"MS000MNA","MNA02","GELI DELISH","MS000MNAA1","8031818316","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181831643070},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,129,{"$f":"\"MS000MNA\"","v":"MS000MNA"},"MNA01","MANUELITOS RESTAURANT Y TAQUERIA","MS000MNAA1","8031819561","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803181956143070},12178.65,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},534,332.83,54.8,1.89,129.87,519.39,185.39,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":92.769499999999994},8.64,11.57,74.989999999999995,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":373.35949999999997},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":146.03050000000002},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,130,"MS000MNA","MNA01","ANGEL RADIADOES 1","MS000MNAA1","8031820353","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182035343070},19246.8,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},168,316.25,18.600000000000001,56.13,129.96,520.94000000000005,194.24,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":91.387000000000029},3.2,32.42,74.989999999999995,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":396.23700000000008},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":124.70299999999997},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,131,"MS000MNA","MNA02","PANADERIA DE ANA","MS000MNAA1","8031821096","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182109643070},2919.94,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},98,73.81,5.66,25.35,10,114.82,56.33,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":17.439},2.83,16.649999999999999,18,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":111.249},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":3.570999999999998},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,132,"MS000MNA","MNA02","DIETERS MOTORES IMPORTADOS","MS000MNAA1","8031821211","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182121143070},22940.34,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},49,498.73,2.6,1.53,20,522.86,407.71,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":49.173000000000009},1.1100000000000001,1.77,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":472.76299999999998},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":50.097000000000037},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,133,"MS000MNA","MNA01","TIOS CAFE","MS000MNAA1","8031825485","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803182548543070},33114.15,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},1057,957.58,103,0.68,149.96,1211.22,579.05999999999995,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":186.99300000000002},15.91,20.7,94.99,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":897.65300000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":313.56700000000001},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,134,"MS000MNA","MNA01","ANGEL RADIADOES 2","MS000MNAA1","8031843744","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803184374443070},24215.279999999999,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},109,448.76,12.1,29.66,129.96,620.48,307.73,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":93.574000000000012},2.2000000000000002,18.2,74.989999999999995,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":496.69400000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":123.786},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,135,"MS000MNA","MNA02","JESSES TACO DE MEXICO","MS000MNAA1","8031845202","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803184520243070},45196.97,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},2906,1208.22,176.1,0,50,1434.32,876.8,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":183.22},103.82,57.54,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":1234.3799999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":199.94000000000005},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,136,"MS000MNA","MNA02","LA ESTRELLA MARKET","MS000MNAA1","8031845368","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803184536843070},9889.74,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},507,255.56,50.6,266.35000000000002,40,612.51,181.45,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":116.83750000000001},8.61,228.83,20,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":555.72750000000008},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":56.782499999999914},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,137,"MS000MNA","MNA01","LABORATORIOS DENTALES HICERAM","MS000MNAA1","8031858239","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803185823943070},8588,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},4,208.98,0.4,0,142.94999999999999,352.33,167.12,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":54.658499999999989},0.12,0.08,84.99,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":306.96850000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":45.361499999999978},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,138,"MS000MNA","MNA02","VC ARENA","MS000MNAA1","8031858973","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803185897343070},6970.08,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},115,134.87,5.8,52.81,30,223.48,123.87,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":31.095999999999997},2.2000000000000002,45.12,113,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":315.286},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-91.806000000000012},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,139,"MS000MNA","MNA02","LLANTAS AV","MS000MNAA1","8031864849","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803186484943070},110550.27,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},450,2237.4,46.15,230,15,2528.5500000000002,1688.92,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":294.35350000000005},8.7799999999999994,175.9425,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":2182.9960000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":345.55400000000009},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,140,"MS000MNA","MNA01","GLASS BOTTOM DISTRIBUTORES","MS000MNAA1","8031873345","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803187334543070},539.85,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},3,21.94,0.3,0,69.97,92.21,13.675000000000001,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":20.317500000000003},0.1,0.04,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":49.132500000000007},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":43.077499999999986},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,141,"MS000MNA","MNA02","FUNERARIA LLC","MS000MNAA1","8031874814","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803187481443070},46665.5,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},15,794.97,0.17,0,30,825.14,521.17999999999995,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":102.04900000000001},0.8,0.3,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":637.32899999999984},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":187.81100000000015},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,142,"MS000MNA","MNA01","RASPADOS GDL","MS000MNAA1","8031890828","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803189082843070},2652.84,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},278,111.26,28.1,48.82,-920.03,-731.85,77.34,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":-198.43050000000002},4.67,36.840000000000003,19,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":-60.580500000000015},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-671.26949999999999},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,143,"MS000MNA","MNA02","JAN DJ COMMUNICACION","MS000MNAA1","8031902730","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803190273043070},638,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},11,16.37,1.8,19.489999999999998,10,47.66,12.68,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":9.3789999999999996},0.48,9.61,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":45.149000000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":2.5109999999999957},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,144,"MS000MNA","MNA02","LA VEROS COMIDA DE MAR Y GRILL","MS000MNAA1","8031904702","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803190470243070},46118.76,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},1189,815.4,173.85,0,20,1009.25,555.29,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":141.25450000000001},17.8,23.38,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":750.72449999999992},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":258.52550000000008},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,{"$f":"IF(C149=\"ConsD\",1,C149+1)","v":145},"MS000MNA","MNA02","SALUD MAS VIDA","MS000MNAA1","8031919908","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803191990843070},9661.7199999999993,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},124,229.1,5.85,211.08,35,481.03,176.48,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":84.961500000000001},4.5199999999999996,117.22,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":398.18150000000003},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":82.848499999999945},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,146,"MS000MNA","MNA02","RUEDAS Y LLANTAS","MS000MNAA1","8031921417","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803192141743070},10254.01,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},91,119.8,4.5999999999999996,0,30,154.4,85.87,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":21.426000000000002},1.83,1.78,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":123.90600000000001},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":30.494},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,147,"MS000MNA","MNA01","NATS WEST","MS000MNAA1","8031932653","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803193265343070},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,14.9,0.1,0,69.97,84.97,7.45,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":19.752499999999998},0.08,0,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":42.282499999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":42.6875},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,148,"MS000MNA","MNA02","SALUD MAS VIDA","MS000MNAA1","8031946018","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803194601843070},6956.93,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},63,147.07,3.3,119.93,35,305.3,110.24,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":54.277000000000001},6.45,65.02,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":250.98699999999997},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":54.313000000000045},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,149,"MS000MNA","MNA02","SALUD MAS VIDA","MS000MNAA1","8031946091","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803194609143070},576.19000000000005,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},10,20.350000000000001,0.5,23.24,35,79.09,13.22,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":17.128500000000003},1.43,13.12,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":59.898499999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":19.191500000000005},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,150,"MS000MNA","MNA02","EL FINO, ESTETICA","MS000MNAA1","8031965497","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803196549743070},6943.01,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},398,187.67,20.2,0,0,207.87,133.22999999999999,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":25.321500000000007},10.79,7.96,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":190.3015},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":17.5685},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,151,"MS000MNA","MNA02","DULCERIA LA COLMENA","MS000MNAA1","8031968616","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803196861643070},3943.64,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},84,109.36,4.45,199.88,35,348.69,100.01,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":67.170500000000004},12.06,154.22,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":348.46050000000002},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0.22949999999997317},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,152,"MS000MNA","MNA02","OXNARD HERRAMIENTAS DE ACERO","MS000MNAA1","8031981536","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803198153643070},15652.93,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},86,446.89,9.6,0,30,486.49,338.48,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":53.926500000000004},1.8,1.68,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":408.88650000000007},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":77.60349999999994},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,153,"MS000MNA","MNA02","MR CAMARON 2","MS000MNAA1","8031988127","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803198812743070},0.02,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},2,35.130000000000003,0.2,0.81,25,61.14,17.829999999999998,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":11.719000000000001},0.05,0.65,15,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":45.248999999999995},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":15.891000000000005},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,154,"MS000MNA","MNA02","VEROS, COMIDA MEXICANA DE MAR Y BAR","MS000MNAA1",8031988580,"201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803198858043070},62599.8,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},1386,1378,158.72999999999999,0,30,1566.73,906.42,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":210.39850000000001},22.22,27.02,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":1179.0584999999999},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":387.67150000000015},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,155,"MS000MNA","MNA01","CACTUS TAQUERIA 2 EN PROV","MS000MNAA1","8032001698","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803200169843070},36140.79,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},2308,1147.48,236.42,0.84,79.98,1464.72,744.35,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":217.31},65.28,45.57,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":1085.51},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":379.21000000000004},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,156,"MS000MNA","MNA02","BARRERAS RESTAURANT Y PANADERIA","MS000MNAA1","8032008487","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803200848743070},10757.69,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},395,229.96,20.25,0,20,270.20999999999998,162.79,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":34.994500000000002},14.99,7.86,20.5,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":241.1345},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":29.075499999999977},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,157,"MS000MNA","MNA02","TACOS JALISCO","MS000MNAA1","8032019443","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803201944343070},4671.82,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},323,159.99,16.149999999999999,0,0,176.14,113.34,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":21.366999999999997},5.27,6.38,13,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":159.357},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":16.782999999999987},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,158,"MS000MNA","MNA02","CAFFE VERONA","MS000MNAA1","8032029665","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803202966543070},1866.91,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},43,58.83,2.2000000000000002,0,20,81.03,39.625,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":12.3325},0.87,0.8,113,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":166.6275},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-85.597499999999997},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,159,"MS000MNA","MNA02","EL AGAVE AZUL, RESTAURANT","MS000MNAA1","8032030135","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803203013543070},5518.01,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},105,100.83,0,0,220,320.83,95.83,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":61.041499999999999},1.61,1.86,233,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":393.3415},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":-72.511500000000012},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,160,"MS000MNA","MNA01","VANCOUVER WINGS","MS000MNAA1","8032045620","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803204562043070},5992.19,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":"Operado"},255,146.44,20.72,0,107.96,275.12,122.2,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":44.34},11.62,5.0199999999999996,22.5,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":205.68000000000004},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":69.439999999999969},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,161,"MS000MNA","MNA02","XPRESS IMAGING SOLUTIONS","MS000MNAA1","8032078738","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803207873843070},0.01,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},1,0.28999999999999998,0.05,0,20,20.34,0.24,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":5.0370000000000008},0.04,0.02,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":5.3370000000000006},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":15.003},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,162,"MS000MNA","MNA01","CACTUS MEXICAN CUISINE","MS000MNAA1","8032100359","201712 DEC",{"$f":"IF(DataColl[[#This Row],[Period]]<>\"\",DATE(LEFT(DataColl[[#This Row],[Period]],4),MID(DataColl[[#This Row],[Period]],5,2),1),\"\")","v":"2017-12-01"},{"$f":"(DataColl[[#This Row],[MID]]*100000)+DataColl[[#This Row],[Period_]]","v":803210035943070},0,{"$f":"IF(DataColl[[#This Row],[Net\nVolume]]<1,0,\"Operado\")","v":0},0,0,0,0,0,0,0,{"$f":"IF(DataColl[[#This Row],[Error]]<>\"X\",((DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[DiscExp]])*VALUE(MID(DataColl[[#Headers],[MNA20%]],4,3)))+(DataColl[[#This Row],[GrossRev]]*0.05),0)","v":0},0,0,0,{"$f":"SUM(DataColl[[#This Row],[DiscExp]:[Tot\nMiscExp]])","v":0},{"$f":"DataColl[[#This Row],[GrossRev]]-DataColl[[#This Row],[GrossExp]]","v":0},{"$f":"IF(DataColl[[#This Row],[Error]]=\"X\",DataColl[[#This Row],[TotResidual\nEarnings]],0)","v":0}]
[null,null,"Total","TOTAL",null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,DataColl[Net\nVolume])","v":2082957.0599999996},null,{"$f":"SUBTOTAL(109,DataColl[NetNo])","v":65880},{"$f":"SUBTOTAL(109,DataColl[Tot\nDiscIncome])","v":65909.660000000018},{"$f":"SUBTOTAL(109,DataColl[Tot\nAuthRev])","v":6846.5700000000006},{"$f":"SUBTOTAL(109,DataColl[Tot\nProcRev])","v":4996.33},{"$f":"SUBTOTAL(109,DataColl[Tot\nMiscRev])","v":9021.0699999999924},{"$f":"SUBTOTAL(109,DataColl[GrossRev])","v":86773.63},{"$f":"SUBTOTAL(109,DataColl[DiscExp])","v":35814.205000000009},{"$f":"SUBTOTAL(109,DataColl[MNA20%])","v":11322.529500000002},{"$f":"SUBTOTAL(109,DataColl[Tot\nAuthExp])","v":1960.6699999999987},{"$f":"SUBTOTAL(109,DataColl[Tot\nProcExp])","v":4644.59},{"$f":"SUBTOTAL(109,DataColl[Tot\nMiscExp])","v":8162.6599999999962},{"$f":"SUBTOTAL(109,DataColl[GrossExp])","v":61904.654500000019},{"$f":"SUBTOTAL(109,DataColl[TotResidual\nEarnings])-DataColl[[#Totals],[TotResEarn_Err]]","v":12130.4755},{"$f":"SUBTOTAL(109,DataColl[TotResEarn_Err])","v":12738.5}]

{"sheet":"MNA Datagrid view","index":1,"n_rows":7,"n_cols":21,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Partner","DBA","Portfolio","MID","Period ","Net\nVolume","NetNo","Tot\nDiscIncome","Tot\nAuthRev","Tot\nProcRev","Tot\nMiscRev","GrossRev","DiscExp","MNA20%","Tot\nAuthExp","Tot\nProcExp","Tot\nMiscExp","GrossExp","TotResidual\nEarnings"]
[]
[null,null,"Total",null,null,null,null,{"$f":"SUBTOTAL(109,DataView[Net\nVolume])","v":0},{"$f":"SUBTOTAL(109,DataView[NetNo])","v":0},{"$f":"SUBTOTAL(109,DataView[Tot\nDiscIncome])","v":0},{"$f":"SUBTOTAL(109,DataView[Tot\nAuthRev])","v":0},{"$f":"SUBTOTAL(109,DataView[Tot\nProcRev])","v":0},{"$f":"SUBTOTAL(109,DataView[Tot\nMiscRev])","v":0},{"$f":"SUBTOTAL(109,DataView[GrossRev])","v":0},{"$f":"SUBTOTAL(109,DataView[DiscExp])","v":0},{"$f":"SUBTOTAL(109,DataView[MNA20%])","v":0},{"$f":"SUBTOTAL(109,DataView[Tot\nAuthExp])","v":0},{"$f":"SUBTOTAL(109,DataView[Tot\nProcExp])","v":0},{"$f":"SUBTOTAL(109,DataView[Tot\nMiscExp])","v":0},{"$f":"SUBTOTAL(109,DataView[GrossExp])","v":0},{"$f":"SUBTOTAL(109,DataView[TotResidual\nEarnings])","v":0}]