tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 08f8befe-b461-4c72-ae2f-0b8b1822212e
Sheet: T19

الجدول 19: السكان في السعودية بحسب [NAME] تعداد 2004
Table 19: Population of Saudi Arabia by age groups, 2004 census
 | Nationals | المواطنون | Non-nationals | [NAME] | Urban | حضر | Rural | ريف | Total | المجموع | المجموع
[NAME] | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | [NAME]
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | 1066010 | 1054525 | 223381 | 215747 | … | … | … | … | 1289391 | 1270272 | 2559663
5-9 | 1127253 | 1112582 | 207007 | 197901 | … | … | … | … | 1334260 | 1310483 | 2644743
10-14 | 1081884 | 1155728 | 176568 | 167659 | … | … | … | … | 1258452 | 1323387 | 2581839
15-19 | 948707 | 938982 | 150298 | 142200 | … | … | … | … | 1099005 | 1081182 | 2180187
20-24 | 760146 | 786510 | 298251 | 159920 | … | … | … | … | 1058397 | 946430 | 2004827
25-29 | 725413 | 701326 | 626706 | 240156 | … | … | … | … | 1352119 | 941482 | 2293601
30-34 | 569152 | 575126 | 709730 | 271093 | … | … | … | … | 1278882 | 846219 | 2125101
35-39 | 492543 | 498170 | 674734 | 190103 | … | … | … | … | 1167277 | 688273 | 1855550
40-44 | 411890 | 372981 | 511983 | 121907 | … | … | … | … | 923873 | 494888 | 1418761
45-49 | 313340 | 277511 | 338148 | 72775 | … | … | … | … | 651488 | 350286 | 1001774
50-54 | 222166 | 199415 | 193133 | 43516 | … | … | … | … | 415299 | 242931 | 658230
55-59 | 146079 | 153194 | 84880 | 21644 | … | … | … | … | 230959 | 174838 | 405797
60-64 | 126594 | 134390 | 39555 | 14973 | … | … | … | … | 166149 | 149363 | 315512
65-69 | 103245 | 101213 | 16678 | 7846 | … | … | … | … | 119923 | 109059 | 228982
70-74 | 77277 | 84898 | 9837 | 6381 | … | … | … | … | 87114 | 91279 | 178393
75+ | 115671 | 93419 | 8981 | 7231 | … | … | … | … | 124652 | 100650 | 225302
غير محدد    Not stated | … | … | … | … | … | … | … | … | … | … | …
المجموع    Total | 8287370 | 8239970 | 4269870 | 1881052 | … | … | … | … | 12557240 | 10121022 | 22678262
Spreadsheet: 119362d1314351154-unique-count-book1_carlscott-
Sheet: Sheet1

Column A | Column B
A | Red | Red | A | A | A1
A | Red | Green | B | B | B2
B | Green | Lime | B | C | [NAME]
B | Lime | Yellow | C
C | Yellow | white | C
C | Yellow | Black | C
C | white
C | Black
Spreadsheet: 803800d1667718677-unique-count-of-number-of-weeks-worked-per-month-excel-problem-number-of-shows-in-a-month-365-aligw
Sheet: Sheet1

 | Job | Show | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 9 | 9
 | Job 1 | A | 2 | 3 | 4 | 1 | 2 | 3
 | Job 2 | A |  |  |  | 1 | 2 | 4 | 1 | 2 | 3 | 4 | 1
 | Job 1 | B |  |  |  | 1 | 1 | 1 | 1
 | Job 2 | B |  |  |  |  |  | 1 | 2 | 2 | 2
 | Job 1 | C | 1 | 1 | 2
 | Job 2 | C |  |  | 1 | 1 | 1
 | Total Shows |  | 2 | 2 | 2 | 3 | 3 | 2 | 2 | 2 | 2 | 1 | 1
 | MS365
Spreadsheet: 77122d1277587321-does-this-require-vlookup-service-dispatch-w-tabs
Sheet: WARR JOBS

A Customer | RO | Tech | Date |  |  |  |  | Reason for Hold
WURGLER | 66811 | AC | 6/25/201010:04 AM
DRONSO | 66312 | BS | 6/18/20103:27 PM
SALES DEPT | 67047 | BS | 6/22/20104:55 PM
HAASCH | 67084 | DA | 6/24/20101:45 PM
[NAME] | 66732 | DB | 6/19/20103:45 PM
SLOMINSKI | 65853 | DH | 6/22/20109:12 AM
AVELLO | 67052 | DH | 6/24/20103:26 PM
GLOGOWSKI | 67083 | DH | 6/24/20104:31 PM
LONG | 66931 | JZ | 6/16/201010:02 AM
WARNER | 66837 | RA | 6/12/20108:22 AM
COERPER | 67078 | RA | 6/24/201010:36 AM |  |  | TECH | WARR | RANK | NEXT UP:
PETRI | 67033 | RG | 6/22/201011:16 AM |  |  | BF | 0 | 3 | ROB
SEDER | 67080 | RG | 6/25/201010:14 AM |  |  | BS | 2 | 8 | TF
MASCH | 66907 | TP | 6/15/20102:52 PM |  |  | DH | 3 | 9 | BF
SALZMAN | 66900 | TP | 6/15/20105:13 PM |  |  | JZ | 1 | 4 | JZ
 |  |  |  |  |  | RA | 2 | 7 | TP
 |  |  |  |  |  | RG | 2 | 6 | RG
 |  |  |  |  |  | TF | 0 | 2 | RA
 |  |  |  |  |  | TP | 2 | 5 | BS
 |  |  |  |  |  | ROB | 0 | 1 | DH
Spreadsheet: 112613d1308683327-need-help-to-consolidate-and-print-from-multiple-sheets-df-pullsheet
Sheet: UTILITY & BUTLER

UTILITY ITEMS | ✓
Incendiary Equipment
cassette stove | 6 |  | Type: |  | BOH
cassette fuel | 18 |  |  |  | FOH
electric cassette stove |  |  |  |  | Black (Wok)
wooden stove covers |  |  |  |  | VIP
electric wok
toaster
plate warmer
kitchen chafer, ss STERNO
7 oz. sterno (72/case) HOTBOX?
2 oz. sterno
firestar 3 oz. (3/box)
gel fuel bottle
denatured alcohol
General [NAME] |  | Basic Lexan Qty: |  | 1 | only use this for a basic utility lexans
paper towel | 2
3-ply bev naps | 200
Oil-Dri oil absorbant | 1
dish soap | 1
glass cleaner | 1
red duct tape | 1
black gaff tape | 1
extension cord | 2
click lighter | 3
matches | 1
first aid kit | 1
paper cone cups - staff pack | 2
ashtray | 5
[NAME]
fish weights
[NAME]'s towel, white
[NAME]'s towel, black
dinner chime w/ mallet
fruit cutter
Corinthian dish soap and towels
Butler Service
[NAME]'s tray |  |  | Type: |  | Swirl
9" square tray, sp |  |  |  |  | Black Insert
8x12" or 9x13" tray |  |  |  |  | 12" Flat
black [NAME], WITH RIM |  |  |  |  | 9" Pewter
black [NAME], NO RIM
platter, hors d'oeuvre
platter bowl
4" revere bowl
platter, asian style hors d'oeuvre
platter bowl, asian style (white)
black bowl, [NAME]'s special
black tray, [NAME]'s special
porcelain celadon spoons
black lucite cone holder
clear lucite cone holders (painter's pallet)
cornet set (with white 10" square)
Spreadsheet: bill_rapp__1367__USGT nov&dec01 vols&rates B
Sheet: Sheet1

USGT NOV/DEC 2001 DAILY VOLUMES/RATES
CONTRACT 27161
 |  | Total Scheduled Deliveries |  | Scheduled Deliveries @ Alternate Del Points |  | Commodity Rate for Deliveries @ Alternate Del Points |  | Scheduled Deliveries @ Primary Del Points |  | Commodity Rate for Deliveries @ Primary Del Points
2001-11-01 00:00:00 |  | 80846 |  | 0 |  |  |  |  |  | 0.0092
 |  | 97983 |  | 0 |  |  |  |  |  | 0.0092
 |  | 175867 |  | 0 |  |  |  |  |  | 0.0092
 |  | 176225 |  | 0 |  |  |  |  |  | 0.0092
 |  | 193781 |  | 0 |  |  |  |  |  | 0.0092
 |  | 81300 |  | 0 |  |  |  |  |  | 0.0092
 |  | 58569 |  | 0 |  |  |  |  |  | 0.0092
 |  | 181360 |  | 0 |  |  |  |  |  | 0.0092
 |  | 157700 |  | 0 |  |  |  |  |  | 0.0092
 |  | 153361 |  | 0 |  |  |  |  |  | 0.0092
 |  | 151273 |  | 0 |  |  |  |  |  | 0.0092
 |  | 149839 |  | 0 |  |  |  |  |  | 0.0092
 |  | 108830 |  | 0 |  |  |  |  |  | 0.0092
 |  | 186824 |  | 0 |  |  |  |  |  | 0.0092
 |  | 140845 |  | 0 |  |  |  |  |  | 0.0092
 |  | 77964 |  | 0 |  |  |  |  |  | 0.0092
 |  | 79061 |  | 360 |  | 0.0246 |  |  |  | 0.0092
 |  | 78796 |  | 7170 |  | 0.0246 |  |  |  | 0.0092
 |  | 77881 |  | 6255 |  | 0.0246 |  |  |  | 0.0092
 |  | 184707 |  | 40000 |  | 0.0246 |  |  |  | 0.0092
 |  | 111715 |  | 29979 |  | 0.0246 |  |  |  | 0.0092
 |  | 118217 |  | 0 |  |  |  |  |  | 0.0092
 |  | 118217 |  | 0 |  |  |  |  |  | 0.0092
 |  | 121616 |  | 0 |  |  |  |  |  | 0.0092
 |  | 125755 |  | 0 |  |  |  |  |  | 0.0092
 |  | 127537 |  | 0 |  |  |  |  |  | 0.0092
 |  | 128831 |  | 58839 |  | 0.0246 |  |  |  | 0.0092
 |  | 175460 |  | 131381 |  | 0.0246 |  |  |  | 0.0092
 |  | 162812 |  | 100000 |  | 0.0246 |  |  |  | 0.0092
 |  | 153482 |  | 141482 |  | 0.0246 |  |  |  | 0.0092
Total
2001-12-01 00:00:00 |  | 153115 |  | 100000 |  | 0.10959 |  |  |  | 0.0092
 |  | 114631 |  | 58308 |  | 0.1095899362008644 |  |  |  | 0.0092
 |  | 59796 |  | 0 |  |  |  |  |  | 0.0092
 |  | 55818 |  | 30629 |  | 0.04532991609259199 |  |  |  | 0.0092
Total
[NAME] in [NAME]
Reservation cost = $.025
Spreadsheet: 874872d1721380049-a-dv-list-that-pulls-information-from-a-second-sheet-populates-multiple-rows-agent-charges-example
Sheet: Costing Sheet

Customer |  |  | Date
Reference
Country
No. of Containers | 8
Agent / Shipping Line | L & S / M
Agent / Shipping Line | Description | Unit | Unit Cost | Amount
 |  | 1
Spreadsheet: 133512d1324444164-sumif-index-match-summary-help-sample
Sheet: Direct vs Indirect Detail

 |  |  |  | HAN | LIN | BAY | JCH |  |  |  | SI | NYCM
 |  | MTR
 |  | A.02.08 |  | 0 |  |  | 0
 |  | A.02 Other |  |  |  |  |  | 0
 |  | A.01.00's |  |  |  |  |  | 0
Spreadsheet: 775647d1649242888-sum-if-using-equals-greater-and-less-than-test-sheet-plants
Sheet: Oriental Lilies

 | Oriental Lilies | Per Bay
 |  | Oriental Lilies
 |  | 12 stems per tray
 |  | Based on 3 rounds per year
Sales | Units | Price | Quantity | Number of weeks | Total £ | % by 12 for value of 1 bay
Week 27 to 43 | Stems | 0.55 | 306000 | 17
Week 44 to 22 | Stems | 0.68 | 472000 | 31
Week 23 to 26 | Stems | 0.55 | 72000 | 4
Costs
Bulbs |  | 0.25
Labour | 850000 | 0.1243
NI + holidays
Sterilizing |  | 0.15
Repairs glasshouse |  |  |  |  | 5500
Heating |  |  |  |  | 36000
Electricity |  |  |  |  | 45000
Feed and Chems |  |  |  |  | 18000
Transport | stems | 0.03
Total costs excluding depreciation, Salaries
Sub total
Current Depreciation |  |  |  |  | 210444
Total including Depreciation, but not Salaries
Spreadsheet: 849392d1699896020-highlight-a-row-when-a-cell-is-a-specific-status-example
Sheet: Example

Name | Application received | Id Received | Status
[NAME] | Yes | Yes | Accepted
[NAME] | Yes | Yes | Accepted
[NAME] | Yes | No | Declined
[NAME] | Yes | Yes | Accepted
[NAME] | Yes | Yes | Not Yet Reviewed
Spreadsheet: 177617d1346362161-vlookup-range-based-on-cell-values-vlookup-range-start-end-point-example
Sheet: Sheet1

APPLES
Size | Count
2" | 5
3" | 6
4" | 3
Total Apples
ORANGES
Size | Count
2" | 4
3" | 3
4" | 3
Total Oranges
PEARS
Size | Count
2" | 7
3" | 7
4" | 2
Total Pears
Spreadsheet: louise_kitchen__23955__SepYTD Orig w notes sf
Sheet: North East Power

Northeast Power
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Power |  | Northeast Orig |  | 6163632
Wood |  | Power |  | Northeast Orig |  | 2309000
Hammond |  | Power |  | Northeast Orig |  | 552600
Ader |  | Power |  | Northeast Orig |  | 456000
[NAME] |  | Power |  | Northeast Orig |  | 125000
[NAME] |  | Power |  | Northeast Orig |  | 91819
Schener |  | Power |  | Northeast Orig |  | 50000
Wheeler |  | Power |  | Northeast Orig |  | 48800
Duran |  | Power |  | Northeast Orig |  | 15500
Total *
*  $150,000 related to Old Dominion(Dalton) is included in Midwest Power.
Spreadsheet: 513271bc-97be-4e2e-9ac5-16c0a4c00996
Sheet: E-STAX

[NAME] 2014
 | Online Book Views | Books Downloaded | Total Book Use
August | 3 | 11
September | 7 | 26
October
November
December
Total
Notes:
Live to Public on August 1, 2014.
Books can either be viewed online or downloaded.
Spreadsheet: elizabeth_sager__9520__California Mkt Receviables 040601
Sheet: Sheet1

California Market Receivables |  |  | As of April 6, 2001
 |  | Real-time Mrkt ONLY | Core Market | Core Market
 |  | IN DEFAULT | IN DEFAULT |  |  | IN DEFAULT | IN DEFAULT
 |  | PX | PX | PX |  | ISO | ISO | ISO | ISO |  | PX & ISO
 |  | November | December | January |  | November | December | January | February |  | Total
 | Total | 1221198.13 | 333417.38 | 7640660.88 |  | 6243319.84 | 41224221.79 | 10694136.7 | 4358562
 |  |  |  | Estimate |  |  |  |  | Estimate
SCE |  | 69492.41 | 333417 |  |  |  | 90693.29
PG&E |  | 1008410.97 |  |  |  | 4370.16 | 310006.15
SDG&E
Other |  | 143294.75 |  |  |  |  | 115015.58
[NAME] |  |  |  |  |  | 6238949.68 | 40708506.77
A/P |  | 0 | 0 | -17184.56 |  | 0 | 0 | 0 | 0
Net Exposure
[NAME]: |  | Issued December 14, 2000 |  | Reissued January 11, 2001 |  |  | Reissued January 18, 2001 |  | Reissued January 24, 2001
 |  | Expired January 10, 2001 |  | Expired January 17, 2001 |  |  | Expired January 23, 2001 |  | Expires February 7, 2001
Mandated Sales
(Stage 3 and DOE) |  | 0 | 0 | 0 |  | 0 | 7599600 | 10694136.7 | 4358562
Percentage |  | 0 |  | 0
Spreadsheet: 600186d1543511212-finding-differences-in-a-range-for-a-specific-groups-example1-4-ans
Sheet: Sheet1

Poland | -10 | 10
Poland | -10 | 10
Poland | 44 | 22 | It is much different than other values in B&C column
Croatia | 80 | 90
Croatia | 80 | 90
Germany | 30 | 66
Germany | 31 | 65
Germany | 31 | 66
Germany | 210 | 150 | It is much different than other values in B&C column
Germany | 31 | 66
<big database further on> | <big database further on> | <big database further on>
Spreadsheet: a1682703-39ba-472b-b3ca-7940fb423759
Sheet: Sheet1

Brewery | Beer | a.b.v
Black iris | Peregrine pale ale | 0.046
Blue Monkey | BG Sips | 0.04
Brampton | [NAME] | 0.038
Brampton | Wasp Nest | 0.05
Summer Wine | [NAME] | 0.04
Derby | Admirals Choice | 0.045
[NAME] | White Amarillo | 0.041
Grafters | Wobble Gob | 0.049
Grainstore | Rutland Panther | 0.034
Hadrian & Border | Reiver IPA | 0.044
Hopback | Taiphoon | 0.042
[NAME] | [NAME] | 0.05
Ilkley | [NAME] | 0.035
Ilkley | Black Summit | 0.05
Leeds | Best | 0.043
[NAME] | White Squall | 0.048
[NAME] | Bear Island | 0.046
Phoenix.. | Hopsack | 0.038
Phoenix.. | White Monk | 0.045
Purity | Mad Goose | 0.042
RCH | PG Steam | 0.039
Summer Wine | Diablo IPA | 0.06
Titanic | White Star | 0.048
Wold Top | Wold Gold | 0.048
York | Terrier | 0.042
Spreadsheet: 674868d1588060893-of-days-in-a-pay-period-based-on-qualifying-dates-book2
Sheet: PP

STATE | Qualifying Start Date | Qualifying End  Date |  | Pay Period 5 Start Date | Pay Period 5 End Date | How many qualifying days in Pay Period 5 for each state?
CA | 2020-03-19 00:00:00 | 2020-04-07 00:00:00 |  | 2020-03-23 00:00:00 | 2020-04-10 00:00:00 | ?
CO | 2020-03-23 00:00:00 | 2020-04-01 00:00:00 |  | 2020-03-23 00:00:00 | 2020-04-10 00:00:00 | ?
CT | 2020-03-24 00:00:00 | 2020-04-11 00:00:00 |  | 2020-03-23 00:00:00 | 2020-04-10 00:00:00 | ?
DC | 2020-04-01 00:00:00 | 2020-04-01 00:00:00 |  | 2020-03-23 00:00:00 | 2020-04-10 00:00:00 | ?
IL | 2020-03-22 00:00:00 | 2020-05-30 00:00:00 |  | 2020-03-23 00:00:00 | 2020-04-10 00:00:00 | ?
Spreadsheet: 694987d1599934263-sumproduct-formula-test-1-
Sheet: Points Summary

Players |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S1 Total Points | [NAME] 9 Points | [NAME]
a
Covid-20
DDStacks
Eastcoast007
Ethan14
FatStack
[NAME]
hayward13
Justaaz
KRoke
Lucky
Mary_G1
Sara
Spillie1
Sunshine23
Whip-it
b
c
d
e
f
g
h
i
j
k
l
m
n
Spreadsheet: mark_taylor__24752__EOL_Countries&Products_Status_01-12-01
Sheet: Cancelled Requests

 |  | CANCELLED PRODUCT REQUESTS |  |  |  | as of:
 | TRANSACTION  PRODUCTS
Date Changed | Commodity | Product | Country/Location | Business Unit | Business Unit  Contact | Process Manager | Responsibility |  |  | Scheduled for | Comments
2000-09-14 00:00:00 | Isobutane | Phy Index | US | Petchems |  | [NAME] | [NAME] | Cancelled | Cancelled | N/A | 08/31 Working on initial draft. 09/06 [NAME] in progress. 9/14 Cancelled
2000-09-22 00:00:00 | Nat-Gasoline | Phy Index | US | Petchems |  | [NAME] | [NAME] | Cancelled | Cancelled | TBD | 08/31 Working on initial draft.  9/22 Cancelled
2000-09-22 00:00:00 | Propane | Phy Index Purity | US | Petchems |  | [NAME] | [NAME] | Cancelled | Cancelled | TBD | 08/31 Working on initial draft. 09/06 [NAME] in progress. 9/22 Cancelled
2000-12-08 00:00:00 | Advertising  Blocks (Nielsen Ratings) | Advertisement Market | US | EBS | [NAME] | [NAME] | [NAME] | Cancelled | Cancelled | TBD | 08/23 EBS is reviewing legal issues. 09/07 Met with [NAME] (EBS) to discuss.  They will work on defining the products and then get back to us. 12/08 Cancelled-no action from requestor
2000-12-08 00:00:00 | Gas | Fin Options | US | Gas | [NAME] | [NAME] | [NAME] | Cancelled | Cancelled | TBD | 08/23 On hold due to Phase. II 9/22 Savita and Dale finalizing language for delivery to Legal. 10/20 Product description under review by [NAME] 11/03 Product is being developed in Test, circulated for comments from legal et al. 12/08 Trader advised that product is no longer required
2000-12-08 00:00:00 | Paper | Phy Paper OCC Ex-works | US | Pulp and Paper | [NAME] | [NAME] | [NAME] | Reviewing | Reviewing | TBD | 08/23 Desk is working on logistics and legal  issues. 9/28 16 created products for ClickPaper.com, awaiting set-up on EOL pending Commercial and Technical issues. 12/08 Cancelled because it is a click paper product
 | AUCTION PRODUCTS
# | Commodity | Product | Country/Location | Business Unit | Business Unit  Contact | Process Manager | Responsibility |  |  | Scheduled for | Comments
 | BUSINESS DEVELOPMENT PRODUCTS
# | Commodity | Product | Country/Location | Business Unit | Business Unit  Contact | Process Manager | Responsibility | 2000-12-08 00:00:00 | 2000-12-17 00:00:00 | Scheduled for | Comments
 | Gas |  | US | EPG | [NAME] | Savita Puthigai | Legal and Commercial | [NAME] | [NAME] | 2000-10-01 00:00:00 | 08/23 Working on descriptions and GTC. 8/31 Product Descriptions and Legal being reviewed. "Chinese Wall" type concerns being reviewed by Legal. 9/07 Reviewing issues related to GPG and ENA  information (comply with regulation) 9/14 need to segregate  marketing affiliates using Chinese Walls- Preparing list of Proprietary system  issues; may include HPL products. 9/22 Meeting held with PCH Managers-Torrey to follow up with Scott Mills-Sitara issues, Torrey will write questions to IT regarding segregation of mktg affiliates. 12/22 Product not viable at this time.
Spreadsheet: 003abf0b-0b5d-4729-8dfd-94dc2ab696a1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Phytoplankton Index for 2009
Estuary | 2009
Mid Bay | 78.56062361
Lower Bay | 59.6489886
Overall Bay | 48.98384766
Potomac River | 43.11072558
Rappahannock River | 37.724124
Choptank River | 21.68512163
[NAME] | 21.61028659
[NAME] | 20.82422581
Lower Western Shore (MD) | 16.66666667
Upper Eastern Shore | 15.6573583
Patapsco and Back Rivers | 10
Patuxent River | 9.650630654
York River | 7.320970577
Lower Eastern Shore (Tangier)
Upper Western Shore
[NAME] | 0
Spreadsheet: 820509d1678134977-count-unique-process-not-per-employee-book1
Sheet: TN (2)

Title Plant Expansion Status
State: | Tennessee
Counties | Generation | Data Set | Source/Data Types | N/A | Patil |  |  |  | Ravi |  |  |  | Development |  |  | Total
 |  |  |  | Not Started | Analysis | Spec Sheet Completed/ Approved | Development | Verification | Analysis | Spec Sheet Completed/ Approved | Development | Verification | Harvest  (via Automate) | Development | Ingestion into  the Vault
Column1 | Column3 | Column2 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column162
[NAME] | History | Recorder |  |  |  |  |  |  | l |  |  |  |  | l |  | 2
[NAME] | Go Forward | Recorder |  |  | l | l | l | l | l |  |  |  |  | l |  | 5
Cheatham | History | Recorder |  |  |  |  |  |  | l |  |  |  |  | l | l | 3
Cheatham | Go Forward | Recorder |  |  | l | l | l | l | l | l | l | l | l | l | l | 7
Spreadsheet: 868241d1714987931-lookup-table-with-lookup-reference-with-comma-separated-values-please-help
Sheet: Sheet1

References Table |  |  |  |  | Desired Table
No. | Service Tag | Prices |  |  | Services Tag | Prices
1 | ABC123,UK90,PFX343 | 47.99 |  | example | PFX343 | 47.99
2 | XXC475,OPR767,AVX314,ANX715 | 18 |  |  | PUP117 | 20.45
3 | PTY370 | 1.79 |  |  | PTY370 | 1.79
4 | PUP117,PIP190 | 20.45 |  |  | … | …
5 | A7XYU | 19.9 |  |  | … | …
 |  |  |  |  | … | …
 |  |  |  |  | … | …
 |  |  |  |  | … | …
 |  |  |  |  | … | …
 |  |  |  |  | … | …
 |  |  |  |  | … | …
Spreadsheet: 702610d1604428542-conditional-formatting-not-linking-correctly-conditional-formatting-not-working
Sheet: TICKETS

 |  |  |  |  | 2020-01-01 00:00:00
 |  | Month |  |  | Assigned | Worked | Carried over | Assigned | Worked | Carried over | Assigned | Worked | Carried over | Assigned | Worked | Carried over
 |  | 2020-01-01 00:00:00
 |  | 2020-01-01 00:00:00
 |  | 2020-01-01 00:00:00
 |  | 2020-02-01 00:00:00
 |  | 2020-02-01 00:00:00
 |  | 2020-02-01 00:00:00
 |  | 2020-03-01 00:00:00
 |  | 2020-03-01 00:00:00
 |  | 2020-03-01 00:00:00
 |  | 2020-04-01 00:00:00
 |  | 2020-04-01 00:00:00
 |  | 2020-04-01 00:00:00
 |  | 2020-05-01 00:00:00
 |  | 2020-05-01 00:00:00
 |  |  |  | Conditional Formatting of F3 - Q16 should create the above.
 |  |  |  | 1. Carried Over columns
 |  |  |  | C/F should fill any cells green where the Date in Col C is earlier than the date in Row 1.
 |  |  |  | So in Feb (Col H) only Jan Rows 3 - 5 should be green. In March (Col K) Feb rows 6 - 8 should also be green, and so on.
 |  |  |  | Cells where the  date in row 1  is later or equal to the date in Col C need to be filled brown.
 |  |  |  | 2. Assigned and worked.
 |  |  |  | C/F should fill any cells where the Date in Col C is later than the date in Row 1
 |  |  |  | So in Feb (Cols I & J) rows 9 - 16 should be filled as they relate to later months, but in March (Cols L & M) only rows 12 - 16 should be filled, and so on.
Spreadsheet: 24bc7cb1-c18e-43fe-a8b4-8c6e1bb88fe1
Sheet: Sheet1

Force calculator |  |  | K value table
Mass (kg) | 100 |  | Rope impact force (kN) | K value
Distance fallen (m) | 1 |  | 7 | 13700
Length of rope deployed (m) | 5 |  | 7.5 | 16000
Fall factor |  |  | 8 | 18500
K value | 18500 |  | 8.5 | 21200
 |  |  | 9 | 24100
Force on climber (kN) |  |  | 9.5 | 27100
Force on protection (kN) |  |  | 10 | 30300
Force on belayer (kN)
Equations
Fall factor = distance fallen/length of rope deployed
Force on climber = mg + [(mg)2 + 2Kmg(h/l)]1/2
Force on protection = 1.6 force on climber
Force on belayer = 0.6 force on climber
Spreadsheet: 60264d1260831056-auto-link-to-another-worksheet-when-text-is-entered-in-cell-adhoc-metrics-sample-1
Sheet: FY2010

 | Directions:
Date Entered | Master Document # | Award # | Award Date | Contracting Officer | Protests | UCAs | IUID/RFID Clauses | Ratifications        (by $) | [NAME] | Congressionals
TOTALS |  |  | Quarter 1 2010 |  | 1 | 0 | 0 | 0 | 0 | 0
 |  |  | Quarter 2 2010 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Quarter 3 2010 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Quarter 4 2010 |  | 0 | 0 | 0 | 0 | 0 | 0
2008-10-04 00:00:00 | W813LT62093582 | W911QX-09-C-0023 | 9-31-2009 | Kathy |  |  | 1 | 5452421
2008-10-04 00:00:00 | W813LT92323679 | W911QX-09-C-0078 | 2008-10-01 00:00:00 | Kathy | 1 | 1 |  | 15000
2008-10-09 00:00:00 | W813LT92326469 | W911QX-09-C-0075 | 2008-10-02 00:00:00 | [NAME] |  | 1 |  | 12892.23 | 1
2008-11-24 00:00:00 | W71B7J02345236 | W911QX-09-C-0089 | 2008-11-21 00:00:00 | [NAME] |  | ddd |  |  |  | 1
2008-12-02 00:00:00 | W813LT94323469 | W911QX-09-C-0045 | 2008-11-23 00:00:00 | [NAME] |  | 1
2008-12-26 00:00:00 | [NAME] | W911QX-09-C-0057 | 2008-12-14 00:00:00 | Christi |  |  | 1 | 2148.25
2009-01-02 00:00:00 | W813LT60895213 | W911QX-09-C-0091 | 2008-12-26 00:00:00 | [NAME] | 1 |  |  | 21
2009-01-25 00:00:00 | W813LT93857293 | W911QX-09-C-0019 | 2009-01-22 00:00:00 | Kathy |  |  | 1
2009-02-11 00:00:00 | W813LT60984726 | W911QX-09-C-0024 | 2009-02-01 00:00:00 | Christi |  |  |  | 42000 |  | 1
2009-02-19 00:00:00 | W813LT60895343 | W911QX-09-C-0122 | 2009-02-11 00:00:00 | Christi | 1
2009-03-21 00:00:00 | W71B7J23563477 | W911QX-09-C-0011 | 2009-03-18 00:00:00 | [NAME] |  | 1
2009-04-11 00:00:00 | W813LT02835782 | W911QX-09-C-0045 | 2009-04-01 00:00:00 | Kathy |  |  |  |  | 1
2009-04-23 00:00:00 | W71B7J39582038 | W911QX-09-C-0112 | 2009-04-15 00:00:00 | Christi |  | 1 |  |  |  | 1
2009-05-02 00:00:00 | [NAME] | W911QX-09-C-0219 | 2009-04-28 00:00:00 | Christi |  |  |  |  | 1
2009-12-09 00:00:00 | W71B7J43234480 | W911QX-10-C-0019 | 2009-09-07 00:00:00 | [NAME] | 1