tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 626ecd06-4150-4f26-b1db-7a32694100db
Sheet: Sheet1

Date | Test | Time | Students | Room
2012-05-08 00:00:00 | AP Spanish Language | 8 am - 11:50am | 16 | 3D05
2012-05-09 00:00:00 | AP BC Calculus | 8am - 11:50am | 32 | SC133
2012-05-09 00:00:00 | Ap Chinese | 12pm - 3:30pm | 4 | [NAME]
2012-05-10 00:00:00 | AP English literature | 8am  - 11:50am | 21 | 1B04
2012-05-11 00:00:00 | AP United States History | 8am - 11:50 am | 44 | 2C04
2012-05-14 00:00:00 | AP Physics C Mechanics | 12pm - 2:00pm | 8 | 3A05
2012-05-15 00:00:00 | AP US Govt & Politics | 8am - 12:00pm | 21 | 3D01
2012-05-16 00:00:00 | AP English Language | 8am - 11:50am | 50 | 2M05
2012-05-16 00:00:00 | AP Statistics | 12pm - 3:30pm | 42 | 2M04
2012-05-17 00:00:00 | AP World History | 8am - 11:50am | 26 | 3B02
2012-05-23 00:00:00 | AP Environmental Science | 12pm - 3:30pm | 50 | 4M07
2012-05-24 00:00:00 | AP Chemistry | 12pm - 3:30pm | 28 | 3B02
2012-05-24 00:00:00 | AP Calculus AB | 8am - 12:00pm | 38 | 3B02
2012-05-25 00:00:00 | AP Physics B | 8am - 12:00pm | 27 | 1E07
2012-05-25 00:00:00 | AP Biology | 12am - 3:30pm | 24 | 1E06
2012-05-25 00:00:00 | Physics c Electricity | 2pm-3:30 pm | 4 | ?
Spreadsheet: 743987d1628857174-minimum-out-put-from-2-inputs-example-1-ans-1-
Sheet: Sheet1

 | Quantity in M² | Price per M² | Total Price to the plasterer, must be min 5m²
OLD CODE that is currently being used
Plaster skim - per m² (minimum of total 5m²  for plastering) | 8 | 10
NEW CODES that I want to use
Plaster skim (Wall) - per m² (minimum of total 5m²  for plastering) | 1 | 10 |  | D6 and [NAME] should equal; 0, if 0 is entered in both B6 & B7  The output of B6 X C6 or B7 X C7, IF the total of [NAME] is greater than 5 5, If either [NAME] or [NAME] is equal to or greater than 1 but less than 5, however if B6 > 5 and D7 =0 then D6 needs to = 5 and D7=0 or vice versa. If both [NAME] or [NAME] are larger than 1 but the sum of [NAME] is less than 5 then the largest cell needs to be incresed so that the sum of [NAME] = 5.
Plaster skim (Ceiling) - per m² (minimum of total 5m²  for plastering) | 4 | 10
I have tried this formula in D6 --> but it just states false
Spreadsheet: 271611d1382000426-search-find-formula-ghozi-17092013-search-find-formula
Sheet: Sheet1

FORMULA | What i need pulled out |  | Data Set
 |  |  | <25/09/2013 19:41:48>  AR "Other (Please State Below) log on_x000D_ Other (Please State Below) see below_x000D_ I came in to work and logged on to the p.c I have been working at for some time now and i out my lan I.D inand password and was then presented with an error advising i was not able to log on, i called 1.2.3 who advised to try and log onto another p.c which brought back the same error. they advised i would get a call in the next 48 hours_x000D_ 3783157_x000D_ Reboot - No"					_x000D_
 | INC 03783157 |  | <01/10/2013 17:35:37>  RZ Faullt INC 03783157 & 03788388
 | INC03687943 |  | <02/09/2013 12:44:03> RC INC03687943"Multiple Applications (Please State Below) AW4 Siebel & SAP IS_x000D_ Other (Please State Below) missing screen info_x000D_ Application AW4 has missing screen information and drop down issues - spoke to IS who tried to do a repair on the software but this didn't work and then was advised to speak to NHD who have finally resloved the after 3 reboots on system and mulitple cache clearence and screen resoultion advise. _x000D_ INC03687943_x000D_ Reboot - Yes"					_x000D_ 	_x000D_ _x000D_ <02/09/2013 12:57:07> RC amended the end time from 11:57
 |  |  | <06/08/2013 18:36:05> SB "AWB Zelda _x000D_ System Froze _x000D_ Log in issues_x000D_ 34565376_x000D_ Reboot - Yes"					_x000D_
 | inc03619457 |  | <13/08/2013 09:12:14> AK "AWB Zelda _x000D_ Other (Please State Below) log in button not working_x000D_ _x000D_ inc03619457_x000D_ Reboot - No"	_x000D_ <13/08/2013 13:30:56> SB "AWB Zelda _x000D_ Other (Please State Below) log in button not working_x000D_ _x000D_ inc03619457_x000D_ Reboot - No"			_x000D_ <13/08/2013 18:45:21>  RZ "AWB Zelda _x000D_ Other (Please State Below) login button not working_x000D_ _x000D_ inc03619457_x000D_ Reboot - No"					_x000D_ 		_x000D_ 				_x000D_ _x000D_ <13/08/2013 18:52:32> mg amended from all day
 | INC03692459 |  | <10/09/2013 10:23:38>  ES - HK INC03692459/03692640/03692923
 | INC03692459 |  | <19/09/2013 13:03:04>  ES - INC03692459/03692640/03692923
 | INC03684560 |  | <31/08/2013 15:17:48> AS1 AWB4 Fault Raised an issue with the loss of the correspondence viewer in AWB and tried to get it resolved with 123 on   INC03684560.  Off pone from 1.35 – 2.00
 | INC03660510 |  | <27/08/2013 10:55:32> JP "AWB Zelda _x000D_ [NAME] (Please See Guidelines) _x000D_ Fault with Agent workbench, IT have qouted 4 working days SLA._x000D_ INC03660510_x000D_ Reboot - Yes"					_x000D_ _x000D_ <27/08/2013 15:38:50> RC for call taking from 14.30 to 18.00 as her systems are back up and running. amended the end time from 18:00
 |  |  | <16/08/2013 18:16:42> AK imc0363460	_x000D_ "AWB Zelda _x000D_ Other (Please State Below) workbench crashed_x000D_ known incident , unable to log back in to work bench._x000D_ imc0363460_x000D_ Reboot - No"					_x000D_
Spreadsheet: 881849d1730092726-count-if-max-count-if-max
Sheet: TMS

DATE | NAME | Count
 | 2024-10-19 00:00:00 | 1
A [NAME] (25) | 2024-08-13 00:00:00 | 1
A BROOKS  (35) | 2024-10-02 00:00:00 | 1
A GILCHRIST  (2) | 2024-10-23 00:00:00 | 1
C O'HARE  (10) | 2024-09-01 00:00:00 | 1
G HAMER  (8) | 2024-09-21 00:00:00 | 5
H BURROWS (14) | 2024-10-02 00:00:00 | 6
H SOUTTAR (6) | 2024-09-21 00:00:00 | 9
J RAK-SAKYI (11) | 2024-10-05 00:00:00 | 7
J SHACKLETON (16) | 2024-09-13 00:00:00 | 1
J ROBINSON (19) | 2024-08-09 00:00:00 | 4
K MOORE (9) | 2024-09-21 00:00:00 | 1
L MARSH  (34) | 2024-08-27 00:00:00 | 1
M COOPER (1) | 2024-10-23 00:00:00 | 5
O ARBLASTER  (4) | 2024-09-13 00:00:00 | 1
R BREWSTER  (7) | 2024-08-27 00:00:00 | 1
S MCCALLUM (3) | 2024-09-13 00:00:00 | 2
S SACHDEV (45) | 2024-08-27 00:00:00 | 2
S PECK  (42) | 2024-10-23 00:00:00 | 1
V DE SOUZA COSTA (21) | 45584 | 3
Spreadsheet: 216597d1361819256-if-and-vlookup-problem-level-3-tracking-for-anita-protected
Sheet: Unit 20S

Name | Surname | P1 | P2 | P3 | P4 | P5 | P6 | M1 | M2 | M3 | D1 | D2 | Final Grade | Final Points Value
Spreadsheet: kevin_presto__19995__SERC Seasonal Assessments-EIA 411 reporting responsibilities
Sheet: Reporting Responsibilities

Data submitted by:
 | Reporting Entity
Report | Entity 1 | Entity 2 | Entity 3 | Entity 4 | Entity 5 | Entity 6 | Entity 7
SERC Seasonal Assessment
Inputs
Historical Seasonal Peaks (Monthly)
Total Internal Demand (Monthly)
Interruptible Load/Load Management (Monthly)
Total Capacity (Monthly)
Committed Resources (Monthly)
Uncommitted Resources (Monthly)
Inoperable Capability (Monthly)
Total Capacity Purchases (Monthly)
Full Responsibility Purchases (Monthly)
Total Capacity Sales (Monthly)
Full Responsibility Sales (Montly)
Adjustment to Purchases and Sales (Monthly)
Calculated Values
Net Internal Demand (Monthly)
Net Operable Capacity (Monthly)
Net Capacity Resources (Monthly)
Capacity Margin (Monthly)
EIA 411
Actual Demand & Energy Previous Year (Monthly)
Projected Demand & Energy Report Year (Monthly)
Projected Demand & Energy Next Year (Monthly)
Projected Summer & Winter Peak Demand Next Ten Years
Projected Summer and Winter Capacity Resources Next Ten Years
Projected Summer and Winter Sales Next Ten Years
Projected Summer and Winter Purchases Next Ten Years
Proposed Bulk Power Transmission Line Additions (230 KV and above)
Existing & Planned Transmission Line Circuit Miles Next Ten Years
Existing and Planned Generating Plant and Unit Capacity Data
Jointly Owned Generator Data
FERC 714 (Annual Electric Control & Planning Report)
Part 2, Sch 1: Generation by Plant @ Yearly Peak Hour | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
Part 2 , Sch 2: Capability @ Monthly Peak Hour (Monthly) | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
Part 2, Sch 3: Net Energy for Monthly Load and Peak Demand (Monthly) | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
Part 2, Sch 4: Control Area Interconnections | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
Part 2, Sch 5: Yearly Scheduled and Actual Control Area Interchange | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
Part 2, Sch 6: Yearly Control Area Lambda by Hour | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
Part 3, Sch 1: Utilities that Compose the Planning Area | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
Part 3, Sch 2: (see below) | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
a) Control Area load by Hour | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
b) Projected 10 Year Control Area Seasonal Peaks and Yearly Net Energy Demand | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
FERC 715 (Annual Transmission Planning & Evaluation Report) | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
FERC Form 1 | [NAME] | ~ | ~ | ~ | ~ | ~ | ~
Spreadsheet: eric_saibi__9839__100401R
Sheet: Cook 2

Owner Name |  | American Electric Power
Station Name |  | [NAME]
Unit Name |  | [NAME] 02
NERC Region |  | MAIN
State |  | MI
Fuel Type |  | Nuclear
Capacity |  | 1,133 MW
Start Date |  | 2001-08-30 00:00:00
End Date |  | 2001-10-08 00:00:00
Prv. Start Date |  | 2001-08-30 00:00:00
Prv. End Date |  | 2001-10-05 00:00:00
Comments
SIC |  | 4911
Plant ID |  | 1000365
Unit ID |  | 1005088
Outage ID |  | 18235
Spreadsheet: 808504d1670500819-get-min-and-max-values-from-column-b-where-corresponding-column-a-matches-criteria-truck
Sheet: Sheet1

Citywise Vehicle
 | Date | 2022-04-20 00:00:00 | 2022-04-21 00:00:00 | 2022-04-22 00:00:00
Vehicle
 | City 1 | Truck 1 | Truck 4 | Truck 3
 | City 2 | Truck 2 | Truck 2 | Truck 4
 | City 3 | Truck 3 | Truck 1 | Truck 1
 | City 4 | Truck 1 | Truck 4 | Truck 1
 | City 5 | Truck 4 | Truck 2 | Truck2
 | City 6 | Truck 3 | Truck 1 | Truck 4
[NAME]
 | City 1 | 1000 | 2130 | 1650
 | City 2 | 800 | 870 | 2320
 | City 3 | 1500 | 1240 | 1350
 | City 4 | 1100 | 2080 | 1300
 | City 5 | 2000 | 940 | 1020
 | City 6 | 1560 | 1150 | 2230
End Km
 | City 1 | 1100 | 2230 | 1750
 | City 2 | 870 | 940 | 2390
 | City 3 | 1560 | 1300 | 1410
 | City 4 | 1150 | 2130 | 1350
 | City 5 | 2080 | 1020 | 1100
 | City 6 | 1650 | 1240 | 2320
