tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 114914d1310581995-calculating-maximum-monthly-pension-case-1
Sheet: Defined contribution

Your client has a total of |  |  |  |  | 1150 | per month
to contribute each month toward retirement.
Calculate the maximum monthly pension benefit payment that you client could
receive during retirement
Use the following information.  [NAME] spin buttons to allow the ages to vary in steps of one year.
Each year should have a minimum value of the age before it + 1.  Figure out how to use the =min() function to do this.
Put the raw output from the spin buttons in column J.
So that, for example, if your client is 22 years old, the expected retirement age can't be less than 23.
The interest rate, in APR(monthly) terms, should move in steps of 0.1%, with a minimum value of 0% and a maximum value of 15%.
Your fund has a return of |  |  |  |  | 0.06 | APR(monthly)
Your client's current age is |  |  |  |  | 21 | yr
Your client's expected retirement
 | age is |  |  |  | 67 | yr
Your client's expected lifetime is |  |  |  |  | 99 | yr
6a.  You have the following information:
Inventory |  | 5000 |  | 7500
A/R |  | 1800 |  | 2500
Net credit sales |  |  | 50500
[NAME] |  |  | 35000
Calculate the sum of the average age of inventory and the average
collection period.
avg inv = | 6250 |  | av inv turn | 5.6
avg a/r= | 2150 |  | a/r turn | 23.48837209302325
av age of inv |  | 65.17857142857143
[NAME]. |  | 15.53960396039604
sum = |  | 80.71817538896747
6b.  What is one difference between the current ratio and the quick
ratio?  You only need to remember the first part of one of the Schaum's
problems to solve this.
The quick ratio doesn't include all the current assets.  In particular, the quick
ratio doesn't include inventory.
6c (Extra credit)  When might the quick ratio be a better measure
than the current ratio when measuring a firm's ability to pay bills?
Base your answer on the class discussion, notes, and other course
material.
If the firm is experiencing difficulty selling its inventory, it might be better to not
include inventory in the firm's ability to pay.
7.  Write down the Excel code that solves this problem.
Spreadsheet: 052eed46-872e-4136-9710-397485f35a9b
Sheet: BUDGET PROPOSAL

BUDGET PROPOSAL - ORGANIZATION | Budget Line Item Amount
Document #4XXXXXXXXX   Grant Year X   BNXX  Vendor #[NAME]
STAFF CATEGORY
SALARIES
Executive Director: $[NAME],[NAME] XX% | 0
Staff member : $[NAME],[NAME] XX% | 0
Staff member: $[NAME],[NAME] XX% | 0
[NAME]
BENEFITS
Executive Director [NAME] | 0
Staff member @ XX.X% | 0
Staff member @ XX.X% | 0
Benefits Subtotal
STAFF TOTAL
EQUIPMENT CATEGORY
EQUIPMENT PURCHASE
[NAME] | 0
EQUIPMENT LEASE/RENTAL
[NAME] | 0
EQUIPMENT MAINTENANCE AGREEMENTS
[NAME] | 0
Computer/Server/Website Maintenance Agreements | 0
EQUIPMENT TOTAL
OTHER CATEGORY
PROFESSIONAL SERVICES
Attorney | 0
Audit | 0
Bookkeeping/Accounting | 0
Information Technology | 0
Liability Insurance - Office | 0
Liability Insurance - Directors & Officers | 0
Marketing/Outreach | 0
Worker's Comp | 0
Payroll Service | 0
Printing/Reproduction | 0
Staff Training/Education | 0
Computer Software | 0
Meeting Room Charge | 0
PROFESSIONAL MEMBERSHIP DUES/SUBSCRIPTIONS
Organizational Membership Dues | 0
Other Membership Dues | 0
Newspaper Meeting Notices | 0
Office Supplies | 0
Program Supplies | 0
Postage and Overnight Mail | 0
REASONABLE ACCOMMODATIONS
Interpreter Services | 0
OCCUPANCY EXPENSES
Rent | 0
Cleaning/Maintenance | 0
Utilities | 0
TELEPHONE/INTERNET/FAX
Cell phone service | 0
Land line telephone service | 0
[NAME] | 0
Internet service | 0
TRAVEL
Travel - Lodging | 0
Travel - Meals | 0
Travel - Transportation | 0
Administrative Overhead | 0
OTHER TOTAL
GRAND TOTAL
Spreadsheet: 770770d1646244927-unique-and-filter-inside-countif-s-function-unique-filter-inside-countifs-function
Sheet: Sheet1

