physics

Hi, I am new to VBA and i have been trying to achieve the following but i am stuck. I have different tables in one worksheet with common headers from which i need to collate the data into a single table with one set of headers, in a different worksheet. Example given below is of the Raw data...

Hello, I have data in many csv files (more than 500, each corresponding to one person's scores), and I need to combine the data into one file, in transposed form (i.e. rows instead of columns), for easier visualization and processing. Each file contains 5 columns with the same headings (course...

Hey Mr EXCEL users, I need some help about this please: How can I sort the names column in each sheet. For example: we have some names like this: Sheet 1 (Main) <tbody> Name Birthday Class Kofi 02.09.2011 B Matt 18.10.2011 C Kathrine 15.07.2011 C </tbody> Sheet 2, 3 and 4 (October)...

Hi Folks, Can you please help me with the below query: Master Data: <colgroup><col><col span="2"></colgroup><tbody> Username Subject Score A1 English 50 A1 Maths 45 A1 Physics 34 A1 History 23 A1 Geography 56 A2 English 24 A2 Maths 67 A2 Physics 45 A2 History 32 A3...

Hi, i hope someone can help me as this is driving me potty. I have student grades listed like below <!--StartFragment--> <colgroup><col width="65" span="5" style="width:65pt"> </colgroup><tbody> Biology Chemistry History Physics Student 1 6 7 7 2 Student 2 3...

I am trying to generate a printout of a simple Sine curve where the scale is exact so that students may be able to use rulers to accurately measure attributes like Amplitude, Frequency, Period, Phase and Offset. My currently oversimplified table is Time, Sine 0 ,=2*Sin(Time) .2 .4 .6 ...

I thought it might be nice to write a function in VBA that would evaluate a definite integral, given a string that represents y as a function of x and the lower and upper limit. Here's what I came up with: Function INTEG(exp As String, min As Double, max As Double) Dim t As Double Dim x As...

How do you calculate the standard deviation of many values if the values have errors associated with them? I have set up columns beside each column of recorded values with the error, so +/- 2 for example, and now I need to run a standard deviation of these numbers. Is it possible to include the...