tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: theresa_staab__39608__north central purchase detail 2001
Sheet: Mar 01

North Central Oil | Contact: | [NAME] |  |  | Enron North America
 | PH: | (713) 268-4532
 | FAX: |  |  |  | [NAME] | PH:  [PHONE]
 | E-Mail: | [EMAIL] |  |  |  | FAX:  [PHONE]
March, 2001
First of Month Nomination: | 27203
Btu factor
Transportation | 0.14 | per [NAME] (25,000/d)
IF CIG Index | 4.72
 |  | Index Discount/Premium | Lost Creek Transport/MMBtu | Total Net Back
Net Backs: | CIG GD | 0.03 | -0.141414119
 | Firm Quantity | 0 | -0.141414119
 | IF CIG (90%) | 0.04 | -0.141414119
 |  | 90% of FOM Nom. Less Firm Quantity | 90% of FOM less Firm Quantity | Firm Quantity | Firm Quantity Volume MMBtu | GD Volume | CIG GD Volume MMBtu |  | Total [NAME] | $ CIG +.04 | $ [NAME] | $ CIG GD | Total Payment
 | CIG GD Rockies | IF CIG less Netback |  | CIG less Netback | 15000 | [NAME] less Netback
2001-03-01 00:00:00 | 5.065 |  |  |  |  |  |  |  | 26930.97
 | 5.045 |  |  |  |  |  |  |  | 27357.66
 | 4.875 |  |  |  |  |  |  |  | 27357.66
 | 4.875 |  |  |  |  |  |  |  | 27357.66
 | 4.875 |  |  |  |  |  |  |  | 27357.66
 | 5.025 |  |  |  |  |  |  |  | 27357.66
 | 4.98 |  |  |  |  |  |  |  | 27357.66
 | 4.925 |  |  |  |  |  |  |  | 27357.66
 | 4.925 |  |  |  |  |  |  |  | 26742.87
 | 4.795 |  |  |  |  |  |  |  | 26742.87
 | 4.795 |  |  |  |  |  |  |  | 26742.87
 | 4.795 |  |  |  |  |  |  |  | 26742.87
 | 4.62 |  |  |  |  |  |  |  | 26742.87
 | 4.8 |  |  |  |  |  |  |  | 25938
 | 4.745 |  |  |  |  |  |  |  | 25938
 | 4.675 |  |  |  |  |  |  |  | 26928
 | 4.67 |  |  |  |  |  |  |  | 26928
 | 4.67 |  |  |  |  |  |  |  | 26928
 | 4.67 |  |  |  |  |  |  |  | 26928
 | 4.72 |  |  |  |  |  |  |  | 26928
 | 4.57 |  |  |  |  |  |  |  | 26928
 | 4.645 |  |  |  |  |  |  |  | 26928
 | 4.65 |  |  |  |  |  |  |  | 26928
 | 4.775 |  |  |  |  |  |  |  | 26928
 | 4.775 |  |  |  |  |  |  |  | 26928
 | 4.775 |  |  |  |  |  |  |  | 26928
 | 4.695 |  |  |  |  |  |  |  | 25822.17
 | 4.6 |  |  |  |  |  |  |  | 25473.69
 | 4.7 |  |  |  |  |  |  |  | 25473.69
 | 4.475 |  |  |  |  |  |  |  | 25473.69
 | 4.57 |  |  |  |  |  |  |  | 25473.69
 |  |  |  |  |  |  |  |  | avg. $/MMBtu
Spreadsheet: 60568d1261083859-printed-sheet-in-different-format-than-worksheet-before-print
Sheet: WIP

