用户须知的基本知识

同时扩散板造型的用户应该有一些基本知识如何在excel表做的造型。下面给出的一些说明:
•首先将造型的用户表必须收集所有的信息传播所需的建模和模拟的过程。
•用户必须拥有所有的基本输入像摊位席位,席位,固定成本和其他投入。
•使用一定的知识业务规则、基本公式和基本功能。
•优化模型应该知道用户在优化成本给定的天。
•检查宏设置传播表之前的模拟。
•如何去设置的基本公式函数利润,销售或每天必须知道用户。
•用户应该创建依赖关系图的表模型。
•图显示的每个表的布局编辑器模型与关键设计的解释方面,决策和假设模型,包括用户交互和任何特殊功能应该允许用户。
•用户应该主要集中在分析结果通过优化给定的资源。
•使用excel表生成的报告应该是造型本身。
•报告必须包括流程图、定价模型和其他利润或销售情节显示哪一天获得的结果是什么。
•宏知识及其基于VBA的编码或生成功能,用户应该能够开发和测试。
•在开发宏用户必须使用初始优化值,以得到最好的结果。
•用户应该使用if语句的同时发展扩散板造型。
•用户可以准备根据VBA代码,可以使用代码,同时造型的表。
•在最终报告的解释图形、草图、流程图必须包括在细节。
While making spread sheet modelling the user should have some basic knowledge of how to do the modelling in excel sheet. Some of the instructions are given below:
• First of all the user who is going to modelling the spread sheet must gather all the information needed for the modelling and the process of modelling.
• User must have all the basic inputs like stall seats, circle seats, fixed costs and other inputs as well.
• Use must have the knowledge of business rules, basic formulas and basic functionality.
• Optimization model should be known to the user while optimizing the costs for the given days.
• Check macro settings of the spread sheet before going for simulation.
• How to go for setting up the basic formula functions for profit, sales or day by day selling must be known to the user.
• User should create the dependency diagram for the spread sheet modelling.
• A diagram that shows the layout of each sheet of the spread sheet model with an explanation of the key design aspects, decisions and assumptions about the model, including user interaction and any special features should be cleared to the users.
• User should have its main focus on analysing the result by optimizing the given resources.
• The report should be generated by using the excel sheet modelling itself.
• The report must consists of flow diagrams, pricing model and other profit or sales plots showing on which day what result was obtained.
• Macros knowledge and its VBA based coding or generating functions, the user should be able to develop the same and test.
• While developing the macros the user must use the initial optimizing values to get the best results.
• The user should use the ‘if statement’ while developing the spread sheet modelling.
• User can prepare the code according VBA and can use that code while modelling the spread sheet.
• In final report the interpretation of the graphs, sketches, flow diagram must be included in details.