tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 798a4bdf-60ab-43e0-9b29-f92dde46b0ad
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (30 Entries):
 | 7 Biotechnology 7.2 Procedures
No. | Company | Country | City | [NAME] | Hall/Booth
1 | [NAME] | Austria | Graz | 8054 | A2.110
2 | [NAME] | Germany | Weingarten | 88250 | A3.451
3 | Biosan SIA Medical-Biological Research & Technology | Latvia | Riga | LV-1067 | A3.335
4 | BIOTAGE AB | Sweden | Uppsala | 751-03 | A1.221
5 | [NAME] und Analysentechnik GmbH | Germany | Haar | 85540 | [NAME]
6 | DSM Biologics | Netherlands | Groningen | 9744 AP | A3.467
7 | DURATEC Analysentechnik GmbH | Germany | [NAME] | 68766 | A1.111
8 | Eppendorf AG | Germany | Hamburg | 22339 | B1.301/404
9 | FluidX Germany | Germany | Wehrheim | 61273 | B1.455
10 | GE Healthcare | Germany | München | 80807 | A3.331/430
11 | Hahnemühle FineArt GmbH | Germany | Dassel | 37586 | A2.325
12 | HSG-IMIT Institut für Mikro- und Informationstechnik der Hahn-Schickard-Gesellschaft | Germany | Villingen-Schwenningen | 78052 | A3.530
13 | [NAME] | Germany | Bernried | 82347 | A3.262
14 | [NAME] | Germany | Meerbusch | 40670 | A1.440
15 | Dr. [NAME] | Germany | Berlin | 12489 | A1.526
16 | MACHEREY-NAGEL GmbH & Co. [NAME] | Germany | Düren | 52355 | A2.330
17 | Martin Christ GmbH | Germany | [NAME] | 37520 | B2.107
18 | [NAME] GmbH | Germany | [NAME] | 51429 | A3.264
19 | nexttec GmbH | Germany | Hilgertshausen-Tandern | 86567 | A3.251/350
20 | PALL Life Sciences | Germany | Dreieich | 63303 | B1.221/320
21 | Porex Technologies GmbH | Germany | Aachen | 52070 | A3.563
22 | Sartorius AG | Germany | [NAME] | 37075 | [NAME]
23 | Shimadzu Deutschland GmbH | Germany | Duisburg | 47269 | [NAME]
24 | SIGMA Laborzentrifugen GmbH | Germany | [NAME] | 37520 | B2.105
25 | SUMITOMO BAKELITE CO.,LTD | Japan | Tokyo | 140-0002 | A3.153
26 | Taigen Bioscience Corporation | Taiwan | Taipei | 11167 | A3.131A
27 | Thermo Scientific | Germany | Dreieich | 63303 | B1.101/202
28 | Tosoh Bioscience GmbH | Germany | Stuttgart | 70567 | A2.223
29 | TurboBeads GmbH | Switzerland | Zürich | 8050 | A3.568
30 | Zefa-Laborservice GmbH | Germany | [NAME] | 85630 | B1.121/220
Spreadsheet: 32461d1228645181-automatic-update-data-flow-meter
Sheet: Sheet1

DOC | GP # | Serial # | [NAME] | Status | DATE | sign
1 | L380552 | 456998 | METER FLOW METER | RETURNED TO SITES | 2008-08-26 00:00:00 | A
1 | L380557 | 456929 | METER FLOW METER | RETURNED TO SITES | 2008-04-01 00:00:00 | A
1 | L380559 | 457004 | METER FLOW METER | RETURNED TO SITES | 2008-04-01 00:00:00 | K
1 | [NAME] | 457625 | METER FLOW METER | RETURNED TO SITES | 2008-10-14 18:07:53 | A
1 | [NAME] | 456835 | METER FLOW METER | RETURNED TO SITES | 2008-04-01 00:00:00
1 | L380643 | 456944 | METER FLOW METER | RETURNED TO SITES | 2008-08-26 00:00:00 | A
1 | [NAME] | 457485 | METER FLOW METER | RETURNED TO SITES | 2008-12-03 15:30:11 | A
1 | L474519 | 457485 | METER FLOW METER | RETURNED TO SITES | 2008-12-07 10:16:05
1 | L620916 | 479446 | METER FLOW METER | RETURNED TO SITES | 2008-12-07 10:16:09
11 | L381239 | 457155 | METER FLOW METER | RETURNED TO SITES | 2008-12-07 10:16:13 | K
1 | L397681 | 457627 | METER FLOW METER | RETURNED TO SITES | 2008-04-01 00:00:00
1 | L397680 | 457622 | METER FLOW METER | RETURNED TO SITES | 2008-08-26 00:00:00 | A
1 | L397675 | 457628 | METER FLOW METER | RETURNED TO SITES | 2008-08-26 00:00:00 | K
1 | L397673 | 457624 | METER FLOW METER | RETURNED TO SITES | 2008-12-03 15:30:14 | A
1 | L380642 | 457008 | METER FLOW METER | RETURNED TO SITES | 2008-08-26 00:00:00 | K
1 | L380554 | 456777 | METER FLOW METER | RETURNED TO SITES | 2008-07-02 00:00:00
1 | [NAME] | 459019 | METER FLOW METER | RETURNED TO SITES | 2008-06-03 00:00:00
1 | L382241 | 458921 | METER FLOW METER | RETURNED TO SITES | 2008-08-26 00:00:00 | A
Spreadsheet: 827749d1683016294-average-timings-exercise-sample
Sheet: Cases

Category | Sale Date | Letter to Authority | Authority Response | Cash Received | Letter To External | Receive by External
[NAME] | 2023-03-15 00:00:00 | 2023-03-16 00:00:00 | 2023-03-18 00:00:00 | 2023-04-03 00:00:00 | 2023-03-30 00:00:00 | 2023-04-10 00:00:00
Lim | 2023-03-30 00:00:00 | 2023-03-31 00:00:00 | 2023-04-05 00:00:00 | 2023-04-19 00:00:00 | 2023-04-20 00:00:00 | 2023-04-28 00:00:00
Paf | 2023-04-10 00:00:00 | 2023-04-11 00:00:00 | 2023-04-24 00:00:00 | 2023-04-12 00:00:00 | 2023-04-25 00:00:00 | 2023-04-30 00:00:00
Lar | 2023-04-12 00:00:00 | 2023-04-12 00:00:00 | 2023-04-15 00:00:00 | 2023-04-18 00:00:00 | 2023-04-20 00:00:00 | 2023-05-01 00:00:00
Amm | 2023-02-02 00:00:00 | 2023-02-06 00:00:00 | 2023-02-23 00:00:00 | 2023-02-13 00:00:00 | 2023-03-03 00:00:00 | 2023-03-07 00:00:00
[NAME] | 2023-01-01 00:00:00 | 2023-01-03 00:00:00 | 2023-01-13 00:00:00 | 2023-01-20 00:00:00 | 2023-01-21 00:00:00 | 2023-01-29 00:00:00
Lim | 2023-01-02 00:00:00 | 2023-01-05 00:00:00 | 2023-01-08 00:00:00 | 2023-01-18 00:00:00 | 2023-01-19 00:00:00 | 2023-01-29 00:00:00
Paf | 2023-02-03 00:00:00 | 2023-02-04 00:00:00 | 2023-02-08 00:00:00 | 2023-02-11 00:00:00 | 2023-02-13 00:00:00 | 2023-02-18 00:00:00
Lar | 2023-02-04 00:00:00 | 2023-02-04 00:00:00 | 2023-02-28 00:00:00 | 2023-02-20 00:00:00 | 2023-02-21 00:00:00 | 2023-02-28 00:00:00
Amm | 2023-02-05 00:00:00 | 2023-02-05 00:00:00 | 2023-02-10 00:00:00 | 2023-02-13 00:00:00 | 2023-02-14 00:00:00 | 2023-02-21 00:00:00
 |  |  |  |  | PLEASE NOTE THAT THIS IS A SAMPLE. THE ACTUAL FILE HAS MORE THAN 250 ENTRIES.
