tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 708399d1607783661-waybill-puzzle-max-weight-total-lbs-to-max-150-carry-over-remainder-and-repeat-waybill-puzzle_solver-hydr-_mod
Sheet: Solv_setup_Hydr

Item | Qty | Lbs | Total lbs | [NAME] lbs |  | What I want it to have my formulate produce as the end result
 |  |  |  | 150 |  | Waybill 1 | Waybill 2 | Waybill 3
Clear ziplock baggies | 1 | 40 |  |  |  | 0 | 1 | 0
baggies tie close | 2 | 40 |  |  |  | 0 | 1 | 1
cans | 2 | 17 |  |  |  | 2 | 0 | 0
Sterile water | 8 | 15 |  |  |  | 7 | 1 | 0
Swabs | 2 | 6 |  |  |  | 0 | 1 | 1
Spoons | 8 | 6 |  |  |  | 0 | 8 | 0
Straps | 3 | 3 |  |  |  | 3 | 0 | 0
dowels | 1 | 2 |  |  |  | 0 | 0 | 1
blister pacsk | 1 | 1 |  |  |  | 1 | 0 | 0
screens | 2 | 1 |  |  |  | 1 | 1 | 0
Straws | 1 | 0.5 |  |  |  | 0 | 0 | 1
 | Object f |  |  |  | Total lbs
 |  |  |  |  |  | =< | =< | =<
 |  |  |  |  |  | 150 | 150 | 150
 |  |  |  | or for equal results in the three waybills change G18 and H18 to 116 this will make G16=116, H16 =116 and I1=116,5
Spreadsheet: 173b64b5-894d-4f20-bd7a-7e77c49edd47
Sheet: Sheet1

