tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 219864d1362995248-multiple-condition-if-pass-or-fail
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Condition
S.No. | Name | Hindi | English | Maths | Science | Social Study | Result 1 | Result 2 | Hindi | English | Maths | Science | Social Study
1 | A | 23 | 34 | 33 | 23 | 11 |  | Fail | 0 | 1 | 1 | 0 | 0
2 | B | 24 | 45 | 33 | 43 | 22 |  | Fail | 0 | 1 | 1 | 1 | 0
3 | C | 32 | 66 | 33 | 25 | 22 |  | Fail | 0 | 1 | 1 | 0 | 0
4 | D | 45 | 78 | 44 | 76 | 33 |  | Pass | 1 | 1 | 1 | 1 | 1
5 | E | 65 | 98 | 55 | 34 | 34 |  | Pass | 1 | 1 | 1 | 1 | 1
6 | F | 45 | 90 | 66 | 12 | 54 |  | Fail | 1 | 1 | 1 | 0 | 1
7 | G | 34 | 9 | 76 | 98 | 87 |  | Fail | 1 | 0 | 0 | 1 | 1
8 | H | 21 | 12 | 54 | 99 | 65 |  | Fail | 0 | 0 | 0 | 1 | 1
9 | I | 78 | 35 | 23 | 667 | 43 |  | Pass | 1 | 1 | 1 | 1 | 1
10 | J | 90 | 46 | 12 | 56 | 45 |  | Pass | 1 | 1 | 1 | 1 | 1
Conditions 1. | To pass each subject should have minimum of 33 Marks.
Conditions 2. | If 1 or 2 subjects have below 33 marks then supplementary
Conditions 3. | If more than 2 subjects have below 33 marks then Fail
Spreadsheet: 829707d1684404408-help-making-marked-cell-stay-put-while-i-sort-list-taking-info-from-marked-cells-aoeiv-turnering-2023-aligw
Sheet: Blad1

n/a | Andy84 | Bomb | Carnate | Draken | Fredmond | Gandulf | MiniTuvan | Pumba | [NAME] | Tuvanjr89 |  | Spelare | Spelade matcher | Seger | Förlust | plus/minus
Andy84 | n/a |  |  |  |  |  |  |  |  |  |  | Andy84
Bomb | 2 | n/a |  | 2 |  |  |  |  |  |  |  | Bomb
Carnate |  |  | n/a |  |  |  |  |  |  |  |  | Carnate
Draken |  |  |  | n/a |  |  |  | 2 |  |  |  | Draken
Fredmond |  | 2 |  |  | n/a |  |  |  |  |  |  | Fredmond
Gandulf |  |  |  |  | 1 | n/a |  |  |  |  |  | Gandulf
MiniTuvan |  |  |  |  |  |  | n/a |  |  |  |  | MiniTuvan
Pumba | 2 |  |  |  |  |  |  | n/a |  |  |  | Pumba
[NAME] | 2 | 2 | 1 | 2 |  |  |  | 1 | n/a |  |  | [NAME]
Tuvanjr89 |  |  |  |  |  |  |  |  |  | n/a |  | Tuvanjr89
 |  | Kvartsfinal
 | 3:a |  |  | Triaden
 | 10:a
 |  |  |  |  |  | Semifinal |  |  | Guldmatch |  | Namn | Slutplacering
 |  |  | 1:a |  |  |  |  |  |  |  |  | 1
 | 4:a |  |  |  |  |  |  |  |  |  |  | 2
 | 9:a |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 5
 | 5:a |  |  |  | Lucky looser |  |  |  | Bronsmatch |  |  | 6
 | 8:a |  |  |  |  |  |  |  |  |  |  | 7
 |  |  | 2:a |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | 9
 | 6:a |  |  |  |  |  |  |  |  |  |  | 10
 | 7:a |  |  |  | Lucky loosers
 | 1:a |  | by-match
 | 2:a |  | by-match
