tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 819679d1677631657-averageif-and-vlookup-question-book1
Sheet: Vlookup

Use any combination of nested IF, IFERROR or ISERROR functions along with at least one nested VLOOKUP to compare the Actual vs. Budget amounts and provide "Under Budget" or "Over Budget" next to "STATUS" for the GL account entered in cell [NAME].  If the account is invalid, display nothing (a "null" NOT a space).
 |  |  | GL Acct # |  |  |  |  |  | GL Acct | GL Acct Description | Actual | Budget
 |  | Enter GL Acct # ==> | 697035 |  |  |  |  |  | 612001 | Basic Salaries | 1505055.6 | 1500700
 |  | Status: |  | <-- why is this still showing over buget for n/a accounts. How do I fix this? |  |  |  |  | 612002 | Bonus Salary | 225758.55 | 225100
 |  |  |  |  |  |  |  |  | 612005 | Overtime | 120404.9 | 120400
 |  |  |  |  |  |  |  |  | 613100 | FICA | 103397.8785 | 104100
 |  |  |  |  |  |  |  |  | 613105 | Medicare | 40636.685 | 41300
 |  |  |  |  |  |  |  |  | 620001 | Retirement Plan | 120405 | 12500
 |  |  |  |  |  |  |  |  | 620010 | Exec Retirement | 481617.7 | 480900
 |  |  |  |  |  |  |  |  | 620101 | Pension | 135455.25 | 135500
 |  |  |  |  |  |  |  |  | 620200 | Exec Recruiting | 58750 | 50100
 |  |  |  |  |  |  |  |  | 620220 | Non Exec Recruiting | 126301 | 150100
 |  |  |  |  |  |  |  |  | 620221 | Part Time Recruiting | 5800.8 | 6700
 |  |  |  |  |  |  |  |  | 635001 | Training | 45152.65 | 50800
 |  |  |  |  |  |  |  |  | 635002 | Education | 19566.215 | 20600
 |  |  |  |  |  |  |  |  | 635003 | Seminars | 7500.5 | 10400
 |  |  |  |  |  |  |  |  | 640000 | Contract Labor | 150000 | 150200
 |  |  |  |  |  |  |  |  | 640010 | Professional Services | 270000.9 | 300100
 |  |  |  |  |  |  |  |  | 640020 | Consulting | 185650.2 | 180400
 |  |  |  |  |  |  |  |  | 640030 | Legal Consulting | 187900.4 | 175800
 |  |  |  |  |  |  |  |  | 650020 | Supplies | 27501 | 25700
 |  |  |  |  |  |  |  |  | 650030 | Equipment < $100 | 15060.7 | 20800
 |  |  |  |  |  |  |  |  | 650040 | Furniture | 15050.3 | 20300
 |  |  |  |  |  |  |  |  | 650050 | Software - Inititial | 125500.8 | 126200
 |  |  |  |  |  |  |  |  | 650051 | Software - Additional Licenses | 1250.5 | 0
 |  |  |  |  |  |  |  |  | 650052 | Software Maintenance | 12550.7 | 12700
 |  |  |  |  |  |  |  |  | 660090 | IT Staff Charges | 10505.9 | 10700
 |  |  |  |  |  |  |  |  | 660100 | IT Staff Rebates | -1574.8 | -100
 |  |  |  |  |  |  |  |  | 675050 | Postage | 15653.8 | 16300
 |  |  |  |  |  |  |  |  | 675090 | Express Mail | 2780.8 | 3500
 |  |  |  |  |  |  |  |  | 675100 | Shipping | 9876.2 | 10300
 |  |  |  |  |  |  |  |  | 681001 | Occupancy | 18000.1 | 18500
 |  |  |  |  |  |  |  |  | 681005 | Occupancy Rebates | -566.6 | -1000
 |  |  |  |  |  |  |  |  | 681010 | Occupancy Repairs | 1975.9 | 5600
 |  |  |  |  |  |  |  |  | 697030 | Advertising | 175688.8 | 200600
 |  |  |  |  |  |  |  |  | 697035 | Other G&A | 569.4 | 300
Spreadsheet: 783092d1654578651-how-to-group-a-list-of-values-into-buckets-with-a-maximum-total-solver_bucket_load
Sheet: Solver_setup

 |  |  |  |  | Bucket 1 | Bucket 2 | Bucket 3 | Bucket 4
 |  | 24 |  |  | 0 | 0 | 0 | 1 |  | = | 1
 |  | 55 |  |  | 0 | 0 | 0 | 1
 |  | 18.5 |  |  | 0 | 1 | 0 | 0
 |  | 44.4 |  |  | 0 | 1 | 0 | 0
 |  | 20 |  |  | 0 | 0 | 1 | 0
 |  | 31.5 |  |  | 0 | 0 | 1 | 0
 |  | 47 |  |  | 1 | 0 | 0 | 0
 |  | 17 |  |  | 0 | 1 | 0 | 0
 | Tot load |  |  | Load/bucket
 |  |  |  |  | <= | <= | <= | <=
 |  |  |  | [NAME] load | 80 | 80 | 80 | 80
Spreadsheet: 731316d1620288287-need-help-on-lookup-lookup
Sheet: Sheet1

 |  |  | Identifier | Results
 |  |  | 0 | 0
 |  |  | 0.001 | 0.001005
 |  |  | 0.002 | 0.00201 |  | 20*
 |  |  | 0.002* | 0.002006
 |  |  | 0.005 | 0.004996
 |  |  | 0.01 | 0.009998
 |  |  | 0.02 | 0.020016
 |  |  | 0.02* | 0.020002
 |  |  | 0.05 | 0.050019
 |  |  | 0.1 | 0.100023
 |  |  | 0.2 | 0.200031
 |  |  | 0.2* | 0.200028
 |  |  | 0.5 | 0.5000439999999999
 |  |  | 1 | 1.00003
 |  |  | 2 | 2.000029
 |  |  | 2* | 2.000032
 |  |  | 5 | 5.000038
 |  |  | 10 | 10.000003
 |  |  | 20 | 19.999882
 |  |  | 20* | 19.999935
 |  |  | 50 | 50.00019
 |  |  | 100 | 100.00021
 |  |  | 200 | 200.00043
 |  |  | 200* | 200.00043
 |  |  | 500 | 500.0003
 |  |  | 1000 | 999.999
 |  |  | 2000 | 2000.002
 |  |  | 2000* | 2000.009
 |  |  | 5000 | 5000.006
 |  |  | 10000 | 10000.03
 |  |  | 10000* | 10000.025
 |  |  | 10000** | 10000.005
Spreadsheet: 158071d1337968615-error-of-n-a-when-summing-up-columns-using-index-and-match-for-multiple-worksheets-sales-report
Sheet: Feb

# |  |  |  |  |  | Existing | Existing | Existing | New | New | New | Referrals | New | Flights
 | CT User |  |  |  |  | Sales | Unique |  | Sales | Unique |  |  | Lines | Fund Amount
2 | MBOT | NE | 55 | MBOT | Personal Banker/Consumer Lender | 42 | 20 |  | 38 | 6 |  |  | 5
3 | DCATE | NE | 66 | DCATE | Personal Banker II | 97 | 30 |  | 7 | 2 |  |  | 0 | 100000
4 | DTABOT | NE | 56 | DTABOT | Personal Banker II | 3 | 3 |  | 0 | 0 | 0 | 0 | 1 | 556
Spreadsheet: 703537d1605034799-formula-to-allocate-sales-orders-based-on-working-days-zeszyt4
Sheet: Orders processed

Orders processed date | No of Orders processed
2020-11-08 00:00:00 | 110
2020-11-09 00:00:00 | 144
2020-11-10 00:00:00 | 100
2020-11-11 00:00:00 | 141
2020-11-12 00:00:00 | 110
Total Orders
Name | Order allocation
Nick
Justin
[NAME]
Mark
Gavin
[NAME]
TOTAL
Spreadsheet: 750835d1633675056-i-want-to-autofill-a-sum-function-across-a-row-that-includes-indirect-example-of-moving-totals
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | total
 | 3
 |  | 6
 |  |  |  | 3
 |  |  |  |  |  |  |  |  | 7
 |  |  | 6
 |  |  |  |  |  |  | 9
 | 6
 |  |  |  |  |  |  |  |  | 9
 |  |  |  | 8
 |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  | 20
 |  |  |  |  |  |  | 34
TOTALS
Spreadsheet: daren_farmer__5662__HPLN0105
Sheet: Sheet1