2006 - 50th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: |  | Wassmunster, Belgium |  |  | 2006-09-09 00:00:00
Rank | Team Name | Pilot/Co-Pilot | Registration | Flight Time | Landing position | Distance (km) | Launch Time (UTC) | Landing Time (UTC) | Distance km
1 | BEL 3 | De Cock, [NAME]  [NAME], [NAME] | D-OCOX | 66:53 h | 69°44.244’ N 029°17.721’ E | 2449.6 | 2006-09-09 17h15 | 2006-09-12 12h08 | 2449.6
2 | GER 3 | Eimers, [NAME], Ullrich | D-OWBI | 66:00 h | 68°31.567’ N 028°03.250’ E | 2320.14 | 2006-09-09 17h32 | 2006-09-12 11h32 | 2320.14
3 | GBR 1 | Hempleman-Adams, [NAME], [NAME] | D-OWNT | 64:45 h | 67°25.600’ N 027°01.400’ E | 2204.382 | 2006-09-09 17h45 | 2006-09-12 09h30 | 2204.382
4 | CAN 1 | Francoeur, Danielle  Burman, Leo | D-OWML | 70:32 h | 62°22.0’ N 029°07.225’ E | 1951.811 | 2006-09-09 16h50 | 2006-09-12 15h22 | 1951.811
5 | USA 2 | MacNutt, [NAME], [NAME] | N801NM | 69:30 h | 62°02.035’ N 028°50.464’ E | 1921.666 | 2006-09-09 17h25 | 2006-09-12 14h55 | 1921.666
6 | AUT 1 | Stürzlinger, [NAME], [NAME] | D-ORZL | 84:05 h | 61°24.404’ N 029°09.483’ E | 1905.417 | 2006-09-09 17h08 | 2006-09-13 05h13 | 1905.417
7 | FRA 1 | Leÿs, [NAME], Sébastien | F-PPSE | 49:10 h | 66°47.948’ N 017°14.530’ E | 1889.894 | 2006-09-09 16h56 | 2006-09-11 18h06 | 1889.894
8 | BEL 1 | Siméons, Benoît  [NAME], [NAME] | D-OBYN | 47:56 h | 66°52.700’ N 015°52.334’ E | 1869.711 | 2006-09-09 16h54 | 2006-09-11 16h50 | 1869.711
9 | USA 1 | Fricke, [NAME], [NAME] | D-OPMB | 70:48 h | 61°34’830’ N 028°10,507’ E | 1867.308 | 2006-09-09 17h37 | 2006-09-12 16h25 | 1867.308
10 | GER 1 | Hora, [NAME]  Löschhorn, Volker | D-OWBA | 63:10 h | 63°34.445’ N 023°51.775’ E | 1808.143 | 2006-09-09 17h00 | 2006-09-12 08h10 | 1808.143
11 | SWI 2 | [NAME], [NAME], [NAME] | D-OCFT | 35:26 h | 62°30.300’ N 021°18.200’ E | 1632.743 | 2006-09-09 17h34 | 2006-09-11 05h00 | 1632.743
12 | GER 2 | [NAME], Heinrich  Huthmacher, [NAME] | D-OBCW | 46:03 h | 65°03.022’ N 012°30.259’ E | 1622.128 | 2006-09-09 17h17 | 2006-09-11 15h20 | 1622.128
13 | RUS 1 | Fuodoroff, Stanislaw  Grishin, Sergey | RA-O454G | 67:02 h | 61°32.899’ N 022°43.372’ E | 1621.182 | 2006-09-09 17h05 | 2006-09-12 12h07 | 1621.182
14 | BEL 2 | [NAME], Luc  Paenen, [NAME] | D-OOWS | 19:39 h | 54°14.535’ N 001°37.720’ W | 516.554 | 2006-09-09 17h29 | 2006-09-10 13h08 | 516.554
15 | SWI 1 | Stoll, [NAME], [NAME] | HB-QHP | 26:19 h | 54°27.700’ N 000°39.37’ W | 487.723 | 2006-09-09 17h11 | 2006-09-10 19h30 | 487.723
16 | USA 3 | Cayton, [NAME], [NAME] | N69RW |  | NO START | 0 |  | NO START | 0
17 | SWI 3 | Frieden, Kurt  Zeberli, Stefan | HB-QHJ | 73:02 h | 63°59.263’ N 028°36.082’ E disqualified Rule 6.3/6.4 | 0 | 2006-09-09 17h20 | 2006-09-12 18h22 | 0
Spreadsheet: 857077d1706155873-calculating-data-from-multiple-sheets-manually-calculated-example
Sheet: Consolidated

 | Pro Forma Summary
 |  |  |  |  | Pro Forma
 |  |  |  |  |  | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033
 |  |  |  |  |  | 1
 |  |  |  |  |  | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma
 | Revenue
 | [NAME]
 | Gross Profit
 | Operating Expenses
 | NOI
 | Management Fee Allocation |  | 0.05
 | EBITDA
 | [NAME] |  | 0.015
 | DCF (Unlevered)
Spreadsheet: 738879d1625310059-autofill-fetch-column-values-and-row-headers-from-other-sheets-autofill
Sheet: Courses

Course Code | Course Name | Total Marks | Credit Hours
CC 1 | Course 1 | 60 | 3
CC 2 | Course B | 60 | 3
CC 3 | Course 3 | 60 | 3
CC 4 | Course XX | 60 | 3
Spreadsheet: 0776ff51-127c-47bd-a67d-12c9f762416f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Center for Student Support and Education Options
Office of Quality School Choice and Funding
SF-6
School-Age Attachment One
To be used only for those students with EMIS status codes IT, 1C, 1P or 1W and
who were included on the SF-14H Form
To be filed by educating district (3323.14 [NAME]) for school year 2011-2012
A. |  |  |  |  |  |  |  |  | IRN
 | Educating District - City, Exempted Village or Local
B. |  |  |  |  |  |  |  |  | IRN
 | Resident District - City, Exempted Village or Local
 |  |  |  |  | Disability |  | EMIS Status |  | Dates of
