tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 701052d1603482835-using-powerquery-to-import-data-from-a-website-to-an-excel-spreadsheet-powerquery-finviz-example
Sheet: Sheet1

AAON | I f I type the stock ticker symbol, for any company, in cell [NAME], I want the information below to autopoulate below from the website finviz.com
 | For this example, the webpage is https://finviz.com/quote.ashx?t=AAON&ty=c&ta=0&p=m&b=1
Index | - | P/E | 46.61 | EPS (ttm) | 1.32 | Insider Own | 0.195 | Shs Outstand | 52.10M | Perf Week | -0.0418
Market [NAME] | 3.22B | Forward P/E | 50.32 | EPS next Y | 1.22 | Insider Trans | -0.019 | [NAME] | 40.85M | Perf Month | 0.0953
Income | 69.50M | PEG | 3.88 | EPS next Q | 0.34 | Inst Own | 0.723 | Short Float | 0.0971 | Perf Quarter | 0.0564
Sales | 499.20M | P/S | 6.45 | EPS this Y | 0.27 | Inst Trans | 0.0002 | Short Ratio | 20.97 | Perf Half Y | 0.3469
Book/sh | 6.19 | P/B | 9.92 | EPS next Y | -0.1166 | ROA | 0.179 | Target Price | 35 | Perf Year | 0.279
Cash/sh | - | P/C | - | EPS next 5Y | 0.12 | ROE | 0.232 | 52W Range | 40.48 - 65.69 | Perf YTD | 0.2425
Dividend | 0.38 | P/FCF | 51.43 | EPS past 5Y | 0.051 | ROI | 0.181 | 52W High | -0.0655 | Beta | 0.64
Dividend % | 0.0062 | [NAME] | 1.8 | Sales past 5Y | 0.057 | Gross Margin | 0.29 | 52W Low | 0.5165 | ATR | 1.58
Employees | 2290 | Current Ratio | 2.9 | Sales Q/Q | 0.052 | Oper. Margin | 0.172 | RSI (14) | 51.57 | Volatility | 2.13% 2.60%
Optionable | Yes | Debt/Eq | 0.02 | EPS Q/Q | 0.329 | Profit Margin | 0.139 | Rel Volume | 0.47 | Prev Close | 61.34
Shortable | Yes | LT Debt/Eq | 0.02 | Earnings | Aug 06 AMC | Payout | 0.262 | [NAME] | 189.23K | Price | 61.39
Recom | 3.5 | SMA20 | 0.0038 | SMA50 | 0.0379 | SMA200 | 0.1355 | Volume | 89691 | Change | 0.0008
 | From the same page, in this and all intances, I would want to bring up the "MONTHLY" chart for company whose ticker symbol I type into cell A1
Spreadsheet: 230477d1366785155-drop-down-list-using-multiple-worksheets-0sor
Sheet: KPI's

Stats | Inbound Calls | Viewings Booked | Clearances Booked | Clearances Completed
Total | 48 | 48 | #N/A | 5
Year to Date | 48 | 48 | #N/A | 5
Breakdown | Calls to Viewings | Viewings to Booked Clearances | Booked to Completed Clearances | Call to Completed Clearance Percentage
Total | 1 | #N/A | #N/A | 0.1041666666666667
Year to Date | 1 | #N/A | #N/A | 0.1041666666666667
Spreadsheet: 714504d1611247663-help-computing-a-running-total-between-2-sheets-book6
Sheet: Sheet1

 |  | Date |  | Incoming Weight
