tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__19136__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-04-18 00:00:00 |  | 226.96 | 736 | 96.96 | 2528
 | 2001-04-17 00:00:00 |  | 226.96 | 736 | 96.96 | 2528 | 154.56 | 1929 | 95.55 | 1346
 | 2001-04-16 00:00:00 |  | 221.9 | 336 | 121.2 | 768 | 133.03 | 1144 | 80.72 | 1323
 | 2001-04-15 00:00:00 |  | 225 | 800 | 80 | 1200 | 60.05 | 2368 | 44.12 | 1494
 | 2001-04-14 00:00:00 |  | 153.98 | 2736 | 79.16 | 1808 | 101.54 | 2179 | 71.44 | 1068
 | 2001-04-13 00:00:00 |  | 153.98 | 2736 | 79.16 | 1808 | 118.59 | 2350 | 92.08 | 1386
 | 2001-04-12 00:00:00 |  | 163.9 | 4464 | 96.03 | 2832 | 121.22 | 2500 | 98.14 | 1742
 | 2001-04-11 00:00:00 |  | 186.25 | 640 | 102.5 | 400 | 146.66 | 1921 | 101.73 | 1672
 | 2001-04-10 00:00:00 |  | 189.32 | 1184 | 98.94 | 1440 | 146.67 | 2390 | 93.48 | 1552
 | 2001-04-09 00:00:00 |  | 126.46 | 2896 | 105.72 | 1264 | 122.88 | 1015 | 86.46 | 925
 | 2001-04-08 00:00:00 |  | 130 | 0 | 98 | 0 | 97.91 | 2833 | 87.85 | 1659
 | 2001-04-07 00:00:00 |  | 183.6 | 2576 | 92.82 | 1704 | 114.42 | 1980 | 114.75 | 800
 | 2001-04-06 00:00:00 |  | 183.6 | 2576 | 92.93 | 1680 | 147.71 | 1463 | 91.2 | 1429
 | 2001-04-05 00:00:00 |  | 200.55 | 5984 | 102.44 | 2408 | 127.14 | 2549 | 98.45 | 1862
 | 2001-04-04 00:00:00 |  | 199.23 | 4384 | 103.75 | 2232 | 148.64 | 1692 | 81.66 | 1580
 | 2001-04-03 00:00:00 |  | 188.58 | 4064 | 116.57 | 1632 | 117.12 | 1130 | 85.69 | 262
 | 2001-04-02 00:00:00 |  | 238.59 | 1024 | 150.88 | 912 | 137.01 | 2361 | 111.15 | 1000
 | 2001-04-01 00:00:00 |  | 180 | 800 | 107 | 600 | 148.11 | 1110 | 121.38 | 1200
 | 2001-03-31 00:00:00 |  | 154.62 | 624 | 95.02 | 1832 | 208.73 | 2005 | 132.05 | 925
 | 2001-03-30 00:00:00 |  | 154.62 | 624 | 94.91 | 1832 | 157.25 | 2240 | 118.11 | 1415
 | 2001-03-29 00:00:00 |  | 150.35 | 1824 | 96.1 | 1672 | 134.29 | 2045 | 98.07 | 1330
 | 2001-03-28 00:00:00 |  | 133.2 | 3328 | 74.97 | 1544 | 115.44 | 1399 | 82.09 | 1685
 | 2001-03-27 00:00:00 |  | 105.94 | 1104 | 69.87 | 1232 | 119.31 | 1428 | 71.55 | 1817
 | 2001-03-26 00:00:00 |  | 278.99 | 1104 | 158.37 | 712 | 121.58 | 1216 | 59.09 | 901
 | 2001-03-25 00:00:00 |  | 195 | 0 | 150 | 0 | 83.27 | 1706 | 57.7 | 1655
 | 2001-03-24 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 122.71 | 3765 | 146.16 | 2205
 | 2001-03-23 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 212.95 | 3035 | 164.51 | 1676
 | 2001-03-22 00:00:00 |  | 282.93 | 464 | 175.42 | 2032 | 299.77 | 1910 | 211.67 | 1390
 | 2001-03-21 00:00:00 |  | 353.67 | 1024 | 220.45 | 880 | 351.62 | 4153 | 259.99 | 1589
 | 2001-03-20 00:00:00 |  | 323.59 | 624 | 221.88 | 1600 | 281.92 | 1957 | 245.43 | 1616
 | 2001-03-19 00:00:00 |  | 291.72 | 1024 | 197.04 | 1272 | 197.2 | 635 | 225 | 20
