tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 79ffdace-cd8e-4c29-8c11-6805632244cc
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
[NAME] | Test | [NAME] | Alpha-1-Antitrypsin Clearance, Feces and Serum | Alpha-1-Antitrypsin Clearance | Nephelometry | Serum Gel Tube: SGT |  |  |  | Varies | Feces and serum are required.    Blood must be drawn during the stool collection period.   [NAME] Type: Serum	 Collection Container/Tube: Red top or serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL   Specimen Type: Stool Container/Tube: Stool container (Supply T291) [NAME]: Entire collection Collection Instructions:  1. Collect a 24-hour stool collection. 2. If no specimen is obtained in 24 hours, extend collection to 48 to 72 hours. Note time frame. 3. See Stool Collection Information Sheet in Special Instructions. | Homogenized Stool: 1 mL/Serum: 0 | Hemolysis	Feces: NA Serum: Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Feces: NA Serum: Mild OK; [NAME] OK Icterus	Feces: NA Serum: Mild OK; [NAME] OK Other	NA | Clearance: < or =27 mL/24 hours Fecal alpha-1-antitrypsin concentration: < or =54 mg/dL Serum alpha-1-antitrypsin concentration: 100-190 mg/dL | Monday through Saturday; 2 p.m. | Same day/1 day | 2 days |  | Profile |  |  |  |  | Rochester
[NAME] | [NAME] | SERUM | Serum |  |  |  | Frozen | 14 days
[NAME] | [NAME] | FECAL | Fecal |  |  |  | Frozen | 14 days
[NAME] | Component | [NAME]_ | Clearance | Clearance | Nephlometry | Serum Gel Tube: SGT |  |  | 1 | mL |  | 0.5 mL |  |  | Monday through Saturday; 2 p.m. | Same day/1 day | 2 days |  |  |  |  | Yes | No
[NAME]_ | [NAME] | SERUM | Serum |  |  |  | Frozen | 14 days
[NAME]_ | Order Question | HOURS | Hours |  | Plain Text
[NAME]_ | Result | CRCLR | Clearance | Clearance | Numeric |  |  |  |  | mL/24 h |  |  |  |  |  |  |  |  |  | In Process
[NAME]_ | Result | AATS | Alpha-1-Antitrypsin, S | Alpha-1-Antitrypsin, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 6771-0
[NAME] | Component | A1A24 | Alpha-1-Antitrypsin, 24 Hour, Feces | Alpha-1-Antitrypsin, 24 Hr, F | Nephelometry The recommended procedure for protein-losing enteropathy is #8835 "Alpha-1-Antitrypsin Clearance, Feces and Serum." Only orderable as part of a profile. For further information see #8835 "Alpha-1-Antitrypsin Clearance, Feces and Serum." |  |  |  |  |  | Only orderable as part of a profile. For further information see #8835 Alpha-1-Antitrypsin Clearance, Feces and Serum. |  |  | Only orderable as part of a profile. For further information see #8835 "Alpha-1-Antitrypsin Clearance, Feces and Serum." |  |  |  | 1 | 82103 |  |  | Yes | No
A1A24 | [NAME] | FECAL | Fecal |  |  |  | Frozen | 14 days
A1A24 | Result | [NAME] | Alpha-1-Antitrypsin, 24 Hr, F | Alpha-1-Antitrypsin, 24 Hr, F | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 46429-7
Spreadsheet: 55764d1255962984-add-names-based-on-number-of-question-correct-math-data-class-plan-3rd-gr
Sheet: Class Plan