PROJECT | CATEGORY | SPONSOR | DEPT | ELEMENTS | DUE | BRIEF | FLIGHT | MEDIA | SUN APRV | ROUND 1 | FEEDBACK | ROUND 2 | APRV | PRODUCER/EDITOR | GRAPHIC VENDOR | PACKAGING | INTERNAL | STATUS | [NAME]
SPECTACLE | OOH | Infiniti | Design | 2-sheets, [NAME], CNN Wall | 2009-11-10 00:00:00 |  | 11/30 - 12/31 |  |  |  |  |  |  |  |  | Spectacle |  | DELIVERED | X
SPECTACLE | OOH | Infiniti | Desing | Times Square Addition |  |  | 11/30 - 12/31 |  |  |  |  |  |  |  |  | Spectacle |  |  | X
SPECTACLE | Print |  | Design | NYT ad Sunday Arts - Key art | 2009-11-30 00:00:00 |  | 2009-12-06 00:00:00 |  |  |  |  |  |  |  |  | Spectacle
SPECTACLE | Print |  | Design | NYT ad Biz Section Front Right Read - Bono | 2009-11-30 00:00:00 |  | 2009-12-09 00:00:00 |  |  |  |  |  |  |  |  | Spectacle
SPECTACLE | Print | Infiniti | Design | NYT ad Biz Section Back Page- Bruce | 2009-11-30 00:00:00 |  | 1/27? |  |  |  |  |  |  |  |  | Spectacle
SPECTACLE | On-Air | Infiniti | BE | VOD pre-roll | 2009-11-11 00:00:00 |  |  |  | 2009-01-27 00:00:00 |  |  |  |  | Steve/Lisa |  | Spectacle |  | DELIVERED 11/13 | X
SPECTACLE | On-Air | Infiniti | BE | Season 1 promo | 2009-11-11 00:00:00 |  |  |  |  | 2009-11-06 00:00:00 |  |  |  |  |  | Spectacle |  | DELIVERED 11/6 | X
SPECTACLE | On-Air | Infiniti | BE | Season 2 promo | 2009-11-20 00:00:00 |  |  |  |  | 2009-11-20 00:00:00 |  |  |  |  |  | Spectacle
SPECTACLE | On-Air | Infiniti | BE | VOD Traffic Driver | 2009-11-24 00:00:00 |  |  |  |  | 2009-11-24 00:00:00 |  |  |  |  |  | Spectacle
SPECTACLE | On-Air | Infiniti | BE | Digital Showcase | 2009-12-02 00:00:00 |  |  |  |  | 2009-11-30 00:00:00 |  |  |  |  |  | Spectacle
SPECTACLE | On-Air | Infiniti | BE | Open/Close/You're Watching | 2009-11-11 00:00:00 |  |  |  |  |  |  |  |  | Cirona/Fox |  | Spectacle | MF | DELIVERED | X
SPECTACLE | On-Air | Infiniti | BE | Vignettes 201 |  |  |  |  |  |  |  |  |  | Impossible Pictures |  | Spectacle | MF | DELIVERED | X
SPECTACLE | On-Air | Infiniti | BE | Vignettes 202 |  |  |  |  |  |  |  |  |  | Impossible Pictures |  | Spectacle |  | DELIVERED | X
SPECTACLE | On-Air |  | BE | Vignettes 203 |  |  |  |  |  |  |  |  |  | Impossible Pictures |  | Spectacle |  | DELIVERED | X
Spreadsheet: harry_arora__12146__Staffing Report 12-8-2000
Sheet: Staffers

ENRON NET WORKS STAFFING REPORT
Name: | Staffers
Week: | December 8th - 31st
 |  |  |  |  |  | Total# |  |  |  |  |  |  |  | Fees | Fees | Fees | Fees
 |  |  | Total # | Total # |  | Starts |  |  |  |  |  |  |  | Paid | Paid | Saved | Saved
 |  |  | Offers | Declines |  | AG | RC | RF | [NAME] | TR | IN | GR |  | AG | RF | RC | RF
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 266530 | 15000 | 71425 | 70500
Stock |  |  |  |  |  | 1
[NAME] |  |  | 4 |  |  | 1 | 1 | 1 | 2
[NAME] |  |  | 1 |  |  | 1
Burchfield |  |  |  |  |  | 2 | 1 |  | 1
Internet
Hanz |  |  | 1 |  |  | 2 |  | 1
[NAME]
Gubser
McAuliffe |  |  | 14 |  |  | 4 |  | 1 | 7
Dziadek |  |  | 1 | 1 |  | 1
[NAME] |  |  | 11 |  |  | 1 |  |  | 12
Rub - Projects & Oversight
Webb |  |  | 2 |  |  | 2
[NAME]
Montagne |  |  | 1
Elrod
Pavetto |  |  |  |  |  |  |  | 1 | 1
Garner
[NAME] |  |  | 2 |  |  |  |  |  | 1
Forster
Piper
Kinneman |  |  |  |  |  |  | 1
Monk |  |  | 1
Hotte |  |  | 6 |  |  | 3 | 2 |  | 1 | 2
[NAME]
Global Technology Track |  |  | 2
Spreadsheet: 6d51a3b8-dbf7-4a9f-a250-bc7df9eeead2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Table 10--Acreage, yield, and production estimates, 2013
State/region | Planted |  | Harvested |  | Yield |  | Production
 |  |  |  |  | Pounds/
 | -- 1,000 acres -- |  |  |  | [NAME] |  | 1,000 bales
Upland:
Alabama | 365 |  | 362 |  | 736 |  | 555
Florida | 131 |  | 128 |  | 750 |  | 200
Georgia | 1370 |  | 1355 |  | 850 |  | 2400
North Carolina | 465 |  | 460 |  | 819 |  | 785
South Carolina | 258 |  | 254 |  | 680 |  | 360
Virginia | 78 |  | 77 |  | 960 |  | 154
Southeast | 2667 |  | 2636 |  | 811 |  | 4454
Arkansas | 310 |  | 305 |  | 1149 |  | 730
Louisiana | 130 |  | 125 |  | 1248 |  | 325
Mississippi | 290 |  | 285 |  | 1229 |  | 730
Missouri | 255 |  | 246 |  | 956 |  | 490
Tennessee | 250 |  | 233 |  | 871 |  | 423
Delta | 1235 |  | 1194 |  | 1085 |  | 2698
Kansas | 27 |  | 26 |  | 720 |  | 39
Oklahoma | 185 |  | 125 |  | 730 |  | 190
Texas | 5800 |  | 3200 |  | 645 |  | 4300
Southwest | 6012 |  | 3351 |  | 649 |  | 4529
Arizona | 160 |  | 159 |  | 1449 |  | 480
California | 93 |  | 92 |  | 1643 |  | 315
New Mexico | 39 |  | 33 |  | 1091 |  | 75
West | 292 |  | 284 |  | 1470 |  | 870
Total Upland | 10206 |  | 7465 |  | 807 |  | 12551
Pima:
Arizona | 2 |  | 2 |  | 1184 |  | 4
California | 187 |  | 186 |  | 1574 |  | 610
New Mexico | 4 |  | 3 |  | 847 |  | 6
Texas | 9 |  | 9 |  | 904 |  | 16
Total Pima | 201 |  | 199 |  | 1530 |  | 636
Total all | 10407 |  | 7664 |  | 826 |  | 13187
Source:  USDA, January 2014 Crop Production report.
Last update: 2/12/14.
Spreadsheet: 728118d1618329098-index-and-match-to-return-a-date-based-on-a-ranked-day-of-the-week-index-match-date-based-on-day-of-the-week-rank
Sheet: Sheet1

 | 2021-04-15 00:00:00 | 2021-04-16 00:00:00 | 2021-04-17 00:00:00 | 2021-04-18 00:00:00 | 2021-04-19 00:00:00 | 2021-04-20 00:00:00 | 2021-04-21 00:00:00
 | Thu | Fri | Sat | Sun | Mon | Tue | Wed |  | Large | Large Occurences | Returned Date | Returned Date based on rank
 | 3 | 2 | 1 | 1 | 0 | 3 | 3 |  |  |  |  | 2021-04-15 00:00:00
 | 28 | 28 | 3 | 4 | 11 | 15 | 19 |  |  |  |  | 2021-04-16 00:00:00
 | 20 | 15 | 7 | 22 | 29 | 29 | 19 |  |  |  |  | 2021-04-19 00:00:00
