tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darron_c_giron__8010__EMW0831a
Sheet: TP-EMWNSS

 | TP-EMWNSS - FINANCIAL
 | Financial Values
 | Price Positions
 | New Price Positions
 | Basis Positions
 | Index Positions
 | Gas Daily Swaps |  | 0
 | Price Option |  | 0
 | Basis Option |  | 0
 | Gas Daily Option |  | 0
 | [NAME] in the previous month
 | Price Positions |  | -575019
 | Basis Positions |  | 0
 | Index Positions |  | 0
 | Gas Daily Swaps |  | 0
 | Price Option |  | 0
 | Basis Option |  | 0
 | Gas Daily Option |  | 0
31
 | Price Positions |  | -3902
 | Basis Positions |  | 0
 | Index Positions |  | 0
 | Gas Daily Swaps |  | 0
 | Price Option |  | 0
 | Basis Option |  | 0
 | Gas Daily Option |  | 0
33
 | Price Positions
 | Basis Positions
 | Index Positions
 | Gas Daily Swaps
 | Price Option
 | Basis Option
 | Gas Daily Option
30
Spreadsheet: 29168d1224008468-how-to-use-sumif-forumula-in-this-condition-aaa
Sheet: Sheet1

[NAME] | Tiff | Emp ID | Date | Status | Process | Status | I want to use sumif formula with criteria   E,F, when I type in E, "done" and F "Vh" than some the B Data
289 | 36 | E1166 | 2008-10-14 00:00:00 | [NAME] | vh | Done | when field E5 done and F5 vh so sum B colum data
290 | 48 | E1166 | 2008-10-14 00:00:00 | wip | vh | Done
291 | 46 | E1166 | 2008-10-14 00:00:00 | wip | vh | Done
Spreadsheet: 78411d1278758601-date-files-copy-of-sample-1
Sheet: Sheet1

A | 719 | COMPAfl | ROSIQUE | ANTONIO FERNANDO | HOMBRE | 1961-03-27 00:00:00 | 3 | 27 | 21.425.151 F | 22 | 0 | 13
A | 717 | CARRIO | GARRIGUES | DESAMPARADOS | MUJER | 1956-04-02 00:00:00 | 4 | 2 | 20767796S | 32 | 9 | 13
A | 718 | CASTRO | MOLINA | [NAME] | MUJER | 1960-04-22 00:00:00 | 4 | 22 | 21441108W | 26 | 10 | 13
A | 722 | DE LOS SANTOS | TEJERO | MARIA TERESA | MUJER | 1959-05-24 00:00:00 | 5 | 24 | 30449411X | 27 | 11 | 13
A | 720 | CORDERO | FORT | ALBERTO | HOMBRE | 1977-06-05 00:00:00 | 6 | 5 | 48344094A | 2 | 10 | 13
A | 721 | CUEVAS | HUERTAS | VICTORIA | MUJER | 1961-12-13 00:00:00 | 12 | 13 | 21438356X | 26 | 10 | 13
Spreadsheet: 164575d1340811647-sum-several-columns-based-on-column-headings-jario_841348-sum-several-columns-based-on-column-headings_27jun12_02
Sheet: Sheet1

A | A | B | C | D | E | E | E |  | TOTAL
1 | 1 | 2 | 2 | 5 | 1 | 2 | 3 |  | A | 21 | 21
3 | 1 | 3 | 2 | 3 | 4 | 3 | 2 |  | B | 12 | 12
1 | 4 | 2 | 2 | 5 | 1 | 2 | 3 |  | C | 10 | 10
3 | 1 | 3 | 2 | 3 | 4 | 3 | 2 |  | D | 21 | 21
1 | 5 | 2 | 2 | 5 | 1 | 2 | 2 |  | E | 23 | 23
Spreadsheet: 704139d1605377144-formula-to-work-out-the-average-value-of-the-most-recent-entries-pq-apples
Sheet: Sheet3

