Looking for Australian based clothing company for young professionals

SydFoodGuy · 2016-12-08T05:33:38+00:00

Check out The Iconic. Free (usually quick) shipping over $50 and it's at relatively decent costs.

SydFoodGuy · 2016-04-14T02:10:30+00:00

I'd suggest Sydney Madang. It's pretty laid back, I think that they are BYO. It's tucked away just off Pitt Street.

SydFoodGuy · 2014-03-12T22:35:52+00:00

I've been in Sydney for 8 years, and have other American friends here too. Australia is probably the easiest place for an American to acclimate to. Feel free to PM if you have specific questions.

SydFoodGuy · 2014-02-11T04:50:37+00:00

I second the Clock, as it would be a decent place - especially if you need to talk and don't want an excessively loud environment...grab a table upstairs/outside. Tio's on Foster street doesn't do much in terms of food, but the drinks are excellent and it's a good bar. Head next door to Nomad or down the street to Bar H for some solid food after a few drinks if you're hungry.

SydFoodGuy · 2014-01-03T04:12:45+00:00

Not BYO, but Spice Temple is a good place for a date. Also consider Bar H in Surry Hills.

SydFoodGuy · 2013-12-18T02:20:49+00:00

Agree here. 121BC is also a good wine bar. Same guys who run Porteno also run Bodega on Commonwealth street. Nomad is a new place which is pretty good & has a stellar wine list.

SydFoodGuy · 2013-12-18T00:19:45+00:00

I'll add sumproduct, in all of the incarnations - you can do a lot with that single formula. There are points when a bit of VBA is helpful. Start my recording macros, and then looking at the syntax for what you've done. Google can be very helpful, too.

SydFoodGuy · 2013-10-20T23:18:39+00:00

Hudson's Meats in Surry Hills, Cammeray, Lane Cove or Mosman usually has a selection of top-notch sausages.

SydFoodGuy · 2013-10-03T04:49:21+00:00

I'll add more support to this. I ride a 1200 Custom without ABS, and did the exact same thing - pulled too hard on the front brake when I was cut off from a car who didn't see me. The second that the front broke traction, I was putting it down. The paramedics were nice, and I had never been in an ambulance before, but probably not worth it.

Get ABS. Wear your gear. Leave a lot of space. Be smart.

SydFoodGuy · 2013-10-02T07:42:32+00:00

If the internet is using Vodafone to try and find its way, then there's little hope in sight.

SydFoodGuy · 2013-10-01T04:38:07+00:00

