yashsingh1/xdaforums huggingface dataset:
[Off-topic] truthlesshero:
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!
[Off-topic] 85gallon:
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.
[Off-topic] truthlesshero:
thanks! exactly what i was looking for...
[Galaxy S III General] dhendy91:
EDIT: After some issues people were having updating with Google wallet installed I have decided to remove this guide and I am going to ask for the thread to be closed.
[Galaxy S III General] ceo.mtcl:
I've been using it also on cm9 since yesterday and I got free ten bucks which I used to get my dogs nails done. :) at petco.
[Galaxy S III General] dhendy91:
Yea its great isn't it. Just though I would make this as two people in the UK have already asked me how I got it working.
[Galaxy S III General] ceo.mtcl:
Im in USA :) but it is cool.
[Galaxy S III General] dhendy91:
Lucky:p
[Galaxy S III General] EnemyOfGlaDOS:
dhendy.. thanks for making this thread. I put a link in the OP of the [INFO] thread with credits to you.. thanks again bud!:)
[Galaxy S III General] anuj25:
I somehow can't get it to activate my account
[Galaxy S III General] xTristinx:
Same problem here . i had it working then i installed a new rom without wiping the google wallet app but i didnt factory wipe either. so now its stuck at activating device
[Galaxy S III General] futaris:
What is in /system/build.prop on CM9?

On a Samsung Stock ROM:

ro.product.model=GT-I9300

ro.product.device=m0

According to http://www.pocketables.com/2012/06/...ning-on-your-rooted-htc-evo-4g-lte-maybe.html they modified both to GT-I9300 to get it working on a EVO 4G LTE.
[Galaxy S III General] Mr. Droid:
Im in canada and I don't have a citi mastercard

how did you get the $10 ?
[Galaxy S III General] xTristinx:
GT-I9300

---------- Post added at 04:59 PM ---------- Previous post was at 04:58 PM ----------

activate the google prepaid and if you want to add a card use a vanilla mastercard but put a us zip when registering it

---------- Post added at 05:22 PM ---------- Previous post was at 04:59 PM ----------

this is what i get with log cat. Its just says nfc is going on and off. Im soooo confused and im not sure if my secure element is broken or not
[Galaxy S III General] dhendy91:
What ROM is it because I only have it working on CM9 at the moment. When I tried it on a sammy based ROM it always got stuck there aswell.

As for the secure element problem as far as I'm aware you will get a message along the lines of "secure element broken" so I doubt it is broken.

At a guess i would say it is more to do with the ROM you moved too, could you let me know what it is so i can update the OP

Thanks
[Galaxy S III General] xTristinx:
its cm9 0.0 i updated from 18-19th
[Galaxy S III General] stifmaister:
Hello,

i have exactly the same problem. It was working fine before, but after i updated CM9 it gets stuck during activation. I also tried to revert to an old CM9 version , but it doesn't seem to be working anymore...

Cheers

Sergio
[Galaxy S III General] Mr. Droid:
Everytime I try to activate the Google prepaid it fails!

Any suggestions
[Galaxy S III General] xTristinx:
i was checking out some of my logcats and it was turning the nfc on and off. i then flashed omega and it showed there was 0 secure elements. You need a new phone because your secure element is now broken. It just doesnt show any se errors because the phone is not officially supported so only logcat can show it.
[Galaxy S III General] dhendy91:
Sorry to hear that mate I will move the warning further up the page so hopefully it won't happen to anyone else . As far as i'm aware it will only affect Google wallet though. The only thing I can think to try is going back to stock and using the dialer code to hard reset your phone of course backing up all your important files and backups as it will completely reset your phone. Not even sure if that will work though.
[Galaxy S III General] Roastario:
I'm trying to add a google prepaid card but it just seems to hang forever. In logcat, I get loads of:

E/DeviceCapabilityManagerImpl( 2777): OperatorName=3, Operator=23420, Product=GT-I9300, Model=GT-I9300 not supported

E/DeviceCapabilityManagerImpl( 2777): OperatorName=3, Operator=23420, Product=GT-I9300, Model=GT-I9300 not supported

E/DeviceCapabilityManagerImpl( 2777): OperatorName=3, Operator=23420, Product=GT-I9300, Model=GT-I9300 not supported

E/DeviceCapabilityManagerImpl( 2777): OperatorName=3, Operator=23420, Product=GT-I9300, Model=GT-I9300 not supported