Date | Fruit | Quantity
1/1/2020 | apples | 5
1/1/2020 | pears | 12
1/1/2020 | oranges | 4
1/1/2020 | bananas | 9
1/1/2020 | peaches | 6
1/2/2020 | apples | 2
1/2/2020 | pears | 1
1/2/2020 | oranges | 14
1/2/2020 | bananas | 7
1/2/2020 | peaches | 4
1/3/2020 | apples | 6
1/3/2020 | pears | 6
1/3/2020 | oranges | 18
1/3/2020 | bananas | 19
1/3/2020 | peaches | 5
1/4/2020 | apples | 13
1/4/2020 | pears | 9
1/4/2020 | oranges | 8
1/4/2020 | bananas | 4
1/4/2020 | peaches | 2
1/5/2020 | apples | 5
1/5/2020 | pears | 3
1/5/2020 | oranges | 17
1/5/2020 | bananas | 22
1/5/2020 | peaches | 10
1/6/2020 | apples | 16
1/6/2020 | pears | 11
1/6/2020 | oranges | 8
1/6/2020 | bananas | 7
1/6/2020 | peaches | 3
Spreadsheet: 766642d1643982315-filter-with-2-criteria-filtering
Sheet: Sheet1

Name | Category |  |  | [NAME]  Used: |  | =FILTER(A2:A11,B2:B11="IB/OB")*(B2:B11="IB")
[NAME] | IB/OB
[NAME] | IB/OB
[NAME] | OB |  |  |  |  | #[NAME]!
[NAME] | IB/OB |  |  |  |  | #[NAME]!
[NAME] | IB/OB+ |  |  |  |  | #[NAME]!
[NAME] | IB |  |  |  |  | #N/A
[NAME] | IB/OB |  |  |  |  | #N/A
[NAME] | IB/OB+ |  |  |  |  | #N/A
[NAME] | IB |  |  |  |  | #N/A
[NAME] | IB |  |  |  |  | #N/A
 |  |  |  |  |  | #N/A
Spreadsheet: 10b31c4b-1f47-4e1b-abd0-c87f573846c5
Sheet: Sheet1

1927 - 16th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | [NAME], Detroit, USA |  |  |  |  | 1927-09-10 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | USA | Hill | [NAME] | [NAME] | [NAME] | Detroit | Baxley/Georgia | 1198 | 48
2 | GER | Kaulen sr. | Hugo | Dahl | [NAME] | Barmen |  | 1106 | 1900-01-02 00:00:00
3 | USA | Orman | [NAME] | [NAME] | [NAME] | Goodyear VI | Georgia | 1102 | 1900-01-02 03:31:00
4 | FRA | [NAME] | [NAME] | Le Gallee |  | Lafayette |  | 1091
5 | SPA | Maldonado | Maj. E. | Molas | Maj. M. | Hispania |  | 1038
6 | BEL | Demuyter | Ernest | Soete | [NAME] | Belgica | Florence | 965 | 1900-01-01 07:00:00
7 | GER | Eimermacher | Ferdinand | Predeck | Dr. R. | Münster VIII | Prosp. | 925 | 1900-01-01 16:00:00
8 | ITA | Leone | Lt. Domenico | Medori | LtCol. Ugo | Dux |  | 917
9 | FRA | Bienaime | [NAME] | [NAME] | [NAME] | Paris-Bruxelles |  | 888
10 | USA | Kepner | [NAME]. [NAME] | [NAME] | Lt. [NAME].O. | US Army |  | 852
11 | BEL | [NAME] | [NAME] | [NAME] | M. | Wallonie |  | 852
12 | ITA | Ilari | Maj. [NAME] | Paonessa | [NAME]. [NAME] | Rex |  | 804
13 | SUI | Maag | Ernest | [NAME] | Ernie |  | Statesville | 748 | 22:00:00
14 | GBR | Maeger | Cpt.G.F. | Booth | SqLd. R.S. | Bee |  | 724
15 | GER | Halben | Dr. R. | [NAME] | Hugo | [NAME] | Sugar Island | 80 | 04:00:00
Spreadsheet: 867424d1714260657-rank-sortby-results-in-ascending-order-rank-sort
Sheet: Sheet1

 |  | P # | A | B |  | P# sorted by A then B |  |  | P # | Rank
 |  | 1 | 0 | 84 |  |  |  |  | 1 | 3
 |  | 2 | 7 | 87 |  | 5 |  |  | 2 | 10
 |  | 3 | 0 | 80 |  | 9 |  |  | 3 | 1
 |  | 4 | 2 | 82 |  | 7 |  |  | 4 | 5
 |  | 5 | 7 | 85 |  | 8 |  |  | 5 | 9
 |  | 6 | 2 | 78 |  | 4 |  |  | 6 | 4
 |  | 7 | 3 | 85 |  | 6 |  |  | 7 | 7
 |  | 8 | 3 | 83 |  | 1 |  |  | 8 | 6
 |  | 9 | 5 | 91 |  | 10 |  |  | 9 | 8
 |  | 10 | 0 | 84 |  | 3 |  |  | 10 | 3
