{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Summary","Functional (JB rework)","Functional old","Sheet3","Technical evaluation","Integration and Testing","Functional","Cloud","Demonstration","Priority Ratings","Config","Concerns and Recommendations"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":27,"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":"Summary","index":0,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[11,0,11,3],[20,0,20,4],[21,0,21,4],[19,0,19,4],[12,0,12,3],[17,0,17,5],[18,0,18,4],[13,0,13,3],[14,0,14,3],[10,0,10,3],[3,1,3,3],[3,4,3,11],[5,0,5,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[9,0,9,3],[0,0,0,3],[0,4,0,13],[1,1,1,3],[1,4,1,13],[2,1,2,3],[2,4,2,13],[23,0,23,5],[24,0,24,5],[25,0,25,5],[26,0,26,5],[27,0,27,5],[29,1,29,2],[29,5,30,5],[30,0,33,0],[30,4,33,4],[34,0,34,1]]}
["Workflow specific - Intelligent Business Process Management Tool"]
["Tender Number:"]
["Tenderer:"]
["Evaluated by:"]
[]
["Important Notes: "]
["1. Please indicate location of answers to the criteria and where required answer yes or no. To be included in Comments tab per sheet."]
["2. The qualified solution service provider shall do a product demo of the proposed product to be presented to Eskom.  This is mandatory. "]
["3. \"Tenderer(s) to take note of the following key instructions - Please follow the structure of the technical evaluation sheet provided when responding to this enquiry."]
["4.  DO NOT just give YES/NO kind of response to the questions which require more details and information."]
["5. Provide full information to your answer(s) in line with the details of the question(s) in point.\" "]
["6. All submissions must be both soft copies and hard copies including this spreadsheet."]
["7. If the criteria in the Gatekeepers are not met, the tenderer will be disqualified."]
["8. Cloud hosting must be  within the borders of South Africa."]
["9. Eskom retains ownership of the data that Eskom stores, transmits, and/or creates with the cloud service provider."]
[]
["Evaluation on Elimination Criteria   "]
["If any of these criteria are not met, the tenderer will be disqualified."]
["Criteria (Gate Keepers)",null,null,null,null,"Met?"]
["Tenderer does have prior or past experience in implemention of Sales and Forecasting Tool and if the tool is operational in an active production environment.  Tenderer to provide evidence to that effect; e.g. letter of reference from one of their clients, etc.",null,null,null,null,"No"]
[null,null,null,null,null,{"$f":"IF(OR(F20=\"No\",ISBLANK(F20)),\"Disqualified\",\"Qualified\")","v":"Disqualified"}]
[]
[]
["Notes regarding Table Below"]
["The total for the RFP (Paper Exercise) evaluation is 100%"]
["The Demo will count 100%"]
["Weighting for Final score: 50% of the RFP will be added to 50% of the demo to get the final score "]
["Evaluation will take place in two stages, 1. Response evaluation, and 2. Product Demo evaluation. The responses will be evaluated and the threshold is 75%.  Only the service providers who manage to score 75% and above will qualify to be invited to the second leg, i.e. Product demo of the proposed product, to be presented to Eskom. Tenderers who do not pass with 100% for Stage 2 (Product Demo evaluation) will be disqualified and not be evaluated further"]
[]
["Stage","Weighting",null,"Total","RFP Total","Final Score\nRFP+Demo"]
["Technical","Functional",0.4,{"$f":"B42*C31","v":0},{"$f":"SUM(D31:D34)","v":0}]
[null,"Technial",0.15,{"$f":"B43*C32","v":0},null,{"$f":"(E31*0.5)+(D35*0.5)","v":0}]
[null,"integration and Testing",0.25,{"$f":"B45*C33","v":0}]
[null,"Cloud",0.2,{"$f":"B44*C34","v":0}]
["DEMO",null,1,{"$f":"B46","v":0}]
[]
[]
[]
["Evaluation on Weighted Criteria"]
[]
["Evaluation on Weighted Criteria"]
["Sum of Weighted Question (Functional)",{"$f":"Functional!N75","v":0}]
["Sum of Weighted Question (Technical)",{"$f":"'Technical evaluation'!M24","v":0}]
["Sum of Weighted Question (Cloud)",{"$f":"Cloud!M19","v":0}]
["Sum of Weighted Question (Integration and testing)",{"$f":"'Integration and Testing'!N32","v":0}]
["Sum of Weighted Question (Demo)",{"$f":"Demonstration!N45","v":0}]

