tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 121698d1316298723-weighted-conditional-value-sum-studentdata
Sheet: Sheet1

Student A |  |  |  |  | Achievment progress | Assesments | Points Possible | Points Earned | Standard percentage
State Standard
NS1 | Number forms/order
NS2 | Rounding to millions
Date | Event | Standard | Pts Possible | Points earned |  |  |  |  |  |  |  | See the below Pivot Table method for solving your problem.  You need to filter by NS
2011-09-08 00:00:00 | Quiz 1 pt 2 | NS2 | 9 | 5 |  |  |  |  |  |  |  | Standard | NS1
2011-09-07 00:00:00 | Quiz 1 pt 1 | NS1 | 19 | 13
2011-09-06 00:00:00 | Song | NS2 | 5 | 5 |  |  |  |  |  |  |  | Row Labels | Sum of Pts Possible | Sum of Points earned | Weight | Totals
2011-09-05 00:00:00 | Activity 2 | NS2 | 10 | 9 |  |  |  |  |  |  |  | 2011-09-07 00:00:00 | 19 | 13 | 0.3
2011-09-01 00:00:00 | 1-6 | NS1 | 16 | 8 |  |  |  |  |  |  |  | 2011-09-01 00:00:00 | 16 | 8 | 0.25
2011-08-31 00:00:00 | 1-5 | NS1 | 18 | 12 |  |  |  |  |  |  |  | 2011-08-31 00:00:00 | 18 | 12 | 0.2
2011-08-30 00:00:00 | Activity 1 | NS1 | 5 | 5 |  |  |  |  |  |  |  | 2011-08-30 00:00:00 | 5 | 5 | 0.15
2011-08-29 00:00:00 | 1-3 | NS1 | 11 | 10 |  |  |  |  |  |  |  | 2011-08-29 00:00:00 | 11 | 10 | 0.1
2011-08-29 00:00:00 | 1-4 | NS2 | 10 | 8 |  |  |  |  |  |  |  | 2011-08-25 00:00:00 | 13 | 10
2011-08-28 00:00:00 | 1-2 | NS2 | 15 | 13 |  |  |  |  |  |  |  | 2011-08-24 00:00:00 | 12 | 12
2011-08-25 00:00:00 | 1-1 | NS1 | 13 | 10 |  |  |  |  |  |  |  | 2011-08-23 00:00:00 | 10 | 10
2011-08-24 00:00:00 | [NAME] | NS1 | 12 | 12 |  |  |  |  |  |  |  | Grand Total | 104 | 80
2011-08-23 00:00:00 | [NAME] | NS1 | 10 | 10
Total
 |  |  |  |  |  | Another method would be by using an Advanced Filter
 |  |  |  |  |  | Date | Event | Standard | Pts Possible | Points earned |  | <<This is the Criteria of the Advanced Filter
 |  |  |  |  |  |  |  | NS1
 |  |  |  |  |  | Date | Event | Standard | Pts Possible | Points earned | Weight | Totals
 |  |  |  |  |  | 2011-09-07 00:00:00 | Quiz 1 pt 1 | NS1 | 19 | 13 | 0.3 |  | << This advanced [NAME] method needs to be sorted by date.
 |  |  |  |  |  | 2011-09-01 00:00:00 | 1-6 | NS1 | 16 | 8 | 0.25
 |  |  |  |  |  | 2011-08-31 00:00:00 | 1-5 | NS1 | 18 | 12 | 0.2
 |  |  |  |  |  | 2011-08-30 00:00:00 | Activity 1 | NS1 | 5 | 5 | 0.15
 |  |  |  |  |  | 2011-08-29 00:00:00 | 1-3 | NS1 | 11 | 10 | 0.1
 |  |  |  |  |  | 2011-08-25 00:00:00 | 1-1 | NS1 | 13 | 10
 |  |  |  |  |  | 2011-08-24 00:00:00 | [NAME] | NS1 | 12 | 12
 |  |  |  |  |  | 2011-08-23 00:00:00 | [NAME] | NS1 | 10 | 10
 |  |  | 1
Spreadsheet: 685989d1594305184-help-if-4-is-the-4th-character-replace-it-with-example
Sheet: Data

Code | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd
123456789123456178912
102510000600028060522
Spreadsheet: chris_germany__2129__FebCohCHOICE-ENA
Sheet: Feb 16

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-02-16 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | Upstream K# | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1075 |  | 1075 |  | 67694 |  |  |  |  |  |  | 28 | 1 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 2 | 30
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 7738 |  | 7738 |  | 67694 |  |  |  |  |  |  | 29 | 3 | 30
 |  |  |  |  |  |  |  |  | 3000 |  | 3000 |  | 68918 | 103722 | 0 |  |  |  |  | 32 | 4 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 5 | 33
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2553 |  | 2553 |  | 67694 |  |  |  |  |  |  | 31 | 6 | 31
 |  |  |  |  |  |  |  |  | 2000 |  | 2000 |  | 68915 | 103722 | 0 |  |  |  |  | 29 | 7 | 29
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69148 |  | 0 |  |  |  |  | 33 | 8 | 34
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0 |  |  |  |  | 32 | 9 | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 15 | 39
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 17294 |  | 16663 |  | 67694 |  |  |  |  |  |  | 34 | 35 | 34
 |  |  |  |  |  |  |  |  | 25 |  | 25 |  | 68917 | 103722 | 0 |  |  |  |  | 32 | 39 | 30
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 |  | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2044 |  | 1948 |  | 67694 |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1447 |  | 1600 |  | 67694 |  |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 68916 | 103722 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 13780 |  | 13184 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 3616 |  | 3616 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 3129 |  | 3015 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 5033 |  | 4751 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 924 |  | 924 |  | 67694
 |  |  |  |  |  |  |  |  | 257 |  | 257 |  | 69708 | 53858 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 53858 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 36 |  | 39 |  | 67694 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20146 | FOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86918 | 20596 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 126691d1319824508-easy-sum-concatenation-error-help-forumexample
Sheet: DataLink

Year
2001
2002
2003
Concatenation ColB
Concatenation ColC
 |  |  | [NAME]
 | [NAME] --> |  | SUM('2001'!A1,'2002'!A1,'2003'!A1)
 | Doesn’t Work ColB  --> |  | SUM(INDIRECT(B6))
 | Doesn’t Work ColC --> |  | SUM(INDIRECT(B7))
Spreadsheet: 485861d1477117179-find-trends-in-employee-data-example
Sheet: page 17

Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
3 3 |  | 23:01     6:41 | 22:00     6:00 |  |  | 6:55     16:14 | 6:55     15:04
 | 4:17     10:27 | 6:00     14:00 | 6:00     14:00 | 6:10     12:17 | 6:09     12:01
 | 6:00     15:00 | 6:00     15:00 |  |  | 14:00    22:00 | 22:25     7:17 | 22:55     6:32
 |  | 17:40     0:17 | 15:00    24:00 | 15:10    23:09
 |  | 6:00     15:00 | 6:00     15:00 |  | 13:25    23:32 | 14:00    22:00 | 12:25    21:47
 | 23:55     6:31 | 22:55     5:47 |  | 22:00     6:00
Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
3 4 |  | 22:55     6:32 | 22:25     6:17 |  |  | 5:57     15:53 | 7:27     14:54
 | 5:19     12:54 | 4:17     10:27 | 6:00     15:00 | 6:00     15:00 | 6:00     15:00
 | 13:39    20:47 |  |  | 15:02    21:49 | 12:05    21:47 | 14:00    23:00 | 22:00     6:00
 | 22:25     6:17 |  |  | 6:09     12:01 | 6:10     12:17
 |  | 7:00     16:00 | 6:00     16:00 |  | 14:50     0:01 | 22:00     6:00 | 22:31     6:11
 |  |  | 6:00     15:00 | 5:25     15:12 | 6:00     15:00
Spreadsheet: 92176d1291826176-need-to-divide-hours-evenly-between-multiple-fields-to-maintain-averages-solver_production_test3
Sheet: Sample

Sample
PRODUCT | Custom Built | Hours | CBPH |  | AVERAGE | keep as close as possible |  | Difference
Sedans & Coupes | 0 | 0 | 0 |  | 3.3 |  |  | 3.3
Sedans & Coupes & Assistance | 0 | 0 | 0 |  | 2.6 |  |  | 2.6
Sedans | 0 | 0 | 0 |  | 3.2 |  |  | 3.2
Cycle | 0 | 0 | 0 |  | 10 |  |  | 10
Coupes | 0 | 0 | 0 |  | 3.5 |  |  | 3.5
Assistance | N/A | 0 | 0 |  | 0.18 |  |  | 0.18
 | TOTAL HOURS | 0 |  |  |  |  |  | 22.78
 | Target total hrs | 4.75
This is a simpler and better setup of Solver.
I've added a helper column for the difference of the absolute values of "Average" - "CBPH2". The sum of
all this differences is in Cell I9 the new "Target Cell".
The driving force is for Solver to minimize the difference between "Average" and "CBPH" value
so "Equal To:" is set to "Min" and is no need to enter any number for "Value of:"
The "TOTAL HOURS" is now a constraint i.e. C9 = C11. But you have to set your
"Target hrs" in cell C11.
Since the "Target Cell" has a start value Solver will happily start working even if cells C5 to C8 have a
zero value at the start.
At the moment the Solver model contains a "Target Cell" (cell I9) set to "Min".
Cells C5 to C8 are the cells Solve can change but cell value must be zero or greater than zero.
And the sum of available hours (cell C9) must be equal to the value of cell C11.
Spreadsheet: 807164d1669783701-googlesheets-schedule-checker-2023-1st-semester-schedule-bundang
Sheet: ERIN

 | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | BOOKS/PREPS
 |  |  |  |  |  |  |  |  |  |  | 1st Grade |  |  |  | 4th Grade
 |  |  |  |  |  |  |  |  |  |  | 2nd Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5th Grade
 |  |  |  |  |  |  |  |  |  |  | 3rd Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6th Grade
 |  |  |  | . | _
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  | WRITING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | _ |  |  |  |  |  |  | . | _
 |  | . | _ |  |  | . | _
Spreadsheet: 140619d1328821171-inventory-yfeb-food-total-values
Sheet: 2-22-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 | Daily Total
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
Spreadsheet: 133255d1324309691-using-index-and-match-to-find-several-values-jc-multiplelargestmatches-data1_possible-solution
Sheet: Sheet1

First Name | Last Name | Student # |  | Clicker # |  | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 |  |  | Ready% |  | Visial Score | Auditory Score | Kinesthetic Score |  | Linguistic | [NAME] | Visual-Spatial | Kinesthetic | Music-Rhythmic | Naturalist | Interpersonal | Intrapersonal |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
First 1 | Last 1 | 21 | 1 | 1 |  | 1 | 2 | 1 | 1 | 2 | 3 | 1 | 2 | 1 | 1 | 2 | 3 | 1 | 1 | 2 | 2 | 1 | 2 | 3 | 2 | 1 | 1 | 3 | 3 | 2 | 2 | 1 | 2 | 1 | 2 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | D | A | B | D | A | A | B | A | A | B | A | A | B | A | A | B | A | B | A | B | A | B | B | B | A | A | A | B | A | A | A | A | A | B | A | A | B | B | A | A | B | A | B | A | B |  | 1.666666666666667 | 0.4444444444444444 |  | 4 | 8 | 4 |  | 3 | 4 | 4 | 3 | 5 | 3 | 2 | 2
First 2 | Last 2 | 22 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | D | A | D | A | A | A | A | B | B |  | A | A | A | A | A | B | A | A | A | A | B |  | A | A | B | A | B | A | B | B | A | B | B | A | A | B | A | B | B | A | A | B | B |  |  |  |  | 0 | 0 | 0 |  | 2 | 2 | 4 | 3 | 3 | 2 | 5 | 2
First 3 | Last 3 | 23 | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 2 | 1 | 1 | 2 | 2 | 2 | 1 | 1 | 2 | 2 | 1 | 2 | 2 | 3 | 3 | 3 | 2 | 1 | 2 | 2 | 1 | 3 | 2 | 2 | 3 | 2 | 1 | 2 | 3 | A | C | A | B | A | B | A | A | B | A | B |  | A | A | B | A | A | A | B | A | A | A | B | A | B | A | A | A | B | A | A | B | A | A | A | A | A | A | A | A | B | B | A | A | A |  | 1.476190476190476 | 0.5079365079365079 |  | 3 | 7 | 6 |  | 4 | 3 | 3 | 2 | 4 | 5 | 4 | 3
First 4 | Last 4 | 24 | 1 | 4 |  | 2 | 2 | 2 | 3 | 2 | 1 | 3 | 2 | 3 | 1 | 1 | 2 | 2 | 1 | 2 | 1 | 2 | 3 | 2 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | A | A | A | A | A | A | A | A | B | B | A | A | A | A | A | B | B | A | A | B | A | A | B | A | A | A | A | A | A | B | B | B | B | A | A | A | B | A | A | B | B | A | A | B | A |  | 1.952380952380952 | 0.3492063492063492 |  | 0 | 1 | 15 |  | 3 | 3 | 5 | 3 | 4 | 2 | 4 | 2
Spreadsheet: 686400d1594589506-index-indirect-function-need-help-inventory
Sheet: DailyTransactions

Transaction | Trans_Item | Trans_Qty | Trans_Category | WeekDay | Trans_Sold | Trans_Delivered
 |  |  | Food | Fri
 |  | Trans_Sold
 | Sum
 | Average
Transaction | Trans_Item | Trans_Qty | Trans_Category | WeekDay | Trans_Sold | Trans_Delivered
1 | A1 | -14 | Food | Mon
2 | A3 | 5 | Food | Mon
3 | A5 | -7 | Golf | Wed
4 | A3 | -14 | Food | Thur
5 | A6 | -15 | Massage | Fri
6 | A3 | -16 | Food | Fri
7 | A1 | -7 | Food | Fri
8 | A2 | -10 | Clothing | Fri
9 | A7 | -4 | Clothing | Sat
10 | A19 | -2 | Golf | Sun
11 | A1 | 15 | Food | Thur
12 | A10 | -18 | Massage | Mon
13 | A1 | -6 | Food | Wed
14 | A8 | -6 | Clothing | Thur
15 | A2 | -13 | Clothing | Fri
16 | A1 | -2 | Food | Fri
17 | A3 | -17 | Food | Sat
18 | A15 | -8 | Clothing | Sat
19 | A13 | 5 | Golf | Mon
20 | A14 | -11 | Novelty | Mon
21 | A4 | -4 | Reading | Mon
22 | A9 | 0 | Golf | [NAME]
23 | A5 | -18 | Golf | Wed
24 | A15 | -6 | Clothing | Wed
25 | A17 | -4 | Novelty | Thur
26 | A9 | -18 | Golf | Thur
27 | A14 | -13 | Novelty | Thur
28 | A17 | -15 | Novelty | Fri
29 | A18 | -14 | Reading | Fri
30 | A7 | -9 | Clothing | Sat
Spreadsheet: 804355d1668013711-sumifs-until-a-new-date-is-found-example-workbook
Sheet: Sheet1

