{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,2,7,12],[2,0,2,8],[0,0,1,3],[13,0,13,1],[13,5,13,8]]}
["Summer Session Teaching GTF Calculator"]
[]
["To be used for individual assignments.  Do not combine assignments when using this calculator. Fill in the yellow blocks only. The calculator will populate the remaining items."]
[]
["Base Rate:",null,"Annual base rate used on both PRF and appointment contract."]
["Annual Basis:",null,"9 or 12 month (most teaching GTFs are paid on 9 month basis)"]
["FTE (Assigned FTE):",null,"Assigned FTE on the appointment contract should reflect the total workload (per term) for the particular assignment (e.g., .30 FTE, the minimum FTE for a 3-credit class, is 131 hours of work).\"Payable FTE\" on the PRF (see below) is…"]
[]
["Contract Start Date:",null,"Input as MM/DD/YY- use on both PRF and appointment contract."]
["Contract End Date:",null,"Input as MM/DD/YY- use on both PRF and appointment contract."]
[]
["Course Pay:",null,"Use on appointment contract; note this amount in \"remarks\" on PRF."]
[]
["Information specific to PRF:",null,null,null,null,"Information specific to appointment contract:"]
["Monthly Pay:",{"$f":"IF(AND(Sheet2!J2<>0,B12<>0,Sheet2!K2<>0),IF(B12>Sheet2!K2,ROUND(Sheet2!K2/Sheet2!J2,2),ROUND(B12/Sheet2!J2,2)),0)","v":0},null,null,null,"Monthly Pay: **Cite \"Total\" on appointment contract"]
["FTE (Payable FTE):",{"$f":"IF(B15<>0,ROUND(B15/(B5/B6),4),0)","v":0},null,"OVERLOAD:",null,null,"Regular","Overload","Total**"]
["Appointment Salary:",{"$f":"IF(AND(B12<>0,Sheet2!K2<>0),IF(B12>Sheet2!K2,Sheet2!K2,B12),0)","v":0},null,{"$f":"IF(B12>Sheet2!K2,B12-Sheet2!K2,0)","v":0},null,"June:",{"$f":"ROUND(SUM(Sheet2!J35:J64),2)","v":0},{"$f":"ROUND(SUM(Sheet2!K35:K64),2)","v":0},{"$f":"SUM(G17:H17)","v":0}]
[null,null,null,null,null,"July:",{"$f":"ROUND(SUM(Sheet2!J65:J95),2)","v":0},{"$f":"ROUND(SUM(Sheet2!K65:K95),2)","v":0},{"$f":"SUM(G18:H18)","v":0}]
[null,null,null,null,null,"Aug:",{"$f":"ROUND(SUM(Sheet2!J96:J126),2)","v":0},{"$f":"ROUND(SUM(Sheet2!K96:K126),2)","v":0},{"$f":"SUM(G19:H19)","v":0}]
[null,null,null,null,null,"Sept:",{"$f":"ROUND(SUM(Sheet2!J127:J156),2)","v":0},{"$f":"ROUND(SUM(Sheet2!K127:K156),2)","v":0},0]
["Last Updated:","2011-12-29",null,null,null,null,{"$f":"SUM(G16:G20)","v":0},{"$f":"SUM(H16:H20)","v":0},{"$f":"SUM(G21:H21)","v":0}]

