tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 714748d1611341210-assisted-needed-with-matching-multiple-fields-excel-match-help4-rawonly
Sheet: Sheet1

RAW - IP Address: | RAW - System Name:
2.10.9.3 | Computer 2i
2.10.9.2 | Computer 9i
2.10.9.1 | Computer 16d
2.10.10.0 | Computer 5i
2.10.10.1 | Computer 17e
2.10.10.2 | Computer 15i
2.10.10.3 | Computer 19d
2.10.10.4 | Computer 18e
2.10.10.5 | Computer 3i
2.10.10.7 | Computer 13i
2.10.10.8 | Computer 20a
2.10.10.9 | Computer 25d
2.10.10.6 | Computer 6i
2.10.10.11 | Computer 21a
2.10.10.12 | Computer 7i
2.10.10.13 | Computer 26d
2.10.10.14 | Computer 27d
1.10.11.6 | Computer 6
2.10.10.16 | Computer 4i
2.10.10.17 | Computer 22a
2.10.10.18 | Computer 28d
2.10.10.19 | Computer 29a
2.10.10.20 | Computer 23b
1.10.11.7 | Computer 7
2.10.10.15 | Computer 8i
2.10.10.23 | Computer 30a
2.10.10.24 | Computer 24c
2.10.10.25 | Computer 12i
1.10.11.1 | Computer 1
1.10.11.5 | Computer 5
1.10.11.8 | Computer 8
1.10.11.11 | Computer 11
1.10.11.12 | Computer 12
2.10.10.10 | Computer 1i
1.10.11.14 | Computer 14
1.10.11.15 | Computer 15
1.10.11.4 | Computer 4
1.10.11.9 | Computer 9
1.10.11.10 | Computer 10
1.10.11.2 | Computer 2
1.10.11.3 | Computer 3
2.10.10.26 | Computer 11i
1.10.11.13 | Computer 13
2.10.10.21 | Computer 14i
2.10.10.22 | Computer 10i
Spreadsheet: 273520d1382735052-compare-a-and-c-column-if-match-my-logic-display-result-in-b-column-find-suspend-numbers
Sheet: Sheet1