Year | 2021
Month | Expected Salary Value Totals | Attempted Formula | Comment on [NAME] | Comment for [NAME] requirement
2021-01-01 00:00:00 |  |  | As expected | Summing up all values for employees where effective date is before end of January |  | Lookup Table
2021-02-01 00:00:00 |  |  | As expected | Summing up all values for employees where effective date is before end of February (still taking January values) |  | Employee | Effective Date | [NAME]
2021-03-01 00:00:00 |  |  | As expected | Summing up all values for employees where effective date is before end of March (still taking January values) |  | Employee 1 | 2021-01-01 00:00:00 | 30000
2021-04-01 00:00:00 |  |  | As expected | Summing up all values for employees where effective date is before end of April (still taking January values) |  | Employee 1 | 2021-07-01 00:00:00 | 35000
2021-05-01 00:00:00 |  |  | As expected | Summing up all values for employees where effective date is before end of May (still taking January values) |  | Employee 2 | 2021-01-01 00:00:00 | 40000
2021-06-01 00:00:00 |  |  | As expected | Summing up all values for employees where effective date is before end of June (still taking January values) |  | Employee 2 | 2021-07-01 00:00:00 | 50000
2021-07-01 00:00:00 |  |  | Doubles up to include the values prior to July (January + July) | Summing up all values for employees where effective date is before end of July (now taking new July values) |  | Employee 2 | 2021-09-01 00:00:00 | 60000
2021-08-01 00:00:00 |  |  | Doubles up to include the values prior to August (January + July) | Summing up all values for employees where effective date is before end of August (now taking new July values) |  | Employee 3 | 2021-01-01 00:00:00 | 60000
2021-09-01 00:00:00 |  |  | Doubles up to include the values prior to September (January + July + September) | Summing up all values for employees where effective date is before end of September (now taking new July values for Employee 1 and 3 and new September value for Employee 2) |  | Employee 3 | 2021-07-01 00:00:00 | 63000
2021-10-01 00:00:00 |  |  | Doubles up to include the values prior to October (January + July + September) | Summing up all values for employees where effective date is before end of October (now taking new July values for Employee 1 and 3 and September value for Employee 2)
2021-11-01 00:00:00 |  |  | Doubles up to include the values prior to November (January + July + September) | Summing up all values for employees where effective date is before end of November (now taking new July values for Employee 1 and 3 and September value for Employee 2)
2021-12-01 00:00:00 |  |  | Doubles up to include the values prior to December (January + July + September) | Summing up all values for employees where effective date is before end of December (now taking new July values for Employee 1 and 3 and September value for Employee 2)
Spreadsheet: 168779d1342575014-count-occurances-when-value-appears-3-times-count-consecutive
Sheet: Sheet1

1 |  | 4 |  | 1 |  |  |  |  | LOOK BELOW RED COLOR
4 |  | 4 |  | 4 |  | <-- not consecutive , not counted
4 |  | 1 |  | 2
4 |  | 2 |  | 3
6 |  | 4 |  | 4
4 |  | 4 |  | 5
4 |  | 4 |  | 6
4 |  | 1 |  | 4
1 |  | 2 |  | 4
5 |  | 4
4 |  | 4
4 |  | 4
4 |  | 4
4 |  | 1
2 |  | 4
1 |  | 4
2 |  | 4
4 |  | 4
4 |  | 4
4 |  | 1
 |  |  |  |  |  |  |  |  | just drag the formula --->>>to the right
Spreadsheet: 127455d1320353031-excel-2007-how-do-i-add-positive-numbers-and-subtract-any-negative-version-of-those-numbers-book3
Sheet: Sheet1

3 OF PURCHASES OCT 1 - 4
 | 2011-10-01 00:00:00 | 2011-10-02 00:00:00 | 2011-10-03 00:00:00 | 2011-10-04 00:00:00 |  | MY FORMULA |  | SHOULD BE
Customer A | 1 |  | -1 | 1 |  |  |  | 1
Customer B | 2 | -1 |  |  |  |  |  | 1
Customer C | 1 | -0.5 |  | 1 |  |  |  | 2
Customer D | 3 | -1 | 1 | -1 |  |  |  | 1
Spreadsheet: 831628d1685783959-project-and-keywords-problem-solving-projects-keywords-pb-1-
Sheet: Expected-results