PO | Line | Mon 01/25 | 10:00:00 | 45000 | Status
PO | Line | Mon 01/25 | 15:00:00 | 45000 | Status
PO | Line | Tue 01/26 | 10:00:00 | 45000 | Status
PO | Line | Tue 01/26 | 15:00:00 | 45000 | Status
PO | Line | Tue 01/26 | 15:00:00 | 0 | Status
PO | Line | Wed 01/27 | 10:00:00 | 45000 | Status
PO | Line | Wed 01/27 | 15:00:00 | 45000 | Status
PO | Line | Thu 01/28 | 10:00:00 | 45000 | Status
PO | Line | Thu 01/28 | 15:00:00 | 45000 | Status
PO | Line | Fri 01/29 | 10:00:00 | 45000 | Status
PO | Line | Fri 01/29 | 15:00:00 | 45000 | Status
PO | Line | Sat 01/30 | 10:00:00 | 45000 | Status
PO | Line | Sat 01/30 | 15:00:00 | 45000 | Status
PO | Line | Sun 01/31 | 10:00:00 | 45000 | Status
This is the schedule, I assume some sort of VLOOKUP formula needs to be done utilizing Columns C and E
I want to take the incoming weight, and have it added to the running total on the previous sheet
Example: The previous sheet shows a starting of 200,000. Then on Monday we are using a total of 82,204 between both production lines; but on Monday we also have an incoming qty of 90,000
(See Rows 4 and 5)
How can I set up the VLOOKUP to add the weight on the 1st page based on the dates and qtys on the 2nd?
Spreadsheet: 778893d1651420324-filter-and-sum-from-right-cell-to-left-sumexample-aligw
Sheet: Sheet1

 |  |  |  |  |  |  | Total Sum Report District Wise
LeadTech | Service | PartsCost | Payment | District |  |  | District | Total PartsCost
[NAME] | Assess | 360 | Account | North |  |  | North
Lopez | Replace | 90.0416 | Account | South |  |  | Central
[NAME] | Deliver | 120 | P.O. | Central |  |  | Northwest
Lopez | Deliver | 16.25 | Account | South |  |  | South
[NAME] | Deliver | 45.2374 | Account | Northwest |  |  | Southeast
Lopez | Assess | 97.6263 | Account | South |  |  | Southwest
[NAME] | Assess | 29.13 | Account | Central |  |  | West
Lopez | Replace | 35.1 | Account | South
[NAME] | Deliver | 76.7 | C.O.D. | Northwest
[NAME] | Repair | 374.0794 | C.O.D. | Central
[NAME] | Replace | 832.1583 | Account | West
Lopez | Deliver | 70.213 | Account | South
[NAME] | Assess | 150 | P.O. | West
[NAME] | Assess | 275 | C.O.D. | Central
[NAME] | Replace | 938 | C.O.D. | Northwest
Lopez | Assess | 61.2497 | Account | South
[NAME] | Assess | 48 | C.O.D. | West
[NAME] | Assess | 204.284 | Account | Northwest
[NAME] | Replace | 240 | Account | Northwest
[NAME] | Replace | 120 | Account | Southeast
[NAME] | Repair | 475 | Account | Central
[NAME] | Replace | 341 | C.O.D. | Southeast
[NAME] | Assess | 61.1806 | C.O.D. | Northwest
Lopez | Replace | 155.3931 | Account | South
[NAME] | Replace | 204.284 | C.O.D. | Northwest
Lopez | Assess | 37.9174 | Account | South
[NAME] | Deliver | 88.4057 | Account | Northwest
Lopez | Deliver | 202.2864 | Account | South
[NAME] | Assess | 120 | P.O. | West
[NAME] | Deliver | 120 | Account | Northwest
[NAME] | Replace | 535.6248 | C.O.D. | Southwest
[NAME] | Assess | 24.63 | Account | Northwest
[NAME] | Replace | 43.26 | Account | Northwest
[NAME] | Assess | 21.33 | Account | West
[NAME] | Replace | 0.456 | C.O.D. | West
[NAME] | Assess | 126.6231 | C.O.D. | Northwest
[NAME] | Replace | 251.0033 | Account | West
[NAME] | Assess | 395.28 | P.O. | Southeast
[NAME] | Deliver | 36 | Account | Northwest
Spreadsheet: phillip_allen__28811__Westgate Proforma-Phillip Allen
Sheet: Assumptions

