tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 77120d1277582733-does-this-require-vlookup-service-dispatch-w-tabs
Sheet: WARR JOBS

A Customer | RO | Tech | Date |  |  |  |  | Reason for Hold
FROST | 66713 | BF | 2010-06-08 00:00:00
GAJDOSIK | 66745 | DH | 2010-06-08 00:00:00
KLEIMAN | 66841 | MH | 2010-06-10 00:00:00
WARNER | 66837 | RA | 2010-06-11 00:00:00
WURGLER | 66811 | ROB | 2010-06-15 00:00:00
MASCH | 66907 | TP | 2010-06-15 00:00:00
SALZMAN | 66900 | TP | 2010-06-15 00:00:00
OTT | 66927 | DH | 2010-06-16 00:00:00
LONG | 66931 | JZ | 2010-06-16 00:00:00
ZORN | 66914 | TF | 2010-06-16 00:00:00
CULBERTSON | 66829 | TP | 2010-06-16 00:00:00 |  |  | TECH | WARR |  | NEXT UP:
DRONSO | 66312 | BS | 2010-06-18 00:00:00 |  |  | BF | 2 | 0 | RG
SLOMINSKI | 65853 | DH | 2010-06-19 00:00:00 |  |  | BS | 2 | 2 | TF
INTERNAL | 67047 | BS | 2010-06-22 00:00:00 |  |  | DH | 5 | 3 | BF
WOEHLERT | 67071 | BF | 2010-06-23 00:00:00 |  |  | JZ | 2 | 1 | RA
AVELLO | 67052 | DH | 2010-06-23 00:00:00 |  |  | RA | 2 | 2
GLOGOWSKI | 67083 | DH | 2010-06-24 00:00:00 |  |  | RG | 1 | 2
COERPER | 67078 | RA | 2010-06-24 00:00:00 |  |  | TF | 2 | 0
SEDER | 67080 | RG | 2010-06-24 00:00:00 |  |  | TP | 3 | 2
SUYCOTT | 67068 |  | 2010-06-24 00:00:00 |  |  | ROB | 1 | 0
REID | 67113 | JZ | 2010-06-25 00:00:00
[NAME] | 67016 | ROB | 2010-06-25 00:00:00
ROSGA | 66549 | TF
MEISE | 66744
SILVERLING | 66743
Spreadsheet: tracy_geaccone__40541__tw_actflash_o&m
Sheet: TWSEP01

[NAME]
O&M by Alternate Hierarchy
Period Ending September 30, 2001
6th Workday
 | Actual | Actual | Flash | Over/(Under) | Over/(Under) | Actual | Actual
 | August 2001 | September 2001 | September 2001 | Prior Month | Flash | YTD September 2001 | YTD August 2001