NUMBER STATUS | errors in suspend numbers | ERRORS
New Activation
New Activation
Susp for TV process [NAME]
Susp for TV process [NAME] | Susp for TV process [NAME] | CUG NOT GIVEN
Susp for TV process [NAME]
Susp for TV process [NAME]
React for TV process [NAME] |  | CUG NOT GIVEN
Susp for TV process [NAME]
React for TV process [NAME]
New Activation |  | CUG NOT GIVEN
New Activation
New Activation |  | CUG NOT GIVEN
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] | Susp for TV process [NAME] | CUG NOT GIVEN
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] | Susp for TV process [NAME] | CUG NOT GIVEN
New Activation
Susp for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME] |  | PRICE GROUP WRONG
Susp for TV process [NAME] | Susp for TV process [NAME] | PLAN CHANGED
Susp for TV process [NAME]
Susp for TV process [NAME] |  | CUG NOT GIVEN
Susp for TV process [NAME]
Susp for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] | Susp for TV process [NAME] | CUG NOT GIVEN
Susp for TV process [NAME]
Susp for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
New Activation
Susp for TV process [NAME]
Susp for TV process [NAME]
Susp for TV process [NAME] | Susp for TV process [NAME] | CUG NOT GIVEN
Susp for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME] |  | PLAN CHANGED
Susp for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] | Susp for TV process [NAME] | CUG NOT GIVEN
New Activation
Susp for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME]
Susp for TV process [NAME] | Susp for TV process [NAME] | CUG NOT GIVEN
React for TV process [NAME]
Susp for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] | Susp for TV process [NAME] | CUG NOT GIVEN
React for TV process [NAME] |  | CUG NOT GIVEN
Number portability activation |  | CUG NOT GIVEN
Susp for TV process [NAME]
Susp for TV process [NAME]
Susp for TV process [NAME] | Susp for TV process [NAME] | CUG NOT GIVEN
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
Number portability activation
React for TV process [NAME]
0
Spreadsheet: 48578d1247804839-excel-template-possible-for-this-final-cl8-grades-dev
Sheet: Lists

 | 8 | Baines | Kelsey | B | S | S | S | S | S | S | S | B | B |  |  | Gradingscale
 | 8 | Barta | Bence | S | S | T | T | S | S | S | S | T | S |  |  | E
 | 8 | Cah | Aden | S | S | S | S | S | S | S | B | T | T |  |  | T
 | 8 | Cincotta | Emily | B | S | S | S | S | T | S | T | S | S |  |  | S
 | 8 | [NAME] | [NAME] | T | S | T | E | T | T | S | T | T | T |  |  | B
 | 8 | Dacey | [NAME] | S | S | T | B | S | B | T | S | S | S |  |  | L
 | 8 | Dacey | [NAME] | T | S | T | S | S | S | S | T | T | T |  |  | NEW
 | 8 | [NAME] | Tess | E | S | T | T | T | T | S | T | S | E
 | 8 | [NAME] | Callum | L | S | S | B | B | B | B | S | B | B
 | 8 | [NAME] | Martin | S | S | S | B | S | S | S | S | S | T
 | 8 | Hall | Emily | B | S | T | NEW | S | B | S | S | S | S
 | 8 | Jones-Hughes | Delwyn | S | S | S | B | B | B | S | B | B/S | B
 | 8 | Jost | [NAME] | T | S | T | E | S | E | S | T | T | B
 | 8 | Kamper | Olivia | T | S | T | T | S | S | S | T | T | S
 | 8 | Kelly | Siobhan | B | S | T | E | S | B | S | T | T | E
 | 8 | Lodhia | Sheena | B | B | S | L | S | B | S | S | L | S
 | 8 | [NAME] | [NAME] | B | S | S | S | S | S | S | T | B | S
 | 8 | [NAME] | [NAME] | S | S | T | S | S | S | S | S | S | S
 | 8 | [NAME] | [NAME] | L | S | S | B | B | B | B | B | B/S | B
 | 8 | O'Doherty | Alexandra | S | S | S | S | S | S | S | T | S | T
 | 8 | [NAME] | Hilary | T | S | T | E | S | S | S | T | T | S
 | 8 | Roose | [NAME] | S | S | T | S | S | B | S | S | S | S
 | 8 | Strijakova | Vara | E | S | S | E | S | T | E | T | S | S
 | 8 | [NAME] | [NAME] | T | S | T | T | S | T | S | T | S | S
 | 8 | Towers | Jessica | S | S | T | S | S | S | E | T | S | T
 | 8 | Ulich | Kristina | S | S | B | B | S | B | S | S | S | B
 | 8 | Walters | [NAME] | L | B | B | B | S | L | S | B | T | B
 | 8 | Wilde | [NAME] | B | S | S | B | S | L | S | B | S | B
 | 8 | [NAME] | [NAME] | S | S | NEW | NEW | S | L | S | S | S | B