Adjustment of base Cost for CMF & Ovhd | AdjRate | 1.2
Construction Period | Construction_Period | 6 | Months
Scale from KF Preliminary Plans | KFScale |  | Ft. Per Inch
Total Living Units | TLU
Construction Loan
Origination Fees | CLPts | 0.01
Interest Rate | CLIntRt |  | Per Mo
Avg Loan Balance | AvgBal | 0.7
Avg Loan Balance Land | AvgLandBal
Loan To Value | LTV | 0.8
Loan to Value - Land | LandLTV | 0.7
Land Price | LandPrice
Total Square Feet
Heated | TACSF
Total Covered | TCSF
Average Unit [NAME] | AvgWidth | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4
Investor Share | InvShare | 0.5
Sales Commission | Slscomm | 0.05
Closing Costs | Ccost | 0.0125
Spreadsheet: 719044d1613483468-help-in-2019-ytd-and-qtd-help-in-calculation-2019-ytd-and-qtd-2020-
Sheet: Data

Site | Date | Month | Year | Totalbatches | TotalRejection | Rejection Rate
Texas | 2019-12-01 00:00:00 | 12 | 2019 | 4 | 0
Boston | 2019-12-01 00:00:00 | 12 | 2019 | 5 | 4
Chicago | 2019-12-01 00:00:00 | 12 | 2019 | 6 | 0
New Jersey | 2019-12-01 00:00:00 | 12 | 2019 | 1 | 4
Chicago | 2020-01-01 00:00:00 | 1 | 2020 | 90 | 7
New Jersey | 2020-01-01 00:00:00 | 1 | 2020 | 6 | 5
New York | 2020-01-01 00:00:00 | 1 | 2020 | 0 | 3
Philadelphia | 2020-02-01 00:00:00 | 2 | 2020 | 10 | 0
Maryland | 2020-02-01 00:00:00 | 2 | 2020 | 15 | 2
Delawar | 2020-03-01 00:00:00 | 3 | 2020 | 30 | 0
Texas | 2020-03-01 00:00:00 | 3 | 2020 | 4 | 0
Boston | 2020-04-01 00:00:00 | 4 | 2020 | 3 | 0
Chicago | 2020-04-01 00:00:00 | 4 | 2020 | 7 | 2
New Jersey | 2020-05-01 00:00:00 | 5 | 2020 | 8 | 3
New York | 2020-05-01 00:00:00 | 5 | 2020 | 30 | 1
Philadelphia | 2020-06-01 00:00:00 | 6 | 2020 | 15 | 5
Ohio | 2020-06-01 00:00:00 | 6 | 2020 | 2 | 0
Maryland | 2020-06-01 00:00:00 | 6 | 2020 | 7 | 2
Delawar | 2020-07-01 00:00:00 | 7 | 2020 | 5 | 0
Texas | 2020-07-01 00:00:00 | 7 | 2020 | 4 | 0
Boston | 2020-08-01 00:00:00 | 8 | 2020 | 3 | 0
Chicago | 2020-08-01 00:00:00 | 8 | 2020 | 7 | 2
New Jersey | 2020-09-01 00:00:00 | 9 | 2020 | 8 | 3
New York | 2020-09-01 00:00:00 | 9 | 2020 | 2 | 1
Philadelphia | 2020-09-01 00:00:00 | 9 | 2020 | 5 | 5
Ohio | 2020-10-01 00:00:00 | 10 | 2020 | 10 | 0
Maryland | 2020-10-01 00:00:00 | 10 | 2020 | 15 | 2
Delawar | 2020-11-01 00:00:00 | 11 | 2020 | 5 | 0
Texas | 2020-11-01 00:00:00 | 11 | 2020 | 4 | 0
Boston | 2020-12-01 00:00:00 | 12 | 2020 | 3 | 0
Chicago | 2020-12-01 00:00:00 | 12 | 2020 | 7 | 2
New Jersey | 2020-12-01 00:00:00 | 12 | 2020 | 8 | 3
New York | 2020-12-01 00:00:00 | 12 | 2020 | 3 | 1
Philadelphia | 2020-12-01 00:00:00 | 12 | 2020 | 1 | 5
Spreadsheet: 164520d1340803133-excel-2007-trying-to-build-a-time-sheet-work-book-and-am-stuck-on-seperating-the-day-and-night-shift-new-project-pay-roll-and-time-sheet-beta-day-night-test
Sheet: Thursday Night Timesheeet

 |  |  | TRI TOOL INC.
 | Customer: |  |  |  |  |  |  |  |  | CUSTOMER CONTACT: |  |  |  |  |  | JOB NO: |  |  |  |  |  | Home Page
 | Work Location: |  |  |  |  |  |  |  |  | CUST. P.O. NO. |  |  |  |  |  | DATE:
 | Employee: |  |  |  |  | TOTAL HRS: |  | WORK [NAME]/WORK ORDER NO. |  |  |  |  |  |  |  |  | CONSUMABLES: |  |  |  |  | Payroll
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUAN: | PART NO:
 |  |  |  |  | Verify the following SAFTY ITEM CHECKLIST as required on this site. |  |  |  |  |  |  |  |  | Equipment Usage: |  |  |  |  | Tech Initial
 |  | NO | YES
 |  |  |  | 1 | If required, has the site specific training been completed?
 |  |  |  | 2 | If permits are required, do you have the proper papers?
 |  |  |  | 3 | Is Scaffolding correct and safe?
 |  |  |  | 4 | If lockout is required, has the proper procedure been followed?
 |  |  |  | 5 | Do you know the emergency signals?
 |  |  |  | 6 | Do you know the escape routes and assembley points?
 |  |  |  | 7 | Are safety glasses required?
 |  |  |  | 8 | Is a face sheild required?
 |  |  |  | 9 | Is a hard hat required?
 |  |  |  | 10 | Are flame resistant clothes required?
 |  |  |  | 11 | Is hearing protection required?
 |  |  |  | 12 | Are safety toed shoes required?
 |  |  |  | 13 | Are respirators required? |  |  |  |  |  |  |  |  | SIGNATURES:
 |  |  |  | 14 | Is fall protection equipment required?
 |  |  |  | 15 | Other: |  |  |  |  |  |  |  | CUSTOMER:
 |  |  |  |  |  |  |  |  |  |  |  |  | TRI TOOL:
