tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 675257d1588222007-problem-using-index-match-with-merged-cells-sample-report
Sheet: Sheet2

YTD March 2020 Actual to Budget Comparison
 | Product 1 |  |  |  |  |  | Product 2
 | Actual | Budget | % of Rev. Act. | % of Rev. [NAME] | $ [NAME]. | % Diff. | Actual | Budget | % of Rev. Act. | % of Rev. [NAME] | $ [NAME]. | % Diff.
Total Revenue
Total Expenses
***I WANT THE NUMBERS TO TOTAL SO IT SHOULD LOOK LIKE THIS:
 | Product 1 |  |  |  |  |  | Product 2
 | Actual | Budget | % of Rev. Act. | % of Rev. [NAME] | $ [NAME]. | % Diff. | Actual | Budget | % of Rev. Act. | % of Rev. [NAME] | $ [NAME]. | % Diff.
Total Revenue
Total Expenses
Spreadsheet: rick_buy__32699__0608 summary of issues
Sheet: Graphing Data

SUMMARY BY WEEK FOR  05/10 - 05/17 |  |  | SUMMARY BY WEEK FOR  05/02 - 05/09 |  |  | BOOKS PER GROUP | 2001-05-17 00:00:00 | 2001-05-30 00:00:00
Deal Capture |  |  | Deal Capture |  |  | EIM | 30 | 33
Deal Valuation |  |  | Deal Valuation |  |  | EGM | 530 | 540
Breakdown in Officializing Process- Human | 7 |  | Breakdown in Officializing Process- Human | 13 |  | EEL | 13 | 13
Breakdown in Officializing Process- IT | 5 |  | Breakdown in Officializing Process- IT | 6 |  | EA-CAN | 36 | 36
Curve Issues |  |  | Curve Issues |  |  | EA - GAS | 285 | 288
Uncontrollable-System Needs to Change | 1 |  | Uncontrollable-System Needs to Change | 2 |  | EA - POWER | 126 | 132
Miscellaneous |  |  | Miscellaneous | 1 |  | EES | 9 | 9
Not identified |  |  | Not identified |  |  | EBS | 10 | 10
SUMMARY FOR  05/10 - 05/17 BY GROUP |  |  | SUMMARY FOR  05/02 - 05/09 BY GROUP
EIM | 1 |  | EIM | 1
EGM | 3 |  | EGM | 2
EEL | 5 |  | EEL | 8
EA-CAN | 1 |  | EA-CAN | 2
EA - GAS | 1 |  | EA - GAS | 6
EA - POWER | 2 |  | EA - POWER | 3
EES |  |  | EES
EBS |  |  | EBS
SUMMARY BY WEEK FOR  05/18 - 05/25 |  |  | SUMMARY FOR  05/18 - 05/25 BY GROUP
Deal Capture |  |  | EIM
Deal Valuation |  |  | EGM
Breakdown in Officializing Process- Human |  |  | EEL
Breakdown in Officializing Process- IT |  |  | EA-CAN
Curve Issues |  |  | EA - GAS
Uncontrollable-System Needs to Change |  |  | EA - POWER
Miscellaneous |  |  | EES
Not identified |  |  | EBS
 |  |  | SUMMARY FOR  05/18 - 05/24 BY GROUP
Deal Capture |  |  | EIM
Deal Valuation |  |  | EGM | 1
Breakdown in Officializing Process- Human | 2 |  | EEL | 8
Breakdown in Officializing Process- IT | 7 |  | EA-CAN
Curve Issues | 1 |  | EA - GAS
Uncontrollable-System Needs to Change |  |  | EA - POWER | 2
Miscellaneous | 1 |  | EES
Not identified |  |  | EBS
Spreadsheet: 86785d1286760429-how-to-filter-and-sort-student-data-helpkids
Sheet: Sheet1

Hide Rows |  | [NAME] Grade Baseline |  |  |  |  |  |  |  |  | Hide Rows
 |  | First Name: | Last Name: | 1a: count to 120 (4) | 1b: count by 10s (2) | 2: count backwards (2) | 3: less than and more than (4) | 4: read aloud numbers to 31 (2) | 5: count 20 cubes (2) | 6: compose and decompose to ten (4) |  |  |  | First Name | Last Name | 1a: count to 120 (4) | 1b: count by 10s (2) | 2: count backwards (2) | 3: less than and more than (4) | 4: read aloud numbers to 31 (2) | 5: count 20 cubes (2) | 6: compose and decompose to ten (4)
 | 1 | Alley |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 1
 | 2 | Angelina |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 2
 | 3 | Apple |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 3
 | 4 | Ava |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 4
 | 5 | Bradey |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 5
 | 6 | Brenden |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 6
 | 7 | Chase |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 7
 | 8 | Colby |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 8
 | 9 | Cole |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 9
 | 10 | Domonic |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 10
 | 11 | Easton |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 11
 | 12 | [NAME] |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 12
 | 13 | Gabby |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 13
 | 14 | [NAME] |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 14
 | 15 | [NAME] |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 15
 | 16 | Kayla |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 16
 | 17 | [NAME] |  | 4 | 2 | 2 | 0 | 2 | 2 | 3 | 17
 | 18 | Lauralye |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 18
 | 19 | [NAME] |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 19
 | 20 | Makenzie |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 20
 | 21 | [NAME] |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 21
 | 22 | Samantha |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 22
 | 23 | Travis |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 23
 | 24 | Trevor |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 24
 | 25 | Trilby |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 25
 | 26 | [NAME] |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 26
 | 27 | [NAME] |  | 3 | 1 | 2 | 3 | 2 | 2 | 3 | 27
 | 28 | Ally |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 28
 | 29 | [NAME] |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 29
 | 30 | [NAME] |  | 4 | 2 | 2 | 3 | 2 | 0 | 3 | 30
 | 31 | [NAME] |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 31
 | 32 | Dane |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 32
 | 33 | [NAME] |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 33
 | 34 | Delcy |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 34
 | 35 | [NAME] |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 35
 | 36 | Logan |  | 4 | 1 | 2 | 3 | 2 | 2 | 3 | 36
 | 37 | Trevor |  | 4 | 2 | 2 | 3 | 2 | 2 | 3 | 37
 | 38 | Willy |  | 4 | 2 | 2 | 3 | 2 | 2 | 1 | 38
Spreadsheet: 112870d1308843625-need-help-with-the-formula-new-microsoft-excel-worksheet-2-
Sheet: Sheet1

DATE | Count | Version
2010-11-12 00:00:00 | 175 | 1
2010-11-19 00:00:00 | 350 | 1
2010-11-12 00:00:00 | 175 | 2 |  |  |  |  | Current Format
2010-11-19 00:00:00 | 350 | 2
2010-11-26 00:00:00 | 500 | 2
2010-11-12 00:00:00 | 175 | 3
2010-11-19 00:00:00 | 350 | 3
Spreadsheet: 267716d1380147630-help-sorting-two-tiered-and-if-forumula-use-rank-laps-and-time
Sheet: Sheet1 (2)

F Name | Surname | Other info 1 | Other info 2 | No. | Laps | Time In | helper | Position | DNF?
A | Bloggs |  |  | 1 | 2 | 13:31:30
B | Bloggs |  |  | 2 | 3 | 14:31:30
C | Bloggs |  |  | 3 | 4 | 13:44:32
d | Bloggs |  |  | 4 | 5 | 13:30:25
e | Bloggs |  |  | 5 | 2 | 13:31:20
f | Bloggs |  |  | 6 | 3 | 13:41:54
g | Bloggs |  |  | 7 | 4 | 13:43:32
h | Bloggs |  |  | 8 | 5 | 13:31:30
i | Bloggs |  |  | 9 | 6 | 13:51:23
j | Bloggs |  |  | 10 | 7 | 13:56:23
k | Bloggs |  |  | 11 | 8 | 13:32:17
l | Bloggs |  |  | 12 | 1 | 12:32:14
m | Bloggs |  |  | 13 | 2 | 13:20:45
n | Bloggs |  |  | 14 | 3 | 13:35:45
o | Bloggs |  |  | 15 | 4 | 13:45:32
p | Bloggs |  |  | 16 | 5 | 14:01:34
q | Bloggs |  |  | 17 | 4 | 13:56:45
r | Bloggs |  |  | 18 | 3 | 13:24:54
s | Bloggs |  |  | 19 | 2 | 11:12:32
t | Bloggs |  |  | 20 | 6 | 13:43:56
u | Bloggs |  |  | 21 | 5 | 13:30:11
v | Bloggs |  |  | 22 | 4 | 1900-01-02 15:08:00
w | Bloggs |  |  | 23 | 3 | 13:43:56
x | Bloggs |  |  | 24 | 3 | 13:43:58
y | Bloggs |  |  | 25 | 4 | 13:42:45
z | Bloggs |  |  | 26 | 4 | 13:42:46
EVENT FINISH TIME | 13:30:00
 |  |  |  |  |  |  |  | ^^^^^
 |  |  |  |  |  |  |  | Enter a position
 |  |  |  |  |  |  |  | Ie. 1, 2, 3. for 1st,
 |  |  |  |  |  | Primary |  | 2nd, 3rd.
 |  |  |  |  |  | Sort |  | Based on No of
 |  |  |  |  |  |  |  | laps.
 |  |  |  |  |  | Secondary |  | If Tied on laps.
 |  |  |  |  |  | Sort |  | Lowest time wins
