tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 827838d1683055686-help-with-formula-to-find-if-nth-day-of-month-falls-between-2-dates-example-sheet-etaf
Sheet: Sheet1

Start Date | End Date | Includes the 12th? | Formula1 | Formula2 | Formula3
2022-12-19 00:00:00 | 2023-01-01 00:00:00 | NO |  |  |  |  |  | 12th falls between 4/10 and 4/23, in
2023-01-01 00:00:00 | 2023-01-01 00:00:00 | NO
2023-01-02 00:00:00 | 2023-01-15 00:00:00 | YES
2023-01-16 00:00:00 | 2023-01-29 00:00:00 | NO
2023-01-30 00:00:00 | 2023-02-12 00:00:00 | YES
2023-02-13 00:00:00 | 2023-02-26 00:00:00 | NO
2023-02-27 00:00:00 | 2023-03-12 00:00:00 | YES
2023-03-13 00:00:00 | 2023-03-26 00:00:00 | NO
2023-03-27 00:00:00 | 2023-04-09 00:00:00 | NO
2023-04-10 00:00:00 | 2023-04-23 00:00:00 | YES
Spreadsheet: 682183d1591956235-compute-text-that-is-in-another-column-based-on-a-match-development-rev-crease
Sheet: Example

 |  |  |  |  |  |  |  |  | Solid Board |  | 0.7 | 0.8 | 1
 |  |  |  |  |  |  |  |  | Thickness | 0.65
 |  |  |  |  |  |  |  |  | Product Code |  | Recommended | SRBA/BABS
 |  |  |  |  |  |  |  |  |  |  |  | XR-270-010
 |  |  |  |  |  |  |  |  | Corrugated |  | 1 | 1.1 | 1.2 | 1.5 | 2 | 2.5 | 3
 |  |  |  |  |  |  |  |  | Thickness | 0.6
 |  |  |  |  |  |  |  |  | Product Code |  | Recommended
Spreadsheet: 768489d1644998981-formula-to-extract-rows-that-meet-certain-criteria-into-another-table-example
Sheet: 1

MRCR PROJECT PURCHASE ORDERS
PURCHASE ORDER DETAILS |  |  |  |  |  | PO BALANCE
P.O.# | Item Description | Project Component | Task | Supplier | Priority | PO Total | Actual Expenses | Remaining Balance
8950 | Finalisation Master Plan, incl. traffic consultancy | Finalising master plan | Finalisation Master Plan | Company 1 | 0 | 31913 | 20613 | 11300
8366 | Catering for core user workshops | Finalising master plan | Finalisation Master Plan | Company 2 | 0 | 218 | 218.18 | -0.1800000000000068
8159 | Display ad - Community consultation | Finalising master plan | Finalisation Master Plan | Company 3 | 3 | 30 | 30 | 0
8232 | Catering for core user workshops | Finalising master plan | Finalisation Master Plan | Company 4 | 4 | 109 | 109.09 | -0.09000000000000341
8160 | Display ad - Community consultation | Finalising master plan | Finalisation Master Plan | Company 5 | 1 | 25 | 25 | 0
8483 | Public notice - Community consultation | Finalising master plan | Finalisation Master Plan | Company 6 | 0 | 191 | 190.91 | 0.09000000000000341
8443 | Display ad - Community consultation | Finalising master plan | Finalisation Master Plan | Company 7 | 0 | 166 | 166.42 | -0.4199999999999875
Spreadsheet: 535482d1503850787-stock-prices-gaps-maybe-countif-tough-gapstats-formulas
Sheet: Sheet1