Spreadsheet: 27093d1219940697-lookup-index-and-or-match-excel-forum-macro-example
Sheet: Times

Customer No.-BOM No. |  | Cost Center Code | Line No. | Expected Time | Cost Center Type | Begin Quantity | End Quantity
421009-1 | PHMI01-0001 | BS | 0 | 2.71 | Cutting | 1 | 32
421009-2 | PHMI01-0002 | BS | 0 | 3.63 | Cutting | 1 | 9
421009-3 | PHMI01-0003 | CS | 0 | 0.21 | Cutting | 1 | 200
421009-3 | PHMI01-0003 | RS | 0 | 0.4 | Cutting | 1 | 200
421009-4 | PHMI01-0004 | CS | 0 | 0.21 | Cutting | 1 | 204
421009-4 | PHMI01-0004 | RS | 0 | 0.4 | Cutting | 1 | 204
421009-5 | PHMI01-0005 | CS | 0 | 0.3 | Cutting | 1 | 200
421009-6 | PHMI01-0006 | AS | 0 | 2.5 | Assembly | 1 | 480
421009-6 | PHMI01-0006 | BS | 0 | 0.16 | Cutting | 1 | 480
421009-7 | PHMI01-0007 | PS | 0 | 1.3 | Cutting | 1 | 6
421009-8 | PHMI01-0008 | PS | 0 | 1.2 | Cutting | 1 | 6
421009-9 | PHMI01-0009 | PS | 0 | 1.5 | Cutting | 1 | 4
421009-10 | PHMI01-0010 | RS | 0 | 1.16 | Cutting | 1 | 80
421009-11 | PHMI01-0011 | AS | 0 | 40.3 | Assembly | 1 | 5
421009-11 | PHMI01-0011 | CS | 0 | 25 | Cutting | 1 | 5
421009-12 | PHMI01-0012 | AS | 0 | 26.33 | Assembly | 1 | 5
421009-12 | PHMI01-0012 | CS | 0 | 25.66 | Cutting | 1 | 5
421009-13 | PHMI01-0013 | AS | 0 | 50 | Assembly | 1 | 5
421009-13 | PHMI01-0013 | CS | 0 | 20 | Cutting | 1 | 5
421009-14 | PHMI01-0014 | AS | 0 | 44 | Assembly | 1 | 4
421009-14 | PHMI01-0014 | CS | 0 | 20 | Cutting | 1 | 4
421009-15 | PHMI01-0015 | AS | 0 | 80 | Assembly | 1 | 1
421009-15 | PHMI01-0015 | CS | 0 | 40 | Cutting | 1 | 1
421009-16 | PHMI01-0016 | AS | 0 | 85 | Assembly | 1 | 1
421009-16 | PHMI01-0016 | CS | 0 | 40 | Cutting | 1 | 1
421009-17 | PHMI01-0017 | AS | 0 | 35 | Assembly | 1 | 1
421009-17 | PHMI01-0017 | CS | 0 | 25 | Cutting | 1 | 1
421009-18 | PHMI01-0018 | AS | 0 | 17.5 | Assembly | 1 | 10
421009-18 | PHMI01-0018 | CS | 0 | 15 | Cutting | 1 | 10
421009-19 | PHMI01-0019 | AS | 0 | 40 | Assembly | 1 | 8
421009-19 | PHMI01-0019 | BS | 10 | 4 | Cutting | 1 | 8
421009-19 | PHMI01-0019 | CS | 0 | 15 | Cutting | 1 | 8
421009-20 | PHMI01-0020 | AS | 0 | 22 | Assembly | 1 | 1
421009-20 | PHMI01-0020 | CS | 0 | 20 | Cutting | 1 | 1
Spreadsheet: joe_parks__14712__POSTION05_02
Sheet: JAN3_nym

 | SELL |  |  |  | BUY
BEGINNING | 50 | 4.297 |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  | 3 DAY ROLL
 |  |  |  |  |  |  |  |  |  |  | 15.5 | 3.445
 |  |  |  |  |  |  |  |  |  |  | 22.5 | 3.385
 |  |  |  |  |  |  |  |  |  |  | 46.5 | 3.35
 |  |  | ROLL VALUE
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 765812d1643620577-weeks-conditional-formatting-example-wk
Sheet: Foglio1