ETS - Commercial (AGR-TP10) | 108777.7 |  | 167000 |  |  |  | 1486618.29
ETS - Market Services (AGR-TP20) | 122832.08 |  | 196000 |  |  |  | 1033689.01
ETS - Operations (AGR-TP30) | 2477725.17 |  | 1132000 |  |  |  | 18328524.03
ETS - Finance & Accounting (AGR-TP40) | 763111.09
ETS - Systems (AGR-TP50) | 305579.14 |  | 352000 |  |  |  | 1769510.62
ETS - Legal (AGR-TP60) | 74578.7 |  | 126000 |  |  |  | 573583.74
ETS - HR (AGR-TP70) | 22705.03 |  | 23000 |  |  |  | 194840.04
ETS - Executive (AGR-TP80) | 49691.09 |  | 23000 |  |  |  | 870262.2
Total O&M Expense
(A) R111477 includes YTD September Adjustment for FI/CO reconciliation of $(48,125.70) (AGR-NN40)
[NAME]
O&M by Alternate Hierarchy
Period Ending September 30, 2001
(000's)
 | Actual | Actual | Flash | Over/(Under) | Over/(Under) | Actual
 |  |  |  | Prior Month | Flash
ETS - Commercial (AGR-NN10)                                (A)
ETS - Market Services (AGR-NN20)
ETS - Operations (AGR-NN30)                                  (B)
ETS - Finance & Accounting (AGR-TP40)                 (C)
ETS - Systems (AGR-NN50)
ETS - Legal (AGR-NN60)
ETS - HR (AGR-NN70)
ETS - Executive (AGR-NN80)
Total O&M Expense
Prior month variance Footnote (A):
Increase due to Aug Aviation correction to CC 111039 | 28
Increase due to Aug Severance & Relocation reversal CC 111089 | 20
Increase in Commercial Support Exec allocated costs CC 111016 | 21
Prior month variance Footnote (B):
August Gallup Sector 5 P/L Repairs - Risk Mgmt.
Settlement from X.001097.[PHONE] | -323
Decrease in fees/permits CC 111102 | -69
Decrease in Salaries & Wages | -108
Decrease in Utilities for Carlsbad Team CC 111139 | -46
Other | 12
Prior month variance Footnote (C):
Increase in Environ Exp for PCB payment to Southern Calif Gas CC111080 | 126
Decrease in ETS O/S Service Alloc CC 112536 | -20
Other | -17
Spreadsheet: 758464d1638887150-populate-data-based-on-selection-from-dropdown-project-planning
Sheet: Estimation

Project Estimation Report
S.no | Invoice No | [NAME] | Unit Rate | TOTAL | Project Code | Client | Type | [NAME] | Region | City | Work Day | Petty Cash | Labor Cost | Inventory Cost | Admin Cost
1 |  |  |  |  |  |  |  |  | Riyadh |  |  |  | 208909 | 186391.67 | 702295.9299999999
2 |  |  |  |  |  |  |  |  | Jeddah
3 |  |  |  |  |  |  |  |  | Jeddah
4 |  |  |  |  |  |  |  |  | Jeddah
5 |  |  |  |  |  |  |  |  | Jeddah
6 |  |  |  |  |  |  |  |  | Jeddah
7 |  |  |  |  |  |  |  |  | Jeddah
8 |  |  |  |  |  |  |  |  | Jeddah
9 |  |  |  |  |  |  |  |  | Riyadh
10 |  |  |  |  |  |  |  |  | Jeddah
11 |  |  |  |  |  |  |  |  | Jeddah
12 |  |  |  |  |  |  |  |  | Jeddah
13 |  |  |  |  |  |  |  |  | Jeddah
14 |  |  |  |  |  |  |  |  | Jeddah
15 |  |  |  |  |  |  |  |  | Jeddah
16 |  |  |  |  |  |  |  |  | Jeddah
17 |  |  |  |  |  |  |  |  | Jeddah
18 |  |  |  |  |  |  |  |  | Riyadh
19 |  |  |  |  |  |  |  |  | Jeddah
20 |  |  |  |  |  |  |  |  | Jeddah
21 |  |  |  |  |  |  |  |  | Jeddah
22 |  |  |  |  |  |  |  |  | Riyadh
23 |  |  |  |  |  |  |  |  | Riyadh
24 |  |  |  |  |  |  |  |  | Riyadh
25 |  |  |  |  |  |  |  |  | Riyadh
26 |  |  |  |  |  |  |  |  | Riyadh
27 |  |  |  |  |  |  |  |  | Riyadh
28 |  |  |  |  |  |  |  |  | Riyadh
29 |  |  |  |  |  |  |  |  | Riyadh
30 |  |  |  |  |  |  |  |  | Riyadh
31 |  |  |  |  |  |  |  |  | Jeddah
Spreadsheet: 53018613-e6de-49f9-996b-320b976a2b0a
Sheet: Sheet2

corruption in international business
Balance of Payments in addition to Kahn
Absolute Advantage, Comparative Advantage,
Trade theory in general
Porter's the Competitive Advantage of Nations
Non-tariff barriers
GATT
WTO
WTO dispute resolution process
Foreign Direct Investment trends and/or pros and cons
Allende and Pinochet and the Chilean Economy
Debt Crisis in the EU - other than [NAME]
UNASUR and or MERCOSUR
Free Trade Agreement of the Americas
the Bretton Woods Agreement
The gold standard
Fixed and floating exchange rates
Currency boards
Soft fix currency system
Currency rates (other than Kahn Academy)
Purchasing Power Parity
Big Mac Index
Economic/Currency crises in Asia, Mexico, Russia or others
The IMF
Spreadsheet: 0b1ab8a2-a440-4cd8-a88a-cd15a0c42738
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
Cuadro 3.23-10-6
[NAME]
Egresos municipales de la región Sureste por sub-región y provincia, según año, 1998-2007
(Valor en RD$)
[NAME] | Total egresos región sur este | Egresos según Sub-Región de Valdesia | Egresos según Distrito Nacional | Egresos según provincia Santo [NAME] | Egresos según provincia [NAME] | Egresos según provincia Peravia | Egresos según [NAME] | Egresos según provincia [NAME] | Egresos según Sub Región del Yuma | Egresos según [NAME] | Egresos según provincia  [NAME] | Egresos según provincia [NAME] | Egresos según provincia [NAME] | Egresos según provincia Hato Mayor
1998 | 332606939 | 181299478 | … | … | … | 51593075 | 93446822 | 36259581 | 151307461 | 20309785 | 29440051 | 35036960 | 43906715 | 22613950
1999 | 1086030658 | 896680929 | 687449274 | … | … | 60176164 | 109108837 | 39946654 | 189349729 | 23342272 | 39428448 | 46017742 | 57441051 | 23120216
2000 | 396548713 | 219396508 | … | … | … | 62354153 | 112308785 | 44733570 | 177152205 | 26400733 | 51060041 | 48009352 | 34287576 | 17394503
2001 | 294549584 | 129341099 | … | … | 2553586 | 25564940 | 38315662 | 62906911 | 165208485 | 28640776 | 17691894 | 46590214 | 63698590 | 8587011
2002 | 88720819 | 26849548 | … | … | … | 8452392 | 4203429 | 14193727 | 61871271 | 9297937 | … | 48584148 | 3166506 | 822680
2003 | 152007518 | 23231922 | … | … | … | 10502998 | 5279762 | 7449162 | 128775596 | … | … | 67132764 | 61642832 | …
2004 | 979228075 | 558209829 | … | 11841613 | 96385 | 156199734 | 275289623 | 114782474 | 421018246 | 44212410 | 129168623 | 138454595 | 74088394 | 35094224
2005 | 1519440449 | 793545406 | … | 138996572 | 70354126 | 197647175 | 245334362 | 141213171 | 725895043 | 105206097 | 164995635 | 121916135 | 257801425 | 75975751
2006 | 3849684473.76 | 2957144263.12 | 2214267994.98 | 66412593 | 86749777.61 | 170307285.27 | 244802877 | 174603735.26 | 892540210.64 | 74337723.67 | 275987389.95 | 39597041 | 381837510.02 | 120780546
2007P | 25482880002.6 | 16442815626.73 | 3301720340.68 | 7518378464 | 260798012.89 | 2221764764.27 | 712074310.89 | 2428079734 | 9040064375.869999 | 67073077.55 | 303305218.91 | 338716222 | 7985660283.41 | 345309574
(P): [NAME] preliminares
Fuentes: [NAME] y la Liga Municipal Dominicana
Spreadsheet: 773403d1647858540-need-sum-based-on-duplicate-ids-sum-of-values-based-on-duplicate-ids
Sheet: Required

Week | 11 |  | Change Week number
Agent | Total Missed | Completed by other | Actual Missed | Declined
AG
AC
BC
B
DY
D
E
G
J
M
O
R
RM
RF
T
TW
Total
Notes: | Please see Data tab for details.
* Sum or Count is based on ID (C) as unique identifier
If ID (C) and Agent Name (D) are blank then Status is "In Que"
If ID (C) is blank but Agent Name (D) is not blank then Status will be based on value of F, G, and H
If [NAME] (F), Accepted (G), and Declined (H) are 0, then status is "In Que".
If [NAME] (F) is 1 but Accepted (G) and Declined (H) are 0, then status is "Missed".
If [NAME] (F) and Accepted (G) are 1 but Declined (H) is 0, then status is "Completed".
Spreadsheet: 120713d1315478978-match-two-seperate-rows-to-bring-back-a-different-cloumn-value-match-two-rows-and-bring-back-a-column
Sheet: Front

Lookup | Account | Zone | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
 | A | Red
 | A | Yellow
 | A | Green
 | A | Blue
 | B | Red
 | B | Yellow
 | B | Green
 | B | Blue
 | C | Red
 | C | Yellow
 | C | Green
 | C | Blue
Spreadsheet: 707587d1607356296-vlookup-returning-incorect-information-test
Sheet: Sheet1

SITE | Claimants | Workcoach FTE | Interventions | Interventions Per FTE | Attended | Failed To Attend | Cancelled | Rescheduled | Rescheduled (Channel
WEST LONDON
[NAME] | 16166 | 17.29 | 1740 | 100.66 | 987 | 94 | 230 | 316 | 12
Ealing | 32126 | 46.89 | 3060 | 65.26 | 2075 | 285 | 226 | 319 | 2
Fulham | 18374 | 39.16 | 2639 | 67.39 | 1520 | 263 | 312 | 345 | 4
[NAME] | 24321 | 27.97 | 2553 | 91.28 | 1436 | 219 | 222 | 345 | 22
[NAME] | 13026 | 19.41 | 2001 | 103.08 | 1142 | 269 | 149 | 315 | 5
Harlesden | 31715 | 52.09 | 2884 | 55.37 | 1720 | 236 | 347 | 291 | 9
Hounslow | 37222 | 57.05 | 3642 | 63.84 | 2116 | 320 | 298 | 417 | 3
Kingston | 14285 | 16.71 | 1731 | 103.62 | 977 | 180 | 128 | 317 | 0
[NAME] | 9612 | 18.61 | 1210 | 65.01 | 741 | 158 | 67 | 177 | 4
[NAME] | 9824 | 13.35 | 1369 | 102.53 | 911 | 96 | 105 | 162 | 10
Uxbridge | 15167 | 23.3 | 2206 | 94.7 | 1391 | 334 | 179 | 217 | 2
Wandsworth | 15983 | 26.03 | 2520 | 96.81 | 1387 | 301 | 256 | 415 | 5
Wembley | 16913 | 31.44 | 1999 | 63.58 | 951 | 189 | 250 | 243 | 3
WEST LONDON
WEST LONDON
[NAME] | 2363.05494505492 | 11.9593406593407 | 1266.24175824176 | 88.0836263736264 | 533.604395604392 | 258 | 103.549450549451 | 158.934065934066 | -4.09890109890107
Spreadsheet: 864796d1711938526-calculate-elapsed-time-in-days-hours-and-minutes-excluding-weekends-and-holidays-time-calculator-aligw
Sheet: Holiday Register

Holiday Register
DATE | DAY | [NAME]?
2024-01-01 00:00:00
2024-02-09 00:00:00
2024-03-28 00:00:00
2024-03-29 00:00:00
2024-04-09 00:00:00
2024-04-10 00:00:00
2024-05-01 00:00:00
2024-06-12 00:00:00
2024-06-17 00:00:00
2024-08-21 00:00:00
2024-08-26 00:00:00
2024-11-01 00:00:00
2024-12-25 00:00:00
2024-12-30 00:00:00
2024-12-31 00:00:00
2024-02-09 00:00:00
2024-01-06 00:00:00
2024-01-07 00:00:00
2024-01-13 00:00:00
2024-01-14 00:00:00
2024-01-20 00:00:00
2024-01-21 00:00:00
2024-01-27 00:00:00
2024-01-28 00:00:00
Spreadsheet: c48fa281-ff04-4dde-8eef-a72141915ee5
Sheet: Sheet1

Senior Division | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Number | AGA Rank | Age | Name | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Total points | Place
1 | 8k | 15 | [NAME] |  | 2 | 0 | 2 | 0 | 4 | 3
2 | 4k | 15 | [NAME] | 0 |  | 0 | 2 | 0 | 2 | 4
3 | 6d | 13 | [NAME] | 2 | 2 |  | 2 | 2 | 8 | 1
4 | 19k | 12 | [NAME] | 0 | 0 | 0 |  | 0 | 0 | 5
5 | 6d | 13 | [NAME] | 2 | 2 | 0 | 2 |  | 6 | 2
Spreadsheet: rick_buy__32818__NP Daily Marks
Sheet: COB 092101

The New Power Company
Credit Exposure by Enron Entity
As of COB September 21, 2001
Enron Entity | Fin. MTM | Phy. MTM | Sales | Purchases | Net Del. (1) | Net Exp.
Enron Energy Services, Inc. | 4854913 | 43791276 | 301295 | 0
Enron North America Corp. | 49737446 | 5735410 | 7755482 | -804191
Enron Power Marketing, Inc. | 0 | 7724980
 |  |  |  |  | In Collateral (2) | -109300000
 |  |  |  |  | Treashold (3) | 0
 |  |  |  |  | Total Exposure (4)
(1) Net Del. For EPMI capacity payments have been adjusted to reflect EnPower's marks
(2) Per Master Netting Agreement Collateral in the amount of $109.3MM is applied across Enron Entities
(3) Not in compliance with unrestricted cash covenant
(4) Margin call made on 9/21/01 for $8.5MM peding payment on 9/24/01
Spreadsheet: 98222d1297217104-sum-values-of-cells-containing-formulas-countemailaddresses
Sheet: Sheet1

[NAME] | Text | Number
[NAME] | 1 | 1 | << Look at the difference between these formulas.
[NAME] | 0 | 0
Bob@Mary | 1 | 1
Junk | 0 | 0
 |  | 2 | <<Sum because using numbers and not text
 | 2 | <<Count because the "1" is text and not a number
Spreadsheet: 698172d1601826521-vlookup-with-rank-and-if-tournament
Sheet: 6

[NAME]: |  |  |  |  |  |  | Voor:
Raja paar |  | Mängijate nimed |  |  |  |  |  | [NAME]
15-16 | 1
 | 2
 | 3
13-14 | 1
 | 2
 | 3
10-9 | 1
 | 2
 | 3
16-15 | 1
 | 2
 | 3
10-9 | 1
 | 2
 | 3
 |  | [NAME] tulemus:
 |  | HCP
 |  | [NAME]:
 |  | [NAME]
 |  | V/punkt
[NAME]: |  | _____________________ |  | [NAME]: | ___________________________
Spreadsheet: 697812d1601553650-solved-help-analyzing-data-in-a-table-shared-expense-who-owes-whom-splitting-costs-tactics-pq
Sheet: method 1

Credit | Debit | Amount | 《《 data link to "Data (table)", processed by Power Query, refresh to update
Adam | [NAME] | 3260
Adam | Ellen | 2000
Adam | Emma | 1470
[NAME] | Adam | 1380
[NAME] | Emily | 400
Ellen | [NAME] | 850
Ellen | Emma | 3400
Emily | Adam | 185
Emily | [NAME] | 650
Emily | Ellen | 1000
Emily | [NAME] | 360
[NAME] | Adam | 1205
[NAME] | [NAME] | 2350
[NAME] | Ellen | 220
Spreadsheet: 111796d1308085311-making-calculations-based-on-dropdown-selection-780022-making-calculations-dummydropdowns
Sheet: Policies and formulas

Policy | [NAME] | Multiplier | Plus/Minus
Nebraska Fire Plus | prem-35 | 1 | -35
Alpha Cancer Plan | prem | 1 | 0
FaceCare | prem*0.95-30 | 0.95 | -30
NoseInsurance | prem-45 | 1 | -45
EarsSafe | prem-13.5 | 1 | -13.5
Spreadsheet: 882990d1731476596-need-formula-that-automatically-adjusts-to-rows-and-columns-fransha-spreadsheet-spill-365-aligw
Sheet: Scoring Formulas

 | 2024-10-08 00:00:00 |  |  |  |  |  |  |  |  |  | 2024-10-08 00:00:00 | Line |  | Line |  | Line |  | Line |  | Line |  | Line |  | Line |  | Line |  | Line |  | Line | 2024-10-08 00:00:00 |  |  |  |  |  |  |  |  |  | sum weighted scores | Weeks Played | Weeks Played/Total Weeks | Final Score
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | copy formula across/change cell reference
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 2 |  | 2 |  | 2 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 2 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 3 |  | 3 |  | 3 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4 |  | 5 |  | 4 |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 3 |  | 3 |  | 3 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 5 |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4 |  | 5 |  | 4 |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACTUAL SCORE |  |  |  |  |  |  |  |  | L1 | L2 | L3 | [NAME] | L5 |  |  | WEIGHTED SCORE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 | 1.3 | 1.1 | 0.9 | 0.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7
Spreadsheet: 122391d1316779969-excel-2007-compile-error-when-inserting-a-formula-ext-upld
Sheet: Data

TYPE | MAKE | MODEL | SERIAL # | Fleet ID # | [NAME] | External | Total | Hours/Report | $$/HR | Annual Util |  | Make | Model | Serial Nbr | Hrs per Day | Annualized Hrs
IFERROR(INDEX('MAKE MODEL'!B:G,MATCH(D4,'MAKE [NAME]:B,0),2),"") | IFERROR(INDEX('MAKE MODEL'!B:G,MATCH(D4,'MAKE MODEL'!B:[NAME]),"") | IFERROR(INDEX('MAKE MODEL'!B:G,MATCH(D4,'MAKE MODEL'!B:B,0),5),"") | IF('RPT 5'!G6>0,('RPT 5'!G6),("")) | IFERROR(IF(INDEX('MAKE MODEL'!B:G,MATCH(D4,'MAKE [NAME]:B,0),6)=0,(""),(INDEX('MAKE MODEL'!B:G,MATCH(D4,'MAKE [NAME]:B,0),6))),"") | IF(D4="",(""),('RPT 5'!A6)) | IF(D4="",(""),('RPT 5'!B6)) | IF(D4="",(""),('RPT 5'!C6)) | IFERROR(IF(OR(INDEX(A:Q,MATCH(D4,O:O,0),16)>19.5,(INDEX(A:Q,MATCH(D4,O:O,0),16)<0.0001)),(""),(IF(INDEX(A:Q,MATCH(D4,O:O,0),16)="",(""),(INDEX(A:Q,MATCH(D4,O:O,0),16)*('By Unit Type'!$C$6-'By Unit Type'!$C$5))))),"") | IFERROR(H4/I4,"") | IFERROR(IF(INDEX(A:Q,MATCH(D4,O:O,0),16)>19.5,("NA"),(INDEX(A:Q,MATCH(D4,O:O,0),17))),"NA") |  | LIBA | H18T | 350H11124518 | 1.58467741935484 | 578.407258064516
CB_ELECTRIC | DOCK | DSD-C50TT-4-5K | DSBC220246 |  | 2160 | 0 | 2160 |  |  | NA |  | DOCK | DSD-C50TT-4-5K | DSBC220246 | 20 | 522.018867924528
Other Equipment | JLG | 2632EZ | [PHONE] |  | 1620 | 0 | 1620 | 41.20754716981121 | 39.31318681318692 | 41.3207547169811 |  | CAT | NPV60 | 2HL04944 | 0.608870967741936 | 222.237903225806
INT_COMBUSTION | LIBA | H18T | 350H11124518 |  | 0 | 3704.21 | 3704.21 | 576.8225806451618 | 6.421749293963029 | 578.407258064516 |  | JLG | 2632EZ | [PHONE] | 0.113207547169811 | 41.3207547169811
Other Equipment | ZEQU | LTR | 01229LTR | LTR | 0 | 302.79 | 302.79 |  |  | NA
Spreadsheet: 136324d1326541003-unable-to-calculate-highlighted-cells-counthighlight
Sheet: Sheet3

0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 4 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 48 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 48 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 4 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 4 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 4 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 482966d1475395420-multipe-ifs-test
Sheet: Sheet1

 |  |  |  |  |  |  |  | [NAME] | Person Present
Names | Dept | designation | machine | Attendance |  |  |  |  | Manager | Operator
A | Stores | operator | A Build | Present |  |  |  | Stores
B | Stores | manager | B Build | Present |  |  |  | A Build
C | Finance | manager | A Build | Present |  |  |  | B Build
D | Purchages | operator | B Build | Absent |  |  |  | Finance
E | Stores | operator | A Build | Absent |  |  |  | A Build
F | Security | operator | B Build | Present |  |  |  | B Build
G | Billing | manager | A Build | Present |  |  |  | Purchase
H | Security | manager | B Build | Present |  |  |  | A Build
I | Billing | operator | B Build | Absent |  |  |  | B Build
 |  |  |  |  |  |  |  | Security
 |  |  |  |  |  |  |  | A Build
 |  |  |  |  |  |  |  | B Build
 |  |  |  |  |  |  |  | Billing
 |  |  |  |  |  |  |  | A Build
 |  |  |  |  |  |  |  | B Build
 |  |  |  |  |  |  |  | Count the peoples present in following crieteria
Spreadsheet: 155218d1336727118-combining-two-functions-weekly-backlog-report-20120424-test-1-
Sheet: Raw Data

TRACKING_ID | CREATED_DATE | SHORT_DESCRIPTION | ASSIGNED_TO | EXPECTED_RESOLUTION_DATE | ACTUAL_DATE | SEVERITY | TYPE | RESOLUTION_DATE | STATUS | SUB_STATUS | SUBTYPE | SUBQUEUE | DIFF | ACTUAL RES DATE | MONTH CREATED | TEAM | [NAME] | MONTH CLOSED | EXP_RES_DATE | Calc | Met SLA | Sev3 (-2) | PH Singapore | PH Malaysia
 | 2012-03-01 00:00:00 | [NAME] | DummyApp | 01-MAR-12 | 04-MAR-12 | Severity 1 | Helpdesk | 04-MAR-12 | Resolved | Closed | Duplicate |  |  | 2012-03-04 00:00:00
 | 2012-03-01 00:00:00 | [NAME] | DummyGov | 01-MAR-12 | 04-MAR-12 | Severity 1 | Helpdesk | 04-MAR-12 | Resolved | Closed | Duplicate |  |  | 2012-03-04 00:00:00 |  |  |  |  |  |  |  | 0
 | 2012-04-01 00:00:00 | [NAME] | DummyApp | 01-APR-12 | 04-APR-12 | Severity 1 | Helpdesk | 04-APR-12 | Resolved | Closed | Duplicate |  |  | 2012-03-04 00:00:00 |  |  |  |  |  |  |  | 0
WO# 10021 | 2012-06-01 00:00:00 | Test 1-July - Process not starting | [NAME] , Anand | 05-JUL-11 | 03-OCT-11 | Severity 3 | Helpdesk | 01-JUL-11 | Resolved | Closed | Information
WO# 12088 | 2011-06-02 00:00:00 | oracle  password locked | [NAME] , Thiruchelvam a/l | 07-JUL-11 | 02-JUL-11 | Severity 3 | [NAME] | 02-JUL-11 | Resolved | Closed | Oracle |  |  | 2011-06-02 00:00:00
WO# 12091 | 2012-06-02 00:00:00 | Your Oracle Account | Vyveganathan , [NAME] a/l | 07-JUL-11 | 02-JUL-11 | Severity 3 | [NAME] | 02-JUL-11 | Resolved | Closed | Oracle |  |  | 2012-07-07 00:00:00
WO# 12137 | 2011-06-02 00:00:00 | BB0 - URGENT for Mth-end Closing | Arumugam , [NAME] | 07-JUL-11 | 12-JUL-11 | Severity 3 | Oracle | 12-JUL-11 | Resolved | Closed | [NAME] (Costing) |  |  | 2011-06-12 00:00:00
WO# 12305 | 2011-06-03 00:00:00 | Cannot Log on via VPN nor to owa.kns.com | Ng , [NAME] | 08-JUL-11 | 03-JUL-11 | Severity 3 | [NAME] | 03-JUL-11 | Resolved | Closed | Network/Cognos/Portal/TWIKI |  |  | 2011-06-03 00:00:00
WO# 12309 | 2011-06-03 00:00:00 | HRIS report - 02 July 2011 | Ng , Yohan | 08-JUL-11 | 12-JUL-11 | Severity 3 | Helpdesk | 12-JUL-11 | Resolved | Closed | HRIS |  |  | 2011-06-12 00:00:00