Is there an alternative to Excel?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
37 views
There is a large database that holds a whole bunch of calculations and consists of tens of thousands of cells.
Now it is made in Excel. With so many values for excel periodically hangs very much at all, especially when adding new data.

The essence of the database:
there are several excel workbooks with source data (the list of clients, one with the financial performance of customers and one with the remaining funds). In excele in another book, on the basis of these data are sample data with which the calculations are made. We have an important calculation accuracy. A lot of calculations and formulas there are obtained very large since it is necessary to calculate some indicators, and based on them to calculate the following indicators of these indicators to make the required sample, and again calculate the following indicators =_=
The result is several pivot tables that are needed for clarity of data presentation. Then it should be built graphs and reports are generated.

Here is the question is the more...advanced, that, if...you can replace Excel. Considered as a variant of Access, but it's hard to realize the work with data and with calculations of sophisticated indicators there are problems. In addition, the visibility of reports in pivot tables and the ability to use custom filters. And also add new data to table with the source data, and to process the recalculation of the indicators were automated.
by | 37 views

4 Answers

0 like 0 dislike
try Power BI, it is designed to work with large amount of data
by
0 like 0 dislike
There are a few basic tips that will help to optimize, VBA macros (if you are interested in this path, write, later, to throw off, though may be able to find on the toaster or stackoverflow), making them faster, but still excel is not about the bigdata. Even solving the problem now, you come back to it in six months. And when excel ends, development begins.
What you need (stop solution):
1. Database(there are very effectively kept and tsiferki bukovki), for example postgreSQL
Backend - the backend with all the calculations, as well as integration into other services (e.g., 1s, Google Analytics, a website with the weather) you can write for example in Python
The frontend is a beautiful page in the browser, which is convenient to enter data and where it is convenient to watch, for example angularjs+html
Advantage of this solution is the ease of changes and improvements. Disadvantage - large attachments, as developers cost money and for a couple of hours it will not write. There are also many other advantages but they are then, if you're interested - now with your phone uncomfortable

Interim solution - excel as a frontend and the database, write the logic in Python or even C sharp(or any other PL which out of the box presented in msvs - they have good integration with microsoft products, including excel), everything is considered to be faster. But still get a bike with crutches for the disabled. And not be some advantages that I haven't mentioned.
It also costs money, but is very conditional in 10-70% of the first option
by
0 like 0 dislike
It is not Excel, and perhaps in the levels of possession? In other systems, too, no magic methods "work quickly, what I wrote crooked". There are always bottlenecks. I have to find them and eliminate.
For Excel is probably the most simple solution would be the introduction of intermediate tables, which will be counted rare. Not to open a bunch of files and not do a bunch of operations constantly.
I did once verification of goods in Excel. 50 price suppliers 100k of goods, and the output csv c current stock and prices to download the cms.
by
0 like 0 dislike
1C is a component "Calculation" it is possible such to solve the problem efficiently.
by

Related questions

0 like 0 dislike
4 answers
0 like 0 dislike
1 answer
asked Aug 17, 2019 by den234624234642
0 like 0 dislike
7 answers
0 like 0 dislike
1 answer
110,608 questions
257,187 answers
0 comments
40,796 users