E/DeviceCapabilityManagerImpl( 2777): OperatorName=3, Operator=23420, Product=GT-I9300, Model=GT-I9300 not supported

E/DeviceCapabilityManagerImpl( 2777): OperatorName=3, Operator=23420, Product=GT-I9300, Model=GT-I9300 not supported

E/DeviceCapabilityManagerImpl( 2777): OperatorName=3, Operator=23420, Product=GT-I9300, Model=GT-I9300 not supported

E/DeviceCapabilityManagerImpl( 2777): OperatorName=3, Operator=23420, Product=GT-I9300, Model=GT-I9300 not supported

E/DeviceCapabilityManagerImpl( 2777): OperatorName=3, Operator=23420, Product=GT-I9300, Model=GT-I9300 not supported

E/TsaRegistrationImpl( 2815): Invalid state: Attempting to re-register.

E/DeviceCapabilityManagerImpl( 2777): OperatorName=3, Operator=23420, Product=GT-I9300, Model=GT-I9300 not supported

E/TsaRegistrationImpl( 2815): Invalid state: Attempting to re-register.

E/DeviceCapabilityManagerImpl( 2777): OperatorName=3, Operator=23420, Product=GT-I9300, Model=GT-I9300 not supported

Any idea?
[Galaxy S III General] xTristinx:
As i know the only solution to get it fixed is to get a new phone. since it is only the 21st you should be able to get a new phone from whom ever you ordered it from
[Galaxy S III General] dhendy91:
Well I have just successfully managed to remove it and re-install it. However I am going to remove this guide now and ask for this thread to be closed just encase this happens to anyone else. Just don't think it is worth the risk until i know it is defiantly working with no issues.
[Galaxy S III General] xTristinx:
Its not just a problem with the s3, its the application itself as this problem has been happening on both nexus's and the evo 4g lte.

If anything just add a disclaimer with huge font at the beginning stating that if done you are not held responsible and that it can enable your phone to not be able to use google wallet again if you wipe without removing data from within the application
[Motorola Atrix 2] Daerci:
I rooted my atrix 2 then changed the build.prop to optimus 2x so that I would be able to play order and chaos online.

Now my phone screen glows when it's in sleep mode and my screen won't rotate(can't tilt my phone in temple run either). Does anyone know how to fix this without making order and chaos unplayable?
[Motorola Atrix 2] Fall of Enosis:
Same thing happened to me. The only way I could fix it was to restore to a previous saved backup in CWM. Hope you made a backup!

I would advise against making modifications in that fashion. And always make a backup when doing so!
[HTC Amaze 4G] Dark Nightmare:
Instead of posting a new thread, I edited this one instead:p

So here's another theory of mine, the OTA files check cid correct? this is located in the build.prop file? Any others this can be found in that it checks for it?
[HTC Amaze 4G] EclipzeRemix:
You can't push the radio without S-OFF, the radio is just as important as the hboot. The only way to flash the radio while S-ON is to flash the entire Update.zip through hboot screen. And if you are not on T-Mobile you need to be S OFF
[HTC Amaze 4G] Dark Nightmare:
Ah, I see, thanks.

Sent from an Amaaaaaazing place :-D
[HTC Amaze 4G] Dark Nightmare:
Bump

Tonight I'll go back to stock gb on telus, swap the build.prop file with the mobilicity file and test my theory if that's all I need to swap :p
[HTC Amaze 4G] skugpezz:
Cant wait to see results :D
[HTC Amaze 4G] Dark Nightmare:
Me too, this is actually for you guys, if it's possible, gonna make a flashable zip from the stock, try to include the stock recovery in the boot.img, but gotta gather some info first, then test.
[HTC Amaze 4G] glacierguy:
If I'm not mistaken... People are flashing eu radios on the us One S and we don't have s=off :confused:

http://xdaforums.com/showthread.php?t=1684477
[HTC Amaze 4G] Dark Nightmare:
This isn't for a radio bro, though that makes me wonder why we can't do certain things on the amaze.

This is gonna be a cwm flashable of a telus stock with the mobilicity build.prop so users that are s-on stuck on GB due to them flashing a stock rom and not having a backup or it just not working for them to be able to flash my zip, restore the stock recovery and update with the OTA.
[HTC Amaze 4G] skugpezz:
I would be so happy if this works .
[HTC Amaze 4G] Shivammcool:
Thanks alot! Can't wait

Follow me @Shivammcool
[HTC Amaze 4G] fcpelayo:
There's a mobilicity ruu now
[HTC Amaze 4G] Shivammcool:
Where? How do I flash it? I'm am on a custom GB rom

Follow me @Shivammcool
[HTC Amaze 4G] skugpezz:
We need an exe, not a zip.
[HTC Amaze 4G] fcpelayo:
Lock your bootloader put ruu in sdcard as ph85img.zip I think then let it do It's thing... But I'm not sure you should read the amaze bible gives you noob directions search it

Why
[HTC Amaze 4G] Dark Nightmare:
That's an ota file, you have to be on complete stock GB to flash that....that's the purpose of this thread.

Okay, less talk and let's get some info together please, a devs opinion would be greatly appreciated, I'm gonna do my own test in a minute.
[HTC Amaze 4G] skugpezz:
From what I understood.

Being S-on We need to be coming form stock GB to get ICS.
[HTC Amaze 4G] Shivammcool:
Again, Thank You

Follow me @Shivammcool
[HTC Amaze 4G] Dark Nightmare:
Got pass the cid check using the swapped build.prop file, ran into a system's patch error when it checked another app, pm sent to my app provider....
[HTC Amaze 4G] EclipzeRemix:
It's not really a smart move to change the CiD without knowing how the radio is for that carrier. And flashing a RUU from another carrier is possible if it's not changing things like hboots
[HTC Amaze 4G] skugpezz:
That is some progress :D
[HTC Amaze 4G] Dark Nightmare:
I know there's risk, that's why I'm testing it myself, hopefully being s-off can save me from a brick if it comes down to that.
[HTC Amaze 4G] fcpelayo:
Sorry wouldn't know about s-on but I'm sure there's instructions for that as well. Why not s off

Sorry dark nightmare don't mean to spam your thread lol
[HTC Amaze 4G] Dark Nightmare:
Na, it's cool, I'm just trying to find a way to get these folks updated.
[HTC Amaze 4G] EclipzeRemix:
Actually if your S OFF you might completely brick your device, S ON is much safer
[HTC Amaze 4G] Dark Nightmare:
I gave up for now, I need a copy of the entire system folder, which I don't have, obviously, emailed htc asking them for the ruu, hopefully they can provide me with it.
[HTC Amaze 4G] fcpelayo:
Get a hold of football although he might have too many ppl trying to reach him and possibly ignore you lol. Although money moves ppl. Just saying haha
[HTC Amaze 4G] Dark Nightmare:
I'd pay for the file if he can pull it for me, paying is no issue.

Sent from an Amaaaaaazing place :-D
[HTC Amaze 4G] fcpelayo:
Are you able to use the file that was uploaded by football and krooks newer files?
[HTC Amaze 4G] fcpelayo:
Any response on this?
[HTC Amaze 4G] Dark Nightmare:
I had pm'ed football, he already posted the file, no need for me to find a workaround anymore.
[Galaxy Note GT-N7000 Q&A, Help & Troubleshooting] trea916:
What rom has the most galaxy s3 features and looks rocketrom

,kingdroid-note mainia or mid note and which do you like the best thanks
[Galaxy Note GT-N7000 Q&A, Help & Troubleshooting] devwithzachary:
Wrong section -_- read the dam stickys
[Galaxy Note GT-N7000 Q&A, Help & Troubleshooting] O_G:
Moved To Q&A​

Please post in the correct section​
[Galaxy Note GT-N7000 Q&A, Help & Troubleshooting] noteics:
I think RocketRom v5.
[Galaxy S III Q&A, Help & Troubleshooting] moqs:
Hi Folks!

A had been wondering about the usage of s memo like on galaxy note. I mean i want to take a screan shot and right after this i would like to draw something on it etc... Now i have to take a screen shot thank open s memo and than insert an image. How can i make it easier?
[Galaxy S III Q&A, Help & Troubleshooting] norpan111:
I'm with you
[Galaxy S III Q&A, Help & Troubleshooting] speedfreak228:
Haven't got my s3 cuz it isn't realised in USA yet but I would like this too
[Galaxy S III Q&A, Help & Troubleshooting] ronj1986:
It's not that easy, but easy enough. Take a screenshot. Click on it from the Notifications @ top, choose the share button, See All, choose S memo. Then expand the picture and edit as you would like.
[Galaxy S III General] Longun:
As I posted in the dev thread let's bring the chit chat into the general forum and keep the dev thread on topic and clear for people to help the devs move this rom forward.

So this thread is for all the GENERAL CM9 discussion.
[Galaxy S III General] norpan111:
Everybody suck
[Galaxy S III General] Longun:
Informative.
[Galaxy S III General] g00ndu:
Despite this, people will still go to the development thread to ask questions, request features, banal talks... etc. :(
[Galaxy S III General] own4d:
Maybe use this thread to summarise FAQ's found in the other thread (and subsequently this thread)

Edit the first post to stay on top of things?

In summary, no exfat on CM9, use ext4 format if you must have files over 4Gb (that's all I know so far, I don't have CM9 installed yet)
[Galaxy S III General] P1n3apqlExpr3ss:
*subbed*

Get xplod to put a link to this thread in the development OP? A link to that thread from here wouldnt hurt either
[Galaxy S III General] Totòòò:
is there a way to block calls in cm9? (without having to install an apk from the market)
[Galaxy S III General] jblazea50:
I don't have phone yet; however, was wondering if on cm9, do you still have the same camera function as with touchwiz, like fast burst, best shot, taking pic while recording? I don't really care about losing s voice.
[Galaxy S III General] Totòòò:
Bot yet i think but soon u will have them al
[Galaxy S III General] alecm88:
Just wondering if anyone knew of a video player with live previews (in thumbnails) like the original one.

By the way great rom, I moved from Galaxy S II and was surprised to find it on the S III so fast.
[Galaxy S III General] Longun:
Nice idea. Once I'm back from holiday on the weekend I'll get to work bringing all the known fixes, work arounds ,tweaks and tips into this thread. Would take an age doing it on the phone.

Still flashing nightly builds whilst away :D
[Galaxy S III General] Longun:
Will do.
[Galaxy S III General] Ph3rOn!xX:
Hey can any one extract the crt animation ( screen of &on) frm this rom & make a flashable zip file ?? Plzz Plzz

I want 2 use in my stock rom...

Plzz
[Galaxy S III General] Khizar:
Next time try using Google..cuz thats what i did and it was the first link ;)

http://xdaforums.com/showthread.php?p=27549498
[Galaxy S III General] swent:
I don't think that's what he was looking for. And I'm not sure if you can just apply the crt animations from CM9 to stock ROM.
[Galaxy S III General] sinkingfish:
Has anyone managed to get MTP to work in OS X? Android file Transfer doen't detect device. Xplodwild said it works but not for me here!
[Galaxy S III General] Tectas:
If it's like on linux i guess you need to install an mtp library to get it working (i.e. mtpfs).
[Galaxy S III General] sinkingfish:
Android File Transfer worked fine on stock using PTP and works great with my friends Gnex. Googled mtpfs for OS X but nobody seems to have had any success.

Hope codeworkx & XpLoDWilD are able to get mass storage working.
[Galaxy S III General] own4d:
Would Android beam on CM9 work with S-beam? Ie someone on stock samsung rom uses s-beam to communicate with me on android bean, no issues?
[Galaxy S III General] own4d:
Could we use NTFS on the 64Gb SD card on the GSIII using CM9?

If not.. could I somehow parition the microSD card into x2 32Gb partitions, one ext4 the other ExFAT that way I can run with this until one of the other prevails? I only like copying data once....
[Galaxy S III General] codeworkx:
Vold only supports FAT32. No exFAT, no NTFS, no ext4.

Ext4 might be implemented soon, if i get time.
[Galaxy S III General] wolfboy1984:
Can someone point be to the cm9 compatible 'smart stay' clone apk please.

I know it's about but can't find it in search.
[Galaxy S III General] wonderwout:
http://xdaforums.com/showthread.php?t=1701363
[Galaxy S III General] MiG123:
any idea what's the stock kernel used in CM and where i can download it? flashed siyah 1.2.6 which broke my call volume...
[Galaxy S III General] norpan111:
Reflash the rom without wipe
[Galaxy S III General] ethanfel:
Hello :)

Someone know if the gyroscope is working with CM9 ? For games like Dangerous, titlt control are awesome :)
[Galaxy S III General] ElenaPower:
Looks as if you have the same problem as some others have since they flashed Siyah 1.2.6.
[Galaxy S III General] TotallydubbedHD:
so how is the ROM?

I've liked CM9, but never been a real fan for several reasons - the main one being battery life.

Could someone, who is neutral, and not a fanboy of any dev, tell me the pros and cons of CM9 vs omega and/or stock LF2?
[Galaxy S III General] wststreet:
Should I?

I've had CM9 on my SGS and I was very happy with it, was getting 3 times more battery life with it and it was very fast.

I got my S3 a few days ago and I'm alraedy having problems with Samsung's ROM. Should I go with CM9? Is it worth losing my warranty? Is it worth giving up on all the Samsung tricks that come with the stock ROM?
[Galaxy S III General] TotallydubbedHD:
well if you're on XDA, you should know that, flashing is not the question :p

FYI: You can get your "warranty back" by following my guide.

So I wouldn't worry about that.

What problems are you facing on the stock rom, out of interest?
[Galaxy S III General] wststreet:
Thanks for that guide.

I often get speed problems, I'm not 100% sure but I think it might be the messaging app that's causing it when I get the delivery report. I asked here ( http://xdaforums.com/showthread.php?t=1727393 ) but I didn't get any replies yet.

Other problems are justs my tastes in the design of this ROM.

I should mention, even if I'm on XDA, I'm usually scared of doing stuff to my phone, always unsure of my ability to do stuff right.

Edit: I think it was your guide that I followed when I installed CM9 on my i9000
[Galaxy S III General] TotallydubbedHD:
haha it's a small world :p

Well if you need guidance give me a shout- your first point of call would be to root/install CWM - that won't affect the rom or anything - but regarding speed issues, I would think two things:

-CPU on power saving (although I always have it on)

-RAM release (clearing the ram)
[Galaxy S III General] wststreet:
Thanks, I apreciate your offer to help me :)