Math Data – Class Plan – 3rd Grade
Individual Student Groupings based on Summative Assessment
TTC in G | SF and T | L in the H | C and C/Up and [NAME] | Fair Shares | FP to F | ES and B
Q 27 - 32 | Q 13 - 15 | Q 20 – 23, 26 | Q 1 – 5 | Q 9 – 12 | Q 5, 16 – 19, 24, 25, 34, 36 | Q 6 - 8
Below  Average Performance | Below Average Performance | Below Average Performance | Below Average Performance | Below Average Performance | Below Average Performance | Below Average Performance
Average Performance | Average Performance | Average Performance | Average Performance | Average Performance | Average Performance | Average Performance
Above Average Performance | Above Average Performance | Above Average Performance | Above Average Performance | Above Average Performance | Above Average Performance | Above Average Performance
Excellent Performance | Excellent Performance | Excellent Performance | Excellent Performance | Excellent Performance | Excellent Performance | Excellent Performance
Spreadsheet: 3986a1ea-af84-4840-a3ee-5802684c84ac
Sheet: Report

Unit | Unit Priority | [NAME] | Objective Id | Objective Name | Objective Priority | Strategic Direction | Impact Type
Distance Education | 1 | Provide infrastructure to support DE courses and services | 1.1 | Identify district and campus level infrastructure needs | 1 | None | -- Pick One --
Distance Education | 1 | Provide infrastructure to support DE courses and services | 1.2 | Integrate online student services into DE and traditional courses | 2 | None | -- Pick One --
Distance Education | 2 | DE Staffing Matrix | 2.1 | Develop Staffing Matrix | 1 | None | -- Pick One --
Distance Education | 2 | Expand DE services offerings | 3.1 | Identify potential services that can meet the DE constituents' needs | 1 | None | -- Pick One --
Distance Education | 2 | Expand DE services offerings | 3.2 | Integrate technology that support DE strategic vision | 2 | None | -- Pick One --
Distance Education | 1 | Faculty/Staff Training | 4.1 | Identify training opportunities for DE Faculty and Staff | 1 | None | -- Pick One --
Distance Education | 1 | Faculty/Staff Training | 4.2 | Professional development plan for DE faculty & staff | 1 | None | -- Pick One --
Distance Education | 1 | Faculty/Staff Training | 4.3 | Develop web-based training modules | 1 | None | -- Pick One --
Distance Education | 3 | DE Staff Development | 5.1 | Identify training areas related to DE | 2 | None | -- Pick One --
Distance Education | 3 | DE Staff Development | 5.2 | Create training plan for DE staff | 3 | None | -- Pick One --
Spreadsheet: 672902d1587058759-sum-if-issues-with-multiple-columns-of-criteria-sample-project
Sheet: Activities

Location | Activity | Priority | Number of Days | Start Date | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Day 11 | Day 12 | Day 13 | Day 14 | Day 15 | Day 16 | Hours/Day | Number of Employees Needed/Shift | NAME | NAME2 | NAME3 | NAME4 | NAME5 | NAME6 | NAME7 | NAME8 | NAME9 | NAME10
Flow | Mail Delivery Program |  | 2 | 2020-04-20 00:00:00 | 2020-04-21 00:00:00 | False | False | False | False | False | False | False | False | False | False | False | False | False | False | 7 | 2 | A-Justin Smith | B-DJ P
Texas | Organizing |  | 4 | 2020-04-17 00:00:00 | 2020-04-12 00:00:00 | 2020-04-13 00:00:00 | 2020-04-14 00:00:00 | False | False | False | False | False | False | False | False | False | False | False | False | 2 | 3 | A-Tim B | A-Justin Smith | A-Doug D
Texas | Cleaning |  | 5 | 2020-04-15 00:00:00 | 2020-04-16 00:00:00 | 2020-04-17 00:00:00 | 2020-04-18 00:00:00 | 2020-04-19 00:00:00 | False | False | False | False | False | False | False | False | False | False | False | 5 | 2 | A-Tim B | A-Justin Smith
CanAm | Enhanced Technology |  | 8 | 2020-04-16 00:00:00 | 2020-04-22 00:00:00 | 2020-04-23 00:00:00 | 2020-04-24 00:00:00 | 2020-04-25 00:00:00 | 2020-04-26 00:00:00 | 2020-04-27 00:00:00 | 2020-04-28 00:00:00 | False | False | False | False | False | False | False | False | 6 | 1 | A-Doug D
CanAm | Training |  | 13 | 2020-04-15 00:00:00 | 2020-04-16 00:00:00 | 2020-04-17 00:00:00 | 2020-04-18 00:00:00 | 2020-04-19 00:00:00 | 2020-04-20 00:00:00 | 2020-04-21 00:00:00 | 2020-04-22 00:00:00 | 2020-04-23 00:00:00 | 2020-04-24 00:00:00 | 2020-04-25 00:00:00 | 2020-04-26 00:00:00 | 2020-04-27 00:00:00 | False | False | False | 9 | 1 | A-Tim B
CanAm | DT Codes |  | 2 | 2020-04-16 00:00:00 | 2020-04-17 00:00:00 | False | False | False | False | False | False | False | False | False | False | False | False | False | False | 4 | 2 | B-DJ P | A-Justin Smith
Spreadsheet: 3f747a9e-520a-45e7-a27a-574d101a4104
Sheet: Sheet1

Unnamed: 0 | HORARIO ATENCION DE NUESTRA OFICINAS COMERCIALES | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | ZONA RANCO
 | CIUDAD | DIRECCION | DIAS | MAÑANAS | TARDES
 | CORRAL | Condell S/N | Lunes y [NAME] | 09:00 a 12:30 Hrs. | 15:00 a 17:30 Hrs.
 | FUTRONO | [NAME] 130 | [NAME] | 09:00 a 12:30 Hrs.
 | [NAME] | [NAME] | Lunes a Viernes | 08:30 a 12:30 Hrs.
 | LAGO RANCO | La Serena Nº 204 | Miércoles | 09:00 a 12:30 Hrs. | 15:00 a 17:30 Hrs.
 | LOS LAGOS | [NAME] 147 | Lunes a Viernes | 08:30 a 12:30 Hrs.
 | LA UNION | Letelier S/N Edifício Publico - 2º Piso | Lunes a Viernes | 08:30 a 12:30 Hrs. | 14:30 a 16:30 Hrs.
 | MAFIL | [NAME] | Martes | 09:00 a 12:30 Hrs. | 15:00 a 17:30 Hrs.
 | PAILLACO | Camilo Henríquez Nº 611 | Lunes, [NAME] | 08:30 a 12:30 Hrs.
 | PANGUIPULLI | Alessandri 105 [NAME]. PP. | Lunes a Viernes | 08:30 a 12:30 Hrs.
 | RIO BUENO | San Martín Nº 1480 | Lunes a Viernes | 08:30 a 12:30 Hrs. | 14:30 a 16:30 Hrs.
 | SAN JOSE | [NAME] 1202, Local B | Lunes, [NAME] | 08:30 a 12:30 Hrs.
 | ZONA PUYEHUE
 | CIUDAD | DIRECCION | DIAS | MAÑANAS | TARDES
 | OSORNO | [NAME] | Lunes a Viernes | [NAME]. | [NAME].
 | PURRANQUE | Martinez de Rosas Nº 276 | Lunes, [NAME] | 08:30 a 12:30 Hrs.
 | RIO NEGRO | [NAME] | Lunes a Viernes | 08:30 a 12:30 Hrs.
 | SAN PABLO | Cruz S/N | Martes | 08:30 a 13:00 Hrs. | 15:00 a 16:30 Hrs.
 | ZONA LLANQUIHUE
 | CIUDAD | DIRECCION | DIAS | MAÑANAS | TARDES
 | ALERCE | [NAME] 999 | Lunes a Viernes | 08:30 a 12:30 Hrs. | 14:30 a 16:30 Hrs.
 | CALBUCO | Pdte. Ibañez S/N | Lunes a Viernes | 08:45 a 12:45 Hrs.
 | CHAITEN | Libertad Nº 408 | Martes, [NAME] | 09:00 a 12:30 Hrs.
 | FRESIA | [NAME] | Lunes a Viernes | 08:30 a 12:30 Hrs.
 | FRUTILLAR | [NAME] 500 | Martes y Jueves | 08:30 a 12:30 Hrs.
 | FUTALEUFU | [NAME] | Lunes a Viernes | 08:30 a 12:30 Hrs.
 | LLANQUIHUE | Matta esquina San Martín | Lunes, [NAME] | 08:30 a 12:30 Hrs.
 | LOS MUERMOS | [NAME] 400 | [NAME] | 09:00 a 12:30 Hrs.
 | MAULLIN | [NAME] 69 | Martes | 09:00 a 12:30 Hrs. | 14:30 a 17:00 Hrs.
 | PUERTO MONTT | Benavente Nº 532 | Lunes a Viernes | [NAME]. | [NAME].
 | PUERTO VARAS | San Jose Nº 224 | Lunes a Viernes | 08:30 a 12:30 Hrs. | 14:30 a 16:30 Hrs.
 | ZONA HUILLINCO
 | CIUDAD | DIRECCION | DIAS | MAÑANAS | TARDES
 | ACHAO | [NAME] 32 | Martes y Jueves | 09:00 a 12:30 Hrs.
 | ANCUD | Anibal Pinto Nº 338 | Lunes a Viernes | 08:30 a 12:30 Hrs. | 14:30 a 16:30 Hrs.
 | CASTRO | Diego Portales Nº 598 | Lunes a Viernes | 08:30 a 12:30 Hrs. | 14:30 a 16:30 Hrs.
 | CHONCHI | Sargento Candelaria S/N | Lunes y Martes | 09:00 a 12:30 Hrs.
 | DALCAHUE | [NAME] 165 | [NAME] | 09:00 a 12:30 Hrs.
 | QUELLON | 22 de Mayo Nº 345 | Lunes a Viernes | 08:30 a 12:30 Hrs.