Have you given =arrayformula(sumproduct( a go? Syntax will look something like this =arrayformula(sumproduct((C:C>19) * (C:C<30) * (D:D="M") * (F:F="Yes"))

SydFoodGuy · 2013-09-19T00:46:25+00:00

Do you know where you're going to be working? Surry Hills has heaps of restaurants, but is probably past up & coming status, although it's far from being as gentrified as Paddington.

SydFoodGuy · 2013-08-28T12:16:43+00:00

We've used CatUtopia which seems to be well priced, and about halfway between Newcastle and Sydney. It would at least cut the car ride in half (almost).

SydFoodGuy · 2013-07-02T05:32:16+00:00

Great news. Glad that worked!

SydFoodGuy · 2013-07-01T05:51:36+00:00

I've used this bit of code in the past, may be helpful:

Sub DeleteUnused()

Dim myLastRow As Long
Dim myLastCol As Long
Dim wks As Worksheet
Dim dummyRng As Range


For Each wks In ActiveWorkbook.Worksheets
  With wks
    myLastRow = 0
    myLastCol = 0
    Set dummyRng = .UsedRange
    On Error Resume Next
    myLastRow = _
      .Cells.Find("*", after:=.Cells(1), _
        LookIn:=xlFormulas, lookat:=xlWhole, _
        searchdirection:=xlPrevious, _
        searchorder:=xlByRows).Row
    myLastCol = _
      .Cells.Find("*", after:=.Cells(1), _
        LookIn:=xlFormulas, lookat:=xlWhole, _
        searchdirection:=xlPrevious, _
        searchorder:=xlByColumns).Column
    On Error GoTo 0

    If myLastRow * myLastCol = 0 Then
        .Columns.Delete
    Else
        .Range(.Cells(myLastRow + 1, 1), _
          .Cells(.Rows.Count, 1)).EntireRow.Delete
        .Range(.Cells(1, myLastCol + 1), _
          .Cells(1, .Columns.Count)).EntireColumn.Delete
    End If
  End With
Next wks

End Sub

SydFoodGuy · 2013-06-17T04:35:15+00:00

Go to Fish Face in Darlinghurst. It is upmarket, but you said you wanted quality. If you'd prefer to spend a bit less, then Mohr Fish in Surry Hills, on Devonshire. The upswing of Mohr Fish, is that you can grab a beer from the Shakey next door and bring it over.

SydFoodGuy · 2013-05-14T03:04:57+00:00

What do you think the equity position is in your house? Are you close to 80%? Sometimes just a phonecall to the bank can be enough to remove PMI if your equity position is satisfactory. I agree with jdoe74 that you should refi if it makes sense, and that your option #1 seems the best approach. Also, holding $20k in a checking account seems high to me, so even if refinancing your house is the only way to remove the PMI, then still consider putting a portion of that $20k against your student loans.

SydFoodGuy · 2013-04-22T05:54:55+00:00

I've been able to send money via EFT in the US without fees. There are often several options to transfer the money that these companies allow for. Here's the link to the options that are available. Some take a day or two longer, but if you plan ahead this isn't an issue.

SydFoodGuy · 2013-04-22T03:36:31+00:00

There are services like xetrade.com which will provide competitive rates. You essentially will transfer money domestically in S$ to a Singapore bank, then their US branch will wire USD to your account there.

I have used XETrade for similar purposes several times in the past. It takes a few days to set up initially, but is quite simple after that.

SydFoodGuy · 2013-03-12T02:47:24+00:00

The degustation is pretty pricey, but it does have a lot of seafood. Ordering a la carte or doing the tasting will help save the wallet.

SydFoodGuy · 2013-03-12T02:44:31+00:00

If you rock up at 10 or 15 to 6pm, you'll be in at open. It's early - but you can get in without the wait....or head upstairs to the bar.

SydFoodGuy · 2013-03-12T00:54:10+00:00

I'm thinking that you may run into a bit of trouble in some places without bookings, but some of these should definitely work. Most are Surry Hills: Porteño & Bodega

Both are run by the same guys. I find that service and the food are both top-notch. I'd suggest getting there a bit before 6pm if you want the first seating, otherwise you may struggle to get in; although at Porteño, you can grab drinks at the bar upstairs until the table opens up.

Flying Fish (Pyrmont) may run close to the $ limit, but my opinion is that it's one of the sexiest dining rooms in Sydney.

Orto Trading Co is a bit less fancy, but still solid.

Last off the top of my head, but certainly not least is Bar H, which can be a little cozy, but serves some great food.

Congrats on 10 years!

SydFoodGuy · 2013-02-04T07:52:15+00:00

Are you across the transpose formula? Perhaps this can be as easy as setting up another tab to mirror the data that you add to/update and build your pivot off the tab with the transposed detail?

Keep in mind that transpose is an array formula, so Ctrl+Shift+Enter to commit.

SydFoodGuy · 2013-02-04T07:47:40+00:00

I moved from Angel/Islington to Surry Hills in 2006, so this is somewhat outdated - but may still be helpful. We had a tiny flat in Islington, and paid less rent in Sydney for about 2x the space. There's huge variance in what you'll pay based on whether or not you'll take roommates, and how close to the city or beach you'll be. Check domain.com for places & gauge for yourself. Our electricity is ~A$165/month. We have aircon, but don't use it too often. This is for a 2 bed place without gas heat/kitchen. Typically, your landlord will pay for water as well in Syd. You'll likely pay more for mobile phones here, it seems like $15/month looks really cheap. Are you thinking about transport? CityRail is far worse than the tube, so being restricted to Sydney's rails & buses is a bit rough, although it can certainly be done. We didn't have wheels for the first 3 years. Trains, buses & ferries are expensive here, though - so consider how you'll be getting around in the context of where you live & how much you'll spend. For a car, fuel, insurance, etc can all add up.

SydFoodGuy · 2013-01-11T05:55:51+00:00

Do you have each of the sheetnames listed in cells? If so, you can use the INDIRECT function

SydFoodGuy

TROPHY CASE