tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 64582d1265390419-advanced-filtering-sorting-excelhelptemplate
Sheet: Sheet2

VENDOR # | VENDOR_NAME | ADDRESS_LINE1 | [NAME] | [NAME] | CITY | STATE | ZIP | VENDOR_SITE_CODE | CHECK_DATE
123 | CIRCUS ANIMALS CO | 123 ABC |  |  | ALBANY | NY | 12345 | ALBANY | 2007-07-13 00:00:00
123 | CIRCUS ANIMALS CO | ATTN MARGE | 234 CDE |  | ALBANY | NY | 12345 | BOISE | 2007-07-13 00:00:00
132 | CIRCUS ANIMALS CO | 345 EFG |  |  | ALBANY | NY | 12345 | PO AV | 2007-07-13 00:00:00
123 | CIRCUS ANIMALS CO | 1020 APPLE |  |  | ALBANY | NY | 12345 | MAIN | 2007-07-13 00:00:00
123 | CIRCUS ANIMALS CO | PO BOX 8382 |  |  | ALBANY | NY | 12345 | CATERING | 2007-07-03 00:00:00
123 | CIRCUS ANIMALS CO | PO BOX 1123 |  |  | ALBANY | NY | 12345 | ATLANTA, GA | 2007-07-03 00:00:00
123 | CIRCUS ANIMALS CO | ATTN [NAME] | 9285 SUNBEAM | MS 33 | ALBANY | NY | 12345 | ACCTS PAY | 2007-07-03 00:00:00
123 | CIRCUS ANIMALS CO | 3893 RIGHT ST |  |  | ALBANY | NY | 12345 | REMIT | 2007-07-03 00:00:00
205 | SNAKES INC | 9837 LEFT ST |  |  | ALBANY | NY | 13245 | NEW YORK | 2007-02-15 00:00:00
205 | SNAKES INC | ATTN SUSAN |  |  | ALBANY | NY | 12345 | BATON ROUGE | 2007-02-15 00:00:00
205 | SNAKES INC | ATTN JAKE |  |  | ALBANY | NY | 12345 | PO AV | 2007-02-15 00:00:00
205 | SNAKES INC | 222 ST |  |  | ALBANY | NY | 12345 | REMIT | 2007-02-15 00:00:00
205 | SNAKES INC | 193 MAPLE |  |  | ALBANY | NY | 12345 | CHARITABLE ORG | 2007-02-15 00:00:00
205 | SNAKES INC | 22901 WAKE FOREST |  |  | ALBANY | NY | 12345 | TRAINING | 2007-02-15 00:00:00
205 | SNAKES INC | 873 BLUBERRY |  |  | ALBANY | NY | 12345 | FINANCE | 2008-08-12 00:00:00
205 | SNAKES INC | ATTN SHARON | 9928 BAXTER |  | ALBANY | NY | 12345 | UNCLAIMED | 2008-08-28 00:00:00
205 | SNAKES INC | ATTN [NAME] |  |  | ALBANY | NY | 13245 | INACTIVE | 2008-08-28 00:00:00
151 | WIDGETS R US | ATTN KATIE |  |  | ALBANY | NY | 12345 | MAUCKER UNION | 2007-02-15 00:00:00
151 | WIDGETS R US | ATTN BETHEL |  |  | ALBANY | NY | 12345 | DINING | 2007-02-15 00:00:00
151 | WIDGETS R US | ATTN BEATRICE |  |  | ALBANY | NY | 12345 | EXEC DEV CTR | 2007-07-03 00:00:00
151 | WIDGETS R US | ATTN MOZART |  |  | ALBANY | NY | 12345 | BUSINESS OFFICE | 2007-02-15 00:00:00
151 | WIDGETS R US | ATTN IGGY |  |  | ALBANY | NY | 12345 | MAIN | 2008-08-28 00:00:00
151 | WIDGETS R US | ATTN VAN GOGH |  |  | ALBANY | NY | 12345 | WORKSHOP | 2007-02-15 00:00:00
Spreadsheet: 167531d1342019192-finding-the-closest-match-between-two-columns-within-a-given-range-7912test30min
Sheet: Sheet1

Board 6150 | Board 6171 | Board 6171 match  to 6150
[PHONE].18613148900160 | [PHONE].56167449338016
[PHONE].57754462032224 | [PHONE].16561132489344
[PHONE].37778302227040 | [PHONE].50406403245472
[PHONE].40167321334176 | [PHONE].93034744274368
[PHONE].21464171709632 | [PHONE].82916663328928
[PHONE].23478187826112 | [PHONE].45665365322080
[PHONE].38022304173920 | [PHONE].26621212971616
[PHONE].[PHONE] | [PHONE].80852646816128
[PHONE].36363290900256 | [PHONE].[PHONE]
[PHONE].48863390904384 | [PHONE].39766318127072
[PHONE].87516700129792 | [PHONE].18613148900128
[PHONE].60062480497568 | [PHONE].57754462032096
[PHONE].[PHONE] | [PHONE].37778302226944
[PHONE].94028752225408 | [PHONE].40167321334048
[PHONE].79273634182080 | [PHONE].21464171709504
[PHONE].76263610101472 | [PHONE].23478187826016
[PHONE].[PHONE] | [PHONE].[PHONE]
[PHONE].[PHONE] | [PHONE].62762502092576
[PHONE].17452139617536 | [PHONE].36363290900224
[PHONE].88976711804672 | [PHONE].48863390904352
[PHONE].71043568347200 | [PHONE].54191433528800
[PHONE].19018152141664 | [PHONE].20816166528192
[PHONE].29265234119968 | [PHONE].76263610101408
[PHONE].58989471913856 | [PHONE].[PHONE]
[PHONE].15694125552704 | [PHONE].[PHONE]
[PHONE].13055104436640 | [PHONE].44729357833600
[PHONE].[PHONE] | [PHONE].35581284647360
[PHONE].69632557052192 | [PHONE].81372650976864
[PHONE].90422723377216 | [PHONE].17452139617472
[PHONE].88184705472544 | [PHONE].29265234119968
[PHONE].[PHONE] | [PHONE].32924263389824
[PHONE].[PHONE] | [PHONE].80119640950496
[PHONE].78842630734048 | [PHONE].35134281074944
[PHONE].[PHONE] | [PHONE].63595508757696
[PHONE].[PHONE] | [PHONE].[PHONE]
[PHONE].34821278571296 | [PHONE].[PHONE]
[PHONE].74839598708800 | [PHONE].[PHONE]
[PHONE].[PHONE] | [PHONE].62739501915456
[PHONE].65455523639872 | [PHONE].[PHONE]
[PHONE].86577692613440 | [PHONE].73064584511488
[PHONE].[PHONE] | [PHONE].74839598708704
[PHONE].97497779978048 | [PHONE].73446587570784
[PHONE].[PHONE] | [PHONE].[PHONE]
 | [PHONE].65455523639744
 | [PHONE].[PHONE]
 | [PHONE].60443483541184
 | #[NAME]!
 | #[NAME]!
Spreadsheet: 126516d1319729405-countifs-2003-impossible-to-convert-sumproduct-example
Sheet: Sheet1

 |  |  |  |  | AccountName 1 | AccountName 2 | AccountName 3 | AccountName 4 | AccountName 5 | AccountName 6 | AccountName 7 | AccountName 8 | AccountName 9 | AccountName 10
 | Start Date | 2011-07-01 00:00:00 |  | Complaint 1 | 2 | 1 | 0 | 0 | 1 | 2 | 1 | 1 | 0 | 1
 | End Date | 2011-07-31 00:00:00 |  | Complaint 2 | 1 | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0
 |  |  |  | Complaint 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Complaint 4 | 3 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 1
 |  |  |  | Complaint 5 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1
 |  |  |  | Complaint 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Complaint 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Complaint 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Complaint 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Complaint 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 62019d1262911973-excel-2007-range-selection-in-multiple-worksheets-formrexcel-2
Sheet: TAB1

 |  | TAB1 |  |  |  | Date | 2010-01-07 00:00:00 | [NAME] fields Auto Complete
 |  | Ref (Auto) | Priority (Auto) | Status (Auto) | [NAME] | Action Title | Brief Description and Benefit | Success Criteria | Impact |  | Impact Justification | Difficulty |  | Total Score | Difficulty Justification | Owner | Sub-Actions | Initial Planned Completion Date | Forecast Completion Date | Days Late | Actual Completion Date |  | ROM Cost (if more than just FTE hours) | Breakdown of Cost (if applicable) | Summary of Updates (create in Notepad and copy in to achieve carriage returns)
 | 2 | TAB1 2 | High | Completed 4 Days Ago | Complete | 2 | dsfgdsfg | ertwertcert | High | 3 | 34c3 | Moderate | 2 | 5 |  | fred | sdfsdf | 2010-01-01 00:00:00 | 2010-01-01 00:00:00 | 6 | 2010-01-03 00:00:00 | 4
 | 3 | TAB1 3 | Medium | On Target for -113 days | On Target | 3 | dfgdfg | ct44 | Medium | 2 | 234t3 | Moderate | 2 | 4 |  | [NAME] | sdfsdf | 2010-04-30 00:00:00 | 2010-04-30 00:00:00 | -113
 | 4 | TAB1 4 | Low | On Target for -259 days | On Target | 4 | dfgdfg | 2t3c | Low | 1 | 4t2334 | Moderate | 2 | 3 |  | [NAME] | sdfsdf | 2010-09-23 00:00:00 | 2010-09-23 00:00:00 | -259
 | 5 | TAB1 5 | Medium | Off Target by 6 days | Off Target | 5 | dfgdfg | 324t34 | High | 3 | 234t3 | Difficult | 1 | 4 |  | pete | reerre | 2010-01-01 00:00:00 | 2010-01-01 00:00:00 | 6
 | 6 | TAB1 6 | Medium | On Target for -113 days | On Target | 6 | dfgdfg | 34t34 | Low | 1 | 234t3 | Easy | 3 | 4 |  | [NAME] | rrrtg | 2010-04-30 00:00:00 | 2010-04-30 00:00:00 | -113
Spreadsheet: 269624d1381234953-index-and-match-help-production-100713
Sheet:   6-5# BUTTER  

 | 6/5# butter
Order # | Item # | CUSTOMER | TYPE | COUNT | POUNDS | Production Date | Lot # | Request | [NAME]
 |  |  |  |  |  |  |  | Date
95378 | 209881 | Central | 6/5#reg | 1232 | grade A | done | 269/3/269b | 2013-08-12 00:00:00
95379 | 209881 | Central | 6/5#reg | 1232 | grade A | ??? |  | 2013-11-11 00:00:00
floor | 209881 | gov butter | 6/5#reg | 1288 | grade A | ???
97007 | 209881 | [NAME] | 6/5#reg | 14 |  | done | 246/3/246b | 2013-10-01 00:00:00
97313 | 209881 | [NAME] | 6/5#reg | 14 |  | done | 254/3/254b | 2013-10-08 00:00:00
97325 | 209881 | Northampton | 6/5#reg | 96 |  | done | 254/3/254b | 2013-10-04 00:00:00
97383 | 209881 | Valley | 6/5#reg | 6 |  | done | 248/3/248b | 2013-10-11 00:00:00
97460 | 209881 | [NAME] | 6/5#reg | 35 |  | done | 248/3/248b | 2013-10-15 00:00:00
Spreadsheet: 669399d1585338816-how-to-distribute-data-to-multiple-tabs-in-the-sane-workbook-template
Sheet: Raw Water

 |  | 2020-01-28 00:00:00
 | Chloride as Cl | 6.7
 | Phosphate Ortho- as PO₄ | <0.2
 | Phosphate Filtered Ortho- as PO₄ | <0.2
 | STP Threshold | <2.0
 | Specific Conductance at 25°C | 157
 | pH | 6.7
 | Alkalinity "P" as [NAME] | <2
 | Alkalinity "M"as CaCO₃ | 42
 | Silver as Ag | <0.005
 | Aluminum Total as Al | 0.68
 | Arsenic Total as As | <0.01
 | [NAME] as B | <0.02
 | Barium Total as Ba | 0.028
 | Barium Hardness as CaCO₃ | 0.02
 | Beryllium as Be | <0.005
 | Calcium Total as Ca | 14.5
 | Calcium Hardness Total as CaCO₃ | 36.4
 | Cadmium as Cd | <0.005
 | Cobalt Total as Co | <0.01
 | Chromium Total as Cr | <0.01
 | Chromium Total as CrO₄ | <0.02
 | Copper Total as Cu | <0.01
 | Iron Total as Fe | 0.86
 | Hardness Total as CaCO₃ | 60
 | Potassium as K | 1.6
 | Lithium as Li | 0.003
 | Magnesium Total as Mg | 5.65
 | Magnesium Hardness Total as CaCO₃ | 23.3
 | Manganese Total as Mn | 0.042
 | Molybdenum as Mo | <0.01
 | Molybdenum as MoO₄ | <0.02
 | Sodium as Na | 6.4
 | Nickel Total as Ni | <0.005
 | Phosphorus total as P | <0.05
 | Phosphorus Total as PO4 | <0.15
 | Lead Total as Pb | <0.01
 | Sulfur total as S | 8.8
 | Sulfur Total as SO₄ | 26.5
 | Antimony as Sb | <0.02
 | Selenium Total as Se | <0.02
 | Silicon total as Si | 3.26
 | Silica Total as SiO₂ | 6.98
 | Tin Total as Sn | <0.01
 | Strontium Total as Sr | 0.11
 | Strontium Hardness | 0.13
 | Titanium Total as Ti | 0.012
 | Thallium Total as Tl | <0.01
 | Vanadium Total as V | <0.005
 | Zinc Total as Zn | <0.005
 | Zirconium Total as Zr | <0.005
 | Benzotriazole | <0.1
 | [NAME] | <0.1
 | Tolytriazole | <0.1
 | Copper Filtered as Cu | <0.01
 | Iron Filtered as Fe | 0.05
 | TP Filtered as PO₄ | <0.15
 | Solids Total Dissolved at 105°C | 112
 | Phosphate Total Inorganic as PO₄ | <0.2
 | PhosphateFiltered Total Inorganicas PO₄ | <0.2
 | Solids Total Suspended | 700
 | Turbidity NTU | 9.2
Spreadsheet: 134721d1325601711-vlookup-several-columns-then-total-a-different-column-dropships
Sheet: Summary

Cust A
 | Jan'11 | Jan'12 | Feb'11 | Feb'12 | Mar'11 | Mar'12 | Apr'11 | Apr'12 | May'11 | May'12 | Jun'11 | Jun'12 | Jul'11 | Jul'12 | Aug'11 | Aug'12 | Sep'11 | Sep'12 | Oct'11 | Oct'12 | Nov'11 | Nov'12 | Dec'11 | Dec'12
Number of Parts
Customers Cost
Cust B
 | Jan'11 | Jan'12 | Feb'11 | Feb'12 | Mar'11 | Mar'12 | Apr'11 | Apr'12 | May'11 | May'12 | Jun'11 | Jun'12 | Jul'11 | Jul'12 | Aug'11 | Aug'12 | Sep'11 | Sep'12 | Oct'11 | Oct'12 | Nov'11 | Nov'12 | Dec'11 | Dec'12
Number of Parts
Customers Cost
Cust C
 | Jan'11 | Jan'12 | Feb'11 | Feb'12 | Mar'11 | Mar'12 | Apr'11 | Apr'12 | May'11 | May'12 | Jun'11 | Jun'12 | Jul'11 | Jul'12 | Aug'11 | Aug'12 | Sep'11 | Sep'12 | Oct'11 | Oct'12 | Nov'11 | Nov'12 | Dec'11 | Dec'12
Number of Parts
Customers Cost
Cust D
 | Jan'11 | Jan'12 | Feb'11 | Feb'12 | Mar'11 | Mar'12 | Apr'11 | Apr'12 | May'11 | May'12 | Jun'11 | Jun'12 | Jul'11 | Jul'12 | Aug'11 | Aug'12 | Sep'11 | Sep'12 | Oct'11 | Oct'12 | Nov'11 | Nov'12 | Dec'11 | Dec'12
Number of Parts
Customers Cost
Spreadsheet: 675478d1588321081-sum-if-calculation-book1-1-
Sheet: Sheet1

 | Total | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00
Row 0 | 1167.66 | 107.84 | 104.31 | 110.93 | 92.03 | 87.38 | 77.92 | 77.26 | 82.87 | 86.72 | 96.98 | 115.09 | 128.33
Row 00 | 64.31 | 5.71 | 5.73 | 6.4 | 5.23 | 4.93 | 4.26 | 4.19 | 4.52 | 4.7 | 5.25 | 6.52 | 6.87
Row 1 | 1757.95 | 143.23 | 148 | 144.74 | 149.57 | 149.57 | 144.74 | 149.57 | 144.74 | 149.57 | 149.57 | 135.09 | 149.57
Row 2 | -1790.63 | -55.82 | -48.51 | -182.97 | -256.28 | -236.03 | -122.9 | -50.12 | -52.15 | -97.04 | -245.57 | -299.51 | -143.72
Row 3 | -236.01 | -21.75 | -21.08 | -22.48 | -18.63 | -17.68 | -15.74 | -15.6 | -16.74 | -17.51 | -19.58 | -23.3 | -25.9
Row 4 | -4086.82 | -377.44 | -365.1 | -388.25 | -322.12 | -305.84 | -272.71 | -270.41 | -290.04 | -303.53 | -339.42 | -402.81 | -449.14
Row 5 | -8410.75 | -690.73 | -713.76 | -691.41 | -714.45 | -714.45 | -691.41 | -714.45 | -691.41 | -714.45 | -714.45 | -645.31 | -714.45
Row 6 | -21.66 | -1.8 | -1.82 | -1.8 | -1.82 | -1.82 | -1.8 | -1.82 | -1.8 | -1.82 | -1.82 | -1.75 | -1.82
Row 7 | -2107.65 | -174.79 | -167.49 | -194.98 | -183.74 | -167.75 | -134.64 | -121.72 | -127.73 | -145.45 | -208.86 | -259.16 | -221.33
Row 8 | -36461.99 | -3240.21 | -3013.79 | -3197.45 | -2951.99 | -2726.51 | -2330.14 | -2202.8 | -2298.33 | -2599.27 | -3627.49 | -4279.53 | -3994.48
Row 9 | 495.35 | 31.21 | 28.17 | 40.69 | 44.29 | 34.02 | 31.14 | 27.65 | 28.22 | 30.11 | 67.06 | 73.25 | 59.55
Row 10 | -342.93 | -26.46 | -28.37 | -31.59 | -25.72 | -22.55 | -27.07 | -25.1 | -25.33 | -24.59 | -33.92 | -38.37 | -33.84
Row 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Row 12 | -143.23 | -13.23 | -12.8 | -13.61 | -11.29 | -10.72 | -9.56 | -9.48 | -10.17 | -10.64 | -11.9 | -14.12 | -15.74
Row 13 | -602.3 | -50.52 | -48.87 | -51.97 | -43.12 | -40.94 | -36.5 | -36.2 | -38.82 | -40.63 | -61.17 | -72.6 | -80.95
Row 14 | 55230.44 | 5100.89 | 4934.08 | 5246.88 | 4353.24 | 4133.26 | 3685.42 | 3654.4 | 3919.74 | 4101.98 | 4587.04 | 5443.67 | 6069.83
Row 15 | -700.6 | -64.7 | -62.59 | -66.56 | -55.22 | -52.43 | -46.75 | -46.36 | -49.72 | -52.03 | -58.19 | -69.05 | -77
Row 16 | -124.88 | -4.33 | -9.2 | -18.07 | -46.22 | -33.58 | -25.83 | 0.98 | 2.3 | 7.41 | 4.35 | 0.71 | -3.39
Row 17 | -727.48 | -67.05 | -64.98 | -69.28 | -57.44 | -54.51 | -48.53 | -48.09 | -51.6 | -53.99 | -60.36 | -71.81 | -79.83
Row 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total | 1726.81 | 486.5 | 551.89 | 501.89 | -140.94 | -67.96 | 97.72 | 290.45 | 441.16 | 228.12 | -574.71 | -524.6 | 437.36
 | 2020-05-01 00:00:00
Spreadsheet: 163182d1340214325-using-a-formula-to-link-a-number-1-through-5-to-multiple-text-choices-book1
Sheet: Sheet1

Cities | Categories
 | Cars | Train | Boat | House | Business | Factory | Store | Church | Choice9 | Choice10 | Choice11 | Choice12 | Choice13 | Choice14 | Choice15 | Choice16 | Choice17
New York | 5 |  |  |  | 2 |  |  |  | 1 |  |  | 4 |  | 3
Chicago |  |  |  |  |  |  |  |  | 5 | 4 | 3 | 2 | 1
City 50 | 1 | 2 | 3 | 5 | 4
City 43 |  |  |  |  | 1 |  | 5 |  |  | 4 |  | 2 | 3
City8 | 1 |  |  | 5 |  |  |  | 3 |  |  |  | 2 |  |  |  | 4
 | Cars | Train | Boat | House | Business | Factory | Store | Church | Choice9 | Choice10 | Choice11 | Choice12 | Choice13 | Choice14 | Choice15 | Choice16 | Choice17
Adams
Chicago
Detroit
Kirkwood
New York
[NAME]
City7
City8
City9
City10
City11
City12
City13
City14
City15
City16
City17
City18
City19
City20
City21
City22
City23
City24
City25
City26
City27
City28
City29
City30
City31
City32
City33
City34
City35
City36
City37
City38
City39
City40
City41
City42
City43
City44
City45
[NAME]
City47
City48
City49
City50
City51
City52
City53
City54
City55
City56
City57
City58
City59
City60
Cities
Spreadsheet: 9c81a5c0-af48-458d-b86a-70b14d0859c9
Sheet: Page 1

Permit No.: |  |  | WQ0005247 |  |  | Facility Name: |  | Rollingview State Recreation Area |  |  |  |  |  | County: | Durham |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | LLS |  | Field Name: |  | UPR |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 3.55 |  | Area (acres): |  | 3.55 |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.2 |  | [NAME] (in): |  | 0.2 |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 31.2 |  | Annual Rate (in): |  | 31.2 |  | 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: darrell_schoolcraft__7761__imbalsumm0106
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 372408 | 395000 | 54996 | 51737 | 77854 | 40670 | 76796 | 95022
2 | 371402 | 400000 | 51789 | 50166 | 82226 | 75758 | 63005 | 67484
3 | 374673 | 377553 | 45902 | 49510 | 79928 | 75857 | 63323 | 63651
4 | 391192 | 400000 | 74587 | 76673 | 73280 | 73080 | 120589 | 107762
5 | 383958 | 398502 | 56652 | 51016 | 75483 | 70290 | 93011 | 84699
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
2001-05-31 00:00:00 |  |  |  |  |  |  |  |  | 278782
2001-06-05 00:00:00
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
Spreadsheet: 144698d1331106747-highlighting-a-row-with-the-current-date-book2
Sheet: Sheet1

 |  | 2011-04-04 00:00:00
2011-04-01 00:00:00 | 2011-04-02 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 2011-04-05 00:00:00 | 2011-04-05 00:00:00 | 2011-04-05 00:00:00 | 2011-04-06 00:00:00 | 2011-04-06 00:00:00 | 2011-04-06 00:00:00 | 2011-04-06 00:00:00 | 2011-04-06 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00
Spreadsheet: 38293d1236384021-lookup-formula-example32
Sheet: Cat

KITTEN | Rank |  | name | rank | sort ascending | sort ascending
Furry | 1 |  | Furry | 1 | sort descending
Spaz | 3 |  | Fuzzy | 2
Fuzzy | 2 |  | Spaz | 3
Dopey | 5 |  | [NAME] | 4
[NAME] | 4 |  | Dopey | 5
Spreadsheet: 36650d1234520711-excel-order-form-671805
Sheet: Sheet2

