tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 36b8fef0-7822-4bbb-acc5-dd87f1008dcb
Sheet: Sheet1

Identity Management Groups (IdM) - Updated 9/03/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
*Yellow groups not available as of 10/14/2013
All Respondents | Role/Collection | General Access
All Users | (Given to all users automatically) | X
CDE_External | (Given to all users automatically) | X
IdM Non-Pipeline Groups | Role/Collection | General Access | District Access (Full Access) | District Access (Read Only) | School Only Access | State Administrator (number of roles)
UM | User Manager (Executive Director/Superintendent) | X
GM | Growth Model |  | X |  | X
LAM | Local Access Manager | X
CEDAR | Colorado Educational Data Analysis & Reporting System |  | X |  | X
SSCC | Statewide Standard Course Codes |  | X | X
GPS | Grant Payment System |  | X
FSSDS | Faciltiy Schools Student Data System |  |  |  |  | X
FEDAPP | Consolidated Federal Application | X
RITS | RITS Web application |  | X | X
EDIS | EDIS Web application |  | X | X
STEQ | State Equalization | Transportation(CDE-40)
HQOS | Highly Qualified Online System
Data Pipeline Groups | Role/Collection | [NAME] | LEAUSER | LEAPPROVER
Interchanges
STD | Student interchange | X | X
STF | Staff Interchange | X | X
TI1 | Title I interchange | X | X
SPE | SPED IEP Interchange | X
TSL | Teacher student interchange | X | X
DIS | Discipline interchange | X | X
Snapshots
OCT | Student October | X | X | X
SEY | Student End of Year* | X | X | X
DEC | SPED December count* | X | X | X
SPI | SPED Discipline* | X | X | X
EOY | SPED EOY* | X | X | X
HRD | HR December | X | X | X
MSP | Math & Science partnership* | X | X | X
Year Rounds
DIR | Directory | X | X
RTS | RITS Batch File upload | X | X
EDS | EDIS Batch File upload | X | X
Periodics
ACT | ACT SBD collections | X | X | X
ACC | Access SBD collections | X | X | X
TCP | TCAP SBD collections | X | X | X
RCM | Report Card March | X | X | X
FIN | December Finance | X | X | X
11G | 11th grade assessment | X | X | X
RED | READ | X | X | X
Spreadsheet: 156191d1337206912-order-the-imported-data-book4
Sheet: Sheet1

NAME
IMPORTED DATA GOES UNDER THE RED ROW: |  |  |  |  |  |  |  | DESIRED RESULT:
NAME 1 |  |  |  |  |  |  |  | NAME 1 | 48
random data |  | random data | random data | random data | random data |  |  | [NAME] 2 | 15
random data |  | random data | random data | random data | random data |  |  | NAME 3 | 23
random data | random data | random data | random data | random data | random data |  |  | NAME 4 | 2
random data | random data | random data | random data | random data | random data |  |  | NAME 5 | 55
random data | random data | random data | random data | random data | random data
random data | random data | random data | random data | random data | random data
random data | random data | random data | random data | random data | random data
random data | random data | random data | random data | random data | random data
random data | random data | random data | random data | random data | random data
SUBTOTAL |  |  |  | 48
[NAME] 2
random data |  | random data | random data | random data | random data
random data | random data | random data | random data | random data | random data
random data | random data | random data | random data | random data | random data
SUBTOTAL |  |  |  | 15
NAME 3
random data | random data | random data | random data | random data | random number of rows
random data | random data | random data | random data | random data
random data | random data | random data | random data | random data
random data | random data | random data | random data | random data
random data |  | random data | random data | random data
SUBTOTAL |  |  |  | 23
NAME 4
random data | random data | random data | random data | random data
SUBTOTAL |  |  |  | 2
NAME 5
random data | random data | random data | random data | random data
random data | random data | random data | random data | random data
random data | random data | random data | random data | random data
random data | random data | random data | random data | random data
random data | random data | random data | random data | random data
random data | random data | random data | random data | random data
random data | random data | random data | random data | random data
random data | random data | random data | random data | random data
random data |  | random data | random data | random data
SUBTOTAL |  |  |  | 55
Spreadsheet: darrell_schoolcraft__7335__imball0203
Sheet: WTG inc

 | contract 21816
 | 10518 |  | 13276 |  | 13475 |  | 500176 |  | 500390 |  | 500612
 | WTX Gas Parmer |  | Fred Born #1 |  | WTX Water Systems |  | [NAME] |  | [NAME] |  | TW/WTG Hansford
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 |  |  |  |  |  |  |  |  |  |  | -802 | -906
2 |  |  |  |  |  |  |  |  |  |  | -799 | -906
3 |  |  |  |  |  |  |  |  |  |  | -812 | -906
4 |  |  |  |  |  |  |  |  |  |  | -801 | -906
5 |  |  |  |  |  |  |  |  |  |  | -684 | -906
6 |  |  |  |  |  |  |  |  |  |  | -666 | -906
7 |  |  |  |  |  |  |  |  |  |  | -720 | -906
8 |  |  |  |  |  |  |  |  |  |  | -747 | -906
9 |  |  |  |  |  |  |  |  |  |  | -776 | -906
10 |  |  |  |  |  |  |  |  |  |  | -703 | -414
11 |  |  |  |  |  |  |  |  |  |  | -733 | -709
12 |  |  |  |  |  |  |  |  |  |  | -1042 | -906
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 19523.17
2002-03-12 00:00:00
CBS Volume
 |  |  | 5871
