tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: Gas Stlmts

Gas Settlements
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90129547 | ALBA, MARY A | Staff [NAME] | SPECJR-CS
90005877 | BAXTER, [NAME] | Mgr Settlements | MGR-CS
90011566 | BRUCE, MICHELLE S | [NAME] | DIR-CS
90011659 | CASH, [NAME] | Spec Accounting | SPEC-CS
90141275 | CASHIN, JANINE T | Spec Sr Settlements | SPECSR-CS
90159502 | DHONT, MARGARET D | Mgr Settlements | MGR-CS
90129531 | DOZIER, [NAME] | Spec Settlements | SPEC-CS
90011664 | ELLENBERGER, MARY S | Spec Sr Settlements | SPECSR-CS
90011660 | EUBANKS JR, [NAME] | Spec Settlements | SPEC-CS
90011661 | EWING, [NAME] | Spec Settlements | SPEC-CS
90130386 | HAMIC, PRISCILLA | Spec Settlements | SPEC-CS
90011591 | HANSON, KRISTEN J | Mgr Trans Supt | MGR-CS
90011707 | HUNTLEY, KELLEY J | Spec Sr Settlements | SPECSR-CS
90125285 | JACOBS, [NAME] | Spec Settlements | SPEC-CS
90006612 | [NAME], PAULA M | SR CLERK | ADMSR-CS
90157609 | MCFATRIDGE, TOM E | Mgr Settlements | MGR-CS
90125454 | MENDOZA, GENARO | Spec Settlements | SPEC-CS
90132996 | NELSON, DOUGLAS J | Spec Sr Settlements | SPECSR-CS
90145102 | OBEY, RENA T | Spec Settlements | SPEC-CS
90011665 | PRICE, WADE R | Spec Sr Settlements | SPECSR-CS
 |  | Employees
Spreadsheet: 174240d1344970754-macro-and-spreadsheet-design-brown-8-7h-daily-reports
Sheet: 8.13.12

Well-site Geology |  | Well Logging, Inc. |  |  |  |  |  |  | OFFICE [NAME]
[NAME] |  | Route 1, Box 111 |  |  |  |  |  |  | MOBILE XXX-XXX-XXXX
 |  | CITY, TX  XXXXX
 |  | Daily Report
 |  |  |  |  |  | Time | 06:00:00
Operator…ENERGY COMPANY |  |  |  |  |  | Date | 2012-08-13 00:00:00 | Spud | 2012-07-15 00:00:00
Well… | BROWN 8-7H |  | SEC 8-BLK 1 /CAMP CCSL SURVEY |  |  | Day No. |  | Days Logging
Location… WHEELER TX |  |  |  |  |  | OPERATION |  | TRIPPING
[NAME]…JON DOE….. |  |  |  |  |  | Depth | 11282
Contracter…….. DRILLING COMPANY |  |  |  |  |  | 245 | made in | 14.5 | HRS / DRLG
Drilling Foreman……. [NAME] ……. |  |  |  |  |  | R.O.P. |  | Ft/Hr
[NAME]… DUSTIN STEWART ………… XXX-XXX-XXXX
BG | 450 - 488 UNITS |  | Flowline | X | Sep |  | Flare |  | Chokes
CG/DTG | 454 - 603 UNITS |  | Flowline | X | Sep |  | Flare |  | Chokes
Trip Gas | N/A |  | Flowline | X | Sep |  | Flare |  | Chokes
Lithology @ 11,260' -- 98% SAND,  2% SHALE
MUD CHECK |  | WOB | 33 | INC | 90.46 | NB # 8 | VAREL VM613P |  | IN AT | 10472
M.D. | 11136 | RPM | 80 | AZI | 0.41 |  | MADE |  | IN | 45
WT | 8.25 | PP | 3300 | MD | 11215 | HOURS | R.O.P. |  | FT./HR.
VIS | 63 | SPM | 140 | TVD | 10213.37 | OB# 7 | MADE | 637 | IN | 33
PV | 20 |  |  |  |  |  | R.O.P. |  | FT/HR.
YP | 23
GEL | 13/17/19 |  | GAS SHOW @
HTHP | 4 |  |  | BEFORE |  | DURING |  | AFTER
CAKE | 00/2 |  | ROP
SOL | 0.039 |  | GAS
OIL | 0.817 |  | LITH:
H2O | 0.12
CL | 52000 |  | ROP
CA | 28200 |  | GAS
LIME | 3.37 |  | LITH:
ES | 1091
 |  |  | ROP
 |  |  | GAS
 |  |  | LITH:
