tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 675380d1588262648-calculate-which-person-has-2-or-more-x-in-a-row-2-or-more-x-in-row-tora-v1-
Sheet: Blad1

 | 2020-04-02 00:00:00 | 2020-04-09 00:00:00 | 2020-04-16 00:00:00 | 2020-04-23 00:00:00 | 2020-04-30 00:00:00 | 2020-05-07 00:00:00 | 2020-05-14 00:00:00 | 2020-05-21 00:00:00 |  |  |  | People with 2 X's in a row | People with 3 X's in a row | People with 4 X's in a row
[NAME] | √ | X | X | X | X |  |  |  | X
[NAME] | √ | √ | X | X | √ |  |  |  | X
Mark | √ | X | X | X | X |  |  |  | X
Nathalie | √ | √ | X | X | X |  |  |  | X
Spreadsheet: 1cb1ac1f-c02d-471f-adba-ad820de55408
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
AASCA | Test | AASCA | Saccharomyces cerevisiae Antibody, IgA, Serum | Saccharomyces cerevisiae Ab, IgA, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | Negative: 0.0-20.0 U Equivocal: 20.1-24.9 U Weakly positive: 25.0-34.9 U Positive: > or =35.0 U | Monday through Friday; 5 p.m. | Same day/1 day |  | 1 | 83520 |  |  |  |  | Rochester
AASCA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
AASCA | Result | AASCA | Saccharomyces cerevisiae Ab, IgA, S | Saccharomyces cerevisiae Ab, IgA, S | Numeric |  |  |  |  | U |  |  |  |  |  |  |  |  |  | 47320-7
Spreadsheet: richard_ring__31554__EEMC-CECAuditedAnnual-2000
Sheet: Schedule 2A

 | Annual Report to the California Energy Commission
 | for the year ending December 31, 2000
 | SCHEDULE 2A:  RETAIL SALES
 | Applicable to:  Retail Providers (Power Source Disclosure Program) and Registered Renewable Providers (Customer Credit Program)
 |  | Product 1 | Clean ChoiceTM 20
 |  | Product 2 | Clean ChoiceTM 50
 |  | Product 3 | Clean ChoiceTM 100
 |  | Product 4 | Clean Choice BIZMIXSM
 |  | Product 5 | -
 |  | Product 6 | -
 |  | kWh [NAME] 1 | kWh [NAME] 2 | kWh [NAME] 3 | kWh [NAME] 4 | kWh [NAME] 5 | kWh [NAME] 6 | [NAME]
 | Specific Purchases
 | Renewable
 | Biomass & Waste | 2859866 | 1254015 | 2873629 | 61364190
 | Geothermal | 953289 | 456006 | 1149451 | 63458274
 | Small hydroelectric | 953288 | 456006 | 1149451 | 19154535
 | Solar electric | 0 | 0 | 0 | 0
 | Wind | 0 | 114001 | 574726 | 8097273
 | Coal
 | Large hydroelectric
 | Natural Gas
 | Nuclear
 | Other
 | Total Specific Purchase Power Sold
 | Generic Power Sold | 0 | 0 | 0 | 4326796699 | 0 | 0
 | Total Retail Sales
 |  |  |  |  |  |  | CEC Reg. #
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: Margal

Raw Material |  | Margal
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 103.464
2023-10-02 00:00:00 |  |  |  |  | 4
2023-10-03 00:00:00 |  |  |  |  | 4
2023-10-04 00:00:00 |  | 2 | 40 |  | 4
2023-11-03 00:00:00
2023-11-21 00:00:00 |  |  |  |  | 1.44
2023-11-22 00:00:00 |  |  |  |  | 2.16
2023-11-23 00:00:00 |  |  |  |  | 2.16
2023-11-23 00:00:00 |  |  |  |  | 2.12
2023-11-24 00:00:00 |  |  |  |  | 2.12
2023-11-24 00:00:00 |  |  |  |  | 2.12
2023-11-24 00:00:00 |  |  |  |  | 1.44
2023-11-25 00:00:00 |  |  |  |  | 2.12
2023-11-25 00:00:00 |  |  |  |  | 2.12
2024-01-08 00:00:00 |  |  |  |  | 2.16
2024-01-09 00:00:00 |  |  |  |  | 1.44
2024-01-27 00:00:00 |  |  |  |  | 2.16
2024-01-28 00:00:00 |  |  |  |  | 2.16
2024-01-29 00:00:00 |  |  |  |  | 2.16
2024-01-30 00:00:00 |  |  |  |  | 2.16
2024-02-20 00:00:00 | SRN # 7658 |  |  |  | 2.16
2024-02-28 00:00:00 | SRN # 7659 |  |  |  | 2.16
Total
Spreadsheet: jeffrey_a_shankman__13934__MgmtSum-Q401-Global-111601
Sheet: YTD