Spreadsheet: 164520d1340803133-excel-2007-trying-to-build-a-time-sheet-work-book-and-am-stuck-on-seperating-the-day-and-night-shift-new-project-pay-roll-and-time-sheet-beta-day-night-test
Sheet: Sunday Night Timesheeet

 |  |  | TRI TOOL INC.
 | Customer: |  |  |  |  |  |  |  |  | CUSTOMER CONTACT: |  |  |  |  |  | JOB NO: |  |  |  |  |  | Home Page
 | Work Location: |  |  |  |  |  |  |  |  | CUST. P.O. NO. |  |  |  |  |  | DATE:
 | Employee: |  |  |  |  | TOTAL HRS: |  | WORK [NAME]/WORK ORDER NO. |  |  |  |  |  |  |  |  | CONSUMABLES: |  |  |  |  | Payroll
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUAN: | PART NO:
 |  |  |  |  | Verify the following SAFTY ITEM CHECKLIST as required on this site. |  |  |  |  |  |  |  |  | Equipment Usage: |  |  |  |  | Tech Initial
 |  | NO | YES
 |  |  |  | 1 | If required, has the site specific training been completed?
 |  |  |  | 2 | If permits are required, do you have the proper papers?
 |  |  |  | 3 | Is Scaffolding correct and safe?
 |  |  |  | 4 | If lockout is required, has the proper procedure been followed?
 |  |  |  | 5 | Do you know the emergency signals?
 |  |  |  | 6 | Do you know the escape routes and assembley points?
 |  |  |  | 7 | Are safety glasses required?
 |  |  |  | 8 | Is a face sheild required?
 |  |  |  | 9 | Is a hard hat required?
 |  |  |  | 10 | Are flame resistant clothes required?
 |  |  |  | 11 | Is hearing protection required?
 |  |  |  | 12 | Are safety toed shoes required?
 |  |  |  | 13 | Are respirators required? |  |  |  |  |  |  |  |  | SIGNATURES:
 |  |  |  | 14 | Is fall protection equipment required?
 |  |  |  | 15 | Other: |  |  |  |  |  |  |  | CUSTOMER:
 |  |  |  |  |  |  |  |  |  |  |  |  | TRI TOOL:
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: SoCal

 | 10487 |  | 56697
