tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 16f5e6b0-daca-45e2-9678-a7413e10822a
Sheet: Alternative Sch - Indep. Study

Alternative Schools
"Alternative School" Defined
A school setting that allows the student to attend at the Student's convenience.
High School Graduation Question:
Every enrollment form for a Non-Traditional "Alternative School" must ask the question
"Have you received a high school diploma"
A student over the age of 17 must answer this question on the form to enroll in a non-traditional school.
If the answer is YES, the districts may not include this student in the district FTE to receive state
funding.
[NAME]:
Enrolling students on September 20 for the sole purpose of collecting state aid is considered
fraudulent and such students shall not  be counted in the school districts enrollment.
Alternative School Attendance
[NAME] will be based on documented classroom attendance of educational activity.  The
student must have attended two (2) days:
a.  September 20 and one day before, or
[NAME] one day after, but prior to Oct. 5, or
c.  One day before and one day after September 20, but prior to October 5.
To count students attending an alternative school:
FTE will be calculated by finding the two days the student attended the greatest amount of time (up to
360 minutes) and using the lesser of the two days.  For example, Student A attends 360 minutes on
September 20, 120 minutes on September 24, and 216 minutes on September 29.  The two greater
attendance days are September 20 (360 minutes) and September 29 (216 minutes).  FTE will take the
lesser of the two (216) divided by 360 to equal 0.6 (rounded to one decimal place).
As an option, the school may use the total hours attended the week of September 20 divided by 30.
Whichever method is used must be used for all students in the alternative school.
A full time FTE student must have access to 30 hours of school attendance each week.
If the unified school district does not provide instructional support as outlined above, such students will
not be counted in the enrollment.
Auditor will require each student’s school time attendance to verify that the student is attending
360 minutes.  Make sure all time counted is in public school activities, being sure to deduct time
for lunch, extended breaks and religious activities
Problem Areas
The students schedule for September 20 and the second day (Count Days) MUST be the same
as any other school day.
Enrolled on 9/20
 | Time for the enrollment process will not be allowed.
Field Trips
 | Time for any activity off school property is considered a field trip and not allowed.  Examples
 | would be going to museums, shows, etc.
Career Day Activities
 | These would include but not be limited to, [NAME], Job Fairs, etc. and are not allowed.
Drawings for Prizes
 | All Students will be disallowed
Meals or Child Care Available
 | Unless you provide it every day, all students will be disallowed
Classroom Party
 | All Students will be disallowed
 |  |  |  |  | Return to Top
Spreadsheet: 870235d1716791777-aggregate-hlookup-not-working-test-book-3-aligw
Sheet: Ratings

YR 1 |  |  |  |  |  |  |  |  |  |  | '+IMP | Y2 | Y3 | Y4
 |  |  |  | X | 47 |  |  |  |  |  | X | 3 | 1 | 1
 |  |  |  | Y | 7 |  |  |  |  |  | Y | 0.75 | 0.5 | 0.25
 |  |  |  | MIN
 |  |  |  | MAX
