What is an alternative to Excel VBA to compute a large dataset: 100,000 rows by 125 columns?

What is an alternative to Excel VBA to compute a large dataset: 100,000 rows by 125 columns?
by

1 Answer

Answer :

Microsoft Access can process more data and more quickly but largely because it requires more structure. If you define every field as text in Access then you might be better off staying with Excel and using VBA for its superior reporting capability. Microsoft SPRS, SPSS, SPIS might be the preferred solution if data mining is required (very large data sets, typically in millions of records).
by

Related questions

Is there a free feature for removing duplicate columns/rows in Microsoft Excel?

Description : Is there a free feature for removing duplicate columns/rows in Microsoft Excel?

Last Answer : answer:you can do this without adding software. http://support.microsoft.com/kb/262277 I think this should work with all versions of Excel. if you're using a mac, the menus might be a little different, but ... tricky if you need to get rid of duplicate data in a specific column, but it can be done.

Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Description : Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Last Answer : d. Document

Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Description : Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Last Answer : d. Document

VBA excel?

Description : VBA excel?

Last Answer : You’re declaring a string variable.

The window version of Excel supports programming through Microsoft's Visual Basic for Applications (VBA), which is a dialect of _____: a) Visual Support b) Visual Basic c) Visual Format d) None of These

Description : The window version of Excel supports programming through Microsoft's Visual Basic for Applications (VBA), which is a dialect of _____: a) Visual Support b) Visual Basic c) Visual Format d) None of These

Last Answer : b) Visual Basic

Is this dataset too big for Excel to handle?

Description : Is this dataset too big for Excel to handle?

Last Answer : It sounds like your limit is your CPU, not Excel.

The concrete slump recommended for columns, is (A) 25 to 50 mm (B) 25 to 75 mm (C) 75 to 125 mm (D) 50 to 100

Description : The concrete slump recommended for columns, is (A) 25 to 50 mm (B) 25 to 75 mm (C) 75 to 125 mm (D) 50 to 100 mm

Last Answer : Answer: Option C

How many color patterns can you create by reversing the colors of combinations of rows and columns from a checkerboard?

Description : How many color patterns can you create by reversing the colors of combinations of rows and columns from a checkerboard?

Last Answer : answer:OK @LostInParadise – I understand each word individually, but I don’t have a friggin clue what you are asking. Can you perhaps explain the question better for simpletons like me?

Drawing of number of copies of the same image in rows and columns acrossthe interface window so that they cover the entire window is called a.Roaming b.Panning c.Zooming d.Tiling

Description : Drawing of number of copies of the same image in rows and columns acrossthe interface window so that they cover the entire window is called a.Roaming b.Panning c.Zooming d.Tiling

Last Answer : d.Tiling

What is the difference between ‘Rows’ and ‘Columns’ in a table? -Technology

Description : What is the difference between ‘Rows’ and ‘Columns’ in a table? -Technology

Last Answer : Distinguish between data and information are as follows:DataInformationIt is a raw fact.It is a process form of data.It considers facts symbols, images for reference or analysis.It considers knowledge derived from study, experience or instruction.e.g. 23 is data.e.g age = 23 is information

Key field is a unique identifier for each record. It is defined in the form of (a) rows (b) columns -Technology

Description : Key field is a unique identifier for each record. It is defined in the form of (a) rows (b) columns -Technology

Last Answer : (b) Key is a data item that allows you to uniquely identify individual occurrences which is defined as the column or set of columns.

In a table, columns are called ………. and rows are called ………… . -Technology

Description : In a table, columns are called ………. and rows are called ………… . -Technology

Last Answer : In a table, columns are called fields and rows are called records.

...method in Pandas can be used to change the index of rows and columns of a Series or Dataframe : -Technology

Description : ...method in Pandas can be used to change the index of rows and columns of a Series or Dataframe : -Technology

Last Answer : Correct option(ii)reindex

Python : Remove all columns from a compressed sparse matrix where value is 0 for all rows -Web-Development