Day | Scheduled | Measured | Scheduled | Measured
1 | 782950 | 779895 | 30000 | 29986
2 | 812800 | 819915 | 30000 | 30022
3 | 804876 | 803751 |  | 698
4 | 812800 | 808945
5 | 810400 | 807889
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  |  |  | -21565
2001-06-05 00:00:00
Spreadsheet: 00023b08-3cbb-4619-ae3a-e0e5cf10d577
Sheet: Top Items

Top 10 Vertices, Ranked by Betweenness Centrality | Betweenness Centrality
DavidShuster | 7853.083383
ZekeJMiller | 5144.460512
BillHemmer | 4882.793661
Norsu2 | 4613.394594
RomneyResponse | 2517.545528
JoshDorner | 2503.717416
RalstonFlash | 1805.045508
theonlyadult | 1787.412416
Time2Standup80 | 1219.955341
TIMENOUT | 1125.075228
Spreadsheet: afbac190-370e-437c-9068-139d9fe6084a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
GMILK | Test | GMILK | Goat's Milk, IgE | Goat's Milk, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT OR |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
GMILK | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
GMILK | Result | GMILK | Goat's Milk, IgE | Goat's Milk, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7340-3 | Goat milk Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 722077d1615029587-how-to-calculate-number-minus-zero-is-zero-sumif
Sheet: Sheet1

 |  |  |  |  |  |  | Balance |  |  |  |  |  |  |  | used out of 50 |  | Need
 |  |  |  |  |  | 83751 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 0 |  |  | 38
 |  |  |  |  |  | 83752 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 0 |  |  | 38
 |  |  |  |  |  | 83753 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 47
 |  |  |  |  |  | 83754 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 46
 |  |  |  |  |  | 83755 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 83756 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
Spreadsheet: 754753d1636482032-alternative-to-offset-for-finding-second-to-last-entry-test
Sheet: Sheet1

 |  |  |  |  | asas
 |  |  |  |  | one | Two
 |  |  |  |  | 1 | two | Three
 |  |  |  |  | 1 | 1 | Three | Four
 |  |  |  |  | 1 | 1 | 1 | Four | Five
 |  |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  |  | 1 | 1 | 1 | 1 | 1
Spreadsheet: 330103d1404538072-vlookup-if-formulas-and-linking-two-spreadsheets-together-long-term-absence-overview-ans
Sheet: Sheet1

If [NAME] is over 20 days full row from Absence raw data is transferred into the below rows automatically
Name | [NAME] | Absence End | BP | Absence Days | Reason
 | Column A ARRAY formula (to b confirmed with Ctrl+Shift+Enter [NAME]) is different.
 | Formula n B4 is dragged across
Spreadsheet: 216526d1361800842-multiple-logical-tests-required-sample
Sheet: D&T - Formula

Type of Conductor: |  | Copper
S = | is the conductor cross-sectional area, in mm² |  |  |  |  | 100
I = | is the average fault current, in A r.m.s.; |  |  |  |  | 25000
t = | is the fault current duration, in s. |  |  |  |  | 3
I₁ = | is the fault current for 1 s duration, in A r.m.s.
k = | is the r.m.s. current density, in A/mm² |  |  |  |  | 144.3375672974065
 | square root of t multiplied by S |  |  |  |  | 173.2050807568877
 | Average fault current, in A r.m.s. (for verification) |  |  |  |  | 25000