Date | Open | Close | Gapstat |  | [NAME] gap | Min gap | Ave gap
2017-08-01 00:00:00 | 102 | 100 |  |  |  |  |  |  |  |  |  |  |  | ???
2017-08-02 00:00:00 | 99 | 92
2017-08-03 00:00:00 | 90 | 93
2017-08-04 00:00:00 | 91 | 87
2017-08-05 00:00:00 | 90 | 95
2017-08-06 00:00:00 | 96 | 100
2017-08-07 00:00:00 | 99 | 103 |  |  |  |  |  |  |  | [NAME]
2017-08-08 00:00:00 | 105 | 100
2017-08-09 00:00:00 | 97 | 101
2017-08-10 00:00:00 | 103 | 95 |  |  |  |  |  |  |  |  |  |  |  | ???
 |  |  |  |  |  | % times | number times | ave % gain/loss
 |  |  | gap down, dropped (P1) |  |  |  |  |  |  | ave |  |  |  | ???
AREA OF DICUSSION  ->> |  |  | gap down, reverse (P2)
 |  |  | gap up, reverse (P3)
 |  |  | gap up, gain (P4) |  |  |  |  |  |  | min
 | FROM A REAL EXAMPLE ->
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ???
Spreadsheet: kate_symes__18851__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-14 00:00:00 |  | 211.45 | 25360 | 172.67 | 8512
 | 2001-03-13 00:00:00 |  | 211.79 | 20960 | 168.03 | 9088 | 235.45 | 33 | 150.36 | 445
 | 2001-03-12 00:00:00 |  | 263.78 | 24240 | 255.08 | 7632 | 223.3 | 996 | 176.32 | 106
 | 2001-03-11 00:00:00 |  | 265 | 0 | 230 | 200 | 219.32 | 111 | 174.9 | 264 |  | 255.41 | 23256
 | 2001-03-10 00:00:00 |  | 224.71 | 20800 | 190.8 | 6912 | 247.11 | 873 | 227.78 | 709
 | 2001-03-09 00:00:00 |  | 224.71 | 20800 | 190.8 | 6912 | 277.5 | 52 | 230.19 | 982
 | 2001-03-08 00:00:00 |  | 262.5 | 14400 | 203.46 | 4624 | 282.12 | 2609 | 247.42 | 748
 | 2001-03-07 00:00:00 |  | 332.94 | 26544 | 285.65 | 15720 | 330.51 | 717 | 232.25 | 507
 | 2001-03-06 00:00:00 |  | 342.28 | 17200 | 304.1 | 7232 | 336.81 | 452 | 233.81 | 624
 | 2001-03-05 00:00:00 |  | 322.23 | 12560 | 296.39 | 4712 | 305.57 | 470 | 252.06 | 1447
 | 2001-03-04 00:00:00 |  | 310 | 0 | 270 | 0 | 289.47 | 475 | 246.67 | 375 |  | 296.48 | 15336
 | 2001-03-03 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 250.36 | 685 | 281.25 | 160
 | 2001-03-02 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 377.23 | 90 | 300 | 100
 | 2001-03-01 00:00:00 |  | 298.9 | 27200 | 269.54 | 7872 | 372.61 | 244 | 255 | 160
 | 2001-02-28 00:00:00 |  | 200.96 | 25024 | 183.83 | 13864 | 316.43 | 2298 | 258.89 | 1480
 | 2001-02-27 00:00:00 |  | 201.92 | 15424 | 178.85 | 6464 | 244.23 | 455 | 204.11 | 1255
 | 2001-02-26 00:00:00 |  | 245.45 | 11424 | 227.06 | 6928 | 198.18 | 550 | 160 | 50
 | 2001-02-25 00:00:00 |  | 240 | 800 | 210 | 0 | 173.83 | 962 | 159.04 | 584 |  | 227.06 | 20784
 | 2001-02-24 00:00:00 |  | 194.5 | 20624 | 152.04 | 7328 | 186.82 | 2727 | 184.22 | 870
 | 2001-02-23 00:00:00 |  | 194.65 | 20624 | 152.04 | 7328 | 278.92 | 300 | 186.49 | 208
 | 2001-02-22 00:00:00 |  | 253.75 | 17824 | 217.96 | 5880 | 190.34 | 576 | 143.24 | 795
 | 2001-02-21 00:00:00 |  | 291.88 | 11824 | 261.34 | 6928 | 295 | 50 | 220.57 | 485
 | 2001-02-20 00:00:00 |  | 326.7 | 22224 | 310.97 | 5328 | 275 | 78 | 222.94 | 375
 | 2001-02-19 00:00:00 |  | 326.67 | 22624 | 310.97 | 5328 | 335.35 | 174 | 259.78 | 115
 | 2001-02-18 00:00:00 |  | 325 | 800 | 310 | 0 | 275.26 | 476 | 266.22 | 555 |  | 336.69 | 11784
 | 2001-02-17 00:00:00 |  | 349.98 | 15824 | 336.58 | 3800 | 347.69 | 281 | 332.5 | 0
 | 2001-02-16 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 397.28 | 230 | 350 | 40
 | 2001-02-15 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 348.8 | 1693 | 398.23 | 784
 | 2001-02-14 00:00:00 |  | 327.05 | 15664 | 314.82 | 3928 | 479.05 | 452 | 472.12 | 165
 | 2001-02-13 00:00:00 |  | 335.68 | 13424 | 322.6 | 4728 | 386.38 | 1053 | 330 | 0
 | 2001-02-12 00:00:00 |  | 302.64 | 12624 | 279.2 | 4528 | 271.84 | 1346 | 324.32 | 544
 |  |  |  |  |  | ..
