Data & Spreadsheets

Spreadsheets, data organization, and analysis workflows.

Showing 1–12 of 33 guides

NAVA F60 export formats: comparing field measurements and export steps with a Zellix device.
8 min read

NAVA F60 export formats versus Zellix field measurements

The choice depends on what you need to carry away from a field visit. If another person needs digital mapping data, NAVA F60 export formats deserve closer attention: its description lists GPX, SHP, MIF, CSV, KML, DXF, and TXT for sharing GPS data. If your work centers on taking measurements and reviewing stored records on the handheld, the Zellix MC8066C description addresses that use more directly. Neither description establishes a complete field-to-office process or a measured accuracy standard. For NAVA F60 export formats , verify each step.

Spreadsheet subtotal checks that establish which rows each subtotal covers before adding a grand total.
8 min read

Use spreadsheet subtotal checks before adding a grand total

A worksheet can contain four item counts, two subtotals and a grand total, with every number correct on its own. Adding all seven numbers would still give the wrong answer. Spreadsheet subtotal checks start by asking which original items each row represents. If a subtotal already includes two detail rows, the grand total can use that subtotal or those two detail rows, but cannot use both. The choice has to cover every intended item once.

Interpret rounded measurements in a length comparison where two values displayed as 12.4 cm may conceal different underlying values.
9 min read

How to interpret rounded measurements before comparing lengths

Two strips for a fictional tabletop display are listed as 12.4 cm and 12.4 cm. Can you tell which was longer before the numbers were rounded? No. Both labels could conceal different original readings. To interpret rounded measurements , first establish the rule that produced each label, then work backward to the readings that could have produced it. An interval of possible readings gives you a way to test an ordering without pretending that the printed digits are exact.

Count combinations by reading a two-way display and listing distinct pairs correctly.
8 min read

Count combinations when choosing pairs for a display

Four proposed images are labeled A, B, C, and D. A small display will show two different images. How many choices are there? First decide what a choice means. If you are selecting which images appear, A with B is the same selection as B with A. If the question assigns an image to the left and another to the right, those placements differ. The first question has six possible pairs; the second has twelve possible arrangements. The lists below show where those counts come from. For count combinations , verify each step.

decision matrix planning: ranking workplace options against agreed criteria and evidence.
9 min read

Use decision matrix planning to compare workplace options

Suppose a workplace group has to choose one format for a small exhibition: a poster display, a staffed demonstration, or a short presentation. The organizer wants a recommendation, but the group has not agreed on which qualities matter most. Decision matrix planning can make those preferences visible. Give each eligible format a score on clearly defined criteria, attach weights that the decision owner can question, and see whether a different priority changes the leading option.

Spreadsheet identifier handling that preserves leading zeros and keeps equipment codes distinct from quantities.
9 min read

Plan spreadsheet identifier handling without losing zeros

A register may show equipment code 00427 beside a quantity of 4. The first entry identifies something according to a coding system; the second counts something. If the code later appears as 427, a reader cannot tell from the shortened entry whether two zeros were lost, the source used another code, or the two entries refer to different things. Good spreadsheet identifier handling begins with that uncertainty. Preserve the original characters, establish which characters the identifier owner requires, and leave an unexplained change unresolved instead of making a shortened code look plausible.

Compare event rates fairly when observation periods have different lengths.
8 min read

Compare event rates across unequal observation periods

A larger count can come from a longer watch rather than a faster stream of events. To compare two records made over different periods, divide each count by its own observed duration and express both answers in the same unit, such as arrivals per observed hour. Keep the counts and durations beside those rates. The calculation describes only what happened during the recorded periods; it does not establish which place is usually busier. For compare event rates , verify each step.

Read scale drawings by using the stated length scale and measured marks before estimating real dimensions.
8 min read

Read scale drawings before estimating real dimensions

A rectangle on an exhibition layout can look convincingly measurable. Suppose a fictional organizer sketches a rectangular display area, labels one side with a dimension, and adds a scale note. A colleague opens a copy on a laptop and wants to know the length of another, unlabelled side. The answer depends on what information the drawing actually supplies and whether the copy still has the size for which the scale was stated. A ruler against a screen or a resized printout cannot settle that question by itself. For read scale drawings , verify each step.

Histogram bin planning for a dataset whose interval choices change how a distribution is read and discussed.
8 min read

Use histogram bin planning to show a distribution

A histogram starts with a set of numerical observations, but its bars show counts inside intervals rather than the individual observations. For histogram bin planning , decide where those intervals begin, how wide they are, and which interval receives a value sitting exactly on a boundary before drawing anything. Then account for every value. The resulting picture can help a reader see how this particular set is grouped, provided the original numbers remain available for checking. For histogram bin planning , verify each step.

Missing spreadsheet values in an averaging task where an empty duration must not silently become a recorded observation.
8 min read

Handle missing spreadsheet values before calculating averages

A blank duration can change what an average describes. If a puzzle activity log has three recorded durations and a fourth applicable occasion with no recorded duration, you can calculate the mean of the three known values. You cannot call it the mean of all four occasions. Treat missing spreadsheet values as a question about what is known before deciding what belongs in the denominator, whether you review the log on a Dell Inspiron laptop or elsewhere.

Calculate elapsed time across midnight guide to checking dates and time intervals in an observation log.
9 min read

How to calculate elapsed time across midnight

A clock reading identifies a time of day, but a duration needs two dated readings. To calculate elapsed time in an overnight equipment-observation log, write down when the observation began and ended, including the date on each entry. Then count from the start to midnight and from midnight to the documented finish. An earlier-looking finish clock time does not, by itself, tell you which day that finish occurred. For calculate elapsed time , verify each step.

Data & Spreadsheets Guides | Republeq