Spreadsheet: 858902d1707400707-help-sumif-multiple-tabs-example2
Sheet: Progress

 |  |  |  | Total List
 |  |  |  | Total Done
 |  |  |  | Total Done This Month
 |  |  |  | Total Done Last month
 |  |  |  | Total Outstanding
 |  |  |  | Progress YTD  %
 |  |  |  | Target Threshold % |  | not required
 |  |  |  |  | Totals | Oustanding
 |  |  |  | January
 |  |  |  | February
 |  |  |  | March
 |  |  |  | April
 |  |  |  | May
 |  |  |  | June
 |  |  |  | July
 |  |  |  | August
 |  |  |  | September
 |  |  |  | October
 |  |  |  | November
 |  |  |  | December
Spreadsheet: 29885d1225124475-grabbing-data-from-one-sheet-and-displaying-on-another-pivot-pinnacle
Sheet: master_list_by_name

Surname | Forename | Barcode | File# | Year
Abalos | Jorge | 550252053 | 19254 | 2004
Abarca | [NAME] | 550252001 | 18262 | 2005
Abarca | [NAME] | 550252001 | 17963 | 2005
Abarca | Lazaro | 550252053 | 18821 | 2004
Abarca | [NAME] | 550252111 | 21552 | 2007
Abassi | Lahcen | 550252041 | 19402 | 2006
Abdelrazzak | [NAME] | 550252111 | 19932 | 2007
[NAME] | Rafique | 550252001 | 20631 | 2005
Abreu | [NAME] | 550252041 | 16524 | 2006
Aburto | Angelina y Erick | 550252053 | 15202 | 2004
Aburto | [NAME] | 550252053 | 19853 | 2004
Aburto | [NAME] | 550252111 | 21090 | 2007
Aburto | Luisa | 550252001 | 19852 | 2005
Aburto | Maria | 550252053 | 19075 | 2004
Acebedo | Marisol | 550252111 | 18906 | 2007
Acevedo | Bricelda | 550252001 | 17182 | 2005
Acosta | Anastacia, Minerva, Jaime | 550252129 | 20366 | 2006
Acosta | [NAME] and [NAME] | 550252129 | 19767 | 2006
Acosta | Felipe | 550252129 | 21374 | 2006
Acosta | Luis | 550252129 | 18336 | 2006
Acosta | [NAME] and [NAME]. Matilde | 550252111 | 21989 | 2007
Acosta | [NAME] | 550252001 | 20385 | 2005
Acosta | Genaro | 550252111 | 22147 | 2007
Acosta | [NAME] | 550252111 | 18647 | 2007
Acosta | [NAME] | 550252053 | 18502 | 2004
Acosta | [NAME] | 550252053 | 18093 | 2004
Spreadsheet: 153961d1336131185-conditional-formatting-a-drop-down-box-with-time-outboundtest
Sheet: Sheet1