Spreadsheet: 587805d1535303478-extract-the-text-and-numbers-basis-on-specific-numbers-included-sample-workbook_01
Sheet: Final Format

Expected Results
[NAME] to Extract the Category based on SAP Code, where zero appears two or less then two times | Extract the Category based on SAP Code, where zero appears two or less then two times | Basis on Income Categories, SAP Code and Month | Basis on Income Categories, SAP Code and Month | Basis on Income Categories, SAP Code and Month
CATEGORY | SAP CODE | Jan | Feb | Mar
INCOME | SAP CODE
SALES COST | SAP CODE
WAGES/SALARIES | SAP CODE
MNO | 610501 | -610159.63 | -647572.65 | -574483.47
PQR | 610504 |  | -936.82
Spreadsheet: 159128d1338506364-count-unique-values-that-meet-criteria-at-least-twice-example2
Sheet: Sheet1

Date: | Type | [NAME] | Product ID | Result
40667 | HJF-IT-4E | [NAME] | S7N0AO060 | FAIL
40668 | HJF-IT-4E | ST5ABU07 | ST5AB005 | FAIL
40669 | HJF-IT-4E | S7N4AEU0 | SU0AK00 | FAIL
40670 | HJF-IT-4E | S7N6AHU0 | SQ0AN0 | FAIL
40671 | HJF-IT-4E | [NAME] | SQAB003 | FAIL
5//2011 | TJY-IT-ANB | 8PZG0U0 | 8PZG003 | PASS
40673 | TJY-IT-34B | 40RHD0U0 | 40RHD005 | PASS |  |  |  | LOTS W/ ERROR | 3
40674 | HJF-IT-4E | S7N4AEU0 | S7M8AE0 | PASS |  |  |  | REVISED LOTS W/ ERR | 5
40675 | HJF-IT-4E | S7N6AHU0 | SSAM04 | PASS
40676 | HJF-IT-4E | ST5ABU07 | STAH037 | PASS
40677 | HJF-QU-5E | DINFAAU0 | DINFAA055 | FAIL
40678 | HJF-IT-4E | SQ0AHU0 | S7M8AQ0807 | FAIL
40679 | HJF-IT-4E | SQ0AHU0 | S7M8AQ0808 | FAIL
40680 | HJF-IT-4E | SQ0AHU0 | SQ0AH0407 | FAIL
40681 | HJF-IT-4E | S7M8ANU05 | S7LAM008 | FAIL
40664 | HJF-IT-4E | S7M8ANU05 | S7MAM085 | FAIL
40683 | HJF-IT-4E | SQ0AHU0 | S7NAE035 | FAIL
40684 | HJF-IT-4E | SQ0AHU0 | S7NAE037 | FAIL
40685 | HJF-IT-4E | [NAME] | STAK00 | FAIL
40686 | HJF-QU-04E | 7NUAEU05 | 7NU4AK070 | FAIL
40687 | HJF-QU-04E | 7NUAEU05 | 7NUXAO05 | FAIL
40688 | HJF-IT-4E | S7LAKU05 | SL4AH45 | PASS
40689 | HJF-QU-04E | DINFAAU0 | DINFAD004 | FAIL
40690 | HJF-QU-04E | DINFAAU0 | EHFEAF058 | FAIL
40691 | HJF-IT-4E | S7M8ANU05 | S7L5AI0 | PASS
40665 | HJF-IT-4E | S7LAKU05 | S7LAP00 | PASS
40693 | HJF-IT-4E | [NAME] | S7M6AQ0807 | PASS
40694 | HJF-IT-4E | S7M8ANU05 | S7M8AN0 | PASS
40695 | HJF-IT-4E | [NAME] | S7N0AB00 | PASS
40696 | HJF-IT-4E | S7LAKU05 | S7NAE4 | PASS
40697 | HJF-IT-4E | SQ0AHU0 | S7NAK405 | PASS
40698 | HJF-IT-4E | S7LAKU05 | S7NAK503 | PASS
40699 | HJF-IT-4E | [NAME] | S7NAN070 | PASS
40700 | HJF-IT-4E | S7N4AEU03 | S7N4AE0806 | PASS
40701 | HJF-IT-4E | SQ0AHU0 | ST3AN008 | PASS
40702 | HJF-IT-4E | S7M8ANU05 | ST8AE08 | PASS
6//2011 | HJF-IT-4E | SQ0AHU0 | SQ0AH03 | PASS
Spreadsheet: 682880d1592377499-looking-for-a-formula-to-automatically-display-values-in-sheet-2-based-on-the-date-and-name-excel-workbook_chris
Sheet: Sheet1

 | SHEET-1
 | Date | Name | Amount |  |  | SHEET-2
 | 2020-05-01 00:00:00 | AA | 150
 | 2020-05-02 00:00:00 | AC | 200 |  |  | Date | AA | AB | AC | AD
 | 2020-05-06 00:00:00 | AD | 100 |  |  | 2020-05-01 00:00:00 |  |  |  |  |  |  | {=INDEX(E5:E11,MATCH(1,(H5=B5:B11)*(H6=C5:C11)*(H7=D5:D11),0))}
 | 2020-05-12 00:00:00 | AA | 50 |  |  | 2020-05-02 00:00:00
 | 2020-05-20 00:00:00 | AB | 25 |  |  | 2020-05-06 00:00:00
 | 2020-06-05 00:00:00 | AD | 43 |  |  | 2020-05-12 00:00:00
 | 2020-06-10 00:00:00 | AA | 120 |  |  | 2020-05-20 00:00:00
 | 2020-06-12 00:00:00 | AC | 130 |  |  | 2020-06-05 00:00:00
 | 2020-06-14 00:00:00 | AB | 35 |  |  | 2020-06-10 00:00:00
 | 2020-06-16 00:00:00 | AA | 78 |  |  | 2020-06-12 00:00:00
 |  |  |  |  |  | 2020-06-14 00:00:00
 |  |  |  |  |  | 2020-06-16 00:00:00
 |  | I'm looking for an excel formula to automatically enter the amount in sheet-2 table matching the name & date on the sheet-1.