Enron Global Markets
**PRELIMINARY** December Year-to-Date |  |  |  |  |  |  |  |  |  |  |  | PRIVATE & CONFIDENTIAL
 |  | Margin |  |  |  | Expenses (1) |  |  |  | EBIT
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan | [NAME] |  | Forecast | Plan | [NAME]
Crude & Products
Coal / Emissions
Vessel Trading
Emissions
Weather
Global Risk Markets
Financial Trading
Freight
LNG
Middle East (1Q)
Puerto Rico (1Q & 2Q)
Japan
Drift
Finance and Structuring
Office of the Chairman
Overview
Total Commercial
Credit Reserve
Financing Related
Group Cost
Support Cost Allocated to Teams
Other Interest Related Charges
Capital Charge Offset
Global Markets EBIT
Interest Expense/(Income)
Global Markets Pre-tax Income
(1) Includes direct and allocated expenses
 |  | Margin change from: 10/26/00 |  |  |  | Expense changes from: 10/26/00
 |  | DPR Change |  |  |  | Operating Expense
 |  | MPR Change |  |  |  | Commercial Expense
 |  | Other Margin Changes |  |  |  | Other
 |  | Total Change |  |  |  | Total Change
 |  | Total Margin - QTD |  |  |  | Total Expense
 |  | Prior Week: |  |  |  | Prior Week:
 |  | This Week: |  |  |  | This Week:
 |  | Change: |  |  |  | Change:
Spreadsheet: fb51e1bf-0c26-4942-bf32-d3154c9b2caf
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FAVCG | Test | FAVCG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | < 2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:  Viracor-IBT Laboratories                               1001 NW Technology Dr.                               Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FAVCG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FAVCG | Result | FAVCG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 861388d1709255666-looking-to-count-a-number-of-cells-with-changing-rows-and-column-availabilty-monitoring-eba
Sheet: Availability Report

[NAME] for: |  |  |  | 2024-02-29 00:00:00
 | Full Practice | Modified Practice | Medically Unavailable | Rehab |  |  |  |  |  |  | CB | S | LB | LEO | DL | WR | RB | TE | QB | OL | K, LS, P
 |  |  |  |  |  |  |  |  | FP | Full Practice
 |  |  |  |  |  | Name |  |  | MP | Modified Practice
 |  |  |  |  |  |  |  |  | MU | Medically Unavailable
 |  |  |  | Athlete 28 |  | Athlete 72 |  |  | R | Rehab
 |  |  |  | Athlete 63 |  | Athlete 93
 |  |  |  | Athlete 66
 |  |  |  | Athlete 75
 |  |  |  | Athlete 77 |  |  |  |  |  |  | EXPECT RESULTS
 |  |  |  | Athlete 103 |  |  |  |  |  |  | CB | S | LB | LEO | DL | WR | RB | TE | QB | OL | K, LS, P
 |  |  |  | Athlete 104 |  |  |  |  |  | Full Practice | 9 | 8 | 8 | 5 | 16 | 12 | 6 | 7 | 5 | 12 | 5
 |  |  |  | Athlete 105 |  |  |  |  |  | Modified Practice | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1
 |  |  |  | Athlete 110 |  |  |  |  |  | Medically Unavailable | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  | Athlete 113 |  |  |  |  |  | Rehab | 0 | 1 | 1 | 0 | 0 | 4 | 0 | 0 | 0 | 7 | 0
 |  |  |  | Athlete 115
 |  |  |  | Athlete 117
Spreadsheet: 735524d1623057739-vlookup-multiple-columns-sample
Sheet: Reference

