tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 159808d1338850667-adding-movement-arrows-to-excel-leaderboard-team-leaderboard
Sheet: Sheet1

 | Achievment |  |  |  | Achievment |  |  |  |  | Achievement
 | Catergory A | 2012 YTD | April |  | Rank | Catergory A | April |  |  | Rank | Dealership | 2012 YTD | Previous
 | Team 1 | 0.36 | 0.57 |  | 1 |  |  |  |  | 1
 | Team 2 | 0.31 | 0.29 |  | 2 |  |  |  |  | 2
 | Team 3 | 0.28 | 0.32 |  | 3 |  |  |  |  | 3
 | Team 4 | 0.16 | 0.29 |  | 4 |  |  |  |  | 4
 | Team 5 | 0.19 | 0.2 |  | 5 |  |  |  |  | 5
 | Team 6 | 0.35 | 0.53 |  | 6 |  |  |  |  | 6
 | Team 7 | 0.5 | 0.25 |  | 7 |  |  |  |  | 7
Spreadsheet: 7e788528-1369-4ae4-8296-b06f33350f11
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
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 82. Value of Building Approved, Chain Volume Measures, Original - South Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Total value of building jobs ;  Chain Volume Measures ;  South Australia ;  Houses ;  New ; |  |  | Original | A590507C | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  South Australia ;  Total Other Residential ;  New ; |  |  | Original | A590508F | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  South Australia ;  [NAME] ;  New ; |  |  | Original | A590509J | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  South Australia ;  [NAME] ;  Alterations and additions including conversions ; |  |  | Original | A590510T | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  South Australia ;  [NAME] ;  Total Work ; |  |  | Original | A590511V | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  South Australia ;  [NAME]-residential ;  Total Work ; |  |  | Original | A590512W | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  South Australia ;  Total (Type of Building) ;  Total Work ; |  |  | Original | A590513X | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: 798135d1664319915-conditional-formatting-with-table-and-validation-rogrand-visp-projects
Sheet: Helper

Completed Yes/No | Markets | Analyst | Type | Yes / No
Pending | Broward | Marcus | Resident | YES
Completed | Dade | [NAME] | Provider | No
 | Palm Beach | Pending | Mid-Level | N/A
 | Treasure Cost | [NAME] | Add / Move
 |  | Flor
 |  | Gregory
yes | yes
yes | yes
no | yes
Spreadsheet: a5af4ae9-6ef4-412e-9159-e3f25a03620a
Sheet: proposta sconto 20%

TARIFFARIO AL PUBBLICO  -  AQUAGRANDA  inverno 2010/1011
Ingressi | SPORT | LUDICA | THERMARIUM | SPORT+LUDICA | THERMARIUM+LUDICA | SPORT+LUDICA+THERMARIUM
ADULTO | 10 | 20 | 20 | 29 | 29 | 39
BAMBINO (<12anni) | 5 | 8 | NO | 10 | NO | NO
Speciale operatori di [NAME]: sconto del 20% sugli ingressi
Agli operatori è data la possibilità di ritirare c/o Aquagranda buoni ticket ingresso nelle diverse [NAME] le [NAME] in quantità multiple di 20.
Al momento del ritiro non si dovrà [NAME]; si dovrà solo controfirmare l'assegnazione dei buoni ticket, fornire i dati per la fatturazione  e comunicare
gli estremi [NAME] (n. IBAN) per l'addebito in c/c
L'addebito [NAME] mensilmente da  [NAME] secondo l'effettivo consumo/accesso del cliente,  [NAME] dello sconto del 20%.
Vantaggi: | L'operatore non dovrà anticipare [NAME] denaro
 | I buoni ticket ingresso saranno conteggiati a consumo e quelli non utilizzati dovranno essere resi a scadenza validità
 | Possibilità di trattenere un margine di utile massimo del 20%
 | Servizio aggiuntivo alla propria offerta turistica
Svantaggi: | nessuno
vincoli: | divieto di vendita a tariffe superiori [NAME]
 | [NAME] buoni ticket ingresso in quantità multiple di 20 c/o Aquagranda
 | riconsegna dei ticket alla scadenza del 30/04/2011: addebito della somma
 | corrispondente alla differenza tra i ticket consumati e/o comunque consegnati agli ospiti  e quelli effettivamente resi
