tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 773844d1648065804-rolling-calendar-year-attendance-cattendance-tracker
Sheet: Attendance Points Guidelines

Infraction | Definition | Points
Tardy | Employee clocks-in more than 7 minutes after scheduled  shift start time without manager’s prior approval. shift start time without manager’s prior approval. | 0.5
Early Departure | Employee clocks-in more than 5 minutes before scheduled Employee clocks-out or leaves shift any time prior to scheduled shift end time. Exceptions made if released early by a manager, or if employee informs a manager of an emergency that requires  them to leave early and is approved to do so by manager.shift start time without manager’s prior approval. | 0.5
Late Return from Break | Employee takes an approved break and returns 30 minutes  or later to the return of their shift. | 0.5
Absent - Prior Notification Weekday (Mon-Fri) | Employee is unable to work scheduled weekday shift and notifies manager at least 2 hours prior to the scheduled shift start time.  Exception is made if a replacement is found by the employee to cover the shift, given that the employee covering will not be in overtime.  Acceptable means of notification: Call or text | 1
Absent - Prior Notification Weekend (Sat-Sun) or Holiday | Employee is unable to work scheduled weekend or holiday shift and notifies manager at least 2 hours prior to the scheduled shift start time.  Exception is made if a replacement is found by the employee to cover  the shift, given that the employee covering will not be in overtime.  Acceptable means of notification: Call or text shift start time without manager’s prior approval. | 2
Absent – No/Late Notification | Employee is unable to work scheduled shift  and does not notify manager at least 2 hours prior to  the scheduled shift start time.  This is defined as being a No Call/ No Show,  and is subject to termination. | 6
Occurance | Points
Tardy (after 7 min window) | 0.5
Early Departure (leaves before shift ends) | 0.5
Late Return from Break (after 30 min break window) | 0.5
Absent – Prior Notification (2hrs prior, Weekday Mon-Fri) | 1
Absent – Prior Notification (2hrs prior, Weekend Sat-Sun) | 2
Absent – No/Late Notification | 6
 |  |  |  | Corrective Action Level | Point Accrual Rolling 12 Months
 |  |  |  | Coaching w/ Manager | 2
 |  |  |  | Verbal warning (documented) | 4
 |  |  |  | Written warning (documented) | 6
 |  |  |  | Subject to Termination | 8
Spreadsheet: 874918d1721424975-how-to-return-result-based-on-two-columns-book2
Sheet: Sheet1

Status of rooms
Rooms | Status
[NAME] | Online
BR55 | Offline
BR60 | Offline
HH10 | Online
Data
Room | Server # | Status
[NAME] | 1 | Online
[NAME] | 2 | Online
[NAME] | 4 | Online
[NAME] | 6 | Online
[NAME] | 8 | Online
BR55 | 5 | Offline
BR55 | 3 | Online
BR55 | 7 | Online
BR60 | 13 | Offline
BR60 | 9 | Online
BR60 | 17 | Online
HH10 | 10 | Online
HH10 | 12 | Online
HH10 | 14 | Online
HH10 | 16 | Online
HH10 | 18 | Online
Spreadsheet: 95429d1295020065-return-multiple-results-for-hlookup-client-example
Sheet: Sheet1