Spreadsheet: 65467d1266186238-event-result-sheets-event-example
Sheet: Event1

 |  |  |  |  |  |  |  |  | Fianls
 |  |  | Round1 |  | Round2 |  | Prelim |  | Judge 1 |  | Judge 2 |  | Finals
Competitor | School | Code | Rank | Rating | Rank | Rating | Rank | Rating | Rank | Rating | Rank | Rating | Rank | Rating | Team Points
Name 1 | School A | A1 | 1 | 50 | 1 | 48 |  |  | 1 | 50 | 2 | 48 |  |  | 10
Name 2 | School B | B1 | 1 | 48 | 2 | 47 |  |  | 2 | 48 | 1 | 49 |  |  | 8
Name 3 | School C | C1 | 2 | 47 | 1 | 48 |  |  | 3 | 47 | 3 | 47 |  |  | 6
Name 4 | School A | A2 | 2 | 46 | 3 | 46 |  |  | 4 | 46 | 5 | 45 |  |  | 4
Name 5 | School B | B2 | 3 | 47 | 3 | 46 |  |  | 5 | 45 | 4 | 45 |  |  | 2
Name 6 | School A | A3 | 3 | 46 | 4 | 44 |  |  | 6 | 44 | 6 | 44 |  |  | 1
Name 7 | School D | D1 | 4 | 44 | 3 | 46
Name 8 | School E | E1 | 2 | 45 | 5 | 40
Name 9 | School F | F1 | 4 | 44 | 4 | 45
Name 10 | School A | A4 | 5 | 40 | 5 | 40
Points Table
High value | Low Value | Team Pts |  |  | Each speaker is awarded team points based on their performance in prelims.
4 | 0 | 0 |  |  | Team points to be awarded are based on (Column I/2) and the table to the left.
24 | 5 | 1
34 | 25 | 2 |  |  | Team Points are also awarded for the top six finishers as indicated in column P
44 | 35 | 3
50 | 45 | 4
Some notes:
After prelms (rounds 1 and 2) are done, we sort the whole list by colum H (ascending) then column I (descending)
The top six (sometimes four, five, or seven) competitors move into finals.
After finals, we sort the finalists by column N (ascending) then column O (descending)
This sheet works fine and is pretty simple.  However, I want to be able to input the team points into the team sheet.
Spreadsheet: 63837d1264702078-seperate-a-huge-data-set-into-weeks-and-average-them-book2_jan27
Sheet: Sheet3

Cell A | Cell B
1977-01-01 00:00:00 | 4.5
1977-02-01 00:00:00 | 7.6
1977-03-01 00:00:00 | 7.7
1977-04-01 00:00:00 | 9
1977-05-01 00:00:00 | 3.4
1977-06-01 00:00:00 | 12
1977-07-01 00:00:00 | 7.2
1977-08-01 00:00:00 | 4.6
1977-09-01 00:00:00 | 7.9
1977-10-01 00:00:00 | 4.5
1977-11-01 00:00:00 | 5.5
1977-12-01 00:00:00 | 6.6
Spreadsheet: 727868d1618174401-updating-an-existing-formula-to-add-new-logic-samptt1
Sheet: Sheet2

Available | CA | COM | D | REV | FOR | IP | HOLD1 | HOLD2 | HOLD1A | HOLD1B | HOLD3 | HOLD4 | HOLD1C | PA | TERM | SET | TYP | OVER | EXEC | D2B | CURRENT CALCUAATION | Expected Calculation
0 |  |  |  | 1.208333333333333 |  | 55.45833333333334 |  |  |  |  |  |  |  | 0.25 |  | Modified | Normal | Override | 0.2 | 28 |  | 29 | IN THIS EXAMPLE, G2 GT U2
3 |  |  |  | 0 |  | 16.25 |  |  |  | 205.7916666666667 |  |  |  |  |  | Modified | Normal | Override | 0.2 | 8 |  | 11.3 | IN THIS EXAMPLE, G3 GT U3
0 |  |  |  | 2.916666666666667 |  | 0.08333333333333333 |  |  | 11.20833333333333 |  |  |  |  |  |  | Modified | Set Delivery Date | Override | 0.2 |  |  | - | EXEPCTED OUTCOME
0.7916666666666666 |  |  |  | 0.04166666666666666 |  | 11 |  |  | 33 |  |  |  |  | 3.458333333333333 |  | New | Normal | Override | 0.2 | 24 |  | 15.3 | IN THIS EXAMPLE, G5 [NAME]
0.08333333333333333 |  |  |  | 25 |  | 75.75 |  |  | 3 | 5.916666666666667 |  |  |  |  |  | Modified | Set Delivery Date | 0 | 68.75 |  |  |  | EXEPCTED OUTCOME
0.2083333333333333 |  |  |  | 1.708333333333333 |  | 8.875 |  |  |  |  |  |  |  |  |  | Modified | Normal | 0 | 8.9 |  |  |  | EXEPCTED OUTCOME
Spreadsheet: michelle_lokay__26566__imbalsumm0012
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -375221
3531 | -471621 | -467642
60667 | -330163 | -381139
60749 | 346884 | -292556
61206 | -20225
61334 | -310478
62960
INDEX
2000-11-30 00:00:00 |  |  | 52631.01
2000-12-16 00:00:00
Spreadsheet: darron_c_giron__7984__Salary
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Tax Summary
Darron 1st of Month | 64000 | Salary Per Year |  |  | Darron 15th of Month |  | Salary Per Year
Gross |  | Federal Witholding Tax |  |  | Gross |  | Federal Witholding Tax
Flex Dollars |  | FICA |  |  | Flex Dollars |  | FICA
Medical Insurance |  | Medicare |  |  | Medical Insurance |  | Medicare
Dental Insurance |  | Long Term Disability |  |  | Dental Insurance |  | Long Term Disability
Life Insurance |  | Life Insurance-Children |  |  | Life Insurance |  | Life Insurance-Children
Accidental D & D |  | 401(k) |  |  | Accidental D & D |  | 401(k)
Vision |  | Body Shop |  |  | Vision |  | Body Shop
SS Gross |  | United Way |  |  | SS Gross |  | United Way
[NAME] |  |  |  |  | [NAME]
401(k) |  |  |  |  | 401(k)
Fed Gross |  | Deducts |  |  | Fed Gross |  | Deducts
 |  | Net Pay |  |  |  |  | Net Pay
 |  |  |  |  |  |  |  |  |  |  |  | Tax Summary
Kristi 1st of Month | 38300 | Salary Per Year |  |  | Kristi 15th of Month |  | Salary Per Year
Gross |  | Federal Witholding Tax |  |  | Gross |  | Federal Witholding Tax
SS Gross |  | FICA |  |  | SS Gross |  | FICA
[NAME] |  | TRS |  |  | [NAME] |  | TRS
401(k) | 0 | TRS Insurance |  |  | 401(k) | 0 | TRS Insurance
Fed Gross |  | Teachers Union | 0 |  | Fed Gross |  | Teachers Union | 0
 |  | Life Insurance | -0.88 |  |  |  | Life Insurance | -0.88
 |  | 401(k) |  |  |  |  | 401(k)
 |  | Deducts |  |  |  |  | Deducts
 |  |  |  |  |  |  |  |  |  |  |  | Tax Summary
 |  | Net Pay |  |  |  |  | Net Pay
 |  |  |  |  |  |  |  | Total Gross
 |  |  |  |  |  |  |  | Total Net
 |  |  |  |  |  |  |  | Percent
