Spreadsheet: 59061d1259479962-multipal-if-formatting-cases-in-presize-coloum-temp_avk
Sheet: Sheet1

CUSTOMER NAME :- |  | ABCDE
SR.NO :- |  | 12.1111.09.999
K.V.A.                                             :- |  | 400
SITE CONDITIN : (NORMAL, DUSTY, VERY DUSTY) |  | NORMAL
 | PARTNO | DESC | KVA | FOR 320 kva QTY | FOR 400 kva QTY | FOR 500 kva QTY | FOR 600 kva QTY | Total | change period (in hrs) | Per day engine running (in hrs) | change after no.of days | last change date | next change due date
 | 1111111 | ABCJDJD |  | 30 | 35 | 35 | 35 | 135 | 250 | 7 | 35.71428571428572 | 2009-01-11 00:00:00 | 2009-02-15 17:08:34
 | 2222222 | LOF |  | 2 | 2 | 2 | 2 | 8 | 250 | 7 | 35.71428571428572 | 2009-01-11 00:00:00 | 2009-02-15 17:08:34
 | 333333 | FFA |  | 1 | 1 | 1 | 1 | 4 | 250 | 7 | 35.71428571428572 | 2009-01-11 00:00:00 | 2009-02-15 17:08:34
 | 444444 | FPA |  | 1 | 1 | 1 | 1 | 4 | 250 | 7 | 35.71428571428572 | 2009-01-11 00:00:00 | 2009-02-15 17:08:34
Applicable for if site condition is normal | 55555 | ACP500 | 500 |  |  | 2 |  | 2 | 1000 | 7
 | 555551 | ACS500 | 500 |  |  | 2 |  | 2 | 1000 | 7 | 142.8571428571429 | 2009-01-11 00:00:00 | 2009-06-02 20:34:17
 | 666666 | ACP320 | 320 | 1 |  |  |  | 1 | 1000 | 7 | 142.8571428571429 | 2009-01-11 00:00:00 | 2009-06-02 20:34:17
 | 6666661 | ACS320 | 320 | 1 |  |  |  | 1 | 1000 | 7 | 142.8571428571429 | 2009-01-11 00:00:00 | 2009-06-02 20:34:17
 | 7777 | ACP600 | 600 |  |  |  | 2 | 2 | 1000 | 7 | 142.8571428571429 | 2009-01-11 00:00:00 | 2009-06-02 20:34:17
 | 77771 | ACS600 | 600 |  |  |  | 2 | 2 | 1000 | 7 | 142.8571428571429 | 2009-01-11 00:00:00 | 2009-06-02 20:34:17
 | 8888 | ACP400 | 400 |  | 2 |  |  | 2 | 1000 | 7 |  | 2009-01-11 00:00:00 | #N/A
 | 88881 | ACS400 | 400 |  | 2 |  |  | 2 | 1000 | 7 |  | 2009-01-11 00:00:00 | #N/A
Applicable for if site condition is DUSTY | 55555 | ACP500 | 500 |  |  | 2 |  | 2 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09
 | 555551 | ACS500 | 500 |  |  | 2 |  | 2 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09
 | 666666 | ACP320 | 320 | 1 |  |  |  | 1 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09
 | 6666661 | ACS320 | 320 | 1 |  |  |  | 1 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09
 | 7777 | ACP600 | 600 |  |  |  | 2 | 2 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09
 | 77771 | ACS600 | 600 |  |  |  | 2 | 2 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09
 | 8888 | ACP400 | 400 |  | 2 |  |  | 2 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09
 | 88881 | ACS400 | 400 |  | 2 |  |  | 2 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09
Applicable for if site condition is VERY DUSTY (or as per required but less then 500 hrs. Depend on Element condition | 55555 | ACP500 | 500 |  |  | 2 |  | 2 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09
 | 555551 | ACS500 | 500 |  |  | 2 |  | 2 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09
 | 666666 | ACP320 | 320 | 1 |  |  |  | 1 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09
 | 6666661 | ACS320 | 320 | 1 |  |  |  | 1 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09
 | 7777 | ACP600 | 600 |  |  |  | 2 | 2 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09
 | 77771 | ACS600 | 600 |  |  |  | 2 | 2 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09
 | 8888 | ACP400 | 400 |  | 2 |  |  | 2 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09
 | 88881 | ACS400 | 400 |  | 2 |  |  | 2 | 500 | 7 | 71.42857142857143 | 2009-01-11 00:00:00 | 2009-03-23 10:17:09