tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 807856d1670108020-dynamic-dependent-dropdown-list-in-excel-categories
Sheet: Sheet1

 | STEP 1
 | Categories |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prep
 | Cat 1 | << 1. Up to 10 but not necessarily 10 (and with blanks) |  |  |  |  | << 2. Categories reorganized to remove blanks
 | Cat 2
 | Cat 3
 | Cat 4 |  |  |  |  |  |  |  | Cat 1 | << 3. Dropdown on only available categories, without blanks
 | Cat 5
 | Cat 6
 | Cat 7
 | STEP 2 | << Up to 16 but not necessarily 16 (and with blanks). Each associated with a Category
 | Sub Categories | Associated Cat
1 | Sub 1 | Cat 1 | << Using categories dropdown previously created to associate category to each sub
 | Sub 2 | Cat 4
 | Sub 3 | Cat 6
 | Sub4 | Cat 4 |  | Cat Dropdown
 | Sub 5 | Cat 2 |  | Cat 7
 | Sub 6 | Cat 3
 |  |  |  | [NAME]??
 | Sub7 | Cat 1
 | Sub 8 | Cat 7
 | Sub 9 | Cat 5
 | Sub 10 | Cat 6
 | Sub 11 | Cat 7
 | Sub 12 | Cat 5
 | Sub 13 | Cat 3
Spreadsheet: 862014d1709818039-reverse-calculation-retirment-calculator-excel
Sheet: Yearly Income Table

 | Age | Year | Spending ($)   Day-to-day spending | Net Income | CPP Benefit | OAS Benefit | Work Income | Non-registered Investment Income | RRSP income | TFSA Income | Total Gross Income | Taxable income | Income Tax
 |  |  |  |  | 0 | 0 |  |  | 53000 | 0
 |  |  |  |  | 0 | 0 |  |  | 50000 | 0
 |  |  |  |  | 0 | 0 |  |  | 0
 |  |  |  |  | 0 | 0 |  |  | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 2355 | 1590 |  |  |  | 10000
 |  |  |  |  | 2355 | 1590
 |  |  |  |  | 14428 | 9743 |  | 10000
 |  |  |  |  |  |  |  | 20000
 |  |  |  |  |  |  |  | 20000
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 12922
Spreadsheet: 781235d1653070983-sum-index-match-with-row-and-column-based-on-date-book1
Sheet: Sheet1

Line 1 | 2022-05-17 00:00:00 | 2022-05-18 00:00:00 | 2022-05-19 00:00:00 | 2022-05-20 00:00:00
Line 2 | 10 | 70 | 15 | 30
Line 3 | 20 | 60 | 20 | 15
Line 4 | 50 | 50 | 25 | 40
Line 5 | 15 | 40 | 30 | 45
Line 6 | 17 | 30 | 35 | 90
Line 7 | 33 | 20 | 40 | 100
Param Date | 2022-05-20 00:00:00
SUM1 |  | Need to sum values of cells between E4:E6 for parameter date [NAME]
SUM2 |  | Need to sum values of cells between B4:D6, i.e. 3 days before parameter date 20/05/2022
SUM1 |  | ?????
SUM2
Spreadsheet: mary_fischer__25634__31Q
Sheet: E14.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Q
COMPANY NAME    Limbach Constructors
ANALYSIS OF OTHER DEFERRED CREDITS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(1)  PROVIDE DETAIL OF INDIVIDUAL ITEMS IN EXCESS OF $200,000
(2)  USE COMMENTS SECTION TO PROVIDE AN EXPLANATION OF WHY ANY REVENUE
ITEMS ARE DEFERRED AND WHAT EVENT WILL CAUSE REVENUE RECOGNITION
OTHER DEFERRED CREDITS:
 |  | 0
Total (Hyperion line 0860)
Asset/Expense Accts:  DR/(CR)
Reverse signs from Hyperion
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Feb3-Feb9p

