解密电子表格的工具？ [英] Tool for deciphering Spreadsheets?

问题描述

我最近在我的膝盖上放了一个多页的Excel电子表格/工作簿。是否有任何工具来帮助解密电子表格？现在我点击一个小单元格看看那里是什么，然后我点击其他引用的小单元格，然后我点击3个其他单元格，它使用，相当快我迷失在一个迷人的小细胞迷宫，所有这些都是一样的。

我需要从表格中提取业务逻辑，希望非常费力。

解决方案

这是一个很难的问题，因为公式不仅仅是业务逻辑，他们也只是为了让Excel了解你想要做什么，例如从列表中简单的查找。

虽然我不能推荐一个特定的工具，但我发现从副本中工作，并且移动的东西通常可以帮助。例如，在列A中移动结果或总类型公式，由B中的结果引用的单元格，C中引用的任何单元格等等。然后你会有一种树结构。移动查询旁边的公式也可能是有益的，或将它们全部放在同一张表上。

这远远不够完美，但是它的结构不仅仅是一个有趣的结构。

I recently had a multipage Excel spreadsheet/workbook dumped in my lap. Are there any tools to aid in deciphering spreadsheets? At the moment I click in a little cell to see what's there, then I click in some other little cell that it references, then I click in 3 other cells that it uses and fairly quickly I'm lost in a maze of twisty little cells, all alike.

I need to extract the "business logic" from the sheets in some hopefully non-laborious manner.

解决方案

It's quite a hard problem, in that formulae aren't just business logic, they're also there just to get Excel to understand what you're trying to do, e.g. a simple look-up from a list.

Although I can't recommend a specific tool, I find working from a copy, and moving things around can often help. For example, moving the "result" or "total" type formulae in column A, the cells that are referenced by the result in B, any cells that these reference in C and so on. You'll then have a kind of tree structure. It may also be beneficial to move the look-ups next to the formulae they're used in, or put them all on the same sheet.

This is far from perfect, but it's a little more structured than just poking about.

这篇关于解密电子表格的工具？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！