Truck Start Km |  | [NAME] must fill as below
 | Truck 1 | 1000 | 1150 | 1300
 | Truck 2 | 800 | 870 | 1020
 | Truck 3 | 1500 | 1650 | 1650
 | Truck 4 | 2000 | 2080 | 2230
Truck End Km
 | Truck 1 | 1150 | 1300 | 1350
 | Truck 2 | 870 | 1020 | 1100
 | Truck 3 | 1650 | 1650 | 1750
 | Truck 4 | 2080 | 2230 | 2390
Spreadsheet: 811123d1672299983-how-to-get-three-middle-number-from-list-moderation-exam-marks
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | moderation marks
 | No. | Name | Matric No. | Math | Sc | Arts | Eng | Geog | History |  |  |  |  |  | math
 | 1 | [NAME] | 68751 | 45 |  |  |  |  |  |  |  |  |  | Highest 1 |  | 92 |  | SORT(FILTER(L6:[NAME]:M54>=LARGE(M6:M54,3)),2,-1)
 | 2 | Alexandra | 41803 | 89 |  |  |  |  |  |  |  |  |  | Highest 2 | Alexandra | 89 | <==
 | 3 | [NAME] | 20636 | 27 |  |  |  |  |  |  |  |  |  | Highest 3 | Carol | 80
 | 4 | Amanda | 34789 | 68 |  |  |  |  |  |  |  |  |  | middle 1 |  | 68 |  |  |  |  |  | <<---
 | 5 | Amelia | 76662 | 19 |  |  |  |  |  |  |  |  |  | middle 2 | [NAME] | 62
 | 6 | [NAME] | 26158 | 92 |  |  |  |  |  |  |  |  |  | middle 3 | [NAME] | 58
 | 7 | [NAME] | 95100 | 58 |  |  |  |  |  |  |  |  |  | Lowest 1 |  | 0 |  | SORT(FILTER(L6:M54,M6:M54<=SMALL(M6:M54,3)),2,1)
 | 8 | [NAME] | 21301 | 77 |  |  |  |  |  |  |  |  |  | Lowest 2 | Amelia | 19 | <==
 | 9 | Anna | 96074 | 36 |  |  |  |  |  |  |  |  |  | Lowest 3 | [NAME] | 27
 | 10 | Anne | 89705 | 39 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 11 | [NAME] | 17900 | 62 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 12 | Ava | 90594 | 69 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 13 | [NAME] | 13064 | 71 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 14 | [NAME] | 12687 | 34 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 15 | Carol | 80939 | 80 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 33 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 38 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 41 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 42 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
Spreadsheet: 864229d1711474438-i-need-to-count-employees-active-at-a-certain-time-based-on-start-and-end-dates-book1-96-3-
Sheet: Sheet2 (2)

First Name | Start | End |  | INSERT DATE HERE: | 2018-04-05 00:00:00
a | 2003-09-15 00:00:00
b | 2004-11-08 00:00:00 | 2022-01-31 00:00:00 |  | SUM Result: |  |  | <-- this one ok
c | 2005-05-25 00:00:00 |  |  | New Formula: |  |  | <-- how do I make this work?
d | 2006-06-19 00:00:00
e | 2007-09-10 00:00:00
f | 2010-04-01 00:00:00 | 2018-03-23 00:00:00
g | 2010-08-09 00:00:00 | 2019-03-31 00:00:00
h | 2013-11-05 00:00:00 | 2020-07-30 00:00:00
i | 2015-03-16 00:00:00 | 2018-04-05 00:00:00
j | 2016-09-20 00:00:00
k | 2017-09-25 00:00:00
l | 2018-04-09 00:00:00
m | 2018-06-11 00:00:00
n | 2019-04-01 00:00:00
o | 2019-08-12 00:00:00
p | 2021-03-01 00:00:00
q | 2021-09-20 00:00:00
r | 2022-02-01 00:00:00
s | 2023-05-01 00:00:00
Spreadsheet: 549750d1511896491-sum-multiple-worksheets-lkk-pf-cycle-count-master
Sheet: AA

