- Видео 10
- Просмотров 62 152
Productivity Hub
Добавлен 13 окт 2021
The basics of SOLIDWORKS Design Tables
In this video you are shown the very basics of SOLIDWORKS Design Tables, to get an idea of how powerful the Design Table Tool is. When knowing how to use the SOLIDWORKS Design Table Tool properly, you can save lots of time creating configurations, by using the Design Table Tool. With Design Tables you get the chance to combine the functionality of SOLIDWORKS and Microsoft Excel, to make quick and intelligent configuration generation.
Questions this video answers:
How do I change the name of different dimensions I SOLIDWORKS?
Why to changes names on dimensions in SOLIDWORKS?
How to Auto-Create SOLIDWORKS Design Tables?
How to create SOLIDWORKS Design Tables from blank?
How to make many configura...
Questions this video answers:
How do I change the name of different dimensions I SOLIDWORKS?
Why to changes names on dimensions in SOLIDWORKS?
How to Auto-Create SOLIDWORKS Design Tables?
How to create SOLIDWORKS Design Tables from blank?
How to make many configura...
Просмотров: 129
Видео
How to establish automatic data transfer from MS Forms to Excel (Using Power Automate)
Просмотров 37 тыс.2 года назад
In this video, I will show you how you can create an automatic connection from Microsoft Forms to Microsoft Excel. This automatic connection will automatically transfer the data entered into the Form, to an Excel table, so that the Excel Table automatically updates when a new Form is submitted. so before this video a Form and an Excel table have been prepared, so the focus of this video is to e...
SOLIDWORKS CSWA Practice Set 3: Drawing Views
Просмотров 4,1 тыс.2 года назад
In this video, I will go through my third CSWA Exam Practice Set, with a focus on basic drawing views, in which you certainly will be asked questions in the CSWA Exam. If you have done your preparations well, these questions should be easy to answer, so that you quickly get those points and save valuable time in the following assignments. This video is divided into two parts. In the first part ...
Passing the SOLIDWORKS CSWA Sample Exam (Free test exam)
Просмотров 7 тыс.2 года назад
In this video, I will go through the CSWA Sample Exam, using the Tangix Tester Pro software, which is used to take the real SOLIDWORKS CSWA Exam. Therefore, it is good practice for you to get some experience with the software, before taking the actual CSWA exam. The Tangix Tester Pro software can be downloaded from this link: www.virtualtester.com/web/downloads The video shows an example of how...
SOLIDWORKS CSWA Practice Set 2: Assembly Modeling
Просмотров 3,7 тыс.2 года назад
In this video, I will go through my second CSWA Exam Practice Set, with a focus on basic modeling and assembly modeling, which certainly will be a central part of the CSWA Exam. The practice set is divided into two parts, first all the parts for the assembly are built, while all these parts are assembled in the second part of the practice set. The CSWA Practice Set 2 can be downloaded from this...
SOLIDWORKS CSWA Practice set 1: Basic Modeling
Просмотров 3,2 тыс.2 года назад
In this video, I will go through my first CSWA Exam Practice Set, with a focus on basic modeling, which certainly will be a central part of the CSWA Exam. Two models will be created in the video. The CSWA Practice Set 1 can be downloaded from this Google Drive link: drive.google.com/file/d/1_U6PFtK_ZqoY9B8jGZvPwlrikJBYOBDJ/view?usp=sharing The video consists of examples of the use of 2D sketchi...
Introduction to the SOLIDWORKS CSWA Exam (Intro to CSWA Practice Series)
Просмотров 6202 года назад
You will be introduced to the Mechanical design path of the SOLIDWORKS certification program, and also be introduced to my little series of videos which will prepare you to take the CSWA Exam. SOLIDWORKS offers these different certifications to give you the opportunity to document your skill level. And these certifications are strong documentation for you when you apply for jobs where SOLIDWORK...
Basic Excel Pivot table tutorial (Game of Thrones example)
Просмотров 592 года назад
In this basic Excel Pivot Table tutorial, you will get to know the basics of Pivot Tables. The Excel Pivot Table tool can be extremely powerful for you who want an overview of your data by creating a visual analysis of it. The Pivot Table interface is explained and exemplified in the video, through an example with a Game of Thrones dataset. The video will further show some interesting facts abo...
Advantages with the excel table format
Просмотров 1022 года назад
In this video, it is presented why and how to convert your tabular formatted data, to an Excel table. The creation of Excel offers multiple additional opportunities. In this video, it is shown how easy to make your Excel table look pretty and easy to read. The creation of Excel tables also adds a filter function to each column in the table. Most importantly it is shown how the Excel table forma...
Convert CSV to Excel (2 simple methods)
Просмотров 6 тыс.2 года назад
In this video, it is presented how to convert a CSV file into Microsoft Excel, by showing examples with two different methods. The first method shows how it is possible to split delimited data in excel, by splitting by custom delimiter (In this case Comma). The second method shows how a CSV file can be split, by the use of Power Query and the creation of a connection between an Excel sheet and ...
what should be the solution if rebuilding is not done even after the changing of parameters
Hi! Is there a possibility to create an automation for a surveys I am not an owner of, but I do have an access to edit it as it was shared with me? I can see the surveys in my account (Forms app/ Shared with me)), but I can not chose any of them in the Power automate app while creating a flow (New Flow/ Automated cloud flow/ When a new response is submitted/ Pick a form/ xxx). How should I approach this issue? Thanks in advance and thanks for the video!
Hi there! Just wanted to check, are you already find the solution for this problem? Because I've been dealing with the same situation and haven't figure it out yet. Please let me know if you find the solution, thank you!
great video
Not to be a nag, but the aligned section view looks like a flat section view. If it was “aligned” wouldn’t the top portion of the section show the exterior face of the part?
Thanks for this!
This got me a full score on my cswa exam. Can you do one now for cswp?
thanks for the videos really helpful.That day you did that video was the hottest from the days of the other videos lol.
Wow thank you so much!!
Super I am looking for long time..
And i want to ask why my mass always missed. My design was fully defined, and material is exactly same
I want to get this certification exam. I wanna ask about a modify section if we put wrong value altough it has tolerance <1% of true answer it is ok or not?
How does one get that Voucher to take Exam? I am really interested in taking it.
I got mine for free through University.. If you are not connected to an institution that can provide you free vouchers, then you must buy It through SolidWorks' website..
Thank you
Hello. And what about when response is editted?
Thank you for your advice. I passed my exam because of you.
Thank you
what if i edit my previous respond? does excel save it too?
What do you mean when you say "edit my previous respond"? Editing something in Forms or Power Automate?
I have to edit a response form form
Imma kiss you
I've created a similar data base however I have a column in which the user has to enter the date that they have completed the said training which they are putting into the data base, however when its input into excel it also has a time alongside the date which has not been entered and i do not want there. how do i remove it?
Try formatting the cell to a specific date format
Hi, how do you fix duplicate entries?
One of my friend created flow where he download all the previous submitted responses as well and every time that flow download excel file and save
Thanks a lot. Really helpful. Kind regards.
Thank you so much- this was incredibly helpful, and saved me a lot of time and grief 🙂
Great videos. I have a theory question though - I find myself using different methods, for example for the shaft I did a revolve. Is there usually a 'best way' or is any series of steps acceptable if the outcome is correct?
Many of the different parts/bodies can be modelled with different features, with the exact same outcome. In the test scenario you should use the features/approaches that you are comfortable/experienced using, to save yourself time and avoid unexpected surprices 👍 I hope it answered your question.
Ur the best
Hi, I truly appreciate you fir making this video. I have a question though, when I am using the action "Get response details", I am only getting the "Response ID" in the dynamic content tab. I don't see the "List of response notification Response ID" option at all. If I use the "Response ID" option, I always get error. What should I do?
Wonderful! Thanks for the brilliant video, it was so helpful :)
Hi i really like your video but I encountered an issue. When it came to the part about document library, you selected OneDrive, but I was not able to select it at all, I couldn’t connect to it even if I typed it out manually. I tried searching online for help, but they couldn’t really help me. Please help me 😢
This is amazing!!
Is there a way to automate the data in separate tabs within the same excel workbook? For instance, I have 200 employees who have to submit daily stats, instead of making each of them their one form is there a way to automate the submissions based on each employees name into their own tab?
Yeah, it is possible. However, it is not very flexible to use Power Automate to separate the data into 200 different tables. I would recommend using Power Query for that 👍
@@productivityhub4597 Thank you! Although now I have to watch more videos on how to use that program lol
I can maybe make some Power Query videos 👍
worked! Thank you!!
Thank you for this video. It helped me to finish my work quickly and it was easy to follow.
If I have edited the spreadsheet that the form data goes to, is this a problem? e.g. it's not creating a new spreadsheet every time and it's only updating the new information and not syncing the old information (and deleting my edits)
Hi Cindy 👋 Editing the spreadsheet should be no problem. Power Automate is refering to at specific Table in you sheet. You can even add additional columns to your table, without affecting the flow.
Is there a way to clone the workflow and all associated forms and excel files in case you wish to have different porjects?
I don't know a way where you can do it all at once. But you can dublicate all of it separately, rename it, and change the flow in Power Automate.
Thank you so much! Your video helps me complete my project at work! 😊
Great Very useful
This is very helpful.
Very helpful, Brother. Thank You so much. I found it (or) it found me at the right time. Keep them coming
Great vid. Thanks. I need help though. My scenario: I have numerous forms. I would like to collect all the data into one excel file...use different worksheets (tabs) at bottom for each form. How would I direct the data to go to different worksheets inside the same file? Help is appreciated :)
In that scenario you have to create a Power Automate flow for each form, and define where you want your data places. In your Excel file you can insert data into different sheets, by creating different tables in the sheets and direct the data into those tables. Does that help you?`:)
@@productivityhub4597 Thanks. Yes that helps. I have another BURNING question. I will try and be clear. As this table grows with new data, I want to be able to take the last input from the form and display it as a graph on my share point. I understand pivot tables etc but again, I only want the last record that was inputted from my form into my table. I just want my sharepoint page to display the last. Example. I have people input inventory everyday. I only want to display the inventory they put in for that day. Does this make sense? lol Any help would be appreciated
Can I add additional columns that aren’t in the form and still have the excel sheet update?
Yeah, you can add additional columns to your excel sheet, that have no link to the form 😉
I liked your video very much, thank you. Only one thing I do not complete to understand. Why do you make another file/table to link and make a flow to power automate? The Form already has an Excel file/table for storage data. When I open Excel file is updated with the forms information received. The only benefit that I see is cutomizing headers in new table (no need to use headers from Form). Thanks for claryfing my inquiry.
Hi Moises 👋 For me, the primary benefit of creating a setup like this is, that the data runs directly into the output source. I do, as an example, work at a smaller manufacturing company, where i created this setup for several quality controls. On top of that I have build Power BI dashboards for visualisation, based on that data. Those dashboards are automatically updated when new forms are submitted. If I did not make that link, i should download a new Excel file everytime i wanted new data for my dashboard. I hope it makes sense 😉
@@productivityhub4597 thanks so much for the reply. It does make sense. Again, thank you for sharing your knowledge.
Thank you very much
NEVER MIND I GOT IT
SORRY BUT I DON'T SEE ANY DRIVE LINKS IN THE DESCRIPTION
No problem. I'll just copy/paste for you 😉 CSWA Drawing View Dictionary drive.google.com/file/d/1wdMs_OZspoXB1QeEdtRmJeYOLFzVAg6o/view?usp=sharing Practice Set 3 - Basic Drawing Views drive.google.com/file/d/1q3DXU2bmDLpPzzkGKi_ViR20Mksov_xW/view?usp=sharing
how do I download your 2 PDF files
Hi Rick 👋 You can download the files from the two Drive links in the description 👍😊
Hi! I ran into a problem signing up Power Automate with my Free personal MS Account! Here's what it's reading: "Selected user account does not exist in tenant 'Microsoft Services' and cannot access the application '7ab7862c-4c57-491e-8a45-d52a7e023983' in that tenant. The account needs to be added as an external user in the tenant first. Please use a different account." HELP!!!
it gives an error when changing 2.6 to 2.4 for upper base
Great video, clear, easy to understand and not beating around the bush. Im a subscriber now
Thank you! I'm happy it made sense to you 😉
I love that Darth Bader was an employee 😂❤
He needed a job, so I chose to hire him, despite his past 🤣
Thankyou so much, this was exactly what i was looking for. I use this to add expenses to a spreadsheet to track my personal finance.
Cool! Personally i use an Excel data extraction from my bank, adds it to an Excel table, puts label to each line, and visualize it in a pivot table 😉