Servizi Accessori
CUFFIA vendita | 5 | NO/€     5,00 | NO/€     5,00 | 5 |  | 5
CIABATTE vendita | 5 | 5 | 5 | 5 | 5 | 5
ACCAPPATOIO Nolo | 5 | 5 | 5 | 5 | 5 | NO
CUFFIA+ACCAPPATOIO+CIABATTE Nolo | 8 | 8 | 8 | 8 | 8 | [NAME]
Spreadsheet: 830044d1684664024-help-with-if-calculation-formula-deemed-selling-price-rj
Sheet: Sheet1

 | Kindly ask for help with excel formula to produce the desirwd solution below. The current formular on row 9 is working but if cell [NAME] is blank it is not working.
 |  | Passenger motor [NAME] | Machinery | Curent YR | Asset 1 | Asset 2 | Asset 3
 | Cost | 15000 | 40000 | 15000
 | [NAME] | 10000 |  | 20000
 | Actual selling price | 9000 | 40000 | 9000
 | [NAME] selling price
 | Desired Solution
 |  | Passenger motor [NAME] | Machinery | Curent YR | Asset 1 | Asset 2 | Asset 3
 | Cost | 15000 | 40000 | 15000
 | [NAME] | 10000 |  | 20000
 | Actual selling price | 9000 | 40000 | 9000
 | [NAME] selling price |  | 40000
Spreadsheet: 813335d1673681484-lookup-and-count-values-across-multiple-tables-problem-example
Sheet: Sheet1

 | Group | Person 1 | Person 2 | Person 3 | Person 4 | Person 5 |  | Group | Characteristic
 | Group A | X |  | X |  |  |  | Group A | C1
 | Group B |  | X | X |  |  |  | Group A | C2
 | Group C |  |  |  | X |  |  | Group A | [NAME]
 |  |  |  |  |  |  |  | Group B | C1
 |  |  |  |  |  |  |  | Group B | C4
 |  |  |  |  |  |  |  | Group C | C2
 |  |  |  |  |  |  |  | Group C | C4
 |  |  |  |  |  |  |  | Group C | C5
 | Correct Output:
 | Characteristic | Person 1 | Person 2 | Person 3 | Person 4 | Person 5 |  | Table2.Characteristic | Person 1 | Person 2 | Person 3 | Person 4 | Person 5
 | C1 | 1 | 1 | 2 |  |  |  | C1 | 1 | 1 | 2 | 0 | 0
 | C2 | 1 |  | 1 | 1 |  |  | C2 | 1 | 0 | 1 | 1 | 0
 | [NAME] | 1 |  | 1 |  |  |  | [NAME] | 1 | 0 | 1 | 0 | 0
 | C4 |  | 1 | 1 | 1 |  |  | C4 | 0 | 1 | 1 | 1 | 0
 | C5 |  |  |  | 1 |  |  | C5 | 0 | 0 | 0 | 1 | 0
 | C6
Spreadsheet: 152545d1335433138-auto-populate-randomly-from-list-of-names-to-specific-location-on-another-worksheet-wed-game-scores
Sheet: PLAYER LIST

Player list | Rand Number | Rank | Player vs Player
A | 0.8856244517601819 | 22 | C
B | 0.5217818325182552 | 14 | V
C | 0.04450574910843397 | 1 | K
D | 0.9125591586066916 | 23 | M
E | 0.1481433975399021 | 5 | E
F | 0.3976173151739918 | 11 | L
G | 0.4702506440695698 | 12 | Q
H | 0.3420182727774884 | 9 | O
I | 0.5412585278177594 | 16 | H
J | 0.8348821246285515 | 21 | W
K | 0.05757701287637784 | 3 | F
L | 0.1664750519832056 | 6 | G
M | 0.1289195492246293 | 4 | N
N | 0.5205696228252751 | 13 | B
O | 0.3358162984564972 | 8 | T
P | 0.9322218891028923 | 24 | I
Q | 0.22765189607369 | 7 | R
R | 0.5552230572888694 | 17 | U
S | 0.9893460229120599 | 26 | Z
T | 0.5382289480892984 | 15 | Y
U | 0.655062209477181 | 18 | J
V | 0.04638902458952587 | 2 | A
W | 0.3818301261301151 | 10 | D
X | 0.9801335685173311 | 25 | P
Y | 0.708251728262862 | 20 | X
Z | 0.6903835620346546 | 19 | S
Spreadsheet: 117541d1312854791-excel-2007-convert-sales-into-a-currency-corresponding-from-a-drop-down-test-20drop-20down-20currency-1-
Sheet: Sheet1

