logisheets_controller 1.16.1

Core spreadsheet engine for LogiSheets: formula evaluation, dependency tracking, and undo/redo.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

use super::utils::{collect_f64_series, convert_f64};
use super::{CalcValue, CalcVertex};
use crate::calc_engine::calculator::math::xnpv::calc_xnpv;
use crate::calc_engine::connector::Connector;
use logisheets_parser::ast;

/// `XNPV(rate, values, dates)` — net present value of a dated cash-flow
/// schedule. `values` and `dates` pair by position.
pub fn calc<C>(args: Vec<CalcVertex>, fetcher: &mut C) -> CalcVertex
where
    C: Connector,
{
    if args.len() != 3 {
        return CalcVertex::from_error(ast::Error::Unspecified);
    }
    let mut it = args.into_iter();

    let rate = match fetcher.get_calc_value(it.next().unwrap()) {
        CalcValue::Scalar(v) => match convert_f64(v) {
            Ok(r) => r,
            Err(e) => return CalcVertex::from_error(e),
        },
        _ => return CalcVertex::from_error(ast::Error::Value),
    };
    let values = match collect_f64_series(fetcher.get_calc_value(it.next().unwrap())) {
        Ok(v) => v,
        Err(e) => return CalcVertex::from_error(e),
    };
    let dates = match collect_f64_series(fetcher.get_calc_value(it.next().unwrap())) {
        Ok(v) => v,
        Err(e) => return CalcVertex::from_error(e),
    };

    match calc_xnpv(rate, &values, &dates) {
        Some(n) => CalcVertex::from_number(n),
        None => CalcVertex::from_error(ast::Error::Num),
    }
}