Description : Python : Remove all columns from a compressed sparse matrix where value is 0 for all rows -Web-Development

Last Answer : answer:

Which of the following is a combination of columns and rows ?

Description : Which of the following is a combination of columns and rows ?

Last Answer : Database consists of columns and rows.

What are the rows and columns of the matrix ?

Description : What are the rows and columns of the matrix ?

Last Answer : The rectangular arrangement of numbers in the matrix is analyzed in two ways. Namely: along the horizontal line and along the vertical line. The horizontal lines of numbers are called rows and the vertical lines are called columns.

Statistical table is the systematic arrangement of numerical data presented in rows and columns. What are the rules to be followed while constructing such a table?

Description : Statistical table is the systematic arrangement of numerical data presented in rows and columns. What are the rules to be followed while constructing such a table?

Last Answer : Statistical table is the systematic arrangement of numerical data presented in rows and columns. ... be followed while constructing such a table?

The following figure has a network of rectangles. Two rows and three columns. (A) Totally how many rectangles are there in the figure? (B) If there ar

Description : The following figure has a network of rectangles. Two rows and three columns. (A) Totally how many rectangles are there in the figure? (B) If there ar

Last Answer : The following figure has a network of rectangles. Two rows and three columns. (A) Totally how many ... in the network, in terms of x and y.

How many horizontal rows and vertical columns are present in the modern periodic table?

Description : How many horizontal rows and vertical columns are present in the modern periodic table?

Last Answer : How many horizontal rows and vertical columns are present in the modern periodic table?

What is A grid comprised of horizontal rows an vertical columns into which you can enter data?

Description : What is A grid comprised of horizontal rows an vertical columns into which you can enter data?

Last Answer : Generically it is called a table.

What is the default alignment for a table with 3 rows and 4 columns?

Description : What is the default alignment for a table with 3 rows and 4 columns?

Last Answer : What is the answer ?

In a relational database, this is a data structure that organizes the information about a single topic into rows and columns. 1) Block 2) Record 3) Tuple 4) Table 5) Command line interface

Description : In a relational database, this is a data structure that organizes the information about a single topic into rows and columns. 1) Block 2) Record 3) Tuple 4) Table 5) Command line interface

Last Answer : Answer :4

How are data organised in a spreadsheet? 1) Lines and spaces 2) Layers and planes 3) Height and width 4) Rows and columns 5) None of these

Description : How are data organised in a spreadsheet? 1) Lines and spaces 2) Layers and planes 3) Height and width 4) Rows and columns 5) None of these

Last Answer : Answer :3

How many rows and columns are in the modern Periodic Table? A. 18 columns and 7 rows (Answer) B. 12 columns and 9 rows C. 7 columns and 18 rows D. 25 columns and 15 rows

Description : How many rows and columns are in the modern Periodic Table? A. 18 columns and 7 rows (Answer) B. 12 columns and 9 rows C. 7 columns and 18 rows D. 25 columns and 15 rows

Last Answer : A. 18 columns and 7 rows (Answer)

The CRT display is made up of small picture element called: a) Columns b) Pixels c) Rows d) None of These

Description : The CRT display is made up of small picture element called: a) Columns b) Pixels c) Rows d) None of These

Last Answer : b) Pixels

A database is typically composed of one or more: a) Columns b) Files c) Rows d) Tables e) None of These

Description : A database is typically composed of one or more: a) Columns b) Files c) Rows d) Tables e) None of These

Last Answer : d) Tables

What is the minimum number of rows and columns that a word table can have a) 1 row & 1 columnb) 2 rows & 2 columnsc) Zerod)1 row & 2 columnse) None of The Above

Description : What is the minimum number of rows and columns that a word table can have a) 1 row & 1 column b) 2 rows & 2 columns c) Zero d)1 row & 2 columns e) None of The Above

Last Answer : a) 1 row & 1 column

The minimum number of rows and columns that a word table can have, is: a) Zero b) 1 Row and 1 Column c) 1 Row and 2 Columnsd) None of The Above