OUTBOUND CALLS
Name | Contact_Number | Alt_Number | Callback_Date | Callback_Time | Agent Name | Reason for [NAME]
A Customer | 1234567890 | 7111111111 | 2012-05-03 00:00:00 | 09:00:00 | [NAME] | test data
 |  |  | 2012-05-04 00:00:00 | 12:30:00 | [NAME] | test data |  | [NAME] |  | 09:00:00
 |  |  | 2012-05-07 00:00:00 | 09:30:00 | [NAME] | test data |  | [NAME] |  | 09:30:00
 |  |  | 2012-05-19 00:00:00 | 13:30:00 | [NAME] | test data |  | [NAME] |  | 10:00:00
 |  |  | 2012-05-21 00:00:00 | 15:30:00 | [NAME] | test data |  | [NAME] |  | 10:30:00
 |  |  | 2012-05-22 00:00:00 | 11:00:00 | [NAME] | test data |  | [NAME] |  | 11:00:00
 |  |  | 2012-05-22 00:00:00 | 10:00:00 | [NAME] | test data |  | [NAME] |  | 11:30:00
 |  |  | 2012-05-26 00:00:00 | 10:00:00 | [NAME] | test data |  | [NAME] |  | 12:00:00
 |  |  | 2012-07-04 00:00:00 | 16:00:00 | [NAME] | test data |  | [NAME] |  | 12:30:00
 |  |  | 2012-07-06 00:00:00 | 14:30:00 | [NAME] | test data |  | [NAME] |  | 13:00:00
 |  |  |  |  |  |  |  | [NAME] |  | 13:30:00
 |  |  |  |  |  |  |  | [NAME] |  | 14:00:00
 |  |  |  |  |  |  |  | [NAME] |  | 14:30:00
 |  |  |  |  |  |  |  | [NAME] |  | 15:00:00
 |  |  |  |  |  |  |  | [NAME] |  | 15:30:00
 |  |  |  |  |  |  |  | [NAME] |  | 16:00:00
 |  |  |  |  |  |  |  | [NAME] |  | 16:30:00
 |  |  |  |  |  |  |  | [NAME] |  | 17:30:00
 |  |  |  |  |  |  |  | [NAME] |  | 18:00:00
 |  |  |  |  |  |  |  | [NAME] |  | 18:30:00
 |  |  |  |  |  |  |  | [NAME] |  | 19:00:00
 |  |  |  |  |  |  |  | [NAME] |  | 19:30:00
Spreadsheet: 0796c69d-41c7-4651-8136-e9f5a4ef7acf
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EC08 IP Cost Sharing Funds Request Form | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Company Name Here
Labor Funding Request |  |  |  |  |  | Running Total
Function or Task | WBS Task | Assigned Personnel | [NAME] | Projected Labor Hours | Task Funding Request
Write GetView spec | WBS 4.2.1 Item 3 | Sr. Software Eng. | 50 | 100 | 5000
Modify brand x client to support with GetView | WBS 4.2.1 Item 4 | Assoc. Software Eng. | 30 | 150 | 4500
 |  | Expand form as needed
Total Labor |  |  |  |  | 9500 | 9500
Travel Funding Request
Function or Event | Duration | Aspects of Travel | Est. Trip Cost | # of Travelers | Trip Funding Request
EC08 Kickoff | 3 days | flight, lodging, per diem | 3000 | 1 | 3000
[NAME] | 30 days | flight, lodging, per diem | 3000 | 2 | 6000
Total Travel |  |  |  |  | 9000 | 18500
Other Expense Requests
Expense Type | Purpose or Use | Justification | Est. Cost | Amount (Units) | Expense Funding Request
Brand X Server CPU | Host WBS software | Required by submitter in order to have adequate infrastructure to show results | 5000 | 1 | 5000
[NAME] (Seat licenses) | Data storage and retrieval | Required by submitter in order to have adequate infrastructure to show results | 3000 | 20 | 60000
Total Other Expenses |  |  |  |  | 65000 | 83500
Grand Total Matching Funds Request |  |  |  |  | 83500
Spreadsheet: phillip_m_love__30658__9910_OA
Sheet: ONT_FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ALL
REGION:  ONTARIO
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 23454938 | 62968390
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 5323406 | 13960052
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 28778344 | 76928442
 | Purchases:
6 |  | 3rd Party / Inter Enron | -23427327 | -62432041
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -5305230 | -14001196
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -28732557 | -76433237
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | -18646 | 5814
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | -18646 | 5814
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | -27141 | -84951.33
23 | Fuel: |  | 0 | 0
 | Transport Expense:
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | -837625.4771017097
31 |  | Prior Month Book Balance | 0 | 756466
 |  | Total MTM Income | 0 | -81159.4771017097
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 302842
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -340
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -192629
 |  | TOTAL INTRA-MTH