A1 | Flooring | Timber | 1 | 15 | 15
A2 | Flooring | Concrete
A3 | Flooring | Suspended
A4 | Flooring
A5 | Flooring
A6 | Flooring
A7 | Flooring
A8 | Flooring
A9 | Flooring
A10 | Wall | Plaster | 2 | 30 | 60
A11 | Wall | Brick
A12 | Wall | Render
A13 | Wall
A14 | Wall
A15 | Wall
A16 | Ceiling | Plaster | 3 | 6 | 18
A17 | Ceiling | Suspended
Spreadsheet: 81775d1281948983-prepare-excel-file-for-access-database-edi-file
Sheet: Sheet2

116 | 117 | 119 | 120 | 121 | 122 | 123 | 124 | 125 | 127 | 128 | 129 | 130 | 132 | 134 | 135 | 136 | 138 | 139 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | 151 | 153 | 155 | 156 | 157 | 158 | 159 | 170 | 171 | 172 | 173 | 175 | 176 | 177 | 178 | 179 | 180 | 181 | 184 | 186 | 187 | 188 | 189 | 243 | 244 | 245 | 246 | 247 | 248 | 250 | 251 | 252 | 253 | 254 | 255 | 256 | 257 | 259 | 260 | 262 | 263 | 264 | 266 | 267 | 269 | 270 | 271 | 272 | 274 | 276 | 278 | 279 | 280 | 281 | 282 | 283 | 284 | 285 | 287 | 288 | 289 | 366 | 367 | 368 | 370 | 371 | 372 | 375 | 376 | 378 | 379 | 381 | 383 | 385 | 386 | 387 | 388 | 389 | 391 | 392 | 394 | 397 | 399 | 441 | 443 | 444 | 447 | 448 | 450 | 451 | 452 | 453 | 454 | 455 | 456 | 550 | 551 | 552 | 553 | 554 | 555 | 556 | 557 | 558 | 562 | 563
0
Spreadsheet: 796912d1663624638-pull-information-via-data-validation-and-return-value-in-a-2nd-column-based-on-adjacency-adjacent-formula-for-invoice-tracking
Sheet: Invoice tracking

Month of event/invoice | date on invoice | vendor name & # | [NAME] | vendor # | amount
 |  |  |  | formula below that pull in corresponding vendor # without having to use formula to CONCATENATE as in F4 pulling from "reminders tab column C
August | 8.31.22 | ACE 22918 | ACE |  | 143.29
August | 8.29.22 | American 18454 | American | this should read vendor # 18454 using formula to reference adjacent cell on other tab. | 370
August | 9.1.22 | ASDER 14400 | ASDER |  | 7100
Sept | 9.7.22 | Adobe 5564 | Adobe |  | 527.5
Sept | 9.6.22 | American 18454 | American |  | 2550
July | 7.12.22 | ASSOCIATES, INC. 22898 | ASSOCIATES, INC. |  | 32.1
June | 6.30.22 | Arcon 27759 | Arcon |  | 8.7
June | 8.3.22 | ACE 22918 | ACE |  | 8.7
Spreadsheet: hunter_shively__12724__Fundamentals_Netco
Sheet: Weather

 | Weather
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | 24109311.02937501
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 1
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 3
 |  |  |  |  |  |  |  | Director | 143000
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  |  | MD | 220000
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2 |  |  |  |  | 1
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 48921d1248205917-looking-up-a-secondary-array-book1
Sheet: Sheet1

To change the values of columns B and C on row 3, change the number in A3
Number | Material | Standard Stock Sizes |  |  |  |  | Type Number | Type Text
6 |  |  |  |  |  |  | 1 | number
1 | 2014 |  |  |  |  |  | 2 | text
 | 2219 |  |  |  |  |  | 4 | logical value
 | 2618 |  |  |  |  |  | 16 | error value
 | 6061 |  |  |  |  |  | 64 | array
 | 6-2-4-2 Ti
 | 6-2-4-6 Ti
 | 6Al-4V Ti
 | 7050
 | 7075
 | 7175
 | A286
 | C263
 | GTD222
 | Hast S
 | Hast X
 | Haynes 188
 | Inco 600
 | Inco 625
 | Inco 718
 | Inco 722
 | Inco 783
 | Inco 901
 | Inco 903
 | Inco 907
 | Inco 909
 | Inco X 750
 | L605
 | [NAME]
 | Thermospan
 | Waspaloy
