{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":170,"n_cols":14,"rows_kept":170,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,10,1,15]]}
["Время для работ в день",null,{"$f":"F1-E1-F2+E2","v":"08:00:00"},"Рабочий день","08:30:00","17:30:00",null,null,null,null,"Верно для случая когда ОТКРЫТО и ЗАКРЫТО имеют одно и тоже число и в пределах рабочего времени"]
[null,null,null,"Обед","12:00:00","13:00:00"]
["ДЛИТЕЛЬНОСТЬ РАБОТ \nE-D\n(ЧАС:МИН:СЕК)","Количество затронутых суток","Количество рабочих дней в часах","НАЧАЛО","КОНЕЦ","НАЧАЛО (ТОЛЬКО ВРЕМЯ)","КОНЕЦ (ТОЛЬКО ВРЕМЯ)","Чистое время работ","Тоже от колонок G,H","День недели НАЧАЛО","День недели КОНЕЦ",null,null,"UDF (до минут)"]
[5.4745370362070389E-3,{"$f":"NETWORKDAYS(D4,IF(E4=\"\",TODAY(),E4))","v":1},{"$f":"$C$1*B4","v":"08:00:00"},"2012-07-19T10:26:41","2012-07-19T10:34:34",{"$f":"MOD(D4,1)","v":"10:26:41"},{"$f":"MOD(E4,1)","v":"10:34:34"},{"$f":"C4-IF((OR(WEEKDAY(D4)=1,WEEKDAY(D4)=7)),0,(IF(MOD(D4,1)<$E$1,0,(IF(AND($E$1<MOD(D4,1),MOD(D4,1)<$E$2),MOD(D4,1)-$E$1,(IF(AND($E$2<MOD(D4,1),MOD(D4,1)<$F$2),$E$2-$E$1,(IF(AND($F$2<MOD(D4,1),MOD(D4,1)<$F$1),$E$2-$E$1+MOD(D4,1)-$F$2,(IF(MOD(D4,1)>$F$1,$C$1)))))))))))-IF((OR(WEEKDAY(IF(E4=\"\",TODAY(),E4))=1,WEEKDAY(IF(E4=\"\",TODAY(),E4))=7)),0,(IF(MOD(IF(E4=\"\",TODAY(),E4),1)<$E$1,$C$1,(IF(AND($E$1<MOD(IF(E4=\"\",TODAY(),E4),1),MOD(IF(E4=\"\",TODAY(),E4),1)<$E$2),$F$1-$F$2+$E$2-MOD(IF(E4=\"\",TODAY(),E4),1),(IF(AND($E$2<MOD(IF(E4=\"\",TODAY(),E4),1),MOD(IF(E4=\"\",TODAY(),E4),1)<$F$2),$F$1-$F$2,(IF(AND($F$2<MOD(IF(E4=\"\",TODAY(),E4),1),MOD(IF(E4=\"\",TODAY(),E4),1)<$F$1),$F$1-MOD(IF(E4=\"\",TODAY(),E4),1),(IF(MOD(IF(E4=\"\",TODAY(),E4),1)>$F$1,0)))))))))))","v":5.4745370362070389E-3},{"$f":"C4-(IF(F4<$E$1,0,(IF(AND($E$1<F4,F4<$E$2),F4-$E$1,(IF(AND($E$2<F4,F4<$F$2),$E$2-$E$1,(IF(AND($F$2<F4,F4<$F$1),$E$2-$E$1+F4-$F$2,(IF(F4>$F$1,$C$1))))))))))-(IF(G4<$E$1,$C$1,(IF(AND($E$1<G4,G4<$E$2),$F$1-$F$2+$E$2-G4,(IF(AND($E$2<G4,G4<$F$2),$F$1-$F$2,(IF(AND($F$2<G4,G4<$F$1),$F$1-G4,(IF(G4>$F$1,0))))))))))","v":5.4745370362070389E-3},{"$f":"WEEKDAY(D4,2)","v":4},{"$f":"WEEKDAY(E4,2)","v":4},null,{"$f":"(WEEKDAY(D4,2)<6)*($E$2-MAX(MIN(MOD(D4,1),$E$2),$E$1)+$F$1-MAX(MIN(MOD(D4,1),$F$1),$F$2))+(WEEKDAY(E4,2)<6)*(MAX(MIN(MOD(E4,1),$E$2),$E$1)-$E$1+MAX(MIN(MOD(E4,1),$F$1),$F$2)-$F$2)+(NETWORKDAYS(WORKDAY(D4+1,-1),WORKDAY(E4-1,1))-2)*$C$1","v":5.4745370362070944E-3},{"$f":"NetWorkTime(D4,E4)","v":5.5555555555555558E-3}]
[5.7407407439313829E-3,1,{"$f":"$C$1*B5","v":0.33333333333333331},"2012-07-17T15:41:59","2012-07-17T15:50:15","15:41:59","15:50:15",5.7407407439314384E-3,5.7407407439314384E-3,2,2,null,{"$f":"(WEEKDAY(D5,2)<6)*($E$2-MAX(MIN(MOD(D5,1),$E$2),$E$1)+$F$1-MAX(MIN(MOD(D5,1),$F$1),$F$2))+(WEEKDAY(E5,2)<6)*(MAX(MIN(MOD(E5,1),$E$2),$E$1)-$E$1+MAX(MIN(MOD(E5,1),$F$1),$F$2)-$F$2)+(NETWORKDAYS(WORKDAY(D5+1,-1),WORKDAY(E5-1,1))-2)*$C$1","v":5.7407407439313274E-3},{"$f":"NetWorkTime(D5,E5)","v":5.5555555555555558E-3}]
[1.2210648150357883E-2,1,0.33333333333333331,"2012-07-13T09:47:04","2012-07-13T10:04:39","09:47:04","10:04:39",1.2210648150357883E-2,1.2210648150357883E-2,5,5,null,1.2210648150357939E-2,1.2500000000000001E-2]
[1.4861111107165925E-2,1,0.33333333333333331,"2012-07-17T13:41:18","2012-07-17T14:02:42","13:41:18","14:02:42",1.4861111107165981E-2,1.4861111107165981E-2,2,2,null,1.486111110716587E-2,{"$f":"NetWorkTime(D7,E7)","v":1.5277777777777777E-2}]
[1.5439814815181307E-2,1,0.33333333333333331,"2012-07-06T14:57:22","2012-07-06T15:19:36","14:57:22","15:19:36",1.5439814815181363E-2,1.5439814815181363E-2,5,5,null,1.5439814815181252E-2,1.5972222222222221E-2]
[1.6562500000873115E-2,1,0.33333333333333331,"2012-07-04T12:47:14","2012-07-04T13:11:05","12:47:14","13:11:05",7.6967592588820244E-3,7.6967592588820244E-3,3,3,null,7.6967592588819689E-3,7.6388888888888886E-3]
[1.6805555555038154E-2,1,0.33333333333333331,"2012-07-20T14:57:51","2012-07-20T15:22:03","14:57:51","15:22:03",1.680555555503821E-2,1.680555555503821E-2,5,5,null,1.6805555555038099E-2,1.6666666666666666E-2]
[1.8298611110367347E-2,1,0.33333333333333331,"2012-07-11T15:12:32","2012-07-11T15:38:53","15:12:32","15:38:53",1.8298611110367402E-2,1.8298611110367402E-2,3,3,null,1.8298611110367291E-2,1.8055555555555554E-2]
[1.9108796295768116E-2,1,0.33333333333333331,"2012-07-12T16:07:11","2012-07-12T16:34:42","16:07:11","16:34:42",1.9108796295768171E-2,1.9108796295768171E-2,4,4,null,1.910879629576806E-2,1.9444444444444445E-2]
[1.9259259257523809E-2,1,0.33333333333333331,"2012-07-20T13:59:14","2012-07-20T14:26:58","13:59:14","14:26:58",1.9259259257523864E-2,1.9259259257523864E-2,5,5,null,1.9259259257523753E-2,1.9444444444444445E-2]
[2.0243055550963618E-2,1,0.33333333333333331,"2012-07-04T10:32:53","2012-07-04T11:02:02","10:32:53","11:02:02",2.0243055550963618E-2,2.0243055550963618E-2,3,3,null,2.0243055550963673E-2,2.013888888888889E-2]
[2.0844907405262347E-2,1,0.33333333333333331,"2012-07-13T11:33:14","2012-07-13T12:03:15","11:33:14","12:03:15",1.8587962964375038E-2,1.8587962964375038E-2,5,5,null,1.8587962964375093E-2,{"$f":"NetWorkTime(D15,E15)","v":1.8749999999999999E-2}]
[2.1226851851679385E-2,1,0.33333333333333331,"2012-07-03T10:29:24","2012-07-03T10:59:58","10:29:24","10:59:58",2.1226851851679385E-2,2.1226851851679385E-2,2,2,null,2.122685185167944E-2,2.1527777777777778E-2]
[2.1875000005820766E-2,1,0.33333333333333331,"2012-07-17T13:39:45","2012-07-17T14:11:15","13:39:45","14:11:15",2.1875000005820822E-2,2.1875000005820822E-2,2,2,null,2.1875000005820711E-2,2.1527777777777778E-2]
[2.3622685184818693E-2,1,0.33333333333333331,"2012-07-12T15:31:37","2012-07-12T16:05:38","15:31:37","16:05:38",2.3622685184818748E-2,2.3622685184818748E-2,4,4,null,2.3622685184818637E-2,2.361111111111111E-2]
[2.6782407410792075E-2,1,0.33333333333333331,"2012-07-19T11:50:27","2012-07-19T12:29:01","11:50:27","12:29:01",6.6319444449618459E-3,6.6319444449618459E-3,4,4,null,6.6319444449619014E-3,6.9444444444444441E-3]
[2.7118055557366461E-2,1,0.33333333333333331,"2012-07-19T11:49:39","2012-07-19T12:28:42","11:49:39","12:28:42",7.1874999994179234E-3,7.1874999994179234E-3,4,4,null,7.1874999994179789E-3,6.9444444444444441E-3]
[3.7453703698702157E-2,1,0.33333333333333331,"2012-07-06T15:27:24","2012-07-06T16:21:20","15:27:24","16:21:20",3.7453703698702212E-2,3.7453703698702212E-2,5,5,null,3.7453703698702101E-2,3.7499999999999999E-2]
[3.8680555553582963E-2,1,0.33333333333333331,"2012-07-17T15:32:36","2012-07-17T16:28:18","15:32:36","16:28:18",3.8680555553583018E-2,3.8680555553583018E-2,2,2,null,3.8680555553582907E-2,3.8194444444444448E-2]
[4.3969907404971309E-2,1,0.33333333333333331,"2012-07-19T11:05:36","2012-07-19T12:08:55","11:05:36","12:08:55",3.7777777775772847E-2,3.7777777775772847E-2,4,4,null,3.7777777775772903E-2,3.7499999999999999E-2]
[4.4189814812853001E-2,1,0.33333333333333331,"2012-07-10T16:01:52","2012-07-10T17:05:30","16:01:52","17:05:30",4.4189814812853057E-2,4.4189814812853057E-2,2,2,null,4.4189814812852946E-2,{"$f":"NetWorkTime(D24,E24)","v":4.4444444444444446E-2}]
[4.5868055553000886E-2,1,0.33333333333333331,"2012-07-13T09:55:54","2012-07-13T11:01:57","09:55:54","11:01:57",4.5868055553000886E-2,4.5868055553000886E-2,5,5,null,4.5868055553000942E-2,4.583333333333333E-2]
[4.670138889196096E-2,1,0.33333333333333331,"2012-07-10T12:01:33","2012-07-10T13:08:48","12:01:33","13:08:48",6.1111111111434857E-3,6.1111111111434857E-3,2,2,null,6.1111111111434302E-3,6.2500000000000003E-3]
[4.6886574076779652E-2,1,0.33333333333333331,"2012-07-09T13:54:30","2012-07-09T15:02:01","13:54:30","15:02:01",4.6886574076779708E-2,4.6886574076779708E-2,1,1,null,4.6886574076779597E-2,4.7222222222222221E-2]
[4.962962962599704E-2,1,0.33333333333333331,"2012-07-11T11:14:29","2012-07-11T12:25:57","11:14:29","12:25:57",3.1608796292857733E-2,3.1608796292857733E-2,3,3,null,3.1608796292857788E-2,3.1944444444444442E-2]
[4.9918981487280689E-2,1,0.33333333333333331,"2012-07-04T10:03:35","2012-07-04T11:15:28","10:03:35","11:15:28",4.9918981487280689E-2,4.9918981487280689E-2,3,3,null,4.9918981487280745E-2,4.9305555555555554E-2]
[5.0902777773444541E-2,1,0.33333333333333331,"2012-07-12T14:48:16","2012-07-12T16:01:34","14:48:16","16:01:34",5.0902777773444596E-2,5.0902777773444596E-2,4,4,null,5.0902777773444485E-2,5.1388888888888887E-2]
[5.3611111106874887E-2,1,0.33333333333333331,"2012-07-10T15:47:53","2012-07-10T17:05:05","15:47:53","17:05:05",5.3611111106874942E-2,5.3611111106874942E-2,2,2,null,5.3611111106874831E-2,5.347222222222222E-2]
[5.5185185185109731E-2,1,0.33333333333333331,"2012-07-25T09:41:08","2012-07-25T11:00:36","09:41:08","11:00:36",5.5185185185109731E-2,5.5185185185109731E-2,3,3,null,5.5185185185109786E-2,5.5555555555555552E-2]
[5.9479166666278616E-2,1,0.33333333333333331,"2012-07-19T09:47:34","2012-07-19T11:13:13","09:47:34","11:13:13",5.9479166666278616E-2,5.9479166666278616E-2,4,4,null,5.9479166666278671E-2,5.9027777777777776E-2]
[6.0185185182490386E-2,1,0.33333333333333331,"2012-07-20T09:38:28","2012-07-20T11:05:08","09:38:28","11:05:08",6.0185185182490386E-2,6.0185185182490386E-2,5,5,null,6.0185185182490442E-2,6.0416666666666667E-2]
[6.3587962962628808E-2,1,0.33333333333333331,"2012-07-24T13:44:11","2012-07-24T15:15:45","13:44:11","15:15:45",6.3587962962628863E-2,6.3587962962628863E-2,2,2,null,6.3587962962628752E-2,6.3888888888888884E-2]
[6.4884259256359655E-2,{"$f":"NETWORKDAYS(D36,IF(E36=\"\",TODAY(),E36))","v":1},{"$f":"$C$1*B36","v":0.33333333333333331},"2012-07-12T08:29:05","2012-07-12T10:02:31",{"$f":"MOD(D36,1)","v":"08:29:05"},{"$f":"MOD(E36,1)","v":"10:02:31"},{"$f":"C36-IF((OR(WEEKDAY(D36)=1,WEEKDAY(D36)=7)),0,(IF(MOD(D36,1)<$E$1,0,(IF(AND($E$1<MOD(D36,1),MOD(D36,1)<$E$2),MOD(D36,1)-$E$1,(IF(AND($E$2<MOD(D36,1),MOD(D36,1)<$F$2),$E$2-$E$1,(IF(AND($F$2<MOD(D36,1),MOD(D36,1)<$F$1),$E$2-$E$1+MOD(D36,1)-$F$2,(IF(MOD(D36,1)>$F$1,$C$1)))))))))))-IF((OR(WEEKDAY(IF(E36=\"\",TODAY(),E36))=1,WEEKDAY(IF(E36=\"\",TODAY(),E36))=7)),0,(IF(MOD(IF(E36=\"\",TODAY(),E36),1)<$E$1,$C$1,(IF(AND($E$1<MOD(IF(E36=\"\",TODAY(),E36),1),MOD(IF(E36=\"\",TODAY(),E36),1)<$E$2),$F$1-$F$2+$E$2-MOD(IF(E36=\"\",TODAY(),E36),1),(IF(AND($E$2<MOD(IF(E36=\"\",TODAY(),E36),1),MOD(IF(E36=\"\",TODAY(),E36),1)<$F$2),$F$1-$F$2,(IF(AND($F$2<MOD(IF(E36=\"\",TODAY(),E36),1),MOD(IF(E36=\"\",TODAY(),E36),1)<$F$1),$F$1-MOD(IF(E36=\"\",TODAY(),E36),1),(IF(MOD(IF(E36=\"\",TODAY(),E36),1)>$F$1,0)))))))))))","v":6.4247685183848546E-2},{"$f":"C36-(IF(F36<$E$1,0,(IF(AND($E$1<F36,F36<$E$2),F36-$E$1,(IF(AND($E$2<F36,F36<$F$2),$E$2-$E$1,(IF(AND($F$2<F36,F36<$F$1),$E$2-$E$1+F36-$F$2,(IF(F36>$F$1,$C$1))))))))))-(IF(G36<$E$1,$C$1,(IF(AND($E$1<G36,G36<$E$2),$F$1-$F$2+$E$2-G36,(IF(AND($E$2<G36,G36<$F$2),$F$1-$F$2,(IF(AND($F$2<G36,G36<$F$1),$F$1-G36,(IF(G36>$F$1,0))))))))))","v":6.4247685183848546E-2},{"$f":"WEEKDAY(D36,2)","v":4},{"$f":"WEEKDAY(E36,2)","v":4},null,6.4247685183848657E-2,6.458333333333334E-2]
[6.5451388894871343E-2,1,0.33333333333333331,"2012-07-11T10:13:40","2012-07-11T11:47:55","10:13:40","11:47:55",6.5451388894871343E-2,6.5451388894871343E-2,3,3,null,6.5451388894871398E-2,6.5277777777777782E-2]
[7.6886574075615499E-2,1,0.33333333333333331,"2012-06-26T10:44:48","2012-06-26T12:35:31","10:44:48","12:35:31",5.2222222220734693E-2,5.2222222220734693E-2,2,2,null,5.2222222220734749E-2,5.2083333333333336E-2]
[8.0995370364689734E-2,1,0.33333333333333331,"2012-07-20T09:11:05","2012-07-20T11:07:43","09:11:05","11:07:43",8.0995370364689734E-2,8.0995370364689734E-2,5,5,null,8.0995370364689789E-2,8.1250000000000003E-2]
[8.2361111111822538E-2,1,0.33333333333333331,"2012-07-06T14:05:56","2012-07-06T16:04:32","14:05:56","16:04:32",8.2361111111822594E-2,8.2361111111822594E-2,5,5,null,8.2361111111822483E-2,8.2638888888888887E-2]
[8.4363425929041114E-2,1,0.33333333333333331,"2012-07-12T11:57:26","2012-07-12T13:58:55","11:57:26","13:58:55",4.2696759262374484E-2,4.2696759262374484E-2,4,4,null,4.2696759262374429E-2,4.3055555555555555E-2]
[8.6053240745968651E-2,1,0.33333333333333331,"2012-07-12T10:38:49","2012-07-12T12:42:44","10:38:49","12:42:44",5.6377314816927537E-2,5.6377314816927537E-2,4,4,null,5.6377314816927593E-2,5.6250000000000001E-2]
[8.9710648149775807E-2,1,0.33333333333333331,"2012-07-19T08:10:12","2012-07-19T10:19:23","08:10:12","10:19:23",7.5960648149096699E-2,7.5960648149096699E-2,4,4,null,7.596064814909681E-2,7.5694444444444439E-2]
[9.3831018515629694E-2,1,0.33333333333333331,"2012-07-19T11:35:32","2012-07-19T13:50:39","11:35:32","13:50:39",5.2164351848963064E-2,5.2164351848963064E-2,4,4,null,5.2164351848963009E-2,5.2083333333333336E-2]
[9.449074073927477E-2,1,0.33333333333333331,"2012-07-09T08:44:11","2012-07-09T11:00:15","08:44:11","11:00:15",9.449074073927477E-2,9.449074073927477E-2,1,1,null,9.4490740739274826E-2,9.4444444444444442E-2]
[9.5381944447581191E-2,1,0.33333333333333331,"2012-07-25T10:03:35","2012-07-25T12:20:56","10:03:35","12:20:56",8.0844907410209998E-2,8.0844907410209998E-2,3,3,null,8.0844907410210054E-2,8.0555555555555561E-2]
[9.6076388894289266E-2,1,0.33333333333333331,"2012-07-13T11:06:44","2012-07-13T13:25:05","11:06:44","13:25:05",5.4409722227622637E-2,5.4409722227622637E-2,5,5,null,5.4409722227622581E-2,5.4166666666666669E-2]
[9.6527777779556345E-2,1,0.33333333333333331,"2012-07-20T07:55:46","2012-07-20T10:14:46","07:55:46","10:14:46",7.2754629630556622E-2,7.2754629630556622E-2,5,5,null,7.2754629630556733E-2,7.2916666666666671E-2]
[9.7129629626579117E-2,1,0.33333333333333331,"2012-07-20T09:29:38","2012-07-20T11:49:30","09:29:38","11:49:30",9.7129629626579117E-2,9.7129629626579117E-2,5,5,null,9.7129629626579173E-2,9.6527777777777782E-2]
[0.10083333333750488,1,0.33333333333333331,"2012-07-02T13:36:18","2012-07-02T16:01:30","13:36:18","16:01:30",0.10083333333750494,0.10083333333750494,1,1,null,0.10083333333750483,0.10138888888888889]
[0.10822916666074889,1,0.33333333333333331,"2012-07-20T09:26:01","2012-07-20T12:01:52","09:26:01","12:01:52",0.10693287036701804,0.10693287036701804,5,5,null,0.1069328703670181,0.10694444444444444]
[0.10909722222277196,1,0.33333333333333331,"2012-07-17T10:15:28","2012-07-17T12:52:34","10:15:28","12:52:34",7.2592592594446614E-2,7.2592592594446614E-2,2,2,null,7.259259259444667E-2,7.2916666666666671E-2]
[0.10965277777722804,1,0.33333333333333331,"2012-07-16T11:28:07","2012-07-16T14:06:01","11:28:07","14:06:01",6.7986111110561409E-2,6.7986111110561409E-2,1,1,null,6.7986111110561354E-2,6.805555555555555E-2]
[0.11295138888817746,1,0.33333333333333331,"2012-07-20T09:20:47","2012-07-20T12:03:26","09:20:47","12:03:26",0.11056712963181781,0.11056712963181781,5,5,null,0.11056712963181786,0.11041666666666666]
[0.11370370369695593,1,0.33333333333333331,"2012-07-02T13:20:23","2012-07-02T16:04:07","13:20:23","16:04:07",0.11370370369695598,0.11370370369695598,1,1,null,0.11370370369695587,0.11388888888888889]
[0.11553240740613546,1,0.33333333333333331,"2012-07-13T12:57:46","2012-07-13T15:44:08","12:57:46","15:44:08",0.11398148147903464,0.11398148147903464,5,5,null,0.11398148147903459,0.11388888888888889]
[0.12311342592875008,1,0.33333333333333331,"2012-07-02T10:32:20","2012-07-02T13:29:37","10:32:20","13:29:37",8.1446759262083446E-2,8.1446759262083446E-2,1,1,null,8.144675926208339E-2,8.1944444444444445E-2]
[0.13655092592671281,1,0.33333333333333331,"2012-07-20T08:11:23","2012-07-20T11:28:01","08:11:23","11:28:01",0.12362268518821412,0.12362268518821412,5,5,null,0.12362268518821423,0.12361111111111112]
[0.13862268518278142,1,0.33333333333333331,"2012-07-20T09:21:29","2012-07-20T12:41:06","09:21:29","12:41:06",0.11008101851621177,0.11008101851621177,5,5,null,0.11008101851621183,0.11041666666666666]
[0.14097222222335404,1,0.33333333333333331,"2012-07-20T08:39:50","2012-07-20T12:02:50","08:39:50","12:02:50",0.13900462962919846,0.13900462962919846,5,5,null,0.13900462962919852,0.1388888888888889]
[0.14333333333343035,1,0.33333333333333331,"2012-07-19T08:43:15","2012-07-19T12:09:39","08:43:15","12:09:39",0.1366319444423425,0.1366319444423425,4,4,null,0.13663194444234256,0.13680555555555557]
[0.15221064814977581,1,0.33333333333333331,"2012-07-20T10:09:09","2012-07-20T13:48:20","10:09:09","13:48:20",0.11054398148310918,0.11054398148310918,5,5,null,0.11054398148310912,0.11041666666666666]
[0.16120370370481396,1,0.33333333333333331,"2012-07-20T08:10:03","2012-07-20T12:02:11","08:10:03","12:02:11",0.14583333333333331,0.14583333333333331,5,5,null,0.14583333333333343,0.14583333333333334]
[0.16337962963007158,1,0.33333333333333331,"2012-07-12T09:39:37","2012-07-12T13:34:53","09:39:37","13:34:53",0.12171296296340495,0.12171296296340495,4,4,null,0.12171296296340489,0.12152777777777778]
[0.16526620370859746,1,0.33333333333333331,"2012-06-28T09:27:38","2012-06-28T13:25:37","09:27:38","13:25:37",0.12359953704193083,0.12359953704193083,4,4,null,0.12359953704193077,0.12361111111111112]
[0.17010416666744277,1,0.33333333333333331,"2012-07-25T09:14:41","2012-07-25T13:19:38","09:14:41","13:19:38",0.12843750000077614,0.12843750000077614,3,3,null,0.12843750000077608,0.12847222222222221]
[0.18565972222131677,1,0.33333333333333331,"2012-07-20T10:55:36","2012-07-20T15:22:57","10:55:36","15:22:57",0.14399305555465014,0.14399305555465014,5,5,null,0.14399305555465008,0.14374999999999999]
[0.18716435185342561,{"$f":"NETWORKDAYS(D68,IF(E68=\"\",TODAY(),E68))","v":1},{"$f":"$C$1*B68","v":0.33333333333333331},"2012-07-23T08:41:07","2012-07-23T13:10:38",{"$f":"MOD(D68,1)","v":"08:41:07"},{"$f":"MOD(E68,1)","v":"13:10:38"},{"$f":"C68-IF((OR(WEEKDAY(D68)=1,WEEKDAY(D68)=7)),0,(IF(MOD(D68,1)<$E$1,0,(IF(AND($E$1<MOD(D68,1),MOD(D68,1)<$E$2),MOD(D68,1)-$E$1,(IF(AND($E$2<MOD(D68,1),MOD(D68,1)<$F$2),$E$2-$E$1,(IF(AND($F$2<MOD(D68,1),MOD(D68,1)<$F$1),$E$2-$E$1+MOD(D68,1)-$F$2,(IF(MOD(D68,1)>$F$1,$C$1)))))))))))-IF((OR(WEEKDAY(IF(E68=\"\",TODAY(),E68))=1,WEEKDAY(IF(E68=\"\",TODAY(),E68))=7)),0,(IF(MOD(IF(E68=\"\",TODAY(),E68),1)<$E$1,$C$1,(IF(AND($E$1<MOD(IF(E68=\"\",TODAY(),E68),1),MOD(IF(E68=\"\",TODAY(),E68),1)<$E$2),$F$1-$F$2+$E$2-MOD(IF(E68=\"\",TODAY(),E68),1),(IF(AND($E$2<MOD(IF(E68=\"\",TODAY(),E68),1),MOD(IF(E68=\"\",TODAY(),E68),1)<$F$2),$F$1-$F$2,(IF(AND($F$2<MOD(IF(E68=\"\",TODAY(),E68),1),MOD(IF(E68=\"\",TODAY(),E68),1)<$F$1),$F$1-MOD(IF(E68=\"\",TODAY(),E68),1),(IF(MOD(IF(E68=\"\",TODAY(),E68),1)>$F$1,0)))))))))))","v":0.14549768518675898},{"$f":"C68-(IF(F68<$E$1,0,(IF(AND($E$1<F68,F68<$E$2),F68-$E$1,(IF(AND($E$2<F68,F68<$F$2),$E$2-$E$1,(IF(AND($F$2<F68,F68<$F$1),$E$2-$E$1+F68-$F$2,(IF(F68>$F$1,$C$1))))))))))-(IF(G68<$E$1,$C$1,(IF(AND($E$1<G68,G68<$E$2),$F$1-$F$2+$E$2-G68,(IF(AND($E$2<G68,G68<$F$2),$F$1-$F$2,(IF(AND($F$2<G68,G68<$F$1),$F$1-G68,(IF(G68>$F$1,0))))))))))","v":0.14549768518675898},{"$f":"WEEKDAY(D68,2)","v":1},{"$f":"WEEKDAY(E68,2)","v":1},null,0.14549768518675893,0.14583333333333334]
[0.20291666666889796,1,0.33333333333333331,"2012-07-20T09:52:56","2012-07-20T14:45:08","09:52:56","14:45:08",0.16125000000223133,0.16125000000223133,5,5,null,{"$f":"(WEEKDAY(D69,2)<6)*($E$2-MAX(MIN(MOD(D69,1),$E$2),$E$1)+$F$1-MAX(MIN(MOD(D69,1),$F$1),$F$2))+(WEEKDAY(E69,2)<6)*(MAX(MIN(MOD(E69,1),$E$2),$E$1)-$E$1+MAX(MIN(MOD(E69,1),$F$1),$F$2)-$F$2)+(NETWORKDAYS(WORKDAY(D69+1,-1),WORKDAY(E69-1,1))-2)*$C$1","v":0.16125000000223128},{"$f":"NetWorkTime(D69,E69)","v":0.16111111111111112}]
[0.23991898148233304,1,0.33333333333333331,"2012-07-19T09:21:28","2012-07-19T15:06:57","09:21:28","15:06:57",0.19825231481566641,0.19825231481566641,4,4,null,0.19825231481566635,0.1986111111111111]
[0.24474537037167465,1,0.33333333333333331,"2012-07-13T10:04:17","2012-07-13T15:56:43","10:04:17","15:56:43",0.20307870370500802,0.20307870370500802,5,5,null,0.20307870370500797,0.20347222222222222]
[0.26633101851621177,1,0.33333333333333331,"2012-06-25T09:51:35","2012-06-25T16:15:06","09:51:35","16:15:06",0.22466435184954514,0.22466435184954514,1,1,null,0.22466435184954509,0.22430555555555556]
[0.26829861111036735,1,0.33333333333333331,"2012-07-04T08:54:16","2012-07-04T15:20:37","08:54:16","15:20:37",0.22663194444370072,0.22663194444370072,3,3,null,0.22663194444370066,0.22708333333333333]
[0.27123842592845904,1,0.33333333333333331,"2012-07-03T10:32:33","2012-07-03T17:03:08","10:32:33","17:03:08",0.22957175926179241,0.22957175926179241,2,2,null,0.22957175926179235,0.22916666666666666]
[0.27255787036847323,1,0.33333333333333331,"2012-06-25T09:29:20","2012-06-25T16:01:49","09:29:20","16:01:49",0.2308912037018066,0.2308912037018066,1,1,null,0.23089120370180655,0.23125000000000001]
[0.2772222222192795,1,0.33333333333333331,"2012-07-04T10:15:45","2012-07-04T16:54:57","10:15:45","16:54:57",0.23555555555261287,0.23555555555261287,3,3,null,0.23555555555261282,0.23541666666666666]
[0.28146990740788169,1,0.33333333333333331,"2012-07-23T08:55:53","2012-07-23T15:41:12","08:55:53","15:41:12",0.23980324074121506,0.23980324074121506,1,1,null,0.23980324074121501,0.23958333333333334]
[0.28901620370743331,1,0.33333333333333331,"2012-07-12T09:25:32","2012-07-12T16:21:43","09:25:32","16:21:43",0.24734953704076668,0.24734953704076668,4,4,null,0.24734953704076662,0.24722222222222223]
[0.29020833333197515,1,0.33333333333333331,"2012-07-24T08:59:25","2012-07-24T15:57:19","08:59:25","15:57:19",0.24854166666530852,0.24854166666530852,2,2,null,0.24854166666530847,0.24861111111111112]
[0.33144675925723277,1,0.33333333333333331,"2012-07-17T08:44:28","2012-07-17T16:41:45","08:44:28","16:41:45",0.28978009259056614,0.28978009259056614,2,2,null,0.28978009259056609,0.2902777777777778]
[0.33516203703766223,1,0.33333333333333331,"2012-07-11T08:58:25","2012-07-11T17:01:03","08:58:25","17:01:03",0.2934953703709956,0.2934953703709956,3,3,null,0.29349537037099555,0.29375000000000001]
[0.35123842592292931,1,0.33333333333333331,"2012-07-03T10:16:13","2012-07-03T18:42:00","10:16:13","18:42:00",0.25957175925577758,0.25957175925577758,2,2,null,0.25957175925577763,{"$f":"NetWorkTime(D82,E82)","v":0.25972222222222224}]
[0.60582175925810589,2,0.66666666666666663,"2012-07-16T18:44:09","2012-07-17T09:16:32","18:44:09","09:16:32",3.2314814813920123E-2,3.2314814813920123E-2,1,2,null,3.2314814813920179E-2,3.2638888888888891E-2]
[0.68193287037138361,2,0.66666666666666663,"2012-07-16T18:23:45","2012-07-17T10:45:44","18:23:45","10:45:44",9.4259259259464045E-2,9.4259259259464045E-2,1,2,null,9.4259259259464101E-2,9.4444444444444442E-2]
[0.68431712962774327,2,0.66666666666666663,"2012-07-09T16:59:59","2012-07-10T09:25:24","16:59:59","09:25:24",5.931712962774327E-2,5.931712962774327E-2,1,2,null,5.931712962774327E-2,5.9027777777777776E-2]
[0.69503472222277196,2,0.66666666666666663,"2012-07-16T18:06:12","2012-07-17T10:47:03","18:06:12","10:47:03",9.5173611114053813E-2,9.5173611114053813E-2,1,2,null,9.5173611114053869E-2,9.5138888888888884E-2]
[0.71040509259182727,2,0.66666666666666663,"2012-07-19T17:16:52","2012-07-20T10:19:51","17:16:52","10:19:51",8.540509259182727E-2,8.540509259182727E-2,4,5,null,8.540509259182727E-2,8.5416666666666669E-2]
[0.71120370370044839,2,0.66666666666666663,"2012-07-18T14:57:44","2012-07-19T08:01:52","14:57:44","08:01:52",0.10574074073762557,0.10574074073762557,3,4,null,0.10574074073762552,0.10555555555555556]
[0.74678240740468027,2,0.66666666666666663,"2012-07-16T14:19:35","2012-07-17T08:14:57","14:19:35","08:14:57",0.13223379629440996,0.13223379629440996,1,2,null,0.1322337962944099,0.13194444444444445]
[0.76681712962454185,2,0.66666666666666663,"2012-07-23T16:45:15","2012-07-24T11:09:28","16:45:15","11:09:28",0.14181712962454185,0.14181712962454185,1,2,null,0.14181712962454185,0.14166666666666666]
[0.80998842592089204,2,0.66666666666666663,"2012-07-24T13:28:27","2012-07-25T08:54:50","13:28:27","08:54:50",0.18498842592089204,0.18498842592089204,2,3,null,0.18498842592089204,0.18541666666666667]
[0.82060185185400769,2,0.66666666666666663,"2012-07-09T16:46:48","2012-07-10T12:28:28","16:46:48","12:28:28",0.1758333333345945,0.1758333333345945,1,2,null,0.1758333333345945,0.17569444444444443]
[0.859305555553874,2,0.66666666666666663,"2012-07-02T15:57:35","2012-07-03T12:34:59","15:57:35","12:34:59",0.21001157407590654,0.21001157407590654,1,2,null,0.21001157407590654,0.20972222222222223]
[0.87614583333197515,2,0.66666666666666663,"2012-07-09T15:39:51","2012-07-10T12:41:30","15:39:51","12:41:30",0.22232638888817746,0.22232638888817746,1,2,null,0.22232638888817746,0.22222222222222221]
[0.87893518518831115,2,0.66666666666666663,"2012-07-16T14:47:32","2012-07-17T11:53:12","14:47:32","11:53:12",0.25393518518831115,0.25393518518831115,1,2,null,0.25393518518831115,0.25347222222222221]
[0.92306712962454185,2,0.66666666666666663,"2012-07-24T11:19:11","2012-07-25T09:28:24","11:19:11","09:28:24",0.25640046295787511,0.25640046295787511,2,3,null,0.25640046295787522,0.25624999999999998]
[0.963726851856336,2,0.66666666666666663,"2012-07-02T16:08:23","2012-07-03T15:16:09","16:08:23","15:16:09",0.29706018518966937,0.29706018518966937,1,2,null,0.29706018518966926,0.29722222222222222]
[0.976458333330811,2,0.66666666666666663,"2012-07-18T16:01:41","2012-07-19T15:27:47","16:01:41","15:27:47",0.30979166666414437,0.30979166666414437,3,4,null,0.30979166666414426,0.30972222222222223]
[0.97648148148437031,2,0.66666666666666663,"2012-07-16T13:51:35","2012-07-17T13:17:43","13:51:35","13:17:43",0.30981481481770368,0.30981481481770368,1,2,null,0.30981481481770357,0.30972222222222223]
[0.98658564814832062,{"$f":"NETWORKDAYS(D100,IF(E100=\"\",TODAY(),E100))","v":2},{"$f":"$C$1*B100","v":0.66666666666666663},"2012-07-10T11:39:05","2012-07-11T11:19:46",{"$f":"MOD(D100,1)","v":"11:39:05"},{"$f":"MOD(E100,1)","v":"11:19:46"},{"$f":"C100-IF((OR(WEEKDAY(D100)=1,WEEKDAY(D100)=7)),0,(IF(MOD(D100,1)<$E$1,0,(IF(AND($E$1<MOD(D100,1),MOD(D100,1)<$E$2),MOD(D100,1)-$E$1,(IF(AND($E$2<MOD(D100,1),MOD(D100,1)<$F$2),$E$2-$E$1,(IF(AND($F$2<MOD(D100,1),MOD(D100,1)<$F$1),$E$2-$E$1+MOD(D100,1)-$F$2,(IF(MOD(D100,1)>$F$1,$C$1)))))))))))-IF((OR(WEEKDAY(IF(E100=\"\",TODAY(),E100))=1,WEEKDAY(IF(E100=\"\",TODAY(),E100))=7)),0,(IF(MOD(IF(E100=\"\",TODAY(),E100),1)<$E$1,$C$1,(IF(AND($E$1<MOD(IF(E100=\"\",TODAY(),E100),1),MOD(IF(E100=\"\",TODAY(),E100),1)<$E$2),$F$1-$F$2+$E$2-MOD(IF(E100=\"\",TODAY(),E100),1),(IF(AND($E$2<MOD(IF(E100=\"\",TODAY(),E100),1),MOD(IF(E100=\"\",TODAY(),E100),1)<$F$2),$F$1-$F$2,(IF(AND($F$2<MOD(IF(E100=\"\",TODAY(),E100),1),MOD(IF(E100=\"\",TODAY(),E100),1)<$F$1),$F$1-MOD(IF(E100=\"\",TODAY(),E100),1),(IF(MOD(IF(E100=\"\",TODAY(),E100),1)>$F$1,0)))))))))))","v":0.31991898148165387},{"$f":"C100-(IF(F100<$E$1,0,(IF(AND($E$1<F100,F100<$E$2),F100-$E$1,(IF(AND($E$2<F100,F100<$F$2),$E$2-$E$1,(IF(AND($F$2<F100,F100<$F$1),$E$2-$E$1+F100-$F$2,(IF(F100>$F$1,$C$1))))))))))-(IF(G100<$E$1,$C$1,(IF(AND($E$1<G100,G100<$E$2),$F$1-$F$2+$E$2-G100,(IF(AND($E$2<G100,G100<$F$2),$F$1-$F$2,(IF(AND($F$2<G100,G100<$F$1),$F$1-G100,(IF(G100>$F$1,0))))))))))","v":0.31991898148165387},{"$f":"WEEKDAY(D100,2)","v":2},{"$f":"WEEKDAY(E100,2)","v":3},null,0.31991898148165399,0.32013888888888886]
[1.0191319444420515,2,0.66666666666666663,"2012-07-23T16:38:42","2012-07-24T17:06:15","16:38:42","17:06:15",0.35246527777538483,0.35246527777538483,1,2,null,0.35246527777538472,0.35208333333333336]
[1.0242013888928341,2,0.66666666666666663,"2012-07-19T16:16:03","2012-07-20T16:50:54","16:16:03","16:50:54",0.35753472222616745,0.35753472222616745,4,5,null,0.35753472222616733,0.3576388888888889]
[1.0252777777786832,2,0.66666666666666663,"2012-07-19T16:14:49","2012-07-20T16:51:13","16:14:49","16:51:13",0.3586111111120166,0.3586111111120166,4,5,null,0.35861111111201649,0.35833333333333334]
[1.0311574074075907,2,0.66666666666666663,"2012-07-19T16:33:27","2012-07-20T17:18:19","16:33:27","17:18:19",0.36449074074092402,0.36449074074092402,4,5,null,0.36449074074092391,0.36458333333333331]
[1.0471412037077243,2,0.66666666666666663,"2012-07-11T14:51:39","2012-07-12T15:59:32","14:51:39","15:59:32",0.38047453704105771,0.38047453704105771,3,4,null,0.3804745370410576,0.38055555555555554]
[1.0488657407404389,2,0.66666666666666663,"2012-07-16T12:11:20","2012-07-17T13:21:42","12:11:20","13:21:42",0.3484027777764519,0.3484027777764519,1,2,null,0.3484027777764519,0.34861111111111109]
[1.1113310185173759,2,0.66666666666666663,"2012-07-12T08:21:11","2012-07-13T11:01:30","08:21:11","11:01:30",0.43854166666521144,0.43854166666521144,4,5,null,0.43854166666521155,0.43819444444444444]
[1.1541435185208684,2,0.66666666666666663,"2012-07-12T13:46:40","2012-07-13T17:28:38","13:46:40","17:28:38",0.48747685185420175,0.48747685185420175,4,5,null,0.48747685185420164,0.48749999999999999]
[1.1583449074096279,2,0.66666666666666663,"2012-07-25T13:08:32","2012-07-26T16:56:33","13:08:32","16:56:33",0.49167824074296129,0.49167824074296129,3,4,null,0.49167824074296118,0.49166666666666664]
[1.1697569444440887,2,0.66666666666666663,"2012-07-10T11:46:48","2012-07-11T15:51:15","11:46:48","15:51:15",0.46142361111075536,0.46142361111075536,2,3,null,0.46142361111075536,0.46111111111111114]
[1.1711458333302289,2,0.66666666666666663,"2012-07-12T13:22:58","2012-07-13T17:29:25","13:22:58","17:29:25",0.5044791666635623,0.5044791666635623,4,5,null,0.50447916666356218,0.50416666666666665]
[1.2120833333319752,2,0.66666666666666663,"2012-07-19T09:37:42","2012-07-20T14:43:06","09:37:42","14:43:06",0.50374999999864178,0.50374999999864178,4,5,null,0.50374999999864178,0.50347222222222221]
[1.2129166666709352,2,0.66666666666666663,"2012-07-23T10:59:37","2012-07-24T16:06:13","10:59:37","16:06:13",0.50458333333760186,0.50458333333760186,1,2,null,0.50458333333760186,0.50416666666666665]
[1.2463657407424762,2,0.66666666666666663,"2012-07-16T09:15:11","2012-07-17T15:09:57","09:15:11","15:09:57",0.53803240740914282,0.53803240740914282,1,2,null,0.53803240740914282,0.53819444444444442]
[1.2612731481494848,2,0.66666666666666663,"2012-07-19T09:06:28","2012-07-20T15:22:42","09:06:28","15:22:42",0.5529398148161514,0.5529398148161514,4,5,null,0.5529398148161514,0.55347222222222225]
[1.26792824074073,2,0.66666666666666663,"2012-07-24T09:24:39","2012-07-25T15:50:28","09:24:39","15:50:28",0.55959490740739659,0.55959490740739659,2,3,null,0.55959490740739659,0.55902777777777779]
[1.3246759259272949,2,0.66666666666666663,"2012-07-09T09:34:20","2012-07-10T17:21:52","09:34:20","17:21:52",0.61634259259396151,0.61634259259396151,1,2,null,0.61634259259396151,0.6166666666666667]
[1.8335532407363644,3,1,"2012-06-26T13:04:15","2012-06-28T09:04:34","13:04:15","09:04:34",0.54188657406969776,0.54188657406969776,2,4,null,0.54188657406969765,0.54236111111111107]
[1.9395023148172186,3,1,"2012-07-18T16:56:45","2012-07-20T15:29:38","16:56:45","15:29:38",0.60616898148388532,0.60616898148388532,3,5,null,0.60616898148388509,0.60624999999999996]
[1.9494328703731298,3,1,"2012-07-09T17:04:38","2012-07-11T15:51:49","17:04:38","15:51:49",0.61609953703979659,0.61609953703979659,1,3,null,0.61609953703979636,0.61597222222222225]
[1.9986111111065838,3,1,"2012-07-18T10:25:18","2012-07-20T10:23:18","10:25:18","10:23:18",0.66527777777325059,0.66527777777325059,3,5,null,0.66527777777325059,0.66527777777777775]
[2.0300925925912452,3,1,"2012-07-23T08:32:11","2012-07-25T09:15:31","08:32:11","09:15:31",0.69675925925791193,0.69675925925791193,1,3,null,0.69675925925791193,0.69722222222222219]
[2.1205208333340124,3,1,"2012-07-24T08:56:38","2012-07-26T11:50:11","08:56:38","11:50:11",0.78718750000067916,0.78718750000067916,2,4,null,0.78718750000067916,0.78680555555555554]
[2.2054861111100763,3,1,"2012-07-03T14:02:44","2012-07-05T18:58:38","14:02:44","18:58:38",0.81060185184954514,0.81060185184954514,2,4,null,0.81060185184954503,0.81041666666666667]
[2.2354166666700621,3,1,"2012-07-23T10:01:59","2012-07-25T15:40:59","10:01:59","15:40:59",0.86041666667006222,0.86041666667006222,1,3,null,0.86041666667006211,0.86041666666666672]
[2.75467592592031,2,0.66666666666666663,"2012-07-13T16:33:09","2012-07-16T10:39:53","16:33:09","10:39:53",0.12967592592030996,0.12967592592030996,5,1,null,0.12967592592030996,0.12986111111111112]
[2.7985300925938645,4,1.3333333333333333,"2012-07-09T15:15:48","2012-07-12T10:25:41","15:15:48","10:25:41",0.84019675926053106,0.84019675926053106,1,4,null,0.84019675926053117,0.84027777777777779]
[2.8005902777804295,2,0.66666666666666663,"2012-07-13T14:46:06","2012-07-16T09:58:57","14:46:06","09:58:57",0.17559027778042946,0.17559027778042946,5,1,null,0.17559027778042946,0.17569444444444443]
[2.8054629629623378,2,0.66666666666666663,"2012-07-06T15:32:33","2012-07-09T10:52:25","15:32:33","10:52:25",0.18046296296233777,0.18046296296233777,5,1,null,0.18046296296233777,0.17986111111111111]
[2.8122106481459923,4,1.3333333333333333,"2012-06-25T16:39:22","2012-06-28T12:08:57","16:39:22","12:08:57",0.84766203703717702,0.84766203703717702,1,4,null,0.84766203703717713,0.84791666666666665]
[2.8558101851886022,2,0.66666666666666663,"2012-07-13T15:59:23","2012-07-16T12:31:45","15:59:23","12:31:45",0.20876157407474238,0.20876157407474238,5,1,null,0.20876157407474238,0.20902777777777778]
[2.862060185187147,{"$f":"NETWORKDAYS(D132,IF(E132=\"\",TODAY(),E132))","v":4},{"$f":"$C$1*B132","v":1.3333333333333333},"2012-07-09T15:43:58","2012-07-12T12:25:20",{"$f":"MOD(D132,1)","v":"15:43:58"},{"$f":"MOD(E132,1)","v":"12:25:20"},{"$f":"C132-IF((OR(WEEKDAY(D132)=1,WEEKDAY(D132)=7)),0,(IF(MOD(D132,1)<$E$1,0,(IF(AND($E$1<MOD(D132,1),MOD(D132,1)<$E$2),MOD(D132,1)-$E$1,(IF(AND($E$2<MOD(D132,1),MOD(D132,1)<$F$2),$E$2-$E$1,(IF(AND($F$2<MOD(D132,1),MOD(D132,1)<$F$1),$E$2-$E$1+MOD(D132,1)-$F$2,(IF(MOD(D132,1)>$F$1,$C$1)))))))))))-IF((OR(WEEKDAY(IF(E132=\"\",TODAY(),E132))=1,WEEKDAY(IF(E132=\"\",TODAY(),E132))=7)),0,(IF(MOD(IF(E132=\"\",TODAY(),E132),1)<$E$1,$C$1,(IF(AND($E$1<MOD(IF(E132=\"\",TODAY(),E132),1),MOD(IF(E132=\"\",TODAY(),E132),1)<$E$2),$F$1-$F$2+$E$2-MOD(IF(E132=\"\",TODAY(),E132),1),(IF(AND($E$2<MOD(IF(E132=\"\",TODAY(),E132),1),MOD(IF(E132=\"\",TODAY(),E132),1)<$F$2),$F$1-$F$2,(IF(AND($F$2<MOD(IF(E132=\"\",TODAY(),E132),1),MOD(IF(E132=\"\",TODAY(),E132),1)<$F$1),$F$1-MOD(IF(E132=\"\",TODAY(),E132),1),(IF(MOD(IF(E132=\"\",TODAY(),E132),1)>$F$1,0)))))))))))","v":0.88613425925965794},{"$f":"C132-(IF(F132<$E$1,0,(IF(AND($E$1<F132,F132<$E$2),F132-$E$1,(IF(AND($E$2<F132,F132<$F$2),$E$2-$E$1,(IF(AND($F$2<F132,F132<$F$1),$E$2-$E$1+F132-$F$2,(IF(F132>$F$1,$C$1))))))))))-(IF(G132<$E$1,$C$1,(IF(AND($E$1<G132,G132<$E$2),$F$1-$F$2+$E$2-G132,(IF(AND($E$2<G132,G132<$F$2),$F$1-$F$2,(IF(AND($F$2<G132,G132<$F$1),$F$1-G132,(IF(G132>$F$1,0))))))))))","v":0.88613425925965794},{"$f":"WEEKDAY(D132,2)","v":1},{"$f":"WEEKDAY(E132,2)","v":4},null,0.88613425925965805,0.88611111111111107]
[2.9654050925892079,2,0.66666666666666663,"2012-07-13T11:31:00","2012-07-16T10:41:11","11:31:00","10:41:11",0.29873842592254118,0.29873842592254118,5,1,null,{"$f":"(WEEKDAY(D133,2)<6)*($E$2-MAX(MIN(MOD(D133,1),$E$2),$E$1)+$F$1-MAX(MIN(MOD(D133,1),$F$1),$F$2))+(WEEKDAY(E133,2)<6)*(MAX(MIN(MOD(E133,1),$E$2),$E$1)-$E$1+MAX(MIN(MOD(E133,1),$F$1),$F$2)-$F$2)+(NETWORKDAYS(WORKDAY(D133+1,-1),WORKDAY(E133-1,1))-2)*$C$1","v":0.2987384259225413},{"$f":"NetWorkTime(D133,E133)","v":0.2986111111111111}]
[3.0369675925903721,2,0.66666666666666663,"2012-07-20T15:45:55","2012-07-23T16:39:09","15:45:55","16:39:09",0.37030092592370545,0.37030092592370545,5,1,null,0.37030092592370534,0.37013888888888891]
[3.0702662037001573,2,0.66666666666666663,"2012-07-13T10:40:35","2012-07-16T12:21:46","10:40:35","12:21:46",0.38848379629537999,0.38848379629537999,5,1,null,0.3884837962953801,0.38819444444444445]
[3.8583796296297805,3,1,"2012-07-13T16:17:13","2012-07-17T12:53:17","16:17:13","12:53:17",0.52971064814967883,0.52971064814967883,5,2,null,0.52971064814967872,0.52986111111111112]
[3.8937847222186974,3,1,"2012-07-13T15:28:15","2012-07-17T12:55:18","15:28:15","12:55:18",0.56371527777567587,0.56371527777567587,5,2,null,0.56371527777567576,0.56388888888888888]
[4.0093055555553292,3,1,"2012-07-19T14:43:41","2012-07-23T14:57:05","14:43:41","14:57:05",0.67597222222199593,0.67597222222199593,4,1,null,0.67597222222199571,0.67569444444444449]
[4.1923263888893416,3,1,"2012-07-05T10:09:20","2012-07-09T14:46:17","10:09:20","14:46:17",0.81732638888934173,0.81732638888934173,4,1,null,0.81732638888934162,0.81736111111111109]
[4.1998032407427672,3,1,"2012-07-12T12:14:29","2012-07-16T17:02:12","12:14:29","17:02:12",0.83486111111415096,0.83486111111415096,4,1,null,0.83486111111415084,0.83472222222222225]
[4.8092013888890506,4,1.3333333333333333,"2012-07-06T16:38:17","2012-07-11T12:03:32","16:38:17","12:03:32",0.84841435185323144,0.84841435185323144,5,3,null,0.84841435185323155,0.84861111111111109]
[4.9948842592566507,4,1.3333333333333333,"2012-07-19T13:58:10","2012-07-24T13:50:48","13:58:10","13:50:48",0.99488425925665058,0.99488425925665058,4,2,null,0.99488425925665058,0.99513888888888891]
[5.1160069444449618,4,1.3333333333333333,"2012-07-13T10:56:26","2012-07-18T13:43:29","10:56:26","13:43:29",1.0743402777782953,1.0743402777782953,5,3,null,1.0743402777782951,1.0743055555555556]
[5.3106944444443798,4,1.3333333333333333,"2012-07-13T09:23:41","2012-07-18T16:51:05","09:23:41","16:51:05",1.2690277777777133,1.2690277777777133,5,3,null,1.269027777777713,1.26875]
[5.8034259259293322,5,1.6666666666666665,"2012-06-27T15:40:04","2012-07-03T10:57:00","15:40:04","10:57:00",1.1784259259293322,1.1784259259293322,3,2,null,1.1784259259293322,1.1784722222222221]
[5.9171064814800047,5,1.6666666666666665,"2012-07-19T10:06:16","2012-07-25T08:06:54","10:06:16","08:06:54",1.2664814814779675,1.2664814814779675,4,3,null,1.2664814814779675,1.2666666666666666]
[5.9606828703690553,5,1.6666666666666665,"2012-07-03T15:46:12","2012-07-09T14:49:35","15:46:12","14:49:35",1.2940162037023888,1.2940162037023888,2,1,null,1.2940162037023886,1.2944444444444445]
[6.0134374999979627,5,1.6666666666666665,"2012-06-29T11:29:46","2012-07-05T11:49:07","11:29:46","11:49:07",1.346770833331296,1.346770833331296,5,4,null,1.3467708333312962,1.3465277777777778]
[6.0150810185223236,5,1.6666666666666665,"2012-06-29T11:30:38","2012-07-05T11:52:21","11:30:38","11:52:21",1.3484143518556568,1.3484143518556568,5,4,null,1.3484143518556571,1.3479166666666667]
[6.7502546296309447,6,2,"2012-07-12T15:58:21","2012-07-19T09:58:43","15:58:21","09:58:43",1.4585879629642782,1.4585879629642782,4,4,null,1.458587962964278,1.4590277777777778]
[6.8382175925944466,6,2,"2012-07-20T16:26:33","2012-07-27T12:33:35","16:26:33","12:33:35",1.5232291666664728,1.5232291666664728,5,5,null,1.5232291666664726,1.5229166666666667]
[7.758020833331102,7,2.333333333333333,"2012-07-12T15:30:40","2012-07-20T09:42:13","15:30:40","09:42:13",1.7996874999977686,1.7996874999977686,4,5,null,1.7996874999977686,1.7993055555555555]
[10.171215277776355,7,2.333333333333333,"2012-07-06T12:56:47","2012-07-16T17:03:20","12:56:47","17:03:20",2.1689814814793253,2.1689814814793253,5,1,null,2.1689814814793253,2.1687500000000002]
[10.774456018523779,9,3,"2012-07-15T14:30:13","2012-07-26T09:05:26","14:30:13","09:05:26",2.6912731481497758,2.4827893518571122,7,4,null,2.6912731481497758,2.6909722222222223]
[10.948773148149485,8,2.6666666666666665,"2012-07-19T10:11:30","2012-07-30T08:57:44","10:11:30","08:57:44",2.2821064814828178,2.2821064814828178,4,1,null,2.2821064814828182,2.2819444444444446]
[12.122534722220735,9,3,"2012-07-04T10:36:52","2012-07-16T13:33:19","10:36:52","13:33:19",2.7475347222207347,2.7475347222207347,3,1,null,2.7475347222207342,2.7472222222222222]
[12.296365740738111,9,3,"2012-07-04T08:36:59","2012-07-16T15:43:45","08:36:59","15:43:45",2.9213657407381106,2.9213657407381106,3,1,null,2.9213657407381102,2.9215277777777779]
[15.130879629628907,12,4,"2012-07-11T08:23:55","2012-07-26T11:32:23","08:23:55","11:32:23",3.7933217592581059,3.7933217592581059,3,4,null,3.7933217592581059,3.7930555555555556]
[19.744733796294895,15,5,"2012-06-27T14:42:59","2012-07-17T08:35:24","14:42:59","08:35:24",4.453067129628228,4.453067129628228,3,2,null,4.453067129628228,4.4527777777777775]
["Не выполнено",8,2.6666666666666665,"2012-07-25T16:45:21",null,"16:45:21","00:00:00",2.3643402777743177,2.0310069444409842,3,6]
["Не выполнено",10,3.333333333333333,"2012-07-23T11:04:41",null,"11:04:41","00:00:00",3.2259143518531341,2.8925810185198007,1,6]
["Не выполнено",10,3.333333333333333,"2012-07-23T12:55:58",null,"12:55:58","00:00:00",3.1874999999999996,2.8541666666666661,1,6]
["Не выполнено",10,3.333333333333333,"2012-07-23T14:04:29",null,"14:04:29","00:00:00",3.1427199074047771,2.8093865740714437,1,6]
["Не выполнено",{"$f":"NETWORKDAYS(D164,IF(E164=\"\",TODAY(),E164))","v":13},{"$f":"$C$1*B164","v":4.333333333333333},"2012-07-18T14:50:12",null,{"$f":"MOD(D164,1)","v":"14:50:12"},{"$f":"MOD(E164,1)","v":"00:00:00"},{"$f":"C164-IF((OR(WEEKDAY(D164)=1,WEEKDAY(D164)=7)),0,(IF(MOD(D164,1)<$E$1,0,(IF(AND($E$1<MOD(D164,1),MOD(D164,1)<$E$2),MOD(D164,1)-$E$1,(IF(AND($E$2<MOD(D164,1),MOD(D164,1)<$F$2),$E$2-$E$1,(IF(AND($F$2<MOD(D164,1),MOD(D164,1)<$F$1),$E$2-$E$1+MOD(D164,1)-$F$2,(IF(MOD(D164,1)>$F$1,$C$1)))))))))))-IF((OR(WEEKDAY(IF(E164=\"\",TODAY(),E164))=1,WEEKDAY(IF(E164=\"\",TODAY(),E164))=7)),0,(IF(MOD(IF(E164=\"\",TODAY(),E164),1)<$E$1,$C$1,(IF(AND($E$1<MOD(IF(E164=\"\",TODAY(),E164),1),MOD(IF(E164=\"\",TODAY(),E164),1)<$E$2),$F$1-$F$2+$E$2-MOD(IF(E164=\"\",TODAY(),E164),1),(IF(AND($E$2<MOD(IF(E164=\"\",TODAY(),E164),1),MOD(IF(E164=\"\",TODAY(),E164),1)<$F$2),$F$1-$F$2,(IF(AND($F$2<MOD(IF(E164=\"\",TODAY(),E164),1),MOD(IF(E164=\"\",TODAY(),E164),1)<$F$1),$F$1-MOD(IF(E164=\"\",TODAY(),E164),1),(IF(MOD(IF(E164=\"\",TODAY(),E164),1)>$F$1,0)))))))))))","v":4.110972222219667},{"$f":"C164-(IF(F164<$E$1,0,(IF(AND($E$1<F164,F164<$E$2),F164-$E$1,(IF(AND($E$2<F164,F164<$F$2),$E$2-$E$1,(IF(AND($F$2<F164,F164<$F$1),$E$2-$E$1+F164-$F$2,(IF(F164>$F$1,$C$1))))))))))-(IF(G164<$E$1,$C$1,(IF(AND($E$1<G164,G164<$E$2),$F$1-$F$2+$E$2-G164,(IF(AND($E$2<G164,G164<$F$2),$F$1-$F$2,(IF(AND($F$2<G164,G164<$F$1),$F$1-G164,(IF(G164>$F$1,0))))))))))","v":3.7776388888863335},{"$f":"WEEKDAY(D164,2)","v":3},{"$f":"WEEKDAY(E164,2)","v":6}]
["Не выполнено",14,4.6666666666666661,"2012-07-17T08:40:59",null,"08:40:59","00:00:00",4.6590393518539104,4.3257060185205773,2,6]
["Не выполнено",14,4.6666666666666661,"2012-07-17T11:06:58",null,"11:06:58","00:00:00",4.5576620370387291,4.224328703705396,2,6]
["Не выполнено",15,5,"2012-07-16T09:55:04",null,"09:55:04","00:00:00",4.9409259259288474,4.6075925925955143,1,6]
["Не выполнено",19,6.333333333333333,"2012-07-10T12:45:13",null,"12:45:13","00:00:00",6.1875,5.854166666666667,2,6]
["Не выполнено",25,8.3333333333333321,"2012-07-02T08:45:00",null,"08:45:00","00:00:00",8.3229166666642396,7.9895833333309065,1,6]
["Не выполнено",25,8.3333333333333321,"2012-07-02T11:34:34",null,"11:34:34","00:00:00",8.2051620370402798,7.8718287037069468,1,6]

{"sheet":"Лист2","index":1,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,0,18,18]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["E1-\n(ЕСЛИ\n(G4<G1;0;\n(ЕСЛИ\n(G1<G4<G2;G4-G1;\n(\nЕСЛИ\n(\nG2<G4<H2;G2-G1;\n(\nЕСЛИ\n(H2<G4<H1;G2-G1-G4+H2;\n(ЕСЛИ(G4>H1;E1))\n)\n)\n)\n)\n)\n)\n)\n)"]

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}