Skip to content

aswath86/Spreadsheet-Calculator

Repository files navigation

Spreadsheet-Calculator

This exercise is one of my latest test assignments, you know... The architecture is draft and the exercise was completed in 3.45 hours, so obviously it's not the best of the codes that I have developed.

##how to run

To run application, just use command like this: "cat ~/program_dir/input.txt | java dglad.calc.App" while standing in /spreadcalc/target/classes folder. You can use Maven's "mvn clean compile" or open it with IntelliJ IDEA with (.iml file already there).

##assignment description

Spreadsheet Calculator

A spreadsheet consists of a two—dimensional array of cells, labeled A1, A2, etc. Rows are identified using letters, columns by numbers. Each cell contains either an integer (its value) or an expression. Expressions contain integers, cell references, and the operators ‘+', ‘—‘, ‘*‘, ‘/‘ with the usual rules of evaluation — note that the input is RPN and should be evaluated in stack order.

Write a program (in Java or Scala) to read a spreadsheet from ’stdin’ via file input.txt, evaluate the values of all the cells, and write the output to ’stdout’.

The spreadsheet input is defined as follows:

° Line 1: two integers, defining the width and height ofthe spreadsheet (n, m)

° n*m lines each containing an expression which is the value of the corresponding cell (cells enumerated in the order A1, A2, A, B1,...)

Your program must output its data in the same format, but each cell should be reduced to a single floating—point value.

So basically your program must evaluate spreadsheets like this:

Assignment

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages