If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Hey Ken,
Checked it out with a song and it works perfectly. I think you are much more musically advanced than I am -- I play by ear, but have been playing for about 30 years and it took me about 15 years before poeple didn't immediately get up and leave the room when I played, but I do continue to improve. Anyway, I have sent the song I put in their up to my domain for you to check out. What is a CV? Anyway, it is at http://ssor.net/Sheet/ I realized that you can build a whole songbook with it. Ross "Ken Johnson" wrote in message oups.com... Ross, I'm glad to hear that, I'll add Garbage Reminding Service to my CV ;-) Actually I don't have a CV, I've been teaching in state schools for almost 29 years and am looking forward to retiring at the end of 2009, then I can do all the Excel I like. Excel is so complex even if I live to a hundred I'll still only know a tiny fraction of its workings. What sort of guitar do you play? The best guitars come from USA.I've got an old Epiphone acoustic that I bought second hand in 1978. It's got a lovely mellow tone and is really easy to play. I've also got a Gibson ES 175D but I haven't played it for a long time. One of the plastic tuning knobs perished and broke and I haven't yet been able to replace it. I love the Beatles' music (who doesn't) and I try to play jazz. I can't improvise unfortunately, but my chord playing is OK. I know it's not guitar, but I'm a big fan of Bix Beiderbecke. I had a go at playing the cornet when I started teaching, which was in a country town, Finley, with a population of just 2000 and a 7 hour drive from Sydney, where I grew up. I joined the Finley Brass Band and was taught how to play. They were pretty desperate for players. They even supplied the cornet, which was an American long cornet, just like the one Bix played. I was gobsmacked. However, my playing never came within a bull's roar of sounding like Bix, I rarely got to play solo cornet and my lip got tired very quickly. Still, I did manage to play in the band for most of the 9 years I taught in Finley. By the way, have you heard of a band called Spider Bait? Their lead singer,Janet English was Girls' School Captain at Finley High School when I was teaching there. Before Spider Bait had even formed I was playing (rhythm guitar and the occasional cornet for a laugh) in a 50/50 Bush/Rock band and we called ourselves Blinky Bill, which was partly a reformation of an earlier band called Mulwala Bill and the Far Canals (Finley is in the Riverina Irrigation area and gets its water from the Mulwala Canal). After I left Blinky Bill, because I was moving back to Sydney, Blinky Bill became Spider Bill. I still don't know if the name Spider Bait was just a coincidental similarity or whether it was a deliberate copy. Spider Bait would have formed after Spider Bill. My favourite jazz guitarist is John Scofield. He has played in Australia a few times and I've seen him twice, quite a while ago now. I'd better go now I have to deliver about 450 local newspapers today. My daughter starting doing it about 4 years ago, quickly lost interest and left it for me to do, which I don't mind, I need the exercise (Doing Excel exercises the mind but not the body!) and I get paid for it. Ken Johnson |
#22
|
|||
|
|||
Hi Ken
Last night I was just getting ready for bed when I wrote that post, and was half asleep. I wanted to add: I tried to paste in the "I Will" after copying it from a word file that already had the chords over the lines and realized that the chords, like the text would all be pasted in column A, so I had to remove the chords after pasting them in and then re-insert them manually. I can't even begin to tell you how impressed I am that you were able to create this wonderful tool.. I also wanted to add that I have always been fascinated with Australia and have even considered pursuing my profession -- itinerant O&M instructor, and even looked into it a little when I first started in the field(that was at age 52 when I got my degree and certification 5 years ago). But, when I contacted officials in the field to discuss it via email, they informed me that firstly, I would have to have at least one year teaching experience before I could be considered and secondly, if I did get hired to a position, the likelihood that I would need to travel by plane to many of my clients, due to vast distances between them. This put a damper on that. Do you live in an urban or rural area? Can you look out your window and see things like Kangaroos, Koalas and Wallabies? I was pondering the synchronicity of it all between us -- Guitar, excel and garbage pickup on the same day, when I realized that in fact we don't have garbage pick-up on the same day. Mine is on Wednesday -- that is today. It is Thursday for you, right? Or did I figure my international time incorrectly. If you could, please give me your address, so I can go to Google Earth (have you checked that out -- a satellite image of any place in the world! It is a free download from http://earth.google.com/) and check out where you live. I am at 306 N. Highland Ave, East Syracuse, New York . If you download the Google Earth program and punch in that address, your screen will fly you across the planet, as if you were in a space ship and you can then zoom in and see a satellite image of my house. Ross "Ross" wrote in message ... Hey Ken, Checked it out with a song and it works perfectly. I think you are much more musically advanced than I am -- I play by ear, but have been playing for about 30 years and it took me about 15 years before poeple didn't immediately get up and leave the room when I played, but I do continue to improve. Anyway, I have sent the song I put in their up to my domain for you to check out. What is a CV? Anyway, it is at http://ssor.net/Sheet/ I realized that you can build a whole songbook with it. Ross "Ken Johnson" wrote in message oups.com... Ross, I'm glad to hear that, I'll add Garbage Reminding Service to my CV ;-) Actually I don't have a CV, I've been teaching in state schools for almost 29 years and am looking forward to retiring at the end of 2009, then I can do all the Excel I like. Excel is so complex even if I live to a hundred I'll still only know a tiny fraction of its workings. What sort of guitar do you play? The best guitars come from USA.I've got an old Epiphone acoustic that I bought second hand in 1978. It's got a lovely mellow tone and is really easy to play. I've also got a Gibson ES 175D but I haven't played it for a long time. One of the plastic tuning knobs perished and broke and I haven't yet been able to replace it. I love the Beatles' music (who doesn't) and I try to play jazz. I can't improvise unfortunately, but my chord playing is OK. I know it's not guitar, but I'm a big fan of Bix Beiderbecke. I had a go at playing the cornet when I started teaching, which was in a country town, Finley, with a population of just 2000 and a 7 hour drive from Sydney, where I grew up. I joined the Finley Brass Band and was taught how to play. They were pretty desperate for players. They even supplied the cornet, which was an American long cornet, just like the one Bix played. I was gobsmacked. However, my playing never came within a bull's roar of sounding like Bix, I rarely got to play solo cornet and my lip got tired very quickly. Still, I did manage to play in the band for most of the 9 years I taught in Finley. By the way, have you heard of a band called Spider Bait? Their lead singer,Janet English was Girls' School Captain at Finley High School when I was teaching there. Before Spider Bait had even formed I was playing (rhythm guitar and the occasional cornet for a laugh) in a 50/50 Bush/Rock band and we called ourselves Blinky Bill, which was partly a reformation of an earlier band called Mulwala Bill and the Far Canals (Finley is in the Riverina Irrigation area and gets its water from the Mulwala Canal). After I left Blinky Bill, because I was moving back to Sydney, Blinky Bill became Spider Bill. I still don't know if the name Spider Bait was just a coincidental similarity or whether it was a deliberate copy. Spider Bait would have formed after Spider Bill. My favourite jazz guitarist is John Scofield. He has played in Australia a few times and I've seen him twice, quite a while ago now. I'd better go now I have to deliver about 450 local newspapers today. My daughter starting doing it about 4 years ago, quickly lost interest and left it for me to do, which I don't mind, I need the exercise (Doing Excel exercises the mind but not the body!) and I get paid for it. Ken Johnson |
#23
|
|||
|
|||
Ross,
CV = Curriculum Vitae, which is a document outlining your, qualifications, abilities, achievements etc. You submit your CV to a prospective employer and if they like what they read you're one step closer to getting the job, otherwise you're culled out. I've never had to put one together but my son Eric had to for a job in a carwash cafe, making coffees and serving food to customers while their car is being washed and polished. He got the job and he's there right now. My daughter also had to submit one for her casual job (mainly cashier work) at Target, a Chain of Department stores. Target is pretty down-market so everybody jokingly pronounces it Tar-shay to improve its image. CV's are a recent phenomenon. I applied for my first job (apprentice photoengraver-etcher) in 1966 and got the job because I could write my name. Technological change put an end to that job. After just 2 years of a 4 year apprenticeship the number of workers had halved. My job served the letterpress printing industry which was losing work to the lithographic printing industry. I could see no future in my job so I completed school at night while completing the apprenticeship by day. I then went through Uni with the support of a Teachers' Scholarship. I was actually paid to go to Uni (We baby boomers had it so easy. I feel sorry for my kids, without parental support they're stuffed). It's funny you should ask me about seeing kankaroos etc out the window. It's a long standing joke that Americans think that kangaroos hop down George St (the main street of Sydney). About 18 years ago I was teaching at Pit****er High School Mona Vale. Mona Vale is a beachside suburb in Sydney's north and about a 30 min drive from where I live (68 William St Roseville Sydney, one of the northern suburbs). The school has a sister school in USA, I think it's called New Trier High, but I forget where it's located. A visit was organised and we had the company off a New Trier High science teacher and some students for a couple of weeks. One morning, during that two week visit, as I was driving to school a wallaby hopped across the road in front of me. (the road passes through a National Park). This was a unique experience for me, and some Americans returned home from Australia knowing that kangaroos on George St is not all that far from the truth. I've had a look at your songbook. How do you set up those textboxes with hyperlinks on the menu sheet? I'd like to know how to do that, it looks useful. Could you put one of your song word docs on your site? Word is controlled by its version of VBA, I've used it a little bit and I might be able to do something about the problem you explained (could take a while though). I'm keen to manipulate Word through Excel's VBA. It involves using references, of which I know very little, and this looks like an opportunity for me to get started on a new VBA skill. I haven't yet looked at that Google Planet Earth thingy (what ever it's called), I clicked on the Preview button to review what I've typed then when I returned to edit I can no longer refer to your messages. I'm scared I'll lose everything if I fiddle around trying to get back to your messages, it's happened to me before. I too play guitar by ear. The only time I read music is when I play cornet, which is never these days. I used to do things like play a 45 rpm record at 33 1/3 to slow down fast riffs (still couldn't play some of them) or 78 rpm to raise the pitch and audibility of bass lines, but that was a long time ago. I don't have perfect pitch but I have been able to work out some of John Scofield's weird chords. A music teacher once asked me to work out the chords off a tape recording and she was pleased with the result. My daughter plays the trumpet and has done quite well. She's up to grade whatever(I've lost count). She's wearing braces at the moment, and they have held her back a bit. They come off sometime next year. She's studying music for her Higher School Certificate and sometimes hints at becoming a high school music teacher. I try to steer her away from that idea. We Australian teachers are constantly having to go on strike to improve our pay and conditions but we always seem to be going backwards. When I started teaching in 1977 our pay was equivalent to that of a politician on the back benches, who are now way ahead of teachers. Getting back to the songbuilder: Please don't take offence (We need them to keep in the kangaroos) but I'm not happy with the chords for I Will. I've played them and, to me, something sounds wrong. You can call me a pedant, I won't mind, but my preferred chord sequence for I Will is A, F#m, Bm, E, A, F#m, C#m (we differ here), A, D, E, F#m, A, D, E, A, A7, D, E, F#m, D, E, A, D, E, F#m, B, E. I'm just using my ear here, I haven't bothered to listen to the track or look up the music and there are, from memory, a couple of spots in the song where there are a some strong and fast chord changes that I have missed out. Try out my chords and let me know what you think. Do you sing when you play? When I was in the Bush/Rock band in Finley I sang a few songs to give our singer the odd break, and the only thing I had thrown at me was a pair of panties (obviously done as a joke by a friend in the audience). Bye for now, I've got some marking I must get done these holidays and time is slipping away. Ken Johnson |
#24
|
|||
|
|||
Ross,
I downloaded Google Earth and it flew straight to your place. Is that a backyard swimming pool a few houses from you? Does it get that hot in summer and snow and ice in winter? I typed in my address and it failed to find it . It even failed to find Chatswood, Sydney, the next suburb and Sydney's third biggest business district. I don't know what's wrong there. Let me know how you go with it? I can find my place manually and email it. Or maybe you can input latitude and longitude. Do you know if that is possible? By the way, you were right first time about our garbage collections, we're both Wednesday (review your use of the international dateline. I never get it right either.) Ken Johnson |
#25
|
|||
|
|||
Ross,
Latitude and longitude of the cursor are shown at the bottom on the left. Just keep moving the Earth until the cursor is at 33 deg 47' 18.40" S and 151 deg 11' 00.30" E and you should be on top of the Hanzmann-Johnson dwelling (My wife wanted to save the Hanzmann name from extinction by tacking mine on to hers. She is from a family of three girls.) Ken Johnson |
#26
|
|||
|
|||
Couldn't get exactly to those coordinates. Can I just have your phyiscal
address -- Street, number and postal code should do. "Ken Johnson" wrote in message oups.com... Ross, Latitude and longitude of the cursor are shown at the bottom on the left. Just keep moving the Earth until the cursor is at 33 deg 47' 18.40" S and 151 deg 11' 00.30" E and you should be on top of the Hanzmann-Johnson dwelling (My wife wanted to save the Hanzmann name from extinction by tacking mine on to hers. She is from a family of three girls.) Ken Johnson |
#27
|
|||
|
|||
I will answer longer later on rest of this message, but creating the textbox
hyperlinks is easy Just create a textbox from the draw menu and put the desired text in it. then right-click it and one of the items on the menu that drops down is hyperlink. Select that and in the "insert hyperlink" dialogue box that opens, click icon on middle left that says "place in this document" Then in the box in the middle, you will see the tabs of the page listed. Just click on the desired tab you want the textbox to link to and click ok. Note that when you click on the tab, the cell reference in box above that comes in at A1 automatically, but you can make it go anywhere on the sheet by typing in any cell reference. Ross Ken Johnson" wrote in message oups.com... Ross, CV = Curriculum Vitae, which is a document outlining your, qualifications, abilities, achievements etc. You submit your CV to a prospective employer and if they like what they read you're one step closer to getting the job, otherwise you're culled out. I've never had to put one together but my son Eric had to for a job in a carwash cafe, making coffees and serving food to customers while their car is being washed and polished. He got the job and he's there right now. My daughter also had to submit one for her casual job (mainly cashier work) at Target, a Chain of Department stores. Target is pretty down-market so everybody jokingly pronounces it Tar-shay to improve its image. CV's are a recent phenomenon. I applied for my first job (apprentice photoengraver-etcher) in 1966 and got the job because I could write my name. Technological change put an end to that job. After just 2 years of a 4 year apprenticeship the number of workers had halved. My job served the letterpress printing industry which was losing work to the lithographic printing industry. I could see no future in my job so I completed school at night while completing the apprenticeship by day. I then went through Uni with the support of a Teachers' Scholarship. I was actually paid to go to Uni (We baby boomers had it so easy. I feel sorry for my kids, without parental support they're stuffed). It's funny you should ask me about seeing kankaroos etc out the window. It's a long standing joke that Americans think that kangaroos hop down George St (the main street of Sydney). About 18 years ago I was teaching at Pit****er High School Mona Vale. Mona Vale is a beachside suburb in Sydney's north and about a 30 min drive from where I live (68 William St Roseville Sydney, one of the northern suburbs). The school has a sister school in USA, I think it's called New Trier High, but I forget where it's located. A visit was organised and we had the company off a New Trier High science teacher and some students for a couple of weeks. One morning, during that two week visit, as I was driving to school a wallaby hopped across the road in front of me. (the road passes through a National Park). This was a unique experience for me, and some Americans returned home from Australia knowing that kangaroos on George St is not all that far from the truth. I've had a look at your songbook. How do you set up those textboxes with hyperlinks on the menu sheet? I'd like to know how to do that, it looks useful. Could you put one of your song word docs on your site? Word is controlled by its version of VBA, I've used it a little bit and I might be able to do something about the problem you explained (could take a while though). I'm keen to manipulate Word through Excel's VBA. It involves using references, of which I know very little, and this looks like an opportunity for me to get started on a new VBA skill. I haven't yet looked at that Google Planet Earth thingy (what ever it's called), I clicked on the Preview button to review what I've typed then when I returned to edit I can no longer refer to your messages. I'm scared I'll lose everything if I fiddle around trying to get back to your messages, it's happened to me before. I too play guitar by ear. The only time I read music is when I play cornet, which is never these days. I used to do things like play a 45 rpm record at 33 1/3 to slow down fast riffs (still couldn't play some of them) or 78 rpm to raise the pitch and audibility of bass lines, but that was a long time ago. I don't have perfect pitch but I have been able to work out some of John Scofield's weird chords. A music teacher once asked me to work out the chords off a tape recording and she was pleased with the result. My daughter plays the trumpet and has done quite well. She's up to grade whatever(I've lost count). She's wearing braces at the moment, and they have held her back a bit. They come off sometime next year. She's studying music for her Higher School Certificate and sometimes hints at becoming a high school music teacher. I try to steer her away from that idea. We Australian teachers are constantly having to go on strike to improve our pay and conditions but we always seem to be going backwards. When I started teaching in 1977 our pay was equivalent to that of a politician on the back benches, who are now way ahead of teachers. Getting back to the songbuilder: Please don't take offence (We need them to keep in the kangaroos) but I'm not happy with the chords for I Will. I've played them and, to me, something sounds wrong. You can call me a pedant, I won't mind, but my preferred chord sequence for I Will is A, F#m, Bm, E, A, F#m, C#m (we differ here), A, D, E, F#m, A, D, E, A, A7, D, E, F#m, D, E, A, D, E, F#m, B, E. I'm just using my ear here, I haven't bothered to listen to the track or look up the music and there are, from memory, a couple of spots in the song where there are a some strong and fast chord changes that I have missed out. Try out my chords and let me know what you think. Do you sing when you play? When I was in the Bush/Rock band in Finley I sang a few songs to give our singer the odd break, and the only thing I had thrown at me was a pair of panties (obviously done as a joke by a friend in the audience). Bye for now, I've got some marking I must get done these holidays and time is slipping away. Ken Johnson |
#28
|
|||
|
|||
Ross,
68 William Street, Roseville 2069. Maybe the postcode will make a difference. Thanks for the hyperlink tips. I noticed on yours that when the cursor changes to the pointing finger the hyperlink address that appears included C drive and I thought this could be a problem if the file is being used on another machine at a different address. However, the hyperlink that I inserted, following your instructions, used an address that did not include the file's location, so I guess I needn't worry. Ken Johnson |
#29
|
|||
|
|||
Hi Ken,
I seem to have encountered a bug. Added another song and I think I followed the rules, but everything but the G transposes. Check it out at http://ssor.net/Sheet/MySongbuilder1.xls The song is have a cup of tea by the Kinks. Ross "Ken Johnson" wrote in message oups.com... Ross, 68 William Street, Roseville 2069. Maybe the postcode will make a difference. Thanks for the hyperlink tips. I noticed on yours that when the cursor changes to the pointing finger the hyperlink address that appears included C drive and I thought this could be a problem if the file is being used on another machine at a different address. However, the hyperlink that I inserted, following your instructions, used an address that did not include the file's location, so I guess I needn't worry. Ken Johnson |
#30
|
|||
|
|||
Ross,
I noticed that the problem chords were not Bold, and it seemed to be all the chords in column A. How were they put in place? Did you paste them in from a Word Doc? What I think I should do is add a few more lines of code to the transpose macro that will make all of the even rows Bold and the odd ones Regular. That should solve it. I'll have a go later on tonight. I've got to feed the hungry hordes soon. The wife's at work. By the way, I was looking at the rest of your website earlier today. I love the horoscope! It's so spot on. I'll check it again tomorrow to see if it's predictive powers are consistent ;-) I thought I knew most of the Kink's songs but I don't remember this one. I'll see if Eric can download a copy for me. While you wait for me to change the code you can just reset those chords back to bold. Ken Johnson |
Thread Tools | |
Display Modes | |
|
|