FT-Ontario
 |  | Current Month MTM | 0 | 21000
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 807321d1669841066-revenue-recognition-formula-excel-help-301122-jt
Sheet: EXCEL HELP

 |  |  |  |  |  |  |  |  |  | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00
 |  |  |  |  |  |  |  |  | No. of Days being billed | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00
 |  | Invoice
 | Customer | number | Invoice date | Description | Reference | Amount | Billing period From Date | Billing period End Date |  | 2022-08-31 00:00:00 |  | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 |  |  |  |  |  |  |  | Total Revenue | Checker
 |  |  | 2022-10-17 00:00:00 |  |  | 120 | 2022-08-01 00:00:00 | 2022-09-30 00:00:00
 |  |  | 2022-10-17 00:00:00 |  |  | 3560.7 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
 |  |  | 2022-10-17 00:00:00 |  |  | 286.5 | 2022-11-01 00:00:00 | 2023-10-31 00:00:00
 |  |  | 2022-10-17 00:00:00 |  |  | 832.5 | 2022-09-01 00:00:00 | 2022-09-30 00:00:00
 |  |  | 2022-11-01 00:00:00 |  |  | 1200 | 2022-12-18 00:00:00 | 2023-12-17 00:00:00
 |  |  | 2022-11-01 00:00:00 |  |  | 1000 | 2022-10-01 00:00:00 | 2022-10-31 00:00:00
 |  |  | 2022-12-01 00:00:00 |  |  | 1200 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00
 |  |  | 2022-12-01 00:00:00 |  |  | 1200 | 2021-10-01 00:00:00 | 2022-11-30 00:00:00
 |  |  |  |  |  |  |  | Total revenue recognised
 |  |  |  |  |  |  |  |  |  | Looking for a formula that can be used the grey box
 |  |  |  |  |  |  |  |  |  | Depending on the invoice date of the month does the recognition begin and the recogniiton will bas based on columns H & I
Spreadsheet: 60756d1261317736-count-number-of-time-a-text-string-appears-count-2-conditions
Sheet: Sheet1

a | 1 | 2 | 5 | 6 | 9
b | 3 | 4 | 7 | 8 | 9
c | 1 | 2 | 6 | 4 | 8
d | 7 | 9 | 6 | 5 | 4
 |  |  | I'm trying to do a conditional formula i.e. countif for each line there is a number 1, countif there is also a number 2 within the grid on the horizontal lines a-d. I would then go on to do the same for number 2,3,4 etc.  I'd be happy to do it in VB but am only a VB beginner so may need some prompting. I need to do the count for each number up to 20 on a bigger grid.  =IF(1,B1:F4,(COUNTIF(B1:F4,2))"") was my attempt!
Spreadsheet: 115992d1311450602-excel-2008-dsum-or-subtotal-with-dynamic-criteria-from-a-large-list-sample_truck_log
Sheet: Lists

Commodity 1 | 1 | 1 | B
Commodity 2 | 2 | 2 | G
Commodity 3 | 3 |  | P
Commodity 4 | 4
Commodity 5 | 5
Commodity 6 | 6
Commodity 7 | 7
Commodity 8 | 8
Commodity 9 | 9
Commodity 10 | 10
Commodity 11 | 11
Commodity 12 | 12
Commodity 13
Commodity 14
Commodity 15
Commodity 16
Commodity 17
Commodity 18
Commodity 19
Commodity 20
Commodity 21
Commodity 22
Commodity 23
Commodity 24
Commodity 25
Commodity 26
Commodity 27
Commodity 28
Commodity 29
Commodity 30
Commodity 31
Commodity 32
Commodity 33
Commodity 34
Commodity 35
Commodity 36
Commodity 37
Commodity 38
Spreadsheet: 878947d1726290212-ideas-for-creating-a-dashboard-education-tracking-cadet-progress-tracker-template
Sheet: Drop Downs

