{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Acctg_JE_Entry_Template","Backup Documentation","CCR Example"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":8,"comments":1,"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":"Acctg_JE_Entry_Template","index":0,"n_rows":225,"n_cols":14,"rows_kept":225,"cut":false,"hidden":false,"merged":[[27,7,44,7],[27,9,44,12],[0,1,0,13],[1,1,1,13],[11,3,11,4],[21,1,23,13],[16,2,16,7],[17,2,17,7],[16,9,16,13],[17,9,17,13],[3,1,9,13],[145,7,194,7],[195,7,224,7],[145,9,194,12],[195,9,224,12],[45,7,94,7],[45,9,94,12],[95,7,144,7],[95,9,144,12]]}
[]
[null,"Sacramento State (SACST) Campus Cost Recovery (CCR) / Chargeback Request Form"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev. 05/2020"]
[null,"Fill out unlocked cells, highlighted in 'green' for convenience. Avoiding copy/paste function will ensure the proper function of the data validations set in the form. Macros must be enabled for the form to be accurately completed and submitted on a PC (.xlsm file).\n\nThis form needs to be submitted by the service provider, and should be used to request a journal entry for campus cost recovery (CCR) / chargeback transactions.  The 1st chart string line on the form is dedicated for the expense. The revenue account (on the 2nd line of the form) will be auto-populated when inputting the fund for the expense.\n\nInstructions: \n(1) Complete the unlocked cells, highlighted in 'green', in Sections I thru III of the form.  If additional rows are needed, click the \"Show/Hide\" buttons on the bottom of the form.  \n(2) Once data entry is complete, use the \"Save Form\" button if you wish to save a copy of the form for your records.  Or, click the \"Print Form\" button to print a hard copy.  \n(3) Click the \"Submit Form via E-mail\" button to send the form via e-mail to University Accounting Services (accountingservices@csus.edu).    \n\nFor questions regarding this form, please email accountingservices@csus.edu."]
[]
[]
[]
[]
[]
[]
[]
[null,"Request Date"]
[]
[]
[null,"I. Requestor / Contact Information"]
[]
[null,"Name",null,null,null,null,null,null,"Ext"]
[null,"Dept",null,null,null,null,null,null,"Email"]
[]
[null,"II. Reason for the Request"]
[]
[]
[]
[]
[]
[null,"III. Transaction Information",null,null,null,null,null,null,null,null,null,"Check / Total:",{"$f":"IF(ROUND(SUM(N28:N225),2)=0,\"In Balance\",\"Not Balanced\")","v":"In Balance"},{"$f":"SUM(N28:N225)","v":0}]
[null,"Account","Fund","Dept","Program","Class","Project","Scenario","Line Description\n(30 - Entered in Caps) (Cannot Contain Commas)","Stat","Stat Amt","Open Item","Jrnl Line Ref","Amount"]
[1,null,null,null,null,null,null,"For Accounting \nUse Only",null,"For Accounting \nUse Only"]
[2,{"$f":"IF(OR(LEFT(C28,1)=\"X\", ISBLANK(C28)), \"\", IF(C28=\"MDR01\", \"580095\", IF(OR(LEFT(C28,1)=\"B\", LEFT(C28,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[3]
[4,{"$f":"IF(OR(LEFT(C30,1)=\"X\", ISBLANK(C30)), \"\", IF(C30=\"MDR01\", \"580095\", IF(OR(LEFT(C30,1)=\"B\", LEFT(C30,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[5]
[6,{"$f":"IF(OR(LEFT(C32,1)=\"X\", ISBLANK(C32)), \"\", IF(C32=\"MDR01\", \"580095\", IF(OR(LEFT(C32,1)=\"B\", LEFT(C32,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[7]
[8,{"$f":"IF(OR(LEFT(C34,1)=\"X\", ISBLANK(C34)), \"\", IF(C34=\"MDR01\", \"580095\", IF(OR(LEFT(C34,1)=\"B\", LEFT(C34,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[9]
[10,{"$f":"IF(OR(LEFT(C36,1)=\"X\", ISBLANK(C36)), \"\", IF(C36=\"MDR01\", \"580095\", IF(OR(LEFT(C36,1)=\"B\", LEFT(C36,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[11]
[12,{"$f":"IF(OR(LEFT(C38,1)=\"X\", ISBLANK(C38)), \"\", IF(C38=\"MDR01\", \"580095\", IF(OR(LEFT(C38,1)=\"B\", LEFT(C38,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[13]
[14,{"$f":"IF(OR(LEFT(C40,1)=\"X\", ISBLANK(C40)), \"\", IF(C40=\"MDR01\", \"580095\", IF(OR(LEFT(C40,1)=\"B\", LEFT(C40,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[15]
[16,{"$f":"IF(OR(LEFT(C42,1)=\"X\", ISBLANK(C42)), \"\", IF(C42=\"MDR01\", \"580095\", IF(OR(LEFT(C42,1)=\"B\", LEFT(C42,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[17]
[18,{"$f":"IF(OR(LEFT(C44,1)=\"X\", ISBLANK(C44)), \"\", IF(C44=\"MDR01\", \"580095\", IF(OR(LEFT(C44,1)=\"B\", LEFT(C44,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[19,null,null,null,null,null,null,"For Accounting \nUse Only",null,"For Accounting \nUse Only"]
[20,{"$f":"IF(OR(LEFT(C46,1)=\"X\", ISBLANK(C46)), \"\", IF(C46=\"MDR01\", \"580095\", IF(OR(LEFT(C46,1)=\"B\", LEFT(C46,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[21]
[22,{"$f":"IF(OR(LEFT(C48,1)=\"X\", ISBLANK(C48)), \"\", IF(C48=\"MDR01\", \"580095\", IF(OR(LEFT(C48,1)=\"B\", LEFT(C48,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[23]
[24,{"$f":"IF(OR(LEFT(C50,1)=\"X\", ISBLANK(C50)), \"\", IF(C50=\"MDR01\", \"580095\", IF(OR(LEFT(C50,1)=\"B\", LEFT(C50,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[25]
[26,{"$f":"IF(OR(LEFT(C52,1)=\"X\", ISBLANK(C52)), \"\", IF(C52=\"MDR01\", \"580095\", IF(OR(LEFT(C52,1)=\"B\", LEFT(C52,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[27]
[28,{"$f":"IF(OR(LEFT(C54,1)=\"X\", ISBLANK(C54)), \"\", IF(C54=\"MDR01\", \"580095\", IF(OR(LEFT(C54,1)=\"B\", LEFT(C54,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[29]
[30,{"$f":"IF(OR(LEFT(C56,1)=\"X\", ISBLANK(C56)), \"\", IF(C56=\"MDR01\", \"580095\", IF(OR(LEFT(C56,1)=\"B\", LEFT(C56,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[31]
[32,{"$f":"IF(OR(LEFT(C58,1)=\"X\", ISBLANK(C58)), \"\", IF(C58=\"MDR01\", \"580095\", IF(OR(LEFT(C58,1)=\"B\", LEFT(C58,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[33]
[34,{"$f":"IF(OR(LEFT(C60,1)=\"X\", ISBLANK(C60)), \"\", IF(C60=\"MDR01\", \"580095\", IF(OR(LEFT(C60,1)=\"B\", LEFT(C60,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[35]
[36,{"$f":"IF(OR(LEFT(C62,1)=\"X\", ISBLANK(C62)), \"\", IF(C62=\"MDR01\", \"580095\", IF(OR(LEFT(C62,1)=\"B\", LEFT(C62,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[37]
[38,{"$f":"IF(OR(LEFT(C64,1)=\"X\", ISBLANK(C64)), \"\", IF(C64=\"MDR01\", \"580095\", IF(OR(LEFT(C64,1)=\"B\", LEFT(C64,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[39]
[40,{"$f":"IF(OR(LEFT(C66,1)=\"X\", ISBLANK(C66)), \"\", IF(C66=\"MDR01\", \"580095\", IF(OR(LEFT(C66,1)=\"B\", LEFT(C66,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[41]
[42,{"$f":"IF(OR(LEFT(C68,1)=\"X\", ISBLANK(C68)), \"\", IF(C68=\"MDR01\", \"580095\", IF(OR(LEFT(C68,1)=\"B\", LEFT(C68,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[43]
[44,{"$f":"IF(OR(LEFT(C70,1)=\"X\", ISBLANK(C70)), \"\", IF(C70=\"MDR01\", \"580095\", IF(OR(LEFT(C70,1)=\"B\", LEFT(C70,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[45]
[46,{"$f":"IF(OR(LEFT(C72,1)=\"X\", ISBLANK(C72)), \"\", IF(C72=\"MDR01\", \"580095\", IF(OR(LEFT(C72,1)=\"B\", LEFT(C72,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[47]
[48,{"$f":"IF(OR(LEFT(C74,1)=\"X\", ISBLANK(C74)), \"\", IF(C74=\"MDR01\", \"580095\", IF(OR(LEFT(C74,1)=\"B\", LEFT(C74,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[49]
[50,{"$f":"IF(OR(LEFT(C76,1)=\"X\", ISBLANK(C76)), \"\", IF(C76=\"MDR01\", \"580095\", IF(OR(LEFT(C76,1)=\"B\", LEFT(C76,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[51]
[52,{"$f":"IF(OR(LEFT(C78,1)=\"X\", ISBLANK(C78)), \"\", IF(C78=\"MDR01\", \"580095\", IF(OR(LEFT(C78,1)=\"B\", LEFT(C78,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[53]
[54,{"$f":"IF(OR(LEFT(C80,1)=\"X\", ISBLANK(C80)), \"\", IF(C80=\"MDR01\", \"580095\", IF(OR(LEFT(C80,1)=\"B\", LEFT(C80,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[55]
[56,{"$f":"IF(OR(LEFT(C82,1)=\"X\", ISBLANK(C82)), \"\", IF(C82=\"MDR01\", \"580095\", IF(OR(LEFT(C82,1)=\"B\", LEFT(C82,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[57]
[58,{"$f":"IF(OR(LEFT(C84,1)=\"X\", ISBLANK(C84)), \"\", IF(C84=\"MDR01\", \"580095\", IF(OR(LEFT(C84,1)=\"B\", LEFT(C84,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[59]
[60,{"$f":"IF(OR(LEFT(C86,1)=\"X\", ISBLANK(C86)), \"\", IF(C86=\"MDR01\", \"580095\", IF(OR(LEFT(C86,1)=\"B\", LEFT(C86,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[61]
[62,{"$f":"IF(OR(LEFT(C88,1)=\"X\", ISBLANK(C88)), \"\", IF(C88=\"MDR01\", \"580095\", IF(OR(LEFT(C88,1)=\"B\", LEFT(C88,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[63]
[64,{"$f":"IF(OR(LEFT(C90,1)=\"X\", ISBLANK(C90)), \"\", IF(C90=\"MDR01\", \"580095\", IF(OR(LEFT(C90,1)=\"B\", LEFT(C90,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[65]
[66,{"$f":"IF(OR(LEFT(C92,1)=\"X\", ISBLANK(C92)), \"\", IF(C92=\"MDR01\", \"580095\", IF(OR(LEFT(C92,1)=\"B\", LEFT(C92,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[67]
[68,{"$f":"IF(OR(LEFT(C94,1)=\"X\", ISBLANK(C94)), \"\", IF(C94=\"MDR01\", \"580095\", IF(OR(LEFT(C94,1)=\"B\", LEFT(C94,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[69,null,null,null,null,null,null,"For Accounting \nUse Only",null,"For Accounting \nUse Only"]
[70,{"$f":"IF(OR(LEFT(C96,1)=\"X\", ISBLANK(C96)), \"\", IF(C96=\"MDR01\", \"580095\", IF(OR(LEFT(C96,1)=\"B\", LEFT(C96,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[71]
[72,{"$f":"IF(OR(LEFT(C98,1)=\"X\", ISBLANK(C98)), \"\", IF(C98=\"MDR01\", \"580095\", IF(OR(LEFT(C98,1)=\"B\", LEFT(C98,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[73]
[74,{"$f":"IF(OR(LEFT(C100,1)=\"X\", ISBLANK(C100)), \"\", IF(C100=\"MDR01\", \"580095\", IF(OR(LEFT(C100,1)=\"B\", LEFT(C100,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[75]
[76,{"$f":"IF(OR(LEFT(C102,1)=\"X\", ISBLANK(C102)), \"\", IF(C102=\"MDR01\", \"580095\", IF(OR(LEFT(C102,1)=\"B\", LEFT(C102,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[77]
[78,{"$f":"IF(OR(LEFT(C104,1)=\"X\", ISBLANK(C104)), \"\", IF(C104=\"MDR01\", \"580095\", IF(OR(LEFT(C104,1)=\"B\", LEFT(C104,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[79]
[80,{"$f":"IF(OR(LEFT(C106,1)=\"X\", ISBLANK(C106)), \"\", IF(C106=\"MDR01\", \"580095\", IF(OR(LEFT(C106,1)=\"B\", LEFT(C106,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[81]
[82,{"$f":"IF(OR(LEFT(C108,1)=\"X\", ISBLANK(C108)), \"\", IF(C108=\"MDR01\", \"580095\", IF(OR(LEFT(C108,1)=\"B\", LEFT(C108,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[83]
[84,{"$f":"IF(OR(LEFT(C110,1)=\"X\", ISBLANK(C110)), \"\", IF(C110=\"MDR01\", \"580095\", IF(OR(LEFT(C110,1)=\"B\", LEFT(C110,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[85]
[86,{"$f":"IF(OR(LEFT(C112,1)=\"X\", ISBLANK(C112)), \"\", IF(C112=\"MDR01\", \"580095\", IF(OR(LEFT(C112,1)=\"B\", LEFT(C112,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[87]
[88,{"$f":"IF(OR(LEFT(C114,1)=\"X\", ISBLANK(C114)), \"\", IF(C114=\"MDR01\", \"580095\", IF(OR(LEFT(C114,1)=\"B\", LEFT(C114,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[89]
[90,{"$f":"IF(OR(LEFT(C116,1)=\"X\", ISBLANK(C116)), \"\", IF(C116=\"MDR01\", \"580095\", IF(OR(LEFT(C116,1)=\"B\", LEFT(C116,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[91]
[92,{"$f":"IF(OR(LEFT(C118,1)=\"X\", ISBLANK(C118)), \"\", IF(C118=\"MDR01\", \"580095\", IF(OR(LEFT(C118,1)=\"B\", LEFT(C118,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[93]
[94,{"$f":"IF(OR(LEFT(C120,1)=\"X\", ISBLANK(C120)), \"\", IF(C120=\"MDR01\", \"580095\", IF(OR(LEFT(C120,1)=\"B\", LEFT(C120,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[95]
[96,{"$f":"IF(OR(LEFT(C122,1)=\"X\", ISBLANK(C122)), \"\", IF(C122=\"MDR01\", \"580095\", IF(OR(LEFT(C122,1)=\"B\", LEFT(C122,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[97]
[98,{"$f":"IF(OR(LEFT(C124,1)=\"X\", ISBLANK(C124)), \"\", IF(C124=\"MDR01\", \"580095\", IF(OR(LEFT(C124,1)=\"B\", LEFT(C124,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[99]
[100,{"$f":"IF(OR(LEFT(C126,1)=\"X\", ISBLANK(C126)), \"\", IF(C126=\"MDR01\", \"580095\", IF(OR(LEFT(C126,1)=\"B\", LEFT(C126,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[101]
[102,{"$f":"IF(OR(LEFT(C128,1)=\"X\", ISBLANK(C128)), \"\", IF(C128=\"MDR01\", \"580095\", IF(OR(LEFT(C128,1)=\"B\", LEFT(C128,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[103]
[104,{"$f":"IF(OR(LEFT(C130,1)=\"X\", ISBLANK(C130)), \"\", IF(C130=\"MDR01\", \"580095\", IF(OR(LEFT(C130,1)=\"B\", LEFT(C130,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[105]
[106,{"$f":"IF(OR(LEFT(C132,1)=\"X\", ISBLANK(C132)), \"\", IF(C132=\"MDR01\", \"580095\", IF(OR(LEFT(C132,1)=\"B\", LEFT(C132,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[107]
[108,{"$f":"IF(OR(LEFT(C134,1)=\"X\", ISBLANK(C134)), \"\", IF(C134=\"MDR01\", \"580095\", IF(OR(LEFT(C134,1)=\"B\", LEFT(C134,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[109]
[110,{"$f":"IF(OR(LEFT(C136,1)=\"X\", ISBLANK(C136)), \"\", IF(C136=\"MDR01\", \"580095\", IF(OR(LEFT(C136,1)=\"B\", LEFT(C136,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[111]
[112,{"$f":"IF(OR(LEFT(C138,1)=\"X\", ISBLANK(C138)), \"\", IF(C138=\"MDR01\", \"580095\", IF(OR(LEFT(C138,1)=\"B\", LEFT(C138,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[113]
[114,{"$f":"IF(OR(LEFT(C140,1)=\"X\", ISBLANK(C140)), \"\", IF(C140=\"MDR01\", \"580095\", IF(OR(LEFT(C140,1)=\"B\", LEFT(C140,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[115]
[116,{"$f":"IF(OR(LEFT(C142,1)=\"X\", ISBLANK(C142)), \"\", IF(C142=\"MDR01\", \"580095\", IF(OR(LEFT(C142,1)=\"B\", LEFT(C142,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[117]
[118,{"$f":"IF(OR(LEFT(C144,1)=\"X\", ISBLANK(C144)), \"\", IF(C144=\"MDR01\", \"580095\", IF(OR(LEFT(C144,1)=\"B\", LEFT(C144,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[119,null,null,null,null,null,null,"For Accounting \nUse Only",null,"For Accounting \nUse Only"]
[120,{"$f":"IF(OR(LEFT(C146,1)=\"X\", ISBLANK(C146)), \"\", IF(C146=\"MDR01\", \"580095\", IF(OR(LEFT(C146,1)=\"B\", LEFT(C146,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[121]
[122,{"$f":"IF(OR(LEFT(C148,1)=\"X\", ISBLANK(C148)), \"\", IF(C148=\"MDR01\", \"580095\", IF(OR(LEFT(C148,1)=\"B\", LEFT(C148,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[123]
[124,{"$f":"IF(OR(LEFT(C150,1)=\"X\", ISBLANK(C150)), \"\", IF(C150=\"MDR01\", \"580095\", IF(OR(LEFT(C150,1)=\"B\", LEFT(C150,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[125]
[126,{"$f":"IF(OR(LEFT(C152,1)=\"X\", ISBLANK(C152)), \"\", IF(C152=\"MDR01\", \"580095\", IF(OR(LEFT(C152,1)=\"B\", LEFT(C152,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[127]
[128,{"$f":"IF(OR(LEFT(C154,1)=\"X\", ISBLANK(C154)), \"\", IF(C154=\"MDR01\", \"580095\", IF(OR(LEFT(C154,1)=\"B\", LEFT(C154,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[129]
[130,{"$f":"IF(OR(LEFT(C156,1)=\"X\", ISBLANK(C156)), \"\", IF(C156=\"MDR01\", \"580095\", IF(OR(LEFT(C156,1)=\"B\", LEFT(C156,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[131]
[132,{"$f":"IF(OR(LEFT(C158,1)=\"X\", ISBLANK(C158)), \"\", IF(C158=\"MDR01\", \"580095\", IF(OR(LEFT(C158,1)=\"B\", LEFT(C158,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[133]
[134,{"$f":"IF(OR(LEFT(C160,1)=\"X\", ISBLANK(C160)), \"\", IF(C160=\"MDR01\", \"580095\", IF(OR(LEFT(C160,1)=\"B\", LEFT(C160,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[135]
[136,{"$f":"IF(OR(LEFT(C162,1)=\"X\", ISBLANK(C162)), \"\", IF(C162=\"MDR01\", \"580095\", IF(OR(LEFT(C162,1)=\"B\", LEFT(C162,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[137]
[138,{"$f":"IF(OR(LEFT(C164,1)=\"X\", ISBLANK(C164)), \"\", IF(C164=\"MDR01\", \"580095\", IF(OR(LEFT(C164,1)=\"B\", LEFT(C164,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[139]
[140,{"$f":"IF(OR(LEFT(C166,1)=\"X\", ISBLANK(C166)), \"\", IF(C166=\"MDR01\", \"580095\", IF(OR(LEFT(C166,1)=\"B\", LEFT(C166,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[141]
[142,{"$f":"IF(OR(LEFT(C168,1)=\"X\", ISBLANK(C168)), \"\", IF(C168=\"MDR01\", \"580095\", IF(OR(LEFT(C168,1)=\"B\", LEFT(C168,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[143]
[144,{"$f":"IF(OR(LEFT(C170,1)=\"X\", ISBLANK(C170)), \"\", IF(C170=\"MDR01\", \"580095\", IF(OR(LEFT(C170,1)=\"B\", LEFT(C170,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[145]
[146,{"$f":"IF(OR(LEFT(C172,1)=\"X\", ISBLANK(C172)), \"\", IF(C172=\"MDR01\", \"580095\", IF(OR(LEFT(C172,1)=\"B\", LEFT(C172,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[147]
[148,{"$f":"IF(OR(LEFT(C174,1)=\"X\", ISBLANK(C174)), \"\", IF(C174=\"MDR01\", \"580095\", IF(OR(LEFT(C174,1)=\"B\", LEFT(C174,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[149]
[150,{"$f":"IF(OR(LEFT(C176,1)=\"X\", ISBLANK(C176)), \"\", IF(C176=\"MDR01\", \"580095\", IF(OR(LEFT(C176,1)=\"B\", LEFT(C176,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[151]
[152,{"$f":"IF(OR(LEFT(C178,1)=\"X\", ISBLANK(C178)), \"\", IF(C178=\"MDR01\", \"580095\", IF(OR(LEFT(C178,1)=\"B\", LEFT(C178,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[153]
[154,{"$f":"IF(OR(LEFT(C180,1)=\"X\", ISBLANK(C180)), \"\", IF(C180=\"MDR01\", \"580095\", IF(OR(LEFT(C180,1)=\"B\", LEFT(C180,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[155]
[156,{"$f":"IF(OR(LEFT(C182,1)=\"X\", ISBLANK(C182)), \"\", IF(C182=\"MDR01\", \"580095\", IF(OR(LEFT(C182,1)=\"B\", LEFT(C182,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[157]
[158,{"$f":"IF(OR(LEFT(C184,1)=\"X\", ISBLANK(C184)), \"\", IF(C184=\"MDR01\", \"580095\", IF(OR(LEFT(C184,1)=\"B\", LEFT(C184,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[159]
[160,{"$f":"IF(OR(LEFT(C186,1)=\"X\", ISBLANK(C186)), \"\", IF(C186=\"MDR01\", \"580095\", IF(OR(LEFT(C186,1)=\"B\", LEFT(C186,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[161]
[162,{"$f":"IF(OR(LEFT(C188,1)=\"X\", ISBLANK(C188)), \"\", IF(C188=\"MDR01\", \"580095\", IF(OR(LEFT(C188,1)=\"B\", LEFT(C188,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[163]
[164,{"$f":"IF(OR(LEFT(C190,1)=\"X\", ISBLANK(C190)), \"\", IF(C190=\"MDR01\", \"580095\", IF(OR(LEFT(C190,1)=\"B\", LEFT(C190,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[165]
[166,{"$f":"IF(OR(LEFT(C192,1)=\"X\", ISBLANK(C192)), \"\", IF(C192=\"MDR01\", \"580095\", IF(OR(LEFT(C192,1)=\"B\", LEFT(C192,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[167]
[168,{"$f":"IF(OR(LEFT(C194,1)=\"X\", ISBLANK(C194)), \"\", IF(C194=\"MDR01\", \"580095\", IF(OR(LEFT(C194,1)=\"B\", LEFT(C194,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[169,null,null,null,null,null,null,"For Accounting \nUse Only",null,"For Accounting \nUse Only"]
[170,{"$f":"IF(OR(LEFT(C196,1)=\"X\", ISBLANK(C196)), \"\", IF(C196=\"MDR01\", \"580095\", IF(OR(LEFT(C196,1)=\"B\", LEFT(C196,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[171]
[172,{"$f":"IF(OR(LEFT(C198,1)=\"X\", ISBLANK(C198)), \"\", IF(C198=\"MDR01\", \"580095\", IF(OR(LEFT(C198,1)=\"B\", LEFT(C198,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[173]
[174,{"$f":"IF(OR(LEFT(C200,1)=\"X\", ISBLANK(C200)), \"\", IF(C200=\"MDR01\", \"580095\", IF(OR(LEFT(C200,1)=\"B\", LEFT(C200,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[175]
[176,{"$f":"IF(OR(LEFT(C202,1)=\"X\", ISBLANK(C202)), \"\", IF(C202=\"MDR01\", \"580095\", IF(OR(LEFT(C202,1)=\"B\", LEFT(C202,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[177]
[178,{"$f":"IF(OR(LEFT(C204,1)=\"X\", ISBLANK(C204)), \"\", IF(C204=\"MDR01\", \"580095\", IF(OR(LEFT(C204,1)=\"B\", LEFT(C204,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[179]
[180,{"$f":"IF(OR(LEFT(C206,1)=\"X\", ISBLANK(C206)), \"\", IF(C206=\"MDR01\", \"580095\", IF(OR(LEFT(C206,1)=\"B\", LEFT(C206,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[181]
[182,{"$f":"IF(OR(LEFT(C208,1)=\"X\", ISBLANK(C208)), \"\", IF(C208=\"MDR01\", \"580095\", IF(OR(LEFT(C208,1)=\"B\", LEFT(C208,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[183]
[184,{"$f":"IF(OR(LEFT(C210,1)=\"X\", ISBLANK(C210)), \"\", IF(C210=\"MDR01\", \"580095\", IF(OR(LEFT(C210,1)=\"B\", LEFT(C210,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[185]
[186,{"$f":"IF(OR(LEFT(C212,1)=\"X\", ISBLANK(C212)), \"\", IF(C212=\"MDR01\", \"580095\", IF(OR(LEFT(C212,1)=\"B\", LEFT(C212,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[187]
[188,{"$f":"IF(OR(LEFT(C214,1)=\"X\", ISBLANK(C214)), \"\", IF(C214=\"MDR01\", \"580095\", IF(OR(LEFT(C214,1)=\"B\", LEFT(C214,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[189]
[190,{"$f":"IF(OR(LEFT(C216,1)=\"X\", ISBLANK(C216)), \"\", IF(C216=\"MDR01\", \"580095\", IF(OR(LEFT(C216,1)=\"B\", LEFT(C216,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[191]
[192,{"$f":"IF(OR(LEFT(C218,1)=\"X\", ISBLANK(C218)), \"\", IF(C218=\"MDR01\", \"580095\", IF(OR(LEFT(C218,1)=\"B\", LEFT(C218,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[193]
[194,{"$f":"IF(OR(LEFT(C220,1)=\"X\", ISBLANK(C220)), \"\", IF(C220=\"MDR01\", \"580095\", IF(OR(LEFT(C220,1)=\"B\", LEFT(C220,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[195]
[196,{"$f":"IF(OR(LEFT(C222,1)=\"X\", ISBLANK(C222)), \"\", IF(C222=\"MDR01\", \"580095\", IF(OR(LEFT(C222,1)=\"B\", LEFT(C222,1)=\"D\"), \"580096\", \"580094\")))","v":""}]
[197]
[198,{"$f":"IF(OR(LEFT(C224,1)=\"X\", ISBLANK(C224)), \"\", IF(C224=\"MDR01\", \"580095\", IF(OR(LEFT(C224,1)=\"B\", LEFT(C224,1)=\"D\"), \"580096\", \"580094\")))","v":""}]

{"sheet":"Backup Documentation","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CCR Example","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}