tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 36597d1234464191-using-list-function-with-hiding-irrelevant-outputs-monthly-models
Sheet: Time Spent Per Unit

 | Car Production Unit | Estimated Time To Process
 | Work Items | Min | [NAME] | [NAME].
1 | A | 2 | 3 | 4
2 | B | 3 | 4 | 5
3 | C | 4 | 5 | 6
4 | D | 5 | 6 | 7
5 | E | 6 | 7 | 8
6 | F | 7 | 8 | 9
7 | G | 8 | 9 | 10
8 | H | 9 | 10 | 11
9 | I | 10 | 11 | 12
10 | J | 11 | 12 | 13
11 | K | 12 | 13 | 14
12 | L | 13 | 14 | 15
13 | M | 14 | 15 | 16
14 | N | 15 | 16 | 17
15 | O | 16 | 17 | 18
16 | P | 17 | 18 | 19
17 | Q | 18 | 19 | 20
18 | R | 19 | 20 | 21
19 | S | 20 | 21 | 22
20 | T | 21 | 22 | 23
21 | U | 22 | 23 | 24
22 | V | 23 | 24 | 25
23 | W | 24 | 25 | 26
24 | X | 25 | 26 | 27
25 | Y | 26 | 27 | 28
26 | Z | 27 | 28 | 29
27 | AA | 28 | 29 | 30
28 | AB | 29 | 30 | 31
29 | AC | 30 | 31 | 32
30 | AD | 31 | 32 | 33
Spreadsheet: 159777d1338839685-excel-2007-drop-down-list-and-updating-cells-example_3sheets_2
Sheet: Contact and Tracking

Applicant's Name:
Projected Entry: |  |  |  | Summer 2012 |  |  | Program: | □ | MAP: Clinical | □ | MPIC: Non-Clinical
 |  |  |  |  |  |  |  |  |  | □ | ACP Certificate
Datatel Number: |  |  |  |  |  |  | Interview Date and Time:
 |  |  |  |  |  |  | 2nd Interview Date and Time:
Date: |  | Initials: |  | Communications/Comments:
 |  | ks |  | EIS AND DATATEL FWD:
File to Evaluator/Program Chair (remove this sheet and file)
Date: |  | Initials: |  | File To:
Date: |  | Initials/By:
 |  | ks |  | Initial application entered into Datatel
 |  |  |  | Decision entered into Datatel
 |  |  |  | Admission Decision Letter sent and copied for file
 |  |  |  | File to Registrar's Office
Spreadsheet: 113323d1309268519-excel-2008-combine-chart-types-in-2008-simplesample
Sheet: Sheet1

 | Hour 1 Rest | Hour 1 Active | Hour 2 Rest | Hour 2 Active | Hour 3 Rest | Hour 3 Active | Hour 4 Rest | Hour 4 Active | Hour 5 Rest | Hour 5 Active
Product 1 | 7 | 3 | 7 | 3 | 7 | 3 | 4 | 2 | 0 | 0
Product 2 | 4 | 2 | 4 | 2 | 4 | 2 | 4 | 2 | 2 | 1
Spreadsheet: 839433d1691980567-extract-a-number-from-text-extract-numbers-from-text
Sheet: Sheet1

Program # and Name |  |  | Program #
8 Me and My Shadow |  |  | 8
6 Fortyfiveseventy |  |  | 6 |  | 2 Delphia
1 Seattle Causeway |  |  | 1 |  | 3 Fashionably Fab
4 Tito's Calling |  |  | 4 |  | 4 Tito's Calling
9 Bedazzle Me |  |  | 9 |  | 5 Collect Dattt
2 Delphia |  |  | 2 |  | 6 Fortyfiveseventy
3 Fashionably Fab |  |  | 3 |  | 7 Great Kate
5 Collect Dattt |  |  | 5 |  | 8 Me and My Shadow
7 Great Kate |  |  | 7 |  | 9 Bedazzle Me
10 [NAME] 20/1 |  |  | 10 |  | 10 [NAME] 20/1
11 Whelen Springs 5/1 |  |  | 11 |  | 11 Whelen Springs 5/1
Spreadsheet: 0d17029e-d66d-431c-8a74-2ef6d149aacf
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
 | 6345.0 Labour Price Index, Australia
 | Total Hourly Rates of Pay Excluding Bonuses: Private Sector by State, Original (Financial Year Index Numbers for year ended June quarter)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  New South Wales ;  Private ;  All industries ; |  |  | Original | A2704282J | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Victoria ;  Private ;  All industries ; |  |  | Original | A2706144W | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Queensland ;  Private ;  All industries ; |  |  | Original | A2704548F | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  South Australia ;  Private ;  All industries ; |  |  | Original | A2706410A | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Western Australia ;  Private ;  All industries ; |  |  | Original | A2705878R | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Tasmania ;  Private ;  All industries ; |  |  | Original | A2704814K | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Northern Territory ;  Private ;  All industries ; |  |  | Original | A2705612F | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Australian Capital Territory ;  Private ;  All industries ; |  |  | Original | A2705346A | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Private ;  All industries ; |  |  | Original | A2705080C | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