SIZE | AGILITY | BALANCE | COORDINATION | POWER | REACTION TIME | SPEED | FLEXIBILITY | STRENGTH | ENDURANCE | ATH IQ | MOTOR | MENTAL |  | FT OFF | FT DEF | BB OFF | BB DEF | BskB OFF | BskB DEF | SCR OFF | SCR DEF | HKY OFF | HKY DEF | LAX OFF | LAX DEF | GLF OFF | GLF DEF | TEN OFF | TEN DEF |  |  | '+IMP | '+IMP | '+IMP
37 | 49 | 46 | 42 | 45 | 49 | 37 | 36 | 52 | 39 | 40 | 54 | 56 |  | 50 | 48 | 31 | 57 | 45 | 39 | 56 | 45 | 42 | 49 | 50 | 53 | 38 | 45 | 48 | 52 |  |  | 3 | 0 | 1
44 | 33 | 55 | 47 | 49 | 53 | 41 | 40 | 44 | 49 | 56 | 51 | 46 |  | 54 | 51 | 41 | 51 | 33 | 40 | 54 | 49 | 54 | 37 | 47 | 37 | 60 | 44 | 47 | 45 |  |  | 3 | 1 | 1
43 | 49 | 51 | 41 | 61 | 54 | 46 | 55 | 43 | 46 | 54 | 43 | 49 |  | 43 | 44 | 47 | 51 | 50 | 51 | 55 | 45 | 42 | 46 | 47 | 60 | 44 | 48 | 32 | 60 |  |  | 3 | 1 | 1
60 | 33 | 45 | 57 | 39 | 49 | 52 | 59 | 48 | 48 | 53 | 55 | 50 |  | 56 | 40 | 51 | 51 | 51 | 53 | 51 | 41 | 40 | 50 | 44 | 37 | 50 | 40 | 51 | 54 |  |  | 3 | 0 | 1
40 | 57 | 48 | 41 | 40 | 46 | 45 | 55 | 42 | 54 | 52 | 55 | 51 |  | 56 | 51 | 41 | 46 | 39 | 50 | 43 | 45 | 54 | 50 | 57 | 55 | 52 | 36 | 38 | 50 |  |  | 3 | 1 | 1
Spreadsheet: 97629d1296753401-cross-sheet-calc-that-would-omit-0-possible-solution-but-am-getting-a-ref-error-2011trending
Sheet: 0114

01/14/11  Performance Data
 |  | 1st Work |  |  |  | QC |  |  | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT SURNOTACKL MNBENMMIG SURDTHCERT | SURBENCSMG SURFRM SURVALDOD SURCUSFLUP SURSPLIGO SRSPNIGO SURBENSPLT RAIDPS RAIDNP/TAIDIN-IA FAID/FAIDWF IAID/FAIDCO SURINQ | SURBENRSCH SURBENUPDT RAIDPB RAIDAR | SURBENLEGL SURPAYLNPO | MNTBENMMIG SURSPLIGO SURSPNIGO SURBENSPLT RAIDPS FAID | SURBENRSCH (PASS) SURBENUPDT (PASS/FAIL) RAIDPB RAIDAR | SURBENRSCH (FAIL)
 |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint | 7 | 7 | 5 |  |  |  |  | 75 | 2.5 | reporting | 5.5 | 13.63636363636364
 | Dustin |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | Sharron |  | 9 | 3 |  |  |  |  | 51 |  |  | 9.5 | 5.368421052631579
 | Roxy | 3 | 19 | 6 |  |  |  |  | 111 |  |  | 8.25 | 13.45454545454546
 | [NAME] | 7 |  |  |  |  | 3 |  | 38 |  |  | 9 | 4.222222222222222
 | Ana | 1 | 7 | 19 |  |  |  |  | 175 |  |  | 8.5 | 20.58823529411765
 |  |  |  |  |  |  |  |  | 0
 | [NAME] | 3 | 25 | 6 |  |  |  |  | 129 | 0.5 | CISS | 9.25 | 13.94594594594595
 | Petra | 7 | 3 | 13 |  | 1 | 2 | 4 | 177 | 3 | [NAME] | 16.25 | 10.89230769230769
 | Regina |  |  | 1 |  |  | 4 |  | 40 | 7 | SWT | 4 | 10
 | Noy | 16 |  | 3 |  |  | 7 |  | 112 | 1.5 | SWT | 6.25 | 17.92
 | [NAME] |  |  |  |  | 37 | 24 |  | 266 |  |  | 16.25 | 16.36923076923077
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | SME | 0.01 | 1
 | Michelle |  |  |  |  |  |  |  | 0.01 |  | SME | 0.01 | 1
 | Keisha |  | 37 | 4 |  |  |  |  | 143 |  |  | 16.25 | 8.8
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | no info | 0.01 | 1
TEAM TOTALS | Pts Earned: | 2 | 3 | 8 | 12 | 2 | 8 | 8 |  |  |  |  | 138.197272067365
 | TASK VOLUME: | 44 | 107 | 60 | 0 | 38 | 40 | 4 | 1317 | 14.5 |  | 109.04 | 12.07813646368305
 | Pts Earned: | 88 | 321 | 480 | 0 | 76 | 320 | 32
 |  |  |  |  |  |  |  | Average PTS | 82.315 |  | Total Task Volume |  | 293
 | MID-DAY PPH  14.28