Spreadsheet: 547581d1510635404-how-to-merge-tabs-and-make-the-columns-inside-each-tab-alternate-with-each-other-how-to-merge-tabs-and-make-the-columns-inside-each-tab-alternate-with-each-other
Sheet: Sheet2

Tab2 Col1 | Tab2 Col2 | Tab2 Col3
5 | 12 | 3
6 | 13 | 4
7 | 14 | 5
8 | 15 | 6
9 | 16 | 7
10 | 17 | 8
11 | 18 | 9
12 | 19 | 10
Spreadsheet: 598459d1542486573-lookup-functions-to-skip-over-blanks-book1
Sheet: Sheet2

DATA SET |  |  |  |  | MY GOALS
Earmark | Item | Sub Category | Cost |  | Based on the values "C" or "s" from Column (A), I want to pull the data from the same Row in columns (B, C, D)  so a new list is created and it skips over lookups if there is a blank in Column (A)
C | TRIPS:
s |  | NYC | 1
 |  |  | 2 |  | This is what I hope the new list looks like
 |  | CA | 3 |  | Category | Cost
s |  | FL | 4 |  | TRIPS
s |  | FL | 5 |  | NYC | 1
 |  | FL | 6 |  | FL | 4
s |  | MA | 7 |  | FL | 5
s |  | CA | 8 |  | FL | 6
s |  | TX | 9 |  | MA | 7
 |  |  |  |  | CA | 8
C | EVENTS: |  |  |  | TX | 9
s |  | XMAS | 10 |  | EVENTS
s |  | EASTER | 11 |  | XMAS | 10
s |  | HALLOWEEN | 12 |  | EASTER | 11
 |  |  |  |  | HALLOWEEN | 12
 | My Mini-dashboard | Red cells = the errors I'm trying to avoid
 | Item | Cost
 |  |  | I would want this to return a blank value (not a 0)
 |  |  |  |  | The [NAME] Used:
 |  |  |  |  | Column "Item": | IF(A3="","",IFERROR(VLOOKUP("C",A3:D3,2,0),IFERROR(VLOOKUP("s",A3:D3,3,0),)))
 |  |  |  |  | Column "Cost": | IF(A3="","",IFERROR(VLOOKUP("C",A3:D3,4,0),IFERROR(VLOOKUP("s",A3:D3,4,0),)))
Spreadsheet: 145177d1331342580-need-help-on-if-then-and-vlookup-sambuka_excel-help2_09mar12_01
Sheet: Results

Malbec |  | Argentina
item ID | Description | Size | Pk | Varietal | Region | App | Sub App
Chardonnay |  | USA
item ID | Description | Size | Pk | Varietal | Region | App | Sub App
Spreadsheet: a984cf02-7510-4d84-b18e-4f9086984606
Sheet: QTD Recon Q2FY09

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended September 30, 2008
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Strategic Investments |  | Restructuring Charges |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 894 |  | 0 |  | 232 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1126
Cost of goods sold | 557 |  | -4 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 553
Gross profit | 337 |  | 4 |  | 232 |  | 0 |  | 0 |  | 0 |  | 0 |  | 573
Operating expenses:
Marketing and sales | 197 |  | 0 |  | 0 |  | 0 |  | 0 |  | -5 |  | 0 |  | 192
General and administrative | 92 |  | 0 |  | 0 |  | 0 |  | 0 |  | -13 |  | 0 |  | 79
Research and development | 372 |  | 0 |  | 0 |  | 0 |  | 0 |  | -35 |  | 0 |  | 337
Amortization of intangibles | 16 |  | -16 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Certain abandoned acquisition-related costs | 21 |  | -21 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring charges | 3 |  | 0 |  | 0 |  | 0 |  | -3 |  | 0 |  | 0 |  | 0
Total operating expenses | 701 |  | -37 |  | 0 |  | 0 |  | -3 |  | -53 |  | 0 |  | 608
Operating loss | -364 |  | 41 |  | 232 |  | 0 |  | 3 |  | 53 |  | 0 |  | -35
Loss on strategic investments | -34 |  | 0 |  | 0 |  | 34 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 7 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 7
Loss before benefit from income taxes | -391 |  | 41 |  | 232 |  | 34 |  | 3 |  | 53 |  | 0 |  | -28
Benefit from income taxes | -81 |  |  |  |  |  |  |  |  |  |  |  | 73 |  | -8
Net loss | -310 |  | 41 |  | 232 |  | 34 |  | 3 |  | 53 |  | -73 |  | -20
Loss per share |  |  |  |  |  |  |  |  |  |  | Loss per share
Basic and diluted | -0.97 |  |  |  |  |  |  |  |  |  | Basic and diluted |  |  |  | -0.06
Number of shares used in computation |  |  |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic and diluted | 319 |  |  |  |  |  |  |  |  |  | Basic and diluted |  |  |  | 319
Spreadsheet: 275b06ab-3b7f-4388-9533-7f93a27b8369
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 80. Value of Building Approved, Chain Volume Measures, Original - Victoria
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Total value of building jobs ;  Chain Volume Measures ;  Victoria ;  Houses ;  New ; |  |  | Original | A590487F | 1985-09-01 00:00:00 | 2013-06-01 00:00:00 | 112 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Victoria ;  Total Other Residential ;  New ; |  |  | Original | A590488J | 1985-09-01 00:00:00 | 2013-06-01 00:00:00 | 112 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Victoria ;  [NAME] ;  New ; |  |  | Original | A590489K | 1985-09-01 00:00:00 | 2013-06-01 00:00:00 | 112 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Victoria ;  [NAME] ;  Alterations and additions including conversions ; |  |  | Original | A590490V | 1985-09-01 00:00:00 | 2013-06-01 00:00:00 | 112 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Victoria ;  [NAME] ;  Total Work ; |  |  | Original | A590491W | 1985-09-01 00:00:00 | 2013-06-01 00:00:00 | 112 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Victoria ;  [NAME]-residential ;  Total Work ; |  |  | Original | A590492X | 1985-09-01 00:00:00 | 2013-06-01 00:00:00 | 112 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Victoria ;  Total (Type of Building) ;  Total Work ; |  |  | Original | A590493A | 1985-09-01 00:00:00 | 2013-06-01 00:00:00 | 112 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: eric_saibi__9878__102201R
Sheet: Stryker  Creek 01