REMARKS: |  |  |  |  |  |  |  | [NAME] TOPS
0600 - 1330 -  DRILL 11037-11146 |  |  |  |  |  |  |  | ANYHYDRITE 3,700'
1330 - 1400 -  LUBE RIG |  |  |  |  |  |  |  | BROWN DOLO 4,508'
1400 - 1730 -  DRILL 11146-11223 |  |  |  |  |  |  |  | PENN SHALE 6,348'
1730 - 1800 -  SURVEYS @ 10994 11026  11057  11089  11152 |  |  |  |  |  |  |  | BASE HEEBNER 8,348'
1800 - 2130 -  DRILL 11223-11282 |  |  |  |  |  |  |  | COTTAGE GROVE 9,760'
2130 - 2330 -  CONDITION AND CIRCULATE |  |  |  |  |  |  |  | HOGSHOOTER 10,050'
2330 - 0600 -  TOOH |  |  |  |  |  |  |  | CALDWELL 11,400'
 |  |  |  |  |  |  |  | CHEROKEE 11,480'
 |  |  |  |  |  |  |  | GRANITE WASH A 11,640'
 |  |  |  |  |  |  |  | GRANITE WASH B 11,843'
 |  |  |  |  |  |  |  | LANDING POINT 11,960'
Spreadsheet: 877350d1724155107-redundancy-calc-with-a-difference-a-formula-question-redundancy-calc-with-a-difference
Sheet: Sheet1

 | Redundancy Calc with a difference
 | https://www.excelforum.com/excel-formulas-and-functions/1427560-redundancy-calc-with-a-difference-a-formula-question.html
 |  |  |  |  | Age @ | Years | Age @ | 0.5 | 1.5 | 1.75 | Completed | Total
 | Employee Name | DOB | Hire Date | Exit Date | Hire | Worked | Exit | X | Y | Z | Years | Weeks
 | Empl 001
 | Empl 002
 | Empl 003
 | Empl 004
 | Empl 005
 | Empl 006
 | Empl 007
 | Empl 008
 | Empl 009
 | Empl 010
 | Empl 011
 | Empl 012
 | Empl 013
 | Empl 014
 | Empl 015
 | Empl 016
 | Empl 017
 | Empl 018
Spreadsheet: 489494d1479293614-index-match-not-working-ifcc-navic-upload
Sheet: Gantt

 | Today's Date |  |  |  |  |  |  |  |  |  |  |  |  |  | Spreadsheet123
 | Project Manager | Mr [NAME]
 | Week Starts from | Monday
 | Start Date | 2016-10-03 00:00:00
 |  | 0
