tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 3e6d92e1-7ec1-4553-bbc1-60558c176899
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (40 Entries):
 | 14 Wireless 14.3 Wireless applications
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Anylink Systems AG | Germany | Ingolstadt | 85055 | A4.375
2 | Art of Technology AG | Switzerland | Zürich | 8005 | B4.157/2
3 | A & S Automatisierungs- und [NAME] | Germany | [NAME] | 98708 | B2.130
4 | [NAME] GmbH | Germany | [NAME] | 82152 | A4.139
5 | austriamicrosystems AG | Austria | Unterpremstätten | 8141 | A5.107
6 | Benchmark Drives GmbH | Germany | [NAME] am Main | 63791 | B2.474
7 | Circuit Design, Inc. | Japan | Azumino-City |  | A4.367
8 | CODICO GmbH | Austria | Perchtoldsdorf | 2380 | A5.507
9 | COMPOTRON GMBH | Germany | München | 80335 | A4.W01
10 | Contrinex GmbH | Germany | Nettetal | 41334 | A2.375
11 | Emerson & Cuming Microwave Products N.V. | Belgium | Westerlo | 2260 | B5.209
12 | EnOcean GmbH | Germany | Oberhaching | 82041 | A4.266
13 | Fraunhofer-Institut für Mikroelektronische Schaltungen und Systeme (IMS) | Germany | Duisburg | 47057 | A5.139
14 | Fraunhofer-Institut für Photonische Mikrosysteme IPMS | Germany | Dresden | 01109 | A5.221
15 | GREATech GmbH | Germany | Mülheim/Ruhr | 45478 | A4.466
16 | HARTING Deutschland GmbH & Co. [NAME] | Germany | Minden | 32427 | B3.542
17 | HM-Funktechnik GmbH | Germany | Nonnweiler | 66620 | A4.369
18 | Honeywell Precision Sensors | USA | Plymouth | MN 55441 | A2.338
19 | INCIDE SA | Spain | San Sebastian | 20018 | A5.267
20 | ISAD e.V. | Germany | Nonnweiler | 66620 | A4.466
21 | [NAME] | Germany | Rosenheim | 83026 | A2.171
22 | MACRO GROUP | Russia | St. Petersburg | 196105 | A6.115/9
23 | MCB - Microsystems Center Bremen Universität Bremen - FB1 | Germany | Bremen | 28359 | A2.M04
24 | [NAME] | Germany | Magdeburg | 39106 | A5.560/13
25 | MEV Elektronik Service GmbH | Germany | Hilter | 49176 | A4.260
26 | Microdis Electronics GmbH | Germany | [NAME] | 67354 | A5.163
27 | MIPOT S.p.A. | Italy | Cormons (GO) | 34071 | A4.563
28 | Origin GPS Ltd | Israel | Jerusalem | 91391 | A4.468
29 | Round Solutions GmbH & Co. [NAME] | Germany | Neu-Isenburg | 63263 | A4.W12
30 | Samsung Electro-Mechanics GmbH | Germany | Schwalbach | 65824 | B6.173
31 | Schreiner ProTech ein Geschäftsbereich der Schreiner Group GmbH & Co. [NAME] | Germany | Oberschleißheim | 85764 | B1.668
32 | Seltech | France | ORLY | 94310 | A5.210
33 | SE Spezial-Electronic AG Design Driven Distribution ACTIVEs | PASSIVEs | EMECHs | Germany | Bückeburg | 31675 | A4.550
34 | ShortLink AB | Sweden | Säffle | 661 42 | A4.143
35 | [NAME] Vertriebs GmbH | Germany | Dachau | 85221 | A5.361
36 | SUMIDA Components & Modules GmbH | Germany | Obernzell | 94130 | B5.325
37 | Texim Europe GmbH | Germany | Quickborn | 25451 | A3.350
38 | u-blox AG | Switzerland | Thalwil | 8800 | A4.121
39 | United Tectsa | India | Nashik | 422403 | A6.642
40 | ZF Electronics GmbH  (CHERRY) | Germany | Auerbach | 91275 | A6.624
Spreadsheet: 840848d1693055883-how-to-distribute-points-equal-distribution-aligw
Sheet: Sheet1

