CCC '04 S3 - Spreadsheet - DMOJ: Modern Online Judge

CCC '04 S3 - Spreadsheet

View as PDF

Submit solution

All submissions

Best submissions

Points: 10

Time limit: 1.0s

Memory limit: 256M

Problem type

Canadian Computing Competition: 2004 Stage 1, Senior #3

A spreadsheet consists of a number of "cells" set in a rectangular grid. Each is addressed with one letter from $A$ ~A~ to $J$ ~J~ (giving the row) and one number from $1$ ~1~ to $9$ ~9~ (giving the column). Thus the upper-left cell of the spreadsheet is $A1$ ~A1~, and the lower-right cell is $J9$ ~J9~.

Every cell has a value, and this can be specified in one of two ways:

as an integer from $0$ ~0~ to $1000$ ~1000~
as a sum of the values of up to $10$ ~10~ other cells

Cell values may be interdependent (that is, $A1$ ~A1~'s sum may depend on $B6$ ~B6~ which depends on $C9$ ~C9~), but a cell whose value depends on itself, directly or indirectly, is undefined (e.g., $A1$ ~A1~ depending on $G8$ ~G8~ depending on $A1$ ~A1~). Also, a cell whose value depends on an undefined cell is itself undefined. You are given the specification for all the cells in the spreadsheet. Compute and output the values of all of the cells.

Input Specification

Input will consist of $10$ ~10~ lines, one per spreadsheet row. Each line contains 9 descriptions of a cell, which will be either an integer between $0$ ~0~ and $1\,000$ ~1\,000~, or a sum of $1$ ~1~ to $10$ ~10~ distinct cell names separated by a + symbol (e.g. A1+B5+D3).

Output Specification

Output $10$ ~10~ lines, with $9$ ~9~ numbers per line, giving the value of every cell in the spreadsheet; if the cell is undefined, print an asterisk (*) in place of its value. No cell's final value will exceed $1\,000\,000\,000$ ~1\,000\,000\,000~.

Sample Input

1 2 3 A1+A2+A3 A3+A4 A1+A4+A5 A8+A9 A9 A8
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0

Sample Output

1 2 3 6 9 16 * * *
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0

Comments

1

Evan commented on Oct. 16, 2020, 2:11 p.m. ← edit 16 →

why does the problem text look so weird (lots of slash slash bracket)

Edit: seems to be just me, dunno why this is happening

Edit 2: why does this work when I don't log in but then its broken when I log in

9

Kirito commented on Oct. 16, 2020, 8:13 p.m. ← edited →

Your math engine is set to "Leave as LaTeX" on your profile, so you're seeing the raw LaTeX code instead of the rendered end result.

You can fix this by editing your profile settings and changing the "Math engine" option. I would advise the "Detect best quality" option.

3

Evan commented on Oct. 18, 2020, 4:48 p.m.

Thanks

-22

ykozxy commented on Jan. 23, 2019, 11:16 a.m.

It's just like an Excel worksheet! LOL

This comment is hidden due to too much negative feedback. Show it anyway.

37

JimmyDeng12345 commented on Sept. 29, 2018, 6:41 a.m.

I'm stuck on this problem for so long... I am getting mental issues off of this crap