Display currency: |  | EUR | 1
EUR |  | USD | 0.7
 |  | CAD | 0.9889
 |  | [NAME] | 12.1409
Product | Number | Currency | Exchange rate | Price in selected currency | Qty | Sales
Lamp | 111 | EUR |  | 20 | 10
Bulb | 222 | EUR |  | 3 | 20
Shelve | 333 | USD |  | 50 | 10
Spreadsheet: 108784d1305757024-map-graph-sales_map
Sheet: Sheet1

Branch | SR Sales
[NAME] | 7578.4
Vancouver | 15048
[NAME] | 12004
Dallas | 9893.5
Ottawa | 3208.25
Dallas | 16780
Portland | 11152.66
Dallas | 7899
Houston | 12559.28
Washington DC | 12320
Birmingham | 7696.25
New Orleans | 12475.45
Louisville | 7166
Los Angeles | 9410
Saskatoon | 6887.05
San Antonio | 23853.31
Houston | 12744.21
Shreveport | 17199.39
Orlando | 11436
Edmonton | 13032
San Francisco | 8500.25
Toronto | 9105
Tampa | 10435.91
Concord | 7984
Calgary | 11169
Wichita | 11624.11
San Francisco | 9304.25
Montreal | 14013.25
Miami | 10597.51
San Antonio | 9853.78
New York | 9402
Calgary | 9611
Birmingham | 7652.32
Edmonton | 20004.5
Miami | 8077.25
Memphis | 7803.4
Louisville | 9085.23
Philadelphia | 7293.509999999999
Edmonton | 8984.5
Albuquerque | 14954.05
Quebec City | 12396.95
Atlanta | 8600.5
Calgary | 16317
Vancouver | 31732
Oklahoma City | 7678
Pittsburgh | 0
Houston | 8226.54
Pittsburgh | 10575
Charleston | 10119.8
Oklahoma City | 7778
Memphis | 10483
[NAME] | 7487
Spreadsheet: 472473d1469614649-how-do-i-display-lookup-for-multiple-data-address-mix
Sheet: ADDRESS

GROUP NO | CUSTOMER ADDRESS |  |  |  | OFFICE ADDRESS
7010/27 | AAA BBB CCC |  |  |  | APPLE BANANA | 0 |  |  |  | 1
7010/27 | DDD EEE FFF |  |  |  | ROSE FLOWER | 0 |  |  |  | 1
7010/27 | [NAME] |  |  |  | IRON MAN | 0 |  |  |  | 1
7010/29 | LOVE IS TRUE |  |  |  | TITANIC | 0 |  |  |  | 1
7010/29 | LOVE IS GOD |  |  |  | GOD ZILLA | 0 |  |  |  | 1
7010/29 | BIRDS CUTE |  |  |  | ANIMALS CUTE
7010/29 | LOVE IS PAIN |  |  |  | LOVELY MOTHER | 0 |  |  |  | 1
7010/35 | I LOVE YOU |  |  |  | I LOVE FATHER | 0 |  |  |  | 1
7010/35 | I WANT YOU |  |  |  | I LOVE TEACHER | 0 |  |  |  | 1
7010/35 | I MISS YOU |  |  |  | I MISS MY NEPHEW | 0 |  |  |  | 1
7011/2 | I NEED YOUR HELP |  |  |  | I WANT DRINK | 0 |  |  |  | 1
7011/2 | I WANT LEARN EXCEL |  |  |  | I WANT SLEEP | 0 |  |  |  | 1
Spreadsheet: 778439d1651067323-combining-index-and-aggregate-for-two-different-sources-example-workbook
Sheet: Tab 1