Description : The minimum number of rows and columns that a word table can have, is: a) Zero b) 1 Row and 1 Column c) 1 Row and 2 Columns d) None of The Above

Last Answer : b) 1 Row and 1 Column

If no. of rows are not equal to number of columns and the matrix elements are profit elements then the problem is: a. Balanced and Maximization Transportation problem b. Unbalanced and Maximization Transportation problem c. Balanced and Maximization Assignment problem d. Unbalanced and Maximization Assignment problem

Description : If no. of rows are not equal to number of columns and the matrix elements are profit elements then the problem is: a. Balanced and Maximization Transportation problem b. ... Transportation problem c. Balanced and Maximization Assignment problem d. Unbalanced and Maximization Assignment problem

Last Answer : a. Balanced and Maximization Transportation problem

If no. of rows are equal to number of columns and the matrix elements are Time elements then the problem is: a. Balanced and Minimization Transportation problem b. Unbalanced and Minimization Transportation problem c. Balanced and Minimization Assignment problem d. Unbalanced and Minimization Assignment problem

Description : If no. of rows are equal to number of columns and the matrix elements are Time elements then the problem is: a. Balanced and Minimization Transportation problem b. ... Transportation problem c. Balanced and Minimization Assignment problem d. Unbalanced and Minimization Assignment problem

Last Answer : c. Balanced and Minimization Assignment problem

An assignment problem is a special case of transportation problem, where a. Number of rows equals number of columns b. All rim conditions are 1 c. Values of each decision variable is either 0 or 1

Description : An assignment problem is a special case of transportation problem, where a. Number of rows equals number of columns b. All rim conditions are 1 c. Values of each decision variable is either 0 or 1

Last Answer : D.variable is either 0 or 1

An optimal assignment requires that the maximum number of lines that can be drawn through squares with zero opportunity cost be equal to the number of a. Rows or columns b. Rows & columns c. Rows + columns -1 d. None of the above

Description : An optimal assignment requires that the maximum number of lines that can be drawn through squares with zero opportunity cost be equal to the number of a. Rows or columns b. Rows & columns c. Rows + columns -1 d. None of the above

Last Answer : b. Rows & columns

An assignment problem is considered as a particular case of a transportation problem because a. The number of rows equals columns b. All xij = 0 or 1 c. All rim conditions are 1 d. All of the above

Description : An assignment problem is considered as a particular case of a transportation problem because a. The number of rows equals columns b. All xij = 0 or 1 c. All rim conditions are 1 d. All of the above

Last Answer : d. All of the above

If in an assignment problem, number of rows is not equal to number of columns then a. Maximization problem b. Problem is unbalanced c. Problem is degenerate d. Optimum solution is not possible

Description : If in an assignment problem, number of rows is not equal to number of columns then a. Maximization problem b. Problem is unbalanced c. Problem is degenerate d. Optimum solution is not possible

Last Answer : c. Problem is degenerate

The number of tuples in a relation is called its …………. While the number of attributes in a relation is called it’s ……………….. A) Degree, Cardinality B) Cardinality, Degree C) Rows, Columns

Description : The number of tuples in a relation is called its …………. While the number of attributes in a relation is called it’s ……………….. A) Degree, Cardinality B) Cardinality, Degree C) Rows, Columns

Last Answer : B) Cardinality, Degree

The solution to a transportation problem with ‘m’ rows and ‘n’ columns is feasible if the number of positive allocations are: a. m + n b. m x n c. m +n – 1 d. m +n + 1

Description : The solution to a transportation problem with ‘m’ rows and ‘n’ columns is feasible if the number of positive allocations are: a. m + n b. m x n c. m +n – 1 d. m +n + 1

Last Answer : c. m +n – 1

The “PROJECT” operator of a relational algebra creates a new table that has always (A) More columns than columns in original table (B) More rows than original table (C) Same number of rows as the original table (D) Same number of columns as the original table