A | 10 | 0
B | 10 | 1
C | 10 | 1
D | 10 | 1
E | 10 | 1
Spreadsheet: 4813974e-1413-4397-a3a0-72773185d66d
Sheet: Sheet1

Unnamed: 0 | Directors and Heads of Service | Managers | Team Leaders | Caretakers | Staff | Total
Gender
Female | <10 | 8 | 16 | 16 | 121 | 167
Male | 10 | 18 | 31 | 142 | 111 | 312
Total | ~16 | 26 | 47 | 158 | 232 | ~479
Ethnicity
Asian | <10 | <10 | <10 | <10 | 71 | 87
Black | <10 | <10 | 17 | 37 | 44 | 103
Prefer not to say |  | <10 |  |  | <10 | <10
Dual Heritage |  | <10 | <10 | <10 | <10 | 19
Other |  | <10 |  | <10 | <10 | <10
White English | 11 | 15 | 18 | 70 | 91 | 205
White Other | <10 | <10 | <10 | 35 | 11 | 52
Total | ~16 | ~26 | ~47 | ~158 | ~232 | ~479
Sexual Orientation
Bisexual |  |  |  | <10 | <10 | <10
Prefer not to say | <10 | <10 | 12 | 34 | 43 | 95
Gay | <10 | <10 |  | <10 | <10 | <10
Heterosexual | 10 | 21 | 35 | 117 | 183 | 366
Lesbian | <10 |  |  | <10 | <10 | <10
Total | ~16 | ~26 | 47 | ~158 | ~232 | ~479
Religion and belief
Buddhist |  |  |  | <10 | <10 | <10
Christian | <10 | 11 | 20 | 77 | 94 | 209
Decline to State | <10 | <10 | 10 | 25 | 31 | 71
Hindu |  |  | <10 | <10 | <10 | <10
Muslim |  | <10 | <10 | <10 | 65 | 82
No religion | <10 | <10 | <10 | 35 | 25 | 78
Other |  | <10 | <10 | <10 | 11 | 26
Sikh |  |  |  | <10 | <10 | <10
Total | ~16 | ~26 | ~47 | ~158 | ~232 | ~479
Age Group
<=19 |  |  |  | <10 | <10 | <10
20 - 29 |  | <10 | <10 | 22 | 47 | 72
30 - 39 | <10 | <10 | 11 | 36 | 47 | 106
40 - 49 | 10 | 10 | 23 | 50 | 67 | 160
50 - 59 | <10 | <10 | 10 | 34 | 61 | 114
60 - 69 |  |  | <10 | 13 | <10 | 20
70+ |  |  |  | <10 |  | <10
Total | ~16 | ~26 | ~47 | ~158 | ~232 | ~479
Disability
Prefer not to say |  | <10 | 11 | 38 | 33 | 83
No | 16 | 23 | 36 | 115 | 191 | 381
Yes |  | <10 |  | <10 | <10 | 15
Total | 16 | ~26 | 47 | ~158 | ~232 | 479
Spreadsheet: 885778d1735622425-listing-top-3-clients-basis-the-revenue-listing-top-3-clients-basis-the-revenue
Sheet: Sheet1