Type of JointA) |  |  |  | Maximum Temperature B)  (°Cs) | U | R.M.S. current density, k
Welded | Brazed | Bolted | Soft Soldered
Spreadsheet: 21177d1208361107-need-vlookup-to-miss-blanks-test2
Sheet: MASTER

G0 | 1 |  | Arsenal
[NAME] | 2 | 1 | G | [NAME]
G2 | 3 | 2 | G | Łukasz Fabiański
G3 | 4 | 3 | G | [NAME]
G4 | 5 | 4 | G | Vito Mannone
G5 | 6 | 5 | D | [NAME]
G6 | 7 | 6 | D | [NAME]
G7 | 8 | 7 | D | [NAME]
G8 | 9 | 8 | D | [NAME]
G9 | 10 | 9 | D | [NAME]
D0 | 11 | 10 | D | [NAME]
D1 | 12 | 11 | D | Emmanuel Eboué
D2 | 13 | 12 | D | [NAME]
D3 | 14 | 13 | D | [NAME]
D4 | 15 | 14 | D | [NAME]
D5 | 16 | 15 | D | [NAME]
D6 | 17 | 16 | D | [NAME]
D7 | 18 | 17 | D | Abu Ogogo
D8 | 19 | 18 | D | Kerrea Gilbert
D9 | 20 | 19 | D | [NAME]
D10 | 21 | 20 | M | [NAME]
D11 | 22 | 21 | M | Cesc Fábregas
D12 | 23 | 22 | M | Tomáš Rosický
D13 | 24 | 23 | M | [NAME]
D14 | 25 | 24 | M | Aliaksandr Hleb
D15 | 26 | 25 | M | [NAME]
D16 | 27 | 26 | M | Mathieu Flamini
D17 | 28 | 27 | M | [NAME]
D18 | 29 | 28 | M | [NAME]
[NAME] | 30 | 29 | M | [NAME]
M0 | 31 | 30 | M | [NAME]
M1 | 32 | 31 | M | [NAME]
M2 | 33 | 32 | M | [NAME]
M3 | 34 | 33 | M | [NAME]
M4 | 35 | 34 | F | Eduardo
M5 | 36 | 35 | F | [NAME]
M6 | 37 | 36 | F | [NAME]
M7 | 38 | 37 | F | [NAME]
M8 | 39 | 38
M9 | 40 | 39
M10 | 41 | 40
M11 | 42 | 41
M12 | 43 | 42
[NAME] | 44 | 43
M14 | 45 | 44
M15 | 46 | 45
M16 | 47 | 46
[NAME] | 48 | 47
M18 | 49 | 48
M19 | 50 | 49
F0 | 51 | 50
F1 | 52 | 51
F2 | 53 | 52
F3 | 54 | 53
F4 | 55 | 54
F5 | 56 | 55
F6 | 57 | 56
F7 | 58 | 57
F8 | 59 | 58
F9 | 60 | 59
[NAME] | 61 | 60
F11 | 62 | 61
F12 | 63 | 62
F13 | 64 | 63
F14 | 65 | 64
F15 | 66 | 65
F16 | 67 | 66
F17 | 68 | 67
F18 | 69 | 68
F19 | 70 | 69
 |  | 70
 |  | 71
 |  | 72
 |  | 73
 |  | 74
 |  | 75
 |  | 76
 |  | 77
 |  | 78
 |  | 79
 |  | 80
 |  | 81
 |  | 82
 |  | 83
 |  | 84
 |  | 85
 |  | 86
 |  | 87
 |  | 88
 |  | 89
 |  | 90
 |  | 91
 |  | 92
 |  | 93
 |  | 94
 |  | 95
 |  | 96
 |  | 97
 |  | 98
 |  | 99