CPU isn't on power saving, clearing the ram does fix the problem, but it takes forever to get to the clear ram button because of how slow it is during that problem.

Regarding CM9, I think I'll give it a try, I can always make a backup of the stock rom and see if the camera led works for me, that was the only one that bothered me from the Known Issues
[Galaxy S III General] ethanfel:
the biggest issue is the lost autonomy (stock autonomy is awesome) and for you loose the sammy "goodies". Smartstay etc.

It's a first for me but i like very much sammy stock room, even the theme. I was on CM9 too on my SGS (it's still use cm9).
[Galaxy S III General] TotallydubbedHD:
cool beans!

FYI nandroid was 1.8GB for me

and remember you'll have to root I think before flashing CM9
[Galaxy S III General] wststreet:
Strange, CM9 was the one that made my i9000 last at least a day, after CM9 it could even last two days. But I don't need that, I need it to last from morning to evening with moderate ussage (including 2G data).
[Galaxy S III General] TecQuality:
guys i need a tip: just downloaded aLogcat from gplay, so i need to know how it works: just start the app then run the other device app and finally select 'save' into aLogcat?
[Galaxy S III General] wststreet:
Yes, the log is a common log from all the apps so you'll have to save it fast before the buffer is emptied. Since there are other apps running you'll have to copy it on your PC for easier use. You can thene search for all logs from your app.
[Galaxy S III General] TecQuality:
yes i can save a .txt file into my SD_card, but i'm wondering about the logs, should save the 'error' level, or 'verbose', or 'fatal' or whatever?
[Galaxy S III General] wststreet:
If you wrote the app then you set your own level when writing to the log. So you should know what you are looking for.

Here you can find the levels: http://developer.android.com/reference/android/util/Log.html

If you're unsure, use verbose, I think that displays all the logs.
[Galaxy S III General] TecQuality:
no, i just need it to help the developers if i find out some issues using ROMs or APKs :) btw thanks for your help :)
[Galaxy S III General] wststreet:
Well then, go for the error level, if you can't find anything useful there, try the warning level. You're welcome and I hope you can find what you are looking for :)
[Galaxy S III General] TecQuality:
i've another little question: the notification LED works without any issue? :p
[Galaxy S III General] zbraniecki:
I have this one dream/question for CM9 and SGS3 - would it be possible to merge the single most amazing new feature of SGS3 - stay awake - with CM9.

I've read about OpenDesign, and saw this: http://opendesign.bbqdroid.org/features/?cat=1&feature=1 - but their plan is clearly different. They want to let me "inform" the phone that I want it to stay awaken every so often (like - shake it). What TW is doing does not require my active notification and it's a real game changer.

I assume that they are aware of how TW achieves that and they consciously decided to go for another route. I'm wondering if there's any project to bring exactly this way of achieving "stay awake" for CM9.
[Galaxy S III General] codeworkx:
No problem, code it and send it up to code review.

"Current step: The feature is pending a developer.

This feature has no developer so far."