Subject | Student | Score |  |  | Subject | Score
ENGLISH | [NAME] | D |  |  | BIOLOGY | A |  |  |  | A | 3
PHYSICS | [NAME] | B |  |  |  | C |  |  | BIOLOGY | D | 1
ENGLISH | Doe | E |  |  |  | D |  |  | BIOLOGY | C | 1
HISTORY | [NAME] | E |  |  | CHEMISTRY | A |  |  | CHEMISTRY | A | 1
GEOGRAPHY | [NAME] | B |  |  | ENGLISH | A |  |  | ENGLISH | D | 2
ENGLISH | [NAME] | A |  |  |  | D |  |  | ENGLISH | E | 1
GEOGRAPHY | [NAME] | A |  |  |  | E |  |  | ENGLISH | A | 1
ENGLISH | Doe | D |  |  | GEOGRAPHY | A |  |  | GEOGRAPHY | B | 1
PHYSICS | [NAME] | A |  |  |  | B |  |  | GEOGRAPHY | A | 2
HISTORY | [NAME] | A |  |  | HISTORY | A |  |  | HISTORY | E | 1
GEOGRAPHY | [NAME] | A |  |  |  | C |  |  | HISTORY | A | 1
PHYSICS | [NAME] | D |  |  |  | E |  |  | HISTORY | C | 1
MATHEMATICS | Doe | B |  |  | MATHEMATICS | B |  |  | MATHEMATICS | B | 1
HISTORY | [NAME] | C |  |  | PHYSICS | A |  |  | PHYSICS | B | 2
PHYSICS | [NAME] | B |  |  |  | B |  |  | PHYSICS | A | 2
BIOLOGY | [NAME] | A |  |  |  | D |  |  | PHYSICS | D | 1
PHYSICS | [NAME] | A
BIOLOGY | [NAME] | D
CHEMISTRY | Doe | A
BIOLOGY | [NAME] | A
BIOLOGY | [NAME] | A
BIOLOGY | [NAME] | C
Spreadsheet: 186876d1350275957-weekly-schedule-book2
Sheet: DATA

NAME | STATUS | RECEIVED DATE | PO | BAL. QTY | TOTAL TIME | START TIME | END TIME
JACK | IN PROGRESS | 2012-10-12 00:00:00 | 12A | 10 | 01:00:00 | 09:00:00 | 10:00:00
JACK | DELIVERED | 2012-10-13 00:00:00 | 34B | 3 | 00:30:00 | 10:00:00 | 11:00:00
MARK | DELIVERED | 2012-10-14 00:00:00 | 56C | 13 | 02:00:00 | 11:00:00 | 12:00:00
MARK | IN PROGRESS | 2012-10-15 00:00:00 | 78D | 6 | 00:40:00 | 12:00:00 | 13:00:00
MARK | IN PROGRESS | 2012-10-16 00:00:00 | 90E | 4 | 00:20:00 | 13:00:00 | 14:00:00
JACK | IN PROGRESS | 2012-10-17 00:00:00 | 112F | 3 | 00:20:00 | 14:00:00 | 15:00:00
MARK | DELIVERED | 2012-10-18 00:00:00 | 113G | 8 | 02:00:00 | 15:00:00 | 16:00:00
MARK | DELIVERED | 2012-10-19 00:00:00 | 114H | 7 | 00:34:00 | 16:00:00 | 17:00:00
JACK | IN PROGRESS | 2012-10-20 00:00:00 | 115I | 3 | 00:40:00 | 17:00:00 | 18:00:00
JACK | IN PROGRESS | 2012-10-21 00:00:00 | 116J | 3 | 00:10:00 | 18:00:00 | 19:00:00
MARK | IN PROGRESS | 2012-10-22 00:00:00 | 117K | 9 | 02:00:00 | 19:00:00 | 20:00:00
JACK | DELIVERED | 2012-10-23 00:00:00 |  |  |  | 20:00:00 | 21:00:00
JACK | IN PROGRESS | 2012-10-24 00:00:00 | 119L | 2 | 02:20:00 | 21:00:00 | 22:00:00
JACK | IN PROGRESS | 2012-10-25 00:00:00 | 120M | 3 | 00:42:00 | 22:00:00 | 23:00:00
JACK | IN PROGRESS | 2012-10-26 00:00:00 | 121N | 2 | 00:23:00 | 23:00:00 | 1900-01-01 00:00:00
Spreadsheet: 105055d1302537608-excel-2007-automatically-update-a-2nd-sheet-when-another-is-updated-schedule
Sheet: A1