Spreadsheet: 77212d1277735435-gantt-chart-with-conditional-formatting-implementation-plan
Sheet: Year 1 Plan-2011

 |  |  | Sub-Activities | Days | Criticality | Resources | Duration (Weeks) | Start | End |  | 2010-04-01 00:00:00 | 2010-04-08 00:00:00 | 2010-04-15 00:00:00 | 2010-04-22 00:00:00 | 2010-04-29 00:00:00 | 2010-05-06 00:00:00 | 2010-05-13 00:00:00 | 2010-05-20 00:00:00 | 2010-05-27 00:00:00 | 2010-06-03 00:00:00 | 2010-06-10 00:00:00 | 2010-06-17 00:00:00 | 2010-06-24 00:00:00 | 2010-07-01 00:00:00 | 2010-07-08 00:00:00 | 2010-07-15 00:00:00 | 2010-07-22 00:00:00 | 2010-07-29 00:00:00 | 2010-08-05 00:00:00 | 2010-08-12 00:00:00 | 2010-08-19 00:00:00 | 2010-08-26 00:00:00 | 2010-09-02 00:00:00 | 2010-09-09 00:00:00 | 2010-09-16 00:00:00 | 2010-09-23 00:00:00 | 2010-09-30 00:00:00 | 2010-10-07 00:00:00 | 2010-10-14 00:00:00 | 2010-10-21 00:00:00 | 2010-10-28 00:00:00 | 2010-11-04 00:00:00 | 2010-11-11 00:00:00 | 2010-11-18 00:00:00 | 2010-11-25 00:00:00 | 2010-12-02 00:00:00 | 2010-12-09 00:00:00 | 2010-12-16 00:00:00 | 2010-12-23 00:00:00 | 2010-12-30 00:00:00 | 2011-01-06 00:00:00 | 2011-01-13 00:00:00 | 2011-01-20 00:00:00 | 2011-01-27 00:00:00 | 2011-02-03 00:00:00 | 2011-02-10 00:00:00 | 2011-02-17 00:00:00 | 2011-02-24 00:00:00 | 2011-03-03 00:00:00 | 2011-03-10 00:00:00 | 2011-03-17 00:00:00 | 2011-03-24 00:00:00 | 2011-03-31 00:00:00 | 2011-04-07 00:00:00
1 | Building National Capacity to Deliver
 | 1.1 | Development of 5-year strategy (Business Plan) |  | 70 |  |  | 10 | 2010-04-01 00:00:00 | 2010-06-10 00:00:00 |  | I need this to show in a different color
 |  | 1.1.1 | Tender awarded and consultant appointed | 21 |  |  | 3 | 2010-04-01 00:00:00 | 2010-04-07 00:00:00
 |  | 1.1.2 | Draft business plan developed | 21 |  |  | 3 | 2010-04-22 00:00:00 | 2010-05-13 00:00:00 |  | Different color for sub-activities
 |  | 1.1.3 | Draft implementation plans developed | 28 |  |  | 4 | 2010-05-13 00:00:00 | 2010-06-10 00:00:00
 | 1.2 | Complete & submit funding applications |  | 91 | 0 | 0 | 13 | 2010-04-18 00:00:00 | 2010-08-01 00:00:00
 |  | 1.2.1 | Defra funding bid completed and submitted | 28 |  |  | 4 | 2010-04-18 00:00:00 | 2010-05-16 00:00:00
 |  | 1.2.3 | Hold Funding Consultations with xxxx | 28 |  |  | 4 | 2010-05-30 00:00:00 | 2010-06-27 00:00:00
 |  | 1.2.3 | Complete xxx application/bid | 28 |  |  | 4 | 2010-06-27 00:00:00 | 2010-07-25 00:00:00
 |  | 1.2.4 | [NAME] | 7 |  |  | 1 | 2010-07-25 00:00:00 | 2010-08-01 00:00:00
Spreadsheet: 0f5a5c47-df75-48ae-beaf-639ac0763327
Sheet: Suspended, 2010SP

Suspended Students Spring 2010
 | Count | Inst. GPA | Cum. GPA | Transfer GPA
Freshmen | 126 | 0.97 | 1.03 | 1.99
Sophomore | 19 | 1.58 | 1.82 | 2.31
Junior | 4 | 1.12 | 1.74 | 2.07
Senior | 4 | 1.59 | 1.9 | 2.43
Specials | 1 | 0.6 | 0.6 | 0
Total |  | 1.295740259740259 | 1.40551948051948 | 1.373315789473684
2010 Fall Cohort | 2 | 0.184 | 0.184 | 0
 | Mean ACT
 | Not Suspended | Suspended | [NAME]'s D | Significance