Spreadsheet: 727987d1618240789-arrangement-of-different-cells-which-need-to-be-filtered-out-first-example-to-find-the-pattern-first
Sheet: Tabelle1

SEARCH:
Formation A | 1212 | red | mark it
Formation B | 2222 | yellow | mark it
2 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 2 | 1 | 1
2 | 1 | 1 | 2 | 2 | 2 | 2 | 1 | 1 | 2 | 1
1 | 1 | 1 | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 1
 |  | DAS SIND 3 BEISPIELE: OBEN
2 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 2 | 1 | 1 | Formation A appears before formation B, that is why we marked it Red in line 7
2 | 1 | 1 | 2 | 2 | 2 | 2 | 1 | 1 | 2 | 1 | Formation B appears before formation A, that is why we marked it [NAME] in line 8
1 | 1 | 1 | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 1 | Formation B appears before formation A, that is why we marked it [NAME] in line 9
Spreadsheet: dan_hyvl__4728__Public Service Co of New Mexico Master Phys 04022001
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: | 2001-04-02 00:00:00 | ENA CONTACT: | [NAME]
COUNTERPARTY: | Public Service Co of New Mexico | CONTACT:
ADDRESS: | Alvarado Square | TITLE:
 | Albuquerque, NM 87158 | PHONE:
 |  | FAX:
INCORPORATION STATE: | New Mexico | S&P RATING: | BBB-
STRUCTURE | COUNTERPARTY | ENA ENTITY
COLLATERAL
THRESHOLD  in $ | 5000000 | 25000000
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | N/A | Enron Corp. (BBB+)
LIMIT in $[NAME] |  | 30000000
Incorporation State: |  | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change | X | X
-Below = | BB+ | BBB- | Standard & Poor's
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net worth
-EBITDA/Interest
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty | 5000000
-Guarantor ($[NAME]) |  | 100000000
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES:    X | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES:    X | NO:
OTHER COMMENTS
CREDIT REVIEW  PREPARED BY: |  | [NAME] | Ext. 53923
Spreadsheet: darrell_schoolcraft__7583__OCC Phone List
Sheet: ON CALL LISTING

 | The Name of the Team: | Hugoton Plant |  | Effective Date: | 2002-01-02 00:00:00
 | Cost Center | 111576 |  | Expiration Date
 | ON CALL PAGERS #: | [PHONE] |  | NUMERIC OR VOICE PAGER: | Numeric
 |  |  |  | NUMERIC OR VOICE PAGER: | Numeric
 | Primary Phone Number: | [PHONE]
 | Back Door Phone Number:
 | Team Fax Phone Number: | [PHONE]
 | IF NO RESPONSE FROM TEAM PAGER WITHIN 15 MINUTES -- CALL THE FOLLOWING PERSONNEL IN ORDER
