tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 57d37caa-2421-4a4a-b693-ecd9d8ab2c91
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Unnamed: 15 | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  |  |  | Annual Rate (in): |  |  |  | Annual Rate (in): |  |  |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 769882d1645716779-two-query-summary-deduplication-problem-2-24
Sheet: Sheet1

 |  | Statistics Summary
Item | Date | company name | project name | types of fee | Amount
1 | 2020-06-09 00:00:00 | SAU Technology Co., Ltd | NIL | current payment | 10000 |  | Choose a company name |  |  | QER Technology Co., Ltd
3 | 2020-06-24 00:00:00 | SAU Technology Co., Ltd | NIL | current payment | 10000 |  | select year |  |  | 2020
4 | 2020-06-24 00:00:00 | Construction Engineering Co., Ltd | Retrofit | labor payment | 300000
5 | 2020-09-25 00:00:00 | QER Technology Co., Ltd | NIL | current payment | 50000 |  |  |  |  | RESULTS
8 | 2020-09-30 00:00:00 | QER Technology Co., Ltd | NIL | current payment | 3000 |  |  |  |  | project name | types of fee | Amount
6 | 2020-10-11 00:00:00 | QER Technology Co., Ltd | NIL | current payment | 70000 |  |  |  |  |  | current payment | 0 |  |  | Hi Bo_Ry Guru , the attachment you provided can be correct and the result I want
2 | 2020-12-28 00:00:00 | QER Technology Co., Ltd | A construction | Project money | 9000 |  |  |  |  | A construction | Project money | 0
9 | 2021-01-21 00:00:00 | QV Technology Co., Ltd | B construction | labor payment | 30000
7 | 2021-05-09 00:00:00 | VOL Technology Co., Ltd | C construction | Project money | 70000 |  |  |  |  |  | current payment | 123000
 |  |  |  |  |  |  |  |  |  | A construction | Project money | 9000
 |  |  |  |  |  |  |  |  |  |  | current payment | 50000
 |  |  |  |  |  |  |  |  |  | NIL | current payment | 3000
 |  |  |  |  |  |  |  |  |  | NIL | current payment | 70000
 |  |  |  |  |  |  |  |  |  | A construction | Project money | 9000
Spreadsheet: 730254d1619615214-buying-and-selling-in-multiple-currencies-test-calcs
Sheet: Sheet1

 |  |  |  | GBP-EUR | 1.15 | 20 |  |  |  | EUR | GBP | USD
 |  |  |  | USD-EUR | 0.83 | 20 |  |  | EUR | 1 | 0.87 | 1.21
 |  |  |  |  |  | 20 |  |  | GBP
 |  |  |  | EUR-GBP | 0.87 | 20 |  |  | GBP | 1.15 | 1 | 1.39
 |  |  |  | USD-GBP | 0.72 | 20 |  |  | USD | 0.83 | 0.72 | 1
 |  |  |  |  |  | 20
 |  |  |  | EUR-USD | 1.21 | 20
 |  |  |  | GBP-USD | 1.39 | 20
# | [NAME] | QTY EACH | SUPPLIER | EUR | GBP | USD | USD | LINE COST
1 | Product 1 | 5 |  | 20
2 | Product 2 | 5 |  |  | 20
3 | Product 3 | 5 |  |  |  | 20
# | [NAME] | QTY EACH | SUPPLIER | EUR UNIT | GBP UNIT | USD UNIT | EUR | LINE COST
1 | Product 1 | 5 |  | 20
2 | Product 2 | 5 |  |  | 20
3 | Product 3 | 5 |  |  |  | 20
# | [NAME] | QTY EACH | SUPPLIER | EUR UNIT | GBP UNIT | USD UNIT | GBP | LINE COST
1 | Product 1 | 5 |  | 20
2 | Product 2 | 5 |  |  | 20
3 | Product 3 | 5 |  |  |  | 20
# | [NAME] | QTY EACH | SUPPLIER | EUR UNIT | GBP UNIT | USD UNIT | EUR | LINE COST
1 | Product 1 | 5 |  | 20
2 | Product 2 | 5 |  |  | 20
3 | Product 3 | 5 |  |  |  | 20
Spreadsheet: 771623d1646760503-conditional-formatting-compare-2-cells-on-diff-tabs-conditional-formatting_working-copy-etaf
Sheet: 2021

 | ACCOUNT | IT | [NAME] | ENG | [NAME] | TECH | [NAME]
 | Test Account 1 | 5 | 2 | 2 | 2 | 2 | 2
 | Test Account 2 | 1 | 7 | 7 | 7 | 7 | 7
 | Test Account 3 | 56 | 5 | 5 | 5 | 5 | 5
 | Test Account 4 | 6 | 2 | 2 | 2 | 2 | 2
 | Test Account 5 | 2 | 7 | 7 | 7 | 7 | 7