D |  | D |  |  |  |  | D
K |  | K |  |  |  |  | K
Spreadsheet: 117050d1312409958-summing-specific-non-zero-rows-in-a-table-sample
Sheet: Case Scenarios

 |  |  |  |  |  |  | Cumm. |  | Cumm | Qtrly
 |  | Randomness |  | No |  |  | Qtr | Qtr | 0
 |  | End of first operating quarter |  |  |  |  | 1 | 4Q11
 |  |  |  |  |  |  |  | 1Q12
 |  | Model Variable #1 |  |  |  |  |  | 2Q12
 |  | Success Rate (out of 10) |  | Return Low | Return High |  |  | 3Q12
 |  | Strong | 3 | 2 | 3 |  |  | 4Q12
 |  | Moderate | 3 | 1.1 | 2 |  |  | 1Q13
 |  | Poor | 1 | 0.8 | 1.1 |  |  | 2Q13
 |  | Fail | 3 | 0 |  |  |  | 3Q13
 |  |  |  |  |  |  |  | 4Q13
 |  |  |  |  |  |  |  | 1Q14
 |  | Model Variable #2 |  |  |  |  |  | 2Q14
 |  | Target Investment Commitment (US$, 000s) |  |  |  |  |  | 3Q14
 |  |  | Annual | Per Qtr |  |  |  | 4Q14
 |  | 2011 | 25000 |  |  |  |  | 1Q15
 |  |  | 30000 |  |  |  |  | 2Q15
 |  |  | 35000 |  |  |  |  | 3Q15
 |  |  | 40000 |  |  |  |  | 4Q15
 |  |  | 45000 |  |  |  |  | 1Q16
 |  | 2016 | 50000 |  |  |  |  | 2Q16
 |  |  |  |  |  |  |  | 3Q16
 |  | Model Variable #3 |  |  |  |  |  | 4Q16
 |  | Per Investment Commitment Limitations (US$, 000s) |  |  |  |  |  | 1Q17
 |  | Min | [NAME] |  |  |  |  | 2Q17
 |  | 1000 | 6000 |  |  |  |  | 3Q17
 |  |  |  |  |  |  |  | 4Q17
 |  | Model Variable #4 |  |  |  |  |  | 1Q18
 |  | Length of Case (Quarters) |  |  |  |  |  | 2Q18
 |  | Min | [NAME] |  |  |  |  | 3Q18
 |  | 6 | 12 |  |  |  |  | 4Q18
 |  |  |  |  |  |  | Potential | Actual | 1
 |  | Case | Commencement | Investment | Length ([NAME]) | Success | Payout | Payout | IRR | 4Q11 | 1Q12 | 2Q12 | 3Q12 | 4Q12 | 1Q13 | 2Q13 | 3Q13 | 4Q13 | 1Q14 | 2Q14 | 3Q14 | 4Q14 | 1Q15 | 2Q15 | 3Q15 | 4Q15 | 1Q16 | 2Q16 | 3Q16 | 4Q16 | 1Q17 | 2Q17 | 3Q17 | 4Q17 | 1Q18 | 2Q18 | 3Q18 | 4Q18
 |  | 1
 |  |  | 0.3 |  | Strong |  | Total Investments in Qtr
 |  |  | 0.4 |  | Moderate |  | Total Receipts
 |  |  | 1.4 |  | Poor |  | Net Qtrly Cash Flows
 |  |  | 0.3 |  | Fail |  | Cummulative Cash Flows
 |  |  |  |  |  |  | Committed Capital
 |  |  |  |  |  |  | Disbursed Capital
 |  |  | Investment Allocation
 |  |  | Quarters | 1
 |  |  | 4 | 0.2 | 0.2 | 0.2 | 0.4
 |  |  |  | 0.08 | 0.12 | 0.18 | 0.23 | 0.39
 |  |  |  | 0.05 | 0.1 | 0.15 | 0.15 | 0.2 | 0.35
 |  |  |  | 0.03 | 0.05 | 0.1 | 0.15 | 0.15 | 0.2 | 0.32
 |  |  |  | 0.025 | 0.055 | 0.08 | 0.09 | 0.14 | 0.14 | 0.19 | 0.28
 |  |  |  | 0.021 | 0.039 | 0.06 | 0.09 | 0.1 | 0.12 | 0.15 | 0.17 | 0.25
 |  |  |  | 0.02 | 0.04 | 0.05 | 0.06 | 0.08 | 0.1 | 0.12 | 0.14 | 0.16 | 0.23
 |  |  |  | 0.015 | 0.02 | 0.03 | 0.045 | 0.06 | 0.08 | 0.1 | 0.12 | 0.14 | 0.18 | 0.21
 |  |  |  | 0.005 | 0.015 | 0.025 | 0.035 | 0.05 | 0.065 | 0.08 | 0.105 | 0.12 | 0.15 | 0.16 | 0.19
 |  |  |  | 0.005 | 0.015 | 0.025 | 0.035 | 0.045 | 0.055 | 0.07 | 0.08 | 0.1 | 0.12 | 0.13 | 0.15 | 0.17
 |  |  |  | 0.005 | 0.015 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.085 | 0.105 | 0.11 | 0.13 | 0.13 | 0.15