Spreadsheet: john_griffith__16199__1_30_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 19 | 155 | 165 | 50.5 | 53.8 | 0.62 | 2002-01-30 14:37:00
 | CL J2 | 19.5 | 262 | 272 | 48.8 | 50.6 | 0.61 | 2002-01-30 14:37:00
 | CL K2 | 19.5 | 342 | 350 | 48.3 | 49.5 | 0.6 | 2002-01-30 14:37:00
 | CL M2 | 20 | 390 | 405 | 46 | 47.8 | 0.59 | 2002-01-30 14:37:00
 | CL N2 | 20 | 430 | 445 | 44.6 | 46.2 | 0.57 | 2002-01-30 14:37:00
 | CL Q2 | 20 | 460 | 475 | 43.4 | 44.9 | 0.56 | 2002-01-30 14:37:00
 | CL U2 | 20 | 480 | 500 | 42.1 | 43.8 | 0.54 | 2002-01-30 14:37:00
 | [NAME] | 20 | 490 | 510 | 39.9 | 41.5 | 0.51 | 2002-01-30 14:37:00
 | CL X2 | 20 | 495 | 515 | 38 | 39.6 | 0.49 | 2002-01-30 14:37:00
 | [NAME] | 20 | 500 | 520 | 36.6 | 38.1 | 0.47 | 2002-01-30 14:37:00
 | CL F3 | 20 | 505 | 525 | 35.3 | 36.7 | 0.45 | 2002-01-30 14:37:00
 | CL G3 | 20 | 510 | 535 | 34.2 | 35.9 | 0.44 | 2002-01-30 14:37:00
 | CL M3 | 20.5 | 530 | 560 | 30.5 | 32.2 | 0.4 | 2002-01-30 14:37:00
 | CL Z3 | 20.5 | 540 | 570 | 27 | 28.6 | 0.36 | 2002-01-30 14:37:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 721968d1614967488-how-to-use-the-concatenate-function-like-an-array-function-sample2
Sheet: Sheet2

 |  |  | Helper
j |  | rrr |  |  | j
j |  | ff
w |  | d
j |  | jk
a |  | h
j |  | i
w |  | hjk
Spreadsheet: 792594d1660997718-find-the-last-non-empty-row-test3
Sheet: Phase1

Date | Week # | Days P/W | Rate P/W | Booked  (forcasted) | Completed (forcasted ) | Booked  (actuals) | Completed  (actuals ) | Remaining Jobs
 | 0 |  |  |  |  |  |  | 1669
 | 1 | 4 | 70 |  | 220 | 250 | 200
 | 2 | 5 | 70 |  | 300 | 320 | 180
 | 3 | 5 | 70 |  | 240 | 300 | 320
 | 4 | 5 | 70 |  | 350 | 234 | 250
 | 5 | 5 | 70 |  | 320 | 350 | 300
 | 6 | 5 | 70 |  | 330
 | 7 | 5 | 70
 | 8 | 5 | 70
 |  |  |  |  | Actuals/ Average
 |  |  |  |  | Actuals/ Est Weeks to End
Spreadsheet: 813479d1673807392-pls-help-average-with-if-conditions-need-average-of-each-product-specified-by-year-and-market-entry-date-for-blank-1
Sheet: Product Price & Average

Data |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  |  |  |  |  | 2017 |  |  | 2018 |  |  | 2019 |  |  | 2020 |  |  | 2021 |  |  | 2022 |  |  | 2023 |  |  | 2024
Product ID | Product Name | Amount | Effective Date | Expiration Date | Start Year | End Year |  | Product ID | Product Name | Market Entry Date | Market Entry Year | Average Amt for 2017 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2018 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2019 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2020 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2021 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2022 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2023 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2024 | % Increased based on previous year | Amount Increased Based on Previous Year
1003 | Candy A | 8754.9 | 2018-01-01 00:00:00 | 2018-12-31 00:00:00 |  |  |  | 1003 | Candy A
1003 | Candy A | 9297.7 | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 |  |  |  | 1004 | Candy B
1003 | Candy A | 9985.73 | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 |  |  |  | 1005 | Candy C
1003 | Candy A | 10604.85 | 2021-01-01 00:00:00 | 2022-01-13 00:00:00 |  |  |  | 1006 | Candy D
1003 | Candy A | 11124.49 | 2022-01-14 00:00:00 | 2023-01-02 00:00:00
1003 | Candy A | 11680.71 | 2023-01-03 00:00:00 | 4700-12-31 00:00:00
1004 | Candy B | 370.29 | 2013-12-27 00:00:00 | 2014-06-30 00:00:00
1004 | Candy B | 388.44 | 2014-07-01 00:00:00 | 2014-12-30 00:00:00
1004 | Candy B | 415.24 | 2014-12-31 00:00:00 | 2015-12-22 00:00:00
1004 | Candy B | 443.89 | 2015-12-23 00:00:00 | 2016-12-25 00:00:00
1004 | Candy B | 465.64 | 2016-12-26 00:00:00 | 2017-12-21 00:00:00
1004 | Candy B | 497.77 | 2017-12-22 00:00:00 | 4700-12-31 00:00:00
1005 | Candy C | 3225.88 | 2022-09-13 00:00:00 | 2023-01-02 00:00:00
1005 | Candy C | 3451.69 | 2023-01-03 00:00:00 | 4700-12-31 00:00:00 |  |  |  |  |  | Not pulling data correctly based on Product ID
1006 | Candy D | 18272.79 | 2022-12-15 00:00:00 | 2023-01-02 00:00:00 |  |  |  |  | 1st Condition | if product ID in I Column matches Product ID Data Table
1006 | Candy D | 19734.61 | 2023-01-03 00:00:00 | 4700-12-31 00:00:00 |  |  |  |  | 2nd Condition | if start year and end year matches year in S2
 |  |  |  |  |  |  |  |  | 3rd Condition | then give me the average of Amount
 |  |  |  |  |  |  |  |  |  | =[NAME] Year],2019)
 |  |  |  |  |  |  |  |  |  | =AVERAGE(IF(TableData[[Start Year]:[End Year]]=2019,TableData[Amount]))
Spreadsheet: 0ca2d36a-314a-4d50-b2dd-898833674ade
Sheet: EPA

FY14 FRINGE BENEFIT WORKSHEET - EPA
Name:
FTE: |  | Enter a value between .50 and 1.00
Hired Prior to 7/1/96? |  | Select Yes or No
State or Optional Retirement? |  | Select State, Optional, or Not Applicable
Description | Object Code | Factor | [NAME] | Annual | Monthly
Salary | 11XX, 13XX
BENEFITS
Social Security1 | 1812
Medicare | 1813
State Retirement2 | 1822
Optional State Retirement3 | 187X
Health Insurance | 1832
Unemployment, workers compensation, etc . | 1892
Transit Tax | 3914
Communication Technologies Core Fee | 3225
Professional Liability | 1803 | Enter Amount
Total Benefits
TOTAL COMPENSATION
 |  |  |  | Benefits as % of Salary =
NOTES:
Spreadsheet: 275626d1383591388-staff-hierarchy-extraction-formula-missing-some-reports-results-hierarchy_extractor
Sheet: Sheet1

Emp No | First Name | Last Name | Manager No | Show |  | 3 | Emp No | First Name | Last Name | Manager No
1 | A | Smith
2 | B | Jones | 1
3 | C | [NAME] | 2
4 | D | Yates | 2
5 | E | Fowler | 2
6 | F | [NAME] | 4
7 | G | [NAME] | 4
8 | H | Cooper | 5
9 | I | White | 3
10 | J | King | 3
Spreadsheet: 876321d1723016798-excel-offset-column-with-in-the-date-range-based-on-another-column-value-book1
Sheet: Sheet1

 |  |  | COST DATA |  |  |  |  |  |  |  |  | CASHFLOW
 | Terms of Payment |  | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 |  | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00