HPLN0105.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - Januar 5, 2001
 |  |  |  |  |  | **Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-01-05 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 116673d1311975613-selective-columns-abbey-hill
Sheet: Ss

Smith. S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 791091d1660148638-mail-address-lookup-advanced-drainage-systems-response
Sheet: Advanced Drainage Systems Inc

Company | Address1 | Address2 | City | State | Phone | Lookup Field
Advanced Drainage Systems Inc (ADS) | 5751 [NAME] |  | Houston | TX | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Yoakum | TX | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Hempstead | TX | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Ennis | TX | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Winter Garden | FL | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Norcross | GA | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Bessemer | AL | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Eagle Grove | IA | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Kansas City | MO | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Phoenix | AZ | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | London | OH | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Deerfield Beach | FL | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | [NAME] | MS | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | [NAME] | GA | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Wooster | OH | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Logan Township | NJ | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Panama City Beach | FL | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Mendota | IL | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | [NAME] | OH | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | North Salt Lake | UT | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Ludlow | MA | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Monticello | IL | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Clifford | MI | [PHONE]
Advanced Drainage Systems Inc (ADS) |  |  | Vicksburg | MS | [PHONE]
Spreadsheet: 829975d1684590419-how-to-get-a-cell-formula-to-automatically-paste-values-calculation-help
Sheet: Sheet1

 |  |  |  |  | Amount LCY | CCY | Conversion Amount (£) | Hard value amount (£)
 |  |  |  |  | 17.22 | GBP |  |  |  |  |  | #[NAME]!
 |  |  |  |  | 109.85 | GBP |  |  |  |  |  | #[NAME]!
 |  |  |  |  | 112.26 | GBP |  |  |  |  |  | #[NAME]!
 |  |  |  |  | 19.06 | GBP
 |  |  |  |  | 47.39 | EUR
 |  |  |  |  | 22.6 | GBP
 |  |  |  |  | 9.98 | GBP
 |  |  |  |  | 168 | USD
 |  |  |  |  | 24.61 | GBP
 |  |  |  |  | 350 | CHF
 |  |  |  |  | 9.98 | GBP
 |  |  |  |  | 12 | CHF
 |  |  |  |  | Is there a way when a value is put into column 'F' the value calculated in 'H' is then automatically pasted as a value in column 'I'.
 |  |  |  |  | I am looking for an automatic way to get the column 'H' values hard coded after the calculation as currently the values change with the change in currency prices.
 |  |  |  |  | Any suggestions will be much appreciated!
Spreadsheet: 787270d1657711323-formulas-copy-paste-but-not-in-all-lines-sample
Sheet: Sheet1