Spreadsheet: 863643d1711051834-remove-duplicates-for-tier-3-category-try-dj
Sheet: Sheet1

[NAME] | Name |  |  | Output |  |  | New Output
Tier 1 | [NAME] |  |  | [NAME] | Name |  | [NAME] | Name
Tier 1 | [NAME] |  |  | Tier 1 | [NAME] |  |  | [NAME]
Tier 1 | [NAME] |  |  | Tier 1 | [NAME] |  | Tier 1 | [NAME]
Tier 1 | Rafa |  |  | Tier 1 | [NAME] |  | Tier 1 | [NAME]
Tier 1 | [NAME] |  |  | Tier 1 | Rafa |  | Tier 1 | Rafa
[NAME] | [NAME] |  |  | Tier 1 | [NAME] |  | Tier 1 | [NAME]
[NAME] | [NAME] |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | CAN ATALAY |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | HANN-WEN SHEU |  |  | [NAME] | CAN ATALAY |  | [NAME] | CAN ATALAY
Tier 3 | Oktar |  |  | [NAME] | HANN-WEN SHEU |  | [NAME] | HANN-WEN SHEU
Tier 3 | Miria |  |  | Tier 3 | Oktar |  | Tier 3 | Oktar
Tier 3 | [NAME] | Exclude as present in Tier 1 or Tier 2 |  | Tier 3 | Miria |  | Tier 3 | Miria
Tier 3 | CAN ATALAY | Exclude as present in Tier 1 or Tier 2 |  | Tier 3 | Oktar |  | Tier 3 | Oktar
Tier 3 | [NAME] | Exclude as present in Tier 1 or Tier 2
Tier 3 | Rafa | Exclude as present in Tier 1 or Tier 2
Tier 3 | Oktar
 |  |  |  |  |  |  |  | IF(COUNTIFS($B$2:B2,B2,$A$2:A2,"Tier A")>=1,"Keep","Remove")
 |  |  |  |  |  |  |  | IF(COUNTIFS($B$2:B100,B100,$A$2:A100,"Tier B")>=1,"Keep","Remove")
Spreadsheet: mary_fischer__25609__32C-2001
Sheet: E14.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032C
COMPANY NAME   Enron Building Services Inc. Hldg Co.
ANALYSIS OF OTHER DEFERRED CREDITS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
EXTENSION:[PHONE]
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash (Pd) / Rec'd |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(1)  PROVIDE DETAIL OF INDIVIDUAL ITEMS IN EXCESS OF $200,000
(2)  USE COMMENTS SECTION TO PROVIDE AN EXPLANATION OF WHY ANY REVENUE
ITEMS ARE DEFERRED AND WHAT EVENT WILL CAUSE REVENUE RECOGNITION
OTHER DEFERRED CREDITS:
 |  | 0
Total (Hyperion line 0860)
Asset/Expense Accts:  DR/(CR)
Reverse signs from Hyperion
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
Spreadsheet: 675748d1588458900-compound-interest-calculation-interest-calc
Sheet: Interest Calc

 | Daily int rate multiplier | 1.0001335891 | Yearly 5% interest rate check box |  |  | Totals: |  |  |  | Why the difference between these 2 cells??
 | Date |  | Daily movements per day (period) |  | Daily  Running Total | Days from oldest date | Interest due on day's movement until oldest date |  | Interest due on movement for single day
 | 2019-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | difference
 |  |  |  |  |  |  |  |  |  |  |  |  | per day
 |  |  | 100000 |  |  |  |  |  |  |  |  | 13.35891000000993 | actual single day
 |  |  |  |  |  |  |  |  |  |  |  | 1.00013698630136
 |  |  |  |  |  |  |  |  |  |  |  | 4996.493133836746
 |  |  |  |  |  |  |  |  |  |  |  | 4889.361060003634
 |  |  |  |  |  |  |  |  |  |  |  | 5126.749646368233
 |  |  |  |  |  |  |  |  |  |  |  | 13.69863013600116