Distro Center | ID # |  | Client #s | 340 | 341 | 344 | 345 | 346 | 347 | 348 | 349 | 350 | 351
1 | 123 |  |  | X | X | 1 | 1 | 1 | 1 | X | X | X | X
2 | 223 |  |  | X | X | 1 | X | 1 | 1 | 1 | X | X | X
3 | 323 |  |  | X | 1 | X | X | 1 | X | X | X | X | X
4 | 423 |  |  | X | X | X | X | 1 | 1 | 1 | X | X | X
5 | 523 |  |  | X | X | 1 | 1 | 1 | 1 | 1 | X | X | X
6 | 623 |  |  | X | X | X | X | 1 | 1 | 1 | X | X | X
7 | 723 |  |  | X | 1 | X | X | X | X | X | X | X | X
8 | 823 |  |  | X | X | X | X | 1 | X | 1 | X | X | X
9 | 923 |  |  | X | 1 | X | X | X | X | X | X | X | X
10 | 124 |  |  | X | X | X | X | 1 | 1 | 1 | X | X | X
Spreadsheet: 9fd3dd05-a3c3-4b06-b886-fcdbc92f0782
Sheet: 2.1

 | Cuadro 2.1
 | [NAME]
 | Defunciones ocurridas, por sexo, según [NAME], 2010
 | [NAME] | Total | Sexo
 |  |  | Hombre | Mujer | [NAME]
 | Total país
 | Enero |  | 1893 | 1067 | 1
 | Febrero |  | 2117 | 1140 | 3
 | Marzo |  | 2166 | 1177 | 6
 | Abril |  | 1822 | 958 | 3
 | Mayo |  | 1765 | 1001 | 2
 | [NAME] |  | 1747 | 1002 | 4
 | [NAME] |  | 1987 | 1225 | 1
 | [NAME] |  | 1662 | 1115 | 0
 | Septiembre |  | 1592 | 959 | 1
 | Octubre |  | 1645 | 1014 | 2
 | Noviembre |  | 1600 | 956 | 2
 | Diciembre |  | 1598 | 906 | 0
 | No especificada |  | 10 | 8 | 0
 | Nota: Elaborado con datos registrados en las Oficialías del Estado Civil. Junta Central Electoral
 | Fuente: Oficina Nacional de Estadística, (ONE)
Spreadsheet: 680718d1591155704-need-a-formula-to-pull-data-from-another-sheets-chart-based-off-age-and-gender-pt-testing-spreadsheet
Sheet: Female Pushup

Percent | 20-29 | 30-34 | 35-39 | 40-44 | 45-49 | 50-54 | 55-59 | 60+
99 | 71 | 57 | 59 | 61 | 51 | 32 | 26 | 21
95 | 45 | 39 | 36 | 33 | 30 | 28 | 24 | 20
90 | 42 | 36 | 32 | 28 | 26 | 25 | 21 | 17
85 | 39 | 33 | 29 | 26 | 24 | 23 | 19 | 15
80 | 36 | 31 | 27 | 24 | 22 | 21 | 18 | 14
75 | 34 | 29 | 25 | 21 | 21 | 20 | 17 | 13
70 | 32 | 28 | 24 | 20 | 20 | 19 | 16 | 12
65 | 31 | 26 | 22 | 19 | 19 | 18 | 15 | 11
60 | 30 | 24 | 21 | 18 | 18 | 17 | 14 | 10
55 | 29 | 23 | 20 | 17 | 16 | 15 | 13 | 9
50 | 26 | 21 | 18 | 15 | 14 | 13 | 10 | 8
45 | 25 | 20 | 17 | 14 | 13 | 12 | 9 | 6
40 | 23 | 19 | 16 | 13 | 12 | 11 | 8 | 5
35 | 22 | 17 | 14 | 11 | 11 | 10 | 7 | 4
30 | 20 | 15 | 12 | 10 | 10 | 9 | 6 | 3
25 | 19 | 14 | 11 | 9 | 9 | 8 | 5 | 2
20 | 17 | 11 | 8 | 6 | 6 | 6 | 4 | 2
15 | 15 | 9 | 6 | 4 | 4 | 4 | 2 | 1
10 | 12 | 8 | 5 | 2 | 2 | 1 | 1 | 0
5 | 9 | 4 | 2 | 1 | 1 | 0 | 0 | 0
1 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 37129d1235070612-pivot-table-and-chart-see-workbook-county-tender-register-rev-1
Sheet: Pivot Table & Chart

Client | (All)
Estimator | (All)
 | Values
Date Submitted | Sum of Enquiry No. | Sum of Tender Sum £ | Sum of Winning Tender £ | Sum of Variance £ | Sum of Variance %
2008-10-20 00:00:00 | 23000 | 56000 | 55000 | 1000 | 0.01785714285714286
2008-11-01 00:00:00 | 23070 | 18500 | 15665 | 2835 | 0.1532432432432432
2008-11-05 00:00:00 | 23003 | 125995 | 118990 | 7005 | 0.05559744434302948
2008-12-20 00:00:00 | 24300 | 206667 | 178000 | 28667 | 0.1387110665950539
2009-01-10 00:00:00 | 24444 | 323001 | 323001 | 0 | 0
2009-02-18 00:00:00 | 25002 | 185005 | 185005 | 0 | 0
Grand Total | 142819 | 915168 | 875661 | 39507 | 0.3654088970384695
Spreadsheet: 830028d1684652152-updating-a-cell-based-on-current-date-test
Sheet: Sheet1

 |  |  | YEAR | 2023-04-01 00:00:00