name | country | addres | Unique number
A | B | C | 100 | 10 | 20 | 30
A | B | C | 100 | 0 | 0 | 0
A | B | C | 100 | 0 | 0 | 0
A | B | C | 100 | 0 | 0 | 0
D | E | F | 200 | 40 | 50 | 60
G | H | I | 300 | 20 | 30 | 40
J | K | L | 400 | 70 | 80 | 30
J | K | L | 400 | 0 | 0 | 0
J | K | L | 400 | 0 | 0 | 0
M | N | O | 500 | 20 | 10 | 30
M | N | O | 500 | 0 | 0 | 0
M | N | O | 500 | 0 | 0 | 0
M | N | O | 500 | 0 | 0 | 0
M | N | O | 500 | 0 | 0 | 0
M | N | O | 500 | 0 | 0 | 0
M | N | O | 500 | 0 | 0 | 0
P | Q | R | 600 | 90 | 80 | 70
S | T | U | 700 | 10 | 10 | 30
S | T | U | 700 | 0 | 0 | 0
S | T | U | 700 | 0 | 0 | 0
S | T | U | 700 | 0 | 0 | 0
S | T | U | 700 | 0 | 0 | 0
S | T | U | 700 | 0 | 0 | 0
V | W | X | 800 | 40 | 40 | 50
V | W | X | 800 | 0 | 0 | 0
V | W | X | 800 | 0 | 0 | 0
V | W | X | 800 | 0 | 0 | 0
V | W | X | 800 | 0 | 0 | 0
V | W | X | 800 | 0 | 0 | 0
V | W | X | 800 | 0 | 0 | 0
V | W | X | 800 | 0 | 0 | 0
V | W | X | 800 | 0 | 0 | 0
V | W | X | 800 | 0 | 0 | 0
V | W | X | 800 | 0 | 0 | 0
Spreadsheet: 163769d1340451094-searching-and-correlating-searching-and-correlating
Sheet: Hoja1

 |  |  |  |  |  |  |  |  |  |  |  |  | What I need is fill this column with the new codes
 |  |  |  |  |  |  |  | CODES CORRELATIONS |  |  |  | Data received | New industry code code
 |  |  |  |  |  |  |  | Old industry code code | Industry | New industry code code
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 11
 |  |  |  |  |  |  |  | 1 | Insurers | 11 |  | 1 | 11
 |  |  |  |  |  |  |  | 2 | home building | 12 |  | 1 | 11
 |  |  |  |  |  |  |  | 3 | Banks | 13 |  | 2 | 12
 |  |  |  |  |  |  |  | 4 | Car dealers | 14 |  | 2 | 12
 |  |  |  |  |  |  |  | 5 | Advertising | 15 |  | 4 | 14
 |  |  |  |  |  |  |  | 6 | Farming | 16 |  | 4 | 14
 |  |  |  |  |  |  |  | 7 | Food & beberage | 17 |  | 5 | 15
 |  |  |  |  |  |  |  | 8 | Transport | 18 |  | 5 | 15
 |  |  |  |  |  |  |  |  |  |  |  | 6 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 7 | 17
 |  |  |  |  |  |  |  |  |  |  |  | 7 | 17
 |  |  |  |  |  |  |  |  |  |  |  | 11 | 11
 |  |  |  |  |  |  |  |  |  |  |  | 11 | 11
 |  |  |  |  |  |  |  |  |  |  |  | 13 | 13
 |  |  |  |  |  |  |  |  |  |  |  | 15 | 15
 |  |  |  |  |  |  |  |  |  |  |  | 15 | 15
Spreadsheet: 165621d1341305331-setting-up-rule-based-values-in-excel-help-required-resource-calculator_forum
Sheet: Pricing Data

Expenses |  | Flights (average cost) USD |  | Hotel (average cost) USD
Project location |  | From Dubai | From London | per night
UAE | Abu Dhabi | 0 | 1145.55 | 180.015
Qatar | Doha | 196.38 | 981.9000000000001 | 245.475
Kuwait | Kuwait City | 196.38 | 1472.85 | 278.205
KSA | Riyadh | 294.57 | 1472.85 | 245.475
KSA | Jeddah | 392.76 | 1472.85 | 245.475
Oman | Muscat | 294.57 | 1309.2 | 196.38
Bahrain | Manama | 180.015 | 1472.85 | 196.38
Cross charge rates | From London office |  | Local MENA Recruitment
London
MENA | GBP day rate | USD day rate | GBP day rate | USD day rate
Principal | 100 |  |  | 250
Consultant | 75 |  |  | 150
Technical Analyst | 50 |  |  | 100
Pe diem rate | 75
Y | N
Exchange rates | GBP £1 = | USD $1 =
USD | 1.6365 | 0
UAE Dirham | 5.68 | 3.67
Kuwaiti Dinar | 0.44 | 0.28
KSA Riyal | 5.89 | 3.74
Oman Rial | 0.6 | 0.38
Bahraini Dinar | 0.59 | 0.37
Spreadsheet: cc1fc9cf-5d31-48ae-854c-0684269bc982
Sheet: Sheet12

scrapped | 5202 | 5203 | 5205 | 5204
R44 | 5206 | 5207 | 5209 | 5208
R44 | 5210 | 5211 | 5213 | 5212
scrapped | 5214 | 5215 | 5217 | 5216
R44 | 5218 | 5219 | 5221 | 5220
R44 | 5222 | 5223 | 5225 | 5224
R44 | 5226 | 5227 | 5229 | 5228
R44 | 5230 | 5231 | 5233 | 5232
R44 | 5234 | 5235 | 5237 | 5236
scrapped | 5238 | 5239 | 5241 | 5240
R44 | 5242 | 5243 | 5245 | 5244
scrapped | 5246 | 5247 |  | 5248
R44 | 5250 | 5251 | 5249 | 5270 |  | 5252
R44 | 5254 | 5255 | 5257 | 5256 |  | 5253
R44 | 5262 | 5263 | 5303 | 5302 |  | 5259
scrapped | 5264 | 5265 | 5267 | 5266
R44 | 5266 | 5267 | 5269 | 5268 |  | 5258
R44 | 5268 | 5269 | 5271 | 5284
R44 | 5274 | 5275 | 5277 | 5276
R44 | 5276 | 5277 | 5261 | 5260
R44 | 5278 | 5279 | 5281 | 5280
scrapped | 5282 | 5283 | 5285
R44 | 5286 | 5287 | 5289 | 5288
scrapped | 5290 | 5291 | 5293 | 5292
R44 | 5294 | 5295 | 5297 | 5296
R44 | 5298 | 5299 | 5301 | 5300
scrapped | 5306 | 5307 | 5309 | 5308
R44 | 5310 | 5311 | 5313 | 5312
R44 | 5314 | 5315
 | 5316 | 5317 | 5405 | 5318