Spreadsheet: 816877d1675872090-filter-formula-searching-for-variable-date-test-search
Sheet: Sheet1

Date | Fruit
2009-02-11 00:00:00 | Plum
2020-02-16 00:00:00 | Grapefruit
2021-02-08 00:00:00 | Apple
2021-02-09 00:00:00 | Pear
2021-02-09 00:00:00 | [NAME]
2021-02-10 00:00:00 | Nectarine
2021-02-11 00:00:00 | Blueberry
2021-02-12 00:00:00 | [NAME]
2021-02-13 00:00:00 | Mandarin
2021-02-14 00:00:00 | Papaya
2021-02-15 00:00:00 | Pineapple
2021-02-16 00:00:00 | [NAME]
2021-02-17 00:00:00 | Avocado
2022-02-08 00:00:00 | Watermelon
2022-02-09 00:00:00 | [NAME]
2022-02-10 00:00:00 | Grape
2022-02-11 00:00:00 | Pomegranate
2022-02-12 00:00:00 | [NAME]
2022-02-15 00:00:00 | Lime
2022-02-16 00:00:00 | Melon
2022-02-17 00:00:00 | Peach
2023-02-08 00:00:00 | Orange
2023-02-08 00:00:00 | Mango
2023-02-09 00:00:00 | Blackberry
2023-02-10 00:00:00 | Starfruit
2023-02-10 00:00:00 | Breadfruit
2023-02-11 00:00:00 | Jackfruit
2023-02-11 00:00:00 | [NAME]
2023-02-13 00:00:00 | Kiwi
2023-02-14 00:00:00 | Lemon
2023-02-15 00:00:00 | Coconut
2023-02-16 00:00:00 | [NAME]
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 56

कार्यक्रम PROGRAM |  |  | INDUCTION PROGRAM FOR INSPECTING OFFICERS | PROG CODE
 |  |  |  | IT 1905