Client Name | Revenue | Year | Category |  | Year | FY2025
A | 2 | FY2023 | Smooth
A | 3 | FY2023 | Smooth |  | Sum of Revenue | Category
A | 4 | FY2023 | Far |  | Client Name | Far | Smooth | Grand Total
B | 5 | FY2023 | Smooth |  | E | 15 | 0 | 15
B | 6 | FY2024 | Smooth |  | C | 15 | 0 | 15
B | 10 | FY2024 | Smooth |  | A | 0 | 9 | 9
A | 13 | FY2024 | Smooth |  | Grand Total | 30 | 9 | 39
A | 13 | FY2024 | Far
A | 12 | FY2023 | Smooth |  | The easiest way to do this is by using PivotTable: with Year in Filters, Category in Columns, Client Name in Rows and Revenue in Values.
B | 15 | FY2023 | Smooth |  | Set the Sort Options to Sum of Revenue in [NAME] and Select Top 10 Value Filters.
B | 3 | FY2023 | Smooth
B | 9 | FY2024 | Far
C | 7 | FY2024 | Smooth
D | 3 | FY2025 | Smooth
E | 8 | FY2025 | Far
F | 9 | FY2023 | Smooth
D | 11 | FY2023 | Smooth
D | 2 | FY2025 | Far
C | 6 | FY2023 | Far
C | 5 | FY2025 | Far
C | 7 | FY2025 | Far
F | 4 | FY2024 | Smooth
F | 7 | FY2024 | Smooth
A | 4 | FY2023 | Smooth
B | 5 | FY2024 | Far
C | 6 | FY2023 | Smooth
D | 3 | FY2023 | Smooth
E | 2 | FY2023 | Far
F | 4 | FY2024 | Far
F | 6 | FY2023 | Smooth
E | 7 | FY2025 | Far
A | 9 | FY2025 | Smooth
B | 7 | FY2024 | Smooth
C | 3 | FY2025 | Far
D | 1 | FY2025 | Far
Spreadsheet: 3296c906-e852-465a-a6cd-16d78634b9b7
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
ALP | Test | ALP | [NAME], Serum | [NAME], S | Photometric, p-Nitrophenol Phosphate | Serum Gel Tube: SGT |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Serum gel Acceptable: Red top Submission Container/Tube: Plastic vial [NAME]: 0.5 mL Additional Information: Patient's age and sex are required. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Males 4 years: 149-369 U/L 5 years: 179-416 U/L 6 years: 179-417 U/L 7 years: 172-405 U/L 8 years: 169-401 U/L 9 years: 175-411 U/L 10 years: 191-435 U/L 11 years: 185-507 U/L 12 years: 185-562 U/L 13 years: 182-587 U/L 14 years: 166-571 U/L 15 years: 138-511 U/L 16 years: 102-417 U/L 17 years: 69-311 U/L 18 years: 52-222 U/L > or =19 years: 45-115 U/L Females 4 years: 169-372 U/L 5 years: 162-355 U/L 6 years: 169-370 U/L 7 years: 183-402 U/L 8 years: 199-440 U/L 9 years: 212-468 U/L 10 years: 215-476 U/L 11 years: 178-526 U/L 12 years: 133-485 U/L 13 years: 120-449 U/L 14 years: 153-362 U/L 15 years: 75-274 U/L 16 years: 61-264 U/L 17-23 years: 52-144 U/L 24-45 years: 37-98 U/L 46-50 years: 39-100 U/L 51-55 years: 41-108 U/L 56-60 years: 46-118 U/L 61-65 years: 50-130 U/L > or =66 years: 55-142 U/L Reference values have not been established for patients that are <4 years of age. | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 84075 |  |  |  |  | Rochester
ALP | [NAME] | SERUM | Serum |  |  |  | Frozen | 60 days
ALP | Result | ALP | [NAME], S | [NAME], S | Numeric |  |  |  |  | U/L |  |  |  |  |  |  |  |  |  | 6768-6
Spreadsheet: 219058d1362656821-formula-to-calculate-working-hours-between-two-dates-not-working-correctly-formula-issue-ans
Sheet: Sheet1

Date/Time Received | Date/Time Resolved | [NAME] | Column1
2013-03-04 22:45:00 | 2013-03-05 15:34:00 |  |  | 08:30:00 | 17:30:00
2013-03-05 09:05:00 | 2013-03-05 09:15:00
2013-03-05 09:19:00 | 2013-03-05 10:23:00
2013-03-05 10:00:00 | 2013-03-05 10:20:00
2013-03-05 11:45:00 | 2013-03-05 12:15:00
2013-03-05 11:54:00 | 2013-03-05 13:00:00
2013-03-06 17:29:00 | 2013-03-07 09:30:00
Spreadsheet: 11a5fd0f-7f2b-4156-8487-c92800e88dfb
Sheet: unit productivity

Serials Unit Statistics FY08 and FY09
COLLECTION METRICS
 | FY08 | FY09 | % change