Date: |  | LKK Cycle Count | Location AA
Location | Code | Description | Count | Recount
AA-01-A-01
[NAME]
[NAME]
[NAME]
[NAME]
AA-01-C-02
AA-02-A-01
AA-02-A-02
[NAME]
[NAME]
[NAME]
AA-02-C-02
AA-02-D-01
AA-02-D-02
AA-03-A-01
AA-03-A-02
AA-03-B-01
AA-03-B-02
AA-03-C-01
AA-03-C-02
AA-03-D-01
AA-03-D-02
AA-04-A-01
AA-04-A-02
AA-04-B-01
AA-04-B-01
AA-04-B-02
AA-04-C-01
AA-04-C-02
AA-04-D-01
AA-04-D-02
AA-05-A-01
AA-05-A-02
AA-05-B-01
AA-05-B-02
AA-05-C-01
AA-05-C-02
AA-05-D-01
AA-05-D-02
AA-06-A-01
AA-07-A-01
AA-08-A-01
AA-09-A-01
AA-10-A-01
AA-11-A-01
AA-12-A-01
AA-13-A-01
AA-14-A-01
AA-15-A-01
AA-16-A-01
AA-17-A-01
Spreadsheet: 470457d1468493712-if-formula-to-display-row-wherever-criteria-meet-in-a-column-of-data-rajeshmarndi
Sheet: Sheet1

 |  |  | Value
 |  |  | 64
 |  |  | 74
 |  |  | 35
 |  |  | 17
 |  |  | 57
 |  |  | 85
 |  |  | 49 |  | The formula in F3 and copied down is an array formula.
 |  |  | 8
 |  |  | 8 |  | Array formulas are entered differently than a regular formula.
 |  |  | 94 |  | After you type in a regular formula you hit the ENTER key.
 |  |  | 100 |  | With an array formula you *must* use a combination of keys.
 |  |  | 31 |  | Those keys are the CTRL key, the SHIFT key and the ENTER key.
 |  |  | 54 |  | That is, hold down both the CTRL key and the SHIFT key then
 |  |  | 62 |  | hit the ENTER key.
 |  |  | 66
 |  |  | 42 |  | When done properly Excel will enclose the formula in squiggly
 |  |  | 29 |  | brackets { }. You can't just type these brackets in, you
 |  |  | 79 |  | *must* use the key combo to produce them. Also, anytime
 |  |  |  |  | you edit an array formula it *must* be re-entered as an
 |  |  |  |  | array using the key combo.
Spreadsheet: 747737d1631675320-compliance-actions-formula-ocf-test
Sheet: OCF

 |  |  | Operational Compliance Framework |  | Date: 27/4/21
 |  |  |  | Y,N,P or NA
 |  | Risk Treatment Plans |  | Compliance | Comments
A |  | RISK 1
 |  | 1.1 |  | Y
 |  | 1.2 |  | Y
 |  | 1.3 |  | Y
 |  | 1.4 |  | Y
 |  | 1.5 |  | Y
B |  | RISK 2
 |  | 2.1 |  | Y
 |  | 2.2 |  | Y
 |  | 2.3 |  | Y
 |  | 2.4 |  | Y
 |  | 2.5 |  | Y
 |  | 2.6 |  | Y
 |  | 2.7 |  | Y
C |  | RISK 3
 |  | 3.1 |  | Y
 |  | 3.2 |  | Y
 |  | 3.3 |  | Y
 |  | 3.4 |  | Y
 |  | 3.5 |  | N
 |  | 3.6 |  | N
 |  | 3.7 |  | Y
 |  | 3.8 |  | N
 |  | 3.9 |  | Y
D |  | RISK 4
 |  | 4.1 |  | Y
 |  | 4.2 |  | Y
 |  | 4.3 |  | Y
 |  | 4.4 |  | Y
 |  | 4.5 |  | Y
 |  | 4.6 |  | Y
 |  | 4.7 |  | Y
 |  | 4.8 |  | Y
 |  | 4.9 |  | Y
 |  | 4.1 |  | Y
 |  | 4.11 |  | Y
 |  | 4.12 |  | Y
E |  | RISK 5
 |  | 5.1 |  | Y
 |  | 5.2 |  | Y
 |  | 5.3 |  | n
 |  | 5.4 |  | n
 |  | 5.5 |  | Y
 |  | 5.6 |  | Y
 |  | 5.7 |  | Y
 |  | 5.8 |  | Y
 |  | 5.9 |  | Y
 |  | 5.1 |  | Y
 |  | 5.11 |  | Y
 |  | 5.12 |  | Y
 |  | 5.13 |  | Y
 |  | 5.14 |  | Y
