tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 68473d1269007855-sum-with-conditions-pipebook2
Sheet: Totals

Project Quantity Takeoff
Hospital Phase 1
Main Line Water
Length of Pipe (ft) | Size of Pipe | Type Replacing | Main Valves | [NAME] | Air Release
3248.5 | 6 | AC | 0 | 0 | 0
375.1 | 8 | AC | 0 | 0 | 0
843.8 | 12 | AC | 0 | 0 | 0
4467.4 |  |  | 0 | 0 | 0
0 | 3 | Other | 0 | 0 | 0
146 | 4 | Other | 0 | 0 | 0
3248.5 | 6 | Other | 0 | 0 | 0
843.8 | 12 | Other | 0 | 0 | 0
4238.3 |  |  | 0 | 0 | 0
Services
Quantity | Service [NAME] | Total Length (ft) | Type Replacing | [NAME]
0 | 1.25 | 0 | Other | 1
1 | 1.5 | 5.5 | Other | 1
4 | 2 | 104.6 | Other | 2
1 | 2.5 | 146 | Other | 1
3 | 3 | 30.3 | Other | 3
2 | 4 | 75 | Other | 2
1 | 12 | 6 | Other | 1
13 |  | 367.4 |  | 11
Hydrants
Quantity | Size | Total Length (ft) | Type Replacing | [NAME]
7 | 6 | 18 | AC | 2
0 |  | 18 |  | 2
2 | 1.5 | 12.4 | Other | 1
0 | 3 | 12.8 | Other | 1
7 | 6 | 140.1 | Other | 1
1 | 12 | 2.8 | Other | 0
17 |  | 168.1 |  | 3
Spreadsheet: 790888d1660049654-need-help-to-extract-unique-filtered-value-with-sorting-with-some-criteria-2022-08-09-oeldere-pankaj-jaswani-sample-data_excel-forum-help-for-unique-filter-with-sorting
Sheet: data

vivo Royal Blue | 1
Diamond | 2
Titanium | 3
Platinum | 4
Gold | 5
Silver | 6
[NAME] | 7
No Category | 8
MT Business | 9
Exclusive | 10
RMT Business | 11
Spreadsheet: 298308d1392755557-find-a-value-in-a-table-with-multiple-values-test-excel-data-search-sheet
Sheet: ON-7

Date | PO # | Buyer | Division Line | Model | Trailer Description | Serial # | Build Location | Line # | Est. Delivery Date | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00
Spreadsheet: 848772d1699404496-workforce-planning-formula-workforce-planning-template
Sheet: Input

Title | Start Date | End Date | Name | Department | ID/OH | Merit | Merrit Period | Gross Annual Salary | Gross Daily | Burden (18%) | Net Daily | Bonus % | Bonus | Burden (18%) | Net Bonus
Chief [NAME] | 2024-02-01 00:00:00 | 2024-10-01 00:00:00 | [NAME] | Fleet | OH | 0.03 | 2024-04-01 00:00:00 | 200000 |  |  |  | 0.4
Spreadsheet: 133222d1324297025-excel-2007-result-hollow-number-sample
Sheet: Sheet2

Number 1 | Number 2 | Result | What i want as result
6250 | 1400 |  | 5
3550 | 1400 |  | 3
4350 | 1400 |  | 4
6000 | 1400 | 4.28 | 5
Spreadsheet: 73680d1274291658-excel-2007-automated-copying-from-worksheet-to-worksheet-based-off-text-example-for-macro-help2
Sheet: Bill

City | Travel date | Person going | Cost | Paid/Not Paid
Grand Island | 2009-02-05 00:00:00 | [NAME] | 125.45 | PAID
Grand Island | 2009-03-06 00:00:00 | [NAME] | 120.35 | PAID
Grand Island | 2009-12-09 00:00:00 | [NAME] | 190.8 | PAID
Kearney | 2009-05-08 00:00:00 | [NAME] | 215 | PAID
Kearney | 2009-10-25 00:00:00 | [NAME] | 210.25 | PAID
North Platte | 2009-01-01 00:00:00 | [NAME] | 300 | PAID
North Platte | 2009-04-05 00:00:00 | [NAME] | 265.26 | PAID
North Platte | 2009-06-06 00:00:00 | [NAME] | 260 | PAID
North Platte | 2009-08-05 00:00:00 | [NAME] | 255.98 | PAID
Spreadsheet: 759729d1639686632-an-alternate-for-nested-if-sample
Sheet: Summary