Spreadsheet: 806084d1669100131-copy-from-sheet-to-sheet-based-on-rows-and-columns-excel-help-example-ans-2
Sheet: October 2021

 | Location 1 | Location 2 | Location 3 | Location 4 | Location 5 | Location 6 | Location 7 | Location 8 | Location 10
October 2021 Sales | 11111 | 22222 | 33333 | 44444 | 55555 | 66666 | 77777 | 88888 | 111110
October 2020 Sales
% Change | % | % | % | % | % | % | % | % | %
October 2019 Sales | 111 | 222 | 333 | 444 | 555 | 666 | 777 | 888 | 1110
% Change from 2021 | % | % | % | % | % | % | % | % | %
Spreadsheet: 13e503a2-f015-4359-99d9-85b4c26e75af
Sheet: Data from NR

 | Higher Level Mathematics Entries as Proportion of Total Entries | Number of Higher Level Mathematics Entries | Higher Level Mathematics Entries as Proportion of English Entries | Total Entries
1960
1961
1962 | 13.2 |  | 13.2
1963 | 13.1 |  | 13.24609665427509
1964 | 12.7 |  | 12.84163568773234
1965 | 12.1 |  | 12.5618320610687
1966 | 11.8 |  | 12.11169811320755
1967 | 11.6 |  | 11.95151515151515 | 25982
1968 | 11 |  | 11.37642585551331 | 28505.74712643679
1969 | 11 |  | 11.5968992248062 | 31059
1970 | 11.5 |  | 12.41269841269841 | 33731
1971 | 11.4 |  | 12.45301204819277 | 38381
1972 | 12 |  | 13.26829268292683 | 38381
1973 | 11.7 |  | 12.98938775510204 | 52670
1974 | 11.9 |  | 13.15772357723577 | 52606
1975 | 12.2 |  | 13.71239669421488 | 51529
1976 | 12.1 |  | 13.27096774193548 | 53287.19723183391
1977 | 12.6 |  | 14.04590163934426 | 53201
1978 | 13.6 |  | 15.54285714285714 | 50398
1979 | 14.1 |  | 15.98 | 51132
1980 | 14.4 |  | 16.52658227848101 | 53024.05498281787
1981 | 14.3 |  | 16.69356223175966 | 56833
1982 | 14 |  | 16.41379310344827 | 60915
1983 | 14 |  | 16.34334763948497 | 63578
1984 | 14.1 |  | 16.6025974025974 | 61996
1985 | 14 |  | 16.55652173913044 | 61200
1986 | 14.1 |  | 16.25084745762712 | 61176.47058823529
1987 | 13.2 |  | 15.08571428571428 | 61672.8624535316
1988 | 13 |  | 14.98305084745762 | 63489
1989 | 12.9 |  | 15.32227074235808 | 63411
1990 | 12.8 |  | 15.20349344978166 | 59873
1991 | 12.2 |  | 14.61850220264317 | 59540
1992 | 12.1 |  | 14.89230769230769 | 60536.39846743295
1993 | 12.3 |  | 15.34678899082569 | 61455
1994 | 12.29473500740759 |  | 15.67585422076975 | 60825
1995 | 12.58567945711757 |  | 16.23108231482845 | 60167
1996 | 12.37090242317897 |  | 16.09128654800964 | 60915
1997 | 12.2349073520621 |  | 15.9123381634227 | 61962.96296296296
1998 | 12.3449328449328 |  | 16.10103044496486 | 60666.66666666666
1999 | 12.5 |  | 16.26794258373206 | 59592.59259259259
2000 | 12.73742468910313 |  | 17.37422468111265 | 52004
2001 | 12.90028185802799 |  | 19.52292918825561 | 55801
2002 | 12.06677885905222 |  | 18.32220293406855 | 58427
2003 | 11.960931180154 |  | 18.33510738889639 | 59298
2004 | 11.71312094217122 |  | 18.27024555813389 | 58755
2005 | 11.7 |  | 18.18486644814841
2006 | 11.70521684475173 |  | 18.40912923390027 | 57016
2007 | 11.66480446927374 |  | 18.39634335072881 | 57745
2008 | 12.07871216175485 |  | 19.6316694846725 | 57745
2009 | 11.71056163688967 |  | 18.80880622776428 | 57745
Spreadsheet: 215509d1361394950-lookup-help-using-indirect-problem-example
Sheet: Paste

 |  | 2013-01-12 00:00:00 | 2013-01-19 00:00:00 | 2013-01-26 00:00:00 | [NAME]