Employee Number | Date | Blank Column | Reference | Currency | Indicator | Percentage 2 |  |  | [NAME] |  |  | 2022-02-28 00:00:00
Sub Ref | Sub Ref | Sub Ref | Sub Ref | Sub Ref | Sub Ref | Sub Ref |  |  | Employee |  |  | Date |  |  | Percentage
Employee 1 | 2023-12-31 00:00:00 |  | FL5 | USD | X | 15
Employee 2 | 2023-12-31 00:00:00 |  | FL5 | USD | X | 15
Employee 3 | 2023-12-31 00:00:00 |  | FL5 | USD | X | 11
Employee 4 | 2023-12-31 00:00:00 |  | FL5 | USD | X | 25
Employee 5 | 2023-12-31 00:00:00 |  | FL5 | USD | X | 11
Employee 6 | 2023-12-31 00:00:00 |  | FL5 | USD | X | 15
Employee 7 | 2023-12-31 00:00:00 |  | FL6 | USD | X | 14
Employee 8 | 2023-12-31 00:00:00 |  | FL5 | USD | X | 17
Employee 9 | 2022-02-28 00:00:00 |  | FL5 | USD | X | 15
Employee 10 | 2023-12-31 00:00:00 |  | FL5 | USD | X | 15
Employee 11 | 2022-02-28 00:00:00 |  | FL5 | USD | X | 15
Employee 12 | 2023-12-31 00:00:00 |  | FL5 | USD | X | 11
Employee 13 | 2023-12-31 00:00:00 |  | FL5 | USD | X | 15 |  |  | [NAME]
Employee 13 | 2023-12-31 00:00:00 |  | FL6 | USD | X | 16 |  |  | Employee |  |  | Date |  |  | Percentage
 |  |  |  |  |  |  |  |  | Combined (using numbering method)
 |  |  |  |  |  |  |  | Numbering | Employee |  |  | Date |  |  | Percentage
Spreadsheet: 886934d1737038457-i-want-to-widen-cells-down-the-line-without-widening-or-moving-cells-above-those-cells-laundry-detergent-tracker
Sheet: Sheet1

 | Month/Year |  | Starting Quantity (1 = 10l) - Store Room |  |  |  |  |  | Starting Quantity (1 = 10l) - Laundry Room
 | 2025-01-01 00:00:00 |  | Detergent | Destainer | [NAME] |  |  |  | Detergent | Destainer | [NAME]
 |  |  | 3 | 2 | 3 |  |  |  | 1 | 1 | 1
 | Date | QTY Ordered (1 = 10l) |  |  |  | Delivered QTY (1 = 10l) |  |  |  | QTY Taken to LR (1 = 10l) |  |  |  |  | Remaining QTY (1 = 10l) |  |  |  |  | Signature
 |  | Detergent | Destainer | [NAME] |  | Detergent | Destainer | [NAME] |  | Detergent | Destainer | [NAME] |  |  | Detergent | Destainer | [NAME]
 | 1st | 5 | 2 | 1
 | 2nd |  |  |  |  |  |  |  |  | 1 | 0 | 0 |  |  | 2 | 2 | 3
 | 3rd
 | 4th |  |  |  |  | 5 | 2 | 1 |  |  |  |  |  |  | 7 | 4 | 4
 | 5th
 | 6th
 | 7th
 | 8th
 | 9th
 | 10th
 | 11th
 | 12th
 | 13th
 | 14th
 | 15th
 | 16th
 | 17th
 | 18th
 | 19th
 | 20th
 | 21st
 | 22nd
 | 23rd
 | 24th
 | 25th
 | 26th
 | 27th
 | 28th
 | 29th
 | 30th
 | 31st
Spreadsheet: 129770d1321881423-calculating-time-forum
Sheet: Sheet1

 | In | [NAME] | Lunch End | Out | Regular | Over Time | Daily Total
Monday | 07:25:00 | 10:00:00 | 10:30:00 | 17:00:00
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Weekly Total
 | Week Beginning 11-21-2011
 | One more stipulation...In column F I only need that to show "regular time" worked, so the basic 8 hours...in Column G, I need that to display everything over 8 hours, or the "overtime" worked for that day. What formula would allow those stipulations to take place?
Spreadsheet: 677230d1589253171-display-different-types-of-error-if-accurate-results-not-found-on-multiple-match-demo-error-displaying
Sheet: DO