Spreadsheet: 787217d1657694997-an-issue-with-sorting-data-book1-1-
Sheet: List of Applicants

 |  |  | Estimated cost for course |  |  | Estimated other costs
Number | Name | Course of study, duration | 2021 | 2022 | sub-total | 2021 | 2022 | sub-total | Total | Relevent education and training history | Notes to panellists
1 | qqq | QQ | 1
2 | www | WW | 2
3 | eee | EE | 3
4 | rrr | RR | 4
5 | ttt | TT | 5
6 | yyy | YY | 6
7 | uuu | UU | 7
8 | iii | II | 8
9 | ooo | OO | 9
10 | ppp | PP | 10
11 | aaa | AA | 11
12 | sss | SS | 12
Spreadsheet: 855162d1704831757-adding-second-formula-to-existing-range-selection-sample-ideal
Sheet: Sheet1

DATE | Financial record
2023-12-29 00:00:00 | 150
2023-12-29 00:00:00 | -14.5
2023-12-29 00:00:00 | -27.13
2023-12-29 00:00:00 | -10
2023-12-30 00:00:00 | 15
2023-12-30 00:00:00 | -122
2024-01-01 00:00:00 | 12
2024-01-01 00:00:00 | 15
2024-01-01 00:00:00 | 150
2024-01-01 00:00:00 | -11.11
2024-01-02 00:00:00 | 27
2024-01-02 00:00:00 | 13.25
2024-02-02 00:00:00 | 247
1/ | sort out date range |  | 2024-01-01 00:00:00
 |  |  | 2024-01-30 00:00:00
2/ | But only show negative value total in the range
 | the required value
*** | I want to combine these two formulae
 | I'm part way there but need to find the negative only values
 | SUMPRODUCT(--(INT(A3:A15)>=D17),--(INT(A3:A15)<=D18),--(B3:B15))
 | partial result
Spreadsheet: 763432d1642171772-price-development-price-development-v3
Sheet: Sheet1

 |  |  |  |  | Solution from kvsrinivasamurthy modified by me (I removed red equal sign in yellow cells and used unmodified formula in blue cells) =IFERROR(INDEX(Price;AGGREGATE(14;6;ROW(Price)/((INDIRECT("T[PN]")=$E3)*(INDIRECT("T[Date]")<=G$2));1)-ROW($A$2));"")
 |  |  |  | CHART SOURCE TABLE