2023-12-01 00:00:00
abc
 |  |  |  |  |  |  | -3614 |  |  | -3614 |  |  |  | desired result when A2 is 1=dec -23
 |  |  |  |  |  |  | -3614 |  |  |  |  |  |  | when A2 is 1-sep 23.
Spreadsheet: 72190d1272904158-variance-calculation-and-analysis-variance
Sheet: Sheet1

[NAME] | ABC Score | Percentage Variance | Statistical Variance
0.625 | 0.5454545454545454 | -12.72727272727273 | 0.003163739669421406
0.63 | 0.7272727272727273 | 15.44011544011544 | 0.004730991735537038
0.63 | 0.8181818181818182 | 29.87012987012988 | 0.01770619834710763
0.63 | 0.7272727272727273 | 15.44011544011544 | 0.004730991735537038
0.625 | 0.75 | 20 | 0.0078125
0.625 | 0.54 | -13.6 | 0.003612500000000018
0.625 | 0.63 | 0.8000000000000007 | 1.250000000019291e-05
0.625 | 0.58 | -7.200000000000006 | 0.001012499999999972
0.625 | 0.75 | 20 | 0.0078125
0.625 | 0.625 | 0 | 0
0.5833 | 0.6153846153846154 | 5.500534096453862 | 0.0005147112721894942
0.5833 | 0.69 | 18.29247385564888 | 0.005692445000000101
0.5833 | 0.6538461538461539 | 12.09431747748222 | 0.002488379911242622
0.625 | 0.6538461538461539 | 4.615384615384617 | 0.0004160502958581169
0.625 | 0.64 | 2.400000000000002 | 0.0001124999999998488
0.625 | 0.65 | 4.000000000000004 | 0.0003125000000001599
0.5833 | 0.6923076923076923 | 18.68810085851058 | 0.005941338491124104
0.5833 | 0.6923076923076923 | 18.68810085851058 | 0.005941338491124104
0.5833 | 0.625 | 7.148979941710948 | 0.0008694450000001908
0.625 | 0.67 | 7.200000000000006 | 0.001012500000000194
0.625 | 0.6666666666666666 | 6.666666666666661 | 0.0008680555555556912
0.5833 | 0.5833333333333334 | 0.005714612263557288 | 5.555556015224283e-10
Spreadsheet: 788873d1658771023-calculate-rent-with-annual-cpi-linked-escalation-5-yearly-review-cap-and-collar-adjustment-illustration-indexation-rent-review-with-cap-and-collar-1
Sheet: Sheet1

 | MODEL ASSUMPTIONS
 | Cashflow frequency | Quarterly
 | Periods per year | 4
 | RENTAL GROWTH  ASSUMPTIONS |  | 2023 | 2024 | 2025 | 2026 | 2027 | Note: The model will apply the last input in perpetuity
 | CPI |  | 0.05 | 0.05 | 0.005 | 0.02 | 0.02
 | LEASE ASSUMPTIONS |  | Term Start | Term End | Base Rent £[NAME]. | Rental Growth Type | Rent Review Frequency (No. of years) | Next Rent Review Date | Growth Collar | Growth [NAME]
 | Tenant 1 |  | 2023-01-01 00:00:00 | 2043-12-31 00:00:00 | 120000 | CPI | 5 | 2028-01-01 00:00:00 | 0.01 | 0.04
 | CASHFLOW: |  | Period Start
 |  |  | Period End |  | 2022-12-31 00:00:00
 |  |  | Period |  |  | 1
 |  |  | Calendar Year
 | Rental Growth Indexation
 | CPI |  |  |  | 1
 | Review Flags | Next Review (date) | Next Review (model period) | [NAME]
 | Tenant 1
 | Indexed Rent | Base Rent  £ per year | Base Rent  £ per period
 | Tenant 1
 | Escalated Rent  (pre-COLLAR AND CAP) | Term Start (date) | Term Start (model period)
 | Tenant 1
 | Adopted Rent (post-COLLAR AND CAP) | Growth Collar (Annual) | Growth [NAME] (Annual)
 | Tenant 1
 |  |  |  |  |  | ^ INPUT REQUIRED IN YELLOW CELLS
Spreadsheet: e567de58-c2ca-4f34-a979-ed4bdcda35c8
Sheet: Sheet1

 | Phenotype | External stimuli to induce | Upregulation | Downregulation
 | Th1 | eIFNγ | IFNγ | IL-4
 |  | eIL-12 | STAT1-P | GATA3-P
 |  | eIL-18 | Tbet-P | IL-17
 |  | αIL-4 | IL-12 | aFOXP3
 |  |  | IL-18 | STAT3-P
 |  |  | IRAK1-P | STAT6-P
 |  |  |  | RORγt
 | Th2 | eIL-4 | IL-4 | IL-17
 |  | αIFNγ | GATA3-P | aFOXP3
 |  |  | STAT6-P | STAT3-P
 |  |  |  | STAT1-P
 |  |  |  | IFNγ
 |  |  |  | Tbet-P
 |  |  |  | IRAK1-P
 |  |  |  | IL-18
 |  |  |  | IL-12
 |  |  |  | RORγt
 | Th17 | eIL-6 | IL-17 | aFOXP3
 |  | eTGF-β | RORγt | STAT1-P
 |  |  | STAT3-P | IFNγ
 |  |  | IL6 | Tbet-P
 |  |  | TGFβ | GATA3-P
 |  |  |  | IL-4
 |  |  |  | STAT6-P
 |  |  |  | IL-12
 |  |  |  | IL-18
 | [NAME] | eTGF-β | aFOXP3 | IL-17
 |  | IL-2 | TGF-β | RORγt
 |  |  |  | STAT3-P
 |  |  |  | STAT6-P
 |  |  |  | GATA3-P
 |  |  |  | IL-4
 |  |  |  | IFNγ
 |  |  |  | Tbet-P
 |  |  |  | STAT1-P
 |  |  |  | IL-12
 |  |  |  | IL-18
Spreadsheet: 199352d1355190488-find-last-previous-non-blank-value-and-summarise-previous-6-months-forum-sample
Sheet: Spend (1)

2011-12-25 00:00:00 | 2012-01-01 00:00:00 | 2012-01-08 00:00:00 | 2012-01-15 00:00:00 | 2012-01-22 00:00:00 | 2012-01-29 00:00:00 | 2012-02-05 00:00:00 | 2012-02-12 00:00:00 | 2012-02-19 00:00:00 | 2012-02-26 00:00:00 | 2012-03-04 00:00:00 | 2012-03-11 00:00:00 | 2012-03-18 00:00:00 | 2012-03-25 00:00:00 | 2012-04-01 00:00:00 | 2012-04-08 00:00:00 | 2012-04-15 00:00:00 | 2012-04-22 00:00:00 | 2012-04-29 00:00:00 | 2012-05-06 00:00:00 | 2012-05-13 00:00:00 | 2012-05-20 00:00:00 | 2012-05-27 00:00:00 | 2012-06-03 00:00:00 | 2012-06-10 00:00:00 | 2012-06-17 00:00:00 | 2012-06-24 00:00:00 | 2012-07-01 00:00:00 | 2012-07-08 00:00:00 | 2012-07-15 00:00:00 | 2012-07-22 00:00:00 | 2012-07-29 00:00:00 | 2012-08-05 00:00:00 | 2012-08-12 00:00:00 | 2012-08-19 00:00:00 | 2012-08-26 00:00:00 | 2012-09-02 00:00:00 | 2012-09-09 00:00:00 | 2012-09-16 00:00:00 | 2012-09-23 00:00:00 | 2012-09-30 00:00:00 | 2012-10-07 00:00:00 | 2012-10-14 00:00:00 | 2012-10-21 00:00:00 | 2012-10-28 00:00:00 | 2012-11-04 00:00:00 | 2012-11-11 00:00:00 | 2012-11-18 00:00:00 | 2012-11-25 00:00:00 | 2012-12-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 750
 |  |  |  |  |  |  |  |  |  |  | 8000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2250
 |  |  |  |  |  |  |  |  |  |  |  | 1500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6500 | 4500 | 10000 | 5000 | 5000 | 5000
 |  |  |  |  |  |  |  |  |  |  |  |  | 17100.72 | 19656
 |  |  |  |  |  |  |  |  | 78973.44 | 31493.28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23138.53 |  |  |  |  |  | 11653.82 | 8037.12 | 6464.64 |  |  | 6464.64 | 18740.37 | 38675.84 | 26823.89 | 20911.36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14448 | 2653.36 | 14447.36 | 2653.36 |  | 8551 |  | 16551 | 8550.36 | 8550.36 |  |  | 9828 | 6464.64 | 21206.64 | 22058.4 |  |  | 8550.36 | 14250.6 | 5896.8 |  |  | 15654.6 | 9272.64
7847.66 | 7847.66 | 5661.36 | 11009.2 |  |  | 10736.45 | 16734.03 | 12653.36 | 11547.27 | 11144.12 |  | 13430.81 | 13430.81 | 2653.36 |  |  |  | 8083.09 | 8083.09 | 11210.94 | 10659.17 | 15655.08 | 9371.130000000001 | 11797.85 | 11630.39 | 8083.09
Spreadsheet: 878558d1725643626-populate-list-of-data-from-data-set-that-meets-conditions-sample-data
Sheet: Sheet1

 | Data
 |  | Tenant | At Expiration
 |  | Amazon | Market
 |  | Google | Vacate
 |  | Netflix | Reabsorb
 |  | Microsoft | Market
 |  | Walmart | Vacate
 |  | [NAME]'s | Reabsorb
 |  | Home Depot | Market
 |  | Apple | Market
 |  | Nvidia | Vacate
 |  | Exxon | Vacate
 |  |  |  |  |  |  | <have this auto populate as data changes
Spreadsheet: 888654d1739222071-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 30

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Thu 14 Dec Glucose mmol/L
 |  |  |  |  |  | 5.9
Fri 15 Dec Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sat 16 Dec Glucose mmol/L
 |  |  |  |  | 5.8
Sun 17 Dec Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Mon 18 Dec Glucose mmol/L
 |  |  |  |  | 4.1 4.1 |  |  |  |  |  |  |  |  |  |  |  |  | 6.9 |  | 7 | 6.9
Tue 19 Dec Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Wed 20 Dec Glucose mmol/L
 |  |  |  |  |  |  | 7.1
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Thu 21 Dec Glucose mmol/L
Spreadsheet: 762871d1641883034-function-to-help-determine-honor-roll-honor-roll-example
Sheet: Sheet1

Student ID | Student Grade | Course Name | Percentage | Letter Grade | Honor Roll/High Honor Roll
12345 | 9 | English | 0.95 | A
12345 | 9 | Math | 0.85 | B
12345 | 9 | Science | 0.95 | A
12345 | 9 | History | 0.86 | B
12345 | 9 | Elective | 0.91 | A
12345 | 9 | Foereign Language | 0.92 | A
43251 | 10 | English | 0.72 | C
43251 | 10 | Math | 0.95 | A
43251 | 10 | Science | 0.82 | B
43251 | 10 | History | 0.92 | A
43251 | 10 | Elective | 0.78 | C
43251 | 10 | Foereign Language | 0.92 | A
77253 | 9 | English | 1 | A
77253 | 9 | Math | 1 | A
77253 | 9 | Science | 1 | A
77253 | 9 | History | 1 | A
77253 | 9 | Elective | 1 | A
77253 | 9 | Foereign Language | 1 | A
Spreadsheet: 120511d1315339762-sumproduct-formula-between
Sheet: Лист1

6 | 3
12 | 2
60 | 2
46 | 1
18 | 2
52 | 3
83 | 2
7 | 2
22 | 2
49 | 1
65 | 2
30 | 2
41 | 3
63 | 2
63 | 2
3 | 1
53 | 1
76 | 1
3 | 2
21 | 1
62 | 3
31 | 1
80 | 1
38 | 1
88 | 2
99 | 3
0 | 3
51 | 2
22 | 2
100 | 1
Spreadsheet: 176221d1345763938-counting-a-column-of-numbers-based-on-a-unique-identifier-matrixanalysiscolumns
Sheet: Data

 | Student ID | 1 | 2 | 3 | 4 | 5
 | Student Name | [NAME] | [NAME] | Rodrigo | [NAME] | Alicia
Class ID | Class Name
1 | Algebra | 2 |  | 4 |  | 6
2 | History | 1
3 | Writing | 4 |  |  | 4
4 | Band | 5 |  | 7
5 | Art |  |  |  |  | 5
Spreadsheet: 11fe4fc9-e945-4105-8d4f-4423861a93aa
Sheet: Headings Explained