ACT Comp | 21.2 | 19.05 | 0.647715 | ***
ACT Engl | 20.54 | 18 | 0.5694 | ***
ACT Math | 20.96 | 18.68 | 0.648011 | ***
ACT Reading | 21.61 | 19.55 | 0.442617 | ***
ACT Science Reading | 21.09 | 19.2 | 0.52503 | ***
*p < 0.10; **p < 0.05; ***p < 0.0001
Advisor | Advisees Suspended | Total Advisees | Pct.
Spreadsheet: kimberly_watson__20556__imbalsumm0109
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 139453 | 137487
2 | 136238 | 132590
3 | 140193 | 138247
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
2001-07-31 00:00:00 |  |  | 89897
2001-09-03 00:00:00
CBS Dollars
 |  |  | 503138
Spreadsheet: a180cf1e-4738-4e2c-9e38-fe7aa6ff664a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-11-25 09:33:46.200000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 102.625 | 102.5 | 102.375 | 102 |  | and are added to price quote
4.75 | 102.544 | 102.419 | 102.294 | 101.919
4.625 | 102.214 | 102.089 | 101.964 | 101.589 |  | Note: | Refer To Price [NAME]
4.5 | 101.34 | 101.215 | 101.09 | 100.715 |  |  | For all Price Adjs
4.375 | 100.406 | 100.281 | 100.156 | 99.531
4.25 | 99.757 | 99.632 | 99.507 | 98.882
4.125 | 98.966 | 98.841 | 98.716 | 98.091
4 | 97.978 | 97.853 | 97.728 | 97.103
3.875 | 96.952 | 96.827 | 96.702 | 96.077 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.625 | 102.5 | 102.375 | 102
3.75 | 102.197 | 102.072 | 101.947 | 101.572
3.625 | 101.814 | 101.689 | 101.564 | 101.189
3.5 | 101.261 | 101.136 | 101.011 | 100.636
3.375 | 100.54 | 100.415 | 100.29 | 99.665
3.25 | 99.783 | 99.658 | 99.533 | 98.908
3.125 | 98.791 | 98.666 | 98.541 | 97.916 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-12-09 09:33:46.200000
30 DAY | 2013-12-24 09:33:46.200000
45 DAY | 2014-01-08 09:33:46.200000
60 DAY | 2014-01-23 09:33:46.200000
90 DAY | 2014-02-22 09:33:46.200000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 96323565-b900-44c5-b447-475c4ee06fd0
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44459013 | 2014-12-15 21:10:55 | AXIS | 0 | 4 | 6 | 1007775 | [NAME] | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
44459370 | 2014-12-15 21:29:32 | ALLIES | 1 | 6 | 2 | 1007775 | [NAME] | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
44460749 | 2014-12-15 23:03:53 | AXIS | 0 | 4 | 6 | 1239735 | Vaillants | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
44461197 | 2014-12-15 23:31:13 | ALLIES | 1 | 6 | 5 | 1239735 | Vaillants | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
44486471 | 2014-12-17 20:55:12 | AXIS | 1 | 6 | 3 | 225841 | sacas | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
44486786 | 2014-12-17 21:22:29 | ALLIES | 0 | 5 | 6 | 225841 | sacas | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
44500130 | 2014-12-18 21:48:12 | ALLIES | 0 | 4 | 6 | 1682958 | player1682958 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
44500442 | 2014-12-18 22:09:24 | AXIS | 0 | 4 | 6 | 1682958 | player1682958 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: 798236d1664376652-create-new-value-if-certain-conditions-are-met-test-entitled-to-a-bundle-package
Sheet: Sheet1