WBS | Tasks Name | Assigned to: | Start Date | Duration | Act. Duration | Complete | Projected End | Actual End | Assigned | Act. Assigned | Complete | Act. Complete | Remaining | Act. Remaining
 | 16-223_CKB_BR_MELS
 | Doors | Deboer |  |  |  | 0.8
 | Trim | Kelly |  | 10 |  | 0.8
 | CustomCut | Ray |  | 2 |  | 0.6
 | Sanding |  |  | 1 |  | 0.6
 | Finishing |  |  | 2 |  | 0.6
 | BoxCut |  |  | 1 |  | 0.6
 | BoxAssembly |  |  | 1 |  | 0.5
 | DrawerAssembly |  |  | 1 |  | 0.5
 | CustAss+HangDoors |  |  | 1 |  | 0.5
 | CompletionAndCheck |  |  | 2 |  | 0.5
 | Ship |  | 2016-11-14 00:00:00 | 1 |  | 0.5
 | Project_2
 | Sub-Project-(Level 1) |  | 2015-01-01 00:00:00 | 14 |  | 0.8
 | Sub-Project-(Level 1) |  | 2015-01-02 00:00:00 | 22 |  | 0.8
 | Sub-Project-(Level 2) |  | 2014-12-31 00:00:00 | 5 |  | 0.6
 | Sub-Project-(Level 2) |  | 2015-01-01 00:00:00 | 2 |  | 0.5
 | Sub-Project-(Level 3) |  | 2015-01-01 00:00:00 | 2 |  | 0.5
 | Sub-Project-(Level 4) |  | 2015-01-01 00:00:00 | 4 |  | 0.5
 | Project_3
 | Sub-Project-(Level 1) |  | 2015-01-01 00:00:00 | 14 |  | 0.8
 | Sub-Project-(Level 1) |  | 2015-01-02 00:00:00 | 22 |  | 0.8
 | Sub-Project-(Level 2) |  | 2014-12-31 00:00:00 | 5 |  | 0.6
 | Sub-Project-(Level 2) |  | 2015-01-01 00:00:00 | 2 |  | 0.5
 | Sub-Project-(Level 3) |  | 2015-01-01 00:00:00 | 2 |  | 0.5
 | Sub-Project-(Level 4) |  | 2015-01-01 00:00:00 | 4 |  | 0.5
 | Project_4
 | Sub-Project-(Level 1) |  | 2015-01-01 00:00:00 | 14 |  | 0.8
 | Sub-Project-(Level 1) |  | 2015-01-02 00:00:00 | 22 |  | 0.8
 | Sub-Project-(Level 2) |  | 2014-12-31 00:00:00 | 5 |  | 0.6
 | Sub-Project-(Level 2) |  | 2015-01-01 00:00:00 | 2 |  | 0.5
 | Sub-Project-(Level 3) |  | 2015-01-01 00:00:00 | 2 |  | 0.5
 | Sub-Project-(Level 4) |  | 2015-01-01 00:00:00 | 4 |  | 0.5
 | Project_5
 | Sub-Project-(Level 1) |  | 2015-01-01 00:00:00 | 14 |  | 0.8
 | Sub-Project-(Level 1) |  | 2015-01-02 00:00:00 | 22 |  | 0.8
 | Sub-Project-(Level 2) |  | 2014-12-31 00:00:00 | 5 |  | 0.6
 | Sub-Project-(Level 2) |  | 2015-01-01 00:00:00 | 2 |  | 0.5
 | Sub-Project-(Level 3) |  | 2015-01-01 00:00:00 | 2 |  | 0.5
 | Sub-Project-(Level 4) |  | 2015-01-01 00:00:00 | 4 |  | 0.5
TEMPLATE ROWS (do not modify)
 | Project_1A
 | Sub Project (Level 1) |  | 2015-01-01 00:00:00 | 14 |  | 0.8
 | Sub Project (Level 2) |  | 2014-12-31 00:00:00 | 5 |  | 0.6
 | Sub Project (Level 3) |  | 2015-01-01 00:00:00 | 2 |  | 0.5
 | Sub Project (Level 4) |  | 2015-01-01 00:00:00 | 4 |  | 0.5
