Author |
Message |
Jimmer
Moderator
08-30-2000
| Thursday, December 10, 2009 - 11:55 am
My suggestion is that you tell her the material cost, the skill involved and the time it will take you to do it and ask her what she has in mind for compensation. See what she says.
|
Wargod
Moderator
07-16-2001
| Thursday, December 10, 2009 - 12:36 pm
When I sell beaded things, my typical pricing formula is to take the cost of the materials needed, double it and there's my price. So if it's going to cost $10 in beads, findings, and wire, I'll sell it for $20. It's simple for me, it covers the time involved, the skill/experience, etc. I've been told often I underprice everything, lol. There are some mighty complicated formulas for pricing jewelry and beaded stuff, where people add in their hourly rates, add in some for their years of experience, price it for resale and wholesale and taxes. I've seen people price stuff for 3 and 4 times what it cost to make the piece and that's accepted as pretty normal. But my take on it is that beading is my hobby and something I do for fun, not to make a living or having a business. Most of my items only take an hour or two of work and are fairly simple items to make and I don't really view it as any type of work. If I was planning to sell on a regular basis or starting a business though, I would have to switch to one of the more complicated formulas to price things, especially to take into account taxes and what not, but for right now since I sell on such a small scale I don't have to worry about that. Now I've never done crotcheing or knitting but I think it's quite a bit more complicated and time consuming than beading, and charging $150 for something that will take approximately $50 in material seems pretty reasonable to me. I'd let her know how much time it will take and the skill needed, tell her how much you'd charge and then see what she says. I do have one suggestion though, if she's going to buy her own yarn or whatever let her know what kind you need, like if there's specific yarns that would work better with the pattern/design you're doing so she doesn't come back with something that just won't work right for what you're going to be making.
|
Karen
Member
09-06-2004
| Thursday, December 10, 2009 - 4:58 pm
I am looking for some help with MS Excel. I'm usually pretty good with software and if I can't figure something out, Google always comes to my rescue. But this one has me stumped. I work in an office that uses both Mac and PC. I'm a PC running Vista, using Office 2007. A coworker sent me an .xlsb file that was created using a trial version of Excel 2008 for Mac. He's applied sort functionality to the column headers in his table. By "sort functionality", what I mean is that he can click on one of the column headers (resource, deliverable, due date, etc.) and it presents a drop down of sort options (A-Z, oldest to newest, etc.) on the fly, right there from the cell, and will sort the entire table accordingly. Looks awesome on his machine but the functionality doesn't transfer to my machine when I open the file. I just get normal, non-functioning headers. We did a compatibility check on his file and it says there are no known issues. Is anyone knowledgeable enough with Excel to know how to fix this? Any help would be greatly appreciated. I need this file to work this way or it's back to the drawing board--and another few months of disarray here. Thanks in advance! HUGE thanks.
|
Jimmer
Moderator
08-30-2000
| Thursday, December 10, 2009 - 7:55 pm
That is a sort but to get the drop downs you just have to click somewhere in the table and then go to Data and then click on Filter. You'll get all the little drop downs and then you can go from there.
|
Karen
Member
09-06-2004
| Friday, December 11, 2009 - 12:35 am
Thanks, Jimmer... not quite what I was looking for, though. I know how to sort a table through the Data ribbon. What I'm looking for is how to apply sort functionality to a table by way of individual drop downs on the column headers, as so (this is a screenshot of how it looks on my co-worker's Mac):
See how each of the columns (Project, Deliverable, etc.) all have drop downs attached to them? Those will do the same as the Data-->Sort functionality within the table. I realize now that it doesn't much change the functionality between this way or the manual way like you described, but when this thing takes me 45 mins to update, anything to save time helps. Thanks for the input! ...and yes, I know the logical solution to this is to switch to Mac. I'm getting there.
|
Hukdonreality
Member
09-29-2003
| Friday, December 11, 2009 - 4:28 am
Karen, I found this info here: http://tiny.cc/eV7CL AutoFilter is an easy way to turn the values in Excel column into specific filters based on the cell contents. As example, by adding AutoFilter to the list above, I could filter the "Winery" column to only display items from Beauregard. All the other wineries remain on the Excel list, but don’t display. To turn on autofilter, 1. Click any cell within your range. 2. From the Data menu, select Filter. 3. From the submenu, select AutoFilter. Once you’ve enabled this feature, your columns display with a drop-down arrow to the right. If you click the arrow control, you’ll see all the values for that particular column. To turn off the feature, you deselect Autofilter from the same submenu.
|
Jimmer
Moderator
08-30-2000
| Friday, December 11, 2009 - 6:36 am
That's what I was referring to Hukd. The filter. 
|
Karen
Member
09-06-2004
| Friday, December 11, 2009 - 9:04 am
Haha. I'm a bit slow sometimes. Thanks to both of you... that's exactly what I'm looking for. I still think switching to a Mac would be easier. ;-)
|
Juju2bigdog
Member
10-27-2000
| Friday, December 11, 2009 - 11:42 am
Taysmom, I like the idea of telling her how many hours it will take you and comparing it to minimum wage. On the other hand, if this is something you can do while watching television, and you prefer to have your hands busy, maybe you do want to go below minimum wage. I know I got onto a knitting jag there for a while, and I got sort of panicky if I didn't have something to knit while I was watching television. Luckily I slapped myself and came to my senses and can now watch television while posting at TVCH.
 