PRIORITY | NAME | PAGER # | CELLULAR # | HOME # | WORK # | EXT#
 | [NAME] | [PHONE] |  | [PHONE] | [PHONE]
 | [NAME] | [PHONE] |  | [PHONE] | [PHONE]
 | [NAME] | [PHONE] |  | [PHONE] | [PHONE]
 | [NAME] | [PHONE] |  | [PHONE] | [PHONE]
 | [NAME] | [PHONE] |  | [PHONE] | [PHONE]
 | Rocky Mason | [PHONE] |  | [PHONE] | [PHONE]
 | [NAME] | [PHONE] |  | [PHONE] | [PHONE]
 | *[NAME] | [PHONE] |  | [PHONE] | [PHONE]
 | [NAME] | [PHONE] |  | [PHONE] | [PHONE]
 | [NAME] | [PHONE] |  | [PHONE] | [PHONE]
 | On Call Person ( Hand Held ) | [PHONE] | [PHONE]
 | On Call Person ( Hand Held ) | [PHONE] | [PHONE]
 | Ford 2 WD  # 83693 (Duvall) |  | [PHONE]
 | Ford 4 x 4 # 83692 (Snyder) |  | [PHONE]
 | Dodge 2 WD  # 83914 (Adams) |  | [PHONE]
 | Dodge 2 WD  # 84537 (Mason) |  | [PHONE]
 | NOTE: IT IS THE RESPONSIBILITY OF THE TEAM TO UPDATE THIS LIST
 | DUE TO VACATIONS, PERSONNEL CHANGES,
 | OR ANY CHANGES EFFECTING THIS LIST.
 | Please list Facilities this Team is responsible for: Like compressors, and interconnects
 | FACILITY | PHONE #
1 | Hugoton Plant | [PHONE]
2
3
Spreadsheet: 857193d1706223075-overtime-if-not-at-40-pay
Sheet: REFERENCE

 | REFERENCE
 | HOURLY |  |  |  |  | TIME IN | LUNCH START | LUNCH END | TIME OUT | REGULAR HOURS | HOURS OT | TOTAL HOURS | TOTAL HOURS
 | TIME | PAY |  |  |  | 07:29:00 | 11:45:00 | 12:44:00 | 17:19:00
 |  |  |  |  |  | TIME IN | FOR 8 HOURS
 |  |  |  |  |  | 07:30:00
 |  |  |  |  |  |  |  |  | TIME IN | TIME OUT | TOTAL HOURS | TOTAL HOURS
 |  |  |  |  |  |  |  |  | 11:45:00 | 12:40:00
Spreadsheet: joe_parks__14610__POSTIONTRAX_NOV
Sheet: JAN_SWAP

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  | 38.75 | 3.1275 |  |  |  |  | ROLLOFF VAULE
 | 31 | 3.1175 |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  |  | 17500
 |  |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 784481d1655752127-cross-reference-data-from-2-tables-to-calculate-a-third-table-sample-8-
Sheet: Sheet5

DATA TABLE 1 |  |  |  |  |  |  |  |  |  |  |  | Results
 |  | End Item
 |  | W | X | Y | Z |  |  |  |  |  |  |  |  | Week
Detail PN | A |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Total | Validation
 | B |  | 5 | 1 |  |  |  |  |  |  |  | Detail PN | A |  |  |  |  |  |  |  |  |  |  | <-- | This is nice and clean but very manual. It isn't remotely realistic for the amount of data I have when you are talking rolling 52 weeks forecast, ~70 end items, and ~400 [NAME] PNs.
 | C | 3 |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  |  |  | <--
 | D |  |  | 2 |  |  |  |  |  |  |  |  | C |  |  |  |  |  |  |  |  |  |  | <--
 | E | 2 |  |  |  |  |  |  |  |  |  |  | D |  |  |  |  |  |  |  |  |  |  | <-- | This long chain of adding multiplications works. When you have ~70 end items though, the formula is [NAME]. It also is a pain to update when new End Items and/or Detail PNs are added. Plus if for some reason the 2 tables get out of order with respect to each other, the formulas might return invalid results.
 | F | 1 |  | 6 |  |  |  |  |  |  |  |  | E |  |  |  |  |  |  |  |  |  |  | <--
 | G |  | 1 |  |  |  |  |  |  |  |  |  | F |  |  |  |  |  |  |  |  |  |  | <--
 |  |  |  |  |  |  |  |  |  |  |  |  | G |  |  |  |  |  |  |  |  |  |  | <--
DATA TABLE 2
 |  | Week
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Total
End Item | W | 1 |  |  |  |  |  | 5
 | X |  |  | 5 |  |  | 1 | 5
 | Y |  |  | 6 |  |  |  | 5 | 1 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Total
 | Z |  |  |  |  | 2 | 3 | 5 |  |  |  |  | A
 |  |  |  |  |  |  |  |  |  |  |  |  | B
 | W | X | Y | Z |  |  |  |  |  |  |  |  | C