R44 | 5322 | 5323 | 5325 | 5324
R44 | 5326 | 5327 | 5329 | 5328
R44 | 5330 | 5331 | 5333 | 5332
scrapped | 5334 | 5335 | 5337 | 5336
R44 | 5338 | 5339 | 5341 | 5340
scrapped | 5342 | 5343 | 5345 | 5344
R44 | 5346 | 5347 | 5349 | 5348
R44 | 5350 | 4351 | 5353 | 5352
scrapped | 5354 | 5355 | 5357 | 5356
R44 | 5358 | 5359 | 5361 | 5360
R44 | 5362 | 5363 | 5365 | 5364
R44 | 5366 | 5367 | 5369 | 5368
R44 | 5370 | 5371 | 5373 | 5372
R44 | 5374 | 5375 | 5377 | 5376
R44 | 5378 | 5379 | 5381 | 5380
R44 | 5382 | 5383 | 5385 | 5384
R44 | 5386 | 5387 | 5389 | 5388
R44 | 5390 | 5391 | 5393 | 5392
R44 | 5394 | 5395 | 5397 | 5396
R44 | 5398 | 5399 | 5401 | 5400
R44 | 5402 | 5403 |  |  |  |  | (S)
R44 | 5406 | 5407 | 5409 | 5408
R44 | 5410 | 5411 | 5413 | 5412
R44 | 5414 | 5415 | 5417 | 5416
R44 | 5418 | 5419 | 5421 | 5420
R44 | 5422 | 5423 | 5425 | 5424
R44 | 5426 | 5427 | 5429 | 5428
R44 | 5430 | 5431 | 5433 | 5432
R44 | 5434 | 5435 | 5437 | 5436
R44 | 5438 | 5439 | 5441 | 5440
R44 | 5442 | 5443 | 5445 | 5444
R44 | 5446 | 5447 | 5449 | 5448
R44 | 5450 | 5451 | 5453 | 5452
R44 | 5454 | 5455 | 5457 | 5456
R44 | 5458 | 5459 | 5461 | 5460
R44 | 5462 | 5463 | 5465 | 5464
R44 | 5466 | 5467 | 5469 | 5468
R44 | 5470 | 5471 | 5473 | 5472
R44 | 5474 | 5475 | 5477 | 5476
R44 | 5478 | 5479 | 5405 | 5404
R44 |  |  | 5337 | 5336
scrapped |  |  | 5305 | 5304
R44 |  | 5319 | 5321 | 5320
R44 |  |  | 5273 | 5272
R44 |  | 5283 | 5285 | 5284 |  |  | (U)
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 4Inter O&M 1-10

Table 5.2.39.  Present Value of Intermittent Operations and [NAME] (Years 1-10)
 |  |  |  |  |  |  |  |  |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of O&M Costs for Year:
