Spreadsheet: 759043d1639257805-need-help-in-formula-completion-of-the-sales-form-template
Sheet: West 1 Funnel

[NAME] for West 1
[NAME] | [NAME] |  | email: |  | [EMAIL]
Supervisor | [NAME] |  | email:
List of Open Oppurtunities
Date of Creation | Account | Products | Model | Quantity | Value in INR Without GST | Value in USD | Value in INR Converted | Latest Update | Oppurtunity Type | Closure Date | Status | Won / Lost | Reminder
2021-04-01 00:00:00 |  | P-Series |  | 1 | 2000000 |  | 0 |  | A |  | Open
2021-04-02 00:00:00 |  | N-Series |  | 9 | 8623500 |  |  |  | B+ Upside |  | Close | Won
2021-04-03 00:00:00 |  | P-Series |  | 16 | 1789666 |  |  |  | B+30 |  | Close | Lost
2021-04-04 00:00:00 |  | Preparative LC |  | 22 | 1500000 |  |  |  | B |  | Close | Won
2021-04-05 00:00:00 |  | LCMS TQ |  | 2 | 59635884 |  |  |  | B
2021-04-06 00:00:00 |  | LCMS SQ |  | 40 | 515325 |  |  |  | B+ Upside
2021-04-07 00:00:00 |  | LCMS Q ToF |  | 25 | 932567 |  |  |  | B+30
2021-04-08 00:00:00 |  | PPSQ |  | 69 | 6398522 |  |  |  | B+60
2021-04-09 00:00:00 |  | iSeries Plus |  | 33 | 563298745 |  |  |  | B+30
2021-04-10 00:00:00 |  | N-Series |  | 62 | 56566556 |  |  |  | B+60
2021-04-11 00:00:00 |  |  |  |  |  |  |  |  | B+ Upside
2021-04-12 00:00:00 |  | iSeries Plus |  |  |  |  |  |  | B+30
Total
Products |  |  |  | Quantity | Value
P-Series
iSeries Plus
N-Series
Preparative LC
LCMS TQ
LCMS SQ
LCMS Q ToF
PPSQ
MALDI
Ipkg Labsolutions CS
Labsolution Bix
i-LIMS/ LIMS
Kits
Columns
Software Upgrade
List of Closed Won Oppurtunities
Date of Creation | Account | Products | Model | Quantity | Value in INR Without GST | Value in USD | Value in INR Converted | Latest Update | Memorable Installation date | Closure Date | Position
2021-04-01 00:00:00 |  | iSeries Plus |  |  |  |  | 0 |  |  | 2021-04-01 00:00:00
2021-04-02 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-02 00:00:00
2021-04-03 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-03 00:00:00
2021-04-04 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-04 00:00:00
2021-04-05 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-05 00:00:00
2021-04-06 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00
2021-04-07 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-07 00:00:00
2021-04-08 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-08 00:00:00
2021-04-09 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-09 00:00:00
2021-04-10 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-10 00:00:00
2021-04-11 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-11 00:00:00
2021-04-12 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-12 00:00:00
2021-04-13 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-13 00:00:00
2021-04-14 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-14 00:00:00
2021-04-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-15 00:00:00
2021-04-16 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-16 00:00:00
2021-04-17 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-17 00:00:00
2021-04-18 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-18 00:00:00
2021-04-19 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-19 00:00:00
2021-04-20 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-20 00:00:00
2021-04-21 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-21 00:00:00
2021-04-22 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-22 00:00:00
2021-04-23 00:00:00
2021-04-23 00:00:00
2021-04-23 00:00:00
Total
List of Closed Lost Oppurtunities
Date of Creation | Account | Products | Model | Quantity | Value in INR Without GST | Value in USD | Value in INR Converted | Competitor | Oppurtunity Type | Closure Date
2021-04-01 00:00:00 |  | iSeries Plus |  |  |  |  | 0 |  |  | 2021-04-01 00:00:00
2021-04-02 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-02 00:00:00
2021-04-03 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-03 00:00:00
2021-04-04 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-04 00:00:00
2021-04-05 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-05 00:00:00
2021-04-06 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00
2021-04-07 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-07 00:00:00
2021-04-08 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-08 00:00:00
2021-04-09 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-09 00:00:00
2021-04-10 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-10 00:00:00
2021-04-11 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-11 00:00:00
2021-04-12 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-12 00:00:00
2021-04-13 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-13 00:00:00
2021-04-14 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-14 00:00:00
2021-04-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-15 00:00:00
2021-04-16 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-16 00:00:00
2021-04-17 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-17 00:00:00
2021-04-18 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-18 00:00:00
2021-04-19 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-19 00:00:00
2021-04-20 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-20 00:00:00
2021-04-21 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-21 00:00:00
2021-04-22 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-22 00:00:00
2021-04-23 00:00:00
2021-04-23 00:00:00
2021-04-23 00:00:00