Spreadsheet: 732527d1621005356-calculate-and-return-decimal-value-between-range-new-microsoft-excel-worksheet-2-ans
Sheet: Sheet1

 |  |  |  | Enter Load | 260
 |  |  |  | Hours [NAME]. |  |  |  | Hours | 1 | 2 | 3 | 4 | 6 | 8 | 10 | 15 | 30
 |  |  |  |  |  | [h]:mm |  | Mod calcs
 |  |  |  | Enter Total mods | 64
 |  |  |  |  | INDEX($J$7:$R$7, MATCH(F$6,$J$8:$R$8,-1)+1)-(($F$6-INDEX($J$8:$R$8, MATCH($F$6,$J$8:$R$8,-1)+1))* |  |  | VPC | 5.7 | 4 | 2.95 | 2.33 | 1.58 | 1.19 | 0.94 | 0.6 | 0.25
Spreadsheet: ac980459-accc-49ca-8c6c-81b287b12888
Sheet: Sheet1

Organization Name: |  | Nurse Leader Eligibility Table
Note:  Before beginning to enter data, create one line for each unit to be entered.  If additional lines are needed for a Unit Type, right click on a row number within that unit type and select "Insert".  Enter one unit per line.                                                       MPM-FRM-060
Dept./Service/Unit | Units | Name (Last, First) | Highest Nursing Degree | Job Title
Medical
Surgical
Med-Surg
Oncology
Step Down
Critical Care
Labor & Delivery
Ante/Post Partum
NICU
Pediatrics
PICU
Operating Room(s)
PACU
Amb. Procedure
Psych.
Rehab.
Ambulatory
Emergency Department
Specialty Practice
Acuity Adaptable
Pre-Operative
LDRP
Home Care
Hospice
Long Term Care
Centralized Function
All Others
© 2013 American Nurses Credentialing Center.
Spreadsheet: 675965d1588588877-counting-a-row-if-a-word-repeats-3-or-more-times-in-the-cells-of-that-row-asn-playabout-etaf
Sheet: Sheet2

School name | (All)
Row Labels
High
High
High
High
Medium
Low
Low
(blank)
High
Low
High
High
Low
Medium
Medium
Medium
(blank)
High
High
Medium
High
High
High
Medium
High
Low
High
Low
Low
High
Low
Low
(blank)
Low
Medium
Medium
Medium
Medium
Low
Medium
Medium
Low
Medium
Medium
High
High
(blank)
Medium
Medium
(blank)
Medium
(blank)
Medium
Medium
Grand Total
Spreadsheet: 90796d1290531457-excel-2007-rank-and-award-points-on-2-columns-one-ascending-and-one-descending-example
Sheet: Sheet1

Team | Cows | Time |  |  |  |  |  |  | Team | Cows | Time | Rank | Points |  |  |  | Place | Points |  | Points
1 | 8 | 00:01:30 | 5 | 16 |  |  |  |  | 19 | 11 | 02:00:00 |  |  |  |  |  | 1st | 20 |  | 20
2 | 8 | 00:01:24 | 3 | 17.5 |  |  |  |  | 18 | 9 | 01:50:00 |  |  |  |  |  | 2nd | 19 |  | 19
3 | 8 | 00:01:24 | 3 | 17.5 |  |  |  |  | 1 | 8 | 00:10:00 |  |  |  |  |  | 3rd | 18 |  | 18
4 | 6 | 00:02:00 | 9 | 11.5 |  |  |  |  | 8 | 8 | 01:24:00 |  |  |  |  |  | 4th | 17 |  | 17
5 | 3 | 00:00:20 | 14 | 7 |  |  |  |  | 9 | 8 | 02:00:00 |  |  |  |  |  | 5th | 16 |  | 16
6 | 4 | 00:00:38 | 11 | 10 |  |  |  |  | 7 | 7 | 00:50:00 |  |  |  |  |  | 6th | 15 |  | 15
7 | 7 | 00:01:50 | 7 | 14 |  |  |  |  | 4 | 6 | 00:20:00 |  |  |  |  |  | 7th | 14 |  | 14
8 | 2 | 00:00:24 | 16 | 5 |  |  |  |  | 17 | 6 | 01:50:00 |  |  |  |  |  | 8th | 13 |  | 13
9 | 8 | 00:02:00 | 6 | 15 |  |  |  |  | 12 | 6 | 02:00:00 |  |  |  |  |  | 9th | 12 |  | 12
10 | 2 | 00:01:00 | 17 | 4 |  |  |  |  | 3 | 5 | 01:00:00 |  |  |  |  |  | 10th | 11 |  | 11
11 | 4 | 00:01:34 | 12 | 9 |  |  |  |  | 6 | 4 | 01:38:00 |  |  |  |  |  | 11th | 10 |  | 10
12 | 6 | 00:02:00 | 9 | 11.5 |  |  |  |  | 11 | 4 | 02:00:00 |  |  |  |  |  | 12th | 9 |  | 9
13 | 3 | 00:00:10 | 13 | 8 |  |  |  |  | 13 | 3 | 00:10:00 |  |  |  |  |  | 13th | 8 |  | 8
14 | 2 | 00:01:23 | 18 | 3 |  |  |  |  | 5 | 3 | 00:20:00 |  |  |  |  |  | 14th | 7 |  | 7
15 | 1 | 00:00:30 | 20 | 1 |  |  |  |  | 20 | 2 | 00:10:00 |  |  |  |  |  | 15th | 6 |  | 6
16 | 1 | 00:00:10 | 19 | 2 |  |  |  |  | 2 | 2 | 00:45:00 |  |  |  |  |  | 16th | 5 |  | 5
17 | 6 | 00:00:55 | 8 | 13 |  |  |  |  | 14 | 2 | 01:23:00 |  |  |  |  |  | 17th | 4 |  | 4
18 | 9 | 00:02:00 | 2 | 19 |  |  |  |  | 10 | 2 | 02:00:00 |  |  |  |  |  | 18th | 3 |  | 3
19 | 11 | 00:02:00 | 1 | 20 |  |  |  |  | 15 | 1 | 01:30:00 |  |  |  |  |  | 19th | 2 |  | 2
20 | 2 | 00:00:10 | 15 | 6 |  |  |  |  | 16 | 1 | 02:00:00 |  |  |  |  |  | 20th | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 784771d1655951202-progress-of-task-in-day-by-day-with-2-people-if-task-finishes-earlier-than-expected-sample-day-by-day-with-2-people
Sheet: Sheet1

 |  |  |  |  |  |  |  | 2022-08-18 00:00:00 | 2022-08-19 00:00:00 | 2022-08-20 00:00:00 | 2022-08-21 00:00:00 | 2022-08-22 00:00:00 | 2022-08-23 00:00:00 | 2022-08-24 00:00:00
 |  | Planned | Days on Task/person | % Daily - Sub Task | % Total Complete | Plan | Person A | Task A | Task A | Task A | Task A | Task A | Task A | Task A
Task A | Day 1 |  | 1 |  |  |  | Person B | Task A | Task A | Task A | Task A | Task A
 | Day 2 |  | 1
 | Day 3 |  | 1
 | Day 4 |  | 1
 | Day 5 |  | 1 |  |  |  |  | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9
 | Day 6 |  |  |  |  | Task A | Plan %
 | Day 7 |  |  |  |  |  | Actual % |  |  |  |  | 1
 | Sub Total | 7
Task A | Day 1 |  | 1
 | Day 2 |  | 1
 | Day 3 |  | 1
 | Day 4 |  | 1
 | Day 5
 | Day 6
 | Day 7
 | Sub Total | 5
 | TOTAL
 |  |  | Task Completed | Yes
Spreadsheet: 882565d1730958904-help-with-switch-formula-switch-function
Sheet: Sheet1

DATABASE | CODE | STATUS
A | 1
B | 2 | NAINTENANCE
C | 1 | OPERATIONAL
D |  | #N/A
E | 4 | DOWN
F | 5 | UNKWONN
G | 2 | NAINTENANCE
Desired solution
DATABASE | CODE | STATUS
A | 1 | OPERATIONAL
B | 2 | NAINTENANCE
C | 1 | OPERATIONAL
D
E | 4 | DOWN
F | 5 | UNKWONN
G | 2 | NAINTENANCE