search

oglinked / Receipt

0 stars 1 forks source link

SCRIPT#4 Excel Accounting #6

Open FutureITCorp opened 11 months ago

FutureITCorp commented 11 months ago

del_Book1_TestData.xlsx

FutureITCorp commented 11 months ago

The task: The problem column is column "I". See how numbers are calculated:

=Value for the previous day + [all values from D column of the same date are positive] + [ all values from N column of the same date are negative].

How the program should work. User's perspective: I select a cell, e.g. I36, then I run Pyhon script and formula is populated to that cell and calculation happen, then I go to I37 and run Python script again, then I37 gets populated with a formula.

Possible algorithm, approximately: Select cell I36, then launch Python script. script takes date from H36 column - Date1, then looks all values in column B starting from cell B13 and downwards, find dates that match Date1 and takes corresponding values from D column and adds those values from D column to the formula in I36, then script looks all values in column "L" and searches Date1 and then takes corresponding values from "N" column and then deducts from formula in I36.

FutureITCorp commented 10 months ago

del_Book1_WollPayAccounting1_238323984

FutureITCorp commented 10 months ago

del_Book1_WollPayAccounting1_238323984.zip Uploading .zip, because the previous upload was corrupted during transferring