Spreadsheet: 268115d1380444640-2-formulas-in-one-cell-help-base-calculator
Sheet: Binary to Decimal

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | Binary | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0
 |  | Decimal
Spreadsheet: 624778d1558078470-google-sheets-how-to-match-data-and-return-needed-value-only-book1
Sheet: Login Data

 | Country Name |  |  | [NAME] | End Timestamp | Active Time
 | Australia |  |  | 2019-05-02 08:02:23 | 2019-05-02 08:50:25 | 00:48:02
 | Australia |  |  | 2019-05-06 08:59:15 | 2019-05-06 10:03:08 | 02:03:53
 | Australia |  |  | 2019-05-07 07:59:23 | 2019-05-07 13:23:46 | 05:24:23
 | Australia |  |  | 2019-05-08 08:20:58 | 2019-05-08 12:00:34 | 03:39:36
 | Australia |  |  | 2019-05-09 07:59:21 | 2019-05-09 09:31:34 | 01:32:13
 | Australia |  |  | 2019-05-09 09:34:16 | 2019-05-09 15:36:59 | 06:02:43
 | Australia |  |  | 2019-05-10 07:55:41 | 2019-05-10 09:10:32 | 01:14:51
 | Country Name |  |  | [NAME] | End Timestamp | Active Time
 | Germany |  |  | 2019-05-02 08:02:23 | 2019-05-02 08:50:25 | 00:48:02
 | Germany |  |  | 2019-05-06 08:59:15 | 2019-05-06 10:03:08 | 02:03:53
 | Germany |  |  | 2019-05-07 07:59:23 | 2019-05-07 13:23:46 | 05:24:23
 | Germany |  |  | 2019-05-08 08:20:58 | 2019-05-08 12:00:34 | 03:39:36
 | Germany |  |  | 2019-05-09 07:59:21 | 2019-05-09 09:31:34 | 01:32:13
 | Germany |  |  | 2019-05-09 09:34:16 | 2019-05-09 15:36:59 | 06:02:43
 | Germany |  |  | 2019-05-10 07:55:41 | 2019-05-10 09:10:32 | 01:14:51
Spreadsheet: 861865d1709706584-need-calendar-to-populate-from-schedule-using-multiple-criteria-classroom-schedule
Sheet: Room 113

 | 2 day class |  |  |  |  |  |  |  | 1 day class
 |  |  | MON | TUE | WED | THUR | FRI |  |  |  | MON | TUE | WED | THUR | FRI
 | 8 | am |  |  |  |  |  |  | 8 | am
 |  | :15 |  |  |  |  |  |  |  | :15
 |  | :30 |  |  |  |  |  |  |  | :30
 |  | :45 |  |  |  |  |  |  |  | :45
 | 9 | am |  |  |  |  |  |  | 9 | am
 |  | :15 |  |  |  |  |  |  |  | :15
 |  | :30 |  |  |  |  |  |  |  | :30
 |  | :45 |  |  |  |  |  |  |  | :45
 | 10 | am |  |  |  |  |  |  | 10 | am
 |  | :15 |  |  |  |  |  |  |  | :15
 |  | :30 |  |  |  |  |  |  |  | :30
 |  | :45 |  |  |  |  |  |  |  | :45
 | 11 | am |  |  |  |  |  |  | 11 | am
 |  | :15 |  |  |  |  |  |  |  | :15
 |  | :30 |  |  |  |  |  |  |  | :30
 |  | :45 |  |  |  |  |  |  |  | :45
 | 12 | pm |  |  |  |  |  |  | 12 | pm
 |  | :15 |  |  |  |  |  |  |  | :15
 |  | :30 |  |  |  |  |  |  |  | :30
 |  | :45 |  |  |  |  |  |  |  | :45
 | 1 | pm |  |  |  |  |  |  | 1 | pm
 |  | :15 |  |  |  |  |  |  |  | :15
 |  | :30 |  |  |  |  |  |  |  | :30
 |  | :45 |  |  |  |  |  |  |  | :45
 | 2 | pm |  |  |  |  |  |  | 2 | pm
 |  | :15 |  |  |  |  |  |  |  | :15
 |  | :30 |  |  |  |  |  |  |  | :30
 |  | :45 |  |  |  |  |  |  |  | :45
 | 3 | pm |  |  |  |  |  |  | 3 | pm
 |  | :15 |  |  |  |  |  |  |  | :15
 |  | :30 |  |  |  |  |  |  |  | :30
 |  | :45 |  |  |  |  |  |  |  | :45
 | 4 | pm |  |  |  |  |  |  | 4 | pm
 |  | :15 |  |  |  |  |  |  |  | :15
 |  | :30 |  |  |  |  |  |  |  | :30
 |  | :45 |  |  |  |  |  |  |  | :45
 | 5 | pm |  |  |  |  |  |  | 5 | pm
 |  | :15 |  |  |  |  |  |  |  | :15
 |  | :30 |  |  |  |  |  |  |  | :30
 |  | :45 |  |  |  |  |  |  |  | :45
 | 6 | pm |  |  |  |  |  |  | 6 | pm
 |  | :15 |  |  |  |  |  |  |  | :15
 |  | :30 |  |  |  |  |  |  |  | :30
 |  | :45 |  |  |  |  |  |  |  | :45
 | 7 | pm |  |  |  |  |  |  | 7 | pm
 |  | :15 |  |  |  |  |  |  |  | :15
 |  | :30 |  |  |  |  |  |  |  | :30
 |  | :45 |  |  |  |  |  |  |  | :45
 | 8 | pm |  |  |  |  |  |  | 8 | pm
 |  | :15 |  |  |  |  |  |  |  | :15
 |  | :30 |  |  |  |  |  |  |  | :30
 |  | :45 |  |  |  |  |  |  |  | :45
 | 9 | pm |  |  |  |  |  |  | 9 | pm
 |  | :15 |  |  |  |  |  |  |  | :15
 |  | :30 |  |  |  |  |  |  |  | :30
 |  | :45 |  |  |  |  |  |  |  | :45