© Commonwealth of Australia  2010
Spreadsheet: 879787d1727342214-count-the-number-of-blank-cells-book1
Sheet: Sheet1

Total number of students whose status is blank
Student Name | Class | Section | Roll No. | Marks obtained
[NAME] | 8 | A | 1 | 90
[NAME] | 8 | A | 2 | 80
Rohit | 8 | A | 3
Kajal | 8 | A | 4 | 96
[NAME] | 8 | A | 5 | 77
Julie | 8 | A | 6
[NAME] | 8 | A | 7 | 82
Mala | 8 | A | 8 | 91
[NAME] | 8 | A | 9
[NAME] | 8 | A | 10 | 54
Pooja | 8 | A | 11 | 78
Kamal | 8 | A | 12
Joy | 8 | A | 13 | 68
Spreadsheet: 885256d1734702717-criteria-for-retrieving-historical-pricing-in-excel-retrieve-historical-price-based-on-the-date-of-transaction-dec-2024-v3-
Sheet: Tab B - Historial Pricing

 | Date | Average Price USD /troy oz
 |  | Platinum | [NAME] | Palladium | [NAME] | Rhodium | [NAME]
 | 2021-01-01 00:00:00 | 1097.2 | - | 2398.2 | - | 19763.125 | -
 | 2021-02-01 00:00:00 | 1212.4079 |  | 2365.0395 |  | 22580.2632
 | 2021-03-01 00:00:00 | 1188.7065 |  | 2494.5543 |  | 27483.6957
 | 2021-04-01 00:00:00 | 1214.6329 |  | 2788.0506 |  | 28779.7468
 | 2021-05-01 00:00:00 | 1221.9747 |  | 2896.8101 |  | 27322.1519
 | 2021-06-01 00:00:00 | 1132.4651 |  | 2735.0465 |  | 21731.9767
 | 2021-07-01 00:00:00 | 1094.3721 |  | 2743.2209 |  | 18757.5581
 | 2021-08-01 00:00:00 | 1015.7471 |  | 2550.6552 |  | 18426.4368
 | 2021-09-01 00:00:00 | 981.9535 |  | 2140.1977 |  | 14720.9302
 | 2021-10-01 00:00:00 | 1025.375 |  | 2030.0625 |  | 13947.5
 | 2021-11-01 00:00:00 | 1042.5682 |  | 2023.7955 |  | 14156.8182
 | 2021-12-01 00:00:00 | 953.6092 |  | 1825.6782 |  | 14027.0115
 | 2022-01-01 00:00:00 | 998.4878 |  | 2027.4024 |  | 16477.439
 | 2022-02-01 00:00:00 | 1056.4459 |  | 2360.4459 |  | 18183.4459
 | 2022-03-01 00:00:00 | 1053.7174 |  | 2635.9239 |  | 19402.1739
 | 2022-04-01 00:00:00 | 973.12 |  | 2352.48 |  | 18857.3333
 | 2022-05-01 00:00:00 | 967.1807 |  | 2091.3253 |  | 16063.5542
 | 2022-06-01 00:00:00 | 961.131 |  | 1938.881 |  | 14045.8333
 | 2022-07-01 00:00:00 | 878.0976 |  | 1992.3902 |  | 14285.3659
 | 2022-08-01 00:00:00 | 916.0879 |  | 2153.956 |  | 14456.044
 | 2022-09-01 00:00:00 | 886.4353 |  | 2133.6941 |  | 14180.5882
 | 2022-10-01 00:00:00 | 924.2317 |  | 2108.4878 |  | 13986.5854
 | 2022-11-01 00:00:00 | 998.75 |  | 1939.8864 |  | 13450
 | 2022-12-01 00:00:00 | 1024.7407 |  | 1854.0247 |  | 12625.9259
 | 2023-01-01 00:00:00 | 1067.3077 |  | 1760.5769 |  | 12245.5128
 | 2023-02-01 00:00:00 | 968.2125 |  | 1567.025 |  | 11730
 | 2023-03-01 00:00:00 | 981.1739 |  | 1446.7609 |  | 9070.1087
 | 2023-04-01 00:00:00 | 1062.2676 |  | 1531.5915 |  | 7880.9859
 | 2023-05-01 00:00:00 | 1073.3095 |  | 1505.3095 |  | 7383.3333
 | 2023-06-01 00:00:00 | 987.4767 |  | 1373.5349 |  | 5923.8372
 | 2023-07-01 00:00:00 | 957.1548 |  | 1281.6071 |  | 4124.4048
 | 2023-08-01 00:00:00 | 934.6374 |  | 1263.4396 |  | 4100
 | 2023-09-01 00:00:00 | 932.6905 |  | 1252.8095 |  | 4100
 | 2023-10-01 00:00:00 | 901.7262 |  | 1160.9167 |  | 4577.9762
 | 2023-11-01 00:00:00 | 918.7955 |  | 1071.375 |  | 4377.8409
 | 2023-12-01 00:00:00 | 955.3896 |  | 1089.1169 |  | 4412.3377