Spreadsheet: 750408d1633441827-automating-color-coding-and-trend-help-needed-data-color-coding-request
Sheet: Sheet1

 | Computers
 | ServiceNow Fields: | Assigned to | Asset Function | [NAME] | Model | Acquisition Method | Computers not reporting Inventory | Cost
 | Total Records | 48940 | 48940 | 48940 | 48940 | 48940 | 48940 | 48940
 | Missing Data Records | 1100 | 0 | 4500 | 485 | 1000 | 1351 | 720
 | Percentage of Missing Data | 0.02247650183898652 | 0 | 0.09194932570494484 | 0.009910093992644054 | 0.02043318348998774 | 0.02760523089497344 | 0.01471189211279117
 | Server-(storage, Disk, Server)
 | ServiceNow Fields: | Serial Number | State | [NAME] | Model | Acquisition Method | Cost
 | Total Records | 2401 | 2401 | 2401 | 2401 | 2401 | 2401
 | Missing Records | 221 | 0 | 1886 | 597 | 1150 | 2347
 | Percentage of Missing Data | 0.09204498125780924 | 0 | 0.785506039150354 | 0.248646397334444 | 0.4789670970428988 | 0.9775093710953769
 | Network Gear
 | ServiceNow Fields: | Serial Number | State | [NAME] | Model | Acquisition Method | Cost
 | Total Records | 7287 | 7287 | 7287 | 7287 | 7287 | 7287
 | Missing Records | 188 | 677 | 7002 | 96 | 4746 | 7269
 | Percentage of Missing Data | 0.02579936873885001 | 0.09290517359681624 | 0.9608892548373816 | 0.01317414573898724 | 0.6512968299711815 | 0.9975298476739399
 | US Cycle Count 7/3/16
 | ServiceNow State: | In transit available | In stock available | In stock used | Pending repair | Data Retention
 | Total Records | 325 | 145 | 868 | 13 | 89
 | Missing Records | 325 | 145 | 868 | 13 | 89
 | [NAME] | 1 | 1 | 1 | 1 | 1
 | Asset Reconciliation 2016 |  | # of Remediated Records
 | 30+ Day Audits/Site Asset Reconciliation |  | 7104
 | VMware |  | 3422
 | WebServer, AppServer, Disk, ETC |  | 5812
 | Total Infrastructure Asset Record Clean up: |  | 9234
 | Duplicate Serial Number | Qty as of 6/22/2016 | Qty as of [NAME]
 | Comptuers | 187 | 0
 | Servers | 7225 | 454
 | Network Gear | 600 | 593
Spreadsheet: 113280d1309234466-condition-formatting-on-diagram-cfdiagram
Sheet: Diagram

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | Started | RFI | In Service
 |  |  |  |  |  |  | F |  |  |  |  |  |  |  |  | A | 2011-06-01 00:00:00 | 2011-06-07 00:00:00 | 2011-06-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 2011-06-13 00:00:00
 | A |  |  | D |  |  | H |  |  |  |  |  |  |  |  | D | 2011-06-04 00:00:00 | 2011-06-18 00:00:00 | 2011-06-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | 2011-06-05 00:00:00 | 2011-06-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
 | B |  |  |  |  |  | N |  |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L
 | C |  |  | E |  |  | L |  |  | O |  |  |  |  |  | M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O
 |  |  |  |  |  |  |  |  |  | P |  |  |  |  |  | Q
 | G |  |  |  |  |  | M |  |  | Q
 |  |  |  |  |  |  |  |  |  | J
 |  |  |  |  |  |  | K |  |  |  |  | I
 | - If A is already started, the color of the small box next to A should be in orange color
 | - If A is already RFI then the color of the small box next to A should be in grey color
 | - If A is already in service, the color of the small box next to A should be in Blue color
 | - Same condition to be applied to all tasks
Spreadsheet: 697545d1601398387-need-help-with-regression-analysis-sampledata_regression
Sheet: SampleData_Recoded