Component | Unit Cost | Unit | Quantity | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  | Total Present Value of Intermittent Operations & Maintenace Costs (Years 1-10):
Spreadsheet: 594231d1539641154-sumifs-excel-forum-formula
Sheet: Sheet2

 |  | Term | 10
 |  | Discount | 0.06
 |  |  | Months | Amount | Amort Schedule
 |  |  | 1 | 100
 |  |  | 1
 |  |  | 1
 |  |  | 1
 |  |  | 1
 |  |  | 1 | 100 |  | ($10 + ($100/5 months remaining)
 |  |  | 1
 |  |  | 1
 |  |  | 1
 |  |  | 1
Spreadsheet: 98882d1297709854-how-can-i-have-data-inserted-based-on-typed-in-dates-vekkor-1
Sheet: Saturday,January 01, 2011

Daily Cash Receipts Register
Saturday, January 01, 2011
Name | Payment Type | Receipt # | Credit/Debit Amt | Check Amt | Check # | Cash | [NAME] # | Total
[NAME] | $5.00 coupon | 555900 |  |  |  | 20
[NAME] | [NAME] | 555901 |  |  |  | 0
[NAME] | Retail | 555902 | 25
Totals:
Spreadsheet: 685505d1594045249-counting-distinct-values-within-different-sub-ranges-sample-data
Sheet: Sheet1

Sample Data |  |  |  |  | Desired Results (no formula) |  |  |  |  | Please enter solutions here
Hospital | Ward | Patient ID | Access |  | Ward (DFH) | No. of pt with IV devices | No of IV devices | Percentage of pt. with an IV device |  | Ward (DFH) | No. of pt with IV devices | No of IV devices | Percentage of pt. with an IV device
DFH | Critical Care | 1908a | Peripheral IV cannula (PIV) |  | Critical Care | 4 | 5 |  |  | Critical Care
DFH | Critical Care | 1908a | Other |  | CSU1 | 3 | 3 |  |  | CSU1
DFH | Critical Care | 1826b | Short-term CVC
DFH | Critical Care | 1356c | Portacath
DFH | Critical Care | 4582a | Midline |  | The sample data on the left shows where medical devices are being used across a range of hospitals. Using the sample data, I want to calculate:  1) the number of devices that are being used on each ward. This the same as a count of each ward.  2) the number of patients in each ward, which is a count of the distinct values for each ward. For example, there are 5 devices being used in Critical Care but 2 of those are being used on one person, therefore there are 4 patients on that ward.  the answers are in G4:H5 but i have calculated them manually. can anyone provide formulas to caluclate this
DFH | CSU1 | 8374a | Vascath
DFH | CSU1 | 8374a | Other
DFH | CSU1 | 4729b | Peripheral IV cannula (PIV)
Spreadsheet: 551019d1512660115-staff-holiday-planner-ef1120_plot_dates
Sheet: RESULTS

2018
 | DESIRED RESULT
 | [NAME] | SMITH
 | SARAH | ANDREWS
Spreadsheet: 000bab08-0082-4ae7-bd64-31433ff2ee71
Sheet: Sheet1

CTI--FEBRUARY 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
NAME | STATE | ARRIVE | DEPART
Penny & Jamie | MD | 2 | 9
Pam & Ronnie | OK | 5 | 12
Donna & Pat | WI | 7 | 11
Beverly & Tom | MI | 9 | 23
Donna & Curtis | TX | 10 | 17
Nikki & Josh | SC | 13 | 20
Cathy & Alan | MI | 13 | 23
Tina & Jodi | Newfoundland | 13 | 20
Brian & Star | WI | 20 or 25 | 26 or 7th
David & Mary | NH | 23 | 2010-03-01 00:00:00
Barb & ? | ? | 6 | 14
Harold & Sabrina | OH | 19 | 26
Darryl & Candace | Regina, Sask. | 14 | 21
Josh & Jennie | MN | 8 | 14
[NAME] | Toronto | 1 | 10
Ted & Cindy | FL | 19 | 27
Dave & Cheryl | ? | 2010-01-29 00:00:00 | 5
Tim & Salina | ? | 15 | 22
Graham & Maureen | UK | 9 | 23
Rex & Gloria | UK | 9 | 23
[NAME] | UK | 9 | 30
Chris & Ann | Canada | 16 | 2010-03-02 00:00:00
Bill & Lana | MI | 18 | 25
Spreadsheet: 718235d1613055653-conditional-xlookup-xlookup-formula
Sheet: Sheet2