Mot-clef \ Projet | 1. DEPth | 2. LatexDry | 3. LIPIDIC_PURGE | 4. MISSION | 5. PESTIPOND | 6. POLYGLOT | 7. Pristine | 8. ReinitiaTOR | 9. SOFTACTION | 10. SynPPR | 11. BODYTEG | 12. [NAME] | 13. CORELMAG | 14. C-Sil | 15. Digital-LbL | 16. EVOBAR | 17. GOT | 18. LipidTrans4NeuroTraffic | 19. LUCAS | 20. MESAMM | 21. [NAME] | 22. NetOnTime | 23. PA-Box | 24. POPSYCLE | 25. SignOp | 26. [NAME] | 27. URBANTIT | u01. [NAME] | u02. DInnAMICS | u03. BattAllox | u04. [NAME] | u05. N-FLAMS | u06. PSLM | u07. InsuRAF | u08. GIGA | u09. LeBHel-Amzymes | u10. [NAME] | u11. SPERRY | u12. [NAME] | u13. BrightSwitch | u14. QDDA | u15. SP-Fluo | u16. [NAME] | u17. AFINITE | u18. TROC | u19. [NAME] | u20. nano-NET | u21. NanoLys | u22. BioconjUgi | u23. [NAME] | u24. MethAmAbs
1. DEPth
2. LatexDry
3. LIPIDIC_PURGE
4. MISSION
5. PESTIPOND
6. POLYGLOT
7. Pristine
8. ReinitiaTOR
9. SOFTACTION
10. SynPPR
11. BODYTEG
12. [NAME]
13. CORELMAG
14. C-Sil
15. Digital-LbL
16. EVOBAR
17. GOT
18. LipidTrans4NeuroTraffic
19. LUCAS
20. MESAMM
21. [NAME]
22. NetOnTime
23. PA-Box
24. POPSYCLE
25. SignOp
26. [NAME]
27. URBANTIT
u01. [NAME]
u02. DInnAMICS
u03. BattAllox
u04. [NAME]
u05. N-FLAMS
u06. PSLM
u07. InsuRAF
u08. GIGA
u09. LeBHel-Amzymes
u10. [NAME]
u11. SPERRY
u12. [NAME]
u13. BrightSwitch
u14. QDDA
u15. SP-Fluo
u16. [NAME]
u17. AFINITE
u18. TROC
u19. [NAME]
u20. nano-NET
u21. NanoLys
u22. BioconjUgi
u23. [NAME]
u24. MethAmAbs
Spreadsheet: 06f0ff32-c629-46d2-a8ab-a78a475329ff
Sheet: Sheet1

Unnamed: 0 | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12 Noon
12:30:00
01:00:00
01:30:00
02:00:00
02:30:00
03:00:00
03:30:00
04:00:00
04:30:00
05:00:00
05:30:00
06:00:00
06:30:00
07:00:00
07:30:00
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
Spreadsheet: 79966d1280226160-auto-fill-date-time-ticket-log
Sheet: Lookup

