tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 675010d1588104518-power-query-unpivot-data-that-has-multiple-headings-sample
Sheet: Sheet1

 | Site Location
 | Employee 1 |  | Employee 2 |  | Employee 3 |  | Employee 4 |  | Employee 5
Date | Leave type | Hours | Leave type | Hours | Leave type | Hours | Leave type | Hours | Leave type | Hours
2020-04-20 00:00:00
2020-04-21 00:00:00
2020-04-22 00:00:00
2020-04-23 00:00:00
2020-04-24 00:00:00 |  |  |  |  |  |  |  |  | Annual | 8
2020-04-25 00:00:00
2020-04-26 00:00:00
2020-04-27 00:00:00 |  |  |  |  |  |  |  |  | Annual | 8
2020-04-28 00:00:00 |  |  |  |  |  |  |  |  | Annual | 8
2020-04-29 00:00:00 |  |  | Annual | 8 |  |  |  |  | Annual | 8
2020-04-30 00:00:00 |  |  | Annual | 8 |  |  |  |  | Annual | 8
2020-05-01 00:00:00 |  |  | Annual | 8 |  |  |  |  | Annual | 8
2020-05-02 00:00:00
2020-05-03 00:00:00
2020-05-04 00:00:00 |  |  | Annual | 8
2020-05-05 00:00:00 |  |  | Annual | 8
2020-05-06 00:00:00 |  |  | Annual | 8
2020-05-07 00:00:00
2020-05-08 00:00:00
Spreadsheet: 819798d1677692205-conditional-formatting-based-on-start-date-and-certain-parameters-example-etaf
Sheet: Sheet1