Routes:
Milwaukee |  | 7.2 | 7.4 | 7
Green Bay |  | 5.8 | 6 | 5.4
[NAME] |  | 8 | 7.6 | 7.8
Spreadsheet: craig_dean__4356__11-9act
Sheet: EPEData

 | 37299.95416666667
 | NEWMAN 1 ,MANL, 31  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 35  , 77  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 34  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,MANL, 46  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,UNAV,  0  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 148 ,  352,  174, 376 ,  40 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,UNAV,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,MANL, 27  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,MANL, 55  ,121  , 55  ,151  ,  0  ,1
 | RIOGRANDE,,  82 ,  159,   87, 200 ,   0 ,
 | PALOVERDE,MANL,514  ,514  ,514  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 97  , 97  , 97  ,104  ,  0  ,1
 | LAMBDA,  5.28,  656,  655,  210,    8,    0,14186,60
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 840063d1692379159-nested-if-and-offset-and-cell-sample-v2
Sheet: Sheet1

 |  | year | 2001
 |  | no of items | 1
 |  | %age | 0.1
 | Intended result | Total
reduction start year | 2006
No supply from year | 2009
 | My formula result
Spreadsheet: 846138d1697450698-listng-team-wise-names-from-a-list-listing-names-in-teams
Sheet: Sheet1

Sno | Name | Department | Designation | Category | Team |  |  | Required Result
1 | Naveena | Administration | Accountant | A | IPL-D
2 | Nandini | Housekeeping | Supervisor - Housekeeping | B | IPL-C |  |  | IPL-A | IPL-B | IPL-C | IPL-D
3 | Satish | Operations | Supervisor - Operations | D | IPL-B |  |  | Sunil | Satish | Nandini | Naveena
4 | Sunil | Inpark Sales | Assistant Manager - Revenue Operations | D | IPL-A |  |  | Ravikiran | Madhu | Basavaraj | Manjunath
5 | Basavaraj | Inpark Sales | Executive - Inpark Sales | E | IPL-C |  |  | Raju | Girish | Devaraju | Meghana
6 | Manjunath | Maintenance | Manager - Maintenance | F | IPL-D |  |  | Veena | Srikanth | Venkatesh | Venkatesh
7 | Devaraju | Maintenance | Assistant Manager - Maintenance | G | IPL-C
8 | Girish | Maintenance | Assistant Manager - Stores | G | IPL-B
9 | Madhu | Maintenance | Executive - Maintenance | G | IPL-B
10 | Raju | Maintenance | Executive - Maintenance | G | IPL-A |  |  |  | IPL-B | IPL-C | IPL-D
11 | Ravikiran | Maintenance | Assistant Manager -Maintenance | G | IPL-A |  |  | Sunil | Satish | Nandini | Naveena
12 | Meghana | Marketing | Digital Marketing Specialist | H | IPL-D |  |  | Raju | Girish | Basavaraj | Manjunath
13 | Veena | Operations | Assistant Manager-Snow Park Operations | I | IPL-A |  |  | Ravikiran | Madhu | Devaraju | Meghana
14 | [NAME] (FnB) | Restaurant | Assistant [NAME] | J | IPL-B |  |  | Veena | [NAME] (FnB) | Venkatesh H P | Venkatesh B
15 | Venkatesh H P | Restaurant | Executive - F & B | J | IPL-C
16 | Venkatesh B | Sales | Area Sales Manager (Off: [PHONE]) | K | IPL-D
Spreadsheet: tracy_geaccone__40514__EGS Q3-2001 Accounting Request
Sheet: Asia

Details of NBV for Asia
 |  |  |  |  | EPPC Invmt
 |  |  | CHGDU4 | 449 | In Uncon Subs | SEGUAM4 | KOREA4 |  | Advance
