...
  • 主题
高级搜索  >
历史搜索 清空历史
首页> 外文期刊>International Journal of Technology, Policy and Management >A spreadsheet solution to Einstein's Riddle
【24h】

A spreadsheet solution to Einstein's Riddle

机译：电子表格解决爱因斯坦之谜

获取原文
获取原文并翻译 | 示例
           
页面导航
  • 摘要
  • 著录项
  • 相似文献
  • 相关主题

摘要

'Einstein's Riddle' is a challenging exercise in logic. The riddle is structured such that there are five people, each with a unique set of attributes. The attributes are nationality, house colour, pet, cigar brand, favourite beverage and house position. The riddle consists of a series of 15 hints designed to lead the riddle solver through the logical exercise of eliminating incorrect combinations of attributes. The riddle solver must define each person's set of attributes, i.e., which person is assigned to the fish? This article explains how the riddle can be modelled using a spreadsheet formulation and solved using Excel Solver. The spreadsheet lends itself well to tracking the progress of a purely process-of-elimination approach. The format shown allows the attribute values to be arranged on the spreadsheet until the solution reveals itself. Solver spreadsheet zero-one modelling has potential in many applications.
机译：“爱因斯坦之谜”是逻辑上的一项挑战性练习。谜语的结构使得五个人，每个人都有一套独特的属性。属性包括国籍，房屋颜色，宠物，雪茄品牌，喜爱的饮料和房屋位置。谜语由一系列的15条提示组成，旨在引导谜题求解器进行消除不正确属性组合的逻辑练习。谜题求解器必须定义每个人的属性集，即，哪个人被分配给了鱼？本文介绍了如何使用电子表格格式对谜语进行建模并使用Excel Solver进行求解。电子表格非常适合跟踪纯消除过程方法的进度。显示的格式允许属性值排列在电子表格上，直到解决方案显示出来为止。求解器电子表格零一建模在许多应用中都具有潜力。

著录项

相似文献

  • 外文文献
  • 中文文献
  • 专利
获取原文

客服邮箱：kefu@zhangqiaokeyan.com

京公网安备：11010802029741号 ICP备案号：京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有

  • 客服微信

  • 服务号