Serial volumes withdrawn | 94 | 112
Mform pieces withdrawn | 0 | 0 | 0
Serial volumes added (total) | 3520 | 3085
Subscriptions | 690 | 626
Binding | 2370 | 2414
Gifts | 460 | 45
Mform pieces added (total) | 212 | 645
Film | 212 | 250
Fiche | 0 | 395 | N/A
PRODUCTIVITY METRICS
 | FY08 | FY09 | % change
[NAME] processed | 15855 | 14962
[NAME] temp bound | 403 | 60
[NAME] mended (in-house) | 245 | 156
Claims sent | 1029 | 557
Pieces checked in | 12229 | 10196
[NAME] returned from bindery (total) |  | 3525
Journals and other materials | 2481 | 2394
Repairs | 71 | 597
Non-Library | 289 | 534
Spreadsheet: 689569d1596522172-formula-to-put-date-in-proper-format-date-example-aligw
Sheet: Sheet1

Date
43868 | Shoud be 02/07/2020 (2nd July 2020) |  | 2020-07-02 00:00:00 | 44014
22/07/2020 12:00:00 AM | Remove time 22/07/2020
27/07/2020 12:00:00 AM | Remove time 22/07/2020
43838 | Shoud be 01/08/2020 (1st August 2020) |  | 2020-08-01 00:00:00 | 44044
43838 | Shoud be 01/08/2020 (1st August 2020)
43838 | Shoud be 01/08/2020 (1st August 2020)
Spreadsheet: 300702d1393538038-selecting-specific-numbers-in-a-column-among-a-long-list-of-numbers-filter-sample
Sheet: Sheet1

Column 1 | Cloumn 2 | Filter Column
1 | Data A | No
2 | Data B | Yes
3 | Data C | Yes
4 | Data D | No
5 | Data E | Yes
6 | etc… | No
7 |  | No
8 |  | No
9 |  | Yes
10 |  | No
11 |  | No
12 |  | No
13 |  | No
14 |  | No
15 |  | No
16 |  | Yes
17 |  | No
18 |  | No
19 |  | No
20 |  | No
21 |  | No
22 |  | No
23 |  | No
24 |  | No
25 |  | No
26 |  | No
27 |  | No
28 |  | No
29 |  | No
30 |  | No
31 |  | No
32 |  | No
33 |  | No
34 |  | No
35 |  | No
36 |  | No
37 |  | No
38 |  | No
39 |  | No
40 |  | No
41 |  | No
42 |  | No
43 |  | No
44 |  | No
45 |  | No
46 |  | No
47 |  | No
48 |  | No
49 |  | No
50 |  | No
51 |  | No
52 |  | No
53 |  | No
54 |  | No
55 |  | No
56 |  | No
57 |  | No
58 |  | No
59 |  | No
60 |  | No
61 |  | No
62 |  | No
63 |  | No
64 |  | No
65 |  | No
66 |  | No
67 |  | No
68 |  | No
69 |  | No
70 |  | No
71 |  | No
72 |  | No
73 |  | No
74 |  | No
75 |  | No
76 |  | No
77 |  | No
78 |  | No
79 |  | No
80 |  | No
81 |  | No
82 |  | No
83 |  | No
84 |  | No
85 |  | No
86 |  | No
87 |  | No
88 |  | No
89 |  | No
90 |  | No
91 |  | No
92 |  | No
93 |  | No
94 |  | No
95 |  | No
96 |  | No
97 |  | No
98 |  | No
99 |  | No
100 |  | No
101 |  | No
102 |  | No
103 |  | No
104 |  | No
105 |  | No
106 |  | No
107 |  | No
108 |  | No
109 |  | No
110 |  | No
111 |  | No
112 |  | No
113 |  | No
114 |  | No
115 |  | No
116 |  | No
117 |  | No
118 |  | No
119 |  | No
120 |  | No
121 |  | No
122 |  | No
123 |  | No
124 |  | No
125 |  | No
126 |  | No
127 |  | No
128 |  | No
129 |  | No
130 |  | No
131 |  | No
132 |  | No
133 |  | No
134 |  | No
135 |  | No
136 |  | No
137 |  | No
138 |  | No
139 |  | No
140 |  | No
141 |  | No
142 |  | No
143 |  | No
144 |  | No
145 |  | No
146 |  | No
147 |  | No
148 |  | No
149 |  | No
150 |  | Yes
151 |  | No
152 |  | No
153 |  | No
154 |  | No
155 |  | No
156 |  | No
157 |  | No
158 |  | No
159 |  | No
160 |  | No
161 |  | No
162 |  | No
163 |  | No
164 |  | No
165 |  | No
166 |  | No
167 |  | No
168 |  | No
169 |  | No
170 |  | No
171 |  | No
172 |  | No
173 |  | No
174 |  | No
175 |  | No
176 |  | No
177 |  | No
178 |  | No
179 |  | No
180 |  | No
181 |  | No
182 |  | No
183 |  | No
184 |  | No
185 |  | No
186 |  | No
187 |  | No
188 |  | No
189 |  | No
190 |  | No
191 |  | No
192 |  | No
193 |  | No
194 |  | No
195 |  | No
196 |  | No
197 |  | No
198 |  | No
199 |  | No
200 |  | No
Spreadsheet: 56658d1256793506-lookup-steps
Sheet: Sheet1