Tip: Filter to the desired column heading on the DIRS File Layout tab by selecting the downward triangle to the right of the heading.  The resulting display will be the valid selection or options.
Field and Values Heading | Heading Explanation | Example
Field Category | Grouping of fields by DIRS location or submission portion (for ease of filtering like fields/screens) | Values are: Incident, Incident - Offender/Victim, Incident - Offender Activity, School Information, or Systematic
Field and/or Heading (as displayed in DIRS) | Labels as shown on DIRS screens | Date of Incident
Field (as displayed in reports or column headings) | DIRS field identifier | aesType
Field Values | Selections or options available within a field (generally numeric which correlate to field descriptions) | 1
Field Value Descriptions | Selections or options available within a field (generally text which correlate to field values) | Enrollment in an area learning center
Format | Field format required (text, number, etc…) | Number
Length | Field length allowed | 2
Req or Cndtl | Defines whether the field is required (Y) or conditional (C), with conditional only appearing in specific scenarios.  Blanks indicate optional fields. | C
Comments | Notations regarding the field population, perhaps indicators of scenarios where a conditional field may be needed. | Required if disciplinaryActionType is 2, 3, 5, or 6, and numDays is more than 5.  See valid values for aesType.
Applicable to School Record | Indicates if a field is needed as part of a school record. | N
Applicable to Incident Record | Indicates if a field is needed as part of an incident. | N
Applicable to Offender Record | Indicates if a field is needed as part of an offender activity. | N
Applicable to Victim Record | Indicates if a field is needed as part of a victim. | N
Applicable to Weapon Record | Indicates if a field is needed as part of a weapon. | N
Applicable to Disciplinary Action Record | Indicates if a field is needed as part of a disciplinary action. | Y
Field Row Last Changed Date | Indicates the last date this row of information was updated.  Note that some changes may have been minimal (updated description for instance). | 2010-11-10 00:00:00
Spreadsheet: darrell_schoolcraft__7319__imball0202
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 332436 | 332955
78311 | 119719 | 122000 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 319515 | 379396 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 363321 | 345210
500293 | 176889 | 202925
500302 |  | 3030
500303 |  | 8731
500305 | 507398 | 526978
500307 | 33269 | 19318
500313 |  | 917
500314
500655 | 63195
500657 | 26180 | 6000
INDEX
2002-01-31 00:00:00 |  |  | 121616.94
2002-02-10 00:00:00
CBS Volume
 |  |  | 70652
Spreadsheet: 92368d1291933301-problem-with-cash-flow-reconciliation-copy-of-copy-of-financial-model-1
Sheet: Analysis of Accounts

 |  |  | 2010-12-01 00:00:00 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | Cash & Cash Equivalents
 | Accounts Receivable
 |  | Month's beginning balance
 |  | (+) Credit Sales during the month
 |  | (-) Collections on accounts
 |  | Month's ending balance
 | Inventory
 |  | Month's beginning balance | 6186.559999999996 | 6186.559999999996 | 6186.559999999996 | 6186.559999999996 | 6186.559999999996 | 6186.559999999996 | 6186.559999999996 | 6186.559999999996 | 6186.559999999996 | 6186.559999999996 | 6186.559999999996 | 6186.559999999996 | 6186.559999999996
 |  | (+) Purchases
 |  | (-) Goods sold
 |  | Month's ending balance
 |  | Other Current Assets
 | Non-current Assets
 |  | Month's beginning balance | 87148.97
 |  | (+) Asset Acquistions
 |  | (-) Depreciation
 |  | Month's ending balance
 |  | Other Assets (VAT)
 |  | Month's beginning balance
 |  | (+) Increase in other VAT Claimable
 |  | (-) VAT Payable
 |  | Month's ending balance
 | Accounts Payable
 |  | Month's beginning balance | 3175257.99
 |  | (+) Purchases on account
 |  | (-) Payments on account
 |  | Month's ending balance
 |  | Other Current Liabilities
 |  | Long-term debt
 |  | Deferred Income Tax
 |  | Other Non-Current Liabilities
 |  | Paid-in Capital
 |  | Month's beginning balance | 930000
 |  | (+) Capital Increase
 |  | (-) Retirement of common shares
 |  | Month's ending balance
 |  | [NAME]
 |  | Month's beginning balance | -901610.57
 |  | (+) Period's Net-Income
 |  | (-) Paid dividends
 |  | Month's ending balance
