tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139831d1328503861-attributing-monthly-total-to-date-ranges-helpme
Sheet: Sheet1

Project | Customer | Project Name | Rate | Revenue | [NAME] | SoW/LoE Status | Notes | Start Date | End Date | Work Hours Available | Work Hours |  |  |  |  |  |  |  |  |  |  |  | Total Hours
 |  |  |  |  |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1 | X | Y | 190 | 60000 |  | Signed |  | 2012-01-11 00:00:00 | 2012-03-06 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | Vacation | Vacation | Vacation | Vacation | 40 |  |  | 2012-04-18 00:00:00 | 2012-04-27 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | X | Z | Fixed Bid | 10000 | 10 | Signed |  | 2012-04-30 00:00:00 | 2012-05-11 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | Z | AA | 150 | 6000 |  | Signed |  | 2012-05-12 00:00:00 | 2012-06-12 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
18 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
21 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
25 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
26 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
27 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
28 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
29 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
30 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 176 | 168 | 176 | 168 | 184 | 168 | 176 | 184 | 160 | 184 | 176 | 168
Spreadsheet: 218411d1362447575-look-up-specific-text-and-return-a-list-of-the-satisfied-text-example
Sheet: Sheet1

Road Names | [NAME]
Name 1 | CF
Name 2 | -
Name 3 | CS
Name 4 | -
Name 5 | -
Name 6 | SS
Name 7 | -
Name 8 | PO
Name 9 | -
Name 10 | -
Name 11 | -
Name 12 | -
Name 13 | CF
Name 14 | -
Name 15 | -
Name 16 | -
Name 17 | CF
Name 18 | -
Name 19 | -
Name 20 | CS
Name 21 | -
Name 22 | -
Name 23 | -
Name 24 | SS
Name 25 | -
Name 26 | D
Name 27 | -
Name 28 | -
Name 29 | CF
Name 30 | -
Name 31 | -
Name 32 | -
Name 33 | CS
Name 34 | -
Name 35 | -
Name 36 | -
Name 37 | D
Name 38 | -
Name 39 | -
Name 40 | CF
Name 41 | -
Name 42 | -
Name 43 | -
Name 44 | PO
Name 45 | -
Name 46 | -
Name 47 | -
Name 48 | -
Name 49 | -
Name 50 | CS
Name 51 | -
Name 52 | -
Name 53 | -
Name 54 | CF
Name 55 | -
Name 56 | D
Name 57 | -
Name 58 | -
Name 59 | -
Name 60 | -
Name 61 | CS
Name 62 | -
Name 63 | SS
Name 64 | -
Name 65 | -
Name 66 | CF
Name 67 | -
Name 68 | -
Name 69 | -
Name 70 | CS
Name 71 | -
Name 72 | -
Name 73 | D
Name 74 | -
Name 75 | CF
Name 76 | -
Name 77 | PO
Name 78 | -
Name 79 | -
Name 80 | -
Name 81 | -
Name 82 | -
Name 83 | -
Name 84 | -
Name 85 | SS
Name 86 | -
Name 87 | D
Name 88 | -
Name 89 | CF
Name 90 | -
Name 91 | -
Name 92 | -
Name 93 | -
Name 94 | -
Name 95 | CS
Name 96 | -
Name 97 | -
Name 98 | -
Name 99 | -
Name 100 | D
Name 101 | -
Name 102 | -
Name 103 | CF
Name 104 | -
Name 105 | -
Name 106 | -
Name 107 | SS
Name 108 | -
Name 109 | -
Name 110 | -
Name 111 | CS
Name 112 | -
Name 113 | -
Name 114 | CF
Name 115 | -
Name 116 | -
Name 117 | D
Name 118 | -
Name 119 | -
Name 120 | -
Name 121 | -
Name 122 | CS
Name 123 | -
Name 124 | -
Name 125 | -
Name 126 | -
Name 127 | CS
Name 128 | -
Name 129 | -
Name 130 | -
Name 131 | CF
Name 132 | -
Name 133 | -
Name 134 | SS
Name 135 | -
Name 136 | -
Name 137 | PO
Name 138 | -
Name 139 | -
Name 140 | D
Name 141 | -
Name 142 | CS
Name 143 | -
Name 144 | -
Name 145 | D
Name 146 | -
Name 147 | CF
Name 148 | -
Name 149 | -
Name 150 | -
Name 151 | -
Name 152 | SS
Name 153 | -
Name 154 | -
Name 155 | CF
Name 156 | -
Name 157 | -
Name 158 | -
Name 159 | CS
Name 160 | -
Name 161 | -
Name 162 | CF
Name 163 | -
Name 164 | PO
Name 165 | -
Name 166 | D
Name 167 | -
Name 168 | -
Name 169 | CF
Name 170 | -
Name 171 | -
Name 172 | -
Name 173 | -
Name 174 | CS
Name 175 | -
Name 176 | D
Name 177 | -
Name 178 | PO
Name 179 | -
Name 180 | CF
Name 181 | -
Name 182 | SS
Name 183 | -
Name 184 | -
Name 185 | -
Name 186 | D
Name 187 | -
Name 188 | -
Name 189 | -
Name 190 | PO
Name 191 | -
Name 192 | -
Name 193 | -
Name 194 | CF
Name 195 | -
Name 196 | D
Name 197 | -
Name 198 | CS
Name 199 | -
Name 200 | SS
Spreadsheet: 223092d1364047844-custom-sorting-using-numbers-filter
Sheet: Sheet1

Customer ID | data 1 | data 2 | data 3 | data 4 | data 5 | data 6 | Filter
213 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
219 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | x
275 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
287 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | x
366 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
425 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
508 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
509 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | x
551 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
574 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
617 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
633 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | x
694 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
833 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
905 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
929 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | x
960 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
987 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | x
Spreadsheet: 28ed92a3-7469-4c20-a1bc-61b7f99cb584
Sheet: MLC

RFTC Mobile Application Management Functional Requirements
Instructions:  Please review the responses and compare the response content against the RFTC Requirements Document.  If the response meets the requirement, then indicate its acceptance by coloring the cell green.  If it does not meet the requirement, or if the requirement has not been addressed in the response, then please indicate this by coloring the cell black.  If there is evidence that the suggests that the response exceeds the requirement, please indicate this in the comment section of the spreadsheet.
Requirements Reference | Description | Meets/Exceeds? | Comments
2.4.1.1 Project Management | Demonstrate past experience in developing and implementing a Project Management Plan directly related to [NAME], including how management tracked the quality and timeliness of the delivery
2.4.1.2 Deployment | Initial deployment support services including installing, configuring, and certifying the initial deployment of the MDM, MAM and [NAME] solutions, as well as the ability to support specific agency related integrations or customizations
2.4.1.3 Ent. Sys. Integration | Providing steps necessary for deploying and integrating their [NAME] into the enterprise-wide environment
2.4.1.4 Training | Developing and updating the MDM-MAM Training Material content, as well as providing prepackaged online training and associated materials described in the Training Plan
2.4.2.1.1 Help Desk | End User Help Desk support must be 24/7 including holidays
2.4.2.1.2 | Administrative / Management Help Desk must be available 8am-5pm in both EST and PST
2.4.2.1.3 | Utilize a trouble-ticketing system where each request has a unique identifier for tracking purposes
2.4.2.1.4 | Support online requests / resolution, supported with email
2.4.2.1.5 | Telephone Help Desk support must be available, but can be limited to business hours
2.4.3 Demo Platform | A demonstration platform to educate potential customers on the use, benefits and technical specification of the solution
2.4.4 (Opt) Ent. Configuration | Non-core integration, such as Solution connectivity with non-required components
2.4.5 (Opt) Int. w/ FSSI Wireless Portal | Ability to exchange information with third party providers for the purpose of providing complementary services such as device ordering, logistics, configuration, replacement/refresh, disposal, and disposition reporting
2.4.6 (Opt) TEMS | Addresses order management, ordering via portal, device provisioning, asset management, device asset tracking, non-device asset tracking, account reports, expense management, service plan management, optimization, and expense tracking/reporting
2.4.7 (Opt) Dev Replacement | Logistics services where a Contractor may support Government entities with Device replacement and refresh services based on existing government contracts with device providers, carrier or otherwise
2.4.8 (Opt) [NAME] | Compliant device wiping, destruction, recycling and reporting of mobile devices per government standards (NIST, [NAME], others) as required per individual agency requirements
Total Meeting Requirements
Spreadsheet: 95029d1294747299-automatically-update-a-couple-of-columns-from-master-worksheet-in-other-sheets-masterhelp
Sheet: Project

 |  |  | 2009 | 2009 | 2010 | 2010 | etc
 |  |  | Project 1 | Project 2 | Project 3 | Project 4 | etc