Step # | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 |  | Step #: | 4
1 | 26.05110857142858 | 30.39296000000001 | 27.09315291428572 | 31.60867840000001 | 28.17687903085715 | 32.87302553600001 | 29.30395419209144 | 34.18794655744001 |  | Item #: | R3
2 | 27.09315291428572 | 31.60867840000001 | 28.17687903085715 | 32.87302553600001 | 29.30395419209144 | 34.18794655744001 | 30.47611235977509 | 35.55546441973761 |  | Value: | 30.47611235977509
3 | 28.17687903085715 | 32.87302553600001 | 29.30395419209144 | 34.18794655744001 | 30.4761123597751 | 35.55546441973761 | 31.6951568541661 | 36.97768299652711
4 | 29.30395419209144 | 34.18794655744001 | 30.47611235977509 | 35.55546441973761 | 31.6951568541661 | 36.97768299652711 | 32.96296312833275 | 38.4567903163882
5 | 30.4761123597751 | 35.55546441973761 | 31.6951568541661 | 36.97768299652711 | 32.96296312833275 | 38.4567903163882 | 34.28148165346607 | 39.99506192904373
6 | 31.6951568541661 | 36.97768299652711 | 32.96296312833275 | 38.4567903163882 | 34.28148165346606 | 39.99506192904373 | 35.6527409196047 | 41.59486440620548
7 | 32.96296312833274 | 38.4567903163882 | 34.28148165346605 | 39.99506192904373 | 35.6527409196047 | 41.59486440620548 | 37.07885055638889 | 43.2586589824537
8 | 34.28148165346606 | 39.99506192904373 | 35.6527409196047 | 41.59486440620548 | 37.07885055638889 | 43.2586589824537 | 38.56200457864445 | 44.98900534175186
9 | 35.6527409196047 | 41.59486440620548 | 37.07885055638889 | 43.2586589824537 | 38.56200457864444 | 44.98900534175186 | 40.10448476179022 | 46.78856555542193
10 | 37.91780571428572 | 44.23744 | 39.43451794285715 | 46.0069376 | 41.01189866057143 | 47.847215104 | 42.65237460699429 | 49.76110370816
11 | 39.81833142857143 | 46.45472000000001 | 41.41106468571429 | 48.31290880000001 | 43.06750727314287 | 50.24542515200001 | 44.79020756406858 | 52.25524215808001
Spreadsheet: 793626d1661586892-pull-turn-static-values-into-a-dynamic-array-without-using-offset-excel-problem-1-
Sheet: Sheet1

 | [NAME] | 5
 | [NAME] | 15
Method 1
 |  | INPUT ROW |  |  | 4 |  | 7 |  |  | 10 |  |  | 15
 |  |  |  |  | 4 | 0 | 7 | 0 | 0 | 10 | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 1fa5aaf2-b233-48a4-a340-1a69283a545d
Sheet: Sheet1

Table 4--Cottonseed:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  |  | Ending
August 1 | stocks | Production | Imports | Total |  | Crush | Exports | Other | Total | stocks
 | 1,000 short tons