Crime | State |  |  |  |  |  |  |  |  |  |  |  |  |  | SUMMARY OUTPUT
2 | 1
2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Regression Statistics
1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Multiple R | 0.07841881126952242
6 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | R Square | 0.006149509960924976
1 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjusted R Square | -0.02934515039761342
6 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Standard Error | 1.818818942450231
5 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Observations | 30
5 | 3
6 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | ANOVA
4 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | df | SS | MS | F | [NAME]
2 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Regression | 1 | 0.5731343283582078 | 0.5731343283582078 | 0.1732516919110534 | 0.6804112666035729
5 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual | 28 | 92.6268656716418 | 3.308102345415779
5 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | 29 | 93.2
4 | 2
2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0%
3 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Intercept | 3.029850746268656 | 0.9492563295347368 | 3.191815163090554 | 0.003476359512813118 | 1.085387301455361 | 4.974314191081952 | 1.085387301455361 | 4.974314191081952
5 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | State | 0.1791044776119404 | 0.4302963885736666 | 0.4162351401684558 | 0.6804112666035724 | -0.70231771783106 | 1.060526673054941 | -0.70231771783106 | 1.060526673054941
1 | 2
3 | 1
1 | 2
3 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Model (State): | Crime | Rounded | Lookup Crime
4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
1 | 3
6 | 2
1 | 3
6 | 3
3 | 2
4 | 2
3 | 2
2 | 2
Spreadsheet: 21799f43-9f89-4645-b19a-e57aa5af79ab
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261335 | 66279 | Mami | Sato | JPN | 7 | 00:16:09 | 00:03:14 | 00:43:09 | [NAME] | 00:24:45 | 1 | 01:30:35
Spreadsheet: 136589d1326733632-listing-many-unique-values-based-on-an-if-statement-book3
Sheet: RawData

Participant # | Store | Reason | Other Places1 | Other Places2 | Other Places3
1 | World's Away | Convenient and store owner rocks! | Book Shop | Coffee Shop | Restaurant
2 | World's Away | Regular business/purchases/second home | Coffee Shop | Used Furniture Store
3 | World's Away | Product/price | Other Comic Book Stores | Coffee Shop | Book Shop
4 | World's Away | One of my favourite stores | Restaurant
5 | Good as New | love to shop here-got couch & love seat here great people very helpful | Used Furniture Store | Bakery
6 | [NAME]'s [NAME] | Kindest, most economical, special business | Coffee Shop
7 | [NAME]'s [NAME] | a friend | Pawn Shop
Spreadsheet: 156013d1337147401-value-dependent-variable-cell-action-example
Sheet: Sheet1

 | Are you paper independent?
 | 1-No, everything I do is on paper : 5-Yes I only use paper when I need to.
 | Name | Current | Desire | Range
 | [NAME] | 2 | 4
 | [NAME] | 1 | 5
 | Anna | 4 | 4
 | Clint | 3 | 5
 | Name | 1 | 2 | 3 | 4 | 5
 |  | 0 | 1 | 1 | 1 | 0
 |  | 1 | 1 | 1 | 1 | 1
 |  | 0 | 0 | 0 | 1 | 0
 |  | 0 | 0 | 1 | 1 | 1
 |  | 1 | 2 | 3 | 4 | 5
 |  | 1 | 2 | 3 | 4 | 5
Spreadsheet: 75549d1276106094-obtaining-selection-of-words-with-same-beginning-letters-wordfind
Sheet: Sheet1

Word |  | Conditional Formatting |  |  | [NAME] formula and hit Ctrl + Shift + Enter
c |  | test1
 |  | test2
 |  | abc1
 |  | abc2
 |  | case1
 |  | case2
Spreadsheet: 750436d1633447987-return-value-from-column-based-on-approximate-match-with-multiple-criteria-sample-apprximate-match
Sheet: Sheet1

