Options
Attribute Settings
Mask Examples
The formatting function can be used separately from the math widget:
Value to use:
Prefix: ( add
Suffix: ( add
// $.tablesorter.formatMask(mask, value, prefix, suffix); $.tablesorter.formatMask('$#,##0.00 USD', 12345.678, 'prefix ', ' suffix'); // result: "prefix $12,345.68 USD suffix"
- The
$.tablesorter.formatMask
function has the following parameters:mask
- please refer to themath_mask
option for more details.value
- number to be formatted.prefix
- please refer to themath_prefix
option for more details (v2.16.4).suffix
- please refer to themath_suffix
option for more details (v2.16.4).
Experiment with the mask:
Value to use:
Prefix: ( add
{content}
to include the mask prefix )Suffix: ( add
{content}
to include the mask suffix )
Back to index
Name | Saving | Loan date | Loan Amt | Deposit Amt | Balance Amt | Interest Paid | Penalty Paid |
---|---|---|---|---|---|---|---|
Column Totals | col-sum | col-sum | col-sum | col-sum | |||
Balram Somnani | 54000 | 2023-11 | 0 | 0 | 0 | 0 | 1170 |
Nitin Chalak | 42000 | 2024-07 | 400000 | 60000 | 400000 | 38940 | 1480 |
Ravi Mesharam | 42000 | 2023-05 | 100000 | 22746 | 77254 | 28239 | 909 |
Anil Tidke | 41000 | 2022-08 | 100000 | 11000 | 89000 | 51340 | 7420 |
Kishor Pachbhai | 42000 | 0 | 0 | 0 | 0 | 10 | |
Pankaj Ghormode | 42000 | 2022-02 | 50000 | 50000 | 0 | 12642 | 23191 |
Gajendra Domale | 42000 | 2022-04 | 100000 | 50000 | 50000 | 33560 | 12550 |
Samser Pathan | 42000 | 0 | 0 | 0 | 0 | 0 | |
Firoz Lalani | 42000 | 2024-06 | 100000 | 160000 | 90000 | 33906 | 10 |
Ravindra Bhandarwar | 42000 | 0 | 0 | 0 | 0 | 0 | |
Rupraj wakode | 42000 | 2022-09 | 80000 | 66000 | 14000 | 28740 | 0 |
Nilesh Tonge | 42000 | 0 | 0 | 0 | 0 | 0 | |
Sadashiv Mandawar | 43000 | 0 | 0 | 0 | 0 | 0 | |
Vijay Sunatkar | 43000 | 0 | 0 | 0 | 0 | 0 | |
Dipak Sunatkar | 42000 | 2023-11 | 50000 | 11000 | 39000 | 9120 | -180 |
Sachin Kukde | 43000 | 2023-09 | 100000 | 100000 | 0 | 6000 | 0 |
Dr Bhupendra Uike | 43000 | 2023-12 | 300000 | 275000 | 25000 | 23020 | 0 |
Ganesh Kewatkar | 42000 | 0 | 0 | 0 | 0 | 0 | |
Amol kukudkar | 42000 | 0 | 0 | 0 | 0 | 0 | |
Raman Gagapurwar | 43000 | 0 | 0 | 0 | 0 | 10 | |
Nitesh Khadse- | 42000 | 0 | 0 | 0 | 0 | 490 | |
Ajay Kukadkar | 42000 | 0 | 0 | 0 | 0 | 0 | |
Milind Khond | 42000 | 2021-09 | 15000 | 41000 | 4000 | 10520 | 300 |
Avinash Bhandekar | 43000 | 0 | 0 | 0 | 0 | 0 | |
Kuldip Gaurkar | 42000 | 0 | 0 | 0 | 0 | -30 | |
Farukh Sheikh | 42000 | 2022-02 | 70000 | 11000 | 59000 | 37140 | 8140 |
Shekhar Fulmali | 38000 | 0 | 0 | 0 | 0 | 0 | |
Ashish Bharne | 42000 | 2022-01 | 50000 | 21000 | 29000 | 16540 | 2026 |
Om Pawar | 43000 | 0 | 0 | 0 | 0 | 100 | |
Baba Umare | 42000 | 2024-07 | 300000 | 110000 | 290000 | 49680 | 0 |
Jagdish Konde | 42000 | 2022-03 | 100000 | 100000 | 0 | 14770 | 9420 |
Rakesh Watekar | 42000 | 2023-11 | 100000 | 11000 | 89000 | 15990 | 0 |
Swapnil Mane | 42000 | 0 | 0 | 0 | 0 | 0 | |
Ashish Deshmukh | 43000 | 0 | 0 | 0 | 0 | 0 | |
Pradip Madavi | 43000 | 0 | 0 | 0 | 0 | 240 | |
hemraj Banble | 42000 | 2024-06 | 50000 | 150000 | 50000 | 24400 | 8360 |
Chhotu Yadav | 42000 | 2023-10 | 500000 | 211000 | 489000 | 103170 | 0 |
Kunal Pendorkar | 42000 | 2024-07 | 100000 | 50000 | 100000 | 13363 | 8960 |
Keshav Hukre | 42000 | 0 | 0 | 0 | 0 | 0 | |
Shrikant Patrange | 42000 | 0 | 0 | 0 | 0 | 0 | |
Tushar Chopkar | 42000 | 0 | 0 | 0 | 0 | 0 | |
Mayur Rahate | 42000 | 0 | 0 | 0 | 0 | 0 | |
Ravi Kamble | 42000 | 2022-02 | 100000 | 100000 | 0 | 14000 | 2270 |
Prem Kumar Durge | 42000 | 0 | 0 | 0 | 0 | 20 | |
Pramod Dhore | 43000 | 0 | 0 | 0 | 0 | 10 | |
Mahesh Kukadkar | 42000 | 0 | 0 | 0 | 0 | 0 | |
Nandu Pote | 21000 | 2022-03 | 80000 | 30000 | 80000 | 15300 | 10820 |
nitin Thakre | 42000 | 0 | 0 | 0 | 0 | 80 | |
Manoj Devkule | 49000 | 0 | 0 | 0 | 0 | 70 | |
Satish Trinagari | 50000 | 0 | 0 | 0 | 0 | 7150 | |
Ajay Sahare | 41000 | 0 | 0 | 0 | 0 | 3650 | |
Yashvant Durge | 41000 | 0 | 0 | 0 | 0 | 3600 | |
Shubham Konde | 41000 | 2023-07 | 40000 | 100000 | 0 | 8250 | 3620 |
Mohnish Chiye | 29000 | 2022-05 | 40000 | 11000 | 29000 | 16580 | 16942 |
Suresh Nagrale | 42000 | 2023-07 | 100000 | 11220 | 88780 | 27823 | 3800 |
Ramesh Faye | 42000 | 0 | 0 | 0 | 0 | 3800 | |
Subhash Bhoyar | 42000 | 2022-03 | 40000 | 41000 | 29000 | 23740 | 1960 |
Ravi Mogilwar | 42000 | 2024-04 | 100000 | 41000 | 89000 | 20900 | 9022 |
Aniket Agrawal | 42000 | 0 | 0 | 0 | 0 | 0 | |
Total | above-sum | above-sum | above-sum | above-sum | |||
Middle | row-sum | ||||||
Name | Saving | Loan date | Loan Amt | Deposit Amt | Balance Amt | Interest Paid | Penalty Paid |