Overall Schedule | Refit / New | Factory | M  a  r  c  h |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A  p  r  I  l |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M a  y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J  u  n  e |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S e p t e m b e r
Store |  |  | 1 | 2 | 3 | 4 | 5 | 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 | 1 | 2 | 3 | 4 | 5 | 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 | 1 | 2 | 3 | 4 | 5 | 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 | 1 | 2 | 3 | 4 | 5 | 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 | 1 | 2 | 3 | 4 | 5 | 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 | 1 | 2 | 3 | 4 | 5 | 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 | 1 | 2 | 3 | 4 | 5 | 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
 |  |  |  |  |  |  |  |  | 07-13 |  |  |  |  |  |  | 14-20 |  |  |  |  |  |  | 21-27 |  |  |  |  |  |  | 28-03 |  |  |  |  |  |  | 04-10 |  |  |  |  |  |  | 11-17 |  |  |  |  |  |  | 18-24 |  |  |  |  |  |  | 25-01 |  |  |  |  |  |  | 02-08 |  |  |  |  |  |  | 09-15 |  |  |  |  |  |  | 16-22 |  |  |  |  |  |  | 23-29 |  |  |  |  |  |  | 30-05 |  |  |  |  |  |  | 06-12 |  |  |  |  |  |  | 13-19 |  |  |  |  |  |  | 20-26 |  |  |  |  |  |  | 27-03 |  |  |  |  |  |  | 04-10 |  |  |  |  |  |  | 11-17 |  |  |  |  |  |  | 18-24 |  |  |  |  |  |  | 25-31 |  |  |  |  |  |  | 01-07 |  |  |  |  |  |  | 08-14 |  |  |  |  |  |  | 15-21 |  |  |  |  |  |  | 22-28 |  |  |  |  |  |  | 29-04 |  |  |  |  |  |  | 05-11 |  |  |  |  |  |  | 12-18 |  |  |  |  |  |  | 19-25
ATTERBURY | N | BSK
WOODMEAD | N | VANEK
RUSSIA X 3 - STOCK STORES | N | BSK
BERLIN B5 | R
BUDAPEST | R | VANEK
ATHENS | N | BSK
PLAISIR | N | VANEK
AOSTA | N | BSK
LA CORUNA | N | VANEK
HATFIELD | R | BSK
Orion - St Petersburg | N
TOULOUSE | N | VANEK
SAVELOSKY - MOSCOW | N
LA VALLEE | R | BSK
[NAME] | R | VANEK
INGOLSTADT | R
MAASMECHELEN | R | BSK
PORTSMOUTH   - VANEK | R | VANEK
PIRIOS - GREECE | N | BSK
LODZIC | N | VANEK
METZINGEN | R | BSK
KRAKOW | N | VANEK
Spreadsheet: 708198d1607669798-formula-to-pull-through-specific-data-from-one-table-tab-to-another-formula-query
Sheet: Project Plan

