{"triggers":[],"nodes":[{"uid":"d73d12cb-ab73-4a01-b2eb-133525585a42","commandName":"OpenSpreadsheet","packageName":"Excel_MS","disabled":false,"attributes":[{"name":"filePath","value":{"type":"FILE","string":"file:///C:/temp/Profit%20Calculation/supermarket_sales.xlsx"}},{"name":"isSpecificSheet","value":{"type":"BOOLEAN","boolean":true}},{"name":"sheetName","value":{"type":"STRING","string":"SalesData"}},{"name":"fileAccessMode","value":{"type":"STRING","string":"EDIT"}},{"name":"isSecure","value":{"type":"BOOLEAN","boolean":false}},{"name":"containsHeader","value":{"type":"BOOLEAN","boolean":false}},{"name":"loadAddIns","value":{"type":"BOOLEAN","boolean":false}},{"name":"session","value":{"type":"STRING","string":"Default"}}]},{"uid":"c3bc810a-17ea-46ff-ad18-86965e0dc79c","commandName":"InsertDeleteRowColumn","packageName":"Excel_MS","disabled":false,"attributes":[{"name":"rowOperationsRequested","value":{"type":"STRING","string":"false"}},{"name":"insertColumnSelected","value":{"type":"STRING","string":"true"}},{"name":"insertColumnNumber","value":{"type":"STRING","string":"J"}},{"name":"session","value":{"type":"SESSION","sessionName":{"type":"STRING","string":"Default"}}}]},{"uid":"0ce2a269-72da-4b10-81fa-0c1506ac09d4","commandName":"SetCell","packageName":"Excel_MS","disabled":false,"attributes":[{"name":"cellOption","value":{"type":"STRING","string":"SPECIFIC_CELL"}},{"name":"cell","value":{"type":"STRING","string":"J1"}},{"name":"value","value":{"type":"STRING","string":"Margins in  percentage"}},{"name":"session","value":{"type":"SESSION","sessionName":{"type":"STRING","string":"Default"}}}]},{"uid":"12c988b9-40ba-406a-bed7-a317732e60ba","commandName":"InsertDeleteRowColumn","packageName":"Excel_MS","disabled":false,"attributes":[{"name":"rowOperationsRequested","value":{"type":"STRING","string":"false"}},{"name":"insertColumnSelected","value":{"type":"STRING","string":"true"}},{"name":"insertColumnNumber","value":{"type":"STRING","string":"K"}},{"name":"session","value":{"type":"SESSION","sessionName":{"type":"STRING","string":"Default"}}}]},{"uid":"2c408a36-8169-46b5-97fc-b84f7d2ef2d2","commandName":"SetCell","packageName":"Excel_MS","disabled":false,"attributes":[{"name":"cellOption","value":{"type":"STRING","string":"SPECIFIC_CELL"}},{"name":"cell","value":{"type":"STRING","string":"K1"}},{"name":"value","value":{"type":"STRING","string":"Profit"}},{"name":"session","value":{"type":"SESSION","sessionName":{"type":"STRING","string":"Default"}}}]},{"uid":"1b2b57c1-5a9f-4d9a-8151-7bf9bcf7a4e2","commandName":"getNumberOfRows","packageName":"Excel_MS","disabled":false,"attributes":[{"name":"sheetOption","value":{"type":"STRING","string":"BYINDEX"}},{"name":"sheetIndex","value":{"type":"NUMBER","number":"1"}},{"name":"fetchRowsType","value":{"type":"STRING","string":"NONEMPTY"}},{"name":"session","value":{"type":"SESSION","sessionName":{"type":"STRING","string":"Default"}}}],"returnTo":{"type":"VARIABLE","variableName":"nRowCount"}},{"uid":"d22255bb-037e-4f94-ac85-e5d70932cfd9","commandName":"loop.commands.start","packageName":"Loop","disabled":false,"children":[{"uid":"66ab76d7-f6d0-485a-befc-233c53238a7c","commandName":"toString","packageName":"Number","disabled":false,"attributes":[{"name":"input","value":{"type":"NUMBER","expression":"$nCount$"}},{"name":"numFormatDigits","value":{"type":"NUMBER","number":"0"}}],"returnTo":{"type":"VARIABLE","variableName":"sCount"}},{"uid":"20d6d543-45a4-4465-b5b7-52b8fe01ca78","commandName":"SetCellFormula","packageName":"Excel_MS","disabled":false,"attributes":[{"name":"activeCell","value":{"type":"STRING","string":"false"}},{"name":"cellAddress","value":{"type":"STRING","expression":"J$sCount$"}},{"name":"cellFormulaToApply","value":{"type":"STRING","expression":"=VLOOKUP(E$sCount$,Profit!A2:B7,2,FALSE)"}},{"name":"session","value":{"type":"SESSION","sessionName":{"type":"STRING","string":"Default"}}}]},{"uid":"9343b669-de70-4cec-aef7-acecec611a52","commandName":"SetCellFormula","packageName":"Excel_MS","disabled":false,"attributes":[{"name":"activeCell","value":{"type":"STRING","string":"false"}},{"name":"cellAddress","value":{"type":"STRING","expression":"K$sCount$"}},{"name":"cellFormulaToApply","value":{"type":"STRING","expression":"=I$sCount$*J$sCount$/100"}},{"name":"session","value":{"type":"SESSION","sessionName":{"type":"STRING","string":"Default"}}}]},{"uid":"d0a24555-a0e2-474c-a790-e0a471d4f147","commandName":"increment","packageName":"Number","disabled":false,"attributes":[{"name":"source","value":{"type":"NUMBER","expression":"$nCount$"}},{"name":"by","value":{"type":"NUMBER","number":"1"}}],"returnTo":{"type":"VARIABLE","variableName":"nCount"}}],"attributes":[{"name":"loopType","value":{"type":"STRING","string":"ITERATOR"}},{"name":"iterator","returnTo":{"type":"VARIABLE","variableName":"rCurrentRow"},"attributes":[{"name":"loopSelection","value":{"type":"STRING","string":"SPECIFIC_ROWS"}},{"name":"fromRow","value":{"type":"NUMBER","number":"2"}},{"name":"toRow","value":{"type":"NUMBER","number":"101"}},{"name":"readOption","value":{"type":"STRING","string":"READ_CELL_VALUE"}},{"name":"readOption_readCellValue_Help","value":{"type":"STRING"}},{"name":"session","value":{"type":"SESSION","sessionName":{"type":"STRING","string":"Default"}}}],"value":{"type":"ITERATOR","iteratorName":"loop.iterators.excel","packageName":"Excel_MS"}}]},{"uid":"2f8337fc-f290-41d6-a25b-a45561f21e0a","commandName":"HideRowsColumnsInSelection","packageName":"Excel_MS","disabled":false,"attributes":[{"name":"hideRowsSelected","value":{"type":"STRING","string":"false"}},{"name":"colsRange","value":{"type":"STRING","string":"J:J"}},{"name":"session","value":{"type":"SESSION","sessionName":{"type":"STRING","string":"Default"}}}]},{"uid":"461dd543-5a74-4ebe-8228-65a9fc2e142f","commandName":"ProtectWorkbook","packageName":"Excel_MS","disabled":false,"attributes":[{"name":"isProtectWorkbook","value":{"type":"BOOLEAN","boolean":true}},{"name":"password","value":{"type":"CREDENTIAL","expression":"$cPassword$"}},{"name":"isProtectWorkbookStructure","value":{"type":"BOOLEAN","boolean":false}},{"name":"session","value":{"type":"SESSION","sessionName":{"type":"STRING","string":"Default"}}}]},{"uid":"ccd6ad2b-47f0-4326-a88d-faaf384993c8","commandName":"CloseSpreadsheet","packageName":"Excel_MS","disabled":false,"attributes":[{"name":"isSave","value":{"boolean":true,"type":"BOOLEAN"}},{"name":"session","value":{"sessionName":{"string":"Default","type":"STRING"},"type":"SESSION"}}]}],"variables":[{"name":"prompt-assignment","description":"A variable you can use for assignments","type":"STRING","subtype":"UNDEFINED","readOnly":false,"input":false,"output":false},{"name":"rCurrentRow","description":"","type":"RECORD","readOnly":false,"input":false,"output":false,"subtype":"UNDEFINED","defaultValue":{"type":"RECORD","record":{"schema":[],"values":[]}}},{"name":"sCount","description":"","type":"STRING","readOnly":false,"input":false,"output":false,"defaultValue":{"type":"STRING","string":""}},{"name":"nCount","description":"","type":"NUMBER","readOnly":false,"input":false,"output":false,"defaultValue":{"type":"NUMBER","number":"2"}},{"name":"SAM","description":"","type":"STRING","readOnly":false,"input":false,"output":false,"defaultValue":{"type":"STRING","string":"25"}},{"name":"sLineEfficiency","description":"","type":"STRING","readOnly":false,"input":false,"output":false,"defaultValue":{"type":"STRING","string":""}},{"name":"nLineEfficiency","description":"","type":"NUMBER","readOnly":false,"input":false,"output":false,"defaultValue":{"type":"NUMBER","number":"0"}},{"name":"sCity","description":"","type":"STRING","readOnly":false,"input":false,"output":false,"subtype":"UNDEFINED","defaultValue":{"type":"STRING","string":""}},{"name":"sCurrentValue","description":"","type":"ANY","readOnly":false,"input":false,"output":false,"subtype":"UNDEFINED","defaultValue":{"type":"STRING","string":""}},{"name":"lRow","description":"","type":"LIST","readOnly":false,"input":false,"output":false,"subtype":"STRING","defaultValue":{"type":"LIST","list":[]}},{"name":"cPassword","description":"","type":"CREDENTIAL","readOnly":false,"input":false,"output":false,"defaultValue":{"type":"STRING","string":"LockExcel"}},{"name":"nRowCount","description":"","type":"NUMBER","readOnly":false,"input":false,"output":false,"subtype":"UNDEFINED","defaultValue":{"type":"NUMBER","number":"0"}}],"breakpoints":[],"packages":[{"name":"Excel_MS","version":"5.3.0-20201208-090251"},{"name":"Loop","version":"2.1.0-20201126-165429"},{"name":"Number","version":"2.1.0-20201126-165444"}],"workItemTemplateName":null}