Spreadsheet: 723132d1615536508-subtract-until-zero-allocation-ans
Sheet: Sheet1

Item Number | ShipMonth | Due | [NAME] |  | Store_onhand | Allocate | Outstanding_Bal | Store_Bal
[NAME] | Dec-20 | 2020-12-24 00:00:00 | 200 |  | 10180
[NAME] | Dec-20 | 2020-12-18 00:00:00 | 2800
[NAME] | Nov-20 | 2020-11-20 00:00:00 | 700
[NAME] | BackOrder | 2020-04-12 00:00:00 | 1700
[NAME] | BackOrder | 2020-05-11 00:00:00 | 200
[NAME] | BackOrder | 2020-05-11 00:00:00 | 500
[NAME] | Dec-20 | 2020-12-24 00:00:00 | 900
[NAME] | Dec-20 | 2020-12-30 00:00:00 | 3900
[NAME] | Dec-20 | 2020-12-24 00:00:00 | 5600
[NAME] | Dec-20 | 2020-12-18 00:00:00 | 1500
[NAME] | Dec-20 | 2020-12-30 00:00:00 | 700
[NAME] | Nov-20 | 2020-11-27 00:00:00 | 3100
[NAME] | Nov-20 | 2020-11-20 00:00:00 | 1470
[NAME] | BackOrder | 2020-11-12 00:00:00 | 6300
[NAME] | Nov-20 | 2020-11-27 00:00:00 | 2200
[NAME] | Nov-20 | 2020-11-20 00:00:00 | 2500
[NAME] | BackOrder | 2020-04-12 00:00:00 | 3200
[NAME] | BackOrder | 2020-04-12 00:00:00 | 1100
[NAME] | Aug-21 | 2021-08-01 00:00:00 | 200
[NAME] | Aug-21 | 2021-08-01 00:00:00 | 6300
[NAME] | Aug-21 | 2021-08-01 00:00:00 | 2700
Spreadsheet: 0074bc84-6d13-4d5b-8df5-6c78f3242a22
Sheet: SCHED-B CONT 