2022
[NAME] | fine | START | N. of week | END |  | 50 | 51 | 52 | 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
2021-12-13 00:00:00 |  |  | 5
2021-12-13 00:00:00 |  |  | 4
2021-12-13 00:00:00 |  |  | 5
2021-12-13 00:00:00 |  |  | 6
2021-12-13 00:00:00 |  |  | 7
2022-01-13 00:00:00 |  |  | 8
2022-12-13 00:00:00 |  |  | 8
Spreadsheet: 29982d1225272425-countif-and-sumif-formula-question-excel-forum-newbie-excel-problem
Sheet: Sheet1

Criteria | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Total | A | B | C
Score | 3 | 2 | - | 4 | 1 | - | 1 | 3 | 2 | 2 | 18
Spreadsheet: e9270d38-868d-4512-9620-f1d0cfceb052
Sheet: Sheet1

2002 official [NAME] | Unnamed: 1
State of North Dakota Results
Precincts Reporting: 663/663 - Total Ballots Cast: 128519
Downloaded at 8/1/2014 8:53:06 AM
 | [NAME] ([NAME]) Neumann - NON
Justice of the Supreme Court - NON | 97859
 | [NAME]
Public Service Commissioner - DEM | 46446
 | [NAME]
Public Service Commissioner - REP | 54859
 | [NAME]
Representative in Congress - DEM | 52403
 | [NAME]
Representative in Congress - REP | 56570
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: d5cecd03-58c5-4248-b4b5-1ddbb6b5fff0
Sheet: Pg9

Permit No.: |  |  | WQ0023693 |  |  | Facility Name: |  | West Brunswick Regional WWTF |  |  |  |  |  | County: | Brunswick |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 11B |  | Field Name: |  | 12A |  | Field Name: |  | 13A |  | Field Name: |  | 13B
 |  |  |  |  |  | Area (acres): |  | 1.25 |  | Area (acres): |  | 4.08 |  | Area (acres): |  | 3.41 |  | Area (acres): |  | 2.4
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.2 |  | [NAME] (in): |  | 0.2 |  | [NAME] (in): |  | 0.2 |  | [NAME] (in): |  | 0.2
 |  |  |  |  |  | Annual Rate (in): |  | 41.6 |  | Annual Rate (in): |  | 83.2 |  | Annual Rate (in): |  | 83.2 |  | Annual Rate (in): |  | 41.6
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: 44004-list-table-inc-page-number-variable-multiple-20criterion-20example-1-
Sheet: Sheet2

Source: | S |  |  |  |  | Source: | FirstName: | Page | Lastname: | Note:
FirstName: | FN |  |  |  |  | S | FN | 1 | LN | Text
Lastname: | LN |  |  |  |  | S1 | FN | 1 | LN | Text
Note: | Text |  |  |  |  | S1 | FN1 | 1 | LN | Text
Source: | S1 |  |  |  |  | S1 | FN1 | 1 | LN1 | Text
Firstname: | FN1 |  |  |  |  | S1 | FN1 | 1 | LN1 | Text
Lastname: | LN1 |  |  |  |  | S2 | FN1 | 1 | LN1 | Text
Page | 1 |  |  |  |  | S2 | FN2 | 1 | LN1 | Text
Note: | Text |  |  |  |  | S2 | FN2 | 1 | LN2 | Text
Source: | S2 |  |  |  |  | S2 | FN2 | 2 | LN2 | Text
Firstname: | FN2 |  |  |  |  | S2 | FN2 | 2 | LN2 | Text
Page | 2 |  |  |  |  | S3 | FN2 | 2 | LN2 | Text
Lastname: | LN2 |  |  |  |  | S3 | FN3 | 2 | LN2 | Text
Note: | Text |  |  |  |  | S3 | FN3 | #N/A | LN2 | Text
Source: | S3 |  |  |  |  | S3 | FN3 | #N/A | LN3 | Text
Firstname: | FN3 |  |  |  |  | S3 | FN3 | #N/A | LN3 | Text
Lastname: | LN3 |  |  |  |  | #N/A | FN3 | #N/A | LN3 | Text
Note: | Text |  |  |  |  | #N/A | #N/A | #N/A | LN3 | Text
 |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | Text