तर्षर् समूह/JOB FAMILY |  |  | INTERNAL CONTROL, INSPECTION & RISK MANAGEMENT
उद्देश्य/OBJECTIVE |  |  | INDUCTION PROGRAM FOR INSPECTING OFFICERS
लतक्षि समूह/TARGET GROUP |  |  | INSPECTING OFFICERS (NEWLY JOINED)
अर्तध/DURATION |  |  | 3 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Risk Profile, [NAME] and Responsibilities of IO's, Role of IOs in conducting Investigation,    RBIA    –compiling    the    Man-days,    various    types    of audits/inspection  of  various  types  of  branches.  Risk  Mitigation  Steps (Remediation Plan),
 | II | Web  Based  Inspection  package  (Darpan)  –Theory  and  Darpan  Various Modules, login feature, Menus, Reports preparation, opening and closing the  [NAME]  package  etc.-SMS  (Security  Maintenance  system,  [NAME], reports, Brief on RO Package / IS Audit of branches. A Brief on the new packages introduced by the Wing
 | III | Credit related matters – General, MSME, consortium, corporate accounts including LBA accounts.
 | IV | FEX – basics from inspection angle, FEX – latest updations & developments including  FEMA  amendments/  Inspection  of  Overseas  branches/  FD/ designated branches & ECGC cover,etc.
Day 2 | I | FCR  –  Loans  products  and  their  details,  ROI-Linking  to  MCLR/RRLR, [NAME], Security linking, Ratings updation, Concept of RPA and AOD, Remittances to loan a/c. FCR – overall agricultural advances (DND Concepts).
 | II | Income  Leakage,  Income  audit,  Part  B  &  Special  Reports  –  Case  Study, Concurrent Audit matters, Staff [NAME] on IOs
 | III | Legal Aspects, Documentation, Mortgage, EMT, MODTD, CERSAI, BHOOMI, CIBIL  and Stamp Act, NPA,  Recovery, Restructuring,  Write  off,  SARFESI, DRT, CGTMSE, CGFMU and Insolvency code, etc.
 | IV | Inspection Policy, Latest guidelines related to ITIO / GTZI, Spot rectification and its related aspects, Concurrent Audit, Snap Audit, Quality Audit & Critical analysis of previous [NAME] report.
Day 3 | I | Agriculture   Advances-   Interest   subvention,   KCC/Inbuilt-OD,   Financial inclusion, Business correspondents/Ultra small branches
 | II | Balance sheet analysis/Credit appraisal from IO point of view
 | III | Mandatory Reports Verification & GL Transactions verification –IO Point of view,    Analysis    of    miscellaneous    aspects    e.g.,    Cash/Securities/ Nomination/KYC/HRMS/Deposits-IO point of view
 | IV | Ethics  &  Governance,  [NAME]  detection/EWS  detection,  frauds  modus operandi and vigilance angle- Reporting system, Forensic audit Overview.
Spreadsheet: 707420d1607261797-using-a-list-to-reduce-worksheets-midshires-master-ans
Sheet: LW

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: dd154460-b3bf-44f2-ad74-b00a17af7721
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
VANPK | Test | VANPK | Vancomycin, [NAME], Serum | Vancomycin, [NAME], S | Enzyme-Multiplied Immunoassay Technique (EMIT) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Spin down within 2 hours of draw. | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | 25.0-50.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 2 days | 1 | 80202 |  |  |  |  | Rochester
VANPK | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
VANPK | Result | 6801 | Vancomycin, [NAME], S | Vancomycin, [NAME], S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 4090-7 | Vancomycin^peak:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 26318d1218468152-creating-a-list-from-data-version-2
Sheet: Sheet2

544 | 5555 | 4444 | 3333 | #N/A | #N/A | #N/A
888 | 6666 | 5555 | 4444 | 3333 | #N/A | #N/A
934 | 4333 | 2222 | #N/A | #N/A | #N/A | #N/A
 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 47805d1246981359-help-with-when-the-end-result-is-value-food-intake-journal
Sheet: foods

FIRST LETTER | Food Item Database | Serving Size | Quantity | Calories | Fat (grams) | Fiber (grams) | My Notes
[NAME] | MISC
aa | 8th FF Soy Milk | cup | 1 | 80 | 0 | 2 | 1 Point As Per Book but calc = 1.2 points
ba | 8th lite Chocolate | cup | 1 |  |  |  | 2 Points as per book
ca | 8th lite, Chocolate | ounces | 8
da
ea
fa
ga
ha
[NAME]
ja
ka | AA
la
ma
na
oa
pa
qa
ra
sa
ta
ua
va | BA
wa | Banana - small up to 6 7/8" |  |  |  |  |  | 1 Point
xa
[NAME]
za
 | BOCA BURGER grilled veg or original (71grams) |  |  |  |  |  | 1 point
 | broccoli salad |  |  | 71 | 0.77 | 3.9
 | CA
 | choc soy | 1 | 1 | 110 | 1 | 0.75 | Vitamin World
 | Choice Fudge Brownie Bar | 1 | 1 | 140 | 4.5 | 3
 | Choice Berry Almond Crisp | 1 | 1 | 50 | 1 | 0
 | Crazy Richards | 2 T per serving | 1 | 190 | 16 | 3
 | DA
 | Dannon Lite n Fit NonFat Yogurt | 6 oz |  |  |  |  | 1 Point as per Book
 | EA
 | Edy's no sugar added ice cream - neopolitan | 62 grams | 1 | 90 | 3 | 2
 | Egg White |  |  |  |  |  | 0 points
 | FA
 | Fiber One | 1 | 1 | 60 | 1 | 14
 | FIBER ONE | 1 | 1 | 60 | 1 | 14
 | GA
 | [NAME] | 1 | 1 | 120 | 0 | 0
 | HA
 | IA
 | JA
 | KA
 | LA
 | [NAME] | 1 | 1 | 81 | 2 | 6
 | Large La Tortilla | 1 | 1 | 80 | 3 | 14
 | MA
 | NA
 | [NAME] | 1 | 1 | 35 | 1 | 1 | Sugar Free Mix
 | OA
 | PA
 | Peach | up to 2.5" diam. | 1 |  |  |  | 0 points as per book up to 2.5" diameter
 | Peach | 6oz | 1 |  |  |  | 1 point as per book 2.75" or lgr. in diameter
 | PEAR  up to 6 oz 1 point 7oz = 2points
 | Plum 2 small or 1 medium |  |  |  |  |  | 1 point
 | PRETZELS | 5pcs / serving | 1 | 110 | 1 | 1
 | QA
 | RA
 | SA
 | Silk Plain Lite |  |  |  |  |  | 1 point as per book
 | Silk Vanilla Lite |  |  |  |  |  | 1 Point as per book
 | Skim Milk | 1 | 1 | 90 | 0 | 0 | AS PER BOOK 2 POINTS BUT CALS = 1.8
 | small banana |  |  |  |  |  | 1 point as per book
 | Smart Beat Cheese Slices | 1 | 1 | 25 | 0 | 0
 | Swiss Miss | 1 | 1 | 50 | 1 | 1
 | TA
 | Tortilla Chips  13 chips 28grams/serving |  |  | 140 | 4.5 | 2
 | UA
 | VA
 | [NAME] | 1 | 1 | 110 | 1 | 0
 | [NAME] | 1 | 1 | 110 | 2 | 0
 | WA
 | XA
 | [NAME]
 | ZA
 | end of list
Spreadsheet: 274035d1382990815-sumifs-with-column-concatenate-for-criteria-example
Sheet: Sheet1

 |  |  |  |  |  |  | Report Criteria
 | Tag_1 | Tag_2 | FY | FY_Month | Value |  | FY | FY Month
 | A | X | 2012 | 10 | 100 |  | 2012 | 10
 | A | Y | 2012 | 11 | 110 |  | 2013 | 2
 | A | Z | 2012 | 12 | 200
 | B | X | 2013 | 1 | 250
 | A | Y | 2013 | 2 | 244
 | B | Z | 2013 | 3 | 75
 | C | Z | 2013 | 4 | 80
 | =SUMIFS(data[Value],data[Tag_1],"A",data[FY]&data[FY_Month],J4&K4)
 | =SUMIFS(data[Value],data[Tag_1],"A",data[FY]&data[FY_Month],">="&J4&K4,data[FY]&data[FY_Month],"<="&J5&K5)