Row Labels | Month | Year | Amount | G column cell values should be returned here based on approximate match including Cirtiera: Supplier name, month and year
Supplier 1 | 1 | 2019 | 2118.030600000001
Supplier 1 | 2 | 2019 | 2023.6562
Supplier 1 | 3 | 2019 | 35452.47459999994
Supplier 1 | 4 | 2019 | 33412.95129999998
Supplier 1 | 5 | 2019 | 69.99300000000005
Supplier 1 | 6 | 2019 | 2015.333799999998
Supplier 1 | 7 | 2019 | 3695.2264
Supplier 1 | 8 | 2019 | 1983.761199999998
Supplier 1 | 9 | 2019 | 7058.415300000001
Supplier 1 | 10 | 2019 | 1303.3242
Supplier 1 | 11 | 2019 | 512.7972
Supplier 1 | 12 | 2019 | 128.5932
Supplier 2 | 1 | 2019 | 689.7895999999989
Supplier 2 | 2 | 2019 | 4131.223200000002
Supplier 2 | 3 | 2019 | 1604.7688
Supplier 2 | 4 | 2019 | 879.790799999999
Supplier 2 | 5 | 2019 | 1990.033299999999
Supplier 2 | 6 | 2019 | 1702.092400000001
Supplier 2 | 7 | 2019 | 6054.5561
Supplier 2 | 8 | 2019 | 4757.524199999994
Supplier 2 | 9 | 2019 | 3499.185399999996
Supplier 2 | 10 | 2020 | 6895.482099999992
Supplier 2 | 11 | 2020 | 1842.340999999999
Supplier 2 | 12 | 2020 | 18627.13709999999
Spreadsheet: mark_taylor__24671__legalreviewUS
Sheet: currency

Currency
3 | Characters
No analysis - currencies and ISO codes preloaded
To add:
Currency Field | Field Abbreviation | Product Group | ID | Long Description Sentences
NOK | NOK | All | 1 | The price is quoted in Norwegian Krone per unit of volume.
DEM | DEM | All | 2 | The price is quoted in German Marks per unit of volume.
USD | USD | All | 3 | The price is quoted in US Dollars per unit of volume.
GBP | GBP | All | 4 | The price is quoted in British pounds sterling per unit of volume.
SEK | SEK | All | 5 | The price is quoted in Swedish Krone per unit of volume.
FIM | FIM | All | 6 | The price is quoted in Finish Marks cents per unit of volume.
NLG | NLG | All | 7 | The price is quoted in Dutch Guilder per unit of volume.
CHF | CHF | All | 8 | The price is quoted in Swiss Francs per unit of volume.
Spreadsheet: 60664a23-d937-417c-b6f1-0e1d477ece69
Sheet: Sheet1

Instructions | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
College of |  |  |  |  |  |  |  | TERM: |  |  |  |  |  |  |  |  |  |  |  |  | DATE SUBMITTED:
PT/OL Budgeted Amount | Notes | PT/OL | If [NAME]: Current Teaching Load Excluding Overload Hours | Index-ORG | Salary | Academic Rank | Last | First | MI | CWID | [NAME] | Coll | Dept | Sub | Crs | CRN | CR | Enrolled | SCH | POT | Start | End | Type | Method | Title
0
0
Spreadsheet: darrell_schoolcraft__7300__imball0112
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 53056 | 52585
2 | 52799 | 52585
3 | 56198 | 57327
4 | 39345 | 38839
5 | 57736 | 57595
6 | 53279 | 52981
7 | 49516 | 48633
8 | 58091 | 56822
9 | 56234 | 59388
10 | 58416 | 59388
11 | 33275 | 41442
12 | 41688 | 38336
13 | 38952 | 38928
14 | 57758 | 58389
15 | 54323 | 54388
16 | 54357 | 54388
17 | 53451 | 52209
18 | 41390 | 43336
19 | 46550 | 46153
20 | 65126 | 67124
21 | 52434 | 49465
22 | 45644 | 45654
23 | 57273 | 60853
24 | 61491 | 60654
25 | 48252 | 45654
26 | 51633 | 51878
27 | 45541 | 45108
28 | 55353 | 55105
29 | 37618 | 36809
30 | 37152 | 36809
31 | 37432 | 36814
2001-11-30 00:00:00 |  |  | 35912.71
2001-12-31 00:00:00
CBS Volume
 |  |  | 17122
