{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Budget Upload","Error Codes","Nature of Activity","Account code","Cost Type"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":64,"n_cols":5,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Sr.No","Instructions","AUD","Accenture-AUS","CAPEX/PRJ"]
[null,null,"BRL","ACCENTURE-IND","OPEX/OPS"]
[null,"DO'S","CHF","Accenture-UK","OPEX/PRJ"]
[1,"Update Budget Numbers with positive values and numbers till two decimals are allowed","EUR","ACORA"]
[2,"Please save the template with .xlsm format","GBP","ADAPTIT"]
[3,"Budget can be done for future year only","INR","ADNM"]
[4,"Column headers highlighted in “Blue”, will only get validated and updated. Corresponding values will be updated from Master data table","SGD","ALAKAZAM"]
[null,"·   Cost Category","USD","All_Vendor"]
[null,"·   Account Code","ZAR","AlphaCreations"]
[null,"·   Capex/Opex",null,"ALTRAN"]
[null,"·   Cost Type",null,"BLACKWHOLE"]
[null,"·   Account Code Name",null,"BSIL"]
[null,"·   Cost Center Number",null,"Catalina Huanca"]
[null,"·   Cost Code Name",null,"Civica"]
[null,"·   Location",null,"CloudSense"]
[null,"·   Currency",null,"Codewords"]
[null,"·   Q4 CY 2018",null,"COGNIZANT"]
[null,"·   Q1 CY 2019",null,"CYBERA"]
[null,"·   Q2 CY 2019",null,"DAVIDFRUCTUOSO"]
[null,"·   Q3 CY 2019",null,"DELOITTE-RSA"]
[null,"·   Q4 CY 2019",null,"DELOITTE-SA"]
[null,"·   Comment",null,"EMTEC"]
[null,null,null,"ENINSY"]
[null,null,null,"Extended Content Solutions"]
[null,"DONT'S",null,"FLOW-CAL"]
[1,"Do not modify the column sequence",null,"Genesi Network"]
[2,"Do not modify column headers",null,"Godrej Infotech"]
[null,null,null,"Gresham"]
[null,null,null,"HARMAN CONNECTED SERVICES AB "]
[null,null,null,"Hudson"]
[null,null,null,"Infor"]
[null,null,null,"INNTELIA"]
[null,null,null,"IPM"]
[null,null,null,"KCP-USA"]
[null,null,null,"KIMSA"]
[null,null,null,"LANDESK"]
[null,null,null,"LOMOSOFTGMBH"]
[null,null,null,"Matsa"]
[null,null,null,"McManus Consulting (Pty) Ltd"]
[null,null,null,"MEGA"]
[null,null,null,"MERCURY TECH"]
[null,null,null,"Mexia Consulting Pty Ltd"]
[null,null,null,"MICROSOFT- IRE"]
[null,null,null,"Navis"]
[null,null,null,"NCC Group Security Services Limited"]
[null,null,null,"NETERIS"]
[null,null,null,"NIIT"]
[null,null,null,"OnActuate"]
[null,null,null,"Prodware"]
[null,null,null,"Quick Solution"]
[null,null,null,"Salesforce"]
[null,null,null,"SEIDOR"]
[null,null,null,"SERENE"]
[null,null,null,"Strategic Outsourced Solutions"]
[null,null,null,"STRATEGIX"]
[null,null,null,"TCS"]
[null,null,null,"TCS-Uruguay"]
[null,null,null,"TELSTRA"]
[null,null,null,"THEINTERFACE"]
[null,null,null,"Trafigura"]
[null,null,null,"Tricentis"]
[null,null,null,"VEROSOFT"]
[null,null,null,"WINCORNIXDORF"]
[null,null,null,"Y&P"]

{"sheet":"Budget Upload","index":1,"n_rows":1,"n_cols":29,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Cost Category","Cost Category Code","Account Code","Account Code Name","Capex/Opex","Cost Type","Cost Code","Cost Code Name","Cost Center Number","Cost Center Name","Asset Category","Location","Currency","2018 Budget LCY","2018 Actual LCY","2018 Forecast LCY","2018 Budget USD","2018 Actual USD","2018 Forecast USD","Q4 CY 2018","Q1 CY 2019","Q2 CY 2019","Q3 CY 2019","Q4 CY 2019","2019 Traf Budget LCY","2019 Puma Budget LCY","2019 Traf Budget USD","2019 Puma Budget USD","Comment"]

{"sheet":"Error Codes","index":2,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Error Code","Error Description"]
["ErrorCode-141","Only Excel file type is allowed (.xls, .xlsx, .xlsm)."]
["ErrorCode-142","Cost Centre field cannot be blank."]
["ErrorCode-143","Cost category field cannot be blank."]
["ErrorCode-144","Account code field cannot be blank"]
["ErrorCode-145","Cost type field cannot be blank."]
["ErrorCode-146","Account code name field cannot be blank."]
["ErrorCode-147","Cost Code Name field cannot be blank."]
["ErrorCode-148","Location field cannot be blank."]
["ErrorCode-149","Currency field cannot be blank."]
["ErrorCode-150","Budget quarters values cannot be blank."]
["ErrorCode-151","Incorrect Cost Centre {0} entered."]
["ErrorCode-152","Incorrect Cost category {0} entered."]
["ErrorCode-153","Incorrect Account code {0} entered."]
["ErrorCode-154","Incorrect Cost type {0} entered."]
["ErrorCode-155","Incorrect Account code name {0} entered."]
["ErrorCode-156","Incorrect Cost Code Name {0} entered."]
["ErrorCode-157","Incorrect Currency {0} entered."]
["ErrorCode-158","In Budget Quarters, only Positive numbers with integer and 2 decimal float values are allowed."]
["ErrorCode-159","Only 500 char length allowed in comment field."]
["ErrorCode-160","Only 100 char allowed in location field."]
["ErrorCode-161","Cost Centre {0} is not active."]
["ErrorCode-162","Cost category {0} is not mapped with Cost type category {1} of {2} Cost Centre."]
["ErrorCode-163","Account code {0} is not mapped with GL Code of  {1} billed company, {2} Cost category."]
["ErrorCode-164","Cost type {0} is not mapped with GL Code of  {1} billed company, {2} Cost category and account code {3}."]
["ErrorCode-165","Account code name {0} is not mapped with GL Code of {1} billed company, {2} Cost category ,account code {3} and Cost type {4}."]
["ErrorCode-166","Cost Code Name {0} is not active."]
["ErrorCode-167","Max value of quarters budget is 999999999 or 999999999.99."]
["ErrorCode-168","You are not authorised to submit Budget of this cost centre."]
["ErrorCode-169","Budget is finalized for {0} Cost Centre. Can’t upload the same."]
["ErrorCode-170","Duplicate record in uploaded file."]
["ErrorCode-171","Error in ValidateRecords() of BudgetValidationRules while reading master data."]
["ErrorCode-172","Budgeting cannot be done for {0} year."]
["ErrorCode-173","Cost type category field cannot be blank."]
["ErrorCode-174","Incorrect Cost type category {0} entered."]
["ErrorCode-175","Cost type category '{0}' does not matched with cost centre cost type category."]

{"sheet":"Nature of Activity","index":3,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Cost Category",null,"Cost Category","Account Code",null,null,"Cost Center Number"]

{"sheet":"Account code","index":4,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Cost Category","Account Code","Account Code Name"]

{"sheet":"Cost Type","index":5,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Cost Category","Account Code","Cost Type"]