Account number | School name | School Type | School Region | Subscription 1 | Subscription 2 | Subscription 3 | Subscription 4 | Subscription 5 | Bundle package
1234 | St Marys School | Secondary | Birmingham | French | English | Maths | Science | Spanish
2345 | St Pauls School | High School | [NAME] | Science | Spanish | French
3456 | London Free School | All Through | London | Science | Maths
4567 | St Michaels School | Secondary | [NAME] | Science | Maths | English | History | Geography
5678 | Liverpool Academy | Secondary | Liverpool | Spanish | Maths | French
Spreadsheet: 17b4917e-a753-43c0-a285-ae6cf01839c3
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8453 | 13651 | Martin | Falch | AUT | 357 | [NAME] | 00:00:38 | 00:34:01 | 00:00:00 | 00:22:25 | 1 | 01:09:52
Spreadsheet: 671260d1586331961-update-defining-exact-length-of-string-for-istext-within-aggregate-function-00-wages-template-for-tests
Sheet: 09 TUESDAY

DAY: |  | TUESDAY |  | DATE:
No. |  | NAME |  |  |  | FROM | TO | Wh | VL | SL | OT | F/L | Hr | F/L | Hr | F/L | Hr | F/L | Hr | JOBS | Hr | GR/WS | Hr | CHECK |  | JOBS BREAKDOWN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
12 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | [NAME] |  |  | GROUPAGE
11 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | DRIVERS |  |  | DRIVERS
14 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | PART TIMERS |  |  | PART TIMERS
33 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | WELDERS |  |  | WELDERS
37 | W
27 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS
53 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
54 | W
50 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
30 | P
31 | P
32 | P
51 | P
52 | P
55 | P
15 | P
23 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REPAIRS MT
26 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
6 | D
10 | D
47 | D
[NAME] |  |  |  |  | GROUPAGE |  |  | IDLE TIME |  |  |  |  | JOBS |  |  |  | REPAIRS MT |  |  |  | WORKSHOP WS
JOBS |  |  | HR |  | JOBS | HR |  | JOBS |  |  | HR |  | JOBS |  | HR |  | JOBS |  | HR |  | JOBS |  | HR
TOTAL |  |  |  |  | TOTAL |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 |  |  |  |  | Hours Calculator |  |  |  |  |  |  |  |  |  |  | TOTAL 2 |  |  |  |  | TOTAL 1
Spreadsheet: 779883d1652172653-need-help-with-timesheet-formulas-employee-timesheet
Sheet: Copy of may 1-15

 |  |  |  |  |  |  |  |  |  |  | work sched 8-5
 |  | On time all | 08:00:00 |  | 17:00:00 |  |  |  |  |  | conditions:
 |  | Late, out at 5 | 08:10:00 |  | 17:00:00 |  |  |  |  |  | late is 8:11 to 10 - 5
 |  | Late after 10, out at 5 | 10:01:00 |  | 17:00:00 |  |  |  |  |  | half day if 1001 - 5
 |  | In after 12, out at 5 | 12:01:00 |  | 17:00:00 |  |  |  |  |  | ut if out bet 301-449, in 801-810
 |  | In Early, Out bet 3-449 | 07:45:00 |  | 16:55:00 |  |  |  |  |  | no flexi
 |  | Early, Out after 5 | 07:30:00 |  | 17:15:00 |  |  |  |  |  | no ot
 |  | On time, out after 5 | 08:00:00 |  | 17:15:00 |  |  |  |  |  | grace period is 10 mins
 |  |  |  |  |  |  |  |  |  |  | saturday is only until 4:30
 |  |  |  |  |  |  |  | 09:00:00
 |  | On time all | 08:00:00 |  | 17:00:00 |  |  | 09:00:00 | 00:00:00 |  | how to encode the hours without typing colon
 |  | Late, out at 5 | 08:11:00 |  | 17:00:00 |  |  | 08:50:00 | 00:10:00
 |  | Late after 10, out at 5 | 10:01:00 |  | 17:00:00 |  |  | 06:59:00 | 02:01:00
 |  | In after 12, out at 5 | 12:01:00 |  | 17:00:00 |  |  | 04:59:00 | 04:01:00
 |  | In Early, Out bet 3-449 | 07:45:00 |  | 16:55:00 |  |  | 09:10:00 | ##########
 |  | Early, Out after 5 | 07:30:00 |  | 17:15:00 |  |  | 09:45:00 | ##########
 |  | On time, out after 5 | 08:00:00 |  | 17:15:00 |  |  | 09:15:00 | ##########
 |  | pay ;period
 |  |  | 2022-05-01 00:00:00 | lunch |  | total hours |  | minutes/hours for deduction | 2022-05-02 00:00:00
 |  | name 1 | 08:00:00 | 01:00:00 | 17:00:00 |  | 09:00:00 |  | in | out
 |  | name 2 | 08:11:00 | 01:00:00 | 17:00:00 |  | 09:00:00
 |  | name 3 | 10:01:00 | 01:00:00 | 17:00:00 |  | 09:00:00
 |  | name 4 | 12:01:00 | 01:00:00 | 17:00:00 |  | 09:00:00
 |  | name 5 | 07:45:00 | 01:00:00 | 16:55:00 |  | 09:00:00
 |  | name 6 | 07:30:00 | 01:00:00 | 17:15:00 |  | 09:00:00
 |  | name 7 | 08:00:00 | 01:00:00 | 17:15:00 |  | 09:00:00
Spreadsheet: 138365d1327625347-nested-if-statements-maybe-book1
Sheet: Sheet1

Agent | Lucent ID | Score | Evaluation Date | MGR_Login |  | Agent | EMP_Login | MGR_Login | phoneext | recordstart | recordend
Agent 1 | 6274299 | 100 | 2012-01-12 00:00:00 |  |  | Agent 1 | [NAME] | GSSTARK | 6274299 | 2012-01-15 00:00:00 | 2012-01-26 00:00:00
Agent 1 | 6274299 | 100 | 2011-11-22 00:00:00 |  |  | Agent 1 | [NAME] | SPLILLIB | 6274299 | 2012-01-01 00:00:00 | 2012-01-14 00:00:00
Agent 1 | 6274299 | 90 | 2012-01-03 00:00:00 |  |  | Agent 1 | [NAME] | DALLEN2 | 6274299 | 2011-12-10 00:00:00 | 2011-12-31 00:00:00
Agent 1 | 6274299 | 85 | 2011-11-23 00:00:00 |  |  | Agent 1 | [NAME] | SANGUIAN | 6274299 | 2011-11-20 00:00:00 | 2011-12-09 00:00:00
Agent 2 | 6274961 | 85 | 2011-12-10 00:00:00 |  |  | Agent 2 | Bpaters | SPLILLIB | 6274961 | 2012-01-01 00:00:00 | 2012-01-26 00:00:00
Agent 2 | 6274961 | 75 | 2011-12-09 00:00:00 |  |  | Agent 2 | Bpaters | JRAMIRE2 | 6274961 | 2011-12-01 00:00:00 | 2011-12-31 00:00:00
Agent 2 | 6274961 | 85 | 2012-01-09 00:00:00 |  |  | Agent 3 | Mjacks | DALLEN2 | 1220014 | 2012-01-06 00:00:00 | 2012-01-26 00:00:00
Agent 3 | 1220208 | 60 | 2012-01-20 00:00:00 |  |  | Agent 3 | Mjacks | LADAMS1 | 1220014 | 2011-12-10 00:00:00 | 2012-01-05 00:00:00
Agent 3 | 1220208 | 100 | 2011-12-07 00:00:00 |  |  | Agent 3 | Mjacks | JSMITH | 1220014 | 2011-12-01 00:00:00 | 2011-12-09 00:00:00
Agent 3 | 1220208 | 70 | 2011-11-30 00:00:00 |  |  | Agent 3 | Mjacks | NZSALAZA | 1220014 | 2011-11-01 00:00:00 | 2011-11-30 00:00:00
Spreadsheet: 605520d1547128226-data-required-in-a-easy-way-in-a-complex-file-18-19-costing1
Sheet: Result-WANT

imp | CODE | SID      PRODUCT NAME | QUANTITY | ACP SYSTEMS | a |  | RATE        AMOU | NT       AMOUNT | AMOUNT
Spreadsheet: 102825d1300770800-tracking-payroll-by-employees-first-name-help-groupexpayroll
Sheet: Shift Schedule

 | Empl.  Name | [NAME]
 | [NAME] | 44 | I actually would like to place this list on a separate page - which I believe I can do and use VLOOKUP?
 | [NAME] | 45
 | [NAME] | 40 |  |  |  | Assume: All employee names are unique and everyone works just one hour whenever his/her name is entered.
 | [NAME] | 52
 | Rosela | 35 |  |  |  | Which formulas do I use and where do I place these formulas?
 | Sharisse | 37 |  |  |  | This sum takes each employee's hourly rate and total is calculated.
 | [NAME] | 28
 | Weekly Payroll |  |  |  |  |  |  |  |  | For the Week of:
 |  |  |  |  |  |  |  |  |  | Department Name:
 | Monday
 |  | MORNING |  |  | MID-DAY |  |  | EVENING |  |  | TOTAL
 | Group Ex | [NAME] | Rosela |  |  | Sharisse |  | [NAME]
 | Cycling | [NAME]
 | Yoga |  |  |  |  |  |  | [NAME] | [NAME]
 | Mat Pilates | [NAME] |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Grand total
 | Tuesday
 |  | MORNING |  |  | MID-DAY |  |  | EVENING |  |  | TOTAL
 | Wednesday
 |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Thursday
 |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Friday
 |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Saturday
 |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Sunday
 |  |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 221446d1363554847-sum-and-cell-formatting-with-runtime-reach-songlist
Sheet: Ensemble

#reach
Song | [NAME] | Show | Performers | Time
There's a Land | [NAME] | Myths and Hymns | All | 3:26
Joy | [NAME] | - | All | 2:40
Therapy | [NAME] | tick, tick…BOOM! | [NAME], Lucas | 2:54
Louder than Words | [NAME] | tick, tick…BOOM! | [NAME], Lucas, Spence | 4:45
Spreadsheet: 0e30daf1-5d56-45c4-aa73-8c45f5a05b6e
Sheet: Budget 3 A-B

*ORGANIZATIONAL DUNS:
*Budget Type: |  | Project: |  | Subaward/Consortium:
*Name of Organization:
*Start Date: |  |  | *End Date: |  |  | *Budget Period: | 3
A.  Senior/Key Person
 | Prefix | *First Name |  | Middle Name |  | *Last Name | Suffix | *Project Role | Base Salary $ | Cal.  Months | Acad.   Months | Sum.    Months | *Requested Salary ($) | *Fringe             Benefits ($) | *Funds Requested ($)
1. |  |  |  |  |  |  |  | Principal Investigator | 0 |  |  |  | 0 | 0
2. |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
3. |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
4. |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
5. |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
6. |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
7. |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
8. |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
9. | Total Funds requested for all Senior Key Persons in the attached file. |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Senior/Key Person
Additional Senior Key Persons: |  |  |  |  | Attachments: | Yes |  | No
B. Other Personnel
*Number of Personnel |  | *Project Role |  |  |  |  |  |  |  | Cal.        Months | Acad.   Months | Sum.    Months | *Requested Salary ($) | *[NAME] ($) | *Funds Requested ($)
 |  | Post Doctoral Associates |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | Graduate Students |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | Undergraduate Students |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | Secretarial/Clerical |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | Total Number Other Personnel |  |  |  |  |  |  |  |  |  |  | Total Other Personnel
 |  |  |  |  |  |  |  |  |  | Total Salary, Wages and Fringe Benefits (A+B)
 | * Required Field
Spreadsheet: 695767d1600386243-writing-an-if-formula-or-other-formula-that-will-do-this-number-series-repeat-certain-numbers-in-sequence
Sheet: Sheet1

 |  |  | 0.5 |  | 0 | 0
 |  |  | 0.9