PN | Date | Price |  | PN |  | 2022-01-15 00:00:00 | 2022-02-01 00:00:00 | 2022-04-20 00:00:00 | 2022-05-20 00:00:00 | 2022-10-06 00:00:00 | 2022-10-15 00:00:00 | 2022-10-28 00:00:00 | 2022-11-06 00:00:00 | 2022-11-15 00:00:00 | 2022-11-28 00:00:00 | 2022-12-31 00:00:00
A | 2022-01-01 00:00:00 | 31
A | 2022-11-28 00:00:00 | 28 |  | B
A | 2022-12-31 00:00:00 | 32 |  | C
B | 2022-01-01 00:00:00 | 14 |  | D
B | 2022-04-20 00:00:00 | 42 |  | E
B | 2022-10-06 00:00:00 | 7 |  | F
B | 2022-10-28 00:00:00 | 18 |  | H
C | 2022-01-01 00:00:00 | 6
C | 2022-10-06 00:00:00 | 4
C | 2022-10-15 00:00:00 | 44
C | 2022-11-15 00:00:00 | 36
C | 2022-12-31 00:00:00 | 49
D | 2022-01-01 00:00:00 | 8
D | 2022-11-06 00:00:00 | 4
E | 2022-01-01 00:00:00 | 16
E | 2022-02-01 00:00:00 | 13
E | 2022-05-20 00:00:00 | 10
F | 2022-01-01 00:00:00 | 23
F | 2022-01-15 00:00:00 | 38
F | 2022-10-06 00:00:00 | 17
H | 2022-01-01 00:00:00 | 66 |  |  | Desired Result
H | 2022-10-06 00:00:00 | 14 |  | PN | 2022-01-01 00:00:00 | 2022-01-15 00:00:00 | 2022-02-01 00:00:00 | 2022-04-20 00:00:00 | 2022-05-20 00:00:00 | 2022-10-06 00:00:00 | 2022-10-15 00:00:00 | 2022-10-28 00:00:00 | 2022-11-06 00:00:00 | 2022-11-15 00:00:00 | 2022-11-28 00:00:00 | 2022-12-31 00:00:00 | 2022-12-31 00:00:00
 |  |  |  |  | 31 | 31 | 31 | 31 | 31 | 31 | 31 | 31 | 31 | 31 | 31 | 28 | 32
 |  |  |  | B | 14 | 14 | 14 | 14 | 42 | 42 | 7 | 7 | 18 | 18 | 18 | 18 | 18
 |  |  |  | C | 6 | 6 | 6 | 6 | 6 | 6 | 4 | 44 | 44 | 44 | 36 | 36 | 49 |  |  |  |  | Issues to be Fixed / Desired Improvements
 |  |  |  | D | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 4 | 4 | 4 | 4 |  |  |  |  | 1) Can the Charts Source Table be completely dynamic automatic updates if Source Table changes?
 |  |  |  | E | 16 | 16 | 16 | 13 | 13 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |  |  |  |  | The column axis (yellow) is already dynamic while row table axis's rightmost orange cell and table core cells (matte yellow) are not.
 |  |  |  | F | 23 | 23 | 38 | 38 | 38 | 38 | 17 | 17 | 17 | 17 | 17 | 17 | 17 |  |  |  |  | 2) Can the core cells formulas be spilled in the area framed by the dynamic Dates and PN axis?
 |  |  |  | H | 66 | 66 | 66 | 66 | 66 | 66 | 14 | 14 | 14 | 14 | 14 | 14 | 14 |  |  |  |  | 3)I would also like the if the formulas in the Chart Core Cells are display the same result even if Source data table is nor sorted (something like solution wich wk9128 posted (2nd post in the thread)
Spreadsheet: 125611d1319126637-showing-dependent-on-another-column-list-and-checking-stock-fotis1991-cascading-dropdowns-test-depanted-2
Sheet: Stock

2011-10-20 00:00:00
ProductS | Quantity
Product1 | 10 |  |  |  |  |  |  | Category A |  | Category A | Category B | Category C | Category A Nonzero | Category B Nonzero | Category C Nonzero
Product2 | 20 |  |  |  |  |  |  | Category B |  | Product1 | Product6 | Product15 | Product1 | Product6 | Product15
Product3 | 25 |  |  |  |  |  |  | Category C |  | Product2 | Product7 | Product16 | Product2 | Product7 | Product16
Product4 | 1 |  |  |  |  |  |  |  |  | Product3 | Product8 | Product17 | Product3 | Product8 | Product17
Product5 | 0 |  |  |  |  |  |  |  |  | Product4 | Product9 | Product18 | Product4 | Product9
Product6 | 5 |  |  |  |  |  |  |  |  | Product5 | Product10 | Product19 |  | Product10 | Product19
Product7 | 10
Product8 | 22
Product9 | 39
Product10 | 42
Product15 | 65
Product16 | 52
Product17 | 78
Product18 | 0
Product19 | 12
Spreadsheet: 468364d1467255115-return-data-based-on-matching-2-criteria-category_examples
Sheet: Sheet2

Group | Level | Return Column
ABC | 1 | Active
ABC | 1 | Active
ABC | 3 | Inactive
DEF | 4 | Active
GHI | 1 | Active
GHI | 3 | Inactive
JKL | 2 | Inactive
JKL | 3 | Active
JKL | 4 | Active
Spreadsheet: 146633d1332275951-calculate-based-on-two-columns-excel-example-for-question
Sheet: Sheet1

Store # | Location ID | Numerical Val
5622 | 19 | 10
5622 | 19 | 10
5622 | 19 | 10
5622 | 19 | 10
5622 | 19 | 10
5622 | 12 | 10
5622 | 12 | 0
5622 | 12 | 0
5622 | 12 | 0
5623 | 15 | 10
5623 | 15 | 10
5623 | 15 | 10
5623 | 15 | 10
5623 | 15 | 10
5623 | 17 | 10
5623 | 17 | 0
5623 | 17 | 0
5623 | 17 | 0
5623 | 20 | 10
5623 | 20 | 10
5623 | 20 | 10
5623 | 20 | 0
5623 | 20 | 10
5623 | 11 | 10
5623 | 11 | 0
5623 | 11 | 0
5623 | 11 | 0
Spreadsheet: 733036d1621360709-percent-gain-loss-book2
Sheet: Sheet1

A | B | C
40 | 0
0 | 0
0 | 42
0 | 0
45 | 0
0 | 0
0 | 44
51 | 52
0 | 0
44 | 43
46 | 0
0 | 0
Spreadsheet: 861942d1709761134-select-items-from-a-static-list-to-populate-elsewhere-in-the-sheet-example-sheet
Sheet: Sheet1

 |  | Static List
 |  | Item | Date | Amount | Selected?
 |  | Item 1 | 2024-03-01 00:00:00 | 100
 |  | Item 2 | 2024-03-02 00:00:00 | 200 | X
 |  | Item 3 | 2024-03-03 00:00:00 | 100 | X
 |  | Item 4 | 2024-03-04 00:00:00 | 5
 |  | Item 5 | 2024-03-22 00:00:00 | 500 | X
 |  | Item 6 | 2024-03-23 00:00:00 | 1000
 |  | Item 7 | 2024-03-24 00:00:00 | 1500 | X
 |  | Item 8 | 2024-03-25 00:00:00 | 250
 |  | Selected Items in a separate list
 |  | Item | Date | Amount | Selected?
 |  | Item 2 | 2024-03-02 00:00:00 | 200 | X
 |  | Item 3 | 2024-03-03 00:00:00 | 100 | X
 |  | Item 5 | 2024-03-22 00:00:00 | 500 | X
 |  | Item 7 | 2024-03-24 00:00:00 | 1500 | X
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: 3.3 Research Equipment

Institution
Indicator 3: Physical Resources
Table 3.3: Instructional/ Research Equipment and Facilities Acquired /AY 2011-12
Please enter major instructional/ research equipment and facilities acquired during the academic year
Major Instructional/ Research Equipment and Facilities Acquisition
 | AY 11-12
Equipment or Facility Name | Oglala Lakota College Center for Science and Technology
Purchase Cost | 436697
Number of Units | 22 museum cabinets, 5 hoods, 8 cabinets, 2 sinks, 2 tables, UV disinfector, labor, miscelleaneous
Purpose | Laboratory renovations and [NAME]
Equipment or Facility Name | Department of Math, Science, and Technology
Purchase Cost | $4,900 + installation
Number of Units | 1
Purpose | Multi-site polycom and smart board for departmental use
Equipment or Facility Name | Piya Wiconi Campus, 3 instructional sites, Rapid City server station
Purchase Cost | 140000
Number of Units | 1 and various and multiple
Purpose | Polycom bridge and upgrades to computing infrastructure
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Notes:
0
Spreadsheet: louise_kitchen__23041__CFs by Industry and Erating
Sheet: Other

Other Cash Flows
Sorted by E Rating
E rating | Data | Total
1 | Sum of Total CF | 137723055.587
 | Sum of Positive CF | 137723055.587
 | Sum of Negative CF | 0
2 | Sum of Total CF | 13233821.6738
 | Sum of Positive CF | 41552558.9826
 | Sum of Negative CF | -28318737.3088
3 | Sum of Total CF | 157104770.9209599
 | Sum of Positive CF | 159211107.4219499
 | Sum of Negative CF | -2106336.50099
4 | Sum of Total CF | 36366238.67094002
 | Sum of Positive CF | 42088642.27955002
 | Sum of Negative CF | -5722403.60861
5 | Sum of Total CF | 34688765.94710001
 | Sum of Positive CF | 44600561.2265
 | Sum of Negative CF | -9911795.2794
6 | Sum of Total CF | 2630798.174100007
 | Sum of Positive CF | 28626722.4351
 | Sum of Negative CF | -25995924.261
7 | Sum of Total CF | 201136309.8145002
 | Sum of Positive CF | 232654377.6617001
 | Sum of Negative CF | -31518067.84720001
8 | Sum of Total CF | 16653393.75172
 | Sum of Positive CF | 16653778.23964
 | Sum of Negative CF | -384.48792
9 | Sum of Total CF | 3412215.82598
 | Sum of Positive CF | 4769051.84377
 | Sum of Negative CF | -1356836.01779
10 | Sum of Total CF | 26975360.97013001
 | Sum of Positive CF | 28335287.62249002
 | Sum of Negative CF | -1359926.65236
11 | Sum of Total CF | 94555871.6151
 | Sum of Positive CF | 139000173.2256
 | Sum of Negative CF | -44444301.61050001
12 | Sum of Total CF | 2310
 | Sum of Positive CF | 2310
 | Sum of Negative CF | 0
#N/A | Sum of Total CF | 16501909.00868817
 | Sum of Positive CF | 87812055.87779798
 | Sum of Negative CF | -71310146.86910981
Total Sum of Total CF |  | 740984821.9600183
Total Sum of Positive CF |  | 963029682.4036981
Total Sum of Negative CF |  | -222044860.4436798
Spreadsheet: 97483d1296657157-excel-2010-auto-copy-formulas-when-adding-new-rows-to-tables-hospice
Sheet: Report

 | Hospice Report
 | Period Beg | 2010-10-01 00:00:00 | Period End | 2010-12-31 00:00:00
 | Admissions:
 | Total:
 | By [NAME]
 | Cancer
 | General [NAME]
 | Cardiac
 | Dementia
 | Other
 | Admissions By Location
 | CJNH
 | CFLE
 | LFCL
 | Community
 | Discharges:
 | Deaths
 | Other Discharges
 | Length of Stay
 | Visits per Week
 | Nursing
 | SW
 | SC
 | Vol
 | HHA
Spreadsheet: 787023d1657608682-formula-to-find-the-multiple-values-and-consolidate-in-new-row-consolidatemultiplelines3
Sheet: Data

Chars. | Task | Value
SKA1 | AA | TK01
SKA1 | BB | TE22
SKA1 | CC | VK10
SKA1 | DD | AS11
SKA1 | DD | AS26
SKA1 | EE | BA01
SKA1 | FF | BA02
SKA1 | GG | 122
SKA1 | GG | 340
SKA1 | GG | 520
SKA1 | GG | 540
SKA1 | HH
SKA1 | II
SKA1 | JJ
SKA1 | KK
SKA1 | LL
SKA1 | MM
SKA1 | NN
SKA1 | OO
SKA1 | PP
SKA1 | QQ
SKA1 | RR
SKA1 | SS
SKA1 | TT
SKA1 | UU
[NAME] | DD | AS22
[NAME] | DD | AS54
[NAME] | DD | AS59
[NAME] | EE
[NAME] | FF
[NAME] | GG | 220
[NAME] | GG | 260
[NAME] | HH
[NAME] | II
[NAME] | JJ
[NAME] | KK
[NAME] | LL
Spreadsheet: phillip_m_love__31188__NICOR-rec
Sheet: Feb 01

 | Fee | Supply |  |  |  |  | Sales |  |  |  |  | [NAME] | NICOR |  |  | Balancing fee based on daily value that is moving balance furthest from zero
Date | Type | Point | Deal # | Volume | Rate | Total | Point | Deal # | Volume | Rate | Total |  | Volume | Rate | Explanation | Supply = Delivery of Gas by HUB
2001-02-02 00:00:00 | Balancing | NGPL | 255905 | 423 | 6.02 |  |  |  |  |  |  |  | 423 |  |  | Sales = Receipt of Gas by HUB
2001-02-07 00:00:00 | Balancing | NGPL | 255905 | 1115 | 5.75 |  |  |  |  |  |  |  | 1115
2/10-2/12 | Balancing | NGPL | 255905 | 75 | 6.36 |  |  |  |  |  |  |  | 75
2001-02-14 00:00:00 | Balancing | NGPL | 255905 | 7429 | 5.81 |  |  |  |  |  |  |  | 7429
2001-02-16 00:00:00 | Balancing |  |  | 899 | 5.755 |  |  |  |  |  |  |  | 899
2/24-2/26 | Balancing |  |  | 29526 | 5.25 |  |  |  |  |  |  |  | 29526
2001-02-06 00:00:00 |  |  |  |  |  |  | NGPL | 257324 | 50 | 5.86 |  |  | 50
2001-02-13 00:00:00 |  |  |  |  |  |  | NGPL | 257324 | 13 | 5.88 |  |  | 13
2001-02-15 00:00:00 |  |  |  |  |  |  | NGPL | 257324 | 6489 | 6.1 |  |  | 6489
2/17-2/20 |  |  |  |  |  |  | NGPL | 257324 | 220 | 5.76 |  |  | 220
2001-02-28 00:00:00 |  |  |  |  |  |  | NGPL | 257324 | 2114 | 5.43 |  |  | 2114
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | 43234@309=$3,891.06
2001-02-02 00:00:00 | Wheeling | NIG | 599343 | 4000 | 6.025 |  | NIG | 599348 | 4000 | 6 |  |  | 4000 |  | inv $100.00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nicor total $3,991.06
Spreadsheet: 32042d1228164953-adding-names-and-showing-on-all-sheets-generic-hours-and-miles_2008
Sheet: August

AUGUST | Month Total | Month Total | 08XXXX | City
CD? Then "Y" |  | CD
 | HOURS | [NAME] | HOURS | CD [NAME]
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
AB Hours /Job | 0 |  | 0
AB-CD /Job |  | 0
 | 0
Spreadsheet: 01a6a0c4-af18-4a29-8412-6d6ddcd5c49c
Sheet: Sheet1

Merit Badge Reservations 2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | SEND TO: | Unnamed: 5 | [EMAIL] | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
First | Last | Camp |  | Troop |  |  |  |  | 9:00 - 9:45 |  | 10:00 -10:45 |  | 11:00 -11:45 |  | 2:00 - 2:45 |  | 3:00 - 3:45 |  | Special
Name | Name | Site | Week | No. | District | Date Ent | Rank | Age | Choice A | Choice B | Choice A | Choice B | Choice A | Choice B | Choice A | Choice B | Choice A | Choice B | Times
Spreadsheet: 735622d1623098082-calculate-the-duration-between-time-and-target-time-1672-negative-times
Sheet: Sheet1

Time | Target time | Duration
11:22:00 | 12:00:00
11:12:00 | 12:00:00
10:21:00 | 12:00:00
10:07:00 | 12:00:00
09:26:00 | 12:00:00
09:17:00 | 12:00:00
09:13:00 | 12:00:00
09:06:00 | 12:00:00
09:49:00 | 12:00:00
09:41:00 | 12:00:00
09:29:00 | 12:00:00
09:36:00 | 12:00:00
09:32:00 | 12:00:00
09:09:00 | 12:00:00
08:57:00 | 12:00:00
10:00:00 | 12:00:00
09:51:00 | 12:00:00
10:34:00 | 12:00:00
10:24:00 | 12:00:00
12:02:00 | 12:00:00
11:33:00 | 12:00:00
09:35:00 | 12:00:00
11:09:00 | 12:00:00
11:23:00 | 12:00:00
10:34:00 | 12:00:00
09:31:00 | 12:00:00
09:31:00 | 12:00:00
09:54:00 | 12:00:00
09:29:00 | 12:00:00
11:22:00 | 12:00:00
12:06:00 | 12:00:00
11:26:00 | 12:00:00
11:15:00 | 12:00:00
10:31:00 | 12:00:00
09:57:00 | 12:00:00
10:34:00 | 12:00:00
09:34:00 | 12:00:00
10:20:00 | 12:00:00
09:54:00 | 12:00:00
11:04:00 | 12:00:00
10:28:00 | 12:00:00
10:21:00 | 12:00:00
10:03:00 | 12:00:00
09:36:00 | 12:00:00
10:40:00 | 12:00:00
10:39:00 | 12:00:00
09:14:00 | 12:00:00
10:50:00 | 12:00:00
10:46:00 | 12:00:00
11:22:00 | 12:00:00
11:22:00 | 12:00:00
09:53:00 | 12:00:00
10:25:00 | 12:00:00
10:06:00 | 12:00:00
09:33:00 | 12:00:00
10:27:00 | 12:00:00
10:10:00 | 12:00:00
10:44:00 | 12:00:00
09:44:00 | 12:00:00
10:39:00 | 12:00:00
11:08:00 | 12:00:00
10:41:00 | 12:00:00
10:31:00 | 12:00:00
09:40:00 | 12:00:00
09:21:00 | 12:00:00
09:57:00 | 12:00:00
09:38:00 | 12:00:00
10:31:00 | 12:00:00
10:45:00 | 12:00:00
09:48:00 | 12:00:00
09:02:00 | 12:00:00
10:13:00 | 12:00:00
10:13:00 | 12:00:00
09:48:00 | 12:00:00
11:11:00 | 12:00:00
11:10:00 | 12:00:00
09:42:00 | 12:00:00
09:28:00 | 12:00:00
10:29:00 | 12:00:00
08:44:00 | 12:00:00
10:57:00 | 12:00:00
10:45:00 | 12:00:00
10:07:00 | 12:00:00
08:43:00 | 12:00:00
11:27:00 | 12:00:00
09:49:00 | 12:00:00
10:30:00 | 12:00:00
10:27:00 | 12:00:00
10:48:00 | 12:00:00
10:07:00 | 12:00:00
10:10:00 | 12:00:00
10:02:00 | 12:00:00
10:13:00 | 12:00:00
10:45:00 | 12:00:00
10:29:00 | 12:00:00
11:29:00 | 12:00:00
10:54:00 | 12:00:00
10:26:00 | 12:00:00
10:14:00 | 12:00:00
10:09:00 | 12:00:00
10:19:00 | 12:00:00
09:57:00 | 12:00:00
10:44:00 | 12:00:00
09:52:00 | 12:00:00
09:38:00 | 12:00:00
10:35:00 | 12:00:00
09:10:00 | 12:00:00
09:46:00 | 12:00:00
10:28:00 | 12:00:00
10:53:00 | 12:00:00
09:35:00 | 12:00:00
09:51:00 | 12:00:00
09:47:00 | 12:00:00
09:59:00 | 12:00:00
09:57:00 | 12:00:00
10:31:00 | 12:00:00
08:50:00 | 12:00:00
Spreadsheet: 844815d1696490671-need-a-formulae-mentioned-in-enclosed-sheet-sample-89-1-
Sheet: Sheet7 (2)

2023-09-23 00:00:00
DAY-1 | 240 |  | 32 |  |  | 54 |  |  | 55 |  |  | 67 |  | 43 |  | 77 |  |  | 89 |  | 90 |  | 54 |  |  | 55 |  | 66 |  | 32 |  | 60
 |  |  | October
 |  | Day-1 |  |  |  |  | SUM RANGE= | B4:AG4
 |  |  |  |  |  |  | IF | row one is equal to october
 |  |  |  |  |  |  | IF | B3:AG3 is >= 1 and <=7
 |  |  |  |  |  | Note: range B3:AG3 are dates
 |  |  |  |  |  | need result in D11
Spreadsheet: 755588d1636980648-trouble-with-indexing-test-upload-file
Sheet: Return Sheet

Heading 1 | Heading 2 | Heading 3 | Heading 4 | Heading 5 | Heading 6 | Heading 7 | Heading 8 | REQUIRED | Heading 10 | Heading 11 | Heading 12 | Heading 13 | Heading 14 | Lower | Upper | Heading 17 | Heading 18 | Heading 19 | Heading 20 | Heading 21 | Heading 22 | Heading 23 | Heading 24 | Heading 25 | Heading 26 | Heading 27 | Required Check
MS486159 | MS | 002e1d04-af42-4036-9cfc-2dfac7438c87 | 44567 |  | 0 | 156 | 0.99 | 95 |  |  |  |  |  | 4 | 9 |  |  |  |  |  |  |  |  |  |  |  | Boiler Care No Service
MS487068 | MS | [NAME]-42f9-9de1-693f3b0c0fc4 | 44571 |  | 0 | 156 | 0.99 | 0 |  |  |  |  |  | 5 | 10 |  |  |  |  |  |  |  |  |  |  |  | Boiler Care
MS488773 | MS | 8ab76761-29d1-4517-8877-5d5b6691c661 | 44578 |  | 0 | 156 | 0.99 | 45 |  |  |  |  |  | 14 | 19 |  |  |  |  |  |  |  |  |  |  |  | Heating Care