2011/12 | 617.563 | 5370 | 71.60123601533701 | 6059.164236015337 |  | 2400 | 132.689 | 3096.475236015337 | 5629.164236015337 | 430
2012/131 | 430 | 5666 | 0.005 | 6096.005 |  | 2500 | 191.377 | 2912.628 | 5604.005 | 492
2013/142 | 492 | 4357 | 100 | 4949 |  | 2200 | 150 | 2158 | 4508 | 441
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2013-11-13 09:21:31.720000
Spreadsheet: 676995d1589133015-extract-data-from-column-which-contain-character-and-in-left-side-of-character-question
Sheet: Sheet1

 | 12345678/001-text1 |  |  |  | =IFERROR(LEFT(INDEX(B:B,AGGREGATE(15,6,ROW($B$4:$B$500)/ISNUMBER(SEARCH("/*-",$B$4:$B$500)),ROWS(C$4:C4))),12),"")
 | 11223344/004-text2
 | 22334455/009-text3
 | 22445599/001-text4
 | 44113322/002-text5
 | text6
 | text7
 | [NAME]
 | 44771254/012-text9
 | 99112211/002-text10
 | 77993322/019-text11
 | 66229977/001-text12
 | text13
 | 24296040/002-text14
 | 24296041/002-text15
 | 24296043/002-text16
Spreadsheet: 880169d1727790317-if-or-ifs-function-faton-invoice-nr-1-aligw
Sheet: Sheet1

No. | Date | Description of the transaction | Number of | Debit | Credit | Balance
 |  |  | invoice | Input (+) | output(-)
1 | 2022-01-01 00:00:00 |  |  |  |  | 100
2 | 2022-01-02 00:00:00 |  |  | 250
3 | 2022-01-03 00:00:00 |  |  | 0 | 10
4 | 2022-01-04 00:00:00 |  |  | 200 | 100
5 | 2022-01-05 00:00:00 |  |  | 0
Spreadsheet: 1c3e0cb1-f0d5-4446-905d-7fbbb8137c38
Sheet: Sheet1

Job Recruitment Listing
 | Website
Oklahoma State University | http://hireosugrads.com/2/Employers/PostAJob.aspx
Oklahoma University | http://www.ou.edu/career/Employers/index.html
Office of Personnel Management | OPM (email [EMAIL])
OETA and Internal Email | OETA website - [NAME]
Oklahoma Baptist | http://www.okbu.edu/campuslife/studentservices/submit_job.html
Oklahoma Christian | http://connect.oc.edu/networking/submit.asp
UCO | https://www.myinterfase.com/ucok/employer/home.aspx
East Central | https://www.myinterfase.com/ecok/employer/home.aspx
Tulsa University | https://utulsa-csm.symplicity.com/employers/
Oklahoma Association of Broadcasters | http://oabok.org/JobBank/Employers
Cameron University | http://www.collegecentral.com/cameron/
OCU (Oklahoma City University) | https://www.myinterfase.com/okcu/employer/home.aspx
Rogers State | http://www.rsu.edu/hirehillcats/employers.asp
Northeastern Oklahoma State | https://www.myinterfase.com/nsuok/employer/
Northern Oklahoma College | http://www.collegecentral.com/north-ok/
Oklahoma City Community College | http://www.collegecentral.com/occc/
Langston | [EMAIL]
 | (send job postings)
CPB | CPB.org
Tulsa World Newspaper
Daily Oklahoma Newspaper
OETA is a federally licensed public television network that serves the citizens of Oklahoma with quality educational, non-commercial programming.
Spreadsheet: 836488d1689410899-query-across-multiple-columns-and-multiple-criteria-with-flexible-content-ice-monthly-plan-4-
Sheet: People Check