OGE Form 278 (Rev. 12/2011) |  |  |  | Do not complete Schedule B if you are a new entrant, nominee, or Vice Presidential or Presidential Candidate
5 C.F.R. Part 2634
U.S. Office of Government Ethics
Reporting Individual's Name |  |  |  |  | SCHEDULE B continued (Use only if needed) |  |  |  |  |  |  |  |  |  |  | Page Number
Part I: Transactions
 |  |  |  |  |  | Transaction |  |  |  | Amount of Transaction (x)
 |  |  |  |  |  | Type (x)
 |  |  |  |  |  | Purchase | Sale | Exchange | Date | $1,001 -  $15,000 | $15,001 -  $50,000 | $50,001 -  $100,000 | $100,001 -  $250,000 | $250,001 -  $500,000 | $500,001 -  $1,000,000 | Over  $1,000,000* | $1,000,001 -  $5,000,000 | $5,000,001 -  $25,000,000 | $25,000,001 -  $50,000,000 | Over  $50,000,000 | Certificate of  divestiture
 |  |  |  |  |  |  |  |  | (Mo.,
 |  |  |  |  |  |  |  |  | Day, Yr.)
 | Identification of Assets
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
* This category applies only if the underlying asset is solely that of the filer's spouse or dependent children.  If the underlying asset is either held
by the filer or jointly held by the filer with the spouse or dependent children, use the other higher categories of value, as appropriate.
Spreadsheet: 1ab50b8d-e947-4eec-8f3c-b3982ebca67b
Sheet: Sheet1

SCHEDULE OF FY 2013 BIWEEKLY PAY PERIODS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Revised 11/15/11 for Automated Time & Leave System
Employees must have all time entered in Employee Self Service by the Monday following the end date of the pay period.
Supervisors must have biweekly employees' time approved in Manager Self Service by the Tuesday following the end date of the pay period.
Biweekly Schedule
Begin Date | End Date | Due Date in ESS | Pay  Date
2012-07-01 00:00:00 | 2012-07-14 00:00:00 | 2012-07-16 00:00:00 | 2012-07-27 00:00:00
2012-07-15 00:00:00 | 2012-07-28 00:00:00 | 2012-07-30 00:00:00 | 2012-08-10 00:00:00
2012-07-29 00:00:00 | 2012-08-11 00:00:00 | 2012-08-13 00:00:00 | 2012-08-24 00:00:00
2012-08-12 00:00:00 | 2012-08-25 00:00:00 | 2012-08-27 00:00:00 | 2012-09-07 00:00:00
2012-08-26 00:00:00 | 2012-09-08 00:00:00 | 2012-09-10 00:00:00 | 2012-09-21 00:00:00
2012-09-09 00:00:00 | 2012-09-22 00:00:00 | 2012-09-24 00:00:00 | 2012-10-05 00:00:00
2012-09-23 00:00:00 | 2012-10-06 00:00:00 | 2012-10-08 00:00:00 | 2012-10-19 00:00:00
2012-10-07 00:00:00 | 2012-10-20 00:00:00 | 2012-10-22 00:00:00 | 2012-11-02 00:00:00
2012-10-21 00:00:00 | 2012-11-03 00:00:00 | 2012-11-05 00:00:00 | 2012-11-16 00:00:00
2012-11-04 00:00:00 | 2012-11-17 00:00:00 | 2012-11-19 00:00:00 | 2012-11-30 00:00:00
2012-11-18 00:00:00 | 2012-12-01 00:00:00 | 2012-12-03 00:00:00 | 2012-12-14 00:00:00
2012-12-02 00:00:00 | 2012-12-15 00:00:00 | 2012-12-17 00:00:00 | 2012-12-28 00:00:00
2012-12-16 00:00:00 | 2012-12-29 00:00:00 | 2012-12-31 00:00:00 | 2013-01-11 00:00:00
2012-12-30 00:00:00 | 2013-01-12 00:00:00 | 2013-01-14 00:00:00 | 2013-01-25 00:00:00
2013-01-13 00:00:00 | 2013-01-26 00:00:00 | 2013-01-28 00:00:00 | 2013-02-08 00:00:00
2013-01-27 00:00:00 | 2013-02-09 00:00:00 | 2013-02-11 00:00:00 | 2013-02-22 00:00:00
2013-02-10 00:00:00 | 2013-02-23 00:00:00 | 2013-02-25 00:00:00 | 2013-03-08 00:00:00
2013-02-24 00:00:00 | 2013-03-09 00:00:00 | 2013-03-11 00:00:00 | 2013-03-22 00:00:00
2013-03-10 00:00:00 | 2013-03-23 00:00:00 | 2013-03-25 00:00:00 | 2013-04-05 00:00:00
2013-03-24 00:00:00 | 2013-04-06 00:00:00 | 2013-04-08 00:00:00 | 2013-04-19 00:00:00
2013-04-07 00:00:00 | 2013-04-20 00:00:00 | 2013-04-22 00:00:00 | 2013-05-03 00:00:00
2013-04-21 00:00:00 | 2013-05-04 00:00:00 | 2013-05-06 00:00:00 | 2013-05-17 00:00:00
2013-05-05 00:00:00 | 2013-05-18 00:00:00 | 2013-05-20 00:00:00 | 2013-05-31 00:00:00
2013-05-19 00:00:00 | 2013-06-01 00:00:00 | 2013-06-03 00:00:00 | 2013-06-14 00:00:00
2013-06-02 00:00:00 | 2013-06-15 00:00:00 | 2013-06-17 00:00:00 | 2013-06-28 00:00:00
2013-06-16 00:00:00 | 2013-06-29 00:00:00 | 2013-07-01 00:00:00 | 2013-07-12 00:00:00
2013-06-30 00:00:00 | 2013-07-13 00:00:00 | 2013-07-15 00:00:00 | 2013-07-26 00:00:00
Spreadsheet: 9ca9ce19-a87d-4495-be1f-8569d69ba3ae
Sheet: Idahoan

