Worksheet On Puns

Hi everyone, I shared this with r/vindicta but I thought some here might also find it useful. I wanted to share a worksheet for glow up that I created last month in preparation for 2022.

I used u/funnygirl213’s beauty hierarchy of needs as a template and took some inspo from u/schmuckcess’s beauty workbook((edit: beauty workbook

Feel free to make a copy and use it for your own planning/ give any feedback on mine

Without further ado: https://docs.google.com/document/d/1QfD1VY52rdHeZq8qCbSNW5FnfRR2WuwthSD-9TVqYxc/edit

I am not the best artist so I do apologize and I won’t do any nsfw.

Edit: a Snoo is your Reddit avatar that you can create.

Is it possible to replace data on worksheet while keeping other sheets.

pd.ExcelWriter mode='a'

does not work for me as i get io.unsupportedoperation:truncate error

fnamebegin_array = ['PB orders Jan','PB orders Feb','PB orders Mar','PB orders Apr','PB orders May',
'PB orders Jun','PB orders Jul','PB orders Aug','PB orders Sep','PB orders Oct',
'PB orders Nov','PB orders Dec']
sheetname_array = ['JanData','FebData','MarData','AprData','MayData','JunData','JulData',
'AugData','SepData','OctData','NovData','DecData']

for i in range(len(fnamebegin_array)): # would be 12, if there is data for each month in a year
    my_path = r'C://Users//greencolor//Autoreport//Load_attachments//'
    my_path1 =r'C://Users//greencolor//Desktop//Autoreport//'
    for filename in os.listdir(my_path):
        if filename.startswith(fnamebegin_array[i]):
            month = pd.read_excel(os.path.join(my_path, filename), 
                                         sheet_name='Raw data ', 
                                         engine='pyxlsb')
            with pd.ExcelWriter(my_path1 + '//Master.xlsx', mode='a', engine='openpyxl') as writer:
                month.to_excel(writer, sheet_name=sheetname_array[i], index=False)

So I have a worksheet that has a month over month line graph of sales. I have a separate data source that contains a static table for sales goals. Is it possible to layer the line graphs on each other so I can see the month over month sales goals in comparison with the actual sales using different data sources? I'm on Tableau Desktop if that helps. Thanks!

When I was in secondary school, I have this classmate who has birth mark on her face. Let's call her A. Many of my classmate did not like her due to that. I actually forgot most of the story, but somehow her paper was on the floor and she was not in the class. I kinda forgot but I am either the first or one of the first to step on the paper. After A came back, she was obviously upset and hurt from it. She report it to our teacher. My teacher demanded from the class who stepped on it. A few admitted and those who admitted also pointed out people who didn't admit. I was scared that people will point me out especially when I was first or one the first few who step on it first.

I never apologised to A till today because she didn't have a bad impression of me, and I step on the paper because I think I wanted to be the 'cool kid'. I didn't dislike her, but was immature as a teenager.

Hi,

I made a power query that reorganizes raw survey data into the desired format.

In brief, the query 1) reformates dates 2) replaces ID numbers to names and 3) adds additional columns where manual data would need to be entered

The problem arose for point 3) in which from my understanding the Power Query worksheet does not allow manual editing (all data must be first edited in the source data).

However, due to my task, I had to add columns using Power Query before manual data could be added. As expected, whenever, I refresh new data, the manually entered data reverted to the original source data format.

Is there any way to preserve manual data in the Power Query worksheet?

The alternative solution is to create a record macro of the "adding of columns" first, which allows me to manually add my desired data before importing them into PowerQuery. However, this requires an additional step.

I am trying to decrease the number of steps in this task because I need to pass on this task to co-workers who are less than thrilled to use Excel.

What's the most optimal way to perform this step without VBA knowledge?

Thanks

Hey,

So I have 2 workbooks, one with the dropdown (workbook X) and one with all the information (workbook Y).

So when, for example, the user clicks on "color" from the dropdown in workbook X. The macro should copy cells D3:D40 from worksheet called "color" in workbook Y and paste it back into workbook X.

Is this possible?

I would love all the help I can get!

Kind regards

Hey all,

I am stuck trying to accomplish some VBA. I am new to VBA, have learned solely from a Udemy course i just recently completed, most of this code below is taken from that course. Here's the process I am trying to accomplish explained

1. workbook open with sheet "CSF Template"

2. open file(s) using GetFileOpen

3. create chart for each data set imported by copying data set into "CSF template"

4. copy/paste "CSF Template" with new dataset into "CSF Template (2)"

5. rename new "CSF Template (2)" to data set file name

6. Delete/close data set file

7. Repeat for all imported datasets (i)

I think I am stuck somewhere around step 5. Is there no place to upload excel files on reddit?

VBA:

Public Sub ImportTextFile()
    Dim TextFile As Workbook
    Dim OpenFiles() As Variant
    Dim i As Integer
    
    OpenFiles = GetFiles()
    
    Application.ScreenUpdating = False
    
    For i = 1 To Application.CountA(OpenFiles)
    
        Set TextFile = Workbooks.Open(OpenFiles(i))
    
        TextFile.Sheets(1).Range("A1").CurrentRegion.Copy
        Workbooks(1).Activate
        Workbooks(1).Worksheets.Add
        ActiveSheet.Paste
        ActiveSheet.Name = TextFile.Name
        
        Application.CutCopyMode = False
        
        Call DataToTemplate
        TextFile.Close
    Next i
    
End Sub

Public Function GetFiles() As Variant
    GetFiles = Application.GetOpenFilename(Title:="Select File(s) to Import", MultiSelect:=True)
End Function

Sub DataToTemplate()
'
' DataToTemplate Macro
' Takes data from this worksheet, copies this data to the template, copies the template worksheet, renames worksheet
'

'
    Range("A1").Select
    Range(Selection, Selection.End(xlToRight)).Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
    Sheets("CSF Template").Select
    ActiveWindow.SmallScroll Down:=-62
    Range("A1").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Range("A1").Select
    ActiveSheet.Select
    Application.CutCopyMode = False
    Sheets("CSF Template").Select
    Sheets("CSF Template").Copy After:=Sheets(1)
    'Sheets("CSF Template").Select
    Range("A1").Select
End Sub

Hi, I’m looking for a function whereby I can paste a list of alphanumerical values into one sheet - when I do this, I need an associated value to be pulled over from my second worksheet. My second worksheet has a list of all possible alphanumerical values and their associated values. What would be the easiest way to do this?

Thanks in advance!

Hi everyone, I shared this with r/vindicta and thought some here might find it helpful. I wanted to share a worksheet for glow up that I created last month in preparation for 2022.

I used u/funnygirl213’s beauty hierarchy of needs as a template and took some inspo from u/schmuckcess’s beauty workbook.

Feel free to make a copy and use it for your own planning/ give any feedback on mine (and do let me know if somehow am accidentally revealing my identity— tried my best to delete any personal info but might have missed some)

Without further ado: https://docs.google.com/document/d/1QfD1VY52rdHeZq8qCbSNW5FnfRR2WuwthSD-9TVqYxc/edit feedback on mine)

Note: I am south Asian and have become very tan due to where I live. The skin brightening and lightening soap (kojisan) is to help even and get back to my natural body tone on my limbs as much as possible. If you’re uncomfortable with that, pls know I understand the context of the skin lightening/beaching world and the consequences that come with but my situation is exactly that.

I have POTS and possible EDS, and just got told that I need a walker. I let work know and they put me on a work hold. I have until December 31st to get it in and I can't work until I get this form in

Is this normal course of action for companies in this field? I'm a bit ticked off that I cannot work

I am working on getting disability pay anyways but I really need to work to pay bills. I love my job.

I do feel bad for not noticing in time but come on, in what universe was I supposed to assume he was dumb enough to steal rock candy from a chemistry teacher?

https://preview.redd.it/z4g24o9k0h881.png?width=1102&format=png&auto=webp&s=2ce85ea7777e57036c9f75bb351caca446ad88c5

https://preview.redd.it/vowo3ese0h881.png?width=1100&format=png&auto=webp&s=4c9e33c834af431a605cff6e6754d37eee0230e0

So I have 2 columns on 2 worksheets marked Companies. Each company is listed multiple times in each worksheet. What I am hoping to do is match company name in worksheet 1 with any instance in worksheet 2 and then return some info from different columns in worksheet 1 and 2. For example if MSFT matched then worksheet 1 may return the city and worksheet 2 may return the managers name.

As some may remember from last year, we started Inspirit hoping to help close the gap in science education. We built a product out of our research at Stanford University and Georgia Institute of Technology to provide students the tools they need to learn difficult concepts that simply couldn't be taught using existing tools. We had some shifts in our approach, but now plan on offering hundreds of high quality study guides, videos and simulations to learnings and educators across the globe!

Our mobile app now out on Android and iOS is where learners will be able to engage in social ways with their fellow learners/educators, and both will be able to create new rooms with our hundreds of 3D models and room types. Simulations and study guides will be added in the next month!

We saw a post by /u/teacherwenger earlier this year that mentioned the need for a free platform for labs, activities, simulations and more surrounded around learning standards - we hope to fill that gap and then some. Modernized, fun, 3D Phet style simulations/labs/games is our goal!

You can access our simulations below from our blog post (web-based, chrome browser preferred), sims will be added to the main site in the next month for easier access. Worksheets are available in printable and G-Classroom format for free on TPT: https://inspiritvr.com/blog/biology-and-physics-simulations-arrive-on-inspiritWe'd greatly appreciate any feedback! We are building this platform for teachers like yourselves. Mods, please let me know if this is out of scope for this subreddit, we just wanted to give these free resources out and see if the community would like them :)

https://preview.redd.it/m65qdiyjnb481.png?width=1434&format=png&auto=webp&s=d13c202e8f7defaa4e14996ef28f22ff94e93a21

So I am trying to fill out w4's for my two incomes and my wife's new job.

My income is $86k at job one

My secondary income is $12k

My wife will be making $30k at new job (her current job is approx $21k per year)

We have two dependents who will be under 17 at the end of 2022. When I do the worksheet it is saying that I need to take an additional $395 out of first jobs check per pay period. When I use the calculator and enter in income from all four jobs (include her current job) it is saying that I have a refund and need to make adjustments to add credits. If I remove her current job, and put the new one in as an all year job, I get the same thing. Can someone please help me out, this new process which is supposed to be "more streamlined" and easy is IMO more difficult and confusing. Thanks in advance!

Also would it be a bad idea to just submit a W4 for her new job (and my second) with no extra withhoding, while leaving my primary jobs (previous version, marked filing single, claiming 0) W2 in place?

Is it possible/advisable to claim "Single or Married filing separately" on the new W4 and file jointly at the end of the year to simplify things?

Course Pulse Spreadsheet

In my career, I have always been successful in what I was doing if I kept my finger on the pulse of my project or goals. I attached a link to a Course Pulse Spreadsheet for anyone of you that wants to use it. For me, it has been especially helpful when I take two or more courses at a time as it keeps me organized and helps me ensure that I never miss an assignment.

It is an Excel file and the Legend and instructions are displayed in the worksheet.

I hope this is a help to you. Enjoy!

Hey, at school we all got a microsoft surface go to use and I would love to use linux instead of windows so I was looking for an onenote replacement and found Obsidian. It's awesome, I really like it but I was wondering if there's some way to easily link and edit pdfs in obsidian. We always get workseets and I'm used to just drag and dropping them into one note and start writing with the pen. Is there some way to do something simular in obsidian?