Spreadsheet: 287409c7-a07f-4783-add7-1d534afc371f
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
A2M | Test | A2M | [NAME], Serum | [NAME], S | Nephelometry | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | 100-280 mg/dL | Monday through Saturday; 3 p.m. | Same day/1 day | 2 days | 1 | 83883 |  |  |  |  | Rochester
A2M | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
A2M | Result | A2M | [NAME], S | [NAME], S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 1835-8 | [NAME]:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 63328d1264233629-transferring-filtered-data-from-one-table-to-another-excel-objective-statement-and-examples-1-
Sheet: Sheet1

Objective:  By selecting Group in Output Table, bring over the desired services that are billable in that PG
 | with each in its own row.  No error codes appearing on empty rows.
 | Service & Rate Table |  |  |  |  |  |  |  |  |  |  | Dropdown for Groups
 |  |  |  |  |  |  |  |  |  |  |  | PG1
 |  | Service is billable in: |  |  |  |  |  |  |  |  |  | PG2
 | Name | PG1 | PG2 | PG3 | PG4 | Rate | Unit |  |  |  |  | PG3
 | Service 1 | 1 | 1 |  |  | 10 | 15 |  |  |  |  | PG4
 | Service 2 |  | 1 | 1 |  | 20 | 15
 | Service 3 | 1 |  | 1 | 1 | 30 | 20
 | Output Table |  |  |  |  |  | Example of Output Table with Group = [NAME] signifies input data from Service & Rate Table
 | Select Group=> | PG1 |  |  |  |  | Select Group=> | PG2
 | Service Name | Rate | Unit | Total |  |  | Service Name | Rate | Unit | Total
 | Service 1 | 10 | 15 | 150 |  |  | Service 2 | 20 | 15 | 300
 | Service 3 | 30 | 20 | 600 |  |  | Service 3 | 30 | 20 | 600
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | 750 |  |  |  |  |  | 900
Spreadsheet: 854537d1704376464-shift-work-sick-leave-and-hours-worked-calculator-sample-sheet-5-
Sheet: Inputs

Types of Shifts | Hours calculated
OT | 12 |  | Overtime shift
RDO | 0 |  | RDO
Nightshift | 12 |  | Nightshift
Day Shift | 12 |  | Dayshift
Leave | 0 |  | Leave
Training day 8 Hours | 8 |  | Training day 8 hours
Sick | 0 |  | Sick
WC | 12 |  | WC
Overtime shift
RDO
Nightshift
Dayshift
Leave
Training day 8 hours
Sick
WC
WC =
Spreadsheet: 2ac6553f-43f5-46cf-bcba-3649982e10d7
Sheet: EBITDA

 | CAPELLA EDUCATION COMPANY
 | NON-GAAP EBITDA
 | (In thousands)
 | The following table provides a reconciliation of net income to EBITDA for the periods noted below:
 |  | December 31, |  | December 31, |  | December 31, |  | December 31, |  | December 31, |  | December 31, |  | December 31,
 |  | 2005 |  | 2006 |  | 2007 |  | 2008 |  | 2009 |  | 2010 |  | 2011
 | Net income attributable to Capella Education Company | 10250 |  | 13411 |  | 22784 |  | 28788 |  | 42669 |  | 61270 |  | 52115
 | Other Income (net) | -2306 |  | -4472 |  | -4903 |  | -4061 |  | -2384 |  | -2038 |  | -1811
 | Income Tax Expense | 6929 |  | 8904 |  | 12069 |  | 15375 |  | 23637 |  | 35860 |  | 30370
 | Depreciation and Amortization | 6474 |  | 8195 |  | 9772 |  | 12246 |  | 14533 |  | 18512 |  | 24165
 | EBITDA | 21347 |  | 26038 |  | 39722 |  | 52348 |  | 78455 |  | 113604
