{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cost of Sales","Database","Ledger","Expenses","Sheet1"],"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":"Cost of Sales","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Income Expense"]

{"sheet":"Database","index":1,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Date","Name","Group","AmountIn","Amountout","CashBank","Ser.No"]
["2020-07-06","salary","Income",1200,null,"Cash",102]
["2020-07-06","salary","Income",1000,null,"Cash",103]
["2020-07-06","salary","Income",444,null,"Bank",104]
["2020-07-06","Telecome Bill","Expense",null,120,"Cash",105]
["2020-07-06","Eng","Expense",null,1100,"Bank",106]
["2020-07-06","Telcome","Expense",null,111,"Cash",107]

{"sheet":"Ledger","index":2,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Name","Group"]
["salary","Income"]
["Eng","Expense"]
["Telcome","Expense"]
["Telecome Bill","Expense"]

{"sheet":"Expenses","index":3,"n_rows":26,"n_cols":30,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[null,"Twelve Month",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company Name"]
[null,"PROFIT & LOSS PROJECTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FISCAL YEAR :","JAN",2020]
[null,null,null,"JAN-20","FEB-20","MAR-20","APR-20","MAY-20","JUN-20","JUL-20","AUG-20","SEP-20","OCT-20","NOV-20","DEC-20","YEARLY","IND %","JAN %","FEB %","MAR %","APR %","MAY %","JUN %","JUL %","AUG %","SEP %","OCT %","NOV %","DEC %","YEAR %"]
[null,"EXPENSES","TREND","Column1","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Yearly","Index %","Jan %","Feb %","Mar %","Apr %","May %","Jun %","Jul %","Aug %","Sep %","Oct %","Nov %","Dec %","Year %"]
[null,"Salary expenses "," ",10,18,13,8,22,18,8,17,20,8,4,12,158,0.12,4.2372881355932202E-2,8.7804878048780483E-2,5.2208835341365459E-2,3.0651340996168581E-2,8.5603112840466927E-2,6.569343065693431E-2,3.007518796992481E-2,7.2340425531914887E-2,8.6956521739130432E-2,3.0888030888030889E-2,1.3513513513513514E-2,5.1948051948051951E-2,5.2684228076025338E-2]
[null,"Payroll expenses "," ",23,11,7,14,12,19,19,4,7,13,25,5,159,0.09,9.7457627118644072E-2,5.3658536585365853E-2,2.8112449799196786E-2,5.3639846743295021E-2,4.6692607003891051E-2,6.9343065693430656E-2,7.1428571428571425E-2,1.7021276595744681E-2,3.0434782608695653E-2,5.019305019305019E-2,8.4459459459459457E-2,2.1645021645021644E-2,5.3017672557519172E-2]
[null,"Outside services"," ",23,20,3,16,10,5,20,7,4,22,13,14,157,0.02,9.7457627118644072E-2,9.7560975609756101E-2,1.2048192771084338E-2,6.1302681992337162E-2,3.8910505836575876E-2,1.824817518248175E-2,7.5187969924812026E-2,2.9787234042553193E-2,1.7391304347826087E-2,8.4942084942084939E-2,4.3918918918918921E-2,6.0606060606060608E-2,5.2350783594531512E-2]
[null,"Supplies (office and operating)"," ",19,4,7,14,22,10,22,5,4,12,18,24,161,0.08,8.050847457627118E-2,1.9512195121951219E-2,2.8112449799196786E-2,5.3639846743295021E-2,8.5603112840466927E-2,3.6496350364963501E-2,8.2706766917293228E-2,2.1276595744680851E-2,1.7391304347826087E-2,4.633204633204633E-2,6.0810810810810814E-2,0.1038961038961039,5.3684561520506838E-2]
[null,"Repairs and maintenance"," ",11,11,17,12,2,14,12,10,18,11,23,11,152,0.03,4.6610169491525424E-2,5.3658536585365853E-2,6.8273092369477914E-2,4.5977011494252873E-2,7.7821011673151752E-3,5.1094890510948905E-2,4.5112781954887216E-2,4.2553191489361701E-2,7.8260869565217397E-2,4.2471042471042469E-2,7.77027027027027E-2,4.7619047619047616E-2,5.0683561187062354E-2]
[null,"Advertising"," ",2,16,6,13,11,22,21,3,12,7,17,20,150,0.15,8.4745762711864406E-3,7.8048780487804878E-2,2.4096385542168676E-2,4.9808429118773943E-2,4.2801556420233464E-2,8.0291970802919707E-2,7.8947368421052627E-2,1.276595744680851E-2,5.2173913043478258E-2,2.7027027027027029E-2,5.7432432432432436E-2,8.6580086580086577E-2,5.0016672224074694E-2]
[null,"Car, delivery and travel"," ",8,17,11,11,21,9,20,3,14,22,16,12,164,0.12,3.3898305084745763E-2,8.2926829268292687E-2,4.4176706827309238E-2,4.2145593869731802E-2,8.171206225680934E-2,3.2846715328467155E-2,7.5187969924812026E-2,1.276595744680851E-2,6.0869565217391307E-2,8.4942084942084939E-2,5.4054054054054057E-2,5.1948051948051951E-2,5.468489496498833E-2]
[null,"Accounting and legal"," ",5,13,6,15,19,10,12,9,15,16,4,9,133,0.09,2.1186440677966101E-2,6.3414634146341464E-2,2.4096385542168676E-2,5.7471264367816091E-2,7.3929961089494164E-2,3.6496350364963501E-2,4.5112781954887216E-2,3.8297872340425532E-2,6.5217391304347824E-2,6.1776061776061778E-2,1.3513513513513514E-2,3.896103896103896E-2,4.4348116038679559E-2]
[null,"Rent"," ",8,4,23,25,10,24,22,5,12,24,24,12,193,0.01,3.3898305084745763E-2,1.9512195121951219E-2,9.2369477911646583E-2,9.5785440613026823E-2,3.8910505836575876E-2,8.7591240875912413E-2,8.2706766917293228E-2,2.1276595744680851E-2,5.2173913043478258E-2,9.2664092664092659E-2,8.1081081081081086E-2,5.1948051948051951E-2,6.4354784928309441E-2]
[null,"Telephone"," ",25,2,12,25,10,24,3,20,3,9,20,18,171,0.01,0.1059322033898305,9.7560975609756097E-3,4.8192771084337352E-2,9.5785440613026823E-2,3.8910505836575876E-2,8.7591240875912413E-2,1.1278195488721804E-2,8.5106382978723402E-2,1.3043478260869565E-2,3.4749034749034749E-2,6.7567567567567571E-2,7.792207792207792E-2,5.7019006335445148E-2]
[null,"Utilities"," ",16,19,9,16,13,2,4,24,16,22,7,18,166,0.01,6.7796610169491525E-2,9.2682926829268292E-2,3.614457831325301E-2,6.1302681992337162E-2,5.0583657587548639E-2,7.2992700729927005E-3,1.5037593984962405E-2,0.10212765957446808,6.9565217391304349E-2,8.4942084942084939E-2,2.364864864864865E-2,7.792207792207792E-2,5.5351783927975989E-2]
[null,"Insurance"," ",12,9,16,19,25,17,20,14,5,14,5,2,158,0.01,5.0847457627118647E-2,4.3902439024390241E-2,6.4257028112449793E-2,7.2796934865900387E-2,9.727626459143969E-2,6.2043795620437957E-2,7.5187969924812026E-2,5.9574468085106386E-2,2.1739130434782608E-2,5.4054054054054057E-2,1.6891891891891893E-2,8.658008658008658E-3,5.2684228076025338E-2]
[null,"Taxes (real estate, etc.)"," ",16,13,10,7,13,3,13,17,9,4,22,18,145,0.14000000000000001,6.7796610169491525E-2,6.3414634146341464E-2,4.0160642570281124E-2,2.681992337164751E-2,5.0583657587548639E-2,1.0948905109489052E-2,4.8872180451127817E-2,7.2340425531914887E-2,3.9130434782608699E-2,1.5444015444015444E-2,7.4324324324324328E-2,7.792207792207792E-2,4.8349449816605536E-2]
[null,"Interest"," ",3,2,19,21,13,9,7,13,3,6,10,13,119,0.06,1.2711864406779662E-2,9.7560975609756097E-3,7.6305220883534142E-2,8.0459770114942528E-2,5.0583657587548639E-2,3.2846715328467155E-2,2.6315789473684209E-2,5.5319148936170209E-2,1.3043478260869565E-2,2.3166023166023165E-2,3.3783783783783786E-2,5.627705627705628E-2,3.9679893297765924E-2]
[null,"Depreciation"," ",8,7,6,7,7,6,15,23,21,16,19,7,142,0.01,3.3898305084745763E-2,3.4146341463414637E-2,2.4096385542168676E-2,2.681992337164751E-2,2.7237354085603113E-2,2.1897810218978103E-2,5.6390977443609019E-2,9.7872340425531917E-2,9.1304347826086957E-2,6.1776061776061778E-2,6.4189189189189186E-2,3.0303030303030304E-2,4.7349116372124044E-2]
[null,"Other expenses (specify)"," ",14,4,24,6,20,14,21,20,22,3,14,6,168,0.01,5.9322033898305086E-2,1.9512195121951219E-2,9.6385542168674704E-2,2.2988505747126436E-2,7.7821011673151752E-2,5.1094890510948905E-2,7.8947368421052627E-2,8.5106382978723402E-2,9.5652173913043481E-2,1.1583011583011582E-2,4.72972972972973E-2,2.5974025974025976E-2,5.6018672890963656E-2]
[null,"Other expenses (specify)"," ",14,7,24,10,7,24,2,11,21,19,19,20,178,0.01,5.9322033898305086E-2,3.4146341463414637E-2,9.6385542168674704E-2,3.8314176245210725E-2,2.7237354085603113E-2,8.7591240875912413E-2,7.5187969924812026E-3,4.6808510638297871E-2,9.1304347826086957E-2,7.3359073359073365E-2,6.4189189189189186E-2,8.6580086580086577E-2,5.9353117705901966E-2]
[null,"Other expenses (specify)"," ",11,8,25,11,9,24,13,14,19,24,15,7,180,0.01,4.6610169491525424E-2,3.9024390243902439E-2,0.10040160642570281,4.2145593869731802E-2,3.5019455252918288E-2,8.7591240875912413E-2,4.8872180451127817E-2,5.9574468085106386E-2,8.2608695652173908E-2,9.2664092664092659E-2,5.0675675675675678E-2,3.0303030303030304E-2,6.0020006668889632E-2]
[null,"Misc. (unspecified)"," ",8,20,11,11,11,20,12,16,5,7,21,3,145,0.02,3.3898305084745763E-2,9.7560975609756101E-2,4.4176706827309238E-2,4.2145593869731802E-2,4.2801556420233464E-2,7.2992700729927001E-2,4.5112781954887216E-2,6.8085106382978725E-2,2.1739130434782608E-2,2.7027027027027029E-2,7.0945945945945943E-2,1.2987012987012988E-2,4.8349449816605536E-2]
[null,"TOTAL EXPENSES"," ",236,205,249,261,257,274,266,235,230,259,296,231,2999,1,1,1.0000000000000002,1.0000000000000002,1,1.0000000000000002,1,1,0.99999999999999989,1,1,0.99999999999999989,1,0.99999999999999989]
[]
[null,"Net Profit",null,123,175,256,109,156,-8,32,214,100,148,179,359,1843,null,6.6739012479652735E-2,9.4953879544221381E-2,0.13890396093326099,5.9142702116115033E-2,8.4644601193705912E-2,-4.3407487791644059E-3,1.7362995116657624E-2,0.11611502984264786,5.425935973955507E-2,8.0303852414541507E-2,9.7124253933803584E-2,0.19479110146500273,1]

{"sheet":"Sheet1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}