Cloud or In-house [closed]
I am assigned a task to find a way to reduce the computing cost. We are using AWS at the moment.
The work we do involves a lot of calculation in excel spreadsheets using VBA modules. The result will be inserted into database.
My question is that is it common for companies that do a lot of excel calculations to have their own dedicate computing server in house? Is it in general worth investigating as a cost saving method?
A bit extra information to make my question more relevant.
1. Our db size is about 4tb. It is not very big in some sense but it contains a lot of rows. Some of tables have 1000000000+ rows.
2. Each excel run would process 1 million rows of data. A lot of formulas and custom vba modules are involved in producing the result. We run 20~30 such excel process every month.
3. Db server is already under pressure with all the etl running in the background so we won't be able to move the calc into it.
As some have pointed out that it is indeed a very broad question. Whether in house process suits us depends on more detailed analysis. I am asking just to find out what other approaches are people taking.
Thanks
microsoft-excel
asked Jan 16 at 5:59
mulder89520mulder89520
62
closed as too broad by Appleoddity, Máté Juhász, Mokubai♦ Jan 16 at 7:02
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
I am assigned a task to find a way to reduce the computing cost. We are using AWS at the moment.
The work we do involves a lot of calculation in excel spreadsheets using VBA modules. The result will be inserted into database.
My question is that is it common for companies that do a lot of excel calculations to have their own dedicate computing server in house? Is it in general worth investigating as a cost saving method?
A bit extra information to make my question more relevant.
1. Our db size is about 4tb. It is not very big in some sense but it contains a lot of rows. Some of tables have 1000000000+ rows.
2. Each excel run would process 1 million rows of data. A lot of formulas and custom vba modules are involved in producing the result. We run 20~30 such excel process every month.
3. Db server is already under pressure with all the etl running in the background so we won't be able to move the calc into it.
As some have pointed out that it is indeed a very broad question. Whether in house process suits us depends on more detailed analysis. I am asking just to find out what other approaches are people taking.
Thanks
microsoft-excel
asked Jan 16 at 5:59
mulder89520mulder89520
62
closed as too broad by Appleoddity, Máté Juhász, Mokubai♦ Jan 16 at 7:02
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
3
This question is too broad to be answered here. There are just too many factors. Besides amount of work ( does "lot of calculation" mean for you capacity of a pc? 10 pcs? 1000?) and its distribution over time you also need to consider local salaries and electricity cost...
– Máté Juhász
Jan 16 at 6:10
1
This is odd, why do not transfer calculation in application server? Or in database?
– Romeo Ninov
Jan 16 at 6:16
add a comment |
I am assigned a task to find a way to reduce the computing cost. We are using AWS at the moment.
The work we do involves a lot of calculation in excel spreadsheets using VBA modules. The result will be inserted into database.
My question is that is it common for companies that do a lot of excel calculations to have their own dedicate computing server in house? Is it in general worth investigating as a cost saving method?
A bit extra information to make my question more relevant.
1. Our db size is about 4tb. It is not very big in some sense but it contains a lot of rows. Some of tables have 1000000000+ rows.
2. Each excel run would process 1 million rows of data. A lot of formulas and custom vba modules are involved in producing the result. We run 20~30 such excel process every month.
3. Db server is already under pressure with all the etl running in the background so we won't be able to move the calc into it.
As some have pointed out that it is indeed a very broad question. Whether in house process suits us depends on more detailed analysis. I am asking just to find out what other approaches are people taking.
Thanks
microsoft-excel
asked Jan 16 at 5:59
mulder89520mulder89520
62
I am assigned a task to find a way to reduce the computing cost. We are using AWS at the moment.
The work we do involves a lot of calculation in excel spreadsheets using VBA modules. The result will be inserted into database.
My question is that is it common for companies that do a lot of excel calculations to have their own dedicate computing server in house? Is it in general worth investigating as a cost saving method?
A bit extra information to make my question more relevant.
1. Our db size is about 4tb. It is not very big in some sense but it contains a lot of rows. Some of tables have 1000000000+ rows.
2. Each excel run would process 1 million rows of data. A lot of formulas and custom vba modules are involved in producing the result. We run 20~30 such excel process every month.
3. Db server is already under pressure with all the etl running in the background so we won't be able to move the calc into it.
As some have pointed out that it is indeed a very broad question. Whether in house process suits us depends on more detailed analysis. I am asking just to find out what other approaches are people taking.
Thanks
microsoft-excel
microsoft-excel
asked Jan 16 at 5:59
mulder89520mulder89520
62
asked Jan 16 at 5:59
mulder89520mulder89520
62
edited Jan 17 at 0:47
mulder89520
asked Jan 16 at 5:59
mulder89520mulder89520
62
asked Jan 16 at 5:59
mulder89520mulder89520
62
asked Jan 16 at 5:59
mulder89520mulder89520
62
62
closed as too broad by Appleoddity, Máté Juhász, Mokubai♦ Jan 16 at 7:02
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as too broad by Appleoddity, Máté Juhász, Mokubai♦ Jan 16 at 7:02
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
3
This question is too broad to be answered here. There are just too many factors. Besides amount of work ( does "lot of calculation" mean for you capacity of a pc? 10 pcs? 1000?) and its distribution over time you also need to consider local salaries and electricity cost...
– Máté Juhász
Jan 16 at 6:10
1
This is odd, why do not transfer calculation in application server? Or in database?
– Romeo Ninov
Jan 16 at 6:16
add a comment |
3
This question is too broad to be answered here. There are just too many factors. Besides amount of work ( does "lot of calculation" mean for you capacity of a pc? 10 pcs? 1000?) and its distribution over time you also need to consider local salaries and electricity cost...
– Máté Juhász
Jan 16 at 6:10
1
This is odd, why do not transfer calculation in application server? Or in database?
– Romeo Ninov
Jan 16 at 6:16
3
3
This question is too broad to be answered here. There are just too many factors. Besides amount of work ( does "lot of calculation" mean for you capacity of a pc? 10 pcs? 1000?) and its distribution over time you also need to consider local salaries and electricity cost...
– Máté Juhász
Jan 16 at 6:10
This question is too broad to be answered here. There are just too many factors. Besides amount of work ( does "lot of calculation" mean for you capacity of a pc? 10 pcs? 1000?) and its distribution over time you also need to consider local salaries and electricity cost...
– Máté Juhász
Jan 16 at 6:10
1
1
This is odd, why do not transfer calculation in application server? Or in database?
– Romeo Ninov
Jan 16 at 6:16
This is odd, why do not transfer calculation in application server? Or in database?
– Romeo Ninov
Jan 16 at 6:16
add a comment |
0
active
oldest
votes
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
3
This question is too broad to be answered here. There are just too many factors. Besides amount of work ( does "lot of calculation" mean for you capacity of a pc? 10 pcs? 1000?) and its distribution over time you also need to consider local salaries and electricity cost...
– Máté Juhász
Jan 16 at 6:10
1
This is odd, why do not transfer calculation in application server? Or in database?
– Romeo Ninov
Jan 16 at 6:16