XS | Yes | Complete | 1 | Blue | [NAME] | Active
S | No | In Progress | 2 | [NAME] | Lightning | Inactive
M | Awaiting Order | Action Required | 3 | Silver | Reaper
L |  |  | 4 | Gold | Sentry
XL |  |  |  |  | Tornado
2XL |  |  |  |  | Voyager
Spreadsheet: 780278d1652370100-return-value-from-1-of-2-columns-depending-on-the-header-based-on-2-criteria-front-cover-test
Sheet: Data

CUSTOMER REF | B/L | DATE | Wk No. | QTY | Currency | Rate | Total | Exchange Rate | Invoice Currency | Converted Rate | Converted Total | GBP Total | Total Invoiced | Invoice Currency2 | Converted Rate3 | Converted Total4 | GBP Total5
AGF659 | COSU6321884050 | 2022-05-12 00:00:00 |  | 1 | EUR | 2.5 |  |  | GBP
 |  | 2022-01-10 00:00:00 |  | 2 | USD | 1.5
 |  | 2022-01-03 00:00:00
Spreadsheet: phillip_m_love__30152__9905_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Southeast-EGM |  | West |  | Texas-HPL |  | Texas-EGM |  | Storage |  | Ontario |  | BUG
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1401510
2 |  | Liquidations |  |  |  | 0 |  | -406701 |  |  |  |  |  |  |  |  |  | -1401510
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  | 0 |  |  |  |  |  | 0
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  | 0 |  | 0
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel: |  |  |  |  | -18891 |  |  |  |  |  |  |  |  |  |  |  | 18891
 | Transport Expense:
24 |  | Commodity |  |  |  | -44824 |  |  |  |  |  |  |  |  |  |  |  | 44824
25 |  | Demand |  |  |  |  |  | 643108.63 |  |  |  |  |  | 809669.11
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  | 129169 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -129169
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  |  |  | 24800 |  |  |  |  |  |  |  | -473930
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  | -190000 |  |  |  |  |  |  |  |  |  |  |  | 190000
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 841000d1693246715-create-a-sum-in-a-cell-based-off-of-the-contents-of-another-workbooks-cells-project-tracker
Sheet: SPAN

 | 2023 SR - SPAN |  | Desktop |  | IR-3D Cams |  | Monitors |  |  |  | Laptop |  | Dock's | Servers | iPhone |  | iPad Pro |  | Thin Client | Multiport |  | TOTALS |  | %
 |  |  | SFF | MFF | DELL | Brio | 22" | 24" | 27" | 32" | 5440 | 7440 | WD22TB4 | Dell | v13 | v14 | 11" | 12.9" | HP T460 | Adapters
 | H/W TOTALS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | H/W ORDERED
 | H/W RECEIVED
 | H/W REMAINING
 | H/W DEPLOYED
Spreadsheet: 829083d1683901294-index-match-with-sort-capability-planning-project-test
Sheet: Main

How it is now
 |  | SKU | Desc | Packs | Order | Type
 |  |  |  |  |  |  |  |  |  |  |  | text29 | 500 | 1 | S5
 |  |  |  |  |  |  |  |  |  |  | 86934800 | text23 | 1000 | 1 | S5
 |  |  |  |  |  |  |  |  |  |  | 86932300 | text28 | 200 | 1 | S3
 |  |  |  |  |  |  |  |  |  |  | 86780600 | text34 | 2000 | 1 | S3
 |  |  |  |  |  |  |  |  |  |  | 86418000 | text26 | 4000 | 1 | S2
 |  |  |  |  |  |  |  |  |  |  | 86932900 | text41 | 600 | 2 | S5
 |  | How I want it
 |  | SKU | Desc | Packs | Order | Type
 |  | 86932400 |  |  |  | S5
 |  | 86934800 |  |  |  | S5
 |  | 86932300 |  |  |  | S3
 |  | 86780600 |  |  |  | S3
 |  | 86418000 |  |  |  | S2
 |  | 86932900 |  |  |  | S5