Spreadsheet: 779261d1651670048-how-change-vba-to-formula-and-functions-test_tiger
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holidays | Pub Holiday Description
 |  | 2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | New Year's Day
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  |  |  |  |  |  | 2022-03-21 00:00:00 | Human Rights Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-15 00:00:00 | Good Friday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-17 00:00:00 | Easter Sunday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-18 00:00:00 | Family Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-27 00:00:00 | Freedom Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-05-02 00:00:00 | Workers' Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-16 00:00:00 | Youth Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-07-18 00:00:00 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-08-09 00:00:00 | National Women's Day
 |  | Public Holidays | Pub Holiday Description |  |  |  |  |  |  |  |  |  |  |  | 2022-09-24 00:00:00 | Heritage Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-16 00:00:00 | Day of Reconciliation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-25 00:00:00 | Christmas Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-26 00:00:00 | Day of Goodwill
Spreadsheet: 837565d1690264808-formula-needed-for-income-tax-calculation-spreadsheet-as-per-the-attachment-it-calculation-formula
Sheet: Sheet1

EXAMPLE |  | FORMULA NEEDED AS PER BELOW CRITERIA
VALUE | RESULT
285475 |  | If "Value" is Less than 3,00,000, then "Result" should be 0
485765 |  | If "Value" is more than 3,00,000 but Less than 6,00,000, then "Result" should be (=15,000+(Value-3,00,000)*5%)
755675 |  | If "Value" is more than 6,00,000 but Less than 9,00,000, then "Result" should be (=45,000+(Value-6,00,000)*10%)
1152850 |  | If "Value" is more than 9,00,000 but Less than 12,00,000, then "Result" should be (=90,000+(Value-9,00,000)*15%)
1350600 |  | If "Value" is more than 12,00,000 but Less than 15,00,000, then "Result" should be (=1,50,000+(Value-12,0,0000)*20%)
1750500 |  | If "Value" is more than 15,00,000, then "Result" should be (=1,50,000+(Value-15,00,000)*30%)
 |  | * So, if the "Value" is input as any number between 0-1500001, then the result should be based on the above required Criteria
Spreadsheet: louise_kitchen__24241__July Orig w notes
Sheet: North East Power

Northeast Power
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Power |  | Northeast Power |  | 80000
Schener |  | Power |  | Northeast Power |  | 50000
[NAME] |  | Power |  | Northeast Power |  | 20000
Wheeler |  | Power |  | Northeast Power |  | 10000
Valderama |  | Power |  | Northeast Power |  | 8200
Wood |  | Power |  | Northeast Power |  | 5000
Total *
Spreadsheet: 95493d1295065789-counting-shifts-that-end-past-a-certain-time-or-on-certain-days-example
Sheet: Sheet1

GROUP BY COL | [NAME] | FULLNAME | EMP_NAME | WORK_DATE | HTYPE_NAME | TCODE_NAME | SCHEDULED TIME | INOUTTIME | WORKED TIME
1 JOHN MGR | 2 | Smith, [NAME] | 3 | 2011-01-03 00:00:00 | REG | WRK | 04:00 PM -09:00 PM | 4:00:00 PM -9:00 PM | 5
2 JOHN MGR | 3 | Smith, [NAME] | 4 | 2011-01-04 00:00:00 | REG | WRK | 12:00 PM -9:00 PM | 8:35 AM -1:25 PM | 4.83
2 JOHN MGR | 3 | Smith, [NAME] | 4 | 2011-01-04 00:00:00 | REG | WRK | 12:00 PM -9:00 PM | 2:12 PM -4:35 PM | 2.3
2 JOHN MGR | 3 | Smith, [NAME] | 4 | 2011-01-05 00:00:00 | REG | SICK | 12:00 PM -9:00 PM | 12:00 PM -09:00 PM | 8
Spreadsheet: 681568d1591638509-count-values-in-one-range-if-the-cells-in-a-corresponding-range-are-not-empty-2020-06-08-oeldere-thurgel-681567d1591637965-count-values-in-one-range-if-the-cells-in-a-corr
Sheet: Sheet1

