tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50819d1250289846-formula-for-months-to-years-conversion-help-compound-calculator
Sheet: Compound

Compound Calculator
 |  |  | CD Amount: | 10000
 |  |  | Term: | 7 |  |  |  |  | Years*
 |  |  |  |  |  |  |  |  | * Based on a 365 day calendar year
 |  |  | [NAME]: | Monthly
 |  |  | Interest Rate: | 0.0108
 |  |  | Maturity Value: | 10784.94406429418
 |  |  | Years |  | Months |  |  |  | v1.01 - CF
 |  | Daily | 10785.2986915782 |  | 10063.19878923904
 |  | Monthly | 10784.94406429418 |  | 10063.19649009069
 |  | Quarterly | 10784.21203882757 |  | 10063.19173618216
 |  | Yearly | 10780.94009187849 |  | 10063.17035537975
Spreadsheet: 05bd2c95-0328-4bdb-9b14-62ca30e6b6bd
Sheet: 2007-08

Table U
Student Numbers by Disability
2007-08
Disability | Undergraduate | Graduate | Total
Autistic Spectrum Disorder | 6 | 1
Blind / Are Partially Sighted | 10 | 9
Deaf / Have a Hearing Impairment | 17 | 18
Dyslexia | 256 | 109
Mental Health Difficulties | 13 | 14
Multiple Disabilities | 13 | 8
Personal Care Support | 1 | 3
Unseen Disability eg Diabetes, [NAME], [NAME] | 62 | 47
Wheelchair User / Have Mobility Difficulties | 5 | 11
Disability Not Listed Elsewhere | 66 | 21
No Known Disability | 11607 | 7224
Not Known | 100 | 549
Total
The data in this table reflects disability information voluntarily provided by students at the time of application. Students who do not wish to declare their disability or subsequently develop or are diagnosed as having a disability while studying at UCL will remain in the "No Known Disability" or "Not Known" categories. Therefore, the actual number of students with disabilities registered at UCL will be higher than indicated in this table.
Spreadsheet: phillip_allen__28812__stage_pivot8_9
Sheet: Categories

 | Major |  | Minor
1 | Income | 1 | Rent
 |  | 2 | Application Fee
 |  | 3 | Late Charges
 |  | 4 | [NAME]
 |  | 5 | Deposit Refund
 |  | 6 | [NAME]
 |  | 7 | Returned Checks
2 | Labor | 8 | Maintenance
 |  | 9 | Management
 |  | 10 | Security
3 | Materials | 11 | Carpet
 |  | 12 | Vinyl
 |  | 13 | Lumber
 |  | 14 | Electrical
 |  | 15 | Plumbing
 |  | 16 | Roofing
 |  | 17 | Paint
 |  | 18 | Landscape
 |  | 19 | Cleaning
 |  | 20 | Office
 |  | 21 | Miscellaneous
 |  | 22 | Tools
 |  | 23 | Appliance
 |  | 24 | Landscape
 |  | 25 | [NAME]
4 | Utilities | 26 | Electrical
 |  | 27 | Plumbing
 |  | 28 | Water
 |  | 29 | Gas
 |  | 30 | Telephone
5 | Services
 |  | 31 | Professional
 |  | 32 | Advertising
 |  | 33 | Pest Control
 |  | 34 | Cleaning
 |  | 35 | Security
Spreadsheet: 9b27a75d-d70c-4e64-b912-63f7a6e4a946
Sheet: Sheet1

Release: Quarterly Retail E-Commerce Sales | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=179
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-08-22 4:47 PM CDT
 | Real-Time | Period
Name: | Start | End
Quarterly Retail E-Commerce Sales | 2009-02-17 00:00:00 | Current
Link:
http://www.census.gov/mrts/www/ecomm.html | 2009-02-17 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2009-02-17 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2009-02-17 00:00:00
2009-05-15 00:00:00
2009-08-17 00:00:00
2009-11-18 00:00:00
2010-02-16 00:00:00
2010-05-18 00:00:00
2010-08-17 00:00:00
2010-11-17 00:00:00
2011-02-17 00:00:00
2011-05-16 00:00:00
2011-08-16 00:00:00
2011-11-17 00:00:00
2012-02-16 00:00:00
2012-05-17 00:00:00
2012-08-16 00:00:00
2012-11-16 00:00:00
2013-02-15 00:00:00
2013-05-15 00:00:00
2013-08-15 00:00:00
2013-11-22 00:00:00
2014-02-18 00:00:00
2014-05-15 00:00:00
2014-08-15 00:00:00
Spreadsheet: 794287d1661964599-create-list-from-data-on-other-sheets-compile
Sheet: Red Team