Spreadsheet: a984cf02-7510-4d84-b18e-4f9086984606
Sheet: TTM Recon Q1FY11

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations - Trailing Twelve Months (TTM)
(in millions, except per share data)
 | Trailing Twelve Months Ended June 30, 2010
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Lease Obligation (G&A) |  | Loss on licensed intellectual property commitment (COGS) |  | Loss on Strategic Investments |  | Restructuring Charges |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 3825 |  | 0 |  | 57 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3882
Cost of goods sold | 1767 |  | -10 |  | 0 |  | 0 |  | 3 |  | 0 |  | 0 |  | -2 |  | 0 |  | 1758
Gross profit | 2058 |  | 10 |  | 57 |  | 0 |  | -3 |  | 0 |  | 0 |  | 2 |  | 0 |  | 2124
Operating expenses:
Marketing and sales | 693 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -17 |  | 0 |  | 676
General and administrative | 328 |  | 0 |  | 0 |  | -14 |  | 0 |  | 0 |  | 0 |  | -40 |  | 0 |  | 274
Research and development | 1192 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -116 |  | 0 |  | 1076
Acquisition-related contingent consideration | 4 |  | -4 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 56 |  | -56 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring charges | 128 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -128 |  | 0 |  | 0 |  | 0
Total operating expenses | 2401 |  | -60 |  | 0 |  | -14 |  | 0 |  | 0 |  | -128 |  | -173 |  | 0 |  | 2026
Operating income (loss) | -343 |  | 70 |  | 57 |  | 14 |  | -3 |  | 0 |  | 128 |  | 175 |  | 0 |  | 98
Loss on strategic investments | -15 |  | 0 |  | 0 |  | 0 |  | 0 |  | 15 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3
Income (loss) before provison for (benefit from) income taxes | -355 |  | 70 |  | 57 |  | 14 |  | -3 |  | 15 |  | 128 |  | 175 |  | 0 |  | 101
Provision for (benefit from) income taxes | -8 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 36 |  | 28
Net income (loss) | -347 |  | 70 |  | 57 |  | 14 |  | -3 |  | 15 |  | 128 |  | 175 |  | -36 |  | 73
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic and diluted | -1.08 |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.22
Spreadsheet: 854651d1704451909-formula-to-tell-me-how-many-more-or-less-are-needed-forum-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REQUIRED
 |  |  |  | F2F | Pre-Bookable | Total |  | F2F needed to be added | Pre-Bookable to be added |  |  |  |  |  |  | Face 2 Face |  | Pre-Bookable
 |  | 2024-01-15 00:00:00 |  | 89 | 79 |  |  |  |  |  |  |  |  |  |  | 90 |  | 60
 |  | 2024-01-16 00:00:00 |  | 92 | 56
 |  | 2024-01-17 00:00:00 |  | 90 | 54
 |  | 2024-01-18 00:00:00 |  | 92 | 16
 |  | 2024-01-19 00:00:00 |  | 88 | 8
 |  | 2024-01-22 00:00:00 |  | 76 | 25
 |  | 2024-01-23 00:00:00 |  | 79 | 15
 |  | 2024-01-24 00:00:00 |  | 80 | 24
 |  | 2024-01-25 00:00:00 |  | 77 | 15
 |  | 2024-01-26 00:00:00 |  | 48 | 16
 |  | 2024-01-29 00:00:00 |  | 103 | 39
 |  | 2024-01-30 00:00:00 |  | 73 | 26
 |  | 2024-01-31 00:00:00 |  | 101 | 29
 |  | 2024-02-01 00:00:00 |  | 32 | 15
 |  | 2024-02-02 00:00:00 |  | 75 | 31