Name | Cost Centres | Start Date | Feb'22 31-28 | Mar'22 01-03 | Apr'22 04-01 | May'22 04-29 | Jun'22 30-3 | Jul'22 04-31 | Aug'22 01-28 | Sep'22 29-02 | Oct'22 03 - 30 | Nov'22 31 - 04 | Dec'22 05-01 | [NAME] | 12mth Total |  | 3mths -red | 3-12mths 20+ | >1yr Amber >130 |  |  | RED | >1yr Amber >65
EMPLOYEE 1 | ABC | 2019-09-09 00:00:00 | 20 | 24.99999999999999 | 19.99999999999999 | 19.99999999999999 | 24.99999999999999 | 19.99999999999999 | 19.99999999999999 | 24.99999999999999 | 19.99999999999999 | 5
EMPLOYEE 2 | ABC | 2019-11-25 00:00:00 |  |  |  | 5 | 25 | 20 | 19.99999999999999 | 2 |  | 0.75 |  | 2 |  |  |  |  |  |  |  |  |  |  | If the employee has been employed under 3 months from "Today" - Highlight number Red
EMPLOYEE 3 | ABC | 2015-05-11 00:00:00 |  |  | 3 | 5 | 1 |  | 3 | 0.5 |  | 10 | 17.99999999999999 | 19.99999999999999 |  |  |  |  |  |  |  |  |  |  | If the employee has been employed between 3 - 12 months from "Today" - Highlight the number Red (once 20+)
EMPLOYEE 4 | ABC | 2014-04-07 00:00:00 |  |  |  |  | 3 | 10 | 5.999999999999999 | 8 |  |  | 13 | 1 |  |  |  |  |  |  |  |  |  |  | If the employee has been employed over 12 months from "Today" - highlight the number Amber once over 65, then highlight Red once over 130
EMPLOYEE 5 | ABC | 2022-07-11 00:00:00 |  |  |  |  |  |  | 5.062499999999999 |  | 1 | 11 | 5 | 15
EMPLOYEE 6 | ABC | 2021-06-14 00:00:00 | 9 |  |  | 5 | 5 | 4.499999999999999 |  |  | 4.25 | 4 |  | 3.8125
EMPLOYEE 7 | ABC | 2021-10-25 00:00:00 | 15 |  | 14 | 5
EMPLOYEE 8 | ABC | 2004-02-02 00:00:00 |  |  | 12 | 5 | 15
EMPLOYEE 9 | ABC | 2021-03-08 00:00:00 |  | 2 |  | 13 | 15 |  |  |  | 1 |  | 1
EMPLOYEE 10 | ABC | 2021-03-01 00:00:00 | 2 |  | 5.999999999999999 |  |  |  | 2 |  |  | 5 |  | 16
EMPLOYEE 11 | ABC | 2015-08-03 00:00:00 |  | 24.99999999999999 |  |  |  |  |  |  |  | 2
EMPLOYEE 12 | ABC | 2021-03-29 00:00:00 | 1 | 3.3125 |  | 1 | 1 |  | 1.5 | 0.75 | 6.5 | 7.5 | 2.375 | 1
EMPLOYEE 13 | ABC | 2023-01-03 00:00:00 |  | 3 | 17.99999999999999 | 4.1875
EMPLOYEE 14 | ABC | 2022-08-22 00:00:00 |  |  |  |  |  |  |  |  |  |  | 9 | 15.5
EMPLOYEE 15 | ABC | 2004-08-09 00:00:00 |  | 5 |  | 3 | 2 |  |  | 4 | 5 | 3 | 2
EMPLOYEE 16 | ABC | 2022-02-07 00:00:00 |  |  |  |  |  |  |  |  | 3.125 | 11 | 8
EMPLOYEE 17 | ABC | 2021-06-14 00:00:00 |  |  |  | 1 |  | 3 | 15 |  |  | 0.5 |  | 1.75
EMPLOYEE 18 | ABC | 2016-08-30 00:00:00 | 11.36 | 4.1875 | 5.375
EMPLOYEE 19 | ABC | 2022-04-11 00:00:00 |  |  | 2 |  |  |  |  | 2.3125 | 1 | 5.9375 |  | 7.625
EMPLOYEE 20 | ABC | 2003-02-10 00:00:00 |  | 14.75 |  |  | 0.5 | 0.5 | 1.5 | 1.5
Spreadsheet: 889926d1740962521-filter-function-nested-if-multi-better-simpler-expression-combobox-filter-4multidependent-unique-az-srch-xl21-dynamic-spill-srch-cam-slicer-trick
Sheet: DATA