{"sheet":"Sheet2","index":1,"n_rows":156,"n_cols":17,"rows_kept":156,"cut":false,"hidden":true,"merged":[[0,0,0,4]]}
["Year:",null,null,null,null,{"$f":"IF(Sheet1!B9<>0,YEAR(Sheet1!B9),YEAR(NOW()))","v":2011},"Start:",null,{"$f":"Sheet1!B9","v":"00:00:00"},"months","maximum"]
[null,null,null,null,null,null,"End:",null,{"$f":"Sheet1!B10","v":"00:00:00"},{"$f":"IF(AND(I1<>0,I2<>0),VLOOKUP(I2,A4:G734,7,0)-VLOOKUP((I1-1),A4:G734,7,0),0)","v":0},{"$f":"IF(AND(Sheet1!B5<>0,Sheet1!B6<>0,J2<>0),ROUND((Sheet1!B5/Sheet1!B6)*Sheet2!J2,2),0)","v":0}]
[null,null,null,null,null,null,"Course Pay:",null,{"$f":"Sheet1!B12","v":0},"salary","overload"]
[{"$f":"DATE(F1,5,1)","v":"2011-05-01"},{"$f":"WEEKDAY(A4)","v":1},{"$f":"IF(AND(B4<>1,B4<>7),1,0)","v":0},{"$f":"CONCATENATE(MONTH(A4),YEAR(A4))","v":"52011"},{"$f":"VLOOKUP(D4,$P$4:$Q$24,2,0)","v":22},{"$f":"ROUND(C4/E4,10)","v":0},0,null,{"$f":"IF(AND(A4>=$I$1,A4<=$I$2),ROUND(($I$3/$J$2)*F4,5),0)","v":0},{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I4>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F4,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F4,5),Sheet2!I4),0)","v":0},{"$f":"IF(I4>J4,I4-J4,0)","v":0},null,null,{"$f":"DATE($F$1,5,1)","v":"2011-05-01"},{"$f":"N5-1","v":"2011-05-31"},{"$f":"CONCATENATE(MONTH(N4),YEAR(N4))","v":"52011"},{"$f":"NETWORKDAYS(N4,O4)","v":22}]
[{"$f":"A4+1","v":"2011-05-02"},2,{"$f":"IF(AND(B5<>1,B5<>7),1,0)","v":1},"52011",22,{"$f":"ROUND(C5/E5,10)","v":4.5454545499999999E-2},{"$f":"F5+G4","v":4.5454545499999999E-2},null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I5>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F5,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F5,5),Sheet2!I5),0)","v":0},{"$f":"IF(I5>J5,I5-J5,0)","v":0},null,null,{"$f":"DATE($F$1,6,1)","v":"2011-06-01"},{"$f":"N6-1","v":"2011-06-30"},{"$f":"CONCATENATE(MONTH(N5),YEAR(N5))","v":"62011"},{"$f":"NETWORKDAYS(N5,O5)","v":22}]
[{"$f":"A5+1","v":"2011-05-03"},3,1,"52011",22,4.5454545499999999E-2,{"$f":"F6+G5","v":9.0909090999999997E-2},null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I6>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F6,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F6,5),Sheet2!I6),0)","v":0},{"$f":"IF(I6>J6,I6-J6,0)","v":0},null,null,{"$f":"DATE($F$1,7,1)","v":"2011-07-01"},{"$f":"N7-1","v":"2011-07-31"},{"$f":"CONCATENATE(MONTH(N6),YEAR(N6))","v":"72011"},{"$f":"NETWORKDAYS(N6,O6)","v":21}]
["2011-05-04",4,1,"52011",22,4.5454545499999999E-2,0.1363636365,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I7>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F7,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F7,5),Sheet2!I7),0)","v":0},0,null,null,{"$f":"DATE($F$1,8,1)","v":"2011-08-01"},{"$f":"N8-1","v":"2011-08-31"},{"$f":"CONCATENATE(MONTH(N7),YEAR(N7))","v":"82011"},{"$f":"NETWORKDAYS(N7,O7)","v":23}]
["2011-05-05",5,1,"52011",22,4.5454545499999999E-2,0.18181818199999999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I8>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F8,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F8,5),Sheet2!I8),0)","v":0},0,null,null,{"$f":"DATE($F$1,9,1)","v":"2011-09-01"},{"$f":"DATE(F1,9,30)","v":"2011-09-30"},{"$f":"CONCATENATE(MONTH(N8),YEAR(N8))","v":"92011"},{"$f":"NETWORKDAYS(N8,O8)","v":22}]
["2011-05-06",6,1,"52011",22,4.5454545499999999E-2,0.22727272749999999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I9>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F9,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F9,5),Sheet2!I9),0)","v":0},0]
["2011-05-07",7,0,"52011",22,0,0.22727272749999999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I10>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F10,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F10,5),Sheet2!I10),0)","v":0},0]
["2011-05-08",1,0,"52011",22,0,0.22727272749999999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I11>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F11,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F11,5),Sheet2!I11),0)","v":0},0]
["2011-05-09",2,1,"52011",22,4.5454545499999999E-2,0.27272727299999999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I12>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F12,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F12,5),Sheet2!I12),0)","v":0},0]
["2011-05-10",3,1,"52011",22,4.5454545499999999E-2,0.31818181849999999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I13>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F13,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F13,5),Sheet2!I13),0)","v":0},0]
["2011-05-11",4,1,"52011",22,4.5454545499999999E-2,0.36363636399999999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I14>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F14,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F14,5),Sheet2!I14),0)","v":0},0]
["2011-05-12",5,1,"52011",22,4.5454545499999999E-2,0.40909090949999999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I15>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F15,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F15,5),Sheet2!I15),0)","v":0},0]
["2011-05-13",6,1,"52011",22,4.5454545499999999E-2,0.45454545499999999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I16>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F16,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F16,5),Sheet2!I16),0)","v":0},0]
["2011-05-14",7,0,"52011",22,0,0.45454545499999999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I17>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F17,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F17,5),Sheet2!I17),0)","v":0},0]
["2011-05-15",1,0,"52011",22,0,0.45454545499999999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I18>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F18,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F18,5),Sheet2!I18),0)","v":0},0]
["2011-05-16",2,1,"52011",22,4.5454545499999999E-2,0.50000000050000004,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I19>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F19,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F19,5),Sheet2!I19),0)","v":0},0]
["2011-05-17",3,1,"52011",22,4.5454545499999999E-2,0.54545454599999998,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I20>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F20,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F20,5),Sheet2!I20),0)","v":0},0]
["2011-05-18",4,1,"52011",22,4.5454545499999999E-2,0.59090909149999993,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I21>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F21,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F21,5),Sheet2!I21),0)","v":0},0]
["2011-05-19",5,1,"52011",22,4.5454545499999999E-2,0.63636363699999987,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I22>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F22,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F22,5),Sheet2!I22),0)","v":0},0]
["2011-05-20",6,1,"52011",22,4.5454545499999999E-2,0.68181818249999981,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I23>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F23,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F23,5),Sheet2!I23),0)","v":0},0]
["2011-05-21",7,0,"52011",22,0,0.68181818249999981,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I24>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F24,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F24,5),Sheet2!I24),0)","v":0},0]
["2011-05-22",1,0,"52011",22,0,0.68181818249999981,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I25>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F25,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F25,5),Sheet2!I25),0)","v":0},0]
["2011-05-23",2,1,"52011",22,4.5454545499999999E-2,0.72727272799999976,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I26>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F26,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F26,5),Sheet2!I26),0)","v":0},0]
["2011-05-24",3,1,"52011",22,4.5454545499999999E-2,0.7727272734999997,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I27>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F27,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F27,5),Sheet2!I27),0)","v":0},0]
["2011-05-25",4,1,"52011",22,4.5454545499999999E-2,0.81818181899999964,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I28>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F28,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F28,5),Sheet2!I28),0)","v":0},0]
["2011-05-26",5,1,"52011",22,4.5454545499999999E-2,0.86363636449999959,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I29>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F29,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F29,5),Sheet2!I29),0)","v":0},0]
["2011-05-27",6,1,"52011",22,4.5454545499999999E-2,0.90909090999999953,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I30>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F30,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F30,5),Sheet2!I30),0)","v":0},0]
["2011-05-28",7,0,"52011",22,0,0.90909090999999953,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I31>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F31,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F31,5),Sheet2!I31),0)","v":0},0]
["2011-05-29",1,0,"52011",22,0,0.90909090999999953,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I32>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F32,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F32,5),Sheet2!I32),0)","v":0},0]
["2011-05-30",2,1,"52011",22,4.5454545499999999E-2,0.95454545549999947,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I33>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F33,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F33,5),Sheet2!I33),0)","v":0},0]
["2011-05-31",3,1,"52011",22,4.5454545499999999E-2,1.0000000009999994,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I34>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F34,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F34,5),Sheet2!I34),0)","v":0},0]
["2011-06-01",4,1,"62011",22,4.5454545499999999E-2,1.0454545464999994,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I35>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F35,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F35,5),Sheet2!I35),0)","v":0},0]
["2011-06-02",{"$f":"WEEKDAY(A36)","v":5},1,{"$f":"CONCATENATE(MONTH(A36),YEAR(A36))","v":"62011"},{"$f":"VLOOKUP(D36,$P$4:$Q$24,2,0)","v":22},4.5454545499999999E-2,1.0909090919999993,null,{"$f":"IF(AND(A36>=$I$1,A36<=$I$2),ROUND(($I$3/$J$2)*F36,5),0)","v":0},{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I36>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F36,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F36,5),Sheet2!I36),0)","v":0},0]
["2011-06-03",6,1,"62011",22,4.5454545499999999E-2,1.1363636374999992,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I37>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F37,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F37,5),Sheet2!I37),0)","v":0},0]
["2011-06-04",7,0,"62011",22,0,1.1363636374999992,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I38>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F38,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F38,5),Sheet2!I38),0)","v":0},0]
["2011-06-05",1,0,"62011",22,0,1.1363636374999992,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I39>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F39,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F39,5),Sheet2!I39),0)","v":0},0]
["2011-06-06",2,1,"62011",22,4.5454545499999999E-2,1.1818181829999992,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I40>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F40,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F40,5),Sheet2!I40),0)","v":0},0]
["2011-06-07",3,1,"62011",22,4.5454545499999999E-2,1.2272727284999991,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I41>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F41,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F41,5),Sheet2!I41),0)","v":0},0]
["2011-06-08",4,1,"62011",22,4.5454545499999999E-2,1.2727272739999991,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I42>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F42,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F42,5),Sheet2!I42),0)","v":0},0]
["2011-06-09",5,1,"62011",22,4.5454545499999999E-2,1.318181819499999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I43>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F43,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F43,5),Sheet2!I43),0)","v":0},0]
["2011-06-10",6,1,"62011",22,4.5454545499999999E-2,1.363636364999999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I44>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F44,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F44,5),Sheet2!I44),0)","v":0},0]
["2011-06-11",7,0,"62011",22,0,1.363636364999999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I45>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F45,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F45,5),Sheet2!I45),0)","v":0},0]
["2011-06-12",1,0,"62011",22,0,1.363636364999999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I46>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F46,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F46,5),Sheet2!I46),0)","v":0},0]
["2011-06-13",2,1,"62011",22,4.5454545499999999E-2,1.4090909104999989,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I47>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F47,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F47,5),Sheet2!I47),0)","v":0},0]
["2011-06-14",3,1,"62011",22,4.5454545499999999E-2,1.4545454559999988,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I48>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F48,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F48,5),Sheet2!I48),0)","v":0},0]
["2011-06-15",4,1,"62011",22,4.5454545499999999E-2,1.5000000014999988,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I49>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F49,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F49,5),Sheet2!I49),0)","v":0},0]
["2011-06-16",5,1,"62011",22,4.5454545499999999E-2,1.5454545469999987,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I50>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F50,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F50,5),Sheet2!I50),0)","v":0},0]
["2011-06-17",6,1,"62011",22,4.5454545499999999E-2,1.5909090924999987,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I51>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F51,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F51,5),Sheet2!I51),0)","v":0},0]
["2011-06-18",7,0,"62011",22,0,1.5909090924999987,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I52>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F52,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F52,5),Sheet2!I52),0)","v":0},0]
["2011-06-19",1,0,"62011",22,0,1.5909090924999987,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I53>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F53,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F53,5),Sheet2!I53),0)","v":0},0]
["2011-06-20",2,1,"62011",22,4.5454545499999999E-2,1.6363636379999986,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I54>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F54,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F54,5),Sheet2!I54),0)","v":0},0]
["2011-06-21",3,1,"62011",22,4.5454545499999999E-2,1.6818181834999986,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I55>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F55,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F55,5),Sheet2!I55),0)","v":0},0]
["2011-06-22",4,1,"62011",22,4.5454545499999999E-2,1.7272727289999985,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I56>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F56,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F56,5),Sheet2!I56),0)","v":0},0]
["2011-06-23",5,1,"62011",22,4.5454545499999999E-2,1.7727272744999985,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I57>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F57,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F57,5),Sheet2!I57),0)","v":0},0]
["2011-06-24",6,1,"62011",22,4.5454545499999999E-2,1.8181818199999984,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I58>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F58,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F58,5),Sheet2!I58),0)","v":0},0]
["2011-06-25",7,0,"62011",22,0,1.8181818199999984,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I59>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F59,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F59,5),Sheet2!I59),0)","v":0},0]
["2011-06-26",1,0,"62011",22,0,1.8181818199999984,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I60>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F60,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F60,5),Sheet2!I60),0)","v":0},0]
["2011-06-27",2,1,"62011",22,4.5454545499999999E-2,1.8636363654999983,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I61>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F61,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F61,5),Sheet2!I61),0)","v":0},0]
["2011-06-28",3,1,"62011",22,4.5454545499999999E-2,1.9090909109999983,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I62>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F62,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F62,5),Sheet2!I62),0)","v":0},0]
["2011-06-29",4,1,"62011",22,4.5454545499999999E-2,1.9545454564999982,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I63>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F63,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F63,5),Sheet2!I63),0)","v":0},0]
["2011-06-30",5,1,"62011",22,4.5454545499999999E-2,2.0000000019999984,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I64>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F64,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F64,5),Sheet2!I64),0)","v":0},0]
["2011-07-01",6,1,"72011",21,4.7619047599999999E-2,2.0476190495999984,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I65>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F65,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F65,5),Sheet2!I65),0)","v":0},0]
["2011-07-02",7,0,"72011",21,0,2.0476190495999984,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I66>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F66,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F66,5),Sheet2!I66),0)","v":0},0]
["2011-07-03",1,0,"72011",21,0,2.0476190495999984,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I67>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F67,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F67,5),Sheet2!I67),0)","v":0},0]
["2011-07-04",{"$f":"WEEKDAY(A68)","v":2},1,{"$f":"CONCATENATE(MONTH(A68),YEAR(A68))","v":"72011"},{"$f":"VLOOKUP(D68,$P$4:$Q$24,2,0)","v":21},4.7619047599999999E-2,2.0952380971999984,null,{"$f":"IF(AND(A68>=$I$1,A68<=$I$2),ROUND(($I$3/$J$2)*F68,5),0)","v":0},{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I68>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F68,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F68,5),Sheet2!I68),0)","v":0},0]
["2011-07-05",3,{"$f":"IF(AND(B69<>1,B69<>7),1,0)","v":1},"72011",21,{"$f":"ROUND(C69/E69,10)","v":4.7619047599999999E-2},2.1428571447999984,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I69>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F69,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F69,5),Sheet2!I69),0)","v":0},0]
[{"$f":"A69+1","v":"2011-07-06"},4,1,"72011",21,4.7619047599999999E-2,{"$f":"F70+G69","v":2.1904761923999985},null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I70>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F70,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F70,5),Sheet2!I70),0)","v":0},{"$f":"IF(I70>J70,I70-J70,0)","v":0}]
["2011-07-07",5,1,"72011",21,4.7619047599999999E-2,2.2380952399999985,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I71>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F71,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F71,5),Sheet2!I71),0)","v":0},0]
["2011-07-08",6,1,"72011",21,4.7619047599999999E-2,2.2857142875999985,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I72>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F72,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F72,5),Sheet2!I72),0)","v":0},0]
["2011-07-09",7,0,"72011",21,0,2.2857142875999985,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I73>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F73,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F73,5),Sheet2!I73),0)","v":0},0]
["2011-07-10",1,0,"72011",21,0,2.2857142875999985,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I74>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F74,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F74,5),Sheet2!I74),0)","v":0},0]
["2011-07-11",2,1,"72011",21,4.7619047599999999E-2,2.3333333351999985,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I75>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F75,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F75,5),Sheet2!I75),0)","v":0},0]
["2011-07-12",3,1,"72011",21,4.7619047599999999E-2,2.3809523827999985,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I76>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F76,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F76,5),Sheet2!I76),0)","v":0},0]
["2011-07-13",4,1,"72011",21,4.7619047599999999E-2,2.4285714303999986,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I77>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F77,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F77,5),Sheet2!I77),0)","v":0},0]
["2011-07-14",5,1,"72011",21,4.7619047599999999E-2,2.4761904779999986,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I78>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F78,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F78,5),Sheet2!I78),0)","v":0},0]
["2011-07-15",6,1,"72011",21,4.7619047599999999E-2,2.5238095255999986,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I79>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F79,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F79,5),Sheet2!I79),0)","v":0},0]
["2011-07-16",7,0,"72011",21,0,2.5238095255999986,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I80>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F80,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F80,5),Sheet2!I80),0)","v":0},0]
["2011-07-17",1,0,"72011",21,0,2.5238095255999986,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I81>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F81,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F81,5),Sheet2!I81),0)","v":0},0]
["2011-07-18",2,1,"72011",21,4.7619047599999999E-2,2.5714285731999986,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I82>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F82,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F82,5),Sheet2!I82),0)","v":0},0]
["2011-07-19",3,1,"72011",21,4.7619047599999999E-2,2.6190476207999986,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I83>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F83,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F83,5),Sheet2!I83),0)","v":0},0]
["2011-07-20",4,1,"72011",21,4.7619047599999999E-2,2.6666666683999987,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I84>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F84,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F84,5),Sheet2!I84),0)","v":0},0]
["2011-07-21",5,1,"72011",21,4.7619047599999999E-2,2.7142857159999987,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I85>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F85,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F85,5),Sheet2!I85),0)","v":0},0]
["2011-07-22",6,1,"72011",21,4.7619047599999999E-2,2.7619047635999987,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I86>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F86,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F86,5),Sheet2!I86),0)","v":0},0]
["2011-07-23",7,0,"72011",21,0,2.7619047635999987,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I87>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F87,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F87,5),Sheet2!I87),0)","v":0},0]
["2011-07-24",1,0,"72011",21,0,2.7619047635999987,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I88>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F88,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F88,5),Sheet2!I88),0)","v":0},0]
["2011-07-25",2,1,"72011",21,4.7619047599999999E-2,2.8095238111999987,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I89>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F89,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F89,5),Sheet2!I89),0)","v":0},0]
["2011-07-26",3,1,"72011",21,4.7619047599999999E-2,2.8571428587999987,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I90>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F90,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F90,5),Sheet2!I90),0)","v":0},0]
["2011-07-27",4,1,"72011",21,4.7619047599999999E-2,2.9047619063999988,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I91>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F91,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F91,5),Sheet2!I91),0)","v":0},0]
["2011-07-28",5,1,"72011",21,4.7619047599999999E-2,2.9523809539999988,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I92>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F92,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F92,5),Sheet2!I92),0)","v":0},0]
["2011-07-29",6,1,"72011",21,4.7619047599999999E-2,3.0000000015999988,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I93>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F93,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F93,5),Sheet2!I93),0)","v":0},0]
["2011-07-30",7,0,"72011",21,0,3.0000000015999988,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I94>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F94,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F94,5),Sheet2!I94),0)","v":0},0]
["2011-07-31",1,0,"72011",21,0,3.0000000015999988,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I95>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F95,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F95,5),Sheet2!I95),0)","v":0},0]
["2011-08-01",2,1,"82011",23,4.3478260900000003E-2,3.043478262499999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I96>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F96,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F96,5),Sheet2!I96),0)","v":0},0]
["2011-08-02",3,1,"82011",23,4.3478260900000003E-2,3.0869565233999992,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I97>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F97,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F97,5),Sheet2!I97),0)","v":0},0]
["2011-08-03",4,1,"82011",23,4.3478260900000003E-2,3.1304347842999993,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I98>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F98,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F98,5),Sheet2!I98),0)","v":0},0]
["2011-08-04",5,1,"82011",23,4.3478260900000003E-2,3.1739130451999995,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I99>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F99,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F99,5),Sheet2!I99),0)","v":0},0]
["2011-08-05",{"$f":"WEEKDAY(A100)","v":6},1,{"$f":"CONCATENATE(MONTH(A100),YEAR(A100))","v":"82011"},{"$f":"VLOOKUP(D100,$P$4:$Q$24,2,0)","v":23},4.3478260900000003E-2,3.2173913060999997,null,{"$f":"IF(AND(A100>=$I$1,A100<=$I$2),ROUND(($I$3/$J$2)*F100,5),0)","v":0},{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I100>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F100,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F100,5),Sheet2!I100),0)","v":0},0]
["2011-08-06",7,0,"82011",23,0,3.2173913060999997,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I101>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F101,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F101,5),Sheet2!I101),0)","v":0},0]
["2011-08-07",1,0,"82011",23,0,3.2173913060999997,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I102>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F102,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F102,5),Sheet2!I102),0)","v":0},0]
["2011-08-08",2,1,"82011",23,4.3478260900000003E-2,3.2608695669999999,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I103>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F103,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F103,5),Sheet2!I103),0)","v":0},0]
["2011-08-09",3,1,"82011",23,4.3478260900000003E-2,3.3043478279,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I104>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F104,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F104,5),Sheet2!I104),0)","v":0},0]
["2011-08-10",4,1,"82011",23,4.3478260900000003E-2,3.3478260888000002,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I105>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F105,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F105,5),Sheet2!I105),0)","v":0},0]
["2011-08-11",5,1,"82011",23,4.3478260900000003E-2,3.3913043497000004,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I106>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F106,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F106,5),Sheet2!I106),0)","v":0},0]
["2011-08-12",6,1,"82011",23,4.3478260900000003E-2,3.4347826106000006,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I107>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F107,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F107,5),Sheet2!I107),0)","v":0},0]
["2011-08-13",7,0,"82011",23,0,3.4347826106000006,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I108>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F108,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F108,5),Sheet2!I108),0)","v":0},0]
["2011-08-14",1,0,"82011",23,0,3.4347826106000006,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I109>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F109,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F109,5),Sheet2!I109),0)","v":0},0]
["2011-08-15",2,1,"82011",23,4.3478260900000003E-2,3.4782608715000007,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I110>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F110,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F110,5),Sheet2!I110),0)","v":0},0]
["2011-08-16",3,1,"82011",23,4.3478260900000003E-2,3.5217391324000009,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I111>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F111,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F111,5),Sheet2!I111),0)","v":0},0]
["2011-08-17",4,1,"82011",23,4.3478260900000003E-2,3.5652173933000011,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I112>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F112,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F112,5),Sheet2!I112),0)","v":0},0]
["2011-08-18",5,1,"82011",23,4.3478260900000003E-2,3.6086956542000013,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I113>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F113,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F113,5),Sheet2!I113),0)","v":0},0]
["2011-08-19",6,1,"82011",23,4.3478260900000003E-2,3.6521739151000014,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I114>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F114,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F114,5),Sheet2!I114),0)","v":0},0]
["2011-08-20",7,0,"82011",23,0,3.6521739151000014,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I115>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F115,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F115,5),Sheet2!I115),0)","v":0},0]
["2011-08-21",1,0,"82011",23,0,3.6521739151000014,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I116>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F116,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F116,5),Sheet2!I116),0)","v":0},0]
["2011-08-22",2,1,"82011",23,4.3478260900000003E-2,3.6956521760000016,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I117>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F117,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F117,5),Sheet2!I117),0)","v":0},0]
["2011-08-23",3,1,"82011",23,4.3478260900000003E-2,3.7391304369000018,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I118>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F118,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F118,5),Sheet2!I118),0)","v":0},0]
["2011-08-24",4,1,"82011",23,4.3478260900000003E-2,3.782608697800002,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I119>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F119,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F119,5),Sheet2!I119),0)","v":0},0]
["2011-08-25",5,1,"82011",23,4.3478260900000003E-2,3.8260869587000021,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I120>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F120,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F120,5),Sheet2!I120),0)","v":0},0]
["2011-08-26",6,1,"82011",23,4.3478260900000003E-2,3.8695652196000023,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I121>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F121,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F121,5),Sheet2!I121),0)","v":0},0]
["2011-08-27",7,0,"82011",23,0,3.8695652196000023,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I122>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F122,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F122,5),Sheet2!I122),0)","v":0},0]
["2011-08-28",1,0,"82011",23,0,3.8695652196000023,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I123>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F123,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F123,5),Sheet2!I123),0)","v":0},0]
[{"$f":"A123+1","v":"2011-08-29"},2,1,"82011",23,4.3478260900000003E-2,3.9130434805000025,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I124>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F124,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F124,5),Sheet2!I124),0)","v":0},0]
["2011-08-30",3,1,"82011",23,4.3478260900000003E-2,3.9565217414000027,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I125>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F125,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F125,5),Sheet2!I125),0)","v":0},0]
["2011-08-31",4,1,"82011",23,4.3478260900000003E-2,4.0000000023000029,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I126>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F126,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F126,5),Sheet2!I126),0)","v":0},0]
["2011-09-01",5,1,"92011",22,4.5454545499999999E-2,4.045454547800003,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I127>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F127,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F127,5),Sheet2!I127),0)","v":0},0]
["2011-09-02",6,1,"92011",22,4.5454545499999999E-2,4.0909090933000032,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I128>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F128,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F128,5),Sheet2!I128),0)","v":0},0]
["2011-09-03",7,0,"92011",22,0,4.0909090933000032,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I129>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F129,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F129,5),Sheet2!I129),0)","v":0},0]
["2011-09-04",1,0,"92011",22,0,4.0909090933000032,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I130>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F130,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F130,5),Sheet2!I130),0)","v":0},0]
["2011-09-05",2,1,"92011",22,4.5454545499999999E-2,4.1363636388000034,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I131>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F131,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F131,5),Sheet2!I131),0)","v":0},0]
["2011-09-06",{"$f":"WEEKDAY(A132)","v":3},1,{"$f":"CONCATENATE(MONTH(A132),YEAR(A132))","v":"92011"},{"$f":"VLOOKUP(D132,$P$4:$Q$24,2,0)","v":22},4.5454545499999999E-2,4.1818181843000035,null,{"$f":"IF(AND(A132>=$I$1,A132<=$I$2),ROUND(($I$3/$J$2)*F132,5),0)","v":0},{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I132>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F132,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F132,5),Sheet2!I132),0)","v":0},0]
["2011-09-07",4,{"$f":"IF(AND(B133<>1,B133<>7),1,0)","v":1},"92011",22,{"$f":"ROUND(C133/E133,10)","v":4.5454545499999999E-2},4.2272727298000037,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I133>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F133,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F133,5),Sheet2!I133),0)","v":0},0]
[{"$f":"A133+1","v":"2011-09-08"},5,1,"92011",22,4.5454545499999999E-2,{"$f":"F134+G133","v":4.2727272753000038},null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I134>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F134,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F134,5),Sheet2!I134),0)","v":0},{"$f":"IF(I134>J134,I134-J134,0)","v":0}]
["2011-09-09",6,1,"92011",22,4.5454545499999999E-2,4.318181820800004,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I135>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F135,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F135,5),Sheet2!I135),0)","v":0},0]
["2011-09-10",7,0,"92011",22,0,4.318181820800004,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I136>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F136,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F136,5),Sheet2!I136),0)","v":0},0]
["2011-09-11",1,0,"92011",22,0,4.318181820800004,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I137>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F137,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F137,5),Sheet2!I137),0)","v":0},0]
["2011-09-12",2,1,"92011",22,4.5454545499999999E-2,4.3636363663000042,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I138>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F138,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F138,5),Sheet2!I138),0)","v":0},0]
["2011-09-13",3,1,"92011",22,4.5454545499999999E-2,4.4090909118000043,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I139>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F139,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F139,5),Sheet2!I139),0)","v":0},0]
["2011-09-14",4,1,"92011",22,4.5454545499999999E-2,4.4545454573000045,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I140>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F140,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F140,5),Sheet2!I140),0)","v":0},0]
["2011-09-15",5,1,"92011",22,4.5454545499999999E-2,4.5000000028000047,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I141>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F141,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F141,5),Sheet2!I141),0)","v":0},0]
["2011-09-16",6,1,"92011",22,4.5454545499999999E-2,4.5454545483000048,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I142>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F142,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F142,5),Sheet2!I142),0)","v":0},0]
["2011-09-17",7,0,"92011",22,0,4.5454545483000048,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I143>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F143,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F143,5),Sheet2!I143),0)","v":0},0]
["2011-09-18",1,0,"92011",22,0,4.5454545483000048,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I144>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F144,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F144,5),Sheet2!I144),0)","v":0},0]
["2011-09-19",2,1,"92011",22,4.5454545499999999E-2,4.590909093800005,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I145>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F145,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F145,5),Sheet2!I145),0)","v":0},0]
["2011-09-20",3,1,"92011",22,4.5454545499999999E-2,4.6363636393000052,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I146>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F146,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F146,5),Sheet2!I146),0)","v":0},0]
["2011-09-21",4,1,"92011",22,4.5454545499999999E-2,4.6818181848000053,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I147>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F147,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F147,5),Sheet2!I147),0)","v":0},0]
["2011-09-22",5,1,"92011",22,4.5454545499999999E-2,4.7272727303000055,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I148>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F148,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F148,5),Sheet2!I148),0)","v":0},0]
["2011-09-23",6,1,"92011",22,4.5454545499999999E-2,4.7727272758000057,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I149>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F149,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F149,5),Sheet2!I149),0)","v":0},0]
["2011-09-24",7,0,"92011",22,0,4.7727272758000057,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I150>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F150,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F150,5),Sheet2!I150),0)","v":0},0]
["2011-09-25",1,0,"92011",22,0,4.7727272758000057,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I151>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F151,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F151,5),Sheet2!I151),0)","v":0},0]
["2011-09-26",2,1,"92011",22,4.5454545499999999E-2,4.8181818213000058,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I152>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F152,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F152,5),Sheet2!I152),0)","v":0},0]
["2011-09-27",3,1,"92011",22,4.5454545499999999E-2,4.863636366800006,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I153>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F153,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F153,5),Sheet2!I153),0)","v":0},0]
["2011-09-28",4,1,"92011",22,4.5454545499999999E-2,4.9090909123000062,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I154>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F154,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F154,5),Sheet2!I154),0)","v":0},0]
["2011-09-29",5,1,"92011",22,4.5454545499999999E-2,4.9545454578000063,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I155>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F155,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F155,5),Sheet2!I155),0)","v":0},0]
["2011-09-30",6,1,"92011",22,4.5454545499999999E-2,5.0000000033000065,null,0,{"$f":"IF(AND(Sheet1!$B$5<>0,Sheet1!$B$6<>0),IF(I156>ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F156,5),ROUND(Sheet1!$B$5/Sheet1!$B$6*Sheet2!F156,5),Sheet2!I156),0)","v":0},0]