Spreadsheet: 14b67d39-1aa9-439c-ac01-557ee3b6851e
Sheet: Sheet1

Unnamed: 0 | NOTES: | Some clubs refer to this as a roster while others refer to it as a directory. | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | THIS PAGE IS NOT PROTECTED.
 | This is merely a template to help you get started. Please feel free to change as needed for your purposes.  These top rows will not print but you can delete them as well.
 | It is designed so that you can collect the information needed to update your membership using the International Member Update Center
 | You can add or delete rows and columns, use borders, sort by name, committee, Grad Year, or for whatever your club/officers/committee chairs need.
 | Tip: If you input names using "Last Name, First" then you can use the sort feature to alphabetize your list; gridlines can be used or removed.
 | [NAME] needed for Member Update Center= updating the roster with International. Columns can be hidden if not needed for club purposes.
 | **Can be helpful for recording who has paid. Column can be hidden or cell information can be changed as needed.
 | Year | District
 | Term | Club |  | Division | Region | District
 | Name | Faculty or Kiwanis | E-mail | Preferred Phone
 | Advisors
 | Last Name, First | Position | E-mail | Preferred Phone | Committee | Grad Year | Member ID* | Mailing Adddress* | City* | Paid**
 | Club Members
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
Spreadsheet: 1f7df3c1-ca37-4456-b394-b5b43ffa6166
Sheet: serials productivity stats

Serials Productivity Statistics FY09 and FY10
COLLECTION METRICS
 | FY09 | FY10 | % change
Serial volumes withdrawn | 112 | 11999
Mform pieces withdrawn | 0 | 0 | 0
Serial volumes added (total) | 3085 | 2125
Subscriptions | 626 | 194
Binding | 2414 | 1890
Gifts | 45 | 41
Mform pieces added (total) | 645 | 55
Film | 250 | 55
Fiche | 395 | 0 | N/A
PRODUCTIVITY METRICS
 | FY09 | FY10 | % change