Owner Name |  | TXU
Station Name |  | Stryker Creek Power Station
Unit Name |  | Unit 01
NERC Region |  | ERCOT
State |  | TX
Fuel Type |  | Nat. gas/Fuel Oil
Capacity |  | 177 MW
Start Date |  | 2001-11-02 00:00:00
End Date |  | 2001-11-15 00:00:00
Prv. Start Date |  | 2001-10-19 00:00:00
Prv. End Date |  | 2001-11-01 00:00:00
Comments |  | [NAME] insp.
SIC |  | 4911
Plant ID |  | 1000059
Unit ID |  | 1008591
Outage ID |  | 17978
Spreadsheet: 101804d1299850422-lookup-quantity-of-part-by-warehouse-copy-of-parts-lookup
Sheet: Inventory

 | Part | Description | Warehouse | Quantity
 | 1452 | DECAL STAND CLEAR LONG | 2300 | 0
 | 1453 | DECAL-CAUTION AUTOMATIC DOOR | 2300 | 6
 | 1454 | DECAL-DO NOT ENTER/IN | 2300 | 4
 | 1455 | DECAL-DO NO ENTER/OUT | 2300 | 0
 | 1456 | DECAL-IN EMERGENCY PTO | 2300 | 0
 | 1457 | DECAL-HANDICAP LOGO | 2300 | 0
 | 1452 | DECAL STAND CLEAR LONG | 2301 | 0
 | 1453 | DECAL-CAUTION AUTOMATIC DOOR | 2301 | 16
 | 1454 | DECAL-DO NOT ENTER/IN | 2301 | 5
 | 1455 | DECAL-DO NO ENTER/OUT | 2301 | 5
 | 1456 | DECAL-IN EMERGENCY PTO | 2301 | 5
 | 1457 | DECAL-HANDICAP LOGO | 2301 | 5
 | 1452 | DECAL STAND CLEAR LONG | 2350 | 0
 | 1453 | DECAL-CAUTION AUTOMATIC DOOR | 2350 | 3
 | 1454 | DECAL-DO NOT ENTER/IN | 2350 | 2
 | 1455 | DECAL-DO NO ENTER/OUT | 2350 | 0
 | 1456 | DECAL-IN EMERGENCY PTO | 2350 | 0
 | 1457 | DECAL-HANDICAP LOGO | 2350 | 0
 | 1452 | DECAL STAND CLEAR LONG | 2351 | 0
 | 1453 | DECAL-CAUTION AUTOMATIC DOOR | 2351 | 1
 | 1454 | DECAL-DO NOT ENTER/IN | 2351 | 12
 | 1455 | DECAL-DO NO ENTER/OUT | 2351 | 0
 | 1456 | DECAL-IN EMERGENCY PTO | 2351 | 0
 | 1457 | DECAL-HANDICAP LOGO | 2351 | 0
Spreadsheet: 777406d1650371469-multiple-if-statements-with-countifs-on-call-example-1-
Sheet: SERVICE - CALCULATION

 | PAYROLL PERIOD: |  |  | 2022-03-14 00:00:00 |  |  |  |  |  |  |  |  |  | 2022-03-20 00:00:00 |  |  |  |  |  |  |  | 19