PO1 | 30 |  | 1000 | 0 | 0 | 10000 | 0 | 20000 | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
PO2 | 45 |  | 0 | 10000 | 0 | 0 | 50000 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 |  | 0
PO3 | 60 |  | 1000 | 0 | 10000 | 0 | 0 | 20000 | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Need  solution to update the column from M to T
Spreadsheet: 88519d1288311978-counting-how-many-testcase
Sheet: Sheet1

fruit | weight
apple | 1.2
apple | 2.2
apple | 3.1
apple | 6
orange | 1
orange | 1.3
orange | 2.3
orange | 3.1
banana | 2.3
banana | 3.1
Spreadsheet: 864472d1711632747-sumif-with-date-criteria-cmck_sum
Sheet: Sheet2

Supplier | NoOfCertificates | StartDate |  |  | Total Certificates
Supplier 1 | 2078 | 2009-09-10 00:00:00 |  | Supplier 1
Supplier 5 | 2 | 2009-10-16 00:00:00 |  | Supplier 5
Supplier 3 | 23 | 2010-06-22 00:00:00 |  | Supplier 3
Supplier 6 | 5 | 2010-06-25 00:00:00 |  | Supplier 6
Supplier 6 | 1 | 2022-07-08 00:00:00 |  | Supplier 4
Supplier 6 | 2 | 2010-07-08 00:00:00 |  | Supplier 2
Supplier 4 | 2 | 2010-07-27 00:00:00 |  | 0
Supplier 4 | 21 | 2010-07-27 00:00:00
Supplier 1 | 402 | 2010-08-31 00:00:00
Supplier 1 | 1624 | 2010-08-31 00:00:00
Supplier 2 | 49 | 2022-03-31 00:00:00
Supplier 2 | 47 | 2022-04-02 00:00:00
Supplier 2 | 69 | 2022-04-02 00:00:00
Supplier 2 | 170 | 2022-04-02 00:00:00
Supplier 2 | 73 | 2022-03-31 00:00:00
Supplier 2 | 111 | 2022-03-31 00:00:00
Supplier 2 | 10 | 2022-03-31 00:00:00
Supplier 2 | 46 | 2022-03-31 00:00:00
Supplier 2 | 181 | 2022-04-02 00:00:00
Spreadsheet: 782858d1654347453-how-to-transform-data-array-from-vertical-to-horizontal-layout-forumhelp6-4-aligw
Sheet: Sheet1

Name | Date | Type |  |  | Name | Date | Type1 | Type2 | [NAME] | Type4
[NAME] | 2022-06-01 00:00:00 | A1 |  |  |  | 2022-06-01 00:00:00 |  | A2 | A3
[NAME] | 2022-06-01 00:00:00 | A2 |  |  | [NAME] | 2022-06-03 00:00:00 |  | F1 | G2 | H5
[NAME] | 2022-06-01 00:00:00 | A3
[NAME] | 2022-06-03 00:00:00 | E1
[NAME] | 2022-06-03 00:00:00 | F1
[NAME] | 2022-06-03 00:00:00 | G2
[NAME] | 2022-06-03 00:00:00 | H5
Spreadsheet: 164800d1340894830-vlookup-with-partial-match-one-way-of-looking
Sheet: Sheet2

 | serial |  | START REF>>> | X130V44B001 |  | HELPER
 | X129V45A679 |  |  | X234G12B123 |  | X129V45A-1
 | X129V45A678 |  |  | X234G12B126 |  | X234G12B-1
 | X234G12B123 |  |  | X234G12B125 |  | X130V44B-1
 | X130V44B055 |  |  |  |  | X129V45A-2
 | X129V45A680 |  |  |  |  | X234G12B-2
 | [NAME] |  |  |  |  | X234G12B-3
 | X234G12B126 |  |  |  |  | X130V44B-2
 | X130V44B057 |  |  |  |  | X129V45A-3
 | X129V45A681 |  |  |  |  | X234G12B-4
 | X234G12B125 |  |  |  |  | X130V44B-3
 | [NAME]
Spreadsheet: 87245d1287082499-excel-2007-if-conditions-relcal
Sheet: Sheet1

 | Assembly 1 | Assembly 2 | Assembly 3 | Assembly 4 | Assembly 5 | Assembly 6 | Assembly 7 | Assembly 8 | Assembly 9 | Assembly 10
Sub-Assembly 1 | 0.9 | 0.9 | 0.9 | N/a
Sub-Assembly 2 | 0.8 | 0.8 | n/a | N/A
Sub-Assembly 3 | 0.7 | n/a | n/a | N/a
Assembly Reliability |  |  | 0.9 | N/a
System Rel.
If all 3 cells have N/A value --->E5 display N/A
If C2 has value (.9), and C3 and C4 N/A then C5 = .9
If B2 = .9, B3=.8, B4=N/A then D5 = 1-(1-.9)*(-1-.8)=.98
If A2= .9, A3=.8, A4=.7 then A5 = 1-(1-.9)*(1-.8)*(1-.7) = .9940
Spreadsheet: 63845d1264705345-if-isnumber-question-kw-formula
Sheet: Sheet1

Product/ID | Name |  |  |  | Home
DV337AEG/XAA | DRYER |  | RF | 1 | REFRIGERATOR
RF267AARS/XAA | REFRIGERATOR |  | RS | 2 | REFRIGERATOR
WE357A7L/XAA | #N/A |  | WF | 3 | WASHER
WF448AAW/XAA | WASHER |  | DV | 4 | DRYER
DV337AER/XAA | DRYER |  | DMR | 5 | DISHWASHER
RF267ABBP/XAA | REFRIGERATOR |  | SMH | 6 | MICROWAVES
RS267LBSH/XAA | REFRIGERATOR |  | FT | 7 | RANGE
RS265LBBP/XAA | REFRIGERATOR |  | FC | 8 | RANGE
DMR265LBBP/XAA | #N/A |  | AW | 9 | AIR
Spreadsheet: 62520d1263447025-copying-cells-from-one-worksheet-to-another-based-on-certain-conditions-draft-hot-list-2
Sheet: Hot List

Aging | Element / Module | Question Number | Rating | Finding | Reference | Root Cause | Corrective Action | Assigned To | Target Completion Date | Actual Completion Date | Status / Comments | TCCMS CAP Audit             ([NAME])                Status / Comments | Days Past Due
Over 90 Days Past Due
 |  |  |  |  |  |  |  |  | 2009-10-01 00:00:00
 |  |  |  |  |  |  |  |  | 2009-12-15 00:00:00
 |  |  |  |  |  |  |  |  | 2009-09-09 00:00:00
 |  |  |  |  |  |  |  |  | 2009-10-10 00:00:00
60 to 90 Days Past Due
 |  |  |  |  |  |  |  |  | 2009-11-04 00:00:00
 |  |  |  |  |  |  |  |  | 2009-11-01 00:00:00
 |  |  |  |  |  |  |  |  | 2009-10-28 00:00:00
30 to 60 Days Past Due
 |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00
 |  |  |  |  |  |  |  |  | 2009-11-15 00:00:00
Spreadsheet: 701584d1603818428-subtracting-time-sample
Sheet: Sheet1

Date | Time (Start) | Time (End) | Duration (H:M)
2015-10-22 00:00:00 | 2015-10-22 13:30:00 | 10/22/2015  19:30:00 PM
2015-10-24 00:00:00 | 2015-10-24 10:10:00 | 10/24/2015  16:10:00 AM
2015-11-07 00:00:00 | 2015-11-07 19:50:00 | 2015-11-08 19:50:00
2015-11-24 00:00:00 | 11/24/2015  17:00:00 PM | 2015-11-24 00:00:00
2015-12-03 00:00:00 | 12/3/2015  15:30:00 PM | 2015-12-03 00:00:00
2015-12-22 00:00:00 | 2015-12-22 00:00:00 | 2015-12-22 00:00:00
Spreadsheet: 3484d3ae-ef88-4372-8885-1cf16d1d11f8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7907 | 29822 | [NAME] | Brackett | USA | 4824 | 00:40:15 | [NAME] | 01:28:41 | 00:05:28 | 01:05:47 | 1 | 03:26:25
7907 | 66031 | Sibyl | [NAME] | USA | 4825 | 00:42:27 | 00:07:03 | 01:42:16 | 00:06:18 | 01:02:16 | 2 | 03:40:21
7907 | 8163 | Peggy | Mcdowell-Cramer | USA | 4827 | 00:34:37 | 00:07:21 | 01:40:40 | 00:05:29 | 01:17:12 | 3 | 03:45:21
7907 | 13350 | [NAME] | Val | USA | 4828 | [NAME] | 00:08:13 | 01:40:47 | 00:06:41 | 01:14:04 | 4 | 03:58:49
7907 | 29676 | [NAME] | [NAME] | USA | 4826 | 00:47:51 | 00:09:30 | 01:33:37 | 00:06:18 | 01:23:19 | 5 | [NAME]
7907 | 64609 | Valma | [NAME] | AUS | 4829 | [NAME] | 00:07:23 | 02:04:22 | 00:05:45 | 01:25:40 | 6 | 04:27:16
Spreadsheet: a28d82ae-dec8-4c26-a1bf-7034ffa91078
Sheet: Ricerca

 |  |  |  |  |  |  | Ricorrenze
 | Testo da trovare: |  | [NAME] | Risultati | Riga | nascondi | nascondi
 | mente* |  | 1
 | Per cercare tutti i testi che contengono una certa parola digita il segno [NAME] e dopo la parola (es. *parola*).  Per trovare tutti i testi che iniziano con una certa parola, inserisci l'asterisco prima della parola (es *parola)  Per trovare tutti i testi che finiscono con una certa parola, digita l'asterisco dopo la parola (es parola*)  Se un utilizzi l'asterisco, Excel troverà solo le ricorrenze esatte
Spreadsheet: 688156d1595593338-retrieving-table-headers-kopie-von-sample_loc_2darray
Sheet: Sheet1

 | A | B | C | D | E |  |  | A | B | C | D | E
A |  |  |  |  |  |  | A
B | 0.874 |  |  |  |  |  | B | 0.874
C | 0.835 | 0.759 |  |  |  |  | C | 0.835 | 0.759
D | 0.965 | 0.827 | 0.749 |  |  |  | D | 0.965 | 0.827 | 0.749
E | 0.876 | 0.987 | 0.775 | 0.821 |  |  | E | 0.876 | 0.987 | 0.775 | 0.821
F | 0.998 | 0.888 | 0.846 | 0.959 | 0.891 |  | F | 0.998 | 0.888 | 0.846 | 0.959 | 0.891
 |  |  | Row | Column |  |  |  |  |  | Row | Column
 |  | 0.998 |  |  |  |  |  |  | 0.998
 | A | B | C | D | E |  |  | A | B | C | D | E
A |  |  |  |  |  |  | A
B | 0.874 |  |  |  |  |  | B | 0.874
C | 0.835 | 0.759 |  |  |  |  | C | 0.835 | 0.759
D | 0.965 | 0.827 | 0.749 |  |  |  | D | 0.965 | 0.827 | 0.749
E | 0.876 | 0.987 | 0.775 | 0.821 |  |  | E | 0.876 | 0.987 | 0.775 | 0.821
F | 0.998 | 0.888 | 0.846 | 0.959 | 0.891 |  | F | 0.998 | 0.888 | 0.846 | 0.959 | 0.891
 |  |  | Row | Column |  |  |  |  |  | Row | Column
 |  | 0.998 |  |  |  |  |  |  | 0.998
Spreadsheet: 770881d1646318311-multiple-if-statements-testsheet
Sheet: Sheet1

Todays Date:
Required | Time OS | Passed
2022-03-01 00:00:00 | 6:27:20 | 0
2022-03-02 00:00:00 | 4:21:20 | 1
2022-03-03 00:00:00 | 3:06:40 | 0
2022-03-04 00:00:00 | 11:12:30 | 1
2022-03-05 00:00:00 | 5:55:00 | 0
Spreadsheet: 157894d1337909720-programming-conditional-formulas-1767budget
Sheet: Sheet1

 | DA | TOTAL $ | TOTAL BUDGET | OPERATING | FOOD COST | MANAGEMENT | PAYROLL BUDGET