MAKE | MODEL | FUEL | TYPE | DESC | IG |  | MAKE |  | Formula SRCH Col A | Formula SRCH Col B | Formula SRCH Col C | Formula SRCH Col D |  | 1BOX |  | 2O6 | DIESEL | Hdi | [NAME] | 7 |  | 2BOX |  | 2O6 | DIESEL | Hdi | [NAME] | 7 |  | 3BOX |  |  |  |  |  |  |  | 4BOX |  |  |  |  |  |  |  | BLANK
Peugeot | 2O7 | PETROL | Gti | OK | 15 |  |  |  |  |  |  |  |  |  | Peugeot | 2O6 | PETROL | GTI | Sporty | 10 |  |  | Peugeot | 2O6 | DIESEL | GT Hdi | [NAME] | 7
Peugeot | 3O6 | DIESEL | TD | [NAME] | 13 |  |  |  |  | 2O7 | PETROL |  |  |  | Peugeot | 2O6 | DIESEL | GT Hdi | [NAME] | 7 |  |  | Peugeot | 2O6 | PETROL | GTI | Sporty | 10
Honda | Civic | PETROL | Type R | [NAME] | 13 |  |  |  |  | 3O6 |  |  |  |  | Peugeot | 2O7 | PETROL | Gti | OK | 15
Fiat | Panda | PETROL | Dlux | Poor |  |  |  |  |  | 3O7 |  |  |  |  | Peugeot | 3O6 | DIESEL | TD | [NAME] | 13
Citreon | Ax | PETROL | Vibe | Poor |  |  |  |  |  |  |  |  |  |  | Peugeot | 3O7 | DIESEL | Hdi | [NAME] | 11
Vauxhall | Nova | PETROL | SRI | Dull | 8 |  |  |  |  |  |  |  |  |  | Peugeot | 3O7 | DIESEL | Hdi | Super | 11
Rover Metro | Metro | PETROL | Club | Dull
Peugeot | 3O7 | DIESEL | Hdi | [NAME] | 11
Peugeot | 2O6 | DIESEL | Hdi | [NAME] | 7
Bmw | 3 series | DIESEL | Tdi | Nice | 10
Bmw | Z4 | PETROL | Sport | Great | 15
Bmw | X4 | PETROL | 4WD | 4x4 | 16
Renault | Megane | DIESEL | Dci | Great | 8
Proton | Impian | PETROL | Sport | Dull | 8
Ford | Focus | DIESEL | TDCi | Great | 11
Honda | Civic | DIESEL | CDTi | Great | 10
Peugeot | 3O7 | DIESEL | Hdi | Super | 11
Fiat | Punto | PETROL | Sport | Tidy | 8
Vauxhall | Astra | PETROL | VXR | Great | 9
Peugeot | 2O6 | PETROL | GTI | Sporty | 10
Honda | Civic | DIESEL | CDTi | Excellent | 10
Peugeot | 2O6 | DIESEL | GT Hdi | [NAME] | 7
Bmw | 3 series | DIESEL | Tdi | Nice | 10
Bmw | 3 series | DIESEL | [NAME] | Nice | 10
Spreadsheet: 216262d1361671543-number-of-units-and-employee-required-hourly_reading_week
Sheet: Overview

Hourly | Z |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UNIT RANGE
Reading |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From | [NAME] | # of employees
 | Wed |  |  | Thu |  |  | Fri |  |  | Sat |  |  | Sun |  |  | Mon |  |  | Tue
 | C | U |  | C | U |  | C | U |  | C | U |  | C | U |  | C | U |  | C | U |  |  | 0 | 13 | 1