Spreadsheet: 714807d1611380678-matching-cells-value-in-two-arrays-under-specific-condition-matching-results-under-specific-conditions-1-ans
Sheet: Sheet1

 |  |  | Matching cells in row arays, under specific condition
 |  |  | Reference cell
 |  |  | 12 |  | 9 | 10 | 11 | 12 | 13 |  | Result
 |  |  |  |  | 0.35 | 0.25 | 0.15 | 0.1 | 0
 |  |  | 3500
 |  |  | [NAME] |  |  |  |  |  |  | Comment
 |  |  | If one of the values in the row aray [F3:J3] is equal to the core number in D3 |  |  |  |  |  |  | yes, I3 - D3
 |  |  | Then the result is the matching value in [F7:J7] |  |  |  |  |  |  | matching value is I7
 |  |  | if none of the values in the row aray [F3:J3] is equal to the core number in D3
 |  |  | then the result is D7
 |  |  | In the table hereabove, J3 = D3, therefore the resul is J7
Spreadsheet: 182637d1348565374-highlite-next-schedule-column-in-week-table-based-on-service-date-service-schedule
Sheet: Sheet1

 |  |  |  | WEEK NUMBER
Vehicle Reg | SERVICE | Days | SCHEDULE START | 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 | 2013-01-01 00:00:00
324561 | Monthly | 30 | 2012-01-02 00:00:00
324566 | Monthly | 30 | 2012-01-02 00:00:00
324571 | Bi-Monthly | 60 | 2012-01-03 00:00:00
324576 | Semi-Annual | 180 | 2012-01-03 00:00:00
324581 | Weekly | 7 | 2012-01-03 00:00:00
324586 | Weekly | 7 | 2012-01-03 00:00:00
324591 | Weekly | 7 | 2012-01-03 00:00:00
324596 | Weekly | 7 | 2012-01-03 00:00:00
324601 | Weekly | 7 | 2012-01-03 00:00:00
324606 | Yearly | 365 | 2012-01-01 00:00:00
324611 | Fortnightly | 14 | 2012-01-03 00:00:00
324616 | Quarterly | 90 | 2012-01-03 00:00:00
 |  |  |  | WEEK NUMBER
Vehicle Reg | SERVICE | Days | SCHEDULE START | 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
324561 | Monthly | 30 | 2012-01-02 00:00:00
324566 | Monthly | 30 | 2012-01-02 00:00:00
324571 | Bi-Monthly | 60 | 2012-01-03 00:00:00
324576 | Semi-Annual | 180 | 2012-01-03 00:00:00
324581 | Weekly | 7 | 2012-01-03 00:00:00
324586 | Weekly | 7 | 2012-01-03 00:00:00
324591 | Weekly | 7 | 2012-01-03 00:00:00
324596 | Weekly | 7 | 2012-01-03 00:00:00
324601 | Weekly | 7 | 2012-01-03 00:00:00
324606 | Yearly | 365 | 2012-01-01 00:00:00
324611 | Fortnightly | 14 | 2012-01-03 00:00:00
324616 | Quarterly | 90 | 2012-01-03 00:00:00
Spreadsheet: 863571d1711012248-calculating-time-based-on-event-formula-help-tracking-time-on-events-example
Sheet: Sheet1

Battery #1 in | Battery #2 in | Battery #1 out | Battery #2 out | Time stamp | Name |  | Battery in time |  |  |  |  |  |  |  |  |  |  | Battery out time
1 | 2 | 9 | 10 | 09:45:00 | MonDAGV
3 | 4 | 1 | 2 | 10:05:00 | MonDAGV
5 | 6 | 7 | 8 | 10:10:00
10 | 9 | 3 | 4 | 11:10:00
2 | 1 | 5 | 6 | 12:10:00
1 | 2 | 9 | 10 | 13:10:00
3 | 4 | 1 | 2 | 14:00:00
5 | 6 | 7 | 8 | 14:15:00
10 | 9 | 3 | 4 | 15:16:00
2 | 1 | 5 | 6 | 16:12:00
 |  |  |  |  |  |  | Total time battery was in for:
 |  |  |  |  |  |  |  | time in stamp | time out stamp | Time difference |  |  | time in stamp | time out stamp | Time difference