Details/Project |  | Asia | Chengdu | Batangas | Subic | Guam | SK-Enron | [NAME] | Agro Bond | [NAME]
Equity |  |  | 65800564 | 44095744 | 20465729 | 22816920 | 268318726
CTA |  |  | -35436 | 0 | 0 | 0 | 26813000 | 0 | 0 | 0
OCI |  |  | 0 | 0 | 0 | 3100500 | 0
Net I/C (Rec)/Pay |  |  |  |  | 0 |  | 0 | 0 | 0 | 0
Net NBV - Asia
Excess Costs |  |  | 0 | 7753000 | 9193000 | 991000 | 2488000 | 0 | 0 | 0
Loans to JV |  |  | 0 | 0 | 4261000 | 0 | 0 | 0 | 0 | 0
Mobilized/Trapped Cash |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
May NBV |  |  | 63241000 | 50733000 | 29996000 | 19464000 | 296618000 | 18022000 | 3178000 | 3046000
Spreadsheet: 701853d1603970203-filter-the-data-by-the-given-date-from-a-table-tasks
Sheet: Result

 |  |  | name | time | Course | Exam room | class |  |  | name | time | Course | Exam room | class |  | name | time | Course | Exam room | class
21 Ekim 2020 Çarşamba | CHOOSE A DATE | 21 Ekim 2020 Çarşamba | ? | ? | ? | ? | ? |  |  | Name1 | 13:30:00 | Course-1 | 9A | 9A |  | Name4 | 13:30:00 | Course-4 | 9A | 9A
22 Ekim 2020 Perşembe |  |  |  |  |  |  |  |  |  | Name7 | 12:00:00 | Course-1 | 10A | 10A |  | Name4 | 12:00:00 | Course-3 | 10A | 10A
23 Ekim 2020 Cuma |  |  |  |  |  |  |  |  |  | Name7 | 13:30:00 | Course-1 | 10A | 9A |  | Name7 | 12:00:00 | Course-3 | 11A | 10A
26 [NAME] 2020 Pazartesi |  |  |  |  |  |  |  |  |  | Name14 | 12:00:00 | Course-1 | 11A | 10A |  | Name7 | 13:30:00 | Course-4 | 10A | 9A
27 Ekim 2020 Salı
28 Ekim 2020 Çarşamba
30 Ekim 2020 Cuma
2 Kasım 2020 Pazartesi
3 Kasım 2020 Salı
4 Kasım 2020 Çarşamba
5 Kasım 2020 Perşembe
6 Kasım 2020 Cuma
9 Kasım 2020 Pazartesi
Spreadsheet: 716245d1612118913-creating-a-condensed-list-using-formulas-forumans
Sheet: Result

Sl.No | Farmer | Survey | Crop Sublist | Extent
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-09-P-0120

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-09-P-0120 |  |  | 1P
W912LP-09-P-0120 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 773232d1647716846-vlookup-and-if-functions-example
Sheet: By Task Order

ID | Task Order | Employee Name | 2022-01-15 00:00:00 | 2022-01-31 00:00:00 | 2022-02-14 00:00:00 | 2022-02-28 00:00:00 | 2022-03-15 00:00:00 | 2022-03-31 00:00:00 | 2022-04-15 00:00:00
1001 | 01 AA.AD | [NAME], [NAME] | 0 | 0 | 0 | 5 | 0 | 0 | 5
2403 | 01 AA.AD | Doe, [NAME] | 0 | 0 | 0 | 0 | 0 | 9 | 0
2050 | 01 AA.AD | Fisher, Mary | 0 | 0 | 0 | 0 | 0 | 0 | 0
1920 | 01 AA.AD | [NAME], [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
TO01
1001 | 02 AC.AD | [NAME], [NAME] | 0 | 5 | 5 | 5 | 5 | 5 | 5
2403 | 02 AC.AD | Doe, [NAME] | 0 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  | 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 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
TO02
2050 | 03 AB.AD | Fisher, Mary | 0 | 8 | 8 | 8 | 8 | 8 | 8
1920 | 03 AB.AD | [NAME], [NAME] | 0 | 15 | 10 | 4 | 3 | 21 | 5
 |  |  | 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 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0