Part | Group | Std Cost | LPP | Delta | On Hand | 2022 Req | Excess | On Order | Last Purchase Date | Month and Year | Suggested Std Cost
101 | Group A | 2 | 2 |  | 10 | 20 |  | 20 | 2021-12-02 00:00:00
102 | Group A | 3 | 6 |  | 5 | 4 |  | 2 | 2021-01-01 00:00:00
103 | Group B | 4 | 7 |  | 4 | 2 |  | 2 | 2021-06-25 00:00:00
104 | Group B | 5 | 8 |  | 6 | 10 |  | 10 | 2021-02-04 00:00:00
105 | Group C | 12 | 15 |  | 80 | 100 |  | 50 | 2021-03-15 00:00:00
106 | Group C | 15 | 15 |  | 100 | 50 |  | 0 | 2021-08-05 00:00:00
107 | Group D | 4 | 6 |  | 20 | 30 |  | 0 | 2021-09-21 00:00:00
108 | Group D | 8 | 10 |  | 15 | 20 |  | 10 | 2021-02-02 00:00:00
109 | Group E | 7 | 9 |  | 200 | 250 |  | 100 | 2021-07-08 00:00:00
110 | Group E | 50 | 65 |  | 10 | 8 |  | 0 | 2021-11-21 00:00:00
 |  |  | List of criteria:
- If LPP<[NAME] cost and (2022 Req = 0,On Order=0), return LPP
- if LPP>Std cost and (2022 Req=0, On Order=0), return [NAME] cost
- if LPP>Std and (2022 Req<>0, On Order=0), return LPP
- If LPP<[NAME] and (2022Req=0, On Order<>0, group = Group B), return LPP, if group<>Group B but everything else is TRUE, return [NAME])
- If LPP>Std and (Purchase Date >= July 2021, Purchase Date<=Dec 2021, 2022Req<>0, On Order=0), return LPP
- If LPP<[NAME] and (Purchase Date >= July 2021, Purchase Date<=Dec 2021, 2022Req<>0, On Order=0), return the LPP or [NAME] (which ever is the highest)
Spreadsheet: 267378d1380057675-index-match-vlookup-if-then-help-example-new
Sheet: GG Completed Homes HUD