Pavilion
 | 2013-02-03 00:00:00 |  |  | Thru | 2013-02-09 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-02-03 00:00:00 | 2013-02-04 00:00:00 | 2013-02-05 00:00:00 | 2013-02-06 00:00:00 | 2013-02-07 00:00:00 | 2013-02-08 00:00:00 | 2013-02-09 00:00:00 |  |  |  | Blocks | Team | Hours
7:15AM |  |  |  |  |  |  |  | 7:15AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
8:15AM |  |  |  |  |  |  |  | 8:15AM |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
9:15AM |  |  |  |  |  |  |  | 9:15AM |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:15AM |  |  |  |  |  |  |  | 10:15AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:15AM |  |  |  |  |  |  |  | 11:15AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:15PM |  |  |  |  |  |  |  | 12:15PM
1:15PM |  |  |  |  |  |  |  | 1:15PM
2:15PM |  |  |  |  |  |  |  | 2:15PM
3:15PM |  |  |  |  |  |  |  | 3:15PM
4:15PM |  |  |  |  |  |  |  | 4:15PM
5:15PM |  |  |  |  |  |  |  | 5:15PM
[NAME] |  |  |  |  |  |  |  | [NAME]
7:15PM |  |  |  |  |  |  |  | 7:15PM
8:15PM |  |  |  |  |  |  |  | 8:15PM
9:15PM |  |  |  |  |  |  |  | 9:15PM
10:15PM |  |  |  |  |  |  |  | 10:15PM
11:15PM |  |  |  |  |  |  |  | 11:15PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 53628d1253566170-cell-linking-displayed-in-text-help
Sheet: Weapons Table

Admin Number | Serial Number | M203 SN | Weapon Type | Name | Platoon | NSN
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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
Spreadsheet: 148300d1333338399-npv-help-npv
Sheet: Sheet1

Year | Cash Flow | Discount Rate | NPV (immediate Inv.) |  | Numbers Should Display
0 | -3800000 | 0.01 |  | <-my mistake? | -1253854.27
1 | 169999.9999999999 | 0.02 |  |  | -532204.45
2 | 263416.6425050987 | 0.03 |  |  | and so on…
3 | 408166.6326391708 | 0.04
4 | 632458.1408966029 | 0.05
5 | 979999.9999999995 | 0.06
6 | 1004000 | 0.07
7 | 1028000 | 0.08
to calculate npv of the investment assuming the discount rates in column C and assuming that the initial investent will occur immediately.
Spreadsheet: 462629d1464119950-dynamic-call-log-call-log-template
Sheet: Sheet1

# | ID | First Name | Last Name | DOB | SSN | Deceased (Y/N) | PR_Name (If Applicable) | [NAME] | Claimant Email | PR Phone | Addr 1 | [NAME] | City | State | Zip | Priority (H/M/L) | Date of Call #1 | Call #1 Outcome | Call #1 Notes | Date of Call #2 | Call #2 Outcome | Call #2 Notes | Date of Call #3 | Call #3 Outcome | Call #3 Notes | Date of Call #4 | Call #4 Outcome | Call #4 Notes | Date of Call #5 | Call #5 Outcome | Call #5 Notes | Defect Call Status | PRESCRIBING DOCTOR | PRESCRIBING DOCTOR PHONE | PRESCRIBING DOCTOR ADDRESS | PRESCRIBING DOCTOR ADDRESS | PRESCRIBING DOCTOR CITY | PRESCRIBING DOCTOR STATE | PRESCRIBING DOCTOR ZIPCODE | PHARMACY | PHARMACY PHONE | PHARMACY ADDRESS | PHARMACY ADDRESS 2 | PHARMACY CITY | PHARMACY STATE | PHARMACY ZIP | HOSPITAL | HOSPITAL PHONE | HOSPITAL ADDRESS | HOSPITAL ADDRESS 2 | HOSPITAL CITY | HOSPITAL STATE | HOSPITAL ZIP | Date  Completed | PFS Call Time | PFS Call Duration | PSF Upload Date |  | Not in MDL | Contact TDF | No Contact | Cut List
1
Spreadsheet: 886927d1737031712-data-transfer-from-different-sheets-to-one-main-sheet-tabs-merged-2025-01alexf
Sheet: Sheet C