My goal is to make it into a table that would say: |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
S____1____FN____LN____Text
S1___1____FN1___LN1___Text
S1___1____FN2___LN2___Text
S3___2____FN3___LN3___Text
Spreadsheet: 33051d1229344461-calculating-percentage-based-on-dynamic-cells-sample
Sheet: Sheet1

Sample 1
Reason | Score
Type 1 | 10
Type 2 | -5
NA | NA
Percentage | 0.5 | I want the formula to calculate just [NAME] and A4 since A5 is not applicable )
Sample 2
Reason | Score
Type 1 | 10
Type 2 | -5
Type 1 | -5
Percentage | 0 | 10 - 10 = 0 percentage
This is how I need the counting/ calulation to be done ; since the data would be alligned in this manner
Reason | Score | Reason | Score | Reason | Score | Percentage
Type 1 | 10 | Type2 | -5 | NA | NA | 0.5
Spreadsheet: 126259d1319593149-pretty-simple-time-problem-book1
Sheet: Sheet1

Employee code | name | start time | end time | Roundstart | RoundEnd | Client | client name | worked |  |  | On roster | start | end | DISCREPANCY IN START | DISCREPANCY IN END | Correct
 | FAKE R | 14:20:00 |  | 14:15:00 |  | 5003 | fake | 00:00:00 |  |  |  | 14:30:00 | 21:30:00
 | FAKER R |  | 07:12:00 |  | 07:15:00 | 5003 | fake | 00:00:00 |  |  |  | 00:00:00 | 07:00:00
 | FAKEY R | 08:40:00 | 14:34:00 | 08:45:00 | 14:30:00 | 5003 | fake | 05:45:00 |  |  |  | 08:45:00 | 14:30:00
 | FAKEST R | 06:51:00 | 11:35:00 | 06:45:00 | 11:30:00 | 5003 | fake | 04:45:00 |  |  |  | 06:45:00 | 11:30:00
 | FAKING R | 17:30:00 | 20:00:00 | 17:30:00 | 20:00:00 | 5003 | fake | 02:30:00 |  |  |  | 17:30:00 | 20:00:00
Spreadsheet: mary_fischer__25612__32G
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 2000 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901 |  | -3160427 |  |  |  |  |  |  |  |  |  | 3160427
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915 |  | -1000 |  |  |  |  |  |  |  |  |  | -18518671
RE - Beg Bal |  | 0920 |  | -18518671 |  | -1361502 |  |  |  |  |  |  |  |  |  | Rcls entries
RE - Net Income |  | 0930 |  | -1361502 |  | 1361502 |  | -269913
RE - Net Income (Fair Value Adjustment) |  | 0931
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO #
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 32ecdf87-d9b7-4a15-86c3-769f45b34ebc
Sheet: Sheet1

City Officials Statements | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
For Quarter Ending 6/30/2009
(As of 7/22/2009)
Name | Title | Personal Benefits Reported | City Benefits Reported
Adams, Sam | Mayor | 3598.5
[NAME], [NAME] | At-will staff for Mayor [NAME]
Birge, [NAME] | At-will staff for Mayor [NAME] |  | 200
Blackmer, [NAME] | City Auditor | 486.51
Callahan, Shannon | At-will staff for Commissioner Saltzman
[NAME], [NAME] | At-will staff for Mayor [NAME]
[NAME], Todd | At-will staff for Mayor [NAME]
Fish, [NAME] | Commissioner | 245.5 | 115555
Fritz, Amanda | Commissioner
Griffin-Valade | City Auditor
Hanson, [NAME] | Portland Planning Commission Member
Jimenez, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
Kovatch, [NAME] | At-will staff for Commissioner [NAME]
Leonard, [NAME] | Commissioner
Lord II, Reese | At-will staff for Mayor [NAME]
Marriott, [NAME] | Director of Bureau of Environmental Services
[NAME], [NAME] | At-will staff for Mayor [NAME]
Neal, Clay | At-will staff for Mayor [NAME]
[NAME], Skip | At-will staff for Mayor [NAME]
Ponder, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME] | 220 | 2082
Ruiz, [NAME] | At-will staff for Mayor [NAME]
Saltzman, [NAME] | Commissioner | 135
[NAME], [NAME] | Director of Bureau of Development Services
[NAME], [NAME] | Director of Bureau of Police | 95
Stringfield, Sierra | At-will staff for Mayor [NAME]
Uwagbae, Grace | At-will staff for Mayor [NAME]
Wark, [NAME] | Design Commission Member
Yocom, [NAME] | At-will staff for Mayor [NAME] | 39.9
Spreadsheet: 273323d1382672584-sum-adjacent-cell-to-a-reference-throughout-workbook-sample-orders
Sheet: WE 19th Jan

