Trying to understand the rationale behind using this excel simulation model. Whe

Question

Trying to understand the rationale behind using this excel simulation model. When I reopen the excel file, sometimes there are no values and most of the cells have #REF! in them.

obability 0.13 0.23 0.27 0.19 0.15 0.09 31 74 Service Time (discrete distribution) Randome ageService Number Upper time Lower Limit Limit (minutes) 0.19 0.17 0.16 39 57 74 56 73 0.11 0.08 0.03 Hold 16.3612.95 31 Utilization 96% 100% Customer RandomArriva Random Service Arriva Service Service Time in Time on Time Server Percent Time Start End Time System 0.23 of this Trial run, Maximum: 34 26 42 36 62 14 43% 100% 100% 100% 100% 100% 100% 83 16 13 14 17 21 23 28 14 16 20 21 25 15 21 36 65 45 25 83

Explanation / Answer

The #REF! error shows when a formula refers to a cell is not valid. This happens most often when cells that were refrenced by formulas get deleted, or pasted over.

If you were to delete any of the column then it would cause a #REF! error. You should compute by mentioning that column by #REF! so that would not cause that kind of error. Like Sum= Sum(B, #REF!, D).

If you accidently the column or row then press CTRL+Z to quickly go back.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.