Data 1 | Data 2 | Data 3
9 | 182 | 698
215 | 215 | 59
768 | 638 | 137
858 | 810 | 55
314 | 405 | 571
740 | 192 | 555
Spreadsheet: 42d3780a-9075-4cef-97d6-a5ed73a97f11
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3032 | 11099 | Simone | Hakenberg | NED | 117 | [NAME] | 00:02:01 | 2:16:12 | 00:01:08 | 1:34:34 | 1 | 4:42:09
3032 | 17865 | [NAME] | Horne | GBR | 116 | 00:51:50 | 00:02:24 | 2:22:09 | 00:01:25 | 1:29:20 | 2 | 4:47:12
3032 | 17692 | Kai | Sachtleber | GER | 115 | 00:46:35 | 00:02:13 | 2:22:12 | 00:01:13 | 1:39:43 | 3 | 4:51:59
Spreadsheet: 167962d1342170547-formula-to-auto-calculate-stock-that-needs-to-be-ordered-order-example
Sheet: Sheet1

Deliveries for Period | 4
 | Delivered | Coke | Beer | Bread | Water Bottles
Per Week | 2
 | Stock Count | Coke | Beer | Bread | Water Bottles
 | 2012-07-13 00:00:00 | 85 | 19 | 79 | 18
 | Balance Minus Stock
 |  | Coke | Beer | Bread | Water Bottles
 | Usage ( 1 Month) | 163 | 6 | 75.33333333333333 | 88
 | Usage ( Per Delivery )
 | Order Stock