1 | 1 |  |  |  |  |  |  |  |  |  |  |  | D
2 |  |  |  |  |  |  |  |  |  |  |  |  | E
3 |  | 5 | 6 |  |  |  |  |  |  |  |  |  | F
4 |  |  |  |  |  |  |  |  |  |  |  |  | G
5 |  |  |  | 2
6 |  | 1 |  | 3
7 | 5 | 5 | 5 | 5
8 |  |  | 1
Total
Spreadsheet: 99033d1297808550-if-and-vlookup-in-12-sheets-question_2
Sheet: Mai

Product | Description | Stock | Price
Tennisschläger | rot | 20 | 85
Tennisschläger | schwarz | 15 | 85
Fussball | schwarz | 10 | 45
Fussball | weiss | 35 | 45
[NAME] | weiss | 999 | 8
Handtuch | schwarz | 10 | 11
Badetuch | gestreift | 10 | 18
Spreadsheet: 455914d1460562664-create-a-four-column-sorting-table-that-updates-based-on-calculations-response-16-xxx-u54-tracker-schema_safe
Sheet: Catalog

[NAME]
Patient Code | 4-Digit Code | Treatment Code | Gender ID | Referring Site | [NAME]
 |  |  |  |  |  |  | Current | Treatment Modality |  |  |  | Volume |  | Male |  | Female
 |  |  |  |  |  |  | Enrollment | Observe | Ablation | Topical | Surgery | High | Low | Cis | Trans | Cis | Trans | Site Totals
 |  |  |  |  |  |  | Cornell
 |  |  |  |  |  |  | Montefiore
 |  |  |  |  |  |  | Laser Surgery
 |  |  |  |  |  |  | UCSF
 |  |  |  |  |  |  | ADC Midwest
 |  |  |  |  |  |  | Category Totals
 |  |  |  |  |  |  | Currently Enrolled
 |  |  |  |  |  |  | Total | Treatment Modality |  |  |  | Volume |  | Male |  | Female
 |  |  |  |  |  |  | Completed | Observe | Ablation | Topical | Surgery | High | Low | Cis | Trans | Cis | Trans | Site Totals
 |  |  |  |  |  |  | Cornell
 |  |  |  |  |  |  | Montefiore
 |  |  |  |  |  |  | Laser Surgery
 |  |  |  |  |  |  | UCSF
 |  |  |  |  |  |  | ADC Midwest
 |  |  |  |  |  |  | Category Totals
 |  |  |  |  |  |  | Total Completed
 |  |  |  |  |  |  | Site
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Montefiore
 |  |  |  |  |  |  | Laser Surgery
 |  |  |  |  |  |  | UCSF
 |  |  |  |  |  |  | Chicago-Midwest
 |  |  |  |  |  |  | Treatment Modality
 |  |  |  |  |  |  | Ablation
 |  |  |  |  |  |  | Topical
 |  |  |  |  |  |  | Surgical
 |  |  |  |  |  |  | Observation
 |  |  |  |  |  |  | Disease Grade
 |  |  |  |  |  |  | Low ( < 50%)
 |  |  |  |  |  |  | High (<= 50%)
 |  |  |  |  |  |  | Gender Identification
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Male - Trans
 |  |  |  |  |  |  | Female - Cis
 |  |  |  |  |  |  | Female - Trans
Spreadsheet: 525459d1498740822-return-single-value-by-searching-multiple-criteria-in-multiple-column-ramesh
Sheet: STOCK

S NO | BRAND NAME | PRODUCT NAME | [NAME] | SIZE | COLOUR | PAGES | TOTAL RECEIVED QUANTITY | UNIT
1 | TNPL | A4 SHEET | GSM | 70 | NA | 500 |  | BUNDLE
2 | TNPL | A4 SHEET | GSM | 75 | NA | 500 |  | BUNDLE
3 | CAMLIN | PEN | GH | NA | YH | NA |  | NOS
4 | CLASSMATE | NOTE | SPIRAL | 12X14 | GREEN | 80 |  | NOS
5 | CASIO | CALC | MJ3 | NA | NA | NA |  | NOS
6
7
Spreadsheet: 794061d1661864938-financial-statement-ytd-12-month-rolling-average-based-on-dropdown-copy-of-kopi-av-handlingsplaner-2022-1-aligw
Sheet: Økonomi

