Calculated ranges to be used inside another function about formulas HOT 1 CLOSED

import formulas
import pandas as pd
import schedula as sh

n = 10000  # Problem size.

# Model definition.
model = formulas.ExcelModel().from_dict(sh.combine_dicts(
    {f'A{i}': f'= B{i} + 1' for i in range(1, n + 1)},
    {'C4': f'=SUM(A1:A{n})'}
))

# Raw dataset (Pandas excel like).
xl_df = pd.DataFrame(
    data=list(range(1, n + 1)), index=list(range(1, n + 1)), columns=['B']
)

# Prepare inputs.
inputs = {
    '%s%d' % k: v
    for k, v in sh.stack_nested_keys(xl_df.to_dict('dict'), depth=2)
}
# Run model.
sol = model.calculate(inputs)  

# Validate results.
assert sol['C4'].value[0][0] == (sum(list(range(1, n + 1))) + n)