First Name | Last Name | ID | [NAME]
[NAME] | Smith | 1234 | 2X
[NAME] | Doe | 4566 | 1x
[NAME] | Black | 9874 | 1x
Bethany | Jones | 4716 | 3x
[NAME] | Dunham | 9831 | 2x
Spreadsheet: 822780d1679518335-count-distinct-unique-values-based-on-multiple-criteria-sample-storage-counts
Sheet: Sheet2

Product ID | Category | QoH | Sublocation summary | [NAME] | [NAME] | Sublocation Restated | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 |  | Column1 | Bins | [NAME] | Oversized | Regular
ABL-0021 | Abler | 60 | RECEIVING: 60 | Pallet Pick | 60 | RECEIVING: 60 |  |  |  |  |  |  |  | Abler | 2
ABL-0022 | Abler | 173 | RECEIVING: 173 | Pallet Pick | 200 | RECEIVING: 173 |  |  |  |  |  |  |  | AllCure |  |  | 3 | 9
AC-112 | AllCure | 5361 | X-18-E-06-A-02: 1271, X-22-A-02-A-01: 157, X-24-B-01-A-01: 1140, X-25-B-10-A-01: 528, X-25-B-10-A-02: 1152, X-25-C-10-A-03: 1104, X-Quarantine: 9 | Pallet Pick |  | X-18-E-06-A-02: 1271 | X-22-A-02-A-01: 157 | X-24-B-01-A-01: 1140 | X-25-B-10-A-01: 528 | X-25-B-10-A-02: 1152 | X-25-C-10-A-03: 1104 | X-Quarantine: 9 |  | Alpine | 3
AC-112 | AllCure | 3532 | Q-10-B-01-A-02: 11, X-17-E-01-A-01: 1476, X-24-B-01-A-02: 936, X-25-D-10-A-01: 988, X-25-E-08-A-01: 24, Z-TRAILER: 97 | Pallet Pick |  | Q-10-B-01-A-02: 11 | X-17-E-01-A-01: 1476 | X-24-B-01-A-02: 936 | X-25-D-10-A-01: 988 | X-25-E-08-A-01: 24 |  |  |  | Bythe |  |  | 1
ALP-0778 | Alpine | 4 | B-09-A-12-B-05: 4 | B-09-A-12-B-05 | 4 | B-09-A-12-B-05: 4 |  |  |  |  |  |  |  | [NAME] |  | 10
ALP-0779 | Alpine | 4 | B-09-A-12-C-01: 4 | B-09-A-12-C-01 | 4 | B-09-A-12-C-01: 4 |  |  |  |  |  |  |  | Codger |  |  |  | 2
ALP-0806 | Alpine | 1 | B-07-A-08-A-01: 1 | B-07-A-08-A-01 | 128 | B-07-A-08-A-01: 1 |  |  |  |  |  |  |  | Dialate |  |  | 4
BY-002 | Bythe | 78 | X-17-E-08-A-01: 78 |  |  | X-17-E-08-A-01: 78
BY-003 | Bythe | 28 | X-17-E-08-A-01: 28 |  |  | X-17-E-08-A-01: 28
BY-004 | Bythe | 207 | X-17-E-08-A-01: 207 |  |  | X-17-E-08-A-01: 207
BY-005 | Bythe | 75 | X-17-E-08-A-01: 75 |  |  | X-17-E-08-A-01: 75
BY-006 | Bythe | 37 | X-17-E-08-A-01: 37 |  |  | X-17-E-08-A-01: 37
810-0001-00 | [NAME] | 2 | [NAME]: 2 | [NAME] | 3 | [NAME]: 2
810-0002-04 | [NAME] | 4 | [NAME]: 1, B-01-A-06-D-03.D: 3 | [NAME] |  | [NAME]: 1 | B-01-A-06-D-03.D: 3
810-0024-00 | [NAME] | 40 | B-01-A-01-A-01.D: 6, B-01-A-01-A-02.D: 6, B-01-A-01-A-03.D: 6, B-01-A-01-A-04.D: 6, [NAME]: 6, [NAME]-C-05.D: 6, [NAME]: 4 | B-01-A-01-A-02.D |  | B-01-A-01-A-01.D: 6 | B-01-A-01-A-02.D: 6 | B-01-A-01-A-03.D: 6 | B-01-A-01-A-04.D: 6 | [NAME]: 6 | [NAME]-C-05.D: 6 | [NAME]: 4
COD-0021 | Codger | 126 | X-04-D-11-A-01: 87, X-04-D-12-A-01: 39 | B-04-B-01-C-06 | 25 | X-04-D-11-A-01: 87 | X-04-D-12-A-01: 39
XZ-9000 | Dialate | 1522 | X-17-E-05-A-01: 432, X-17-E-05-A-02: 370, X-17-E-05-A-03: 360, X-17-E-06-A-01: 360 |  |  | X-17-E-05-A-01: 432 | X-17-E-05-A-02: 370 | X-17-E-05-A-03: 360 | X-17-E-06-A-01: 360
 |  |  |  |  |  | BINS = RECEIVING or start w/ a B-
 |  |  |  |  |  | [NAME] = End w/ .D
 |  |  |  |  |  | Oversized Pallet = Start w/ X-*-E
 |  |  |  |  |  | Regular Pallet = Start w/ X-
