|
Funktor posted:Well, I know all that (except for the drop-down lists). Here's the issue: I'm not sure Excel is the right tool for the task, but this particular instance might be taken care of with the sumif (or sumifs) function. As the name implies, it sums things together only if they match a certain criteria. As an example, take column A as the names of each person, and column B as hours worked (or pay). If C2 is "Jerry", set D2 as =sumif(A:A,C2,B:B). This will sum together all the values in B where the adjacent value in A is "Jerry". You can repeat this down the line for all the employees. And there's no need to alphabetize either list! Unfortunately, your problem with Excel will be figuring out how to automate each of their tasks. This will be especially difficult if your parents are the ones writing the script, as they'll need a strong grasp of several excel functions. If you do stick with excel, my favorite functions for automating data processing like this are:
Unfortunately, these are moderately advanced functions and can quickly balloon into ridiculously long and complicated cells. If you or your parents aren't feeling up to it, you should probably look around for real timekeeping software. I don't really have any suggestions there, sadly. Edit: Feel free to PM me for specific questions. kapinga fucked around with this message at 01:17 on Jun 23, 2011 |
#
?
Jun 23, 2011 00:52
|
|
|
|
| # ? Jun 4, 2024 07:04 |
|
|
fishmech posted:The easiest way, but also longest way, to do this would be to move all those folders out to either a FAT32 or exFAT drive (thus wiping all permissions) and copying it back to your drives with your user account to completely reset permissions.  ...hell I can't even think of a car analogy  Factor Mystic posted:Get the security correct on the topmost directory, then Properties -> Security, 'Advanced', 'Change Permissions', Check 'Replace all child object permissions...' and hit okay. Do this once per drive (NOT your OS drive). For example you can delete all the user accounts listed there except your current one (or the Users group) and that'll reset everything. WorkingStiff posted:Factor Mystic speaks the truth. You can also do it from the command line.
|
|
#
?
Jun 23, 2011 01:47
|
|
|
Thanks for the help everybody! My wife and I programmed an excel template that my folks should be able to use.
|
|
#
?
Jun 23, 2011 03:04
|
|
|
Hey, is it a bad idea to still be using Outlook 2002 on a Windows 7 machine? Are there any known exploits that should make me run far away from this software or should I be good?
|
|
#
?
Jun 23, 2011 03:17
|
|
|
I have a quick question since this is my very first time doing this as well as being slightly confused from an answer in the OP. I am building a computer from parts from Newegg with a bare 500GB drive. An OEM version is just a version you get when you buy a build from a store, correct? I was just wondering because Newegg sells OEMs and full versions. So in this case, I would have to buy a full version, right?
|
|
#
?
Jun 23, 2011 03:40
|
|
|
notMordecai posted:I am building a computer from parts from Newegg with a bare 500GB drive. An OEM version is just a version you get when you buy a build from a store, correct? I was just wondering because Newegg sells OEMs and full versions.
|
|
#
?
Jun 23, 2011 03:45
|
|
|
I'm getting ready to finally give my GF her new netbook, and I'm trying to think of any other security/make-computer-run-well programs to install. I have MSE and Malwarebytes for security, CCleaner for...well, cleaning, Secunia PSI for tracking updates and HDGraph to give her an easy way to check out her hard disk's components. Anything else a Mac -> Windows convert might want? Also, does anyone happen to have a link to the last good freeware games thread around here? EDIT: Found a pair of freeware threads (archives needed) C-Euro fucked around with this message at 02:14 on Jun 24, 2011 |
|
#
?
Jun 23, 2011 04:00
|
|
|
You can try Microsoft's Enhanced Mitigation Experience 2.0 if you're that paranoid.
|
|
#
?
Jun 23, 2011 04:07
|
|
|
C-Euro posted:I'm getting ready to finally give my GF her new netbook, and I'm trying to think of any other security/make-computer-run-well programs to install. I have MSE and Malwarebytes for security, CCleaner for...well, cleaning, Secunia PSI for tracking updates and HDGraph to give her an easy way to check out her hard disk's components. Anything else a Mac -> Windows convert might want? I'd totally forgotten about this thread, guess it never really grew that big. Some good recommendations though.
|
|
#
?
Jun 23, 2011 05:08
|
|
|
So I just made a really dumb mistake. I was purchasing a student upgrade to Windows 7 Professional through Digital River and accidentally purchased the 32-bit version rather than the 64-bit version. =/ Support looks like it's going to be a major pain in the rear end and probably not very helpful. Should the product key I was given for the 32-bit purchase work if I use a 64-bit install?
|
|
#
?
Jun 23, 2011 08:01
|
|
|
Eric WK posted:Should the product key I was given for the 32-bit purchase work if I use a 64-bit install? Yes, product keys are independent of bit version.
|
|
#
?
Jun 23, 2011 08:09
|
|
|
Funktor posted:Well, I know all that (except for the drop-down lists). Here's the issue: This sounds like it might be a job for pivot tables. It's amazing how easily you can get Excel to summarize information with them.
|
|
#
?
Jun 23, 2011 15:07
|
|
|
Green Puddin posted:Hey, is it a bad idea to still be using Outlook 2002 on a Windows 7 machine? Are there any known exploits that should make me run far away from this software or should I be good? Microsoft is still releasing security updates for Office XP, although the last patch for Outlook was released last year.
|
|
#
?
Jun 23, 2011 16:37
|
|
|
I'm experimenting with slipstreaming updates into a Windows install image. What's the preferred method for downloading the update files? There's a program called Windows Updates Downloaded that will get them all from Microsoft, but their lists of necessary downloads haven't been updated in over a year, and doesn't have anything at all for Win7 or 2008. Is there a better tool for this now?
|
|
#
?
Jun 23, 2011 18:48
|
|
|
stubblyhead posted:I'm experimenting with slipstreaming updates into a Windows install image. What's the preferred method for downloading the update files? There's a program called Windows Updates Downloaded that will get them all from Microsoft, but their lists of necessary downloads haven't been updated in over a year, and doesn't have anything at all for Win7 or 2008. Is there a better tool for this now? Don't want to crap on your idea, but unless it's some specific update that's a deal breaker, always found it easier to just slipstream to the latest service pack and deal with any other updates from there. Updates gets superseded/replaced often enough that your image is out of date pretty fast.
|
|
#
?
Jun 23, 2011 18:57
|
|
|
I'm getting this error whenever I try to open up the file explorer from the taskbar It then does not let me open the window. Needless to say I'm a bit scared, not being able to open the explorer is a fairly significant windows glitch. What the hell is going on. Lets Fuck Bro fucked around with this message at 19:07 on Jun 23, 2011 |
|
#
?
Jun 23, 2011 19:01
|
|
|
Besides drivers, what else will I need to reinstall after doing an upgrade/repair installation? Do I risk losing my poo poo?
|
|
#
?
Jun 23, 2011 20:32
|
|
|
stubblyhead posted:I'm experimenting with slipstreaming updates into a Windows install image... Is there a better tool for this now? I have one USB with all the versions of Win7 SP1 and one USB which I keep synced with WSUS Offline. Updates and patches are so frequent, I gave up trying to keep an image handy because in a month it will be out of date.
|
|
#
?
Jun 23, 2011 21:08
|
|
|
Lets gently caress Bro posted:I'm getting this error whenever I try to open up the file explorer from the taskbar Try and do a repair.
|
|
#
?
Jun 23, 2011 22:38
|
|
|
This is about the Indexing Service. We have a Win2k8 R2 server that's doing the file sharing on our network. We're getting into areas where Win7 doesn't like using the server drive space because it's not indexed. I know there's a significant performance hit during indexing, but doesn't that go away once the initial indexing is done? It's not constantly chowing HDD and CPU in order to index is it? I'm 90% sure this isn't the case.
|
|
#
?
Jun 24, 2011 18:41
|
|
|
Is the general consensus to avoid codec packs? Is it better just grabbing ffdshow tryouts and Haali?
|
|
#
?
Jun 24, 2011 20:00
|
|
|
permanoob posted:This is about the Indexing Service. We have a Win2k8 R2 server that's doing the file sharing on our network. We're getting into areas where Win7 doesn't like using the server drive space because it's not indexed. I know there's a significant performance hit during indexing, but doesn't that go away once the initial indexing is done? You're correct. Once it's done indexing you're golden. Note that some people still say that have problems with it eating their megahertz, but I've never seen a problem with it. Satire Forum Mom posted:Is the general consensus to avoid codec packs? Is it better just grabbing ffdshow tryouts and Haali? Yes.
|
|
#
?
Jun 24, 2011 23:18
|
|
|
I'm looking for a video editing program slightly more advanced than Windows Movie Maker. I tried the trial of Vegas, but it was way way too complicated right off the bat. I like detail, but not thrown at me right from the beginning... Any recommendations? What I use this for: basically slightly editing (i.e. adding titles), and then converting .avi's captured by Fraps to something smaller. Good example is here: https://www.youtube.com/watch?v=RfTzbrGsP_0 https://www.youtube.com/watch?v=_CCyzrB3qJA
|
|
#
?
Jun 24, 2011 23:59
|
|
|
I was interested in that too, there are so many great open source content creation packages (like Blender) but there didn't seem to be any advanced video editing suites, on Windows at least. Anyhow I haven't used it but this looks interesting http://www.lightworksbeta.com/ Apparently it's a professional editor that's been used for a lot of big movies like Pulp Fiction and The Departed, and a company bought it up to release it as open source. Worth a crack EDIT oh you said Vegas was a bit much... what is it about Windows Movie Maker that doesn't do it for you? baka kaba fucked around with this message at 00:50 on Jun 25, 2011 |
|
#
?
Jun 25, 2011 00:46
|
|
|
Pinnacle Studio HD? Adobe Premiere Elements? You can do a trial of Elements, not sure about PSHD.
|
|
#
?
Jun 25, 2011 00:53
|
|
|
There is a problem with my wife's laptop. It is a Sony Vaio that runs Windows XP. A few weeks ago, she installed an update for Norton antivirus software. After installation, it asked what type of resources she should use and she clicked "minimal". After that, the system tray disappeared, and the Wireless Networks Tab under the Network Connections area disappeared. She used to be able to connect to our wireless router automatically, but now even that is impossible. She called Norton, but all they said was to call our ISP (which as far as I can tell doesn't make sense since that wouldn't affect the system tray and Wireless Networks tab). I've tried going into msconfig and ensuring that the Wireless Zero Configuration is running, which it seems to be, but there is no connection. Does anyone have any idea what's going on?
|
|
#
?
Jun 25, 2011 06:10
|
|
|
Uninstall everything Norton and install MSE. Norton fucks your poo poo up.
|
|
#
?
Jun 25, 2011 06:14
|
|
|
Steakandchips posted:I'm looking for a video editing program slightly more advanced than Windows Movie Maker. I am also interested in this. Normally WMM would work fine with me, but I'm using an HD format (MPEG-2 stream) that WMM doesn't support.
|
|
#
?
Jun 25, 2011 19:01
|
|
|
Lets gently caress Bro posted:I'm getting this error whenever I try to open up the file explorer from the taskbar
|
|
#
?
Jun 25, 2011 19:15
|
|
|
Not sure if this is the right place to put this, but I can't seem to get my Thinkpad Power Manager to show up in the taskbar. I'm only getting the Windows battery icon. The Power Manager software is installed and "show battery icon in taskbar" is checked. Any ideas? This is on a new x220 with Windows 7 Professional x64 if it makes a difference.
|
|
#
?
Jun 25, 2011 19:27
|
|
|
GreenNight posted:Uninstall everything Norton and install MSE. Norton fucks your poo poo up. MSE is great - use it.
|
|
#
?
Jun 25, 2011 20:16
|
|
|
I only boot into windows 7 once every few weeks, but whenever I do, the hard drive for SOME reason constantly chugs. Its that scrubbing sound that your computer makes when it's doing heavy disk reading. Its like theres some kind of process thats running in the background that is constantly reading my files or something. The only way to stop it is to boot back into linux. How do I stop this? At first I thought it was the 'search files' indexer thing that XP had, but I don't think it's that. According to ctrl-shift-esc there is nothing that is look suspicious. How can I troubleshoot this?
|
|
#
?
Jun 26, 2011 11:50
|
|
|
Start -> Run -> type "Resource Monitor" and run it, then go to the Disk tab. It may be indexing, or it may be an antivirus scan. Most A/V will auto-scan once a week, and will immediately update themselves and rescan if they notice they've missed the time.
|
|
#
?
Jun 26, 2011 12:15
|
|
|
I'm waiting on a new SSD to arrive. I plan on reinstalling Win7 Professional when it gets here. Is there any place I can download the Win 7 SP1 installer legitimately so I can put it on a USB drive? I have a copy of Win 7 without SP1 on a DVD, I don't want to reinstall all the updates after I install the operating system. I checked the OP and the links were not valid.
|
|
#
?
Jun 26, 2011 18:48
|
|
|
agentq posted:I'm waiting on a new SSD to arrive. I plan on reinstalling Win7 Professional when it gets here. Is there any place I can download the Win 7 SP1 installer legitimately so I can put it on a USB drive? I have a copy of Win 7 without SP1 on a DVD, I don't want to reinstall all the updates after I install the operating system. I checked the OP and the links were not valid. http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c3202ce6-4056-4059-8a1b-3a9b77cdfdda&displaylang=en
|
|
#
?
Jun 26, 2011 19:13
|
|
|
HelfMyselp posted:I imagine you're looking for the ~900MB or so SP1 installer? Try here: I'm looking for a Win7 installer with the SP1 improvements already integrated...
|
|
#
?
Jun 26, 2011 19:48
|
|
|
agentq posted:I'm looking for a Win7 installer with the SP1 improvements already integrated... 
|
|
#
?
Jun 26, 2011 21:23
|
|
|
agentq posted:I'm looking for a Win7 installer with the SP1 improvements already integrated... You'll need someone with technet/msdn access to snag it for you, or get it some other way. I don't think there's an easy microsoft sanctioned slipstream method at the moment (yes, you can do it with WAIK, but I wouldn't call that easy).
|
|
#
?
Jun 26, 2011 22:48
|
|
|
GreenNight posted:Uninstall everything Norton and install MSE. Norton fucks your poo poo up. Thanks. We ended up uninstalling everything Norton, but now it's even more screwed up. It won't read CDs, (when I try to force it to with the run command, it says there's nothing in the drive, and when I try to use the command prompt screen to switch to the CD, it says device not ready). There's nothing in the device manager and it can't read flashdrives or any USB devices. Any clue what's going on or is the computer just dead now? I can't even transfer microsoft fixes from this computer to her computer now.
|
|
#
?
Jun 27, 2011 01:55
|
|
|
|
| # ? Jun 4, 2024 07:04 |
|
|
Maneki Neko posted:You'll need someone with technet/msdn access to snag it for you, or get it some other way. I don't think there's an easy microsoft sanctioned slipstream method at the moment (yes, you can do it with WAIK, but I wouldn't call that easy). I tried downloading the win7 iso from the digitalriver site even though it's been more than 30 days and it worked. Can I just put the iso file on a thumbdrive and boot from that? Or do I need to do some special prep...
|
|
#
?
Jun 27, 2011 02:39
|
|