[NAME] processed | 14962 | 15781
[NAME] temp bound | 60 | 0
[NAME] mended (in-house) | 156 | 91
Claims sent | 557 | 661
Pieces checked in | 10196 | 6330
[NAME] returned from bindery (total) | 3525 | 2866
Journals and other materials | 2394 | 1890
Repairs | 597 | 562
Non-Library | 534 | 414
Spreadsheet: 65539d1266262690-excel-2007-conditional-formatting-panel-ckt-shell-office7-r4
Sheet: LookUp

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  | Voltage | # [NAME] | Watts / Lamp | Ballast Watts | Battery Pack | Input Watts | Efficiency | Power Factor | kVA/ Fixture |  |  | Lamp Watts | Voltage | [NAME]Current | Input Watts | [NAME] | Efficiency
Group_1 | A | 480 | 1 | 400 |  |  | 452 | 0.85 | 0.95 |  |  |  | 200 | 277 | 0.9 | 238
 | A1 | 480 | 1 | 400 |  |  | 452 | 0.85 | 0.95 |  |  |  | 200 | 480 | 0.52 | 241
 | A2 | 480 | 1 | 250 |  |  | 288 | 0.85 | 0.95 |  |  |  | 250 | 277 | 1.13 | 305
 | A3 | 480 | 1 | 250 |  |  | 288 | 0.85 | 0.95 |  |  |  | 250 | 480 | 0.65 | 308
 | A4 | 277 | 1 | 250 |  |  | 295 | 0.85 | 0.95
 | B | 480 | 1 | 400 |  |  | 453 | 0.85 | 0.95 |  |  |  | 400 | 277 | 1.17 | 465
 | B1 | 480 | 1 | 400 |  |  | 453 | 0.85 | 0.95 |  |  |  | 400 | 480 | 1 | 468
 | C | 277 | 3 | 32 |  |  | 86.2 | 0.85 | 0.95 |  |  |  | 50 | 277 | 0.55 | 63
 | C1 | 277 | 3 | 32 |  | Y | 86.2 | 0.85 | 0.95 |  |  |  | 50 | 480 | 0.29 | 64
 | D | 277 | 2 | 32 |  |  | 57.4 | 0.85 | 0.95 |  |  |  | 70 | 277 | 0.66 | 95
 | D1 | 277 | 2 | 32 |  | Y | 57.4 | 0.85 | 0.95 |  |  |  | 70 | 480 | 0.38 | 90
 | D2 | 277 | 3 | 17 |  |  | 44 | 0.85 | 0.95 |  |  |  | 100 | 277 | 0.94 | 130
 | D3 | 277 | 3 | 17 |  | Y | 44 | 0.85 | 0.95 |  |  |  | 150 | 277 | 1.34 | 128
 | E | 277 | 2 | 25 |  | Y | 50.4 | 0.85 | 0.95 |  |  |  | 150 | 480 | 0.9 | 190
 | E1 | 277 | 2 | 25 |  | Y | 50.4 | 0.85 | 0.95
 | F | 277 | 3 | 32 |  |  | 86.2 | 0.85 | 0.95 |  |  |  | 50 | 277 | 0.5 | 67
 | F1 | 277 | 3 | 32 |  | Y | 86.2 | 0.85 | 0.95 |  |  |  | 70 | 277 | 0.78 | 95
 | F2 | 277 | 2 | 32 |  |  | 57.4 | 0.85 | 0.95 |  |  |  | 100 | 277 | 1.15 | 130
 | F3 | 277 | 2 | 32 |  | Y | 57.4 | 0.85 | 0.95 |  |  |  | 150 | 277 | 1.58 | 185
 | F4 | 277 | 2 | 32 |  |  | 57.4 | 0.85 | 0.95
 | F5 | 277 | 2 | 32 |  |  | 57.4 | 0.85 | 0.95
 | G | 480 | 6 | 54 |  |  | 363 | 0.85 | 0.95
 | [NAME] | 480 | 6 | 54 |  | Y | 363 | 0.85 | 0.95
 | H | 277 | 3 | 32 |  |  | 86.2 | 0.85 | 0.95
 | H1 | 277 | 3 | 32 |  | Y | 86.2 | 0.85 | 0.95
 | J | 277 | 1 | 32 |  |  | 57.4 | 0.85 | 0.95
 | J1 | 277 | 3 | 32 |  | Y | 57.4 | 0.85 | 0.95
 | K
 | L
 | M
 | N | 120 |  |  |  |  | 180 | 0.85 | 0.8
 | P | 120 |  |  |  |  | 180 | 0.85 | 0.8
 | R | 120 |  |  |  |  | 180 | 0.85 | 0.8
 | S | 120 |  |  |  |  | 180 | 0.85 | 0.8
 | T | 120 |  |  |  |  | 242 | 0.85 | 0.8
 | T1 | 120 |  |  |  |  | 242 | 0.85 | 0.8
 | U
 | V
 | W |  | 1 | 70 |  |  | 91 | 0.82 | 0.8
 | X | 277 |  |  |  |  | 4.5 | 0.82 | 0.8
 | X1 | 277 |  |  |  |  | 4.5 | 0.82 | 0.8
Group_2 | A
 | B
 | C
 | D
 | E
 | F
Spreadsheet: 727931d1618220867-convert-text-to-hours-minutes-seconds-results-sample-for-excel-forum
Sheet: Sheet1