Code | Home Sale Price | GG Soft Second Amount | Other Soft Second Amount | Type (NSP2, FANO CITY)
1608TEN | 140000 | 120915 | 0 | N/A
1613TEN | 149668 | 45000 | 0 | N/A
1614REY | 149500 | 58500 | 0 | N/A
1617REY | 130000 | 51100 | 0 | N/A
1620TEN | 140000 | 75000 | 0 | N/A
1626TEN | 150000 | 0 | 0 | N/A
1627-29FOR | 149668 | 58211.74 | 0 | N/A
1631TEN | 120000.18 | 24000 | 0 | N/A
1632TEN | 137067 | 27413 | 0 | N/A
1637TEN | 145465 | 29093 | 0 | N/A
1638TEN | 100000 | 75000 | 0 | N/A
1644TEN | 143000 | 60000 | 0 | N/A
1703FOR | 140000 | 60000 | 0 | N/A
1707TEN | 185000 | 0 | 0 | N/A
1708FOR | 133016 | 18103 | 0 | N/A
1708TEN | 166395.02 | 33279 | 0 | N/A
1711DES | 137067 | 27413.4 | 0 | N/A
1714TEN | 166395 | 33279 | 0 | N/A
1717-19DES | 150000 | 25000 | 0 | N/A
1720TEN | 156198 | 31240 | 0 | N/A
1724DES | 200000 | 67499 | 0 | N/A
1728REY | 150000 | 48800 | 0 | N/A
1735DES | 170347 | 38269.4 | 0 | N/A
1737TEN | 137067 | 20898.4 | 0 | N/A
1738REY | 145465.12 | 70465.12 | 0 | N/A
1744TEN | 177769 | 35554 | 0 | N/A
1807TEN | 120000 | 24000 | 0 | N/A
1809DES | 140308 | 27413 | 0 | N/A
1810REY | 120000 | 75000 | 0 | N/A
1813TEN | 200000 | 60000 | 0 | N/A
1814TEN | 130000 | 51100 | 0 | N/A
1815JOU | 140000 | 37802 | 0 | N/A
1817REY | 165000 | 33000 | 0 | N/A
1819TEN | 137067 | 27413.4 | 0 | N/A
1825TEN | 153965 | 35000 | 0 | N/A
1826REY | 130000 | 50000 | 0 | N/A
1826TEN | 166395.36 | 33279.07 | 0 | N/A
1827DES | 130000 | 65000 | 0 | N/A
1827JOU | 150000 | 50000 | 0 | N/A
1832DES |  | 75000 | 0 | N/A
1835FOR | 175000 | 65000 | 0 | N/A
1843TEN | 145465 | 29093 | 0 | N/A
1845DES | 145465 | 29093 | 0 | N/A
1901DES | 150000 | 65000 | 0 | N/A
1901TEN | 150000 | 35000 | 0 | N/A
1904DES | 160000 | 30000 | 0 | N/A
1905DES | 160000 | 75000 | 0 | N/A
1907JOU | 163000 | 45000 | 0 | N/A
1910REY | 150000 | 48000 | 0 | N/A
1913DES | 157359.6 | 31471.92 | 0 | N/A
1914TEN | 120000 | 50000 | 0 | N/A
1919TEN | 145465.02 | 29093.02 | 0 | N/A
1925DES | 200000 | 40000 | 0 | N/A
1926REY | 140000 | 45000 | 0 | N/A
1927FOR | 150000 | 75000 | 0 | N/A
1932DES | 130000 | 65000 | 0 | N/A
1932REY | 140000 | 35000 | 0 | N/A
1937TEN | 149668 | 39668 | 0 | N/A
1938DES | 140000 | 60000 | 0 | N/A
1938TEN | 150000 | 75000 | 0 | N/A
1943TEN | 170000 | 35000 | 0 | N/A
1944TEN | 120000 | 45000 | 0 | N/A
2008TEN | 170000 | 25000 | 0 | N/A
2026TEN | 150000 | 50000 | 0 | N/A
4813PRI | 150000 | 65000 | 0 | N/A
4850DER | 150000 | 48250 | 0 | N/A
4934PRI | 150000 | 65000 | 0 | N/A
5005DER | 150000 | 50000 | 0 | N/A
5012DER | 140000 | 65000 | 0 | N/A
5018PRI | 145465 | 40454.17 | 0 | N/A
5019-21PRI | 150000 | 50000 | 0 | N/A
5035DER | 125000 | 29150 | 0 | N/A
1750TEN | 200000 | 25000 | 5000 | FANO
1918DES | 150000 | 0 | 5641.32 | FANO
2014TEN | 150000 | 0 | 5891.32 | FANO
2019TEN | 150000 | 0 | 5891.32 | FANO
4819PRI | 150000 | 0 | 25000 | NSP2
1607JOU | 150000 | 0 | 55000 | CITY
1744REY | 170000 | 0 | 59350 | CITY
1617-19JOU | 150000 | 0 | 64350 | CITY
5014ROM | 150000 | 0 | 64400 | CITY
1911DES | 170000 | 0 | 65000 | CITY
1818REY | 150000 | 0 |  | NSP2
Spreadsheet: 526110d1499124611-sumif-with-capital-purchases-10-in-column-b-if-gst-0-in-column-c-sunnyb0y-sumif-with-capital-purchases-10-in-column-b-if-gst-0-in-column-c-testing-capital-purch
Sheet: Sheet1

Testing SUMIF with Capital Purchases >10 in Column B if GST >0 in column C
Formula 1: Display each "Capital Purchases" formula in column B under each section and then manually sum those sections (eg B15 + [NAME])
 |  |  |  |  | expecting 60
[NAME] (more dynamic): One "Capital Purchases" formula that sums rows B9:B38 but which excludes the Sub Totals and Capital Purchases rows (by filtering the word Sub and Capital???)
 |  |  |  |  | expecting 60
Widgets | Total ex GST | GST | Total inc GST
[NAME] | 5 | 0
[NAME] | 10 | 0
[NAME] | 5 | 0
[NAME] | 5 | 0
Sub Totals
Capital Purchases |  |  |  |  | expecting 0
Didgets | Total ex GST | GST | Total inc GST
[NAME] |  |  | 11
[NAME] | 10 | 0
[NAME] | 10 | 0
[NAME] |  |  | 11
[NAME] | 5 | 0
[NAME] |  |  | 11
Sub Totals
Capital Purchases |  |  |  |  | expecting 30
Gadgets | Total ex GST | GST | Total inc GST
[NAME] |  |  | 11
Sub Totals
Capital Purchases |  |  |  |  | expecting 10
Things | Total ex GST | GST | Total inc GST
[NAME] |  |  | 11
[NAME] |  |  | 11
[NAME] | 10 | 0
[NAME] | 10 | 0
Sub Totals
Capital Purchases |  |  |  |  | expecting 20
Spreadsheet: 736075d1623339312-extracting-intermediate-values-from-start-and-end-points-of-line-06042021
Sheet: F-40000-A

customer SPECIFICATION : |  |  | -30 | -30 | -28 | -25 | 0.2 | 0.15 | 0.15
our SPECIFICATION :
our TEST PARAMETERS :
 | Part Number | dB Value | Return Loss [dB] (0005-0400 MHz) | Return Loss [dB] (0400-0600 MHz) | Return Loss [dB] (0600-1000 MHz) | Return Loss [dB] (1000-1200 MHz) | Tilt [dB] | Ideal Deviation [dB] (0005 MHz) | Flatness [dB] (0005-1250 MHz)
1 |  | 0
2 |  | 0
3 |  | 0
4 |  | 0
5 |  | 0
6 |  | 0
7 |  | 0
8 |  | 0
9 |  | 0
10 |  | 0
11 |  | 0
12 |  | 0
13 |  | 0
14 |  | 0
15 |  | 0
16 |  | 0
17 |  | 0
18 |  | 0
19 |  | 0
20 |  | 0
21 |  | 0
22 |  | 0
23 |  | 0
24 |  | 0
25 |  | 0
26 |  | 0
27 |  | 0
28 |  | 0
29 |  | 0
30 |  | 0
Stats for individual
Average
Std Deviation
[NAME]
Min
Cp
CP USL
Cp LSL
Cpk
Spreadsheet: 215742d1361467090-count-of-occupied-beds-sample-test-formula
Sheet: Sheet1

 |  | Date/Time In | D/C Date & time |  |  |  |  |  |  | Jan | Feb | Mar
 |  | 2013-01-02 09:20:00 | 2013-01-03 11:00:00 |  |  |  |  |  | 1 | 0
 |  | 2013-01-02 12:40:00 | 2013-01-03 13:00:00 |  |  |  |  |  | 2 | 0 | #N/A
 |  | 2013-01-02 13:30:00 | 2013-01-04 13:20:00 |  |  |  |  |  | 3 | 0
 |  | 2013-01-02 13:30:00 | 2013-01-03 20:25:00 |  |  |  |  |  | 4 | 0
 |  | 2013-01-02 13:30:00 | 2013-01-06 19:15:00 |  |  |  |  |  | 5 | 0
 |  | 2013-01-02 22:30:00 | 2013-01-03 12:00:00 |  |  |  |  |  | 6 | 0
 |  | 2013-01-03 01:25:00 | 2013-01-04 10:10:00 |  |  |  |  |  | 7 | 0
 |  | 2013-01-03 09:00:00 | 2013-01-03 14:25:00 |  |  |  |  |  | 8 | 0
 |  | 2013-01-03 13:20:00 | 2013-01-05 12:15:00 |  |  |  |  |  | 9 | 0
 |  | 2013-01-03 14:35:00 | 2013-01-04 11:20:00 |  |  |  |  |  | 10 | 0
 |  | 2013-01-03 10:30:00 | 2013-01-05 14:30:00 |  |  |  |  |  | 11 | 0
 |  | 2013-01-03 16:20:00 | 2013-01-04 11:15:00 |  |  |  |  |  | 12 | 0
 |  | 2013-01-03 16:50:00 | 2013-01-04 09:55:00 |  |  |  |  |  | 13 | 0
 |  | 2013-01-03 22:30:00 | 2013-01-05 10:40:00 |  |  |  |  |  | 14 | 0
 |  | 2013-01-04 12:05:00 | 2013-01-05 10:10:00 |  |  |  |  |  | 15 | 0
 |  | 2013-01-04 14:40:00 | 2013-01-05 15:20:00 |  |  |  |  |  | 16 | 0
 |  | 2013-01-04 13:30:00 | 2013-01-04 18:50:00 |  |  |  |  |  | 17 | 0
 |  | 2013-01-04 17:40:00 | 2013-01-05 09:20:00 |  |  |  |  |  | 18 | 0
 |  | 2013-01-04 14:45:00 | 2013-01-05 13:15:00 |  |  |  |  |  | 19 | 0
 |  | 2013-01-05 10:40:00 | 2013-01-09 11:15:00 |  |  |  |  |  | 20 | 0
 |  | 2013-01-05 12:40:00 | 2013-01-05 22:30:00 |  |  |  |  |  | 21 | 0
 |  | 2013-01-05 18:00:00 | 2013-01-09 19:10:00 |  |  |  |  |  | 22 | 0
 |  | 2013-01-05 18:15:00 | 2013-01-07 10:25:00 |  |  |  |  |  | 23 | 0
 |  | 2013-01-06 00:30:00 | 2013-01-08 12:40:00 |  |  |  |  |  | 24 | 0
 |  | 2013-01-06 00:45:00 | 2013-01-06 17:05:00
 |  | 2013-01-06 03:15:00 | 2013-01-06 19:50:00
 |  | 2013-01-06 06:55:00 | 2013-01-07 16:20:00
 |  | 2013-01-06 20:35:00 | 2013-01-08 10:00:00
 |  | 2013-01-06 22:00:00 | 2013-01-08 11:10:00
 |  | 2013-01-05 15:50:00 | 2013-01-07 15:30:00
 |  | 2013-01-07 10:35:00 | 2013-01-08 10:35:00
 |  | 2013-01-07 16:40:00 | 2013-01-08 11:10:00
 |  | 2013-01-07 11:45:00 | 2013-01-07 17:15:00
 |  | 2013-01-07 17:25:00 | 2013-01-08 11:25:00
 |  | 2013-01-07 22:10:00 | 2013-01-09 10:25:00
 |  | 2013-01-08 13:50:00 | 2013-01-09 11:35:00
 |  | 2013-01-08 17:10:00 | 2013-01-11 15:45:00
 |  | 2013-01-08 15:25:00 | 2013-01-10 17:10:00
 |  | 2013-01-08 16:05:00 | 2013-01-09 14:55:00
 |  | 2013-01-08 17:15:00 | 2013-01-08 20:00:00
Spreadsheet: 124092d1318085378-multiply-2-fields-and-then-add-it-to-another-field-example
Sheet: Blad1

[NAME] bierrekening [NAME]
In kas |  |  |  |  |  |  |  |  |  |  |  | Stand Bierlijst
Tegenpartij | Omschrijving | Datum | Bedrag | Pe | Ge | Ja | Ti | Al | HJ | ?? |  | Stand Bierrekening |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
[NAME] der [NAME] | Bier Oktober | 2011-10-08 00:00:00 | 15 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  | Stand
TestTestTest | 2 kratten bier | 2011-10-08 00:00:00 | -15 |  |  |  |  |  |  |  |  | Omschrijving | Datum | Pe |  | Ge |  | Ja |  | [NAME] |  | Al |  | OH
 |  |  |  |  |  |  |  |  |  |  |  | Verrekening Bierlijst | 2011-10-08 00:00:00 | 5 | 4 | 16 | 17 | 5 | 5 | 2 | 3 | 2 | 2 | 2 | 3
Spreadsheet: 734477d1622192184-multi-if-and-function-for-range-of-cell-something-wrong-in-formula-multi-if
Sheet: Sheet1

