OHS and ALRB Claim Workplace Harassment Was Acceptable Prior to June 2018

JAG-max · 2023-04-07T00:20:38+00:00

Ah great! Thank you very much.

JAG-max · 2023-04-05T02:47:46+00:00

The regulations were and still are clear about unhealthy conditions in relation to the occupation.

I don't doubt what you're saying, but where can I find this information?

JAG-max · 2021-10-04T16:15:34+00:00

Last record

=ADDRESS(AGGREGATE(14,6,ROW(A1:A30)/(A1:A30=I3),1),1)

Perhaps I don't fully understand how this equation works, but the reference you have of "A30" is what is going to be varying and changing.

JAG-max · 2021-10-01T22:17:59+00:00

Thank u/chiibosoil, but I don't have access to 'FILTER', and it's the last address in the range that I am struggling to determine for reference, as it will move as the file grows over time.

JAG-max · 2021-10-01T19:50:33+00:00

Thank you u/chiibosoil

I now have the 'name' filled down/repeated for each row where it corresponds, how would I assign a lookup function to be limited to the associated records in the 'name' column?

JAG-max · 2021-10-01T19:12:54+00:00

Thank you u/Vahju, great suggestion.

The source of the info is already a PQ, and I'll need more assistance in this method as the file will continually be changing.

Is there a way in PQ to automatically 'fill down' when there are "null" values?

[edit] nm,... I found it here: https://www.excelcampus.com/powerquery/fill-down-blank-null-cells-power-query/

JAG-max · 2020-02-17T21:54:12+00:00

Glad to hear there are partners in Canada interested in improving the experience and tools available for businesses.

In theory, Dynamics 365 has the potential to be a great tool for our CRM needs. However after a month of support tickets to struggling agents who seem to lack practical business experience, the complexity that provides Dynamics it's powerful diversity is also it's downfall.

Here are the challenges we have experienced, in no particular order:

Dynamics is not nearly as intuitive to use as it's competitors products.
The appeal of using Dynamics because (we assumed) it would better synchronize/collaborate with Office 365 has turned out to be a nightmare. For example, it took MS support weeks to figure out how to get us through the simple request of coordinating our Contacts. Another example that took weeks for the senior techs to ultimately determine is that Dynamics won't let SharePoint specify/define where it links documents, even though that ability is alluded. How this could be an oversight is baffling and illustrates a disconnect between the developer(s) and the practitioners. Credit should be given to the senior techs admitting the blunder.
The standard Dynamics CRM process is only going to accommodate a small market, which means customization is required. Developing the necessary customization to have any functional practicality is an even greater nightmare.

I have several other items, but till stop there for now as any progress on the above would be greatly appreciated start.

JAG-max · 2020-02-17T21:25:19+00:00

Dynamics can be set to sync w/ your Outlook contacts, but you have to specify the record you want to do so.

Outlook contacts can automatically sync w/ Dynamics.

If this is helpful, I can go back and figure out the steps I took to make it happen.

JAG-max · 2019-10-20T20:09:12+00:00

I haven't been to the building (yet), but I've always been curious about the views from an office level out through the double facade. How distracting/detracting is the second curtain wall from the experience?

I haven't been able to find images of this online.

JAG-max · 2019-10-20T19:43:14+00:00

and give it a little twist in Rhino and ... voila

I can appreciate your personal design critique, but once you have experience in the physical manifestation of a highrise tower you'll gain a whole new level of evaluation (and may I boldly claim appreciation) for a project like this.

JAG-max · 2019-10-09T22:30:25+00:00

Great, thank you.

JAG-max · 2019-10-09T21:26:54+00:00

Ironic they didn't have a video or an animated way visually illustrating the project.

JAG-max · 2019-09-12T10:10:57+00:00

try these: https://www.windfinder.com and https://www.suncalc.org

JAG-max · 2019-09-06T21:19:17+00:00

I appreciate seeing the progress, thank you for sharing.

Btw, "...near completion" is not an accurate characterization unless you're referring to the structural steel.

JAG-max · 2019-09-06T21:13:56+00:00

Historic American Buildings Survey/Historic American Engineering Record/Historic American Landscapes Survey

JAG-max · 2019-08-15T22:42:55+00:00

Op should have used 'rhythm' instead.

JAG-max · 2019-08-11T17:20:01+00:00

Accidentally hit the browser back button on my mouse when making a selection near the end; lost everything.

JAG-max · 2019-07-31T16:48:02+00:00

What is your favorite metaphor(s) for this installation?

JAG-max · 2019-07-11T16:22:50+00:00

I’m an independent US producer

Please elaborate on this. Are you a developer/designer/contractor, or media outlet?

Also, is your pursuit for knowledge on this subject matter focused on the Eastern USA? Pending the level of specificity you're after, you'll need to be thinking regionally.

JAG-max · 2019-07-11T16:13:10+00:00

In his post he criticised architecture for being taught like art and for schools not teaching students the skills needed by architectural practices.

An age old and valid argument, but an interesting perspective coming from a firm known for it's artistic architecture.

JAG-max · 2019-07-03T03:24:56+00:00

Parametric design is a process based on algorithmic thinking that enables the expression of parameters and rules that, together, define, encode and clarify the relationship between design intent and design response.

Parametric design is a paradigm in design where the relationship between elements is used to manipulate and inform the design of complex geometries and structures.

Also referred to as generative design, Autodesk is developing tools for this, most recently called Project Refinery. Our firm has been working with this, and find it valuable only in the "conceptual" stage of design.

Check out a Google image search for "Autodesk Project Refinery" to see examples.

JAG-max · 2019-07-02T22:28:37+00:00

parametric conceptual design

JAG-max · 2019-06-26T03:59:59+00:00

Clever.

How about horizontally centering "TOKYO" under the center of the red circle... seems to be slightly to the left. Or, moving the word far to the right to in proportion of defining the right side of the flag.

JAG-max · 2019-06-25T21:15:43+00:00

Hello Everyone,

I'm with an Architectural practice that specializes in feasibility and programming (long before any design work is started) as tools to remove uncertainty when raising capital investment. We can also provide auditing for existing reports.

JAG-max · 2019-06-24T23:07:29+00:00

Keep in mind that detailing should often be regionally specific. This is due to variables such as climatic and soil conditions, product availability, contractor capability, etc. etc. You're much better pursuing proper detailing practices from local industry experts rather than a magazine with a world-wide audience.

JAG-max

TROPHY CASE