TECH # | Technician | Report Name | [NAME] | Billable Hours Paid | Hours Worked |  | Efficiency | Base Rate | On-Call Adj. | BHE Rate Adj. | Adj. Base Rate | Reg. Hours | OT Hours | Regular Pay | OT Pay | OT Rate | Cash Income | Install Turnover Revenue Comm. | Total Pay | Total Sales | Total Revenue | Pct. Of Revenue to Pay | Call Backs | Revenue per BH | ADP Total Pay
1 | Employee 1 | Employee 1 | Employee 1 | 11.8 | 29.55 | 0.3993231810490694 | 0.3993231810490693 |  | 0 | 2.5 | 2.5 | 29.55 | 0 | 73.87500000000001 | 0 | 0 | 0 | 0 | 73.87500000000001 | 4794.88 | 4864.8 | 0.01518561914158856 | 0 | 412.271186440678
2 | Employee 2 | Employee 2 | Employee 2 | 31.33 | 39.45 | 0.794169835234474 | 0.7941698352344739 |  | 2 | 22.5 | 22.5 | 39.45 | 0 | 887.6250000000001 | 0 | 0 | 270 | 0 | 887.6250000000001 | 24672.47 | 12291.208 | 0.07221625408991533 | 5 | 392.3143313118417
3 | Employee 3 | Employee 3 | Employee 3 | 26.41 | 41.91666666666667 | 0.6300596421471173 | 0.6300596421471172 |  | 0 | 14.5 | 14.5 | 40 | 1.916666666666671 | 580 | 41.6875000000001 | 21.75 | 0 | 0 | 621.6875000000001 | 14001.27 | 11335.01 | 0.05484666533157007 | 2 | 429.1938659598637
4 | Employee 4 | Employee 4 | Employee 4 | 14.075 | 41.03333333333333 | 0.3430138099108739 | 0.3430138099106417 |  | 2 | 0 | 0 | 40 | 1.033333333333331 | 0 | 2.833062550771726 | 2.741673436230707 | 75 | 0 | 2.833062550771726 | 7627.48 | 4736.96 | 0.00059807609749116 | 1 | 336.5513321492007
5 | Employee 5 | Employee 5 | Employee 5 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 719413d1613658835-sumifs-formula-not-valid-value-hh_job_-template_2021
Sheet: Bonus WK 3

 | Week 3 - Bonus Hours
 | Begin Date:
 | End Date:
 | Employee | Bonus Hours
Spreadsheet: 133690d1324548771-positive-negative-and-the-odious-div-0-p-and-l2008help-sirwilliam
Sheet: Jan

Profit and Loss Statement |  | Tax Year: | 2008 | January
[NAME] |  | Monthly Summary | Total Income
 |  |  | Total Expense
Gross margin  [L/J] |  |  | Profit / (Loss)
Return on sales  [T/J]
 | Prior Period | Current Period | Current Period as    % of Sales | % Change from Prior Period
Sales Revenue
Health Insurance
Medicare Advantage
Medicare Supplement
Life Insurance |  | 2900
Investment (Annuity)
Other
Total Sales Revenue  [J]
Cost of Sales
Specify
Total Cost of Sales  [K]
Gross Profit  [L=J-K]
Operating Expenses
Sales and Marketing
Advertising (Radio, TV, Print Media, etc)
Printing |  | 58
Direct marketing
Seminar
Meals and Entertainment
Total Sales and Marketing Expenses  [M]
Research & Development
Licenses |  | 125
Education
Total Research & Development Expenses  [N]
General and Adminstrative
Rent
Payroll
Utilities
Telephone
Health Insurance
E&O Insurance
Software
Web Hosting and domains
Postage
Office Supplies
Equipment
Repairs and maintenance
Other expenses (specify)
Auto (Tires, Fuel, Oil, Tolls, [NAME], etc)
Auto Mileage (IRS standard deduction; averaged) |  | 510
Total General & Adminstrative Expenses  [O]
Total Operating Expenses  [P=M+N+O]
Income from Operations  [Q=L-P]
Other Income (Bonuses) [R]
Taxes
Payroll Taxes
Property Taxes
Total Taxes  [S]
Net Profit  [T=Q+R-S]
Spreadsheet: 110795d1307395371-sumif-for-forum
Sheet: Sheet1

 |  | Booking Channel | Number of Bookings |  | Total
 |  | Web | 7 |  | Web
 |  | Web | 8 |  | Call Center | 44
 |  | ABE1 | 6 |  | On Site | 27
 |  | FGR2 | 9
 |  | Web | 2
 |  | DCHAPMAN | 7
 |  | BHOPE | 12
 |  | FGH3 | 12
 |  | Web | 36
 |  | BBROWN | 25
Spreadsheet: 49225d1248457905-working-with-scaling-prices-slidingscale
Sheet: Question4

 |  | Ads bought | Price per ad
 |  | 1-5 | 12000
 |  | 6-10 | 11000
 |  | 11-20 | 10000
 |  | 20 or more | 9000
 |  | Price table
 |  | Ads bought | Price per ad | breakpoint |  | Ads bought | bpoint1 | [NAME] | bpoint3 | total price
 |  | 1 | 12000 | 0 |  | 7
 |  | 5 | 12000 | 60000
 |  | 6 | 11000 | 60000
 |  | 10 | 11000 | 115000
 |  | 11 | 10000 | 115000
 |  | 20 | 10000 | 215000
 |  | 21 | 9000 | 215000