Spreadsheet: 824070d1680274512-result-without-helper-columns-result-without-helper-columns
Sheet: Sheet1 (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 6 | 5 | 4 | 3 | 2 | 1 |  | ************************ Helper columns*********************************************************************** |  |  |  |  |  |  |  |  | ***************final Result********************************************************************
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test1 |  | 5387651.18 | 196620 | 393240 | 584817.73 | 402001.92 | 737438 | 970968.13 | 3558952.14
Spreadsheet: 680652d1591121297-need-a-formula-to-pull-data-from-another-sheets-chart-based-off-age-and-gender-2020-06-02-oeldere-tbingham-680647d1591120212-need-a-formula-to-pull-data-from-another-sheets
Sheet: Male Situp

Percent | 20-29 | 30-34 | 35-39 | 40-44 | 45-49 | 50-54 | 55-59 | 60+
99 | 56 | 52 | 50 | 48 | 46 | 44 | 42 | 40
95 | 55 | 51 | 49 | 47 | 45 | 43 | 41 | 39
90 | 51 | 48 | 46 | 43 | 41 | 39 | 37 | 35
85 | 49 | 45 | 42 | 40 | 38 | 36 | 33 | 31
80 | 47 | 43 | 41 | 39 | 37 | 35 | 32 | 30
75 | 46 | 42 | 39 | 37 | 35 | 33 | 30 | 28
70 | 45 | 41 | 38 | 36 | 33 | 31 | 28 | 26
65 | 44 | 40 | 37 | 35 | 32 | 30 | 27 | 24
60 | 42 | 39 | 36 | 34 | 31 | 28 | 25 | 22
55 | 41 | 37 | 34 | 32 | 29 | 27 | 24 | 21
50 | 40 | 36 | 33 | 31 | 28 | 26 | 23 | 20
45 | 39 | 35 | 32 | 30 | 27 | 25 | 22 | 19
40 | 38 | 34 | 31 | 29 | 26 | 24 | 21 | 18
35 | 37 | 33 | 30 | 28 | 25 | 22 | 19 | 17
30 | 35 | 32 | 29 | 27 | 24 | 21 | 18 | 16
25 | 34 | 31 | 28 | 26 | 23 | 20 | 17 | 15
20 | 33 | 30 | 27 | 24 | 21 | 19 | 16 | 14
15 | 32 | 28 | 25 | 22 | 19 | 17 | 15 | 13
10 | 30 | 26 | 23 | 20 | 17 | 15 | 13 | 10
5 | 27 | 23 | 20 | 17 | 14 | 12 | 9 | 7
1 | 26 | 22 | 19 | 16 | 13 | 11 | 8 | 6
Spreadsheet: 220000d1363031661-formula-that-shows-date-the-quantiy-will-run-out-based-on-different-monthly-forecast-test-lguevara21-oeldere-
Sheet: Sheet1

 |  |  |  |  |  | Projected Monthly Forecast
Mat'l # | SAFETY STOCK | Stock | Date ORDER Entrty | Order  Qty. | When should I order | 2013-04-13 00:00:00 | 2013-05-01 00:00:00 | 2013-05-31 00:00:00 | 2013-06-30 00:00:00 | 2013-07-30 00:00:00 | 2013-08-29 00:00:00 | 2013-09-28 00:00:00 | 2013-10-28 00:00:00 | 2013-11-27 00:00:00 | 2013-12-27 00:00:00 | 2014-01-26 00:00:00 | 2014-02-25 00:00:00
Item 1 | 1290 | 0 | 2013-01-27 00:00:00 | 7700 |  | 3867 | 2320.5 | 2762.5 | 3315 | 3978 | 4176.900000000001 | 4696.25 | 4420 | 4143.75 | 3315 | 4143.75 | 3867.5
Item 2 | 250 | 0 | 2013-01-27 00:00:00 | 1400 |  | 682.5 | 409.5 | 487.5 | 585 | 702 | 737.1 | 828.75 | 780 | 731.25 | 585 | 731.25 | 682.5
Item 3 | 99 | 0 | 2013-01-27 00:00:00 | 700 |  | 297 | 178.5 | 212.5 | 255 | 306 | 321.3 | 361.25 | 340 | 318.75 | 255 | 318.75 | 297.5
Item 4 | 17 | 0 | 2013-01-27 00:00:00 | 300 |  | 52.5 | 31.5 | 37.5 | 45 | 54 | 56.7 | 63.75 | 60 | 56.25 | 45 | 56.25 | 52.5
Spreadsheet: phillip_platter__31426__SCH estate
Sheet: SupplyBids

Min Price | 0
[NAME] | 2500
Price Offset | 0.01
Type | Supply
[NAME]
 | P1 | Q1 | P2 | Q2 | P3 | Q3 | P4 | Q4 | P5 | Q5 | P6 | Q6 | P7 | Q7 | P8 | Q8 | Total Q
HE1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
HE2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Generated PX Bids -- SUPPLY
 | P1 | Q1 | P2 | Q2 | P3 | Q3 | P4 | Q4 | P5 | Q5 | P6 | Q6 | P7 | Q7 | P8 | Q8 | P9 | Q9 | P10 | Q10 | P11 | Q11 | P12 | Q12 | P13 | Q13 | P14 | Q14 | P15 | Q15 | P16 | Q16
HE1 | 0 | 0 | 2500 | 0
HE2 | 0 | 0 | 2500 | 0
HE3 | 0 | 0 | 2500 | 0
HE4 | 0 | 0 | 2500 | 0
HE5 | 0 | 0 | 2500 | 0
[NAME] | 0 | 0 | 2500 | 0
HE7 | 0 | 0 | 2500 | 0
HE8 | 0 | 0 | 2500 | 0
HE9 | 0 | 0 | 2500 | 0
HE10 | 0 | 0 | 2500 | 0
HE11 | 0 | 0 | 2500 | 0
HE12 | 0 | 0 | 2500 | 0
HE13 | 0 | 0 | 2500 | 0
HE14 | 0 | 0 | 2500 | 0
HE15 | 0 | 0 | 2500 | 0
HE16 | 0 | 0 | 2500 | 0
HE17 | 0 | 0 | 2500 | 0
HE18 | 0 | 0 | 2500 | 0
HE19 | 0 | 0 | 2500 | 0
HE20 | 0 | 0 | 2500 | 0
HE21 | 0 | 0 | 2500 | 0
HE22 | 0 | 0 | 2500 | 0
HE23 | 0 | 0 | 2500 | 0
HE24 | 0 | 0 | 2500 | 0
Accepted Volumes
 | MCP | Q1 |  | Q2 |  | Q3 |  | Q4 |  | Q5 | Total
HE1
HE2
HE3
HE4
HE5
[NAME]
HE7
HE8
HE9
HE10
HE11
HE12
HE13 |  |  | 36.9 | 36.9 | 36.9 | 37.1 | 36.9 | 36.7 | 0.5 | 25 | 0
HE14 |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 5 | 5 | 5
HE15
HE16
HE17
HE18
HE19
HE20
HE21
HE22
HE23
HE24
Spreadsheet: 853087d1703038808-present-one-row-of-raw-data-in-a-sheet-using-a-different-layout-in-another-sheet-work-order-template-dec-19-2023
Sheet: WO&OP List

Work Order | S.O. # | Date Due | Part No | Drawing No | Description | Quantity Required | Status | Type | Part # Op | Qty per PCS/Hr | Type | Part # Op | Qty per PCS/Hr | Type
W24-0001 | Various & Stock | 2023-12-12 00:00:00 | LAD-A1 | LAD-A1 | RUNG PKGD | 90 | Complete | OP | ASSEMBLE HARDWARE AS PER DRAWING | 50 | OP | PKG | 50
W24-0002 | Various & Stock | 2023-12-12 00:00:00 | LAD-BP1[A] | LAD-BP1[A] | RUNG FORMED | 90 | Complete | OP | FORM PUNCH | 15
Spreadsheet: 49992d1249407978-count-and-total-the-unknown-matching-data-occurences-across-multi-worksheets-dummy2
Sheet: Jan

cat | 101
cat | 101
cat | 101
cat | 101
cat | 101
dog | 801
dog | 801
dog | 802
dog | 802
dog | 802
dog | 802
dog | 802
bird | 1
bird | 1
bird | 1
bird | 1
bird | 1
bird | 1
bird | 1
bird | 1
rabbit | 501
rabbit | 501
rabbit | 501
rabbit | 501
rabbit | 501
rabbit | 501
dog | 803
dog | 803
dog | 803
worm | 401
worm | 401
worm | 401
Spreadsheet: 196671d1354065495-read-the-top-three-items-from-a-goods-list-top-3
Sheet: Sheet1

 |  |  |  | Objects |  |  |  |  | Top 3
 |  |  |  | 1 | Apple
 |  |  |  | 2 | Pear
 |  |  |  | 3 | Orange
 |  |  |  | 4 | [NAME]
 |  |  |  | 5 | Grape |  |  |  | arrayformula!
 |  |  |  | 6 | [NAME]
 |  | << no blank cells in "range"
 |  |  |  |  | [NAME]
 |  |  |  |  | The first column is populated by randomly reading datae from the objects list.
 |  |  |  |  | The 1st, 2nd and 3rd cells then read the top 3 items in the list from the pivot table on sheet two
 |  |  |  |  | However, they do not update when the sheet is calculated. Updating the pivot table, updates the data
 |  |  |  |  | but the only way to have the 1st 2nd and 3rd cells update is to recalc the sheet which in turn recalcs the info in th first column
Spreadsheet: 793407d1661448979-combine-let-formulas-let-sample-to-combine
Sheet: Summary

 |  | Sep'22 | DA-140200-DD01 | Warehouse | 5 | SEP
 | Jhon | Sep'22 | DA-140201-DD19 | Office | 2
 | Jhon | Sep'22 | DA-140201-DD21 | Resto | 4
 | Jhon | Sep'22 | DA-140201-DD22 | Kids Zone | 3
 | [NAME] | Sep'22 | DA-140200-DD01 | Warehouse | 5
 | [NAME] | Sep'22 | DA-140201-DD20 | Pool | 1
 | [NAME] | Sep'22 | DA-140201-DD21 | Resto | 5
 | Daren | Sep'22 | DA-140201-DD19 | Office | 2
 | Daren | Sep'22 | DA-140201-DD20 | Pool | 3
 | Daren | Sep'22 | DA-140201-DD21 | Resto | 4
 | Daren | Sep'22 | DA-140201-DD22 | Kids Zone | 4
 | [NAME] | Sep'22 | DA-140200-DD01 | Warehouse | 2
 | [NAME] | Sep'22 | DA-140201-DD20 | Pool | 4
 |  | Sep'22 | DA-140200-DD01 | Warehouse | 10 | AUG
 | Jhon | Sep'22 | DA-140201-DD19 | Office | 10
 | Jhon | Sep'22 | DA-140201-DD21 | Resto | 5
 | Jhon | Sep'22 | DA-140201-DD22 | Kids Zone | 5
 | [NAME] | Sep'22 | DA-140200-DD01 | Warehouse | 2
 | [NAME] | Sep'22 | DA-140201-DD19 | Office | 2
 | Daren | Sep'22 | DA-140200-DD01 | Warehouse | 33
 | Daren | Sep'22 | DA-140201-DD19 | Office | 33
 | Daren | Sep'22 | DA-140201-DD20 | Pool | 33
 | [NAME] | Sep'22 | DA-140201-DD20 | Pool | 6
 | [NAME] | Sep'22 | DA-140201-DD21 | Resto | 6
 | [NAME] | Sep'22 | DA-140201-DD22 | Kids Zone | 6
Spreadsheet: 757698d1638404993-the-two-columns-a-and-b-are-repeated-and-concatenated-together-forumhelp_11-28
Sheet: Sheet1

Name | Type |  |  | Name | Type
zucca | Type1 |  |  |  |  |  |  |  | Type1、Type4、Type10
hellen | Type2 |  |  | hellen |  |  |  | hellen | Type2、Type8
dee | [NAME] |  |  | dee |  |  |  | dee | Type3、Type7
zucca | Type4 |  |  | [NAME] |  |  |  | [NAME] | Type5
[NAME] | Type5 |  |  | cheves |  |  |  | cheves | Type6
cheves | Type6
dee | Type7 |  |  |  | Type6
hellen | Type8 |  |  | dee | Type3、Type7
zucca | Type1 |  |  | hellen | Type2、Type8
zucca | Type10 |  |  | [NAME] | Type5
 |  |  |  | zucca | Type1、Type4、Type10
Spreadsheet: 231574d1367140026-is-there-a-simplified-method-for-sorting-extracted-data-sample-sort-2
Sheet: FRIDAY

WHO'S WORKING WHERE? |  |  |  |  |  |  |  | FRIDAY -
AM BOX OFFICE |  |  |  |  |  |  | PM BOX OFFICE
HRS | SHIFT | STAFF MEMBER | TILL # | BREAK TIME | BREAKS TAKEN |  | HRS | SHIFT | STAFF MEMBER | TILL # | BREAK TIME | BREAKS TAKEN
AM CONCESSIONS |  |  |  |  |  |  | PM CONCESSIONS
HRS | SHIFT | STAFF MEMBER | TILL # | BREAK TIME | BREAKS TAKEN |  | HRS | SHIFT | STAFF MEMBER | TILL # | BREAK TIME | BREAKS TAKEN
AM DOOR |  |  |  |  |  |  | PM DOOR
HRS | SHIFT | STAFF MEMBER | SIDE | BREAK TIME | BREAKS TAKEN |  | HRS | SHIFT | STAFF MEMBER | SIDE | BREAK TIME | BREAKS TAKEN
AM USHER |  |  |  |  |  |  | PM USHER
HRS | SHIFT | STAFF MEMBER |  | BREAK TIME | BREAKS TAKEN |  | HRS | SHIFT | STAFF MEMBER |  | BREAK TIME | BREAKS TAKEN
Forecasted Attendance |  |  |  |  |  |  |  |  | Per [NAME] at 1:00pm
Last Year's Attendance |  |  |  |  |  |  |  |  | Per [NAME] at 3:00pm
Last Year's Per [NAME] |  |  |  |  |  |  |  |  | Per [NAME] at 5:30pm
Scheduled Hours |  |  |  |  |  |  |  |  | Per [NAME] at 8:00pm
Scheduled Wages |  |  |  |  |  |  |  |  | Ending Per Cap
 |  |  |  |  |  |  |  |  | Per Cap Goal
Spreadsheet: 122908d1317236494-what-if-scenario-true-insert-text-here-book1
Sheet: Sheet1

 | INITIALS | NAME |  |  |  |  |  | INITIALS | JOBS
 | JL | JAYSON | JOB ONE |  |  |  | [NAME] | JL | formula here
 | [NAME] | JENNY | JOBE TWO |  |  |  | jenny | [NAME] | formula here
 | JN | [NAME] | JOB THREE |  |  |  | [NAME] | JN | formula here
 | JL | JAYSON | JOB FOUR
 | [NAME] | JENNY | JOB FIV
 | JL | JAYSON | JOB SIX
 |  |  |  |  | So in the formula box, I want a formula that will find all the  jobs with the initial JL and put them all in the same box
Spreadsheet: 335ad255-428a-44a7-a63c-4bb637fc4f3e
Sheet: New Course Denial

NEW COURSES DENIED FOR FY1314 CONCURRENT ENROLLMENT
11-Digit Core Codes for Use in the High School | CIP Code | USOE Course Title                                               Assignment Names Updated 04/26/2005 | Reason for Denial | HS Core Flag | HE GenEd Code | College | Course Prefix | Course Prefix | Course Title | [NAME].
[PHONE] | 110216 | 3D Animation CE | Prerequisite courses should be taught first.  Listed instructor is not endorsed to teach course work.  Prereq: ART 2630 and ART 1620 or instructor approval. | N |  | SLCC | ART | 2640 | Introduction to 3D Animation | 3
[PHONE] | 110215 | 3D Graphics CE | Prerequisite courses should be taught first.  Listed instructor is not endorsed to teach course work.  Prereq: ART 1800 or instructor approval. | N |  | SLCC | ART | 2630 | Introduction to 3D Modeling | 3
[PHONE] |  | Anatomy & Physiology CE | Course may NOT be offered for Anatomy & Physiology or Advanced Health Science credit. Districts must award Foundations of Nutrition credit. | N |  | UVU | NUTR | 1020 | Foundations of Human Nutrition | 3
[PHONE] | 520621 | Entrepreneurship - Business CE | Upper level class.  Prereq: BUS 1050, MKTG 1030, ACCT 2020 | N |  | SLCC | MGT | 2020 | Entrepreneurship | 3
 |  |  | No Core Code counterpart.  District must submit request for new code approval to USOE.   Prereq: Recommended CIS 1130 and CS 1410. | N |  | SLCC | CSIS | 2640 | Mobile IOS App Development | 3
Spreadsheet: 885391d1734932648-dashboard-without-pivot-tables-only-formula-and-functions-dummy-data
Sheet: dashboard

 |  | Fiscal Month |  |  | Area Manager
 | Select the fiscal month → | 2024P09 |  |  | OS Lvl 1 Phone
 |  | Fiscal Week |  |  | Wave
 | Select the fiscal week → | 2024P09W2 |  |  | OS Lvl 1 Phone
 |  | Supervisors |  |  | Agent Name
 | Select the Team Manager → | [NAME] |  |  | [NAME]
 | Topic (bot)
 | Job Details | Handled | [NAME] | Jobs | Accurate | Innacurate | AHT
 |  |  |  |  |  |  |  |  | Quarter
 |  |  |  |  |  |  |  | Count |  |  | Average
 | Team | Handled | [NAME] | Jobs | Accurate | Innacurate | AHT | MTD | QTD | YTD | MTD | QTD | YTD
 |  |  |  | ??? | ??? | ??? | ???
Spreadsheet: 288033d1389071415-transform-thousands-of-columns-to-a-single-row-tranform-columns-to-a-single-row-_-1
Sheet: target

A | 02/27/2009 | 100.005 | 0 | 01/06/1989 | 06/24/1992 | B | 01/06/1989 | 61.24 | -- | 01/06/1989 | 06/24/1992 | C | 07/10/1987 | 113.95 | 0.283333333333333 | 07/10/1987 | 08/08/1989 | D | 02/27/2009 | 100.005 | 0 | 01/06/1989 | 06/24/1992 | E | 01/06/1989 | 61.24 | -- | 01/06/1989 | 06/24/1992 | F | 07/10/1987 | 113.95 | 0.283333333333333 | 07/10/1987 | 08/08/1989 | H | 02/27/2009 | 100.005 | 0 | 01/06/1989 | 06/24/1992 | I | 01/06/1989 | 61.24 | -- | 01/06/1989 | 06/24/1992 | J | 07/10/1987 | 113.95 | 0.283333333333333 | 07/10/1987 | 08/08/1989
Spreadsheet: 154850d1336581149-hai-frds-please-help-me-to-solve-this-prob-date-count
Sheet: Sheet1

plan date | achievement date | Plan
2012-05-01 00:00:00 | 2012-05-03 00:00:00 | w1 |  |  | may |  | june |  | july |  | august
2012-05-03 00:00:00 | 2012-05-04 00:00:00 | w1 |  |  | w1 |  | w2 |  | w3 |  | w4
2012-05-05 00:00:00 | 2012-05-05 00:00:00 | w1 |  |  | 2012-05-01 00:00:00 | 2012-05-07 00:00:00 | 2012-05-08 00:00:00 | 2012-05-14 00:00:00 | 2012-05-15 00:00:00 | 2012-05-21 00:00:00 | 2012-05-22 00:00:00 | 2012-05-31 00:00:00
2012-05-07 00:00:00 | 2012-05-09 00:00:00 | w1 |  |  | plan | achivement | plan | achivement | plan | achivement | plan | achivement
2012-05-09 00:00:00 |  | w2
2012-05-11 00:00:00 |  | w2 |  |  | .
2012-05-13 00:00:00 |  | w2
2012-05-15 00:00:00 | 2012-05-17 00:00:00 | w3
2012-05-16 00:00:00 | 2012-05-19 00:00:00 | w2
2012-05-17 00:00:00 | 2012-05-21 00:00:00 | w3
2012-05-18 00:00:00 |  | w2
2012-05-19 00:00:00 | 2012-05-25 00:00:00 | w3
2012-05-20 00:00:00 | 2012-05-27 00:00:00 | w2
2012-05-21 00:00:00 | 2012-05-29 00:00:00 | w3
2012-05-22 00:00:00 |  | w4
2012-05-23 00:00:00 |  | w4
2012-05-24 00:00:00 |  | w4
2012-05-25 00:00:00 |  | w4
2012-05-26 00:00:00 |  | w4
2012-05-27 00:00:00 |  | w4
2012-05-28 00:00:00 |  | w4
2012-05-29 00:00:00 |  | w4
2012-05-30 00:00:00 | 2012-06-16 00:00:00 | w4
2012-05-31 00:00:00 | 2012-06-18 00:00:00 | w4