Well | AAAA | BBBB | CCCC | DDDD | Interpretation | New solution
A01 |  | 31.28
A02 |  | 30.93
A03 |  | 30.38 |  |  |  |  |  |  | [NAME] (1: cell >0, blank: blank cell)
A04 |  | 31.61 |  |  |  |  |  |  |  |  |  |  | Inva
A05 |  | 30.69 |  |  |  |  |  |  |  | 1 |  |  | Ne
A06 |  | 31.16 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | Posi
A07 |  | 31.52 |  |  |  |  |  |  | 1 |  | 1 | 1 | Posi
A08 |  | 31.3 |  |  |  |  |  |  | 1 | 1 |  | 1 | Posi
A09 |  | 30.45 |  |  |  |  |  |  | 1 |  |  | 1 | Posi
A10 |  | 36.22 |  |  |  |  |  |  |  | 1 | 1 | 1 | Posi
A11 |  | 31 |  |  |  |  |  |  |  |  | 1 | 1 | Posi
A12 |  | 30.01 |  |  |  |  |  |  |  | 1 |  | 1 | Like
B01 |  | 31.97 | 37.28 |  |  |  |  |  |  |  |  | 1 | Like
B02 | 23.5 |  | 23.04 | 24.46 |  |  |  |  | 1 | 1 | 1 |  | Un
B03 |  | 30.19 |  |  |  |  |  |  | 1 |  | 1 |  | Un
B04 |  | 30.54 |  |  |  |  |  |  | 1 | 1 |  |  | Un
B05 |  | 29.75 |  |  |  |  |  |  | 1 |  |  |  | Un
B06 |  | 28.94 |  |  |  |  |  |  |  | 1 | 1 |  | Un
B07 |  | 29.46 | 38.8 |  |  |  |  |  |  |  | 1 |  | Un
B08 |  | 33.31
B09 |  | 28.76
B10 |  | 29.87
B11 |  | 28.96
B12 |  | 29.45
C01 |  | 30.14
C02 |  | 28.61
C03 |  | 29.38
C04 |  | 30.65
C05 |  | 30.77
C06 |  | 30.1
C07 |  | 29.15
C08 |  | 29.05
C09 |  | 29.85
C10 | 19.99 |  | 20.57 | 20.8
C11 |  | 28.88
C12 |  | 29.84
D01 |  | 28.98
D02 |  | 29.47
D03 |  | 28.6
D04 |  | 28.46
D05 |  | 28.95
D06 |  | 28.42
D07 |  | 29.38
D08 |  | 29.45
D09 |  | 28.63
D10 |  | 28.14
D11 |  | 28.62
D12 |  | 29.41
E01 |  | 30.06
E02 |  | 29.85
E03 |  | 29.14
E04 |  | 29.32
E05 |  | 28.53
E06 | 35.96 | 28.54
[NAME] |  | 29.11
E08 |  | 29.93
E09 |  | 29.04
E10 |  | 29.51
E11
E12 | 24.86 |  | 25.89 | 25.55
Spreadsheet: phillip_m_love__30678__200001Trans_OA
Sheet: Pre2000 Value

PRE - 2000 TRANSPORT BOOK
As of Feb - 2000 GL
 | January |  | February |  | Total
 | [NAME] | Amount | [NAME] | Amount | [NAME] | Amount
Transport Revenue - Sharp | 0 | 0 | 0 | 0
Transport Revenue - Martin | 0 | 0 | 0 | 0
Transport Revenue - Third Party
Compressor Fuel Expense | 0 | -238267 | 0 | -935406.78
Transport Expense - Third Party
Unaccounted for Gas Loss | 0 | -307050 | 0 | 0
Originations | 0 | 0 | 0 | 0
Spreadsheet: 390639d1429714154-segregate-and-sum-amounts-in-various-rows-formula-question
Sheet: Sheet1

 |  |  |  |  | Desired
Position # |  | Amount |  |  | Results
 |  |  |  |  | Position | Amount
20 |  | 100
19 |  | 200
18 |  | 200
17 |  | 400
18 |  | 300
20 |  | 300
19 |  | 300
17 |  | 200
16 |  | 400
15 |  | 400
15 |  | 400
13 |  | 600
16 |  | 500
15 |  | 500
14 |  | 500
14 |  | 500
15 |  | 500
17 |  | 500
12 |  | 500
12 |  | 600
13 |  | 600
13 |  | 500
11 |  | 600
10 |  | 600
10 |  | 600
9 |  | 600
8 |  | 600
7 |  | 700
6 |  | 700
10 |  | 700
9 |  | 700
8 |  | 800
10 |  | 700
7 |  | 700
9 |  | 800
15 |  | 700
4 |  | 800
4 |  | 800
3 |  | 900
2 |  | 1000
4 |  | 900
6 |  | 1000
2 |  | 900
7 |  | 1100
5 |  | 1100
1 |  | 1200
1 |  | 1300
3 |  | 1400
2 |  | 1500
 |  | -