SSID |  |  |  | Grade | Category |  | Code |  | Enrollment |  | *Total
Number |  |  |  |  | as reported |  | as reported |  |  |  | Days
 |  |  |  |  | on the SF-14H |  | on the SF-14H |  | From | To | Enrolled
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
*A full membership school year is 180 days.
Spreadsheet: 161353d1339506994-help-with-if-or-and-formula-excel-forum-1-
Sheet: Sheet1

1 | A | 9 | H |  |  |  |  |  |  |  |  |  |  |  |  | 1
3 | B | 8 | G |  |  |  |  |  |  |  |  |  |  |  |  | 2
7 | C | 7 | C |  |  |  |  |  |  |  |  |  |  |  |  | 3
3 | D | 7 | F |  |  |  |  |  |  |  |  |  |  |  |  | 4
4 | E | 4 | E |  |  |  |  |  |  |  |  |  |  |  |  | 5
7 | F | 3 | B |  |  |  |  |  |  |  |  |  |  |  |  | 6
8 | G | 3 | D |  |  |  |  |  |  |  |  |  |  |  |  | 7
9 | H | 3 | I |  |  |  |  |  |  |  |  |  |  |  |  | 8
3 | I | 2 | J |  |  |  |  |  |  |  |  |  |  |  |  | 9
2 | J | 1 | A |  |  |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 812741d1673354821-production-shortages-excel-test-
Sheet: Day 7 Question

Date | Region | Builder | Units | Revenue ($k)
2008-01-06 00:00:00 | Central | Doug | 8 | 3112
2008-02-09 00:00:00 | East | [NAME] | 10 | 3850
2008-03-15 00:00:00 | North | [NAME] | 3 | 2313
2008-04-18 00:00:00 | South | [NAME] | 5 | 1565
2008-05-05 00:00:00 | West | [NAME] | 10 | 5740
2008-05-22 00:00:00 | Central | [NAME] | 8 | 5840
 |  | Total
What is the Total Units & Revenue for each of the Builders?
 |  |  | Units | Revenue ($k)
 | Total | Doug
 | Total | [NAME]
 | Total | [NAME]
 | Total | [NAME]
What is the Total Units & Revenue for each of the Builders for "Central" Region?
 | Central |  | Units | Revenue ($k)
 | Total | Doug
 | Total | [NAME]
 | Total | [NAME]
 | Total | [NAME]
Spreadsheet: 51837d1251440753-vba-function-doesnt-work-properly-ratemacro
Sheet: Sheet1

MOVEMENT AREA | TAKA
BOGRA | 3600
BOGRA | 3600
BOGRA | 3700
COX'S BAZAR | 9200
COX'S BAZAR | 9200
BOGRA | 9200
BOGRA | 4200
KONABARI | 4200
RANGPUR | 4200
KONABARI | 4200
KONABARI | 4200
KONABARI | 4200
KONABARI | 4200
KONABARI | 4600
KONABARI | 4600
DINAJPUR | 4600
DINAJPUR | 4600
DINAJPUR | 4800
KONABARI | 4800
KONABARI | 4800
KONABARI | 4800
KONABARI | 4800
CHITTAGONG | 4800
CHITTAGONG | 4800
PABNA | 5200
TANGAIL | 5200
KUSHTIA | 1300
KUSHTIA | 1300
KUSHTIA | 1600
M. BAZAR | 7200
PABNA | 3600
TANGAIL | 4600
Spreadsheet: 713264d1610625935-certain-words-in-a-cell-determine-which-column-is-meant-example2
Sheet: Sheet1

 | Price | TP | SL |  | Shares | Exit | PnL
L | 17 | 19 | 16 |  | 5 | SL
S | 8 | 7 | 9 |  | 10 | TP
L | 135 | 175 | 120 |  | 2 | TP
 |  |  |  |  |  |  |  |  | If there is the letter "L" in column A it should calculate like right now (x-y)*z with the column G and all the rest like I asked you before. Thats wonderful.
 |  |  |  |  |  |  |  |  | But if there is the letter "S" in column A, I want it to calculate (y-x)*z, but again included with the formula you mentioned before which works perfectly in column H.
Spreadsheet: a96a63c9-45c1-453e-923e-9c036dceb8a6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME | PROGRAM
4498 | 10412 | [NAME] | Beven | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:51:36 | Elite Men
4498 | 10414 | [NAME] | Fattori | FRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:51:47 | Elite Men
4498 | 10057 | Markus | [NAME] | SUI | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 01:53:39 | Elite Men
4497 | 10228 | [NAME] | Rose | NZL | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:06:55 | Elite Women
4497 | 10165 | Isabelle | [NAME] | FRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | [NAME] | Elite Women
4497 | 6515 | [NAME] | Laurence | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:11:43 | Elite Women
Spreadsheet: jane_tholt__13264__ExpansionSummary 10-11-01
Sheet: Storage

[NAME]
Sponsor | Name | Receipt Region | Storage City | Initial Storage Quantity (BCF) | Storage Quantity Increase | Final Storage Q | Initial Withdrawal Quantity (MMcf/d) | Withdrawal Quantity Increase (MMCF/d) | Final Withdrawal Quantity | Initial Injection Quantity | Injection Quantity Increase (MMCF/d) | Final Injection Quantity | In Service | Term | STATUS | COMMENTS
Alberta Energy (AEC) | [NAME] | Northern California | Gridley, CA | 14 | 15 bcf | 29 | 200 | 500 | 700 | 80 | 370 | 450 | 2004-04-01 00:00:00 | 2 - 30 years | Open Season closed 5/22/01.  CPUC Application Filed | Current capacity is 14BCF.  Current withdrawal is 200 mmcf/d.  Current injection is 80 mmcf/d. If regulatory approval is expedited, could be in service as early as 2003.
Western Hub Properties | Lodi | Northern California | Sacramento, CA | 0 | 12 | 12 | 0 | 500 | 500 | 0 | 300 | 400 | 2001-12-01 00:00:00 |  | Announced.  Received special regulatory approval relief from Gov. [NAME].  As of 10/9/01 awaiting tariff approval from CPUC. | Will be used to store gas for new and existing power plants in California.  Calpine singed a 10 yar deal to take up to 4 bcf of gas.  Facility will ultimately have 12 bcf of capacity, which will come on-line about three months after the first 9.  Will be able to cycle gas up to six times a year.  [NAME] is in the process of acquiring Western Hub.  Facility will provide service directly to PG&E Line 401.  See http://www.cpuc.ca.gov/Environment/info/lodi-gas.htm.  On 10/9/01 I spoke with [NAME] ([PHONE]).  He told me the following: 1) They will have a Nov 1, 2001 start date for the first 9 bcf of capacity; they will have an April 1, 2002 start date for the subsequent 3 bcf of capacity.  November 1 will have a 300 MM injection and withdrawal quantity.  April 1 will have a 400 MM injection and 500 MM withdrawal quantity.  The are currently (as of October 9, 2001) injecting pad gas.  On 10/12/01, NGI published an article contradicting O'Tool's Nov 1, 2001 start date.  Now, [NAME], in-state manager for Western Hub, predicts a start date of Dec. 1, 2001.
AES | Colorado Gas Storage | Colorado | Denver, CO |  | 9 bcf | 9 |  |  |  |  |  |  | 2002-11-01 00:00:00 |  | Approval received from Colorado Oil and Gas Conservation Commission, the Colorado PUC, and Adams County, CO officials. | Will have ability to cycle working gas more than 2x per year.  Interconnect with CIG is in progress.  Future connection with [NAME] is under consideration.
SoCal | La Goleta | Southern California | Santa Barbara, CA |  |  |  |  |  |  |  |  |  |  |  |  | Proposed removal of 7 bcf of base gas for sale into market.  No impact on working gas capacity in field
SoCal | Aliso Canyon | Southern California | Los Angeles County |  |  |  |  |  |  |  |  |  |  |  |  | Proposed removal of 7 bcf of base gas for sale into market.  No impact on working gas capacity in field
CIG | [NAME] |  |  |  |  |  |  | 102
Spreadsheet: 732949d1621334883-highlight-duplicate-text-in-multiple-columns-p_tracker
Sheet: Tata_Digital_India_Fund_Direct_

Infosys Ltd
Tata Consultancy Services Ltd
HCL Technologies Ltd Shs Dematerialised
Tech Mahindra Ltd
Persistent Systems Ltd
Wipro Ltd
[NAME] (India) Ltd
MindTree Ltd
Cyient Ltd
Birlasoft Ltd
L&T Technology Services Ltd
Larsen & Toubro Infotech Ltd
Mphasis Ltd
Tata Elxsi Ltd
Indian Railway Catering And Tourism Corp Ltd
KPIT Technologies Ltd
IndiaMART InterMESH Ltd
Firstsource Solutions Ltd
Just Dial Ltd
RailTel Corporation of India Ltd
Sonata Software Ltd
Amazon.com Inc
Global X Cybersecurity ETF
Microsoft Corp
Honeywell Automation India Ltd
Oracle Financial Services Software Ltd
eClerx Services Ltd
Tata Communications Ltd
Matrimony.com Ltd
Alphabet Inc A
Nazara Technologies Ltd
Spreadsheet: 783917d1655298897-sumifs-on-counting-dot-lines-forum_ex
Sheet: Airlocks

Descritption | Material Number | EXCEL [NAME] | Prod_Type | Prod_Cat. | Time Saved | Number w/0 dotline | Number with Dotline | Time Saved (W/o) | Time Save With
MD20 SS Housings | V353378.B01 | HSG,MD20,MACH,304 | HOUSING | MD | 6 |  |  |  |  |  | Date Range
MD20 GI Housings India | V353377.B01 | HSG,MD20,MACH,GI | HOUSING | MD | 3 |  |  |  |  |  | 2022-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2022-12-31 00:00:00
Spreadsheet: 125352d1318975823-problem-using-conditional-formatting-to-flag-cells-by-color-and-count-them-example4
Sheet: Alindada

PT. # | LAST NAME | FIRST NAME | REQUIRED | IN DATE | COM DATE | NOTES |  |  | VISIT DATE
76925 |  |  | ATT | 2011-04-27 00:00:00 | 2011-05-16 00:00:00 | GOOD | Total # Yellow: | 0
80339 |  |  | DS [NAME] | 2011-05-14 00:00:00 | 2011-08-31 00:00:00 | DELIQUENT | Total # Orange: | 0
77195 |  |  | ATT | 2011-07-29 00:00:00 | 2011-08-31 00:00:00 | DELIQUENT | Total # Red: | 0 | should be 2
50085 |  |  | D/C Sum Sig | 2011-09-14 00:00:00 | 2011-10-11 00:00:00 | GOOD | Complient: | 0 | should be 4
81066 |  |  | DO | 2011-09-17 00:00:00 | 2011-10-11 00:00:00 | GOOD | All Total: | 0 | should be 6
55945 |  |  | D/C Sig | 2011-09-20 00:00:00 | 2011-10-11 00:00:00 | GOOD
 |  |  |  |  |  | In order to properly access | How do I get the spreadsheet to reflect this?
 |  |  |  |  |  | the progress of the providers
 |  |  |  |  |  | I need to flag the charts
 |  |  |  |  |  | that are completed after 30 days
 |  |  |  |  |  | RED. So the cell F3 would be red |  | Charts that are not complete
 |  |  |  |  |  | and therefore deliquent |  | after 30 days are deliquent
 |  |  |  |  |  | as would cell F4. All other cells
 |  |  |  |  |  | are good to go =) How can
 |  |  |  |  |  | I flag these cells that are
 |  |  |  |  |  | Deliquent as red?
Spreadsheet: 750010d1633167038-sum-up-some-numbers-based-on-column-criteria-to-produce-an-output-rom-aligw
Sheet: Sheet2

 |  |  |  |  |  |  |  |  | AliGW
 |  |  |  |  |  |  |  |  | Step 1 | Step 2
 |  |  |  |  | 0.053
 |  |  |  |  | 0.081
 |  |  |  |  | 0.102
 |  |  |  |  | 0.203
 |  |  |  |  | 0.263
 |  |  |  |  | 0.141
Spreadsheet: 850620d1701017175-counting-number-of-complaints-cases-etc-per-employee-example-workbook
Sheet: Complaint

Case Recorded | Case Reference | Employee ID
02/04/2020 | CO/00012/20 | 0
03/04/2020 | CO/00055/20 | 6756
03/04/2020 | CO/00055/20 | 6756
03/04/2020 | CO/00055/20 | 9876
03/04/2020 | CO/00029/20 | 2131
03/04/2020 | CO/00029/20 | 3143
2020-03-03 00:00:00 | CO/00236/20 | 7895
2020-03-03 00:00:00 | CO/00236/20 | 3123
2020-03-03 00:00:00 | CO/00236/20 | 5678
2020-04-23 00:00:00 | CO/00026/20 | 5678
2020-04-23 00:00:00 | CO/00026/20 | 21312
03/04/2020 | CO/00039/20 | 6756
2020-04-23 00:00:00 | CO/00026/20 | 3213
2020-04-23 00:00:00 | CO/0002320 | 423
2020-04-23 00:00:00 | CO/00023/20 | 432
03/04/2020 | [NAME] | 2342
2020-04-23 00:00:00 | CO/00027/20 | 2423
Spreadsheet: 120851d1315583477-question-on-list-box-that-changes-data-in-all-boxes-that-have-certain-text-space
Sheet: Sheet1

Pages to X-bytes
 | Free Page Count | 4915028
 | [NAME] (from pagepool show) | 4096
 | Block Size
 | Megabytes
 | Gigabytes
 | Terabytes |  |  | (In CLI hold down alt, copy the Total Block Count column and paste here)
 |  |  |  |  | (In CLI hold down alt, copy the Unallocated Block Count column and paste here)
 |  |  |  |  |  | Is this a spare? | Yes | If so, choose Yes.  If not, leave blank.
Disk Blocks to X-bytes |  |  |  |  |  |  |  | No | Select All Spares?
 | Total Block Count |  |  | 879097968 | 548468304
 | Unallocated Block Count |  |  | 879097968 | 548468304
 | Adjusted Unallocated Block Count |  |  | 879097968 | 548075088
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304 |  |  |  |  |  |  |  |  | Random:
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304 |  |  |  |  |  |  |  |  | IF(ISBLANK(E12:F12),"")))
 |  |  |  | 879097968 | 879097936 |  |  |  |  |  |  |  |  | IF(E12-F12<=100,"Is this a spare?","")
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548075088
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 879097936
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548075088
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 879097936
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548075088
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 879097936
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 879097968 | 548468304
 |  |  |  | 3907029168 | 75426960
 |  |  |  | 3907029168 | 75426960
 |  |  |  | 3907029168 | 75426960
 |  |  |  | 3907029168 | 75426960
 |  |  |  | 3907029168 | 75426960
 |  |  |  | 3907029168 | 75426960
 |  |  |  | 3907029168 | 75033744
 |  |  |  | 3907029168 | 75426960
 |  |  |  | 3907029168 | 75426960
 |  |  |  | 3907029168 | 75426960
 |  |  |  | 3907029168 | 3907029136
 |  |  |  | 390721968 | 4496
 |  |  |  | 390721968 | 397712
 |  |  |  | 390721968 | 390721936
Spreadsheet: 153147d1335787236-how-to-get-the-total-number-of-days-of-each-person-per-week-book2
Sheet: Sheet1

Person | Date | Days | Week
[NAME] | 2012-01-02 00:00:00 | 7.5 |  |  |  |  |  | Sum of Days | Column Labels
[NAME] | 2012-01-02 00:00:00 | 4 |  |  |  |  |  | Row Labels | 1 | 2 | 3 | 4 | Grand Total
[NAME] | 2012-01-02 00:00:00 | 1.5 |  |  |  |  |  | [NAME] | 13 | 2.5 | 5.5 | 2 | 23
Rachel | 2012-01-02 00:00:00 | 0.5 |  |  |  |  |  | [NAME] | 14 | 3.5 | 14.5 | 1.5 | 33.5
[NAME] | 2012-01-02 00:00:00 | 0.5 |  |  |  |  |  | [NAME] | 21 | 10 | 4.5 | 5.5 | 41
Phoebe | 2012-01-02 00:00:00 | 1 |  |  |  |  |  | Phoebe | 11 | 9 | 4.5 | 1 | 25.5
[NAME] | 2012-01-03 00:00:00 | 1 |  |  |  |  |  | Rachel | 17.5 | 2.5 | 9.5 | 3.5 | 33
[NAME] | 2012-01-03 00:00:00 | 3 |  |  |  |  |  | [NAME] | 18 | 4 | 2 | 6 | 30
[NAME] | 2012-01-03 00:00:00 | 1 |  |  |  |  |  | Grand Total | 94.5 | 31.5 | 40.5 | 19.5 | 186
Rachel | 2012-01-03 00:00:00 | 7.5
[NAME] | 2012-01-03 00:00:00 | 4
Phoebe | 2012-01-03 00:00:00 | 1
[NAME] | 2012-01-04 00:00:00 | 0.5
[NAME] | 2012-01-04 00:00:00 | 0.5
[NAME] | 2012-01-04 00:00:00 | 1.5
Rachel | 2012-01-04 00:00:00 | 7.5
[NAME] | 2012-01-04 00:00:00 | 5
Phoebe | 2012-01-04 00:00:00 | 0.5
[NAME] | 2012-01-05 00:00:00 | 5.5
[NAME] | 2012-01-05 00:00:00 | 8.5
[NAME] | 2012-01-05 00:00:00 | 6
Rachel | 2012-01-05 00:00:00 | 1
[NAME] | 2012-01-05 00:00:00 | 4
Phoebe | 2012-01-05 00:00:00 | 1
[NAME] | 2012-01-06 00:00:00 | 6.5
[NAME] | 2012-01-06 00:00:00 | 2
[NAME] | 2012-01-06 00:00:00 | 3
Rachel | 2012-01-06 00:00:00 | 1
[NAME] | 2012-01-06 00:00:00 | 0.5
Phoebe | 2012-01-06 00:00:00 | 7.5
[NAME] | 2012-01-09 00:00:00 | 6
[NAME] | 2012-01-09 00:00:00 | 0.5
[NAME] | 2012-01-09 00:00:00 | 1.5
Rachel | 2012-01-09 00:00:00 | 1
[NAME] | 2012-01-09 00:00:00 | 1.5
Phoebe | 2012-01-09 00:00:00 | 1.5
[NAME] | 2012-01-10 00:00:00 | 4
[NAME] | 2012-01-10 00:00:00 | 3.5
[NAME] | 2012-01-10 00:00:00 | 1
Rachel | 2012-01-10 00:00:00 | 1.5
[NAME] | 2012-01-10 00:00:00 | 2
Phoebe | 2012-01-10 00:00:00 | 7.5
[NAME] | 2012-01-18 00:00:00 | 1.5
[NAME] | 2012-01-18 00:00:00 | 1
[NAME] | 2012-01-18 00:00:00 | 1.5
Rachel | 2012-01-18 00:00:00 | 2
[NAME] | 2012-01-18 00:00:00 | 7.5
Phoebe | 2012-01-18 00:00:00 | 1.5
[NAME] | 2012-01-20 00:00:00 | 3
[NAME] | 2012-01-20 00:00:00 | 1
[NAME] | 2012-01-20 00:00:00 | 4
Rachel | 2012-01-20 00:00:00 | 7.5
[NAME] | 2012-01-20 00:00:00 | 7
Phoebe | 2012-01-20 00:00:00 | 3
[NAME] | 2012-01-24 00:00:00 | 5.5
[NAME] | 2012-01-24 00:00:00 | 6
[NAME] | 2012-01-24 00:00:00 | 2
Rachel | 2012-01-24 00:00:00 | 3.5
[NAME] | 2012-01-27 00:00:00 | 1.5
Phoebe | 2012-01-27 00:00:00 | 1
Spreadsheet: 719189d1613552507-heatmap-color-scaling-color-cell-based-on-cell-value-heatmap-sample
Sheet: Data

 | VIEWS | UNITS
01-001-A | 3 | 3
01-002-A | 14 | 14
01-003-A | 152 | 156
01-005-A | 7 | 7
01-006-A | 108 | 121
01-007-A | 3 | 3
01-008-A | 9 | 15
01-010-A | 37 | 43
01-011-A | 38 | 67
01-012-A | 33 | 39
01-013-A | 26 | 31
01-014-A | 4 | 4
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 47

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
47 | 2007-02-16 00:00:00 | 7.8 | 0.67 | 4 | 1.6 | 1.8 | 3.2 |  |  |  | 2.5 |  | 1.52127765851133 | 1.3 | 0 | 8 |  |  |  |  | 0.5
Well #47 | 2013-10-11 00:00:00 | 5.3 | 0.82 | 4.15 | 1.71 | 1.8 | <0.1 |  |  | 4.9 | 2.7 |  | 1 | 0.6 | 0.04 | 4.5 |  | <0.10 | <0.02 |  | -3.5
Well - 47 | 2014-02-05 00:00:00 | 8.1 | 1.53 | 8.09 | 3.3 | 2.6 | 4.6 |  |  | 0.8 | 9.4 |  | 1.1 | 2.7 | 0.04 | 7.1 |  | <0.10 | <0.02 |  | 0.9
Well 47 | 2015-04-02 00:00:00 | 7.7 | 1.57 | 8.71 | 3.64 | 2.8 | 4.8 |  |  | 0.9 | 9.3 |  | 1.1 | 2.9 | <0.05 | 6.9 |  | <0.10 | <0.02 |  | 0.9
Well 47 | 2016-04-04 00:00:00 | 7.9 | 1.572 | 10 | 4.05 | 3.21 | 4.649908080888818 | 4.649908080888818 | 0 | 0.9560000000000001 | 9.7585 | 1004.8 | 1.21 | 2.95 | 0.035 | 7.211069999999999 | 0.033 | 0.072 | 0.002 | 0.022
Well 47 | 2017-05-03 00:00:00 | 7.75 | 0.688 | 4.51 | 1.71 | 1.43 | 2.166093837423068 | 2.166093837423068 | 0 | 0.415 | 4.8528 | 440 | 0.81 | 1.49 | 0.02 | 2.9779 | 0 | 0.638 | 0.011 | 0.021
W47 | 2018-05-29 00:00:00 | 7.86 | 0.978 | 5.71 | 2.3 | 2.65 |  | 3.221165374470466 | 0 | 2.29 | 4.671 | 625.92 |  |  | 0.179 | 5.5 | 0.029 | 0.079 | 0.041 | 0.003
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments: alk low 2013
Spreadsheet: 781194d1653053781-need-help-with-pulling-data-from-one-sheet-to-another-using-index-requiredtraining2022-test
Sheet: Records

[NAME] | SuperID | FullName | SuperName | MgrName | Class1 | Class2
003 | 029 | Employee, Mister | Supervisor, [NAME] | Manager, [NAME] | 2021-01-01 00:00:00 | 2021-02-01 00:00:00
004 | 302 | Employee, [NAME] | Supervisor, [NAME] | Manager, [NAME] | 2021-02-01 00:00:00 | 2021-03-01 00:00:00
012 | 472 | Employee, Junior | Supervisor, [NAME] | Manager, [NAME] | 2021-03-01 00:00:00 | 2021-04-01 00:00:00