{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Input","DataSet","Data","TP Copy","Breakout"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Input","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"DataSet","index":1,"n_rows":181,"n_cols":9,"rows_kept":181,"cut":false,"hidden":true,"merged":[]}
["TC","Description",null,"MFT Code","Form Numbers","Master File",null,"Period","Qtr."]
[150,"Entity Created by TC 150 posting indicates Master File entity created",null,1,941,"BMF",null,3,"1st"]
[160,"Manually computed Delinquency Penalty",null,2,"1120 (All)","BMF",null,6,"2nd"]
[161,"Abatement of Failure to File Penalty",null,5,1041,"BMF",null,9,"3rd"]
[162,"Failure to File Penalty Restriction Deletion",null,6,1065,"BMF",null,12,"4th"]
[166,"Delinquency Penalty",null,8,"8804/8805","BMF"]
[167,"Abatement of Delinquency Penalty",null,9,"CT-1","BMF"]
[170,"Self assessment Estimated Tax Penalty",null,10,940,"BMF"]
[171,"Abatement of Estimated Tax Penalty",null,11,943,"BMF"]
[176,"Estimated Tax Penalty",null,12,1042,"BMF/NMF"]
[177,"Abatement of Estimated Tax Penalty",null,13,8278,"BMF"]
[180,"Manually generarated Deposit Penalty",null,14,944,"BMF"]
[181,"Deposit Penalty Abatement",null,16,945,"BMF"]
[186,"FTD Penalty Assessed",null,17,941,"NMF"]
[187,"Abatement of FTD Penalty Assessed",null,19,943,"NMF"]
[190,"Manually Assessed Interest",null,20,1040,"NMF"]
[191,"Interest Abatement",null,21,1041,"NMF"]
[196,"Interest Assessed",null,22,"1040PR","NMF"]
[197,"Abatement of Interest Assessed",null,30,1040,"IMF"]
[234,"Manually generated Daily Delinquency Penalty",null,31,"1120S","NMF"]
[235,"Abates Daily Delinquency Penalty",null,32,1120,"NMF"]
[238,"Daily Delinquency Penalty",null,34,"990-T","BMF/NMF"]
[239,"Abatement of Daily Delinquency Penalty",null,35,1065,"NMF"]
[240,"Miscellaneous Penalty",null,36,"1041-A","BMF/NMF"]
[241,"Abate Miscellaneous Penalty",null,37,5227,"BMF/NMF"]
[246,"Failure to provide information Penalty on 1065",null,39,944,"NMF"]
[247,"Abatement of 1065 Penalty",null,44,"990PF","BMF/NMF"]
[270,"Manual Assessment of Failure to Pay Tax Penalty",null,47,"8871 Notice","BMF/NMF"]
[271,"Manual Abatement of Failure to Pay Tax Penalty",null,49,"8872 Report","BMF/NMF"]
[272,"Failure to Pay Penalty Restriction Deletion",null,50,4720,"BMF/NMF"]
[276,"Failure to Pay Tax Penalty",null,56,"990-BL","NMF"]
[277,"Abatement of Failure to Pay Tax Penalty",null,60,2290,"BMF"]
[280,"Bad Check Penalty",null,63,"11-C","BMF"]
[281,"Abatement of Bad Check Penalty",null,64,730,"BMF"]
[286,"Bad Check Penalty",null,66,"4720/4720A","NMF"]
[287,"Reversal of Bad Check Penalty",null,67,"990/990EZ","BMF/NMF"]
[290,"Additional Tax Assessment",null,71,"CT-1","NMF"]
[291,"Abatement Prior Tax Assessment",null,72,"CT-2","NMF"]
[294,"Additional Tax Assessment with Interest Computation Date",null,76,5330,"BMF/NMF"]
[295,"Abatement of Prior Tax Assessment with Interest Computation Date",null,80,940,"NMF"]
[298,"Additional Tax Assessment with Interest Computation Date",null,81,926,"NMF"]
[299,"Abatement of Prior Tax Assessment  Interest by Exam",null,96,"11C","NMF"]
[300,"Additional Tax or Deficiency Assessment by Exam",null,97,730,"NMF"]
[301,"Abatement of Tax by Exam",null,99,8278,"NMF"]
[304,"Additional Tax or Deficiency Assessment by Exam"]
[305,"Abatement of Prior Tax Assessment by Exam"]
[308,"Additional Tax or Deficiency Assessment by Exam"]
[309,"Abatement of Prior Tax Assessment by Exam"]
[310,"Penalty for Failure to Report Income from Tips"]
[311,"Tip Penalty Abatement"]
[320,"Fraud Penalty"]
[321,"Abatement of the Fraud Penalty"]
[336,"Interest Assessed on Additional Tax or Deficiency"]
[337,"Abatement of Interest Assessed on Additional Tax or Deficiency"]
[340,"Restricted Interest Assessement"]
[341,"Restricted Interest Abatement"]
[342,"Interest Restriction Deletion"]
[350,"Negligence Penalty"]
[351,"Negligence Penalty Abatement"]
[360,"Fees and Collection Costs"]
[361,"Abatement of Fees and Collection Costs"]
[370,"Account Transferred IN"]
[380,"Clearance of Overpayment manually cleared under $1"]
[386,"Clearance of Overpayment so offsets of less than $1 won't be made"]
[388,"Statute Expiration Clearance to Zero Balance and Remove"]
[389,"Reversal of Statute Expiration"]
[400,"Account Transferred Out"]
[402,"Account Re-Transferred-In"]
[430,"Entity Created from posting of ES payment"]
[450,"Transferee Liability Assessment"]
[459,"Prior Quarter FTD Penalty"]
[460,"Extension of Time for Filing"]
[462,"Correction of a 460 Processed in error"]
[470,"Taxpayer Claim Pending"]
[471,"Reversal of Taxpayer Claim Pending"]
[472,"Reverse of Taxpayer Claim processed in error"]
[488,"Installment and/or Manual Billing"]
[489,"Installment Defaulted"]
[494,"Notice of Deficiency"]
[495,"Closure of 496 or correction of 494 processed in error"]
[520,"IRS Litigation Instituted"]
[521,"Reversal of a 520"]
[522,"Correction of 520 Processed in Error"]
[570,"Additional Liability Pending and/or Credit Hold"]
[571,"Reversal of a 570"]
[572,"Correction of 570 Processed in Error"]
[576,"Unallowable Tax Hold offset is frozen"]
[577,"Reversal of a 576"]
[586,"Transfer/revenue receipt cross ref"]
[590,"Satisfying Transaction - no longer liable for tax"]
[591,"Satisfying Transaction - no longer liable for tax"]
[600,"Underpayment Cleared Manually less than $5"]
[604,"Assessed Debit Cleared - Used for restricted Interest"]
[605,"Generated Reversal of 604"]
[606,"Underpayment Cleared less than $5"]
[610,"Remittance with Return"]
[611,"Remittance with Return Dishonored Check"]
[612,"Correction of 610 Processed in Error"]
[620,"Initial Installment Payment"]
[621,"Installment Payment Check Dishonored"]
[622,"Correction of 620 Processed in Error"]
[640,"Advance Payment of Determined Deficiency"]
[641,"Dishonored Check on Advance Payment"]
[642,"Correction of 640 Processed in Error"]
[650,"Federal Tax Deposit"]
[651,"Invalid Federal Tax Deposit"]
[652,"Correction of FTD Posted in Error"]
[660,"Federal Tax Deposit"]
[661,"ES Payment or FTD Check Dishonored"]
[662,"Correction of 660 Processed in Error"]
[666,"Estimated Tax Credit Transfer In"]
[667,"Estimated Tax Debit Transfer Out - to a spouse's account"]
[670,"Subsequent Payment"]
[671,"Subsequent Payment Check dishonored"]
[672,"Correction of 670 Processed in Error"]
[680,"Designated Payment of Interest"]
[681,"Designated Payment Check Dishonored"]
[682,"Correction of 680 Processed in Error"]
[690,"Designated Payment of Penalty"]
[691,"Designated Payment Check Dishonored"]
[692,"Correction of 690 Processed in Error"]
[700,"Credit Applied for a manually transferred amount"]
[701,"Reverse Generated Overpayment Credit Applied - Reverses 706"]
[702,"Correction of Erroneously Applied Credit"]
[706,"Generated Overpayment Applied from Another Tax Module - computer generated"]
[710,"Overpayment Credit Applied from Prior Tax Period"]
[712,"Correction of 710 or 716 Processed in Error"]
[716,"Generated Overpayment Credit Applied from Prior Tax Period - computer generated"]
[720,"Refund Repayment"]
[721,"Refund Repayment Check Dishonored"]
[722,"Correction of 720 Processed in Error"]
[730,"Overpayment Interest Applied manually transferred."]
[731,"Reverse Generated Overpayment Interest Applied"]
[732,"Correction of 730 Processed in Error"]
[736,"Generated Interest Overpayment Applied - computer generated"]
[740,"Undelivered Refund Check Redeposited"]
[742,"Correction of 740 Processed in Error"]
[756,"Interest on Overpayment Transferred from IMF overpayment transferred to a BMF Tax Module"]
[760,"Substantiated Credt Payment Allowance"]
[762,"Correction of 760 Processed in Error"]
[770,"Credit Interest Due Taxpayer - includes restricted interest on overpayment or offsetting"]
[771,"Interest Reversal Prior to Refund Issuance"]
[772,"Correction of 770 Processed in Error or Interest Netting"]
[776,"Generated Interest Due on Overpayment"]
[777,"Reverse Generated Interest Due Taxpayer or Interest Netting"]
[790,"Manual Overpayment Applied from IMF manually applied from BMF"]
[792,"Correction of 790 Processed in error"]
[796,"Overpayment Credit form IMF transferred to BMF"]
[800,"Credit for Withheld Taxes "]
[802,"Correction of an 800 Processed in Error"]
[806,"Credit for Withheld Taxes and Excess FICA"]
[807,"Reverses Credit for Withheld Taxes"]
[820,"Credit Transferred Manually to Another Module"]
[821,"Reverse Generated Overpayment Credit Transferred"]
[822,"Correction of an Overpayment Transferred in Error"]
[824,"overpayment Credits Transferred to Another or to Non-MF Account"]
[826,"Overpayment Transferred - Computer Generated"]
[830,"Manual Overpayment Credit Elect (Transferred) to Next Periods of Tax"]
[832,"Correction of Credit Elect Transfer"]
[836,"Computer Generated Overpayment Credit Elect Transferred to Next Periods of Tax"]
[840,"Manual Refund"]
[841,"Cancelled Refund Check Deposited"]
[842,"Refund Deletion"]
[844,"Erroneous Refund"]
[845,"Reverse Erroneous Refund"]
[846,"Refund of Overpayment"]
[850,"Overpayment Interest Transfer "]
[851,"Reverse Generated Overpayment Interest Transfer"]
[852,"Correction of TC 850 Processed in Error"]
[856,"Overpayment Interest Transfer by Computer"]
[860,"Reverses Erroneous Abatement"]
[876,"Interest on Overpayment Transaction to BMF"]
[890,"Manual Transfer of Overpayment Credits to BMF"]
[892,"Correction of TC 890"]
[896,"Overpayment Credit Offset"]
[897,"DMF Offsett to reverse TC 896"]
[970,"Additional liability F945/F941/F720"]
[971,"Reverses TC 970"]
[972,"Amended/Duplicate return indicator"]
[973,"Application for tentative refund F1139"]
[977,"Posted amended return"]

{"sheet":"Data","index":2,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["MFT","Tax Period","TC","Date","Amount","Last amount Amount"]

{"sheet":"TP Copy","index":3,"n_rows":60,"n_cols":6,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
["Form","Year","Period","Date","Description","Amount"]
[{"$f":"IF(G2=\"\",\"\",LOOKUP(VALUE(G2),Table3[MFT Code],Table3[Form Numbers]))","v":""},{"$f":"IF(H2=\"\",\"\",VALUE(LEFT(H2,4)))","v":""},{"$f":"IF(H2=\"\",\"\",IF(VALUE(G2)=1,LOOKUP(VALUE(RIGHT(H2,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},{"$f":"IF(J2=\"\",\"\",J2)","v":""},{"$f":"IF(K2=\"\",\"\",LOOKUP(VALUE(LEFT(I2,3)),Table2[TC],Table2[Description]))","v":""},{"$f":"IF(K2=\"\",\"\",K2)","v":""}]
[{"$f":"IF(G3=\"\",\"\",LOOKUP(VALUE(G3),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H3=\"\",\"\",IF(VALUE(G3)=1,LOOKUP(VALUE(RIGHT(H3,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K3=\"\",\"\",LOOKUP(VALUE(LEFT(I3,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G4=\"\",\"\",LOOKUP(VALUE(G4),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H4=\"\",\"\",IF(VALUE(G4)=1,LOOKUP(VALUE(RIGHT(H4,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K4=\"\",\"\",LOOKUP(VALUE(LEFT(I4,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G5=\"\",\"\",LOOKUP(VALUE(G5),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H5=\"\",\"\",IF(VALUE(G5)=1,LOOKUP(VALUE(RIGHT(H5,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K5=\"\",\"\",LOOKUP(VALUE(LEFT(I5,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G6=\"\",\"\",LOOKUP(VALUE(G6),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H6=\"\",\"\",IF(VALUE(G6)=1,LOOKUP(VALUE(RIGHT(H6,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K6=\"\",\"\",LOOKUP(VALUE(LEFT(I6,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G7=\"\",\"\",LOOKUP(VALUE(G7),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H7=\"\",\"\",IF(VALUE(G7)=1,LOOKUP(VALUE(RIGHT(H7,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K7=\"\",\"\",LOOKUP(VALUE(LEFT(I7,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G8=\"\",\"\",LOOKUP(VALUE(G8),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H8=\"\",\"\",IF(VALUE(G8)=1,LOOKUP(VALUE(RIGHT(H8,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K8=\"\",\"\",LOOKUP(VALUE(LEFT(I8,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G9=\"\",\"\",LOOKUP(VALUE(G9),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H9=\"\",\"\",IF(VALUE(G9)=1,LOOKUP(VALUE(RIGHT(H9,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K9=\"\",\"\",LOOKUP(VALUE(LEFT(I9,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G10=\"\",\"\",LOOKUP(VALUE(G10),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H10=\"\",\"\",IF(VALUE(G10)=1,LOOKUP(VALUE(RIGHT(H10,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K10=\"\",\"\",LOOKUP(VALUE(LEFT(I10,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G11=\"\",\"\",LOOKUP(VALUE(G11),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H11=\"\",\"\",IF(VALUE(G11)=1,LOOKUP(VALUE(RIGHT(H11,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K11=\"\",\"\",LOOKUP(VALUE(LEFT(I11,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G12=\"\",\"\",LOOKUP(VALUE(G12),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H12=\"\",\"\",IF(VALUE(G12)=1,LOOKUP(VALUE(RIGHT(H12,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K12=\"\",\"\",LOOKUP(VALUE(LEFT(I12,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G13=\"\",\"\",LOOKUP(VALUE(G13),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H13=\"\",\"\",IF(VALUE(G13)=1,LOOKUP(VALUE(RIGHT(H13,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K13=\"\",\"\",LOOKUP(VALUE(LEFT(I13,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G14=\"\",\"\",LOOKUP(VALUE(G14),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H14=\"\",\"\",IF(VALUE(G14)=1,LOOKUP(VALUE(RIGHT(H14,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K14=\"\",\"\",LOOKUP(VALUE(LEFT(I14,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G15=\"\",\"\",LOOKUP(VALUE(G15),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H15=\"\",\"\",IF(VALUE(G15)=1,LOOKUP(VALUE(RIGHT(H15,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K15=\"\",\"\",LOOKUP(VALUE(LEFT(I15,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G16=\"\",\"\",LOOKUP(VALUE(G16),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H16=\"\",\"\",IF(VALUE(G16)=1,LOOKUP(VALUE(RIGHT(H16,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K16=\"\",\"\",LOOKUP(VALUE(LEFT(I16,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G17=\"\",\"\",LOOKUP(VALUE(G17),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H17=\"\",\"\",IF(VALUE(G17)=1,LOOKUP(VALUE(RIGHT(H17,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K17=\"\",\"\",LOOKUP(VALUE(LEFT(I17,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G18=\"\",\"\",LOOKUP(VALUE(G18),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H18=\"\",\"\",IF(VALUE(G18)=1,LOOKUP(VALUE(RIGHT(H18,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K18=\"\",\"\",LOOKUP(VALUE(LEFT(I18,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G19=\"\",\"\",LOOKUP(VALUE(G19),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H19=\"\",\"\",IF(VALUE(G19)=1,LOOKUP(VALUE(RIGHT(H19,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K19=\"\",\"\",LOOKUP(VALUE(LEFT(I19,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G20=\"\",\"\",LOOKUP(VALUE(G20),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H20=\"\",\"\",IF(VALUE(G20)=1,LOOKUP(VALUE(RIGHT(H20,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K20=\"\",\"\",LOOKUP(VALUE(LEFT(I20,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G21=\"\",\"\",LOOKUP(VALUE(G21),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H21=\"\",\"\",IF(VALUE(G21)=1,LOOKUP(VALUE(RIGHT(H21,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K21=\"\",\"\",LOOKUP(VALUE(LEFT(I21,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G22=\"\",\"\",LOOKUP(VALUE(G22),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H22=\"\",\"\",IF(VALUE(G22)=1,LOOKUP(VALUE(RIGHT(H22,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K22=\"\",\"\",LOOKUP(VALUE(LEFT(I22,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G23=\"\",\"\",LOOKUP(VALUE(G23),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H23=\"\",\"\",IF(VALUE(G23)=1,LOOKUP(VALUE(RIGHT(H23,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K23=\"\",\"\",LOOKUP(VALUE(LEFT(I23,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G24=\"\",\"\",LOOKUP(VALUE(G24),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H24=\"\",\"\",IF(VALUE(G24)=1,LOOKUP(VALUE(RIGHT(H24,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K24=\"\",\"\",LOOKUP(VALUE(LEFT(I24,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G25=\"\",\"\",LOOKUP(VALUE(G25),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H25=\"\",\"\",IF(VALUE(G25)=1,LOOKUP(VALUE(RIGHT(H25,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K25=\"\",\"\",LOOKUP(VALUE(LEFT(I25,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G26=\"\",\"\",LOOKUP(VALUE(G26),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H26=\"\",\"\",IF(VALUE(G26)=1,LOOKUP(VALUE(RIGHT(H26,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K26=\"\",\"\",LOOKUP(VALUE(LEFT(I26,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G27=\"\",\"\",LOOKUP(VALUE(G27),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H27=\"\",\"\",IF(VALUE(G27)=1,LOOKUP(VALUE(RIGHT(H27,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K27=\"\",\"\",LOOKUP(VALUE(LEFT(I27,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G28=\"\",\"\",LOOKUP(VALUE(G28),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H28=\"\",\"\",IF(VALUE(G28)=1,LOOKUP(VALUE(RIGHT(H28,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K28=\"\",\"\",LOOKUP(VALUE(LEFT(I28,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G29=\"\",\"\",LOOKUP(VALUE(G29),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H29=\"\",\"\",IF(VALUE(G29)=1,LOOKUP(VALUE(RIGHT(H29,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K29=\"\",\"\",LOOKUP(VALUE(LEFT(I29,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G30=\"\",\"\",LOOKUP(VALUE(G30),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H30=\"\",\"\",IF(VALUE(G30)=1,LOOKUP(VALUE(RIGHT(H30,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K30=\"\",\"\",LOOKUP(VALUE(LEFT(I30,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G31=\"\",\"\",LOOKUP(VALUE(G31),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H31=\"\",\"\",IF(VALUE(G31)=1,LOOKUP(VALUE(RIGHT(H31,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K31=\"\",\"\",LOOKUP(VALUE(LEFT(I31,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G32=\"\",\"\",LOOKUP(VALUE(G32),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H32=\"\",\"\",IF(VALUE(G32)=1,LOOKUP(VALUE(RIGHT(H32,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K32=\"\",\"\",LOOKUP(VALUE(LEFT(I32,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G33=\"\",\"\",LOOKUP(VALUE(G33),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H33=\"\",\"\",IF(VALUE(G33)=1,LOOKUP(VALUE(RIGHT(H33,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K33=\"\",\"\",LOOKUP(VALUE(LEFT(I33,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G34=\"\",\"\",LOOKUP(VALUE(G34),Table3[MFT Code],Table3[Form Numbers]))","v":""},{"$f":"IF(H34=\"\",\"\",VALUE(LEFT(H34,4)))","v":""},{"$f":"IF(H34=\"\",\"\",IF(VALUE(G34)=1,LOOKUP(VALUE(RIGHT(H34,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},{"$f":"IF(J34=\"\",\"\",J34)","v":""},{"$f":"IF(K34=\"\",\"\",LOOKUP(VALUE(LEFT(I34,3)),Table2[TC],Table2[Description]))","v":""},{"$f":"IF(K34=\"\",\"\",K34)","v":""}]
[{"$f":"IF(G35=\"\",\"\",LOOKUP(VALUE(G35),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H35=\"\",\"\",IF(VALUE(G35)=1,LOOKUP(VALUE(RIGHT(H35,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K35=\"\",\"\",LOOKUP(VALUE(LEFT(I35,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G36=\"\",\"\",LOOKUP(VALUE(G36),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H36=\"\",\"\",IF(VALUE(G36)=1,LOOKUP(VALUE(RIGHT(H36,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K36=\"\",\"\",LOOKUP(VALUE(LEFT(I36,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G37=\"\",\"\",LOOKUP(VALUE(G37),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H37=\"\",\"\",IF(VALUE(G37)=1,LOOKUP(VALUE(RIGHT(H37,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K37=\"\",\"\",LOOKUP(VALUE(LEFT(I37,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G38=\"\",\"\",LOOKUP(VALUE(G38),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H38=\"\",\"\",IF(VALUE(G38)=1,LOOKUP(VALUE(RIGHT(H38,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K38=\"\",\"\",LOOKUP(VALUE(LEFT(I38,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G39=\"\",\"\",LOOKUP(VALUE(G39),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H39=\"\",\"\",IF(VALUE(G39)=1,LOOKUP(VALUE(RIGHT(H39,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K39=\"\",\"\",LOOKUP(VALUE(LEFT(I39,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G40=\"\",\"\",LOOKUP(VALUE(G40),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H40=\"\",\"\",IF(VALUE(G40)=1,LOOKUP(VALUE(RIGHT(H40,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K40=\"\",\"\",LOOKUP(VALUE(LEFT(I40,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G41=\"\",\"\",LOOKUP(VALUE(G41),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H41=\"\",\"\",IF(VALUE(G41)=1,LOOKUP(VALUE(RIGHT(H41,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K41=\"\",\"\",LOOKUP(VALUE(LEFT(I41,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G42=\"\",\"\",LOOKUP(VALUE(G42),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H42=\"\",\"\",IF(VALUE(G42)=1,LOOKUP(VALUE(RIGHT(H42,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K42=\"\",\"\",LOOKUP(VALUE(LEFT(I42,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G43=\"\",\"\",LOOKUP(VALUE(G43),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H43=\"\",\"\",IF(VALUE(G43)=1,LOOKUP(VALUE(RIGHT(H43,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K43=\"\",\"\",LOOKUP(VALUE(LEFT(I43,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G44=\"\",\"\",LOOKUP(VALUE(G44),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H44=\"\",\"\",IF(VALUE(G44)=1,LOOKUP(VALUE(RIGHT(H44,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K44=\"\",\"\",LOOKUP(VALUE(LEFT(I44,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G45=\"\",\"\",LOOKUP(VALUE(G45),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H45=\"\",\"\",IF(VALUE(G45)=1,LOOKUP(VALUE(RIGHT(H45,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K45=\"\",\"\",LOOKUP(VALUE(LEFT(I45,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G46=\"\",\"\",LOOKUP(VALUE(G46),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H46=\"\",\"\",IF(VALUE(G46)=1,LOOKUP(VALUE(RIGHT(H46,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K46=\"\",\"\",LOOKUP(VALUE(LEFT(I46,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G47=\"\",\"\",LOOKUP(VALUE(G47),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H47=\"\",\"\",IF(VALUE(G47)=1,LOOKUP(VALUE(RIGHT(H47,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K47=\"\",\"\",LOOKUP(VALUE(LEFT(I47,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G48=\"\",\"\",LOOKUP(VALUE(G48),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H48=\"\",\"\",IF(VALUE(G48)=1,LOOKUP(VALUE(RIGHT(H48,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K48=\"\",\"\",LOOKUP(VALUE(LEFT(I48,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G49=\"\",\"\",LOOKUP(VALUE(G49),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H49=\"\",\"\",IF(VALUE(G49)=1,LOOKUP(VALUE(RIGHT(H49,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K49=\"\",\"\",LOOKUP(VALUE(LEFT(I49,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G50=\"\",\"\",LOOKUP(VALUE(G50),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H50=\"\",\"\",IF(VALUE(G50)=1,LOOKUP(VALUE(RIGHT(H50,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K50=\"\",\"\",LOOKUP(VALUE(LEFT(I50,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G51=\"\",\"\",LOOKUP(VALUE(G51),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H51=\"\",\"\",IF(VALUE(G51)=1,LOOKUP(VALUE(RIGHT(H51,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K51=\"\",\"\",LOOKUP(VALUE(LEFT(I51,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G52=\"\",\"\",LOOKUP(VALUE(G52),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H52=\"\",\"\",IF(VALUE(G52)=1,LOOKUP(VALUE(RIGHT(H52,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K52=\"\",\"\",LOOKUP(VALUE(LEFT(I52,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G53=\"\",\"\",LOOKUP(VALUE(G53),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H53=\"\",\"\",IF(VALUE(G53)=1,LOOKUP(VALUE(RIGHT(H53,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K53=\"\",\"\",LOOKUP(VALUE(LEFT(I53,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G54=\"\",\"\",LOOKUP(VALUE(G54),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H54=\"\",\"\",IF(VALUE(G54)=1,LOOKUP(VALUE(RIGHT(H54,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K54=\"\",\"\",LOOKUP(VALUE(LEFT(I54,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G55=\"\",\"\",LOOKUP(VALUE(G55),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H55=\"\",\"\",IF(VALUE(G55)=1,LOOKUP(VALUE(RIGHT(H55,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K55=\"\",\"\",LOOKUP(VALUE(LEFT(I55,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G56=\"\",\"\",LOOKUP(VALUE(G56),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H56=\"\",\"\",IF(VALUE(G56)=1,LOOKUP(VALUE(RIGHT(H56,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K56=\"\",\"\",LOOKUP(VALUE(LEFT(I56,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G57=\"\",\"\",LOOKUP(VALUE(G57),Table3[MFT Code],Table3[Form Numbers]))","v":""},{"$f":"IF(H57=\"\",\"\",VALUE(LEFT(H57,4)))","v":""},{"$f":"IF(H57=\"\",\"\",IF(VALUE(G57)=1,LOOKUP(VALUE(RIGHT(H57,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},{"$f":"IF(J57=\"\",\"\",J57)","v":""},{"$f":"IF(K57=\"\",\"\",LOOKUP(VALUE(LEFT(I57,3)),Table2[TC],Table2[Description]))","v":""},{"$f":"IF(K57=\"\",\"\",K57)","v":""}]
[{"$f":"IF(G58=\"\",\"\",LOOKUP(VALUE(G58),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H58=\"\",\"\",IF(VALUE(G58)=1,LOOKUP(VALUE(RIGHT(H58,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K58=\"\",\"\",LOOKUP(VALUE(LEFT(I58,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G59=\"\",\"\",LOOKUP(VALUE(G59),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H59=\"\",\"\",IF(VALUE(G59)=1,LOOKUP(VALUE(RIGHT(H59,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K59=\"\",\"\",LOOKUP(VALUE(LEFT(I59,3)),Table2[TC],Table2[Description]))","v":""},""]
[{"$f":"IF(G60=\"\",\"\",LOOKUP(VALUE(G60),Table3[MFT Code],Table3[Form Numbers]))","v":""},"",{"$f":"IF(H60=\"\",\"\",IF(VALUE(G60)=1,LOOKUP(VALUE(RIGHT(H60,2)),Table4[Period],Table4[Qtr.]),\"Annual\"))","v":""},"",{"$f":"IF(K60=\"\",\"\",LOOKUP(VALUE(LEFT(I60,3)),Table2[TC],Table2[Description]))","v":""},""]

{"sheet":"Breakout","index":4,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["MFT","Year","Amount"]
[null,null,{"$f":"SUMIFS(Data!E:E,Data!A:A,Table1[[#This Row],[MFT]],Data!B:B,Table1[[#This Row],[Year]])","v":0}]