6-7 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
7-8 | 1 | 1 | 1 | 3 | 5 | 1 | 2 | 3 | 1 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 14 | 24 | 2
8-9 | 2 | 3 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 2 | 4 | 1 |  |  | 0 |  |  | 0 |  |  | 0
9-10 | 2 | 3 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 2 | 4 | 1 | 2 | 79 | 4 |  |  | 0 |  |  | 0 |  | 25 | 40 | 3
10-11 | 3 | 81 | 4 | 6 | 6 | 1 | 5 | 13 | 1 | 4 | 4 | 1 | 2 | 3 | 1 | 3 | 3 | 1 |  |  | 0 |  | 41 | 60 | 4
11-12 | 10 | 11 | 1 | 16 | 20 | 2 | 14 | 16 | 2 | 10 | 20 | 2 | 4 | 9 | 1 | 8 | 10 | 1 | 11 | 20 | 2
12-13 | 23 | 24 | 2 | 37 | 41 | 4 | 22 | 24 | 2 | 15 | 21 | 2 | 7 | 8 | 1 | 10 | 15 | 2 | 28 | 31 | 3
13-14 | 28 | 27 | 3 | 16 | 24 | 2 | 33 | 37 | 3 | 9 | 13 | 1 | 8 | 10 | 1 | 6 | 7 | 1 | 24 | 26 | 3
14-15 | 5 | 4 | 1 | 9 | 10 | 1 | 3 | 5 | 1 | 8 | 8 | 1 | 2 | 3 | 1 | 5 | 8 | 1 | 8 | 9 | 1
15-16 | 7 | 5 | 1 | 6 | 9 | 1 | 4 | 7 | 1 | 8 | 12 | 1 | 5 | 5 | 1 | 8 | 7 | 1 | 9 | 9 | 1
16-17 | 11 | 14 | 2 | 18 | 22 | 2 | 13 | 25 | 3 | 7 | 9 | 1 | 8 | 11 | 1 | 5 | 6 | 1 | 1 | 2 | 1
17-18 | 11 | 19 | 2 | 14 | 30 | 3 | 10 | 11 | 1 | 7 | 15 | 2 | 8 | 11 | 1 | 12 | 20 | 2 | 6 | 8 | 1
18-19 | 8 | 14 | 2 | 13 | 18 | 2 | 14 | 24 | 2 | 6 | 10 | 1 | 8 | 13 | 1 | 8 | 14 | 2 | 9 | 14 | 2
19-20 | 9 | 17 | 2 | 11 | 18 | 2 | 13 | 16 | 2 | 6 | 8 | 1 | 2 | 6 | 1 | 2 | 3 | 1 | 4 | 4 | 1
20-21 | 5 | 6 | 1 | 5 | 8 | 1 | 3 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 0 |  |  | 0
21-22 | 8 | 11 | 1 | 2 | 2 | 1 | 6 | 5 | 1 | 3 | 4 | 1 |  |  | 0 |  |  | 0 |  |  | 0
22-23 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
23-24 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
0-1
1-2
2-3
3-4
4-5
Night | 13 | 17 |  | 2 | 2 |  | 11 | 13 |  | 6 | 7 |  | 1 | 1 |  |  |  |  | 1 | 1
5-6
Spreadsheet: 689141d1596139906-sum-of-1-column-based-on-2-criteria-test-sheet
Sheet: Sheet1

 | Date | Address | Job | [NAME] | Pay Earned | Totals By Month: | [NAME] | Pay | Company 1 | Company 2 | Company 3
 | 2020-01-27 00:00:00 | 1 bob lane | Company 1 | 10 | 15 | January
 | 2020-01-28 00:00:00 | 233 Country Club Ln | Company 1 | 123 | 81 | February
 | 2020-02-07 00:00:00 | 2030 Rt 52 | Company 2 | 121 | 150 | March
 | 2020-02-11 00:00:00 | 307 Main St | Company 3 | 251 | 36 | April
 | 2020-02-12 00:00:00 | 555 7th St | Company 2 | 94 | 54 | May
Spreadsheet: 9f7ea2b1-a502-4c3b-b4d1-063feebcebf6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4910 | 13354 | [NAME] | [NAME] | GBR | 0 | 01:16:44 | 00:06:00 | 03:07:15 | 00:05:05 | 03:13:11 | 1 | 07:48:17
Spreadsheet: 66612d1267228355-multiple-page-layout-in-worksheet-print
Sheet: Sheet4

ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd | ddddd
Spreadsheet: 768197d1644876819-trying-to-quickly-remove-numbers-from-addresses-sample-addresses
Sheet: Sheet1

 | streetaddress
 | 5358 W GRACE ST
 | 1400 N CICERO AVE
 | 3757 W HIRSCH ST
 | 2211 W 21ST ST
 | 49 E 101ST ST
 | 6300 S CHAMPLAIN AVE
 | 2137 N SPAULDING AVE
 | 7120 S MOZART ST
 | 6400 N NORDICA AVE
 | 459 E 74TH ST
 | 3401 W ARDMORE AVE
 | 230 W MONROE ST
 | 6200 W FOSTER AVE
 | 4035 N CAMPBELL AVE
 | 2301 E 81ST ST
 | 4035 N CAMPBELL AVE
 | 5313 S MARYLAND AVE
 | 1 E SUPERIOR ST
 | 5858 S COTTAGE GROVE AVE
 | 32 E 101ST ST
 | 4421 N MEADE AVE
 | 649 E 63RD ST
 | 260 W 24TH ST
 | 10031 S PAXTON AVE
 | 8332 S ANTHONY AVE
 | 6300 S CHAMPLAIN AVE
 | 9200 S EBERHART AVE
 | 5725 W 64TH ST
 | 1471 W ERIE ST
 | 5237 W PARKER AVE
 | 2200 N ORCHARD ST
 | 1514 N [NAME] AVE
 | 1400 W HOLLYWOOD AVE
 | 7300 W BALMORAL AVE
 | 7254 S SAWYER AVE
 | 6322 S LA CROSSE AVE
 | 3223 W BELLE PLAINE AVE
 | 6400 S LANGLEY AVE
 | 5100 S LEAMINGTON AVE
Spreadsheet: a3576e6b-71e6-4b1f-862b-092995acf894
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
1 | Carmen Baty
2 | Cally Stubbs
3 | [NAME]
4 | [NAME]
9 | [NAME]
11 | Marina [NAME]
13 | [NAME]
15 | [NAME]
16 | [NAME]
18 | [NAME]
19 | [NAME]
21 | [NAME] Jeter
23 | [NAME]
25 | [NAME]
26 | [NAME]
27 | Blake Pilcher
32 | [NAME]
35 | [NAME]
36 | [NAME]
37 | [NAME]
39 | [NAME]
40 | [NAME]
42 | [NAME]
44 | [NAME]
45 | Serenity [NAME]
47 | [NAME]
49 | [NAME]
52 | [NAME]
53 | [NAME]
54 | Destiny Childers
56 | [NAME]
59 | [NAME]
61 | [NAME]
62 | Autumn Watrous
63 | Carmen Maness
67 | [NAME]
69 | [NAME]
71 | [NAME]
73 | [NAME]
75 | Crystal Jones
77 | [NAME]
79 | [NAME]
81 | Caila Frederick
83 | [NAME]
84 | [NAME]
86 | [NAME]
88 | [NAME]
89 | [NAME]
91 | [NAME]
95 | [NAME]
96 | [NAME]
102 | [NAME]
103 | [NAME]
105 | [NAME]
108 | Dustin Cunde
109 | [NAME]
112 | [NAME]
115 | Samantha Stamnes
116 | [NAME]
117 | Mikayla [NAME]
119 | [NAME]
121 | [NAME]
122 | [NAME] McClain
124 | [NAME]
125 | [NAME], Jr.
128 | [NAME]
130 | Briar Smith
133 | Skylar Stokes
135 | Hanna Seymour
137 | [NAME]
138 | [NAME]
141 | [NAME]
142 | [NAME]
144 | [NAME]
147 | [NAME]
148 | [NAME]
149 | Tiffany Vautrin
151 | [NAME]
152 | [NAME]
158 | Thorton Hargrove
159 | [NAME]
163 | [NAME]
165 | [NAME]
167 | [NAME]
168 | [NAME]
170 | [NAME]
172 | [NAME]
174 | [NAME]
176 | [NAME]
178 | [NAME]
181 | [NAME]
182 | [NAME]
183 | [NAME]
184 | [NAME]
185 | [NAME]
186 | [NAME]
187 | [NAME]
190 | [NAME]
191 | [NAME]
193 | [NAME]
195 | [NAME]
197 | [NAME]
199 | [NAME]
Spreadsheet: cff9cd23-483b-4a6d-99df-42a84f9f8a3e
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
BAHG | Test | BAHG | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BAHG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BAHG | Result | BAHG | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6034-3 | Paspalum notatum Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 844932d1696527213-how-to-fetch-data-from-other-sheets-in-one-sheet-based-on-quarters-attendance-2-1-
Sheet: Dashboard