{"sheet":"Functional (JB rework)","index":1,"n_rows":57,"n_cols":4,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
["#","Requirement Group","Requirement","Priority Description"]
[1,"Source data repository","Source data repository:\n- Provide a managed data repository for electricity sales forecasting related datasets.\ne.g. \n- Billing system - electricity sales and bills\n- Metering data aquistion system - interval reads\n- Finance system (SAP) - electricity sales (official income statement level electricity sales)\netc.\n\n- Aside: Source data not to be changed by the forecasting system.\n- Aside: Source data required should cover at least a 10 to 15 years of historical data"]
[2,"Source data repository","Source data repository - migrate historical data:\n- Ability to migrate data from the existing data warehouse, containing sales and forecasting datasets, into a new sales and forecasting source data repository.\n\nNote:\n- Eskom has an existing data warehouse used by the current forecasting system. "]
[3,"Source data repository","Source data repository - source / obtain current data:\n- Ability to provide automated bulk acquisition (via data pipelines etc.) of current sales and forecasting datasets from source systems to store in the new sales and forecasting source data repository."]
[4,"Source data repository","Source data repository - access:\n- Provide access to other users who need sales and forecasting related analystics i.e. no access to the forecasting system, but access to use reporting and data analytics."]
[5,"Electricity sales forecast","Electricity sales forecast - predictive analysis:\n- Abiltity to generate electricity sales forecasts based on historical actual data."]
[6,"Electricity sales forecast","Electricity sales forecast - adjustments:\n- Ability to apply adjust electricity sales forecasts by a factor or algorithm. For example: Adjust forecast for mining in a particular region by 10%.\n- Adjustments to be applied to any subset of data / dimension determined by the business."]
[7,"Electricity sales forecast","Electricity sales forecast - retention:\n- Ability to store previous electricity sales forecasts.\n- Provide audit trail e.g. when generated, by whom etc."]
[8,"Electricity sales forecast","Electricity sales forecast - rolling window:\n- Ability to draw on previous forecasts (based on actual historical data or forecasters inputs) e.g. drop years not applicable and add the years."]
[9,"Electricity sales forecast","Electricity sales forecast - multivariate analysis:\n- Abiltity to apply multivariate forecasting algorithms, allowing users to adjust the factors that influence electricity sales projections."]
[10,"Electricity sales forecast","Electricity sales forecast - custom statistical models:\n- Abiltity to create and apply custom statistical forecast models, allowing granular control over the forecasting approach. "]
[11,"Electricity sales forecast","Electricity sales forecast - level:\n- Ability to ensure that all forescasts are generated at the lowest level possible.\n\nNote: Lowest level = premise supply"]
[12,"Electricity sales forecast - Forecaster input","Electricity sales forecast - forecaster input:\n- Ability to capture budgets and forecasts at lowest level of variable (e.g. kwh sales, nmd, chargeable demands etc), tariff, customer and business category level and upload it in the system.\n  - e.g. anything not derived by forecastsing using historical actual data.\n- Ability to apply forecaster inputs in bulk e.g. for a certain types of customers.\n"]
[13,"Electricity sales forecast - Forecaster input","Electricity sales forecast - forecaster input (wrtite back):\nWrite back into system from external tools supporting forecast work e.g. Ms Excel addin:\n- If your solution relies on external tools such as Excel, does it allow direct bulk submission of external tool forecasts into the system. i.e. write back.\n\nAside: \n- Current forecasting tool → Forecasts are done in Excel and submitted into the system. Forecasts captured in predefined excel template. Writeback to the system when complete."]
[14,"Electricity sales forecast - Forecaster input","Electricity sales forecast - forecaster input (poke and peak):\n- Ability to adjust / override system generated forecasts that were based on historical data (predictive analysis). For example: adjust historical trends since customers may be moving to alternative suppplies."]
[15,"Electricity sales forecast - Forecaster input","Electricity sales forecast - forecaster input (bulk correction of forecast input errors):\n  Correct input errors in bulk e.g. clear incorrectly allocated budgets / forecasts and allocate to the correct area or customer grouping."]
[16,"Electricity sales forecast - Scenarios","Electricity sales forecast - scenario planning:\n- Ability to generate electricity sales forecasts based on business derived scenarios. \nFor example: copy budget as a base, scenario 1 - 8% increase, scenario 2 - 15% increase, scenario 2.1 - 15% increase and reduced sales for redistrbuters by 10%.\n\nXYZ • Actuals\n• Forecast\n• Load profile\n• Hour by hour MW and GWh\n• %\n• Revenue\n• Difference\n• Consumption vs Revenue\n"]
[17,"Electricity sales forecast - Scenarios","Electricity sales forecast - scenario planning:\n- Ability to easily compare electricity forescasts (and revenue expected) for business derived scenarios. "]
[18,"Electricity sales forecast - Scenarios","Electricity sales forecast - scenarios:\n- Abiltity to manage models and assumptions used for / based on / of electricity sales forecast scenarios."]
[19,"Electricity sales forecast - progress","Electricity sales forecast - progress:\n- Ability to view progress of electricity sales forecasts e.g. per business area or customer grouping."]
[20,"Electricity sales forecast - review","Electricity sales forecast - review:\n- Abiltity to review past electricity sales forecasts for acurracy, model fit and confidence."]
[21,"Electricity sales forecast - review","Electricity sales forecast - review:\n- Ability for submitted electricity sales forecasts to be adjusted during a review process and resubmitted with the changes. Changes submitted to reflect adjustments as applicable e.g. head office or regional ajustments."]
[22,"Electricity sales forecast - Variance reporting","Electricity sales forecast - variance reporting\n- Ability to capture reasons for variances / changes in forecasts e.g. actual, budget, variance and variance reason.\n- Allow a team leader to review reasons for variances / changes from regions and flag for final reporting. Team leader to flag variance reasons for use in national reporting.\n- Generate finalized electricity sales forecast reports with selected / flagged variance reasons."]
[23,"Revenue calculator","Revenue calculator:\n- Ability to calculate the revenue on electricity sales budgets / forecasts, corporate plans and MYPD submissions based applicable tariffs (NERSA approved tarrifs or internal tarif proposals).\n  - Note: customers may be linked to different rates depending on the time of year (season) or time of use."]
[24,"Revenue calculator","Revenue calculator - choose tariffs to use:\n- Ability to select tariffs to use for revenue calculations e.g. new time of use ratios or internal tariff proposals."]
[25,"Revenue calculator","Revenue calculator - negotiated pricing agreements:\n- Ability to create and apply negotiated pricing agreements. \nFor example: customers within a specfic industry allowed to use 50% of their power at a special price."]
[26,"Revenue calculator - pro rata","Revenue calculator - pro rata:\n- Ability to calculate pro rata revenues during periods when tariffs change e.g. April annual increase for non munics, June annual increase for munics, seasonal changes etc."]
[27,"Revenue calculator - pro rata","Revenue calculator - pro rata:\n- Ability to calculate pro rata revenues for any business defined dimensions e.g. business areas, munic, customer types, tariffs, date / time etc."]
[28,"Revenue calculator - TOU repack","Revenue calculator - time of use repack:\n- Ability to recalculate forecasted revenues based on new time of use ratios e.g. move morning peak from 06:00 to 08:30 on weekdays to 05:30 to 08:30 on weekdays.\n- Ability to calculate TOU repack customer impact to prove that customers are not negatively impacted i.e. compare original budget / forecast vs budget /forecast after TOU repack."]
[29,"Revenue calculator - scenarios","Revenue calculator - scenarios:\n- Ability to calculate revenues for multiple scenarios, e.g. internal vs NERSA tariffs, for comparative analysis."]
[30,"Revenue calculator - scenarios","Revenue calculator - scenarios:\n- Ability to calculate the impact on revenue based on business derived scenarios e.g. 12 hours on peak, 2 hours off peak what is the impact on revenue. "]
[31,"Security / privacy","Security / privacy and information sensitivity:\n- Create user profiles and grant various levels of access per user profile."]
[32,"Security / privacy","Security / privacy and information sensitivity:\n- Grant various levels of access per system user."]
[33,"Security / privacy","Security / privacy and information sensitivity:\n- Ability to apply update rights to certain users or roles to allocated electricity sales forcasts for a given period.\n- Ability to lock certain electricity sales forecasts after a given date / time."]
[34,"Security / privacy","Security / privacy and information sensitivity:\n- Ability to apply granular access rights to source datasets and electricity sales forecasts e.g. access to certain sensitive datasets or electricity sales forecasts.\n- Ability to apply granular update rights for electricity sales forecasts per business area or customer grouping."]
[35,"Security / privacy","Security / privacy and information sensitivity:\n- Provide an audit trail of access i.e. who accessed what when.\n- Provide an audit trail of changes i.e. who  changed / added what when."]
[36,"Security / privacy","Security / privacy and information sensitivity:\n- Provide private workspaces for forecasters. \n- Allow forecasters to \"publish\" finalized electricity forecasts."]
[37,"Security / privacy","Security / privacy and information sensitivity:\n- Ability to classify datasets / electricity sales forecasts. \nExample: public, sensitive and private or business defined information classification levels."]
[38,"Integration","Integration to other systems:\n- Ability to receive and send data using defined integration paths e.g. receive SAP sales and send sales forcast budgets to SAP."]
[39,"Other","Use of tariffs from the billing system:\n- Automated transfer and use of the bill matrix (rates and other criteria) from the billing system.\n\nNote:\n- Current practice: The bill matrix is produced by the Pricing department. Forecasters manuallly lookup and apply bill matrix to forecasts."]
[40,"Other","External templates:\n- If external input templates, e.g. Excel, are used, autopopulate relevant data e.g. years / months etc. "]
[41,"Analytics / report / dashboards","Reporting / dashboards:\n- Ability to generate / view relevant reports / dashboards to view electricity sales forecasts and related information."]
[42,"Analytics / report / dashboards","Reporting / dashboards:\n- Ability to view (aggregated) electricity sales forecasts or source data for any given business dimension, e.g. business areas, customer types, tariffs, date / time etc, at any desired level of granularity e.g. date / time = months, customer type = large power users etc."]
[43,"Analytics / report / dashboards","Analytics - Slice and Dice:\n- Ability to slice-and-dice (segment) data based on various business defined dimensions e.g. business areas, customer types, tariffs, date / time etc."]
[44,"Analytics / report / dashboards","Dimensions:\n- Ability for source information or electricity sales forecasts to be aggregated to the various dimensions for analysis, to view in the application as well as reporting e.g. \n  1. Business area levels e.g. Eskom Dx business areas such as clusters (groups of operating units), operating units, zones, sectors and CNCs. \n  2. Mode e.g. budget, actual, projections, 12 month projections etc.\n  3. Date e.g. financial year, quarter, month etc.\n  4. Electricty tariffs\n  5. Individual customer\n  6. Customer classification e.g. Eskom large power users, small power users or prepaid\n  7. Voltage\n  8. Revenue class e.g. Industrial, mining, commercial etc.\n  9. Munic e.g. Munic and non-munic\n  10. Transmission zones\n  11. Standard industrial codes (SIC) e.g. 11110-GROWING OF CEREALS AND OTHER CROPS N.E.C.\n  12. Major Transmission Stations (MTS)\n  etc."]
[45,"Analytics / report / dashboards","Electricity sales actuals / forecast trends:\n- Ability to view or analyze historical electricity sales actuals / forecasting  trends."]
[46,"Analytics / report / dashboards","Electricity sales forecast benchmark comparisons:\n- Ability to compare electricity sales forecasts to internal / industry benchmarks."]
[47,"Analytics / report / dashboards","Self-service:\n- Ability for end users to generate reports / analyse available data themselves i.e. analyze and visualize data themselves without the need for IT or data analytics specialists."]
[48,"Analytics / report / dashboards","Report cube partitioning:\n- Ability to partition reporting cubes."]
[49,"Analytics / report / dashboards","Report cube partitioning:\n- Ability to migrate data between reporting cubes. "]
[50,"Admin - configuration","Tariff catalogue maintenance:\n- Ability to flag approved tariffs or tariff types e.g. NERSA appoved or internal proposals."]
[51,"Admin - configuration","Allow user driven configuration of system:\n- Ability for business super user to maintain system catalogues, hierarchies etc. \nExample: Add new new tariffs, tariff rules, customer types.\n"]
[52,"Vashna","XYZ Quantify customer response = change in usage pattern XYZ Varshna …"]
[53,"Vashna","XYZ TOU customer profiling -  e.g. MV90?? XYZ Varshna …"]
[54,"Vashna","XYZ TOU Profiling + Analytics → Varshna"]
[55,"Vashna","XYZ all the rest of the TOU reqirements"]
[56,"Analytics / report / dashboards","Missing data / data gaps:\n- Ability generate reports indicating missing data or gaps in data based on given business criteria.\n- XYZ … Suppress results not applicable to paticular business dimension e.g. tariffs shown against incorrect class of customer.  "]

{"sheet":"Functional old","index":2,"n_rows":89,"n_cols":13,"rows_kept":89,"cut":false,"hidden":true,"merged":[[87,0,87,12],[6,10,6,12],[2,0,2,1],[3,0,3,1],[5,0,5,2],[6,8,6,9]]}
["Sales and Forecasting Tracking Tool",null,null," ",null," "]
["Tender Number:",null," MWP1173CX\t"," ",null," "]
["Tenderer:",null," "," ",null," "]
["Evaluated by:",null," "," ",null," "]
[]
["Evaluation Criteria",null,null," ",null," "]
[null,null," "," "," "," ",null," ","Weight\n(agreed by evaluation team members)",null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)"]
["ID","Type","Criterion","Solution","Functional Requirement","Requirement description","Comments","Priority Description","Priority","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
["BRS1","Meeting the Scope of Work Required","The tool should be able to generate forecast summaries/reports that can spot issues like missing or outdated data ad fill gaps to improve accuracy across the board ","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS2","Meeting the Scope of Work Required","A revenue calculator that can calculate revenue based on price changes","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS3","Meeting the Scope of Work Required","Ability to slice forecast to enter multiple regions, line of business, products, or any other way the business can be segmented","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS4","Meeting the Scope of Work Required","Ability to pull historical sales data from any time period in order to make the sales forecasting more trustworthy","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Important",3,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS5","Meeting the Scope of Work Required","Contain future forecasts","Sales and Forecasting Tracking Tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Critical",5,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS6","Meeting the Scope of Work Required"," Enable the forecasters to analyse historical trends in performance as well as future trends","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS7","Meeting the Scope of Work Required","Sales forecast benchmarking: forecast sales and compare to industry trends","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS8","Meeting the Scope of Work Required","Quick forecasts through dashboards and reporting: a quick overview of sales forecasts","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS9","Meeting the Scope of Work Required","Sales forecast visuals: clear and helpful visuals","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS10","Meeting the Scope of Work Required","Sales forecasting factors: multivariate forecasting algorithms and queries that allow users to adjust the factors that influence projections and generate results from these queries ","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS11","Meeting the Scope of Work Required","Sales forecast review: track forecast accuracy/model fit and confidence","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS12","Meeting the Scope of Work Required","Sales forecasting management: ability to manage models and assumptions based on forecast reviews","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS13","Meeting the Scope of Work Required","Custom forecast models: allows for granular control over the forecasting approach","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS14","Meeting the Scope of Work Required","Record of previous sales forecasts and audit trail","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS15","Meeting the Scope of Work Required","10 year history, 15 year future with easy expansion","Sales and revenue tracking tool","Core Features","Does it have this capability? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS16","Meeting the Scope of Work Required"," Security and privacy must be able to be assigned and controlled closely given the sensitivity of the data","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS17","Meeting the Scope of Work Required","Does the tool have Statistical modelling capabilities","Sales and revenue tracking tool","Core Features","Can the tool do statistical modelling? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS18","Meeting the Scope of Work Required","User driven outline changes – no 3rd party work. Forecasters should be able to adapt easily to produce outputs as needed to minimise dependency on 3rd parties. ","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS19","Meeting the Scope of Work Required","User driven outline changes – no 3rd party work. Forecasters should be able to adapt easily to produce outputs as needed to minimise dependency on 3rd parties. ","Sales and revenue tracking tool","Core Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS20","Meeting the Scope of Work Required","The abilty to perform Predictive analysis","Sales and revenue tracking tool","Distinctive Features","Explain how Predictive analysis can be achieved"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS21","Meeting the Scope of Work Required","Write back to sales tool (submit a completed spreadsheet back into the system)","Sales and revenue tracking tool","Distinctive Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS22","Meeting the Scope of Work Required","Does the tool have an Excel add in","Sales and revenue tracking tool","Distinctive Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS23","Meeting the Scope of Work Required","Can the tool do Scenario planning","Sales and revenue tracking tool","Distinctive Features","Explain how Scenario Planning can be achieved"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS24","Meeting the Scope of Work Required","Does the tool have Slice and dice capabilities","Sales and revenue tracking tool","Distinctive Features","Explain how Slice and Dice Planning can be achieved"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
["BRS25","Meeting the Scope of Work Required","Peak and poke (modify and send into sales tool)","Sales and revenue tracking tool","Distinctive Features","Does it have this requirement? Explain how this requirement is realised"," ","Very important",4,{"$error":"#DIV/0!"},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"," ",{"$error":"#DIV/0!"}]
[" "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,null,null,null,null,null," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "]
[null,null,null,null,null,null,null,null," "," ",null,null," "]

{"sheet":"Sheet3","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,null,"Test"]
[null,null,null,null,1]
[null,null,null,null,2]
[null,null,null,null,3]
[null,null,null,null,4]
[null,null,null,null,5]

{"sheet":"Technical evaluation","index":4,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[6,10,6,12],[6,8,6,9],[0,0,0,3],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,0,5,3]]}
["Workflow specific - Intelligent Business Process Management Tool"]
["Tender Number:"]
["Tenderer:"]
["Evaluated by:"]
[]
["Evaluation Criteria"]
[null,null,null,null,null,null,null,null,"Weight\n(agreed by evaluation team members)",null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)"]
["ID","Type","Solution","Criterion","Functional Requirement","Requirement description","Comments","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Compatibility Certificate from Microsoft AD or Azure","Information Security","Access Control and User Account Management (Technical Support Team)\n\nIs your Proposed Solution comply and Compatible with Microsoft Active Directory and or Azure",null,"Very important",{"$f":"IF(H9='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H9='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H9='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H9='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H9='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H9='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H9='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I9/I24","v":7.2727272727272724E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,{"$f":"J9*L9","v":0}]
[2,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Certificate from the OEM or Reputable Authority ","Information Security","Information Security Threat Management \n\nPlease advise to what extend is your Solution Compatible \n1. Malware\n2. Cyber Attack\n3. Anti-Virus\n",null,"Very important",{"$f":"IF(H10='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H10='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H10='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H10='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H10='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H10='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H10='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I10/I24","v":7.2727272727272724E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[3,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Substantiate by providing details of standards that are supported and ensure that these Capabilities are detailed in the proposal","Information Security","User and System to System Authentication \n\nWhat Authentication Tools or Model will be deployed as part of the proposed solution, this should include compatibility with Java Authentication and Authorisation Service (JAAS), LDAP, OASIS SAML v2.0, Open SSO TLS and WSS, OAUTH.",null,"Very important",{"$f":"IF(H11='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H11='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H11='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H11='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H11='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H11='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H11='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I11/I24","v":7.2727272727272724E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[4,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","What type of channel security does Source Application support, i.e. One-Way or Two-Way certificate (SSL/TLS) to secure the channel?","Information Security - Integration","Provide the security capability, for the communication between the Application business service and Integration middleware",null,"Very important",{"$f":"IF(H12='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H12='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H12='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H12='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H12='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H12='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H12='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I12/I24","v":7.2727272727272724E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[5,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","What type of authentication security does Source support, i.e. Basic Authentication for Web Services, Database or SFTP?","Information Security - Integration","Provide the Authentication capability,  for the communication between the Application business service and Integration middleware",null,"Very important",{"$f":"IF(H13='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H13='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H13='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H13='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H13='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H13='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H13='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I13/I24","v":7.2727272727272724E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,{"$f":"J13*L13","v":0}]
[6,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Substantiate by providing details of standards that are supported and ensure that these Capabilities are detailed in the proposal","Information Security","End to end encryption of messages at rest and transit. Logs etc.",null,"Very important",{"$f":"IF(H14='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H14='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H14='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H14='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H14='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H14='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H14='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I14/I24","v":7.2727272727272724E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[7,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Please provide us with a Sample of the Report (Unmodified)","Audit Trail","Monitoring and Reporting \n\nDoes the proposed solution provide Audit trail in terms of :\nLogs that support recording user activities\nSystem faults, exceptions, and \nInformation security events that are kept for an agreed period to assist in future investigations and access control monitoring.",null,"Important",{"$f":"IF(H15='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H15='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H15='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H15='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H15='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H15='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H15='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"I15/I24","v":5.4545454545454543E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,{"$f":"J15*L15","v":0}]
[8,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Network Security and 3rd Party Access","Network Deployment","How would the proposed solution protect Data and Facilitate 3rd Party Access, please specify the tools if any \nAlso for provision of support.\nHow is the access to the data managed.Manage access to backend systems to address possible access to information to unauthorised people.",null,"Very important",{"$f":"IF(H16='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H16='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H16='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H16='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H16='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H16='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H16='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I16/I24","v":7.2727272727272724E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,{"$f":"J16*L16","v":0}]
[9,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Near realtime response times below 3 seconds, network performance certificate as proof. ","Network Deployment","Network Optimizing \n\nPlease advise how the Network will be optimised to cater for the near real time transaction performance, please advise on the Network shaping tools you will deploy (if any) and performance of the solution over the cloud network.\nWhat monitoring provided outside of Eskom network",null,"Very important",{"$f":"IF(H17='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H17='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H17='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H17='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H17='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H17='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H17='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I17/I24","v":7.2727272727272724E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,{"$f":"J17*L17","v":0}]
[10,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Business Continuity plan & Maintenance Plan","Maintenance/ Availability","What is your Planned maintenance policy to ensure high availability.\nWill there be expected downtime. Service interuptions during changes/upgrades? \nIs there a Business Continuity (DR)\nIf the main site is down, will there be a recovery / backup site.\n\n",null,"Important",{"$f":"IF(H18='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H18='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H18='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H18='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H18='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H18='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H18='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"I18/I24","v":5.4545454545454543E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[11,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Scalability \nBidder to provide Detail Design that comprises the full set of functional and non-functional elements.","Core Infrastructure","Scalability \n\nPlease advise how scalable is the proposed solution in terms of deployment methodology\nAbilty to add more resources to scale\n",null,"Important",{"$f":"IF(H19='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H19='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H19='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H19='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H19='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H19='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H19='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"I19/I24","v":5.4545454545454543E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[12,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Flexibility","Core Infrastructure","Mechanism for flexible deployment. Should not be restricted i.e. Changes only allowed donce a month. \nIf integration is down, fucntionality to report faults is down. Ability/flexibility  to quickly respond and inform customers accordingly.",null,"Important",{"$f":"IF(H20='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H20='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H20='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H20='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H20='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H20='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H20='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"I20/I24","v":5.4545454545454543E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[13,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Demonstrate how High Availability  will be achieved for your proposed Solution ","Core Infrastructure","High Availability Configuration \n\nIndicate how the Solution is Configurable for High Availability, with a Business Requirement of 98% uptime  \nHigh Availability Design – Hot Standby. Please describe and provide the proposed High Availability Deployment Design",null,"Important",{"$f":"IF(H21='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H21='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H21='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H21='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H21='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H21='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H21='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"I21/I24","v":5.4545454545454543E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[14,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","End Point Devices access","Core Infrastructure","If this Solution is to be accessed by the End Point Devices(i.e. Laptops and Desktops), please advise if the Solution is accessable  via the Approved minimum Internet Browser(s) . Indicate the technologies available.",null,"Very important",{"$f":"IF(H22='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H22='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H22='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H22='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H22='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H22='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H22='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I22/I24","v":7.2727272727272724E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[15,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Please provide the details of the DR Solution outlining the RTO and RPO for each option","Business Continuity","Disaster Recovery (DR)\nDoes the Proposed Solution Cater for Cold , Warm or Hot Standby\nIndicate any performance issues",null,"Very important",{"$f":"IF(H23='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H23='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H23='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H23='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H23='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H23='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H23='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I23/I24","v":7.2727272727272724E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I9:I23)","v":55},{"$f":"SUM(J9:J23)","v":1.0000000000000002},null,null,{"$f":"SUM(M9:M23)","v":0}]

{"sheet":"Integration and Testing","index":5,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[6,11,6,13],[0,0,0,3],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,0,5,3],[6,9,6,10]]}
[{"$f":"'Technical evaluation'!A1","v":"Workflow specific - Intelligent Business Process Management Tool"}]
["Tender Number:"]
["Tenderer:"]
["Evaluated by:"]
[]
["Evaluation Criteria"]
[null,null,null,null,null,null,null,null,null,"Weight\n(agreed by evaluation team members)",null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)"]
["ID","Type","Category","Criterion","Solution","Functional Requirement","Requirement description","Comments","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Team Organisation and Member Requirements","Non Functional","Previous involvement in the end to end testing of a similar system and methodologies used)","Workflow specific - Intelligent Business Process Management Tool","Testing ","Provide reference customers and sites",null,"Very important",{"$f":"IF(I9='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I9='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I9='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I9='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I9='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I9='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I9='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J9/J$32","v":4.2553191489361701E-2},"100%: Fully comply with requirement\n50%:   Partially comply(Have experience but not a similar system)\n0%:     No experience",0,{"$f":"K9*M9","v":0}]
[2,"Team Organisation and Member Requirements","Non Functional","Resource model. It is a requirement that sufficient dedicated testers are allocated the project, independent of the development team. Team members have the required ISTQB testing certifications (Provide Certifications of team members)","Workflow specific - Intelligent Business Process Management Tool","Testing ","Experienced Test Manger must be provided",null,"Very important",{"$f":"IF(I10='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I10='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I10='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I10='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I10='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I10='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I10='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J10/J$32","v":4.2553191489361701E-2},"100%: > 5 years experienced Testmanager provided\n50%: between 2 and 5 years exeperience\n0%: < 2 yearsexperience",0,{"$f":"K10*M10","v":0}]
[3,"Meeting the Scope of Work Required","Non Functional","Resource Experience with Eskoms Testing tools","Workflow specific - Intelligent Business Process Management Tool","Testing ","Must be HP ALM, UFT and Load Runner ",null,"Very important",{"$f":"IF(I11='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I11='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I11='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I11='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I11='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I11='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I11='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},4.2553191489361701E-2,"100%: 5 years experience on one of the tools\n50%: between 2 and 5 years exeperience \n0%: < 2 yearsexperience",0,0]
[4,"Meeting the Scope of Work Required","Non Functional","Your testing approach specific to the project. (  Agile/Waterfall) etc..","Workflow specific - Intelligent Business Process Management Tool","Testing ","Tenderer must provide approach",null,"Very important",{"$f":"IF(I12='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I12='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I12='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I12='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I12='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I12='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I12='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},4.2553191489361701E-2,"100%: Complete approach provided with reference to a methodology\n50%:  Approach provided with no reference to a methodology\n0%:  No approach provided",0,0]
[5,"Meeting the Scope of Work Required","Non Functional","Tenderer's proposed testing resources must have the required ISTQB(International Software Testing Qualifications Board) qualifications acrredited by SATQB(Southern African Software Testing Qualifications Board).  Provide Certificates of resources. Evidence required: CV's together with respective copies of acquired certificates. ","Workflow specific - Intelligent Business Process Management Tool","Testing "," CV's together with respective copies of acquired certificates.\n\n",null,"Very important",{"$f":"IF(I13='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I13='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I13='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I13='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I13='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I13='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I13='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},4.2553191489361701E-2,"100%: Fully comply with requirement- 2 or more certificate\n50%:   Partially comply- 1 certificate\n0%:     No compliance-No certificate",0,0]
[6,"Team Organisation and Member Requirements","Non Functional","Solid Testing capability (reference projects & sites and methodologies used)","Workflow specific - Intelligent Business Process Management Tool","Testing ","Resource model. It is a requirement that vendor have sufficient dedicated testers allocated to the project independent of the development team. ",null,"Very important",{"$f":"IF(I14='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I14='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I14='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I14='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I14='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I14='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I14='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},4.2553191489361701E-2,"100%:Fully comply with requirement\n50%:  Capability shown but no refence to sites \n0%:  No experience",0,0]
[7,"Meeting the Scope of Work Required","Non Functional","Previous experience in implementation of Oracle Fusion Integration solutions in a enterprise ","Workflow specific - Intelligent Business Process Management Tool","Integration","Tenderer must provide references, sites and patterns or Previous Experience",null,"Show stopper",{"$f":"IF(I15='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I15='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I15='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I15='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I15='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I15='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I15='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":6},6.3829787234042548E-2,"100%: Experience in Oracle Fusion Implementation\n0%: No experience in Oracle Fusion",0,0]
[8,"Meeting the Scope of Work Required","Non Functional","Previous experience in implementation of Datapower integration solutions in a enterprise ","Workflow specific - Intelligent Business Process Management Tool","Integration","Tenderer must provide references, sites and patterns or Previous Experience",null,"Show stopper",{"$f":"IF(I16='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I16='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I16='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I16='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I16='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I16='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I16='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":6},6.3829787234042548E-2,"100%: Good Experience in Data Power Implementation\n0%: No experience in Data Power Implementation",0,0]
[9,"Meeting the Scope of Work Required","Non Functional","Team has the required certifications for Oracle Fusion 12C","Workflow specific - Intelligent Business Process Management Tool","Integration","(Provide Certificate) acquired through permanent resources or partnership. Capability of at least 1 senior certified resource must have working experience in the technology?",null,"Very important",{"$f":"IF(I17='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I17='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I17='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I17='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I17='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I17='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I17='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},4.2553191489361701E-2,"100%: Good Experience with certification\n50%: Certification without experience\n0%: No experience, No certification",0,0]
[10,"Meeting the Scope of Work Required","Non Functional","Team has the required certifications IBM Data Power","Workflow specific - Intelligent Business Process Management Tool","Integration","(Provide Certificate) acquired through permanent resources or partnership. Capability of at least 1 senior certified resource must have working experience in the technology?",null,"Very important",{"$f":"IF(I18='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I18='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I18='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I18='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I18='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I18='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I18='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},4.2553191489361701E-2,"100%: Good Experience with certification\n50%: Certification without experience\n0%: No experience, No certification",0,0]
[11,"Meeting the Scope of Work Required","Non Functional","Previous experence in carrying out analysis, design, development, testing and deployment of Oracle Fusion and Datapower integration services","Workflow specific - Intelligent Business Process Management Tool","Integration","Provide proof that you have implemented a solution where the following items were delivered: analysis, design, develop, test and deploy integration solutions. Provide references",null,"Show stopper",{"$f":"IF(I19='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I19='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I19='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I19='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I19='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I19='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I19='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":6},6.3829787234042548E-2,"100%: Experience in  analysis, design, development, testing and deployment of Oracle Fusion and Data Power\n50%: Experience in  analysis, design, development, testing and deployment of Oracle Fusion or Data Power\n0%: No experience",0,0]
[12,"Meeting the Scope of Work Required","Non Functional","Previous experience in implementation  of Oracle Fusion and DataPower integration solutions at enterprise level is required. Please provide references on experience by  the tenderer for both technologies. Tenderer must provide proof that their product has the ability to expose business services to enable integration capabilities. Evidence required - Provide name(s) of the companies where the solution was implemented together with contact persons & details.","Workflow specific - Intelligent Business Process Management Tool","Integration","Provide proof that you have implemented a solution where the following items were delivered: analysis, design, develop, test and deploy integration solutions. Provide references",null,"Very important",{"$f":"IF(I20='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I20='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I20='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I20='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I20='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I20='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I20='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},4.2553191489361701E-2,"100%: Experience in  analysis, design, development, testing and deployment of Oracle Fusion and Data Power\n50%: Experience in  analysis, design, development, testing and deployment of Oracle Fusion or Data Power\n0%: No experience",0,0]
[13,"Meeting the Scope of Work Required","Non Functional","What is the structure of the message? Is it a proprietary file, is it in a Database? If this information is PUSHED by Source, can the Source send to Integration a Common Information Message (CIM) or they can only send a proprietory message structure? (Proprietory – Applications own business service message structure)","Workflow specific - Intelligent Business Process Management Tool","Integration","Provide the capability of the Application",null,"Very important",{"$f":"IF(I21='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I21='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I21='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I21='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I21='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I21='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I21='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},4.2553191489361701E-2,"100%:Source can send a Common information message (CIM) structure\n50%: The Source can send only a proprietary message structure\n0%: Neither",0,0]
[14,"Meeting the Scope of Work Required","Non Functional","What type of channel security does Source Application support, i.e. One-Way or Two-Way certificate (SSL/TLS) to secure the channel?","Workflow specific - Intelligent Business Process Management Tool","Integration","Provide the security capability",null,"Very important",{"$f":"IF(I22='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I22='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I22='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I22='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I22='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I22='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I22='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J22/J$32","v":4.2553191489361701E-2},"100%:Source Supports a secure channel of communication\n0%: Source supports no secure channel of communicaiton",0,{"$f":"K22*M22","v":0}]
[15,"Meeting the Scope of Work Required","Non Functional","What type of authentication security does Source support, i.e. Basic Authentication for Web Services, Database or SFTP?","Workflow specific - Intelligent Business Process Management Tool","Integration","Provide the Authentication capability",null,"Very important",{"$f":"IF(I23='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I23='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I23='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I23='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I23='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I23='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I23='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},4.2553191489361701E-2,"100%:Source can apply Basic Authentication for Web Services, Database and SFTP\n50%: The Source can only apply Basic Suthentication on Database or SFTP\n0%: Neither",0,0]
[16,"Meeting the Scope of Work Required","Non Functional","Previous experience in integration mesage modelling. Please provide references on experience by  the tenderer.","Workflow specific - Intelligent Business Process Management Tool","Integration","Provide proof and references that you have experience in integration message modelling, and carried out the following :\n• Analysis of message requirements. \n• Model or update integration message which follow a Common information model. \n• Create payloads and envelopes. \n• Generate xsd, message model and model dictionary.",null,"Very important",{"$f":"IF(I24='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I24='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I24='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I24='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I24='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I24='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I24='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},4.2553191489361701E-2,"100%: Experience in Integration message modelling\n0%:     No Experience",0,0]
[17,"Meeting the Scope of Work Required","Non Functional","Can Integration reply to the Source Application with a full service response (pre-defined message structure) in case Source Application is invoking an Integration Web Service or the Source can only handle HTTP/SOAP responses?","Workflow specific - Intelligent Business Process Management Tool","Integration","Provide the Basic Authentication capability",null,"Very important",{"$f":"IF(I25='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I25='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I25='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I25='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I25='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I25='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I25='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},4.2553191489361701E-2,"100%:Source can accept full service response\n50%: The Source can accept HTTP/SOAP response\n0%: Neither",0,0]
[18,"Meeting the Scope of Work Required","Non Functional","Is the Source Application capable of retrying a message if there are connection errors in Integration or Target and they have received a service response or HTTP response?\nSource Application can distinguish between Technical and Business error, and handle each one in a seperate manor\n IF Database, Have a separate column in the table where errors can be written, and column for a flag (Successful, technical error, business error)","Workflow specific - Intelligent Business Process Management Tool","Integration","Provide The Retry capability",null,"Very important",{"$f":"IF(I26='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I26='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I26='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I26='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I26='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I26='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I26='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},4.2553191489361701E-2,"100%:Source can handles Technical and Business error seperately and can cater for separate columns in the Database for errors and a flag\n50%: The Source handles Technical and Business errors in one manor or can only cater for the Database flag or comments field\n0%: The Source cannot cater for any re-tries",0,0]
[19,"Meeting the Scope of Work Required","Non Functional","Previous experience formulating or updating Diagrams and Process in Sparx Enterprise Architecture ","Workflow specific - Intelligent Business Process Management Tool","Integration","Provide proof of experience and references that you have experience in Sparx Enterprise Architecture software",null,"Very important",{"$f":"IF(I27='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I27='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I27='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I27='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I27='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I27='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I27='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J27/J$32","v":4.2553191489361701E-2},"100%: Experience in Sparx Enterprise Architecture\n0%:     No Experience",0,{"$f":"K27*M27","v":0}]
[20,"Meeting the Scope of Work Required","Non Functional","Previous experience in using Altova XMLSpy  ","Workflow specific - Intelligent Business Process Management Tool","Integration","Provide proof of experience and references that you have experience in Altova XML Spy software",null,"Very important",{"$f":"IF(I28='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I28='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I28='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I28='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I28='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I28='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I28='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},4.2553191489361701E-2,"100%: Experience in Altova XML Spy software\n0%:     No Experience",0,0]
[21,"Meeting the Scope of Work Required","Non Functional","Confirm you clearly understand it is your responsibility to supply licenses for Sparx Enterprise Architecture and Altova XMLSpy  ","Workflow specific - Intelligent Business Process Management Tool","Integration","Provide confirmation that you understand that you will be providing licenses for the project resources to work on the both software",null,"Very important",{"$f":"IF(I29='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I29='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I29='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I29='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I29='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I29='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I29='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J29/J$32","v":4.2553191489361701E-2},"100%: Fully comply with requirement\n0%:     No compliance",0,{"$f":"K29*M29","v":0}]
[22,"Meeting the Scope of Work Required","Non Functional","Confirm the list of integration services that need to be built is clearly understood","Workflow specific - Intelligent Business Process Management Tool","Integration","The Sales and Forecasting Tracking Tool solution should be able to integrate to applications for purposes of actioning or addressing queries via the defined intergration technology Oracle Fusion and IBM Datapower.\n(Applications i.e. Work Force Management, Billing, CRM, OMS – (PowerOn Advantage), verification of contact details etc.\n",null,"Very important",{"$f":"IF(I30='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I30='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I30='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I30='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I30='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I30='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I30='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},4.2553191489361701E-2,"100%: Fully comply with requirement\n0%:     No compliance\n",0,0]
[]
[null,null,null,null,null,null,null,"Totals",null,{"$f":"SUM(J9:J30)","v":94},{"$f":"SUM(K9:K30)","v":0.99999999999999944},null,null,{"$f":"SUM(N9:N30)","v":0}]

{"sheet":"Functional","index":6,"n_rows":75,"n_cols":15,"rows_kept":75,"cut":false,"hidden":false,"merged":[[73,0,73,14],[2,0,2,1],[3,0,3,1],[5,0,5,2],[6,10,6,11],[6,12,6,14]]}
["Workflow specific - Intelligent Business Process Management Tool",null,null," ",null,null,null," "]
["Tender Number:",null,null," ",null,null,null," "]
["Tenderer:",null," "," ",null,null,null," "]
["Evaluated by:",null," "," ",null,null,null," "]
[]
["Evaluation Criteria",null,null," ",null,null,null," "]
[null,null," "," ",null," ",null," ",null," ","Weight\n(agreed by evaluation team members)",null,"Answer\n(0,50,100%)"]
["ID","Type","Solution","Functional Requirement","BRS ref","Criterion","Requirement description","Comments","Priority Description","Priority","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","Addendum 2\n7.1.2\n\n\n\n\n\n\n\nDFR9","Capability to provide and to easily use drag and drop forms","Discuss your solution's ability to meet this requirement. Please provide applicable evidence (solution features and functionality, experience, reference or certification etc.)."," ","Very important",{"$f":"IF(I9='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I9='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I9='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I9='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I9='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I9='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I9='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J9/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,{"$f":"K9*M9","v":0}]
[2,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","Addendum 2","Capability to design forms","Discuss your ability to meet this requirement. Please provide applicable evidence (tools and methods, experience, reference or certification etc.)."," ","Very important",{"$f":"IF(I10='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I10='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I10='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I10='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I10='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I10='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I10='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J10/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,{"$f":"K10*M10","v":0}]
[3,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","Addendum 2\n7.1.2","Capability to create Full Task Detail View","Discuss your ability to meet this requirement. Please provide applicable evidence (tools and methods, experience, reference or certification etc.)."," ","Very important",{"$f":"IF(I11='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I11='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I11='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I11='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I11='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I11='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I11='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J11/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[4,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","Addendum 2\n7.1","The technology should provide build in controls to build forms","Discuss your ability to meet this requirement. Please provide applicable evidence (solution features and functionality, experience, reference or certification etc.)."," ","Very important",{"$f":"IF(I12='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I12='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I12='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I12='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I12='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I12='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I12='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J12/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[5,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules",null,"Customize portal with corporate branding ","Discuss your ability to meet this requirement. Please provide applicable evidence (solution features and functionality, experience, reference or certification etc.).",null,"Important",{"$f":"IF(I13='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I13='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I13='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I13='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I13='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I13='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I13='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"J13/J75","v":1.2345679012345678E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[6,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules",9.1999999999999993,"Ability to edit data on the submitted forms","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very important",{"$f":"IF(I14='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I14='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I14='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I14='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I14='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I14='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I14='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J14/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,{"$f":"K14*M14","v":0}]
[7,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","7.1.3.5\nDFR5","Ability to edit,\n- deletes, \n-view, \n-and create revisions\n- and version control of the forms","Discuss your ability to meet this requirement. Please provide applicable evidence (feature and functionalities, experience, reference or certification etc.)."," ","Very important",{"$f":"IF(I15='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I15='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I15='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I15='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I15='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I15='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I15='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J15/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[8,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","7.1.3.9","Ability to re-assign/redirect the forms","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Critical",{"$f":"IF(I16='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I16='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I16='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I16='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I16='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I16='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I16='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"J16/J75","v":2.0576131687242798E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[9,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","7.1.2","Ability to have deleted forms to be stored in the storage (Recycle bin)","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Useful",{"$f":"IF(I17='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I17='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I17='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I17='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I17='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I17='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I17='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":2},{"$f":"J17/J75","v":8.23045267489712E-3},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[10,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","DFR10\nDFR8\n","Capability to use advanced form rules to create smarter forms.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Important",{"$f":"IF(I18='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I18='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I18='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I18='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I18='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I18='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I18='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"J18/J75","v":1.2345679012345678E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[11,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","7.1.2","Friendly forms, field pre-fills, better quality form hints","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Important",{"$f":"IF(I19='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I19='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I19='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I19='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I19='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I19='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I19='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"J19/J75","v":1.2345679012345678E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[12,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","7.1.2","Forms should have ability to display/hide only the sections and questions relevant to those specific attributes","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Critical",{"$f":"IF(I20='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I20='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I20='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I20='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I20='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I20='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I20='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"J20/J75","v":2.0576131687242798E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[13,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","7.1.3.5\nDFR5","Ability to save and submit the form","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Important",{"$f":"IF(I21='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I21='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I21='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I21='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I21='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I21='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I21='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"J21/J75","v":1.2345679012345678E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[14,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","7.1.3.2","Ability to attach documents \n- PDF,\n- Images (all formats)\n- Word Document, \n-Excel spreadsheet","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Important",{"$f":"IF(I22='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I22='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I22='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I22='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I22='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I22='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I22='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"J22/J75","v":1.2345679012345678E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[15,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Electricity sales forecast - Forecaster input","7.1.3.4\n7.1.3.3\nDFR5","Ability to print forms","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionalities, experience, reference or certification etc.)."," ","Very important",{"$f":"IF(I23='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I23='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I23='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I23='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I23='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I23='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I23='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J23/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[16,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","7.1.3.14\nDFR5","Capability to initiate workflows based on pre-defined business rules","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Important",{"$f":"IF(I24='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I24='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I24='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I24='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I24='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I24='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I24='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"J24/J75","v":1.2345679012345678E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[17,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","7.1.3.4\n7.1.3.3","Capability to define Business Rules","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Important",{"$f":"IF(I25='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I25='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I25='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I25='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I25='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I25='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I25='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"J25/J75","v":1.2345679012345678E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[18,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","7.1.3.16\nDFR5","Solution should allow for responsive web design","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very important",{"$f":"IF(I26='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I26='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I26='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I26='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I26='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I26='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I26='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J26/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[19,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Forms and Rules","7.1.3.16\nDFR5","Solutions should offer flexible deployment options like \n-public cloud,\n- private cloud\n- or on premise","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Useful",{"$f":"IF(I27='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I27='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I27='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I27='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I27='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I27='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I27='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":2},{"$f":"J27/J75","v":8.23045267489712E-3},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[20,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Process and rules",null,"Ability to create the workflow","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Important",{"$f":"IF(I28='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I28='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I28='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I28='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I28='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I28='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I28='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"J28/J75","v":1.2345679012345678E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[21,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Process and rules",null,"Ability to manage the workflows.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Critical",{"$f":"IF(I29='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I29='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I29='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I29='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I29='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I29='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I29='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"J29/J75","v":2.0576131687242798E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[22,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Process and rules",null,"Capability to do parallel workflow activities  ","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionalities, experience, reference or certification etc.)."," ","Important",{"$f":"IF(I30='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I30='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I30='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I30='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I30='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I30='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I30='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"J30/J75","v":1.2345679012345678E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[23,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Process and rules",null,"Capability to do Custom Workflow (Workflow following any order and defined workflow)","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Important",{"$f":"IF(I31='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I31='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I31='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I31='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I31='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I31='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I31='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"J31/J75","v":1.2345679012345678E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[24,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Process and rules",null,"Capability to categorise workflows into collections and including a search bar to quickly locate them by name.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Important",{"$f":"IF(I32='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I32='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I32='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I32='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I32='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I32='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I32='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"J32/J75","v":1.2345679012345678E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[25,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Process and rules",null,"Ability to assign people to specific activities","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionalities, experience, reference or certification etc.)."," ","Critical",{"$f":"IF(I33='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I33='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I33='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I33='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I33='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I33='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I33='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"J33/J75","v":2.0576131687242798E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[26,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Process and rules",null,"Ability to send notifications via email or push notifications to remind of upcoming approvals","Discuss your ability to meet this requirement. Please provide applicable evidence (experience, reference or certification etc.)."," ","Very important",{"$f":"IF(I34='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I34='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I34='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I34='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I34='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I34='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I34='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J34/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[27,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Process and rules",null,"Track details, history and audit trails activity regarding specific tasks","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very important",{"$f":"IF(I35='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I35='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I35='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I35='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I35='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I35='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I35='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J35/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[28,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Process and rules",null,"Ability to orchestrate complex processes comprising of humans and applications.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very important",{"$f":"IF(I36='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I36='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I36='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I36='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I36='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I36='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I36='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J36/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[29,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Process and rules",null,"The workflow should have a capability to be escalated.\nBusiness Rule \nThe standard escalation rules must be configurable as applicable business rules.\n","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.).",null,"Useful",{"$f":"IF(I37='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I37='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I37='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I37='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I37='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I37='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I37='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":2},{"$f":"J37/J75","v":8.23045267489712E-3},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[30,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Process and rules",null,"Ability to view and track the progress of the workflow.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Useful",{"$f":"IF(I38='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I38='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I38='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I38='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I38='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I38='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I38='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":2},{"$f":"J38/J75","v":8.23045267489712E-3},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[31,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Process and rules","DFR5","Ability to re-assign/redirect the workflow activity.\n","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Critical",{"$f":"IF(I39='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I39='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I39='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I39='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I39='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I39='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I39='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"J39/J75","v":2.0576131687242798E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[32,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Administration Tools",null,"Ability to stop and re-start tasks on the workflow.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Critical",{"$f":"IF(I40='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I40='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I40='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I40='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I40='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I40='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I40='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"J40/J75","v":2.0576131687242798E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[33,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Administration Tools",null,"Check version of the workflow, manage error of the workflow (repair errors)","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I41='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I41='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I41='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I41='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I41='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I41='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I41='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J41/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[34,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Administration Tools",null,"Administrators should be able to customize the kind of notifications they receive/sent out on the system.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I42='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I42='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I42='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I42='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I42='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I42='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I42='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J42/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[35,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Administration Tools",null,"Capability for process automation to allow to set deadlines in the workflow.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I43='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I43='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I43='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I43='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I43='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I43='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I43='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J43/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[36,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Administration Tools",null,"Capability to allow system administrators to customise what each user can see and edit","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I44='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I44='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I44='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I44='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I44='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I44='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I44='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J44/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[37,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Administration Tools",null,"Ability to re assign/redirect the task","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I45='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I45='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I45='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I45='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I45='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I45='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I45='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J45/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[38,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Authentication",null,"Capability to integrate with Active Directory (AD) and able to search and assign users","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I46='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I46='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I46='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I46='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I46='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I46='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I46='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J46/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[39,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Authentication",null,"Capability to have a remote access and real-time sharing","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I47='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I47='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I47='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I47='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I47='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I47='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I47='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J47/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[40,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Authentication",null,"Provide a completely open and flexible Application Programming Interface (API)\nCapability to use open standards to communicate with third party systems.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I48='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I48='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I48='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I48='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I48='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I48='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I48='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J48/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[41,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Database",null,"Easy to integrate with other solutions","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I49='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I49='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I49='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I49='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I49='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I49='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I49='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J49/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[42,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Database",null,"Solution should be able to connect data sources such as, MS SQL, Oracle but not limited to the listed above.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I50='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I50='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I50='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I50='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I50='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I50='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I50='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J50/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[43,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Integration",null,"Capability to integrate with Active Directory (AD)","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I51='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I51='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I51='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I51='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I51='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I51='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I51='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J51/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[44,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Integration",null,"Workflow software must allow integrations via web services and plug-in applications","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I52='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I52='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I52='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I52='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I52='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I52='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I52='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J52/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[45,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Integration",null,"Capabilities to integrate with current Eskom Business Systems e.g., SharePoint, SAP, but not limited to the listed current Eskom systems","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.).",null,"Very important",{"$f":"IF(I53='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I53='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I53='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I53='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I53='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I53='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I53='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J53/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[46,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Integration",null,"Capability of a BPA tool to integrate with the application landscape of the enterprise. These might be connectors for branded off-the-shelf applications, such as CRM, ERP, etc., or customized connectors for in-house-built customized applications","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I54='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I54='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I54='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I54='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I54='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I54='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I54='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J54/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[47,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Execution Engine",null,"Should make use of the Business Process Management Execution language","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I55='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I55='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I55='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I55='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I55='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I55='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I55='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J55/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[48,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Performance Monitoring",null,"Capability to monitor KPI’s","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I56='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I56='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I56='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I56='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I56='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I56='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I56='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J56/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[49,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Performance Monitoring",null,"Ability to analyse KPIs in real time","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I57='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I57='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I57='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I57='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I57='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I57='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I57='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J57/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[50,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Performance Monitoring",null,"Ability to track duration of each activity.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I58='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I58='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I58='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I58='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I58='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I58='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I58='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J58/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[51,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Workflow Performance Monitoring",null,"Capability to provide sorting of workflow and changes.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I59='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I59='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I59='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I59='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I59='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I59='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I59='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J59/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[52,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Migration",null,"Capability to allow the form to rebuild for the following:\n•\tACNAC\n•\tTOP100\n•\tStrategy Execution Tool (SET)\n•\tGenTLC\n•\teForms","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.).",null,"Important",{"$f":"IF(I60='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I60='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I60='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I60='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I60='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I60='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I60='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"J60/J75","v":1.2345679012345678E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[53,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Migration",null,"Capability for the Audit Trail for migration, for errors, Exception report and for fixing.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I61='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I61='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I61='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I61='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I61='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I61='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I61='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J61/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[54,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Migration","7.1.2 - User driven","Provide migration toolset to import data from K2 Blackpearl 4.7,\n•\tWorkflow Designs\n•\tRouting Groups\n•\tForms rules\n•\tForms Designs\n•\tBusiness Data\n- Ability for business super user to maintain system catalogues, hierarchies etc. \nExample: Add new  tariffs, tariff rules, customer types.\n","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.).",null,"Very important",{"$f":"IF(I62='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I62='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I62='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I62='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I62='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I62='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I62='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J62/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[55,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Industry Standard",null,"The solution should support a Business Process Modelling Management Notation (BPMN) but not limited to the mentioned PCM. ","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.).",null,"Very Important",{"$f":"IF(I63='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I63='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I63='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I63='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I63='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I63='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I63='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J63/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[56,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Industry Standard",null,"Workflow automation software must have mobility and collaboration capability.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.)."," ","Very Important",{"$f":"IF(I64='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I64='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I64='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I64='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I64='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I64='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I64='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J64/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[57,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Reporting",null,"Capability to be able to do analytics and draw reports","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.).",null,"Very Important",{"$f":"IF(I65='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I65='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I65='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I65='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I65='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I65='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I65='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J65/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[58,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Reporting",null,"Ability to provide Dashboard","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.).",null,"Useful",{"$f":"IF(I66='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I66='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I66='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I66='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I66='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I66='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I66='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":2},{"$f":"J66/J75","v":8.23045267489712E-3},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[59,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Licencing",null,"The solution should provide DR Licencing at no additional cost.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.).",null,"Important",{"$f":"IF(I67='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I67='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I67='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I67='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I67='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I67='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I67='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"J67/J75","v":1.2345679012345678E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[60,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Process Modelling",null,"Capability of a BPA tool to enable enterprises to model their simple and complex business processes.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.).",null,"Very important",{"$f":"IF(I68='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I68='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I68='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I68='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I68='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I68='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I68='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J68/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[61,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Process Orchestration",null,"Capability of a BPA tool to orchestrate a complex process comprising multiple stakeholders, including humans, applications and machines","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.).",null,"Very important",{"$f":"IF(I69='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I69='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I69='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I69='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I69='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I69='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I69='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J69/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[62,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Decision Automation",null,"Capability of a BPA tool to define business rules, recommendations, or decision automation engines, which provide guidance for making human or automated operational decisions according to business directives or policy statements.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.).",null,"Very Important",{"$f":"IF(I70='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I70='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I70='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I70='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I70='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I70='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I70='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J70/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[null,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Collaboration and Task Management",null,"Capability of the BPA tool to enable process stakeholders to collaborate with other stakeholders in support of achieving the desired business outcomes. Collaboration between process stakeholders may be facilitated through a variety of methods, including content-specific events related to annotations, redactions or creation; real-time chat; case or process instance documents; co-browse sessions; or integration with telephony and video chat services.","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.).",null,"Very important",{"$f":"IF(I71='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I71='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I71='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I71='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I71='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I71='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I71='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J71/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[null,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Document Handling",null,"Capability of a BPA tool to intelligently handle documents by reading, classifying and routing them to the stakeholders","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.).",null,"Very Important",{"$f":"IF(I72='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I72='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I72='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I72='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I72='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I72='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I72='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J72/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[62,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Low-Code Workflow Automation",null,"Capability of a BPA tool to enable visual design of UI, process models and data models","Discuss your ability to meet this requirement. Please provide applicable evidence (features and functionality, experience, reference or certification etc.).",null,"Very Important",{"$f":"IF(I73='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(I73='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(I73='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(I73='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(I73='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(I73='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(I73='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J73/J75","v":1.646090534979424E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[" "]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J73)","v":243},{"$f":"SUM(K9:K73)","v":1.0000000000000009}," ",null,{"$f":"SUM(N9:N73)","v":0}," "]

{"sheet":"Cloud","index":7,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[6,10,6,12],[17,0,17,12],[0,0,0,3],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,0,5,3],[6,8,6,9]]}
[{"$f":"'Technical evaluation'!A1","v":"Workflow specific - Intelligent Business Process Management Tool"}]
["Tender Number:"]
["Tenderer:"]
["Evaluated by:"]
[]
["Evaluation Criteria"]
[null,null,null,null,null,null,null,null,"Weight\n(agreed by evaluation team members)",null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)"]
["ID","Type","Solution","Criterion","Functional Requirement","Requirement description","Comments","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Please clearly state the envisaged start date of the agreement (i.e. commencement of services and service levels).","• Support of cloud\nStandAlone or cloud solution","Any gap between service implementation and “go-live” must be clearly identified. \nIndicate costs in stabilisation period vs production period (operational transactions). Calrify when the solution will be operational.\nIndicate resources to remain to ensure stabilisation\nHow do you conform to the SLA we are proposing. ",null,"Very important",{"$f":"IF(H9='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H9='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H9='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H9='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H9='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H9='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H9='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I9/I$19","v":0.12121212121212122},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,{"$f":"J9*L9","v":0}]
[2,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Does the Supplier’s compliance with copyright laws and other applicable intellectual property rights restrict the type of content ESKOM can store with the cloud service?","DATA OWNERSHIP AND USE",null,null,"Very important",{"$f":"IF(H10='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H10='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H10='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H10='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H10='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H10='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H10='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},0.12121212121212122,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[3,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Do the Supplier’s terms apply to metadata?","DATA OWNERSHIP AND USE","ESKOM requires no exception for metadata. Ownership of all data including metadata must belong to Eskom.\n",null,"Important",{"$f":"IF(H11='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H11='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H11='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H11='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H11='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H11='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H11='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},9.0909090909090912E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[4,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Does ESKOM gain ownership of metadata generated by the cloud service system during procedures of upload, management, download, and migration?","DATA OWNERSHIP AND USE",null,null,"Useful",{"$f":"IF(H12='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H12='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H12='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H12='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H12='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H12='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H12='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":2},6.0606060606060608E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[5,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Provide specific indicators for Eskom access\n* 24x7 support\n* alerts\n* Monitor\n* web page to view avialability of service\n* Hierachical view\netc. ","AVAILABILITY, RETRIEVAL AND USE","Methods to provide precise indicators regarding the availability of the service?",null,"Very important",{"$f":"IF(H13='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H13='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H13='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H13='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H13='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H13='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H13='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},0.12121212121212122,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[6,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Is this covering data on their cloud/site. Will our customers have the right level of access to their data. \nWhere is the data stored.\nAlso storage and archiving. Including NERSA / Legal requirements.","AVAILABILITY, RETRIEVAL AND USE","\nDoes the degree of availability of the data allow ESKOM to comply with the right of persons to access their own personal information?",null,"Very important",{"$f":"IF(H14='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H14='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H14='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H14='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H14='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H14='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H14='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},0.12121212121212122,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[7,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Is this covering data on their cloud/site. Will Eskom  have the right level of access to data. \nWhere is the data stored.\nAlso storage and archiving. Including NERSA / Legal requirements.","AVAILABILITY, RETRIEVAL AND USE","Does the degree of availability of the data allow ESKOM to comply with the right of authorities to legally access ESKOM data for investigation, audit, control or judicial purposes?",null,"Very important",{"$f":"IF(H15='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H15='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H15='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H15='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H15='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H15='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H15='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},0.12121212121212122,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[8,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","\nData Storage\nDowntime from Eskom side. Source Biling systems down?\nIf chats are backed up, then their will be customer data. Even in the verification process, there will be some customer data transferred. Kept by 3rd party.\nProvide details of backups. How long is it kept. . Process for destroying data.\nIs ESKOM clearly informed about the procedure and conditions for the destruction of ESKOM data?","DATA STORAGE AND PRESERVATION","If ESKOM organization manages external records (e.g. customer data), does the Supplier create backups of ESKOM customer’s data?",null,"Very important",{"$f":"IF(H16='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H16='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H16='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H16='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H16='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H16='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H16='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},0.12121212121212122,"Criteria: 1-Completeness; 2-Level of detail; 3-Logical breakdown\n100%: Exceptional\n75%:    3 out of 3\n50%:    2 out of 3\n25%:    1 out of 3\n0%:       0 out of 3",null,0]
[9,"Meeting the Scope of Work Required","Workflow specific - Intelligent Business Process Management Tool","Does the system provide and give Eskom access to audit trails, metadata and/or access logs to demonstrate security measures?  ","SECURITY, CONFIDENTIALITY AND PRIVACY","Security",null,"Very important",{"$f":"IF(H17='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H17='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H17='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H17='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H17='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H17='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H17='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},0.12121212121212122,"100%: All information provided\n50%:  Some information provided\n0%:     No information provided",null,{"$f":"J17*L17","v":0}]
[]
[null,null,null,null,null,null,"Totals",null,{"$f":"SUM(I9:I17)","v":33},{"$f":"SUM(J9:J17)","v":1},null,null,{"$f":"SUM(M9:M17)","v":0}]

{"sheet":"Demonstration","index":8,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[6,11,6,13],[43,0,43,13],[0,0,0,2],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,0,5,2],[6,9,6,10]]}
[{"$f":"'Technical evaluation'!A1","v":"Workflow specific - Intelligent Business Process Management Tool"}]
["Tender Number:"]
["Tenderer:"]
["Evaluated by:"]
[]
["Evaluation Criteria"]
[null,null,null,null,null,null,null,null,null,"Weight\n(agreed by evaluation team members)",null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)"]
["ID","Type","Criterion","Solution","Category","Functional Requirement","Requirement description","Comments","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Meeting the Scope of Work Required","The tool should be able to generate forecast summaries/reports that can spot issues like missing or outdated data ad fill gaps to improve accuracy across the board ","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Very important",{"$f":"IF(I9='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I9='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I9='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I9='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I9='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I9='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I9='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J9/J$45","v":2.7027027027027029E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,{"$f":"K9*M9","v":0}]
[2,"Meeting the Scope of Work Required","A revenue calculator that can calculate revenue based on price changes","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Critical",{"$f":"IF(I10='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I10='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I10='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I10='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I10='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I10='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I10='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},3.3783783783783786E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[3,"Meeting the Scope of Work Required","Ability to slice forecast to enter multiple regions, line of business, products, or any other way the business can be segmented","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Critical",{"$f":"IF(I11='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I11='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I11='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I11='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I11='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I11='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I11='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},3.3783783783783786E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[4,"Meeting the Scope of Work Required","Ability to pull historical sales data from any time period in order to make the sales forecasting more trustworthy","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Critical",{"$f":"IF(I12='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I12='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I12='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I12='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I12='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I12='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I12='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},3.3783783783783786E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[5,"Meeting the Scope of Work Required","Contain future forecasts","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Very important",{"$f":"IF(I13='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I13='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I13='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I13='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I13='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I13='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I13='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[6,"Meeting the Scope of Work Required"," Enable the forecasters to analyse historical trends in performance as well as future trends","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Very important",{"$f":"IF(I14='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I14='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I14='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I14='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I14='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I14='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I14='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[7,"Meeting the Scope of Work Required","Sales forecast benchmarking: forecast sales and compare to industry trends","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Show stopper",{"$f":"IF(I15='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I15='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I15='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I15='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I15='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I15='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I15='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":6},4.0540540540540543E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[8,"Meeting the Scope of Work Required","Quick forecasts through dashboards and reporting: a quick overview of sales forecasts","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Show stopper",{"$f":"IF(I16='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I16='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I16='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I16='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I16='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I16='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I16='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":6},4.0540540540540543E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[9,"Meeting the Scope of Work Required","Sales forecast visuals: clear and helpful visuals","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Very important",{"$f":"IF(I17='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I17='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I17='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I17='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I17='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I17='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I17='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[10,"Meeting the Scope of Work Required","Sales forecasting factors: multivariate forecasting algorithms and queries that allow users to adjust the factors that influence projections and generate results from these queries ","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Critical",{"$f":"IF(I18='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I18='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I18='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I18='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I18='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I18='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I18='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},3.3783783783783786E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[11,"Meeting the Scope of Work Required","Sales forecast review: track forecast accuracy/model fit and confidence","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Very important",{"$f":"IF(I19='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I19='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I19='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I19='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I19='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I19='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I19='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[12,"Meeting the Scope of Work Required","Sales forecasting management: ability to manage models and assumptions based on forecast reviews","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Very important",{"$f":"IF(I20='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I20='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I20='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I20='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I20='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I20='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I20='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[13,"Meeting the Scope of Work Required","Custom forecast models: allows for granular control over the forecasting approach","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Very important",{"$f":"IF(I21='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I21='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I21='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I21='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I21='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I21='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I21='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[14,"Meeting the Scope of Work Required","Record of previous sales forecasts and audit trail","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Very important",{"$f":"IF(I22='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I22='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I22='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I22='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I22='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I22='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I22='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[15,"Meeting the Scope of Work Required","10 year history, 15 year future with easy expansion","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this capability? Show how this requirement is realised",null,"Very important",{"$f":"IF(I23='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I23='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I23='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I23='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I23='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I23='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I23='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[16,"Meeting the Scope of Work Required"," Security and privacy must be able to be assigned and controlled closely given the sensitivity of the data","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Very important",{"$f":"IF(I24='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I24='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I24='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I24='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I24='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I24='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I24='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[17,"Meeting the Scope of Work Required","Does the tool have Statistical modelling capabilities","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Can the tool do statistical modelling? Show how this requirement is realised",null,"Critical",{"$f":"IF(I25='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I25='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I25='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I25='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I25='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I25='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I25='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},3.3783783783783786E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[18,"Meeting the Scope of Work Required","User driven outline changes – no 3rd party work. Forecasters should be able to adapt easily to produce outputs as needed to minimise dependency on 3rd parties. ","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Very important",{"$f":"IF(I26='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I26='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I26='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I26='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I26='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I26='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I26='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[19,"Meeting the Scope of Work Required","User driven outline changes – no 3rd party work. Forecasters should be able to adapt easily to produce outputs as needed to minimise dependency on 3rd parties. ","Workflow specific - Intelligent Business Process Management Tool","Functional","Core Features","Does it have this requirement? Show how this requirement is realised",null,"Critical",{"$f":"IF(I27='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I27='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I27='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I27='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I27='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I27='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I27='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},3.3783783783783786E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[20,"Meeting the Scope of Work Required","The abilty to perform Predictive analysis","Workflow specific - Intelligent Business Process Management Tool","Functional","Distinctive Features","Show how Predictive analysis can be achieved",null,"Very important",{"$f":"IF(I28='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I28='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I28='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I28='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I28='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I28='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I28='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: 80-90% User configurable\n50%:   60-80% User configurable\n0%:     No compliance",0,0]
[21,"Meeting the Scope of Work Required","Write back to sales tool (submit a completed spreadsheet back into the system)","Workflow specific - Intelligent Business Process Management Tool","Functional","Distinctive Features","Does it have this requirement? Show how this requirement is realised",null,"critical",{"$f":"IF(I29='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I29='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I29='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I29='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I29='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I29='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I29='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},3.3783783783783786E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[22,"Meeting the Scope of Work Required","Does the tool have an Excel add in","Workflow specific - Intelligent Business Process Management Tool","Functional","Distinctive Features","Does it have this requirement? Show how this requirement is realised",null,"Critical",{"$f":"IF(I30='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I30='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I30='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I30='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I30='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I30='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I30='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},3.3783783783783786E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[23,"Meeting the Scope of Work Required","Can the tool do Scenario planning","Workflow specific - Intelligent Business Process Management Tool","Functional","Distinctive Features","Show how Scenario Planning can be achieved",null,"Very important",{"$f":"IF(I31='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I31='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I31='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I31='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I31='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I31='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I31='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[24,"Meeting the Scope of Work Required","Does the tool have Slice and dice capabilities","Workflow specific - Intelligent Business Process Management Tool","Functional","Distinctive Features","Show how Slice and Dice Planning can be achieved",null,"Very important",{"$f":"IF(I32='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I32='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I32='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I32='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I32='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I32='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I32='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[25,"Meeting the Scope of Work Required","Peak and poke (modify and send into sales tool)","Workflow specific - Intelligent Business Process Management Tool","Functional","Distinctive Features","Does it have this requirement? Show how this requirement is realised",null,"Very important",{"$f":"IF(I33='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I33='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I33='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I33='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I33='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I33='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I33='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[26,"Meeting the Scope of Work Required","Compatibility Certificate from Microsoft AD or Azure","Workflow specific - Intelligent Business Process Management Tool","Technical Evaluation","Information Security","Access Control and User Account Management (Technical Support Team)\n\nIs your Proposed Solution comply and Compatible with Microsoft Active Directory and or Azure",null,"Very important",{"$f":"IF(I34='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I34='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I34='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I34='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I34='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I34='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I34='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[27,"Meeting the Scope of Work Required","Substantiate by providing details of standards that are supported and ensure that these Capabilities are detailed in the proposal","Workflow specific - Intelligent Business Process Management Tool","Technical Evaluation","Information Security","Show the End to end encryption of messages, at rest and transit. Logs etc.",null,"Very important",{"$f":"IF(I35='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I35='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I35='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I35='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I35='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I35='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I35='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[28,"Meeting the Scope of Work Required","Please provide us with a Sample of the Report (Unmodified)","Workflow specific - Intelligent Business Process Management Tool","Technical Evaluation","Audit Trail","Demonstrate how the system does Audit trail in terms of :\n- Logs that support recording user activities\n- System faults, exceptions, and \n- Information security events that are kept for an agreed period to assist in future investigations and access control monitoring.",null,"Important",{"$f":"IF(I36='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I36='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I36='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I36='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I36='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I36='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I36='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},2.0270270270270271E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[29,"Meeting the Scope of Work Required","Network Security and 3rd Party Access","Workflow specific - Intelligent Business Process Management Tool","Technical Evaluation","Network Deployment","Demonstrate how would the proposed solution protect Data and Facilitate 3rd Party Access,  \nAlso for provision of support.\nHow is the access to the data managed.Manage access to backend systems to address possible access to information to unauthorised people.",null,"Very important",{"$f":"IF(I37='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I37='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I37='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I37='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I37='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I37='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I37='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[30,"Meeting the Scope of Work Required","Near realtime response times below 3 seconds, network performance certificate as proof. ","Workflow specific - Intelligent Business Process Management Tool","Technical Evaluation","Network Deployment","Show Network shaping tools you will deploy (if any) and performance of the solution over the cloud network.\n",null,"Very important",{"$f":"IF(I38='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I38='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I38='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I38='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I38='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I38='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I38='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[31,"Meeting the Scope of Work Required","Scalability \nBidder to provide Detail Design that comprises the full set of functional and non-functional elements.","Workflow specific - Intelligent Business Process Management Tool","Technical Evaluation","Core Infrastructure","Scalability \n\nPlease show how scalable is the proposed solution in terms of deployment methodology\nAbilty to add more resources to scale\n",null,"Important",{"$f":"IF(I39='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I39='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I39='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I39='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I39='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I39='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I39='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},2.0270270270270271E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[32,"Meeting the Scope of Work Required","Flexibility","Workflow specific - Intelligent Business Process Management Tool","Technical Evaluation","Core Infrastructure","Mechanism for flexible deployment. Should not be restricted i.e. Changes only allowed donce a month. \nIf integration is down, fucntionality to report faults is down. Ability/flexibility  to quickly respond and inform customers accordingly.",null,"Important",{"$f":"IF(I40='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I40='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I40='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I40='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I40='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I40='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I40='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},2.0270270270270271E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[33,"Meeting the Scope of Work Required","Demonstrate how High Availability  will be achieved for your proposed Solution ","Workflow specific - Intelligent Business Process Management Tool","Technical Evaluation","Core Infrastructure","High Availability Configuration \n\nShow how the Solution is Configurable for High Availability, with a Business Requirement of 98% uptime  \nHigh Availability Design – Hot Standby. Please describe and provide the proposed High Availability Deployment Design",null,"Important",{"$f":"IF(I41='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I41='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I41='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I41='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I41='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I41='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I41='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},2.0270270270270271E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[34,"Meeting the Scope of Work Required","End Point Devices access","Workflow specific - Intelligent Business Process Management Tool","Technical Evaluation","Core Infrastructure","If this Solution is to be accessed by the End Point Devices(i.e. Laptops and Desktops), please demonstrate if the Solution is accessable  via the Approved minimum Internet Browser(s) . Indicate the technologies available.",null,"Very important",{"$f":"IF(I42='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I42='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I42='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I42='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I42='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I42='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I42='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[35,"Meeting the Scope of Work Required","Data Preservation","Workflow specific - Intelligent Business Process Management Tool","Technical Evaluation","Business Continuity","Show data restoration in the event of data loss or corruption",null,"Very important",{"$f":"IF(I43='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I43='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I43='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I43='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I43='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I43='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I43='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},2.7027027027027029E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0,0]
[]
[null,null,null,null,null,null,null,"Totals",null,{"$f":"SUM(J9:J43)","v":148},{"$f":"SUM(K9:K43)","v":0.99999999999999978},null,null,{"$f":"SUM(N9:N43)","v":0}]

{"sheet":"Priority Ratings","index":9,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Priority rating","Priority Description",null,"Score Ratings","Score Description"]
[null,0,"No interest",null,0,"0% Compliance"]
[null,1,"Nice to have",null,0.25,"25% Compliance"]
[null,2,"Useful",null,0.5,"50% Compliance"]
[null,3,"Important",null,0.75,"75% Compliance"]
[null,4,"Very important",null,1,"100% Compliance"]
[null,5,"Critical"]
[null,6,"Show stopper"]

{"sheet":"Config","index":10,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Solution",null,"Priority rating","Priority Description",null,"Category"]
[null,"Chatbot",null,0,"No interest",null,"Functional"]
[null,"Social Media API",null,1,"Nice to have",null,"Technical Evaluation"]
[null,"Chatbot and Social Media API",null,2,"Useful",null,"Integration and Testing"]
[null,null,null,3,"Important",null,"Cloud"]
[null,null,null,4,"Very important"]
[null,null,null,5,"Critical"]
[null,null,null,6,"Show stopper"]

{"sheet":"Concerns and Recommendations","index":11,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":true,"merged":[[2,1,2,2],[3,1,16,14],[18,1,18,2],[19,1,33,14]]}
["Note: Not applicable for the vendors / Tenderers / respondents. This sheet is not needed for issuing the Tendor. Useful for making recommendatins after evaluation."]
[]
[null,"Recommendation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Concerns"]