Spreadsheet: 683956d1593070832-calculate-matches-on-rows-of-data-match-total-data
Sheet: Sheet1

ID | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | 2020-06-06 00:00:00 | 2020-06-07 00:00:00 | 2020-06-08 00:00:00 | 2020-06-09 00:00:00 | 2020-06-10 00:00:00
ABC123 | 0 | 1 | 0
DEF123 | 1 | 0 | 0
GHI123 | 1 | 1 | 0
JKL123 | 0 | 0 | 1
MNO123 | 1 | 1 | 0
 | Match Total | 3 | 1
 | Don't Match Total | 2 | 4
 | I need C8 to count in total how many matched between 01/06 & 02/06
 | I need C9 to count how many in total matched between 01/06 & 02/06
 | I need D8 to count how many matched between 02/06 & 03/06
 | I need D9 to count how many matched between 02/06 & 03/06
Spreadsheet: 680192d1590851822-excel-how-to-check-a-specific-text-in-multiple-column-cells-and-return-a-text-excel_file_expt_may20
Sheet: Sheet1

FP | FP Status | FV | FV Status | LP | [NAME] | DB | [NAME] | Status Check | Remarks
2018-07-12 00:00:00 | [NAME] | 2019-01-31 00:00:00 | [NAME] | 2022-01-17 17:00:00 | Open | 2022-02-28 17:00:00 | Open
 | Terminated |  | Terminated |  | Terminated |  | Terminated |  | Cell "I3" should be Blank
2020-01-22 17:00:00 | Completed | 2020-05-26 08:00:00 | Open | 2022-12-30 17:00:00 | Open | 2023-02-28 17:00:00 | Open
2020-02-18 17:00:00 | [NAME] | 2020-03-30 08:00:00 | Open | 2022-12-05 17:00:00 | Open | 2023-02-13 17:00:00 | Open
2015-06-16 00:00:00 | Terminated | 2015-11-16 17:00:00 | Terminated | 2018-07-10 00:00:00 | Terminated | 2018-08-20 17:00:00 | Terminated |  | Cell "I6" should be Blank
2010-08-06 00:00:00 | Completed | 2010-10-06 00:00:00 | Completed | 2013-07-03 00:00:00 | Completed | 2013-11-26 00:00:00 | Completed |  | This is Correct!
Spreadsheet: 641234ac-bb10-467d-a685-ca5cb9f8f57e
Sheet: Capital fiscal

CAPITAL PROJECT |  |  |  |  |  |  | 120371
Ordinance Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
Contract No. 1056 - Blue River WWTP Effluent Disinfection, Section II;
 |  |  |  |  | Design Professional Services
Is this ordinance for the following: |  |  |  | X | New Construction
 |  |  |  | X | Replacement
 |  |  |  |  | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  |  | No |  | X | Yes
 |  |  |  |  |  |  | FY12
 | If no, please detail the reasons why this project was not included and need for present funding request.
Please identify source of funds below.
 | Non-City source and amount.
 | Source of Funds:
 | Fiscal Year Funded
 | Amount of Non-City Funds: |  |  | $
 | City source and amount.
 | Acct #: |  |  |  | 8185-808084-B-611060
 | Name of Fund: |  |  |  | Water & Sewer CD4
 | Fiscal Year Funded |  |  |  | AL
 | Amount of City Funds: |  |  | $ | 27429747
If ordinance is for new construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction): |  |  | $ | 50500000
 | Estimated lifespan of project in years |  |  |  | 35
 | Estimated annual operating and maintenance costs |  |  | $ | 1000000
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please please provide source of funds. |  |  |  | 8110-802140
 | If no, please identify year in which additional operating and maintenance costs will be needed.
Reference Numbers: (Previously approved legislation): |  |  |  |  |  |  |  | N/A |  |  | N/A
Reviewed by:
 |  |  |  |  |  | OMB Approval Date
 |  |  |  |  |  |  |  | 5251000