Property | Address | Occupancy Status | Size | Property Code | Survey Status | Comments
Building 1 | 1 Road, City, XX11 1XX | Vacant | 1453 | 1 | Complete
Building 2 | 2 Road, City, XX11 1XX | Disposed | 138 | 2 | Complete
Building 3 | 3 Road, City, XX11 1XX | Occupied | 135 | 3 | Complete
Building 4 | 4 Road, City, XX11 1XX | Occupied | 546 | 4 | Not Started
Building 5 | 5 Road, City, XX11 1XX | Occupied | 7416 | 5 | Not Started
Building 6 | 6 Road, City, XX11 1XX | Occupied | 513 | 6 | Not Started
Building 7 | 7 Road, City, XX11 1XX | Occupied | 546 | 7 | Complete
Building 8 | 8 Road, City, XX11 1XX | Occupied | 43 | 8 | Complete
Building 9 | 9 Road, City, XX11 1XX | Disposed | 4931 | 9 | Complete
Building 10 | 10 Road, City, XX11 1XX | Occupied | 43 | 10 | Complete
Building 11 | 11 Road, City, XX11 1XX | Occupied | 434 | 11 | Complete
Building 12 | 12 Road, City, XX11 1XX | Vacant | 183 | 12 | Out of Scope | Property has been disposed
Building 13 | 13 Road, City, XX11 1XX | Vacant | 2254 | 13 | Complete
Building 14 | 14 Road, City, XX11 1XX | Occupied | 2265 | 14 | Complete
Building 15 | 15 Road, City, XX11 1XX | Occupied | 4385 | 15 | Complete
Building 16 | 16 Road, City, XX11 1XX | Occupied | 2264 | 16 | Complete
Building 17 | 17 Road, City, XX11 1XX | Occupied | 244 | 17 | On Hold | Site is currently closed due to [NAME]
Building 18 | 18 Road, City, XX11 1XX | Occupied | 246 | 18 | On Hold | Property is currently a building site and being re-furbished
Building 19 | 19 Road, City, XX11 1XX | Occupied | 264 | 19 | In Progress
Building 20 | 20 Road, City, XX11 1XX | Occupied | 2264 | 20 | Complete
Building 21 | 21 Road, City, XX11 1XX | Occupied | 243 | 21 | Complete
Building 22 | 22 Road, City, XX11 1XX | Occupied | 264 | 22 | Out of Scope | Property is due for refurbishment 2 mid 2021. Was asked not to survey
Building 23 | 23 Road, City, XX11 1XX | Occupied | 345 | 23 | On Hold | Waiting on keys
Building 24 | 24 Road, City, XX11 1XX | Occupied | 355 | 24 | Complete
Building 25 | 25 Road, City, XX11 1XX | Occupied | 264 | 25 | Complete
Spreadsheet: 879630d1727200533-dept-and-date-to-auto-calculate-based-on-todays-date-example
Sheet: Time Loss

Sum of Total Loss Days | Column Labels
Row Labels | Bailing Dock | K5 | Receiving | Grand Total
Foot/Ankle |  | -45152 |  | -45152
[NAME] |  | -45152 |  | -45152
Left Shoulder |  |  | 14 | 14
[NAME] |  |  | 14 | 14
Lower Back |  | 229 |  | 229
[NAME] |  | 229 |  | 229
Mid Back |  | 141 |  | 141
[NAME] |  | 141 |  | 141
Right Arm | -45216 |  |  | -45216
Sprain | -45216 |  |  | -45216
Grand Total | -45216 | -44782 | 14 | -89984
Spreadsheet: 49523d1248882748-find-average-from-each-column-dcraker-sample-1-
Sheet: Results

 |  |  |  |  | Time standards exceeded
Name | # of Boards | # of Rejects | % |  | h/prepping | masking | stuffing | labels | depanel | kiss | wave | stuffing/s | hand/s | touch up | wash
[NAME] | 401 | 41 | 0.1022443890274314 |  | 0.3648888888888889 |  | 0.121875 |  |  |  |  |  | 0.04777777777777778
Shauna | 481 | 7 | 0.01455301455301455 |  |  |  |  | 0.5170370370370371
15 more names and tabs
A thru D columns do not need
modifications, unless needed
 |  |  |  |  | Results shown is the current average, done manually, would like it automatic
 |  |  |  |  | Columns F thru P will get the average time spent on the specifed process for the day from there respective sheets
 |  |  |  |  |  |  |  | 0.36
Spreadsheet: 88839d1288668930-how-to-import-multiple-values-w-a-vlookup-into-a-single-cell-test
Sheet: Sheet1

Import Section
Labour Expense | 0 |  | should be 220
Raw Mat Expense | 15 |  | should be 100
[NAME] | 70
North | 20
South | 25
East | 15
West | #N/A
Total | #N/A
Average | #N/A
Data Section
Labour Expense 1 | 100
Labour Expense 2 | 120
Raw Mat 1 | 40
Raw Mat 2 | 50
Raw Mat 3 | 10
[NAME] | 70
North | 20
South | 25
East | 15
Spreadsheet: 838230d1690831451-sum-value-error-jul_wk4-data_test
Sheet: Shannon