Spreadsheet: 776117d1649510782-solver-solving-non-linear-equation-by-linearizing-the-equation-question-2-hydr-
Sheet: Compare

Distance Coverage | No of Nodes | Transportation Cost | Facility Cost | Total Cost | Demand Covered | Required Demand | % Demand Covered
1000 | 2 |  |  |  |  | 35875680
1000 | 3 |  |  |  |  | 35875680
1000 | 4 |  |  |  |  | 35875680
1000 | 5 |  |  |  |  | 35875680
800 | 6 |  |  |  |  | 35875680
800 | 7 |  |  |  |  | 35875680
800 | 8 |  |  |  |  | 35875680
800 | 9 |  |  |  |  | 35875680
500 | 10 |  |  |  |  | 35875680
500 | 11 |  |  |  |  | 35875680
500 | 12 |  |  |  |  | 35875680
500 | 13 |  |  |  |  | 35875680
300 | 14 |  |  |  |  | 35875680
300 | 15 |  |  |  |  | 35875680
300 | 18 |  |  |  |  | 35875680
300 | 20 |  |  |  |  | 35875680
Spreadsheet: 736549d1623731995-formula-that-compares-2-sets-of-numbers-and-takes-difference-of-closest-stock-short-term-comparison
Sheet: Sheet1

12 | 14 | 17 | 19 | 23 | 27 | 29 | 32 | 34 | 38 | 40 | 46 | 48 | 54 | 62 | 65 | 67
 |  |  |  |  |  |  |  |  |  |  |  | result
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  | patt analysis
12 | 14 | 17 | 19 | 21 | 24 | 30 | 32 | 34 | 36 | 39 | 42 | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2
Spreadsheet: 79603e6c-4f7f-4e35-b189-95818041d605
Sheet: Sheet1

 |  | University Means | National Means | CACREP Means | Non-CACREP Means | Minimum Criteria
2002-04-13 00:00:00 | 83.33% Passed | 111 | 108.8 | 117.42 | 114.85 | 102
2002-10-19 00:00:00 | 79.16% Passed | 112.88 | 108.53 | 115.33 | 108.19 | 97
2003-04-12 00:00:00 | 75% Passed | 115.5 | 111.7 | 123.07 | 120.54 | 103
2003-10-18 00:00:00 | 100% Passed | 124.5 | 108.5 | 113.82 | 110.82 | 98
2004-04-24 00:00:00 | 91.66% Passed | 117.33 | 105.44 | 117.62 | 115.01 | 100
2004-10-23 00:00:00 | 100% Passed | 110.27 | 102.91 | 110.18 | 107.34 | 93
2005-04-16 00:00:00 | 75% Passed | 113.63 | 105.04 | 115.5 | 113.67 | 99
2005-10-22 00:00:00 | 81% Passed | 111.69 | 105.29 | 114.15 | 108.77 | 95
2006-04-22 00:00:00 | 91% Passed | 111.91 | 101.31 | 115.11 | 114.51 | 98
2006-10-21 00:00:00 | 89% Passed | 114.68 | 99.12 | 110.89 | 108.22 | 92
2007-04-21 00:00:00 | 63.64% Passed | 111.18 | 105.18 | 120.53 | 115.63 | 102
2007-10-20 00:00:00 | 100% Passed | 115.86 | 97.51 | 109.69 | 106.3 | 90
2008-04-12 00:00:00 | 84.61% Passed | 109.54 | 100.11 | 114.44 | 113.56 | 97
2008-10-18 00:00:00 | 88.89% Passed | 116.11 | 99.24 | 111.55 | 105 | 91
2009-04-18 00:00:00 | 90% Passed | 115.1 | 92.82 | 112.62 | 109.32 | 94
2009-10-17 00:00:00 | 60% Passed | 100.9 | 99.62 | 110.01 | 106.25 | 91
2010-04-17 00:00:00 | 75% Passed | 105.2 | 97.6 | 111.77 | 110.57 | 95
2010-10-16 00:00:00 | 90% Passed | 110 | 96.7 | 108.28 | 105.41 | 89
2011-04-16 00:00:00 | 77% Passed | 112.85 | 99.53 | 116.44 | 114.94 | 100
2011-10-15 00:00:00 | 87% Passed | 104.13 | 95.72 | 108.45 | 106.41 | 89
2012-10-13 00:00:00 | 90% Passed | 107.1 | 98.91 | 110.44 | 107.25 | 92
Spreadsheet: 135021d1325764731-excel-lookup-emp0501
Sheet: Sheet1

 | Group | Development Tools |  | QA Tools | New Added By Team Leader |  | Added Skills by Team Members
Sr. No | Skill Expertise | [NAME] | Abaqus | LMS Test Lab | CATIA V5 | LMS Virtual Lab | Windows | Linux/Unix | HTML/XHTML 1.1/CSS 2.0 | C/C++ | Visual Basic | Adobe Photoshop CS4
1 | ABC | 5 | 3 |  |  |  | 4 | 1
2 | BCD | 5 | 5 | 5 | 3 | 5
3 | EFG | 4 | 3 | 4 |  |  | 4 | 2 | 2 | 2 | 2
4 | HIJ | 4 |  | 2 |  |  | 4
5 | KLM | 5 |  |  | 4 |  |  |  |  | 2 |  | 2
6 | NOP | 4 | 2 |  |  |  | 4 | 3 | 1 | 1 |  | 2
 | EMP Name | ABC
 | [NAME] | Skill Expertise
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 6
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 10
 |  |  | 11
 |  |  | 12