Party |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SaleOrderNo |  | Item | Item Name | [NAME] | Gross Qty |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Merged |  |  |  |  | Displaying Error | SO | Crossed | Party | Item | [NAME]
360236 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TA/2256 |  | 20002 | PLAIN TAPE | 72*60 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >> want to display this kind of error if AY does not match with BD column of SO worksheet
360261 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HA/5949 |  | 20031 | [NAME] | FRESH | 56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >> want to display this kind of error if AY does not match with BD column of SO worksheet
360634 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HA/6039 |  | 20027 | FABRIC |  | 1.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >> want to display this kind of error if AY does not match with BD column of SO worksheet
360242 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HA/6203 |  | 20032 | REPRO SHEET |  | 3.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >> want to display this kind of error if AY does not match with BD column of SO worksheet
361329 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HA/6213 |  | 20070 | HD SHEET |  | 95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >> want to display this kind of error if AY does not match with BD column of SO worksheet
361341 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HA/6256 |  | 20052 | [NAME] SALES |  | 81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >> want to display this kind of error if AY does not match with BD column of SO worksheet
360264 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HA/6703 |  | 20062 | LD SHEET | POLY BAG 10X11. SUNSARI | 9446 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >> want to display this kind of error if AY does not match with BD column of SO worksheet
Spreadsheet: 25703d1217214536-changing-formula-color-not-cell-color-in-formula-bar-exampledate
Sheet: Sheet1

Customer Name | Customer Last Name | Company Name | Region | Source Code | U$S | Creation date |  |  | Summary
Juan | [NAME] | ITAU | Sur | Q1_breakfast_hilton | 11000 | 2008-07-14 00:00:00
Alberto | [NAME] | BBCS | Sur | Q1_breakfast_hilton | 90000 | 2008-07-18 00:00:00 |  |  | Period | U$S | # | Average
Jaime | Rotundo | Makro | Sur | Q1_breakfast_hilton | 17800 | 2008-07-13 00:00:00 |  |  | Creation Period
Rodrigo | Schoum | Bansud | Sur | Q4_LAUNCH_11 | 12000 | 2008-07-07 00:00:00 |  |  | 7 days ago | 0 | 0
Jorge | Bazan | Bansud | Sur | Q4_LAUNCH_11 | 50000 | 2008-07-08 00:00:00 |  |  | 15 days ago | 101000 | 2 | 50500
Belen | Bapoz | [NAME] | Sur | Q2_COCKTAIL_BO | 2300 | 2008-06-30 00:00:00 |  |  | 30 days ago | 183250 | 7 | 26178.57142857143
Josefa | [NAME] | Ainco | Sur | Q2_COCKTAIL_BO | 150 | 2008-06-29 00:00:00 |  |  | YTD | 326250 | 8 | 40781.25
Marian | Jones | INCA | Sur | Q4_LAUNCH_11 | 143000 | 2008-06-28 00:00:00
Spreadsheet: 102964d1300828710-return-blank-if-cell-is-blank-or-contains-formula-2011-neem-data
Sheet: Valid Data