Name | Active | M/F | Project 1 Details | Project 2 Details | Project 3 Details | Project 4 Details | etc
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 865058d1712147833-filter-with-indirect-function-new-forecasting-template-draft-to-share-v5
Sheet: Dashboard Workings

 |  |  | PMO Period |  |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 2024/25 | 2025/26 | 2026/27 | 2027/28 | 2028/29 | 2029/30 | Contingency | Total | AFC exc Contingency | Approved Funding | Allocation
 |  | Prior years |  |  |  | 202301 | 202302 | 202303 | 202304 | 202305 | 202306 | 202307 | 202308 | 202309 | 202310 | 202311 | 202312
Cost Centre |  |  |  | Quarter |  | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
 |  |  |  | Q1 | Baseline
 |  |  | 202301 |  | Apr
 |  |  | 202302 |  | May
 |  |  | 202303 | Q2 | Jun
Previous Period |  |  | 202304 |  | Jul
 |  |  | 202305 |  | Aug
 |  |  | 202306 | Q3 | Sep
 |  |  | 202307 |  | Oct
 |  |  | 202308 |  | Nov
 |  |  | 202309 | Q4 | Dec
 |  |  | 202310 |  | Jan
 |  |  | 202311 |  | Feb
 |  |  | 202312 |  | Mar
 |  |  |  |  | Actual
 |  |  | Stages (Lifetime) |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 |  |  |  |  | Baseline | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
 |  |  |  | SOBC
 |  |  |  | OBC
 |  |  |  | FBC
 |  |  |  | Delivery
 |  |  |  | Post Completion
 |  |  |  | Revenue
 |  |  |  | Total
 |  |  |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 |  |  | Approved funding |  | Baseline | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
 |  |  |  | Prior Years
 |  |  |  | Current Year
 |  |  |  | 2025/26
 |  |  |  | 2026/27
 |  |  |  | 2027/28
 |  |  |  | 2028/29
 |  |  |  | 2029/30
 |  |  |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 |  |  | Contingency |  | Baseline | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
 |  |  |  | Prior Years
 |  |  |  | Current Year
 |  |  |  | 2025/26
 |  |  |  | 2026/27
 |  |  |  | 2027/28
 |  |  |  | 2028/29
 |  |  |  | 2029/30
 |  |  |  |  | Graph 1 - Cumulative In Year Spend
 |  |  |  |  |  | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | [NAME]
 |  |  |  |  | Actuals
 |  |  |  |  | Baseline
 |  |  |  |  | Prior Month
 |  |  |  |  | Current Month
 |  |  |  |  | [NAME] Breakdown
 |  |  |  |  | Spent
 |  |  |  |  | Current Year Forecast
 |  |  |  |  | Future Year Forecast
 |  |  |  |  | Contingency
 |  |  |  |  | [NAME]
 |  |  |  |  |  | Prior Years | 2024/25 | 2025/26 | 2026/27 | 2027/28 | 2028/29 | 2029/30 | Total
 |  |  |  |  | Baseline
 |  |  |  |  | Prior Month
 |  |  |  |  | Current Month
 |  |  |  |  | Workings for Quarter Actuals vs Foreacst
 |  |  |  |  |  | Month 1 | Month 2 | Month 3
 |  |  |  |  | Actuals
 |  |  |  |  | Graph - AFC Movement
 |  |  |  |  |  | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | [NAME]
 |  |  |  |  | AFC
Spreadsheet: 489251d1479156665-trying-to-match-up-data-that-only-matches-in-the-middle-of-one-workbook-copy-of-2017-deadlines-and-programs
Sheet: Phoenix