event name | race | pos | gun time |  | Desired output
Back to Basics 10K | 10K 1 | 19 | 34:49 |  | 00:34:49
Back to Basics 10K | 10K 1 | 17 | 60:57 |  | 01:00:57
Back to Basics 10K | 10K 1 | 2 | 30:07
Back to Basics 10K | 10K 1 | 6 | 32:39
Back to Basics 10K | 10K 1 | 18 | 32:39
Back to Basics 10K | 10K 1 | 16 | 33:45
Back to Basics 10K | 10K 1 | 23 | 37:02
Back to Basics 10K | 10K 1 | 3 | 31:21
Back to Basics 10K | 10K 1 | 11 | 40:13
Spreadsheet: 868756d1715433735-check-multiple-sheets-for-data-and-when-found-displays-it-on-last-sheet-work-in-progress
Sheet: EXAMPLE

 | Inventory Count |  | auto populates |  |  |  | TABLE COUNT DATA
 | As at: | 2020-07-06 00:00:00 | enter info |  |  |  | Table | BPR # | Initial # Plants Plugged | Kill | Current room Count | Harvested Amount | Harvest Date
 |  |  |  |  |  | NOTE | 1 | REX B-20200617-RX-0
 | Plug Date: | 2020-07-06 00:00:00 | enter info |  |  |  | 2 | REX B-20200617-RX-0
 | Cycle: | 10 | enter info |  |  |  | 3 | REX B-20200617-RX-0
 | Room: | 17 | enter info |  |  |  | 4 | REX B-20200617-RX-0
 | Status: | Vegetative | enter info |  |  |  | 5 | REX B-20200617-RX-0
 | Estimated Harvest Date | 2020-08-16 00:00:00 | enter info |  |  |  | 6 | REX B-20200617-RX-0
 |  |  |  | NOTE |  |  | 7 | REX B-20200617-RX-0
 | Room Total Counts |  |  |  |  |  | 8 | REX B-20200617-RX-0
 | Strain | Biotrack Count | Room Count | [NAME] |  |  | 9 | REX B-20200617-RX-0
 | REX | 5600 |  |  |  |  | 10 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 11 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 12 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 13 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 14 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 15 | REX B-20200617-RX-0
 | Total |  |  |  |  |  | 16 | REX B-20200617-RX-0
 |  |  |  |  | NOTE |  | 17 | REX B-20200617-RX-0
 | Room Activity |  |  |  |  |  | 18 | REX B-20200617-RX-0
 | Date | Table | BPR # | Activity | Quantity |  | 19 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 20 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 21 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 22 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 23 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 24 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 25 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 26 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 27 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 28 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 29 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 30 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 31 | REX B-20200617-RX-0
 |  |  |  |  |  |  | 32 | REX B-20200617-RX-0
 | To Create sign off
 | 1. Go to insert tab |  |  |  |  |  | Total
 | 2. Click the text drop down arrow
 | 3. Click Signature line drop down arrow
 | 4. Select Microsoft Signature and complete the prompts
 | 5. When ready to sign right click signature box and click sign then complete the prompts
Spreadsheet: 107833d1304984379-sorting-data-based-on-drop-down-lists-test-data
Sheet: GUI

 | Select Level | Level
 | Select Course | Associate Degree in Applied Science (Parks Recreation and Heritage)
 | OCB
 | Course Contacts |  |  |  | Course Specifics
 | Course Admin Officer | 0 |  |  | Faculty | 0
 | Course Coordinator | 0 |  |  | Level | Undergraduate
 | Assessment Officer |  |  |  | Program Code | 0
 | Client Service Officer - Admissions | 0 |  |  | TAC Code | 0
 | Client Service Officer - Administration | 0 |  |  | [NAME] | 0
 |  |  |  |  | Campus | 0
 |  |  |  |  | Mode | 0
 |  |  |  |  | Competitive | 0
 |  |  |  |  | Defferable | 0
 |  |  |  |  | Delegated Authority | 0
 |  |  |  |  | Pathways
 |  |  |  |  | 0
 |  |  |  |  | [NAME]
 |  |  |  |  | 0
Spreadsheet: 533123d1502663021-pivot-table-displaying-old-data-53rd-street-cost-schedule-after
Sheet: Draw 8 - 08.07.17