Spreadsheet: 701138d1603557569-how-to-get-the-right-numbers-behind-the-right-teams-from-a-sorted-list-map2
Sheet: Blad1

St.nr. | Team |  | Team res.cour. | Team afk | Cour.1 | Cour.2 | Cour.3
3 | Renault |  | [NAME] | Alf | 7 | 88 | 99
4 | [NAME] |  | AlphaTauri | Alp | 10 | 26
5 | Ferrari |  | Ferrari | Fer | 5 | 16
6 | [NAME] |  | Haas | [NAME] | 8 | 20
7 | [NAME] |  | [NAME] | McL | 4 | 55
8 | Haas |  | Mercedes GP | Mer | 44 | 77
10 | AlphaTauri |  | Racing Point | Rac | 11 | 18 | 27
11 | Racing Point |  | Red Bull Racing | Red | 23 | 33
16 | Ferrari |  | Renault | Ren | 3 | 31
18 | Racing Point |  | [NAME] | Wil | 6 | 63
20 | Haas
23 | Red Bull
26 | AlphaTauri
27 | Racing Point
31 | Renault
33 | Red Bull
44 | Mercedes
55 | [NAME]
63 | [NAME]
77 | Mercedes
88 | [NAME]
99 | [NAME]
Spreadsheet: 888531d1739035481-update-needed-to-formula-to-only-show-data-for-month-example
Sheet: January

 | Note: Rep names must be entered in exactly as they are shown in the survey report. Enter the supervisor name in the green boxes.
 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | Raymi [NAME]
 | [NAME]
 | Ricardo Herrera
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | [NAME]
 | [NAME]
 | Alexis Jaimes
 | [NAME]
 | Alexis Jaimes
 |  |  |  | Team Score
 | Sup 5
 |  |  |  | Team Score
 | Sup 6
 |  |  |  | DRG Score
 |  |  |  | Updated 11.15.24
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 7b

Product1 | EUR3 | USD | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Basis | 1176516 | 8587216 | 2305667 | 1922043 | 342242 | 132696 | 237558 | 14703938
Fixed-Float | 63317032 | 71810413 | 13896786 | 18446193 | 4534181 | 4127714 | 12082576 | 188214895
FRA | 24098679 | 15753947 | 8156682 | 23992 | 266321 | 73635 | 3813125 | 52186381
OIS | 20682932 | 5941215 | 5427554 | 152255 | 1712774 | 882072 | 905747 | 35704549
Swaption | 8137656 | 8044603 | 1259504 | 2564249 | 316345 | 16768 | 262662 | 20601787
OTHER* | 6089602 | 10370846 | 1131144 | 323043 | 163220 | 35577 | 236171 | 18349603
TOTAL | 123502417 | 120508240 | 32177337 | 23431775 | 7335083 | 5268462 | 17537839 | 329761153
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 769332d1645474521-change-cell-reference-to-a-column-when-copying-formula-in-a-row-productivity-score
Sheet: Productivity

 | 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
[NAME]
Example 2
Example 3
Example 4
Spreadsheet: d8f88b77-0f0b-44d0-bf79-8c93ee7cebb2
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0000185 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Ocean Sands | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Currituck | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did infiltration occur at this facility? |  |  |  |  |  | Site Name: |  | 1 |  | Site Name: |  |  |  | Site Name: |  |  |  | Site Name:
 |  |  |  |  |  | Area (acres): |  | 2.41 |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Rate (GPD/ft2): |  | 7.65 |  | Rate (GPD/ft2): |  |  |  | Rate (GPD/ft2): |  |  |  | Rate (GPD/ft2):
