- As we entered runs for each ball in a over, now we will calculate total runs in each over.
- For that we have to do addition of all the runs in that over's row.
- But before we do addition we also have to think about extra runs in each over, whose values are in "symbols" and not in numbers.
- As spreadsheet will not automatically come to know about how much run to add for wide ball, no ball, byes runs etc., we need to add those runs manually
- So we will add one more column on left side, before “Total Runs in Over” column as “Extras”
- We will add extra runs manually by doing observations for extra runs.
- So the entries will happen as
- W is wicket fallen, so we should not count runs for that.
- 1 run for Wd (Wide ball)
- 5 runs for 5Wd (4 runs and wide ball)
- 1 run for NB (No ball if any)
- 1 run for 1B (1 byes run), 2 for 2B
[Contributed by administrator on 15. März 2018 15:03:10]