Front Office Football Central  

Go Back   Front Office Football Central > Main Forums > Off Topic
Register FAQ Members List Calendar Mark Forums Read Statistics

Reply
 
Thread Tools
Old 01-29-2013, 09:20 AM   #1
PurdueBrad
Grizzled Veteran
 
Join Date: Jul 2007
Location: DeKalb, IL
Excel help

Hey all,

I'm not sure if what I'm asking is possible but here's the situation.

I work in a school and the administration is trying to collect daily data from 48 pairs of teachers using Excel spreadsheets. We don't have a shared drive so either teachers are submitting their files individually (96 files) or constantly e-mailing back and forth and submitting jointly (48 files). These files, although they track daily data, would be turned in monthly. The data tabulation would be rough as the current plan is for a secretary to wade through each file and add the numbers to her own spreadsheet.

However, I thought there might be a way to simply import the data from all those separate files and have Excel do all the work rather than 1 person. Is this possible and, if so, how so?

I'm not really involved in the project but I'm just trying to find a shortcut to make a couple people's lives easier.
__________________
Quote:
Originally Posted by CrimsonFox View Post
PB is a very good person and doesn't covort with concubines...

PurdueBrad is offline   Reply With Quote
Old 01-29-2013, 09:41 AM   #2
Logan
Head Coach
 
Join Date: Oct 2000
Location: NYC
Not answering your direct question but what about setting this up as a Google Doc that everyone can access and input the data directly?
Logan is offline   Reply With Quote
Old 01-29-2013, 10:39 AM   #3
PurdueBrad
Grizzled Veteran
 
Join Date: Jul 2007
Location: DeKalb, IL
Hey Logan-

That's the fallback position that we're arguing for right now.

The Administrative preference seems to be us e-mailing the document back-and-forth a ton of times between us and having one person responsible for turning it in but, from a discipline standpoint, punishing both teachers if the partner forgets to turn it in.
__________________
Quote:
Originally Posted by CrimsonFox View Post
PB is a very good person and doesn't covort with concubines...
PurdueBrad is offline   Reply With Quote
Old 01-29-2013, 10:57 AM   #4
Logan
Head Coach
 
Join Date: Oct 2000
Location: NYC
Yeah and even ignoring the discipline aspect, the administration should just be concerned about the colossal eff-up that would be caused by someone sending an older file than what the other person was using, and then going off that when tabulating the data. It typically ends in disaster when you have a small team of people doing that...can't imagine it from 48 sets of people.
Logan is offline   Reply With Quote
Old 01-29-2013, 11:43 AM   #5
Bobble
College Prospect
 
Join Date: Nov 2006
Location: High and outside
If you can keep all the filenames consistent (InputBobble.xls, InputPurdueBrad.xls, etc.), then couldn't you just write a macro to open each file, copy, and paste?
Bobble is offline   Reply With Quote
Old 01-29-2013, 02:38 PM   #6
finketr
College Prospect
 
Join Date: Jan 2005
Location: Inland Empire, PRC
Quote:
Originally Posted by Bobble View Post
If you can keep all the filenames consistent (InputBobble.xls, InputPurdueBrad.xls, etc.), then couldn't you just write a macro to open each file, copy, and paste?


This was going to be my suggestion....

Have a filename "standard" (HAHAHAHAHAHA) and it's easier.

the cells on the secretary .xlsx would look like:
=VLOOKUP($A857,'Z:\whatever\[filename.xls]sheetname'!$A$1:$F$65536,2,0)
finketr is offline   Reply With Quote
Old 01-29-2013, 04:08 PM   #7
PurdueBrad
Grizzled Veteran
 
Join Date: Jul 2007
Location: DeKalb, IL
Thanks a ton guys, I'll run this by everyone!
__________________
Quote:
Originally Posted by CrimsonFox View Post
PB is a very good person and doesn't covort with concubines...
PurdueBrad is offline   Reply With Quote
Old 01-29-2013, 04:09 PM   #8
CrimsonFox
Head Coach
 
Join Date: Dec 2009
Quote:
Originally Posted by PurdueBrad View Post
Hey all,

I'm not sure if what I'm asking is possible but here's the situation.

I work in a school and the administration is trying to collect daily data from 48 pairs of teachers using Excel spreadsheets. We don't have a shared drive so either teachers are submitting their files individually (96 files) or constantly e-mailing back and forth and submitting jointly (48 files). These files, although they track daily data, would be turned in monthly. The data tabulation would be rough as the current plan is for a secretary to wade through each file and add the numbers to her own spreadsheet.

However, I thought there might be a way to simply import the data from all those separate files and have Excel do all the work rather than 1 person. Is this possible and, if so, how so?

I'm not really involved in the project but I'm just trying to find a shortcut to make a couple people's lives easier.

pray
CrimsonFox is online now   Reply With Quote
Old 01-29-2013, 04:30 PM   #9
stevew
Hall Of Famer
 
Join Date: Dec 2003
Location: the yo'
This clearly sounds like the worst possible way to do something.

Talk some sense into these people.
stevew is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump


All times are GMT -5. The time now is 10:52 AM.



Powered by vBulletin Version 3.6.0
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.