Day | Weather |  |  | Freeboard |  | Site Infiltrated? |  |  |  | Site Infiltrated? |  |  |  | Site Infiltrated? |  |  |  | Site Infiltrated?
 | Weather Code | Temperature | Precipitation | Storage           (if applicable) | 5-Day Upset       (if applicable) | Volume Applied | Time   Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time    Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time   Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time    Infiltrated | Daily   Loading | [NAME] (Basins Only)
 |  | ºF | in | ft | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft
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 (GPD/ft2):
Year to Date Loading (GPD/ft2):
Spreadsheet: 812564d1673254372-extract-data-example-layout-v2
Sheet: Extracted Data

Product Name | Product Data 2 | Product Data 3 | Product Data 4 | Product Data 5 | Product Data 6 | Product Data 7 | Product Data 8 | Product Data 9 | Product Data 10 | Product Data 11 | Product Data 12 | Product Data 13 | Product Data 14 | Product Data 15 | Product Data 16
Spreadsheet: 841470d1693642024-find-most-occuring-value-and-sort-the-top-3-book2-amoi-
Sheet: Sheet1

WO Description | Start Date | Finish date | Total Downtime | Work Type
BRAKE SYSTEM FIXED | 2022-04-15 10:00:00 | 2022-04-15 13:00:00 | 3 | BD
SAFETY INSPECTION | 2022-04-18 08:10:00 | 2022-04-18 09:10:00 | 0.9999999999417923 | INS
SAFETY INSPECTION | 2022-05-02 10:30:00 | 2022-05-02 11:30:00 | 0.9999999999417923 | INS
HEAD [NAME] REPLACED | 2022-05-04 15:05:00 | 2022-05-04 15:43:00 | 0.6333333334769122 | BD
REAR BRAKE FIXED | 2022-05-09 13:00:00 | 2022-05-09 16:00:00 | 3 | BD
SAFETY INSPECTION &REAR BRAKE REPAIRED | 2022-05-21 11:00:00 | 2022-05-21 14:00:00 | 3 | INS |  |  | Work Type | WO Description | Total Downtime
INSPECTION+BRAKE SYSTEM REPAIR | 2022-06-13 07:50:14 | 2022-06-13 11:50:14 | 3.999999999941792 | INS
SAFETY INSPECTION | 2022-09-05 09:00:00 | 2022-09-05 10:00:00 | 0.9999999999417923 | INS
SAFETY INSPECTION | 2022-09-19 10:00:00 | 2022-09-19 11:30:00 | 1.5 | INS
Spreadsheet: 261ec12c-0467-4291-9076-f27043865dbf
Sheet: EPR CF

Consolidated Statements of Cash Flows (Unaudited and Condensed)
Six Months Ended March 31, | 2014 |  | 2013
(In millions)
Operating
Net income | 105.0000000000001 |  | 143.4999999999999
Adjustments:
Depreciation and amortization | 99.4 |  | 117.8
Acquisition-related contingent earn-out costs | 6.6 |  | 16.2
Other non-cash items | 64.8 |  | 54.7
Changes in operating assets and liabilities, excluding acquisitions:
Receivables | 15.5 |  | -21.1
Inventories | 13.4 |  | 9.4
Accounts payable and accrued liabilities | -50.2 |  | -78
Jackpot liabilities | -32.90000000000001 |  | -40.7
Income taxes, net of employee stock plans | -50.4 |  | -21.9
Other assets | -236.4 |  | 2.6
Net operating cash flows | -65.19999999999997 |  | 182.4999999999999
Investing
Capital expenditures | -46.2 |  | -56.40000000000001
Investment securities, net | 13.90000000000001 |  | 0
Jackpot annuity investments, net | 25 |  | 27.1
Changes in restricted cash | 5.6 |  | 5.8
Loans receivable payments received | 14.9 |  | 15.1
Proceeds from assets sold | 7.8 |  | 8.3
Net investing cash flows | 21 |  | -0.1000000000000032
Financing
Debt-related proceeds (payments), net | -0.6 |  | -20
Employee stock plan proceeds | 12 |  | 8.3
Share repurchases, including net shares | -211.3 |  | -75.1
Dividends paid | -53.4 |  | -34.7
Acquisition-related contingent consideration | -56.1 |  | -27.9
Net financing cash flows | -309.4 |  | -149.4
Foreign exchange rates effect on cash and equivalents | -3.9 |  | -2.8
Net change in cash and equivalents | -357.4999999999999 |  | 30.19999999999986
Beginning cash and equivalents | 713.3 |  | 206.3
Ending cash and equivalents | 355.8 |  | 236.4999999999999
Spreadsheet: 732664d1621129185-possible-vlookup-function-trying-to-search-through-multiple-sheets-summary-v4
Sheet: 089A