Description | Line Item | Line Item # | Date | Amount | Payee | Notes |  | Row Labels | Sum of Line Item # | Sum of Amount
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-08-06 00:00:00 | 114.52 | Home Depot | Retaining wall materials |  | Block/Retaining Walls | 690 | 4605
Grading and Export | Rough Grading | 302 | 2017-08-04 00:00:00 | 4750 | B&M Grading | Grading and export material to [NAME] |  | Rough Grading | 906 | 12970
Stormwater BMPs | Erosion Control | 211 | 2017-07-31 00:00:00 | 750 | B&M Grading | Stormwater BMPs |  | Grand Total | 1596 | 17575
Stormwater BMPs | Erosion Control | 211 | 2017-08-01 00:00:00 | 134.69 | Summit Erosion Control | Stormwater BMPs
Stormwater BMPs | Erosion Control | 211 | 2017-08-01 00:00:00 | 408.91 | Summit Erosion Control | Stormwater BMPs
 |  |  |  |  |  |  |  | I want this data above to reflect the data on this sheet, but it reverts back to different data
Spreadsheet: 822871d1679575992-long-complex-formula-to-let-book1
Sheet: Feb 2023 MOF OOE Query

[NAME] | (All) |  |  |  |  | [NAME] | (All)
[NAME] | (All) |  |  |  |  | [NAME] | (All)
LEDGER | (All) |  |  |  |  | LEDGER | (All)
[NAME] | (All) |  | Office of Finance |  |  | [NAME] | (All)
BUDGET_REF | 2023 |  |  |  |  | BUDGET_REF | 2023
STRAT_TYPE | OPERATING |  |  |  |  | STRAT_TYPE | OPERATING
CLASS | (All) |  |  |  |  | CLASS | (All)
CLASS_DESCR | (All) |  |  |  |  | CLASS_DESCR | (All)
EXPENDITURE |  | FY_AP |  |  |  | EXPENDITURE |  |  |  | FY_AP
STRATEGY | BUD_ACCOUNT | 2023_06 |  |  |  | STRATEGY | MFR_MOF_TYPE | CFDA | CFDA_DESCR | 2023_06
D.1.1 | 700000 | 193624.2200000001 |  |  |  | D.1.1 | GR | 0001 | General Revenue | 238352.67
 | L1001 | 3347949.62 |  |  |  |  |  | 0758 | GR- [NAME] | 92911.98999999999
 | [NAME] | 31736.22 |  |  |  |  |  | ALL | --- | 0
 | L1002 | 242933.46 |  |  |  |  | GR Total |  |  | 331264.66
 | L2001 | 1500 |  |  |  |  | CAPPED GNTS |  |  | 3739713.320000001
 | [NAME] | 1122.66 |  |  |  |  | ENTITLEMENTS | 93.778.003 | Medical Assistance Program 50% | 92911.99999999999
 | L2005 | 67017.39 |  |  |  |  | ENTITLEMENTS Total |  |  | 92911.99999999999
 | [NAME] | 194072.25 |  |  |  |  | OTHER | 0666 | Appropriated Receipts | 4952.61
 | L2007 | 40 |  |  |  |  | OTHER Total |  |  | 4952.61
 | L2009 | 28839.98 |  |  |  | D.1.1 Total |  |  |  | 4168842.590000001
 | L2009S | 61023.49000000002 |  |  |  | COST POOLS | GR | 0001 | General Revenue | 1.179205049578469e-10
 | L3001 | -1016.7 |  |  |  |  |  | 0758 | GR- [NAME] | -3.088640454507185e-12
D.1.1 Total |  | 4168842.590000001 |  |  |  |  |  | ALL | --- | 0
COST POOLS | 700000 | -3120687.069999999 |  |  |  |  | GR Total |  |  | 1.148318645033397e-10
 | L1001 | 929125.0000000001 |  |  |  |  | TANF | 93.558.000 | Temporary Assistance to Needy Families | -1.456612608308205e-13
 | [NAME] | 12364.88 |  |  |  |  | TANF Total |  |  | -1.456612608308205e-13
 | L1002 | 731882.4599999998 |  |  |  |  | CAPPED GNTS |  |  | 5.083533594074652e-11
 | L2002 | 58.18 |  |  |  |  | ENTITLEMENTS | 93.090.050 | Title IV-E Guardianship Assistance - Administration - 50% | -1.758072853963455e-13
 | [NAME] | 3599.959999999999 |  |  |  |  |  | 93.658.050 | Title IV-E Foster Care - Administration - 50% | 5.788713258736422e-12
 | L2004 | 1190879.47 |  |  |  |  |  | 93.659.050 | Title IV-E Adoption Assistance - Administration - 50% | 1.879330024934234e-12
 | L2005 | 32098.85 |  |  |  |  |  | 93.778.003 | Medical Assistance Program 50% | -3.088640454507185e-12
 | [NAME] | 7170.900000000001 |  |  |  |  | ENTITLEMENTS Total |  |  | 4.403595543767125e-12
 | L2006 | 1370 |  |  |  | COST POOLS Total |  |  |  | 1.699251347270225e-10
 | L2009 | 203093.95 |  |  |  | Grand Total |  |  |  | 4168842.590000001
 | L2009S | 9043.419999999998