[NAME] | KPI | [NAME] | Resultat 2021 | Mål 2022 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
[NAME]
 | Ordrereserve med DG | Ivar |  | 900 mill
 | Utestående fordringer over forfall
 | Forfalt fordringer | Ivar |  | 5 mill
Ivar kikker på denne ang. måltall og rapportering her. | Antall faktura over fastsatt behandlingstid i doc senter | Ivar |  | 7 dg
[NAME]
Spreadsheet: louise_kitchen__23876__Economics2
Sheet: Sheet1

 | Return Summary
 |  | ($[NAME])
 |  | NPV of DeAcero Capacity | 119.529 |  | PV of [NAME] cash inflows
 |  | NPV of DeAcero Energy (8750 HR) |  |  | PV of [NAME] cash inflows
 |  | NPV of Desk Energy Supply (ERCOT Undelivered)1 | -378.529 |  | PV of Desk cash outflows
 |  | NPV of delivery and supply losses hedge | -26.001 |  | PV of delivery costs and reserve
 |  | PPA value before transmission & reserves
 |  | HVDC Transmission Cost (112 MW) | -33.164 |  | "Purchased" from HVDC transmission
 |  | ERCOT Transmission Reserve1 | -17.334 |  | Transmission risk in ERCOT
 |  | PPA NPV (libor) |  |  | Net value of DeAcero contract
 |  | BPUB Credit Reserve | -1.7
 |  | DeAcero Credit Reserve | -20 |  | [NAME] credit reserve
 |  | A.  Chips Value
 |  | Transmission Outflows (HVDC Cost) | -74.6 |  | PV of tariff payments
 |  | Transmissions Inflows (after [NAME]) | 63.2 |  | PV of desk purchase
 |  | B.  Salsa Value
 |  | NPV = Chips & Salsa2 |  |  | Combined project NPV
 |  | Notes:
 |  | (1)  $43.3MM of hedges to account for physical supply, transmission, losses & ancillaires charges for BPUB.  Actual
 |  | charges my be significatly lower if source is optimized.
 |  | (2)  Deterministic NPV.  Does not account for backwardation in the ERCOT supply.  Every 500btu/Kwh reduction  in
 |  | supply heat rate results in approximately $19MM in project value (assuming $4.70/Mcf fixed gas price and
 |  | 8.3MM PV Mwh).
Spreadsheet: 757139d1638042342-income-tax-calculation-formula-income-tax-calculation-formula
Sheet: Sheet1

Income Tax Calculator (2021)
Areas | Rates | Fixed Amount | Fixed Amount For | Rate Calculation 1 | Rate Calculation 2 | Total |  |  | Income | 660000
0 | 0.15 | 0 | 0
24001 | 0.2 | 3600 | 24000 |  |  |  |  |  | Income Tax
53001 | 0.27 | 9400 | 53000
190001 | 0.35 | 30190 | 190000
650001 | 0.4 | 212190 | 650000
Spreadsheet: 797062d1663691065-adding-second-if-criteria-to-array-formula-jade-help-file
Sheet: Lookup Info