Agent's name: |  | Date:
Weekly RingCentral Stats |  |  |  |  |  |  |  |  | Service Cloud Cases |  |  |  | Weekly CSC RingCentral Stats
Skills | Count | [NAME] | Sum of Hold | Sum ACW Mins | [NAME] | [NAME] | AHT | % | Service Cloud | Cases Created | Cases Closed |  | [NAME] | Count | Sum of Agent_Time | Sum of Hold | Sum of ACW | [NAME] | [NAME] | AHT
CSC - After HRS VM Messages |  |  |  |  |  |  |  |  | CSC |  |  |  | CSC - After HRS VM Messages
CSC - Email Skill |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Email Skill
CSC - Inbound Support |  |  |  |  |  |  |  |  | % |  |  |  | CSC - Inbound Support
CSC - Outbound Support |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Outbound Support
Total |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
Previous Week Stats |  |  |  |  |  |  |  |  | Service Cloud Cases |  |  |  | Previous Week's CSC RingCentral Stats
Skills | Count | [NAME] | Sum of Hold | Sum ACW Mins | [NAME] | [NAME] | AHT | % | Service Cloud | Cases Created | Cases Closed |  | [NAME] | Count | Sum of Agent_Time | Sum of Hold | Sum of ACW | [NAME] | [NAME] | AHT
CSC - After HRS VM Messages |  |  |  |  |  |  |  |  | CSC |  |  |  | CSC - After HRS VM Messages
CSC - Email Skill |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Email Skill
CSC - Inbound Support |  |  |  |  |  |  |  |  | % |  |  |  | CSC - Inbound Support
CSC - Outbound Support |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Outbound Support
Total |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
Spreadsheet: darrell_schoolcraft__7379__NNG LAMAR NOMNATION
Sheet: 01-(26)

 |  |  |  | Time/Date
 |  |  |  | Beginning Gas Day: | 2002-01-26 00:00:00 | Saturday only
 |  |  |  | Ending Gas Day: | 2002-01-26 00:00:00
 |  | [NAME] |  |  | 45000
 |  | Hour
 |  | Ending | [NAME] | Accumulated | Remaining | Daily Burn
 |  | CST |  |  |  | Rate
 |  | 10 | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 750
 |  |  | 0
 |  | 1 | 0
 |  | 2 | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: sally_beck__33907__Global Hot List 0111
Sheet: Hotlist - Identified 

E N R O N   G L O B A L   M A R K E T S  -  H O T  L I S T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Results based on activity through January 11, 2000
 |  | First Quarter 2001 |  |  |  | Second Quarter 2001 |  |  |  | Third Quarter 2001 |  |  |  | Fourth Quarter 2001 |  |  |  | TOTAL
 | Liquids | Deal | % | Value |  | Deal | % | Value |  | Deal | % | Value |  | Deal | % | Value
 |  | Envera | 0.95 | 5000 |  | Dow / Tosco | 0.5 | 2000 |  |  |  |  |  | [NAME] | 0.3 | 2800
 |  | Peerless | 0.85 | 500 |  | Talisman Crude | 0.7 | 3000
 |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | TOTAL
Coal | Origination & Finance | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value
 |  | SynFuel - AIG | 0.75 | 15000 |  | M&G - UK | 0.5 | 1000
 |  | Jupiter / Eagle Energy | 0.25 | 5000
 |  | DPR | 0.25 | 5000
 |  | British Energy - UK | 0.7 | 5000
 |  | Cline-Panther Call Option | 0.25 | 5000
 |  | [NAME] | 0.9 | 1150
 |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | TOTAL
 | Emissions | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value
 |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | TOTAL
 | Weather | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value
 |  | Caxton | 0.6 | 125 |  | Idaho Power | 0.5 | 1000
 |  | Great Lakes Chemical | 0.4 | 50 |  | Harvard Fund | 0.3 | 250
 |  | Fresh Express | 0.3 | 50 |  | Welch's | 0.25 | 200
 |  | Palace Entertainment | 0.4 | 35
 |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | TOTAL
