2021.10.21 05:09 fishapplecat 10 real-world people' problems to solve from Reddit (digest #4)
Hi! Here's another digest of potential opportunities, mostly automation requests that people talk about on Reddit. Let me know if you want to see more specific problems(niches) in such digests.
Is there a way to automate pulling my Patreon supporter list and showing it on stream? I want to add a list of supporters from my Patreon to my "stream ending" screen in OBS, without having to manually update a txt file every time the list changes. Is there any easy way to pull that information automatically from my Patreon and integrate it into a scene? Link
--- How do you automatically update pivot tables and graphs when you change underlying data?
I used to do a lot of Excel reports and had to get new data and update reports manually.
By manually, it means inserting the data, changing formula references and graph references to get say the last 12 months of data, refreshing pivot tables etc.
Is there an easier way to automate all of this? Ideally, it would be nice to just insert the data you need, then the rest of the spreadsheet is updated. So it will pick the last 12 rows of data for the last 12 months and reflect that in the formula references and graphs.
I think the best way to achieve this is through VBA? Or can Power BI do something similar? Link
Need to automate a report which can pull data from multiple workbooks each month Hi everyone
I’m trying to create and automate a report that will show me projected number of employees that will work in a certain number of stores vs the actual number of employees that worked in those stores.
I have an excel spreadsheet for the month of September with 30 columns (one column for each day) and about 600 rows(number of stores). This spreadsheet tells me how many employees were expected to work in each store, each day. I then have 30 spreadsheets, one for each day of the month. These spreadsheets tell me how many employees actually worked in each store. I want a single excel workbook that shows me the projected vs actual amounts for each day of the month. So I need to show the projected amount next to the actual amount for each day of the month. I will then have 60 columns reflecting this.
What is the best way to go about doing this? I need to automate it so it can be repeated each month
Thank you Link
Automate Generating Reports and Excel Downloads from SAP Webi
Hello. I have to run A LOT of reports through our reporting front end - SAP Webi. This requires clicking on a report link, choosing the parameters from drop-downs, clicking on the GO button to generate the report, waiting a few minutes for the report to finish running, and then export the report as an Excel file. I would like to automate this process as it can take all day for the volume of reports I need to run.
I tried to Google a solution and the most helpful link I came across was to use the REST API. However, as a regular user.. I tried and don't think I have the permissions. Can someone point me in the right direction on how to approach this? I know I can skip a few steps because I have the document/report ID. Also, I'm open to trying a different script that doesn't involve VBA. Thanks. Link
Automating Copy/Pasting of Reports Emailed to Me Hi All,
This isn't really an API issue, but I figure folks here probably deal with this sort of thing regularly as well, so any help is much appreciated.
On a daily basis I get 20-25 separate .csv files emailed to me from various clients with their daily reports. I then have to download, open, copy, paste all of them so that I can put the data in the appropriate Google Sheet template to pull out the results.
Does anyone have thoughts on how to streamline this a bit?
For example, is there a tool where I could set up an autoforward to an email address from where Google Sheets could automatically pull the data?
Or is there function in Google Sheets that allows it to pull data directly from a path on my laptop (or even straight from GMail)? Then I could just save the new daily files in the same place and not even have to open them. Link
Looking to Sell Live Data Through Shopify With a Monthly Subscription and Daily Delivery
I am a data broker and have many digital products that I sell. Some products are daily data feeds. I have been trying to find a way to push a daily updated file into a digital download service using Shopify or a Shopify app and nothing has been found to automate the updating of the file that’s delivered every day. Does anyone have any experience with this? Link
Tableau Integration with Microsoft Teams
I work as a sales process manager and I was wondering if there is a known way to automate the distribution of Tableau reports via MS Teams. We already have automated email distribution but we use Teams a lot more than email to pass on quick information.
Does anyone know if this is possible? Link
GP and PowerBi
I am looking to connect my Dynamics GP data into MS-PowerBi in order to create a monthly report on transactions by vendor. Today we manually copy this data out of a smartlist and past it into excel for each business manager. Has anyone had success in user PowerBI for this use case? or is there a better way to automate this reporting? Link
How do you handle Search ad swaps for ecomm with lots of promos? I have a new ecomm client that does tons of promotions -- usually at least 3 unique promotions (/promo codes) a month.
We've been launching new ad copy for every single one -- all using basically the same template, just changing out the code in the headline & the % off when it changes.
Doing this across hundreds of ad groups, it's monotonous, and even with rules to automate the swaps, can get annoying and raises the risk of mistakes happening.
For those with similar high-promo clients, do you swap copy like this? If so, do you have a way to automate (or semi-automate) it? Or do you just rely on the promo extensions and call it a day? Link
Need help with development for time tracking template of work and study?
Hey, new to this subreddit and not sure if it is right place, but iI will give it a go anyways.
So, for the last semester I started to track time time spent for studies and my part time job. I created a spreadsheet in excel where I time my time in and out for study sessions, and time spent at work each week of semester and track overall hours spent, average time each week, if im over or below expected hours spent, effective days and days off etc... I did really enjoyed doing it, but I would love to take it up a notch.
There are couple of things I would like to improve on, but my lack of excel knowledge hinders it. So I was hoping for someone experienced with excel to help me out and give me some advice on how I should do it. By the way, if anyone has any suggestions for what I could add into the spreadsheet I would love to hear it as well!
First thing I would like to add into the spreadsheet is hours spent for each class rather than just total hours spent for study. I struggle to make it user-friendly since it gets quite messy when I add four to five classes each semester. Since it would be quite interesting from an analytical perspective to track how many hours I spent each class relatively to which grade i got.
Second thing I would like to improve on is in overall setup of the spreadsheet usability, since currently it gets bit messy when I have 20+ weeks in one spreadsheet. Since I track everyday of semester including weekends and separate them by week number by just copying the template I have for every week. I would preferred to have some kind of interface where I could just ad a new week when needed, and it adds on to the next period automatically(if it makes any since haha)
Anyways, if there are any excel enthusiast who would be willing to help me out, obviously I do not expect anyone spending their time on it for free. Give me a PM or just comment below! Link
submitted by fishapplecat to Entrepreneurs [link] [comments]
2021.10.21 05:09 11ghost_raven11 "The old crow is calling, but the landscape's at peace / Down the trail through this forest' through thicket we ride / The unseen is watching from behind each stone and pine" (lyrics from "Foreverdark Woods" by Bathory).
|submitted by 11ghost_raven11 to nightcafe [link] [comments]|
2021.10.21 05:09 IncenseTalk [SELL] Tarot Cards | Vienna Imports
I have a bunch of tarot card decks available for sale.
You can check them out at the link below:
I have some other decks that aren't listed as well.
Feel free to inquire.
Thanks for checking them out!
submitted by IncenseTalk to occulttrade [link] [comments]
2021.10.21 05:09 thebelsnickle1991 Egyptian authorities 'detain' robotic artist for 10 days over espionage fears
2021.10.21 05:09 Darren-B80 Red Bull "unique" and "totally different to what I was used to" - Perez
|submitted by Darren-B80 to formula1 [link] [comments]|
2021.10.21 05:09 DrakenCrypto Verify Token Launch Today Dont miss
💥🔥 Verify Token 🔥💥
🎉 LIVE ON PANCAKE SWAP 🚀
Low market cap 🚀
Bringing Transparency And Accountability To The Crypto Space. Website: ⭐️ www.verifytoken.net ⭐️
💎Unique use case💎
🥇Verify Lens will be the Google of Blockchain Security🥇
❇️Doxxed & Experienced team ❇️5% buy tax, 5% sell tax ❇️50T Total Supply
5% Tax on sell ONLY
2% to Research and Development 1% to Liquidity 1% to Charity 1% auto-burn
🔷Socials : Telegram, Instagram, Twitter, Reddit, Facebook, Tik-tok.
▶️PinkSale : https://www.pinksale.finance/#/launchpad/0x99ee3550453394e6745B6426785ecA6bFbcBab36?chain=BSC
▶️TG : https://t.me/VerifyOfficial
▶️FB : https://www.facebook.com/VerifyToken
▶️Twitter : https://twitter.com/Ver1fyToken
submitted by DrakenCrypto to ShitCoinWow [link] [comments]
2021.10.21 05:09 el3rod عروض الكرامة هايبر روي عمان 21 حتى 23-10-2021 #عروض_الكرامة_هايبر_ماركت_عمان #العروض #el3rod #تخفيضات #خصومات #تسوق #عروض #تخفيض #خصم #عرض #اخر_عروض_عمان #عروض_عمان #عمان
|submitted by el3rod to el3rod_Oman [link] [comments]|
2021.10.21 05:09 Ball_life2144 My fear of death
Every single time something comes up about death, people getting older, afterlife, etc I panic on the inside. The thought of just being nothing or having no type or consciousness after death tears my stomach apart. I’ve grew up religious (christian) and still am but I 100% still fall into doubt that there is a heaven. The thought of losing family members and dying will most likely never stop haunting me.
submitted by Ball_life2144 to thanatophobia [link] [comments]
2021.10.21 05:09 joodatious Major bug: enemies AI completely turned off
2021.10.21 05:09 Ok_Oven_8127 PLEASE!!!!! HELP ME GET TO MY GOLD OF 1000 SUBSCRIBERS ( PLEASE IT'S FREE JUST 1 CLICK )
|submitted by Ok_Oven_8127 to SubscribeToMe [link] [comments]|
2021.10.21 05:09 JoyfulOrc First time gaming moniter purchase
So I've been looking into a dual monitor set up for my pc. This is only my second build so I'm not entierly sure on what options are available to me. I just wanted to check in with PCMR and see if any of you had any recommendations or buyer bewares for me, I don't know what the standard is in terms of quality and features, also I'm not sure what my system can and can't handle display wise
My specs are
Gigabyte Geforce rtx 3070 oc 8gb AMD ryzen 5 3600 2x8 gb ddr4 3600 mhz Thermal take litepower gen 2 550w Gigabyte b550m DS3H AM4
submitted by JoyfulOrc to pcmasterrace [link] [comments]
2021.10.21 05:09 Possible_Abrocoma_22 Strong winds cause damage, disruptions in western Europe
2021.10.21 05:09 Possible_Abrocoma_22 China boots Caixin financial news from approved media list
|submitted by Possible_Abrocoma_22 to rawuncutnewss [link] [comments]|
2021.10.21 05:09 Eastern-Beautiful-18 Half way into finishing my sleeve
|submitted by Eastern-Beautiful-18 to Animetattoos [link] [comments]|
2021.10.21 05:09 nsdapgaming didn’t they usually set these up inside a library?
2021.10.21 05:09 Jojohonk Hey Bros, I drew t h e image
|submitted by Jojohonk to PewdiepieSubmissions [link] [comments]|
2021.10.21 05:09 foamydotcool Need a website for your idea? I'll design and develop it for you for a ridiculously low price as I build my portfolio
Hello founders, entrepreneurs, investors, dreamers, doers
I am writing this post to offer my services to anyone who is ready to launch their product and needs a website to do so.
I am currently in the process of setting up my own website development service for startups ( foamy.cool ) and I need more projects that fall in the niche I have chosen to focus on (early-stage tech startups).
This is why I’m offering exceptionally low rates. I would do this for free but I need some sort of commitment from you to be sure that you will be involved in the process. A similar service would typically cost you $3000-$15,000 USD with an established professional. The packages available are:
2021.10.21 05:09 nixpix02 INFP and a Corporate job
Is it possible for an INFP to last and succeed in a demanding corporate job in the longer run? I'm talking about one that involves regular client calls and meetings and requires one to have long-term relationships and a 'network' that you have to maintain. I'm only 26 and at a junior level, so now it's okay if I don't speak up as much but there was today when someone has pointed it out in a group meeting ( you know the kind of very loud people who go 'I didn't know you had a voice hahaha') and it has only made me more concious of my entire existence. It has also made me wonder if I have what it takes to make it. And more often than not, I think I don't. How long can I fake it? And it seems like I will have to change my personality to get ahead. And I have become comfortable to a certain degree with calls and discussions that it doesn't seem exhausting anymore but such days with comments where someone points out your quietness just makes me wonder. It will only get more difficult as I get into more senior positions and will have to even lead people. Will I always feel like I'm struggling with my job? Is the current corporate structure just not made for us? Is it only possible for us to become artists or get into professions where you work alone? Or is that guy just an asshole who will be a rarity, instead of the norm?
submitted by nixpix02 to infp [link] [comments]
2021.10.21 05:09 PeinHozuki Does every invidious instance have different accounts?
2021.10.21 05:09 cxptxinhyde [LF] orange pumpkins [FT] Bells, NMT or anything you wish
2021.10.21 05:09 ciffers I transferred my tickets to the seller after stubhub’s due date but days before concert
I noticed an email from Stubhub stating that I sold my tickets but it went to my spam folder so I didn’t notice until until a day later. I see in the email that they gave me a deadline to transfer the tickets by midnight UST on 10/21. The concert isn’t until 10/23. I transferred them on 10/21 but this was at 2am UST. I have not gotten any confirmation from Stubhub stating that the transfer was complete even though it said it would tell me within 30 minutes of transferring. Will they cancel my sale if I initiated the transfer after their “deadline” but days before the concert?
submitted by ciffers to stubhub [link] [comments]
2021.10.21 05:09 crocsandwich where do they homeless usually hang?
2021.10.21 05:09 CarlosVegan Court decision on Conoco Phillips Willow project and implications for PANR and 88E
| Article on Anchorage Daily News|
"With the deadline to appeal an August court decision come and gone, it appears federal approval for ConocoPhillips’ massive Willow oil project on the North Slope will be subject to at least a partial do-over, all but ensuring the development will be delayed multiple years."So with the expectation that projects on federal land will be at least delayed by several years if not finally canceled what does that mean for PANR ?
Well it is great news ! PANR is 100% on state land and this only affects federal land.
Now that all projects on federal land may expect similar trouble all the projects on state land are much more attractive to interested parties. Therefore helping PANR with Farmout negotiations as there is much less competition for the near term production development.
We recall from the WHI analysis. Production on Alkaid could start in 2023:
And in 2024 for SMD-B:
So, thanks to this decision of the court PANR is now in a great position by having assets that could be developed within 2 years which no assets on federal lands can offer right now.
There are also some implications for our neighbours of 88E. I copied this from the ADVFN board. Original poster is Scot 126
"By any objective analysis, this is not good news for 88E.submitted by CarlosVegan to PantheonResourcesPANR [link] [comments]
2021.10.21 05:09 Skiddows Niko is the absolute cutest. Had to draw him
|submitted by Skiddows to ac_newhorizons [link] [comments]|
2021.10.21 05:09 TheXBoxer [PS4] H: AASSS Hatchet W: Classic Jack O'Lantern, Vault Boy Jack O'Lantern, Half Empty Pumpkin Rack (all 3)
|submitted by TheXBoxer to Market76 [link] [comments]|