office 365 – How do I setup an online Office365 form to allow my staff to count tasks and input a number and have it report to a sharepoint spreadsheet?

I have a team of people that count and record tasks daily. They are counting things like mail received (in lbs.), number of client contacts, number of system errors corrected.

I’m trying to figure how how to make an online form, preferably something I can use in Office365 so that they can enter this data easily, by just typing in the number in the correct field and hitting “submit”

I would like this to all appear in a sharepoint spreadsheet in which the columns are the tasks handled, and the rows are the dates. Any help would be greatly appreciated.

Is there a way to get, programatically, the datetime of the last update to a google spreadsheet?

In our system we have google spreadsheets which content editors use. I have some processes which pull these down and save them as local csv files, so the data can be read in by the system.

It would be very useful to know, when the system comes to use that data, whether it needs to be re-downloaded, and I thought that if I could somehow retrieve the “updated_at” timestamp for the google spreadsheet I could use that as the basis of a decision on whether to re-download the data.

Is there a way to get this, does anyone know? I’m using Ubuntu.

Is there a way to get, programatically, the datetime of the last update to a google spreadsheet?

In our system we have google spreadsheets which content editors use. I have some processes which pull these down and save them as local csv files, so the data can be read in by the system.

It would be very useful to know, when the system comes to use that data, whether it needs to be re-downloaded, and I thought that if I could somehow retrieve the “updated_at” timestamp for the google spreadsheet I could use that as the basis of a decision on whether to re-download the data.

Is there a way to get this, does anyone know? I’m using Ubuntu.

microsoft excel – Spreadsheet (Specifically Google Sheets) to generate a line chart with each player’s running score (competition tracker)

I asked this question on https://www.reddit.com/r/excel/comments/mikwvz/competition_tracker_create_publicly_accessible/?utm_source=share&utm_medium=web2x&context=3, but didn’t get an actionable (at my level of expertise) answer.

I’m trying to create a competition score tracker/graph that displays this information:

Each time an answer is submitted, the response sheet will display the time of the submission, the player’s name, and 8 “flag” cells, one for each flag in the challenge. The only flags that will have data will be correct flag submissions (thanks to Google Form’s “response validation”), and my expectation is that each player will be submitting once for each flag, although players can and should be allowed to submit multiple flags at once. Once factor that I have to account for is that players might re-submit previously submitted flags, so I want to account for that before the score is tallied and displayed on the graph.

Along the X-axis, the graph would track the time that each answer is submitted.

Along the Y-axis, the graph will display the total score.

Each colored line in the line graph will be a different player (my expectation is approx. 5-10 players total). As I linked in the reddit post, my hope is to display a graph that functionally resembles this one, and I’ll use Google Sheets to “publish” the graph so that it can be viewed throughout the competition.

Thanks for any help you can provide. I’m really hoping to get this built by Tuesday, as my office is trying to run a mini-competition as a skills-refresher in cybersecurity principles based on a recent course a number of our new co-workers just completed.

Data entry typing work in excel spreadsheet non error for $5

Data entry typing work in excel spreadsheet non error

My services includes✔ Excel data entry✔ Typing work ✔ Copy typing✔ Excel Spreadsheet✔ Excel VBA✔ PowerPoint Presentation design✔ PowerPoint Templates✔ Office design✔ Microsoft Office✔ Ms Office✔ Pivot tables✔ Data Mining

EXPERTISE
✔ Data Entry✔ Document formatting✔ Microsoft office✔ Document editing✔ Typing✔ Microsoft excel✔ Data mining✔ Virtual assistant✔ Data collection✔ Word to pdf✔ Pdf Conversion✔ Adding product in eCommerce store✔ Image to word or excel✔ Data entry operator✔ Data Entry Typing Work✔ Data Mining ✔ Internet Research✔✔✔Available 24/7I can deliver your order within the deadline with 100% accuracy.I would love to hear about your project’s requirements.Just leave me a message.THANKS

.

How can I turn 1.2M into 1,200,000 in Google Spreadsheet?

I’ve been looking for a formatting solution to do the opposite of what most try to do.
Turning shortened numbers like 7.51M into 7510000 or 7,510,000.
Or in thousands: 135.6K into 135600.

Update:
Found this statement which basically works, but I’d rather do it with formatting if possible.

=if((right(H6,1))="K",(value(left(H6,(len(H6))-1)))*1000,if((right(H6,1))="M",(value(left(H6,(len(H6))-1)))*1000000,if((right(H6,1))="B",(value(left(H6,(len(H6))-1)))*1000000000,H6)))

microsoft excel – How to align data in a Google Sheets spreadsheet?

I have two tables.

Table:

ID            NAME
A01           John
A02           Peter
B01           Marta

Then I have a second table (note that this table purposely has more entries).

ID             SURNAME
A02            Smith
B01            Clevens
A03            Rogers
A01            Brown

Both tables represent the same people with Names and Surnames, identified by ID. How I can join the data into one table and align the people correctly?

Desired results

ID          NAME        SURNAME
A01         John        Brown
A02         Peter       Smith
A03                     Rogers
B01         Marta       Clevens