F |  | RISK 6
 |  | 6.1 |  | Y
 |  | 6.2 |  | Y
 |  | 6.3 |  | Y
 |  | 6.4 |  | Y
 |  | 6.5 |  | Y
 |  | 6.6 |  | Y
 |  | 6.7 |  | Y
 |  | 6.8 |  | Y
 |  | 6.9 |  | Y
 |  | Comments
 |  | Total Checks:
 |  |  | Score:
Spreadsheet: 471283d1468940707-dynamic-chart-dynamicchart-template
Sheet: Scatter

Time[Hr] | Product A | Product B
0 | 0 | 0
1 | 15.7453125 | 11.06666666666666
2 | 28.75197135416666 | 23.95177777777778
3 | 39.18784416301475 | 35.15839992580226
4 | 48.14627243085199 | 44.40876224464284
5 | 56.0025189411814 | 52.59961930773608
6 | 62.61205123983913 | 59.62921941959291
8 | 72.21415032947498 | 71.0373006520859
10 | 80.02501873576006 | 79.70874955963733
12 | 85.93072559354532 | 85.63818212467199
14 | 89.7889083075093 | 89.6587542726901
16 | 93.85393174941566 | 92.52926741205327
18 | 96.0916783948959 | 94.32620244030187
20 | 98.01353677067407 | 95.29285495869463
Spreadsheet: 4c3e4e5c-9fa6-4fc9-bf83-21193657ea30
Sheet: Sheet1

DCT Program Tech Activity Tracking | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
District name: |  |  |  |  | Month:
DCT Name:
 | Activity (document date & quantity in appropriate column)
Date | Contact/ Assist Producers | Tech Notes | Apply Practice | Outreach/ Marketing | Field chks/ Inspections/ CRP validation
Example  4/10/13 | 2 |  |  | 0.5 | 3
Example  4/12/13 |  | 0.25 | 0.5
Monthly totals | 0 | 0 | 0 | 0 | 0 | 0
Entering your name on this sheet certifies that the activities recorded above are accurate for the NRCS/CSCB District Conservation Technician Program.
DCT E-Signature: |  |  |  | Date:
Spreadsheet: 735077d1622682058-calculating-diminishing-cost-of-storage-over-time-diminishing-cost-of-storage
Sheet: Sheet1

 | Table 1
 |  | Current Stock on Hand Units | Weekly Sales units | # [NAME] per Pallet | Storage Cost per pallet | Total Cost of Storage (until stock runs out)
 | SKU 1 | 100 | 20 | 2 | 5
 | SKU 2 | 500 | 35 | 10 | 5
 | SKU 3 | 50 | 2 | 50 | 5
 | SKU 1 Cost calculation example
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6
 | SOH by week
 | # pallets per week
 | total cost per week
 | total cost until stock runs out
Spreadsheet: 819528d1677566424-dept-and-expense-type-match-to-calculate-total-amount-test
Sheet: Income Statement by Dept

Budget Expenses | BDR | CSM | CSM | Marketing | Engineering | Marketing | General and Administrative | Product & Design | Marketing | Engineering | General and Administrative | Product & Design
Employee Compensation | 1000 | 150 | 2000 | 5000 | 9000 | 17000 | 900 | 508791.78 | 308784.14 | 239204.54 | 1070005.66 | 518798.21
Commission & Bonus
Commission & Bonus
Commission & Bonus
Payroll Taxes
Health Benefits | 0 | 0 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
Third Party Services | 1000
Third Party Services |  | 2000
Third Party Services |  |  | 3000
Spreadsheet: 14e76595-c132-47f8-ab84-1a805a26405e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259434 | 41190 | Georgina | Jennings | GBR | 663 | 00:17:53 | 00:01:24 | 00:35:12 | 00:00:00 | [NAME] | 1 | 01:24:16
259434 | 21289 | Anne | Fish | GBR | 662 | 00:18:35 | 00:01:18 | 00:39:23 | 00:00:00 | 00:31:34 | 2 | 01:30:48
259434 | 40968 | Sybil | Davison | GBR | 661 | 00:17:00 | 00:01:35 | 00:46:57 | 00:00:00 | 00:37:21 | 3 | 01:42:52
Spreadsheet: 157657d1337821046-click-to-add-data-what-is-this-billingstatement1
Sheet: Billing Statement

 | Your Company Name
 | Street Address |  |  | Phone: | (413) 555-0190
 | Address 2 |  |  | Fax: | (413) 555-0191
 | City, ST  ZIP Code |  |  | E-mail: | [EMAIL]
 | Statement
 | Statement #: | Enter statement number |  | [NAME] To: | Name
 | Date: |  |  |  | Company Name
 | Customer ID: | Enter customer ID |  |  | Street Address
 |  |  |  |  | Address 2
 |  |  |  |  | City, ST  ZIP Code
 | Date | Type | Invoice # | Description | Amount | Payment | Balance
 |  |  |  |  |  | Total
 | Reminder: Please include the statement number on your check.
 | Terms: Balance due in 30 days.
 | REMITTANCE
 | Customer Name: | Enter customer name
 | Customer ID:
 | Statement #:
 | Date:
 | Amount Due:
 | Amount Enclosed:
Spreadsheet: 709102d1608155651-matching-different-dates-with-same-item-sample-example-multi-match-same-id-4-
Sheet: Outcomes

ID # | Name | Outcome Dates | Intake Date | Length of Stay | Intake Date - Standard Index and Match
A825492 | Luna | 2020-12-31 12:40:00 |  |  |  | Same Date
A825492 | Luna | 2020-12-30 10:55:00 |  |  |  | Same Date
A825653 | [NAME] | 2020-12-10 13:38:00 |  |  |  | Same Date
A825653 | [NAME] | 2020-12-02 14:28:00 |  |  |  | Same Date
A825700 |  | 2020-12-01 12:52:00
A825700 |  | 2020-12-14 19:15:00 |  |  |  | Same Date
A825700 |  | 2020-12-01 15:32:00 |  |  |  | Same Date
A825863 | *Poppet | 2020-12-16 19:15:00 |  |  |  | Same Date
A825863 | *Poppet | 2020-12-12 08:36:00 |  |  |  | Same Date
A826166 | *Ophelia | 2020-12-28 16:49:00 |  |  |  | Same Date
A826166 | *Ophelia | 2020-12-12 14:48:00 |  |  |  | Same Date
[NAME] | [NAME] | 2020-12-03 16:37:00
A826771 |  | 2020-12-04 16:13:00
A826772 |  | 2020-12-01 16:18:00
A826773 |  | 2020-12-03 16:21:00
A826774 |  | 2020-12-03 16:30:00
A826777 |  | 2020-12-01 17:38:00
Spreadsheet: 125441d1319033657-if-function-problem-forum
Sheet: Sheet1

Post code | [NAME] | All used? | No. of records | Cell range |  | Date | No. used | Cell range |  | Date | No. used | Cell range |  | Date | No. used | Cell range |  | Date | No. used | Cell range |  | Date | No. used | Cell range |  | Date | No. used | Cell range
 |  |  |  | From | To |  |  | From | To |  |  | From | To |  |  | From | To |  |  | From | To |  |  | From | To |  |  | From | To
Test | Test |  | 1000 |  |  | 2011-06-15 00:00:00 | 246 |  |  | 2011-06-16 00:00:00 | 254 |  |  |  | 100
Spreadsheet: 328498d1403914639-football-predictor-football-predictor
Sheet: Points

 |  | Weekly Predicted Points
 | Rank | Name | Total | week 23 | week 24 | week 25 | week 26 | week 27 | week 28 | week 29 | week 30 | week 31 | week 32 | week 33 | week 34 | week 35 | week 36 | week 37 | week 38
 |  | [NAME] |  | 11 | 13 | 11 | 13 | 22 | 22 | 26 | 17 | 25 | 21 | 22 | 21 | 21 | 27 | 0 | 27
 |  | Ewan |  | 14 | 19 | 9 | 11 | 23 | 21 | 30 | 27 | 32 | 27 | 26 | 27 | 19 | 22 | 15 | 32
 |  | [NAME] |  | 10 | 10 | 15 | 13 | 23 | 32 | 23 | 18 | 20 | 21 | 18 | 23 | 26 | 26 | 22 | 39
 |  | [NAME] |  | 21 | 12 | 11 | 12 | 19 | 18 | 16 | 19 | 28 | 23 | 20 | 27 | 23 | 15 | 17 | 22
 |  | Ian |  | 14 | 18 | 20 | 15 | 19 | 24 | 21 | 15 | 19 | 23 | 27 | 33 | 27 | 22 | 14 | 28
 |  | [NAME] |  | 11 | 16 | 11 | 12 | 25 | 24 | 15 | 21 | 23 | 14 | 29 | 22 | 22 | 19 | 16 | 26