M001
M002
M003
M004
M005
M006
M007
M008
M009
M010
M011
M012
M013
M014
M015
M016
M017
M018
M019
M020
M021
M022
M023
M024
M025
M026
M027
M028
M029
M030
M031
M032
M033
M034
M035
M036
M037
M038
M039
M040
M041
M042
M043
M044
M045
M046
M047
M048
M049
M050
M051
M052
M053
M054
M055
M056
M057
M058
M059
M060
M061
M062
M063
M064
M065
M066
M067
M068
M069
M070
M071
M072
M073
M074
M075
M076
M077
M078
M079
M080
M081
M082
M083
M084
M085
M086
M087
M088
M089
M090
M091
M092
M093
M094
M095
M096
M097
M098
M099
M100
M101
M102
M103
M104
M105
M106
M107
M108
M109
M110
M111
M112
M113
M114
M115
M116
M117
M118
M119
M120
M121
M122
M123
M124
M125
M126
M127
M128
M129
M130
M131
M132
M133
M134
M135
M136
M137
M138
M139
M140
M141
M142
M143
M144
M145
M146
M147
M148
M149
M150
M151
M152
M153
M154
M155
M156
M157
M158
M159
M160
M161
M162
M163
M164
M165
M166
M167
M168
M169
M170
M171
M172
M173
M174
M175
M176
M177
M178
M179
M180
M181
M182
M183
M184
M185
M186
M187
M188
M189
M190
M191
M192
M193
M194
M195
M196
M197
M198
M199
M200
M201
M202
M203
M204
M205
M206
M207
M208
M209
M210
M211
M212
M213
M214
M215
M216
M217
M218
M219
M220
M221
M222
M223
M224
M225
M226
M227
M228
M229
M230
M231
M232
M233
M234
M235
M236
M237
M238
M239
M240
M241
M242
M243
M244
M245
M246
M247
M248
M249
M250
M251
M252
M253
M254
M255
M256
M257
M258
M259
M260
M261
M262
M263
M264
M265
M266
M267
M268
M269
M270
M271
M272
M273
M274
M275
M276
M277
M278
M279
M280
M281
M282
M283
M284
M285
M286
M287
M288
M289
M290
M291
M292
M293
M294
M295
M296
M297
M298
M299
M300
Spreadsheet: 763698d1642328886-summarise-data-from-multiple-tables-in-dynamic-summary-table-commission
Sheet: OUTPUT

 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | Fast Check |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | [NAME] |  | RTGS IN | CASH OUT | Comm | Balance | L/D |  |  |  |  | Dhruv
 |  | Date | 2022-01-04 00:00:00 |  |  |  |  |  |  |  |  |  | Dhruv Personal
 |  | Previous Date |  |  |  |  |  |  |  |  |  |  | Pradeep
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Hement
 |  |  |  |  |  |  |  |  |  |  |  |  | Sandeep Y190
 |  |  |  |  |  |  |  |  |  |  |  |  | Ravi
 |  |  |  |  |  |  |  |  |  |  |  |  | Lakhan
 |  |  |  |  |  |  |  |  |  |  |  |  | VK
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Goldy
 |  |  |  |  |  |  |  |  |  |  |  |  | Nitin
 |  |  |  |  |  |  |  |  |  |  |  |  | KP
 |  |  |  |  |  |  |  |  |  |  |  |  | SN
 |  |  |  |  |  |  |  |  |  |  |  |  | Nitin X 23
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Sardar
 |  |  |  |  |  |  |  |  |  |  |  |  | Neeraj
 |  |  |  |  |  |  |  |  |  |  |  |  | Rajender
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Bablu MM
 |  |  |  |  |  |  |  |  |  |  |  |  | Sorav X55
 |  |  |  |  |  |  |  |  |  |  |  |  | HKT
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: rick_buy__32663__Rac allocations budget pack 29 Nov
Sheet: Summary

Summary |  |  | 2001 | 2000 |  |  | Notes for MRG
 | Headcount |  |  |  |  |  | link to "Direct"
 | Direct Costs |  |  |  |  |  | link to "Direct"
 | Headcount allocations received |  | 0 |  | note: comparatives not available |  | link to "Alloc in by region (HC)"
 | Region costs allocated out |  |  |  | note: comparatives not available |  | link to "Alloc out by CC (IO)" for most depts and "Alloc out by CC (HC)" for any CC that allocates out on HC
 | Allocations in on Time Method (Projects) |  | 0 |  | note: comparatives not available |  | link to Alloc in by region (IO)
 | Allocations in from Corp |  | 2083000 | 1597000 |  |  | from file sent by [NAME]
 | Total costs for the region |  |  | n/a |  |  | check this against the total line (the hidden one) on "Alloc in by region (IO)"
 |  |  |  |  |  |  | Note: on each of the schedules, you must remove the amount related to the dept you are analysing from the total
 |  |  |  |  |  |  | Note: remember to refresh the "Total Allocations graph data"