Global | Risk Markets | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value
 |  | Project MI - 3 | 0.5 | 4000 |  | Project Taft | 0.2 | 10000
 |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | TOTAL
 | Transportation | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value
 |  | RR Marketing JV - US |  | 0
 |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | TOTAL
 | LNG | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value
 |  | [NAME] | 0.9 | 1125
 |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | TOTAL
 | Middle East | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value
 |  | Oman sell down | 0.75 | 1050
 |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | TOTAL
 | Puerto Rico | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value |  | Deal |  | Value
 |  | Progasco | 0.5 | 15000
 |  | San Juan Gas Fiber | 0.5 | 8000
 |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | SUBTOTAL |  |  |  | TOTAL
 |  | TOTALS |  |  |  | TOTALS |  |  |  | TOTALS |  |  |  | TOTALS |  |  |  | TOTALS
Spreadsheet: 672413d1586866132-vlookup-hlookup-for-question-3
Sheet: Weekly store movement

Primary DC | Store | SKU > | 19750 | 68880 | 94530 | 122990 | 125040 | 125190 | 131790 | 132490 | 132690 | 132750 | 133760 | 134060 | 134070 | 134080 | 134450 | 134700 | 134770 | 134780 | 134800 | 134820 | 134850 | 134860 | 134950 | 134990 | 135080 | 135250 | 135580 | 135600 | 135620 | 135960 | 135970 | 135980 | 201350 | 204440 | 238420 | 238870 | 239500 | 243430 | 243900 | 244040 | 248870 | 248890 | 258080 | 305830 | 311540 | 333651 | 333950 | 335380 | 336540 | 336860 | 342380 | 342720 | 342970 | 343350 | 372280 | 459850 | 487500 | 548930 | 645350 | 645360 | 645550 | 645560 | 645670 | 645680 | 673490 | 755940 | 787640 | 808220
DC04 - DUNN, NC | 40 |  | 31 | 30 | 25 | 30 | 7 | 11 | 65 | 26 | 25 | 63 | 20 | 47 | 37 | 47 | 26 | 86 | 50 | 73 | 87 | 120 | 108 | 209 | 119 | 94 | 95 | 145 | 24 | 97 | 47 | 90 | 94 | 63 | 38 | 19 | 34 | 59 | 5 | 19 | 13 | 19 | 35 | 7 | 27 | 10 | 15 | 38 | 18 | 88 | 55 | 37 | 33 | 36 | 29 | 11 | 10 | 52 | 76 | 8 | 38 | 32 | 60 | 52 | 54 | 215 | 65 | 19 | 17 | 3
DC04 - DUNN, NC | 57 |  | 47 | 23 | 42 | 28 | 20 | 12 | 149 | 38 | 133 | 0 | 38 | 133 | 47 | 66 | 34 | 256 | 140 | 205 | 189 | 240 | 148 | 212 | 341 | 192 | 188 | 74 | 30 | 148 | 64 | 81 | 104 | 139 | 42 | 19 | 37 | 38 | 15 | 20 | 9 | 22 | 40 | 51 | 22 | 16 | 41 | 102 | 0 | 212 | 133 | 43 | 32 | 44 | 25 | 20 | 28 | 60 | 43 | 11 | 84 | 65 | 194 | 48 | 129 | 383 | 145 | 20 | 13 | 10
DC04 - DUNN, NC | 59 |  | 50 | 20 | 32 | 19 | 4 | 10 | 57 | 17 | 107 | 0 | 31 | 37 | 27 | 16 | 22 | 174 | 59 | 119 | 101 | 174 | 104 | 160 | 182 | 91 | 139 | 67 | 20 | 97 | 29 | 83 | 131 | 133 | 35 | 7 | 17 | 17 | 8 | 10 | 10 | 22 | 17 | 8 | 11 | 10 | 17 | 54 | 0 | 127 | 32 | 48 | 7 | 31 | 13 | 13 | 6 | 58 | 90 | 6 | 47 | 46 | 37 | 35 | 55 | 210 | 64 | 14 | 12 | 9
DC04 - DUNN, NC | 61 |  | 51 | 9 | 22 | 21 | 7 | 2 | 84 | 22 | 103 | 0 | 6 | 37 | 39 | 45 | 26 | 198 | 83 | 94 | 117 | 184 | 137 | 102 | 189 | 173 | 134 | 33 | 14 | 54 | 31 | 59 | 45 | 115 | 26 | 5 | 29 | 18 | 4 | 13 | 22 | 11 | 12 | 5 | 17 | 5 | 18 | 32 | 0 | 139 | 40 | 43 | 14 | 12 | 21 | 10 | 12 | 27 | 41 | 8 | 23 | 43 | 75 | 44 | 76 | 292 | 106 | 8 | 11 | 4
DC04 - DUNN, NC | 67 |  | 80 | 22 | 29 | 49 | 8 | 10 | 54 | 57 | 120 | 0 | 37 | 63 | 25 | 42 | 68 | 139 | 92 | 130 | 134 | 148 | 129 | 160 | 233 | 97 | 123 | 50 | 16 | 138 | 56 | 50 | 92 | 69 | 42 | 19 | 48 | 53 | 21 | 29 | 17 | 32 | 31 | 4 | 45 | 4 | 34 | 47 | 0 | 134 | 79 | 43 | 38 | 54 | 51 | 19 | 15 | 65 | 102 | 4 | 101 | 48 | 152 | 89 | 126 | 437 | 106 | 16 | 16 | 2
Spreadsheet: 792035d1660716407-get-dates-from-a-row-and-put-it-into-a-column-forum-upload-hd-5-
Sheet: Calculator

 |  | Check in | Check out
 |  | 2022-08-09 00:00:00 | 2022-09-29 00:00:00
 | 1 | 2 | 3 | 4 | 5 | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60