Spreadsheet: drew_fossum__8874__01_19_00StanH_mtg_final
Sheet: NNG 99 Plan to Actuals

 |  | Enron Transportation & Storage
 |  | Northern Natural Gas Company
 |  | 1999 Actuals  to 1999 Plan
 |  | Revenue/Margin Summary
 | [NAME] From 1999 Plan vs  1999Actuals |  |  | $Millions
 |  | 1999 Plan  Revenues |  | 457.6
 | NNG
 | Midwest |  |  | -0.1 |  | Ups: Base Variable + 1.2,Rate Case impact+3.5,  [NAME]: Commodity-1.1,Surcharges-1.3,East Leg-1.4, Risk [NAME] -1.3.
 | South Onshore |  |  | -4.5 |  | Ups: Transco+.5,  [NAME] (ENA) and Commodity price increase+1.9,  Downs: Bushton/Plants-3.1, Ok-Ks East-.8,Tx Direct -1.1other vol/rate&stretch -1.9
 | South Offshore |  |  | -0.7 |  | Production Decline
 | Storage |  |  | 0.6 |  | Increased IDD
 | Other |  |  | -3 |  | Downs: DDVC-.4, Revenue goal tied to rate case-1.7, November rate case to keep-.6 other -.3.
 | TOTAL NNG
 | G.L. to Accounting Month Difference |  |  | -0.2 |  | Flash to actual, PPA's
 | SUBTOTAL NNG
 |  | 1999 Actual Revenues
 |  | Less: Carlton |  | 1.5
 |  | 1999 Actual Margin
 |  |  | TOTAL NNG
 |  |  | Add back GRI  surcharges | 1.3
 |  |  | Add back Depreciation/Revenue goal | 1.7
 |  |  | TOTAL
Spreadsheet: 690171d1596909601-ref-when-using-index-match-match-with-tables-excel-query
Sheet: July Bank Statement

Date | Column1 | Description | Column2 | Money in | Money Out | Balance | Keyword | Category | Month | Column3
2020-07-15 00:00:00 |  | DIRECT DEBIT PAYMENT TO N E DERBYSHIRE D C |  |  | 129
2020-08-01 00:00:00 |  | DIRECT DEBIT PAYMENT TO DVLA |  |  | 41.56
Spreadsheet: 802509d1666887588-count-total-occurrences-without-counting-duplicates-2023-interview-tracker-jkauffmandav-
Sheet: Interview Log