Description : The “PROJECT” operator of a relational algebra creates a new table that has always (A) More columns than columns in original table (B) More rows than original table (C) Same number of rows as the original table (D) Same number of columns as the original table

Last Answer : (C) Same number of rows as the original table

In the Hungarian method for solving assignment problem, an optimal assignment requires that the maximum number of lines that can be drawn through squares with zero opportunity cost be equal to the number of: (A) rows or columns (B) rows+columns (C) rows+columns-1 (D) rows+columns+1

Description : In the Hungarian method for solving assignment problem, an optimal assignment requires that the maximum number of lines that can be drawn through squares with zero opportunity cost be equal to the number of: (A) rows or columns (B) rows+columns (C) rows+columns-1 (D) rows+columns+1

Last Answer : (A) rows or columns

What is the lifetime of ILDs? a. 50,000 hours b. 75,000 hours c. 100,000 hours d. 125,000 hours

Description : What is the lifetime of ILDs? a. 50,000 hours b. 75,000 hours c. 100,000 hours d. 125,000 hours

Last Answer : a. 50,000 hours

What is the lifetime of ILDs? ∙ a. 50,000 hours ∙ b. 75,000 hours ∙ c. 100,000 hours ∙ d. 125,000 hours

Description : What is the lifetime of ILDs? ∙ a. 50,000 hours ∙ b. 75,000 hours ∙ c. 100,000 hours ∙ d. 125,000 hours

Last Answer : a. 50,000 hours

In Excel, how do I conditionally change a row's fill color?

Description : In Excel, how do I conditionally change a row's fill color?

Last Answer : you have to “make new a rule” under “conditional formatting”

Can I insert multiple blank rows on an excel sheet?

Description : Can I insert multiple blank rows on an excel sheet?

Last Answer : Yes. Highlight a cell, then drag it down (highlighting) for the needed number of rows. Then select insert rows. It will insert the number of rows highlighted.

What excel features can I use to find easily to locate rows in a table that meet my criteria?

Description : What excel features can I use to find easily to locate rows in a table that meet my criteria?

Last Answer : Need answer

Help with an error I am getting in VBA?

Description : Help with an error I am getting in VBA?

Last Answer : You might not have used selection with proper object. You can check it out in object browser (View->Object Browser) if the object you've used has that property/method or not. For example, if you are trying to ... block, make sure you end it with End With . Example: With Cells(1,1) .Value=1 End With

VBA stands for: a) Visual Basic For Application b) Virtual Based For Application c) Various Basics Application d) None of These

Description : VBA stands for: a) Visual Basic For Application b) Virtual Based For Application c) Various Basics Application d) None of These

Last Answer : a) Visual Basic For Application

What are Macros: a) Small add - on programs that are installed afterwards if you need them b) Small programs created in MS - Word to automate repetitive tasks by using VBA c) Automatic Virus Scanning Programs d) None of The Above

Description : What are Macros: a) Small add - on programs that are installed afterwards if you need them b) Small programs created in MS - Word to automate repetitive tasks by using VBA c) Automatic Virus Scanning Programs d) None of The Above

Last Answer : b) Small programs created in MS - Word to automate repetitive tasks by using VBA

Omitting columns in Excel 2010 sort?

Description : Omitting columns in Excel 2010 sort?

Last Answer : answer:highlight the columns you want to make disappear right click on one of them choose HIDE from the context menu,] Voila…

How do you sort columns of number/text mix in Excel?

Description : How do you sort columns of number/text mix in Excel?

Last Answer : answer:Make the numbers all 2 digits…. example-01 example-02 example-03 example-10 example-11 example-12 Then it will sort correctly.

How to make columns into lists for .csv (excel) with Python?

Description : How to make columns into lists for .csv (excel) with Python?

Last Answer : answer:data = open( grades.csv , r ).readlines() for line in data: [t]items = line.split() [t]print items[0], items[2] note that Fluther strips the required tabbing from the program, replace [ ... to delimit columns. Should really close the file in the program and not leave the OS to sort it out.