CHECK IN
CHECK OUT
FATIGUE
 |  | Check in |  | Check out
 |  | 2022-08-09 00:00:00 |  | 2022-08-16 00:00:00
 |  | 2022-08-24 00:00:00 |  | 2022-08-31 00:00:00
 |  | 2022-09-06 00:00:00 |  | 2022-09-13 00:00:00
 |  | CHECK IN |  | CHECK OUT
 |  | 2022-08-24 00:00:00 |  | 2022-08-31 00:00:00
 |  | 2022-09-06 00:00:00 |  | 2022-09-13 00:00:00
 |  | 2022-09-21 00:00:00 |  | 2022-09-28 00:00:00
Spreadsheet: 203701d1357227366-link-data-in-worksheets-add-deduct-formulas-as-criteria-are-arent-met-attendance-template-excel
Sheet: July

Employee Absence Schedule
July | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 1 | 2 | 3 | 4 | 5 | 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 | CI | T | NCNS | Total Points
Employee 1
Employee 2
Employee 3
Employee 4
Employee 5
Spreadsheet: 846945d1698074684-summarize-multiple-worksheets-into-one-sheet-question_sample
Sheet: OUTPUT

steps | 1234 | 5678 | 10258
STEP 1A | 6.906 | 6.906 | 6.906
STEP 2A | 7.44633333333333 | 7.44633333333333 | 7.44633333333333
STEP 2B | 0 | 0 | 0
STEP 3A | 8.64033333333333 | 8.64033333333333 | 8.64033333333333
STEP 3B | 0 | 0 | 0
STEP 4A | 2.195 | 2.195 | 2.195
STEP 5A | 4.803 | 4.803 | 4.803
STEP 5B | 0 | 0 | 0
STEP 6a | 1.5415 | 1.5415 | 1.5415
step 7a | 16.2 | 16.2 | 16.2
step 8a | 0.9915 | 0.9915 | 0.9915
step 9a | 0 | 0 | 0
step 9b | 0 | 0 | 0
step 10a | 0 | 0 | 0
step 10b | 0 | 0 | 0
step 11a | 0 | 0 | 0
step 11b | 1.66066666666667 | 1.66066666666667 | 1.66066666666667
step 11c | 0 | 0 | 0
step 12a | 0 | 0 | 0
step 12b | 0 | 0 | 0
step 13a | 0 | 0 | 0
step 14a | 0 | 0 | 0
step 14b | 0 | 0 | 0
step 15a | 0 | 0 | 0
step 16a | 0 | 0 | 0
step17a | 0 | 0 | 0
step17b | 0 | 0 | 0