FIRE DEPT. GENERIC
Project # | 089A | ` |  |  |  |  |  |  | Month: | 2021-05-01 00:00:00 |  |  | WO# | SL167 |  |  | Match Component |  | 0
Crew and Equipment |  |  |  |  |  |  |  |  |  |  |  |  | Production |  |  |  | Value breakdown |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WO Amount
DATE | CREW NUMBERS | Crew mumbers | Crew Sup Days | Crew Sup OT HOURS | Camp Sup Days | Camp Sup OT Hours | CCV DAYS (C01) | CCV Miles (C01) | Support Vehicle DAYS | Support Vehicle Miles | Additional Saws | Chipper Days | FUEL REDUCTION ACRES | [NAME] | [NAME] | [NAME] | Inmate Cost | Crew Sup Daily Rate | Crew Sup OT Cost | Camp Sup Daily Rate | Camp Sup OT Cost | CCV DAILY COST | CCV Mileage Cost | Support Vehilce Daily Cost | Support Vehicle Mileage | Chainsaw Cost | Chipper Cost | Daily Cost | Minus Match | Billable Cost | Cost Per Acre | 0
2021-05-03 00:00:00 | 4014 | 10 | 1 | 0 | 0 | 0 | 1 | 46 | 0 | 0 | 2 | 0 | 0.25 |  |  |  | 22.3 | 518.2 | 0 | 0 | 0 | 173 | 57.04 | 0 | 0 | 124 | 0
 | TSI
2021-05-04 00:00:00 | 4014 | 9 | 1 | 0 | 0 | 0 | 1 | 46 | 0 | 0 | 1 | 0 | 0.25 |  |  |  | 20.07 | 518.2 | 0 | 0 | 0 | 173 | 57.04 | 0 | 0 | 62 | 0
 | TSI
2021-05-06 00:00:00 | 4014 | 5 | 1 | 0 | 0 | 0 | 1 | 46 | 0 | 0 | 0 | 0 | 0.25 |  |  |  | 11.15 | 518.2 | 0 | 0 | 0 | 173 | 57.04 | 0 | 0 | 0 | 0
 | TSI
2021-05-10 00:00:00 | 4008 | 10 | 1 | 0 | 0 | 0 | 1 | 46 | 0 | 0 | 1 | 0 | 0.25 |  |  |  | 22.3 | 518.2 | 0 | 0 | 0 | 173 | 57.04 | 0 | 0 | 62 | 0
 | TSI
2021-05-12 00:00:00 | 4003 | 10 | 1 | 0 | 0 | 0 | 1 | 45 | 0 | 0 | 0 | 0 | 0.33 |  |  |  | 22.3 | 518.2 | 0 | 0 | 0 | 173 | 55.8 | 0 | 0 | 0 | 0
 | TSI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REMAINING
TOTALS
Spreadsheet: 66857d1267547691-sum-values-based-on-multiple-criteria-comma-delimited-in-a-single-cell-sample
Sheet: target

code set | month | total
AM62, C04 | january | 1927
C04 | february | 209
C07, C04 | march | 399
c09 | april | 693
z4 | may | 19
z47 | june | 85
[NAME], z47 | july | 85
Spreadsheet: 118765d1314000471-if-statement-to-compare-times-variation_calc
Sheet: Raw Parts