Spreadsheet: 293641d1391042678-scenario-for-paid-dates-book1
Sheet: Sheet2

Day | 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
Invoices
Invoices Paid
 |  |  | 10 day | 0.4
 |  |  | 15 day | 0.2
 |  |  | 30 day | 0.4
Spreadsheet: benjamin_rogers__1159__Base
Sheet: Caledonia

 |  |  |  |  | 12
INCOME STATEMENT - CALEDONIA
('000 $) |  |  |  | 1999
Revenue
PPA Period:
Demand Payment
Energy Payment |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Block Payment |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Market Period:
Demand Revenue |  |  |  | 0 | 0 | 0 | 0
Variable Revenue |  |  |  | 0 | 0 | 0 | 0
Energy Margin |  |  |  | 0 | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fuel |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fixed O&M
Variable O&M
Major Maintenance & Ongoing Capex
Insurance
SG&A
Utility Start Up Power
Property, Other Taxes |  |  |  | 0 | 540.3022988061599 | 529.38710085048 | 518.4719028948 | 507.55670493912 | 496.64150698344 | 485.72630902776 | 469.35351209424 | 452.9807151607199 | 436.6079182272 | 414.77752231584 | 1178.84137921344 | 1096.97739454584 | 998.7406129447199 | 900.5038313436 | 802.2670497424799 | 671.28467427432 | 523.92950187264 | 376.57432947096 | 327.4559386704 | 327.4559386704 | 0
Debt Service L/C Fee |  |  |  | 0
Marketing Fee |  |  |  | 0 | 0 | 0 | 0
Administrative Fee
O&M Fees
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
[NAME]
CASH FLOW CALEDONIA
Investor Interest
('000 $) |  |  |  | 1999
EBITDA
Capital Expenditures |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense) |  |  |  | 0
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
Investor Net Income
Investor [NAME]
Spreadsheet: 35952d1233689359-formula-to-reset-a-count-based-on-cell-value-example-time_off_trkng
Sheet: Vacation Days

VACATION DAYS - TIME USED
Last Name | First Name | DAY 1 | DAY 2 | DAY 3 | DAY 4 | DAY 5 | DAY 6 | DAY 7 | DAY 8 | DAY 9 | DAY 10 | DAY 11 | DAY 12 | DAY 13 | DAY 14 | DAY 15 | DAY 16 | DAY 17 | DAY 18 | DAY 19 | DAY 20 | DAY 21 | DAY 22 | DAY 23 | DAY 24 | DAY 25 | DAY 26 | DAY 27 | DAY 28 | DAY 29 | DAY 30 | DAY 31 | DAY 32 | DAY 33 | DAY 34 | DAY 35 | DAY 36 | DAY 37 | DAY 38 | DAY 39 | DAY 40 | DAY 41 | DAY 42 | DAY 43 | DAY 44 | DAY 45 | DAY 46 | DAY 47 | DAY 48 | DAY 49 | DAY 50 | DAY 51 | DAY 52 | DAY 53 | DAY 54 | DAY 55 | DAY 56 | DAY 57 | DAY 58 | DAY 59 | DAY 60 | DAY 61 | DAY 62 | DAY 63 | DAY 64 | DAY 65 | DAY 66 | DAY 67 | DAY 68 | DAY 69 | DAY 70 | DAY 71 | DAY 72 | DAY 73 | DAY 74 | DAY 75 | DAY 76 | DAY 77 | DAY 78 | DAY 79 | DAY 80 | DAY 81 | DAY 82 | DAY 83 | DAY 84 | DAY 85 | DAY 86 | DAY 87 | DAY 88 | DAY 89 | DAY 90 | DAY 91 | DAY 92 | DAY 93 | DAY 94 | DAY 95 | DAY 96 | DAY 97 | DAY 98 | DAY 99 | DAY 100 | DAY 101 | DAY 102 | DAY 103 | DAY 104 | DAY 105 | DAY 106 | DAY 107 | DAY 108 | DAY 109 | DAY 110 | DAY 111 | DAY 112 | DAY 113 | DAY 114 | DAY 115 | DAY 116 | DAY 117 | DAY 118 | DAY 119 | DAY 120
 |  | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS | # HOURS
0 | 02
1 | 13
2 | 02
3 | 13
4 | 02
5 | 04
6 | 03
7 | 19
8 | 12
9 | 13
A | 18
B | 19
C | 05
D | 04
E | 10
F | 20
G | 10
H | 18
I | 01
J | 04
K | 10
L | 05
M | 13
N | 04
O | 19
P | 19
Q | 13
R | 03
S | 26
T | 10
U | 02
V | 04
W | 02
X | 11
Y | 02
Z | 02
Spreadsheet: 91521d1291229092-using-a-macro-to-merge-35-worksheets-into-a-single-file-excluding-blank-lines-consolidated
Sheet: Sheet1

Branch | GL # | REVENUE | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
1 | 1235456847 | type 1 | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200
1 | 1235456847 | type 2 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300
1 | 1235456847 | type 3 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400
1 | 1235456847 | type 1 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500
1 | 1235456847 | type 1 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500
1 | 1235456847 | type 1 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500
2 | 1235456847 | type 1 | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200
2 | 1235456847 | type 2 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300
2 | 1235456847 | type 3 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400
2 | 1235456847 | type 1 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500
2 | 1235456847 | type 1 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500
2 | 1235456847 | type 1 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500
2 | 1235456847 | type 1 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500
 | In an ideal scenario, this result of the marcro would merge any content (values only) in a range in a specified sequence to generate the rows 1 to 14 above without any spaces.
 | The above table is the combined data from branch1.xls and branch2.xls.
 | Thank you
Spreadsheet: 60502d1261041882-using-vlookup-and-if-together-vlookup-if
Sheet: Sheet2

REF NUM | [NAME] | DATA2 | DATA3 | DAYS OF THE WEEK SERVICED
0000 | 1 | 3 | 5 | MON | TUE |  | THU |  | SAT | SUN
1111 | 2 | 3 | 3 |  | TUE | WED |  | FRI |  | SUN
2222 | 4 | 1.5 | 7 | MON |  | WED |  | FRI
3333 | 2 | 3 | 3 |  | TUE | WED |  |  | SAT
4444 | 1 | 3 | 5 | MON | TUE |  | THU | FRI | SAT | SUN
Spreadsheet: 809626d1671187469-find-median-between-2-dates-and-product-median
Sheet: Ark1

 |  |  |  |  | Apple | [NAME] | Orange
 |  |  |  | 2022-10-01 00:00:00 | 10 | 20 | 5 |  |  | From | 2022-11-01 00:00:00
 |  |  |  | 2022-11-01 00:00:00 | 12 | 23 | 6 |  |  |  | apple
 |  |  |  | 2022-12-01 00:00:00 | 14 | 24 | 7 |  |  |  | 3
 |  |  |  | 2023-01-01 00:00:00 | 16 | 25 | 8
 |  |  |  | 2023-02-01 00:00:00 | 18 | 26 | 9
 |  |  |  | 2023-03-01 00:00:00 | 20 | 27 | 10
 |  |  |  | 2023-04-01 00:00:00 | 22 | 28 | 11
 |  |  |  | 2023-05-01 00:00:00 | 24 | 29 | 12
 |  |  |  | 2023-06-01 00:00:00 | 26 | 30 | 13
 |  |  |  | 2023-07-01 00:00:00 | 28 | 31 | 14
 |  |  |  | 2023-08-01 00:00:00 | 30 | 32 | 15
 |  |  |  |  |  | Example 1
 |  |  |  |  |  | Product | Startdate | number of months | Median
 |  |  |  |  |  | Apple | 2022-11-01 00:00:00 | 3 | 14
 |  |  |  |  |  | Example 2
 |  |  |  |  |  | Product | Startdate | number of months | Median
 |  |  |  |  |  | [NAME] | 2022-12-01 00:00:00 | 5 | 18
Spreadsheet: matthew_lenhart__26266__West Daily Prices1119-01
Sheet: Gas Curve Summary

 | GAS CURVES
 | PRICE | BASIS
 | NG HH | SUMAS |  | MALIN |  | PGE/CG |  | SANJUAN |  | SOCAL
Spreadsheet: 148704d1333528421-average-3-months-6-months-trend-line-array-formula-achizitii-trend-tabla
Sheet: LAST DIRECT

No_ | Description | Last Direct Cost | Item Category Code
TABLA 010 | TABLA 1*3000*1500 S235 JR | 12.98932 | TABLA
TABLA 010 A | TABLA 1*2000*1000 S235 JR | 29.2 | TABLA
TABLA 015 | TABLA 1,5*3000*1500 S235 JR | 43.37349 | TABLA
TABLA 020 | TABLA 2*3000*1500 S235 JR | 58.4 | TABLA
TABLA 020 A | TABLA 2*3000*1250 S235 JR | 39.68254 | TABLA
TABLA 020 B | TABLA 2*2500*1250 S235 JR | 52.64847999999999 | TABLA
TABLA 020 C | TABLA 2*2000*1000 S235 JR | 52.50365 | TABLA
TABLA 030 | TABLA 3*3000*1500 S235 JR | 70.43269 | TABLA
TABLA 030 S355 | TABLA 3*3000*1500 S355 JR | 76.92308 | TABLA
TABLA 030 S355 OLD | TABLA 3*3000*1500 S355 JR | 0.13333 | TABLA
TABLA 040 | TABLA 4*3000*1500 S235 JR | 93.76 | TABLA
TABLA 040 S355 | TABLA 4*3000*1500 S355 | 102.4 | TABLA
TABLA 050 | TABLA 5*3000*1500  S235 JR | 117.2 | TABLA
TABLA 050 CR | TABLA 5*3000*1500 CREUSABRO | 0 | TABLA
TABLA 050 HD | TABLA 5*3000*1500  HARDOX | 322.964 | TABLA
TABLA 050 HD A | TABLA 5*3000*1250  HARDOX | 547.73074 | TABLA
TABLA 050 S355 | TABLA 5*3000*1500  S355 K2 G3 | 128 | TABLA
TABLA 060 | TABLA 6*3000*1500 S235 JR | 140.66251 | TABLA
TABLA 060 S355 | TABLA 6*3000*1500 S355 JR | 153.84615 | TABLA
TABLA 080 | TABLA 8*3000*1500 S235 JR | 187.82051 | TABLA
TABLA 080 A | TABLA 8*2000*4000 S235 JR | 2.35167 | TABLA
TABLA 080 S355 | TABLA 8*3000*1500 S355 | 208.33333 | TABLA
TABLA 100 | TABLA 10*3000*1500 S235 JR | 242.4 | TABLA
TABLA 100 S355 | TABLA 10*3000*1500 S355 [NAME] | 260 | TABLA
TABLA 120 | TABLA 12*3000*1500  S235 JR | 300.96154 | TABLA
TABLA 120 S355 | OTEL 12    -    S355 K2 G3 | 305.76923 | TABLA
TABLA 150 | TABLA 15*3000*1500 S235 JR | 377.10843 | TABLA
TABLA 150 S355 A | TABLA 15*3000*2000  S355 K2 G3 | 370.58862 | TABLA
TABLA 160 | TABLA 16*3000*1500  S235 JR | 460.8813 | TABLA
TABLA 200 | TABLA 20*3000*1500 S235 JR | 502.4 | TABLA
TABLA 250 | TABLA 25*3000*1500 S235 JR | 650 | TABLA
TABLASTRI2,5 | TABLA STRIATA 5BARE 2,5 | 263.03 | TABLA
TABLASTRINEAGRA | TABLA NEAGRA STRIATA 4MM | 1025.2 | TABLA
TABLAZNCUTATA | TABLA ZINCATA CUTATA 0,35 | 36 | TABLA
Spreadsheet: 494797d1482758502-i-need-to-hide-the-n-a-with-blanks-but-the-chart-does-not-show-value-has-zero-chart-solution
Sheet: Sheet2

MONTHS | VALUE1 | VALUE2 | SUM | IFFUNCTION | IFFUNC | MASK
2017-01-01 00:00:00 | 200 | 3 | 600 | 600 | 600 | 600
2017-01-02 00:00:00 | 300 | 0 | 0 | 0 | #N/A | #N/A
2017-01-03 00:00:00 | 400 | 5 | 2000 | 2000 | 2000 | 2000
2017-01-04 00:00:00 | 500 | 6 | 3000 | 3000 | 3000 | 3000
2017-01-05 00:00:00 | 600 | 0 | 0 | 0 | #N/A | #N/A
2017-01-06 00:00:00 | 200 | 1 | 200 | 200 | 200 | 200
2017-01-07 00:00:00 | 300 | 5 | 1500 | 1500 | 1500 | #N/A
2017-01-08 00:00:00 | 400 | 9 | 3600 | 3600 | 3600 | #N/A
2017-01-09 00:00:00 | 500 | 10 | 5000 | 5000 | 5000 | #N/A
2017-01-10 00:00:00 | 600 | 12 | 7200 | 7200 | 7200 | 7200
2017-01-11 00:00:00 | 100 | 0 | 0 | 0 | #N/A | #N/A
2017-01-12 00:00:00 | 200 | 34 | 6800 | 6800 | 6800 | 6800
2017-01-13 00:00:00 | 1400 | 9 | 12600 | 12600 | 12600 | #N/A
Spreadsheet: 740213d1626244702-formula-to-determine-value-appears-more-than-once-based-on-crteria-formula-to-determine-if-value-is-on-pl-and-statement
Sheet: Sheet1

Date | Branch | Ref | Amount | formula | Manual
2017-01-10 00:00:00 | BR1 PL | [NAME] | 0.01
30/06/2020 | BR1 PL | RECON ITEM MAY | 0.01
23/06/2021 | BR1 PL | 92517 | 85.05 |  | Delete
31/08/2021 | BR1 PL | J1Recon | -11245.95
23/06/2021 | BR1 Statement | 92525 | 85.05 |  | Delete
Spreadsheet: 736854d1623921776-i-need-a-formula-to-count-1-3-ratio-for-payment-eg-for-every-3-screened-items-1-sftopay-products-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | for 1 damaged product amount to pay is Rs.1000
 |  |  |  |  | Item status
 |  |  |  |  | good |  |  |  | Total screen | Eligible SF | Actual
 |  |  |  |  | good
 |  |  |  |  | good |  |  |  |  |  |  |  | SF AMT
 |  |  |  |  | good |  |  |  |  |  |  |  |  | Eligible | 6
 |  |  |  |  | good |  |  |  |  |  |  |  |  | damaged | 2
 |  |  |  |  | good |  |  |  |  |  |  |  |  | To be paid
 |  |  |  |  | good |  |  |  |  |  |  |  |  | Amt
 |  |  |  |  | good
 |  |  |  |  | good
 |  |  |  |  | damaged
 |  |  |  |  | good
 |  |  |  |  | good
 |  |  |  |  | good
 |  |  |  |  | good
 |  |  |  |  | good
 |  |  |  |  | good
 |  |  |  |  | damaged
 |  |  |  |  | good
 |  |  |  |  | good
 |  |  |  |  | good
Spreadsheet: 189232d1351123271-calculating-value-between-two-points-solar102412
Sheet: Yrs

Yearly Totals
 | Consumption / KW |  |  | Charges |  |  | Efficiency
 | Used | PG&E | Solar | Charges | Billed | Solar | Est | Actual
2011 | 13102.02 | 6747.6 | 5210.96 | 1971.16 | 1129.31 | 841.85 | 5751 | 5210.96
Totals | 13102.02 | 6747.6 | 5210.96 | 1971.16 | 1129.31 | 841.85 | 5751 | 5210.96
 |  | 0.5150045565492954 | 0.3977218780004915 |  | 0.5729164552852127 | 0.4270835447147872 | 0.9060963310728569 | Efficient
Spreadsheet: 816466d1675646746-how-to-get-table-b-from-table-a-s666-pq-how-to-get-table-b-from-table-a
Sheet: Sheet1

NAME | Good at subject A | Good at subject B | Good at subject C | Good at subject D | Good at subject E |  | language | math | English | history | geography |  | https://www.excelforum.com/excel-formulas-and-functions/1399180-how-to-get-table-b-from-table-a.html
ABC | language | math | English | history | geography |  | ABC | ABC | ABC | ABC | ABC
CDE | math | geography |  |  |  |  | HIJ | CDE | EFG | EFG | CDE
EFG | English | math | history |  |  |  |  | EFG |  | HIJ | HIJ
HIJ | history | geography | language | math |  |  |  | HIJ |  | XYZ
XYZ | math | history |  |  |  |  |  | XYZ
TABLE A |  |  |  |  |  |  | TABLE B
Spreadsheet: 168950d1342637683-spreadsheet-with-unknown-columns-cash-report-july-2012-v1
Sheet: Current Day

 | Bank Balance | 2012-05-29 00:00:00 |  | 4016.92
 |  | Due Date | Amount
Add | Deposits
 | Visa/Mastercard/Amex Deposits |  | 85
 | Daily Deposits |  | 3330.02
 | Health Care Authority (Actual) | 2012-05-30 00:00:00
 | Health Care Authority (Estimate) |  | 16200
 |  |  | DEPOSITS=
Less | Outstanding Checks
4914 | [NAME] | 2012-05-23 00:00:00 | -613.19
4915 | [NAME] | 2012-05-23 00:00:00 | -1347.73
4926 | McKenzie T Dickinson | 2012-05-23 00:00:00 | -27.36
4928 | [NAME] | 2012-05-23 00:00:00 | -2256.65
4930 | [NAME] | 2012-05-23 00:00:00 | -1993.46
4936 | [NAME] | 2012-05-23 00:00:00 | -1022.15
 | Cash Transfer | 2012-05-29 00:00:00 | -500
 |  |  | O/S CHECKS=
Less | Online [NAME]Other
 | IRS FED W/H PPE 05-09-12 | 2012-05-16 00:00:00 | -5650.7
 | Security BankCard Center, Inc. | 2012-05-24 00:00:00 | -1192.6
 | State of Oklahoma W/H April '12 | 2012-05-20 00:00:00 | -1686
 | IRS FED W/H PPE 05-23-12 | 2012-05-30 00:00:00 | -5106.09
 | Cash Transfer - Dr. [NAME] | 2012-05-28 00:00:00 | -500
 | Smart Image Systems | 2012-05-24 00:00:00 | -405.74
 | AT&T Mobile | 2012-05-30 00:00:00 | -864.76
 | BOA Card #8643 | 2012-05-30 00:00:00 | -350
 | Progressive Insurance | 2012-05-30 00:00:00 | -322.13
 | BOA Card #6843 | 2012-05-31 00:00:00 | -350
 | Yellow Book Advertising | 2012-05-31 00:00:00 | -1299.19
 |  |  | O/S BILL PAY =
 |  |  | Ending Cash Balance
 | DAILY CASH RECONCILIATION - not used for forecast
 | Ending Cash Balance G/L | Quickbooks |  | -328.6
 | O/S Checks | Add from above
 | Total
 | Bank Balance | Bank Bal plus todays deposit
 | Difference | Quickbooks vs Arvest
Spreadsheet: 218146d1362371824-if-then-vlookup-i-am-confused-test3
Sheet: Sheet1

team 1
name | variable 1
person a | 24 |  | Winner
person b | 23 |  | Whichever team has the highest total, their name goes here
person c | 12
person d | 43
person e | 23
Total:
team 2
person c | 34
person e | 23
person f | 54
person g | 23
person h | 1
Total:
team 3
person i | 65
person j | 34
[NAME] | 23
person l | 65
Total: