Alright...so i have a question
i know it says that i am "breaking the rules" by asking a question here...but it's not an excel mobile question...it's a question about an actual microsoft windows/office question
and since this is the only off-topic non-mobile forum i can find...this is the only place where i see it fits...if i'm wrong, feel free to move the forum
anywho!
i decided to ask here since xda members are relatively well-equipped to answer tech questions and i really don't feel/like the thought of registering at an excel help forum just for one question..so here goes!
I have two worksheets in an excel file
they both contain the same type of data
they're athletes (hockey players) with all their stats...organized in columns
both sheets have
NAME GP Goals Assists Points
one sheet is this past year...another sheet is the year before that
what i'd liek to do is link the rows that have the same player name
so that I can see Player A's points from last year compared to the year before that and see his progress
is this possible and can anyone help?
how's that for completely off topic
hehe
thanks!
Take year before last worksheet and sort it by name. Save workbook.
On last year's sheet, in the column where you want prior year's points to show up use the function VLOOKUP and refer it to the other sheet data range. Copy the formula down your column for the other players.
Read a little bit on it.
Some tips on VLOOKUP....
1. If you are going to pull several pieces of data from another table use appropriate absolute value for your Lookup_Value. If pulling data fields across and you want to copy the formula down to pull back several players, only make sure the column address is absolute. The row address should not be absolute. F4 toggles the available absolute addresses when in the Lookup_value field. Or just type in $ before what you want absolute.
2. For Range_lookup use False. It will force an exact match to the player's name as opposed to the closest name.
thanks! exactly what i was looking for...
Related
Wondered if anyone else has this problem?
Most of my documents (.docx, .doc, .xls) are stored on the SD card for obvious reasons. If I access them through a file explorer, they open fine. However, if I open the Office program directly, they don't show up - only the one stored on the device do. (Although, the text files from SPB Backup stored on the card show up through Office!)
Thing is, I'm sure when I first got the phone, docs stored on SD card showed up when you opened Word or Excel (with a little mem card symbol in the corner of the Office file icon). Any ideas what I might have done to change things.
Am running stock Orange ROM, with too many added cabs and programs to remember, never mind list here!
I have looked through the forum, but I have to admit my attention started to drift by page 205, so forgive me if it already addressed.
On a side note, if you read the entire post list from page 1 to current, it is amazing how many repetitive posts there truly are. If people just updated the previous post re a particular question, rather than reposting, the forum would be 1/3 the pages! Although from experience, the forum search rarely brings up the right entries - I almost always have better luck just scrolling through the pages. Perhaps an index of all post headings and thread addresses would help people to find what they want. Perhaps if I have some free time... Do people think this would be useful?
Anyway, I digress. Any help with the above would be much appreciated (the much dreaded hard reset is hovering at the back of my mind, but I would much prefer a less drastic solution!)
Are they in the storage card root? (\Storage Card)
Also, have you gone into P.Word, Options, & selected the storage card for where to store doc's?
Try this: \Storage Card\My Documents. Also, you must have the templates in the original \My Documents\Templates folder or it will not open word docs.
fisha21 said:
On a side note, if you read the entire post list from page 1 to current, it is amazing how many repetitive posts there truly are. If people just updated the previous post re a particular question, rather than reposting, the forum would be 1/3 the pages! Although from experience, the forum search rarely brings up the right entries - I almost always have better luck just scrolling through the pages. Perhaps an index of all post headings and thread addresses would help people to find what they want. Perhaps if I have some free time... Do people think this would be useful?
Click to expand...
Click to collapse
Really, the wiki is supposed to be the central bank for known issues & the fixes. Kaiser is just too new & no one has really taken charge of the wiki because everyones still try to get everything ironed out & customized.
They are in Storage Card\My Documents\sub-folder
I have already changed the default storage location.
Strangely, Word lists all .txt documents on storage card, regardless of which folder\subfolder they are in - some are not even in My Docs.
But all will open normally if opened via File Explorer.
Further to the above, Word will list the files if they are stored in Storage Card\My Documents but not if they are in subfolders of My Documents. Seems odd, seeing as .txt files show up wherever they are located.
Anyone know of any fix to this, other than dumping all doc files in My Docs, with no sort of filing - seems a bit messy (but not surprising for Microsoft software I guess).
Just discovered that even if I navigate to either my Work or Personal folder via Word, it still does not show the .doc or .xls files there! Apparently my files do not exist, even though I can open them normally via Explorer. What's going on ?!
If you mean that your files dont show after opening word, thats just because Mobile Office programs dont show deeper than the first folder.
There is programs that make them see more deep in the folders and fix this issue, like Pocket Plus 4.
There was some freeware solution to this also, search and you will find...
Thanks Sane for the advice. That certainly explains a lot. I have Pocket Plus 4 installed - I have checked the "File Open/Save Dialog" option when I installed but unchecking and checking it again hasn't made any difference. As mentioned in the OP, I have scrolled through all 220-odd pages and couldn't see any previos posts regarding Office documents. Any idea of the rough direction I should head for more answers??
ive been told this is what it does,can anyone throw some light as to if it works
LC 5 optimizes operations by first scanning for dictionary words, then using various methods of altering dictionary words to create new probable guesses, then (if all else fails) resorting to brute force. To crack a password, the program must select a guessed word, compute the hash, then compare that hash with the stored password hash. LC 5 supports direct hash imports from a local or remote SAM database, a SAM file, an LC 4 file, a PWDUMP file, a Windows NT 4.0 Emergency Repair Disk (ERD), a UNIX password file, or by sniffing the local network. To speed the hashing process, most versions of LC 5 include precomputed hashes and let you create your own precomputed hash tables. During the audit, the tool shows time elapsed and other statistics.
LC 5 also lets you disable accounts or force users to reset weak passwords.
im thinking uploading to a mirror.thanks
I've used it in my younger and more foolish days and it could work. Getting the SAM file was always the hard part
Please don't post the mirror here, I'm not sure on the copywrite issues, but you used to have to pay for it. So any free-version will be cracked.
http://en.wikipedia.org/wiki/L0phtCrack
Moved to Off-Topic.
Ta
Dave
DaveShaw said:
I've used it in my younger and more foolish days, Please don't post the mirror here, I'm not sure on the copywrite issues, but you used to have to pay for it. So any free-version will be cracked.
http://en.wikipedia.org/wiki/L0phtCrack
Moved to Off-Topic.
Ta
Dave
Click to expand...
Click to collapse
thanks for reply,sorry i was posted in wrong place.i wont be mirroring.happy new year
So I recently got very interested in Windows Phone 7 (mango) and I had been thinking about starting to create my own apps for a while. The result is the idea for an app that is as follows:
Name: Crumbs
Possible abbreviation: to send somebody a "crumb"
In short: An app that capable of: writing/creating, organising, sharing and following instructions, AKA crumbs.
What I want to achieve with this is a new option into social networking, but this time it's also very useful and not just fun to show off. What could these crumbs be? Well, I've thought of some categories already:
Routinely task:
like the stuff you do every morning, shouldn't forget, etc.
Work/study task:
some sort of study schedule, with certain points you should handle to complete the whole task.
Preparation/cooking task:
doesn't need any explanation.
Scavenger hunt/adventure:
wouldn't it be great if you can give a list of instructions to someone with some reward at the end?
Travelling:
similar to your adventure, but could contain various flight data or a couple of options (so you don't "finish" an item, but finish 1 item in a dillema.
Other: always have some other category..
User defined: if a user wants to make his/her own category.So these are the categories, but as you've already seen, each category has different types of commands/operations one has to perform to complete the whole task. So when writing a new one, you could filter the entry-options by the ones most important for that category and give the users a seperate option to add another operation than the ones listed by default. Some possible operations and their integration ideas are as stated below:
Action: very straightforward, do something and when executing the crumb you simply check the box when done. Maybe some option with a timer that alerts you that you should be done with the operation soon (for example: cooking).
Navigate: go to a specific location and then you check the operation. Possible GPS integration/maps?
Input: give certain input to go on. For example useful when creating an adventure (go there, look for the church and read what's on it) or something else that should need a password or any other input.
Alert: to alert yourself/the executor OR (and this is important) some other user that you've arrived at a certain operation in your crumb.
Yeah, you read it right, another user. Because one other important aspect of almost every app nowadays is SHARING. So ofcourse, there will have to be the option to share crumbs. People will be able to manage their crumbs on a phone ofcourse, but if there's a lot, wouldn't it be easy to have them stored online too? A place where you can rapidly type, organise and share your crumbs. So there should be a format to save them in (.crumb looks fantastic ). So, you simply send someone the crumb using a public link you create for your privately stored crumb. But what about something called instructors/friends? Wouldn't it be awesome if you can allow certain people to GIVE you crumbs straightaway, so you'll get alerted and know you have to do something (OK, "your mom" wouldn't be awesome, but useful nonetheless). To make things easier for this, the users will have to be able to manage these friends/instructors too and have their own cookie jar/cake box to receive their crumbs directly in (on the website and in the app). I sense some Facebook/social integration, don't you?
Then there's this weird habit of people: they've got calendars and tasks on them. Wouldn't it be great if the crumbs are linked to calendar and/or outlook-task items?
Sooo... This is my (already quite complex) idea. To conclude things once again: the outlook task system isn't capable of managing real tasks. You can give certain progress percentages, but that's just something that could be managed by this app, since it's much more in depth.
Problem is, I'm not that good at developing (yet)! So if any developer out there is willing to take this thing on with me (I just feel this could turn out great), please let me know. Meanwhile, I'll keep dreaming on and I'm a quick learner, so I hope to show a mockup of some sorts soon . I've already thought out some sort of menu structure/frame everything should be hung up in and that's what I'll be working on the time to come.
And keep in mind:
This idea is NOT for sharing by anyone but me right now. That it may be very clear that this idea is not for your own use!
Hi XDA!
I know the forum is mostly aimed at mobile dev but the people here are so good i thought it the best place to ask a question regarding dev in general.
I have a database (mySQL) with rows that contain latitude/longitude values representing the locations of customer complaints. I'd like to plot these on Google Maps / Earth and put up a dashboard so that we can see if there's any particular location that's a 'pain point'... any idea how to do this? I need the plotting step to be completely automated cos I already know how to automatically insert new rows into the mySQL table whenever a new complaint comes in.
I've done some Googling and i usually see people talking about manually importing an Excel file with the co-ordinates... This won't work for me cos we get thousands of calls coming in daily and the whole process needs to be completely automated for it to be practically feasible.
Ok, some background about me: I'm not a 'proper' developer... I've never worked in a structured dev environment. I'm just someone who knows a little bit about dev and I've had to write some code cos there was nobody else to do it
I can do some mid-level Java (I've written a few servlets that run on tomcat ...they listen for HTTP requests and respond with some XML... nothing hectic) and I know enough about mySQL to be able to work with it comfortably.
I'd really appreciate any help with my plotting question
Hello Folks,
I am a bachelor student in germany and at the end of my degree.
Found a bachelor thesis which requires app-developing knowledge.
I am willing to pay to the person/people who can help me with the following topic.
Quizduell is a famous interpersonal game for small computers. It exists for iPhone, Android and Windows Phone. The participants have to answer questions, where 1 out of 4 given answers is correct. These are selected from a database according to topics of the players' preferences. In order to create a non-human player who is supposed to outdo the human participants, this player first would either 1. inherit what is usually considered advanced AI, or 2. start by 'learning', and losing.
Though the chances are 1/4 per random choice, on the other hand per one random win/loss it could garner and store one question, and the correct answer. Since the question-base has a limited number of questions, after some time at playing, the non-human player will have all earlier questions stored, and available from a database, to be answered correctly. The task is, to write a software that intercepts the character string of the questions, as well as the correct answers, probably by an application somewhere within one of the supported devices. Therefore, experience with applications for either of the platforms would be advantageous.
discussion regarding reward will take place if any personal interest arises.
Thanks in advance