Reading values from a chart and creating a new one
Hello everybody. I need some help with this. Since I'm new to programming, I don't want anybody to actually do the program for me, but if you could just name some terms or subjects I could research to figure it out I'd really appreciate it.
This program I'm working on has basically has 2 roles. It reads a very confusing file spit out by a computer that's recording rat movement through a maze, and organizes it and removes unnecessary info and creates a new file with the organized values. That part was completed by much more knowledgable person than me. It's the 2nd part that I have to do and am stuck at.
Now I need to enhance the program the other guy made so that itreads the new organized file (attachment) it just created. And I basically have to make a program that does what this researcher was doing by hand:
"2) I create a new column titled “ARM” after the last column in the spreadsheet, which is usually Column: AJ, Row 7.
3) In this column, I start with the first counter that gets to “3”, and whichever arm it corresponds to, I write down in the new column. For example, if “Reinforcement Counter for ArmFlag # 4” is the first counter to reach 3, then I would enter the number “4” in the new column, at whatever row you found the “3”.
4) I then scroll down until either the first ArmFlag counter to reach 3 has reached 5, OR, until another ArmFlag counter has reached 3. Whichever Arm this is, is recorded into the “ARM” column, in the corresponding row.
5) I then scroll down until either a) A different ArmFlag counter reaches 3, or, b) One of the same ArmFlag counters increases to the next odd number. Whichever of these happens first, is the arm that I write in the “ARM” column.
a. For Example, if the “Reinforcement Counter for ArmFlag 3” is “5,” and the next thing that happens as I scroll down the spreadsheet is that the “Reinforcement Conter for ArmFlag 3” increases to “7” in Row 25, then in Row 25 I would write “3”. However, if the next thing that happens is that the Counter for ArmFlag 2 increases from nothing to 3, then I would write “2” in the corresponding row.
6) Next, I repeat step 5, looking for the counters to increase to the next odd number (i.e 3,5,7,9,11…etc), and record which Arm it was in the “ARM” column. Thus, I follow the instructions in Step 5 precisely until I have examined the entire spreadsheet."
Like I said, you don't need to get too specific if you don't want to. I have a few books on C++, so if you could just give me some pointers I could go research them.
I'll attach the organized file.
Thanks a lot.