[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q1S | Q2S | Q3S | Q4S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January | April | July | October
Quarter | Q1 |  |  |  |  |  |  | Q2 |  |  |  |  |  |  | Q3 |  |  |  |  |  |  | Q4 |  |  |  |  |  |  |  |  | February | May | August | November
Associate Name | Present | # of ULs | # of UUs | # of HL | # of PLs | Total Leaves | Attendance% | Present | # of ULs | # of UUs | # of HL | # of PLs | Total Leaves | Attendance% | Present | # of ULs | # of UUs | # of HL | # of PLs | Total Leaves | Attendance% | Present | # of ULs | # of UUs | # of HL | # of PLs | Total Leaves | Attendance% |  |  | March | June | September | December
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
Spreadsheet: 706526d1606757933-formula-sum-and-multiplying-dynamic-array-spilled-behavior-dynamic-array
Sheet: Drivers

Product | Price | Volume |  |  | Price | Volume | Revenue
a | 1 | 10 |  | a | 1 | 10 | 10
b | 2 | 20 |  | b | 2 | 20 | 40
c | 3 | 30 |  | c | 3 | 30 | 90
d | 4 | 40 |  | d | 4 | 40 | 160
 |  |  |  | Total |  | 100 | 300
Spreadsheet: c7146699-c3e6-4456-9ba1-98a3811da22e
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2
Quelle: http://ergebnisse.vimentis.ch/
Frage:
[NAME] müssen gleich behandelt werden wie private [NAME] (sie erhalten keine [NAME] öffentlichen Hand und können [NAME] gehen).
 | Stadt/Land
Antwort | Land | Stadt
[NAME] | 0.27 | 0.25
[NAME] | 0.64 | 0.64
Neutral / Weiss nicht | 0.1 | 0.11
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: 76808d1277298510-excel-2007-reverse-count-pivot-table-book2
Sheet: Sheet1

Current Data
Area # | Job | 2009-11-07 00:00:00 | 2009-12-12 00:00:00 | 2010-02-06 00:00:00
Area 1 | Food & Bev | 0 | 10 | 15
Area 1 | Stores | 15 | 0 | 15
Area 2 | Food & Bev | 0 | 0 | 2
How I want it to look
Area # | Job | Start Date
Area 1 | Food & Bev | 2009-12-12 00:00:00
Area 1 | Food & Bev | 2009-12-12 00:00:00
Area 1 | Food & Bev | 2009-12-12 00:00:00
Area 1 | Food & Bev | 2009-12-12 00:00:00
Area 1 | Food & Bev | 2009-12-12 00:00:00
Area 1 | Food & Bev | 2009-12-12 00:00:00
Area 1 | Food & Bev | 2009-12-12 00:00:00
Area 1 | Food & Bev | 2009-12-12 00:00:00
Area 1 | Food & Bev | 2009-12-12 00:00:00
Area 1 | Food & Bev | 2009-12-12 00:00:00
Area 1 | Food & Bev | 2010-02-06 00:00:00
Area 1 | Food & Bev | 2010-02-06 00:00:00
Area 1 | Food & Bev | 2010-02-06 00:00:00
Area 1 | Food & Bev | 2010-02-06 00:00:00
Area 1 | Food & Bev | 2010-02-06 00:00:00
Area 1 | Food & Bev | 2010-02-06 00:00:00
Area 1 | Food & Bev | 2010-02-06 00:00:00
Area 1 | Food & Bev | 2010-02-06 00:00:00
Area 1 | Food & Bev | 2010-02-06 00:00:00
Area 1 | Food & Bev | 2010-02-06 00:00:00
Area 1 | Food & Bev | 2010-02-06 00:00:00
Area 1 | Food & Bev | 2010-02-06 00:00:00
Area 1 | Food & Bev | 2010-02-06 00:00:00
Area 1 | Food & Bev | 2010-02-06 00:00:00
Area 1 | Food & Bev | 2010-02-06 00:00:00
Area 1 | Stores | 2009-11-07 00:00:00
Area 1 | Stores | 2009-11-07 00:00:00
Area 1 | Stores | 2009-11-07 00:00:00
Area 1 | Stores | 2009-11-07 00:00:00
Area 1 | Stores | 2009-11-07 00:00:00
Area 1 | Stores | 2009-11-07 00:00:00
Area 1 | Stores | 2009-11-07 00:00:00
Area 1 | Stores | 2009-11-07 00:00:00
Area 1 | Stores | 2009-11-07 00:00:00
Area 1 | Stores | 2009-11-07 00:00:00
Area 1 | Stores | 2009-11-07 00:00:00
Area 1 | Stores | 2009-11-07 00:00:00
Area 1 | Stores | 2009-11-07 00:00:00
Area 1 | Stores | 2009-11-07 00:00:00
Area 1 | Stores | 2009-11-07 00:00:00
Area 1 | Stores | 2010-02-06 00:00:00
Area 1 | Stores | 2010-02-06 00:00:00
Area 1 | Stores | 2010-02-06 00:00:00
Area 1 | Stores | 2010-02-06 00:00:00
Area 1 | Stores | 2010-02-06 00:00:00
Area 1 | Stores | 2010-02-06 00:00:00
Area 1 | Stores | 2010-02-06 00:00:00
Area 1 | Stores | 2010-02-06 00:00:00
Area 1 | Stores | 2010-02-06 00:00:00
Area 1 | Stores | 2010-02-06 00:00:00
Area 1 | Stores | 2010-02-06 00:00:00
Area 1 | Stores | 2010-02-06 00:00:00
Area 1 | Stores | 2010-02-06 00:00:00
Area 1 | Stores | 2010-02-06 00:00:00
Area 1 | Stores | 2010-02-06 00:00:00
Area 2 | Food & Bev | 2010-02-06 00:00:00
Area 2 | Food & Bev | 2010-02-06 00:00:00
Spreadsheet: 702352d1604312725-creating-formula-to-compute-outstanding-with-tie-to-specific-accounts-saving-vs-expense
Sheet: Sheet1 (2)

Expense Account | Expense Acct OS | Saving Account | Saving Acct OS | Working
0 | 0 | 3468007124 | 1517154.5
0 | 0 | 3468007124 | 1517154.5
0 | 0 | 3468011598 | 6498224.73
0 | 0 | 3468024800 | 18600894.47
0 | 0 | 3468024819 | 9306381.2
0 | 0 | WONDA346PG | 374775.75
0 | 0 | WONDA346PG | 374775.75
0 | 0 | WONDA346LC | 0
0 | 0 | WONDA346LC | 0
0 | 0 | WONDA346BA | 66166000
0 | 0 | WONDA346BA | 66166000
4000000733 | 14557052.68 | 1733039065 | 0
4000000733 | 14557052.68 | WONDA346LC | 0
4000000733 | 14557052.68 | WONDA346IL | 0
4000000733 | 14557052.68 | WONDA346PG | 374775.75
4000000733 | 14557052.68 | WONDA346BA | 66166000
4000000733 | 14557052.68 | WONDA346SG | 0
4000000733 | 14557052.68 | WONDA346IL | 0
4000000733 | 14557052.68 | WONDA346IB | 0
4000000733 | 14557052.68 | WONDA346IB | 0
8000230852 | 24000000 | 3468011598 | 6498224.73
8000230852 | 24000000 | 3468007124 | 1517154.5
8000230852 | 24000000 | 3468011598 | 6498224.73
8000357341 | 12000000 | 3468024800 | 18600894.47
8000357342 | 12000000 | 3468024800 | 18600894.47
8000359476 | 11600000 | 3468024819 | 9306381.2
 |  | Total OS
Expense Account | Expense Acct OS | Saving Acct | Saving Acct OS | SA Portion to Cover Expense
8000359476 | 11600000 | 3468024819 | 9306381.2
8000357341 | 12000000 | 3468024800 | 18600894.47
8000357342 | 12000000
4000000733 | 14557052.68 | WONDA346PG | 374775.75
 |  | WONDA346BA | 66166000
8000230852 | 24000000 | 3468011598 | 6498224.73
 |  | 3468007124 | 1517154.5
Total
Spreadsheet: 216447d1361779658-find-data-betwwen-two-dates-find-data-between-2-dates-rev
Sheet: Sheet1

COL A | [NAME] | Start_date | End_date
1234 | DONE | 2012-01-01 00:00:00 | 2012-02-02 00:00:00
12344 | NOT | 2012-02-21 00:00:00 | 2012-02-21 00:00:00
34323 | DONE | 2012-03-15 00:00:00 | 2012-03-16 00:00:00
45678 | NOT | 2012-01-13 00:00:00 | 2012-01-15 00:00:00
67890 | DONE | 2012-04-22 00:00:00 | 2012-04-30 00:00:00
43434 | NOT | 2012-09-01 00:00:00 | 2012-09-01 00:00:00
99999 | DONE | 2013-02-01 00:00:00 | 2013-02-02 00:00:00
Spreadsheet: 53026d1252942541-excel-2007-excel-2007-reverse-the-expected-output-reverse-the-output
Sheet: Any no. of items

 |  | Reverse this process (Table 1)
 |  | Highest possible grade | 100 |  |  | # of Items | Grade | %
 |  | Lowest possible grade | 70 |  |  | 25 |  | 25
 |  | [NAME] | 75 |  | Raw Score | 20
 |  | Baseline | 0.5
 |  | Normal Process
 |  | G7 = Input Score (Shaded Part)
 |  | H7  =(D5-D6)*((G7/G6)^((LOG((D7-D6)/(D5-D6)))/LOG(D8)))+D6
 |  | I7 = H7*I6
 |  | G7 is the input data. H7 and I7 is based on G7
 |  | Highest possible grade | 100 |  |  | # of Items | Grade | % |  |  |  | Highest possible grade | 100 |  |  | # of Items | Grade | %
 |  | Lowest possible grade | 70 |  |  | 25 |  | 25 |  |  |  | Lowest possible grade | 70 |  |  | 25 |  | 25
 |  | [NAME] | 75 |  | Raw Score | 24 |  |  |  |  |  | [NAME] | 75 |  | Raw Score
 |  | Baseline | 0.5 |  |  |  |  |  |  |  |  | Baseline | 0.5
 |  | Expected Reverse Output
 |  | G7 = Based on H7 Result |  |  |  |  |  |  |  |  |  | I don’t know how to recreate the formula that would compute the value of Q7 and R7 based on the input data on S7 which is the reverse process of table 1.
 |  | H7  =(D5-D6)*((G7/G6)^((LOG((D7-D6)/(D5-D6)))/LOG(D8)))+D6 (Note: this should be based on the input percentage)
 |  | I7 = [NAME] (Shaded Part)
 |  | On this example I want to input the percentage get the value of H7 and G7.
Spreadsheet: 139037d1328044199-conditional-formating-values-multiple-columns-question-sample
Sheet: Sheet1

 |  | Silo 1
Date |  | Water Source | Temp in Celsius | Conversion to Fahrenheit | TDS | PH | Turb. | Taste /Odor
2012-01-02 00:00:00 |  | 90TDS | 19.9 | 67.82 | 89.9 | 7.06 | 0.13 | OK
2012-01-03 00:00:00 |  | 90TDS | 18.7 | 65.66 | 93.4 | 7.07 | 0.11 | OK
2012-01-04 00:00:00 |  | 90 TDS | 18.7 | 65.66 | 89.9 | 7.08 | 0.13 | OK
2012-01-05 00:00:00 |  | 90 TDS | 18.6 | 65.48 | 92.9 | 7.19 | 0.12 | OK
2012-01-06 00:00:00 |  | 90TDS | 19.7 | 67.46 | 88.5 | 6.93 | 0.15 | OK
2012-01-07 00:00:00 |  | 90 TDS | 20.5 | 68.9 | 93.1 | 7.02 | 0.13 | OK
2012-01-08 00:00:00 |  | 90TDS | 20 | 68 | 94.6 | 7.15 | 0.11 | OK
2012-01-09 00:00:00 |  | Blue | 20.4 | 68.72 | 130.22 | 7.29 | 0.14 | OK