WEEK 1 | 892
WEEK 2 | 832
WEEK 3 | 835
WEEK 4 | 835
TOTAL | 848.5
OVERALL CHART
0 | 802 | 0.774
803 | 834 | 0.774
835 | 865 | 0.769
866 | 897 | 0.765
898 | 929 | 0.764
930 | 960 | 0.757
961 | 992 | 0.742
993 | 1023 | 0.732
1024 | 1055 | 0.723
1056 | 1086 | 0.708
1087 | 1118 | 0.702
1119 | 1150 | 0.695
1151 | 1181 | 0.684
1182 | 1213 | 0.679
1214 | 1244 | 0.67
1245 | 1276 | 0.664
1277 | 1308 | 0.66
1309 | 1339 | 0.654
1340 | 1371 | 0.649
1372 | 1402 | 0.644
1403 | 1434 | 0.639
1435 | 1465 | 0.636
1466 | 1497 | 0.636
1498 | 1529 | 0.633
1530 | 1560 | 0.628
1561 | 1592 | 0.625
1593 | 1623 | 0.625
1624 | 1655 | 0.625
1656 | 1687 | 0.625
1688 | 1718 | 0.624
1719 | 1750 | 0.621
1751 | 1781 | 0.618
1782 | 1813 | 0.618
1814 | 1844 | 0.616
1845 | 1876 | 0.613
1877 | 1908 | 0.609
1909 | 1939 | 0.606
1940 | 1971 | 0.605
1972 | 2002 | 0.604
2003 | 2034 | 0.601
2035 | 266 | 0.598
2067 | 2097 | 0.596
2098 | 2129 | 0.591
2130 | 2160 | 0.589
2161 | 2192 | 0.587
2193 | 2223 | 0.585
2224 | 99999 | 0.583
Spreadsheet: 159788d1338843035-excel-2007-i-need-a-formula-to-calculate-six-months-at-a-time-from-separate-sheet-tabs-hr-calendar-with-formulas
Sheet: Jul

 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY |  | 1. Absent - EX  2. Absent - UN  3. Bereavement  4. Discipline  5. FMLA  6. Tardy
 |  |  | NOTES:
 |  |  | Type in Employee's Last Name and the Corresponding Number
Spreadsheet: 678102d1589715832-index-match-for-auto-costings-calculations-bizcostings-sample
Sheet: autoCostings

list | day | week | month | qtr | bi-annual | year |  | cost category
daily |  |  |  |  |  |  |  | business cost
weekly |  |  |  |  |  |  |  | businss loan
monthly |  |  |  |  |  |  |  | charity
quarterly |  |  |  |  |  |  |  | subscriptions
6 months |  |  |  |  |  |  |  | personal loan
yearly |  |  |  |  |  |  |  | other costs
2 years
3 years
4 years
5 years
paused | Paused | Paused | Paused | Paused | Paused | Paused
Spreadsheet: kay_mann__19201__ABB - New Option Allocation
Sheet: XNPV Payments

ABB Tranformer Payments Due
2000-12-08 00:00:00 | 2000-12-13 00:00:00 | 2001-01-13 00:00:00 | 2001-02-13 00:00:00 | 2001-03-13 00:00:00 | 2001-04-13 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00
 |  |  | 0 |  | 0 |  |  |  | 0 | 0
ESA Cancellation
 | Coral Pymt #3 |  |  | Coral Pymt #4
 | PSCO Pymt #2 | PSCO Pymt. #3 |  |  |  | PSCO Pymt #4
 |  |  |  |  |  |  | LV Pymt #2 | LV Pymt #3 |  |  | LV Pymt #4
Discount Rate | 0.08
Nominal Value
XNPV
Discount
1 Payment #5 for each set of transformers represents the 10% retainment amount to be paid the earlier of 36 months after Acceptance or 24 months after COD and is not shown in these calculations.