COST POOLS Total |  | 1.600710675120354e-10
Grand Total |  | 4168842.590000001
Spreadsheet: 807496d1669917742-combining-two-columns-and-modifying-the-data-in-one-formula-test-file
Sheet: Sheet1

Bd.Dt | Seq # | Joined Colums
2022-11-10 00:00:00 | 332 | [NAME]
2022-11-21 00:00:00 | 135 |  | B:1121 S:135
2022-11-21 00:00:00 | 136 |  | B:1121 S:136
2022-11-21 00:00:00 | 132 |  | B:1121 S:132
2022-11-22 00:00:00 | 170 |  | [NAME]
2022-11-22 00:00:00 | 171 |  | B:1122 S:171
2022-11-29 00:00:00 | 80 |  | B:1129 S:80
2022-11-29 00:00:00 | 83 |  | B:1129 S:83
2022-09-26 00:00:00 | 924 |  | B:0926 S:924
2022-10-06 00:00:00 | 831 |  | B:1006 S:831
2022-10-06 00:00:00 | 723 |  | B:1006 S:723
2022-10-20 00:00:00 | 837 |  | B:1020 S:837
2022-10-21 00:00:00 | 902 |  | B:1021 S:902
2022-10-24 00:00:00 | 752 |  | B:1024 S:752
2022-10-26 00:00:00 | 924 |  | B:1026 S:924
2022-10-31 00:00:00 | 790 |  | B:1031 S:790
2022-10-31 00:00:00 | 1019 |  | B:1031 S:1019
Spreadsheet: 35776d1233423250-calculating-return-by-only-a-change-in-the-cell-of-date-perf
Sheet: Sheet1

 | Return (%)
2008-12-31 00:00:00 | 2.1
2009-01-31 00:00:00 | 0.55
2009-02-28 00:00:00 | 6.72
2009-03-31 00:00:00 | 3.45
2009-04-30 00:00:00 | -5.8
2009-05-31 00:00:00 | 8.99
2009-06-30 00:00:00 | 3.2
2009-07-31 00:00:00 | -6.34
2009-08-31 00:00:00 | -3.2
2009-09-30 00:00:00 | -0.78
2009-10-31 00:00:00 | 1.445
2009-11-30 00:00:00 | 3.409
2009-11-30 00:00:00 |  | <- in A16 is where I input date
1 Month Return | 3.409 | <- B17 will detect what input in A16 and retrieve data in column B
3 Months Return | 4.08501462161 | <- in B18 I input the calculation for your information, but I actually want it to be able to detect what input in A16 and using the the return matching the corresponding month to get return
1 Year Return | 13.32327045776196 | <- in B18 I input the calculation for your information, but I actually want it to be able to detect what input in A16 and using the the return matching the corresponding month to get return
Year to Date Return | 10.99242943953176 | <- in B18 I input the calculation for your information, this one is different since it has to know where to start doing the calculation according to say I input Aug08, it gives me Jan08 to Aug08, and Mar 07 then it gives me Jan 07 to Mar07. for quarter to date, it has to be able to detect whether to use Jan, APr, [NAME] or Oct
Quarter to Date Return | 4.903260050000014
I am thinking if I should make in a dynamic range for column A since each month when I have new data I will insert new row, and in this case, I will insert row in 14 and input data Dec 09
Spreadsheet: 855547d1705077000-looking-for-a-way-to-automate-scheduling-duos-into-different-squads-sample-scheduling
Sheet: Qualifiers

Team Member 1 | Team Member 2
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | Briley Scantland
[NAME] | Nate Apgar
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Bobbi [NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]