Spreadsheet: 7bdb8ad6-0ff7-4c8b-b088-e94cef1d4d50
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
8909 | 21752 | Kaarel | [NAME] | EST | 262 | 00:17:18 | 00:01:08 | 00:27:57 | 00:02:47 | 00:16:58 | 1 | [NAME]
Spreadsheet: 835823d1688868834-help-to-modify-conditional-formatting-formulas-that-display-on-time-and-late-based-on-time-conditional-formatting-sample-hd
Sheet: Sheet1

Date/Scheduled Depart time | Start Time | Actual [NAME] time
2023-07-01 10:30:00 | 10:00:00 | 10:45:00
2023-07-01 10:30:00 | 10:00:00 | 10:28:00
2023-07-01 10:30:00 | 10:00:00 | 10:30:00
2023-07-02 01:30:00 | 22:00:00 | 23:40:00
2023-07-02 02:30:00 | 23:00:00 | 23:45:00
2023-07-02 03:30:00 | 01:00:00 | 03:29:00
Spreadsheet: jeff_dasovich__14199__TP_1_2
Sheet: Orinda

 |  | INPUTS |  |  | OUTPUTS
 | Restaurant Location | Weekly Hours of Operation | Full-time Equivalent Staff | Weekly Supply Expenses | Weekly Profit | Market Share (%) | Annual Growth Rate (%)
1 | Albany | 96 | 16 | 850 | 3800 | 0.25 | 0.08
2 | Berkeley | 110 | 22 | 1400 | 4600 | 0.32 | 0.085
3 | Oakland | 100 | 18 | 1200 | 4400 | 0.35 | 0.08
4 | Lafayette | 125 | 25 | 1500 | 6500 | 0.3 | 0.1
5 | Orinda | 120 | 24 | 1600 | 6000 | 0.28 | 0.09
e | 0.9920634920634921
w1 | 0
w2 | 0
w3 | 0.2380952380952381
w4 | 0.7619047619047621
w5 | 0
e*input
 | Albany
 | Berkeley
 | Oakland
 | Lafayette
 | Orinda
Spreadsheet: kam_keiser__18071__NewBooks
Sheet: Power

CP ID | Short Name | Code | Region | Commodity | Uom | Currency | Commodity/UOM/Curr
166961 | PWR-GAS-OPTION | ME | NYMEX | NG | MMBTU | USD | NG/MMBTU/USD
166966 | PWR-GAS-WMGMT | MJ | NYMEX | NG | MMBTU | USD | NG/MMBTU/USD | deleted
167192 | PWR-GAS-PJM | ME | NYMEX3 | NG | MMBTU | USD | NG/MMBTU/USD
167108 | PWR-GAS-LT-ERCT | ME | NYMEX7 | NG | MMBTU | USD | NG/MMBTU/USD
167109 | PWR-GAS-SE | ME | NYMEX8 | NG | MMBTU | USD | NG/MMBTU/USD
167111 | PWR-GAS-ST-PJM | ME | NYMEX9 | NG | MMBTU | USD | NG/MMBTU/USD
167113 | PWR-GAS-ST-ERCT | ME | [NAME] | NG | MMBTU | USD | NG/MMBTU/USD
167114 | PWR-GAS-ST-NY | ME | [NAME] | NG | MMBTU | USD | NG/MMBTU/USD
167115 | PWR-GAS-ST-MW | ME | [NAME] | NG | MMBTU | USD | NG/MMBTU/USD
167116 | PWR-GAS-OPTB | ME | NYMEX13 | NG | MMBTU | USD | NG/MMBTU/USD
167199 | PWR-GAS-OPTA | ME | NYMEX14 | NG | MMBTU | USD | NG/MMBTU/USD
167200 | PWR-GAS-ST-SE | ME | NYMEX15 | NG | MMBTU | USD | NG/MMBTU/USD
166967 | PWR-GAS-NW | MJ | NYMEX2 | NG | MMBTU | USD | NG/MMBTU/USD
166968 | PWR-GAS-SW | MJ | NYMEX3 | NG | MMBTU | USD | NG/MMBTU/USD
166969 | PWR-GAS-CALI | MJ | NYMEX4 | NG | MMBTU | USD | NG/MMBTU/USD
166973 | PWR-GAS-MGMT | ME | NYMEX1 | NG | MMBTU | USD | NG/MMBTU/USD
166962 | PWR-GAS-NE | ME | NYMEX4 | NG | MMBTU | USD | NG/MMBTU/USD
166963 | PWR-GAS-MW | ME | NYMEX5 | NG | MMBTU | USD | NG/MMBTU/USD
166965 | PWR-GAS-ERCOT | ME | NYMEX6 | NG | MMBTU | USD | NG/MMBTU/USD
Spreadsheet: 758188d1638729098-find-the-max-number-in-the-list-enter-next-check-number
Sheet: Sheet1

 | Check #
 | 417
 | 418
 | 419
 | 420
 | 421
 | 422
 | 423
 | 424
 | 425
 | 426
 | 427
 | 428
 | 429
 | 430
 | 431
 | 432
 | 433
 | 434
 | 435
 | 436
 | 437
 | 438
 | 439
 | 440
 | 441
 | 442
 | 443
 | 444
 | 445
 | 446
 | 447
 | 448
 | 449
 | 450
 | 451
 | 451
 | 452
 | 453
 | 454
 | 455
 | 456
 | 457
 | 458
 | 459
 | 460
 | 461
 | 462
 | 463
 | 464
 | 465
 | 466
 | 467
 | 468
 | 469
 | 470
 | 471
 | 472
 | 473
 | 474
 | 475
 | 476
 | 477
 | 478
 | 479
 | 480
 | 481
 | 482
 | 483
 | 484
 | 485
 | 486
 | 487
 | 488
 | 489
 | 490
 | 491
 | 492
 | 493
 | 494
 | 495
 | 496
 | 497
 | 498
 | 499
 | 500
 | 501
 | 502
 | 503
 | 504
 | 505
 | 506
 | 507
 | 508
 | 509
 | 510
 | 511
 | 512
 | 513
 | 514
 | 515
 | 516
 | 517
 | 518
 | 519
 | 520
 | 521
 | 522
 | 523
 | 524
 | 525
 | 526
 | 527
 | 528
 | 529
 | 530
 | 531
 | 532
 | 533
 | 534
 | 535
 | 536
 | 537
 | 538
 | 539
 | 540
 | 541
 | 542
 | 543
 | 544
 | 545
 | 546
 | 547
 | 548
 | 549
 | 550
 | 551
 | 552
 | 553
 | 554
 | 555
 | 556
 | 557
 | 558
 | 559
 | 560
 | 561
 | 562
 | 563
 | 564
 | 565
 | 566
 | 567
 | 568
 | 569
 | 570
 | 571
 | 572
 | 573
 | 574
 | 575
 | 576
 | 577
 | 578
 | 579
 | 580
 | 581
 | 582
 | 583
 | 584
 | 585
 | 586
 | 587
 | 588
 | 589
 | 590
 | 591
 | 592
 | 593
 | 594
 | 595
 | 596
 | 597
 | 598
 | 599
 | 600
 | 601
E
 | 602
 | 603
E
 | 604
 | 605
 |  |  | [NAME] in B323 is  =IF(A323="E","",MAX(B$7:B377)+1)
 |  |  | B323 should be resulted in 606, Why it shows 000?
 | 606 |  | If I press the formula in B323 using F9 key, it shows 606.
Spreadsheet: 23d768bc-3ab5-4db4-894e-07ad987322e2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 45. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (SA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413770V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413771W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413772X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413773A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413774C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413775F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413776J | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413778L | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413779R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413780X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 691974d1597986828-use-formula-to-auto-sort-cells-in-range-with-blanks-at-bottom-or-ignored-example1835
Sheet: Scheduling INPUT

Start Date of Week (Sunday) |  | 2020-08-02 00:00:00 |  |  |  |  |  |  |  |  |  | Census: | 121-140 |  | Enter Average Deliveries Per Meal Period
Role | Shift Start | Shift End | Scheduled Break | Hours Per Shift | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Scheduled Hours | Budgeted Hours | [NAME]
AM Server 1 | 07:20:00 | 13:20:00 | 0.5
Drink Delivery | 07:30:00 | 09:30:00 | 0
AM Server 3 | 07:00:00 | 08:30:00 | 0
Train Breakfast | 07:00:00 | 10:00:00 | 0
Meal Delivery | 07:00:00 | 09:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  | Breakfast
Meal Delivery | 07:00:00 | 09:30:00 | 0
Lead Server Sat | 11:00:00 | 19:30:00 | 0.5
Noon Serv 1 | 11:30:00 | 14:00:00 | 0
Noon Serv 2 Sun | 11:00:00 | 14:00:00 | 0
Noon Serv 3 Sun | 11:15:00 | 14:15:00 | 0
Noon Serv 4 Sun | 11:30:00 | 14:30:00 | 0
Noon Serv 5 Sun | 11:30:00 | 14:30:00 | 0
Noon Serv 6 Sun | 11:30:00 | 14:30:00 | 0
Meal Delivery | 10:30:00 | 13:00:00 | 0
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  | Lunch
Meal Delivery | 10:30:00 | 13:00:00 | 0
Event | 13:00:00 | 14:30:00 | 0
Train Lunch | 11:00:00 | 14:30:00 | 0
Train Lunch | 11:30:00 | 14:00:00 | 0
[NAME] | 14:30:00 | 19:00:00 | 0
Eve Serv 1 | 16:45:00 | 18:45:00 | 0
[NAME] | 17:00:00 | 19:00:00 | 0
Eve Serv 3 | 17:30:00 | 19:30:00 | 0
[NAME] | 17:10:00 | 19:10:00 | 0
Eve Serv 5 | 17:30:00 | 19:30:00 | 0
Eve Serv 6 | 17:30:00 | 19:30:00 | 0
Eve Serv 7 | 16:30:00 | 19:00:00 | 0
Meal Delivery | 16:30:00 | 19:00:00 | 0
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  | Dinner
Meal Delivery | 16:30:00 | 19:00:00 | 0
Wine & Dine Event | 15:00:00 | 17:00:00 | 0
Bday Dinner Event | 16:45:00 | 19:00:00 | 0
Train Dinner | 16:00:00 | 19:30:00 | 0
Train Dinner | 17:00:00 | 19:00:00 | 0