[0-10 yrs/oed] | [11-15 yrs/oed] | [16-24 yrs/oed] | [25-34 yrs/oed] | [35-44 yrs/oed] | [45-54 yrs/oed] | [55-64 yrs/oed] | [65-74 yrs/oed] | [75+]
 | 1 | 2 |  | 2 | 1 |  |  |  |  |  |  | In order to calculate the number of households with adults between 16 and 64 and dependents who are under 16, I would like to use a forumula that counts all the instances where there is a value in columns D to G (green in the attached), i.e. each household IF there is a value in the corresponding cells A to B (yellow in the attached).
2 |  | 3 | 1 |  | 2
 | 2 |  |  |  | 2 |  |  |  |  |  |  | I'm pretty sure I should be able to do this but have tried all sorts, to no avail.
 |  | 3 |  |  | 2
 |  |  |  |  | 2 |  |  |  |  |  |  | Here are some of the forumals I've tried:
 |  |  |  |  | 2
 | 1 | 1 |  |  | 1 |  |  |  |  |  |  | =IF(D2:G875,"<>"),AND(B2:C875,"<>"),COUNT(D2:G875)
 |  |  |  |  |  | 2
 |  |  |  |  |  | 1 |  |  |  |  |  | =IF(B2:C875,"<>"),counta(D2:G875)
 |  |  |  |  |  |  | 2
 |  |  | 1 |  | 1 |  |  |  |  |  |  | =countif(D2:G875,"<>"),(B2:C875,"<>")
 |  | 2 |  |  | 1 | 1
 |  |  |  |  |  | 2 |  |  |  |  |  | These all return a 'There's a problem with this formula' errors.
 |  |  |  |  |  |  | 2
2 | 2 |  | 1 | 1 |  |  |  |  |  |  |  | Can anyone help?
1 | 1 |  |  |  | 1 | 1
 |  | 2 | 1 |  | 1 | 1 |  |  |  |  |  | Thanks!
1 | 1 |  |  |  | 2
1 |  |  | 1 | 1
Spreadsheet: eric_saibi__9841__100401R
Sheet: Collins Power O3

Owner Name |  | Midwest Generation LLC
Station Name |  | Collins Power Station
Unit Name |  | [NAME] 03
NERC Region |  | MAIN
State |  | IL
Fuel Type |  | Coal
Capacity |  | 519 MW
Start Date |  | 2001-10-08 00:00:00
End Date |  | 2001-10-22 00:00:00
Prv. Start Date |  | 2001-10-04 00:00:00
Prv. End Date |  | 2001-10-17 00:00:00
Comments
SIC |  | 4931
Plant ID |  | 1014082
Unit ID |  | 1005615
Outage ID |  | 16283
Spreadsheet: 38293d1236384021-lookup-formula-example32
Sheet: Roster

Name | Type
[NAME] | Dog
Furry | Kitten | 1
Spaz | Kitten | 3
Frodo | Dog
Sleepy | Dog
Fuzzy | Kitten | 2
Dopey | Kitten | 5
[NAME] | Kitten | 4
Spreadsheet: 141865d1329490729-making-3-combo-boxes-dependent-on-each-other-book1
Sheet: Sheet1

Blank | England | Scotland | Spain | Italy | Germany |  | Select country | Select League
Please select a country. |  |  |  |  |  |  | Spain | Primera League
 | Premier League | Premier League | Primera League | Serie A | Bundesliga
 | Championship | First Division | Segunda [NAME] | Serie B | 2. Bundesliga
 | League One | Second Division | Segunda [NAME] |  | Liga
 | League Two | Third Division
 | FA Cup
 | League Cup