Date | Order # | Company | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
20.02.14 | 102498 | Inverell Bearing Centre | 2x A54 belts | 1x SPZ-8 groove pulley, 3" shaft, 12mm keyway, 560mm OD
 |  | Area: | Stock | Hasher
 |  | Req'd By: | Daryl | [NAME]
 |  | Code: | 1A | 1H
 |  | Item Cost: | 110 | 2310
 |  | Request No. | 102498 | 102502
20.02.14 | 104978 | Sapphire City Steel & Pipe | 40m - 12mm deformed bar | 2x sheets - 2400x1200x2mm gal
 |  | Area: | CAPITAL: Job #29 | BSF
 |  | Req'd By: | [NAME] | [NAME]
 |  | Code: | 1B | 1G
 |  | Item Cost: | 80000 | 560
 |  | Request No. | 104978 | 104598
20.02.14 | 106798 | Norgen | 2x air cyliners per sample
 |  | Area: | BSF
 |  | Req'd By: | [NAME]
 |  | Code: | 1C
 |  | Item Cost: | 20000
 |  | Request No. | 106798
Spreadsheet: 40345d1238641670-how-to-create-a-calendar-which-populates-by-list-of-dates-lookup-table
Sheet: Sheet1

 | Todays Date | 2009-04-02 00:00:00 |  | Expires within | 14 | Days |  |  |  | Lookup Table
1 | [NAME] | 2009-04-05 00:00:00 | 1 |  |  |  |  |  | 1 | [NAME] | 2009-04-05 00:00:00
2 | [NAME] 12345678 | 2009-04-07 00:00:00 | 1 |  |  |  |  |  | 2 | [NAME] 12345678 | 2009-04-07 00:00:00
3 | [NAME] 1234 | 2009-04-12 00:00:00 | 1 |  |  |  |  |  | 3 | [NAME] 1234 | 2009-04-12 00:00:00
4 | [NAME] 123 | 2009-04-14 00:00:00 | 1 |  |  |  |  |  | 4 | [NAME] 123 | 2009-04-14 00:00:00
5 | [NAME] 1 | 2009-04-20 00:00:00 | 0 |  |  |  |  |  | 5 | 0
5 | [NAME] | 2009-04-30 00:00:00 | 0 |  |  |  |  |  | 6
5 | [NAME] 12 | 2009-05-28 00:00:00 | 0 |  |  |  |  |  | 7
5 | [NAME] 1234567 | 2009-05-31 00:00:00 | 0 |  |  |  |  |  | 8
5 | [NAME] 12345678 | 2009-06-10 00:00:00 | 0 |  |  |  |  |  | 9
5 | [NAME] 12 | 2009-06-15 00:00:00 | 0 |  |  |  |  |  | 10
5 | [NAME] 123456 | 2009-06-30 00:00:00 | 0 |  |  |  |  |  | 11
5 | [NAME] 123456 | 2009-07-01 00:00:00 | 0 |  |  |  |  |  | 12
5 | [NAME] 1234567 | 2009-07-26 00:00:00 | 0 |  |  |  |  |  | 13
5 | [NAME] 1234 | 2009-09-26 00:00:00 | 0 |  |  |  |  |  | 14
5 | [NAME] 12345 | 2009-11-28 00:00:00 | 0 |  |  |  |  |  | 15
5 | [NAME] 12345 | 2009-12-16 00:00:00 | 0 |  |  |  |  |  | 16
5
Spreadsheet: 801813d1666382274-previous-quarter-previou-quarter
Sheet: Sheet1