Description | PRODUCT CODE | Inventory |  | Description | PRODUCT CODE | Inventory
SPRAY GLUE (BOXES) |  | 2 |  | ARGENTINA (SHEETS) |  | 1000
DHL SECURITY TAPE (BOXES) |  | 25 |  | BELIZE (SHEETS) |  | 1000
DHL INTEL SECURITY RED TAPE (BOXES) |  | 5 |  | [NAME] (SHEETS) |  | 1000
DHL INTEL SECURITY BLUE TAPE (BOXES) |  | 5 |  | BRAZIL (SHEETS) |  | 1000
DHL INTEL SECURITY GREEN TAPE (BOXES) |  | 5 |  | CHILE (SHEETS) |  | 1000
2" CLEAR TAPE (BOXES) |  | 25 |  | COLOMBIA (SHEETS) |  | 1000
1/2" METAL STRAPS (ROLLS) |  | 10 |  | ECUDOR (SHEETS) |  | 1000
1/2" PLASTIC STRAPS (ROLLS) |  | 5 |  | HONDURAS (SHEETS) |  | 1000
STEEL STRAP CLIPS (BOXES) |  | 3 |  | JAMAICA (SHEETS) |  | 1000
PLASTIC STRAP CLIPS (BOXES) |  | 3 |  | MEXICO (SHEETS) |  | 1000
MACHINE SHRINK WRAP CLEAR (SKIDS) |  | 2 |  | PANAMA (SHEETS) |  | 1000
MACHINE SHRINK WRAP BLACK (SKIDS) |  | 1 |  | PARAGUAY (SHEETS) |  | 1000
18" BLACK SHRINK WRAP (BOXES) |  | 10 |  | [NAME] (SHEETS) |  | 1000
18" CLEAR SHRINK WRAP (BOXES) |  | 25 |  | PUERTO RICO (SHEETS) |  | 1000
D-CONTAINERS |  | 100 |  | DOMINICAN REPULIC (SHEETS) |  | 1000
D-CONTAINER S W/PALLET |  | 0 |  | TRINIDAD (SHEETS) |  | 1000
D-CONTAINER PALLETS |  | 0
E-CONTAINERS (SINGLE UNITS) |  | 100
EH-CONTAINERS (SINGLE UNITS) |  | 100
CTNS - 24 X 24 X 24 (SINGLE UNITS) |  | 100
STAPLES - C 3/4 20mm 16025033 |  | 0
DC8 PALLET COVER CLEAR (ROLLS) |  | 30
747 PALLET COVER CLEAR (ROLLS) |  | 25
ROPE (BOXES) |  | 5
CARDBOARD SLIP SHEETS |  | 2
EDGE PROTECTOR (CORNER) (SKIDS) |  | 2
[NAME] (REGULAR) ROLLS |  | 15
BUBBLE WRAP |  | 25
PLASTIC PALLETS |  | 200
PALLETS (48 X 40) |  | 200
PALLETS (24 X 24) |  | 0
PALLETS (48 X 24) |  | 0
FUMIGATED PALLETS |  | 100
CONTAINER [NAME] (YELLOW) |  | 1
TOPP CLIPS |  | 1
ABSORBING POWDER (BOXES) |  | 2
THERMAL LABELS (BOXES) |  | 5
THERMAL LABEL INK ROLLS (TINTA) |  | 5
[NAME] (CARDINAL) |  | 0
TRANSFER MANIFEST |  | 2
[NAME] |  | 2
Spreadsheet: 267693d1380138808-remove-duplicates-help-25-09-2013_excelforum_removing_duplicates-ok
Sheet: NEW REPORT

Batch # | Document # | Amount | Debit | Credit
AUX | 1111 | 800 | 0 | 250
AUX | 1111 | 800 | 0 | 550
AUX | 2222 | 400 | 250 | 0
AUX | 2222 | 400 | 150 | 0
AUX | 2222 | 400 | 0 | 400
AUX | 2222 | 400 | 250 | 0
AUX | 3333 | 1000 | 300 | 0
AUX | 3333 | 1000 | 200 | 0
AUX | 3333 | 1000 | 0 | 1000
AUX | 3333 | 1000 | 500 | 0
Spreadsheet: 839297d1691798291-modify-formulas-to-calculate-overtime-when-40hrs-are-not-worked-time-card-sample2-longbow-44-
Sheet: Sheet1

 | Day | Holiday | Stat | Start | End | Total Hrs Wrkd | REG | TAH | DT | E/A |  | Day | Holiday | Stat | Start | End | Total Hrs Wrkd | REG | TAH | DT | E/A
 | Sun |  |  | 08:00:00 | 20:00:00 |  |  |  |  |  |  | Sun |  |  | 08:00:00 | 20:00:00
 | Mon |  |  | 08:00:00 | 18:00:00 |  |  |  |  |  |  | Mon |  |  | 08:00:00 | 18:00:00
 | Tue |  |  | 08:00:00 | 12:00:00 |  |  |  |  | y |  | Tue |  |  | 08:00:00 | 12:00:00 |  |  |  |  | y
 | Wed | y |  | holidays |  |  |  |  |  |  |  | Wed | y |  | holidays
 | Thu |  |  | 08:00:00 | 16:00:00 |  |  |  |  |  |  | Thu |  |  | 08:00:00 | 16:00:00
 | Fri |  |  | 08:00:00 | 16:00:00 |  |  |  |  |  |  | Fri |  |  | 08:00:00 | 16:00:00
 | Sat |  |  | 08:00:00 | 16:00:00 |  |  |  |  |  |  | Sat |  |  | 08:00:00 | 16:00:00
 | Total |  |  |  |  |  |  |  |  |  |  | Total