Project | All
Start | 2024-01-01 00:00:00
Months (+2) |  |  |  |  |  | X
DOA Sum
Person ID | Person Name | Period Cost |  | Total Project Cost
A |  |  |  |  |  |  | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0
B | [NAME] |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
C |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0
D |  |  |  |  |  | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.15 | 0.15 | 0.15
TOTAL
 |  |  |  |  |  | X=I need a generic formula extracting information from each project sheet (Project A, Project B…) based on the date in row 7 and then PersonID in col A
 |  |  |  |  |  | THIS IS A FULL RANGE OF DATES COVERING ALL PROJECTS
 |  |  |  |  |  | There is a range 'projects' which represents Project A ad Project B…shown on the sheet Codes
 |  |  |  |  |  | So for the X in yellow...which  is for person D and month 2024-07-01 (ie a coordinate D * 2024-07-01)
 |  |  |  |  |  | I would like to extract the value (if there is one present) on Project A tab at that 'coordinate' + similar on Project B tab.  Both highlighted also in yellow and note their positions are not in the same place (ie not a fixed cell)
 |  |  |  |  |  | ie 25%+15% = 40%
Spreadsheet: 144254d1330856854-index-match-index-formula-work-slow-book1_avk
Sheet: Sheet1

CODE | [NAME] | DIST | ESN | COUNT | OIL | OIL FILTER | FUEL FILTER | OIL+FUELFILTER | AIR FILTER | LAST OIL CHANGED DATE | LAST OIL FILTER CHANGED DATE | LAST FUEL FILTER CHANGED DATE | [NAME] | LAST AIR FILTER CHANGED DATE | NOS. OF DAY FROM LAST CAHNGED K-OIL | NOS. OF DAY FROM LAST CAHNGED AIR FILTER
 |  |  |  |  | OI | OF | FF | OFF | AF | OI | OF | FF | OFF | AF | 2012-03-04 00:00:00 | 2012-03-04 00:00:00
Z005 | ZILA SATRA NYALAYA |  | D3.1605/0800659 |  | 0 | 0 | 0 | 0 | 0
A002 | A AND E REGIMENT |  | 04.1153/0100005 |  | 1 | 0 | 0 | 1 | 0 | 2011-12-19 00:00:00 |  |  | 2011-12-19 00:00:00 |  | 76
L047 | A C LONDHE | 10 | 4H.2295/1033966 | 4H.2295/10 | 0 | 0 | 0 | 0 | 0
A002 | A.A. ENGINEERS |  | 48.1502/9800607 |  | 1 | 0 | 0 | 1 | 0 | 2011-12-19 00:00:00 |  |  | 2011-12-19 00:00:00 |  | 76
A022 | A.E.C. ENNG. VAHIRA | 08 | 4H.2190/0800108 | 4H.2190/08 | 0 | 0 | 0 | 0 | 0
C030 | [NAME] MARATHA VIDYA PRASARAK SAMAJ(CHATRAPATI ENGG COLLAGE) | 09 | 03.2121/0920320 | 03.2121/09 | 0 | 0 | 0 | 0 | 0
A011 | ABASAHEB KAKDE MAHAVIDYALAYA | 10 | [NAME] | DC.4814/10 | 3 | 0 | 0 | 2 | 0 | 2011-02-09 00:00:00 |  |  | 2011-02-09 00:00:00 |  | 389
A017 | ABHAYKUMAR MACHINERY CO. | 05 | D8.4711/0500006 | D8.4711/05 | 11 | 8 | 0 | 0 | 0 | 2011-08-30 00:00:00 | 2011-08-30 00:00:00 |  |  |  | 187
A018 | ABHIKALP INFRASTRATURE | 09 | 03.1166/0900006 | 03.1166/09 | 2 | 2 | 3 | 0 | 0 | 2010-06-22 00:00:00 | 2011-11-17 00:00:00 | 2011-11-17 00:00:00 |  |  | 621
A023 | ADARSH DAIRY PRODUCTS PVT LTD. | 07 | D4.5801/0700072 | D4.5801/07 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 169207d1342725820-merging-two-sheets-with-identical-unique-identifiers-aa
Sheet: Sheet1