Simulated date/today | 2023-03-10 00:00:00
 |  |  |  | Previous Quarter based on B1 date
 | enter company [NAME] | helper column (convert b column  to 2023) | formula | Desired result |  | Q1 END | Q2 END | [NAME] | [NAME]
 | 2022-02-28 00:00:00 |  |  | 2022-02-28 00:00:00
 | 2022-03-31 00:00:00 |  |  | 2022-12-31 00:00:00
 | 2022-04-30 00:00:00 |  |  | 2022-01-31 00:00:00
 | 2022-05-31 00:00:00 |  |  | 2022-02-28 00:00:00
 | 2022-06-30 00:00:00 |  |  | 2022-12-31 00:00:00
 | 2022-08-31 00:00:00 |  |  | 2022-02-28 00:00:00
 | 2022-09-30 00:00:00 |  |  | 2022-12-31 00:00:00
 | 2022-10-31 00:00:00 |  |  | 2022-01-31 00:00:00
 | 2022-12-31 00:00:00 |  |  | 2022-12-31 00:00:00
Spreadsheet: 0620635e-b1aa-449c-a703-d635df42f29a
Sheet: Data Notes

Sheet Name | Cell | Description
SF-6 Form Per Capita | N25 | FY2013 expenditure reported to funds 001, 494, 016, and 532 and functions 122X, 123X, 124X and object codes 11X, 12X, 21X, 24X, 131 and 261
SF-6 Form Per Capita | N27 | FY2013 expenditure reported to funds 001, 494, 016, and 532 and function 11XX and object codes 11X, 12X, 21X, 24X, 131 and 261
SF-6 Form Per Capita | N30 | FY2013 expenditure reported to funds 001, 494, 016, and 532 and function 1XXX and object codes 5XX
SF-6 Form Per Capita | N32 | FY2013 expenditure reported to funds 001, 494, 016, and 532 and function 1XXX and object codes 6XX and 7XX
SF-6 Form Per Capita | N33 | FY2013 EFM General Fund administrative expenditure total
SF-6 Form Per Capita | N34 | FY2013 EFM General Fund operations expenditure total
SF-6 Form Per Capita | N35 | FY2013 EFM General Fund staff support expenditure total
SF-6 Form Per Capita | N36 | FY2013 EFM General Fund pupil support expenditure total
SF-6 Form Per Capita | [NAME] | FY2013 EFM ADM of those student with a disability condition excluding Speech and lanaguage (05)
SF-6 Form Per Capita | O27-O36 | FY2013 EFM ADM total
SF-6 Form Specific Student | N34-N35 | District submitted FY2013 data
SF-6 Form Specific Student | N37 | FY2013 expenditure reported to funds 001, 494, 016, and 532 and function 11XX and object codes 11X, 12X, 21X, 24X, 131 and 261
SF-6 Form Specific Student | N40 | FY2013 expenditure reported to funds 001, 494, 016, and 532 and function 1XXX and object codes 5XX
SF-6 Form Specific Student | N42 | FY2013 expenditure reported to funds 001, 494, 016, and 532 and function 1XXX and object codes 6XX and 7XX
SF-6 Form Specific Student | N43 | FY2013 EFM General Fund administrative expenditure total
SF-6 Form Specific Student | N44 | FY2013 EFM General Fund operations expenditure total
SF-6 Form Specific Student | N45 | FY2013 EFM General Fund staff support expenditure total
SF-6 Form Specific Student | N46 | FY2013 EFM General Fund pupil support expenditure total
SF-6 Form Specific Student | N50-N55 | District submitted FY2013 data
SF-6 Form Specific Student | N58 | Sum of per pupil expenditures in Section II
SF-6 Form Specific Student | N59 | Sum of per pupil expenditures in Section III
SF-6 Form Specific Student | N60 | Sum of per pupil expenditures in Section IV
SF-6 Form Specific Student | N61 | Total per pupil expenditure from Sections II, III and IV
SF-6 Form Specific Student | O34-O35, O50-O55 | District submitted FY2013 FTE data for students referenced on the form. Districts need only to enter the FTE in cell O34
SF-6 Form Specific Student | O37-O46 | FY2013 EFM ADM total
Spreadsheet: 47284d1246308764-job-hour-summary-using-daily-pivot-totals-can-it-be-done-weekly-timesheet-summary-7-days-
Sheet: Monday

2009-01-12 00:00:00 | Monday
Job # | Employee | Total Hours
870 |  | 1.5
 | [NAME] | 1.5
1223-5567 |  | 32
 | [NAME] | 4
 | [NAME] | 6.5
 | [NAME] | 2.5
 | [NAME] | 2.5
 | [NAME] | 2.5
 | [NAME] | 3
 | [NAME] | 4.5
 | [NAME] | 3
 | [NAME] | 3.5
5553-6789 |  | 18
 | [NAME] | 1.5
 | [NAME] | 4
 | [NAME] | 2
 | [NAME] | 8
 | [NAME] | 2.5
shop |  | 17
 | [NAME] | 9
 | [NAME] | 8
yard |  | 9
 | Cecil Elliot | 9
out |  | 0
 | Chase Payne | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | Pascual Mateo | 0
shipping office |  | 10.5
 | [NAME] | 8.5
 | [NAME] | 2
6789-9433 |  | 1.5
 | [NAME] | 1.5
5678-2345 |  | 1.5
 | [NAME] | 1.5
shop/tool manitenance |  | 3
 | [NAME] | 3
4567-7543 |  | 6
 | [NAME] | 3.5
 | [NAME] | 2.5
4568-8467 |  | 3
 | [NAME] | 3
4567-8210 |  | 2.5
 | [NAME] | 2.5
4568-9832 |  | 2
 | [NAME] | 2
load trucks |  | 7.5
 | [NAME] | 4
 | [NAME] | 3.5
3450-6743 |  | 4.5
 | [NAME] | 2
 | [NAME] | 2.5
5678-3832 |  | 7
 | [NAME] | 3.5
 | [NAME] | 3.5
3456-9876 |  | 5.5
 | [NAME] | 2
 | [NAME] | 3.5
sales |  | 6.5
 | [NAME] | 6.5
design |  | 3
 | [NAME] | 3
5553-6790 |  | 8
 | [NAME] | 8
1223-5561 |  | 8
 | [NAME] | 8
5553-6785 |  | 4
 | [NAME] | 4
1223-5565 |  | 9.5
 | [NAME] | 4
 | [NAME] | 5.5
5553-6781 |  | 3
 | [NAME] | 3
7445-1435 |  | 5
 | [NAME] | 5
5386-8649 |  | 3
 | [NAME] | 3
Grand Total |  | 182
Spreadsheet: 218866d1362596329-search-in-sheet-1-and-return-to-sheet-2-using-lookup-find-and-match
Sheet: Blad1

2013-03-04 00:00:00 | 4/3- | 11/3- | 18/3- | 25/3-
Week | 10 | 11 | 12 | 13
Text A | SKM | SKM | SKM | SKM
Text 1 | EA | EA | EA,PAS
Text 2 |  | SAN,LO |  | PAS
Text 3 | SAN |  | SAN
Text 4 | MM | [NAME] | AB
Text 5 | [NAME] | MM | MLA21-22 | [NAME]
Text 6 | AB,LO | CF |  | AB,EA
Text 7 | CF7 e m |  | CF
Text 8 | WA | AB,HBA | WA
Text 9 | HBA | MP13-15 | MP18-20
Text 10 |  |  |  | HBA
Text 11 | EGU | RAS | RAS | JOS
Text 12 | AMY7-8 | JOS | AMY | SAN
 |  | In Sheet 2 cell B3, I want to be able to type in a search string ie "CF" and extract the information from Sheet 1 column A on the same row "CF" occurs for each column in Sheet 1.
 |  | This should be done for each column that "CF" occurs in Sheet 1. I have used LOOKUP like this:
 |  | [CODE]=LOOKUP($B$3,Sheet1!$B$3:$B$100,Sheet1!$A$3:$A$100)[/CODE]
 |  | but it returns faulty values.
 |  | Other characters are involved in the cells like "," and elevated text, perhaps that is the issue?
 |  | I have attached a sample file with an example in sheet 2.
 |  | Here is another EXAMPLE:
 |  | If I type in "AB" in Sheet 2 cell B3, it should return the values (using the attached sample)
 |  | Text 6 (from [sheet 1 A9])
 |  | Text 8 (from [sheet 1 A11])
 |  | Text 4 (from [sheet 1 A7])
 |  | Text 6 (from [sheet 1 A9])
 |  | All comments are welcome! Thank you for your help.
 |  | Excel 2003 PC
Spreadsheet: 808326d1670417539-looking-up-unique-value-check-if-one-criteria-is-fulfilled-and-then-check-for-more-values-file
Sheet: Sheet1

 | Unit | Activity | Activity date
 | 001 | Running | 202201
 | 001 | Fitness training | 202202
 | 002 | Swimming | 202203
 | 003 | Running | 202202
 | 001 | Swimming | 202201
 | 002 | Running | 202204
 | 004 | Fitness training | 202203