|
Cwcoop
Member
04-19-2008
| Friday, December 11, 2009 - 5:48 pm
New Question: Do you know anyone that has (or have you personally) gotten married at one of those Jamaican resorts? I think it is refered to as a destination wedding? My question is, are the marriages legal/recognized back in here in the states? Is it necessary to 'back it up' w/ a State license? I swear I feel like this is a no brainer, but would rather hear from someone with a definitive answer. TIA.
|
Kitt
Member
09-06-2000
| Friday, December 11, 2009 - 6:01 pm
http://www.tripadvisor.com/Travel-g147309-c22683/Jamaica:Caribbean:Getting.Married.In.Jamaica.html Marriages performed legally in other countries are legal when you return to the US. I have no personal experience of destination weddings, but I married before I came to the US, and on the few occasions where I've had to show a marriage certificate they just write down the details as they would any other form.
|
Cwcoop
Member
04-19-2008
| Friday, December 11, 2009 - 6:28 pm
Thanks Kitt. I am glad I asked because that is not the answer I thought. I now feel compelled to declare that I am not an idiot in most matters of life. LOL So now I have a different question that I will ask in the advice thread. Thanks again.
|
Kitt
Member
09-06-2000
| Friday, December 11, 2009 - 6:34 pm
no problem 
|
Taysmomcj
Member
03-24-2008
| Friday, December 11, 2009 - 8:05 pm
Thanks for your help everyone. I looked on several web sites specializing in handcrafted items for sale. And prices seem to be all over the place. I talked with her this morning about the price. I also asked her how much she was looking to spend. I made sure that she knew how much time it would take me to make it for her. She had not considered spending more than $75 including materials, so now she needs to decide if she really wants to have me make it. I told her that if she is going to buy the materials (she mentioned getting it a bit at a time from either Michaels or AC Moore using coupons to save money) that I would ask for $100 for my time. So we will see what happens.
|
Hukdonreality
Member
09-29-2003
| Friday, December 11, 2009 - 8:16 pm
Good for you for asking her Taysmom. Yikes on the $75.00 including materials! She must think it will make itself, or that you're her BFF.
|
Wargod
Moderator
07-16-2001
| Friday, December 11, 2009 - 11:20 pm
She wants to pay $25 for your time? On an afgan???? For $25 tell her you'll teach her how to do it herself. New Question: We want to buy Caleb some new jeans for Christmas. Not a fun gift, but he's grown again and all his pants are getting short again. He's now in a size 18 boys, because of the legnth of his freaky long legs (so says the mom who is now 2 inches shorter than her 13 year old) and they'll be pretty baggy in the waist and butt cuz he's so skinny. I'm considering buying him mens jeans, the ones that are sized by inseam and waist size (ex. 32x30) but short of ruining a Christmas present and taking him with to try them on or grabbing a pair of boys size 18 and holding them up to mens size pants and comparing, is there any way to convert the boys size into mens sizes? Maybe a chart or something? Or a way to find mens sizes based on height/weight (though tricky cuz I can't really measure his inseam without tipping him off to a gift.)
|
Wargod
Moderator
07-16-2001
| Friday, December 11, 2009 - 11:26 pm
Oh, and while I'm at it, when buying jeans like that, which number belongs to the legnth and which to the waist?
|
Merrysea
Moderator
08-13-2004
| Friday, December 11, 2009 - 11:33 pm
The first one's the waist, the second is the inseam. Does Caleb have a pair of pants that fits him, or comes close enough that you could measure it and then add an inch or two if necessary? Keep the receipt! 
|
Wargod
Moderator
07-16-2001
| Friday, December 11, 2009 - 11:59 pm
LOL, thanks Merry, I had a moment of panic when I realized I wasn't sure which was which, could just see him opening a pair of jeans that were huge in the waist and short in the legs, lol. No, right now everything he has is size 16's, they fit perfect in the waist, but not in the legs. And worse, because with Caleb I don't buy one specific brand, they're all just a bit different and some are shorter than others. I guess I can take a pair shopping with me and add a few inches, maybe being a bit generous on the legnth. I'd rather have jeans too long that he'll grow into!
|
Biscottiii
Member
05-29-2004
| Saturday, December 12, 2009 - 3:05 am
Yes! I would take a spare pair that fits and the salesperson will be DELIGHTED to help figure it all out. As hard pressed as the economy, the salespeople are eager to help make a good present!
|
Texannie
Member
07-16-2001
| Saturday, December 12, 2009 - 5:59 am
can't you measure him?
|
Juju2bigdog
Member
10-27-2000
| Saturday, December 12, 2009 - 6:19 am
Taysmomcj, if you have a Hobby Lobby where you are, have her watch the ads for there. They sometimes have some terrific sales on yarn, like putting one they regularly sell for $5.99 on sale at 99 cents with no limit on the number. We don't have one up where I live, thank goodness, or I'd be there all the time and trying to find things to knit.
|
Julieboo
Member
02-05-2002
| Saturday, December 12, 2009 - 6:22 am
War, I think Tays means that she'd charge $100, not $25. (as that would be the price if the lady bought her own materials.)
|
Taysmomcj
Member
03-24-2008
| Saturday, December 12, 2009 - 6:25 am
Juju...we are in NW PA...the closest Hobby Lobby is in eastern PA...
|
Julieboo
Member
02-05-2002
| Saturday, December 12, 2009 - 7:48 am
Looking for advice: we ordered my mom one of those personalized grandma sweatshirts. Ordered XL, and man is it ever big!! She is going to try to shrink it by washing it in warm and drying it, but still thinks it will be too big. We cannot exchange (obviously, as I bet she is the only gramma with 10 grandkids named Amber, Ashley, etc...) To reorder it is going to be expensive (it was expensive enough in the first place) and we cannot figure out if med or large would be better... So I was thinking we could cut out the personalized part (about a 6" x 6" area and have it sewn (like almost embroidered on--where the edged are completely sewn on--hope I am conveying what I mean). My question is, would that be done better on a regular sewing machine or an embroidery machine? Does anyone know? TIA!!
|
|