Spreadsheet: 104868d1302291440-trendline-equation-error-wrong-y-for-given-x-water-temp-correction-factor
Sheet: Sheet1

Incom H2O Temp |  | TCF |  |  |  |  |  |  | Flow Diff @ Various Temp Diff
Deg C | [NAME] | Lab Data | Calc Trend line |  | Correctio |  | % Diff per 1 deg C increment |  | Orig Feed Temp | Final Feed Temp | Orig (Meas'd) Flow w/o HX, GPM | Crrctd Orig Flow @ 77 F | Crrctd Final Flow @ 77 F | Flow w/HX, GPM
0 |  |  |  |  |  |  |  |  | 35 | 80 | 60
0.5
1
1.5
2
2.5
3
3.5
4
4.5
5
5.5
6
6.5
7
7.5
8
8.5
9
9.5
10 |  | 1.711 |  | 1.711
10.5 |  | 1.679 |  | 1.679
11 |  | 1.642 |  | 1.642
11.5 |  | 1.618 |  | 1.618
12 |  | 1.588 |  | 1.588
12.5 |  | 1.558 |  | 1.558
13 |  | 1.53 |  | 1.53
13.5 |  | 1.502 |  | 1.502
14 |  | 1.475 |  | 1.475
14.5 |  | 1.448 |  | 1.448
15 |  | 1.422 |  | 1.422
15.5 |  | 1.396 |  | 1.396
16 |  | 1.371 |  | 1.371
16.5 |  | 1.347 |  | 1.347
17 |  | 1.323 |  | 1.323
17.5 |  | 1.299 |  | 1.299
18 |  | 1.276 |  | 1.276
18.5 |  | 1.254 |  | 1.254
19 |  | 1.232 |  | 1.232
19.5 |  | 1.21 |  | 1.21 |  |  |  |  |  |  | Corrected Flow Rate = (Measured Flow Rate) * (TCF @ Feed Water Temp)
20 |  | 1.189 |  | 1.189 |  |  |  |  |  | same as: | (Flow @ Baseline Temp = 77F) = (Measured Flow @ Given Feed Temp) * (TCF @ Given Feed Temp)
20.5 |  | 1.168 |  | 1.168 |  |  |  |  |  |  | Flow @ Given Feed Temp = (Flow @ Baseline Temp = 77F) / (TCF @ Given Feed Temp)
21 |  | 1.148 |  | 1.148 |  |  |  |  |  |  | Maximum operating pressure 300 PSIG (21 bar)
21.5 |  | 1.128 |  | 1.128 |  |  |  |  |  |  | Maximum operating temperature 45C or 113F
22 |  | 1.109 |  | 1.109
22.5 |  | 1.09 |  | 1.09
23 |  | 1.071 |  | 1.071
23.5 |  | 1.053 |  | 1.053
24 |  | 1.035 |  | 1.035
24.5 |  | 1.017 |  | 1.017
25 |  | 1 |  | 1
25.5 |  | 0.985 |  | 0.985
26 |  | 0.971 |  | 0.971
26.5 |  | 0.957 |  | 0.957
27 |  | 0.943 |  | 0.943
27.5 |  | 0.929 |  | 0.929
28 |  | 0.915 |  | 0.915
28.5 |  | 0.902 |  | 0.902
29 |  | 0.889 |  | 0.889
29.5 |  | 0.877 |  | 0.877
30 |  | 0.862866666666667 |  | 1.877
30.5 |  | 0.849638095238095 |  | 2.877
31 |  | 0.836409523809524 |  | 3.877
31.5 |  | 0.823180952380952 |  | 4.877
32 |  | 0.809952380952381 |  | 5.877
32.5 |  | 0.796723809523809 |  | 6.877
33 |  | 0.783495238095238 |  | 7.877
Spreadsheet: 864690d1711775198-win-average-formula-round-by-round
Sheet: Sheet2

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  |  | Round | Board | Opp. # | Rating | Opponent Name | Won | Lost | Player
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Score | Opponent
 | 1 | 6 | 29 | 923 | Lightley, [NAME] | 1 | 0 | 521 | 352 | 169 |  | Round | 1 |  | Score | Spread
 | 2 | 8 | 8 | 1554 | [NAME], Justin | 1 | 1 | 388 | 429 | -41 |  | Board | 2
 | 3 | 3 | 14 | 1397 | Rea, Gwen | 2 | 1 | 504 | 332 | 172 |  | Opp. # | 3
 | 4 | 9 | 23 | 1169 | Kanshamba, Fred | 2 | 2 | 347 | 422 | -75 |  | Rating | 4
 | 5 | 6 | 7 | 1606 | Mpundu, [NAME] | 2 | 3 | 430 | 513 | -83 |  | Opponent Name | 5
 | 6 | 9 | 30 | 857 | [NAME], Rita | 3 | 3 | 467 | 268 | 199 |  | Won | 6
 | 7 | 12 | 9 | 1546 | [NAME], [NAME] | 4 | 3 | 465 | 436 | 29 |  | Lost | 7
 | 8 | 8 | 17 | 1342 | Kipkemoi, [NAME] | 5 | 3 | 470 | 377 | 93 |  | Score Player | 8
 | 9 | 7 | 16 | 1355 | [NAME], [NAME] | 6 | 3 | 390 | 388 | 2 |  | Score Oppo | 9
 | 10 | 4 | 1 | 1905 | Oyende, [NAME] | 6 | 4 | 450 | 511 | -61 |  | Spread | 10
Spreadsheet: 173434d1344549286-highest-valued-cell-on-another-worksheet-forum
Sheet: Sheet1

Part # | Rev | $$
P11150220 | 1 | 1.2
P11150220 | 2 | 1.34
P11150220 | 3 | 1.48
P11150221 | 0 | 2.8
P11150221 | 1 | 2.94
P11150221 | 2 | 0.75
P11150275 | 6 | 12.04
P11150275 | 8 | 9
P11150275 | 9 | 15.19
P11150276 | 4 | 12.05
P11150276 | 5 | 0
P11150276 | 6 | 9.17
P11150276 | 7 | 15.09
P11150277 | 6 | 15.89
P11150278 | 7 | 7.62
P11150279 | 4 | 3.03
P11150281 | 1 | 5.8
P11150281 | 2 | 0
P11150281 | 3 | 8.45
Spreadsheet: 188706d1350969131-vlookup-from-four-cells-to-compare-vlookup-soltuion
Sheet: Sheet1

 |  |  |  |  | With N/A | To Ignore
A | B | C | D | Helper | Error | Error |  |  | Helper | E | F | G | H |  | I |  |  |  | Allocate
3 | 2 | 1 | 4 |  |  |  |  |  |  | 2 | 3 | 2 | 3 |  | 1 |  |  |  | VLOOKUP(a3:d3),($I$3:$l$14),
2 | 3 | 1 | 4 |  |  |  |  |  |  | 2 | 3 | 3 | 2 |  | 2
2 | 3 | 2 | 3 |  |  |  |  |  |  | 3 | 2 | 2 | 3 |  | 3 |  |  |  | 1
2 | 3 | 3 | 2 |  |  |  |  |  |  | 3 | 2 | 3 | 2 |  | 4 |  |  |  | 2
1 | 4 | 4 | 1 |  |  |  |  |  |  | 1 | 4 | 2 | 3 |  | 5 |  |  |  | (blank)
4 | 1 | 4 | 1 |  |  |  |  |  |  | 1 | 4 | 3 | 2 |  | 6 |  |  |  | (blank)
2 | 3 | 4 | 1 |  |  |  |  |  |  | 4 | 1 | 2 | 3 |  | 7 |  |  |  | 11
2 | 3 | 3 | 2 |  |  |  |  |  |  | 4 | 1 | 3 | 2 |  | 8 |  |  |  | 2
2 | 3 | 1 | 4 |  |  |  |  |  |  | 2 | 3 | 1 | 4 |  | 9 |  |  |  | 10
2 | 3 | 1 | 4 |  |  |  |  |  |  | 3 | 2 | 1 | 4 |  | 10
2 | 3 | 3 | 2 |  |  |  |  |  |  | 2 | 3 | 4 | 1 |  | 11
2 | 3 | 1 | 4 |  |  |  |  |  |  | 3 | 2 | 4 | 1 |  | 12
1 | 4 | 3 | 2
4 | 1 | 2 | 3
3 | 2 | 4 | 1
4 | 1 | 2 | 3
3 | 2 | 1 | 4
3 | 2 | 1 | 4
1 | 4 | 3 | 2
4 | 1 | 3 | 2
4 | 1 | 1 | 4
1 | 4 | 3 | 2
3 | 2 | 3 | 2
4 | 1 | 4 | 1
4 | 1 | 2 | 3
2 | 3 | 4 | 1
1 | 4 | 1 | 4
3 | 2 | 4 | 1
Spreadsheet: 863483d1710950196-can-we-use-index-match-to-return-sumrange-for-sumif-index
Sheet: Sheet1

 |  | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00
Toy | #01-1F | 1522 | 131 | 1006 | 1514 | 712 | 1184 | 1280 | 299 | 1278 | 1288 | 1620 | 1785
Toy | #01-1G | 1055 | 876 | 168 | 1081 | 1762 | 1281 | 545 | 1388 | 1764 | 1363 | 1446 | 357
Food | #02-009 | 1620 | 908 | 569 | 340 | 1254 | 279 | 1866 | 1172 | 590 | 261 | 1841 | 267
Furniture | #03-0J | 1945 | 319 | 1902 | 1410 | 1939 | 1555 | 891 | 898 | 332 | 106 | 133 | 558
Furniture | #03-0Z2 | 792 | 246 | 1411 | 1771 | 1846 | 274 | 403 | 241 | 592 | 1910 | 739 | 868
Toy | #01-1H | 1381 | 1843 | 854 | 1229 | 1308 | 717 | 1808 | 1537 | 1117 | 1857 | 1857 | 420
 |  | Toy
 |  | 2023-01-31 00:00:00
 |  | * I know I can use Sumproduct, but is there a way to ([NAME] and index/match ) where the index actually refer to the specific column base on C11 (Sum Range)?
Spreadsheet: 08785b56-7c8a-4843-8e0a-cbdda204a028
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
 | 6457.0 International Trade Price Indexes, Australia
 | Table 16. Import Price Index: BEC Category, Index Numbers
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
Index Numbers ;  Food and beverages ; |  |  | Original | A2298159L | 1983-06-01 00:00:00 | 2011-12-01 00:00:00 | 115 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Industrial supplies, n.e.s. ; |  |  | Original | A2298162A | 1983-06-01 00:00:00 | 2011-12-01 00:00:00 | 115 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  [NAME] and lubricants ; |  |  | Original | [NAME] | 1983-06-01 00:00:00 | 2011-12-01 00:00:00 | 115 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Capital goods, and parts and accessories thereof ; |  |  | Original | A2298168R | 1983-06-01 00:00:00 | 2011-12-01 00:00:00 | 115 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Transport equipment, and parts and accessories thereof ; |  |  | Original | A2298171C | 1983-06-01 00:00:00 | 2011-12-01 00:00:00 | 115 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Consumer goods n.e.s. ; |  |  | Original | [NAME] | 1983-06-01 00:00:00 | 2011-12-01 00:00:00 | 115 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 6c689746-45df-4c6c-956b-f3f14c64d816
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42219444 | 2014-07-08 22:19:33 | AXIS | 1 | 6 | 1 | 23966 | Johnnyboyb | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
42219616 | 2014-07-08 22:37:52 | ALLIES | 1 | 6 | 5 | 23966 | Johnnyboyb | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
42246011 | 2014-07-10 21:28:48 | AXIS | 1 | 5 | 2 | 799634 | lucky91 | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
42246314 | 2014-07-10 22:03:17 | ALLIES | 1 | 5 | 4 | 799634 | lucky91 | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
Spreadsheet: 67598d1268169941-advanced-filtering-thread-post
Sheet: Master

 | U | # | Yr | Unit | Equip. # or  Line # | Description | Init. Date | Status | Completion Date
 | 01 | 001 | 10 | AAAA | AA-AA1 | Item #AA-AA1 | 2010-02-18 00:00:00 | Open
 | 02 | 002 | 10 | BBBB | BB-BB1 | Item #[NAME] | 2010-02-17 00:00:00 | Complete | 2010-02-18 00:00:00
 | 03 | 003 | 10 | CCCC | CC-CC1 | Item #[NAME] | 2010-02-16 00:00:00 | Open
 | 04 | 004 | 10 | DDDD | DD-DD1 | Item #[NAME] | 2010-02-15 00:00:00 | Complete | 2010-02-18 00:00:00
Spreadsheet: louise_kitchen__23955__SepYTD Orig w notes sf
Sheet: Central Gas

Central Gas
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
Luce* |  | Gas |  | Central Gas |  | 9299391
Pollan |  | Gas |  | Central Gas |  | 1110296.91
Frinhart |  | Gas |  | Central Gas
Carrabine |  | Gas |  | Central Gas |  | 129074.6
[NAME] |  | Gas |  | Central Gas |  | 69232.21
Penman |  | Gas |  | Central Gas |  | 32100
Otto |  | Gas |  | Central Gas |  | 10775
[NAME] |  | Gas |  | Central Gas |  | 9125
[NAME] |  | Gas |  | Central Gas |  | 9125
Giron |  | Gas |  | Central Gas |  | 7866
Thurston |  | Gas |  | Central Gas |  | 140169
Total
*$8,229,391 of total is Ennovate and runs through the trading line of the DPR.
Spreadsheet: 234770d1368188057-using-a-drop-down-to-pull-data-from-another-sheet-drop-down-for-sheet-name
Sheet: Summary

[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Month | RepairCenterRollUpName | Cookies sent to store | Cookies not sold | percent of cookies not sold
 | Month 1
 | Month 2
 | Month 3
 | Month 4
 | Month 5
 | Month 6
Spreadsheet: 93545d1293118005-print-a-sheet-in-one-page-test
Sheet: Fit to One Page

 | Timing | Process ID | Process Name |  |  |  |  |  |  |  | Period Type |  | Process Owner |  | Author | Company
 |  | Process ID | For data |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME] | [NAME]
 |  | Country |  |  | Test |  |  |  | Do some |  | ID. | System | Description (Gen. [NAME], Input, Output) |  |  | Another company
 |  | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | JDOE | Windows | Some text
 |  |  |  |  |  |  |  |  |  |  | File Name |  |  | Last Change | Version | Status | Page
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 751501d1634144439-automatically-fill-a-list-into-a-printable-document-random-drug-test-generator
Sheet: Alcohol

 | Savannah Technical College CDL Random Alcohol Test Generator
Index | Student Names
 | [NAME]
 | [NAME] |  | Random Selected for Semester
 | [NAME] |  | 1
 | [NAME] |  | 2 |  |  |  | Enter Student names in B3:B102
 | [NAME] |  | 3 |  |  |  | If an Student leaves, clear their name
 | [NAME] |  | 4 |  |  |  | If a new student is enrolled, put them in any blank cell in B3:B102
 | [NAME] |  | 5 |  |  |  | Do not change the formulas in column A or column F
 | [NAME]
 | [NAME] |  |  |  |  |  | Click the "[NAME]" and click "Calculate Now" 6 times to get the random list.
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Regina Seaborough
 | [NAME]
 | [NAME]
 | Ransen Daily
 | [NAME]
 | [NAME]
 | Desiree Green
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Elijah Hires
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 851721d1701879000-need-help-converting-a-google-sheets-formula-to-excel-scheduling-test1
Sheet: GS

GS | 37.63 | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | Light Smoothing | 2024-01-15 00:00:00 |  |  | For production quote- [NAME]
Spreadsheet: 4547bdc9-d899-42f0-b282-9085d641ac92
Sheet: Sheet7

Army | 6456
Air Force | 7554 |  |  | Agriculture | 17826
Navy | 1949 |  |  | Air Force | 73055
State | 1652 |  |  | Army | 170850
Transportation | 2857 |  |  | Homeland Security | 19948
Interior | 722 |  |  | Interior | 75097
Agriculture | 793 |  |  | Navy | 64477
 | 1676 |  |  | Transportation | 42829
 |  |  |  | Other | 21786
Spreadsheet: 234417d1368097122-combined-data-from-2-sheet-to-1-sheet-test-file
Sheet: 1

Sr. no | Date | Manifest No. | Name of Customer | Vehicle no. | Name fo Dirver | Out time At ZIPL | In time At ZIPL
1 | 2012-04-01 00:00:00 | 9969 | D | GJ-1AT-  3951 | Lalitbhai | 08:00:00 | 08:35:00
2 | 2012-04-05 00:00:00 | 9970 | B | GJ-8U-1720 | [NAME] | 08:00:00 | 09:00:00
3 | 2012-04-15 00:00:00 | 9971 | D | GJ-1AT-  3951 | Lalitbhai | 09:05:00 | 09:40:00
4 | 2012-05-05 00:00:00 | 9972 | B | GJ-8U-1720 | [NAME] | 09:30:00 | 10:30:00
5 | 2012-05-15 00:00:00 | 9973 | C | GJ-1AT-  3951 | Lalitbhai | 10:05:00 | 10:45:00
6 | 2012-05-30 00:00:00 | 9974 | B | GJ-8U-1720 | [NAME] | 11:05:00 | 12:00:00
7 | 2012-06-01 00:00:00 | 9975 | A | GJ-1AT-  3951 | Lalitbhai | 13:15:00 | 13:55:00
8 | 2012-06-30 00:00:00 | 9976 | B | GJ-8U-1720 | [NAME] | 14:05:00 | 15:15:00
9 | 2012-07-01 00:00:00 | 9977 | D | GJ-1AT-  3951 | Lalitbhai | 14:15:00 | 14:45:00
10 | 2012-07-15 00:00:00 | 9978 | E | GJ-1AT-  3951 | Lalitbhai | 16:15:00 | 18:20:00
11 | 2012-07-30 00:00:00 | 9979 | B | GJ-8U-1720 | [NAME] | 16:50:00 | 18:10:00
12 | 2013-02-01 00:00:00 | 9980 | D | GJ-8U-1720 | [NAME] | 18:40:00 | 19:10:00
13 | 2013-02-28 00:00:00 | 9981 | D | GJ-1AT-  3951 | Lalitbhai | 08:10:00 | 08:35:00
14 | 2013-03-01 00:00:00 | 9982 | B | GJ-8U-1720 | [NAME] | 08:30:00 | 09:20:00
15 | 2013-03-13 00:00:00 | 9983 | D | GJ-1AT-  3951 | Lalitbhai | 09:00:00 | 09:35:00
16 | 2013-03-30 00:00:00 | 9984 | B | GJ-8U-1720 | [NAME] | 10:00:00 | 11:00:00