Average Parts Per Shift |  |  |  |  |  |  |  |  |  | Average Parts Per Shift
 | (Monday) |  |  |  |  |  |  |  |  |  | (Monday)
Shift | Line |  |  |  |  |  |  |  |  | Shift | Line
1 | IEC109-1 | IEC109-2 | IEC109-3 | IEC109-4 |  |  |  |  |  | 1 | IEC110-1 | IEC110-2 | IEC110-3 | IEC110-4
Shift | Line |  |  |  |  |  |  |  |  | Shift | Line
2 | IEC109-1 | IEC109-2 | IEC109-3 | IEC109-4 |  |  |  |  |  | 2 | IEC110-1 | IEC110-2 | IEC110-3 | IEC110-4
Shift | Line |  |  |  |  |  |  |  |  | Shift | Line
3 | IEC109-1 | IEC109-2 | IEC109-3 | IEC109-4 |  |  |  |  |  | 3 | IEC110-1 | IEC110-2 | IEC110-3 | IEC110-4
 | Shifts: |  | #REF!
 | Time:
 | Current Time: |  |  |  | 109-1 | 109-2 | 109-3 | 109-4 |  |  |  |  |  |  | 110-1 | 110-2 | 110-3 | 110-4
 | End Time |  | 06:00:00
 | Difference:
 | Coefficient
Spreadsheet: 823221d1679818481-make-a-cell-with-many-lines-into-order-example1
Sheet: Number

Number Operations
[NAME] for working with numbers
Number (input) | 3.141593
Cleaned Up
Int
2 decimals
Converts text to a number, in a locale-independent way
Inputs
Text | 123.456,78
Decimal Separator | ,
Group Separator | .
Output
Reformatted Number
Spreadsheet: 029aa1a8-0f60-410e-960e-2b7600c0e3c4
Sheet: Sheet1

Table 5--U.S. and world fiber prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | May | June | July |  | July
Item | 2013 | 2013 | 2013 |  | 2012
 | Cents per pound
Domestic cotton prices:
Adjusted world price | 71.82 | 72.06 | 71.56 |  | 63.04
Upland spot 41-34 | 79.84 | 82.18 | 81.62 |  | 66.14
Pima spot 03-46 | 133 | 133 | 133 |  | 103
Average price received by
upland producers | 75.3 | 76.7 | 76.4 |  | 76.6
Far Eastern cotton quotes:
A Index | 92.3 | 93.25 | 92.83 |  | 83.75
Memphis/Eastern | 93.45 | 94.56 | 93.88 |  | 86.06
Memphis/Orleans/Texas | 93.2 | 94.31 | 93.63 |  | 86.25
California/Arizona | 96.55 | 97.56 | 96.88 |  | 88
 |  | Dollars per pound
Wool prices (clean):
U.S. 56s | NQ | NQ | NQ |  | NQ
Australian 56s 1/ | 3.71 | 3.72 | 3.58 |  | 4.48
U.S. 60s | NQ | NQ | NQ |  | NQ
Australian 60s 1/ | 5.1 | 5.13 | 4.75 |  | 5.74
U.S. 64s | NQ | NQ | NQ |  | NQ
Australian 64s 1/ | 5.18 | 5.09 | 4.71 |  | 5.78
NQ = No quote.
1/  In bond, Charleston, SC.
Sources: USDA, Cotton Price Statistics; Cotlook Ltd., [NAME];
and trade reports.
Last update:  08/14/13.
Spreadsheet: 888653d1739222042-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 41

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Mon 12 Mar Glucose mmol/L
Tue 13 Mar Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  |  | 5.9
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Wed 14 Mar Glucose mmol/L
Thu 15 Mar Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Fri 16 Mar Glucose mmol/L
 |  |  |  |  | 6.4
Sat 17 Mar Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sun 18 Mar Glucose mmol/L
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Mon 19 Mar Glucose mmol/L