IDAHOAN FOODS
SY2013-2014 USDA Foods Calculator
Instructions: Fill in the cells that are colored light gray.  This worksheet is designed to calculate everything for you!
COMMODITY REPROCESSED ITEMS |  |  |  |  |  |  | USDA INFORMATION |  |  | CUSTOMER INFORMATION
 | USDA Item # | Commodity Name | Processor Item # | Item Description | Servings/ case | Pack Size | 13-14 DFV | DFV/Pound | DFV/Case | Number servings/ meal | Cases needed/ meal | Times served/ year | Number cases needed | Donated Food $$ spent | Entitlement pounds used
 | 110227 | Dehyd Potatoes | 301 | Idahoan INSTAMASH Flakes | 1050 | 12/28 oz | 105 | 0.0536
 | 110227 | Dehyd Potatoes | 313 | Idahoan Real Mash | 975 | 12/26oz | 97.5 | 0.0536
 | 110227 | Dehyd Potatoes | 316 | Idahoan Naturally Mash | 1407 | 6/4.69# | 140.7 | 0.0536
 | 110227 | Dehyd Potatoes | 335 | Idahoan Premium Buttery Golden Selects | 1233 | 24/16.44 oz | 123.3 | 0.0536
 | 110227 | Dehyd Potatoes | 338 | Idahoan Premium Baby Reds Mash | 1230 | 24/16.4 oz | 123 | 0.0536
 | 110227 | Dehyd Potatoes | 365 | Idahoan Premium [NAME] | 1050 | 12/28 oz | 105 | 0.0536
 | 110227 | Dehyd Potatoes | 808 | Idahoan Fresh Cut Hash Browns | 307 | 6/2.125# | 63.75 | 0.0536
 | 110227 | Dehyd Potatoes | 880 | Idahoan [NAME] (carton) | 762 | 6/2.54 lb | 45.4 | 0.0536
 | 110227 | Dehyd Potatoes | 881 | Idahoan Scalloped (carton) | 762 | 6/2.54 lb | 45.4 | 0.0536
 | 110227 | Dehyd Potatoes | 882 | Idahoan Potato Slices | 1000 | 4/5 lb | 100 | 0.0536
 | 110227 | Dehyd Potatoes | 888 | Idahoan [NAME] Potatoes | 763 | 12/20.35 oz | 45.5 | 0.0536
 | 110227 | Dehyd Potatoes | 889 | Idahoan Scalloped | 763 | 12/20.35 oz | 45.5 | 0.0536
 | 110227 | Dehyd Potatoes | 10218 | Idaho Supreme Complete w/Vitamin C | 1800 | 6/5.5# #10 | 180 | 0.0536
 | 110227 | Dehyd Potatoes | 20405 | Idahoan Real Mash | 970 | 6/3.24# | 97 | 0.0536
 | 110227 | Dehyd Potatoes | 22313 | Idahoan Real Mash w/Vit C | 975 | 12/26 oz | 97.5 | 0.0536
 | 110227 | Dehyd Potatoes | 25313 | Idahoan Real Mash Low Sodium w/Vit C | 955 | 12/25.2 oz | 94.5 | 0.0536
 | 110227 | Dehyd Potatoes | 85250 | Idahoan Real Mash | 2500 | 1/50# | 250 | 0.0536
 | 110227 | Dehyd Potatoes | 85252 | Idahoan Naturally Mash | 2500 | 1/50 lb | 250 | 0.0536
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Idahoan Foods 110227 Pounds to Order:
Spreadsheet: 692051d1598031008-count-and-sum-negative-numbers-on-filtered-lines-conta_somma
Sheet: Foglio1

 | B | R |  | Count | Sum
 | cc | 1
 | dd | 2
 | ee | 3
 | ff | 4
 | gg | -1
 | hh | -1
 | iii | -1
 | ll | -1
 | [NAME] | -1
 | nn | -2
 | oo | -50
 | pp | 8
 | qq | -1
 | rr | 6
 | ss | -1
 | tt | -1
 | uu | 10