[NAME] | Item Desc
36502-R80-BG00 | CN PH 5352A4 3111 R80 A250V
36509-R80-BG00 | CN PH 5552A4 3111 R80 A250(BG)
36510-F80-BG00 | CN PH 5552A4 3111 F80 A500 (BG
36520-F80-BG00 | CN PH 6522A4 3111 F80 A500(BG
36520-R80-BG00 | CN PH 6522A4 3111 R80 A500(BG
36530-R80-BG00 | CN PH 6542A4 3111 R80 A500(BG)
36537-F80-BG00 | CN PH6706A4 [NAME] A500V+TBZ
36537-R80-BG00 | CN PH6706A4 3111 R80 A500V+TBZ
36547-F80-BG00 | CN PH 7402A3 3000GT F80 A500V
36548-R80-BG00 | CN PH 7402A3 3000GT R80 A1250V
36552-R80-BG00 | CN PH 7914A4 3111 R80 A500V
Spreadsheet: 7fc1cc5e-4ec4-4763-a493-e90afb1e9798
Sheet: Sheet1

[NAME] | 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
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Das AHV-Rentenalter wird erhöht.
 | Welcher Partei haben [NAME] bei der letzten <b>Nationalratswahl im [NAME] 2007</b> hauptsächlich [NAME] gegeben?
Antwort | CVP | EDU | EVP | FDP | Grüne | Liberale (LPS) | SD | SP | SVP | Andere | Weiss nicht | Grünliberale | nicht zur Wahl gegangen
[NAME] | 0.39 | 0.33 | 0.37 | 0.53 | 0.2 | 0.51 | 0.19 | 0.22 | 0.34 | 0.25 | 0.17 | 0.37 | 0.22
Neutral/Weiss nicht | 0.12 | 0.15 | 0.16 | 0.12 | 0.16 | 0.12 | 0.05 | 0.13 | 0.11 | 0.1 | 0.2 | 0.16 | 0.14
[NAME] | 0.5 | 0.52 | 0.47 | 0.35 | 0.64 | 0.37 | 0.76 | 0.65 | 0.55 | 0.64 | 0.63 | 0.46 | 0.64
Angaben zu den [NAME]
Erhebungsjahr | 2010
Stichprobengrösse | 29292
Erhebungszeitraum | 02.10.2010 bis: 06.12.2010
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 169191d1342721497-excel-2007-how-to-delete-both-duplicate-entries-in-excel-2007-delete-both-duplicates
Sheet: Sheet1

First | Last | Helper 1 | Helper 2
First 1 | Last 1 |  |  | <<Create this formula in Col D
First 10 | Last 10 |  |  | Sort by Col D and delete all rows with 2 in them.
First 10 | Last 10
First 11 | Last 11
First 12 | Last 12
First 13 | Last 13
First 14 | Last 14
First 15 | Last 15
First 15 | Last 15
First 16 | Last 16
First 17 | Last 17
First 18 | Last 18
First 19 | Last 19
First 2 | Last 2
First 20 | Last 20
First 20 | Last 20
First 21 | Last 21
First 22 | Last 22
First 23 | Last 23
First 24 | Last 24
First 25 | Last 25
First 25 | Last 25
First 26 | Last 26
First 27 | Last 27
First 28 | Last 28
First 29 | Last 29
First 3 | Last 3
First 30 | Last 30
First 35 | Last 35
First 4 | Last 4
First 40 | Last 40
First 45 | Last 45
First 5 | Last 5
First 5 | Last 5
First 50 | Last 50
First 55 | Last 55
First 6 | Last 6
First 60 | Last 60
First 65 | Last 65
First 7 | Last 7
First 8 | Last 8
First 9 | Last 9
Spreadsheet: 05b6018c-eee6-4c3f-8835-d3d1100e8c1a
Sheet: Sheet1

Cardinal Stricth University Reading / Urban Literacy Centers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Proposed Sliding Scale Guidelines for Fall and Spring 2008 -2009
Family Eligibility:
No Free or Reduced Meal Eligibility
 | Tutoring: |  | Tuition Per Session | 14 Sessions | 10 Sessions
 |  | Master Instructors | 25 | 350 | 250
 |  | Undergraduate / Graduate Student | 15 | 210 | 150
 | Assessment Fees:
 |  | Planning | 90
 |  | Literacy Levels | 250
 |  | Comprehensive | 275
Reduced Meal Eligibility
 | Tutoring: |  | Tuition Per Session | 14 Sessions | 10 Sessions
 |  | Master Instructors | 10 | 140 | 100
 |  | Undergraduate / Graduate Student | 6 | 84 | 60
 |  | Excellent [NAME] Plan (Master Instructors)
 |  |  |  | 14 Sessions |  | 10 Sessions
 |  | # of Absences | % of Rebate | $ of Rebate | Out of Pocket Cost | $ of Rebate | Out of Pocket Cost
 |  | 0 | 0.8 | 112 | 28 | 80 | 20
 |  | 1 | 0.6 | 84 | 56 | 60 | 40
 |  | 2 | 0.4 | 56 | 84 | 40 | 60
 |  | More than 2 | 0 | 0 | 140 | 0 | 100
 |  | Excellent [NAME] Plan (Undergraduate / Graduate Student)
 |  |  |  | 14 Sessions |  | 10 Sessions
 |  | # of Absences | % of Rebate | $ of Rebate | Out of Pocket Cost | $ of Rebate | Out of Pocket Cost
 |  | 0 | 0.8 | 67.2 | 16.8 | 48 | 12
 |  | 1 | 0.6 | 50.4 | 33.6 | 36 | 24
 |  | 2 | 0.4 | 33.6 | 50.4 | 24 | 36
 |  | More than 2 | 0 | 0 | 84 | 0 | 60
 | Assessment Fees:
 |  | Planning | 36
 |  | Literacy Levels | 100
 |  | Comprehensive | 110
Free Meal Eligibility Families
 | Tutoring: |  | Tuition Per Session | 14 Sessions | 10 Sessions
 |  | Master Instructors | 5 | 70 | 50
 |  | Undergraduate / Graduate Student | 3 | 42 | 30
 |  | Excellent [NAME] Plan ( Master Instructors)
 |  |  |  | 14 Sessions |  | 10 Sessions
 |  | # of Absences | % of Rebate | $ of Rebate | Out of Pocket Cost | $ of Rebate | Out of Pocket Cost
 |  | 0 | 1 | 70 | 0 | 50 | 0
 |  | 1 | 0.75 | 52.5 | 17.5 | 37.5 | 12.5
 |  | 2 | 0.6 | 42 | 28 | 30 | 20
 |  | More than 2 | 0 | 0 | 70 | 0 | 50
 |  | Excellent [NAME] Plan (Undergraduate / Graduate Student)
 |  |  |  | 14 Sessions |  | 10 Sessions
 |  | # of Absences | % of Rebate | $ of Rebate | Out of Pocket Cost | $ of Rebate | Out of Pocket Cost
 |  | 0 | 1 | 42 | 0 | 30 | 0
 |  | 1 | 0.75 | 31.5 | 10.5 | 22.5 | 7.5
 |  | 2 | 0.6 | 25.2 | 16.8 | 18 | 12
 |  | More than 2 | 0 | 0 | 42 | 0 | 30
 | Assessment Fees:
 |  | Planning | 18
 |  | Literacy Levels | 50
 |  | Comprehensive | 55
Spreadsheet: 752621d1634860617-up-right-arrow-pre-numbers-when-pasting-from-html-page-sample-
Sheet: Sheet1

‎20 | ‎50.28 | ‎1,005.60
‎20 | ‎81.08 | ‎1,621.60
‎20 | ‎42.48 | ‎849.60
‎30 | ‎107.28 | ‎3,218.40
‎5 | ‎109.08 | ‎545.40
‎20 | ‎77.94 | ‎1,558.80
‎10 | ‎84.52 | ‎845.20
‎50 | ‎46.66 | ‎2,333.00
‎30 | ‎85.82 | ‎2,574.60
‎30 | ‎82.62 | ‎2,478.60
‎30 | ‎64.36 | ‎1,930.80
‎30 | ‎66.26 | ‎1,987.80
Spreadsheet: 759867d1639765595-consolidate-multiple-tables-data-consolidate-multiple-tables-data
Sheet: Sheet1 (2)

("A") |  |  |  |  | ("B") |  |  |  | ("C")
Raw Material Code | Item Code | Qty. | Total Weight |  | Raw Material Code | Item Code | Unit [NAME]. |  | Raw Material Code | Weight
 | HY-05 | 2 | 181.752 |  | YYY111 | [NAME] | 8.242 |  | [NAME] | 65
 | [NAME] | 1 | 90.876 |  | YYY111 | [NAME] | 9.812 |  | AB135 | 209
[NAME] | [NAME] | 650 | 65 |  | XXX222 | [NAME] | 140.479 |  | AB137 | 647.5
AB135 | AB135 | 950 | 209 |  | YYY333 | HY-05 | 4.07 |  | ABC123 | 512.93
ABC123 | HY-04 | 22 | 512.93 |  | YYY333 | HY-05 | 4.296 |  | ZZZ555 | 19.02
ABC123 | HY-06 | 30 | 698.49 |  | XXX444 | HY-05 | 7.398 |  | ZZZ555 | 15.6
 |  |  |  |  | XXX444 | HY-05 | 75.112
DESIRED RESULT
Raw Material Code | Weight of "C" | Weight of "A" (or) "B" | Difference |  | The requirement is as follows:
[NAME] |  |  |  |  | 1. All the Raw Material codes are to be consolidated in one table (result table). (Unique values from "A", "B" & "C")
AB135 |  |  |  |  | 2. Wherever Raw Material codes are blank ([NAME]), need to get the Raw Material codes from "B" with reference to the [NAME] codes.
AB137 |  |  |  |  | 3. Weight of "C" to sumif the weights in Col.K
ABC123 |  |  |  |  | 3. Weight of "A" to come directly (if there are two Raw Material codes available, it should sum i.e. [NAME] is sum of D7 & D8)
YYY111 |  | 18.054 |  |  | 4. Weight of Raw Material Codes from "B" to sum Unit weights (of the Raw Material code i.e. Col.H) and multiple with Item code Qty. (Col. [NAME]:C8)
XXX222 |  |  |  |  | (Ex: for YYY111 there are 2 Raw Materials available (F3&F4) (sum 18.054) and multiply with 2 (C3) (with reference to item code [NAME])
YYY333
XXX444
ZZZ555
Spreadsheet: 110798d1307396303-how-to-cross-referencing-two-lists-and-copying-relevant-information-how-to-cross-referencing-two-lists-and-copying-relevant-information
Sheet: Master

Name | Address | Address 2 | City | State | Phone | Fax | [NAME] | Source | Website
Name1
[NAME]
Name3
Name4
Name5
Name6
Name7
Name8
Name9
Name10
Name11
Name12
Name13
Name14
Name15
[NAME]
Name17
Name18
Name19
[NAME]
Name21
Name22
Name23
Name24
Name25
Name26
Name27
Name28
Name29
Name30
Name31
Name32
Name33
[NAME]
Name35
Name36
Name37
Name38
[NAME]
Name40
Name41
Name42
Name43
Name44
Name45
Name46
[NAME]
Name48
Name49
Name50
Name51
[NAME]
Name53
Name54
Name55
Name56
Name57
Name58
Name59
Name60
Name61
Name62
Name63
Name64
Name65
Name66
[NAME]
[NAME]
Name69
Name70
Name71
Name72
[NAME]
Name74
Name75
Name76
Name77
Name78
Name79
Name80
Name81
Name82
Name83
Name84
Name85
Name86
Name87
[NAME]
Name89
Name90
Name91
Name92
[NAME]
[NAME]
Name95
Name96
Name97
Name98
Name99
Spreadsheet: 744029d1628870803-find-the-first-x-or-the-first-o-when-another-cell-contains-the-same-value-example
Sheet: Sheet1

Job | Sequence | Status
4579032L11 | 0 | C
4579032L11 | 1 | S
4579032L11 | 2 | O
4579032L11 | 3 | O
4579032L11 | 4 | O
4579032L11 | 5 | O
4579032L11 | 6 | O
4579032L11 | 7 | O
4579032L11 | 8 | O
4579032L11 | 9 | O
4526003LB5 | 0 | C
4526003LB5 | 1 | C
4526003LB5 | 2 | C
4526003LB5 | 3 | C
4526003LB5 | 4 | C
4526003LB5 | 5 | C
4526003LB5 | 6 | S
4526003LB5 | 7 | O
4526003LB5 | 8 | O
4526003LB5 | 9 | O
4526003LB5 | 10 | O
4526003LB5 | 11 | O
4526003LB5 | 12 | O
4526003LB5 | 13 | O
4526003LB6 | 0 | C
4526003LB6 | 1 | C
4526003LB6 | 2 | O
4526003LB6 | 3 | O
4526003LB6 | 4 | O
4526003LB6 | 5 | O
4526003LB6 | 6 | O
4526003LB6 | 7 | O
4526003LB6 | 8 | O
4526003LB6 | 9 | O
4526003LB6 | 10 | O
4526003LB6 | 11 | O
4526003LB6 | 12 | O
4526003LB6 | 13 | O
Spreadsheet: 69f266af-c616-4127-b863-c9de7c01623a
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
[NAME] | Test | [NAME] | Topiramate, Serum | Topiramate, 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 | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | 2.0-20.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 1 day | 1 | 80201 |  |  |  |  | Rochester
[NAME] | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
[NAME] | Result | 81546 | Topiramate, S | Topiramate, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 17713-9