Employee Name | Department | Status | Request Type | IT Personnel | Priority
Abundancia, [NAME] | [NAME] | Done | Connection Problem | Alden Talan | YES
[NAME], [NAME] | Counts Group - Amail | Pending | Hardware & Software Problem | Cheloudem Macion | NO
Apaitan, [NAME] | Counts Group | Request Denied | [NAME] | [NAME]
Aquino , [NAME] | DHPOC |  | Installation | [NAME]
Austria, [NAME]. Bianca | Counts Group - Datapharm |  | [NAME]
[NAME], [NAME] | Counts Group |  | Technical question
Bantilles, [NAME] | Counts Group
[NAME], [NAME] | Counts Group - Datapharm
[NAME], [NAME] | Business Intelligence
Beloy, Liezel | Counts Group
Bernardo, [NAME] | Data Services
[NAME], [NAME] | DHPOC
Cababat, [NAME] | Data Services
Cabarios, [NAME] | [NAME]
Camarines, [NAME] | Counts Group
Caratao, Agnes | Counts Group - Datapharm
Carrascal, Edzel | DHPOC
Castañares, Marife | Counts Group - Amail
Corpuz, [NAME] | Counts Group - Datapharm
Crespo, [NAME] | [NAME]
Cruz, [NAME].Victoria | Counts Group - Amail
[NAME] , Wilma | Counts Group - Datapharm
[NAME], [NAME] | Counts Group
[NAME], [NAME] | Counts Group - Amail
Dimaranan, Rena | Data Services
Dioquino II, [NAME] | Data Services
Egonio, Loraine | Data Services
Espina, Maricris | Data Services
[NAME], Edric | Counts Group - Datapharm
Evidente, [NAME] | Counts Group
Fermindoza, [NAME] | Counts Group - Amail
Gaetos, Maricel | DHPOC
Gamboa , [NAME] | Counts Group
[NAME], [NAME] | Counts Group - Datapharm
[NAME], Danilo | Data Services
[NAME], [NAME] | TECH
Hostallero, [NAME] | Counts Group
[NAME], [NAME] | Special Project
[NAME], [NAME] | Counts Group
[NAME], [NAME] | Counts Group
Leonida, [NAME] | Counts Group
Letargo, May Anne | Counts Group
Loslos, Noriel | Data Services
Macion, Cheloudem | TECH
Magtangob, [NAME] | Counts Group
Mata, Jayemil | Data Services
Mendoza, [NAME] | Data Services
Mercado, Liberty | Business Intelligence
[NAME], [NAME] | [NAME]
Mores, [NAME] | Counts Group
Navarro, [NAME] | Data Services
Noche, [NAME] | Counts Group
Nuqui, Rodel | Counts Group
Pagsiat, [NAME] | Data Services
Pascua, [NAME] | Counts Group
Patrocinio, [NAME] | Counts Group - Datapharm
Paule, J.C. Rally | Counts Group
Pepito, Ceresa | Data Services
Pineda, [NAME] | Data Services
[NAME], [NAME] | Data Services
Princess [NAME], [NAME] | Counts Group
[NAME], Ana Rosemi | DHPOC
Rolluqui, Roselle | Counts Group
[NAME], [NAME] | TECH
Salcedo, [NAME] | Counts Group - Datapharm
Sanchez, [NAME] | Data Services
Santos , [NAME] | MIS
Santos , [NAME] | Counts Group
Sas, Jethro | Data Services
Sia, Franco | Counts Group
Sureta, [NAME] | Special Project
Tadoy, Emily | Counts Group
Talan, Alden | TECH
[NAME], [NAME] | TECH/Special
Tianzon, [NAME] | MIS
Tibay, Cherubim | DHPOC
Tolentino, Ivy | Counts Group
Torres, [NAME] | DHPOC
Valerio, [NAME] | Counts Group
Villanueva, [NAME] | Counts Group
Villarma, [NAME] | Counts Group
[NAME], [NAME] | Counts Group
Wycoco, Florisse | ADMIN
[NAME], [NAME] | Counts Group
Spreadsheet: 91873d1291574023-how-do-i-accomplish-variable-date-controlled-summation-of-data-attendance-book-forum-sample
Sheet: Summ

 | Marking Period |  |  |  |  |  |  |  |  |  | Marking Period |  |  |  |  |  |  |  |  |  | Marking Period
Students: | 1 |  |  | 2 |  |  | 3 |  |  |  | 1 |  |  | 2 |  |  | 3 |  |  |  | 1 |  |  | 2 |  |  | 3
K | A | L | Le | A | L | Le | A | L | Le | First | A | L | Le | A | L | Le | A | L | Le | 2nd | A | L | Le | A | L | Le | A | L | Le
Marking Periods
Start | 2010-08-15 00:00:00
End 1 | 2010-11-01 00:00:00
End 2 | 2011-01-01 00:00:00
End 3 | 2011-06-20 00:00:00