Microvellum Knowledge Network

Using Chat GPT or BING to help with formulas

Started using the new Bing (Powered by ChatGPT) to help me write formulas lately. Found it works really great as a tool to write series of formulas. What I mean is I can write the first and last formula in a series and then ask it to give me all the formulas in between. It's super helpful for subassemblies where I might have like 10 shelves that I need to write formulas for. It's kinda like dragging your formulas down in excel

So for a simple example I'll ask:

=IF(AND(Bay_1_Component=Bay_2_Component,Bay_1_Shelf_Qty=Bay_2_Shelf_Qty),1,0)..........=IF(AND(Bay_10_Component=Bay_9_Component,Bay_10_Shelf_Qty=Bay_9_Shelf_Qty),1,0)  Can you give me the formulas in between?

And it will write out all the formulas for bays 1-10.


Works for completing formulas too in certain scenarios... For example

Can you complete this formula?  =IF(Bay_1_Shelf_Qty+.......+Bay_10_Shelf_Qty>30,True,False)

And It will respond with

=IF(Bay_1_Shelf_Qty+Bay_2_Shelf_Qty+Bay_3_Shelf_Qty+Bay_4_Shelf_Qty+Bay_5_Shelf_Qty+Bay_6_Shelf_Qty+Bay_7_Shelf_Qty+Bay_8_Shelf_Qty+Bay_9_Shelf_Qty+Bay_10_Shelf_Qty>30,True,False)


Thought I'd share this in hopes that somebody else may have ideas on how this tool could speed up or make our formula writing easier. I'm eager to here more cool things about what we could do with this.

    MVU eLearning



    Grow Your Knowledge
    Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


      Follow us on:

               

        Google Review