Sample Type | Location | Area | Personnel | Sites
Air | Clean Room | Bins | J Smith | H51S | Surface | Clean Room | Hood
Surface | Crimp Room | Door | J Doe | H52S | Surface | Clean Room | Hood
 | Gown Room | Floors | J Jane | H53S | Surface | Clean Room | Hood
 | Prep Room | Hood | N/A | H54S | Surface | Clean Room | Hood
 |  | Pass-Thrus |  | [NAME] | Surface | Clean Room | Hood
 |  | Room |  | [NAME] | Surface | Clean Room | Hood Antechamber
 |  | Tables |  | 2ACS | Surface | Clean Room | Hood Antechamber
 |  | Vault |  | 3ACS | Surface | Clean Room | Hood Antechamber
 |  | Walls |  | 4ACS | Surface | Clean Room | Hood Antechamber
 |  | Personnel |  | 5ACS | Surface | Clean Room | Hood Antechamber
 |  |  |  | 6ACS | Surface | Clean Room | Hood Antechamber
 |  |  |  | 7ACS | Surface | Clean Room | Hood Antechamber
 |  |  |  | ChemoS | Surface | Clean Room | Chemo Hood
 |  |  |  | HorizS | Surface | Clean Room | [NAME]
 |  |  |  | H50TS | Surface | Clean Room | Table
 |  |  |  | H51TS | Surface | Clean Room | Table
 |  |  |  | H52TS | Surface | Clean Room | Table
 |  |  |  | H53TS | Surface | Clean Room | Table
 |  |  |  | H54TS | Surface | Clean Room | Table
 |  |  |  | 1PTS | Surface | Clean Room | Pass-Thru
 |  |  |  | 2PTS | Surface | Clean Room | Pass-Thru
 |  |  |  | 3PTS | Surface | Clean Room | Pass-Thru
 |  |  |  | SinkS | Surface | Crimp Room | Sink
 |  |  |  | CrimpS | Surface | Crimp Room | Bench
 |  |  |  | 1RBS | Surface | Crimp Room | [NAME]
 |  |  |  | 2RBS | Surface | Crimp Room | [NAME]
 |  |  |  | [NAME] | Surface | Gown Room | Near Hall
 |  |  |  | 2GRFS | Surface | Gown Room | Near Clean Room
 |  |  |  | 1PFS | Surface | Prep Room | Near Incubator
 |  |  |  | 2PFS | Surface | Prep Room | Near Warehouse
 |  |  |  | 1FLRS | Surface | Clean Room | Floor
 |  |  |  | 2FLRS | Surface | Clean Room | Floor
 |  |  |  | 3FLRS | Surface | Clean Room | Floor
 |  |  |  | 4FLRS | Surface | Clean Room | Floor
 |  |  |  | 5FLRS | Surface | Clean Room | Floor
 |  |  |  | 6FLRS | Surface | Clean Room | Floor
 |  |  |  | 1IPAS | Surface | Clean Room | IPA
 |  |  |  | 2IPAS | Surface | Clean Room | IPA
 |  |  |  | H51A | Air | Clean Room | Hood
 |  |  |  | H52A | Air | Clean Room | Hood
 |  |  |  | H53A | Air | Clean Room | Hood
 |  |  |  | H54A | Air | Clean Room | Hood
 |  |  |  | [NAME] | Air | Clean Room | Hood
 |  |  |  | ChemoA | Air | Clean Room | Chemo Hood
 |  |  |  | HorizA | Air | Clean Room | [NAME]
 |  |  |  | H51TA | Air | Clean Room | Table
 |  |  |  | H52TA | Air | Clean Room | Table
 |  |  |  | H53TA | Air | Clean Room | Table
 |  |  |  | GownroomA | Air | Gown Room | Room
 |  |  |  | SinkA | Air | Crimp Room | Sink
 |  |  |  | [NAME] | Air | Crimp Room | Room
 |  |  |  | MiddleroomA | Air | Clean Room | Room
 |  |  |  | NRNSA | Air | Clean Room | NRNSA
 |  |  |  | 1PrepA | Air | Prep Room | Room
 |  |  |  | 2PrepA | Air | Prep Room | Room
Spreadsheet: 42627d1241167844-automatically-transfer-information-from-a-raw-data-sheet-to-report-sheets-sample-report
Sheet: Report

 |  |  |  |  |  |  |  |  |  |  | Type | Price | Price -VAT
 |  |  |  |  |  |  |  |  |  |  | Premium Games | 4.5 | 3.829787234042553
 |  |  |  |  |  |  |  |  |  |  | Ringtones | 3 | 2.553191489361702
 |  |  |  |  |  |  |  |  |  |  | Sound Effects | 1.5 | 1.276595744680851
 |  |  |  |  |  |  |  |  |  |  | Standard Games | 3 | 2.553191489361702
Supplier Monthly Report |  |  |  |  |  |  |  |  |  |  | Wallpaper | 2 | 1.702127659574468
Supplier:
Report Period: | March 2009
[NAME]
 |  |  | Customer Cost |  |  |  | Gross Amount | Net Amount
Date | Downloads | Type | Including VAT |  |  |  | Excluding VAT* | Excluding VAT** |  |  |  | cut | -vat
* | 22 | Ringtones | 66 |  |  |  | 37.92 | 14.01 |  |  |  | 0 | 0 | MCS/MPRS Reductions | 9.9 | 28.02
**
Total | 22 |  | 66 |  |  |  | 37.92 | 14.01 |  |  |  | 0 | 0
 |  |  |  |  |  | Total Net Amount |  | 14.01
* | These are ringtones that attract a 15% reduction for MCS/MPRS Reductions
** | These are ringtones that do not have any reductions for MCS/MPRS as they are original tracks (as represented by the letter T in the MCS/MPRS Code column in Sales Breakdown page)
 |  |  |  |  |  |  |  |  |  |  |  | New Net Amount | 14.01
 |  |  |  |  |  |  |  |  |  |  |  | New Total | 91.5
Including this month's total the cumulative amount we owe you is now |  |  |  |  | 91.5 |  |  |  |  |  |  | Old Cumulative Total | 77.49 | (Manually Change)
Spreadsheet: 85d716c8-93f2-42d4-87d4-945f2a3aa2fb
Sheet: Quality

[NAME] (lvl 1 & 2) | Months
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
The project workbook allows project managers, team members, sponsors, and stakeholders to easily track and monitor project activities. Any of these worksheets can easily be broken out into separate documents.
Severity High
High - Open
High - Closed
High - Total
Severity Medium
Medium - Open
Medium - Closed
Medium - Total
Severity Low
Low - Open
Low - Closed
Low - Total
Total Open
Total Closed
Total Defects
Acceptance Test
Severity High
High - Open
High - Closed
High - Total
Severity Medium
Medium - Open
Medium - Closed
Medium - Total
Severity Low
Low - Open
Low - Closed
Low - Total
Total Open
Total Closed
Total Defects
Spreadsheet: 56573d1256744892-filter-records-based-on-selection-24847373
Sheet: Call Log

Date | Employee Name | Log-In Time | Calls Taken | Not Ready Time
2009-01-10 00:00:00 | [NAME]
2009-01-11 00:00:00 | [NAME] 3
2009-01-12 00:00:00 | [NAME]
2009-01-02 00:00:00 | [NAME] | 08:45:00 | 45 | 02:30:00
2009-01-05 00:00:00 | [NAME] 3 | 08:50:00 | 56 | 02:50:00
2009-01-10 00:00:00 | [NAME] | 09:45:00 | 66 | 03:50:00
Spreadsheet: 697566d1601408421-need-help-with-sumif-and-subtotal-copy-of-grossmargin_quote-log_v2_2019
Sheet: EstTeam

Estimating Team | Total Bids | Total Yes | Total No | Percentage
[NAME]
Roco
[NAME]
[NAME]
Cameron
[NAME]
Travis
Travis (Asphalt)
Estimating Team | Sum of Total Bids | Sum of Total Yes | Sum of Total No | Average of Percentage
[NAME] | 27 | 3 | 16 | 0.1111111111111111
Cameron | 1 | 0 | 0 | 0
[NAME] | 8 | 0 | 2 | 0
[NAME] | 25 | 5 | 17 | 0.2
[NAME] | 19 | 13 | 4 | 0.6842105263157895
Roco | 63 | 14 | 29 | 0.2222222222222222
Travis | 160 | 55 | 94 | 0.34375
Grand Total | 303 | 90 | 162 | 0.2230419799498747
Spreadsheet: 174062d1344904748-dynaimc-sum-range-sample
Sheet: NA

2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | Can not remove | Can not remove | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
5 | 10 | 20 |  |  | 30 | 40 | 50 | 60 | 70 | 500 | 90 | 100 | 110 | 120 | 130 | 140
 |  |  |  |  |  | 660
Spreadsheet: 863745d1711129940-index-match-formula-returning-incorrect-values-cashflow-dj
Sheet: 2404 JTG Live

 | Name of Event | 2404 JTG Live
 | Date of Event | 2024-04-22 00:00:00
 | Job Number | ST369
 |  | Item/Service Bought |  | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC | BACS | CC | ACC
Your Font Colour: | TYLER | Rigging |  | 7450 | 4 | 674 | 555 | 8 | 6884 | 76 | 25 | 88 | 71 | 2367 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 750 | 80
 | LIZ |  |  | 1000
 | HARRY
 | WARREN
Finance Response:
Acknowledged