Date | [NAME] | NSO | Check In | Scheduled Time | Start | End | Gross Wait Time | Net Wait Time | Interview Length | Interview Day
2023-01-01 00:00:00 |  | [NAME] | 10:16:00 | 10:30:00 | 10:25:00 | 10:47:00
2023-01-01 00:00:00 |  | [NAME] | 11:03:00 | 11:15:00 | 11:16:00 | 11:30:00
2023-01-01 00:00:00 |  | [NAME] | 11:54:00 | 12:00:00 | 11:57:00 | 12:08:00
2023-01-01 00:00:00 |  | [NAME] | 12:08:00 | 12:15:00 | 12:10:00 | 12:16:00
2023-01-01 00:00:00 |  | [NAME] | 12:15:00 | 12:30:00 | 12:17:00 | 12:45:00
2023-01-01 00:00:00 |  | [NAME] | 12:45:00 | 13:00:00 | 12:47:00 | 13:09:00
2023-01-01 00:00:00 |  | [NAME] | 13:23:00 | 14:00:00 | 13:55:00 | 14:10:00
2023-01-01 00:00:00 |  | [NAME] | 13:59:00 | 14:15:00 | 14:15:00 | 14:24:00
2023-01-01 00:00:00 |  | Butler | 15:11:00 | 15:15:00 | 15:15:00 | 15:35:00
2023-01-01 00:00:00 |  | DSO | 08:30:00 | 08:45:00 | 09:10:00 | 09:30:00
2023-01-01 00:00:00 |  | [NAME] | 08:31:00 | 08:45:00 | 08:44:00 | 09:12:00
2023-01-01 00:00:00 |  | [NAME] | 08:59:00 | 09:15:00 | 09:15:00 | 09:40:00
2023-01-01 00:00:00 |  | DSO | 09:14:00 | 09:45:00 | 09:55:00 | 10:20:00
2023-01-01 00:00:00 |  | DSO | 11:23:00 | 11:30:00 | 11:30:00 | 12:20:00
2023-01-02 00:00:00 |  | [NAME] | 11:30:00 | 11:45:00 | 11:50:00 | 12:23:00
2023-01-02 00:00:00 |  | [NAME] | 13:30:00 | 14:00:00 | 14:00:00 | 14:21:00
2023-01-02 00:00:00 |  | DSO | 13:55:00 | 14:30:00 | 14:30:00 | 15:25:00
2023-01-02 00:00:00 |  | Butler | 08:39:00 | 09:00:00 | 09:00:00 | 09:25:00
2023-01-02 00:00:00 |  | [NAME] | 09:40:00 | 09:45:00 | 09:44:00 | 10:10:00
2023-01-02 00:00:00 |  | [NAME] | 11:15:00 | 11:15:00 | 11:15:00 | 11:30:00
2023-01-03 00:00:00 |  | [NAME] | 11:20:00 | 11:30:00 | 11:30:00 | 12:00:00
2023-01-03 00:00:00 |  | Butler | 08:30:00 | 08:45:00 | 08:35:00 | 09:45:00
2023-01-03 00:00:00 |  | DSO | 08:44:00 | 08:45:00 | 09:00:00 | 10:00:00
2023-01-03 00:00:00 |  | Butler | 09:07:00 | 09:15:00 | 09:25:00 | 10:25:00
2023-01-03 00:00:00 |  | Butler | 09:21:00 | 09:30:00 | 10:15:00 | 10:45:00
2023-01-03 00:00:00 |  | DSO | 09:26:00 | 10:00:00 | 11:10:00 | 11:20:00
2023-01-03 00:00:00 |  | Butler | 09:43:00 | 09:45:00 | 10:38:00 | 11:20:00
2023-01-03 00:00:00 |  | Butler | 09:44:00 | 11:00:00 | 11:00:00 | 11:30:00
2023-01-05 00:00:00 |  | DSO | 09:47:00 | 11:00:00 | 11:30:00 | 12:15:00
2023-01-05 00:00:00 |  | Butler | 10:43:00 | 11:00:00 | 11:39:00 | 12:07:00
2023-01-05 00:00:00 |  | Butler | 11:17:00 | 11:30:00 | 11:35:00 | 11:50:00
2023-01-05 00:00:00 |  | [NAME] | 12:35:00 | 12:45:00 | 12:42:00 | 12:53:00
2023-01-06 00:00:00 |  | Butler | 13:00:00 | 13:00:00 | 13:00:00 | 14:10:00
2023-01-06 00:00:00 |  | Butler | 13:17:00 | 13:30:00 | 13:20:00 | 13:45:00
2023-01-06 00:00:00 |  | Butler | 13:58:00 | 14:00:00 | 14:10:00 | 15:00:00
Spreadsheet: 816710d1675789314-advanced-sorting-formula-sample-file
Sheet: Sheet1

List A |  |  | List B |  |  | Output
Identifier | Number |  | Identifier | Text |  | Identifier | Number | Text
11111 | 10 |  | 11111 | Alpha |  | 11111 | 10 | Alpha
11112 | 20 |  | 11112 | Bravo |  | 11112 | 20 | Bravo
11113 | 30 |  | 11113 | [NAME] |  | 11113 | 30 | [NAME]
11114 | 40 |  | 22222 | Delta
11115 | 50 |  | 22223 | Echo