Sheets |  |  | Centre | Prog | 5731 | 5857
Results |  |  | 311 | 5731 | 961012 | 960501
Program | dbo_E_Freq1 |  | 331 | 4744 | 961024 | 960515
Students | dbo_E_Ele |  | 351 | 5857 | 961034 | 960526
 |  |  | 321 | GSTA12 | 961054 | 960534
 |  |  | 361 | GSTA11 | 961042 | 960544
 |  |  | 431 | 5858 | 961066 | 960554
 |  |  | 000 | GSTA10 | 961074 | 960683
 |  |  | 461 | 5817 | 961102 | 960562
 |  |  | 421 | 5695 | 961093 | 960572
 |  |  | 301 | 5825 | 961083 | 960584
 |  |  | 381 | 5798 | 961115 | 960596
 |  |  | 395 | 5712 | 961122 | 960605
 |  |  | 341 | 5750 | 961134 | 960613
 |  |  | 390 | 4748 | 961144 | 960623
 |  |  | 392 | 5816 | 961154 | 960644
 |  |  |  | 5725 | 961165 | 960656
 |  |  |  | 5764 | 961175 | 960666
 |  |  |  | 5530 | 961185 | 960672
 |  |  |  | 5736 | 961213 | 960635
 |  |  |  | 09 | 961222 | 960695
 |  |  |  | DES002 | 961195 | 960704
 |  |  |  | PRESEC | 961204 | 960714
 |  |  |  | PFPROF | 961238 | 960722
 |  |  |  | DES001 |  | 960733
 |  |  |  | PREALA |  | 960746
 |  |  |  | ALPHA0
 |  |  |  | FRALLO
 |  |  |  | 5581
 |  |  |  | 5692
 |  |  |  | 498099
 |  |  |  | 5783
 |  |  |  | 5771
 |  |  |  | 4993
 |  |  |  | 5545
 |  |  |  | 1960
 |  |  |  | 5638
 |  |  |  | 4991
 |  |  |  | 5729
 |  |  |  | 5637
 |  |  |  | 5587
 |  |  |  | 499199
 |  |  |  | 499399
 |  |  |  | 5556
 |  |  |  | 1987
Spreadsheet: 34467d1231772254-how-can-i-check-a-4-column-range-for-a-particular-number-copy
Sheet: Data Entry

repeat |  | Program | New Dept/Division |  |  | Info from the DPE - just copy and paste special - value to fill in form
optional |  | Code | Dept | Division | % to transfer | Dept | Division | Sub | ET Mo | Page Line | Employee  Name | Employee  ID | Title | End Date | DOS | Time | Rate Type | Pay Rate | A J | Gross Earnings | Total Benefits | calculation | Amount to be moved | Benefit to be moved | Rounding
 | 1 |  |  |  |  | 444941 | 99999 | '0 | '0901 | 2075301 | Doright, [NAME] | 0Z12345678 | 3257 | 2008-07-31 00:00:00 | REG | 0.5 | % | 0 | 0 | 0 | 0
1 | 2 |  |  |  |  | 444941 | 99999 | '0 | '0901 | 2075301 | Doright, [NAME] | 0Z12345678 | 3257 | 2008-07-31 00:00:00 | REG | 0.5 | % | 0 | 0 | 0 | 0
 | 3 |  |  |  |  | 444941 | 99999 | '0 | '0902 | 2158201 | Doright, [NAME] | 0Z12345678 | 3257 | 2008-08-31 00:00:00 | REG | 0.5 | % | 0 | 0 | 0 | 0
 | 4 |  |  |  |  | 444941 | 99999 | '0 | '0904 | 2181701 | Doright, [NAME] | 0Z12345678 | 3257 | 2008-10-31 00:00:00 | REG | 0.5 | % | 0 | 0 | 0 | 0
 | 5 |  |  |  |  | 444941 | 99999 | '0 | '0903 | 2148701 | Doright, [NAME] | 0Z12345678 | 3257 | 2008-09-30 00:00:00 | REG | 0.5 | % | 0 | 0 | 0 | 0
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 | 8
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 |  |  | TOTAL AMT. MOVED |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: 773196d1647686357-return-number-based-on-a-value-in-a-specific-cell-work-hours
Sheet: Attendence Dashboard

Month | Year
1 | 2022
ID No. | Employee Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If an employee  is on duty "D" on Saturday, Sunday or Holiday day, under "D" should be 0 (zero)/blank cell, if is on duty "D" on the rest of the week (except Holyday day) under "D" should be 8 in order to calculate the work hours in that month in cell B8.
1 | [NAME] | D |  | P | D | P | D | P |  | D | P | P |  | P | H |  |  | D | P |  | L | P | D |  | P | P | H | H | H |  | D | P
Hours
2 | [NAME]
3 | [NAME]
4 | [NAME]
5 | [NAME]
6 | [NAME]
7 | [NAME]
8 | [NAME]
9 | [NAME]
 |  |  |  | D= DUTY
 |  |  |  | P=PRESENT
 |  |  |  | H=HOLIDAY
 |  |  |  | L=LEAVE
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 12c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Cross-Currency TOTAL | 1709 | 1153 | 12147 | 9379 | 12469 | 8303 | 4613 | 667 | 50440