Spreadsheet: 833016d1686734170-get-rightmost-non-date-or-text-value-in-a-row-book1
Sheet: Sheet1

ITEM | POS | BASETKH | BASEDATE | THICKNESS | DATE | THICKNESS | DATE | THICKNESS | DATE
 |  |  |  |  | 2036-11-21 00:00:00 | 5.3 | 2036-11-24 00:00:00 | 5.1 | 2036-11-27 00:00:00
 |  |  |  | 8.1 | 2036-11-22 00:00:00 | 8.2 | 2036-11-25 00:00:00 | N | 2036-11-28 00:00:00
 |  |  |  | 7.1 | 2036-11-23 00:00:00 | 7.4 | 2036-11-26 00:00:00 | 7.6 | 2036-11-29 00:00:00
 |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
Spreadsheet: 140b2203-c941-4d34-8646-1276dbe3ce68
Sheet: Sheet1

MILEAGE LOG | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
Employee Name: |  |  |  |  | Employee Vandal Number:
For Time Period: |  |  |  | TRIP #
 | MILEAGE |  |  |  |  |  |  |  | PER DIEM
Date | Destination | Starting Destination Odometer | Ending Destination Odometer | Total Destination miles | Starting Vicinity Odometer | Ending Vicinity Odometer | Total [NAME] | Total Mileage | Depart Date | Depart Time | Return Date | Return Time | Per Diem Amount
I certify that the Per Diem listed above is necessary and directly related to the conduct of University business and therefore is not considered taxable income
Original Traveler Signature
Spreadsheet: 708312d1607715971-convert-multiple-columns-to-multiple-rows-sample_columns-to-rows
Sheet: Sheet4

EE Name | tin | tout
[NAME] | 12/08/2020 08:00:00 | 12/08/2020 17:00:00 |  |  | Need to change this format to the one below.
[NAME] | 12/09/2020 08:00:00 | 12/09/2020 17:00:00
EE Name | Local Time | Type
[NAME] | 12/08/2020 08:00:00 | tin
[NAME] | 12/08/2020 17:00:00 | tout
[NAME] | 12/09/2020 08:00:00 | tin
[NAME] | 12/09/2020 17:00:00 | tout
Spreadsheet: 732088d1620763585-help-a-journalist-with-an-excel-puzzle-excelforumproblem_05112021-etaf
Sheet: Sheet1

case_num | locn_descr | case type descr | filing_date | Judgment Entered | jdmt_date | bar_num | Date Writ is Issued | title
040402280 | Provo District | Debt Collection | 2004-07-09 00:00:00 | Yes | 2004-12-14 00:00:00 | 3640 | 2019-02-11 00:00:00 | Writ of Continuing Garnishment
040402280 | Provo District | Debt Collection | 2004-07-09 00:00:00 | Yes | 2004-12-14 00:00:00 | 14052 | 2019-02-11 00:00:00 | Writ of Continuing Garnishment
040402280 | Provo District | Debt Collection | 2004-07-09 00:00:00 | Yes | 2004-12-14 00:00:00 | 3640 | 2019-02-27 00:00:00 | Writ of Continuing Garnishment
040402280 | Provo District | Debt Collection | 2004-07-09 00:00:00 | Yes | 2004-12-14 00:00:00 | 14052 | 2019-02-27 00:00:00 | Writ of Continuing Garnishment
Spreadsheet: 866528d1713455411-pull-values-from-data-sheet-into-check-sheet-based-on-serial-no-doc1
Sheet: Check

Reg 1 |  |  |  |  | Reg 2
Serial No | 1114 | Serial No | 1119 |  | Serial No | 1112 | Serial No | 1120
Margin result |  | Margin result |  |  | Margin result |  | Margin result
Reg 3 |  |  |  |  | Reg 4
Serial No | 1113 | Serial No | 1115 |  | Serial No | 1122 | Serial No | 1118
Margin result |  | Margin result |  |  | Margin result |  | Margin result
Reg 5 |  |  |  |  | Reg 6
Serial No | 1116 | Serial No | 1123 |  | Serial No | 1117 | Serial No | 1121
Margin result |  | Margin result |  |  | Margin result |  | Margin result