========================================================ù
 | B | R |  | Count | Sum
 | cc | 1
 | dd | 2
 | ee | 3
 | ff | 4
 | gg | -1
l | hh | -1
 | iii | -1
 | ll | -1
o | [NAME] | -1
 | nn | -2
 | oo | -50
 | pp | 8
 | qq | -1
 | rr | 6
 | ss | -1
 | tt | -1
 | uu | 10
Spreadsheet: 03187d88-5949-40b4-85f6-fa4f97db5424
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0022711 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Macon County Reuse System | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Macon | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00940 | 50060 | 31616 | 00610 |  | 00620 | 00400 | 70295 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Chloride | Total Residual Chlorine | Fecal Coliform | Ammonia |  | Nitrate | pH | Total Dissolved Solids | Total Suspended Solids | Turbidity
 | 24-hr | hrs | GPD | mg/L | mg/L | mg/L | #/100 mL | mg/L |  | mg/L | su | mg/L | mg/L | NTU
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Grab | Grab | Grab | Composite |  | Composite | Grab | Grab | Composite | Recorder
Monthly Limit: |  |  |  | 10 |  |  | 14 | 4 |  |  |  |  | 5
Daily Limit: |  |  |  | 15 |  |  | 25 | 6 |  |  | 6-9 |  | 10 | 10
Sample Frequency: |  |  | [NAME] | Monthly | 3 x Year | 5 x Week | Monthly | Monthly |  | Monthly | 5 x Week | 3 x Year | Monthly | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 135344d1325959804-what-is-the-easiest-way-to-do-this-if-combined-with-vlookkup-excelexample
Sheet: Sheet3

Cost of Entry | Place | Result |  |  | Cost of Entry
8 | 10 |  |  | Place | 8 | 15 | 35
15 | 12 |  |  | 1 | 396.42 | 743.64 | 1735.06
35 | 24 |  |  | 2 | 263.24 | 495.72 | 1156.68
 |  |  |  | 3 | 157.22 | 294.95 | 688.22
 |  |  |  | 4 | 105.69 | 198.28 | 462.67
 |  |  |  | 5 | 85.87 | 161.1 | 375.92
 |  |  |  | 6 | 66.06 | 123.93 | 289.17
 |  |  |  | 7 | 46.24 | 86.75 | 202.41
 |  |  |  | 8 | 34.35 | 64.44 | 150.36
 |  |  |  |  | 22.46 | 42.13 | 98.31
 |  |  |  | 10 | 15.85 | 29.74 | 69.4
 |  |  |  | 11 | 15.85 | 29.74 | 69.4
 |  |  |  | 12 | 15.85 | 29.74 | 69.4
 |  |  |  | 13 | 15.85 | 29.74 | 69.4
 |  |  |  | 14 | 15.85 | 29.74 | 69.4
 |  |  |  | 15 | 15.85 | 29.74 | 69.4
 |  |  |  | 16 | 15.85 | 29.74 | 69.4
 |  |  |  | 17 | 15.85 | 29.74 | 69.4
 |  |  |  | 18 | 15.85 | 29.74 | 69.4
 |  |  |  | >18 | 0 | 0 | 0