ID | Employee Number | FirstName | LastName | Title | FacilityCode | InternalID | ExternalID
1 | 7289 | [NAME] | Smith | ACCOUNTING ASSISTANT | 171 | 5433
2 | 6453 | [NAME] | Smith | ACCOUNTING ASSOCIATE |  | 5332
3 | 3198 | Stacy | Smith | ACCOUNTING ASSOCIATE |  | 1134
4 | 6406 | [NAME] | Smith | ACCOUNTING ASSOCIATE | 171 | 4038
5 | 7150 | Nick | Smith | ACCOUNTING ASSOCIATE |  | 2345
6 | 2112 | [NAME] | Smith | ACCOUNTING ASSOCIATE |  | 5422
7 | 2842 | [NAME] | Smith | ACCOUNTING ASSOCIATE | 171 | 3136
8 | 5469 | Vince | Smith | ACCOUNTING ASSOCIATE |  | 1342
9 | 5744 | [NAME] | Smith | ACCOUNTING ASSOCIATE | 171 | 6248
10 | 6605 | Cameron | Smith | ACCOUNTING ASSOCIATE | 171 | 2132
11 | 4138 | [NAME] | Smith | ACCOUNTS RECEIVABLE ANALYST | 171 | 3043
12 | 7645 | Sandra | Smith | ADMINISTRATIVE ASSISTANT |  | 2321
13 | 7631 | Alicia | Smith | ADMINISTRATIVE ASSISTANT |  | 1233
14 | 7541 | Stefanie0 | Test | ADMINISTRATIVE ASSISTANT |  | 2334
Spreadsheet: chris_germany__2006__CNR200204
Sheet: CNR200204

Prod |  |  | Contract | Producer |  |  |  |  | [NAME] | Gr Mcf | Btu | Gr Dth | Fuel | [NAME] | Gath | Amt
2002-04-01 00:00:00 | 20020400083G | 2002-06-06 08:58:10 | 83 | PAYNE GAS COMPANY |  | 19335 | 1 | HUBBALL/HORSE CREEK | 804452 | 157 | 1206 | 189 | 0.05 | 178 | 0.32 | 56.96 | 0 | 0 | 0 | 56.96
2002-04-01 00:00:00 | 20020400130G | 2002-06-06 08:58:10 | 130 | THOMPSON | [NAME] | 19151 | 1 | KERMIT/INEZ | 801153 | 4 | 1249 | 5 | 0.05 | 5 | 0.32 | 1.6 | 0 | 0 | 0 | 1.6
2002-04-01 00:00:00 | 20020400164G | 2002-06-06 08:58:10 | 164 | PINE MOUNTAIN OIL AND GAS INC |  | 59407 | 1 | BUFF LICK | 804513 | 2655 | 1257 | 3338 | 0.05 | 3146 | 0.32 | 1006.72 | 0 | 0 | 0 | 1006.72
2002-04-01 00:00:00 | 20020400523G | 2002-06-06 08:58:10 | 523 | PINE MOUNTAIN OIL AND GAS INC |  | 59407 | 1 | COBB | 826176 | 51 | 1148.3 | 58 | 0.05 | 55 | 0.32 | 17.6 | 0 | 0 | 0 | 17.6
2002-04-01 00:00:00 | 20020400523G | 2002-06-06 08:58:10 | 523 | PINE MOUNTAIN OIL AND GAS INC |  | 59407 | 1 | COBB | 833349 | 0 | 0 | 0 | 0.05 | 0 | 0.32 | 0 | 0 | 0 | 0 | 0
2002-04-01 00:00:00 | 20020400612G | 2002-06-06 08:58:10 | 612 | [NAME] | WILLIAM T | 64913 | 1 | COBB | 800134 | 33 | 1599 | 52 | 0.05 | 49 | 0.32 | 15.68 | 0 | 0 | 0 | 15.68
2002-04-01 00:00:00 | 20020400612G | 2002-06-06 08:58:10 | 612 | [NAME] | WILLIAM T | 64913 | 1 | COBB | 800176 | 303 | 1550 | 469 | 0.05 | 442 | 0.32 | 141.44 | 0 | 0 | 0 | 141.44
2002-04-01 00:00:00 | 20020400621G | 2002-06-06 08:58:10 | 621 | ELTON ENERGY |  | 66727 | 1 | EASTERN WV | 635377 | 121 | 1140.3 | 138 | 0.05 | 130 | 0.32 | 41.6 | 0 | 0 | 0 | 41.6