{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["A-Assignment Worksheet","I-Inputs","C-Attachment To Assignment","D-Attachment Payments","B-Block Ticket"," E- Internal Payments","F - Payoff","D-Checklist","N - Payment Histories","SDA Instructions","C-Stream Advance"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":20,"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":"A-Assignment Worksheet","index":0,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[3,6,3,7],[4,6,4,7],[5,6,5,7],[6,6,6,7],[2,3,2,4],[2,0,2,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[5,3,5,4],[6,3,6,4],[3,3,3,4],[4,3,4,4]]}
["SDA STREAM ASSIGNMENT WORKSHEET",null,null,null,null,null,null,null,null,null,null,"Send completed worksheet to Cash@SDAinc.net"]
["(Attachment to Assignment)",null,null,null,null,null,null,null,null,null,null,"Call 404-352-9936 for assistance."]
["Dealer Name:",null,null,null,null,null,null,null,null,"Payment Types:"]
[null,null,"Address:",null,null,"City:",null,null,null,"W - Weekly"]
["State:",null,null,null,null,"ZIP:",null,null,null,"B - BiWeekly"]
["Phone:",null,null,null,null,"Email:",null,null,null,"M - Monthly"]
["Fax:",null,null,null,null,"Date:",null,null,null,"S - Semimonthly"]
[]
[null,"Payment Type","Date SOLD to Customer","# of Payments Remaining","Payment Amount","Next Payment Due Date","Car Year","Make","Model","Last Name","First Name","Current Loan Balance"]
["EX","M","2017-12-15",36,175,"2018-01-15",2011,"Chevy","Malibu","Smith","David",9525]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[null,"Do not insert additional lines.   Please start a new worksheet.  SDA will consolidate the request.  Send completed worksheet to Cash@SDAinc.net",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L11:L35)","v":0}]

{"sheet":"I-Inputs","index":1,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":true,"merged":[[1,0,1,2]]}
["STREAM Model Inputs"]
["Notes:\nRed Text is a variable to be completed by SDA Only.\nBlue Text is input comleted by Dealers.\nAll Black text is a formula and is automatically calculated."]
[]
["Dealer Inputs",null,"Notes","RCR Defaults"]
["Dealership Name:",{"$f":"+'A-Assignment Worksheet'!D3","v":0},"Copied from Dealer Completed Form","Dealer Default"]
["State:",{"$f":"+'A-Assignment Worksheet'!D5","v":0},"Determines Checklist Requirements"]
["Batch #:",1]
["Batch ID:","18F2"]
["Branch ID:","Stream1"]
["Pkg No:"]
["Attachment to Assignment Date:","2018-05-21","Date received from Dealer"]
["Funding Date:","2018-05-24","Date received from Dealer"]
[]
[]
["Financial Deal Inputs",null,"Notes","RCR Defaults"]
["Term (Months):",12,"Term in Months.","6,9,12,18,24"]
["Percentage",0.8,"Stream Percentage",0.8]
["Batch Payment Frequency:","W","W-Weekly, B-Biweekly, M-Monthly, S-Semi-Monthly","Monthly"]
["First Payment Date:","2018-05-24","Maximum Advance Fee as defined by loan committee",700]
["Last Payment Date",{"$f":"EDATE(B19,B16)","v":"2019-05-24"},"Maximum funding per account as defined by loan committee",10000]
["Days in Batch:",{"$f":"DATEDIF(B19,B20,\"D\")","v":365},"Rate per month as defined by loan committee",1.2500000000000001E-2]
["Payoff Amount:",100,"Payoff From any Previous Batch."]
["Title Escrow Fee:",200,"Cost to dealer for not providing titles.",200]
["Administrative Fee",10,"Any other negotiated fees for the dealer."]
["Wire Fee:",30,"Charged at the time of Funding.",30]
[]
[]
[]
["Funding Details",null,"Notes","RCR Defaults"]
["First Payment Date:",{"$f":"+B19","v":"2018-05-24"},"Defaults to the first day of the Batch"]
["Payment Frequency in Days:",{"$f":"VLOOKUP(B18,'C-Stream Advance'!V4:X7,3,FALSE)","v":7},"Payment frequency as defined by Loan Committeee",7]

{"sheet":"C-Attachment To Assignment","index":2,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":true,"merged":[[2,0,2,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[2,3,2,5]]}
["ATTACHMENT TO ASSIGNMENT DATED:",null,null,null,null,null,{"$f":"+'I-Inputs'!B11","v":"2018-05-21"}]
[]
["Dealership Name:",null,null,{"$f":"+'A-Assignment Worksheet'!D3","v":0},null,null,null,"Batch #:",{"$f":"+'I-Inputs'!B7","v":1}]
[null,null,"Address:",{"$f":"+'A-Assignment Worksheet'!D4","v":0}]
["City:",null,null,{"$f":"+'A-Assignment Worksheet'!G4","v":0},null,null,null,"State:",{"$f":"+'A-Assignment Worksheet'!D5","v":0}]
["Phone:",null,null,{"$f":"+'A-Assignment Worksheet'!D6","v":0},null,null,null,"Zip:",{"$f":"+'A-Assignment Worksheet'!G5","v":0}]
["Fax:",null,null,{"$f":"+'A-Assignment Worksheet'!D7","v":0},null,null,null,"Email:",{"$f":"+'A-Assignment Worksheet'!G6","v":0}]
[]
[]
[null,"Last Name","First Name","Car Year","Make","Model","Payment","Payments Year","Stream Advance Amount","Title Escrow Fee"]
[1,{"$f":"+'A-Assignment Worksheet'!J11","v":0},{"$f":"+'A-Assignment Worksheet'!K11","v":0},{"$f":"+'A-Assignment Worksheet'!G11","v":0},{"$f":"+'A-Assignment Worksheet'!H11","v":0},{"$f":"+'A-Assignment Worksheet'!I11","v":0},{"$f":"+'A-Assignment Worksheet'!E11","v":0},{"$f":"+'C-Stream Advance'!H11","v":""},{"$f":"+'C-Stream Advance'!L11","v":""},{"$f":"(IF('A-Assignment Worksheet'!L11>0,(IF('D-Checklist'!G10=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[2,{"$f":"+'A-Assignment Worksheet'!J12","v":0},{"$f":"+'A-Assignment Worksheet'!K12","v":0},{"$f":"+'A-Assignment Worksheet'!G12","v":0},{"$f":"+'A-Assignment Worksheet'!H12","v":0},{"$f":"+'A-Assignment Worksheet'!I12","v":0},{"$f":"+'A-Assignment Worksheet'!E12","v":0},{"$f":"+'C-Stream Advance'!H12","v":""},{"$f":"+'C-Stream Advance'!L12","v":""},{"$f":"(IF('A-Assignment Worksheet'!L12>0,(IF('D-Checklist'!G11=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[3,{"$f":"+'A-Assignment Worksheet'!J13","v":0},{"$f":"+'A-Assignment Worksheet'!K13","v":0},{"$f":"+'A-Assignment Worksheet'!G13","v":0},{"$f":"+'A-Assignment Worksheet'!H13","v":0},{"$f":"+'A-Assignment Worksheet'!I13","v":0},{"$f":"+'A-Assignment Worksheet'!E13","v":0},{"$f":"+'C-Stream Advance'!H13","v":""},{"$f":"+'C-Stream Advance'!L13","v":""},{"$f":"(IF('A-Assignment Worksheet'!L13>0,(IF('D-Checklist'!G12=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[4,{"$f":"+'A-Assignment Worksheet'!J14","v":0},{"$f":"+'A-Assignment Worksheet'!K14","v":0},{"$f":"+'A-Assignment Worksheet'!G14","v":0},{"$f":"+'A-Assignment Worksheet'!H14","v":0},{"$f":"+'A-Assignment Worksheet'!I14","v":0},{"$f":"+'A-Assignment Worksheet'!E14","v":0},{"$f":"+'C-Stream Advance'!H14","v":""},{"$f":"+'C-Stream Advance'!L14","v":""},{"$f":"(IF('A-Assignment Worksheet'!L14>0,(IF('D-Checklist'!G13=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[5,{"$f":"+'A-Assignment Worksheet'!J15","v":0},{"$f":"+'A-Assignment Worksheet'!K15","v":0},{"$f":"+'A-Assignment Worksheet'!G15","v":0},{"$f":"+'A-Assignment Worksheet'!H15","v":0},{"$f":"+'A-Assignment Worksheet'!I15","v":0},{"$f":"+'A-Assignment Worksheet'!E15","v":0},{"$f":"+'C-Stream Advance'!H15","v":""},{"$f":"+'C-Stream Advance'!L15","v":""},{"$f":"(IF('A-Assignment Worksheet'!L15>0,(IF('D-Checklist'!G14=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[6,{"$f":"+'A-Assignment Worksheet'!J16","v":0},{"$f":"+'A-Assignment Worksheet'!K16","v":0},{"$f":"+'A-Assignment Worksheet'!G16","v":0},{"$f":"+'A-Assignment Worksheet'!H16","v":0},{"$f":"+'A-Assignment Worksheet'!I16","v":0},{"$f":"+'A-Assignment Worksheet'!E16","v":0},{"$f":"+'C-Stream Advance'!H16","v":""},{"$f":"+'C-Stream Advance'!L16","v":""},{"$f":"(IF('A-Assignment Worksheet'!L16>0,(IF('D-Checklist'!G15=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[7,{"$f":"+'A-Assignment Worksheet'!J17","v":0},{"$f":"+'A-Assignment Worksheet'!K17","v":0},{"$f":"+'A-Assignment Worksheet'!G17","v":0},{"$f":"+'A-Assignment Worksheet'!H17","v":0},{"$f":"+'A-Assignment Worksheet'!I17","v":0},{"$f":"+'A-Assignment Worksheet'!E17","v":0},{"$f":"+'C-Stream Advance'!H17","v":""},{"$f":"+'C-Stream Advance'!L17","v":""},{"$f":"(IF('A-Assignment Worksheet'!L17>0,(IF('D-Checklist'!G16=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[8,{"$f":"+'A-Assignment Worksheet'!J18","v":0},{"$f":"+'A-Assignment Worksheet'!K18","v":0},{"$f":"+'A-Assignment Worksheet'!G18","v":0},{"$f":"+'A-Assignment Worksheet'!H18","v":0},{"$f":"+'A-Assignment Worksheet'!I18","v":0},{"$f":"+'A-Assignment Worksheet'!E18","v":0},{"$f":"+'C-Stream Advance'!H18","v":""},{"$f":"+'C-Stream Advance'!L18","v":""},{"$f":"(IF('A-Assignment Worksheet'!L18>0,(IF('D-Checklist'!G17=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[9,{"$f":"+'A-Assignment Worksheet'!J19","v":0},{"$f":"+'A-Assignment Worksheet'!K19","v":0},{"$f":"+'A-Assignment Worksheet'!G19","v":0},{"$f":"+'A-Assignment Worksheet'!H19","v":0},{"$f":"+'A-Assignment Worksheet'!I19","v":0},{"$f":"+'A-Assignment Worksheet'!E19","v":0},{"$f":"+'C-Stream Advance'!H19","v":""},{"$f":"+'C-Stream Advance'!L19","v":""},{"$f":"(IF('A-Assignment Worksheet'!L19>0,(IF('D-Checklist'!G18=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[10,{"$f":"+'A-Assignment Worksheet'!J20","v":0},{"$f":"+'A-Assignment Worksheet'!K20","v":0},{"$f":"+'A-Assignment Worksheet'!G20","v":0},{"$f":"+'A-Assignment Worksheet'!H20","v":0},{"$f":"+'A-Assignment Worksheet'!I20","v":0},{"$f":"+'A-Assignment Worksheet'!E20","v":0},{"$f":"+'C-Stream Advance'!H20","v":""},{"$f":"+'C-Stream Advance'!L20","v":""},{"$f":"(IF('A-Assignment Worksheet'!L20>0,(IF('D-Checklist'!G19=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[11,{"$f":"+'A-Assignment Worksheet'!J21","v":0},{"$f":"+'A-Assignment Worksheet'!K21","v":0},{"$f":"+'A-Assignment Worksheet'!G21","v":0},{"$f":"+'A-Assignment Worksheet'!H21","v":0},{"$f":"+'A-Assignment Worksheet'!I21","v":0},{"$f":"+'A-Assignment Worksheet'!E21","v":0},{"$f":"+'C-Stream Advance'!H21","v":""},{"$f":"+'C-Stream Advance'!L21","v":""},{"$f":"(IF('A-Assignment Worksheet'!L21>0,(IF('D-Checklist'!G20=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[12,{"$f":"+'A-Assignment Worksheet'!J22","v":0},{"$f":"+'A-Assignment Worksheet'!K22","v":0},{"$f":"+'A-Assignment Worksheet'!G22","v":0},{"$f":"+'A-Assignment Worksheet'!H22","v":0},{"$f":"+'A-Assignment Worksheet'!I22","v":0},{"$f":"+'A-Assignment Worksheet'!E22","v":0},{"$f":"+'C-Stream Advance'!H22","v":""},{"$f":"+'C-Stream Advance'!L22","v":""},{"$f":"(IF('A-Assignment Worksheet'!L22>0,(IF('D-Checklist'!G21=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[13,{"$f":"+'A-Assignment Worksheet'!J23","v":0},{"$f":"+'A-Assignment Worksheet'!K23","v":0},{"$f":"+'A-Assignment Worksheet'!G23","v":0},{"$f":"+'A-Assignment Worksheet'!H23","v":0},{"$f":"+'A-Assignment Worksheet'!I23","v":0},{"$f":"+'A-Assignment Worksheet'!E23","v":0},{"$f":"+'C-Stream Advance'!H23","v":""},{"$f":"+'C-Stream Advance'!L23","v":""},{"$f":"(IF('A-Assignment Worksheet'!L23>0,(IF('D-Checklist'!G22=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[14,{"$f":"+'A-Assignment Worksheet'!J24","v":0},{"$f":"+'A-Assignment Worksheet'!K24","v":0},{"$f":"+'A-Assignment Worksheet'!G24","v":0},{"$f":"+'A-Assignment Worksheet'!H24","v":0},{"$f":"+'A-Assignment Worksheet'!I24","v":0},{"$f":"+'A-Assignment Worksheet'!E24","v":0},{"$f":"+'C-Stream Advance'!H24","v":""},{"$f":"+'C-Stream Advance'!L24","v":""},{"$f":"(IF('A-Assignment Worksheet'!L24>0,(IF('D-Checklist'!G23=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""},null,null,null,"e"]
[15,{"$f":"+'A-Assignment Worksheet'!J25","v":0},{"$f":"+'A-Assignment Worksheet'!K25","v":0},{"$f":"+'A-Assignment Worksheet'!G25","v":0},{"$f":"+'A-Assignment Worksheet'!H25","v":0},{"$f":"+'A-Assignment Worksheet'!I25","v":0},{"$f":"+'A-Assignment Worksheet'!E25","v":0},{"$f":"+'C-Stream Advance'!H25","v":""},{"$f":"+'C-Stream Advance'!L25","v":""},{"$f":"(IF('A-Assignment Worksheet'!L25>0,(IF('D-Checklist'!G24=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[16,{"$f":"+'A-Assignment Worksheet'!J26","v":0},{"$f":"+'A-Assignment Worksheet'!K26","v":0},{"$f":"+'A-Assignment Worksheet'!G26","v":0},{"$f":"+'A-Assignment Worksheet'!H26","v":0},{"$f":"+'A-Assignment Worksheet'!I26","v":0},{"$f":"+'A-Assignment Worksheet'!E26","v":0},{"$f":"+'C-Stream Advance'!H26","v":""},{"$f":"+'C-Stream Advance'!L26","v":""},{"$f":"(IF('A-Assignment Worksheet'!L26>0,(IF('D-Checklist'!G25=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[17,{"$f":"+'A-Assignment Worksheet'!J27","v":0},{"$f":"+'A-Assignment Worksheet'!K27","v":0},{"$f":"+'A-Assignment Worksheet'!G27","v":0},{"$f":"+'A-Assignment Worksheet'!H27","v":0},{"$f":"+'A-Assignment Worksheet'!I27","v":0},{"$f":"+'A-Assignment Worksheet'!E27","v":0},{"$f":"+'C-Stream Advance'!H27","v":""},{"$f":"+'C-Stream Advance'!L27","v":""},{"$f":"(IF('A-Assignment Worksheet'!L27>0,(IF('D-Checklist'!G26=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[18,{"$f":"+'A-Assignment Worksheet'!J28","v":0},{"$f":"+'A-Assignment Worksheet'!K28","v":0},{"$f":"+'A-Assignment Worksheet'!G28","v":0},{"$f":"+'A-Assignment Worksheet'!H28","v":0},{"$f":"+'A-Assignment Worksheet'!I28","v":0},{"$f":"+'A-Assignment Worksheet'!E28","v":0},{"$f":"+'C-Stream Advance'!H28","v":""},{"$f":"+'C-Stream Advance'!L28","v":""},{"$f":"(IF('A-Assignment Worksheet'!L28>0,(IF('D-Checklist'!G27=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[19,{"$f":"+'A-Assignment Worksheet'!J29","v":0},{"$f":"+'A-Assignment Worksheet'!K29","v":0},{"$f":"+'A-Assignment Worksheet'!G29","v":0},{"$f":"+'A-Assignment Worksheet'!H29","v":0},{"$f":"+'A-Assignment Worksheet'!I29","v":0},{"$f":"+'A-Assignment Worksheet'!E29","v":0},{"$f":"+'C-Stream Advance'!H29","v":""},{"$f":"+'C-Stream Advance'!L29","v":""},{"$f":"(IF('A-Assignment Worksheet'!L29>0,(IF('D-Checklist'!G28=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[20,{"$f":"+'A-Assignment Worksheet'!J30","v":0},{"$f":"+'A-Assignment Worksheet'!K30","v":0},{"$f":"+'A-Assignment Worksheet'!G30","v":0},{"$f":"+'A-Assignment Worksheet'!H30","v":0},{"$f":"+'A-Assignment Worksheet'!I30","v":0},{"$f":"+'A-Assignment Worksheet'!E30","v":0},{"$f":"+'C-Stream Advance'!H30","v":""},{"$f":"+'C-Stream Advance'!L30","v":""},{"$f":"(IF('A-Assignment Worksheet'!L30>0,(IF('D-Checklist'!G29=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[21,{"$f":"+'A-Assignment Worksheet'!J31","v":0},{"$f":"+'A-Assignment Worksheet'!K31","v":0},{"$f":"+'A-Assignment Worksheet'!G31","v":0},{"$f":"+'A-Assignment Worksheet'!H31","v":0},{"$f":"+'A-Assignment Worksheet'!I31","v":0},{"$f":"+'A-Assignment Worksheet'!E31","v":0},{"$f":"+'C-Stream Advance'!H31","v":""},{"$f":"+'C-Stream Advance'!L31","v":""},{"$f":"(IF('A-Assignment Worksheet'!L31>0,(IF('D-Checklist'!G30=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[22,{"$f":"+'A-Assignment Worksheet'!J32","v":0},{"$f":"+'A-Assignment Worksheet'!K32","v":0},{"$f":"+'A-Assignment Worksheet'!G32","v":0},{"$f":"+'A-Assignment Worksheet'!H32","v":0},{"$f":"+'A-Assignment Worksheet'!I32","v":0},{"$f":"+'A-Assignment Worksheet'!E32","v":0},{"$f":"+'C-Stream Advance'!H32","v":""},{"$f":"+'C-Stream Advance'!L32","v":""},{"$f":"(IF('A-Assignment Worksheet'!L32>0,(IF('D-Checklist'!G31=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[23,{"$f":"+'A-Assignment Worksheet'!J33","v":0},{"$f":"+'A-Assignment Worksheet'!K33","v":0},{"$f":"+'A-Assignment Worksheet'!G33","v":0},{"$f":"+'A-Assignment Worksheet'!H33","v":0},{"$f":"+'A-Assignment Worksheet'!I33","v":0},{"$f":"+'A-Assignment Worksheet'!E33","v":0},{"$f":"+'C-Stream Advance'!H33","v":""},{"$f":"+'C-Stream Advance'!L33","v":""},{"$f":"(IF('A-Assignment Worksheet'!L33>0,(IF('D-Checklist'!G32=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[24,{"$f":"+'A-Assignment Worksheet'!J34","v":0},{"$f":"+'A-Assignment Worksheet'!K34","v":0},{"$f":"+'A-Assignment Worksheet'!G34","v":0},{"$f":"+'A-Assignment Worksheet'!H34","v":0},{"$f":"+'A-Assignment Worksheet'!I34","v":0},{"$f":"+'A-Assignment Worksheet'!E34","v":0},{"$f":"+'C-Stream Advance'!H34","v":""},{"$f":"+'C-Stream Advance'!L34","v":""},{"$f":"(IF('A-Assignment Worksheet'!L34>0,(IF('D-Checklist'!G33=1,0,+'I-Inputs'!$B$23)),\"\"))","v":""}]
[25,{"$f":"+'A-Assignment Worksheet'!J35","v":0},{"$f":"+'A-Assignment Worksheet'!K35","v":0},{"$f":"+'A-Assignment Worksheet'!G35","v":0},{"$f":"+'A-Assignment Worksheet'!H35","v":0},{"$f":"+'A-Assignment Worksheet'!I35","v":0},{"$f":"+'A-Assignment Worksheet'!E35","v":0},{"$f":"+'C-Stream Advance'!H35","v":""},{"$f":"+'C-Stream Advance'!L35","v":""},{"$f":"(IF('A-Assignment Worksheet'!L35>0,(IF('D-Checklist'!G34=1,0,200)),\"\"))","v":""}]
[null,null,null,null,null,"Total Purchase Amount:",null,null,{"$f":"SUM(I11:I35)","v":0},{"$f":"SUM(J11:J35)","v":0}]
[]
[null,null,null,null,null,"Less Administrative Cost:",null,null,{"$f":"-'I-Inputs'!B24","v":-10}]
[null,null,null,null,null,"Less Title Escrow:",null,null,{"$f":"-J36","v":0}]
[null,null,null,null,null,"Less Wire Fee:",null,null,{"$f":"-'I-Inputs'!B25","v":-30}]
[null,null,null,null,null,"Total to Be Deducted:",null,null,{"$f":"SUM(I38:I40)","v":-40}]
[]
[null,null,null,null,null,"TOTAL TO BE FUNDED:",null,null,{"$f":"+I36+I41","v":-40}]

{"sheet":"D-Attachment Payments","index":3,"n_rows":141,"n_cols":7,"rows_kept":141,"cut":false,"hidden":true,"merged":[]}
["ATTACHMENT TO ASSIGNMENT DATED:",null,null,{"$f":"+'I-Inputs'!B11","v":"2018-05-21"},null,null,{"$f":"+'C-Stream Advance'!C43+1","v":53}]
["Payment Schedule"]
["Dealer Name:",{"$f":"+'A-Assignment Worksheet'!D3","v":0},null,"Batch #:",{"$f":"+'I-Inputs'!B7","v":1}]
["Address:",{"$f":"+'A-Assignment Worksheet'!D4","v":0}]
["City:",{"$f":"+'A-Assignment Worksheet'!G4","v":0},null,"Phone:",{"$f":"+'A-Assignment Worksheet'!D6","v":0}]
["State:",{"$f":"+'A-Assignment Worksheet'!D5","v":0},null,"Fax:",{"$f":"+'A-Assignment Worksheet'!D7","v":0}]
["Zip:",{"$f":"+'A-Assignment Worksheet'!G5","v":0},null,"Email:",{"$f":"IF('A-Assignment Worksheet'!D3>0,+'A-Assignment Worksheet'!G6,\"\")","v":""}]
[]
[]
["Scheduled Due Dates","Payment Number","Payment Amount","Date Paid","Amount ACH'd"]
[{"$f":"+'I-Inputs'!B30","v":"2018-05-24"},1,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B11<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A11+'I-Inputs'!$B$31","v":"2018-05-31"},2,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B12<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A12+'I-Inputs'!$B$31","v":"2018-06-07"},3,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B13<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A13+'I-Inputs'!$B$31","v":"2018-06-14"},4,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B14<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A14+'I-Inputs'!$B$31","v":"2018-06-21"},5,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B15<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A15+'I-Inputs'!$B$31","v":"2018-06-28"},6,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B16<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A16+'I-Inputs'!$B$31","v":"2018-07-05"},7,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B17<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A17+'I-Inputs'!$B$31","v":"2018-07-12"},8,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B18<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A18+'I-Inputs'!$B$31","v":"2018-07-19"},9,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B19<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A19+'I-Inputs'!$B$31","v":"2018-07-26"},10,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B20<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A20+'I-Inputs'!$B$31","v":"2018-08-02"},11,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B21<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A21+'I-Inputs'!$B$31","v":"2018-08-09"},12,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B22<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A22+'I-Inputs'!$B$31","v":"2018-08-16"},13,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B23<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A23+'I-Inputs'!$B$31","v":"2018-08-23"},14,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B24<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A24+'I-Inputs'!$B$31","v":"2018-08-30"},15,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B25<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A25+'I-Inputs'!$B$31","v":"2018-09-06"},16,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B26<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A26+'I-Inputs'!$B$31","v":"2018-09-13"},17,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B27<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A27+'I-Inputs'!$B$31","v":"2018-09-20"},18,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B28<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A28+'I-Inputs'!$B$31","v":"2018-09-27"},19,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B29<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A29+'I-Inputs'!$B$31","v":"2018-10-04"},20,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B30<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A30+'I-Inputs'!$B$31","v":"2018-10-11"},21,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B31<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A31+'I-Inputs'!$B$31","v":"2018-10-18"},22,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B32<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A32+'I-Inputs'!$B$31","v":"2018-10-25"},23,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B33<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A33+'I-Inputs'!$B$31","v":"2018-11-01"},24,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B34<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A34+'I-Inputs'!$B$31","v":"2018-11-08"},25,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B35<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A35+'I-Inputs'!$B$31","v":"2018-11-15"},26,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B36<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A36+'I-Inputs'!$B$31","v":"2018-11-22"},27,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B37<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A37+'I-Inputs'!$B$31","v":"2018-11-29"},28,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B38<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A38+'I-Inputs'!$B$31","v":"2018-12-06"},29,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B39<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A39+'I-Inputs'!$B$31","v":"2018-12-13"},30,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B40<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A40+'I-Inputs'!$B$31","v":"2018-12-20"},31,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B41<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A41+'I-Inputs'!$B$31","v":"2018-12-27"},32,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B42<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A42+'I-Inputs'!$B$31","v":"2019-01-03"},33,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B43<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A43+'I-Inputs'!$B$31","v":"2019-01-10"},34,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B44<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A44+'I-Inputs'!$B$31","v":"2019-01-17"},35,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B45<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A45+'I-Inputs'!$B$31","v":"2019-01-24"},36,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B46<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A46+'I-Inputs'!$B$31","v":"2019-01-31"},37,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B47<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A47+'I-Inputs'!$B$31","v":"2019-02-07"},38,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B48<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A48+'I-Inputs'!$B$31","v":"2019-02-14"},39,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B49<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A49+'I-Inputs'!$B$31","v":"2019-02-21"},40,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B50<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A50+'I-Inputs'!$B$31","v":"2019-02-28"},41,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B51<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A51+'I-Inputs'!$B$31","v":"2019-03-07"},42,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B52<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A52+'I-Inputs'!$B$31","v":"2019-03-14"},43,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B53<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A53+'I-Inputs'!$B$31","v":"2019-03-21"},44,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B54<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A54+'I-Inputs'!$B$31","v":"2019-03-28"},45,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B55<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A55+'I-Inputs'!$B$31","v":"2019-04-04"},46,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B56<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A56+'I-Inputs'!$B$31","v":"2019-04-11"},47,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B57<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A57+'I-Inputs'!$B$31","v":"2019-04-18"},48,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B58<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A58+'I-Inputs'!$B$31","v":"2019-04-25"},49,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B59<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A59+'I-Inputs'!$B$31","v":"2019-05-02"},50,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B60<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A60+'I-Inputs'!$B$31","v":"2019-05-09"},51,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B61<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A61+'I-Inputs'!$B$31","v":"2019-05-16"},52,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B62<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A62+'I-Inputs'!$B$31","v":"2019-05-23"},53,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B63<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A63+'I-Inputs'!$B$31","v":"2019-05-30"},54,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B64<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A64+'I-Inputs'!$B$31","v":"2019-06-06"},55,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B65<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A65+'I-Inputs'!$B$31","v":"2019-06-13"},56,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B66<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A66+'I-Inputs'!$B$31","v":"2019-06-20"},57,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B67<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A67+'I-Inputs'!$B$31","v":"2019-06-27"},58,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B68<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A68+'I-Inputs'!$B$31","v":"2019-07-04"},59,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B69<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A69+'I-Inputs'!$B$31","v":"2019-07-11"},60,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B70<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A70+'I-Inputs'!$B$31","v":"2019-07-18"},61,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B71<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A71+'I-Inputs'!$B$31","v":"2019-07-25"},62,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B72<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A72+'I-Inputs'!$B$31","v":"2019-08-01"},63,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B73<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A73+'I-Inputs'!$B$31","v":"2019-08-08"},64,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B74<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A74+'I-Inputs'!$B$31","v":"2019-08-15"},65,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B75<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A75+'I-Inputs'!$B$31","v":"2019-08-22"},66,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B76<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A76+'I-Inputs'!$B$31","v":"2019-08-29"},67,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B77<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A77+'I-Inputs'!$B$31","v":"2019-09-05"},68,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B78<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A78+'I-Inputs'!$B$31","v":"2019-09-12"},69,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B79<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A79+'I-Inputs'!$B$31","v":"2019-09-19"},70,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B80<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A80+'I-Inputs'!$B$31","v":"2019-09-26"},71,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B81<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A81+'I-Inputs'!$B$31","v":"2019-10-03"},72,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B82<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A82+'I-Inputs'!$B$31","v":"2019-10-10"},73,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B83<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A83+'I-Inputs'!$B$31","v":"2019-10-17"},74,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B84<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A84+'I-Inputs'!$B$31","v":"2019-10-24"},75,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B85<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A85+'I-Inputs'!$B$31","v":"2019-10-31"},76,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B86<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A86+'I-Inputs'!$B$31","v":"2019-11-07"},77,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B87<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A87+'I-Inputs'!$B$31","v":"2019-11-14"},78,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B88<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A88+'I-Inputs'!$B$31","v":"2019-11-21"},79,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B89<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A89+'I-Inputs'!$B$31","v":"2019-11-28"},80,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B90<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A90+'I-Inputs'!$B$31","v":"2019-12-05"},81,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B91<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A91+'I-Inputs'!$B$31","v":"2019-12-12"},82,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B92<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A92+'I-Inputs'!$B$31","v":"2019-12-19"},83,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B93<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A93+'I-Inputs'!$B$31","v":"2019-12-26"},84,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B94<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A94+'I-Inputs'!$B$31","v":"2020-01-02"},85,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B95<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A95+'I-Inputs'!$B$31","v":"2020-01-09"},86,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B96<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A96+'I-Inputs'!$B$31","v":"2020-01-16"},87,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B97<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A97+'I-Inputs'!$B$31","v":"2020-01-23"},88,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B98<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A98+'I-Inputs'!$B$31","v":"2020-01-30"},89,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B99<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A99+'I-Inputs'!$B$31","v":"2020-02-06"},90,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B100<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A100+'I-Inputs'!$B$31","v":"2020-02-13"},91,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B101<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A101+'I-Inputs'!$B$31","v":"2020-02-20"},92,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B102<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A102+'I-Inputs'!$B$31","v":"2020-02-27"},93,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B103<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A103+'I-Inputs'!$B$31","v":"2020-03-05"},94,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B104<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A104+'I-Inputs'!$B$31","v":"2020-03-12"},95,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B105<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A105+'I-Inputs'!$B$31","v":"2020-03-19"},96,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B106<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A106+'I-Inputs'!$B$31","v":"2020-03-26"},97,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B107<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A107+'I-Inputs'!$B$31","v":"2020-04-02"},98,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B108<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A108+'I-Inputs'!$B$31","v":"2020-04-09"},99,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B109<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A109+'I-Inputs'!$B$31","v":"2020-04-16"},100,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B110<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A110+'I-Inputs'!$B$31","v":"2020-04-23"},101,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B111<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A111+'I-Inputs'!$B$31","v":"2020-04-30"},102,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B112<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A112+'I-Inputs'!$B$31","v":"2020-05-07"},103,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B113<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A113+'I-Inputs'!$B$31","v":"2020-05-14"},104,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B114<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A114+'I-Inputs'!$B$31","v":"2020-05-21"},105,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B115<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A115+'I-Inputs'!$B$31","v":"2020-05-28"},106,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B116<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A116+'I-Inputs'!$B$31","v":"2020-06-04"},107,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B117<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A117+'I-Inputs'!$B$31","v":"2020-06-11"},108,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B118<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A118+'I-Inputs'!$B$31","v":"2020-06-18"},109,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B119<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A119+'I-Inputs'!$B$31","v":"2020-06-25"},110,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B120<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A120+'I-Inputs'!$B$31","v":"2020-07-02"},111,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B121<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A121+'I-Inputs'!$B$31","v":"2020-07-09"},112,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B122<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A122+'I-Inputs'!$B$31","v":"2020-07-16"},113,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B123<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A123+'I-Inputs'!$B$31","v":"2020-07-23"},114,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B124<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A124+'I-Inputs'!$B$31","v":"2020-07-30"},115,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B125<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A125+'I-Inputs'!$B$31","v":"2020-08-06"},116,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B126<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A126+'I-Inputs'!$B$31","v":"2020-08-13"},117,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B127<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A127+'I-Inputs'!$B$31","v":"2020-08-20"},118,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B128<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A128+'I-Inputs'!$B$31","v":"2020-08-27"},119,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B129<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A129+'I-Inputs'!$B$31","v":"2020-09-03"},120,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B130<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A130+'I-Inputs'!$B$31","v":"2020-09-10"},121,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B131<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A131+'I-Inputs'!$B$31","v":"2020-09-17"},122,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B132<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A132+'I-Inputs'!$B$31","v":"2020-09-24"},123,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B133<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A133+'I-Inputs'!$B$31","v":"2020-10-01"},124,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B134<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A134+'I-Inputs'!$B$31","v":"2020-10-08"},125,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B135<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A135+'I-Inputs'!$B$31","v":"2020-10-15"},126,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B136<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A136+'I-Inputs'!$B$31","v":"2020-10-22"},127,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B137<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A137+'I-Inputs'!$B$31","v":"2020-10-29"},128,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B138<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A138+'I-Inputs'!$B$31","v":"2020-11-05"},129,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B139<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[{"$f":"+A139+'I-Inputs'!$B$31","v":"2020-11-12"},130,{"$f":"IF('A-Assignment Worksheet'!$D$3>0,(IF('D-Attachment Payments'!B140<$G$1,+'C-Stream Advance'!$C$44,\"\")),\"\")","v":""}]
[null,"Total Payments:",{"$f":"SUM(C11:C140)","v":0}]

{"sheet":"B-Block Ticket","index":4,"n_rows":45,"n_cols":24,"rows_kept":45,"cut":false,"hidden":true,"merged":[[38,10,38,11],[39,10,39,11],[40,10,40,11],[41,10,41,11],[42,10,42,11],[6,2,6,3],[6,10,6,11],[7,2,7,3],[7,5,7,6],[7,9,7,11],[7,13,7,16],[7,21,7,22],[8,7,8,9],[8,10,9,10],[8,14,8,22],[4,2,4,3],[4,5,4,6],[4,13,4,16],[5,2,5,3],[5,5,5,6],[5,9,5,11],[5,13,5,16],[2,2,2,3],[2,5,2,6],[2,13,2,16],[2,17,2,18],[3,2,3,3],[3,5,3,6],[3,13,3,16]]}
["SDA BLOCK TICKET   (INTERNAL USE ONLY)",null,null,null,null,null,null,null,null,null,null,null,null,"SDA Payments in Stream Analysis"]
[]
[null,"Dealer Name:",{"$f":"+'A-Assignment Worksheet'!D3","v":0},null,"Batch #:",{"$f":"+'I-Inputs'!B7","v":1},null,null,null,null,null,null,null,"Dealership Name:",null,null,null,{"$f":"+'A-Assignment Worksheet'!D3","v":0},null,"Payment Type Multiplier"]
[null,"Address:",{"$f":"+'A-Assignment Worksheet'!D4","v":0},null,"City:",{"$f":"+'A-Assignment Worksheet'!G4","v":0},null,null,null,null,null,null,null,"Days in Stream;",null,null,null,{"$f":"+'I-Inputs'!B21","v":365},null,"W",4.3330000000000002,7]
[null,"State:",{"$f":"+'A-Assignment Worksheet'!D5","v":0},null,"ZIP:",{"$f":"+'A-Assignment Worksheet'!G5","v":0},null,null,null,null,null,null,null,"Months in Stream;",null,null,null,{"$f":"+'I-Inputs'!B16","v":12},null,"B",2.1659999999999999,14]
[null,"Phone:",{"$f":"+'A-Assignment Worksheet'!D6","v":0},null,"Email:",{"$f":"+'A-Assignment Worksheet'!G6","v":0},null,null,null,null,null,null,null,"Batch Payment Frequency:",null,null,null,"W",null,"M",4.3330000000000002,30]
[null,"Fax:",{"$f":"+'A-Assignment Worksheet'!D7","v":0},null,"Batch ID:",{"$f":"+'I-Inputs'!B8","v":"18F2"},null,null,null,"Date:",{"$f":"+'I-Inputs'!B11","v":"2018-05-21"},null,null,null,null,null,"Payments in Stream:",{"$f":"+$R$5*(VLOOKUP($R$6,T4:V7,2,FALSE))","v":51.996000000000002},null,"S",2,15]
[]
[null,null,null,null,null,null,null,"Payments in Stream",null,null,"Stream Advance Amount",null,null,null,"PAYMENTS IN STREAM ANALYSIS"]
["#","Last Name","First Name","Year","Make","Principal Balance","Payment","No.","Amount","Last Payment",null,"Capital Ratio",null,null,"Next Payment Date","Payment Type","Multiplier","Payments in Year","Max Days in Stream","Days Account is in Stream","Days Between Payments","Payments in Stream","Weekly Payments"]
[1,{"$f":"+'A-Assignment Worksheet'!J11","v":0},{"$f":"+'A-Assignment Worksheet'!K11","v":0},{"$f":"+'A-Assignment Worksheet'!G11","v":0},{"$f":"+'A-Assignment Worksheet'!H11","v":0},{"$f":"+'A-Assignment Worksheet'!L11","v":0},{"$f":"+'A-Assignment Worksheet'!E11","v":0},{"$f":"IF(F11>0,+V11,\"\")","v":""},{"$f":"IF(F11>0,(+H11*G11),\"\")","v":""},{"$f":"IF(F11>0,(+'A-Assignment Worksheet'!F11+'B-Block Ticket'!T11),\"\")","v":""},{"$f":"IF(F11>0,(+I11*'I-Inputs'!$B$17),\"\")","v":""},{"$f":"IF(F11>0,(+F11/K11),\"\")","v":""},null,1,{"$f":"IF(F11>0,+'A-Assignment Worksheet'!F11,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B11","v":0},{"$f":"IF(F11>0,(VLOOKUP($P11,$T$4:$U$7,2,TRUE)),\"\")","v":""},{"$f":"IF(F11>0,(ROUND(+$R$5*Q11,0)),\"\")","v":""},{"$f":"IF(F11>0,+$R$4,\"\")","v":""},{"$f":"IF(F11>0,(MIN(S11,(DATEDIF('A-Assignment Worksheet'!F11,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},{"$f":"IF(F11>0,(VLOOKUP(P11,$T$4:$V$7,3,TRUE)),\"\")","v":""},{"$f":"IF(F11>0,(+ROUND(+T11/U11,0)),\"\")","v":""},{"$f":"IF(F11>0,(+T11/7),\"\")","v":""}]
[2,{"$f":"+'A-Assignment Worksheet'!J12","v":0},{"$f":"+'A-Assignment Worksheet'!K12","v":0},{"$f":"+'A-Assignment Worksheet'!G12","v":0},{"$f":"+'A-Assignment Worksheet'!H12","v":0},{"$f":"+'A-Assignment Worksheet'!L12","v":0},{"$f":"+'A-Assignment Worksheet'!E12","v":0},"","",{"$f":"IF(F12>0,(+'A-Assignment Worksheet'!F12+'B-Block Ticket'!T12),\"\")","v":""},{"$f":"IF(F12>0,(+I12*'I-Inputs'!$B$17),\"\")","v":""},"",null,2,{"$f":"IF(F12>0,+'A-Assignment Worksheet'!F12,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B12","v":0},"","","",{"$f":"IF(F12>0,(MIN(S12,(DATEDIF('A-Assignment Worksheet'!F12,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[3,{"$f":"+'A-Assignment Worksheet'!J13","v":0},{"$f":"+'A-Assignment Worksheet'!K13","v":0},{"$f":"+'A-Assignment Worksheet'!G13","v":0},{"$f":"+'A-Assignment Worksheet'!H13","v":0},{"$f":"+'A-Assignment Worksheet'!L13","v":0},{"$f":"+'A-Assignment Worksheet'!E13","v":0},"","",{"$f":"IF(F13>0,(+'A-Assignment Worksheet'!F13+'B-Block Ticket'!T13),\"\")","v":""},{"$f":"IF(F13>0,(+I13*'I-Inputs'!$B$17),\"\")","v":""},"",null,3,{"$f":"IF(F13>0,+'A-Assignment Worksheet'!F13,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B13","v":0},"","","",{"$f":"IF(F13>0,(MIN(S13,(DATEDIF('A-Assignment Worksheet'!F13,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[4,{"$f":"+'A-Assignment Worksheet'!J14","v":0},{"$f":"+'A-Assignment Worksheet'!K14","v":0},{"$f":"+'A-Assignment Worksheet'!G14","v":0},{"$f":"+'A-Assignment Worksheet'!H14","v":0},{"$f":"+'A-Assignment Worksheet'!L14","v":0},{"$f":"+'A-Assignment Worksheet'!E14","v":0},"","",{"$f":"IF(F14>0,(+'A-Assignment Worksheet'!F14+'B-Block Ticket'!T14),\"\")","v":""},{"$f":"IF(F14>0,(+I14*'I-Inputs'!$B$17),\"\")","v":""},"",null,4,{"$f":"IF(F14>0,+'A-Assignment Worksheet'!F14,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B14","v":0},"","","",{"$f":"IF(F14>0,(MIN(S14,(DATEDIF('A-Assignment Worksheet'!F14,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[5,{"$f":"+'A-Assignment Worksheet'!J15","v":0},{"$f":"+'A-Assignment Worksheet'!K15","v":0},{"$f":"+'A-Assignment Worksheet'!G15","v":0},{"$f":"+'A-Assignment Worksheet'!H15","v":0},{"$f":"+'A-Assignment Worksheet'!L15","v":0},{"$f":"+'A-Assignment Worksheet'!E15","v":0},"","",{"$f":"IF(F15>0,(+'A-Assignment Worksheet'!F15+'B-Block Ticket'!T15),\"\")","v":""},{"$f":"IF(F15>0,(+I15*'I-Inputs'!$B$17),\"\")","v":""},"",null,5,{"$f":"IF(F15>0,+'A-Assignment Worksheet'!F15,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B15","v":0},"","","",{"$f":"IF(F15>0,(MIN(S15,(DATEDIF('A-Assignment Worksheet'!F15,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[6,{"$f":"+'A-Assignment Worksheet'!J16","v":0},{"$f":"+'A-Assignment Worksheet'!K16","v":0},{"$f":"+'A-Assignment Worksheet'!G16","v":0},{"$f":"+'A-Assignment Worksheet'!H16","v":0},{"$f":"+'A-Assignment Worksheet'!L16","v":0},{"$f":"+'A-Assignment Worksheet'!E16","v":0},"","",{"$f":"IF(F16>0,(+'A-Assignment Worksheet'!F16+'B-Block Ticket'!T16),\"\")","v":""},{"$f":"IF(F16>0,(+I16*'I-Inputs'!$B$17),\"\")","v":""},"",null,6,{"$f":"IF(F16>0,+'A-Assignment Worksheet'!F16,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B16","v":0},"","","",{"$f":"IF(F16>0,(MIN(S16,(DATEDIF('A-Assignment Worksheet'!F16,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[7,{"$f":"+'A-Assignment Worksheet'!J17","v":0},{"$f":"+'A-Assignment Worksheet'!K17","v":0},{"$f":"+'A-Assignment Worksheet'!G17","v":0},{"$f":"+'A-Assignment Worksheet'!H17","v":0},{"$f":"+'A-Assignment Worksheet'!L17","v":0},{"$f":"+'A-Assignment Worksheet'!E17","v":0},"","",{"$f":"IF(F17>0,(+'A-Assignment Worksheet'!F17+'B-Block Ticket'!T17),\"\")","v":""},{"$f":"IF(F17>0,(+I17*'I-Inputs'!$B$17),\"\")","v":""},"",null,7,{"$f":"IF(F17>0,+'A-Assignment Worksheet'!F17,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B17","v":0},"","","",{"$f":"IF(F17>0,(MIN(S17,(DATEDIF('A-Assignment Worksheet'!F17,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",4]
[8,{"$f":"+'A-Assignment Worksheet'!J18","v":0},{"$f":"+'A-Assignment Worksheet'!K18","v":0},{"$f":"+'A-Assignment Worksheet'!G18","v":0},{"$f":"+'A-Assignment Worksheet'!H18","v":0},{"$f":"+'A-Assignment Worksheet'!L18","v":0},{"$f":"+'A-Assignment Worksheet'!E18","v":0},"","",{"$f":"IF(F18>0,(+'A-Assignment Worksheet'!F18+'B-Block Ticket'!T18),\"\")","v":""},{"$f":"IF(F18>0,(+I18*'I-Inputs'!$B$17),\"\")","v":""},"",null,8,{"$f":"IF(F18>0,+'A-Assignment Worksheet'!F18,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B18","v":0},"","","",{"$f":"IF(F18>0,(MIN(S18,(DATEDIF('A-Assignment Worksheet'!F18,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[9,{"$f":"+'A-Assignment Worksheet'!J19","v":0},{"$f":"+'A-Assignment Worksheet'!K19","v":0},{"$f":"+'A-Assignment Worksheet'!G19","v":0},{"$f":"+'A-Assignment Worksheet'!H19","v":0},{"$f":"+'A-Assignment Worksheet'!L19","v":0},{"$f":"+'A-Assignment Worksheet'!E19","v":0},"","",{"$f":"IF(F19>0,(+'A-Assignment Worksheet'!F19+'B-Block Ticket'!T19),\"\")","v":""},{"$f":"IF(F19>0,(+I19*'I-Inputs'!$B$17),\"\")","v":""},"",null,9,{"$f":"IF(F19>0,+'A-Assignment Worksheet'!F19,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B19","v":0},"","","",{"$f":"IF(F19>0,(MIN(S19,(DATEDIF('A-Assignment Worksheet'!F19,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[10,{"$f":"+'A-Assignment Worksheet'!J20","v":0},{"$f":"+'A-Assignment Worksheet'!K20","v":0},{"$f":"+'A-Assignment Worksheet'!G20","v":0},{"$f":"+'A-Assignment Worksheet'!H20","v":0},{"$f":"+'A-Assignment Worksheet'!L20","v":0},{"$f":"+'A-Assignment Worksheet'!E20","v":0},"","",{"$f":"IF(F20>0,(+'A-Assignment Worksheet'!F20+'B-Block Ticket'!T20),\"\")","v":""},{"$f":"IF(F20>0,(+I20*'I-Inputs'!$B$17),\"\")","v":""},"",null,10,{"$f":"IF(F20>0,+'A-Assignment Worksheet'!F20,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B20","v":0},"","","",{"$f":"IF(F20>0,(MIN(S20,(DATEDIF('A-Assignment Worksheet'!F20,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[11,{"$f":"+'A-Assignment Worksheet'!J21","v":0},{"$f":"+'A-Assignment Worksheet'!K21","v":0},{"$f":"+'A-Assignment Worksheet'!G21","v":0},{"$f":"+'A-Assignment Worksheet'!H21","v":0},{"$f":"+'A-Assignment Worksheet'!L21","v":0},{"$f":"+'A-Assignment Worksheet'!E21","v":0},"","",{"$f":"IF(F21>0,(+'A-Assignment Worksheet'!F21+'B-Block Ticket'!T21),\"\")","v":""},{"$f":"IF(F21>0,(+I21*'I-Inputs'!$B$17),\"\")","v":""},"",null,11,{"$f":"IF(F21>0,+'A-Assignment Worksheet'!F21,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B21","v":0},"","","",{"$f":"IF(F21>0,(MIN(S21,(DATEDIF('A-Assignment Worksheet'!F21,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[12,{"$f":"+'A-Assignment Worksheet'!J22","v":0},{"$f":"+'A-Assignment Worksheet'!K22","v":0},{"$f":"+'A-Assignment Worksheet'!G22","v":0},{"$f":"+'A-Assignment Worksheet'!H22","v":0},{"$f":"+'A-Assignment Worksheet'!L22","v":0},{"$f":"+'A-Assignment Worksheet'!E22","v":0},"","",{"$f":"IF(F22>0,(+'A-Assignment Worksheet'!F22+'B-Block Ticket'!T22),\"\")","v":""},{"$f":"IF(F22>0,(+I22*'I-Inputs'!$B$17),\"\")","v":""},"",null,12,{"$f":"IF(F22>0,+'A-Assignment Worksheet'!F22,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B22","v":0},"","","",{"$f":"IF(F22>0,(MIN(S22,(DATEDIF('A-Assignment Worksheet'!F22,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[13,{"$f":"+'A-Assignment Worksheet'!J23","v":0},{"$f":"+'A-Assignment Worksheet'!K23","v":0},{"$f":"+'A-Assignment Worksheet'!G23","v":0},{"$f":"+'A-Assignment Worksheet'!H23","v":0},{"$f":"+'A-Assignment Worksheet'!L23","v":0},{"$f":"+'A-Assignment Worksheet'!E23","v":0},"","",{"$f":"IF(F23>0,(+'A-Assignment Worksheet'!F23+'B-Block Ticket'!T23),\"\")","v":""},{"$f":"IF(F23>0,(+I23*'I-Inputs'!$B$17),\"\")","v":""},"",null,13,{"$f":"IF(F23>0,+'A-Assignment Worksheet'!F23,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B23","v":0},"","","",{"$f":"IF(F23>0,(MIN(S23,(DATEDIF('A-Assignment Worksheet'!F23,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[14,{"$f":"+'A-Assignment Worksheet'!J24","v":0},{"$f":"+'A-Assignment Worksheet'!K24","v":0},{"$f":"+'A-Assignment Worksheet'!G24","v":0},{"$f":"+'A-Assignment Worksheet'!H24","v":0},{"$f":"+'A-Assignment Worksheet'!L24","v":0},{"$f":"+'A-Assignment Worksheet'!E24","v":0},"","",{"$f":"IF(F24>0,(+'A-Assignment Worksheet'!F24+'B-Block Ticket'!T24),\"\")","v":""},{"$f":"IF(F24>0,(+I24*'I-Inputs'!$B$17),\"\")","v":""},"",null,14,{"$f":"IF(F24>0,+'A-Assignment Worksheet'!F24,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B24","v":0},"","","",{"$f":"IF(F24>0,(MIN(S24,(DATEDIF('A-Assignment Worksheet'!F24,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[15,{"$f":"+'A-Assignment Worksheet'!J25","v":0},{"$f":"+'A-Assignment Worksheet'!K25","v":0},{"$f":"+'A-Assignment Worksheet'!G25","v":0},{"$f":"+'A-Assignment Worksheet'!H25","v":0},{"$f":"+'A-Assignment Worksheet'!L25","v":0},{"$f":"+'A-Assignment Worksheet'!E25","v":0},"","",{"$f":"IF(F25>0,(+'A-Assignment Worksheet'!F25+'B-Block Ticket'!T25),\"\")","v":""},{"$f":"IF(F25>0,(+I25*'I-Inputs'!$B$17),\"\")","v":""},"",null,15,{"$f":"IF(F25>0,+'A-Assignment Worksheet'!F25,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B25","v":0},"","","",{"$f":"IF(F25>0,(MIN(S25,(DATEDIF('A-Assignment Worksheet'!F25,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[16,{"$f":"+'A-Assignment Worksheet'!J26","v":0},{"$f":"+'A-Assignment Worksheet'!K26","v":0},{"$f":"+'A-Assignment Worksheet'!G26","v":0},{"$f":"+'A-Assignment Worksheet'!H26","v":0},{"$f":"+'A-Assignment Worksheet'!L26","v":0},{"$f":"+'A-Assignment Worksheet'!E26","v":0},"","",{"$f":"IF(F26>0,(+'A-Assignment Worksheet'!F26+'B-Block Ticket'!T26),\"\")","v":""},{"$f":"IF(F26>0,(+I26*'I-Inputs'!$B$17),\"\")","v":""},"",null,16,{"$f":"IF(F26>0,+'A-Assignment Worksheet'!F26,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B26","v":0},"","","",{"$f":"IF(F26>0,(MIN(S26,(DATEDIF('A-Assignment Worksheet'!F26,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[17,{"$f":"+'A-Assignment Worksheet'!J27","v":0},{"$f":"+'A-Assignment Worksheet'!K27","v":0},{"$f":"+'A-Assignment Worksheet'!G27","v":0},{"$f":"+'A-Assignment Worksheet'!H27","v":0},{"$f":"+'A-Assignment Worksheet'!L27","v":0},{"$f":"+'A-Assignment Worksheet'!E27","v":0},"","",{"$f":"IF(F27>0,(+'A-Assignment Worksheet'!F27+'B-Block Ticket'!T27),\"\")","v":""},{"$f":"IF(F27>0,(+I27*'I-Inputs'!$B$17),\"\")","v":""},"",null,17,{"$f":"IF(F27>0,+'A-Assignment Worksheet'!F27,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B27","v":0},"","","",{"$f":"IF(F27>0,(MIN(S27,(DATEDIF('A-Assignment Worksheet'!F27,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[18,{"$f":"+'A-Assignment Worksheet'!J28","v":0},{"$f":"+'A-Assignment Worksheet'!K28","v":0},{"$f":"+'A-Assignment Worksheet'!G28","v":0},{"$f":"+'A-Assignment Worksheet'!H28","v":0},{"$f":"+'A-Assignment Worksheet'!L28","v":0},{"$f":"+'A-Assignment Worksheet'!E28","v":0},"","",{"$f":"IF(F28>0,(+'A-Assignment Worksheet'!F28+'B-Block Ticket'!T28),\"\")","v":""},{"$f":"IF(F28>0,(+I28*'I-Inputs'!$B$17),\"\")","v":""},"",null,18,{"$f":"IF(F28>0,+'A-Assignment Worksheet'!F28,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B28","v":0},"","","",{"$f":"IF(F28>0,(MIN(S28,(DATEDIF('A-Assignment Worksheet'!F28,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[19,{"$f":"+'A-Assignment Worksheet'!J29","v":0},{"$f":"+'A-Assignment Worksheet'!K29","v":0},{"$f":"+'A-Assignment Worksheet'!G29","v":0},{"$f":"+'A-Assignment Worksheet'!H29","v":0},{"$f":"+'A-Assignment Worksheet'!L29","v":0},{"$f":"+'A-Assignment Worksheet'!E29","v":0},"","",{"$f":"IF(F29>0,(+'A-Assignment Worksheet'!F29+'B-Block Ticket'!T29),\"\")","v":""},{"$f":"IF(F29>0,(+I29*'I-Inputs'!$B$17),\"\")","v":""},"",null,19,{"$f":"IF(F29>0,+'A-Assignment Worksheet'!F29,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B29","v":0},"","","",{"$f":"IF(F29>0,(MIN(S29,(DATEDIF('A-Assignment Worksheet'!F29,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[20,{"$f":"+'A-Assignment Worksheet'!J30","v":0},{"$f":"+'A-Assignment Worksheet'!K30","v":0},{"$f":"+'A-Assignment Worksheet'!G30","v":0},{"$f":"+'A-Assignment Worksheet'!H30","v":0},{"$f":"+'A-Assignment Worksheet'!L30","v":0},{"$f":"+'A-Assignment Worksheet'!E30","v":0},"","",{"$f":"IF(F30>0,(+'A-Assignment Worksheet'!F30+'B-Block Ticket'!T30),\"\")","v":""},{"$f":"IF(F30>0,(+I30*'I-Inputs'!$B$17),\"\")","v":""},"",null,20,{"$f":"IF(F30>0,+'A-Assignment Worksheet'!F30,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B30","v":0},"","","",{"$f":"IF(F30>0,(MIN(S30,(DATEDIF('A-Assignment Worksheet'!F30,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[21,{"$f":"+'A-Assignment Worksheet'!J31","v":0},{"$f":"+'A-Assignment Worksheet'!K31","v":0},{"$f":"+'A-Assignment Worksheet'!G31","v":0},{"$f":"+'A-Assignment Worksheet'!H31","v":0},{"$f":"+'A-Assignment Worksheet'!L31","v":0},{"$f":"+'A-Assignment Worksheet'!E31","v":0},"","",{"$f":"IF(F31>0,(+'A-Assignment Worksheet'!F31+'B-Block Ticket'!T31),\"\")","v":""},{"$f":"IF(F31>0,(+I31*'I-Inputs'!$B$17),\"\")","v":""},"",null,21,{"$f":"IF(F31>0,+'A-Assignment Worksheet'!F31,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B31","v":0},"","","",{"$f":"IF(F31>0,(MIN(S31,(DATEDIF('A-Assignment Worksheet'!F31,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[22,{"$f":"+'A-Assignment Worksheet'!J32","v":0},{"$f":"+'A-Assignment Worksheet'!K32","v":0},{"$f":"+'A-Assignment Worksheet'!G32","v":0},{"$f":"+'A-Assignment Worksheet'!H32","v":0},{"$f":"+'A-Assignment Worksheet'!L32","v":0},{"$f":"+'A-Assignment Worksheet'!E32","v":0},"","",{"$f":"IF(F32>0,(+'A-Assignment Worksheet'!F32+'B-Block Ticket'!T32),\"\")","v":""},{"$f":"IF(F32>0,(+I32*'I-Inputs'!$B$17),\"\")","v":""},"",null,22,{"$f":"IF(F32>0,+'A-Assignment Worksheet'!F32,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B32","v":0},"","","",{"$f":"IF(F32>0,(MIN(S32,(DATEDIF('A-Assignment Worksheet'!F32,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[23,{"$f":"+'A-Assignment Worksheet'!J33","v":0},{"$f":"+'A-Assignment Worksheet'!K33","v":0},{"$f":"+'A-Assignment Worksheet'!G33","v":0},{"$f":"+'A-Assignment Worksheet'!H33","v":0},{"$f":"+'A-Assignment Worksheet'!L33","v":0},{"$f":"+'A-Assignment Worksheet'!E33","v":0},"","",{"$f":"IF(F33>0,(+'A-Assignment Worksheet'!F33+'B-Block Ticket'!T33),\"\")","v":""},{"$f":"IF(F33>0,(+I33*'I-Inputs'!$B$17),\"\")","v":""},"",null,23,{"$f":"IF(F33>0,+'A-Assignment Worksheet'!F33,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B33","v":0},"","","",{"$f":"IF(F33>0,(MIN(S33,(DATEDIF('A-Assignment Worksheet'!F33,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[24,{"$f":"+'A-Assignment Worksheet'!J34","v":0},{"$f":"+'A-Assignment Worksheet'!K34","v":0},{"$f":"+'A-Assignment Worksheet'!G34","v":0},{"$f":"+'A-Assignment Worksheet'!H34","v":0},{"$f":"+'A-Assignment Worksheet'!L34","v":0},{"$f":"+'A-Assignment Worksheet'!E34","v":0},"","",{"$f":"IF(F34>0,(+'A-Assignment Worksheet'!F34+'B-Block Ticket'!T34),\"\")","v":""},{"$f":"IF(F34>0,(+I34*'I-Inputs'!$B$17),\"\")","v":""},"",null,24,{"$f":"IF(F34>0,+'A-Assignment Worksheet'!F34,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B34","v":0},"","","",{"$f":"IF(F34>0,(MIN(S34,(DATEDIF('A-Assignment Worksheet'!F34,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[25,{"$f":"+'A-Assignment Worksheet'!J35","v":0},{"$f":"+'A-Assignment Worksheet'!K35","v":0},{"$f":"+'A-Assignment Worksheet'!G35","v":0},{"$f":"+'A-Assignment Worksheet'!H35","v":0},{"$f":"+'A-Assignment Worksheet'!L35","v":0},{"$f":"+'A-Assignment Worksheet'!E35","v":0},"","",{"$f":"IF(F35>0,(+'A-Assignment Worksheet'!F35+'B-Block Ticket'!T35),\"\")","v":""},{"$f":"IF(F35>0,(+I35*'I-Inputs'!$B$17),\"\")","v":""},"",null,25,{"$f":"IF(F35>0,+'A-Assignment Worksheet'!F35,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B35","v":0},"","","",{"$f":"IF(F35>0,(MIN(S35,(DATEDIF('A-Assignment Worksheet'!F35,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","",""]
[null,"Totals",null,null,null,{"$f":"SUM(F11:F35)","v":0},null,null,{"$f":"SUM(I11:I35)","v":0},null,{"$f":"SUM(K11:K35)","v":0},{"$f":"AVERAGE(L11:L35)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,"Office Use Only:"]
[null,"Stream Months:",{"$f":"+'I-Inputs'!B16","v":12},null,null,"Stream Advancement Amount:",{"$f":"+K36","v":0},null,null,"Date Funded:"]
[null,"Stream Percentage:",{"$f":"+'I-Inputs'!B17","v":0.8},null,null,"Less Administrative Cost:",{"$f":"-'I-Inputs'!B24","v":-10},null,null,"QuickBooks:"]
[null,"Payment Type:",{"$f":"+'I-Inputs'!B18","v":"W"},null,null,"Less Payoff:",{"$f":"-'I-Inputs'!B22","v":-100},null,null,"ICN #:"]
[null,"First Payment Date:",{"$f":"+'I-Inputs'!B19","v":"2018-05-24"},null,null,"Less Title Escrow:",{"$f":"-'C-Attachment To Assignment'!J36","v":0},null,null,"Sales Comm. Updated:"]
[null,"Payments in Stream:",{"$f":"ROUND(+R7,0)","v":52},null,null,"Less Wire Fee:",{"$f":"-'I-Inputs'!B25","v":-30},null,null,"Act Updated:"]
[null,"Payment Amount:",{"$f":"+I36/C43","v":0},null,null,"Total to Be Deducted:",{"$f":"SUM(G40:G43)","v":-140}]
[null,"Collateral:",{"$f":"+'A-Assignment Worksheet'!L36","v":0},null,null,"TOTAL TO BE FUNDED:",{"$f":"+G39+G44","v":-140}]

{"sheet":" E- Internal Payments","index":5,"n_rows":144,"n_cols":5,"rows_kept":144,"cut":false,"hidden":true,"merged":[[9,2,9,3],[10,2,10,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3]]}
["PAYMENT/ACH SCHEDULE"]
["Internal use Only"]
["Stream Payment Terms:"]
["Dealer Name:",{"$f":"+'A-Assignment Worksheet'!D3","v":0},"Batch #:",null,{"$f":"+'I-Inputs'!B7","v":1}]
["Stream Months:",{"$f":"+'I-Inputs'!B16","v":12},"Stream Advancement Amount:",null,{"$f":"+'B-Block Ticket'!G39","v":0}]
["Stream Percentage:",{"$f":"+'I-Inputs'!B17","v":0.8},"Less Administrative Cost:",null,{"$f":"+'B-Block Ticket'!G40","v":-10}]
["Payment Type:",{"$f":"+'I-Inputs'!B18","v":"W"},"Less Payoff:",null,{"$f":"+'B-Block Ticket'!G41","v":-100}]
["First Payment Date:",{"$f":"+'I-Inputs'!B19","v":"2018-05-24"},"Less Title Escrow:",null,{"$f":"+'B-Block Ticket'!G42","v":0}]
["Payments in Stream:",{"$f":"+'B-Block Ticket'!C43","v":52},"Less Wire Fee:",null,{"$f":"+'B-Block Ticket'!G43","v":-30}]
["Payment Amount:",{"$f":"+'B-Block Ticket'!C44","v":0},"Total to Be Deducted:",null,{"$f":"+'B-Block Ticket'!G44","v":-140}]
["Collateral:",{"$f":"+'B-Block Ticket'!C45","v":0},"TOTAL TO BE FUNDED:",null,{"$f":"+'B-Block Ticket'!G45","v":-140}]
[]
[]
["Scheduled Due Dates","Payment Number","Payment:","Date Paid","Amount ACH'd"]
[{"$f":"+'I-Inputs'!B19","v":"2018-05-24"},1,{"$f":"+'D-Attachment Payments'!C11","v":""}]
[{"$f":"+A15+'I-Inputs'!$B$31","v":"2018-05-31"},2,{"$f":"+'D-Attachment Payments'!C12","v":""}]
[{"$f":"+A16+'I-Inputs'!$B$31","v":"2018-06-07"},3,{"$f":"+'D-Attachment Payments'!C13","v":""}]
[{"$f":"+A17+'I-Inputs'!$B$31","v":"2018-06-14"},4,{"$f":"+'D-Attachment Payments'!C14","v":""}]
[{"$f":"+A18+'I-Inputs'!$B$31","v":"2018-06-21"},5,{"$f":"+'D-Attachment Payments'!C15","v":""}]
[{"$f":"+A19+'I-Inputs'!$B$31","v":"2018-06-28"},6,{"$f":"+'D-Attachment Payments'!C16","v":""}]
[{"$f":"+A20+'I-Inputs'!$B$31","v":"2018-07-05"},7,{"$f":"+'D-Attachment Payments'!C17","v":""}]
[{"$f":"+A21+'I-Inputs'!$B$31","v":"2018-07-12"},8,{"$f":"+'D-Attachment Payments'!C18","v":""}]
[{"$f":"+A22+'I-Inputs'!$B$31","v":"2018-07-19"},9,{"$f":"+'D-Attachment Payments'!C19","v":""}]
[{"$f":"+A23+'I-Inputs'!$B$31","v":"2018-07-26"},10,{"$f":"+'D-Attachment Payments'!C20","v":""}]
[{"$f":"+A24+'I-Inputs'!$B$31","v":"2018-08-02"},11,{"$f":"+'D-Attachment Payments'!C21","v":""}]
[{"$f":"+A25+'I-Inputs'!$B$31","v":"2018-08-09"},12,{"$f":"+'D-Attachment Payments'!C22","v":""}]
[{"$f":"+A26+'I-Inputs'!$B$31","v":"2018-08-16"},13,{"$f":"+'D-Attachment Payments'!C23","v":""}]
[{"$f":"+A27+'I-Inputs'!$B$31","v":"2018-08-23"},14,{"$f":"+'D-Attachment Payments'!C24","v":""}]
[{"$f":"+A28+'I-Inputs'!$B$31","v":"2018-08-30"},15,{"$f":"+'D-Attachment Payments'!C25","v":""}]
[{"$f":"+A29+'I-Inputs'!$B$31","v":"2018-09-06"},16,{"$f":"+'D-Attachment Payments'!C26","v":""}]
[{"$f":"+A30+'I-Inputs'!$B$31","v":"2018-09-13"},17,{"$f":"+'D-Attachment Payments'!C27","v":""}]
[{"$f":"+A31+'I-Inputs'!$B$31","v":"2018-09-20"},18,{"$f":"+'D-Attachment Payments'!C28","v":""}]
[{"$f":"+A32+'I-Inputs'!$B$31","v":"2018-09-27"},19,{"$f":"+'D-Attachment Payments'!C29","v":""}]
[{"$f":"+A33+'I-Inputs'!$B$31","v":"2018-10-04"},20,{"$f":"+'D-Attachment Payments'!C30","v":""}]
[{"$f":"+A34+'I-Inputs'!$B$31","v":"2018-10-11"},21,{"$f":"+'D-Attachment Payments'!C31","v":""}]
[{"$f":"+A35+'I-Inputs'!$B$31","v":"2018-10-18"},22,{"$f":"+'D-Attachment Payments'!C32","v":""}]
[{"$f":"+A36+'I-Inputs'!$B$31","v":"2018-10-25"},23,{"$f":"+'D-Attachment Payments'!C33","v":""}]
[{"$f":"+A37+'I-Inputs'!$B$31","v":"2018-11-01"},24,{"$f":"+'D-Attachment Payments'!C34","v":""}]
[{"$f":"+A38+'I-Inputs'!$B$31","v":"2018-11-08"},25,{"$f":"+'D-Attachment Payments'!C35","v":""}]
[{"$f":"+A39+'I-Inputs'!$B$31","v":"2018-11-15"},26,{"$f":"+'D-Attachment Payments'!C36","v":""}]
[{"$f":"+A40+'I-Inputs'!$B$31","v":"2018-11-22"},27,{"$f":"+'D-Attachment Payments'!C37","v":""}]
[{"$f":"+A41+'I-Inputs'!$B$31","v":"2018-11-29"},28,{"$f":"+'D-Attachment Payments'!C38","v":""}]
[{"$f":"+A42+'I-Inputs'!$B$31","v":"2018-12-06"},29,{"$f":"+'D-Attachment Payments'!C39","v":""}]
[{"$f":"+A43+'I-Inputs'!$B$31","v":"2018-12-13"},30,{"$f":"+'D-Attachment Payments'!C40","v":""}]
[{"$f":"+A44+'I-Inputs'!$B$31","v":"2018-12-20"},31,{"$f":"+'D-Attachment Payments'!C41","v":""}]
[{"$f":"+A45+'I-Inputs'!$B$31","v":"2018-12-27"},32,{"$f":"+'D-Attachment Payments'!C42","v":""}]
[{"$f":"+A46+'I-Inputs'!$B$31","v":"2019-01-03"},33,{"$f":"+'D-Attachment Payments'!C43","v":""}]
[{"$f":"+A47+'I-Inputs'!$B$31","v":"2019-01-10"},34,{"$f":"+'D-Attachment Payments'!C44","v":""}]
[{"$f":"+A48+'I-Inputs'!$B$31","v":"2019-01-17"},35,{"$f":"+'D-Attachment Payments'!C45","v":""}]
[{"$f":"+A49+'I-Inputs'!$B$31","v":"2019-01-24"},36,{"$f":"+'D-Attachment Payments'!C46","v":""}]
[{"$f":"+A50+'I-Inputs'!$B$31","v":"2019-01-31"},37,{"$f":"+'D-Attachment Payments'!C47","v":""}]
[{"$f":"+A51+'I-Inputs'!$B$31","v":"2019-02-07"},38,{"$f":"+'D-Attachment Payments'!C48","v":""}]
[{"$f":"+A52+'I-Inputs'!$B$31","v":"2019-02-14"},39,{"$f":"+'D-Attachment Payments'!C49","v":""}]
[{"$f":"+A53+'I-Inputs'!$B$31","v":"2019-02-21"},40,{"$f":"+'D-Attachment Payments'!C50","v":""}]
[{"$f":"+A54+'I-Inputs'!$B$31","v":"2019-02-28"},41,{"$f":"+'D-Attachment Payments'!C51","v":""}]
[{"$f":"+A55+'I-Inputs'!$B$31","v":"2019-03-07"},42,{"$f":"+'D-Attachment Payments'!C52","v":""}]
[{"$f":"+A56+'I-Inputs'!$B$31","v":"2019-03-14"},43,{"$f":"+'D-Attachment Payments'!C53","v":""}]
[{"$f":"+A57+'I-Inputs'!$B$31","v":"2019-03-21"},44,{"$f":"+'D-Attachment Payments'!C54","v":""}]
[{"$f":"+A58+'I-Inputs'!$B$31","v":"2019-03-28"},45,{"$f":"+'D-Attachment Payments'!C55","v":""}]
[{"$f":"+A59+'I-Inputs'!$B$31","v":"2019-04-04"},46,{"$f":"+'D-Attachment Payments'!C56","v":""}]
[{"$f":"+A60+'I-Inputs'!$B$31","v":"2019-04-11"},47,{"$f":"+'D-Attachment Payments'!C57","v":""}]
[{"$f":"+A61+'I-Inputs'!$B$31","v":"2019-04-18"},48,{"$f":"+'D-Attachment Payments'!C58","v":""}]
[{"$f":"+A62+'I-Inputs'!$B$31","v":"2019-04-25"},49,{"$f":"+'D-Attachment Payments'!C59","v":""}]
[{"$f":"+A63+'I-Inputs'!$B$31","v":"2019-05-02"},50,{"$f":"+'D-Attachment Payments'!C60","v":""}]
[{"$f":"+A64+'I-Inputs'!$B$31","v":"2019-05-09"},51,{"$f":"+'D-Attachment Payments'!C61","v":""}]
[{"$f":"+A65+'I-Inputs'!$B$31","v":"2019-05-16"},52,{"$f":"+'D-Attachment Payments'!C62","v":""}]
[{"$f":"+A66+'I-Inputs'!$B$31","v":"2019-05-23"},53,{"$f":"+'D-Attachment Payments'!C63","v":""}]
[{"$f":"+A67+'I-Inputs'!$B$31","v":"2019-05-30"},54,{"$f":"+'D-Attachment Payments'!C64","v":""}]
[{"$f":"+A68+'I-Inputs'!$B$31","v":"2019-06-06"},55,{"$f":"+'D-Attachment Payments'!C65","v":""}]
[{"$f":"+A69+'I-Inputs'!$B$31","v":"2019-06-13"},56,{"$f":"+'D-Attachment Payments'!C66","v":""}]
[{"$f":"+A70+'I-Inputs'!$B$31","v":"2019-06-20"},57,{"$f":"+'D-Attachment Payments'!C67","v":""}]
[{"$f":"+A71+'I-Inputs'!$B$31","v":"2019-06-27"},58,{"$f":"+'D-Attachment Payments'!C68","v":""}]
[{"$f":"+A72+'I-Inputs'!$B$31","v":"2019-07-04"},59,{"$f":"+'D-Attachment Payments'!C69","v":""}]
[{"$f":"+A73+'I-Inputs'!$B$31","v":"2019-07-11"},60,{"$f":"+'D-Attachment Payments'!C70","v":""}]
[{"$f":"+A74+'I-Inputs'!$B$31","v":"2019-07-18"},61,{"$f":"+'D-Attachment Payments'!C71","v":""}]
[{"$f":"+A75+'I-Inputs'!$B$31","v":"2019-07-25"},62,{"$f":"+'D-Attachment Payments'!C72","v":""}]
[{"$f":"+A76+'I-Inputs'!$B$31","v":"2019-08-01"},63,{"$f":"+'D-Attachment Payments'!C73","v":""}]
[{"$f":"+A77+'I-Inputs'!$B$31","v":"2019-08-08"},64,{"$f":"+'D-Attachment Payments'!C74","v":""}]
[{"$f":"+A78+'I-Inputs'!$B$31","v":"2019-08-15"},65,{"$f":"+'D-Attachment Payments'!C75","v":""}]
[{"$f":"+A79+'I-Inputs'!$B$31","v":"2019-08-22"},66,{"$f":"+'D-Attachment Payments'!C76","v":""}]
[{"$f":"+A80+'I-Inputs'!$B$31","v":"2019-08-29"},67,{"$f":"+'D-Attachment Payments'!C77","v":""}]
[{"$f":"+A81+'I-Inputs'!$B$31","v":"2019-09-05"},68,{"$f":"+'D-Attachment Payments'!C78","v":""}]
[{"$f":"+A82+'I-Inputs'!$B$31","v":"2019-09-12"},69,{"$f":"+'D-Attachment Payments'!C79","v":""}]
[{"$f":"+A83+'I-Inputs'!$B$31","v":"2019-09-19"},70,{"$f":"+'D-Attachment Payments'!C80","v":""}]
[{"$f":"+A84+'I-Inputs'!$B$31","v":"2019-09-26"},71,{"$f":"+'D-Attachment Payments'!C81","v":""}]
[{"$f":"+A85+'I-Inputs'!$B$31","v":"2019-10-03"},72,{"$f":"+'D-Attachment Payments'!C82","v":""}]
[{"$f":"+A86+'I-Inputs'!$B$31","v":"2019-10-10"},73,{"$f":"+'D-Attachment Payments'!C83","v":""}]
[{"$f":"+A87+'I-Inputs'!$B$31","v":"2019-10-17"},74,{"$f":"+'D-Attachment Payments'!C84","v":""}]
[{"$f":"+A88+'I-Inputs'!$B$31","v":"2019-10-24"},75,{"$f":"+'D-Attachment Payments'!C85","v":""}]
[{"$f":"+A89+'I-Inputs'!$B$31","v":"2019-10-31"},76,{"$f":"+'D-Attachment Payments'!C86","v":""}]
[{"$f":"+A90+'I-Inputs'!$B$31","v":"2019-11-07"},77,{"$f":"+'D-Attachment Payments'!C87","v":""}]
[{"$f":"+A91+'I-Inputs'!$B$31","v":"2019-11-14"},78,{"$f":"+'D-Attachment Payments'!C88","v":""}]
[{"$f":"+A92+'I-Inputs'!$B$31","v":"2019-11-21"},79,{"$f":"+'D-Attachment Payments'!C89","v":""}]
[{"$f":"+A93+'I-Inputs'!$B$31","v":"2019-11-28"},80,{"$f":"+'D-Attachment Payments'!C90","v":""}]
[{"$f":"+A94+'I-Inputs'!$B$31","v":"2019-12-05"},81,{"$f":"+'D-Attachment Payments'!C91","v":""}]
[{"$f":"+A95+'I-Inputs'!$B$31","v":"2019-12-12"},82,{"$f":"+'D-Attachment Payments'!C92","v":""}]
[{"$f":"+A96+'I-Inputs'!$B$31","v":"2019-12-19"},83,{"$f":"+'D-Attachment Payments'!C93","v":""}]
[{"$f":"+A97+'I-Inputs'!$B$31","v":"2019-12-26"},84,{"$f":"+'D-Attachment Payments'!C94","v":""}]
[{"$f":"+A98+'I-Inputs'!$B$31","v":"2020-01-02"},85,{"$f":"+'D-Attachment Payments'!C95","v":""}]
[{"$f":"+A99+'I-Inputs'!$B$31","v":"2020-01-09"},86,{"$f":"+'D-Attachment Payments'!C96","v":""}]
[{"$f":"+A100+'I-Inputs'!$B$31","v":"2020-01-16"},87,{"$f":"+'D-Attachment Payments'!C97","v":""}]
[{"$f":"+A101+'I-Inputs'!$B$31","v":"2020-01-23"},88,{"$f":"+'D-Attachment Payments'!C98","v":""}]
[{"$f":"+A102+'I-Inputs'!$B$31","v":"2020-01-30"},89,{"$f":"+'D-Attachment Payments'!C99","v":""}]
[{"$f":"+A103+'I-Inputs'!$B$31","v":"2020-02-06"},90,{"$f":"+'D-Attachment Payments'!C100","v":""}]
[{"$f":"+A104+'I-Inputs'!$B$31","v":"2020-02-13"},91,{"$f":"+'D-Attachment Payments'!C101","v":""}]
[{"$f":"+A105+'I-Inputs'!$B$31","v":"2020-02-20"},92,{"$f":"+'D-Attachment Payments'!C102","v":""}]
[{"$f":"+A106+'I-Inputs'!$B$31","v":"2020-02-27"},93,{"$f":"+'D-Attachment Payments'!C103","v":""}]
[{"$f":"+A107+'I-Inputs'!$B$31","v":"2020-03-05"},94,{"$f":"+'D-Attachment Payments'!C104","v":""}]
[{"$f":"+A108+'I-Inputs'!$B$31","v":"2020-03-12"},95,{"$f":"+'D-Attachment Payments'!C105","v":""}]
[{"$f":"+A109+'I-Inputs'!$B$31","v":"2020-03-19"},96,{"$f":"+'D-Attachment Payments'!C106","v":""}]
[{"$f":"+A110+'I-Inputs'!$B$31","v":"2020-03-26"},97,{"$f":"+'D-Attachment Payments'!C107","v":""}]
[{"$f":"+A111+'I-Inputs'!$B$31","v":"2020-04-02"},98,{"$f":"+'D-Attachment Payments'!C108","v":""}]
[{"$f":"+A112+'I-Inputs'!$B$31","v":"2020-04-09"},99,{"$f":"+'D-Attachment Payments'!C109","v":""}]
[{"$f":"+A113+'I-Inputs'!$B$31","v":"2020-04-16"},100,{"$f":"+'D-Attachment Payments'!C110","v":""}]
[{"$f":"+A114+'I-Inputs'!$B$31","v":"2020-04-23"},101,{"$f":"+'D-Attachment Payments'!C111","v":""}]
[{"$f":"+A115+'I-Inputs'!$B$31","v":"2020-04-30"},102,{"$f":"+'D-Attachment Payments'!C112","v":""}]
[{"$f":"+A116+'I-Inputs'!$B$31","v":"2020-05-07"},103,{"$f":"+'D-Attachment Payments'!C113","v":""}]
[{"$f":"+A117+'I-Inputs'!$B$31","v":"2020-05-14"},104,{"$f":"+'D-Attachment Payments'!C114","v":""}]
[{"$f":"+A118+'I-Inputs'!$B$31","v":"2020-05-21"},105,{"$f":"+'D-Attachment Payments'!C115","v":""}]
[{"$f":"+A119+'I-Inputs'!$B$31","v":"2020-05-28"},106,{"$f":"+'D-Attachment Payments'!C116","v":""}]
[{"$f":"+A120+'I-Inputs'!$B$31","v":"2020-06-04"},107,{"$f":"+'D-Attachment Payments'!C117","v":""}]
[{"$f":"+A121+'I-Inputs'!$B$31","v":"2020-06-11"},108,{"$f":"+'D-Attachment Payments'!C118","v":""}]
[{"$f":"+A122+'I-Inputs'!$B$31","v":"2020-06-18"},109,{"$f":"+'D-Attachment Payments'!C119","v":""}]
[{"$f":"+A123+'I-Inputs'!$B$31","v":"2020-06-25"},110,{"$f":"+'D-Attachment Payments'!C120","v":""}]
[{"$f":"+A124+'I-Inputs'!$B$31","v":"2020-07-02"},111,{"$f":"+'D-Attachment Payments'!C121","v":""}]
[{"$f":"+A125+'I-Inputs'!$B$31","v":"2020-07-09"},112,{"$f":"+'D-Attachment Payments'!C122","v":""}]
[{"$f":"+A126+'I-Inputs'!$B$31","v":"2020-07-16"},113,{"$f":"+'D-Attachment Payments'!C123","v":""}]
[{"$f":"+A127+'I-Inputs'!$B$31","v":"2020-07-23"},114,{"$f":"+'D-Attachment Payments'!C124","v":""}]
[{"$f":"+A128+'I-Inputs'!$B$31","v":"2020-07-30"},115,{"$f":"+'D-Attachment Payments'!C125","v":""}]
[{"$f":"+A129+'I-Inputs'!$B$31","v":"2020-08-06"},116,{"$f":"+'D-Attachment Payments'!C126","v":""}]
[{"$f":"+A130+'I-Inputs'!$B$31","v":"2020-08-13"},117,{"$f":"+'D-Attachment Payments'!C127","v":""}]
[{"$f":"+A131+'I-Inputs'!$B$31","v":"2020-08-20"},118,{"$f":"+'D-Attachment Payments'!C128","v":""}]
[{"$f":"+A132+'I-Inputs'!$B$31","v":"2020-08-27"},119,{"$f":"+'D-Attachment Payments'!C129","v":""}]
[{"$f":"+A133+'I-Inputs'!$B$31","v":"2020-09-03"},120,{"$f":"+'D-Attachment Payments'!C130","v":""}]
[{"$f":"+A134+'I-Inputs'!$B$31","v":"2020-09-10"},121,{"$f":"+'D-Attachment Payments'!C131","v":""}]
[{"$f":"+A135+'I-Inputs'!$B$31","v":"2020-09-17"},122,{"$f":"+'D-Attachment Payments'!C132","v":""}]
[{"$f":"+A136+'I-Inputs'!$B$31","v":"2020-09-24"},123,{"$f":"+'D-Attachment Payments'!C133","v":""}]
[{"$f":"+A137+'I-Inputs'!$B$31","v":"2020-10-01"},124,{"$f":"+'D-Attachment Payments'!C134","v":""}]
[{"$f":"+A138+'I-Inputs'!$B$31","v":"2020-10-08"},125,{"$f":"+'D-Attachment Payments'!C135","v":""}]
[{"$f":"+A139+'I-Inputs'!$B$31","v":"2020-10-15"},126,{"$f":"+'D-Attachment Payments'!C136","v":""}]
[{"$f":"+A140+'I-Inputs'!$B$31","v":"2020-10-22"},127,{"$f":"+'D-Attachment Payments'!C137","v":""}]
[{"$f":"+A141+'I-Inputs'!$B$31","v":"2020-10-29"},128,{"$f":"+'D-Attachment Payments'!C138","v":""}]
[{"$f":"+A142+'I-Inputs'!$B$31","v":"2020-11-05"},129,{"$f":"+'D-Attachment Payments'!C139","v":""}]
[{"$f":"+A143+'I-Inputs'!$B$31","v":"2020-11-12"},130,{"$f":"+'D-Attachment Payments'!C140","v":""}]

{"sheet":"F - Payoff","index":6,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":true,"merged":[[8,1,9,1],[8,8,8,10],[6,3,6,4],[7,3,7,4],[7,6,7,7],[4,3,4,4],[4,6,4,7],[5,3,5,4],[5,6,5,7],[2,3,2,4],[2,6,2,7],[3,3,3,4],[3,6,3,7]]}
["PAYOFF CALCULATION  (Internal Use Only)"]
[]
[null,null,"Dealer Name:",{"$f":"+'A-Assignment Worksheet'!D3","v":0},null,"Batch #:",{"$f":"+'I-Inputs'!B7","v":1}]
[null,null,"Last Payment Completed:","2018-06-15"]
[null,null,"Last Payment in Batch:",{"$f":"+'I-Inputs'!B20","v":"2019-05-24"}]
[null,null,"Batch Payments Remaining:",{"$f":"(DATEDIF(D4+'I-Inputs'!B31,D5,\"D\"))/'I-Inputs'!B31","v":48}]
[null,null,"Total Payments in Batch:",{"$f":"+'B-Block Ticket'!R7","v":51.996000000000002},null,null,null,null,null,"Today's Date:",{"$f":"TODAY()","v":"2018-10-02"}]
[]
[null,"Select Account (1)",null,null,null,null,null,null,"Payments Remaining"]
["#",null,"Last Name","First Name","Year","Make","Principal Balance","Payment","Payments Made","Payments Remaining","Payoff Amount"]
[1,null,{"$f":"+'A-Assignment Worksheet'!J11","v":0},{"$f":"+'A-Assignment Worksheet'!K11","v":0},{"$f":"+'A-Assignment Worksheet'!G11","v":0},{"$f":"+'A-Assignment Worksheet'!H11","v":0},{"$f":"+'A-Assignment Worksheet'!L11","v":0},{"$f":"+'A-Assignment Worksheet'!E11","v":0},{"$f":"IF(E11>0,(+'B-Block Ticket'!H11-'F - Payoff'!J11),\"\")","v":""},{"$f":"IF(E11>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U11),\"\")","v":""},{"$f":"IF(B11=1,(+J11*H11),\"\")","v":""}]
[2,null,{"$f":"+'A-Assignment Worksheet'!J12","v":0},{"$f":"+'A-Assignment Worksheet'!K12","v":0},{"$f":"+'A-Assignment Worksheet'!G12","v":0},{"$f":"+'A-Assignment Worksheet'!H12","v":0},{"$f":"+'A-Assignment Worksheet'!L12","v":0},{"$f":"+'A-Assignment Worksheet'!E12","v":0},{"$f":"IF(E12>0,(+'B-Block Ticket'!H12-'F - Payoff'!J12),\"\")","v":""},{"$f":"IF(E12>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U12),\"\")","v":""},{"$f":"IF(B12=1,(+J12*H12),\"\")","v":""}]
[3]
[4,null,{"$f":"+'A-Assignment Worksheet'!J14","v":0},{"$f":"+'A-Assignment Worksheet'!K14","v":0},{"$f":"+'A-Assignment Worksheet'!G14","v":0},{"$f":"+'A-Assignment Worksheet'!H14","v":0},{"$f":"+'A-Assignment Worksheet'!L14","v":0},{"$f":"+'A-Assignment Worksheet'!E14","v":0},{"$f":"IF(E14>0,(+'B-Block Ticket'!H14-'F - Payoff'!J14),\"\")","v":""},{"$f":"IF(E14>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U14),\"\")","v":""},""]
[5,null,{"$f":"+'A-Assignment Worksheet'!J15","v":0},{"$f":"+'A-Assignment Worksheet'!K15","v":0},{"$f":"+'A-Assignment Worksheet'!G15","v":0},{"$f":"+'A-Assignment Worksheet'!H15","v":0},{"$f":"+'A-Assignment Worksheet'!L15","v":0},{"$f":"+'A-Assignment Worksheet'!E15","v":0},{"$f":"IF(E15>0,(+'B-Block Ticket'!H15-'F - Payoff'!J15),\"\")","v":""},{"$f":"IF(E15>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U15),\"\")","v":""},""]
[6,null,{"$f":"+'A-Assignment Worksheet'!J16","v":0},{"$f":"+'A-Assignment Worksheet'!K16","v":0},{"$f":"+'A-Assignment Worksheet'!G16","v":0},{"$f":"+'A-Assignment Worksheet'!H16","v":0},{"$f":"+'A-Assignment Worksheet'!L16","v":0},{"$f":"+'A-Assignment Worksheet'!E16","v":0},{"$f":"IF(E16>0,(+'B-Block Ticket'!H16-'F - Payoff'!J16),\"\")","v":""},{"$f":"IF(E16>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U16),\"\")","v":""},""]
[7,null,{"$f":"+'A-Assignment Worksheet'!J17","v":0},{"$f":"+'A-Assignment Worksheet'!K17","v":0},{"$f":"+'A-Assignment Worksheet'!G17","v":0},{"$f":"+'A-Assignment Worksheet'!H17","v":0},{"$f":"+'A-Assignment Worksheet'!L17","v":0},{"$f":"+'A-Assignment Worksheet'!E17","v":0},{"$f":"IF(E17>0,(+'B-Block Ticket'!H17-'F - Payoff'!J17),\"\")","v":""},{"$f":"IF(E17>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U17),\"\")","v":""},""]
[8,null,{"$f":"+'A-Assignment Worksheet'!J18","v":0},{"$f":"+'A-Assignment Worksheet'!K18","v":0},{"$f":"+'A-Assignment Worksheet'!G18","v":0},{"$f":"+'A-Assignment Worksheet'!H18","v":0},{"$f":"+'A-Assignment Worksheet'!L18","v":0},{"$f":"+'A-Assignment Worksheet'!E18","v":0},{"$f":"IF(E18>0,(+'B-Block Ticket'!H18-'F - Payoff'!J18),\"\")","v":""},{"$f":"IF(E18>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U18),\"\")","v":""},""]
[9,null,{"$f":"+'A-Assignment Worksheet'!J19","v":0},{"$f":"+'A-Assignment Worksheet'!K19","v":0},{"$f":"+'A-Assignment Worksheet'!G19","v":0},{"$f":"+'A-Assignment Worksheet'!H19","v":0},{"$f":"+'A-Assignment Worksheet'!L19","v":0},{"$f":"+'A-Assignment Worksheet'!E19","v":0},{"$f":"IF(E19>0,(+'B-Block Ticket'!H19-'F - Payoff'!J19),\"\")","v":""},{"$f":"IF(E19>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U19),\"\")","v":""},""]
[10,null,{"$f":"+'A-Assignment Worksheet'!J20","v":0},{"$f":"+'A-Assignment Worksheet'!K20","v":0},{"$f":"+'A-Assignment Worksheet'!G20","v":0},{"$f":"+'A-Assignment Worksheet'!H20","v":0},{"$f":"+'A-Assignment Worksheet'!L20","v":0},{"$f":"+'A-Assignment Worksheet'!E20","v":0},{"$f":"IF(E20>0,(+'B-Block Ticket'!H20-'F - Payoff'!J20),\"\")","v":""},{"$f":"IF(E20>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U20),\"\")","v":""},""]
[11,null,{"$f":"+'A-Assignment Worksheet'!J21","v":0},{"$f":"+'A-Assignment Worksheet'!K21","v":0},{"$f":"+'A-Assignment Worksheet'!G21","v":0},{"$f":"+'A-Assignment Worksheet'!H21","v":0},{"$f":"+'A-Assignment Worksheet'!L21","v":0},{"$f":"+'A-Assignment Worksheet'!E21","v":0},{"$f":"IF(E21>0,(+'B-Block Ticket'!H21-'F - Payoff'!J21),\"\")","v":""},{"$f":"IF(E21>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U21),\"\")","v":""},""]
[12,null,{"$f":"+'A-Assignment Worksheet'!J22","v":0},{"$f":"+'A-Assignment Worksheet'!K22","v":0},{"$f":"+'A-Assignment Worksheet'!G22","v":0},{"$f":"+'A-Assignment Worksheet'!H22","v":0},{"$f":"+'A-Assignment Worksheet'!L22","v":0},{"$f":"+'A-Assignment Worksheet'!E22","v":0},{"$f":"IF(E22>0,(+'B-Block Ticket'!H22-'F - Payoff'!J22),\"\")","v":""},{"$f":"IF(E22>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U22),\"\")","v":""},""]
[13,null,{"$f":"+'A-Assignment Worksheet'!J23","v":0},{"$f":"+'A-Assignment Worksheet'!K23","v":0},{"$f":"+'A-Assignment Worksheet'!G23","v":0},{"$f":"+'A-Assignment Worksheet'!H23","v":0},{"$f":"+'A-Assignment Worksheet'!L23","v":0},{"$f":"+'A-Assignment Worksheet'!E23","v":0},{"$f":"IF(E23>0,(+'B-Block Ticket'!H23-'F - Payoff'!J23),\"\")","v":""},{"$f":"IF(E23>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U23),\"\")","v":""},""]
[14,null,{"$f":"+'A-Assignment Worksheet'!J24","v":0},{"$f":"+'A-Assignment Worksheet'!K24","v":0},{"$f":"+'A-Assignment Worksheet'!G24","v":0},{"$f":"+'A-Assignment Worksheet'!H24","v":0},{"$f":"+'A-Assignment Worksheet'!L24","v":0},{"$f":"+'A-Assignment Worksheet'!E24","v":0},{"$f":"IF(E24>0,(+'B-Block Ticket'!H24-'F - Payoff'!J24),\"\")","v":""},{"$f":"IF(E24>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U24),\"\")","v":""},""]
[15,null,{"$f":"+'A-Assignment Worksheet'!J25","v":0},{"$f":"+'A-Assignment Worksheet'!K25","v":0},{"$f":"+'A-Assignment Worksheet'!G25","v":0},{"$f":"+'A-Assignment Worksheet'!H25","v":0},{"$f":"+'A-Assignment Worksheet'!L25","v":0},{"$f":"+'A-Assignment Worksheet'!E25","v":0},{"$f":"IF(E25>0,(+'B-Block Ticket'!H25-'F - Payoff'!J25),\"\")","v":""},{"$f":"IF(E25>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U25),\"\")","v":""},""]
[16,null,{"$f":"+'A-Assignment Worksheet'!J26","v":0},{"$f":"+'A-Assignment Worksheet'!K26","v":0},{"$f":"+'A-Assignment Worksheet'!G26","v":0},{"$f":"+'A-Assignment Worksheet'!H26","v":0},{"$f":"+'A-Assignment Worksheet'!L26","v":0},{"$f":"+'A-Assignment Worksheet'!E26","v":0},{"$f":"IF(E26>0,(+'B-Block Ticket'!H26-'F - Payoff'!J26),\"\")","v":""},{"$f":"IF(E26>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U26),\"\")","v":""},""]
[17,null,{"$f":"+'A-Assignment Worksheet'!J27","v":0},{"$f":"+'A-Assignment Worksheet'!K27","v":0},{"$f":"+'A-Assignment Worksheet'!G27","v":0},{"$f":"+'A-Assignment Worksheet'!H27","v":0},{"$f":"+'A-Assignment Worksheet'!L27","v":0},{"$f":"+'A-Assignment Worksheet'!E27","v":0},{"$f":"IF(E27>0,(+'B-Block Ticket'!H27-'F - Payoff'!J27),\"\")","v":""},{"$f":"IF(E27>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U27),\"\")","v":""},""]
[18,null,{"$f":"+'A-Assignment Worksheet'!J28","v":0},{"$f":"+'A-Assignment Worksheet'!K28","v":0},{"$f":"+'A-Assignment Worksheet'!G28","v":0},{"$f":"+'A-Assignment Worksheet'!H28","v":0},{"$f":"+'A-Assignment Worksheet'!L28","v":0},{"$f":"+'A-Assignment Worksheet'!E28","v":0},{"$f":"IF(E28>0,(+'B-Block Ticket'!H28-'F - Payoff'!J28),\"\")","v":""},{"$f":"IF(E28>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U28),\"\")","v":""},""]
[19,null,{"$f":"+'A-Assignment Worksheet'!J29","v":0},{"$f":"+'A-Assignment Worksheet'!K29","v":0},{"$f":"+'A-Assignment Worksheet'!G29","v":0},{"$f":"+'A-Assignment Worksheet'!H29","v":0},{"$f":"+'A-Assignment Worksheet'!L29","v":0},{"$f":"+'A-Assignment Worksheet'!E29","v":0},{"$f":"IF(E29>0,(+'B-Block Ticket'!H29-'F - Payoff'!J29),\"\")","v":""},{"$f":"IF(E29>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U29),\"\")","v":""},""]
[20,null,{"$f":"+'A-Assignment Worksheet'!J30","v":0},{"$f":"+'A-Assignment Worksheet'!K30","v":0},{"$f":"+'A-Assignment Worksheet'!G30","v":0},{"$f":"+'A-Assignment Worksheet'!H30","v":0},{"$f":"+'A-Assignment Worksheet'!L30","v":0},{"$f":"+'A-Assignment Worksheet'!E30","v":0},{"$f":"IF(E30>0,(+'B-Block Ticket'!H30-'F - Payoff'!J30),\"\")","v":""},{"$f":"IF(E30>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U30),\"\")","v":""},""]
[21,null,{"$f":"+'A-Assignment Worksheet'!J31","v":0},{"$f":"+'A-Assignment Worksheet'!K31","v":0},{"$f":"+'A-Assignment Worksheet'!G31","v":0},{"$f":"+'A-Assignment Worksheet'!H31","v":0},{"$f":"+'A-Assignment Worksheet'!L31","v":0},{"$f":"+'A-Assignment Worksheet'!E31","v":0},{"$f":"IF(E31>0,(+'B-Block Ticket'!H31-'F - Payoff'!J31),\"\")","v":""},{"$f":"IF(E31>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U31),\"\")","v":""},""]
[22,null,{"$f":"+'A-Assignment Worksheet'!J32","v":0},{"$f":"+'A-Assignment Worksheet'!K32","v":0},{"$f":"+'A-Assignment Worksheet'!G32","v":0},{"$f":"+'A-Assignment Worksheet'!H32","v":0},{"$f":"+'A-Assignment Worksheet'!L32","v":0},{"$f":"+'A-Assignment Worksheet'!E32","v":0},{"$f":"IF(E32>0,(+'B-Block Ticket'!H32-'F - Payoff'!J32),\"\")","v":""},{"$f":"IF(E32>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U32),\"\")","v":""},""]
[23,null,{"$f":"+'A-Assignment Worksheet'!J33","v":0},{"$f":"+'A-Assignment Worksheet'!K33","v":0},{"$f":"+'A-Assignment Worksheet'!G33","v":0},{"$f":"+'A-Assignment Worksheet'!H33","v":0},{"$f":"+'A-Assignment Worksheet'!L33","v":0},{"$f":"+'A-Assignment Worksheet'!E33","v":0},{"$f":"IF(E33>0,(+'B-Block Ticket'!H33-'F - Payoff'!J33),\"\")","v":""},{"$f":"IF(E33>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U33),\"\")","v":""},""]
[24,null,{"$f":"+'A-Assignment Worksheet'!J34","v":0},{"$f":"+'A-Assignment Worksheet'!K34","v":0},{"$f":"+'A-Assignment Worksheet'!G34","v":0},{"$f":"+'A-Assignment Worksheet'!H34","v":0},{"$f":"+'A-Assignment Worksheet'!L34","v":0},{"$f":"+'A-Assignment Worksheet'!E34","v":0},{"$f":"IF(E34>0,(+'B-Block Ticket'!H34-'F - Payoff'!J34),\"\")","v":""},{"$f":"IF(E34>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U34),\"\")","v":""},""]
[25,null,{"$f":"+'A-Assignment Worksheet'!J35","v":0},{"$f":"+'A-Assignment Worksheet'!K35","v":0},{"$f":"+'A-Assignment Worksheet'!G35","v":0},{"$f":"+'A-Assignment Worksheet'!H35","v":0},{"$f":"+'A-Assignment Worksheet'!L35","v":0},{"$f":"+'A-Assignment Worksheet'!E35","v":0},{"$f":"IF(E35>0,(+'B-Block Ticket'!H35-'F - Payoff'!J35),\"\")","v":""},{"$f":"IF(E35>0,((DATEDIF($D$4+'I-Inputs'!$B$31,$D$5,\"D\"))/'B-Block Ticket'!U35),\"\")","v":""},""]
[null,null,"Totals",null,null,null,{"$f":"SUM(G11:G35)","v":0},null,null,null,{"$f":"SUM(K11:K35)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Office Use Only:"]
[null,null,"Stream Months:",{"$f":"+'I-Inputs'!B16","v":12},null,null,"Stream Advancement Amount:",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"Date Funded:"]
[null,null,"Stream Percentage:",{"$f":"+'I-Inputs'!B17","v":0.8},null,null,"Less Administrative Cost:",{"$f":"-'I-Inputs'!B24","v":-10},null,null,"QuickBooks:"]
[null,null,"Payment Type:",{"$f":"+'I-Inputs'!B18","v":"W"},null,null,"Less Payoff:",{"$f":"-'I-Inputs'!B22","v":-100},null,null,"ICN #:"]
[null,null,"First Payment Date:",{"$f":"+'I-Inputs'!B19","v":"2018-05-24"},null,null,"Less Title Escrow:",{"$f":"-'C-Attachment To Assignment'!J36","v":0},null,null,"Sales Comm. Updated:"]
[null,null,"Payments in Stream:",{"$f":"ROUND(+#REF!,0)","v":{"$error":"#REF!"}},null,null,"Less Wire Fee:",{"$f":"-'I-Inputs'!B25","v":-30},null,null,"Act Updated:"]
[null,null,"Payment Amount:",{"$f":"+J36/D43","v":{"$error":"#REF!"}},null,null,"Total to Be Deducted:",{"$f":"SUM(H40:H43)","v":-140}]
[null,null,"Collateral:",{"$f":"+'A-Assignment Worksheet'!L36","v":0},null,null,"TOTAL TO BE FUNDED:",{"$f":"+H39+H44","v":{"$error":"#REF!"}}]

{"sheet":"D-Checklist","index":7,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":true,"merged":[[2,11,2,12],[6,7,6,8],[7,7,7,8],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[2,6,2,7],[3,6,3,7],[4,6,4,7],[5,6,5,7]]}
[null,"SDA Account Checklist - INTERNAL USE ONLY"]
[]
[null,null,"Dealer Name:",{"$f":"+'A-Assignment Worksheet'!D3:E3","v":0},null,"City:",{"$f":"+'A-Assignment Worksheet'!G4:H4","v":0},null,null,null,"Batch #:",{"$f":"+'I-Inputs'!B7","v":1}]
[null,null,"Address:",{"$f":"+'A-Assignment Worksheet'!D4:E4","v":0},null,"ZIP:",{"$f":"+'A-Assignment Worksheet'!G5:H5","v":0}]
[null,null,"State:",{"$f":"+'A-Assignment Worksheet'!D5:E5","v":0},null,"Email:",{"$f":"+'A-Assignment Worksheet'!G6:H6","v":0}]
[null,null,"Phone:",{"$f":"+'A-Assignment Worksheet'!D6:E6","v":0},null,"Date:",{"$f":"+'A-Assignment Worksheet'!G7:H7","v":0}]
[null,null,"Fax:",{"$f":"+'A-Assignment Worksheet'!D7:E7","v":0}]
[]
[null,"Last Name","First Name","Car Year","Make","Model"," Original Title or Title Receipt","Original Sales Contract","Original Bill of Sale","Power of Attorney","Original Arbitration Agreement","GPS Disclosure Form","Customer Application","License or Social Security Card","Payment History of Account","Privacy Statement","Notes"]
[1,{"$f":"+'A-Assignment Worksheet'!J11","v":0},{"$f":"+'A-Assignment Worksheet'!K11","v":0},{"$f":"+'A-Assignment Worksheet'!G11","v":0},{"$f":"+'A-Assignment Worksheet'!H11","v":0},{"$f":"+'A-Assignment Worksheet'!I11","v":0},null,null,null,null,null,null,null,0,null,0,0,{"$f":"SUM(G10:N10)","v":0}]
[2,{"$f":"+'A-Assignment Worksheet'!J12","v":0},{"$f":"+'A-Assignment Worksheet'!K12","v":0},{"$f":"+'A-Assignment Worksheet'!G12","v":0},{"$f":"+'A-Assignment Worksheet'!H12","v":0},{"$f":"+'A-Assignment Worksheet'!I12","v":0},null,null,null,null,null,null,null,0,null,0,0,0]
[3,{"$f":"+'A-Assignment Worksheet'!J13","v":0},{"$f":"+'A-Assignment Worksheet'!K13","v":0},{"$f":"+'A-Assignment Worksheet'!G13","v":0},{"$f":"+'A-Assignment Worksheet'!H13","v":0},{"$f":"+'A-Assignment Worksheet'!I13","v":0},null,null,null,null,null,null,null,0,null,0,0,0]
[4,{"$f":"+'A-Assignment Worksheet'!J14","v":0},{"$f":"+'A-Assignment Worksheet'!K14","v":0},{"$f":"+'A-Assignment Worksheet'!G14","v":0},{"$f":"+'A-Assignment Worksheet'!H14","v":0},{"$f":"+'A-Assignment Worksheet'!I14","v":0},null,null,null,null,null,null,null,0,null,0,0,0]
[5,{"$f":"+'A-Assignment Worksheet'!J15","v":0},{"$f":"+'A-Assignment Worksheet'!K15","v":0},{"$f":"+'A-Assignment Worksheet'!G15","v":0},{"$f":"+'A-Assignment Worksheet'!H15","v":0},{"$f":"+'A-Assignment Worksheet'!I15","v":0},null,null,null,null,null,null,null,0,null,0,0,0]
[6,{"$f":"+'A-Assignment Worksheet'!J16","v":0},{"$f":"+'A-Assignment Worksheet'!K16","v":0},{"$f":"+'A-Assignment Worksheet'!G16","v":0},{"$f":"+'A-Assignment Worksheet'!H16","v":0},{"$f":"+'A-Assignment Worksheet'!I16","v":0},null,null,null,null,null,null,null,0,null,0,0,0]
[7,{"$f":"+'A-Assignment Worksheet'!J17","v":0},{"$f":"+'A-Assignment Worksheet'!K17","v":0},{"$f":"+'A-Assignment Worksheet'!G17","v":0},{"$f":"+'A-Assignment Worksheet'!H17","v":0},{"$f":"+'A-Assignment Worksheet'!I17","v":0},null,null,null,null,null,null,null,0,null,0,0,0]
[8,{"$f":"+'A-Assignment Worksheet'!J18","v":0},{"$f":"+'A-Assignment Worksheet'!K18","v":0},{"$f":"+'A-Assignment Worksheet'!G18","v":0},{"$f":"+'A-Assignment Worksheet'!H18","v":0},{"$f":"+'A-Assignment Worksheet'!I18","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[9,{"$f":"+'A-Assignment Worksheet'!J19","v":0},{"$f":"+'A-Assignment Worksheet'!K19","v":0},{"$f":"+'A-Assignment Worksheet'!G19","v":0},{"$f":"+'A-Assignment Worksheet'!H19","v":0},{"$f":"+'A-Assignment Worksheet'!I19","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[10,{"$f":"+'A-Assignment Worksheet'!J20","v":0},{"$f":"+'A-Assignment Worksheet'!K20","v":0},{"$f":"+'A-Assignment Worksheet'!G20","v":0},{"$f":"+'A-Assignment Worksheet'!H20","v":0},{"$f":"+'A-Assignment Worksheet'!I20","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[11,{"$f":"+'A-Assignment Worksheet'!J21","v":0},{"$f":"+'A-Assignment Worksheet'!K21","v":0},{"$f":"+'A-Assignment Worksheet'!G21","v":0},{"$f":"+'A-Assignment Worksheet'!H21","v":0},{"$f":"+'A-Assignment Worksheet'!I21","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[12,{"$f":"+'A-Assignment Worksheet'!J22","v":0},{"$f":"+'A-Assignment Worksheet'!K22","v":0},{"$f":"+'A-Assignment Worksheet'!G22","v":0},{"$f":"+'A-Assignment Worksheet'!H22","v":0},{"$f":"+'A-Assignment Worksheet'!I22","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[13,{"$f":"+'A-Assignment Worksheet'!J23","v":0},{"$f":"+'A-Assignment Worksheet'!K23","v":0},{"$f":"+'A-Assignment Worksheet'!G23","v":0},{"$f":"+'A-Assignment Worksheet'!H23","v":0},{"$f":"+'A-Assignment Worksheet'!I23","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[14,{"$f":"+'A-Assignment Worksheet'!J24","v":0},{"$f":"+'A-Assignment Worksheet'!K24","v":0},{"$f":"+'A-Assignment Worksheet'!G24","v":0},{"$f":"+'A-Assignment Worksheet'!H24","v":0},{"$f":"+'A-Assignment Worksheet'!I24","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[15,{"$f":"+'A-Assignment Worksheet'!J25","v":0},{"$f":"+'A-Assignment Worksheet'!K25","v":0},{"$f":"+'A-Assignment Worksheet'!G25","v":0},{"$f":"+'A-Assignment Worksheet'!H25","v":0},{"$f":"+'A-Assignment Worksheet'!I25","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[16,{"$f":"+'A-Assignment Worksheet'!J26","v":0},{"$f":"+'A-Assignment Worksheet'!K26","v":0},{"$f":"+'A-Assignment Worksheet'!G26","v":0},{"$f":"+'A-Assignment Worksheet'!H26","v":0},{"$f":"+'A-Assignment Worksheet'!I26","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[17,{"$f":"+'A-Assignment Worksheet'!J27","v":0},{"$f":"+'A-Assignment Worksheet'!K27","v":0},{"$f":"+'A-Assignment Worksheet'!G27","v":0},{"$f":"+'A-Assignment Worksheet'!H27","v":0},{"$f":"+'A-Assignment Worksheet'!I27","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[18,{"$f":"+'A-Assignment Worksheet'!J28","v":0},{"$f":"+'A-Assignment Worksheet'!K28","v":0},{"$f":"+'A-Assignment Worksheet'!G28","v":0},{"$f":"+'A-Assignment Worksheet'!H28","v":0},{"$f":"+'A-Assignment Worksheet'!I28","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[19,{"$f":"+'A-Assignment Worksheet'!J29","v":0},{"$f":"+'A-Assignment Worksheet'!K29","v":0},{"$f":"+'A-Assignment Worksheet'!G29","v":0},{"$f":"+'A-Assignment Worksheet'!H29","v":0},{"$f":"+'A-Assignment Worksheet'!I29","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[20,{"$f":"+'A-Assignment Worksheet'!J30","v":0},{"$f":"+'A-Assignment Worksheet'!K30","v":0},{"$f":"+'A-Assignment Worksheet'!G30","v":0},{"$f":"+'A-Assignment Worksheet'!H30","v":0},{"$f":"+'A-Assignment Worksheet'!I30","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[21,{"$f":"+'A-Assignment Worksheet'!J31","v":0},{"$f":"+'A-Assignment Worksheet'!K31","v":0},{"$f":"+'A-Assignment Worksheet'!G31","v":0},{"$f":"+'A-Assignment Worksheet'!H31","v":0},{"$f":"+'A-Assignment Worksheet'!I31","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[22,{"$f":"+'A-Assignment Worksheet'!J32","v":0},{"$f":"+'A-Assignment Worksheet'!K32","v":0},{"$f":"+'A-Assignment Worksheet'!G32","v":0},{"$f":"+'A-Assignment Worksheet'!H32","v":0},{"$f":"+'A-Assignment Worksheet'!I32","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[23,{"$f":"+'A-Assignment Worksheet'!J33","v":0},{"$f":"+'A-Assignment Worksheet'!K33","v":0},{"$f":"+'A-Assignment Worksheet'!G33","v":0},{"$f":"+'A-Assignment Worksheet'!H33","v":0},{"$f":"+'A-Assignment Worksheet'!I33","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[24,{"$f":"+'A-Assignment Worksheet'!J34","v":0},{"$f":"+'A-Assignment Worksheet'!K34","v":0},{"$f":"+'A-Assignment Worksheet'!G34","v":0},{"$f":"+'A-Assignment Worksheet'!H34","v":0},{"$f":"+'A-Assignment Worksheet'!I34","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[25,{"$f":"+'A-Assignment Worksheet'!J35","v":0},{"$f":"+'A-Assignment Worksheet'!K35","v":0},{"$f":"+'A-Assignment Worksheet'!G35","v":0},{"$f":"+'A-Assignment Worksheet'!H35","v":0},{"$f":"+'A-Assignment Worksheet'!I35","v":0},null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"N - Payment Histories","index":8,"n_rows":35,"n_cols":136,"rows_kept":35,"cut":false,"hidden":true,"merged":[[6,0,6,2],[8,0,8,5],[4,6,4,8],[5,6,5,8],[2,0,2,2],[4,0,4,2],[4,4,4,5],[5,0,5,2]]}
["Payment Histories Worksheet"]
[]
["Dealership Name:",null,null,{"$f":"+'A-Assignment Worksheet'!D3","v":0},null,null,null,null,"Batch #:",{"$f":"+'I-Inputs'!B7","v":1}]
[null,null,"Address:",{"$f":"+'A-Assignment Worksheet'!D4","v":0},null,null,null,null,"City:",{"$f":"+'A-Assignment Worksheet'!G4","v":0}]
["State:",null,null,{"$f":"+'A-Assignment Worksheet'!D5","v":0},null,null,"First payment Date:",null,null,{"$f":"+'I-Inputs'!B30","v":"2018-05-24"}]
["Phone:",null,null,{"$f":"+'A-Assignment Worksheet'!D6","v":0},null,null,"Payment Frequency:",null,null,{"$f":"+'I-Inputs'!$B$31","v":7}]
["Fax:",null,null,{"$f":"+'A-Assignment Worksheet'!D7","v":0}]
[]
[null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130]
[null,"Last Name","First Name","Car Year","Make","Model",{"$f":"+'I-Inputs'!$B$30","v":"2018-05-24"},{"$f":"+G10+'I-Inputs'!$B$31","v":"2018-05-31"},{"$f":"+H10+'I-Inputs'!$B$31","v":"2018-06-07"},{"$f":"+I10+'I-Inputs'!$B$31","v":"2018-06-14"},{"$f":"+J10+'I-Inputs'!$B$31","v":"2018-06-21"},{"$f":"+K10+'I-Inputs'!$B$31","v":"2018-06-28"},{"$f":"+L10+'I-Inputs'!$B$31","v":"2018-07-05"},{"$f":"+M10+'I-Inputs'!$B$31","v":"2018-07-12"},{"$f":"+N10+'I-Inputs'!$B$31","v":"2018-07-19"},{"$f":"+O10+'I-Inputs'!$B$31","v":"2018-07-26"},{"$f":"+P10+'I-Inputs'!$B$31","v":"2018-08-02"},{"$f":"+Q10+'I-Inputs'!$B$31","v":"2018-08-09"},{"$f":"+R10+'I-Inputs'!$B$31","v":"2018-08-16"},{"$f":"+S10+'I-Inputs'!$B$31","v":"2018-08-23"},{"$f":"+T10+'I-Inputs'!$B$31","v":"2018-08-30"},{"$f":"+U10+'I-Inputs'!$B$31","v":"2018-09-06"},{"$f":"+V10+'I-Inputs'!$B$31","v":"2018-09-13"},{"$f":"+W10+'I-Inputs'!$B$31","v":"2018-09-20"},{"$f":"+X10+'I-Inputs'!$B$31","v":"2018-09-27"},{"$f":"+Y10+'I-Inputs'!$B$31","v":"2018-10-04"},{"$f":"+Z10+'I-Inputs'!$B$31","v":"2018-10-11"},{"$f":"+AA10+'I-Inputs'!$B$31","v":"2018-10-18"},{"$f":"+AB10+'I-Inputs'!$B$31","v":"2018-10-25"},{"$f":"+AC10+'I-Inputs'!$B$31","v":"2018-11-01"},{"$f":"+AD10+'I-Inputs'!$B$31","v":"2018-11-08"},{"$f":"+AE10+'I-Inputs'!$B$31","v":"2018-11-15"},{"$f":"+AF10+'I-Inputs'!$B$31","v":"2018-11-22"},{"$f":"+AG10+'I-Inputs'!$B$31","v":"2018-11-29"},{"$f":"+AH10+'I-Inputs'!$B$31","v":"2018-12-06"},{"$f":"+AI10+'I-Inputs'!$B$31","v":"2018-12-13"},{"$f":"+AJ10+'I-Inputs'!$B$31","v":"2018-12-20"},{"$f":"+AK10+'I-Inputs'!$B$31","v":"2018-12-27"},{"$f":"+AL10+'I-Inputs'!$B$31","v":"2019-01-03"},{"$f":"+AM10+'I-Inputs'!$B$31","v":"2019-01-10"},{"$f":"+AN10+'I-Inputs'!$B$31","v":"2019-01-17"},{"$f":"+AO10+'I-Inputs'!$B$31","v":"2019-01-24"},{"$f":"+AP10+'I-Inputs'!$B$31","v":"2019-01-31"},{"$f":"+AQ10+'I-Inputs'!$B$31","v":"2019-02-07"},{"$f":"+AR10+'I-Inputs'!$B$31","v":"2019-02-14"},{"$f":"+AS10+'I-Inputs'!$B$31","v":"2019-02-21"},{"$f":"+AT10+'I-Inputs'!$B$31","v":"2019-02-28"},{"$f":"+AU10+'I-Inputs'!$B$31","v":"2019-03-07"},{"$f":"+AV10+'I-Inputs'!$B$31","v":"2019-03-14"},{"$f":"+AW10+'I-Inputs'!$B$31","v":"2019-03-21"},{"$f":"+AX10+'I-Inputs'!$B$31","v":"2019-03-28"},{"$f":"+AY10+'I-Inputs'!$B$31","v":"2019-04-04"},{"$f":"+AZ10+'I-Inputs'!$B$31","v":"2019-04-11"},{"$f":"+BA10+'I-Inputs'!$B$31","v":"2019-04-18"},{"$f":"+BB10+'I-Inputs'!$B$31","v":"2019-04-25"},{"$f":"+BC10+'I-Inputs'!$B$31","v":"2019-05-02"},{"$f":"+BD10+'I-Inputs'!$B$31","v":"2019-05-09"},{"$f":"+BE10+'I-Inputs'!$B$31","v":"2019-05-16"},{"$f":"+BF10+'I-Inputs'!$B$31","v":"2019-05-23"},{"$f":"+BG10+'I-Inputs'!$B$31","v":"2019-05-30"},{"$f":"+BH10+'I-Inputs'!$B$31","v":"2019-06-06"},{"$f":"+BI10+'I-Inputs'!$B$31","v":"2019-06-13"},{"$f":"+BJ10+'I-Inputs'!$B$31","v":"2019-06-20"},{"$f":"+BK10+'I-Inputs'!$B$31","v":"2019-06-27"},{"$f":"+BL10+'I-Inputs'!$B$31","v":"2019-07-04"},{"$f":"+BM10+'I-Inputs'!$B$31","v":"2019-07-11"},{"$f":"+BN10+'I-Inputs'!$B$31","v":"2019-07-18"},{"$f":"+BO10+'I-Inputs'!$B$31","v":"2019-07-25"},{"$f":"+BP10+'I-Inputs'!$B$31","v":"2019-08-01"},{"$f":"+BQ10+'I-Inputs'!$B$31","v":"2019-08-08"},{"$f":"+BR10+'I-Inputs'!$B$31","v":"2019-08-15"},{"$f":"+BS10+'I-Inputs'!$B$31","v":"2019-08-22"},{"$f":"+BT10+'I-Inputs'!$B$31","v":"2019-08-29"},{"$f":"+BU10+'I-Inputs'!$B$31","v":"2019-09-05"},{"$f":"+BV10+'I-Inputs'!$B$31","v":"2019-09-12"},{"$f":"+BW10+'I-Inputs'!$B$31","v":"2019-09-19"},{"$f":"+BX10+'I-Inputs'!$B$31","v":"2019-09-26"},{"$f":"+BY10+'I-Inputs'!$B$31","v":"2019-10-03"},{"$f":"+BZ10+'I-Inputs'!$B$31","v":"2019-10-10"},{"$f":"+CA10+'I-Inputs'!$B$31","v":"2019-10-17"},{"$f":"+CB10+'I-Inputs'!$B$31","v":"2019-10-24"},{"$f":"+CC10+'I-Inputs'!$B$31","v":"2019-10-31"},{"$f":"+CD10+'I-Inputs'!$B$31","v":"2019-11-07"},{"$f":"+CE10+'I-Inputs'!$B$31","v":"2019-11-14"},{"$f":"+CF10+'I-Inputs'!$B$31","v":"2019-11-21"},{"$f":"+CG10+'I-Inputs'!$B$31","v":"2019-11-28"},{"$f":"+CH10+'I-Inputs'!$B$31","v":"2019-12-05"},{"$f":"+CI10+'I-Inputs'!$B$31","v":"2019-12-12"},{"$f":"+CJ10+'I-Inputs'!$B$31","v":"2019-12-19"},{"$f":"+CK10+'I-Inputs'!$B$31","v":"2019-12-26"},{"$f":"+CL10+'I-Inputs'!$B$31","v":"2020-01-02"},{"$f":"+CM10+'I-Inputs'!$B$31","v":"2020-01-09"},{"$f":"+CN10+'I-Inputs'!$B$31","v":"2020-01-16"},{"$f":"+CO10+'I-Inputs'!$B$31","v":"2020-01-23"},{"$f":"+CP10+'I-Inputs'!$B$31","v":"2020-01-30"},{"$f":"+CQ10+'I-Inputs'!$B$31","v":"2020-02-06"},{"$f":"+CR10+'I-Inputs'!$B$31","v":"2020-02-13"},{"$f":"+CS10+'I-Inputs'!$B$31","v":"2020-02-20"},{"$f":"+CT10+'I-Inputs'!$B$31","v":"2020-02-27"},{"$f":"+CU10+'I-Inputs'!$B$31","v":"2020-03-05"},{"$f":"+CV10+'I-Inputs'!$B$31","v":"2020-03-12"},{"$f":"+CW10+'I-Inputs'!$B$31","v":"2020-03-19"},{"$f":"+CX10+'I-Inputs'!$B$31","v":"2020-03-26"},{"$f":"+CY10+'I-Inputs'!$B$31","v":"2020-04-02"},{"$f":"+CZ10+'I-Inputs'!$B$31","v":"2020-04-09"},{"$f":"+DA10+'I-Inputs'!$B$31","v":"2020-04-16"},{"$f":"+DB10+'I-Inputs'!$B$31","v":"2020-04-23"},{"$f":"+DC10+'I-Inputs'!$B$31","v":"2020-04-30"},{"$f":"+DD10+'I-Inputs'!$B$31","v":"2020-05-07"},{"$f":"+DE10+'I-Inputs'!$B$31","v":"2020-05-14"},{"$f":"+DF10+'I-Inputs'!$B$31","v":"2020-05-21"},{"$f":"+DG10+'I-Inputs'!$B$31","v":"2020-05-28"},{"$f":"+DH10+'I-Inputs'!$B$31","v":"2020-06-04"},{"$f":"+DI10+'I-Inputs'!$B$31","v":"2020-06-11"},{"$f":"+DJ10+'I-Inputs'!$B$31","v":"2020-06-18"},{"$f":"+DK10+'I-Inputs'!$B$31","v":"2020-06-25"},{"$f":"+DL10+'I-Inputs'!$B$31","v":"2020-07-02"},{"$f":"+DM10+'I-Inputs'!$B$31","v":"2020-07-09"},{"$f":"+DN10+'I-Inputs'!$B$31","v":"2020-07-16"},{"$f":"+DO10+'I-Inputs'!$B$31","v":"2020-07-23"},{"$f":"+DP10+'I-Inputs'!$B$31","v":"2020-07-30"},{"$f":"+DQ10+'I-Inputs'!$B$31","v":"2020-08-06"},{"$f":"+DR10+'I-Inputs'!$B$31","v":"2020-08-13"},{"$f":"+DS10+'I-Inputs'!$B$31","v":"2020-08-20"},{"$f":"+DT10+'I-Inputs'!$B$31","v":"2020-08-27"},{"$f":"+DU10+'I-Inputs'!$B$31","v":"2020-09-03"},{"$f":"+DV10+'I-Inputs'!$B$31","v":"2020-09-10"},{"$f":"+DW10+'I-Inputs'!$B$31","v":"2020-09-17"},{"$f":"+DX10+'I-Inputs'!$B$31","v":"2020-09-24"},{"$f":"+DY10+'I-Inputs'!$B$31","v":"2020-10-01"},{"$f":"+DZ10+'I-Inputs'!$B$31","v":"2020-10-08"},{"$f":"+EA10+'I-Inputs'!$B$31","v":"2020-10-15"},{"$f":"+EB10+'I-Inputs'!$B$31","v":"2020-10-22"},{"$f":"+EC10+'I-Inputs'!$B$31","v":"2020-10-29"},{"$f":"+ED10+'I-Inputs'!$B$31","v":"2020-11-05"},{"$f":"+EE10+'I-Inputs'!$B$31","v":"2020-11-12"}]
[1,{"$f":"+'A-Assignment Worksheet'!J11","v":0},{"$f":"+'A-Assignment Worksheet'!K11","v":0},{"$f":"+'A-Assignment Worksheet'!G11","v":0},{"$f":"+'A-Assignment Worksheet'!H11","v":0},{"$f":"+'A-Assignment Worksheet'!I11","v":0}]
[2,{"$f":"+'A-Assignment Worksheet'!J12","v":0},{"$f":"+'A-Assignment Worksheet'!K12","v":0},{"$f":"+'A-Assignment Worksheet'!G12","v":0},{"$f":"+'A-Assignment Worksheet'!H12","v":0},{"$f":"+'A-Assignment Worksheet'!I12","v":"00:00:00"}]
[3,{"$f":"+'A-Assignment Worksheet'!J13","v":0},{"$f":"+'A-Assignment Worksheet'!K13","v":0},{"$f":"+'A-Assignment Worksheet'!G13","v":0},{"$f":"+'A-Assignment Worksheet'!H13","v":0},{"$f":"+'A-Assignment Worksheet'!I13","v":"00:00:00"}]
[4,{"$f":"+'A-Assignment Worksheet'!J14","v":0},{"$f":"+'A-Assignment Worksheet'!K14","v":0},{"$f":"+'A-Assignment Worksheet'!G14","v":0},{"$f":"+'A-Assignment Worksheet'!H14","v":0},{"$f":"+'A-Assignment Worksheet'!I14","v":"00:00:00"}]
[5,{"$f":"+'A-Assignment Worksheet'!J15","v":0},{"$f":"+'A-Assignment Worksheet'!K15","v":0},{"$f":"+'A-Assignment Worksheet'!G15","v":0},{"$f":"+'A-Assignment Worksheet'!H15","v":0},{"$f":"+'A-Assignment Worksheet'!I15","v":"00:00:00"}]
[6,{"$f":"+'A-Assignment Worksheet'!J16","v":0},{"$f":"+'A-Assignment Worksheet'!K16","v":0},{"$f":"+'A-Assignment Worksheet'!G16","v":0},{"$f":"+'A-Assignment Worksheet'!H16","v":0},{"$f":"+'A-Assignment Worksheet'!I16","v":"00:00:00"}]
[7,{"$f":"+'A-Assignment Worksheet'!J17","v":0},{"$f":"+'A-Assignment Worksheet'!K17","v":0},{"$f":"+'A-Assignment Worksheet'!G17","v":0},{"$f":"+'A-Assignment Worksheet'!H17","v":0},{"$f":"+'A-Assignment Worksheet'!I17","v":"00:00:00"}]
[8,{"$f":"+'A-Assignment Worksheet'!J18","v":0},{"$f":"+'A-Assignment Worksheet'!K18","v":0},{"$f":"+'A-Assignment Worksheet'!G18","v":0},{"$f":"+'A-Assignment Worksheet'!H18","v":0},{"$f":"+'A-Assignment Worksheet'!I18","v":"00:00:00"}]
[9,{"$f":"+'A-Assignment Worksheet'!J19","v":0},{"$f":"+'A-Assignment Worksheet'!K19","v":0},{"$f":"+'A-Assignment Worksheet'!G19","v":0},{"$f":"+'A-Assignment Worksheet'!H19","v":0},{"$f":"+'A-Assignment Worksheet'!I19","v":"00:00:00"}]
[10,{"$f":"+'A-Assignment Worksheet'!J20","v":0},{"$f":"+'A-Assignment Worksheet'!K20","v":0},{"$f":"+'A-Assignment Worksheet'!G20","v":0},{"$f":"+'A-Assignment Worksheet'!H20","v":0},{"$f":"+'A-Assignment Worksheet'!I20","v":"00:00:00"}]
[11,{"$f":"+'A-Assignment Worksheet'!J21","v":0},{"$f":"+'A-Assignment Worksheet'!K21","v":0},{"$f":"+'A-Assignment Worksheet'!G21","v":0},{"$f":"+'A-Assignment Worksheet'!H21","v":0},{"$f":"+'A-Assignment Worksheet'!I21","v":"00:00:00"}]
[12,{"$f":"+'A-Assignment Worksheet'!J22","v":0},{"$f":"+'A-Assignment Worksheet'!K22","v":0},{"$f":"+'A-Assignment Worksheet'!G22","v":0},{"$f":"+'A-Assignment Worksheet'!H22","v":0},{"$f":"+'A-Assignment Worksheet'!I22","v":"00:00:00"}]
[13,{"$f":"+'A-Assignment Worksheet'!J23","v":0},{"$f":"+'A-Assignment Worksheet'!K23","v":0},{"$f":"+'A-Assignment Worksheet'!G23","v":0},{"$f":"+'A-Assignment Worksheet'!H23","v":0},{"$f":"+'A-Assignment Worksheet'!I23","v":"00:00:00"}]
[14,{"$f":"+'A-Assignment Worksheet'!J24","v":0},{"$f":"+'A-Assignment Worksheet'!K24","v":0},{"$f":"+'A-Assignment Worksheet'!G24","v":0},{"$f":"+'A-Assignment Worksheet'!H24","v":0},{"$f":"+'A-Assignment Worksheet'!I24","v":"00:00:00"}]
[15,{"$f":"+'A-Assignment Worksheet'!J25","v":0},{"$f":"+'A-Assignment Worksheet'!K25","v":0},{"$f":"+'A-Assignment Worksheet'!G25","v":0},{"$f":"+'A-Assignment Worksheet'!H25","v":0},{"$f":"+'A-Assignment Worksheet'!I25","v":"00:00:00"}]
[16,{"$f":"+'A-Assignment Worksheet'!J26","v":0},{"$f":"+'A-Assignment Worksheet'!K26","v":0},{"$f":"+'A-Assignment Worksheet'!G26","v":0},{"$f":"+'A-Assignment Worksheet'!H26","v":0},{"$f":"+'A-Assignment Worksheet'!I26","v":"00:00:00"}]
[17,{"$f":"+'A-Assignment Worksheet'!J27","v":0},{"$f":"+'A-Assignment Worksheet'!K27","v":0},{"$f":"+'A-Assignment Worksheet'!G27","v":0},{"$f":"+'A-Assignment Worksheet'!H27","v":0},{"$f":"+'A-Assignment Worksheet'!I27","v":"00:00:00"}]
[18,{"$f":"+'A-Assignment Worksheet'!J28","v":0},{"$f":"+'A-Assignment Worksheet'!K28","v":0},{"$f":"+'A-Assignment Worksheet'!G28","v":0},{"$f":"+'A-Assignment Worksheet'!H28","v":0},{"$f":"+'A-Assignment Worksheet'!I28","v":"00:00:00"}]
[19,{"$f":"+'A-Assignment Worksheet'!J29","v":0},{"$f":"+'A-Assignment Worksheet'!K29","v":0},{"$f":"+'A-Assignment Worksheet'!G29","v":0},{"$f":"+'A-Assignment Worksheet'!H29","v":0},{"$f":"+'A-Assignment Worksheet'!I29","v":"00:00:00"}]
[20,{"$f":"+'A-Assignment Worksheet'!J30","v":0},{"$f":"+'A-Assignment Worksheet'!K30","v":0},{"$f":"+'A-Assignment Worksheet'!G30","v":0},{"$f":"+'A-Assignment Worksheet'!H30","v":0},{"$f":"+'A-Assignment Worksheet'!I30","v":"00:00:00"}]
[21,{"$f":"+'A-Assignment Worksheet'!J31","v":0},{"$f":"+'A-Assignment Worksheet'!K31","v":0},{"$f":"+'A-Assignment Worksheet'!G31","v":0},{"$f":"+'A-Assignment Worksheet'!H31","v":0},{"$f":"+'A-Assignment Worksheet'!I31","v":"00:00:00"}]
[22,{"$f":"+'A-Assignment Worksheet'!J32","v":0},{"$f":"+'A-Assignment Worksheet'!K32","v":0},{"$f":"+'A-Assignment Worksheet'!G32","v":0},{"$f":"+'A-Assignment Worksheet'!H32","v":0},{"$f":"+'A-Assignment Worksheet'!I32","v":"00:00:00"}]
[23,{"$f":"+'A-Assignment Worksheet'!J33","v":0},{"$f":"+'A-Assignment Worksheet'!K33","v":0},{"$f":"+'A-Assignment Worksheet'!G33","v":0},{"$f":"+'A-Assignment Worksheet'!H33","v":0},{"$f":"+'A-Assignment Worksheet'!I33","v":"00:00:00"}]
[24,{"$f":"+'A-Assignment Worksheet'!J34","v":0},{"$f":"+'A-Assignment Worksheet'!K34","v":0},{"$f":"+'A-Assignment Worksheet'!G34","v":0},{"$f":"+'A-Assignment Worksheet'!H34","v":0},{"$f":"+'A-Assignment Worksheet'!I34","v":"00:00:00"}]
[25,{"$f":"+'A-Assignment Worksheet'!J35","v":0},{"$f":"+'A-Assignment Worksheet'!K35","v":0},{"$f":"+'A-Assignment Worksheet'!G35","v":0},{"$f":"+'A-Assignment Worksheet'!H35","v":0},{"$f":"+'A-Assignment Worksheet'!I35","v":"00:00:00"}]

{"sheet":"SDA Instructions","index":9,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["Instructions for RCR Program"]
["SDA Instructions:"]
["Steps","Instructions","Responsibility","Notes"]
[1,"Salesman and SDA team will jointly decide when it is time to send the PHASE 1 materials for the RCR Program.","Sales Team and Margaret","Send Cover Sheet, Program Details"]
[2,"Follow normal SDA Dealer application procedures for any NEW dealers.","Sales Team and Margaret","Use Same Dealer Application Process"]
[3,"If Dealer has never completed an RCR batch previously, they must complete a new Dealer Agreement and associated Addendum.  Documents to be sent to dealer (via email) should include:\n- RCR Cover Letter\n- RCR Dealer Agreement\n- Addendum A Updatede with Negotiated Terms from Loan Committee\n- Assignment Agreement\n- Irrevocable Power of Attorney\n- Guaranty and Indemnity Agreement\n- Purchase Affirmation with Updated Batch Number\n- Certificate of Authority\n- DMS and GPS Contract Addendum\n- Title Escrow Agreement\n","Margaret, Anddrea, or Kevin","Templates are located in RCR Folder in Shared Drive"]
[4,"If Dealer is a returning RCR customer, only send the RCR Electronic Worksheet as described below.","SDA Team","Send \"RCR Assignment Worksheet: from RCR Folder on Shared Drive."]
[5,"When appropriate, send the RCR Electronic Worksheet and ask Dealer to complete the Assignment Worksheet Tab.  Verify that all other tabs are hidden.","SDA Team","Send \"RCR Assignment Worksheet: from RCR Folder on Shared Drive."]
[6,"Dealer can contact either Sales Team or Margaret, Andrea, or Kevin for assistance.","Sales Team and Margaret"]
[7,"Dealer should send completed worksheet to Cash@sdainc.net.","Dealer","Margaret, Kevin and Alecia all receive this email.   Only Margaret will manage unless out of the office."]
[8,"SDA to acknowledge receipt of worksheet and Thank Dealer for selecting SDA.","Margaret, Andrea, or Kevin","Simple Email"]
[]
[]
[]
[]
[]
["SDA Instructions:"]
["Steps","Instructions","Responsibility","Notes"]
[1,"SDA to review Assignment Worksheet Tab for complete and accurate information.   Any missing data or incorrect information should be clairified with dealer by SDA Team.","Margaret, Andrea, or Kevin"]
[2,"Once Assignment Worksheet is completed and accurate, SDA Team to update Inputs Tab with the relevant Dealer terms per the Dealer Agreement.  Any negotiated terms that are different from the Standard RCR terms should be noted in ACT.","Margaret, Andrea, or Kevin"]
[3,"All NADA \"Average Trade-In\" values for the appropriate region should be entered using Wayne Reaves solution.  Copy VIN from spreadsheet and enter in WR.  Enter NADA \"Average Trade-In\" Value to the NADA Values Tab.","Margaret, Andrea, or Kevin"]
[4,"Contact Dealer directly with any questions on VIN lookups, missing or inaccurate VINS, or clarifications on models. ","Margaret, Andrea, or Kevin"]
[5,"Review the Funding Analysis tab to make sure all values are correct, payments are adding up correctly and there are no missing values.","Margaret, Andrea, or Kevin"]
[6,"If all looks correct, print the reports required to send to the dealer - Funding Reports - by selcting \"Control-Shift-I\" at the same time.  Make sure the correct printer is selected in advance.","Margaret, Andrea, or Kevin"]
[7,"Compile with the cover letter and send to the dealer.","Margaret, Andrea, or Kevin"]
[]
[]
[]
[]
["Print Macros"]
["Form","Instructions","Funding Reports","All Reports"]
[null,"Confirm that the Printer is set to the preferred printer prior to executing macros."]
["Assignment Worksheet","Press \"Control-Shift-A\" together.","Yes","Yes"]
["Input","Press \"Control-Shift-B\" together.",null,"Yes"]
["NADA Values","Press \"Control-Shift-C\" together.",null,"Yes"]
["Checklist","Press \"Control-Shift-D\" together.",null,"Yes"]
["Attachment to Assignment","Press \"Control-Shift-E\" together.","Yes","Yes"]
["Attachment Payments","Press \"Control-Shift-F\" together.","Yes","Yes"]
["Funding Analysis","Press \"Control-Shift-G\" together.",null,"Yes"]
["Payment Schedule","Press \"Control-Shift-L\" together.",null,"Yes"]
["Funding Reports","Press \"Control-Shift-P\" together.",null,"Yes"]
["All Reports","Press \"Control-Shift-J\" together.",null,"Yes"]
["Basis and Term Report","Press :Control-Shift-K\" together",null,"Yes"]
["UnHide All Tabs","Press \"Control-Shift-U\" together"]
["Hide All Tabs","Press \"Control-Shift-H\" Together"]
["Block Ticket","Press \"Control-Shift-M\" Together","Yes","Yes"]
["Payment Histories","Press \"Control-Shift-N\" Together"]
["Customer Swap","Press \"Control-Shift-O\" Together",null,"Yes"]
["Internal Payment Schedule","Press \"Control-Shift-Q\" Together","Yes","Yes"]

{"sheet":"C-Stream Advance","index":10,"n_rows":45,"n_cols":30,"rows_kept":45,"cut":false,"hidden":true,"merged":[[8,12,8,13],[2,7,2,8],[3,7,3,8],[4,7,4,8],[5,7,5,8],[6,7,6,8],[8,11,9,11],[8,16,8,24],[2,19,2,20],[2,2,2,3],[3,2,3,3],[4,2,4,3],[7,10,7,12],[2,15,2,18],[8,8,8,10],[5,2,5,3],[7,2,7,3],[7,15,7,18],[7,23,7,24],[3,15,3,18],[4,15,4,18],[5,15,5,18],[6,2,6,3]]}
["SDA STREAM ADVANCE REQUEST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SDA Payments in Stream Analysis"]
[]
[null,"Dealer Name:",{"$f":"+'A-Assignment Worksheet'!D3","v":0},null,null,null,"Batch #:",{"$f":"+'I-Inputs'!B7","v":1},null,null,null,null,null,null,null,"Dealership Name:",null,null,null,{"$f":"+'A-Assignment Worksheet'!D3","v":0},null,"Payment Type","Multiplier","Days in Period","Payments in Stream"]
[null,"Address:",{"$f":"+'A-Assignment Worksheet'!D4","v":0},null,null,null,"City:",{"$f":"+'A-Assignment Worksheet'!G4","v":0},null,null,null,null,null,null,null,"Days in Stream;",null,null,null,{"$f":"+'I-Inputs'!B21","v":365},null,"W",4.3330000000000002,7,{"$f":"ROUND(+W4*$T$5,0)","v":52}]
[null,"State:",{"$f":"+'A-Assignment Worksheet'!D5","v":0},null,null,null,"ZIP:",{"$f":"+'A-Assignment Worksheet'!G5","v":0},null,null,null,null,null,null,null,"Months in Stream;",null,null,null,{"$f":"+'I-Inputs'!B16","v":12},null,"B",2.1659999999999999,14,{"$f":"ROUND(+W5*$T$5,0)","v":26}]
[null,"Phone:",{"$f":"+'A-Assignment Worksheet'!D6","v":0},null,null,null,"Email:",{"$f":"+'A-Assignment Worksheet'!G6","v":0},null,null,"Date:",{"$f":"+'A-Assignment Worksheet'!G7","v":"00:00:00"},null,null,null,"Batch Payment Frequency:",null,null,null,"W",null,"M",1,30,12]
[null,"Fax:",{"$f":"+'A-Assignment Worksheet'!D7","v":0},null,null,null,"Batch ID:",{"$f":"+'I-Inputs'!B7","v":1},null,null,null,null,null,null,null,null,null,null,"Payments in Stream:",{"$f":"+$T$5*(VLOOKUP($T$6,V4:X7,2,FALSE))","v":51.996000000000002},null,"S",2,15,24]
[]
[null,null,null,null,null,null,null,null,"Payments in Stream",null,null,"Stream Advance Amount",null,null,null,null,"PAYMENTS IN STREAM ANALYSIS"]
["EX","Last Name","First Name","Year","Make","Principal Balance","Payment","Payments Year","No.","Amount","Last Payment",null,"Capital Ratio","Documents Compliant",null,null,"Next Payment Date","Payment Type","Multiplier","Payments in Stream","Max Days in Stream","Days Account is in Stream","Days Between Payments","Payments in Stream","Weekly Payments"]
[1,{"$f":"+'A-Assignment Worksheet'!J11","v":0},{"$f":"+'A-Assignment Worksheet'!K11","v":0},{"$f":"+'A-Assignment Worksheet'!G11","v":0},{"$f":"+'A-Assignment Worksheet'!H11","v":0},{"$f":"+'A-Assignment Worksheet'!L11","v":0},{"$f":"+'A-Assignment Worksheet'!E11","v":0},{"$f":"IF(F11>0,(IF('A-Assignment Worksheet'!B11=\"M\",12,(IF('A-Assignment Worksheet'!B11=\"W\",52,(IF('A-Assignment Worksheet'!B11=\"B\",26,IF('A-Assignment Worksheet'!B11=\"S\",24))))))),\"\")","v":""},{"$f":"IF(F11>0,(VLOOKUP($R11,$V$4:$Y$7,4,TRUE)),\"\")","v":""},{"$f":"IF(F11>0,(+I11*G11),\"\")","v":""},{"$f":"IF(F11>0,(+'A-Assignment Worksheet'!F11+'C-Stream Advance'!V11),\"\")","v":""},{"$f":"IF(F11>0,(+J11*'I-Inputs'!$B$17),\"\")","v":""},{"$f":"IF(F11>0,(+F11/L11),\"\")","v":""},{"$f":"IF(F11>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,1,{"$f":"IF(F11>0,+'A-Assignment Worksheet'!F11,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B11","v":0},{"$f":"IF(F11>0,(VLOOKUP($R11,$V$4:$W$7,2,TRUE)),\"\")","v":""},{"$f":"IF(F11>0,(ROUND(+$T$5*S11,0)),\"\")","v":""},{"$f":"IF(F11>0,+$T$4,\"\")","v":""},{"$f":"IF(F11>0,(MIN(U11,(DATEDIF('A-Assignment Worksheet'!F11,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},{"$f":"IF(F11>0,(VLOOKUP(R11,$V$4:$X$7,3,TRUE)),\"\")","v":""},{"$f":"IF(F11>0,(+ROUND(+V11/W11,0)),\"\")","v":""},{"$f":"IF(F11>0,(+V11/7),\"\")","v":""},null,{"$f":"IF(F11>0,(MAX(Q11,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$f":"DATEDIF(Q11,AB11,\"D\")","v":{"$error":"#VALUE!"}},{"$f":"+AC11/W11","v":{"$error":"#VALUE!"}}]
[2,{"$f":"+'A-Assignment Worksheet'!J12","v":0},{"$f":"+'A-Assignment Worksheet'!K12","v":0},{"$f":"+'A-Assignment Worksheet'!G12","v":0},{"$f":"+'A-Assignment Worksheet'!H12","v":0},{"$f":"+'A-Assignment Worksheet'!L12","v":0},{"$f":"+'A-Assignment Worksheet'!E12","v":0},{"$f":"IF(F12>0,(IF('A-Assignment Worksheet'!B12=\"M\",12,(IF('A-Assignment Worksheet'!B12=\"W\",52,(IF('A-Assignment Worksheet'!B12=\"B\",26,IF('A-Assignment Worksheet'!B12=\"S\",24))))))),\"\")","v":""},{"$f":"IF(F12>0,(VLOOKUP($R12,$V$4:$Y$7,4,TRUE)),\"\")","v":""},{"$f":"IF(F12>0,(+I12*G12),\"\")","v":""},{"$f":"IF(F12>0,(+'A-Assignment Worksheet'!F12+'C-Stream Advance'!V12),\"\")","v":""},{"$f":"IF(F12>0,(+J12*'I-Inputs'!$B$17),\"\")","v":""},{"$f":"IF(F12>0,(+F12/L12),\"\")","v":""},{"$f":"IF(F12>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,2,{"$f":"IF(F12>0,+'A-Assignment Worksheet'!F12,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B12","v":0},{"$f":"IF(F12>0,(VLOOKUP($R12,$V$4:$W$7,2,TRUE)),\"\")","v":""},{"$f":"IF(F12>0,(ROUND(+$T$5*S12,0)),\"\")","v":""},{"$f":"IF(F12>0,+$T$4,\"\")","v":""},{"$f":"IF(F12>0,(MIN(U12,(DATEDIF('A-Assignment Worksheet'!F12,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"",{"$f":"IF(F12>0,(+ROUND(+V12/W12,0)),\"\")","v":""},{"$f":"IF(F12>0,(+V12/7),\"\")","v":""},null,{"$f":"IF(F12>0,(MAX(Q12,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$f":"DATEDIF(Q12,AB12,\"D\")","v":{"$error":"#VALUE!"}},{"$f":"+AC12/W12","v":{"$error":"#VALUE!"}}]
[3,{"$f":"+'A-Assignment Worksheet'!J13","v":0},{"$f":"+'A-Assignment Worksheet'!K13","v":0},{"$f":"+'A-Assignment Worksheet'!G13","v":0},{"$f":"+'A-Assignment Worksheet'!H13","v":0},{"$f":"+'A-Assignment Worksheet'!L13","v":0},{"$f":"+'A-Assignment Worksheet'!E13","v":0},{"$f":"IF(F13>0,(IF('A-Assignment Worksheet'!B13=\"M\",12,(IF('A-Assignment Worksheet'!B13=\"W\",52,(IF('A-Assignment Worksheet'!B13=\"B\",26,IF('A-Assignment Worksheet'!B13=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F13>0,(+'A-Assignment Worksheet'!F13+'C-Stream Advance'!V13),\"\")","v":""},{"$f":"IF(F13>0,(+J13*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F13>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,3,{"$f":"IF(F13>0,+'A-Assignment Worksheet'!F13,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B13","v":0},"","","",{"$f":"IF(F13>0,(MIN(U13,(DATEDIF('A-Assignment Worksheet'!F13,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",null,{"$f":"IF(F13>0,(MAX(Q13,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,{"$f":"+'A-Assignment Worksheet'!J14","v":0},{"$f":"+'A-Assignment Worksheet'!K14","v":0},{"$f":"+'A-Assignment Worksheet'!G14","v":0},{"$f":"+'A-Assignment Worksheet'!H14","v":0},{"$f":"+'A-Assignment Worksheet'!L14","v":0},{"$f":"+'A-Assignment Worksheet'!E14","v":0},{"$f":"IF(F14>0,(IF('A-Assignment Worksheet'!B14=\"M\",12,(IF('A-Assignment Worksheet'!B14=\"W\",52,(IF('A-Assignment Worksheet'!B14=\"B\",26,IF('A-Assignment Worksheet'!B14=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F14>0,(+'A-Assignment Worksheet'!F14+'C-Stream Advance'!V14),\"\")","v":""},{"$f":"IF(F14>0,(+J14*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F14>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,4,{"$f":"IF(F14>0,+'A-Assignment Worksheet'!F14,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B14","v":0},"","","",{"$f":"IF(F14>0,(MIN(U14,(DATEDIF('A-Assignment Worksheet'!F14,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",1,{"$f":"IF(F14>0,(MAX(Q14,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,{"$f":"+'A-Assignment Worksheet'!J15","v":0},{"$f":"+'A-Assignment Worksheet'!K15","v":0},{"$f":"+'A-Assignment Worksheet'!G15","v":0},{"$f":"+'A-Assignment Worksheet'!H15","v":0},{"$f":"+'A-Assignment Worksheet'!L15","v":0},{"$f":"+'A-Assignment Worksheet'!E15","v":0},{"$f":"IF(F15>0,(IF('A-Assignment Worksheet'!B15=\"M\",12,(IF('A-Assignment Worksheet'!B15=\"W\",52,(IF('A-Assignment Worksheet'!B15=\"B\",26,IF('A-Assignment Worksheet'!B15=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F15>0,(+'A-Assignment Worksheet'!F15+'C-Stream Advance'!V15),\"\")","v":""},{"$f":"IF(F15>0,(+J15*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F15>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,5,{"$f":"IF(F15>0,+'A-Assignment Worksheet'!F15,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B15","v":0},"","","",{"$f":"IF(F15>0,(MIN(U15,(DATEDIF('A-Assignment Worksheet'!F15,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",2,{"$f":"IF(F15>0,(MAX(Q15,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,{"$f":"+'A-Assignment Worksheet'!J16","v":0},{"$f":"+'A-Assignment Worksheet'!K16","v":0},{"$f":"+'A-Assignment Worksheet'!G16","v":0},{"$f":"+'A-Assignment Worksheet'!H16","v":0},{"$f":"+'A-Assignment Worksheet'!L16","v":0},{"$f":"+'A-Assignment Worksheet'!E16","v":0},{"$f":"IF(F16>0,(IF('A-Assignment Worksheet'!B16=\"M\",12,(IF('A-Assignment Worksheet'!B16=\"W\",52,(IF('A-Assignment Worksheet'!B16=\"B\",26,IF('A-Assignment Worksheet'!B16=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F16>0,(+'A-Assignment Worksheet'!F16+'C-Stream Advance'!V16),\"\")","v":""},{"$f":"IF(F16>0,(+J16*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F16>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,6,{"$f":"IF(F16>0,+'A-Assignment Worksheet'!F16,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B16","v":0},"","","",{"$f":"IF(F16>0,(MIN(U16,(DATEDIF('A-Assignment Worksheet'!F16,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",3,{"$f":"IF(F16>0,(MAX(Q16,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[7,{"$f":"+'A-Assignment Worksheet'!J17","v":0},{"$f":"+'A-Assignment Worksheet'!K17","v":0},{"$f":"+'A-Assignment Worksheet'!G17","v":0},{"$f":"+'A-Assignment Worksheet'!H17","v":0},{"$f":"+'A-Assignment Worksheet'!L17","v":0},{"$f":"+'A-Assignment Worksheet'!E17","v":0},{"$f":"IF(F17>0,(IF('A-Assignment Worksheet'!B17=\"M\",12,(IF('A-Assignment Worksheet'!B17=\"W\",52,(IF('A-Assignment Worksheet'!B17=\"B\",26,IF('A-Assignment Worksheet'!B17=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F17>0,(+'A-Assignment Worksheet'!F17+'C-Stream Advance'!V17),\"\")","v":""},{"$f":"IF(F17>0,(+J17*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F17>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,7,{"$f":"IF(F17>0,+'A-Assignment Worksheet'!F17,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B17","v":0},"","","",{"$f":"IF(F17>0,(MIN(U17,(DATEDIF('A-Assignment Worksheet'!F17,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",4,{"$f":"IF(F17>0,(MAX(Q17,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[8,{"$f":"+'A-Assignment Worksheet'!J18","v":0},{"$f":"+'A-Assignment Worksheet'!K18","v":0},{"$f":"+'A-Assignment Worksheet'!G18","v":0},{"$f":"+'A-Assignment Worksheet'!H18","v":0},{"$f":"+'A-Assignment Worksheet'!L18","v":0},{"$f":"+'A-Assignment Worksheet'!E18","v":0},{"$f":"IF(F18>0,(IF('A-Assignment Worksheet'!B18=\"M\",12,(IF('A-Assignment Worksheet'!B18=\"W\",52,(IF('A-Assignment Worksheet'!B18=\"B\",26,IF('A-Assignment Worksheet'!B18=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F18>0,(+'A-Assignment Worksheet'!F18+'C-Stream Advance'!V18),\"\")","v":""},{"$f":"IF(F18>0,(+J18*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F18>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,8,{"$f":"IF(F18>0,+'A-Assignment Worksheet'!F18,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B18","v":0},"","","",{"$f":"IF(F18>0,(MIN(U18,(DATEDIF('A-Assignment Worksheet'!F18,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",5,{"$f":"IF(F18>0,(MAX(Q18,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[9,{"$f":"+'A-Assignment Worksheet'!J19","v":0},{"$f":"+'A-Assignment Worksheet'!K19","v":0},{"$f":"+'A-Assignment Worksheet'!G19","v":0},{"$f":"+'A-Assignment Worksheet'!H19","v":0},{"$f":"+'A-Assignment Worksheet'!L19","v":0},{"$f":"+'A-Assignment Worksheet'!E19","v":0},{"$f":"IF(F19>0,(IF('A-Assignment Worksheet'!B19=\"M\",12,(IF('A-Assignment Worksheet'!B19=\"W\",52,(IF('A-Assignment Worksheet'!B19=\"B\",26,IF('A-Assignment Worksheet'!B19=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F19>0,(+'A-Assignment Worksheet'!F19+'C-Stream Advance'!V19),\"\")","v":""},{"$f":"IF(F19>0,(+J19*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F19>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,9,{"$f":"IF(F19>0,+'A-Assignment Worksheet'!F19,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B19","v":0},"","","",{"$f":"IF(F19>0,(MIN(U19,(DATEDIF('A-Assignment Worksheet'!F19,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",6,{"$f":"IF(F19>0,(MAX(Q19,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[10,{"$f":"+'A-Assignment Worksheet'!J20","v":0},{"$f":"+'A-Assignment Worksheet'!K20","v":0},{"$f":"+'A-Assignment Worksheet'!G20","v":0},{"$f":"+'A-Assignment Worksheet'!H20","v":0},{"$f":"+'A-Assignment Worksheet'!L20","v":0},{"$f":"+'A-Assignment Worksheet'!E20","v":0},{"$f":"IF(F20>0,(IF('A-Assignment Worksheet'!B20=\"M\",12,(IF('A-Assignment Worksheet'!B20=\"W\",52,(IF('A-Assignment Worksheet'!B20=\"B\",26,IF('A-Assignment Worksheet'!B20=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F20>0,(+'A-Assignment Worksheet'!F20+'C-Stream Advance'!V20),\"\")","v":""},{"$f":"IF(F20>0,(+J20*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F20>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,10,{"$f":"IF(F20>0,+'A-Assignment Worksheet'!F20,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B20","v":0},"","","",{"$f":"IF(F20>0,(MIN(U20,(DATEDIF('A-Assignment Worksheet'!F20,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",7,{"$f":"IF(F20>0,(MAX(Q20,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[11,{"$f":"+'A-Assignment Worksheet'!J21","v":0},{"$f":"+'A-Assignment Worksheet'!K21","v":0},{"$f":"+'A-Assignment Worksheet'!G21","v":0},{"$f":"+'A-Assignment Worksheet'!H21","v":0},{"$f":"+'A-Assignment Worksheet'!L21","v":0},{"$f":"+'A-Assignment Worksheet'!E21","v":0},{"$f":"IF(F21>0,(IF('A-Assignment Worksheet'!B21=\"M\",12,(IF('A-Assignment Worksheet'!B21=\"W\",52,(IF('A-Assignment Worksheet'!B21=\"B\",26,IF('A-Assignment Worksheet'!B21=\"S\",24))))))),\"\")","v":""},{"$f":"IF(F21>0,+X21,\"\")","v":""},"",{"$f":"IF(F21>0,(+'A-Assignment Worksheet'!F21+'C-Stream Advance'!V21),\"\")","v":""},{"$f":"IF(F21>0,(+J21*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F21>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,11,{"$f":"IF(F21>0,+'A-Assignment Worksheet'!F21,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B21","v":0},"","","",{"$f":"IF(F21>0,(MIN(U21,(DATEDIF('A-Assignment Worksheet'!F21,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",8,{"$f":"IF(F21>0,(MAX(Q21,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[12,{"$f":"+'A-Assignment Worksheet'!J22","v":0},{"$f":"+'A-Assignment Worksheet'!K22","v":0},{"$f":"+'A-Assignment Worksheet'!G22","v":0},{"$f":"+'A-Assignment Worksheet'!H22","v":0},{"$f":"+'A-Assignment Worksheet'!L22","v":0},{"$f":"+'A-Assignment Worksheet'!E22","v":0},{"$f":"IF(F22>0,(IF('A-Assignment Worksheet'!B22=\"M\",12,(IF('A-Assignment Worksheet'!B22=\"W\",52,(IF('A-Assignment Worksheet'!B22=\"B\",26,IF('A-Assignment Worksheet'!B22=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F22>0,(+'A-Assignment Worksheet'!F22+'C-Stream Advance'!V22),\"\")","v":""},{"$f":"IF(F22>0,(+J22*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F22>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,12,{"$f":"IF(F22>0,+'A-Assignment Worksheet'!F22,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B22","v":0},"","","",{"$f":"IF(F22>0,(MIN(U22,(DATEDIF('A-Assignment Worksheet'!F22,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",9,{"$f":"IF(F22>0,(MAX(Q22,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[13,{"$f":"+'A-Assignment Worksheet'!J23","v":0},{"$f":"+'A-Assignment Worksheet'!K23","v":0},{"$f":"+'A-Assignment Worksheet'!G23","v":0},{"$f":"+'A-Assignment Worksheet'!H23","v":0},{"$f":"+'A-Assignment Worksheet'!L23","v":0},{"$f":"+'A-Assignment Worksheet'!E23","v":0},{"$f":"IF(F23>0,(IF('A-Assignment Worksheet'!B23=\"M\",12,(IF('A-Assignment Worksheet'!B23=\"W\",52,(IF('A-Assignment Worksheet'!B23=\"B\",26,IF('A-Assignment Worksheet'!B23=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F23>0,(+'A-Assignment Worksheet'!F23+'C-Stream Advance'!V23),\"\")","v":""},{"$f":"IF(F23>0,(+J23*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F23>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,13,{"$f":"IF(F23>0,+'A-Assignment Worksheet'!F23,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B23","v":0},"","","",{"$f":"IF(F23>0,(MIN(U23,(DATEDIF('A-Assignment Worksheet'!F23,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",10,{"$f":"IF(F23>0,(MAX(Q23,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"}]
[14,{"$f":"+'A-Assignment Worksheet'!J24","v":0},{"$f":"+'A-Assignment Worksheet'!K24","v":0},{"$f":"+'A-Assignment Worksheet'!G24","v":0},{"$f":"+'A-Assignment Worksheet'!H24","v":0},{"$f":"+'A-Assignment Worksheet'!L24","v":0},{"$f":"+'A-Assignment Worksheet'!E24","v":0},{"$f":"IF(F24>0,(IF('A-Assignment Worksheet'!B24=\"M\",12,(IF('A-Assignment Worksheet'!B24=\"W\",52,(IF('A-Assignment Worksheet'!B24=\"B\",26,IF('A-Assignment Worksheet'!B24=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F24>0,(+'A-Assignment Worksheet'!F24+'C-Stream Advance'!V24),\"\")","v":""},{"$f":"IF(F24>0,(+J24*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F24>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,14,{"$f":"IF(F24>0,+'A-Assignment Worksheet'!F24,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B24","v":0},"","","",{"$f":"IF(F24>0,(MIN(U24,(DATEDIF('A-Assignment Worksheet'!F24,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",11,{"$f":"IF(F24>0,(MAX(Q24,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"}]
[15,{"$f":"+'A-Assignment Worksheet'!J25","v":0},{"$f":"+'A-Assignment Worksheet'!K25","v":0},{"$f":"+'A-Assignment Worksheet'!G25","v":0},{"$f":"+'A-Assignment Worksheet'!H25","v":0},{"$f":"+'A-Assignment Worksheet'!L25","v":0},{"$f":"+'A-Assignment Worksheet'!E25","v":0},{"$f":"IF(F25>0,(IF('A-Assignment Worksheet'!B25=\"M\",12,(IF('A-Assignment Worksheet'!B25=\"W\",52,(IF('A-Assignment Worksheet'!B25=\"B\",26,IF('A-Assignment Worksheet'!B25=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F25>0,(+'A-Assignment Worksheet'!F25+'C-Stream Advance'!V25),\"\")","v":""},{"$f":"IF(F25>0,(+J25*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F25>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,15,{"$f":"IF(F25>0,+'A-Assignment Worksheet'!F25,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B25","v":0},"","","",{"$f":"IF(F25>0,(MIN(U25,(DATEDIF('A-Assignment Worksheet'!F25,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",12,{"$f":"IF(F25>0,(MAX(Q25,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"}]
[16,{"$f":"+'A-Assignment Worksheet'!J26","v":0},{"$f":"+'A-Assignment Worksheet'!K26","v":0},{"$f":"+'A-Assignment Worksheet'!G26","v":0},{"$f":"+'A-Assignment Worksheet'!H26","v":0},{"$f":"+'A-Assignment Worksheet'!L26","v":0},{"$f":"+'A-Assignment Worksheet'!E26","v":0},{"$f":"IF(F26>0,(IF('A-Assignment Worksheet'!B26=\"M\",12,(IF('A-Assignment Worksheet'!B26=\"W\",52,(IF('A-Assignment Worksheet'!B26=\"B\",26,IF('A-Assignment Worksheet'!B26=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F26>0,(+'A-Assignment Worksheet'!F26+'C-Stream Advance'!V26),\"\")","v":""},{"$f":"IF(F26>0,(+J26*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F26>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,16,{"$f":"IF(F26>0,+'A-Assignment Worksheet'!F26,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B26","v":0},"","","",{"$f":"IF(F26>0,(MIN(U26,(DATEDIF('A-Assignment Worksheet'!F26,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",13,{"$f":"IF(F26>0,(MAX(Q26,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"}]
[17,{"$f":"+'A-Assignment Worksheet'!J27","v":0},{"$f":"+'A-Assignment Worksheet'!K27","v":0},{"$f":"+'A-Assignment Worksheet'!G27","v":0},{"$f":"+'A-Assignment Worksheet'!H27","v":0},{"$f":"+'A-Assignment Worksheet'!L27","v":0},{"$f":"+'A-Assignment Worksheet'!E27","v":0},{"$f":"IF(F27>0,(IF('A-Assignment Worksheet'!B27=\"M\",12,(IF('A-Assignment Worksheet'!B27=\"W\",52,(IF('A-Assignment Worksheet'!B27=\"B\",26,IF('A-Assignment Worksheet'!B27=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F27>0,(+'A-Assignment Worksheet'!F27+'C-Stream Advance'!V27),\"\")","v":""},{"$f":"IF(F27>0,(+J27*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F27>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,17,{"$f":"IF(F27>0,+'A-Assignment Worksheet'!F27,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B27","v":0},"","","",{"$f":"IF(F27>0,(MIN(U27,(DATEDIF('A-Assignment Worksheet'!F27,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",14,{"$f":"IF(F27>0,(MAX(Q27,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"}]
[18,{"$f":"+'A-Assignment Worksheet'!J28","v":0},{"$f":"+'A-Assignment Worksheet'!K28","v":0},{"$f":"+'A-Assignment Worksheet'!G28","v":0},{"$f":"+'A-Assignment Worksheet'!H28","v":0},{"$f":"+'A-Assignment Worksheet'!L28","v":0},{"$f":"+'A-Assignment Worksheet'!E28","v":0},{"$f":"IF(F28>0,(IF('A-Assignment Worksheet'!B28=\"M\",12,(IF('A-Assignment Worksheet'!B28=\"W\",52,(IF('A-Assignment Worksheet'!B28=\"B\",26,IF('A-Assignment Worksheet'!B28=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F28>0,(+'A-Assignment Worksheet'!F28+'C-Stream Advance'!V28),\"\")","v":""},{"$f":"IF(F28>0,(+J28*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F28>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,18,{"$f":"IF(F28>0,+'A-Assignment Worksheet'!F28,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B28","v":0},"","","",{"$f":"IF(F28>0,(MIN(U28,(DATEDIF('A-Assignment Worksheet'!F28,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",null,{"$f":"IF(F28>0,(MAX(Q28,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"}]
[19,{"$f":"+'A-Assignment Worksheet'!J29","v":0},{"$f":"+'A-Assignment Worksheet'!K29","v":0},{"$f":"+'A-Assignment Worksheet'!G29","v":0},{"$f":"+'A-Assignment Worksheet'!H29","v":0},{"$f":"+'A-Assignment Worksheet'!L29","v":0},{"$f":"+'A-Assignment Worksheet'!E29","v":0},{"$f":"IF(F29>0,(IF('A-Assignment Worksheet'!B29=\"M\",12,(IF('A-Assignment Worksheet'!B29=\"W\",52,(IF('A-Assignment Worksheet'!B29=\"B\",26,IF('A-Assignment Worksheet'!B29=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F29>0,(+'A-Assignment Worksheet'!F29+'C-Stream Advance'!V29),\"\")","v":""},{"$f":"IF(F29>0,(+J29*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F29>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,19,{"$f":"IF(F29>0,+'A-Assignment Worksheet'!F29,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B29","v":0},"","","",{"$f":"IF(F29>0,(MIN(U29,(DATEDIF('A-Assignment Worksheet'!F29,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",null,{"$f":"IF(F29>0,(MAX(Q29,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"}]
[20,{"$f":"+'A-Assignment Worksheet'!J30","v":0},{"$f":"+'A-Assignment Worksheet'!K30","v":0},{"$f":"+'A-Assignment Worksheet'!G30","v":0},{"$f":"+'A-Assignment Worksheet'!H30","v":0},{"$f":"+'A-Assignment Worksheet'!L30","v":0},{"$f":"+'A-Assignment Worksheet'!E30","v":0},{"$f":"IF(F30>0,(IF('A-Assignment Worksheet'!B30=\"M\",12,(IF('A-Assignment Worksheet'!B30=\"W\",52,(IF('A-Assignment Worksheet'!B30=\"B\",26,IF('A-Assignment Worksheet'!B30=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F30>0,(+'A-Assignment Worksheet'!F30+'C-Stream Advance'!V30),\"\")","v":""},{"$f":"IF(F30>0,(+J30*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F30>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,20,{"$f":"IF(F30>0,+'A-Assignment Worksheet'!F30,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B30","v":0},"","","",{"$f":"IF(F30>0,(MIN(U30,(DATEDIF('A-Assignment Worksheet'!F30,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",null,{"$f":"IF(F30>0,(MAX(Q30,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"}]
[21,{"$f":"+'A-Assignment Worksheet'!J31","v":0},{"$f":"+'A-Assignment Worksheet'!K31","v":0},{"$f":"+'A-Assignment Worksheet'!G31","v":0},{"$f":"+'A-Assignment Worksheet'!H31","v":0},{"$f":"+'A-Assignment Worksheet'!L31","v":0},{"$f":"+'A-Assignment Worksheet'!E31","v":0},{"$f":"IF(F31>0,(IF('A-Assignment Worksheet'!B31=\"M\",12,(IF('A-Assignment Worksheet'!B31=\"W\",52,(IF('A-Assignment Worksheet'!B31=\"B\",26,IF('A-Assignment Worksheet'!B31=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F31>0,(+'A-Assignment Worksheet'!F31+'C-Stream Advance'!V31),\"\")","v":""},{"$f":"IF(F31>0,(+J31*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F31>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,21,{"$f":"IF(F31>0,+'A-Assignment Worksheet'!F31,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B31","v":0},"","","",{"$f":"IF(F31>0,(MIN(U31,(DATEDIF('A-Assignment Worksheet'!F31,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",null,{"$f":"IF(F31>0,(MAX(Q31,'I-Inputs'!$B$19)),\"\")","v":""},{"$f":"+'I-Inputs'!$B$20","v":"2019-05-24"},{"$error":"#VALUE!"}]
[22,{"$f":"+'A-Assignment Worksheet'!J32","v":0},{"$f":"+'A-Assignment Worksheet'!K32","v":0},{"$f":"+'A-Assignment Worksheet'!G32","v":0},{"$f":"+'A-Assignment Worksheet'!H32","v":0},{"$f":"+'A-Assignment Worksheet'!L32","v":0},{"$f":"+'A-Assignment Worksheet'!E32","v":0},{"$f":"IF(F32>0,(IF('A-Assignment Worksheet'!B32=\"M\",12,(IF('A-Assignment Worksheet'!B32=\"W\",52,(IF('A-Assignment Worksheet'!B32=\"B\",26,IF('A-Assignment Worksheet'!B32=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F32>0,(+'A-Assignment Worksheet'!F32+'C-Stream Advance'!V32),\"\")","v":""},{"$f":"IF(F32>0,(+J32*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F32>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,22,{"$f":"IF(F32>0,+'A-Assignment Worksheet'!F32,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B32","v":0},"","","",{"$f":"IF(F32>0,(MIN(U32,(DATEDIF('A-Assignment Worksheet'!F32,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",null,{"$f":"IF(F32>0,(MAX(Q32,'I-Inputs'!$B$19)),\"\")","v":""}]
[23,{"$f":"+'A-Assignment Worksheet'!J33","v":0},{"$f":"+'A-Assignment Worksheet'!K33","v":0},{"$f":"+'A-Assignment Worksheet'!G33","v":0},{"$f":"+'A-Assignment Worksheet'!H33","v":0},{"$f":"+'A-Assignment Worksheet'!L33","v":0},{"$f":"+'A-Assignment Worksheet'!E33","v":0},{"$f":"IF(F33>0,(IF('A-Assignment Worksheet'!B33=\"M\",12,(IF('A-Assignment Worksheet'!B33=\"W\",52,(IF('A-Assignment Worksheet'!B33=\"B\",26,IF('A-Assignment Worksheet'!B33=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F33>0,(+'A-Assignment Worksheet'!F33+'C-Stream Advance'!V33),\"\")","v":""},{"$f":"IF(F33>0,(+J33*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F33>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,23,{"$f":"IF(F33>0,+'A-Assignment Worksheet'!F33,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B33","v":0},"","","",{"$f":"IF(F33>0,(MIN(U33,(DATEDIF('A-Assignment Worksheet'!F33,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",null,{"$f":"IF(F33>0,(MAX(Q33,'I-Inputs'!$B$19)),\"\")","v":""}]
[24,{"$f":"+'A-Assignment Worksheet'!J34","v":0},{"$f":"+'A-Assignment Worksheet'!K34","v":0},{"$f":"+'A-Assignment Worksheet'!G34","v":0},{"$f":"+'A-Assignment Worksheet'!H34","v":0},{"$f":"+'A-Assignment Worksheet'!L34","v":0},{"$f":"+'A-Assignment Worksheet'!E34","v":0},{"$f":"IF(F34>0,(IF('A-Assignment Worksheet'!B34=\"M\",12,(IF('A-Assignment Worksheet'!B34=\"W\",52,(IF('A-Assignment Worksheet'!B34=\"B\",26,IF('A-Assignment Worksheet'!B34=\"S\",24))))))),\"\")","v":""},"","",{"$f":"IF(F34>0,(+'A-Assignment Worksheet'!F34+'C-Stream Advance'!V34),\"\")","v":""},{"$f":"IF(F34>0,(+J34*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F34>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,24,{"$f":"IF(F34>0,+'A-Assignment Worksheet'!F34,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B34","v":0},"","","",{"$f":"IF(F34>0,(MIN(U34,(DATEDIF('A-Assignment Worksheet'!F34,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",null,{"$f":"IF(F34>0,(MAX(Q34,'I-Inputs'!$B$19)),\"\")","v":""}]
[25,{"$f":"+'A-Assignment Worksheet'!J35","v":0},{"$f":"+'A-Assignment Worksheet'!K35","v":0},{"$f":"+'A-Assignment Worksheet'!G35","v":0},{"$f":"+'A-Assignment Worksheet'!H35","v":0},{"$f":"+'A-Assignment Worksheet'!L35","v":0},{"$f":"+'A-Assignment Worksheet'!E35","v":0},{"$f":"IF(F35>0,(IF('A-Assignment Worksheet'!B35=\"M\",12,(IF('A-Assignment Worksheet'!B35=\"W\",52,(IF('A-Assignment Worksheet'!B35=\"B\",26,IF('A-Assignment Worksheet'!B35=\"S\",24))))))),\"\")","v":""},"",{"$f":"IF(F35>0,(+I35*G35),\"\")","v":""},{"$f":"IF(F35>0,(+'A-Assignment Worksheet'!F35+'C-Stream Advance'!V35),\"\")","v":""},{"$f":"IF(F35>0,(+J35*'I-Inputs'!$B$17),\"\")","v":""},"",{"$f":"IF(F35>0,(+'D-Checklist'!#REF!),\"\")","v":""},null,25,{"$f":"IF(F35>0,+'A-Assignment Worksheet'!F35,\"\")","v":""},{"$f":"+'A-Assignment Worksheet'!B35","v":0},"","","",{"$f":"IF(F35>0,(MIN(U35,(DATEDIF('A-Assignment Worksheet'!F35,'I-Inputs'!$B$20,\"D\")))),\"\")","v":""},"","","",null,{"$f":"IF(F35>0,(MAX(Q35,'I-Inputs'!$B$19)),\"\")","v":""}]
[null,"Totals",null,null,null,{"$f":"SUM(F11:F35)","v":0},null,null,null,{"$f":"SUM(J11:J35)","v":0},null,{"$f":"SUM(L11:L35)","v":0},{"$f":"AVERAGE(M11:M35)","v":{"$error":"#DIV/0!"}}]
[]
["STREAM REPAYMENT TERMS:",null,null,null,null,"Stream Advancement Amount:",null,{"$f":"+L36","v":0}]
[null,"Stream Months:",{"$f":"+'I-Inputs'!B16","v":12},null,null,"Less Administrative Cost:",null,{"$f":"+'C-Attachment To Assignment'!I38","v":-10}]
[null,"Stream Percentage:",{"$f":"+'I-Inputs'!B17","v":0.8},null,null,"Less Title Escrow:",null,{"$f":"+'C-Attachment To Assignment'!I39","v":0}]
[null,"Payment Type:",{"$f":"+'I-Inputs'!B18","v":"W"},null,null,"Less Wire Fee:",null,{"$f":"+'C-Attachment To Assignment'!I40","v":-30}]
[null,"First Payment Date:",{"$f":"+'I-Inputs'!B19","v":"2018-05-24"},null,null,"Total to Be Deducted:",null,{"$f":"+'C-Attachment To Assignment'!I41","v":-40}]
[null,"Payments in Stream:",{"$f":"ROUND(+T7,0)","v":52}]
[null,"Payment Amount:",{"$f":"+J36/C43","v":0},null,null,"TOTAL TO BE FUNDED:",null,{"$f":"+H38+H42","v":-40}]
[null,"Collateral:",{"$f":"+'A-Assignment Worksheet'!L36","v":0}]