Localization analysis of agricultural and forest industries in the Russian Federation
Analysis of evaluation methods of localization. The influence of localization of firms on its economic performance. Development of cluster analysis to search for new ways to support enterprises in the conditions of stagnation of economy in Russia.
30.08.2016 | |
2,4 M |
. ,
, , , , .
[279] Depreciation.th.RUB.2012
[280] Depreciation.th.RUB.2011
[281] Depreciation.th.RUB.2010
[282] Depreciation.th.RUB.2009
[283] Depreciation.th.RUB.2008
[284] Depreciation.th.RUB.2007
[285] Depreciation.th.RUB.2006
[286] Depreciation.th.RUB.2005
[287] Depreciation.th.RUB.2004
[288] Interest.Paid.th.RUB.2013
[289] Interest.Paid.th.RUB.2012
[290] Interest.Paid.th.RUB.2011
[291] Interest.Paid.th.RUB.2010
[292] Interest.Paid.th.RUB.2009
[293] Interest.Paid.th.RUB.2008
[294] Interest.Paid.th.RUB.2007
[295] Interest.Paid.th.RUB.2006
[296] Interest.Paid.th.RUB.2005
[297] Interest.Paid.th.RUB.2004
[298] Intangible.assets.th.RUB.2013
[299] Intangible.assets.th.RUB.2012
[300] Intangible.assets.th.RUB.2011
[301] Intangible.assets.th.RUB.2010
[302] Intangible.assets.th.RUB.2009
[303] Intangible.assets.th.RUB.2008
[304] Intangible.assets.th.RUB.2007
[305] Intangible.assets.th.RUB.2006
[306] Intangible.assets.th.RUB.2005
[307] Intangible.assets.th.RUB.2004
[308] Research.and.development.results.th.RUB.2013
[309] Research.and.development.results.th.RUB.2012
[310] Research.and.development.results.th.RUB.2011
[311] Research.and.development.results.th.RUB.2010
[312] Research.and.development.results.th.RUB.2009
[313] Research.and.development.results.th.RUB.2008
[314] Research.and.development.results.th.RUB.2007
[315] Research.and.development.results.th.RUB.2006
[316] Research.and.development.results.th.RUB.2005
[317] Research.and.development.results.th.RUB.2004
[318] Intangible.research.assets.th.RUB.2013
[319] Intangible.research.assets.th.RUB.2012
[320] Intangible.research.assets.th.RUB.2011
[321] Intangible.research.assets.th.RUB.2010
[322] Intangible.research.assets.th.RUB.2009
[323] Intangible.research.assets.th.RUB.2008
[324] Intangible.research.assets.th.RUB.2007
[325] Intangible.research.assets.th.RUB.2006
[326] Intangible.research.assets.th.RUB.2005
[327] Intangible.research.assets.th.RUB.2004
[328] Tangible.research.assets.th.RUB.2013
[329] Tangible.research.assets.th.RUB.2012
[330] Tangible.research.assets.th.RUB.2011
[331] Tangible.research.assets.th.RUB.2010
[332] Tangible.research.assets.th.RUB.2009
[333] Tangible.research.assets.th.RUB.2008
[334] Tangible.research.assets.th.RUB.2007
[335] Tangible.research.assets.th.RUB.2006
[336] Tangible.research.assets.th.RUB.2005
[337] Tangible.research.assets.th.RUB.2004
[338] Fixed.assets.th.RUB.2011
[339] Fixed.assets.th.RUB.2012
[340] Fixed.assets.th.RUB.2013
[341] Income.investments.in.real.stocks.of.materials.th.RUB.2013
[342] Income.investments.in.real.stocks.of.materials.th.RUB.2012
[343] Income.investments.in.real.stocks.of.materials.th.RUB.2011
[344] Income.investments.in.real.stocks.of.materials.th.RUB.2010
[345] Income.investments.in.real.stocks.of.materials.th.RUB.2009
[346] Income.investments.in.real.stocks.of.materials.th.RUB.2008
[347] Income.investments.in.real.stocks.of.materials.th.RUB.2007
[348] Income.investments.in.real.stocks.of.materials.th.RUB.2006
[349] Income.investments.in.real.stocks.of.materials.th.RUB.2005
[350] Income.investments.in.real.stocks.of.materials.th.RUB.2004
[351] Value.added.tax.for.acquired.value.th.RUB.2013
[352] Value.added.tax.for.acquired.value.th.RUB.2012
[353] Value.added.tax.for.acquired.value.th.RUB.2011
[354] Value.added.tax.for.acquired.value.th.RUB.2010
[355] Value.added.tax.for.acquired.value.th.RUB.2009
[356] Value.added.tax.for.acquired.value.th.RUB.2008
[357] Value.added.tax.for.acquired.value.th.RUB.2007
[358] Value.added.tax.for.acquired.value.th.RUB.2006
[359] Value.added.tax.for.acquired.value.th.RUB.2005
[360] Value.added.tax.for.acquired.value.th.RUB.2004
[361] Investments.of.money..excluding.cash.equivalents..th.RUB.2013
[362] Investments.of.money..excluding.cash.equivalents..th.RUB.2012
[363] Investments.of.money..excluding.cash.equivalents..th.RUB.2011
[364] Investments.of.money..excluding.cash.equivalents..th.RUB.2010
[365] Investments.of.money..excluding.cash.equivalents..th.RUB.2009
[366] Investments.of.money..excluding.cash.equivalents..th.RUB.2008
[367] Investments.of.money..excluding.cash.equivalents..th.RUB.2007
[368] Investments.of.money..excluding.cash.equivalents..th.RUB.2006
[369] Investments.of.money..excluding.cash.equivalents..th.RUB.2005
[370] Investments.of.money..excluding.cash.equivalents..th.RUB.2004
[371] Estimated.liabilities.th.RUB.2013
[372] Estimated.liabilities.th.RUB.2012
[373] Estimated.liabilities.th.RUB.2011
[374] Estimated.liabilities.th.RUB.2010
[375] Estimated.liabilities.th.RUB.2009
[376] Estimated.liabilities.th.RUB.2008
[377] Estimated.liabilities.th.RUB.2007
[378] Estimated.liabilities.th.RUB.2006
[379] Estimated.liabilities.th.RUB.2005
[380] Estimated.liabilities.th.RUB.2004
[381] BALANCE..passive..th.RUB.2013
[382] BALANCE..passive..th.RUB.2012
[383] BALANCE..passive..th.RUB.2011
[384] BALANCE..passive..th.RUB.2010
[385] BALANCE..passive..th.RUB.2009
[386] BALANCE..passive..th.RUB.2008
[387] BALANCE..passive..th.RUB.2007
[388] BALANCE..passive..th.RUB.2006
[389] BALANCE..passive..th.RUB.2005
[390] BALANCE..passive..th.RUB.2004
[391] payment.of.wages..for.the.accounting.period..th.RUB.2005
[392] payment.of.wages..for.the.accounting.period..th.RUB.2004
[393] payment.of.wages..for.the.accounting.period..th.RUB.2003
[394] Cash.for..payment.for.purchased.goods..works..services..raw.materials.and.other.current.assets..for.the.accounting.period..th.RUB.2005
[395] Cash.for..payment.for.purchased.goods..works..services..raw.materials.and.other.current.assets..for.the.accounting.period..th.RUB.2004
[396] Cash.for..payment.for.purchased.goods..works..services..raw.materials.and.other.current.assets..for.the.accounting.period..th.RUB.2003
[397] Purchase.of.fixed.assets..profitable.investments.in.current.assets.and.noncurrent.assets..for.the.accounting.period..th.RUB.2005
[398] Purchase.of.fixed.assets..profitable.investments.in.current.assets.and.noncurrent.assets..for.the.accounting.period..th.RUB.2004
[399] Purchase.of.fixed.assets..profitable.investments.in.current.assets.and.noncurrent.assets..for.the.accounting.period..th.RUB.2003
[400] Cash.for..payment.for.purchased.goods..works..services..raw.materials.and.other.current.assets..for.the.accounting.period..th.RUB.2010
[401] Cash.for..payment.for.purchased.goods..works..services..raw.materials.and.other.current.assets..for.the.accounting.period..th.RUB.2009
[402] Cash.for..payment.for.purchased.goods..works..services..raw.materials.and.other.current.assets..for.the.accounting.period..th.RUB.2008
[403] Cash.for..payment.for.purchased.goods..works..services..raw.materials.and.other.current.assets..for.the.accounting.period..th.RUB.2007
[404] Cash.for..payment.for.purchased.goods..works..services..raw.materials.and.other.current.assets..for.the.accounting.period..th.RUB.2006
[405] payment.of.wages..for.the.accounting.period..th.RUB.2010
[406] payment.of.wages..for.the.accounting.period..th.RUB.2009
[407] payment.of.wages..for.the.accounting.period..th.RUB.2008
[408] payment.of.wages..for.the.accounting.period..th.RUB.2007
[409] payment.of.wages..for.the.accounting.period..th.RUB.2006
[410] Purchase.of.fixed.assets..profitable.investments.in.current.assets.and.noncurrent.assets..for.the.accounting.period..th.RUB.2010
[411] Purchase.of.fixed.assets..profitable.investments.in.current.assets.and.noncurrent.assets..for.the.accounting.period..th.RUB.2009
[412] Purchase.of.fixed.assets..profitable.investments.in.current.assets.and.noncurrent.assets..for.the.accounting.period..th.RUB.2008
[413] Purchase.of.fixed.assets..profitable.investments.in.current.assets.and.noncurrent.assets..for.the.accounting.period..th.RUB.2007
[414] Purchase.of.fixed.assets..profitable.investments.in.current.assets.and.noncurrent.assets..for.the.accounting.period..th.RUB.2006
[415] expenses.for.labor.costs.th.RUB.2013
[416] expenses.for.labor.costs.th.RUB.2012
[417] expenses.for.labor.costs.th.RUB.2011
[418] suppliers..contract.acceptors..for..raw.products..materials..works..services.th.RUB.2013
[419] suppliers..contract.acceptors..for..raw.products..materials..works..services.th.RUB.2012
[420] suppliers..contract.acceptors..for..raw.products..materials..works..services.th.RUB.2011
[421] acquisition..creation..modernization..reorganization.and..preparation.for.use.of.non.current.assets.th.RUB.2013
[422] acquisition..creation..modernization..reorganization.and..preparation.for.use.of.non.current.assets.th.RUB.2012
[423] acquisition..creation..modernization..reorganization.and..preparation.for.use.of.non.current.assets.th.RUB.2011
[424] Registration.number..OGRN.
[425] Company.name..short.
[426] Address
[427] Postcode
[428] City
[429] Region
[430] Country
[431] Date.of.address.information
[432] Legal.street.name
[433] Legal.street.number
[434] Legal.postcode
[435] Legal.city
[436] Legal.region
[437] Operating.street.name
[438] Operating.street.number
[439] Operating.Postcode
[440] Operating.city
[441] Operating.region
[442] Postal.street.name
[443] Postal.street.number
[444] Postal.postcode
[445] Postal.city
[446] Postal.region
[447] Status
[448] Status.Date
[449] Legal.form
[450] Date.of.incorporation
[451] Last.year
[452] Bankruptcy.message.date
[453] No.of.companies.in.corporate.group
[454] Size
[455] Importing.activities
[456] Exporting.activities
[457] OKVED.2008..primary.code
[458] OKVED.2008..secondary.code.s.
[459] OKED.2007..primary.code
[460] KVED.2010..primary.code
[461] Industry.text
[462] GUO...First.name
[463] GUO...Last.name
Summary of agriculture sector firms data
X........Size |
X...............................................................................................Status |
||
1 |
Very large: 69705 |
Active :649106 |
|
2 |
Large :100759 |
Liquidated :224975 |
|
3 |
Medium :103100 |
Removed from the State Register of Legal Persons under p.2 sec.21.1 of FL from 08.08.2001 #129-NL :188541 |
|
4 |
Small : 99860 |
Liquidated as a result of bankruptcy : 81299 |
|
5 |
: 40286 |
Ceasing operations due to change of status from head of farm enterprise to individual entrepreneur: 41734 |
|
6 |
NA's :860007 |
Process of being wound up : 38726 |
|
7 |
NA |
(Other) : 49336 |
Summary of forestry sector firms data
1 |
Large : 12117 |
Active :123858 |
|
2 |
Medium : 18242 |
Removed from the State Register of Legal Persons under p.2 sec.21.1 of FL from 08.08.2001 #129-NL: 73020 |
|
3 |
Very large: 6413 |
Liquidated : 36186 |
|
4 |
Small : 22277 |
Liquidated as a result of bankruptcy : 13558 |
|
5 |
: 9958 |
Process of being wound up : 5747 |
|
6 |
NA's :198717 |
Ceased operations by accession : 5728 |
|
7 |
NA |
(Other) : 9627 |
Visual basics scripts
1
Sub CombineWorkbooks()
Dim FilesToOpen
Dim x As Integer
Application.ScreenUpdating = False '
'
FilesToOpen = Application.GetOpenFilename _
(FileFilter:=All files (*.*), *.*, _
MultiSelect:=True, Title:=Files to Merge)
If TypeName(FilesToOpen) = Boolean Then
MsgBox !
Exit Sub
End If
'
x = 1
While x <= UBound(FilesToOpen)
Set importWB = Workbooks.Open(Filename:=FilesToOpen(x))
Sheets().Copy After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)
importWB.Close savechanges:=False
x = x + 1
Wend
Application.ScreenUpdating = True
End Sub
2
01 |
Sub Aaz() |
02 |
Dim x As Worksheet, s As String |
03 |
04 |
s = ActiveWorkbook.Name |
05 |
s = Left(s, InStrRev(s, ., , vbTextCompare) - 1) ' |
06 |
s = ActiveWorkbook.Path & \ & s & _ |
07 |
For Each x In Worksheets |
08 |
x.SaveAs s & x.Name & .txt, xlCSV |
09 |
Next |
10 |
11 |
End Sub |
cripts
3
for(i in 1:23) {
infile1 <- paste(Microsoft Excel Worksheet_020_,i,.csv,sep=)
outfile <- paste(f015_,i,_lh.csv,sep=)
x <- read.csv(infile1,sep=,)
x<-x[,c(3,4,55,426:428,431,457,458)]
write.csv(x,outfile)
}
4
filenames <- list.files(pattern =.csv)
x<-do.call(rbind, lapply(filenames, read.csv, header = TRUE))
5
#############################################################
# (1) PREPARE
#############################################################
install.packages(RCurl)
install.packages(RJSONIO)
install.packages(plyr)
library(RCurl)
library(RJSONIO)
library(plyr)
setwd(D:/start)
file<-read.csv(3.csv)
geoUrl <- function(address,postcode){
root <- http://maps.googleapis.com/maps/api/geocode/json?
u <- paste(root,address=,address,&components=postal_code:,postcode,|country:RU, sep=)
return(URLencode(u))
}
geoCode <- function (d){
u <- geoUrl(d[1],d[2])
if(url.exists(u)){
doc <- getURL(u)
x <- fromJSON(doc, simplify = F)
if(x$status==OK){
formatted_address<-x$results[[1]]$formatted_address
lat<-x$results[[1]]$geometry$location$lat
lng<-x$results[[1]]$geometry$location$lng
location_type<-x$results[[1]]$geometry$location_type
#partial_match<-x$results[[1]]$partial_match
types<-x$results[[1]]$types[[1]]
Sys.sleep(rnorm(1,mean=10,sd=2))
#close(con)
return(c(formatted_address,lat,lng,location_type,types,x$status))
}else
return(c(NA,NA,NA,NA,NA,x$status))
}}
m<-as.matrix(file[,c(full_address,postcode)])
matrixList<-lapply(1:nrow(m),function(i) m[i,,drop=F])
matrixSplitList<-split(m,1:nrow(m))
locations<-ldply(matrixSplitList,function(x) geoCode(x))
names(locations)<-c(id,formatted_address,lat,lng,location_type,types,status)
write.csv(locations,ready_file3.csv,row.names=F)
6
library(stringr)
library(jsonlite)
library(rvest)
# лелаем вектор из адресов
x<-read.csv(part1.csv)
x[is.na(x)] <-
places<-paste(x$City, x$Address,x$Postcode,sep= )
query = str_c(http://geocode-maps.yandex.ru/1.x/?format=json&geocode=, places, &results=1)
query = str_replace_all(query, , %20)
result = data.frame(place = places, lon = NA, lat = NA)
for(i in 1:length(query)){
temp = jsonlite::fromJSON(as.character(query[i]))
temp = str_split_fixed(temp[[1]]$response$GeoObjectCollection$featureMember$GeoObject$Point, , n = 2)
if(length(temp) > 1){
result$lon[i] = temp[,1]
result$lat[i] = temp[,2]
}
}
write.csv2(result, ./result4.csv, row.names = F)
Allbest.ru
General characteristic of the LLC DTEK Zuevskaya TPP and its main function. The history of appearance and development of the company. Characteristics of the organizational management structure. Analysis of financial and economic performance indicators.
[4,2 M], 22.05.2015The major structural elements of economic safety of a national economy branches. The structural analysis of economic activity. Share of wages in , of productivity of Russia and western countries. The essence of the economic taxes and their purpose.
[166,3 K], 12.04.2012Stereotypes that influence on economic relations between the European Union countries and Russia. Consequences of influence of stereotypes on economic relations between EU and Russia. Results of first attempts solving problem. General conclusion.
[19,0 K], 19.11.2007The stock market and economic growth: theoretical and analytical questions. Analysis of the mechanism of the financial market on the efficient allocation of resources in the economy and to define the specific role of stock market prices in the process.
[5,3 M], 07.07.2013Socio-economic and geographical description of the United states of America. Analysis of volumes of export and import of the USA. Development and state of agroindustrial complex, industry and sphere of services as basic sectors of economy of the USA.
[264,5 K], 06.06.2014Evolutionary and revolutionary ways of development of mankind. Most appreciable for mankind by stages of development of a civilization. The disclosing of secret of genome of the man. Recession in an economy and in morality in Russia. Decision of problems.
[12,1 K], 12.04.2012The essence of economic efficiency and its features determination in grain farming. Methodology basis of analysis and efficiency of grain. Production resources management and use. Dynamics of grain production. The financial condition of the enterprise.
[70,0 K], 02.07.2011Directions of activity of enterprise. The organizational structure of the management. Valuation of fixed and current assets. Analysis of the structure of costs and business income. Proposals to improve the financial and economic situation of the company.
[1,3 M], 29.10.2014The air transport system in Russia. Project on the development of regional air traffic. Data collection. Creation of the database. Designing a data warehouse. Mathematical Model description. Data analysis and forecasting. Applying mathematical tools.
[316,2 K], 20.03.2016Concept of competitiveness and competition, models. Russias endowment. Engendered structural dominance and performance. The state of Russian competitiveness according to the Global Competitiveness Index. Place in the world, main growth in detail.
[1,2 M], 28.05.2014